The Long Term Care Community Coalition (LTCCC) has published the latest staffing data for every U.S. nursing home. This follows mandatory reporting requirements for the third quarter of 2021. The federal data shows that staffing levels are declining as too many facilities continue failing to provide basic care needs for many of the nation’s 1.1 million nursing home residents. State by state data and national statistics are available for download.
Nursing home staffing, 4th Q. 2018
Data files includes direct care RN, LPN and CAN staffing levels for each facility; non-nursing staff, including administrators and activities staff; and the extent to which the facility relies on contract workers to provide resident care. Data is sortable by state and staffing levels.
CMS Payroll Based Journal (PBJ) staffing data submitted by long-term care facilities. Data are presented as one row per work day, for each facility. Use this data to track actual (paid) staffing against what facilities report to CMS. Information is updated quarterly. You can find staffing ratings and reported, expected, and adjusted staffing values here (CMS spreadsheet). Sort and filter data by numerous variables, such as size, state, zip code, CNA staffing perresident per day and more. Staffing is one of the measures used in the five-star rating system. It may be helpful to compare this data with general information on currently active nursing homes, including number of certified beds, quality measure scores, and other five-star criteria. Data files includes direct care RN, LPN and CAN staffing levels for each facility; non-nursing staff, including administrators and activities staff; and the extent to which the facility relies on contract workers to provide resident care. Data is sortable by state and staffing levels.
In November 2007, the U.S. Medicare Web site released detailed information about every Medicare and Medicaid-certified nursing home in the country. Nursing Home Compare uses data compiled from inspections and compares health and fire safety concerns as well as quality measures and staffing information. Nursing Home Compare, according to the Medicare website, is meant to provide information to help individuals, family members, caregivers, and those who assist them find and compare nursing homes and make informed decisions about nursing home care. AHCJ has reduced key elements in Nursing Compare data into more manageable formats in Excel spreadsheets.
CMS 2016 Skilled Nursing Facility Public Use File
The Skilled Nursing Facility PUF presents summarized information on services provided to Medicare beneficiaries by skilled nursing facilities. It contains information on utilization, payment (Medicare payment and Medicare standardized payment), submitted charges, and beneficiary demographic and chronic condition indicators organized by CMS Certification Number (6-digit provider identification number), Resource Utilization Group (RUG), and state of service.
The new 2016 PUF has information for 14,993 skilled nursing facilities, approximately 2.5 million stays, and $26.7 billion in Medicare payments for 2016. Demographic and chronic condition information is included.
Finding patterns and trends in health data: Pivot tables in spreadsheets: Excel pivot tables are a powerful way to organize, interpret and manipulate numerical data. In this tip sheet, reporters learn the skills necessary to apply these tables in real-world situations, including analyzing the Nursing Home Compare data.