Healthcare
23 columns
200 rows
8 formats

Healthcare Provider Referral Analytics

This dataset provides a detailed view of healthcare provider referral events, capturing information about referring and receiving providers, patient demographics, referral reasons, statuses, and outcomes. It enables healthcare networks to analyze referral patterns, identify bottlenecks in patient navigation, and improve provider collaboration for better patient care.

last updated 20 Aug 2025
by GoMask

The brief that made it

Analyzing referral patterns and bottlenecks in healthcare networks

Sample rows

preview · 8 of 200 rows · all 23 columns

referral_idstring	referral_prioritystring	days_to_appointmentinteger	referring_provider_idstring	patient_idstring	referring_provider_namestring	referring_provider_specialtystring	referring_provider_organizationstring	receiving_provider_idstring	receiving_provider_namestring	receiving_provider_specialtystring	receiving_provider_organizationstring	referral_reasonstring	referral_datedate	appointment_scheduled_datedate	appointment_completed_datedate	referral_statusstring	referral_channelstring	patient_ageinteger	patient_genderstring	patient_zip_codestring	referral_outcomestring	referral_notesstring
REF-0001	routine	13	PROV-14	PAT-1023	Dr. Alice Morgan	Family Medicine	Sunrise Health Clinic	PROV-22	Dr. Henry Cole	Cardiology	Metropolitan Cardiac Center	Suspected arrhythmia evaluation	2023-10-02	2023-10-15	2023-10-15	completed	electronic	54	female	98121	accepted	Patient reports palpitations during exercise.
REF-0002	routine	9	PROV-03	PAT-2049	Dr. Brian Chen	Pediatrics	Children's Health Group	PROV-28	Dr. Emily Finch	Allergy & Immunology	Evergreen Allergy Clinic	Recurrent seasonal allergies	2023-09-18	2023-09-27	2023-09-27	completed	electronic	8	female	98103	accepted	Parent concerned about persistent sneezing.
REF-0003	stat	0	PROV-07	PAT-3056	Dr. Carla James	Geriatrics	Northlake Senior Care	PROV-33	Dr. John Oliver	Palliative Medicine	Northlake Senior Care	End-of-life pain management	2023-11-03	2023-11-03	2023-11-03	completed	phone	88	male	98144	accepted	Patient experiencing acute pain episode; family requests immediate consult.
REF-0004	routine	14	PROV-17	PAT-4128	Dr. Sophie Patel	Internal Medicine	Evergreen Medical Group	PROV-35	Dr. Mark Turner	Endocrinology	Evergreen Medical Group	Elevated fasting glucose levels	2023-08-10	2023-08-24	2023-08-24	completed	electronic	43	female	98005	accepted	Family history of diabetes mellitus.
REF-0005	urgent	9	PROV-12	PAT-5194	Dr. Linda Nguyen	Family Medicine	Eastside Community Clinic	PROV-41	Dr. Alex Foster	Sleep Medicine	Eastside Sleep Center	Obstructive sleep apnea suspicion	2023-12-01	2023-12-10	blank	scheduled	electronic	34	male	98027	accepted	Patient reports excessive daytime sleepiness.
REF-0006	stat	0	PROV-21	PAT-6243	Dr. Matthew Lee	General Surgery	Valley Surgical Associates	PROV-44	Dr. Rachel Kim	Orthopedics	Valley Surgical Associates	Suspected femur fracture after fall	2023-10-23	2023-10-23	2023-10-23	completed	fax	67	female	98199	accepted	Ambulance transport required; urgent intervention indicated.
REF-0007	urgent	7	PROV-09	PAT-7301	Dr. Erica Davis	OB/GYN	Harbor Women's Health	PROV-52	Dr. Olivia Grant	Maternal-Fetal Medicine	Harbor Women's Health	High-risk pregnancy consult	2023-11-11	2023-11-18	blank	scheduled	fax	27	female	98007	accepted	Elevated blood pressure noted during prenatal visit.
REF-0008	routine	14	PROV-02	PAT-8472	Dr. Kevin Black	Pediatrics	Children's Health Group	PROV-29	Dr. Priya Singh	Ophthalmology	Redmond Eye Center	Routine vision screening for school	2023-09-22	2023-10-06	2023-10-06	completed	electronic	6	male	98052	accepted	Teacher reports squinting in class.
REF-0009	routine	17	PROV-16	PAT-9586	Dr. Samuel Wright	Internal Medicine	Riverpoint Medical Center	PROV-37	Dr. Julia Lopez	Nephrology	Riverpoint Medical Center	Elevated creatinine levels in labs	2023-07-30	2023-08-16	2023-08-16	completed	electronic	61	male	98119	accepted	Recent diagnosis of hypertension.
REF-0010	urgent	10	PROV-20	PAT-0617	Dr. Karen Bailey	General Surgery	Cascade Surgical Partners	PROV-43	Dr. William Dean	Oncology	Cascade Cancer Center	Breast mass biopsy follow-up	2023-09-02	2023-09-12	2023-09-12	completed	fax	49	female	98033	accepted	Biopsy showed atypical cells; oncology assessment needed.
REF-0011	routine	13	PROV-15	PAT-1734	Dr. Nancy Brooks	Family Medicine	Sunrise Health Clinic	PROV-23	Dr. Steven Park	Dermatology	Dermatology Specialists	Persistent eczema unresponsive to topical therapy	2023-08-20	2023-09-02	blank	scheduled	electronic	42	female	98056	accepted	Patient reports chronic itching and redness.
REF-0012	routine	15	PROV-11	PAT-2840	Dr. Derek White	Psychiatry	Harborview Behavioral Health	PROV-36	Dr. Grace Lim	Sleep Medicine	Harborview Sleep Center	Insomnia secondary to anxiety disorder	2023-08-28	2023-09-12	2023-09-12	completed	electronic	31	other	98115	accepted	Patient unable to sleep for more than 3 hours per night.
REF-0013	stat	0	PROV-18	PAT-3952	Dr. Paul Reed	Emergency Medicine	blank	PROV-45	Dr. Sara Meyer	Orthopedics	Cascade Surgical Partners	Trauma: suspected wrist fracture after fall	2023-12-21	2023-12-21	2023-12-21	completed	phone	24	male	98112	accepted	Patient arrived by ambulance; acute pain, swelling noted.
REF-0014	routine	15	PROV-13	PAT-5028	Dr. Angela Wu	Family Medicine	Eastside Community Clinic	PROV-42	Dr. Michael Lee	Endocrinology	Eastside Diabetes Center	Thyroid nodule evaluation	2023-07-05	2023-07-20	2023-07-20	completed	electronic	38	female	98004	accepted	Patient reports new neck lump.
REF-0015	routine	14	PROV-06	PAT-6092	Dr. Vincent Moore	Pediatrics	Children's Health Group	PROV-25	Dr. Harpreet Anand	Allergy & Immunology	Evergreen Allergy Clinic	Food allergy assessment	2023-09-07	2023-09-21	blank	scheduled	electronic	5	male	98107	accepted	Parent reports hives after peanuts.
REF-0016	urgent	12	PROV-22	PAT-7135	Dr. Henry Cole	Family Medicine	Sunrise Health Clinic	PROV-24	Dr. Eva Thomas	Dermatology	Dermatology Specialists	Suspicious skin lesion evaluation	2023-10-18	2023-10-30	blank	scheduled	electronic	50	other	98034	accepted	Patient reports recent change in lesion color.
REF-0017	urgent	10	PROV-05	PAT-8246	Dr. Raymond Ellis	Geriatrics	Northlake Senior Care	PROV-32	Dr. Marta Rossi	Neurology	Northlake Senior Care	Memory loss and confusion episodes	2023-11-25	2023-12-05	2023-12-05	completed	fax	83	female	98072	accepted	Family concerned about early dementia.
REF-0018	urgent	4	PROV-19	PAT-9318	Dr. Peter Gold	Internal Medicine	Riverpoint Medical Center	PROV-38	Dr. Lillian Ford	Cardiology	Riverpoint Medical Center	Chest pain with exertion	2023-10-11	2023-10-15	blank	scheduled	electronic	63	male	98020	accepted	Exercise stress test recommended.
REF-0019	stat	0	PROV-10	PAT-0429	Dr. Carla James	Geriatrics	Northlake Senior Care	PROV-34	Dr. Suresh Krishnan	Palliative Medicine	Northlake Senior Care	Hospice care evaluation	2023-10-28	2023-10-28	2023-10-28	completed	phone	95	female	98118	accepted	Patient in declining health; comfort care requested.
REF-0020	routine	14	PROV-08	PAT-1576	Dr. Sharon Bell	Internal Medicine	Evergreen Medical Group	PROV-30	Dr. Alan Young	Nephrology	Evergreen Medical Group	New onset proteinuria	2023-09-04	2023-09-18	blank	scheduled	electronic	59	female	98059	accepted	Urine dipstick positive for protein.

