Ask the Grid

Overview

ERCOT's weekly registration crosswalk between resource nodes and registered generation units. It can establish the published node-to-unit relationship for a particular snapshot. It does not establish dispatch, ownership, substation topology, constraint exposure, or the cause of a nodal price move. This table is listed in the public catalog but is not exposed to agent SQL until its snapshot and identity semantics are fully contracted. The source is ERCOT report NP4-160-SG.

Schema14

Column
Type
event_timeDateTime64(6, 'UTC')
resource_nodeLowCardinality(String)
unit_nameLowCardinality(String)
unit_typeNullable(String)
fuel_typeNullable(String)
hsl_mwNullable(Float64)
lsl_mwNullable(Float64)
countyNullable(String)
effective_startNullable(Date32)
effective_endNullable(Date32)
emil_idNullable(String)
doc_idNullable(Int64)
ingested_atDateTime64(6, 'UTC')
unit_substationNullable(String)

Sample rows

event_timeresource_nodeunit_nameunit_typefuel_typehsl_mwlsl_mwcountyeffective_starteffective_endemil_iddoc_idingested_atunit_substation
2026-07-29 00:00:00.000000ZIER_SLR_ALLPV1NP4-160-SG12558182332026-08-03 08:00:25.893710ZIER_SLR
2026-07-29 00:00:00.000000ZIER_SLR_ALLESR1NP4-160-SG12558182332026-08-03 08:00:25.893710ZIER_SLR
2026-07-29 00:00:00.000000Z5_DGR1_RNDGR1NP4-160-SG12558182332026-08-03 08:00:25.893710Z5
2026-07-29 00:00:00.000000Z0_DGR2_RNESR1NP4-160-SG12558182332026-08-03 08:00:25.893710Z0
2026-07-29 00:00:00.000000Z0_DGR2_RNDGR2NP4-160-SG12558182332026-08-03 08:00:25.893710Z0
2026-07-29 00:00:00.000000Z0_DGR1_RNDGR1NP4-160-SG12558182332026-08-03 08:00:25.893710Z0
2026-07-29 00:00:00.000000YNG_WND_ALLUNIT3NP4-160-SG12558182332026-08-03 08:00:25.893710YNG_WND
2026-07-29 00:00:00.000000YNG_WND_ALLUNIT2NP4-160-SG12558182332026-08-03 08:00:25.893710YNG_WND
2026-07-29 00:00:00.000000YNG_WND_ALLUNIT1NP4-160-SG12558182332026-08-03 08:00:25.893710YNG_WND
2026-07-29 00:00:00.000000YAPN_SLR_RNPV2NP4-160-SG12558182332026-08-03 08:00:25.893710YAPN_SLR
2026-07-29 00:00:00.000000YAPN_SLR_RNPV1NP4-160-SG12558182332026-08-03 08:00:25.893710YAPN_SLR
2026-07-29 00:00:00.000000X443ESRNESR1NP4-160-SG12558182332026-08-03 08:00:25.893710X4
2026-07-29 00:00:00.000000X1_DGR_RNDGR1NP4-160-SG12558182332026-08-03 08:00:25.893710X1
2026-07-29 00:00:00.000000W_PECO_UNIT1UNIT1NP4-160-SG12558182332026-08-03 08:00:25.893710W_PECOS
2026-07-29 00:00:00.000000W_HRL_ESR_RNESR1NP4-160-SG12558182332026-08-03 08:00:25.893710W_HARLIN
2026-07-29 00:00:00.000000WZRD_ESS_RNESR1NP4-160-SG12558182332026-08-03 08:00:25.893710WZRD_ESS
2026-07-29 00:00:00.000000WR_RNESR1NP4-160-SG12558182332026-08-03 08:00:25.893710WR
2026-07-29 00:00:00.000000WRSBES_BESS1ESR1NP4-160-SG12558182332026-08-03 08:00:25.893710WORSHAM
2026-07-29 00:00:00.000000WOV_BESS_RNESR1NP4-160-SG12558182332026-08-03 08:00:25.893710WOVER
2026-07-29 00:00:00.000000WOODWRD2_RNWOODWRD2NP4-160-SG12558182332026-08-03 08:00:25.893710WOODWRD2
2026-07-29 00:00:00.000000WOODWRD1_RNWOODWRD1NP4-160-SG12558182332026-08-03 08:00:25.893710WOODWRD1
2026-07-29 00:00:00.000000WND_WHITNEYWHITNEY2NP4-160-SG12558182332026-08-03 08:00:25.893710WND
2026-07-29 00:00:00.000000WND_WHITNEYWHITNEY1NP4-160-SG12558182332026-08-03 08:00:25.893710WND
2026-07-29 00:00:00.000000WNDTS2_UNIT1UNIT1NP4-160-SG12558182332026-08-03 08:00:25.893710WNDTHST2
2026-07-29 00:00:00.000000WL_RANCH_RNUNIT1NP4-160-SG12558182332026-08-03 08:00:25.893710WL_RANCH

Coverage

11.5% complete69 gap days9 days with data
Show coverage history ▾
Coverage: 11.5%Days with data: 9Gaps: 69
2026
gaplessmore