Baselight
Sign In

Council Spending

Leeds City Council

@ukgov.council_spending

Loading...
Loading...

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
  • 587.1 KB
  • 27994 rows
  • 254 columns
Loading... 

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

December 2015

@ukgov.council_spending.december_2015
  • 456.31 KB
  • 26386 rows
  • 15 columns
Loading... 

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
  • 461.79 KB
  • 27270 rows
  • 15 columns
Loading... 

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
  • 415.25 KB
  • 23606 rows
  • 15 columns
Loading... 

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
  • 422.42 KB
  • 23160 rows
  • 15 columns
Loading... 

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
  • 459.14 KB
  • 26009 rows
  • 15 columns
Loading... 

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
  • 435 KB
  • 24758 rows
  • 15 columns
Loading... 

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
  • 192.79 KB
  • 9216 rows
  • 12 columns
Loading... 

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
  • 179.81 KB
  • 8562 rows
  • 13 columns
Loading... 

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

February 2013

@ukgov.council_spending.february_2013
  • 188.55 KB
  • 9344 rows
  • 12 columns
Loading... 

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
  • 427.5 KB
  • 25655 rows
  • 12 columns
Loading... 

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
  • 535.02 KB
  • 24522 rows
  • 253 columns
Loading... 

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

February 2016

@ukgov.council_spending.february_2016
  • 398 KB
  • 22511 rows
  • 15 columns
Loading... 

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
  • 393.09 KB
  • 22116 rows
  • 15 columns
Loading... 

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
  • 407.34 KB
  • 23188 rows
  • 15 columns
Loading... 

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
  • 422.33 KB
  • 23307 rows
  • 15 columns
Loading... 

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
  • 417.66 KB
  • 23510 rows
  • 15 columns
Loading... 

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
  • 352.16 KB
  • 18661 rows
  • 15 columns
Loading... 

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
  • 190.72 KB
  • 8837 rows
  • 12 columns
Loading... 

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
  • 169.49 KB
  • 8177 rows
  • 12 columns
Loading... 

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
  • 171.84 KB
  • 8273 rows
  • 12 columns
Loading... 

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
  • 360.44 KB
  • 21222 rows
  • 12 columns
Loading... 

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
  • 423.01 KB
  • 22599 rows
  • 253 columns
Loading... 

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

January 2016

@ukgov.council_spending.january_2016
  • 359.13 KB
  • 19988 rows
  • 15 columns
Loading... 

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
  • 385.84 KB
  • 22222 rows
  • 15 columns
Loading... 

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

Share link

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