Born in Bradford Data Dictionary

BiB property level public transport and traffic data

Table ID: BiB_Geographic.bib_geog_public_transport_traffic

github | csv

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

Summarises the availability of public transport and volume of vehicle traffic at property address. Amount of public transport access points (e.g. bus stops, train stations) are measured using distance decay and street network distance at a range of radii (300m to 2000m). Vehicle traffic volume is measured at morning, afternoon and evening within a street network distance of 100m and 300m, with additional measures of congestion at the same time periods.
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
pt_2021_air_count_e_4_0_001 Distance decay weighted (0.001) count of airports
Distance decay weighted (parameter β = 0.001) count of airports.
decimal mean (sd)
0.00 (0.00)

min < median < max
0.00 < 0.00 < 0.00

Complete: 4045 (12.64%)

pt_2021_air_count_e_4_0_003 Distance decay weighted (0.003) count of airports
Distance decay weighted (parameter β = 0.003) count of airports.
decimal mean (sd)
0.00 (0.00)

min < median < max
0.00 < 0.00 < 0.00

Complete: 4045 (12.64%)

pt_2021_air_count_e_4_0_005 Distance decay weighted (0.005) count of airports
Distance decay weighted (parameter β = 0.005) count of airports.
decimal mean (sd)
0.00 (0.00)

min < median < max
0.00 < 0.00 < 0.00

Complete: 4045 (12.64%)

pt_2021_air_count_e_4_0_007 Distance decay weighted (0.007) count of airports
Distance decay weighted (parameter β = 0.007) count of airports.
decimal mean (sd)
0.00 (0.00)

min < median < max
0.00 < 0.00 < 0.00

Complete: 4045 (12.64%)

pt_2021_air_count_e_4_0_01 Distance decay weighted (0.01) count of airports
Distance decay weighted (parameter β = 0.01) count of airports.
decimal mean (sd)
0.00 (0.00)

min < median < max
0.00 < 0.00 < 0.00

Complete: 4045 (12.64%)

pt_2021_air_count_f_2_300 Count of airports within street network 300m
Count of airports within street network based distance of 300m.
decimal mean (sd)
0.00 (0.00)

min < median < max
0.00 < 0.00 < 0.00

Complete: 4045 (12.64%)

pt_2021_air_count_f_2500 Count of airports within street network of 500m
Count of airports within street network based distance of 500m.
decimal mean (sd)
0.00 (0.00)

min < median < max
0.00 < 0.00 < 0.00

Complete: 4045 (12.64%)

pt_2021_air_count_f_2_1000 Count of airports within street network of 1000m
Count of airports within street network based distance of 1000m.
decimal mean (sd)
0.00 (0.00)

min < median < max
0.00 < 0.00 < 0.00

Complete: 4045 (12.64%)

pt_2021_air_count_f_2_2000 Count of airports within street network of 2000m
Count of airports within street network based distance of 2000m.
decimal mean (sd)
0.00 (0.00)

min < median < max
0.00 < 0.00 < 0.00

Complete: 4045 (12.64%)

pt_2021_air_distance_f_2_mean Mean distance to all airports
Average distance to all airports.
decimal mean (sd)
8692.67 (898.97)

min < median < max
5309.33 < 8878.13 < 9999.11

Complete: 4045 (12.64%)

pt_2021_air_closest_d_2 Distance to closest airport in meters
Distance to the closest airport in meters.
decimal mean (sd)
8692.67 (898.97)

min < median < max
5309.33 < 8878.13 < 9999.11

Complete: 4045 (12.64%)

pt_2021_bus_count_e_4_0_001 Distance decay weighted (0.001) count of bus stops
Distance decay weighted (parameter β = 0.001) count of bus stops.
decimal mean (sd)
81.25 (24.16)

min < median < max
10.13 < 85.49 < 146.07

Complete: 26153 (81.71%)

pt_2021_bus_count_e_4_0_003 Distance decay weighted (0.003) count of bus stops
Distance decay weighted (parameter β = 0.003) count of bus stops.
decimal mean (sd)
8.98 (3.51)

min < median < max
0.05 < 8.82 < 28.12

Complete: 26153 (81.71%)

