Healthcare
25 columns
200 rows
8 formats

Emergency Department Resource Allocation

This dataset provides detailed, shift-level resource allocation and patient throughput metrics for emergency departments across hospitals. It includes staffing levels, bed usage, supply availability, patient flow statistics, and operational notes, enabling hospitals to optimize staffing and supply decisions, identify bottlenecks, and improve emergency care efficiency.

last updated 20 Aug 2025
by GoMask

The brief that made it

Optimizing emergency department staffing and scheduling

Sample rows

preview · 8 of 200 rows · all 25 columns

ed_idstring	address_countrystring	average_wait_time_minutesfloat	resource_shortages_flagboolean	shift_typestring	hospital_idstring	hospital_namestring	address_streetstring	address_citystring	address_statestring	address_postal_codestring	report_datedate	staff_physicians_countinteger	staff_nurses_countinteger	staff_support_countinteger	bed_count_totalinteger	bed_count_occupiedinteger	patient_arrivals_countinteger	patient_admitted_countinteger	patient_discharged_countinteger	patient_left_without_being_seen_countinteger	average_length_of_stay_minutesfloat	critical_supplies_availableinteger	critical_supplies_usedinteger	notesstring
ED001	USA	51.2	true	day	HOSP001	Central University Hospital	123 Main St	Boston	MA	02115	2024-06-01	10	24	13	40	38	95	36	55	4	254.8	850	380	Resource shortage due to marathon surge, extra PPE required
ED002	USA	44.1	false	evening	HOSP002	Urban Trauma Center	456 Elm Ave	New York	NY	10032	2024-06-01	9	22	12	38	34	89	32	51	6	210.6	800	299	blank
ED003	USA	37.5	false	night	HOSP003	Midtown General Hospital	789 Oak Rd	Chicago	IL	60610	2024-06-01	8	20	11	36	30	74	28	43	3	186.7	700	142	blank
ED004	USA	35.2	false	day	HOSP004	Suburban Regional Medical Center	321 Pine St	Raleigh	NC	27607	2024-06-01	7	16	10	28	25	62	14	45	3	154.9	380	112	blank
ED005	USA	9.3	false	evening	HOSP005	Rural Care Clinic	17 Maple Lane	Bozeman	MT	59718	2024-06-01	2	4	2	8	5	12	2	8	2	47.2	22	6	Routine shift
ED006	Canada	23.5	false	night	HOSP006	Halifax General Hospital	1101 South St	Halifax	NS	B3H 2Y9	2024-06-01	5	13	7	24	18	41	10	30	1	118.6	170	47	blank
ED007	Canada	56.5	true	day	HOSP007	Toronto General Hospital	200 Elizabeth St	Toronto	ON	M5G 2C4	2024-06-01	11	27	14	44	42	110	39	68	3	280.5	990	370	Critical supply shortage, mass casualty event downtown
ED008	USA	28.6	false	evening	HOSP008	Green Valley Medical Center	75 Willow Dr	Denver	CO	80221	2024-06-01	6	15	8	22	17	47	11	34	2	108.5	210	62	blank
ED009	USA	9.7	false	night	HOSP009	Riverbend Community Hospital	300 River Rd	Columbus	OH	43201	2024-06-01	2	5	3	10	6	13	3	9	1	52.3	16	5	Low volume due to weather
ED010	USA	23.2	false	day	HOSP010	Children's Health Center	100 Rainbow Ave	Atlanta	GA	30309	2024-06-01	4	11	4	16	13	28	8	18	2	78.6	45	16	Routine pediatric shift
ED011	USA	54.6	true	day	HOSP001	Central University Hospital	123 Main St	Boston	MA	02115	2024-06-02	10	25	14	40	39	92	33	56	3	260.5	890	391	Shortage of medication, high patient volume after festival
ED012	USA	48.7	false	evening	HOSP002	Urban Trauma Center	456 Elm Ave	New York	NY	10032	2024-06-02	9	23	12	38	35	91	31	54	6	223.3	780	302	blank
ED013	USA	39.8	false	night	HOSP003	Midtown General Hospital	789 Oak Rd	Chicago	IL	60610	2024-06-02	8	19	10	36	30	77	29	45	3	192.3	720	157	blank
ED014	USA	36.8	false	day	HOSP004	Suburban Regional Medical Center	321 Pine St	Raleigh	NC	27607	2024-06-02	7	17	9	28	26	64	15	46	3	159.2	395	117	blank
ED015	USA	8.8	false	evening	HOSP005	Rural Care Clinic	17 Maple Lane	Bozeman	MT	59718	2024-06-02	2	3	2	8	4	9	1	7	1	44.9	18	3	Routine shift
ED016	Canada	22.7	false	night	HOSP006	Halifax General Hospital	1101 South St	Halifax	NS	B3H 2Y9	2024-06-02	4	12	8	24	15	38	9	28	1	111.9	160	45	blank
ED017	Canada	58.3	true	day	HOSP007	Toronto General Hospital	200 Elizabeth St	Toronto	ON	M5G 2C4	2024-06-02	12	28	14	45	45	120	40	77	3	278.2	1000	400	Surge after city festival, supply outage in ED
ED018	USA	29.8	false	evening	HOSP008	Green Valley Medical Center	75 Willow Dr	Denver	CO	80221	2024-06-02	6	14	8	22	18	48	12	34	2	110.2	215	71	blank
ED019	USA	4.5	false	night	HOSP009	Riverbend Community Hospital	300 River Rd	Columbus	OH	43201	2024-06-02	1	3	1	8	4	6	1	5	0	24.1	8	2	Routine shift
ED020	USA	19.7	false	day	HOSP010	Children's Health Center	100 Rainbow Ave	Atlanta	GA	30309	2024-06-02	3	10	4	15	12	25	7	17	1	67.3	39	12	Routine pediatric shift

