Velarion Records

The 340B register and hospital finances — joined, watched daily, delivered.

Facility record report · CMS certification number 555517

KERN VALLEY HEALTHCARE DISTRICT DP SNF

LAKE ISABELLA, California · Medicare and Medicaid

Finances, as filed

Not yet extracted for this facility.

Ownership, as filed with CMS

Care Compare

As filed in the CMS file dated 1 August 2026 (Care Compare ownership).

Owner or managerRoleTypeOwnership percentageAssociation
GROSS, ROBERTADP OF THE SNFIndividualNOT APPLICABLEsince 02/01/2020
LOVRICH, JOHNADP OF THE SNFIndividualNOT APPLICABLEsince 01/15/2026
MARKMAN, SALLYADP OF THE SNFIndividualNOT APPLICABLEsince 03/03/2014
SMITH, AMYADP OF THE SNFIndividualNOT APPLICABLEsince 02/18/2015
BLYTHE, JOHNCORPORATE DIRECTORIndividualNOT APPLICABLEsince 05/03/2017
CLARK, FREDERICKCORPORATE DIRECTORIndividualNOT APPLICABLEsince 01/01/2021
ELCONIN, KATHERYNCORPORATE DIRECTORIndividualNOT APPLICABLEsince 01/01/2021
ELLIOTT, ROSSCORPORATE DIRECTORIndividualNOT APPLICABLEsince 01/01/2020
PARKS, EUGENECORPORATE DIRECTORIndividualNOT APPLICABLEsince 12/07/2018
LOVRICH, JOHNCORPORATE OFFICERIndividualNOT APPLICABLEsince 09/01/2025
PETTIJOHN, BRENDACORPORATE OFFICERIndividualNOT APPLICABLEsince 10/06/2023
GROSS, ROBERTOPERATIONAL/MANAGERIAL CONTROLIndividualNOT APPLICABLEsince 02/01/2020
LOVRICH, JOHNOPERATIONAL/MANAGERIAL CONTROLIndividualNOT APPLICABLEsince 09/01/2025
MARKMAN, SALLYOPERATIONAL/MANAGERIAL CONTROLIndividualNOT APPLICABLEsince 03/03/2014
SMITH, AMYOPERATIONAL/MANAGERIAL CONTROLIndividualNOT APPLICABLEsince 02/18/2015

Medicare enrollment

As filed in the CMS file dated 1 August 2026 (Medicare enrollment ownership), under the enrollment of KERN VALLEY HEALTHCARE DISTRICT (enrollment ID O20100105000110).

OwnerIndividual or organizationRoleOwnership percentageAssociation dateDescribed in the filing as
AMY SMITHIndividualADP OF THE SNFCMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.2/18/2015
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
JOHN LOVRICHIndividualADP OF THE SNFCMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.1/15/2026
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
ROBERT L GROSSIndividualADP OF THE SNFCMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.2/1/2020
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
SALLY MARKMANIndividualADP OF THE SNFCMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.3/3/2014
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
EUGENE PARKSIndividualCORPORATE DIRECTOR012/7/2018
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
FREDERICK CLARKIndividualCORPORATE DIRECTOR01/1/2021
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
JOHN R BLYTHEIndividualCORPORATE DIRECTOR15/3/2017
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
KATHERYN S ELCONINIndividualCORPORATE DIRECTOR01/1/2021
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
ROSS W ELLIOTTIndividualCORPORATE DIRECTOR01/1/2020
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
BRENDA JEAN PETTIJOHNIndividualCORPORATE OFFICER010/6/2023
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
JOHN LOVRICHIndividualCORPORATE OFFICER09/1/2025
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
AMY SMITHIndividualOPERATIONAL/MANAGERIAL CONTROLCMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.2/18/2015
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
JOHN LOVRICHIndividualOPERATIONAL/MANAGERIAL CONTROLCMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.9/1/2025
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
ROBERT L GROSSIndividualOPERATIONAL/MANAGERIAL CONTROLCMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.2/1/2020
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
SALLY MARKMANIndividualOPERATIONAL/MANAGERIAL CONTROLCMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.3/3/2014
Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.

Changes in ownership

Inspections

Inspection cycleHealth inspectionFire safety inspectionHealth deficienciesFire safety deficiencies
123 April 202623 April 2026153
212 June 202512 June 2025106
325 April 202425 April 202475

From the Care Compare inspection summary file NH_SurveySummary_Aug2026.csv, processed on 1 August 2026.

Deficiencies cited

