Skilled Nursing Center Costs Utah 2019

opendata.utah.gov | Last Updated 9 Nov 2022

The Skilled Nursing Facility (SNF) Cost Report dataset is a public use file that provides select measures from the skilled nursing facility annual cost report. This data includes provider information such as facility characteristics, utilization data, cost and charges by cost center (in total and for Medicare), Medicare settlement data, and financial statement data organized by CMS Certification Number.

This dataset has the following 100 columns:

Column NameAPI Column NameData TypeSample Values
rpt_rec_numrpt_rec_numnumber
Provider CCNprovider_ccnnumber
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 Vtotal_discharges_title_vtext
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 Vsnf_average_length_of_staytext
SNF Average Length of Stay Title XVIIIsnf_average_length_of_stay_1number
SNF Average Length of Stay Title XIXsnf_average_length_of_stay_2number
SNF Average Length of Stay Totalsnf_average_length_of_stay_3number
SNF Admissions Title Vsnf_admissions_title_vtext
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 Vsnf_days_title_vtext
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 Vsnf_discharges_title_vtext
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
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
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
Allowable Bad Debtsallowable_bad_debtsnumber