Transportation Fleet Energy Consumption
This dataset provides detailed daily logs of energy and fuel consumption for diverse vehicle fleets, including distance traveled, CO2 emissions, and operational regions. It supports sustainability benchmarking, operational efficiency analysis, and fleet management optimization for organizations seeking to monitor and improve their transportation energy footprint.
Sample rows
preview · 8 of 200 rows · all 15 columns| log_idstring | vehicle_typestring | distance_travelled_kmfloat | fleet_idstring | fleet_namestring | vehicle_idstring | fuel_typestring | datedate | energy_consumed_kwhfloat | fuel_consumed_litersfloat | co2_emissions_kgfloat | operational_regionstring | driver_idstring | maintenance_flagboolean | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LOG0001 | truck | 845.3 | FLEET-A | Alpha Logistics | A-truck-01 | diesel | 2024-06-01 | blank | 320.6 | 920.4 | Midwest Corridor | DR-A101 | false | Long-haul delivery |
| LOG0002 | car | 52.5 | FLEET-B | Beta Transport | B-car-03 | electric | 2024-06-02 | 19.4 | blank | blank | San Francisco | DR-B301 | false | Airport pickup |
| LOG0003 | van | 212.1 | FLEET-C | Cargomax | C-van-04 | diesel | 2024-06-04 | blank | 87.3 | 245.1 | London | DR-C204 | false | Parcel delivery |
| LOG0004 | bus | 124.7 | FLEET-D | Delta Fleet | D-bus-01 | hybrid | 2024-06-02 | 22.5 | blank | 17.1 | Tokyo | DR-D501 | false | Low emission route |
| LOG0005 | car | 63.2 | FLEET-E | EcoMove | E-car-06 | hybrid | 2024-06-05 | 11.3 | blank | 9.4 | Berlin Center | DR-E306 | false | Short city ride |
| LOG0006 | motorcycle | 15.7 | FLEET-F | FleetOne | F-moto-03 | gasoline | 2024-06-01 | blank | 2.4 | 3.7 | Sydney | DR-F403 | false | Express delivery |
| LOG0007 | other | 6.2 | FLEET-G | Global Express | G-other-01 | hydrogen | 2024-06-03 | blank | 1.8 | 2.6 | Experimental Zone | DR-G901 | false | Hydrogen test run |
| LOG0008 | truck | 978.8 | FLEET-H | Highway Star | H-truck-02 | diesel | 2024-06-07 | blank | 389.7 | 1052.2 | Texas Highway | DR-H202 | false | Record mileage |
| LOG0009 | van | 74.9 | FLEET-I | Infinity Mobility | I-van-02 | electric | 2024-06-05 | 29.8 | blank | blank | Delhi | DR-I802 | false | Medical supplies |
| LOG0010 | bus | 312.5 | FLEET-J | JetStream | J-bus-03 | diesel | 2024-06-04 | blank | 132.1 | 412.8 | New York City | DR-J603 | false | Morning commute |
| LOG0011 | car | 91.3 | FLEET-K | Kappa Vehicles | K-car-01 | electric | 2024-06-06 | 36.4 | blank | blank | Brussels | DR-K101 | false | blank |
| LOG0012 | truck | 654.8 | FLEET-L | LogistiX | L-truck-04 | diesel | 2024-06-02 | blank | 249.4 | 708.3 | Ontario | DR-L204 | false | Cross-border shipment |
| LOG0013 | bus | 131.2 | FLEET-M | MetroFleet | M-bus-01 | electric | 2024-06-03 | 58.1 | blank | blank | Paris | DR-M501 | false | School transport |
| LOG0014 | truck | 302.9 | FLEET-N | Northern Haul | N-truck-03 | diesel | 2024-06-01 | blank | 110.2 | 334.7 | Manchester | DR-N303 | false | Food distribution |
| LOG0015 | motorcycle | 3.7 | FLEET-O | Omni Transit | O-moto-01 | electric | 2024-06-08 | 0.7 | blank | blank | Singapore | DR-O601 | false | New motorcycle test |
| LOG0016 | van | 79.4 | FLEET-P | Prime Movers | P-van-03 | gasoline | 2024-06-02 | blank | 14.2 | 29.9 | Madrid | DR-P203 | false | Intercity shuttle |
| LOG0017 | car | 41.6 | FLEET-Q | QuickTransit | Q-car-02 | hybrid | 2024-06-07 | 7.3 | blank | 5.2 | Rome | DR-Q802 | false | Short city ride |
| LOG0018 | bus | 305.1 | FLEET-R | RoadRunner | R-bus-02 | hybrid | 2024-06-08 | 41.5 | blank | 31.1 | Toronto | DR-R502 | false | Low emission route |
| LOG0019 | truck | 287.6 | FLEET-S | Speedy Ship | S-truck-02 | hydrogen | 2024-06-03 | blank | 72.9 | 136.7 | Berlin | DR-S202 | false | Hydrogen test run |
| LOG0020 | van | 191.4 | FLEET-T | TransitPro | T-van-01 | diesel | 2024-06-04 | blank | 73.2 | 202.3 | Vienna | DR-T101 | false | Cargo transfer |
What the 200 rows show
from the 200-row sampleTruck (vehicle type) stands out: mean distance_
- 110.0median distance_
travelled_ km - 6fuel types
- 46fleet names
- 18.1median energy_
consumed_ kwh - 96.3median fuel_
consumed_ liters - 136.7median co2_
emissions_ kg
Median 110.0, from 0.40 to 990.1.
- string 9
- float 4
- date 1
- boolean 1
Columns
15 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
log_id | string | Unique identifier for each daily energy consumption log entryunique | LOG0001 |
fleet_id | string | Unique identifier for the vehicle fleet | FLEET-A |
fleet_name | string | Name or label of the vehicle fleetoptional | Alpha Logistics |
vehicle_id | string | Unique identifier for the vehicle within the fleet | A-truck-01 |
vehicle_type | string | Type or category of the vehicle (e.g., truck, van, car, bus)6 values | truck |
fuel_type | string | Type of fuel or energy used by the vehicle (e.g., diesel, gasoline, electric, hybrid)6 values | diesel |
operational_region | string | Geographic region or area where the vehicle operated on the given dateoptional | Midwest Corridor |
driver_id | string | Unique identifier for the driver assigned to the vehicle on the given dateoptional | DR-A101 |
notes | string | Additional notes or comments about the log entryoptional | Long-haul delivery |
| Numbers 4 columns | |||
distance_travelled_km | float | Total distance travelled by the vehicle on the given date, in kilometers0 or more | 845.3 |
energy_consumed_kwh | float | Total energy consumed by the vehicle on the given date, in kilowatt-hours (for electric/hybrid vehicles)0 or more · optional | 19.4 |
fuel_consumed_liters | float | Total fuel consumed by the vehicle on the given date, in liters (for combustion vehicles)0 or more · optional | 320.6 |
co2_emissions_kg | float | Estimated CO2 emissions produced by the vehicle on the given date, in kilograms0 or more · optional | 920.4 |
| Dates and times 1 column | |||
date | date | Date of the energy consumption log entry | 2024-06-01 |
| True or false 1 column | |||
maintenance_flag | boolean | Indicates whether the vehicle underwent maintenance on the given dateoptional | false |
Use it for
A transportation dashboard
Distance_
travelled_ km by vehicle_ type and a breakdown of fleet_ id. Excel, Power BI or Tableau. Why do the 48 truck rows have a mean distance_
travelled_ km of 597.0? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs200LOG0001845.3truckLOG000252.5carLOG0003212.1van
A software demo
Believable logs with fleet_
id, fleet_ name and vehicle_ id to fill a screen in front of a buyer.
This dataset200 rows15 columns
Yours1,000 rows15 columnsoperational_region: UK only
blueprint · transportation-fleet-energy-consumption
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 15 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
- Record per vehicle type
- Include fuel/energy source
- Flag peak consumption periods
- Track maintenance scheduling
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
- transportation-fleet-energy-consumption