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 aadmin_record
overview
overview
~18,000 LEAs across all 50 states + DC. Covers active, changed-boundary, closed, and new districts.
current vintage — SY 2024-25
history — CCD goes back to SY 1986-87; this table reflects the most recent directory snapshot
provenance
source & licensing
authority
U.S. National Center for Education Statistics
dataset
Common Core of Data (CCD) — Local Education Agency Universe Survey
source url
methodology
license
Public domain (U.S. Federal Government work)
citation
U.S. National Center for Education Statistics, Common Core of Data (CCD) LEA Universe Survey, SY 2024-25.
schema
fields
| name | type | definition |
|---|---|---|
| city | string | City where the LEA's administrative office is located, as reported in the NCES directory. |
| grade_high | string | Highest grade level offered by the LEA, encoded in NCES format (e.g. '08' for 8th grade, '12' for 12th grade). |
| grade_low | string | Lowest grade level offered by the LEA, encoded in NCES format (e.g. 'PK' for pre-kindergarten, 'KG' for kindergarten, '01' through '12' for grades 1–12). |
| is_charter | bool | True if the LEA is a charter school agency rather than a traditional public school district. |
| lea_name | string | Official name of the Local Education Agency as recorded in the NCES Common Core of Data directory. |
| lea_type | int64 | Numeric code indicating the type of LEA as classified by NCES (e.g. regular local school district, supervisory union, charter). See lea_type_text for the human-readable label. |
| lea_type_text | string | Human-readable description of the LEA type code (e.g. 'Regular local school district', 'Supervisory union component'). |
| leaidkey | string | 7-character Local Education Agency identifier, constructed as a 2-digit state FIPS code followed by a 5-digit district number. Serves as the primary key for this table.Joins dim.lea on leaid. |
| level | string | Grade span served by the LEA, indicating whether it is an elementary, secondary, or unified (K–12) district. |
| no_grades_flag | bool | True if the LEA does not serve traditional K–12 grades, such as adult education or vocational-only agencies. |
| offers_kg | bool | True if the LEA offers a kindergarten program. |
| offers_pk | bool | True if the LEA offers a pre-kindergarten program. |
| operational_schools | int64 · count | Number of schools within the LEA that are operationally active at the time of the directory snapshot. Higher values indicate larger districts by school count. |
| school_year | string | School year to which this directory snapshot applies, formatted as an academic year string (e.g. '2024-2025'). |
| state_abbr | string | 2-letter USPS postal abbreviation for the state in which the LEA 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 | int64 | Numeric code representing the LEA's operational status: 1=active, 2=changed-boundary, 3=closed, 4=new. See status_text for the human-readable label. |
| status_text | string | Human-readable description of the LEA's operational status code (e.g. 'Active', 'Closed'). |
| zip_code | string | ZIP code of the LEA's administrative office.Joins dim.crosswalk_zip_county on zip_code. |
relationships
joins
primary key
leaid
common joins
us_education fact tables with leaid
dim.states on state_id
usage
how to use this table
do not use for
County-level geographic analysis without an additional geographic crosswalk; leaid does not encode county FIPS
last updated · May 5, 2026