districts_lea
NCES CCD 2024-25 district directory (LEA grain) joined with NCES F-33 FY2023 for county FIPS (CONUM) and enrollment. ~19,500 active districts.
overview
19,497 active LEAs in SY2024-25 directory. ~99% match F-33 FY2023 for county FIPS and total enrollment.
current vintage — Directory: SY2024-25; Finance: FY2023
history — CCD directory: SY1986-87 to present; F-33: FY1992 to present
source & licensing
fields
| name | type | definition |
|---|---|---|
| city | string | City of the LEA's primary administrative address. |
| county_id | string | 5-character FIPS code identifying the county.Joins dim.counties on county_id. |
| data_year | int64 | Four-digit calendar year corresponding to the end of the school year in which data were collected (e.g., 2023 for the 2022-23 school year). |
| districts_in_state | int64 · count | Total number of LEAs in the same state during the reference school year. Provides state-level context for the LEA's row. |
| grade_high | string | Highest grade level offered by the LEA, using standard NCES grade codes (e.g., '08', '12', 'UG'). |
| grade_low | string | Lowest grade level offered by the LEA, using standard NCES grade codes (e.g., 'PK', 'KG', '01'). |
| is_charter | string | Flag indicating whether the LEA is a charter school agency. Typically 'Y' or 'N'. |
| lea_name | string | Official name of the Local Education Agency (school district or equivalent administrative body). |
| lea_type | string | Numeric code indicating the category of LEA (e.g., regular school district, supervisory union, state agency). Corresponds to lea_type_text. |
| lea_type_text | string | Human-readable label describing the LEA type category, corresponding to the lea_type code. |
| leaidkey | string | NCES-assigned Local Education Agency (LEA) identifier, uniquely identifying each school district or equivalent administrative unit nationwide.Joins dim.lea on leaid. |
| level | string | Grade-level classification of the LEA (e.g., elementary, secondary, unified/combined) indicating the span of grades served. |
| offers_grade12 | string | Flag indicating whether the LEA offers 12th grade instruction. Typically 'Y', 'N', or blank. |
| offers_kg | string | Flag indicating whether the LEA offers kindergarten instruction. Typically 'Y', 'N', or blank. |
| offers_pk | string | Flag indicating whether the LEA offers pre-kindergarten instruction. Typically 'Y', 'N', or blank. |
| operational_schools | int64 · count | Number of operationally active schools within the LEA during the reference school year. Higher values indicate larger district footprints. |
| school_year | string | Academic year label for the record, typically formatted as 'YYYY-YY' (e.g., '2022-23'), representing the start and end years of the school year. |
| state_abbr | string | Two-letter USPS 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 | string | Numeric code representing the operational status of the LEA (e.g., open, closed, reopened). Corresponds to status_text. |
| status_text | string | Human-readable label describing the LEA's operational status, corresponding to the status_code. |
| total_membership | int64 · count | Total student enrollment (membership) in the LEA during the reference school year. Higher values indicate larger districts by student population. |
| zip_code | string | ZIP code of the LEA's primary administrative address.Joins dim.crosswalk_zip_county on zip_code. |
joins
how to use this table
CCD is administrative census reported by SEAs. F-33 is finance census collected by Census Bureau on behalf of NCES; CONUM is F-33-assigned county FIPS. Pipeline left-joins CCD <- F-33 on leaid.
School-level analysis (LEA grain); within-district equity comparisons; multi-county district apportionment (CONUM is single-county); current-year finance (F-33 lags 2 years).
Multi-county districts: CONUM single-county assignment under-attributes ~6% of LEAs. Charter LEAs sometimes use sponsor address. New SY24-25 LEAs may have no F-33 row.