Healthcare Resource Utilization Dataset

This dataset provides detailed, facility-level tracking of medical equipment and bed occupancy, including resource status, maintenance schedules, utilization rates, and patient assignments. It enables healthcare administrators to optimize resource allocation, monitor capacity, and improve operational efficiency across departments and locations.

  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Real-time monitoring and optimization of bed and equipment utilization

Sample rows

preview · 8 of 200 rows · all 21 columns
facility_idstringresource_statusstringutilization_ratefloatresource_subtypestringfacility_namestringfacility_typestringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystringresource_idstringresource_typestringoccupancy_start_datetimedatetimeoccupancy_end_datetimedatetimepatient_idstringdepartmentstringlast_maintenance_datedatenext_maintenance_due_datedateresource_capacityintegernotesstring
FAC1001occupied94.2ICU bedSt. Gabriel Medical Centerhospital1200 Elm StSpringfieldIL62704USARES-A1001bed2024-06-12T08:21:002024-06-13T15:45:00PAT-4221ICU2024-03-122024-09-121Admitted for post-op monitoring.
FAC1002available22.5Portable ECGGreen Valley Clinicclinic44 Oakwood DriveRedmondWA98052USARES-GV1002ECG machineblankblankblankCardiology2024-01-252024-07-251Machine has passed all calibration checks.
FAC1003under maintenance0Chemotherapy pumpMaple Rehabilitation Centerrehabilitation center88 Maple AveBurlingtonONL7R3A7CanadaRES-MRC1003infusion pumpblankblankblankOncology2024-06-012024-11-302Awaiting replacement tubing.
FAC1004reserved80.3General bedRiverbend Urgent Careurgent care231 Riverbend RdFort WorthTX76107USARES-RB1004bed2024-06-14T10:00:002024-06-14T18:00:00PAT-3664General Ward2024-02-142024-08-142Bed reserved for minor injury patient.
FAC1005out of service0Geriatric bedSilver Pines LTC Facilitylong-term care115 Silver Pines BlvdBuffaloNY14221USARES-SP1005bedblankblankblankGeriatrics2024-05-102024-11-101Frame damaged, awaiting repair.
FAC1003available76.9Hydrotherapy tankMaple Rehabilitation Centerrehabilitation center88 Maple AveBurlingtonONL7R3A7CanadaRES-MRC1004otherblankblankblankPhysical Therapy2024-02-282024-08-285blank
FAC1006available56.7Pediatric CTPrairie Hospitalhospital490 Prairie AveWichitaKS67214USARES-PH1006CT scannerblankblankblankRadiology2024-04-112024-10-111Upgraded for child imaging protocols.
FAC1001occupied96.5Adult ventilatorSt. Gabriel Medical Centerhospital1200 Elm StSpringfieldIL62704USARES-A1002ventilator2024-06-10T19:00:002024-06-12T08:00:00PAT-4212ICU2024-03-152024-09-151Ventilator used for respiratory arrest case.

What the 200 rows show

from the 200-row sample

Occupied (resource status) stands out: mean utilization_rate is 92.6, against 34.9 for the rest.

  • 33.4median utilization_rate
  • 2address countries
  • 5facility types
  • 7resource types
  • 11departments
  • 30address states
Mean utilization_rate by resource_status200 rows
05010035.3availa…110 rows92.6occupi…24 rows3.1under …27 rows87.3reserv…25 rows0.06out of…14 rows
utilization_rate200 rows, in bands of 10
0204039262725149482226050100utilization_rate →

Median 33.4, from 0.0 to 99.5.

resource_subtype185 rows with a value · 15 left blank
  1. General bed52
  2. ICU bed16
  3. Geriatric bed16
  4. Portable ECG14
  5. Chemotherapy pump13
  6. Hydrotherapy tank12
  7. Adult ventilator10
  8. Nutrition pump10
  9. Speech therapy booth9
  10. Pediatric CT8
21 columns by typefrom the column list below
  • string 15
  • integer 1
  • float 1
  • date 2
  • datetime 2

Columns

21 columns in three groups
blueprint · 21 columns
columntypedescriptionexample
Text 15 columns
facility_idstringUnique identifier for the healthcare facilityFAC1001
facility_namestringName of the healthcare facilityGreen Valley Clinic
facility_typestringType of healthcare facility (e.g., hospital, clinic, urgent care)5 valueshospital
address_streetstringStreet address of the facility1200 Elm St
address_citystringCity where the facility is locatedSpringfield
address_statestringState or province of the facilityIL
address_postal_codestringPostal or ZIP code of the facility62704
address_countrystringCountry where the facility is located2 countriesUSA
resource_idstringUnique identifier for the medical resource (equipment or bed)uniqueRES-A1001
resource_typestringType of resource (e.g., bed, ventilator, MRI machine)7 valuesbed
resource_subtypestringSubtype or classification of the resource (e.g., ICU bed, general bed, pediatric ventilator)optionalICU bed
resource_statusstringCurrent status of the resource (e.g., available, occupied, under maintenance, reserved)5 valuesoccupied
patient_idstringUnique identifier for the patient occupying the resource (if applicable)optionalPAT-4221
departmentstringDepartment within the facility where the resource is located (e.g., ICU, ER, radiology)11 departments · optionalICU
notesstringAdditional notes or comments about the resource or occupancyoptionalFamily suite.
Numbers 2 columns
resource_capacityintegerCapacity of the resource (e.g., number of beds in a room, slots in a machine)1 or more · optional1
utilization_ratefloatPercentage of time the resource has been utilized over a defined period (0-100)0 to 100 · optional94.2
Dates and times 4 columns
occupancy_start_datetimedatetimeTimestamp when the resource was occupied or reservedoptional2024-06-12T08:21:00
occupancy_end_datetimedatetimeTimestamp when the resource was released or became availableoptional2024-06-13T15:45:00
last_maintenance_datedateDate when the resource last underwent maintenanceoptional2024-03-12
next_maintenance_due_datedateDate when the next maintenance is scheduled for the resourceoptional2024-09-12

Use it for

  • median utiliza…33.4200 rowsmean utilization rate…35.3avai…92.6occu…3.1unde…87.3rese…

    A healthcare dashboard

    Utilization_rate by resource_status and a breakdown of resource_subtype. Excel, Power BI or Tableau.

  • Why do the 24 occupied rows have a mean utilization_rate of 92.6?

    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 facilities with facility_name, facility_type and address_street to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 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 rows21 columns
Yours1,000 rows21 columnsaddress_street: UK only

blueprint · healthcare-resource-utilization-dataset

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 21 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 equipment type and location
  • Log occupancy timestamps
  • Flag unused resources
  • Aggregate by department
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
healthcare-resource-utilization-dataset

More in Healthcare

Browse all
Also in HealthcareHealthcare Facility Resource UtilizationPharmacy Inventory ForecastingClaims Denials and Rejection ManagementAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.