Spending Over £25,000 In The Foreign And Commonwealth Office

CREATE TABLE april_2019_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE april_2020_fco_spending_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE august_2019_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE august_2020_fco_spending_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE december_2018_fco_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE december_2019_fco_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE february_2019_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE february_2020_fco_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE january_2019_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE january_2020_fco_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE july_2019_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE july_2020_fco_spending_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE june_2019_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE june_2020_fco_spending_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE march_2019_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE march_2020_fco_spending_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE may_2019_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE may_2020_fco_spending_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE november_2018_fco_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "invoice_line_amount_net_gbp" DOUBLE,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE november_2019_fco_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE october_2018_fco_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE october_2019_fco_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE september_2018_fco_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE september_2019_spend_over_25000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "intrenal_voucher_number" BIGINT,
  "n__invoice_line_amount_net_gbp" DOUBLE  -- Invoice Line Amount Net GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

CREATE TABLE spending_over_25_000_in_the_foreign_and_commonwealth_office (
  "department" VARCHAR,
  "entity" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" BIGINT,
  "invoice_amount" VARCHAR,
  "supplier" VARCHAR,
  "account_description" VARCHAR
);