Hospital Staff Shift Scheduling
This dataset provides detailed, structured records of hospital staff shift schedules, including assignments, shift swaps, absences, and overtime metrics. It enables comprehensive workforce analytics, compliance monitoring, and operational optimization for healthcare organizations seeking to improve staff management and patient care.
Sample rows
preview · 8 of 200 rows · all 17 columns| staff_idstring | shift_typestring | overtime_hoursfloat | swap_requestedboolean | assigned_bystring | staff_namestring | rolestring | departmentstring | shift_idstring | shift_datedate | shift_start_timedatetime | shift_end_timedatetime | swap_approvedboolean | swap_with_staff_idstring | absence_typestring | absence_approvedboolean | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| D1001 | day | 0 | false | scheduler01 | Dr. Emily M. King | doctor | Cardiology | S1001 | 2024-05-01 | 2024-05-01T06:00:00 | 2024-05-01T14:00:00 | blank | blank | none | blank | blank |
| N5014 | night | 2 | false | scheduler02 | Lauren Kim | nurse | ICU | S1002 | 2024-05-01 | 2024-05-01T19:00:00 | 2024-05-02T07:00:00 | blank | blank | none | blank | Stayed late due to emergency admission |
| T0231 | day | 0 | false | scheduler03 | Andres Patel | technician | Radiology | S1003 | 2024-05-02 | 2024-05-02T08:00:00 | 2024-05-02T16:00:00 | blank | blank | none | blank | blank |
| N3055 | evening | 0 | false | scheduler01 | Monica Li | nurse | Pediatrics | S1004 | 2024-05-02 | 2024-05-02T12:00:00 | 2024-05-02T20:00:00 | blank | blank | none | blank | blank |
| A1120 | day | 0 | false | system_batch | Jesse Carter | admin | Administration | S1005 | 2024-05-01 | 2024-05-01T08:30:00 | 2024-05-01T16:30:00 | blank | blank | none | blank | blank |
| P0035 | day | 0 | false | scheduler04 | Samantha Ortega | pharmacist | Pharmacy | S1006 | 2024-05-01 | 2024-05-01T10:00:00 | 2024-05-01T18:00:00 | blank | blank | personal | false | Requested personal leave, not approved |
| TH3012 | day | 0 | false | rehab_mgr | Rosa Nguyen | therapist | Rehabilitation | S1007 | 2024-05-02 | 2024-05-02T09:00:00 | 2024-05-02T13:00:00 | blank | blank | none | blank | blank |
| D1002 | day | 1.5 | false | scheduler01 | Alexander J. Singh | doctor | ER | S1008 | 2024-05-03 | 2024-05-03T07:00:00 | 2024-05-03T17:00:00 | blank | blank | none | blank | Covered late trauma case |
| T0877 | evening | 0 | false | scheduler05 | Brenda Foster | technician | Lab | S1009 | 2024-05-03 | 2024-05-03T12:00:00 | 2024-05-03T20:00:00 | blank | blank | none | blank | blank |
| N1012 | night | 0 | true | autogen | Chad E. Young | nurse | Emergency | S1010 | 2024-05-01 | 2024-05-01T19:30:00 | 2024-05-02T07:30:00 | false | N7001 | none | blank | Requested swap (denied) for family emergency |
| O1150 | on-call | 0 | false | blank | Morgan Blume | other | Morgue | S1011 | 2024-05-04 | 2024-05-04T14:00:00 | 2024-05-04T17:00:00 | blank | blank | none | blank | Late assignment |
| T0911 | night | 0 | false | scheduler03 | Jamal Evans | technician | Sleep Lab | S1012 | 2024-05-02 | 2024-05-02T20:00:00 | 2024-05-03T06:00:00 | blank | blank | sick | true | Called in sick, coverage arranged |
| P0094 | day | 0 | false | autogen | Lina Mendez | pharmacist | Pharmacy | S1013 | 2024-05-04 | 2024-05-04T11:00:00 | 2024-05-04T15:00:00 | blank | blank | none | blank | blank |
| A1182 | day | 0 | false | system_batch | Deepti Rao | admin | IT | S1014 | 2024-05-05 | 2024-05-05T09:00:00 | 2024-05-05T17:00:00 | blank | blank | vacation | true | On approved vacation |
| TH2077 | evening | 0 | false | psy_unit | Blake Jordan | therapist | Psychiatry | S1015 | 2024-05-05 | 2024-05-05T13:00:00 | 2024-05-05T18:00:00 | blank | blank | none | blank | blank |
| D1003 | night | 3 | false | scheduler02 | Rajiv Patel | doctor | ICU | S1016 | 2024-05-05 | 2024-05-05T19:00:00 | 2024-05-06T07:00:00 | blank | blank | none | blank | Stayed late for code blue |
| N7001 | night | 0 | true | scheduler02 | Ava McCarthy | nurse | ER | S1017 | 2024-05-03 | 2024-05-03T19:00:00 | 2024-05-04T07:00:00 | true | N1012 | none | blank | Swap with N1012 (approved) |
| T0901 | evening | 0.5 | false | scheduler05 | Derek White | technician | Lab | S1018 | 2024-05-06 | 2024-05-06T14:00:00 | 2024-05-06T22:00:00 | blank | blank | none | blank | Instrument calibration ran late |
| P0101 | day | 0 | false | scheduler04 | Andre Green | pharmacist | Pharmacy | S1019 | 2024-05-06 | 2024-05-06T12:00:00 | 2024-05-06T20:00:00 | blank | blank | none | blank | blank |
| D1004 | day | 0 | false | experimental_bot | X Æ A-12 Musk | doctor | Research | S1020 | 2024-05-06 | 2024-05-06T08:00:00 | 2024-05-06T08:00:00 | blank | blank | unexcused | false | Zero-length shift; marked as no-show |
What the 200 rows show
from the 200-row sampleNight (shift type) stands out: mean overtime_
- 9%swap_
requested = true - 0.0median overtime_
hours - 5absence types
- 7roles
- 15departments
Median 0.0, from 0.0 to 3.8.
- string 10
- float 1
- date 1
- datetime 2
- boolean 3
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
staff_id | string | Unique identifier for each medical staff member | D1001 |
staff_name | string | Full name of the staff member | Dr. Emily M. King |
role | string | Professional role of the staff member (e.g., nurse, doctor, technician)7 values | doctor |
department | string | Department or unit where the staff member is assigned (e.g., ER, ICU, Pediatrics) | Cardiology |
shift_id | string | Unique identifier for each shift assignmentunique | S1001 |
shift_type | string | Type of shift (e.g., day, night, evening, on-call)day · night · evening · on-call | day |
assigned_by | string | Identifier or name of the scheduler or system that assigned the shiftoptional | scheduler01 |
swap_with_staff_id | string | Staff ID of the person with whom the shift was swapped, if applicableoptional | N7001 |
absence_type | string | Type of absence (e.g., sick, vacation, personal, none)sick · vacation · personal · unexcused · none | none |
notes | string | Additional notes or comments related to the shift or staff assignmentoptional | Covered late trauma case |
| Numbers 1 column | |||
overtime_hours | float | Number of overtime hours worked during this shift (0 if none)0 or more | 0 |
| Dates and times 3 columns | |||
shift_date | date | Date of the scheduled shift | 2024-05-01 |
shift_start_time | datetime | Start time of the scheduled shift | 2024-05-01T06:00:00 |
shift_end_time | datetime | End time of the scheduled shift | 2024-05-01T14:00:00 |
| True or false 3 columns | |||
swap_requested | boolean | Indicates if a shift swap was requested for this shift | false |
swap_approved | boolean | Indicates if the shift swap was approvedoptional | false |
absence_approved | boolean | Indicates if the absence was officially approvedoptional | false |
Use it for
A healthcare dashboard
The swap_
requested rate, overtime_ hours by shift_ type and a breakdown of assigned_ by. Excel, Power BI or Tableau. Why do the 40 night rows have a mean overtime_
hours of 1.0? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Staffs200D10010dayN10120nightN70010night
A software demo
Believable staffs with staff_
name, role and department to fill a screen in front of a buyer.
This dataset200 rows17 columns
Yours1,000 rows17 columns
blueprint · hospital-staff-shift-scheduling
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
- Assignments include staff ID, role, and shift
- Track absences, swaps, and overtime per staff
- Compliance with rest period rules enforced
- Coverage ensured for all departments
- Shifts labeled as day/night/holiday
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
- hospital-staff-shift-scheduling