About this Dataset

Payroll Based Journal Daily Nurse Staffing

The Payroll Based Journal (PBJ) Nurse Staffing and Non-Nurse Staffing datasets provide information submitted by nursing homes including rehabilitation services on a quarterly basis. The View Data link above includes the hours staff are paid to work each day, for each facility, aggregated by staff reporting category. Examples of reporting categories include Director of Nursing, Administrative Registered Nurses, Registered Nursing, Administrative Licensed Practice Nurses, Licensed Practice Nurses, Certified Nurse Aides, Certified Medication Aides, and Nurse Aides in Training. There are also other non-nurse staff categories provided in the data such as Respiratory Therapist, Occupational Therapist, and Social Worker. The datasets also include a facility’s daily census calculated using the Minimum Data Set (MDS) submission.

The Payroll Based Journal (PBJ) Employee Detail Nursing Home Staffing datasets and technical information have been moved to a new location.

Note: This full dataset contains more records than most spreadsheet programs can handle, which will result in an incomplete load of data. Use of a database or statistical software is required.
Organization: U.S. Department of Health & Human Services
Last updated: 2022-01-25T02:04:13.457806
Tags: health-care-use-payments, hospitals-facilities, medicare, original-medicare, skilled-nursing

Tables

Payroll Based Journal Daily Nurse Staffing : 2017-03-31

@usgov.hhs_gov_payroll_based_journal_daily_nurse_staffing_94bbe.payroll_based_journal_daily_nurse_staffing_2017_03_31

29.71 MB
1253610 rows
33 columns


CREATE TABLE payroll_based_journal_daily_nurse_staffing_2017_03_31 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_rn_donadmin" DOUBLE,
  "hrs_rndon_emp" DOUBLE,
  "hrs_rndon_ctr" DOUBLE,
  "hrs_rnadmin" DOUBLE,
  "hrs_rnadmin_emp" DOUBLE,
  "hrs_rnadmin_ctr" DOUBLE,
  "hrs_rn" DOUBLE,
  "hrs_rn_emp" DOUBLE,
  "hrs_rn_ctr" DOUBLE,
  "hrs_lpn_admin" DOUBLE,
  "hrs_lpnadmin_emp" DOUBLE,
  "hrs_lpnadmin_ctr" DOUBLE,
  "hrs_lpn" DOUBLE,
  "hrs_lpn_emp" DOUBLE,
  "hrs_lpn_ctr" DOUBLE,
  "hrs_cna" DOUBLE,
  "hrs_cna_emp" DOUBLE,
  "hrs_cna_ctr" DOUBLE,
  "hrs_na_trn" DOUBLE,
  "hrs_natrn_emp" DOUBLE,
  "hrs_natrn_ctr" DOUBLE,
  "hrs_medaide" DOUBLE,
  "hrs_medaide_emp" DOUBLE,
  "hrs_medaide_ctr" DOUBLE
);

Payroll Based Journal Daily Nurse Staffing : 2017-06-30

@usgov.hhs_gov_payroll_based_journal_daily_nurse_staffing_94bbe.payroll_based_journal_daily_nurse_staffing_2017_06_30

30.08 MB
1272544 rows
33 columns


CREATE TABLE payroll_based_journal_daily_nurse_staffing_2017_06_30 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_rndon" DOUBLE,
  "hrs_rndon_emp" DOUBLE,
  "hrs_rndon_ctr" DOUBLE,
  "hrs_rnadmin" DOUBLE,
  "hrs_rnadmin_emp" DOUBLE,
  "hrs_rnadmin_ctr" DOUBLE,
  "hrs_rn" DOUBLE,
  "hrs_rn_emp" DOUBLE,
  "hrs_rn_ctr" DOUBLE,
  "hrs_lpn_admin" DOUBLE,
  "hrs_lpnadmin_emp" DOUBLE,
  "hrs_lpnadmin_ctr" DOUBLE,
  "hrs_lpn" DOUBLE,
  "hrs_lpn_emp" DOUBLE,
  "hrs_lpn_ctr" DOUBLE,
  "hrs_cna" DOUBLE,
  "hrs_cna_emp" DOUBLE,
  "hrs_cna_ctr" DOUBLE,
  "hrs_medaide" DOUBLE,
  "hrs_medaide_emp" DOUBLE,
  "hrs_rn_donadmin" DOUBLE,
  "hrs_na_trn" DOUBLE,
  "hrs_natrn_emp" DOUBLE,
  "hrs_natrn_ctr" DOUBLE
);

