Logistics
24 columns
200 rows
8 formats

Logistics Fleet Route Optimization Data

This dataset provides granular delivery route logs for logistics fleets, including vehicle and driver assignments, departure and arrival details, stop counts, delays, fuel usage, and route outcomes. It enables comprehensive route optimization, cost analysis, and operational efficiency improvements for logistics and supply chain management teams.

last updated 20 Aug 2025
by GoMask

The brief that made it

Route optimization and cost savings analysis

Sample rows

preview · 8 of 200 rows · all 24 columns

route_idstring	total_delay_minutesfloat	delivery_successfulboolean	origin_countrystring	vehicle_idstring	driver_idstring	departure_datetimedatetime	origin_street_addressstring	origin_citystring	origin_statestring	origin_postal_codestring	destination_street_addressstring	destination_citystring	destination_statestring	destination_postal_codestring	destination_countrystring	planned_stops_countinteger	actual_stops_countinteger	delay_reason_summarystring	fuel_used_litersfloat	distance_traveled_kmfloat	route_duration_minutesfloat	average_speed_kmhfloat	notesstring
R0001	9.5	true	USA	V1001	D2101	2024-05-06T08:13:00	112 Maple Ave	Dallas	TX	75201	349 Oak St	Houston	TX	77002	USA	3	3	Minor traffic congestion near city center	38.6	383.2	235	81.1	Smooth run, customer praised promptness
R0002	0	true	CAN	V1002	D2102	2024-05-06T10:57:00	17 Queen St W	Toronto	ON	M5H 2N2	255 King St E	Toronto	ON	M5A 1K2	CAN	2	2	blank	4.1	7.8	20	23.4	Express parcel, delivered in record time
R0003	47	false	CAN	V1003	D2103	2024-05-07T19:24:00	9 Rue Saint-Paul	Montreal	QC	H2Y 1E9	81 Boulevard René-Lévesque	Montreal	QC	H2Z 1N3	CAN	9	8	One recipient unavailable, weather delays	34.5	93.2	249	22.5	Longest city circuit, all except 1 delivery completed
R0004	0	true	GBR	V1004	D2104	2024-05-07T07:35:00	44 Baker St	London	LDN	NW1 6XE	182 Oxford St	London	LDN	W1D 1NN	GBR	1	1	blank	2.2	5.4	12	27	Urgent document, delivered before 8am
R0005	0	false	USA	V1005	D2105	2024-05-07T13:10:00	555 S Michigan Ave	Chicago	IL	60605	320 N Clark St	Chicago	IL	60654	USA	0	0	blank	0	0	0	0	Canceled route, no pickup requested
R0006	2.1	true	USA	V1006	D2106	2024-05-06T21:44:00	1425 Broadway	New York	NY	10018	700 8th Ave	New York	NY	10036	USA	2	2	Brief loading delay at origin	3.7	6.6	18	22	Fast delivery, late evening run
R0007	0	true	USA	V1007	D2107	2024-05-08T11:32:00	81 Market St	San Francisco	CA	94103	550 Howard St	San Francisco	CA	94105	USA	1	1	blank	2.4	4.1	11	22.4	Express parcel, delivered on time
R0008	0	true	CAN	V1008	D2108	2024-05-08T15:00:00	77 Yonge St	Toronto	ON	M5E 1J4	100 Front St W	Toronto	ON	M5J 1E3	CAN	3	3	blank	3.3	5.5	15	22	Fast delivery, all parcels on schedule
R0009	6.2	true	USA	V1009	D2109	2024-05-09T06:55:00	501 7th Ave	New York	NY	10018	11 Wall St	New York	NY	10005	USA	2	2	Elevator malfunction at destination	3.9	8.3	24	20.8	Morning delivery, minor recipient delay
R0010	0	true	AUS	V1010	D2110	2024-05-08T20:02:00	188 King St	Sydney	NSW	2000	76 Pitt St	Sydney	NSW	2000	AUS	1	1	blank	1.9	2.7	8	20.2	Midnight delivery, express service
R0011	17.5	false	USA	V1011	D2111	2024-05-09T13:22:00	422 Main St	Madison	WI	53703	900 University Ave	Milwaukee	WI	53202	USA	4	3	Recipient not present at final stop	29.8	143.6	101	85.3	Missed last stop, partial delivery
R0012	38.9	true	CAN	V1012	D2112	2024-05-10T15:34:00	400 Sainte-Catherine St	Montreal	QC	H3B 1A2	295 Sherbrooke St W	Montreal	QC	H2X 1Y6	CAN	9	9	Heavy rain caused traffic delays	42.6	109.4	327	20.1	Longest city circuit, all deliveries completed
R0013	0	true	USA	V1013	D2113	2024-05-09T12:10:00	99 Elm St	Boston	MA	02110	338 Beacon St	Boston	MA	02116	USA	2	2	blank	2.8	4.9	13	22.6	Quick run, no delays
R0014	0	true	GBR	V1014	D2114	2024-05-10T08:51:00	23 Southgate St	Bath	BAS	BA1 1TP	4 Pulteney Rd	Bath	BAS	BA2 4BP	GBR	2	2	blank	2.5	3.6	9	24	Express parcel, delivered before noon
R0015	13.5	false	USA	V1015	D2115	2024-05-11T17:17:00	801 Grant Ave	San Francisco	CA	94108	1390 Market St	San Francisco	CA	94102	USA	3	2	Customer unavailable at 2nd stop	2.9	6.1	18	20.3	Partial delivery, one missed stop
R0016	0	false	CAN	V1016	D2116	2024-05-11T22:25:00	2100 Bloor St W	Toronto	ON	M6S 1M7	1396 Gerrard St E	Toronto	ON	M4L 1Z2	CAN	0	0	blank	0	0	0	0	Canceled route, vehicle failure reported
R0017	52.3	false	SGP	V1017	D2117	2024-05-12T07:34:00	88 Victoria St	Singapore	SG	188017	32 Orchard Rd	Singapore	SG	238895	SGP	10	9	One package returned by recipient	48.7	124.1	319	23.3	Longest city route, all but one delivered
R0018	0	true	GBR	V1018	D2118	2024-05-12T09:22:00	12 High St	Birmingham	WMD	B4 7SL	155 Broad St	Birmingham	WMD	B15 1DA	GBR	2	2	blank	2.1	3.9	10	23.4	Express parcel, all stops completed
R0019	8.7	true	USA	V1019	D2119	2024-05-13T12:06:00	301 Main St	Dallas	TX	75202	420 Cedar Springs Rd	Dallas	TX	75219	USA	3	3	Roadwork near destination	3.5	5.7	17	20.1	Minor delay, delivery completed
R0020	101.2	true	CAN	V1020	D2120	2024-05-13T16:42:00	10 de la Gauchetière St	Montreal	QC	H2Z 2A2	85 McGill St	Montreal	QC	H2Y 2E7	CAN	11	11	Severe thunderstorm caused traffic jams	72.3	251.3	370	40.8	Record delay, all stops completed

