Hospital Equipment Usage Schedules
This dataset provides detailed, time-stamped logs of high-value hospital equipment usage, including scheduling, actual usage, responsible staff, downtime events, and usage purposes. It enables hospitals to optimize resource allocation, minimize equipment downtime, and analyze utilization patterns for operational efficiency and patient care improvement.
Sample rows
preview · 8 of 200 rows · all 19 columns| usage_idstring | usage_statusstring | downtime_flagboolean | equipment_typestring | equipment_idstring | equipment_namestring | hospital_idstring | hospital_namestring | departmentstring | scheduled_start_timedatetime | scheduled_end_timedatetime | actual_start_timedatetime | actual_end_timedatetime | user_idstring | user_rolestring | patient_idstring | purposestring | downtime_reasonstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USG-00001 | completed | false | MRI | EQ-001 | Siemens Magnetom Aera MRI Scanner | HSP-001 | North Valley Medical Center | Radiology | 2024-01-05T09:00:00 | 2024-01-05T09:45:00 | 2024-01-05T09:02:00 | 2024-01-05T09:47:00 | USR-1001 | radiologist | PAT-2001 | diagnostic | blank | Brain MRI completed. Patient arrived 2 minutes late. |
| USG-00002 | completed | false | CT Scanner | EQ-002 | GE Revolution CT Scanner | HSP-002 | Eastside General Hospital | Radiology | 2024-01-06T14:30:00 | 2024-01-06T15:10:00 | 2024-01-06T14:31:00 | 2024-01-06T15:11:00 | USR-1012 | technician | PAT-2012 | diagnostic | blank | CT scan performed for abdominal pain. No delays. |
| USG-00003 | completed | false | Ventilator | EQ-003 | Dräger Evita Infinity V500 Ventilator | HSP-003 | Central City Hospital | ICU | 2024-01-07T23:00:00 | 2024-01-08T07:00:00 | 2024-01-07T23:02:00 | 2024-01-08T07:00:00 | USR-1020 | nurse | PAT-2020 | treatment | blank | Ventilator used for overnight respiratory support. |
| USG-00004 | scheduled | false | Ultrasound | EQ-004 | Philips Affiniti 70 Ultrasound | HSP-004 | West End Regional Hospital | Obstetrics | 2024-01-08T10:00:00 | 2024-01-08T10:30:00 | blank | blank | USR-1031 | technician | PAT-2030 | diagnostic | blank | Reserved for routine prenatal ultrasound. |
| USG-00005 | completed | false | Patient Monitor | EQ-005 | Mindray BeneVision N22 Patient Monitor | HSP-003 | Central City Hospital | ICU | 2024-01-08T19:00:00 | 2024-01-09T07:00:00 | 2024-01-08T19:01:00 | 2024-01-09T07:05:00 | USR-1040 | nurse | PAT-2040 | treatment | blank | Patient monitoring overnight. All readings stable. |
| USG-00006 | scheduled | false | Hospital Bed | EQ-006 | Hillrom Progressa Hospital Bed | HSP-005 | Lakeside Community Hospital | ICU | 2024-01-09T10:00:00 | 2024-01-09T19:00:00 | blank | blank | USR-1050 | nurse | PAT-2050 | treatment | blank | Bed reserved for new ICU admission. |
| USG-00007 | cancelled | false | CT Scanner | EQ-002 | GE Revolution CT Scanner | HSP-002 | Eastside General Hospital | Radiology | 2024-01-10T13:00:00 | 2024-01-10T13:40:00 | blank | blank | blank | blank | blank | diagnostic | blank | Appointment cancelled due to patient no-show. |
| USG-00008 | delayed | true | Surgical Table | EQ-007 | Maquet Magnus Surgical Table | HSP-006 | Southside Surgical Center | Surgery | 2024-01-10T08:00:00 | 2024-01-10T12:00:00 | 2024-01-10T08:03:00 | 2024-01-10T12:30:00 | USR-1060 | surgeon | PAT-2060 | treatment | unexpected failure | Surgery delayed due to table malfunction. Repairs completed quickly. |
| USG-00009 | completed | false | Endoscope | EQ-008 | Olympus EVIS EXERA III Video Endoscope | HSP-007 | Greenfield Medical Pavilion | Gastroenterology | 2024-01-11T13:30:00 | 2024-01-11T14:15:00 | 2024-01-11T13:31:00 | 2024-01-11T14:18:00 | USR-1071 | technician | PAT-2071 | treatment | blank | Endoscopy for GI bleed. No issues reported. |
| USG-00010 | completed | false | Dialysis Machine | EQ-009 | Fresenius 4008S Dialysis Machine | HSP-008 | Riverbend Nephrology Center | Nephrology | 2024-01-12T07:00:00 | 2024-01-12T11:00:00 | 2024-01-12T07:01:00 | 2024-01-12T11:02:00 | USR-1082 | technician | PAT-2082 | treatment | blank | Routine hemodialysis session. Minor blood pressure dip. |
| USG-00011 | completed | false | Ophthalmic Surgery Device | EQ-010 | Haag-Streit Surgical Microscope | HSP-009 | Sunrise Eye Institute | Ophthalmology | 2024-01-13T09:30:00 | 2024-01-13T11:00:00 | 2024-01-13T09:33:00 | 2024-01-13T11:03:00 | USR-1093 | surgeon | PAT-2093 | treatment | blank | Cataract surgery completed successfully. 3 min delay. |
| USG-00012 | delayed | true | C-arm | EQ-011 | Ziehm Vision RFD Mobile C-arm | HSP-010 | Downtown Orthopedic Hospital | Orthopedics | 2024-01-14T15:00:00 | 2024-01-14T16:30:00 | 2024-01-14T15:04:00 | 2024-01-14T16:50:00 | USR-1104 | technician | PAT-2104 | treatment | repair | C-arm required emergency repair during procedure. |
| USG-00013 | scheduled | false | MRI | EQ-001 | Siemens Magnetom Aera MRI Scanner | HSP-001 | North Valley Medical Center | Radiology | 2024-01-15T08:00:00 | 2024-01-15T08:45:00 | blank | blank | USR-1003 | radiologist | PAT-2003 | diagnostic | blank | Scheduled for knee MRI. Awaiting patient arrival. |
| USG-00014 | completed | false | Defibrillator | EQ-012 | Philips HeartStart XL Defibrillator | HSP-011 | Brighton Emergency Care | Emergency | 2024-01-15T14:10:00 | 2024-01-15T14:25:00 | 2024-01-15T14:11:00 | 2024-01-15T14:26:00 | USR-1115 | emergency physician | PAT-2115 | treatment | blank | Defibrillator used for cardiac arrest. ROSC achieved. |
| USG-00015 | cancelled | false | CT Scanner | EQ-013 | Canon Aquilion Lightning CT Scanner | HSP-012 | Starlight Regional Hospital | Radiology | 2024-01-16T11:00:00 | 2024-01-16T11:40:00 | blank | blank | blank | blank | blank | diagnostic | blank | Session cancelled due to patient transfer. |
| USG-00016 | completed | false | Ultrasound | EQ-014 | GE Venue Go Portable Ultrasound | HSP-002 | Eastside General Hospital | Cardiology | 2024-01-17T15:00:00 | 2024-01-17T15:30:00 | 2024-01-17T15:02:00 | 2024-01-17T15:33:00 | USR-1015 | physician | PAT-2015 | diagnostic | blank | Cardiac echo performed for new murmur. |
| USG-00017 | completed | false | Hospital Bed | EQ-015 | GE Healthcare BiliSoft Phototherapy System | HSP-013 | Meadowbrook Pediatrics Hospital | Pediatrics | 2024-01-18T13:00:00 | 2024-01-18T17:00:00 | 2024-01-18T13:01:00 | 2024-01-18T17:03:00 | USR-1127 | pediatrician | PAT-2127 | treatment | blank | Phototherapy for neonatal jaundice. |
| USG-00018 | completed | false | Mobile X-ray | EQ-016 | Ziehm Vision RFD Mobile X-ray | HSP-014 | Riverside Trauma Center | Emergency | 2024-01-19T10:20:00 | 2024-01-19T10:45:00 | 2024-01-19T10:21:00 | 2024-01-19T10:47:00 | USR-1135 | technician | PAT-2135 | diagnostic | blank | Chest X-ray for trauma patient. No complications. |
| USG-00019 | completed | false | Patient Monitor | EQ-017 | Philips IntelliVue MX800 Patient Monitor | HSP-015 | Harborview ICU Center | ICU | 2024-01-20T20:00:00 | 2024-01-21T06:00:00 | 2024-01-20T20:02:00 | 2024-01-21T06:02:00 | USR-1140 | nurse | PAT-2140 | treatment | blank | Patient monitored overnight post-op. |
| USG-00020 | scheduled | false | C-arm | EQ-018 | GE OEC Elite C-arm | HSP-010 | Downtown Orthopedic Hospital | Orthopedics | 2024-01-21T09:30:00 | 2024-01-21T11:00:00 | blank | blank | USR-1106 | technician | PAT-2106 | treatment | blank | C-arm reserved for orthopedic procedure. |
What the 200 rows show
from the 200-row sampleDelayed (usage status) stands out: 24 of its 24 rows have downtime_
- 16%downtime_
flag = true - 4purposes
- 4downtime reasons
- 7user roles
- 11departments
- 30hospitals
- string 14
- datetime 4
- boolean 1
Columns
19 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
usage_id | string | Unique identifier for each equipment usage log entry.unique | USG-00001 |
equipment_id | string | Unique identifier for the equipment being used. | EQ-001 |
equipment_name | string | Descriptive name of the equipment. | GE Revolution CT Scanner |
equipment_type | string | Type or category of the equipment (e.g., MRI, CT Scanner, Ventilator). | MRI |
hospital_id | string | Unique identifier for the hospital where the equipment is located. | HSP-001 |
hospital_name | string | Name of the hospital where the equipment is used. | Central City Hospital |
department | string | Hospital department where the equipment is located or used (e.g., Radiology, ICU).11 departments | Radiology |
usage_status | string | Status of the usage session (e.g., scheduled, in_progress, completed, cancelled, delayed).scheduled · in_progress · completed · cancelled · delayed | completed |
user_id | string | Unique identifier for the primary staff member responsible for the equipment during this usage session.optional | USR-1001 |
user_role | string | Role of the staff member using the equipment (e.g., technician, nurse, physician).7 roles · optional | radiologist |
patient_id | string | Unique identifier for the patient (if applicable) associated with the equipment usage.optional | PAT-2001 |
purpose | string | Purpose or reason for the equipment usage (e.g., diagnostic, treatment, maintenance, training).4 purposes | diagnostic |
downtime_reason | string | Reason for downtime if downtime_flag is true (e.g., scheduled maintenance, repair, calibration, unexpected failure).4 reasons · optional | unexpected failure |
notes | string | Additional notes or comments about the equipment usage session.optional | Brain MRI completed. Pati… |
| Dates and times 4 columns | |||
scheduled_start_time | datetime | Scheduled start time for equipment usage. | 2024-01-05T09:00:00 |
scheduled_end_time | datetime | Scheduled end time for equipment usage. | 2024-01-05T09:45:00 |
actual_start_time | datetime | Actual start time when the equipment usage began.optional | 2024-01-05T09:02:00 |
actual_end_time | datetime | Actual end time when the equipment usage ended.optional | 2024-01-05T09:47:00 |
| True or false 1 column | |||
downtime_flag | boolean | Indicates if this usage session includes downtime (e.g., due to maintenance or malfunction). | false |
Use it for
A healthcare dashboard
The downtime_
flag rate, downtime_ flag by usage_ status and a breakdown of equipment_ type. Excel, Power BI or Tableau. Why do 32 of 199 rows have downtime_
flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Usages200USG-00001completedUSG-00008delayedUSG-00012delayed
A software demo
Believable usages with equipment_
id, equipment_ name and equipment_ type to fill a screen in front of a buyer.
This dataset200 rows19 columns
Yours1,000 rows19 columns
blueprint · hospital-equipment-usage-schedules
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 19 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
- Equipment ID, department, and type logged.
- Usage start/end time per session.
- Maintenance status annotated.
- Unscheduled downtime flagged.
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-equipment-usage-schedules