Healthcare
36 columns
200 rows
8 formats

Healthcare Appointment No-Show Patterns

This dataset provides detailed records of scheduled healthcare appointments, including patient demographics, appointment logistics, provider information, reminder history, and final outcomes such as no-shows or cancellations. It enables in-depth analysis of factors influencing appointment attendance and supports predictive modeling to reduce no-show rates and improve healthcare delivery.

last updated 29 Jul 2025
by GoMask

The brief that made it

Predictive modeling to identify patients at risk of missing appointments

Sample rows

preview · 8 of 200 rows · all 36 columns

appointment_idstring	reminder_methodstring	previous_appointments_countinteger	reminder_sentboolean	patient_race_ethnicitystring	patient_idstring	patient_genderstring	patient_birth_datedate	patient_phone_numberstring	patient_emailstring	patient_street_addressstring	patient_citystring	patient_statestring	patient_postal_codestring	patient_countrystring	appointment_datedate	appointment_timestring	appointment_created_datetimedatetime	appointment_typestring	departmentstring	provider_idstring	provider_namestring	clinic_locationstring	reminder_sent_datetimedatetime	cancellation_flagboolean	cancellation_datetimedatetime	cancellation_reasonstring	no_show_flagboolean	check_in_flagboolean	check_in_datetimedatetime	appointment_statusstring	insurance_providerstring	copay_amountfloat	chronic_conditions_flagboolean	previous_no_show_countinteger	notesstring
A1000001	sms	6	true	White	P001	female	1985-06-17	+1-415-555-1901	lisa.martin85@gmail.com	234 Pine St	San Francisco	CA	94111	USA	2024-08-05	09:30	2024-07-20T14:12:00	check-up	general practice	PR001	Dr. Michael Nguyen	SF Clinic North	2024-08-03T15:30:00	false	blank	blank	false	true	2024-08-05T09:24:00	completed	Aetna	35	false	0	Routine annual physical. No concerns reported.
A1000002	phone_call	18	true	Black	P002	male	1968-02-03	+1-718-555-2022	ronald.davis68@yahoo.com	987 Flatbush Ave	Brooklyn	NY	11226	USA	2024-08-06	11:15	2024-07-10T10:54:00	consultation	cardiology	PR002	Dr. Alicia Chen	NY Heart Center	2024-08-04T15:00:00	false	blank	blank	false	true	2024-08-06T11:12:00	completed	Medicare	0	true	1	Complaints of chest pain, history of hypertension.
A1000003	sms	4	true	Hispanic/Latino	P003	female	2016-03-21	+1-305-555-1988	parent.maria21@gmail.com	123 Ocean Dr	Miami	FL	33139	USA	2024-08-07	08:00	2024-07-29T17:04:00	check-up	pediatrics	PR003	Dr. Emily Harrington	Sunshine Pediatrics	2024-08-05T16:00:00	false	blank	blank	true	false	blank	no-show	Florida Healthy Kids	0	false	2	Missed well-child visit; reschedule needed.
A1000004	email	8	true	Asian	P004	other	1999-12-11	+82 2-555-3030	j.kim1999@hanmail.net	77 Gangnam-daero	Seoul	Seoul	06236	South Korea	2024-08-08	10:00	2024-07-18T12:21:00	consultation	endocrinology	PR004	Dr. Sun Park	Seoul Endo Clinic	2024-08-06T18:00:00	false	blank	blank	false	true	2024-08-08T09:55:00	completed	NHIS	3.5	true	0	Follow-up for thyroid function, stable labs.
A1000005	sms	2	true	White	P005	male	2011-07-09	+1-206-555-0421	parent.daniel9@yahoo.com	432 Cedar Ave	Seattle	WA	98109	USA	2024-08-09	15:00	2024-07-14T16:30:00	check-up	pediatrics	PR005	Dr. Rachel Lee	Emerald Pediatrics	2024-08-07T10:15:00	false	blank	blank	false	true	2024-08-09T14:55:00	completed	Kaiser Permanente	0	false	0	School physical, vaccinations up to date.
A1000006	phone_call	33	true	White	P006	female	1950-10-14	+33 1 44 55 66 77	claire.dubois50@outlook.fr	12 Rue de Rivoli	Paris	Île-de-France	75001	France	2024-08-10	14:30	2024-07-15T11:45:00	follow-up	geriatrics	PR006	Dr. Jean Morel	Paris Central Med	2024-08-08T09:00:00	false	blank	blank	false	true	2024-08-10T14:28:00	completed	Assurance Maladie	0	true	2	Memory check and medication review.
A1000007	none	7	false	Asian	P007	female	1996-09-29	+1-213-555-1122	meilin.cho1996@gmail.com	88 S Broadway	Los Angeles	CA	90015	USA	2024-08-11	13:00	2024-07-21T09:27:00	procedure	dermatology	PR007	Dr. Omar Patel	LA Skin Center	blank	false	blank	blank	false	true	2024-08-11T13:10:00	completed	Cigna	45	false	0	Minor mole removal performed.
A1000008	none	0	false	blank	P008	unknown	blank	blank	blank	blank	blank	blank	blank	blank	2024-08-12	17:45	2024-08-11T10:00:00	consultation	psychiatry	PR008	Dr. Henry Bloom	Urban Wellness Ctr	blank	false	blank	blank	false	true	2024-08-12T17:54:00	completed	blank	0	false	0	Anonymous walk-in for mental health evaluation.
A1000009	none	12	false	Middle Eastern	P009	male	1975-04-01	+971 50 123 4567	faisal.alnuaimi@outlook.ae	16 Sheikh Zayed Rd	Dubai	Dubai	00000	UAE	2024-08-13	18:30	2024-07-18T18:55:00	consultation	urology	PR009	Dr. Noor Hassan	Mediclinic City	blank	true	2024-08-12T08:00:00	Travel emergency	false	false	blank	cancelled	AXA Gulf	12.5	false	1	Patient cancelled due to urgent travel.
A1000010	sms	6	true	Black	P010	female	1992-05-05	+55 21 99999-8888	ana.silva92@gmail.com	Rua das Flores 221	Rio de Janeiro	RJ	22041-011	Brazil	2024-08-14	10:45	2024-07-28T13:40:00	follow-up	allergy	PR010	Dr. Marcos Rios	Unimed Barra	2024-08-12T09:00:00	false	blank	blank	false	true	2024-08-14T10:41:00	completed	Unimed	0	true	0	Seasonal allergy follow-up, new antihistamine tried.
A1000011	email	11	true	White	P011	male	1979-09-17	+1-312-555-8272	james.elliott1979@gmail.com	501 Lake Shore Dr	Chicago	IL	60611	USA	2024-08-15	12:00	2024-07-30T16:30:00	procedure	orthopedics	PR011	Dr. Linda Clark	Midwest Ortho Center	2024-08-13T19:00:00	false	blank	blank	false	true	2024-08-15T12:02:00	completed	Blue Cross Blue Shield	60	false	1	Knee arthroscopy completed, follow-up in 2 weeks.
A1000012	phone_call	41	true	Hispanic/Latino	P012	female	1944-11-30	+44 20 7123 4567	maria.fernandez44@nhs.uk	14 Regent St	London	London	W1B 2QS	UK	2024-08-16	16:15	2024-07-16T09:40:00	check-up	geriatrics	PR012	Dr. Simon Harris	London Health Hub	2024-08-14T10:00:00	false	blank	blank	false	true	2024-08-16T16:19:00	completed	NHS	0	true	3	Quarterly check-up, mild hypertension.
A1000013	sms	5	true	Pacific Islander	P013	male	1981-01-18	+1-808-555-8812	kimo.kala1981@gmail.com	77 Ala Moana Blvd	Honolulu	HI	96814	USA	2024-08-17	10:20	2024-08-01T11:28:00	consultation	gastroenterology	PR013	Dr. Julia Torres	Waikiki Health	2024-08-15T12:00:00	false	blank	blank	false	false	blank	scheduled	HMSA	30	false	0	New GI symptoms, scheduled endoscopy.
A1000014	email	3	true	East Asian	P014	female	2005-12-07	+82 2-555-4442	parent.yuna05@naver.com	42 Itaewon-ro	Seoul	Seoul	04348	South Korea	2024-08-18	08:10	2024-07-24T07:14:00	check-up	adolescent medicine	PR014	Dr. Mina Jeong	Han River Clinic	2024-08-16T09:00:00	false	blank	blank	false	true	2024-08-18T08:06:00	completed	NHIS	0	false	0	Routine teen wellness, vision test included.
A1000015	sms	9	true	Multiracial	P015	male	1988-03-22	+1-202-555-3311	carlos.martinez88@gmail.com	1000 K St NW	Washington	DC	20001	USA	2024-08-19	13:45	2024-07-29T17:50:00	consultation	general practice	PR015	Dr. Priya Singh	Capitol Medical	2024-08-17T12:00:00	false	blank	blank	false	false	blank	scheduled	Aetna	40	false	1	General consultation, minor cold symptoms.
A1000016	none	0	false	blank	P016	unknown	blank	blank	blank	blank	blank	blank	blank	blank	2024-08-20	20:00	2024-08-20T15:30:00	procedure	dermatology	PR016	Dr. Lauren White	Downtown Skin Clinic	blank	false	blank	blank	false	true	2024-08-20T20:03:00	completed	blank	0	false	0	Anonymous after-hours walk-in for rash evaluation.
A1000017	email	8	true	White	P017	female	1983-11-02	+1-214-555-7120	kelly.james83@outlook.com	712 Maple Rd	Dallas	TX	75201	USA	2024-08-21	16:00	2024-08-02T13:41:00	check-up	general practice	PR017	Dr. Mark Sanders	Dallas Med Clinic	2024-08-19T10:00:00	false	blank	blank	false	false	blank	scheduled	Blue Cross Blue Shield	35	false	0	Annual check-up scheduled. No prior no-shows.
A1000018	sms	5	true	Native American	P018	female	2012-08-30	+1-505-555-2525	parent.sage12@icloud.com	31 Cedar Trail	Santa Fe	NM	87501	USA	2024-08-22	07:45	2024-08-09T15:00:00	check-up	pediatrics	PR018	Dr. Olivia Carter	Santa Fe Kids Clinic	2024-08-20T16:00:00	false	blank	blank	false	true	2024-08-22T07:47:00	completed	Medicaid	0	false	1	Immunizations up to date, healthy.
A1000019	none	16	false	Multiracial	P019	other	2000-04-15	+1-917-555-7788	jordan.lee2000@gmail.com	212 E 23rd St	New York	NY	10010	USA	2024-08-23	19:20	2024-08-11T20:38:00	consultation	neurology	PR019	Dr. Samuel Patel	NY Neurology Assoc	blank	false	blank	blank	true	false	blank	no-show	Cigna	50	true	3	No-show, complex migraine history.
A1000020	phone_call	27	true	White	P020	male	1961-02-26	+33 1 45 67 89 10	philippe.martin61@wanadoo.fr	8 Rue La Fayette	Paris	Île-de-France	75009	France	2024-08-24	09:00	2024-07-22T08:05:00	follow-up	oncology	PR020	Dr. Claire Bernard	Paris Oncology Inst	2024-08-22T09:00:00	false	blank	blank	false	true	2024-08-24T08:57:00	completed	Assurance Maladie	0	true	2	Cancer follow-up, labs reviewed.

