Logistics
38 columns
85 rows
8 formats

NGO Disaster Logistics Planner

This dataset provides detailed, real-time records of NGO-managed supply movements during disaster response, including shipment details, warehouse and delivery site locations, transportation modes, timing, and operational challenges such as bottlenecks and shortages. It is designed to help nonprofits and logistics planners optimize resource allocation, identify bottlenecks, and improve delivery efficiency under crisis conditions. The dataset supports scenario testing for supply chain resilience and disaster preparedness.

last updated 25 Nov 2025
by GoMask

The brief that made it

Optimizing NGO supply chain and transportation routes during disaster response

Sample rows

preview · 8 of 85 rows · all 38 columns

shipment_idstring	current_statusstring	warehouse_capacity_utilization_percentfloat	bottleneck_flagboolean	origin_countrystring	ngo_idstring	ngo_namestring	supply_typestring	supply_descriptionstring	quantityfloat	unitstring	origin_warehouse_idstring	origin_warehouse_namestring	origin_street_addressstring	origin_citystring	origin_statestring	origin_postal_codestring	destination_site_idstring	destination_site_namestring	destination_street_addressstring	destination_citystring	destination_statestring	destination_postal_codestring	destination_countrystring	departure_datetimedatetime	expected_arrival_datetimedatetime	actual_arrival_datetimedatetime	transport_modestring	vehicle_idstring	driver_namestring	bottleneck_descriptionstring	supply_shortage_flagboolean	supply_shortage_descriptionstring	route_idstring	distance_kmfloat	estimated_travel_time_hoursfloat	actual_travel_time_hoursfloat	notesstring
SHIP-001	delivered	82.6	false	USA	NGO-001	Relief International	food	Rice, canned beans, cooking oil	1200.5	kg	WH-001	Central Relief Storage	1450 Elm Road	Houston	TX	77002	SITE-001	Flood Response Center	200 River Ave	Baton Rouge	LA	70802	USA	2024-06-15T08:25:00Z	2024-06-15T16:25:00Z	2024-06-15T16:45:00Z	truck	TRK-041	Maria Gomez	blank	false	blank	ROUTE-001	630.7	8	8.33	Successful delivery. Minor traffic delay.
SHIP-002	delivered	75	false	USA	NGO-002	Global Humanitarian Aid	water	Bottled water packs	850	liters	WH-002	West Storage Facility	602 Sunset Blvd	Phoenix	AZ	85013	SITE-002	Heat Relief Point	98 Desert Way	Yuma	AZ	85364	USA	2024-06-16T09:30:00Z	2024-06-16T12:30:00Z	2024-06-16T12:35:00Z	truck	TRK-018	John Lee	blank	false	blank	ROUTE-002	295.4	3	3.08	Delivery completed on time.
SHIP-003	delivered	90.2	true	USA	NGO-003	AidWorks	medicine	First aid kits, bandages, antiseptics	200	units	WH-003	Northeast Health Depot	18 Maple Drive	Boston	MA	02118	SITE-003	Storm Shelter	900 Harbor St	New Haven	CT	06510	USA	2024-06-14T13:00:00Z	2024-06-14T16:30:00Z	2024-06-14T16:55:00Z	truck	TRK-032	Angela Turner	Road closure due to flooding.	false	blank	ROUTE-003	220.3	3.5	3.92	Delivery delayed by 25 minutes.
SHIP-004	in_transit	80	false	USA	NGO-001	Relief International	shelter	Tents and tarpaulins	60	boxes	WH-001	Central Relief Storage	1450 Elm Road	Houston	TX	77002	SITE-004	Temporary Camp North	41 Pine Lane	Dallas	TX	75201	USA	2024-06-17T07:00:00Z	2024-06-17T11:00:00Z	blank	truck	TRK-045	Derek White	blank	true	Demand exceeded available tents.	ROUTE-004	385	4	blank	Partial supply shipped due to shortage.
SHIP-005	delivered	67.5	true	USA	NGO-004	Hands United	hygiene	Soap bars, hand sanitizer, towels	500	packs	WH-004	Southwest Relief Hub	882 Palm St	San Diego	CA	92103	SITE-005	Earthquake Shelter	17 Main St	Santa Ana	CA	92701	USA	2024-06-16T10:45:00Z	2024-06-16T13:45:00Z	2024-06-16T14:05:00Z	truck	TRK-027	Linda Cho	Heavy traffic in city center.	false	blank	ROUTE-005	160.2	3	3.33	Minor delay due to congestion.
SHIP-006	delivered	72	false	USA	NGO-005	Hope for All	clothing	Winter jackets, gloves, hats	350	units	WH-005	Midwest Clothing Depot	500 Oak St	Chicago	IL	60607	SITE-006	Family Relief Center	123 Liberty Ave	Detroit	MI	48226	USA	2024-06-15T12:15:00Z	2024-06-15T16:45:00Z	2024-06-15T16:45:00Z	truck	TRK-054	Victor Brown	blank	false	blank	ROUTE-006	450	4.5	4.5	Weather clear. Smooth delivery.
SHIP-007	planned	68.5	false	USA	NGO-002	Global Humanitarian Aid	medicine	Painkillers, antibiotics, syringes	95	boxes	WH-002	West Storage Facility	602 Sunset Blvd	Phoenix	AZ	85013	SITE-007	Desert Medical Post	34 Oasis Rd	El Paso	TX	79901	USA	2024-06-15T06:00:00Z	2024-06-15T12:00:00Z	blank	air	AIR-001	Pilot James O'Connor	blank	false	blank	ROUTE-007	560	1.5	blank	Flight scheduled for tomorrow.
SHIP-008	in_transit	86.7	false	USA	NGO-003	AidWorks	food	Bread, canned tuna, energy bars	600	kg	WH-003	Northeast Health Depot	18 Maple Drive	Boston	MA	02118	SITE-008	Storm Recovery Kitchen	77 Bay Rd	Providence	RI	02903	USA	2024-06-17T11:30:00Z	2024-06-17T13:00:00Z	blank	truck	TRK-037	Samuel Park	blank	false	blank	ROUTE-008	80.5	1.5	blank	Expected to arrive early.
SHIP-009	planned	62.1	false	USA	NGO-004	Hands United	equipment	Portable generators, flashlights	24	units	WH-004	Southwest Relief Hub	882 Palm St	San Diego	CA	92103	SITE-009	Power Relief Center	321 Edison Way	Riverside	CA	92501	USA	2024-06-18T09:10:00Z	2024-06-18T11:10:00Z	blank	truck	TRK-062	Christine Dorsey	blank	false	blank	ROUTE-009	140	2	blank	Generators in high demand region.
SHIP-010	delayed	78.3	true	USA	NGO-005	Hope for All	other	Mosquito nets, water purification tablets	480	packs	WH-005	Midwest Clothing Depot	500 Oak St	Chicago	IL	60607	SITE-010	Flooded Area Supply Post	66 Willow St	St. Louis	MO	63101	USA	2024-06-18T08:00:00Z	2024-06-18T14:00:00Z	2024-06-18T14:45:00Z	truck	TRK-065	Henry Wu	Bridge out, detour required.	false	blank	ROUTE-010	480	6	6.75	Delay due to emergency road closure.
SHIP-011	in_transit	84.4	false	USA	NGO-001	Relief International	water	Bulk water containers	3000	liters	WH-006	Gulf Water Depot	100 Seaside Rd	Mobile	AL	36602	SITE-011	Hurricane Relief Camp	1 Shelter Lane	Pensacola	FL	32501	USA	2024-06-19T07:45:00Z	2024-06-19T09:45:00Z	blank	truck	TRK-073	Rita Sanders	blank	false	blank	ROUTE-011	95.6	2	blank	Urgent water needs at camp.
SHIP-012	delivered	61.7	true	USA	NGO-002	Global Humanitarian Aid	equipment	Camping stoves, lanterns	30	units	WH-007	Mountain Supply Depot	212 Ridge Rd	Denver	CO	80202	SITE-012	Wildfire Response Base	400 Pine St	Boulder	CO	80302	USA	2024-06-18T13:20:00Z	2024-06-18T14:20:00Z	2024-06-18T14:40:00Z	truck	TRK-078	Alex Wright	Mountain pass congestion.	false	blank	ROUTE-012	50	1	1.33	Mountain route caused delay.
SHIP-013	planned	70	false	USA	NGO-003	AidWorks	clothing	Children's summer clothes	210	packs	WH-008	East Kidswear Depot	150 Spring St	Atlanta	GA	30303	SITE-013	Family Recovery Center	27 Peachtree Ave	Savannah	GA	31401	USA	2024-06-20T08:00:00Z	2024-06-20T12:00:00Z	blank	truck	TRK-083	Monica Evans	blank	false	blank	ROUTE-013	400	4	blank	Summer clothing for children.
SHIP-014	planned	65.3	false	USA	NGO-004	Hands United	hygiene	Toothbrushes, toothpaste	1000	units	WH-004	Southwest Relief Hub	882 Palm St	San Diego	CA	92103	SITE-014	Shelter Hygiene Point	12 Spring Ave	Los Angeles	CA	90012	USA	2024-06-20T07:00:00Z	2024-06-20T11:00:00Z	blank	truck	TRK-089	Nathan Reed	blank	true	Shortage of toothpaste units.	ROUTE-014	192.4	4	blank	Partial hygiene supply shipped.
SHIP-015	delivered	85	false	USA	NGO-005	Hope for All	food	Instant noodles, dried fruit	900	kg	WH-005	Midwest Clothing Depot	500 Oak St	Chicago	IL	60607	SITE-015	Flood Relief Kitchen	200 River St	Cincinnati	OH	45202	USA	2024-06-19T06:00:00Z	2024-06-19T12:00:00Z	2024-06-19T12:30:00Z	rail	RL-003	Train Operator Cindy Wu	blank	false	blank	ROUTE-015	480	6	6.5	Delay due to train switching.
SHIP-016	in_transit	83.5	false	USA	NGO-001	Relief International	medicine	Diabetes medication, insulin syringes	55	boxes	WH-001	Central Relief Storage	1450 Elm Road	Houston	TX	77002	SITE-016	Health Clinic South	13 Magnolia Ave	Corpus Christi	TX	78401	USA	2024-06-20T09:00:00Z	2024-06-20T14:00:00Z	blank	truck	TRK-092	Sarah Yu	blank	false	blank	ROUTE-016	347	5	blank	Insulin kept cold during transit.
SHIP-017	planned	77.3	false	USA	NGO-002	Global Humanitarian Aid	shelter	Sleeping bags, foam mats	140	boxes	WH-007	Mountain Supply Depot	212 Ridge Rd	Denver	CO	80202	SITE-017	Evacuation Camp West	501 Aspen St	Grand Junction	CO	81501	USA	2024-06-19T11:00:00Z	2024-06-19T17:00:00Z	blank	truck	TRK-096	Brian Carter	blank	false	blank	ROUTE-017	390	6	blank	Shelter supplies for evacuees.
SHIP-018	delayed	79.7	true	USA	NGO-003	AidWorks	water	Large water jugs	1200	liters	WH-008	East Kidswear Depot	150 Spring St	Atlanta	GA	30303	SITE-018	Flooded Neighborhood	40 Lakeview Dr	Jacksonville	FL	32202	USA	2024-06-21T07:30:00Z	2024-06-21T13:00:00Z	2024-06-21T13:45:00Z	truck	TRK-099	Matthew Hill	Flooded roads caused detour.	false	blank	ROUTE-018	550	5.5	6.25	Heavy rainfall slowed progress.
SHIP-019	in_transit	74.2	false	USA	NGO-004	Hands United	equipment	Water pumps, hoses	18	units	WH-009	Flood Equipment Depot	951 River St	Memphis	TN	38103	SITE-019	Flood Operations Center	200 Bridge Rd	Little Rock	AR	72201	USA	2024-06-21T06:00:00Z	2024-06-21T10:00:00Z	blank	truck	TRK-105	Lisa Tran	blank	false	blank	ROUTE-019	210	4	blank	Pumps urgently needed for operations.
SHIP-020	planned	64.3	false	USA	NGO-005	Hope for All	hygiene	Laundry detergent, towels	270	packs	WH-010	Central Hygiene Depot	400 Clean St	Kansas City	MO	64106	SITE-020	Displaced Family Shelter	100 Family Lane	Omaha	NE	68102	USA	2024-06-22T08:00:00Z	2024-06-22T14:00:00Z	blank	truck	TRK-111	David Kim	blank	false	blank	ROUTE-020	410	6	blank	Laundry supplies for displaced families.

