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.46 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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In October 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_october_2023

16.6 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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In October 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_october_2024

16.21 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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In September 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_september_2020

18.46 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  -- Journal No.,
  "allocation_date" TIMESTAMP,
  "account_code" VARCHAR,
  "address_code" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Expenditure In September 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_september_2021

16.7 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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In September 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_september_2022

16.37 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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In September 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_september_2023

18.28 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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In September 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_september_2024

16.91 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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);