Nurse staffing · CMS certification number 105525
MANATEE SPRINGS REHABILITATION AND NURSING CENTER
BRADENTON, Florida
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 | 9,645 | 2,684.25 | 10,366 | 23,384 | 36,434.25 | 0.278305 | 1.074754 | 2.424469 | 3.777527 | 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 | 10,142 | 3,093.25 | 10,808.5 | 23,903.5 | 37,805.25 | 0.304994 | 1.065717 | 2.356882 | 3.727593 | 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 | 10,445 | 3,234 | 11,805.75 | 26,862.75 | 41,902.5 | 0.309622 | 1.130278 | 2.571829 | 4.011728 | 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 |
| 2018Q1 | 31 March 2018 | 90 | 10,068 | 3,742 | 9,987.5 | 25,810 | 39,539.5 | 0.371673 | 0.992004 | 2.563568 | 3.927245 | 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 | 10,553 | 3,019.75 | 10,700.25 | 28,032 | 41,752 | 0.286151 | 1.013953 | 2.656306 | 3.95641 | 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 | 10,716 | 3,169.5 | 10,809 | 29,256 | 43,234.5 | 0.295773 | 1.008679 | 2.730123 | 4.034574 | 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 | 10,764 | 2,142.75 | 10,542 | 24,074 | 36,758.75 | 0.199066 | 0.979376 | 2.236529 | 3.414971 | 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 | 10,271 | 2,428.25 | 12,957.75 | 27,795.75 | 43,181.75 | 0.236418 | 1.261586 | 2.706236 | 4.20424 | 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 | 10,362 | 2,660.5 | 11,607.25 | 27,977.75 | 42,245.5 | 0.256755 | 1.120175 | 2.700034 | 4.076964 | 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 | 10,350 | 3,123.75 | 11,519.5 | 28,468.25 | 43,111.5 | 0.301812 | 1.112995 | 2.750556 | 4.165362 | 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 | 10,460 | 3,895 | 11,341.25 | 26,759.75 | 41,996 | 0.372371 | 1.08425 | 2.558293 | 4.014914 | 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 | 10,605 | 4,378.55 | 10,176.25 | 27,236.75 | 41,791.55 | 0.412876 | 0.959571 | 2.568293 | 3.94074 | 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 | 9,324 | 5,154.5 | 7,721.25 | 21,381.5 | 34,257.25 | 0.552821 | 0.828105 | 2.293168 | 3.674094 | 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 | 9,951 | 5,244 | 9,748.5 | 25,938 | 40,930.5 | 0.526982 | 0.97965 | 2.606572 | 4.113205 | 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 | 10,513 | 4,910.5 | 10,827.5 | 27,956 | 43,694 | 0.467088 | 1.029915 | 2.659184 | 4.156188 | 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 | 10,387 | 5,254 | 9,949 | 27,462.5 | 42,665.5 | 0.505825 | 0.957832 | 2.64393 | 4.107586 | 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 | 10,302 | 5,025.5 | 9,601.25 | 26,914.25 | 41,541 | 0.487818 | 0.931979 | 2.612527 | 4.032324 | 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 |
| 2021Q4 | 31 December 2021 | 92 | 10,649 | 3,980.75 | 10,043.75 | 27,146 | 41,170.5 | 0.373814 | 0.943164 | 2.54916 | 3.866138 | 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 | 10,480 | 2,913.25 | 11,140.25 | 27,656.75 | 41,710.25 | 0.277982 | 1.063001 | 2.639003 | 3.979986 | 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 | 10,520 | 2,867 | 11,904.25 | 26,986.5 | 41,757.75 | 0.272529 | 1.131583 | 2.565257 | 3.969368 | 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 | 10,527 | 2,686.75 | 12,020 | 26,178.75 | 40,885.5 | 0.255225 | 1.141826 | 2.48682 | 3.88387 | 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 | 10,479 | 2,515.5 | 11,804.25 | 26,030.25 | 40,350 | 0.240052 | 1.126467 | 2.48404 | 3.850558 | 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 | 10,227 | 2,980 | 11,105 | 26,408.5 | 40,493.5 | 0.291386 | 1.085851 | 2.582233 | 3.95947 | 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 | 10,165 | 4,054.25 | 9,989 | 26,141.5 | 40,184.75 | 0.398844 | 0.982686 | 2.571717 | 3.953246 | 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 | 10,235 | 4,923 | 8,929.75 | 25,564.62 | 39,417.37 | 0.480997 | 0.872472 | 2.497765 | 3.851233 | 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 | 10,599 | 4,898.5 | 9,295.75 | 24,802.82 | 38,997.07 | 0.462166 | 0.87704 | 2.340109 | 3.679316 | 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 | 10,603 | 6,275.89 | 8,572 | 24,893.85 | 39,741.74 | 0.591898 | 0.80845 | 2.347812 | 3.74816 | 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 | 10,244 | 7,138.82 | 8,306 | 23,725.35 | 39,170.17 | 0.696878 | 0.810816 | 2.316024 | 3.823718 | 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 | 10,353 | 8,031.94 | 7,797.75 | 23,635.67 | 39,465.36 | 0.775808 | 0.753187 | 2.282978 | 3.811973 | 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 | 10,621 | 8,854.25 | 7,206.75 | 26,495 | 42,556 | 0.833655 | 0.678538 | 2.494586 | 4.006779 | 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 | 10,359 | 8,369.82 | 7,074.5 | 24,363.16 | 39,807.48 | 0.807976 | 0.682933 | 2.351883 | 3.842792 | 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 | 10,243 | 9,053.22 | 6,143.25 | 23,640.94 | 38,837.41 | 0.883845 | 0.599751 | 2.308009 | 3.791605 | 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 | 10,345 | 10,911.04 | 4,609 | 25,059.15 | 40,579.19 | 1.054716 | 0.445529 | 2.422344 | 3.92259 | 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 | 10,046 | 10,849.35 | 4,711.75 | 25,669.53 | 41,230.63 | 1.079967 | 0.469018 | 2.555199 | 4.104184 | 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 | 10,248 | 11,165.6 | 4,710.75 | 25,529.9 | 41,406.25 | 1.089539 | 0.459675 | 2.491208 | 4.040423 | 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 105525 and the quarter.