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

CREATE TABLE april_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_cf9fa479" 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 april_2020_part_1 (
  "workbook_name_ap_18" VARCHAR,
  "worksheet_name_transparency_detail_parameters_from_pay_c897c742" VARCHAR,
  "invoice_amount_greater_than_or_equal_to_25000" VARCHAR,
  "n__date_and_time_the_workbook_was_run_06_may_20_01_14_13_pm" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

CREATE TABLE april_2020_part_2 (
  "workbook_name_ap_18" VARCHAR,
  "n__worksheet_name_transparency" VARCHAR,
  "detail_parameters_from_payment_date_01_apr_2020_to_pay_c503d633" VARCHAR,
  "invoice_amount_greater_than_or_equal_to_25000" VARCHAR,
  "date_and_time_the_workbook_was_run_06_may_20_01_14_13_pm" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

CREATE TABLE april_2021 (
  "indentifier" 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 april_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 april_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 april_2024 (
  "invoice_paid_date" TIMESTAMP,
  "invoice_cost_centre_description" VARCHAR,
  "invoice_account_description" VARCHAR,
  "sop_supplier_name" VARCHAR,
  "transparency_invoice_amount" VARCHAR
);

CREATE TABLE august_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_cbaf1032" 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 august_2020_part_1 (
  "workbook_name_ap_18" VARCHAR,
  "worksheet_name_transparency_detail" VARCHAR,
  "parameters_from_payment_date_01_aug_2020_to_payment_da_303c5504" VARCHAR,
  "invoice_amount_greater_than_or_equal_to_25000" VARCHAR,
  "date_and_time_the_workbook_was_run_08_sep_20_09_14_49_am" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

CREATE TABLE august_2020_part_2 (
  "workbook_name_ap_18" VARCHAR,
  "worksheet_name_transparency_detail" VARCHAR,
  "parameters_from_payment_date_01_aug_2020_to_payment_da_303c5504" VARCHAR,
  "invoice_amount_greater_than_or_equal_to_25000" VARCHAR,
  "date_and_time_the_workbook_was_run_08_sep_20_09_14_49_am" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

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

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

CREATE TABLE august_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 december_2018 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_19bd6e17" 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 december_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_eeba8f1b" 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 december_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
);

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

CREATE TABLE december_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
);

CREATE TABLE february_2019 (
  "n_3" 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 february_2020 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_7fe86a69" 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
);

CREATE TABLE february_2021 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_d3e7dead" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

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