Baselight
Sign In

Bristol City Council Contracts Over £5000

Bristol City Council

@ukgov.bristol_city_council_contracts_over_5000

Loading...
Loading...

About this Dataset

Bristol City Council Contracts Over £5000

Quarterly publication Bristol City Council details of any contract including: reference number title of agreement local authority department responsible description of the goods and/or services being provided supplier name and details sum to be paid over the length of the contract or the estimated annual spending or budget for the contract Value Added Tax that cannot be recovered start, end and review dates whether or not the contract was the result of an invitation to quote or a published invitation to tender whether or not the supplier is a small or medium sized enterprise and/or a voluntary or community sector organisation and where it is, provide the relevant registration number.
Publisher name: Bristol City Council
Last updated: 2025-02-13T04:00:02Z

Tables

April 2019 - June 2019

@ukgov.bristol_city_council_contracts_over_5000.april_2019_june_2019
  • 51.7 kB
  • 105 rows
  • 40 columns
Loading... 
CREATE TABLE april_2019_june_2019 (
  "organisationalcode" VARCHAR,
  "organisationname" VARCHAR,
  "reference_no" VARCHAR,
  "lots" BIGINT,
  "title" VARCHAR,
  "department" VARCHAR,
  "buyer" VARCHAR,
  "description" VARCHAR,
  "description_of_the_geographical_coverage" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "awarded_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "appraisal_date" TIMESTAMP,
  "display_until_date" TIMESTAMP,
  "visibility" VARCHAR,
  "initial_contract_period_months" BIGINT  -- Initial Contract Period (months),
  "total_option_to_extend_months" VARCHAR  -- Total Option To Extend (months),
  "total_contract_period_months" BIGINT  -- Total Contract Period (months),
  "available_no_of_ext" DOUBLE  -- Available No. Of Ext.,
  "available_extension_details" VARCHAR,
  "taken_no_of_ext" BIGINT  -- Taken No. Of Ext.,
  "taken_extension_details" VARCHAR,
  "estimated_value" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "vat_not_recovered" VARCHAR,
  "internal_id" VARCHAR,
  "primary_contact" VARCHAR,
  "process_used" VARCHAR,
  "ojeu" VARCHAR,
  "open_to_other_organisations" VARCHAR,
  "participating_organisations" VARCHAR,
  "central_purchasing_body" VARCHAR,
  "framework_type" VARCHAR,
  "keywords" VARCHAR,
  "categories" VARCHAR,
  "custom_fields_field_value" VARCHAR  -- Custom Fields (Field:Value),
  "public_notes" VARCHAR,
  "portal_notes" VARCHAR,
  "private_notes" VARCHAR
);

April 2021 - June 2021

@ukgov.bristol_city_council_contracts_over_5000.april_2021_june_2021
  • 122.57 kB
  • 502 rows
  • 49 columns
Loading... 
CREATE TABLE april_2021_june_2021 (
  "organisational_code" VARCHAR,
  "organisation_name" VARCHAR,
  "reference_no" VARCHAR,
  "lot_title" VARCHAR,
  "lot_description" VARCHAR,
  "company_name" VARCHAR,
  "registration_number" VARCHAR,
  "sme" BOOLEAN,
  "vcs" VARCHAR,
  "contact_name" VARCHAR,
  "postcode" VARCHAR,
  "reference_no2" VARCHAR,
  "lots" BIGINT,
  "title" VARCHAR,
  "department" VARCHAR,
  "buyer" VARCHAR,
  "description" VARCHAR,
  "description_of_the_geographical_coverage" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "awarded_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "appraisal_date" DOUBLE,
  "display_until_date" TIMESTAMP,
  "visibility" VARCHAR,
  "initial_contract_period_months" BIGINT  -- Initial Contract Period (months),
  "total_option_to_extend_months" VARCHAR  -- Total Option To Extend (months),
  "total_contract_period_months" BIGINT  -- Total Contract Period (months),
  "available_no_of_ext" DOUBLE  -- Available No. Of Ext.,
  "available_extension_details" VARCHAR,
  "taken_no_of_ext" BIGINT  -- Taken No. Of Ext.,
  "taken_extension_details" VARCHAR,
  "estimated_value" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "awarded_value" VARCHAR,
  "vat_not_recovered" VARCHAR,
  "internal_id" VARCHAR,
  "primary_contact" VARCHAR,
  "process_used" VARCHAR,
  "ojeu" VARCHAR,
  "open_to_other_organisations" VARCHAR,
  "participating_organisations" VARCHAR,
  "central_purchasing_body" VARCHAR,
  "framework_type" VARCHAR,
  "keywords" VARCHAR,
  "categories" VARCHAR,
  "public_notes" VARCHAR,
  "portal_notes" VARCHAR,
  "private_notes" VARCHAR
);

