TABLE

Attributes

Countries

Country_key, Country_Name, Short_Name

States

State_key, Long_Name, Short_Name, Country_key

Cities

City_key, City_Name, Short_Name, State_key

Stations

Station_STN, Station_wban, Station_name, Country, call_st, latitude, longitude, Elevation, BEGIN_date, END_date

Parameters

Parameter_key, Station_STN, Station_wban, Yearmody, Temperature, DEWP, SLP, STP, VISIB, WDSP, MXSPD, GUST, MAX, MIN, PRCP, SNDP, I_FOG, I_RAIN_DZL, I_SNW_ICE, I_HAIL, I_THUNDER, I_TDO_FNL

Daily_Measures_Temperature

Temperature_key, Temperature_CNT, Month, Year, Day1, Day2, Day3, ..., Day31

Daily_Measures_DEWP

DEWP_key, DEWP_CNT, Month, Year, Day1, Day2, Day3, ..., Day31

Daily_Measures_SLP

SLP_key, SLP_CNT, Month, Year, Day1, Day2, Day3, ..., Day31

Daily_Measures_STP

STP_key, STP_CNT, Month, Year, Day1, Day2, Day3, ..., Day31

Daily_Measures_VISIB

VISIB_key, VISIB_CNT, Month, Year, Day1, Day2, Day3, ..., Day31

Daily_Measures_WDSP

WDSP_key, WDSP_CNT, Month, Year, Day1, Day2, Day3, ..., Day31

Daily_Measures_MXSPD

MXSPD_key, Month, Year, Day1, Day2, Day3, ..., Day31

Daily_Measures_GUST

GUST_key, Month, Year, Day1, Day2, Day3, ..., Day31

Daily_Measures_PRCP

PRCP_key, PRCP_FLAG, Month, Year, Day1, Day2, Day3, ..., Day31