Skip to main content
California Department of Education Logo

Historical Staff Assignment and Course Data

Historical downloadable data files about staff assignments, class and course enrollment, and class size as of Census Day.

A Staff Data - Entity Relationship Diagram (PDF) diagram is provided to help users understand the new organization of files associated with staff demographics, credentials, courses taught, and course enrollment. Accessible Alternate Version (AAV) of the Staff Data - Entity Relationship Diagram

Staff Assignment / Class Section / Class Section Enrollment Downloadable Data Files
Year of Data Data File File Structure Number of Records
2012–13 On AssignmentCodes12On (XLSX; Revised 18-Nov-2019) File Structure: Assignment Code 12 On 1,150
2018–19 StaffAssign18.zip (23MB; Posted 18-Nov-2019) File Structure: Staff Assignment 2012–13 to Current 1,269,836
2018–19 CoursesTaught18.zip (20MB; Posted 18-Nov-2019) File Structure: Courses Taught 2012–13 to Current 1,183,573
2018–19 CourseEnrollment18.zip (59MB; Posted 18-Nov-2019) File Structure: Course Enrollment FTE 2012–13 to Current 3,228,250
2018–19 ClassEnrollment18.zip (21MB; Revised 6-Jan-2020) File Structure: Class Enrollment FTE 2012–13 to Current 1,724,092
2017–18 StaffAssign17.zip (22MB; Posted 16-Jul-2018) File Structure: Staff Assignment 2012–13 to Current 1,235,706
2017–18 CoursesTaught17.zip (19MB; Posted 16-Jul-2018) File Structure: Courses Taught 2012–13 to Current 1,154,350
2017–18 CourseEnrollment17.zip (58MB; Posted 16-Jul-2018) File Structure: Course Enrollment FTE 2012–13 to Current 3,174,700
2017–18 ClassEnrollment17.zip (58MB; Posted 16-Jul-2018) File Structure: Class Enrollment FTE 2012–13 to Current 1,716,983
2016–17 StaffAssign16.zip (13MB; Posted 21-Sep-2017) File Structure: Staff Assignment 2012–13 to Current 1,229,237
2016–17 CoursesTaught16.zip (21MB; Posted 21-Sep-2017) File Structure: Courses Taught 2012–13 to Current 1,150,342
2016–17 CourseEnrollment16.zip (40MB; Revised 21-Dec-2017) File Structure: Course Enrollment FTE 2012–13 to Current 3,157,403
2016–17 ClassEnrollment16.zip (18MB; Revised 21-Dec-2017) File Structure: Class Enrollment FTE 2012–13 to Current 1,706,437
2015–16 StaffAssign15.zip (12MB; Posted 22-May-2017) File Structure: Staff Assignment 2012–13 to Current 1,155,998
2015–16 CoursesTaught15.zip (19MB; Posted 22-May-2017) File Structure: Courses Taught 2012–13 to Current 1,077,128
2015–16 CourseEnrollment15.zip (64MB; Posted 22-May-2017) File Structure: Course Enrollment FTE 2012–13 to Current 3,061,709
2015–16 ClassEnrollment15.zip (20MB; Posted 22-May-2017) File Structure: Class Enrollment FTE 2012–13 to Current 1,670,107
2014–15 StaffAssign14.zip (11MB; Posted 28-Oct-2015) File Structure: Staff Assignment 2012–13 to Current
1,142,660
2014–15 CoursesTaught14.zip (19MB; Posted 28-Oct-2015) File Structure: Courses Taught 2012–13 to Current
1,061,531
2014–15 CourseEnrollment14.zip (64MB; Posted 28-Oct-2015) File Structure: Course Enrollment FTE 2012–13 to Current
2,981,687
2014–15 ClassEnrollment14.zip (25MB; Posted 12-Feb-2016) File Structure: Class Enrollment FTE 2012–13 to Current 1,590,864
2013–14 StaffAssign13.zip (11MB; Revised 20-Aug-2015) File Structure: Staff Assignment 2012–13 to Current
1,115,612
2013–14 CoursesTaught13.zip (19MB; Revised 20-Aug-2015) File Structure: Courses Taught 2012–13 to Current
1,034,496
2013–14 CourseEnrollment13.zip (63MB; Revised 20-Aug-2015) File Structure: Course Enrollment FTE 2012–13 to Current
2,933,287
2013–14 ClassEnrollment13.zip (24MB; Posted 12-Feb-2016) File Structure: Class Enrollment FTE 2012–13 to Current
1,605,081
2012–13 StaffAssign12.zip (11MB; Revised 20-Aug-2015) File Structure: Staff Assignment 2012–13 to Current
1,107,251
2012–13 CoursesTaught12.zip (18MB; Revised 20-Aug-2015) File Structure: Courses Taught 2012–13 to Current
1,030,070
2012–13

CourseEnrollment12.zip (63MB; Revised 20-Aug-2015)

 File Structure: Course Enrollment FTE 2012–13 to Current
2,929,057
2012–13

ClassEnrollment12.zip (24MB; Posted 12-Feb-2016)

 File Structure: Class Enrollment FTE 2012–13 to Current 1,638, 658
Prior Years Downloadable Data Files

The table below includes course information (e.g., course enrollment, grade level, University of California/California State University (UC/CSU) indicator, and No Child Left Behind Act of 2001 (NCLB) core and compliant status) as well as assignment information (e.g., type of staff and time base).

Year of Data File File Structure Number of Records

Up to 2011–12

 Assignment Code File (TXT; Updated 27-Oct-2011) | DBF File Structure: Assignment Code File
1,032

2011–12

 assign11 (TXT; 123MB; Posted 05-Apr-2013) File Structure: Course Data 2010–11
1,039,972
2010–11 assign10 (TXT; 110MB; Modified 16-Mar-2012) File Structure: Course Data 2010–11
969,265

Instructions: Click on the file name you wish to download and save the file to your computer. To view the file, import and open the file in a database or spreadsheet program.

Questions:   Analysis Measurement & Accountability Reporting Division | dro@cde.ca.gov
Last Reviewed: Thursday, July 17, 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.
  • 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.