Skilled Nursing Facility Costs DataViz

opendata.utah.gov | Last Updated 12 Oct 2023

This dataset has the following 98 columns:

Column NameAPI Column NameData TypeSample Values
Yearyeartext
Facility Namefacility_nametext
Street Addressstreet_addresstext
Citycitytext
State Codestate_codetext
Zip Codezip_codetext
Countycountytext
Medicare CBSA Numbermedicare_cbsa_numbernumber
Rural versus Urbanrural_versus_urbantext
Fiscal Year Begin Datefiscal_year_begin_datecalendar_date
Fiscal Year End Datefiscal_year_end_datecalendar_date
Type of Controltype_of_controlnumber
Total Days Title XVIIItotal_days_title_xviiinumber
Total Days Title XIXtotal_days_title_xixnumber
Total Days Othertotal_days_othernumber
Total Days Totaltotal_days_totalnumber
Number of Bedsnumber_of_bedsnumber
Total Bed Days Availabletotal_bed_days_availablenumber
Total Discharges Title XVIIItotal_discharges_title_xviiinumber
Total Discharges Title XIXtotal_discharges_title_xixnumber
Total Discharges Title Othertotal_discharges_title_othernumber
Total Discharges Totaltotal_discharges_totalnumber
SNF Average Length of Stay Title XVIIIsnf_average_length_of_staynumber
SNF Average Length of Stay Title XIXsnf_average_length_of_stay_1number
SNF Average Length of Stay Totalsnf_average_length_of_stay_2number
SNF Admissions Title XVIIIsnf_admissions_title_xviiinumber
SNF Admissions Title XIXsnf_admissions_title_xixnumber
SNF Admissions Othersnf_admissions_othernumber
SNF Admissions Totalsnf_admissions_totalnumber
SNF Days Title XVIIIsnf_days_title_xviiinumber
SNF Days Title XIXsnf_days_title_xixnumber
SNF Days Othersnf_days_othernumber
SNF Days Totalsnf_days_totalnumber
SNF Number of Bedssnf_number_of_bedsnumber
SNF Bed Days Availablesnf_bed_days_availablenumber
SNF Discharges Title XVIIIsnf_discharges_title_xviiinumber
SNF Discharges Title XIXsnf_discharges_title_xixnumber
SNF Discharges Title Othersnf_discharges_title_othernumber
SNF Discharges Totalsnf_discharges_totalnumber
Total RUG Daystotal_rug_daysnumber
Total Salaries From Worksheet Atotal_salaries_from_worksheetnumber
Overhead Non-Salary Costsoverhead_non_salary_costsnumber
Total Chargestotal_chargesnumber
Total Coststotal_costsnumber
Wage-related Costs (core)wage_related_costs_corenumber
Total Salaries (adjusted)total_salaries_adjustednumber
Contract Laborcontract_labornumber
Cash on hand and in bankscash_on_hand_and_in_banksnumber
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
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_loanstext
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
Total General Inpatient Care Services Revenuetotal_general_inpatient_carenumber
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
Net Incomenet_incomenumber
Inpatient PPS Amountinpatient_pps_amountnumber
Nursing and Allied Health Education Activitiesnursing_and_allied_healthtext
Allowable Bad Debtsallowable_bad_debtsnumber
Geocodedgeocodedpoint