Contracts June 2017

Leicester City Council

@ukgov.contracts_june_2017

Table List

1 table(145.68 KB)

Table 1

@ukgov.contracts_june_2017.table_1

Contracts June 2017 (csv)

145.68 KB
1564 rows
19 columns

contract_number Contract Number	supplier_name Supplier Name	supplier_address Supplier Address	postcode Postcode	title_of_agreement Title Of Agreement	company_registration_number Company Registration Number	contract_value Contract Value	start_date Start Date	end_date End Date	review_date Review Date	department Department	procurement_route Procurement Route	small_or_medium_sized_enterprise Small Or Medium Sized Enterprise
ASC0001	Care UK Homecare	Care UK Ltd: Cobdown House, London Road, Aylesford, Kent, United Kingdom Mears Care LTD: 9-11 Mersey House, speke road, liverpool, Merseyside, l19 2ph, United Kingdom	ME20 6DQ	Framework agreement - Danbury Gardens	1174503063	1496500	Mon Oct 14 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 13 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 04 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care & Health	Open Tender
ASC0004	Mears Care Ltd		LE18 3QD	Framework agreement - Provision of generic domiciliary support services	4320403	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 Apr 14 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care & Health	Open Tender
ASC0004	Westminster Homecare Ltd )		LE1 4SG	Framework agreement - Provision of generic domiciliary support services	3353584	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)	Mon Apr 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care & Health	Open Tender
ASC0010	English Churches Housing Group	2 Estuary Boulevard, Estuary Commerce Park, Liverpool, Merseyside	L24 8RF	Sheltered Housing for older people		53616	Wed Oct 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Sep 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care & Health	Procurement Exercise
ASC0011	Network For Change	16 Wellington Street, Leicester, Leicestershire, United Kingdom	LE1 6HH	Mental Health community based low level support service targeted at the people residing in the City with mental health needs and their Carers	4218731	135644	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)	Adult Social Care & Health	Open Tender
ASC0013	LHA Support Services FA SL&FSB	LE1 7GB	LE1 7GB	LHA Older Persons Services	0	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)	Adult Social Care & Health	Open Tender
ASC0015	I Care Community Meals		FY2 0PJ	European style including asian punjabi, halal meal for community meals service		16000000	Fri Oct 03 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care & Health	Open Tender
ASC0017	West Indian Senior Citizens Project		LE2 0JU	African Caribbean style Veg & Non vegetarian meals for community meals service		16000000	Wed Oct 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Sep 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care & Health	Open Tender
ASC0023	Saffron Lane Neighbourhood Council		LE2 1FZ	Community Food Growing Support Programme		10000	Thu Nov 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Public Health	Extension
ASC0026	Staffs & Stoke Partnership NHS Trust	Morston House, Midway, Newcastle Under Lyme, Staffordshire, United Kingdom	ST5 1QG	Community Sexual Health Promotion & HIV Prevention for Co-ordination and Young People	Staffordshire and Stoke on Trent Partnership NHS Trust: N/A	360000	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)	Adult Social Care & Health	Open Tender	Large


CREATE TABLE table_1 (
  "contract_number" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_address" VARCHAR,
  "postcode" VARCHAR,
  "title_of_agreement" VARCHAR,
  "company_registration_number" VARCHAR,
  "contract_description" 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,
  "department" VARCHAR,
  "procurement_route" VARCHAR,
  "voluntary_or_community_sector_organisation" VARCHAR,
  "small_or_medium_sized_enterprise" VARCHAR,
  "notes" VARCHAR
);