Logistics Last-Mile Delivery Times

This dataset provides granular records of last-mile delivery times across regions and carriers, including delivery addresses, package details, and status indicators. It enables logistics providers to analyze performance, identify bottlenecks, and optimize end-to-end supply chain operations. The data supports benchmarking, predictive analytics, and targeted improvements in delivery efficiency.

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

Carrier and regional delivery time benchmarking

Sample rows

preview · 8 of 200 rows · all 17 columns
delivery_idstringdelivery_statusstringdelivery_duration_minutesfloatrecipient_signature_collectedbooleandelivery_delay_reasonstringcarrier_namestringregion_namestringdelivery_datedatedelivery_start_timedatetimedelivery_end_timedatetimedelivery_address_streetstringdelivery_address_citystringdelivery_address_statestringdelivery_address_postal_codestringdelivery_address_countrystringpackage_weight_kgfloatpackage_volume_m3float
NYC_EXP_001completed35trueblankSwiftExpressNew York City2024-04-102024-04-10T08:10:002024-04-10T08:45:00245 Madison AveNew YorkNY10016USA2.40.018
LDN_JET_002completed30trueblankParcelJetLondon Central2024-04-112024-04-11T09:30:002024-04-11T10:00:0015 PiccadillyLondonEnglandW1J 0DGUK3.10.025
SF_GO_003completed27trueblankGoLogisticsSan Francisco Bay2024-04-122024-04-12T11:25:002024-04-12T11:52:00500 Market StSan FranciscoCA94105USA2.90.021
BER_CARGO_004completed40trueblankBlueCargoBerlin Mitte2024-04-132024-04-13T10:50:002024-04-13T11:30:0012 FriedrichstrasseBerlinBE10117DE1.80.015
TYO_EXP_005completed55trueblankSwiftExpressTokyo Shibuya2024-04-132024-04-13T14:05:002024-04-13T15:00:003-15 DogenzakaTokyo13150-0043JP4.20.032
SYD_JET_006completed28trueblankParcelJetSydney CBD2024-04-142024-04-14T09:45:002024-04-14T10:13:00101 George StSydneyNSW2000AU3.70.023
MUM_GO_007completed35trueblankGoLogisticsMumbai South2024-04-142024-04-14T08:30:002024-04-14T09:05:0092 Marine DriveMumbaiMH400002IN2.50.016
PAR_CARGO_008completed46trueblankBlueCargoParis 8e2024-04-152024-04-15T10:10:002024-04-15T10:56:0041 Rue La BoétieParisIDF75008FR1.60.014

What the 200 rows show

from the 200-row sample

Delayed (delivery status) stands out: mean delivery_duration_minutes is 59.8, against 33.0 for the rest.

  • 69%recipient_signature_collected = true
  • 35median delivery_duration_minutes
  • 4carrier names
  • 47delivery address countries
  • 2.4median package_weight_kg
  • 0.02median package_volume_m3
Mean delivery_duration_minutes by delivery_status200 rows
0408035.2comple…163 rows59.8delayed19 rows8.9failed7 rows29.8in_tra…4 rows9.1cancel…7 rows
delivery_duration_minutes200 rows, in bands of 20
060120241165142012080160delivery_duration_minutes →

Median 35, from 0 to 150.

delivery_delay_reason33 rows with a value · 167 left blank
  1. Recipient unavailable9
  2. Traffic congestion8
  3. Vehicle breakdown6
  4. Extreme weather conditions5
  5. Extreme weather5
17 columns by typefrom the column list below
  • string 10
  • float 3
  • date 1
  • datetime 2
  • boolean 1

Columns

17 columns in four groups
blueprint · 17 columns
columntypedescriptionexample
Text 10 columns
delivery_idstringUnique identifier for each last-mile delivery recorduniqueNYC_EXP_001
carrier_namestringName of the logistics carrier responsible for the delivery4 namesSwiftExpress
region_namestringName of the geographic region where the delivery occurredNew York City
delivery_statusstringStatus of the delivery (e.g., completed, delayed, failed)completed · delayed · failed · in_transit · cancelledcompleted
delivery_address_streetstringStreet address of the delivery destination245 Madison Ave
delivery_address_citystringCity of the delivery destinationNew York
delivery_address_statestringState or province of the delivery destinationNY
delivery_address_postal_codestringPostal code of the delivery destination10016
delivery_address_countrystringCountry of the delivery destinationUSA
delivery_delay_reasonstringReason for delivery delay, if applicable5 reasons · optionalTraffic congestion
Numbers 3 columns
delivery_duration_minutesfloatTotal time taken for the last-mile delivery in minutes0 or more35
package_weight_kgfloatWeight of the delivered package in kilograms0 or more · optional2.4
package_volume_m3floatVolume of the delivered package in cubic meters0 or more · optional0.018
Dates and times 3 columns
delivery_datedateDate when the delivery was completed2024-04-10
delivery_start_timedatetimeTimestamp when the last-mile delivery process started2024-04-10T08:10:00
delivery_end_timedatetimeTimestamp when the last-mile delivery process ended2024-04-10T08:45:00
True or false 1 column
recipient_signature_collectedbooleanIndicates if recipient signature was collected upon deliveryoptionaltrue

15 SQL practice questions for the Logistics Last-Mile Delivery Times

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Cancelled deliveries list

    Return delivery_id, carrier_name and region_name for every delivery whose delivery_status is 'cancelled'. Order the results by delivery_id ascending.

    Tables: logistics_last_mile_delivery_times · your result: 3 columns, 7 rows
  2. 02BeginnerFreeDISTINCT · IS NOT NULL · ORDER BY

    Distinct delay reasons

    Return the distinct non-null values of delivery_delay_reason, in a single column named delivery_delay_reason, sorted alphabetically.

    Tables: logistics_last_mile_delivery_times · your result: 1 columns, 5 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Deliveries per carrier

    Count the deliveries for each carrier. Return carrier_name and delivery_count, ordered by delivery_count descending and then by carrier_name ascending.

    Tables: logistics_last_mile_delivery_times · your result: 2 columns, 4 rows
  1. 04Average duration by statusBeginner
  2. 05Total weight by carrier visualPower BI
  3. 06Countries with repeated problemsIntermediate
  4. 07Weight bucketsIntermediate
  5. 08Carriers slower than overallIntermediate
  6. 09Monthly signature rateIntermediate
  7. 10Delay rate card by carrierPower BI
  8. 11Rank carriers within statusAdvanced
  9. 12Gap since previous deliveryAdvanced
  10. 13Running total by dateAdvanced
  11. 14Duration anomalies per carrierAdvanced
  12. 15Share of deliveries by statusPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • recipient sign…69%137 of 200 rowsmean delivery duratio…35.2comp…59.8dela…8.9fail…29.8in_t…

    A logistics dashboard

    The recipient_signature_collected rate, delivery_duration_minutes by delivery_status and a breakdown of delivery_delay_reason. Excel, Power BI or Tableau.

  • Why do the 19 delayed rows have a mean delivery_duration_minutes of 59.8?

    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 carrier_name, region_name and delivery_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 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 rows17 columns
Yours1,000 rows17 columnsregion_name: UK only

blueprint · logistics-last-mile-delivery-times

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 17 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
  • Track delivery times at zip code level
  • Segment by carrier and vehicle type
  • Flag late deliveries
  • Analyze time-of-day impact
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-last-mile-delivery-times

More in Logistics

Browse all
Also in LogisticsDelivery TrackingCold Chain Logistics Temperature DataCold Chain Pharmaceutical Temp LogsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.