pt_2021_bus_count_e_4_0_005 Distance decay weighted (0.005) count of bus stops
Distance decay weighted (parameter β = 0.005) count of bus stops.
decimal mean (sd)
3.09 (1.50)

min < median < max
0.00 < 2.97 < 13.65

Complete: 26153 (81.71%)

pt_2021_bus_count_e_4_0_007 Distance decay weighted (0.007) count of bus stops
Distance decay weighted (parameter β = 0.007) count of bus stops.
decimal mean (sd)
1.50 (0.90)

min < median < max
0.00 < 1.39 < 8.40

Complete: 26153 (81.71%)

pt_2021_bus_count_e_4_0_01 Distance decay weighted (0.01) count of bus stops
Distance decay weighted (parameter β = 0.01) count of bus stops.
decimal mean (sd)
0.68 (0.54)

min < median < max
0.00 < 0.56 < 5.06

Complete: 26153 (81.71%)

pt_2021_bus_count_f_2_300 Count of bus stops within street network 300m
Count of bus stops within street network based distance of 300m.
decimal mean (sd)
3.33 (2.56)

min < median < max
0.00 < 3.00 < 19.00

Complete: 26153 (81.71%)

pt_2021_bus_count_f_2500 Count of bus stops within street network of 500m
Count of bus stops within street network based distance of 500m.
decimal mean (sd)
9.96 (5.15)

min < median < max
0.00 < 10.00 < 45.00

Complete: 26153 (81.71%)

pt_2021_bus_count_f_2_1000 Count of bus stops within street network of 1000m
Count of bus stops within street network based distance of 1000m.
decimal mean (sd)
41.41 (16.63)

min < median < max
0.00 < 41.00 < 106.00

Complete: 26153 (81.71%)

pt_2021_bus_count_f_2_2000 Count of bus stops within street network of 2000m
Count of bus stops within street network based distance of 2000m.
decimal mean (sd)
168.07 (60.68)

min < median < max
5.00 < 173.00 < 302.00

Complete: 26153 (81.71%)

pt_2021_bus_distance_f_2_mean Mean distance to all bus stops
Average distance to all bus stops.
decimal mean (sd)
6246.59 (416.69)

min < median < max
5079.84 < 6245.50 < 7684.37

Complete: 26153 (81.71%)

pt_2021_bus_closest_d_2 Distance to closest bus stop in meters
Distance to the closest bus stop in meters.
decimal mean (sd)
208.22 (124.61)

min < median < max
10.05 < 185.20 < 1758.36

Complete: 26153 (81.71%)

pt_2021_coach_count_e_4_0_001 Distance decay weighted (0.001) count of coach stops
Distance decay weighted (parameter β = 0.001) count of coach stops.
decimal mean (sd)
1.62 (2.24)

min < median < max
0.00 < 0.76 < 19.95

Complete: 26153 (81.71%)

pt_2021_coach_count_e_4_0_003 Distance decay weighted (0.003) count of coach stops
Distance decay weighted (parameter β = 0.003) count of coach stops.
decimal mean (sd)
0.08 (0.40)

min < median < max
0.00 < 0.00 < 9.46

Complete: 26153 (81.71%)

pt_2021_coach_count_e_4_0_005 Distance decay weighted (0.005) count of coach stops
Distance decay weighted (parameter β = 0.005) count of coach stops.
decimal mean (sd)
0.01 (0.14)

min < median < max
0.00 < 0.00 < 5.85

Complete: 26153 (81.71%)

pt_2021_coach_count_e_4_0_007 Distance decay weighted (0.007) count of coach stops
Distance decay weighted (parameter β = 0.007) count of coach stops.
decimal mean (sd)
0.00 (0.06)

min < median < max
0.00 < 0.00 < 4.05

Complete: 26153 (81.71%)

pt_2021_coach_count_e_4_0_01 Distance decay weighted (0.01) count of coach stops
Distance decay weighted (parameter β = 0.01) count of coach stops.
decimal mean (sd)
0.00 (0.03)

min < median < max
0.00 < 0.00 < 2.36

Complete: 26153 (81.71%)

pt_2021_coach_count_f_2_300 Count of coach stops within street network 300m
Count of coach stops within street network based distance of 300m.
decimal mean (sd)
0.00 (0.18)

