CMS HCRIS
Hospital cost reports
The public-use cost report summary (beds, discharges, revenue, cost) plus full report headers and worksheet numbers, FY2019–2025.
Published by CMS HCRIS
Finest detail facility
Tables 3
How we use this · on 1 desk
“Which rural hospitals are under the most money pressure?”
Where you'll see it
- Health Markets: Facility costs, Hospitals under pressure
- AI & Spreadsheets: at Level 3, link it into Excel or Google Sheets, download it, or ask your AI assistant about it
What we added
- Turned into readable revenue, costs, and margins, year over year
- Set next to each hospital's Medicare penalties and quality scores
Cost report summary (PUF)
Sample of 25 rows out of about 18,081
· 18 columns
| id | rpt_rec_num | provider_ccn | fy_year | fy_begin | fy_end | hospital_name | state | zip | rural_urban | beds | medicare_days | medicaid_days | total_days | total_charges | net_patient_revenue | net_income | cost_to_charge |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12168 | 695374 | 341317 | 2021 | 2020-10-01 | 2020-12-31 | LIFEBRITE COMMUNITY HOPITAL OF STOK | NC | 27016 | U | 25 | 139.0 | 12.0 | 414.0 | 7872713.0 | -659945.0 | -4485126.0 | 0.421393 |
| 12169 | 695541 | 520011 | 2021 | 2020-10-01 | 2020-12-31 | LAKEVIEW MEDICAL CENTER OF RICE LAKE | WI | 54868- | R | 40 | 738.0 | 25.0 | 1618.0 | 76869564.0 | 42423135.0 | 6112118.0 | 0.414683 |
| 12170 | 695846 | 520037 | 2021 | 2020-10-01 | 2020-12-31 | MARSHFIELD MEDICAL CENTER | WI | 54449 | R | 189 | 4425.0 | 1286.0 | 17238.0 | 381681665.0 | 157466675.0 | -2200738.0 | 0.379718 |
| 12171 | 696323 | 340141 | 2021 | 2020-10-01 | 2021-01-31 | NEW HANOVER REGIONAL MEDICAL CENTER | NC | 28402 | R | 684 | 22952.0 | 11713.0 | 68179.0 | 1394032087.0 | 390044245.0 | -16912668.0 | 0.23731 |
| 12172 | 696374 | 150045 | 2021 | 2020-10-01 | 2020-12-31 | PARKVIEW - DEKALB HEALTH | IN | 46706- | R | 57 | 387.0 | 17.0 | 1230.0 | 52405183.0 | 18120552.0 | 8474436.0 | 0.229397 |
| 12173 | 697563 | 230118 | 2021 | 2020-10-01 | 2021-01-29 | MCLAREN THUMB REGION | MI | 48413- | R | 31 | 409.0 | 16.0 | 1542.0 | 27823048.0 | 13651448.0 | 837469.0 | 0.436147 |
| 12174 | 699530 | 050660 | 2021 | 2020-10-01 | 2020-12-31 | USC NORRIS CANCER HOSPITAL | CA | 90033- | U | 60 | 864.0 | 461.0 | 3057.0 | 282073249.0 | 83708153.0 | 17848899.0 | No data |
| 12175 | 699531 | 050696 | 2021 | 2020-10-01 | 2020-12-31 | KECK HOSPITAL OF USC | CA | 90033- | R | 301 | 6259.0 | 1245.0 | 19091.0 | 1045111066.0 | 309507314.0 | -26845280.0 | 0.286685 |
| 12176 | 699807 | 190146 | 2021 | 2020-10-01 | 2020-12-31 | EAST JEFFERSON GENERAL HOSPITAL | LA | 70006 | U | 250 | 2709.0 | 44.0 | 11637.0 | 277324092.0 | 69131409.0 | 72710170.0 | 0.231227 |
| 12177 | 700312 | 364064 | 2021 | 2020-11-21 | 2021-03-31 | SUNRISEVISTA HEALTH AND WELLNESS | OH | 44714 | U | 72 | 157.0 | 18.0 | 1736.0 | 9354451.0 | 1049764.0 | 600287.0 | No data |
| 12178 | 705263 | 030146 | 2021 | 2020-10-29 | 2020-12-31 | HONORHEALTH SONORAN CROSSING MED CTR | AZ | 85085 | U | 70 | 173.0 | 179.0 | 899.0 | 53888998.0 | 4780758.0 | -6909003.0 | 0.387433 |
| 12179 | 705524 | 520107 | 2021 | 2021-01-01 | 2021-06-30 | HOLY FAMILY MEMORIAL INC | WI | 54221 | R | 58 | 1034.0 | 166.0 | 3337.0 | 132638830.0 | -1042999888.0 | -1103385474.0 | 0.40199 |
| 12180 | 705766 | 340050 | 2021 | 2020-10-01 | 2021-06-30 | S.E. REGL MEDICAL CENTER | NC | 28358-3075 | R | 258 | 12567.0 | 9165.0 | 46949.0 | 650230157.0 | 198089205.0 | 34350465.0 | 0.285609 |
| 12181 | 705860 | 271324 | 2021 | 2021-01-01 | 2021-05-31 | PONDERA MEDICAL CENTER | MT | 59425 | R | 20 | 185.0 | 7.0 | 298.0 | 7158974.0 | 5747505.0 | 1484832.0 | 0.858349 |
| 12182 | 706877 | 413025 | 2021 | 2021-01-01 | 2021-03-31 | REHAB HOSP OF RI | RI | 02896 | U | 82 | 344.0 | No data | 877.0 | 3876235.0 | 923338.0 | -114650.0 | No data |
| 12183 | 707155 | 670300 | 2021 | 2021-03-24 | 2021-06-30 | METHODIST MIDLOTHIAN MEDICAL CENTER | TX | 76065 | U | 46 | 217.0 | No data | 727.0 | 34225853.0 | 9733491.0 | -7433395.0 | 0.492093 |
| 12184 | 707180 | 050136 | 2021 | 2021-01-01 | 2021-06-30 | PETALUMA VALLEY HOSPITAL | CA | 94954 | U | 80 | 1808.0 | No data | 4522.0 | 224081671.0 | 39716740.0 | -1720639.0 | 0.162886 |
| 12185 | 707392 | 490084 | 2021 | 2021-01-01 | 2021-06-30 | VCU HEALTH TAPPAHANNOCK HOSPITAL | VA | 22560 | R | 67 | 1423.0 | 61.0 | 3054.0 | 92821338.0 | 27715335.0 | -1486965.0 | 0.263796 |
| 12186 | 707917 | 050124 | 2021 | 2021-01-01 | 2021-06-30 | VERDUGO HILLS HOSPITAL | CA | 91208 | U | 116 | 4364.0 | 696.0 | 9937.0 | 374702191.0 | 75723363.0 | -3538461.0 | 0.239906 |
| 12187 | 707962 | 141337 | 2021 | 2021-05-01 | 2021-06-30 | OSF SAINT CLARE MEDICAL CENTER | IL | 61356 | R | 25 | 112.0 | 1.0 | 190.0 | 17843751.0 | 5599508.0 | 942031.0 | 0.462993 |
| 12188 | 709803 | 420026 | 2021 | 2020-10-01 | 2021-07-31 | PROVIDENCE HOSPITAL | SC | 29204 | U | 332 | 8863.0 | 351.0 | 24423.0 | 718238906.0 | 167090473.0 | -14551162.0 | 0.188029 |
| 12189 | 709810 | 454152 | 2021 | 2020-12-31 | 2021-05-31 | CANYON CREEK HOSPITAL | TX | 76502 | U | 17 | 149.0 | No data | 2332.0 | 4910339.0 | 1050657.0 | -4623723.0 | No data |
| 12190 | 709892 | 101993 | 2021 | 2020-10-01 | 2021-09-30 | DAYSTAR INC. | FL | 33330-1616 | No data | No data | No data | No data | No data | No data | No data | No data | No data |
| 12191 | 710010 | 100029 | 2021 | 2021-06-01 | 2021-07-31 | NORTH SHORE MEDICAL CENTER AND FMC C | FL | 33150-2098 | U | 748 | 2691.0 | 2094.0 | 17964.0 | 609728644.0 | 58733629.0 | 1765034.0 | 0.084108 |
| 12192 | 710053 | 100183 | 2021 | 2021-01-01 | 2021-07-31 | CORAL GABLES HOSPITAL | FL | 33134 | U | 245 | 3540.0 | 658.0 | 14554.0 | 742114825.0 | 74767192.0 | 8854482.0 | 0.083025 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing