Dev Mode. Emulators used.
← Data Archive

Finance

District money — SPS budget books, the state F-195 (budgets) and F-196 (actuals) series from OSPI SAFS, lookup tables for the accounting codes, and the joined cross-year files the Finance Dashboard is built on.

SPS Budget Books & Purple Books

(46 files)

Adopted budgets and the supporting “purple books” for Seattle Public Schools. Older years were scraped from archive.org; see notes at the bottom of this section for the URLs used.

How these were sourced
  • 2019–present: seattleschools.org/departments/finance/budget/
  • 2016–2018: seattleschools.org/cms/One.aspx?portalId=627&pageId=4236325
  • 2015: sps.ss8.sharpschool.com/cms/one.aspx?portalId=627&pageId=14984
  • 2014–2015 has a broken-link patch; checking different months will find it
  • 2007–2014: seattleschools.org/modules/cms/pages.phtml?sessionid=&pageid=225568
  • 2004–2005: blue book era — one PDF per school via archive.org
  • 2002–2003: seattleschools.org/area/finance/budget/index.html

State F-195 Budgets (raw)

(12 files)

Annual budget databases as Microsoft Access (.accdb / .mdb) from OSPI SAFS — one per fiscal year, covering every district in the state.

State F-195 Budgets (processed)

(159 files)

Same F-195 data split into per-section AVRO files (activity, object, program, revenue, etc.), one file per section per year. Easier to load than the source .accdb.

2024-2025 (14 sections)
2023-2024 (14 sections)
2022-2023 (15 sections)
2021-2022 (15 sections)
2020-2021 (15 sections)
2019-2020 (15 sections)
2018-2019 (15 sections)
2017-2018 (14 sections)
2016-2017 (14 sections)
2015-2016 (14 sections)
2014-2015 (14 sections)

State F-196 Actuals (raw)

(58 files)

Annual actual-spending databases (and supporting CSVs/dictionaries) from OSPI SAFS.

State F-196 Actuals (processed)

(97 files)

F-196 split into per-section AVRO files, one file per section per year.

2023-2024 (8 sections)
2022-2023 (7 sections)
2021-2022 (1 sections)
2020-2021 (8 sections)
2019-2022 (7 sections)
2019-2020 (8 sections)
2018-2019 (6 sections)
2017-2018 (10 sections)
2016-2017 (10 sections)
2015-2016 (10 sections)
2014-2015 (10 sections)
2013-2014 (12 sections)

F-19x joined cross-year files

(7 files)

Single AVRO per section concatenated across all available years — the easiest starting point for multi-year analysis.

OSPI domain / lookup tables

(14 files)

Lookup tables for the OSPI accounting codes used in F-195/F-196 — activity, object, program, revenue, county, fund, NCES, school, etc.

Joined per-school analysis CSVs

(3 files)

Convenience CSVs joining 2015–2025 data at the school level. Useful for quick spreadsheet work without building a join yourself.

Looking for interactive views of this data? See the Finance Dashboard.