Last-Mile Delivery ETA Predictions

This dataset provides detailed records of last-mile delivery events, including scheduled, predicted, and actual delivery times, route and traffic information, and customer availability windows. It is designed to support analysis and optimization of ETA predictions, enabling improved delivery accuracy and operational efficiency for logistics providers. The dataset is ideal for building predictive models, evaluating delivery performance, and identifying factors affecting last-mile delivery outcomes.

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

Developing and benchmarking ETA prediction models for last-mile delivery

Sample rows

preview · 8 of 200 rows · all 24 columns
delivery_idstringdelivery_statusstringdelivery_delay_minutesfloatdelivery_address_countrystringorder_idstringcustomer_idstringroute_idstringvehicle_idstringdriver_idstringscheduled_delivery_datetimedatetimepredicted_eta_datetimedatetimeactual_delivery_datetimedatetimepickup_datetimedatetimedelivery_address_streetstringdelivery_address_citystringdelivery_address_statestringdelivery_address_postal_codestringroute_distance_kmfloatroute_duration_minutesfloattraffic_conditionstringweather_conditionstringcustomer_availability_startdatetimecustomer_availability_enddatetimedelivery_notesstring
DEL00001delivered-3USORD10001CUST9001RTE-1001VEH-1A2BDRV-20012023-06-01T10:00:00Z2023-06-01T10:35:00Z2023-06-01T10:32:00Z2023-06-01T09:45:00Z1482 Willow AveChicagoIL6061113.230moderateclear2023-06-01T10:00:00Z2023-06-01T12:00:00Zblank
DEL00002delayed14USORD10002CUST9002RTE-1002VEH-2B3CDRV-20022023-06-01T14:00:00Z2023-06-01T14:45:00Z2023-06-01T14:59:00Z2023-06-01T13:45:00Z4010 Market StPhiladelphiaPA1910417.640heavyrain2023-06-01T14:30:00Z2023-06-01T16:30:00ZHeavy traffic due to road construction.
DEL00003delivered0USORD10003CUST9003RTE-1003VEH-3C4DDRV-20032023-06-01T11:30:00Z2023-06-01T12:05:00Z2023-06-01T12:05:00Z2023-06-01T11:10:00Z760 Lake RdClevelandOH441029.722lightclear2023-06-01T12:00:00Z2023-06-01T14:00:00Zblank
DEL00004delayed27USORD10004CUST9004RTE-1004VEH-4D5EDRV-20042023-06-01T08:00:00Z2023-06-01T08:40:00Z2023-06-01T09:07:00Z2023-06-01T07:40:00Z25 Broad StNew YorkNY1000520.138severefog2023-06-01T09:00:00Z2023-06-01T11:00:00ZDense fog caused delivery delay.
DEL00005delivered-7USORD10005CUST9005RTE-1005VEH-5E6FDRV-20052023-06-01T19:00:00Z2023-06-01T19:20:00Z2023-06-01T19:13:00Z2023-06-01T18:55:00Z12 Main StDallasTX752016.918lightclear2023-06-01T19:00:00Z2023-06-01T21:00:00Zblank
DEL00006delivered15USORD10006CUST9006RTE-1006VEH-6F7GDRV-20062023-06-02T08:00:00Z2023-06-02T08:55:00Z2023-06-02T09:10:00Z2023-06-02T07:45:00Z82 Oakwood DrAtlantaGA3030315.440moderaterain2023-06-02T08:30:00Z2023-06-02T10:30:00ZMinor rain and moderate traffic caused slight delay.
DEL00007delivered-3UKORD10007CUST9007RTE-1007VEH-7G8HDRV-20072023-06-02T15:00:00Z2023-06-02T15:50:00Z2023-06-02T15:47:00Z2023-06-02T14:40:00Z934 Maple CrescentLondonENGW1U 1AA1335moderateclearblankblankblank
DEL00008delayed83UKORD10008CUST9008RTE-1008VEH-8H9JDRV-20082023-06-02T17:30:00Z2023-06-02T18:35:00Z2023-06-02T19:58:00Z2023-06-02T17:15:00Z5 Abbey RdLondonENGNW8 9AY22.450heavystorm2023-06-02T18:00:00Z2023-06-02T20:00:00ZSevere storm and heavy traffic delayed delivery.

What the 200 rows show

from the 200-row sample

