Last-Mile Delivery Delay Factors

This dataset provides granular details on last-mile parcel deliveries, including route assignments, vehicle and driver data, live traffic and weather conditions, and delay events with reasons and durations. It enables logistics companies to optimize delivery efficiency, analyze delay factors, and build predictive models for operational improvements.

  • opened 5 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Delivery route optimization and scheduling

Sample rows

preview · 8 of 200 rows · all 25 columns
parcel_idstringdelivery_statusstringroute_stops_countintegerdelay_reasonstringroute_idstringdelivery_vehicle_idstringdriver_idstringscheduled_delivery_datetimedatetimeactual_delivery_datetimedatetimedelay_event_idstringdelay_duration_minutesintegertraffic_conditionstringweather_conditionstringdelivery_address_streetstringdelivery_address_citystringdelivery_address_statestringdelivery_address_postal_codestringdelivery_address_countrystringroute_start_datetimedatetimeroute_end_datetimedatetimeroute_distance_kmfloatparcel_weight_kgfloatparcel_dimensions_cmstringrecipient_namestringrecipient_contact_numberstring
P1001delivered12blankR-9001VH2101DR50012023-09-20T10:45:002023-09-20T11:05:00blankblanknormalclear1701 Broadway AveNew YorkNY10019USA2023-09-20T09:50:002023-09-20T11:20:0014.27.450x40x30Jessica Lamont+1-917-555-0321
P1002delayed14trafficR-9002EV1021DR50022023-09-21T14:20:002023-09-21T15:10:00DE700150heavyrain12 Queen Victoria StLondonGreater LondonEC4N 4TQUK2023-09-21T13:35:002023-09-21T15:30:0022.94.638x22x19Oliver White+44 20 7946 0022
P1003delivered8blankR-9003VH2102DR50032023-09-21T08:35:002023-09-21T08:38:00blankblanknormalclear2 rue de la PaixParisÎle-de-France75002France2023-09-21T08:00:002023-09-21T09:00:0010.82.223x18x12Elodie Martin+33 1 4502 8765
P1004in-transit10blankR-9004VH2103DR50042023-09-22T12:10:00blankblankblanknormalclear77 Yonge StTorontoONM5E 1J4Canada2023-09-22T11:40:00blank20.31.521x17x15Michelle Chen+1-416-555-0189
P1005failed15address_issueR-9005EV1022DR50052023-09-23T17:00:002023-09-23T17:33:00DE700260roadworkrain35 HauptstrasseBerlinBerlin10115Germany2023-09-23T16:15:002023-09-23T17:45:0029.63.730x27x22Felix Bauer+49 30 1234 5678
P1006delivered9blankR-9006VH2104DR50062023-09-24T07:30:002023-09-24T07:37:00blankblanknormalclear88 Market StSan FranciscoCA94105USA2023-09-24T07:05:002023-09-24T07:55:0011.72.924x27x18Samantha Ortiz+1-415-555-0402
P1007delayed13vehicle_breakdownR-9007VH2105DR50072023-09-25T16:40:002023-09-25T17:38:00DE700358accidentfog33 Orchard RoadSingaporeCentral238895Singapore2023-09-25T16:00:002023-09-25T17:55:0024.87.141x25x26Wei Ling Tan+65 6881 2345
P1008delivered8blankR-9008VH2106DR50082023-09-26T13:25:002023-09-26T13:33:00blankblanknormalclear101 Collins StMelbourneVIC3000Australia2023-09-26T13:00:002023-09-26T13:50:0013.65.832x21x18Amelia Taylor+61 3 5550 2001

What the 200 rows show

from the 200-row sample

In-transit (delivery status) stands out: mean route_stops_count is 5.1, against 10.6 for the rest.

  • 10median route_stops_count
  • 5traffic conditions
  • 5weather conditions
  • 11delivery address countries
  • 38delivery address states
  • 39delivery address cities
