Skip to main content
California Department of Education Logo

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: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Thursday, May 16, 2024
Recently Posted in Accessing Educational Data
  • DataQuest Schedule (added 20-Jun-2024)
    An overview of the DataQuest reports expected to be released in the coming year.
  • 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 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: 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: 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.