Methodology, Reconciliation Pipeline & Official .gov Source Inventory
Hospital Ledger deterministically reconciles 36,530 raw CMS Form 2552-10 Medicare cost-report filings into 36,066 annualized hospital-years across 6,670 US hospitals and 321 parent health systems, joined to CMS PECOS ownership graphs, Care Compare quality scores, and CalHHS HCAI 2026 Q2 financial and SB 1953 seismic building tables.
1. Deterministic CMS CCN + IRS EIN Spine & Outlier Quarantine Summary
Raw hospital regulatory filings exhibit recurring structural traps: leading-zero truncation on California (05xxxx) and New England (01xxxx to 09xxxx) 6-character Medicare CCNs, mid-year M&A ownership changes that split a single calendar year into partial stub filings, PECOS psychiatric/rehab subunit codes that fail naive acute-hospital joins, and extreme Worksheet G-3 accounting adjustments on tiny revenue denominators. Hospital Ledger resolves facility identity along a deterministic CMS 6-character CCN + PECOS Enrollment ID spine (with IRS EIN and Schedule H community-benefit context for tax-exempt 501(c)(3) non-profits) without probabilistic fuzzy guessing. Table 1 records every reconciliation step verified in publication d6235cb83aa78ead9db4.
| Reconciliation Stage | Verified Count | Deterministic Rule Applied |
|---|---|---|
| Raw CMS Form 2552-10 HCRIS Filings (2019 to 2024) | 36,530 | Consolidated to 36,066 annualized facility-year records |
| Leading-Zero 6-Character CCN Protection | 12,286 | Strict 6-char text preservation across HCRIS, Care Compare, HAC, PECOS, and HCAI crosswalks |
| Split M&A Stub Periods Annualized | 448 | Day-weighted consolidation and 365-day flow annualization across mid-year ownership transfers |
| Extreme Margin Outliers Quarantined | 2,303 | Flagged and excluded from sector/state median calculations while preserved in audit logs |
| PECOS Organizational vs. Individual Ownership | 22,637 org / 124,311 anon | Retained multi-hop corporate/investor/REIT links (524 multi-hop); converted natural persons to counts |
| California HCAI Crosswalk & Seismic Join | 412 hosp / 4,707 bldgs | Joined 9-digit HCAI OSHPD IDs across QFUR (397), ED (322), and SB 1953 seismic (361) |
2. Automated Quality Gate Checks
| Invariant Check | Status | Audit Evidence |
|---|---|---|
| Entity Primary Key | PASS | Actual: 0 (Expected: 0) |
| Valid 6-Char CCN Format | PASS | Actual: 0 (Expected: 0) |
| Zero Unpadded Leading Zero CCNs | PASS | Actual: 0 (Expected: 0) |
| Bounded Operating Margins | PASS | Actual: 0 (Expected: 0) |
| Bounded Labor And Charity Shares | PASS | Actual: 0 (Expected: 0) |
| Zero Micro Stubs In Facts | PASS | Actual: 0 (Expected: 0) |
| Nonnegative Entity Counts | PASS | Actual: 0 (Expected: 0) |
| California CCN Leading Zero Coverage | PASS | Actual: 0 (Expected: 0) |
| Non CA HCAI Strictly Null | PASS | Actual: 0 (Expected: 0) |
| Bounded HCAI T4Q Margins And Markups | PASS | Actual: 0 (Expected: 0) |
3. Complete Official .gov & .ca.gov Source Inventory (18 Feeds)
Every upstream government dataset is captured directly from official CMS (data.cms.gov) and California Health and Human Services (data.chhs.ca.gov) endpoints with cryptographic SHA-256 verification.
| Source ID & Agency | Dataset Title | Ingested Rows | SHA-256 Prefix & Official URL |
|---|---|---|---|
| hcris_2019 Centers for Medicare & Medicaid Services (CMS) | Hospital Provider Cost Report (2019) | 6,125 |
26be9187e5acbfbd... https://data.cms.gov/sites/default/files/2026-09/93e2ef4e-7e38-41b8-... |
| hcris_2020 Centers for Medicare & Medicaid Services (CMS) | Hospital Provider Cost Report (2020) | 6,060 |
1c9eb532587ed02e... https://data.cms.gov/sites/default/files/2026-09/3751e76b-c99e-48d0-... |
| hcris_2021 Centers for Medicare & Medicaid Services (CMS) | Hospital Provider Cost Report (2021) | 6,058 |
9ad1c3655dab084e... https://data.cms.gov/sites/default/files/2026-10/8b21076c-309e-4eff-... |
| hcris_2022 Centers for Medicare & Medicaid Services (CMS) | Hospital Provider Cost Report (2022) | 6,069 |
4633eaa53eed156b... https://data.cms.gov/sites/default/files/2026-10/1be4ec08-6d9d-4e05-... |
| hcris_2023 Centers for Medicare & Medicaid Services (CMS) | Hospital Provider Cost Report (2023) | 6,109 |
0412fb0050b58260... https://data.cms.gov/sites/default/files/2026-10/e48e1326-aeeb-4ad4-... |
| hcris_2024 Centers for Medicare & Medicaid Services (CMS) | Hospital Provider Cost Report (2024) | 6,109 |
bde32414133a7b4a... https://data.cms.gov/sites/default/files/2026-10/46b1f5a0-a9dd-4431-... |
| pecos_enrollments Centers for Medicare & Medicaid Services (CMS) | Hospital Enrollments (PECOS) | 9,138 |
5f02975f05a043cc... https://data.cms.gov/sites/default/files/2026-10/961708ac-2136-43cb-... |
| pecos_owners Centers for Medicare & Medicaid Services (CMS) | Hospital All Owners (PECOS) | 146,948 |
c940d8760f7403af... https://data.cms.gov/sites/default/files/2026-10/2517a8c1-44a2-4620-... |
| cms_general_info Centers for Medicare & Medicaid Services (CMS Care Compare) | Hospital General Information | 5,419 |
f874f09fef895a1c... https://data.cms.gov/provider-data/sites/default/files/resources/893... |
| cms_hac_fy2026 Centers for Medicare & Medicaid Services (CMS Care Compare) | Fiscal Year (FY) 2026 Hospital-Acquired Condition (HAC) Reduction Program | 3,055 |
5e152d9872e6f3a0... https://data.cms.gov/provider-data/sites/default/files/resources/74b... |
| hcai_qfur_2026q2 California Department of Health Care Access and Information (HCAI) | Hospital Quarterly Financial & Utilization Report (2026 Q2) | 436 |
0fb324aa767c33c9... https://data.chhs.ca.gov/dataset/22026f7b-198a-4708-b1ab-a4aa14885c6... |
| hcai_qfur_2026q1 California Department of Health Care Access and Information (HCAI) | Hospital Quarterly Financial & Utilization Report (2026 Q1) | 436 |
c5899ade6dd0869a... https://data.chhs.ca.gov/dataset/22026f7b-198a-4708-b1ab-a4aa14885c6... |
| hcai_qfur_2025q4 California Department of Health Care Access and Information (HCAI) | Hospital Quarterly Financial & Utilization Report (2025 Q4) | 437 |
91b5af5125dda8ff... https://data.chhs.ca.gov/dataset/22026f7b-198a-4708-b1ab-a4aa14885c6... |
| hcai_qfur_2025q3 California Department of Health Care Access and Information (HCAI) | Hospital Quarterly Financial & Utilization Report (2025 Q3) | 438 |
35aa463c1ac39ea6... https://data.chhs.ca.gov/dataset/22026f7b-198a-4708-b1ab-a4aa14885c6... |
| hcai_seismic_ratings California Department of Health Care Access and Information (HCAI) | Seismic Ratings and Collapse Probabilities of California Hospitals | 4,708 |
1d65b270cc309ddf... https://data.chhs.ca.gov/dataset/257fb4cd-7687-41b5-8ae9-0bc6e29aa28... |
| hcai_seismic_extensions California Department of Health Care Access and Information (HCAI) | Seismic Deadline Extensions Granted for California Hospitals | 4,710 |
1219c74bd23c4986... https://data.chhs.ca.gov/dataset/e961df15-50b8-4217-9628-b696ea121ee... |
| hcai_facility_crosswalk California Health and Human Services (CHHS / CDPH / HCAI) | Licensed and Certified Healthcare Facility Crosswalk (ELMS-ASPEN-OSHPD) | 15,553 |
99488d02787202b4... https://data.chhs.ca.gov/dataset/e89100fd-1f1d-4a37-8205-d588aa42e5a... |
| hcai_ed_encounters California Department of Health Care Access and Information (HCAI) | Hospital Emergency Department Encounters by Facility | 9,114 |
08d2a0f1cc8bc76e... https://data.chhs.ca.gov/dataset/5b5ec987-692c-4b63-a6cb-ef97db518ee... |
4. Statutory Cost Reports vs. Audited GAAP, Known Limitations & Citation Template
Update Cadence: Hospital Ledger refreshes quarterly following CMS HCRIS quarterly public-use releases, CalHHS HCAI QFUR quarterly filings, annual CMS FY Hospital-Acquired Condition Reduction Program updates, and HCAI SB 1953 / AB 869 seismic registry updates.
Statutory HCRIS vs. Consolidated GAAP & IRS Form 990 Context: Medicare Cost Reports (CMS Form 2552-10) follow federal statutory cost-finding rules rather than consolidated audited GAAP financial statements (excluding parent-level investment portfolios, non-hospital insurance subsidiaries, and certain physician foundation eliminations). Tax-exempt 501(c)(3) non-profits also file IRS Form 990 Schedule H community-benefit disclosures at the EIN level, which can encompass broader system entities than an individual Medicare CCN campus. PECOS ownership percentages reflect CMS enrollment disclosures and do not capture debt covenants or minority limited-partner commitments below 5%.
5. Public-Data Architecture, Institutional Partnerships & Related Meru AI Ledgers
Hospital Ledger applies shared Meru AI entity-resolution and cryptographic source-provenance standards across federal and state healthcare filings:
- Meru AI for Healthcare Practice & Clinical Operations
- Healthcare Price Transparency & Pharmaceutical Patent-Cliff Crosswalk Guide
- Meru AI Healthcare Data Architecture & AI Consulting Services
- Custom Health-System Data Integration & Research Partnerships
- Cross-Agency Entity Resolution Across CMS, IRS, and State Identifiers
- Citation-Grade Public-Data Architecture and SHA-256 Provenance
- Call Report Ledger · FDIC Bank & BHC State Balance-Sheet Directories
- Drug Spend Ledger · Medicare Part D, Part B & Medicaid Rx Spending
- MedTech Ledger · FDA 510(k), PMA, Recalls & MAUDE Adverse Events
- Clinical Trial Ledger · ClinicalTrials.gov Interventional Registry
- Help Elders · California Nursing Home Citations & Ownership
- Evidence for Zero · California Traffic Collision & Corridor Safety Records
- All 18 Meru AI Public-Data Platforms