Supply Chain Route Disruption Scenarios
This dataset provides a comprehensive record of simulated supply chain route disruptions, including scenario definitions, event details, affected routes, and operational logs. It enables logistics professionals to analyze the impact of various disruption types, optimize routing strategies, and enhance supply chain resilience through scenario-based planning.
Sample rows
preview · 8 of 200 rows · all 24 columns| scenario_idstring | impact_severitystring | delay_duration_minutesinteger | event_typestring | scenario_namestring | event_idstring | scenario_id_refstring | event_start_datetimedatetime | event_end_datetimedatetime | affected_route_idstring | route_namestring | origin_locationstring | destination_locationstring | route_distance_kmfloat | route_modestring | route_statusstring | log_idstring | affected_route_id_refstring | log_datetimedatetime | log_event_typestring | scenario_descriptionstring | event_descriptionstring | log_descriptionstring | reroute_detailsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SCN001 | critical | blank | natural_disaster | East Coast Hurricane Impact | EVT001 | SCN001 | 2023-08-21T06:00:00Z | 2023-08-24T18:00:00Z | ROUTE1001 | Charlotte to Norfolk Freight Link | Charlotte | Norfolk | 535.8 | road | closed | LOG0001 | ROUTE1001 | 2023-08-22T08:12:00Z | closure | A major hurricane disrupts freight traffic along the Eastern Seaboard, impacting multiple logistics hubs. | Hurricane force winds cause highway closures and port delays in the Carolinas. | Route closed due to major flooding and debris blocking main corridor. | blank |
| SCN002 | high | 1560 | natural_disaster | Transcontinental Snowstorm Disruption | EVT002 | SCN002 | 2023-12-10T02:00:00Z | 2023-12-15T17:00:00Z | ROUTE1002 | Chicago-St Paul Express | Chicago | St Paul | 634.2 | rail | delayed | LOG0002 | ROUTE1002 | 2023-12-12T09:00:00Z | delay | An unseasonal snowstorm halts rail and road transport across northern states. | Heavy snowfall causes derailments and impassable highways. | Rail services delayed due to snow accumulation and track clearing operations. | blank |
| SCN003 | medium | 520 | equipment_failure | Pacific Port Crane Malfunction | EVT003 | SCN003 | 2023-06-04T11:00:00Z | 2023-06-05T19:00:00Z | ROUTE1003 | Seattle to Yokohama Sea Lane | Seattle | Yokohama | 7678.3 | sea | delayed | LOG0003 | ROUTE1003 | 2023-06-04T18:30:00Z | delay | A critical crane failure at a busy seaport delays container unloading and onward shipping. | Main container crane stops working, disrupting cargo handling. | Sea route delayed due to port crane breakdown, awaiting repairs. | blank |
| SCN004 | high | blank | labor_strike | Border Labor Strike Fallout | EVT004 | SCN004 | 2023-04-14T05:00:00Z | 2023-04-19T10:00:00Z | ROUTE1004 | Windsor to Detroit Truck Route | Windsor | Detroit | 13.2 | road | closed | LOG0004 | ROUTE1004 | 2023-04-14T09:06:00Z | closure | A labor strike at a border crossing brings truck shipments to a halt for several days. | Customs staff walk out, blocking cross-border freight. | Truck movements suspended due to ongoing labor action at border. | blank |
| SCN005 | low | 55 | other | Routine Track Inspection | EVT005 | SCN005 | 2023-05-22T10:00:00Z | 2023-05-22T18:00:00Z | ROUTE1005 | Birmingham to Oxford Rail | Birmingham | Oxford | 143.7 | rail | delayed | LOG0005 | ROUTE1005 | 2023-05-22T12:30:00Z | delay | Scheduled safety inspection temporarily slows down cargo rail service. | Annual inspection causes minor delays on regional line. | Routine inspection slowed freight movements, minor schedule impact. | blank |
| SCN006 | low | blank | other | Test Case: Simulated Outlier | EVT006 | SCN006 | 2023-01-15T00:00:00Z | blank | ROUTE1006 | Moscow to Buenos Aires Ultra | Moscow | Buenos Aires | 13923.7 | multimodal | open | LOG0006 | ROUTE1006 | 2023-01-15T00:15:00Z | other | System test scenario with ultra-long distance and artificial disruption. | Simulated event to test system response; no real disruption. | Test log entry for system monitoring; no operational impact. | blank |
| SCN007 | high | 600 | equipment_failure | West Coast Port Backlog | EVT007 | SCN007 | 2023-09-08T13:00:00Z | 2023-09-08T19:45:00Z | ROUTE1007 | Long Beach to Shanghai | Long Beach | Shanghai | 10413.2 | sea | delayed | LOG0007 | ROUTE1007 | 2023-09-08T15:00:00Z | delay | Equipment malfunction at a major port causes container backlog and delays. | Container loader failure disrupts unloading at port. | Delays at port due to equipment breakdown, backlog expected for 10 hours. | blank |
| SCN008 | critical | blank | political_unrest | Central Europe Border Closure | EVT008 | SCN008 | 2023-03-02T03:00:00Z | blank | ROUTE1008 | Prague to Vienna Haul | Prague | Vienna | 333.9 | road | closed | LOG0008 | ROUTE1008 | 2023-03-02T06:00:00Z | closure | Political unrest leads to the closure of a major road border crossing. | Demonstrations force authorities to close border checkpoint. | Major road crossing closed due to unrest; alternate routes being considered. | blank |
| SCN009 | high | blank | natural_disaster | Tropical Storm Air Diversion | EVT009 | SCN009 | 2023-10-13T17:00:00Z | 2023-10-15T04:00:00Z | ROUTE1009 | Bangkok to Mumbai Air Freight | Bangkok | Mumbai | 2997.8 | air | rerouted | LOG0009 | ROUTE1009 | 2023-10-13T20:00:00Z | reroute | A tropical storm forces air cargo flights to be rerouted across South Asia. | Storm system disrupts direct air routes, causing rerouting. | Air route rerouted to avoid tropical storm; alternate waypoints assigned. | Rerouted via Colombo and Hyderabad for storm avoidance. |
| SCN010 | low | blank | other | Routine Safety Drill | EVT010 | SCN010 | 2023-07-16T13:30:00Z | 2023-07-16T14:45:00Z | ROUTE1010 | Dublin to Limerick Delivery | Dublin | Limerick | 200.1 | road | open | LOG0010 | ROUTE1010 | 2023-07-16T14:00:00Z | other | A scheduled drill simulates a minor disruption on a warehouse-to-hub route. | Simulated drill interrupts routine delivery for 30 minutes. | Safety drill completed successfully; minimal impact to schedule. | blank |
| SCN011 | medium | 410 | equipment_failure | Baltic Ferry Engine Failure | EVT011 | SCN011 | 2023-11-24T03:00:00Z | 2023-11-24T21:00:00Z | ROUTE1011 | Stockholm to Tallinn Ferry | Stockholm | Tallinn | 380.5 | sea | delayed | LOG0011 | ROUTE1011 | 2023-11-24T05:32:00Z | delay | Engine trouble on a Baltic ferry delays sea freight between two ports. | Main engine malfunction causes ferry to remain docked for repairs. | Shipping delayed due to unscheduled engine maintenance. | blank |
| SCN012 | low | blank | other | Short Route Test Case | EVT012 | SCN012 | 2023-02-19T08:00:00Z | blank | ROUTE1012 | Local Warehouse Shuttle | Berlin | Berlin | 2.1 | road | open | LOG0012 | ROUTE1012 | 2023-02-19T08:03:00Z | other | Test case for short-haul delivery with no significant disruption. | System test: short route, minimal disruption. | Routine system test completed; no impact to operations. | blank |
| SCN013 | critical | blank | accident | Major Bridge Collapse Incident | EVT013 | SCN013 | 2023-06-22T15:00:00Z | blank | ROUTE1013 | Memphis to Little Rock Express | Memphis | Little Rock | 213.6 | road | closed | LOG0013 | ROUTE1013 | 2023-06-22T15:17:00Z | closure | A major bridge collapse interrupts freight shipments on a vital corridor. | Bridge collapse due to structural failure halts all traffic. | Bridge collapse reported, route closed to all traffic pending inspection. | blank |
| SCN014 | high | blank | natural_disaster | Overseas Air Cargo Reroute | EVT014 | SCN014 | 2023-09-20T21:00:00Z | 2023-09-22T07:00:00Z | ROUTE1014 | New York to Frankfurt Cargo Air | New York | Frankfurt | 6215.6 | air | rerouted | LOG0014 | ROUTE1014 | 2023-09-21T00:40:00Z | reroute | An unexpected weather system necessitates air cargo rerouting between continents. | Severe weather prompts rerouting of transatlantic flights. | Flight rerouted via Reykjavik due to severe weather over North Atlantic. | Alternate route via Iceland, avoiding storm system. |
| SCN015 | low | blank | other | Routine Equipment Maintenance | EVT015 | SCN015 | 2023-05-08T06:00:00Z | 2023-05-08T20:00:00Z | ROUTE1015 | Rotterdam to Paris Multimodal | Rotterdam | Paris | 477.4 | multimodal | open | LOG0015 | ROUTE1015 | 2023-05-08T07:40:00Z | other | Scheduled maintenance on a multimodal route causes minor delays. | Planned maintenance for cargo handling cranes and trucks. | Scheduled maintenance completed, minimal delays reported. | blank |
| SCN016 | medium | 60 | other | Intermodal Route Upgrade Testing | EVT016 | SCN016 | 2023-03-30T09:00:00Z | 2023-03-30T11:00:00Z | ROUTE1016 | Madrid to Dakar Cross-Continent | Madrid | Dakar | 3984.9 | multimodal | delayed | LOG0016 | ROUTE1016 | 2023-03-30T10:00:00Z | delay | System upgrade testing causes brief delays on a cross-continental multimodal route. | Software upgrade for intermodal tracking; short-lived delays. | Minor delays during system upgrade, tracking resumed after 1 hour. | blank |
| SCN017 | critical | blank | accident | Canal Blockage Incident | EVT017 | SCN017 | 2023-04-03T16:00:00Z | blank | ROUTE1017 | Port Said to Suez Sea Route | Port Said | Suez | 193 | sea | closed | LOG0017 | ROUTE1017 | 2023-04-03T17:20:00Z | closure | A grounded ship blocks a major shipping canal, halting maritime freight. | Container vessel runs aground, blocking canal passage. | Sea route closed as vessel remains grounded, salvage teams deployed. | blank |
| SCN018 | high | blank | accident | Highway Accident Delays | EVT018 | SCN018 | 2023-07-18T07:00:00Z | 2023-07-18T14:30:00Z | ROUTE1018 | Toronto to Kingston Road | Toronto | Kingston | 263.5 | road | closed | LOG0018 | ROUTE1018 | 2023-07-18T08:30:00Z | closure | A multi-vehicle accident causes significant delays on a busy highway corridor. | Pile-up on highway 401 results in total lane closure for several hours. | Route closed for crash investigation and debris clearance; alternate routes congested. | blank |
| SCN019 | high | 1200 | natural_disaster | Northern Region Flooding | EVT019 | SCN019 | 2023-05-01T06:00:00Z | 2023-05-05T12:00:00Z | ROUTE1019 | Hanoi to Nanning Rail Link | Hanoi | Nanning | 402 | rail | delayed | LOG0019 | ROUTE1019 | 2023-05-02T09:00:00Z | delay | Seasonal flooding disrupts road and rail cargo flows in the northern region. | Prolonged rainfall leads to widespread flooding, halting logistics. | Rail movement delayed by flooding; pumping operations underway. | blank |
| SCN020 | medium | 112 | other | Intermodal System Simulation | EVT020 | SCN020 | 2023-06-01T08:00:00Z | blank | ROUTE1020 | Hamburg to Ulaanbaatar Multimodal | Hamburg | Ulaanbaatar | 10482.5 | multimodal | delayed | LOG0020 | ROUTE1020 | 2023-06-01T09:45:00Z | delay | Simulated event tests multimodal response on a long-haul route. | Test event: switching from sea to rail with simulated delay. | Simulated intermodal transfer delay; system performance within normal limits. | blank |
What the 200 rows show
from the 200-row sampleHigh (impact severity) stands out: mean delay_
- 297.5median delay_
duration_ minutes - 4route statuses
- 5route modes
- 5log event types
- 394.0median route_
distance_ km
Median 297.5, from 18 to 1,800.
- string 19
- integer 1
- float 1
- datetime 3
Columns
24 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 19 columns | |||
scenario_id | string | Unique identifier for each disruption scenariounique | SCN001 |
scenario_name | string | Descriptive name for the disruption scenario | Routine Track Inspection |
scenario_description | string | Detailed description of the disruption scenariooptional | A major hurricane disrupt… |
event_id | string | Unique identifier for each disruption eventunique | EVT001 |
scenario_id_ref | string | Reference to the scenario_id this event belongs to | SCN001 |
event_type | string | Type of disruption event (e.g., natural disaster, labor strike, accident)6 values | natural_disaster |
event_description | string | Detailed description of the disruption eventoptional | Hurricane force winds cau… |
affected_route_id | string | Identifier for the supply chain route affected by the event | ROUTE1001 |
route_name | string | Descriptive name for the affected routeoptional | Chicago-St Paul Express |
origin_location | string | Starting point of the supply chain route (city or facility name) | Charlotte |
destination_location | string | End point of the supply chain route (city or facility name) | Norfolk |
route_mode | string | Mode of transportation for the route (e.g., road, rail, air, sea)road · rail · air · sea · multimodal | road |
route_status | string | Current operational status of the route (e.g., open, delayed, closed, rerouted)open · delayed · closed · rerouted | closed |
log_id | string | Unique identifier for each route log entryunique | LOG0001 |
affected_route_id_ref | string | Reference to the affected_route_id this log entry pertains to | ROUTE1001 |
log_event_type | string | Type of route log event (e.g., delay, reroute, closure, recovery)delay · reroute · closure · recovery · other | closure |
log_description | string | Details about the route log eventoptional | Route closed due to major… |
reroute_details | string | Description of reroute path or alternative route, if applicableoptional | Rerouted via Colombo and … |
impact_severity | string | Severity of the disruption's impact on the route (e.g., low, medium, high, critical)low · medium · high · critical · optional | critical |
| Numbers 2 columns | |||
route_distance_km | float | Total distance of the route in kilometers0 or more · optional | 535.8 |
delay_duration_minutes | integer | Duration of delay in minutes, if applicable0 or more · optional | 1560 |
| Dates and times 3 columns | |||
event_start_datetime | datetime | Date and time when the disruption event started | 2023-08-21T06:00:00Z |
event_end_datetime | datetime | Date and time when the disruption event endedoptional | 2023-08-24T18:00:00Z |
log_datetime | datetime | Timestamp for when the log entry was recorded | 2023-08-22T08:12:00Z |
Use it for
A logistics dashboard
Delay_
duration_ minutes by impact_ severity and a breakdown of event_ type. Excel, Power BI or Tableau. Why do the 26 high rows have a mean delay_
duration_ minutes of 833.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Scenarios200SCN001criticalSCN0021560highSCN003520medium
A software demo
Believable scenarios with scenario_
name, scenario_ description and event_ id to fill a screen in front of a buyer.
This dataset200 rows24 columns
Yours1,000 rows24 columnsorigin_location: UK only
blueprint · supply-chain-route-disruption-scenarios
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 24 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
- Define route segments with ETA and cargo details
- Inject realistic delay and disruption events
- Include weather, customs, and labor event triggers
- Simulate multi-modal (road, rail, sea) shipments
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
- supply-chain-route-disruption-scenarios