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

Details Of DFID Spend Over £500, July 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2013
  • 59.91 kB
  • 2,357 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_july_2013 (
  "dept_family" VARCHAR  -- Dept. Family,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "invoice_description" VARCHAR
);

Details Of DFID Spend Over £500, July 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2014
  • 60.03 kB
  • 2,504 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_july_2014 (
  "department_entity" 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, July 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2015
  • 54.44 kB
  • 2,016 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_july_2015 (
  "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, July 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2016
  • 44.64 kB
  • 1,650 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_july_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
);

Details Of DFID Spend Over £500, July 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2020
  • 37.91 kB
  • 1,256 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_july_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 Spend Over £500, June 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2011
  • 69.35 kB
  • 5,271 rows
  • 8 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_june_2011 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "paiddate" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "suppliername" VARCHAR,
  "voucher_no" BIGINT,
  "amount" DOUBLE
);

Details Of DFID Spend Over £500, June 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2012
  • 37.66 kB
  • 1,803 rows
  • 8 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_june_2012 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "amount" VARCHAR,
  "expenses_type" VARCHAR,
  "expenses_area" VARCHAR,
  "transaction_description" VARCHAR
);

Details Of DFID Spend Over £500, June 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2013
  • 51.8 kB
  • 1,944 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_june_2013 (
  "department" VARCHAR,
  "family" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "n__expense_area" VARCHAR  -- Expense Area,
  "supplier_name_withheld" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "description" VARCHAR
);

Details Of DFID Spend Over £500, June 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2014
  • 56.9 kB
  • 2,323 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_june_2014 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "n__transaction_date" VARCHAR  -- Transaction Date,
  "n__expense_type" VARCHAR  -- Expense Type,
  "n__expense_area" VARCHAR  -- Expense Area,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "n__component_code" VARCHAR  -- Component Code,
  "n__amount" VARCHAR  -- Amount,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Details Of DFID Spend Over £500, June 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2015
  • 51.22 kB
  • 2,018 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_june_2015 (
  "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, June 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2016
  • 45 kB
  • 1,599 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_june_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
);

Details Of DFID Spend Over £500, June 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2020
  • 38.31 kB
  • 1,352 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_june_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 Spend Over £500, March 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_march_2012
  • 45.37 kB
  • 2,472 rows
  • 8 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_march_2012 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" VARCHAR,
  "supplier_name" VARCHAR,
  "amount" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "expense_description" VARCHAR
);

Details Of DFID Spend Over £500, March 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_march_2013
  • 65.08 kB
  • 2,673 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_march_2013 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Details Of DFID Spend Over £500, March 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_march_2014
  • 59.53 kB
  • 2,286 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_march_2014 (
  "n" 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, March 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_march_2015
  • 66.68 kB
  • 2,793 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_march_2015 (
  "department" VARCHAR,
  "entitly" 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, March 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_march_2016
  • 49.01 kB
  • 1,776 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_march_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
);

Details Of DFID Spend Over £500, May 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_may_2011
  • 58.07 kB
  • 3,333 rows
  • 8 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_may_2011 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "suppliername" VARCHAR,
  "transaction_number" BIGINT,
  "n__amount" DOUBLE  -- Amount
);

Details Of DFID Spend Over £500, May 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_may_2012
  • 46.24 kB
  • 1,820 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_may_2012 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" VARCHAR,
  "supplier_name" VARCHAR,
  "amount" VARCHAR,
  "expenses_type" VARCHAR,
  "expenses_area" VARCHAR,
  "expenses_description" VARCHAR,
  "component_code" VARCHAR
);

Details Of DFID Spend Over £500, May 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_may_2013
  • 54.18 kB
  • 2,128 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_may_2013 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "description" VARCHAR
);

Details Of DFID Spend Over £500, May 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_may_2014
  • 54.73 kB
  • 2,254 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_may_2014 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" VARCHAR,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Details Of DFID Spend Over £500, May 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_may_2015
  • 49.73 kB
  • 1,791 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_may_2015 (
  "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, November 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2011
  • 53.16 kB
  • 2,079 rows
  • 8 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_november_2011 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "trasnsaction_number" DOUBLE,
  "amount" VARCHAR
);

Details Of DFID Spend Over £500, November 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2013
  • 60.74 kB
  • 2,331 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_november_2013 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" VARCHAR,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Details Of DFID Spend Over £500, November 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2014
  • 60.63 kB
  • 2,277 rows
  • 9 columns
Loading...
CREATE TABLE details_of_dfid_spend_over_500_november_2014 (
  "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,
  "n__component_code" VARCHAR  -- Component Code,
  "n__amount" VARCHAR  -- Amount,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Share link

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