Dataset: Wunderground PWS Curitiba 2021

About this Dataset

Wunderground PWS Curitiba 2021

This is a dataset of weather data scraped from Wunderground Website over a period of about 18 days of 19 Personal Weather Stations near the city of Curitiba, Brazil.

The data is scraped at 5 minutes intervals using an F1 Micro Free Tier Google Cloud VM Instance (Github Scraper Code) and stores it on an AWS Dynamo database. This scraper also scrapes Google Weather Forecast data ( weather.com).

The idea is to later compare Google's forecast predictions to the actual data read by the Weather Stations.

Tables

Stations

@kaggle.lucashohmann_wunderground_pws_curitiba_2021.stations

16.27 KB
19 rows
24 columns


CREATE TABLE stations (
  "unnamed_0" BIGINT,
  "station_id" VARCHAR,
  "name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "altitude" BIGINT,
  "country" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR,
  "hardware" VARCHAR,
  "software" VARCHAR,
  "par_temp" BOOLEAN,
  "par_temp_feel" BOOLEAN,
  "par_dew_point" BOOLEAN,
  "par_humidity" BOOLEAN,
  "par_pressure" BOOLEAN,
  "par_wind_speed" BOOLEAN,
  "par_wind_gust" BOOLEAN,
  "par_wind_bearing" BOOLEAN,
  "par_wind_direction" BOOLEAN,
  "par_precip_rate" BOOLEAN,
  "par_precip_total" BOOLEAN,
  "par_uv_index" BOOLEAN,
  "par_radiation" BOOLEAN
);

Wunderground Pws

@kaggle.lucashohmann_wunderground_pws_curitiba_2021.wunderground_pws

2.06 MB
94386 rows
16 columns


CREATE TABLE wunderground_pws (
  "station_id" VARCHAR,
  "last_updated" BIGINT,
  "timestamp" BIGINT,
  "temp" DOUBLE,
  "temp_feel" DOUBLE,
  "dew_point" DOUBLE,
  "humidity" BIGINT,
  "pressure" DOUBLE,
  "wind_speed" DOUBLE,
  "wind_gust" DOUBLE,
  "wind_direction" VARCHAR,
  "wind_bearing" BIGINT,
  "precip_rate" DOUBLE,
  "precip_total" DOUBLE,
  "uv_index" DOUBLE,
  "radiation" DOUBLE
);