Mining Tire Lifecycle and Predictive Maintenance Set (AU)

MINTIR924· 34K records · 23 tables · v1.0.1 · Updated 2026-08-14
Mining Mining Dataset API
CSV JSON SQL Imagestireauanalyticsmaintenanceforecastingrelational-data

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 Haulmax
Terraline HaulmaxMOD001articulated dumper
24.00R35Size
102.9 mmTread depth
48,556 kgMax load
BSpeed rating
1 / 4

Row Counts by Table

Counted from the files that ship, not estimated.

TableRows
au_mining_tire_years12
au_mining_tire_countries1
au_mining_tire_companies216
au_mining_tire_sites216
au_mining_tire_vehicle_models216
au_mining_tire_vehicles216
au_mining_tire_tire_models216
au_mining_tire_tire_media18
au_mining_tire_tire_assets216
au_mining_tire_installations216
au_mining_tire_rotations216
au_mining_tire_inspections216
au_mining_tire_tpms_daily26,280
au_mining_tire_usage_monthly1,728
au_mining_tire_operating_conditions216
au_mining_tire_damage_events2,880
au_mining_tire_repairs216
au_mining_tire_retreads216
au_mining_tire_failures216
au_mining_tire_maintenance_costs216
au_mining_tire_asset_disposals216
au_mining_tire_prediction_features48
au_mining_tire_failure_predictions48

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.

au_mining_tire_years· Rows: 12
ColumnTypeDescription
year_idvarchar(8)Stable identifier for year; use it for declared joins.
calendar_yearintegerCalendar year for the au_mining_tire_years record.
period_startdatePeriod start for the au_mining_tire_years record.
period_enddatePeriod end for the au_mining_tire_years record.
source_statusvarchar(32)source status in the declared lifecycle or operational vocabulary.
au_mining_tire_countries· Rows: 1
ColumnTypeDescription
country_idvarchar(8)Stable identifier for country; use it for declared joins.
country_codevarchar(8)Stable code for country.
country_namevarchar(16)Human-readable country name; names are fictional where the disclosure states so.
region_namevarchar(16)Human-readable region name; names are fictional where the disclosure states so.
currency_codevarchar(8)Stable code for currency.
au_mining_tire_companies· Rows: 216
ColumnTypeDescription
company_idvarchar(16)Stable identifier for company; use it for declared joins.
company_codevarchar(8)Stable code for company.
company_namevarchar(48)Human-readable company name; names are fictional where the disclosure states so.
country_idvarchar(8)Stable identifier for country; use it for declared joins.
company_rolevarchar(24)Company role for the au_mining_tire_companies record.
fictional_entity_flagbooleanBoolean indicator for fictional entity.
au_mining_tire_sites· Rows: 216
ColumnTypeDescription
site_idvarchar(16)Stable identifier for site; use it for declared joins.
company_idvarchar(16)Stable identifier for company; use it for declared joins.
country_idvarchar(8)Stable identifier for country; use it for declared joins.
site_namevarchar(48)Human-readable site name; names are fictional where the disclosure states so.
site_typevarchar(24)Site type for the au_mining_tire_sites record.
climate_bandvarchar(16)Climate band for the au_mining_tire_sites record.
road_or_mine_surfacevarchar(24)Road or mine surface for the au_mining_tire_sites record.

+2 more columns in au_mining_tire_sites. The full schema ships with the download.

au_mining_tire_vehicle_models· Rows: 216
ColumnTypeDescription
vehicle_model_idvarchar(16)Stable identifier for vehicle model; use it for declared joins.
model_codevarchar(8)Stable code for model.
model_namevarchar(24)Human-readable model name; names are fictional where the disclosure states so.
vehicle_classvarchar(24)Vehicle class for the au_mining_tire_vehicle_models record.
axle_countintegerAxle count for the au_mining_tire_vehicle_models record.
gross_vehicle_mass_tintegerGross vehicle mass t for the au_mining_tire_vehicle_models record.
payload_tnumeric(6,1)Payload t for the au_mining_tire_vehicle_models record.

+2 more columns in au_mining_tire_vehicle_models. The full schema ships with the download.

au_mining_tire_vehicles· Rows: 216
ColumnTypeDescription
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
company_idvarchar(16)Stable identifier for company; use it for declared joins.
site_idvarchar(16)Stable identifier for site; use it for declared joins.
vehicle_model_idvarchar(16)Stable identifier for vehicle model; use it for declared joins.
fleet_numbervarchar(8)Fleet number for the au_mining_tire_vehicles record.
commissioned_datedatecommissioned date as an ISO 8601 calendar date.
odometer_or_hour_meter_startintegerOdometer or hour meter start for the au_mining_tire_vehicles record.

