Provider-to-operator crosswalk
Which company owns each facility, and its stock ticker, with a monthly history of ownership.
The entity dimension for the catalogue. Every other product here is keyed on a CMS Certification Number (CCN) or an NPI — a *facility*. This one resolves a facility to the *company* that owns it, and where that company is publicly traded, to a ticker. It is what turns facility-level rows into company-level analysis.
Two files:
1. operator_crosswalk — the current mapping. One row per (CCN, operator). 2. operator_crosswalk_history — point-in-time observations, one row per (CCN, operator, monthly CMS snapshot), so a facility can be attributed to the operator that held it in a given month rather than to its present owner.
The entity model that makes every other table company-level. CMS publishes no ticker anywhere.
- The CCN to owner-name link is CMS's. The owner-name to ticker link is Healthparse's; both are exported so a buyer can filter to the evidence they trust.
- Rows
- 4,412 crosswalk rows covering 4,299 distinct CCNs (2026-08-29 export, rebuilt the same day; the history file holds 113,074 rows).
- Product cadence
- Monthly, on the CMS ownership release
- Lag
- Weeks
- Lookback shipped
- Current mapping plus monthly history from 2022-11
- Backfill available
- None before CMS's first published snapshot
- Vintage
- See dictionary
- Tables
- 2
- Licence
- Inside the Hospital Capital bundle and the suite
Where every row comes from.
| Source | Source cadence | History |
|---|---|---|
| CMS Hospital All Owners and Hospital Enrollments (data.cms.gov) | Monthly | Snapshots from 2022-11 |
| CMS SNF, home health and hospice All Owners files | Monthly | Snapshots from 2022-11 |
| Healthparse operator registry (name patterns to operator and ticker) | With each rebuild | match_method records which link is CMS's and which is ours |
Dictionary source line: CMS Hospital All Owners + Hospital Enrollments (data.cms.gov, monthly); existing SNF/HHA/hospice All Owners rows; CMS HCRIS cost report provider names as a fallback.
2 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 |
|---|---|---|---|
| operator_crosswalk | HEALTHPARSE_DATA.OPERATOR_CROSSWALK.OPERATOR_CROSSWALK | 15 | |
| operator_crosswalk_history | HEALTHPARSE_DATA.OPERATOR_CROSSWALK.OPERATOR_CROSSWALK_HISTORY | 4 |
Operator Crosswalk
Three real rows pulled from the production tables on 2026-09-10. The query is recorded next to the rows in the site source.
| CCN | Operator | Ticker | Type |
|---|---|---|---|
| 020017 | HCA Healthcare, Inc. | HCA | hospital |
| 030030 | Tenet Healthcare Corporation | THC | hospital |
| 014000 | Universal Health Services, Inc. | UHS | hospital |
Evaluate Provider-to-operator crosswalk
Free California sample on the marketplaces. 30-day full-table evaluation on request.