Logistics Fleet Tire Lifecycle and Predictive Maintenance Set (US)
TRNTIR921· 34K records · 23 tables · v1.0.1 · Updated 2026-08-14
Freight & Logistics Freight & Logistics Dataset API
Overview
This longitudinal logistics fleet tire lifecycle and predictive maintenance set connects company, site, vehicle, tire model, serialized asset, installation, rotation, inspection, pressure, usage, conditions, damage, repair, retread, failure, cost, disposal and prediction data. It separates modelled observations, estimates and projections and preserves feature-source cutoffs for time-aware predictive evaluation. Real geography and official standards provide context only. Commercial entities, people, assets, transactions, measurements and financial values are modelled.
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.
Roadhaul DuramaxMOD001all position
315/70R22.5Size
18.1 mmTread depth
3,750 kgMax load
JSpeed rating
1 / 4
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| us_logistics_tire_years | 12 |
| us_logistics_tire_countries | 1 |
| us_logistics_tire_companies | 216 |
| us_logistics_tire_sites | 216 |
| us_logistics_tire_vehicle_models | 216 |
| us_logistics_tire_vehicles | 216 |
| us_logistics_tire_tire_models | 216 |
| us_logistics_tire_tire_media | 18 |
| us_logistics_tire_tire_assets | 216 |
| us_logistics_tire_installations | 216 |
| us_logistics_tire_rotations | 216 |
| us_logistics_tire_inspections | 216 |
| us_logistics_tire_tpms_daily | 26,280 |
| us_logistics_tire_usage_monthly | 1,728 |
| us_logistics_tire_operating_conditions | 216 |
| us_logistics_tire_damage_events | 2,880 |
| us_logistics_tire_repairs | 216 |
| us_logistics_tire_retreads | 216 |
| us_logistics_tire_failures | 216 |
| us_logistics_tire_maintenance_costs | 216 |
| us_logistics_tire_asset_disposals | 216 |
| us_logistics_tire_prediction_features | 48 |
| us_logistics_tire_failure_predictions | 48 |
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.
us_logistics_tire_years· Rows: 12
| Column | Type | Description |
|---|---|---|
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| calendar_year | integer | Calendar year for the us_logistics_tire_years record. |
| period_start | date | Period start for the us_logistics_tire_years record. |
| period_end | date | Period end for the us_logistics_tire_years record. |
| source_status | varchar(32) | source status in the declared lifecycle or operational vocabulary. |
us_logistics_tire_countries· Rows: 1
| Column | Type | Description |
|---|---|---|
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| country_name | varchar(24) | Human-readable country name; names are fictional where the disclosure states so. |
| region_name | varchar(24) | Human-readable region name; names are fictional where the disclosure states so. |
| currency_code | varchar(8) | Stable code for currency. |
us_logistics_tire_companies· Rows: 216
| Column | Type | Description |
|---|---|---|
| company_id | varchar(16) | Stable identifier for company; use it for declared joins. |
| company_code | varchar(8) | Stable code for company. |
| company_name | varchar(48) | Human-readable company name; names are fictional where the disclosure states so. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| company_role | varchar(24) | Company role for the us_logistics_tire_companies record. |
| fictional_entity_flag | boolean | Boolean indicator for fictional entity. |
us_logistics_tire_sites· Rows: 216
| Column | Type | Description |
|---|---|---|
| site_id | varchar(16) | Stable identifier for site; use it for declared joins. |
| company_id | varchar(16) | Stable identifier for company; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| site_name | varchar(40) | Human-readable site name; names are fictional where the disclosure states so. |
| site_type | varchar(24) | Site type for the us_logistics_tire_sites record. |
| climate_band | varchar(24) | Climate band for the us_logistics_tire_sites record. |
| road_or_mine_surface | varchar(24) | Road or mine surface for the us_logistics_tire_sites record. |
+2 more columns in us_logistics_tire_sites. The full schema ships with the download.
us_logistics_tire_vehicle_models· Rows: 216
| Column | Type | Description |
|---|---|---|
| vehicle_model_id | varchar(16) | Stable identifier for vehicle model; use it for declared joins. |
| model_code | varchar(8) | Stable code for model. |
| model_name | varchar(32) | Human-readable model name; names are fictional where the disclosure states so. |
| vehicle_class | varchar(16) | Vehicle class for the us_logistics_tire_vehicle_models record. |
| axle_count | integer | Axle count for the us_logistics_tire_vehicle_models record. |
| gross_vehicle_mass_t | integer | Gross vehicle mass t for the us_logistics_tire_vehicle_models record. |
| payload_t | numeric(5,1) | Payload t for the us_logistics_tire_vehicle_models record. |
+2 more columns in us_logistics_tire_vehicle_models. The full schema ships with the download.
us_logistics_tire_vehicles· Rows: 216
| Column | Type | Description |
|---|---|---|
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| company_id | varchar(16) | Stable identifier for company; use it for declared joins. |
| site_id | varchar(16) | Stable identifier for site; use it for declared joins. |
| vehicle_model_id | varchar(16) | Stable identifier for vehicle model; use it for declared joins. |
| fleet_number | varchar(8) | Fleet number for the us_logistics_tire_vehicles record. |
| commissioned_date | date | commissioned date as an ISO 8601 calendar date. |
| odometer_or_hour_meter_start | integer | Odometer or hour meter start for the us_logistics_tire_vehicles record. |
+2 more columns in us_logistics_tire_vehicles. The full schema ships with the download.
us_logistics_tire_tire_models· Rows: 216
| Column | Type | Description |
|---|---|---|
| tire_model_id | varchar(16) | Stable identifier for tire model; use it for declared joins. |
| manufacturer_company_id | varchar(16) | Stable identifier for manufacturer company; use it for declared joins. |
| model_code | varchar(8) | Stable code for model. |
| model_name | varchar(40) | Human-readable model name; names are fictional where the disclosure states so. |
| application_type | varchar(16) | Application type for the us_logistics_tire_tire_models record. |
| size_code | varchar(16) | Stable code for size. |
| construction_type | varchar(16) | Construction type for the us_logistics_tire_tire_models record. |
+6 more columns in us_logistics_tire_tire_models. The full schema ships with the download.
us_logistics_tire_tire_media· Rows: 18
| Column | Type | Description |
|---|---|---|
| tire_media_id | varchar(16) | Stable identifier for tire media; use it for declared joins. |
| tire_model_id | varchar(16) | Stable identifier for tire model; use it for declared joins. |
| image_file | varchar(24) | Image file for the us_logistics_tire_tire_media record. |
| image_format | varchar(16) | Image format for the us_logistics_tire_tire_media record. |
| image_width_px | integer | Image width px for the us_logistics_tire_tire_media record. |
| image_height_px | integer | Image height px for the us_logistics_tire_tire_media record. |
| tread_pattern_view | varchar(24) | Tread pattern view for the us_logistics_tire_tire_media record. |
+2 more columns in us_logistics_tire_tire_media. The full schema ships with the download.
us_logistics_tire_tire_assets· Rows: 216
| Column | Type | Description |
|---|---|---|
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| tire_model_id | varchar(16) | Stable identifier for tire model; use it for declared joins. |
| serial_number | varchar(16) | Serial number for the us_logistics_tire_tire_assets record. |
| manufacture_date | date | manufacture date as an ISO 8601 calendar date. |
| plant_code | varchar(8) | Stable code for plant. |
| batch_code | varchar(8) | Stable code for batch. |
| acquisition_cost_usd | integer | acquisition cost in United States dollars. |
+4 more columns in us_logistics_tire_tire_assets. The full schema ships with the download.
us_logistics_tire_installations· Rows: 216
| Column | Type | Description |
|---|---|---|
| installation_id | varchar(16) | Stable identifier for installation; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| site_id | varchar(16) | Stable identifier for site; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| installed_on | date | installed on as an ISO 8601 calendar date. |
| removed_on | date | removed on as an ISO 8601 calendar date. |
+6 more columns in us_logistics_tire_installations. The full schema ships with the download.
us_logistics_tire_rotations· Rows: 216
| Column | Type | Description |
|---|---|---|
| rotation_id | varchar(16) | Stable identifier for rotation; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| rotation_date | date | rotation date as an ISO 8601 calendar date. |
| from_position | integer | From position for the us_logistics_tire_rotations record. |
| to_position | integer | To position for the us_logistics_tire_rotations record. |
+5 more columns in us_logistics_tire_rotations. The full schema ships with the download.
us_logistics_tire_inspections· Rows: 216
| Column | Type | Description |
|---|---|---|
| inspection_id | varchar(16) | Stable identifier for inspection; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| site_id | varchar(16) | Stable identifier for site; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| inspection_date | date | inspection date as an ISO 8601 calendar date. |
| tread_inner_mm | numeric(6,2) | tread inner in millimetres. |
+10 more columns in us_logistics_tire_inspections. The full schema ships with the download.
us_logistics_tire_tpms_daily· Rows: 26,280
| Column | Type | Description |
|---|---|---|
| tpms_daily_id | varchar(16) | Stable identifier for tpms daily; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| observation_date | date | observation date as an ISO 8601 calendar date. |
| average_pressure_kpa | integer | average pressure in kilopascals. |
| minimum_pressure_kpa | integer | minimum pressure in kilopascals. |
+6 more columns in us_logistics_tire_tpms_daily. The full schema ships with the download.
us_logistics_tire_usage_monthly· Rows: 1,728
| Column | Type | Description |
|---|---|---|
| usage_month_id | varchar(16) | Stable identifier for usage month; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| site_id | varchar(16) | Stable identifier for site; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| month_number | varchar(8) | Month number for the us_logistics_tire_usage_monthly record. |
| distance_km | integer | distance in kilometres. |
+8 more columns in us_logistics_tire_usage_monthly. The full schema ships with the download.
us_logistics_tire_operating_conditions· Rows: 216
| Column | Type | Description |
|---|---|---|
| condition_id | varchar(16) | Stable identifier for condition; use it for declared joins. |
| site_id | varchar(16) | Stable identifier for site; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| month_number | varchar(8) | Month number for the us_logistics_tire_operating_conditions record. |
| surface_condition | varchar(24) | Surface condition for the us_logistics_tire_operating_conditions record. |
| ambient_temperature_c | numeric(5,1) | Ambient temperature c for the us_logistics_tire_operating_conditions record. |
| rainfall_mm | numeric(6,1) | rainfall in millimetres. |
+6 more columns in us_logistics_tire_operating_conditions. The full schema ships with the download.
us_logistics_tire_damage_events· Rows: 2,880
| Column | Type | Description |
|---|---|---|
| damage_event_id | varchar(16) | Stable identifier for damage event; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| event_date | date | event date as an ISO 8601 calendar date. |
| damage_type | varchar(24) | Damage type for the us_logistics_tire_damage_events record. |
| damage_location | varchar(24) | Damage location for the us_logistics_tire_damage_events record. |
+5 more columns in us_logistics_tire_damage_events. The full schema ships with the download.
us_logistics_tire_repairs· Rows: 216
| Column | Type | Description |
|---|---|---|
| repair_id | varchar(16) | Stable identifier for repair; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| damage_event_id | varchar(16) | Stable identifier for damage event; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| repair_date | date | repair date as an ISO 8601 calendar date. |
| repair_type | varchar(24) | Repair type for the us_logistics_tire_repairs record. |
| patch_count | integer | Patch count for the us_logistics_tire_repairs record. |
+5 more columns in us_logistics_tire_repairs. The full schema ships with the download.
us_logistics_tire_retreads· Rows: 216
| Column | Type | Description |
|---|---|---|
| retread_id | varchar(16) | Stable identifier for retread; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| retread_date | date | retread date as an ISO 8601 calendar date. |
| retread_sequence | integer | Retread sequence for the us_logistics_tire_retreads record. |
| casing_grade | varchar(16) | Casing grade for the us_logistics_tire_retreads record. |
| tread_pattern_code | varchar(8) | Stable code for tread pattern. |
+5 more columns in us_logistics_tire_retreads. The full schema ships with the download.
us_logistics_tire_failures· Rows: 216
| Column | Type | Description |
|---|---|---|
| failure_id | varchar(16) | Stable identifier for failure; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| site_id | varchar(16) | Stable identifier for site; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| failure_date | date | failure date as an ISO 8601 calendar date. |
| failure_mode | varchar(24) | Failure mode for the us_logistics_tire_failures record. |
+9 more columns in us_logistics_tire_failures. The full schema ships with the download.
us_logistics_tire_maintenance_costs· Rows: 216
| Column | Type | Description |
|---|---|---|
| maintenance_cost_id | varchar(16) | Stable identifier for maintenance cost; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| month_number | varchar(8) | Month number for the us_logistics_tire_maintenance_costs record. |
| inspection_cost_usd | integer | inspection cost in United States dollars. |
| repair_cost_usd | integer | repair cost in United States dollars. |
+6 more columns in us_logistics_tire_maintenance_costs. The full schema ships with the download.
us_logistics_tire_asset_disposals· Rows: 216
| Column | Type | Description |
|---|---|---|
| disposal_id | varchar(16) | Stable identifier for disposal; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| disposal_date | date | disposal date as an ISO 8601 calendar date. |
| disposal_reason | varchar(24) | Disposal reason for the us_logistics_tire_asset_disposals record. |
| casing_sale_value_usd | integer | casing sale value in United States dollars. |
| recycling_cost_usd | integer | recycling cost in United States dollars. |
+4 more columns in us_logistics_tire_asset_disposals. The full schema ships with the download.
us_logistics_tire_prediction_features· Rows: 48
| Column | Type | Description |
|---|---|---|
| prediction_feature_id | varchar(16) | Stable identifier for prediction feature; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| prediction_date | date | prediction date as an ISO 8601 calendar date. |
| feature_source_cutoff | date | Latest source date available to the feature row; it precedes the prediction target. |
| age_days | integer | Age days for the us_logistics_tire_prediction_features record. |
+10 more columns in us_logistics_tire_prediction_features. The full schema ships with the download.
us_logistics_tire_failure_predictions· Rows: 48
| Column | Type | Description |
|---|---|---|
| failure_prediction_id | varchar(16) | Stable identifier for failure prediction; use it for declared joins. |
| prediction_feature_id | varchar(16) | Stable identifier for prediction feature; use it for declared joins. |
| tire_asset_id | varchar(16) | Stable identifier for tire asset; use it for declared joins. |
| vehicle_id | varchar(16) | Stable identifier for vehicle; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| forecast_created_on | date | forecast created on as an ISO 8601 calendar date. |
| model_version | varchar(16) | Model version for the us_logistics_tire_failure_predictions record. |
+9 more columns in us_logistics_tire_failure_predictions. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| tire_asset_id | tire_model_id | serial_number | manufacture_date | plant_code | batch_code | acquisition_cost_usd | warranty_months | initial_tread_depth_mm | lifecycle_status |
|---|---|---|---|---|---|---|---|---|---|
| TIR0000001 | TIR0000001 | SN92475603 | 2015-01-01 | PLA001 | BAT001 | 402 | 48 | 18.1 | closed |
| TIR0000002 | TIR0000002 | SN09253222 | 2016-02-08 | PLA002 | BAT002 | 739 | 36 | 14 | completed |
| TIR0000003 | TIR0000003 | SN26030841 | 2017-03-15 | PLA003 | BAT003 | 692 | 48 | 21.7 | active |
Version History
| v1.0.1 | 2026-08-14 | First complete relational release with deterministic generation, media references, documentation and API schema. The product renders that ship in the image directory are refreshed in this release; the data, its schema and every identifier are unchanged from 1.0.0. |
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