Vehicle Load Capacity Utilization

This dataset provides granular records of vehicle load capacity utilization, capturing details on transported loads, vehicle specifications, trip routes, and efficiency metrics. It enables logistics and transportation teams to analyze fleet performance, optimize load distribution, and reduce operational costs through data-driven insights.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Monitor and optimize fleet load utilization for cost savings

Sample rows

preview · 8 of 70 rows · all 20 columns
record_idstringvehicle_typestringvehicle_capacity_kgfloatorigin_citystringvehicle_idstringlicense_platestringdriver_idstringtrip_idstringdeparture_datetimedatetimearrival_datetimedatetimeorigin_statestringorigin_countrystringdestination_citystringdestination_statestringdestination_countrystringactual_load_kgfloatutilization_percentfloatdistance_kmfloatfuel_consumed_litersfloatnotesstring
VLCU-0001truck18000DallasVH-1023AB-1234-TYDRV-201TRP-46012023-03-11T07:15:002023-03-11T15:25:00TXUSAHoustonTXUSA1610089.4385102.5Smooth delivery, no delays.
VLCU-0002lorry22000ChicagoVH-1055KL-8876-OPDRV-214TRP-46122023-03-18T09:05:002023-03-18T17:35:00ILUSAIndianapolisINUSA2200010029888.3Full load; required extra care.
VLCU-0003van3500BuffaloVH-1077NY-4561-CADRV-232TRP-46552023-03-19T06:55:002023-03-19T10:30:00NYUSARochesterNYUSA32909410816.2blank
VLCU-0004truck14500OrlandoVH-1092FL-9921-JKDRV-241TRP-46982023-02-27T11:40:002023-02-27T17:05:00FLUSATampaFLUSA1100075.913536.4Early arrival.
VLCU-0005van4500San JoseVH-1203CA-9007-QWDRV-203TRP-47022023-03-02T13:20:002023-03-02T18:10:00CAUSASacramentoCAUSA401089.118824.5blank
VLCU-0006truck18000DallasVH-1023AB-1234-TYDRV-211TRP-47072023-03-13T08:00:002023-03-13T15:17:00TXUSAAustinTXUSA1630090.631685.9Traffic on I-35.
VLCU-0007lorry20500DetroitVH-1110MI-6692-ZXDRV-255TRP-47332023-03-05T05:30:002023-03-05T13:12:00MIUSAClevelandOHUSA194709528073.9blank
VLCU-0008truck17200AtlantaVH-1165GA-8712-RTDRV-247TRP-47402023-03-15T10:00:002023-03-15T20:25:00GAUSASavannahGAUSA1590092.4399108.2Weather delays.

What the 70 rows show

from the 70-row sample

Truck (vehicle type) stands out: mean vehicle_capacity_kg is 15,753, against 7,275 for the rest.

  • 6,400median vehicle_capacity_kg
  • 15origin countries
  • 15destination countries
  • 5,348median actual_load_kg
  • 84.6median utilization_percent
  • 215.0median distance_km
Mean vehicle_capacity_kg by vehicle_type70 rows
020k40k15,753truck19 rows3,917van12 rows4,567Truck12 rows20,889lorry9 rows1,617Van9 rows7,411Lorry9 rows
vehicle_capacity_kg70 rows, in bands of 2,500
010209209604958012.5k22.5kvehicle_capacity_kg →

Median 6,400, from 1,200 to 22,000.

origin_city70 rows · top 10 of 34 values
  1. San Jose6
  2. Seattle5
  3. Dallas4
  4. Chicago4
  5. Buffalo4
  6. Orlando4
  7. Detroit4
  8. Atlanta4
  9. Düsseldorf2
  10. Marseille2
20 columns by typefrom the column list below
  • string 13
  • float 5
  • datetime 2

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 13 columns
record_idstringUnique identifier for each vehicle load capacity utilization recorduniqueVLCU-0001
vehicle_idstringUnique identifier for the vehicleVH-1023
vehicle_typestringType or classification of the vehicle (e.g., truck, van, lorry)6 typestruck
license_platestringLicense plate number of the vehicleAB-1234-TY
driver_idstringUnique identifier for the driver assigned to the vehicle for this tripoptionalDRV-201
trip_idstringUnique identifier for the trip or delivery instanceTRP-4601
origin_citystringCity where the trip originatedDallas
origin_statestringState or region where the trip originatedTX
origin_countrystringCountry where the trip originatedUSA
destination_citystringCity where the trip endedHouston
destination_statestringState or region where the trip endedTX
destination_countrystringCountry where the trip endedUSA
notesstringAdditional notes or comments about the trip or loadoptionalEarly arrival.
Numbers 5 columns
vehicle_capacity_kgfloatMaximum load capacity of the vehicle in kilograms0 or more18000
actual_load_kgfloatActual weight of the load transported in kilograms0 or more16100
utilization_percentfloatPercentage of the vehicle's load capacity utilized for this trip0 to 10089.4
distance_kmfloatDistance traveled during the trip in kilometers0 or more · optional385
fuel_consumed_litersfloatAmount of fuel consumed during the trip in liters0 or more · optional102.5
Dates and times 2 columns
departure_datetimedatetimeDate and time when the vehicle departed for the trip2023-03-11T07:15:00
arrival_datetimedatetimeDate and time when the vehicle arrived at the destinationoptional2023-03-11T15:25:00

Use it for

  • median vehicle…6,40070 rowsmean vehicle capacity…15.8ktruck3.9kvan4.6kTruck20.9klorry

    A logistics dashboard

    Vehicle_capacity_kg by vehicle_type and a breakdown of origin_city. Excel, Power BI or Tableau.

  • Why do the 19 truck rows have a mean vehicle_capacity_kg of 15,753?

    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 records with vehicle_id, vehicle_type and license_plate 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 dataset70 rows20 columns
Yours1,000 rows20 columnsorigin_city: UK only

blueprint · vehicle-load-capacity-utilization

Behind this dataset

Same schema. As many rows as you need.

These 70 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
  • Record actual vs maximum load per trip
  • Log trip distance and duration
  • Flag loads below 70% capacity
  • Sum daily vehicle utilization rates
  • Identify vehicles with repeated underutilization
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
vehicle-load-capacity-utilization

More in Logistics

Browse all
Also in LogisticsFleet Energy Consumption TrackerWarehouse Inventory Flow DatasetLogistics Shipment Delay PredictionAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.