About this Dataset

Council Spending

The government recommends that local authorities publish expenditure over £500 and all expenditure made on purchasing cards. As of January 2014 and in line with our commitment to openness and transparency we will now be publishing ALL transactions (note; areas may be redacted as they may be commercially sensitive or there may be data protection issues). Local Government Transparency Code 2015 --------------------------------------- * This is a key dataset which the government wants local authorities to publish. * https://www.gov.uk/government/publications/local-government-transparency-code-2015
Publisher name: Leeds City Council
Publisher URL: http://data.europa.eu/88u/.well-known/genid/65b6e73cae57dfb0d51d9da92703d82f
Last updated: 2025-01-28T04:03:51Z

Tables

December 2014

@ukgov.council_spending.december_2014

601.19 kB
27,994 rows
254 columns

CREATE TABLE december_2014 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" DOUBLE,
  "payment_date" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR,
  "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
);

December 2015

@ukgov.council_spending.december_2015

467.26 kB
26,386 rows
15 columns

CREATE TABLE december_2015 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

December 2016

@ukgov.council_spending.december_2016

472.88 kB
27,270 rows
15 columns

CREATE TABLE december_2016 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

December 2017

@ukgov.council_spending.december_2017

425.22 kB
23,606 rows
15 columns

CREATE TABLE december_2017 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

December 2018

@ukgov.council_spending.december_2018

432.56 kB
23,160 rows
15 columns

CREATE TABLE december_2018 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" DOUBLE,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

December 2019

@ukgov.council_spending.december_2019

470.16 kB
26,009 rows
15 columns

CREATE TABLE december_2019 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

December 2020

@ukgov.council_spending.december_2020

445.44 kB
24,758 rows
15 columns

CREATE TABLE december_2020 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" DOUBLE,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "beneficiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

February 2011

@ukgov.council_spending.february_2011

197.42 kB
9,216 rows
12 columns

CREATE TABLE february_2011 (
  "body" VARCHAR,
  "body_name" VARCHAR,
  "service_label" VARCHAR,
  "service_divison_label" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenditure_type" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "date_paid" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "supplier_name" VARCHAR
);

February 2012

@ukgov.council_spending.february_2012

184.12 kB
8,562 rows
13 columns

CREATE TABLE february_2012 (
  "body" VARCHAR,
  "body_name" VARCHAR,
  "service_label" VARCHAR,
  "service_divison_label" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenses_type" VARCHAR,
  "detailed_expense_code" BIGINT,
  "date_paid" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "supplier_name" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12
);

February 2013

@ukgov.council_spending.february_2013

193.07 kB
9,344 rows
12 columns

CREATE TABLE february_2013 (
  "body" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" DOUBLE,
  "datepaid" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR
);

February 2014

@ukgov.council_spending.february_2014

437.76 kB
25,655 rows
12 columns

CREATE TABLE february_2014 (
  "body" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" DOUBLE,
  "datepaid" VARCHAR,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR
);

February 2015

@ukgov.council_spending.february_2015

547.86 kB
24,522 rows
253 columns

CREATE TABLE february_2015 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" DOUBLE,
  "payment_date" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR,
  "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
);

February 2016

@ukgov.council_spending.february_2016

407.56 kB
22,511 rows
15 columns

CREATE TABLE february_2016 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

February 2017

@ukgov.council_spending.february_2017

402.52 kB
22,116 rows
15 columns

CREATE TABLE february_2017 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

February 2018

@ukgov.council_spending.february_2018

417.12 kB
23,188 rows
15 columns

CREATE TABLE february_2018 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" DOUBLE,
  "payment_date" VARCHAR,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

February 2019

@ukgov.council_spending.february_2019

432.47 kB
23,307 rows
15 columns

CREATE TABLE february_2019 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" DOUBLE,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

February 2020

@ukgov.council_spending.february_2020

427.68 kB
23,510 rows
15 columns

CREATE TABLE february_2020 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

February 2021

@ukgov.council_spending.february_2021

360.61 kB
18,661 rows
15 columns

CREATE TABLE february_2021 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" BIGINT,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "beneficiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

January 2011

@ukgov.council_spending.january_2011

195.3 kB
8,837 rows
12 columns

CREATE TABLE january_2011 (
  "body" VARCHAR,
  "body_name" VARCHAR,
  "service_label" VARCHAR,
  "service_division_label" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenditure_type" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "date_paid" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "supplier_name" VARCHAR
);

January 2012

@ukgov.council_spending.january_2012

173.56 kB
8,177 rows
12 columns

CREATE TABLE january_2012 (
  "body" VARCHAR,
  "body_name" VARCHAR,
  "service_label" VARCHAR,
  "service_divison_label" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenses_type" VARCHAR,
  "detailed_expense_code" BIGINT,
  "date_paid" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "supplier_name" VARCHAR
);

January 2013

@ukgov.council_spending.january_2013

175.96 kB
8,273 rows
12 columns

CREATE TABLE january_2013 (
  "body" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" DOUBLE,
  "datepaid" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR
);

January 2014

@ukgov.council_spending.january_2014

369.09 kB
21,222 rows
12 columns

CREATE TABLE january_2014 (
  "body" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" DOUBLE,
  "datepaid" VARCHAR,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR
);

January 2015

@ukgov.council_spending.january_2015

433.16 kB
22,599 rows
253 columns

CREATE TABLE january_2015 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" DOUBLE,
  "payment_date" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR,
  "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
);

January 2016

@ukgov.council_spending.january_2016

367.74 kB
19,988 rows
15 columns

CREATE TABLE january_2016 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

January 2017

@ukgov.council_spending.january_2017

395.1 kB
22,222 rows
15 columns

CREATE TABLE january_2017 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);