Baselight
Sign In

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, August 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2011
  • 71.34 kB
  • 4,782 rows
  • 9 columns
Loading... 
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  -- Amount
);

Details Of DFID Spend Over £500, August 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2012
  • 42.35 kB
  • 1,790 rows
  • 7 columns
Loading... 
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
);

Details Of DFID Spend Over £500, August 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2013
  • 53.2 kB
  • 1,999 rows
  • 9 columns
Loading... 
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
);

Details Of DFID Spend Over £500, August 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2014
  • 53.27 kB
  • 2,007 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_august_2014 (
  "department_family" 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,
  "invoice_description" VARCHAR
);

Details Of DFID Spend Over £500, August 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2015
  • 47.41 kB
  • 1,665 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_august_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, August 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2016
  • 43.38 kB
  • 1,358 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_august_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, August 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2020
  • 34.41 kB
  • 1,054 rows
  • 9 columns
Loading... 
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
);

Details Of DFID Spend Over £500, December 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2011
  • 51.95 kB
  • 2,207 rows
  • 10 columns
Loading... 
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  -- Expense Description Published For Admin Spend Above £25,000 Only,
  "transaction_number" BIGINT,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

Details Of DFID Spend Over £500, December 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2012
  • 49.12 kB
  • 2,002 rows
  • 10 columns
Loading... 
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  -- Unnamed: 9
);

Details Of DFID Spend Over £500, December 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2013
  • 54.22 kB
  • 2,082 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_december_2013 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "n__expense_area" VARCHAR  -- Expense Area,
  "supplier_name" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Details Of DFID Spend Over £500, December 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2014
  • 56.81 kB
  • 2,110 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_december_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
);

Details Of DFID Spend Over £500, December 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2015
  • 60.65 kB
  • 2,308 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_december_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, December 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2016
  • 57.85 kB
  • 2,246 rows
  • 10 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_december_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,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

Details Of DFID Spend Over £500, February 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2012
  • 41.37 kB
  • 2,388 rows
  • 8 columns
Loading... 
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
);

Details Of DFID Spend Over £500, February 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2013
  • 51.9 kB
  • 1,874 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_february_2013 (
  "dep" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "n__expense_type" VARCHAR  -- Expense Type,
  "n__expense_area" VARCHAR  -- Expense Area,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Details Of DFID Spend Over £500, February 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2014
  • 60.06 kB
  • 2,252 rows
  • 9 columns
Loading... 
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  -- Invoice Description
);

Details Of DFID Spend Over £500, February 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2015
  • 57.95 kB
  • 2,255 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_february_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,
  "n__transaction_number" VARCHAR  -- Transaction Number,
  "n__amount" VARCHAR  -- Amount,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Details Of DFID Spend Over £500, February 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2016
  • 45.14 kB
  • 1,532 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_february_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, January 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2012
  • 47.59 kB
  • 2,051 rows
  • 9 columns
Loading... 
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  -- Expense Description Published For Admin Spend Above Ł25,000 Only,
  "transaction_number" BIGINT
);

Details Of DFID Spend Over £500, January 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2013
  • 55.78 kB
  • 2,195 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_january_2013 (
  "dep" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "n__expense_type" VARCHAR  -- Expense Type,
  "n__expense_area" VARCHAR  -- Expense Area,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Details Of DFID Spend Over £500, January 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2014
  • 65.11 kB
  • 2,618 rows
  • 9 columns
Loading... 
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  -- Invoice Description
);

Details Of DFID Spend Over £500, January 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2015
  • 58.33 kB
  • 2,288 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_january_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, January 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2016
  • 39.22 kB
  • 1,229 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_january_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 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2011
  • 69.17 kB
  • 4,840 rows
  • 8 columns
Loading... 
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
);

Details Of DFID Spend Over £500, July 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2012
  • 43.57 kB
  • 2,203 rows
  • 7 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_july_2012 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "n__amount" DOUBLE  -- Amount,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR
);

Share link

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