Ask the Grid
Create free workspace
TVA logo

TVA City River Elevations and Forecasts

Midnight river elevations in feet for 11 cities, with the observed day and three forecast days in one publication.

Hydrology dataTVA market
Query with the agent
Native record
publication snapshot x requested location x city x day
daily values, collected every 15 minutes publication cadence
Evidence
Mixed evidence
Multiple evidence types kept distinct in the contract
Time basis
Point-in-time records
UTC · snapshot_time

Overview

The response does not label evidence per row; preserve the whole snapshot and its date context rather than calling every row observed.

Query contract

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

Schema8

Column
Type
location_idString
snapshot_timeDateTime64(6, 'UTC')
source_urlString
source_recordString
cityString
dayString
elevationNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample data

location_idsnapshot_timesource_urlsource_recordcitydayelevationingested_at
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Knoxville","Day":"10/13/2026","Elevation":"812.546154"}Knoxville10/13/2026812.5461542026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Chattanooga (Selected)","Day":"10/12/2026","Elevation":"634.07002"}Chattanooga (Selected)10/12/2026634.070022026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Chattanooga (Selected)","Day":"10/13/2026","Elevation":"634.160768"}Chattanooga (Selected)10/13/2026634.1607682026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Chattanooga (Selected)","Day":"10/14/2026","Elevation":"634.198858"}Chattanooga (Selected)10/14/2026634.1988582026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Chattanooga (Selected)","Day":"10/15/2026","Elevation":"634.56533"}Chattanooga (Selected)10/15/2026634.565332026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Decatur","Day":"10/12/2026","Elevation":"553.380005"}Decatur10/12/2026553.3800052026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Decatur","Day":"10/13/2026","Elevation":"553.4489025"}Decatur10/13/2026553.44890252026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Decatur","Day":"10/14/2026","Elevation":"553.3474587"}Decatur10/14/2026553.34745872026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Decatur","Day":"10/15/2026","Elevation":"553.2474264"}Decatur10/15/2026553.24742642026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Florence","Day":"10/12/2026","Elevation":"411.420013"}Florence10/12/2026411.4200132026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Florence","Day":"10/13/2026","Elevation":"411.767716"}Florence10/13/2026411.7677162026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Florence","Day":"10/14/2026","Elevation":"412.0209"}Florence10/14/2026412.02092026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Florence","Day":"10/15/2026","Elevation":"412.0028875"}Florence10/15/2026412.00288752026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Johnsonville","Day":"10/12/2026","Elevation":"354.149998"}Johnsonville10/12/2026354.1499982026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Johnsonville","Day":"10/13/2026","Elevation":"354.3041"}Johnsonville10/13/2026354.30412026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Johnsonville","Day":"10/14/2026","Elevation":"354.3102"}Johnsonville10/14/2026354.31022026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Johnsonville","Day":"10/15/2026","Elevation":"354.154266"}Johnsonville10/15/2026354.1542662026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Kingston","Day":"10/12/2026","Elevation":"741.020367"}Kingston10/12/2026741.0203672026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Kingston","Day":"10/13/2026","Elevation":"741.102781"}Kingston10/13/2026741.1027812026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Kingston","Day":"10/14/2026","Elevation":"741.008781"}Kingston10/14/2026741.0087812026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Whitesburg","Day":"10/15/2026","Elevation":"554.09677"}Whitesburg10/15/2026554.096772026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Knoxville","Day":"10/12/2026","Elevation":"812.810033"}Knoxville10/12/2026812.8100332026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"Kingston","Day":"10/15/2026","Elevation":"740.989918"}Kingston10/15/2026740.9899182026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"South Pittsburg","Day":"10/12/2026","Elevation":"595.81002"}South Pittsburg10/12/2026595.810022026-10-13 23:52:09.359968
2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations{"City":"South Pittsburg","Day":"10/14/2026","Elevation":"596.628129"}South Pittsburg10/14/2026596.6281292026-10-13 23:52:09.359968

Coverage

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