Baselight

Spend Transactions By DFID

Department for International Development

@ukgov.spend_transactions_by_dfid

Loading...
Loading...

About this Dataset

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

Tables

Detail Of DFID Spending Over £500: November 2012

@ukgov.spend_transactions_by_dfid.detail_of_dfid_spending_over_500_november_2012
  • 55.46 kB
  • 2,035 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, April 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_april_2019
  • 38.35 kB
  • 1,322 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, April 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_april_2020
  • 41.79 kB
  • 1,588 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, August 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_august_2019
  • 41.02 kB
  • 1,437 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, December 2018

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_december_2018
  • 49.54 kB
  • 1,952 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, December 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_december_2019
  • 48.37 kB
  • 1,716 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, February 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_february_2019
  • 41.11 kB
  • 1,474 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, February 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_february_2020
  • 37.63 kB
  • 1,284 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, January 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_january_2019
  • 40.01 kB
  • 1,428 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, January 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_january_2020
  • 36.52 kB
  • 1,220 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, July 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_july_2019
  • 44.11 kB
  • 1,623 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, June 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_june_2019
  • 39.5 kB
  • 1,397 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, March 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_march_2019
  • 47.2 kB
  • 1,949 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, March 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_march_2020
  • 47.23 kB
  • 1,819 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, May 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_may_2019
  • 43.21 kB
  • 1,602 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, May 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_may_2020
  • 37.36 kB
  • 1,209 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, November 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_november_2019
  • 42 kB
  • 1,463 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, October 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_october_2019
  • 45.19 kB
  • 1,760 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spending Over £500, September 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_september_2019
  • 35.01 kB
  • 1,013 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spend Over £500, April 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2011
  • 44.65 kB
  • 2,324 rows
  • 8 columns
Loading...
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
);

Details Of DFID Spend Over £500, April 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2012
  • 39.69 kB
  • 1,750 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spend Over £500, April 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2013
  • 53.29 kB
  • 2,006 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spend Over £500, April 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2014
  • 50.97 kB
  • 1,943 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spend Over £500, April 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2015
  • 50.97 kB
  • 1,907 rows
  • 9 columns
Loading...
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
);

Details Of DFID Spend Over £500, April 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2016
  • 46.87 kB
  • 1,550 rows
  • 9 columns
Loading...
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
);

Share link

Anyone who has the link will be able to view this.