E-commerce Last-Mile Impact Tracker

This dataset provides granular tracking of last-mile e-commerce deliveries, capturing operational details, vehicle and route information, and estimated carbon emissions. It enables digital operations managers to analyze delivery patterns, optimize routes, and assess the effectiveness of sustainability initiatives, supporting data-driven decisions to minimize environmental impact.

  • last updated 23 Dec 2025
  • by GoMask
The brief that made it

Monitor and report carbon footprint of e-commerce deliveries

Sample rows

preview · 8 of 60 rows · all 23 columns
delivery_idstringvehicle_typestringcarbon_emissions_kgfloatroute_optimization_appliedbooleandelivery_address_statestringorder_idstringdelivery_datedatedelivery_time_window_startdatetimedelivery_time_window_enddatetimeactual_delivery_timedatetimedelivery_vehicle_idstringvehicle_fuel_typestringroute_distance_kmfloatroute_duration_minutesfloatdelivery_address_streetstringdelivery_address_citystringdelivery_address_postal_codestringdelivery_address_countrystringnumber_of_packagesintegerpackage_total_weight_kgfloatdelivery_statusstringsustainability_measures_appliedbooleannotesstring
DEL-00001van2.46trueTXORD-101012024-06-012024-06-01T09:00:002024-06-01T12:00:002024-06-01T11:23:00VEH-301diesel14.252.7341 Cedar Park AveHouston77002USA37.4completedfalseDelivered on time
DEL-00002electric_vehicle0.14trueCAORD-101022024-06-022024-06-02T14:00:002024-06-02T16:00:002024-06-02T15:41:00VEH-312electric938.2578 Willow LaneSan Jose95112USA24.2completedtrueEco-routing used
DEL-00003bike0falseILORD-101032024-06-032024-06-03T08:30:002024-06-03T11:00:002024-06-03T10:59:00VEH-321human_powered3.719.11021 N Clark StChicago60610USA11.2completedtrueGreen packaging used
DEL-00004motorcycle1.15trueAZORD-101042024-06-042024-06-04T13:00:002024-06-04T15:00:002024-06-04T14:56:00VEH-335petrol5.825.4852 Aspen DrPhoenix85016USA25.9completedfalseblank
DEL-00005electric_vehicle0.31falseCAORD-101052024-06-052024-06-05T17:00:002024-06-05T19:00:002024-06-05T18:49:00VEH-312electric17.655.82100 Pine StSan Francisco94109USA49.3delayedtrueTraffic delay reported
DEL-00006van1.81trueTXORD-101062024-06-062024-06-06T11:00:002024-06-06T13:30:002024-06-06T12:11:00VEH-301diesel8.443.61124 Maple AveDallas75201USA28.2completedfalsePackage handled with care
DEL-00007bike0falseORORD-101072024-06-072024-06-07T10:00:002024-06-07T13:00:002024-06-07T12:20:00VEH-321human_powered2.514.6223 Liberty BlvdPortland97205USA10.9completedtrueblank
DEL-00008van4.92trueFLORD-101082024-06-082024-06-08T13:30:002024-06-08T16:00:002024-06-08T15:10:00VEH-343petrol22.968.3999 Summer StMiami33130USA614.1completedfalseLarge order

What the 60 rows show

from the 60-row sample

Van (vehicle type) stands out: mean carbon_emissions_kg is 2.8, against 0.32 for the rest.

  • 55%route_optimization_applied = true
  • 0.47median carbon_emissions_kg
  • 3delivery statuses
  • 5vehicle fuel types
  • 7.3median route_distance_km
  • 28.0median route_duration_minutes
Mean carbon_emissions_kg by vehicle_type60 rows
0242.8van20 rows0.0bike10 rows0.21electr…13 rows0.91motorc…11 rows0.02drone6 rows
carbon_emissions_kg60 rows, in bands of 1
0204035126331036carbon_emissions_kg →

