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.

Publication d6235cb83aa78ead9db4 18 Official CMS & HCAI Feeds 36,530 Raw HCRIS Filings 124,311 Individual Rows Anonymized

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: