Table: wqip_quarterly_performance_report_2023_3
, facility_name like Q*
facility_name |
facilityid |
ccn |
hcai_id |
npi1 |
npi2 |
npi3 |
cna_rate |
raw_score_cna |
cna_days_compliant |
score_cna |
lvn_rate |
raw_score_lvn |
lvn_days_compliant |
score_lvn |
rn_rate |
raw_score_rn |
rn_days_compliant |
score_rn |
total_nursing_rate |
raw_score_total_nursing |
total_nursing_days_compliant |
score_total_nursing |
total_weekend_nursing_rate |
raw_score_weekend |
total_weekend_days_compliant |
score_total_weekend_nursing |
acuity_points_earned |
acuity_possible_points |
acuity_area_score |
staffing_turnover_rate |
turnover_points_earned |
turnover_possible_points |
turnover_area_score |
antipsych_num_pyr |
antipsych_num_pyr_annotation |
antipsych_denom_pyr |
antipsych_denom_pyr_annotation |
antipsych_rate_pyr |
antipsych_rate_pyr_annotation |
antipsych_num |
antipsych_num_annotation |
antipsych_denom |
antipsych_denom_annotation |
antipsych_rate |
antipsych_rate_annotation |
gap_closure_antipsych |
gap_closure_antipsych_annotation |
achievement_points_antipsych |
improvement_points_antipsych |
antipsych_metric_score |
fall_num_pyr |
fall_num_pyr_annotation |
fall_denom_pyr |
fall_denom_pyr_annotation |
fall_rate_pyr |
fall_rate_pyr_annotation |
fall_num |
fall_num_annotation |
fall_denom |
fall_denom_annotation |
fall_rate |
fall_rate_annotation |
gap_closure_fall |
gap_closure_fall_annotation |
achievement_points_fall |
improvement_points_fall |
fall_metric_score |
pu_num_pyr |
pu_num_pyr_annotation |
pu_denom_pyr |
pu_denom_pyr_annotation |
pu_rate_pyr |
pu_rate_pyr_annotation |
pu_num |
pu_num_annotation |
pu_denom |
pu_denom_annotation |
pu_rate |
pu_rate_annotation |
gap_closure_pu |
gap_closure_pu_annotation |
achievement_points_pu |
improvement_points_pu |
pu_metric_score |
mds_points_earned |
mds_points_possible |
raw_mds_score |
mds_data_completeness |
mds_area_score |
medi_cal_share_rate |
medi_cal_share_points_earned |
medi_cal_share_possible_points |
medi_cal_share_area_score |
re_completeness_rate |
re_completeness_points_earned |
re_completeness_points_possible |
re_completeness_area_score |
QUARTZ HILL POST ACUTE |
230000366 |
555356 |
206454003 |
1942722202 |
None |
None |
2.623 |
4 |
0.836065574 |
3.344262295 |
1.416 |
5 |
1 |
5 |
0.292 |
0 |
1 |
0 |
4.353 |
4 |
0.994535519 |
3.978142077 |
3.983 |
4 |
0.981132076 |
3.924528302 |
16.24693267 |
30 |
0.541564422 |
0.449 |
3 |
6 |
0.5 |
None |
1 |
144 |
0 |
None |
1 |
None |
1 |
168 |
0 |
None |
1 |
None |
None |
5 |
0 |
5 |
None |
1 |
194 |
0 |
None |
1 |
None |
1 |
222 |
0 |
None |
1 |
0.672405432 |
0 |
2 |
5 |
5 |
None |
1 |
82 |
0 |
None |
1 |
None |
1 |
148 |
0 |
None |
1 |
0.780012096 |
0 |
5 |
6 |
6 |
16 |
17 |
0.941176471 |
0.848605578 |
0 |
0.514548239 |
0 |
5 |
0 |
0.683844011 |
0 |
10 |
0 |