Healthcare
23 columns
103 rows
8 formats

Provider Referrals and Care Coordination

This dataset provides comprehensive, structured information on provider referrals and care coordination, including referring and specialist provider details, patient information, referral reasons, authorization status, appointment scheduling, and closed-loop communication. It enables healthcare organizations to analyze referral patterns, optimize network utilization, and improve care continuity and outcomes.

last updated 2 Nov 2025
by GoMask

The brief that made it

Analyzing referral patterns and network utilization for healthcare organizations

Sample rows

preview · 8 of 103 rows · all 23 columns

referral_idstring	referral_statusstring	closed_loop_communicationboolean	specialist_provider_specialtystring	referral_datedatetime	referring_provider_idstring	referring_provider_namestring	referring_provider_specialtystring	specialist_provider_idstring	specialist_provider_namestring	patient_idstring	patient_namestring	patient_date_of_birthdate	referral_reasonstring	authorization_requiredboolean	authorization_statusstring	authorization_idstring	appointment_scheduledboolean	appointment_datedatetime	appointment_statusstring	communication_datedatetime	communication_notesstring	network_utilization_flagboolean
REF10001	in-progress	true	Cardiology	2024-03-21T09:15:00	PRV2001	Dr. Lisa Chan	Internal Medicine	SPV3001	Dr. Alan Brooks	PAT5001	John Morris	1968-05-23	Abnormal ECG, possible arrhythmia	true	approved	AUTH9001	true	2024-03-28T10:00:00	scheduled	2024-03-29T14:20:00	Specialist recommends Holter monitoring.	true
REF10002	open	false	Dermatology	2024-03-22T11:05:00	PRV2002	Dr. Michael Stewart	Family Medicine	SPV3002	Dr. Priya Desai	PAT5002	Emily Fox	1982-10-08	Suspicious mole on upper back	false	not required	blank	true	2024-04-02T15:00:00	scheduled	blank	blank	true
REF10003	open	false	Allergy & Immunology	2024-03-20T13:30:00	PRV2003	Dr. Sandra Lee	Pediatrics	SPV3003	Dr. Tom Sanders	PAT5003	Lucas Kim	2012-09-17	Chronic seasonal allergies, uncontrolled symptoms	true	pending	AUTH9002	false	blank	blank	blank	blank	true
REF10004	completed	true	Endocrinology	2024-03-18T08:40:00	PRV2004	Dr. Henry Wu	Internal Medicine	SPV3004	Dr. Maria Torres	PAT5004	Jeanette Alvarez	1955-12-02	Uncontrolled diabetes mellitus type 2	true	approved	AUTH9003	true	2024-03-25T11:30:00	completed	2024-03-26T09:15:00	Medication regimen adjusted; follow-up in 3 months.	true
REF10005	in-progress	false	Orthopedics	2024-03-19T14:50:00	PRV2005	Dr. Ahmed El-Sharif	Family Medicine	SPV3005	Dr. Olivia King	PAT5005	Robert Young	1978-04-16	Knee pain, possible meniscal tear	false	not required	blank	true	2024-03-27T13:00:00	scheduled	blank	blank	false
REF10006	completed	true	Pulmonology	2024-03-17T10:20:00	PRV2001	Dr. Lisa Chan	Internal Medicine	SPV3006	Dr. David Lin	PAT5006	Barbara Holt	1959-01-31	Chronic cough and dyspnea	true	approved	AUTH9004	true	2024-03-24T15:45:00	completed	2024-03-25T16:10:00	COPD confirmed; inhaler prescribed.	false
REF10007	open	false	Gastroenterology	2024-03-23T12:30:00	PRV2002	Dr. Michael Stewart	Family Medicine	SPV3007	Dr. Emily Green	PAT5007	Jessica Lee	1991-07-19	Persistent abdominal pain	false	not required	blank	false	blank	blank	blank	blank	true
REF10008	completed	true	Ophthalmology	2024-03-20T16:15:00	PRV2006	Dr. Raj Patel	Pediatrics	SPV3008	Dr. Hannah Nguyen	PAT5008	Sophie Turner	2016-11-28	Vision screening failure at school	false	not required	blank	true	2024-03-30T09:30:00	scheduled	2024-03-31T11:00:00	Prescription for corrective lenses.	true
REF10009	in-progress	false	Neurology	2024-03-18T13:10:00	PRV2007	Dr. Steven Hall	Family Medicine	SPV3009	Dr. Rachel Kim	PAT5009	William Chen	1986-02-24	Migraine headaches, increased frequency	true	approved	AUTH9005	true	2024-03-26T14:30:00	scheduled	blank	blank	false
REF10010	open	false	Reproductive Endocrinology	2024-03-19T09:45:00	PRV2008	Dr. Grace Lin	Obstetrics & Gynecology	SPV3010	Dr. Mark Evans	PAT5010	Ashley Reed	1993-05-21	Infertility evaluation	true	pending	AUTH9006	false	blank	blank	blank	blank	true
REF10011	open	false	Nephrology	2024-03-22T16:00:00	PRV2009	Dr. Peter O'Brien	Internal Medicine	SPV3011	Dr. Fatima Hassan	PAT5011	George Miller	1952-09-12	Elevated creatinine, possible CKD	false	not required	blank	true	2024-03-29T10:30:00	scheduled	blank	blank	true
REF10012	in-progress	false	Hematology	2024-03-21T11:25:00	PRV2010	Dr. Teresa Choi	Family Medicine	SPV3012	Dr. Simon West	PAT5012	Megan Price	1973-03-14	Iron deficiency anemia, unclear etiology	true	approved	AUTH9007	true	2024-03-28T15:00:00	scheduled	blank	blank	true
REF10013	completed	true	Ophthalmology	2024-03-18T15:10:00	PRV2004	Dr. Henry Wu	Internal Medicine	SPV3008	Dr. Hannah Nguyen	PAT5013	Henry Porter	1943-08-30	Sudden vision loss in right eye	true	approved	AUTH9008	true	2024-03-19T13:15:00	completed	2024-03-20T09:25:00	Retinal detachment; emergency surgery performed.	true
REF10014	completed	true	Psychiatry	2024-03-17T16:50:00	PRV2007	Dr. Steven Hall	Family Medicine	SPV3013	Dr. Chloe Bennett	PAT5014	Daniel Watts	1989-07-07	Major depressive disorder, medication review	false	not required	blank	true	2024-03-23T10:30:00	scheduled	2024-03-24T12:00:00	Therapy initiated, SSRI adjusted.	true
REF10015	open	false	Rheumatology	2024-03-22T12:45:00	PRV2011	Dr. Vincent Tran	Family Medicine	SPV3014	Dr. Sarah Wood	PAT5015	Linda Park	1970-06-11	Joint pain, possible rheumatoid arthritis	true	pending	AUTH9009	false	blank	blank	blank	blank	true
REF10016	completed	true	Ear, Nose, Throat	2024-03-16T09:30:00	PRV2012	Dr. Ethan Gold	Pediatrics	SPV3015	Dr. Megan O'Connor	PAT5016	Amelia Johnson	2015-02-10	Recurrent ear infections	false	not required	blank	true	2024-03-19T11:00:00	completed	2024-03-20T08:45:00	Tympanostomy tubes recommended.	false
REF10017	open	false	General Surgery	2024-03-20T15:00:00	PRV2013	Dr. Julia Moore	Family Medicine	SPV3016	Dr. Isaac Ford	PAT5017	Paul Schneider	1950-11-03	Right inguinal hernia	true	approved	AUTH9010	true	2024-03-27T08:30:00	scheduled	blank	blank	true
REF10018	open	false	Urology	2024-03-23T10:15:00	PRV2014	Dr. Angela White	Obstetrics & Gynecology	SPV3017	Dr. Brian Scott	PAT5018	Nancy Watts	1960-08-14	Urinary incontinence, evaluation needed	false	not required	blank	false	blank	blank	blank	blank	false
REF10019	completed	true	Pediatric Cardiology	2024-03-19T15:20:00	PRV2003	Dr. Sandra Lee	Pediatrics	SPV3018	Dr. Kevin Stein	PAT5019	Oliver Rivera	2014-04-21	Heart murmur detected on exam	true	approved	AUTH9011	true	2024-03-26T13:00:00	scheduled	2024-03-27T09:00:00	Echocardiogram normal; murmur benign.	true
REF10020	open	false	Oncology	2024-03-21T14:05:00	PRV2015	Dr. Samantha Green	Family Medicine	SPV3019	Dr. Eric Chang	PAT5020	Jessica Fox	1987-01-04	Abnormal breast mass on mammogram	true	pending	AUTH9012	false	blank	blank	blank	blank	true