min < median < max
0.00 < 0.00 < 15.00

Complete: 26153 (81.71%)

pt_2021_coach_count_f_2500 Count of coach stops within street network of 500m
Count of coach stops within street network based distance of 500m.
decimal mean (sd)
0.02 (0.65)

min < median < max
0.00 < 0.00 < 29.00

Complete: 26153 (81.71%)

pt_2021_coach_count_f_2_1000 Count of coach stops within street network of 1000m
Count of coach stops within street network based distance of 1000m.
decimal mean (sd)
0.39 (3.16)

min < median < max
0.00 < 0.00 < 29.00

Complete: 26153 (81.71%)

pt_2021_coach_count_f_2_2000 Count of coach stops within street network of 2000m
Count of coach stops within street network based distance of 2000m.
decimal mean (sd)
3.44 (9.10)

min < median < max
0.00 < 0.00 < 29.00

Complete: 26153 (81.71%)

pt_2021_coach_distance_f_2_mean Mean distance to all coach stop
Average distance to all coach stop.
decimal mean (sd)
5111.35 (1443.42)

min < median < max
404.52 < 4978.14 < 9583.70

Complete: 26153 (81.71%)

pt_2021_coach_closest_d_2 Distance to closest coach stop in meters
Distance to the closest coach stop in meters.
decimal mean (sd)
3787.77 (1636.87)

min < median < max
152.26 < 3588.66 < 9280.10

Complete: 26153 (81.71%)

pt_2021_metro_count_e_4_0_001 Distance decay weighted (0.001) count of metro stations
Distance decay weighted (parameter β = 0.001) count of metro stations.
decimal mean (sd)
0.04 (0.16)

min < median < max
0.00 < 0.00 < 1.23

Complete: 2584 (8.07%)

pt_2021_metro_count_e_4_0_003 Distance decay weighted (0.003) count of metro stations
Distance decay weighted (parameter β = 0.003) count of metro stations.
decimal mean (sd)
0.01 (0.04)

min < median < max
0.00 < 0.00 < 0.69

Complete: 2584 (8.07%)

pt_2021_metro_count_e_4_0_005 Distance decay weighted (0.005) count of metro stations
Distance decay weighted (parameter β = 0.005) count of metro stations.
decimal mean (sd)
0.00 (0.02)

min < median < max
0.00 < 0.00 < 0.53

Complete: 2584 (8.07%)

pt_2021_metro_count_e_4_0_007 Distance decay weighted (0.007) count of metro stations
Distance decay weighted (parameter β = 0.007) count of metro stations.
decimal mean (sd)
0.00 (0.01)

min < median < max
0.00 < 0.00 < 0.41

Complete: 2584 (8.07%)

pt_2021_metro_count_e_4_0_01 Distance decay weighted (0.01) count of metro stations
Distance decay weighted (parameter β = 0.01) count of metro stations.
decimal mean (sd)
0.00 (0.01)

min < median < max
0.00 < 0.00 < 0.28

Complete: 2584 (8.07%)

pt_2021_metro_count_f_2_300 Count of metro stations within street network 300m
Count of metro stations within street network based distance of 300m.
decimal mean (sd)
0.00 (0.05)

min < median < max
0.00 < 0.00 < 1.00

Complete: 2584 (8.07%)

pt_2021_metro_count_f_2500 Count of metro stations within street network of 500m
Count of metro stations within street network based distance of 500m.
decimal mean (sd)
0.01 (0.09)

min < median < max
0.00 < 0.00 < 1.00

Complete: 2584 (8.07%)

pt_2021_metro_count_f_2_1000 Count of metro stations within street network of 1000m
Count of metro stations within street network based distance of 1000m.
decimal mean (sd)
0.03 (0.19)

min < median < max
0.00 < 0.00 < 2.00

Complete: 2584 (8.07%)

pt_2021_metro_count_f_2_2000 Count of metro stations within street network of 2000m
Count of metro stations within street network based distance of 2000m.
decimal mean (sd)
0.09 (0.39)

min < median < max
0.00 < 0.00 < 3.00

Complete: 2584 (8.07%)

