MAYO CLINIC HEALTH SYSTEM - LAKE CITY

Ownership, as filed with CMS

Care Compare

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

Medicare enrollment

As filed in the CMS file dated 1 August 2026 (Medicare enrollment ownership), under the enrollment of MAYO CLINIC HEALTH SYSTEM-LAKE CITY (enrollment ID O20100901000268).

Changes in ownership

• 1 July 2026: KATHERINE BAICKER no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: CHRISTINA ZORN no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS no longer appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: NNEKA COMFERE no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: CHARLES SMITH no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: AMY HARA no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: TARYN SCHRUTH no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RAFAEL FONSECA no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: KATHERINE BAICKER appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: CHRISTINA ZORN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: NNEKA COMFERE appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: CHARLES SMITH appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: AMY HARA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: TARYN SCHRUTH appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RAFAEL FONSECA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 April 2026: PAUL M ROBELIA no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: CINDY MCGRATH no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: ROBERT ALBRIGHT no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: KATIE E HINDERAKER appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: KARTHIK GHOSH appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: MEGAN KRAMER appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: TARYN SCHRUTH appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 September 2025: MACKENZIE J CHRISTOPHER no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MAYO CLINIC HEALTH SYSTEM-SOUTHEAST MINNESOTA REGION no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ERIC D CROCKETT no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: LAURA A FISHER no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ROBERT C ALBRIGHT no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: JAMES ROBO appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MORRIS MILLER appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: AMY WILLIAMS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: JAMES FRANCIS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MACKENZIE HARNISCH appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MACKENZIE HARNISCH appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: TRENT ANDERSON appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ALBERT HARRIS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: NANCY PERETSMAN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MARTINE ROTHBLATT appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: SYED KHAN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ROBIN ROBERTS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: BETHANIE FLATTUM appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: GIANRICO FARRUGIA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: DOUGLAS BAKER appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: DENNIS DAHLEN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: PAUL GORMAN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: BRIAN BARTLETT appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: KRISTIN PECK appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MICHAEL SHANNON appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: SALLY ANNE BROWN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: GEORGE BILICIC appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: GOKHAN ANIL appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: TAYLOR BEAHRS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: BRIAN LYNCH appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: KENT THIELEN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MANSI KANUGA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ABIMBOLA FAMUYIDE appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: URSULA BURNS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: AJANI DUNN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: JAY ALIX appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: TARA KROSCH appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: TODD WILLETT appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: RICHARD DAVIS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ERIC SCHMIDT appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: TRAVIS PAUL appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: BRETT ANDERSON appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MICHAEL POWELL appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: RICHARD GRAY appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: CHARANJIT RIHAL appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MATTHEW CALLSTROM appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: JED DAVIS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ROSHANAK DIDEHBAN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: SHERRY HUBERT appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: NATALIE CAINE appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: DONALD REMY appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: SARAH MCLAUGHLIN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: JULIE GERBERDING appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: DENA KEILMAN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: LISA ARCHER appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ANNE SWEENEY appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ROBERT ALBRIGHT appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: KATHERINE BAICKER appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: CHRISTINA ZORN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: RANDY M FOSS appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: RANDY M FOSS appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: NNEKA COMFERE appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: CHARLES SMITH appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: AMY HARA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: RAFAEL FONSECA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 November 2024: RUSSELL BOE no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-11-01.csv
• 1 November 2024: BRIAN WHITED no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-11-01.csv
• 1 November 2024: CINDY MCGRATH appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-11-01.csv
• 15 September 2023: JOHN GRUBER no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 15 September 2023: MAYO CLINIC no longer appears as 5% OR GREATER DIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 15 September 2023: PRAVEEN MEKALA no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 15 September 2023: BOBBIE SMITH GOSTOUT no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 15 September 2023: MORRIS RICK MILLER appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 15 September 2023: KATHLEEN DURAND appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 31 October 2022: PRAVEEN MEKALA no longer appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2022-10-31.csv
• 31 October 2022: PRAVEEN MEKALA appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2022-10-31.csv

