Fleet Emissions Optimization Dataset
This dataset provides granular, trip-level data for commercial fleets, including vehicle specifications, route details, fuel and energy consumption, and calculated carbon emissions. It is designed to help transportation operators and urban planners optimize route efficiency, reduce emissions, and support sustainability and ESG reporting initiatives. The dataset enables in-depth analysis of vehicle performance, energy-saving opportunities, and environmental impact across fleets and time periods.
Sample rows
preview · 8 of 120 rows · all 28 columns| fleet_idstring | vehicle_typestring | route_efficiency_scorefloat | vehicle_makestring | operator_namestring | vehicle_idstring | vehicle_modelstring | vehicle_yearinteger | route_idstring | route_namestring | route_start_latitudefloat | route_start_longitudefloat | route_end_latitudefloat | route_end_longitudefloat | trip_idstring | trip_start_datetimedatetime | trip_end_datetimedatetime | distance_travelled_kmfloat | average_speed_kmhfloat | fuel_typestring | fuel_consumed_litersfloat | energy_consumed_kwhfloat | co2_emissions_kgfloat | emissions_factor_gco2_per_kmfloat | occupancyinteger | load_factor_percentfloat | eco_driving_scorefloat | reporting_periodstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FLEET001-US | electric | 97.5 | Tesla | UrbanEco Mobility | V001-US | Model 3 | 2022 | R001-US | Downtown Express | 40.7128 | -74.006 | 40.7306 | -73.9866 | T001-2024 | 2024-06-05T09:15:00 | 2024-06-05T09:47:00 | 13.2 | 21.7 | electricity | blank | 8.7 | 2.1 | 122 | 2 | 39.2 | 94.8 | 2024-06 |
| FLEET002-UK | hybrid | 88.9 | Toyota | GreenRide Shuttles | V002-UK | Prius Hybrid | 2019 | R002-UK | Central-London Loop | 51.5074 | -0.1278 | 51.5245 | -0.1325 | T002-2024 | 2024-04-14T08:20:00 | 2024-04-14T08:55:00 | 14.8 | 25.4 | hybrid | 0.8 | 6.4 | 1.3 | 92 | 3 | 62 | 98.1 | 2024-Q2 |
| FLEET003-DE | truck | 41.9 | MAN | LogiHaul GmbH | V003-DE | TGS 18.440 | 2015 | R003-DE | Berlin-Hamburg Freight | 52.52 | 13.405 | 53.5511 | 9.9937 | T003-2024 | 2024-03-03T06:10:00 | 2024-03-03T11:30:00 | 289.3 | 54.9 | diesel | 68.5 | blank | 182.3 | 630 | 0 | 94.6 | 39.3 | 2024-Q1 |
| FLEET004-IN | van | 73.2 | Tata | BlueExpress India | V004-IN | Winger | 2018 | R004-IN | Mumbai Courier Route | 19.076 | 72.8777 | 19.2183 | 72.9781 | T004-2024 | 2024-05-17T14:25:00 | 2024-05-17T15:05:00 | 12.9 | 18.9 | diesel | 3.5 | blank | 8.9 | 690 | 1 | 55.3 | 77 | 2024-05 |
| FLEET005-BR | motorcycle | 84.1 | Honda | RioCourier | V005-BR | CB 300R | 2021 | R005-BR | Zona Sul Circuit | -22.9068 | -43.1729 | -22.9707 | -43.1845 | T005-2024 | 2024-03-22T10:15:00 | 2024-03-22T10:37:00 | 8.7 | 23.4 | gasoline | 0.9 | blank | 2.5 | 287 | 0 | 18.5 | 91.6 | 2024-03 |
| FLEET006-AU | electric | 98.2 | Nissan | Sydney Sustainable | V006-AU | Leaf | 2023 | R006-AU | CBD Shuttle | -33.8688 | 151.2093 | -33.8742 | 151.2161 | T006-2024 | 2024-06-11T11:00:00 | 2024-06-11T11:29:00 | 6.6 | 13.6 | electricity | blank | 6.1 | 1.2 | 181 | 2 | 34.2 | 96.7 | 2024-06 |
| FLEET007-FR | car | 99.1 | Renault | EcoMove Paris | V007-FR | ZOE | 2020 | R007-FR | Montparnasse Loop | 48.8422 | 2.3206 | 48.8566 | 2.3522 | T007-2024 | 2024-04-09T13:40:00 | 2024-04-09T14:12:00 | 8.5 | 16 | electricity | blank | 5.8 | 1 | 118 | 3 | 53.7 | 92.4 | 2024-Q2 |
| FLEET008-CA | van | 88.9 | Ford | Toronto Delivery | V008-CA | Transit | 2017 | R008-CA | Queen St. Corridor | 43.6532 | -79.3832 | 43.6629 | -79.3957 | T008-2024 | 2024-05-22T12:00:00 | 2024-05-22T12:40:00 | 9.1 | 13.6 | gasoline | 1.2 | blank | 2.4 | 263 | 1 | 69.8 | 66.2 | 2024-05 |
| FLEET009-JP | car | 92.6 | Honda | Tokyo QuickShip | V009-JP | Fit | 2018 | R009-JP | Shibuya-Meguro Run | 35.658 | 139.7017 | 35.6417 | 139.6981 | T009-2024 | 2024-04-27T08:12:00 | 2024-04-27T08:35:00 | 6.6 | 17.2 | gasoline | 0.7 | blank | 1.9 | 286 | 2 | 29.3 | 85.1 | 2024-Q2 |
| FLEET010-ZA | truck | 38.2 | Mercedes-Benz | CapeFreight Logistics | V010-ZA | Actros | 2011 | R010-ZA | Cape Town Haul | -33.9249 | 18.4241 | -34.1382 | 18.4346 | T010-2024 | 2024-03-11T05:34:00 | 2024-03-11T10:12:00 | 218.7 | 44.2 | diesel | 59.1 | blank | 163.9 | 749 | 0 | 98.7 | 41.5 | 2024-Q1 |
| FLEET011-SG | electric | 97.8 | BYD | SingEco Fleet | V011-SG | e6 | 2024 | R011-SG | Orchard Shuttle | 1.3048 | 103.8318 | 1.3086 | 103.8315 | T011-2024 | 2024-06-22T09:10:00 | 2024-06-22T09:38:00 | 7.2 | 15.4 | electricity | blank | 6.7 | 0.8 | 97 | 1 | 29.9 | 99.2 | 2024-06 |
| FLEET012-MX | motorcycle | 86.8 | Yamaha | CDMX Courier | V012-MX | FZ-S | 2020 | R012-MX | Polanco QuickRun | 19.4326 | -99.1332 | 19.4301 | -99.1974 | T012-2024 | 2024-03-18T07:18:00 | 2024-03-18T07:37:00 | 6.2 | 19.6 | gasoline | 0.6 | blank | 1.5 | 242 | 0 | 23.6 | 79.3 | 2024-03 |
| FLEET013-IT | hybrid | 89.3 | Chevrolet | MilanoEco | V013-IT | Volt | 2021 | R013-IT | Duomo Circuit | 45.4642 | 9.19 | 45.4782 | 9.2278 | T013-2024 | 2024-05-03T07:32:00 | 2024-05-03T08:05:00 | 12.7 | 22.4 | hybrid | 0.6 | 8.2 | 1.3 | 104 | 2 | 71.2 | 93.2 | 2024-Q2 |
| FLEET014-CN | truck | 32.1 | FAW | BeijingLogistics | V014-CN | JH6 | 2016 | R014-CN | Chaoyang-Fengtai | 39.9042 | 116.4074 | 39.866 | 116.2862 | T014-2024 | 2024-04-02T05:00:00 | 2024-04-02T07:40:00 | 136.8 | 34.2 | diesel | 34.4 | blank | 74.9 | 547 | 0 | 90.3 | 38.8 | 2024-Q2 |
| FLEET015-US | van | 67.9 | Fiat | ExpressLogix | V015-US | Ducato | 2014 | R015-US | Midtown Delivery | 40.7549 | -73.984 | 40.7638 | -73.9728 | T015-2024 | 2024-05-30T10:35:00 | 2024-05-30T11:20:00 | 7.1 | 10.5 | diesel | 1.1 | blank | 2.8 | 394 | 1 | 50.7 | 78.8 | 2024-05 |
| FLEET016-ES | electric | 96.1 | Renault | Barcelona UrbanMob | V016-ES | Kangoo ZE | 2021 | R016-ES | Eixample Shuttle | 41.3851 | 2.1734 | 41.4036 | 2.1744 | T016-2024 | 2024-06-04T10:00:00 | 2024-06-04T10:26:00 | 9.5 | 21.2 | electricity | blank | 7.7 | 1.3 | 137 | 3 | 56.1 | 94.7 | 2024-06 |
| FLEET017-DE | truck | 27.8 | DAF | HaulFast GmbH | V017-DE | XF 530 | 2020 | R017-DE | Munich-Leipzig | 48.1351 | 11.582 | 51.3397 | 12.3731 | T017-2024 | 2024-05-10T07:45:00 | 2024-05-10T13:25:00 | 420.6 | 63.8 | diesel | 102.1 | blank | 213.8 | 509 | 0 | 99.7 | 16.2 | 2024-Q2 |
| FLEET018-US | hybrid | 92.7 | Toyota | GreenRides NYC | V018-US | Camry Hybrid | 2023 | R018-US | Brooklyn-Queens | 40.6782 | -73.9442 | 40.7282 | -73.7949 | T018-2024 | 2024-06-16T18:00:00 | 2024-06-16T18:41:00 | 22.1 | 32.4 | hybrid | 0.9 | 6.9 | 1.7 | 77 | 4 | 79.8 | 89.9 | 2024-06 |
| FLEET019-KR | car | 80.1 | Hyundai | SeoulExpress | V019-KR | Elantra | 2019 | R019-KR | Gangnam Delivery | 37.5665 | 126.978 | 37.5172 | 127.0473 | T019-2024 | 2024-04-20T14:10:00 | 2024-04-20T14:49:00 | 10.2 | 15.7 | gasoline | 1.5 | blank | 3.2 | 314 | 3 | 45.2 | 99.8 | 2024-Q2 |
| FLEET020-AU | truck | 58.7 | Kenworth | MelbourneHaulage | V020-AU | T610 | 2016 | R020-AU | Port-Epping | -37.8136 | 144.9631 | -37.6519 | 145.019 | T020-2024 | 2024-04-29T03:55:00 | 2024-04-29T07:45:00 | 78.6 | 27.2 | diesel | 19.6 | blank | 41.2 | 524 | 0 | 96.4 | 67.6 | 2024-Q2 |
What the 120 rows show
from the 120-row sampleTruck (vehicle type) stands out: mean route_
- 87.3median route_
efficiency_ score - 4fuel types
- 12reporting periods
- 9.4median distance_
travelled_ km - 19.6median average_
speed_ kmh - 1.4median fuel_
consumed_ liters
Median 87.3, from 27.8 to 99.7.
- string 11
- integer 2
- float 13
- datetime 2
Columns
28 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
fleet_id | string | Unique identifier for the commercial fleet.unique | FLEET001-US |
operator_name | string | Name of the fleet operator or company. | UrbanEco Mobility |
vehicle_id | string | Unique identifier for each vehicle in the fleet.unique | V001-US |
vehicle_type | string | Type of vehicle (e.g., van, truck, electric, hybrid, diesel, gasoline).9 values | electric |
vehicle_make | string | Manufacturer of the vehicle.optional | Tesla |
vehicle_model | string | Model of the vehicle.optional | Model 3 |
route_id | string | Unique identifier for the route taken.unique | R001-US |
route_name | string | Descriptive name or code for the route.optional | Downtown Express |
trip_id | string | Unique identifier for each trip instance.unique | T001-2024 |
fuel_type | string | Type of fuel used for the trip (e.g., diesel, gasoline, electricity, hybrid).diesel · gasoline · electricity · hybrid · other | electricity |
reporting_period | string | Reporting period for ESG or sustainability analysis (e.g., '2024-Q1', '2024-06').12 periods · optional | 2024-06 |
| Numbers 15 columns | |||
vehicle_year | integer | Year the vehicle was manufactured.1,980 to 2,100 · optional | 2022 |
route_start_latitude | float | Latitude coordinate for the route starting point.-90 to 90 | 40.7128 |
route_start_longitude | float | Longitude coordinate for the route starting point.-180 to 180 | -74.006 |
route_end_latitude | float | Latitude coordinate for the route ending point.-90 to 90 | 40.7306 |
route_end_longitude | float | Longitude coordinate for the route ending point.-180 to 180 | -73.9866 |
distance_travelled_km | float | Total distance travelled during the trip in kilometers.0 or more | 13.2 |
average_speed_kmh | float | Average speed of the vehicle during the trip in kilometers per hour.0 or more · optional | 21.7 |
fuel_consumed_liters | float | Amount of fuel consumed during the trip in liters (or kWh for electric vehicles).0 or more · optional | 0.8 |
energy_consumed_kwh | float | Amount of energy consumed during the trip in kilowatt-hours (for electric or hybrid vehicles).0 or more · optional | 8.7 |
co2_emissions_kg | float | Total CO2 emissions produced during the trip, measured in kilograms.0 or more | 2.1 |
emissions_factor_gco2_per_km | float | Emission factor used for calculation, in grams of CO2 per kilometer.0 or more · optional | 122 |
occupancy | integer | Number of passengers or cargo units carried during the trip.0 or more · optional | 2 |
load_factor_percent | float | Percentage of vehicle capacity utilized during the trip.0 to 100 · optional | 39.2 |
route_efficiency_score | float | Calculated efficiency score for the route (e.g., based on distance, time, and emissions).0 to 100 · optional | 97.5 |
eco_driving_score | float | Score reflecting eco-friendly driving behavior during the trip.0 to 100 · optional | 94.8 |
| Dates and times 2 columns | |||
trip_start_datetime | datetime | Date and time when the trip started. | 2024-06-05T09:15:00 |
trip_end_datetime | datetime | Date and time when the trip ended. | 2024-06-05T09:47:00 |
Use it for
A transportation dashboard
Route_
efficiency_ score by vehicle_ type and a breakdown of vehicle_ make. Excel, Power BI or Tableau. Why do the 25 truck rows have a mean route_
efficiency_ score of 54.2? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Fleets120FLEET001-US97.5electricFLEET002-UK88.9hybridFLEET003-DE41.9truck
A software demo
Believable fleets with operator_
name, vehicle_ id and vehicle_ type to fill a screen in front of a buyer.
blueprint · fleet-emissions-optimization-dataset
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 28 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 unique fleet route per day
- Must include vehicle type and fuel used
- CO2 emissions calculated based on distance and fuel efficiency
- Energy-efficient routes flagged if emissions below set threshold
- Include IoT sensor status for real-time monitoring
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
- fleet-emissions-optimization-dataset