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_s_spending_over_25_000_for_january_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_january_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_july_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_july_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_july_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_june_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_june_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_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_march_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_march_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_may_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_may_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_november_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_november_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_october_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_october_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_october_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_september_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_september_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_september_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 ffcdo_s_spending_over_25_000_for_june_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"posted_date" TIMESTAMP,
"internal_voucher_number" BIGINT,
"n__invoice_line_amount_gbp" DOUBLE,
"supplier_name" VARCHAR,
"account_name" VARCHAR
);
Anyone who has the link will be able to view this.