Data Dictionary
National Weather Service (NWS) Weather Alert EventsView Source Documentation
PUBLIC_DATA.NWS_WEATHER_ALERT_EVENTS: Weather warnings, watches, and advisories issued by the National Weather Service and their associated characteristics.
National Weather Service (NWS) Weather Alert Events Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.NWS_WEATHER_ALERT_EVENTS_PIT: Tracks history of the nws_weather_alert_events table with start and end timestamps to indicate row validity periods.
National Weather Service (NWS) Weather Alert RelationshipsView Source Documentation
PUBLIC_DATA.NWS_WEATHER_ALERT_RELATIONSHIPS: Provides a relational view of NWS alerts to provide context and connection between similar or connected weather events.
National Weather Service (NWS) Weather Alert Relationships Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.NWS_WEATHER_ALERT_RELATIONSHIPS_PIT: Tracks history of the nws_weather_alert_relationships table with start and end timestamps to indicate row validity periods.
National Weather Service (NWS) Weather Observation AttributesView Source Documentation
PUBLIC_DATA.NWS_WEATHER_ATTRIBUTES: Weather observation variables (e.g., precipitation, temperature, wind speed) tracked by NWS stations.
National Weather Service (NWS) Weather Observation Attributes Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.NWS_WEATHER_ATTRIBUTES_PIT: Tracks history of the nws_weather_attributes table with start and end timestamps to indicate row validity periods.
National Weather Service (NWS) Weather Forecast EventsView Source Documentation
PUBLIC_DATA.NWS_WEATHER_FORECAST_EVENTS: Daily and hourly weather forecasts for counties and zip codes.
National Weather Service (NWS) Weather Forecast Events Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.NWS_WEATHER_FORECAST_EVENTS_PIT: Tracks history of the nws_weather_forecast_events table with start and end timestamps to indicate row validity periods.
National Weather Service (NWS) Weather Station IndexView Source Documentation
PUBLIC_DATA.NWS_WEATHER_STATION_INDEX: Index of weather stations operated by the National Weather Service with specified characteristics and identifiers.
National Weather Service (NWS) Weather Station Index Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.NWS_WEATHER_STATION_INDEX_PIT: Tracks history of the nws_weather_station_index table with start and end timestamps to indicate row validity periods.
National Weather Service (NWS) Weather Observation TimeseriesView Source Documentation
PUBLIC_DATA.NWS_WEATHER_TIMESERIES: NWS weather station observation timestamped data.
NWS observation data is the collection of real-time weather and environmental measurements captured by a network of weather stations operated by the National Weather Service (NWS). The observations are made by both automated systems, like the Automated Surface Observing Systems (ASOS), and manual reports from specific locations.
National Weather Service (NWS) Weather Observation Timeseries Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.NWS_WEATHER_TIMESERIES_PIT: Tracks history of the nws_weather_timeseries table with start and end timestamps to indicate row validity periods.
National Weather Service (NWS) Weather Zone IndexView Source Documentation
PUBLIC_DATA.NWS_WEATHER_ZONE_INDEX: Index of NWS geographic regions, known as zones, used for weather alerts and forecasts.
National Weather Service (NWS) Weather Zone Index Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.NWS_WEATHER_ZONE_INDEX_PIT: Tracks history of the nws_weather_zone_index table with start and end timestamps to indicate row validity periods.