Ask the Grid
Create free workspace
TVA logo

TVA Reservoir Inflow and Elevation Forecasts

TVA daily average inflow/outflow in cfs and predicted midnight reservoir elevation in feet for the published three-day horizon.

Hydrology dataTVA market
Query with the agent
Native record
publication snapshot x requested location x day
daily and intraday 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

snapshot_time is when collected; TVA does not supply an issuance timestamp.

Query contract

Preserve one canonical row per (location_id, snapshot_time, day) 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.

Schema9

Column
Type
location_idString
snapshot_timeDateTime64(6, 'UTC')
source_urlString
source_recordString
dayString
average_inflowNullable(String)
midnight_elevationNullable(String)
average_outflowNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample data

location_idsnapshot_timesource_urlsource_recorddayaverage_inflowmidnight_elevationaverage_outflowingested_at
WTGT12026-10-13 23:51:42.153006https://www.tva.com/RestApi/predicted-data/WTGT1{"Day":"10/13/2026","AverageInflow":"660","MidnightElevation":1949.50977,"AverageOutflow":"200"}10/13/20266601949.509772002026-10-13 23:51:42.167775
WTGT12026-10-13 23:51:42.153006https://www.tva.com/RestApi/predicted-data/WTGT1{"Day":"10/14/2026","AverageInflow":"295","MidnightElevation":1949.54,"AverageOutflow":"200"}10/14/20262951949.542002026-10-13 23:51:42.167775
WTGT12026-10-13 23:51:42.153006https://www.tva.com/RestApi/predicted-data/WTGT1{"Day":"10/15/2026","AverageInflow":"218","MidnightElevation":1949.5498,"AverageOutflow":"200"}10/15/20262181949.54982002026-10-13 23:51:42.167775
WLSA12026-10-13 23:51:38.811112https://www.tva.com/RestApi/predicted-data/WLSA1{"Day":"10/13/2026","AverageInflow":"30,338","MidnightElevation":506.92,"AverageOutflow":"30,765"}10/13/202630,338506.9230,7652026-10-13 23:51:38.834004
WLSA12026-10-13 23:51:38.811112https://www.tva.com/RestApi/predicted-data/WLSA1{"Day":"10/14/2026","AverageInflow":"31,642","MidnightElevation":506.800018,"AverageOutflow":"32,565"}10/14/202631,642506.80001832,5652026-10-13 23:51:38.834004
WLSA12026-10-13 23:51:38.811112https://www.tva.com/RestApi/predicted-data/WLSA1{"Day":"10/15/2026","AverageInflow":"31,635","MidnightElevation":506.800018,"AverageOutflow":"31,635"}10/15/202631,635506.80001831,6352026-10-13 23:51:38.834004
WLCK22026-10-13 23:51:35.493252https://www.tva.com/RestApi/predicted-data/WLCK2{"Day":"10/15/2026","MidnightElevation":694.59,"AverageOutflow":"4,450"}10/15/2026∅694.594,4502026-10-13 23:51:35.509777
WLCK22026-10-13 23:51:35.493252https://www.tva.com/RestApi/predicted-data/WLCK2{"Day":"10/14/2026","MidnightElevation":694.790039,"AverageOutflow":"4,450"}10/14/2026∅694.7900394,4502026-10-13 23:51:35.509777
WLCK22026-10-13 23:51:35.493252https://www.tva.com/RestApi/predicted-data/WLCK2{"Day":"10/13/2026","MidnightElevation":694.990051,"AverageOutflow":"4,420"}10/13/2026∅694.9900514,4202026-10-13 23:51:35.509777
WL2026-10-13 23:51:32.040679https://www.tva.com/RestApi/predicted-data/WL{"Day":"10/13/2026","MidnightElevation":1647.11,"AverageOutflow":"340"}10/13/2026∅1647.113402026-10-13 23:51:32.055819
WL2026-10-13 23:51:32.040679https://www.tva.com/RestApi/predicted-data/WL{"Day":"10/14/2026","MidnightElevation":1647.49011,"AverageOutflow":"340"}10/14/2026∅1647.490113402026-10-13 23:51:32.055819
WL2026-10-13 23:51:32.040679https://www.tva.com/RestApi/predicted-data/WL{"Day":"10/15/2026","MidnightElevation":1647.96021,"AverageOutflow":"340"}10/15/2026∅1647.960213402026-10-13 23:51:32.055819
WHLA12026-10-13 23:51:28.944567https://www.tva.com/RestApi/predicted-data/WHLA1{"Day":"10/15/2026","AverageInflow":"29,452","MidnightElevation":553.2,"AverageOutflow":"32,180"}10/15/202629,452553.232,1802026-10-13 23:51:28.961036
WHLA12026-10-13 23:51:28.944567https://www.tva.com/RestApi/predicted-data/WHLA1{"Day":"10/14/2026","AverageInflow":"29,543","MidnightElevation":553.29,"AverageOutflow":"32,180"}10/14/202629,543553.2932,1802026-10-13 23:51:28.961036
WHLA12026-10-13 23:51:28.944567https://www.tva.com/RestApi/predicted-data/WHLA1{"Day":"10/13/2026","AverageInflow":"31,627","MidnightElevation":553.369934,"AverageOutflow":"30,425"}10/13/202631,627553.36993430,4252026-10-13 23:51:28.961036
WBOT12026-10-13 23:51:25.628438https://www.tva.com/RestApi/predicted-data/WBOT1{"Day":"10/15/2026","AverageInflow":"30,065","MidnightElevation":740.7,"AverageOutflow":"30,420"}10/15/202630,065740.730,4202026-10-13 23:51:25.643109
WBOT12026-10-13 23:51:25.628438https://www.tva.com/RestApi/predicted-data/WBOT1{"Day":"10/13/2026","AverageInflow":"29,842","MidnightElevation":740.809937,"AverageOutflow":"29,723"}10/13/202629,842740.80993729,7232026-10-13 23:51:25.643109
WBOT12026-10-13 23:51:25.628438https://www.tva.com/RestApi/predicted-data/WBOT1{"Day":"10/14/2026","AverageInflow":"28,740","MidnightElevation":740.72,"AverageOutflow":"30,420"}10/14/202628,740740.7230,4202026-10-13 23:51:25.643109
UBRA12026-10-13 23:51:22.207741https://www.tva.com/RestApi/predicted-data/UBRA1{"Day":"10/13/2026","AverageInflow":"30","MidnightElevation":796.07,"AverageOutflow":"10"}10/13/202630796.07102026-10-13 23:51:22.228832
UBRA12026-10-13 23:51:22.207741https://www.tva.com/RestApi/predicted-data/UBRA1{"Day":"10/14/2026","AverageInflow":"25","MidnightElevation":796.08,"AverageOutflow":"10"}10/14/202625796.08102026-10-13 23:51:22.228832
UBRA12026-10-13 23:51:22.207741https://www.tva.com/RestApi/predicted-data/UBRA1{"Day":"10/15/2026","AverageInflow":"20","MidnightElevation":796.09,"AverageOutflow":"10"}10/15/202620796.09102026-10-13 23:51:22.228832
TMFT12026-10-13 23:51:18.497490https://www.tva.com/RestApi/predicted-data/TMFT1{"Day":"10/13/2026","AverageInflow":"10","MidnightElevation":887.12,"AverageOutflow":"240"}10/13/202610887.122402026-10-13 23:51:18.512999
TMFT12026-10-13 23:51:18.497490https://www.tva.com/RestApi/predicted-data/TMFT1{"Day":"10/14/2026","AverageInflow":"-7","MidnightElevation":887.0701,"AverageOutflow":"240"}10/14/2026-7887.07012402026-10-13 23:51:18.512999
TMFT12026-10-13 23:51:18.497490https://www.tva.com/RestApi/predicted-data/TMFT1{"Day":"10/15/2026","AverageInflow":"-20","MidnightElevation":887.02,"AverageOutflow":"240"}10/15/2026-20887.022402026-10-13 23:51:18.512999
TDTT12026-10-13 23:51:15.486705https://www.tva.com/RestApi/predicted-data/TDTT1{"Day":"10/13/2026","MidnightElevation":812.47,"AverageOutflow":"0"}10/13/2026∅812.4702026-10-13 23:51:15.502060

Coverage

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