Healthcare
21 columns
200 rows
8 formats

Healthcare Facility Resource Utilization

This dataset provides detailed, time-stamped records of healthcare facility resource utilization by department, including capacity, usage, and availability for key assets such as beds, equipment, and staff. It enables operational efficiency analytics, resource planning, and real-time monitoring to optimize healthcare delivery and manage surge scenarios.

last updated 20 Aug 2025
by GoMask

The brief that made it

Hospital operational efficiency analysis

Sample rows

preview · 8 of 200 rows · all 21 columns

facility_idstring	department_namestring	resource_capacityinteger	facility_citystring	facility_namestring	facility_street_addressstring	facility_statestring	facility_postal_codestring	facility_countrystring	department_idstring	resource_typestring	resource_idstring	resource_namestring	utilization_datedate	utilization_timestring	utilization_period_startdatetime	utilization_period_enddatetime	resource_in_useinteger	resource_availableinteger	utilization_ratefloat	notesstring
FAC001	Emergency	20	New York	Metropolitan General Hospital	123 Main St	NY	10001	USA	DEP100	bed	BED-1001	Emergency Bed 1	2024-06-09	02:15	blank	blank	19	1	95	High usage during overnight shift.
FAC002	ICU	8	Chicago	Lakeside Medical Center	456 Lake Ave	IL	60601	USA	DEP101	ventilator	VENT-1012	ICU Ventilator 2	2024-06-10	01:45	blank	blank	8	0	100	All ventilators occupied due to respiratory emergencies.
FAC003	Pediatrics	15	Los Angeles	Sunrise Children Hospital	789 Sunrise Blvd	CA	90001	USA	DEP102	bed	BED-1023	Pediatric Bed 3	2024-06-08	14:05	blank	blank	12	3	80	Post-flu season peak.
FAC004	Cardiology	2	Houston	Midtown Cardiology Center	334 Heart St	TX	77002	USA	DEP103	equipment	EQ-1031	ECG Machine	2024-06-01	blank	2024-06-01T09:00:00	2024-06-01T11:00:00	1	1	50	Routine scan; one machine under maintenance.
FAC005	Laboratory	5	Phoenix	Green Valley Clinic	blank	AZ	85001	USA	DEP104	staff	ST-1045	Lab Technician	2024-06-07	13:30	blank	blank	2	3	40	Reduced staff due to annual leave.
FAC006	Radiology	1	Toronto	Westside Oncology Center	212 Cancer Rd	ON	M5G1X5	Canada	DEP105	equipment	EQ-1058	CT Scanner	2024-06-09	blank	2024-06-09T10:30:00	2024-06-09T13:30:00	0	1	0	Scheduled calibration, not in use.
FAC007	ICU	4	London	Central London Hospital	45 King St	England	EC1A1BB	UK	DEP106	ventilator	VENT-1067	ICU Ventilator 7	2024-06-06	04:00	blank	blank	0	4	0	Ventilators ready for emergency use.
FAC001	Emergency	8	New York	Metropolitan General Hospital	123 Main St	NY	10001	USA	DEP100	staff	ST-1008	ER Nurse	2024-06-10	03:10	blank	blank	7	1	87.5	Night shift, one nurse on break.
FAC008	Pediatrics	18	San Francisco	Bay Area Children's Hospital	201 Bay St	CA	94102	USA	DEP107	bed	BED-1074	Pediatric Bed 4	2024-05-30	09:00	blank	blank	16	2	88.8889	Peak admissions after flu outbreak.
FAC009	Pharmacy	1000	Boston	Riverfront Medical Center	321 River Rd	MA	02118	USA	DEP108	other	blank	Vaccine Inventory	2024-06-02	11:30	blank	blank	950	50	95	High vaccine demand; restock scheduled.
FAC010	Emergency	25	Montreal	Montreal General Hospital	400 Rue Sainte-Catherine	QC	H3B1A1	Canada	DEP109	bed	BED-1092	Emergency Bed 2	2024-06-05	23:50	blank	blank	25	0	100	Full occupancy due to accident.
FAC011	Radiology	2	Dallas	Hilltop Health Center	222 Summit Ave	TX	75201	USA	DEP110	equipment	EQ-1103	MRI Machine	2024-06-06	blank	2024-06-06T12:00:00	2024-06-06T15:00:00	1	1	50	Routine scans scheduled.
FAC012	Laboratory	4	Seattle	West End Family Clinic	blank	WA	98101	USA	DEP111	staff	ST-1117	Lab Assistant	2024-06-03	16:45	blank	blank	2	2	50	Afternoon shift, half staff present.
FAC013	Pediatrics	12	London	Royal Children's Hospital	10 Royal Rd	England	WC2N5DU	UK	DEP112	bed	BED-1126	Pediatric Bed 6	2024-06-01	12:10	blank	blank	10	2	83.3333	Admissions steady after allergy season.
FAC014	ICU	5	Houston	Downtown Health Campus	88 City Dr	TX	77002	USA	DEP113	ventilator	VENT-1135	ICU Ventilator 5	2024-06-02	05:20	blank	blank	5	0	100	All ventilators in use, critical cases.
FAC015	Radiology	6	Toronto	Maple Leaf Medical Centre	77 Maple St	ON	M5V2H1	Canada	DEP114	staff	ST-1143	Radiology Nurse	2024-06-05	14:20	blank	blank	4	2	66.6667	One nurse on leave; moderate workload.
FAC016	Pharmacy	500	Boston	Eastside Community Hospital	155 East St	MA	02109	USA	DEP115	other	blank	Medication Inventory	2024-06-04	10:05	blank	blank	300	200	60	Medication restocked after shortage.
FAC017	Emergency	18	Seattle	Northern Heights Hospital	300 Heights Ln	WA	98102	USA	DEP116	bed	BED-1168	Emergency Bed 8	2024-06-08	00:30	blank	blank	15	3	83.3333	Busy night shift, trauma cases.
FAC018	ICU	7	San Francisco	Harborview Medical Center	blank	CA	94103	USA	DEP117	ventilator	VENT-1179	ICU Ventilator 9	2024-06-09	03:45	blank	blank	6	1	85.7143	One ventilator reserved for emergencies.
FAC019	Laboratory	4	Toronto	Evergreen Family Clinic	22 Evergreen Rd	ON	M4B1B3	Canada	DEP118	staff	ST-1184	Lab Supervisor	2024-06-07	08:00	blank	blank	3	1	75	Morning shift, one staff absent.

