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

Recently Posted in Demographics


  • File Structure: CALPADS UPC Source File 2014–15 (added 12-Apr-2016)
    File structure for the CALPADS Unduplicated Pupil Count (UPC) Source File for 2014–15.
  • CALPADS UPC Source File 2014–15 (added 12-Apr-2016)
    Downloadable files pertaining to the Unduplicated Pupil Count (UPC) of free or reduced price meal (FRPM) eligibility, English learner (EL), and foster youth data from the California Longitudinal Pupil Achievement Data System (CALPADS).