Contracts March 2017

Leicester City Council

@ukgov.contracts_march_2017

Table List

1 table(145.62 KB)

Table 1

@ukgov.contracts_march_2017.table_1

Contracts March 2017 (csv)

145.62 KB
1629 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
ASC0004	Sevacare (UK) Ltd		LE10 1EQ	Framework agreement - Provision of generic domiciliary support services	3615347	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)	Sat Apr 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care and Health	OJEU Exercise - Open
ASC0005	Mears Care Ltd		LE18 3QD	Framework agreement - Provision of specialist 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)	Sat Apr 29 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care and Health	OJEU Exercise - Open
ASC0002	Aspire UK		LE1 3BD	Framework agreement - Acquired Brain Injury Domiciliary Support Services		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)	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care and Health	OJEU Exercise - Open
CCM100755	Race Furniture Ltd	Race Furniture Limited: Bourton Industrial Estate, Bourton-on-the-Water, Gloucestershire, United Kingdom	GL54 2HQ	Refurbishment of Auditorium at DeMonfort Hall	2454179	382494	Mon Aug 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Sep 06 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Sep 06 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	City Development & Neighbourhoods	Procurement Exercise	Small
CCM100706	Close Circuit Security Services Ltd (CCSS)		B33 0TD	Warden Call Contract		124051.05	Mon Aug 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Aug 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Feb 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	City Development & Neighbourhoods	Procurement Exercise
CCM88694	Alfred Bagnalls & Sons (East Midlands) Ltd	Unit 3 Hawarden Ave Leicester, Leics.	LE5 4NN	National Schedule of Rates - Procurement Advice	1042314	300000	Wed Jan 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jul 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	City Development & Neighbourhoods	Tender Exercise - Open
CCM92439	Lifeline Project Ltd		NW1 2FD	Young People's Drug and Alcohol Substance Misuse Services		657295	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care and Health	OJEU Exercise - Open
CCM101150	Leicester Community Projects Trust (LCPT)	5th Floor, St John's House, 30 East Street, Leicester, Leicestershire	LE1 6NB	EIP - Advocacy Services 2015, Procurement Exercise	1617951	364320	Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Sep 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care and Health	Procurement Exercise	Small
CCM101044	Speedline Taxis		LE3 2GA	Vulnerable Passenger Transport Services - Speedline Taxis Leicester Ltd		4000000	Mon Jun 15 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 14 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 14 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	City Development & Neighbourhoods	OJEU Exercise - Open
CCM101210	Various Suppliers			Lunch Clubs Changes to Funding (16/17)		125601	Fri Jan 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Adult Social Care and Health	Procurement Exercise


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
);