Healthcare
21 columns
200 rows
8 formats

Primary Care Appointment Scheduling

This dataset provides detailed records of appointment requests and scheduling outcomes for primary care clinics, including patient demographics, preferences, wait times, and location details. It enables healthcare organizations to analyze scheduling efficiency, identify bottlenecks, and optimize appointment allocation to reduce patient wait times and improve resource utilization.

last updated 20 Aug 2025
by GoMask

The brief that made it

Optimizing clinic schedules to reduce patient wait times

Sample rows

preview · 8 of 200 rows · all 21 columns

appointment_request_idstring	appointment_typestring	patient_ageinteger	appointment_location_statestring	patient_idstring	clinic_idstring	provider_idstring	request_datetimedatetime	preferred_datedate	preferred_timestring	scheduled_datetimedatetime	scheduled_provider_idstring	scheduling_statusstring	wait_time_minutesinteger	appointment_location_streetstring	appointment_location_citystring	appointment_location_postal_codestring	appointment_location_countrystring	patient_genderstring	cancellation_reasonstring	notesstring
AR0001	routine	34	IL	P1001	C01	PR320	2024-03-24T09:05:00	2024-03-28	morning	2024-03-28T10:00:00	PR320	scheduled	5760	2612 N Clark St	Chicago	60614	USA	female	blank	Annual wellness check, first appointment at this clinic.
AR0002	urgent	12	CA	P1002	C02	PR215	2024-03-22T13:30:00	2024-03-24	afternoon	2024-03-22T15:00:00	PR215	scheduled	90	1457 Mission St	San Francisco	94103	USA	male	blank	Parent requested urgent appointment after minor injury.
AR0003	other	47	NY	P1003	C03	blank	2024-03-25T10:45:00	blank	blank	blank	blank	pending	blank	888 8th Ave	New York	10019	USA	female	blank	Request for travel immunizations, pending insurance approval.
AR0004	annual	62	MA	P1004	C04	PR308	2024-03-21T08:15:00	2024-03-27	morning	2024-03-27T09:00:00	PR308	scheduled	8645	262 Boylston St	Boston	02116	USA	male	blank	Annual physical exam, senior patient.
AR0005	follow-up	54	IL	P1005	C01	PR320	2024-03-30T15:20:00	2024-04-02	afternoon	2024-04-02T13:00:00	PR320	scheduled	4300	2612 N Clark St	Chicago	60614	USA	female	blank	Post-operative follow-up after outpatient surgery.
AR0006	urgent	7	FL	P1006	C05	blank	2024-02-20T14:00:00	2024-02-25	evening	blank	blank	pending	blank	2295 Biscayne Blvd	Miami	33137	USA	female	blank	High fever reported, awaiting triage assignment.
AR0007	routine	29	WA	P1007	C06	PR451	2024-03-19T11:00:00	2024-03-20	morning	2024-03-20T09:30:00	PR453	scheduled	1350	401 Pine St	Seattle	98101	USA	male	blank	Routine checkup; provider reassigned due to availability.
AR0008	other	41	CA	P1008	C07	blank	2024-03-18T14:30:00	blank	evening	blank	blank	denied	blank	700 S Flower St	Los Angeles	90017	USA	prefer_not_to_say	blank	Request denied due to coverage restrictions.
AR0009	follow-up	63	TX	P1009	C08	PR498	2024-03-17T08:45:00	2024-03-23	morning	2024-03-23T09:30:00	PR498	scheduled	8645	1001 E Lamar Blvd	Arlington	76011	USA	male	blank	Follow-up for diabetes management.
AR0010	annual	56	NY	P1010	C09	blank	2024-03-11T16:15:00	blank	blank	blank	blank	pending	blank	1200 Elmwood Ave	Buffalo	14222	USA	female	blank	Request for annual physical, awaiting confirmation.
AR0011	routine	36	AZ	P1011	C10	PR221	2024-01-15T09:30:00	2024-01-20	morning	2024-01-20T11:00:00	PR221	scheduled	7260	7636 W Thunderbird Rd	Peoria	85381	USA	female	blank	Routine appointment, patient has hypertension.
AR0012	follow-up	52	AZ	P1012	C11	PR230	2024-03-05T13:05:00	2024-03-08	afternoon	2024-03-08T14:00:00	PR230	scheduled	4265	1717 W Broadway Rd	Mesa	85202	USA	male	blank	Follow-up for lab results and medication review.
AR0013	routine	28	TX	P1013	C12	PR332	2024-02-01T08:00:00	2024-02-03	morning	2024-02-03T09:00:00	PR332	scheduled	2880	515 Congress Ave	Austin	78701	USA	female	blank	Routine visit, recently moved to area.
AR0014	urgent	17	CA	P1014	C02	PR215	2024-03-12T15:10:00	2024-03-15	afternoon	2024-03-15T15:30:00	PR215	scheduled	4410	1457 Mission St	San Francisco	94103	USA	male	blank	Urgent check for suspected strep throat.
AR0015	other	3	MD	P1015	C13	blank	2024-03-09T12:00:00	blank	blank	blank	blank	denied	blank	650 S Exeter St	Baltimore	21202	USA	other	blank	Request denied: age criteria not met for requested service.
AR0016	annual	76	AZ	P1016	C14	PR322	2024-03-06T11:45:00	2024-03-09	morning	2024-03-09T10:00:00	PR322	scheduled	4245	2301 N Central Ave	Phoenix	85004	USA	male	blank	Annual exam, senior patient, transportation arranged.
AR0017	other	45	CA	P1017	C15	blank	2024-02-28T14:20:00	blank	evening	blank	blank	cancelled	blank	320 S Market St	San Jose	95113	USA	female	Patient cancelled due to unexpected travel.	Appointment request withdrawn by patient.
AR0018	routine	31	NC	P1018	C16	PR329	2024-02-26T10:00:00	2024-02-27	morning	2024-02-27T09:30:00	PR329	scheduled	1410	401 S Tryon St	Charlotte	28202	USA	female	blank	Routine visit; patient requested earliest available slot.
AR0019	follow-up	57	IL	P1019	C17	blank	2024-03-04T13:50:00	2024-03-12	afternoon	blank	blank	pending	blank	222 E Erie St	Chicago	60611	USA	male	blank	Follow-up for hypertension, waiting for provider assignment.
AR0020	follow-up	66	IL	P1020	C18	PR249	2024-02-15T09:30:00	2024-02-22	morning	2024-02-22T10:00:00	PR249	scheduled	10050	4700 S Western Ave	Chicago	60609	USA	female	blank	Follow-up for medication adjustment, senior patient.

