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 October 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_october_2022

18.03 KB
8 rows
22 columns


CREATE TABLE expenditure_in_october_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 October 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_october_2023

16.21 KB
8 rows
22 columns


CREATE TABLE expenditure_in_october_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 October 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_october_2024

15.83 KB
1 row
22 columns


CREATE TABLE expenditure_in_october_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" BIGINT,
  "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 September 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_september_2020

18.03 KB
4 rows
23 columns


CREATE TABLE expenditure_in_september_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,
  "journal_no" BIGINT,
  "allocation_date" TIMESTAMP,
  "account_code" VARCHAR,
  "address_code" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR
);

Expenditure In September 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_september_2021

16.31 KB
5 rows
22 columns


CREATE TABLE expenditure_in_september_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" DOUBLE,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In September 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_september_2022

15.99 KB
5 rows
22 columns


CREATE TABLE expenditure_in_september_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 September 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_september_2023

17.85 KB
8 rows
22 columns


CREATE TABLE expenditure_in_september_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 September 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_september_2024

16.51 KB
9 rows
22 columns


CREATE TABLE expenditure_in_september_2024 (
  "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" TIMESTAMP,
  "expenditure_type" DOUBLE,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "allocation_date" VARCHAR,
  "account_code" DOUBLE,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);