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

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

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

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

File Structure: Class Enrollment FTE 201213 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
Recently Posted in Accessing Educational Data
  • DataQuest Update, Issue #25 (added 24-Sep-2025)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
  • CSPP Enrollment by Residence ZIP Code (added 19-Sep-2025)
    This page contains a collection of CSPP Enrollment by Residence ZIP Code datasets.