
Native record
publisher period x document x sheet/archive member x source row x collected revision
Evidence
Mixed evidence
Time basis
Date-labelled records
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
Analysis rules
Interpretation
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_day_gen_capacity/queryNeed 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_dateDate32source_urlStringsource_memberStringsource_sha256Stringrow_indexInt64record_jsonStringresponse_metadataStringingested_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 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 0 | {"bid_datetime_beginning_utc": "2026-10-09T04:00:00", "bid_datetime_beginning_ept": "2026-10-09T00:00:00", "eco_max": 146820.9, "emerg_max": 147624.4, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 22 | {"bid_datetime_beginning_utc": "2026-10-10T02:00:00", "bid_datetime_beginning_ept": "2026-10-09T22:00:00", "eco_max": 153226.8, "emerg_max": 153960.4, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 23 | {"bid_datetime_beginning_utc": "2026-10-10T03:00:00", "bid_datetime_beginning_ept": "2026-10-09T23:00:00", "eco_max": 153040.8, "emerg_max": 153591.1, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 15 | {"bid_datetime_beginning_utc": "2026-10-09T19:00:00", "bid_datetime_beginning_ept": "2026-10-09T15:00:00", "eco_max": 157078.0, "emerg_max": 157631.2, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 16 | {"bid_datetime_beginning_utc": "2026-10-09T20:00:00", "bid_datetime_beginning_ept": "2026-10-09T16:00:00", "eco_max": 155656.6, "emerg_max": 156221.7, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 17 | {"bid_datetime_beginning_utc": "2026-10-09T21:00:00", "bid_datetime_beginning_ept": "2026-10-09T17:00:00", "eco_max": 152608.5, "emerg_max": 153176.2, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 18 | {"bid_datetime_beginning_utc": "2026-10-09T22:00:00", "bid_datetime_beginning_ept": "2026-10-09T18:00:00", "eco_max": 150318.2, "emerg_max": 150879.5, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 19 | {"bid_datetime_beginning_utc": "2026-10-09T23:00:00", "bid_datetime_beginning_ept": "2026-10-09T19:00:00", "eco_max": 151016.5, "emerg_max": 151563.0, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 20 | {"bid_datetime_beginning_utc": "2026-10-10T00:00:00", "bid_datetime_beginning_ept": "2026-10-09T20:00:00", "eco_max": 152626.1, "emerg_max": 153151.7, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 21 | {"bid_datetime_beginning_utc": "2026-10-10T01:00:00", "bid_datetime_beginning_ept": "2026-10-09T21:00:00", "eco_max": 153314.0, "emerg_max": 154014.1, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 8 | {"bid_datetime_beginning_utc": "2026-10-09T12:00:00", "bid_datetime_beginning_ept": "2026-10-09T08:00:00", "eco_max": 155163.5, "emerg_max": 155716.5, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 9 | {"bid_datetime_beginning_utc": "2026-10-09T13:00:00", "bid_datetime_beginning_ept": "2026-10-09T09:00:00", "eco_max": 159022.2, "emerg_max": 159568.6, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 10 | {"bid_datetime_beginning_utc": "2026-10-09T14:00:00", "bid_datetime_beginning_ept": "2026-10-09T10:00:00", "eco_max": 159018.8, "emerg_max": 159956.7, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 11 | {"bid_datetime_beginning_utc": "2026-10-09T15:00:00", "bid_datetime_beginning_ept": "2026-10-09T11:00:00", "eco_max": 159237.2, "emerg_max": 159752.1, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 12 | {"bid_datetime_beginning_utc": "2026-10-09T16:00:00", "bid_datetime_beginning_ept": "2026-10-09T12:00:00", "eco_max": 158437.2, "emerg_max": 158982.8, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 13 | {"bid_datetime_beginning_utc": "2026-10-09T17:00:00", "bid_datetime_beginning_ept": "2026-10-09T13:00:00", "eco_max": 158697.6, "emerg_max": 159243.2, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 14 | {"bid_datetime_beginning_utc": "2026-10-09T18:00:00", "bid_datetime_beginning_ept": "2026-10-09T14:00:00", "eco_max": 157649.5, "emerg_max": 158198.5, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 1 | {"bid_datetime_beginning_utc": "2026-10-09T05:00:00", "bid_datetime_beginning_ept": "2026-10-09T01:00:00", "eco_max": 146734.5, "emerg_max": 147528.7, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 2 | {"bid_datetime_beginning_utc": "2026-10-09T06:00:00", "bid_datetime_beginning_ept": "2026-10-09T02:00:00", "eco_max": 146940.0, "emerg_max": 147729.1, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 3 | {"bid_datetime_beginning_utc": "2026-10-09T07:00:00", "bid_datetime_beginning_ept": "2026-10-09T03:00:00", "eco_max": 147110.7, "emerg_max": 147891.6, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 4 | {"bid_datetime_beginning_utc": "2026-10-09T08:00:00", "bid_datetime_beginning_ept": "2026-10-09T04:00:00", "eco_max": 147569.2, "emerg_max": 148350.3, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 5 | {"bid_datetime_beginning_utc": "2026-10-09T09:00:00", "bid_datetime_beginning_ept": "2026-10-09T05:00:00", "eco_max": 149106.8, "emerg_max": 149880.6, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 6 | {"bid_datetime_beginning_utc": "2026-10-09T10:00:00", "bid_datetime_beginning_ept": "2026-10-09T06:00:00", "eco_max": 150634.5, "emerg_max": 151243.5, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:37.706737 | day_gen_capacity | 2026-10-09 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F09%2F2026+04%3A00+to+10%2F10%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 1d4f62d65fbbde1f0f74d2f14e1dbe62173c9b5890044184049bd86593acad67 | 7 | {"bid_datetime_beginning_utc": "2026-10-09T11:00:00", "bid_datetime_beginning_ept": "2026-10-09T07:00:00", "eco_max": 151893.1, "emerg_max": 152451.7, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:37 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:37.720140 | 2026-10-11 03:17:37.859651 |
| 2026-10-11 03:17:35.858646 | day_gen_capacity | 2026-10-08 | https://api.pjm.com/api/v1/day_gen_capacity?bid_datetime_beginning_utc=10%2F08%2F2026+04%3A00+to+10%2F09%2F2026+03%3A59&startRow=1&rowCount=5000 | day_gen_capacity-page-1.json | 2e0a2cc31ed9e5c52ce25bc9d387faf83c47d7eb6780108cebebe35724fbd46c | 0 | {"bid_datetime_beginning_utc": "2026-10-08T04:00:00", "bid_datetime_beginning_ept": "2026-10-08T00:00:00", "eco_max": 147907.6, "emerg_max": 148664.4, "total_committed": 142372.2} | {"last-modified": "Sun, 11 Oct 2026 03:17:35 GMT", "content-type": "application/json", "totalRows": 24, "startRow": 1} | 2026-10-11 03:17:35.873397 | 2026-10-11 03:17:35.990271 |
Coverage
100.0% complete0 gap days7 days with data
Show coverage history
Coverage: 100.0%Days with data: 7Gaps: 0
2026
gaplessmore
