NOAA Weather Metrics Timeseries

Snowflake table name : CYBERSYN.NOAA_WEATHER_METRICS_TIMESERIES

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
NOAA_WEATHER_STATION_ID	Unique identifier for land surface weather stations in the Global Historical Climatology Network daily (GHCNd), comprised of the FIPS country code (first 2 characters), a network code (third character), and the actual station ID (the remaining 8 characters).	VARCHAR	USC00087228
VARIABLE	A unique identifier for a variable joinable to the timeseries table.	VARCHAR	precipitation
VARIABLE_NAME	Human-readable name for the variable.	VARCHAR	Precipitation
DATE	Date associated with the value	DATE	2007-07-03
DATETIME	Datetime associated with the value	TIMESTAMP_NTZ	2003-03-05 00:00:00
VALUE	Value reported for the variable	NUMBER	0.000000
UNIT	Unit of measurement for the reported value.	VARCHAR	Millimeters