What the 200 rows show

from the 200-row sample

Phone_call (reminder method) stands out: mean previous_appointments_count is 21.3, against 5.2 for the rest.

84%reminder_sent = true
5median previous_appointments_count
4patient genders
4appointment types
4appointment statuses
7patient countries

Mean previous_appointments_count by reminder_method200 rows

previous_appointments_count200 rows, in bands of 5

Median 5, from 0 to 44.

patient_race_ethnicity183 rows with a value · 17 left blank

White79
Asian31
Black20
Hispanic/Latino16
Multiracial10
Middle Eastern7
Native American7
Pacific Islander6
East Asian5
Other2

36 columns by typefrom the column list below

string 22
integer 2
float 1
date 2
datetime 4
boolean 5

Columns

36 columns in four groups

blueprint · 36 columns
column	type	description	example
Text 22 columns
`appointment_id`	string	Unique identifier for each scheduled appointmentunique	A1000001
`patient_id`	string	Unique identifier for the patient	P001
`patient_gender`	string	Gender of the patientmale · female · other · unknown · optional	female
`patient_race_ethnicity`	string	Self-reported race or ethnicity of the patient10 ethnicities · optional	White
`patient_phone_number`	string	Primary phone number of the patientoptional	+1-415-555-1901
`patient_email`	string	Email address of the patientoptional	lisa.martin85@gmail.com
`patient_street_address`	string	Street address of the patientoptional	234 Pine St
`patient_city`	string	City of the patient's residenceoptional	San Francisco
`patient_state`	string	State or province of the patient's residenceoptional	CA
`patient_postal_code`	string	Postal or ZIP code of the patient's residenceoptional	94111
`patient_country`	string	Country of the patient's residence7 countries · optional	USA
`appointment_time`	string	Scheduled time of the appointment (24-hour format, e.g., '14:30')	09:30
`appointment_type`	string	Type of appointment (e.g., consultation, follow-up, check-up, procedure)4 types · optional	check-up
`department`	string	Department or specialty for the appointment (e.g., cardiology, general practice)optional	general practice
`provider_id`	string	Unique identifier for the healthcare provider assigned to the appointmentoptional	PR001
`provider_name`	string	Name of the healthcare provider assigned to the appointmentoptional	Dr. Michael Nguyen
`clinic_location`	string	Name or code of the clinic or facility locationoptional	SF Clinic North
`reminder_method`	string	Method used to send the reminder (e.g., SMS, email, phone call, none)sms · email · phone_call · none · other · optional	sms
`cancellation_reason`	string	Reason for cancellation (if applicable)optional	Travel emergency
`appointment_status`	string	Final status of the appointment (e.g., completed, cancelled, no-show, rescheduled)completed · cancelled · no-show · rescheduled · scheduled	completed
`insurance_provider`	string	Name of the patient's insurance provider (if available)optional	Aetna
`notes`	string	Additional notes or comments about the appointmentoptional	Colonoscopy screening.
Numbers 3 columns
`copay_amount`	float	Amount of copay required for the appointment0 or more · optional	35
`previous_no_show_count`	integer	Number of previous no-shows by the patient0 or more · optional	0
`previous_appointments_count`	integer	Total number of previous appointments for the patient0 or more · optional	6
Dates and times 6 columns
`patient_birth_date`	date	Date of birth of the patientoptional	1985-06-17
`appointment_date`	date	Scheduled date of the appointment	2024-08-05
`appointment_created_datetime`	datetime	Date and time when the appointment was created/scheduled	2024-07-20T14:12:00
`reminder_sent_datetime`	datetime	Date and time when the reminder was sentoptional	2024-08-03T15:30:00
`cancellation_datetime`	datetime	Date and time when the appointment was cancelled (if applicable)optional	2024-08-12T08:00:00
`check_in_datetime`	datetime	Date and time when the patient checked in (if applicable)optional	2024-08-05T09:24:00
True or false 5 columns
`reminder_sent`	boolean	Indicates if a reminder was sent prior to the appointmentoptional	true
`cancellation_flag`	boolean	Indicates if the appointment was cancelled by the patient or provider	false
`no_show_flag`	boolean	Indicates if the patient did not show up for the appointment	false
`check_in_flag`	boolean	Indicates if the patient checked in for the appointmentoptional	true
`chronic_conditions_flag`	boolean	Indicates if the patient has one or more chronic conditionsoptional	false

Use it for

A healthcare dashboard
The reminder_sent rate, previous_appointments_count by reminder_method and a breakdown of patient_race_ethnicity. Excel, Power BI or Tableau.
Why do the 28 phone_call rows have a mean previous_appointments_count of 21.3?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Appointments200
A10000016sms
A100000218phone_ca…
A10000077none
A software demo
Believable appointments with patient_id, patient_gender and patient_birth_date to fill a screen in front of a buyer.

This dataset200 rows36 columns

Yours1,000 rows36 columnspatient_street_address: UK only

blueprint · healthcare-appointment-no-show-patterns

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 36 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

Each patient has unique anonymized ID
Appointment reminders sent per policy
No-show flagged as binary outcome
Reason codes recorded for cancellations

Rows1,000 rows10,000 rows100,000 rows1,000,000 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-no-show-patterns

What should your data show?

No signup. No card.

Sample rows

What the 200 rows show

Columns

Use it for

A healthcare dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Healthcare

What should your data show?