Urgent Hospital Supply Deliveries

This dataset provides detailed logs of urgent medical supply deliveries to hospitals, capturing shipment contents, delivery routes, timing, vehicle and driver details, and on-time performance. Designed to support supply chain resilience and AI-driven allocation, it enables analysis of delivery efficiency, incident patterns, and resource utilization across emergency medical logistics networks.

  • last updated 21 Jul 2025
  • by GoMask
The brief that made it

Analyze on-time performance and identify supply chain bottlenecks in emergency medical deliveries

Sample rows

preview · 8 of 200 rows · all 27 columns
delivery_idstringvehicle_typestringroute_duration_minutesintegeron_timebooleanhospital_statestringshipment_idstringhospital_idstringhospital_namestringhospital_street_addressstringhospital_citystringhospital_postal_codestringhospital_countrystringshipment_typestringshipment_prioritystringquantityintegerunitstringdispatch_timedatetimeexpected_delivery_timedatetimeactual_delivery_timedatetimedelay_minutesintegerroute_idstringroute_distance_kmfloatvehicle_idstringdriver_idstringincident_reportedbooleanincident_descriptionstringnotesstring
DEL-0001van240trueNYSHIP-0001HSP-001Metro General Hospital123 Main StNew York10001USAPPEcritical750boxes2023-11-01T07:10:00Z2023-11-01T11:10:00Z2023-11-01T11:10:00Z0RTE-101350.5VEH-0001DRV-001falseblankBulk PPE delivery for city-wide restocking
DEL-0002ambulance60falseMASHIP-0002HSP-002St. Francis Medical Center200 5th AveBoston02118USAbloodcritical8liters2023-11-01T09:45:00Z2023-11-01T10:45:00Z2023-11-01T10:50:00Z5RTE-10225.8VEH-0002DRV-002trueBrief traffic congestion near hospital entranceUrgent delivery for emergency surgery
DEL-0003ambulance60falseCASHIP-0003HSP-003Riverside Regional Hospital500 River RdSacramento95814USAventilatorcritical3units2023-11-02T16:00:00Z2023-11-02T17:00:00Z2023-11-02T17:10:00Z10RTE-10319.6VEH-0003DRV-003falseblankCritical ventilator transfer; minor delay due to loading
DEL-0004van330trueILSHIP-0004HSP-004Lakeside Medical Center760 Lakeview DrChicago60616USAPPEhigh1200masks2023-11-03T10:40:00Z2023-11-03T16:10:00Z2023-11-03T16:10:00Z0RTE-104590.2VEH-0004DRV-004falseblankScheduled PPE restock
DEL-0005van360trueMNSHIP-0005HSP-005University Hospital North88 University AveMinneapolis55415USAsyringeshigh2500units2023-11-04T07:00:00Z2023-11-04T13:00:00Z2023-11-04T13:00:00Z0RTE-105410.7VEH-0005DRV-005falseblankRoutine supply shipment
DEL-0006drone120falseMASHIP-0006HSP-002St. Francis Medical Center200 5th AveBoston02118USAtest kitshigh450kits2023-11-04T08:30:00Z2023-11-04T10:30:00Z2023-11-04T10:31:00Z1RTE-10642.5VEH-0006DRV-006trueDrone battery warning; landing delayedSplit shipment: urgent COVID-19 test kits
DEL-0007van1140falseCOSHIP-0007HSP-006Westfield Healthcare Center50 Westfield BlvdDenver80218USAPPEnormal9800gloves2023-11-05T13:20:00Z2023-11-06T08:20:00Z2023-11-06T10:20:00Z120RTE-107820.1VEH-0007DRV-007trueSevere snowstorm, required detourMajor delay due to weather; bulk PPE resupply
DEL-0008van120falseGASHIP-0008HSP-007Pinecrest Medical Center89 Pinecrest DrAtlanta30309USAinsulinhigh120vials2023-11-05T14:10:00Z2023-11-05T16:10:00Z2023-11-05T16:11:00Z1RTE-10838.7VEH-0008DRV-008falseblankInsulin delivery for diabetic patients

What the 200 rows show

from the 200-row sample

