Baselight
Sign In

Payroll Based Journal Daily Non-Nurse Staffing

U.S. Department of Health & Human Services

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_41d84

Loading...
Loading...

About this Dataset

Payroll Based Journal Daily Non-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 data include the hours staff are paid to work each day, for each facility. 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.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:27:53.759146
Tags: health-care-use-payments, hospitals-facilities, medicare, original-medicare, skilled-nursing

Tables

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

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_41d84.payroll_based_journal_daily_non_nurse_staffing_2017_03_31
  • 36.52 MB
  • 1,253,610 rows
  • 81 columns
Loading... 
CREATE TABLE payroll_based_journal_daily_non_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_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

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

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_41d84.payroll_based_journal_daily_non_nurse_staffing_2017_06_30
  • 36.69 MB
  • 1,272,544 rows
  • 81 columns
Loading... 
CREATE TABLE payroll_based_journal_daily_non_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_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

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

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_41d84.payroll_based_journal_daily_non_nurse_staffing_2017_09_30
  • 38.02 MB
  • 1,331,884 rows
  • 81 columns
Loading... 
CREATE TABLE payroll_based_journal_daily_non_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_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

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

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_41d84.payroll_based_journal_daily_non_nurse_staffing_2017_12_31
  • 37.11 MB
  • 1,301,064 rows
  • 81 columns
Loading... 
CREATE TABLE payroll_based_journal_daily_non_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_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

Payroll Based Journal Daily Non-Nurse Staffing : 2018-12-31

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_41d84.payroll_based_journal_daily_non_nurse_staffing_2018_12_31
  • 39.89 MB
  • 1,372,272 rows
  • 81 columns
Loading... 
CREATE TABLE payroll_based_journal_daily_non_nurse_staffing_2018_12_31 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

Payroll Based Journal Daily Non-Nurse Staffing : 2019-03-31

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_41d84.payroll_based_journal_daily_non_nurse_staffing_2019_03_31
  • 39.38 MB
  • 1,355,220 rows
  • 81 columns
Loading... 
CREATE TABLE payroll_based_journal_daily_non_nurse_staffing_2019_03_31 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

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

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_41d84.payroll_based_journal_daily_non_nurse_staffing_2019_06_30
  • 39.66 MB
  • 1,366,820 rows
  • 81 columns
Loading... 
CREATE TABLE payroll_based_journal_daily_non_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_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

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

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_41d84.payroll_based_journal_daily_non_nurse_staffing_2019_09_30
  • 39.92 MB
  • 1,378,436 rows
  • 81 columns
Loading... 
CREATE TABLE payroll_based_journal_daily_non_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_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

Payroll Based Journal Daily Non-Nurse Staffing : 2019-12-31

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_41d84.payroll_based_journal_daily_non_nurse_staffing_2019_12_31
  • 39.18 MB
  • 1,377,148 rows
  • 81 columns
Loading... 
CREATE TABLE payroll_based_journal_daily_non_nurse_staffing_2019_12_31 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

Share link

Anyone who has the link will be able to view this.