7  City 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: 2021

Disaggregation: None

Variable: share_affordable_30_ami

Summary
Min. Median Mean Max. NA’s
0.39 1.05 1.13 3.43 3402
Data Quality
share_affordable_quality quality_label n
1 Strong 220
2 Marginal 247
3 Weak 19
NA NA 3402

Variable: share_affordable_50_ami

Summary
Min. Median Mean Max. NA’s
0.65 1.25 1.30 2.85 3402
Data Quality
share_affordable_quality quality_label n
1 Strong 220
2 Marginal 247
3 Weak 19
NA NA 3402

Variable: share_affordable_80_ami

Summary
Min. Median Mean Max. NA’s
0.87 1.48 1.50 2.70 3402
Data Quality
share_affordable_quality quality_label n
1 Strong 220
2 Marginal 247
3 Weak 19
NA NA 3402

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: 2016, 2017, 2018, 2019

Disaggregation: None

Variable: count_homeless

Summary
Min. Median Mean Max. NA’s
1 710 1,448 53,661 2175
Data Quality
homeless_quality quality_label n
1 Strong 1691
2 Marginal 6
3 Weak 16
NA NA 2175

Variable: share_homeless

Summary
Min. Median Mean Max. NA’s
0.00 0.02 0.03 0.92 2175
Data Quality
homeless_quality quality_label n
1 Strong 1691
2 Marginal 6
3 Weak 16
NA NA 2175

Predictor: Economic Inclusion

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

Variables: share_poverty_exposure, share_poverty_exposure_quality

Years: 2021

Disaggregation: Race

Variable: share_poverty_exposure

Summary
Min. Median Mean Max. NA’s
0.00 0.00 0.09 0.61 3402
Data Quality
share_poverty_exposure_quality quality_label n
1 Strong 452
2 Marginal 34
NA NA 3402

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: 2021

Disaggregation: None

Variable: share_black_nh_exposure

Summary
Min. Median Mean Max. NA’s
0.08 0.86 0.79 1.00 3402
Data Quality
share_black_nh_exposure_quality quality_label n
1 Strong 444
2 Marginal 40
3 Weak 2
NA NA 3402

Variable: share_hispanic_exposure

Summary
Min. Median Mean Max. NA’s
0.04 0.72 0.68 0.97 3402
Data Quality
share_hispanic_exposure_quality quality_label n
1 Strong 485
2 Marginal 1
NA NA 3402

Variable: share_other_nh_exposure

Summary
Min. Median Mean Max. NA’s
0.21 0.87 0.83 0.99 3402
Data Quality
share_other_nh_exposure_quality quality_label n
1 Strong 478
2 Marginal 7
3 Weak 1
NA NA 3402

Variable: share_white_nh_exposure

Summary
Min. Median Mean Max. NA’s
0.12 0.42 0.46 0.99 3402
Data Quality
share_white_nh_exposure_quality quality_label n
1 Strong 486
NA NA 3402

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
0.00 1.60 1.92 7.80 3402
Data Quality
count_membership_associations_per_10k_quality quality_label n
1 Strong 157
2 Marginal 329
NA NA 3402

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: 2020

Disaggregation: None

Variable: ratio_high_low_ses_fb_friends

Summary
Min. Median Mean Max. NA’s
0.42 0.85 0.87 1.56 3402
Data Quality
ratio_high_low_ses_fb_friends_quality quality_label n
1 Strong 13
2 Marginal 108
3 Weak 364
NA NA 3403

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: 2021

Disaggregation: Race/ethnicity

Variable: share_in_preschool

Summary
Min. Median Mean Max. NA’s
0.05 0.38 0.39 0.86 3402
Data Quality
share_in_preschool_quality quality_label n
1 Strong 195
2 Marginal 213
3 Weak 78
NA NA 3402

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: 2016, 2017

Disaggregation: Race/ethnicity, Income

Variable: rate_learning

Summary
Min. Median Mean Max. NA’s
0.29 1.02 1.02 1.99 3089
Data Quality
rate_learning_quality quality_label n
1 Strong 675
2 Marginal 57
3 Weak 67
NA NA 3089

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: 2016, 2017, 2018

Disaggregation: None

Variable: meps20_black

Summary
Min. Median Mean Max. NA’s
0.00 0.52 0.48 1.00 2441
Data Quality
meps20_black_quality quality_label n
1 Strong 1441
2 Marginal 3
3 Weak 3
NA NA 2441

Variable: meps20_hispanic

