MIT-LCP / MIT-LCP/mimic-code

MIMIC-IV Admissions table - Patients who died are later admitted to the hospital with the new hadm_id

Open
#1,194 0 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Jupyter Notebook
Stars
3.4k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

Prerequisites
Description

I am doing an exploratory data analysis of patients readmission to the hospital. I am looking at the readmission rates depending on the discharge location. I now came across quite a strange scenario: there are patients who died in the hospital (discharge_location = 'DIED', deathtime is equal to admittime in the ADMISSIONS.csv table. But these died patients were readmitted to the hospital 1 minute later to the PACU admission location with the new HADM_ID. I have found 110 patients with the same issue (e.g. subject_id = 10304050, 10068026). In their subsequent admission they do not have deathtime and hospital_expire_flag, giving the impression that they are alive.
I could not find the description to this problem in the available documentation. Maybe this is how hospital system works. I would be grateful if you could provide any clarifications on this issue.

Thanks,
Nodira

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the MIMIC online documentation and the ADMISSIONS.csv records for subject_id 10304050 and 10068026. Compare the DIED admission with the later PACU admission, including deathtime and hospital_expire_flag, and determine whether the documented data model explains the sequence. Done when the admission sequence has a clear documented interpretation or a reproducible data defect is identified.

Written by the indexing model from the issue text.

Assessment

Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.