1  County Longitudinal Data

Year

year

State

state state_name

County

county county_name

Population

population

Predictor: Housing Affordablility

Metric: Ratio of affordable and available housing units to households with low-, very low–, and extremely low income levels

Variables: share_affordable_30_ami, share_affordable_50_ami, share_affordable_80_ami, share_affordable_quality

Years: 2014, 2018, 2021

Disaggregation: None

Variable: share_affordable_30_ami

Summary
Min. Median Mean Max. NA’s
0.41 1.83 1.80 3.52 18860
Data Quality
share_affordable_quality quality_label n
1 Strong 1680
2 Marginal 7741
3 Weak 2
NA NA 18858

Variable: share_affordable_50_ami

Summary
Min. Median Mean Max. NA’s
0.76 1.83 1.81 3.02 18860
Data Quality
share_affordable_quality quality_label n
1 Strong 1680
2 Marginal 7741
3 Weak 2
NA NA 18858

Variable: share_affordable_80_ami

Summary
Min. Median Mean Max. NA’s
1.02 1.68 1.68 2.66 18860
Data Quality
share_affordable_quality quality_label n
1 Strong 1680
2 Marginal 7741
3 Weak 2
NA NA 18858

Predictor: Housing Stability

Metric: Number and share of public school children who are ever homeless during the school year

Variables: count_homeless, share_homeless, count_homeless_lb, count_homeless_ub, homeless_quality

Years: 2014, 2015, 2016, 2017, 2018, 2019

Disaggregation: None

Variable: count_homeless

Summary
Min. Median Mean Max. NA’s
0 86 488 75,094 11218
Data Quality
homeless_quality quality_label n
1 Strong 14575
2 Marginal 581
3 Weak 1908
NA NA 11217

Variable: share_homeless

Summary
Min. Median Mean Max. NA’s
0.00 0.02 0.03 0.68 11251
Data Quality
homeless_quality quality_label n
1 Strong 14575
2 Marginal 581
3 Weak 1908
NA NA 11217

Predictor: Economic Inclusion

Metric: Share of residents experiencing poverty living in high-poverty neighborhoods

Variables: share_poverty_exposure, share_poverty_exposure_quality

Years: 2018, 2021

Disaggregation: Race

Variable: share_poverty_exposure

Summary
Min. Median Mean Max. NA’s
0.00 0.00 0.04 1.00 22010
Data Quality
share_poverty_exposure_quality quality_label n
1 Strong 5746
2 Marginal 496
3 Weak 29
NA NA 22010

Predictor: Racial Diversity

Metric: Neighborhood exposure index, or the share of a person’s neighbors who are people of other races and ethnicities

Variables: share_black_nh_exposure, share_black_nh_exposure_quality, share_hispanic_exposure, share_hispanic_exposure_quality, share_other_nh_exposure, share_other_nh_exposure_quality, share_white_nh_exposure, share_white_nh_exposure_quality

Years: 2018, 2021

Disaggregation: None

Variable: share_black_nh_exposure

Summary
Min. Median Mean Max. NA’s
0.12 0.93 0.84 1.00 22900
Data Quality
share_black_nh_exposure_quality quality_label n
1 Strong 3368
2 Marginal 1339
3 Weak 674
NA NA 22900

Variable: share_hispanic_exposure

Summary
Min. Median Mean Max. NA’s
0.01 0.93 0.87 1.00 22179
Data Quality
share_hispanic_exposure_quality quality_label n
1 Strong 4341
2 Marginal 1410
3 Weak 351
NA NA 22179

Variable: share_other_nh_exposure

Summary
Min. Median Mean Max. NA’s
0.04 0.95 0.92 1.00 22169
Data Quality
share_other_nh_exposure_quality quality_label n
1 Strong 3914
2 Marginal 1791
3 Weak 407
NA NA 22169

Variable: share_white_nh_exposure

Summary
Min. Median Mean Max. NA’s
0.00 0.16 0.21 0.99 21999
Data Quality
share_white_nh_exposure_quality quality_label n
1 Strong 6256
2 Marginal 23
3 Weak 3
NA NA 21999

Predictor: Social Capital

Metric: Number of membership associations per 10,000 people

Variables: count_membership_associations_per_10k, count_membership_associations_per_10k_quality

Years: 2020

Disaggregation: None

Variable: count_membership_associations_per_10k

