I have a question about "ventilation.sql"
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
- [O ] 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
Hello, I have a question about "mimic-code/mimic-iv/concepts postgres/treatment/ventilation.sql" on github.
https://github.com/MIT-LCP/mimic-code/blob/main/mimic-iv/concepts_postgres/treatment/ventilation.sql
There is "Having MIN(charttime) <> MAX(charttime)" at the end of this code. Using the condition, number 3 of seq_num in the image below will be excluded. I am curious about why the "having" condition is used and whether this case corresponds to weaning failure.
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
Read mimic-iv/concepts_postgres/treatment/ventilation.sql, focusing on the grouping and the final HAVING MIN(charttime) <> MAX(charttime) condition. Review the surrounding query and relevant MIMIC-IV ventilation documentation, then explain why the condition excludes the shown seq_num 3 case and whether that represents weaning failure.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, sql
- Domain
- databases
- Issue type
- Documentation
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100