Nicar2026_skills_in_codex_claude state-county-rankings

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.

install

source · Clone the upstream repo

git clone https://github.com/amkessler/nicar2026_skills_in_codex_claude

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/amkessler/nicar2026_skills_in_codex_claude "$T" && mkdir -p ~/.claude/skills && cp -r "$T/.claude/skills/state-county-rankings" ~/.claude/skills/amkessler-nicar2026-skills-in-codex-claude-state-county-rankings && rm -rf "$T"

manifest: .claude/skills/state-county-rankings/SKILL.md

source content

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:

```
state
```
```
county
```
```
metric
```
```
value
```
```
rank
```
```
direction
```