Austin Weather
Historical temperature, precipitation, humidity, and windspeed for Austin, Texas
@kaggle.grubenm_austin_weather
Historical temperature, precipitation, humidity, and windspeed for Austin, Texas
@kaggle.grubenm_austin_weather
This dataset is meant to complement the Austin Bikesharing Dataset.
Contains the:
Date (YYYY-MM-DD)
TempHighF (High temperature, in Fahrenheit)
TempAvgF (Average temperature, in Fahrenheit)
TempLowF (Low temperature, in Fahrenheit)
DewPointHighF (High dew point, in Fahrenheit)
DewPointAvgF (Average dew point, in Fahrenheit)
DewPointLowF (Low dew point, in Fahrenheit)
HumidityHighPercent (High humidity, as a percentage)
HumidityAvgPercent (Average humidity, as a percentage)
HumidityLowPercent (Low humidity, as a percentage)
SeaLevelPressureHighInches (High sea level pressure, in inches)
SeaLevelPressureAvgInches (Average sea level pressure, in inches)
SeaLevelPressureLowInches (Low sea level pressure, in inches)
VisibilityHighMiles (High visibility, in miles)
VisibilityAvgMiles (Average visibility, in miles)
VisibilityLowMiles (Low visibility, in miles)
WindHighMPH (High wind speed, in miles per hour)
WindAvgMPH (Average wind speed, in miles per hour)
WindGustMPH (Highest wind speed gust, in miles per hour)
PrecipitationSumInches (Total precipitation, in inches) ('T' if Trace)
Events (Adverse weather events. ' ' if None)
This dataset contains data for every date from 2013-12-21 to 2017-07-31.
This dataset was obtained from WeatherUnderground.com, at the Austin KATT station.
Can we use this dataset to explain some of the variation in the Austin Bikesharing Dataset?
CREATE TABLE austin_weather (
"date" TIMESTAMP,
"temphighf" BIGINT,
"tempavgf" BIGINT,
"templowf" BIGINT,
"dewpointhighf" VARCHAR,
"dewpointavgf" VARCHAR,
"dewpointlowf" VARCHAR,
"humidityhighpercent" VARCHAR,
"humidityavgpercent" VARCHAR,
"humiditylowpercent" VARCHAR,
"sealevelpressurehighinches" VARCHAR,
"sealevelpressureavginches" VARCHAR,
"sealevelpressurelowinches" VARCHAR,
"visibilityhighmiles" VARCHAR,
"visibilityavgmiles" VARCHAR,
"visibilitylowmiles" VARCHAR,
"windhighmph" VARCHAR,
"windavgmph" VARCHAR,
"windgustmph" VARCHAR,
"precipitationsuminches" VARCHAR,
"events" VARCHAR
);Anyone who has the link will be able to view this.