Linking MIMIC-IV and MIMIC-CXR, under the {subject_id, hadm_id, stay_id} tuple key

MIT-LCP / mimic-code

MIMIC Code Repository: Code shared by the research community for the MIMIC family of databases

https://mimic.mit.edu

MIT License

2.43k stars 1.5k forks source link

Linking MIMIC-IV and MIMIC-CXR, under the {subject_id, hadm_id, stay_id} tuple key #1552

Open ArbelHaiman opened 1 year ago

ArbelHaiman commented 1 year ago

Hello,

I want to create a dataset, comprising of records defined by the {subject_id, hadm_id, stay_id} identifier, i.e., each unique tuple defines one record. I looked at the MIMIC-CXR, but I saw that the columns hadm_id and stay_id do not exist there. I saw that there are only the subject_id and the study_id columns. How can I link only the relevant images to each record?

alistairewj commented 1 year ago

Yes, there is no explicit link between MIMIC-CXR and hadm_id / stay_id.

If you use a combination of the DICOM StudyDate, StudyTime, and PatientID (which links to subject_id), you can assign each x-ray to an hadm_id or stay_id.