OpenMPSC Data
datasetOpen dataset of Michigan Public Service Commission regulatory proceedings, 1987–2026, with a public REST API at openmpsc.com
OpenMPSC is an open, structured, continuously updated dataset of regulatory proceedings from the Michigan Public Service Commission (MPSC), spanning November 1987 through the present. The static snapshot in this repository accompanies the paper OpenMPSC: An Open Dataset of Michigan Public Service Commission Regulatory Proceedings; a daily-refreshed live archive (with full PDFs and extracted text) is available at openmpsc.com.
Snapshot
- Coverage: 1987-11-12 to 2026-04-29
- License: CC BY 4.0
- Distribution: per-table CSVs compressed with
zstd -19
Headline numbers
| Cases | 6,136 |
| Filings | 164,865 |
| Orders | 12,685 |
| Public comments | 12,309 |
| Hearings | 2,635 |
| Party records | 12,308 |
| Commission meetings | 672 |
| Total PDF pages | 3,812,492 |
| Total PDF storage (live) | ~149 GB |
| Extracted plain text (live) | ~5.4 GB |
PDFs and full text are not redistributed in the static snapshot; they are retrievable from the public API.
Filing taxonomy
Filings are classified into a 12-category, 86-subcategory regulatory taxonomy using an LLM pipeline. Categories cover applications, testimony, briefs, orders, public comments, party filings, and procedural records. The classification labels live alongside each filing row and are intended as research aids rather than official MPSC categorization.
Tables
cases.csv.zst— one row per case (number, subject, industry, type, status, dates, lead company, child counts)filings.csv.zst— 164,865 filings with type, description, filer, classification, page count, file sizeorders.csv.zst— 12,685 orders with order number, title, date, file sizecomments.csv.zst— 12,309 public comments with commenter name, anonymity flag, text, timestamphearings.csv.zst— 2,635 hearings with type, date, virtual flag, cancellation flagparties.csv.zst— 12,308 party records with role and attorney firmmeetings.csv.zst— 672 commission meeting documents with dates, page count, YouTube URLtaxonomy_categories.csv.zst,taxonomy_subcategories.csv.zst,case_types.csv.zst,summary_stats.csv.zst
Live archive and API
For continuously updated access — including full PDFs, extracted plain text, full-text search, and case-level joins — use the public REST API and web interface at openmpsc.com.