Delivered (delivery status) stands out: mean delivery_delay_minutes is 0.12, against 33.4 for the rest.

  • 3.5median delivery_delay_minutes
  • 4traffic conditions
  • 5weather conditions
  • 12.5median route_distance_km
  • 30median route_duration_minutes
Mean delivery_delay_minutes by delivery_status158 rows
040800.12delivered101 rows28.7delayed47 rows55.5failed10 rows
delivery_delay_minutes158 rows, in bands of 20
04080537117103211-2060140delivery_delay_minutes →

Median 3.5, from -15 to 125.

delivery_address_country200 rows · top 10 of 17 values
  1. US100
  2. Canada18
  3. Australia18
  4. UK16
  5. Testland14
  6. New Zealand8
  7. NZ7
  8. Germany4
  9. France3
  10. Ireland3
24 columns by typefrom the column list below
  • string 15
  • float 3
  • datetime 6

Columns

24 columns in three groups
blueprint · 24 columns
columntypedescriptionexample
Text 15 columns
delivery_idstringUnique identifier for each delivery instanceuniqueDEL00001
order_idstringUnique identifier for the customer order associated with the deliveryORD10001
customer_idstringUnique identifier for the customer receiving the deliveryCUST9001
route_idstringUnique identifier for the planned delivery routeRTE-1001
vehicle_idstringUnique identifier for the delivery vehicleoptionalVEH-1A2B
driver_idstringUnique identifier for the delivery driveroptionalDRV-2001
delivery_statusstringCurrent status of the delivery (e.g., scheduled, in_transit, delivered, delayed, failed)scheduled · in_transit · delivered · delayed · faileddelivered
delivery_address_streetstringStreet address for the delivery destination1482 Willow Ave
delivery_address_citystringCity for the delivery destinationChicago
delivery_address_statestringState or region for the delivery destinationIL
delivery_address_postal_codestringPostal or ZIP code for the delivery destination60611
delivery_address_countrystringCountry for the delivery destinationUS
traffic_conditionstringTraffic condition at the time of delivery (e.g., light, moderate, heavy, severe)light · moderate · heavy · severemoderate
weather_conditionstringWeather condition during delivery (e.g., clear, rain, snow, fog, storm)clear · rain · snow · fog · storm · optionalclear
delivery_notesstringAdditional notes or comments about the delivery (e.g., reasons for delay, customer instructions)optionalTest delivery scheduled.
Numbers 3 columns
route_distance_kmfloatTotal planned route distance in kilometers0 or more13.2
route_duration_minutesfloatPlanned route duration in minutes under normal conditions0 or more30
delivery_delay_minutesfloatDifference in minutes between actual and predicted delivery time (positive if late, negative if early)optional-3
Dates and times 6 columns
scheduled_delivery_datetimedatetimeThe originally scheduled date and time for the delivery2023-06-01T10:00:00Z
predicted_eta_datetimedatetimePredicted estimated time of arrival for the delivery based on route and traffic data2023-06-01T10:35:00Z
actual_delivery_datetimedatetimeActual date and time when the delivery was completedoptional2023-06-01T10:32:00Z
pickup_datetimedatetimeDate and time when the package was picked up for deliveryoptional2023-06-01T09:45:00Z
customer_availability_startdatetimeStart of the time window when the customer is available to receive the deliveryoptional2023-06-01T10:00:00Z
customer_availability_enddatetimeEnd of the time window when the customer is available to receive the deliveryoptional2023-06-01T12:00:00Z

Use it for

  • median deliver…3.5158 rowsmean delivery delay m…0.12delive…28.7delayed55.5failed

    A logistics dashboard

    Delivery_delay_minutes by delivery_status and a breakdown of delivery_address_country. Excel, Power BI or Tableau.

  • Why do the 101 delivered rows have a mean delivery_delay_minutes of 0.12?

    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 deliveries with order_id, customer_id and route_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 24 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 rows24 columns
Yours1,000 rows24 columnsdelivery_address_street: UK only

blueprint · last-mile-delivery-eta-predictions

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
  • Each row is an ETA estimate with ground truth.
  • Route, weather, and vehicle info included.
  • Delivery window and lateness flag attached.
  • Customer feedback on timeliness logged.
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
last-mile-delivery-eta-predictions

More in Logistics

Browse all
Also in LogisticsLast-Mile Delivery Delay FactorsSupply Chain Delivery Delay LogsSupply Chain Disruption EventsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.