edstays and hospadmission not matching
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
- 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
Hi guys, I'm looking into ED patients. Let's take the hadm_id=26996526 for example.
So.. in the admission table, there is an admittime, dischtime, edregtime, edouttime. The edouttime is not matching the outtime from edstays. Which one should be the correct one?
Also, please help me understand the pipeline. The patient was first admitted to the ED, than discharged from the ED and admitted to the Hospital, right? When admitted to the hospital, how can I see where he was (which ward)? There are no ICUstays for that hadm_id. I see that he had labevents during that period but he was no longer in the ED.
Thanks!
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the MIMIC documentation and compare the admissions and edstays records for hadm_id 26996526. Determine how the ED and hospital timelines relate, including where ward information is represented when no ICUstay exists. Done means documenting the source of each timestamp and the appropriate table or field for the ward location.
Written by the indexing model from the issue text.
Assessment
- Domain
- databases
- Issue type
- Documentation
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100