Baselight
Sign In

Contracts Register - Other

Leeds City Council

@ukgov.contracts_register_other

Loading...
Loading...

About this Dataset

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

Tables

June 2017

@ukgov.contracts_register_other.june_2017
  • 24.5 kB
  • 75 rows
  • 22 columns
Loading... 
CREATE TABLE june_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
);

June 2018

@ukgov.contracts_register_other.june_2018
  • 29.79 kB
  • 153 rows
  • 22 columns
Loading... 
CREATE TABLE june_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
);

June 2019

@ukgov.contracts_register_other.june_2019
  • 28.06 kB
  • 253 rows
  • 22 columns
Loading... 
CREATE TABLE june_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
);

March 2020

@ukgov.contracts_register_other.march_2020
  • 29.18 kB
  • 265 rows
  • 17 columns
Loading... 
CREATE TABLE march_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
);

May 2015

@ukgov.contracts_register_other.may_2015
  • 26.95 kB
  • 84 rows
  • 21 columns
Loading... 
CREATE TABLE may_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
);

May 2016

@ukgov.contracts_register_other.may_2016
  • 24.64 kB
  • 67 rows
  • 21 columns
Loading... 
CREATE TABLE may_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
);

May 2017

@ukgov.contracts_register_other.may_2017
  • 31.62 kB
  • 129 rows
  • 22 columns
Loading... 
CREATE TABLE may_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
);

May 2018

@ukgov.contracts_register_other.may_2018
  • 28.7 kB
  • 166 rows
  • 22 columns
Loading... 
CREATE TABLE may_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
);

May 2019

@ukgov.contracts_register_other.may_2019
  • 34.76 kB
  • 256 rows
  • 22 columns
Loading... 
CREATE TABLE may_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
);

May 2020

@ukgov.contracts_register_other.may_2020
  • 28.17 kB
  • 315 rows
  • 13 columns
Loading... 
CREATE TABLE may_2020 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "contracttitle" VARCHAR,
  "description" VARCHAR,
  "startdate" VARCHAR,
  "contractvalue" VARCHAR,
  "contactname" VARCHAR,
  "organisationalunit" VARCHAR,
  "contractreference" VARCHAR,
  "suppliername" VARCHAR,
  "vcsesupplier" VARCHAR,
  "processtype" VARCHAR
);

May 2021

@ukgov.contracts_register_other.may_2021
  • 26.55 kB
  • 348 rows
  • 13 columns
Loading... 
CREATE TABLE may_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
);

November 2017

@ukgov.contracts_register_other.november_2017
  • 30.47 kB
  • 166 rows
  • 22 columns
Loading... 
CREATE TABLE november_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
);

November 2018

@ukgov.contracts_register_other.november_2018
  • 34.91 kB
  • 204 rows
  • 22 columns
Loading... 
CREATE TABLE november_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
);

November 2019

@ukgov.contracts_register_other.november_2019
  • 34.67 kB
  • 302 rows
  • 22 columns
Loading... 
CREATE TABLE november_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
);

November 2020

@ukgov.contracts_register_other.november_2020
  • 27.84 kB
  • 305 rows
  • 13 columns
Loading... 
CREATE TABLE november_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
);

October 2015

@ukgov.contracts_register_other.october_2015
  • 24.73 kB
  • 112 rows
  • 21 columns
Loading... 
CREATE TABLE october_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
);

October 2016

@ukgov.contracts_register_other.october_2016
  • 23.83 kB
  • 69 rows
  • 21 columns
Loading... 
CREATE TABLE october_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
);

October 2017

@ukgov.contracts_register_other.october_2017
  • 29.14 kB
  • 149 rows
  • 22 columns
Loading... 
CREATE TABLE october_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
);

October 2018

@ukgov.contracts_register_other.october_2018
  • 31.39 kB
  • 176 rows
  • 22 columns
Loading... 
CREATE TABLE october_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
);

September 2014

@ukgov.contracts_register_other.september_2014
  • 24.99 kB
  • 110 rows
  • 18 columns
Loading... 
CREATE TABLE september_2014 (
  "contract_title" VARCHAR,
  "council" VARCHAR,
  "description" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" VARCHAR,
  "review_date" VARCHAR,
  "option_to_extend" VARCHAR,
  "available_extension" VARCHAR,
  "estimated_total_contract_value" BIGINT,
  "irrecoverable_vat" VARCHAR,
  "contact_details" VARCHAR,
  "organisational_unit" VARCHAR,
  "contract_reference" VARCHAR,
  "category" VARCHAR,
  "supplier_name" VARCHAR,
  "company_registration_charity_commission_no_information_c055a101" VARCHAR  -- Company Registration/ Charity Commission No - Information Not Currently Collected,
  "supplier_classification" VARCHAR,
  "process_type" VARCHAR
);

September 2015

@ukgov.contracts_register_other.september_2015
  • 22.34 kB
  • 114 rows
  • 21 columns
Loading... 
CREATE TABLE september_2015 (
  "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
);

September 2017

@ukgov.contracts_register_other.september_2017
  • 32.21 kB
  • 120 rows
  • 22 columns
Loading... 
CREATE TABLE september_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
);

September 2019

@ukgov.contracts_register_other.september_2019
  • 32.83 kB
  • 252 rows
  • 22 columns
Loading... 
CREATE TABLE september_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
);

September 2020

@ukgov.contracts_register_other.september_2020
  • 31.15 kB
  • 347 rows
  • 13 columns
Loading... 
CREATE TABLE september_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
);

Share link

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