admissionDrug table extremely infrequently used

[alistairewj]

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]

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 <[email protected]

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
#14