Irish Weather (hourly Data)

Weather data taken at hourly intervals from Irish weather stations (1989-2018)

@kaggle.conorrot_irish_weather_hourly_data

Table List

1 table(78.15 MB)

Hrly Irish Weather

@kaggle.conorrot_irish_weather_hourly_data.hrly_irish_weather

78.15 MB
4660423 rows
18 columns

county County	station Station	latitude Latitude	longitude Longitude	date Date	temp Temp	wetb Wetb	dewpt Dewpt	vappr Vappr	rhum Rhum	msl Msl	wdsp Wdsp	wddir Wddir	sun Sun	vis Vis	clht Clht	clamt Clamt
Galway	ATHENRY	53.289	-8.786	Sun Jun 26 2011 01:00:00 GMT+0000 (Coordinated Universal Time)	15.3	14.5	13.9	15.8	90	1016.0	8	190	nan	nan	nan	nan
Galway	ATHENRY	53.289	-8.786	Sun Jun 26 2011 02:00:00 GMT+0000 (Coordinated Universal Time)	14.7	13.7	12.9	14.9	89	1015.8	7	190	nan	nan	nan	nan
Galway	ATHENRY	53.289	-8.786	Sun Jun 26 2011 03:00:00 GMT+0000 (Coordinated Universal Time)	14.3	13.4	12.6	14.6	89	1015.5	6	190	nan	nan	nan	nan
Galway	ATHENRY	53.289	-8.786	Sun Jun 26 2011 04:00:00 GMT+0000 (Coordinated Universal Time)	14.4	13.6	12.8	14.8	90	1015.3	7	180	nan	nan	nan	nan
Galway	ATHENRY	53.289	-8.786	Sun Jun 26 2011 05:00:00 GMT+0000 (Coordinated Universal Time)	14.4	13.5	12.7	14.7	89	1015.1	6	190	nan	nan	nan	nan
Galway	ATHENRY	53.289	-8.786	Sun Jun 26 2011 06:00:00 GMT+0000 (Coordinated Universal Time)	14.9	13.8	13.0	15.0	88	1015.0	8	180	nan	nan	nan	nan
Galway	ATHENRY	53.289	-8.786	Sun Jun 26 2011 07:00:00 GMT+0000 (Coordinated Universal Time)	15.1	13.5	12.2	14.2	83	1014.9	8	180	nan	nan	nan	nan
Galway	ATHENRY	53.289	-8.786	Sun Jun 26 2011 08:00:00 GMT+0000 (Coordinated Universal Time)	15.2	13.0	11.1	13.2	76	1014.7	7	170	nan	nan	nan	nan
Galway	ATHENRY	53.289	-8.786	Sun Jun 26 2011 09:00:00 GMT+0000 (Coordinated Universal Time)	16.1	13.2	10.8	12.9	70	1014.4	7	160	nan	nan	nan	nan
Galway	ATHENRY	53.289	-8.786	Sun Jun 26 2011 10:00:00 GMT+0000 (Coordinated Universal Time)	16.8	13.3	10.3	12.5	65	1014.1	10	180	nan	nan	nan	nan


CREATE TABLE hrly_irish_weather (
  "county" VARCHAR,
  "station" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date" TIMESTAMP,
  "rain" VARCHAR,
  "temp" VARCHAR,
  "wetb" VARCHAR,
  "dewpt" VARCHAR,
  "vappr" VARCHAR,
  "rhum" VARCHAR,
  "msl" VARCHAR,
  "wdsp" VARCHAR,
  "wddir" VARCHAR,
  "sun" VARCHAR,
  "vis" VARCHAR,
  "clht" VARCHAR,
  "clamt" VARCHAR
);