Healthcare
29 columns
200 rows
8 formats

Healthcare Lab Test Utilization

This dataset provides detailed, transaction-level records of lab test ordering and utilization across hospitals and clinics, including facility, test, patient, physician, cost, and diagnostic context. It enables comprehensive analysis of test utilization patterns, cost management, and supports clinical decision-making and operational efficiency initiatives.

last updated 20 Aug 2025
by GoMask

The brief that made it

Analyzing lab test ordering patterns for cost control and resource optimization

Sample rows

preview · 8 of 200 rows · all 29 columns

utilization_idstring	test_result_flagstring	test_result_valuefloat	test_duplicate_flagboolean	test_result_unitstring	facility_idstring	facility_namestring	facility_typestring	facility_street_addressstring	facility_citystring	facility_statestring	facility_postal_codestring	facility_countrystring	test_order_idstring	test_codestring	test_namestring	test_categorystring	test_order_datedate	test_completed_datedate	ordering_physician_idstring	ordering_physician_namestring	patient_idstring	patient_ageinteger	patient_genderstring	test_costfloat	test_reimbursed_amountfloat	test_utilization_statusstring	diagnosis_codestring	diagnosis_descriptionstring
UTIL0001	normal	98.7	false	mg/dL	FAC001	General Hospital	hospital	123 Main St	Boston	MA	02118	USA	TO10001	LOINC:2345-7	Glucose, Serum	chemistry	2023-01-15	2023-01-16	PHY001	Dr. Sarah Carter	PAT1001	32	female	28.5	27.1	completed	E11.9	Type 2 diabetes mellitus without complications
UTIL0002	normal	13.9	false	g/dL	FAC002	Downtown Clinic	clinic	456 Clinic Ave	Chicago	IL	60611	USA	TO10002	LOINC:718-7	Hemoglobin	hematology	2023-01-18	2023-01-19	PHY002	Dr. Michael Lee	PAT1002	26	male	18	16.5	completed	Z00.00	Encounter for general adult medical examination without abnormal findings
UTIL0003	high	177000	false	/uL	FAC003	Suburban Medical Center	hospital	789 Health Blvd	Phoenix	AZ	85016	USA	TO10003	LOINC:4548-4	Platelet Count	hematology	2023-01-20	2023-01-21	PHY003	Dr. Linda Patel	PAT1003	68	female	32	30	completed	D64.9	Anemia, unspecified
UTIL0004	critical	1	false	Positive	FAC004	Express Urgent Care	urgent care	101 Fast Ln	Dallas	TX	75201	USA	TO10004	LOINC:94531-1	COVID-19 PCR	microbiology	2023-01-22	2023-01-23	PHY004	Dr. James Robinson	PAT1004	8	male	65	40	completed	U07.1	COVID-19, virus identified
UTIL0005	high	220.5	false	mg/dL	FAC005	Northern Laboratory	laboratory	202 Lab Rd	Seattle	WA	98109	USA	TO10005	LOINC:2093-3	Cholesterol, Total	chemistry	2023-01-25	2023-01-27	PHY005	Dr. Emily Nguyen	PAT1005	74	female	42.5	35.6	completed	E78.0	Pure hypercholesterolemia
UTIL0006	normal	27.2	false	kg/m2	FAC006	Sunrise Clinic	clinic	303 Sunrise Ave	Miami	FL	33136	USA	TO10006	LOINC:39156-5	Body Mass Index	vital	2023-01-28	2023-01-28	PHY006	Dr. Carlos Martinez	PAT1006	29	female	12	10.5	completed	Z68.1	Body mass index (BMI) 19.9 or less, adult
UTIL0007	normal	1.3	false	mg/dL	FAC007	Westside Laboratory	laboratory	404 Lab Pkwy	San Francisco	CA	94107	USA	TO10007	LOINC:1975-2	Creatinine	chemistry	2023-01-30	2023-01-31	PHY007	Dr. Olivia Chen	PAT1007	47	male	21	20	completed	N18.9	Chronic kidney disease, unspecified
UTIL0008	low	10.5	false	g/dL	FAC008	Remote Clinic	clinic	blank	Nome	AK	99762	USA	TO10008	LOINC:718-7	Hemoglobin	hematology	2023-02-01	2023-02-02	PHY008	Dr. Henry Davis	PAT1008	6	male	14.7	14.7	completed	D50.9	Iron deficiency anemia, unspecified
UTIL0009	high	8.2	false	mg/L	FAC009	CareFirst Urgent Care	urgent care	505 Care Dr	Houston	TX	77002	USA	TO10009	LOINC:48065-7	C-reactive Protein	chemistry	2023-02-04	2023-02-05	PHY009	Dr. William Scott	PAT1009	55	female	36	32	completed	R79.1	Abnormal levels of other serum enzymes
UTIL0010	critical	100000	false	CFU/mL	FAC010	Green Valley Medical	hospital	606 Valley Rd	Denver	CO	80218	USA	TO10010	LOINC:15074-8	Urine Culture	microbiology	2023-02-07	2023-02-09	PHY010	Dr. Jennifer Kim	PAT1010	79	female	98	60	completed	N39.0	Urinary tract infection, site not specified
UTIL0011	normal	142	false	mmol/L	FAC001	General Hospital	hospital	123 Main St	Boston	MA	02118	USA	TO10011	LOINC:2571-8	Sodium, Serum	chemistry	2023-02-10	2023-02-10	PHY011	Dr. Rebecca Singh	PAT1011	41	female	16.5	15	completed	E87.1	Hypo-osmolality and hyponatremia
UTIL0012	low	6000	false	/uL	FAC011	Highland Clinic	clinic	707 Highland St	Portland	OR	97209	USA	TO10012	LOINC:779-5	White Blood Cell Count	hematology	2023-02-12	2023-02-13	PHY012	Dr. Patrick Turner	PAT1012	3	male	13	13	completed	D72.819	Other decreased white blood cell count
UTIL0013	high	1	false	Positive	FAC012	Riverfront Urgent Care	urgent care	808 River Rd	St. Louis	MO	63101	USA	TO10013	LOINC:6299-2	Urine Leukocyte Esterase	chemistry	2023-02-14	2023-02-14	PHY013	Dr. Steven Young	PAT1013	20	female	21.8	18.6	completed	N30.00	Acute cystitis without hematuria
UTIL0014	low	87	false	mmol/L	FAC013	Central Laboratory	laboratory	909 Central Ave	Atlanta	GA	30303	USA	TO10014	LOINC:2951-2	Sodium, Urine	chemistry	2023-02-16	2023-02-17	PHY014	Dr. Laura Green	PAT1014	59	male	25.3	22	completed	E87.1	Hypo-osmolality and hyponatremia
UTIL0015	normal	195.3	false	mg/dL	FAC014	Metro Medical Center	hospital	111 Metro Dr	New York	NY	10016	USA	TO10015	LOINC:24323-8	Lipid Panel	chemistry	2023-02-18	2023-02-19	PHY015	Dr. Benjamin Clark	PAT1015	30	male	36.5	35	completed	Z13.220	Encounter for screening for lipoid disorders
UTIL0016	normal	24.8	false	kg/m2	FAC002	Downtown Clinic	clinic	456 Clinic Ave	Chicago	IL	60611	USA	TO10016	LOINC:39156-5	Body Mass Index	vital	2023-02-20	2023-02-20	PHY016	Dr. Angela Brooks	PAT1016	27	female	12	11.5	completed	Z68.1	Body mass index (BMI) 19.9 or less, adult
UTIL0017	low	133000	false	/uL	FAC015	Pinecrest Clinic	clinic	222 Pinecrest Rd	Minneapolis	MN	55401	USA	TO10017	LOINC:4548-4	Platelet Count	hematology	2023-02-22	2023-02-23	PHY017	Dr. Eric Sanders	PAT1017	4	female	15	15	completed	D69.6	Thrombocytopenia, unspecified
UTIL0018	high	2.4	false	mg/dL	FAC016	Lakeside Laboratory	laboratory	333 Lake St	Madison	WI	53703	USA	TO10018	LOINC:1975-2	Creatinine	chemistry	2023-02-24	2023-02-25	PHY018	Dr. Heather Evans	PAT1018	65	male	22	18.3	completed	N18.3	Chronic kidney disease, stage 3 (moderate)
UTIL0019	normal	0	false	Negative	FAC017	Southside Medical	hospital	444 Southside Dr	Los Angeles	CA	90017	USA	TO10019	LOINC:94531-1	COVID-19 PCR	microbiology	2023-02-26	2023-02-28	PHY019	Dr. Ethan Price	PAT1019	53	female	62	55	completed	Z11.59	Encounter for screening for other viral diseases
UTIL0020	high	212.7	false	mg/dL	FAC018	CarePoint Laboratory	laboratory	555 CarePoint Ave	San Diego	CA	92101	USA	TO10020	LOINC:24323-8	Lipid Panel	chemistry	2023-03-01	2023-03-02	PHY020	Dr. Maria Torres	PAT1020	51	male	39	30.9	completed	E78.5	Hyperlipidemia, unspecified

