Skip to main content
California Department of Education Logo

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
Recently Posted in Accessing Educational Data
  • DataQuest Update, Issue #20 (added 17-May-2024)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
  • File Structure: CBEDS Data About Schools/Districts (added 16-May-2024)
    File structure for California Basic Educational Data System (CBEDS) data about schools and districts for 2023.
  • File Structure: CBEDS by Race/Ethnic & Gender 2023 (added 16-May-2024)
    File structure for CBEDS data by race/ethnicity, gender, and school for 2023-24. Data include classified staff and home-to-school transportation data.
  • File Structure: Census Day Enrollment Data (added 16-May-2024)
    File structure for downloadable files containing Census Day TK/K–12 enrollment data from the California Longitudinal Pupil Achievement Data System (CALPADS) disaggregated by grade, race/ethnicity, gender, and other student details.
  • Two-Month Average Data Reports (added 09-Apr-2024)
    The page displays two-month average Early Education Division (EED) enrollment data for children by Program Length and Statutory Age for October/April in 2020−23.

  • Single-Month Reports (added 09-Apr-2024)
    The page displays California State Preschool Program (CSPP) Enrollment by Program Length, Statutory Age, Agency Classification, and Race/Ethnicity.
  • CSPP Enrollment by Provider County Reports (added 09-Apr-2024)
    The page provides links to annual October California State Preschool Program (CSPP) enrollment reports by provider county for 2020−22 in XLSX format.
  • Annual Aggregate Reports (added 09-Apr-2024)
    The page displays the annual California State Preschool Program enrollment data by Statutory Age and Program Length for fiscal years 2020−23, providing an unduplicated count of children served by the California Department of Education (CDE).