What the 103 rows show

from the 103-row sample

Completed (referral status) stands out: 28 of its 28 rows have closed_loop_communication = true, against 9 of 75 for the rest.

36%closed_loop_communication = true
2appointment statuses
3authorization statuses
4referring provider specialties

Closed loop communication rate by referral_statusclosed_loop_communication = true

specialist_provider_specialty103 rows · top 10 of 23 values

Dermatology14
Gastroenterology13
Allergy & Immunology11
Otolaryngology7
Ophthalmology6
Cardiology5
Pulmonology5
Urology5
Endocrinology4
Orthopedics4

23 columns by typefrom the column list below

string 15
date 1
datetime 3
boolean 4

Columns

23 columns in three groups

blueprint · 23 columns
column	type	description	example
Text 15 columns
`referral_id`	string	Unique identifier for each referral recordunique	REF10001
`referring_provider_id`	string	Unique identifier for the provider initiating the referral	PRV2001
`referring_provider_name`	string	Full name of the provider initiating the referral	Dr. Lisa Chan
`referring_provider_specialty`	string	Medical specialty of the referring provider4 specialties · optional	Internal Medicine
`specialist_provider_id`	string	Unique identifier for the specialist provider receiving the referral	SPV3001
`specialist_provider_name`	string	Full name of the specialist provider	Dr. Alan Brooks
`specialist_provider_specialty`	string	Medical specialty of the specialist provideroptional	Cardiology
`patient_id`	string	Unique identifier for the patient being referred	PAT5001
`patient_name`	string	Full name of the patient	John Morris
`referral_reason`	string	Detailed reason for the referral	Infertility evaluation
`authorization_status`	string	Status of the authorization (e.g., pending, approved, denied, not required)pending · approved · denied · not required · optional	approved
`authorization_id`	string	Unique identifier for the authorization, if applicableoptional	AUTH9001
`appointment_status`	string	Current status of the appointment (e.g., scheduled, completed, cancelled, no-show)scheduled · completed · cancelled · no-show · optional	scheduled
`communication_notes`	string	Notes or summary of the closed-loop communicationoptional	Genetic testing ordered.
`referral_status`	string	Overall status of the referral (e.g., open, in-progress, completed, cancelled)open · in-progress · completed · cancelled	in-progress
Dates and times 4 columns
`referral_date`	datetime	Date and time when the referral was initiated	2024-03-21T09:15:00
`patient_date_of_birth`	date	Date of birth of the patientoptional	1968-05-23
`appointment_date`	datetime	Date and time of the scheduled appointmentoptional	2024-03-28T10:00:00
`communication_date`	datetime	Date and time when closed-loop communication occurredoptional	2024-03-29T14:20:00
True or false 4 columns
`authorization_required`	boolean	Indicates if pre-authorization is required for the referral	true
`appointment_scheduled`	boolean	Indicates if an appointment has been scheduled with the specialist	true
`closed_loop_communication`	boolean	Indicates if feedback or follow-up was communicated back to the referring provider	true
`network_utilization_flag`	boolean	Indicates if the referral was made within the provider network	true

Use it for

A healthcare dashboard
The closed_loop_communication rate, closed_loop_communication by referral_status and a breakdown of specialist_provider_specialty. Excel, Power BI or Tableau.
Why do 37 of 103 rows have closed_loop_communication = true?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Referrals103
REF10001in-progr…
REF10002open
REF10004completed
A software demo
Believable referrals with referral_date, referring_provider_id and referring_provider_name to fill a screen in front of a buyer.

This dataset103 rows23 columns

Yours1,000 rows23 columns

blueprint · provider-referrals-and-care-coordination

Behind this dataset

Same schema. As many rows as you need.

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

Referral ID unique per referral
Referring provider NPI (usually PCP)
Specialist provider NPI and specialty
Patient demographics and insurance
Referral reason and ICD-10 code
Urgency: routine, urgent, stat
Authorization required indicator
Authorization number if obtained

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

Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: provider-referrals-and-care-coordination

What should your data show?

No signup. No card.

Sample rows

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