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
  • 51.11 KB
  • 1878 rows
  • 9 columns
Loading... 

CREATE TABLE details_of_dfid_spend_over_500_november_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, November 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2016
  • 50.86 KB
  • 2012 rows
  • 9 columns
Loading... 

CREATE TABLE details_of_dfid_spend_over_500_november_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, October 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2011
  • 167.78 KB
  • 2267 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,
  "transaction_number" DOUBLE,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" VARCHAR,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" VARCHAR,
  "unnamed_99" VARCHAR
);

Details Of DFID Spend Over £500, October 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2012
  • 63.69 KB
  • 2504 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_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR
);

Details Of DFID Spend Over £500, October 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2013
  • 58.12 KB
  • 2349 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,
  "n__invoice_description" VARCHAR
);

Details Of DFID Spend Over £500, October 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2014
  • 64.1 KB
  • 2759 rows
  • 9 columns
Loading... 

CREATE TABLE details_of_dfid_spend_over_500_october_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, October 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2015
  • 48.89 KB
  • 1760 rows
  • 9 columns
Loading... 

CREATE TABLE details_of_dfid_spend_over_500_october_2015 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "n__transaction_date" TIMESTAMP,
  "n__expense_type" VARCHAR,
  "n__expense_area" VARCHAR,
  "n__supplier_name" VARCHAR,
  "component_number" VARCHAR,
  "n__amount" VARCHAR,
  "n__invoice_description" VARCHAR
);

Details Of DFID Spend Over £500, October 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2016
  • 49.83 KB
  • 1943 rows
  • 9 columns
Loading... 

CREATE TABLE details_of_dfid_spend_over_500_october_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, September 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2011
  • 51.85 KB
  • 1950 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,
  "transaction_number" BIGINT
);

Details Of DFID Spend Over £500, September 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2012
  • 43.33 KB
  • 1698 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,
  "n__amount" VARCHAR,
  "n__expense_type" VARCHAR,
  "n__expense_area" VARCHAR,
  "n__invoice_description" VARCHAR,
  "n__component_code" VARCHAR
);

Details Of DFID Spend Over £500, September 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2013
  • 50.84 KB
  • 1961 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,
  "n__invoice_description" VARCHAR
);

Details Of DFID Spend Over £500, September 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2014
  • 51.82 KB
  • 1970 rows
  • 9 columns
Loading... 

CREATE TABLE details_of_dfid_spend_over_500_september_2014 (
  "department_entity" 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, September 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2015
  • 45.08 KB
  • 1596 rows
  • 9 columns
Loading... 

CREATE TABLE details_of_dfid_spend_over_500_september_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, September 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2016
  • 45.59 KB
  • 1742 rows
  • 9 columns
Loading... 

CREATE TABLE details_of_dfid_spend_over_500_september_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
);

Spend Transactions By DFID

@ukgov.spend_transactions_by_dfid.spend_transactions_by_dfid
  • 41.77 KB
  • 1497 rows
  • 9 columns
Loading... 

CREATE TABLE spend_transactions_by_dfid (
  "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
);

Share link

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