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-crdc.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 — `crdc`
**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 `crdc`: 24 dataset families, 397 unique variables.
## `crdc/schools_crdc_algebra_{year}`
- **Canonical mirror path:** `crdc/schools_crdc_algebra_{year}.parquet` (6 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/algebra1/{year}/disability/sex/`, `/api/v1/schools/crdc/algebra1/{year}/lep/sex/`, `/api/v1/schools/crdc/algebra1/{year}/race/sex`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `grade_crdc` | Grade | integer | yes | "20" : "Grades 7 and 8","21" : "Grades 9 and 10","22" : "Grades 11 and 12","99" : "Total","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_algebra1` | Students enrolled in algebra I | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_passing_algebra1` | Students passing algebra I | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_ap_exams_{year}`
- **Canonical mirror path:** `crdc/schools_crdc_ap_exams_{year}.parquet` (4 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/ap-exams/{year}/disability/sex/`, `/api/v1/schools/crdc/ap-exams/{year}/lep/sex/`, `/api/v1/schools/crdc/ap-exams/{year}/race/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_ap_exam_none` | Students who took no AP exams | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_ap_pass_none` | Students who did not receive a qualifying score on any AP exams | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_ap_exam_oneormore` | Students who took one or more AP exams | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_ap_pass_oneormore` | Students who received a qualifying score on one or more AP exams | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_ap_exam_all` | Students who took exams for all AP courses enrolled | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_ap_pass_all` | Students who received a qualifying score in all AP exams | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_apib_enroll`
- **Canonical mirror path:** `crdc/schools_crdc_apib_enroll.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/ap-ib-enrollment/{year}/disability/sex/`, `/api/v1/schools/crdc/ap-ib-enrollment/{year}/lep/sex/`, `/api/v1/schools/crdc/ap-ib-enrollment/{year}/race/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_ib` | Students enrolled in the International Baccalaureate Diploma Program | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_gifted_talented` | Students who are enrolled in the gifted and talented programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_ap` | Students enrolled in at least one Advanced Placement (AP) course | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_ap_science` | Students enrolled in at least one AP science course | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_ap_math` | Students enrolled in at least one AP mathematics course | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_ap_other` | Students enrolled in at least one 'other' AP course (e.g., foreign language, computer science) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_ap_language` | Students enrolled in one or more AP language courses | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_ap_compsci` | Students enrolled in at least one AP computer science course | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_chronic_absenteeism_{year}`
- **Canonical mirror path:** `crdc/schools_crdc_chronic_absenteeism_{year}.parquet` (6 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/chronic-absenteeism/{year}/disability/sex/`, `/api/v1/schools/crdc/chronic-absenteeism/{year}/lep/sex/`, `/api/v1/schools/crdc/chronic-absenteeism/{year}/race/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_chronically_absent` | Chronically absent students | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `homeless` | Students who are homeless | integer | yes | "1" : "Yes","99" : "Total" |
## `crdc/schools_crdc_covid_indicators`
- **Canonical mirror path:** `crdc/schools_crdc_covid_indicators.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/covid-indicators/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `covid_instruction_type` | How was instruction provided during the 2020-21 school year | integer | no | "1" : "Only in-person instruction with additional safety precautions was offered because of the coronavirus pandemic.","2" : "Only virtual instruction was offered because of the coronavirus pandemic","3" : "A hybrid of in-person and virtual instruction (e.g., some students received in-person instruction while others received virtual instruction) was offered because of the coronavirus pandemic","4" : "There was no effect on the instruction we offered because of the coronavirus pandemic","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `covid_virtual_type` | Description of the virtual learning setting | integer | no | "1" : "Students were physically in the school setting, while teachers, who provided these students virtual instruction, were in a remote location","2" : "Students were not physically in the school setting (e.g., students were at home or another remote location)","3" : "Both 1 and 2","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `covid_remote_time` | Amount of remote instruction provided by teachers | integer | no | "1" : "Students were taught by teachers who provided 5 or more hours of remote instruction on average each day. not including intersession or summer.","2" : "Students were taught by teachers who provided 3-4 hours of remote instruction on average each day.","3" : "Students were taught by teachers who provided 1-2 hours of remote instruction on average each day.","4" : "Students were taught by teachers who provided less than 1 hour of remote instruction on average each day.","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `covid_remote_time_pct` | Share of students that received remote instruction from teachers at any point during the regular school year, not including intersession or summer | integer | no | "1" : "1-25%","2" : "26-50%","3" : "51-75%","4" : "over 75%","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_credit_recovery`
- **Canonical mirror path:** `crdc/schools_crdc_credit_recovery.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/credit-recovery/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `credit_recovery_offered` | School has students who participate in credit recovery programs | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_credit_recovery` | Number of students who participate in credit recovery programs | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_discipline_k12_{year}`
- **Canonical mirror path:** `crdc/schools_crdc_discipline_k12_{year}.parquet` (6 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/discipline/{year}/disability/lep/sex/`, `/api/v1/schools/crdc/discipline/{year}/disability/race/sex/`, `/api/v1/schools/crdc/discipline/{year}/disability/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_susp_in_sch` | Students who received one or more in-school suspensions | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_susp_out_sch_single` | Students who received one out-of-school suspension | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_susp_out_sch_multiple` | Students who received more than one out-of-school suspension | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `expulsions_no_ed_serv` | Number of students expelled without educational services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `expulsions_with_ed_serv` | Number of students expelled with educational services | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `expulsions_zero_tolerance` | Number of students expelled under zero-tolerance policies | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_corporal_punish` | Number of students who received corporal punishment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_arrested` | Students who received a school-related arrest | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_referred_law_enforce` | Students who were referred to a law enforcement agency or official | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `transfers_alt_sch_disc` | Students who were transferred to an alternative school for disciplinary reasons | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `revised_flag` | Flag indicating if arrests variable has been revised by Office of Civil Rights | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_disciplineinstances`
- **Canonical mirror path:** `crdc/schools_crdc_disciplineinstances.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/discipline-instances/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `suspensions_instances` | Instances of suspensions | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `suspensions_instances_preschool` | Instances of suspensions in preschool | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `corpinstances` | Instances of corporal punishment | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `corpinstances_preschool` | Instances of corporal punishment in preschool | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_dual_enrollment`
- **Canonical mirror path:** `crdc/schools_crdc_dual_enrollment.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/dual-enrollment/{year}/disability/sex`, `/api/v1/schools/crdc/dual-enrollment/{year}/lep/sex`, `/api/v1/schools/crdc/dual-enrollment/{year}/race/sex`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_dual_enrollment` | Number of students enrolled in a dual enrollment or dual credit program | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_enrollment_k12_{year}`
- **Canonical mirror path:** `crdc/schools_crdc_enrollment_k12_{year}.parquet` (6 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/enrollment/{year}/disability/sex/`, `/api/v1/schools/crdc/enrollment/{year}/lep/sex/`, `/api/v1/schools/crdc/enrollment/{year}/race/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrollment_crdc` | Student enrollment | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `psenrollment_crdc` | Number of students enrolled in preschool programs | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_finance`
- **Canonical mirror path:** `crdc/schools_crdc_finance.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/school-finance/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `salaries_teachers` | Personnel salaries at school level— teachers only—amount | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_total` | Total salary amount | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_instruc_staff` | Personnel salaries at school level—instructional staff only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_instructional_aides` | Salary expenditure for instructional aides funded with state and local funds | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_support` | Salary expenditure for support staff funded with state and local funds | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `salaries_administration` | Salary expenditure for administration staff funded with state and local funds | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `expenditures_nonpersonnel` | Non-personnel expenditures at school level | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `instructional_aides_fte` | Number of full-time equivalent instructional aides or paraprofessionals | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `support_fte` | Number of support staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `administration_fte` | Number of school administration staff | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_harass_bully_allegations`
- **Canonical mirror path:** `crdc/schools_crdc_harass_bully_allegations.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/harassment-or-bullying/{year}/allegations/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `allegations_harass_sex` | Number of allegations of harassment or bullying on the basis of sex | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `allegations_harass_race` | Number of allegations of harassment or bullying on the basis of race, color, or national origin | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `allegations_harass_disability` | Number of allegations of harassment or bullying on the basis of disability | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `allegations_harass_orientation` | Allegations of harassment or bullying on the basis of sexual orientation | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `allegations_harass_religion` | Allegations of harassment or bullying on the basis of religion | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harrass_religion_atheist` | Number of allegations of harassment or bullying on the basis of religion, by atheism or agnosticism | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harrass_religion_buddhist` | Number of allegations of harassment or bullying on the basis of religion, by Buddhist | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harrass_religion_catholic` | Number of allegations of harassment or bullying on the basis of religion, by Catholic | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harrass_religion_orthodox` | Number of allegations of harassment or bullying on the basis of religion, by Eastern Orthodox (Russian, Greek, other) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harrass_religion_hindu` | Number of allegations of harassment or bullying on the basis of religion, by Hindu | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harrass_religion_islam` | Number of allegations of harassment or bullying on the basis of religion, by Islamic (Muslim) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harrass_religion_jehovah` | Number of allegations of harassment or bullying on the basis of religion, by Jehovah’s Witness | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harrass_religion_jewish` | Number of allegations of harassment or bullying on the basis of religion, by Jewish | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harrass_religion_mormon` | Number of allegations of harassment or bullying on the basis of religion, by Mormon | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harrass_religion_multi` | Number of allegations of harassment or bullying on the basis of religion across multiple religions | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harass_religion_otherchristian` | Number of allegations of harassment or bullying on the basis of religion across other Christian faiths | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harass_religion_otherrel` | Number of allegations of harassment or bullying on the basis of religion across other religions | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harass_religion_protestant` | Number of allegations of harassment or bullying on the basis of religion, by Protestant | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `harass_religion_sikh` | Number of allegations of harassment or bullying on the basis of religion, by Sikh | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_harass_bully_students_{year}`
- **Canonical mirror path:** `crdc/schools_crdc_harass_bully_students_{year}.parquet` (6 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/harassment-or-bullying/{year}/disability/sex/`, `/api/v1/schools/crdc/harassment-or-bullying/{year}/lep/sex/`, `/api/v1/schools/crdc/harassment-or-bullying/{year}/race/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_disc_harass_dis` | Number of students disciplined for bullying or harassment on the basis of disability | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_disc_harass_race` | Number of students disciplined for bullying or harassment on the basis of race, color, or national origin | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_disc_harass_sex` | Number of students disciplined for bullying or harassment on the basis of sex | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_report_harass_dis` | Number of students harassed or bullied on the basis of disability | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_report_harass_race` | Number of students harassed or bullied on the basis of race, color, or national origin | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_report_harass_sex` | Number of students harassed or bullied on the basis of sex | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_internet_access`
- **Canonical mirror path:** `crdc/schools_crdc_internet_access.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/internet-access/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `sch_internet_fiber` | The school is connected to Internet through a fiber-optic connection | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_internet_wifi` | The school has Wi-Fi access in every classroom | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_internet_schdev` | The school allows students to take home school-issued devices that can be used to access the Internet for student learning | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_internet_studdev` | The school allows students to bring to school student-owned devices that can be used to access the Internet for classroom or student learning | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_internet_wifiendev` | Number of Wi-Fi enabled devices provided by the school to students | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_mathandscience`
- **Canonical mirror path:** `crdc/schools_crdc_mathandscience.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/math-and-science/{year}/disability/sex/`, `/api/v1/schools/crdc/math-and-science/{year}/lep/sex/`, `/api/v1/schools/crdc/math-and-science/{year}/race/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_biology` | Students enrolled in biology | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_chemistry` | Students enrolled in chemistry | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_advanced_math` | Students enrolled in advanced mathematics | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_calculus` | Students enrolled in calculus | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_algebra2` | Students enrolled in algebra II | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_physics` | Students enrolled in physics | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `enrl_geometry` | Students enrolled in geometry | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_offenses`
- **Canonical mirror path:** `crdc/schools_crdc_offenses.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/offenses/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `firearm_incident_ind` | At least one incident at the school involved a shooting | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `homicide_ind` | A student, faculty, or staff member died as a result of a homicide committed at the school | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rape_incidents` | Incidents of rape or attempted rape | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sexual_battery_incidents` | Incidents of sexual assault (other than rape) | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `robbery_w_weapon_incidents` | Incidents of robbery with a weapon | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `robbery_w_firearm_incidents` | Incidents of robbery with a firearm or explosive device | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `robbery_no_weapon_incidents` | Incidents of robbbery without a weapon | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `attack_w_weapon_incidents` | Incidents of physical attack or fight with a weapon | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `attack_w_firearm_incidents` | Incidents of physical attack or fight with a firearm or explosive device | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `attack_no_weapon_incidents` | Incidents of physical attack or fight without a weapon | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `threats_w_weapon_incidents` | Incidents of threats of physical attack with a weapon | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `threats_w_firearm_incidents` | Incidents of threats of physical attack with a firearm or explosive device | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `threats_no_weapon_incidents` | Incidents of threats of physical attack without a weapon | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `possession_firearm_incidents` | Incidents of possession of a firearm or explosive device | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rape_bystudents` | Number of documented incidents of rape or attempted rape committed by a student at school. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sexual_battery_bystudents` | Number of documented incidents of sexual assault (other than rape) committed by a student at school. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `rape_bystaff` | Number of documented incidents of rape or attempted rape committed by a school staff member at school. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sexual_battery_bystaff` | Number of documented incidents of sexual assault (other than rape) committed by a school staff member at school. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alleg_rape_staff_resign` | Number of rape or attempted rape allegations against a school staff member, which were followed by a resignation or retirement before final discipline or termination. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alleg_sexual_batt_staff_resign` | Number of sexual assault (other than rape) allegations against a school staff member, which were followed by a resignation or retirement before final discipline or termination. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alleg_rape_staff_resp` | Number of rape or attempted rape allegations against a school staff member, which were followed by a determination that the school staff member was responsible for the offense. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alleg_sexual_batt_staff_resp` | Number of sexual assault (other than rape) allegations against a school staff member, which were followed by a determination that the school staff member was responsible for the offense. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alleg_rape_staff_notresp` | Number of rape or attempted rape allegations against a school staff member, which were followed by a determination that the school staff member was not responsible for the offense. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alleg_sexual_batt_staff_notresp` | Number of sexual assault (other than rape) allegations against a school staff member, which were followed by a determination that the school staff member was not responsible for the offense. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alleg_rape_staff_pending` | Number of rape or attempted rape allegations against a school staff member, which had a determination that remained pending. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alleg_sexual_batt_staff_pending` | Number of sexual assault (other than rape) allegations against a school staff member, which had a determination that remained pending. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alleg_rape_staff_reassign` | Number of rape or attempted rape allegations against a school staff member, which were followed by a duty reassignment before final discipline or termination. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alleg_sexual_batt_staff_reassign` | Number of sexual assault (other than rape) allegations against a school staff member, which were followed by a duty reassignment before final discipline or termination. | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_offerings`
- **Canonical mirror path:** `crdc/schools_crdc_offerings.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/offerings/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `num_classes_algebra1` | Number of algebra I classes | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_taught_certified_algebra1` | Number of algebra I classes taught by a certified teacher | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_classes_algebra2` | Number of algebra II classes | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_taught_certified_algebra2` | Number of algebra II classes taught by a certified teacher | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_classes_advanced_math` | Number of advanced math classes | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_taught_certified_adv_math` | Number of advanced math classes taught by a certified teacher | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_classes_calculus` | Number of calculus classes | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_taught_certified_calculus` | Number of calculus classes taught by a certified teacher | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_classes_biology` | Number of biology classes | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_taught_certified_biology` | Number of biology classes taught by a certified teacher | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_classes_chemistry` | Number of chemistry classes | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_taught_certified_chemistry` | Number of chemistry classes taught by a certified teacher | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_classes_geometry` | Number of geometry classes | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_taught_certified_geometry` | Number of geometry classes taught by a certified teacher | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_classes_physics` | Number of physics classes | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_taught_certified_physics` | Number of physics classes taught by a certified teacher | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ap_courses_indicator` | Advanced Placement program indicator | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `num_courses_ap` | Number of Advanced Placement courses | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_select_ap_indicator` | Advanced Placement course self-selection | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ap_courses_math_indicator` | Advanced Placement mathematics enrollment indicator | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ap_courses_science_indicator` | Advanced Placement science enrollment indicator | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ap_courses_other_indicator` | Advanced Placement other subjects enrollment indicator | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sch_dual_indicator` | School has students participating in a dual enrollment program | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `gifted_talented_indicator` | Gifted and talented education program indicator | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sports_single_sex_indicator` | Single-sex interscholastic athletics indicator | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sports_single_sex_m` | Number of male-only interscholastic sports | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sports_single_sex_f` | Number of female-only interscholastic sports | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teams_single_sex_m` | Number of male-only interscholastic sports teams | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teams_single_sex_f` | Number of female-only interscholastic sports teams | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `participants_single_sex_sports_m` | Number of male participants in single-sex interscholastic athletics | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `participants_single_sex_sports_f` | Number of female participants in single-sex interscholastic athletics | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `participants_single_sex_sports` | Number of participants in single-sex interscholastic athletics | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_indicator` | Single-sex academic classes indicator | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_alg_geom_m` | Number of algebra I, geometry, and algebra II classes for males only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_alg_geom_f` | Number of algebra I, geometry, and algebra II classes for females only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_alg_geom` | Number of single-sex algebra I, geometry, and algebra II classes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_othermath_m` | Number of other mathematics classes for males only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_othermath_f` | Number of other mathematics classes for females only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_othermath` | Number of other single sex mathematics classes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_science_m` | Number of science classes for males only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_science_f` | Number of science classes for females only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_science` | Number of single-sex science classes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_english_m` | Number of English classes for males only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_english_f` | Number of English classes for females only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_english` | Number of single-sex English classes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_other_m` | Number of other classes for males only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_other_f` | Number of other classes for females only | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `classes_single_sex_other` | Number of other single-sex classes | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_restraint_seclusion_instances`
- **Canonical mirror path:** `crdc/schools_crdc_restraint_seclusion_instances.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/restraint-and-seclusion/{year}/instances/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `instances_mech_restraint` | Number of instances of mechanical restraint | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `instances_phys_restraint` | Number of instances of physical restraint | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `instances_seclusion` | Number of instances of seclusion | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_restraint_seclusion_students_{year}`
- **Canonical mirror path:** `crdc/schools_crdc_restraint_seclusion_students_{year}.parquet` (6 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/restraint-and-seclusion/{year}/disability/lep/sex/`, `/api/v1/schools/crdc/restraint-and-seclusion/{year}/disability/race/sex/`, `/api/v1/schools/crdc/restraint-and-seclusion/{year}/disability/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_mech_restraint` | Number of students subjected to mechanical restraint | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_phys_restraint` | Number of students subjected to physical restraint | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_seclusion` | Number of students subjected to seclusion | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_retention_{year}`
- **Canonical mirror path:** `crdc/schools_crdc_retention_{year}.parquet` (5 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/retention/{year}/{grade}/disability/sex`, `/api/v1/schools/crdc/retention/{year}/{grade}/lep/sex`, `/api/v1/schools/crdc/retention/{year}/{grade}/race/sex`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `grade` | Grade | integer | yes | "-1" : "Pre-K","0" : "Kindergarten","1" : "1","2" : "2","3" : "3","4" : "4","5" : "5","6" : "6","7" : "7","8" : "8","9" : "9","10" : "10","11" : "11","12" : "12","13" : "13","14" : "Adult education","15" : "Ungraded","99" : "Total","999" : "Not specified" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_retained` | Students who were retained | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_sat_and_act_participation_{year}`
- **Canonical mirror path:** `crdc/schools_crdc_sat_and_act_participation_{year}.parquet` (6 mirror files)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/sat-act-participation/{year}/disability/sex/`, `/api/v1/schools/crdc/sat-act-participation/{year}/lep/sex/`, `/api/v1/schools/crdc/sat-act-participation/{year}/race/sex/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `students_sat_act` | Students participating in the SAT and ACT tests | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_school_characteristics`
- **Canonical mirror path:** `crdc/schools_crdc_school_characteristics.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/directory/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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_name_crdc` | Office of Civil Rights school name | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `schoolid_crdc` | 5-digit school identification code | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lea_name` | Local education agency name | string | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `leaid_crdc` | Local education agency identification number | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lea_state` | Local education agency state | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `prek` | At least one student enrolled in prekindergarten | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `k` | At least one student enrolled in kindergarten | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g1` | At least one student enrolled in 1st grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g2` | At least one student enrolled in 2nd grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g3` | At least one student enrolled in 3rd grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g4` | At least one student enrolled in 4th grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g5` | At least one student enrolled in 5th grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g6` | At least one student enrolled in 6th grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g7` | At least one student enrolled in 7th grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g8` | At least one student enrolled in 8th grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g9` | At least one student enrolled in 9th grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g10` | At least one student enrolled in 10th grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g11` | At least one student enrolled in 11th grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `g12` | At least one student enrolled in 12th grade | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ug` | At least one student enrolled in an ungraded level | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `primarily_serve_students_w_dis` | Primarily serves students with disabilities | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `charter_crdc` | Charter school | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `magnet_crdc` | Magnet school | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `entire_school_magnet` | Entire school magnet | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alt_school` | Alternative school | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `alt_school_focus` | Type of alternative school | integer | yes | "1" : "Academic difficulties","2" : "Discipline problems","3" : "Both academic difficulties and discipline problems","-1" : "Missing/not reported","-2" : "Not applicable" |
| `ability_grouped_math_or_eng` | Number of students' ability grouped for math or English | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ug_elementary_school` | Number of ungraded elementary school students | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ug_middle_school` | Number of ungraded middle school students | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `ug_high_school` | Number of ungraded high school students | integer | yes | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_suspensions`
- **Canonical mirror path:** `crdc/schools_crdc_suspensions.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/suspensions-days/{year}/disability/sex`, `/api/v1/schools/crdc/suspensions-days/{year}/lep/sex`, `/api/v1/schools/crdc/suspensions-days/{year}/race/sex`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `race` | Race/ethnicity | integer | yes | "1" : "White","2" : "Black","3" : "Hispanic","4" : "Asian","5" : "American Indian or Alaska Native","6" : "Native Hawaiian or other Pacific Islander","7" : "Two or more races","8" : "Nonresident alien","9" : "Unknown","20" : "Other","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `sex` | Sex | integer | yes | "1" : "Male","2" : "Female","3" : "Gender Not-Identified","9" : "Unknown","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `disability` | Students with disabilities | integer | yes | "0" : "Students without disabilities","1" : "Students with disabilities served under IDEA","2" : "Students with disabilities served under Section 504 only","3" : "Students not served under IDEA (includes students without disabilities and students served under Section 504)","4" : "Students with disabilities (served under Section 504 and under IDEA)","99" : "Total","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `lep` | Students with limited English proficiency | integer | yes | "1" : "Students who are limited English proficient","99" : "All students","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `days_suspended` | Number of days missed due to suspension | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
## `crdc/schools_crdc_teacher`
- **Canonical mirror path:** `crdc/schools_crdc_teacher.parquet` (1 mirror file)
- **Contributing endpoint route(s):** `/api/v1/schools/crdc/teachers-staff/{year}/`
| variable | label | type | filter? | coded values |
|---|---|---|---|---|
| `crdc_id` | Office of Civil Rights school ID | string | yes | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `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" |
| `leaid` | Local education agency identification number (NCES) | 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" |
| `teachers_fte_crdc` | Number of full-time equivalent teachers (Civil Rights Data Collection) | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_certified_fte` | Number of full-time equivalent certified teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_uncertified_fte` | Number of full-time equivalent uncertified teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_first_year_fte` | Number of full-time equivalent first-year teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_second_year_fte` | Number of full-time equivalent second-year teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_current_sy` | Number of current school year teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_previous_sy` | Number of previous school year teachers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_absent_fte` | Number of full-time equivalent teachers absent more than 10 school days | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `counselors_fte` | Number of full-time equivalent school counselors | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `social_workers_fte` | Number of full-time equivalent social workers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `psychologists_fte` | Number of full-time equivalent psychologists | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `nurses_fte` | Number of full-time equivalent nurses | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `law_enforcement_fte` | Number of full-time equivalen sworn law enforcement officers | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `security_guard_fte` | Number of full-time equivalent security guards | float | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `law_enforcement_ind` | Sworn law enforcement officers indicator | integer | no | "1" : "Yes","0" : "No","-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_current_male` | Number of current male teachers | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
| `teachers_current_female` | Number of current female teachers | integer | no | "-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data" |
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 |