SAFS Data Files
This is a discrete website provided for knowledgeable users with the capability to work with large amounts of data in SQL, 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.
- Access 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 2020-2021 F196 - End of Year Financial Data (Posted 12/8/21)
- F-196 Item Number Dictionary 2020-2021 (Updated 12/14/21)
- Financial Services Data Base--Microsoft Access FY 2019-2020 F196 - End of Year Financial Data (Updated 1/13/21)
- F-196 Item Number Dictionary 2019-2020 (Posted 1/7/21)
- Financial Services Data Base--Microsoft Access FY 2018-2019 F196 - End of Year Financial Data (Posted 12/4/19)
- F-196 Item Number Dictionary 2018-2019 (Posted 12/4/19)
- Financial Services Data Base--Microsoft Access FY 2017-2018 F196 - End of Year Financial Data (Posted 12/12/18)
- Financial Services Data Base--Microsoft Access FY 2016-2017 F196 - End of Year Financial Data (Posted 12/28/17)
- Financial Services Data Base--Microsoft Access FY 2015-2016 F196 - End of Year Financial Data (Updated 12/22/16)
- Financial Services Data Base--Microsoft Access FY 2014-2015 F196 - End of Year Financial Data) (Updated 1/28/16)
- Financial Services Data Base--Microsoft Access FY 2013-14 F196 - End of Year Financial Data (Updated 1/5/15)
For further information about the end of year financial data email Mike Sando or call 360-725-6304.
- Financial Services Data Base--Microsoft Access FY 2023-2024 F195 Budget (Updated 12/4/23)
- Financial Services Data Base--Microsoft Access FY 2022-2023 F195 Budget (Posted 10/13/22)
- Financial Services Data Base--Microsoft Access FY 2021-2022 F195 Budget (Posted 10/11/21)
- Financial Services Data Base--Microsoft Access FY 2020-2021 F195 Budget (Posted 12/8/20)
- Financial Services Data Base--Microsoft Access FY 2019-2020 F195 Budget (Posted 10/29/19)
- Financial Services Data Base--Microsoft Access FY 2018-2019 F195 Budget (Updated 2/7/19)
- Financial Services Data Base--Microsoft Access FY 2017-2018 F195 Budget (Updated 1/30/18)
- Financial Services Data Base--Microsoft Access FY 2016-2017 F195 Budget (Reposted 3/6/18)
- Financial Services Data Base--Microsoft Access FY 2015-2016 F195 Budget (Reposted 3/6/18)
- Financial Services Data Base--Microsoft Access FY 2014-2015 F195 Budget (Reposted 3/6/18)
For further information about budget data email Lee Wlazlak or call 360-725-6305.
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 2022 for the 2021-22 school year). Final S-275 school personnel data is available around November after the end of the school year (for example, November 2022 for the 2021-22 school year).
- 2022-2023 Final S-275 Personnel Database (Posted October 31, 2023)
- 2021-2022 Final S-275 Personnel Database (Posted December 14, 2022)
- 2020-2021 Final S-275 Personnel Database (Posted December 3, 2021)
- 2019-2020 Final S-275 Personnel Database (Updated December 29, 2020)
- 2018-2019 Final S-275 Personnel Database
- 2017-2018 Final S-275 Personnel Database
- 2016-2017 Final S-275 Personnel Database
- 2015-2016 Final S-275 Personnel Database
- 2014-2015 Final S-275 Personnel Database
- 2013-2014 Final S-275 Personnel Database
For further information about the personnel database email Ross Bunda or call 360-725-6308.
- Financial Services Data Base--Microsoft Access FY 2020-2021 F196 - End of Year Financial Data (Posted 12/8/21)
- 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 2022-2023 (Updated October 31, 2023)
- Washington State School Personnel - School Year 2021-2022 (Updated, December 14, 2022)
- Washington State School Personnel - School Year 2020-2021 (Updated January 5, 2022)
- Washington State School Personnel - School Year 2019-2020 (Updated December 29, 2020)
- Washington State School Personnel - School Year 2018-2019 (Posted November 8, 2019)
- Washington State School Personnel - School Year 2017-2018 (Posted December 17, 2018)
- Washington State School Personnel - School Year 2016-2017 (Updated January 25, 2018)
- Washington State School Personnel - School Year 2015-2016 (Updated December 6, 2016)
- Washington State School Personnel - School Year 2014-2015 (Updated December 9, 2015)
- Washington State School Personnel - School Year 2013-2014 (Updated December 11, 2014)
- 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 2022-2023 (Updated October 31, 2023)
- Washington State School Personnel - School Year 2021-2022 (Updated December 14, 2022)
- Washington State School Personnel - School Year 2020-2021 (Updated January 5, 2022)
- Washington State School Personnel - School Year 2019-2020 (Updated December 29, 2020)
- Washington State School Personnel - School Year 2018-2019
- Washington State School Personnel - School Year 2017-2018
- Washington State School Personnel - School Year 2016-2017
- Washington State School Personnel - School Year 2015-2016
- Washington State School Personnel - School Year 2014-2015
- Washington State School Personnel - School Year 2013-2014
For further information about the state school personnel data email Ross Bunda or call 360-725-6308.
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 2023-2024 (Updated November 22, 2023)
- Extract - School Year 2022-2023 (Updated June 6, 2023)
- Final Extract - School Year 2021-2022
- Final Extract - School Year 2020-2021
- Final Extract - School Year 2019-2020
- Final Extract - School Year 2018-2019
- Final Extract - School Year 2017-2018
- Final Extract - School Year 2016-2017
- Final Extract - School Year 2015-2016
- Final Extract - School Year 2014-2015
- Final Extract - School Year 2013-2014
For further information about the extract data email Melissa Jarmon or call 360-725-6307.
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. These are also found on our Election Results page but are organized year by year and this data is a flat file starting from 2010.
Levy Election History Data updated through November 2023 elections.
For further information about the levy data email Melissa Jarmon or call 360-725-6307.
The following files provide the Actual General Fund Expenditures from the F196 - End of Year Financial data collection:
For further information about the extract data email Mike Sando or call 360-725-6304.
- CSV Files - End of Fiscal Year Data
-
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 2022-23.
- Actuals Capital Project Revenues
- Actuals Child General Fund Expenditures
- Actuals Debt Service Revenues
- Actuals General Fund Expenditures
- Actuals General Fund Revenues
- Actuals Item Numbers
- Actuals Revenues and Expenditures
- Actuals Transportation Vehicle Revenues
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.
- Actuals Capital Project Revenues
- Actuals Child General Fund Expenditures
- Actuals Debt Service Revenues
- Actuals General Fund Expenditures
- Actuals General Fund Revenues
- Actuals Item Numbers
- Actuals Revenues and Expenditures
- Actuals Transportation Vehicle Revenues
For further information about the end of year financial data, email Mike Sando or call 360-725-6304.