Jan 2019 - March 2019

@ukgov.bristol_city_council_contracts_over_5000.jan_2019_march_2019
  • 55.45 kB
  • 116 rows
  • 40 columns
Loading... 
CREATE TABLE jan_2019_march_2019 (
  "organisationalcode" VARCHAR,
  "organisationname" VARCHAR,
  "reference_no" VARCHAR,
  "lots" BIGINT,
  "title" VARCHAR,
  "department" VARCHAR,
  "buyer" VARCHAR,
  "description" VARCHAR,
  "description_of_the_geographical_coverage" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "awarded_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "appraisal_date" TIMESTAMP,
  "display_until_date" TIMESTAMP,
  "visibility" VARCHAR,
  "initial_contract_period_months" BIGINT  -- Initial Contract Period (months),
  "total_option_to_extend_months" VARCHAR  -- Total Option To Extend (months),
  "total_contract_period_months" BIGINT  -- Total Contract Period (months),
  "available_no_of_ext" DOUBLE  -- Available No. Of Ext.,
  "available_extension_details" VARCHAR,
  "taken_no_of_ext" BIGINT  -- Taken No. Of Ext.,
  "taken_extension_details" VARCHAR,
  "estimated_value" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "vat_not_recovered" VARCHAR,
  "internal_id" VARCHAR,
  "primary_contact" VARCHAR,
  "process_used" VARCHAR,
  "ojeu" VARCHAR,
  "open_to_other_organisations" VARCHAR,
  "participating_organisations" VARCHAR,
  "central_purchasing_body" VARCHAR,
  "framework_type" VARCHAR,
  "keywords" VARCHAR,
  "categories" VARCHAR,
  "custom_fields_field_value" VARCHAR  -- Custom Fields (Field:Value),
  "public_notes" VARCHAR,
  "portal_notes" VARCHAR,
  "private_notes" VARCHAR
);

Jan 2020 - March 2020

@ukgov.bristol_city_council_contracts_over_5000.jan_2020_march_2020
  • 72.62 kB
  • 189 rows
  • 49 columns