Payroll Based Journal Daily Nurse Staffing : 2017-09-30

@usgov.hhs_gov_payroll_based_journal_daily_nurse_staffing_94bbe.payroll_based_journal_daily_nurse_staffing_2017_09_30

31.7 MB
1331884 rows
33 columns


CREATE TABLE payroll_based_journal_daily_nurse_staffing_2017_09_30 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_rndon" DOUBLE,
  "hrs_rndon_emp" DOUBLE,
  "hrs_rndon_ctr" DOUBLE,
  "hrs_rnadmin" DOUBLE,
  "hrs_rnadmin_emp" DOUBLE,
  "hrs_rnadmin_ctr" DOUBLE,
  "hrs_rn" DOUBLE,
  "hrs_rn_emp" DOUBLE,
  "hrs_rn_ctr" DOUBLE,
  "hrs_lpn_admin" DOUBLE,
  "hrs_lpnadmin_emp" DOUBLE,
  "hrs_lpnadmin_ctr" DOUBLE,
  "hrs_lpn" DOUBLE,
  "hrs_lpn_emp" DOUBLE,
  "hrs_lpn_ctr" DOUBLE,
  "hrs_cna" DOUBLE,
  "hrs_cna_emp" DOUBLE,
  "hrs_cna_ctr" DOUBLE,
  "hrs_na_trn" DOUBLE,
  "hrs_natrn_emp" DOUBLE,
  "hrs_natrn_ctr" DOUBLE,
  "hrs_medaide" DOUBLE,
  "hrs_medaide_emp" DOUBLE,
  "hrs_medaide_ctr" DOUBLE
);

Payroll Based Journal Daily Nurse Staffing : 2017-12-31

@usgov.hhs_gov_payroll_based_journal_daily_nurse_staffing_94bbe.payroll_based_journal_daily_nurse_staffing_2017_12_31

30.97 MB
1301064 rows
33 columns


CREATE TABLE payroll_based_journal_daily_nurse_staffing_2017_12_31 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_rndon" DOUBLE,
  "hrs_rndon_emp" DOUBLE,
  "hrs_rndon_ctr" DOUBLE,
  "hrs_rnadmin" DOUBLE,
  "hrs_rnadmin_emp" DOUBLE,
  "hrs_rnadmin_ctr" DOUBLE,
  "hrs_rn" DOUBLE,
  "hrs_rn_emp" DOUBLE,
  "hrs_rn_ctr" DOUBLE,
  "hrs_lpn_admin" DOUBLE,
  "hrs_lpnadmin_emp" DOUBLE,
  "hrs_lpnadmin_ctr" DOUBLE,
  "hrs_lpn" DOUBLE,
  "hrs_lpn_emp" DOUBLE,
  "hrs_lpn_ctr" DOUBLE,
  "hrs_cna" DOUBLE,
  "hrs_cna_emp" DOUBLE,
  "hrs_cna_ctr" DOUBLE,
  "hrs_na_trn" DOUBLE,
  "hrs_natrn_emp" DOUBLE,
  "hrs_natrn_ctr" DOUBLE,
  "hrs_medaide" DOUBLE,
  "hrs_medaide_emp" DOUBLE,
  "hrs_medaide_ctr" DOUBLE
);

Payroll Based Journal Daily Nurse Staffing : 2019-03-13

@usgov.hhs_gov_payroll_based_journal_daily_nurse_staffing_94bbe.payroll_based_journal_daily_nurse_staffing_2019_03_13

32.83 MB
1355220 rows
33 columns


