Fleet Energy Consumption Monitoring
This dataset provides granular, sensor-based daily energy consumption records for vehicle fleets, including detailed vehicle attributes, route information, and emissions estimates. It is designed for transportation managers and ESG analysts to monitor, analyze, and optimize fleet energy usage, supporting sustainability reporting, regulatory compliance, and operational cost reduction.
Sample rows
preview · 8 of 115 rows · all 20 columns| record_idstring | vehicle_typestring | co2_emissions_kgfloat | fuel_typestring | vehicle_idstring | vehicle_makestring | vehicle_modelstring | vehicle_yearinteger | route_idstring | route_namestring | route_start_locationstring | route_end_locationstring | route_distance_kmfloat | datedate | energy_consumed_kwhfloat | fuel_consumed_litersfloat | number_of_stopsinteger | average_speed_kphfloat | driver_idstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REC0001 | truck | 1065.2 | diesel | VH1001 | Freightliner | Cascadia | 2018 | RTE1001 | Dallas to Houston Express | Dallas | Houston | 386.2 | 2023-07-01 | 1620.5 | 401.3 | 4 | 74.8 | DRV2001 | Long-haul, overnight delivery |
| REC0002 | bus | 0 | electric | VH1002 | BYD | K9 | 2022 | RTE1002 | Downtown Loop Shuttle | San Francisco | San Francisco | 18.7 | 2023-07-02 | 29.4 | blank | 16 | 21.3 | DRV2002 | Urban shuttle, high frequency |
| REC0003 | van | 19.8 | diesel | VH1003 | Mercedes | Sprinter | 2019 | RTE1003 | Airport Cargo Run | Atlanta | Hartsfield Airport | 29.6 | 2023-07-03 | 34.1 | 8.7 | 5 | 54.2 | DRV2003 | Airport traffic, moderate regen |
| REC0004 | car | 5.3 | gasoline | VH1004 | Toyota | Corolla | 2015 | RTE1004 | Morning Commuter Route | Berkeley | Oakland | 13.5 | 2023-07-04 | 11.2 | 2.1 | 2 | 32.1 | blank | Short trip |
| REC0005 | truck | 1180.9 | diesel | VH1005 | Volvo | VNL | 2020 | RTE1005 | Interstate Cargo Run | Chicago | St Louis | 480.5 | 2023-07-05 | 1852.4 | 459.7 | 3 | 82.9 | DRV2004 | No delays, efficient |
| REC0006 | van | 0 | electric | VH1006 | Ford | Transit | 2021 | RTE1006 | Suburban Delivery Circuit | Plano | Frisco | 16.9 | 2023-07-06 | 19.5 | blank | 8 | 33.2 | blank | blank |
| REC0007 | bus | 0 | electric | VH1007 | Proterra | Catalyst | 2025 | RTE1007 | Downtown Circular | Seattle | Seattle | 22.3 | 2023-07-07 | 36.8 | blank | 13 | 18.7 | DRV2005 | Loop route |
| REC0008 | car | 0 | electric | VH1008 | Tesla | Model 3 | 2023 | RTE1008 | Suburban EV Commute | Sunnyvale | Mountain View | 18.2 | 2023-07-08 | 15.9 | blank | 3 | 37.5 | blank | EV commuter |
| REC0009 | van | 18.5 | gasoline | VH1009 | Chevrolet | Express | 2017 | RTE1009 | Warehouse Route North | Denver | Boulder | 52.6 | 2023-07-09 | 24.7 | 10.1 | 6 | 55.6 | blank | High regen |
| REC0010 | truck | 990.7 | diesel | VH1010 | Kenworth | T680 | 2016 | RTE1010 | Midwest Distribution | Indianapolis | Detroit | 395.7 | 2023-07-10 | 1542.8 | 375.4 | 3 | 72.3 | DRV2006 | No issues |
| REC0011 | car | 3.8 | gasoline | VH1011 | Honda | Civic | 2013 | RTE1011 | Uptown Commute | Minneapolis | St Paul | 10.3 | 2023-07-11 | 9.6 | 1.7 | 2 | 26.8 | blank | blank |
| REC0012 | bus | 2.6 | hybrid | VH1012 | Gillig | Low Floor | 2028 | RTE1012 | University Shuttle West | Stanford | Palo Alto | 8.7 | 2028-01-05 | 18.2 | 2.3 | 11 | 23 | DRV2007 | Experimental hybrid |
| REC0013 | van | 8.1 | diesel | VH1013 | Ram | ProMaster | 2016 | RTE1013 | Urban Parcel Drop | Brooklyn | Manhattan | 14.8 | 2023-07-12 | 16 | 3.9 | 7 | 31.2 | blank | blank |
| REC0014 | truck | 1242.8 | diesel | VH1014 | Peterbilt | 579 | 2023 | RTE1014 | West Coast Haul | San Diego | Sacramento | 849.4 | 2023-07-13 | 4322.1 | 473.2 | 6 | 89.5 | DRV2008 | Long-haul, performance test |
| REC0015 | car | 0 | electric | VH1015 | Chevrolet | Bolt | 2022 | RTE1015 | EV Suburb Express | Redmond | Bellevue | 26.7 | 2023-07-14 | 21.1 | blank | 2 | 41.8 | DRV2009 | blank |
| REC0016 | van | 0 | electric | VH1016 | Nissan | NV200 | 2018 | RTE1016 | Eastside Package Loop | Queens | Queens | 10.5 | 2023-07-15 | 13.9 | blank | 5 | 21.6 | blank | Loop route |
| REC0017 | bus | 0 | electric | VH1017 | Novabus | LFSe+ | 2021 | RTE1017 | City Center Route | Austin | Austin | 39.8 | 2023-07-16 | 58.1 | blank | 18 | 27.4 | DRV2010 | blank |
| REC0018 | truck | 832.7 | diesel | VH1018 | Mack | Anthem | 2012 | RTE1018 | Northern Freight | Fargo | Minot | 346.7 | 2023-07-17 | 1587.2 | 312.5 | 5 | 62.1 | DRV2011 | No delays |
| REC0019 | car | 1.2 | hybrid | VH1019 | Hyundai | Ioniq Hybrid | 2024 | RTE1019 | Downtown Hybrid Test | Columbus | Columbus | 7.2 | 2024-01-12 | 8.4 | 0.7 | 2 | 34.9 | DRV2012 | Performance test |
| REC0020 | van | 11 | diesel | VH1020 | Volkswagen | Transporter | 2015 | RTE1020 | Suburban Goods Delivery | Philadelphia | Cherry Hill | 21.1 | 2023-07-18 | 21.9 | 5.6 | 4 | 29.7 | blank | blank |
What the 115 rows show
from the 115-row sampleTruck (vehicle type) stands out: mean co2_
- 3.5median co2_
emissions_ kg - 22.3median route_
distance_ km - 21.7median energy_
consumed_ kwh - 7.3median fuel_
consumed_ liters - 5median number_
of_ stops - 37.5median average_
speed_ kph
Median 3.5, from 0.0 to 1,298.
- string 12
- integer 2
- float 5
- date 1
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
record_id | string | Unique identifier for each energy consumption recordunique | REC0001 |
vehicle_id | string | Unique identifier for the vehicle | VH1001 |
vehicle_type | string | Type or classification of the vehicle (e.g., truck, van, car, bus)4 types | truck |
vehicle_make | string | Manufacturer of the vehicleoptional | Freightliner |
vehicle_model | string | Model of the vehicleoptional | Cascadia |
fuel_type | string | Type of fuel or energy source used (e.g., diesel, gasoline, electric, hybrid)diesel · gasoline · electric · hybrid · other | diesel |
route_id | string | Unique identifier for the route taken | RTE1001 |
route_name | string | Descriptive name of the routeoptional | Downtown Loop Shuttle |
route_start_location | string | Starting location of the routeoptional | Dallas |
route_end_location | string | Ending location of the routeoptional | Houston |
driver_id | string | Unique identifier for the driver (if available)optional | DRV2001 |
notes | string | Additional notes or comments regarding the trip or energy consumptionoptional | Short trip |
| Numbers 7 columns | |||
vehicle_year | integer | Year the vehicle was manufactured1,980 to 2,100 · optional | 2018 |
route_distance_km | float | Total distance of the route in kilometers0 or more · optional | 386.2 |
energy_consumed_kwh | float | Total energy consumed by the vehicle on this date in kilowatt-hours (kWh) or equivalent0 or more | 1620.5 |
fuel_consumed_liters | float | Total fuel consumed by the vehicle on this date in liters (if applicable)0 or more · optional | 401.3 |
co2_emissions_kg | float | Estimated CO2 emissions in kilograms for the trip (if available/calculated)0 or more · optional | 1065.2 |
number_of_stops | integer | Number of stops made during the route0 or more · optional | 4 |
average_speed_kph | float | Average speed of the vehicle during the route in kilometers per hour0 or more · optional | 74.8 |
| Dates and times 1 column | |||
date | date | Date of energy consumption record | 2023-07-01 |
Use it for
A transportation dashboard
Co2_
emissions_ kg by vehicle_ type and a breakdown of fuel_ type. Excel, Power BI or Tableau. Why do the 32 truck rows have a mean co2_
emissions_ kg of 862.7? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Records115REC00011065.2truckREC00020busREC000319.8van
A software demo
Believable records with vehicle_
id, vehicle_ type and vehicle_ make to fill a screen in front of a buyer.
blueprint · fleet-energy-consumption-monitoring
Behind this dataset
Same schema. As many rows as you need.
These 115 rows came out of a blueprint — 20 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 one vehicle’s energy consumption for a single day.
- Energy usage (in kWh) is captured via IoT sensor readings.
- Route details include distance (km) and urban/rural classification.
- Vehicle type and fuel source (electric, hybrid, diesel) are specified.
- Maintenance events are flagged if they occur on that day.
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
- fleet-energy-consumption-monitoring