What the 200 rows show

from the 200-row sample

Pharmacy (department name) stands out: mean resource_capacity is 787.0, against 9.0 for the rest.

8median resource_capacity
3facility countries
5resource types
19facility states
6median resource_in_use
1median resource_available

Mean resource_capacity by department_name200 rows

resource_capacity200 rows, in bands of 100

Median 8, from 1 to 1,000.

facility_city200 rows · top 10 of 35 values

Toronto25
London21
Chicago19
Boston18
New York13
Seattle13
Los Angeles10
San Francisco10
Dallas9
San Diego8

21 columns by typefrom the column list below

string 14
integer 3
float 1
date 1
datetime 2

Columns

21 columns in three groups

blueprint · 21 columns
column	type	description	example
Text 14 columns
`facility_id`	string	Unique identifier for the healthcare facility	FAC001
`facility_name`	string	Name of the healthcare facility	Lakeside Medical Center
`facility_street_address`	string	Street address of the healthcare facilityoptional	123 Main St
`facility_city`	string	City where the healthcare facility is locatedoptional	New York
`facility_state`	string	State or region of the healthcare facilityoptional	NY
`facility_postal_code`	string	Postal code of the healthcare facilityoptional	10001
`facility_country`	string	Country where the healthcare facility is located3 countries · optional	USA
`department_id`	string	Unique identifier for the department within the facility	DEP100
`department_name`	string	Name of the department (e.g., Emergency, ICU, Radiology)7 names	Emergency
`resource_type`	string	Type of resource being tracked (e.g., bed, ventilator, staff, equipment)bed · ventilator · staff · equipment · other	bed
`resource_id`	string	Unique identifier for the specific resource (if applicable)optional	BED-1001
`resource_name`	string	Name or description of the resource (e.g., Nurse, CT Scanner)optional	Emergency Bed 1
`utilization_time`	string	Time of resource utilization measurement (HH:MM format)optional	02:15
`notes`	string	Additional notes or comments about resource utilizationoptional	Post-flu season peak.
Numbers 4 columns
`resource_capacity`	integer	Total capacity of the resource (e.g., total beds, total ventilators)0 or more	20
`resource_in_use`	integer	Number of resources currently in use0 or more	19
`resource_available`	integer	Number of resources currently available0 or more	1
`utilization_rate`	float	Percentage of resource utilization (resource_in_use / resource_capacity * 100)0 to 100 · optional	95
Dates and times 3 columns
`utilization_date`	date	Date of resource utilization measurement	2024-06-09
`utilization_period_start`	datetime	Start timestamp of the utilization period (if tracking over intervals)optional	2024-06-01T09:00:00
`utilization_period_end`	datetime	End timestamp of the utilization period (if tracking over intervals)optional	2024-06-01T11:00:00

Use it for

A healthcare dashboard
Resource_capacity by department_name and a breakdown of facility_city. Excel, Power BI or Tableau.
Why do the 23 Pharmacy rows have a mean resource_capacity of 787.0?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Facilities200
FAC00120Emergency
FAC0028ICU
FAC00315Pediatri…
A software demo
Believable facilities with facility_name, facility_street_address and facility_city to fill a screen in front of a buyer.

This dataset200 rows21 columns

Yours1,000 rows21 columnsfacility_street_address: UK only

blueprint · healthcare-facility-resource-utilization

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

Resource types categorized
Department mapped
Usage hours logged
Peak usage periods identified

Rows1,000 rows10,000 rows100,000 rows1,000,000 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-facility-resource-utilization

What should your data show?

No signup. No card.

Sample rows

What the 200 rows show

Columns

Use it for

A healthcare dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Healthcare

What should your data show?