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.

  • last updated 22 Jul 2025
  • by GoMask
The brief that made it

Hospital capacity planning and surge management

Sample rows

preview · 8 of 200 rows · all 24 columns
forecast_idstringhospital_typestringforecast_confidence_interval_lowerfloataddress_statestringhospital_idstringhospital_namestringaddress_streetstringaddress_citystringaddress_postal_codestringaddress_countrystringforecast_datedatebed_typestringforecasted_beds_neededintegerforecasted_beds_availableintegerforecasted_staff_neededintegerforecasted_nurses_neededintegerforecasted_physicians_neededintegerforecasted_ventilators_neededintegerforecasted_ventilators_availableintegerforecasted_ppe_neededintegerforecasted_ppe_availableintegerforecast_confidence_interval_upperfloatforecast_model_versionstringlast_updateddatetime
FCT-00001general450.2CAH001Starlake General Hospital123 Lakeview AveLos Angeles90001USA2024-07-03general468495829497111232531203500478.6urbanpeak-20242024-06-16T08:23:10
FCT-00002other3.4MNH002Northside Regional Clinic88 Maple LaneDuluth55802USA2024-08-12other476310125355rural-v2.12024-06-16T08:28:41
FCT-00003specialty85.1NYH003Central City Specialty Center321 Broadway BlvdNew York10010USA2024-09-01ICU89100145812336381200128098icu-v3.22024-06-16T08:36:09
FCT-00004children's22NSWH004Oceanview Children's Hospital19 Seaside RdSydney2000Australia2024-07-25pediatric26344328881047052529.6aus-ped-20242024-06-16T08:44:12
FCT-00005general498.3TXH005Southpoint Medical Center456 Pine StHouston77002USA2024-10-08general510540902501118253241004200533urbanpeak-20242024-06-16T08:56:01
FCT-00006other1COH006Evergreen Health Clinic22 Forest DrBoulder80302USA2024-07-19general243110012203micro-20242024-06-16T09:01:22
FCT-00007general377.5FLH007Sunrise General Hospital789 Sunrise BlvdMiami33101USA2024-11-15general38940569841597192527502900412urbanpeak-20242024-06-16T09:18:48
FCT-00008ICU70.6ILH008Riverside ICU Center110 Riverbank RdChicago60610USA2024-09-10ICU7689140771740451100120081.4icu-v3.32024-06-16T09:22:23

What the 200 rows show

from the 200-row sample

General (hospital type) stands out: mean forecast_confidence_interval_lower is 299.1, against 42.1 for the rest.

  • 79.0median forecast_confidence_interval_lower
  • 4address countries
  • 5bed types
  • 83median forecasted_beds_needed
  • 95median forecasted_beds_available
  • 140median forecasted_staff_needed
Mean forecast_confidence_interval_lower by hospital_type200 rows
0200400299.1general77 rows62.7specia…39 rows22.7childr…33 rows88.3ICU22 rows1.5other29 rows
forecast_confidence_interval_lower200 rows, in bands of 50
040807344931524717530250500forecast_confidence_interval_lower →

Median 79.0, from 0.0 to 498.3.

address_state200 rows · top 10 of 39 values
  1. CA24
  2. TX21
  3. FL19
  4. ON10
  5. BC10
  6. WA10
  7. NY8
  8. NSW7
  9. SH7
  10. QLD7
24 columns by typefrom the column list below
  • string 11
  • integer 9
  • float 2
  • date 1
  • datetime 1

Columns

24 columns in three groups
blueprint · 24 columns
columntypedescriptionexample
Text 11 columns
forecast_idstringUnique identifier for each forecast recorduniqueFCT-00001
hospital_idstringUnique identifier for the hospital or facilityH001
hospital_namestringOfficial name of the hospital or facilityEvergreen Health Clinic
hospital_typestringType of hospital (e.g., general, specialty, children's, ICU)general · specialty · children's · ICU · other · optionalgeneral
address_streetstringStreet address of the hospitaloptional123 Lakeview Ave
address_citystringCity where the hospital is locatedoptionalLos Angeles
address_statestringState or province where the hospital is locatedoptionalCA
address_postal_codestringPostal or ZIP code of the hospitaloptional90001
address_countrystringCountry where the hospital is located4 countries · optionalUSA
bed_typestringType of bed (e.g., general, ICU, pediatric, isolation)general · ICU · pediatric · isolation · othergeneral
forecast_model_versionstringVersion or name of the forecasting model usedoptionalurbanpeak-2024
Numbers 11 columns
forecasted_beds_neededintegerNumber of beds forecasted to be needed on the forecast date for the specified bed type0 or more468
forecasted_beds_availableintegerNumber of beds expected to be available on the forecast date for the specified bed type0 or more · optional495
forecasted_staff_neededintegerNumber of staff (all types) forecasted to be needed on the forecast date0 or more · optional829
forecasted_nurses_neededintegerNumber of nurses forecasted to be needed on the forecast date0 or more · optional497
forecasted_physicians_neededintegerNumber of physicians forecasted to be needed on the forecast date0 or more · optional111
forecasted_ventilators_neededintegerNumber of ventilators forecasted to be needed on the forecast date0 or more · optional23
forecasted_ventilators_availableintegerNumber of ventilators expected to be available on the forecast date0 or more · optional25
forecasted_ppe_neededintegerNumber of personal protective equipment (PPE) units forecasted to be needed on the forecast date0 or more · optional3120
forecasted_ppe_availableintegerNumber of PPE units expected to be available on the forecast date0 or more · optional3500
forecast_confidence_interval_lowerfloatLower bound of the confidence interval for the primary forecasted value (beds needed)optional450.2
forecast_confidence_interval_upperfloatUpper bound of the confidence interval for the primary forecasted value (beds needed)optional478.6
Dates and times 2 columns
forecast_datedateDate for which the resource utilization is forecasted2024-07-03
last_updateddatetimeTimestamp when this forecast record was last updated2024-06-16T08:23:10

Use it for

  • median forecas…79.0200 rowsmean forecast confide…299.1gene…62.7spec…22.7chil…88.3ICU

    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.

  • A software demo

    Believable forecasts with hospital_id, hospital_name and hospital_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 24 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows24 columns
Yours1,000 rows24 columnsaddress_street: UK only

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.

Rules it was built with
  • Each record predicts resource need by unit and type.
  • Historical utilization, seasonal patterns included.
  • Emergency surges and epidemic scenarios simulated.
  • Demographics and region anonymized.
Rows
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-resource-utilization-forecasts

What should your data show?

Preview 20 rows free
No signup. No card.