Delivery Route Optimization

This dataset provides granular details on delivery routes, vehicle and driver assignments, individual delivery stops, package metrics, and customer feedback. It enables logistics companies to optimize routes, reduce operational costs, and improve delivery performance through actionable insights and analytics. The dataset is ideal for route optimization, fuel cost analysis, and enhancing customer satisfaction.

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

Optimizing delivery routes for reduced fuel consumption and travel time

Sample rows

preview · 8 of 60 rows · all 26 columns
route_idstringdelivery_statusstringcustomer_feedback_scorefloatdelivery_address_statestringvehicle_idstringdriver_idstringroute_datedateroute_start_timedatetimeroute_end_timedatetimetotal_distance_kmfloattotal_fuel_consumed_litersfloatfuel_cost_usdfloatdelivery_idstringcustomer_idstringdelivery_sequenceintegerdelivery_scheduled_timedatetimedelivery_actual_timedatetimecustomer_namestringcustomer_phonestringdelivery_address_streetstringdelivery_address_citystringdelivery_address_postal_codestringdelivery_address_countrystringpackage_weight_kgfloatpackage_volume_m3floatdelivery_notesstring
RTE20240601Acompleted5NYVH1001DRV2012024-06-012024-06-01T08:00:002024-06-01T14:30:0087.511.847.2DLV0001CUST500112024-06-01T08:40:002024-06-01T08:45:00Linda Martinez+1 212-555-0198205 West 57th StNew York10019USA12.30.08Customer requested contactless delivery
RTE20240601Adelayed3.5NYVH1001DRV2012024-06-012024-06-01T08:00:002024-06-01T14:30:0087.511.847.2DLV0002CUST500222024-06-01T09:10:002024-06-01T09:35:00Samuel Lee+1 646-555-432115 Orchard StNew York10002USA7.60.05Traffic delay
RTE20240601Acompleted4NYVH1001DRV2012024-06-012024-06-01T08:00:002024-06-01T14:30:0087.511.847.2DLV0003CUST500332024-06-01T10:00:002024-06-01T10:01:00Priya Singh+1 917-555-003378 5th AveNew York10011USA3.20.02blank
RTE20240601AfailedblankNYVH1001DRV2012024-06-012024-06-01T08:00:002024-06-01T14:30:0087.511.847.2DLV0004CUST500442024-06-01T11:00:002024-06-01T11:35:00Mike O'Brien+1 212-555-0191129 Madison AveNew York10016USA19.70.12Customer not at home
RTE20240601Acompleted4.8NYVH1001DRV2012024-06-012024-06-01T08:00:002024-06-01T14:30:0087.511.847.2DLV0005CUST500552024-06-01T12:15:002024-06-01T12:10:00Yara Ahmed+1 347-555-221244 BroadwayNew York10006USA5.50.04blank
RTE20240601Bcompleted4.5NYVH1002DRV2022024-06-012024-06-01T09:15:002024-06-01T13:50:0062.38.132.4DLV0006CUST500612024-06-01T09:50:002024-06-01T09:53:00Carlos Diaz+1 718-555-1100530 Atlantic AveBrooklyn11217USA8.20.07blank
RTE20240601Bcompleted5NYVH1002DRV2022024-06-012024-06-01T09:15:002024-06-01T13:50:0062.38.132.4DLV0007CUST500722024-06-01T10:45:002024-06-01T10:49:00Fiona McGregor+1 917-555-01003215 Church AveBrooklyn11226USA6.10.03blank
RTE20240601Bdelayed2.5NYVH1002DRV2022024-06-012024-06-01T09:15:002024-06-01T13:50:0062.38.132.4DLV0008CUST500832024-06-01T11:25:002024-06-01T11:45:00Wen Zhang+1 929-555-9981905 Flatbush AveBrooklyn11226USA2.90.01Heavy rain in area

What the 60 rows show

from the 60-row sample

Completed (delivery status) stands out: mean customer_feedback_score is 4.7, against 3.1 for the rest.

  • 4.5median customer_feedback_score
  • 18delivery address countries
  • 54.6median total_distance_km
  • 7.4median total_fuel_consumed_liters
  • 26.8median fuel_cost_usd
  • 1median delivery_sequence
