PJM logo

Operational reserve quantities

PJM's Operational reserve quantities.

Native record
publisher period x document x sheet/archive member x source row x collected revision
day publication 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.

HTTP endpoint
POST /api/v1/datasets/pjm_report_operational_reserves/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_timedatasetreport_datesource_urlsource_membersource_sha256row_indexrecord_jsonresponse_metadataingested_atcompleted_at
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7409{"datetime_beginning_utc": "2026-10-11T04:15:01", "datetime_beginning_ept": "2026-10-11T00:15:01", "reserve_name": "RTO Contingency (Primary) Reserve Requirement", "reserve_mw": 1969.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7410{"datetime_beginning_utc": "2026-10-11T04:15:01", "datetime_beginning_ept": "2026-10-11T00:15:01", "reserve_name": "RTO Contingency (Primary) Reserve Total", "reserve_mw": 5546.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7411{"datetime_beginning_utc": "2026-10-11T04:15:01", "datetime_beginning_ept": "2026-10-11T00:15:01", "reserve_name": "RTO Operating (30 Min) Reserve Total", "reserve_mw": 16119.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7412{"datetime_beginning_utc": "2026-10-11T04:15:01", "datetime_beginning_ept": "2026-10-11T00:15:01", "reserve_name": "RTO Primary Reserve Requirement from Markets", "reserve_mw": 2620.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7413{"datetime_beginning_utc": "2026-10-11T04:15:01", "datetime_beginning_ept": "2026-10-11T00:15:01", "reserve_name": "RTO Synchronized Reserve Requirement", "reserve_mw": 1313.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7400{"datetime_beginning_utc": "2026-10-11T04:15:16", "datetime_beginning_ept": "2026-10-11T00:15:16", "reserve_name": "RTO Synchronized Reserve Requirement", "reserve_mw": 1310.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7401{"datetime_beginning_utc": "2026-10-11T04:15:16", "datetime_beginning_ept": "2026-10-11T00:15:16", "reserve_name": "RTO Synchronized Reserve Requirement from Markets", "reserve_mw": 1810.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7402{"datetime_beginning_utc": "2026-10-11T04:15:16", "datetime_beginning_ept": "2026-10-11T00:15:16", "reserve_name": "RTO Synchronized Reserve Total", "reserve_mw": 3194.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7403{"datetime_beginning_utc": "2026-10-11T04:15:01", "datetime_beginning_ept": "2026-10-11T00:15:01", "reserve_name": "Mid-Atlantic/Dominion Contingency (Primary) Reserve Total", "reserve_mw": 2682.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7404{"datetime_beginning_utc": "2026-10-11T04:15:01", "datetime_beginning_ept": "2026-10-11T00:15:01", "reserve_name": "Mid-Atlantic/Dominion Operating (30 Min) Reserve Total", "reserve_mw": 8483.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7405{"datetime_beginning_utc": "2026-10-11T04:15:01", "datetime_beginning_ept": "2026-10-11T00:15:01", "reserve_name": "Mid-Atlantic/Dominion Primary Reserve Requirement from Markets", "reserve_mw": 2240.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7406{"datetime_beginning_utc": "2026-10-11T04:15:01", "datetime_beginning_ept": "2026-10-11T00:15:01", "reserve_name": "Mid-Atlantic/Dominion Synchronized Reserve Requirement from Markets", "reserve_mw": 1557.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7393{"datetime_beginning_utc": "2026-10-11T04:15:16", "datetime_beginning_ept": "2026-10-11T00:15:16", "reserve_name": "Mid-Atlantic/Dominion Synchronized Reserve Requirement from Markets", "reserve_mw": 1557.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7376{"datetime_beginning_utc": "2026-10-11T04:15:46", "datetime_beginning_ept": "2026-10-11T00:15:46", "reserve_name": "RTO Synchronized Reserve Total", "reserve_mw": 3194.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7395{"datetime_beginning_utc": "2026-10-11T04:15:16", "datetime_beginning_ept": "2026-10-11T00:15:16", "reserve_name": "RTO 30 Minute Reserve Requirement from Markets", "reserve_mw": 3190.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7396{"datetime_beginning_utc": "2026-10-11T04:15:16", "datetime_beginning_ept": "2026-10-11T00:15:16", "reserve_name": "RTO Contingency (Primary) Reserve Requirement", "reserve_mw": 1966.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7397{"datetime_beginning_utc": "2026-10-11T04:15:16", "datetime_beginning_ept": "2026-10-11T00:15:16", "reserve_name": "RTO Contingency (Primary) Reserve Total", "reserve_mw": 5368.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7398{"datetime_beginning_utc": "2026-10-11T04:15:16", "datetime_beginning_ept": "2026-10-11T00:15:16", "reserve_name": "RTO Operating (30 Min) Reserve Total", "reserve_mw": 15953.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7399{"datetime_beginning_utc": "2026-10-11T04:15:16", "datetime_beginning_ept": "2026-10-11T00:15:16", "reserve_name": "RTO Primary Reserve Requirement from Markets", "reserve_mw": 2620.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7394{"datetime_beginning_utc": "2026-10-11T04:15:16", "datetime_beginning_ept": "2026-10-11T00:15:16", "reserve_name": "Mid-Atlantic/Dominion Synchronized Reserve Total", "reserve_mw": 1269.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7382{"datetime_beginning_utc": "2026-10-11T04:15:31", "datetime_beginning_ept": "2026-10-11T00:15:31", "reserve_name": "RTO 30 Minute Reserve Requirement from Markets", "reserve_mw": 3190.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7385{"datetime_beginning_utc": "2026-10-11T04:15:31", "datetime_beginning_ept": "2026-10-11T00:15:31", "reserve_name": "RTO Operating (30 Min) Reserve Total", "reserve_mw": 15952.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7384{"datetime_beginning_utc": "2026-10-11T04:15:31", "datetime_beginning_ept": "2026-10-11T00:15:31", "reserve_name": "RTO Contingency (Primary) Reserve Total", "reserve_mw": 5384.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7386{"datetime_beginning_utc": "2026-10-11T04:15:31", "datetime_beginning_ept": "2026-10-11T00:15:31", "reserve_name": "RTO Primary Reserve Requirement from Markets", "reserve_mw": 2620.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146
2026-10-11 04:22:48.200075operational_reserves2026-10-11https://api.pjm.com/api/v1/operational_reserves?datetime_beginning_utc=10%2F11%2F2026+04%3A00+to+10%2F12%2F2026+03%3A59&startRow=1&rowCount=5000operational_reserves-page-1.json027fde0cbbeb13810b5f920f7c5d49cc52a4122a6ff231d05b37e34628e26ad7383{"datetime_beginning_utc": "2026-10-11T04:15:31", "datetime_beginning_ept": "2026-10-11T00:15:31", "reserve_name": "RTO Contingency (Primary) Reserve Requirement", "reserve_mw": 1967.0}{"last-modified": "Sun, 11 Oct 2026 04:22:48 GMT", "content-type": "application/json", "totalRows": 1196, "startRow": 1}2026-10-11 04:22:48.3248032026-10-11 04:22:49.206146

Coverage

100.0% complete0 gap days9 days with data
Show coverage history
Coverage: 100.0%Days with data: 9Gaps: 0
2026
gaplessmore