Inspections

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

Deficiencies cited

Penalties

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

Care Compare provider information

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

Every change on this record

• 1 July 2026: KATHERINE BAICKER no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: CHRISTINA ZORN no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS no longer appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: NNEKA COMFERE no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: CHARLES SMITH no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: AMY HARA no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: TARYN SCHRUTH no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RAFAEL FONSECA no longer appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: KATHERINE BAICKER appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: CHRISTINA ZORN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RANDY M FOSS appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: NNEKA COMFERE appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: CHARLES SMITH appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: AMY HARA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: TARYN SCHRUTH appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: RAFAEL FONSECA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 April 2026: PAUL M ROBELIA no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: CINDY MCGRATH no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: ROBERT ALBRIGHT no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: KATIE E HINDERAKER appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: KARTHIK GHOSH appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: MEGAN KRAMER appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 April 2026: TARYN SCHRUTH appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-04-01.csv
• 1 September 2025: MACKENZIE J CHRISTOPHER no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MAYO CLINIC HEALTH SYSTEM-SOUTHEAST MINNESOTA REGION no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ERIC D CROCKETT no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: LAURA A FISHER no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ROBERT C ALBRIGHT no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: JAMES ROBO appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MORRIS MILLER appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: AMY WILLIAMS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: JAMES FRANCIS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MACKENZIE HARNISCH appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MACKENZIE HARNISCH appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: TRENT ANDERSON appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ALBERT HARRIS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: NANCY PERETSMAN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MARTINE ROTHBLATT appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: SYED KHAN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ROBIN ROBERTS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: BETHANIE FLATTUM appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: GIANRICO FARRUGIA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: DOUGLAS BAKER appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: DENNIS DAHLEN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: PAUL GORMAN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: BRIAN BARTLETT appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: KRISTIN PECK appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MICHAEL SHANNON appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: SALLY ANNE BROWN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: GEORGE BILICIC appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: GOKHAN ANIL appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: TAYLOR BEAHRS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: BRIAN LYNCH appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: KENT THIELEN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MANSI KANUGA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ABIMBOLA FAMUYIDE appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: URSULA BURNS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: AJANI DUNN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: JAY ALIX appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: TARA KROSCH appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: TODD WILLETT appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: RICHARD DAVIS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ERIC SCHMIDT appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: TRAVIS PAUL appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: BRETT ANDERSON appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MICHAEL POWELL appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: RICHARD GRAY appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: CHARANJIT RIHAL appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: MATTHEW CALLSTROM appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: JED DAVIS appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ROSHANAK DIDEHBAN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: SHERRY HUBERT appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: NATALIE CAINE appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: DONALD REMY appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: SARAH MCLAUGHLIN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: JULIE GERBERDING appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: DENA KEILMAN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: LISA ARCHER appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ANNE SWEENEY appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: ROBERT ALBRIGHT appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: KATHERINE BAICKER appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: CHRISTINA ZORN appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: RANDY M FOSS appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: RANDY M FOSS appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: NNEKA COMFERE appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: CHARLES SMITH appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: AMY HARA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 September 2025: RAFAEL FONSECA appears as MANAGING CONTROL - GOVERNING BODY in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-09-01.csv
• 1 November 2024: RUSSELL BOE no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-11-01.csv
• 1 November 2024: BRIAN WHITED no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-11-01.csv
• 1 November 2024: CINDY MCGRATH appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-11-01.csv
• 15 September 2023: JOHN GRUBER no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 15 September 2023: MAYO CLINIC no longer appears as 5% OR GREATER DIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 15 September 2023: PRAVEEN MEKALA no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 15 September 2023: BOBBIE SMITH GOSTOUT no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 15 September 2023: MORRIS RICK MILLER appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 15 September 2023: KATHLEEN DURAND appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-09-15.csv
• 31 October 2022: PRAVEEN MEKALA no longer appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2022-10-31.csv
• 31 October 2022: PRAVEEN MEKALA appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2022-10-31.csv

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.

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