Ask the Grid
Create free workspace
TVA logo

TVA Gauge Daily Precipitation

Daily incremental precipitation in inches with the source accumulation hours and raw Microsoft JSON date.

Weather dataTVA market
Query with the agent
Native record
publication snapshot x requested location x source_location_id x date_label x hours
daily observations, collected every 6 hours publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · snapshot_time

Overview

Each collection rereads seven days for revisions; select the latest snapshot per gauge/date/hours for history. Explicit backfill windows are supported.

Query contract

Preserve one canonical row per (location_id, snapshot_time, source_location_id, date_label, hours) before aggregating.

Analysis rules

  • Use the latest snapshot_time per source_location_id, date_label and hours before summing precipitation.

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.

Schema11

Column
Type
location_idString
snapshot_timeDateTime64(6, 'UTC')
source_urlString
source_recordString
source_location_idString
locationNullable(String)
stateNullable(String)
date_labelString
precipitation_inchesNullable(String)
hoursString
ingested_atDateTime64(6, 'UTC')

Sample data

location_idsnapshot_timesource_urlsource_recordsource_location_idlocationstatedate_labelprecipitation_incheshoursingested_at
YGHG12026-10-13 22:01:31.519935https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YGHG1/Day{"LocationID":"YGHG1","Location":"Young Harris","State":"GA","Date":"/Date(1791849600000-0000)/","PrecipIncremental_IN":0,"Hours":17}YGHG1Young HarrisGA/Date(1791849600000-0000)/0172026-10-13 22:01:31.536313
YGHG12026-10-13 22:01:31.519935https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YGHG1/Day{"LocationID":"YGHG1","Location":"Young Harris","State":"GA","Date":"/Date(1791504000000-0000)/","PrecipIncremental_IN":0,"Hours":24}YGHG1Young HarrisGA/Date(1791504000000-0000)/0242026-10-13 22:01:31.536313
YGHG12026-10-13 22:01:31.519935https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YGHG1/Day{"LocationID":"YGHG1","Location":"Young Harris","State":"GA","Date":"/Date(1791331200000-0000)/","PrecipIncremental_IN":0,"Hours":24}YGHG1Young HarrisGA/Date(1791331200000-0000)/0242026-10-13 22:01:31.536313
YGHG12026-10-13 22:01:31.519935https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YGHG1/Day{"LocationID":"YGHG1","Location":"Young Harris","State":"GA","Date":"/Date(1791417600000-0000)/","PrecipIncremental_IN":0,"Hours":24}YGHG1Young HarrisGA/Date(1791417600000-0000)/0242026-10-13 22:01:31.536313
YGHG12026-10-13 22:01:31.519935https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YGHG1/Day{"LocationID":"YGHG1","Location":"Young Harris","State":"GA","Date":"/Date(1791590400000-0000)/","PrecipIncremental_IN":1.32,"Hours":24}YGHG1Young HarrisGA/Date(1791590400000-0000)/1.32242026-10-13 22:01:31.536313
YGHG12026-10-13 22:01:31.519935https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YGHG1/Day{"LocationID":"YGHG1","Location":"Young Harris","State":"GA","Date":"/Date(1791676800000-0000)/","PrecipIncremental_IN":0.08,"Hours":24}YGHG1Young HarrisGA/Date(1791676800000-0000)/0.08242026-10-13 22:01:31.536313
YGHG12026-10-13 22:01:31.519935https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YGHG1/Day{"LocationID":"YGHG1","Location":"Young Harris","State":"GA","Date":"/Date(1791763200000-0000)/","PrecipIncremental_IN":0,"Hours":24}YGHG1Young HarrisGA/Date(1791763200000-0000)/0242026-10-13 22:01:31.536313
MDLK22026-10-13 22:01:30.429543https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/MDLK2/Day{"LocationID":"MDLK2","Location":"Yellow Creek nr Middlesboro","State":"KY","Date":"/Date(1791590400000-0000)/","PrecipIncremental_IN":0.6,"Hours":24}MDLK2Yellow Creek nr MiddlesboroKY/Date(1791590400000-0000)/0.6242026-10-13 22:01:30.445133
MDLK22026-10-13 22:01:30.429543https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/MDLK2/Day{"LocationID":"MDLK2","Location":"Yellow Creek nr Middlesboro","State":"KY","Date":"/Date(1791331200000-0000)/","PrecipIncremental_IN":0,"Hours":24}MDLK2Yellow Creek nr MiddlesboroKY/Date(1791331200000-0000)/0242026-10-13 22:01:30.445133
MDLK22026-10-13 22:01:30.429543https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/MDLK2/Day{"LocationID":"MDLK2","Location":"Yellow Creek nr Middlesboro","State":"KY","Date":"/Date(1791417600000-0000)/","PrecipIncremental_IN":0,"Hours":24}MDLK2Yellow Creek nr MiddlesboroKY/Date(1791417600000-0000)/0242026-10-13 22:01:30.445133
MDLK22026-10-13 22:01:30.429543https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/MDLK2/Day{"LocationID":"MDLK2","Location":"Yellow Creek nr Middlesboro","State":"KY","Date":"/Date(1791504000000-0000)/","PrecipIncremental_IN":0,"Hours":24}MDLK2Yellow Creek nr MiddlesboroKY/Date(1791504000000-0000)/0242026-10-13 22:01:30.445133
MDLK22026-10-13 22:01:30.429543https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/MDLK2/Day{"LocationID":"MDLK2","Location":"Yellow Creek nr Middlesboro","State":"KY","Date":"/Date(1791849600000-0000)/","PrecipIncremental_IN":0,"Hours":17}MDLK2Yellow Creek nr MiddlesboroKY/Date(1791849600000-0000)/0172026-10-13 22:01:30.445133
MDLK22026-10-13 22:01:30.429543https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/MDLK2/Day{"LocationID":"MDLK2","Location":"Yellow Creek nr Middlesboro","State":"KY","Date":"/Date(1791763200000-0000)/","PrecipIncremental_IN":0.01,"Hours":24}MDLK2Yellow Creek nr MiddlesboroKY/Date(1791763200000-0000)/0.01242026-10-13 22:01:30.445133
MDLK22026-10-13 22:01:30.429543https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/MDLK2/Day{"LocationID":"MDLK2","Location":"Yellow Creek nr Middlesboro","State":"KY","Date":"/Date(1791676800000-0000)/","PrecipIncremental_IN":0.14,"Hours":24}MDLK2Yellow Creek nr MiddlesboroKY/Date(1791676800000-0000)/0.14242026-10-13 22:01:30.445133
EMGT12026-10-13 22:01:29.424203https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/EMGT1/Day{"LocationID":"EMGT1","Location":"Yellow Creek at Ellis Mills","State":"TN","Date":"/Date(1791763200000-0000)/","PrecipIncremental_IN":0,"Hours":24}EMGT1Yellow Creek at Ellis MillsTN/Date(1791763200000-0000)/0242026-10-13 22:01:29.439278
EMGT12026-10-13 22:01:29.424203https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/EMGT1/Day{"LocationID":"EMGT1","Location":"Yellow Creek at Ellis Mills","State":"TN","Date":"/Date(1791676800000-0000)/","PrecipIncremental_IN":0.03,"Hours":24}EMGT1Yellow Creek at Ellis MillsTN/Date(1791676800000-0000)/0.03242026-10-13 22:01:29.439278
EMGT12026-10-13 22:01:29.424203https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/EMGT1/Day{"LocationID":"EMGT1","Location":"Yellow Creek at Ellis Mills","State":"TN","Date":"/Date(1791590400000-0000)/","PrecipIncremental_IN":0.46,"Hours":24}EMGT1Yellow Creek at Ellis MillsTN/Date(1791590400000-0000)/0.46242026-10-13 22:01:29.439278
EMGT12026-10-13 22:01:29.424203https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/EMGT1/Day{"LocationID":"EMGT1","Location":"Yellow Creek at Ellis Mills","State":"TN","Date":"/Date(1791504000000-0000)/","PrecipIncremental_IN":0,"Hours":24}EMGT1Yellow Creek at Ellis MillsTN/Date(1791504000000-0000)/0242026-10-13 22:01:29.439278
EMGT12026-10-13 22:01:29.424203https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/EMGT1/Day{"LocationID":"EMGT1","Location":"Yellow Creek at Ellis Mills","State":"TN","Date":"/Date(1791417600000-0000)/","PrecipIncremental_IN":0,"Hours":24}EMGT1Yellow Creek at Ellis MillsTN/Date(1791417600000-0000)/0242026-10-13 22:01:29.439278
EMGT12026-10-13 22:01:29.424203https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/EMGT1/Day{"LocationID":"EMGT1","Location":"Yellow Creek at Ellis Mills","State":"TN","Date":"/Date(1791331200000-0000)/","PrecipIncremental_IN":0,"Hours":24}EMGT1Yellow Creek at Ellis MillsTN/Date(1791331200000-0000)/0242026-10-13 22:01:29.439278
EMGT12026-10-13 22:01:29.424203https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/EMGT1/Day{"LocationID":"EMGT1","Location":"Yellow Creek at Ellis Mills","State":"TN","Date":"/Date(1791849600000-0000)/","PrecipIncremental_IN":0,"Hours":16}EMGT1Yellow Creek at Ellis MillsTN/Date(1791849600000-0000)/0162026-10-13 22:01:29.439278
YNCN72026-10-13 22:01:28.336594https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YNCN7/Day{"LocationID":"YNCN7","Location":"Yancey","State":"NC","Date":"/Date(1791849600000-0000)/","PrecipIncremental_IN":0,"Hours":17}YNCN7YanceyNC/Date(1791849600000-0000)/0172026-10-13 22:01:28.354666
YNCN72026-10-13 22:01:28.336594https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YNCN7/Day{"LocationID":"YNCN7","Location":"Yancey","State":"NC","Date":"/Date(1791590400000-0000)/","PrecipIncremental_IN":1.09,"Hours":24}YNCN7YanceyNC/Date(1791590400000-0000)/1.09242026-10-13 22:01:28.354666
YNCN72026-10-13 22:01:28.336594https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YNCN7/Day{"LocationID":"YNCN7","Location":"Yancey","State":"NC","Date":"/Date(1791331200000-0000)/","PrecipIncremental_IN":0,"Hours":24}YNCN7YanceyNC/Date(1791331200000-0000)/0242026-10-13 22:01:28.354666
YNCN72026-10-13 22:01:28.336594https://www.tva.com/RestApi/precipitation-data/2026-10-07/2026-10-14/YNCN7/Day{"LocationID":"YNCN7","Location":"Yancey","State":"NC","Date":"/Date(1791504000000-0000)/","PrecipIncremental_IN":0,"Hours":24}YNCN7YanceyNC/Date(1791504000000-0000)/0242026-10-13 22:01:28.354666

Coverage

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