Error in MIMIC-IV-v2.0 dod record

Prerequisites

• 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

Dear Sir or Madam,

I noticed an error in the dod (date of death) record of MIMIC-IV v2.0 recently.
I find some dod records had a date before ICU admission.
For example, subject 14150625 died on 2137-01-24, but had an ICU admission at 2143-12-20 12:34:58.

I extracted the survive time by:

SELECT
icu.subject_id
, icu.stay_id
, icu.intime
, icu.outtime
, pa.dod
, EXTRACT(EPOCH FROM pa.dod - icu.intime)/(60*60*24) AS survive_time
FROM mimiciv_icu.icustays icu
LEFT JOIN mimiciv_hosp.patients pa 
ON pa.subject_id = icu.subject_id
ORDER BY survive_time

And I find a number of patients had this problem.

I wish this bug could be fixed soon.

Yours Nicky

Start by reproducing the reported query against mimiciv_icu.icustays and mimiciv_hosp.patients, focusing on subject 14150625 and the other negative survival times. Inspect the MIMIC-IV v2.0 source or transformation process for dod and ICU admission timestamps. Done means determining whether these records are erroneous and identifying a verified correction or documented explanation.