Appointment Schedules

This dataset provides a comprehensive view of medical appointment schedules, including patient demographics, provider details, appointment types, durations, and actual check-in/check-out times. It enables robust analysis of healthcare operations, patient flow, and provider efficiency, supporting both clinical and administrative decision-making.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Optimizing clinic schedules and resource allocation

Sample rows

preview · 8 of 200 rows · all 24 columns
appointment_idstringappointment_typestringappointment_duration_minutesintegerprovider_namestringpatient_idstringpatient_first_namestringpatient_last_namestringpatient_date_of_birthdatepatient_genderstringprovider_idstringprovider_specialtystringappointment_datedateappointment_start_timedatetimeappointment_end_timedatetimecheck_in_timedatetimecheck_out_timedatetimeappointment_statusstringlocation_namestringlocation_street_addressstringlocation_citystringlocation_statestringlocation_postal_codestringlocation_countrystringnotesstring
APT000001consultation45Dr. Emily CarterPAT1001JessicaNguyen1982-09-15femalePRV2001Pediatrics2024-06-102024-06-10T09:00:002024-06-10T09:45:002024-06-10T08:50:002024-06-10T09:50:00completedCentral Family Medical Clinic125 Maple AveSpringfieldIL62704USAPatient concerned about persistent cough, prescribed antibiotics.
APT000002follow-up45Dr. Alan SmithPAT1002BrianChoi1995-03-02malePRV2002Cardiology2024-06-112024-06-11T13:30:002024-06-11T14:15:002024-06-11T13:20:002024-06-11T14:25:00completedSpringfield Heart Center312 Oak StSpringfieldIL62705USAReviewed EKG, patient stable, continue current medication.
APT000003physical exam40Dr. Emily CarterPAT1003AvaJohnson2010-07-24femalePRV2001Pediatrics2024-06-122024-06-12T10:00:002024-06-12T10:40:002024-06-12T09:55:002024-06-12T10:45:00completedCentral Family Medical Clinic125 Maple AveSpringfieldIL62704USAAnnual school physical, all vitals normal.
APT000004consultation30Dr. Priya PatelPAT1004LucasWilliams1978-11-07malePRV2003Orthopedics2024-06-132024-06-13T15:00:002024-06-13T15:30:00blankblankscheduledSpringfield Orthopedic Center200 Pine StSpringfieldIL62706USAConsult regarding knee pain after running.
APT000005procedure30Dr. John LeePAT1005MiaGarcia1989-05-19femalePRV2004Dermatology2024-06-142024-06-14T11:00:002024-06-14T11:30:002024-06-14T10:50:002024-06-14T11:40:00completedSpringfield Skin Center55 Birch RdSpringfieldIL62707USAMole removal procedure, no complications.
APT000006consultation30Dr. Alan SmithPAT1006NoahBrown1965-02-13malePRV2002Cardiology2024-06-162024-06-16T14:00:002024-06-16T14:30:00blankblankscheduledSpringfield Heart Center312 Oak StSpringfieldIL62705USAConsultation for high blood pressure management.
APT000007follow-up30Dr. Mark JonesPAT1007SophiaMartinez2002-04-29femalePRV2005General Medicine2024-06-172024-06-17T09:15:002024-06-17T09:45:002024-06-17T09:05:002024-06-17T09:55:00completedSpringfield Community Health200 Walnut StSpringfieldIL62708USAFollow-up for migraine treatment, new medication prescribed.
APT000008physical exam35Dr. Emily CarterPAT1008OliverKim2013-12-05malePRV2001Pediatrics2024-06-182024-06-18T10:30:002024-06-18T11:05:002024-06-18T10:25:002024-06-18T11:10:00completedCentral Family Medical Clinic125 Maple AveSpringfieldIL62704USAPhysical exam for summer camp, no health issues.

What the 200 rows show

from the 200-row sample

Procedure (appointment type) stands out: mean appointment_duration_minutes is 62.5, against 29.6 for the rest.

  • 30median appointment_duration_minutes
  • 2appointment statuses
  • 4patient genders
  • 4location states
  • 9location cities
  • 15provider specialties
