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-nhgis.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 — `nhgis`
**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 `nhgis`: 2 dataset families, 87 unique variables.
## `nhgis/colleges_nhgis_geog_{year}`
- **Canonical mirror path:** `nhgis/colleges_nhgis_geog_{year}.parquet` (4 mirror files)
- **Contributing endpoint route(s):** `/api/v1/college-university/nhgis/census-1990/{year}/`, `/api/v1/college-university/nhgis/census-2000/{year}/`, `/api/v1/college-university/nhgis/census-2010/{year}/`, `/api/v1/college-university/nhgis/census-2020/{year}/`
- **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** here `{year}` is the census-geography vintage (`1990`, `2000`, `2010`, `2020`), not a data year. Each of the 4 files holds every data year: 1980 and 1984-2023 (1981-1983 absent), 337,222 rows per file.
| 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" |
| `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 | 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" |
| `address` | Street address or post office box | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_abbr` | State abbreviation | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `zip` | Zip code | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `county_fips` | Federal Information Processing Standards county code | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `county_name` | County name | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `geo_longitude` | Geocoded longitude of institution | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `geo_latitude` | Geocoded latitude of institution | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `geocode_accuracy` | Accuracy of geocode match | integer | no | "1" : "High confidence","2" : "Medium confidence","3" : "Low confidence","4" : "Did not geocode","-2" : "Not applicable" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** values are a geocoder match score from 61 to 100, plus -2, in all 4 census-vintage files; codes 1, 2, 3 and 4 never occur. Every row is -2 in data years 2018-2023, and no earlier row is -2. |
| `geocode_accuracy_detailed` | Type of geocode match | integer | no | "1" : "Point address","2" : "Street address","3" : "Subaddress","4" : "Street intersection","5" : "Street address extension","6" : "Street name","7" : "Postal extension","8" : "Point of interest","9" : "Distance marker","10" : "Postal code","11" : "Locality","12" : "Postal location","-2" : "Not applicable" |
| `state_fips_geo` | 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-27):** the 1990 census-vintage file stores the state code times 10 (Ohio is 390) in 331,043 of 331,049 college rows matched by unitid and year to the 2010 file; the 2000, 2010 and 2020 files store the plain code. |
| `county_fips_geo` | Federal Information Processing Standards county code | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** the 2000 census-vintage file does not hold a county FIPS code: values run 10-990, never 5 digits, and in 239,946 of 330,629 college rows matched to the 2010 file they equal 10 times the 3-digit county code (Ohio county 057 is 570). The 1990, 2010 and 2020 files hold the 5-digit state+county code. |
| `tract` | Census tract | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `block_group` | Block group number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `geoid_block` | Block identifier | string; **observed:** integer (Int64 in all 4 files) | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** never a 15-digit block GEOID. In the 2010 and 2020 census-vintage files it equals the 12-digit block-group GEOID rebuilt from the file's own columns (Int64, so the leading zero drops when the state FIPS is below 10; zero-pad to 12). In the 1990 file it equals the 11-digit tract GEOID. In the 2000 file it matches neither form rebuilt from the file's own columns (whose `county_fips_geo` is not a county code; see that row). |
| `census_region` | Census Bureau region | integer | yes | "1" : "Northeast","2" : "Midwest","3" : "South","4" : "West","9" : "Puerto Rico" |
| `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" |
| `msa_cmsa` | Federal Information Processing Standards metropolitan statistical area or consolidated metropolitan statistical area code | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `geoid_place` | Place identifier | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `place_fips` | Federal Information Processing Standards place code | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `place_name` | Place name | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `class_code` | Federal Information Processing Standards class code | integer | yes | "1" : "Governmentally active (incorporated)","2" : "Minor civil division coextensive (incorporated)","3" : "Consolidated city (incorporated)","4" : "Minor civil division equivalent (incorporated)","5" : "Alaska Native village statistcal area (incorporated)","6" : "Independent city","7" : "Consolidated city portion","8" : "Operationally inactive incorporated place","10" : "American Indian reservation (trust lands)","11" : "American Indian reservation (no trust lands)","12" : "American Indian off-reservation trust land area","13" : "American Indian reservation (state-recognized)","14" : "American Indian tribe","15" : "Tribal subdivision","16" : "American Indian tribe (state-recognized)","20" : "Alaska Native statistical area (not a census-designated place)","21" : "Alaska Native statistical area (census-designated place)","22" : "Alaska Native statistcal area (incorporated place)","23" : "Alaska Native Regional Corporation","30" : "Hawaiian home land","40" : "Active county","41" : "Inactive or nonfunctioning county","42" : "Census area in Alaska","43" : "County coextensive with incorporated place","50" : "Installation of US Department of Defense","60" : "Governmentally active minor civil division (not incorporated place)","61" : "Governmentally active minor civil division (incorporated place)","62" : "Minor civil division—inactive government","70" : "Census-designated place","71" : "Census-designated place—name not commonly recognized","72" : "Populated place, not census designated","73" : "Census designated place—coincides with Alaska Native village statistical area","80" : "Minor civil division does not provide general-purpose governmental services","81" : "American Indian reservation that is primary county division","82" : "Unorganized territory identified for presenting statistical data","83" : "Census county division","84" : "Subbarrio","85" : "Incorporated place","86" : "Pseudo-minor civil division—water area" |
| `puma` | Public Use Microdata Area identifier | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `upper_chamber` | State legislative district upper chamber code | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_leg_district_upper` | State legislative district—upper | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `upper_chamber_name` | State upper chamber name | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lower_chamber` | State legislative district lower chamber code | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_leg_district_lower` | State legislative district—lower | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lower_chamber_name` | State lower chamber name | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `csa` | Combined statistical area | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cbsa` | Core-based statistical area | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cbsa_name` | Core-based statistical area name | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cbsa_type` | Core-based statistical area type: Metropolitan or micropolitan | integer | yes | "1" : "Metropolitan statistical area","2" : "Micropolitan statistical area","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cbsa_city` | Metropolitan or micropolitan statistical area (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lower_chamber_type` | Legal or statistical area description code for state legislative district lower chamber | integer | yes | "1" : "State legislative district","2" : "State legislative subdistrict","3" : "State house district","4" : "Vermont state house district","5" : "District","6" : "General assembly district","7" : "Assembly district","8" : "Other geographic entity" |
## `nhgis/schools_nhgis_geog_{year}`
- **Canonical mirror path:** `nhgis/schools_nhgis_geog_{year}.parquet` (4 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/nhgis/census-1990/{year}/`, `/api/v1/schools/nhgis/census-2000/{year}/`, `/api/v1/schools/nhgis/census-2010/{year}/`, `/api/v1/schools/nhgis/census-2020/{year}/`
- **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** here `{year}` is the census-geography vintage (`1990`, `2000`, `2010`, `2020`), not a data year. Each of the 4 files holds every data year: 1986-2023 with no gaps, 3,676,375 rows per file.
| 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" |
| `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" |
| `school_id` | School identification number (NCES) | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `school_name` | School name | string | no | "-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" |
| `street_mailing` | Street of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `city_mailing` | City of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_mailing` | State of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `zip_mailing` | Zip code of mailing address | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `street_location` | Street of location | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `city_location` | City of location | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_location` | State of location | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `zip_location` | Zip code of location | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `latitude` | Latitude of institution | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `longitude` | Longitude of institution | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `county_code` | County code | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `congress_district_id` | State and 114th congressional district identification number | integer | 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" |
| `geo_longitude` | Geocoded longitude of institution | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `geo_latitude` | Geocoded latitude of institution | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `geocode_accuracy` | Accuracy of geocode match | integer; **observed:** float (Float64; all values integral) | no | "1" : "High confidence","2" : "Medium confidence","3" : "Low confidence","4" : "Did not geocode","-2" : "Not applicable" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** values are a geocoder match score up to 100, plus -2, with 805 nulls per file. Each file has 2 rows with a value from 1 to 4; in the 1990 and 2010 files (the two tested) both are 4, so codes 1, 2 and 3 do not occur there. Every row is -2 in data years 2017-2023, and no earlier row is -2 (year pattern tested in the 1990 and 2010 files). |
| `geocode_accuracy_detailed` | Type of geocode match | integer | no | "1" : "Point address","2" : "Street address","3" : "Subaddress","4" : "Street intersection","5" : "Street address extension","6" : "Street name","7" : "Postal extension","8" : "Point of interest","9" : "Distance marker","10" : "Postal code","11" : "Locality","12" : "Postal location","-2" : "Not applicable" |
| `state_fips_geo` | 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-27):** the 1990 census-vintage file stores the state code times 10 (Alabama is 10) in 3,627,315 of 3,627,352 school rows matched by ncessch and year to the 2010 file; the 2000, 2010 and 2020 files store the plain code. |
| `county_fips_geo` | Federal Information Processing Standards county code | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** the 2000 census-vintage file does not hold a county FIPS code: values run 10-990, never 5 digits, and in 2,509,923 of 3,624,395 school rows matched to the 2010 file they equal 10 times the 3-digit county code (Alabama county 073 is 730). The 1990, 2010 and 2020 files hold the 5-digit state+county code. |
| `tract` | Census tract | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `block_group` | Block group number | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `geoid_block` | Block identifier | string; **observed:** integer (Int64 in all 4 files) | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" ; **Observed on pinned mirror (rev `0ad00ce0`, probe 2026-10-27):** never a 15-digit block GEOID. In the 2010 file it equals the 12-digit block-group GEOID rebuilt from the file's own columns (Int64, so the leading zero drops when the state FIPS is below 10; zero-pad to 12); the 2020 file has the same 11-12-digit lengths and state+county prefix. In the 1990 file it equals the 11-digit tract GEOID. In the 2000 file it has 10-11 digits and its composition was not established. |
| `census_region` | Census Bureau region | integer | yes | "1" : "Northeast","2" : "Midwest","3" : "South","4" : "West","9" : "Puerto Rico" |
| `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" |
| `msa_cmsa` | Federal Information Processing Standards metropolitan statistical area or consolidated metropolitan statistical area code | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `place_fips` | Federal Information Processing Standards place code | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `geoid_place` | Place identifier | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `place_name` | Place name | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `class_code` | Federal Information Processing Standards class code | integer | yes | "1" : "Governmentally active (incorporated)","2" : "Minor civil division coextensive (incorporated)","3" : "Consolidated city (incorporated)","4" : "Minor civil division equivalent (incorporated)","5" : "Alaska Native village statistcal area (incorporated)","6" : "Independent city","7" : "Consolidated city portion","8" : "Operationally inactive incorporated place","10" : "American Indian reservation (trust lands)","11" : "American Indian reservation (no trust lands)","12" : "American Indian off-reservation trust land area","13" : "American Indian reservation (state-recognized)","14" : "American Indian tribe","15" : "Tribal subdivision","16" : "American Indian tribe (state-recognized)","20" : "Alaska Native statistical area (not a census-designated place)","21" : "Alaska Native statistical area (census-designated place)","22" : "Alaska Native statistcal area (incorporated place)","23" : "Alaska Native Regional Corporation","30" : "Hawaiian home land","40" : "Active county","41" : "Inactive or nonfunctioning county","42" : "Census area in Alaska","43" : "County coextensive with incorporated place","50" : "Installation of US Department of Defense","60" : "Governmentally active minor civil division (not incorporated place)","61" : "Governmentally active minor civil division (incorporated place)","62" : "Minor civil division—inactive government","70" : "Census-designated place","71" : "Census-designated place—name not commonly recognized","72" : "Populated place, not census designated","73" : "Census designated place—coincides with Alaska Native village statistical area","80" : "Minor civil division does not provide general-purpose governmental services","81" : "American Indian reservation that is primary county division","82" : "Unorganized territory identified for presenting statistical data","83" : "Census county division","84" : "Subbarrio","85" : "Incorporated place","86" : "Pseudo-minor civil division—water area" |
| `puma` | Public Use Microdata Area identifier | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `upper_chamber` | State legislative district upper chamber code | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_leg_district_upper` | State legislative district—upper | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `upper_chamber_name` | State upper chamber name | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lower_chamber` | State legislative district lower chamber code | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `state_leg_district_lower` | State legislative district—lower | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lower_chamber_name` | State lower chamber name | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `csa` | Combined statistical area | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cbsa` | Core-based statistical area | integer | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cbsa_name` | Core-based statistical area name | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cbsa_type` | Core-based statistical area type: Metropolitan or micropolitan | integer | yes | "1" : "Metropolitan statistical area","2" : "Micropolitan statistical area","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `cbsa_city` | Metropolitan or micropolitan statistical area (yes/no) | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lower_chamber_type` | Legal or statistical area description code for state legislative district lower chamber | integer | yes | "1" : "State legislative district","2" : "State legislative subdistrict","3" : "State house district","4" : "Vermont state house district","5" : "District","6" : "General assembly district","7" : "Assembly district","8" : "Other geographic entity" |
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: 198k | Updated | Claude CodeCodex | Verified | Install |