MIT-LCP / MIT-LCP/mimic-code

Some blood gas items are not considered in blood_gas_first_day.sql (MIMIC-III)

Open
#1,223 0 comments 0 reactions 0 assignees View on GitHub

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
Description

Currently, blood_gas_first_day.sql in MIMIC-III doesn't use the following items in D_LABITEMS table that looks to be related to blood gases.
Is it intentional or should we add these items?

 	row_id 	itemid 	label 			fluid 			category 	loinc_code
156 	30 	50829 	Fluid Type 		Other Body Fluid 	Blood Gas 	14725-6
157 	31 	50830 	pCO2, Body Fluid 	Other Body Fluid 	Blood Gas 	2023-0
158 	32 	50831 	pH 			Other Body Fluid 	Blood Gas 	2748-2
159 	33 	50832 	pO2, Body Fluid 	Other Body Fluid 	Blood Gas 	2706-0
160 	34 	50833 	Potassium 		Other Body Fluid 	Blood Gas 	2821-7
161 	35 	50834 	Sodium, Body Fluid 	Other Body Fluid 	Blood Gas 	2950-4
741 	742 	51544 	VOIDED SPECIMEN 	OTHER BODY FLUID 	BLOOD GAS 	NaN

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 with mimic-iii/concepts/firstday/blood_gas_first_day.sql and inspect how it selects blood-gas item IDs from D_LABITEMS. Compare that logic with the listed item IDs and labels, then verify that the resulting scope matches the intended first-day blood-gas concept and that the issue’s inclusion question is resolved.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.