Healthcare Workforce Staffing Metrics
This dataset provides detailed, shift-level metrics on healthcare provider staffing, including scheduled and actual staff counts, overtime, shift coverage, and use of agency personnel across facilities and departments. It enables comprehensive analysis of workforce efficiency, identification of staffing gaps, and supports data-driven improvements in patient care and operational management.
Sample rows
preview · 8 of 200 rows · all 15 columns| staffing_record_idstring | provider_rolestring | scheduled_staff_countinteger | facility_namestring | facility_idstring | department_idstring | department_namestring | shift_datedate | shift_typestring | actual_staff_countinteger | overtime_hoursfloat | shift_coverage_percentfloat | absent_staff_countinteger | agency_staff_countinteger | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SR-0001 | Nurse | 7 | Central Valley Medical Center | FAC-001 | DEPT-001-01 | Emergency | 2024-01-03 | Day | 7 | 0 | 100 | 0 | 0 | blank |
| SR-0002 | Physician | 4 | Lakeside Regional Hospital | FAC-002 | DEPT-002-03 | Operating Room | 2024-02-10 | Day | 4 | 0 | 100 | 0 | 0 | blank |
| SR-0003 | Technician | 2 | Mountainview Health Campus | FAC-003 | DEPT-003-02 | ICU | 2024-03-05 | Night | 1 | 2.5 | 50 | 1 | 1 | Staff illness; coverage gap resolved by agency tech |
| SR-0004 | Nurse | 5 | Central Valley Medical Center | FAC-001 | DEPT-001-02 | Pediatrics | 2024-01-12 | Evening | 4 | 1 | 80 | 1 | 0 | One nurse called out sick; short coverage |
| SR-0005 | Physician | 3 | Eastside Community Hospital | FAC-004 | DEPT-004-01 | General Practice | 2024-02-14 | Day | 3 | 0 | 100 | 0 | 0 | blank |
| SR-0006 | Technician | 3 | Riverside Medical Pavilion | FAC-005 | DEPT-005-05 | Radiology | 2024-03-22 | Night | 2 | 1.5 | 66.67 | 1 | 1 | Agency staff filled last-minute vacancy |
| SR-0007 | Therapist | 2 | Lakeside Regional Hospital | FAC-002 | DEPT-002-04 | ICU | 2024-04-06 | Evening | 2 | 0.5 | 100 | 0 | 0 | blank |
| SR-0008 | Nurse | 6 | Mountainview Health Campus | FAC-003 | DEPT-003-01 | Emergency | 2024-05-18 | Day | 8 | 5.5 | 133.33 | 0 | 2 | Major incident required surge staffing |
| SR-0009 | Technician | 5 | Greenfields Medical Center | FAC-006 | DEPT-006-03 | Operating Room | 2024-06-01 | Day | 5 | 0 | 100 | 0 | 0 | blank |
| SR-0010 | Physician | 2 | Central Valley Medical Center | FAC-001 | DEPT-001-03 | ICU | 2024-05-05 | Night | 2 | 0 | 100 | 0 | 0 | blank |
| SR-0011 | Nurse | 8 | Lakeside Regional Hospital | FAC-002 | DEPT-002-01 | Emergency | 2024-04-15 | Day | 8 | 0 | 100 | 0 | 0 | blank |
| SR-0012 | Therapist | 1 | Mountainview Health Campus | FAC-003 | DEPT-003-04 | General Practice | 2024-02-19 | Evening | 1 | 0 | 100 | 0 | 0 | blank |
| SR-0013 | Technician | 0 | Lakeside Regional Hospital | FAC-002 | DEPT-002-05 | Radiology | 2024-01-01 | Day | 0 | 0 | 0 | 0 | 0 | Unit closed, no staff scheduled |
| SR-0014 | Nurse | 3 | Eastside Community Hospital | FAC-004 | DEPT-004-02 | ICU | 2024-03-28 | Night | 2 | 2 | 66.67 | 1 | 1 | Agency nurse filled vacancy due to staff absence |
| SR-0015 | Therapist | 2 | Riverside Medical Pavilion | FAC-005 | DEPT-005-02 | Pediatrics | 2024-04-22 | Evening | 2 | 0 | 100 | 0 | 0 | blank |
| SR-0016 | Nurse | 9 | Greenfields Medical Center | FAC-006 | DEPT-006-01 | Emergency | 2024-05-25 | Day | 10 | 6.5 | 111.11 | 0 | 2 | Surge staffing required due to multi-vehicle accident |
| SR-0017 | Technician | 2 | Central Valley Medical Center | FAC-001 | DEPT-001-04 | Radiology | 2024-03-17 | Night | 2 | 1 | 100 | 0 | 0 | blank |
| SR-0018 | Physician | 5 | Eastside Community Hospital | FAC-004 | DEPT-004-03 | Operating Room | 2024-04-20 | Day | 6 | 3.5 | 120 | 0 | 1 | Surge staffing for unexpected emergency surgery |
| SR-0019 | Nurse | 6 | Riverside Medical Pavilion | FAC-005 | DEPT-005-03 | General Practice | 2024-06-05 | Evening | 5 | 1 | 83.33 | 1 | 1 | Short staffed due to callout; agency nurse assisted |
| SR-0020 | Technician | 2 | Mountainview Health Campus | FAC-003 | DEPT-003-05 | Radiology | 2024-02-24 | Night | 2 | 0.5 | 100 | 0 | 0 | blank |
What the 200 rows show
from the 200-row sampleNurse (provider role) stands out: mean scheduled_
- 3.5median scheduled_
staff_ count - 3shift types
- 8department names
- 25facilities
- 3median actual_
staff_ count - 0.50median overtime_
hours
Median 3.5, from 0 to 9.
- string 8
- integer 4
- float 2
- date 1
Columns
15 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
staffing_record_id | string | Unique identifier for each staffing recordunique | SR-0001 |
facility_id | string | Unique identifier for the healthcare facility | FAC-001 |
facility_name | string | Name of the healthcare facility | Northeast Medical Center |
department_id | string | Unique identifier for the department within the facility | DEPT-001-01 |
department_name | string | Name of the department (e.g., Emergency, ICU, Pediatrics)8 names | Emergency |
shift_type | string | Type of shift (e.g., Day, Night, Evening)Day · Evening · Night | Day |
provider_role | string | Role of the healthcare provider (e.g., Nurse, Physician, Technician)4 roles | Nurse |
notes | string | Additional notes or comments about the shift (e.g., reasons for understaffing, incidents)optional | Staff illness; coverage g… |
| Numbers 6 columns | |||
scheduled_staff_count | integer | Number of staff scheduled for the shift0 or more | 7 |
actual_staff_count | integer | Number of staff who actually worked the shift0 or more | 7 |
overtime_hours | float | Total overtime hours worked during the shift0 or more | 0 |
shift_coverage_percent | float | Percentage of scheduled positions that were filled for the shift0 to 100 | 100 |
absent_staff_count | integer | Number of scheduled staff who were absent for the shift0 or more | 0 |
agency_staff_count | integer | Number of agency or temporary staff used during the shift0 or more | 0 |
| Dates and times 1 column | |||
shift_date | date | Date of the staffing shift | 2024-01-03 |
Use it for
A healthcare dashboard
Scheduled_
staff_ count by provider_ role and a breakdown of facility_ name. Excel, Power BI or Tableau. Why do the 65 Nurse rows have a mean scheduled_
staff_ count of 6.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Staffing records200SR-00017NurseSR-00024PhysicianSR-00032Technici…
A software demo
Believable staffing records with facility_
id, facility_ name and department_ id to fill a screen in front of a buyer.
This dataset200 rows15 columns
Yours1,000 rows15 columns
blueprint · healthcare-workforce-staffing-metrics
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 15 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
- Log staff role and qualifications
- Track shift patterns and absences
- Flag overtime events
- Aggregate daily staffing levels
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-workforce-staffing-metrics