Healthcare
20 columns
200 rows
8 formats

Hospital Resource Allocation Records

This dataset provides detailed, daily records of hospital resource allocation, including beds, staff, and critical equipment, across multiple facilities. It enables comprehensive monitoring of capacity, surge response, and operational readiness, supporting data-driven planning and crisis management in healthcare settings.

opened 10 times
last updated 29 Jul 2025
by GoMask

The brief that made it

Real-time hospital capacity monitoring and surge response planning

Sample rows

preview · 8 of 200 rows · all 20 columns

allocation_idstring	bed_typestring	beds_allocatedinteger	surge_statusboolean	staff_typestring	hospital_idstring	hospital_namestring	hospital_street_addressstring	hospital_citystring	hospital_statestring	hospital_postal_codestring	hospital_countrystring	allocation_datedate	beds_occupiedinteger	staff_allocatedinteger	staff_on_dutyinteger	equipment_typestring	equipment_allocatedinteger	equipment_in_useinteger	notesstring
AL001	general	120	true	nurse	HSP101	St. Anne Medical Center	480 Maple Ave	Boston	MA	02118	USA	2023-12-03	110	32	31	defibrillator	14	13	Winter surge, high occupancy throughout week
AL002	icu	40	true	doctor	HSP102	River Valley Hospital	215 Oak Blvd	Madison	WI	53703	USA	2024-01-10	37	18	17	ventilator	16	15	ICU at 92% occupancy, post-holiday spike
AL003	pediatric	28	true	nurse	HSP103	Westside Children's Clinic	701 Elm St	Denver	CO	80218	USA	2024-03-14	25	11	11	defibrillator	5	4	Flu season peak, full staffing required
AL004	surgical	60	false	support_staff	HSP104	Lakeside Surgery Institute	99 Lakeview Dr	Chicago	IL	60611	USA	2024-05-02	54	20	18	ecmo	10	8	Routine operations, elective surgeries resumed
AL005	maternity	20	false	nurse	HSP105	Maple Grove Hospital	3124 Woodrow Ln	Toronto	ON	M4W1A8	Canada	2023-11-18	17	7	7	ventilator	4	3	Moderate admissions, stable demand
AL006	general	85	true	doctor	HSP106	Northern Regional Center	448 Pine Crescent	Seattle	WA	98109	USA	2024-02-26	83	24	22	dialysis_machine	14	13	Near capacity, additional staff called in
AL007	icu	35	false	respiratory_therapist	HSP107	Glenridge Medical Center	109 Cypress Way	Dallas	TX	75219	USA	2024-04-13	28	13	12	ventilator	20	18	ICU below critical levels, routine monitoring
AL008	general	112	true	support_staff	HSP108	Pacific Community Hospital	52 Pacific Blvd	San Diego	CA	92103	USA	2024-05-20	101	37	36	defibrillator	15	14	High turnover, admissions up 20% this week
AL009	maternity	32	true	nurse	HSP109	Sunrise Women's Hospital	200 Sunrise Ave	Phoenix	AZ	85016	USA	2024-01-07	31	12	12	defibrillator	6	6	Peak winter surge, nearly all beds full
AL010	general	130	true	nurse	HSP110	Central Health Institute	81 Central Ave	Minneapolis	MN	55404	USA	2024-04-02	124	35	34	ventilator	18	17	End of quarter, max utilization
AL011	pediatric	19	false	doctor	HSP111	Redwood Family Hospital	490 Redwood Rd	Portland	OR	97227	USA	2023-12-21	16	7	6	ventilator	3	3	Pre-holiday admissions, stable
AL012	icu	22	true	respiratory_therapist	HSP112	Halifax General Hospital	2 South St	Halifax	NS	B3H2Y9	Canada	2024-02-14	21	11	10	ecmo	7	6	Respiratory admissions rising, staff at limit
AL013	maternity	14	true	nurse	HSP113	Sydney Bay Medical Center	88 Harbour Rd	Sydney	NSW	2000	Australia	2024-03-29	14	6	6	defibrillator	2	2	Full capacity, seasonal admissions spike
AL014	other	7	false	other	HSP114	Oslo University Hospital	10 Ringveien	Oslo	Oslo	0455	Norway	2024-04-06	5	2	2	other	1	1	Specialty care, low patient volume
AL015	general	12	false	support_staff	HSP115	Pinecrest Community Clinic	74 Cedar St	San Jose	CA	95116	USA	2024-01-26	9	3	2	other	1	1	Steady admissions, no surge activity
AL016	surgical	45	false	doctor	HSP116	Monterey Surgical Hospital	21 Seaside Dr	Monterey	CA	93940	USA	2024-05-18	39	17	16	defibrillator	12	11	Routine post-op care, moderate levels
AL017	icu	48	true	nurse	HSP117	Great Plains Hospital	1839 Meadow Rd	Omaha	NE	68114	USA	2023-12-14	45	22	20	ventilator	20	19	ICU at 94% occupancy, surge protocols active
AL018	surgical	27	false	support_staff	HSP118	Clinton Regional Hospital	67 Clinton St	Ottawa	ON	K1P5M6	Canada	2024-03-08	21	8	8	dialysis_machine	7	6	Surgical volume below average this week
AL019	other	3	false	other	HSP119	Springbrook Health Center	303 Main St	Springfield	MO	65807	USA	2024-02-01	0	1	0	other	0	0	Unused ward, closed for renovation
AL020	general	104	true	doctor	HSP120	Grand View Hospital	120 Grandview Rd	St. Louis	MO	63110	USA	2024-03-22	95	29	29	ventilator	12	12	High demand after local event

