Last-Mile Delivery Route Data
This dataset provides granular, real-world data on last-mile delivery routes, including stop-level outcomes, timing, geolocation, and package details. It enables robust analysis for optimizing logistics operations, improving route efficiency, and enhancing ETA predictions. Designed for use in logistics analytics, routing algorithm development, and operational performance benchmarking.
Sample rows
preview · 8 of 202 rows · all 26 columns| route_idstring | delivery_statusstring | distance_traveled_kmfloat | signature_capturedboolean | delivery_address_countrystring | route_datedate | vehicle_idstring | driver_idstring | delivery_idstring | stop_sequenceinteger | customer_idstring | delivery_address_streetstring | delivery_address_citystring | delivery_address_statestring | delivery_address_postal_codestring | scheduled_arrival_timedatetime | actual_arrival_timedatetime | scheduled_departure_timedatetime | actual_departure_timedatetime | failure_reasonstring | package_countinteger | delivered_package_countinteger | travel_time_minutesfloat | stop_latitudefloat | stop_longitudefloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R101-20240410 | delivered | 0 | true | USA | 2024-04-10 | VAN-001 | DRV-2101 | D001-R101-20240410 | 1 | CUS-3001 | 100 Market St | San Francisco | CA | 94105 | 2024-04-10T09:30:00Z | 2024-04-10T09:32:00Z | 2024-04-10T09:40:00Z | 2024-04-10T09:42:00Z | blank | 3 | 3 | 0 | 37.7936 | -122.3965 | Delivered to front desk, signed by Jane. |
| R101-20240410 | delivered | 3.1 | false | USA | 2024-04-10 | VAN-001 | DRV-2101 | D002-R101-20240410 | 2 | CUS-3002 | 205 Pine St | San Francisco | CA | 94111 | 2024-04-10T10:00:00Z | 2024-04-10T10:03:00Z | 2024-04-10T10:10:00Z | 2024-04-10T10:13:00Z | blank | 1 | 1 | 20 | 37.792 | -122.3997 | blank |
| R101-20240410 | partial | 6.8 | true | USA | 2024-04-10 | VAN-001 | DRV-2101 | D003-R101-20240410 | 3 | CUS-3003 | 501 Van Ness Ave | San Francisco | CA | 94102 | 2024-04-10T10:40:00Z | 2024-04-10T10:55:00Z | 2024-04-10T10:50:00Z | 2024-04-10T11:01:00Z | blank | 4 | 2 | 37 | 37.779 | -122.4192 | Customer refused 2 boxes due to damage. |
| R102-20240410 | delivered | 0 | true | USA | 2024-04-10 | TRUCK-002 | DRV-3002 | D001-R102-20240410 | 1 | CUS-4021 | 1234 Jefferson Ave | Detroit | MI | 48226 | 2024-04-10T08:15:00Z | 2024-04-10T08:14:00Z | 2024-04-10T08:25:00Z | 2024-04-10T08:27:00Z | blank | 5 | 5 | 0 | 42.3327 | -83.0485 | blank |
| R102-20240410 | delivered | 10.4 | false | USA | 2024-04-10 | TRUCK-002 | DRV-3002 | D002-R102-20240410 | 2 | CUS-4022 | 900 Lafayette St | Detroit | MI | 48207 | 2024-04-10T09:10:00Z | 2024-04-10T09:08:00Z | 2024-04-10T09:20:00Z | 2024-04-10T09:26:00Z | blank | 2 | 2 | 55 | 42.3459 | -83.0272 | blank |
| R103-20240410 | delivered | 0 | true | USA | 2024-04-10 | TRUCK-004 | DRV-4103 | D001-R103-20240410 | 1 | CUS-5020 | 2000 Biscayne Blvd | Miami | FL | 33137 | 2024-04-10T10:00:00Z | 2024-04-10T09:58:00Z | 2024-04-10T10:10:00Z | 2024-04-10T10:11:00Z | blank | 10 | 10 | 0 | 25.7987 | -80.1914 | Large order, warehouse staff signed. |
| R103-20240410 | partial | 7.5 | true | USA | 2024-04-10 | TRUCK-004 | DRV-4103 | D002-R103-20240410 | 2 | CUS-5021 | 1550 Brickell Ave | Miami | FL | 33129 | 2024-04-10T10:45:00Z | 2024-04-10T10:59:00Z | 2024-04-10T10:55:00Z | 2024-04-10T11:10:00Z | blank | 12 | 10 | 45 | 25.7622 | -80.1948 | Partial delivery due to missing items. |
| R104-20240410 | delivered | 0 | false | Norway | 2024-04-10 | E-BIKE-007 | DRV-5101 | D001-R104-20240410 | 1 | CUS-6002 | Karl Johans gate 5 | Oslo | OS | 0154 | 2024-04-10T08:00:00Z | 2024-04-10T08:13:00Z | 2024-04-10T08:15:00Z | 2024-04-10T08:17:00Z | blank | 2 | 2 | 0 | 59.9139 | 10.7522 | blank |
| R104-20240410 | failed | 3.2 | false | Norway | 2024-04-10 | E-BIKE-007 | DRV-5101 | D002-R104-20240410 | 2 | CUS-6003 | Universitetsgata 16 | Oslo | OS | 0164 | 2024-04-10T08:45:00Z | 2024-04-10T08:50:00Z | 2024-04-10T08:55:00Z | 2024-04-10T08:58:00Z | Customer not present | 1 | 0 | 21 | 59.9165 | 10.7397 | Left notice for redelivery. |
| R105-20240410 | delivered | 0 | false | Canada | 2024-04-10 | VAN-003 | DRV-2203 | D001-R105-20240410 | 1 | CUS-7010 | 201 King St W | Toronto | ON | M5H 1K5 | 2024-04-10T09:00:00Z | 2024-04-10T09:12:00Z | 2024-04-10T09:15:00Z | 2024-04-10T09:19:00Z | blank | 1 | 1 | 0 | 43.6465 | -79.3853 | Delivered to concierge. |
| R105-20240410 | delivered | 3.7 | true | Canada | 2024-04-10 | VAN-003 | DRV-2203 | D002-R105-20240410 | 2 | CUS-7011 | 77 Bloor St W | Toronto | ON | M5S 1M2 | 2024-04-10T09:45:00Z | 2024-04-10T09:56:00Z | 2024-04-10T09:55:00Z | 2024-04-10T10:02:00Z | blank | 4 | 4 | 23 | 43.6688 | -79.3933 | blank |
| R106-20240410 | failed | 0 | false | Atlantis | 2024-04-10 | TRUCK-EDGE | DRV-ZERO | D001-R106-20240410 | 1 | CUS-EDGE | 0 Null Ave | Null Island | Equator | 0000 | 2024-04-10T00:00:00Z | blank | 2024-04-10T00:10:00Z | blank | Invalid address | 1 | 0 | 0 | 0 | 0 | Edge case: test for Null Island. |
| R107-20240410 | delivered | 0 | false | Australia | 2024-04-10 | VAN-010 | DRV-3107 | D001-R107-20240410 | 1 | CUS-8002 | 15 Collins St | Melbourne | VIC | 3000 | 2024-04-10T08:00:00Z | 2024-04-10T07:59:00Z | 2024-04-10T08:15:00Z | 2024-04-10T08:18:00Z | blank | 2 | 2 | 0 | -37.817 | 144.97 | blank |
| R108-20240410 | delivered | 0 | false | Brazil | 2024-04-10 | E-BIKE-015 | DRV-1108 | D001-R108-20240410 | 1 | CUS-9001 | Rua Augusta 2500 | São Paulo | SP | 01305-100 | 2024-04-10T09:20:00Z | 2024-04-10T09:35:00Z | 2024-04-10T09:30:00Z | 2024-04-10T09:40:00Z | blank | 3 | 3 | 0 | -23.5558 | -46.6522 | Delivered to security. |
| R109-20240411 | delivered | 0 | true | USA | 2024-04-11 | TRUCK-005 | DRV-1110 | D001-R109-20240411 | 1 | CUS-1102 | 350 Mission St | San Francisco | CA | 94105 | 2024-04-11T08:00:00Z | 2024-04-11T08:05:00Z | 2024-04-11T08:15:00Z | 2024-04-11T08:16:00Z | blank | 20 | 20 | 0 | 37.7898 | -122.3965 | Large delivery received by warehouse staff. |
| R109-20240411 | delivered | 8.7 | true | USA | 2024-04-11 | TRUCK-005 | DRV-1110 | D002-R109-20240411 | 2 | CUS-1103 | 500 Howard St | San Francisco | CA | 94105 | 2024-04-11T09:00:00Z | 2024-04-11T08:55:00Z | 2024-04-11T09:15:00Z | 2024-04-11T09:13:00Z | blank | 12 | 12 | 60 | 37.7886 | -122.3971 | blank |
| R110-20240411 | delivered | 0 | false | Ireland | 2024-04-11 | VAN-021 | DRV-3210 | D001-R110-20240411 | 1 | CUS-2011 | 25 North St | Dublin | Leinster | D01F5P2 | 2024-04-11T08:00:00Z | 2024-04-11T08:07:00Z | 2024-04-11T08:10:00Z | 2024-04-11T08:14:00Z | blank | 1 | 1 | 0 | 53.3498 | -6.2603 | blank |
| R111-20240411 | rescheduled | 0 | false | Greece | 2024-04-11 | VAN-050 | DRV-4111 | D001-R111-20240411 | 1 | CUS-9010 | 4 Vassilissis Sofias | Athens | Attica | 10674 | 2024-04-11T10:00:00Z | blank | 2024-04-11T10:10:00Z | blank | Severe weather | 2 | 0 | 0 | 37.9755 | 23.7364 | Delivery postponed due to heavy snow. |
| R112-20240411 | delivered | 0 | true | Ireland | 2024-04-11 | TRUCK-077 | DRV-2112 | D001-R112-20240411 | 1 | CUS-3701 | 1 Main St | Dublin | Leinster | D02X285 | 2024-04-11T07:30:00Z | 2024-04-11T07:33:00Z | 2024-04-11T07:40:00Z | 2024-04-11T07:45:00Z | blank | 5 | 5 | 0 | 53.3478 | -6.2597 | blank |
| R113-20240411 | delivered | 0 | false | Norway | 2024-04-11 | TRUCK-013 | DRV-1113 | D001-R113-20240411 | 1 | CUS-1113 | Storgata 15 | Oslo | OS | 0184 | 2024-04-11T10:00:00Z | 2024-04-11T10:07:00Z | 2024-04-11T10:10:00Z | 2024-04-11T10:15:00Z | blank | 3 | 3 | 0 | 59.9132 | 10.7522 | blank |
What the 202 rows show
from the 202-row sampleFailed (delivery status) stands out: mean distance_
- 35%signature_
captured = true - 0.0median distance_
traveled_ km - 49delivery address states
- 51delivery address cities
- 1median stop_
sequence - 2median package_
count
Median 0.0, from 0.0 to 10,000.
- string 13
- integer 3
- float 4
- date 1
- datetime 4
- boolean 1
Columns
26 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
route_id | string | Unique identifier for the delivery route on a given day.unique | R101-20240410 |
vehicle_id | string | Unique identifier for the delivery vehicle. | VAN-001 |
driver_id | string | Unique identifier for the driver assigned to the route. | DRV-2101 |
delivery_id | string | Unique identifier for each delivery stop within a route.unique | D001-R101-20240410 |
customer_id | string | Unique identifier for the customer or delivery recipient. | CUS-3001 |
delivery_address_street | string | Street address for the delivery location. | 100 Market St |
delivery_address_city | string | City for the delivery location. | San Francisco |
delivery_address_state | string | State or province for the delivery location. | CA |
delivery_address_postal_code | string | Postal or ZIP code for the delivery location. | 94105 |
delivery_address_country | string | Country for the delivery location. | USA |
delivery_status | string | Outcome of the delivery (e.g., delivered, failed, rescheduled, partial).delivered · failed · rescheduled · partial | delivered |
failure_reason | string | Reason for delivery failure, if applicable.optional | Customer not present |
notes | string | Additional notes or comments about the delivery stop.optional | Delivered to concierge. |
| Numbers 7 columns | |||
stop_sequence | integer | Order of the stop within the route (1 = first stop, etc.).1 or more | 1 |
package_count | integer | Number of packages to be delivered at the stop.1 or more | 3 |
delivered_package_count | integer | Number of packages successfully delivered at the stop.0 or more · optional | 3 |
distance_traveled_km | float | Distance traveled from the previous stop to this stop, in kilometers.0 or more · optional | 0 |
travel_time_minutes | float | Time taken to travel from the previous stop to this stop, in minutes.0 or more · optional | 0 |
stop_latitude | float | Latitude coordinate of the delivery stop.-90 to 90 | 37.7936 |
stop_longitude | float | Longitude coordinate of the delivery stop.-180 to 180 | -122.3965 |
| Dates and times 5 columns | |||
route_date | date | Date when the route was executed. | 2024-04-10 |
scheduled_arrival_time | datetime | Planned arrival time at the delivery stop. | 2024-04-10T09:30:00Z |
actual_arrival_time | datetime | Actual arrival time at the delivery stop.optional | 2024-04-10T09:32:00Z |
scheduled_departure_time | datetime | Planned departure time from the delivery stop.optional | 2024-04-10T09:40:00Z |
actual_departure_time | datetime | Actual departure time from the delivery stop.optional | 2024-04-10T09:42:00Z |
| True or false 1 column | |||
signature_captured | boolean | Indicates if a recipient signature was captured at delivery.optional | true |
Use it for
A logistics dashboard
The signature_
captured rate, distance_ traveled_ km by delivery_ status and a breakdown of delivery_ address_ country. Excel, Power BI or Tableau. Why do the 18 failed rows have a mean distance_
traveled_ km of 3,889? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Routes202R101-202404100deliveredR101-202404103.1deliveredR101-202404106.8partial
A software demo
Believable routes with route_
date, vehicle_ id and driver_ id to fill a screen in front of a buyer.
This dataset202 rows26 columns
Yours1,000 rows26 columnsdelivery_address_street: UK only
blueprint · last-mile-delivery-route-data
Behind this dataset
Same schema. As many rows as you need.
These 202 rows came out of a blueprint — 26 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
- Each delivery includes geocoded start and end points
- Failed deliveries include failure reason
- Time stamps required for all route points
- Routes with missing address info excluded
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
- last-mile-delivery-route-data