Hourly Energy Demand Generation And Weather

Electrical demand, generation by type, prices and weather in Spain

@kaggle.nicholasjhana_energy_consumption_generation_prices_and_weather

Table List

2 tables(4.07 MB)

Weather Features

@kaggle.nicholasjhana_energy_consumption_generation_prices_and_weather.weather_features

2.44 MB
178396 rows
17 columns

dt_iso Dt Iso	city_name City Name	temp Temp	temp_min Temp Min	temp_max Temp Max	pressure Pressure	humidity Humidity	wind_speed Wind Speed	wind_deg Wind Deg	weather_id Weather Id	weather_main Weather Main	weather_description Weather Description	weather_icon Weather Icon
2015-01-01 00:00:00+01:00	Valencia	270.475	270.475	270.475	1001	77	1	62	800	clear	sky is clear	01n
2015-01-01 01:00:00+01:00	Valencia	270.475	270.475	270.475	1001	77	1	62	800	clear	sky is clear	01n
2015-01-01 02:00:00+01:00	Valencia	269.686	269.686	269.686	1002	78		23	800	clear	sky is clear	01n
2015-01-01 03:00:00+01:00	Valencia	269.686	269.686	269.686	1002	78		23	800	clear	sky is clear	01n
2015-01-01 04:00:00+01:00	Valencia	269.686	269.686	269.686	1002	78		23	800	clear	sky is clear	01n
2015-01-01 05:00:00+01:00	Valencia	270.29200000000003	270.29200000000003	270.29200000000003	1004	71	2	321	800	clear	sky is clear	01n
2015-01-01 06:00:00+01:00	Valencia	270.29200000000003	270.29200000000003	270.29200000000003	1004	71	2	321	800	clear	sky is clear	01n
2015-01-01 07:00:00+01:00	Valencia	270.29200000000003	270.29200000000003	270.29200000000003	1004	71	2	321	800	clear	sky is clear	01n
2015-01-01 08:00:00+01:00	Valencia	274.601	274.601	274.601	1005	71	1	307	800	clear	sky is clear	01d
2015-01-01 09:00:00+01:00	Valencia	274.601	274.601	274.601	1005	71	1	307	800	clear	sky is clear	01d


CREATE TABLE weather_features (
  "dt_iso" VARCHAR,
  "city_name" VARCHAR,
  "temp" DOUBLE,
  "temp_min" DOUBLE,
  "temp_max" DOUBLE,
  "pressure" BIGINT,
  "humidity" BIGINT,
  "wind_speed" BIGINT,
  "wind_deg" BIGINT,
  "rain_1h" DOUBLE,
  "rain_3h" DOUBLE,
  "snow_3h" DOUBLE,
  "clouds_all" BIGINT,
  "weather_id" BIGINT,
  "weather_main" VARCHAR,
  "weather_description" VARCHAR,
  "weather_icon" VARCHAR
);