lea
Canonical Local Education Agency (school district) dimension sourced from NCES CCD 2024-25 directory. Primary key is leaid (7-character, 2-digit state FIPS + 5-digit district number). Covers active, changed-boundary, closed, and new districts. No county FIPS in this source — district-to-county mapping requires a separate geographic crosswalk.
tier aTier A: federal K-12 administrative census.
overview
overview
19,497 LEAs (active, changed-boundary, closed, new). No county FIPS in source.
current vintage — 2024-2025
provenance
source & licensing
authority
U.S. National Center for Education Statistics
dataset
NCES CCD LEA Directory
source url
license
Public domain (U.S. Federal Government work)
citation
U.S. NCES, Common Core of Data LEA Directory, 2024-25.
schema
fields
| name | type | definition |
|---|---|---|
| city | string | City in which the district's administrative office is located. |
| country_id | string | ISO alpha-2 country code (always 'US' for domestic tables). |
| grade_high | string | Highest grade offered by the LEA (e.g. '08', '12'). |
| grade_low | string | Lowest grade offered by the LEA (e.g. 'PK', 'KG', '01'). |
| is_charter | string | Boolean flag (as string); True if the LEA is a charter school agency. |
| lea_name | string | Official name of the local education agency (school district) as reported in the NCES CCD directory. |
| lea_type | string | Numeric LEA type code as reported by NCES; see lea_type_text for the human-readable meaning. |
| lea_type_text | string | Human-readable LEA type description (e.g. 'Regular local school district', 'Charter school agency', 'Regional education service agency'). |
| leaidkey | string | 7-character Local Education Agency identifier (2-digit state FIPS + 5-digit district number). Primary key; join on this to link district-level records.Part of primary key. Joins dim.lea on leaid. |
| level | string | Grade span served by the LEA (e.g. 'Elementary', 'Secondary', 'Unified'). |
| no_grades_flag | string | Boolean flag (as string); True if the LEA does not serve traditional K-12 grades (e.g. a service or administrative agency). |
| offers_grade12 | string | Boolean flag (as string); True if the LEA offers grade 12. |
| offers_kg | string | Boolean flag (as string); True if the LEA offers kindergarten. |
| offers_pk | string | Boolean flag (as string); True if the LEA offers pre-kindergarten. |
| operational_schools | int64 · count | Number of operational schools administered by the LEA. Higher values indicate a larger district. |
| school_year | string | School year of the directory snapshot from which this record was sourced (e.g. '2024-2025'). |
| state_abbr | string | 2-letter USPS postal abbreviation for the state in which the district is located. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| state_name | string | Human-readable state name corresponding to state_id. |
| status_code | string | Operational status code: 1=active, 2=changed-boundary, 3=closed, 4=new. See status_text for labels. |
| status_text | string | Human-readable description of the LEA's operational status corresponding to status_code. |
| zip_code | string | ZIP code of the district's administrative office. String to preserve leading zeros.Joins dim.crosswalk_zip_county on zip_code. |
relationships
joins
primary key
leaid
common joins
not provided
usage
how to use this table
method
Loaded from the CCD LEA directory; no derivation.
do not use for
County joins without a district-county crosswalk; school-level analysis.
last updated · Jul 7, 2026