32 deficiencies on file, newest inspection first
Inspection dateInspection typeTagCategoryWhat was citedScope and severityComplaintCorrectedCorrection date
23 April 2026HealthF 0658Resident Assessment and Care Planning DeficienciesEnsure services provided by the nursing facility meet professional standards of quality.ENoDeficient, Provider has date of correction22 May 2026
23 April 2026HealthF 0689Quality of Life and Care DeficienciesEnsure that a nursing home area is free from accident hazards and provides adequate supervision to prevent accidents.ENoDeficient, Provider has date of correction22 May 2026
23 April 2026HealthF 0695Quality of Life and Care DeficienciesProvide safe and appropriate respiratory care for a resident when needed.DNoDeficient, Provider has date of correction22 May 2026
23 April 2026HealthF 0727Nursing and Physician Services DeficienciesHave a registered nurse on duty 8 hours a day; and select a registered nurse to be the director of nurses on a full time basis.FNoDeficient, Provider has date of correction22 May 2026
23 April 2026HealthF 0812Nutrition and Dietary DeficienciesProcure food from sources approved or considered satisfactory and store, prepare, distribute and serve food in accordance with professional standards.ENoDeficient, Provider has date of correction22 May 2026
23 April 2026HealthF 0813Nutrition and Dietary DeficienciesHave a policy regarding use and storage of foods brought to residents by family and other visitors.DNoDeficient, Provider has date of correction22 May 2026
23 April 2026HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.FNoDeficient, Provider has date of correction22 May 2026
23 April 2026HealthF 0926Environmental DeficienciesHave policies on smoking.DNoDeficient, Provider has date of correction22 May 2026
17 December 2025HealthF 0552Resident Rights DeficienciesEnsure that residents are fully informed and understand their health status, care and treatments.DYesDeficient, Provider has date of correction28 February 2026
17 December 2025HealthF 0580Resident Rights DeficienciesImmediately tell the resident, the resident's doctor, and a family member of situations (injury/decline/room, etc.) that affect the resident.DYesDeficient, Provider has date of correction28 February 2026
17 December 2025HealthF 0600Freedom from Abuse, Neglect, and Exploitation DeficienciesProtect each resident from all types of abuse such as physical, mental, sexual abuse, physical punishment, and neglect by anybody.DYesDeficient, Provider has date of correction28 February 2026
17 December 2025HealthF 0656Resident Assessment and Care Planning DeficienciesDevelop and implement a complete care plan that meets all the resident's needs, with timetables and actions that can be measured.DYesDeficient, Provider has date of correction28 February 2026
17 December 2025HealthF 0658Resident Assessment and Care Planning DeficienciesEnsure services provided by the nursing facility meet professional standards of quality.DYesDeficient, Provider has date of correction28 February 2026
27 October 2025HealthF 0684Quality of Life and Care DeficienciesProvide appropriate treatment and care according to orders, resident’s preferences and goals.GYesDeficient, Provider has date of correction30 January 2026
27 October 2025HealthF 0712Nursing and Physician Services DeficienciesEnsure that the resident and his/her doctor meet face-to-face at all required visits.EYesDeficient, Provider has date of correction30 January 2026
26 June 2025HealthF 0609Freedom from Abuse, Neglect, and Exploitation DeficienciesTimely report suspected abuse, neglect, or theft and report the results of the investigation to proper authorities.DYesDeficient, Provider has date of correction27 July 2025
25 June 2025HealthF 0755Pharmacy Service DeficienciesProvide pharmaceutical services to meet the needs of each resident and employ or obtain the services of a licensed pharmacist.DYesDeficient, Provider has date of correction1 September 2025
12 June 2025HealthF 0658Resident Assessment and Care Planning DeficienciesEnsure services provided by the nursing facility meet professional standards of quality.DNoDeficient, Provider has date of correction3 July 2025
12 June 2025HealthF 0684Quality of Life and Care DeficienciesProvide appropriate treatment and care according to orders, resident’s preferences and goals.DNoDeficient, Provider has date of correction3 July 2025
12 June 2025HealthF 0727Nursing and Physician Services DeficienciesHave a registered nurse on duty 8 hours a day; and select a registered nurse to be the director of nurses on a full time basis.FNoDeficient, Provider has date of correction3 July 2025
12 June 2025HealthF 0790Quality of Life and Care DeficienciesProvide routine and 24-hour emergency dental care for each resident.DNoDeficient, Provider has date of correction3 July 2025
12 June 2025HealthF 0812Nutrition and Dietary DeficienciesProcure food from sources approved or considered satisfactory and store, prepare, distribute and serve food in accordance with professional standards.FNoDeficient, Provider has date of correction3 July 2025
7 April 2025HealthF 0585Resident Rights DeficienciesHonor the resident's right to voice grievances without discrimination or reprisal and the facility must establish a grievance policy and make prompt efforts to resolve grievances.DYesDeficient, Provider has date of correction21 May 2025
7 April 2025HealthF 0679Quality of Life and Care DeficienciesProvide activities to meet all resident's needs.DYesDeficient, Provider has date of correction21 May 2025
25 November 2024HealthF 0689Quality of Life and Care DeficienciesEnsure that a nursing home area is free from accident hazards and provides adequate supervision to prevent accidents.GYesDeficient, Provider has date of correction25 January 2025
25 April 2024HealthF 0645Resident Assessment and Care Planning DeficienciesPASARR screening for Mental disorders or Intellectual DisabilitiesDYesDeficient, Provider has date of correction20 May 2024
25 April 2024HealthF 0676Quality of Life and Care DeficienciesEnsure residents do not lose the ability to perform activities of daily living unless there is a medical reason.DYesDeficient, Provider has date of correction20 May 2024
25 April 2024HealthF 0690Quality of Life and Care DeficienciesProvide appropriate care for residents who are continent or incontinent of bowel/bladder, appropriate catheter care, and appropriate care to prevent urinary tract infections.DYesDeficient, Provider has date of correction20 May 2024
25 April 2024HealthF 0725Nursing and Physician Services DeficienciesProvide enough nursing staff every day to meet the needs of every resident; and have a licensed nurse in charge on each shift.EYesDeficient, Provider has date of correction20 May 2024
25 April 2024HealthF 0807Nutrition and Dietary DeficienciesEnsure each resident receives and the facility provides drinks consistent with resident needs and preferences and sufficient to maintain resident hydration.DYesDeficient, Provider has date of correction20 May 2024
25 April 2024HealthF 0812Nutrition and Dietary DeficienciesProcure food from sources approved or considered satisfactory and store, prepare, distribute and serve food in accordance with professional standards.EYesDeficient, Provider has date of correction20 May 2024
25 April 2024HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.DYesDeficient, Provider has date of correction20 May 2024

