MIT-LCP/gossis

Add respiratory rate from respiratoryCharting

Opened this issue · 0 comments

Right now nurse charting gets 90% of respiratory rates

select
count(pt.patientunitstayid) as num_total
, count(vnc_d1.resprate_max) as rr
, count(vnc_d1.resprate_max)::numeric / count(pt.patientunitstayid) * 100.0 as percentage_complete
from gossis_cohort pt left join gossis_vital_nc_d1 vnc_d1 on pt.patientunitstayid = vnc_d1.patientunitstayid
where excluded=0;

If we add in respiratory rate from respiratoryCharting then we could prob bump this up from 90%. Then have to decide whether it is worth it to add in vitalPeriodic to "clean up" the rest.