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

**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 `csafety`: 1 dataset family, 13 unique variables.

## `csafety/colleges_csafety_hate_crimes`

- **Canonical mirror path:** `csafety/colleges_csafety_hate_crimes.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/college-university/campus-crime/hate-crimes/{year}/`

| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `year` | Academic year (fall semester) | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `unitid` | Unit ID number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `inst_name` | Institution (entity) name | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `opeid` | 8-digit Office of Postsecondary Education (OPE) ID 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" |
| `crime_type` | Type of crime committed | integer | yes | "1" : "Murder","2" : "Rape","3" : "Fondling","4" : "Aggravated Assault","5" : "Incest","6" : "Statutory Rape","7" : "Robbery","8" : "Burglary","9" : "Motor Vehicle Theft","10" : "Arson","11" : "Simple Assault","12" : "Larceny","13" : "Intimidation","14" : "Destruction, Damage, or Vandalism ","15" : "Forcible Sex Offense","16" : "Neglient Manslaughter","17" : "Nonforcible Sex Offense","18" : "Body Injury" |
| `bias` | Group that was vicitimized by hate crime | integer | yes | "1" : "Race","2" : "Religion","3" : "Sex","4" : "Gender","5" : "Gender Identity","6" : "Disability","7" : "Ethnicity","8" : "Nationality","9" : "Ethnicity (Pre 2014)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** no -1, -2 or -3 value occurs; the non-null values are 1-9 and 99, and 352,310 rows are null. |
| `on_campus_hate_crimes` | Number of hate crimes committed on campus | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `residence_hall_hate_crimes` | Number of hate crimes committed in residence halls | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `non_campus_hate_crimes` | Number of hate crimes committed off campus | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `public_property_hate_crimes` | Number of hate crimes committed on campus-related public property | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `other_hate_crimes` | Number of hate crimes committed in other places | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `total_hate_crimes` | Number of hate crimes committed | 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