Hospital Resource Utilization Forecasts
This dataset provides daily, hospital-level forecasts of resource utilization, including beds, staff, ventilators, and PPE, to support capacity planning and emergency response. Each record details projected needs and availability for specific resource types, along with confidence intervals and model metadata, enabling healthcare administrators and policymakers to anticipate surges and allocate resources efficiently.
Sample rows
preview · 8 of 200 rows · all 24 columns| forecast_idstring | hospital_typestring | forecast_confidence_interval_lowerfloat | address_statestring | hospital_idstring | hospital_namestring | address_streetstring | address_citystring | address_postal_codestring | address_countrystring | forecast_datedate | bed_typestring | forecasted_beds_neededinteger | forecasted_beds_availableinteger | forecasted_staff_neededinteger | forecasted_nurses_neededinteger | forecasted_physicians_neededinteger | forecasted_ventilators_neededinteger | forecasted_ventilators_availableinteger | forecasted_ppe_neededinteger | forecasted_ppe_availableinteger | forecast_confidence_interval_upperfloat | forecast_model_versionstring | last_updateddatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FCT-00001 | general | 450.2 | CA | H001 | Starlake General Hospital | 123 Lakeview Ave | Los Angeles | 90001 | USA | 2024-07-03 | general | 468 | 495 | 829 | 497 | 111 | 23 | 25 | 3120 | 3500 | 478.6 | urbanpeak-2024 | 2024-06-16T08:23:10 |
| FCT-00002 | other | 3.4 | MN | H002 | Northside Regional Clinic | 88 Maple Lane | Duluth | 55802 | USA | 2024-08-12 | other | 4 | 7 | 6 | 3 | 1 | 0 | 1 | 25 | 35 | 5 | rural-v2.1 | 2024-06-16T08:28:41 |
| FCT-00003 | specialty | 85.1 | NY | H003 | Central City Specialty Center | 321 Broadway Blvd | New York | 10010 | USA | 2024-09-01 | ICU | 89 | 100 | 145 | 81 | 23 | 36 | 38 | 1200 | 1280 | 98 | icu-v3.2 | 2024-06-16T08:36:09 |
| FCT-00004 | children's | 22 | NSW | H004 | Oceanview Children's Hospital | 19 Seaside Rd | Sydney | 2000 | Australia | 2024-07-25 | pediatric | 26 | 34 | 43 | 28 | 8 | 8 | 10 | 470 | 525 | 29.6 | aus-ped-2024 | 2024-06-16T08:44:12 |
| FCT-00005 | general | 498.3 | TX | H005 | Southpoint Medical Center | 456 Pine St | Houston | 77002 | USA | 2024-10-08 | general | 510 | 540 | 902 | 501 | 118 | 25 | 32 | 4100 | 4200 | 533 | urbanpeak-2024 | 2024-06-16T08:56:01 |
| FCT-00006 | other | 1 | CO | H006 | Evergreen Health Clinic | 22 Forest Dr | Boulder | 80302 | USA | 2024-07-19 | general | 2 | 4 | 3 | 1 | 1 | 0 | 0 | 12 | 20 | 3 | micro-2024 | 2024-06-16T09:01:22 |
| FCT-00007 | general | 377.5 | FL | H007 | Sunrise General Hospital | 789 Sunrise Blvd | Miami | 33101 | USA | 2024-11-15 | general | 389 | 405 | 698 | 415 | 97 | 19 | 25 | 2750 | 2900 | 412 | urbanpeak-2024 | 2024-06-16T09:18:48 |
| FCT-00008 | ICU | 70.6 | IL | H008 | Riverside ICU Center | 110 Riverbank Rd | Chicago | 60610 | USA | 2024-09-10 | ICU | 76 | 89 | 140 | 77 | 17 | 40 | 45 | 1100 | 1200 | 81.4 | icu-v3.3 | 2024-06-16T09:22:23 |
| FCT-00009 | general | 240 | ON | H009 | Maple Leaf Medical Center | 88 King St W | Toronto | M5H 1A1 | Canada | 2024-08-20 | general | 256 | 260 | 420 | 246 | 44 | 13 | 15 | 1500 | 1600 | 272 | can-gen-v1.2 | 2024-06-16T09:31:55 |
| FCT-00010 | specialty | 58.3 | BC | H010 | West Valley Isolation Center | 411 Westview Ave | Vancouver | V6B 1T1 | Canada | 2024-12-04 | isolation | 62 | 80 | 123 | 68 | 19 | 21 | 23 | 940 | 1100 | 69.2 | iso-intl-v2.1 | 2024-06-16T09:38:47 |
| FCT-00011 | general | 220 | CA | H011 | Harmony General Hospital | 336 Oakwood Dr | San Francisco | 94102 | USA | 2024-08-16 | general | 227 | 241 | 410 | 235 | 45 | 15 | 18 | 1400 | 1550 | 241.3 | urbanpeak-2024 | 2024-06-16T09:47:19 |
| FCT-00012 | children's | 31 | TX | H012 | Sunbeam Children's Hospital | 94 Children's Way | Dallas | 75201 | USA | 2024-09-21 | pediatric | 34 | 38 | 57 | 38 | 7 | 6 | 7 | 610 | 690 | 37.5 | ped.v3.1 | 2024-06-16T10:04:31 |
| FCT-00013 | ICU | 88 | WA | H013 | Silver Lake ICU Center | 21 Silver Lake Rd | Seattle | 98101 | USA | 2024-09-15 | ICU | 92 | 100 | 166 | 101 | 18 | 52 | 58 | 1450 | 1600 | 98.5 | icu-v3.5 | 2024-06-16T10:12:17 |
| FCT-00014 | general | 406 | CA | H014 | Downtown General Hospital | 200 Main St | San Diego | 92101 | USA | 2024-10-19 | general | 412 | 418 | 715 | 420 | 102 | 27 | 29 | 3320 | 3450 | 426.8 | urbanpeak-2024 | 2024-06-16T10:19:21 |
| FCT-00015 | general | 362.5 | FL | H015 | Meadowbrook Health Center | 84 Meadowbrook Dr | Orlando | 32801 | USA | 2024-10-31 | general | 370 | 390 | 642 | 387 | 68 | 16 | 20 | 2510 | 2660 | 388.8 | urbanpeak-2024 | 2024-06-16T10:26:49 |
| FCT-00016 | specialty | 66.8 | SH | H016 | Rosehill Specialty Hospital | 16 Rosehill Ave | Shanghai | 200040 | China | 2024-08-07 | isolation | 73 | 90 | 146 | 90 | 21 | 19 | 23 | 1300 | 1450 | 78.4 | iso-intl-v2.5 | 2024-06-16T10:37:02 |
| FCT-00017 | other | 0 | ON | H017 | Pinecrest Rural Clinic | 7 Pinecrest Rd | Thunder Bay | P7B 6G2 | Canada | 2024-06-30 | other | 1 | 2 | 2 | 1 | 0 | 0 | 0 | 5 | 8 | 2 | micro-2024 | 2024-06-16T10:48:20 |
| FCT-00018 | children's | 20.4 | QLD | H018 | Liberty Pediatric Center | 60 Liberty Ave | Brisbane | 4000 | Australia | 2024-11-11 | pediatric | 22 | 28 | 37 | 25 | 4 | 4 | 5 | 410 | 470 | 25.2 | aus-ped-2024 | 2024-06-16T10:59:55 |
| FCT-00019 | general | 201.8 | TX | H019 | Greenfield General Hospital | 52 Greenfield Blvd | Austin | 73301 | USA | 2024-07-15 | general | 209 | 220 | 362 | 221 | 31 | 10 | 13 | 1200 | 1300 | 217.4 | urbanpeak-2024 | 2024-06-16T11:06:31 |
| FCT-00020 | ICU | 58.1 | MA | H020 | Peacehaven ICU Hospital | 110 Peacehaven Dr | Boston | 02108 | USA | 2024-12-19 | ICU | 61 | 70 | 120 | 71 | 15 | 30 | 33 | 930 | 1000 | 66.9 | icu-v3.7 | 2024-06-16T11:16:21 |
What the 200 rows show
from the 200-row sampleGeneral (hospital type) stands out: mean forecast_
- 79.0median forecast_
confidence_ interval_ lower - 4address countries
- 5bed types
- 83median forecasted_
beds_ needed - 95median forecasted_
beds_ available - 140median forecasted_
staff_ needed
Median 79.0, from 0.0 to 498.3.
- string 11
- integer 9
- float 2
- date 1
- datetime 1
Columns
24 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
forecast_id | string | Unique identifier for each forecast recordunique | FCT-00001 |
hospital_id | string | Unique identifier for the hospital or facility | H001 |
hospital_name | string | Official name of the hospital or facility | Evergreen Health Clinic |
hospital_type | string | Type of hospital (e.g., general, specialty, children's, ICU)general · specialty · children's · ICU · other · optional | general |
address_street | string | Street address of the hospitaloptional | 123 Lakeview Ave |
address_city | string | City where the hospital is locatedoptional | Los Angeles |
address_state | string | State or province where the hospital is locatedoptional | CA |
address_postal_code | string | Postal or ZIP code of the hospitaloptional | 90001 |
address_country | string | Country where the hospital is located4 countries · optional | USA |
bed_type | string | Type of bed (e.g., general, ICU, pediatric, isolation)general · ICU · pediatric · isolation · other | general |
forecast_model_version | string | Version or name of the forecasting model usedoptional | urbanpeak-2024 |
| Numbers 11 columns | |||
forecasted_beds_needed | integer | Number of beds forecasted to be needed on the forecast date for the specified bed type0 or more | 468 |
forecasted_beds_available | integer | Number of beds expected to be available on the forecast date for the specified bed type0 or more · optional | 495 |
forecasted_staff_needed | integer | Number of staff (all types) forecasted to be needed on the forecast date0 or more · optional | 829 |
forecasted_nurses_needed | integer | Number of nurses forecasted to be needed on the forecast date0 or more · optional | 497 |
forecasted_physicians_needed | integer | Number of physicians forecasted to be needed on the forecast date0 or more · optional | 111 |
forecasted_ventilators_needed | integer | Number of ventilators forecasted to be needed on the forecast date0 or more · optional | 23 |
forecasted_ventilators_available | integer | Number of ventilators expected to be available on the forecast date0 or more · optional | 25 |
forecasted_ppe_needed | integer | Number of personal protective equipment (PPE) units forecasted to be needed on the forecast date0 or more · optional | 3120 |
forecasted_ppe_available | integer | Number of PPE units expected to be available on the forecast date0 or more · optional | 3500 |
forecast_confidence_interval_lower | float | Lower bound of the confidence interval for the primary forecasted value (beds needed)optional | 450.2 |
forecast_confidence_interval_upper | float | Upper bound of the confidence interval for the primary forecasted value (beds needed)optional | 478.6 |
| Dates and times 2 columns | |||
forecast_date | date | Date for which the resource utilization is forecasted | 2024-07-03 |
last_updated | datetime | Timestamp when this forecast record was last updated | 2024-06-16T08:23:10 |
Use it for
A healthcare dashboard
Forecast_
confidence_ interval_ lower by hospital_ type and a breakdown of address_ state. Excel, Power BI or Tableau. Why do the 77 general rows have a mean forecast_
confidence_ interval_ lower of 299.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Forecasts200FCT-00001450.2generalFCT-000023.4otherFCT-0000385.1specialty
A software demo
Believable forecasts with hospital_
id, hospital_ name and hospital_ type to fill a screen in front of a buyer.
blueprint · hospital-resource-utilization-forecasts
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 24 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.
- Each record predicts resource need by unit and type.
- Historical utilization, seasonal patterns included.
- Emergency surges and epidemic scenarios simulated.
- Demographics and region anonymized.
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-forecasts