Emergency Supply Chain Optimization
This dataset provides detailed records of simulated emergency supply chain shipments, including resource types, quantities, multi-modal transport details, priority rankings, inventory constraints, and bottleneck tracking. It enables analysis of resource allocation efficiency, delivery times, and operational bottlenecks for scenario planning and digital transformation in crisis logistics.
Sample rows
preview · 8 of 120 rows · all 29 columns| shipment_idstring | resource_typestring | priority_levelinteger | inventory_constraint_flagboolean | origin_facility_namestring | request_idstring | resource_quantityfloat | origin_facility_idstring | origin_street_addressstring | origin_citystring | origin_statestring | origin_postal_codestring | origin_countrystring | destination_site_idstring | destination_site_namestring | destination_street_addressstring | destination_citystring | destination_statestring | destination_postal_codestring | destination_countrystring | transport_modestring | departure_datetimedatetime | arrival_datetimedatetime | estimated_delivery_duration_hoursfloat | actual_delivery_duration_hoursfloat | inventory_available_at_originfloat | bottleneck_flagboolean | bottleneck_descriptionstring | scenario_idstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SHIP0001 | medical_supplies | 1 | false | Chicago Central Med Depot | REQ1001 | 5200 | FAC001 | 1800 N Damen Ave | Chicago | IL | 60647 | USA | SITE001 | Evanston Emergency Clinic | 1003 Maple Ave | Evanston | IL | 60201 | USA | road | 2024-05-01T08:15:00 | 2024-05-01T10:15:00 | 2 | 2 | 10000 | false | blank | SCENARIO_ALPHA |
| SHIP0002 | food | 2 | false | Houston Food Distribution | REQ1002 | 600000 | FAC002 | 2121 Main St | Houston | TX | 77002 | USA | SITE002 | Dallas Disaster Relief Center | 3301 Ross Ave | Dallas | TX | 75204 | USA | rail | 2024-05-02T09:30:00 | 2024-05-02T16:00:00 | 6.5 | 7 | 650000 | true | Track maintenance delay near Corsicana | SCENARIO_BETA |
| SHIP0003 | water | 3 | false | Denver Water Warehouse | REQ1003 | 100000 | FAC003 | 2555 W 6th Ave | Denver | CO | 80204 | USA | SITE003 | Boulder Emergency Shelter | 2800 Jay Rd | Boulder | CO | 80301 | USA | road | 2024-05-03T07:45:00 | 2024-05-03T09:45:00 | 2 | 2 | 150000 | false | blank | SCENARIO_GAMMA |
| SHIP0004 | shelter_materials | 2 | false | St. Louis Shelter Depot | REQ1004 | 25000 | FAC004 | 2020 Market St | St. Louis | MO | 63103 | USA | SITE004 | Columbia Temporary Housing | 1100 College Ave | Columbia | MO | 65201 | USA | road | 2024-05-03T11:10:00 | 2024-05-03T15:00:00 | 3.9 | 3.9 | 30000 | false | blank | SCENARIO_DELTA |
| SHIP0005 | fuel | 3 | false | Phoenix Fuel Storage | REQ1005 | 50000 | FAC005 | 7400 E McDowell Rd | Scottsdale | AZ | 85257 | USA | SITE005 | Flagstaff Fire Response | 1700 S Milton Rd | Flagstaff | AZ | 86001 | USA | road | 2024-05-04T08:00:00 | 2024-05-04T13:00:00 | 5 | 5.5 | 60000 | true | Accident delay on I-17 | SCENARIO_EPSILON |
| SHIP0006 | other | 5 | false | NYC Miscellaneous Depot | REQ1006 | 0.01 | FAC006 | 300 W 145th St | New York | NY | 10039 | USA | SITE006 | Manhattan Event Response | 230 E 51st St | New York | NY | 10022 | USA | road | 2024-05-05T13:00:00 | 2024-05-05T13:30:00 | 0.5 | 0.5 | 0.02 | false | blank | SCENARIO_ZETA |
| SHIP0007 | medical_supplies | 1 | false | Chicago Central Med Depot | REQ1007 | 7000 | FAC001 | 1800 N Damen Ave | Chicago | IL | 60647 | USA | SITE007 | Naperville Trauma Center | 1400 S Washington St | Naperville | IL | 60540 | USA | road | 2024-05-06T07:20:00 | 2024-05-06T09:00:00 | 1.67 | 1.67 | 9300 | false | blank | SCENARIO_ALPHA |
| SHIP0008 | food | 3 | false | Houston Food Distribution | REQ1008 | 12000 | FAC002 | 2121 Main St | Houston | TX | 77002 | USA | SITE008 | Austin Food Bank | 6500 Metropolis Dr | Austin | TX | 78744 | USA | road | 2024-05-07T08:00:00 | 2024-05-07T13:00:00 | 5 | 5 | 15000 | false | blank | SCENARIO_BETA |
| SHIP0009 | water | 5 | false | Denver Water Warehouse | REQ1009 | 0.01 | FAC003 | 2555 W 6th Ave | Denver | CO | 80204 | USA | SITE009 | Aurora Test Site | 1900 S Potomac St | Aurora | CO | 80012 | USA | road | 2024-05-08T13:00:00 | 2024-05-08T13:10:00 | 0.17 | 0.17 | 0.01 | false | blank | SCENARIO_ZETA |
| SHIP0010 | shelter_materials | 2 | false | St. Louis Shelter Depot | REQ1010 | 4500 | FAC004 | 2020 Market St | St. Louis | MO | 63103 | USA | SITE010 | Kansas City Recovery Center | 1234 Troost Ave | Kansas City | MO | 64108 | USA | road | 2024-05-09T06:30:00 | 2024-05-09T09:30:00 | 3 | 3 | 5000 | false | blank | SCENARIO_DELTA |
| SHIP0011 | fuel | 5 | false | Phoenix Fuel Storage | REQ1011 | 0.01 | FAC005 | 7400 E McDowell Rd | Scottsdale | AZ | 85257 | USA | SITE011 | Mesa Microgrid | 100 N Center St | Mesa | AZ | 85201 | USA | road | 2024-05-10T11:00:00 | 2024-05-10T11:30:00 | 0.5 | 0.5 | 0.02 | false | blank | SCENARIO_ZETA |
| SHIP0012 | other | 4 | false | NYC Miscellaneous Depot | REQ1012 | 110000 | FAC006 | 300 W 145th St | New York | NY | 10039 | USA | SITE012 | Brooklyn Response Center | 4500 3rd Ave | Brooklyn | NY | 11232 | USA | multi-modal | 2024-05-11T09:15:00 | 2024-05-11T13:45:00 | 4.5 | 4.5 | 120000 | false | blank | SCENARIO_OMICRON |
| SHIP0013 | medical_supplies | 1 | false | Los Angeles Med Central | REQ1013 | 8000 | FAC007 | 1600 W Temple St | Los Angeles | CA | 90026 | USA | SITE013 | Santa Monica ER | 123 Main St | Santa Monica | CA | 90401 | USA | road | 2024-05-12T07:00:00 | 2024-05-12T08:30:00 | 1.5 | 1.5 | 12000 | false | blank | SCENARIO_THETA |
| SHIP0014 | food | 2 | false | Atlanta Food Hub | REQ1014 | 800000 | FAC008 | 600 Peachtree St NE | Atlanta | GA | 30308 | USA | SITE014 | Savannah Relief Camp | 1400 E Victory Dr | Savannah | GA | 31404 | USA | rail | 2024-05-13T08:00:00 | 2024-05-13T15:30:00 | 7.5 | 8 | 900000 | true | Freight congestion in Macon | SCENARIO_BETA |
| SHIP0015 | water | 3 | false | Miami Water Reserve | REQ1015 | 6000 | FAC009 | 2801 NW 24th Ave | Miami | FL | 33142 | USA | SITE015 | Fort Lauderdale Support | 700 SE 3rd Ave | Fort Lauderdale | FL | 33301 | USA | road | 2024-05-14T09:00:00 | 2024-05-14T11:00:00 | 2 | 2 | 7000 | false | blank | SCENARIO_LAMBDA |
| SHIP0016 | shelter_materials | 4 | false | Dallas Shelter Hub | REQ1016 | 12000 | FAC010 | 4000 Commerce St | Dallas | TX | 75226 | USA | SITE016 | Arlington Temporary Housing | 1300 E Lamar Blvd | Arlington | TX | 76011 | USA | road | 2024-05-14T13:45:00 | 2024-05-14T15:15:00 | 1.5 | 1.5 | 13000 | false | blank | SCENARIO_OMEGA |
| SHIP0017 | fuel | 2 | false | Phoenix Fuel Storage | REQ1017 | 35000 | FAC005 | 7400 E McDowell Rd | Scottsdale | AZ | 85257 | USA | SITE017 | Tucson Generator Site | 3900 S Country Club Rd | Tucson | AZ | 85714 | USA | road | 2024-05-15T10:00:00 | 2024-05-15T14:30:00 | 4.5 | 4.5 | 40000 | false | blank | SCENARIO_EPSILON |
| SHIP0018 | other | 5 | false | Seattle Misc Depot | REQ1018 | 0.01 | FAC011 | 5000 15th Ave NW | Seattle | WA | 98107 | USA | SITE018 | Tacoma Emergency Site | 2100 S State St | Tacoma | WA | 98405 | USA | road | 2024-05-16T12:00:00 | 2024-05-16T12:30:00 | 0.5 | 0.5 | 0.01 | false | blank | SCENARIO_ZETA |
| SHIP0019 | medical_supplies | 1 | false | Boston Med Supplies | REQ1019 | 4100 | FAC012 | 800 Massachusetts Ave | Boston | MA | 02118 | USA | SITE019 | Cambridge Emergency Hospital | 650 Main St | Cambridge | MA | 02139 | USA | road | 2024-05-17T07:00:00 | 2024-05-17T08:30:00 | 1.5 | 1.5 | 5000 | false | blank | SCENARIO_ALPHA |
| SHIP0020 | food | 3 | false | Atlanta Food Hub | REQ1020 | 250000 | FAC008 | 600 Peachtree St NE | Atlanta | GA | 30308 | USA | SITE020 | Macon Relief Center | 1100 Riverside Dr | Macon | GA | 31201 | USA | road | 2024-05-18T09:00:00 | 2024-05-18T13:30:00 | 4.5 | 4.5 | 300000 | false | blank | SCENARIO_GAMMA |
What the 120 rows show
from the 120-row sampleMedical_
- 3%inventory_
constraint_ flag = true - 3median priority_
level - 5transport modes
- 10scenarios
- 13origin states
- 17destination states
Median 3, from 1 to 5.
- string 20
- integer 1
- float 4
- datetime 2
- boolean 2
Columns
29 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
shipment_id | string | Unique identifier for each emergency supply shipmentunique | SHIP0001 |
request_id | string | Unique identifier for the emergency resource request | REQ1001 |
resource_type | string | Type of resource being shipped (e.g., medical supplies, food, water, shelter materials)6 values | medical_supplies |
origin_facility_id | string | Unique identifier for the facility or warehouse where shipment originates | FAC001 |
origin_facility_name | string | Name of the origin facility or warehouse | Denver Water Warehouse |
origin_street_address | string | Street address of the origin facility | 1800 N Damen Ave |
origin_city | string | City of the origin facility | Chicago |
origin_state | string | State or province of the origin facility | IL |
origin_postal_code | string | Postal code of the origin facility | 60647 |
origin_country | string | Country of the origin facility | USA |
destination_site_id | string | Unique identifier for the emergency response site or recipient location | SITE001 |
destination_site_name | string | Name of the destination site or recipient location | Flagstaff Fire Response |
destination_street_address | string | Street address of the destination site | 1003 Maple Ave |
destination_city | string | City of the destination site | Evanston |
destination_state | string | State or province of the destination site | IL |
destination_postal_code | string | Postal code of the destination site | 60201 |
destination_country | string | Country of the destination site | USA |
transport_mode | string | Primary mode of transport used for the shipmentroad · rail · air · sea · multi-modal | road |
bottleneck_description | string | Description of the bottleneck encountered (if any)optional | Accident delay on I-17 |
scenario_id | string | Identifier for the simulation scenario (for scenario planning and analysis)10 scenarios | SCENARIO_ALPHA |
| Numbers 5 columns | |||
resource_quantity | float | Quantity of the resource shipped (in standardized units)0.01 or more | 5200 |
priority_level | integer | Priority ranking of the shipment (1 = highest urgency)1 to 5 | 1 |
estimated_delivery_duration_hours | float | Estimated total delivery time in hours0 or more | 2 |
actual_delivery_duration_hours | float | Actual total delivery time in hours0 or more · optional | 2 |
inventory_available_at_origin | float | Available inventory of the resource at the origin facility at time of shipment0 or more | 10000 |
| Dates and times 2 columns | |||
departure_datetime | datetime | Date and time when the shipment leaves the origin facility | 2024-05-01T08:15:00 |
arrival_datetime | datetime | Date and time when the shipment arrives at the destination site | 2024-05-01T10:15:00 |
| True or false 2 columns | |||
inventory_constraint_flag | boolean | Indicates if inventory constraints affected the shipment (true if constraints present) | false |
bottleneck_flag | boolean | Indicates if a bottleneck was encountered during transportoptional | false |
Use it for
A logistics dashboard
The inventory_
constraint_ flag rate, priority_ level by resource_ type and a breakdown of origin_ facility_ name. Excel, Power BI or Tableau. Why do the 22 medical_
supplies rows have a mean priority_ level of 1.0? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Shipments120SHIP00011medical_…SHIP00625otherSHIP00715water
A software demo
Believable shipments with request_
id, resource_ type and resource_ quantity to fill a screen in front of a buyer.
blueprint · emergency-supply-chain-optimization
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 29 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.
- Critical resources receive highest priority for delivery
- Transport route selection must minimize overall delay
- Inventory levels are updated after each dispatch
- Orders exceeding available inventory are flagged for escalation
- Delivery times impacted by simulated traffic and weather events
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
- emergency-supply-chain-optimization