Mobility Metrics Data for the Upward Mobility Framework

The following is the data dictionary for the variables in the downloadable raw data files located in our data catalog – Mobility Metrics Data for the Upward Mobility Framework – Upward Mobility Data Dashboard. This data dictionary connects the main and accompanying variables to their respective metric in the Framework.

Each metric will have at least one main variable. Some metrics require more than one main variable; for example, the mobility metric “household income at the 20th, 50th, and 80th percentiles” has three main variables: pctl_income_20, pctl_income_50, and pctl_income_80. Each of these main variables will have a group of respective accompanying variables to capture confidence intervals and a data quality index.

The accompanying set of variables will include its data quality index (_quality) and, if confidence intervals are calculated, a pair of variables that indicate the lower-bound (_lb) and upper-bound (_ub) values, all of which will have a prefix that matches the main variable name with the specified suffix.

The group of accompanying variables will show when you click the hyperlink in the main variable. The hyperlink will also include notes, years available, the variable format or type, the files it is included in, and some summary statistics.

To see the programming code that generates each of these variables, visit our public GitHub site: https://github.com/UI-Research/mobility-from-poverty. See the data dashboard Appendix to learn how each metric performed against our selection criteria, alternative metrics considered, and a summary of the data available in the Dashboard for each metric (i.e., years, categories of disaggregation, and data sources).

Last updated: October 25, 2024.

Geographic and Technical Variables

Variable	Description	Years Available	Files
county	County code	2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 14_mobility-metrics_county_income_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 18_mobility-metrics_county_disability_longitudinal.csv 19_mobility-metrics_county_industry_longitudinal.csv 20_mobility-metrics_county_mothers_education_longitudinal.csv
county_name	County name	2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 14_mobility-metrics_county_income_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 18_mobility-metrics_county_disability_longitudinal.csv 19_mobility-metrics_county_industry_longitudinal.csv 20_mobility-metrics_county_mothers_education_longitudinal.csv
place	Place code	2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022	61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv 64_mobility-metrics_place_income_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv 68_mobility-metrics_place_disability_longitudinal.csv
place_name	Place name	2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022	61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv 64_mobility-metrics_place_income_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv 68_mobility-metrics_place_disability_longitudinal.csv
population	Population count	2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
state	State abbreviation	2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 14_mobility-metrics_county_income_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 18_mobility-metrics_county_disability_longitudinal.csv 19_mobility-metrics_county_industry_longitudinal.csv 20_mobility-metrics_county_mothers_education_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv 64_mobility-metrics_place_income_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv 68_mobility-metrics_place_disability_longitudinal.csv
state_name	State name	2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 14_mobility-metrics_county_income_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 18_mobility-metrics_county_disability_longitudinal.csv 19_mobility-metrics_county_industry_longitudinal.csv 20_mobility-metrics_county_mothers_education_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv 64_mobility-metrics_place_income_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv 68_mobility-metrics_place_disability_longitudinal.csv
subgroup	Subgroup identifier	2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022	12_mobility-metrics_county_race-ethnicity_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 14_mobility-metrics_county_income_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 18_mobility-metrics_county_disability_longitudinal.csv 19_mobility-metrics_county_industry_longitudinal.csv 20_mobility-metrics_county_mothers_education_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv 64_mobility-metrics_place_income_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv 68_mobility-metrics_place_disability_longitudinal.csv
subgroup_type	Type of subgroup	2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022	12_mobility-metrics_county_race-ethnicity_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 14_mobility-metrics_county_income_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 18_mobility-metrics_county_disability_longitudinal.csv 19_mobility-metrics_county_industry_longitudinal.csv 20_mobility-metrics_county_mothers_education_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv 64_mobility-metrics_place_income_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv 68_mobility-metrics_place_disability_longitudinal.csv
year	Year of data collection	2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 14_mobility-metrics_county_income_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 18_mobility-metrics_county_disability_longitudinal.csv 19_mobility-metrics_county_industry_longitudinal.csv 20_mobility-metrics_county_mothers_education_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv 64_mobility-metrics_place_income_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv 68_mobility-metrics_place_disability_longitudinal.csv

Metric Variables

