Substation Automation and IED Data
This dataset provides comprehensive, time-stamped records of Intelligent Electronic Device (IED) operations within digital substations, including relay settings, fault events, system logs, and IEC 61850 GOOSE message exchanges. It enables detailed analysis of substation automation, operational reliability, and event traceability for power grid monitoring and optimization.
Sample rows
preview · 8 of 105 rows · all 27 columns| ied_idstring | ied_manufacturerstring | fault_current_peakfloat | substation_namestring | substation_idstring | ied_modelstring | ied_firmware_versionstring | relay_setting_idstring | relay_typestring | relay_setting_valuefloat | relay_setting_unitstring | relay_setting_timestampdatetime | fault_record_idstring | fault_typestring | fault_start_timedatetime | fault_end_timedatetime | fault_duration_secondsfloat | event_log_idstring | event_typestring | event_timestampdatetime | goose_message_idstring | goose_publisher_ied_idstring | goose_subscriber_ied_idstring | goose_message_typestring | goose_message_timestampdatetime | event_descriptionstring | goose_message_payloadstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| IED-000001 | Schweitzer Engineering Labs | 2380.2 | Green Valley | SS-001 | SEL-751A | FW-3.21 | RS-00001 | overcurrent | 1168.7 | A | 2024-04-01T08:10:00Z | FR-00001 | phase-to-ground | 2024-04-01T08:18:27Z | 2024-04-01T08:19:45Z | 78 | EL-00001 | trip | 2024-04-01T08:19:50Z | GM-00001 | IED-000001 | IED-000002 | trip | 2024-04-01T08:19:52Z | Trip due to phase-to-ground fault detected by overcurrent relay. | GOOSE trip: phase-to-ground fault, relay tripped. |
| IED-000002 | ABB | 1450.7 | Central City | SS-002 | ABB-REF615 | FW-2.14 | RS-00002 | distance | 9.3 | Ohm | 2024-04-02T09:00:00Z | FR-00002 | three-phase | 2024-04-02T09:07:18Z | 2024-04-02T09:08:01Z | 43 | EL-00002 | alarm | 2024-04-02T09:08:04Z | GM-00002 | IED-000002 | IED-000003 | block | 2024-04-02T09:08:06Z | Alarm: abnormal impedance detected by distance relay. | GOOSE block: distance relay blocking due to alarm. |
| IED-000003 | General Electric | 1950.5 | Southpoint | SS-003 | GE-869 | FW-1.87 | RS-00003 | differential | 0.075 | A | 2024-04-03T10:15:00Z | FR-00003 | three-phase | 2024-04-03T10:17:33Z | 2024-04-03T10:17:56Z | 23 | EL-00003 | trip | 2024-04-03T10:18:00Z | GM-00003 | IED-000003 | IED-000004 | trip | 2024-04-03T10:18:02Z | Trip: three-phase fault detected by differential relay. | GOOSE trip: three-phase differential fault. |
| IED-000004 | Schweitzer Engineering Labs | 800.1 | Green Valley | SS-001 | SEL-710 | FW-2.90 | RS-00004 | voltage | 122.7 | V | 2024-04-04T11:00:00Z | FR-00004 | phase-to-ground | 2024-04-04T11:09:13Z | 2024-04-04T11:10:15Z | 62 | EL-00004 | alarm | 2024-04-04T11:10:20Z | GM-00004 | IED-000004 | blank | status | 2024-04-04T11:10:22Z | Alarm: undervoltage detected, phase-to-ground fault. | GOOSE status: undervoltage alarm phase-to-ground. |
| IED-000005 | Mitsubishi Electric | 50.2 | Hillcrest | SS-004 | Mitsubishi-PRG600 | blank | RS-00005 | frequency | 49.98 | Hz | 2024-04-05T12:10:00Z | FR-00005 | other | 2024-04-05T12:15:27Z | 2024-04-05T12:15:41Z | 14 | EL-00005 | reset | 2024-04-05T12:15:45Z | GM-00005 | IED-000005 | blank | status | 2024-04-05T12:15:47Z | Reset: frequency fault cleared, relay reset. | GOOSE status: frequency relay reset. |
| IED-000006 | Siemens | 1700.4 | Riverbend | SS-005 | Siemens-7SJ85 | FW-4.51 | RS-00006 | distance | 0 | Ohm | 2024-04-06T13:05:00Z | FR-00006 | phase-to-phase | 2024-04-06T13:10:44Z | 2024-04-06T13:11:20Z | 36 | EL-00006 | alarm | 2024-04-06T13:11:25Z | GM-00006 | IED-000006 | IED-000007 | block | 2024-04-06T13:11:27Z | Alarm: zero impedance detected by distance relay. | GOOSE block: distance relay zero impedance alarm. |
| IED-000007 | Schweitzer Engineering Labs | blank | Eastfield | SS-006 | SEL-351S | FW-5.03 | RS-00007 | other | -8.7 | A | 2024-04-07T14:30:00Z | FR-00007 | other | 2024-04-07T14:32:13Z | blank | blank | EL-00007 | test | 2024-04-07T14:32:16Z | GM-00007 | IED-000007 | blank | other | 2024-04-07T14:32:18Z | Test: relay type other, negative setting for edge case. | blank |
| IED-000008 | ABB | 2001.8 | North Ridge | SS-007 | ABB-REL670 | FW-3.08 | RS-00008 | distance | 16.9 | Ohm | 2024-04-08T15:10:00Z | FR-00008 | phase-to-phase | 2024-04-08T15:16:59Z | 2024-04-08T15:17:22Z | 23 | EL-00008 | alarm | 2024-04-08T15:17:25Z | GM-00008 | IED-000008 | IED-000009 | block | 2024-04-08T15:17:27Z | Alarm: distance relay phase-to-phase fault detected. | GOOSE block: phase-to-phase distance fault. |
| IED-000009 | Eaton | blank | Westwood | SS-008 | Eaton-F60 | FW-1.72 | RS-00009 | differential | 0.043 | A | 2024-04-09T16:00:00Z | FR-00009 | three-phase | 2024-04-09T16:07:39Z | blank | blank | EL-00009 | reset | 2024-04-09T16:07:45Z | GM-00009 | IED-000009 | blank | status | 2024-04-09T16:07:47Z | Reset: differential relay three-phase fault cleared. | GOOSE status: differential relay reset. |
| IED-000010 | Schneider Electric | 99.6 | Hillcrest | SS-009 | Schneider-PowerLogic | FW-2.17 | RS-00010 | frequency | 60.01 | Hz | 2024-04-10T17:20:00Z | FR-00010 | other | 2024-04-10T17:28:11Z | 2024-04-10T17:28:33Z | 22 | EL-00010 | alarm | 2024-04-10T17:28:35Z | GM-00010 | IED-000010 | IED-000011 | status | 2024-04-10T17:28:37Z | Alarm: frequency relay abnormal value, fault type other. | GOOSE status: frequency relay alarm. |
| IED-000011 | General Electric | 1560.9 | Meadowbrook | SS-010 | GE-B90 | FW-3.07 | RS-00011 | differential | 0.087 | A | 2024-04-11T18:00:00Z | FR-00011 | other | 2024-04-11T18:06:29Z | 2024-04-11T18:07:01Z | 32 | EL-00011 | trip | 2024-04-11T18:07:03Z | GM-00011 | IED-000011 | IED-000012 | trip | 2024-04-11T18:07:05Z | Trip: differential relay detected an other fault. | GOOSE trip: differential relay other fault. |
| IED-000012 | Siemens | 2100.3 | Central City | SS-011 | Siemens-7UT612 | FW-4.03 | RS-00012 | distance | 24.7 | Ohm | 2024-04-12T19:10:00Z | FR-00012 | phase-to-phase | 2024-04-12T19:16:15Z | 2024-04-12T19:17:00Z | 45 | EL-00012 | alarm | 2024-04-12T19:17:05Z | GM-00012 | IED-000012 | IED-000013 | block | 2024-04-12T19:17:07Z | Alarm: Siemens distance relay phase-to-phase fault. | GOOSE block: Siemens relay phase-to-phase. |
| IED-000013 | Schweitzer Engineering Labs | 2450.8 | Green Valley | SS-001 | SEL-710-5 | FW-3.92 | RS-00013 | overcurrent | 1521.4 | A | 2024-04-13T20:00:00Z | FR-00013 | phase-to-ground | 2024-04-13T20:07:27Z | 2024-04-13T20:08:19Z | 52 | EL-00013 | trip | 2024-04-13T20:08:22Z | GM-00013 | IED-000013 | IED-000014 | trip | 2024-04-13T20:08:24Z | Trip: overcurrent relay phase-to-ground fault. | GOOSE trip: phase-to-ground overcurrent. |
| IED-000014 | Schneider Electric | blank | Southpoint | SS-012 | Schneider-MiCOM | blank | RS-00014 | other | 99999.99 | V | 2024-04-14T21:10:00Z | FR-00014 | other | 2024-04-14T21:15:44Z | blank | blank | EL-00014 | other | 2024-04-14T21:15:47Z | GM-00014 | IED-000014 | blank | other | 2024-04-14T21:15:49Z | Other: MiCOM relay with extreme setting value. | blank |
| IED-000015 | Mitsubishi Electric | 1120.3 | Lakeview | SS-013 | Mitsubishi-MR600 | FW-2.95 | RS-00015 | voltage | 220 | V | 2024-04-15T22:00:00Z | FR-00015 | phase-to-ground | 2024-04-15T22:07:13Z | 2024-04-15T22:07:55Z | 42 | EL-00015 | alarm | 2024-04-15T22:07:59Z | GM-00015 | IED-000015 | IED-000016 | status | 2024-04-15T22:08:01Z | Alarm: Mitsubishi voltage relay phase-to-ground fault. | GOOSE status: voltage relay phase-to-ground. |
| IED-000016 | Eaton | 1800.6 | Green Valley | SS-014 | Eaton-FT80 | FW-2.56 | RS-00016 | differential | 0.015 | A | 2024-04-16T23:10:00Z | FR-00016 | three-phase | 2024-04-16T23:16:33Z | 2024-04-16T23:16:47Z | 14 | EL-00016 | reset | 2024-04-16T23:16:51Z | GM-00016 | IED-000016 | blank | status | 2024-04-16T23:16:53Z | Reset: differential relay three-phase fault cleared. | GOOSE status: differential relay reset. |
| IED-000017 | ABB | 1650.2 | Central City | SS-015 | ABB-REF620 | FW-3.00 | RS-00017 | distance | 7.8 | Ohm | 2024-04-17T08:00:00Z | FR-00017 | phase-to-phase | 2024-04-17T08:08:09Z | 2024-04-17T08:08:27Z | 18 | EL-00017 | alarm | 2024-04-17T08:08:30Z | GM-00017 | IED-000017 | IED-000018 | status | 2024-04-17T08:08:32Z | Alarm: ABB distance relay phase-to-phase fault. | GOOSE status: distance relay alarm. |
| IED-000018 | Siemens | 2690.3 | Southpoint | SS-016 | Siemens-7SJ80 | FW-4.71 | RS-00018 | overcurrent | 1780.6 | A | 2024-04-18T09:20:00Z | FR-00018 | phase-to-ground | 2024-04-18T09:27:18Z | 2024-04-18T09:28:09Z | 51 | EL-00018 | trip | 2024-04-18T09:28:13Z | GM-00018 | IED-000018 | IED-000019 | trip | 2024-04-18T09:28:15Z | Trip: Siemens overcurrent relay detected phase-to-ground fault. | GOOSE trip: Siemens overcurrent relay phase-to-ground. |
| IED-000019 | Schweitzer Engineering Labs | blank | Westwood | SS-017 | SEL-787 | blank | RS-00019 | voltage | 0.01 | V | 2024-04-19T10:30:00Z | FR-00019 | other | 2024-04-19T10:32:32Z | blank | blank | EL-00019 | other | 2024-04-19T10:32:36Z | GM-00019 | IED-000019 | blank | other | 2024-04-19T10:32:39Z | Other: SEL voltage relay with low setting, fault unresolved. | blank |
| IED-000020 | General Electric | 1701.7 | North Ridge | SS-018 | GE-C90Plus | FW-1.65 | RS-00020 | differential | 0.03 | A | 2024-04-20T11:00:00Z | FR-00020 | three-phase | 2024-04-20T11:07:41Z | 2024-04-20T11:08:13Z | 32 | EL-00020 | trip | 2024-04-20T11:08:17Z | GM-00020 | IED-000020 | IED-000021 | trip | 2024-04-20T11:08:19Z | Trip: GE differential relay detected three-phase fault. | GOOSE trip: GE differential relay three-phase. |
What the 105 rows show
from the 105-row sampleSchneider Electric (ied manufacturer) stands out: mean fault_
- 1,430median fault_
current_ peak - 4relay setting units
- 4fault types
- 4goose message types
- 5event types
- 6relay types
Median 1,430, from 0.0 to 2,690.
- string 19
- float 3
- datetime 5
Columns
27 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 19 columns | |||
ied_id | string | Unique identifier for the Intelligent Electronic Device (IED)unique | IED-000001 |
substation_id | string | Unique identifier for the substation where the IED is located | SS-001 |
substation_name | string | Name of the substation | Green Valley |
ied_model | string | Model name or number of the IED | SEL-751A |
ied_manufacturer | string | Manufacturer of the IED7 manufacturers | ABB |
ied_firmware_version | string | Firmware version running on the IEDoptional | FW-3.21 |
relay_setting_id | string | Unique identifier for the protective relay setting recordunique | RS-00001 |
relay_type | string | Type of protective relay (e.g., overcurrent, distance, differential)6 values | overcurrent |
relay_setting_unit | string | Unit of measurement for the relay setting value (e.g., A, V, s)4 units | A |
fault_record_id | string | Unique identifier for the fault recordunique | FR-00001 |
fault_type | string | Type of fault detected (e.g., phase-to-ground, phase-to-phase)phase-to-ground · phase-to-phase · three-phase · other | phase-to-ground |
event_log_id | string | Unique identifier for the event log entryunique | EL-00001 |
event_type | string | Type of event (e.g., trip, alarm, reset, test)trip · alarm · reset · test · other | trip |
event_description | string | Detailed description of the eventoptional | Trip due to phase-to-grou… |
goose_message_id | string | Unique identifier for the IEC 61850 GOOSE messageunique | GM-00001 |
goose_publisher_ied_id | string | IED ID of the publisher of the GOOSE message | IED-000001 |
goose_subscriber_ied_id | string | IED ID of the subscriber of the GOOSE messageoptional | IED-000002 |
goose_message_type | string | Type of GOOSE message (e.g., trip, block, status)trip · block · status · other | trip |
goose_message_payload | string | Payload or content of the GOOSE message (as a string)optional | GOOSE trip: phase-to-grou… |
| Numbers 3 columns | |||
relay_setting_value | float | Configured value for the relay setting | 1168.7 |
fault_duration_seconds | float | Duration of the fault in seconds0 or more · optional | 78 |
fault_current_peak | float | Peak current measured during the fault (in Amperes)0 or more · optional | 2380.2 |
| Dates and times 5 columns | |||
relay_setting_timestamp | datetime | Date and time when the relay setting was applied | 2024-04-01T08:10:00Z |
fault_start_time | datetime | Timestamp when the fault started | 2024-04-01T08:18:27Z |
fault_end_time | datetime | Timestamp when the fault endedoptional | 2024-04-01T08:19:45Z |
event_timestamp | datetime | Date and time when the event occurred | 2024-04-01T08:19:50Z |
goose_message_timestamp | datetime | Timestamp when the GOOSE message was sent | 2024-04-01T08:19:52Z |
Use it for
An energy dashboard
Fault_
current_ peak by ied_ manufacturer and a breakdown of substation_ name. Excel, Power BI or Tableau. Why do the 11 Schneider Electric rows have a mean fault_
current_ peak of 88.4? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Ieds105IED-0000012380.2Schweitz…IED-0000021450.7ABBIED-0000031950.5General …
A software demo
Believable ieds with substation_
id, substation_ name and ied_ model to fill a screen in front of a buyer.
blueprint · substation-automation-and-ied-data
Behind this dataset
Same schema. As many rows as you need.
These 105 rows came out of a blueprint — 27 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.
- IED ID unique per device
- Device type: protective relay, RTU, merging unit, bay controller
- Communication protocol: IEC 61850, DNP3, Modbus, IEC 60870-5-104
- GOOSE (Generic Object-Oriented Substation Event) messages
- Sampled Values (SV) for process bus architecture
- Fault records with oscillography data
- Sequence of events (SOE) with sub-second timestamps
- Relay settings: pickup, time delay, coordination curves
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
- substation-automation-and-ied-data