OSPI Homepage   background
 
 

This is a discrete website provided for knowledgeable  users with the capability  to work with large amounts of data  in Access and/or Excel.   (Several of these databases are too large for Excel).    Each dataset requires the user to have firm knowledge of the data fields reported and their interrelationships to capably work with the data files.  OSPI does not have the resources to, and cannot, provide support for users that do not have this prerequisite knowledge.
 
Databases
Access Database Files
The following files were created in Microsoft Access and contain the raw data reflected in the F-195, F-196, and S-275 files. Each database has been zipped to conserve space. The user will need to unzip the files and open the database with the Access program.
Financial Services Data Base--Microsoft Access FY 2015-2016 F196 - End of Year Financial Data (Zipped) (Updated 12/22/16) (For further information contact Ramona Garner 360-725-6304) 
Financial Services Data Base--Microsoft Access FY 2014-2015 F196 - End of Year Financial Data (Zipped) (Updated 1/28/16) (For further information contact Ramona Garner 360-725-6304) 
Financial Services Data Base--Microsoft Access FY 2013-14 F196 - End of Year Financial Data (Zipped) (Updated 1/5/15)  (For further information contact Ramona Garner 360-725-6304) 
Financial Services Data Base--Microsoft Access FY 2016-2017 F195 Budget (Posted 1/13/17) (For further information contact Mike Dooley 360-725-6305)
Financial Services Data - Microsoft Access Multiple Year F-196 Item Numbers (Posted 5/24/12) (For further information contact Ramona Garner 360-725-6304).
   
Preliminary S-275 school personnel data is available around February of the school year (for example, February 2017 for the 2016-17 school year). Final S-275 school personnel data is available around November after the end of the school year (for example, November 2016 for the 2015-16 school year).

The S-275 school personnel data provided is complete with the exception of:
*Social Security numbers, which are exempt from disclosure per RCW 42.56.250(3); and
*A very limited number of personnel records, where personal information of crime victims is protected (Chapter 40.24 RCW) and where the safety of individuals may be endangered.
2016-2017 Preliminary S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated February 2, 2017
2015-2016 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated December 6, 2016
2014-2015 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated December 9, 2015
2013-2014 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated December 11, 2014
2012-2013 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated November 4, 2013
2011-2012 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated October 31, 2012
2010-2011 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
2009-2010 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
2008-2009 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
2007-2008 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
2006-2007 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
2005-2006 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
2004-2005 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
2003-2004 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
2002-2003 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
2001-2002 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
2000-2001 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
1999-2000 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
1998-1999 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
1997-1998 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
1996-1997 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012
1995-1996 Final S-275 Personnel Database (For more information, contact Ross Bunda, 360-725-6308) Updated September 5, 2012

Adobe PDF Files

The following Adobe PDF data files are simplified versions of the S-275 data on Washington State school personnel for each school year, sorted by employing school district and the person's last name. You can also use the Adobe edit feature "Find" (Ctrl+F) to search for individual records. For example, you can find records for teacher John Doe with certificate number 123456A by searching for "Doe, John" or "doe, john" or "doe, j", or "123456A", and so on.

Washington State School Personnel - School Year 2016-2017 (pdf) Updated February 2, 2017
Washington State School Personnel - School Year 2015-2016 (pdf) Updated December 6, 2016
Washington State School Personnel - School Year 2014-2015 (pdf) Updated December 9, 2015
Washington State School Personnel - School Year 2013-2014 (pdf) Updated December 11, 2014
Washington State School Personnel - School Year 2012-2013 (pdf) Updated November 4, 2013
Washington State School Personnel - School Year 2011-2012 (pdf) Updated October 31, 2012
Washington State School Personnel - School Year 2010-2011 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 2009-2010 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 2008-2009 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 2007-2008 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 2006-2007 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 2005-2006 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 2004-2005 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 2003-2004 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 2002-2003 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 2001-2002 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 2000-2001 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 1999-2000 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 1998-1999 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 1997-1998 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 1996-1997 (pdf) Added September 4, 2012
Washington State School Personnel - School Year 1995-1996 (pdf) Added September 4, 2012
Washington State School Personnel - School Years 1995-1996 through 2016-2017 (pdf) Updated February 2, 2017
WARNING: This is a MASSIVE file! 312MB in size! Right-click on the link and choose "Save As..." to save it to your computer.

Excel Files

The following Microsoft Excel spreadsheet files are simplified versions of the S-275 data containing records of Washington state school personnel. Because of the large number of records yearly, each school year's list is grouped into three worksheets, by employing district:

  • District names beginning with A-G
  • District names beginning with H-P
  • District names beginning with Q-Z

