The National Archives - GPC Spend Data

CREATE TABLE gpc_spend_for_august_2022 (
  "august_2022_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE gpc_spend_for_november_2022 (
  "november_2022_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE gpc_spend_for_october_2022 (
  "october_2022_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE gpc_spend_for_september_2022 (
  "september_2022_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE gpc_spend_july_2020 (
  "date" VARCHAR,
  "merchant_name" VARCHAR,
  "item_description" VARCHAR,
  "sum_of_line_value" BIGINT
);

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

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

CREATE TABLE national_archives_gpc_spend_april_2022 (
  "april_2022_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_april_2023 (
  "april_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_april_2024 (
  "apr_2024_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

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

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

CREATE TABLE national_archives_gpc_spend_august_2023 (
  "august_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

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

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

CREATE TABLE national_archives_gpc_spend_december_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "account_description" VARCHAR,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "transaction_reference" DOUBLE,
  "invoice_number" DOUBLE,
  "amount_paid" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project" VARCHAR,
  "expenditure_type" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_december_2022 (
  "december_2022_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_december_2023 (
  "dec_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_february_2019 (
  "transaction_date" VARCHAR,
  "merchant_name" VARCHAR,
  "description" VARCHAR,
  "value" DOUBLE
);

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

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

CREATE TABLE national_archives_gpc_spend_february_2023 (
  "february_2023_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

CREATE TABLE national_archives_gpc_spend_february_2024 (
  "feb_2024_gpc_spend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR
);

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

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