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
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 |
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.