Laboratory Values to consider (Query required)

[NadavLankin]

Inpatients, FTR include/exclude criteria FROM LABEVENTS (https://mimic.physionet.org/mimictables/labevents/)

Laboratory Values to focus on:

• Serum sodium < 110 mEq/L or > 170 mEq/L
• Serum potassium < 2.0 mEq/L or > 7.0 mEq/L
• PaO2 < 50 mm Hg
• pH < 7.1 or > 7.7
• Serum glucose > 800 mg/dl
• Serum calcium > 15 mg/dl
• Toxic level of drug or other chemical substance in a hemodynamically or neurologically
  compromised patient

references: http://www.ahpi.in/EMERGENCY%20DEPARTMENTS-HEALTH%20QUEST%20GUIDELINES%202018.pdf

[Aggrus]

In sodium, pH, potassium, glucose, and calcium is it general sodium concentration, or in a specific fluid?
pH shows too many results, so the database only shows some of them.
PaO2 also shows too many results.

I can perform filtered querries and get multiple excel sheets to show all results, if we need all of them.