Weather
All weather tables have the same data.
The column names, explanations, units, datatypes, and data examples are below.
| Column name | Description | Unit of Measure | Data Type |
|---|---|---|---|
| ls_id | unique identifier | n/a | integer |
| date | date | yyyy-mm-dd | date |
| time | time | hh:mm | time without time zone |
| lattitude | latidue | numeric | |
| longitude | longitude | numeric | |
| timezone | timezone | text | |
| tz_offset | timzone offset from GMT | integer | |
| days_datetime | timestamp without time zone | ||
| days_datetime_epoch | integer | ||
| days_tempmax | Daily max temp | fahrenheit | numeric |
| days_tempmin | Daily min temp | fahrenheit | numeric |
| days_temp | temp (or mean temp) | fahrenheit | numeric |
| days_feelslikemax | Daily Feels like max temp | fahrenheit | numeric |
| days_feelslikemin | Daily Feels like min temp | fahrenheit | numeric |
| days_feelslike | Daily Feels like | fahrenheit | numeric |
| days_dew | Daily Dew Point | fahrenheit | numeric |
| days_humidity | Daily Relative Humidity | % - percentage | numeric |
| days_precip | Daily Precipitation | inches | numeric |
| days_precipprob | Daily Precipitation chance | % - percentage | integer |
| days_precipcover | Daily | numeric | |
| days_preciptype | Daily Precipitation type | n/a | text |
| days_snow | Daily Snow | inches | numeric |
| days_snowdepth | Daily Snow Depth | inches | numeric |
| days_windgust | Daily Wind Gust | miles per hour | numeric |
| days_windspeed | Daily Wind Speed | miles per hour | numeric |
| days_winddir | Daily Wind Direction | degrees | numeric |
| days_pressure | Daily Sea Level Pressure | mb - millibars | numeric |
| days_cloudcover | Daily Cloud Cover | % - percentage | numeric |
| days_visibility | Daily Visibility | miles per hour | numeric |
| days_solarradiation | Daily Solar Radiation | W/m2 - watt per square metre | numeric |
| days_solarenergy | Daily Solar Energy | MJ/m2 - Megajoules per square meter | numeric |
| days_uvindex | Daily UV Index | int | integer |
| days_conditions | Daily Short text about the weather | text | text |
| days_icon | Daily A weather icon | text | text |
| days_sunrise_epoch | Daily Sunrise time | unix time | integer |
| days_sunset_epoch | Daily Sunset time | unix time | integer |
| days_moonphase | Daily Moonphase | int | numeric |
| weatherapi_time | text | ||
| datetime_epoch | integer | ||
| cloudcover | Cloud Cover | % - percentage | numeric |
| conditions | Short text about the weather | text | text |
| dew | Dew Point | fahrenheit | numeric |
| feelslike | Feels like | fahrenheit | numeric |
| humidity | Relative Humidity | % - percentage | numeric |
| icon | A weather icon | text | text |
| moonphase | Moonphase | integer | numeric |
| precip | Precipitation | mm - millimeter | numeric |
| preciptype | Precipitation type | text | text |
| precipprob | Precipitation chance | % - percentage | integer |
| pressure | Sea Level Pressure | mb - millibars | numeric |
| snow | Snow | inches | numeric |
| snowdepth | Snow Depth | inches | numeric |
| solarenergy | Solar Energy | MJ/m2 - Megajoules per square meter | numeric |
| solarradiation | Solar Radiation | W/m2 - watt per square metre | numeric |
| sunrise | Sunrise time in 24 hour clock | time | time without time zone |
| sunrise_epoch | Sunrise time | unix time | integer |
| sunset | Sunset time in 24 hour clock | time | time without time zone |
| sunset_epoch | Sunset time | unix time | integer |
| uvindex | UV Index | integer | integer |
| visibility | Visibility | fahrenheit | numeric |
| winddir | Wind Direction | degrees | numeric |
| windgust | Wind Gust | miles per hour | numeric |
| windspeed | Wind Speed | miles per hour | numeric |
| temp | temp (or mean temp) | fahrenheit | numeric |