About this Dataset

Procurement Information: Contracts Register

Procurement information including every invitation to tender for contracts to provide goods and/or services with a value that exceeds £5,000.
Publisher name: South Lakeland District Council
Last updated: 2022-07-01T04:04:04Z

Tables

Contracts Register June 2019

@ukgov.procurement_information_contracts_register.contracts_register_june_2019

47.39 kB
131 rows
28 columns

CREATE TABLE contracts_register_june_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "contractreference" VARCHAR,
  "titleoftheagreement" VARCHAR,
  "contracttype" VARCHAR,
  "directorateresponsible" VARCHAR,
  "departmentresponsible" VARCHAR,
  "servicecategory" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "descriptionofgoodsandservices" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procurementclassification_proclasscode" DOUBLE,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "extensiondate" TIMESTAMP,
  "reviewdate" TIMESTAMP,
  "contractvalue" DOUBLE,
  "fixedorestimatedcosts" VARCHAR,
  "irrecoverablevat" BIGINT,
  "suppliername" VARCHAR,
  "companynumber" VARCHAR,
  "charitycommissionnumber" DOUBLE,
  "smesupplier" VARCHAR,
  "vcsesupplier" VARCHAR,
  "vcsesuppliertype" VARCHAR,
  "tenderprocesstype" VARCHAR,
  "originaltenderdocument" VARCHAR
);

Contracts Register November 2019

@ukgov.procurement_information_contracts_register.contracts_register_november_2019

54.94 kB
184 rows
29 columns

CREATE TABLE contracts_register_november_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "contractreference" VARCHAR,
  "titleoftheagreement" VARCHAR,
  "contracttype" VARCHAR,
  "directorateresponsible" VARCHAR,
  "departmentresponsible" VARCHAR,
  "servicecategory" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "descriptionofgoodsandservices" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procurementclassification_proclasscode" DOUBLE,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "extensiondate" TIMESTAMP,
  "reviewdate" TIMESTAMP,
  "contractvalue" VARCHAR,
  "fixedorestimatedcosts" VARCHAR,
  "irrecoverablevat" BIGINT,
  "suppliername" VARCHAR,
  "companynumber" VARCHAR,
  "charitycommissionnumber" BIGINT,
  "smesupplier" DOUBLE,
  "vcsesupplier" VARCHAR,
  "vcsesuppliertype" VARCHAR,
  "tenderprocesstype" VARCHAR,
  "originaltenderdocument" VARCHAR,
  "original_tender_document" VARCHAR
);

Procurement Information: Contracts Register

@ukgov.procurement_information_contracts_register.procurement_information_contracts_register

35.74 kB
54 rows
28 columns

CREATE TABLE procurement_information_contracts_register (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "contractreference" VARCHAR,
  "titleoftheagreement" VARCHAR,
  "contracttype" VARCHAR,
  "directorateresponsible" VARCHAR,
  "servicecategory" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "descriptionofgoodsandservices" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procurementclassification_proclasscode" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "extensiondate" VARCHAR,
  "reviewdate" TIMESTAMP,
  "contractvalue" DOUBLE,
  "fixedorestimated_costs" VARCHAR,
  "irrecoverablevat" DOUBLE,
  "suppliername" VARCHAR,
  "companynumber" VARCHAR,
  "charitycommissionnumber" VARCHAR,
  "smesupplier" VARCHAR,
  "vcsesupplier" VARCHAR,
  "vcsesuppliertype" VARCHAR,
  "tenderprocesstype" VARCHAR,
  "originaltenderdocument" VARCHAR,
  "unnamed_27" VARCHAR  -- Unnamed: 27
);