Wunderground PWS Curitiba 2021

Weather data from Wunderground Personal Weather Stations near Curitiba, Brazil

@kaggle.lucashohmann_wunderground_pws_curitiba_2021

Table List

2 tables(2.07 MB)

Wunderground Pws

@kaggle.lucashohmann_wunderground_pws_curitiba_2021.wunderground_pws

2.06 MB
94386 rows
16 columns

station_id Station Id	last_updated Last Updated	timestamp Timestamp	temp Temp	temp_feel Temp Feel	dew_point Dew Point	humidity Humidity	pressure Pressure	wind_speed Wind Speed	wind_gust Wind Gust	wind_direction Wind Direction	wind_bearing Wind Bearing	precip_total Precip Total	uv_index Uv Index	radiation Radiation
ICURIT32	8	1624249206362583494	11.7	11.7	10.6	93	1016.48	1.8	1.8	NE	46
ICURITIB28	18	1625234754894877196	15.9	15.9	10	68	1016.82	1.8	1.8	ENE	60		4	454.6
ICURIT21	60	1624315805406686951	11.5	11.5	11.2	98	1022.57	2.6	3.5	NW	315	6.1
ICURIT46	31	1625730610386346896	9.4	9.4	7.4	87				NW	326
ISOJOS29	60	1624532406198147752	11.8	11.8	11.8	100	917.61			NE	45
ICURITIB24	19	1624838711448911583	16	16	14.2	89	1017.15			SSE	167
IBALSA3	5	1625346973004112731	14.9	14.9	7.3	62	902.37	5	6.6	S	180
ICURITIB15	18	1624548305410647474	19.2	19.2	15.3	78	910.16	6.4	9.6	SE	135
ICURITIB29	4	1624511125567767538	11.7	11.7	10.8	94		11	12.2	N	9
IBALSA1	6	1625523327136153990	10.6	10.6	10.6	99	1015.12			NW	315


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