About this Dataset

Contracts December 2019

Details of contracts, commissioned activity, purchase order, framework agreement with a value that exceeds £5,000.

Data has been excluded or redacted from the publication in line with guidance issued by the Local Government Association. This can be redacted personal data, commercial confidentiality or where the data would reveal information which would compromise security, health & safety or crime prevention.

This data is published quarterly.
Publisher name: Leicester City Council
Last updated: 2023-04-07T04:00:03Z

Tables

Table 1

@ukgov.contracts_december_2019.table_1

272.4 KB
2651 rows
37 columns


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