State County Rankings
SkillFiles & storageThis 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.
Available today. Use it from your connected AI after setup.
No other account needed.
Connect ahel once, and every AI you use reads what you have installed.
Then ask your AI: use the State County Rankings skill
What this skill tells your AI
The instructions your AI receives, as published by amkessler/nicar2026_skills_in_codex_claude in skills/state-county-rankings/SKILL.md and read by ahel’s review.
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, andjsonlite - Local CSV input with
county, a state column (state,state_name, orstate_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.
--stateaccepts full names or USPS abbreviations (for example,GeorgiaorGA).- Default bundled input:
skills/state-county-rankings/data/county_demographics_acs5_2023.csv
- Review
skills/state-county-rankings/references/COLUMN_REQUIREMENTS.mdand use exact output headers before downstream filtering/selecting.- Output columns are
state,county,metric,value,rank, anddirection.
- Output columns are
- 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
Signals
- GitHub stars
- 20
- Forks
- 7
- Last commit
- Jul 2026
Advanced
- Catalog kind
- skill
- Gateway key
state-county-rankings- Source
- github.com/amkessler/nicar2026_skills_in_codex_claude