From the Care Compare health citations file NH_HealthCitations_Aug2026.csv, processed on 1 August 2026.

Penalties

Penalty dateTypeFine amountPayment denial beganPayment denial, daysFine ID
27 October 2025Fine$21,548137146
27 October 2025Payment Denial8 January 202651
25 November 2024Fine$10,033131058

From the Care Compare penalties file NH_Penalties_Aug2026.csv, processed on 1 August 2026.

Care Compare provider information

FieldAs filed
Provider TypeMedicare and Medicaid
Ownership TypeGovernment - Hospital district
Legal Business NameKERN VALLEY HEALTHCARE DISTRICT
Date First Approved to Provide Medicare and Medicaid Services1992-07-30
Provider Resides in HospitalY
Continuing Care Retirement CommunityN
UrbanY
County/ParishKern
Telephone Number7603792681
Provider Changed Ownership in Last 12 MonthsN
With a Resident and Family CouncilResident
Automatic Sprinkler Systems in All Required AreasYes
Number of Certified Beds74
Average Number of Residents per Day55.7
Overall Rating2
Health Inspection Rating2
QM Rating5
Long-Stay QM Rating5
Processing Date2026-08-01

From the Care Compare Provider Information file NH_ProviderInfo_Aug2026.csv, processed on 1 August 2026.

Every change on this record

How to read this report

Every figure is printed as the CMS file it came from printed it. Each cost-report figure carries the worksheet, line and column of form CMS-2540 it was read from, so a reader holding the same public file can go to that cell; each Care Compare and Medicare enrollment section names its file and the date CMS stamped on it.

A figure the filing does not carry is left out, and so is a figure whose value the filing’s own arithmetic contradicts. Net income is printed with what the form’s own arithmetic shows about it — plainly where it follows from the lines above it, and, where it does not, beside what the form’s own lines leave unaccounted for. An ownership field left empty carries the dated sentence on CMS’s pause of the expanded Form CMS-855A disclosure. A source that holds nothing for this facility says so in its section.

This report carries no percentile and no score, and it does not place this facility above or below another. The five facilities above are the one comparison it draws: the nearest certified bed counts in the same state at the same fiscal year, listed by name. Nurse staffing is printed in its own section, on its own page, apart from the cost-report figures.

How to cite this report

Velarion Records, KERN VALLEY HEALTHCARE DISTRICT DP SNF — facility record report, CMS certification number 555517. https://velarionrecords.com/facility/555517/report.

Published by VELARIONAI LLC · Andrew Richardson, founder. Corrections: hello@velarionrecords.com, quoting certification number 555517. Velarion Records publishes these records as filed.

Nurse staffing, quarter by quarter

Hours this facility reported to CMS’s Payroll-Based Journal, one row per quarter, oldest first, each with how its figures are derived and the file it came from.

