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.
Sample rows
preview · 8 of 200 rows · all 23 columns| vehicle_idstring | statusstring | utilization_ratefloat | makestring | license_platestring | modelstring | yearinteger | vehicle_typestring | current_mileagefloat | fuel_typestring | average_fuel_consumptionfloat | last_maintenance_datedate | next_maintenance_duedate | maintenance_type_laststring | maintenance_cost_lastfloat | driver_idstring | driver_namestring | driver_license_numberstring | driver_assignment_start_datedate | driver_assignment_end_datedate | total_tripsinteger | total_distancefloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1HGCM82633A000101 | active | 77.6 | Ford | TXF-8921 | F-150 | 2016 | truck | 72340.5 | gasoline | 16.4 | 2023-09-15 | 2024-03-15 | oil change | 89.95 | DRV001 | James Peterson | TX9324912 | 2023-02-10 | blank | 564 | 71230.7 | Truck used for regional deliveries. |
| JTDKB20U383028765 | active | 85.3 | Toyota | CAJ-7017 | Prius | 2019 | sedan | 48217.1 | hybrid | 48.3 | 2023-11-03 | 2024-05-03 | inspection | 120 | DRV002 | Ana Martinez | CA8274711 | 2022-12-21 | blank | 791 | 46391.8 | Assigned for urban commutes. |
| 2FMDK3GC7BBA00022 | active | 67.9 | Chevrolet | NYH-3114 | Express | 2014 | van | 89312.2 | diesel | 14.8 | 2023-07-29 | 2024-01-28 | tire rotation | 135 | DRV003 | Robert Chen | NY3849208 | 2023-06-15 | blank | 439 | 88310.9 | Van used for supply runs. |
| 3C6UR5FL9JG000413 | active | 92.1 | Ram | FLR-8805 | 2500 | 2021 | truck | 34812.6 | diesel | 15.5 | 2023-12-19 | 2024-06-19 | brake replacement | 340.25 | DRV004 | Alexis Rivera | FL7942315 | 2023-12-20 | blank | 397 | 34023.6 | High utilization in construction. |
| 1FAFP40413F000505 | in_maintenance | 63.2 | Ford | ILP-2934 | Fusion | 2017 | sedan | 61102.8 | gasoline | 24.9 | 2024-02-10 | 2024-03-10 | oil change | 90 | DRV005 | Melissa King | IL2498127 | 2023-08-01 | blank | 320 | 61012.3 | Vehicle currently in scheduled maintenance. |
| WBA8E9G51GNU00216 | active | 74 | BMW | NJH-1102 | 320i | 2018 | sedan | 40211.9 | gasoline | 28.7 | 2023-09-17 | 2024-03-17 | inspection | 150 | DRV006 | Stephanie Wu | NJ8901234 | 2023-01-10 | blank | 522 | 40102.6 | Corporate client transport. |
| 5J6RM4H55GL012345 | active | 80.5 | Honda | GAC-5792 | CR-V | 2015 | SUV | 67192.4 | gasoline | 23.6 | 2023-08-21 | 2024-02-21 | tire rotation | 110.75 | DRV007 | David Moore | GA5732940 | 2023-04-02 | blank | 636 | 67013.2 | Used for field operations. |
| 2T1BURHE4GC000888 | retired | 18.4 | Toyota | TXD-3302 | Corolla | 2013 | sedan | 120102.1 | gasoline | 30.2 | 2023-05-11 | blank | inspection | 95 | blank | blank | blank | blank | blank | 1131 | 119890.4 | Vehicle retired in June 2023. |
| JH4KA9650MC002134 | retired | 10.1 | Acura | OHB-4417 | TL | 2012 | sedan | 131900.6 | gasoline | 26.8 | 2022-11-30 | blank | oil change | 75 | blank | blank | blank | blank | blank | 1042 | 131750.8 | Retired after engine failure. |
| 1FTFW1EF5EKE00009 | active | 83.2 | Ford | OKT-9283 | F-250 | 2020 | truck | 25892.7 | diesel | 14.6 | 2023-10-04 | 2024-04-04 | inspection | 155 | DRV008 | Brian Lee | OK9028121 | 2023-06-21 | blank | 233 | 25821.3 | Used for site delivery. |
| 1C4RJFBG0LC000312 | active | 75.8 | Jeep | COV-3217 | Grand Cherokee | 2016 | SUV | 65322.9 | gasoline | 22.3 | 2023-08-10 | 2024-02-10 | brake replacement | 325 | DRV009 | Patricia Simmons | CO7812109 | 2022-10-16 | blank | 680 | 65200.1 | Assigned for mountain travel. |
| 5YJSA1CN5DFP00022 | active | 68.5 | Tesla | CAL-0092 | Model S | 2022 | sedan | 10394.3 | electric | 108.2 | 2023-12-08 | 2024-06-08 | inspection | 75 | DRV010 | Miguel Hernandez | CA7019234 | 2023-04-01 | blank | 94 | 10294.1 | EV fleet pilot vehicle. |
| 2HKRM4H52FH000321 | active | 84.3 | Honda | FLY-3126 | Pilot | 2015 | SUV | 75214.8 | gasoline | 21.7 | 2023-07-18 | 2024-01-18 | tire rotation | 115 | DRV011 | Nicole Evans | FL2381940 | 2023-05-10 | blank | 730 | 75120 | Used for team travel. |
| 1GNDT13S342000204 | retired | 5.3 | Chevrolet | WAC-6821 | Trailblazer | 2014 | SUV | 140113.9 | gasoline | 20.1 | 2022-12-21 | blank | inspection | 105 | blank | blank | blank | blank | blank | 1292 | 139890.6 | Decommissioned in 2023. |
| 1GNSKJKC0FR000156 | active | 69.2 | Chevrolet | MIB-9282 | Suburban | 2018 | SUV | 51123.5 | gasoline | 19.8 | 2023-09-23 | 2024-03-23 | oil change | 95 | DRV012 | Matthew Allen | MI8921348 | 2023-02-11 | blank | 479 | 51092.6 | Used for large group transport. |
| 1FTNE24L1YHB00031 | active | 76.1 | Ford | TXV-1083 | Transit | 2017 | van | 59421.4 | gasoline | 20 | 2023-10-30 | 2024-04-30 | tire rotation | 120 | DRV013 | Emily Foster | TX9843121 | 2023-09-03 | blank | 518 | 59298.6 | Used for event logistics. |
| JHMCM56557C002102 | retired | 12.3 | Honda | AZT-2109 | Accord | 2013 | sedan | 112190.2 | gasoline | 29.4 | 2020-09-22 | blank | brake replacement | 210 | blank | blank | blank | blank | blank | 1002 | 111950 | Retired due to age. |
| WVGRF7AX5DW000011 | active | 90.3 | Volkswagen | FLM-2132 | Atlas | 2020 | SUV | 23210.7 | gasoline | 23.3 | 2023-12-01 | 2024-06-01 | inspection | 145 | DRV014 | Jackson Price | FL7284139 | 2023-11-15 | blank | 139 | 23090.3 | New addition to the fleet. |
| 1G1ZF575X8F000512 | active | 72.5 | Chevrolet | PAA-8123 | Malibu | 2016 | sedan | 50312 | gasoline | 28.2 | 2023-10-13 | 2024-04-13 | oil change | 80 | DRV015 | Lauren Carter | PA3498124 | 2023-02-19 | blank | 540 | 50290.7 | Assigned to sales team. |
| JTHBK1EG1F2000911 | active | 69.6 | Lexus | ILM-9237 | ES 350 | 2020 | sedan | 20123.4 | gasoline | 28.6 | 2023-11-24 | 2024-05-24 | inspection | 155 | DRV016 | Sandra Ross | IL9834211 | 2023-06-15 | blank | 154 | 20090.1 | Executive transport. |
What the 200 rows show
from the 200-row sampleRetired status stands out: mean utilization_
- 73.8median utilization_
rate - 4fuel types
- 6vehicle types
- 15maintenance type lasts
- 52,349median current_
mileage - 27.3median average_
fuel_ consumption
Median 73.8, from 0.0 to 93.2.
- string 12
- integer 2
- float 5
- date 4
Columns
23 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
vehicle_id | string | Unique identifier for each vehicle in the fleet (e.g., VIN or asset number)unique | 1HGCM82633A000101 |
license_plate | string | Vehicle license plate numberunique | TXF-8921 |
make | string | Manufacturer of the vehicle (e.g., Ford, Toyota) | Ford |
model | string | Model of the vehicle (e.g., F-150, Camry) | F-150 |
vehicle_type | string | Type of vehicle (e.g., sedan, truck, van, SUV)6 values | truck |
status | string | Current status of the vehicle (e.g., active, in_maintenance, retired)active · in_maintenance · retired | active |
fuel_type | string | Type of fuel used by the vehicle (e.g., gasoline, diesel, electric, hybrid)gasoline · diesel · electric · hybrid · other | gasoline |
maintenance_type_last | string | Type of last maintenance performed (e.g., oil change, tire rotation, inspection)optional | oil change |
driver_id | string | Unique identifier for the currently assigned driveroptional | DRV001 |
driver_name | string | Full name of the currently assigned driveroptional | James Peterson |
driver_license_number | string | License number of the assigned driveroptional | TX9324912 |
notes | string | Additional notes or comments about the vehicle or its usageoptional | Used for site delivery. |
| Numbers 7 columns | |||
year | integer | Year the vehicle was manufactured1,980 to 2,100 | 2016 |
current_mileage | float | Current odometer reading in miles0 or more | 72340.5 |
average_fuel_consumption | float | Average fuel consumption in miles per gallon (MPG) or equivalent0 or more · optional | 16.4 |
maintenance_cost_last | float | Cost of the last maintenance event in USD0 or more · optional | 89.95 |
utilization_rate | float | Percentage of time the vehicle is actively used (0-100)0 to 100 · optional | 77.6 |
total_trips | integer | Total number of trips made by the vehicle0 or more · optional | 564 |
total_distance | float | Total distance traveled by the vehicle in miles0 or more · optional | 71230.7 |
| Dates and times 4 columns | |||
last_maintenance_date | date | Date of the most recent maintenance performed on the vehicleoptional | 2023-09-15 |
next_maintenance_due | date | Scheduled date for the next maintenanceoptional | 2024-03-15 |
driver_assignment_start_date | date | Date when the current driver was assigned to the vehicleoptional | 2023-02-10 |
driver_assignment_end_date | date | Date when the current driver assignment ended (if applicable)optional | 2024-05-29 |
Use it for
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.
- Vehicles2001HGCM82633A00010177.6activeJTDKB20U38302876585.3active2FMDK3GC7BBA0002267.9active
A software demo
Believable vehicles with license_
plate, make and model to fill a screen in front of a buyer.
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.
- 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
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