Ask the Grid
Open live grid

Infrastructure

The physical and administrative scaffolding behind the market data: interconnection queues, plant and substation registries, pricing-node reference maps, and hosting-capacity inventories.

27 datasetspublished by ATG DataUS reference10ERCOT3CAISO3ISONE3NYISO2PJM2MISO2SPP2

Infrastructure datasets
DatasetRows
CAISOCAISO Interconnection QueueATG Data·CAISO·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.141.2K1999
CAISOCAISO Price LocationsATG Data·CAISO·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.26.6K—
DER Hosting Capacity by CountyATG Data·US reference·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.2.3K2026
ERCOTERCOT Interconnection QueueATG Data·ERCOT·ERCOT's public large-generation interconnection queue, with project identity, developer, proposed point of interconnection, transmission owner, technology, requested MW, queue status, and proposed or actual completion dates. Each posting is a snapshot, so current project claims must use the latest snapshot rather than count every vintage. Queue inclusion and proposed dates do not establish available transmission headroom, study outcome, approval, construction probability, or an operating asset. The official source is ERCOT's GIS Report.97.0K2006
ERCOTERCOT Price LocationsATG Data·ERCOT·Every ERCOT location that carries a price, as three columns: location_id, name, and kind. 20,456 rows — bus (19,329), node (1,100), weather_zone (8), zone (8), hub (7), interface (4). This is the dimension the ERCOT 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 ERCOT, name equals location_id — the settlement-point name is the identifier. The key is (location_id, kind), not location_id alone: 161 ERCOT names exist as both a settlement point and an electrical bus, and those are separately priced objects. Filter on kind when a name could be either. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.20.4K—
Interstate Gas Pipeline Capacity and Scheduled FlowATG Data·US reference·Operationally available capacity postings from the electronic bulletin boards that FERC requires interstate natural gas pipelines to publish, covering 34 pipelines including Transco, Texas Eastern, Algonquin, Tennessee, NGPL, El Paso Natural Gas, CIG, Southern Natural and Northwest. Each row is one metering location on one pipeline for one gas day and nomination cycle, carrying design capacity, operating capacity, operationally available capacity and scheduled quantity in dekatherms. This is physical capacity and physical flow, not price: scheduled_dth is gas actually nominated to move through that point, and the gap between operating capacity and scheduled quantity is the headroom left on that segment. It is the physical layer underneath gas-driven price formation — constrained takeaway or a full segment into a load pocket is what turns a regional gas price away from the national benchmark — and it is the only view here of gas delivery to individual power plants, with locations tagged by category including power_plant (85,896 rows), citygate (291,891) and storage, processing, production, interconnect, industrial and LNG terminal. Coverage is very uneven by pipeline and must be checked before any cross-pipeline comparison: Transco reaches back to 2018-06-04 and the Enbridge group to 2023-06, but the Kinder Morgan pipelines begin only on 2026-03-04, so a multi-pipeline total over an earlier window silently omits them. 32 of the 34 pipelines are current to within three days. The category column is unlabelled for 81% of rows, so a category filter returns an authoritative subset rather than everything of that kind. Filter on event_time rather than gas_day — the two always hold the same date, but only event_time is indexed, and using it cuts a representative power-plant query from a full scan to three granules. The official source is each pipeline's FERC-mandated electronic bulletin board.4.7M2018
ISO-NEISO-NE Interconnection QueueATG Data·ISONE·ISO New England's public interconnection queue, including project identity, location, transmission owner, technology, requested capacity, milestone status, and withdrawal date where published. Each posting is a snapshot: current totals must use one latest snapshot, and requested queue MW is not operating capacity, available transmission headroom, completed study work, or evidence that a project will be built.161.7K1996
MISOLive System SnapshotATG Data·MISO·The compact public MISO dashboard snapshot, retaining each publisher title and raw string value for demand, capacity, and interchange headlines. Prefer the typed live_load, live_capacity, and live_grid_metrics tables for calculations.14.7K1970
MISOMISO Interconnection QueueATG Data·MISO·MISO's public generator interconnection queue, including project identity, developer, county and state, proposed point of interconnection, transmission owner, technology, requested capacity, status, and negotiated or actual completion dates where published. Each posting is a snapshot: current totals must use one latest snapshot, and requested queue MW is not operating capacity, available transmission headroom, completed study work, or evidence that a project will be built.64.7K2015
ISO-NEMorning ReportATG Data·ISONE·ISO-NE's published Morning Report source feed. This catalog page exposes the physical schema, coverage, and latest source rows without inventing a normalized grain for publisher-shaped snapshot fields. Use the documented key and event time when comparing revisions or vintages.1.8K2022
NYISONYISO Interconnection QueueATG Data·NYISO·NYISO's public interconnection queue across active, cluster-study, withdrawn, and in-service projects, including developer, location, transmission owner, technology, requested capacity, status, and proposed or actual 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.2.1K1989
NYISONYISO Price LocationsATG Data·NYISO·Every NYISO location that carries a price, as three columns: location_id, name, and kind. 773 rows — generator (758), zone (15). This is the dimension the NYISO 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 NYISO, location_id is the numeric PTID and name is the human-readable zone or generator name. Join on location_id; report 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.828—
ODIN Utility Feed StatusATG Data·US reference·Coverage and health snapshots from ORNL/DOE's ODIN status API. Each poll records the utility feeds ODIN reports, their spatial resolution, outage-feed metadata, current total outages, vendor, received timestamp, and error flag. Use this to understand whether ODIN coverage is complete for a state or utility before treating the county outage layer as comprehensive.895.4K2026
Operating GeneratorsATG Data·US reference·A generator-level inventory of every operable utility-scale electric generator in the United States, drawn from EIA Form 860. Each record describes one generating unit, including its nameplate capacity, technology and prime mover, primary energy source, operating status, owner or operator, balancing authority, and the latitude and longitude of its plant. It is the standard reference for understanding what physical generation exists on the grid, where it sits, and how it is fueled. Annual final filings give the authoritative year-end picture, while the monthly EIA-860M updates track newly proposed, added, and retired units between annual releases, making it useful for tracking the fleet's evolving capacity mix and the buildout of new resources.4.7M2008
PJMPJM Interconnection QueueATG Data·PJM·PJM's public generation interconnection queue, with project identity, location, transmission owner, technology, requested capacity, status, and proposed 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, completed study work, or evidence that a project will be built.908.0K1997
PJMPJM Price LocationsATG Data·PJM·Every PJM location that carries a price, as three columns: location_id, name, and kind. 14,977 rows — load (12,159), generator (2,255), aggregate (293), bus (153), interface (82), zone (23), hub (12). This is the dimension the PJM 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 PJM, location_id is the numeric pnode_id and name is the pnode name (e.g. WESTERN HUB). Join on location_id; report 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.15.0K—
CAISOPNode Reference MapATG Data·CAISO·CAISO pricing-node (PNode) reference map: pricing-node id, aggregate-node id, name, voltage, node type, and the effective-date window each definition is valid for. This is a dimension / reference table, not a time series — it is a slow-moving registry snapshotted periodically (a handful of vintages), so use it to resolve and label pricing nodes and their attributes rather than for time-based analysis. Join it to the CAISO LMP and shadow-price tables to give nodes human-readable names and group them. The official source is CAISO OASIS.77.1K2015
Power PlantsATG Data·US reference·A plant-level inventory of US electric generating facilities, with one record per plant carrying its operator, location (latitude and longitude), primary fuel, and installed capacity broken out by fuel type. The underlying data is authored by the Energy Information Administration and distributed through the Homeland Infrastructure Foundation-Level Data (HIFLD) catalog, serving as the geographic companion to the EIA-860 generator inventory. It lets anyone place the generating fleet on a map and ask where capacity sits, what fuels it runs on, and who operates it, which is the starting point for siting studies, fuel-mix analysis, interconnection context, and resource-adequacy work.188.2K2026
ERCOTResource Node → Unit MappingATG Data·ERCOT·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.21.0K2026
ISO-NESchedule2 VAR ProgramATG Data·ISONE·ISO-NE's published Schedule2 VAR Program source feed. This catalog page exposes the physical schema, coverage, and latest source rows without inventing a normalized grain for publisher-shaped snapshot fields. Use the documented key and event time when comparing revisions or vintages.6062023
Solar GeneratorsATG Data·US reference·This is the utility-scale solar slice of the EIA-860 generator inventory, listing every operating solar generating unit along with its plant, location, owner, nameplate and net capacity, and in-service dates. It adds solar-specific attributes such as panel tracking type (fixed, single-axis, or dual-axis) and tilt angle. Researchers and analysts can use it to map where solar capacity sits on the grid, gauge how design choices shape generation profiles, and track the buildout of utility-scale solar over time. The source is the EIA-860 annual survey, with the inventory refreshed monthly between full annual snapshots.720.8K2008
SPPSPP Interconnection QueueATG Data·SPP·SPP's public generator interconnection queue, including project identity, county and state, proposed point of interconnection, technology, requested capacity, status, and proposed 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, completed study work, or evidence that a project will be built.294.8K1999
SPPSPP Price LocationsATG Data·SPP·Every SPP location that carries a price, as three columns: location_id, name, and kind. 12,442 rows — bus (10,457), node (1,983), hub (2). This is the dimension the SPP 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 SPP, name equals location_id. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.12.4K—
Storage GeneratorsATG Data·US reference·This is the subset of utility-scale battery and energy storage resources reported in the EIA-860 generator inventory, covering plant and owner identifiers, location, capacity, and operating status alongside storage-specific attributes such as maximum charge and discharge rates, useful-life energy in MWh, and storage technology. It is updated annually with a full snapshot and refreshed monthly between cycles. The duration and power ratings let you separate short-duration frequency-regulation assets from longer-duration shifting resources, and tracking new entries over time shows where storage is being added across the grid. Operators, traders, and researchers use it as the authoritative reference for what storage exists, where it sits, and how much energy and power it can move.76.2K2010
SubstationsATG Data·US reference·A point-level inventory of electric substations across the United States, drawn from the Homeland Infrastructure Foundation-Level Data (HIFLD) program. Each record locates a substation and describes its name, city and county, voltage class (minimum and maximum kV), the number of transmission lines connecting to it, its type, and its operating status. Substations are the nodes where voltage is stepped up or down and where transmission and distribution meet, so this dataset lets operators, planners, traders, and researchers see where the grid's switching and transformation points sit, gauge the relative importance of a node by its voltage and line count, and tie generation and load to the network that connects them.753.3K2026
Transmission LinesATG Data·US reference·This dataset maps the physical transmission backbone of the US power grid as polyline geometry, tracing each line from one substation endpoint to the other. Each segment carries attributes including the owning utility and a voltage class, distinguishing the high-voltage bulk transmission corridors from lower-voltage feeders. With it you can see how regions interconnect, identify the major paths that move power across long distances, and reason about constraints, interties, and where new generation or load would need to tie in. The source is the Homeland Infrastructure Foundation-Level Data (HIFLD) electric power transmission lines layer.807.7K2026
Wind GeneratorsATG Data·US reference·A national inventory of utility-scale wind generators drawn from EIA-860, the Energy Information Administration's annual survey of electric generating units. Each record carries the standard generator attributes (plant, operator, location, nameplate capacity, operating status, and online date) plus wind-specific detail such as hub height and turbine manufacturer and model. This is the authoritative reference for who owns which wind fleet, where the turbines stand, and what hardware is installed, which lets operators, traders, and researchers map installed wind capacity, gauge buildout by region or developer, and connect equipment characteristics to generation behavior. It updates monthly for status changes and is consolidated in the annual EIA-860 release.289.6K2008