What the 200 rows show

from the 200-row sample

Critical (test result flag) stands out: 5 of its 17 rows have test_duplicate_flag = true, against 0 of 183 for the rest.

3%test_duplicate_flag = true
28.8median test_result_value
2facility countries
3test utilization statuses
4test categories
4patient genders

Test duplicate flag rate by test_result_flagtest_duplicate_flag = true

test_result_value188 rows, in bands of 25k

Median 28.8, from 0.0 to 203,000.

test_result_unit188 rows with a value · 12 left blank

mg/dL60
kg/m225
/uL19
g/dL17
mmol/L15
CFU/mL10
Positive5
mg/L5
10^3/uL5
10^5 CFU/mL5

29 columns by typefrom the column list below

string 22
integer 1
float 3
date 2
boolean 1

Columns

29 columns in four groups

blueprint · 29 columns
column	type	description	example
Text 22 columns
`utilization_id`	string	Unique identifier for each lab test utilization recordunique	UTIL0001
`facility_id`	string	Unique identifier for the hospital or clinic where the lab test was ordered	FAC001
`facility_name`	string	Name of the hospital or clinic	General Hospital
`facility_type`	string	Type of healthcare facility (e.g., hospital, clinic, urgent care)hospital · clinic · urgent care · laboratory · other	hospital
`facility_street_address`	string	Street address of the facilityoptional	123 Main St
`facility_city`	string	City where the facility is locatedoptional	Boston
`facility_state`	string	State or region where the facility is locatedoptional	MA
`facility_postal_code`	string	Postal code of the facility locationoptional	02118
`facility_country`	string	Country where the facility is located2 countries · optional	USA
`test_order_id`	string	Unique identifier for the specific lab test order	TO10001
`test_code`	string	Standardized code for the lab test (e.g., LOINC, CPT)	LOINC:2345-7
`test_name`	string	Name of the lab test	Glucose, Serum
`test_category`	string	Category of the lab test (e.g., hematology, chemistry, microbiology)4 categories	chemistry
`ordering_physician_id`	string	Unique identifier for the physician who ordered the testoptional	PHY001
`ordering_physician_name`	string	Name of the physician who ordered the testoptional	Dr. Sarah Carter
`patient_id`	string	Unique identifier for the patient for whom the test was orderedoptional	PAT1001
`patient_gender`	string	Gender of the patientmale · female · other · unknown · optional	female
`test_result_unit`	string	Unit of measurement for the test result valueoptional	mg/dL
`test_result_flag`	string	Indicator for abnormal results (e.g., normal, high, low, critical)normal · high · low · critical · unknown · optional	normal
`test_utilization_status`	string	Status of test utilization (e.g., ordered, completed, cancelled, duplicate)ordered · completed · cancelled · duplicate · pending	completed
`diagnosis_code`	string	Primary diagnosis code associated with the test order (e.g., ICD-10)optional	E11.9
`diagnosis_description`	string	Description of the diagnosis associated with the test orderoptional	Anemia, unspecified
Numbers 4 columns
`patient_age`	integer	Age of the patient at the time of test order0 to 120 · optional	32
`test_result_value`	float	Numeric value of the lab test result (if applicable)optional	98.7
`test_cost`	float	Cost incurred for the lab test0 or more · optional	28.5
`test_reimbursed_amount`	float	Amount reimbursed for the lab test (if applicable)0 or more · optional	27.1
Dates and times 2 columns
`test_order_date`	date	Date the lab test was ordered	2023-01-15
`test_completed_date`	date	Date the lab test was completedoptional	2023-01-16
True or false 1 column
`test_duplicate_flag`	boolean	Indicates whether the test order is a duplicateoptional	false

Use it for

A healthcare dashboard
The test_duplicate_flag rate, test_result_value by test_result_flag and a breakdown of test_result_unit. Excel, Power BI or Tableau.
Why do 5 of 200 rows have test_duplicate_flag = true?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Utilizations200
UTIL000198.7normal
UTIL0047230.9critical
UTIL00501critical
A software demo
Believable utilizations with facility_id, facility_name and facility_type to fill a screen in front of a buyer.

This dataset200 rows29 columns

Yours1,000 rows29 columnsfacility_street_address: UK only

blueprint · healthcare-lab-test-utilization

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 29 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

Track test frequency per department
Segment by test type
Flag under-utilized tests
Include average turnaround time

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

Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: healthcare-lab-test-utilization

What should your data show?

No signup. No card.

Sample rows

What the 200 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?