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, November 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2015
  • 52.34 kB
  • 1,878 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_november_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 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2016
  • 52.08 kB
  • 2,012 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_november_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, October 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2011
  • 171.81 kB
  • 2,267 rows
  • 229 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_october_2011 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" TIMESTAMP,
  "suppliername" VARCHAR,
  "amount" DOUBLE,
  "expenses_type" VARCHAR,
  "expenses_area" VARCHAR,
  "expenses_description_published_for_admin_spend_above_2_d4965150" VARCHAR  -- Expenses Description (published For Admin Spend Above Ł25,000 Only),
  "transaction_number" DOUBLE,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "unnamed_85" VARCHAR  -- Unnamed: 85,
  "unnamed_86" VARCHAR  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "unnamed_88" VARCHAR  -- Unnamed: 88,
  "unnamed_89" VARCHAR  -- Unnamed: 89,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "unnamed_92" VARCHAR  -- Unnamed: 92,
  "unnamed_93" VARCHAR  -- Unnamed: 93,
  "unnamed_94" VARCHAR  -- Unnamed: 94,
  "unnamed_95" VARCHAR  -- Unnamed: 95,
  "unnamed_96" VARCHAR  -- Unnamed: 96,
  "unnamed_97" VARCHAR  -- Unnamed: 97,
  "unnamed_98" VARCHAR  -- Unnamed: 98,
  "unnamed_99" VARCHAR  -- Unnamed: 99
);

Details Of DFID Spend Over £500, October 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2012
  • 65.22 kB
  • 2,504 rows
  • 13 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_october_2012 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12
);

Details Of DFID Spend Over £500, October 2013

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

Details Of DFID Spend Over £500, October 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2014
  • 65.64 kB
  • 2,759 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_october_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, October 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2015
  • 50.06 kB
  • 1,760 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_october_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,
  "component_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Details Of DFID Spend Over £500, October 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2016
  • 51.03 kB
  • 1,943 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_october_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, September 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2011
  • 53.09 kB
  • 1,950 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_september_2011 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" TIMESTAMP,
  "suppliername" VARCHAR,
  "amount" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "voucher_description_published_admin_over_25000" VARCHAR  -- Voucher Description Published Admin Over Ł25000,
  "transaction_number" BIGINT
);

Details Of DFID Spend Over £500, September 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2012
  • 44.37 kB
  • 1,698 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_september_2012 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" TIMESTAMP,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "n__amount" VARCHAR  -- Amount,
  "n__expense_type" VARCHAR  -- Expense Type,
  "n__expense_area" VARCHAR  -- Expense Area,
  "n__invoice_description" VARCHAR  -- Invoice Description,
  "n__component_code" VARCHAR  -- Component Code
);

Details Of DFID Spend Over £500, September 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2013
  • 52.06 kB
  • 1,961 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_september_2013 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Details Of DFID Spend Over £500, September 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2014
  • 53.06 kB
  • 1,970 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_september_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,
  "n__component_code" VARCHAR  -- Component Code,
  "n__amount" VARCHAR  -- Amount,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Details Of DFID Spend Over £500, September 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2015
  • 46.16 kB
  • 1,596 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_september_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, September 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2016
  • 46.68 kB
  • 1,742 rows
  • 9 columns
Loading... 
CREATE TABLE details_of_dfid_spend_over_500_september_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
);

Spend Transactions By DFID

@ukgov.spend_transactions_by_dfid.spend_transactions_by_dfid
  • 42.77 kB
  • 1,497 rows
  • 9 columns
Loading... 
CREATE TABLE spend_transactions_by_dfid (
  "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.