Velarion Records

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

Facility record report · CMS certification number 125026

KUAKINI GERIATRIC CARE, INC

HONOLULU, Hawaii · 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
KUAKINI HEALTH SYSTEM5% OR GREATER DIRECT OWNERSHIP INTERESTOrganization100%since 07/07/1983
AI, STEVENCORPORATE DIRECTORIndividualNOT APPLICABLEsince 01/01/2014
OISHI, GREGGTRUSTEE OF THE SNFIndividualNOT APPLICABLEsince 04/01/2024
OISHI, GREGGW-2 MANAGING EMPLOYEEIndividualNOT APPLICABLEsince 04/01/2024

Medicare enrollment

As filed in the CMS file dated 1 August 2026 (Medicare enrollment ownership), under the enrollment of KUAKINI GERIATRIC CARE, INC. (enrollment ID O20160105000817).

OwnerIndividual or organizationRoleOwnership percentageAssociation dateDescribed in the filing as
KUAKINI HEALTH SYSTEMOrganization5% OR GREATER DIRECT OWNERSHIP INTEREST1007/7/1983
Private equity company: No
Real estate investment trust: No
Holding company: No
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.IndividualADP 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/2/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.
STEVEN AIIndividualCORPORATE DIRECTOR01/1/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.
GREGG Y OISHIIndividualTRUSTEE 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.4/1/2024
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.
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.IndividualTRUSTEE 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.4/1/2024
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.
GREGG Y OISHIIndividualW-2 MANAGING EMPLOYEE1004/1/2024
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
18 January 20258 January 2025110
212 January 202412 January 202490
313 January 202313 January 2023391

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

Deficiencies cited