+2 more columns in au_mining_tire_vehicles. The full schema ships with the download.

au_mining_tire_tire_models· Rows: 216
ColumnTypeDescription
tire_model_idvarchar(16)Stable identifier for tire model; use it for declared joins.
manufacturer_company_idvarchar(16)Stable identifier for manufacturer company; use it for declared joins.
model_codevarchar(8)Stable code for model.
model_namevarchar(40)Human-readable model name; names are fictional where the disclosure states so.
application_typevarchar(24)Application type for the au_mining_tire_tire_models record.
size_codevarchar(16)Stable code for size.
construction_typevarchar(16)Construction type for the au_mining_tire_tire_models record.

+6 more columns in au_mining_tire_tire_models. The full schema ships with the download.

au_mining_tire_tire_media· Rows: 18
ColumnTypeDescription
tire_media_idvarchar(16)Stable identifier for tire media; use it for declared joins.
tire_model_idvarchar(16)Stable identifier for tire model; use it for declared joins.
image_filevarchar(24)Image file for the au_mining_tire_tire_media record.
image_formatvarchar(16)Image format for the au_mining_tire_tire_media record.
image_width_pxintegerImage width px for the au_mining_tire_tire_media record.
image_height_pxintegerImage height px for the au_mining_tire_tire_media record.
tread_pattern_viewvarchar(24)Tread pattern view for the au_mining_tire_tire_media record.

+2 more columns in au_mining_tire_tire_media. The full schema ships with the download.

au_mining_tire_tire_assets· Rows: 216
ColumnTypeDescription
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
tire_model_idvarchar(16)Stable identifier for tire model; use it for declared joins.
serial_numbervarchar(16)Serial number for the au_mining_tire_tire_assets record.
manufacture_datedatemanufacture date as an ISO 8601 calendar date.
plant_codevarchar(8)Stable code for plant.
batch_codevarchar(8)Stable code for batch.
acquisition_cost_usdintegeracquisition cost in United States dollars.

+4 more columns in au_mining_tire_tire_assets. The full schema ships with the download.

au_mining_tire_installations· Rows: 216
ColumnTypeDescription
installation_idvarchar(16)Stable identifier for installation; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
site_idvarchar(16)Stable identifier for site; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
installed_ondateinstalled on as an ISO 8601 calendar date.
removed_ondateremoved on as an ISO 8601 calendar date.

+6 more columns in au_mining_tire_installations. The full schema ships with the download.

au_mining_tire_rotations· Rows: 216
ColumnTypeDescription
rotation_idvarchar(16)Stable identifier for rotation; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
rotation_datedaterotation date as an ISO 8601 calendar date.
from_positionintegerFrom position for the au_mining_tire_rotations record.
to_positionintegerTo position for the au_mining_tire_rotations record.

+5 more columns in au_mining_tire_rotations. The full schema ships with the download.

au_mining_tire_inspections· Rows: 216
ColumnTypeDescription
inspection_idvarchar(16)Stable identifier for inspection; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
site_idvarchar(16)Stable identifier for site; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
inspection_datedateinspection date as an ISO 8601 calendar date.
tread_inner_mmnumeric(6,2)tread inner in millimetres.

+10 more columns in au_mining_tire_inspections. The full schema ships with the download.

au_mining_tire_tpms_daily· Rows: 26,280
ColumnTypeDescription
tpms_daily_idvarchar(16)Stable identifier for tpms daily; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
observation_datedateobservation date as an ISO 8601 calendar date.
average_pressure_kpaintegeraverage pressure in kilopascals.
minimum_pressure_kpaintegerminimum pressure in kilopascals.

+6 more columns in au_mining_tire_tpms_daily. The full schema ships with the download.

au_mining_tire_usage_monthly· Rows: 1,728
ColumnTypeDescription
usage_month_idvarchar(16)Stable identifier for usage month; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
site_idvarchar(16)Stable identifier for site; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
month_numbervarchar(8)Month number for the au_mining_tire_usage_monthly record.
distance_kmintegerdistance in kilometres.

+8 more columns in au_mining_tire_usage_monthly. The full schema ships with the download.

au_mining_tire_operating_conditions· Rows: 216
ColumnTypeDescription
condition_idvarchar(16)Stable identifier for condition; use it for declared joins.
site_idvarchar(16)Stable identifier for site; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
month_numbervarchar(8)Month number for the au_mining_tire_operating_conditions record.
surface_conditionvarchar(24)Surface condition for the au_mining_tire_operating_conditions record.
ambient_temperature_cnumeric(5,1)Ambient temperature c for the au_mining_tire_operating_conditions record.
rainfall_mmnumeric(6,1)rainfall in millimetres.

