Healthcare Provider Scheduling Conflicts
This dataset provides detailed records of healthcare provider shift schedules, including built-in scheduling conflicts and overtime indicators. It enables analysis and optimization of staff allocation, identification of resource bottlenecks, and improvement of hospital workforce management. The dataset is ideal for operational analytics, compliance monitoring, and predictive scheduling in healthcare environments.
Sample rows
preview · 8 of 200 rows · all 20 columns| schedule_idstring | provider_rolestring | actual_hours_workedfloat | is_overtimeboolean | location_countrystring | provider_idstring | provider_namestring | departmentstring | shift_datedate | shift_start_timedatetime | shift_end_timedatetime | scheduled_hoursfloat | overtime_hoursfloat | conflict_typestring | location_namestring | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | conflict_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SCH-00001 | nurse | 8 | false | USA | PROV-001 | Nurse Amanda Liu | ICU | 2024-02-29 | 2024-02-29T07:00:00 | 2024-02-29T15:00:00 | 8 | 0 | none | St. Mary Medical Center | 1510 Elm St | Los Angeles | CA | 90017 | blank |
| SCH-00002 | physician | 13 | true | Italy | PROV-002 | Dr. Victor Romano | Surgery | 2024-03-01 | 2024-03-01T08:00:00 | 2024-03-01T20:00:00 | 12 | 1 | insufficient-rest | Milano General Hospital | Via Roma 22 | Milan | Lombardy | 20121 | Shift scheduled after only 5 hours rest from previous on-call rotation. |
| SCH-00003 | therapist | 4 | false | Germany | PROV-003 | Emily Sanchez | Physical Therapy | 2024-03-02 | 2024-03-02T10:00:00 | 2024-03-02T14:00:00 | 4 | 0 | none | Berlin Health Center | Friedrichstrasse 75 | Berlin | Berlin | 10117 | blank |
| SCH-00004 | technician | 4.5 | true | Egypt | PROV-004 | Technician Omar Said | Radiology | 2024-03-02 | 2024-03-02T15:00:00 | 2024-03-02T19:00:00 | 4 | 0.5 | overlap | Cairo Regional Hospital | 23 Giza St | Cairo | Cairo | 11511 | Shift overlaps with another assigned department by 30 minutes. |
| SCH-00005 | physician | 8 | false | India | PROV-005 | Dr. Ava Singh | Cardiology | 2024-03-03 | 2024-03-03T15:00:00 | 2024-03-03T23:00:00 | 8 | 0 | none | Apollo Heart Institute | Plot 12, Main Road | Chennai | Tamil Nadu | 600006 | blank |
| SCH-00006 | nurse | 12.25 | true | USA | PROV-006 | Nurse John Price | Oncology | 2024-03-03 | 2024-03-03T19:00:00 | 2024-03-04T07:00:00 | 12 | 0.25 | none | Mercy Hospital North | 2812 Maple Ave | Chicago | IL | 60616 | blank |
| SCH-00007 | therapist | 2 | false | France | PROV-007 | Therapist Clara Dubois | Occupational Therapy | 2024-03-04 | 2024-03-04T09:00:00 | 2024-03-04T11:00:00 | 2 | 0 | none | Paris Community Clinic | 12 Rue de Rivoli | Paris | Île-de-France | 75004 | blank |
| SCH-00008 | technician | 8 | false | UK | PROV-008 | James O’Neill | Laboratory | 2024-03-04 | 2024-03-04T23:00:00 | 2024-03-05T07:00:00 | 8 | 0 | double-booked | Royal London Hospital | Whitechapel Rd | London | England | E1 1BB | Provider scheduled in Laboratory and Pathology at the same time. |
| SCH-00009 | physician | 8.5 | true | Spain | PROV-009 | Dr. Sofia Mendez | Emergency | 2024-03-05 | 2024-03-05T08:00:00 | 2024-03-05T16:00:00 | 8 | 0.5 | none | San Juan Medical Center | Av. de la Constitución 100 | Madrid | Madrid | 28014 | blank |
| SCH-00010 | nurse | 8 | false | Canada | PROV-010 | Nurse Julia Kim | Pediatrics | 2024-03-05 | 2024-03-05T07:00:00 | 2024-03-05T15:00:00 | 8 | 0 | none | Toronto Children's Hospital | 345 Queen St W | Toronto | ON | M5V 2A4 | blank |
| SCH-00011 | technician | 3.5 | false | Russia | PROV-011 | Technician Petra Ivanov | Pathology | 2024-03-06 | 2024-03-06T20:00:00 | 2024-03-07T00:00:00 | 4 | 0 | none | Moscow Diagnostic Lab | Kuznetsky Most 19 | Moscow | Moscow | 101000 | blank |
| SCH-00012 | physician | 8 | false | USA | PROV-012 | Dr. Henry Smith | Outpatient | 2024-03-06 | 2024-03-06T14:00:00 | 2024-03-06T22:00:00 | 8 | 0 | none | Mount Sinai Outpatient Center | 320 5th Ave | New York | NY | 10001 | blank |
| SCH-00013 | therapist | 4 | false | Brazil | PROV-013 | Therapist Laura Fraga | Psychiatry | 2024-03-07 | 2024-03-07T12:00:00 | 2024-03-07T16:00:00 | 4 | 0 | none | Hospital das Clínicas | Av. Dr. Enéas Carvalho de Aguiar | São Paulo | SP | 05403-000 | blank |
| SCH-00014 | nurse | 12 | false | Canada | PROV-014 | Nurse Michael Chu | Geriatrics | 2024-03-07 | 2024-03-07T19:00:00 | 2024-03-08T07:00:00 | 12 | 0 | insufficient-rest | Golden Oak Senior Facility | 890 Pine Ridge Rd | Vancouver | BC | V6Z 1Y6 | Provider assigned less than 8 hours off between consecutive night shifts. |
| SCH-00015 | physician | 8 | false | China | PROV-015 | Dr. Evelyn Lee | ER | 2024-03-08 | 2024-03-08T23:00:00 | 2024-03-09T07:00:00 | 8 | 0 | none | Shanghai Central Hospital | 123 Nanjing Rd | Shanghai | Shanghai | 200003 | blank |
| SCH-00016 | technician | 6 | false | Germany | PROV-016 | Technician Lucas Meyer | Dialysis | 2024-03-08 | 2024-03-08T06:00:00 | 2024-03-08T12:00:00 | 6 | 0 | none | Frankfurt Kidney Center | Mainzer Landstr. 100 | Frankfurt | Hesse | 60329 | blank |
| SCH-00017 | therapist | 4 | false | UAE | PROV-017 | Therapist Mona Khalid | Physical Therapy | 2024-03-09 | 2024-03-09T09:00:00 | 2024-03-09T13:00:00 | 4 | 0 | overlap | Al Noor Medical Center | 156 Sheikh Zayed Rd | Dubai | Dubai | 00000 | Shift overlaps with another therapy assignment by 1 hour. |
| SCH-00018 | nurse | 12 | false | USA | PROV-018 | Nurse Carla Evans | Maternity | 2024-03-09 | 2024-03-09T07:00:00 | 2024-03-09T19:00:00 | 12 | 0 | none | St. Luke's Women's Hospital | 1010 Walnut St | Kansas City | MO | 64106 | blank |
| SCH-00019 | technician | 4 | false | Serbia | PROV-019 | Technician Ivan Novak | Radiology | 2024-03-10 | 2024-03-10T14:00:00 | 2024-03-10T18:00:00 | 4 | 0 | none | Belgrade Imaging Center | Knez Mihailova 32 | Belgrade | Central Serbia | 11000 | blank |
| SCH-00020 | physician | 8 | false | Egypt | PROV-020 | Dr. Samira Farouk | Cardiology | 2024-03-10 | 2024-03-10T08:00:00 | 2024-03-10T16:00:00 | 8 | 0 | none | As-Salam Heart Hospital | 41 Ramses St | Cairo | Cairo | 11519 | blank |
What the 200 rows show
from the 200-row sampleTherapist (provider role) stands out: mean actual_
- 23%is_
overtime = true - 8.0median actual_
hours_ worked - 5conflict types
- 18departments
- 8.0median scheduled_
hours - 0.0median overtime_
hours
Median 8.0, from 1.5 to 13.0.
- string 13
- float 3
- date 1
- datetime 2
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
schedule_id | string | Unique identifier for each provider shift schedule entryunique | SCH-00001 |
provider_id | string | Unique identifier for the healthcare provider | PROV-001 |
provider_name | string | Full name of the healthcare provider | Nurse Amanda Liu |
provider_role | string | Role or title of the provider (e.g., nurse, physician, technician)physician · nurse · technician · therapist · other | nurse |
department | string | Department or unit where the provider is scheduled (e.g., ER, ICU, Pediatrics) | ICU |
conflict_type | string | Type of scheduling conflict (e.g., overlap, double-booked, insufficient rest, none)overlap · double-booked · insufficient-rest · none · other | none |
conflict_description | string | Detailed description of the scheduling conflict, if anyoptional | Shift scheduled after onl… |
location_name | string | Name of the hospital or facility where the shift is scheduled | St. Mary Medical Center |
location_street_address | string | Street address of the hospital or facilityoptional | 1510 Elm St |
location_city | string | City where the hospital or facility is locatedoptional | Los Angeles |
location_state | string | State or province where the hospital or facility is locatedoptional | CA |
location_postal_code | string | Postal code of the hospital or facilityoptional | 90017 |
location_country | string | Country where the hospital or facility is locatedoptional | USA |
| Numbers 3 columns | |||
scheduled_hours | float | Total number of hours scheduled for this shift0 or more | 8 |
actual_hours_worked | float | Actual number of hours worked during the shift0 or more · optional | 8 |
overtime_hours | float | Number of overtime hours worked during the shift0 or more · optional | 0 |
| Dates and times 3 columns | |||
shift_date | date | Date of the scheduled shift | 2024-02-29 |
shift_start_time | datetime | Scheduled start time of the shift | 2024-02-29T07:00:00 |
shift_end_time | datetime | Scheduled end time of the shift | 2024-02-29T15:00:00 |
| True or false 1 column | |||
is_overtime | boolean | Indicates if the shift includes overtime hours | false |
Use it for
A healthcare dashboard
The is_
overtime rate, actual_ hours_ worked by provider_ role and a breakdown of location_ country. Excel, Power BI or Tableau. Why do the 19 therapist rows have a mean actual_
hours_ worked of 3.4? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Schedules200SCH-000018nurseSCH-0000213physicianSCH-000044.5technici…
A software demo
Believable schedules with provider_
id, provider_ name and provider_ role to fill a screen in front of a buyer.
This dataset200 rows20 columns
Yours1,000 rows20 columnslocation_name: UK only
blueprint · healthcare-provider-scheduling-conflicts
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 20 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 provider covers specific specialties
- Double-bookings and cancellations simulated
- Maximum hours and overtime rules enforced
- Department assignments vary by week
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-provider-scheduling-conflicts