What the 200 rows show

from the 200-row sample

76%delivery_successful = true
0.0median total_delay_minutes
12destination countries
43origin states
43destination states
49origin cities

total_delay_minutes200 rows, in bands of 20

Median 0.0, from 0.0 to 125.3.

origin_country200 rows · top 10 of 12 values

USA113
CAN52
AUS11
GBR7
FRA6
CHN3
NZL2
SG2
SGP1
NZ1

24 columns by typefrom the column list below

string 15
integer 2
float 5
datetime 1
boolean 1

Columns

24 columns in four groups

blueprint · 24 columns
column	type	description	example
Text 15 columns
`route_id`	string	Unique identifier for each delivery route instanceunique	R0001
`vehicle_id`	string	Unique identifier for the fleet vehicle assigned to the route	V1001
`driver_id`	string	Unique identifier for the driver assigned to the route	D2101
`origin_street_address`	string	Street address of the route's starting location	112 Maple Ave
`origin_city`	string	City of the route's starting location	Dallas
`origin_state`	string	State of the route's starting location	TX
`origin_postal_code`	string	Postal code of the route's starting location	75201
`origin_country`	string	Country of the route's starting location12 countries	USA
`destination_street_address`	string	Street address of the route's final destination	349 Oak St
`destination_city`	string	City of the route's final destination	Houston
`destination_state`	string	State of the route's final destination	TX
`destination_postal_code`	string	Postal code of the route's final destination	77002
`destination_country`	string	Country of the route's final destination12 countries	USA
`delay_reason_summary`	string	Summary of reasons for delays encountered during the routeoptional	Loading dock unavailable
`notes`	string	Additional notes or comments about the routeoptional	Quick run, no delays
Numbers 7 columns
`planned_stops_count`	integer	Total number of planned stops along the route0 or more	3
`actual_stops_count`	integer	Total number of actual stops made along the route0 or more	3
`total_delay_minutes`	float	Total delay time in minutes encountered during the route0 or more	9.5
`fuel_used_liters`	float	Total fuel consumed during the route in liters0 or more	38.6
`distance_traveled_km`	float	Total distance traveled during the route in kilometers0 or more	383.2
`route_duration_minutes`	float	Total duration of the route in minutes0 or more	235
`average_speed_kmh`	float	Average speed of the vehicle during the route in kilometers per hour0 or more · optional	81.1
Dates and times 1 column
`departure_datetime`	datetime	Date and time when the vehicle departed for the route	2024-05-06T08:13:00
True or false 1 column
`delivery_successful`	boolean	Indicates whether the delivery was completed successfully	true

Use it for

A logistics dashboard
The delivery_successful rate, total_delay_minutes and a breakdown of origin_country. Excel, Power BI or Tableau.
Why do 152 of 200 rows have delivery_successful = true?
A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
Routes200
R00019.5true
R00020true
R000347false
A software demo
Believable routes with vehicle_id, driver_id and departure_datetime to fill a screen in front of a buyer.

This dataset200 rows24 columns

Yours1,000 rows24 columnsorigin_street_address: UK only

blueprint · logistics-fleet-route-optimization-data

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

Vehicle and route IDs anonymized
Departure, stop, arrival timestamps logged
Delay reasons annotated
Fuel usage calculated per route
Weather impact simulated

Rows1,000 rows10,000 rows100,000 rows1,000,000 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: logistics-fleet-route-optimization-data

What should your data show?

No signup. No card.

Sample rows

What the 200 rows show

Columns

Use it for

A logistics dashboard

A class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Logistics

What should your data show?