Supply Chain Route Optimization

This dataset provides granular details on optimized supply chain shipment routes, including origin and destination addresses, vehicle assignments, freight load metrics, delivery times, and route costs. It enables logistics professionals to analyze and improve delivery efficiency, reduce transportation costs, and benchmark route optimization strategies across multiple carriers and vehicle types.

  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Optimizing shipment routes to minimize cost and delivery time

Sample rows

preview · 8 of 200 rows · all 30 columns
route_idstringvehicle_typestringfreight_load_volume_m3floatoptimizedbooleanoptimization_methodstringshipment_idstringorigin_facility_namestringorigin_street_addressstringorigin_citystringorigin_statestringorigin_postal_codestringorigin_countrystringdestination_facility_namestringdestination_street_addressstringdestination_citystringdestination_statestringdestination_postal_codestringdestination_countrystringdeparture_datetimedatetimearrival_datetimedatetimevehicle_idstringcarrier_namestringfreight_load_weight_kgfloatnumber_of_stopsintegerstopover_citiesstringroute_distance_kmfloatestimated_delivery_time_hoursfloatactual_delivery_time_hoursfloatroute_cost_usdfloatnotesstring
R-00001truck32.1trueshortest pathSHP-00001Chicago Distribution Hub1450 W Exchange AveChicagoIL60608USADallas Retail Center2201 Commerce BlvdDallasTX75201USA2024-06-03T10:15:002024-06-04T05:10:00TRK-87265AmeriFreight Transport8500.51Little Rock1476.318.518.923400Delivered electronics, minor traffic delay in Little Rock.
R-00002rail110.4trueleast costSHP-00002Toronto Main Terminal77 King StreetTorontoONM5H 1J5CanadaMontreal Logistics Point1282 Rue Sainte-CatherineMontrealQCH3B 1E5Canada2024-06-02T09:00:002024-06-02T17:30:00RL-35671Canadian National Railways210002Ottawa, Cornwall541.27.58.514500Fresh produce shipment, prioritized for speed.
R-00003ship5100trueleast costSHP-00003Bremen Port WarehouseAm Speicher XI 11BremenHB28217GermanyMumbai Shipping YardDock 14, Nhava ShevaMumbaiMH400707India2024-05-28T16:00:002024-06-15T13:30:00SHIP-0023Maersk Line India8200003Suez, Dubai, Kochi9670.7365375.597000Bulk machinery, customs clearance required at Suez.
R-00004air6.8truetime-windowSHP-00004Delhi Cargo TerminalPlot 25, IGI AirportDelhiDL110037IndiaLondon Heathrow Depot71 Sovereign RoadLondonLDNTW6 1EWUK2024-06-05T07:30:002024-06-05T18:00:00AIR-77912British Airways Cargo26000blank67209.51017800Medical equipment, urgent delivery.
R-00005van5.3falseblankSHP-00005New York Metro Hub2338 7th AvenueNew YorkNY10027USABoston Commercial Center155 Atlantic AvenueBostonMA02110USA2024-06-07T14:00:002024-06-07T19:30:00VN-31012Northeast Express12000blank3495.25.7650blank
R-00006truck35.5falseblankSHP-00006San Francisco Bay Depot185 Berry StreetSan FranciscoCA94107USASeattle Area Facility4501 Aurora Ave NSeattleWA98103USA2024-06-10T08:00:002024-06-11T02:00:00TRK-98145Pacific Logistics76002Portland, Olympia1295.217.918.33650Minor delay due to roadwork near Olympia.
R-00007rail95trueshortest pathSHP-00007Birmingham Express Depot21 Steelhouse LaneBirminghamWMDB4 6DRUKGlasgow Distribution Center33 Argyle StreetGlasgowGLGG2 8DLUK2024-06-11T05:45:002024-06-11T12:50:00RL-10045UK Rail Freight165001Manchester567.26.87.36400blank
R-00008truck41.8falseblankSHP-00008Los Angeles Freight Station101 Wilshire BlvdLos AngelesCA90025USAPhoenix Delivery Center3200 E Camelback RdPhoenixAZ85016USA2024-06-13T07:30:002024-06-13T17:10:00TRK-21009Sunshine Transport99001Palm Springs598.799.72100blank

What the 200 rows show

from the 200-row sample

