Contracts - March 2021

Leicester City Council

@ukgov.contracts_march_2021

Table List

1 table(233.86 KB)

Table 1

@ukgov.contracts_march_2021.table_1

Contracts - March 2021 (csv)

233.86 KB
1122 rows
28 columns

procurement_team Procurement Team	type Type	contract_number Contract Number	supplier_name Supplier Name	classification Classification	website_portal_y_n Website Portal Y N	title_of_agreement_contract_description Title Of Agreement Contract Description	contract_value_total_contract_value_excl_variations Contract Value Total Contract Value Excl Variations	revised_tcv Revised Tcv	one_off_intial_cost One Off Intial Cost	contract_signature_date Contract Signature Date	start_date_go_live_term_start_date Start Date Go Live Term Start Date	annual_renewal_date Annual Renewal Date	annual_contract_value Annual Contract Value	first_next_break_point_date First Next Break Point Date	review_date_next_review_date_procurement Review Date Next Review Date Procurement	end_date_ultimate_end_date End Date Ultimate End Date	procurement_route Procurement Route	department_or_division Department Or Division
IT	Active Other Service Contracts		20-20 Technologies Limited	Modelling Software		Fusion Design Software ( kitchens) Support for 3 dongles	1665	1665		Fri Apr 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1665	Fri Apr 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RFQ	Housing
IT	Active Other Service Contracts		20-20 Technologies Limited	Modelling Software		Fusion Design Software ( kitchens) Support for 3 dongles	5703.75	5703.75	5085	Thu May 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	618.75	Mon May 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RFQ	Housing
IT	Active Other Service Contracts	FEW0583	Aimsun	Modelling Software		leicester City traffic Model of all roads and juntions / traffic movements developed for the European Space Agency (ESA) Ultraq Project	44000	44000	31725	Mon Aug 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Sep 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Aug 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	4284	Tue Aug 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Aug 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RFQ	Planning, Development & Transportation
IT	Active Other Service Contracts	386	Alcium Software Limited	Case Management Solution	Yes	CRM System for LLEP and third party partners	58875	58875	875	Mon Sep 05 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Apr 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	11775	Wed Mar 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITT	LLEP
IT	Active Other Service Contracts	438	Allpay Limited	Corporate Solution (Finance)		Corporate Pre-Paid Cards contract	219121	219121	1855	Mon May 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	43826	Fri Sep 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Sep 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITT	Finance
IT	Active Other Service Contracts		Argus	Propert Assesment & Financial Tool		ARGUS developer for Network Modules 1 & 4 ( 1 licence ) and Argus developer fornetwork Project Module - property industry development appraisal software since about 2006- (used for development appraisal and financial viability assessments used by developers and property consultants in orer to advise…	2026.91	2026.91		Wed Mar 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Dec 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1023.49	Wed Dec 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Nov 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RFQ	Planning, Development & Transportation
IT	Active Other Service Contracts	451	Artifax Software Ltd	Booking Management ( events )		Event Management Solution -Annual Subscription for Artifax Event and Artifax Agora. Cloud based SaaS solution based on 10 Read Write licences used by both DMH and Arts & Museums	35855	35855	4490	Thu Oct 26 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	6276	Mon May 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed May 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	RFQ	Tourism Culture & Inward Investment
IT	Active Other Service Contracts	321	Aspex UK Ltd	Door Access Control		Salto Door Access Management Solution - Dawn Centre	11250	11250	3750	Tue Dec 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1500	Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RFQ	Housing
IT	Active Other Service Contracts	331	Atlas AV Ltd	Media Services		To supply Audio visual support service for the German Expressionist Gallery of all commissioned hardware and software installations in the Gallery at New Walk Museum and Art Gallery to a 3 year schedule. To provide 5 year manufactures lamp replacement service to all 6 on gallery projectors.	17892	17892			Sun Mar 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 28 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	5964	Sun Feb 28 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 28 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RFQ	Tourism Culture & Inward Investment
IT	Active Other Service Contracts	FEW0777	Barbour Logic Ltd	Parking Management Solution		PCN Letter Writing response master 40- 59.9 K cases per annum & Self Serve , logging of appeals and online payment	44264	44264			Wed May 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	22132	Fri Apr 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	FEW	Planning, Development & Transportation


CREATE TABLE table_1 (
  "procurement_team" VARCHAR,
  "type" VARCHAR,
  "contract_number" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_address" VARCHAR,
  "postcode" VARCHAR,
  "classification" VARCHAR,
  "website_portal_y_n" VARCHAR,
  "title_of_agreement_contract_description" VARCHAR,
  "dpc_value" DOUBLE,
  "contract_value_total_contract_value_excl_variations" DOUBLE,
  "variations_to_date" DOUBLE,
  "revised_tcv" DOUBLE,
  "revised_tcv0" DOUBLE,
  "one_off_intial_cost" DOUBLE,
  "contract_signature_date" TIMESTAMP,
  "start_date_go_live_term_start_date" TIMESTAMP,
  "annual_renewal_date" TIMESTAMP,
  "annual_contract_value" DOUBLE,
  "first_next_break_point_date" TIMESTAMP,
  "review_date_next_review_date_procurement" TIMESTAMP,
  "end_date_ultimate_end_date" TIMESTAMP,
  "procurement_route" VARCHAR,
  "department_or_division" VARCHAR,
  "company_registration_number" VARCHAR,
  "small_or_medium_sized_enterprise" VARCHAR,
  "voluntary_or_community_sector_organisation" VARCHAR,
  "notes_refer_to_column_heading" VARCHAR
);