Summary
Min. Median Mean Max. NA’s
1.00 11.00 11.81 59.80 25290
Data Quality
count_membership_associations_per_10k_quality quality_label n
1 Strong 2991
NA NA 25290

Metric: Ratio of Facebook friends with higher socioeconomic status to Facebook friends with lower socioeconomic status (“economic connectedness”)

Variables: ratio_high_low_ses_fb_friends, ratio_high_low_ses_fb_friends_quality

Years: 2022

Disaggregation: None

Variable: ratio_high_low_ses_fb_friends

Summary
Min. Median Mean Max. NA’s
0.29 0.81 0.81 1.36 25264
Data Quality
ratio_high_low_ses_fb_friends_quality quality_label n
1 Strong 3017
NA NA 25264

Predictor: Transportation Access

Metric: Transit trips index

Variables: transportation_cost, transportation_cost_quality, index_transit_trips, index_transit_trips_quality

Years: 2016

Disaggregation: Race share

Variable: index_transit_trips

Summary
Min. Median Mean Max. NA’s
0.00 18.70 23.13 98.72 25139
Data Quality
index_transit_trips_quality quality_label n
1 Strong 3133
2 Marginal 5
3 Weak 4
NA NA 25139

Variable: transportation_cost

Summary
Min. Median Mean Max. NA’s
0.00 18.23 24.05 98.24 25139
Data Quality
transportation_cost_quality quality_label n
1 Strong 3132
2 Marginal 6
3 Weak 4
NA NA 25139

Predictor: Access to Preschool

Metric: Share of 3- to 4-year-olds enrolled in nursery school or preschool

Variables: share_in_preschool, share_in_preschool_quality

Years: 2018, 2021

Disaggregation: Race/ethnicity

Variable: share_in_preschool

Summary
Min. Median Mean Max. NA’s
0.01 0.39 0.40 0.83 22003
Data Quality
share_in_preschool_quality quality_label n
1 Strong 850
2 Marginal 3380
3 Weak 2053
NA NA 21998

Predictor: Effective Public Education

Metric: Average per grade change in English Language Arts achievement between third and eighth grades

Variables: rate_learning, rate_learning_lb, rate_learning_ub, rate_learning_quality

Years: 2014, 2015, 2016, 2017

Disaggregation: Race/ethnicity, Income

Variable: rate_learning

Summary
Min. Median Mean Max. NA’s
−1.25 0.99 0.99 2.97 16051
Data Quality
rate_learning_quality quality_label n
1 Strong 10316
2 Marginal 762
3 Weak 1152
NA NA 16051

Predictor: School Economic Diversity

Metric: Share of students attending high-poverty schools, by student race or ethnicity

Variables: meps20_black, meps20_black_quality, meps20_hispanic, meps20_hispanic_quality, meps20_white, meps20_white_quality

Years: 2014, 2015, 2016, 2017, 2018

Disaggregation: None

Variable: meps20_black

Summary
Min. Median Mean Max. NA’s
0.00 0.51 0.50 1.00 13040
Data Quality
meps20_black_quality quality_label n
1 Strong 10412
2 Marginal 1622
3 Weak 3207
NA NA 13040

Variable: meps20_hispanic

Summary
Min. Median Mean Max. NA’s
0.00 0.51 0.50 1.00 12687
Data Quality
meps20_hispanic_quality quality_label n
1 Strong 13437
2 Marginal 1033
3 Weak 1124
NA NA 12687

Variable: meps20_white

Summary
Min. Median Mean Max. NA’s
0.00 0.35 0.42 1.00 12593
Data Quality
meps20_white_quality quality_label n
1 Strong 15526
2 Marginal 89
3 Weak 73
NA NA 12593

Predictor: Preparation for College

Metric: Share of 19- and 20-year-olds with a high school degree

Variables: share_hs_degree, share_hs_degree_quality

Years: 2018, 2021

Disaggregation: Race/ethnicity

Variable: share_hs_degree

Summary
Min. Median Mean Max. NA’s
0.40 0.91 0.89 1.00 22000
Data Quality
share_hs_degree_quality quality_label n
1 Strong 860
2 Marginal 2862
3 Weak 2560
NA NA 21999

Predictor: Digital Access

Metric: Share of households with broadband access in the home

Variables: share_digital_access, share_digital_access_quality

Years: 2021

Disaggregation: Race

