Supply Chain Delay Simulation
This dataset provides detailed records of manufactured orders and shipments, including supplier information, transport modes, and comprehensive delay tracking with reasons such as weather and supplier issues. It enables granular analysis of supply chain disruptions and supports optimization efforts by highlighting delay patterns and their root causes across global logistics networks.
Sample rows
preview · 8 of 200 rows · all 23 columns| order_idstring | delay_reasonstring | delay_duration_daysinteger | weather_impactboolean | destination_countrystring | order_datedate | product_idstring | product_namestring | quantity_orderedinteger | supplier_idstring | supplier_namestring | supplier_countrystring | shipment_idstring | shipment_datedate | expected_delivery_datedate | actual_delivery_datedate | origin_citystring | origin_countrystring | destination_citystring | transport_modestring | weather_descriptionstring | supplier_issue_flagboolean | supplier_issue_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ORD000001 | customs | 2 | false | USA | 2023-01-04 | P-EQ23 | Industrial Gear Assembly | 124 | SUP001 | Shanghai Precision | China | SHIPA01 | 2023-01-05 | 2023-01-14 | 2023-01-16 | Shanghai | China | Los Angeles | sea | blank | false | blank |
| ORD000002 | none | 0 | false | Germany | 2023-01-06 | P-HV87 | Hydraulic Valve Set | 55 | SUP002 | Wroclaw Engineering | Poland | SHIPB02 | 2023-01-07 | 2023-01-10 | 2023-01-10 | Wroclaw | Poland | Berlin | road | blank | false | blank |
| ORD000003 | customs | 2 | false | Canada | 2023-01-08 | P-RA124 | Robotic Arm Segment | 480 | SUP003 | FutureTech Labs | USA | SHIPC01 | 2023-01-10 | 2023-01-12 | 2023-01-14 | Austin | USA | Calgary | air | blank | false | blank |
| ORD000004 | weather | 2 | true | France | 2023-01-09 | P-PLD01 | Plastic Drive Housing | 25 | SUP004 | Italia Plastica | Italy | SHIPD05 | 2023-01-10 | 2023-01-13 | 2023-01-15 | Milan | Italy | Marseille | rail | Heavy snowstorm | false | blank |
| ORD000005 | none | 0 | false | Australia | 2023-01-11 | P-SE33 | Servo Encoder Module | 98 | SUP005 | Daegu Robotics | South Korea | SHIPE10 | 2023-01-13 | 2023-01-16 | 2023-01-16 | Daegu | South Korea | Brisbane | air | blank | false | blank |
| ORD000006 | none | 0 | false | Thailand | 2023-01-11 | P-MT12 | Motor Torque Sensor | 15 | SUP006 | Hanoi Electronics | Vietnam | SHIPF01 | 2023-01-13 | 2023-01-15 | 2023-01-15 | Hanoi | Vietnam | Bangkok | road | blank | false | blank |
| ORD000007 | none | 0 | false | USA | 2023-01-13 | P-BC99 | Bearing Cartridge | 890 | SUP007 | Guangzhou Bearings | China | SHIPG03 | 2023-01-14 | 2023-01-22 | 2023-01-22 | Guangzhou | China | San Francisco | sea | blank | false | blank |
| ORD000008 | transport | 1 | false | Czechia | 2023-01-14 | P-SSK2 | Sensor Kit | 26 | SUP008 | Krakow Supplies | Poland | SHIPH01 | 2023-01-16 | 2023-01-18 | 2023-01-19 | Krakow | Poland | Prague | road | blank | false | blank |
| ORD000009 | customs | 1 | false | Saudi Arabia | 2023-01-15 | P-TRK6 | Tracking Chipset | 143 | SUP009 | Mumbai Circuits | India | SHIPI07 | 2023-01-17 | 2023-01-24 | 2023-01-25 | Mumbai | India | Riyadh | sea | blank | false | blank |
| ORD000010 | none | 0 | false | Switzerland | 2023-01-16 | P-LC47 | Logic Controller | 48 | SUP010 | Munich Controls | Germany | SHIPJ06 | 2023-01-18 | 2023-01-22 | 2023-01-22 | Munich | Germany | Zurich | rail | blank | false | blank |
| ORD000011 | none | 0 | false | Czechia | 2023-01-17 | P-ABR3 | Abrasive Wheel Set | 12 | SUP011 | Katowice Metals | Poland | SHIPK04 | 2023-01-18 | 2023-01-20 | 2023-01-20 | Katowice | Poland | Ostrava | road | blank | false | blank |
| ORD000012 | weather | 2 | true | Australia | 2023-01-18 | P-PRT8 | Precision Rotor | 620 | SUP012 | Hsinchu Tech | Taiwan | SHIPL09 | 2023-01-19 | 2023-01-29 | 2023-01-31 | Hsinchu | Taiwan | Sydney | sea | Typhoon delays | false | blank |
| ORD000013 | none | 0 | false | Lithuania | 2023-01-20 | P-PLC9 | Programmable Controller | 14 | SUP013 | Warsaw Automation | Poland | SHIPM03 | 2023-01-21 | 2023-01-23 | 2023-01-23 | Warsaw | Poland | Vilnius | road | blank | false | blank |
| ORD000014 | supplier_issue | 3 | false | UK | 2023-01-21 | P-DRV1 | Heavy Duty Drive | 13400 | SUP003 | FutureTech Labs | USA | SHIPN15 | 2023-01-23 | 2023-01-25 | 2023-01-28 | Austin | USA | London | air | blank | true | Component shortage |
| ORD000015 | none | 0 | false | Slovenia | 2023-01-22 | P-LN12 | Linear Actuator | 29 | SUP014 | Vicenza Automation | Italy | SHIPO04 | 2023-01-24 | 2023-01-27 | 2023-01-27 | Vicenza | Italy | Ljubljana | rail | blank | false | blank |
| ORD000016 | customs | 1 | false | Australia | 2023-01-23 | P-TR88 | Transformer Core | 112 | SUP015 | Yokohama Electrics | Japan | SHIPP08 | 2023-01-25 | 2023-01-30 | 2023-01-31 | Yokohama | Japan | Melbourne | sea | blank | false | blank |
| ORD000017 | none | 0 | false | Poland | 2023-01-25 | P-PLR1 | Pallet Roller | 8 | SUP016 | Berlin Conveyor | Germany | SHIPQ01 | 2023-01-26 | 2023-01-29 | 2023-01-29 | Berlin | Germany | Warsaw | rail | blank | false | blank |
| ORD000018 | weather | 2 | true | Czechia | 2023-01-25 | P-ELT5 | Electromagnetic Tape | 21 | SUP017 | Poznan Magnetics | Poland | SHIPR02 | 2023-01-27 | 2023-01-30 | 2023-02-01 | Poznan | Poland | Brno | rail | Flooded tracks | false | blank |
| ORD000019 | customs | 2 | false | USA | 2023-01-28 | P-STR4 | Steering Module | 350 | SUP018 | Busan Controls | South Korea | SHIPS11 | 2023-01-30 | 2023-02-03 | 2023-02-05 | Busan | South Korea | Seattle | sea | blank | false | blank |
| ORD000020 | none | 0 | false | USA | 2023-01-29 | P-PRC5 | Pressure Control Valve | 9000 | SUP019 | Dallas Components | USA | SHIPT03 | 2023-01-31 | 2023-02-04 | 2023-02-04 | Dallas | USA | Miami | air | blank | false | blank |
What the 200 rows show
from the 200-row sampleNone (delay reason) stands out: mean delay_
- 12%weather_
impact = true - 1median delay_
duration_ days - 4transport modes
- 14supplier countries
- 14origin countries
- 53origin cities
Median 1, from 0 to 5.
- string 15
- integer 2
- date 4
- boolean 2
Columns
23 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
order_id | string | Unique identifier for the manufactured orderunique | ORD000001 |
product_id | string | Identifier for the product being ordered | P-EQ23 |
product_name | string | Name or description of the product | Industrial Gear Assembly |
supplier_id | string | Unique identifier for the supplier | SUP001 |
supplier_name | string | Name of the supplier | Shanghai Precision |
supplier_country | string | Country where the supplier is located | China |
shipment_id | string | Unique identifier for the shipmentunique | SHIPA01 |
origin_city | string | City where the shipment originated | Shanghai |
origin_country | string | Country where the shipment originated | China |
destination_city | string | Destination city for the shipment | Los Angeles |
destination_country | string | Destination country for the shipment | USA |
transport_mode | string | Mode of transport used for the shipment (e.g., air, sea, road, rail)air · sea · road · rail | sea |
delay_reason | string | Primary reason for delay, if any (e.g., weather, supplier_issue, customs, none)weather · supplier_issue · customs · transport · none · optional | customs |
weather_description | string | Description of the weather event (e.g., heavy rain, snowstorm); blank if no impactoptional | Heavy snowstorm |
supplier_issue_description | string | Description of the supplier issue (e.g., raw material shortage); blank if no issue7 descriptions · optional | Component shortage |
| Numbers 2 columns | |||
quantity_ordered | integer | Number of units ordered1 or more | 124 |
delay_duration_days | integer | Number of days the shipment was delayed (0 if no delay)0 or more | 2 |
| Dates and times 4 columns | |||
order_date | date | Date the order was placed | 2023-01-04 |
shipment_date | date | Date the shipment was dispatched | 2023-01-05 |
expected_delivery_date | date | Date the shipment is expected to arrive | 2023-01-14 |
actual_delivery_date | date | Date the shipment actually arrivedoptional | 2023-01-16 |
| True or false 2 columns | |||
weather_impact | boolean | Indicates if weather impacted the shipment (true/false) | false |
supplier_issue_flag | boolean | Indicates if a supplier issue caused a delay (true/false) | false |
Use it for
A logistics dashboard
The weather_
impact rate, delay_ duration_ days by delay_ reason and a breakdown of destination_ country. Excel, Power BI or Tableau. Why do the 94 none rows have a mean delay_
duration_ days of 0.0? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Orders200ORD0000012customsORD0000042weatherORD0000122weather
A software demo
Believable orders with order_
date, product_ id and product_ name to fill a screen in front of a buyer.
blueprint · supply-chain-delay-simulation
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 23 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.
- Delay causes classified by type
- Order lines link to delivery events
- Weather data merged by region/date
- Delay durations capped at 30 days
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-delay-simulation