Data Catalog

Real-time SCED locational marginal prices at ERCOT settlement points (resource nodes, load zones, and trading hubs), in 5-minute intervals (report NP6-788-CD). Mirrored live from the warehouse.

The locational marginal price for each electrical bus in ERCOT, normally produced by SCED every five minutes. Bus-level granularity (~21k buses).

Day-Ahead Market hourly settlement point prices (DAM SPP) for every ERCOT settlement point — resource nodes, load zones, and hubs. The day-ahead counterpart to the real-time LMP. History back to 2017.

Market clearing prices for ERCOT ancillary services by product — RegUp, RegDown, RRS, Non-Spin (NSPIN), and ERCOT Contingency Reserve (ECRS). Hourly clearing prices, history back to 2017.

ERCOT actual system load (demand) by the 8 weather zones — Coast, East, Far West, North, North Central, South Central, Southern, West — plus the system total, at hourly resolution. History back to 2017. Powers the map's per-zone demand readout.

ERCOT's official Fuel Mix Report (IntGenByFuel) — actual generation by fuel for each 15-minute settlement interval, long format across 10 fuel categories (biomass, coal, gas, gas_cc, hydro, nuclear, other, solar, wsl, wind). Each interval is published INITIAL (provisional) then restated FINAL (settled); both are kept. History back to 2017.

ERCOT's real-time supply-demand dashboard feed, captured 1:1 in one table. Each 5-minute row is tagged by series: 'realized' (actual demand + committed capacity, ~1-min lag — the best live demand measure), 'intraday_forecast' (today's remaining forecast), and 'forward_forecast' (6-day-ahead hourly demand + available capacity). Powers the live counters.

ERCOT headline 5-minute fuel mix — realized generation (MW) for each of the 8 fuel categories (coal, hydro, nuclear, storage, solar, wind, gas, other) at each 5-minute interval. Wide format; the live-dashboard companion to the settlement Fuel Mix Report.

ERCOT System-Wide Demand (NP6-235-CD) — aggregated actual system demand at 15-minute intervals from the official reports API. The settled, authoritative counterpart to the real-time supply-demand dashboard feed.

Crosswalk from each ERCOT resource node (settlement point) to its physical generation unit(s) and substation — the Resource_Node_to_Unit member of NP4-160-SG (Settlement Points List & Electrical Buses Mapping, RTID 10008). A weekly registration snapshot that links nodal LMP to the underlying generators.

ERCOT Day-Ahead Market total ancillary service cleared (MW) by product — RegUp, RegDown, RRS, ECRS, and Non-Spin — for each delivery hour. The system-wide AS procurement counterpart to the per-product clearing prices. Report NP4-532-CD.

ERCOT Day-Ahead Market total energy sold (MWh) for each delivery hour — the system-wide cleared day-ahead energy quantity. Report NP4-193-CD.

ERCOT actual system-wide demand (instantaneous total load, MW) at 5-minute resolution from real-time telemetry. The grid-wide companion to the per-weather-zone System Load. Report NP6-235-CD.

ERCOT wind generation by geographic region — hourly actuals plus forecast vintages, from NP4-742-CD. Five regions plus the system total; long format with one row per (delivery hour, vintage, region). History back to 2017. Bitemporal: each forecast vintage is kept as its own row (event_time = delivery hour, source_time = posted time).

ERCOT solar generation by geographic region — hourly actuals plus forecast vintages (COP HSL, STPPF, PVGRPP), from NP4-745-CD. Six weather/geo regions plus system-wide; long format keyed by region. History back to 2022 (its true floor). Bitemporal, one row per vintage.

EIA Form 860 inventory of every operable utility-scale electric generator in the US — one row per (snapshot, plant, generator) with nameplate / summer / winter capacity, technology, prime mover, energy source, operator (entity), balancing authority, status, and plant lat/lon. Annual final back to 2001 plus monthly-preliminary EIA-860M updates.

EIA-860 inventory filtered to utility-scale solar generators — the base generator-inventory columns plus solar-specific attributes (single- vs dual-axis tracking, tilt angle). Subset of Operating Generators.

EIA-860 inventory filtered to utility-scale wind generators — the base generator-inventory columns plus wind-specific attributes (hub height, predominant turbine manufacturer / model). Subset of Operating Generators.

EIA-860 inventory filtered to utility-scale battery / storage resources — the base generator-inventory columns plus storage-specific attributes (max charge / discharge rate, useful-life MWh, storage technology). Subset of Operating Generators.

Plant-level power-plant registry (the EIA-authored layer distributed via the HIFLD catalog) — one row per plant with operator, primary fuel, lat/lon, and a per-fuel installed-capacity breakdown (coal, gas, nuclear, solar, wind, hydro, battery, …). The plant-level companion to EIA-860.

HIFLD electric substations — point geometry with name, city / county, voltage class (min / max kV), line count, type, and operating status. Powers the map's substation layer.

HIFLD electric power transmission lines — polyline geometry (GeoJSON) with owner, voltage / voltage class, and the two substation endpoints (sub_1 / sub_2). The physical transmission backbone.