March 2022

@ukgov.financial_transactions_data_dwp.march_2022

39.99 kB
1,148 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

44.71 kB
1,294 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.87 kB
1,218 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

111.59 kB
9,555 rows
6 columns

CREATE TABLE march_2025 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "n__266_050_847" VARCHAR  -- È266,050,847
);

May 2019

@ukgov.financial_transactions_data_dwp.may_2019

166.18 kB
28,598 rows
10 columns

CREATE TABLE may_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_73bd7d6d" VARCHAR  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-MAY-2019' , To Payment Date : '31-MAY-2019' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 02-JUL-19–03.03.44 PM,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

May 2020

@ukgov.financial_transactions_data_dwp.may_2020

46.77 kB
959 rows
10 columns

CREATE TABLE may_2020 (
  "workbook_name_ap_18" VARCHAR  -- Workbook Name: AP 18,
  "worksheet_name_transparency_detail" VARCHAR  -- Worksheet Name: Transparency - Detail,
  "parameters_from_payment_date_01_may_2020_to_payment_da_87a502b8" VARCHAR  -- Parameters: From Payment Date : '01-MAY-2020' , To Payment Date : '31-MAY-2020',
  "invoice_amount_greater_than_or_equal_to_25000" VARCHAR  -- Invoice Amount Greater Than Or Equal To : '25000',
  "date_and_time_the_workbook_was_run_03_jun_20_10_45_39_am" VARCHAR  -- Date And Time The Workbook Was Run: 03-JUN-20–10.45.39 AM,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

May 2021

@ukgov.financial_transactions_data_dwp.may_2021

35.84 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

40.43 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

30.68 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

38.49 kB
8,442 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

162.28 kB
14,432 rows
10 columns

CREATE TABLE november_2018 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_a81aee9e" VARCHAR  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-NOV-2018' , To Payment Date : '30-NOV-2018' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 06-DEC-18–11.44.10 AM,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

November 2019

@ukgov.financial_transactions_data_dwp.november_2019

201.33 kB
26,322 rows
10 columns

CREATE TABLE november_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_4b4c1ce3" VARCHAR  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-NOV-2019' , To Payment Date : '30-NOV-2019' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 05-DEC-19–01.32.47 PM,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

November 2020

@ukgov.financial_transactions_data_dwp.november_2020

36.45 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.75 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.92 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.7 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

265.83 kB
31,984 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

167.78 kB
14,652 rows
10 columns

CREATE TABLE october_2018 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_24b803c7" VARCHAR  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-OCT-2018' , To Payment Date : '31-OCT-2018' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 23-NOV-18–11.28.22 AM,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

October 2019

@ukgov.financial_transactions_data_dwp.october_2019

167.78 kB
14,652 rows
10 columns

CREATE TABLE october_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_24b803c7" VARCHAR  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-OCT-2018' , To Payment Date : '31-OCT-2018' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 23-NOV-18–11.28.22 AM,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

October 2020

@ukgov.financial_transactions_data_dwp.october_2020

38.61 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

41.3 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

35.76 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

27.26 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

265.83 kB
31,984 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

195.94 kB
26,890 rows
10 columns

CREATE TABLE september_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_497f1fd9" VARCHAR  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-SEP-2019' , To Payment Date : '30-SEP-2019' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 01-OCT-19–02.43.49 PM,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

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

About this Dataset