Mining Dump Truck Fleet Management Analytics Set (ID)
MINFMS930· 1.8M records · 24 tables · v2.0.1 · Updated 2026-08-14
Mining Mining Dataset API
Overview
This longitudinal mining dump truck fleet management analytics set connects mine, location, truck, operator, shift, dispatch, haul cycle, payload, position, delay, fuel, tyre, maintenance, breakdown, safety, production, cost 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.
Analytics
Four entries from the packaged tables, with the performance the dataset records for them. Every value below is read from the shipped files.
Ridgehaul 136TMOD001mid class
17Trucks
408.3 MtMoved
136 tPayload
USD 0.79Cost per tonne
Tonnes moved, millionsTonnes moved, millions
1 / 4
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| id_mining_fms_years | 12 |
| id_mining_fms_countries | 1 |
| id_mining_fms_companies | 4 |
| id_mining_fms_mine_sites | 8 |
| id_mining_fms_locations | 48 |
| id_mining_fms_truck_models | 12 |
| id_mining_fms_trucks | 120 |
| id_mining_fms_truck_media | 12 |
| id_mining_fms_operators | 240 |
| id_mining_fms_shifts | 70,128 |
| id_mining_fms_dispatch_assignments | 29,357 |
| id_mining_fms_haul_cycles | 656,491 |
| id_mining_fms_payloads | 656,491 |
| id_mining_fms_positions | 176,514 |
| id_mining_fms_delays | 58,926 |
| id_mining_fms_fuel_events | 31,488 |
| id_mining_fms_tyre_events | 4,028 |
| id_mining_fms_maintenance_events | 16,958 |
| id_mining_fms_breakdowns | 704 |
| id_mining_fms_safety_events | 374 |
| id_mining_fms_shift_production | 70,128 |
| id_mining_fms_operating_costs | 17,280 |
| id_mining_fms_prediction_features | 17,280 |
| id_mining_fms_cycle_predictions | 17,280 |
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_fms_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_fms_years record. |
| period_start | date | Period start for the id_mining_fms_years record. |
| period_end | date | Period end for the id_mining_fms_years record. |
| source_status | varchar(32) | source status in the declared lifecycle or operational vocabulary. |
id_mining_fms_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_fms_companies· Rows: 4
| 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(32) | 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. |
| business_role | varchar(24) | Business role for the id_mining_fms_companies record. |
| fictional_entity_flag | boolean | Boolean indicator for fictional entity. |
id_mining_fms_mine_sites· Rows: 8
| Column | Type | Description |
|---|---|---|
| mine_site_id | varchar(8) | Stable identifier for mine 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_code | varchar(8) | Stable code for site. |
| site_name | varchar(32) | Human-readable site name; names are fictional where the disclosure states so. |
| commodity | varchar(16) | Commodity for the id_mining_fms_mine_sites record. |
| mining_method | varchar(32) | Mining method for the id_mining_fms_mine_sites record. |
+3 more columns in id_mining_fms_mine_sites. The full schema ships with the download.
id_mining_fms_locations· Rows: 48
| Column | Type | Description |
|---|---|---|
| location_id | varchar(16) | Stable identifier for location; use it for declared joins. |
| mine_site_id | varchar(8) | Stable identifier for mine site; use it for declared joins. |
| location_code | varchar(16) | Stable code for location. |
| location_name | varchar(32) | Human-readable location name; names are fictional where the disclosure states so. |
| location_type | varchar(16) | Location type for the id_mining_fms_locations record. |
| material_code | varchar(8) | Stable code for material. |
| latitude | numeric(8,5) | Latitude for the id_mining_fms_locations record. |
+4 more columns in id_mining_fms_locations. The full schema ships with the download.
id_mining_fms_truck_models· Rows: 12
| Column | Type | Description |
|---|---|---|
| truck_model_id | varchar(8) | Stable identifier for truck 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. |
| truck_class | varchar(16) | Truck class for the id_mining_fms_truck_models record. |
| nominal_payload_t | integer | Nominal payload t for the id_mining_fms_truck_models record. |
| gross_power_kw | integer | Gross power kw for the id_mining_fms_truck_models record. |
| body_capacity_m3 | numeric(6,1) | Body capacity m3 for the id_mining_fms_truck_models record. |
+3 more columns in id_mining_fms_truck_models. The full schema ships with the download.
id_mining_fms_trucks· Rows: 120
| Column | Type | Description |
|---|---|---|
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| mine_site_id | varchar(8) | Stable identifier for mine site; use it for declared joins. |
| truck_model_id | varchar(8) | Stable identifier for truck model; use it for declared joins. |
| fleet_number | varchar(16) | Fleet number for the id_mining_fms_trucks record. |
| commissioned_date | date | commissioned date as an ISO 8601 calendar date. |
| acquisition_cost_usd | integer | acquisition cost in United States dollars. |
| hour_meter_start | integer | Hour meter start for the id_mining_fms_trucks record. |
+2 more columns in id_mining_fms_trucks. The full schema ships with the download.
id_mining_fms_truck_media· Rows: 12
| Column | Type | Description |
|---|---|---|
| truck_media_id | varchar(8) | Stable identifier for truck media; use it for declared joins. |
| truck_model_id | varchar(8) | Stable identifier for truck model; use it for declared joins. |
| image_file | varchar(24) | Image file for the id_mining_fms_truck_media record. |
| image_format | varchar(16) | Image format for the id_mining_fms_truck_media record. |
| image_width_px | integer | Image width px for the id_mining_fms_truck_media record. |
| image_height_px | integer | Image height px for the id_mining_fms_truck_media record. |
| equipment_view | varchar(24) | Equipment view for the id_mining_fms_truck_media record. |
+2 more columns in id_mining_fms_truck_media. The full schema ships with the download.
id_mining_fms_operators· Rows: 240
| Column | Type | Description |
|---|---|---|
| operator_id | varchar(16) | Stable identifier for operator; use it for declared joins. |
| mine_site_id | varchar(8) | Stable identifier for mine site; use it for declared joins. |
| operator_code | varchar(8) | Stable code for operator. |
| operator_name | varchar(24) | Human-readable operator name; names are fictional where the disclosure states so. |
| licence_class | varchar(32) | Licence class for the id_mining_fms_operators record. |
| experience_years | integer | Experience years for the id_mining_fms_operators record. |
| training_level | varchar(16) | Training level for the id_mining_fms_operators record. |
+3 more columns in id_mining_fms_operators. The full schema ships with the download.
id_mining_fms_shifts· Rows: 70,128
| Column | Type | Description |
|---|---|---|
| shift_id | varchar(16) | Stable identifier for shift; use it for declared joins. |
| mine_site_id | varchar(8) | Stable identifier for mine site; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| shift_date | date | shift date as an ISO 8601 calendar date. |
| shift_code | varchar(8) | Stable code for shift. |
| starts_at | varchar(32) | Starts at for the id_mining_fms_shifts record. |
| ends_at | varchar(32) | Ends at for the id_mining_fms_shifts record. |
+4 more columns in id_mining_fms_shifts. The full schema ships with the download.
id_mining_fms_dispatch_assignments· Rows: 29,357
| Column | Type | Description |
|---|---|---|
| dispatch_assignment_id | varchar(16) | Stable identifier for dispatch assignment; use it for declared joins. |
| shift_id | varchar(16) | Stable identifier for shift; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| operator_id | varchar(16) | Stable identifier for operator; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| assigned_at | varchar(32) | Assigned at for the id_mining_fms_dispatch_assignments record. |
| source_location_id | varchar(16) | Stable identifier for source location; use it for declared joins. |
+6 more columns in id_mining_fms_dispatch_assignments. The full schema ships with the download.
id_mining_fms_haul_cycles· Rows: 656,491
| Column | Type | Description |
|---|---|---|
| haul_cycle_id | varchar(16) | Stable identifier for haul cycle; use it for declared joins. |
| dispatch_assignment_id | varchar(16) | Stable identifier for dispatch assignment; use it for declared joins. |
| shift_id | varchar(16) | Stable identifier for shift; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| operator_id | varchar(16) | Stable identifier for operator; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| cycle_start | varchar(32) | Cycle start for the id_mining_fms_haul_cycles record. |
+13 more columns in id_mining_fms_haul_cycles. The full schema ships with the download.
id_mining_fms_payloads· Rows: 656,491
| Column | Type | Description |
|---|---|---|
| payload_id | varchar(16) | Stable identifier for payload; use it for declared joins. |
| haul_cycle_id | varchar(16) | Stable identifier for haul cycle; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| measured_payload_t | numeric(7,2) | Measured payload t for the id_mining_fms_payloads record. |
| target_payload_t | integer | Target payload t for the id_mining_fms_payloads record. |
| nominal_payload_t | integer | Nominal payload t for the id_mining_fms_payloads record. |
+6 more columns in id_mining_fms_payloads. The full schema ships with the download.
id_mining_fms_positions· Rows: 176,514
| Column | Type | Description |
|---|---|---|
| position_id | varchar(16) | Stable identifier for position; use it for declared joins. |
| haul_cycle_id | varchar(16) | Stable identifier for haul cycle; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| observed_at | varchar(32) | Observed at for the id_mining_fms_positions record. |
| latitude | numeric(8,5) | Latitude for the id_mining_fms_positions record. |
| longitude | numeric(10,5) | Longitude for the id_mining_fms_positions record. |
+6 more columns in id_mining_fms_positions. The full schema ships with the download.
id_mining_fms_delays· Rows: 58,926
| Column | Type | Description |
|---|---|---|
| delay_id | varchar(16) | Stable identifier for delay; use it for declared joins. |
| haul_cycle_id | varchar(16) | Stable identifier for haul cycle; use it for declared joins. |
| shift_id | varchar(16) | Stable identifier for shift; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| delay_started_at | varchar(32) | Delay started at for the id_mining_fms_delays record. |
| delay_ended_at | varchar(32) | Delay ended at for the id_mining_fms_delays record. |
+6 more columns in id_mining_fms_delays. The full schema ships with the download.
id_mining_fms_fuel_events· Rows: 31,488
| Column | Type | Description |
|---|---|---|
| fuel_event_id | varchar(16) | Stable identifier for fuel event; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| shift_id | varchar(16) | Stable identifier for shift; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| event_timestamp | varchar(32) | Event timestamp for the id_mining_fms_fuel_events record. |
| event_type | varchar(16) | Event type for the id_mining_fms_fuel_events record. |
| fuel_litre | integer | Fuel litre for the id_mining_fms_fuel_events record. |
+6 more columns in id_mining_fms_fuel_events. The full schema ships with the download.
id_mining_fms_tyre_events· Rows: 4,028
| Column | Type | Description |
|---|---|---|
| tyre_event_id | varchar(16) | Stable identifier for tyre event; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| shift_id | varchar(16) | Stable identifier for shift; 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. |
| wheel_position | varchar(24) | Wheel position for the id_mining_fms_tyre_events record. |
| event_type | varchar(16) | Event type for the id_mining_fms_tyre_events record. |
+6 more columns in id_mining_fms_tyre_events. The full schema ships with the download.
id_mining_fms_maintenance_events· Rows: 16,958
| Column | Type | Description |
|---|---|---|
| maintenance_event_id | varchar(16) | Stable identifier for maintenance event; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| opened_at | varchar(32) | Opened at for the id_mining_fms_maintenance_events record. |
| completed_at | varchar(32) | Completed at for the id_mining_fms_maintenance_events record. |
| maintenance_type | varchar(24) | Maintenance type for the id_mining_fms_maintenance_events record. |
| system_group | varchar(16) | System group for the id_mining_fms_maintenance_events record. |
+8 more columns in id_mining_fms_maintenance_events. The full schema ships with the download.
id_mining_fms_breakdowns· Rows: 704
| Column | Type | Description |
|---|---|---|
| breakdown_id | varchar(16) | Stable identifier for breakdown; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| shift_id | varchar(16) | Stable identifier for shift; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| breakdown_at | varchar(32) | Breakdown at for the id_mining_fms_breakdowns record. |
| system_group | varchar(16) | System group for the id_mining_fms_breakdowns record. |
| failure_mode | varchar(24) | Failure mode for the id_mining_fms_breakdowns record. |
+6 more columns in id_mining_fms_breakdowns. The full schema ships with the download.
id_mining_fms_safety_events· Rows: 374
| Column | Type | Description |
|---|---|---|
| safety_event_id | varchar(16) | Stable identifier for safety event; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| operator_id | varchar(16) | Stable identifier for operator; use it for declared joins. |
| shift_id | varchar(16) | Stable identifier for shift; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| event_at | varchar(32) | Event at for the id_mining_fms_safety_events record. |
| event_type | varchar(24) | Event type for the id_mining_fms_safety_events record. |
+7 more columns in id_mining_fms_safety_events. The full schema ships with the download.
id_mining_fms_shift_production· Rows: 70,128
| Column | Type | Description |
|---|---|---|
| shift_production_id | varchar(16) | Stable identifier for shift production; use it for declared joins. |
| shift_id | varchar(16) | Stable identifier for shift; use it for declared joins. |
| mine_site_id | varchar(8) | Stable identifier for mine site; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| completed_cycles | integer | Completed cycles for the id_mining_fms_shift_production record. |
| tonnes_moved | integer | Tonnes moved for the id_mining_fms_shift_production record. |
| tonne_km | integer | tonne in kilometres. |
+7 more columns in id_mining_fms_shift_production. The full schema ships with the download.
id_mining_fms_operating_costs· Rows: 17,280
| Column | Type | Description |
|---|---|---|
| operating_cost_id | varchar(16) | Stable identifier for operating cost; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| mine_site_id | varchar(8) | Stable identifier for mine 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_fms_operating_costs record. |
| fuel_cost_usd | numeric(10,2) | fuel cost in United States dollars. |
| maintenance_cost_usd | numeric(10,2) | maintenance cost in United States dollars. |
+7 more columns in id_mining_fms_operating_costs. The full schema ships with the download.
id_mining_fms_prediction_features· Rows: 17,280
| Column | Type | Description |
|---|---|---|
| prediction_feature_id | varchar(16) | Stable identifier for prediction feature; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| mine_site_id | varchar(8) | Stable identifier for mine site; 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. |
| rolling_cycle_minutes | numeric(6,2) | rolling cycle in minutes. |
+9 more columns in id_mining_fms_prediction_features. The full schema ships with the download.
id_mining_fms_cycle_predictions· Rows: 17,280
| Column | Type | Description |
|---|---|---|
| cycle_prediction_id | varchar(16) | Stable identifier for cycle prediction; use it for declared joins. |
| prediction_feature_id | varchar(16) | Stable identifier for prediction feature; use it for declared joins. |
| truck_id | varchar(16) | Stable identifier for truck; use it for declared joins. |
| mine_site_id | varchar(8) | Stable identifier for mine site; 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(24) | Model version for the id_mining_fms_cycle_predictions record. |
+9 more columns in id_mining_fms_cycle_predictions. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| operator_id | mine_site_id | operator_code | operator_name | licence_class | experience_years | training_level | fatigue_risk_band | fictional_person_flag |
|---|---|---|---|---|---|---|---|---|
| OPR00001 | SIT001 | OP0001 | Michael Lindqvist | HR_multi_combination | 20 | trainer | low | true |
| OPR00002 | SIT001 | OP0002 | David Santoso | HR_multi_combination | 13 | trainer | elevated | true |
| OPR00003 | SIT001 | OP0003 | Andrew Halim | HR_multi_combination | 15 | trainer | elevated | true |
Version History
| v2.0.1 | 2026-08-14 | Rebuilt from a simulation of the pit. Every shift at every mine is a row carrying what the fleet actually moved, haul cycles break into the seven times that sum to the cycle, and payloads sit against the rated payload of the truck that carried them under the industry 10/10/20 rule. Each site now plans the tonnage it moves rather than a few hundred tonnes a year against a pit shifting tens of millions, truck models carry the payload their render depicts, and the cost ledger reconciles to the hours and tonnes each machine ran. Fuel volumes in this revision are corrected: each truck burns litres per engine hour in the band its size class actually runs, so a recorded refuel puts back the burn of the shift it follows against a tank sized to the machine. |
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 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 Mining Tire Lifecycle and Predictive Maintenance Set (ID)
MiningA complete Indonesia 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