Offshore Platform Pump SCADA and Predictive Maintenance Set (ASIA)
ENGPMP928· 34K records · 21 tables · v1.0.0 · Updated 2026-08-12
Energy Oil & Gas Dataset API
Overview
This longitudinal offshore platform pump scada and predictive maintenance set connects operator, offshore platform, pump, sensor, SCADA, run, alarm, inspection, work order, part, failure, downtime, reliability, energy 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.
Meridian HX-379MOD001centrifugal multistage
1,472 m3/hRated flow
252 mRated head
1,380 kWPower
2,980 rpmRated speed
1 / 4
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| asia_offshore_pump_years | 12 |
| asia_offshore_pump_countries | 5 |
| asia_offshore_pump_operators | 4 |
| asia_offshore_pump_platforms | 12 |
| asia_offshore_pump_pump_models | 12 |
| asia_offshore_pump_pumps | 72 |
| asia_offshore_pump_pump_media | 12 |
| asia_offshore_pump_sensors | 504 |
| asia_offshore_pump_scada_hourly | 26,280 |
| asia_offshore_pump_operating_runs | 216 |
| asia_offshore_pump_alarm_events | 2,880 |
| asia_offshore_pump_inspections | 216 |
| asia_offshore_pump_maintenance_work_orders | 216 |
| asia_offshore_pump_parts | 72 |
| asia_offshore_pump_replacements | 216 |
| asia_offshore_pump_failures | 216 |
| asia_offshore_pump_downtime_costs | 216 |
| asia_offshore_pump_reliability_monthly | 1,728 |
| asia_offshore_pump_energy_performance | 216 |
| asia_offshore_pump_prediction_features | 288 |
| asia_offshore_pump_failure_predictions | 288 |
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.
asia_offshore_pump_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 asia_offshore_pump_years record. |
| period_start | date | Period start for the asia_offshore_pump_years record. |
| period_end | date | Period end for the asia_offshore_pump_years record. |
| source_status | varchar(32) | source status in the declared lifecycle or operational vocabulary. |
asia_offshore_pump_countries· Rows: 5
| 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. |
asia_offshore_pump_operators· Rows: 4
| Column | Type | Description |
|---|---|---|
| operator_id | varchar(16) | Stable identifier for operator; use it for declared joins. |
| operator_code | varchar(8) | Stable code for operator. |
| operator_name | varchar(32) | Human-readable operator name; names are fictional where the disclosure states so. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| operating_model | varchar(24) | operating model as the declared analytical measure. |
| fictional_entity_flag | boolean | Boolean indicator for fictional entity. |
asia_offshore_pump_platforms· Rows: 12
| Column | Type | Description |
|---|---|---|
| platform_id | varchar(16) | Stable identifier for platform; use it for declared joins. |
| operator_id | varchar(16) | Stable identifier for operator; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| platform_code | varchar(8) | Stable code for platform. |
| platform_name | varchar(24) | Human-readable platform name; names are fictional where the disclosure states so. |
| water_depth_m | numeric(8,2) | Water depth m for the asia_offshore_pump_platforms record. |
| production_type | varchar(16) | Production type for the asia_offshore_pump_platforms record. |
+3 more columns in asia_offshore_pump_platforms. The full schema ships with the download.
asia_offshore_pump_pump_models· Rows: 12
| Column | Type | Description |
|---|---|---|
| pump_model_id | varchar(16) | Stable identifier for pump 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. |
| pump_type | varchar(32) | Pump type for the asia_offshore_pump_pump_models record. |
| service_class | varchar(24) | Service class for the asia_offshore_pump_pump_models record. |
| api_610_type | varchar(16) | Api 610 type for the asia_offshore_pump_pump_models record. |
| rated_flow_m3h | integer | Rated flow m3h for the asia_offshore_pump_pump_models record. |
+4 more columns in asia_offshore_pump_pump_models. The full schema ships with the download.
asia_offshore_pump_pumps· Rows: 72
| Column | Type | Description |
|---|---|---|
| pump_id | varchar(16) | Stable identifier for pump; use it for declared joins. |
| platform_id | varchar(16) | Stable identifier for platform; use it for declared joins. |
| pump_model_id | varchar(16) | Stable identifier for pump model; use it for declared joins. |
| equipment_tag | varchar(16) | Equipment tag for the asia_offshore_pump_pumps record. |
| service_description | varchar(32) | Service description for the asia_offshore_pump_pumps record. |
| installed_date | date | installed date as an ISO 8601 calendar date. |
| criticality_class | varchar(16) | Criticality class for the asia_offshore_pump_pumps record. |
+4 more columns in asia_offshore_pump_pumps. The full schema ships with the download.
asia_offshore_pump_pump_media· Rows: 12
| Column | Type | Description |
|---|---|---|
| pump_media_id | varchar(16) | Stable identifier for pump media; use it for declared joins. |
| pump_model_id | varchar(16) | Stable identifier for pump model; use it for declared joins. |
| image_file | varchar(24) | Image file for the asia_offshore_pump_pump_media record. |
| image_format | varchar(16) | Image format for the asia_offshore_pump_pump_media record. |
| image_width_px | integer | Image width px for the asia_offshore_pump_pump_media record. |
| image_height_px | integer | Image height px for the asia_offshore_pump_pump_media record. |
| equipment_view | varchar(24) | Equipment view for the asia_offshore_pump_pump_media record. |
+2 more columns in asia_offshore_pump_pump_media. The full schema ships with the download.
asia_offshore_pump_sensors· Rows: 504
| Column | Type | Description |
|---|---|---|
| sensor_id | varchar(16) | Stable identifier for sensor; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; use it for declared joins. |
| sensor_tag | varchar(16) | Sensor tag for the asia_offshore_pump_sensors record. |
| measurement_type | varchar(24) | Measurement type for the asia_offshore_pump_sensors record. |
| unit | varchar(16) | Unit for the asia_offshore_pump_sensors record. |
| sampling_interval_seconds | integer | Sampling interval seconds for the asia_offshore_pump_sensors record. |
| alarm_low | numeric(7,2) | Alarm low for the asia_offshore_pump_sensors record. |
+4 more columns in asia_offshore_pump_sensors. The full schema ships with the download.
asia_offshore_pump_scada_hourly· Rows: 26,280
| Column | Type | Description |
|---|---|---|
| scada_hourly_id | varchar(16) | Stable identifier for scada hourly; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; use it for declared joins. |
| sensor_id | varchar(16) | Stable identifier for sensor; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| observation_timestamp | varchar(32) | Observation timestamp for the asia_offshore_pump_scada_hourly record. |
| operating_state | varchar(16) | operating state as the declared analytical measure. |
| process_value | numeric(8,2) | Process value for the asia_offshore_pump_scada_hourly record. |
+4 more columns in asia_offshore_pump_scada_hourly. The full schema ships with the download.
asia_offshore_pump_operating_runs· Rows: 216
| Column | Type | Description |
|---|---|---|
| operating_run_id | varchar(16) | Stable identifier for operating run; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| started_at | varchar(32) | Started at for the asia_offshore_pump_operating_runs record. |
| ended_at | varchar(32) | Ended at for the asia_offshore_pump_operating_runs record. |
| run_hours | integer | run in hours. |
| start_count | integer | Start count for the asia_offshore_pump_operating_runs record. |
+5 more columns in asia_offshore_pump_operating_runs. The full schema ships with the download.
asia_offshore_pump_alarm_events· Rows: 2,880
| Column | Type | Description |
|---|---|---|
| alarm_event_id | varchar(16) | Stable identifier for alarm event; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; use it for declared joins. |
| sensor_id | varchar(16) | Stable identifier for sensor; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| alarm_started_at | varchar(32) | Alarm started at for the asia_offshore_pump_alarm_events record. |
| alarm_ended_at | varchar(32) | Alarm ended at for the asia_offshore_pump_alarm_events record. |
| alarm_code | varchar(16) | Stable code for alarm. |
+5 more columns in asia_offshore_pump_alarm_events. The full schema ships with the download.
asia_offshore_pump_inspections· Rows: 216
| Column | Type | Description |
|---|---|---|
| inspection_id | varchar(16) | Stable identifier for inspection; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; 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. |
| inspection_type | varchar(32) | Inspection type for the asia_offshore_pump_inspections record. |
| vibration_rms_mms | numeric(6,2) | Vibration rms mms for the asia_offshore_pump_inspections record. |
| bearing_temperature_c | numeric(5,1) | Bearing temperature c for the asia_offshore_pump_inspections record. |
+6 more columns in asia_offshore_pump_inspections. The full schema ships with the download.
asia_offshore_pump_maintenance_work_orders· Rows: 216
| Column | Type | Description |
|---|---|---|
| work_order_id | varchar(16) | Stable identifier for work order; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| opened_date | date | opened date as an ISO 8601 calendar date. |
| completed_date | date | completed date as an ISO 8601 calendar date. |
| maintenance_strategy | varchar(16) | Maintenance strategy for the asia_offshore_pump_maintenance_work_orders record. |
| work_type | varchar(24) | Work type for the asia_offshore_pump_maintenance_work_orders record. |
+9 more columns in asia_offshore_pump_maintenance_work_orders. The full schema ships with the download.
asia_offshore_pump_parts· Rows: 72
| Column | Type | Description |
|---|---|---|
| part_id | varchar(16) | Stable identifier for part; use it for declared joins. |
| pump_model_id | varchar(16) | Stable identifier for pump model; use it for declared joins. |
| part_code | varchar(8) | Stable code for part. |
| part_name | varchar(24) | Human-readable part name; names are fictional where the disclosure states so. |
| part_group | varchar(16) | Part group for the asia_offshore_pump_parts record. |
| critical_spare_flag | boolean | Boolean indicator for critical spare. |
| unit_cost_usd | numeric(9,2) | unit cost in United States dollars. |
+3 more columns in asia_offshore_pump_parts. The full schema ships with the download.
asia_offshore_pump_replacements· Rows: 216
| Column | Type | Description |
|---|---|---|
| replacement_id | varchar(16) | Stable identifier for replacement; use it for declared joins. |
| work_order_id | varchar(16) | Stable identifier for work order; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; use it for declared joins. |
| part_id | varchar(16) | Stable identifier for part; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| replacement_date | date | replacement date as an ISO 8601 calendar date. |
| quantity | integer | Quantity for the asia_offshore_pump_replacements record. |
+4 more columns in asia_offshore_pump_replacements. The full schema ships with the download.
asia_offshore_pump_failures· Rows: 216
| Column | Type | Description |
|---|---|---|
| failure_id | varchar(16) | Stable identifier for failure; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; 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 asia_offshore_pump_failures record. |
| failure_mechanism | varchar(24) | Failure mechanism for the asia_offshore_pump_failures record. |
| detection_method | varchar(24) | Detection method for the asia_offshore_pump_failures record. |
+6 more columns in asia_offshore_pump_failures. The full schema ships with the download.
asia_offshore_pump_downtime_costs· Rows: 216
| Column | Type | Description |
|---|---|---|
| downtime_cost_id | varchar(16) | Stable identifier for downtime cost; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; use it for declared joins. |
| work_order_id | varchar(16) | Stable identifier for work order; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| production_loss_boe | integer | Production loss boe for the asia_offshore_pump_downtime_costs record. |
| deferred_revenue_usd | integer | deferred revenue in United States dollars. |
| intervention_cost_usd | integer | intervention cost in United States dollars. |
+4 more columns in asia_offshore_pump_downtime_costs. The full schema ships with the download.
asia_offshore_pump_reliability_monthly· Rows: 1,728
| Column | Type | Description |
|---|---|---|
| reliability_month_id | varchar(16) | Stable identifier for reliability month; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; 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 asia_offshore_pump_reliability_monthly record. |
| available_hours | integer | available in hours. |
| running_hours | integer | running in hours. |
| planned_downtime_hours | integer | planned downtime in hours. |
+7 more columns in asia_offshore_pump_reliability_monthly. The full schema ships with the download.
asia_offshore_pump_energy_performance· Rows: 216
| Column | Type | Description |
|---|---|---|
| energy_performance_id | varchar(16) | Stable identifier for energy performance; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; 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 asia_offshore_pump_energy_performance record. |
| throughput_m3 | integer | Throughput m3 for the asia_offshore_pump_energy_performance record. |
| power_consumption_mwh | numeric(6,1) | Power consumption mwh for the asia_offshore_pump_energy_performance record. |
| specific_energy_kwh_m3 | numeric(6,3) | Specific energy kwh m3 for the asia_offshore_pump_energy_performance record. |
+4 more columns in asia_offshore_pump_energy_performance. The full schema ships with the download.
asia_offshore_pump_prediction_features· Rows: 288
| Column | Type | Description |
|---|---|---|
| prediction_feature_id | varchar(16) | Stable identifier for prediction feature; use it for declared joins. |
| pump_id | varchar(16) | Stable identifier for pump; 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. |
| vibration_rms_7d | numeric(5,2) | Vibration rms 7d for the asia_offshore_pump_prediction_features record. |
| vibration_kurtosis_7d | numeric(5,2) | Vibration kurtosis 7d for the asia_offshore_pump_prediction_features record. |
+9 more columns in asia_offshore_pump_prediction_features. The full schema ships with the download.
asia_offshore_pump_failure_predictions· Rows: 288
| 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. |
| pump_id | varchar(16) | Stable identifier for pump; 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 asia_offshore_pump_failure_predictions record. |
| failure_probability_30d | numeric(7,4) | Failure probability 30d for the asia_offshore_pump_failure_predictions record. |
+8 more columns in asia_offshore_pump_failure_predictions. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| scada_hourly_id | pump_id | sensor_id | year_id | observation_timestamp | operating_state | process_value | setpoint_value | quality_code | alarm_state |
|---|---|---|---|---|---|---|---|---|---|
| SCA0000001 | PUM0000001 | SEN0000001 | Y2015 | 2015-10-19T00:00:00Z | running | 247.12 | 162.28 | GOOD | normal |
| SCA0000002 | PUM0000002 | SEN0000002 | Y2016 | 2016-02-03T00:00:00Z | running | 13.05 | 20 | UNCERTAIN | normal |
| SCA0000003 | PUM0000003 | SEN0000003 | Y2017 | 2017-10-20T00:00:00Z | running | 4.33 | 3.8 | BAD | normal |
Version History
| v1.0.0 | 2026-08-12 | First complete relational release with deterministic generation, media references, documentation and API schema. |
Related Datasets
Energy Generation and Consumption (ASIA)
EnergyAn Asian power sector dataset: eight markets, 502 plants across seven technologies, monthly generation, availability, fuel and wholesale prices, sector demand and 340,798 outage events from 2016 to mid 2026, with the decade's energy transition and the 2021 to 2022 fuel shock built into the series.
$149one time
View details Offshore Platform Pump SCADA and Predictive Maintenance Set (US)
EnergyA complete United States analytical warehouse covering operator, offshore platform, pump, sensor, SCADA, run, alarm, inspection, work order, part, failure, downtime, reliability, energy and prediction data.
$129one time
View details Oil and Gas Supply Chain (ME)
EnergyThe commercial liquids export chain of six Middle Eastern producer countries: 40 invented fields, 12 refineries, 10 export terminals, 53,626 cargoes cut into 80,260 priced parcels bound for ten named markets, with an invented benchmark price, tanker rates and exact chain reconciliation, monthly from 2016 to mid 2026.
$149one time
View details