Spend Over £25,000 In The Department For Work And Pensions
Department for Work and Pensions
@ukgov.financial_transactions_data_dwp
Department for Work and Pensions
@ukgov.financial_transactions_data_dwp
A monthly-updated list of all financial transactions spending over £25,000 made by the Department for Work and Pensions, as part of the Government's commitment to transparency in expenditure.
Publisher name: Department for Work and Pensions
Last updated: 2025-05-02T04:00:28Z
CREATE TABLE september_2020 (
"workbook_name_ap_18" VARCHAR -- Workbook Name: AP 18,
"worksheet_name_transparency_detail" VARCHAR -- Worksheet Name: Transparency - Detail,
"parameters_from_payment_date_01_sep_2020_to_payment_da_27a62158" VARCHAR -- Parameters: From Payment Date : '01-SEP-2020' , To Payment Date : '30-SEP-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_06_oct_20_12_19_43_pm" VARCHAR -- Date And Time The Workbook Was Run: 06-OCT-20–12.19.43 PM,
"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
);CREATE TABLE september_2021 (
"unique_identifier" VARCHAR,
"invoice_paid_date" TIMESTAMP,
"invoice_cost_centre_description" VARCHAR,
"invoice_account_description" VARCHAR,
"supplier_name" VARCHAR,
"transparency_invoice_amount" VARCHAR
);CREATE TABLE september_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
);CREATE TABLE september_2023 (
"invoice_paid_date" TIMESTAMP,
"invoice_cost_centre_description" VARCHAR,
"invoice_account_description" VARCHAR,
"supplier_name" VARCHAR,
"transparency_invoice_amount" VARCHAR
);CREATE TABLE september_2024 (
"values_listed_under_25_000_are_one_part_of_multiple_pa_e1bb0aae" VARCHAR -- Values Listed Under £25,000 Are One Part Of Multiple Payments Under A Single Transaction Number. All Transaction Numbers Total Over £25,000 In Value.,
"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
);CREATE TABLE spend_over_25_000_in_the_department_for_work_and_pensions (
"work_book_name_rm_a2fr_gl35_transparency_report" VARCHAR,
"work_sheet_name_transparency" VARCHAR,
"date_time_report_ran_07_mar_17_02_52_26_pm" VARCHAR -- Date & Time Report Ran: 07-MAR-17–02.52.26 PM,
"parameters_from_payment_date_01_feb_2017_to_payment_da_175b8d0c" VARCHAR -- Parameters: From Payment Date : '01-FEB-2017' , To Payment Date : '28-FEB-2017',
"payment_amount_25000" VARCHAR -- Payment Amount : '25000',
"note_see_report_specification_document_for_the_list_of_784c7322" VARCHAR -- Note:See Report Specification Document For The List Of Excluded Account Codes And Cost Centres.,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);Anyone who has the link will be able to view this.