Baselight
Sign In

London Building Stock Model 2 (LBSM 2)

Greater London Authority

@ukgov.london_building_stock_model_2_lbsm_2

Loading...
Loading...

About this Dataset

London Building Stock Model 2 (LBSM 2)

The London Building Stock Model v2 provides energy efficiency data for all London homes. This includes information on EPC ratings, heating systems, insulation levels and building fabric.

This dataset represents an update of the original London Building Stock Model, and it brings together data from Energy Performance Certificates (EPCs), alongside data from other sources such as the London borough councils and the GLA. For properties that don't have data from an EPC or an alternative source, we’ve generated modelled values for these properties through machine learning. For more information on our methodology, please see this blog post.

An interactive map for this data is available here. The data from the London Building Stock Model interactive map has been made available through the data extracts below.

The current version of the London Building Stock Model v2 is based on data from October 2024.

The data contains Ordnance Survey mapping and the data is published under Ordnance Survey's 'presumption to publish'. © Crown copyright and database rights 2023
Publisher name: Greater London Authority
Last updated: 2025-05-27T04:01:23Z

Tables

London Building Stock Model 2 - Merton

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_merton
  • 3.87 MB
  • 88265 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_merton (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Bromley

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_bromley
  • 6.3 MB
  • 143916 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_bromley (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Barnet

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_barnet
  • 7.27 MB
  • 162828 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_barnet (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Hillingdon

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_hillingdon
  • 4.54 MB
  • 118533 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_hillingdon (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Richmond Upon Thames

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_richmond_upon_thames
  • 3.8 MB
  • 86291 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_richmond_upon_thames (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Hounslow

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_hounslow
  • 4.3 MB
  • 110935 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_hounslow (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Bexley

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_bexley
  • 4.4 MB
  • 101485 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_bexley (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Haringey

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_haringey
  • 4.55 MB
  • 119067 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_haringey (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Tower Hamlets

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_tower_hamlets
  • 4.29 MB
  • 144191 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_tower_hamlets (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Camden

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_camden
  • 4.04 MB
  • 121640 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_camden (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Hammersmith & Fulham

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_hammersmith_fulham
  • 3.54 MB
  • 100320 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_hammersmith_fulham (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Greenwich

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_greenwich
  • 4.94 MB
  • 128997 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_greenwich (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Brent

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_brent
  • 5.13 MB
  • 135126 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_brent (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Kensington And Chelsea

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_kensington_and_chelsea
  • 3.03 MB
  • 92022 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_kensington_and_chelsea (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" DOUBLE,
  "basement_floor" DOUBLE,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" DOUBLE,
  "solar_pv_potential_11_9" DOUBLE,
  "avg_tilt" DOUBLE,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Redbridge

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_redbridge
  • 4.4 MB
  • 108113 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_redbridge (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Hackney

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_hackney
  • 4.24 MB
  • 124118 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_hackney (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Westminster

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_westminster
  • 4.53 MB
  • 138510 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_westminster (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Islington

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_islington
  • 3.74 MB
  • 109039 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_islington (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Ealing

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_ealing
  • 5.44 MB
  • 149228 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_ealing (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Kingston Upon Thames

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_kingston_upon_thames
  • 3.18 MB
  • 76407 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_kingston_upon_thames (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Southwark

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_southwark
  • 5.17 MB
  • 149062 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_southwark (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Waltham Forest

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_waltham_forest
  • 4.54 MB
  • 111589 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_waltham_forest (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Barking & Dagenham

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_barking_dagenham
  • 3.26 MB
  • 81070 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_barking_dagenham (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Wandsworth

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_wandsworth
  • 5.87 MB
  • 161126 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_wandsworth (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Harrow

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_harrow
  • 3.77 MB
  • 97795 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_harrow (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Croydon

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_croydon
  • 6.61 MB
  • 170383 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_croydon (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Lewisham

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_lewisham
  • 5.33 MB
  • 139377 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_lewisham (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Havering

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_havering
  • 5.42 MB
  • 108759 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_havering (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Newham

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_newham
  • 4.91 MB
  • 131250 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_newham (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Lambeth

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_lambeth
  • 5.43 MB
  • 150273 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_lambeth (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Enfield

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_enfield
  • 5.61 MB
  • 132530 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_enfield (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - City Of London

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_city_of_london
  • 284.93 KB
  • 8441 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_city_of_london (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

London Building Stock Model 2 - Sutton

@ukgov.london_building_stock_model_2_lbsm_2.london_building_stock_model_2_sutton
  • 3.63 MB
  • 86848 rows
  • 63 columns
Loading... 

CREATE TABLE london_building_stock_model_2_sutton (
  "uprn" BIGINT,
  "os_topo_toid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "postcode_locator" VARCHAR,
  "administrative_area" VARCHAR,
  "oa21cd" VARCHAR,
  "lsoa21cd" VARCHAR,
  "lsoa21nm" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ward22cd" VARCHAR,
  "ward22nm" VARCHAR,
  "property_type" VARCHAR,
  "built_form" VARCHAR,
  "property_type_built_form" VARCHAR,
  "tenure" VARCHAR,
  "tenure_known" BIGINT,
  "building_use" VARCHAR,
  "construction_age_band" VARCHAR,
  "construction_age_band_known" BIGINT,
  "epc_score" BIGINT,
  "epc_score_known" BIGINT,
  "epc_rating" VARCHAR,
  "epc_rating_known" BIGINT,
  "potential_epc_score" BIGINT,
  "potential_epc_score_known" BIGINT,
  "potential_epc_rating" VARCHAR,
  "potential_epc_rating_known" BIGINT,
  "number_habitable_rooms" VARCHAR,
  "number_habitable_rooms_known" BIGINT,
  "total_floor_area" BIGINT,
  "total_floor_area_known" BIGINT,
  "estimated_floor_count" VARCHAR,
  "basement_floor" VARCHAR,
  "wall_type" VARCHAR,
  "wall_type_known" BIGINT,
  "wall_insulation" VARCHAR,
  "wall_insulation_known" BIGINT,
  "roof_type" VARCHAR,
  "roof_type_known" BIGINT,
  "roof_insulation" VARCHAR,
  "roof_insulation_known" BIGINT,
  "glazing_type" VARCHAR,
  "glazing_type_known" BIGINT,
  "main_heat_type" VARCHAR,
  "main_heat_type_known" BIGINT,
  "main_fuel_type" VARCHAR,
  "main_fuel_type_known" BIGINT,
  "energy_consumption" BIGINT,
  "energy_consumption_known" BIGINT,
  "solar_pv_area" VARCHAR,
  "solar_pv_potential_11_9" VARCHAR,
  "avg_tilt" VARCHAR,
  "imd19_national_decile" BIGINT,
  "imd19_income_decile" BIGINT,
  "loac_supergroup" VARCHAR,
  "loac_group" VARCHAR,
  "fuel_poverty" DOUBLE,
  "heat_risk_quintile" BIGINT,
  "listed_building_grade" VARCHAR,
  "conservation_area_flag" VARCHAR,
  "conservation_area_site_id" VARCHAR
);

Share link

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