Rural Fleet Energy Benchmarking
This dataset provides granular energy consumption and carbon emission data for rural logistics fleets, including vehicle, route, and improvement action details. It enables transportation and sustainability professionals to benchmark fleet performance, identify opportunities for energy and carbon savings, and track the impact of efficiency initiatives across vehicles and routes.
Sample rows
preview · 8 of 120 rows · all 26 columns| fleet_idstring | vehicle_typestring | energy_consumed_kwhfloat | vehicle_makestring | fleet_namestring | operator_namestring | vehicle_idstring | vehicle_modelstring | year_of_manufactureinteger | fuel_typestring | route_idstring | route_namestring | route_distance_kmfloat | route_frequency_per_weekinteger | fuel_consumed_litersfloat | carbon_emissions_kgfloat | date_of_measurementdate | improvement_action_takenstring | improvement_action_datedate | energy_savings_kwhfloat | carbon_savings_kgfloat | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | location_countrystring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FLT-001 | truck | 0 | MAN | Northmoor Logistics | Rural Transport Ltd | VEH-001 | TGX | 2008 | diesel | RTE-001 | Moorview to Brambleton | 245.6 | 2 | 81.2 | 176.4 | 2024-04-16 | blank | blank | blank | blank | blank | Northmoor | Devon | EX19 7JL | UK |
| FLT-002 | van | 0 | Ford | Fenland Couriers | East Rural Express | VEH-002 | Transit | 2016 | diesel | RTE-002 | Fenland Circular | 24.1 | 7 | 8.9 | 21.2 | 2024-03-29 | blank | blank | blank | blank | 12 Willow Lane | March | Cambridgeshire | PE15 8QP | UK |
| FLT-003 | truck | 0 | DAF | Borderland Freight | Borderland Logistics | VEH-003 | CF | 2012 | diesel | RTE-003 | Berwick to Tweed Route | 188.7 | 2 | 74.3 | 151.8 | 2024-02-25 | Switched to biodiesel blend | 2024-02-10 | 0 | 7.7 | blank | Berwick-upon-Tweed | Northumberland | TD15 1UB | UK |
| FLT-004 | van | 0 | Vauxhall | Cotswold Fleet | Cotswold Distribution | VEH-004 | Vivaro | 2019 | diesel | RTE-004 | Stow to Moreton | 18.4 | 8 | 7.3 | 16.2 | 2024-03-20 | blank | blank | blank | blank | 7 Sheep Street | Stow-on-the-Wold | Gloucestershire | GL54 1AB | UK |
| FLT-005 | truck | 0 | Scania | Peak Valley Haulage | Peak Valley Services | VEH-005 | R440 | 2002 | diesel | RTE-005 | Bakewell to Buxton | 115.3 | 3 | 63.5 | 128.7 | 2024-04-03 | blank | blank | blank | blank | blank | Bakewell | Derbyshire | DE45 1AW | UK |
| FLT-006 | van | 0 | Renault | Vale Express | Vale Transport Ltd | VEH-006 | Trafic | 2015 | diesel | RTE-006 | Vale Circuit | 12.9 | 10 | 6.3 | 13.8 | 2024-05-02 | blank | blank | blank | blank | 2 Ash Close | Evesham | Worcestershire | WR11 3BQ | UK |
| FLT-007 | van | 0 | Peugeot | Welsh Borderline | Borderline Logistics | VEH-007 | Expert | 2023 | petrol | RTE-007 | Wrexham Local | 21.7 | 6 | 9.6 | 17.3 | 2024-04-12 | blank | blank | blank | blank | 9 High Street | Wrexham | Clwyd | LL11 1AP | UK |
| FLT-008 | truck | 0 | Mercedes | South Downs Fleet | Downs Logistics | VEH-008 | Actros | 2011 | diesel | RTE-008 | Lewes to Midhurst | 160.3 | 1 | 61.4 | 127.6 | 2024-05-07 | blank | blank | blank | blank | blank | Lewes | East Sussex | BN7 2FB | UK |
| FLT-009 | truck | 0 | Iveco | Lake Country Freight | Lake Country Haulage | VEH-009 | Stralis | 2001 | diesel | RTE-009 | Windermere to Penrith | 72.5 | 1 | 55.6 | 112.4 | 2024-03-15 | blank | blank | blank | blank | blank | Windermere | Cumbria | LA23 1AA | UK |
| FLT-010 | van | 0 | Volkswagen | Norfolk Runners | Norfolk Logistics | VEH-010 | Crafter | 2014 | diesel | RTE-010 | Norwich to Cromer | 42.8 | 9 | 11.2 | 24.7 | 2024-03-27 | blank | blank | blank | blank | 10 Market Street | Norwich | Norfolk | NR1 3HU | UK |
| FLT-011 | truck | 0 | Volvo | Wessex Logistics | Wessex Transport | VEH-011 | FH | 2010 | diesel | RTE-011 | Yeovil to Salisbury | 102.7 | 2 | 53.8 | 109.2 | 2024-04-10 | Implemented eco-driving training | 2024-03-18 | 0 | 3.8 | 22 Roman Road | Yeovil | Somerset | BA21 3AW | UK |
| FLT-012 | truck | 0 | Renault | Fife Rural Haulage | Fife Transport Co | VEH-012 | Range T | 2003 | diesel | RTE-012 | Kirkcaldy to St Andrews | 82.9 | 2 | 58.1 | 117.5 | 2024-02-18 | blank | blank | blank | blank | blank | Kirkcaldy | Fife | KY1 1PL | UK |
| FLT-013 | van | 0 | Fiat | Thames Rural Express | Thames Rural Carriers | VEH-013 | Ducato | 2021 | petrol | RTE-013 | Windsor to Maidenhead | 39.3 | 6 | 12.1 | 23.6 | 2024-05-05 | blank | blank | blank | blank | 4 Mill Lane | Windsor | Berkshire | SL4 1RH | UK |
| FLT-014 | truck | 0 | DAF | Yorkshire Dales Fleet | Dales Distribution | VEH-014 | LF | 2009 | diesel | RTE-014 | Skipton to Hawes | 130.4 | 1 | 67.5 | 134.9 | 2024-04-24 | blank | blank | blank | blank | blank | Skipton | North Yorkshire | BD23 2QR | UK |
| FLT-015 | truck | 0 | MAN | Pennine Rural | Pennine Transport | VEH-015 | TGS | 2013 | diesel | RTE-015 | Huddersfield to Todmorden | 97.2 | 3 | 49.7 | 104.2 | 2024-03-08 | blank | blank | blank | blank | 17 Market Place | Huddersfield | West Yorkshire | HD1 2QF | UK |
| FLT-016 | van | 0 | Citroen | Cornwall Carriers | Cornwall Rural Ltd | VEH-016 | Dispatch | 2017 | diesel | RTE-016 | Truro to Falmouth | 31.6 | 8 | 10.4 | 15.7 | 2024-02-22 | blank | blank | blank | blank | 5 Lemon Street | Truro | Cornwall | TR1 2QB | UK |
| FLT-017 | van | 0 | Mercedes | Mendip Fleet | Mendip Logistics | VEH-017 | Vito | 2018 | diesel | RTE-017 | Wells to Glastonbury | 13.7 | 12 | 4.5 | 7.2 | 2024-05-10 | blank | blank | blank | blank | blank | Wells | Somerset | BA5 2UU | UK |
| FLT-018 | van | 0 | Toyota | Rural Connect | Rural Connect Ltd | VEH-018 | Proace | 2015 | diesel | RTE-018 | Market Rasen Local | 9.2 | 7 | 3.2 | 5.9 | 2024-02-27 | blank | blank | blank | blank | blank | Market Rasen | Lincolnshire | LN8 3HL | UK |
| FLT-019 | van | 0 | Fiat | Wiltshire Rural | Wiltshire Logistics | VEH-019 | Scudo | 2022 | petrol | RTE-019 | Swindon to Marlborough | 19.4 | 7 | 7.2 | 13.9 | 2024-03-19 | blank | blank | blank | blank | 14 High Street | Swindon | Wiltshire | SN1 1AA | UK |
| FLT-020 | truck | 0 | Scania | Highland Carriers | Highland Transport | VEH-020 | R500 | 2006 | diesel | RTE-020 | Inverness to Wick | 223.3 | 2 | 97.1 | 201.2 | 2024-04-21 | blank | blank | blank | blank | blank | Inverness | Highland | IV2 3HZ | UK |
What the 120 rows show
from the 120-row sampleElectric van (vehicle type) stands out: mean energy_
- 0.0median energy_
consumed_ kwh - 5fuel types
- 32.6median route_
distance_ km - 3median route_
frequency_ per_ week - 8.8median fuel_
consumed_ liters - 17.6median carbon_
emissions_ kg
Median 0.0, from 0.0 to 39.1.
- string 16
- integer 2
- float 6
- date 2
Columns
26 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 16 columns | |||
fleet_id | string | Unique identifier for each rural logistics fleet.unique | FLT-001 |
fleet_name | string | Name of the rural logistics fleet. | Northmoor Logistics |
operator_name | string | Name of the company or organization operating the fleet. | Rural Transport Ltd |
vehicle_id | string | Unique identifier for each vehicle in the fleet.unique | VEH-001 |
vehicle_type | string | Type of vehicle (e.g., van, truck, electric van, hybrid truck).van · truck · electric van · hybrid truck · other | truck |
vehicle_make | string | Manufacturer of the vehicle.optional | MAN |
vehicle_model | string | Model of the vehicle.optional | TGX |
fuel_type | string | Type of fuel used by the vehicle (e.g., diesel, petrol, electric, hybrid).diesel · petrol · electric · hybrid · other | diesel |
route_id | string | Unique identifier for each route serviced by the fleet.unique | RTE-001 |
route_name | string | Name or description of the route. | Moorview to Brambleton |
improvement_action_taken | string | Description of any energy efficiency or carbon reduction action taken for the vehicle or route.optional | Battery optimization |
location_street_address | string | Street address of the fleet's base or depot.optional | 12 Willow Lane |
location_city | string | City where the fleet's base or depot is located.optional | Northmoor |
location_state | string | State or region of the fleet's base or depot.optional | Devon |
location_postal_code | string | Postal code of the fleet's base or depot.optional | EX19 7JL |
location_country | string | Country where the fleet's base or depot is located.optional | UK |
| Numbers 8 columns | |||
year_of_manufacture | integer | Year the vehicle was manufactured.1,980 to 2,024 · optional | 2008 |
route_distance_km | float | Total distance of the route in kilometers.0 or more | 245.6 |
route_frequency_per_week | integer | Number of times the route is serviced per week.0 or more | 2 |
energy_consumed_kwh | float | Total energy consumed by the vehicle on the route, measured in kilowatt-hours (kWh).0 or more | 0 |
fuel_consumed_liters | float | Total fuel consumed by the vehicle on the route, measured in liters.0 or more · optional | 81.2 |
carbon_emissions_kg | float | Total carbon emissions produced by the vehicle on the route, measured in kilograms.0 or more | 176.4 |
energy_savings_kwh | float | Amount of energy saved due to improvement actions, measured in kilowatt-hours.0 or more · optional | 0 |
carbon_savings_kg | float | Amount of carbon emissions reduced due to improvement actions, measured in kilograms.0 or more · optional | 7.7 |
| Dates and times 2 columns | |||
date_of_measurement | date | Date when the energy and emissions data were recorded. | 2024-04-16 |
improvement_action_date | date | Date when the improvement action was implemented.optional | 2024-02-10 |
Use it for
A transportation dashboard
Energy_
consumed_ kwh by vehicle_ type and a breakdown of vehicle_ make. Excel, Power BI or Tableau. Why do the 13 electric van rows have a mean energy_
consumed_ kwh of 28.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Fleets120FLT-0010truckFLT-0020vanFLT-0030truck
A software demo
Believable fleets with fleet_
name, operator_ name and vehicle_ id to fill a screen in front of a buyer.
blueprint · rural-fleet-energy-benchmarking
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 26 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 vehicle and daily route.
- Energy consumption measured in kWh or liters per route.
- Carbon emissions calculations follow GHG protocol standards.
- Fleet type (EV, hybrid, diesel) is coded and validated.
- Seasonal and weather impact factors included per route.
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
- rural-fleet-energy-benchmarking