Baselight
Sign In

Spend Over £25,000 In The Department Of Health

Department of Health and Social Care

@ukgov.financial_transactions_data_dh

Loading...
Loading...

About this Dataset

Spend Over £25,000 In The Department Of Health

A monthly-updated list of all financial transactions spending over £25,000 made by the Department of Health, as part of the Government's commitment to transparency in expenditure.
Publisher name: Department of Health and Social Care
Last updated: 2023-02-06T01:09:30Z

Tables

June 2022

@ukgov.financial_transactions_data_dh.june_2022
  • 59.21 KB
  • 1850 rows
  • 14 columns
Loading... 

CREATE TABLE june_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
);

March 2019

@ukgov.financial_transactions_data_dh.march_2019
  • 67.86 KB
  • 2041 rows
  • 14 columns
Loading... 

CREATE TABLE march_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
);

March 2020

@ukgov.financial_transactions_data_dh.march_2020
  • 66.17 KB
  • 2326 rows
  • 14 columns
Loading... 

CREATE TABLE march_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
);

March 2021

@ukgov.financial_transactions_data_dh.march_2021
  • 181.94 KB
  • 9867 rows
  • 15 columns
Loading... 

CREATE TABLE march_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
);

March 2022

@ukgov.financial_transactions_data_dh.march_2022
  • 154.88 KB
  • 4383 rows
  • 14 columns
Loading... 

CREATE TABLE march_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
);

May 2019

@ukgov.financial_transactions_data_dh.may_2019
  • 29.76 KB
  • 431 rows
  • 14 columns
Loading... 

CREATE TABLE may_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
);

May 2020

@ukgov.financial_transactions_data_dh.may_2020
  • 42.9 KB
  • 985 rows
  • 14 columns
Loading... 

CREATE TABLE may_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
);

May 2021

@ukgov.financial_transactions_data_dh.may_2021
  • 90.04 KB
  • 4531 rows
  • 15 columns
Loading... 

CREATE TABLE may_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
);

May 2022

@ukgov.financial_transactions_data_dh.may_2022
  • 41.84 KB
  • 713 rows
  • 14 columns
Loading... 

CREATE TABLE may_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
);

November 2019

@ukgov.financial_transactions_data_dh.november_2019
  • 34.8 KB
  • 608 rows
  • 14 columns
Loading... 

CREATE TABLE november_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
);

November 2020

@ukgov.financial_transactions_data_dh.november_2020
  • 59.37 KB
  • 2282 rows
  • 15 columns
Loading... 

CREATE TABLE november_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
);

November 2021

@ukgov.financial_transactions_data_dh.november_2021
  • 62.54 KB
  • 2334 rows
  • 15 columns
Loading... 

CREATE TABLE november_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
);

November 2022

@ukgov.financial_transactions_data_dh.november_2022
  • 61.96 KB
  • 1370 rows
  • 14 columns
Loading... 

CREATE TABLE november_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
);

October 2019

@ukgov.financial_transactions_data_dh.october_2019
  • 37.47 KB
  • 628 rows
  • 14 columns
Loading... 

CREATE TABLE october_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
);

October 2020

@ukgov.financial_transactions_data_dh.october_2020
  • 54.58 KB
  • 1927 rows
  • 16 columns
Loading... 

CREATE TABLE october_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,
  "unnamed_15" VARCHAR
);

October 2021

@ukgov.financial_transactions_data_dh.october_2021
  • 58.76 KB
  • 2177 rows
  • 15 columns
Loading... 

CREATE TABLE october_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
);

October 2022

@ukgov.financial_transactions_data_dh.october_2022
  • 54.94 KB
  • 1244 rows
  • 14 columns
Loading... 

CREATE TABLE october_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
);

September 2019

@ukgov.financial_transactions_data_dh.september_2019
  • 51.4 KB
  • 1290 rows
  • 14 columns
Loading... 

CREATE TABLE september_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
);

September 2020

@ukgov.financial_transactions_data_dh.september_2020
  • 84.13 KB
  • 3801 rows
  • 15 columns
Loading... 

CREATE TABLE september_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
);

September 2021

@ukgov.financial_transactions_data_dh.september_2021
  • 155.18 KB
  • 12123 rows
  • 15 columns
Loading... 

CREATE TABLE september_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
);

September 2022

@ukgov.financial_transactions_data_dh.september_2022
  • 67.26 KB
  • 1781 rows
  • 14 columns
Loading... 

CREATE TABLE september_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
);

Spend Over £25,000 In The Department Of Health

@ukgov.financial_transactions_data_dh.spend_over_25_000_in_the_department_of_health
  • 44.38 KB
  • 872 rows
  • 14 columns
Loading... 

CREATE TABLE spend_over_25_000_in_the_department_of_health (
  "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
);

Share link

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