59 deficiencies on file, newest inspection first
Inspection dateInspection typeTagCategoryWhat was citedScope and severityComplaintCorrectedCorrection date
12 June 2026HealthF 0628Resident Rights DeficienciesProvide the required documentation or notification related to the resident's needs, appeal rights, or bed-hold policies.EYesDeficient, Provider has date of correction2 July 2026
12 June 2026HealthF 0641Resident Assessment and Care Planning DeficienciesEnsure each resident receives an accurate assessment.DYesDeficient, Provider has date of correction2 July 2026
12 June 2026HealthF 0684Quality of Life and Care DeficienciesProvide appropriate treatment and care according to orders, resident’s preferences and goals.GYesDeficient, Provider has date of correction2 July 2026
12 June 2026HealthF 0689Quality of Life and Care DeficienciesEnsure that a nursing home area is free from accident hazards and provides adequate supervision to prevent accidents.DYesDeficient, Provider has date of correction2 July 2026
8 January 2025HealthF 0552Resident Rights DeficienciesEnsure that residents are fully informed and understand their health status, care and treatments.DNoDeficient, Provider has date of correction4 February 2025
8 January 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.DNoDeficient, Provider has date of correction6 March 2025
8 January 2025HealthF 0684Quality of Life and Care DeficienciesProvide appropriate treatment and care according to orders, resident’s preferences and goals.DNoDeficient, Provider has date of correction6 March 2025
8 January 2025HealthF 0693Quality of Life and Care DeficienciesEnsure that feeding tubes are not used unless there is a medical reason and the resident agrees; and provide appropriate care for a resident with a feeding tube.DNoDeficient, Provider has date of correction6 March 2025
8 January 2025HealthF 0695Quality of Life and Care DeficienciesProvide safe and appropriate respiratory care for a resident when needed.DNoDeficient, Provider has date of correction7 February 2025
8 January 2025HealthF 0812Nutrition and Dietary DeficienciesProcure food from sources approved or considered satisfactory and store, prepare, distribute and serve food in accordance with professional standards.LNoDeficient, Provider has date of correction7 February 2025
8 January 2025HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.DNoDeficient, Provider has date of correction7 February 2025
19 July 2024HealthF 0580Resident Rights DeficienciesImmediately tell the resident, the resident's doctor, and a family member of situations (injury/decline/room, etc.) that affect the resident.EYesDeficient, Provider has date of correction4 October 2024
19 July 2024HealthF 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.EYesDeficient, Provider has date of correction4 October 2024
19 July 2024HealthF 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 correction4 October 2024
19 July 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.DYesDeficient, Provider has date of correction4 October 2024
19 July 2024HealthF 0726Nursing and Physician Services DeficienciesEnsure that nurses and nurse aides have the appropriate competencies to care for every resident in a way that maximizes each resident's well being.DYesDeficient, Provider has date of correction4 October 2024
19 July 2024HealthF 0842Resident Assessment and Care Planning DeficienciesSafeguard resident-identifiable information and/or maintain medical records on each resident that are in accordance with accepted professional standards.DYesDeficient, Provider has date of correction4 October 2024
29 February 2024HealthF 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 correction8 April 2024
29 February 2024HealthF 0657Resident Assessment and Care Planning DeficienciesDevelop the complete care plan within 7 days of the comprehensive assessment; and prepared, reviewed, and revised by a team of health professionals.DYesPast Non-Compliance29 February 2024
29 February 2024HealthF 0726Nursing and Physician Services DeficienciesEnsure that nurses and nurse aides have the appropriate competencies to care for every resident in a way that maximizes each resident's well being.GYesPast Non-Compliance29 February 2024
12 January 2024HealthF 0552Resident Rights DeficienciesEnsure that residents are fully informed and understand their health status, care and treatments.DNoDeficient, Provider has date of correction16 February 2024
12 January 2024HealthF 0623Resident Rights DeficienciesProvide timely notification to the resident, and if applicable to the resident representative and ombudsman, before transfer or discharge, including appeal rights.FNoDeficient, Provider has date of correction16 February 2024
12 January 2024HealthF 0625Resident Rights DeficienciesNotify the resident or the resident’s representative in writing how long the nursing home will hold the resident’s bed in cases of transfer to a hospital or therapeutic leave.FNoDeficient, Provider has date of correction16 February 2024
12 January 2024HealthF 0657Resident Assessment and Care Planning DeficienciesDevelop the complete care plan within 7 days of the comprehensive assessment; and prepared, reviewed, and revised by a team of health professionals.DNoDeficient, Provider has date of correction16 February 2024
12 January 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.DNoDeficient, Provider has date of correction16 February 2024
12 January 2024HealthF 0726Nursing and Physician Services DeficienciesEnsure that nurses and nurse aides have the appropriate competencies to care for every resident in a way that maximizes each resident's well being.DNoDeficient, Provider has date of correction16 February 2024
12 January 2024HealthF 0761Pharmacy Service DeficienciesEnsure drugs and biologicals used in the facility are labeled in accordance with currently accepted professional principles; and all drugs and biologicals must be stored in locked compartments, separately locked, compartments for controlled drugs.DNoDeficient, Provider has date of correction16 February 2024
12 January 2024HealthF 0812Nutrition and Dietary DeficienciesProcure food from sources approved or considered satisfactory and store, prepare, distribute and serve food in accordance with professional standards.DNoDeficient, Provider has date of correction16 February 2024
12 January 2024HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.FNoDeficient, Provider has date of correction16 February 2024
13 January 2023HealthF 0558Resident Rights DeficienciesReasonably accommodate the needs and preferences of each resident.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0578Resident Rights DeficienciesHonor the resident's right to request, refuse, and/or discontinue treatment, to participate in or refuse to participate in experimental research, and to formulate an advance directive.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0584Resident Rights DeficienciesHonor the resident's right to a safe, clean, comfortable and homelike environment, including but not limited to receiving treatment and supports for daily living safely.ENoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 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.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0636Resident Assessment and Care Planning DeficienciesAssess the resident completely in a timely manner when first admitted, and then periodically, at least every 12 months.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0640Resident Assessment and Care Planning DeficienciesEncode each resident’s assessment data and transmit these data to the State within 7 days of assessment.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0641Resident Assessment and Care Planning DeficienciesEnsure each resident receives an accurate assessment.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0655Resident Assessment and Care Planning DeficienciesCreate and put into place a plan for meeting the resident's most immediate needs within 48 hours of being admittedDNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 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.ENoDeficient, Provider has date of correction19 April 2023
13 January 2023HealthF 0657Resident Assessment and Care Planning DeficienciesDevelop the complete care plan within 7 days of the comprehensive assessment; and prepared, reviewed, and revised by a team of health professionals.DNoDeficient, Provider has date of correction19 April 2023
13 January 2023HealthF 0677Quality of Life and Care DeficienciesProvide care and assistance to perform activities of daily living for any resident who is unable.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0684Quality of Life and Care DeficienciesProvide appropriate treatment and care according to orders, resident’s preferences and goals.DNoDeficient, Provider has date of correction19 April 2023
13 January 2023HealthF 0686Quality of Life and Care DeficienciesProvide appropriate pressure ulcer care and prevent new ulcers from developing.DNoDeficient, Provider has date of correction19 April 2023
13 January 2023HealthF 0689Quality of Life and Care DeficienciesEnsure that a nursing home area is free from accident hazards and provides adequate supervision to prevent accidents.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 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.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0692Quality of Life and Care DeficienciesProvide enough food/fluids to maintain a resident's health.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0693Quality of Life and Care DeficienciesEnsure that feeding tubes are not used unless there is a medical reason and the resident agrees; and provide appropriate care for a resident with a feeding tube.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0697Quality of Life and Care DeficienciesProvide safe, appropriate pain management for a resident who requires such services.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 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.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0726Nursing and Physician Services DeficienciesEnsure that nurses and nurse aides have the appropriate competencies to care for every resident in a way that maximizes each resident's well being.ENoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 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 correction28 February 2023
13 January 2023HealthF 0756Pharmacy Service DeficienciesEnsure a licensed pharmacist perform a monthly drug regimen review, including the medical chart, following irregularity reporting guidelines in developed policies and procedures.JNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0758Pharmacy Service DeficienciesImplement gradual dose reductions(GDR) and non-pharmacological interventions, unless contraindicated, prior to initiating or instead of continuing psychotropic medication; and PRN orders for psychotropic medications are only used when the medication is necessary and PRN use is limited.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0791Quality of Life and Care DeficienciesProvide or obtain dental services for each resident.ENoDeficient, Provider has date of correction19 April 2023
13 January 2023HealthF 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 correction28 February 2023
13 January 2023HealthF 0835Administration DeficienciesAdminister the facility in a manner that enables it to use its resources effectively and efficiently.ENoDeficient, Provider has date of correction19 April 2023
13 January 2023HealthF 0838Administration DeficienciesConduct and document a facility-wide assessment to determine what resources are necessary to care for residents competently during both day-to-day operations (including nights and weekends) and emergencies.FNoDeficient, Provider has date of correction19 April 2023
13 January 2023HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.FNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0883Infection Control DeficienciesDevelop and implement policies and procedures for flu and pneumonia vaccinations.DNoDeficient, Provider has date of correction28 February 2023
13 January 2023HealthF 0886Infection Control DeficienciesPerform COVID19 testing on residents and staff.FNoDeficient, Provider has date of correction28 February 2023

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
12 June 2026Fine$15,185141015
8 January 2025Fine$52,781131612
29 February 2024Fine$30,455131603

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 TypeNon profit - Corporation
Legal Business NameKUAKINI GERIATRIC CARE, INC.
Date First Approved to Provide Medicare and Medicaid Services1976-07-01
Provider Resides in HospitalN
Continuing Care Retirement CommunityN
UrbanY
County/ParishHonolulu
Telephone Number8085479357
Special Focus StatusSFF Candidate
Provider Changed Ownership in Last 12 MonthsN
With a Resident and Family CouncilResident
Automatic Sprinkler Systems in All Required AreasYes
Number of Certified Beds187
Average Number of Residents per Day131.4
Overall Rating1
Health Inspection Rating1
QM Rating4
Long-Stay QM Rating3
Short-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 at a stated confidence, saying what is left unaccounted for, where it does not. 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, KUAKINI GERIATRIC CARE, INC — facility record report, CMS certification number 125026. https://velarionrecords.com/facility/125026/report.

