Last-Mile Delivery Emissions Benchmark
This dataset provides detailed, route-level records of last-mile delivery CO2 emissions, including vehicle and fuel types, provider information, and delivery metrics. It is designed for logistics providers and e-commerce companies to benchmark emissions, identify hotspots, and support ESG and sustainability reporting. The data enables actionable insights for optimizing supply chain operations and reducing carbon footprints.
Sample rows
preview · 8 of 60 rows · all 25 columns| delivery_idstring | vehicle_fuel_typestring | co2_emissions_per_package_kgfloat | origin_countrystring | route_idstring | route_namestring | vehicle_idstring | vehicle_typestring | delivery_datedate | distance_kmfloat | number_of_stopsinteger | total_packages_deliveredinteger | co2_emissions_kgfloat | origin_street_addressstring | origin_citystring | origin_statestring | origin_postal_codestring | destination_street_addressstring | destination_citystring | destination_statestring | destination_postal_codestring | destination_countrystring | provider_namestring | emission_calculation_methodstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DEL-20240601-001 | diesel | 0.325 | USA | R-1001 | Downtown North Loop | VAN-001 | van | 2024-06-01 | 13.7 | 8 | 32 | 10.4 | 1512 Central Depot Ave | Chicago | IL | 60622 | 3421 N Ashland Ave | Chicago | IL | 60657 | USA | SwiftLogistics | GLEC | Traffic delays added 8 minutes to route. |
| DEL-20240601-002 | electric | 0.016 | USA | R-1002 | Eastside Express | EBIKE-003 | bike | 2024-06-01 | 7.2 | 5 | 12 | 0.19 | 201 E Lake St | Chicago | IL | 60601 | 1200 S Michigan Ave | Chicago | IL | 60605 | USA | GreenWheels | DEFRA | Zero-emission bike route. |
| DEL-20240601-003 | gasoline | 0.332 | USA | R-1003 | West Hills | VAN-002 | van | 2024-06-02 | 18.3 | 14 | 38 | 12.6 | 890 Depot Dr | San Francisco | CA | 94107 | 1201 Twin Peaks Blvd | San Francisco | CA | 94114 | USA | SwiftLogistics | GLEC | blank |
| DEL-20240601-004 | diesel | 0.705 | USA | R-1004 | Riverfront | TRUCK-003 | truck | 2024-06-02 | 22.1 | 9 | 41 | 28.9 | 400 Wharf St | Memphis | TN | 38103 | 1100 Riverside Dr | Memphis | TN | 38106 | USA | DeltaFreight | DEFRA | Heavy cargo load. |
| DEL-20240601-005 | electric | 0.075 | USA | R-1005 | Suburban Sweep | EVAN-001 | electric van | 2024-06-03 | 16.2 | 10 | 28 | 2.1 | 55 Edison Rd | Evanston | IL | 60201 | 1900 Ridge Ave | Evanston | IL | 60201 | USA | EcoLastMile | GLEC | EV charging required before route start. |
| DEL-20240601-006 | diesel | 0.366 | USA | R-1001 | Downtown North Loop | VAN-003 | van | 2024-06-03 | 13.5 | 7 | 24 | 8.8 | 1512 Central Depot Ave | Chicago | IL | 60622 | 3421 N Ashland Ave | Chicago | IL | 60657 | USA | SwiftLogistics | GLEC | Left warehouse at 8:15 AM. |
| DEL-20240601-007 | electric | 0.012 | USA | R-1006 | Harbor Run | SC-001 | scooter | 2024-06-04 | 4.6 | 3 | 6 | 0.07 | 80 Harbor Blvd | Miami | FL | 33132 | 3300 Biscayne Blvd | Miami | FL | 33137 | USA | UrbanFleet | custom | Scooter battery at 90%. |
| DEL-20240601-008 | other | 0.004 | USA | R-1007 | Campus Circuit | BIKE-002 | bike | 2024-06-04 | 2.8 | 4 | 5 | 0.02 | 10 College Ave | Ann Arbor | MI | 48104 | 500 S State St | Ann Arbor | MI | 48109 | USA | CampusCourier | custom | Manual bike delivery. |
| DEL-20240601-009 | diesel | 0.638 | USA | R-1008 | Sunset Strip | TRUCK-002 | truck | 2024-06-05 | 27.4 | 12 | 52 | 33.2 | 1800 Sunset Blvd | Los Angeles | CA | 90026 | 600 Hollywood Blvd | Los Angeles | CA | 90028 | USA | DeltaFreight | DEFRA | Included heavy furniture. |
| DEL-20240601-010 | electric | 0.068 | USA | R-1009 | Parkside | EVAN-002 | electric van | 2024-06-05 | 10.9 | 6 | 19 | 1.3 | 400 Park Ave | Denver | CO | 80205 | 1010 York St | Denver | CO | 80206 | USA | EcoLastMile | GLEC | blank |
| DEL-20240601-011 | hybrid | 0.246 | USA | R-1010 | Central Link | VAN-004 | van | 2024-06-06 | 15.2 | 10 | 24 | 5.9 | 900 Main St | Dallas | TX | 75202 | 3100 Elm St | Dallas | TX | 75226 | USA | SwiftLogistics | DEFRA | Hybrid van used for mixed urban/suburban route. |
| DEL-20240601-012 | electric | 0.013 | USA | R-1011 | Mall Loop | SC-002 | scooter | 2024-06-06 | 3.6 | 2 | 3 | 0.04 | 100 E Market St | Indianapolis | IN | 46204 | 900 Circle Centre Mall | Indianapolis | IN | 46225 | USA | UrbanFleet | custom | Battery at 60%. |
| DEL-20240601-013 | diesel | 0.414 | USA | R-1012 | Bay Area | VAN-005 | van | 2024-06-07 | 19.8 | 11 | 29 | 12 | 1500 Shoreline Dr | Oakland | CA | 94612 | 700 Embarcadero | Oakland | CA | 94607 | USA | SwiftLogistics | GLEC | blank |
| DEL-20240601-014 | electric | 0.06 | USA | R-1013 | Lakeshore | EVAN-003 | electric van | 2024-06-07 | 8.4 | 5 | 15 | 0.9 | 200 Lakeshore Blvd | Cleveland | OH | 44114 | 400 E 9th St | Cleveland | OH | 44115 | USA | EcoLastMile | GLEC | EV van ran full route on single charge. |
| DEL-20240601-015 | hybrid | 0.34 | USA | R-1010 | Central Link | VAN-006 | van | 2024-06-08 | 17.1 | 8 | 20 | 6.8 | 900 Main St | Dallas | TX | 75202 | 3100 Elm St | Dallas | TX | 75226 | USA | SwiftLogistics | DEFRA | Hybrid mode used for most of route. |
| DEL-20240601-016 | hybrid | 0.442 | USA | R-1014 | Midtown | TRUCK-004 | truck | 2024-06-08 | 20.2 | 13 | 45 | 19.9 | 500 Midtown Blvd | Atlanta | GA | 30309 | 700 Peachtree St | Atlanta | GA | 30308 | USA | DeltaFreight | GLEC | Hybrid truck trial route. |
| DEL-20240601-017 | diesel | 0.751 | USA | R-1004 | Riverfront | TRUCK-005 | truck | 2024-06-09 | 21.7 | 10 | 37 | 27.8 | 400 Wharf St | Memphis | TN | 38103 | 1100 Riverside Dr | Memphis | TN | 38106 | USA | DeltaFreight | DEFRA | blank |
| DEL-20240601-018 | electric | 0.019 | USA | R-1015 | Greenbelt | BIKE-003 | bike | 2024-06-10 | 6.3 | 4 | 8 | 0.15 | 300 Greenbelt Pkwy | Austin | TX | 78704 | 800 Barton Springs Rd | Austin | TX | 78704 | USA | GreenWheels | custom | Bike replaced EV van due to repairs. |
| DEL-20240601-019 | gasoline | 0.394 | USA | R-1016 | City Center | VAN-007 | van | 2024-06-10 | 11 | 7 | 18 | 7.1 | 700 Market St | Philadelphia | PA | 19106 | 1200 Walnut St | Philadelphia | PA | 19107 | USA | SwiftLogistics | GLEC | Minor detour due to roadworks. |
| DEL-20240601-020 | electric | 0.08 | USA | R-1017 | Tech Corridor | EVAN-004 | electric van | 2024-06-11 | 12.8 | 5 | 20 | 1.6 | 400 Silicon Rd | San Jose | CA | 95134 | 900 Innovation Ave | San Jose | CA | 95110 | USA | EcoLastMile | GLEC | blank |
What the 60 rows show
from the 60-row sampleDiesel (vehicle fuel type) stands out: mean co2_
- 0.17median co2_
emissions_ per_ package_ kg - 3emission calculation methods
- 5vehicle types
- 14provider names
- 16.2median distance_
km - 8.5median number_
of_ stops
Median 0.17, from 0.00 to 0.75.
- string 19
- integer 2
- float 3
- date 1
Columns
25 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 19 columns | |||
delivery_id | string | Unique identifier for each last-mile delivery recordunique | DEL-20240601-001 |
route_id | string | Unique identifier for the delivery route | R-1001 |
route_name | string | Descriptive name or code for the delivery routeoptional | Downtown North Loop |
vehicle_id | string | Unique identifier for the vehicle used | VAN-001 |
vehicle_type | string | Type of vehicle used (e.g., van, bike, electric van, scooter, truck)6 values | van |
vehicle_fuel_type | string | Type of fuel or energy source used by the vehicle (e.g., diesel, electric, gasoline, hybrid)diesel · electric · gasoline · hybrid · other | diesel |
origin_street_address | string | Street address of the delivery origin (e.g., warehouse or depot)optional | 1512 Central Depot Ave |
origin_city | string | City of the delivery originoptional | Chicago |
origin_state | string | State or province of the delivery originoptional | IL |
origin_postal_code | string | Postal code of the delivery originoptional | 60622 |
origin_country | string | Country of the delivery originoptional | USA |
destination_street_address | string | Street address of the final delivery destinationoptional | 3421 N Ashland Ave |
destination_city | string | City of the final delivery destinationoptional | Chicago |
destination_state | string | State or province of the final delivery destinationoptional | IL |
destination_postal_code | string | Postal code of the final delivery destinationoptional | 60657 |
destination_country | string | Country of the final delivery destinationoptional | USA |
provider_name | string | Name of the logistics provider or delivery company | SwiftLogistics |
emission_calculation_method | string | Method or standard used to calculate CO2 emissions (e.g., GLEC, DEFRA, custom)3 methods · optional | GLEC |
notes | string | Additional notes or comments about the delivery or emissions calculationoptional | Heavy cargo load. |
| Numbers 5 columns | |||
distance_km | float | Total distance covered during the delivery (in kilometers)0 or more | 13.7 |
number_of_stops | integer | Number of stops made during the delivery route1 or more | 8 |
total_packages_delivered | integer | Total number of packages delivered on this route1 or more | 32 |
co2_emissions_kg | float | Total CO2 emissions generated during the delivery (in kilograms)0 or more | 10.4 |
co2_emissions_per_package_kg | float | Average CO2 emissions per package delivered (in kilograms)0 or more · optional | 0.325 |
| Dates and times 1 column | |||
delivery_date | date | Date the delivery was completed | 2024-06-01 |
Use it for
A logistics dashboard
Co2_
emissions_ per_ package_ kg by vehicle_ fuel_ type and a breakdown of origin_ country. Excel, Power BI or Tableau. Why do the 19 diesel rows have a mean co2_
emissions_ per_ package_ kg of 0.44? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Deliveries60DEL-20240601-0010.325dieselDEL-20240601-0020.016electricDEL-20240601-0030.332gasoline
A software demo
Believable deliveries with route_
id, route_ name and vehicle_ id to fill a screen in front of a buyer.
blueprint · last-mile-delivery-emissions-benchmark
Behind this dataset
Same schema. As many rows as you need.
These 60 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.
- Each row represents a completed delivery route.
- CO2 emissions are calculated based on distance, vehicle type, and delivery weight.
- Only registered fleet vehicles with GPS tracking are included.
- Emission values standardized in kg CO2 per package delivered.
- Data includes urban, suburban, and rural routes.
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- last-mile-delivery-emissions-benchmark