Van (vehicle type) stands out: mean route_duration_minutes is 304.0, against 58.8 for the rest.

  • 56%on_time = true
  • 240median route_duration_minutes
  • 3shipment priorities
  • 12units
  • 13shipment types
  • 56hospitals
Mean route_duration_minutes by vehicle_type200 rows
0200400304.0van146 rows45.2ambulance33 rows80.2drone21 rows
route_duration_minutes200 rows, in bands of 200
05010096702940106001,200route_duration_minutes →

Median 240, from 20 to 1,140.

hospital_state200 rows · top 10 of 37 values
  1. CA26
  2. TX14
  3. NY10
  4. OH10
  5. IL9
  6. CO8
  7. WA8
  8. FL7
  9. OR7
  10. PA7
27 columns by typefrom the column list below
  • string 18
  • integer 3
  • float 1
  • datetime 3
  • boolean 2

Columns

27 columns in four groups
blueprint · 27 columns
columntypedescriptionexample
Text 18 columns
delivery_idstringUnique identifier for each urgent supply delivery eventuniqueDEL-0001
shipment_idstringUnique identifier for the medical shipment being deliveredSHIP-0001
hospital_idstringUnique identifier for the hospital receiving the deliveryHSP-001
hospital_namestringName of the hospital receiving the deliveryMetro General Hospital
hospital_street_addressstringStreet address of the hospital123 Main St
hospital_citystringCity where the hospital is locatedNew York
hospital_statestringState or province where the hospital is locatedNY
hospital_postal_codestringPostal code of the hospital10001
hospital_countrystringCountry where the hospital is locatedUSA
shipment_typestringType of medical supplies in the shipment (e.g., blood, PPE, ventilator)PPE
shipment_prioritystringPriority level of the shipment (e.g., critical, high, normal)critical · high · normalcritical
unitstringUnit of measurement for the quantity (e.g., units, boxes, liters)12 unitsboxes
route_idstringUnique identifier for the delivery route takenRTE-101
vehicle_idstringUnique identifier for the delivery vehicleVEH-0001
vehicle_typestringType of vehicle used for delivery (e.g., ambulance, van, drone)3 typesvan
driver_idstringUnique identifier for the delivery driver or operatorDRV-001
incident_descriptionstringDescription of any incident that occurred during the delivery (empty if none)optionalHeavy traffic on I-25.
notesstringAdditional notes or comments about the deliveryoptionalScheduled PPE restock
Numbers 4 columns
quantityintegerQuantity of items in the shipment1 or more750
delay_minutesintegerNumber of minutes the delivery was delayed (0 if on time or early)0 or more0
route_distance_kmfloatTotal distance of the delivery route in kilometers0 or more350.5
route_duration_minutesintegerPlanned duration of the delivery route in minutes1 or more240
Dates and times 3 columns
dispatch_timedatetimeDate and time when the shipment was dispatched2023-11-01T07:10:00Z
expected_delivery_timedatetimeDate and time the shipment is expected to arrive at the hospital2023-11-01T11:10:00Z
actual_delivery_timedatetimeActual date and time the shipment arrived at the hospital2023-11-01T11:10:00Z
True or false 2 columns
on_timebooleanIndicates if the delivery was on time (true) or late (false)true
incident_reportedbooleanIndicates if any incident occurred during the deliveryfalse

Use it for

  • on time56%113 of 200 rowsmean route duration m…304.0van45.2ambula…80.2drone

    A logistics dashboard

    The on_time rate, route_duration_minutes by vehicle_type and a breakdown of hospital_state. Excel, Power BI or Tableau.

  • Why do the 146 van rows have a mean route_duration_minutes of 304.0?

    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 deliveries with shipment_id, hospital_id and hospital_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 27 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 rows27 columns
Yours1,000 rows27 columnshospital_street_address: UK only

blueprint · urgent-hospital-supply-deliveries

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 27 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
  • Emergency shipments flagged with urgency rating
  • Delivery times affected by traffic, weather, and stockouts
  • Route selection based on real-world constraints
  • Include failed and rerouted deliveries
  • Shipment contents matched to hospital department needs
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
urgent-hospital-supply-deliveries

More in Logistics

Browse all
Also in LogisticsSupply Chain Route Efficiency DataLogistics Shipment Delay PredictionWarehouse Inventory Flow DatasetAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.