Born in Bradford Data Dictionary

BiB property level built environment and indoor building quality

Table ID: BiB_Geographic.bib_geog_built_env_indoor_qual

github | csv

Entity type Variables Entities Updated Related tables
Property 39 32008 2023-05-17 NA

Describes the immediate built environment of a participant’s address and indoor qualities of a participant’s home. Built environment (be) variables measure the geometry of the building and block containing the participants address. Indoor qualities (iq) variables use Energy Performance Certificate (EPC) data to measure the property’s energy use/efficiency and to describe the internal layout and features of the property.
Usage instructions: To link to BiB participants, use the id column to link to the property_id variable in bib_geog_person.
Further information: Created by Kimon Krenz, on behalf of Born in Bradford. Please reference Krenz et al. (2023) when using this data, where more detailed methodological information can be found regarding the construction of these variables.

variable label value_type summary
iq_2021_inspection_date The date that inspection was actually carried out by energy assessor
The date that the inspection was actually carried out by the energy assessor.
date from 2008-07-28
to 2021-12-31

Complete: 21469 (67.07%)

iq_2021_construction_age_band Age band when building part constructed
Age band when building part constructed. England & Wales only. One of: before 1900; 1900-1929; 1930-1949; 1950-1966; 1967-1975; 1976-1982; 1983-1990; 1991-1995; 1996-2002; 2003-2006; 2007-2011; 2012 onwards.
text 13 unique values
21469 non-missing values
4 to 31 characters
iq_2021_built_form The building type of address
The building type of the property, e.g., Detached, Semi-Detached, Terrace, etc..Together with the Property Type, the Build Form produces a structured description of the property.
text 7 unique values
21469 non-missing values
8 to 20 characters
iq_2021_property_type The property type of address
Describes the type of property such as House, Flat, Maisonette etc. This is the type differentiator for dwellings. 
text 4 unique values
21469 non-missing values
4 to 10 characters
iq_2021_floor_level Floor level relative to lowest level of property (0 for ground floor)
Floor level relative to the lowest level of the property (0 for ground floor). If there is a basement, the basement is level 0 and the other floors are from 1 upwards. Measure only availabe for flats and maisonettes.
text 31 unique values
21469 non-missing values
2 to 16 characters
iq_2021_flat_storey_count The number of storeys in apartment block. 
The number of storeys in the apartment block. 
decimal mean (sd)
3.43 (2.46)

min < median < max
1.00 < 3.00 < 15.00

Complete: 453 (1.42%)

iq_2021_flat_top_storey Whether flat is on top storey. Measure availabe for flats only
Whether the flat is on the top storey. Measure availabe for flats only.
text 3 unique values
21469 non-missing values
1 to 16 characters
iq_2021_total_floor_area Total m2 of all enclosed spaces measured to internal face of external walls
The total useful floor area in square meter is the total of all enclosed spaces measured to the internal face of the external walls, i.e., the gross floor area as measured in accordance with the guidance issued from time to time by the Royal Institute of Chartered Surveyors or by a body replacing that institution.
decimal mean (sd)
98.70 (53.32)

min < median < max
0.00 < 85.00 < 2846.00

Complete: 21469 (67.07%)

iq_2021_floor_height Mean height of storey in metres. 
Average height of the storey in metres. 
decimal mean (sd)
2.48 (0.30)

min < median < max
0.00 < 2.44 < 17.56

Complete: 7725 (24.13%)

iq_2021_number_heated_rooms Number of heated rooms in property if > half of habitable rooms are not heated
The number of heated rooms in the property if more than half of the habitable rooms are not heated. 
decimal mean (sd)
4.86 (1.76)

min < median < max
0.00 < 5.00 < 24.00

Complete: 20765 (64.87%)

