Baselight
Sign In

Spend Over £25,000 In HM Revenue & Customs

HM Revenue and Customs

@ukgov.financial_transactions_data_hmrc

Loading...
Loading...

About this Dataset

Spend Over £25,000 In HM Revenue & Customs

The spreadsheets below set out monthly details of HMRC’s and Revenue and Customs Digital Technology Services Limited (RCDTS) spending with suppliers covering transactions over £25,000. RCDTS was closed in 2023. A list of abbreviations and terms used by HMRC when recording spend with suppliers, can be found : https://www.gov.uk/government/publications/hmrc-glossary-of-terms-used-in-departmental-spending-over-25000-pages
Publisher name: HM Revenue and Customs
Last updated: 2025-05-01T04:00:24Z

Tables

April 2019 Return

@ukgov.financial_transactions_data_hmrc.april_2019_return
  • 30.6 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE april_2019_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

April 2019 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.april_2019_return_rcdts
  • 11.14 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE april_2019_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

April 2020 Return

@ukgov.financial_transactions_data_hmrc.april_2020_return
  • 28.37 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE april_2020_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

April 2020 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.april_2020_return_rcdts
  • 11.21 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE april_2020_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

April 2021 Return

@ukgov.financial_transactions_data_hmrc.april_2021_return
  • 35.93 kB
  • 732 rows
  • 14 columns
Loading... 
CREATE TABLE april_2021_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

April 2021 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.april_2021_return_rcdts
  • 10.67 kB
  • 20 rows
  • 14 columns
Loading... 
CREATE TABLE april_2021_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

April 2022 Return

@ukgov.financial_transactions_data_hmrc.april_2022_return
  • 35.86 kB
  • 1,191 rows
  • 14 columns
Loading... 
CREATE TABLE april_2022_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

April 2022 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.april_2022_return_rcdts
  • 10.85 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE april_2022_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

August 2019 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.august_2019_return_rcdts
  • 11.07 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE august_2019_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

August 2020 Return

@ukgov.financial_transactions_data_hmrc.august_2020_return
  • 29.96 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE august_2020_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

August 2020 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.august_2020_return_rcdts
  • 11.15 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE august_2020_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

August 2021 Return

@ukgov.financial_transactions_data_hmrc.august_2021_return
  • 34.83 kB
  • 757 rows
  • 14 columns
Loading... 
CREATE TABLE august_2021_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

August 2021 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.august_2021_return_rcdts
  • 10.69 kB
  • 15 rows
  • 14 columns
Loading... 
CREATE TABLE august_2021_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

August 2022 Return

@ukgov.financial_transactions_data_hmrc.august_2022_return
  • 37.4 kB
  • 4,991 rows
  • 14 columns
Loading... 
CREATE TABLE august_2022_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

August 2022 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.august_2022_return_rcdts
  • 10.63 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE august_2022_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

August 2024 Return

@ukgov.financial_transactions_data_hmrc.august_2024_return
  • 34.75 kB
  • 4,991 rows
  • 14 columns
Loading... 
CREATE TABLE august_2024_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

December 2018 Return

@ukgov.financial_transactions_data_hmrc.december_2018_return
  • 27.25 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE december_2018_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

December 2018 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.december_2018_return_rcdts
  • 12 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE december_2018_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

December 2019 Return

@ukgov.financial_transactions_data_hmrc.december_2019_return
  • 29.9 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE december_2019_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

December 2019 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.december_2019_return_rcdts
  • 11.3 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE december_2019_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

December 2020 Return

@ukgov.financial_transactions_data_hmrc.december_2020_return
  • 36.09 kB
  • 675 rows
  • 14 columns
Loading... 
CREATE TABLE december_2020_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

December 2020 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.december_2020_return_rcdts
  • 10.53 kB
  • 15 rows
  • 14 columns
Loading... 
CREATE TABLE december_2020_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

December 2021 Return

@ukgov.financial_transactions_data_hmrc.december_2021_return
  • 40.77 kB
  • 1,191 rows
  • 14 columns
Loading... 
CREATE TABLE december_2021_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

