search

MIT-LCP / mimic-website

Website for the MIMIC Critical Care Database (currently version MIMIC-III)
https://mimic.mit.edu
MIT License
102 stars 111 forks source link

ITEM_ID in CHART EVENT Table #49

Closed snehatuteja closed 8 years ago

snehatuteja commented 8 years ago

Hi, I tried mapping ITEMID in CHARTEVENT table using https://physionet.org/mimic2/UserGuide/UserGuide.pdf Appendix 6.2,

But there are so many ITEMIDs that are not there in Appendix 6.2. Is there a way that I can map every ITEMID to figure out what vital signs or lab events it shows? I also tried matching the ITEMIDs with the Lab Event's ITEMIDs using:

https://github.com/MIT-LCP/mimic-code/blob/master/migrating/labid.csv

But no success!

tompollard commented 8 years ago

Hi @snehatuteja, please read the documentation at http://mimic.physionet.org/gettingstarted/overview/, and also the MIMIC-III paper at: http://www.nature.com/articles/sdata201635. These should give you an outline of the database structure.

Is there a way that I can map every ITEMID to figure out what vital signs or lab events it shows?

As noted in the documentation, the D_ITEMS table is a "Dictionary of ITEMIDs appearing in the MIMIC database, except those that relate to laboratory tests" and the D_LABITEMS table is a "Dictionary of ITEMIDs in the laboratory database that relate to laboratory tests". These should contain the information that you are looking for.

I tried mapping ITEMID in CHARTEVENT table using https://physionet.org/mimic2/UserGuide/UserGuide.pdf

The current version of MIMIC is MIMIC-III. The PDF you are looking at is an archived copy of the MIMIC-II documentation.

snehatuteja commented 8 years ago

Hey,

Thank you so much for your reply! Is there a way to map Subject_ID with the waveform data in the physio net ATM?

Regards, Sneha

Masters student Computer Science Dept. University of Illinois at Chicago

On Fri, Jul 22, 2016 at 4:47 PM, Tom Pollard notifications@github.com wrote:

Hi @snehatuteja https://github.com/snehatuteja, please read the documentation at http://mimic.physionet.org/gettingstarted/overview/, and also the MIMIC-III paper at: http://www.nature.com/articles/sdata201635. These should give you an outline of the database structure.

Is there a way that I can map every ITEMID to figure out what vital signs or lab events it shows?

As noted in the documentation, the D_ITEMS table is a "Dictionary of ITEMIDs appearing in the MIMIC database, except those that relate to laboratory tests" and the D_LABITEMS table is a "Dictionary of ITEMIDs in the laboratory database that relate to laboratory tests". These should contain the information that you are looking for.

I tried mapping ITEMID in CHARTEVENT table using https://physionet.org/mimic2/UserGuide/UserGuide.pdf

The current version of MIMIC is MIMIC-III. The PDF you are looking at is an archived copy of the MIMIC-II documentation.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/MIT-LCP/mimic-website/issues/49#issuecomment-234665241, or mute the thread https://github.com/notifications/unsubscribe-auth/AOiKtA88oAJj20KAB1K1njEyjuHsjI6dks5qYTqAgaJpZM4JTHA7 .

alistairewj commented 8 years ago

SUBJECT_ID maps to the waveforms directly.

See here for details on the matched waveforms: https://physionet.org/physiobank/database/mimic2wdb/matched/ See this issue for more details regarding the update for MIMIC-III: https://github.com/MIT-LCP/mimic-code/issues/86

alistairewj commented 8 years ago

I want the neonates vital data along with Ins and Outs. The link you sent just have the adults data but not the neonates.

MIMIC contains data for both adults and neonates.

I have the MIMIC 2 data access but it does not have the full vitals in CHARTEVENTS file. The file that I have attached is of a Neonate patient and I have highlighted the vitals that I could map but the other ITEM_IDs could not be mapped to any other vitals. Can you please send me the link to Dictionary of ITEMIDs, so that I can map them?

D_ITEMS is the dictionary of ITEMIDs for both neonates and adults.

Also is there a way that I can map SUBJECT_IDs with the waveform data of neonates in Physio Bank ATM?

See here for details on the matched waveforms: https://physionet.org/physiobank/database/mimic2wdb/matched/ See this issue for more details regarding the update for MIMIC-III: MIT-LCP/mimic-code#86