• Facebook
  • OSPI on Twitter
  • OSPI Medium
  • OSPI LinkedIn
  • OSPI YouTube
  • OSPI on Flickr
  • Subscribe to OSPI GovDelivery

You are here

Home » SAFS Database Files

SAFS Database Files

Contact Information

School Apportionment

360-725-6300
TTY:
360-664-3631
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


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.

Preliminary S-275 school personnel data is available around February of the school year (for example, February 2019 for the 2018-19 school year). Final S-275 school personnel data is available around November after the end of the school year (for example, November 2018 for the 2017-18 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.

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.

The following Adobe PDF data files are non-ADA compliant versions of the reports 1801 Certificated and Classified for the 2016-17 school year and later. ADA compliant versions of these reports will be forthcoming.

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

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.