enrollment_district_year
District-level total enrollment (MEMBERSCH) from NCES F-33 FY2023. Demographic breakdown not included (county-total enrollment only).
tier aadmin_record
overview
overview
~19,000-20,000 active LEAs x ~10 years.
current vintage — SY2023-24 (released 2025)
history — CCD LEA enrollment: SY1986-87 to present
provenance
source & licensing
authority
U.S. Department of Education
dataset
NCES F-33 School District Finance Survey FY2023
source url
methodology
license
Public domain (U.S. Federal Government work)
citation
U.S. Department of Education, NCES. CCD LEA Universe - enrollment, SY2013-14 through SY2023-24.
schema
fields
| name | type | definition |
|---|---|---|
| lea_name | string | Official name of the Local Education Agency (school district). |
| leaidkey | string | NCES Local Education Agency (LEA) identifier uniquely identifying the school district.Joins dim.lea on leaid. |
| state_idkey | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| total_enrollment | int64 · count | Total number of students enrolled in the district. Higher values indicate larger districts. |
| yearkey | int64 | Reference year of the observation. |
relationships
joins
primary key
leaid, state_id, country_id, year
common joins
dim.geographies on county_id
districts_lea on leaid
graduation_district_year on (leaid, year)
usage
how to use this table
method
State-reported enrollment by grade, race/ethnicity, sex, ELL status, IDEA, and FRPL eligibility (where reported), aggregated to LEA.
do not use for
School-level enrollment (use CCD school file); homeschool or private school enrollment.
known issues
FRPL universe changed with Community Eligibility Provision - high-poverty districts may show 100% FRPL even with mixed populations.
last updated · Jul 7, 2026