Skip to main content
California Department of Education Logo

Staff Demographic Data

Downloadable data files for staff demographics (e.g., gender, race/ethnicity, education level, and years of service for teachers, administrators, and pupil services staff).

Beginning in 2012–13, a staff credential file added to the first table below includes a credential type and authorized teaching area for credentialed staff. 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 Demographics / Staff Credentials Downloadable Data Files
Year
of
Data		 File File Structure Number
of
Records
2017-18 staffdemo17
(TXT; 35MB;
Posted 16-Jul-2018)		 File Structure: Staff Demographics 2015-16 to Current 361,718
2017-18 staffcred17
(TXT; 26MB;
Posted 16-Jul-2018)		 File Structure: Staff Credentials 2012–13 to Current 829,815
2017-18 staffschoolfte17
(TXT; 39MB;
Posted 16-Jul-2018)		 File Structure: Staff School FTE 2012–13 to Current 381,586
2016-17 staffdemo16
(TXT; 34MB;
Posted 16-Jul-2018)		 File Structure: Staff Demographics 2015-16 to Current 359,889
2016-17 staffcred16
(TXT; 26MB;
Posted 29-Nov-2017)		 File Structure: Staff Credentials 2012–13 to Current 827,222
2016-17 staffschoolfte16
(TXT; 39MB;
Posted 21-Sep-2017)		 File Structure: Staff School FTE 2012–13 to Current 378,446
2015-16 staffdemo15
(TXT; 33MB;
Posted 22-May-2017)		 File Structure: Staff Demographics 2015-16 to Current 352,599
2015-16 staffcred15
(TXT; 26MB;
Revised 18-Jul-2017)		 File Structure: Staff Credentials 2012–13 to Current 778,250
2015-16 staffschoolfte15
(TXT; 37MB;
Posted 22-May-2017)		 File Structure: Staff School FTE 2012–13 to Current 371,181
2014–15 staffdemo14
(TXT; 32MB;
Posted 28-Oct-2015)		 File Structure: Staff Demographics 2012–13 to 2014–15 346,214
2014–15 staffcred14
(TXT; 25MB;
Posted 28-Oct-2015)		 File Structure: Staff Credentials 2012–13 to Current 811,112
2014–15 staffschoolfte14
(TXT; 37MB;
Posted 28-Oct-2015)		 File Structure: Staff School FTE 2012–13 to Current 365,802
2013–14 staffdemo13
(TXT; 32MB;
Revised 20-Aug-2015)		 File Structure: Staff Demographics 2012–13 to 2014–15 336,739
2013–14 staffcred13
(TXT; 74MB;
Revised 20-Aug-2015)		 File Structure: Staff Credentials 2012–13 to Current 807,125
2013–14 staffschoolfte13
(TXT; 36MB;
Revised 20-Aug-2015)		 File Structure: Staff School FTE 2012–13 to Current 355,153
2012–13 staffdemo12
(TXT; 32MB;
Revised 20-Aug-2015)		 File Structure: Staff Demographics 2012–13 to 2014–15
 332,498
2012–13 staffcred12
(TXT; 24MB;
Revised 31-Aug-2017)

File Structure: Staff Credentials 2012–13 to Current

 781,643
2012–13 staffschoolfte12
(TXT; 36MB;
Revised 20-Aug-2015)

File Structure: Staff School FTE 2012–13 to Current

 350,813
Prior Years Downloadable Data Files

The table below includes staff demographics, such as, gender, race/ethnicity, education level, and years of service for teachers, administrators, and pupil services staff.

Year
of
Data		 File File Structure Number
of
Records
2011–12
 paif11
(TXT; 36MB;
Posted 05-Apr-2013) 		File Structure: Staff Demographics 2011
350,129
2010–11
 paif10
(TXT; 33MB;
Posted 15-Dec-2011)		 File Structure: Staff Demographics 2010
332,641

2009–10

 paif09
(TXT; 18MB;
Modified* 05-Nov-2010) 		File Structure: Staff Demographics 2009
347,046

2008–09

 paif08
(DBF; 27MB;
Modified* 02-Feb-2010) 		File Structure: Staff Demographics 2008
359,670

2007–08

 paif07
(DBF; 27MB;
Posted 15-Jul-2008)		 File Structure: Staff Demographics 2006 & 2007
363,968

2006–07

 paif06
(DBF; 27MB;
Modified* 02-Mar-2009) 		File Structure: Staff Demographics 2006 & 2007
358,307

2005–06

 paif05
(DBF; 42MB;
Posted 21-Aug-2006) 		File Structure: Staff Demographics 2005
355,489

2004–05

 paif04
(DBF; 42MB;
Modified* 21-Aug-2006) 		File Structure: Staff Demographics 1999, 2000, 2003, & 2004

353,097

2003–04

 paif03
(DBF; 24MB;
Posted 27-Jul-2004) 		File Structure: Staff Demographics 1999, 2000, 2003, & 2004

353,097

2002–03**

 paift02
(DBF; 29MB;
Posted 27-Jun-2003) 		File Structure: Staff Demographics 2001 & 2002

355,881

2001–02**

 paift01
(DBF; 29MB;
Modified* 31-Dec-2002) 		File Structure: Staff Demographics 2001 & 2002

351,644

2000–2001

 paif00
(DBF; 47MB;
Modified* 02-Aug-2001) 		File Structure: Staff Demographics 1999, 2000, 2003, & 2004

344,921

1999–2000

paif99
(DBF; 47MB;
Posted 12-Jul-2000)

File Structure: Staff Demographics 1999, 2000, 2003, & 2004

333,530

1998–99

 paif98
(DBF; 36MB;
Posted; 15-Sept-1999) 		File Structure: Staff Demographics 1997 & 1998

322,020

1997–98

paif97
(DBF; 20MB;
Posted 23-Mar-2000) 		File Structure: Staff Demographics 1997 & 1998

307,769


Files are in either a tab delimited text file or a database/spreadsheet format (.dbf). To use a file: (1) click and download; (2) from Windows Explorer, double click on the file name; (3) to view the file, open the uncompressed file (.dbf) in a database or spreadsheet program. For further instructions choose a link below or contact our office for assistance.

Special instructions for Excel and Access users

*For details on specific file modifications, refer to the File Modifications Web page.

** For 2001–02 and 2002–03, PAIF data are collected in such a way that does not allow staff data to be linked to some of the assignment data. Consequently, the "ASSIGNnn" file format was not used for these years.

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Monday, July 16, 2018