NOAA Weather Metrics Timeseries

Snowflake table name : CYBERSYN.NOAA_WEATHER_METRICS_TIMESERIES

View data source documentation 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	USW00094017
VARIABLE	A unique identifier for a variable joinable to the timeseries table.	VARCHAR	precipitation
VARIABLE_NAME	Human-readable name for the variable.	VARCHAR	Snowfall
DATE	Date associated with the value	DATE	2014-12-18
DATETIME	Datetime associated with the value	TIMESTAMP_NTZ	2013-05-21 00:00:00
VALUE	Value reported for the variable	NUMBER	0.000000
UNIT	Unit of measurement for the reported value.	VARCHAR	Degrees Celsius