Energy Asset Maintenance Scheduling
This dataset provides detailed logs of maintenance activities for energy assets in plants and field locations, capturing preventive and corrective schedules, work orders, downtime, costs, and safety incidents. It enables comprehensive analysis of asset reliability, maintenance efficiency, and operational impacts, supporting optimization of utility maintenance strategies and regulatory compliance.
Sample rows
preview · 8 of 200 rows · all 25 columns| asset_idstring | maintenance_typestring | cost_usdfloat | safety_incidentboolean | location_citystring | asset_namestring | asset_typestring | location_namestring | location_street_addressstring | location_statestring | location_postal_codestring | location_countrystring | work_order_idstring | scheduled_start_datetimedatetime | scheduled_end_datetimedatetime | actual_start_datetimedatetime | actual_end_datetimedatetime | downtime_minutesinteger | work_order_statusstring | maintenance_personnel_idstring | maintenance_personnel_namestring | parts_usedstring | maintenance_descriptionstring | reported_issuestring | safety_incident_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GEN-00127 | corrective | 3175.25 | false | Houston | North Plant Generator 1 | generator | North Power Plant | 3902 Energy Rd | TX | 77001 | USA | WO-100001 | 2023-03-14T09:00:00Z | 2023-03-14T17:00:00Z | 2023-03-14T09:22:00Z | 2023-03-14T16:45:00Z | 443 | completed | ENG-3238 | Ella Anderson | rotor, vibration sensor, mounting bolts | Replaced main rotor following electrical fault detected during operation. | Generator tripped due to excessive vibration alarm. | blank |
| TRF-08192 | preventive | 215.45 | false | Columbus | West Substation Transformer A | transformer | West Substation | 52 Grid Rd | OH | 43215 | USA | WO-100002 | 2023-04-20T10:00:00Z | 2023-04-20T13:00:00Z | 2023-04-20T10:07:00Z | 2023-04-20T12:42:00Z | 155 | completed | TECH-2217 | Derek Morales | bushings, transformer oil | Performed oil sampling and replaced bushings as scheduled. | blank | blank |
| PPL-04501 | predictive | 0 | false | El Paso | South Field Pipeline Main | pipeline | South Field | 8101 Valley Rd | TX | 79922 | USA | WO-100003 | 2023-04-25T07:30:00Z | 2023-04-25T11:00:00Z | blank | blank | 0 | scheduled | blank | blank | blank | Scheduled ultrasonic thickness measurements for corrosion monitoring. | blank | blank |
| SOL-30581 | preventive | 97.8 | false | Las Vegas | Solar Farm Panel Array 3 | solar_panel | Horizon Solar Farm | 900 Suncrest Dr | NV | 89124 | USA | WO-100004 | 2023-04-18T08:00:00Z | 2023-04-18T10:00:00Z | 2023-04-18T08:14:00Z | 2023-04-18T09:57:00Z | 103 | completed | TECH-1985 | Amelia Chen | cleaning fluid, microfiber cloth | Cleaned panel surfaces and checked inverter connections. | blank | blank |
| TRB-11014 | inspection | 54.9 | false | Rogaland | East Wind Turbine B | turbine | East Wind Facility | 1568 Turbine Rd | Rogaland | 4001 | NOR | WO-100005 | 2023-05-01T09:00:00Z | 2023-05-01T10:30:00Z | 2023-05-01T09:00:00Z | 2023-05-01T09:51:00Z | 51 | completed | CREW-401 | Turbine Inspection Team | blank | Visual inspection of blades and gearbox; no anomalies detected. | blank | blank |
| BAT-93211 | predictive | 355.15 | false | San Diego | Battery Storage Unit 2 | battery_storage | Grid Battery Hub | 215 Power Ave | CA | 92102 | USA | WO-100006 | 2023-05-11T13:00:00Z | 2023-05-11T15:00:00Z | 2023-05-11T13:07:00Z | 2023-05-11T14:12:00Z | 65 | completed | TEAM-PRD2 | Predictive Analytics Group | battery module | Battery module replacement triggered by predictive analytics. | blank | blank |
| VAL-02816 | corrective | 2389.7 | false | Tulsa | Midwest Pipeline Valve D | valve | Midwest Pipeline Station | 2801 Pump Station Rd | OK | 74101 | USA | WO-100007 | 2023-03-07T07:00:00Z | 2023-03-07T12:00:00Z | 2023-03-07T07:16:00Z | 2023-03-07T11:31:00Z | 255 | completed | ENG-4817 | Valve Service Crew | valve actuator, wiring harness | Replaced actuator after valve failed to respond to SCADA signals. | Actuator failure; valve not responding remotely. | blank |
| SWG-07129 | inspection | 31 | false | Phoenix | Switchgear Bay 7 | switchgear | South Plant Control Room | 1442 Gridline Blvd | AZ | 85009 | USA | WO-100008 | 2023-05-08T11:00:00Z | 2023-05-08T11:45:00Z | 2023-05-08T11:01:00Z | 2023-05-08T11:41:00Z | 40 | completed | TECH-3301 | Liam Jacobs | blank | Inspected contactors and relays; no visible wear observed. | blank | blank |
| GEN-00127 | preventive | 146.3 | false | Houston | North Plant Generator 1 | generator | North Power Plant | 3902 Energy Rd | TX | 77001 | USA | WO-100009 | 2023-06-10T08:00:00Z | 2023-06-10T12:30:00Z | 2023-06-10T08:13:00Z | 2023-06-10T12:21:00Z | 248 | completed | TECH-2250 | Brandon Lee | lubricant, coolant | Lubricated bearings and checked coolant levels according to maintenance plan. | blank | blank |
| TRB-11014 | corrective | 4211.8 | true | Rogaland | East Wind Turbine B | turbine | East Wind Facility | 1568 Turbine Rd | Rogaland | 4001 | NOR | WO-100010 | 2023-06-13T07:00:00Z | 2023-06-13T15:00:00Z | 2023-06-13T07:10:00Z | 2023-06-13T14:38:00Z | 448 | completed | TEAM-TRB2 | Wind Maintenance Team | gearbox, coolant fluid | Gearbox replaced after overheating event triggered shutdown. | High gearbox temperature alarm; automatic shutdown. | Minor hand injury during gearbox removal; first aid administered. |
| SOL-30581 | inspection | 41.5 | false | Las Vegas | Solar Farm Panel Array 3 | solar_panel | Horizon Solar Farm | 900 Suncrest Dr | NV | 89124 | USA | WO-100011 | 2023-06-18T10:00:00Z | 2023-06-18T11:00:00Z | 2023-06-18T10:02:00Z | 2023-06-18T10:39:00Z | 37 | completed | TECH-2014 | Oliver Grant | blank | Inspected panel connections and mounting hardware. | blank | blank |
| TRF-09218 | corrective | 2030.1 | false | Berlin | Central Substation Transformer C | transformer | Central Substation | 1290 Central Ave | BE | 10115 | DEU | WO-100012 | 2023-07-03T11:00:00Z | 2023-07-03T17:00:00Z | 2023-07-03T11:18:00Z | 2023-07-03T16:41:00Z | 323 | completed | ENG-TRF3 | Substation Maintenance Team | tap changer, relay contacts | Replaced failed tap changer; restored normal voltage regulation. | Tap changer failure; voltage fluctuation reported. | blank |
| SWG-07129 | preventive | 0 | false | Phoenix | Switchgear Bay 7 | switchgear | South Plant Control Room | 1442 Gridline Blvd | AZ | 85009 | USA | WO-100013 | 2023-07-08T09:00:00Z | 2023-07-08T11:00:00Z | blank | blank | 0 | scheduled | blank | blank | blank | Annual preventive inspection and cleaning scheduled. | blank | blank |
| BAT-93211 | inspection | 43.2 | false | San Diego | Battery Storage Unit 2 | battery_storage | Grid Battery Hub | 215 Power Ave | CA | 92102 | USA | WO-100014 | 2023-08-10T10:00:00Z | 2023-08-10T11:00:00Z | 2023-08-10T10:03:00Z | 2023-08-10T10:54:00Z | 51 | completed | TECH-2722 | Sophia Weber | blank | Visual inspection of all battery modules; checked for leakage. | blank | blank |
| PMP-01287 | inspection | 36.5 | false | Cincinnati | Pump Station 3A | pump | River Pump Station | 75 River Dr | OH | 45202 | USA | WO-100015 | 2023-07-12T08:30:00Z | 2023-07-12T09:15:00Z | 2023-07-12T08:33:00Z | 2023-07-12T09:04:00Z | 31 | completed | CREW-107 | Inspection Crew 3 | blank | Checked pump seals and flow meters; all parameters normal. | blank | blank |
| GEN-01345 | preventive | 168.2 | false | Dallas | West Plant Standby Generator | generator | West Standby Facility | 1203 Reserve Ln | TX | 75247 | USA | WO-100016 | 2023-08-15T09:00:00Z | 2023-08-15T13:00:00Z | 2023-08-15T09:14:00Z | 2023-08-15T12:44:00Z | 210 | completed | TECH-1589 | Michael Harris | air filter, testing cable | Tested generator under load and replaced air filters. | blank | blank |
| VAL-02816 | inspection | 28.9 | false | Tulsa | Midwest Pipeline Valve D | valve | Midwest Pipeline Station | 2801 Pump Station Rd | OK | 74101 | USA | WO-100017 | 2023-08-20T07:00:00Z | 2023-08-20T07:45:00Z | 2023-08-20T07:02:00Z | 2023-08-20T07:37:00Z | 35 | completed | TECH-3402 | Emma Johnson | blank | Inspected valve stem and actuator; no issues found. | blank | blank |
| GEN-00127 | corrective | 0 | false | Houston | North Plant Generator 1 | generator | North Power Plant | 3902 Energy Rd | TX | 77001 | USA | WO-100018 | 2023-09-02T12:00:00Z | 2023-09-02T18:00:00Z | blank | blank | 0 | scheduled | blank | blank | blank | Scheduled repair for detected coolant leak. | Coolant leak detected during operation. | blank |
| SOL-30999 | preventive | 91.6 | false | Las Vegas | Solar Farm Panel Array 8 | solar_panel | Horizon Solar Farm | 900 Suncrest Dr | NV | 89124 | USA | WO-100019 | 2023-08-22T07:00:00Z | 2023-08-22T09:00:00Z | 2023-08-22T07:09:00Z | 2023-08-22T08:52:00Z | 103 | completed | TECH-2175 | Lucas Price | cleaning agent, grease | Cleaned panel surfaces and checked all electrical connectors. | blank | blank |
| TRF-09218 | inspection | 39.2 | false | Berlin | Central Substation Transformer C | transformer | Central Substation | 1290 Central Ave | BE | 10115 | DEU | WO-100020 | 2023-09-11T10:30:00Z | 2023-09-11T11:30:00Z | 2023-09-11T10:31:00Z | 2023-09-11T11:17:00Z | 46 | completed | TECH-2885 | Stefan Hoffmann | blank | Inspection of transformer bushings and oil temperature. | blank | blank |
What the 200 rows show
from the 200-row sampleCorrective (maintenance type) stands out: mean cost_
- 6%safety_
incident = true - 98.9median cost_
usd - 3location countries
- 3work order statuses
- 10asset types
- 24location states
Median 98.9, from 0.0 to 4,789.
- string 18
- integer 1
- float 1
- datetime 4
- boolean 1
Columns
25 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 18 columns | |||
asset_id | string | Unique identifier for the energy asset (e.g., generator, transformer, pipeline). | GEN-00127 |
asset_name | string | Descriptive name of the asset. | North Plant Generator 1 |
asset_type | string | Type or category of the asset (e.g., turbine, substation, valve).10 types | generator |
location_name | string | Name or description of the asset's location (e.g., Plant A, Field 12).optional | North Power Plant |
location_street_address | string | Street address of the asset's location.optional | 3902 Energy Rd |
location_city | string | City where the asset is located.optional | Houston |
location_state | string | State or province where the asset is located.optional | TX |
location_postal_code | string | Postal code of the asset's location.optional | 77001 |
location_country | string | Country where the asset is located.3 countries · optional | USA |
work_order_id | string | Unique identifier for the maintenance work order.unique | WO-100001 |
maintenance_type | string | Type of maintenance performed (preventive, corrective, predictive, inspection).preventive · corrective · predictive · inspection | corrective |
work_order_status | string | Current status of the work order (scheduled, in_progress, completed, cancelled).scheduled · in_progress · completed · cancelled | completed |
maintenance_description | string | Detailed description of the maintenance activity performed.optional | Replaced main rotor follo… |
reported_issue | string | Description of the issue reported (for corrective maintenance).optional | Generator tripped due to … |
maintenance_personnel_id | string | Identifier for the personnel or team responsible for the maintenance.optional | ENG-3238 |
maintenance_personnel_name | string | Name of the personnel or team responsible for the maintenance.optional | Ella Anderson |
parts_used | string | Comma-separated list of parts or materials used during maintenance.optional | battery module |
safety_incident_description | string | Description of any safety incident that occurred.optional | Minor hand injury during … |
| Numbers 2 columns | |||
downtime_minutes | integer | Total downtime in minutes caused by the maintenance activity.0 or more · optional | 443 |
cost_usd | float | Total cost of the maintenance activity in USD.0 or more · optional | 3175.25 |
| Dates and times 4 columns | |||
scheduled_start_datetime | datetime | Scheduled start date and time for the maintenance activity. | 2023-03-14T09:00:00Z |
scheduled_end_datetime | datetime | Scheduled end date and time for the maintenance activity.optional | 2023-03-14T17:00:00Z |
actual_start_datetime | datetime | Actual start date and time of the maintenance activity.optional | 2023-03-14T09:22:00Z |
actual_end_datetime | datetime | Actual end date and time of the maintenance activity.optional | 2023-03-14T16:45:00Z |
| True or false 1 column | |||
safety_incident | boolean | Indicates if a safety incident occurred during maintenance.optional | false |
Use it for
An energy dashboard
The safety_
incident rate, cost_ usd by maintenance_ type and a breakdown of location_ city. Excel, Power BI or Tableau. Why do the 54 corrective rows have a mean cost_
usd of 2,342? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Assets200GEN-001273175.25correcti…TRB-110144211.8correcti…PPL-045013877.5correcti…
A software demo
Believable assets with asset_
name, asset_ type and location_ name to fill a screen in front of a buyer.
blueprint · energy-asset-maintenance-scheduling
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 25 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Assets categorized by plant and function
- Preventive tasks scheduled quarterly
- Downtime associated with work orders
- Spare part usage recorded
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- energy-asset-maintenance-scheduling