search

Trauma-Team-International / Home

Trauma Team International || Autonomio's Coronavirus Task Force
MIT License
4 stars 1 forks source link

Intubation concept #37

Open mikkokotila opened 4 years ago

mikkokotila commented 4 years ago

ITEMID:

[418,
 227210,
 227211,
 227212,
 227213,
 227214,
 227215,
 226814,
 228643,
 222871,
 223059,
 225585,
 225586,
 225587,
 225588,
 225590,
 225592,
 225593,
 224385,
 226166,
 226188,
 226189,
 226190,
 226191,
 225271,
 226429,
 226430,
 226431,
 226432,
 228065,
 228066,
 228067,
 228068,
 228069,
 228070,
 228071,
 225291,
 225292,
 225294,
 225295,
 225296,
 225297,
 225298,
 225300,
 225301,
 225302,
 225303,
 225304,
 225306]
mikkokotila commented 4 years ago

I think it's best that we create the concept with everything, and then based on preliminary analysis with the data, we'll decide which ones to keep. We can do the analysis before merging PR, so in one PR we can handle everything without changing the main dataset in the meantime.

pdey commented 4 years ago

out of 49 itemid for intubation 1 of them is procedureevents_mv item and rest are chartevents items. Following are the occurrences of them in tables. select itemid, count(itemid) as count from procedureevents_mv where itemid=224385 group by itemid; itemid | count --------+------- 224385 | 4514

And for the remaining 48 chartevents items only 2 of them are present in table. elect itemid, count(itemid) as count from chartevents where itemid in (418, .... // skip, 225306) group by itemid order by count desc; itemid | count --------+-------- 226814 | 101809 223059 | 1 (2 rows)