Baselight
Sign In

London Building Stock Model (LBSM)

Greater London Authority

@ukgov.london_building_stock_model_lbsm

Loading...
Loading...

About this Dataset

London Building Stock Model (LBSM)

The Mayor is committed to cutting fuel poverty and increasing the energy efficiency of buildings across London. To help target where action is most needed, the Mayor has developed a London Building Stock Model with the UCL Energy Institute. The London Building Stock Model is a database of all the energy and carbon data collected through the Mayor’s energy programmes and policies. It provides a snapshot of all London’s buildings (both domestic and non-domestic) with information on their energy performance certificates as of 2017. More information is available here, and an interactive map is available here. Most of the data from the London Building Stock Model interactive map has been made available through the data extracts below. Please note that the data extracts are based on Ordnance Survey's list of London properties as of 2023. However, as the London Building Stock Model data is from 2017, some of the properties might not have any London Building Stock Model data attached to them. 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: 2024-06-14T04:02:21Z

Tables

London Building Stock Model - Barking & Dagenham Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_barking_dagenham_data
  • 4.55 MB
  • 94,121 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_barking_dagenham_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Barnet Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_barnet_data
  • 8.78 MB
  • 184,518 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_barnet_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Bexley Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_bexley_data
  • 5.86 MB
  • 113,773 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_bexley_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Brent Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_brent_data
  • 6.4 MB
  • 161,102 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_brent_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Bromley Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_bromley_data
  • 8.25 MB
  • 167,567 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_bromley_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Camden Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_camden_data
  • 4.7 MB
  • 168,421 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_camden_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - City Of London Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_city_of_london_data
  • 586.7 kB
  • 19,365 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_city_of_london_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Croydon Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_croydon_data
  • 8.84 MB
  • 191,324 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_croydon_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Ealing Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_ealing_data
  • 7.46 MB
  • 178,456 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_ealing_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Enfield Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_enfield_data
  • 7.04 MB
  • 153,346 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_enfield_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Greenwich Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_greenwich_data
  • 6.18 MB
  • 147,929 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_greenwich_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Hackney Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_hackney_data
  • 4.59 MB
  • 155,608 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_hackney_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Hammersmith & Fulham Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_hammersmith_fulham_data
  • 4.22 MB
  • 128,414 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_hammersmith_fulham_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Haringey Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_haringey_data
  • 5.59 MB
  • 145,429 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_haringey_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Harrow Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_harrow_data
  • 5.47 MB
  • 112,055 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_harrow_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Havering Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_havering_data
  • 6.99 MB
  • 124,601 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_havering_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Hillingdon Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_hillingdon_data
  • 7.43 MB
  • 146,731 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_hillingdon_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Hounslow Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_hounslow_data
  • 6.04 MB
  • 129,232 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_hounslow_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Islington Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_islington_data
  • 4.39 MB
  • 149,021 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_islington_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Kensington & Chelsea Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_kensington_chelsea_data
  • 3.6 MB
  • 116,529 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_kensington_chelsea_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Kingston Upon Thames Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_kingston_upon_thames_data
  • 3.99 MB
  • 90,223 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_kingston_upon_thames_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Lambeth Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_lambeth_data
  • 6.62 MB
  • 184,711 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_lambeth_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Lewisham Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_lewisham_data
  • 6.38 MB
  • 161,176 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_lewisham_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Merton Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_merton_data
  • 5.42 MB
  • 111,725 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_merton_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Newham Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_newham_data
  • 6.08 MB
  • 151,833 rows
  • 43 columns
Loading... 
CREATE TABLE london_building_stock_model_newham_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

Share link

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