Hospital Staff Shift Schedules
This dataset provides detailed records of hospital staff shift schedules, including staff roles, departments, shift timings, and location information. It enables comprehensive workforce planning, shift optimization, and compliance tracking for healthcare operations. The dataset supports analysis of staffing patterns, overtime, and holiday coverage to improve hospital efficiency and patient care.
Sample rows
preview · 8 of 200 rows · all 19 columns| shift_idinteger | staff_rolestring | is_overtimeboolean | location_countrystring | staff_idinteger | staff_first_namestring | staff_last_namestring | departmentstring | shift_datedate | shift_start_timedatetime | shift_end_timedatetime | shift_typestring | is_holidayboolean | location_namestring | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Nurse | false | USA | 101 | Emily | Nguyen | Emergency | 2024-06-14 | 2024-06-14T06:00:00 | 2024-06-14T14:00:00 | Day | false | St. Mary Medical Center | 123 Main St | Los Angeles | CA | 90001 | blank |
| 2 | Doctor | true | UK | 102 | David | Mitchell | ICU | 2024-06-14 | 2024-06-14T20:00:00 | 2024-06-15T08:00:00 | Night | false | Royal Hospital | blank | London | blank | SW1A 1AA | Covering for sick colleague |
| 3 | Technician | false | Sweden | 103 | Sara | Johansson | Labs | 2024-06-15 | 2024-06-15T15:00:00 | 2024-06-15T23:00:00 | Evening | false | Karolinska Hospital | Solnavägen 1 | Stockholm | blank | 17176 | blank |
| 4 | Support Staff | false | Brazil | 104 | Lucas | Martins | Oncology | 2024-07-04 | 2024-07-04T08:00:00 | 2024-07-04T16:00:00 | Day | true | Hospital das Clínicas | Av. Dr. Enéas Carvalho | São Paulo | SP | 05403-000 | Independence Day coverage |
| 5 | Other | false | China | 105 | Mei | Zhang | Administration | 2024-08-15 | 2024-08-15T09:00:00 | 2024-08-15T10:00:00 | Other | true | Beijing Central Hospital | No. 1 Dongdan North St | Beijing | blank | 100005 | Short shift for setup |
| 6 | Nurse | false | USA | 106 | Ava | Smith | ICU | 2024-06-14 | 2024-06-14T07:00:00 | 2024-06-14T15:00:00 | Day | false | Mercy General Hospital | 456 Oak Ave | Sacramento | CA | 95819 | blank |
| 7 | Doctor | true | Greece | 107 | Nikos | Papadopoulos | Cardiology | 2024-08-15 | 2024-08-15T21:00:00 | 2024-08-16T07:00:00 | Night | true | Athens General Hospital | Leof. Vasilissis Sofias 45 | Athens | blank | 11528 | Holiday overnight shift |
| 8 | Technician | false | USA | 108 | Michael | Brown | Radiology | 2024-06-14 | 2024-06-14T16:00:00 | 2024-06-14T22:00:00 | Evening | false | Cedars-Sinai Medical Center | 8700 Beverly Blvd | Los Angeles | CA | 90048 | blank |
| 9 | Support Staff | false | France | 109 | Sophie | Dubois | Rehabilitation | 2024-06-15 | 2024-06-15T08:00:00 | 2024-06-15T16:00:00 | Day | false | Hopital Pitié-Salpêtrière | 47 Bd de l'Hôpital | Paris | blank | 75013 | blank |
| 10 | Other | false | Ireland | 110 | James | O'Connor | Psychiatry | 2024-06-16 | 2024-06-16T09:00:00 | 2024-06-16T17:00:00 | Day | false | St. Vincent's Hospital | Elm Park | Dublin | blank | D04 T6F4 | Staff meeting in afternoon |
| 11 | Nurse | false | USA | 111 | Chloe | Martin | Pediatrics | 2024-07-04 | 2024-07-04T07:00:00 | 2024-07-04T15:00:00 | Day | true | Johns Hopkins Hospital | 1800 Orleans St | Baltimore | MD | 21287 | Independence Day pediatric unit |
| 12 | Doctor | true | Canada | 112 | Ethan | Wang | Surgery | 2024-06-15 | 2024-06-15T19:00:00 | 2024-06-16T07:00:00 | Night | false | Mount Sinai Hospital | 600 University Ave | Toronto | ON | M5G 1X5 | Post-op monitoring required |
| 13 | Technician | false | Mexico | 113 | Maria | González | Labs | 2024-06-16 | 2024-06-16T14:00:00 | 2024-06-16T21:00:00 | Evening | false | Centro Médico ABC | Sur 136 No. 116 | Mexico City | CDMX | 01120 | Blood panel rush |
| 14 | Support Staff | false | Canada | 114 | Claire | Lambert | Administration | 2024-06-14 | 2024-06-14T10:00:00 | 2024-06-14T14:00:00 | Other | false | Toronto General Hospital | 200 Elizabeth St | Toronto | ON | M5G 2C4 | blank |
| 15 | Nurse | false | USA | 115 | John | Lee | Maternity | 2024-06-16 | 2024-06-16T08:00:00 | 2024-06-16T16:00:00 | Day | false | NY Presbyterian Hospital | 525 E 68th St | New York | NY | 10065 | blank |
| 16 | Doctor | true | Poland | 116 | Jonas | Nowak | Neurology | 2024-06-15 | 2024-06-15T22:00:00 | 2024-06-16T07:00:00 | Night | false | Szpital Uniwersytecki | ul. Kopernika 36 | Kraków | blank | 31-501 | blank |
| 17 | Technician | false | Japan | 117 | Haruto | Tanaka | Radiology | 2024-06-14 | 2024-06-14T17:00:00 | 2024-06-14T23:00:00 | Evening | false | Tokyo Medical Center | 2-5-1 Higashigaoka | Tokyo | blank | 152-8902 | blank |
| 18 | Support Staff | false | Israel | 118 | Noah | Katz | Geriatrics | 2024-06-16 | 2024-06-16T08:00:00 | 2024-06-16T16:00:00 | Day | false | Hadassah Medical Center | Kiryat Hadassah | Jerusalem | blank | 91120 | blank |
| 19 | Other | false | Italy | 119 | Isabella | Rossi | Oncology | 2024-06-14 | 2024-06-14T12:00:00 | 2024-06-14T12:15:00 | Other | false | Policlinico Umberto I | Viale del Policlinico 155 | Rome | blank | 00161 | Edge: 15-min consult |
| 20 | Nurse | false | USA | 120 | Olivia | Jones | Neonatology | 2024-06-15 | 2024-06-15T06:30:00 | 2024-06-15T15:00:00 | Day | false | Children's Hospital of Philadelphia | 3401 Civic Center Blvd | Philadelphia | PA | 19104 | blank |
What the 200 rows show
from the 200-row sampleDoctor (staff role) stands out: 42 of its 42 rows have is_
- 25%is_
overtime = true - 4shift types
- 15departments
- string 12
- integer 2
- date 1
- datetime 2
- boolean 2
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
staff_first_name | string | First name of the staff member | Emily |
staff_last_name | string | Last name of the staff member | Nguyen |
staff_role | string | Role or job title of the staff member (e.g., Nurse, Doctor, Technician)Doctor · Nurse · Technician · Support Staff · Other | Nurse |
department | string | Hospital department where the shift takes place (e.g., Emergency, ICU, Pediatrics) | Emergency |
shift_type | string | Type of shift (e.g., Day, Night, Evening, On-call)Day · Night · Evening · On-call · Other | Day |
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 | 123 Main 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 or ZIP code for the hospital or facilityoptional | 90001 |
location_country | string | Country where the hospital or facility is locatedoptional | USA |
notes | string | Additional notes or comments about the shift (e.g., special instructions, coverage details)optional | Short shift for setup |
| Numbers 2 columns | |||
shift_id | integer | Unique identifier for each scheduled shiftunique | 1 |
staff_id | integer | Unique identifier for the staff member assigned to the shift | 101 |
| Dates and times 3 columns | |||
shift_date | date | Date on which the shift occurs | 2024-06-14 |
shift_start_time | datetime | Start date and time of the shift | 2024-06-14T06:00:00 |
shift_end_time | datetime | End date and time of the shift | 2024-06-14T14:00:00 |
| True or false 2 columns | |||
is_overtime | boolean | Indicates if the shift is considered overtime for the staff member | false |
is_holiday | boolean | Indicates if the shift falls on a recognized holiday | false |
Use it for
A healthcare dashboard
The is_
overtime rate, is_ overtime by staff_ role and a breakdown of location_ country. Excel, Power BI or Tableau. Why do 49 of 200 rows have is_
overtime = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Rows2001Nurse2Doctor7Doctor
A software demo
Believable rows with staff_
id, staff_ first_ name and staff_ last_ name to fill a screen in front of a buyer.
This dataset200 rows19 columns
Yours1,000 rows19 columnslocation_name: UK only
blueprint · hospital-staff-shift-schedules
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 19 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 shift linked to staff ID, role, department.
- Shift duration and type (day/night) provided.
- Leave and swap events annotated.
- Overtime flagged.
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-schedules