Loading... 
CREATE TABLE jan_2020_march_2020 (
  "organisational_code" VARCHAR,
  "organisation_name" VARCHAR,
  "reference_no" VARCHAR,
  "lot_title" VARCHAR,
  "lot_description" VARCHAR,
  "company_name" VARCHAR,
  "registration_number" VARCHAR,
  "sme" BOOLEAN,
  "vcs" VARCHAR,
  "contact_name" VARCHAR,
  "postcode" VARCHAR,
  "reference_no2" VARCHAR,
  "lots" BIGINT,
  "title" VARCHAR,
  "department" VARCHAR,
  "buyer" VARCHAR,
  "description" VARCHAR,
  "description_of_the_geographical_coverage" VARCHAR,
  "start_date" BIGINT,
  "end_date" BIGINT,
  "awarded_date" DOUBLE,
  "review_date" BIGINT,
  "appraisal_date" DOUBLE,
  "display_until_date" BIGINT,
  "visibility" VARCHAR,
  "initial_contract_period_months" BIGINT  -- Initial Contract Period (months),
  "total_option_to_extend_months" VARCHAR  -- Total Option To Extend (months),
  "total_contract_period_months" BIGINT  -- Total Contract Period (months),
  "available_no_of_ext" DOUBLE  -- Available No. Of Ext.,
  "available_extension_details" VARCHAR,
  "taken_no_of_ext" BIGINT  -- Taken No. Of Ext.,
  "taken_extension_details" VARCHAR,
  "estimated_value" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "vat_not_recovered" VARCHAR,
  "internal_id" VARCHAR,
  "primary_contact" VARCHAR,
  "process_used" VARCHAR,
  "ojeu" VARCHAR,
  "open_to_other_organisations" VARCHAR,
  "participating_organisations" VARCHAR,
  "central_purchasing_body" VARCHAR,
  "framework_type" VARCHAR,
  "keywords" VARCHAR,
  "categories" VARCHAR,
  "custom_fields_field_value" VARCHAR  -- Custom Fields (Field:Value),
  "public_notes" VARCHAR,
  "portal_notes" VARCHAR,
  "private_notes" VARCHAR
);

Jan 2021 - March 2021

@ukgov.bristol_city_council_contracts_over_5000.jan_2021_march_2021
  • 113.63 kB
  • 481 rows
  • 50 columns
Loading... 
CREATE TABLE jan_2021_march_2021 (
  "organisational_code" VARCHAR,
  "organisation_name" VARCHAR,
  "reference_no" VARCHAR,
  "lot_title" VARCHAR,
  "lot_description" VARCHAR,
  "company_name" VARCHAR,
  "registration_number" VARCHAR,
  "sme" BOOLEAN,
  "vcs" VARCHAR,
  "contact_name" VARCHAR,
  "postcode" VARCHAR,
  "reference_no2" VARCHAR,
  "lots" BIGINT,
  "title" VARCHAR,
  "department" VARCHAR,
  "buyer" VARCHAR,
  "description" VARCHAR,
  "description_of_the_geographical_coverage" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" VARCHAR,
  "awarded_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "appraisal_date" TIMESTAMP,
  "display_until_date" TIMESTAMP,
  "visibility" VARCHAR,
  "initial_contract_period_months" BIGINT  -- Initial Contract Period (months),
  "total_option_to_extend_months" VARCHAR  -- Total Option To Extend (months),
  "total_contract_period_months" BIGINT  -- Total Contract Period (months),
  "available_no_of_ext" DOUBLE  -- Available No. Of Ext.,
  "available_extension_details" VARCHAR,
  "taken_no_of_ext" BIGINT  -- Taken No. Of Ext.,
  "taken_extension_details" VARCHAR,
  "estimated_value" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "awarded_value" VARCHAR,
  "vat_not_recovered" VARCHAR,
  "internal_id" VARCHAR,
  "primary_contact" VARCHAR,
  "process_used" VARCHAR,
  "ojeu" VARCHAR,
  "open_to_other_organisations" VARCHAR,
  "participating_organisations" VARCHAR,
  "central_purchasing_body" VARCHAR,
  "framework_type" VARCHAR,
  "keywords" VARCHAR,
  "categories" VARCHAR,
  "custom_fields_field_value" VARCHAR  -- Custom Fields (Field:Value),
  "public_notes" VARCHAR,
  "portal_notes" VARCHAR,
  "private_notes" VARCHAR
);

July 2019 - September 2019

@ukgov.bristol_city_council_contracts_over_5000.july_2019_september_2019
  • 63.78 kB
  • 161 rows
  • 45 columns
