Healthcare
27 columns
200 rows
8 formats

Healthcare Diagnostic Referral Patterns

This dataset provides detailed tracking of patient referrals from healthcare providers to diagnostic centers, including referral reasons, test types, scheduling, and outcomes. It enables analysis of referral patterns, provider-network efficiency, and patient care pathways, supporting operational improvements and quality initiatives in healthcare delivery.

last updated 20 Aug 2025
by GoMask

The brief that made it

Analyzing referral patterns to optimize provider and diagnostic center networks

Sample rows

preview · 8 of 200 rows · all 27 columns

referral_idstring	diagnostic_center_typestring	referring_provider_specialtystring	patient_idstring	patient_genderstring	patient_birth_datedate	referral_datedatetime	referring_provider_idstring	referring_provider_namestring	referring_provider_organizationstring	diagnostic_center_idstring	diagnostic_center_namestring	diagnostic_center_street_addressstring	diagnostic_center_citystring	diagnostic_center_statestring	diagnostic_center_postal_codestring	diagnostic_center_countrystring	diagnostic_test_typestring	diagnostic_test_codestring	diagnosis_codestring	diagnosis_descriptionstring	referral_reasonstring	referral_prioritystring	appointment_scheduled_datedatetime	appointment_completed_datedatetime	referral_statusstring	outcome_notesstring
REF001	laboratory	Pediatrics	PAT001	female	2012-04-17	2024-03-03T09:15:00	PROV0001	Dr. Linda Kaufman	Children's Clinic of San Francisco	DC001	Bay Area Laboratory	122 Market St	San Francisco	CA	94103	USA	Complete Blood Count	LOINC:718-7	D50.9	Iron deficiency anemia, unspecified	Fatigue and pallor, screening for anemia	routine	2024-03-09T08:45:00	2024-03-09T09:30:00	completed	CBC completed, mild anemia detected. Provider notified.
REF002	imaging	Cardiology	PAT002	male	1956-10-02	2024-02-14T14:10:00	PROV0002	Dr. Robert Chan	HeartCare Clinic	DC002	Westside Imaging Center	485 W 7th Ave	Los Angeles	CA	90017	USA	Echocardiogram	CPT:93306	I50.9	Heart failure, unspecified	Shortness of breath, possible CHF	urgent	2024-02-17T10:00:00	2024-02-17T10:40:00	completed	Echocardiogram shows reduced EF. Recommend follow-up.
REF003	laboratory	Endocrinology	PAT003	female	1986-07-21	2024-01-28T15:05:00	PROV0003	Dr. Naomi O'Brien	Union Square Medical Group	DC001	Bay Area Laboratory	122 Market St	San Francisco	CA	94103	USA	Thyroid Stimulating Hormone	LOINC:3016-3	E03.9	Hypothyroidism, unspecified	Fatigue, weight gain, abnormal TSH	routine	2024-02-02T09:00:00	2024-02-02T09:30:00	completed	TSH elevated, confirmed hypothyroidism.
REF004	laboratory	Pediatrics	PAT004	male	2019-12-08	2024-01-17T11:40:00	PROV0004	Dr. Emily Anozie	Lagos Children's Hospital	DC003	Eko Central Lab	33 Marina Rd	Lagos	LA	101001	Nigeria	Bilirubin Test	LOINC:1975-2	P59.9	Neonatal jaundice, unspecified	Jaundice, rule out liver dysfunction	stat	2024-01-17T12:20:00	2024-01-17T13:00:00	completed	Elevated direct bilirubin. Monitor closely.
REF005	pathology	Geriatrics	PAT005	female	1967-11-14	2024-04-02T08:00:00	PROV0005	Dr. Hannah Smith	Central Health Associates	DC004	Toronto Pathology Clinic	99 Elm St	Toronto	ON	M5G1G7	Canada	Liver Biopsy	CPT:47000	K76.9	Liver disease, unspecified	Abnormal LFTs, suspected liver pathology	urgent	2024-04-10T13:30:00	2024-04-10T15:00:00	completed	Biopsy revealed mild fibrosis, no malignancy.
REF006	laboratory	blank	PAT006	other	blank	2024-05-11T16:55:00	PROV0006	blank	blank	DC005	Canberra Diagnostics	blank	blank	blank	blank	Australia	Urinalysis	blank	blank	blank	blank	routine	blank	blank	pending	blank
REF007	laboratory	General Practice	PAT007	male	1997-09-30	2024-06-15T11:30:00	PROV0007	Dr. Isaac Stein	Fremont Health Group	DC001	Bay Area Laboratory	122 Market St	San Francisco	CA	94103	USA	Comprehensive Metabolic Panel	LOINC:24323-8	R79.89	Abnormal blood chemistry	Routine annual screening	routine	2024-06-21T09:00:00	2024-06-21T09:30:00	completed	CMP normal. No further action needed.
REF008	pathology	Oncology	PAT008	female	1978-08-19	2024-05-07T13:20:00	PROV0008	Dr. Farah Alhassan	Sydney Cancer Center	DC006	Sydney Pathology Group	200 Pitt St	Sydney	NSW	2000	Australia	Bone Marrow Biopsy	CPT:38221	C92.9	Leukemia, unspecified	Abnormal white count, rule out malignancy	urgent	2024-05-10T10:00:00	2024-05-10T11:15:00	completed	Biopsy confirmed diagnosis of leukemia.
REF009	laboratory	Pediatrics	PAT009	male	2015-05-11	2024-03-22T07:50:00	PROV0009	Dr. John O'Sullivan	Galway Children's Clinic	DC007	Galway Medical Lab	45 Eyre Square	Galway	GA	H91F5X9	Ireland	Lead Level Test	LOINC:5671-3	T56.0	Lead poisoning	Screening due to old housing	routine	2024-03-25T08:30:00	2024-03-25T09:00:00	completed	Lead levels within normal limits.
REF010	imaging	Pediatrics	PAT010	female	2009-11-30	2024-06-01T10:20:00	PROV0010	Dr. Stephanie Lee	Seattle Children's	DC008	Northwest Imaging	700 Virginia St	Seattle	WA	98101	USA	Abdominal Ultrasound	CPT:76700	R10.9	Abdominal pain, unspecified	Recurrent abdominal pain, rule out pathology	urgent	2024-06-05T14:00:00	2024-06-05T14:45:00	completed	Normal ultrasound. No abnormalities seen.
REF011	pathology	blank	PAT011	other	blank	2024-04-18T13:00:00	PROV0011	blank	blank	DC004	Toronto Pathology Clinic	99 Elm St	Toronto	ON	M5G1G7	Canada	Skin Lesion Biopsy	blank	blank	blank	blank	routine	blank	blank	pending	blank
REF012	laboratory	General Practice	PAT012	female	1992-03-14	2024-05-25T08:15:00	PROV0012	Dr. Sarah Akintola	Abuja Family Clinic	DC009	Abuja Central Laboratory	12 Gimbiya St	Abuja	FC	900001	Nigeria	Fasting Blood Glucose	LOINC:1558-6	R73.9	Hyperglycemia, unspecified	Screening for diabetes	routine	2024-05-30T09:00:00	blank	scheduled	blank
REF013	imaging	Neurology	PAT013	male	1981-04-09	2024-02-12T12:00:00	PROV0013	Dr. Marcus Li	San Mateo Neuro Center	DC008	Northwest Imaging	700 Virginia St	Seattle	WA	98101	USA	Brain MRI	CPT:70553	G40.9	Epilepsy, unspecified	Seizure episodes, rule out lesion	urgent	2024-02-18T13:00:00	2024-02-18T14:00:00	completed	MRI normal, no structural abnormalities.
REF014	pathology	Geriatrics	PAT014	female	1942-01-29	2024-04-29T09:00:00	PROV0014	Dr. Nathaniel Cohen	Silver Years Medical	DC004	Toronto Pathology Clinic	99 Elm St	Toronto	ON	M5G1G7	Canada	Renal Biopsy	CPT:50200	N18.9	Chronic kidney disease, unspecified	Abnormal renal function, possible nephropathy	urgent	2024-05-04T10:00:00	2024-05-04T11:00:00	completed	Biopsy confirmed diabetic nephropathy.
REF015	laboratory	blank	PAT015	unknown	blank	2024-05-10T12:10:00	PROV0015	blank	blank	DC005	Canberra Diagnostics	blank	blank	blank	blank	Australia	HIV Screening	blank	blank	blank	blank	routine	blank	blank	pending	blank
REF016	laboratory	General Practice	PAT016	male	2004-07-02	2024-03-11T09:50:00	PROV0016	Dr. Kevin McCarthy	Dublin Health Partnership	DC007	Galway Medical Lab	45 Eyre Square	Galway	GA	H91F5X9	Ireland	Lipid Panel	LOINC:24331-1	E78.5	Hyperlipidemia, unspecified	Elevated cholesterol, family history	routine	2024-03-20T10:20:00	2024-03-20T11:00:00	completed	LDL elevated, dietary advice provided.
REF017	laboratory	Pediatrics	PAT017	female	2017-05-24	2024-03-15T13:10:00	PROV0017	Dr. Judith Okafor	Abuja Children's Hospital	DC009	Abuja Central Laboratory	12 Gimbiya St	Abuja	FC	900001	Nigeria	Hemoglobin Electrophoresis	LOINC:32535-3	D57.0	Sickle cell anemia	Screening for sickle cell disease	routine	2024-03-20T08:45:00	2024-03-20T09:30:00	completed	Sickle cell trait detected. Counseling provided.
REF018	imaging	Cardiology	PAT018	male	1975-06-05	2024-04-17T10:30:00	PROV0018	Dr. Aaron Stewart	Melbourne Heart Clinic	DC010	Melbourne Imaging	250 Collins St	Melbourne	VIC	3000	Australia	Cardiac CT	CPT:75574	I25.10	Atherosclerotic heart disease	Chest pain, rule out CAD	urgent	2024-04-20T09:30:00	2024-04-20T10:00:00	completed	No significant coronary stenosis found.
REF019	pathology	Oncology	PAT019	female	1950-02-15	2024-01-20T09:45:00	PROV0019	Dr. Olivia Murphy	Vancouver Oncology Associates	DC011	Vancouver Pathology Center	855 W 12th Ave	Vancouver	BC	V5Z1M9	Canada	Breast Tissue Biopsy	CPT:19100	C50.9	Malignant neoplasm of breast, unspecified	Suspicious mammogram finding	urgent	2024-01-25T10:00:00	2024-01-25T10:45:00	completed	Biopsy confirmed malignancy.
REF020	laboratory	General Practice	PAT020	male	1989-12-22	2024-07-12T10:40:00	PROV0020	Dr. Michael Johnson	Chicago Primary Care	DC012	Windy City Laboratory	210 S Clark St	Chicago	IL	60603	USA	HbA1c Test	LOINC:4548-4	E11.9	Type 2 diabetes mellitus, unspecified	Diabetes management follow-up	routine	2024-07-18T09:00:00	2024-07-18T09:20:00	completed	HbA1c improved from prior. Continue regimen.

