Patient Appointment No-Show Data

This dataset provides detailed records of patient appointments, including attendance status, patient demographics, health conditions, and reminder interventions. It enables healthcare providers and analysts to identify patterns and factors contributing to missed appointments, supporting the development of targeted interventions to improve patient engagement and clinic efficiency.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Predictive modeling of appointment no-shows

Sample rows

preview · 8 of 80 rows · all 19 columns
appointment_idstringappointment_typestringageintegerno_showbooleanneighbourhoodstringpatient_idstringappointment_datedateappointment_timestringscheduled_datedatescheduled_timestringgenderstringscholarshipbooleanhypertensionbooleandiabetesbooleanalcoholismbooleanhandicapintegersms_receivedbooleanclinic_idstringclinic_namestring
APT10001general28falseBrooklynPAT00012024-06-1008:302024-06-0515:21femalefalsefalsefalsefalse0trueCLINIC01Greenwood Medical
APT10002specialist53falseHarlemPAT00022024-06-1209:452024-06-0716:10malefalsetruefalsefalse1trueCLINIC02Central Health
APT10003follow-up34trueQueens VillagePAT00032024-06-1311:002024-06-0913:35femaletruefalsefalsefalse0falseCLINIC03Riverbend Clinic
APT10004general28falseBrooklynPAT00012024-06-1614:152024-06-1412:10femalefalsefalsefalsefalse0falseCLINIC01Greenwood Medical
APT10005general42trueUpper East SidePAT00042024-06-1410:002024-06-1009:40malefalsefalsefalsetrue1trueCLINIC02Central Health
APT10006specialist66falseStaten IslandPAT00052024-06-1515:302024-06-1110:50malefalsetruefalsefalse2falseCLINIC04Southside Family Health
APT10007follow-up58falseWilliamsburgPAT00062024-06-2008:002024-06-1717:15femaletruetruetruefalse1trueCLINIC03Riverbend Clinic
APT10008general19trueChelseaPAT00072024-06-2113:202024-06-1314:44femalefalsefalsefalsefalse0falseCLINIC05Broadway Health Center

What the 80 rows show

from the 80-row sample

General (appointment type) stands out: mean age is 32.3, against 53.7 for the rest.

  • 30%no_show = true
  • 42median age
  • 4genders
  • 15clinics
  • 15clinic names
  • 1median handicap
Mean age by appointment_type80 rows
0408032.3general38 rows52.7specialist21 rows54.8follow-up21 rows
age80 rows, in bands of 10
0918316181511125105080age →

Median 42, from 18 to 77.

neighbourhood80 rows · top 10 of 21 values
  1. Greenfield6
  2. Riverside6
  3. Brooklyn5
  4. Harlem5
  5. Old Town5
  6. Maple Heights5
  7. Brooklyn West5
  8. Elmwood5
  9. Williamsburg4
  10. Astoria4
19 columns by typefrom the column list below
  • string 9
  • integer 2
  • date 2
  • boolean 6

Columns

19 columns in four groups
blueprint · 19 columns
columntypedescriptionexample
Text 9 columns
appointment_idstringUnique identifier for each appointment recorduniqueAPT10001
patient_idstringUnique identifier for each patientPAT0001
appointment_timestringScheduled time of the appointment (24-hour format, e.g., '14:30')08:30
scheduled_timestringTime when the appointment was scheduled/booked (24-hour format, e.g., '09:15')15:21
genderstringPatient's gendermale · female · other · unknown · optionalfemale
neighbourhoodstringPatient's residential neighborhood or districtoptionalBrooklyn
appointment_typestringType or category of the appointment (e.g., general, specialist, follow-up)3 types · optionalgeneral
clinic_idstringUnique identifier for the clinic or facility where the appointment is scheduledoptionalCLINIC01
clinic_namestringName of the clinic or facilityoptionalGreenwood Medical
Numbers 2 columns
ageintegerPatient's age at the time of the appointment0 to 120 · optional28
handicapintegerDegree of disability/handicap (0 = none, 1 = mild, 2 = moderate, 3 = severe, 4 = very severe)0 to 4 · optional0
Dates and times 2 columns
appointment_datedateScheduled date of the appointment2024-06-10
scheduled_datedateDate when the appointment was scheduled/booked2024-06-05
True or false 6 columns
no_showbooleanIndicates whether the patient missed the appointment (true = no-show, false = attended)false
scholarshipbooleanIndicates if the patient is enrolled in a welfare program or scholarshipoptionalfalse
hypertensionbooleanIndicates if the patient has been diagnosed with hypertensionoptionalfalse
diabetesbooleanIndicates if the patient has been diagnosed with diabetesoptionalfalse
alcoholismbooleanIndicates if the patient has a history of alcoholismoptionalfalse
sms_receivedbooleanIndicates if the patient received an SMS reminder for the appointmentoptionaltrue

Use it for

  • no show30%24 of 80 rowsmean age by appointme…32.3general52.7specia…54.8follow…

    A healthcare dashboard

    The no_show rate, age by appointment_type and a breakdown of neighbourhood. Excel, Power BI or Tableau.

  • Why do the 38 general rows have a mean age of 32.3?

    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, appointment_date and appointment_time to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 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 dataset80 rows19 columns
Yours1,000 rows19 columns

blueprint · patient-appointment-no-show-data

Behind this dataset

Same schema. As many rows as you need.

These 80 rows came out of a blueprint — 19 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
  • Patients must have at least one appointment
  • Missed appointments are recorded with reasons when available
  • Reminders sent 24 hours before confirmed appointments
  • Patients with 3+ no-shows flagged for follow-up
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
patient-appointment-no-show-data

What should your data show?

Preview 20 rows free
No signup. No card.