Is there a mapping between hadm_id and episode?

[johntiger1]

From my understanding, there is a 1:1 mapping between hadm_id and an episode for a subject. In other words, a patient episode simply summarizes a hospital admit which has a key hadm_id. Is there a mapping file? This would let us join back to get other data from MIMIC. Thanks

[hrayrhar]

Hi @johntiger1 ,

I don't think we have the mapping ready somewhere, but it will be possible to construct it by going over all episodes after processing the root folder.

Hrayr

[shan23chen]

From my understanding, there is a 1:1 mapping between hadm_id and an episode for a subject. In other words, a patient episode simply summarizes a hospital admit which has a key hadm_id. Is there a mapping file? This would let us join back to get other data from MIMIC. Thanks

Hi, I am facing the same question, did you figure out the mapping by chance? Thanks!

[shan23chen]

Hi @johntiger1 ,

I don't think we have the mapping ready somewhere, but it will be possible to construct it by going over all episodes after processing the root folder.

Hrayr

I am also wondering which file you guys use to partition the csv files into all the episodes. Thanks!