NOAA NCEI

Overview

NOAA's National Centers for Environmental Information (NCEI) publishes daily weather events from over 100,000 stations across 180 countries in the Global Historical Climatology Network daily (GHCNd) database.

Example topics covered:

• Temperature
• Precipitation
• Snow depth
• Snowfall
• Average wind speed
• Humidity
• Total sunshine
• Average cloudiness
• Weather station metadata (e.g. location, name, id)

Key Attributes

Geographic Coverage	Global
Entity Level	Weather Station, Country
Time Granularity	Daily
Release Frequency	Daily
History	Since January 1, 2000

Description

Weather Station Data Variance: Roughly half of weather stations only report precipitation. Both record length and period of record vary by station. Data lag time varies depending on the station NOAA pulls data from but it is most frequently one to two days.

NOAA Data Quality Checks: Any recorded weather observation that does not pass NOAA’s data quality checks is filtered out.

Cybersyn Products

Tables above are available in the following Cybersyn data products:

• Weather & Environment
• Cybersyn Foundations - PAID

Sample Queries

Daily precipitation trends in a particular region

Timeseries of average precipitation levels in a specific state.

SELECT
    ts.date,
    AVG(ts.value) AS avg_value
FROM cybersyn.noaa_weather_metrics_timeseries AS ts
JOIN cybersyn.noaa_weather_station_index AS idx
    ON (ts.noaa_weather_station_id = idx.noaa_weather_station_id)
WHERE
    idx.state_name = 'Florida'
    AND ts.variable = 'precipitation'
    AND ts.date >= DATEADD(DAY, -365, CURRENT_DATE())
GROUP BY ts.date;

Prevalence of severe weather in a particular region

Determine how many tornados, waterspouts, or funnel clouds were recorded in Florida each year since 2010.

SELECT
    YEAR(ts.date) AS year,
    COUNT(DISTINCT ts.date) AS count_severe_weather_days
FROM cybersyn.noaa_weather_metrics_timeseries AS ts
JOIN cybersyn.noaa_weather_station_index AS idx
    ON (ts.noaa_weather_station_id = idx.noaa_weather_station_id)
WHERE 
    ts.variable_name = 'Weather Type: Tornado, Waterspout, or Funnel Cloud'
    AND idx.state_name = 'Florida'
    AND ts.value = 1
    AND ts.date >= '2010-01-01'
GROUP BY year
ORDER BY year;

Disclaimers

The data in this product is sourced from National Oceanic and Atmospheric Administration (NOAA).

Cybersyn is not endorsed by or affiliated with any of these providers. Contact snowflake-public-data@snowflake.com for questions.