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