Published by VELARIONAI LLC · Andrew Richardson, founder. Corrections: hello@velarionrecords.com, quoting certification number 125026. 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 20179018,17112,905.368,343.0933,593.7454,842.19
2017Q230 June 20179115,41713,049.518,353.732,533.7653,936.97
2017Q330 September 20179214,61813,412.078,442.7833,141.9154,996.76
2017Q431 December 20179215,13313,901.747,542.0132,645.6154,089.36
2018Q131 March 20189014,69614,848.388,221.0231,279.1754,348.57
2018Q230 June 20189115,93815,220.517,960.7530,924.0654,105.32
2018Q330 September 20189215,86413,736.228,554.2531,018.3153,308.78
2018Q431 December 20189214,96813,488.28,391.6330,307.4552,187.28
2019Q131 March 20199013,73512,309.788,927.8530,799.4652,037.09
2019Q230 June 20199114,53612,924.7110,663.3330,037.1653,625.2
2019Q330 September 20199214,23012,129.179,758.1930,251.6752,139.03
2019Q431 December 20199214,13913,3168,816.4627,666.9549,799.41
2020Q131 March 20209112,99714,114.858,330.8426,155.6848,601.37
2020Q230 June 20209111,93615,017.067,615.326,316.0648,948.42
2020Q330 September 20209212,05814,018.357,169.4827,607.2848,795.11
2020Q431 December 20209212,19814,3396,906.4629,145.4350,390.89
2021Q131 March 20219012,66815,548.526,076.4126,882.2248,507.15
2021Q230 June 20219112,80815,602.365,492.7225,536.3646,631.44
2021Q330 September 20219212,65916,226.035,529.3225,165.4346,920.78
2021Q431 December 20219213,31115,862.844,719.7325,555.8946,138.46
2022Q131 March 20229011,81515,639.863,237.5323,543.5542,420.94
2022Q230 June 20229111,37314,485.163,458.3523,774.2541,717.76
2022Q330 September 20229210,64313,882.723,687.2922,678.9140,248.92
2022Q431 December 20229210,43512,758.13,809.8922,053.4238,621.41
2023Q131 March 2023909,81112,598.843,529.8222,642.9438,771.6
2023Q230 June 2023919,89312,873.613,412.3423,003.6439,289.59
2023Q330 September 2023929,33212,443.073,796.523,139.9639,379.53
2023Q431 December 2023929,49914,635.413,459.2622,107.2540,201.92
2024Q131 March 2024919,66713,862.583,306.4620,504.0437,673.08
2024Q230 June 2024919,95113,787.33,688.6119,647.0537,122.96
2024Q330 September 20249210,04114,282.213,355.9119,249.7536,887.87
2024Q431 December 2024929,88114,680.843,502.3720,951.6539,134.86
2025Q131 March 20259010,39215,840.683,231.9621,263.3740,336.01
2025Q230 June 20259110,51915,862.853,659.9520,426.3539,949.15
2025Q330 September 20259211,62115,432.023,854.820,629.9339,916.75
2025Q431 December 20259211,75714,756.514,853.3219,791.9539,401.78
2026Q131 March 20269011,82616,528.484,282.5119,751.6540,562.64
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.7102170.4591431.8487563.018116
2017Q20.8464360.541852.1102523.498539
2017Q30.9175040.5775612.2671993.762263
2017Q40.9186370.4983822.1572463.574266
2018Q11.0103690.5594052.1284143.698188
2018Q20.9549820.4994821.9402723.394737
2018Q30.8658740.5392241.9552643.360362
2018Q40.9011360.5606382.0248163.48659
2019Q10.8962340.6500072.2424073.788649
2019Q20.8891520.7335812.0663983.68913
2019Q30.8523660.6857482.1259083.664022
2019Q40.9417920.6235561.9567833.522131
2020Q11.0860080.6409822.012443.73943
2020Q21.2581320.6380112.2047644.100907
2020Q31.1625770.5945832.2895414.0467
2020Q41.1755210.5661962.3893614.131078
2021Q11.2273860.4796662.1220573.829109
2021Q21.2181730.4288511.9937823.640806
2021Q31.2817780.436791.9879483.706516
2021Q41.1917090.3545741.9199083.46619
2022Q11.3237290.2740191.9926833.590431
2022Q21.2736450.3040842.0904123.66814
2022Q31.3043990.3464522.1308763.781727
2022Q41.2226260.3651072.1134093.701141
2023Q11.2841550.3597822.3079143.95185
2023Q21.3012850.3449252.3252443.971454
2023Q31.3333770.4068262.4796364.219838
2023Q41.5407320.3641712.3273244.232227
2024Q11.4340110.3420362.1210343.897081
2024Q21.3855190.3706771.9743793.730576
2024Q31.4223890.3342211.9171153.673725
2024Q41.4857650.3544552.1203983.960617
2025Q11.5243150.3110052.0461293.881448
2025Q21.5080190.3479371.9418533.797809
2025Q31.3279430.331711.7752283.434881
2025Q41.2551250.4128031.6834183.351346
2026Q11.3976390.3621271.6701893.429954

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
  • 2019Q1: 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: 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: 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: 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
  • 2021Q3: 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: 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