TVA logo

TVA Precipitation Gauge Registry

The 244 gauge identifiers, names and states available from TVA daily precipitation queries.

Native record
publication snapshot x requested location x source_location_id
6-hour collection publication cadence
Evidence
Reference data
Stable context used to interpret other datasets
Time basis
Point-in-time records
UTC · snapshot_time

Overview

No coordinates are supplied by this endpoint.

Query contract

Preserve one canonical row per (location_id, snapshot_time, source_location_id) 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
source_location_idString
locationNullable(String)
stateNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample data

location_idsnapshot_timesource_urlsource_recordsource_location_idlocationstateingested_at
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"MPYN7","Location":"Murphy","State":"NC"}MPYN7MurphyNC2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"MRNV2","Location":"Marion","State":"VA"}MRNV2MarionVA2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"MRST1","Location":"Morrison","State":"TN"}MRST1MorrisonTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"MSTT1","Location":"Morristown","State":"TN"}MSTT1MorristownTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"MTCK2","Location":"Beaver Creek nr Monticello","State":"KY"}MTCK2Beaver Creek nr MonticelloKY2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"MUGT1","Location":"West Fork Stones at Murfreesboro","State":"TN"}MUGT1West Fork Stones at MurfreesboroTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"PORT1","Location":"Red at Port Royal","State":"TN"}PORT1Red at Port RoyalTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"NDMN7","Location":"Needmore Rain","State":"NC"}NDMN7Needmore RainNC2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"NEWT1","Location":"Newcomb","State":"TN"}NEWT1NewcombTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"NFGT1","Location":"Newfound Gap","State":"TN"}NFGT1Newfound GapTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"NKJT1","Location":"Nickajack Dam","State":"TN"}NKJT1Nickajack DamTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"NOLT1","Location":"Nolichucky Dam","State":"TN"}NOLT1Nolichucky DamTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"NOTG1","Location":"Nottely Dam","State":"GA"}NOTG1Nottely DamGA2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"NPRT1","Location":"Newport","State":"TN"}NPRT1NewportTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"NRMT1","Location":"Normandy Dam","State":"TN"}NRMT1Normandy DamTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"NRST1","Location":"Norris Dam","State":"TN"}NRST1Norris DamTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"NBLV2","Location":"North Bristol","State":"VA"}NBLV2North BristolVA2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"OHHT1","Location":"Old Hickory Dam","State":"TN"}OHHT1Old Hickory DamTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"PLYG1","Location":"Presley","State":"GA"}PLYG1PresleyGA2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"PLMN7","Location":"Plumtree","State":"NC"}PLMN7PlumtreeNC2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"PKVT1","Location":"Pikeville","State":"TN"}PKVT1PikevilleTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"PKST1","Location":"Parksville","State":"TN"}PKST1ParksvilleTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"PICT1","Location":"Pickwick Dam","State":"TN"}PICT1Pickwick DamTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"OKGT1","Location":"Oak Grove","State":"TN"}OKGT1Oak GroveTN2026-10-13 21:57:38.693167
2026-10-13 21:57:38.557410https://www.tva.com/RestApi/precipitation-data-location/{"LocationID":"PENT1","Location":"Cumberland at Penitentiary Branch","State":"TN"}PENT1Cumberland at Penitentiary BranchTN2026-10-13 21:57:38.693167

Coverage

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