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 April 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_april_2021
  • 18.74 kB
  • 11 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_april_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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In April 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_april_2022
  • 20.68 kB
  • 25 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_april_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 April 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_april_2023
  • 18.45 kB
  • 21 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_april_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 April 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_april_2024
  • 18.81 kB
  • 10 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_april_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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In August 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_august_2020
  • 17.79 kB
  • 4 rows
  • 23 columns
Loading... 
CREATE TABLE expenditure_in_august_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 August 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_august_2021
  • 17.65 kB
  • 5 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_august_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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In August 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_august_2022
  • 17.62 kB
  • 5 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_august_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 August 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_august_2023
  • 16.86 kB
  • 10 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_august_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 August 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_august_2024
  • 18.54 kB
  • 9 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_august_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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In December 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_december_2020
  • 18.41 kB
  • 32 rows
  • 25 columns
Loading... 
CREATE TABLE expenditure_in_december_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,
  "allocation_date" TIMESTAMP,
  "account_code" VARCHAR,
  "address_code" VARCHAR,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24
);

Expenditure In December 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_december_2021
  • 17.57 kB
  • 5 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_december_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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In December 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_december_2022
  • 17.34 kB
  • 8 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_december_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 December 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_december_2023
  • 18.37 kB
  • 8 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_december_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 December 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_december_2024
  • 17.94 kB
  • 9 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_december_2024 (
  "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" VARCHAR,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In February 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_february_2021
  • 17.55 kB
  • 5 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_february_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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In February 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_february_2022
  • 18.35 kB
  • 7 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_february_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 February 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_february_2024
  • 16.87 kB
  • 7 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_february_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" 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 February 2025

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_february_2025
  • 16.99 kB
  • 9 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_february_2025 (
  "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 January 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_january_2021
  • 18.34 kB
  • 6 rows
  • 25 columns
Loading... 
CREATE TABLE expenditure_in_january_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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24
);

Expenditure In January 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_january_2022
  • 17.54 kB
  • 6 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_january_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: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

Expenditure In January 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_january_2023
  • 16.98 kB
  • 7 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_january_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 January 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_january_2024
  • 17.77 kB
  • 8 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_january_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" 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 January 2025

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_january_2025
  • 19.23 kB
  • 9 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_january_2025 (
  "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 July 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_july_2020
  • 17.96 kB
  • 4 rows
  • 23 columns
Loading... 
CREATE TABLE expenditure_in_july_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" BIGINT,
  "amount_in_sterling" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "expenditure_type" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "journal_no" VARCHAR  -- 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 July 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_july_2021
  • 16.51 kB
  • 2 rows
  • 22 columns
Loading... 
CREATE TABLE expenditure_in_july_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" BIGINT,
  "amount_in_sterling" BIGINT,
  "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
);

Share link

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