Spend Over £25,000 In The Department Of Health
Department of Health and Social Care
@ukgov.financial_transactions_data_dh
Department of Health and Social Care
@ukgov.financial_transactions_data_dh
CREATE TABLE april_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE april_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE april_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" VARCHAR,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE april_2022 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE august_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE august_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE august_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE august_2022 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE december_2018 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE december_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE december_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE december_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE february_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE february_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE february_2022 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE january_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE january_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" VARCHAR,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE january_2022 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE july_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE july_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE july_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE july_2022 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE june_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE june_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE june_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" DOUBLE,
"po_line_description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR,
"unnamed_14" VARCHAR
);
Anyone who has the link will be able to view this.