Payments To Suppliers Over £250
South Lakeland District Council
@ukgov.payments_to_suppliers_over_250
South Lakeland District Council
@ukgov.payments_to_suppliers_over_250
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
Anyone who has the link will be able to view this.