| name | state-county-rankings |
| description | This skill should be used when users need ranked county-level demographic metrics within a state from a local CSV file, such as income, population, poverty, or rent. |
State County Rankings
Use this skill to rank counties within a state for one or more metrics from a local dataset.
Requirements
- R with
dplyr, tidyr, readr, stringr, and jsonlite
- Local CSV input with
county, a state column (state, state_name, or state_abbrev), and requested metric columns
- Bundled Census CSV for immediate use:
skills/state-county-rankings/data/county_demographics_acs5_2023.csv
- No API key required
Standard Workflow
- Confirm input CSV path and state.
--state accepts full names or USPS abbreviations (for example, Georgia or GA).- Default bundled input:
skills/state-county-rankings/data/county_demographics_acs5_2023.csv
- Review
skills/state-county-rankings/references/COLUMN_REQUIREMENTS.md and use exact output headers before downstream filtering/selecting.
- Output columns are
state, county, metric, value, rank, and direction.
- Ask for metrics (or use defaults) and ranking direction.
- Run:
Rscript skills/state-county-rankings/scripts/get_state_county_rankings.R --input skills/state-county-rankings/data/county_demographics_acs5_2023.csv --state "<state>"
- Return top/bottom county rankings and note missing/invalid fields.
Output
Return ranked rows with:
statecountymetricvaluerankdirection
