Detail Of DFID Spending Over £500: November 2012

@ukgov.spend_transactions_by_dfid.detail_of_dfid_spending_over_500_november_2012

55.46 kB
2,035 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  -- Supplier,
  "transaction_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "n__invoice_description" VARCHAR  -- Invoice Description
);

Details Of DFID Spending Over £500, April 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_april_2019

38.35 kB
1,322 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 Spending Over £500, April 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_april_2020

41.79 kB
1,588 rows
9 columns

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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_august_2019

41.02 kB
1,437 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, December 2018

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_december_2018

49.54 kB
1,952 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 Spending Over £500, December 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_december_2019

48.37 kB
1,716 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 Spending Over £500, February 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_february_2019

41.11 kB
1,474 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 Spending Over £500, February 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_february_2020

37.63 kB
1,284 rows
9 columns

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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_january_2019

40.01 kB
1,428 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 Spending Over £500, January 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_january_2020

36.52 kB
1,220 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, July 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_july_2019

44.11 kB
1,623 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 Spending Over £500, June 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_june_2019

39.5 kB
1,397 rows
9 columns

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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_march_2019

47.2 kB
1,949 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, March 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_march_2020

47.23 kB
1,819 rows
9 columns

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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_may_2019

43.21 kB
1,602 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 Spending Over £500, May 2020

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_may_2020

37.36 kB
1,209 rows
9 columns

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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_november_2019

42 kB
1,463 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

45.19 kB
1,760 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 Spending Over £500, September 2019

@ukgov.spend_transactions_by_dfid.details_of_dfid_spending_over_500_september_2019

35.01 kB
1,013 rows
9 columns

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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2011

44.65 kB
2,324 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  -- Amount
);

Details Of DFID Spend Over £500, April 2012

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2012

39.69 kB
1,750 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 Type .1,
  "expenses_description" VARCHAR
);

Details Of DFID Spend Over £500, April 2013

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2013

53.29 kB
2,006 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  -- Invoice Description
);

Details Of DFID Spend Over £500, April 2014

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2014

50.97 kB
1,943 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, April 2015

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2015

50.97 kB
1,907 rows
9 columns

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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_april_2016

46.87 kB
1,550 rows
9 columns

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

@ukgov.spend_transactions_by_dfid.details_of_dfid_spend_over_500_august_2011

71.34 kB
4,782 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  -- 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Tables