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
);

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.