Loading... 
CREATE TABLE july_2019_september_2019 (
  "reference_no" VARCHAR,
  "lot_title" VARCHAR,
  "lot_description" VARCHAR,
  "company_name" VARCHAR,
  "registration_number" VARCHAR,
  "sme" BOOLEAN,
  "vcs" VARCHAR,
  "contact_name" VARCHAR,
  "postcode" VARCHAR,
  "title" VARCHAR,
  "department" VARCHAR,
  "buyer" VARCHAR,
  "description" VARCHAR,
  "description_of_the_geographical_coverage" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "awarded_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "appraisal_date" TIMESTAMP,
  "display_until_date" TIMESTAMP,
  "visibility" VARCHAR,
  "initial_contract_period_months" BIGINT  -- Initial Contract Period (months),
  "total_option_to_extend_months" VARCHAR  -- Total Option To Extend (months),
  "total_contract_period_months" BIGINT  -- Total Contract Period (months),
  "available_no_of_ext" DOUBLE  -- Available No. Of Ext.,
  "available_extension_details" VARCHAR,
  "taken_no_of_ext" BIGINT  -- Taken No. Of Ext.,
  "taken_extension_details" BIGINT,
  "estimated_value" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "vat_not_recovered" VARCHAR,
  "internal_id" VARCHAR,
  "primary_contact" VARCHAR,
  "process_used" VARCHAR,
  "ojeu" VARCHAR,
  "open_to_other_organisations" VARCHAR,
  "participating_organisations" VARCHAR,
  "central_purchasing_body" VARCHAR,
  "framework_type" VARCHAR,
  "keywords" VARCHAR,
  "categories" VARCHAR,
  "custom_fields_field_value" VARCHAR  -- Custom Fields (Field:Value),
  "public_notes" VARCHAR,
  "portal_notes" VARCHAR,
  "private_notes" VARCHAR
);

July 2020 - September 2020

@ukgov.bristol_city_council_contracts_over_5000.july_2020_september_2020
  • 81.74 kB
  • 242 rows
  • 48 columns
Loading... 
CREATE TABLE july_2020_september_2020 (
  "organisational_code" VARCHAR,
  "organisation_name" VARCHAR,
  "reference_no" VARCHAR,
  "lot_title" VARCHAR,
  "lot_description" VARCHAR,
  "company_name" VARCHAR,
  "registration_number" VARCHAR,
  "sme" BOOLEAN,
  "vcs" VARCHAR,
  "contact_name" VARCHAR,
  "postcode" VARCHAR,
  "reference_no2" VARCHAR,
  "lots" BIGINT,
  "title" VARCHAR,
  "department" VARCHAR,
  "buyer" VARCHAR,
  "description" VARCHAR,
  "description_of_the_geographical_coverage" VARCHAR,
  "start_date" BIGINT,
  "end_date" BIGINT,
  "awarded_date" DOUBLE,
  "review_date" BIGINT,
  "appraisal_date" DOUBLE,
  "display_until_date" BIGINT,
  "visibility" VARCHAR,
  "initial_contract_period_months" BIGINT  -- Initial Contract Period (months),
  "total_option_to_extend_months" VARCHAR  -- Total Option To Extend (months),
  "total_contract_period_months" BIGINT  -- Total Contract Period (months),
  "available_no_of_ext" DOUBLE  -- Available No. Of Ext.,
  "available_extension_details" VARCHAR,
  "taken_no_of_ext" BIGINT  -- Taken No. Of Ext.,
  "taken_extension_details" VARCHAR,
  "estimated_value" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "vat_not_recovered" VARCHAR,
  "internal_id" VARCHAR,
  "primary_contact" VARCHAR,
  "process_used" VARCHAR,
  "ojeu" VARCHAR,
  "open_to_other_organisations" VARCHAR,
  "participating_organisations" VARCHAR,
  "central_purchasing_body" VARCHAR,
  "framework_type" VARCHAR,
  "keywords" VARCHAR,
  "categories" VARCHAR,
  "public_notes" VARCHAR,
  "portal_notes" VARCHAR,
  "private_notes" VARCHAR
);

