Government Disaster Relief Supply Logistics
This dataset provides detailed tracking of government disaster relief supply shipments, including inventory levels, shipment routes, delivery outcomes, and bottleneck identification. It enables municipal managers and analysts to optimize stock allocations, monitor supply chain performance, and improve emergency response times during disasters.
Sample rows
preview · 8 of 75 rows · all 32 columns| shipment_idstring | shipment_prioritystring | quantity_shippedinteger | delivery_successboolean | origin_statestring | inventory_item_idstring | item_namestring | item_categorystring | origin_facility_idstring | origin_facility_namestring | origin_street_addressstring | origin_citystring | origin_postal_codestring | origin_countrystring | destination_facility_idstring | destination_facility_namestring | destination_street_addressstring | destination_citystring | destination_statestring | destination_postal_codestring | destination_countrystring | shipment_departure_datetimedatetime | shipment_arrival_datetimedatetime | delivery_statusstring | inventory_level_at_origininteger | inventory_level_at_destinationinteger | transport_modestring | estimated_arrival_datetimedatetime | actual_travel_time_hoursfloat | bottleneck_flagboolean | bottleneck_descriptionstring | delivery_failure_reasonstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SHIP0001 | high | 250 | true | TX | ITEMA1 | Bottled Water | food | FAC001 | Central Distribution Center | 123 Main St | Houston | 77001 | USA | FAC012 | West Relief Warehouse | 789 West Ave | Dallas | TX | 75001 | USA | 2023-03-15T09:30:00 | 2023-03-15T17:45:00 | delivered | 900 | 550 | truck | 2023-03-15T18:00:00 | 8.25 | false | blank | blank |
| SHIP0002 | medium | 120 | true | TX | ITEMB2 | Blankets | shelter | FAC002 | South Storage Hub | 654 Oak Ln | Austin | 73301 | USA | FAC010 | East Relief Center | 321 East Blvd | San Antonio | TX | 78205 | USA | 2023-03-16T10:00:00 | 2023-03-16T14:45:00 | delivered | 400 | 180 | truck | 2023-03-16T15:30:00 | 4.75 | false | blank | blank |
| SHIP0003 | high | 60 | false | OK | ITEMC3 | Medical Kits | medical | FAC003 | North Medical Depot | 987 Pine Rd | Oklahoma City | 73101 | USA | FAC013 | Central Health Center | 741 Central Pkwy | Norman | OK | 73069 | USA | 2023-03-17T08:15:00 | 2023-03-17T10:00:00 | in_transit | 150 | blank | truck | 2023-03-17T10:30:00 | blank | false | blank | blank |
| SHIP0004 | medium | 150 | true | IA | ITEMD4 | Sanitation Wipes | hygiene | FAC004 | Midwest Relief Depot | 432 Maple Ave | Des Moines | 50309 | USA | FAC014 | Cedar Rapids Center | 159 Cedar Rd | Cedar Rapids | IA | 52401 | USA | 2023-03-18T13:00:00 | 2023-03-18T17:10:00 | delivered | 300 | 180 | truck | 2023-03-18T17:00:00 | 4.17 | true | Heavy traffic on I-80 caused a 10 min delay | blank |
| SHIP0005 | high | 320 | false | CA | ITEME5 | Canned Soup | food | FAC005 | West Coast Facility | 321 Ocean Blvd | Los Angeles | 90001 | USA | FAC020 | San Jose Relief Point | 555 Relief Dr | San Jose | CA | 95112 | USA | 2023-03-19T07:45:00 | 2023-03-19T14:30:00 | delayed | 650 | blank | truck | 2023-03-19T13:00:00 | 6.75 | true | Truck breakdown caused extended delay | blank |
| SHIP0006 | medium | 80 | true | TX | ITEMF6 | First Aid Packs | medical | FAC001 | Central Distribution Center | 123 Main St | Houston | 77001 | USA | FAC015 | Galveston Response Hub | 222 Bay Area Blvd | Galveston | TX | 77550 | USA | 2023-03-20T11:10:00 | 2023-03-20T12:55:00 | delivered | 100 | 60 | truck | 2023-03-20T12:45:00 | 1.75 | false | blank | blank |
| SHIP0007 | low | 45 | false | TX | ITEMG7 | Sleeping Bags | shelter | FAC002 | South Storage Hub | 654 Oak Ln | Austin | 73301 | USA | FAC017 | El Paso Care Point | 401 Sunland Park Dr | El Paso | TX | 79912 | USA | 2023-03-21T10:20:00 | blank | in_transit | 90 | blank | rail | 2023-03-21T21:00:00 | blank | false | blank | blank |
| SHIP0008 | medium | 200 | true | OK | ITEMH8 | Hand Sanitizer | hygiene | FAC003 | North Medical Depot | 987 Pine Rd | Oklahoma City | 73101 | USA | FAC018 | Tulsa Relief Center | 1010 Greenwood Ave | Tulsa | OK | 74120 | USA | 2023-03-22T14:00:00 | 2023-03-22T17:40:00 | delivered | 350 | 120 | truck | 2023-03-22T17:00:00 | 3.67 | true | Minor vehicle incident delayed arrival | blank |
| SHIP0009 | high | 300 | true | IA | ITEMI9 | Face Masks | medical | FAC004 | Midwest Relief Depot | 432 Maple Ave | Des Moines | 50309 | USA | FAC014 | Cedar Rapids Center | 159 Cedar Rd | Cedar Rapids | IA | 52401 | USA | 2023-03-23T08:10:00 | 2023-03-23T11:30:00 | delivered | 600 | 340 | truck | 2023-03-23T11:00:00 | 3.33 | true | Loading dock congestion at origin | blank |
| SHIP0010 | high | 500 | true | CA | ITEMJ10 | Ready-to-Eat Meals | food | FAC005 | West Coast Facility | 321 Ocean Blvd | Los Angeles | 90001 | USA | FAC021 | Oakland Support Center | 97 Broadway | Oakland | CA | 94607 | USA | 2023-03-24T06:10:00 | 2023-03-24T13:35:00 | delivered | 1000 | 540 | truck | 2023-03-24T12:30:00 | 7.42 | true | Route detour due to road closure | blank |
| SHIP0011 | medium | 170 | true | TX | ITEMK11 | Soap Bars | hygiene | FAC002 | South Storage Hub | 654 Oak Ln | Austin | 73301 | USA | FAC019 | Waco Relief Hub | 888 Baylor St | Waco | TX | 76701 | USA | 2023-03-25T09:00:00 | 2023-03-25T12:20:00 | delivered | 210 | 120 | truck | 2023-03-25T12:00:00 | 3.33 | false | blank | blank |
| SHIP0012 | low | 80 | true | IA | ITEML12 | Pillows | shelter | FAC004 | Midwest Relief Depot | 432 Maple Ave | Des Moines | 50309 | USA | FAC016 | Sioux City Shelter Site | 312 Harbor Rd | Sioux City | IA | 51101 | USA | 2023-03-26T14:30:00 | 2023-03-26T18:00:00 | delivered | 200 | 70 | truck | 2023-03-26T17:00:00 | 3.5 | true | Weather caused slower travel speeds | blank |
| SHIP0013 | medium | 60 | true | OK | ITEMM13 | Baby Formula | food | FAC003 | North Medical Depot | 987 Pine Rd | Oklahoma City | 73101 | USA | FAC013 | Central Health Center | 741 Central Pkwy | Norman | OK | 73069 | USA | 2023-03-27T08:00:00 | 2023-03-27T09:30:00 | delivered | 170 | 80 | truck | 2023-03-27T09:10:00 | 1.5 | false | blank | blank |
| SHIP0014 | medium | 100 | true | CA | ITEMN14 | Toothbrushes | hygiene | FAC005 | West Coast Facility | 321 Ocean Blvd | Los Angeles | 90001 | USA | FAC021 | Oakland Support Center | 97 Broadway | Oakland | CA | 94607 | USA | 2023-03-28T06:15:00 | 2023-03-28T11:00:00 | delivered | 300 | 120 | truck | 2023-03-28T10:45:00 | 4.75 | false | blank | blank |
| SHIP0015 | high | 8 | true | IA | ITEMO15 | Portable Toilets | other | FAC004 | Midwest Relief Depot | 432 Maple Ave | Des Moines | 50309 | USA | FAC022 | Kansas City Support | 200 Union St | Kansas City | MO | 64105 | USA | 2023-03-29T13:35:00 | 2023-03-29T18:50:00 | delivered | 15 | 10 | truck | 2023-03-29T18:30:00 | 5.25 | true | Oversize load required extra documentation | blank |
| SHIP0016 | high | 400 | true | OK | ITEMP16 | Gloves | medical | FAC003 | North Medical Depot | 987 Pine Rd | Oklahoma City | 73101 | USA | FAC018 | Tulsa Relief Center | 1010 Greenwood Ave | Tulsa | OK | 74120 | USA | 2023-03-30T09:40:00 | 2023-03-30T13:20:00 | delivered | 900 | 480 | truck | 2023-03-30T13:00:00 | 3.67 | false | blank | blank |
| SHIP0017 | medium | 35 | true | TX | ITEMQ17 | Tarps | shelter | FAC002 | South Storage Hub | 654 Oak Ln | Austin | 73301 | USA | FAC019 | Waco Relief Hub | 888 Baylor St | Waco | TX | 76701 | USA | 2023-03-31T10:10:00 | 2023-03-31T12:50:00 | delivered | 50 | 30 | truck | 2023-03-31T12:30:00 | 2.67 | false | blank | blank |
| SHIP0018 | medium | 260 | true | CA | ITEMR18 | Rice Bags | food | FAC005 | West Coast Facility | 321 Ocean Blvd | Los Angeles | 90001 | USA | FAC021 | Oakland Support Center | 97 Broadway | Oakland | CA | 94607 | USA | 2023-04-01T07:30:00 | 2023-04-01T12:50:00 | delivered | 600 | 330 | truck | 2023-04-01T12:40:00 | 5.33 | false | blank | blank |
| SHIP0019 | high | 180 | true | OK | ITEMS19 | Bandages | medical | FAC003 | North Medical Depot | 987 Pine Rd | Oklahoma City | 73101 | USA | FAC018 | Tulsa Relief Center | 1010 Greenwood Ave | Tulsa | OK | 74120 | USA | 2023-04-02T12:00:00 | 2023-04-02T14:50:00 | delivered | 300 | 120 | truck | 2023-04-02T14:30:00 | 2.83 | false | blank | blank |
| SHIP0020 | medium | 90 | false | TX | ITEMT20 | Diapers | hygiene | FAC002 | South Storage Hub | 654 Oak Ln | Austin | 73301 | USA | FAC017 | El Paso Care Point | 401 Sunland Park Dr | El Paso | TX | 79912 | USA | 2023-04-03T10:00:00 | blank | pending | 200 | blank | rail | 2023-04-03T22:00:00 | blank | false | blank | blank |
What the 75 rows show
from the 75-row sampleHigh (shipment priority) stands out: mean quantity_
- 79%delivery_
success = true - 80median quantity_
shipped - 3origin countries
- 3destination countries
- 4transport modes
- 5item categories
Median 80, from 8 to 500.
- string 23
- integer 3
- float 1
- datetime 3
- boolean 2
Columns
32 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 23 columns | |||
shipment_id | string | Unique identifier for each shipment of disaster relief supplies.unique | SHIP0001 |
inventory_item_id | string | Unique identifier for each inventory item included in the shipment. | ITEMA1 |
item_name | string | Name of the inventory item (e.g., bottled water, blankets, medical kits). | Bottled Water |
item_category | string | Category of the inventory item (e.g., food, medical, shelter, hygiene).food · medical · shelter · hygiene · other | food |
origin_facility_id | string | Unique identifier for the facility where the shipment originated. | FAC001 |
origin_facility_name | string | Name of the origin facility. | South Storage Hub |
origin_street_address | string | Street address of the origin facility. | 123 Main St |
origin_city | string | City of the origin facility. | Houston |
origin_state | string | State or province of the origin facility. | TX |
origin_postal_code | string | Postal code of the origin facility. | 77001 |
origin_country | string | Country of the origin facility.3 countries | USA |
destination_facility_id | string | Unique identifier for the facility where the shipment is delivered. | FAC012 |
destination_facility_name | string | Name of the destination facility. | West Relief Warehouse |
destination_street_address | string | Street address of the destination facility. | 789 West Ave |
destination_city | string | City of the destination facility. | Dallas |
destination_state | string | State or province of the destination facility. | TX |
destination_postal_code | string | Postal code of the destination facility. | 75001 |
destination_country | string | Country of the destination facility.3 countries | USA |
delivery_status | string | Current status of the shipment delivery.pending · in_transit · delivered · failed · delayed | delivered |
delivery_failure_reason | string | Reason for delivery failure, if applicable.optional | Train derailment halted d… |
shipment_priority | string | Priority level assigned to the shipment.high · medium · low | high |
transport_mode | string | Mode of transportation used for the shipment.truck · air · rail · ship · other | truck |
bottleneck_description | string | Description of the bottleneck or delay, if applicable.optional | Heavy traffic on I-80 cau… |
| Numbers 4 columns | |||
quantity_shipped | integer | Number of units of the item shipped in this shipment.1 or more | 250 |
inventory_level_at_origin | integer | Inventory level of the item at the origin facility prior to shipment.0 or more | 900 |
inventory_level_at_destination | integer | Inventory level of the item at the destination facility after arrival.0 or more · optional | 550 |
actual_travel_time_hours | float | Actual travel time in hours from departure to arrival.0 or more · optional | 8.25 |
| Dates and times 3 columns | |||
shipment_departure_datetime | datetime | Date and time when the shipment departed from the origin facility. | 2023-03-15T09:30:00 |
shipment_arrival_datetime | datetime | Date and time when the shipment arrived at the destination facility.optional | 2023-03-15T17:45:00 |
estimated_arrival_datetime | datetime | Estimated date and time of arrival at the destination. | 2023-03-15T18:00:00 |
| True or false 2 columns | |||
delivery_success | boolean | Indicates whether the shipment was successfully delivered. | true |
bottleneck_flag | boolean | Indicates whether this shipment experienced a bottleneck or delay.optional | false |
Use it for
A logistics dashboard
The delivery_
success rate, quantity_ shipped by shipment_ priority and a breakdown of origin_ state. Excel, Power BI or Tableau. Why do the 19 high rows have a mean quantity_
shipped of 192.3? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Shipments75SHIP0001250highSHIP0002120mediumSHIP000360high
A software demo
Believable shipments with inventory_
item_ id, item_ name and item_ category to fill a screen in front of a buyer.
blueprint · government-disaster-relief-supply-logistics
Behind this dataset
Same schema. As many rows as you need.
These 75 rows came out of a blueprint — 32 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.
- Each record represents a unique supply shipment for a specific disaster event.
- Shipments must include source, type of relief goods, destination center, quantity, and priority level.
- Delivery status must be updated with actual arrival date and any delays over 24 hours flagged.
- Inventory depletion at receiving centers triggers automated restock alerts if below critical threshold.
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
- government-disaster-relief-supply-logistics