Urban Delivery Efficiency Benchmark Dataset
This dataset provides granular, event-level data on urban last-mile deliveries, including route efficiency, vehicle utilization, delivery timeliness, and environmental impact metrics such as CO2 emissions and energy consumption. It enables logistics managers to benchmark and optimize ESG performance across fleets and urban zones, supporting data-driven decisions for sustainable and cost-effective urban logistics.
Sample rows
preview · 8 of 120 rows · all 25 columns| delivery_idstring | vehicle_typestring | vehicle_capacity_kgfloat | on_time_deliveryboolean | zone_namestring | route_idstring | vehicle_idstring | driver_idstring | zone_idstring | delivery_datedate | scheduled_delivery_timedatetime | actual_delivery_timedatetime | delivery_statusstring | number_of_stopsinteger | total_distance_kmfloat | total_time_minutesfloat | vehicle_fuel_typestring | utilization_ratefloat | co2_emissions_kgfloat | energy_consumed_kwhfloat | fuel_consumed_litersfloat | number_of_packagesinteger | average_stop_time_minutesfloat | esg_scorefloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DLY0001 | electric van | 1200 | true | Downtown | RTE101 | VEH-0001 | DRV001 | ZN01 | 2024-06-01 | 2024-06-01T10:15:00 | 2024-06-01T10:10:00 | completed | 8 | 7.2 | 32.5 | electric | 84.3 | 0.2 | 7.1 | blank | 19 | 4.1 | 97.2 | Smooth delivery run, no issues encountered. |
| DLY0002 | van | 1000 | false | Financial District | RTE102 | VEH-0002 | DRV002 | ZN02 | 2024-06-01 | 2024-06-01T11:00:00 | 2024-06-01T11:25:00 | delayed | 10 | 8.8 | 40 | diesel | 98.1 | 12.5 | blank | 6.2 | 28 | 4.5 | 54.7 | Traffic congestion delayed arrival. |
| DLY0003 | cargo bike | 60 | false | Midtown | RTE103 | VEH-0003 | DRV003 | ZN03 | 2024-06-01 | 2024-06-01T09:30:00 | 2024-06-01T09:32:00 | completed | 6 | 5.1 | 29.8 | other | 57 | 0 | blank | blank | 12 | 4.9 | 96.4 | Slight delay due to loading at last stop. |
| DLY0004 | truck | 4100 | true | Industrial Park | RTE104 | VEH-0004 | DRV004 | ZN04 | 2024-06-01 | 2024-06-01T08:45:00 | 2024-06-01T08:45:00 | completed | 3 | 12.3 | 16.2 | diesel | 63.2 | 22.8 | blank | 7.5 | 44 | 5.8 | 48.2 | Bulk delivery, all packages accepted. |
| DLY0005 | bike | 30 | true | University District | RTE105 | VEH-0005 | blank | ZN05 | 2024-06-01 | 2024-06-01T12:05:00 | 2024-06-01T12:00:00 | completed | 7 | 3.8 | 22 | other | 70 | 0 | blank | blank | 9 | 3.1 | 99 | Short route, delivered ahead of schedule. |
| DLY0006 | truck | 3900 | false | Airport Area | RTE106 | VEH-0006 | DRV005 | ZN06 | 2024-06-02 | 2024-06-02T13:30:00 | 2024-06-02T13:33:00 | delayed | 2 | 18.2 | 41.5 | diesel | 93.4 | 26.2 | blank | 7.7 | 52 | 7 | 41.5 | Security check caused delay. |
| DLY0007 | electric van | 1100 | true | Waterfront | RTE107 | VEH-0007 | DRV006 | ZN07 | 2024-06-02 | 2024-06-02T10:00:00 | 2024-06-02T10:00:00 | completed | 9 | 6.4 | 28.4 | electric | 77.2 | 0.1 | 6.3 | blank | 15 | 3.2 | 94.3 | Delivered promptly, positive feedback from recipients. |
| DLY0008 | van | 950 | false | Financial District | RTE108 | VEH-0008 | blank | ZN02 | 2024-06-02 | 2024-06-02T15:20:00 | 2024-06-02T15:34:00 | delayed | 12 | 9.1 | 44.2 | petrol | 89.6 | 15.1 | blank | 5.9 | 27 | 4.2 | 60.9 | Late due to roadwork detours. |
| DLY0009 | van | 1050 | true | Harbor | RTE109 | VEH-0009 | DRV007 | ZN08 | 2024-06-02 | 2024-06-02T08:30:00 | 2024-06-02T08:28:00 | completed | 5 | 13.5 | 22.8 | hybrid | 61.5 | 3.2 | blank | 3.1 | 23 | 4.6 | 81.2 | Efficient hybrid route; all stops on time. |
| DLY0010 | van | 1300 | false | Medical Campus | RTE110 | VEH-0010 | DRV008 | ZN09 | 2024-06-03 | 2024-06-03T14:10:00 | 2024-06-03T14:11:00 | completed | 4 | 11.6 | 18.9 | hybrid | 74.7 | 2.6 | blank | 2.6 | 16 | 4.7 | 73.5 | Minor delay at medical supplies dock. |
| DLY0011 | other | 500 | true | Suburbs | RTE111 | VEH-0011 | DRV009 | ZN10 | 2024-06-03 | 2024-06-03T08:05:00 | 2024-06-03T08:05:00 | completed | 2 | 4.2 | 7.1 | other | 48 | 0 | blank | blank | 2 | 3.5 | 91.3 | Quick run; urgent medication delivered. |
| DLY0012 | electric van | 1200 | true | Downtown | RTE112 | VEH-0012 | DRV010 | ZN01 | 2024-06-03 | 2024-06-03T12:50:00 | 2024-06-03T12:50:00 | completed | 8 | 6.6 | 24.2 | electric | 81.7 | 0.1 | 5.8 | blank | 18 | 3 | 98.6 | All stops on schedule, no delays. |
| DLY0013 | cargo bike | 70 | false | Midtown | RTE113 | VEH-0013 | DRV011 | ZN03 | 2024-06-03 | 2024-06-03T09:40:00 | 2024-06-03T09:44:00 | delayed | 12 | 7.1 | 38.6 | other | 95.9 | 0 | blank | blank | 18 | 6.1 | 92.7 | Heavy rain slowed stop times. |
| DLY0014 | bike | 35 | true | Tech Park | RTE114 | VEH-0014 | DRV012 | ZN11 | 2024-06-03 | 2024-06-03T13:06:00 | 2024-06-03T13:06:00 | completed | 6 | 5.6 | 26.7 | other | 62.5 | 0 | blank | blank | 10 | 4 | 100 | All packages delivered to campus offices. |
| DLY0015 | truck | 4100 | false | Harbor | RTE115 | VEH-0015 | DRV013 | ZN12 | 2024-06-04 | 2024-06-04T08:25:00 | 2024-06-04T08:28:00 | delayed | 2 | 16.3 | 35 | diesel | 94.3 | 25.2 | blank | 7.8 | 55 | 8.2 | 43.7 | Unscheduled dock inspection delayed delivery. |
| DLY0016 | electric van | 1200 | true | Waterfront | RTE116 | VEH-0016 | DRV014 | ZN13 | 2024-06-04 | 2024-06-04T09:50:00 | 2024-06-04T09:48:00 | completed | 9 | 7.9 | 30.3 | electric | 77 | 0.2 | 8.9 | blank | 15 | 3.4 | 95.1 | Efficient run; received positive feedback. |
| DLY0017 | other | 500 | true | Suburbs | RTE117 | VEH-0017 | blank | ZN14 | 2024-06-04 | 2024-06-04T11:11:00 | 2024-06-04T11:09:00 | completed | 3 | 3.7 | 11.6 | other | 52.5 | 0 | blank | blank | 2 | 3.2 | 90.7 | Short route; all packages received on time. |
| DLY0018 | bike | 40 | false | University District | RTE118 | VEH-0018 | DRV015 | ZN05 | 2024-06-04 | 2024-06-04T12:20:00 | 2024-06-04T12:30:00 | delayed | 10 | 4.5 | 28.2 | other | 99 | 0 | blank | blank | 16 | 5.1 | 93.6 | Late start caused minor delay. |
| DLY0019 | cargo bike | 65 | true | Tech Park | RTE119 | VEH-0019 | DRV016 | ZN15 | 2024-06-04 | 2024-06-04T14:00:00 | 2024-06-04T14:00:00 | completed | 5 | 5.7 | 18.6 | other | 54.3 | 0 | blank | blank | 7 | 3.6 | 98.1 | All packages delivered on schedule. |
| DLY0020 | truck | 3500 | false | Airport Area | RTE120 | VEH-0020 | DRV017 | ZN16 | 2024-06-05 | 2024-06-05T13:15:00 | 2024-06-05T13:18:00 | delayed | 1 | 13.8 | 22.8 | diesel | 99.7 | 19.8 | blank | 6.3 | 48 | 8.8 | 42.6 | Single urgent bulk package, delayed by customs. |
What the 120 rows show
from the 120-row sampleTruck (vehicle type) stands out: mean vehicle_
- 62%on_
time_ delivery = true - 1,005median vehicle_
capacity_ kg - 4delivery statuses
- 5vehicle fuel types
- 6median number_
of_ stops - 6.5median total_
distance_ km
Median 1,005, from 25 to 4,200.
- string 10
- integer 2
- float 9
- date 1
- datetime 2
- boolean 1
Columns
25 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
delivery_id | string | Unique identifier for each delivery eventunique | DLY0001 |
route_id | string | Unique identifier for the delivery route | RTE101 |
vehicle_id | string | Unique identifier for the delivery vehicle | VEH-0001 |
driver_id | string | Unique identifier for the driver assigned to the deliveryoptional | DRV001 |
zone_id | string | Unique identifier for the urban delivery zone | ZN01 |
zone_name | string | Descriptive name of the urban delivery zoneoptional | Downtown |
delivery_status | string | Status of the delivery (e.g., completed, delayed, failed, in-progress)completed · delayed · failed · in-progress | completed |
vehicle_type | string | Type of vehicle used for delivery (e.g., van, bike, electric van, cargo bike)6 values | electric van |
vehicle_fuel_type | string | Type of fuel used by the vehicle (e.g., diesel, petrol, electric, hybrid)diesel · petrol · electric · hybrid · other | electric |
notes | string | Additional notes or comments about the deliveryoptional | Campus route, no delays. |
| Numbers 11 columns | |||
number_of_stops | integer | Total number of stops on the route1 or more | 8 |
total_distance_km | float | Total distance covered during the delivery route in kilometers0 or more | 7.2 |
total_time_minutes | float | Total time taken for the delivery route in minutes0 or more | 32.5 |
vehicle_capacity_kg | float | Maximum load capacity of the vehicle in kilograms0 or more · optional | 1200 |
utilization_rate | float | Percentage of vehicle capacity utilized during the delivery (0-100)0 to 100 · optional | 84.3 |
co2_emissions_kg | float | Estimated CO2 emissions for the delivery in kilograms0 or more · optional | 0.2 |
energy_consumed_kwh | float | Total energy consumed during the delivery in kilowatt-hours (for electric vehicles)0 or more · optional | 7.1 |
fuel_consumed_liters | float | Total fuel consumed during the delivery in liters (for combustion vehicles)0 or more · optional | 6.2 |
number_of_packages | integer | Total number of packages delivered on this route0 or more · optional | 19 |
average_stop_time_minutes | float | Average time spent per stop in minutes0 or more · optional | 4.1 |
esg_score | float | Composite ESG (Environmental, Social, Governance) score for the delivery (0-100)0 to 100 · optional | 97.2 |
| Dates and times 3 columns | |||
delivery_date | date | Date of the delivery event | 2024-06-01 |
scheduled_delivery_time | datetime | Scheduled date and time for delivery arrival | 2024-06-01T10:15:00 |
actual_delivery_time | datetime | Actual date and time of delivery arrival | 2024-06-01T10:10:00 |
| True or false 1 column | |||
on_time_delivery | boolean | Indicates if the delivery was completed on or before the scheduled time | true |
Use it for
A logistics dashboard
The on_
time_ delivery rate, vehicle_ capacity_ kg by vehicle_ type and a breakdown of zone_ name. Excel, Power BI or Tableau. Why do the 19 truck rows have a mean vehicle_
capacity_ kg of 3,987? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Deliveries120DLY00011200electric…DLY00021000vanDLY00044100truck
A software demo
Believable deliveries with route_
id, vehicle_ id and driver_ id to fill a screen in front of a buyer.
This dataset120 rows25 columns
Yours1,000 rows25 columns
blueprint · urban-delivery-efficiency-benchmark-dataset
Behind this dataset
Same schema. As many rows as you need.
These 120 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
- Each row represents a unique delivery route on a single day.
- Include route start/end times, total distance, delivery stops, and vehicle type.
- Capture fuel/energy consumption per route and associated CO2 emissions estimate.
- Benchmark against zone-specific traffic and environmental impact targets.
- Indicate if route used low-emission or IoT-enabled vehicles.
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
- urban-delivery-efficiency-benchmark-dataset