TABLE pivoted_oasis
Nobody has claimed this yet.
Assessment
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Newbie friendliness
- 64/100
Research direction
Locate the query that creates TABLE pivoted_oasis and inspect its PostgreSQL dependencies, including the surgflag relation and both ventdurations joins. Correct the missing relation or view and the inconsistent ventdurations aliases, then run the query to confirm that pivoted_oasis is created successfully.
Written by the indexing model from the issue text.
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.physionet.org/about/mimic/
- Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=
Description
Hello,
I found a problem when creating the TABLE pivoted_oasis in PostgreSQL. There is no previous table or view for the relation surgflag sf. I have not seen it included in the views required to run this query. Also, there are two left joins performed with the table ventdurations. They are referenced by two different initials but then the left join is made with different initials (ventdurations vd1 on co.icustay_id = vd.icustay_id, and ventdurations vd2 on co.icustay_id = vd.icustay_id), which has to be corrected in order to run the query.
Thank you.
- Dominant language
- Jupyter Notebook
- Stars
- 3.4k
- Forks
- 1.7k
- PR merge metrics
- No merged PRs in 30d
Getting set up
We have not checked this project's setup files yet. Start from its README, and see our first-contribution guide for the general steps.
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.
More from MIT-LCP/mimic-code
-
Difficulty 1/5 Under an hour Newbie friendliness 95/100
MIT-LCP/mimic-code#2169 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
MIT-LCP/mimic-code#2168 · 1 comment ·
-
Difficulty 1/5 Under an hour Newbie friendliness 72/100
MIT-LCP/mimic-code#1919 · 1 comment ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
MIT-LCP/mimic-code#1770 · 4 comments · 1 reaction ·
-
enhancement mimic-iv
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
MIT-LCP/mimic-code#1358 · 1 comment ·
All issues in MIT-LCP/mimic-code
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
Maintainers usually reply within 1 day
-
channels:add check:passed
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
Maintainers usually reply within 1 day
-
area/sessions comp/cli comp/dashboard P3 sweeper:risk-session-state type/bug
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
NousResearch/hermes-agent#123612 ·
Maintainers usually reply within 1 day
-
vector-store
Difficulty 1/5 1-3 hours Newbie friendliness 90/100
mem0ai/mem0#7461 · 1 comment ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
WingedGuardian/GENesis-AGI#2381 ·
Maintainers usually reply within 1 day