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. Accessible Alternate Version (AAV) of the Staff Data - Entity Relationship Diagram

Staff Demographics / Staff Credentials Downloadable Data Files

Year
of
Data

File

File Structure

Number
of
Records
2015-16 staffdemo15
(TXT; 33MB;
Posted 22-May-2017)
File Structure: Staff Demographics 2015-16 to Current 352,599
2015-16 staffcred15
(TXT; 24MB;
Posted 22-May-2017)
File Structure: Staff Credentials 2012–13 to Current 778,250
2015-16 staffschoolfte15
(TXT; 37MB;
Posted 22-May-2017)
File Structure: Staff School FTE 2012–13 to Current 371,181
2014–15 staffdemo14
(TXT; 32MB;
Posted 28-Oct-2015)
File Structure: Staff Demographics 2012–13 to 2014–15 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 2014–15 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 2014–15
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: Monday, May 22, 2017
Recently Posted in Demographics
  • File Structure: Staff Demographics Record (added 22-May-2017)
    File structure for the staff demographics record, which includes demographic and full-time equivalent (FTE) data for K-12 public education certificated teachers, administrators, and pupil services personnel reported as employed on Information Day.
  • Dropouts by Race & Gender (updated 11-Apr-2017)
    Downloadable data files for grade seven through twelve dropouts and enrollment by race/ethnic designation and gender by school.
  • Graduates by Ethnicity and School (updated 11-Apr-2017)
    Downloadable data files for graduates by racial/ethnic group and school.
  • Graduates Meeting UC/CSU Entrance Requirements (updated 11-Apr-2017)
    Downloadable data files for graduates meeting University of California/California State University (UC/CSU) entrance requirements.
  • Graduates by Race & Gender (updated 11-Apr-2017)
    Downloadable data files for graduates and graduates meeting University of California (UC)/California State University (CSU) entrance requirements by race/ethnic designation and gender by school.

  • Cohort Outcome Data (updated 11-Apr-2017)
    California Longitudinal Pupil Achievement Data System (CALPADS) cohort outcome data reported by race/ethnicity, program participation, and gender.