NOAA NCEI

National Oceanic and Atmospheric Administration's National Centers for Environmental Information

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

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Description

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. All timeseries' dates and values that refer to the entity are included in a timeseries table. Descriptors of the timeseries are included in an attributes table. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

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.

Tables & Sources

Tables	Sources
NOAA_WEATHER_METRICS_ATTRIBUTES NOAA_WEATHER_METRICS_TIMESERIES NOAA_WEATHER_STATION_INDEX	NOAA NCEI

Cybersyn Products

Tables above are available in the following Cybersyn data products:

• Weather & Environment

• Enterprise

Examples & 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 [e-mail] for questions.