December 2021 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.december_2021_return_rcdts
  • 11.02 kB
  • 35 rows
  • 14 columns
Loading... 
CREATE TABLE december_2021_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

December 2023 Return

@ukgov.financial_transactions_data_hmrc.december_2023_return
  • 35.74 kB
  • 1,019 rows
  • 14 columns
Loading... 
CREATE TABLE december_2023_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

February 2019 Return

@ukgov.financial_transactions_data_hmrc.february_2019_return
  • 27.51 kB
  • 441 rows
  • 14 columns
Loading... 
CREATE TABLE february_2019_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

February 2019 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.february_2019_return_rcdts
  • 11.41 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE february_2019_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

February 2020 Return

@ukgov.financial_transactions_data_hmrc.february_2020_return
  • 28.14 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE february_2020_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

February 2020 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.february_2020_return_rcdts
  • 10.84 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE february_2020_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

February 2021 Return

@ukgov.financial_transactions_data_hmrc.february_2021_return
  • 35.42 kB
  • 716 rows
  • 14 columns
Loading... 
CREATE TABLE february_2021_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

February 2021 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.february_2021_return_rcdts
  • 10.56 kB
  • 13 rows
  • 14 columns
Loading... 
CREATE TABLE february_2021_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

February 2022 Return

@ukgov.financial_transactions_data_hmrc.february_2022_return
  • 35.71 kB
  • 1,191 rows
  • 14 columns
Loading... 
CREATE TABLE february_2022_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

February 2022 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.february_2022_return_rcdts
  • 10.96 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE february_2022_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

January 2019 Return

@ukgov.financial_transactions_data_hmrc.january_2019_return
  • 27.97 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE january_2019_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

January 2019 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.january_2019_return_rcdts
  • 11.61 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE january_2019_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

January 2020 Return

@ukgov.financial_transactions_data_hmrc.january_2020_return
  • 28 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE january_2020_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

January 2020 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.january_2020_return_rcdts
  • 11.08 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE january_2020_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

January 2021 Return

@ukgov.financial_transactions_data_hmrc.january_2021_return
  • 33.14 kB
  • 630 rows
  • 14 columns
Loading... 
CREATE TABLE january_2021_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

January 2021 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.january_2021_return_rcdts
  • 10.76 kB
  • 25 rows
  • 14 columns
Loading... 
CREATE TABLE january_2021_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

January 2022 Return

@ukgov.financial_transactions_data_hmrc.january_2022_return
  • 36.2 kB
  • 1,191 rows
  • 14 columns
Loading... 
CREATE TABLE january_2022_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

January 2022 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.january_2022_return_rcdts
  • 10.71 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE january_2022_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

July 2019 Return

@ukgov.financial_transactions_data_hmrc.july_2019_return
  • 27.47 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE july_2019_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

July 2019 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.july_2019_return_rcdts
  • 11.63 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE july_2019_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

July 2020 Return

@ukgov.financial_transactions_data_hmrc.july_2020_return
  • 33.79 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE july_2020_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

July 2020 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.july_2020_return_rcdts
  • 11 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE july_2020_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

July 2021 Return

@ukgov.financial_transactions_data_hmrc.july_2021_return
  • 39.29 kB
  • 989 rows
  • 14 columns
Loading... 
CREATE TABLE july_2021_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

July 2021 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.july_2021_return_rcdts
  • 10.76 kB
  • 25 rows
  • 14 columns
Loading... 
CREATE TABLE july_2021_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

July 2022 Return

@ukgov.financial_transactions_data_hmrc.july_2022_return
  • 35.88 kB
  • 4,991 rows
  • 14 columns
Loading... 
CREATE TABLE july_2022_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

July 2022 Return - RCDTS

@ukgov.financial_transactions_data_hmrc.july_2022_return_rcdts
  • 10.73 kB
  • 752 rows
  • 14 columns
Loading... 
CREATE TABLE july_2022_return_rcdts (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

July 2024 Return

@ukgov.financial_transactions_data_hmrc.july_2024_return
  • 36.61 kB
  • 4,991 rows
  • 14 columns
Loading... 
CREATE TABLE july_2024_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

Share link

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