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.

Staff Demographics / Staff Credentials Downloadable Data Files

Year
of
Data

File

File Structure

Number
of
Records
2014–15 staffdemo14
(TXT; 32MB;
Posted 28-Oct-2015)
File Structure: Staff Demographics 2012–13 to Current 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 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 
Last Reviewed: Wednesday, January 27, 2016

Share this Page

Recently Posted in Demographics

  • Expulsion and Suspension Data (updated 17-Dec-2015)
    Downloadable data file containing student discipline data by ethnicity. Expulsion, in-school suspension, and out-of-school suspension data are provided.
  • Transitional Kindergarten Data (added 16-Dec-2015)
    Downloadable data files for school-level transitional kindergarten program participation data racial/ethnic designation and subgroup (i.e., gender, English learner, migrant, and socio-economically disadvantaged status).
  • File Structure: Transitional Kindergarten Data (added 16-Dec-2015)
    File structure for the downloadable data files for school-level transitional kindergarten program participation data racial/ethnic designation and subgroup (i.e., gender, English learner, migrant, and socio-economically disadvantaged status).