Urban Last-Mile Emissions Tracker
This dataset provides granular tracking of urban last-mile delivery routes, capturing vehicle emissions, operational efficiency, and geographic context. It empowers fleet managers and city planners to analyze environmental impact, optimize delivery operations, and support eco-friendly logistics initiatives. The data is ideal for benchmarking, regulatory reporting, and identifying high-impact areas for sustainability improvements.
Sample rows
preview · 8 of 120 rows · all 25 columns| route_idstring | vehicle_typestring | total_distance_kmfloat | countrystring | delivery_datedate | vehicle_idstring | vehicle_fuel_typestring | fleet_idstring | driver_idstring | start_timedatetime | end_timedatetime | start_latitudefloat | start_longitudefloat | end_latitudefloat | end_longitudefloat | total_duration_minutesfloat | number_of_stopsinteger | successful_deliveriesinteger | failed_deliveriesinteger | total_emissions_kg_co2efloat | emissions_per_km_kg_co2efloat | emissions_per_delivery_kg_co2efloat | citystring | regionstring | route_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R001-20240601-NYC | van | 32.6 | USA | 2024-06-01 | VAN-1001 | diesel | FleetA | DRV-001 | 2024-06-01T05:35:00Z | 2024-06-01T09:40:00Z | 40.7128 | -74.006 | 40.7356 | -73.9906 | 245 | 13 | 12 | 1 | 27.2 | 0.834 | 2.267 | New York | NY | Traffic congestion caused minor delays at two stops. One failed delivery due to incorrect address. |
| R002-20240601-LON | electric van | 12.4 | United Kingdom | 2024-06-01 | EV-101 | electric | FleetGreenUK | DRV-002 | 2024-06-01T07:10:00Z | 2024-06-01T09:25:00Z | 51.5074 | -0.1278 | 51.4983 | -0.1657 | 135 | 8 | 8 | 0 | 0.6 | 0.048 | 0.075 | London | England | Pilot route for low emission zones. All deliveries successful, minimal traffic delays. |
| R003-20240602-SFO | truck | 82.2 | USA | 2024-06-02 | TRK-205 | diesel | FleetWest | DRV-003 | 2024-06-02T06:45:00Z | 2024-06-02T17:00:00Z | 37.7749 | -122.4194 | 37.7925 | -122.3957 | 615 | 23 | 22 | 1 | 87.7 | 1.067 | 3.986 | San Francisco | CA | Construction detours increased route length. One failed delivery due to weather-related road closure. |
| R004-20240602-TYO | bike | 2.8 | Japan | 2024-06-02 | BIKE-007 | other | FleetTokyo | DRV-004 | 2024-06-02T04:20:00Z | 2024-06-02T05:10:00Z | 35.6895 | 139.6917 | 35.6872 | 139.6981 | 50 | 3 | 3 | 0 | 0 | 0 | 0 | Tokyo | Tokyo | All deliveries completed by bike. Zero emissions and smooth ride, moderate morning traffic. |
| R005-20240603-BER | electric van | 9.7 | Germany | 2024-06-03 | EV-102 | electric | FleetGreenDE | blank | 2024-06-03T06:30:00Z | 2024-06-03T08:00:00Z | 52.52 | 13.405 | 52.5153 | 13.3994 | 90 | 7 | 7 | 0 | 0.8 | 0.082 | 0.114 | Berlin | Berlin | Auto-dispatch route. Electric van tested for smooth delivery in central Berlin. Zero failed deliveries. |
| R006-20240603-MUM | van | 37.1 | India | 2024-06-03 | VAN-1002 | diesel | FleetInd | DRV-005 | 2024-06-03T08:45:00Z | 2024-06-03T12:50:00Z | 19.076 | 72.8777 | 19.0823 | 72.8682 | 245 | 14 | 13 | 1 | 31.8 | 0.858 | 2.446 | Mumbai | Maharashtra | Heavy traffic in South Mumbai led to a missed delivery. Diesel van performed as expected. |
| R007-20240604-AKL | electric van | 7.4 | New Zealand | 2024-06-04 | EV-103 | electric | FleetNZ | DRV-006 | 2024-06-04T04:55:00Z | 2024-06-04T06:50:00Z | -36.8485 | 174.7633 | -36.852 | 174.7689 | 115 | 6 | 6 | 0 | 0.5 | 0.068 | 0.083 | Auckland | Auckland | All stops completed; electric van operated with low noise and zero tailpipe emissions. |
| R008-20240604-CAI | truck | 74.8 | Egypt | 2024-06-04 | TRK-206 | diesel | FleetCairo | DRV-007 | 2024-06-04T07:00:00Z | 2024-06-04T16:40:00Z | 30.0444 | 31.2357 | 30.0511 | 31.2432 | 580 | 18 | 17 | 1 | 63.5 | 0.849 | 3.735 | Cairo | Cairo Governorate | One missed delivery due to customer absence. Route passed through moderate construction zones. |
| R009-20240605-RIO | bike | 1.5 | Brazil | 2024-06-05 | BIKE-008 | other | FleetRio | DRV-008 | 2024-06-05T05:30:00Z | 2024-06-05T06:00:00Z | -22.9068 | -43.1729 | -22.9102 | -43.1804 | 30 | 2 | 2 | 0 | 0 | 0 | 0 | Rio de Janeiro | Rio de Janeiro | Sunny weather made for a fast and easy bike delivery; all stops completed successfully. |
| R010-20240605-TOR | van | 21.4 | Canada | 2024-06-05 | VAN-1003 | gasoline | FleetToronto | DRV-009 | 2024-06-05T06:40:00Z | 2024-06-05T09:15:00Z | 43.6532 | -79.3832 | 43.6558 | -79.3802 | 155 | 9 | 9 | 0 | 18.3 | 0.855 | 2.033 | Toronto | ON | Gasoline van completed all deliveries; minor delays due to downtown traffic. |
| R011-20240606-SHA | bike | 0.6 | China | 2024-06-06 | BIKE-009 | other | FleetShanghai | DRV-010 | 2024-06-06T07:05:00Z | 2024-06-06T07:15:00Z | 31.2304 | 121.4737 | 31.2318 | 121.4712 | 10 | 1 | 1 | 0 | 0 | 0 | 0 | Shanghai | Shanghai | Single-stop bike delivery with zero emissions; completed swiftly. |
| R012-20240606-DEL | van | 39.6 | India | 2024-06-06 | VAN-1004 | diesel | FleetInd | DRV-011 | 2024-06-06T09:00:00Z | 2024-06-06T13:30:00Z | 28.6139 | 77.209 | 28.6201 | 77.2315 | 270 | 12 | 11 | 1 | 34.5 | 0.871 | 3.136 | Delhi | Delhi | One stop not completed; diesel van operated efficiently in heavy traffic. |
| R013-20240607-SYD | van | 28.2 | Australia | 2024-06-07 | VAN-1005 | diesel | FleetAus | DRV-012 | 2024-06-07T05:55:00Z | 2024-06-07T10:15:00Z | -33.8688 | 151.2093 | -33.8547 | 151.2175 | 260 | 11 | 10 | 1 | 22.7 | 0.806 | 2.27 | Sydney | NSW | Minor delays due to roadworks; one failed delivery, all others successful. |
| R014-20240607-REY | truck | 92.8 | Iceland | 2024-06-07 | TRK-207 | other | FleetIceland | DRV-013 | 2024-06-07T08:30:00Z | 2024-06-07T19:40:00Z | 64.9631 | -19.0208 | 64.9802 | -19.025 | 670 | 19 | 19 | 0 | 41.7 | 0.449 | 2.194 | Reykjavík | Capital Region | Biodiesel truck completed all stops with moderate emissions; route included rural areas. |
| R015-20240608-NYC | van | 31.7 | USA | 2024-06-08 | VAN-1006 | diesel | FleetA | DRV-014 | 2024-06-08T04:30:00Z | 2024-06-08T09:15:00Z | 40.7128 | -74.006 | 40.7291 | -73.9965 | 285 | 13 | 12 | 1 | 28.6 | 0.903 | 2.383 | New York | NY | Heavy rain caused a missed delivery; all other stops completed on time. |
| R016-20240608-DEL | electric van | 8.2 | India | 2024-06-08 | EV-104 | electric | FleetInd | DRV-015 | 2024-06-08T07:20:00Z | 2024-06-08T09:20:00Z | 28.6139 | 77.209 | 28.6172 | 77.2158 | 120 | 6 | 6 | 0 | 0.6 | 0.073 | 0.1 | Delhi | Delhi | Electric van operated smoothly; no failed deliveries, low morning traffic. |
| R017-20240609-PAR | van | 26.9 | France | 2024-06-09 | VAN-1007 | diesel | FleetParis | DRV-016 | 2024-06-09T05:25:00Z | 2024-06-09T10:05:00Z | 48.8566 | 2.3522 | 48.8579 | 2.3483 | 280 | 10 | 10 | 0 | 22.2 | 0.825 | 2.22 | Paris | Île-de-France | All stops completed; moderate traffic and timely delivery. |
| R018-20240609-BER | electric van | 6.9 | Germany | 2024-06-09 | EV-105 | electric | FleetGreenDE | DRV-017 | 2024-06-09T07:45:00Z | 2024-06-09T09:30:00Z | 52.52 | 13.405 | 52.5242 | 13.4001 | 105 | 5 | 5 | 0 | 0.5 | 0.072 | 0.1 | Berlin | Berlin | Short electric van route; zero failed deliveries, minimal delays. |
| R019-20240610-CAI | truck | 98.6 | Egypt | 2024-06-10 | TRK-208 | diesel | FleetCairo | DRV-018 | 2024-06-10T06:20:00Z | 2024-06-10T16:15:00Z | 30.0444 | 31.2357 | 30.0492 | 31.2441 | 595 | 22 | 21 | 1 | 129.2 | 1.311 | 6.152 | Cairo | Cairo Governorate | One failed delivery due to incorrect address; heavy emissions noted in urban segments. |
| R020-20240610-BOM | van | 19.5 | India | 2024-06-10 | VAN-1008 | diesel | FleetInd | DRV-019 | 2024-06-10T08:05:00Z | 2024-06-10T11:15:00Z | 19.076 | 72.8777 | 19.0794 | 72.8725 | 190 | 8 | 8 | 0 | 15.7 | 0.805 | 1.963 | Mumbai | Maharashtra | All stops completed successfully. Diesel van performed as expected. |
What the 120 rows show
from the 120-row sampleTruck (vehicle type) stands out: mean total_
- 18.4median total_
distance_ km - 4vehicle fuel types
- 145median total_
duration_ minutes - 9median number_
of_ stops - 8median successful_
deliveries - 0median failed_
deliveries
Median 18.4, from 0.0 to 125.6.
- string 10
- integer 3
- float 9
- date 1
- datetime 2
Columns
25 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
route_id | string | Unique identifier for each delivery route instance.unique | R001-20240601-NYC |
vehicle_id | string | Unique identifier for the delivery vehicle. | VAN-1001 |
vehicle_type | string | Type of vehicle used (e.g., van, bike, electric van, truck).van · bike · electric van · truck · other | van |
vehicle_fuel_type | string | Fuel type used by the vehicle (e.g., diesel, gasoline, electric, hybrid).diesel · gasoline · electric · hybrid · other | diesel |
fleet_id | string | Identifier for the fleet or company operating the vehicle.optional | FleetA |
driver_id | string | Unique identifier for the driver assigned to the route.optional | DRV-001 |
city | string | City where the delivery route took place. | New York |
region | string | Administrative region, state, or province of the delivery route.optional | NY |
country | string | Country where the delivery route occurred. | USA |
route_notes | string | Optional notes or comments about the delivery route, such as traffic conditions or incidents.optional | Traffic congestion caused… |
| Numbers 12 columns | |||
start_latitude | float | Latitude coordinate of the route's starting point.-90 to 90 | 40.7128 |
start_longitude | float | Longitude coordinate of the route's starting point.-180 to 180 | -74.006 |
end_latitude | float | Latitude coordinate of the route's ending point.-90 to 90 · optional | 40.7356 |
end_longitude | float | Longitude coordinate of the route's ending point.-180 to 180 · optional | -73.9906 |
total_distance_km | float | Total distance covered during the delivery route in kilometers.0 or more | 32.6 |
total_duration_minutes | float | Total duration of the delivery route in minutes.0 or more | 245 |
number_of_stops | integer | Total number of delivery stops made on the route.1 or more | 13 |
successful_deliveries | integer | Number of successful deliveries completed on the route.0 or more | 12 |
failed_deliveries | integer | Number of failed or missed deliveries on the route.0 or more | 1 |
total_emissions_kg_co2e | float | Total greenhouse gas emissions for the route, measured in kilograms of CO2 equivalent.0 or more | 27.2 |
emissions_per_km_kg_co2e | float | Average emissions per kilometer for the route, in kg CO2e/km.0 or more · optional | 0.834 |
emissions_per_delivery_kg_co2e | float | Average emissions per delivery stop, in kg CO2e/delivery.0 or more · optional | 2.267 |
| Dates and times 3 columns | |||
delivery_date | date | Date on which the delivery route was executed. | 2024-06-01 |
start_time | datetime | Timestamp when the delivery route started. | 2024-06-01T05:35:00Z |
end_time | datetime | Timestamp when the delivery route ended. | 2024-06-01T09:40:00Z |
Use it for
A logistics dashboard
Total_
distance_ km by vehicle_ type and a breakdown of country. Excel, Power BI or Tableau. Why do the 31 truck rows have a mean total_
distance_ km of 86.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Routes120R001-20240601-NYC32.6vanR002-20240601-LON12.4electric…R003-20240602-SFO82.2truck
A software demo
Believable routes with delivery_
date, vehicle_ id and vehicle_ type to fill a screen in front of a buyer.
This dataset120 rows25 columns
Yours10,000 rows25 columnscity: UK only
blueprint · urban-last-mile-emissions-tracker
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 completed delivery trip within city boundaries.
- Emissions calculation incorporates vehicle type, distance, and idle time.
- Routes must include time-stamped start and end locations.
- Emission values flagged if exceeding city or EU limits.
- Trips without GPS coordinates or emissions data are excluded.
Open the blueprint in Data Factory
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
- urban-last-mile-emissions-tracker