What the 200 rows show

from the 200-row sample

3referral priorities
3referral statuses
4patient genders
5diagnostic center countries
21diagnostic center states
25diagnostic center cities

diagnostic_center_type200 rows by value

referring_provider_specialty175 rows with a value · 25 left blank

General Practice43
Pediatrics34
Endocrinology27
Cardiology20
Geriatrics16
Neurology12
Oncology10
Neonatology5
Gynecology4
Hematology1

27 columns by typefrom the column list below

string 23
date 1
datetime 3

Columns

27 columns in two groups

blueprint · 27 columns
column	type	description	example
Text 23 columns
`referral_id`	string	Unique identifier for each referral recordunique	REF001
`patient_id`	string	Unique identifier for the patient being referred	PAT001
`patient_gender`	string	Gender of the patientmale · female · other · unknown · optional	female
`referring_provider_id`	string	Unique identifier for the provider making the referral	PROV0001
`referring_provider_name`	string	Name of the provider making the referraloptional	Dr. Linda Kaufman
`referring_provider_specialty`	string	Medical specialty of the referring provideroptional	Pediatrics
`referring_provider_organization`	string	Organization or practice of the referring provideroptional	HeartCare Clinic
`diagnostic_center_id`	string	Unique identifier for the diagnostic center receiving the referral	DC001
`diagnostic_center_name`	string	Name of the diagnostic centeroptional	Bay Area Laboratory
`diagnostic_center_type`	string	Type of diagnostic center (e.g., imaging, lab, pathology)imaging · laboratory · pathology · other · optional	laboratory
`diagnostic_center_street_address`	string	Street address of the diagnostic centeroptional	122 Market St
`diagnostic_center_city`	string	City where the diagnostic center is locatedoptional	San Francisco
`diagnostic_center_state`	string	State where the diagnostic center is locatedoptional	CA
`diagnostic_center_postal_code`	string	Postal code of the diagnostic centeroptional	94103
`diagnostic_center_country`	string	Country of the diagnostic center5 countries · optional	USA
`diagnostic_test_type`	string	Type of diagnostic test requested	Complete Blood Count
`diagnostic_test_code`	string	Standardized code for the diagnostic test (e.g., CPT, LOINC)optional	LOINC:718-7
`diagnosis_code`	string	Primary diagnosis code associated with the referral (e.g., ICD-10)optional	D50.9
`diagnosis_description`	string	Description of the diagnosisoptional	Abnormal blood chemistry
`referral_reason`	string	Reason for the referral as provided by the referring provideroptional	Routine annual screening
`referral_priority`	string	Priority level of the referralroutine · urgent · stat · optional	routine
`referral_status`	string	Current status of the referralpending · scheduled · completed · cancelled · no-show	completed
`outcome_notes`	string	Notes or summary of the outcome of the referral or diagnostic testoptional	Malaria smear negative.
Dates and times 4 columns
`patient_birth_date`	date	Birth date of the patientoptional	2012-04-17
`referral_date`	datetime	Date and time when the referral was made	2024-03-03T09:15:00
`appointment_scheduled_date`	datetime	Date and time when the appointment at the diagnostic center is scheduledoptional	2024-03-09T08:45:00
`appointment_completed_date`	datetime	Date and time when the diagnostic test was completedoptional	2024-03-09T09:30:00

Use it for

A healthcare dashboard
A breakdown of referring_provider_specialty. Excel, Power BI or Tableau.
What pattern can you find in 200 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
Referrals200
REF001laborato…
REF002imaging
REF003laborato…
A software demo
Believable referrals with patient_id, patient_gender and patient_birth_date to fill a screen in front of a buyer.

This dataset200 rows27 columns

Yours1,000 rows27 columnsdiagnostic_center_street_address: UK only

blueprint · healthcare-diagnostic-referral-patterns

Behind this dataset

Same schema. As many rows as you need.

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

Include provider and referral center IDs
Log referral reasons
Flag multiple referrals per patient
Aggregate by specialty
Integrate test turnaround times

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-referral-patterns

What should your data show?

No signup. No card.

Sample rows

What the 200 rows show

Columns

Use it for

A healthcare dashboard

A class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Healthcare

What should your data show?