mimic-code icon indicating copy to clipboard operation
mimic-code copied to clipboard

Multiple lab item IDs with same lab test name

Open yzhao5183 opened this issue 2 years ago • 1 comments

Prerequisites

  • [ ] 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

Description of the issue, including: I was going through d_labitems table. I found several items with same names but different ID: 51069, 52698 all belong to Albumin, Urine. 51133,52764 all belong to Absolute Lymphocyte Count.

May I know the reasons for having different IDs for one lab test? Do they represent anything different? Was there a more detailed lab test name?

Thank you!

yzhao5183 avatar Oct 13 '21 19:10 yzhao5183

For the labs, do also check the fluid and category columns. Many tests have the same label (e.g. pH) but are for different bodily fluids (blood, urine, etc). That being said, it is still the case that redundant itemid exist. The lab database in MIMIC-IV seems to have "extra" itemid which are never used in practice but share the same label as the ones actually used.

alistairewj avatar Oct 28 '21 14:10 alistairewj