trove
Reference tools for underused public healthcare data. Open-source parsers, Parquet/JSON bundles, and Claude Code skills for FDA novel drug approvals (NMEs) and U.S. nonprofit hospital reporting (CMS HCRIS Worksheet S-10 + IRS Form 990 Schedule H). Live at troveproject.com — MIT-licensed.
Try it
What this is
trove builds open-source lookup tools, parsers, and Claude Code skills on top of public-domain healthcare datasets that are widely cited but rarely usable in their raw form. CMS publishes 100,000-row long-skinny CSVs. The IRS publishes 990s as XML in bulk ZIPs. The FDA scatters drug-approval reviews across hundreds of PDF directories. trove does the parsing, joining, and packaging so the data is browsable and queryable.
Two areas live in v1:
/drugs — FDA drug approvals
Look up any FDA novel drug approval from 2021–2024 (218 drugs). v0.2 ingests both FDA regulatory centers: CDER (192 NMEs and novel antibody BLAs from the annual Novel Drug Approvals lists) plus CBER (26 cell and gene therapy approvals — Lenmeldy, Casgevy, Lyfgenia, Beqvez, Hemgenix, Roctavian, Adstiladrin, etc.). Each row carries application number, sponsor, approval date, indication, a regulatory_center column, and a deep link to either the drugs@FDA application overview (CDER) or the per-product FDA page (CBER) where every approval-package document lives. Companion Claude skill fda-analyst reads those PDFs at query time.
Sources: FDA's annual Novel Drug Approvals curated lists (CDER); Approved Cellular and Gene Therapy Products page (CBER); drugs@FDA database. US government work, public domain.
/hospitals — hospital reporting (CMS + IRS)
A lookup tool for related charity-care reporting fields that nonprofit U.S. hospitals file with two different regulators: CMS (Worksheet S-10 of the Medicare Cost Report) and the IRS (Form 990 Schedule H Part I line 7a). Both lines are intended to capture the cost of care provided to patients who couldn't pay, but the rules and scope diverge enough that the two numbers can legitimately differ. Search any of 1,295 nonprofit hospital systems for tax year 2022 and see the two filings side-by-side, with period-alignment context, a home-county Social Vulnerability Index proxy, and a deep link to the actual 990 on ProPublica.
For tax year 2022, the funnel: 1,334 systems matched at the EIN level → 1,295 computable → 372 period-aligned within 1 month → 228 also material (both filings ≥ $500K). Among those 228, the median absolute proportional difference is 25%.
Full data: artifacts/community_benefit_gap_2022.csv · Method: artifacts/community_benefit_gap_2022_summary.md.
Reproduce
git clone https://github.com/cbetz/trove
cd trove && uv sync --all-packages
# /hospitals dataset:
uv run python scripts/build_gap_dataset.py
# /drugs dataset:
uv run python scripts/build_fda_index.py
What's in the box
Hospital reporting area:
hcris — CMS Medicare Cost Reports (form 2552-10) parser with a 44-variable semantic dictionary. Raw HCRIS ships as headerless long-skinny CSVs; this turns them into tidy DataFrames and partitioned Parquet.form990 — IRS Form 990 Schedule H parser. Bulk-XML download, index reader, and 19 fields per filing including Part I 7a–k community benefit amounts and Part III bad debt.crosswalk — CCN ↔ EIN crosswalk (3,523 hospitals, 2,385 EINs). Bundled from Community Benefit Insight.analytics — composed queries. community_benefit_gap() is the cross-form charity-care difference primitive.sdoh — Social Determinants of Health enrichments. Ships CDC Social Vulnerability Index 2022 county-level (public domain — included in the public bundles) and UW Area Deprivation Index county aggregation (local-only — UW's terms are non-sublicensable).
FDA drug approvals area:
