Healthcare
20 columns
200 rows
8 formats

Healthcare Diagnostic Test Utilization

This dataset provides granular records of laboratory and imaging diagnostic test utilization across healthcare facilities, including test details, patient demographics, provider roles, costs, and result statuses. It enables comprehensive analysis of usage trends, resource allocation, and cost management, supporting data-driven decision-making for healthcare administrators and policy makers.

last updated 20 Aug 2025
by GoMask

The brief that made it

Optimizing diagnostic test resource allocation across facilities

Sample rows

preview · 8 of 200 rows · all 20 columns

test_utilization_idinteger	facility_typestring	test_costfloat	insurance_coveredboolean	test_categorystring	facility_idinteger	facility_namestring	test_idinteger	test_namestring	test_typestring	ordered_by_rolestring	order_datedate	performed_datedate	patient_ageinteger	patient_genderstring	test_result_statusstring	test_result_flaggedboolean	repeat_testboolean	utilization_reasonstring	departmentstring
1	hospital	32.5	true	hematology	101	Northeast Hospital	501	Complete Blood Count	laboratory	physician	2024-01-05	2024-01-06	34	female	completed	false	false	routine screening	internal medicine
2	clinic	15.75	true	urinalysis	102	Central Clinic	502	Urinalysis Panel	laboratory	physician	2024-01-10	2024-01-10	29	female	completed	false	false	screening	general practice
3	imaging_center	850	false	neurology	103	Metro Imaging Center	503	MRI Brain	imaging	physician_assistant	2024-02-03	2024-02-04	56	male	completed	true	false	diagnostic	neurology
4	laboratory	38.9	true	endocrinology	104	Southside Laboratory	504	Thyroid Panel	laboratory	physician	2024-01-21	2024-01-22	51	female	completed	true	true	diabetes monitoring	endocrinology
5	hospital	120	true	radiology	105	Westfield Hospital	505	X-Ray Chest	imaging	physician	2024-03-02	2024-03-02	67	male	completed	false	false	symptoms	cardiology
6	clinic	22.45	true	endocrinology	106	Oakwood Clinic	506	HbA1c Test	laboratory	nurse_practitioner	2024-01-19	2024-01-20	58	female	completed	false	true	diabetes monitoring	primary care
7	laboratory	2500	false	genetics	107	Evergreen Laboratory	507	Genetic Panel	laboratory	physician	2024-01-14	2024-01-21	46	female	completed	false	false	family history	genetics
8	imaging_center	600	false	gastroenterology	108	Riverbend Imaging Center	508	CT Abdomen	imaging	physician_assistant	2024-02-14	2024-02-15	65	female	completed	false	false	diagnostic	gastroenterology
9	hospital	36.9	true	cardiology	109	Hilltop Hospital	509	Lipid Profile	laboratory	physician	2024-01-23	2024-01-23	55	male	completed	true	true	follow-up	cardiology
10	laboratory	1100	false	oncology	110	Maple Laboratory	510	Oncology Marker Panel	laboratory	physician	2024-03-09	2024-03-19	74	female	completed	true	true	cancer staging	oncology
11	clinic	20	true	infectious disease	111	Summit Clinic	511	Strep Rapid Test	laboratory	nurse_practitioner	2024-02-24	2024-02-24	17	male	completed	false	false	symptoms	pediatrics
12	hospital	210	true	orthopedics	112	Valley Hospital	512	Bone Density Scan	imaging	physician	2024-01-07	2024-01-09	77	female	completed	false	false	diagnostic	orthopedics
13	laboratory	45.25	true	virology	113	Sunrise Laboratory	513	Virology Panel	laboratory	physician	2024-03-11	2024-03-12	41	female	completed	false	false	screening	internal medicine
14	clinic	18.6	true	gynecology	114	Lakeside Clinic	514	Pap Smear	laboratory	physician	2024-02-13	2024-02-13	28	female	completed	false	false	routine screening	gynecology
15	imaging_center	3499.99	false	oncology	115	Redwood Imaging Center	515	PET Scan	imaging	physician	2024-03-21	2024-03-28	70	male	completed	true	false	cancer staging	oncology
16	hospital	35	true	microbiology	101	Northeast Hospital	516	Microbiology Culture	laboratory	physician	2024-02-17	2024-02-18	15	male	completed	false	false	symptoms	emergency
17	laboratory	40.6	true	hematology	116	Prairie Laboratory	517	C-Reactive Protein	laboratory	physician	2024-03-14	2024-03-15	39	male	completed	true	true	follow-up	internal medicine
18	laboratory	1300	false	genetics	107	Evergreen Laboratory	518	Genetic Carrier Test	laboratory	other	2024-02-28	2024-03-07	49	female	completed	false	false	family history	genetics
19	clinic	27.9	true	endocrinology	117	Green Valley Clinic	519	Glucose Test	laboratory	physician_assistant	2024-02-10	2024-02-11	62	male	completed	false	true	diabetes monitoring	endocrinology
20	hospital	41	true	cardiology	118	Northside Hospital	520	Cardiac Enzyme Panel	laboratory	physician	2024-01-29	2024-01-29	80	female	completed	true	true	diagnostic	cardiology

