Contracts Register
Stockport Metropolitan Borough Council
@ukgov.stockport_council_contracts_register
Stockport Metropolitan Borough Council
@ukgov.stockport_council_contracts_register
CREATE TABLE contract_register_april_to_june_2019 (
"uid" BIGINT,
"client" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_duration_of_contract_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register (
"uid" DOUBLE,
"client" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"route_to_market" VARCHAR,
"contract_type" VARCHAR,
"contract_start_date" TIMESTAMP,
"initial_contract_term_months" DOUBLE,
"potential_maximum_duration_of_contract_months" DOUBLE,
"contract_end_date" TIMESTAMP,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" TIMESTAMP,
"review_date" TIMESTAMP,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register_april_to_june_2020 (
"uid" BIGINT,
"client" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_contract_term_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register_april_to_june_2021 (
"uid" BIGINT,
"client" VARCHAR,
"status" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"contract_trigger" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_duration_of_contract_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register_april_to_june_2022 (
"uid" BIGINT,
"council" VARCHAR,
"contract_status" VARCHAR,
"name" VARCHAR,
"description" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"annual_contract_value_average" VARCHAR,
"value" VARCHAR,
"lifetime_estimated_value" VARCHAR,
"start_date" TIMESTAMP,
"end_date" TIMESTAMP,
"expiry" VARCHAR,
"extension_number_1" VARCHAR,
"extension_start_date_1" VARCHAR,
"extension_end_date_1" VARCHAR,
"extension_referece_1" VARCHAR,
"extension_description_1" VARCHAR,
"extension_status_1" VARCHAR,
"auto_extend_date_1" VARCHAR,
"extension_number_2" VARCHAR,
"extension_start_date_2" VARCHAR,
"extension_end_date_2" VARCHAR,
"extension_referece_2" VARCHAR,
"extension_description_2" VARCHAR,
"extension_status_2" VARCHAR,
"auto_extend_date_2" VARCHAR,
"extension_number_3" VARCHAR,
"extension_start_date_3" VARCHAR,
"extension_end_date_3" VARCHAR,
"extension_referece_3" VARCHAR,
"extension_description_3" VARCHAR,
"extension_status_3" VARCHAR,
"auto_extend_date_3" VARCHAR,
"extension_number_4" VARCHAR,
"extension_start_date_4" VARCHAR,
"extension_end_date_4" VARCHAR,
"extension_referece_4" VARCHAR,
"extension_description_4" VARCHAR,
"extension_status_4" VARCHAR,
"auto_extend_date_4" VARCHAR,
"collaborative_group" VARCHAR,
"council_directorate" VARCHAR,
"category" VARCHAR,
"subcategory" VARCHAR,
"star_responsible_officer" VARCHAR,
"procurement_system_reference" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_number" VARCHAR,
"postal_code" VARCHAR,
"supplier_type" VARCHAR
);
CREATE TABLE contracts_register_april_to_june_2023 (
"uid" DOUBLE,
"council" VARCHAR,
"contract_status" VARCHAR,
"name" VARCHAR,
"classification" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"start_date" TIMESTAMP,
"end_date" VARCHAR,
"maximum_extension_date" VARCHAR,
"annual_contract_value_average" VARCHAR,
"value" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_number" VARCHAR,
"postal_code" VARCHAR,
"supplier_type" VARCHAR,
"customer_name" VARCHAR
);
CREATE TABLE contracts_register_april_to_june_2024 (
"uid" VARCHAR,
"council" VARCHAR,
"contract_status" VARCHAR,
"classification" VARCHAR,
"name" VARCHAR,
"star_category_manager" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"start_date" BIGINT,
"end_date" DOUBLE,
"maximum_extension_date" VARCHAR,
"n__annual_contract_value_average" VARCHAR,
"n__value" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_number" VARCHAR,
"postcode" VARCHAR,
"supplier_type" VARCHAR,
"customer_name" VARCHAR
);
CREATE TABLE contracts_register_january_to_march_2019 (
"uid" BIGINT,
"client" VARCHAR,
"proclass" VARCHAR,
"contract_title" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_duration_of_contract_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"supplier_number" VARCHAR,
"supplier_postcode" VARCHAR,
"directorate" VARCHAR
);
CREATE TABLE contracts_register_january_to_march_2020 (
"uid" BIGINT,
"client" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_duration_of_contract_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register_january_to_march_2021 (
"uid" BIGINT,
"client" VARCHAR,
"status" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"contract_trigger" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_duration_of_contract_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register_january_to_march_2022 (
"uid" BIGINT,
"council" VARCHAR,
"contract_status" VARCHAR,
"classification" VARCHAR,
"name" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"start_date" TIMESTAMP,
"end_date" VARCHAR,
"maximum_extension_date" VARCHAR,
"annual_contract_value_average" VARCHAR,
"value" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_number" VARCHAR,
"postal_code" VARCHAR,
"supplier_type" VARCHAR,
"customer_name" VARCHAR
);
CREATE TABLE contracts_register_january_to_march_2024 (
"uid" DOUBLE,
"council" VARCHAR,
"contract_status" VARCHAR,
"classification" VARCHAR,
"name" VARCHAR,
"star_category_manager" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"start_date" TIMESTAMP,
"end_date" VARCHAR,
"maximum_extension_date" VARCHAR,
"n__annual_contract_value_average" VARCHAR,
"n__value" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_number" VARCHAR,
"postcode" VARCHAR,
"supplier_type" VARCHAR,
"customer_name" VARCHAR
);
CREATE TABLE contracts_register_january_to_march_2025 (
"uid" VARCHAR,
"council" VARCHAR,
"contract_status" VARCHAR,
"classification" VARCHAR,
"name" VARCHAR,
"star_category_manager" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"start_date" TIMESTAMP,
"end_date" TIMESTAMP,
"maximum_extension_date" TIMESTAMP,
"annual_contract_value_average" VARCHAR,
"value" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_number" VARCHAR,
"postcode" VARCHAR,
"supplier_type" VARCHAR,
"customer_name" VARCHAR
);
CREATE TABLE contracts_register_july_to_september_2019 (
"uid" VARCHAR,
"client" VARCHAR,
"status" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"contract_requirement" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_duration_of_contract_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register_july_to_september_2020 (
"uid" BIGINT,
"client" VARCHAR,
"responsible_officer" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_duration_of_contract_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register_july_to_september_2021 (
"supplier_name" VARCHAR,
"company_registration_number" VARCHAR,
"supplier_postcode" VARCHAR,
"uid" VARCHAR,
"council" VARCHAR,
"contract_status" VARCHAR,
"classification" VARCHAR,
"name" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"start_date" TIMESTAMP,
"end_date" TIMESTAMP,
"annual_contract_value_average" VARCHAR,
"value" VARCHAR,
"customer_name" VARCHAR
);
CREATE TABLE contracts_register_july_to_september_2022 (
"uid" VARCHAR,
"council" VARCHAR,
"contract_status" VARCHAR,
"classification" VARCHAR,
"name" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"maximum_extension_date" VARCHAR,
"n__annual_contract_value_average" VARCHAR,
"n__value" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_number" VARCHAR,
"postal_code" VARCHAR,
"supplier_type" VARCHAR,
"customer_name" VARCHAR
);
CREATE TABLE contracts_register_july_to_september_2024 (
"uid" VARCHAR,
"council" VARCHAR,
"contract_status" VARCHAR,
"classification" VARCHAR,
"name" VARCHAR,
"star_category_manager" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"start_date" TIMESTAMP,
"end_date" VARCHAR,
"maximum_extension_date" VARCHAR,
"annual_contract_value_average" VARCHAR,
"value" VARCHAR,
"supplier_name" VARCHAR,
"company_reg_no" VARCHAR,
"postcode" VARCHAR,
"supplier_type" VARCHAR,
"customer_name" VARCHAR
);
CREATE TABLE contracts_register_october_to_december_2018 (
"uid" BIGINT,
"client" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_duration_of_contract_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register_october_to_december_2019 (
"uid" VARCHAR,
"client" VARCHAR,
"category" VARCHAR,
"status" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_duration_of_contract_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register_october_to_december_2020 (
"uid" BIGINT,
"client" VARCHAR,
"status" VARCHAR,
"pro_class" VARCHAR,
"contract_title" VARCHAR,
"route_to_market" VARCHAR,
"agreement_type" VARCHAR,
"contract_start_date" VARCHAR,
"contract_term_months" VARCHAR,
"maximum_duration_of_contract_months" VARCHAR,
"contract_end_date" VARCHAR,
"ext_applied_to_contract" VARCHAR,
"maximum_extend_date" VARCHAR,
"review_date" VARCHAR,
"estimated_annual_value" VARCHAR,
"estimated_total_value" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"registered_number" VARCHAR,
"postcode" VARCHAR,
"council_directorate" VARCHAR
);
CREATE TABLE contracts_register_october_to_december_2022 (
"uid" VARCHAR,
"council" VARCHAR,
"contract_status" VARCHAR,
"classification" VARCHAR,
"name" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"maximum_extension_date" VARCHAR,
"n__annual_contract_value_average" VARCHAR,
"n__value" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_number" VARCHAR,
"postal_code" VARCHAR,
"supplier_type" VARCHAR,
"customer_name" VARCHAR
);
CREATE TABLE contracts_register_october_to_december_2024 (
"uid" VARCHAR,
"council" VARCHAR,
"contract_status" VARCHAR,
"classification" VARCHAR,
"name" VARCHAR,
"star_category_manager" VARCHAR,
"route_to_market" VARCHAR,
"contract_type_detail" VARCHAR,
"start_date" TIMESTAMP,
"end_date" VARCHAR,
"maximum_extension_date" VARCHAR,
"n__annual_contract_value_average" VARCHAR,
"n__value" VARCHAR,
"supplier_name" VARCHAR,
"company_registration_number" VARCHAR,
"postcode" VARCHAR,
"supplier_type" VARCHAR,
"customer_name" VARCHAR
);
Anyone who has the link will be able to view this.