
Transmission Outage Tickets
PJM's Transmission Facilities Outage List (TFOL): one row per outaged facility per outage ticket, covering active, scheduled, and planned transmission outages across the footprint.
Overview
Each row carries the zone, facility type, station, voltage, equipment, status, outage type, cause, reschedule count, first scheduled start, submission time, and PJM's at-risk flag. event_time is the outage start and end_time its scheduled end. PJM republishes the whole list about every five minutes, and published_at is the report's own generation stamp. A reschedule writes a new row under the new start time, so a ticket's current state is its row with the newest published_at, not the newest row or the latest start. status separates a request (Received) from a commitment (Approved, Active). PJM withholds market-sensitive tickets before publication, so a facility missing from this list is not proof that it is in service. A scheduled outage does not by itself establish that a constraint will bind or that prices will separate. Source: PJM eDART.
Query contract
Analysis rules
Schema24
event_timeDateTime64(6, 'UTC')end_timeDateTime64(6, 'UTC')published_atDateTime64(6, 'UTC')ticketLowCardinality(String)zoneLowCardinality(String)facility_typeLowCardinality(String)stationLowCardinality(String)voltage_kvNullable(Float64)equipmentStringfacilityStringstatusLowCardinality(String)prev_statusLowCardinality(String)outage_typeLowCardinality(String)causeStringopen_closedLowCardinality(String)recallLowCardinality(String)rtepBoolat_riskBoolon_timeBoolreschedule_countInt32first_startNullable(DateTime64(6, 'UTC'))submitted_atNullable(DateTime64(6, 'UTC'))last_evaluatedNullable(DateTime64(6, 'UTC'))ingested_atDateTime64(6, 'UTC')Sample data
| event_time | end_time | published_at | ticket | zone | facility_type | station | voltage_kv | equipment | facility | status | prev_status | outage_type | cause | open_closed | recall | rtep | at_risk | on_time | reschedule_count | first_start | submitted_at | last_evaluated | ingested_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2059-03-01 14:30:00.000000 | 2059-06-15 20:00:00.000000 | 2026-09-19 01:48:29.000000 | 987691 | DOM-C | LINE | NANNA4 | 500 | NANNA4 -MIDLOTH 576A | LINE NANNA4 500 KV NANNA4 -MIDLOTH 576A | Received | Submitted | Continuous | OUTAGE REQUEST RECEIVED BY PJM PLANNING PERSONNEL; . . . . outage type . . . | Duration | true | false | true | 0 | 2059-03-01 14:30:00.000000 | 2023-02-07 15:00:00.000000 | ∅ | 2026-09-19 01:52:36.992791 | |
| 2059-03-01 14:30:00.000000 | 2059-06-15 20:00:00.000000 | 2026-09-19 01:48:29.000000 | 987691 | DOM-C | BRKR | NANNA4 | 500 | NANNA4 WT576 CB | BRKR NANNA4 500 KV NANNA4 WT576 CB | Received | Submitted | Continuous | OUTAGE REQUEST RECEIVED BY PJM PLANNING PERSONNEL; . . . . outage type . . . | Duration | true | false | true | 0 | 2059-03-01 14:30:00.000000 | 2023-02-07 15:00:00.000000 | ∅ | 2026-09-19 01:52:36.992791 | |
| 2059-03-01 14:30:00.000000 | 2059-06-15 20:00:00.000000 | 2026-09-19 01:48:29.000000 | 987691 | DOM-C | BRKR | NANNA4 | 500 | NANNA4 57602 CB | BRKR NANNA4 500 KV NANNA4 57602 CB | Received | Submitted | Continuous | OUTAGE REQUEST RECEIVED BY PJM PLANNING PERSONNEL; . . . . outage type . . . | O | Duration | true | false | true | 0 | 2059-03-01 14:30:00.000000 | 2023-02-07 15:00:00.000000 | ∅ | 2026-09-19 01:52:36.992791 |
| 2059-03-01 14:30:00.000000 | 2059-06-15 20:00:00.000000 | 2026-09-19 01:48:29.000000 | 987691 | DOM-C | BRKR | MIDLOTH | 500 | MIDLOTH H6T576 CB | BRKR MIDLOTH 500 KV MIDLOTH H6T576 CB | Received | Submitted | Continuous | Repair/Replace: Conductor; OUTAGE REQUEST RECEIVED BY PJM PLANNING PERSONNEL; . . . . outage type . . . | Duration | true | false | true | 0 | 2059-03-01 14:30:00.000000 | 2023-02-07 15:00:00.000000 | ∅ | 2026-09-19 01:52:36.992791 | |
| 2059-03-01 14:30:00.000000 | 2059-06-15 20:00:00.000000 | 2026-09-19 01:48:29.000000 | 987691 | DOM-C | BRKR | MIDLOTH | 500 | MIDLOTH 563T576 CB | BRKR MIDLOTH 500 KV MIDLOTH 563T576 CB | Received | Submitted | Continuous | OUTAGE REQUEST RECEIVED BY PJM PLANNING PERSONNEL; . . . . outage type . . . | Duration | true | false | true | 0 | 2059-03-01 14:30:00.000000 | 2023-02-07 15:00:00.000000 | ∅ | 2026-09-19 01:52:36.992791 |