Table 1.
Structured data extracted for the project.
| Data type, extracted data, and subcategory | Unit | |||
| General administrative data | ||||
|
|
Patient identification number (coded) | Category | ||
|
|
Case identification number (admission ID, hospitalization ID, or stay ID) | Category | ||
|
|
Insurance type | Category | ||
|
|
Region of residence (MedStata region) | Category | ||
|
|
Admission mode (eg, admission via emergency department, planned admission, or transfer) | Category | ||
|
|
Nationality | Category | ||
|
|
Date of birth (coded) | Date | ||
|
|
Gender | Category | ||
|
|
Date of death (if applicable) | Date | ||
| Clinical measurements | ||||
|
|
Blood pressure | Value | ||
|
|
Weight | Value | ||
|
|
Height | Value | ||
|
|
Sum of alcohol withdrawal syndrome score | Value | ||
| Patient location or locations and transfers | ||||
|
|
Unit of hospitalization | Category | ||
|
|
Transfers (medicine, surgery, intermediate care, and intensive care) | Category | ||
|
|
Date and time of admission | Date and time | ||
|
|
Date and time of discharge | Date and time | ||
| Diagnoses and procedures | ||||
|
|
DRGb codes | Category | ||
|
|
CHOPc codes | Category | ||
|
|
ICD-10d codes | Category | ||
|
|
Readmissions and reasons for readmissions (first, second, third, fourth, and subsequent readmissions) | Category | ||
|
|
Drugs coded for reimbursement | Category | ||
|
|
Intensive care unit length of stay (in hours) | Category | ||
|
|
Duration of mechanical ventilation (in hours) | Category | ||
|
|
Disease severity and scores | Category | ||
|
|
NEMSe | Category | ||
| Laboratory valuesf | ||||
|
|
Electrolytes and ions | |||
|
|
|
Blood ionogram (sodium and potassium) | mmol/L | |
|
|
|
Serum lactate and bicarbonate levels | mmol/L | |
|
|
|
Serum uric acid level | mmol/L | |
|
|
|
Serum urea level | mmol/L | |
|
|
|
Serum iron, transferrin saturation, and serum ferritin level | mmol/L and µg/L | |
|
|
Enzymes | |||
|
|
|
Serum levels of aminotransferases | ASTg and ALTh (UIi/L) | |
|
|
|
Serum levels of 5′-nucleotidase | UI/L | |
|
|
|
Serum level of CKj | UI/L | |
|
|
|
Serum level of GGTk | UI/L | |
|
|
|
Serum level of ALPl | UI/L | |
|
|
CBCm | |||
|
|
|
Red blood cell count | Absolute value/mm3 | |
|
|
|
Hemoglobin | mmol/L | |
|
|
|
Hematocrit | Percentage of total blood volume | |
|
|
|
Mean corpuscular volume | µ 3 | |
|
|
|
White blood cell count | Absolute value/mm3 | |
|
|
|
Platelet count | Absolute value/mm3 | |
|
|
|
Reticulocyte count | Absolute value/mm3 | |
|
|
Hemostasis | |||
|
|
|
PTn | Time | |
|
|
|
APTTo | Time | |
|
|
|
TTp | Time | |
|
|
|
INRq | N/Ar | |
|
|
|
Plasma fibrinogen | g/L | |
|
|
|
Procoagulant balance | Antithrombin (g/L), protein C and S (nmol/L), anticardiolipin antibody (GPLs unit), and anti-beta-2-glycoprotein 1 antibody (GPL unit) | |
|
|
|
Individual coagulation factors | Percentage relative to a reference pool | |
|
|
|
Fibrinolysis | D-dimer (µg/L) | |
|
|
|
Anticoagulation monitoring | Anti-Xa (percentage relative to a reference value) and anti-IIa (percentage relative to a reference value) | |
|
|
|
Markers of coagulation | TATt (ng/mL) and fragment 1 and 2 of prothrombin (percentage relative to a reference value) | |
|
|
Other | |||
|
|
|
Serum albumin | g/dL | |
|
|
|
Serum total protein | g/dL | |
|
|
|
Oxygen saturation in arterial blood | Percentage | |
|
|
|
CRPu | mg/L | |
|
|
|
Serum myoglobin | µg/L | |
|
|
|
Serum troponin | µg/L | |
|
|
|
Serum creatinine and creatinine clearance | mg/L and mL/minute | |
|
|
|
Serum total bilirubin and direct and indirect bilirubin | mg/L | |
|
|
|
Serum glycated hemoglobin | Percentage | |
|
|
|
Serum tumor markers available | N/A | |
| Prescription or medicationv | ||||
|
|
ATCw code (and product ID) | Category | ||
|
|
Information on dose and planned administration frequency, including unit (eg, milligrams) | Value and category | ||
|
|
Information on administration route (eg, intravenous administration vs oral) | Category | ||
|
|
PRNx orders (“as needed”: drugs available at patient’s request; eg, analgesics) | Category | ||
|
|
Administrations performed (signed by nurses) | Category | ||
aMedStat: MedStat regions are geographic areas with a sufficiently large population to anonymously assign a residence to each person hospitalized in Switzerland.
bDRG: Swiss Diagnosis Related Groups.
cCHOP: Swiss classification of surgical interventions.
dICD-10: International Classification of Diseases, 10th Revision.
eNEMS: Nine Equivalents of Nursing Manpower Use Score.
fLaboratory results that were ordered or received within the time frame of any of the recorded or extracted stays (if available).
gAST: Aspartate aminotransferase.
hALT: Alanine transaminase.
iUI: international unit.
jCK: creatine kinase.
kGGT: gamma-glutamyltransferase.
lALP: alkaline phosphatase.
mCBC: complete blood count.
nPT: prothrombin time.
oAPTT: activated partial thromboplastin time.
pTT: thrombin time.
qINR: international normalized ratio.
rN/A: not applicable.
sGPL: immunoglobulin G [IgG] phospholipid unit.
tTAT: thrombin-antithrombin III complex.
uCRP: C-reactive protein.
vAll medication orders that have (1) a planned start date ≤discharge date AND (2) a planned discontinuation date ≥admission date.
wATC: Anatomical Therapeutic Chemical.
xPRN: Pro re nata.