Contracts Register - Other
Leeds City Council
@ukgov.contracts_register_other
Leeds City Council
@ukgov.contracts_register_other
This dataset lists all contracts currently in place with Leeds City Council as well as expired contracts for the previous month where no tender process has been run e.g. 3 quote process. Information includes title of contact, contractor, start and end dates, and estimated value. 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/04b13d6efb916a019d46b39345af2ea9
Last updated: 2024-09-14T10:14:07Z
CREATE TABLE april2015 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" VARCHAR,
"contractreference" VARCHAR,
"contracttitle" VARCHAR,
"organisationalunit" VARCHAR,
"description" VARCHAR,
"procurementcategory" VARCHAR,
"startdate" TIMESTAMP,
"enddate" VARCHAR,
"reviewdate" VARCHAR,
"optiontoextend" VARCHAR,
"extensionperiod" VARCHAR,
"contractvalue" VARCHAR,
"irrecoverablevat" VARCHAR,
"suppliername" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR,
"vcsesupplier" VARCHAR,
"contactname" VARCHAR,
"processtype" VARCHAR
);CREATE TABLE april_2016 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contractreference" VARCHAR,
"contracttitle" VARCHAR,
"organisationalunit" VARCHAR,
"description" VARCHAR,
"procurementcategory" VARCHAR,
"startdate" TIMESTAMP,
"enddate" VARCHAR,
"reviewdate" VARCHAR,
"optiontoextend" VARCHAR,
"extensionperiod" VARCHAR,
"contractvalue" DOUBLE,
"irrecoverablevat" VARCHAR,
"suppliername" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR,
"vcsesupplier" VARCHAR,
"contactname" VARCHAR,
"processtype" VARCHAR
);CREATE TABLE april_2018 (
"old_column_name" VARCHAR -- Old Column Name >,
"council" VARCHAR,
"new" VARCHAR,
"new_1" VARCHAR,
"contract_reference" VARCHAR,
"contract_title" VARCHAR,
"organisational_unit" VARCHAR,
"description" VARCHAR,
"category" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"review_date" VARCHAR,
"option_to_extend" VARCHAR,
"available_extension" VARCHAR,
"estimated_total_contract_value" VARCHAR,
"irrecoverable_vat" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_charity_commission_no" VARCHAR -- Company Registration/ Charity Commission No,
"supplier_classification" VARCHAR,
"supplier_classification_1" VARCHAR,
"contact_details" VARCHAR,
"process_type" VARCHAR
);CREATE TABLE april_2021 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contracttitle" VARCHAR,
"description" VARCHAR,
"startdate" TIMESTAMP,
"contractvalue" VARCHAR,
"contactname" VARCHAR,
"organisationalunit" VARCHAR,
"contractreference" VARCHAR,
"suppliername" VARCHAR,
"vcsesupplier" VARCHAR,
"procurementtype" VARCHAR
);CREATE TABLE august_2017 (
"old_column_name" VARCHAR -- Old Column Name >,
"council" VARCHAR,
"new" VARCHAR,
"new_1" VARCHAR,
"contract_reference" VARCHAR,
"contract_title" VARCHAR,
"organisational_unit" VARCHAR,
"description" VARCHAR,
"category" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"review_date" VARCHAR,
"option_to_extend" VARCHAR,
"available_extension" VARCHAR,
"estimated_total_contract_value" VARCHAR,
"irrecoverable_vat" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_charity_commission_no" VARCHAR -- Company Registration/ Charity Commission No,
"supplier_classification" VARCHAR,
"supplier_classification_1" VARCHAR,
"contact_details" VARCHAR,
"process_type" VARCHAR
);CREATE TABLE august_2019 (
"old_column_name" VARCHAR -- Old Column Name >,
"council" VARCHAR,
"new" VARCHAR,
"new_1" VARCHAR,
"contract_title" VARCHAR,
"description" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"review_date" VARCHAR,
"option_to_extend" VARCHAR,
"estimated_total_contract_value" VARCHAR,
"irrecoverable_vat" VARCHAR,
"contact_details" VARCHAR,
"organisational_unit" VARCHAR,
"contract_reference" VARCHAR,
"supplier_name" VARCHAR,
"supplier_classification" VARCHAR,
"process_type" VARCHAR,
"category" VARCHAR,
"available_extension" VARCHAR,
"company_registration_charity_commission_no" VARCHAR -- Company Registration/ Charity Commission No,
"supplier_classification_1" VARCHAR
);CREATE TABLE august_2020 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contracttitle" VARCHAR,
"description" VARCHAR,
"startdate" TIMESTAMP,
"contractvalue" VARCHAR,
"contactname" VARCHAR,
"organisationalunit" VARCHAR,
"contractreference" VARCHAR,
"suppliername" VARCHAR,
"vcsesupplier" VARCHAR,
"processtype" VARCHAR
);CREATE TABLE december_2015 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contractreference" VARCHAR,
"contracttitle" VARCHAR,
"organisationalunit" VARCHAR,
"description" VARCHAR,
"procurementcategory" VARCHAR,
"startdate" TIMESTAMP,
"enddate" VARCHAR,
"reviewdate" VARCHAR,
"optiontoextend" VARCHAR,
"extensionperiod" VARCHAR,
"contractvalue" VARCHAR,
"irrecoverablevat" VARCHAR,
"suppliername" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR,
"vcsesupplier" VARCHAR,
"contactname" VARCHAR,
"processtype" VARCHAR
);CREATE TABLE december_2017 (
"old_column_name" VARCHAR -- Old Column Name >,
"council" VARCHAR,
"new" VARCHAR,
"new_1" VARCHAR,
"contract_reference" VARCHAR,
"contract_title" VARCHAR,
"organisational_unit" VARCHAR,
"description" VARCHAR,
"category" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"review_date" VARCHAR,
"option_to_extend" VARCHAR,
"available_extension" VARCHAR,
"estimated_total_contract_value" VARCHAR,
"irrecoverable_vat" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_charity_commission_no" VARCHAR -- Company Registration/ Charity Commission No,
"supplier_classification" VARCHAR,
"supplier_classification_1" VARCHAR,
"contact_details" VARCHAR,
"process_type" VARCHAR
);CREATE TABLE december_2020 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contracttitle" VARCHAR,
"description" VARCHAR,
"startdate" TIMESTAMP,
"contractvalue" VARCHAR,
"contactname" VARCHAR,
"organisationalunit" VARCHAR,
"contractreference" VARCHAR,
"suppliername" VARCHAR,
"vcsesupplier" VARCHAR,
"procurementtype" VARCHAR
);CREATE TABLE february_2015 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contractreference" VARCHAR,
"contracttitle" VARCHAR,
"organisationalunit" VARCHAR,
"description" VARCHAR,
"procurementcategory" VARCHAR,
"startdate" TIMESTAMP,
"enddate" VARCHAR,
"reviewdate" VARCHAR,
"optiontoextend" VARCHAR,
"extensionperiod" VARCHAR,
"contractvalue" VARCHAR,
"irrecoverablevat" VARCHAR,
"suppliername" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR,
"vcsesupplier" VARCHAR,
"contactname" VARCHAR,
"processtype" VARCHAR
);CREATE TABLE february_2016 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contractreference" VARCHAR,
"contracttitle" VARCHAR,
"organisationalunit" VARCHAR,
"description" VARCHAR,
"procurementcategory" VARCHAR,
"startdate" TIMESTAMP,
"enddate" VARCHAR,
"reviewdate" VARCHAR,
"optiontoextend" VARCHAR,
"extensionperiod" VARCHAR,
"contractvalue" DOUBLE,
"irrecoverablevat" VARCHAR,
"suppliername" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR,
"vcsesupplier" VARCHAR,
"contactname" VARCHAR,
"processtype" VARCHAR
);CREATE TABLE february_2017 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" VARCHAR,
"contractreference" VARCHAR,
"contracttitle" VARCHAR,
"organisationalunit" VARCHAR,
"description" VARCHAR,
"procurementcategory" VARCHAR,
"startdate" TIMESTAMP,
"enddate" VARCHAR,
"reviewdate" VARCHAR,
"optiontoextend" VARCHAR,
"extensionperiod" VARCHAR,
"contractvalue" VARCHAR,
"irrecoverablevat" VARCHAR,
"suppliername" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR,
"vcsesupplier" VARCHAR,
"contactname" VARCHAR,
"processtype" VARCHAR
);CREATE TABLE february_2018 (
"old_column_name" VARCHAR -- Old Column Name >,
"council" VARCHAR,
"new" VARCHAR,
"new_1" VARCHAR,
"contract_reference" VARCHAR,
"contract_title" VARCHAR,
"organisational_unit" VARCHAR,
"description" VARCHAR,
"category" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"review_date" VARCHAR,
"option_to_extend" VARCHAR,
"available_extension" VARCHAR,
"estimated_total_contract_value" VARCHAR,
"irrecoverable_vat" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_charity_commission_no" VARCHAR -- Company Registration/ Charity Commission No,
"supplier_classification" VARCHAR,
"supplier_classification_1" VARCHAR,
"contact_details" VARCHAR,
"process_type" VARCHAR
);CREATE TABLE february_2020 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contracttitle" VARCHAR,
"description" VARCHAR,
"startdate" TIMESTAMP,
"contractvalue" VARCHAR,
"contactname" VARCHAR,
"organisationalunit" VARCHAR,
"contractreference" VARCHAR,
"suppliername" VARCHAR,
"vcsesupplier" VARCHAR,
"processtype" VARCHAR,
"procurementcategory" VARCHAR,
"extensionperiod" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR
);CREATE TABLE february_2021 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contracttitle" VARCHAR,
"description" VARCHAR,
"startdate" VARCHAR,
"contractvalue" VARCHAR,
"contactname" VARCHAR,
"organisationalunit" VARCHAR,
"contractreference" VARCHAR,
"suppliername" VARCHAR,
"vcsesupplier" VARCHAR,
"procurementtype" VARCHAR
);CREATE TABLE january_2015 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contractreference" VARCHAR,
"contracttitle" VARCHAR,
"organisationalunit" VARCHAR,
"description" VARCHAR,
"procurementcategory" VARCHAR,
"startdate" TIMESTAMP,
"enddate" VARCHAR,
"reviewdate" VARCHAR,
"optiontoextend" VARCHAR,
"extensionperiod" VARCHAR,
"contractvalue" VARCHAR,
"irrecoverablevat" VARCHAR,
"suppliername" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR,
"vcsesupplier" VARCHAR,
"contactname" VARCHAR,
"processtype" VARCHAR
);CREATE TABLE january_2018 (
"old_column_name" VARCHAR -- Old Column Name >,
"council" VARCHAR,
"new" VARCHAR,
"new_1" VARCHAR,
"contract_reference" VARCHAR,
"contract_title" VARCHAR,
"organisational_unit" VARCHAR,
"description" VARCHAR,
"category" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"review_date" VARCHAR,
"option_to_extend" VARCHAR,
"available_extension" VARCHAR,
"estimated_total_contract_value" VARCHAR,
"irrecoverable_vat" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_charity_commission_no" VARCHAR -- Company Registration/ Charity Commission No,
"supplier_classification" VARCHAR,
"supplier_classification_1" VARCHAR,
"contact_details" VARCHAR,
"process_type" VARCHAR
);CREATE TABLE january_2019 (
"old_column_name" VARCHAR -- Old Column Name >,
"council" VARCHAR,
"new" VARCHAR,
"new_1" VARCHAR,
"contract_reference" VARCHAR,
"contract_title" VARCHAR,
"organisational_unit" VARCHAR,
"description" VARCHAR,
"category" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"review_date" VARCHAR,
"option_to_extend" VARCHAR,
"available_extension" VARCHAR,
"estimated_total_contract_value" VARCHAR,
"irrecoverable_vat" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_charity_commission_no" VARCHAR -- Company Registration/ Charity Commission No,
"supplier_classification" VARCHAR,
"supplier_classification_1" VARCHAR,
"contact_details" VARCHAR,
"process_type" VARCHAR
);CREATE TABLE january_2020 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contracttitle" VARCHAR,
"description" VARCHAR,
"startdate" TIMESTAMP,
"contractvalue" VARCHAR,
"contactname" VARCHAR,
"organisationalunit" VARCHAR,
"contractreference" VARCHAR,
"suppliername" VARCHAR,
"vcsesupplier" VARCHAR,
"processtype" VARCHAR,
"procurementcategory" VARCHAR,
"extensionperiod" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR
);CREATE TABLE july_2016 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contractreference" VARCHAR,
"contracttitle" VARCHAR,
"organisationalunit" VARCHAR,
"description" VARCHAR,
"procurementcategory" VARCHAR,
"startdate" TIMESTAMP,
"enddate" VARCHAR,
"reviewdate" VARCHAR,
"optiontoextend" VARCHAR,
"extensionperiod" VARCHAR,
"contractvalue" VARCHAR,
"irrecoverablevat" VARCHAR,
"suppliername" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR,
"vcsesupplier" VARCHAR,
"contactname" VARCHAR,
"processtype" VARCHAR
);CREATE TABLE july_2017 (
"old_column_name" VARCHAR -- Old Column Name >,
"council" VARCHAR,
"new" VARCHAR,
"new_1" VARCHAR,
"contract_reference" VARCHAR,
"contract_title" VARCHAR,
"organisational_unit" VARCHAR,
"description" VARCHAR,
"category" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"review_date" VARCHAR,
"option_to_extend" VARCHAR,
"available_extension" VARCHAR,
"estimated_total_contract_value" VARCHAR,
"irrecoverable_vat" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_charity_commission_no" VARCHAR -- Company Registration/ Charity Commission No,
"supplier_classification" VARCHAR,
"supplier_classification_1" VARCHAR,
"contact_details" VARCHAR,
"process_type" VARCHAR
);CREATE TABLE july_2018 (
"old_column_name" VARCHAR -- Old Column Name >,
"council" VARCHAR,
"new" VARCHAR,
"new_1" VARCHAR,
"contract_reference" VARCHAR,
"contract_title" VARCHAR,
"organisational_unit" VARCHAR,
"description" VARCHAR,
"category" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"review_date" VARCHAR,
"option_to_extend" VARCHAR,
"available_extension" VARCHAR,
"estimated_total_contract_value" VARCHAR,
"irrecoverable_vat" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_charity_commission_no" VARCHAR -- Company Registration/ Charity Commission No,
"supplier_classification" VARCHAR,
"supplier_classification_1" VARCHAR,
"contact_details" VARCHAR,
"process_type" VARCHAR
);CREATE TABLE july_2019 (
"old_column_name" VARCHAR -- Old Column Name >,
"council" VARCHAR,
"new" VARCHAR,
"new_1" VARCHAR,
"contract_title" VARCHAR,
"description" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"review_date" VARCHAR,
"option_to_extend" VARCHAR,
"estimated_total_contract_value" VARCHAR,
"irrecoverable_vat" VARCHAR,
"contact_details" VARCHAR,
"organisational_unit" VARCHAR,
"contract_reference" VARCHAR,
"supplier_name" VARCHAR,
"supplier_classification" VARCHAR,
"process_type" VARCHAR,
"category" VARCHAR,
"available_extension" VARCHAR,
"company_registration_charity_commission_no" VARCHAR -- Company Registration/ Charity Commission No,
"supplier_classification_1" VARCHAR
);CREATE TABLE june_2015 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"contractreference" VARCHAR,
"contracttitle" VARCHAR,
"organisationalunit" VARCHAR,
"description" VARCHAR,
"procurementcategory" VARCHAR,
"startdate" TIMESTAMP,
"enddate" VARCHAR,
"reviewdate" VARCHAR,
"optiontoextend" VARCHAR,
"extensionperiod" VARCHAR,
"contractvalue" VARCHAR,
"irrecoverablevat" DOUBLE,
"suppliername" VARCHAR,
"charitycommissionnumber" VARCHAR,
"smesupplier" VARCHAR,
"vcsesupplier" VARCHAR,
"contactname" VARCHAR,
"processtype" VARCHAR
);Anyone who has the link will be able to view this.