System AS capacity dashboard JSON

ERCOT's System AS capacity dashboard JSON.

Ancillary Services data ERCOT market

Query with the agent

Native record

publisher period x document x sheet/archive member x source row x collected revision

Publisher snapshot publication cadence

Evidence

Mixed evidence

Multiple evidence types kept distinct in the contract

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

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

ERCOT MCP API reference

HTTP endpoint

POST /api/v1/datasets/ercot_report_ancillary_service_capacity_monitor/query

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema11

Column

Type

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_time	dataset	report_date	source_url	source_member	source_sha256	row_index	record_json	response_metadata	ingested_at	completed_at
2026-10-11 04:20:53.750200	ancillary_service_capacity_monitor	2026-10-11	https://www.ercot.com/api/1/services/read/dashboards/ancillary-service-capacity-monitor.json	ancillary-service-capacity-monitor.json	02fecc2754099421790e12ac350fac7f626219e20dc00e9c18c2c533520968cf	0	{"lastUpdated": "2026-10-10 23:20:32-0500", "epoch": "1791692432", "interval": "23:20:32", "dstFlag": "N", "data": {"responsiveReserveCapabilityGroup": [["key", "value"], ["rrcCapPfrGenEsr", 1377], ["rrcCapLrWoClr", 1140], ["rrcCapLr", 0], ["rrcCapFfr", 0], ["rrcCapFfrEsr", 183]], "responsiveReserveAwardsGroup": [["key", "value"], ["rrAwdGen", 1377], ["rrAwdNonClr", 1142], ["rrAwdClr", 0], ["rrAwdFfr", 183]], "ercotContingencyReserveCapabilityGroup": [["key", "value"], ["ecrsCapGen", 89], ["ecrsCapNclr", 214], ["ecrsCapClr", 74], ["ecrsCapQs", 138], ["ecrsCapEsr", 655], ["ecrsCapDeployedGenLr", 0]], "ercotContingencyReserveAwardsGroup": [["key", "value"], ["ecrsAwdGen", 89], ["ecrsAwdNonClr", 214], ["ecrsAwdClr", 74], ["ecrsAwdQs", 138], ["ecrsAwdEsr", 655]], "nonSpinReserveCapabilityGroup": [["key", "value"], ["nsrCapOnGenWoEo", 3363], ["nsrCapOffResWOs", 0], ["nsrCapUndeployedLr", 27], ["nsrCapOffGen", 2312], ["nsrCapEsr", 1293]], "nonSpinReserveAwardsGroup": [["key", "value"], ["nsrAwdGenWEo", 3376], ["nsrAwdGenWOs", 0], ["nsrAwdLr", 51], ["nsrAwdOffGen", 2312], ["nsrAwdQs", 645], ["nsrAwdAs", 1296]], "regulationCapacityGroup": [["key", "value"], ["regUpCap", 336], ["regDownCap", 272], ["regUpUndeployed", 336], ["regDownUndeployed", 272], ["regUpDeployed", 0], ["regDownDeployed", 0]], "regulationAwardsGroup": [["key", "value"], ["regUpAwd", 336], ["regDownAwd", 287]], "systemAvailableCapacityGroup": [["key", "value"], ["capClrDecreaseBp", -7], ["capClrIncreaseBp", 130], ["capWEoIncreaseBp", 10774], ["capWEoDecreaseBp", -33326], ["capWoEoIncreaseBp", 37], ["capWoEoDecreaseBp", -3516], ["esrCapWEoIncreaseBp", 15798], ["esrCapWEoDecreaseBp", -16870], ["esrCapWoEoIncreaseBp", 275], ["esrCapWoEoDecreaseBp", -398], ["capIncreaseGenBp", 20757], ["capDecreaseGenBp", -42291], ["sumCapResRegUpRrs", 20684], ["sumCapResRegUpRrsEcrs", 24522], ["sumCapResRegUpRrsEcrsNsr", 26055]], "ercotWidePhysicalResponsiveCapabilityGroup": [["key", "value"], ["prc", 12849]], "realTimeOperatingReserveDemandCurveCapacityGroup": [["key", "value"], ["rtReserveOnline", 0], ["rtReserveOnOffline", 0]], "emrOutAndOutLCapacityGroup": [["key", "value"], ["telemHslEmr", 806], ["telemHslOut", 13930], ["telemHslOutl", 2357]]}}	{"etag": "\"28cd3f4f\"", "content-type": "application/json"}	2026-10-11 04:20:54.236589	2026-10-11 04:20:55.596892

Coverage

100.0% complete0 gap days1 days with data

Show coverage history

Coverage: 100.0%Days with data: 1Gaps: 0

2026

gaplessmore

Related ancillary services data

Related ancillary services data
Dataset	Description
Ancillary Service PricesERCOT · hourly (DAM)	Hourly market clearing prices for the ancillary services ERCOT procures alongside energy in its Day-Ahead Market, broken out by product: Regulation Up (RegUp), Regulation Down (RegDown), Responsive Reserve (RRS), Non-Spinning Reserve (NSPIN), and the ERCOT Contingency Reserve Service (ECRS). These prices represent what the grid pays per megawatt to hold capacity in reserve for frequency control and contingency response, separate from the energy itself. Watching them shows when reserves are scarce and expensive (often during tight or volatile conditions), which informs how generators and storage operators allocate capacity between energy and reserve markets, and gives researchers a read on the cost of keeping the Texas grid reliable. ECRS, added in 2023, is the newest of these products and has at times cleared at notably high levels.
Ancillary-service capacity monitor HTMLERCOT · Publisher snapshot	ERCOT's Ancillary-service capacity monitor HTML. 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.
DAM Energy Storage Resource Data (60-Day)ERCOT · hourly (DAM), 60-day disclosure	What each ERCOT battery offered into the Day-Ahead Market and what it was awarded, hour by hour, from the 60-Day DAM Disclosure Reports. Like the SCED storage file this subreport begins at RTC+B go-live on 6 December 2025. Each row is one hour for one storage resource and its QSE, carrying the QSE's submitted energy curve as up to ten monotonic MW/price pairs, the resource's high and low sustainable limits and status, the awarded energy quantity, its settlement point and that point's day-ahead price, and its ancillary awards with the matching market clearing price for capacity in each service (Reg-Up, Reg-Down, RRS-PFR, RRS-FFR, RRS-UFR, ECRS, Non-Spin). This is where day-ahead storage strategy is legible: how a fleet split its capacity between energy and reserves, what it was paid for each, and how its bid curve related to the price that cleared. It is a cleared-market record on a 60-day regulatory delay, not a live feed. Measured 2026-09-07: 3.2 million rows. The official source is ERCOT report NP3-966-ER, 60-Day DAM Disclosure Reports.
DAM Total AS SoldERCOT · hourly (DAM)	This dataset reports the total quantity of ancillary services ERCOT procured in its Day-Ahead Market, broken out by product (such as Regulation Up, Regulation Down, Responsive Reserve, ECRS, and Non-Spinning Reserve) for each delivery hour. These figures show how much reserve capability ERCOT set aside to keep supply and demand balanced and to respond to contingencies, separate from the energy cleared for actual generation. Paired with the per-product clearing prices, the cleared volumes let traders, researchers, and the public see how reserve requirements shift hour to hour and how much of the market's capacity is committed to grid reliability rather than energy. The data comes from ERCOT report NP4-532-CD (DAM Total AS Sold) and updates with each day-ahead market run.