DAAF-Contribution-Community/daaf / .claude/skills/education-data-explorer
education-data-explorer
VerifiedMirror-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-saipe.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 — `saipe`
**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.
> Caveat: entries marked **Observed on pinned mirror** record what file-first probes of the pinned revision found on 2026-10-28 where it contradicts or qualifies the Portal varlist or the bridge's file counts; they are added beside the declared label, type and legend, which are kept verbatim, and override nothing declared.
Source `saipe`: 1 dataset family, 10 unique variables.
## `saipe/districts_saipe`
- **Canonical mirror path:** `saipe/districts_saipe.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/school-districts/saipe/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `leaid` | Local education agency identification number (NCES) | string; **observed:** integer (Int64) | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-28):** no -1, -2 or -3 value and no null occurs. As an integer it carries no leading zeros: values have 7 digits in 326,894 rows, 6 in 55,204 and 4 in 1 row (range 7230-7200030). DAAF convention, not probed: the `education-data-source-ccd` skill documents `leaid` as a 7-character string (2-digit state FIPS plus 5 digits), so zero-pad to 7 before joining to a string `leaid`. The single 4-digit value (7230) would pad to `0007230`, whose `00` prefix matches no `fips` value in this file; the probe did not explain that row. |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-28):** no -1, -2 or -3 value and no null occurs; 28 distinct years between 1995 and 2024. |
| `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" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-28):** no -1, -2 or -3 value and no null occurs; values run from 1 to 72. |
| `district_id` | District identification numbers reported in the US Census Small Area Income and Poverty Estimates | string; **observed:** integer (Int64) | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-28):** no -1, -2 or -3 value and no null occurs; values run from 1 to 99965. |
| `district_name` | District names reported in the US Census Small Area Income and Poverty Estimates | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-28):** no "-1", "-2" or "-3" value and no null occurs. |
| `est_population_total` | Estimated total population | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-28):** no -1, -2, -3 or other negative value and no null occurs. |
| `est_population_5_17` | Estimated total population ages 5–17 | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-28):** no -1, -2, -3 or other negative value and no null occurs. |
| `est_population_5_17_pct` | Share of population that is school age (ages 5–17) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-28):** no -1, -2, -3 or other negative value occurs; 122 of the file's 382,099 rows are null. Values run from 0.0 to 1.0. |
| `est_population_5_17_poverty` | Estimated population ages 5–17 in poverty | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-28):** no -1, -2, -3 or other negative value and no null occurs. |
| `est_population_5_17_poverty_pct` | Share of school-age population (ages 5–17) in poverty | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-28):** no -1, -2, -3 or other negative value occurs; 280 of the file's 382,099 rows are null. Values run from 0.0 to 1.0, a proportion, not a 0-100 percentage. |
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| 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: 197k | Updated | Claude CodeCodex | Verified | Install |