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_dfid_spending_over_25_000_april_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"n__posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"n__invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"n__account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_april_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_august_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_december_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_december_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_february_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"n__invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_february_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_january_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_january_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_july_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_june_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_march_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"n__posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"n__invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_march_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_may_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"n__posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_may_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_november_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_november_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_october_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_october_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"n__expense_type" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_september_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"n__invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_dfid_spending_over_25_000_september_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR,
"n__account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_april_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_april_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_august_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"n__invoice_line_amount_gbp" DOUBLE,
"internal_voucher_number" BIGINT,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
CREATE TABLE fcdo_fco_spending_over_25_000_december_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);
Anyone who has the link will be able to view this.