Spend Transactions By DFID
Department for International Development
@ukgov.spend_transactions_by_dfid
Department for International Development
@ukgov.spend_transactions_by_dfid
CREATE TABLE details_of_dfid_spend_over_500_august_2011 (
"department" VARCHAR,
"entity" VARCHAR,
"paiddate" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"suppliername" VARCHAR,
"voucher_no" DOUBLE,
"voucher_descrption" VARCHAR,
"n__amount" DOUBLE
);
CREATE TABLE details_of_dfid_spend_over_500_august_2012 (
"department" VARCHAR,
"entity" VARCHAR,
"transaction_date" TIMESTAMP,
"supplier_name" VARCHAR,
"amount" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_august_2013 (
"deptartment_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_august_2014 (
"department_family" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"n__supplier_name" VARCHAR,
"n__component_code" VARCHAR,
"n__amount" VARCHAR,
"invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_august_2015 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"n__supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_august_2016 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"n__supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_august_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"transaction_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"amount" VARCHAR,
"invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_december_2011 (
"department" VARCHAR,
"entity" VARCHAR,
"transaction_date" TIMESTAMP,
"supplier_name" VARCHAR,
"amount" VARCHAR,
"expense_type_published" VARCHAR,
"expense_area" VARCHAR,
"expense_description_published_for_admin_spend_above_25_000_only" VARCHAR,
"transaction_number" BIGINT,
"unnamed_9" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_december_2012 (
"department_family" VARCHAR,
"entity" VARCHAR,
"transaction_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"component_code" VARCHAR,
"amount" VARCHAR,
"invoice_description" VARCHAR,
"unnamed_9" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_december_2013 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_december_2014 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"n__supplier_name" VARCHAR,
"n__component_code" VARCHAR,
"n__amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_december_2015 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"n__supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_december_2016 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"n__supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" VARCHAR,
"n__invoice_description" VARCHAR,
"unnamed_9" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_february_2012 (
"department" VARCHAR,
"entity" VARCHAR,
"transaction_date" BIGINT,
"supplier_name" VARCHAR,
"amount" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"expenses_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_february_2013 (
"dep" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_february_2014 (
"department_family" VARCHAR,
"entity" VARCHAR,
"transaction_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_february_2015 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"n__supplier_name" VARCHAR,
"n__transaction_number" VARCHAR,
"n__amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_february_2016 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"n__supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_january_2012 (
"department" VARCHAR,
"entity" VARCHAR,
"transaction_date" TIMESTAMP,
"supplier_name_published" VARCHAR,
"amount_published" VARCHAR,
"expense_type_published" VARCHAR,
"expense_area_published" VARCHAR,
"expense_description_published_for_admin_spend_above_25_000_only" VARCHAR,
"transaction_number" BIGINT
);
CREATE TABLE details_of_dfid_spend_over_500_january_2013 (
"dep" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_january_2014 (
"department_family" VARCHAR,
"entity" VARCHAR,
"transaction_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_january_2015 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"n__supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_january_2016 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP,
"n__expense_type" VARCHAR,
"n__expense_area" VARCHAR,
"n__supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__amount" VARCHAR,
"n__invoice_description" VARCHAR
);
CREATE TABLE details_of_dfid_spend_over_500_july_2011 (
"department" VARCHAR,
"entity" VARCHAR,
"paid_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"voucher_no" BIGINT,
"amount" DOUBLE
);
CREATE TABLE details_of_dfid_spend_over_500_july_2012 (
"department" VARCHAR,
"entity" VARCHAR,
"transaction_date" TIMESTAMP,
"supplier_name" VARCHAR,
"n__amount" DOUBLE,
"expense_type" VARCHAR,
"expense_area" VARCHAR
);
Anyone who has the link will be able to view this.