pt_2021_metro_distance_f_2_mean Mean distance to all metro stations
Average distance to all metro stations.
decimal mean (sd)
8411.39 (1879.74)

min < median < max
2120.05 < 9216.54 < 9999.89

Complete: 2584 (8.07%)

pt_2021_metro_closest_d_2 Distance to closest metro station in meters
Distance to the closest metro station in meters.
decimal mean (sd)
7722.51 (2549.64)

min < median < max
125.80 < 8770.47 < 9999.89

Complete: 2584 (8.07%)

pt_2021_rail_count_e_4_0_001 Distance decay weighted (0.001) count of rail stations
Distance decay weighted (parameter β = 0.001) count of rail stations.
decimal mean (sd)
0.24 (0.25)

min < median < max
0.00 < 0.16 < 1.49

Complete: 26153 (81.71%)

pt_2021_rail_count_e_4_0_003 Distance decay weighted (0.003) count of rail stations
Distance decay weighted (parameter β = 0.003) count of rail stations.
decimal mean (sd)
0.02 (0.06)

min < median < max
0.00 < 0.00 < 0.92

Complete: 26153 (81.71%)

pt_2021_rail_count_e_4_0_005 Distance decay weighted (0.005) count of rail stations
Distance decay weighted (parameter β = 0.005) count of rail stations.
decimal mean (sd)
0.01 (0.04)

min < median < max
0.00 < 0.00 < 0.86

Complete: 26153 (81.71%)

pt_2021_rail_count_e_4_0_007 Distance decay weighted (0.007) count of rail stations
Distance decay weighted (parameter β = 0.007) count of rail stations.
decimal mean (sd)
0.00 (0.02)

min < median < max
0.00 < 0.00 < 0.81

Complete: 26153 (81.71%)

pt_2021_rail_count_e_4_0_01 Distance decay weighted (0.01) count of airports
Distance decay weighted (parameter β = 0.01) count of airports.
decimal mean (sd)
0.00 (0.02)

min < median < max
0.00 < 0.00 < 0.74

Complete: 26153 (81.71%)

pt_2021_rail_count_f_2_300 Count of rail stations within street network 300m
Count of rail stations within street network based distance of 300m.
decimal mean (sd)
0.01 (0.07)

min < median < max
0.00 < 0.00 < 1.00

Complete: 26153 (81.71%)

pt_2021_rail_count_f_2500 Count of rail stations within street network of 500m
Count of rail stations within street network based distance of 500m.
decimal mean (sd)
0.02 (0.13)

min < median < max
0.00 < 0.00 < 2.00

Complete: 26153 (81.71%)

pt_2021_rail_count_f_2_1000 Count of rail stations within street network of 1000m
Count of rail stations within street network based distance of 1000m.
decimal mean (sd)
0.09 (0.31)

min < median < max
0.00 < 0.00 < 2.00

Complete: 26153 (81.71%)

pt_2021_rail_count_f_2_2000 Count of rail stations within street network of 2000m
Count of rail stations within street network based distance of 2000m.
decimal mean (sd)
0.46 (0.79)

min < median < max
0.00 < 0.00 < 3.00

Complete: 26153 (81.71%)

pt_2021_rail_distance_f_2_mean Mean distance to all rail stations
Average distance to all rail stations.
decimal mean (sd)
6306.24 (857.25)

min < median < max
3621.44 < 6161.42 < 9721.02

Complete: 26153 (81.71%)

pt_2021_rail_closest_d_2 Distance to closest rail station in meters
Distance to the closest rail station in meters.
decimal mean (sd)
2922.72 (1494.52)

min < median < max
29.73 < 2693.26 < 9552.77

Complete: 26153 (81.71%)

tr_2019_am_count_f_2_300_mean Mean number of vehicles during morning period within street network 300m
Average number of vehicles during morning period within street network based distance of 300m.
decimal mean (sd)
167.47 (175.28)

min < median < max
0.00 < 121.00 < 2131.00

Complete: 26149 (81.70%)

tr_2019_am_cong_f_2_300_mean Mean congestion during morning period within street network 300m
Average congestion during morning period within street network based distance of 300m.
decimal mean (sd)
0.94 (0.05)

min < median < max
0.65 < 0.95 < 1.00

Complete: 26149 (81.70%)

