Labs

Chemistry

Table mimiciv_hosp.labevents

SELECT subject_id, hadm_id,

Short	Name	Description	itemid	Constraint	UOM
	albumin	ALBUMIN	50862	0 < valuenum ≤ 20
	globulin	Globulin	50930	0 < valuenum ≤ 10
	total_protein	Total protein	50976	0 < valuenum ≤ 20
	aniongap	ANION GAP	50868	valuenum ≤ 10000
HCO₃	bicarbonate	BICARBONATE	50882	0 < valuenum ≤ 10000
BUN	Blood Urea Nitrogen	UREA NITROGEN	51006	0 < valuenum ≤ 300
Ca	calcium	Calcium	50893	0 < valuenum ≤ 10000
Cl	chloride	CHLORIDE	50902	0 < valuenum ≤ 10000
S.Cr hoặc Cr	creatinine	Creatinine	50912	0 < valuenum ≤ 150	mg/dL
	glucose	GLUCOSE	50931	0 < valuenum ≤ 10000	mg/dL
NA⁺	sodium	SODIUM	50931	0 < valuenum ≤ 200
K	potassium	POTASSIUM	50971	0 < valuenum ≤ 30
P	Phosphate	Phosphate	50970		mg/dL
Mg	Magnesium	Magnesium	50960		mg/dL
	ast	Asparate Aminotransferase (AST)	50878		IU/L
	alt	Alanine Aminotransferase (ALT)	50861		IU/L
	alp	Alkaline Phosphatase	50971		IU/L

Chemistry

itemid	label	fluid	category
50862	Albumin	Blood	Chemistry
50868	Anion Gap	Blood	Chemistry
50882	Bicarbonate	Blood	Chemistry
50893	Calcium, Total	Blood	Chemistry
50902	Chloride	Blood	Chemistry
50912	Creatinine	Blood	Chemistry
50930	Globulin	Blood	Chemistry
50931	Glucose	Blood	Chemistry
50971	Potassium	Blood	Chemistry
50976	Protein, Total	Blood	Chemistry
50983	Sodium	Blood	Chemistry
51006	Urea Nitrogen	Blood	Chemistry

Coagulation - Xét nghiệm đông máu

label

itemid
51237	INR
51274	PT
51275	PTT

Blood Count

mimiciv_hosp.labevents

White Blood Cells

itemid	Name	Description
51221	hematocrit	Hematocrit
51222	hemoglobin	Hemoglobin
51248	mch	MCH
51249	mchc	MCHC
51250	mcv	MCV
51265	platelet	Platelet Count
51279	rbc	Red Blood Cells
51277	rdw
52159	rdwsd	Platelet Aggregation
51301	wbc

mimiciv_hosp.d_labitem

itemid	label	fluid	category
51221	Hematocrit	Blood	Hematology
51222	Hemoglobin	Blood	Hematology
51248	MCH	Blood	Hematology
51249	MCHC	Blood	Hematology
51250	MCV	Blood	Hematology
51265	Platelet Count	Blood	Hematology
51277	RDW	Blood	Hematology
51279	Red Blood Cells	Blood	Hematology
51301	White Blood Cells	Blood	Hematology
52159	Platelet Aggregation	Blood	Hematology

Blood Different

Table mimiciv_hosp.labevents;

Name	itemid	Note
wbc	51300, 51301, 51755
basophils_abs	52069
eosinophils_abs	52073, 51199	52073 in K/uL, 51199 in #/uL
lymphocytes_abs	51133, 52769	51133 in K/uL, 52769 in #/uL
monocytes_abs	52074, 51253	52074 in K/uL, 51253 in #/uL
neutrophils_abs	52075
granulocytes_abs	52075	convert from #/uL to K/uL
basophils	51146	percentages, equal to cell count / white blood cell count
eosinophils	51200	percentages, equal to cell count / white blood cell count
lymphocytes	51244, 51245	percentages, equal to cell count / white blood cell count
monocytes	51254	percentages, equal to cell count / white blood cell count
neutrophils	51256	percentages, equal to cell count / white blood cell count
atypical_lymphocytes	51143	percentages, equal to cell count / white blood cell count
bands	51144	other cell count percentages
immature_granulocytes	52135	other cell count percentages
metamyelocytes	51251	other cell count percentages
nrbc	51257	other cell count percentages

Table mimiciv_hosp.d_labitems

itemid	label	fluid	category
51133	Absolute Lymphocyte Count	Blood	Hematology
51143	Atypical Lymphocytes	Blood	Hematology
51144	Bands	Blood	Hematology
51146	Basophils	Blood	Hematology
51199	Eosinophil Count	Blood	Hematology
51200	Eosinophils	Blood	Hematology
51218	Granulocyte Count	Blood	Hematology
51244	Lymphocytes	Blood	Hematology
51245	Lymphocytes, Percent	Blood	Hematology
51251	Metamyelocytes	Blood	Hematology
51253	Monocyte Count	Blood	Hematology
51254	Monocytes	Blood	Hematology
51256	Neutrophils	Blood	Hematology
51257	Nucleated Red Cells	Blood	Hematology
51300	WBC Count	Blood	Hematology
51301	White Blood Cells	Blood	Hematology
51755	White Blood Cells	Blood	Chemistry
52069	Absolute Basophil Count	Blood	Hematology
52073	Absolute Eosinophil Count	Blood	Hematology
52074	Absolute Monocyte Count	Blood	Hematology
52075	Absolute Neutrophil Count	Blood	Hematology
52135	Immature Granulocytes	Blood	Hematology
52769	Absolute Lymphocyte Count	Blood	Hematology

SELECT *
FROM mimiciv_icu.chartevents ce
JOIN mimiciv_icu.icustays icu ON ce.stay_id = icu.stay_id
WHERE charttime >= icu.intime + interval '6 hour'
  AND charttime <= icu.intime + interval '1 day'