blood test database

patients

1 rows6 columns

patient_id	first_name	last_name	date_of_birth	gender	phone
EA639450	AUTUMN	SANDS	1987-09-13T00:00:00.000Z	F	616.437.1648

test orders

1 rows11 columns

specimen_id	patient_id	requisition_number	lab_ref_number	collected_datetime	received_datetime	reported_datetime	client_number	ordering_provider	facility_name	facility_address
ZW648383S	EA639450	0070004	CB91FC85DC4F433E	2026-01-14T11:16:00.000Z	2026-01-15T05:32:00.000Z	2026-01-21T14:59:00.000Z	73929412	DAMASCO, LEO	JUNCTION	440 N BARRANCA AVE # 3811, COVINA, CA 91723-1722

lab results

94 rows14 columns

test_name	result_value	unit	result_id	specimen_id	panel_name	result_numeric	reference_range_text	flag	lab_code	test_category
IRON, TOTAL	103	mcg/dL	1	ZW648383S	IRON, TIBC AND FERRITIN PANEL	103.0000	40-190		CB	Hematology
IRON BINDING CAPACITY	421	mcg/dL	2	ZW648383S	IRON, TIBC AND FERRITIN PANEL	421.0000	250-450		CB	Hematology
% SATURATION	24	%	3	ZW648383S	IRON, TIBC AND FERRITIN PANEL	24.0000	16-45		CB	Hematology
FERRITIN	13	ng/mL	4	ZW648383S	IRON, TIBC AND FERRITIN PANEL	13.0000	16-154	L	CB	Hematology
T3 UPTAKE	34	%	5	ZW648383S	THYROID PANEL WITH TSH	34.0000	22-35		CB	Endocrinology
T4 (THYROXINE), TOTAL	7.0	mcg/dL	6	ZW648383S	THYROID PANEL WITH TSH	7.0000	5.1-11.9		CB	Endocrinology
FREE T4 INDEX (T7)	2.4		7	ZW648383S	THYROID PANEL WITH TSH	2.4000	1.4-3.8		CB	Endocrinology
TSH	8.05	mIU/L	8	ZW648383S	THYROID PANEL WITH TSH	8.0500	0.40-4.50	H	CB	Endocrinology
T3, FREE	2.6	pg/mL	9	ZW648383S	THYROID PANEL	2.6000	2.3-4.2		CB	Endocrinology
ALBUMIN	4.8	g/dL	10	ZW648383S	TESTOSTERONE, FREE, BIOAVAILABLE AND TOTAL, MS	4.8000	3.6-5.1		Z3E	Endocrinology
SEX HORMONE BINDING GLOBULIN	42	nmol/L	11	ZW648383S	TESTOSTERONE, FREE, BIOAVAILABLE AND TOTAL, MS	42.0000	17-124		Z3E	Endocrinology
TESTOSTERONE, FREE	1.9	pg/mL	12	ZW648383S	TESTOSTERONE, FREE, BIOAVAILABLE AND TOTAL, MS	1.9000	0.2-5.0		Z3E	Endocrinology
TESTOSTERONE, BIOAVAILABLE	4.2	ng/dL	13	ZW648383S	TESTOSTERONE, FREE, BIOAVAILABLE AND TOTAL, MS	4.2000	0.5-8.5		Z3E	Endocrinology
TESTOSTERONE, TOTAL, MS	20	ng/dL	14	ZW648383S	TESTOSTERONE, FREE, BIOAVAILABLE AND TOTAL, MS	20.0000	2-45		Z3E	Endocrinology
LIPOPROTEIN (a)	35	nmol/L	15	ZW648383S	CARDIOVASCULAR	35.0000	<75		CB	Cardiovascular
HS CRP	0.5	mg/L	16	ZW648383S	CARDIOVASCULAR	0.5000	<1.0		CB	Cardiovascular
HOMOCYSTEINE	6.4	umol/L	17	ZW648383S	CARDIOVASCULAR	6.4000	<=11.0		CB	Cardiovascular
APOLIPOPROTEIN B	85	mg/dL	18	ZW648383S	CARDIOVASCULAR	85.0000	<90		EZ	Cardiovascular
CHOLESTEROL, TOTAL	204	mg/dL	19	ZW648383S	LIPID PANEL WITH RATIOS	204.0000	<200	H	CB	Cardiovascular
HDL CHOLESTEROL	79	mg/dL	20	ZW648383S	LIPID PANEL WITH RATIOS	79.0000	>=50		CB	Cardiovascular
TRIGLYCERIDES	69	mg/dL	21	ZW648383S	LIPID PANEL WITH RATIOS	69.0000	<150		CB	Cardiovascular
LDL-CHOLESTEROL	109	mg/dL	22	ZW648383S	LIPID PANEL WITH RATIOS	109.0000	<100	H	CB	Cardiovascular
CHOL/HDLC RATIO	2.6		23	ZW648383S	LIPID PANEL WITH RATIOS	2.6000	<5.0		CB	Cardiovascular
LDL/HDL RATIO	1.4		24	ZW648383S	LIPID PANEL WITH RATIOS	1.4000	<2.34		CB	Cardiovascular
NON HDL CHOLESTEROL	125	mg/dL	25	ZW648383S	LIPID PANEL WITH RATIOS	125.0000	<130		CB	Cardiovascular
GLUCOSE	91	mg/dL	26	ZW648383S	COMPREHENSIVE METABOLIC PANEL	91.0000	65-99		CB	Chemistry
UREA NITROGEN (BUN)	15	mg/dL	27	ZW648383S	COMPREHENSIVE METABOLIC PANEL	15.0000	7-25		CB	Chemistry
CREATININE	0.88	mg/dL	28	ZW648383S	COMPREHENSIVE METABOLIC PANEL	0.8800	0.50-0.97		CB	Chemistry
EGFR	86	mL/min/1.73m2	29	ZW648383S	COMPREHENSIVE METABOLIC PANEL	86.0000	>=60		CB	Chemistry
SODIUM	140	mmol/L	30	ZW648383S	COMPREHENSIVE METABOLIC PANEL	140.0000	135-146		CB	Chemistry
POTASSIUM	4.0	mmol/L	31	ZW648383S	COMPREHENSIVE METABOLIC PANEL	4.0000	3.5-5.3		CB	Chemistry
CHLORIDE	104	mmol/L	32	ZW648383S	COMPREHENSIVE METABOLIC PANEL	104.0000	98-110		CB	Chemistry
CARBON DIOXIDE	29	mmol/L	33	ZW648383S	COMPREHENSIVE METABOLIC PANEL	29.0000	20-32		CB	Chemistry
CALCIUM	9.3	mg/dL	34	ZW648383S	COMPREHENSIVE METABOLIC PANEL	9.3000	8.6-10.2		CB	Chemistry
PROTEIN, TOTAL	6.7	g/dL	35	ZW648383S	COMPREHENSIVE METABOLIC PANEL	6.7000	6.1-8.1		CB	Chemistry
ALBUMIN	4.6	g/dL	36	ZW648383S	COMPREHENSIVE METABOLIC PANEL	4.6000	3.6-5.1		CB	Chemistry
GLOBULIN	2.1	g/dL	37	ZW648383S	COMPREHENSIVE METABOLIC PANEL	2.1000	1.9-3.7		CB	Chemistry
ALBUMIN/GLOBULIN RATIO	2.2		38	ZW648383S	COMPREHENSIVE METABOLIC PANEL	2.2000	1.0-2.5		CB	Chemistry
BILIRUBIN, TOTAL	0.7	mg/dL	39	ZW648383S	COMPREHENSIVE METABOLIC PANEL	0.7000	0.2-1.2		CB	Chemistry
ALKALINE PHOSPHATASE	54	U/L	40	ZW648383S	COMPREHENSIVE METABOLIC PANEL	54.0000	31-125		CB	Chemistry
AST	18	U/L	41	ZW648383S	COMPREHENSIVE METABOLIC PANEL	18.0000	10-30		CB	Chemistry
ALT	18	U/L	42	ZW648383S	COMPREHENSIVE METABOLIC PANEL	18.0000	6-29		CB	Chemistry
HEMOGLOBIN A1c	5.1	%	43	ZW648383S	METABOLIC	5.1000	<5.7		CB	Chemistry
eAG (mg/dL)	100	mg/dL	44	ZW648383S	METABOLIC	100.0000			CB	Chemistry
URIC ACID	5.3	mg/dL	45	ZW648383S	METABOLIC	5.3000	2.5-7.0		CB	Chemistry
BILIRUBIN, DIRECT	0.1	mg/dL	46	ZW648383S	METABOLIC	0.1000	<=0.2		CB	Chemistry
BILIRUBIN, INDIRECT	0.6	mg/dL	47	ZW648383S	METABOLIC	0.6000	0.2-1.2		CB	Chemistry
GGT	17	U/L	48	ZW648383S	METABOLIC	17.0000	3-50		CB	Chemistry
THYROGLOBULIN ANTIBODIES	7	IU/mL	49	ZW648383S	THYROID PEROXIDASE AND THYROGLOBULIN ANTIBODIES	7.0000	<=1	H	CB	Immunology
THYROID PEROXIDASE ANTIBODIES	<1	IU/mL	50	ZW648383S	THYROID PEROXIDASE AND THYROGLOBULIN ANTIBODIES		<9		CB	Immunology
IGF 1, LC/MS	225	ng/mL	51	ZW648383S	GROWTH HORMONE	225.0000	53-331		EZ	Endocrinology
Z SCORE (FEMALE)	1.0	SD	52	ZW648383S	GROWTH HORMONE	1.0000	-2.0 to +2.0		EZ	Endocrinology
SED RATE BY MODIFIED WESTERGREN	2	mm/h	53	ZW648383S	INFLAMMATORY	2.0000	<=20		CB	Hematology
WHITE BLOOD CELL COUNT	6.8	Thousand/uL	54	ZW648383S	CBC (INCLUDES DIFF/PLT)	6.8000	3.8-10.8		CB	Hematology
RED BLOOD CELL COUNT	4.17	Million/uL	55	ZW648383S	CBC (INCLUDES DIFF/PLT)	4.1700	3.80-5.10		CB	Hematology
HEMOGLOBIN	13.2	g/dL	56	ZW648383S	CBC (INCLUDES DIFF/PLT)	13.2000	11.7-15.5		CB	Hematology
HEMATOCRIT	40.1	%	57	ZW648383S	CBC (INCLUDES DIFF/PLT)	40.1000	35.9-46.0		CB	Hematology
MCV	96.2	fL	58	ZW648383S	CBC (INCLUDES DIFF/PLT)	96.2000	81.4-101.7		CB	Hematology
MCH	31.7	pg	59	ZW648383S	CBC (INCLUDES DIFF/PLT)	31.7000	27.0-33.0		CB	Hematology
MCHC	32.9	g/dL	60	ZW648383S	CBC (INCLUDES DIFF/PLT)	32.9000	31.6-35.4		CB	Hematology
RDW	12.4	%	61	ZW648383S	CBC (INCLUDES DIFF/PLT)	12.4000	11.0-15.0		CB	Hematology
PLATELET COUNT	236	Thousand/uL	62	ZW648383S	CBC (INCLUDES DIFF/PLT)	236.0000	140-400		CB	Hematology
MPV	12.1	fL	63	ZW648383S	CBC (INCLUDES DIFF/PLT)	12.1000	7.5-12.5		CB	Hematology
ABSOLUTE NEUTROPHILS	4298	cells/uL	64	ZW648383S	CBC (INCLUDES DIFF/PLT)	4298.0000	1500-7800		CB	Hematology
ABSOLUTE LYMPHOCYTES	1897	cells/uL	65	ZW648383S	CBC (INCLUDES DIFF/PLT)	1897.0000	850-3900		CB	Hematology
ABSOLUTE MONOCYTES	388	cells/uL	66	ZW648383S	CBC (INCLUDES DIFF/PLT)	388.0000	200-950		CB	Hematology
ABSOLUTE EOSINOPHILS	129	cells/uL	67	ZW648383S	CBC (INCLUDES DIFF/PLT)	129.0000	15-500		CB	Hematology
ABSOLUTE BASOPHILS	88	cells/uL	68	ZW648383S	CBC (INCLUDES DIFF/PLT)	88.0000	0-200		CB	Hematology
NEUTROPHILS	63.2	%	69	ZW648383S	CBC (INCLUDES DIFF/PLT)	63.2000			CB	Hematology
LYMPHOCYTES	27.9	%	70	ZW648383S	CBC (INCLUDES DIFF/PLT)	27.9000			CB	Hematology
MONOCYTES	5.7	%	71	ZW648383S	CBC (INCLUDES DIFF/PLT)	5.7000			CB	Hematology
EOSINOPHILS	1.9	%	72	ZW648383S	CBC (INCLUDES DIFF/PLT)	1.9000			CB	Hematology
BASOPHILS	1.3	%	73	ZW648383S	CBC (INCLUDES DIFF/PLT)	1.3000			CB	Hematology
VITAMIN B12	800	pg/mL	74	ZW648383S	VITAMIN B12/FOLATE, SERUM PANEL	800.0000	200-1100		CB	Chemistry
FOLATE, SERUM	>24.0	ng/mL	75	ZW648383S	VITAMIN B12/FOLATE, SERUM PANEL		>5.4		CB	Chemistry
VITAMIN D,25-OH,TOTAL,IA	64	ng/mL	76	ZW648383S	VITAMINS	64.0000	30-100		CB	Chemistry
CORTISOL, TOTAL	11.6	mcg/dL	77	ZW648383S	HORMONES	11.6000	4.0-22.0 (8am)		CB	Endocrinology
DHEA SULFATE	60	mcg/dL	78	ZW648383S	HORMONES	60.0000	19-237		CB	Endocrinology
FSH	9.0	mIU/mL	79	ZW648383S	HORMONES	9.0000	2.5-10.2 (Follicular)		CB	Endocrinology
INSULIN	5.0	uIU/mL	80	ZW648383S	HORMONES	5.0000	<=18.4		CB	Endocrinology
LH	6.4	mIU/mL	81	ZW648383S	HORMONES	6.4000	1.9-12.5 (Follicular)		CB	Endocrinology
PROGESTERONE	<0.5	ng/mL	82	ZW648383S	HORMONES		<1.0 (Follicular)		CB	Endocrinology
PROLACTIN	8.9	ng/mL	83	ZW648383S	HORMONES	8.9000	3.0-30.0		CB	Endocrinology
ESTRADIOL	32	pg/mL	84	ZW648383S	HORMONES	32.0000	30-144 (Follicular)		CB	Endocrinology
PSA, TOTAL	<0.1	ng/mL	85	ZW648383S	PSA (FREE AND TOTAL)		Female: Not established		CB	Chemistry
PSA, FREE	<0.1	ng/mL	86	ZW648383S	PSA (FREE AND TOTAL)				CB	Chemistry
LDL P	1291	nmol/L	87	ZW648383S	CARDIO IQ - LIPOPROTEIN FRACTIONATION NMR	1291.0000	<935 (Optimal)	H	Z4M	Cardiovascular
SMALL LDL P	<154	nmol/L	88	ZW648383S	CARDIO IQ - LIPOPROTEIN FRACTIONATION NMR		<467 (Optimal)		Z4M	Cardiovascular
LDL SIZE	21.8	nm	89	ZW648383S	CARDIO IQ - LIPOPROTEIN FRACTIONATION NMR	21.8000	>20.5 (Optimal)		Z4M	Cardiovascular
HDL P	43.7	umol/L	90	ZW648383S	CARDIO IQ - LIPOPROTEIN FRACTIONATION NMR	43.7000	>32.8 (Optimal)		Z4M	Cardiovascular
LARGE HDL P	14.0	umol/L	91	ZW648383S	CARDIO IQ - LIPOPROTEIN FRACTIONATION NMR	14.0000	>7.2 (Optimal)		Z4M	Cardiovascular
HDL SIZE	9.8	nm	92	ZW648383S	CARDIO IQ - LIPOPROTEIN FRACTIONATION NMR	9.8000	>9.0 (Optimal)		Z4M	Cardiovascular
LARGE VLDL P	1.7	nmol/L	93	ZW648383S	CARDIO IQ - LIPOPROTEIN FRACTIONATION NMR	1.7000	<3.7 (Optimal)		Z4M	Cardiovascular
VLDL SIZE	46.7	nm	94	ZW648383S	CARDIO IQ - LIPOPROTEIN FRACTIONATION NMR	46.7000	<47.1 (Optimal)		Z4M	Cardiovascular