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: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE national_archives_gpc_spend_january_2024 (
  "jan_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

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: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE national_archives_gpc_spend_july_2023 (
  "july_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE national_archives_gpc_spend_july_2024 (
  "jul_2024_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

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: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE national_archives_gpc_spend_june_2023 (
  "june_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE national_archives_gpc_spend_june_2024 (
  "may_gpc_spend_over_500" VARCHAR  -- May GPC Spend Over £500,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE national_archives_gpc_spend_march_2019 (
  "n_25_03_2019_www_secol_co_uk_archival_polyester_pockets" VARCHAR  -- 25/03/2019,WWW.SECOL.CO.UK,Archival Polyester Pockets,
  "n__5_x_pk_50_a4" VARCHAR  -- 5 X Pk 50 A4,
  "n__8_x_pk_50_foolscap" VARCHAR  -- 8 X Pk 50 Foolscap,
  "n__8_x_pk_50_a6" VARCHAR  -- 8 X Pk 50 A6,
  "n__5_x_pk_50_a5_903_48" VARCHAR  -- 5 X Pk 50 A5,903.48
);

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: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE national_archives_gpc_spend_march_2024 (
  "mar_2024_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE national_archives_gpc_spend_may_2020 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "n_4_209_89" VARCHAR  -- 4,209.89
);

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: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE national_archives_gpc_spend_may_2023 (
  "may_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE national_archives_gpc_spend_may_2024 (
  "may_gpc_spend_over_500" VARCHAR  -- May GPC Spend Over £500,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

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: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "n_11_798_87" VARCHAR  -- 11,798.87
);

CREATE TABLE national_archives_gpc_spend_november_2023 (
  "november_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

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: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "n_12_008_21" VARCHAR  -- 12,008.21
);