Ask the Grid
PJM logo

Transmission equipment directory

PJM's Transmission equipment directory.

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_equipment_directory/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 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264518["BRKR", "DUKE", "DUKE", "CATAWBA4", "230 KV", "DUM07247", "CATAWBA4 DUM07247 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264517["BRKR", "DUKE", "DUKE", "CATAWBA4", "230 KV", "DUM07246", "CATAWBA4 DUM07246 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264516["BRKR", "DUKE", "DUKE", "CATAWBA4", "230 KV", "DUM07245", "CATAWBA4 DUM07245 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264515["BRKR", "DUKE", "DUKE", "CATAWBA4", "230 KV", "DUM07244", "CATAWBA4 DUM07244 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264514["BRKR", "DUKE", "DUKE", "CATAWBA4", "230 KV", "DUM07243", "CATAWBA4 DUM07243 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264513["BRKR", "DUKE", "DUKE", "CATAWBA4", "230 KV", "DUM07242", "CATAWBA4 DUM07242 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264526["BRKR", "DUKE", "DUKE", "CENTRL", "100 KV", "DUM07270", "CENTRL DUM07270 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264525["BRKR", "DUKE", "DUKE", "CENTRL", "100 KV", "DUM07267", "CENTRL DUM07267 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264524["BRKR", "DUKE", "DUKE", "CENTRL", "100 KV", "DUM07266", "CENTRL DUM07266 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264523["BRKR", "DUKE", "DUKE", "CENTRL", "100 KV", "DUM07265", "CENTRL DUM07265 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264522["BRKR", "DUKE", "DUKE", "CENTRL", "100 KV", "AT1_100", "CENTRL AT1_100 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264521["BRKR", "DUKE", "DUKE", "CATAWBA4", "230 KV", "DUM07250", "CATAWBA4 DUM07250 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264520["BRKR", "DUKE", "DUKE", "CATAWBA4", "230 KV", "DUM07249", "CATAWBA4 DUM07249 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264533["BRKR", "DUKE", "DUKE", "CENTRL", "230 KV", "AKENS_BY", "CENTRL AKENS_BY DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264532["BRKR", "DUKE", "DUKE", "CENTRL", "230 KV", "AKENS_BR", "CENTRL AKENS_BR DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264531["BRKR", "DUKE", "DUKE", "CENTRL", "230 KV", "AKEB", "CENTRL AKEB CB"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264530["BRKR", "DUKE", "DUKE", "CENTRL", "100 KV", "DUM07274", "CENTRL DUM07274 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264529["BRKR", "DUKE", "DUKE", "CENTRL", "100 KV", "DUM07273", "CENTRL DUM07273 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264528["BRKR", "DUKE", "DUKE", "CENTRL", "100 KV", "DUM07272", "CENTRL DUM07272 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264527["BRKR", "DUKE", "DUKE", "CENTRL", "100 KV", "DUM07271", "CENTRL DUM07271 DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264540["BRKR", "DUKE", "DUKE", "CENTRL", "230 KV", "AT-2_HT", "CENTRL AT-2_HT CB"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264539["BRKR", "DUKE", "DUKE", "CENTRL", "230 KV", "AT-1_YB", "CENTRL AT-1_YB DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264538["BRKR", "DUKE", "DUKE", "CENTRL", "230 KV", "AT-1_RB", "CENTRL AT-1_RB DIS"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264555["BRKR", "DUKE", "DUKE", "CENTRL", "230 KV", "CALW", "CENTRL CALW CB"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590
2026-10-26 10:31:14.986857equipment_directory2026-10-26https://edartsso.pjm.com/edart/rest/secure/download?dart=true&downloadtype=pjmpostingfile&fileId=10equiplist.zip/equiplist.csv4cd3f8bc45e0f3a20ab903b24e0dfc784ec2b3d5536e0bcc2b7899e560be813264537["BRKR", "DUKE", "DUKE", "CENTRL", "230 KV", "AT-1_HT", "CENTRL AT-1_HT CB"]{"posting_file": {"fileId": "10", "fileName": "equiplist.zip", "description": "Equipment List/Complete Descriptions file<br>Updated with the PJM model build (quarterly)", "lastUpdated": "2026-09-15T15:07:02.000"}, "report_date_meaning": "collection date; source times remain verbatim", "history_semantics": "completed-ticket history, not as-of forecast vintages"}2026-10-26 10:31:19.4219612026-10-26 10:31:25.366590

Coverage

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