Foreign, Commonwealth And Development Office Spending Over £25,000
Foreign, Commonwealth and Development Office (FCDO)
@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf
Foreign, Commonwealth and Development Office (FCDO)
@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf
CREATE TABLE fcdo_fco_spending_over_25_000_december_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_february_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_february_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_january_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"intrenal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_january_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_july_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_march_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_march_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" DOUBLE,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_may_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_may_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_november_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_november_2021 (
"department" VARCHAR,
"entiry" VARCHAR,
"posted_date" TIMESTAMP,
"interenal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_october_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_october_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_september_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_september_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_s_spending_over_25_000_for_april_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"unique_identifier" BIGINT,
"invoice_line_number" BIGINT,
"supplier_name" VARCHAR,
"invoice_gbp_line_amt" VARCHAR,
"category" VARCHAR
);
CREATE TABLE fcdo_s_spending_over_25_000_for_april_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"unique_identifier" BIGINT,
"invoice_line_number" BIGINT,
"supplier_name" VARCHAR,
"invoice_gbp_line_amt" DOUBLE,
"category" VARCHAR
);
CREATE TABLE fcdo_s_spending_over_25_000_for_august_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"unique_identifier" BIGINT,
"invoice_line_number" BIGINT,
"supplier_name" VARCHAR,
"invoice_gbp_line_amt" VARCHAR,
"category" VARCHAR
);
CREATE TABLE fcdo_s_spending_over_25_000_for_august_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"unique_identifier" BIGINT,
"invoice_line_number" BIGINT,
"supplier_name" VARCHAR,
"invoice_gbp_line_amt" VARCHAR,
"category" VARCHAR
);
CREATE TABLE fcdo_s_spending_over_25_000_for_august_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"unique_identifier" BIGINT,
"invoice_line_number" BIGINT,
"supplier_name" VARCHAR,
"invoice_gbp_line_amt" DOUBLE,
"category" VARCHAR
);
CREATE TABLE fcdo_s_spending_over_25_000_for_december_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"unique_identifier" BIGINT,
"invoice_line_number" BIGINT,
"supplier_name" VARCHAR,
"invoice_gbp_line_amt" VARCHAR,
"category" VARCHAR
);
CREATE TABLE fcdo_s_spending_over_25_000_for_december_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"unique_identifier" BIGINT,
"invoice_line_number" BIGINT,
"supplier_name" VARCHAR,
"invoice_gbp_line_amt" VARCHAR,
"category" VARCHAR
);
CREATE TABLE fcdo_s_spending_over_25_000_for_february_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"unique_identifier" BIGINT,
"invoice_line_number" BIGINT,
"supplier_name" VARCHAR,
"invoice_gbp_line_amt" VARCHAR,
"category" VARCHAR
);
CREATE TABLE fcdo_s_spending_over_25_000_for_february_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"unique_identifier" BIGINT,
"invoice_line_number" BIGINT,
"supplier_name" VARCHAR,
"invoice_gbp_line_amt" DOUBLE,
"category" VARCHAR
);
Anyone who has the link will be able to view this.