Hospital Bed Occupancy Forecast
This dataset provides detailed forecasts of hospital bed occupancy rates by department and time, incorporating expected admissions, discharges, and resource utilization metrics. It enables healthcare administrators to anticipate capacity needs, optimize resource allocation, and improve patient care delivery through data-driven planning. The dataset supports both operational and strategic decision-making in hospital management.
Sample rows
preview · 8 of 200 rows · all 16 columns| forecast_idstring | forecast_methodstring | forecasted_occupied_bedsinteger | departmentstring | hospital_idstring | hospital_namestring | forecast_datedate | forecast_timestring | total_bedsinteger | forecasted_occupancy_ratefloat | expected_admissionsinteger | expected_dischargesinteger | resource_utilization_scorefloat | created_atdatetime | updated_atdatetime | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| F20240621-001 | ML-based | 80 | General Ward | H10234 | Green Valley Medical Center | 2024-07-03 | 08:00 | 86 | 93.02 | 5 | 3 | 0.93 | 2024-06-21T09:11:23 | 2024-06-21T11:05:12 | Routine weekday forecast with high census following holiday. |
| F20240621-002 | Expert estimate | 22 | ICU | H10235 | Bay Area Health Institute | 2024-07-04 | 16:00 | 24 | 91.67 | 1 | 2 | 0.92 | 2024-06-21T09:13:44 | blank | Surge expected post-local festival; critical beds prioritized. |
| F20240621-003 | ARIMA | 12 | Pediatrics | H10236 | Lakeside Community Hospital | 2024-07-05 | 12:00 | 52 | 23.08 | 2 | 1 | 0.19 | 2024-06-21T09:16:22 | 2024-06-21T12:30:55 | Low census prior to summer camp admissions. |
| F20240621-004 | ML-based | 60 | General Ward | H10237 | Riverfield Clinic | 2024-07-06 | 06:00 | 62 | 96.77 | 8 | 5 | 0.97 | 2024-06-21T09:18:01 | blank | Post-weekend spike; increased admissions due to flu cases. |
| F20240621-005 | Expert estimate | 14 | Emergency | H10238 | Sunrise Regional Hospital | 2024-07-07 | 18:00 | 15 | 93.33 | 1 | 1 | 0.94 | 2024-06-21T09:20:12 | 2024-06-21T10:12:19 | Weekend event; higher trauma occupancy expected. |
| F20240621-006 | ML-based | 45 | ICU | H10239 | Harborview Medical Center | 2024-07-03 | 22:00 | 46 | 97.83 | 2 | 1 | 0.98 | 2024-06-21T09:22:38 | blank | Critical occupancy; single-bed turnovers expected. |
| F20240621-007 | ARIMA | 38 | Geriatrics | H10240 | Northside General Hospital | 2024-07-08 | 10:00 | 39 | 97.44 | 0 | 0 | 0.97 | 2024-06-21T09:24:52 | 2024-06-21T12:14:45 | Stable occupancy; scheduled maintenance week. |
| F20240621-008 | Expert estimate | 11 | NICU | H10241 | Eastside Pediatric Hospital | 2024-07-09 | 09:00 | 13 | 84.62 | 1 | 1 | 0.85 | 2024-06-21T09:26:31 | blank | Seasonal RSV spike; higher neonatal admissions forecasted. |
| F20240621-009 | ML-based | 4 | Oncology | H10242 | Willowbrook Oncology Center | 2024-07-10 | 13:00 | 21 | 19.05 | 0 | 2 | 0.18 | 2024-06-21T09:29:11 | 2024-06-21T09:41:22 | Major discharges after routine chemotherapy sessions. |
| F20240621-010 | Expert estimate | 6 | Cardiology | H10243 | Central City Cardiology Hospital | 2024-07-11 | 07:00 | 38 | 15.79 | 0 | 1 | 0.16 | 2024-06-21T09:32:20 | blank | Scheduled cleaning; low occupancy expected. |
| F20240621-011 | ARIMA | 34 | Rehabilitation | H10244 | Highland Rehabilitation Center | 2024-07-12 | 15:00 | 36 | 94.44 | 1 | 1 | 0.94 | 2024-06-21T09:34:17 | 2024-06-21T10:20:44 | Routine scheduled maintenance; stable census. |
| F20240621-012 | ML-based | 3 | Psychiatry | H10245 | Westside Psychiatric Clinic | 2024-07-13 | 11:00 | 18 | 16.67 | 0 | 1 | 0.16 | 2024-06-21T09:37:05 | blank | Low census post-discharge; routine cleaning scheduled. |
| F20240621-013 | Expert estimate | 5 | Neurology | H10246 | Mountainview Neurology Institute | 2024-07-14 | 17:00 | 30 | 16.67 | 1 | 0 | 0.17 | 2024-06-21T09:39:45 | 2024-06-21T09:55:15 | Elective admissions postponed; low occupancy forecasted. |
| F20240621-014 | ARIMA | 3 | Maternity | H10247 | Southridge Maternity Hospital | 2024-07-15 | 21:00 | 22 | 13.64 | 0 | 1 | 0.14 | 2024-06-21T09:41:51 | blank | Low occupancy after major discharges; routine maintenance. |
| F20240621-015 | ML-based | 17 | ICU | H10234 | Green Valley Medical Center | 2024-07-03 | 10:00 | 18 | 94.44 | 1 | 0 | 0.94 | 2024-06-21T09:43:36 | 2024-06-21T09:45:05 | Surge in critical care beds; holiday weekend. |
| F20240621-016 | ARIMA | 70 | General Ward | H10235 | Bay Area Health Institute | 2024-07-04 | 14:00 | 74 | 94.59 | 6 | 4 | 0.95 | 2024-06-21T09:46:18 | blank | Routine post-weekend spike in admissions. |
| F20240621-017 | Expert estimate | 2 | Maternity | H10236 | Lakeside Community Hospital | 2024-07-05 | 07:00 | 19 | 10.53 | 0 | 2 | 0.11 | 2024-06-21T09:48:00 | 2024-06-21T09:49:30 | Low census before scheduled admissions. |
| F20240621-018 | ARIMA | 42 | Pediatrics | H10237 | Riverfield Clinic | 2024-07-06 | 12:00 | 44 | 95.45 | 2 | 1 | 0.95 | 2024-06-21T09:51:17 | blank | Seasonal peak; RSV admissions expected. |
| F20240621-019 | ML-based | 53 | ICU | H10238 | Sunrise Regional Hospital | 2024-07-07 | 20:00 | 54 | 98.15 | 2 | 1 | 0.98 | 2024-06-21T09:53:50 | 2024-06-21T10:23:09 | Critical care beds at near full; weekend event. |
| F20240621-020 | ARIMA | 60 | General Ward | H10239 | Harborview Medical Center | 2024-07-03 | 10:00 | 65 | 92.31 | 7 | 5 | 0.92 | 2024-06-21T09:56:27 | blank | Routine weekday forecast post-holiday. |
What the 200 rows show
from the 200-row sampleExpert estimate (forecast method) stands out: mean forecasted_
- 18.5median forecasted_
occupied_ beds - 50forecast times
- 30median total_
beds - 90.7median forecasted_
occupancy_ rate - 1median expected_
admissions - 1median expected_
discharges
Median 18.5, from 0 to 98.
- string 7
- integer 4
- float 2
- date 1
- datetime 2
Columns
16 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 7 columns | |||
forecast_id | string | Unique identifier for each hospital bed occupancy forecast recordunique | F20240621-001 |
hospital_id | string | Unique identifier for the hospital | H10234 |
hospital_name | string | Name of the hospital | Riverfield Clinic |
department | string | Hospital department or unit (e.g., ICU, General Ward, Pediatrics)12 departments | General Ward |
forecast_time | string | Time of day for the forecast (e.g., 08:00, 16:00); use 24-hour formatoptional | 08:00 |
forecast_method | string | Method or model used for forecasting (e.g., ARIMA, ML-based, expert estimate)3 methods · optional | ML-based |
notes | string | Additional comments or notes about the forecastoptional | Routine weekday forecast … |
| Numbers 6 columns | |||
total_beds | integer | Total number of beds available in the department/unit1 or more | 86 |
forecasted_occupied_beds | integer | Number of beds expected to be occupied at the forecast time0 or more | 80 |
forecasted_occupancy_rate | float | Forecasted occupancy rate as a percentage (0-100)0 to 100 | 93.02 |
expected_admissions | integer | Number of patient admissions expected during the forecast period0 or more · optional | 5 |
expected_discharges | integer | Number of patient discharges expected during the forecast period0 or more · optional | 3 |
resource_utilization_score | float | Composite score indicating resource utilization (e.g., staff, equipment) in the department/unit (0-1 scale)0 to 1 · optional | 0.93 |
| Dates and times 3 columns | |||
forecast_date | date | Date for which the occupancy forecast is made | 2024-07-03 |
created_at | datetime | Timestamp when the forecast record was created | 2024-06-21T09:11:23 |
updated_at | datetime | Timestamp when the forecast record was last updatedoptional | 2024-06-21T11:05:12 |
Use it for
A healthcare dashboard
Forecasted_
occupied_ beds by forecast_ method and a breakdown of department. Excel, Power BI or Tableau. Why do the 65 Expert estimate rows have a mean forecasted_
occupied_ beds of 11.9? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Forecasts200F20240621-00180ML-basedF20240621-00222Expert e…F20240621-00312ARIMA
A software demo
Believable forecasts with hospital_
id, hospital_ name and department to fill a screen in front of a buyer.
This dataset200 rows16 columns
Yours1,000 rows16 columns
blueprint · hospital-bed-occupancy-forecast
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 16 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
- Include daily admission and discharge records
- Calculate average length of stay per department
- Segment data by ward type
- Flag high-demand periods for occupancy surges
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-bed-occupancy-forecast