The dataset, not the dashboard, is the citable artifact this project is built around. Every table below is a direct export of what powers the charts on this site.
Built and maintained by Sudhanshu Rai, an independent researcher; not affiliated with any court, agency, or party. Descriptive measurement only — no causal claims. Not legal advice — nothing here states your legal rights or deadlines in any individual case, or reaches a conclusion about any party's compliance, liability, or wrongdoing; consult a licensed attorney about a specific matter.
Statewide inpatient competency restoration/evaluation, monthly, by facility/stage/setting. 1123 rows · 17 columns · 2017-10–2026-07 · 176 KB.
↓ Download CSV| Column | Meaning |
|---|---|
| state | Two-letter state postal abbreviation |
| period | YYYY-MM, the report's DATA month (not the report's own publish date) |
| facility | WSH / ESH / RTF / OCRP / TOTAL |
| stage | evaluation / restoration |
| setting | inpatient / jail / outpatient (the only three values that occur) |
| orders_signed | Court orders signed that month (demand) |
| orders_completed | Orders resolved that month -- admission, dismissal/withdrawal, or jail release; see washington.html's measurement notes |
| avg_days_to_completion / median_days_to_completion | Among orders completed that month |
| pct_within_deadline / pct_within_alt2 / pct_within_alt3 | Percent completed within 7 days of signature / DSHS receipt / referral -- 3 published clock-start definitions, see washington.html |
| report, source_url, source_sha | Exact source PDF, its identifying string (always "(local) " plus the filename today -- no live URL is reconstructed for WA yet), and the first 12 hex characters of its SHA-256 fingerprint |
| pdf_page | 1-indexed PHYSICAL page in that PDF (jump to this page in any reader) -- not the document's own printed page number, which can differ |
| table_ref | The report's own table label this row was read from, e.g. "Table 3" -- printed directly above the source table |
Oregon State Hospital aid-and-assist waitlist and related series, long format (one metric per row). 177 rows · 8 columns · 2021-12–2026-03 · 19 KB.
↓ Download CSV| Column | Meaning |
|---|---|
| state | Two-letter state postal abbreviation |
| period | YYYY-MM |
| metric | admits / avg_wait_days / pct_within_7day / waitlist_stock / waitlist_stock_avg_days / census_* / beds_* / contempt_fines_accrued_musd / orders_received / waitlist_count |
| value | The metric's value for that period |
| report, source_sha | Source report filename and SHA-256 fingerprint (first 12 hex characters) |
| pdf_page | 1-indexed PHYSICAL page in that PDF (jump to this page in any reader) -- not the document's own printed page number, which can differ |
| table_ref | The report's own table label this value was read from, e.g. "Table 4" -- blank for values drawn from narrative prose rather than a table |
Colorado Joint Budget Committee legislative briefing figures -- roughly annual, long format. 9 rows · 8 columns · 2022-23–2025-26 · 1 KB.
↓ Download CSV| Column | Meaning |
|---|---|
| state | Two-letter state postal abbreviation |
| period | YYYY-MM or a fiscal-year label depending on metric; blank for at least one row where the source only gives a day-count range, not a single date |
| metric | restoration_waitlist_count / avg_wait_days_restoration / decree_fines_capped_$M / decree_fines_uncapped_est_$M |
| value | The metric's value |
| as_of | The source document's own as-of date/description, verbatim |
| source, source_sha | Source document and SHA-256 fingerprint (first 12 hex characters) |
| pdf_page | 1-indexed PHYSICAL page in that PDF (jump to this page in any reader) -- not the document's own printed page number, which can differ. No table_ref column: every figure in this file comes from narrative prose, not a table -- confirmed directly against the raw source text |
Colorado federal special-master court reports -- the denser monthly Tier-1/Tier-2 series. Covers the SAME underlying population as the JBC file above, from a different institutional channel, at a much finer cadence -- do not sum values across the two files by period, they would double-count (e.g. 2023-09: JBC's restoration_waitlist_count=431 vs. this file's own Tier-1 + Tier-2 tier_waitlist_count=45+386=431 for the same month, independently confirmed). 124 rows · 9 columns · 2020-01–2026-04 · 10 KB.
↓ Download CSV| Column | Meaning |
|---|---|
| state | Two-letter state postal abbreviation |
| period | YYYY-MM |
| tier | 1 (acute, 7-day standard) or 2 (remainder, 28-day standard) |
| metric | tier_wait_days_restoration / tier_waitlist_count |
| value | The metric's value for that tier/period |
| report, source_sha | Source report filename and SHA-256 fingerprint (first 12 hex characters) |
| pdf_page | 1-indexed PHYSICAL page in that PDF (jump to this page in any reader) -- not the document's own printed page number, which can differ |
| is_multi_month_avg | For tier_wait_days_restoration rows: True if this reading is a rolling multi-month average dated to its own end month rather than a true single-month figure -- these quarterly reports' own tables mix both, and the report's own prose treats the multi-month average as its headline compliance figure, not a lesser one. False means a true single month. Always False for tier_waitlist_count, which never ships a multi-month value. As of 2026-09-12 every row in this column resolves to True or False -- no row is left blank/unconfirmed. |
Texas HHSC mental-health waiting-list reports, by security level. 24 rows · 15 columns · 2022-11–2025-08 · 3 KB.
↓ Download CSV| Column | Meaning |
|---|---|
| state | Two-letter state postal abbreviation |
| period | YYYY-MM |
| security_level | max / non_max |
| waitlist_count, avg_wait_days, removed_count | As published for that level/period -- removed_count is the number of people taken off the waitlist that quarter (admitted, or otherwise resolved), a flow metric complementing the waitlist_count stock figure |
| report, source, source_sha | Source report, its origin (a Wayback Machine capture where the live HHSC page has since changed), and the first 12 hex characters of its SHA-256 fingerprint |
| pdf_page, table_ref | 1-indexed PHYSICAL page and the report's own table label (e.g. "Table 10") that waitlist_count came from |
| pdf_page_days, table_ref_days | The SAME, for avg_wait_days specifically -- the count and avg-days figures on one row can come from two different tables a few pages apart (e.g. Table 7 vs Table 9), so each gets its own citation rather than one shared one. Both null when the row has no avg_wait_days at all |
| pdf_page_removed, table_ref_removed | The SAME, for removed_count -- a third, independently-cited table (e.g. Table 8/11) a few pages from either of the other two. Both null when the row has no removed_count at all |
California DSH Incompetent-to-Stand-Trial (IST) pending-placement figures -- irregular cadence. 27 rows · 9 columns · 2019-06–2026-05 · 2 KB.
↓ Download CSV| Column | Meaning |
|---|---|
| state | Two-letter state postal abbreviation |
| period | YYYY-MM |
| metric | ist_pending_placement |
| value | People pending placement as of that period |
| kind | annual_fy_table (year-end snapshot from a budget table) or prose_snapshot (a date mentioned in budget narrative text) |
| report, source_sha | Source document and SHA-256 fingerprint (first 12 hex characters) |
| pdf_page | 1-indexed PHYSICAL page in that PDF (jump to this page in any reader) -- not the document's own printed page number, which can differ |
| table_ref | The report's own table label, e.g. "Table 2" -- populated ONLY for kind=annual_fy_table rows. A prose_snapshot row's page can genuinely also contain an unrelated table (confirmed directly: may2024-25.pdf p.14 has both a real "Table 3: Patient Census" and, in unrelated prose elsewhere on that page, the 397-as-of-May-2024 figure this row is built from) -- citing that table for the prose figure would be false precision, so it's left blank there on purpose |
Every figure regenerates from the public source reports by code — fully reproducible. The Zenodo deposit already includes real, MIT-licensed extraction code for the frozen Washington/Oregon study (an extraction pipeline plus its own verification gate) — but this dashboard's own full 5-state codebase (adapted from that study's code, plus Colorado, Texas, and California from scratch) is a separate, not-yet-public repository. A dedicated "Build & Replicate" walkthrough page and that public release are both planned but not yet published.
Researchers, clinicians, monitors, and reporters welcome — especially if you know of more recent source reports for this state. Every correction to an already-published number is logged on the Changelog page and in this RSS feed — nothing changes silently.