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
Reports on departmental spending over £25,000.
Publisher name: Foreign, Commonwealth and Development Office (FCDO)
Last updated: 2024-12-11T08:00:02Z
CREATE TABLE fcdo_dfid_spending_over_25_000_april_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"n__posted_date" TIMESTAMP -- Posted Date,
"internal_voucher_number" VARCHAR,
"n__invoice_line_amount_gbp" VARCHAR -- Invoice Line Amount GBP,
"n__supplier_name" VARCHAR -- Supplier Name,
"n__account_code" VARCHAR -- Account Code
);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 -- Supplier Name,
"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 -- Invoice Line Amount GBP,
"n__supplier_name" VARCHAR -- Supplier Name,
"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 -- Supplier Name,
"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 -- Posted Date,
"internal_voucher_number" VARCHAR,
"n__invoice_line_amount_gbp" VARCHAR -- Invoice Line Amount GBP,
"n__supplier_name" VARCHAR -- Supplier Name,
"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 -- Supplier Name,
"account_code" VARCHAR
);CREATE TABLE fcdo_dfid_spending_over_25_000_may_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"n__posted_date" TIMESTAMP -- Posted Date,
"internal_voucher_number" VARCHAR,
"invoice_line_amount_gbp" VARCHAR,
"n__supplier_name" VARCHAR -- Supplier Name,
"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 -- Invoice Line Amount (GBP),
"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 -- Supplier Name,
"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 -- Supplier Name,
"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 -- Supplier Name,
"n__expense_type" VARCHAR -- Expense Type
);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 -- Invoice Line Amount GBP,
"n__supplier_name" VARCHAR -- Supplier Name,
"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 -- Supplier Name,
"n__account_code" VARCHAR -- Account Code
);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 -- Invoice Line Amount GBP,
"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 -- Invoice Line Amount GBP,
"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 -- Invoice Line Amount GBP,
"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 -- Invoice Line Amount GBP,
"supplier_name" VARCHAR,
"account_code" VARCHAR
);Anyone who has the link will be able to view this.