tr_2019_ip_count_f_2_300_mean Mean number of vehicles during intermediate period within street network 300m
Average number of vehicles during intermediate period within street network based distance of 300m.
decimal mean (sd)
822.88 (829.09)

min < median < max
0.00 < 606.00 < 10316.00

Complete: 26149 (81.70%)

tr_2019_ip_cong_f_2_300_mean Mean vehicle congestion during intermediate period within street network 300m
Average congestion of vehicles during intermediate period within street network based distance of 300m.
decimal mean (sd)
0.93 (0.05)

min < median < max
0.69 < 0.93 < 1.00

Complete: 26149 (81.70%)

tr_2019_pm_count_f_2_300_mean Mean number of vehicles during evening period within street network 300m
Average number of vehicles during evening period within street network based distance of 300m.
decimal mean (sd)
112.30 (103.11)

min < median < max
0.00 < 85.00 < 1288.00

Complete: 26149 (81.70%)

tr_2019_pm_cong_f_2_300_mean Mean vehicle congestion during evening period within street network 300m
Average congestion of vehicles during evening period within street network based distance of 300m.
decimal mean (sd)
0.94 (0.05)

min < median < max
0.64 < 0.95 < 1.00

Complete: 26149 (81.70%)

tr_2019_am_count_f_2_300_max Max number of vehicles during morning period within street network 300m
Maximum number of vehicles during morning period within street network based distance of 300m.
decimal mean (sd)
961.01 (779.18)

min < median < max
0.00 < 787.00 < 5407.00

Complete: 26149 (81.70%)

tr_2019_am_cong_f_2_300_min Minimum congestion during morning period within street network 300m
Minimum congestion during morning period within street network based distance of 300m.
decimal mean (sd)
0.56 (0.23)

min < median < max
0.06 < 0.55 < 1.00

Complete: 26149 (81.70%)

tr_2019_ip_count_f_2_300_max Max number of vehicles during intermediate period within street network 300m
Maximum number of vehicles during intermediate period within street network based distance of 300m.
decimal mean (sd)
4638.06 (3598.11)

min < median < max
0.00 < 3994.00 < 20758.00

Complete: 26149 (81.70%)

tr_2019_ip_cong_f_2_300_min Minimum congestion during intermediate period within street network 300m
Minimum congestion during intermediate period within street network based distance of 300m.
decimal mean (sd)
0.52 (0.21)

min < median < max
0.02 < 0.50 < 1.00

Complete: 26149 (81.70%)

tr_2019_pm_count_f_2_300_max Max number of vehicles during evening period within street network 300m
Maximum number of vehicles during evening period within street network based distance of 300m.
decimal mean (sd)
615.25 (433.19)

min < median < max
0.00 < 569.00 < 2630.00

Complete: 26149 (81.70%)

tr_2019_pm_cong_f_2_300_min Minimum congestion during evening period within street network 300m
Minimum congestion during evening period within street network based distance of 300m.
decimal mean (sd)
0.55 (0.25)

min < median < max
0.03 < 0.54 < 1.00

Complete: 26149 (81.70%)

tr_2019_am_count_f_2_100_mean Mean number of vehicles during morning period within street network of 100m
Average number of vehicles during morning period within street network based distance of 100m.
decimal mean (sd)
132.87 (212.08)

min < median < max
0.00 < 42.00 < 3039.00

Complete: 26117 (81.60%)

tr_2019_am_cong_f_2_100_mean Mean congestion during morning period within street network of 100m
Average congestion during morning period within street network based distance of 100m.
decimal mean (sd)
0.95 (0.06)

min < median < max
0.41 < 0.98 < 1.00

Complete: 26117 (81.60%)

tr_2019_ip_count_f_2_100_mean Mean number of vehicles during intermediate period within street network of 100m
Average number of vehicles during intermediate period within street network based distance of 100m.
decimal mean (sd)
654.40 (999.73)

min < median < max
0.00 < 228.00 < 14713.00

Complete: 26117 (81.60%)

tr_2019_ip_cong_f_2_100_mean Mean vehicle congestion during intermediate period within street network of 100m
Average congestion of vehicles during intermediate period within street network based distance of 100m.
decimal mean (sd)
0.93 (0.07)

