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

April 2019

@ukgov.financial_transactions_data_dh.april_2019
  • 38.79 kB
  • 627 rows
  • 14 columns
Loading... 
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
);

April 2020

@ukgov.financial_transactions_data_dh.april_2020
  • 37.37 kB
  • 889 rows
  • 14 columns
Loading... 
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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

April 2021

@ukgov.financial_transactions_data_dh.april_2021
  • 100.24 kB
  • 4,664 rows
  • 15 columns
Loading... 
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  -- 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
);

April 2022

@ukgov.financial_transactions_data_dh.april_2022
  • 56.3 kB
  • 1,038 rows
  • 14 columns
Loading... 
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
);

August 2019

@ukgov.financial_transactions_data_dh.august_2019
  • 32.94 kB
  • 465 rows
  • 14 columns
Loading... 
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
);

August 2020

@ukgov.financial_transactions_data_dh.august_2020
  • 47.23 kB
  • 1,851 rows
  • 14 columns
Loading... 
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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

August 2021

@ukgov.financial_transactions_data_dh.august_2021
  • 89.8 kB
  • 5,712 rows
  • 15 columns
Loading... 
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  -- 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
);

August 2022

@ukgov.financial_transactions_data_dh.august_2022
  • 45.57 kB
  • 818 rows
  • 14 columns
Loading... 
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
);

December 2018

@ukgov.financial_transactions_data_dh.december_2018
  • 64.6 kB
  • 1,797 rows
  • 14 columns
Loading... 
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
);

December 2019

@ukgov.financial_transactions_data_dh.december_2019
  • 66.93 kB
  • 1,654 rows
  • 14 columns
Loading... 
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
);

December 2020

@ukgov.financial_transactions_data_dh.december_2020
  • 66.8 kB
  • 2,624 rows
  • 15 columns
Loading... 
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  -- 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
);

December 2021

@ukgov.financial_transactions_data_dh.december_2021
  • 69.28 kB
  • 2,077 rows
  • 14 columns
Loading... 
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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

February 2020

@ukgov.financial_transactions_data_dh.february_2020
  • 51.24 kB
  • 1,033 rows
  • 14 columns
Loading... 
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
);

February 2021

@ukgov.financial_transactions_data_dh.february_2021
  • 91.91 kB
  • 4,337 rows
  • 15 columns
Loading... 
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  -- 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
);

February 2022

@ukgov.financial_transactions_data_dh.february_2022
  • 78.23 kB
  • 1,809 rows
  • 14 columns
Loading... 
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
);

January 2019

@ukgov.financial_transactions_data_dh.january_2019
  • 42.4 kB
  • 886 rows
  • 14 columns
Loading... 
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
);

January 2020

@ukgov.financial_transactions_data_dh.january_2020
  • 36.06 kB
  • 553 rows
  • 14 columns
Loading... 
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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

January 2022

@ukgov.financial_transactions_data_dh.january_2022
  • 66.06 kB
  • 1,498 rows
  • 14 columns
Loading... 
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
);

July 2019

@ukgov.financial_transactions_data_dh.july_2019
  • 33.71 kB
  • 536 rows
  • 14 columns
Loading... 
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
);

July 2020

@ukgov.financial_transactions_data_dh.july_2020
  • 69.64 kB
  • 2,645 rows
  • 14 columns
Loading... 
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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

July 2021

@ukgov.financial_transactions_data_dh.july_2021
  • 103.24 kB
  • 5,098 rows
  • 15 columns
Loading... 
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  -- 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
);

July 2022

@ukgov.financial_transactions_data_dh.july_2022
  • 51.87 kB
  • 1,029 rows
  • 14 columns
Loading... 
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
);

June 2019

@ukgov.financial_transactions_data_dh.june_2019
  • 52.73 kB
  • 1,357 rows
  • 14 columns
Loading... 
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
);

June 2020

@ukgov.financial_transactions_data_dh.june_2020
  • 79.73 kB
  • 2,789 rows
  • 14 columns
Loading... 
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  -- Amount,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

June 2021

@ukgov.financial_transactions_data_dh.june_2021
  • 113.19 kB
  • 5,739 rows
  • 15 columns
Loading... 
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  -- 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
);

Share link

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