ESSENTIA HEALTH NORTHERN PINES MEDICAL CENTER

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 NORTHERN PINES MEDICAL CENTER (enrollment ID O20090603000100).

Changes in ownership

• 1 July 2026: BRADLEY J BEARD 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: BRADLEY J BEARD 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: BRADLEY J BEARD no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: AMY BERGSTROM no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: MARK BORTNEM no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: KRISTA ANN SKORUPA no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: AMY BERGSTROM appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: KRISTA ANN SKORUPA appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 March 2026: JAN LINSE BALDWIN no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-03-01.csv
• 1 March 2026: JEANNE WEBER no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-03-01.csv
• 1 March 2026: BEVERLY RAWAY no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-03-01.csv
• 1 March 2026: BRUCE SMITH appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-03-01.csv
• 1 March 2026: JUSTIN TERCH appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-03-01.csv
• 1 November 2025: TRACI MORRIS no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-11-01.csv
• 1 November 2025: MARK BORTNEM appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-11-01.csv
• 1 June 2025: CHRISTOPHER T WHITING no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: JOSEPH MIHALEK no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: KEVIN S BOREN no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: BRADLEY J BEARD no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: THERESE CARSON no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: ALAN ROCK no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: DIANA KALLBERG no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: NANCY ARONSON NORR appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: CHRISTOPHER T WHITING appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: CHRISTOPHER T WHITING appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: KEVIN S BOREN appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: KEVIN S BOREN appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: BRADLEY J BEARD appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: BRADLEY J BEARD appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: ST MARYS DULUTH CLINIC HEALTH SYSTEM appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: ESSENTIA HEALTH appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: REBECCA URBANSKI appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: THOMAS JAMAR appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: ADAM BACHAND appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: DIANA KALLBERG appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: DIANA KALLBERG appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: ANTHONY SERTICH appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 September 2024: LAURA ACKMAN no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-09-01.csv
• 1 September 2024: DIANA KALLBERG appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-09-01.csv
• 1 July 2024: WILLIAM HEEGAARD no longer appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-07-01.csv
• 1 July 2024: KRISTA ANN SKORUPA appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-07-01.csv
• 1 May 2024: HARA CHARLIER no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-05-01.csv
• 1 May 2024: RENEE WACHTER no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-05-01.csv
• 1 May 2024: CHRISTOPHER T WHITING appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-05-01.csv
• 1 May 2024: GEORGE LOBAN appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-05-01.csv
• 1 May 2024: AMY BERGSTROM appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-05-01.csv
• 2 October 2023: JON L PRYOR no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: LAURA JEAN TROMBINO no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: KEVIN S BOREN no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: ST MARYS DULUTH CLINIC HEALTH SYSTEM no longer appears as 5% OR GREATER DIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: JEFFREY COREY no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: THOMAS RENIER no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: HOWARD T KLATZKY no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: JOSEPH LEONI no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: HARA CHARLIER appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: MICHAEL WATTERS appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: TROY DUININCK appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: KEVIN S BOREN appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: BRADLEY J BEARD appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: BRADLEY J BEARD appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: TRACI MORRIS appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: ESSENTIA HEALTH appears as 5% OR GREATER DIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: ANTHONY YUNG appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: WILLIAM HEEGAARD appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv

Inspections

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

Deficiencies cited

Penalties

Not yet extracted for this facility.

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: BRADLEY J BEARD 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: BRADLEY J BEARD 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: BRADLEY J BEARD no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: AMY BERGSTROM no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: MARK BORTNEM no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: KRISTA ANN SKORUPA no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: AMY BERGSTROM appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 July 2026: KRISTA ANN SKORUPA appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
• 1 March 2026: JAN LINSE BALDWIN no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-03-01.csv
• 1 March 2026: JEANNE WEBER no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-03-01.csv
• 1 March 2026: BEVERLY RAWAY no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-03-01.csv
• 1 March 2026: BRUCE SMITH appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-03-01.csv
• 1 March 2026: JUSTIN TERCH appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-03-01.csv
• 1 November 2025: TRACI MORRIS no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-11-01.csv
• 1 November 2025: MARK BORTNEM appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-11-01.csv
• 1 June 2025: CHRISTOPHER T WHITING no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: JOSEPH MIHALEK no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: KEVIN S BOREN no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: BRADLEY J BEARD no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: THERESE CARSON no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: ALAN ROCK no longer appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: DIANA KALLBERG no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: NANCY ARONSON NORR appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: CHRISTOPHER T WHITING appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: CHRISTOPHER T WHITING appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: KEVIN S BOREN appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: KEVIN S BOREN appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: BRADLEY J BEARD appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: BRADLEY J BEARD appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: ST MARYS DULUTH CLINIC HEALTH SYSTEM appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: ESSENTIA HEALTH appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: REBECCA URBANSKI appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: THOMAS JAMAR appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: ADAM BACHAND appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: DIANA KALLBERG appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: DIANA KALLBERG appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 June 2025: ANTHONY SERTICH appears as CORPORATE DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2025-06-01.csv
• 1 September 2024: LAURA ACKMAN no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-09-01.csv
• 1 September 2024: DIANA KALLBERG appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-09-01.csv
• 1 July 2024: WILLIAM HEEGAARD no longer appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-07-01.csv
• 1 July 2024: KRISTA ANN SKORUPA appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-07-01.csv
• 1 May 2024: HARA CHARLIER no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-05-01.csv
• 1 May 2024: RENEE WACHTER no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-05-01.csv
• 1 May 2024: CHRISTOPHER T WHITING appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-05-01.csv
• 1 May 2024: GEORGE LOBAN appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-05-01.csv
• 1 May 2024: AMY BERGSTROM appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2024-05-01.csv
• 2 October 2023: JON L PRYOR no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: LAURA JEAN TROMBINO no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: KEVIN S BOREN no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: ST MARYS DULUTH CLINIC HEALTH SYSTEM no longer appears as 5% OR GREATER DIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: JEFFREY COREY no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: THOMAS RENIER no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: HOWARD T KLATZKY no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: JOSEPH LEONI no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: HARA CHARLIER appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: MICHAEL WATTERS appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: TROY DUININCK appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: KEVIN S BOREN appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: BRADLEY J BEARD appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: BRADLEY J BEARD appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: TRACI MORRIS appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: ESSENTIA HEALTH appears as 5% OR GREATER DIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: ANTHONY YUNG appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.csv
• 2 October 2023: WILLIAM HEEGAARD appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-10-02.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
• 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
• 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
• 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
• 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