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-pseo.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 — `pseo`

**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-27 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 `pseo`: 1 dataset family, 18 unique variables.

## `pseo/colleges_pseo_{year}`

- **Canonical mirror path:** `pseo/colleges_pseo_{year}.parquet` (21 mirror files)
- **Contributing endpoint route(s):** `/api/v1/college-university/pseo/earnings-and-flows/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `unitid` | Unit ID number | integer | 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" |
| `opeid` | 8-digit Office of Postsecondary Education (OPE) ID number | string; **observed:** string (2001-2018 files) / integer (Int64, 2019-2021 files) | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** the Int64 files drop the leading zeros (365800 where the 2018 file has "00365800"), so cast to string and zero-pad to 8 before concatenating years or joining. |
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `pseo_cohort` | Graduation cohort | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `degree_level` | Degree level of study | integer | yes | "1" : "Certificate < 1 year","2" : "Certificate 1-2 years","3" : "Associates","4" : "Certificate 2-4 years","5" : "Baccalaureate","6" : "Post-Bacc Certificate","7" : "Masters","8" : "Post-Masters Certificate","9" : "Doctoral - Research/Scholarship","10" : "Doctoral - Professional Practice","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cipcode` | 2-digit Classification of Instructional Programs (CIP) code | integer | yes | "10000" : "Agriculture, agriculture operations, and related sciences","20000" : "Agricultural sciences","30000" : "Natural resources and conservation","40000" : "Architecture and related services","50000" : "Area, ethnic, cultural, and gender studies","80000" : "Marketing and distribution","90000" : "Communication, journalism, and related programs","100000" : "Communications technologies/technicians and support services","110000" : "Computer and information sciences and support services","120000" : "Personal and culinary services","130000" : "Education","140000" : "Engineering","150000" : "Engineering technologies/technicians","160000" : "Foreign languages, literatures, and linguistics","190000" : "Family and consumer sciences/human sciences","200000" : "Vocational home economics","220000" : "Legal professions and studies","220101" : "Law (LLB, JD)","230000" : "English language and literature/letters","240000" : "Liberal arts and sciences, general studies and humanities","250000" : "Library science","260000" : "Biological and biomedical sciences","270000" : "Mathematics and statistics","290000" : "Military technologies","300000" : "Multi/interdisciplinary studies","310000" : "Parks, recreation, leisure, and fitness studies","380000" : "Philosophy and religious studies","390000" : "Theology and religious vocations","390602" : "Divinity/ministry (BD, MDiv)","390603" : "Rabbinical studies","390605" : "Rabbinical studies (MHL/Rav)","400000" : "Physical sciences","410000" : "Science technologies/technicians","420000" : "Psychology","430000" : "Security and protective services","440000" : "Public administration and social service professions","450000" : "Social sciences","460000" : "Construction trades","470000" : "Mechanic and repair technologies/technicians","480000" : "Precision production","490000" : "Transportation and materials moving","500000" : "Visual and performing arts","510000" : "Health professions and related clinical sciences","510101" : "Chiropractic (DC)","510401" : "Dentistry (DDS, DMD)","511201" : "Medicine (MD)","511701" : "Optometry (OD)","511901" : "Osteopathic medicine/osteopathy (DO)","512001" : "Pharmacy (PharmD [USA] PharmD, BS/BPharm [Canada])","512101" : "Podiatric medicine/podiatry (DPM)","512401" : "Veterinary medicine (DVM)","512704" : "Naturopathic medicine","520000" : "Business, management, marketing, and related support services","540000" : "History (new)","950000" : "Undesignated field of study","99" : "All programs","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** the 2018 and 2021 files (the two profiled) hold only bare 2-digit CIP family codes stored as integers (e.g. 1, 11, 14, 52) and 99, not the 6-digit-style values this legend lists: cipcode == 11 matches 150,390 rows in 2018 and 34,020 in 2021, and cipcode == 110000 matches 0 in both. The column is Int64 in all 21 files. |
| `years_after_grad` | Number of years after graduation | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `industry` | 2022 NAICS code | string | yes | "11" : "Agriculture, Forestry, Fishing and Hunting","21" : "Mining, Quarrying, and Oil and Gas Extraction","22" : "Utilities","23" : "Construction","31" : "Manufacturing","42" : "Wholesale Trade","44" : "Retail Trade","48" : "Transportation and Warehousing","51" : "Information","52" : "Finance and Insurance","53" : "Real Estate and Rental and Leasing","54" : "Professional, Scientific, and Technical Services","55" : "Management of Companies and Enterprises","56" : "Administrative and Support and Waste Management and Remediation Services","61" : "Educational Services","62" : "Health Care and Social Assistance","71" : "Arts, Entertainment, and Recreation","72" : "Accommodation and Food Services","81" : "Other Services (except Public Administration)","92" : "Public Administration","99" : "All NAICS Sectors","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data","999" : "All NAICS Subsectors","9999" : "All NAICS Industry Groups" |
| `census_division` | Census Bureau division | integer | yes | "1" : "New England","2" : "Middle Atlantic","3" : "East north central","4" : "West north central","5" : "South Atlantic","6" : "East south central","7" : "West south central","8" : "Mountain","9" : "Pacific" |
| `p25_earnings` | Earnings 25th Percentile (2022 Dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `p50_earnings` | Earnings 50th Percentile (2022 Dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `p75_earnings` | Earnings 75th Percentile(2022 Dollars) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `employed_grads_count_e` | Count of Employed Graduates from e file | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `employed_grads_count_f` | Count of Employed Graduates from f file | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_grads_count` | Count of IPEDS Reported Graduates of Programs Included in Dataset | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `employed_instate_grads_count` | Count of Graduates Employed in Same State as Educational Institution | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `jobless_m_emp_grads_count` | Count of Graduates Jobless or Marginally Employed | 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