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 #24 (added 17-Jul-2025)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
  • Information about the Staff Experience Data (added 17-Jul-2025)
    Overview of the Staff Experience data, including data sources, DataQuest reports, downloadable files, definitions, and other information helpful to understanding the data, reports, and downloadable files.
  • Information about the Staff Race/Ethnicity Data (added 17-Jul-2025)
    Overview of the Staff Race/Ethnicity data, including data sources, DataQuest reports, downloadable files, definitions, and other information helpful to understanding the data, reports, and downloadable files.
  • Staff Experience Downloadable Data Files (added 17-Jul-2025)
    Downloadable data files about certificated staff employed on Census Day disaggregated by years of experience, academic year, staff type, school grade span, and gender.
  • Student/Staff Ratios Downloadable Data Files (added 17-Jul-2025)
    Downloadable data files about student/staff ratios as of Census Day disaggregated by staff type, academic year, and school grade span.

  • File Structure: Staff Education Data (added 17-Jul-2025)
    File structure for downloadable data files containing Certificated Staff Education disaggregated by academic year, staff type, school grade span, and gender.
  • File Structure: Staff Experience Data (added 17-Jul-2025)
    File structure for downloadable data files containing Certificated Staff Experience disaggregated by academic year, staff type, school grade span, and gender.
  • File Structure: Staff Race/Ethnicity Data (added 17-Jul-2025)
    File structure for downloadable data files containing Certificated Staff by Race/Ethnicity disaggregated by academic year, staff type, school grade span, and gender.
  • Staff Counts by Education (added 17-Jul-2025)
    Reports and data about certificated staff employed on Census Day disaggregated by education level, academic year, staff type, school grade span, and gender.
  • Staff Counts by Experience (added 17-Jul-2025)
    Reports and data about certificated staff employed on Census Day disaggregated by years of experience, academic year, staff type, school grade span, and gender.