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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2011
  • 69.67 KB
  • 4782 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
);

Details Of DFID Spend Over £500, August 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2012
  • 41.36 KB
  • 1790 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
  • 51.96 KB
  • 1999 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
  • 52.02 KB
  • 2007 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, August 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2015
  • 46.29 KB
  • 1665 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, August 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2016
  • 42.36 KB
  • 1358 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, August 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2020
  • 33.6 KB
  • 1054 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
  • 50.74 KB
  • 2207 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,
  "transaction_number" BIGINT,
  "unnamed_9" VARCHAR
);

Details Of DFID Spend Over £500, December 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2012
  • 47.97 KB
  • 2002 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
);

Details Of DFID Spend Over £500, December 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2013
  • 52.95 KB
  • 2082 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,
  "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
  • 55.48 KB
  • 2110 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, December 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2015
  • 59.23 KB
  • 2308 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, December 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2016
  • 56.49 KB
  • 2246 rows
  • 10 columns
Loading...

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
);

Details Of DFID Spend Over £500, February 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2012
  • 40.4 KB
  • 2388 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
  • 50.68 KB
  • 1874 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, February 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2014
  • 58.65 KB
  • 2252 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
);

Details Of DFID Spend Over £500, February 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2015
  • 56.59 KB
  • 2255 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, February 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2016
  • 44.08 KB
  • 1532 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, January 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2012
  • 46.47 KB
  • 2051 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,
  "transaction_number" BIGINT
);

Details Of DFID Spend Over £500, January 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2013
  • 54.47 KB
  • 2195 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, January 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2014
  • 63.59 KB
  • 2618 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
);

Details Of DFID Spend Over £500, January 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2015
  • 56.96 KB
  • 2288 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, January 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2016
  • 38.3 KB
  • 1229 rows
  • 9 columns
Loading...

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
);

Details Of DFID Spend Over £500, July 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2011
  • 67.54 KB
  • 4840 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
  • 42.55 KB
  • 2203 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,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR
);

Share link

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