Contracts September 2018

Leicester City Council

@ukgov.contracts_september_2018

Table List

1 table(196.26 KB)

Table 1

@ukgov.contracts_september_2018.table_1

Contracts September 2018 (csv)

196.26 KB
2140 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
PAN0935 (Lot 1)	Leicester City Council Sexual and Domestic Violence Services - Lot 1 Children, Young People & Families	Public Health	600000	Tue Dec 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Mar 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Open Tender (Variation)	United Against Violence and Abuse (UAVA)	PO Box 26, Leicester, Leicestershire.	LE1 1AA	9857159	Not captured	Yes
PAN0906	Eco-Management and Audit Scheme (EMAS) verification and Statement Validation Services	City Development & Neighbourhoods	14079	Mon May 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)		Advertised Quotation	DNV GL Business Assurance UK	Palace House, 3 Cathedral Street, London, Greater London, United Kingdom	SE1 9DE	1503799	Not captured	Not captured
PAN0835	Energy Savings Measures - Insulation	City Development & Neighbourhoods	39541.68	Fri May 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Advertised Quotation	Mark Group Limited	70 Boston Road, Beaumont Leys, Leicester, Leicestershire, United Kingdom	LE4 1AW	1304470	Not captured	Not captured
PAN0963	Economic and Social Study for Waterside Regeneration Area	City Development & Neighbourhoods	22775	Sun Jun 21 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)		Procurement Exercise	Regeneris Consulting Ltd	Faulkner House, Faulkner Street, Manchester, Greater Manchester, United Kingdom	M1 4DY	4028436	Not captured	Not captured
PAN0954	Consultancy Housing Company	City Development & Neighbourhoods	63520	Thu May 28 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat May 28 2016 00:00:00 GMT+0000 (Coordinated Universal Time)		Procurement Exercise	Ernst & Young LLP	1 More London Place, London, Greater London, United Kingdom	SE1 2AF	OC300001	Not captured	Not captured
PAN1268	Framework for the Provision of Ready Mix Concrete, Volumetric Concrete Aggregates and Asphalts	City Development & Neighbourhoods	4100000	Sat Jul 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Dec 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Open Tender	Wright Mix	158 Barkby Rd, Leicester, Leicestershire, LE4 9LF, United Kingdom	LE4 9LF	5076144	Small	No
PAN1077	Construction Consultancy Services for Main Line Museum	City Development & Neighbourhoods	199822	Sun May 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Restricted Tender	Lend Lease Consulting EMEA Limited	20 Triton Street, Regent's Place, London, Greater London, United Kingdom	Not captured	3826968	Large	No
PAN1239	Minor Adaptations Works up to £1k (Adult Social Care)	Adult Social Care & Health	1472000	Tue Nov 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Nov 14 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		Open Tender	UK Gas Services Ltd	13 Leicester Road, Groby, Leicester. Leics	LE6 0DQ	2976617	Not captured	Not captured
PAN1239	Minor Adaptations Works up to £1k (Adult Social Care)	Adult Social Care & Health	1472000	Tue Nov 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Nov 14 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		Open Tender	A Hull Electrical Ltd	500 Aylestone Rd, Leicester, Leics	LE2 8JB	3201058	Small	No
PAN0709	Provision of Consultancy Services in support of an Infrastructure Delivery Programme for the Ashton Green Development Project		162935	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)		Procurement Exercise	WYG Environment Planning Transport Ltd	2 Avalon Way, Leicester, Leics.	LE7 7GR	305297	Not captured	Not captured


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