Mean customer_feedback_score by delivery_status53 rows
0484.7completed39 rows1.4failed2 rows3.4delayed12 rows
customer_feedback_score53 rows, in bands of 0.5
015301112171129135customer_feedback_score →

Median 4.5, from 1.0 to 5.0.

delivery_address_state60 rows · top 10 of 27 values
  1. NY32
  2. CA3
  3. BE1
  4. Tokyo1
  5. Karnataka1
  6. Auvergne-Rhône-Alpes1
  7. CDMX1
  8. Malopolskie1
  9. England1
  10. Lombardy1
26 columns by typefrom the column list below
  • string 14
  • integer 1
  • float 6
  • date 1
  • datetime 4

Columns

26 columns in three groups
blueprint · 26 columns
columntypedescriptionexample
Text 14 columns
route_idstringUnique identifier for each delivery routeuniqueRTE20240601A
vehicle_idstringUnique identifier for the vehicle assigned to the routeVH1001
driver_idstringUnique identifier for the driver assigned to the routeDRV201
delivery_idstringUnique identifier for each delivery stop on the routeuniqueDLV0001
customer_idstringUnique identifier for the customer receiving the deliveryCUST5001
delivery_statusstringStatus of the delivery (e.g., pending, completed, failed, delayed)pending · completed · failed · delayedcompleted
customer_namestringName of the customer receiving the deliveryLinda Martinez
customer_phonestringContact phone number for the customeroptional+1 212-555-0198
delivery_address_streetstringStreet address for the delivery location205 West 57th St
delivery_address_citystringCity for the delivery locationNew York
delivery_address_statestringState or region for the delivery locationNY
delivery_address_postal_codestringPostal code for the delivery location10019
delivery_address_countrystringCountry for the delivery locationUSA
delivery_notesstringAdditional notes or comments about the deliveryoptionalTraffic delay
Numbers 7 columns
total_distance_kmfloatTotal distance covered in kilometers for the route0 or more87.5
total_fuel_consumed_litersfloatTotal fuel consumed in liters for the route0 or more · optional11.8
fuel_cost_usdfloatTotal fuel cost in USD for the route0 or more · optional47.2
delivery_sequenceintegerOrder of the delivery stop in the route1 or more1
package_weight_kgfloatWeight of the package delivered at this stop (in kilograms)0 or more · optional12.3
package_volume_m3floatVolume of the package delivered at this stop (in cubic meters)0 or more · optional0.08
customer_feedback_scorefloatCustomer feedback score for the delivery (1-5 scale)1 to 5 · optional5
Dates and times 5 columns
route_datedateDate the delivery route is scheduled or executed2024-06-01
route_start_timedatetimePlanned start time for the delivery route2024-06-01T08:00:00
route_end_timedatetimePlanned or actual end time for the delivery routeoptional2024-06-01T14:30:00
delivery_scheduled_timedatetimeScheduled time for the delivery at this stop2024-06-01T08:40:00
delivery_actual_timedatetimeActual time when the delivery was madeoptional2024-06-01T08:45:00

Use it for

  • median custome…4.553 rowsmean customer feedbac…4.7comple…1.4failed3.4delayed

    A logistics dashboard

    Customer_feedback_score by delivery_status and a breakdown of delivery_address_state. Excel, Power BI or Tableau.

  • Why do the 39 completed rows have a mean customer_feedback_score of 4.7?

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

Not quite right?

Make it yours.

Same 26 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 dataset60 rows26 columns
Yours1,000 rows26 columnsdelivery_address_street: UK only

blueprint · delivery-route-optimization

Behind this dataset

Same schema. As many rows as you need.

These 60 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
  • Routes exceeding 8 hours flagged for review
  • Deliveries must be within promised time window
  • Drivers record mileage per route
  • Packages over 25kg require two staff
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
delivery-route-optimization

More in Logistics

Browse all
Also in LogisticsUrban Last-Mile Emissions TrackerSupply Chain Inventory MovementsLogistics Last-Mile Delivery TimesAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.