Distribution Automation and Feeder Remote Terminal Units
This dataset provides comprehensive SCADA event records from distribution feeder RTUs, detailing recloser operations, capacitor bank switching, voltage regulator tap changes, and automation scheme actions. It includes device-level measurements, event metadata, and operational context, enabling advanced grid analytics, reliability studies, and automation performance tracking for electric utilities.
Sample rows
preview · 8 of 120 rows · all 18 columns| rtu_idstring | device_typestring | operation_valuefloat | event_typestring | feeder_idstring | location_namestring | latitudefloat | longitudefloat | event_idstring | event_timestampdatetime | device_idstring | operation_statusstring | voltagefloat | currentfloat | power_factorfloat | automation_scheme_idstring | operator_idstring | remarksstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RTU001 | recloser | blank | recloser_operation | FD10001 | Central Substation | 34.0522 | -118.2437 | EVT202401001 | 2024-01-12T08:30:10 | RECL-001 | open | 12345 | 245.7 | 0.97 | AS001 | SYS_TRIG | Routine open sequence, triggered by automation |
| RTU002 | capacitor_bank | 320.5 | capacitor_bank_switching | FD10002 | Downtown Commercial | 40.7128 | -74.006 | EVT202401002 | 2024-01-13T09:15:22 | CAPB-002 | switched | 12860 | 370.1 | 0.89 | AS002 | SCADA_CORE | Automated kVAR adjustment due to peak load |
| RTU003 | voltage_regulator | 8 | voltage_regulator_tap | FD10003 | Remote Rural Site | 47.6062 | -122.3321 | EVT202401003 | 2024-01-15T19:22:46 | VREG-003 | tap_changed | 12110 | 62.5 | 0.74 | blank | OP101 | Manual tap adjustment for seasonal voltage |
| RTU004 | capacitor_bank | 480 | capacitor_bank_switching | FD10001 | Industrial Park North | 35.6895 | 139.6917 | EVT202401004 | 2024-01-16T13:44:08 | CAPB-004 | switched | 13200 | 405 | 0.93 | AS003 | OP102 | High kVAR switching, industrial backup required |
| RTU005 | voltage_regulator | 2 | voltage_regulator_tap | FD10004 | Suburban Block | 33.4484 | -112.074 | EVT202401005 | 2024-01-18T21:02:35 | VREG-005 | tap_changed | 12950 | 82.3 | 0.91 | blank | OP103 | Routine tap change, mid-range seasonal adjustment |
| RTU006 | recloser | blank | recloser_operation | FD10005 | Offshore Wind Hub | 51.5074 | 0.1278 | EVT202401006 | 2024-01-19T00:00:00 | RECL-006 | closed | 13490 | 199.9 | 0.99 | blank | OP104 | Boundary recloser closure, edge case |
| RTU007 | capacitor_bank | 410.2 | capacitor_bank_switching | FD10002 | Medical Campus East | 42.3601 | -71.0589 | EVT202401007 | 2024-01-20T05:18:27 | CAPB-007 | switched | 12680 | 366.4 | 0.84 | AS004 | SYS_AUTO | Backup capacitor bank switching |
| RTU008 | voltage_regulator | 16 | voltage_regulator_tap | FD10006 | blank | -90 | 180 | EVT202401008 | 2024-01-21T23:59:59 | VREG-008 | tap_changed | 99999 | 999.9 | -1 | blank | OP999 | Outlier event, boundary voltage and current |
| RTU009 | recloser | blank | automation_scheme_action | FD10007 | Secondary Substation | 37.7749 | -122.4194 | EVT202401009 | 2024-01-22T07:46:21 | RECL-009 | open | 12450 | 132.6 | 0.88 | AS005 | SYS_TRIG | Scheme action: recloser open, automated |
| RTU010 | voltage_regulator | 4 | voltage_regulator_tap | FD10008 | Data Center South | 29.7604 | -95.3698 | EVT202401010 | 2024-01-23T13:41:56 | VREG-010 | tap_changed | 12580 | 126.8 | 0.87 | AS006 | OP105 | Infrastructure tap change during daytime load |
| RTU011 | recloser | blank | recloser_operation | FD10003 | blank | blank | blank | EVT202401011 | 2024-01-24T11:23:45 | RECL-011 | closed | 0 | 0 | 1 | blank | OP106 | Edge case: null location and zero readings |
| RTU012 | voltage_regulator | 6 | voltage_regulator_tap | FD10009 | Suburban Secondary | 39.7392 | -104.9903 | EVT202401012 | 2024-01-25T16:18:30 | VREG-012 | tap_changed | 12050 | 79.9 | 0.92 | blank | OP107 | Routine adjustment for suburban block |
| RTU013 | recloser | blank | recloser_operation | FD10010 | Urban Primary | 41.8781 | -87.6298 | EVT202401013 | 2024-01-26T22:16:40 | RECL-013 | open | 12730 | 245.3 | 0.99 | AS007 | SCADA_CORE | Automated open sequence in urban feeder |
| RTU014 | capacitor_bank | 510.9 | capacitor_bank_switching | FD10011 | Industrial Park West | 48.8566 | 2.3522 | EVT202401014 | 2024-01-27T14:30:03 | CAPB-014 | switched | 13460 | 390.8 | 0.86 | AS008 | SYS_AUTO | Industrial kVAR switching operation |
| RTU015 | recloser | blank | recloser_operation | FD10012 | Secondary | 32.7157 | -117.1611 | EVT202401015 | 2024-01-28T08:05:17 | RECL-015 | closed | 13020 | 310.2 | 0.94 | blank | OP108 | Manual recloser closure during morning hours |
| RTU016 | capacitor_bank | 9999.9 | capacitor_bank_switching | FD10013 | blank | 90 | -180 | EVT202401016 | 2024-01-29T15:50:36 | CAPB-016 | switched | 99999 | 999.9 | 1 | blank | SCADA_CORE | Outlier: test of upper bounds on capacitor bank |
| RTU017 | voltage_regulator | 10 | voltage_regulator_tap | FD10010 | Medical Campus West | 45.5017 | -73.5673 | EVT202401017 | 2024-01-30T07:11:49 | VREG-017 | tap_changed | 12670 | 160.3 | 0.85 | blank | OP109 | Seasonal tap adjustment for medical campus |
| RTU018 | recloser | blank | recloser_operation | FD10014 | Urban North | 36.1627 | -86.7816 | EVT202401018 | 2024-01-31T17:39:12 | RECL-018 | open | 13300 | 398.4 | 0.96 | AS009 | SYS_TRIG | Automated open operation, urban feeder |
| RTU019 | capacitor_bank | blank | automation_scheme_action | FD10015 | Remote Boundary Site | -45 | 179.9 | EVT202401019 | 2024-02-01T18:44:55 | CAPB-019 | switched | 0 | 0 | -0.5 | AS010 | SYS_TRIG | Boundary event, automation scheme test |
| RTU020 | voltage_regulator | 5 | voltage_regulator_tap | FD10016 | Suburban Block East | 38.9072 | -77.0369 | EVT202401020 | 2024-02-02T11:21:13 | VREG-020 | tap_changed | 12430 | 99.8 | 0.79 | blank | OP110 | Routine tap adjustment, suburban feeder |
What the 120 rows show
from the 120-row sample- 16.0median operation_
value - 4operation statuses
- 12,770median voltage
- 151.4median current
- 0.89median power_
factor
Median 16.0, from 0.0 to 10,000.
- string 11
- float 6
- datetime 1
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
rtu_id | string | Unique identifier for the feeder Remote Terminal Unit (RTU)unique | RTU001 |
feeder_id | string | Unique identifier for the feeder circuit associated with the RTU | FD10001 |
location_name | string | Name or description of the RTU installation locationoptional | Central Substation |
event_id | string | Unique identifier for the SCADA event recorded by the RTUunique | EVT202401001 |
event_type | string | Type of event (e.g., recloser_operation, capacitor_bank_switching, voltage_regulator_tap, automation_scheme_action)4 values | recloser_operation |
device_id | string | Unique identifier for the device involved in the event (e.g., recloser, capacitor bank, voltage regulator) | RECL-001 |
device_type | string | Type of device involved (e.g., recloser, capacitor_bank, voltage_regulator)recloser · capacitor_bank · voltage_regulator | recloser |
operation_status | string | Status of the operation (e.g., open, closed, switched, tap_changed)open · closed · switched · tap_changed | open |
automation_scheme_id | string | Identifier for the distribution automation scheme involved in the eventoptional | AS001 |
operator_id | string | Identifier for the operator or system that initiated the eventoptional | SYS_TRIG |
remarks | string | Additional notes or remarks about the eventoptional | Seasonal tap reset |
| Numbers 6 columns | |||
latitude | float | Latitude coordinate of the RTU location-90 to 90 · optional | 34.0522 |
longitude | float | Longitude coordinate of the RTU location-180 to 180 · optional | -118.2437 |
operation_value | float | Value associated with the operation (e.g., tap position, switched kVAR, etc.)optional | 320.5 |
voltage | float | Measured voltage at the time of event (in volts)0 or more · optional | 12345 |
current | float | Measured current at the time of event (in amperes)0 or more · optional | 245.7 |
power_factor | float | Measured power factor at the time of event-1 to 1 · optional | 0.97 |
| Dates and times 1 column | |||
event_timestamp | datetime | Date and time when the event occurred | 2024-01-12T08:30:10 |
Use it for
An energy dashboard
Operation_
value by device_ type and a breakdown of event_ type. Excel, Power BI or Tableau. What pattern can you find in 120 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 120 rows.
- Rtus120RTU001recloserRTU002320.5capacito…RTU0038voltage_…
A software demo
Believable rtus with feeder_
id, location_ name and latitude to fill a screen in front of a buyer.
blueprint · distribution-automation-and-feeder-remote-terminal-units
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 18 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.
- RTU ID and feeder identification
- Recloser operations: open, close, lockout
- Recloser shot count for maintenance prediction
- Capacitor bank status: in-service, out-of-service
- Voltage regulator tap position
- Feeder head voltage and current
- Load profile at feeder level
- Fault indicators: permanent vs temporary faults
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
- distribution-automation-and-feeder-remote-terminal-units