ED patients that were transferred to ICU
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
I would like to do an study only with the ED stays that were transferred to the ICU. I tried to link the edstays with icustays using stay_id, but it returned no rows. I assume they are different ids, although they have the same name. I understand that I would have to use the subject_id, but then if the patient has multiple ED stays I wouldn't be sure which ED stay ended with ICU admission. Is there a way to link the ED stay with the ICU stay, even if the patient has multiple stays? Perhaps I'm missing something? 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 online documentation and the schemas for the edstays and icustays tables mentioned in the issue. Check the documented identifiers and relationship guidance, then verify the intended linkage with a small query using patients with multiple ED stays. Done means the repository documents a reliable way to identify ED stays associated with ICU admissions.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Documentation
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100