TVA Recreation Calendar Status Keys

The companion calendar colors as printed.

Hydrology data TVA market

Query with the agent

Native record

publication snapshot x requested location x date_label

daily collection publication cadence

Evidence

Reference data

Stable context used to interpret other datasets

Time basis

Point-in-time records

UTC · snapshot_time

Overview

Join one snapshot of each publication by location_id and date_label; colors encode the source calendar legend and are not a measured flow.

Query contract

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

Schema9

Column

Type

location_idString

snapshot_timeDateTime64(6, 'UTC')

source_urlString

source_recordString

date_labelString

background_colorNullable(String)

colorNullable(String)

border_colorNullable(String)

ingested_atDateTime64(6, 'UTC')

Sample data

location_id	snapshot_time	source_url	source_record	date_label	background_color	color	border_color	ingested_at
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778889600000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778889600000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778803200000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778803200000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778716800000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778716800000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778630400000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778630400000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778544000000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778544000000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778457600000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778457600000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778371200000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778371200000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778284800000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778284800000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778198400000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778198400000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778112000000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778112000000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1778025600000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1778025600000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777939200000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777939200000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777852800000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777852800000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777766400000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777766400000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777680000000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777680000000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777593600000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777593600000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777507200000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777507200000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777420800000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777420800000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777334400000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777334400000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777248000000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777248000000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777161600000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777161600000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1775001600000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1775001600000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1776988800000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1776988800000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1777075200000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1777075200000-0000)/	white	black	white	2026-10-13 21:58:35.351060
WTGT1	2026-10-13 21:58:35.334063	https://www.tva.com/RestApi/recreation-schedule-detail/WTGT1	{"Date":"/Date(1775520000000-0000)/","BackgroundColor":"white","Color":"black","BorderColor":"white"}	/Date(1775520000000-0000)/	white	black	white	2026-10-13 21:58:35.351060

Coverage

100.0% complete0 gap days1 days with data

Show coverage history

Coverage: 100.0%Days with data: 1Gaps: 0

2026

gaplessmore

Related hydrology data

Related hydrology data
Dataset	Description
TVA City River Elevations and ForecastsTVA · daily values, collected every 15 minutes	Midnight river elevations in feet for 11 cities, with the observed day and three forecast days in one publication. The response does not label evidence per row; preserve the whole snapshot and its date context rather than calling every row observed.
TVA Recreation Release CalendarsTVA · daily collection	TVA annual recreation-release calendar descriptions and source Microsoft JSON date labels. Blank days are retained. Wilbur uses Watauga publication WTGT1; a recreation calendar is distinct from the current generation schedule.
TVA Reservoir Hourly ObservationsTVA · hourly observations, collected every 15 minutes	The published rolling 48 hours of reservoir elevation, tailwater elevation (feet above mean sea level) and average hourly discharge (cubic feet per second). Raw day and time_label preserve EDT/EST/CDT/CST. Midnight denotes the end of the printed day. Source sentinel values and missing readings are retained.
TVA Reservoir Inflow and Elevation ForecastsTVA · daily and intraday revisions, collected every 15 minutes	TVA daily average inflow/outflow in cfs and predicted midnight reservoir elevation in feet for the published three-day horizon. snapshot_time is when collected; TVA does not supply an issuance timestamp.