Vehicle Fleet Data

This dataset provides comprehensive, flat-structured information on fleet vehicles, including identification, maintenance records, fuel consumption, driver assignments, and utilization metrics. It enables detailed analysis of fleet operations, maintenance scheduling, driver management, and cost optimization for transportation and logistics professionals.

  • opened 14 times
  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Fleet maintenance scheduling and cost analysis

Sample rows

preview · 8 of 200 rows · all 23 columns
vehicle_idstringstatusstringutilization_ratefloatmakestringlicense_platestringmodelstringyearintegervehicle_typestringcurrent_mileagefloatfuel_typestringaverage_fuel_consumptionfloatlast_maintenance_datedatenext_maintenance_duedatemaintenance_type_laststringmaintenance_cost_lastfloatdriver_idstringdriver_namestringdriver_license_numberstringdriver_assignment_start_datedatedriver_assignment_end_datedatetotal_tripsintegertotal_distancefloatnotesstring
1HGCM82633A000101active77.6FordTXF-8921F-1502016truck72340.5gasoline16.42023-09-152024-03-15oil change89.95DRV001James PetersonTX93249122023-02-10blank56471230.7Truck used for regional deliveries.
JTDKB20U383028765active85.3ToyotaCAJ-7017Prius2019sedan48217.1hybrid48.32023-11-032024-05-03inspection120DRV002Ana MartinezCA82747112022-12-21blank79146391.8Assigned for urban commutes.
2FMDK3GC7BBA00022active67.9ChevroletNYH-3114Express2014van89312.2diesel14.82023-07-292024-01-28tire rotation135DRV003Robert ChenNY38492082023-06-15blank43988310.9Van used for supply runs.
3C6UR5FL9JG000413active92.1RamFLR-880525002021truck34812.6diesel15.52023-12-192024-06-19brake replacement340.25DRV004Alexis RiveraFL79423152023-12-20blank39734023.6High utilization in construction.
1FAFP40413F000505in_maintenance63.2FordILP-2934Fusion2017sedan61102.8gasoline24.92024-02-102024-03-10oil change90DRV005Melissa KingIL24981272023-08-01blank32061012.3Vehicle currently in scheduled maintenance.
WBA8E9G51GNU00216active74BMWNJH-1102320i2018sedan40211.9gasoline28.72023-09-172024-03-17inspection150DRV006Stephanie WuNJ89012342023-01-10blank52240102.6Corporate client transport.
5J6RM4H55GL012345active80.5HondaGAC-5792CR-V2015SUV67192.4gasoline23.62023-08-212024-02-21tire rotation110.75DRV007David MooreGA57329402023-04-02blank63667013.2Used for field operations.
2T1BURHE4GC000888retired18.4ToyotaTXD-3302Corolla2013sedan120102.1gasoline30.22023-05-11blankinspection95blankblankblankblankblank1131119890.4Vehicle retired in June 2023.

What the 200 rows show

from the 200-row sample

Retired status stands out: mean utilization_rate is 2.9, against 75.0 for the rest.

  • 73.8median utilization_rate
  • 4fuel types
  • 6vehicle types
  • 15maintenance type lasts
  • 52,349median current_mileage
  • 27.3median average_fuel_consumption
Mean utilization_rate by status200 rows
05010076.9active158 rows51.9in_maintenan…13 rows2.9retired29 rows
utilization_rate200 rows, in bands of 10
0306025403344158539050100utilization_rate →

Median 73.8, from 0.0 to 93.2.

make200 rows · top 10 of 24 values
  1. Ford34
  2. Chevrolet30
  3. Honda24
  4. Toyota22
  5. Acura19
  6. Nissan11
  7. Hyundai10
  8. Jeep8
  9. Ram5
  10. Tesla5
23 columns by typefrom the column list below
  • string 12
  • integer 2
  • float 5
  • date 4

Columns

23 columns in three groups
blueprint · 23 columns
columntypedescriptionexample
Text 12 columns
vehicle_idstringUnique identifier for each vehicle in the fleet (e.g., VIN or asset number)unique1HGCM82633A000101
license_platestringVehicle license plate numberuniqueTXF-8921
makestringManufacturer of the vehicle (e.g., Ford, Toyota)Ford
modelstringModel of the vehicle (e.g., F-150, Camry)F-150
vehicle_typestringType of vehicle (e.g., sedan, truck, van, SUV)6 valuestruck
statusstringCurrent status of the vehicle (e.g., active, in_maintenance, retired)active · in_maintenance · retiredactive
fuel_typestringType of fuel used by the vehicle (e.g., gasoline, diesel, electric, hybrid)gasoline · diesel · electric · hybrid · othergasoline
maintenance_type_laststringType of last maintenance performed (e.g., oil change, tire rotation, inspection)optionaloil change
driver_idstringUnique identifier for the currently assigned driveroptionalDRV001
driver_namestringFull name of the currently assigned driveroptionalJames Peterson
driver_license_numberstringLicense number of the assigned driveroptionalTX9324912
notesstringAdditional notes or comments about the vehicle or its usageoptionalUsed for site delivery.
Numbers 7 columns
yearintegerYear the vehicle was manufactured1,980 to 2,1002016
current_mileagefloatCurrent odometer reading in miles0 or more72340.5
average_fuel_consumptionfloatAverage fuel consumption in miles per gallon (MPG) or equivalent0 or more · optional16.4
maintenance_cost_lastfloatCost of the last maintenance event in USD0 or more · optional89.95
utilization_ratefloatPercentage of time the vehicle is actively used (0-100)0 to 100 · optional77.6
total_tripsintegerTotal number of trips made by the vehicle0 or more · optional564
total_distancefloatTotal distance traveled by the vehicle in miles0 or more · optional71230.7
Dates and times 4 columns
last_maintenance_datedateDate of the most recent maintenance performed on the vehicleoptional2023-09-15
next_maintenance_duedateScheduled date for the next maintenanceoptional2024-03-15
driver_assignment_start_datedateDate when the current driver was assigned to the vehicleoptional2023-02-10
driver_assignment_end_datedateDate when the current driver assignment ended (if applicable)optional2024-05-29

Use it for

  • median utiliza…73.8200 rowsmean utilization rate…76.9active51.9in_mai…2.9retired

    A transportation dashboard

    Utilization_rate by status and a breakdown of make. Excel, Power BI or Tableau.

  • Why do the 29 retired rows have a mean utilization_rate of 2.9?

    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 license_plate, make and model to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset200 rows23 columns
Yours10,000 rows23 columns

blueprint · vehicle-fleet-data

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 23 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
  • Vehicle ID and VIN unique identifiers
  • Current mileage increases over time
  • Maintenance due based on mileage or date
  • Driver assignment tracked per vehicle
  • Fuel efficiency calculated miles per gallon
Rows
Open the blueprint in Data Factory

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
vehicle-fleet-data

What should your data show?

Preview 20 rows free
No signup. No card.