Skip to content
Printer-friendly version

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.

Staff Demographics / Staff Credentials Downloadable Data Files

Year of Data

File

File Structure

Number of Records
2014–15 StaffDemo14 (Coming Soon) File Structure: Staff Demographics 2012–13 to Current NA
2014–15 StaffCred14 (Coming Soon) File Structure: Staff Credentials 2012–13 to Current NA
2014–15 StaffSchoolFTE14 (Coming Soon) File Structure: Staff School FTE 2012–13 to Current NA
2013–14 StaffDemo13 (TXT; 32MB; Revised 20-Aug-2015) File Structure: Staff Demographics 2012–13 to Current 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 Current
332,498
2012–13 staffcred12 (TXT; 73MB; Revised 20-Aug-2015)

File Structure: Staff Credentials 2012–13 to Current

781,798
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 200102 and 200203, 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 
Download Free Readers