Summary
Min. Median Mean Max. NA’s
0.00 0.52 0.50 1.00 2441
Data Quality
meps20_hispanic_quality quality_label n
1 Strong 1446
2 Marginal 1
NA NA 2441

Variable: meps20_white

Summary
Min. Median Mean Max. NA’s
0.00 0.21 0.30 1.00 2441
Data Quality
meps20_white_quality quality_label n
1 Strong 1447
NA NA 2441

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: 2021

Disaggregation: Race/ethnicity

Variable: share_hs_degree

Summary
Min. Median Mean Max. NA’s
0.53 0.92 0.91 1.00 3402
Data Quality
share_hs_degree_quality quality_label n
1 Strong 210
2 Marginal 225
3 Weak 51
NA NA 3402

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.66 0.90 0.89 0.98 3402
Data Quality
share_digital_access_quality quality_label n
1 Strong 486
NA NA 3402

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.59 0.80 0.80 0.93 2918
Data Quality
share_employed_quality quality_label n
1 Strong 202
2 Marginal 518
3 Weak 250
NA NA 2918

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,402.82 28,395.35 30,214.60 85,335.99 2918
Data Quality
pctl_income_quality quality_label n
1 Strong 202
2 Marginal 518
3 Weak 250
NA NA 2918

Variable: pctl_income_50

Summary
Min. Median Mean Max. NA’s
29,811.44 66,341.43 70,880.86 185,322.84 2918
Data Quality
pctl_income_quality quality_label n
1 Strong 202
2 Marginal 518
3 Weak 250
NA NA 2918

Variable: pctl_income_80

Summary
Min. Median Mean Max. NA’s
56,651.46 127,380.00 137,838.42 424,754.42 2918
Data Quality
pctl_income_quality quality_label n
1 Strong 202
2 Marginal 518
3 Weak 250
NA NA 2918

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: 2021

Disaggregation: None

Variable: share_debt_col

Summary
Min. Median Mean Max. NA’s
0.12 0.32 0.33 0.58 3784
Data Quality
share_debt_col_quality quality_label n
1 Strong 104
NA NA 3784

Predictor: Wealth Building Opportunities

Metric: Ratio of the share of a community’s housing wealth 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%:9.3% 486
Data Quality
ratio_black_nh_house_value_households_quality quality_label n
1 Strong 549
2 Marginal 930
3 Weak 1923
NA NA 486

Variable: ratio_hispanic_house_value_households

Summary
Min. Median Mean Max. NA’s
0.0%:0.7% NA NA 96.8%:95.7% 486
Data Quality
ratio_hispanic_house_value_households_quality quality_label n
1 Strong 510
2 Marginal 1168
3 Weak 1724
NA NA 486

Variable: ratio_other_nh_house_value_households

Summary
Min. Median Mean Max. NA’s
0.0%:0.0% NA NA 9.9%:9.6% 486
Data Quality
ratio_other_nh_house_value_households_quality quality_label n
1 Strong 547
2 Marginal 1215
3 Weak 1640
NA NA 486

Variable: ratio_white_nh_house_value_households

Summary
Min. Median Mean Max. NA’s
0.7%:1.3% NA NA 99.3%:89.6% 486
Data Quality
ratio_white_nh_house_value_households_quality quality_label n
1 Strong 720
2 Marginal 1456
3 Weak 1226
NA NA 486

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 40.00 40.19 96.00 2922
Data Quality
index_air_quality_quality quality_label n
1 Strong 966
NA NA 2922

Predictor: Political Participation

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

Variables: share_election_turnout, share_election_turnoutt_quality

Years: 2020

Disaggregation: None

Variable: share_election_turnout

Summary
Min. Median Mean Max. NA’s
0.29 0.64 0.64 0.94 3402
Data Quality
share_election_turnout_quality quality_label n
1 Strong 408
2 Marginal 42
3 Weak 36
NA NA 3402

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 1,240.61 1,448.08 13,765.64 3574
Data Quality
rate_crime_quality quality_label n
1 Strong 209
2 Marginal 75
3 Weak 30
NA NA 3574

Variable: rate_property_crime

Summary
Min. Median Mean Max. NA’s
0.00 3,434.57 3,875.26 22,171.84 3574
Data Quality
rate_crime_quality quality_label n
1 Strong 209
2 Marginal 75
3 Weak 30
NA NA 3574

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 1,030.99 1,386.13 11,169.73 3578
Data Quality
rate_juv_arrest_quality quality_label n
1 Strong 199
2 Marginal 83
3 Weak 28
NA NA 3578