What the 85 rows show

from the 85-row sample

Delayed (current status) stands out: 11 of its 11 rows have bottleneck_flag = true, against 8 of 74 for the rest.

22%bottleneck_flag = true
69.7median warehouse_capacity_utilization_percent
4transport modes
5units
8supply types
220.0median quantity

Bottleneck flag rate by current_statusbottleneck_flag = true

warehouse_capacity_utilization_percent85 rows, in bands of 10

Median 69.7, from 40.2 to 90.2.

origin_country85 rows · top 10 of 28 values

USA43
South Africa4
Nigeria3
Egypt3
Turkey3
India2
Belgium2
Philippines2
United Kingdom2
Indonesia2

38 columns by typefrom the column list below

string 28
float 5
datetime 3
boolean 2

Columns

38 columns in four groups

blueprint · 38 columns
column	type	description	example
Text 28 columns
`shipment_id`	string	Unique identifier for each supply shipment or movement event.unique	SHIP-001
`ngo_id`	string	Unique identifier for the NGO responsible for this shipment.	NGO-001
`ngo_name`	string	Name of the NGO managing the shipment.	Relief International
`supply_type`	string	Type of supply being transported (e.g., food, water, medicine, shelter).8 values	food
`supply_description`	string	Detailed description of the supplies in the shipment.optional	Bottled water packs
`unit`	string	Unit of measurement for the quantity (e.g., kg, liters, units, boxes).6 values	kg
`origin_warehouse_id`	string	Unique identifier for the origin warehouse or storage location.	WH-001
`origin_warehouse_name`	string	Name of the origin warehouse or storage facility.	Central Relief Storage
`origin_street_address`	string	Street address of the origin warehouse.	1450 Elm Road
`origin_city`	string	City of the origin warehouse.	Houston
`origin_state`	string	State or province of the origin warehouse.	TX
`origin_postal_code`	string	Postal code of the origin warehouse.optional	77002
`origin_country`	string	Country of the origin warehouse.	USA
`destination_site_id`	string	Unique identifier for the disaster response site or delivery location.	SITE-001
`destination_site_name`	string	Name of the disaster response site or delivery location.	Flood Response Center
`destination_street_address`	string	Street address of the destination site.	200 River Ave
`destination_city`	string	City of the destination site.	Baton Rouge
`destination_state`	string	State or province of the destination site.	LA
`destination_postal_code`	string	Postal code of the destination site.optional	70802
`destination_country`	string	Country of the destination site.	USA
`transport_mode`	string	Mode of transportation used for the shipment (e.g., truck, air, boat, rail).truck · air · boat · rail · other	truck
`vehicle_id`	string	Identifier for the vehicle or transport asset used.optional	TRK-041
`driver_name`	string	Name of the driver or transport lead.optional	Maria Gomez
`current_status`	string	Current status of the shipment (e.g., planned, in_transit, delivered, delayed, cancelled).planned · in_transit · delivered · delayed · cancelled	delivered
`bottleneck_description`	string	Description of the bottleneck or delay, if applicable.optional	Border inspection delay
`supply_shortage_description`	string	Description of the supply shortage, if applicable.optional	Shortage of clean water.
`route_id`	string	Identifier for the planned route taken by the shipment.optional	ROUTE-001
`notes`	string	Additional notes or comments related to the shipment.optional	Antivirals for outbreak.
Numbers 5 columns
`quantity`	float	Total quantity of supplies in the shipment (in standardized units).0.01 or more	1200.5
`distance_km`	float	Planned distance in kilometers between origin and destination.0 or more · optional	630.7
`estimated_travel_time_hours`	float	Estimated travel time in hours for the shipment.0 or more · optional	8
`actual_travel_time_hours`	float	Actual travel time in hours for the shipment.0 or more · optional	8.33
`warehouse_capacity_utilization_percent`	float	Percentage of warehouse capacity utilized at the time of shipment departure.0 to 100 · optional	82.6
Dates and times 3 columns
`departure_datetime`	datetime	Date and time when the shipment departed from the origin warehouse.	2024-06-15T08:25:00Z
`expected_arrival_datetime`	datetime	Expected date and time of arrival at the destination site.	2024-06-15T16:25:00Z
`actual_arrival_datetime`	datetime	Actual date and time of arrival at the destination site.optional	2024-06-15T16:45:00Z
True or false 2 columns
`bottleneck_flag`	boolean	Indicates if this shipment is experiencing a logistical bottleneck.optional	false
`supply_shortage_flag`	boolean	Indicates if this shipment is affected by a supply shortage.optional	false

Use it for

A logistics dashboard
The bottleneck_flag rate, warehouse_capacity_utilization_percent by current_status and a breakdown of origin_country. Excel, Power BI or Tableau.
Why do 19 of 85 rows have bottleneck_flag = true?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Shipments85
SHIP-00182.6delivered
SHIP-00390.2delivered
SHIP-00567.5delivered
A software demo
Believable shipments with ngo_id, ngo_name and supply_type to fill a screen in front of a buyer.

This dataset85 rows38 columns

Yours1,000 rows38 columnsorigin_street_address: UK only

blueprint · ngo-disaster-logistics-planner

Behind this dataset

Same schema. As many rows as you need.

These 85 rows came out of a blueprint — 38 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 disaster response event must involve at least two resource types (e.g., water, medicine).
Transportation delays are generated based on weather severity and road accessibility tags.
Warehouse inventory adjusts dynamically as deliveries are dispatched and received.
Allocation prioritizes critical zones based on severity score and population affected.
Resource shortages trigger rerouting or alternative sourcing in at least 15% of cases.

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: ngo-disaster-logistics-planner

What should your data show?

No signup. No card.

Sample rows

What the 85 rows show

Columns

Use it for

A logistics dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Logistics

What should your data show?