Variable: share_digital_access

Summary
Min. Median Mean Max. NA’s
0.23 0.84 0.82 0.99 25140
Data Quality
share_digital_access_quality quality_label n
1 Strong 3080
2 Marginal 55
3 Weak 6
NA NA 25140

Predictor: Employment Opportunities

Metric: Employment-to-population ratio for adults ages 25 to 54

Variables: share_employed, share_employed_quality

Years: 2018, 2021

Disaggregation: Race/ethnicity

Variable: share_employed

Summary
Min. Median Mean Max. NA’s
0.41 0.78 0.78 0.93 23043
Data Quality
share_employed_quality quality_label n
1 Strong 1120
2 Marginal 907
3 Weak 4257
NA NA 21997

Predictor: Jobs Paying Living Wages

Metric: Ratio of pay on the average job to the cost of living

Variables: ratio_average_to_living_wage, wage_ratio_quality

Years: 2014, 2018, 2021

Disaggregation: None

Variable: ratio_average_to_living_wage

Summary
Min. Median Mean Max. NA’s
0.36 0.65 0.67 1.64 18860
Data Quality
ratio_average_to_living_wage_quality quality_label n
1 Strong 9386
3 Weak 36
NA NA 18859

Predictor: Opportunities for Income

Metric: Household income at the 20th, 50th, and 80th percentiles

Variables: pctl_income_20, pctl_income_50, pctl_income_80, pctl_income_quality

Years: 2018, 2021

Disaggregation: Race/ethnicity

Variable: pctl_income_20

Summary
Min. Median Mean Max. NA’s
9,068.57 23,273.97 24,071.12 79,202.52 22711
Data Quality
pctl_income_quality quality_label n
1 Strong 1120
2 Marginal 908
3 Weak 4256
NA NA 21997

Variable: pctl_income_50

Summary
Min. Median Mean Max. NA’s
26,125.96 54,182.12 56,487.19 174,000.23 22711
Data Quality
pctl_income_quality quality_label n
1 Strong 1120
2 Marginal 908
3 Weak 4256
NA NA 21997

Variable: pctl_income_80

Summary
Min. Median Mean Max. NA’s
65,928.21 103,373.28 108,925.90 329,496.85 22711
Data Quality
pctl_income_quality quality_label n
1 Strong 1120
2 Marginal 908
3 Weak 4256
NA NA 21997

Predictor: Financial Security

Metric: Share with debt in collections

Variables: share_debt_col, share_debt_col_lb, share_debt_col_ub, share_debt_col_quality

Years: 2018, 2022

Disaggregation: Race share

Variable: share_debt_col

Summary
Min. Median Mean Max. NA’s
0.02 0.30 0.31 0.68 22278
Data Quality
share_debt_col_quality quality_label n
1 Strong 6003
NA NA 22278

Predictor: Wealth Building Opportunities

Metric: Ratio of the share of a community’s housing value held by a racial or ethnic group to the share of households of the same group

Variables: ratio_black_nh_house_value_households, ratio_hispanic_house_value_households, ratio_other_nh_house_value_households, ratio_white_nh_house_value_households, ratio_black_nh_house_value_households_quality, ratio_hispanic_house_value_households_quality, ratio_other_nh_house_value_households_quality, ratio_white_nh_house_value_households_quality

Years: 2014, 2015, 2016, 2017, 2018, 2019, 2021

Disaggregation: None

Variable: ratio_black_nh_house_value_households

Summary
Min. Median Mean Max. NA’s
0.0%:0.0% NA NA 9.9%:29.6% 6309
Data Quality
ratio_black_nh_house_value_households_quality quality_label n
1 Strong 1840
2 Marginal 745
3 Weak 19387
NA NA 6309

Variable: ratio_hispanic_house_value_households

Summary
Min. Median Mean Max. NA’s
0.0%:0.0% NA NA 93.2%:93.3% 6309
Data Quality
ratio_hispanic_house_value_households_quality quality_label n
1 Strong 1807
2 Marginal 359
3 Weak 19806
NA NA 6309

Variable: ratio_other_nh_house_value_households

Summary
Min. Median Mean Max. NA’s
0.0%:0.0% NA NA 9.9%:9.6% 6309
Data Quality
ratio_other_nh_house_value_households_quality quality_label n
1 Strong 1766
2 Marginal 451
3 Weak 19755
NA NA 6309

