CAISO's public generation interconnection queue, combining active, completed, and withdrawn projects with the proposed point of interconnection, technology, requested capacity, status, and completion dates. Each posting is a snapshot: current totals must use one latest snapshot, and requested queue MW is not operating capacity, available transmission headroom, or evidence that a project will be built.
Every CAISO location that carries a price, as three columns: location_id, name, and kind. 26,632 rows — node (26,048), interface (578), zone (6). This is the dimension the CAISO price, and where applicable constraint, tables join to, and it is the one place a location's type is decided: resolve "which hubs exist", "is this a zone or a node", or "give me the readable name for this id" here rather than inferring a type from a name prefix. For CAISO, name equals location_id (the pnode name). The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.
NYSERDA Integrated Energy Data Resource (IEDR) per-county DER hosting-capacity rollup for New York State's 62 counties. Each snapshot row carries DER counts by status, feeder count, and min/max/total hosting capacity for generic DER, ESS charging, ESS discharging, and EV load, plus county population and centroid. `county_id` is an IEDR-internal identifier, NOT a FIPS code — join to county geometry by normalized county name. Bitemporal snapshot: use ROW_NUMBER() OVER (PARTITION BY county_id ORDER BY event_time DESC) = 1 (or an equivalent argMax(..., event_time) per county_id) to get the current snapshot. ESS charging and discharging hosting capacity are asymmetric: a battery can only charge into a wire's spare import capacity, but can discharge more than the wire's rating when serving co-located load.