Data Archive

A mirror of publicly available data about Seattle Public Schools and Washington education in general — about 17,645 files in total, hosted in Google Cloud Storage. Everything below is downloadable directly; the curated dashboards on this site are built on top of it.

Finance

386 files

SPS budget books, state F-195 budgets, F-196 actuals, OSPI domain/lookup tables, and the joined cross-year financial datasets that feed the Finance Dashboard.

Enrollment (P-223)

167 files

Monthly P-223 enrollment counts — SPS PDFs, OSPI statewide PDFs, processed monthly CSVs, and the SAFS historical enrollment workbooks.

Staffing (S-275)

18 files

Per-year S-275 personnel databases from OSPI plus normalized AVRO tables (assignments, employees, reports).

Assessment

4 files

Report Card assessment data plus per-school joined CSVs covering 2015–2025.

Transportation (STARS)

15,475 files

STARS pupil transportation reports — Key Performance Indicators, Quarterly District Detail, Efficiency, Efficiency Review, and Operations Allocation — for 331 districts across 9 school years. Use the district chooser to drill in.

OSPI OData (Socrata mirror)

1,257 files

Snapshot of OSPI's public Socrata datasets as AVRO + schema pairs. Useful when you need fields that don't fit into the curated sections above.

School Quality Status System (SQSS)

6 files

Multi-year SQSS AVRO files covering school accountability indicators across Washington.

Public Records Requests

10 files

Documents released through Public Records Requests — primarily the SOFG (Seattle Operations + Finance Group) installments and accompanying redaction logs.

About this archive

Files live in the public Cloud Storage bucket gs://sps-btn-data-all-data. Raw artifacts (PDFs, Word docs, Access databases, AVRO from Socrata) are under raw/; cleaned and joined outputs sit under processed/. The listing on each subpage is generated at build time from a snapshot (all_data.txt) of the bucket. If something is missing or stale, run gsutil ls -r against the bucket and refresh that file.