What the 200 rows show

from the 200-row sample

Stat (referral priority) stands out: mean days_to_appointment is 0.0, against 10.5 for the rest.

10median days_to_appointment
2referral statuses
2referral outcomes
4referral channels
4patient genders
18referring provider specialties

Mean days_to_appointment by referral_priority200 rows

days_to_appointment200 rows, in bands of 5

Median 10, from 0 to 27.

referring_provider_id200 rows · top 10 of 37 values

PROV-2113
PROV-1913
PROV-1712
PROV-1510
PROV-1810
PROV-2310
PROV-149
PROV-119
PROV-138
PROV-228

23 columns by typefrom the column list below

string 18
integer 2
date 3

Columns

23 columns in three groups

blueprint · 23 columns
column	type	description	example
Text 18 columns
`referral_id`	string	Unique identifier for each patient referral eventunique	REF-0001
`patient_id`	string	Unique identifier for the patient being referred	PAT-1023
`referring_provider_id`	string	Unique identifier for the healthcare provider initiating the referral	PROV-14
`referring_provider_name`	string	Full name of the referring healthcare provider	Dr. Alice Morgan
`referring_provider_specialty`	string	Medical specialty of the referring provider	Family Medicine
`referring_provider_organization`	string	Organization or facility where the referring provider worksoptional	Sunrise Health Clinic
`receiving_provider_id`	string	Unique identifier for the healthcare provider receiving the referral	PROV-22
`receiving_provider_name`	string	Full name of the receiving healthcare provider	Dr. Henry Cole
`receiving_provider_specialty`	string	Medical specialty of the receiving provider	Cardiology
`receiving_provider_organization`	string	Organization or facility where the receiving provider worksoptional	Evergreen Allergy Clinic
`referral_reason`	string	Reason or diagnosis for the referral	Food allergy assessment
`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)pending · scheduled · completed · cancelled	completed
`referral_channel`	string	Method by which the referral was made (e.g., electronic, fax, phone, paper)electronic · fax · phone · paper · optional	electronic
`patient_gender`	string	Gender of the patientmale · female · other · unknown · optional	female
`patient_zip_code`	string	Postal code of the patient's primary residenceoptional	98121
`referral_notes`	string	Additional notes or comments related to the referraloptional	Evaluate for insulinoma.
`referral_outcome`	string	Outcome of the referral (e.g., accepted, declined, no-show, follow-up required)accepted · declined · no-show · follow-up required · other · optional	accepted
Numbers 2 columns
`patient_age`	integer	Age of the patient at the time of referral0 to 120 · optional	54
`days_to_appointment`	integer	Number of days between referral date and scheduled appointment date0 or more · optional	13
Dates and times 3 columns
`referral_date`	date	Date when the referral was initiated	2023-10-02
`appointment_scheduled_date`	date	Date when the appointment with the receiving provider is scheduledoptional	2023-10-15
`appointment_completed_date`	date	Date when the patient completed the appointment with the receiving provideroptional	2023-10-15

Healthcare Provider Referral Analytics

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.

What should your data show?

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?