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

Capitalization of Units of Measure

Open pszolovits opened this issue 1 year ago • 0 comments

This not earthshaking but I notice that examining the uses of units of measure in MIMIC-IV, there is considerable inconsistency in how these are capitalized. For example, in chartevents, milliliters are represented as "mL", but milliliters per minute are "ml/min". By contrast, in labevents, milliliters per minute are "mL/min". Below is the comprehensive list of units of measure used in chartevents and labevents in MIMIC-IV v2.2.

MariaDB [mimic4v22]> select binary valueuom, count(*) n from labevents group by binary valueuom order by valueuom;

binary valueuom n
NULL 17991766
#/hpf 1513831
#/lpf 122293
#/uL 292835
% 16868943
+/- 63684
/hpf 306103
/mm3 3
BU 1
EU/dL 8919
fL 4532801
g/dL 5729746
GPL 2506
hrs 625
IU/L 4943774
IU/mL 25520
K/uL 9029635
L/min 9320
log10 cop/mL 1564
log10 copies/mL 2232
log10 IU/mL 14085
m/uL 3190494
mEq/L 16935016
mg/24hr 14607
mg/dL 22812951
mg/g 54967
mg/L 156300
mg/mg 46472
min 66
mIU/mL 49561
mL 11192
mL/min 625
mm Hg 1036214
mm/hr 60481
mmol/L 796306
mOsm/kg 90755
MPL 2506
N/A 1606801
ng/dL 138087
ng/mL 1157605
ng/mL DDU 39
ng/mL FEU 9592
nmol/L 7036
pg 3167073
pg/mL 232519
Pos/Neg 545
Ratio 316483
Score 48
sec 2662566
U 2106
U/g/Hb 2557
U/L 273
U/mL 32919
ug/dL 278831
ug/mL 236261
uIU/mL 316306
umol/L 14807
units 1270125
uU/ML 89

MariaDB [mimic4v22]> select binary valueuom, count(*) n from chartevents group by binary valueuom order by valueuom;

binary valueuom n
NULL 236702276
#/uL 696
% 9312983
/min 6579
bpm 7827348
cm 968376
cmH2O 3351546
cmH2O/L/seconds 173637
Degree 77
dynes*sec/cm5 2647
dynes*sec/cm5/m2 3087
dynes.sec.cm-5/m2 3620
g/dL 58054
g/dl 428841
g/kg 450
hour 1717
Inch 33707
insp/min 9642142
IU/L 473024
K/uL 877493
kcal/day 1
kcal/kg 477
kg 277540
L/min 2819673
L/min/m2 15070
lbs 1462
Liters 1606
mA 138292
mEq/L 3064966
mg/dL 2781756
mg/L 2747
min 44066
mL 2662414
mL/beat 20836
ml/hr 993580
ml/kg 2376
mL/m2 6380
ml/min 242012
mm/hr 916
mmHg 25401973
mmHg. 19059
mmol/L 448477
mOsm/kg 22412
msec 415
mV 98445
ng/mL 111153
pg/mL 3808
ppm 1290
psi 927
RPM 15444
sec 1524360
ug/dL 5698
ug/mL 44789
umol/L 1615
units 525828
years 26
°C 958887
°F 1515987

pszolovits avatar Jul 25 '24 22:07 pszolovits