8  City Recent 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

Disaggregation: None

Variable: share_affordable_30_ami

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

Variable: share_affordable_50_ami

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

Variable: share_affordable_80_ami

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

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

Disaggregation: None

Variable: count_homeless

Summary
Min. Median Mean Max. NA’s
1 665 1,302 21,911 56
Data Quality
homeless_quality quality_label n
1 Strong 425
2 Marginal 2
3 Weak 3
NA NA 56

Variable: share_homeless

Summary
Min. Median Mean Max. NA’s
0.00 0.02 0.03 0.32 56
Data Quality
homeless_quality quality_label n
1 Strong 425
2 Marginal 2
3 Weak 3
NA NA 56

Predictor: Economic Inclusion

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

Variables: share_poverty_exposure, share_poverty_exposure_quality

Disaggregation: Race

Variable: share_poverty_exposure

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

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

Disaggregation: None

Variable: share_black_nh_exposure

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

Variable: share_hispanic_exposure

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

Variable: share_other_nh_exposure

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

Variable: share_white_nh_exposure

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

Predictor: Social Capital

Metric: Number of membership associations per 10,000 people

Variables: count_membership_associations_per_10k, count_membership_associations_per_10k_quality

Disaggregation: None

Variable: count_membership_associations_per_10k

Summary
Min. Median Mean Max. NA’s
0.00 1.60 1.92 7.80 0
Data Quality
count_membership_associations_per_10k_quality quality_label n
1 Strong 157
2 Marginal 329

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

Disaggregation: None

Variable: ratio_high_low_ses_fb_friends

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

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

Disaggregation: Race/ethnicity

Variable: share_in_preschool

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

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

Disaggregation: Race/ethnicity, Income

Variable: rate_learning

Summary
Min. Median Mean Max. NA’s
0.29 0.99 1.00 1.54 88
Data Quality
rate_learning_quality quality_label n
1 Strong 336
2 Marginal 30
3 Weak 32
NA NA 88

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

Disaggregation: None

Variable: meps20_black

Summary
Min. Median Mean Max. NA’s
0.00 0.48 0.47 1.00 3
Data Quality
meps20_black_quality quality_label n
1 Strong 482
3 Weak 1
NA NA 3

Variable: meps20_hispanic

Summary
Min. Median Mean Max. NA’s
0.00 0.47 0.48 1.00 3
Data Quality
meps20_hispanic_quality quality_label n
1 Strong 482
2 Marginal 1
NA NA 3

Variable: meps20_white

Summary
Min. Median Mean Max. NA’s
0.00 0.19 0.28 1.00 3
Data Quality
meps20_white_quality quality_label n
1 Strong 483
NA NA 3

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

Disaggregation: Race/ethnicity

Variable: share_hs_degree

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

Predictor: Digital Access

Metric: Share of households with broadband access in the home

Variables: share_digital_access, share_digital_access_quality

Disaggregation: Race

Variable: share_digital_access

Summary
Min. Median Mean Max. NA’s
0.66 0.90 0.89 0.98 0
Data Quality
share_digital_access_quality quality_label n
1 Strong 486

Predictor: Employment Opportunities

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

Variables: share_employed, share_employed_quality

Disaggregation: Race/ethnicity

Variable: share_employed

Summary
Min. Median Mean Max. NA’s
0.59 0.80 0.79 0.93 1
Data Quality
share_employed_quality quality_label n
1 Strong 101
2 Marginal 259
3 Weak 125
NA NA 1

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

Disaggregation: Race/ethnicity

Variable: pctl_income_20

Summary
Min. Median Mean Max. NA’s
12,290.91 30,439.98 31,744.26 85,335.99 1
Data Quality
pctl_income_quality quality_label n
1 Strong 101
2 Marginal 259
3 Weak 125
NA NA 1

Variable: pctl_income_50

Summary
Min. Median Mean Max. NA’s
34,722.11 70,065.79 74,880.55 185,322.84 1
Data Quality
pctl_income_quality quality_label n
1 Strong 101
2 Marginal 259
3 Weak 125
NA NA 1

Variable: pctl_income_80

Summary
Min. Median Mean Max. NA’s
69,867.23 134,004.89 145,697.18 424,754.42 1
Data Quality
pctl_income_quality quality_label n
1 Strong 101
2 Marginal 259
3 Weak 125
NA NA 1

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

Disaggregation: None

Variable: share_debt_col

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

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

Disaggregation: None

Variable: ratio_black_nh_house_value_households

Summary
Min. Median Mean Max. NA’s
0.0%:0.0% NA NA 9.8%:9.9% 0
Data Quality
ratio_black_nh_house_value_households_quality quality_label n
1 Strong 81
2 Marginal 136
3 Weak 269

Variable: ratio_hispanic_house_value_households

Summary
Min. Median Mean Max. NA’s
0.5%:2.7% NA NA 95.0%:95.4% 0
Data Quality
ratio_hispanic_house_value_households_quality quality_label n
1 Strong 79
2 Marginal 178
3 Weak 229

Variable: ratio_other_nh_house_value_households

Summary
Min. Median Mean Max. NA’s
0.0%:1.1% NA NA 9.8%:14.3% 0
Data Quality
ratio_other_nh_house_value_households_quality quality_label n
1 Strong 88
2 Marginal 191
3 Weak 207

Variable: ratio_white_nh_house_value_households

Summary
Min. Median Mean Max. NA’s
1.8%:1.3% NA NA 94.0%:85.3% 0
Data Quality
ratio_white_nh_house_value_households_quality quality_label n
1 Strong 102
2 Marginal 208
3 Weak 176

Predictor: Environmental Quality

Metric: Air quality index

Variables: index_air_quality, index_air_quality_quality

Disaggregation: Race share

Variable: index_air_quality

Summary
Min. Median Mean Max. NA’s
0.00 39.00 38.39 96.00 3
Data Quality
index_air_quality_quality quality_label n
1 Strong 483
NA NA 3

Predictor: Political Participation

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

Variables: share_election_turnout, share_election_turnoutt_quality

Disaggregation: None

Variable: share_election_turnout

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

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

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

Disaggregation: None

Variable: rate_violent_crime

Summary
Min. Median Mean Max. NA’s
0.00 1,240.61 1,448.08 13,765.64 172
Data Quality
rate_crime_quality quality_label n
1 Strong 209
2 Marginal 75
3 Weak 30
NA NA 172

Variable: rate_property_crime

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

Predictor: Just Policing

Metric: Rate of juvenile justice arrests

Variables: rate_juv_arrest, rate_juv_arrest_quality

Disaggregation: Race

Variable: rate_juv_arrest

Summary
Min. Median Mean Max. NA’s
0.00 1,030.99 1,386.13 11,169.73 176
Data Quality
rate_juv_arrest_quality quality_label n
1 Strong 199
2 Marginal 83
3 Weak 28
NA NA 176