PJM logo

Very Short-Term Load Forecast

PJM's very-short-term load forecast by forecast area, covering roughly the next two hours at fine granularity.

Native record
forecast area x target interval x issue vintage
sub-hourly (~2h horizon) publication cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
Time basis
Interval-start records
UTC · event_time

Overview

Rows are keyed by their target time (event_time) with the issue time in evaluated_at_utc, so the latest vintage for each target comes from an argMax over evaluated_at_utc. Forecast areas use utility names (AE/MIDATL, DOMINION, and RTO_COMBINED for the system total). Use it for the immediate demand trajectory; for tomorrow and the week ahead use the 7-day forecast. Source: PJM Market Data.

Query contract

Select argMax(forecast_load_mw, evaluated_at_utc) per target interval and area.

Analysis rules

  • Do not sum issue vintages.
  • query_data applies the latest issue vintage before aggregation. Use max(forecast_load_mw) with arg_max(event_time by forecast_load_mw) for a peak; do not write SQL for that single-dataset extremum.

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_very_short_load_frcst/query

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

Schema7

Column
Type
event_timeDateTime64(6, 'UTC')
evaluated_at_utcDateTime64(6, 'UTC')
forecast_datetime_beginning_utcNullable(String)
forecast_datetime_ending_utcNullable(String)
forecast_areaLowCardinality(String)
forecast_load_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeevaluated_at_utcforecast_datetime_beginning_utcforecast_datetime_ending_utcforecast_areaforecast_load_mwingested_at
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00WESTERN_REGION461002026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00UGI/MIDATL1002026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00SOUTHERN_REGION151082026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00RTO_COMBINED872802026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00RECO/MIDATL1542026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00PSE&G/MIDATL41242026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00PPL/MIDATL38852026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00PEPCO/MIDATL27912026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00PENELEC/MIDATL18602026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00PECO/MIDATL37562026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00MID_ATLANTIC_REGION260722026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00METED/MIDATL15882026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00JCP&L/MIDATL20452026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00EKPC13542026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00DUQUESNE13182026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00DP&L/MIDATL16642026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00DOMINION151082026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00DEOK25612026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00DAYTON18542026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00COMED103792026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00BG&E/MIDATL28952026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00ATSI74742026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00AP51082026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00AEP160522026-10-12 10:41:40.274008
2026-10-12 12:35:00.0000002026-10-12 10:40:00.0000002026-10-12T12:35:002026-10-12T12:40:00AE/MIDATL9062026-10-12 10:41:40.274008

Coverage

93.8% complete9 gap days136 days with data
Show coverage history
Coverage: 93.8%Days with data: 136Gaps: 9
2026
gaplessmore