Skip to main content

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 CoverageGlobal
Entity LevelWeather Station, Country
Time GranularityDaily
Release FrequencyDaily
HistorySince 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:

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 support@cybersyn.com for questions.