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:   Analysis Measurement & Accountability Reporting Division | dro@cde.ca.gov
Last Reviewed: Friday, February 28, 2025
Recently Posted in Accessing Educational Data
  • DataQuest Update, Issue #26 (added 01-Oct-2025)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
  • File Structure: JCCC Schools Data – Grad Outcomes (added 01-Oct-2025)
    File structure for the Juvenile Court and County Community (JCCC) Schools Graduation outcomes data from the California Longitudinal Pupil Achievement Data System (CALPADS).
  • File Structure: JCCC Schools Data – Dashboard (added 01-Oct-2025)
    File structure for the Juvenile Court and County Community (JCCC) Schools dashboard data from the California Longitudinal Pupil Achievement Data System (CALPADS).
  • Information about JCCC Schools Data (added 01-Oct-2025)
    High-level overview regarding the collection and reporting of Juvenile Court and County Community (JCCC) Schools data.
  • Juvenile Court and County Community Schools Data (added 01-Oct-2025)
    Downloadable data files containing student enrollment, graduation outcomes, course enrollments and statewide dashboard summaries for juvenile court and county community schools.

  • File Structure: JCCC Schools Data – Re-Enrollment (added 01-Oct-2025)
    File structure for the Juvenile Court and County Community (JCCC) Schools Re-Enrollment data from the California Longitudinal Pupil Achievement Data System (CALPADS).
  • File Structure: JCCC Schools Data - Course (added 01-Oct-2025)
    File structure for the Juvenile Court and County Community (JCCC) Schools Course data from the California Longitudinal Pupil Achievement Data System (CALPADS).
  • DataQuest Update, Issue #25 (added 24-Sep-2025)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.