Hospital Resource Utilization Dataset
This dataset provides granular, time-stamped records of hospital resource utilization, including beds, staff, and equipment across departments and shifts. It enables detailed analysis and forecasting for operational planning, surge management, and cost optimization, making it ideal for AI-driven resource allocation and healthcare analytics. The dataset supports both real-time monitoring and historical trend analysis for improved hospital efficiency.
Sample rows
preview · 8 of 200 rows · all 18 columns| record_idstring | resource_typestring | unit_costfloat | hospital_namestring | hospital_idstring | departmentstring | resource_subtypestring | datedate | shiftstring | resource_capacityinteger | resource_in_useinteger | resource_availableinteger | forecasted_demandinteger | surge_capacityinteger | utilization_ratefloat | total_costfloat | last_updateddatetime | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REC0001 | bed | 8500 | Green Valley Medical Center | H001 | ICU | ICU Bed | 2024-06-01 | morning | 30 | 28 | 2 | 31 | 38 | 0.933 | 238000 | 2024-06-01T08:45:12 | Near full occupancy, surge likely needed. |
| REC0002 | nurse | 72.5 | Riverside General Hospital | H002 | Emergency | ER Nurse | 2024-06-01 | afternoon | 12 | 13 | 0 | 14 | 15 | 1.083 | 942.5 | 2024-06-01T13:22:59 | Overutilization: staff covering multiple roles. |
| REC0003 | doctor | 315 | Northside Regional Health | H003 | Surgery | Surgeon | 2024-06-01 | afternoon | 7 | 6 | 1 | 7 | 8 | 0.857 | 1890 | 2024-06-01T15:03:21 | All scheduled procedures covered. |
| REC0004 | PPE | 1.75 | Sunrise Children's Hospital | H004 | Pediatrics | Child Surgical Mask | 2024-06-01 | morning | 800 | 250 | 550 | 260 | 1200 | 0.313 | 437.5 | 2024-06-01T09:30:00 | Stocked in advance for seasonal spikes. |
| REC0005 | ventilator | 11500 | Central City Medical Campus | H005 | ICU | LifeSupport Ventilator | 2024-06-01 | night | 10 | 9 | 1 | 10 | 13 | 0.9 | 103500 | 2024-06-01T22:02:18 | All ventilators in use except one on standby. |
| REC0006 | PPE | 2.2 | Green Valley Medical Center | H001 | Emergency | N95 Mask | 2024-06-01 | night | 1200 | 1000 | 200 | 1100 | 1500 | 0.833 | 2200 | 2024-06-01T23:55:35 | Critical low stock, resupply ordered. |
| REC0007 | nurse | 80 | Riverside General Hospital | H002 | ICU | ICU Nurse | 2024-06-01 | morning | 18 | 18 | 0 | 19 | 20 | 1 | 1440 | 2024-06-01T06:58:41 | All ICU nurses on shift, full occupancy. |
| REC0008 | monitor | 1250 | Northside Regional Health | H003 | Surgery | Cardiac Monitor | 2024-06-01 | afternoon | 4 | 2 | 2 | 3 | 5 | 0.5 | 2500 | 2024-06-01T16:37:55 | No equipment failures reported. |
| REC0009 | nurse | 68 | Sunrise Children's Hospital | H004 | Pediatrics | Pediatric Nurse | 2024-06-02 | morning | 11 | 8 | 3 | 9 | 13 | 0.727 | 544 | 2024-06-02T09:10:26 | Several staff on leave this week. |
| REC0010 | doctor | 192 | Central City Medical Campus | H005 | Emergency | ER Physician | 2024-06-02 | full_day | 8 | 9 | 0 | 9 | 10 | 1.125 | 1728 | 2024-06-02T18:45:20 | Doctors covering double shifts due to incident. |
| REC0011 | PPE | 2.1 | Lakeshore Medical Pavilion | H006 | ICU | Face Shield | 2024-06-02 | night | 1000 | 750 | 250 | 800 | 1300 | 0.75 | 1575 | 2024-06-02T23:02:45 | Surge likely needed if trend continues. |
| REC0012 | other | 2500000 | Liberty Memorial Hospital | H007 | Surgery | Surgical Robot | 2024-06-02 | afternoon | 1 | 1 | 0 | 1 | 1 | 1 | 2500000 | 2024-06-02T13:30:11 | High-cost, fully utilized. |
| REC0013 | monitor | 2250 | Willowbrook Health Center | H008 | Pediatrics | Neonatal Monitor | 2024-06-02 | morning | 3 | 1 | 2 | 2 | 4 | 0.333 | 2250 | 2024-06-02T10:05:17 | One monitor on standby for emergencies. |
| REC0014 | ventilator | 9500 | Summit Hills Hospital | H009 | ICU | Portable Ventilator | 2024-06-02 | full_day | 7 | 8 | 0 | 9 | 10 | 1.143 | 76000 | 2024-06-02T19:45:33 | Emergency overutilization due to local outbreak. |
| REC0015 | PPE | 0.85 | Maplewood Medical Institute | H010 | Emergency | Nitrile Gloves | 2024-06-02 | morning | 1500 | 1120 | 380 | 1200 | 2000 | 0.747 | 952 | 2024-06-02T09:14:56 | Stocked in advance. |
| REC0016 | doctor | 295 | Green Valley Medical Center | H001 | Surgery | blank | 2024-06-03 | afternoon | 6 | 3 | 3 | 4 | 7 | 0.5 | 885 | 2024-06-03T15:00:00 | Low demand, some doctors on rotation. |
| REC0017 | nurse | 80 | Riverside General Hospital | H002 | ICU | blank | 2024-06-03 | night | 20 | 16 | 4 | 17 | 22 | 0.8 | 1280 | 2024-06-03T23:44:11 | Night shift under standard capacity. |
| REC0018 | PPE | 1.95 | Northside Regional Health | H003 | Pediatrics | Child Face Shield | 2024-06-03 | night | 950 | 600 | 350 | 650 | 1100 | 0.632 | 1170 | 2024-06-03T22:09:43 | Usage increasing with local flu reports. |
| REC0019 | doctor | 198 | Sunrise Children's Hospital | H004 | Emergency | ER Physician | 2024-06-03 | morning | 9 | 9 | 0 | 10 | 11 | 1 | 1782 | 2024-06-03T08:50:15 | All ER doctors on duty. |
| REC0020 | bed | 8900 | Central City Medical Campus | H005 | ICU | ICU Bed | 2024-06-03 | full_day | 34 | 33 | 1 | 34 | 40 | 0.971 | 293700 | 2024-06-03T20:21:17 | Near full occupancy. |
What the 200 rows show
from the 200-row sampleOther (resource type) stands out: mean unit_
- 305.0median unit_
cost - 4departments
- 4shifts
- 30hospitals
- 11median resource_
capacity - 10median resource_
in_ use
Median 305.0, from 0.85 to 2,500,000.
- string 8
- integer 5
- float 3
- date 1
- datetime 1
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
record_id | string | Unique identifier for each resource utilization recordunique | REC0001 |
hospital_id | string | Unique identifier for the hospital | H001 |
hospital_name | string | Name of the hospital | Summit Hills Hospital |
department | string | Hospital department (e.g., ICU, Emergency, Surgery, Pediatrics)4 departments | ICU |
resource_type | string | Type of resource (e.g., bed, ventilator, nurse, doctor, PPE)8 values | bed |
resource_subtype | string | Subtype or specification of the resource (e.g., ICU bed, surgical nurse, N95 mask)optional | ICU Bed |
shift | string | Work shift (e.g., morning, afternoon, night)morning · afternoon · night · full_day · optional | morning |
notes | string | Additional notes or comments about resource utilizationoptional | Stocked in advance. |
| Numbers 8 columns | |||
resource_capacity | integer | Total number of this resource available in the department on the given date and shift0 or more | 30 |
resource_in_use | integer | Number of this resource currently in use0 or more | 28 |
resource_available | integer | Number of this resource currently available for use0 or more | 2 |
forecasted_demand | integer | Forecasted demand for this resource for the given date and shift0 or more · optional | 31 |
surge_capacity | integer | Maximum number of this resource that can be made available in a surge scenario0 or more · optional | 38 |
utilization_rate | float | Percentage of resource in use (resource_in_use/resource_capacity)0 to 1 · optional | 0.933 |
unit_cost | float | Cost per unit of the resource (in local currency)0 or more · optional | 8500 |
total_cost | float | Total cost for the resource in use (resource_in_use * unit_cost)0 or more · optional | 238000 |
| Dates and times 2 columns | |||
date | date | Date for which the resource utilization is recorded | 2024-06-01 |
last_updated | datetime | Timestamp when the record was last updated | 2024-06-01T08:45:12 |
15 SQL practice questions for the Hospital Resource Utilization Dataset
Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.
Overutilized ICU records
Return every record from the ICU department whose utilization_rate is above 1. Include the columns record_id, hospital_name, resource_type and utilization_rate. Order the results by utilization_rate from highest to lowest, then by record_id ascending.
Tables: hospital_resource_utilization_dataset · your result: 4 columns, 4 rowsDistinct resource types per department
Return each distinct combination of department and resource_type that appears in the data. Use the columns department and resource_type. Order by department, then resource_type.
Tables: hospital_resource_utilization_dataset · your result: 2 columns, 21 rowsRecords per shift
Count the records for each shift. Return the columns shift and record_count. Order by record_count from highest to lowest, then by shift ascending.
Tables: hospital_resource_utilization_dataset · your result: 2 columns, 4 rows
- 04Total cost by departmentBeginner
- 05Power BI: capacity by resource typePower BI
- 06Hospitals with high average utilizationIntermediate
- 07Utilization bucketsIntermediate
- 08Departments above overall average costIntermediate
- 09Monthly demand gapIntermediate
- 10Power BI: surge-risk records by departmentPower BI
- 11Top two hospitals by cost per departmentAdvanced
- 12Change in daily utilizationAdvanced
- 13Running total of costAdvanced
- 14Percent of total cost by resource typeAdvanced
- 15Power BI: anomalous utilization recordsPower BI
Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.
Get the practice kit · $3.99Use it for
A healthcare dashboard
Unit_
cost by resource_ type and a breakdown of hospital_ name. Excel, Power BI or Tableau. Why do the 17 other rows have a mean unit_
cost of 1,097,376? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Records200REC00018500bedREC000272.5nurseREC0003315doctor
A software demo
Believable records with hospital_
id, hospital_ name and department to fill a screen in front of a buyer.
blueprint · hospital-resource-utilization-dataset
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 18 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.
- Admissions fluctuate with seasonality
- Intensive care units have limited capacity
- Equipment utilization peaks during outbreaks
- Staff schedules adhere to labor rules
- Elective surgeries affect resource demand
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-resource-utilization-dataset