Trucking and Logistics Analytics Set (EU)
TRNLOG904· 2.5M records · 53 tables · v1.0.0 · Updated 2026-08-10
Freight & Logistics Freight & Logistics Dataset API
Overview
This dataset follows the modelled Altivaro European Road Logistics across ten complete years from July 2016 through June 2026. It links depots, lanes, customers, commercial contracts and NST-style goods categories to shipments, load plans, trip legs, delivery stops, proof of delivery, driver assignments, tachograph activity, telematics, fuel and charging transactions. Fleet records include European-dominant and smaller Chinese-manufacturer cohorts, vehicle specification, trailers, tyres, inspections, health scores, maintenance, parts, breakdowns, accidents, insurance claims, depreciation and asset sales. Every executed leg reconciles revenue to fuel, driver, toll, ferry, subcontract, maintenance allocation, depreciation and overhead costs. Monthly marts and pre-period feature tables support route profitability, fuel benchmarking, overload detection, maintenance prediction, safety analysis and cost forecasting without representing a real operator, person, vehicle or transaction.
Products and Specifications
Four entries from the packaged tables, with the specifications the dataset records for them. Every value below is read from the shipped files.
Mercedes-Benz Trucks Actros 2545MDL001long haul
450 kWPower
25,100 kgPayload
tractor 4x2Configuration
Euro VIEmissions
1 / 4
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| logistics_trucks | 360 |
| logistics_countries | 14 |
| logistics_months | 120 |
| logistics_calendar_days | 3,652 |
| logistics_depots | 28 |
| logistics_routes | 168 |
| logistics_route_segments | 684 |
| logistics_service_types | 8 |
| logistics_customer_segments | 7 |
| logistics_customers | 2,400 |
| logistics_contracts | 3,000 |
| logistics_goods_catalog | 40 |
| logistics_truck_manufacturers | 12 |
| logistics_truck_models | 28 |
| logistics_trailers | 240 |
| logistics_vehicle_media | 28 |
| logistics_drivers | 540 |
| logistics_driver_licences | 1,080 |
| logistics_driver_training | 7,200 |
| logistics_shipments | 60,000 |
| logistics_shipment_goods | 132,000 |
| logistics_load_plans | 60,000 |
| logistics_trip_legs | 146,428 |
| logistics_delivery_stops | 439,284 |
| logistics_proof_of_delivery | 60,000 |
| logistics_driver_assignments | 146,428 |
| logistics_tachograph_daily | 146,428 |
| logistics_telematics_trip | 146,428 |
| logistics_fuel_transactions | 137,570 |
| logistics_charging_sessions | 8,858 |
| logistics_truck_monthly_health | 43,200 |
| logistics_inspections | 21,600 |
| logistics_maintenance_work_orders | 18,000 |
| logistics_maintenance_parts | 45,000 |
| logistics_tyres | 2,880 |
| logistics_tyre_inspections | 115,200 |
| logistics_breakdowns | 5,200 |
| logistics_accidents | 2,100 |
| logistics_insurance_claims | 2,100 |
| logistics_tolls_ferries_border | 292,142 |
| logistics_trip_costs | 146,428 |
| logistics_invoices | 60,000 |
| logistics_payments | 60,000 |
| logistics_asset_valuations | 43,200 |
| logistics_asset_sales | 90 |
| logistics_monthly_truck_performance | 43,200 |
| logistics_monthly_route_performance | 20,160 |
| logistics_monthly_financials | 1,680 |
| logistics_sustainability_monthly | 1,680 |
| logistics_fuel_benchmarks | 10,080 |
| logistics_forecast_features | 20,160 |
| logistics_cost_forecasts | 20,160 |
| logistics_maintenance_predictions | 43,200 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
70%
Loading diagram
Schema
Every table ships with typed columns, referential integrity, and documentation.
logistics_trucks· Rows: 360
| Column | Type | Description |
|---|---|---|
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| fleet_number | varchar(16) | Fleet number for the logistics record. |
| truck_model_id | varchar(8) | Stable fictional identifier for truck model; use it for declared joins. |
| manufacturer_id | varchar(8) | Stable fictional identifier for manufacturer; use it for declared joins. |
| manufacturer_name | varchar(32) | Human-readable manufacturer name. All people and organisations are fictional. |
| model_family | varchar(24) | Model family for the logistics record. |
| powertrain_type | varchar(24) | Powertrain type for the logistics record. |
+13 more columns in logistics_trucks. The full schema ships with the download.
logistics_countries· Rows: 14
| Column | Type | Description |
|---|---|---|
| country_id | varchar(8) | Stable fictional identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| country_name | varchar(24) | Human-readable country name. All people and organisations are fictional. |
| currency | varchar(16) | Currency for the logistics record. |
| cost_index | numeric(5,2) | Cost index for the logistics record. |
| toll_index | numeric(5,2) | Toll index for the logistics record. |
| route_complexity_index | numeric(5,2) | Route complexity index for the logistics record. |
+5 more columns in logistics_countries. The full schema ships with the download.
logistics_months· Rows: 120
| Column | Type | Description |
|---|---|---|
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| year_month | varchar(16) | Year month for the logistics record. |
| calendar_year | integer | Calendar year for the logistics record. |
| month_number | varchar(8) | Month number for the logistics record. |
| month_name | varchar(16) | Human-readable month name. All people and organisations are fictional. |
| quarter_number | varchar(8) | Quarter number for the logistics record. |
| season_band | varchar(16) | Season band for the logistics record. |
+5 more columns in logistics_months. The full schema ships with the download.
logistics_calendar_days· Rows: 3,652
| Column | Type | Description |
|---|---|---|
| calendar_date | varchar(16) | calendar date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| calendar_year | integer | Calendar year for the logistics record. |
| quarter_number | varchar(8) | Quarter number for the logistics record. |
| month_number | varchar(8) | Month number for the logistics record. |
| day_of_month | integer | Day of month for the logistics record. |
| day_of_year | integer | Day of year for the logistics record. |
+7 more columns in logistics_calendar_days. The full schema ships with the download.
logistics_depots· Rows: 28
| Column | Type | Description |
|---|---|---|
| depot_id | varchar(8) | Stable fictional identifier for depot; use it for declared joins. |
| depot_name | varchar(48) | Human-readable depot name. All people and organisations are fictional. |
| country_id | varchar(8) | Stable fictional identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| city | varchar(16) | City for the logistics record. |
| depot_type | varchar(16) | Depot type for the logistics record. |
| parking_bays | integer | Parking bays for the logistics record. |
+7 more columns in logistics_depots. The full schema ships with the download.
logistics_routes· Rows: 168
| Column | Type | Description |
|---|---|---|
| route_id | varchar(16) | Stable fictional identifier for route; use it for declared joins. |
| route_code | varchar(16) | Stable code for route; its companion description carries the meaning. |
| origin_depot_id | varchar(8) | Stable fictional identifier for origin depot; use it for declared joins. |
| origin_country_code | varchar(8) | Stable code for origin country; its companion description carries the meaning. |
| origin_city | varchar(16) | Origin city for the logistics record. |
| destination_depot_id | varchar(8) | Stable fictional identifier for destination depot; use it for declared joins. |
| destination_country_code | varchar(8) | Stable code for destination country; its companion description carries the meaning. |
+11 more columns in logistics_routes. The full schema ships with the download.
logistics_route_segments· Rows: 684
| Column | Type | Description |
|---|---|---|
| route_segment_id | varchar(16) | Stable fictional identifier for route segment; use it for declared joins. |
| route_id | varchar(16) | Stable fictional identifier for route; use it for declared joins. |
| segment_sequence | integer | Segment sequence for the logistics record. |
| segment_type | varchar(24) | Segment type for the logistics record. |
| from_location | varchar(16) | From location for the logistics record. |
| to_location | varchar(16) | To location for the logistics record. |
| segment_distance_km | integer | segment distance in kilometres. |
+6 more columns in logistics_route_segments. The full schema ships with the download.
logistics_service_types· Rows: 8
| Column | Type | Description |
|---|---|---|
| service_type_id | varchar(8) | Stable fictional identifier for service type; use it for declared joins. |
| service_type_code | varchar(32) | Stable code for service type; its companion description carries the meaning. |
| service_type_name | varchar(40) | Human-readable service type name. All people and organisations are fictional. |
| contract_family | varchar(24) | Contract family for the logistics record. |
| pricing_basis | varchar(32) | Pricing basis for the logistics record. |
| service_commitment | varchar(80) | Service commitment for the logistics record. |
logistics_customer_segments· Rows: 7
| Column | Type | Description |
|---|---|---|
| customer_segment_id | varchar(8) | Stable fictional identifier for customer segment; use it for declared joins. |
| segment_code | varchar(32) | Stable code for segment; its companion description carries the meaning. |
| segment_name | varchar(40) | Human-readable segment name. All people and organisations are fictional. |
| volume_band | varchar(16) | Volume band for the logistics record. |
| service_profile | varchar(32) | Service profile for the logistics record. |
| default_payment_days | integer | Default payment days for the logistics record. |
logistics_customers· Rows: 2,400
| Column | Type | Description |
|---|---|---|
| customer_id | varchar(16) | Stable fictional identifier for customer; use it for declared joins. |
| account_name | varchar(40) | Human-readable account name. All people and organisations are fictional. |
| country_id | varchar(8) | Stable fictional identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| customer_segment_id | varchar(8) | Stable fictional identifier for customer segment; use it for declared joins. |
| segment_code | varchar(32) | Stable code for segment; its companion description carries the meaning. |
| joined_on | date | joined on as an ISO 8601 calendar date. |
+7 more columns in logistics_customers. The full schema ships with the download.
logistics_contracts· Rows: 3,000
| Column | Type | Description |
|---|---|---|
| contract_id | varchar(16) | Stable fictional identifier for contract; use it for declared joins. |
| customer_id | varchar(16) | Stable fictional identifier for customer; use it for declared joins. |
| service_type_id | varchar(8) | Stable fictional identifier for service type; use it for declared joins. |
| contract_reference | varchar(24) | Contract reference for the logistics record. |
| contract_type | varchar(32) | Contract type for the logistics record. |
| starts_on | date | starts on as an ISO 8601 calendar date. |
| ends_on | date | ends on as an ISO 8601 calendar date. |
+12 more columns in logistics_contracts. The full schema ships with the download.
logistics_goods_catalog· Rows: 40
| Column | Type | Description |
|---|---|---|
| goods_id | varchar(8) | Stable fictional identifier for goods; use it for declared joins. |
| goods_code | varchar(8) | Stable code for goods; its companion description carries the meaning. |
| goods_name | varchar(48) | Human-readable goods name. All people and organisations are fictional. |
| nst_group | varchar(24) | Nst group for the logistics record. |
| temperature_regime | varchar(16) | Temperature regime for the logistics record. |
| required_body_type | varchar(24) | Required body type for the logistics record. |
| handling_class | varchar(16) | Handling class for the logistics record. |
+4 more columns in logistics_goods_catalog. The full schema ships with the download.
logistics_truck_manufacturers· Rows: 12
| Column | Type | Description |
|---|---|---|
| manufacturer_id | varchar(8) | Stable fictional identifier for manufacturer; use it for declared joins. |
| manufacturer_code | varchar(8) | Stable code for manufacturer; its companion description carries the meaning. |
| manufacturer_name | varchar(32) | Human-readable manufacturer name. All people and organisations are fictional. |
| headquarters_country | varchar(16) | Headquarters country for the logistics record. |
| origin_group | varchar(16) | Origin group for the logistics record. |
| fleet_weight | numeric(5,1) | Fleet weight for the logistics record. |
| reference_only_flag | boolean | Boolean indicator for reference only. |
+1 more columns in logistics_truck_manufacturers. The full schema ships with the download.
logistics_truck_models· Rows: 28
| Column | Type | Description |
|---|---|---|
| truck_model_id | varchar(8) | Stable fictional identifier for truck model; use it for declared joins. |
| manufacturer_id | varchar(8) | Stable fictional identifier for manufacturer; use it for declared joins. |
| manufacturer_code | varchar(8) | Stable code for manufacturer; its companion description carries the meaning. |
| manufacturer_name | varchar(32) | Human-readable manufacturer name. All people and organisations are fictional. |
| model_family | varchar(24) | Model family for the logistics record. |
| powertrain_type | varchar(24) | Powertrain type for the logistics record. |
| vehicle_configuration | varchar(16) | Vehicle configuration for the logistics record. |
+11 more columns in logistics_truck_models. The full schema ships with the download.
logistics_trailers· Rows: 240
| Column | Type | Description |
|---|---|---|
| trailer_id | varchar(16) | Stable fictional identifier for trailer; use it for declared joins. |
| trailer_type | varchar(24) | Trailer type for the logistics record. |
| home_depot_id | varchar(8) | Stable fictional identifier for home depot; use it for declared joins. |
| manufacture_year | integer | Manufacture year for the logistics record. |
| maximum_payload_kg | integer | Maximum payload kg for the logistics record. |
| volume_capacity_cbm | integer | Volume capacity cbm for the logistics record. |
| refrigeration_flag | boolean | Boolean indicator for refrigeration. |
+4 more columns in logistics_trailers. The full schema ships with the download.
logistics_vehicle_media· Rows: 28
| Column | Type | Description |
|---|---|---|
| vehicle_media_id | varchar(8) | Stable fictional identifier for vehicle media; use it for declared joins. |
| truck_model_id | varchar(8) | Stable fictional identifier for truck model; use it for declared joins. |
| schematic_svg_file | varchar(40) | Schematic svg file for the logistics record. |
| schematic_png_file | varchar(40) | Schematic png file for the logistics record. |
| image_width_px | integer | Image width px for the logistics record. |
| image_height_px | integer | Image height px for the logistics record. |
| transparent_background_flag | boolean | Boolean indicator for transparent background. |
+2 more columns in logistics_vehicle_media. The full schema ships with the download.
logistics_drivers· Rows: 540
| Column | Type | Description |
|---|---|---|
| driver_id | varchar(16) | Stable fictional identifier for driver; use it for declared joins. |
| workforce_code | varchar(16) | Stable code for workforce; its companion description carries the meaning. |
| home_depot_id | varchar(8) | Stable fictional identifier for home depot; use it for declared joins. |
| home_country_code | varchar(8) | Stable code for home country; its companion description carries the meaning. |
| employment_type | varchar(16) | Employment type for the logistics record. |
| role_code | varchar(24) | Stable code for role; its companion description carries the meaning. |
| hired_on | date | hired on as an ISO 8601 calendar date. |
+10 more columns in logistics_drivers. The full schema ships with the download.
logistics_driver_licences· Rows: 1,080
| Column | Type | Description |
|---|---|---|
| driver_licence_id | varchar(16) | Stable fictional identifier for driver licence; use it for declared joins. |
| driver_id | varchar(16) | Stable fictional identifier for driver; use it for declared joins. |
| licence_category | varchar(16) | Licence category for the logistics record. |
| endorsement_code | varchar(16) | Stable code for endorsement; its companion description carries the meaning. |
| issued_on | date | issued on as an ISO 8601 calendar date. |
| expires_on | date | expires on as an ISO 8601 calendar date. |
| issuing_country_code | varchar(8) | Stable code for issuing country; its companion description carries the meaning. |
+4 more columns in logistics_driver_licences. The full schema ships with the download.
logistics_driver_training· Rows: 7,200
| Column | Type | Description |
|---|---|---|
| driver_training_id | varchar(16) | Stable fictional identifier for driver training; use it for declared joins. |
| driver_id | varchar(16) | Stable fictional identifier for driver; use it for declared joins. |
| training_date | date | training date as an ISO 8601 calendar date. |
| training_code | varchar(24) | Stable code for training; its companion description carries the meaning. |
| training_name | varchar(40) | Human-readable training name. All people and organisations are fictional. |
| duration_hours | integer | duration in hours. |
| assessment_score_pct | numeric(6,2) | assessment score expressed as a percentage from 0 to 100. |
+4 more columns in logistics_driver_training. The full schema ships with the download.
logistics_shipments· Rows: 60,000
| Column | Type | Description |
|---|---|---|
| shipment_id | varchar(16) | Stable fictional identifier for shipment; use it for declared joins. |
| booked_date | date | booked date as an ISO 8601 calendar date. |
| pickup_date | date | pickup date as an ISO 8601 calendar date. |
| promised_delivery_date | date | promised delivery date as an ISO 8601 calendar date. |
| actual_delivery_date | date | actual delivery date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| customer_id | varchar(16) | Stable fictional identifier for customer; use it for declared joins. |
+16 more columns in logistics_shipments. The full schema ships with the download.
logistics_shipment_goods· Rows: 132,000
| Column | Type | Description |
|---|---|---|
| shipment_goods_id | varchar(16) | Stable fictional identifier for shipment goods; use it for declared joins. |
| shipment_id | varchar(16) | Stable fictional identifier for shipment; use it for declared joins. |
| line_number | varchar(8) | Line number for the logistics record. |
| goods_id | varchar(8) | Stable fictional identifier for goods; use it for declared joins. |
| goods_code | varchar(8) | Stable code for goods; its companion description carries the meaning. |
| goods_name | varchar(48) | Human-readable goods name. All people and organisations are fictional. |
| package_type | varchar(16) | Package type for the logistics record. |
+10 more columns in logistics_shipment_goods. The full schema ships with the download.
logistics_load_plans· Rows: 60,000
| Column | Type | Description |
|---|---|---|
| load_plan_id | varchar(16) | Stable fictional identifier for load plan; use it for declared joins. |
| shipment_id | varchar(16) | Stable fictional identifier for shipment; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| trailer_id | varchar(16) | Stable fictional identifier for trailer; use it for declared joins. |
| planned_payload_kg | integer | Planned payload kg for the logistics record. |
| measured_payload_kg | integer | Measured payload kg for the logistics record. |
| truck_curb_weight_kg | integer | Truck curb weight kg for the logistics record. |
+14 more columns in logistics_load_plans. The full schema ships with the download.
logistics_trip_legs· Rows: 146,428
| Column | Type | Description |
|---|---|---|
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| shipment_id | varchar(16) | Stable fictional identifier for shipment; use it for declared joins. |
| leg_sequence | integer | Leg sequence for the logistics record. |
| route_id | varchar(16) | Stable fictional identifier for route; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| trailer_id | varchar(16) | Stable fictional identifier for trailer; use it for declared joins. |
| departure_date | date | departure date as an ISO 8601 calendar date. |
+15 more columns in logistics_trip_legs. The full schema ships with the download.
logistics_delivery_stops· Rows: 439,284
| Column | Type | Description |
|---|---|---|
| delivery_stop_id | varchar(16) | Stable fictional identifier for delivery stop; use it for declared joins. |
| shipment_id | varchar(16) | Stable fictional identifier for shipment; use it for declared joins. |
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| stop_sequence | integer | Stop sequence for the logistics record. |
| stop_type | varchar(16) | Stop type for the logistics record. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| city | varchar(32) | City for the logistics record. |
+9 more columns in logistics_delivery_stops. The full schema ships with the download.
logistics_proof_of_delivery· Rows: 60,000
| Column | Type | Description |
|---|---|---|
| proof_of_delivery_id | varchar(16) | Stable fictional identifier for proof of delivery; use it for declared joins. |
| shipment_id | varchar(16) | Stable fictional identifier for shipment; use it for declared joins. |
| delivery_date | date | delivery date as an ISO 8601 calendar date. |
| delivery_status | varchar(32) | Delivery status for the logistics record. |
| signed_role_code | varchar(24) | Stable code for signed role; its companion description carries the meaning. |
| packages_expected | integer | Packages expected for the logistics record. |
| packages_accepted | integer | Packages accepted for the logistics record. |
+7 more columns in logistics_proof_of_delivery. The full schema ships with the download.
logistics_driver_assignments· Rows: 146,428
| Column | Type | Description |
|---|---|---|
| driver_assignment_id | varchar(16) | Stable fictional identifier for driver assignment; use it for declared joins. |
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| driver_id | varchar(16) | Stable fictional identifier for driver; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| assignment_role | varchar(16) | Assignment role for the logistics record. |
| shift_start_timestamp | varchar(32) | Shift start timestamp for the logistics record. |
| shift_end_timestamp | varchar(32) | Shift end timestamp for the logistics record. |
+6 more columns in logistics_driver_assignments. The full schema ships with the download.
logistics_tachograph_daily· Rows: 146,428
| Column | Type | Description |
|---|---|---|
| tachograph_day_id | varchar(16) | Stable fictional identifier for tachograph day; use it for declared joins. |
| driver_assignment_id | varchar(16) | Stable fictional identifier for driver assignment; use it for declared joins. |
| driver_id | varchar(16) | Stable fictional identifier for driver; use it for declared joins. |
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| activity_date | date | activity date as an ISO 8601 calendar date. |
| driving_hours | numeric(6,2) | driving in hours. |
| other_work_hours | numeric(5,2) | other work in hours. |
+11 more columns in logistics_tachograph_daily. The full schema ships with the download.
logistics_telematics_trip· Rows: 146,428
| Column | Type | Description |
|---|---|---|
| telematics_trip_id | varchar(16) | Stable fictional identifier for telematics trip; use it for declared joins. |
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| event_date | date | event date as an ISO 8601 calendar date. |
| distance_km | numeric(6,1) | distance in kilometres. |
| engine_hours | numeric(6,2) | engine in hours. |
| average_speed_kph | numeric(6,2) | Average speed kph for the logistics record. |
+15 more columns in logistics_telematics_trip. The full schema ships with the download.
logistics_fuel_transactions· Rows: 137,570
| Column | Type | Description |
|---|---|---|
| fuel_transaction_id | varchar(16) | Stable fictional identifier for fuel transaction; use it for declared joins. |
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| driver_id | varchar(16) | Stable fictional identifier for driver; use it for declared joins. |
| transaction_date | date | transaction date as an ISO 8601 calendar date. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| fuel_type | varchar(16) | Fuel type for the logistics record. |
+9 more columns in logistics_fuel_transactions. The full schema ships with the download.
logistics_charging_sessions· Rows: 8,858
| Column | Type | Description |
|---|---|---|
| charging_session_id | varchar(16) | Stable fictional identifier for charging session; use it for declared joins. |
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| session_date | date | session date as an ISO 8601 calendar date. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| charger_type | varchar(16) | Charger type for the logistics record. |
| energy_kwh | numeric(7,2) | Energy kwh for the logistics record. |
+9 more columns in logistics_charging_sessions. The full schema ships with the download.
logistics_truck_monthly_health· Rows: 43,200
| Column | Type | Description |
|---|---|---|
| truck_month_health_id | varchar(16) | Stable fictional identifier for truck month health; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| odometer_end_km | integer | odometer end in kilometres. |
| distance_month_km | numeric(7,1) | distance month in kilometres. |
| utilisation_pct | numeric(6,2) | utilisation expressed as a percentage from 0 to 100. |
| availability_pct | numeric(6,2) | availability expressed as a percentage from 0 to 100. |
+12 more columns in logistics_truck_monthly_health. The full schema ships with the download.
logistics_inspections· Rows: 21,600
| Column | Type | Description |
|---|---|---|
| inspection_id | varchar(16) | Stable fictional identifier for inspection; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| depot_id | varchar(8) | Stable fictional identifier for depot; use it for declared joins. |
| inspection_date | date | inspection date as an ISO 8601 calendar date. |
| inspection_type | varchar(24) | Inspection type for the logistics record. |
| odometer_km | integer | odometer in kilometres. |
| brake_result | varchar(16) | Brake result for the logistics record. |
+9 more columns in logistics_inspections. The full schema ships with the download.
logistics_maintenance_work_orders· Rows: 18,000
| Column | Type | Description |
|---|---|---|
| maintenance_work_order_id | varchar(16) | Stable fictional identifier for maintenance work order; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| depot_id | varchar(8) | Stable fictional identifier for depot; use it for declared joins. |
| opened_on | date | opened on as an ISO 8601 calendar date. |
| closed_on | date | closed on as an ISO 8601 calendar date. |
| maintenance_type | varchar(16) | Maintenance type for the logistics record. |
| component_group | varchar(24) | Component group for the logistics record. |
+14 more columns in logistics_maintenance_work_orders. The full schema ships with the download.
logistics_maintenance_parts· Rows: 45,000
| Column | Type | Description |
|---|---|---|
| maintenance_part_id | varchar(16) | Stable fictional identifier for maintenance part; use it for declared joins. |
| maintenance_work_order_id | varchar(16) | Stable fictional identifier for maintenance work order; use it for declared joins. |
| line_number | varchar(8) | Line number for the logistics record. |
| part_code | varchar(16) | Stable code for part; its companion description carries the meaning. |
| part_description | varchar(40) | Human-readable meaning of part. |
| component_group | varchar(24) | Component group for the logistics record. |
| quantity | integer | Quantity for the logistics record. |
+5 more columns in logistics_maintenance_parts. The full schema ships with the download.
logistics_tyres· Rows: 2,880
| Column | Type | Description |
|---|---|---|
| tyre_id | varchar(16) | Stable fictional identifier for tyre; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| axle_number | varchar(8) | Axle number for the logistics record. |
| wheel_position | varchar(16) | Wheel position for the logistics record. |
| tyre_brand | varchar(16) | Tyre brand for the logistics record. |
| tyre_size | varchar(16) | Tyre size for the logistics record. |
| installed_on | date | installed on as an ISO 8601 calendar date. |
+6 more columns in logistics_tyres. The full schema ships with the download.
logistics_tyre_inspections· Rows: 115,200
| Column | Type | Description |
|---|---|---|
| tyre_inspection_id | varchar(16) | Stable fictional identifier for tyre inspection; use it for declared joins. |
| tyre_id | varchar(16) | Stable fictional identifier for tyre; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| inspection_date | date | inspection date as an ISO 8601 calendar date. |
| tread_depth_mm | numeric(5,1) | Tread depth mm for the logistics record. |
| pressure_kpa | integer | Pressure kpa for the logistics record. |
+5 more columns in logistics_tyre_inspections. The full schema ships with the download.
logistics_breakdowns· Rows: 5,200
| Column | Type | Description |
|---|---|---|
| breakdown_id | varchar(16) | Stable fictional identifier for breakdown; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| breakdown_date | date | breakdown date as an ISO 8601 calendar date. |
| component_group | varchar(24) | Component group for the logistics record. |
| severity_band | varchar(16) | Severity band for the logistics record. |
| roadside_flag | boolean | Boolean indicator for roadside. |
+8 more columns in logistics_breakdowns. The full schema ships with the download.
logistics_accidents· Rows: 2,100
| Column | Type | Description |
|---|---|---|
| accident_id | varchar(16) | Stable fictional identifier for accident; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| driver_id | varchar(16) | Stable fictional identifier for driver; use it for declared joins. |
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| accident_date | date | accident date as an ISO 8601 calendar date. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| accident_type | varchar(24) | Accident type for the logistics record. |
+15 more columns in logistics_accidents. The full schema ships with the download.
logistics_insurance_claims· Rows: 2,100
| Column | Type | Description |
|---|---|---|
| insurance_claim_id | varchar(16) | Stable fictional identifier for insurance claim; use it for declared joins. |
| accident_id | varchar(16) | Stable fictional identifier for accident; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| opened_on | date | opened on as an ISO 8601 calendar date. |
| closed_on | date | closed on as an ISO 8601 calendar date. |
| claim_type | varchar(16) | Claim type for the logistics record. |
| reserve_eur | numeric(10,2) | reserve in euros. |
+7 more columns in logistics_insurance_claims. The full schema ships with the download.
logistics_tolls_ferries_border· Rows: 292,142
| Column | Type | Description |
|---|---|---|
| route_charge_id | varchar(16) | Stable fictional identifier for route charge; use it for declared joins. |
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| route_id | varchar(16) | Stable fictional identifier for route; use it for declared joins. |
| charge_date | date | charge date as an ISO 8601 calendar date. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| charge_type | varchar(16) | Charge type for the logistics record. |
| provider_code | varchar(8) | Stable code for provider; its companion description carries the meaning. |
+5 more columns in logistics_tolls_ferries_border. The full schema ships with the download.
logistics_trip_costs· Rows: 146,428
| Column | Type | Description |
|---|---|---|
| trip_cost_id | varchar(16) | Stable fictional identifier for trip cost; use it for declared joins. |
| trip_leg_id | varchar(16) | Stable fictional identifier for trip leg; use it for declared joins. |
| shipment_id | varchar(16) | Stable fictional identifier for shipment; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| route_id | varchar(16) | Stable fictional identifier for route; use it for declared joins. |
| revenue_eur | numeric(8,2) | revenue in euros. |
| fuel_or_energy_cost_eur | numeric(8,2) | fuel or energy cost in euros. |
+13 more columns in logistics_trip_costs. The full schema ships with the download.
logistics_invoices· Rows: 60,000
| Column | Type | Description |
|---|---|---|
| invoice_id | varchar(16) | Stable fictional identifier for invoice; use it for declared joins. |
| shipment_id | varchar(16) | Stable fictional identifier for shipment; use it for declared joins. |
| customer_id | varchar(16) | Stable fictional identifier for customer; use it for declared joins. |
| contract_id | varchar(16) | Stable fictional identifier for contract; use it for declared joins. |
| invoice_date | date | invoice date as an ISO 8601 calendar date. |
| due_date | date | due date as an ISO 8601 calendar date. |
| currency | varchar(16) | Currency for the logistics record. |
+9 more columns in logistics_invoices. The full schema ships with the download.
logistics_payments· Rows: 60,000
| Column | Type | Description |
|---|---|---|
| payment_id | varchar(16) | Stable fictional identifier for payment; use it for declared joins. |
| invoice_id | varchar(16) | Stable fictional identifier for invoice; use it for declared joins. |
| customer_id | varchar(16) | Stable fictional identifier for customer; use it for declared joins. |
| payment_date | date | payment date as an ISO 8601 calendar date. |
| payment_status | varchar(16) | Payment status for the logistics record. |
| payment_method | varchar(24) | Payment method for the logistics record. |
| amount_eur | numeric(9,2) | amount in euros. |
+5 more columns in logistics_payments. The full schema ships with the download.
logistics_asset_valuations· Rows: 43,200
| Column | Type | Description |
|---|---|---|
| asset_valuation_id | varchar(16) | Stable fictional identifier for asset valuation; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| valuation_date | date | valuation date as an ISO 8601 calendar date. |
| acquisition_cost_eur | integer | acquisition cost in euros. |
| gross_book_value_eur | integer | gross book value in euros. |
| accumulated_depreciation_eur | numeric(10,2) | accumulated depreciation in euros. |
+6 more columns in logistics_asset_valuations. The full schema ships with the download.
logistics_asset_sales· Rows: 90
| Column | Type | Description |
|---|---|---|
| asset_sale_id | varchar(16) | Stable fictional identifier for asset sale; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| sale_date | date | sale date as an ISO 8601 calendar date. |
| sale_channel | varchar(24) | Sale channel for the logistics record. |
| sale_reason | varchar(32) | Sale reason for the logistics record. |
| buyer_region | varchar(32) | Buyer region for the logistics record. |
| odometer_at_sale_km | integer | odometer at sale in kilometres. |
+6 more columns in logistics_asset_sales. The full schema ships with the download.
logistics_monthly_truck_performance· Rows: 43,200
| Column | Type | Description |
|---|---|---|
| truck_month_performance_id | varchar(16) | Stable fictional identifier for truck month performance; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| manufacturer_id | varchar(8) | Stable fictional identifier for manufacturer; use it for declared joins. |
| manufacturer_name | varchar(32) | Human-readable manufacturer name. All people and organisations are fictional. |
| model_family | varchar(24) | Model family for the logistics record. |
| powertrain_type | varchar(24) | Powertrain type for the logistics record. |
+17 more columns in logistics_monthly_truck_performance. The full schema ships with the download.
logistics_monthly_route_performance· Rows: 20,160
| Column | Type | Description |
|---|---|---|
| route_month_performance_id | varchar(16) | Stable fictional identifier for route month performance; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| route_id | varchar(16) | Stable fictional identifier for route; use it for declared joins. |
| route_scope | varchar(24) | Route scope for the logistics record. |
| terrain_profile | varchar(16) | Terrain profile for the logistics record. |
| trips | integer | Trips for the logistics record. |
| distance_km | numeric(7,1) | distance in kilometres. |
+10 more columns in logistics_monthly_route_performance. The full schema ships with the download.
logistics_monthly_financials· Rows: 1,680
| Column | Type | Description |
|---|---|---|
| monthly_financial_id | varchar(16) | Stable fictional identifier for monthly financial; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| country_id | varchar(8) | Stable fictional identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| currency | varchar(16) | Currency for the logistics record. |
| freight_revenue_eur | numeric(10,2) | freight revenue in euros. |
| fuel_surcharge_revenue_eur | numeric(9,2) | fuel surcharge revenue in euros. |
+17 more columns in logistics_monthly_financials. The full schema ships with the download.
logistics_sustainability_monthly· Rows: 1,680
| Column | Type | Description |
|---|---|---|
| sustainability_id | varchar(16) | Stable fictional identifier for sustainability; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| country_id | varchar(8) | Stable fictional identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| distance_km | numeric(8,1) | distance in kilometres. |
| tonne_km | numeric(10,2) | tonne in kilometres. |
| diesel_litres | numeric(9,2) | Diesel litres for the logistics record. |
+10 more columns in logistics_sustainability_monthly. The full schema ships with the download.
logistics_fuel_benchmarks· Rows: 10,080
| Column | Type | Description |
|---|---|---|
| fuel_benchmark_id | varchar(16) | Stable fictional identifier for fuel benchmark; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| truck_model_id | varchar(8) | Stable fictional identifier for truck model; use it for declared joins. |
| manufacturer_id | varchar(8) | Stable fictional identifier for manufacturer; use it for declared joins. |
| manufacturer_name | varchar(32) | Human-readable manufacturer name. All people and organisations are fictional. |
| model_family | varchar(24) | Model family for the logistics record. |
| powertrain_type | varchar(24) | Powertrain type for the logistics record. |
+10 more columns in logistics_fuel_benchmarks. The full schema ships with the download.
logistics_forecast_features· Rows: 20,160
| Column | Type | Description |
|---|---|---|
| forecast_feature_id | varchar(16) | Stable fictional identifier for forecast feature; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| route_id | varchar(16) | Stable fictional identifier for route; use it for declared joins. |
| feature_source_cutoff | date | Latest source date available to the prediction feature row; empty for the first period and otherwise strictly earlier than the target month. |
| feature_set_version | varchar(24) | Feature set version for the logistics record. |
| lag_total_cost_1m_eur | numeric(9,2) | lag total cost 1m in euros. |
| lag_total_cost_12m_eur | numeric(9,2) | lag total cost 12m in euros. |
+12 more columns in logistics_forecast_features. The full schema ships with the download.
logistics_cost_forecasts· Rows: 20,160
| Column | Type | Description |
|---|---|---|
| cost_forecast_id | varchar(16) | Stable fictional identifier for cost forecast; use it for declared joins. |
| forecast_feature_id | varchar(16) | Stable fictional identifier for forecast feature; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| route_id | varchar(16) | Stable fictional identifier for route; use it for declared joins. |
| forecast_created_on | date | forecast created on as an ISO 8601 calendar date. |
| model_version | varchar(32) | Model version for the logistics record. |
| baseline_total_cost_eur | numeric(9,2) | baseline total cost in euros. |
+9 more columns in logistics_cost_forecasts. The full schema ships with the download.
logistics_maintenance_predictions· Rows: 43,200
| Column | Type | Description |
|---|---|---|
| maintenance_prediction_id | varchar(16) | Stable fictional identifier for maintenance prediction; use it for declared joins. |
| month_id | varchar(16) | Stable fictional identifier for month; use it for declared joins. |
| truck_id | varchar(16) | Stable fictional identifier for truck; use it for declared joins. |
| feature_source_cutoff | date | Latest source date available to the prediction feature row; empty for the first period and otherwise strictly earlier than the target month. |
| model_version | varchar(24) | Model version for the logistics record. |
| odometer_km | integer | odometer in kilometres. |
| age_months | integer | Age months for the logistics record. |
+10 more columns in logistics_maintenance_predictions. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| month_id | truck_id | manufacturer_name | model_family | powertrain_type | distance_km | payload_tonnes | fuel_or_energy_quantity | fuel_or_energy_unit | maintenance_cost_eur | revenue_eur | total_cost_eur | contribution_margin_eur | contribution_margin_pct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| M201607 | TRK0001 | Mercedes-Benz Trucks | eActros 600 | battery_electric | 11114 | 16.5 | 14081.4 | kWh | 69.65 | 12873.98 | 11218.23 | 1655.75 | 12.86 |
| M201607 | TRK0002 | Mercedes-Benz Trucks | Actros 2545 | diesel | 10692 | 16.3 | 3207.6 | litres | 276.07 | 12339.78 | 10019.41 | 2320.37 | 18.8 |
| M201607 | TRK0003 | Mercedes-Benz Trucks | Actros 2545 | diesel | 11254 | 16.2 | 3466.2 | litres | 190.24 | 12972.38 | 9631.59 | 3340.79 | 25.75 |
Version History
| v1.0.0 | 2026-08-10 | First release. A linked ten-year European road-freight warehouse spanning commercial, fleet, driver, load, route, telematics, fuel, maintenance, safety, finance, asset and predictive analytics. |
Related Datasets
Commercial Aviation Analytics Set (ASIA)
Freight & LogisticsA complete Asia analytical warehouse covering airline, fleet, route, flight, ticket, ancillary, operating, maintenance, safety, passenger-experience, rating, financial, profitability and demand-forecast data.
$299one time
View details Commercial Aviation Analytics Set (EU)
Freight & LogisticsA complete Europe analytical warehouse covering airline, fleet, route, flight, ticket, ancillary, operating, maintenance, safety, passenger-experience, rating, financial, profitability and demand-forecast data.
$299one time
View details Commercial Aviation Analytics Set (US)
Freight & LogisticsA complete United States analytical warehouse covering airline, fleet, route, flight, ticket, ancillary, operating, maintenance, safety, passenger-experience, rating, financial, profitability and demand-forecast data.
$299one time
View details