MIT-LCP / MIT-LCP/mimic-code

About picking up Respiratory Rate from the mimic III

Open
#832 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

mimic-iii
Dominant language
Jupyter Notebook
Stars
3.4k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

I want to use the pgAdmin4 to download the Respiratory Rate from the mimic III,but it shows that there are more than 3million data.I try to download it and I failled.I think it maybe too large for me to download,how can I solve this problem.This is the code:

select * from mimiciii.d_items where label like '%espiratory Rate%'
select * from mimiciii.chartevents_5 where itemid=618

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 reviewing the two SQL queries in the issue, especially the itemid=618 query against mimiciii.chartevents_5, and reproduce the download failure in pgAdmin4. Done would require a documented, agreed way to retrieve the respiratory-rate data without the reported failure; the issue does not name a repository file or test.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
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.