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  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-APR-2019' , To Payment Date : '15-APR-2019' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 07-MAY-19–12.17.43 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
);

CREATE TABLE april_2020_part_1 (
  "workbook_name_ap_18" VARCHAR  -- Workbook Name: AP 18,
  "worksheet_name_transparency_detail_parameters_from_pay_c897c742" VARCHAR  -- Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-APR-2020' , To Payment Date : '30-APR-2020',
  "invoice_amount_greater_than_or_equal_to_25000" VARCHAR  -- Invoice Amount Greater Than Or Equal To : '25000',
  "n__date_and_time_the_workbook_was_run_06_may_20_01_14_13_pm" VARCHAR  -- Date And Time The Workbook Was Run: 06-MAY-20–01.14.13 PM,
  "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
);

CREATE TABLE april_2020_part_2 (
  "workbook_name_ap_18" VARCHAR  -- Workbook Name: AP 18,
  "n__worksheet_name_transparency" VARCHAR  -- Worksheet Name: Transparency,
  "detail_parameters_from_payment_date_01_apr_2020_to_pay_c503d633" VARCHAR  -- Detail Parameters: From Payment Date : '01-APR-2020' , To Payment Date : '30-APR-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_may_20_01_14_13_pm" VARCHAR  -- Date And Time The Workbook Was Run: 06-MAY-20–01.14.13 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 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  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-AUG-2019' , To Payment Date : '31-AUG-2019' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 27-SEP-19–11.29.19 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
);

CREATE TABLE august_2020_part_1 (
  "workbook_name_ap_18" VARCHAR  -- Workbook Name: AP 18,
  "worksheet_name_transparency_detail" VARCHAR  -- Worksheet Name: Transparency - Detail,
  "parameters_from_payment_date_01_aug_2020_to_payment_da_303c5504" VARCHAR  -- Parameters: From Payment Date : '01-AUG-2020' , To Payment Date : '31-AUG-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_08_sep_20_09_14_49_am" VARCHAR  -- Date And Time The Workbook Was Run: 08-SEP-20–09.14.49 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
);

CREATE TABLE august_2020_part_2 (
  "workbook_name_ap_18" VARCHAR  -- Workbook Name: AP 18,
  "worksheet_name_transparency_detail" VARCHAR  -- Worksheet Name: Transparency - Detail,
  "parameters_from_payment_date_01_aug_2020_to_payment_da_303c5504" VARCHAR  -- Parameters: From Payment Date : '01-AUG-2020' , To Payment Date : '31-AUG-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_08_sep_20_09_14_49_am" VARCHAR  -- Date And Time The Workbook Was Run: 08-SEP-20–09.14.49 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
);

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  -- 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 december_2018 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_19bd6e17" VARCHAR  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-DEC-2018' , To Payment Date : '31-DEC-2018' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 04-JAN-19–12.33.10 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
);

CREATE TABLE december_2019 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_eeba8f1b" VARCHAR  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-DEC-2019' , To Payment Date : '31-DEC-2019' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 08-JAN-20–11.42.02 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
);

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  -- 3,
  "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
);

CREATE TABLE february_2020 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_7fe86a69" VARCHAR  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-FEB-2020' , To Payment Date : '29-FEB-2020' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 03-MAR-20–02.55.17 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,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71
);

CREATE TABLE february_2021 (
  "workbook_name_ap_18_worksheet_name_transparency_detail_d3e7dead" VARCHAR  -- Workbook Name: AP 18 Worksheet Name: Transparency - Detail Parameters: From Payment Date : '01-FEB-2021' , To Payment Date : '28-FEB-2021' , Invoice Amount Greater Than Or Equal To : '25000' Date And Time The Workbook Was Run: 02-MAR-2021–09.28.38 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
);

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
);