Mean route_stops_count by delivery_status200 rows
010209.3delivered111 rows12.9delayed54 rows5.1in-trans…23 rows12.0failed12 rows
route_stops_count200 rows, in bands of 2.5
03060711195960211544012.522.5route_stops_count →

Median 10, from 1 to 22.

delay_reason66 rows with a value · 134 left blank
  1. traffic15
  2. address_issue14
  3. vehicle_breakdown14
  4. weather12
  5. other11
25 columns by typefrom the column list below
  • string 17
  • integer 2
  • float 2
  • datetime 4

Columns

25 columns in three groups
blueprint · 25 columns
columntypedescriptionexample
Text 17 columns
parcel_idstringUnique identifier for each parcel being delivereduniqueP1001
route_idstringUnique identifier for the delivery route assigned to the parcelR-9001
delivery_vehicle_idstringIdentifier for the vehicle assigned to the delivery routeVH2101
driver_idstringIdentifier for the driver responsible for the deliveryDR5001
delivery_statusstringCurrent status of the delivery (e.g., delivered, delayed, in-transit, failed)delivered · delayed · in-transit · faileddelivered
delay_event_idstringIdentifier for the delay event, if any, associated with the deliveryoptionalDE7001
delay_reasonstringReason for delivery delay (e.g., traffic, weather, vehicle breakdown, address issue)5 values · optionaltraffic
traffic_conditionstringTraffic condition during delivery (e.g., normal, heavy, accident, roadwork)normal · heavy · accident · roadwork · unknown · optionalnormal
weather_conditionstringWeather condition during delivery (e.g., clear, rain, snow, fog)clear · rain · snow · fog · other · optionalclear
delivery_address_streetstringStreet address of the delivery destination1701 Broadway Ave
delivery_address_citystringCity of the delivery destinationNew York
delivery_address_statestringState or region of the delivery destinationNY
delivery_address_postal_codestringPostal code of the delivery destination10019
delivery_address_countrystringCountry of the delivery destination11 countriesUSA
parcel_dimensions_cmstringDimensions of the parcel in centimeters (LxWxH)50x40x30
recipient_namestringName of the parcel recipientJessica Lamont
recipient_contact_numberstringContact phone number of the recipientoptional+1-917-555-0321
Numbers 4 columns
delay_duration_minutesintegerDuration of the delay in minutes0 or more · optional50
route_distance_kmfloatTotal distance of the delivery route in kilometers0 or more14.2
route_stops_countintegerNumber of stops on the delivery route1 or more12
parcel_weight_kgfloatWeight of the parcel in kilograms0 or more7.4
Dates and times 4 columns
scheduled_delivery_datetimedatetimePlanned date and time for parcel delivery2023-09-20T10:45:00
actual_delivery_datetimedatetimeActual date and time when the parcel was deliveredoptional2023-09-20T11:05:00
route_start_datetimedatetimeStart date and time for the delivery route2023-09-20T09:50:00
route_end_datetimedatetimeEnd date and time for the delivery routeoptional2023-09-20T11:20:00

Use it for

  • median route s…10200 rowsmean route stops coun…9.3deli…12.9dela…5.1in-t…12.0fail…

    A logistics dashboard

    Route_stops_count by delivery_status and a breakdown of delay_reason. Excel, Power BI or Tableau.

  • Why do the 23 in-transit rows have a mean route_stops_count of 5.1?

    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 parcels with route_id, delivery_vehicle_id and driver_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

blueprint · last-mile-delivery-delay-factors

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 25 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
  • Link parcels to route and traffic data
  • Record estimated vs actual delivery times
  • Flag weather-impact events
  • Include real-time traffic congestion levels
  • Geo-coordinates anonymized
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-delay-factors

More in Logistics

Browse all
Also in LogisticsProduct Delivery Route OptimizationPharmaceutical Inventory Supply ChainsCold Chain Logistics Temperature LogsAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.