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 - 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 - 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 - 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 - 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
);

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 - 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 - 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 - 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
);

Share link

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