An individual's records can be found more easily by using Excel's search features, such as 'filter' or 'find.'

Washington State School Personnel - School Year 2016-2017 (For further information, contact Ross Bunda, 360-725-6308) Updated February 2, 2017
Washington State School Personnel - School Year 2015-2016 (For further information, contact Ross Bunda, 360-725-6308) Updated December 6, 2016
Washington State School Personnel - School Year 2014-2015 (For further information, contact Ross Bunda, 360-725-6308) Updated December 9, 2015
Washington State School Personnel - School Year 2013-2014 (For further information, contact Ross Bunda, 360-725-6308) Updated December 11, 2014
Washington State School Personnel - School Year 2012-2013 (For further information, contact Ross Bunda, 360-725-6308) Updated November 4, 2013
Washington State School Personnel - School Year 2011-2012 (For further information, contact Ross Bunda, 360-725-6308) Updated October 31, 2012
Washington State School Personnel - School Year 2010-2011 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 2009-2010 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 2008-2009 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 2007-2008 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 2006-2007 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 2005-2006 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 2004-2005 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 2003-2004 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 2002-2003 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 2001-2002 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 2000-2001 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 1999-2000 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 1998-1999 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 1997-1998 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 1996-1997 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012
Washington State School Personnel - School Year 1995-1996 (For further information, contact Ross Bunda, 360-725-6308) Updated September 6, 2012

The following files were created in Microsoft Excel and contain the raw data reported on OSPI Enrollment forms P-223 and P-223H. The file has been zipped to conserve space.

Current Enrollment Data --Microsoft Excel SY 2011-2012                             (For further information contact Becky McLean 360-725-6306)
Final Enrollment Data --Microsoft Excel SY 2010-2011(Updated 01/02/12) (For further information contact Becky McLean 360-725-6306)
Final Enrollment Data --Microsoft Excel SY 2009-2010(Updated 12/06/10) (For further information contact Becky McLean 360-725-6306)
Final Enrollment Data --Microsoft Excel SY 2008-2009(Updated 12/02/09) (For further information contact Becky McLean 360-725-6306)
Final Enrollment Data --Microsoft Excel SY 2007-2008 (Updated 12/05/08) (For further information contact Becky McLean 360-725-6306)

The following files were created in Microsoft Excel and contain the raw extract data reported on all Apportionment reports. The file has been zipped to conserve space.

Current Extract - School Year 2016-2017 (For further information contact Melissa Jarmon 360-725-6307) Updated April 24, 2017
Final Extract - School Year 2015-2016 (For further information contact Melissa Jarmon 360-725-6307) Updated January 25, 2017
Final Extract - School Year 2014-2015 (For further information contact Melissa Jarmon 360-725-6307) Updated January 22, 2016
Final Extract - School Year 2013-2014 (For further information contact Melissa Jarmon 360-725-6307) Updated January 29, 2015
Final Extract - School Year 2012-2013 (For further information contact Melissa Jarmon 360-725-6307) Updated August 11, 2014
Final Extract - School Year 2011-2012 (For further information contact Melissa Jarmon 360-725-6307) Updated August 11, 2014

Staffing Unit Comparison - Impact of I-1351 (Updated 11/04/14)

Vader Report (Posted 6/09/11)

  •  [Updated - February 23, 2017]

     
    Director, School Apportionment and Financial Services: T.J. Kelly (360)725-6301
    Associate Director, School Apportionment and Financial Services: Vacant (360)725-6300
    Supervisor, SD/ESD Budget : Mike Dooley (360)725-6305
    Supervisor, SD/ESD Annual Financial Statements : Ramona Garner (360)725-6304
    Supervisor, SD/ESD Accounting : Paul Stone (360)725-6303
    Supervisor, Enrollment : Becky McLean (360)725-6306
    Supervisor, Apportionment Payments, Basic Ed Funding : Melissa Jarmon (360)725-6307
    Supervisor, Personnel Reporting : Ross Bunda (360)725-6308
    Apportionment Advances/Redirections : Mike Dooley (360)725-6305
     
    Office of Superintendent of Public Instruction
    School Apportionment & Financial Services
    Old Capitol Building, PO Box 47200
    Olympia, WA 98504-7200
    Phone:(360)725-6300    FAX:(360)664-3683    TDD:(360)664-3631
     
    Web content in PDF format requires the Free Adobe PDF Reader
    Apportionment & Financial Services Home Page
    Go to Top


  • OSPI
    Old Capitol Building, P.O. Box 47200, Olympia, WA 98504-7200
    (360) 725-6000       TTY (360) 664-3631      webmaster@k12.wa.us