Last-mile Delivery Route Records

This dataset provides detailed, stepwise records of last-mile delivery routes, including stop sequences, geolocations, actual and planned travel times, and delivery outcomes for each stop. It is ideal for route optimization, delivery performance analysis, and geospatial research in logistics and supply chain operations.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Optimizing delivery routes for efficiency and cost savings

Sample rows

preview · 8 of 202 rows · all 23 columns
route_idstringdelivery_statusstringstop_sequenceintegerrecipient_signature_capturedbooleanstop_address_citystringroute_datedatevehicle_idstringdriver_idstringstop_idstringstop_latitudefloatstop_longitudefloatstop_address_streetstringstop_address_statestringstop_address_postal_codestringstop_address_countrystringplanned_arrival_timedatetimeactual_arrival_timedatetimeplanned_departure_timedatetimeactual_departure_timedatetimeactual_travel_time_minutesfloatdelivery_notesstringpackage_countintegerrecipient_namestring
R20240601Adelivered1trueNew York2024-06-01V1001D2001S0000140.7128-74.006123 BroadwayNY10007USA2024-06-01T08:00:002024-06-01T08:02:002024-06-01T08:10:002024-06-01T08:12:000blank4Lisa Grant
R20240601Adelivered2trueNew York2024-06-01V1001D2001S0000240.758-73.9855200 W 47th StNY10036USA2024-06-01T08:25:002024-06-01T08:28:002024-06-01T08:35:002024-06-01T08:37:0016blank3Katrina Wong
R20240601Adelivered3trueNew York2024-06-01V1001D2001S0000340.7306-73.986640 Washington Sq SNY10012USA2024-06-01T08:55:002024-06-01T08:58:002024-06-01T09:10:002024-06-01T09:11:0021blank2Manuel Alvarez
R20240601Apartial4trueBrooklyn2024-06-01V1001D2001S0000440.7061-73.99691 Brooklyn Bridge BlvdNY11201USA2024-06-01T09:30:002024-06-01T09:41:002024-06-01T09:43:002024-06-01T09:46:0030One package missing, left note.1Robert Lin
R20240601Afailed5falseBrooklyn2024-06-01V1001D2001S0000540.6782-73.944255 Flatbush AveNY11217USA2024-06-01T10:05:002024-06-01T10:25:002024-06-01T10:15:002024-06-01T10:27:0039No one at home, could not deliver.0blank
R20240601Bdelivered1trueLos Angeles2024-06-01V1002D2002S0000634.0522-118.2437400 S Hope StCA90071USA2024-06-01T08:00:002024-06-01T08:03:002024-06-01T08:12:002024-06-01T08:13:000blank5Rosa Martinez
R20240601Bdelivered2trueLos Angeles2024-06-01V1002D2002S0000734.0407-118.2468300 W 5th StCA90013USA2024-06-01T08:20:002024-06-01T08:22:002024-06-01T08:32:002024-06-01T08:33:0010blank2Tina Lee
R20240601Bdelivered3trueLos Angeles2024-06-01V1002D2002S0000833.9416-118.40851 World WayCA90045USA2024-06-01T08:50:002024-06-01T08:58:002024-06-01T09:10:002024-06-01T09:13:0025blank4Arjun Rao

What the 202 rows show

from the 202-row sample

Delivered (delivery status) stands out: 138 of its 140 rows have recipient_signature_captured = true, against 32 of 62 for the rest.

  • 84%recipient_signature_captured = true
  • 3median stop_sequence
  • 14stop address countries
  • 18stop address states
  • 42drivers
  • 43vehicles
Recipient signature captured rate by delivery_statusrecipient_signature_captured = true
0%50%100%99%delivered138 of 1400%failed0 of 10100%partial32 of 320%skipped0 of 20

Delivered (delivery status)'s mean stop_sequence is 2.4, against 3.3 for failed, 4.0 for partial and 3.8 for skipped.

stop_sequence202 rows, in bands of 0.5
025504804404303631135stop_sequence →

Median 3, from 1 to 5.

stop_address_city193 rows with a value · 9 left blank
  1. Tokyo24
  2. Paris22
  3. London18
  4. Sydney18
  5. Berlin18
  6. New York16
  7. Rome13
  8. Chicago10
  9. Los Angeles9
  10. San Francisco6
23 columns by typefrom the column list below
  • string 12
  • integer 2
  • float 3
  • date 1
  • datetime 4
  • boolean 1

Columns

23 columns in four groups
blueprint · 23 columns
columntypedescriptionexample
Text 12 columns
route_idstringUnique identifier for the delivery route on a given dayR20240601A
vehicle_idstringIdentifier for the delivery vehicle assigned to the routeoptionalV1001
driver_idstringIdentifier for the driver assigned to the routeoptionalD2001
stop_idstringUnique identifier for the delivery stopS00001
stop_address_streetstringStreet address of the delivery stopoptional123 Broadway
stop_address_citystringCity of the delivery stopoptionalNew York
stop_address_statestringState or province of the delivery stopoptionalNY
stop_address_postal_codestringPostal or ZIP code of the delivery stopoptional10007
stop_address_countrystringCountry of the delivery stopoptionalUSA
delivery_statusstringStatus of the delivery at this stopdelivered · failed · partial · skippeddelivered
delivery_notesstringAdditional notes or comments regarding the delivery at this stopoptionalAddress not found.
recipient_namestringName of the recipient at the delivery stopoptionalLisa Grant
Numbers 5 columns
stop_sequenceintegerOrder of the stop within the route (1 for first stop, 2 for second, etc.)1 or more1
stop_latitudefloatLatitude coordinate of the delivery stop-90 to 9040.7128
stop_longitudefloatLongitude coordinate of the delivery stop-180 to 180-74.006
actual_travel_time_minutesfloatActual travel time in minutes from the previous stop to this stop0 or more · optional0
package_countintegerNumber of packages delivered at this stop0 or more · optional4
Dates and times 5 columns
route_datedateDate when the delivery route was executed2024-06-01
planned_arrival_timedatetimeScheduled arrival time at the stopoptional2024-06-01T08:00:00
actual_arrival_timedatetimeActual arrival time at the stopoptional2024-06-01T08:02:00
planned_departure_timedatetimeScheduled departure time from the stopoptional2024-06-01T08:10:00
actual_departure_timedatetimeActual departure time from the stopoptional2024-06-01T08:12:00
True or false 1 column
recipient_signature_capturedbooleanIndicates if a recipient signature was captured at this stopoptionaltrue

Use it for

  • recipient sign…84%170 of 202 rowsmean stop sequence by…2.4deli…3.3fail…4.0part…3.8skip…

    A logistics dashboard

    The recipient_signature_captured rate, stop_sequence by delivery_status and a breakdown of stop_address_city. Excel, Power BI or Tableau.

  • Why do 170 of 202 rows have recipient_signature_captured = true?

    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 route_date, vehicle_id and driver_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 23 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 dataset202 rows23 columns
Yours1,000 rows23 columnsstop_address_street: UK only

blueprint · last-mile-delivery-route-records

Behind this dataset

Same schema. As many rows as you need.

These 202 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.

Rules it was built with
  • Route ID, driver ID, delivery sequence included
  • Timestamp per stop
  • Delivery success/failure flag
  • No customer or address data
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
last-mile-delivery-route-records

More in Logistics

Browse all
Also in LogisticsLast-Mile Delivery ETA PredictionsSupply Chain Disruption EventsLogistics Shipment Delay PredictionAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.