What the 200 rows show

from the 200-row sample

Imaging_center (facility type) stands out: mean test_cost is 1,038, against 271.2 for the rest.

69%insurance_covered = true
41.0median test_cost
2test types
2test result statuses
4ordered by roles
4patient genders

Mean test_cost by facility_type200 rows

test_cost200 rows, in bands of 500

Median 41.0, from 13.5 to 3,500.

test_category198 rows with a value · 2 left blank

hematology30
endocrinology29
oncology19
orthopedics15
genetics13
infectious disease12
gastroenterology10
microbiology10
cardiology9
virology9

20 columns by typefrom the column list below

string 10
integer 4
float 1
date 2
boolean 3

Columns

20 columns in four groups

blueprint · 20 columns
column	type	description	example
Text 10 columns
`facility_name`	string	Name of the healthcare facility	Northeast Hospital
`facility_type`	string	Type of healthcare facility (e.g., hospital, clinic, lab)hospital · clinic · laboratory · imaging_center · other	hospital
`test_name`	string	Name of the diagnostic test (e.g., CBC, MRI, X-ray)	Complete Blood Count
`test_type`	string	Type of diagnostic test (laboratory or imaging)laboratory · imaging	laboratory
`test_category`	string	Category or specialization of the test (e.g., hematology, radiology)optional	hematology
`ordered_by_role`	string	Role of the healthcare provider who ordered the test (e.g., physician, nurse practitioner)4 values	physician
`patient_gender`	string	Gender of the patientmale · female · other · unknown · optional	female
`test_result_status`	string	Status of the test result (e.g., completed, pending, canceled)completed · pending · canceled · in_progress	completed
`utilization_reason`	string	Reason for ordering the test (e.g., routine screening, diagnostic, follow-up)12 reasons · optional	routine screening
`department`	string	Department or specialty requesting the test (e.g., cardiology, emergency)optional	internal medicine
Numbers 5 columns
`test_utilization_id`	integer	Unique identifier for each diagnostic test utilization recordunique · 1 or more	1
`facility_id`	integer	Unique identifier for the healthcare facility where the test was performed1 or more	101
`test_id`	integer	Unique identifier for the diagnostic test1 or more	501
`patient_age`	integer	Age of the patient at the time of the test0 to 120 · optional	34
`test_cost`	float	Cost incurred for the diagnostic test0 or more	32.5
Dates and times 2 columns
`order_date`	date	Date the diagnostic test was ordered	2024-01-05
`performed_date`	date	Date the diagnostic test was performedoptional	2024-01-06
True or false 3 columns
`insurance_covered`	boolean	Indicates if the test was covered by insuranceoptional	true
`test_result_flagged`	boolean	Indicates if the test result was flagged as abnormal or requiring follow-upoptional	false
`repeat_test`	boolean	Indicates if this test is a repeat of a previous test for the same patientoptional	false

Use it for

A healthcare dashboard
The insurance_covered rate, test_cost by facility_type and a breakdown of test_category. Excel, Power BI or Tableau.
Why do the 35 imaging_center rows have a mean test_cost of 1,038?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Rows200
132.5hospital
215.75clinic
3850imaging_…
A software demo
Believable rows with facility_id, facility_name and facility_type to fill a screen in front of a buyer.

This dataset200 rows20 columns

Yours1,000 rows20 columns

blueprint · healthcare-diagnostic-test-utilization

Behind this dataset

Same schema. As many rows as you need.

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

Log test type and result
Include patient age/gender
Track referral source
Aggregate monthly volumes
Flag repeat tests

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-diagnostic-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?