Skip to main content
California Department of Education Logo

File Structure: Graduates by Race & Gender

File structure for downloadable data files for graduates by race/ethnic designation and gender by school.

Files: gradsYY.txt

For each school, there is one record for every instance where there is data. A school may have 1 to 16 record(s), depending on data reported.

Note: This file does not contain the county name, district name or school name. To obtain this data, users must download the Public Schools and Districts Data Files and match records by the CDS_CODE field. See description of CDS_CODE field below.

Field Name Type Field Width Description

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.

ETHNIC

Character

1

This is a coded field for race/ethnic designation. The ethnic designations are 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 (formerly known as Black, not Hispanic)
  • Code 7 = White, not Hispanic
  • Code 9 = Two or More Races, Not Hispanic

GENDER

Character

1

This field is a coded field identifying gender. The gender is coded as follows:

  • M = Male
  • F = Female

GRADS

Numeric

4

Number of twelfth-grade graduates. This data includes summer graduates and does not include students with high school equivalencies (i.e., General Educational Development (GED) test or California High School Proficiency Examination (CHSPE)).

UC_GRADS

Numeric

4

Number of twelfth-grade graduates who also completed all courses required for entry into the University of California (UC) and/or California State University (CSU) with a grade "C" or better. This data includes summer graduates and does not include students with high school equivalencies (i.e., GED or CHSPE).

YEAR Character 4 Year of data.
Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Friday, February 16, 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.