Nurse staffing · CMS certification number 415096
Bethany Home of Rhode Island
Providence, Rhode Island
Hours reported to CMS’s Payroll-Based Journal, one row per quarter, oldest first. The facility’s full record →
Quarter by quarter
| Quarter | Quarter ended | Days reported | Resident days | Registered nurse hours | Licensed practical nurse hours | Nurse aide hours | Total nurse hours | Registered nurse hours per resident day | Licensed practical nurse hours per resident day | Nurse aide hours per resident day | Total nurse hours per resident day | How it is derived, and the file |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2017Q1 | 31 March 2017 | 90 | 2,763 | 3,108.75 | 322 | 7,667.19 | 11,097.94 | 1.125136 | 0.11654 | 2.774951 | 4.016627 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_rn_donadmin, hrs_lpn_admin, hrs_na_trn; they are read as hrs_rndon, hrs_lpnadmin, hrs_natrn. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-03-31.csv |
| 2017Q2 | 30 June 2017 | 91 | 2,652 | 2,892 | 415 | 7,841.75 | 11,148.75 | 1.090498 | 0.156486 | 2.956919 | 4.203903 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin; they are read as hrs_lpnadmin. CMS's file labels its last six hours columns hrs_medaide, hrs_medaide_emp, hrs_rn_donadmin, hrs_na_trn, hrs_natrn_emp, hrs_natrn_ctr; they are read by position as Hrs_MedAide_emp, Hrs_MedAide_ctr, Hrs_NAtrn, Hrs_NAtrn_emp, Hrs_NAtrn_ctr, Hrs_MedAide, the order in which each total equals its employee and contract parts on every row. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-06-30.csv |
| 2017Q3 | 30 September 2017 | 92 | 2,713 | 2,429.5 | 346.75 | 7,886.5 | 10,662.75 | 0.895503 | 0.127811 | 2.90693 | 3.930243 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin, hrs_na_trn; they are read as hrs_lpnadmin, hrs_natrn. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-09-30.csv |
| 2017Q4 | 31 December 2017 | 92 | 2,773 | 2,798 | 364.25 | 8,101.5 | 11,263.75 | 1.009016 | 0.131356 | 2.921565 | 4.061937 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin, hrs_na_trn; they are read as hrs_lpnadmin, hrs_natrn. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-12-31.csv |
| 2018Q1 | 31 March 2018 | 90 | 2,815 | 3,303.5 | 334 | 7,967 | 11,604.5 | 1.173535 | 0.11865 | 2.830195 | 4.12238 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-03-31.csv |
| 2018Q2 | 30 June 2018 | 91 | 2,446 | 3,581.75 | 72 | 7,992.5 | 11,646.25 | 1.46433 | 0.029436 | 3.26758 | 4.761345 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-06-30.csv |
| 2018Q3 | 30 September 2018 | 92 | 2,530 | 2,987.5 | 42.25 | 8,172.25 | 11,202 | 1.18083 | 0.0167 | 3.230138 | 4.427668 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-09-30.csv |
| 2018Q4 | 31 December 2018 | 92 | 2,665 | 2,353.25 | 194.25 | 7,809 | 10,356.5 | 0.883021 | 0.072889 | 2.930206 | 3.886116 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-12-13.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-12-13.csv |
| 2019Q1 | 31 March 2019 | 90 | 2,609 | 2,521.25 | 360.25 | 8,060.25 | 10,941.75 | 0.966366 | 0.13808 | 3.089402 | 4.193848 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-03-13.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-03-13.csv |
| 2019Q2 | 30 June 2019 | 91 | 2,940 | 3,184.5 | 316.25 | 7,585.25 | 11,086 | 1.083163 | 0.107568 | 2.580017 | 3.770748 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-06-30.csv |
| 2019Q3 | 30 September 2019 | 92 | 2,935 | 3,729.25 | 55.75 | 8,551.75 | 12,336.75 | 1.270613 | 0.018995 | 2.913714 | 4.203322 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-09-30.csv |
| 2019Q4 | 31 December 2019 | 92 | 3,118 | 3,126.5 | 0 | 9,074.5 | 12,201 | 1.002726 | 0 | 2.910359 | 3.913085 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-12-31.csv |
| 2020Q1 | 31 March 2020 | 91 | 2,618 | 2,906.75 | 0 | 8,690.75 | 11,597.5 | 1.110294 | 0 | 3.319614 | 4.429908 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-03-31.csv |
| 2020Q2 | 30 June 2020 | 91 | 1,532 | 2,476.5 | 0 | 7,021 | 9,497.5 | 1.616514 | 0 | 4.582898 | 6.199413 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-06-30.csv |
| 2020Q3 | 30 September 2020 | 92 | 2,101 | 2,315.5 | 0 | 6,276.75 | 8,592.25 | 1.102094 | 0 | 2.987506 | 4.0896 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-09-30.csv |
| 2020Q4 | 31 December 2020 | 92 | 2,273 | 3,460.25 | 0 | 6,965.25 | 10,425.5 | 1.522327 | 0 | 3.064342 | 4.58667 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-12-31.csv |
| 2021Q1 | 31 March 2021 | 90 | 2,113 | 3,213.75 | 0 | 6,989.75 | 10,203.5 | 1.520942 | 0 | 3.307974 | 4.828916 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-03-31.csv |
| 2021Q2 | 30 June 2021 | 91 | 2,442 | 3,547.75 | 0 | 6,756.58 | 10,304.33 | 1.452805 | 0 | 2.766822 | 4.219627 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-06-30.csv |
| 2021Q3 | 30 September 2021 | 92 | 2,640 | 3,902.75 | 0 | 8,097.25 | 12,000 | 1.478314 | 0 | 3.06714 | 4.545455 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-09-30.csv |
| 2021Q4 | 31 December 2021 | 92 | 2,647 | 3,725 | 0 | 7,830 | 11,555 | 1.407253 | 0 | 2.958066 | 4.365319 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. The file's `incomplete` column flags 0 of this facility's days as 1; those days are included as filed. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-12-31.csv |
| 2022Q1 | 31 March 2022 | 90 | 2,489 | 3,787.25 | 0 | 7,803 | 11,590.25 | 1.521595 | 0 | 3.134994 | 4.656589 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-01-01.csv |
| 2022Q2 | 30 June 2022 | 91 | 2,573 | 3,818.75 | 0 | 7,642.5 | 11,461.25 | 1.484162 | 0 | 2.970268 | 4.454431 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-06-30.csv |
| 2022Q3 | 30 September 2022 | 92 | 2,598 | 3,863.25 | 0 | 7,842 | 11,705.25 | 1.487009 | 0 | 3.018476 | 4.505485 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-09-30.csv |
| 2022Q4 | 31 December 2022 | 92 | 2,538 | 3,753.5 | 0 | 7,835.75 | 11,589.25 | 1.47892 | 0 | 3.087372 | 4.566292 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-12-31.csv |
| 2023Q1 | 31 March 2023 | 90 | 2,398 | 3,804.75 | 0 | 7,771.25 | 11,576 | 1.586635 | 0 | 3.240721 | 4.827356 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-01-01.csv |
| 2023Q2 | 30 June 2023 | 91 | 2,647 | 3,807.75 | 0 | 7,932.75 | 11,740.5 | 1.438515 | 0 | 2.996883 | 4.435399 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-06-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-06-01.csv |
| 2023Q3 | 30 September 2023 | 92 | 2,662 | 3,786.75 | 0 | 7,903.75 | 11,690.5 | 1.422521 | 0 | 2.969102 | 4.391623 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-09-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-09-01.csv |
| 2023Q4 | 31 December 2023 | 92 | 2,578 | 3,806.25 | 0 | 7,971.25 | 11,777.5 | 1.476435 | 0 | 3.092029 | 4.568464 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-12-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-12-01.csv |
| 2024Q1 | 31 March 2024 | 91 | 2,840 | 3,807.75 | 0 | 7,942.75 | 11,750.5 | 1.340757 | 0 | 2.796743 | 4.1375 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-01-01.csv |
| 2024Q2 | 30 June 2024 | 91 | 2,651 | 3,820.5 | 0 | 7,790.75 | 11,611.25 | 1.441154 | 0 | 2.938797 | 4.379951 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-04-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-04-01.csv |
| 2024Q3 | 30 September 2024 | 92 | 2,567 | 3,713 | 0 | 8,462.5 | 12,175.5 | 1.446436 | 0 | 3.29665 | 4.743085 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-09-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-09-01.csv |
| 2024Q4 | 31 December 2024 | 92 | 2,496 | 3,789.75 | 0 | 7,875.25 | 11,665 | 1.518329 | 0 | 3.155148 | 4.673478 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-12-31.csv |
| 2025Q1 | 31 March 2025 | 90 | 2,420 | 3,694.75 | 0 | 7,714.5 | 11,409.25 | 1.526756 | 0 | 3.18781 | 4.714566 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-01-01.csv |
| 2025Q2 | 30 June 2025 | 91 | 2,541 | 3,806.75 | 0 | 8,203.25 | 12,010 | 1.498131 | 0 | 3.228355 | 4.726486 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-04-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-04-01.csv |
| 2025Q3 | 30 September 2025 | 92 | 2,756 | 3,884.25 | 0 | 8,229.75 | 12,114 | 1.40938 | 0 | 2.986121 | 4.395501 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-07-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-07-01.csv |
| 2025Q4 | 31 December 2025 | 92 | 2,393 | 3,234.44 | 0 | 6,951.79 | 10,186.23 | 1.351626 | 0 | 2.905052 | 4.256678 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-10-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-10-01.csv |
| 2026Q1 | 31 March 2026 | 90 | 2,633 | 3,815.53 | 0 | 8,925.69 | 12,741.22 | 1.449119 | 0 | 3.389932 | 4.839051 | From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2026-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2026-01-01.csv |
Every figure on this page is printed as it was banked from the Payroll-Based Journal file named on its row. A figure that does not match its file? Tell us on the corrections page, quoting certification number 415096 and the quarter.