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 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