CREATE TABLE payroll_based_journal_daily_nurse_staffing_2019_03_13 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_rndon" DOUBLE,
  "hrs_rndon_emp" DOUBLE,
  "hrs_rndon_ctr" DOUBLE,
  "hrs_rnadmin" DOUBLE,
  "hrs_rnadmin_emp" DOUBLE,
  "hrs_rnadmin_ctr" DOUBLE,
  "hrs_rn" DOUBLE,
  "hrs_rn_emp" DOUBLE,
  "hrs_rn_ctr" DOUBLE,
  "hrs_lpnadmin" DOUBLE,
  "hrs_lpnadmin_emp" DOUBLE,
  "hrs_lpnadmin_ctr" DOUBLE,
  "hrs_lpn" DOUBLE,
  "hrs_lpn_emp" DOUBLE,
  "hrs_lpn_ctr" DOUBLE,
  "hrs_cna" DOUBLE,
  "hrs_cna_emp" DOUBLE,
  "hrs_cna_ctr" DOUBLE,
  "hrs_natrn" DOUBLE,
  "hrs_natrn_emp" DOUBLE,
  "hrs_natrn_ctr" DOUBLE,
  "hrs_medaide" DOUBLE,
  "hrs_medaide_emp" DOUBLE,
  "hrs_medaide_ctr" DOUBLE
);

Payroll Based Journal Daily Nurse Staffing : 2019-06-30

@usgov.hhs_gov_payroll_based_journal_daily_nurse_staffing_94bbe.payroll_based_journal_daily_nurse_staffing_2019_06_30

33.29 MB
1366820 rows
33 columns


CREATE TABLE payroll_based_journal_daily_nurse_staffing_2019_06_30 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_rndon" DOUBLE,
  "hrs_rndon_emp" DOUBLE,
  "hrs_rndon_ctr" DOUBLE,
  "hrs_rnadmin" DOUBLE,
  "hrs_rnadmin_emp" DOUBLE,
  "hrs_rnadmin_ctr" DOUBLE,
  "hrs_rn" DOUBLE,
  "hrs_rn_emp" DOUBLE,
  "hrs_rn_ctr" DOUBLE,
  "hrs_lpnadmin" DOUBLE,
  "hrs_lpnadmin_emp" DOUBLE,
  "hrs_lpnadmin_ctr" DOUBLE,
  "hrs_lpn" DOUBLE,
  "hrs_lpn_emp" DOUBLE,
  "hrs_lpn_ctr" DOUBLE,
  "hrs_cna" DOUBLE,
  "hrs_cna_emp" DOUBLE,
  "hrs_cna_ctr" DOUBLE,
  "hrs_natrn" DOUBLE,
  "hrs_natrn_emp" DOUBLE,
  "hrs_natrn_ctr" DOUBLE,
  "hrs_medaide" DOUBLE,
  "hrs_medaide_emp" DOUBLE,
  "hrs_medaide_ctr" DOUBLE
);

Payroll Based Journal Daily Nurse Staffing : 2019-09-30

@usgov.hhs_gov_payroll_based_journal_daily_nurse_staffing_94bbe.payroll_based_journal_daily_nurse_staffing_2019_09_30

33.7 MB
1378436 rows
33 columns


CREATE TABLE payroll_based_journal_daily_nurse_staffing_2019_09_30 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_rndon" DOUBLE,
  "hrs_rndon_emp" DOUBLE,
  "hrs_rndon_ctr" DOUBLE,
  "hrs_rnadmin" DOUBLE,
  "hrs_rnadmin_emp" DOUBLE,
  "hrs_rnadmin_ctr" DOUBLE,
  "hrs_rn" DOUBLE,
  "hrs_rn_emp" DOUBLE,
  "hrs_rn_ctr" DOUBLE,
  "hrs_lpnadmin" DOUBLE,
  "hrs_lpnadmin_emp" DOUBLE,
  "hrs_lpnadmin_ctr" DOUBLE,
  "hrs_lpn" DOUBLE,
  "hrs_lpn_emp" DOUBLE,
  "hrs_lpn_ctr" DOUBLE,
  "hrs_cna" DOUBLE,
  "hrs_cna_emp" DOUBLE,
  "hrs_cna_ctr" DOUBLE,
  "hrs_natrn" DOUBLE,
  "hrs_natrn_emp" DOUBLE,
  "hrs_natrn_ctr" DOUBLE,
  "hrs_medaide" DOUBLE,
  "hrs_medaide_emp" DOUBLE,
  "hrs_medaide_ctr" DOUBLE
);