Healthcare
19 columns
120 rows
8 formats

Laboratory Test Orders and Results

This dataset provides comprehensive records of laboratory test orders and results, including standardized LOINC codes, test names, quantitative and qualitative results, reference ranges, abnormality flags, and detailed timestamps. It facilitates clinical decision support, quality assurance, and research by enabling precise tracking and analysis of lab diagnostics across healthcare providers and laboratories.

last updated 2 Nov 2025
by GoMask

The brief that made it

Clinical decision support and alerting for abnormal lab results

Sample rows

preview · 8 of 120 rows · all 19 columns

order_idstring	result_unitsstring	reference_range_lowfloat	ordering_provider_namestring	patient_idstring	test_loinc_codestring	test_namestring	order_datedatetime	collection_datedatetime	result_datedatetime	result_valuestring	reference_range_highfloat	abnormal_flagstring	performing_lab_idstring	performing_lab_namestring	specimen_typestring	ordering_provider_idstring	result_statusstring	commentsstring
ORD0001	mg/dL	70	Dr. Lesley Green	PAT1001	2345-7	Glucose	2024-05-01T08:14:00Z	2024-05-01T08:48:00Z	2024-05-01T10:15:00Z	92	110	N	LAB001	Quest Diagnostics	Blood	PRV101	Final	blank
ORD0002	mg/dL	100	Dr. Akash Patel	PAT1002	2093-3	Cholesterol	2024-05-01T09:02:00Z	2024-05-01T09:14:00Z	2024-05-01T11:42:00Z	203	199	H	LAB002	LabCorp	Blood	PRV102	Final	Elevated cholesterol, recommend follow-up.
ORD0003	mmol/L	135	Dr. Sarah Lin	PAT1003	2951-2	Sodium	2024-05-01T10:30:00Z	2024-05-01T10:50:00Z	2024-05-01T12:03:00Z	137	145	N	LAB003	Regional Medical Labs	Blood	PRV103	Final	blank
ORD0004	mmol/L	3.5	Dr. Rita Sandoval	PAT1004	2823-3	Potassium	2024-05-01T11:12:00Z	2024-05-01T11:35:00Z	2024-05-01T12:11:00Z	3.1	5.1	L	LAB004	Northside Clinical	Blood	PRV104	Final	Low potassium, dietary counseling advised.
ORD0005	mg/dL	0.6	Dr. Mark Benson	PAT1002	2160-0	Creatinine	2024-05-02T08:41:00Z	2024-05-02T09:00:00Z	2024-05-02T14:23:00Z	2.2	1.3	HH	LAB005	Downtown Hospital Lab	Blood	PRV105	Final	Critically high creatinine, immediate nephrology consult recommended.
ORD0006	blank	blank	Dr. Emily Wu	PAT1005	5792-7	Urine Protein	2024-05-02T09:13:00Z	2024-05-02T09:34:00Z	2024-05-02T11:47:00Z	Trace	blank	A	LAB006	City Health Lab	Urine	PRV106	Final	Protein detected, monitor for renal involvement.
ORD0007	blank	blank	Dr. Omar Nasser	PAT1006	5804-0	Urine Glucose	2024-05-02T10:25:00Z	2024-05-02T10:51:00Z	2024-05-02T12:04:00Z	Negative	blank	N	LAB006	City Health Lab	Urine	PRV107	Final	blank
ORD0008	blank	blank	Dr. Carlos Silva	PAT1007	32710-6	Urine Leukocyte Esterase	2024-05-02T12:10:00Z	2024-05-02T12:43:00Z	2024-05-02T14:21:00Z	Large	blank	AA	LAB007	Community Pathology Lab	Urine	PRV108	Final	Critically abnormal, possible urinary tract infection.
ORD0009	blank	blank	Dr. Ingrid Meyer	PAT1008	94500-6	COVID-19 PCR	2024-05-02T13:01:00Z	2024-05-02T13:22:00Z	2024-05-02T17:34:00Z	Positive	blank	A	LAB008	Global Infectious Disease Lab	Nasopharyngeal Swab	PRV109	Final	COVID-19 detected, patient isolation required.
ORD0010	F	97	Dr. Henry Olsen	PAT1009	1988-5	Body Temperature	2024-05-02T14:35:00Z	2024-05-02T14:49:00Z	2024-05-02T15:03:00Z	104.2	99	HH	LAB009	Emergency Hospital Lab	Oral	PRV110	Final	Critical fever, immediate intervention required.
ORD0011	mg/L	0	Dr. Fiona Park	PAT1001	30522-7	C-Reactive Protein	2024-05-02T15:22:00Z	2024-05-02T15:54:00Z	2024-05-02T17:15:00Z	17.2	5	H	LAB010	Specialty Immunology Lab	Blood	PRV111	Final	Elevated CRP, possible inflammation.
ORD0012	10^3/uL	4	Dr. Lesley Green	PAT1010	718-7	White Blood Cell Count	2024-05-03T08:00:00Z	2024-05-03T08:19:00Z	2024-05-03T09:02:00Z	6.4	11	N	LAB001	Quest Diagnostics	Blood	PRV101	Final	blank
ORD0013	mmol/L	3.5	Dr. Akash Patel	PAT1003	2823-3	Potassium	2024-05-03T08:45:00Z	2024-05-03T09:02:00Z	2024-05-03T09:59:00Z	5.4	5.1	H	LAB002	LabCorp	Blood	PRV102	Final	Elevated potassium, review medications.
ORD0014	mmol/L	135	Dr. Sarah Lin	PAT1011	2951-2	Sodium	2024-05-03T09:21:00Z	2024-05-03T09:38:00Z	2024-05-03T10:25:00Z	134	145	L	LAB003	Regional Medical Labs	Blood	PRV103	Final	Low sodium, check hydration status.
ORD0015	mg/dL	0.6	Dr. Rita Sandoval	PAT1012	2160-0	Creatinine	2024-05-03T10:10:00Z	2024-05-03T10:33:00Z	2024-05-03T13:55:00Z	0.7	1.3	N	LAB004	Northside Clinical	Blood	PRV104	Final	blank
ORD0016	blank	blank	Dr. Emily Wu	PAT1013	5792-7	Urine Protein	2024-05-03T11:05:00Z	2024-05-03T11:27:00Z	2024-05-03T13:12:00Z	Negative	blank	N	LAB006	City Health Lab	Urine	PRV106	Final	blank
ORD0017	blank	blank	Dr. Carlos Silva	PAT1014	5804-0	Urine Glucose	2024-05-03T12:13:00Z	2024-05-03T12:28:00Z	2024-05-03T14:09:00Z	Trace	blank	A	LAB007	Community Pathology Lab	Urine	PRV108	Final	Trace glucose detected, monitor for diabetes.
ORD0018	blank	blank	Dr. Omar Nasser	PAT1015	32710-6	Urine Leukocyte Esterase	2024-05-03T13:32:00Z	2024-05-03T13:57:00Z	2024-05-03T15:18:00Z	Negative	blank	N	LAB006	City Health Lab	Urine	PRV107	Final	blank
ORD0019	blank	blank	Dr. Ingrid Meyer	PAT1016	94500-6	COVID-19 PCR	2024-05-03T14:41:00Z	2024-05-03T14:57:00Z	2024-05-03T17:23:00Z	Negative	blank	N	LAB008	Global Infectious Disease Lab	Nasopharyngeal Swab	PRV109	Final	blank
ORD0020	F	97	Dr. Henry Olsen	PAT1017	1988-5	Body Temperature	2024-05-04T08:22:00Z	2024-05-04T08:34:00Z	2024-05-04T08:46:00Z	96.8	99	LL	LAB009	Emergency Hospital Lab	Oral	PRV110	Final	Hypothermia detected, warming protocol initiated.