July 2021 - September 2021

@ukgov.bristol_city_council_contracts_over_5000.july_2021_september_2021
  • 106.73 kB
  • 518 rows
  • 49 columns
Loading... 
CREATE TABLE july_2021_september_2021 (
  "organisational_code" VARCHAR,
  "organisation_name" VARCHAR,
  "reference_no" VARCHAR,
  "lot_title" VARCHAR,
  "lot_description" VARCHAR,
  "company_name" VARCHAR,
  "registration_number" VARCHAR,
  "sme" VARCHAR,
  "vcs" VARCHAR,
  "contact_name" VARCHAR,
  "postcode" VARCHAR,
  "reference_no2" VARCHAR,
  "lots" DOUBLE,
  "title" VARCHAR,
  "department" VARCHAR,
  "buyer" VARCHAR,
  "description" VARCHAR,
  "description_of_the_geographical_coverage" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "awarded_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "appraisal_date" TIMESTAMP,
  "display_until_date" TIMESTAMP,
  "visibility" VARCHAR,
  "initial_contract_period_months" DOUBLE  -- Initial Contract Period (months),
  "total_option_to_extend_months" VARCHAR  -- Total Option To Extend (months),
  "total_contract_period_months" DOUBLE  -- Total Contract Period (months),
  "available_no_of_ext" DOUBLE  -- Available No. Of Ext.,
  "available_extension_details" VARCHAR,
  "taken_no_of_ext" DOUBLE  -- Taken No. Of Ext.,
  "taken_extension_details" VARCHAR,
  "estimated_value" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "awarded_value" VARCHAR,
  "vat_not_recovered" VARCHAR,
  "internal_id" VARCHAR,
  "primary_contact" VARCHAR,
  "process_used" VARCHAR,
  "ojeu" VARCHAR,
  "open_to_other_organisations" VARCHAR,
  "participating_organisations" VARCHAR,
  "central_purchasing_body" VARCHAR,
  "framework_type" VARCHAR,
  "keywords" VARCHAR,
  "categories" VARCHAR,
  "public_notes" VARCHAR,
  "portal_notes" VARCHAR,
  "private_notes" VARCHAR
);

October 2019 - December 2019

@ukgov.bristol_city_council_contracts_over_5000.october_2019_december_2019
  • 75.95 kB
  • 178 rows
  • 48 columns
Loading... 
CREATE TABLE october_2019_december_2019 (
  "organisational_code" VARCHAR,
  "organisation_name" VARCHAR,
  "reference_no" VARCHAR,
  "lot_title" VARCHAR,
  "lot_description" VARCHAR,
  "company_name" VARCHAR,
  "registration_number" VARCHAR,
  "sme" BOOLEAN,
  "vcs" VARCHAR,
  "contact_name" VARCHAR,
  "postcode" VARCHAR,
  "lots" BIGINT,
  "title" VARCHAR,
  "department" VARCHAR,
  "buyer" VARCHAR,
  "description" VARCHAR,
  "description_of_the_geographical_coverage" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "awarded_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "appraisal_date" TIMESTAMP,
  "display_until_date" TIMESTAMP,
  "visibility" VARCHAR,
  "initial_contract_period_months" BIGINT  -- Initial Contract Period (months),
  "total_option_to_extend_months" VARCHAR  -- Total Option To Extend (months),
  "total_contract_period_months" BIGINT  -- Total Contract Period (months),
  "available_no_of_ext" DOUBLE  -- Available No. Of Ext.,
  "available_extension_details" VARCHAR,
  "taken_no_of_ext" BIGINT  -- Taken No. Of Ext.,
  "taken_extension_details" VARCHAR,
  "estimated_value" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "vat_not_recovered" VARCHAR,
  "internal_id" VARCHAR,
  "primary_contact" VARCHAR,
  "process_used" VARCHAR,
  "ojeu" VARCHAR,
  "open_to_other_organisations" VARCHAR,
  "participating_organisations" VARCHAR,
  "central_purchasing_body" VARCHAR,
  "framework_type" VARCHAR,
  "keywords" VARCHAR,
  "categories" VARCHAR,
  "custom_fields_field_value" VARCHAR  -- Custom Fields (Field:Value),
  "public_notes" VARCHAR,
  "portal_notes" VARCHAR,
  "private_notes" VARCHAR
);

