Doctor Referral Network Connections
This dataset details provider-to-provider referral connections within healthcare networks, including provider identifiers, specialties, referral reasons, dates, and statuses. It enables comprehensive analysis of referral patterns, network efficiency, and patient flow optimization, supporting both operational improvements and research into care coordination.
Sample rows
preview · 8 of 200 rows · all 22 columns| referral_idstring | referral_prioritystring | referring_provider_specialtystring | referring_provider_idstring | referring_provider_npistring | referring_provider_namestring | referring_provider_organizationstring | referring_provider_citystring | referring_provider_statestring | referred_provider_idstring | referred_provider_npistring | referred_provider_namestring | referred_provider_specialtystring | referred_provider_organizationstring | referred_provider_citystring | referred_provider_statestring | referral_datedate | referral_reasonstring | patient_idstring | referral_statusstring | referral_notesstring | network_idstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REF0001 | routine | Family Medicine | PROV1001 | 1678953021 | Dr. Alice Nguyen | Houston Medical Group | Houston | TX | PROV2001 | 1338509245 | Dr. John Carter | Cardiology | Houston Heart Center | Houston | TX | 2023-08-12 | Chest pain evaluation | PAT1A23BC | completed | Routine referral for evaluation of chest pain. | NWK001 |
| REF0002 | routine | Pediatrics | PROV1002 | 1908623471 | Dr. Vivian Zhou | San Jose Pediatric Clinic | San Jose | CA | PROV2002 | 1114589321 | Dr. Steven Patel | Dermatology | Mountain View Skin Center | Mountain View | CA | 2022-11-03 | Chronic eczema management | PAT4B9DFG | completed | blank | NWK002 |
| REF0003 | stat | Emergency Medicine | PROV1003 | blank | Dr. Taylor Evans | Minneapolis General Hospital | Minneapolis | MN | PROV2003 | 0000000000 | Dr. Paula Lee | Orthopedics | St. Paul Bone & Joint | St. Paul | MN | 2024-02-19 | Fracture management | PAT8C1JQZ | in-progress | Patient needs urgent surgical assessment. | NWK003 |
| REF0004 | routine | Geriatrics | PROV1004 | 1447583922 | Dr. Rashid Ahmed | Seattle Senior Care | Seattle | WA | PROV2004 | 1764589371 | Dr. Julia McNeil | Rheumatology | Bellevue Arthritis Clinic | Bellevue | WA | 2023-10-07 | Chronic joint pain | PAT9Q3F1L | completed | Elderly patient with progressive pain. | NWK004 |
| REF0005 | stat | blank | PROV1005 | 1295837162 | blank | blank | Unknown City | ZZ | PROV2005 | blank | blank | blank | blank | blank | blank | 1900-01-01 | blank | blank | cancelled | Referral cancelled due to provider unavailability. | NWK999 |
| REF0006 | routine | Internal Medicine | PROV1006 | 1864592083 | Dr. Maria Sosa | Austin Health Associates | Austin | TX | PROV2006 | 1448592309 | Dr. Samuel Lee | Endocrinology | Austin Endocrine Clinic | Austin | TX | 2023-09-27 | Diabetes management | PAT2V6H9W | completed | blank | NWK001 |
| REF0007 | urgent | Family Medicine | PROV1007 | 1983745622 | Dr. Peter White | Phoenix Family Practice | Phoenix | AZ | PROV2007 | 1558432971 | Dr. Helen Kim | Nephrology | Desert Kidney Specialists | Phoenix | AZ | 2023-12-15 | Elevated creatinine | PAT3G4K2N | pending | Possible acute kidney injury. | NWK005 |
| REF0008 | urgent | Obstetrics & Gynecology | PROV1008 | blank | Dr. Lila Chang | Chicago Women's Health | Chicago | IL | PROV2008 | 1103928457 | Dr. Monica Greene | Oncology | Chicago Cancer Center | Chicago | IL | 2023-03-22 | Suspicious pelvic mass | blank | pending | blank | NWK006 |
| REF0009 | routine | Internal Medicine | PROV1009 | 1435678920 | Dr. George Patel | Orlando Health | Orlando | FL | PROV2009 | 1329584756 | Dr. Priya Singh | Gastroenterology | Orlando Digestive Center | Orlando | FL | 2022-12-04 | Chronic abdominal pain | PAT5U8T4O | completed | Follow-up for persistent GI symptoms. | NWK007 |
| REF0010 | urgent | Family Medicine | PROV1010 | 1594826317 | Dr. Emma Lin | New York City Health | New York | NY | PROV2010 | 1745623980 | Dr. Boris Kogan | Neurology | NYC Brain Institute | New York | NY | 2024-05-04 | Seizure evaluation | PAT0F2R6S | pending | Recent episode, needs EEG. | NWK008 |
| REF0011 | routine | Pediatrics | PROV1011 | 1783625941 | Dr. Lauren Black | Children's Health Dallas | Dallas | TX | PROV2011 | 1672389051 | Dr. Irene Gold | Speech Pathology | Dallas Language Center | Dallas | TX | 2022-09-14 | Speech delay assessment | blank | completed | blank | NWK001 |
| REF0012 | stat | Family Medicine | PROV1012 | blank | Dr. Oscar Villa | Miami Medical Center | Miami | FL | PROV2012 | 1582039471 | Dr. Susan Graham | Cardiology | Miami Cardiac Group | Miami | FL | 2024-01-09 | Syncope episodes | PAT7C8L9M | pending | Recent syncopal event in office. | NWK007 |
| REF0013 | urgent | Internal Medicine | PROV1013 | 1457892301 | Dr. Hannah Ellis | Boston Primary Care | Boston | MA | PROV2013 | 1682394051 | Dr. Michael Brown | Pulmonology | Boston Lung Center | Boston | MA | 2023-06-23 | Shortness of breath | PAT4K9T2M | completed | Suspect asthma exacerbation. | NWK009 |
| REF0014 | routine | Family Medicine | PROV1014 | 1329487530 | Dr. Aaron Martinez | Denver Health Partners | Denver | CO | PROV2014 | 1764892301 | Dr. Olivia Smith | Ophthalmology | Denver Eye Center | Denver | CO | 2023-05-19 | Vision changes | blank | completed | blank | NWK010 |
| REF0015 | urgent | Pediatrics | PROV1015 | 1703948621 | Dr. Sophia Lee | San Diego Children's Health | San Diego | CA | PROV2015 | 1884902357 | Dr. Kevin Torres | Allergy & Immunology | San Diego Allergy Center | San Diego | CA | 2023-02-13 | Severe atopic dermatitis | PAT6Z1P3V | completed | Frequent flares, needs specialist. | NWK002 |
| REF0016 | stat | blank | PROV1016 | 1845932019 | blank | blank | blank | blank | PROV2016 | blank | blank | blank | blank | blank | blank | 2100-12-31 | blank | blank | cancelled | Referral voided as future-dated. | blank |
| REF0017 | routine | Family Medicine | PROV1017 | 1273896504 | Dr. Ethan Li | Portland Community Health | Portland | OR | PROV2017 | 1930485732 | Dr. Sheila Grant | Endocrinology | Oregon Endocrine Group | Portland | OR | 2023-01-24 | Uncontrolled diabetes | PAT1A9M4F | completed | blank | NWK011 |
| REF0018 | urgent | Internal Medicine | PROV1018 | 1345892017 | Dr. Sara Dorsey | Atlanta Wellness Clinic | Atlanta | GA | PROV2018 | 1993847502 | Dr. Mark Allen | Nephrology | Atlanta Kidney Center | Atlanta | GA | 2023-07-18 | Renal function decline | blank | in-progress | Labs suggest worsening CKD. | NWK012 |
| REF0019 | routine | Geriatrics | PROV1019 | 1229485760 | Dr. Linda Choi | Seattle Senior Care | Seattle | WA | PROV2019 | 1339485201 | Dr. Victor Klein | Pain Management | Bellevue Pain Center | Bellevue | WA | 2023-10-12 | Chronic back pain | PAT7Q8V3P | completed | blank | blank |
| REF0020 | routine | Family Medicine | PROV1020 | 1402849561 | Dr. Gregory Smith | Columbus Health Group | Columbus | OH | PROV2020 | 1883947501 | Dr. Anjali Kumar | Endocrinology | Columbus Endocrine Center | Columbus | OH | 2022-10-31 | New diagnosis of hypothyroidism | blank | completed | Needs specialist follow-up. | NWK013 |
What the 200 rows show
from the 200-row sample- 4referral statuses
- 18referred provider specialties
- 37referring provider states
- 37referred provider states
- string 21
- date 1
Columns
22 columns in two groups| column | type | description | example |
|---|---|---|---|
| Text 21 columns | |||
referral_id | string | Unique identifier for each provider-to-provider referral eventunique | REF0001 |
referring_provider_id | string | Unique identifier for the provider making the referral | PROV1001 |
referring_provider_npi | string | National Provider Identifier (NPI) of the referring provideroptional | 1678953021 |
referring_provider_name | string | Full name of the referring provideroptional | Dr. Alice Nguyen |
referring_provider_specialty | string | Medical specialty of the referring provider6 specialties · optional | Family Medicine |
referring_provider_organization | string | Organization or practice name of the referring provideroptional | Houston Medical Group |
referring_provider_city | string | City where the referring provider practicesoptional | Houston |
referring_provider_state | string | State where the referring provider practicesoptional | TX |
referred_provider_id | string | Unique identifier for the provider receiving the referral | PROV2001 |
referred_provider_npi | string | National Provider Identifier (NPI) of the referred provideroptional | 1338509245 |
referred_provider_name | string | Full name of the referred provideroptional | Dr. John Carter |
referred_provider_specialty | string | Medical specialty of the referred provideroptional | Cardiology |
referred_provider_organization | string | Organization or practice name of the referred provideroptional | Houston Heart Center |
referred_provider_city | string | City where the referred provider practicesoptional | Houston |
referred_provider_state | string | State where the referred provider practicesoptional | TX |
referral_reason | string | Short description or code for the reason for referraloptional | Chest pain evaluation |
patient_id | string | Unique identifier for the patient being referred (de-identified)optional | PAT1A23BC |
referral_status | string | Current status of the referral (e.g., pending, completed, cancelled)pending · completed · cancelled · in-progress · optional | completed |
referral_priority | string | Priority level of the referral (e.g., routine, urgent, stat)routine · urgent · stat · optional | routine |
referral_notes | string | Additional notes or comments about the referraloptional | Ultrasound recommended. |
network_id | string | Identifier for the healthcare network or system facilitating the referraloptional | NWK001 |
| Dates and times 1 column | |||
referral_date | date | Date the referral was made | 2023-08-12 |
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.
- Referrals200REF0001routineREF0002routineREF0003stat
A software demo
Believable referrals with referring_
provider_ id, referring_ provider_ npi and referring_ provider_ name to fill a screen in front of a buyer.
blueprint · doctor-referral-network-connections
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.
- Each row is a referral event.
- Specialty and provider IDs included.
- Referral reason and outcome labeled.
- Timestamp and region provided.
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
- doctor-referral-network-connections