Nurse staffing hours by quarter
QuarterQuarter endedDays reportedResident daysRegistered nurse hoursLicensed practical nurse hoursNurse aide hoursTotal nurse hours
2017Q131 March 2017906,3152,766.294,904.1413,357.5721,028
2017Q230 June 2017916,2632,333.335,524.5812,542.9520,400.86
2017Q330 September 2017926,2932,374.075,795.4512,069.1120,238.63
2017Q431 December 2017926,1122,643.45,324.0911,497.4619,464.95
2018Q131 March 2018905,1562,331.734,906.412,415.4219,653.55
2018Q230 June 2018915,2301,536.015,609.7614,869.6822,015.45
2018Q330 September 2018925,2591,591.435,808.1713,275.9120,675.51
2018Q431 December 2018925,207755.895,634.0413,886.1320,276.06
2019Q431 December 2019924,8951,115.35,804.4810,730.3617,650.14
2020Q131 March 2020914,9621,325.66,020.8611,082.1518,428.61
2020Q230 June 2020914,9251,265.716,058.111,922.519,246.31
2020Q330 September 2020924,6301,116.76,134.9910,698.117,949.79
2020Q431 December 2020924,4171,167.656,093.458,429.4715,690.57
2021Q131 March 2021904,5631,407.76,342.798,578.9916,329.48
2021Q230 June 2021914,4821,015.664,265.8710,063.1815,344.71
2021Q431 December 2021924,247946.923,953.848,928.9113,829.67
2022Q131 March 2022904,0861,272.14,027.299,277.4814,576.87
2022Q230 June 2022914,204854.94,023.079,775.2114,653.18
2022Q330 September 2022924,279861.34,114.1610,451.5615,427.02
2022Q431 December 2022924,161750.83,742.8610,853.6415,347.3
2023Q131 March 2023903,8501,188.83,963.139,260.4714,412.4
2023Q230 June 2023913,8691,360.93,644.949,051.0714,056.91
2023Q330 September 2023923,6861,122.63,729.168,359.6613,211.42
2023Q431 December 2023923,8331,2823,837.027,949.2213,068.24
2024Q131 March 2024914,026870.764,331.018,232.7913,434.56
2024Q230 June 2024914,160848.874,766.637,989.3813,604.88
2024Q330 September 2024924,272879.754,964.069,503.2715,347.08
2024Q431 December 2024924,101499.84,706.7310,619.5415,826.07
2025Q131 March 2025904,416594.334,734.3610,680.2916,008.98
2025Q230 June 2025914,636659.875,230.0310,625.116,515
2025Q330 September 2025924,778739.245,166.6310,629.4616,535.33
2025Q431 December 2025924,8851,051.975,237.1310,482.6216,771.72
2026Q131 March 2026905,012922.334,219.211,820.5116,962.04
Nurse staffing hours per resident day by quarter
QuarterRegistered nurse hours per resident dayLicensed practical nurse hours per resident dayNurse aide hours per resident dayTotal nurse hours per resident day
2017Q10.4380510.7765862.1152133.32985
2017Q20.3725580.8820982.0027063.257362
2017Q30.3772560.9209361.9178633.216054
2017Q40.4324930.8710881.8811293.18471
2018Q10.4522360.951592.4079563.811782
2018Q20.2936921.0726122.8431514.209455
2018Q30.3026111.1044252.5244173.931453
2018Q40.1451681.0820132.666823.894
2019Q40.2278451.1857982.1921063.605749
2020Q10.267151.2133942.2334043.713948
2020Q20.2569971.2300712.4208123.90788
2020Q30.2411881.3250522.3106053.876844
2020Q40.2643541.3795451.9084153.552314
2021Q10.3085031.3900481.8801213.578672
2021Q20.2266090.9517782.2452433.42363
2021Q40.2229620.9309722.1024043.256339
2022Q10.3113310.9856312.2705533.567516
2022Q20.2033540.9569622.3252163.485533
2022Q30.2012850.9614772.4425243.605286
2022Q40.1804370.899512.6084213.688368
2023Q10.3087791.0293842.4053173.743481
2023Q20.3517450.9420882.3393823.633215
2023Q30.3045581.0117092.2679493.584216
2023Q40.3344641.0010492.073893.409403
2024Q10.2162841.075762.0449063.33695
2024Q20.2040551.1458251.9205243.270404
2024Q30.2059341.1619992.2245483.592481
2024Q40.1218731.1477032.58953.859076
2025Q10.1345861.0720922.4185443.625222
2025Q20.1423361.1281342.2918683.562338
2025Q30.1547171.0813372.2246673.460722
2025Q40.2153471.0720842.1458793.43331
2026Q10.1840240.841822.3584423.384286

How each quarter is derived, and its file

  • 2017Q1: 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: 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: 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: 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: 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: 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: 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: 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
  • 2019Q4: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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

← the facility’s full record