Introduction
Methods
Legal and privacy
Extract–transform–load pipeline
Data mapping
Category | Parameter name | Parameter subname | Obs | Pat | Hosp. |
---|---|---|---|---|---|
Respiratory | fio2 | fio2 unspecified | 3,242,962 | 385 | 7 |
Respiratory | fio2 | fio2 set | 6,143,804 | 2927 | 25 |
Respiratory | fio2 | fio2 optiflow | 633 | 70 | 1 |
Respiratory | fio2 | fio2 hiflow | 7223 | 266 | 5 |
Respiratory | fio2 | fio2 measured | 2,095,235 | 1809 | 20 |
Respiratory | fio2 | fio2 niv | 707 | 65 | 2 |
Respiratory | Vent mode | Vent mode | 10,614,561 | 2970 | 25 |
Respiratory | Vent mode | Vent mode invasive | 15,580 | 756 | 11 |
Respiratory | Vent mode | Vent mode machine | 8755 | 396 | 4 |
Respiratory | Vent mode | Vent mode manual | 644 | 105 | 5 |
Respiratory | Vent mode | Vent mode noninvasive | 3630 | 315 | 6 |
Respiratory | Peep | Peep set | 5,976,874 | 2389 | 24 |
Respiratory | Peep | Peep unspecified | 20,479 | 116 | 2 |
Respiratory | Peep | Peep measured | 3,786,729 | 2432 | 22 |
Hemodynamics | Heart rate | Heart rate ECG | 827 | 179 | 3 |
Hemodynamics | Heart rate | Heart rate unspecified | 7,095,759 | 2920 | 25 |
Hemodynamics | Heart rate | Heart rate monitor | 836,776 | 740 | 5 |
Respiratory | o2 saturation | Saturation o2 peripheral monitor | 1,677,619 | 654 | 4 |
Respiratory | o2 saturation | Saturation o2 peripheral | 5,447,816 | 3086 | 23 |
Hemodynamics | Arterial blood pressure mean | Arterial bp mean | 6,538,822 | 3284 | 24 |
Respiratory | Lung compliance static | Lung compliance static | 1,281,683 | 317 | 6 |
Respiratory | Lung compliance static | Lung compliance static adjusted | 4,739,724 | 2515 | 25 |
Hemodynamics | Arterial blood pressure systolic | Arterial bp systolic | 5,901,827 | 3286 | 24 |
Hemodynamics | Arterial blood pressure diastolic | Arterial bp diastolic | 5,896,330 | 3285 | 24 |
Respiratory | Pressure above peep | Pressure support set | 240,321 | 23 | 1 |
Respiratory | Pressure above peep | Inspiratory pressure above peep | 5,427,631 | 2429 | 24 |
Respiratory | Driving pressure | Driving pressure | 4,851,963 | 2519 | 25 |
Respiratory | Driving pressure | Driving pressure adjusted | 746,687 | 1662 | 22 |
Respiratory | Tidal volume | Tidal volume expiratory | 3,694,052 | 2546 | 22 |
Respiratory | Tidal volume | Tidal volume expiratory measured | 1,413,883 | 122 | 3 |
Respiratory | Tidal volume | Tidal volume expiratory unspecified | 19,056 | 109 | 1 |
Respiratory | Tidal volume | Tidal volume measured | 26,262 | 32 | 1 |
Respiratory | Tidal volume | Tidal volume set | 409,944 | 1383 | 22 |
Respiratory | Peak pressure | Peak pressure measured | 156,117 | 18 | 1 |
Respiratory | Peak pressure | Peak inspiratory pressure | 5,364,952 | 2687 | 25 |
Respiratory | Respiratory rate spontaneous | Respiratory rate measured spontaneous | 4,799,514 | 934 | 9 |
Respiratory | Respiratory rate spontaneous | Respiratory rate measured ventilator spontaneous | 489,793 | 1270 | 13 |
Respiratory | Tidal volume per kg | Tidal volume per kg | 5,240,012 | 2683 | 25 |
Respiratory | Minute volume | Minute volume unspecified | 791,194 | 287 | 6 |
Respiratory | Minute volume | Minute volume set | 9414 | 239 | 5 |
Respiratory | Minute volume | Minute volume expiratory | 4,408,260 | 2488 | 22 |
Respiratory | Respiratory rate measured ventilator | Respiratory rate measured ventilator | 5,010,244 | 2408 | 23 |
Respiratory | Mean pressure | Mean airway pressure | 4,590,042 | 2291 | 22 |
Respiratory | End tidal co2 | End tidal co2 measured | 4,193,165 | 2597 | 24 |
Respiratory | Flow trigger set | Flow trigger set | 3,531,317 | 1247 | 20 |
Data enrichment
Parameter | Calculation | Tolerance | Comments |
---|---|---|---|
Basophils percentage | Basophils divided by leukocytes | 1 h | |
Body mass index | Height divided by weight squared | / | A measurement is added for each measurement of weight, using the latest available height for the patient |
Driving pressure | Plateau pressure minus peep | 8 h/1 h | |
Driving pressure | Tidal volume divided by lung compliance static | 1 h | |
Eosinophils percentage | Eosinophils divided by leukocytes | 1 h | |
Glasgow coma scale total | Glasgow coma scale eye plus Glasgow coma scale motor plus Glasgow coma scale verbal | 1 h | |
Inspiratory expiratory ratio | Inspiratory time divided by expiratory time | 1 h | |
Lung compliance dynamic | Tidal volume divided by (peak pressure minus peep) | 1 h | |
Lung compliance static | Tidal volume divided by (plateau pressure minus peep) | 1 h/8 h/1 h | |
Lung compliance static | Tidal volume divided by pressure above peep | 1 h | |
Lymphocytes percentage | Lymphocytes divided by leukocytes | 1 h | |
Mechanical power per kg | Mechanical power divided by ideal body weight | / | Ideal body weight is calculated from the patient's gender and height |
Mechanical power | (0.098 × respiratory rate measured ventilator times tidal volume times (peak pressure minus (driving pressure × 0.5)) × 0.001 | 1 h | |
Mechanical power | (0.098 × respiratory rate measured ventilator times tidal volume times (peak pressure plus peep) × 0.001 | 1 h | |
Minute volume derived | (tidal volume times respiratory rate measured) × 0.001 | 1 h | |
Monocytes percentage | Monocytes divided by leukocytes | 1 h | |
Neutrophils percentage | Neutrophils divided by leukocytes | 1 h | |
Pao2 over fio2 | po2 arterial divided by fio2 | 8 h/1 h | Measurements of ‘fio2’ within 8 h *before* ‘po2’ are given priority over those measured within 1 h afterwards |
Pco2 minus end tidal co2 | pco2 arterial minus end tidal co2 | 8 h | Measurements of ‘end tidal co2’ within 1 h *before* `pco2` are given priority over those measured afterwards |
Physiological dead space | pco2 minus end tidal co2 minus pco2 arterial | 8 h | Measurements of ‘pco2 arterial’ within 8 h *before* ‘pco2 minus end tidal co2’ are given priority over those measured within 8 h afterwards |
Plateau pressure | Driving pressure minus peep | 8 h/1 h | |
Po2 unspecified over fio2 | po2 unspecified divided by fio2 | 8 h/1 h | Measurements of ‘fio2’ within 8 h *before* ‘po2’ are given priority over those measured within 1 h afterwards |
Rapid shallow breathing index | (Respiratory rate set divided by tidal volume) × 1000 | 1 h | |
Respiratory rate difference | Respiratory rate measured ventilator minus respiratory rate set | 1 h | |
Tidal volume per kg | Tidal volume divided by ideal body weight | / | Ideal body weight is calculated from the patient's gender and height |
Ureum over creatinine | Ureum minus creatinine | 1 h | |
Ventilatory ratio | (minute volume times pco2 arterial) divided by (ideal body weight × 100 × 37.5) | 1 h | Ideal body weight is calculated from the patient's gender and height |
Data validation
Data and code availability
Results
Parameter mapping
Data tables
Clinical characteristics of patients
Patient characteristics | Dutch Data Warehouse cohort | n |
---|---|---|
Age, years (median, IQR) | 64.0 (56.0, 72.0) | 3459 |
Body Mass Index, kg/m2 (median, IQR) | 27.3 (24.3, 30.7) | 849 |
Gender male, (n, %) | 2498 (72.3) | 3457 |
Transfersa, (n, %) | 367 (10.6) | 3463 |
Referralsa, (n, %) | 784 (26.5) | 2963 |
ICU mortality, (n, %) | 707 (24.4) | 2900 |
ICU or hospital mortalityb, (n, %) | 853 (29.4) | 2900 |
Still admittedc, (n, %) | 196 (5.7) | 3463 |
ICU length of stay, days (median, IQR) | 7.1 (2.2, 16.0) | 3306 |
Intubated, (n, %) | 2644 (75.6) | 3496 |
Length of intubation, days (median, IQR) | 7.7 (2.9, 14.3) | 2644 |
CRRT, (n, %) | 427 (12.2) | 3496 |