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

March 2012

@ukgov.council_spending.march_2012
  • 217.4 kB
  • 10,325 rows
  • 12 columns
Loading... 
CREATE TABLE march_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" VARCHAR,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "supplier_name" VARCHAR
);

March 2013

@ukgov.council_spending.march_2013
  • 204.1 kB
  • 9,830 rows
  • 12 columns
Loading... 
CREATE TABLE march_2013 (
  "body" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" BIGINT,
  "datepaid" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR
);

March 2014

@ukgov.council_spending.march_2014
  • 482.83 kB
  • 28,657 rows
  • 12 columns
Loading... 
CREATE TABLE march_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
);

March 2015

@ukgov.council_spending.march_2015
  • 462.82 kB
  • 26,486 rows
  • 15 columns
Loading... 
CREATE TABLE march_2015 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" VARCHAR,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" VARCHAR,
  "transactionnumber" VARCHAR,
  "irrecoverable_vat_amount" BIGINT,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

March 2016

@ukgov.council_spending.march_2016
  • 479.14 kB
  • 26,728 rows
  • 15 columns
Loading... 
CREATE TABLE march_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" VARCHAR,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" BIGINT,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

March 2017

@ukgov.council_spending.march_2017
  • 470.59 kB
  • 26,594 rows
  • 15 columns
Loading... 
CREATE TABLE march_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
);

March 2018

@ukgov.council_spending.march_2018
  • 467.9 kB
  • 26,246 rows
  • 15 columns
Loading... 
CREATE TABLE march_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
);

March 2019

@ukgov.council_spending.march_2019
  • 457.68 kB
  • 26,341 rows
  • 15 columns
Loading... 
CREATE TABLE march_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
);

March 2020

@ukgov.council_spending.march_2020
  • 463.82 kB
  • 25,914 rows
  • 15 columns
Loading... 
CREATE TABLE march_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,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

March 2021

@ukgov.council_spending.march_2021
  • 446.4 kB
  • 24,192 rows
  • 15 columns
Loading... 
CREATE TABLE march_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" DOUBLE,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "beneficiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

May 2011

@ukgov.council_spending.may_2011
  • 160.87 kB
  • 7,299 rows
  • 12 columns
Loading... 
CREATE TABLE may_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" VARCHAR,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "supplier_name" VARCHAR
);

May 2012

@ukgov.council_spending.may_2012
  • 193.21 kB
  • 9,122 rows
  • 12 columns
Loading... 
CREATE TABLE may_2012 (
  "body" VARCHAR,
  "body_name" VARCHAR,
  "service_label" VARCHAR,
  "service_divison_label" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenses_type" VARCHAR,
  "detailed_expense_code" DOUBLE,
  "date_paid" VARCHAR,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "supplier_name" VARCHAR
);

May 2013

@ukgov.council_spending.may_2013
  • 199.51 kB
  • 9,394 rows
  • 12 columns
Loading... 
CREATE TABLE may_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
);

May 2014

@ukgov.council_spending.may_2014
  • 430.15 kB
  • 25,325 rows
  • 15 columns
Loading... 
CREATE TABLE may_2014 (
  "body" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" BIGINT,
  "datepaid" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" DOUBLE  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

May 2015

@ukgov.council_spending.may_2015
  • 429.02 kB
  • 24,121 rows
  • 15 columns
Loading... 
CREATE TABLE may_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
);

May 2016

@ukgov.council_spending.may_2016
  • 409.44 kB
  • 23,125 rows
  • 15 columns
Loading... 
CREATE TABLE may_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" VARCHAR,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" BIGINT,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

May 2017

@ukgov.council_spending.may_2017
  • 406.85 kB
  • 22,624 rows
  • 15 columns
Loading... 
CREATE TABLE may_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
);

May 2018

@ukgov.council_spending.may_2018
  • 410.47 kB
  • 22,848 rows
  • 15 columns
Loading... 
CREATE TABLE may_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
);

May 2019

@ukgov.council_spending.may_2019
  • 465.02 kB
  • 25,527 rows
  • 15 columns
Loading... 
CREATE TABLE may_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
);

May 2020

@ukgov.council_spending.may_2020
  • 375.96 kB
  • 17,274 rows
  • 256 columns
Loading... 
CREATE TABLE may_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,
  "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
);

May 2021

@ukgov.council_spending.may_2021
  • 374.61 kB
  • 19,057 rows
  • 15 columns
Loading... 
CREATE TABLE may_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" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "beneficiary_name" VARCHAR,
  "procurement_card" VARCHAR
);

November 2011

@ukgov.council_spending.november_2011
  • 191.34 kB
  • 9,279 rows
  • 12 columns
Loading... 
CREATE TABLE november_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
);

November 2012

@ukgov.council_spending.november_2012
  • 207.41 kB
  • 10,050 rows
  • 12 columns
Loading... 
CREATE TABLE november_2012 (
  "body" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" BIGINT,
  "datepaid" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "n__netamount" DOUBLE  -- NetAmount,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR
);

November 2013

@ukgov.council_spending.november_2013
  • 206.54 kB
  • 10,131 rows
  • 12 columns
Loading... 
CREATE TABLE november_2013 (
  "body" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" BIGINT,
  "datepaid" VARCHAR,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR
);

November 2014

@ukgov.council_spending.november_2014
  • 548.28 kB
  • 24,847 rows
  • 251 columns
Loading... 
CREATE TABLE november_2014 (
  "organisation_code" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" DOUBLE,
  "datepaid" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR,
  "procurement_card" VARCHAR,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "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
);

Share link

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