labitems with same label, fluid, & category but different itemid
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 3.4k
- Forks
- 1.7k
- PR merge metrics
- No merged PRs in 30d
Description
Hi--
I wanted to report this and I don't know if you did that intentionally or not.
Some lab measurements in (mimic_hosp.d_labitems) have the same label, fluid, category, & units (in mimic_hosp.labevents) but have different itemids.
I realize the loinc_code is assigned to one only, but should they be merged with the same loinc_code?
Example:
Also, some items have different itemids just because the units used in the labevents table are different:
Thank you!
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 by comparing the affected rows in mimic_hosp.d_labitems with their corresponding records in mimic_hosp.labevents, focusing on duplicate labels, fluids, categories, units, itemids, and loinc_code values. Done means determining whether these itemids represent distinct measurements or should be merged, then documenting or applying the resulting data-model decision.
Written by the indexing model from the issue text.
Assessment
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100