Contracts December 2018

Leicester City Council

@ukgov.contracts_december_2018

Table List

1 table(205.16 KB)

Table 1

@ukgov.contracts_december_2018.table_1

Contracts December 2018 (csv)

205.16 KB
2195 rows
23 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
FEW0530	Dog Kennelling Service	Adult Social Care & Health	10000	Fri Aug 04 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Aug 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Aug 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Direct Award - Waiver	College Garth Kennels	Derby Road, Hathern, LOughborough, Leicestershire, LE12 5LD, United Kingdom	LE12 5LD	Not captured	Micro	No
FEW0532	King Street Street Furniture	City Development & Neighbourhoods	14000	Wed Nov 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 16 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 16 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Direct Award - Exemption	Broxap	Rowhurst Industrial Estate, Chesterton, Newcastle under Lyme, Staffordshire, ST5 6BD, Other	ST5 6BD	2690329	Large	No
FEW0548	Inglehurst Toilet Block – Pre Construction Fees	City Development & Neighbourhoods	12846	Mon May 15 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Direct Award - Waiver	Interserve Construction Ltd	LE7 1PF	LE7 1PF	Not captured	Not captured	No
FEW0596	Electric Pool Bike Scheme	City Development & Neighbourhoods	8000	Wed Mar 21 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 21 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Direct Award - Waiver	Green Bike Pool Initiative	WC2H 9JQ	WC2H 9JQ	Not captured	Not captured	No
FEW0608	Utility Permit Scheme – Implementation Phase Resourcing & Proof of Concept	City Development & Neighbourhoods	145660	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Direct Award - Waiver	Saanchi Solutions Limited	4200 Waterside Centre, Solihull Parkway, Birmingham Business Park, Solihull, West Midlands, B37 7YN, United Kingdom	B37 7YN	9730316	Micro	No
FEW0624	Friars Mill – Glazing Mastic	City Development & Neighbourhoods	8000	Mon Jun 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Direct Award - Exemption	Norman and Underwood	The Freeschool Building, 170 Scudamore Road, Leicester, Leicestershire, LE3 1HP, United Kingdom	LE3 1HP	242964	Medium	No
FEW0630	Diwali 2018 Crowd Management Review	City Development & Neighbourhoods	6000	Thu Jul 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Direct Award - Waiver	Gentian Events Ltd	CV47 8FB	CV47 8FB	8031298	Not captured	No
FEW0645	NHS Health Checks scheme	Public Health	1850000	Mon Apr 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Sep 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Direct Award - Waiver	Westcotes GP Surgery One	2 Westcotes Drive, Leicester, Leicestershire, LE3 0QR, United Kingdom	LE3 0QR	Not captured	Small	No
FEW0679	Leicester Christmas Ice Rink	City Development & Neighbourhoods	244329.78	Fri Nov 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Direct Award - Waiver	Icescape	Icescape: Unit 2, Avonmouth Way West, Bristol, Avon, BS11 9EX, United Kingdom	Icescape: BS11 9EX	Icescape: 09067066	Medium	No
FEW0689	Replace Ball Courts Carpet	Adult Social Care & Health	35000	Mon Nov 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Direct Award - Exemption	Dura-Sport Ltd	Dura-Sport Ltd: West Avenue, Wigston, Leicestershire, LE18 2FF, United Kingdom	Dura-Sport Ltd: LE18 2FF	Dura-Sport Ltd: 3018525	Small	No


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,
  "annual_contract_value0" DOUBLE,
  "contract_value_excl_variations0" DOUBLE,
  "annual_contract_value_eu" DOUBLE,
  "contract_value_excl_variations_eu" 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
);