October 2020 - December 2020

@ukgov.bristol_city_council_contracts_over_5000.october_2020_december_2020
  • 332.1 kB
  • 2,139 rows
  • 23 columns
Loading... 
CREATE TABLE october_2020_december_2020 (
  "organisational_code" VARCHAR,
  "organisational_name" VARCHAR,
  "org_name1" VARCHAR,
  "project_ref_no" VARCHAR,
  "project_title" VARCHAR,
  "estimated_value" VARCHAR,
  "department" VARCHAR,
  "officer" VARCHAR,
  "contract_start_date" TIMESTAMP,
  "contract_end_date" TIMESTAMP,
  "contract_period" DOUBLE,
  "extensions" DOUBLE,
  "rfx_type" VARCHAR,
  "supplier_company_name" VARCHAR,
  "supplier_town" VARCHAR,
  "supplier_county" VARCHAR,
  "supplier_postcode" VARCHAR,
  "sme_status" VARCHAR,
  "supplier_classification" VARCHAR,
  "contract_review_date" TIMESTAMP,
  "supplier_company_reg_number" VARCHAR,
  "description" VARCHAR,
  "vatnotrecovered" DOUBLE
);

October 2021 - December 2021

@ukgov.bristol_city_council_contracts_over_5000.october_2021_december_2021
  • 105.81 kB
  • 469 rows
  • 49 columns
Loading... 
CREATE TABLE october_2021_december_2021 (
  "organisational_code" VARCHAR,
  "organisation_name" VARCHAR,
  "reference_no" VARCHAR,
  "lot_title" VARCHAR,
  "lot_description" VARCHAR,
  "company_name" VARCHAR,
  "registration_number" VARCHAR,
  "sme" VARCHAR,
  "vcs" VARCHAR,
  "contact_name" VARCHAR,
  "postcode" VARCHAR,
  "reference_no2" VARCHAR,
  "lots" DOUBLE,
  "title" VARCHAR,
  "department" VARCHAR,
  "buyer" VARCHAR,
  "description" VARCHAR,
  "description_of_the_geographical_coverage" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "awarded_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "appraisal_date" DOUBLE,
  "display_until_date" TIMESTAMP,
  "visibility" VARCHAR,
  "initial_contract_period_months" DOUBLE  -- Initial Contract Period (months),
  "total_option_to_extend_months" VARCHAR  -- Total Option To Extend (months),
  "total_contract_period_months" DOUBLE  -- Total Contract Period (months),
  "available_no_of_ext" DOUBLE  -- Available No. Of Ext.,
  "available_extension_details" VARCHAR,
  "taken_no_of_ext" DOUBLE  -- Taken No. Of Ext.,
  "taken_extension_details" VARCHAR,
  "estimated_value" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "awarded_value" VARCHAR,
  "vat_not_recovered" VARCHAR,
  "internal_id" VARCHAR,
  "primary_contact" VARCHAR,
  "process_used" VARCHAR,
  "ojeu" VARCHAR,
  "open_to_other_organisations" VARCHAR,
  "participating_organisations" VARCHAR,
  "central_purchasing_body" VARCHAR,
  "framework_type" VARCHAR,
  "keywords" VARCHAR,
  "categories" VARCHAR,
  "public_notes" VARCHAR,
  "portal_notes" VARCHAR,
  "private_notes" VARCHAR
);

Share link

Anyone who has the link will be able to view this.