Baselight

Austin Weather

Historical temperature, precipitation, humidity, and windspeed for Austin, Texas

@kaggle.grubenm_austin_weather

Loading...
Loading...

About this Dataset

Austin Weather

Context

This dataset is meant to complement the Austin Bikesharing Dataset.

Content

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.

Acknowledgements

This dataset was obtained from WeatherUnderground.com, at the Austin KATT station.

Inspiration

Can we use this dataset to explain some of the variation in the Austin Bikesharing Dataset?

Tables

Austin Weather

@kaggle.grubenm_austin_weather.austin_weather
  • 48.15 KB
  • 1319 rows
  • 21 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.