Skip to content

DAAF-Contribution-Community/daaf / .claude/skills/education-data-explorer

education-data-explorer

Verified

Mirror-first discovery for Urban Institute Education Data: maps a research question to the mirror dataset FILES that answer it — canonical path, entity grain, year coverage, key variables, and join keys — for CCD, IPEDS, CRDC, College Scorecard, SAIPE, EDFacts, FSA, MEPS, NHGIS, PSEO, NACUBO, NCCS, EADA, and Campus Safety. Discovery output is the mirror path (plus grain, years, variables, caveats), the currency planning and acquisition consume. A pure readable-reference skill for read-only discovery agents — no code, no live HTTP probes; all facts keyed to pinned mirror vintage 0.26.1. Load BEFORE education-data-query — routing (which file, what grain) here, retrieval (fetch code, mirror config) there.

references/variable-dictionary-meps.md

View on GitHub
<!-- MECHANICALLY GENERATED on 2026-10-28
     from the Portal varlist captured 2026-08-07 at Portal v0.26.1 — the same
     vintage as the pinned mirror (revision 0ad00ce0e232c96b0642459e4e7326607a8d26aa).
     Do not hand-edit: the DAAF maintainers regenerate these files at each new mirror vintage. -->

# Variable Dictionary — `meps`

**MECHANICALLY GENERATED** on 2026-10-28 from the Portal varlist captured 2026-08-07 at Portal v0.26.1 — the same vintage as the pinned mirror (revision `0ad00ce0e232c96b0642459e4e7326607a8d26aa`). Do not hand-edit: the DAAF maintainers regenerate these files at each new mirror vintage.

> Caveat: the `urban_csv` fallback mirror is unpinned; these facts are guaranteed for the pinned Hugging Face vintage only.

> Caveat: the `coded values` column reproduces the Portal varlist's declared legend (including the standard `-1`/`-2`/`-3` missing codes) and does not assert those codes occur in the pinned mirror file — several mirror files carry nulls instead (a probe of the pinned SAIPE file on 2026-10-28 found no `-1`/`-2`/`-3` or other negative value in any of its 10 columns; nulls occur only in the two `_pct` columns). Test for nulls and for sentinels before treating either as the missing-value convention, and defer to the source skill's SKILL.md where it documents the observed convention.

Source `meps`: 1 dataset family, 11 unique variables.

## `meps/schools_meps`

- **Canonical mirror path:** `meps/schools_meps.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/meps/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ncessch` | National Center for Education Statistics (NCES) identification number | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ncessch_num` | National Center for Education Statistics (NCES) identification number (numeric) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `leaid` | Local education agency identification number (NCES) | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `gleaid` | Geographic local education agency identification number | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `fips` | Federal Information Processing Standards state code | integer | yes | "1" : "Alabama","2" : "Alaska","3" : "American Samoa","4" : "Arizona","5" : "Arkansas","6" : "California","7" : "Canal Zone","8" : "Colorado","9" : "Connecticut","10" : "Delaware","11" : "District of Columbia","12" : "Florida","13" : "Georgia","14" : "Guam","15" : "Hawaii","16" : "Idaho","17" : "Illinois","18" : "Indiana","19" : "Iowa","20" : "Kansas","21" : "Kentucky","22" : "Louisiana","23" : "Maine","24" : "Maryland","25" : "Massachusetts","26" : "Michigan","27" : "Minnesota","28" : "Mississippi","29" : "Missouri","30" : "Montana","31" : "Nebraska","32" : "Nevada","33" : "New Hampshire","34" : "New Jersey","35" : "New Mexico","36" : "New York","37" : "North Carolina","38" : "North Dakota","39" : "Ohio","40" : "Oklahoma","41" : "Oregon","42" : "Pennsylvania","43" : "Puerto Rico","44" : "Rhode Island","45" : "South Carolina","46" : "South Dakota","47" : "Tennessee","48" : "Texas","49" : "Utah","50" : "Vermont","51" : "Virginia","52" : "Virgin Islands of the US","53" : "Washington","54" : "West Virginia","55" : "Wisconsin","56" : "Wyoming","58" : "Department of Defense Dependent Schools (overseas)","59" : "Bureau of Indian Education","60" : "American Samoa","61" : "Department of Defense Dependent Schools (domestic)","63" : "Department of Defense Education Activity","64" : "Federated States of Micronesia","65" : "Mariana Islands waters (including Guam)","66" : "Guam","67" : "Johnston Atoll","68" : "Marshall Islands","69" : "Northern Mariana Islands","70" : "Palau","71" : "Midway Islands","72" : "Puerto Rico","74" : "US Minor Outlying Islands","75" : "Atlantic coast from North Carolina to Florida, and the coasts of Puerto Rico and Virgin Islands","76" : "Navassa Island","78" : "Virgin Islands of the US","79" : "Wake Island","81" : "Baker Island","84" : "Howland Island","86" : "Jarvis Island","89" : "Kingman Reef","95" : "Palmyra Atoll","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `meps_poverty_pct` | Estimated percentage of students living in poverty (MEPS) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `meps_poverty_se` | Standard error for estimated percentage of students living in poverty (MEPS) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `meps_mod_poverty_pct` | Modified estimated percentage of students living in poverty (MEPS) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `meps_poverty_ptl` | Estimated national percentile of students living in poverty, weighted by enrollment (MEPS) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `meps_mod_poverty_ptl` | Modified estimated national percentile of students living in poverty, weighted by enrollment (MEPS) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the workStars: 322kUpdated Claude CodeCodexVerifiedInstall
systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixesStars: 322kUpdated Claude CodeCodexVerifiedInstall
test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation codeStars: 322kUpdated Claude CodeCodexVerifiedInstall
skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.Stars: 197kUpdated Claude CodeCodexVerifiedInstall