Spend Transactions By DFID
Department for International Development
@ukgov.spend_transactions_by_dfid
Department for International Development
@ukgov.spend_transactions_by_dfid
A monthly-updated list of all financial transactions spending over a threshold made by the Department for International Development, as part of the Government's commitment to transparency in expenditure. From April 2010 - March 2011 the threshold is £25,000. From April 2011 the threshold is £500.
Publisher name: Department for International Development
Last updated: 2022-07-01T04:02:43Z
CREATE TABLE detail_of_dfid_spending_over_500_november_2012 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"n__supplier" VARCHAR -- Supplier,
"transaction_number" VARCHAR,
"n__amount" VARCHAR -- Amount,
"n__invoice_description" VARCHAR -- Invoice Description
);CREATE TABLE details_of_dfid_spending_over_500_april_2019 (
"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_spending_over_500_april_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP -- Transaction Date,
"n__expense_type" VARCHAR -- Expense Type,
"n__expense_area" VARCHAR -- Expense Area,
"n__supplier_name" VARCHAR -- Supplier Name,
"transaction_number" VARCHAR,
"n__amount" VARCHAR -- Amount,
"n__invoice_description" VARCHAR -- Invoice Description
);CREATE TABLE details_of_dfid_spending_over_500_august_2019 (
"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_spending_over_500_december_2018 (
"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_spending_over_500_december_2019 (
"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_spending_over_500_february_2019 (
"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_spending_over_500_february_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP -- Transaction Date,
"n__expense_type" VARCHAR -- Expense Type,
"n__expense_area" VARCHAR -- Expense Area,
"n__supplier_name" VARCHAR -- Supplier Name,
"transaction_number" VARCHAR,
"n__amount" VARCHAR -- Amount,
"n__invoice_description" VARCHAR -- Invoice Description
);CREATE TABLE details_of_dfid_spending_over_500_january_2019 (
"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_spending_over_500_january_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_spending_over_500_july_2019 (
"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_spending_over_500_june_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP -- Transaction Date,
"n__expense_type" VARCHAR -- Expense Type,
"n__expense_area" VARCHAR -- Expense Area,
"n__supplier_name" VARCHAR -- Supplier Name,
"transaction_number" VARCHAR,
"n__amount" VARCHAR -- Amount,
"n__invoice_description" VARCHAR -- Invoice Description
);CREATE TABLE details_of_dfid_spending_over_500_march_2019 (
"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_spending_over_500_march_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP -- Transaction Date,
"n__expense_type" VARCHAR -- Expense Type,
"n__expense_area" VARCHAR -- Expense Area,
"n__supplier_name" VARCHAR -- Supplier Name,
"transaction_number" VARCHAR,
"n__amount" VARCHAR -- Amount,
"n__invoice_description" VARCHAR -- Invoice Description
);CREATE TABLE details_of_dfid_spending_over_500_may_2019 (
"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_spending_over_500_may_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP -- Transaction Date,
"n__expense_type" VARCHAR -- Expense Type,
"n__expense_area" VARCHAR -- Expense Area,
"n__supplier_name" VARCHAR -- Supplier Name,
"transaction_number" VARCHAR,
"n__amount" VARCHAR -- Amount,
"n__invoice_description" VARCHAR -- Invoice Description
);CREATE TABLE details_of_dfid_spending_over_500_november_2019 (
"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_spending_over_500_october_2019 (
"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_spending_over_500_september_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP -- Transaction Date,
"n__expense_type" VARCHAR -- Expense Type,
"n__expense_area" VARCHAR -- Expense Area,
"n__supplier_name" VARCHAR -- Supplier Name,
"transaction_number" VARCHAR,
"n__amount" VARCHAR -- Amount,
"n__invoice_description" VARCHAR -- Invoice Description
);CREATE TABLE details_of_dfid_spend_over_500_april_2011 (
"department_family" VARCHAR,
"entity" VARCHAR,
"transaction_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"suppliername" VARCHAR,
"transaction_number" DOUBLE,
"n__amount" DOUBLE -- Amount
);CREATE TABLE details_of_dfid_spend_over_500_april_2012 (
"department" VARCHAR,
"entity" VARCHAR,
"transaction_date" TIMESTAMP,
"supplier_name" VARCHAR,
"amount" VARCHAR,
"expenses_type" VARCHAR,
"expenses_area" VARCHAR,
"expenses_type_1" VARCHAR -- Expenses Type .1,
"expenses_description" VARCHAR
);CREATE TABLE details_of_dfid_spend_over_500_april_2013 (
"department" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"component_code" VARCHAR,
"amount" VARCHAR,
"n__invoice_description" VARCHAR -- Invoice Description
);CREATE TABLE details_of_dfid_spend_over_500_april_2014 (
"department_family" 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_april_2015 (
"dfid" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP -- Transaction Date,
"n__expense_type" VARCHAR -- Expense Type,
"n__expense_area" VARCHAR -- Expense Area,
"n__supplier_name" VARCHAR -- Supplier Name,
"transaction_number" VARCHAR,
"n__amount" VARCHAR -- Amount,
"n__invoice_description" VARCHAR -- Invoice Description
);CREATE TABLE details_of_dfid_spend_over_500_april_2016 (
"department" VARCHAR,
"entity" VARCHAR,
"n__transaction_date" TIMESTAMP -- Transaction Date,
"n__expense_type" VARCHAR -- Expense Type,
"n__expense_area" VARCHAR -- Expense Area,
"n__supplier_name" VARCHAR -- Supplier Name,
"transaction_number" VARCHAR,
"n__amount" VARCHAR -- Amount,
"n__invoice_description" VARCHAR -- Invoice Description
);Anyone who has the link will be able to view this.