iq_2021_number_habitable_rooms Number of rooms used/intended to be used for sleeping/living
Habitable rooms include any living room, sitting room, dining room, bedroom, study and similar; and also a non-separated conservatory. A kitchen/diner having a discrete seating area (with space for a table and four chairs) also counts as a habitable room. A non-separated conservatory adds to the habitable room count if it has an internal quality door between it and the dwelling. Excluded from the room count are any room used solely as a kitchen, utility room, bathroom, cloakroom, en-suite accommodation and similar and any hallway, stairs or landing; and also any room not having a window. 
decimal mean (sd)
5.00 (1.73)

min < median < max
1.00 < 5.00 < 24.00

Complete: 20765 (64.87%)

iq_2021_extension_count The number of extensions added to property
The number of extensions added to the property.
decimal mean (sd)
0.28 (0.55)

min < median < max
0.00 < 0.00 < 4.00

Complete: 20765 (64.87%)

iq_2021_glazed_area Ranged estimate of total glazed area of habitable area
Ranged estimate of the total glazed area of the habitable area.
text 6 unique values
21469 non-missing values
6 to 22 characters
iq_2021_glazed_type The type of glazing, using Fenestration Rating Council/manufacturer declaration
The type of glazing, using British Fenestration Rating Council or manufacturer declaration.
text 7 unique values
21469 non-missing values
14 to 45 characters
iq_2021_energy_use_current Current estimated total energy consumption for property inkWh/m²
Current estimated total energy consumption for the property in a 12-month period in kilowatt hours per square metre (kWh/m²).
decimal mean (sd)
295.83 (108.30)

min < median < max
-1.00 < 289.00 < 2687.00

Complete: 21469 (67.07%)

iq_2021_energy_use_potential Estimated potential total energy consumption for property inkWh/m²
Estimated potential total energy consumption for the property in a 12-month period in kilowatt hours per square metre (kWh/m²).
decimal mean (sd)
154.54 (74.98)

min < median < max
-121.00 < 143.00 < 1877.00

Complete: 21469 (67.07%)

iq_2021_hot_water_cost_current Current estimated annual energy costs for hot water in GBP
Current estimated annual energy costs for hot water in GBP.
decimal mean (sd)
121.00 (62.93)

min < median < max
-1.00 < 106.00 < 992.00

Complete: 21469 (67.07%)

iq_2021_heating_cost_current Current estimated annual energy costs for heating property in GBP
Current estimated annual energy costs for heating the property in GBP.
decimal mean (sd)
951.01 (677.78)

min < median < max
-1.00 < 770.00 < 25554.00

Complete: 21469 (67.07%)

iq_2021_lighting_cost_current Current estimated annual energy costs for lighting property in GBP
Current estimated annual energy costs for lighting the property in GBP.
decimal mean (sd)
85.14 (34.60)

min < median < max
-1.00 < 79.00 < 991.00

Complete: 21469 (67.07%)

iq_2021_potential_energy_effcncy The potential energy efficiency rating of property. 
The potential energy efficiency rating of the property. 
decimal mean (sd)
79.03 (8.34)

min < median < max
1.00 < 80.00 < 118.00

Complete: 21469 (67.07%)

iq_2021_current_energy_effcncy Energy used for heating, water and lighting multiplied by fuel costs (£m2year)
Energy efficiency based on cost of energy, i.e. energy required for space heating, water heating and lighting (in kWh/year) multiplied by fuel costs. (£/m²/year where cost is derived from kWh).
decimal mean (sd)
59.82 (12.14)

min < median < max
1.00 < 60.00 < 99.00

Complete: 21469 (67.07%)

iq_2021_potential_energy_rating Estimated potential energy rating converted into a linear ‘A to G’ rating
Estimated potential energy rating converted into a linear ‘A to G’ rating (where A is the most energy efficient and G is the least energy efficient).
text 7 unique values
21469 non-missing values
1 characters
iq_2021_current_energy_rating Current energy rating converted into a linear ‘A to G’ rating
Current energy rating converted into a linear ‘A to G’ rating (where A is the most energy efficient and G is the least energy efficient).
text 7 unique values
21469 non-missing values
1 characters
iq_2021_transaction_type Type of transaction that triggered assessment
Type of transaction that triggered assessment.
text 15 unique values
21469 non-missing values
6 to 25 characters
iq_2021_tenure_type Describes tenure type of property
Describes the tenure type of the property.
text 5 unique values
21469 non-missing values
7 to 16 characters
be_2021_footprint_a Size of building footprint of building containing home address in m2
Size of the building footprint of the building containing the home address in square meters.
decimal mean (sd)
69.35 (107.61)