Variable	Description	Years Available	Files
count_homeless	Number homeless children	2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv
count_membership_associations_per_10k	Number of membership associations	2020, 2021	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
index_air_hazard	Air quality	2014, 2018, 2019	11_mobility-metrics_county_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 14_mobility-metrics_county_income_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv 64_mobility-metrics_place_income_longitudinal.csv
index_transit_trips	Transit trips index	2015, 2019	11_mobility-metrics_county_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv
index_transportation_cost	Transportation cost index	2015, 2019	11_mobility-metrics_county_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv
pctl_income_20	Household income at 20th percentile	2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv
pctl_income_50	Household income at 50th percentile	2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv
pctl_income_80	Household income at 80th percentile	2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv
rate_crime_property	Property crime rate	2021, 2022	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
rate_crime_violent	Violent crime rate	2021, 2022	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
rate_injury_death	Deaths due to injury	2014, 2015, 2016, 2017, 2018, 2019, 2020	11_mobility-metrics_county_longitudinal.csv
rate_juv_arrest	Juvenile arrests	2021, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv
rate_learning	English achievement	2014, 2015, 2016, 2017	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 14_mobility-metrics_county_income_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 64_mobility-metrics_place_income_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv
ratio_black_nh_house_value_households	Share home value by race	2014, 2015, 2016, 2017, 2018, 2019, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv
ratio_high_low_ses_fb_friends	FB friends ratio	2022	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 11_mobility-metrics_county_longitudinal.csv
ratio_hispanic_house_value_households	Share home value by race	2014, 2015, 2016, 2017, 2018, 2019, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv
ratio_living_wage	Living wage	2014, 2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 19_mobility-metrics_county_industry_longitudinal.csv
ratio_other_nh_house_value_households	Share home value by race	2014, 2015, 2016, 2017, 2018, 2019, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv
ratio_population_pc_physician	Physician ratio	2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021	11_mobility-metrics_county_longitudinal.csv
ratio_white_nh_house_value_households	Share home value by race	2014, 2015, 2016, 2017, 2018, 2019, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 15_mobility-metrics_county_age_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 65_mobility-metrics_place_age_longitudinal.csv
share_affordable_30_ami	Ratio for low-income households	2014, 2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv
share_affordable_50_ami	Ratio for low-income households	2014, 2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv
share_affordable_80_ami	Ratio for low-income households	2014, 2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv
share_affordable_available_30_ami	Ratio for low-income households	2014, 2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv
share_affordable_available_50_ami	Ratio for low-income households	2014, 2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv
share_affordable_available_80_ami	Ratio for low-income households	2014, 2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 17_mobility-metrics_county_tenure_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 67_mobility-metrics_place_tenure_longitudinal.csv
share_black_nh_exposure	Racial exposure index	2018, 2021	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_debt_coll	Share debt	2018, 2022	11_mobility-metrics_county_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 63_mobility-metrics_place_race-share_longitudinal.csv 11_mobility-metrics_county_longitudinal.csv 13_mobility-metrics_county_race-share_longitudinal.csv
share_desc_rep_black_nonhispanic	Elected racial representation	2021	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_desc_rep_hispanic	Elected racial representation	2021	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_desc_rep_other	Elected racial representation	2021	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_desc_rep_white_nonhispanic	Elected racial representation	2021	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_digital_access	Share with internet	2018, 2021	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 14_mobility-metrics_county_income_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 64_mobility-metrics_place_income_longitudinal.csv
share_election_turnout	Share voting	2016, 2020	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_employed	Share employed	2018, 2021, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 18_mobility-metrics_county_disability_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv 68_mobility-metrics_place_disability_longitudinal.csv
share_hispanic_exposure	Racial exposure index	2018, 2021	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_homeless	Share homeless children	2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv
share_hs_degree	Share with high school degree	2018, 2021	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 16_mobility-metrics_county_gender_longitudinal.csv 18_mobility-metrics_county_disability_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv 66_mobility-metrics_place_gender_longitudinal.csv 68_mobility-metrics_place_disability_longitudinal.csv
share_in_preschool	Share in preschool	2018, 2021	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv
share_low_birth_weight	Share low birth weight	2018, 2020, 2022	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 20_mobility-metrics_county_mothers_education_longitudinal.csv
share_meps20_black	Share student poverty by race	2014, 2015, 2016, 2017, 2018, 2019, 2020	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_meps20_hispanic	Share student poverty by race	2014, 2015, 2016, 2017, 2018, 2019, 2020	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_meps20_white	Share student poverty by race	2014, 2015, 2016, 2017, 2018, 2019, 2020	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_other_nh_exposure	Racial exposure index	2018, 2021	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv
share_poverty_exposure	Concentrated poverty	2018, 2021	11_mobility-metrics_county_longitudinal.csv 12_mobility-metrics_county_race-ethnicity_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv 62_mobility-metrics_place_race-ethnicity_longitudinal.csv
share_white_nh_exposure	Racial exposure index	2018, 2021	11_mobility-metrics_county_longitudinal.csv 61_mobility-metrics_place_longitudinal.csv