Hello. I just got acces to MIMIC, but Im having trouble setting up the database to explore the links. does anyone have a bit of time to walk me through this thing? thanks in advance.
Ahhahaha I figured it out. Now ive got to query it when I get back to town
Alistair Johnson
@alistairewj
:+1:
Luke Williams
@luker0bert
hello, I am trying to figure out the "key" for row "ITEMID" in LABEVENTS.csv in order to understand the row "VALUE". For example, ITEMID "50820" has a VALUE "7.39", which I am assuming is pH. Can anyone help me decrypt this? Thank you!
Alistair Johnson
@alistairewj
join the "ITEMID" in LABEVENTS to the "ITEMID" in D_LABITEMS. That will tell you what it means
Or, alternatively, look through D_LABITEMS for the "ITEMID" you would like, and then you use that to find data in LABEVENTS
Luke Williams
@luker0bert
Thanks a lot
Alistair Johnson
@alistairewj
:+1:
Luke Williams
@luker0bert
Another question for you- where did the "a-line.csv" file come from? the original database? Or was this created from a query? I can't seem to find info (no schema) associated with this file. Thanks.
Alistair Johnson
@alistairewj
Which A-line file?
Luke Williams
@luker0bert
There is an a-line.csv file with all the other csv files.