Disaster Relief Supply Chain Tracker

This dataset provides a comprehensive, shipment-level view of disaster relief supply chain operations, capturing item details, facility locations, inventory levels, delivery timelines, transport modes, and bottleneck events. It enables nonprofits and logistics teams to analyze resource allocation efficiency, identify bottlenecks, and optimize delivery routes to maximize disaster response impact and minimize waste.

  • last updated 3 Feb 2026
  • by GoMask
The brief that made it

Analyze supply chain bottlenecks and delivery delays during disaster response

Sample rows

preview · 8 of 120 rows · all 33 columns
shipment_idstringitem_categorystringroute_estimated_duration_hrsfloatbottleneck_flagbooleanorigin_facility_idstringitem_idstringitem_namestringquantityintegerunit_of_measurestringorigin_facility_namestringorigin_street_addressstringorigin_citystringorigin_statestringorigin_postal_codestringorigin_countrystringdestination_facility_idstringdestination_facility_namestringdestination_street_addressstringdestination_citystringdestination_statestringdestination_postal_codestringdestination_countrystringroute_idstringroute_distance_kmfloatdeparture_datetimedatetimearrival_datetimedatetimedelivery_statusstringinventory_level_at_originintegerinventory_level_at_destinationintegertransport_modestringresource_allocation_efficiency_scorefloatdelay_reasonstringbottleneck_descriptionstring
SHP0001food8.1falseFCL001ITM1001Bottled Water12000unitsUS Foods Depot West8200 West AveHoustonTX77041USADST001Baytown Relief Camp4100 Bay StBaytownTX77520USARTTX01480.42024-02-02T09:32:002024-02-02T17:38:00delivered2100012000truck0.93blankblank
SHP0002food7.3falseFCL001ITM1002Canned Beans4500boxesUS Foods Depot West8200 West AveHoustonTX77041USADST002Dallas Feeding Center1250 Elm StDallasTX75201USARTTX02390.72024-02-03T10:07:002024-02-03T17:22:00delivered140004500truck0.9blankblank
SHP0003medical6.7falseFCL002ITM2001Medical Kits95boxesNationwide Med Supply101 Medpark BlvdChicagoIL60632USADST003St Vincent's Hospital4400 Mercy RdSpringfieldIL62703USARTIL03328.22024-02-03T11:24:002024-02-03T18:03:00delivered88095truck0.97blankblank
SHP0004medical4.1falseFCL002ITM2001Medical Kits85boxesNationwide Med Supply101 Medpark BlvdChicagoIL60632USADST004Greenfield Clinic North520 Clinic DrGreenfieldWI53220USARTILWI04149.52024-02-04T07:45:002024-02-04T11:52:00delivered79585truck0.96blankblank
SHP0005hygiene1.5falseFCL003ITM3001Family Hygiene Packs2100unitsCleanStart Hygiene Center200 Hygiene DrAtlantaGA30344USADST005Eastside Shelter910 Eastside DrAtlantaGA30316USARTGA0530.22024-02-05T08:19:002024-02-05T09:49:00delivered59002100truck0.99blankblank
SHP0006shelter4.3falseFCL004ITM4001All-Weather Tents250unitsSafeStay Shelter Storage1600 Shelter RdDenverCO80202USADST006Pueblo Camp Site2110 Campground AvePuebloCO81003USARTCO06179.62024-02-06T10:11:002024-02-06T14:25:00delivered900250truck0.94blankblank
SHP0007food6.8falseFCL001ITM1003Rice Bags7000unitsUS Foods Depot West8200 West AveHoustonTX77041USADST007Mission Outreach Center8830 Outreach StSan AntonioTX78207USARTTX07320.22024-02-07T07:32:002024-02-07T14:16:00delivered140007000truck0.91blankblank
SHP0008medical5.6falseFCL002ITM2002Antibiotic Packs120unitsNationwide Med Supply101 Medpark BlvdChicagoIL60632USADST008Hopewell Emergency Clinic3600 Hopewell RdPeoriaIL61602USARTIL08239.92024-02-08T08:33:002024-02-08T14:14:00delivered650120truck0.96blankblank

What the 120 rows show

from the 120-row sample

Other (item category) stands out: mean route_estimated_duration_hrs is 28.4, against 3.7 for the rest.

  • 8%bottleneck_flag = true
  • 3.7median route_estimated_duration_hrs
  • 2transport modes
  • 4delivery statuses
  • 5unit of measures
  • 17origin states
Mean route_estimated_duration_hrs by item_category120 rows
0501003.6food30 rows3.6shelter25 rows3.6medical32 rows4.3hygiene23 rows28.4other10 rows
route_estimated_duration_hrs120 rows, in bands of 10
060120114300000300050100route_estimated_duration_hrs →

