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
CREATE TABLE september_2020 (
"workbook_name_ap_18" VARCHAR,
"worksheet_name_transparency_detail" VARCHAR,
"parameters_from_payment_date_01_sep_2020_to_payment_da_27a62158" VARCHAR,
"invoice_amount_greater_than_or_equal_to_25000" VARCHAR,
"date_and_time_the_workbook_was_run_06_oct_20_12_19_43_pm" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR
);
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,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
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,
"parameters_from_payment_date_01_feb_2017_to_payment_da_175b8d0c" VARCHAR,
"payment_amount_25000" VARCHAR,
"note_see_report_specification_document_for_the_list_of_784c7322" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
Anyone who has the link will be able to view this.