Variable: ratio_white_nh_house_value_households

Summary
Min. Median Mean Max. NA’s
10.1%:8.1% NA NA 99.8%:98.9% 6309
Data Quality
ratio_white_nh_house_value_households_quality quality_label n
1 Strong 3913
2 Marginal 3190
3 Weak 14869
NA NA 6309

Predictor: Access to Health Services

Metric: Ratio of population per primary care physician

Variables: ratio_population_pc_physician, ratio_population_pc_physician_quality

Years: 2019

Disaggregation: None

Variable: ratio_population_pc_physician

Summary
Min. Median Mean Max. NA’s
0 NA NA 999:1 25139
Data Quality
ratio_population_pc_physician_quality quality_label n
1 Strong 2353
2 Marginal 427
3 Weak 207
NA NA 25294

Predictor: Neonatal Health

Metric: Share with low birth weight

Variables: rate_low_birth_weight, rate_low_birth_weight_lb, rate_low_birth_weight_ub, rate_low_birth_weight_quality

Years: 2018, 2020

Disaggregation: Race/ethnicity

Variable: rate_low_birth_weight

Summary
Min. Median Mean Max. NA’s
0.04 0.08 0.08 0.15 21996
Data Quality
rate_low_birth_weight_quality quality_label n
1 Strong 1155
2 Marginal 1
3 Weak 5129
NA NA 21996

Predictor: Environmental Quality

Metric: Air quality index

Variables: index_air_quality, index_air_quality_quality

Years: 2014, 2018

Disaggregation: Race share

Variable: index_air_quality

Summary
Min. Median Mean Max. NA’s
0.00 72.00 66.25 100.00 21997
Data Quality
index_air_quality_quality quality_label n
1 Strong 6284
NA NA 21997

Predictor: Safety from Trauma

Metric: Number of deaths caused by injury per 100,000 people

Variables: rate_injury_death, rate_injury_death_lb, rate_injury_death_ub, rate_injury_death_quality

Years: 2019

Disaggregation: None

Variable: rate_injury_death

Summary
Min. Median Mean Max. NA’s
19.93 89.38 92.05 280.11 25245
Data Quality
rate_injury_death_quality quality_label n
1 Strong 2630
2 Marginal 372
3 Weak 34
NA NA 25245

Predictor: Political Participation

Metric: Share of the voting-eligible population who turn out to vote

Variables: share_election_turnout, share_election_turnoutt_quality

Years: 2016, 2020

Disaggregation: None

Variable: share_election_turnout

Summary
Min. Median Mean Max. NA’s
0.16 0.62 0.63 1.00 22057
Data Quality
share_election_turnout_quality quality_label n
1 Strong 6067
2 Marginal 144
3 Weak 13
NA NA 22057

Predictor: Descriptive Representation

Metric: Ratio of the share of local elected officials of a racial or ethnic group to the share of residents of the same racial or ethnic group

Variables: share_desc_rep_asian_other, share_desc_rep_asian_other_quality, share_desc_rep_black_nonhispanic, share_desc_rep_hispanic, share_desc_rep_white_nonhispanic

Years: 2021

Disaggregation: None

Predictor: Safety from Crime

Metric: Rates of reported violent crime and property crime

Variables: rate_violent_crime, rate_property_crime, rate_crime_quality

Years: 2021

Disaggregation: None

Variable: rate_violent_crime

Summary
Min. Median Mean Max. NA’s
0.00 708.72 825.03 12,968.59 25581
Data Quality
rate_crime_quality quality_label n
1 Strong 920
2 Marginal 492
3 Weak 1288
NA NA 25581

Variable: rate_property_crime

Summary
Min. Median Mean Max. NA’s
0.00 1,539.04 1,831.17 21,686.75 25581
Data Quality
rate_crime_quality quality_label n
1 Strong 920
2 Marginal 492
3 Weak 1288
NA NA 25581

Predictor: Just Policing

Metric: Rate of juvenile justice arrests

Variables: rate_juv_arrest, rate_juv_arrest_quality

Years: 2021

Disaggregation: Race

Variable: rate_juv_arrest

Summary
Min. Median Mean Max. NA’s
0.00 549.20 1,070.43 19,073.87 25597
Data Quality
rate_juv_arrest_quality quality_label n
1 Strong 864
2 Marginal 480
3 Weak 1340
NA NA 25597