Baselight

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
  • 37.19 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
  • 36.15 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
  • 33.35 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
  • 30.48 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
  • 46.95 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,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

February 2020

@ukgov.payments_to_suppliers_over_250.february_2020
  • 32.63 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
  • 38.8 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
  • 38.55 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
  • 39.17 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
  • 32.61 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.04 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
  • 39.71 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
  • 33.49 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
  • 49.4 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,
  "procurementclassification_proclasslabel" BIGINT,
  "procrementclassification_proclasscode" VARCHAR
);

November 2019

@ukgov.payments_to_suppliers_over_250.november_2019
  • 34.32 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
  • 37.43 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
  • 38.97 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
  • 34.35 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.