State quarterly hospital financials
Quarterly revenue, expense, income, volumes and payer mix that hospitals file with their state regulator, starting with California, matched to the federal facility ID.
Medicare cost reports (HCRIS) are annual and arrive several quarters after a hospital's year end. A handful of states require every licensed hospital to file quarterly financial and utilization reports and publish them in bulk. This product normalizes those filings, California first, into one table keyed on the state facility ID and matched to the hospital's CCN so it joins to every other Healthparse product.
California's Department of Health Care Access and Information (HCAI) publishes the Hospital Quarterly Financial and Utilization Report for about 440 hospitals each quarter: gross and net patient revenue, deductions, capitation, operating revenue and expense, operating and net income, bad debt, charity care, a balance sheet from 2024, beds, patient days, discharges, outpatient and emergency visits, and Medicare and Medi-Cal days, discharges and net revenue. Hospitals file within 45 days of quarter end; HCAI posts about four months after quarter end.
The series ties out. For the 193 California hospitals whose fiscal year is the calendar year, the sum of the four 2024 quarters divided by the HCRIS annual total revenues has a median of 0.999 (interquartile range 0.977 to 1.002; 165 of 193 within ±10%). This is the same hospital reporting the same year, two to three quarters earlier.
Hospital financials two to three quarters ahead of HCRIS. The four quarters tie to the annual cost report at a median ratio of 0.999.
- California only today. Filter report_type = 'quarter'; 2015 and 2016 rows are rolling annual.
- Balance sheet fields start in 2024.
- Rows
- 20,189 rows at the 2026-09-08 export: 16,629 single-quarter rows from 2016 Q4 to 2026 Q1 (about 440 filers per quarter) and 3,560 rolling four-quarter rows for 2015–2016. 481 facilities.
- Product cadence
- Quarterly, when the state posts
- Lag
- About four months
- Lookback shipped
- 2015 to 2026 Q1, 481 California facilities
- Backfill available
- Maryland (monthly), Nevada, Washington, Oregon and Massachusetts verified as next adapters
- Vintage
- derived at export from the latest period end loaded.
- Tables
- 1
- Licence
- $500 per month per firm, or inside the suite
Where every row comes from.
| Source | Source cadence | History |
|---|---|---|
| California HCAI Hospital Quarterly Financial and Utilization Report (data.chhs.ca.gov) | Quarterly, about 120 days after quarter end | 2015 onward; single quarters from 2016 Q4 |
| HCAI facility crosswalk and HCRIS name match for the CCN | With each load | 88.8% of rows and 98.9% of revenue matched |
Dictionary source line: HCAI Hospital Quarterly Financial and Utilization Report files on data.chhs.ca.gov (CKAN), quarterly and, for 2015–2016, rolling four-quarter files; HCAI's ELMS-ASPEN-OSHPD facility crosswalk for CCN; name and city match against HCRIS where the crosswalk has no entry.
1 table, 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 |
|---|---|---|---|
| state_hospital_quarterly_financials | HEALTHPARSE_DATA.STATE_HOSPITAL_QUARTERLY_FINANCIALS.STATE_HOSPITAL_QUARTERLY_FINANCIALS | 23 | 20,189 rows at the 2026-09-08 export: 16,629 single-quarter rows from 2016 Q4 to 2026 Q1 |
State Quarterly Hospital Financials
Three real rows pulled from the production tables on 2026-09-10. The query is recorded next to the rows in the site source.
| Hospital | Quarter | Net patient revenue | Net income |
|---|---|---|---|
| STANFORD HEALTH CARE (CA) | 2026 Q1 | $2.22B | $181M |
| UCSF MEDICAL CENTER (CA) | 2026 Q1 | $1.99B | $151M |
| UC SAN DIEGO MEDICAL CENTER (CA) | 2026 Q1 | $1.21B | $149M |
Evaluate State quarterly hospital financials
Free California sample on the marketplaces. 30-day full-table evaluation on request.