Healthcare
22 columns
200 rows
8 formats

Healthcare Patient Referral Flows

This dataset provides a comprehensive view of healthcare patient referral flows, capturing detailed information on cross-provider referral patterns, delays, outcomes, and leakage events. It enables healthcare organizations to analyze care coordination, identify bottlenecks, and optimize referral processes to improve patient outcomes and reduce network leakage.

last updated 22 Jul 2025
by GoMask

The brief that made it

Analyzing referral patterns to optimize provider networks

Sample rows

preview · 8 of 200 rows · all 22 columns

referral_idstring	referring_provider_typestring	patient_ageinteger	referral_leakageboolean	referred_provider_typestring	patient_idstring	referral_datedate	referring_provider_idstring	referring_provider_namestring	referring_provider_organization_idstring	referred_provider_idstring	referred_provider_namestring	referred_provider_organization_idstring	referral_prioritystring	appointment_scheduled_datedate	appointment_completed_datedate	referral_statusstring	referral_delay_daysinteger	patient_genderstring	patient_zip_codestring	referral_reasonstring	referral_outcomestring
REF00001	PCP	58	false	Cardiologist	PAT001	2024-02-12	PROV1001	Dr. Amy Rogers	ORG1001	PROV2001	Dr. Brian Chen	ORG2001	routine	2024-02-20	2024-03-05	completed	22	male	10011	Abnormal EKG, evaluation for arrhythmia	Cardiac evaluation completed; follow-up required
REF00002	Pediatrician	7	false	Pediatric Allergist	PAT002	2024-03-01	PROV1002	Dr. Susan Patel	ORG1002	PROV2002	Dr. Lena Fox	ORG2002	urgent	2024-03-03	2024-03-06	completed	5	female	60614	Suspected peanut allergy, needs testing	Allergy confirmed, treatment plan initiated
REF00003	PCP	43	false	Dermatologist	PAT003	2024-01-24	PROV1003	Dr. Michael Smith	ORG1003	PROV2003	Dr. Priya Nanda	ORG2003	routine	2024-01-31	2024-02-15	completed	22	female	94110	Chronic eczema, evaluation for new treatment	Treatment plan updated, follow-up in 3 months
REF00004	PCP	49	false	Endocrinologist	PAT004	2024-03-12	PROV1004	Dr. Laura Green	ORG1004	PROV2004	Dr. Omar Karim	ORG2004	urgent	2024-03-15	2024-03-19	completed	7	male	75201	New diagnosis of diabetes, needs specialist management	Initial diabetes assessment completed
REF00005	PCP	26	false	Psychiatrist	PAT005	2024-01-11	PROV1005	Dr. Martin Ellis	ORG1005	PROV2005	Dr. Elsa Rivera	ORG2005	urgent	2024-01-14	blank	no-show	blank	female	30309	Depressive symptoms not improving, evaluation needed	Patient missed appointment
REF00006	PCP	39	false	Physical Therapist	PAT006	2024-02-17	PROV1006	Dr. Tyler Brooks	ORG1006	PROV2006	Dr. Ana Salazar	ORG2006	routine	blank	blank	pending	blank	male	80205	Chronic back pain, needs physical therapy evaluation	blank
REF00007	Geriatrician	81	false	Oncologist	PAT007	2024-03-14	PROV1007	Dr. Isabel Lee	ORG1007	PROV2007	Dr. Charles Wright	ORG2007	stat	2024-03-14	2024-03-15	completed	1	female	44106	Lump found on exam, needs urgent oncology consult	Oncology consult performed; biopsy scheduled
REF00008	PCP	68	false	Nephrologist	PAT008	2024-01-19	PROV1008	Dr. Henry Zhou	ORG1008	PROV2008	Dr. Vera Sokolov	ORG2008	urgent	2024-01-23	2024-01-27	completed	8	male	63108	Elevated creatinine, possible renal disease	Nephrology labs ordered, follow-up in 2 weeks
REF00009	PCP	52	false	Pulmonologist	PAT009	2024-03-08	PROV1009	Dr. Emily Stone	ORG1009	PROV2009	Dr. Danilo Russo	ORG2009	routine	2024-03-17	blank	scheduled	blank	female	19103	Chronic cough, needs pulmonary evaluation	blank
REF00010	PCP	47	false	Dermatologist	PAT010	2024-01-30	PROV1010	Dr. Jose Martinez	blank	PROV2010	Dr. Claire Lin	ORG2010	urgent	2024-02-03	2024-02-07	completed	8	male	02139	Evaluation for new skin lesion	Lesion benign, no treatment needed
REF00011	blank	34	false	Orthopedist	PAT011	2024-02-21	PROV1011	Dr. Rachel Ahmed	ORG1011	PROV2011	Dr. Steve Gordon	ORG2011	routine	2024-02-28	2024-03-06	completed	14	female	98103	Knee pain after injury, needs ortho assessment	Physical therapy recommended
REF00012	PCP	50	false	Gastroenterologist	PAT012	2024-03-04	PROV1012	Dr. Julian Moss	ORG1012	PROV2012	Dr. Grace Evans	ORG2012	routine	2024-03-12	blank	scheduled	blank	other	55416	Chronic abdominal pain, needs evaluation	blank
REF00013	Pediatrician	10	false	Pediatric Neurologist	PAT013	2024-02-15	PROV1013	Dr. Nia Young	ORG1013	PROV2013	Dr. Owen Grant	ORG2013	stat	2024-02-15	2024-02-16	completed	1	male	20009	Recurrent seizures, needs specialist evaluation	EEG ordered; return visit in 2 weeks
REF00014	PCP	66	false	Urologist	PAT014	2024-03-10	PROV1014	Dr. Wendy Lee	ORG1014	PROV2014	Dr. John Walters	ORG2014	routine	2024-03-18	blank	scheduled	blank	male	48326	Elevated PSA, needs prostate evaluation	blank
REF00015	PCP	72	false	Physical Therapist	PAT015	2024-02-08	PROV1015	Dr. Tamara Ruiz	ORG1015	PROV2015	Dr. Dave Williams	ORG2015	routine	2024-02-15	2024-02-28	completed	20	female	68114	Post-knee replacement rehab required	Therapy started, goals set for mobility
REF00016	PCP	29	false	Neurologist	PAT016	2024-02-25	PROV1016	Dr. Mark Bailey	ORG1016	PROV2016	Dr. Linh Tran	ORG2016	urgent	2024-02-28	2024-03-04	completed	8	female	30318	Frequent headaches, needs neuro evaluation	MRI ordered, follow-up in a week
REF00017	PCP	62	false	Nephrologist	PAT017	2024-01-15	PROV1017	blank	ORG1017	PROV2017	Dr. George Patel	ORG2017	routine	2024-01-26	blank	scheduled	blank	male	78701	Stage 3 CKD, needs ongoing specialist care	blank
REF00018	PCP	41	false	Pulmonologist	PAT018	2024-03-03	PROV1018	Dr. Priya Kaur	ORG1018	PROV2018	Dr. Anthony Clark	ORG2018	routine	2024-03-14	2024-03-28	completed	25	male	55401	Sleep apnea, needs further evaluation	Sleep study performed, CPAP started
REF00019	Pediatrician	13	false	Pediatric Orthopedist	PAT019	2024-02-22	PROV1019	Dr. Talia Singh	ORG1019	PROV2019	Dr. Oliver Adams	ORG2019	urgent	2024-02-24	2024-02-28	completed	6	female	19146	Scoliosis screening, abnormal results	Bracing recommended, follow-up in 6 months
REF00020	PCP	67	false	Cardiologist	PAT020	2024-01-28	PROV1020	Dr. Jason Wu	ORG1020	PROV2020	Dr. Mia Novak	blank	urgent	2024-01-29	2024-02-02	completed	5	male	60622	Shortness of breath, concern for CHF	CHF ruled out, no intervention needed

