March 2022

@ukgov.financial_transactions_data_dwp.march_2022

39.05 KB
1148 rows
6 columns


CREATE TABLE march_2022 (
  "unique_id" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

March 2023

@ukgov.financial_transactions_data_dwp.march_2023

43.66 KB
1294 rows
6 columns


CREATE TABLE march_2023 (
  "unique_id" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

March 2024

@ukgov.financial_transactions_data_dwp.march_2024

30.14 KB
1218 rows
5 columns


CREATE TABLE march_2024 (
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

March 2025

@ukgov.financial_transactions_data_dwp.march_2025

108.97 KB
9555 rows
6 columns


CREATE TABLE march_2025 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "n__266_050_847" VARCHAR
);

May 2019

@ukgov.financial_transactions_data_dwp.may_2019

162.29 KB
28598 rows
10 columns


CREATE TABLE may_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_73bd7d6d" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

May 2020

@ukgov.financial_transactions_data_dwp.may_2020

45.67 KB
959 rows
10 columns


CREATE TABLE may_2020 (
  "workbook_name_ap_18" VARCHAR,
  "worksheet_name_transparency_detail" VARCHAR,
  "parameters_from_payment_date_01_may_2020_to_payment_da_87a502b8" VARCHAR,
  "invoice_amount_greater_than_or_equal_to_25000" VARCHAR,
  "date_and_time_the_workbook_was_run_03_jun_20_10_45_39_am" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

May 2021

@ukgov.financial_transactions_data_dwp.may_2021

35 KB
680 rows
7 columns


CREATE TABLE may_2021 (
  "identifier" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "invoice_number" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

May 2022

@ukgov.financial_transactions_data_dwp.may_2022

39.48 KB
785 rows
7 columns


CREATE TABLE may_2022 (
  "unique_id" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "invoice_number" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

May 2023

@ukgov.financial_transactions_data_dwp.may_2023

29.96 KB
799 rows
6 columns


CREATE TABLE may_2023 (
  "unique_id" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

May 2024

@ukgov.financial_transactions_data_dwp.may_2024

37.58 KB
8442 rows
5 columns


CREATE TABLE may_2024 (
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "sop_supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

November 2018

@ukgov.financial_transactions_data_dwp.november_2018

158.47 KB
14432 rows
10 columns


CREATE TABLE november_2018 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_a81aee9e" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

November 2019

@ukgov.financial_transactions_data_dwp.november_2019

196.61 KB
26322 rows
10 columns


CREATE TABLE november_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_4b4c1ce3" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

November 2020

@ukgov.financial_transactions_data_dwp.november_2020

35.59 KB
638 rows
10 columns


CREATE TABLE november_2020 (
  "departmental_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "invoice_number" VARCHAR,
  "invoice_distribution_amount" VARCHAR,
  "account_code" BIGINT,
  "cost_centre" BIGINT
);

November 2021

@ukgov.financial_transactions_data_dwp.november_2021

30.03 KB
769 rows
6 columns


CREATE TABLE november_2021 (
  "unique_identifier" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

November 2022

@ukgov.financial_transactions_data_dwp.november_2022

33.13 KB
899 rows
6 columns


CREATE TABLE november_2022 (
  "unique_id" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

November 2023

@ukgov.financial_transactions_data_dwp.november_2023

25.1 KB
955 rows
5 columns


CREATE TABLE november_2023 (
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

November 2024

@ukgov.financial_transactions_data_dwp.november_2024

259.6 KB
31984 rows
7 columns


CREATE TABLE november_2024 (
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "sop_supplier_name" VARCHAR,
  "payment_number" BIGINT,
  "transparency_invoice_amount" VARCHAR,
  "redactions" VARCHAR
);

October 2018

@ukgov.financial_transactions_data_dwp.october_2018

163.85 KB
14652 rows
10 columns


CREATE TABLE october_2018 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_24b803c7" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

October 2019

@ukgov.financial_transactions_data_dwp.october_2019

163.85 KB
14652 rows
10 columns


CREATE TABLE october_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_24b803c7" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

October 2020

@ukgov.financial_transactions_data_dwp.october_2020

37.7 KB
645 rows
10 columns


CREATE TABLE october_2020 (
  "departmental_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "invoice_number" VARCHAR,
  "invoice_distribution_amount" VARCHAR,
  "account_code" BIGINT,
  "cost_centre" BIGINT
);

October 2021

@ukgov.financial_transactions_data_dwp.october_2021

40.33 KB
817 rows
7 columns


CREATE TABLE october_2021 (
  "unique_id" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "invoice_number" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

October 2022

@ukgov.financial_transactions_data_dwp.october_2022

34.92 KB
934 rows
6 columns


CREATE TABLE october_2022 (
  "unique_identifier" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

October 2023

@ukgov.financial_transactions_data_dwp.october_2023

26.62 KB
980 rows
5 columns


CREATE TABLE october_2023 (
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

October 2024

@ukgov.financial_transactions_data_dwp.october_2024

259.6 KB
31984 rows
7 columns


CREATE TABLE october_2024 (
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "sop_supplier_name" VARCHAR,
  "payment_number" BIGINT,
  "transparency_invoice_amount" VARCHAR,
  "redactions" VARCHAR
);

September 2019

@ukgov.financial_transactions_data_dwp.september_2019

191.35 KB
26890 rows
10 columns


CREATE TABLE september_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_497f1fd9" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

Spend Over £25,000 In The Department For Work And Pensions

About this Dataset