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)

Energy Dataset

@kaggle.nicholasjhana_energy_consumption_generation_prices_and_weather.energy_dataset

1.63 MB
35064 rows
29 columns

time Time	generation_biomass Generation Biomass	generation_fossil_brown_coal_lignite Generation Fossil Brown Coal/lignite	generation_fossil_gas Generation Fossil Gas	generation_fossil_hard_coal Generation Fossil Hard Coal	generation_fossil_oil Generation Fossil Oil	generation_hydro_pumped_storage_consumption Generation Hydro Pumped Storage Consumption	generation_hydro_run_of_river_and_poundage Generation Hydro Run-of-river And Poundage	generation_hydro_water_reservoir Generation Hydro Water Reservoir	generation_nuclear Generation Nuclear	generation_other Generation Other	generation_other_renewable Generation Other Renewable	generation_solar Generation Solar	generation_waste Generation Waste	generation_wind_onshore Generation Wind Onshore	forecast_solar_day_ahead Forecast Solar Day Ahead	forecast_wind_onshore_day_ahead Forecast Wind Onshore Day Ahead	total_load_forecast Total Load Forecast	total_load_actual Total Load Actual	price_day_ahead Price Day Ahead	price_actual Price Actual
2015-01-01 00:00:00+01:00	447	329	4844	4821	162	863	1051	1899	7096	43	73	49	196	6378	17	6436	26118	25385	50.1	65.41
2015-01-01 01:00:00+01:00	449	328	5196	4755	158	920	1009	1658	7096	43	71	50	195	5890	16	5856	24934	24382	48.1	64.92
2015-01-01 02:00:00+01:00	448	323	4857	4581	157	1164	973	1371	7099	43	73	50	196	5461	8	5454	23515	22734	47.33	64.48
2015-01-01 03:00:00+01:00	438	254	4314	4131	160	1503	949	779	7098	43	75	50	191	5238	2	5151	22642	21286	42.27	59.32
2015-01-01 04:00:00+01:00	428	187	4130	3840	156	1826	953	720	7097	43	74	42	189	4935	9	4861	21785	20264	38.41	56.04
2015-01-01 05:00:00+01:00	410	178	4038	3590	156	2109	952	743	7098	43	74	34	188	4618	4	4617	21441	19905	35.72	53.63
2015-01-01 06:00:00+01:00	401	172	4040	3368	158	2108	961	848	7098	43	74	34	186	4397	3	4276	21285	20010	35.13	51.73
2015-01-01 07:00:00+01:00	408	172	4030	3208	160	2031	983	1012	7099	43	72	35	189	3992	12	3994	21545	20377	36.22	51.43
2015-01-01 08:00:00+01:00	413	177	4052	3335	161	2119	1001	1015	7098	43	73	54	198	3629	39	3602	21443	20094	32.4	48.98
2015-01-01 09:00:00+01:00	419	177	4137	3437	163	2170	1041	1357	7097	43	74	743	198	3073	784	3212	21560	20637	36.6	54.2


CREATE TABLE energy_dataset (
  "time" VARCHAR,
  "generation_biomass" DOUBLE,
  "generation_fossil_brown_coal_lignite" DOUBLE,
  "generation_fossil_coal_derived_gas" DOUBLE,
  "generation_fossil_gas" DOUBLE,
  "generation_fossil_hard_coal" DOUBLE,
  "generation_fossil_oil" DOUBLE,
  "generation_fossil_oil_shale" DOUBLE,
  "generation_fossil_peat" DOUBLE,
  "generation_geothermal" DOUBLE,
  "generation_hydro_pumped_storage_aggregated" VARCHAR,
  "generation_hydro_pumped_storage_consumption" DOUBLE,
  "generation_hydro_run_of_river_and_poundage" DOUBLE,
  "generation_hydro_water_reservoir" DOUBLE,
  "generation_marine" DOUBLE,
  "generation_nuclear" DOUBLE,
  "generation_other" DOUBLE,
  "generation_other_renewable" DOUBLE,
  "generation_solar" DOUBLE,
  "generation_waste" DOUBLE,
  "generation_wind_offshore" DOUBLE,
  "generation_wind_onshore" DOUBLE,
  "forecast_solar_day_ahead" DOUBLE,
  "forecast_wind_offshore_eday_ahead" VARCHAR,
  "forecast_wind_onshore_day_ahead" DOUBLE,
  "total_load_forecast" DOUBLE,
  "total_load_actual" DOUBLE,
  "price_day_ahead" DOUBLE,
  "price_actual" DOUBLE
);