Contracts March 2018

Leicester City Council

@ukgov.contracts_march_2018

Table List

1 table(180.5 KB)

Table 1

@ukgov.contracts_march_2018.table_1

Contracts March 2018 (csv)

180.5 KB
1883 rows
19 columns

contract_number Contract Number	title_of_agreement Title Of Agreement	department Department	contract_value Contract Value	start_date Start Date	end_date End Date	review_date Review Date	procurement_route Procurement Route	supplier_name Supplier Name	supplier_address Supplier Address	postcode Postcode	company_registration_number Company Registration Number	small_or_medium_sized_enterprise Small Or Medium Sized Enterprise	voluntary_or_community_sector_organisation Voluntary Or Community Sector Organisation
ASC (Domiciliary Support Service 2017 - Lot 1)	Framework Agreement for the provision of Domiciliary Support Service: General (Lot 1) Domiciliary Support Service	Adult Social Care & Health	166600000	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Care 4U (Leicestershire) limited
ASC (Domiciliary Support Service 2017 - Lot 1)	Framework Agreement for the provision of Domiciliary Support Service: General (Lot 1) Domiciliary Support Service	Adult Social Care & Health	166600000	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Domiciliary Care Services (UK) Limited
ASC (Domiciliary Support Service 2017 - Lot 1)	Framework Agreement for the provision of Domiciliary Support Service: General (Lot 1) Domiciliary Support Service	Adult Social Care & Health	166600000	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	English Rose Care Ltd
ASC (Domiciliary Support Service 2017 - Lot 1)	Framework Agreement for the provision of Domiciliary Support Service: General (Lot 1) Domiciliary Support Service	Adult Social Care & Health	166600000	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Family Care Agency Ltd
ASC (Domiciliary Support Service 2017 - Lot 1)	Framework Agreement for the provision of Domiciliary Support Service: General (Lot 1) Domiciliary Support Service	Adult Social Care & Health	166600000	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Westminster Homecare Limited
ASC (Domiciliary Support Services - Lot 1)	Framework agreement - Domiciliary Support Services - Provision of generic domiciliary support services	Adult Social Care & Health	43050000	Mon Oct 14 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 13 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 13 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Open Tender	Westminster Homecare Ltd		LE1 4SG	3353584		No
ASC0013	LHA Older Persons Services	Adult Social Care & Health	590344	Thu Oct 02 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Sep 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Open Tender	Trinity Hospital	LE2 7BU	LE2 7BU
ASC0019	Community Sexual Health Promotion & HIV Prevention for Men Who Have Sex With Men	Adult Social Care & Health	377072	Wed Apr 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 28 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Open Tender	Trade Sexual Health	2nd Floor, 27 Bowling Green Street, Leicester, Leicestershire, United Kingdom	LE1 6AS	3958484		Yes
ASC0031	Visual and Dual Sensory Impairment Services	Adult Social Care & Health	1185034.08	Wed Apr 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 28 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Open Tender	Vista	Vista House, 1A Salisbury Road, Leicester, Leicestershire	LE1 7QA	163099		Yes
ASC0043	Early Intervention & Prevention (EIP) Advocacy Services 2016: Learning Disability	Adult Social Care & Health	48626.43	Mon Jul 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Mosaic Shaping Disability Services	2 Oak Spinney Park, Ratby Lane, Leicester, Leicestershire	LE3 3AW	533714	Large	Yes


CREATE TABLE table_1 (
  "contract_number" VARCHAR,
  "title_of_agreement" VARCHAR,
  "contract_description" VARCHAR,
  "department" VARCHAR,
  "contract_value" DOUBLE,
  "annual_contract_value" DOUBLE,
  "contract_value_excl_variations" DOUBLE,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "review_date_notes" VARCHAR,
  "procurement_route" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_address" VARCHAR,
  "postcode" VARCHAR,
  "company_registration_number" VARCHAR,
  "small_or_medium_sized_enterprise" VARCHAR,
  "voluntary_or_community_sector_organisation" VARCHAR,
  "notes" VARCHAR
);