Capitalization of Units of Measure
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 3.4k
- Forks
- 1.7k
- PR merge metrics
- No merged PRs in 30d
Description
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 |
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 reviewing the listed valueuom results for labevents and chartevents in MIMIC-IV v2.2 and identify the intended capitalization convention. The issue does not specify which values should change, so confirm the scope and canonical forms before editing. Done means the affected unit values follow a documented, consistent convention across both tables.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100