Spend Over £25,000 In HM Revenue & Customs
HM Revenue and Customs
@ukgov.financial_transactions_data_hmrc
HM Revenue and Customs
@ukgov.financial_transactions_data_hmrc
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
Anyone who has the link will be able to view this.