MIMIC-III : outpatient information

[jaeehooon]

Prerequisites

• [x] Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.mit.edu/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

Description of the issue, including:

Hello, I'm curious for getting soma data from MIMIC-III.

How would I get some data of 'outpatient' from LABEVENTS.csv table? For example, there are some lab event or lab results data from LABEVENTS.csv table. and as it says in this document, it's outpatient data for only lab test if the row doesn't have HADM_ID.

So, this is what I want.

• For a patient, can we know when a patient has visited the hospital for the lab test?

1. It has only CHARTTIME column from LABEVENTS.csv. I guess I can't get which date.
2. So, I would like to use this information with 'how many the patients have visited in the hospital for the lab test as a outpatient'.

Thank you