Contracts March 2019
Leicester City Council
@ukgov.contracts_march_2019
Leicester City Council
@ukgov.contracts_march_2019
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
);
Anyone who has the link will be able to view this.