Baselight
Sign In

Payments To Suppliers Over £250

South Lakeland District Council

@ukgov.payments_to_suppliers_over_250

Loading...
Loading...

About this Dataset

Payments To Suppliers Over £250

Spending by the council for goods and services over £250. From September 2014 this information meets the standards of the Local Government Transparency Code and includes credit notes.
Publisher name: South Lakeland District Council
Last updated: 2024-09-14T15:01:54Z

Tables

April 2019

@ukgov.payments_to_suppliers_over_250.april_2019
  • 38.08 kB
  • 583 rows
  • 15 columns
Loading... 
CREATE TABLE april_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" VARCHAR,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

August 2019

@ukgov.payments_to_suppliers_over_250.august_2019
  • 37.02 kB
  • 557 rows
  • 15 columns
Loading... 
CREATE TABLE august_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

December 2018

@ukgov.payments_to_suppliers_over_250.december_2018
  • 34.15 kB
  • 524 rows
  • 15 columns
Loading... 
CREATE TABLE december_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" BIGINT,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

December 2019

@ukgov.payments_to_suppliers_over_250.december_2019
  • 31.22 kB
  • 430 rows
  • 15 columns
Loading... 
CREATE TABLE december_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

February 2019

@ukgov.payments_to_suppliers_over_250.february_2019
  • 48.07 kB
  • 604 rows
  • 17 columns
Loading... 
CREATE TABLE february_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" BIGINT,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "purposeofspend_1" VARCHAR,
  "procurement_me" VARCHAR  -- Procurement (Me,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

February 2020

@ukgov.payments_to_suppliers_over_250.february_2020
  • 33.42 kB
  • 450 rows
  • 15 columns
Loading... 
CREATE TABLE february_2020 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

January 2019

@ukgov.payments_to_suppliers_over_250.january_2019
  • 39.74 kB
  • 662 rows
  • 15 columns
Loading... 
CREATE TABLE january_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

January 2020

@ukgov.payments_to_suppliers_over_250.january_2020
  • 39.47 kB
  • 653 rows
  • 15 columns
Loading... 
CREATE TABLE january_2020 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

July 2019

@ukgov.payments_to_suppliers_over_250.july_2019
  • 40.12 kB
  • 677 rows
  • 15 columns
Loading... 
CREATE TABLE july_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

June 2019

@ukgov.payments_to_suppliers_over_250.june_2019
  • 33.4 kB
  • 475 rows
  • 15 columns
Loading... 
CREATE TABLE june_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

March 2019

@ukgov.payments_to_suppliers_over_250.march_2019
  • 38.95 kB
  • 684 rows
  • 15 columns
Loading... 
CREATE TABLE march_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" VARCHAR,
  "transactionnumber" DOUBLE,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" DOUBLE,
  "procrementclassification_proclasscode" VARCHAR
);

March 2020

@ukgov.payments_to_suppliers_over_250.march_2020
  • 40.67 kB
  • 699 rows
  • 15 columns
Loading... 
CREATE TABLE march_2020 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

May 2019

@ukgov.payments_to_suppliers_over_250.may_2019
  • 34.3 kB
  • 542 rows
  • 15 columns
Loading... 
CREATE TABLE may_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

November 2018

@ukgov.payments_to_suppliers_over_250.november_2018
  • 50.59 kB
  • 605 rows
  • 17 columns
Loading... 
CREATE TABLE november_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" VARCHAR,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "purposeofspend_1" VARCHAR,
  "procurement_me" VARCHAR  -- Procurement (Me,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

November 2019

@ukgov.payments_to_suppliers_over_250.november_2019
  • 35.15 kB
  • 513 rows
  • 15 columns
Loading... 
CREATE TABLE november_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

October 2019

@ukgov.payments_to_suppliers_over_250.october_2019
  • 38.33 kB
  • 588 rows
  • 15 columns
Loading... 
CREATE TABLE october_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

Payments To Suppliers Over £250

@ukgov.payments_to_suppliers_over_250.payments_to_suppliers_over_250
  • 39.91 kB
  • 613 rows
  • 15 columns
Loading... 
CREATE TABLE payments_to_suppliers_over_250 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

September 2019

@ukgov.payments_to_suppliers_over_250.september_2019
  • 35.17 kB
  • 580 rows
  • 15 columns
Loading... 
CREATE TABLE september_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "supplierregisteredcompany_number" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionnumber" BIGINT,
  "netamount" DOUBLE,
  "irrecoverablevat" BIGINT,
  "purposeofspend" VARCHAR,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

Share link

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