Median 0.47, from 0.0 to 5.6.

delivery_address_state60 rows · top 10 of 26 values
  1. CA11
  2. TX7
  3. FL6
  4. WA5
  5. GA4
  6. AZ3
  7. OR2
  8. OH2
  9. NC2
  10. MO2
23 columns by typefrom the column list below
  • string 12
  • integer 1
  • float 4
  • date 1
  • datetime 3
  • boolean 2

Columns

23 columns in four groups
blueprint · 23 columns
columntypedescriptionexample
Text 12 columns
delivery_idstringUnique identifier for each last-mile delivery eventuniqueDEL-00001
order_idstringUnique identifier for the e-commerce order associated with the deliveryORD-10101
delivery_vehicle_idstringUnique identifier for the vehicle used for deliveryVEH-301
vehicle_typestringType of vehicle used for delivery (e.g., van, bike, electric vehicle)6 valuesvan
vehicle_fuel_typestringFuel type used by the delivery vehicle (e.g., diesel, petrol, electric)6 valuesdiesel
delivery_address_streetstringStreet address of the delivery destination341 Cedar Park Ave
delivery_address_citystringCity of the delivery destinationHouston
delivery_address_statestringState or region of the delivery destinationTX
delivery_address_postal_codestringPostal code of the delivery destination77002
delivery_address_countrystringCountry of the delivery destinationUSA
delivery_statusstringStatus of the delivery (e.g., completed, failed, delayed)completed · failed · delayed · cancelled · in_progresscompleted
notesstringAdditional notes or comments about the delivery eventoptionalDelivered on time
Numbers 5 columns
route_distance_kmfloatTotal distance covered during the last-mile delivery route, in kilometers0 or more14.2
route_duration_minutesfloatTotal duration of the delivery route, in minutes0 or more52.7
number_of_packagesintegerNumber of packages delivered in this event1 or more3
package_total_weight_kgfloatTotal weight of all packages delivered, in kilograms0 or more7.4
carbon_emissions_kgfloatEstimated carbon emissions for the delivery event, in kilograms0 or more2.46
Dates and times 4 columns
delivery_datedateDate when the delivery was completed2024-06-01
delivery_time_window_startdatetimeScheduled start time for the delivery windowoptional2024-06-01T09:00:00
delivery_time_window_enddatetimeScheduled end time for the delivery windowoptional2024-06-01T12:00:00
actual_delivery_timedatetimeActual timestamp when the delivery was made2024-06-01T11:23:00
True or false 2 columns
route_optimization_appliedbooleanIndicates if route optimization was applied for this deliverytrue
sustainability_measures_appliedbooleanIndicates if sustainability measures (e.g., eco-routing, green packaging) were appliedoptionalfalse

Use it for

  • route optimiza…55%33 of 60 rowsmean carbon emissions…2.8van0.0bike0.21elec…0.91moto…

    A logistics dashboard

    The route_optimization_applied rate, carbon_emissions_kg by vehicle_type and a breakdown of delivery_address_state. Excel, Power BI or Tableau.

  • Why do the 20 van rows have a mean carbon_emissions_kg of 2.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 order_id, delivery_date and delivery_time_window_start to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

blueprint · e-commerce-last-mile-impact-tracker

Behind this dataset

Same schema. As many rows as you need.

These 60 rows came out of a blueprint — 23 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 single last-mile delivery event.
  • Emissions are calculated using distance, vehicle type, and delivery time.
  • Delivery failures and delays are flagged for further analysis.
  • Sustainability score is assigned to each delivery based on emissions and efficiency.
  • Carrier and fulfillment center details are anonymized for compliance.
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
e-commerce-last-mile-impact-tracker

More in Logistics

Browse all
Also in LogisticsE-commerce Last-Mile Delivery RisksLogistics Last-Mile Delivery TimesSupply Chain Inventory MovementsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.