Ask the Grid
PJM logo

Transmission outage RTEP project references

PJM's Transmission outage RTEP project references.

Infrastructure 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
Reference data
Stable context used to interpret other datasets
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_rtep_references/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:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4449{"raw_line": "1255138 b3800.122\r\n", "section": "header", "ticket": "1255138", "rtep_reference": "b3800.122"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4450{"raw_line": "1242556 B3800.32\r\n", "section": "header", "ticket": "1242556", "rtep_reference": "B3800.32"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4451{"raw_line": "1242557 B3800.32\r\n", "section": "header", "ticket": "1242557", "rtep_reference": "B3800.32"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4452{"raw_line": "1124089 b3800.312\r\n", "section": "header", "ticket": "1124089", "rtep_reference": "b3800.312"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4453{"raw_line": "1124134 b3800.346\r\n", "section": "header", "ticket": "1124134", "rtep_reference": "b3800.346"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4454{"raw_line": "1124135 b3800.344\r\n", "section": "header", "ticket": "1124135", "rtep_reference": "b3800.344"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4455{"raw_line": "1238056 s3040\r\n", "section": "header", "ticket": "1238056", "rtep_reference": "s3040"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4442{"raw_line": "1266134 b3737.50, b3800.45\r\n", "section": "header", "ticket": "1266134", "rtep_reference": "b3737.50, b3800.45"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4443{"raw_line": "1240932 b3800.326\r\n", "section": "header", "ticket": "1240932", "rtep_reference": "b3800.326"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4444{"raw_line": "1246210 b3800.26, b4000.342\r\n", "section": "header", "ticket": "1246210", "rtep_reference": "b3800.26, b4000.342"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4445{"raw_line": "1253877 B3800.7\r\n", "section": "header", "ticket": "1253877", "rtep_reference": "B3800.7"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4446{"raw_line": "1186635 s3688.1\r\n", "section": "header", "ticket": "1186635", "rtep_reference": "s3688.1"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4447{"raw_line": "1203124 B3800.245\r\n", "section": "header", "ticket": "1203124", "rtep_reference": "B3800.245"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4448{"raw_line": "1227561 s0965.7\r\n", "section": "header", "ticket": "1227561", "rtep_reference": "s0965.7"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4435{"raw_line": "1313908 b3718.12\r\n", "section": "header", "ticket": "1313908", "rtep_reference": "b3718.12"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4436{"raw_line": "1339500 b3800.359\r\n", "section": "header", "ticket": "1339500", "rtep_reference": "b3800.359"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4437{"raw_line": "1355750 b4068.23\r\n", "section": "header", "ticket": "1355750", "rtep_reference": "b4068.23"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4420{"raw_line": "1242507 3780.5\r\n", "section": "header", "ticket": "1242507", "rtep_reference": "3780.5"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4439{"raw_line": "1266133 b3737.50\r\n", "section": "header", "ticket": "1266133", "rtep_reference": "b3737.50"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4440{"raw_line": "1245450 b3800.12\r\n", "section": "header", "ticket": "1245450", "rtep_reference": "b3800.12"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4441{"raw_line": "1245457 b3800.12\r\n", "section": "header", "ticket": "1245457", "rtep_reference": "b3800.12"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4438{"raw_line": "1355752 b4068.22\r\n", "section": "header", "ticket": "1355752", "rtep_reference": "b4068.22"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4415{"raw_line": "1352605 B3780.6\r\n", "section": "header", "ticket": "1352605", "rtep_reference": "B3780.6"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4414{"raw_line": "1320420 s2375\r\n", "section": "header", "ticket": "1320420", "rtep_reference": "s2375"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173
2026-10-26 16:27:55.083721rtep_references2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=8rtep.zip/rtep.txt03c9cfd4ceed600ac2c7fc2120c82e58cafccd5672750ea5d1394deebc2f92b4425{"raw_line": "1334469 s3083.1\r\n", "section": "header", "ticket": "1334469", "rtep_reference": "s3083.1"}{"posting_file": {"fileId": "8", "fileName": "rtep.zip", "description": "List of RTEP Transmission Outage Tickets<br>Updated every 5 minutes", "lastUpdated": "2026-10-26T16:23:59.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 16:27:55.1216872026-10-26 16:27:55.854173

Coverage

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