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.33 MB
  • 94121 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.38 MB
  • 184518 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.59 MB
  • 113773 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.1 MB
  • 161102 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
  • 7.87 MB
  • 167567 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.48 MB
  • 168421 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
  • 572.95 KB
  • 19365 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.43 MB
  • 191324 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.11 MB
  • 178456 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
  • 6.71 MB
  • 153346 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
  • 5.89 MB
  • 147929 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.37 MB
  • 155608 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.02 MB
  • 128414 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.33 MB
  • 145429 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.22 MB
  • 112055 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.67 MB
  • 124601 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.08 MB
  • 146731 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
  • 5.76 MB
  • 129232 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.19 MB
  • 149021 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.43 MB
  • 116529 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.8 MB
  • 90223 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.31 MB
  • 184711 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.08 MB
  • 161176 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.17 MB
  • 111725 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
  • 5.8 MB
  • 151833 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.