+6 more columns in au_mining_tire_operating_conditions. The full schema ships with the download.

au_mining_tire_damage_events· Rows: 2,880
ColumnTypeDescription
damage_event_idvarchar(16)Stable identifier for damage event; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
event_datedateevent date as an ISO 8601 calendar date.
damage_typevarchar(24)Damage type for the au_mining_tire_damage_events record.
damage_locationvarchar(24)Damage location for the au_mining_tire_damage_events record.

+5 more columns in au_mining_tire_damage_events. The full schema ships with the download.

au_mining_tire_repairs· Rows: 216
ColumnTypeDescription
repair_idvarchar(16)Stable identifier for repair; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
damage_event_idvarchar(16)Stable identifier for damage event; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
repair_datedaterepair date as an ISO 8601 calendar date.
repair_typevarchar(24)Repair type for the au_mining_tire_repairs record.
patch_countintegerPatch count for the au_mining_tire_repairs record.

+5 more columns in au_mining_tire_repairs. The full schema ships with the download.

au_mining_tire_retreads· Rows: 216
ColumnTypeDescription
retread_idvarchar(16)Stable identifier for retread; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
retread_datedateretread date as an ISO 8601 calendar date.
retread_sequenceintegerRetread sequence for the au_mining_tire_retreads record.
casing_gradevarchar(16)Casing grade for the au_mining_tire_retreads record.
tread_pattern_codevarchar(8)Stable code for tread pattern.

+5 more columns in au_mining_tire_retreads. The full schema ships with the download.

au_mining_tire_failures· Rows: 216
ColumnTypeDescription
failure_idvarchar(16)Stable identifier for failure; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
site_idvarchar(16)Stable identifier for site; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
failure_datedatefailure date as an ISO 8601 calendar date.
failure_modevarchar(24)Failure mode for the au_mining_tire_failures record.

+9 more columns in au_mining_tire_failures. The full schema ships with the download.

au_mining_tire_maintenance_costs· Rows: 216
ColumnTypeDescription
maintenance_cost_idvarchar(16)Stable identifier for maintenance cost; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
month_numbervarchar(8)Month number for the au_mining_tire_maintenance_costs record.
inspection_cost_usdintegerinspection cost in United States dollars.
repair_cost_usdintegerrepair cost in United States dollars.

+6 more columns in au_mining_tire_maintenance_costs. The full schema ships with the download.

au_mining_tire_asset_disposals· Rows: 216
ColumnTypeDescription
disposal_idvarchar(16)Stable identifier for disposal; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
disposal_datedatedisposal date as an ISO 8601 calendar date.
disposal_reasonvarchar(24)Disposal reason for the au_mining_tire_asset_disposals record.
casing_sale_value_usdintegercasing sale value in United States dollars.
recycling_cost_usdintegerrecycling cost in United States dollars.

+4 more columns in au_mining_tire_asset_disposals. The full schema ships with the download.

au_mining_tire_prediction_features· Rows: 48
ColumnTypeDescription
prediction_feature_idvarchar(16)Stable identifier for prediction feature; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
prediction_datedateprediction date as an ISO 8601 calendar date.
feature_source_cutoffdateLatest source date available to the feature row; it precedes the prediction target.
age_daysintegerAge days for the au_mining_tire_prediction_features record.

+10 more columns in au_mining_tire_prediction_features. The full schema ships with the download.

au_mining_tire_failure_predictions· Rows: 48
ColumnTypeDescription
failure_prediction_idvarchar(16)Stable identifier for failure prediction; use it for declared joins.
prediction_feature_idvarchar(16)Stable identifier for prediction feature; use it for declared joins.
tire_asset_idvarchar(16)Stable identifier for tire asset; use it for declared joins.
vehicle_idvarchar(16)Stable identifier for vehicle; use it for declared joins.
year_idvarchar(8)Stable identifier for year; use it for declared joins.
forecast_created_ondateforecast created on as an ISO 8601 calendar date.
model_versionvarchar(16)Model version for the au_mining_tire_failure_predictions record.

+9 more columns in au_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_idtire_model_idserial_numbermanufacture_dateplant_codebatch_codeacquisition_cost_usdwarranty_monthsinitial_tread_depth_mmlifecycle_status
TIR0000001TIR0000001SN986428622015-01-01PLA001BAT0012754024102.9completed
TIR0000002TIR0000002SN818652432016-02-08PLA002BAT002280571290.1active
TIR0000003TIR0000003SN650876242017-03-15PLA003BAT003216161281.6active

Version History

v1.0.12026-08-14First 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