File Structure: Graduates by Ethnicity 2011–17

Downloadable data files for graduates by racial/ethnic group and school.

Files: gradYY.txt

Field Name	Field Type	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.
COUNTY	Character	15	County name.
DISTRICT	Character	50	District name.
SCHOOL	Character	50	School name.
HISPANIC	Numeric	4	Hispanic or Latino.
AM_IND	Numeric	4	American Indian or Alaska Native, not Hispanic.
ASIAN	Numeric	4	Asian, not Hispanic.
PAC_ISLD	Numeric	4	Pacific Islander, not Hispanic.
FILIPINO	Numeric	4	Filipino, not Hispanic.
AFRICAN_AM	Numeric	4	African American, not Hispanic.
WHITE	Numeric	4	White, not Hispanic.
TWO_MORE_RACES	Numeric	4	Two or more races, not Hispanic.
NOT_REPORTED	Numeric	4	Race/ethnicity not reported.
TOTAL	Numeric	6	Total number of twelfth-grade graduates for year of data. This data includes summer graduates and does not include students with high school equivalencies, such as, General Educational Development (GED) test or California High School Proficiency Examination (CHSPE).
YEAR	Character	4	Year of data.

Questions: Analysis Measurement & Accountability Reporting Division | dro@cde.ca.gov

Last Reviewed: Friday, February 28, 2025

Trending in Accessing Educational Data

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.