← Data Archive
Staffing (S-275)
The S-275 personnel report from OSPI lists every certificated and classified employee assignment in every district, per year. Raw files are Access databases (one per fiscal year); the processed AVROs split them into employee / assignment / report tables suitable for joining. See the Staffing Dashboard for interactive views.
Processed S-275 tables (AVRO)
(5 files)
Normalized cross-year tables. assignment.avro × employee.avro × report.avro is enough to reconstruct most staffing analyses.
Raw S-275 personnel databases
(13 files)
Annual Access databases as published by OSPI SAFS.
- 2013-2014_Final_S-275_Personnel_Database.accdb
- 2014-2015_Final_S-275_Personnel_Database.accdb
- 2015-2016_Final_S-275_Personnel_Database.accdb
- 2016-2017_Final_S-275_Personnel_Database.accdb
- 2017-2018_Final_S-275_Personnel_Database.accdb
- 2018-2019_Final_S-275_Personnel_Database.accdb
- 2019-2020_Final_S-275_Personnel_Database.accdb
- 2020-2021_Final_S-275_Personnel_Database.accdb
- 2021-2022_Final_S-275_Personnel_Database.accdb
- 2022-2023_Final_S-275_Personnel_Database.accdb
- 2023-2024_Final_S-275_Personnel_Database.accdb
- 2023-2024_Preliminary_S-275_Personnel_Database.accdb
- 2024-2025_Final_S-275_Personnel_Database.accdb