Dataset: Weather Data

About this Dataset

Weather Data

Live weather data captured from microsoft start news using scrapping techniques such as beautiful soup and selenium and loaded to google sheets, excel and also stored as json and also an api. Columns include city, temperature, state, humidity, dew point clothing pattern, driving safety etc.

Tables

Weather

@kaggle.bishop36_weather_data.weather

43.21 KB
227 rows
48 columns


CREATE TABLE weather (
  "time" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "temperaturec" BIGINT,
  "temperaturef" DOUBLE,
  "temperaturek" BIGINT,
  "day_date" VARCHAR,
  "max_temp" BIGINT,
  "min_temp" BIGINT,
  "air_quality" BIGINT,
  "wind" BIGINT,
  "humidity" DOUBLE,
  "visibility" DOUBLE,
  "pressure" BIGINT,
  "dew_point" BIGINT,
  "uv_index" BIGINT,
  "status" VARCHAR,
  "moon_phase" VARCHAR,
  "sunrise" VARCHAR,
  "sunset" VARCHAR,
  "moonrise" VARCHAR,
  "moonset" VARCHAR,
  "sunny" BIGINT,
  "rainsnow" BIGINT,
  "rainday" BIGINT,
  "avgrainday" DOUBLE,
  "avgsnowday" DOUBLE,
  "umbrella" VARCHAR,
  "outdoors" VARCHAR,
  "driving" VARCHAR,
  "clothing" VARCHAR,
  "heat_stroke" VARCHAR,
  "wind_chill" VARCHAR,
  "date_taken" VARCHAR,
  "weekday" VARCHAR,
  "umbrella_needed" VARCHAR,
  "outdoors_needed" VARCHAR,
  "driving_needed" VARCHAR,
  "clothing_needed" VARCHAR,
  "heat_stroke_needed" VARCHAR,
  "wind_chill_needed" VARCHAR,
  "umbrella_rank" BIGINT,
  "outdoors_rank" BIGINT,
  "driving_needed_rank" BIGINT,
  "clothing_rank" VARCHAR,
  "heat_stroke_rank" VARCHAR,
  "wind_chill_rank" VARCHAR,
  "date" TIMESTAMP
);