Ship (vehicle type) stands out: mean freight_load_volume_m3 is 3,114, against 41.1 for the rest.

  • 67%optimized = true
  • 37.5median freight_load_volume_m3
  • 27origin countries
  • 35destination countries
  • 60origin states
  • 8,250median freight_load_weight_kg
Mean freight_load_volume_m3 by vehicle_type200 rows
02,0004,00036.5truck68 rows4.5van37 rows100.6rail40 rows9.2air21 rows3,114ship33 rows2.1other1 rows
freight_load_volume_m3200 rows, in bands of 1,000
08517016957106303,0006,000freight_load_volume_m3 →

Median 37.5, from 1.5 to 5,200.

optimization_method133 rows with a value · 67 left blank
  1. shortest path52
  2. least cost45
  3. time-window33
  4. other3
30 columns by typefrom the column list below
  • string 20
  • integer 1
  • float 6
  • datetime 2
  • boolean 1

Columns

30 columns in four groups
blueprint · 30 columns
columntypedescriptionexample
Text 20 columns
route_idstringUnique identifier for each optimized shipment routeuniqueR-00001
shipment_idstringUnique identifier for each shipment assigned to a routeuniqueSHP-00001
origin_facility_namestringName of the facility where the shipment originatesChicago Distribution Hub
origin_street_addressstringStreet address of the origin facility1450 W Exchange Ave
origin_citystringCity of the origin facilityChicago
origin_statestringState or province of the origin facilityIL
origin_postal_codestringPostal code of the origin facility60608
origin_countrystringCountry of the origin facilityUSA
destination_facility_namestringName of the facility where the shipment is deliveredDallas Retail Center
destination_street_addressstringStreet address of the destination facility2201 Commerce Blvd
destination_citystringCity of the destination facilityDallas
destination_statestringState or province of the destination facilityTX
destination_postal_codestringPostal code of the destination facility75201
destination_countrystringCountry of the destination facilityUSA
vehicle_idstringUnique identifier for the vehicle assigned to the shipmentTRK-87265
vehicle_typestringType of vehicle used for the shipment (e.g., truck, van, rail, air)6 valuestruck
carrier_namestringName of the carrier or logistics providerAmeriFreight Transport
stopover_citiesstringComma-separated list of cities where the shipment stops en routeoptionalLittle Rock
optimization_methodstringMethod or algorithm used for route optimization (e.g., shortest path, least cost, time-window)4 methods · optionalshortest path
notesstringAdditional notes or comments about the shipment or routeoptionalSmall business delivery.
Numbers 7 columns
freight_load_weight_kgfloatTotal weight of the freight load in kilograms0 or more8500.5
freight_load_volume_m3floatTotal volume of the freight load in cubic meters0 or more · optional32.1
number_of_stopsintegerTotal number of stops along the route (excluding origin and destination)0 or more1
route_distance_kmfloatTotal distance of the route in kilometers0 or more1476.3
estimated_delivery_time_hoursfloatEstimated total delivery time in hours0 or more18.5
actual_delivery_time_hoursfloatActual total delivery time in hours0 or more · optional18.92
route_cost_usdfloatTotal cost of the shipment route in US dollars0 or more3400
Dates and times 2 columns
departure_datetimedatetimeScheduled departure date and time from the origin facility2024-06-03T10:15:00
arrival_datetimedatetimeScheduled arrival date and time at the destination facility2024-06-04T05:10:00
True or false 1 column
optimizedbooleanIndicates whether the route was optimized by the systemtrue

Use it for

  • optimized67%133 of 200 rowsmean freight load vol…36.5truck4.5van100.6rail9.2air

    A logistics dashboard

    The optimized rate, freight_load_volume_m3 by vehicle_type and a breakdown of optimization_method. Excel, Power BI or Tableau.

  • Why do the 33 ship rows have a mean freight_load_volume_m3 of 3,114?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable routes with shipment_id, origin_facility_name and origin_street_address to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 30 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows30 columns
Yours1,000 rows30 columnsorigin_street_address: UK only

blueprint · supply-chain-route-optimization

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 30 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
  • Include shipment size and weight
  • Track route changes due to weather
  • Record actual delivery times
  • Flag delayed shipments
  • Categorize transport modes
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
supply-chain-route-optimization

More in Logistics

Browse all
Also in LogisticsLogistics Route Cost ComparisonCold Chain Logistics Temperature DataWarehouse Inventory Flow DatasetAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.