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
  • 60.63 kB
  • 1,850 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
  • 69.49 kB
  • 2,041 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
  • 67.76 kB
  • 2,326 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  -- Amount,
  "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
  • 186.3 kB
  • 9,867 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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

March 2022

@ukgov.financial_transactions_data_dh.march_2022
  • 158.6 kB
  • 4,383 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
  • 30.48 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
  • 43.93 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  -- Amount,
  "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
  • 92.2 kB
  • 4,531 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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

May 2022

@ukgov.financial_transactions_data_dh.may_2022
  • 42.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
  • 35.64 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
  • 60.79 kB
  • 2,282 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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

November 2021

@ukgov.financial_transactions_data_dh.november_2021
  • 64.04 kB
  • 2,334 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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

November 2022

@ukgov.financial_transactions_data_dh.november_2022
  • 63.45 kB
  • 1,370 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
  • 38.37 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
  • 55.89 kB
  • 1,927 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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

October 2021

@ukgov.financial_transactions_data_dh.october_2021
  • 60.17 kB
  • 2,177 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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

October 2022

@ukgov.financial_transactions_data_dh.october_2022
  • 56.26 kB
  • 1,244 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
  • 52.64 kB
  • 1,290 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
  • 86.15 kB
  • 3,801 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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

September 2021

@ukgov.financial_transactions_data_dh.september_2021
  • 158.91 kB
  • 12,123 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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

September 2022

@ukgov.financial_transactions_data_dh.september_2022
  • 68.88 kB
  • 1,781 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
  • 45.44 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.