MIT-LCP / MIT-LCP/mimic-code

missing icustay records

Open
#1,598 2 comments 0 reactions 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

Hi,
I just found there were some icustay records lost in the mimiciv_icu module.
For example, patient with hadm_id 20238386. When I search the transfer records for this patient, I found:

subject_id hadm_id transfer_id eventtype careunit intime outtime
18385068 20238386 34322766 admit 2114-08-29 00:21:11 2114-08-29 09:46:01
18385068 20238386 39952860 transfer Cardiac Vascular Intensive Care Unit (CVICU) 2114-08-29 09:46:01 2114-09-01 17:10:45
18385068 20238386 34786921 transfer Cardiac Surgery 2114-09-01 17:10:45 2114-09-06 14:59:15
18385068 20238386 39820107 discharge 2114-09-06 14:59:15

The transfer records showed this patient was admitted to CVICU for 3 days, but no record could be found in icustays table, can some body help to explain this?

Thx!

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 by comparing the transfer records and the icustays table in the mimiciv_icu module for hadm_id 20238386, focusing on the CVICU interval shown in the issue. Review how the module derives icustay records and determine whether this case reflects a data omission or an expected filtering rule; done means documenting the explanation or identifying the affected transformation.

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
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.