search

MIT-LCP / eicu-website

Repository moved
https://github.com/MIT-LCP/eicu-code
MIT License
3 stars 3 forks source link

admissionDrug table extremely infrequently used #14

Open alistairewj opened 8 years ago

alistairewj commented 8 years ago 
with v1 as
( select patientunitstayid, count(*) as numobs
from eicu_adm.admissiondrug
group by patientunitstayid
)
select count(pt.patientunitstayid) as numpat
, count(v1.patientunitstayid) as with_v1
, round(count(v1.patientunitstayid)/count(pt.patientunitstayid)*100.0,2) as percent_v1
, round(sum(v1.numobs) / count(v1.patientunitstayid),2) as avg_num_obs
from eicu_adm.patients pt
left join v1 on pt.patientunitstayid = v1.patientunitstayid

Only 0.15% of patients have data in this table - we should consider simply removing it from the release.

obadawi commented 8 years ago

Not surprising. My understanding is it's infrequently used. I would be fine with removing it since it provides little value.

On Mon, Apr 11, 2016 at 12:53 PM, Alistair Johnson <notifications@github.com

wrote:

with v1 as ( select patientunitstayid, count(_) as numobsfrom eicu_adm.admissiondruggroup by patientunitstayid )select count(pt.patientunitstayid) as numpat , count(v1.patientunitstayid) as with_v1 , round(count(v1.patientunitstayid)/count(pt.patientunitstayid)_100.0,2) as percent_v1 , round(sum(v1.numobs) / count(v1.patientunitstayid),2) as avg_num_obsfrom eicu_adm.patients ptleft join v1 on pt.patientunitstayid = v1.patientunitstayid

Only 0.15% of patients have data in this table - we should consider simply removing it from the release.

— You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub https://github.com/mit-eicu/eicu-website/issues/14