Discharge time before admit time?

[OfficialDelta]

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

Description of the issue, including:

• what you have tried
• references to similar issues
• queries demonstrating your question (if applicable)

I was comparing the length of stay in the hospital, and I found 142 cases where timing seems completely messed up for length of stay, as it is a negative value.
Here's a query to find all of the cases:

SELECT hadm_id, stay_length_hours FROM
    (SELECT
        hadm_id,
        EXTRACT(EPOCH FROM (dischtime - admittime)) / 3600 AS stay_length_hours
    FROM
        mimiciv_hosp.admissions) AS subquery
WHERE stay_length_hours <= 0;

One notably interesting case is that of hadm_id 20609236, who was apparently:

• admitted to the ED at 10:51 AM on 1/31
• discharged from the ED at 4:03 PM on 1/31
• admitted to the hospital at 3:08 PM on 1/31
• discharged (due to death) from the hospital at 3:11 AM on 1/31

[baburz]

I encountered this issue in several data points, example: (subject_id=10049642, hadm_id=26714941). Discharge time is 2177-02-20 02:30:00 while death time is 2177-02-20 20:30:00
I discovered 75 cases so far.