Ask the Grid
Create free workspace
TVA logo

TVA Hydro Generation Release Schedules

Scheduled generator counts by printed local-time interval.

Generation dataTVA market
Query with the agent
Native record
publication snapshot x requested location x day x time_label
intraday schedule revisions, collected every 15 minutes publication cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
Time basis
Point-in-time records
UTC · snapshot_time

Overview

Generators can be qualitative, such as 2 or more. These are operating schedules, not observed electrical MW or confirmed discharge; retain time_label and check the latest complete snapshot.

Query contract

Preserve one canonical row per (location_id, snapshot_time, day, time_label) before aggregating.

Analysis rules

  • For current state, select the latest complete snapshot_time per location_id from tva.feed_snapshots for this table. A row_count of zero means empty; never fall back to an older nonempty snapshot.

Interpretation

  • snapshot_time is collection time. Check the source day/time labels before describing data as current.
  • Raw strings preserve source units, missing-value sentinels and estimation marks; source_record retains all source fields.

Access

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

Schema8

Column
Type
location_idString
snapshot_timeDateTime64(6, 'UTC')
source_urlString
source_recordString
dayString
time_labelString
generatorsNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample data

location_idsnapshot_timesource_urlsource_recorddaytime_labelgeneratorsingested_at
WTGT12026-10-13 23:51:42.969687https://www.tva.com/RestApi/generation-releases/WTGT1{"Day":"10/13/2026","Time":"1 AM - Midnight EDT","Generators":"0"}10/13/20261 AM - Midnight EDT02026-10-13 23:51:42.984659
WTGT12026-10-13 23:51:42.969687https://www.tva.com/RestApi/generation-releases/WTGT1{"Day":"10/14/2026","Time":"Midnight - Midnight EDT","Generators":"0"}10/14/2026Midnight - Midnight EDT02026-10-13 23:51:42.984659
WTGT12026-10-13 23:51:42.969687https://www.tva.com/RestApi/generation-releases/WTGT1{"Day":"10/15/2026","Time":"Midnight - 1 AM EDT","Generators":"0"}10/15/2026Midnight - 1 AM EDT02026-10-13 23:51:42.984659
WLSA12026-10-13 23:51:39.598782https://www.tva.com/RestApi/generation-releases/WLSA1{"Day":"10/14/2026","Time":"Midnight - Midnight CDT","Generators":"2 or more"}10/14/2026Midnight - Midnight CDT2 or more2026-10-13 23:51:39.614716
WLSA12026-10-13 23:51:39.598782https://www.tva.com/RestApi/generation-releases/WLSA1{"Day":"10/13/2026","Time":"Midnight - Midnight CDT","Generators":"2 or more"}10/13/2026Midnight - Midnight CDT2 or more2026-10-13 23:51:39.614716
WLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2{"Day":"10/13/2026","Time":"10 AM - Noon CDT","Generators":"1"}10/13/202610 AM - Noon CDT12026-10-13 23:51:36.280856
WLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2{"Day":"10/13/2026","Time":"11 PM - Midnight CDT","Generators":"0"}10/13/202611 PM - Midnight CDT02026-10-13 23:51:36.280856
WLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2{"Day":"10/13/2026","Time":"6 AM - 7 AM CDT","Generators":"2 or more"}10/13/20266 AM - 7 AM CDT2 or more2026-10-13 23:51:36.280856
WLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2{"Day":"10/13/2026","Time":"7 AM - 10 AM CDT","Generators":"0"}10/13/20267 AM - 10 AM CDT02026-10-13 23:51:36.280856
WLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2{"Day":"10/13/2026","Time":"Midnight - 6 AM CDT","Generators":"0"}10/13/2026Midnight - 6 AM CDT02026-10-13 23:51:36.280856
WLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2{"Day":"10/13/2026","Time":"Noon - 11 PM CDT","Generators":"2 or more"}10/13/2026Noon - 11 PM CDT2 or more2026-10-13 23:51:36.280856
WLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2{"Day":"10/14/2026","Time":"10 PM - Midnight CDT","Generators":"0"}10/14/202610 PM - Midnight CDT02026-10-13 23:51:36.280856
WLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2{"Day":"10/14/2026","Time":"11 AM - 10 PM CDT","Generators":"2 or more"}10/14/202611 AM - 10 PM CDT2 or more2026-10-13 23:51:36.280856
WLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2{"Day":"10/14/2026","Time":"6 AM - 11 AM CDT","Generators":"1"}10/14/20266 AM - 11 AM CDT12026-10-13 23:51:36.280856
WLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2{"Day":"10/14/2026","Time":"Midnight - 6 AM CDT","Generators":"0"}10/14/2026Midnight - 6 AM CDT02026-10-13 23:51:36.280856
WL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL{"Day":"10/14/2026","Time":"6 PM - 7 PM EDT","Generators":"2 or more"}10/14/20266 PM - 7 PM EDT2 or more2026-10-13 23:51:32.838602
WL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL{"Day":"10/15/2026","Time":"Midnight - 1 AM EDT","Generators":"0"}10/15/2026Midnight - 1 AM EDT02026-10-13 23:51:32.838602
WL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL{"Day":"10/14/2026","Time":"Midnight - 6 AM EDT","Generators":"0"}10/14/2026Midnight - 6 AM EDT02026-10-13 23:51:32.838602
WL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL{"Day":"10/14/2026","Time":"7 PM - Midnight EDT","Generators":"0"}10/14/20267 PM - Midnight EDT02026-10-13 23:51:32.838602
WL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL{"Day":"10/14/2026","Time":"7 AM - 6 PM EDT","Generators":"0"}10/14/20267 AM - 6 PM EDT02026-10-13 23:51:32.838602
WL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL{"Day":"10/13/2026","Time":"1 AM - 6 AM EDT","Generators":"0"}10/13/20261 AM - 6 AM EDT02026-10-13 23:51:32.838602
WL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL{"Day":"10/13/2026","Time":"6 AM - 7 AM EDT","Generators":"2 or more"}10/13/20266 AM - 7 AM EDT2 or more2026-10-13 23:51:32.838602
WL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL{"Day":"10/13/2026","Time":"6 PM - 7 PM EDT","Generators":"2 or more"}10/13/20266 PM - 7 PM EDT2 or more2026-10-13 23:51:32.838602
WL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL{"Day":"10/13/2026","Time":"7 AM - 6 PM EDT","Generators":"0"}10/13/20267 AM - 6 PM EDT02026-10-13 23:51:32.838602
WL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL{"Day":"10/13/2026","Time":"7 PM - Midnight EDT","Generators":"0"}10/13/20267 PM - Midnight EDT02026-10-13 23:51:32.838602

Coverage

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