Baselight

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
  • 37.88 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
  • 36.49 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,
  "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
  • 97.89 KB
  • 4664 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,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR
);

April 2022

@ukgov.financial_transactions_data_dh.april_2022
  • 54.98 KB
  • 1038 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.16 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
  • 46.13 KB
  • 1851 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,
  "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
  • 87.7 KB
  • 5712 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,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR
);

August 2022

@ukgov.financial_transactions_data_dh.august_2022
  • 44.5 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
  • 63.09 KB
  • 1797 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
  • 65.36 KB
  • 1654 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
  • 65.24 KB
  • 2624 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,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR
);

December 2021

@ukgov.financial_transactions_data_dh.december_2021
  • 67.66 KB
  • 2077 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,
  "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
  • 50.04 KB
  • 1033 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
  • 89.76 KB
  • 4337 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,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR
);

February 2022

@ukgov.financial_transactions_data_dh.february_2022
  • 76.39 KB
  • 1809 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
  • 41.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
  • 35.22 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,
  "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
  • 64.52 KB
  • 1498 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
  • 32.92 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
  • 68.01 KB
  • 2645 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,
  "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
  • 100.82 KB
  • 5098 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,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR
);

July 2022

@ukgov.financial_transactions_data_dh.july_2022
  • 50.65 KB
  • 1029 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
  • 51.5 KB
  • 1357 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
  • 77.86 KB
  • 2789 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,
  "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
  • 110.53 KB
  • 5739 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,
  "po_line_description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "unnamed_14" VARCHAR
);

Share link

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