Mining Tire Lifecycle and Predictive Maintenance Set (ID)
MINTIR925· 34K records · 23 tables · v1.0.1 · Updated 2026-08-14
Mining Mining Dataset API
Overview
This longitudinal mining 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.
Terraline HaulmaxMOD001haul truck
24.00R35Size
112.4 mmTread depth
71,954 kgMax load
A8Speed rating
1 / 4
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| id_mining_tire_years | 12 |
| id_mining_tire_countries | 1 |
| id_mining_tire_companies | 216 |
| id_mining_tire_sites | 216 |
| id_mining_tire_vehicle_models | 216 |
| id_mining_tire_vehicles | 216 |
| id_mining_tire_tire_models | 216 |
| id_mining_tire_tire_media | 18 |
| id_mining_tire_tire_assets | 216 |
| id_mining_tire_installations | 216 |
| id_mining_tire_rotations | 216 |
| id_mining_tire_inspections | 216 |
| id_mining_tire_tpms_daily | 26,280 |
| id_mining_tire_usage_monthly | 1,728 |
| id_mining_tire_operating_conditions | 216 |
| id_mining_tire_damage_events | 2,880 |
| id_mining_tire_repairs | 216 |
| id_mining_tire_retreads | 216 |
| id_mining_tire_failures | 216 |
| id_mining_tire_maintenance_costs | 216 |
| id_mining_tire_asset_disposals | 216 |
| id_mining_tire_prediction_features | 48 |
| id_mining_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.
id_mining_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 id_mining_tire_years record. |
| period_start | date | Period start for the id_mining_tire_years record. |
| period_end | date | Period end for the id_mining_tire_years record. |
| source_status | varchar(32) | source status in the declared lifecycle or operational vocabulary. |
id_mining_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(16) | Human-readable country name; names are fictional where the disclosure states so. |
| region_name | varchar(16) | Human-readable region name; names are fictional where the disclosure states so. |
| currency_code | varchar(8) | Stable code for currency. |
id_mining_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 id_mining_tire_companies record. |
| fictional_entity_flag | boolean | Boolean indicator for fictional entity. |
id_mining_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(48) | Human-readable site name; names are fictional where the disclosure states so. |
| site_type | varchar(24) | Site type for the id_mining_tire_sites record. |
| climate_band | varchar(16) | Climate band for the id_mining_tire_sites record. |
| road_or_mine_surface | varchar(24) | Road or mine surface for the id_mining_tire_sites record. |
+2 more columns in id_mining_tire_sites. The full schema ships with the download.
id_mining_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(24) | Human-readable model name; names are fictional where the disclosure states so. |
| vehicle_class | varchar(24) | Vehicle class for the id_mining_tire_vehicle_models record. |
| axle_count | integer | Axle count for the id_mining_tire_vehicle_models record. |
| gross_vehicle_mass_t | integer | Gross vehicle mass t for the id_mining_tire_vehicle_models record. |
| payload_t | numeric(6,1) | Payload t for the id_mining_tire_vehicle_models record. |
+2 more columns in id_mining_tire_vehicle_models. The full schema ships with the download.
id_mining_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 id_mining_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 id_mining_tire_vehicles record. |
+2 more columns in id_mining_tire_vehicles. The full schema ships with the download.
id_mining_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(24) | Application type for the id_mining_tire_tire_models record. |
| size_code | varchar(16) | Stable code for size. |
| construction_type | varchar(16) | Construction type for the id_mining_tire_tire_models record. |
+6 more columns in id_mining_tire_tire_models. The full schema ships with the download.
id_mining_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 id_mining_tire_tire_media record. |
| image_format | varchar(16) | Image format for the id_mining_tire_tire_media record. |
| image_width_px | integer | Image width px for the id_mining_tire_tire_media record. |
| image_height_px | integer | Image height px for the id_mining_tire_tire_media record. |
| tread_pattern_view | varchar(24) | Tread pattern view for the id_mining_tire_tire_media record. |
+2 more columns in id_mining_tire_tire_media. The full schema ships with the download.
id_mining_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 id_mining_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 id_mining_tire_tire_assets. The full schema ships with the download.
id_mining_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 id_mining_tire_installations. The full schema ships with the download.
id_mining_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 id_mining_tire_rotations record. |
| to_position | integer | To position for the id_mining_tire_rotations record. |
+5 more columns in id_mining_tire_rotations. The full schema ships with the download.
id_mining_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 id_mining_tire_inspections. The full schema ships with the download.
id_mining_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 id_mining_tire_tpms_daily. The full schema ships with the download.
id_mining_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 id_mining_tire_usage_monthly record. |
| distance_km | integer | distance in kilometres. |
+8 more columns in id_mining_tire_usage_monthly. The full schema ships with the download.
id_mining_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 id_mining_tire_operating_conditions record. |
| surface_condition | varchar(24) | Surface condition for the id_mining_tire_operating_conditions record. |
| ambient_temperature_c | numeric(5,1) | Ambient temperature c for the id_mining_tire_operating_conditions record. |
| rainfall_mm | numeric(6,1) | rainfall in millimetres. |
+6 more columns in id_mining_tire_operating_conditions. The full schema ships with the download.
id_mining_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 id_mining_tire_damage_events record. |
| damage_location | varchar(24) | Damage location for the id_mining_tire_damage_events record. |
+5 more columns in id_mining_tire_damage_events. The full schema ships with the download.
id_mining_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 id_mining_tire_repairs record. |
| patch_count | integer | Patch count for the id_mining_tire_repairs record. |
+5 more columns in id_mining_tire_repairs. The full schema ships with the download.
id_mining_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 id_mining_tire_retreads record. |
| casing_grade | varchar(16) | Casing grade for the id_mining_tire_retreads record. |
| tread_pattern_code | varchar(8) | Stable code for tread pattern. |
+5 more columns in id_mining_tire_retreads. The full schema ships with the download.
id_mining_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 id_mining_tire_failures record. |
+9 more columns in id_mining_tire_failures. The full schema ships with the download.
id_mining_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 id_mining_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 id_mining_tire_maintenance_costs. The full schema ships with the download.
id_mining_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(16) | Disposal reason for the id_mining_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 id_mining_tire_asset_disposals. The full schema ships with the download.
id_mining_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 id_mining_tire_prediction_features record. |
+10 more columns in id_mining_tire_prediction_features. The full schema ships with the download.
id_mining_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 id_mining_tire_failure_predictions record. |
+9 more columns in id_mining_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 | SN93907919 | 2015-01-01 | PLA001 | BAT001 | 40324 | 18 | 112.4 | closed |
| TIR0000002 | TIR0000002 | SN10685538 | 2016-02-08 | PLA002 | BAT002 | 18992 | 18 | 62 | completed |
| TIR0000003 | TIR0000003 | SN27463157 | 2017-03-15 | PLA003 | BAT003 | 27571 | 18 | 77.7 | closed |
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
Mining Dump Truck Fleet Management Analytics Set (AU)
MiningA complete Australia analytical warehouse covering mine, location, truck, operator, shift, dispatch, haul cycle, payload, position, delay, fuel, tyre, maintenance, breakdown, safety, production, cost and prediction data.
$269one time
View details Mining Dump Truck Fleet Management Analytics Set (ID)
MiningA complete Indonesia analytical warehouse covering mine, location, truck, operator, shift, dispatch, haul cycle, payload, position, delay, fuel, tyre, maintenance, breakdown, safety, production, cost and prediction data.
$269one time
View details Mining Tire Lifecycle and Predictive Maintenance Set (AU)
MiningA complete Australia analytical warehouse covering company, site, vehicle, tire model, serialized asset, installation, rotation, inspection, pressure, usage, conditions, damage, repair, retread, failure, cost, disposal and prediction data.
$129one time
View details