Skip to main content
California Department of Education Logo

Staff Assignment and Course Data

Downloadable data files for course information (e.g., course enrollment, grade level, UC/CSU indicator, and NCLB core and compliant status) as well as assignment information (e.g., type of staff and time base).

Note that Local Educational Agencies (LEAs) are not required to submit demographic and Full Time Equivalent (FTE) information for staff that do not have Statewide Educator Identifiers (SEID). Following are examples of when this might occur:

  • Non-certificated charter school teachers.
  • Teachers delivering courses at a Regional Occupational Center.
  • College professors delivering college courses to high school students.
  • Teachers delivering online courses provided by a public or private agency.
  • New teachers who have not been issued a SEID.

Therefore course and course enrollment data will be available for these types of classes, but staff demographic and FTE data will not.

Beginning in 2012–13, staffing assignment and course data (first table below) have been re-organized and enhanced to include more detailed data about enrollment as well as information about classes that have more than one subject content area. 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: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Monday, April 24, 2023
Recently Posted in Accessing Educational Data
  • 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.