Mean appointment_duration_minutes by appointment_type200 rows
0408030.4consul…91 rows30.3follow…29 rows30.4physic…40 rows62.5proced…34 rows10.0other6 rows
appointment_duration_minutes200 rows, in bands of 10
0501001035992749141011060110appointment_duration_minutes →

Median 30, from 10 to 105.

provider_name200 rows · top 10 of 28 values
  1. Dr. Emily Carter15
  2. Dr. Emily Lin11
  3. Dr. Emily Tran10
  4. Dr. Michael Carter10
  5. Dr. Mark Jones9
  6. Dr. Lillian Ford9
  7. Dr. Ashley Bennett8
  8. Dr. Sara Patel8
  9. Dr. Brittany Cruz8
  10. Dr. Priya Patel7
24 columns by typefrom the column list below
  • string 17
  • integer 1
  • date 2
  • datetime 4

Columns

24 columns in three groups
blueprint · 24 columns
columntypedescriptionexample
Text 17 columns
appointment_idstringUnique identifier for each appointment bookinguniqueAPT000001
patient_idstringUnique identifier for the patientPAT1001
patient_first_namestringPatient's first nameJessica
patient_last_namestringPatient's last nameNguyen
patient_genderstringPatient's gendermale · female · other · unknown · optionalfemale
provider_idstringUnique identifier for the healthcare providerPRV2001
provider_namestringFull name of the healthcare providerDr. Emily Carter
provider_specialtystringMedical specialty of the provider (e.g., cardiology, pediatrics)optionalPediatrics
appointment_typestringType of appointment (e.g., consultation, follow-up, physical exam)consultation · follow-up · physical exam · procedure · otherconsultation
appointment_statusstringCurrent status of the appointment (e.g., scheduled, completed, cancelled, no-show)scheduled · completed · cancelled · no-showcompleted
location_namestringName of the clinic or facility where the appointment takes placeoptionalSpringfield Heart Center
location_street_addressstringStreet address of the appointment locationoptional125 Maple Ave
location_citystringCity of the appointment location9 cities · optionalSpringfield
location_statestringState or province of the appointment location4 states · optionalIL
location_postal_codestringPostal or ZIP code of the appointment locationoptional62704
location_countrystringCountry of the appointment locationoptionalUSA
notesstringAdditional notes or comments related to the appointmentoptionalConsult for dizziness.
Numbers 1 column
appointment_duration_minutesintegerDuration of the appointment in minutes1 or more45
Dates and times 6 columns
patient_date_of_birthdatePatient's date of birth1982-09-15
appointment_datedateScheduled date of the appointment2024-06-10
appointment_start_timedatetimeScheduled start time of the appointment2024-06-10T09:00:00
appointment_end_timedatetimeScheduled end time of the appointment2024-06-10T09:45:00
check_in_timedatetimeActual check-in time for the appointmentoptional2024-06-10T08:50:00
check_out_timedatetimeActual check-out time for the appointmentoptional2024-06-10T09:50:00

Use it for

  • median appoint…30200 rowsmean appointment dura…30.4cons…30.3foll…30.4phys…62.5proc…

    A healthcare dashboard

    Appointment_duration_minutes by appointment_type and a breakdown of provider_name. Excel, Power BI or Tableau.

  • Why do the 34 procedure rows have a mean appointment_duration_minutes of 62.5?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable appointments with patient_id, patient_first_name and patient_last_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 24 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 rows24 columns
Yours1,000 rows24 columnslocation_name: UK only

blueprint · appointment-schedules

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 24 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
  • Appointment slots based on provider availability
  • Duration varies by appointment type
  • Status: scheduled, checked-in, completed, no-show
  • Reminder notifications sent before appointment
  • Insurance verification before appointment
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
appointment-schedules

More in Healthcare

Browse all
Also in HealthcarePatient Appointment No-show LogsClaims Denials and Rejection ManagementPharmacy Inventory ForecastingAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.