Baselight
Sign In

Spend Over £25,000 In Office Of Rail And Road

Office of Rail and Road

@ukgov.office_of_rail_and_road_spending_over_25000_dataset

Loading...
Loading...

About this Dataset

Spend Over £25,000 In Office Of Rail And Road

Details of payments in excess of £25,000 which have been made by the Office of Rail and Road (ORR) to its suppliers each month, as part of the Government's commitment to transparency in expenditure.
Publisher name: Office of Rail and Road
Last updated: 2025-05-09T04:05:37Z

Tables

Expenditure In July 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_july_2022
  • 18.36 KB
  • 7 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_july_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In July 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_july_2023
  • 20.16 KB
  • 10 rows
  • 25 columns
Loading... 

CREATE TABLE expenditure_in_july_2023 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR
);

Expenditure In July 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_july_2024
  • 18.18 KB
  • 9 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_july_2024 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In June 2017

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_june_2017
  • 16.17 KB
  • 8 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_june_2017 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" DOUBLE,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" VARCHAR,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In June 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_june_2020
  • 16.45 KB
  • 13 rows
  • 23 columns
Loading... 

CREATE TABLE expenditure_in_june_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" DOUBLE,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "journal_no" DOUBLE,
  "allocation_date" TIMESTAMP,
  "account_code" VARCHAR,
  "address_code" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR
);

Expenditure In June 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_june_2021
  • 11.56 KB
  • 11 rows
  • 19 columns
Loading... 

CREATE TABLE expenditure_in_june_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" VARCHAR,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" VARCHAR,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" VARCHAR,
  "account_code" VARCHAR,
  "address_code" VARCHAR
);

Expenditure In June 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_june_2022
  • 17.57 KB
  • 7 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_june_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" BIGINT,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In June 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_june_2023
  • 18.22 KB
  • 7 rows
  • 25 columns
Loading... 

CREATE TABLE expenditure_in_june_2023 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" DOUBLE,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" DOUBLE,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR
);

Expenditure In June 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_june_2024
  • 17.33 KB
  • 4 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_june_2024 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In March 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_march_2021
  • 17.35 KB
  • 8 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_march_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" VARCHAR,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In March 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_march_2022
  • 20.99 KB
  • 25 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_march_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In March 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_march_2023
  • 20.47 KB
  • 21 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_march_2023 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In March 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_march_2024
  • 19.88 KB
  • 13 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_march_2024 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In March 2025

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_march_2025
  • 17.91 KB
  • 8 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_march_2025 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" BIGINT,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In May 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_may_2021
  • 15.88 KB
  • 11 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_may_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" DOUBLE,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" VARCHAR,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In May 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_may_2022
  • 16.78 KB
  • 24 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_may_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" DOUBLE,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" DOUBLE,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In May 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_may_2023
  • 16.91 KB
  • 13 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_may_2023 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" DOUBLE,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" DOUBLE,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In May 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_may_2024
  • 17.12 KB
  • 7 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_may_2024 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In November 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_november_2020
  • 17.85 KB
  • 3 rows
  • 25 columns
Loading... 

CREATE TABLE expenditure_in_november_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" VARCHAR,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR
);

Expenditure In November 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_november_2021
  • 16.91 KB
  • 4 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_november_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In November 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_november_2022
  • 17.67 KB
  • 8 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_november_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In November 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_november_2023
  • 17.25 KB
  • 6 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_november_2023 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In November 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_november_2024
  • 17.68 KB
  • 4 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_november_2024 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In October 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_october_2020
  • 12.08 KB
  • 4 rows
  • 20 columns
Loading... 

CREATE TABLE expenditure_in_october_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" VARCHAR,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" VARCHAR,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "journal_no" VARCHAR,
  "allocation_date" VARCHAR,
  "account_code" VARCHAR,
  "address_code" VARCHAR
);

Expenditure In October 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_october_2021
  • 17.78 KB
  • 7 rows
  • 22 columns
Loading... 

CREATE TABLE expenditure_in_october_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_code" VARCHAR,
  "expense_type" VARCHAR,
  "cost_centre" BIGINT,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" TIMESTAMP,
  "account_code" BIGINT,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Share link

Anyone who has the link will be able to view this.