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 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).
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.
Last Reviewed: Monday, April 24, 2023
Trending in Accessing Educational Data
Recently Posted in Accessing Educational Data
No items posted in the last 60 days.