Skilled Nursing Center Costs Utah County 2016_2019

opendata.utah.gov | Last Updated 10 Feb 2023

This dataset has the following 101 columns:

Column Name	API Column Name	Data Type	Sample Values
Year	year	number	2016 2017 2018 2019 view top 100
Facility Name	facility_name	text	PARKWAY HEALTH CENTER STONEHENGE OF OREM AVALON CARE CENTER - VA PAYSON SPANISH FORK REHABILITATION AND NURS STONEHENGE OF SPRINGVILLE view top 100
Street Address	street_address	text	1001 NORTH 500 WEST 25 EAST ALPINE WAY 575 EAST 1400 SOUTH 151 EAST CENTER STREET 740 NORTH 300 EAST view top 100
City	city	text	OREM PAYSON PROVO AMERICAN FORK PLEASANT GROVE view top 100
State Code	state_code	text	UT view top 100
Zip Code	zip_code	text	84057 84651 84003 84062 85604 view top 100
County	county	text	UTAH view top 100
Type of Control	type_of_control	number	4 6 5 11 9 view top 100
Total Days Title XVIII	total_days_title_xviii	number	503 6012 878 1223 1284 view top 100
Total Days Title XIX	total_days_title_xix	number	7462 3152 13341 17156 1185 view top 100
Total Days Other	total_days_other	number	2699 1688 1502 6198 33209 view top 100
Total Days Total	total_days_total	number	6273 10345 32404 9830 10047 view top 100
Number of Beds	number_of_beds	number	52 120 45 16 29 view top 100
Total Bed Days Available	total_bed_days_available	number	16425 8760 43800 5840 44165 view top 100
Total Discharges Title XVIII	total_discharges_title_xviii	number	26 6 45 9 31 view top 100
Total Discharges Title XIX	total_discharges_title_xix	number	2 21 54 22 15 view top 100
Total Discharges Title Other	total_discharges_title_other	number	204 213 36 15 17 view top 100
Total Discharges Total	total_discharges_total	number	352 110 94 348 64 view top 100
SNF Average Length of Stay Title V	snf_average_length_of_stay	text	view top 100
SNF Average Length of Stay Title XVIII	snf_average_length_of_stay_1	number	67.27 43.89 26.43 44.6 25.23 view top 100
SNF Average Length of Stay Title XIX	snf_average_length_of_stay_2	number	166.54 277 299.84 249.04 303.6 view top 100
SNF Average Length of Stay Total	snf_average_length_of_stay_3	number	19.06 15.34 57.03 35.31 72.38 view top 100
SNF Admissions Title XVIII	snf_admissions_title_xviii	number	9 31 18 69 48 view top 100
SNF Admissions Title XIX	snf_admissions_title_xix	number	10 13 7 4 3 view top 100
SNF Admissions Other	snf_admissions_other	number	15 18 22 163 151 view top 100
SNF Admissions Total	snf_admissions_total	number	56 58 137 64 174 view top 100
SNF Days Title XVIII	snf_days_title_xviii	number	503 6012 878 1223 1284 view top 100
SNF Days Title XIX	snf_days_title_xix	number	7462 3152 13341 17156 1185 view top 100
SNF Days Other	snf_days_other	number	2699 1688 1502 6198 33209 view top 100
SNF Days Total	snf_days_total	number	6273 10345 32404 9830 10047 view top 100
SNF Number of Beds	snf_number_of_beds	number	52 120 45 16 29 view top 100
SNF Bed Days Available	snf_bed_days_available	number	16425 8760 38690 10585 13140 view top 100
SNF Discharges Title XVIII	snf_discharges_title_xviii	number	26 6 45 9 31 view top 100
SNF Discharges Title XIX	snf_discharges_title_xix	number	2 21 54 22 15 view top 100
SNF Discharges Title Other	snf_discharges_title_other	number	204 15 213 36 17 view top 100
SNF Discharges Total	snf_discharges_total	number	110 352 94 348 64 view top 100
Total RUG Days	total_rug_days	number	6012 878 1223 1284 64 view top 100
Total Salaries From Worksheet A	total_salaries_from_worksheet	number	6 615177 2110493 2229864 1754646 view top 100
Overhead Non-Salary Costs	overhead_non_salary_costs	number	2420821 4330003 2313053 1210656 3752750 view top 100
Total Charges	total_charges	number	358808 683743 3897687 1461987 233518 view top 100
Total Costs	total_costs	number	2397909 817240 1423037 716140 24757 view top 100
Wage-related Costs (core)	wage_related_costs_core	number	1 388623 422668 146619 416117 view top 100
Total Salaries (adjusted)	total_salaries_adjusted	number	6 615177 2110493 2229864 1754646 view top 100
Contract Labor	contract_labor	number	942953 27154 15177 145804 913972 view top 100
Cash on hand and in banks	cash_on_hand_and_in_banks	number	2000 2700 333175 110198 20483 view top 100
Notes Receivable	notes_receivable	number	-1612 1020336 2230895 2344619 view top 100
Accounts Receivable	accounts_receivable	number	822812 3665382 -120908 765530 1559274 view top 100
Less: Allowances for uncollectible notes and accounts receivable	less_allowances_for	number	1166 17261 13524 235754 89834 view top 100
Inventory	inventory	number	32746 1800 17245 11700 944 view top 100
Prepaid expenses	prepaid_expenses	number	-19740 1185 6683 6270 7711 view top 100
Other current assets	other_current_assets	number	5957 78885 -13 4957665 120 view top 100
Total Current Assets	total_current_assets	number	545587 913092 240934 973239 3808674 view top 100
Land	land	number	306459 1646000 1266000 2500 183400 view top 100
Land improvements	land_improvements	number	18151 67477 164215 6084 15751 view top 100
Buildings	buildings	number	3040187 1900758 4575858 4706180 7712403 view top 100
Leasehold improvements	leasehold_improvements	number	17182 183244 359929 831922 179501 view top 100
Fixed equipment	fixed_equipment	number	620629 13254 325735 35387 97865 view top 100
Major movable equipment	major_movable_equipment	number	1900 233539 2630 509209 216558 view top 100
Minor equipment depreciable	minor_equipment_depreciable	text	view top 100
Total fixed Assets	total_fixed_assets	number	1900 774537 243255 427863 2286887 view top 100
Investments	investments	number	-267776 298263 456199 1684606 1983422 view top 100
Other Assets	other_assets	number	2500 23132 19615 2676435 10329 view top 100
Total other Assets	total_other_assets	number	2500 2676435 944496 298263 69006 view top 100
Total Assets	total_assets	number	4794125 1716560 2257025 2746459 1653662 view top 100
Accounts payable	accounts_payable	number	782591 135193 1380516 597901 121681 view top 100
Salaries, wages, and fees payable	salaries_wages_and_fees	number	120513 966129 12758 136624 384146 view top 100
Payroll taxes payable	payroll_taxes_payable	number	57534 10010 63770 71100 71656 view top 100
Notes and Loans Payable (short term)	notes_and_loans_payable_short	number	325586 3612 25000 121349 126010 view top 100
Deferred income	deferred_income	number	3161 315000 320000 view top 100
Other current liabilities	other_current_liabilities	number	135232 99198 702948 12914 1938 view top 100
Total current liabilities	total_current_liabilities	number	515653 1510480 1144726 556573 449735 view top 100
Mortgage payable	mortgage_payable	number	1912483 1992393 2079334 2164610 4730258 view top 100
Notes Payable	notes_payable	number	285586 285587 350586 415858 420057 view top 100
Unsecured Loans	unsecured_loans	number	25000 view top 100
Other long term liabilities	other_long_term_liabilities	number	-2324051 -553655 -23336 -21021 -18442 view top 100
Total long term liabilities	total_long_term_liabilities	number	5057436 9312 4697528 -15081 -2100989 view top 100
Total liabilities	total_liabilities	number	378163 7242207 -2286799 1843752 541492 view top 100
General fund balance	general_fund_balance	number	434274 951261 -186407 -116004 2311730 view top 100
Total fund balances	total_fund_balances	number	434274 951261 -186407 -116004 2311730 view top 100
Total Liabilities and fund balances	total_liabilities_and_fund	number	4794125 1716560 2257025 2746459 1653662 view top 100
Total General Inpatient Care Services Revenue	total_general_inpatient_care	number	1036863 5507850 3692408 613510 3219213 view top 100
Inpatient Revenue	inpatient_revenue	number	3984844 8965024 5276884 3653886 4971583 view top 100
Outpatient Revenue	outpatient_revenue	number	334 350 603 1022 5432 view top 100
Gross Revenue	gross_revenue	number	3984844 8965024 5276884 3653886 4971583 view top 100
Less Contractual Allowance and discounts on patients' accounts	less_contractual_allowance	number	-523629 -403035 69204 5684517 913411 view top 100
Net Patient Revenue	net_patient_revenue	number	3653886 14013582 12775264 3227938 4902820 view top 100
Less Total Operating Expense	less_total_operating_expense	number	406131 6286896 12513612 6200590 2931494 view top 100
Net Income from service to patients	net_income_from_service_to	number	-1323691 -669072 399031 -1476472 243930 view top 100
Total Other Income	total_other_income	number	13982 1131810 38143 9527 68529 view top 100
Total Income	total_income	number	194806 -1190517 -20700 398164 198130 view top 100
Net Income	net_income	number	194806 -1190517 308093 198130 384811 view top 100
Inpatient PPS Amount	inpatient_pps_amount	number	3908787 141709 405837 155731 3242295 view top 100
Nursing and Allied Health Education Activities	nursing_and_allied_health	text	view top 100
Allowable Bad Debts	allowable_bad_debts	number	7235 3290 11305 9172 6954 view top 100
rpt_rec_num	rpt_rec_num	number	1218072 1254434 1160771 1279044 1156557 view top 100
Provider CCN	provider_ccn	number	465088 465119 465104 465090 465183 view top 100
Medicare CBSA Number	medicare_cbsa_number	number	39340 view top 100
Rural versus Urban	rural_versus_urban	text	U view top 100
Fiscal Year Begin Date	fiscal_year_begin_date	calendar_date	2016-01-01T00:00:00.000 2017-01-01T00:00:00.000 2019-01-01T00:00:00.000 2017-07-01T00:00:00.000 2019-07-01T00:00:00.000 view top 100
Fiscal Year End Date	fiscal_year_end_date	calendar_date	2016-12-31T00:00:00.000 2018-12-31T00:00:00.000 2019-12-31T00:00:00.000 2017-06-30T00:00:00.000 2020-06-30T00:00:00.000 view top 100
Geocoded	geocoded	point	{"coordinates":[-111.68145,40.2715],"type":"Point"} {"coordinates":[-111.73992,40.35694],"type":"Point"} {"coordinates":[-111.66742,40.24694],"type":"Point"} {"coordinates":[-111.71222,40.04344],"type":"Point"} {"coordinates":[-111.68862,40.31116],"type":"Point"} view top 100