Nonprofit hospital finances (Form 990)
Revenue, expenses, assets, charity care and executive pay for nonprofit hospitals and health systems, from their IRS returns.
IRS Form 990 nonprofit hospital/health-system finances: latest filing per EIN (one row per organization, the most recent tax year with usable financial data) plus officer/key-employee compensation detail (Schedule J) across all tax years available. Two files, not unioned — filings and officers are different grains (one row per org vs. one row per org-person-year) that don't share a row shape.
Nonprofit system margins and balance sheets. Competitor context for public operators. Municipal credit.
- Officer compensation covers 1,695 of 18,829 organizations.
- Seven NTEE codes loaded today; hospice, rehabilitation and mental health codes are in production.
- Rows
- 140,512 across 2 files (18,829 filings + 121,683 officer rows).
- Product cadence
- Monthly, as new filings post
- Lag
- A year or more after tax year end
- Lookback shipped
- Latest filing per organization (tax years 2023 and 2024); officer compensation across all available years
- Backfill available
- Prior tax years per organization on request
- Vintage
- 2024 (max tax year observed for both files at export time).
- Tables
- 3
- Licence
- $500 per month per firm, or inside the suite
Where every row comes from.
| Source | Source cadence | History |
|---|---|---|
| IRS Form 990 e-file XML via ProPublica Nonprofit Explorer | Annual, as filings post | E-filed returns from tax year 2011 |
| IRS Exempt Organizations master file | Monthly | Current universe and NTEE codes |
Dictionary source line: IRS Form 990 e-filed data, via ProPublica Nonprofit Explorer + IRS Exempt Organizations Master File (EIN universe/NTEE codes) + IRS 990 e-File XML.
3 tables, three meta columns each.
Every table carries _dataset, _vintage and _exported_at in addition to the columns in the dictionary.
| Table | Snowflake path | Columns | Rows |
|---|---|---|---|
| nonprofit_finances_filings | HEALTHPARSE_DATA.NONPROFIT_FINANCES.NONPROFIT_FINANCES_FILINGS | 15 | 18,829 rows |
| nonprofit_finances_filings_history | HEALTHPARSE_DATA.NONPROFIT_FINANCES.NONPROFIT_FINANCES_FILINGS_HISTORY | see dictionary | |
| nonprofit_finances_officers | HEALTHPARSE_DATA.NONPROFIT_FINANCES.NONPROFIT_FINANCES_OFFICERS | 10 | 121,683 rows |
Nonprofit Finances (Form 990)
Three real rows pulled from the production tables on 2026-09-10. The query is recorded next to the rows in the site source.
| Organization | Tax year | Revenue | Charity care |
|---|---|---|---|
| Mass General Brigham (MA) | 2023 | $22.7B | $111M |
| Mayo Clinic Group Return (MN) | 2023 | $14.0B | $37.8M |
| Northwestern Memorial Healthcare (IL) | 2023 | $9.15B | $67.5M |
Evaluate Nonprofit hospital finances (Form 990)
Free California sample on the marketplaces. 30-day full-table evaluation on request.