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

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

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

CREATE TABLE february_2025 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "n__239_603_453" VARCHAR
);

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

CREATE TABLE january_2020 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_e4418b91" 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,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR
);

CREATE TABLE january_2021 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_19e5b2d4" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

CREATE TABLE january_2022 (
  "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 january_2023 (
  "unique_id" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

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

CREATE TABLE january_2025 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "n__307_763_854" VARCHAR
);

CREATE TABLE july_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_1c46be6a" 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
);

CREATE TABLE july_2020 (
  "workbook_name_ap_18" VARCHAR,
  "worksheet_name_transparency_detail" VARCHAR,
  "parameters_from_payment_date_01_jul_2020_to_payment_da_8125f807" VARCHAR,
  "n__invoice_amount_greater_than_or_equal_to_25000" VARCHAR,
  "date_and_time_the_workbook_was_run_04_aug_20_02_23_40_pm" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

CREATE TABLE july_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 july_2022 (
  "unique_id" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

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

CREATE TABLE july_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 june_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_dc27b78b" 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
);

CREATE TABLE june_2020 (
  "workbook_name_ap_18" VARCHAR,
  "worksheet_name_transparency_detail" VARCHAR,
  "parameters_from_payment_date_01_jun_2020_to_payment_da_1f758462" VARCHAR,
  "invoice_amount_greater_than_or_equal_to_25000" VARCHAR,
  "date_and_time_the_workbook_was_run_01_jul_20_10_18_50_am" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

CREATE TABLE june_2021 (
  "unique_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
);

CREATE TABLE june_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 june_2023 (
  "unique_id" VARCHAR,
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

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

CREATE TABLE march_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_9670e55a" 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
);

CREATE TABLE march_2020 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_a0e27996" 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
);

CREATE TABLE march_2021 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_cb50cc97" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);