Fleet Route Utilization Dataset

This dataset provides detailed records of fleet vehicle trips, including vehicle and driver information, route details, trip timings, load and fuel metrics, and utilization rates. It enables comprehensive analysis of fleet usage patterns, route coverage, and operational efficiency, supporting data-driven fleet optimization and strategic management.

  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Fleet utilization analysis and optimization

Sample rows

preview · 8 of 200 rows · all 20 columns
vehicle_idstringtrip_statusstringroute_coveragefloatvehicle_typestringroute_idstringroute_namestringroute_start_locationstringroute_end_locationstringroute_distance_kmfloattrip_idstringtrip_datedatetrip_start_timedatetimetrip_end_timedatetimedriver_idstringdriver_namestringvehicle_capacityfloatload_carried_kgfloatfuel_consumed_litersfloatutilization_ratefloatnotesstring
TRUCK-001completed100truckRTE-101East City Distribution RunCentral DepotEast City85.2TRIP-000012024-03-082024-03-08T07:21:002024-03-08T10:05:00DRV-001Gabriel Martinez1200011658.398.597.15Normal operation, no delays.
VAN-002completed100vanRTE-102Westside ExpressWest DepotWestside33.5TRIP-000022024-04-172024-04-17T12:32:002024-04-17T13:56:00DRV-002Jessica Liu950722.68.676.06Traffic heavy in city center.
CAR-003completed100carRTE-103Downtown ShuttleNorth GarageDowntown14.4TRIP-000032024-01-292024-01-29T09:09:002024-01-29T09:45:00DRV-003Amir Hassan450362.53.680.56Passenger shuttle. No incidents.
BUS-004completed100busRTE-104Morning School RouteSouth StationGreen Valley School26.8TRIP-000042024-03-122024-03-12T06:45:002024-03-12T08:20:00DRV-004Sandra O'Neill780028907.237.05Routine passenger transport.
TRUCK-005completed100truckRTE-105Northern Freight RouteCentral DepotNorth Point120.9TRIP-000052024-05-012024-05-01T05:40:002024-05-01T09:32:00DRV-005Javier Hernandez1650015995.5142.296.97Delivered ahead of schedule.
VAN-006completed100vanRTE-106Uptown Parcel DeliveryWarehouse 3Uptown9.8TRIP-000062024-02-172024-02-17T14:05:002024-02-17T15:01:00DRV-006Lina Kim1100875.42.379.58Parcels delivered successfully.
CAR-007completed100carRTE-107Airport TransferCity CenterInternational Airport37.2TRIP-000072024-04-242024-04-24T17:49:002024-04-24T18:50:00DRV-007Nina Petrov400314.86.978.7Airport transfer. No luggage lost.
BUS-008completed100busRTE-108Event ShuttleMain PlazaConvention Center18.6TRIP-000082024-03-222024-03-22T16:18:002024-03-22T17:30:00DRV-008David Choi800080006.8100Max passenger event.

What the 200 rows show

from the 200-row sample

Completed (trip status) stands out: mean route_coverage is 100.0, against 15.8 for the rest.

  • 100median route_coverage
  • 21.1median route_distance_km
  • 1,250median vehicle_capacity
  • 758.3median load_carried_kg
  • 3.9median fuel_consumed_liters
  • 77.0median utilization_rate
Mean route_coverage by trip_status200 rows
050100100.0completed181 rows31.3cancelled4 rows37.5in-progr…4 rows2.3scheduled11 rows
route_coverage200 rows, in bands of 10
0951901104004000181050100route_coverage →

Median 100, from 0 to 100.

vehicle_type200 rows · 6 values
  1. truck48
  2. van38
  3. car38
  4. bus38
  5. motorcycle27
  6. other11
20 columns by typefrom the column list below
  • string 11
  • float 6
  • date 1
  • datetime 2

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 11 columns
vehicle_idstringUnique identifier for each vehicle in the fleetuniqueTRUCK-001
vehicle_typestringType or category of the vehicle (e.g., truck, van, car)6 valuestruck
route_idstringUnique identifier for the route takenRTE-101
route_namestringDescriptive name of the routeWestside Express
route_start_locationstringStarting point of the route (city or depot name)Central Depot
route_end_locationstringEnding point of the route (city or depot name)East City
trip_idstringUnique identifier for each trip instanceuniqueTRIP-00001
driver_idstringUnique identifier for the driver assigned to the tripDRV-001
driver_namestringFull name of the driverGabriel Martinez
trip_statusstringStatus of the trip (e.g., completed, cancelled, in-progress)completed · cancelled · in-progress · scheduledcompleted
notesstringAdditional notes or comments about the tripoptionalMax passenger event.
Numbers 6 columns
route_distance_kmfloatTotal distance of the route in kilometers0 or more85.2
vehicle_capacityfloatMaximum load capacity of the vehicle in kilograms0 or more12000
load_carried_kgfloatActual load carried during the trip in kilograms0 or more11658.3
fuel_consumed_litersfloatTotal fuel consumed during the trip in liters0 or more98.5
utilization_ratefloatPercentage of vehicle capacity utilized during the trip (0-100)0 to 10097.15
route_coveragefloatPercentage of the planned route actually covered during the trip (0-100)0 to 100100
Dates and times 3 columns
trip_datedateDate when the trip was made2024-03-08
trip_start_timedatetimeTimestamp when the trip started2024-03-08T07:21:00
trip_end_timedatetimeTimestamp when the trip ended2024-03-08T10:05:00

Use it for

  • median route c…100200 rowsmean route coverage b…100.0comp…31.3canc…37.5in-p…2.3sche…

    A transportation dashboard

    Route_coverage by trip_status and a breakdown of vehicle_type. Excel, Power BI or Tableau.

  • Why do the 181 completed rows have a mean route_coverage of 100.0?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable vehicles with vehicle_type, route_id and route_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows20 columns
Yours1,000 rows20 columnsroute_start_location: UK only

blueprint · fleet-route-utilization-dataset

Behind this dataset

Same schema. As many rows as you need.

These 200 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.

Rules it was built with
  • Include vehicle ID and type
  • Record route frequency
  • Track fuel consumption per trip
  • Flag underutilized vehicles
Rows
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
fleet-route-utilization-dataset

More in Transportation

Browse all
Also in TransportationFleet Carbon Route Optimization MetricsSmart Traffic Light Sensor DataTransportation Demand Forecast DatasetAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.