Utah Hospitals Cost Report 2015

opendata.utah.gov | Last Updated 6 Dec 2019

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 NameAPI Column NameData TypeSample Values
Provider CCNprovider_ccnnumber
Hospital Namehospital_nametext
Street Addressstreet_addresstext
Citycitytext
State Codestate_codetext
Zip Codezip_codenumber
Countycountytext
Medicare CBSA Numbermedicare_cbsa_numbernumber
Rural Versus Urbanrural_versus_urbantext
CCN Facility Typeccn_facility_typetext
Provider Typeprovider_typenumber
Type of Controltype_of_controlnumber
Fiscal Year Begin Datefiscal_year_begin_datecalendar_date
Fiscal Year End Datefiscal_year_end_datecalendar_date
FTE - Employees on Payrollfte_employees_on_payrollnumber
Number of Interns and Residents (FTE)number_of_interns_andnumber
Total Days Title Vtotal_days_title_vtext
Total Days Title XVIIItotal_days_title_xviiinumber
Total Days Title XIXtotal_days_title_xixnumber
Total Days (V + XVIII + XIX + Unknown)total_days_v_xviii_xix_unknownnumber
Number of Bedsnumber_of_bedsnumber
Total Bed Days Availabletotal_bed_days_availablenumber
Total Discharges Title Vtotal_discharges_title_vtext
Total Discharges Title XVIIItotal_discharges_title_xviiinumber
Total Discharges Title XIXtotal_discharges_title_xixnumber
Total Discharges (V + XVIII + XIX + Unknown)total_discharges_v_xviiinumber
Total Days Title V + Total for all Subproviderstotal_days_title_v_totaltext
Total Days Title XVIII + Total for all Subproviderstotal_days_title_xviii_totalnumber
Total Days Title XIX + Total for all Subproviderstotal_days_title_xix_totalnumber
Total Days (V + XVIII + XIX + Unknown) + Total for all Subprovidtotal_days_v_xviii_xix_unknown_1number
Number of Beds + Total for all Subprovidersnumber_of_beds_total_fornumber
Total Bed Days Available + Total for all Subproviderstotal_bed_days_available_1number
Total Discharges Title V + Total for all Subproviderstotal_discharges_title_v_1text
Total Discharges Title XVIII + Total for all Subproviderstotal_discharges_title_xviii_1number
Total Discharges Title XIX + Total for all Subproviderstotal_discharges_title_xix_1number
Total Discharges (V + XVIII + XIX + Unknown) + Total for all Subtotal_discharges_v_xviii_1number
Hospital Total Days Title V For Adults & Pedshospital_total_days_titletext
Hospital Total Days Title XVIII For Adults & Pedshospital_total_days_title_1number
Hospital Total Days Title XIX For Adults & Pedshospital_total_days_title_2number
Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Pehospital_total_days_v_xviiinumber
Hospital Number of Beds For Adults & Pedshospital_number_of_beds_fornumber
Hospital Total Bed Days Available For Adults & Pedshospital_total_bed_daysnumber
Hospital Total Discharges Title V For Adults & Pedshospital_total_dischargestext
Hospital Total Discharges Title XVIII For Adults & Pedshospital_total_discharges_1number
Hospital Total Discharges Title XIX For Adults & Pedshospital_total_discharges_2number
Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adulthospital_total_discharges_3number
Cost of Charity Carecost_of_charity_carenumber
Total Bad Debt Expensetotal_bad_debt_expensenumber
Cost of Uncompensated Carecost_of_uncompensated_carenumber
Total Unreimbursed and Uncompensated Caretotal_unreimbursed_andnumber
Total Salaries From Worksheet Atotal_salaries_from_worksheetnumber
Overhead Non-Salary Costsoverhead_non_salary_costsnumber
Depreciation Costdepreciation_costnumber
Total Coststotal_costsnumber
Inpatient Total Chargesinpatient_total_chargesnumber
Outpatient Total Chargesoutpatient_total_chargesnumber
Combined Outpatient + Inpatient Total Chargescombined_outpatient_inpatientnumber
Wage-Related Costs (Core)wage_related_costs_corenumber
Wage-Related Costs (RHC/FQHC)wage_related_costs_rhc_fqhcnumber
Total Salaries (adjusted)total_salaries_adjustednumber
Contract Laborcontract_labornumber
Wage Related Costs for Part - A Teaching Physicianswage_related_costs_for_partnumber
Wage Related Costs for Interns and Residentswage_related_costs_for_internsnumber
Cash on Hand and in Bankscash_on_hand_and_in_banksnumber
Temporary Investmentstemporary_investmentsnumber
Notes Receivablenotes_receivablenumber
Accounts Receivableaccounts_receivablenumber
Less: Allowances for Uncollectible Notes and Accounts Receivableless_allowances_fornumber
Inventoryinventorynumber
Prepaid Expensesprepaid_expensesnumber
Other Current Assetsother_current_assetsnumber
Total Current Assetstotal_current_assetsnumber
Landlandnumber
Land Improvementsland_improvementsnumber
Buildingsbuildingsnumber
Leasehold Improvementsleasehold_improvementsnumber
Fixed Equipmentfixed_equipmentnumber
Major Movable Equipmentmajor_movable_equipmentnumber
Minor Equipment Depreciableminor_equipment_depreciablenumber
Health Information Technology Designated Assetshealth_information_technologynumber
Total fixed Assetstotal_fixed_assetsnumber
Investmentsinvestmentsnumber
Other Assetsother_assetsnumber
Total Other Assetstotal_other_assetsnumber
Total Assetstotal_assetsnumber
Accounts Payableaccounts_payablenumber
Salaries, Wages, and Fees Payablesalaries_wages_and_feesnumber
Payroll Taxes Payablepayroll_taxes_payablenumber
Notes and Loans Payable (Short Term)notes_and_loans_payable_shortnumber
Deferred Incomedeferred_incomenumber
Other Current Liabilitiesother_current_liabilitiesnumber
Total Current Liabilitiestotal_current_liabilitiesnumber
Mortgage Payablemortgage_payablenumber
Notes Payablenotes_payablenumber
Unsecured Loansunsecured_loansnumber
Other Long Term Liabilitiesother_long_term_liabilitiesnumber
Total Long Term Liabilitiestotal_long_term_liabilitiesnumber
Total Liabilitiestotal_liabilitiesnumber
General Fund Balancegeneral_fund_balancenumber
Total Fund Balancestotal_fund_balancesnumber
Total Liabilities and Fund Balancestotal_liabilities_and_fundnumber
DRG Amounts Other Than Outlier Paymentsdrg_amounts_other_than_outliertext
DRG amounts before October 1drg_amounts_before_octobernumber
DRG amounts after October 1drg_amounts_after_octobernumber
DRG Amounts for Model 4 BPCI before October 1drg_amounts_for_model_4_bpcitext
DRG Amounts for Model 4 BPCI after October 1drg_amounts_for_model_4_bpci_1text
Outlier payments for dischargesoutlier_payments_fornumber
Disproporationate Share Adjustmentdisproporationate_sharenumber
Allowable DSH Percentageallowable_dsh_percentagenumber
Managed Care Simulated Paymentsmanaged_care_simulatednumber
Total IME Paymenttotal_ime_paymentnumber
Inpatient Revenueinpatient_revenuenumber
Outpatient Revenueoutpatient_revenuenumber
Gross Revenuegross_revenuenumber
Less Contractual Allowance and discounts on patients' accountsless_contractual_allowancenumber
Net Patient Revenuenet_patient_revenuenumber
Less Total Operating Expenseless_total_operating_expensenumber
Net Income from Service to Patientsnet_income_from_service_tonumber
Total Other Incometotal_other_incomenumber
Total Incometotal_incomenumber
Total Other Expensestotal_other_expensesnumber
Net Incomenet_incomenumber
Cost To Charge Ratiocost_to_charge_rationumber
Net Revenue from Medicaidnet_revenue_from_medicaidnumber
Medicaid Chargesmedicaid_chargesnumber
Net Revenue from Stand-Alone SCHIPnet_revenue_from_stand_alonenumber
Stand-Alone SCHIP Chargesstand_alone_schip_chargesnumber
rpt_rec_numrpt_rec_numnumber