What the 200 rows show

from the 200-row sample

Urgent (appointment type) stands out: mean patient_age is 16.8, against 45.6 for the rest.

41median patient_age
3preferred times
4patient genders
6scheduling statuses
50clinics
53appointment location cities

Mean patient_age by appointment_type200 rows

patient_age200 rows, in bands of 10

Median 41, from 2 to 99.

appointment_location_state200 rows · top 10 of 28 values

TX29
CA24
IL21
FL17
AZ15
NY11
WA11
PA10
MA9
MO8

21 columns by typefrom the column list below

string 16
integer 2
date 1
datetime 2

Columns

21 columns in three groups

blueprint · 21 columns
column	type	description	example
Text 16 columns
`appointment_request_id`	string	Unique identifier for each appointment requestunique	AR0001
`patient_id`	string	Unique identifier for the patient requesting the appointment	P1001
`clinic_id`	string	Unique identifier for the primary care clinic	C01
`provider_id`	string	Unique identifier for the healthcare provider assigned to the appointmentoptional	PR320
`preferred_time`	string	Patient's preferred time for the appointment (e.g., 'morning', 'afternoon', 'evening', or specific time)morning · afternoon · evening · optional	morning
`appointment_type`	string	Type of appointment requested (e.g., 'routine', 'urgent', 'follow-up', 'annual')routine · urgent · follow-up · annual · other	routine
`scheduled_provider_id`	string	Unique identifier for the provider with whom the appointment was scheduledoptional	PR320
`scheduling_status`	string	Outcome of the appointment request (e.g., 'scheduled', 'cancelled', 'pending', 'no-show', 'rescheduled', 'denied')6 values	scheduled
`cancellation_reason`	string	Reason for cancellation if the appointment was cancelledoptional	Patient cancelled due to …
`appointment_location_street`	string	Street address of the appointment locationoptional	2612 N Clark St
`appointment_location_city`	string	City of the appointment locationoptional	Chicago
`appointment_location_state`	string	State of the appointment locationoptional	IL
`appointment_location_postal_code`	string	Postal code of the appointment locationoptional	60614
`appointment_location_country`	string	Country of the appointment locationoptional	USA
`patient_gender`	string	Gender of the patientmale · female · other · prefer_not_to_say · optional	female
`notes`	string	Additional notes or comments related to the appointment requestoptional	Annual wellness check, fi…
Numbers 2 columns
`wait_time_minutes`	integer	Number of minutes between request and scheduled appointment (calculated)0 or more · optional	5760
`patient_age`	integer	Age of the patient at the time of request0 or more · optional	34
Dates and times 3 columns
`request_datetime`	datetime	Timestamp when the appointment request was made	2024-03-24T09:05:00
`preferred_date`	date	Patient's preferred date for the appointmentoptional	2024-03-28
`scheduled_datetime`	datetime	Date and time when the appointment was scheduledoptional	2024-03-28T10:00:00

Use it for

A healthcare dashboard
Patient_age by appointment_type and a breakdown of appointment_location_state. Excel, Power BI or Tableau.
Why do the 28 urgent rows have a mean patient_age of 16.8?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Appointment requests200
AR000134routine
AR000212urgent
AR000347other
A software demo
Believable appointment requests with patient_id, clinic_id and provider_id to fill a screen in front of a buyer.

This dataset200 rows21 columns

Yours1,000 rows21 columnsappointment_location_street: UK only

blueprint · primary-care-appointment-scheduling

Behind this dataset

Same schema. As many rows as you need.

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

Request type classified (routine/emergency)
Appointment outcome logged
Lead time before appointment recorded
Patient no-show flagged

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: primary-care-appointment-scheduling

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?