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:
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.