File Structure: School Enrollment (2014–2022)

File structure for school-level enrollment by enrollment type, race/ethnicity, gender, and grade for academic years 2014–2022.

Beginning in 2020–21, the annual enrollment counts provided in the DataQuest reports and in the supporting downloadable files include both primary and short-term enrollments (C = Combined Enrollment below) to align with other uses of the data, including the Unduplicated Pupil Count (UPC) used in the Local Control Funding Formula (LCFF), and for the Free and Reduced Price Meal (FRPM) data, both of which include primary and short-term enrollments on Census Day.

Note: This file contains multiple years of data. The ACADEMIC_YEAR field is provided that may be used to select a single year of data or to aggregate the data by year. Additionally, this file does not contain the county, district, or school name. To obtain this data, download the Public Schools and Districts Data Files and match records by the CDS_CODE field.

Field Name	Type Field	Width	Description
ACADEMIC_YEAR	Character	7	Year of data.
CDS_CODE	Character	14	This 14-digit code is the official, unique identification of a school within California. The first two digits identify the county, the next five digits identify the school district, and the last seven digits identify the school.
COUNTY	Character	50	County name.
DISTRICT	Character	50	District name.
SCHOOL	Character	50	School name.
ENR_TYPE	Character	1	Type of enrollment record. This field is coded as follows: P = Primary Enrollment The student’s name appears on a register, roll, or list, the student is currently attending (or intends to attend) the educational service institution (ESI), or is responsible for the student's instruction (students attending NPS schools). C = Combined Enrollment The combined enrollment of primary and short-term students. Short-term enrollment is defined as when the student’s name appears on a register, roll, or list, the student is currently attending the educational service institution, and receives or will receive the majority of their instruction at the institution for less than 30 days.
RACE_ETHNICITY	Character	1	Race/Ethnicity is coded as follows: Code 0 = Not reported Code 1 = American Indian or Alaska Native, Not Hispanic Code 2 = Asian, Not Hispanic Code 3 = Pacific Islander, Not Hispanic Code 4 = Filipino, Not Hispanic Code 5 = Hispanic or Latino Code 6 = African American, not Hispanic Code 7 = White, not Hispanic Code 9 = Two or More Races, Not Hispanic
GENDER	Character	1	Gender is coded as follows: M = Male F = Female X = Non-Binary (Beginning 2019–20) Z = Missing
GR_KN	Numeric	4	Students enrolled in kindergarten.
GR_1	Numeric	4	Students enrolled in grade one.
GR_2	Numeric	4	Students enrolled in grade two.
GR_3	Numeric	4	Students enrolled in grade three.
GR_4	Numeric	4	Students enrolled in grade four.
GR_5	Numeric	4	Students enrolled in grade five.
GR_6	Numeric	4	Students enrolled in grade six.
GR_7	Numeric	4	Students enrolled in grade seven.
GR_8	Numeric	4	Students enrolled in grade eight.
UNGR_ELM	Numeric	4	Students enrolled in ungraded elementary classes in grades kindergarten through grade eight.
GR_9	Numeric	4	Students enrolled in grade nine.
GR_10	Numeric	4	Students enrolled in grade ten.
GR_11	Numeric	4	Students enrolled in grade eleven.
GR_12	Numeric	4	Students enrolled in grade twelve.
UNGR_SEC	Numeric	4	Students enrolled in ungraded secondary classes in grades nine through twelve.
ENR_TOTAL	Numeric	4	Total school enrollment for fields kindergarten (GR_KN) through grade twelve (GR_12) plus ungraded elementary (UNGR_ELM) and ungraded secondary classes (UNGR_SEC). Adults in kindergarten through grade twelve programs are not included.
ADULT	Numeric	4	Adults enrolled in kindergarten through grade twelve programs. This data does not include adults in independent study.

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219

Last Reviewed: Thursday, May 16, 2024

Trending in Accessing Educational Data

Recently Posted in Accessing Educational Data

No items posted in the last 60 days.