Skip to main content
California Department of Education Logo

Using the CGR Data File

This page explains how to effectively use the sub-setting variables included in this CGR data file to obtain the desired counts.

How to use the College-Going Rate (CGR) Data File

The College-Going Rate (CGR) data file contains different subsets of data based on the values of different variables. If these sub-setting variables are not used properly, it is easy to end up with incorrect or duplicative data. Please refer to the following examples below as a guide for properly using these data:

  • Get school-level data totals with one record per school with school totals (without student group totals)
    • Aggregate Level = S (School)
    • Charter School (Y/N) = All
    • Alternative School Accountability Status (ASAS) (Y/N) = All
    • Reporting Category = TA
  • Get school-level data totals by student group (Reporting Category) for all non-charter schools
    • Aggregate Level = S (School)
    • Charter School (Y/N) = N
    • ASAS (Y/N) = All
    • Reporting Category Not equal to TA
  • Get school-level data totals by student group (Reporting Category) for all ASAS schools
    • Aggregate Level = S (School)
    • Charter School (Y/N) = All
    • ASAS (Y/N) = Y
    • Reporting Category Not equal to TA
  • Get district-level data totals by student group (Reporting Category) for non-charter schools
    • Aggregate Level = D (District)
    • Charter School (Y/N) = N
    • ASAS (Y/N) = All
    • Reporting Category Not equal to TA
  • Get statewide-level data totals for charter schools that are ASAS schools
    • Aggregate Level = T (State)
    • Charter School (Y/N) = Y
    • ASAS (Y/N) = Y
    • Reporting Category = TA
Questions:   Analysis Measurement & Accountability Reporting Division | dro@cde.ca.gov
Last Reviewed: Tuesday, March 4, 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.
  • 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.
  • 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.

  • 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.
  • 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 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.
  • 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.
  • 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.