What the 200 rows show

from the 200-row sample

13%resource_shortages_flag = true
25.1median average_wait_time_minutes
45address states
5median staff_physicians_count
13median staff_nurses_count
8median staff_support_count

address_country200 rows by value

average_wait_time_minutes200 rows, in bands of 10

Median 25.1, from 0.0 to 59.7.

shift_type200 rows · 3 values

day81
evening60
night59

25 columns by typefrom the column list below

string 10
integer 11
float 2
date 1
boolean 1

Columns

25 columns in four groups

blueprint · 25 columns
column	type	description	example
Text 10 columns
`ed_id`	string	Unique identifier for the emergency department location or unitunique	ED001
`hospital_id`	string	Unique identifier for the hospital	HOSP001
`hospital_name`	string	Name of the hospital	Urban Trauma Center
`address_street`	string	Street address of the hospital	123 Main St
`address_city`	string	City where the hospital is located	Boston
`address_state`	string	State or province of the hospital	MA
`address_postal_code`	string	Postal code of the hospital	02115
`address_country`	string	Country where the hospital is located2 countries	USA
`shift_type`	string	Type of shift (e.g., day, evening, night)day · evening · night	day
`notes`	string	Additional notes or comments for the shift (e.g., unusual events, surge conditions)optional	Routine shift
Numbers 13 columns
`staff_physicians_count`	integer	Number of physicians scheduled for the shift0 or more	10
`staff_nurses_count`	integer	Number of nurses scheduled for the shift0 or more	24
`staff_support_count`	integer	Number of support staff (e.g., technicians, clerks) scheduled for the shift0 or more	13
`bed_count_total`	integer	Total number of ED beds available during the shift0 or more	40
`bed_count_occupied`	integer	Number of ED beds occupied during the shift0 or more	38
`patient_arrivals_count`	integer	Number of patients arriving during the shift0 or more	95
`patient_admitted_count`	integer	Number of patients admitted to hospital from ED during the shift0 or more	36
`patient_discharged_count`	integer	Number of patients discharged from ED during the shift0 or more	55
`patient_left_without_being_seen_count`	integer	Number of patients who left ED without being seen during the shift0 or more	4
`average_wait_time_minutes`	float	Average patient wait time in minutes during the shift0 or more	51.2
`average_length_of_stay_minutes`	float	Average length of stay for patients in minutes during the shift0 or more	254.8
`critical_supplies_available`	integer	Number of critical supply units (e.g., PPE, medications) available at shift start0 or more	850
`critical_supplies_used`	integer	Number of critical supply units used during the shift0 or more	380
Dates and times 1 column
`report_date`	date	Date of resource allocation and throughput report	2024-06-01
True or false 1 column
`resource_shortages_flag`	boolean	Indicates if any resource shortages occurred during the shift	true

Use it for

A healthcare dashboard
The resource_shortages_flag rate, average_wait_time_minutes by address_country and a breakdown of shift_type. Excel, Power BI or Tableau.
Why do 25 of 200 rows have resource_shortages_flag = true?
A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
Eds200
ED00151.2USA
ED00244.1USA
ED00756.5Canada
A software demo
Believable eds with hospital_id, hospital_name and address_street to fill a screen in front of a buyer.

This dataset200 rows25 columns

Yours1,000 rows25 columnsaddress_street: UK only

blueprint · emergency-department-resource-allocation

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 25 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

Log patient arrival and triage data
Include resource usage per case
Track wait and treatment times
Flag resource shortages

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: emergency-department-resource-allocation

What should your data show?

No signup. No card.

Sample rows

What the 200 rows show

Columns

Use it for

A healthcare dashboard

A class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Healthcare

What should your data show?