Logistics Route Cost Comparison
This dataset provides detailed trip-level logistics data, including route information, cost breakdowns, and delivery performance metrics. It enables logistics providers to analyze route efficiency, optimize costs, and improve delivery reliability across various carriers and vehicle types. The data is ideal for benchmarking, route planning, and operational improvement.
Sample rows
preview · 8 of 200 rows · all 24 columns| trip_idstring | vehicle_typestring | labor_cost_usdfloat | origin_statestring | route_namestring | origin_citystring | origin_countrystring | destination_citystring | destination_statestring | destination_countrystring | departure_datetimedatetime | arrival_datetimedatetime | distance_kmfloat | carrier_namestring | total_cost_usdfloat | fuel_cost_usdfloat | toll_cost_usdfloat | other_cost_usdfloat | num_deliveriesinteger | on_time_deliveriesinteger | late_deliveriesinteger | delivery_success_ratefloat | average_delivery_time_minutesfloat | trip_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TRIP0001 | truck | 500 | TX | Route-ATX-DFW | Austin | USA | Dallas | TX | USA | 2024-05-01T07:15:00 | 2024-05-01T13:45:00 | 330.2 | Lone Star Freight | 925.25 | 340.6 | 45.1 | 39.55 | 6 | 5 | 1 | 100 | 76.8 | Heavy rain near Waco caused minor delay in delivery. |
| TRIP0002 | van | 110 | blank | Route-LON-MAN | London | UK | Manchester | blank | UK | 2024-05-02T09:10:00 | 2024-05-02T13:55:00 | 325.7 | BritExpress Logistics | 210.1 | 58.2 | 15.5 | 26.4 | 3 | 3 | 0 | 100 | 88.5 | Roadworks in Birmingham but all deliveries remained on time. |
| TRIP0003 | train | 750 | blank | Route-BJS-SHA | Beijing | China | Shanghai | blank | China | 2024-05-03T17:00:00 | 2024-05-04T07:30:00 | 1066.8 | China Rail Logistics | 1180 | 380 | 0 | 50 | 13 | 13 | 0 | 100 | 49.2 | Scheduled overnight run, all deliveries early. |
| TRIP0004 | airplane | 1150 | blank | Route-TYO-OSA | Tokyo | Japan | Osaka | blank | Japan | 2024-05-04T06:30:00 | 2024-05-04T08:20:00 | 515.3 | Nippon Jet Express | 1885 | 690 | 0 | 45 | 17 | 16 | 1 | 100 | 32.9 | Short transfer delay at Haneda, one late parcel. |
| TRIP0005 | truck | 390 | RJ | Route-RIO-SP | Rio de Janeiro | Brazil | São Paulo | SP | Brazil | 2024-05-06T08:00:00 | 2024-05-06T16:15:00 | 435.9 | Brasil Transportes | 765 | 295 | 55 | 25 | 5 | 4 | 1 | 100 | 89.5 | Heavy traffic at São Paulo entrance, minor late delivery. |
| TRIP0006 | truck | 525 | CA | Route-SFO-LAX | San Francisco | USA | Los Angeles | CA | USA | 2024-05-08T05:45:00 | 2024-05-08T13:10:00 | 612.8 | Pacific Coast Freight | 1052.5 | 410 | 78.5 | 39 | 8 | 8 | 0 | 100 | 68.1 | Smooth trip, no delays, clear weather. |
| TRIP0007 | truck | 480 | CDMX | Route-MEX-GDL | Mexico City | Mexico | Guadalajara | JAL | Mexico | 2024-05-09T07:30:00 | 2024-05-09T15:20:00 | 550.6 | Transportes Azteca | 892.25 | 330.4 | 60 | 21.85 | 7 | 6 | 1 | 100 | 74.2 | Minor vehicle inspection delay, one late delivery. |
| TRIP0008 | van | 65 | blank | Route-BRU-AMS | Brussels | Belgium | Amsterdam | blank | Netherlands | 2024-05-10T06:00:00 | 2024-05-10T09:10:00 | 208.6 | Flemish Deliveries | 120.2 | 30 | 10 | 15.2 | 2 | 2 | 0 | 100 | 58.3 | Smooth cross-border run, no incidents. |
| TRIP0009 | train | 650 | DL | Route-DEL-MUM | Delhi | India | Mumbai | MH | India | 2024-05-11T16:20:00 | 2024-05-12T07:05:00 | 1432 | Indian Rail Logistics | 1120.5 | 390 | 27.5 | 53 | 15 | 15 | 0 | 100 | 63.5 | All deliveries on time, overnight run. |
| TRIP0010 | bike | blank | blank | Route-TEST-NULLS | Testville | USA | Nulltown | blank | USA | 2024-05-12T02:00:00 | 2024-05-12T03:00:00 | 0.1 | Null Logistics Inc | 0.01 | 0 | blank | blank | 1 | 1 | 0 | 100 | blank | Test trip with minimum values and null cost breakdowns. |
| TRIP0011 | truck | 900 | GP | Route-JHB-CT | Johannesburg | South Africa | Cape Town | WC | South Africa | 2024-05-13T05:30:00 | 2024-05-13T17:30:00 | 1406 | Rainbow Logistics SA | 1480 | 480 | 35 | 65 | 10 | 9 | 1 | 100 | 87.5 | One late delivery due to road construction near Worcester. |
| TRIP0012 | train | 590 | VIC | Route-MEL-SYD | Melbourne | Australia | Sydney | NSW | Australia | 2024-05-14T04:15:00 | 2024-05-14T10:10:00 | 878.4 | Aussie Rail Logistics | 1015 | 355 | 22 | 48 | 11 | 11 | 0 | 100 | 79.8 | Early arrival, all deliveries on time. |
| TRIP0013 | van | 190 | blank | Route-LIS-MAD | Lisbon | Portugal | Madrid | blank | Spain | 2024-05-15T07:30:00 | 2024-05-15T13:40:00 | 645.2 | Iberia Express | 340 | 99 | 15 | 36 | 4 | 4 | 0 | 100 | 92.4 | Border crossing smooth, all deliveries on time. |
| TRIP0014 | truck | 480 | WA | Route-SEA-PDX | Seattle | USA | Portland | OR | USA | 2024-05-16T06:30:00 | 2024-05-16T11:05:00 | 277.4 | Cascade Logistics | 785 | 245 | 32 | 28 | 5 | 4 | 1 | 100 | 80.8 | Interstate bridge traffic caused minor delay. |
| TRIP0015 | truck | 540 | ON | Route-YYZ-YUL | Toronto | Canada | Montreal | QC | Canada | 2024-05-17T08:00:00 | 2024-05-17T14:25:00 | 541.8 | Maple Leaf Freight | 1002 | 370 | 52 | 40 | 7 | 7 | 0 | 100 | 77.3 | Smooth trip, all deliveries on time, light traffic. |
| TRIP0016 | truck | 390 | CA | Route-LAX-SD | Los Angeles | USA | San Diego | CA | USA | 2024-05-18T04:20:00 | 2024-05-18T09:00:00 | 195.5 | SoCal Transporters | 655 | 220 | 25 | 20 | 4 | 3 | 1 | 100 | 92.5 | One late delivery due to accident on I-5. |
| TRIP0017 | van | 103 | blank | Route-HAM-BER | Hamburg | Germany | Berlin | blank | Germany | 2024-05-19T08:45:00 | 2024-05-19T11:30:00 | 289.1 | Deutsche Deliveries | 185.5 | 52 | 10 | 20.5 | 2 | 2 | 0 | 100 | 75 | Light city traffic, no delays. |
| TRIP0018 | truck | 300 | MH | Route-BOM-PUN | Mumbai | India | Pune | MH | India | 2024-05-20T10:15:00 | 2024-05-20T13:00:00 | 148.8 | Maharashtra Logistics | 470 | 140 | 22 | 8 | 3 | 3 | 0 | 100 | 85.6 | All deliveries completed on time. |
| TRIP0019 | van | 170 | blank | Route-MAD-BCN | Madrid | Spain | Barcelona | blank | Spain | 2024-05-21T08:00:00 | 2024-05-21T13:30:00 | 623.5 | Catalonia Express | 295.2 | 85 | 17.5 | 22.7 | 3 | 2 | 1 | 100 | 112 | One late delivery due to local festival detour. |
| TRIP0020 | airplane | 900 | blank | Route-JPN-NAGOYA | Tokyo | Japan | Nagoya | blank | Japan | 2024-05-22T12:00:00 | 2024-05-22T14:30:00 | 348.1 | Tokyo Jet Freight | 1482 | 510 | 0 | 72 | 15 | 14 | 1 | 100 | 36.7 | Arrival on time, one late due to ground handling. |
What the 200 rows show
from the 200-row sampleAirplane (vehicle type) stands out: mean labor_
- 390.0median labor_
cost_ usd - 31origin countries
- 34destination countries
- 395.7median distance_
km - 717.7median total_
cost_ usd - 253.3median fuel_
cost_ usd
Median 390.0, from 0.0 to 5,400.
- string 11
- integer 3
- float 8
- datetime 2
Columns
24 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
trip_id | string | Unique identifier for each logistics tripunique | TRIP0001 |
route_name | string | Name or code of the route taken during the trip | Route-ATX-DFW |
origin_city | string | City where the trip originated | Austin |
origin_state | string | State where the trip originatedoptional | TX |
origin_country | string | Country where the trip originated | USA |
destination_city | string | City where the trip ended | Dallas |
destination_state | string | State where the trip endedoptional | TX |
destination_country | string | Country where the trip ended | USA |
vehicle_type | string | Type of vehicle used for the trip (e.g., truck, van, bike)7 values | truck |
carrier_name | string | Name of the logistics provider or carrier | Lone Star Freight |
trip_notes | string | Additional notes or comments about the tripoptional | Quiet day, no delays. |
| Numbers 11 columns | |||
distance_km | float | Total distance covered during the trip in kilometers0 or more | 330.2 |
total_cost_usd | float | Total cost incurred for the trip in US dollars0 or more | 925.25 |
fuel_cost_usd | float | Cost of fuel for the trip in US dollars0 or more · optional | 340.6 |
toll_cost_usd | float | Cost of tolls for the trip in US dollars0 or more · optional | 45.1 |
labor_cost_usd | float | Cost of labor for the trip in US dollars0 or more · optional | 500 |
other_cost_usd | float | Other miscellaneous costs for the trip in US dollars0 or more · optional | 39.55 |
num_deliveries | integer | Number of deliveries made during the trip1 or more | 6 |
on_time_deliveries | integer | Number of deliveries completed on or before the scheduled time0 or more | 5 |
late_deliveries | integer | Number of deliveries completed after the scheduled time0 or more | 1 |
delivery_success_rate | float | Percentage of successful deliveries (0-100)0 to 100 | 100 |
average_delivery_time_minutes | float | Average time taken per delivery in minutes0 or more · optional | 76.8 |
| Dates and times 2 columns | |||
departure_datetime | datetime | Date and time when the trip started | 2024-05-01T07:15:00 |
arrival_datetime | datetime | Date and time when the trip ended | 2024-05-01T13:45:00 |
Use it for
A logistics dashboard
Labor_
cost_ usd by vehicle_ type and a breakdown of origin_ state. Excel, Power BI or Tableau. Why do the 19 airplane rows have a mean labor_
cost_ usd of 1,624? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Trips200TRIP0001500truckTRIP0002110vanTRIP0003750train
A software demo
Believable trips with route_
name, origin_ city and origin_ state to fill a screen in front of a buyer.
This dataset200 rows24 columns
Yours1,000 rows24 columnsorigin_city: UK only
blueprint · logistics-route-cost-comparison
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
- Route, distance, and vehicle type tracked
- Trip costs itemized
- Delivery performance and timing included
- Alternative routes compared
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
- logistics-route-cost-comparison