SAFS Data Files

This is a discrete webpage provided for knowledgeable users with the capability to work with large amounts of data in Access and/or Excel format. 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.

 

End of Year Financial Data (F-196)

For further information about the End of Year Financial Data (F-196), email Mike Sando or call 360-725-6304.

Access Databases

The following files were created in Microsoft Access and contain the raw data reflected in the F-196 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.

CSV Files

  • Due to the increasing amount of data required in order to report school building level financial records, Microsoft Access is no longer a feasible long term option to hold end of year fiscal data.
  • As an alternative option for our heavy data users, we are now providing this data in CSV format.
  • The tables contained below include all three years since OSPI began collecting data at the school building level.

 

The following Excel CSV files contain the raw data reflected in the F-196 for the year 2023-24.

The following Excel CSV files contain the raw data reflected in the F-196 for the year 2022-23.

The following Excel CSV files contain the raw data reflected in the F-196. They contain data for the past three years – 2019-20, 2020-21, and 2021-22. The user will need to sort for each year’s data sets.

ESSER Funding Summary

The following file summarizes the ESSER Funding reported on the F196. For more information on this file, email Gideon Belmaker or Michelle Matakas.

Budget Data (F-195)

For further information about Budget Data (F-195), email Lee Wlazlak or call 360-725-6305.

The following files were created in Microsoft Access and contain the raw data reflected in the F-195 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.

The following files contain the raw data reflected in the F-195F files. Each projection year is in the Excel format. 

Personnel Reporting Data (S-275)

The S-275 school personnel data provided is complete with the exception of:

  • Social Security numbers and birthdates, which are exempt from disclosure per RCW 42.56.230; 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.
  • Preliminary S-275 school personnel data is available around February of the school year (for example, February 2024 for the 2023-24 school year).
  • Final S-275 school personnel data is available around November after the end of the school year (for example, November 2024 for the 2023-24 school year).
  • For further information about the personnel database email Ross Bunda or call 360-725-6308.

Access Databases

The following files were created in Microsoft Access and contain the raw data reflected in the F-196 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.

Adobe PDF Data 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.

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

Apportionment Data Files

For further information about the extract data email Jackie McDonald or call 360-725-6307.

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.

Levy History Data File
  • The following file contain levy data submitted by districts and ESD.
  • This data is used in the F-780 Levy Reports and in completing Property Tax Levy Collection data and can be found on our Election Results page but are organized year by year. 
  • This data is a flat file starting from 2010.
  • For further information about the levy data email Melissa Jarmon or call 360-725-6315.
Enrollment Data Files (P223/P223H)

For further information about the Enrollment data file, email Becky McLean or call 360-725-6306.

The following Excel files summarize the student enrollment data at the Local Education Agencies (LEA) Level on the P-223 and P-223H forms.

The following Excel files provides the Special Education enrollment percentages by LEAs.