What the 200 rows show

from the 200-row sample

General (bed type) stands out: mean beds_allocated is 96.4, against 30.6 for the rest.

55%surge_status = true
35median beds_allocated
4hospital countries
5equipment types
54hospital states
32median beds_occupied

Mean beds_allocated by bed_type200 rows

beds_allocated200 rows, in bands of 25

Median 35, from 0 to 210.

staff_type200 rows · 5 values

nurse80
doctor43
support_staff41
other21
respiratory_therapist15

20 columns by typefrom the column list below

string 12
integer 6
date 1
boolean 1

Columns

20 columns in four groups

blueprint · 20 columns
column	type	description	example
Text 12 columns
`allocation_id`	string	Unique identifier for each allocation recordunique	AL001
`hospital_id`	string	Unique identifier for the hospital	HSP101
`hospital_name`	string	Official name of the hospital	St. Anne Medical Center
`hospital_street_address`	string	Street address of the hospitaloptional	480 Maple Ave
`hospital_city`	string	City where the hospital is locatedoptional	Boston
`hospital_state`	string	State or province where the hospital is locatedoptional	MA
`hospital_postal_code`	string	Postal or ZIP code of the hospitaloptional	02118
`hospital_country`	string	Country where the hospital is located4 countries · optional	USA
`bed_type`	string	Type of hospital bed (e.g., general, ICU, pediatric, maternity)6 values	general
`staff_type`	string	Type of staff (e.g., doctor, nurse, respiratory therapist, support staff)5 values	nurse
`equipment_type`	string	Type of critical equipment (e.g., ventilator, dialysis machine, ECMO, defibrillator)ventilator · dialysis_machine · ecmo · defibrillator · other	defibrillator
`notes`	string	Additional notes or comments regarding the allocation recordoptional	Routine ICU utilization.
Numbers 6 columns
`beds_allocated`	integer	Number of beds allocated for the specified type on the given date0 or more	120
`beds_occupied`	integer	Number of beds occupied for the specified type on the given date0 or more	110
`staff_allocated`	integer	Number of staff allocated for the specified type on the given date0 or more	32
`staff_on_duty`	integer	Number of staff present and on duty for the specified type on the given date0 or more	31
`equipment_allocated`	integer	Number of equipment units allocated for the specified type on the given date0 or more	14
`equipment_in_use`	integer	Number of equipment units currently in use for the specified type on the given date0 or more	13
Dates and times 1 column
`allocation_date`	date	Date for which the resource allocation record applies	2023-12-03
True or false 1 column
`surge_status`	boolean	Indicates if the hospital is in surge mode (true) or normal operation (false) on the allocation date	true

Use it for

A healthcare dashboard
The surge_status rate, beds_allocated by bed_type and a breakdown of staff_type. Excel, Power BI or Tableau.
Why do the 57 general rows have a mean beds_allocated of 96.4?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Allocations200
AL001120general
AL00240icu
AL00460surgical
A software demo
Believable allocations with hospital_id, hospital_name and hospital_street_address to fill a screen in front of a buyer.

This dataset200 rows20 columns

Yours1,000 rows20 columnshospital_street_address: UK only

blueprint · hospital-resource-allocation-records

Behind this dataset

Same schema. As many rows as you need.

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

Allocate by department and shift
Log total beds and equipment used
Track staff assignments
Flag over-allocated resources

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: hospital-resource-allocation-records

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?