Healthcare Clinic Wait Time Logs
This dataset provides detailed logs of patient wait times in healthcare clinics, capturing appointment types, time-of-day patterns, provider details, and patient satisfaction scores. It enables clinics to analyze workflow efficiency, identify bottlenecks, and improve patient experience by correlating wait times with satisfaction and operational factors.
Sample rows
preview · 8 of 200 rows · all 17 columns| log_idinteger | appointment_typestring | wait_time_minutesfloat | provider_namestring | clinic_idinteger | clinic_namestring | appointment_idinteger | patient_idinteger | scheduled_timedatetime | arrival_timedatetime | check_in_timedatetime | seen_by_provider_timedatetime | time_of_daystring | day_of_weekstring | provider_idinteger | notesstring | patient_satisfaction_scorefloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | checkup | 4 | Dr. Emily Park | 101 | Downtown Family Health | 10001 | 5001 | 2024-06-03T08:15:00 | 2024-06-03T08:05:00 | 2024-06-03T08:10:00 | 2024-06-03T08:14:00 | morning | Monday | 321 | Routine visit | 9.7 |
| 2 | checkup | 8 | Dr. Samuel Lin | 102 | Urban Pediatrics Center | 10002 | 5002 | 2024-06-05T09:00:00 | 2024-06-05T08:50:00 | 2024-06-05T08:55:00 | 2024-06-05T09:03:00 | morning | Wednesday | 322 | Patient arrived early | 9.3 |
| 3 | consultation | 19 | Dr. Linda Chavez | 103 | General Medical Clinic | 10003 | 5003 | 2024-06-04T14:30:00 | 2024-06-04T14:20:00 | 2024-06-04T14:23:00 | 2024-06-04T14:42:00 | afternoon | Tuesday | 323 | Provider busy with prior patient | 5.2 |
| 4 | consultation | 27 | Dr. Monica Patel | 104 | Women's Health Center | 10004 | 5004 | 2024-06-06T15:45:00 | 2024-06-06T15:34:00 | 2024-06-06T15:38:00 | 2024-06-06T16:05:00 | afternoon | Thursday | 324 | Interpreter needed | 4.8 |
| 5 | emergency | 2 | Dr. Aisha Brown | 105 | Regional Hospital | 10005 | 5005 | 2024-06-08T23:15:00 | 2024-06-08T23:12:00 | 2024-06-08T23:13:00 | 2024-06-08T23:15:00 | night | Saturday | 325 | Critical emergency | 10 |
| 6 | follow-up | 49 | Dr. Robert Kim | 106 | Med Center South | 10006 | 5006 | 2024-06-07T18:00:00 | 2024-06-07T17:54:00 | 2024-06-07T17:57:00 | 2024-06-07T18:46:00 | evening | Friday | 326 | Provider running behind | 2.9 |
| 7 | follow-up | 60 | Dr. Monica Patel | 104 | Women's Health Center | 10007 | 5007 | 2024-06-08T19:30:00 | 2024-06-08T19:25:00 | 2024-06-08T19:28:00 | 2024-06-08T20:28:00 | evening | Saturday | 324 | Heavy walk-in volume | 1.5 |
| 8 | emergency | 27 | Dr. Michael Evans | 107 | Urgent Care West | 10008 | 5008 | 2024-06-09T02:10:00 | 2024-06-09T02:08:00 | 2024-06-09T02:09:00 | 2024-06-09T02:36:00 | night | Sunday | 327 | Staff shortage | 2.1 |
| 9 | other | 17 | Dr. Laura Stein | 108 | Urban Family Health | 10009 | 5009 | 2024-06-04T07:40:00 | 2024-06-04T07:36:00 | 2024-06-04T07:38:00 | 2024-06-04T07:55:00 | morning | Tuesday | 328 | Interpreter needed | 5.9 |
| 10 | consultation | 33 | Dr. Linda Chavez | 103 | General Medical Clinic | 10010 | 5010 | 2024-06-07T16:10:00 | 2024-06-07T16:03:00 | 2024-06-07T16:05:00 | 2024-06-07T16:38:00 | afternoon | Friday | 323 | First visit | 4.1 |
| 11 | checkup | 5 | Dr. Samuel Lin | 102 | Urban Pediatrics Center | 10011 | 5011 | 2024-06-06T08:40:00 | 2024-06-06T08:39:00 | 2024-06-06T08:40:00 | 2024-06-06T08:45:00 | morning | Thursday | 322 | blank | 9.5 |
| 12 | checkup | 3 | Dr. Emily Park | 101 | Downtown Family Health | 10012 | 5012 | 2024-06-03T10:20:00 | 2024-06-03T10:10:00 | 2024-06-03T10:12:00 | 2024-06-03T10:15:00 | morning | Monday | 321 | Patient arrived early | 9.9 |
| 13 | follow-up | 48 | Dr. Robert Kim | 106 | Med Center South | 10013 | 5013 | 2024-06-08T18:45:00 | 2024-06-08T18:44:00 | 2024-06-08T18:45:00 | 2024-06-08T19:33:00 | evening | Saturday | 326 | Severe staff shortage | 0.9 |
| 14 | other | 32 | Dr. Laura Stein | 108 | Urban Family Health | 10014 | 5014 | 2024-06-08T17:00:00 | 2024-06-08T16:57:00 | 2024-06-08T16:58:00 | 2024-06-08T17:30:00 | evening | Saturday | 328 | First visit for new service | 4.7 |
| 15 | emergency | 1 | Dr. Michael Evans | 107 | Urgent Care West | 10015 | 5015 | 2024-06-07T22:35:00 | 2024-06-07T22:32:00 | 2024-06-07T22:33:00 | 2024-06-07T22:34:00 | night | Friday | 327 | Immediate attention | 9.8 |
| 16 | consultation | 16 | Dr. Linda Chavez | 103 | General Medical Clinic | 10016 | 5016 | 2024-06-05T13:30:00 | 2024-06-05T13:28:00 | 2024-06-05T13:29:00 | 2024-06-05T13:45:00 | afternoon | Wednesday | 323 | blank | 7.2 |
| 17 | emergency | 8 | Dr. Aisha Brown | 105 | Regional Hospital | 10017 | 5017 | 2024-06-09T04:15:00 | 2024-06-09T04:10:00 | 2024-06-09T04:12:00 | 2024-06-09T04:20:00 | night | Sunday | 325 | Staff shortage | 3.6 |
| 18 | checkup | 4 | Dr. Emily Park | 101 | Downtown Family Health | 10018 | 5018 | 2024-06-06T10:30:00 | 2024-06-06T10:27:00 | 2024-06-06T10:28:00 | 2024-06-06T10:32:00 | morning | Thursday | 321 | blank | 9.6 |
| 19 | checkup | 2 | Dr. Samuel Lin | 102 | Urban Pediatrics Center | 10019 | 5019 | 2024-06-05T11:15:00 | 2024-06-05T11:07:00 | 2024-06-05T11:08:00 | 2024-06-05T11:10:00 | morning | Wednesday | 322 | Routine visit | 9.8 |
| 20 | follow-up | 46 | Dr. Monica Patel | 104 | Women's Health Center | 10020 | 5020 | 2024-06-07T18:15:00 | 2024-06-07T18:13:00 | 2024-06-07T18:14:00 | 2024-06-07T19:00:00 | evening | Friday | 324 | Provider running behind | 1.8 |
What the 200 rows show
from the 200-row sampleFollow-up (appointment type) stands out: mean wait_
- 15median wait_
time_ minutes - 4time of days
- 7day of weeks
- 26clinic names
- 43noteses
- 7.0median patient_
satisfaction_ score
Median 15, from 1 to 89.
- string 6
- integer 5
- float 2
- datetime 4
Columns
17 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 6 columns | |||
clinic_name | string | Name of the healthcare clinic | Downtown Family Health |
appointment_type | string | Type of appointment (e.g., checkup, follow-up, emergency, consultation)checkup · follow-up · emergency · consultation · other | checkup |
time_of_day | string | Categorized time of day for the appointment (e.g., morning, afternoon, evening)morning · afternoon · evening · night | morning |
day_of_week | string | Day of the week for the appointment (e.g., Monday, Tuesday)7 values | Monday |
provider_name | string | Name of the healthcare provider | Dr. Emily Park |
notes | string | Additional notes or comments about the appointment or wait timeoptional | Routine visit |
| Numbers 7 columns | |||
log_id | integer | Unique identifier for each wait time log entryunique · 1 or more | 1 |
clinic_id | integer | Unique identifier for the clinic where the appointment occurred1 or more | 101 |
appointment_id | integer | Unique identifier for the patient appointmentunique · 1 or more | 10001 |
patient_id | integer | Unique identifier for the patient1 or more | 5001 |
wait_time_minutes | float | Total wait time in minutes from check-in to being seen by provider0 or more | 4 |
provider_id | integer | Unique identifier for the healthcare provider who saw the patient1 or more | 321 |
patient_satisfaction_score | float | Patient-reported satisfaction score for the appointment (0-10 scale)0 to 10 · optional | 9.7 |
| Dates and times 4 columns | |||
scheduled_time | datetime | Scheduled start time of the appointment | 2024-06-03T08:15:00 |
arrival_time | datetime | Actual arrival time of the patient at the clinic | 2024-06-03T08:05:00 |
check_in_time | datetime | Time when the patient checked in at the clinic reception | 2024-06-03T08:10:00 |
seen_by_provider_time | datetime | Time when the patient was first seen by the healthcare provider | 2024-06-03T08:14:00 |
Use it for
A healthcare dashboard
Wait_
time_ minutes by appointment_ type and a breakdown of provider_ name. Excel, Power BI or Tableau. Why do the 36 follow-up rows have a mean wait_
time_ minutes of 53.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Rows20014checkup28checkup319consulta…
A software demo
Believable rows with clinic_
id, clinic_ name and appointment_ id to fill a screen in front of a buyer.
This dataset200 rows17 columns
Yours1,000 rows17 columns
blueprint · healthcare-clinic-wait-time-logs
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 17 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
- Track wait times per appointment
- Segment by clinic location
- Flag excessive wait periods
- Include staff availability metrics
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-clinic-wait-time-logs