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
2012–13 staffdemo12 (TXT; 26MB; Revised 18-Dec-2013) File Structure: Staff Demographics 2012
337,582
2012–13 staffcred12 (TXT; 21MB; Posted 12-Dec-2013)

File Structure: Staff Credentials 2012

1,351,838
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