| Field | Type | Required | Description |
|---|
| agency_id | text | Yes | Stable Oddity agency identifier compatible with the agencies table in the current U.S. Public Schools Database. |
| nces_district_id | text | Yes | Seven-digit NCES education-agency identifier, stored as text. |
| district_name | text | Yes | Reported education-agency name. |
| state_district_id | text | Yes | State-assigned education agency identifier, stored as text. |
| reporting_jurisdiction | text | Yes | Reporting state, territory, or Bureau of Indian Education (BI). |
| location_state | text | Yes | State or territory of the reported physical address. |
| location_city | text | Yes | Reported physical-address city. |
| postal_code | text | Yes | Five-digit postal code stored as text to preserve leading zeros. |
| postal_extension | text | No | Four-digit postal extension stored as text. |
| mailing_city | text | Yes | Reported mailing-address city. |
| mailing_state | text | Yes | Reported mailing-address state or territory. |
| mailing_postal_code | text | Yes | Mailing ZIP code stored as text. |
| mailing_postal_extension | text | No | Mailing ZIP extension stored as text. |
| phone | text | Yes | Published telephone number; not independently tested or consent to contact. |
| website | text | No | Published website address; not independently tested. |
| directory_school_year | text | Yes | Reference year of current directory facts. |
| agency_type_code | text | Yes | NCES agency-type code as text; includes regular/charter/specialized districts and supporting agencies. |
| agency_type | text | Yes | Full reported education-agency type. |
| operational_status | text | Yes | Latest reported status at the May 6 2026 extraction, not a real-time check. |
| start_year_status | text | Yes | Reported status at the start of the reference school year. |
| charter_agency_status | text | Yes | Reported charter-agency classification; unavailable is not No. |
| lowest_grade | text | Yes | Lowest grade code; PK preschool, KG kindergarten, UG ungraded, AE adult education, M missing and N not applicable. |
| highest_grade | text | Yes | Highest grade code; PK preschool, KG kindergarten, UG ungraded, AE adult education, M missing and N not applicable. |
| education_level | text | Yes | Reported elementary, secondary, other or ungraded agency level. |
| supervisory_union_code | text | No | State-assigned supervisory-union or county-superintendent code; not globally unique. |
| no_grades_indicator | text | Yes | Reported no-grades indicator; preserve source categories. |
| location_address | text | Yes | Combined reported street-address lines. |
| mailing_address | text | Yes | Combined reported street-address lines. |
| status_effective_date | text | Yes | Effective date of updated status, which may predate the school year. |
| reported_operational_school_count | integer | Yes | Published aggregate operational-school count; a source-derived directory measure, not a fresh count of school locations. |
| grades_offered | text | No | Explicitly offered grade codes, including PK, KG, UG and AE where reported; blank is unavailable, not absence of education. |
| statistics_school_year | text | Yes | Reference year for enrollment and staff measures; older than the directory. |
| enrollment_total | integer | No | Published enrollment including adult education where reported. |
| enrollment_total_status | text | Yes | Source value status; suppressed/missing/not reported/not applicable values remain null. |
| nonadult_enrollment | integer | No | Published enrollment excluding adult education; may include preschool, grade13 and ungraded pupils. |
| nonadult_enrollment_status | text | Yes | Source value status; suppressed/missing/not reported/not applicable values remain null. |
| teacher_fte | decimal | No | Staff full-time equivalents for teachers, not headcount. Categories and totals overlap and must not be added together. |
| teacher_fte_status | text | Yes | Source value status; suppression and missingness preserved. |
| total_staff_fte | decimal | No | Staff full-time equivalents for no category codes, not headcount. Categories and totals overlap and must not be added together. |
| total_staff_fte_status | text | Yes | Source value status; suppression and missingness preserved. |
| district_administrator_fte | decimal | No | Staff full-time equivalents for lea administrators, not headcount. Categories and totals overlap and must not be added together. |
| district_administrator_fte_status | text | Yes | Source value status; suppression and missingness preserved. |
| district_administrative_support_fte | decimal | No | Staff full-time equivalents for lea administrative support staff, not headcount. Categories and totals overlap and must not be added together. |
| district_administrative_support_fte_status | text | Yes | Source value status; suppression and missingness preserved. |
| school_administrator_fte | decimal | No | Staff full-time equivalents for school administrators, not headcount. Categories and totals overlap and must not be added together. |
| school_administrator_fte_status | text | Yes | Source value status; suppression and missingness preserved. |
| guidance_counselor_fte | decimal | No | Staff full-time equivalents for guidance counselors, not headcount. Categories and totals overlap and must not be added together. |
| guidance_counselor_fte_status | text | Yes | Source value status; suppression and missingness preserved. |
| school_psychologist_fte | decimal | No | Staff full-time equivalents for school psychologists, not headcount. Categories and totals overlap and must not be added together. |
| school_psychologist_fte_status | text | Yes | Source value status; suppression and missingness preserved. |
| instructional_aide_fte | decimal | No | Staff full-time equivalents for paraprofessionals/instructional aides, not headcount. Categories and totals overlap and must not be added together. |
| instructional_aide_fte_status | text | Yes | Source value status; suppression and missingness preserved. |
| librarian_media_specialist_fte | decimal | No | Staff full-time equivalents for librarians/media specialists, not headcount. Categories and totals overlap and must not be added together. |
| librarian_media_specialist_fte_status | text | Yes | Source value status; suppression and missingness preserved. |
| nonadult_students_per_teacher_fte | decimal | No | Same-year nonadult enrollment divided by positive teacher FTE, rounded to three decimals. Null when either measure is unavailable or denominator is zero; not class size or a national estimate. |
| geography_match_status | text | Yes | Older geography retained only when identifier and entire current physical address agree; otherwise geographic facts withheld. |
| geography_school_year | text | No | Reference year of matched office geography. |
| latitude | decimal | No | Office latitude in NAD83 decimal degrees; not district boundaries or guaranteed rooftop accuracy. |
| longitude | decimal | No | Office longitude in NAD83 decimal degrees; not district boundaries or guaranteed rooftop accuracy. |
| county_fips | text | No | Dated office county fips, not a description of every area served by the district. |
| county_name | text | No | Dated office county name, not a description of every area served by the district. |
| locale_code | text | No | NCES district locale assignment, reflecting schools and enrollment rather than simply the office location; 11-13 city,21-23 suburb,31-33 town,41-43 rural. |
| metro_area_code | text | No | Dated office metro area code, not a description of every area served by the district. |
| metro_area_name | text | No | Dated office metro area name, not a description of every area served by the district. |
| metro_area_type | text | No | Dated office metro area type, not a description of every area served by the district. |
| historical_oddity_record_id | text | No | Identifier in the owned 2011-06-09 Oddity release, retained only for exact NCES ID and normalized name/city/state matches; not current operational evidence. |
| historical_timezone_code | text | No | Unverified historical time-zone code from the 2011-06-09 release, retained only when the current full physical address also matches; not an IANA time-zone identifier. |
| historical_observes_dst | text | No | Historical Y/N daylight-saving flag from the 2011-06-09 release; unknown values remain null. Not verified current. |
| historical_release_date | text | No | Publication date of the historical Oddity release supplying time-zone/DST facts; original measurement date is unknown. |
| historical_value_status | text | No | historical_unverified when a historical time-zone/DST supplement is present, otherwise null. No historical value replaces a current official value. |
