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.3 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In April 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_april_2022
  • 20.19 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In April 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_april_2023
  • 18.01 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In April 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_april_2024
  • 18.37 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In August 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_august_2020
  • 17.37 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,
  "allocation_date" TIMESTAMP,
  "account_code" VARCHAR,
  "address_code" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR
);

Expenditure In August 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_august_2021
  • 17.24 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In August 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_august_2022
  • 17.21 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In August 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_august_2023
  • 16.46 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In August 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_august_2024
  • 18.1 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In December 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_december_2020
  • 17.98 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_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR
);

Expenditure In December 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_december_2021
  • 17.16 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In December 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_december_2022
  • 16.94 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In December 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_december_2023
  • 17.94 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In December 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_december_2024
  • 17.52 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In February 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_february_2021
  • 17.14 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In February 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_february_2022
  • 17.92 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In February 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_february_2024
  • 16.48 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In February 2025

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_february_2025
  • 16.59 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In January 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_january_2021
  • 17.91 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_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR
);

Expenditure In January 2022

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_january_2022
  • 17.13 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In January 2023

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_january_2023
  • 16.58 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In January 2024

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_january_2024
  • 17.35 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In January 2025

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_january_2025
  • 18.78 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Expenditure In July 2020

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_july_2020
  • 17.54 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,
  "allocation_date" TIMESTAMP,
  "account_code" VARCHAR,
  "address_code" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR
);

Expenditure In July 2021

@ukgov.office_of_rail_and_road_spending_over_25000_dataset.expenditure_in_july_2021
  • 16.13 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_20" VARCHAR,
  "unnamed_21" VARCHAR
);

Share link

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