min < median < max
4.10 < 48.45 < 2472.34

Complete: 25999 (81.23%)

be_2021_height_a Height of building containing home address in meters
Height of the building containing the home address in meters.
decimal mean (sd)
6.18 (2.33)

min < median < max
0.10 < 5.80 < 39.60

Complete: 25999 (81.23%)

be_2021_volume_a Volume of building containing home address in cubic m2
Volume of the building containing the home address in cubic square meters.
decimal mean (sd)
540.66 (2018.56)

min < median < max
7.93 < 279.94 < 54363.86

Complete: 25999 (81.23%)

be_2021_floorarea_a Floor area of building containing home address in m2
Floor area of the building containing the home address in square meters.
decimal mean (sd)
180.22 (672.85)

min < median < max
2.64 < 93.31 < 18121.29

Complete: 25999 (81.23%)

be_2021_fsi_c Floor-space index (FSI) of block containing home address
Floor-space index (FSI) of the block containing the home address.
decimal mean (sd)
0.39 (0.27)

min < median < max
0.00 < 0.31 < 4.15

Complete: 25999 (81.23%)

be_2021_gsi_c Ground-space index (GSI) of block containing home address
Ground-space index (GSI) of the block containing the home address.
decimal mean (sd)
0.20 (0.09)

min < median < max
0.00 < 0.19 < 0.65

Complete: 25999 (81.23%)

be_2021_osr_c Open-space ratio (OSR) of block containing home address
Open-space ratio (OSR) of the block containing the home address.
decimal mean (sd)
259275.91 (666587.86)

min < median < max
259.31 < 42968.77 < 49940355.27

Complete: 25999 (81.23%)

be_2021_l_c Mean building layers of floors (L) of block containing home address
Average building layers of floors (L) of the block containing the home address.
decimal mean (sd)
1.85 (0.49)

min < median < max
0.58 < 1.72 < 7.48

Complete: 25999 (81.23%)

be_2021_blockarea_c Size of block containing home address in m2
Size of the block containing the home address in square meters.
decimal mean (sd)
259276.48 (666587.88)

min < median < max
259.93 < 42969.41 < 49940356.01

Complete: 25999 (81.23%)

be_2021_footprint_c_sum Sum of all building footprints within block containing home address in m2
Sum of all building footprints within the block containing the home address in square meters.
decimal mean (sd)
23645.22 (35879.41)

min < median < max
38.44 < 8124.72 < 188852.36

Complete: 25999 (81.23%)

be_2021_height_c_mean Mean height of all buildings within block containing home address in meters
Average height of all buildings within the block containing the home address in meters.
decimal mean (sd)
5.10 (1.33)

min < median < max
1.56 < 4.73 < 23.25

Complete: 25999 (81.23%)

be_2021_floorarea_c_sum Sum of floor area within block containing home address in m2
Sum of floor area within the block containing the home address in square meters.
decimal mean (sd)
40026.55 (59895.09)

min < median < max
62.79 < 14275.48 < 367760.52

Complete: 25999 (81.23%)

be_2021_volume_c_sum Sum of volume of all buildings within block containing home address in m2
Sum of volume of all buildings within the block containing the home address in square meters.
decimal mean (sd)
120079.65 (179685.27)

min < median < max
188.36 < 42826.44 < 1103281.56

Complete: 25999 (81.23%)

be_2021_volume_density_c Volume density of block containing home address in m2
Volume density of the block containing the home address in square meters.
decimal mean (sd)
1.17 (0.80)

min < median < max
0.00 < 0.93 < 12.46

Complete: 25999 (81.23%)