Contracts March 2019

Leicester City Council

@ukgov.contracts_march_2019

Table List

1 table(247.71 KB)

Table 1

@ukgov.contracts_march_2019.table_1

Contracts March 2019 (csv)

247.71 KB
2348 rows
36 columns

procurement_team Procurement Team	contract_number Contract Number	supplier_name Supplier Name	classification Classification	title_of_agreement_contract_description Title Of Agreement Contract Description	total_contract_value_ps Total Contract Value Ps	one_off_intial_cost One Off Intial Cost	start_date Start Date	annual_renewal_date Annual Renewal Date	annual_contract_value_ps Annual Contract Value Ps	first_break_point_date First Break Point Date	ultimate_end_date Ultimate End Date	next_review_date_procurement Next Review Date Procurement	procurement_route Procurement Route	department Department	contract_value Contract Value	end_date End Date	review_date Review Date	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
IT	534	CDW Limited	Servers Hardware & Support	HP 3 Par Support - Parts only - M-F, 9-5 NBD Response with Remote Monitoring for HPE 3PAR 7400 Array Serial Number 1639365 with 6 Enclosures & 144 x 900GB disks	4823.89		Sun Jan 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4823.89	Sun Jan 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RFQ	Finance
IT	495	CDW Limited	Security Solution	Cisco AnyConnect Plus License, 3YR, 2000 Users	3220		Tue Nov 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1073.33	Fri Nov 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RFQ	Finance
IT		CDW Limited	Servers Software & Support	ALTARO VM BACKUP FOR HYPER-V X 10 licences with 1 year free support and a further 4 years support = 5 years	6175	3250	Mon Jul 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jul 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	585	Sat Jul 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jul 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	RFQ	Finance
IT		Bt Payment Services Ltd	Phone Lines	Red care Lift lines etc and pocket of ASDL Circuits	240000		Tue Apr 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	60000	Tue Mar 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ITT	Finance
IT		CDW Limited	VDI Solution	2 x IGEL UD POCKET 8GB USB STICK INCLUDING 3YR MAINT & CODEC LICENCE	287.36	287.36	Tue Feb 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)		Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Dec 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)		Finance
Corporate	FEW0457	Park Steel Structures		Friars Mill 2 – completion of steel frames			Mon Nov 28 2016 00:00:00 GMT+0000 (Coordinated Universal Time)						Direct Award - Exemption	City Development & Neighbourhoods	80000	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)		LS13 4EN	LS13 4EN	8189180	Large	No
Corporate	FEW0463	De Montfort University		DMU DVSV Research Network Support			Thu Dec 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)						Direct Award - Waiver	City Development & Neighbourhoods	11229	Thu Nov 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	The Gateway, Leicester,	LE1 9BH	6634464	Large	No
Corporate	FEW0472	PGA Adjusters (FASA)		Specialist Loss Adjuster (Museums)			Mon Jan 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)						Direct Award - Exemption	Corporate Resources & Support	8750	Tue May 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	SO40 4AQ	SO40 4AQ	Not captured	Large	No
Corporate	FEW0487	Hanover Housing Association		Independent Living Support – Community Alarms			Sat Jul 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)						Direct Award - Exemption	Adult Social Care & Health	45300	Tue Mar 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Nelson House, Alington Road, Eynesbury, St Neots, Cambridgeshire, PE19 6RE, United Kingdom	PE19 6RE	16324R	Small	No
Corporate	FEW0487	Cossington House Co-op		Independent Living Support – Community Alarms			Sat Jul 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)						Direct Award - Exemption	Adult Social Care & Health	45300	Tue Mar 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	LE2 7EA	LE2 7EA	Not captured	Not captured	No


CREATE TABLE table_1 (
  "procurement_team" VARCHAR,
  "contract_number" VARCHAR,
  "supplier_name" VARCHAR,
  "classification" VARCHAR,
  "title_of_agreement_contract_description" VARCHAR,
  "total_contract_value_ps" DOUBLE,
  "total_contract_value_notes" VARCHAR,
  "total_contract_value" DOUBLE,
  "one_off_intial_cost" DOUBLE,
  "start_date" TIMESTAMP,
  "go_live_term_start_date" TIMESTAMP,
  "go_live_term_start_date_notes" VARCHAR,
  "annual_renewal_date" TIMESTAMP,
  "annual_renewal_date_notes" VARCHAR,
  "annual_contract_value_ps" DOUBLE,
  "annual_contract_value_notes" VARCHAR,
  "annual_contract_value" DOUBLE,
  "first_break_point_date" TIMESTAMP,
  "first_break_point_date_notes" VARCHAR,
  "next_break_point_date" TIMESTAMP,
  "next_break_point_date_notes" VARCHAR,
  "ultimate_end_date" TIMESTAMP,
  "ultimate_end_date_notes" VARCHAR,
  "next_review_date_procurement" TIMESTAMP,
  "next_review_date_procurement_notes" VARCHAR,
  "procurement_route" VARCHAR,
  "department" VARCHAR,
  "contract_value" DOUBLE,
  "end_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "review_date_notes" VARCHAR,
  "supplier_address" VARCHAR,
  "postcode" VARCHAR,
  "company_registration_number" VARCHAR,
  "small_or_medium_sized_enterprise" VARCHAR,
  "voluntary_or_community_sector_organisation" VARCHAR
);