Baselight

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

April2015

@ukgov.contracts_register_other.april2015
  • 30.8 kB
  • 131 rows
  • 21 columns
Loading...
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
);

April 2016

@ukgov.contracts_register_other.april_2016
  • 29.5 kB
  • 105 rows
  • 21 columns
Loading...
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
);

April 2018

@ukgov.contracts_register_other.april_2018
  • 31.2 kB
  • 168 rows
  • 22 columns
Loading...
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
);

April 2021

@ukgov.contracts_register_other.april_2021
  • 32.42 kB
  • 351 rows
  • 13 columns
Loading...
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
);

August 2017

@ukgov.contracts_register_other.august_2017
  • 34.72 kB
  • 143 rows
  • 22 columns
Loading...
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
);

August 2019

@ukgov.contracts_register_other.august_2019
  • 34.35 kB
  • 256 rows
  • 22 columns
Loading...
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
);

August 2020

@ukgov.contracts_register_other.august_2020
  • 28.59 kB
  • 301 rows
  • 13 columns
Loading...
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
);

December 2015

@ukgov.contracts_register_other.december_2015
  • 24.62 kB
  • 108 rows
  • 21 columns
Loading...
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
);

December 2017

@ukgov.contracts_register_other.december_2017
  • 29.96 kB
  • 164 rows
  • 22 columns
Loading...
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
);

December 2020

@ukgov.contracts_register_other.december_2020
  • 27.54 kB
  • 299 rows
  • 13 columns
Loading...
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
);

February 2015

@ukgov.contracts_register_other.february_2015
  • 27.63 kB
  • 119 rows
  • 21 columns
Loading...
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
);

February 2016

@ukgov.contracts_register_other.february_2016
  • 22.98 kB
  • 106 rows
  • 21 columns
Loading...
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
);

February 2017

@ukgov.contracts_register_other.february_2017
  • 34.89 kB
  • 148 rows
  • 21 columns
Loading...
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
);

February 2018

@ukgov.contracts_register_other.february_2018
  • 30.54 kB
  • 161 rows
  • 22 columns
Loading...
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
);

February 2020

@ukgov.contracts_register_other.february_2020
  • 30.45 kB
  • 258 rows
  • 17 columns
Loading...
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
);

February 2021

@ukgov.contracts_register_other.february_2021
  • 29.14 kB
  • 315 rows
  • 13 columns
Loading...
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
);

January 2015

@ukgov.contracts_register_other.january_2015
  • 28.36 kB
  • 121 rows
  • 21 columns
Loading...
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
);

January 2018

@ukgov.contracts_register_other.january_2018
  • 31.23 kB
  • 164 rows
  • 22 columns
Loading...
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
);

January 2019

@ukgov.contracts_register_other.january_2019
  • 29.37 kB
  • 217 rows
  • 22 columns
Loading...
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
);

January 2020

@ukgov.contracts_register_other.january_2020
  • 28.89 kB
  • 278 rows
  • 17 columns
Loading...
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
);

July 2016

@ukgov.contracts_register_other.july_2016
  • 22.27 kB
  • 63 rows
  • 21 columns
Loading...
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
);

July 2017

@ukgov.contracts_register_other.july_2017
  • 30.46 kB
  • 98 rows
  • 22 columns
Loading...
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
);

July 2018

@ukgov.contracts_register_other.july_2018
  • 28.72 kB
  • 150 rows
  • 22 columns
Loading...
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
);

July 2019

@ukgov.contracts_register_other.july_2019
  • 34.46 kB
  • 224 rows
  • 22 columns
Loading...
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
);

June 2015

@ukgov.contracts_register_other.june_2015
  • 25.5 kB
  • 122 rows
  • 21 columns
Loading...
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
);

Share link

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