What the 200 rows show

from the 200-row sample

Pediatrician (referring provider type) stands out: mean patient_age is 10.1, against 52.4 for the rest.

2%referral_leakage = true
51.5median patient_age
3referral priorities
4patient genders
5referral statuses
8median referral_delay_days

Mean patient_age by referring_provider_type196 rows

patient_age200 rows, in bands of 10

Median 51.5, from 4 to 89.

referred_provider_type200 rows · top 10 of 22 values

Cardiologist26
Dermatologist26
Physical Therapist15
Oncologist15
Endocrinologist13
Psychiatrist13
Nephrologist13
Neurologist12
Pulmonologist11
Gastroenterologist11

22 columns by typefrom the column list below

string 16
integer 2
date 3
boolean 1

Columns

22 columns in four groups

blueprint · 22 columns
column	type	description	example
Text 16 columns
`referral_id`	string	Unique identifier for each referral eventunique	REF00001
`patient_id`	string	Unique identifier for the patient being referred	PAT001
`referring_provider_id`	string	Unique identifier for the provider making the referral	PROV1001
`referring_provider_name`	string	Name of the provider making the referraloptional	Dr. Amy Rogers
`referring_provider_type`	string	Type or specialty of the referring provider (e.g., PCP, Cardiologist)3 types · optional	PCP
`referring_provider_organization_id`	string	Unique identifier for the referring provider's organizationoptional	ORG1001
`referred_provider_id`	string	Unique identifier for the provider receiving the referral	PROV2001
`referred_provider_name`	string	Name of the provider receiving the referraloptional	Dr. Brian Chen
`referred_provider_type`	string	Type or specialty of the referred provider (e.g., Specialist, Surgeon)optional	Cardiologist
`referred_provider_organization_id`	string	Unique identifier for the referred provider's organizationoptional	ORG2001
`referral_reason`	string	Reason for the referral (e.g., diagnosis, procedure, consultation)optional	New onset of psoriasis.
`referral_priority`	string	Priority level of the referral (e.g., routine, urgent, stat)routine · urgent · stat · optional	routine
`referral_status`	string	Current status of the referral (e.g., pending, scheduled, completed, cancelled, no-show, leaked)6 values	completed
`referral_outcome`	string	Outcome of the referral (e.g., treatment started, follow-up required, not attended, patient declined)optional	Renal biopsy scheduled
`patient_gender`	string	Gender of the patientmale · female · other · unknown · optional	male
`patient_zip_code`	string	Postal code of the patient's residenceoptional	10011
Numbers 2 columns
`referral_delay_days`	integer	Number of days between referral initiation and appointment completion0 or more · optional	22
`patient_age`	integer	Age of the patient at the time of referral0 or more · optional	58
Dates and times 3 columns
`referral_date`	date	Date the referral was initiated	2024-02-12
`appointment_scheduled_date`	date	Date the appointment with the referred provider was scheduledoptional	2024-02-20
`appointment_completed_date`	date	Date the patient completed the appointment with the referred provideroptional	2024-03-05
True or false 1 column
`referral_leakage`	boolean	Indicates if the referral resulted in patient leakage (i.e., patient went outside the network)	false

Use it for

A healthcare dashboard
The referral_leakage rate, patient_age by referring_provider_type and a breakdown of referred_provider_type. Excel, Power BI or Tableau.
Why do the 17 Pediatrician rows have a mean patient_age of 10.1?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Referrals200
REF0000158PCP
REF0003771PCP
REF0010673PCP
A software demo
Believable referrals with patient_id, referral_date and referring_provider_id to fill a screen in front of a buyer.

This dataset200 rows22 columns

Yours1,000 rows22 columnspatient_zip_code: UK only

blueprint · healthcare-patient-referral-flows

Behind this dataset

Same schema. As many rows as you need.

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

Each referral includes patient, source, and target provider.
Time-to-appointment and outcome tracked.
Specialty and insurance compatibility provided.
Referral reasons and feedback notes present.

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-patient-referral-flows

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?