This data set contains the Centers for Medicare & Medicaid Services (CMS) annual update to the Utah Hospital Cost Report Public Use File (Hospital Cost Report PUF) with data for 2015. The PUF is organized at the hospital-level and includes select facility characteristics, utilization measures, cost and charges by cost center (in total and for Medicare), Medicare settlement data, and financial statement data.
This dataset has the following 128 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
Provider CCN | provider_ccn | number | 460054 464013 462005 460003 460021 view top 100 |
Hospital Name | hospital_name | text | CACHE VALLEY HOSPITAL SALT LAKE CITY BEHAVIORAL HEALTH MILFORD VALLEY HEALTHCARE SERVICES NORTHERN UTAH REHABILITATION HOSPITA OGDEN REGIONAL MEDICAL CENTER view top 100 |
Street Address | street_address | text | 2380 NORTH 400 EAST 8TH AVENUE C STREET 11925 S STATE STREET 1303 NORTH MAIN 331 NORTH 400 WEST view top 100 |
City | city | text | SALT LAKE CITY MURRAY OREM PROVO BOUNTIFUL view top 100 |
State Code | state_code | text | UT view top 100 |
Zip Code | zip_code | number | 84341 84107 84057 84088 84405 view top 100 |
County | county | text | SALT LAKE UTAH CACHE DAVIS WEBER view top 100 |
Medicare CBSA Number | medicare_cbsa_number | number | 41620 99946 39340 36260 30860 view top 100 |
Rural Versus Urban | rural_versus_urban | text | U R NA view top 100 |
CCN Facility Type | ccn_facility_type | text | STH CAH PH LTCH CH view top 100 |
Provider Type | provider_type | number | 2 4 1 3 5 view top 100 |
Type of Control | type_of_control | number | 2 4 9 10 1 view top 100 |
Fiscal Year Begin Date | fiscal_year_begin_date | calendar_date | 2015-01-01T00:00:00.000 2015-07-01T00:00:00.000 2015-09-01T00:00:00.000 2014-10-01T00:00:00.000 2015-02-01T00:00:00.000 view top 100 |
Fiscal Year End Date | fiscal_year_end_date | calendar_date | 2015-12-31T00:00:00.000 2016-06-30T00:00:00.000 2016-08-31T00:00:00.000 2016-01-31T00:00:00.000 2015-09-30T00:00:00.000 view top 100 |
FTE - Employees on Payroll | fte_employees_on_payroll | number | 149.45 354.97 2334.57 96.84 207.78 view top 100 |
Number of Interns and Residents (FTE) | number_of_interns_and | number | 359.95 8.71 0.04 72.94 21 view top 100 |
Total Days Title V | total_days_title_v | text | view top 100 |
Total Days Title XVIII | total_days_title_xviii | number | 5915 798 3114 6480 2438 view top 100 |
Total Days Title XIX | total_days_title_xix | number | 231 500 3626 1172 531 view top 100 |
Total Days (V + XVIII + XIX + Unknown) | total_days_v_xviii_xix_unknown | number | 5939 109040 916 8148 21088 view top 100 |
Number of Beds | number_of_beds | number | 25 40 18 49 22 view top 100 |
Total Bed Days Available | total_bed_days_available | number | 6570 17885 9150 14965 5840 view top 100 |
Total Discharges Title V | total_discharges_title_v | text | view top 100 |
Total Discharges Title XVIII | total_discharges_title_xviii | number | 703 97 862 194 354 view top 100 |
Total Discharges Title XIX | total_discharges_title_xix | number | 17 61 840 346 1375 view top 100 |
Total Discharges (V + XVIII + XIX + Unknown) | total_discharges_v_xviii | number | 556 3204 308 1662 14954 view top 100 |
Total Days Title V + Total for all Subproviders | total_days_title_v_total | text | view top 100 |
Total Days Title XVIII + Total for all Subproviders | total_days_title_xviii_total | number | 4836 5915 798 25003 3120 view top 100 |
Total Days Title XIX + Total for all Subproviders | total_days_title_xix_total | number | 2253 1471 500 3626 1172 view top 100 |
Total Days (V + XVIII + XIX + Unknown) + Total for all Subprovid | total_days_v_xviii_xix_unknown_1 | number | 10543 5644 109040 128519 164774 view top 100 |
Number of Beds + Total for all Subproviders | number_of_beds_total_for | number | 25 18 40 22 36 view top 100 |
Total Bed Days Available + Total for all Subproviders | total_bed_days_available_1 | number | 6570 9125 14965 13140 17885 view top 100 |
Total Discharges Title V + Total for all Subproviders | total_discharges_title_v_1 | text | view top 100 |
Total Discharges Title XVIII + Total for all Subproviders | total_discharges_title_xviii_1 | number | 97 535 862 194 354 view top 100 |
Total Discharges Title XIX + Total for all Subproviders | total_discharges_title_xix_1 | number | 61 17 154 840 1080 view top 100 |
Total Discharges (V + XVIII + XIX + Unknown) + Total for all Sub | total_discharges_v_xviii_1 | number | 556 308 14512 15958 1662 view top 100 |
Hospital Total Days Title V For Adults & Peds | hospital_total_days_title | text | view top 100 |
Hospital Total Days Title XVIII For Adults & Peds | hospital_total_days_title_1 | number | 5915 798 2014 428 197 view top 100 |
Hospital Total Days Title XIX For Adults & Peds | hospital_total_days_title_2 | number | 579 1990 513 1947 129 view top 100 |
Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Pe | hospital_total_days_v_xviii | number | 5644 109040 2793 5189 77702 view top 100 |
Hospital Number of Beds For Adults & Peds | hospital_number_of_beds_for | number | 25 20 18 40 41 view top 100 |
Hospital Total Bed Days Available For Adults & Peds | hospital_total_bed_days | number | 6570 14965 14640 9150 30295 view top 100 |
Hospital Total Discharges Title V For Adults & Peds | hospital_total_discharges | text | view top 100 |
Hospital Total Discharges Title XVIII For Adults & Peds | hospital_total_discharges_1 | number | 703 97 862 194 354 view top 100 |
Hospital Total Discharges Title XIX For Adults & Peds | hospital_total_discharges_2 | number | 17 61 840 346 1375 view top 100 |
Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adult | hospital_total_discharges_3 | number | 556 3204 308 1662 14954 view top 100 |
Cost of Charity Care | cost_of_charity_care | number | 793322 1580211 162284 190318 446886 view top 100 |
Total Bad Debt Expense | total_bad_debt_expense | number | 2711158 2488780 42437447 2064881 1702049 view top 100 |
Cost of Uncompensated Care | cost_of_uncompensated_care | number | 427410 16369591 1533347 11993659 20362600 view top 100 |
Total Unreimbursed and Uncompensated Care | total_unreimbursed_and | number | 427410 16369591 5430380 534307 1711038 view top 100 |
Total Salaries From Worksheet A | total_salaries_from_worksheet | number | 4870174 7032590 13237581 25298004 8294996 view top 100 |
Overhead Non-Salary Costs | overhead_non_salary_costs | number | 79960846 8029903 6012936 40687935 13113337 view top 100 |
Depreciation Cost | depreciation_cost | number | 442580 725494 61998883 1633508 11020311 view top 100 |
Total Costs | total_costs | number | 74294816 6944334 50125627 10168899 8152858 view top 100 |
Inpatient Total Charges | inpatient_total_charges | number | 72054037 76676135 156455389 1121642868 300190588 view top 100 |
Outpatient Total Charges | outpatient_total_charges | number | 585 27659740 41926328 85222800 575020132 view top 100 |
Combined Outpatient + Inpatient Total Charges | combined_outpatient_inpatient | number | 24869008 72054037 689887619 99502980 2990243483 view top 100 |
Wage-Related Costs (Core) | wage_related_costs_core | number | 175280939 43300202 13960686 6931432 2899094 view top 100 |
Wage-Related Costs (RHC/FQHC) | wage_related_costs_rhc_fqhc | number | 118871 160032 view top 100 |
Total Salaries (adjusted) | total_salaries_adjusted | number | 7032590 13237581 20302246 8171302 7840652 view top 100 |
Contract Labor | contract_labor | number | 368752 429816 186058 363198 593808 view top 100 |
Wage Related Costs for Part - A Teaching Physicians | wage_related_costs_for_part | number | 14156 22734 23465 39916 53395 view top 100 |
Wage Related Costs for Interns and Residents | wage_related_costs_for_interns | number | 311951 441294 530140 6556589 view top 100 |
Cash on Hand and in Banks | cash_on_hand_and_in_banks | number | 9667 3554606 4550 11700 7023302 view top 100 |
Temporary Investments | temporary_investments | number | 495224 6312508 8169894 16185947 80640071 view top 100 |
Notes Receivable | notes_receivable | number | 141317 1254730 view top 100 |
Accounts Receivable | accounts_receivable | number | 2612252 12310154 13383182 5672285 5348587 view top 100 |
Less: Allowances for Uncollectible Notes and Accounts Receivable | less_allowances_for | number | -2516090 -1922000 -2148394 -4352451 -2439000 view top 100 |
Inventory | inventory | number | 4281947 497507 8631819 170286 1621566 view top 100 |
Prepaid Expenses | prepaid_expenses | number | 54829 159538 124744 28993 3356 view top 100 |
Other Current Assets | other_current_assets | number | 4650 -113137 1703142 627566 1316051 view top 100 |
Total Current Assets | total_current_assets | number | 13050017 2327157 11649505 7006026 14656399 view top 100 |
Land | land | number | 2037360 13067409 155971 28823 505714 view top 100 |
Land Improvements | land_improvements | number | 811477 195160 5481424 1174225 415098 view top 100 |
Buildings | buildings | number | 8854186 51604122 91782490 1036997 22112920 view top 100 |
Leasehold Improvements | leasehold_improvements | number | 28429372 26697300 221802 1268270 30389152 view top 100 |
Fixed Equipment | fixed_equipment | number | 55989749 1845921 305822 2095922 31458301 view top 100 |
Major Movable Equipment | major_movable_equipment | number | 92198401 5356586 2029880 74814822 32813223 view top 100 |
Minor Equipment Depreciable | minor_equipment_depreciable | number | 3901 76808 251604 936865 2008590 view top 100 |
Health Information Technology Designated Assets | health_information_technology | number | 162787 221783 244139 420267 514843 view top 100 |
Total fixed Assets | total_fixed_assets | number | 6312462 8263671 23450447 45709243 214491145 view top 100 |
Investments | investments | number | 66125 161784 171476 1691921 2326031 view top 100 |
Other Assets | other_assets | number | 14235644 14223635 15405677 952873 -1 view top 100 |
Total Other Assets | total_other_assets | number | 33462015 14235644 14223635 146679 1251041 view top 100 |
Total Assets | total_assets | number | 293930608 5777141 43677167 288371941 58101042 view top 100 |
Accounts Payable | accounts_payable | number | 1674068 976002 27609 955322 94564 view top 100 |
Salaries, Wages, and Fees Payable | salaries_wages_and_fees | number | 877101 240145 4149736 146084 486896 view top 100 |
Payroll Taxes Payable | payroll_taxes_payable | number | 284925 118407 208834 670618 519436 view top 100 |
Notes and Loans Payable (Short Term) | notes_and_loans_payable_short | number | 804331 2429594 969582 164690 346862 view top 100 |
Deferred Income | deferred_income | number | -10950 15336 42476 296627 view top 100 |
Other Current Liabilities | other_current_liabilities | number | 38483562 1487034 7015 -669408494 514538 view top 100 |
Total Current Liabilities | total_current_liabilities | number | 1937213 4052480 17971344 11458792 18563362 view top 100 |
Mortgage Payable | mortgage_payable | number | 6254430 68128915 117099360 view top 100 |
Notes Payable | notes_payable | number | 1953107 2480139 27522010 1455499 19851508 view top 100 |
Unsecured Loans | unsecured_loans | number | -85299908 -67839839 -44292573 -13953197 9411385 view top 100 |
Other Long Term Liabilities | other_long_term_liabilities | number | -55157 186181 94359 12000 10207 view top 100 |
Total Long Term Liabilities | total_long_term_liabilities | number | 125582 6254430 484573 -44083370 66829483 view top 100 |
Total Liabilities | total_liabilities | number | -666638007 1137672 61762142 7590163 -213965988 view top 100 |
General Fund Balance | general_fund_balance | number | 680585099 92504444 118011511 5643262 45284950 view top 100 |
Total Fund Balances | total_fund_balances | number | 92504444 118011511 5643262 45284950 3841381 view top 100 |
Total Liabilities and Fund Balances | total_liabilities_and_fund | number | 5777141 43677167 288371941 58101042 53639726 view top 100 |
DRG Amounts Other Than Outlier Payments | drg_amounts_other_than_outlier | text | view top 100 |
DRG amounts before October 1 | drg_amounts_before_october | number | 563693 3556587 17113408 23504 5165512 view top 100 |
DRG amounts after October 1 | drg_amounts_after_october | number | 1310137 831945 199397 7122147 676396 view top 100 |
DRG Amounts for Model 4 BPCI before October 1 | drg_amounts_for_model_4_bpci | text | view top 100 |
DRG Amounts for Model 4 BPCI after October 1 | drg_amounts_for_model_4_bpci_1 | text | view top 100 |
Outlier payments for discharges | outlier_payments_for | number | 8448 37754 8962 7135 5996 view top 100 |
Disproporationate Share Adjustment | disproporationate_share | number | 1002002 1446569 726087 56178 50711 view top 100 |
Allowable DSH Percentage | allowable_dsh_percentage | number | 0 view top 100 |
Managed Care Simulated Payments | managed_care_simulated | number | 18149697 36135353 4089799 27798030 1212684 view top 100 |
Total IME Payment | total_ime_payment | number | 1552 51392 331644 1092160 1131855 view top 100 |
Inpatient Revenue | inpatient_revenue | number | 146097711 98911736 156481742 43153567 28666522 view top 100 |
Outpatient Revenue | outpatient_revenue | number | 585 11075218 363163575 10075665 5027758 view top 100 |
Gross Revenue | gross_revenue | number | 108885341 146097711 39122829 300966645 24869008 view top 100 |
Less Contractual Allowance and discounts on patients' accounts | less_contractual_allowance | number | 1864206 64487164 605097128 485854139 80224081 view top 100 |
Net Patient Revenue | net_patient_revenue | number | 58746496 430246980 17015763 352917125 2673907 view top 100 |
Less Total Operating Expense | less_total_operating_expense | number | 24221392 86325135 21984641 18692122 11747296 view top 100 |
Net Income from Service to Patients | net_income_from_service_to | number | 7780487 583445 12997203 -885502 -8987437 view top 100 |
Total Other Income | total_other_income | number | 75129 2419664 373921 689111 9521176 view top 100 |
Total Income | total_income | number | 10767159 2537372 5673782 3744651 -2046220 view top 100 |
Total Other Expenses | total_other_expenses | number | -2 7810 492 121934 8543 view top 100 |
Net Income | net_income | number | 10767159 2537372 5673782 -2046220 -1927629 view top 100 |
Cost To Charge Ratio | cost_to_charge_ratio | number | 0.417073 0.33687 0.611553 0.269686 0.232069 view top 100 |
Net Revenue from Medicaid | net_revenue_from_medicaid | number | 474047 96017650 1412954 6731149 51133942 view top 100 |
Medicaid Charges | medicaid_charges | number | 3278623 5718429 16243000 1698155 92127553 view top 100 |
Net Revenue from Stand-Alone SCHIP | net_revenue_from_stand_alone | number | 51790 11469 32750 191124 3246 view top 100 |
Stand-Alone SCHIP Charges | stand_alone_schip_charges | number | 2450357 395493 2615964 108946 2084902 view top 100 |
rpt_rec_num | rpt_rec_num | number | 597008 604124 631809 604281 608357 view top 100 |