min < median < max
0.34 < 0.95 < 1.00

Complete: 26117 (81.60%)

tr_2019_pm_count_f_2_100_mean Mean number of vehicles during evening period within street network of 100m
Average number of vehicles during evening period within street network based distance of 100m.
decimal mean (sd)
90.95 (131.79)

min < median < max
0.00 < 37.00 < 1829.00

Complete: 26117 (81.60%)

tr_2019_pm_cong_f_2_100_mean Mean vehicle congestion during evening period within street network of 100m
Average congestion of vehicles during evening period within street network based distance of 100m.
decimal mean (sd)
0.95 (0.06)

min < median < max
0.44 < 0.97 < 1.00

Complete: 26117 (81.60%)

tr_2019_am_count_f_2_100_max Max number of vehicles during morning period within street network of 100m
Maximum number of vehicles during morning period within street network based distance of 100m.
decimal mean (sd)
501.42 (655.51)

min < median < max
0.00 < 187.00 < 4997.00

Complete: 26117 (81.60%)

tr_2019_am_cong_f_2_100_min Minimum congestion during morning period within street network of 100m
Minimum congestion during morning period within street network based distance of 100m.
decimal mean (sd)
0.76 (0.23)

min < median < max
0.08 < 0.81 < 1.00

Complete: 26117 (81.60%)

tr_2019_ip_count_f_2_100_max Max number of vehicles during intermediate period within street network of 100m
Maximum number of vehicles during intermediate period within street network based distance of 100m.
decimal mean (sd)
2433.46 (3059.95)

min < median < max
0.00 < 942.00 < 19711.00

Complete: 26117 (81.60%)

tr_2019_ip_cong_f_2_100_min Minimum congestion during intermediate period within street network of 100m
Minimum congestion during intermediate period within street network based distance of 100m.
decimal mean (sd)
0.70 (0.22)

min < median < max
0.02 < 0.74 < 1.00

Complete: 26117 (81.60%)

tr_2019_pm_count_f_2_100_max Max number of vehicles during evening period within street network of 100m
Maximum number of vehicles during evening period within street network based distance of 100m.
decimal mean (sd)
329.93 (381.40)

min < median < max
0.00 < 158.00 < 2630.00

Complete: 26117 (81.60%)

tr_2019_pm_cong_f_2_100_min Minimum congestion during evening period within street network of 100m
Minimum congestion during evening period within street network based distance of 100m.
decimal mean (sd)
0.75 (0.24)

min < median < max
0.03 < 0.80 < 1.00

Complete: 26117 (81.60%)

tr_2019_am_count_closest_b_2 Count of vehicles during morning period at residential street
Count of vehicles during morning period at the residential street.
decimal mean (sd)
62.95 (242.77)

min < median < max
0.00 < 0.00 < 3487.00

Complete: 25291 (79.01%)

tr_2019_am_cong_closest_b_2 Congestion during morning period at residential street
Congestion during morning period at the residential street.
decimal mean (sd)
0.97 (0.09)

min < median < max
0.08 < 1.00 < 1.00

Complete: 25291 (79.01%)

tr_2019_ip_count_closest_b_2 Count of vehicles during intermediate period at residential street
Count of vehicles during intermediate period at the residential street.
decimal mean (sd)
311.53 (1150.85)

min < median < max
0.00 < 0.00 < 16422.00

Complete: 25291 (79.01%)

tr_2019_ip_cong_closest_b_2 Congestion during intermediate period at residential street
Congestion during intermediate period at the residential street.
decimal mean (sd)
0.96 (0.11)

min < median < max
0.10 < 1.00 < 1.00

Complete: 25291 (79.01%)

tr_2019_pm_count_closest_b_2 Count of vehicles during evening period at residential street
Count of vehicles during evening period at the residential street.
decimal mean (sd)
45.87 (158.27)

min < median < max
0.00 < 0.00 < 1833.00

Complete: 25291 (79.01%)

tr_2019_pm_cong_closest_b_2 Congestion during evening period at residential street
Congestion during evening period at the residential street.
decimal mean (sd)
0.97 (0.09)

min < median < max
0.06 < 1.00 < 1.00

Complete: 25291 (79.01%)