File Structure: School Enrollment (2007–2013)

File Structure for school-level enrollment by race/ethnicity, gender, and grade for academic years 2007–2013.

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.
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
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: Analysis Measurement & Accountability Reporting Division | dro@cde.ca.gov

Last Reviewed: Friday, October 25, 2024

Trending in Accessing Educational Data

Recently Posted in Accessing Educational Data

DataQuest Update, Issue #22 (added 26-Nov-2024)
DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.