Spending Over £25,000 In The Foreign And Commonwealth Office
Foreign and Commonwealth Office
@ukgov.financial_transactions_data_fco
Foreign and Commonwealth Office
@ukgov.financial_transactions_data_fco
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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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
);
Anyone who has the link will be able to view this.