on this page

OpenMPSC Data

dataset

Open dataset of Michigan Public Service Commission regulatory proceedings, 1987–2026, with a public REST API at openmpsc.com

period: 2026-present
tech:
Legal Informatics

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

Cases6,136
Filings164,865
Orders12,685
Public comments12,309
Hearings2,635
Party records12,308
Commission meetings672
Total PDF pages3,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 size
  • orders.csv.zst — 12,685 orders with order number, title, date, file size
  • comments.csv.zst — 12,309 public comments with commenter name, anonymity flag, text, timestamp
  • hearings.csv.zst — 2,635 hearings with type, date, virtual flag, cancellation flag
  • parties.csv.zst — 12,308 party records with role and attorney firm
  • meetings.csv.zst — 672 commission meeting documents with dates, page count, YouTube URL
  • taxonomy_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.

on this page