MIT-LCP / mimic-code

MIMIC Code Repository: Code shared by the research community for the MIMIC family of databases
https://mimic.mit.edu
MIT License
2.43k stars 1.5k forks source link

Unable to find beta-d-glucan laboratory results in MIMIC-IV despite test being mentioned in notes/radiology reports #1562

Open mlbernauer opened 1 year ago

mlbernauer commented 1 year ago

Prerequisites

Description

I am unable to find laboratory results for beta-d-glucan despite the test being mentioned in notes/radiology reports. I've tried searching across all dim tables using various case-insensitive representations (e.g. %beta-d-glucan%, %bdg%, %glucan%, etc) with no luck. I've also tried searching using the brand name Fungitell. Searching hosp.d_labitems using where lower(label) like '%beta%' does return the following:

+--------+--------+----------------------+---------------------+------------------+------------------------------------+----------+------------+
| source | itemid |        label         |        fluid        |     linksto      |              category              | unitname | param_type |
+--------+--------+----------------------+---------------------+------------------+------------------------------------+----------+------------+
| hosp   | 50881  | Beta-2 Microglobulin | Blood               |                  | Chemistry                          |          |            |
| hosp   | 51566  | Beta                 | Blood               |                  | Chemistry                          |          |            |
| hosp   | 51567  | Beta Hydroxybutyrate | Blood               |                  | Chemistry                          |          |            |
| hosp   | 51781  | Beta                 | Cerebrospinal Fluid |                  | Chemistry                          |          |            |
| hosp   | 51810  | Beta                 | Joint Fluid         |                  | Chemistry                          |          |            |
| hosp   | 51840  | Beta                 | Other Body Fluid    |                  | Chemistry                          |          |            |
| hosp   | 51913  | Beta                 | Pleural             |                  | Chemistry                          |          |            |
| hosp   | 51931  | Beta                 | Stool               |                  | Chemistry                          |          |            |
| hosp   | 51965  | Beta                 | Urine               |                  | Chemistry                          |          |            |
| hosp   | 52184  | TCR Alpha-Beta       | Blood               |                  | Hematology                         |          |            |
| hosp   | 52331  | TCR Alpha-Beta       | Bone Marrow         |                  | Hematology                         |          |            |
| hosp   | 52367  | TCR Alpha-Beta       | Other Body Fluid    |                  | Hematology                         |          |            |
| hosp   | 53119  | Beta                 | Ascites             |                  | Chemistry                          |          |            |
+--------+--------+----------------------+---------------------+------------------+------------------------------------+----------+------------+

which has several results for Beta however I'm unsure if this is referring to Beta Hydroxybutyrate or some other laboratory test.

Any suggestions/explanations would be greatly appreciated!