Contracts December 2019

Leicester City Council

@ukgov.contracts_december_2019

Table List

1 table(272.4 KB)

Table 1

@ukgov.contracts_december_2019.table_1

Contracts December 2019 (csv)

272.4 KB
2651 rows
37 columns

procurement_team Procurement Team	contract_number Contract Number	name Name	contract_description Contract Description	start_date Start Date	ultimate_end_date Ultimate End Date	procurement_route Procurement Route	department Department	contract_value Contract Value	review_date Review Date	supplier_address Supplier Address	postcode Postcode	small_or_medium_sized_enterprise Small Or Medium Sized Enterprise	voluntary_or_community_sector_organisation Voluntary Or Community Sector Organisation
Corporate	ASC (Domiciliary Support Service 2017 - Lot 1)	Adaptus Carers Limited	Framework Agreement for the provision of Domiciliary Support Service: General (Lot 1) Domiciliary Support Service	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Adult Social Care & Health	166600000	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Not captured		Not captured	Not captured
Corporate	ASC (Domiciliary Support Service 2017 - Lot 1)	Bluewood Recruitment Ltd	Framework Agreement for the provision of Domiciliary Support Service: General (Lot 1) Domiciliary Support Service	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Adult Social Care & Health	166600000	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Not captured		Not captured	Not captured
Corporate	ASC (Domiciliary Support Service 2017 - Lot 1)	Carewatch Care Services Ltd	Framework Agreement for the provision of Domiciliary Support Service: General (Lot 1) Domiciliary Support Service	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Adult Social Care & Health	166600000	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Not captured		Not captured	Not captured
Corporate	ASC (Domiciliary Support Service 2017 - Lot 1)	English Rose Care Ltd	Framework Agreement for the provision of Domiciliary Support Service: General (Lot 1) Domiciliary Support Service	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Adult Social Care & Health	166600000	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Not captured		Not captured	Not captured
Corporate	ASC (Domiciliary Support Service 2017 - Lot 1)	Mi Life Care Services Limited	Framework Agreement for the provision of Domiciliary Support Service: General (Lot 1) Domiciliary Support Service	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Adult Social Care & Health	166600000	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Not captured		Not captured	Not captured
Corporate	ASC (Domiciliary Support Service 2017 - Lot 2)	Adaptus Carers Limited	Framework Agreement for the provision of Domiciliary Support Service: Complex (Lot 2) Domiciliary Support Service	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Adult Social Care & Health	29400000	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Not captured		Not captured	Not captured
Corporate	ASC (Domiciliary Support Service 2017 - Lot 2)	Evolving Care Limited	Framework Agreement for the provision of Domiciliary Support Service: Complex (Lot 2) Domiciliary Support Service	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Adult Social Care & Health	29400000	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Not captured		Not captured	Not captured
Corporate	ASC (Domiciliary Support Service 2017 - Lot 2)	Private Home Care UK Ltd	Framework Agreement for the provision of Domiciliary Support Service: Complex (Lot 2) Domiciliary Support Service	Mon Oct 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Procurement Exercise	Adult Social Care & Health	29400000	Fri Oct 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Not captured		Not captured	Not captured
Corporate	ASC0006	Leicestershire Aids Support Service (LASS) Well For Living	Community Sexual Health Promotion & HIV Prevention for HIV Positive People	Wed Apr 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Open Tender	Adult Social Care & Health	296892	Fri Sep 28 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	53 Regent Road, Leicester, Leicestershire	LE1 6YF	Not captured	Not captured
Corporate	ASC0007	Leicestershire Aids Support Service (LASS) Well For Living	Community Sexual Health Promotion & HIV Prevention for People of African and African Caribbean Heritage	Wed Apr 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Open Tender	Adult Social Care & Health	299624	Fri Sep 28 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	53 Regent Road, Leicester, Leicestershire	LE1 6YF	Not captured	Not captured


CREATE TABLE table_1 (
  "procurement_team" VARCHAR,
  "contract_number" VARCHAR,
  "name" VARCHAR,
  "classification" VARCHAR,
  "contract_description" VARCHAR,
  "contract_value_excl_variations_ps" DOUBLE,
  "contract_value_excl_variations_notes" VARCHAR,
  "total_contract_value_excl_variations_ps" DOUBLE,
  "total_contract_value_excl_variations" DOUBLE,
  "variations_to_date_ps" DOUBLE,
  "revised_tcv_ps" DOUBLE,
  "revised_tcv" DOUBLE,
  "revised_tcv_notes" VARCHAR,
  "one_off_intial_cost" DOUBLE,
  "contract_signature_date" TIMESTAMP,
  "start_date" TIMESTAMP,
  "go_live_term_start_date" TIMESTAMP,
  "annual_renewal_date" TIMESTAMP,
  "annual_renewal_date_notes" VARCHAR,
  "annual_contract_value_ps" DOUBLE,
  "annual_contract_value" DOUBLE,
  "annual_contract_value_notes" VARCHAR,
  "first_break_point_date" TIMESTAMP,
  "first_break_point_date_notes" VARCHAR,
  "next_break_point_date" TIMESTAMP,
  "ultimate_end_date" TIMESTAMP,
  "ultimate_end_date_notes" VARCHAR,
  "procurement_route" VARCHAR,
  "division" VARCHAR,
  "department" VARCHAR,
  "contract_value" DOUBLE,
  "review_date" TIMESTAMP,
  "supplier_address" VARCHAR,
  "postcode" VARCHAR,
  "small_or_medium_sized_enterprise" VARCHAR,
  "voluntary_or_community_sector_organisation" VARCHAR,
  "review_date_notes" VARCHAR
);