What the 120 rows show

from the 120-row sample

Mg/L (result units) stands out: mean reference_range_low is 0.0, against 58.2 for the rest.

26.0median reference_range_low
3result statuses
4specimen types
7abnormal flags
15performing lab names
21test names

Mean reference_range_low by result_units76 rows

reference_range_low76 rows, in bands of 20

Median 26.0, from 0.0 to 135.0.

ordering_provider_name118 rows with a value · 2 left blank

Dr. Akash Patel9
Dr. Rita Sandoval9
Dr. Lesley Green7
Dr. Sarah Lin7
Dr. Emily Wu6
Dr. Michael Lee6
Dr. Lisa Wong6
Dr. Carlos Silva5
Dr. Ingrid Meyer5
Dr. Henry Olsen5

19 columns by typefrom the column list below

string 14
float 2
datetime 3

Columns

19 columns in three groups

blueprint · 19 columns
column	type	description	example
Text 14 columns
`order_id`	string	Unique identifier for the laboratory test orderunique	ORD0001
`patient_id`	string	Unique identifier for the patient associated with the test order	PAT1001
`test_loinc_code`	string	LOINC code representing the specific laboratory test	2345-7
`test_name`	string	Human-readable name of the laboratory test	Glucose
`result_value`	string	Value of the test result (numeric or qualitative)	92
`result_units`	string	Units of measurement for the test result value7 unitses · optional	mg/dL
`abnormal_flag`	string	Flag indicating if the result is abnormal (e.g., 'H' for high, 'L' for low, 'N' for normal)7 values · optional	N
`performing_lab_id`	string	Unique identifier for the laboratory that performed the test	LAB001
`performing_lab_name`	string	Name of the laboratory that performed the testoptional	Quest Diagnostics
`specimen_type`	string	Type of specimen collected for the test (e.g., blood, urine)4 types · optional	Blood
`ordering_provider_id`	string	Unique identifier for the provider who ordered the testoptional	PRV101
`ordering_provider_name`	string	Name of the provider who ordered the testoptional	Dr. Lesley Green
`result_status`	string	Status of the test result (e.g., 'Final', 'Preliminary', 'Corrected')Final · Preliminary · Corrected · Cancelled	Final
`comments`	string	Additional comments or notes related to the test order or resultoptional	Elevated cholesterol, rec…
Numbers 2 columns
`reference_range_low`	float	Lower bound of the reference range for the test resultoptional	70
`reference_range_high`	float	Upper bound of the reference range for the test resultoptional	110
Dates and times 3 columns
`order_date`	datetime	Date and time the laboratory test was ordered	2024-05-01T08:14:00Z
`collection_date`	datetime	Date and time the specimen was collected for the test	2024-05-01T08:48:00Z
`result_date`	datetime	Date and time the test result was reported	2024-05-01T10:15:00Z

Use it for

A healthcare dashboard
Reference_range_low by result_units and a breakdown of ordering_provider_name. Excel, Power BI or Tableau.
Why do the 11 mg/L rows have a mean reference_range_low of 0.0?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Orders120
ORD000170mg/dL
ORD0002100mg/dL
ORD0003135mmol/L
A software demo
Believable orders with patient_id, test_loinc_code and test_name to fill a screen in front of a buyer.

This dataset120 rows19 columns

Yours1,000 rows19 columns

blueprint · laboratory-test-orders-and-results

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 19 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with

Order ID and result ID unique
Test name and LOINC code (Logical Observation Identifiers Names and Codes)
Ordering provider with NPI
Collection date/time and result date/time
Result value: numeric, text, or coded
Units of measure standardized (UCUM)
Reference range (normal range) by age/gender
Abnormal flag: high, low, critical, normal

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: laboratory-test-orders-and-results

What should your data show?

No signup. No card.

Sample rows

What the 120 rows show

Columns

Use it for

A healthcare dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Healthcare

What should your data show?