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
Recently Posted in Accessing Educational Data
  • 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.
  • Census Day Enrollment Data (added 16-May-2024)
    Downloadable data files containing annual Census Day TK/K–12 enrollment data disaggregated by grade, race/ethnicity, gender, and other student details.

  • Annual Aggregate Reports (added 09-Apr-2024)
    The page displays the annual California State Preschool Program enrollment data by Statutory Age and Program Length for fiscal years 2020−23, providing an unduplicated count of children served by the California Department of Education (CDE).
  • CSPP Enrollment by Provider County Reports (added 09-Apr-2024)
    The page provides links to annual October California State Preschool Program (CSPP) enrollment reports by provider county for 2020−22 in XLSX format.
  • Single-Month Reports (added 09-Apr-2024)
    The page displays California State Preschool Program (CSPP) Enrollment by Program Length, Statutory Age, Agency Classification, and Race/Ethnicity.
  • Two-Month Average Data Reports (added 09-Apr-2024)
    The page displays two-month average Early Education Division (EED) enrollment data for children by Program Length and Statutory Age for October/April in 2020−23.