Ask the Grid
PJM logo

De-energized equipment including normally open equipment

PJM's De-energized equipment including normally open equipment.

Outages & Grid Events dataPJM market
Open in Data (opens in a new tab) Ask the agent
One row per
publisher period x document x sheet/archive member x source row x collected revision
Publisher snapshot cadence
Evidence
Mixed evidence
Multiple evidence types kept distinct in the contract
Time basis
Date-labelled records
UTC · report_date

Overview

Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.

Query contract
The view admits a document only when its completion record and exact mirrored row count agree. Select a report_date, source_url and source_sha256 revision before joining source_member and row_index. Interpret observation times from the source record, never from the collection clock.
Analysis rules
Decode the report's source headers and units before aggregating. Never sum report_date, row_index, snapshots, revisions, regional totals and components, or forecast vintages.
Interpretation
report_date identifies the requested publisher period. It is not an observation timestamp. event_time records collection, not source publication or delivery.The serving mirror keeps the latest row for each publisher record; older collected revisions may no longer be queryable.

Access

Download
Query it in SQL, download it, or read it with an API key. Download data
MCP
Connect an MCP client and load the contract with describe_data before calling query_data.PJM MCPAPI reference
HTTP endpoint
POST /api/v1/datasets/pjm_report_deenergized_equipment/query
Full history
Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

11 columns
ColumnType
event_timeDateTime64(6, 'UTC')
datasetLowCardinality(String)
report_dateDate32
source_urlString
source_memberString
source_sha256String
row_indexInt64
record_jsonString
response_metadataString
ingested_atDateTime64(6, 'UTC')
completed_atDateTime64(6, 'UTC')

Sample data

event_timedatasetreport_datesource_urlsource_membersource_sha256row_indexrecord_jsonresponse_metadataingested_atcompleted_at
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835826{"raw_line": " 2906 1354862 LINE CARDIFF 138 KV LEWIS -CARDIFF 1418 |\r\n", "section": "deenergized_equipment", "item": "2906", "ticket": "1354862", "facility": "LINE CARDIFF 138 KV LEWIS -CARDIFF 1418"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835827{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835828{"raw_line": " 2907 0 LINE CLRKSJCT 138 KV CLRKSJCT-EMERALD CLA-EME - N.O. |\r\n", "section": "deenergized_equipment", "item": "2907", "ticket": "0", "facility": "LINE CLRKSJCT 138 KV CLRKSJCT-EMERALD CLA-EME - N.O."}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835829{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835830{"raw_line": " 2908 1311067 LINE BRANDYDP 115 KV BRANDYDP-MTN RUN 70B |\r\n", "section": "deenergized_equipment", "item": "2908", "ticket": "1311067", "facility": "LINE BRANDYDP 115 KV BRANDYDP-MTN RUN 70B"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835831{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835818{"raw_line": " 2902 0 BRKR SPORNAEP 138 KV SPORNAEP EE CB |\r\n", "section": "deenergized_equipment", "item": "2902", "ticket": "0", "facility": "BRKR SPORNAEP 138 KV SPORNAEP EE CB"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835819{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835820{"raw_line": " 2903 0 BRKR SPORNAEP 138 KV SPORNAEP FF CB |\r\n", "section": "deenergized_equipment", "item": "2903", "ticket": "0", "facility": "BRKR SPORNAEP 138 KV SPORNAEP FF CB"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835821{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835790{"raw_line": " 2888 0 CAP LIMEKILN 35 KV LIMEKILN CAP1 CAP |\r\n", "section": "deenergized_equipment", "item": "2888", "ticket": "0", "facility": "CAP LIMEKILN 35 KV LIMEKILN CAP1 CAP"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835823{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835824{"raw_line": " 2905 1311067 BRKR BRANDYDP 115 KV BRANDYDP 7019 DIS |\r\n", "section": "deenergized_equipment", "item": "2905", "ticket": "1311067", "facility": "BRKR BRANDYDP 115 KV BRANDYDP 7019 DIS"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835811{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835812{"raw_line": " 2899 1175409 BRKR BEDINGTO 138 KV BEDINGTO BD13F CB |\r\n", "section": "deenergized_equipment", "item": "2899", "ticket": "1175409", "facility": "BRKR BEDINGTO 138 KV BEDINGTO BD13F CB"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835813{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835814{"raw_line": " 2900 1175409 BRKR BEDINGTO 138 KV BEDINGTO BD18 CB |\r\n", "section": "deenergized_equipment", "item": "2900", "ticket": "1175409", "facility": "BRKR BEDINGTO 138 KV BEDINGTO BD18 CB"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835815{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835822{"raw_line": " 2904 1225096 BRKR BRAMBLET 230 KV BRAMBLET 20102 CB |\r\n", "section": "deenergized_equipment", "item": "2904", "ticket": "1225096", "facility": "BRKR BRAMBLET 230 KV BRAMBLET 20102 CB"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835797{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835798{"raw_line": " 2892 1354081 BRKR CRYSTLSP 115 KV CRYSTLSP 110-3 H/S CSW |\r\n", "section": "deenergized_equipment", "item": "2892", "ticket": "1354081", "facility": "BRKR CRYSTLSP 115 KV CRYSTLSP 110-3 H/S CSW"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835816{"raw_line": " 2901 0 BRKR EMERALD 138 KV EMERALD CLARKS DIS - N.O. |\r\n", "section": "deenergized_equipment", "item": "2901", "ticket": "0", "facility": "BRKR EMERALD 138 KV EMERALD CLARKS DIS - N.O."}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835800{"raw_line": " 2893 0 BRKR HUNTERST 230 KV HUNTERST LB51 DIS - N.O. |\r\n", "section": "deenergized_equipment", "item": "2893", "ticket": "0", "facility": "BRKR HUNTERST 230 KV HUNTERST LB51 DIS - N.O."}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835799{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307
2026-10-26 16:22:45.960105deenergized_equipment2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileName=linesout.ziplinesout.zip/linesout.txta132f386027b4e48dfa56f9b3512b1f09fec4b9c268d0530e68b85a325a3fc835803{"raw_line": "----------------------------------------------------------------------------\r\n", "section": "deenergized_equipment"}{"section": "DE-ENERGIZED EQUIPMENT", "includes_normally_open_equipment": true}2026-10-26 16:22:46.5053292026-10-26 16:22:47.140307

Coverage

Complete
100.0%
Gap days
0
Days with data
1
Show coverage history
Coverage: 100.0%Days with data: 1Gaps: 0
2026
gaplessmore