Spend Transactions By DFID by UK Government | Finance and Economics

Details Of DFID Spend Over £500, March 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_march_2016

47.86 KB
1776 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_march_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, May 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_may_2014

53.45 KB
2254 rows
9 columns


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

Spend Transactions By DFID

@ukgov.spend_transactions_by_dfid.spend_transactions_by_dfid

41.77 KB
1497 rows
9 columns


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

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


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2015

51.11 KB
1878 rows
9 columns


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, January 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2016

38.3 KB
1229 rows
9 columns


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, December 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2016

56.49 KB
2246 rows
10 columns


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 Spending Over £500, March 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_march_2019

46.1 KB
1949 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_march_2019 (
  "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 Spending Over £500, November 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_november_2019

41.01 KB
1463 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_november_2019 (
  "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 Spending Over £500, October 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_october_2019

44.13 KB
1760 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_october_2019 (
  "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, August 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2012

41.36 KB
1790 rows
7 columns


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, December 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2014

55.48 KB
2110 rows
9 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_march_2015

65.11 KB
2793 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_march_2015 (
  "department" VARCHAR,
  "entitly" 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 Spending Over £500, July 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_july_2019

43.08 KB
1623 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_july_2019 (
  "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, April 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2011

43.6 KB
2324 rows
8 columns


CREATE TABLE details_of_dfid_spend_over_500_april_2011 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "suppliername" VARCHAR,
  "transaction_number" DOUBLE,
  "n__amount" DOUBLE
);

Details Of DFID Spend Over £500, March 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_march_2012

44.31 KB
2472 rows
8 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2013

51.96 KB
1999 rows
9 columns


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, September 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2013

50.84 KB
1961 rows
9 columns


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, February 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2012

40.4 KB
2388 rows
8 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2014

59.21 KB
2277 rows
9 columns


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

Detail Of DFID Spending Over £500: November 2012

@ukgov.spend_transactions_by_dfid.detail_of_dfid_spending_over_500_november_2012

54.16 KB
2035 rows
9 columns


CREATE TABLE detail_of_dfid_spending_over_500_november_2012 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "n__supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount" VARCHAR,
  "n__invoice_description" VARCHAR
);

Details Of DFID Spend Over £500, April 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2015

49.77 KB
1907 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_april_2015 (
  "dfid" 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 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2020

37.02 KB
1256 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_july_2020 (
  "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 Spending Over £500, September 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_september_2019

34.18 KB
1013 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_september_2019 (
  "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 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2013

54.47 KB
2195 rows
9 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2015

56.59 KB
2255 rows
9 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2011

167.78 KB
2267 rows
229 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2020

33.6 KB
1054 rows
9 columns


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, April 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2013

52.04 KB
2006 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_april_2013 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "component_code" VARCHAR,
  "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


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, March 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_march_2013

63.55 KB
2673 rows
9 columns


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,
  "n__invoice_description" VARCHAR
);

Details Of DFID Spend Over £500, June 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2012

36.77 KB
1803 rows
8 columns


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, April 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2014

49.77 KB
1943 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_april_2014 (
  "department_family" 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


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


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2015

53.16 KB
2016 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_july_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 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2014

51.82 KB
1970 rows
9 columns


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 Spending Over £500, March 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_march_2020

46.12 KB
1819 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_march_2020 (
  "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


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

Details Of DFID Spending Over £500, April 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_april_2019

37.45 KB
1322 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_april_2019 (
  "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, August 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2015

46.29 KB
1665 rows
9 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2015

56.96 KB
2288 rows
9 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2016

50.86 KB
2012 rows
9 columns


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, July 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2014

58.62 KB
2504 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_july_2014 (
  "department_entity" 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, February 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2014

58.65 KB
2252 rows
9 columns


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 Spending Over £500, December 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_december_2019

47.24 KB
1716 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_december_2019 (
  "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, September 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_september_2011

51.85 KB
1950 rows
9 columns


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, February 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2016

44.08 KB
1532 rows
9 columns


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 Spending Over £500, August 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_august_2019

40.06 KB
1437 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_august_2019 (
  "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 Spending Over £500, January 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_january_2019

39.08 KB
1428 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_january_2019 (
  "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, April 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2012

38.76 KB
1750 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_april_2012 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "transaction_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "amount" VARCHAR,
  "expenses_type" VARCHAR,
  "expenses_area" VARCHAR,
  "expenses_type_1" VARCHAR,
  "expenses_description" VARCHAR
);

Details Of DFID Spending Over £500, May 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_may_2019

42.19 KB
1602 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_may_2019 (
  "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, January 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2014

63.59 KB
2618 rows
9 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2013

59.31 KB
2331 rows
9 columns


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

Details Of DFID Spend Over £500, November 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_november_2011

51.92 KB
2079 rows
8 columns


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, January 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_january_2012

46.47 KB
2051 rows
9 columns


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 Spending Over £500, January 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_january_2020

35.67 KB
1220 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_january_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 Spending Over £500, April 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_april_2020

40.81 KB
1588 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_april_2020 (
  "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, April 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2016

45.77 KB
1550 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_april_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 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2012

63.69 KB
2504 rows
13 columns


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


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, May 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_may_2012

45.16 KB
1820 rows
9 columns


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, October 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2014

64.1 KB
2759 rows
9 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2011

69.67 KB
4782 rows
9 columns


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 Spending Over £500, May 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_may_2020

36.48 KB
1209 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_may_2020 (
  "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 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2016

49.83 KB
1943 rows
9 columns


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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2011

67.72 KB
5271 rows
8 columns


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 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2016

43.94 KB
1599 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_june_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, March 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_march_2014

58.14 KB
2286 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_march_2014 (
  "n" 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 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_october_2015

48.89 KB
1760 rows
9 columns


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, December 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2013

52.95 KB
2082 rows
9 columns


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 Spending Over £500, February 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_february_2020

36.75 KB
1284 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_february_2020 (
  "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, May 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_may_2013

52.91 KB
2128 rows
9 columns


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,
  "description" VARCHAR
);

Details Of DFID Spend Over £500, July 2016

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2016

43.6 KB
1650 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_july_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, June 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2020

37.42 KB
1352 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_june_2020 (
  "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 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2014

52.02 KB
2007 rows
9 columns


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, July 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2013

58.51 KB
2357 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_july_2013 (
  "dept_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount" VARCHAR,
  "invoice_description" VARCHAR
);

Details Of DFID Spend Over £500, May 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_may_2011

56.71 KB
3333 rows
8 columns


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

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


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, June 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2014

55.57 KB
2323 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_june_2014 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "n__transaction_date" VARCHAR,
  "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, June 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2015

50.02 KB
2018 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_june_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, February 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_february_2013

50.68 KB
1874 rows
9 columns


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, July 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2012

42.55 KB
2203 rows
7 columns


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

Details Of DFID Spend Over £500, June 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_june_2013

50.58 KB
1944 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_june_2013 (
  "department" VARCHAR,
  "family" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "n__expense_area" VARCHAR,
  "supplier_name_withheld" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount" VARCHAR,
  "description" VARCHAR
);

Details Of DFID Spending Over £500, June 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_june_2019

38.57 KB
1397 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_june_2019 (
  "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, May 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_may_2015

48.56 KB
1791 rows
9 columns


CREATE TABLE details_of_dfid_spend_over_500_may_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 Spending Over £500, December 2018

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_december_2018

48.38 KB
1952 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_december_2018 (
  "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 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_december_2015

59.23 KB
2308 rows
9 columns


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 Spending Over £500, February 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_february_2019

40.15 KB
1474 rows
9 columns


CREATE TABLE details_of_dfid_spending_over_500_february_2019 (
  "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, July 2011

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_july_2011

67.54 KB
4840 rows
8 columns


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