Healthcare Appointment Scheduling Analysis

This dataset contains detailed healthcare appointment scheduling records, including patient demographics, provider and clinic information, appointment statuses, and resource allocation metrics. It is designed to help clinics optimize scheduling, reduce no-show rates, and improve resource management through actionable insights.

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

Reducing patient no-show rates through predictive analytics

Sample rows

preview · 8 of 200 rows · all 25 columns
appointment_idstringappointment_typestringresource_allocation_minutesintegerno_show_flagbooleanaddress_streetstringpatient_idstringpatient_ageintegerpatient_genderstringappointment_datedateappointment_timestringbooking_datetimedatetimeclinic_idstringclinic_namestringprovider_idstringprovider_namestringstatusstringcancellation_reasonstringreminder_sentbooleanreminder_datetimedatetimepatient_contact_phonestringpatient_contact_emailstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystring
APT10001vaccination15false123 Maple AvePAT0013female2024-06-1709:152024-06-10T14:22:00CLN03Children's Health PlusDR101Dr. Emily Cartercompletedblanktrue2024-06-15T10:00:00blankblankSpringfieldIL62704USA
APT10002physical90false789 Oak StPAT00272male2024-06-1911:002024-06-12T09:30:00CLN05Elderly Wellness CareDR201Dr. Brian Fordcompletedblanktrue2024-06-17T08:00:00+1-312-555-0123b.ford72@elderwell.comNapervilleIL60540USA
APT10003consultation30false456 Pine StPAT00329female2024-06-2014:302024-06-13T13:00:00CLN01Downtown Medical CenterDR102Dr. Susan Linscheduledblanktrue2024-06-18T09:15:00+1-212-555-0178susan.lin29@downtownmed.comNew YorkNY10001USA
APT10004consultation20false123 Maple AvePAT0048male2024-06-1810:002024-06-16T16:45:00CLN03Children's Health PlusDR103Dr. Anthony RamirezscheduledblankfalseblankblankblankSpringfieldIL62704USA
APT10005follow-up30false456 Pine StPAT00540female2024-06-2216:452024-06-15T10:37:00CLN01Downtown Medical CenterDR102Dr. Susan Linscheduledblanktrue2024-06-20T11:00:00+1-212-555-0199lin40@downtownmed.comNew YorkNY10001USA
APT10006physical120false789 Oak StPAT00684male2024-06-2108:002024-06-14T08:20:00CLN05Elderly Wellness CareDR202Dr. Angela Kimcompletedblanktrue2024-06-19T09:00:00+1-630-555-0134a.kim84@elderwell.comNapervilleIL60540USA
APT10007consultation45false321 Cedar RdPAT00734female2024-06-2018:302024-06-17T18:45:00CLN02Urban Family ClinicDR104Dr. Rachel Wongcompletedblanktrue2024-06-19T15:00:00+1-718-555-0115rachel.wong34@urbanfam.comBrooklynNY11201USA
APT10008follow-up35false321 Cedar RdPAT00855male2024-06-1613:302024-06-08T10:02:00CLN02Urban Family ClinicDR105Dr. Thomas Leescheduledblankfalseblank+1-718-555-0177thomas.lee55@urbanfam.comBrooklynNY11201USA

What the 200 rows show

from the 200-row sample

Physical (appointment type) stands out: mean resource_allocation_minutes is 104.0, against 35.9 for the rest.

  • 4%no_show_flag = true
  • 35median resource_allocation_minutes
  • 4patient genders
  • 5statuses
  • 5address countries
  • 9address states
Mean resource_allocation_minutes by appointment_type200 rows
010020036.3consul…90 rows39.3follow…22 rows104.0physic…52 rows13.9vaccin…23 rows66.2other13 rows
resource_allocation_minutes200 rows, in bands of 25
04590438618202241420125225resource_allocation_minutes →

Median 35, from 10 to 210.

address_street200 rows · top 10 of 28 values
  1. 120 Palm Blvd12
  2. 125 Maple Avenue11
  3. 48 Sunrise Way11
  4. 525 Madison Ave11
  5. 16 Willow Street11
  6. 1527 Willow Drive10
  7. 90 Alexanderplatz9
  8. 305 East 23rd St9
  9. 3910 Orchard Lane9
  10. 4956 Apple Avenue9
25 columns by typefrom the column list below
  • string 18
  • integer 2
  • date 1
  • datetime 2
  • boolean 2

Columns

25 columns in four groups
blueprint · 25 columns
columntypedescriptionexample
Text 18 columns
appointment_idstringUnique identifier for each scheduled appointmentuniqueAPT10001
patient_idstringUnique identifier for the patient booking the appointmentPAT001
patient_genderstringGender of the patientmale · female · other · unknownfemale
appointment_timestringScheduled time of the appointment in HH:MM format09:15
clinic_idstringUnique identifier for the clinic where the appointment is scheduled11 clinicsCLN03
clinic_namestringName of the clinicChildren's Health Plus
provider_idstringUnique identifier for the healthcare provider (doctor, nurse, etc.)DR101
provider_namestringName of the healthcare providerDr. Emily Carter
appointment_typestringType of appointment (e.g., consultation, follow-up, physical, vaccination)consultation · follow-up · physical · vaccination · othervaccination
statusstringFinal status of the appointmentscheduled · completed · cancelled · no-show · rescheduledcompleted
cancellation_reasonstringReason for cancellation, if applicableoptionalPatient traveling abroad
patient_contact_phonestringPatient's contact phone numberoptional+1-312-555-0123
patient_contact_emailstringPatient's contact email addressoptionalb.ford72@elderwell.com
address_streetstringStreet address of the clinicoptional123 Maple Ave
address_citystringCity where the clinic is locatedoptionalSpringfield
address_statestringState or province of the clinic location9 states · optionalIL
address_postal_codestringPostal code of the clinicoptional62704
address_countrystringCountry where the clinic is located5 countries · optionalUSA
Numbers 2 columns
patient_ageintegerAge of the patient at the time of appointment0 to 1203
resource_allocation_minutesintegerNumber of minutes allocated for the appointment5 to 24015
Dates and times 3 columns
appointment_datedateScheduled date of the appointment2024-06-17
booking_datetimedatetimeTimestamp when the appointment was booked2024-06-10T14:22:00
reminder_datetimedatetimeTimestamp when the reminder was sentoptional2024-06-15T10:00:00
True or false 2 columns
no_show_flagbooleanIndicates whether the patient failed to attend the appointmentfalse
reminder_sentbooleanIndicates if an appointment reminder was sent to the patienttrue

Use it for

  • no show flag4%8 of 200 rowsmean resource allocat…36.3cons…39.3foll…104.0phys…13.9vacc…

    A healthcare dashboard

    The no_show_flag rate, resource_allocation_minutes by appointment_type and a breakdown of address_street. Excel, Power BI or Tableau.

  • Why do the 52 physical rows have a mean resource_allocation_minutes of 104.0?

    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_age and patient_gender to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 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 rows25 columns
Yours1,000 rows25 columnsaddress_street: UK only

blueprint · healthcare-appointment-scheduling-analysis

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 25 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
  • Patient and provider IDs anonymized
  • Scheduled, rescheduled, and no-show status included
  • Appointment type and timing tracked
  • Location variable for multi-site analysis
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-appointment-scheduling-analysis

More in Healthcare

Browse all
Also in HealthcareAppointment SchedulesHealthcare-Insurance Claims IntegrationHospital Readmission Prediction DatasetAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.