The National Archives - GPC Spend Data

CREATE TABLE national_archives_gpc_spend_january_2022 (
  "date" VARCHAR,
  "merchant_name" VARCHAR,
  "item_description" VARCHAR,
  "sum_of_line_value" DOUBLE
);

CREATE TABLE national_archives_gpc_spend_january_2023 (
  "january_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_january_2024 (
  "jan_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_july_2021 (
  "date" VARCHAR,
  "merchant_name" VARCHAR,
  "item_description" VARCHAR,
  "sum_of_line_value" DOUBLE
);

CREATE TABLE national_archives_gpc_spend_july_2022 (
  "july_2022_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_july_2023 (
  "july_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_july_2024 (
  "jul_2024_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_june_2021 (
  "date" VARCHAR,
  "merchant_name" VARCHAR,
  "item_description" VARCHAR,
  "sum_of_line_value" DOUBLE
);

CREATE TABLE national_archives_gpc_spend_june_2022 (
  "june_2022_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_june_2023 (
  "june_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_june_2024 (
  "may_gpc_spend_over_500" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_march_2019 (
  "n_25_03_2019_www_secol_co_uk_archival_polyester_pockets" VARCHAR,
  "n__5_x_pk_50_a4" VARCHAR,
  "n__8_x_pk_50_foolscap" VARCHAR,
  "n__8_x_pk_50_a6" VARCHAR,
  "n__5_x_pk_50_a5_903_48" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_march_2021 (
  "date" VARCHAR,
  "merchant_name" VARCHAR,
  "item_description" VARCHAR,
  "sum_of_line_value" DOUBLE
);

CREATE TABLE national_archives_gpc_spend_march_2023 (
  "march_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_march_2024 (
  "mar_2024_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_may_2020 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "n_4_209_89" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_may_2021 (
  "date" VARCHAR,
  "merchant_name" VARCHAR,
  "item_description" VARCHAR,
  "sum_of_line_value" DOUBLE
);

CREATE TABLE national_archives_gpc_spend_may_2022 (
  "may_2022_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_may_2023 (
  "may_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_may_2024 (
  "may_gpc_spend_over_500" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_nov_2018 (
  "transaction_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "total" DOUBLE
);

CREATE TABLE national_archives_gpc_spend_november_2019 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "n_11_798_87" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_november_2023 (
  "november_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_oct_2018 (
  "transaction_date" VARCHAR,
  "merchant_name" VARCHAR,
  "total" DOUBLE
);

CREATE TABLE national_archives_gpc_spend_october_2019 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "n_12_008_21" VARCHAR
);