About this Dataset

Bristol City Council Land And Building Assets

This dataset comprises all land and building assets owned, used and/or managed by Bristol City Council, with the exception of individual social housing units, in accordance with the requirements of the Local Government Transparency Code 2014. This is the first annual update of this dataset, the first version having been published in January 2015. As was the case with the original version, it may contain some errors and omissions (particularly with regard to some Council Housing assets which it has still not been possible to include while excluding all individual housing units, as well as the existence of some ground leases which have been difficult or impossible to identify from our database). Some improvements have been made with regard to the accuracy of the data, but we are still striving to correct and improve the data so that future submissions will be increasingly more accurate.
Publisher name: Bristol City Council
Last updated: 2025-01-26T04:02:33Z

Tables

Bristol City Council Land And Building Assets

@ukgov.bristol_city_council_land_and_building_assets_2014.bristol_city_council_land_and_building_assets

350.57 KB
4039 rows
32 columns


CREATE TABLE bristol_city_council_land_and_building_assets (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "uprn" DOUBLE,
  "property_id" BIGINT,
  "property_type" VARCHAR,
  "property_name" VARCHAR,
  "property_name_address_where_no_uprn" VARCHAR,
  "street_number" DOUBLE,
  "secondary_address_detail" VARCHAR,
  "street" VARCHAR,
  "town_post_town" VARCHAR,
  "postcode" VARCHAR,
  "non_postal_address" VARCHAR,
  "ward" VARCHAR,
  "geo_x_easting" DOUBLE,
  "geo_y_northing" DOUBLE,
  "tenure_type" VARCHAR,
  "ground_lease_in" VARCHAR,
  "ground_lease_out" VARCHAR,
  "lease_in_to_council" VARCHAR,
  "lease_out" VARCHAR,
  "licence_in_to_council" VARCHAR,
  "licence_out" VARCHAR,
  "sub_lease_in_to_council" VARCHAR,
  "sub_lease_out" VARCHAR,
  "vacant" VARCHAR,
  "holding_type" VARCHAR,
  "building_size_gia_m2" DOUBLE,
  "site_area_hectares" DOUBLE,
  "purpose_asset_category" VARCHAR,
  "occupied_by_council_direct_service_property" VARCHAR
);

Land And Building Assets 2019

@ukgov.bristol_city_council_land_and_building_assets_2014.land_and_building_assets_2019

332.01 KB
3804 rows
32 columns


CREATE TABLE land_and_building_assets_2019 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "uprn" DOUBLE,
  "property_id" BIGINT,
  "property_type" VARCHAR,
  "property_name" VARCHAR,
  "property_name_address_where_no_uprn" VARCHAR,
  "street_number" DOUBLE,
  "secondary_address_detail" VARCHAR,
  "street" VARCHAR,
  "town_post_town" VARCHAR,
  "post_code" VARCHAR,
  "non_postal_address" VARCHAR,
  "ward" VARCHAR,
  "geo_x_easting" DOUBLE,
  "geo_y_northing" DOUBLE,
  "tenure_type" VARCHAR,
  "ground_lease_in" VARCHAR,
  "ground_lease_out" VARCHAR,
  "lease_in_to_council" VARCHAR,
  "lease_out" VARCHAR,
  "licence_in_to_council" VARCHAR,
  "licence_out" VARCHAR,
  "sub_lease_in_to_council" VARCHAR,
  "sub_lease_out" VARCHAR,
  "vacant" VARCHAR,
  "asset_type" VARCHAR,
  "building_size_gia_m2" DOUBLE,
  "site_area_hectares" DOUBLE,
  "occupied_by_council_direct_service_property" VARCHAR,
  "purpose_asset_category" VARCHAR
);

Land And Property Assets 2020

@ukgov.bristol_city_council_land_and_building_assets_2014.land_and_property_assets_2020

333.8 KB
3819 rows
32 columns


CREATE TABLE land_and_property_assets_2020 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "uprn" DOUBLE,
  "property_id" BIGINT,
  "property_type" VARCHAR,
  "property_name" VARCHAR,
  "property_name_address_where_no_uprn" VARCHAR,
  "street_number" DOUBLE,
  "secondary_address_detail" VARCHAR,
  "street" VARCHAR,
  "town_post_town" VARCHAR,
  "post_code" VARCHAR,
  "non_postal_address" VARCHAR,
  "ward" VARCHAR,
  "geo_x_easting" BIGINT,
  "geo_y_northing" BIGINT,
  "tenure_type" VARCHAR,
  "ground_lease_in" VARCHAR,
  "ground_lease_out" VARCHAR,
  "lease_in_to_council" VARCHAR,
  "lease_out" VARCHAR,
  "licence_in_to_council" VARCHAR,
  "licence_out" VARCHAR,
  "sub_lease_in_to_council" VARCHAR,
  "sub_lease_out" VARCHAR,
  "vacant" VARCHAR,
  "asset_type" VARCHAR,
  "building_size_gia_m2" DOUBLE,
  "site_area_hectares" DOUBLE,
  "occupied_by_council_direct_service_property" VARCHAR,
  "purpose_asset_category" VARCHAR
);

Land And Property Assets 2021

@ukgov.bristol_city_council_land_and_building_assets_2014.land_and_property_assets_2021

340.27 KB
3820 rows
32 columns


CREATE TABLE land_and_property_assets_2021 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "uprn" DOUBLE,
  "property_id" BIGINT,
  "property_type" VARCHAR,
  "property_name" VARCHAR,
  "property_name_address_where_no_uprn" VARCHAR,
  "secondary_address_detail" VARCHAR,
  "street_number" DOUBLE,
  "street" VARCHAR,
  "town_post_town" VARCHAR,
  "post_code" VARCHAR,
  "non_postal_address" VARCHAR,
  "ward" VARCHAR,
  "geo_x_easting" BIGINT,
  "geo_y_northing" BIGINT,
  "tenure_type" VARCHAR,
  "ground_lease_in" VARCHAR,
  "ground_lease_out" VARCHAR,
  "lease_in_to_council" VARCHAR,
  "lease_out" VARCHAR,
  "licence_in_to_council" VARCHAR,
  "licence_out" VARCHAR,
  "sub_lease_in_to_council" VARCHAR,
  "sub_lease_out" VARCHAR,
  "vacant" VARCHAR,
  "asset_type" VARCHAR,
  "building_size_gia_m2" DOUBLE,
  "site_area_hectares" DOUBLE,
  "occupied_by_council_direct_service_property" VARCHAR,
  "purpose_asset_category" VARCHAR
);