Healthcare Outpatient Visit Analysis

This dataset provides granular details of outpatient visits, including patient demographics, provider information, visit timing, service types, and operational metrics such as wait times and visit status. It is designed to support healthcare resource allocation, patient flow management, and service utilization analysis, enabling data-driven improvements in clinical operations and patient experience.

  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Optimizing resource allocation and staffing in outpatient clinics

Sample rows

preview · 8 of 200 rows · all 23 columns
visit_idstringvisit_statusstringpatient_ageintegeraddress_citystringpatient_idstringprovider_idstringvisit_datedatevisit_start_timedatetimevisit_end_timedatetimeservice_typestringdepartmentstringprovider_namestringpatient_genderstringvisit_reasonstringdiagnosis_codestringprocedure_codestringwait_time_minutesintegervisit_duration_minutesintegerinsurance_typestringaddress_streetstringaddress_statestringaddress_postal_codestringaddress_countrystring
VISIT0001completed68San DiegoPAT1001PROV0012024-03-042024-03-04T09:15:002024-03-04T09:45:00consultationcardiologyHeartwell ClinicfemaleRoutine heart check-upI10blank1230Medicare1209 Elm StCA92116US
VISIT0002completed42Chula VistaPAT1002PROV0022024-03-052024-03-05T11:10:002024-03-05T11:40:00lab_testpathologySouthside Medical CentermaleBlood test for cholesterolE78.080053830Blue Shield3040 Harbor DrCA91910US
VISIT0003completed57IrvinePAT1003PROV0032024-03-062024-03-06T13:00:002024-03-06T13:25:00imagingradiologyCentral ImagingfemaleChest X-ray for coughR0571020525Aetna1555 Main StCA92614US
VISIT0004completed33San DiegoPAT1004PROV0012024-03-072024-03-07T08:30:002024-03-07T08:55:00consultationdermatologyHeartwell ClinicmaleSkin rash assessmentL30.9blank325Cigna1209 Elm StCA92116US
VISIT0005scheduled19EscondidoPAT1005PROV0042024-03-072024-03-07T14:20:00blankprocedureorthopedicsSummit OrthofemaleFollow-up for sprained ankleS93.427650blankblankUnited Healthcare3322 Alpine LnCA92025US
VISIT0006completed50Santa AnaPAT1006PROV0052024-03-082024-03-08T15:00:002024-03-08T15:12:00follow_upendocrinologyPacific EndocrinefemaleDiabetes medication reviewE11.9blank012Medicare4000 Pacific AveCA92701US
VISIT0007completed73AnaheimPAT1007PROV0062024-03-092024-03-09T10:10:002024-03-09T10:37:00consultationneurologyBright Minds ClinicmaleMemory assessmentG31.84blank627Blue Shield2157 Oak RdCA92805US
VISIT0008scheduled7Santa ClaritaPAT1008PROV0072024-03-102024-03-10T09:45:00blankconsultationpediatricsSunrise Children'smaleAnnual physical examblankblankblankblankAetna4120 Sunrise BlvdCA91350US

What the 200 rows show

from the 200-row sample
  • 46median patient_age
  • 3patient genders
  • 3address countries
  • 6service types
  • 8address states
  • 12insurance types
visit_status200 rows by value
095190188completed94%12scheduled6%
patient_age200 rows, in bands of 10
0204054284038393212205090patient_age →

Median 46, from 3 to 81.

address_city200 rows · top 10 of 37 values
  1. Denver23
  2. Phoenix20
  3. Tempe19
  4. Mesa13
  5. Fresno12
  6. Montreal12
  7. Austin12
  8. Reno10
  9. Portland10
  10. Vancouver10
23 columns by typefrom the column list below
  • string 17
  • integer 3
  • date 1
  • datetime 2

Columns

23 columns in three groups
blueprint · 23 columns
columntypedescriptionexample
Text 17 columns
visit_idstringUnique identifier for each outpatient visituniqueVISIT0001
patient_idstringUnique identifier for the patientPAT1001
provider_idstringUnique identifier for the healthcare provider or clinicPROV001
service_typestringType of outpatient service provided (e.g., consultation, lab test, imaging)6 valuesconsultation
departmentstringDepartment within the provider facility (e.g., cardiology, dermatology)cardiology
provider_namestringName of the healthcare provider or clinicHeartwell Clinic
patient_genderstringGender of the patientmale · female · other · unknownfemale
visit_reasonstringPrimary reason for the outpatient visitRoutine heart check-up
diagnosis_codestringStandardized code for diagnosis (e.g., ICD-10)optionalI10
procedure_codestringStandardized code for procedure performed (e.g., CPT)optional80053
visit_statusstringStatus of the visit (e.g., completed, cancelled, no-show)completed · cancelled · no-show · scheduledcompleted
insurance_typestringType of insurance used for the visit12 types · optionalMedicare
address_streetstringStreet address of the provider facilityoptional1209 Elm St
address_citystringCity of the provider facilityoptionalSan Diego
address_statestringState of the provider facility8 states · optionalCA
address_postal_codestringPostal code of the provider facilityoptional92116
address_countrystringCountry of the provider facility3 countries · optionalUS
Numbers 3 columns
patient_ageintegerAge of the patient at the time of visit0 to 12068
wait_time_minutesintegerNumber of minutes the patient waited before being seen0 or more · optional12
visit_duration_minutesintegerTotal duration of the outpatient visit in minutes0 or more · optional30
Dates and times 3 columns
visit_datedateDate of the outpatient visit2024-03-04
visit_start_timedatetimeTimestamp when the visit started2024-03-04T09:15:00
visit_end_timedatetimeTimestamp when the visit ended2024-03-04T09:45:00

Use it for

  • median patient…46200 rowsmean patient age by v…46.1comple…36.7schedu…

    A healthcare dashboard

    Patient_age by visit_status and a breakdown of address_city. 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.

  • A software demo

    Believable visits with patient_id, provider_id and visit_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 23 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows23 columns
Yours1,000 rows23 columnsaddress_street: UK only

blueprint · healthcare-outpatient-visit-analysis

Behind this dataset

Same schema. As many rows as you need.

These 200 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
  • Track visits by department
  • Segment by appointment type
  • Include patient waiting times
  • Flag repeat visits
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-outpatient-visit-analysis

More in Healthcare

Browse all
Also in HealthcareHospital Admission Risk FactorsPharmacy Inventory ForecastingPharmacy Inventory Movement DatasetAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.