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.41k stars 1.5k forks source link

Inconsistence issue regarding the ventilation and dialysis duration between chartevents.csv and procedureevents.csv #1615

Open yukuntan92 opened 11 months ago

yukuntan92 commented 11 months ago

Prerequisites

Description

Hi,

I am trying to extract the ventilation and dialysis duration information from MIMIC-IV dataset. I saw the sql file which extracted the ventilation duration (by using some logic to determine the duration) and dialysis (no duration) information using chartevents.csv. I noticed that procedureevents.csv contains the start and end time for those, but seems a little bit inconsistent with what extracted from chartevents.csv. I was wondering why not extract from procedureevents.csv directly? Is it because the records from procedureevents.csv are incomplete or inaccurate? Thank you.

alistairewj commented 11 months ago

Yes, procedure events is inconsistent, and its use depends on provider preference. In general I've found the following levels of agreement

Of course you can double check this by cross-referencing the data. In general I'd say the procedure events table is sensitive (real events are captured) but misses events. It depends on your study design whether this is problematic.