Majority Minority Change
Use this skill to compare county demographics across two years and flag threshold crossings.
Requirements
- R with
dplyr,readr,stringr, andjsonlite - Two local CSV files with county identifiers and required race/population fields
- Bundled Census CSV snapshots for immediate use:
skills/majority-minority-change/data/county_race_acs5_2010.csvskills/majority-minority-change/data/county_race_acs5_2020.csv
- No API key required
Required Input Columns
- Join keys available in both files:
county_fips(preferred), or- both
stateandcounty
- Metrics in both files:
total_populationnon_hispanic_white
Standard Workflow
- Confirm start/end files and year labels.
--stateaccepts full names or USPS abbreviations (for example,GeorgiaorGA).- Default bundled files:
- start:
skills/majority-minority-change/data/county_race_acs5_2010.csv - end:
skills/majority-minority-change/data/county_race_acs5_2020.csv
- start:
- Review
skills/majority-minority-change/references/DATA_SCHEMA.mdfor exact derived/output field names before downstream filtering or selecting columns.- Expected output naming includes
nonwhite_share_<year_label>anddelta_nonwhite_share_pp.
- Expected output naming includes
- Run script with optional state filter.
- Example:
Rscript skills/majority-minority-change/scripts/analyze_majority_minority_change.R --input-start skills/majority-minority-change/data/county_race_acs5_2010.csv --input-end skills/majority-minority-change/data/county_race_acs5_2020.csv --start-label 2010 --end-label 2020
- Example:
- Review counties with largest percentage-point shifts and threshold crossings.
Output
Return:
- non-white share in each year
- percentage-point change
crossed_to_majority_minoritycrossed_out_of_majority_minority