Median 3.7, from 0.20 to 77.8.

origin_facility_id120 rows · top 10 of 28 values
  1. FCL00212
  2. FCL00412
  3. FCL00310
  4. FCL0019
  5. FCL3036
  6. FCL1145
  7. FCL1165
  8. FCL0064
  9. FCL1054
  10. FCL1104
33 columns by typefrom the column list below
  • string 24
  • integer 3
  • float 3
  • datetime 2
  • boolean 1

Columns

33 columns in four groups
blueprint · 33 columns
columntypedescriptionexample
Text 24 columns
shipment_idstringUnique identifier for each shipment transaction.uniqueSHP0001
item_idstringUnique identifier for the relief item being shipped.ITM1001
item_namestringDescriptive name of the relief item (e.g., water, blankets, medical kits).Bottled Water
item_categorystringCategory of the relief item (e.g., food, shelter, medical, hygiene).food · shelter · medical · hygiene · otherfood
unit_of_measurestringUnit of measurement for the item (e.g., boxes, pallets, liters).5 measuresunits
origin_facility_idstringUnique identifier for the facility dispatching the shipment.FCL001
origin_facility_namestringName of the origin facility or warehouse.US Foods Depot West
origin_street_addressstringStreet address of the origin facility.8200 West Ave
origin_citystringCity of the origin facility.Houston
origin_statestringState or province of the origin facility.TX
origin_postal_codestringPostal code of the origin facility.77041
origin_countrystringCountry of the origin facility.USA
destination_facility_idstringUnique identifier for the destination facility or relief site.DST001
destination_facility_namestringName of the destination facility or relief site.Baytown Relief Camp
destination_street_addressstringStreet address of the destination facility.4100 Bay St
destination_citystringCity of the destination facility.Baytown
destination_statestringState or province of the destination facility.TX
destination_postal_codestringPostal code of the destination facility.77520
destination_countrystringCountry of the destination facility.USA
route_idstringUnique identifier for the route taken by the shipment.optionalRTTX01
delivery_statusstringCurrent status of the shipment delivery.pending · in_transit · delivered · delayed · cancelleddelivered
delay_reasonstringReason for any delivery delay, if applicable.optionalWinter storm delayed arri…
transport_modestringMode of transport used for the shipment (e.g., truck, air, sea, rail).truck · air · sea · rail · othertruck
bottleneck_descriptionstringDescription of the bottleneck encountered, if any.optionalRoute blocked by snowstor…
Numbers 6 columns
quantityintegerNumber of units of the item in the shipment.1 or more12000
route_distance_kmfloatDistance in kilometers for the shipment route.0 or more · optional480.4
route_estimated_duration_hrsfloatEstimated duration in hours for the shipment route.0 or more · optional8.1
inventory_level_at_originintegerInventory level of the item at the origin facility at the time of shipment.0 or more · optional21000
inventory_level_at_destinationintegerInventory level of the item at the destination facility after arrival.0 or more · optional12000
resource_allocation_efficiency_scorefloatScore (0-1) indicating efficiency of resource allocation for this shipment.0 to 1 · optional0.93
Dates and times 2 columns
departure_datetimedatetimeDate and time when the shipment departed from the origin.2024-02-02T09:32:00
arrival_datetimedatetimeDate and time when the shipment arrived at the destination.optional2024-02-02T17:38:00
True or false 1 column
bottleneck_flagbooleanIndicates if this shipment experienced a supply chain bottleneck.false

Use it for

  • bottleneck flag8%10 of 120 rowsmean route estimated …3.6food3.6shel…3.6medi…4.3hygi…

    A logistics dashboard

    The bottleneck_flag rate, route_estimated_duration_hrs by item_category and a breakdown of origin_facility_id. Excel, Power BI or Tableau.

  • Why do the 10 other rows have a mean route_estimated_duration_hrs of 28.4?

    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 shipments with item_id, item_name and item_category to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 33 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset120 rows33 columns
Yours10,000 rows33 columnsorigin_street_address: UK only

blueprint · disaster-relief-supply-chain-tracker

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 33 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
  • Each relief item must have a unique tracking ID
  • Delivery status is updated only upon warehouse scan
  • Routes must avoid zones flagged as 'inaccessible'
  • Inventory quantities should not drop below minimum buffer levels
  • Suppliers are ranked by historical delivery reliability
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
disaster-relief-supply-chain-tracker

More in Logistics

Browse all
Also in LogisticsHumanitarian Aid Supply Chain TrackerSupply Chain Delivery Delay LogsSupplier Lead Time VariabilityAll 1,947 datasets

What should your data show?

Preview 20 rows free
No signup. No card.