Ask the Grid
Create free workspace
TVA logo

TVA Publication Snapshot Coverage

One completion record per table, requested location and collection, including row_count=0.

Infrastructure dataTVA market
Query with the agent
Native record
publication snapshot x requested location x table_name
each collection publication cadence
Evidence
Reference data
Stable context used to interpret other datasets
Time basis
Point-in-time records
UTC · snapshot_time

Overview

An empty latest publication withdraws older schedules. Collection timestamps indicate retrieval, not source observation freshness.

Query contract

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

Schema6

Column
Type
table_nameString
location_idString
snapshot_timeDateTime64(6, 'UTC')
source_urlString
row_countInt64
ingested_atDateTime64(6, 'UTC')

Sample data

table_namelocation_idsnapshot_timesource_urlrow_countingested_at
stream_flows2026-10-13 23:52:10.909130https://www.tva.com/RestApi/valley-stream-flows352026-10-13 23:52:11.073010
river_elevations2026-10-13 23:52:09.259789https://www.tva.com/RestApi/city-river-elevations442026-10-13 23:52:10.249103
lake_messagesWTGT12026-10-13 23:51:43.809071https://www.tva.com/RestApi/lake-messages/WTGT112026-10-13 23:51:43.948459
generation_releasesWTGT12026-10-13 23:51:42.969687https://www.tva.com/RestApi/generation-releases/WTGT132026-10-13 23:51:43.105993
reservoir_forecastsWTGT12026-10-13 23:51:42.153006https://www.tva.com/RestApi/predicted-data/WTGT132026-10-13 23:51:42.306200
reservoir_observationsWTGT12026-10-13 23:51:41.304922https://www.tva.com/RestApi/observed-data-48-hours/WTGT1482026-10-13 23:51:41.455865
lake_messagesWLSA12026-10-13 23:51:40.443192https://www.tva.com/RestApi/lake-messages/WLSA112026-10-13 23:51:40.592786
generation_releasesWLSA12026-10-13 23:51:39.598782https://www.tva.com/RestApi/generation-releases/WLSA122026-10-13 23:51:39.738668
reservoir_forecastsWLSA12026-10-13 23:51:38.811112https://www.tva.com/RestApi/predicted-data/WLSA132026-10-13 23:51:38.975268
reservoir_observationsWLSA12026-10-13 23:51:37.972496https://www.tva.com/RestApi/observed-data-48-hours/WLSA1482026-10-13 23:51:38.123365
lake_messagesWLCK22026-10-13 23:51:37.101855https://www.tva.com/RestApi/lake-messages/WLCK212026-10-13 23:51:37.253182
generation_releasesWLCK22026-10-13 23:51:36.266123https://www.tva.com/RestApi/generation-releases/WLCK2102026-10-13 23:51:36.412063
reservoir_forecastsWLCK22026-10-13 23:51:35.493252https://www.tva.com/RestApi/predicted-data/WLCK232026-10-13 23:51:35.660543
reservoir_observationsWLCK22026-10-13 23:51:34.675770https://www.tva.com/RestApi/observed-data-48-hours/WLCK2482026-10-13 23:51:34.820798
lake_messagesWL2026-10-13 23:51:33.814633https://www.tva.com/RestApi/lake-messages/WL12026-10-13 23:51:33.968188
generation_releasesWL2026-10-13 23:51:32.823210https://www.tva.com/RestApi/generation-releases/WL112026-10-13 23:51:32.987361
reservoir_forecastsWL2026-10-13 23:51:32.040679https://www.tva.com/RestApi/predicted-data/WL32026-10-13 23:51:32.180545
reservoir_observationsWL2026-10-13 23:51:31.199290https://www.tva.com/RestApi/observed-data-48-hours/WL482026-10-13 23:51:31.357253
lake_messagesWHLA12026-10-13 23:51:30.372153https://www.tva.com/RestApi/lake-messages/WHLA112026-10-13 23:51:30.523942
generation_releasesWHLA12026-10-13 23:51:29.515029https://www.tva.com/RestApi/generation-releases/WHLA152026-10-13 23:51:29.662305
reservoir_forecastsWHLA12026-10-13 23:51:28.944567https://www.tva.com/RestApi/predicted-data/WHLA132026-10-13 23:51:29.087613
reservoir_observationsWHLA12026-10-13 23:51:28.142296https://www.tva.com/RestApi/observed-data-48-hours/WHLA1482026-10-13 23:51:28.286048
lake_messagesWBOT12026-10-13 23:51:27.314052https://www.tva.com/RestApi/lake-messages/WBOT112026-10-13 23:51:27.457359
generation_releasesWBOT12026-10-13 23:51:26.456628https://www.tva.com/RestApi/generation-releases/WBOT132026-10-13 23:51:26.639129
reservoir_forecastsWBOT12026-10-13 23:51:25.628438https://www.tva.com/RestApi/predicted-data/WBOT132026-10-13 23:51:25.801268

Coverage

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