Route Carbon Footprint Tracker
This dataset provides detailed, route-level carbon emission data for logistics operations, capturing vehicle types, load weights, driving conditions, and emissions metrics. It enables organizations to audit, benchmark, and optimize delivery routes for sustainability and ESG reporting, and to identify high-impact opportunities for green transportation initiatives.
Sample rows
preview · 8 of 75 rows · all 22 columns| route_idstring | vehicle_typestring | vehicle_capacity_kgfloat | route_completedboolean | start_location_countrystring | route_namestring | datedate | vehicle_idstring | vehicle_fuel_typestring | load_weight_kgfloat | distance_kmfloat | start_location_citystring | start_location_statestring | end_location_citystring | end_location_statestring | end_location_countrystring | driving_conditionsstring | average_speed_kphfloat | carbon_emissions_kgfloat | emissions_per_km_kgfloat | emissions_per_ton_km_kgfloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R10001 | diesel truck | 15000 | true | USA | Midwest Express | 2023-03-15 | V201 | diesel | 12200.5 | 410.8 | Chicago | IL | St. Louis | MO | USA | highway | 83.6 | 1649.7 | 4.02 | 0.33 | On-time delivery, mild traffic. |
| R10002 | electric van | 2500 | true | USA | Bay Area Loop | 2023-04-01 | V306 | electric | 1900 | 70.2 | San Francisco | CA | Oakland | CA | USA | urban | 32.8 | 10.7 | 0.15 | 0.08 | blank |
| R10003 | hybrid car | 650 | true | USA | Northern Corridor | 2023-05-22 | V411 | hybrid | 420 | 152.3 | Minneapolis | MN | Duluth | MN | USA | mixed | 54.3 | 55.8 | 0.37 | 0.88 | Rainy conditions, moderate delays. |
| R10004 | diesel truck | 18000 | true | UK | London South Run | 2023-06-05 | V112 | diesel | 16056.2 | 49.5 | London | London | Croydon | London | UK | urban | 28.4 | 218.9 | 4.42 | 0.28 | Congestion charge applied. |
| R10005 | gasoline van | 3400 | true | USA | Rural East | 2023-07-11 | V203 | gasoline | 2790.1 | 88.7 | Lincoln | NE | Omaha | NE | USA | rural | 62.2 | 67.1 | 0.76 | 0.24 | blank |
| R10006 | diesel truck | 22000 | true | USA | Pacific Interstate | 2023-07-18 | V501 | diesel | 21750.3 | 829.4 | Portland | OR | San Jose | CA | USA | highway | 97.5 | 3142.8 | 3.79 | 0.17 | Long-haul driver swap at midpoint. |
| R10007 | electric van | 2400 | false | USA | Big Apple Shuttle | 2022-11-27 | V333 | electric | 1630.4 | 23.1 | New York | NY | Brooklyn | NY | USA | urban | 19.7 | 3.5 | 0.15 | 0.09 | Minor mechanical issue, route incomplete. |
| R10008 | diesel truck | 16000 | true | USA | Great Lakes Link | 2023-09-16 | V921 | diesel | 14540 | 193.5 | Cleveland | OH | Detroit | MI | USA | highway | 95.4 | 622.1 | 3.22 | 0.29 | blank |
| R10009 | diesel truck | 20000 | true | USA | Tex-Mex Borderline | 2023-10-03 | V604 | diesel | 18333 | 278.9 | San Antonio | TX | Laredo | TX | USA | highway | 88.6 | 1025.2 | 3.67 | 0.2 | Border customs delay. |
| R10010 | hybrid van | 3600 | true | Switzerland | Alpine Delivery | 2023-12-12 | V721 | hybrid | 3490 | 112.7 | Zurich | Zurich | Bern | Bern | Switzerland | rural | 56.8 | 46.5 | 0.41 | 0.12 | blank |
| R10011 | electric mini truck | 1400 | true | Japan | Tokyo Central Loop | 2023-06-07 | V888 | electric | 1090 | 37.8 | Tokyo | Tokyo | Yokohama | Kanagawa | Japan | urban | 25.3 | 6.8 | 0.18 | 0.16 | Heavy morning traffic. |
| R10012 | diesel truck | 18000 | true | USA | Pennsylvania Parkway | 2023-02-11 | V215 | diesel | 17200 | 301.4 | Philadelphia | PA | Pittsburgh | PA | USA | highway | 90.4 | 1179.5 | 3.92 | 0.24 | blank |
| R10013 | diesel truck | 16000 | true | Spain | Iberian Sweep | 2023-09-29 | V722 | diesel | 15200 | 476.6 | Madrid | Madrid | Lisbon | Lisboa | Portugal | highway | 85.3 | 1332.2 | 2.8 | 0.18 | blank |
| R10014 | diesel truck | 20000 | true | Australia | Queensland Coastal | 2023-08-23 | V305 | diesel | 18200 | 621.3 | Brisbane | Queensland | Cairns | Queensland | Australia | highway | 98.2 | 1923.5 | 3.1 | 0.17 | blank |
| R10015 | hybrid van | 3500 | true | Sweden | Scandinavian Freight | 2023-03-13 | V514 | hybrid | 3100 | 730.1 | Stockholm | Stockholm | Oslo | Oslo | Norway | mixed | 72.1 | 173.8 | 0.24 | 0.09 | Cross-border customs cleared. |
| R10016 | diesel truck | 17500 | true | USA | Corn Belt | 2023-04-30 | V352 | diesel | 15000 | 356.2 | Des Moines | IA | Kansas City | MO | USA | highway | 89.4 | 948.3 | 2.66 | 0.18 | blank |
| R10017 | diesel truck | 15500 | true | Estonia | Baltic Express | 2023-04-18 | V298 | diesel | 12790 | 523.7 | Tallinn | Harju | Riga | Riga | Latvia | highway | 78.6 | 1579.6 | 3.02 | 0.24 | blank |
| R10018 | electric van | 2400 | true | USA | Manhattan Drop | 2023-05-05 | V333 | electric | 1840 | 18.9 | New York | NY | Jersey City | NJ | USA | urban | 23.6 | 2.8 | 0.15 | 0.09 | blank |
| R10019 | electric van | 2500 | true | USA | Central Valley | 2023-01-19 | V306 | electric | 2250 | 142.4 | Fresno | CA | Sacramento | CA | USA | mixed | 51.1 | 18.6 | 0.13 | 0.06 | blank |
| R10020 | hybrid van | 3600 | true | Germany | Rhine Run | 2023-07-14 | V721 | hybrid | 3290 | 92 | Frankfurt | Hesse | Cologne | North Rhine-Westphalia | Germany | urban | 48.3 | 32.2 | 0.35 | 0.11 | blank |
What the 75 rows show
from the 75-row sampleDiesel truck (vehicle type) stands out: mean vehicle_
- 96%route_
completed = true - 3,600median vehicle_
capacity_ kg - 4vehicle fuel types
- 4driving conditionses
- 3,300median load_
weight_ kg - 87.5median distance_
km
Median 3,600, from 500 to 22,000.
- string 13
- float 7
- date 1
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
route_id | string | Unique identifier for the delivery routeunique | R10001 |
route_name | string | Descriptive name or label for the routeoptional | Midwest Express |
vehicle_id | string | Unique identifier for the vehicle used | V201 |
vehicle_type | string | Type of vehicle (e.g., diesel truck, electric van, hybrid car)6 types | diesel truck |
vehicle_fuel_type | string | Fuel type used by the vehicle (e.g., diesel, gasoline, electric, hybrid)diesel · gasoline · electric · hybrid · other | diesel |
start_location_city | string | City where the route starts | Chicago |
start_location_state | string | State or region where the route startsoptional | IL |
start_location_country | string | Country where the route starts | USA |
end_location_city | string | City where the route ends | St. Louis |
end_location_state | string | State or region where the route endsoptional | MO |
end_location_country | string | Country where the route ends | USA |
driving_conditions | string | Summary of driving conditions (e.g., urban, rural, highway, mixed)urban · rural · highway · mixed · other | highway |
notes | string | Additional notes or comments about the route or emissions calculationoptional | Border customs delay. |
| Numbers 7 columns | |||
vehicle_capacity_kg | float | Maximum load capacity of the vehicle in kilograms0 or more · optional | 15000 |
load_weight_kg | float | Actual load weight carried during the route in kilograms0 or more | 12200.5 |
distance_km | float | Total distance traveled on the route in kilometers0 or more | 410.8 |
average_speed_kph | float | Average speed during the route in kilometers per hour0 or more · optional | 83.6 |
carbon_emissions_kg | float | Total carbon emissions for the route in kilograms CO2 equivalent0 or more | 1649.7 |
emissions_per_km_kg | float | Carbon emissions per kilometer for the route in kilograms CO2 equivalent0 or more · optional | 4.02 |
emissions_per_ton_km_kg | float | Carbon emissions per ton-kilometer (kg CO2e per 1000kg per km)0 or more · optional | 0.33 |
| Dates and times 1 column | |||
date | date | Date when the route was completed or analyzed | 2023-03-15 |
| True or false 1 column | |||
route_completed | boolean | Indicates if the route was completed as planned | true |
Use it for
A logistics dashboard
The route_
completed rate, vehicle_ capacity_ kg by vehicle_ type and a breakdown of start_ location_ country. Excel, Power BI or Tableau. Why do the 35 diesel truck rows have a mean vehicle_
capacity_ kg of 14,451? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Routes75R1000115000diesel t…R100022500electric…R100072400electric…
A software demo
Believable routes with route_
name, date and vehicle_ id to fill a screen in front of a buyer.
blueprint · route-carbon-footprint-tracker
Behind this dataset
Same schema. As many rows as you need.
These 75 rows came out of a blueprint — 22 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 segment.
- Carbon emissions calculated using vehicle type, fuel efficiency, and distance.
- Include load weight, ambient weather, and stop frequency for each segment.
- Flag routes exceeding carbon intensity thresholds set by ESG compliance.
- Route start/end locations must be anonymized for privacy.
- Aggregate monthly totals for benchmarking.
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
- route-carbon-footprint-tracker