Wind Power Generation Data
Wind Energy Dataset from Four German Power Companies
@kaggle.jorgesandoval_wind_power_generation
Wind Energy Dataset from Four German Power Companies
@kaggle.jorgesandoval_wind_power_generation
Information about the four German Transmission System Operators (TSOs) jointly publish as well as general information about the transmission system.
Wind power generation from four German energy companies (50 Hertz, Amprion, TenneT TSO and TransnetBW). It contains power generation data (non-normalized) with an interval of 15 minutes, totalizing 96 points a day.
Generation in THw between 23/08/2019 to 22/09/2020.
CREATE TABLE amprion (
"date" TIMESTAMP,
"n_00_00_00" BIGINT -- 00:00:00,
"n_00_15_00" BIGINT -- 00:15:00,
"n_00_30_00" BIGINT -- 00:30:00,
"n_00_45_00" BIGINT -- 00:45:00,
"n_01_00_00" BIGINT -- 01:00:00,
"n_01_15_00" BIGINT -- 01:15:00,
"n_01_30_00" BIGINT -- 01:30:00,
"n_01_45_00" BIGINT -- 01:45:00,
"n_02_00_00" BIGINT -- 02:00:00,
"n_02_15_00" BIGINT -- 02:15:00,
"n_02_30_00" BIGINT -- 02:30:00,
"n_02_45_00" BIGINT -- 02:45:00,
"n_03_00_00" BIGINT -- 03:00:00,
"n_03_15_00" BIGINT -- 03:15:00,
"n_03_30_00" BIGINT -- 03:30:00,
"n_03_45_00" BIGINT -- 03:45:00,
"n_04_00_00" BIGINT -- 04:00:00,
"n_04_15_00" BIGINT -- 04:15:00,
"n_04_30_00" BIGINT -- 04:30:00,
"n_04_45_00" BIGINT -- 04:45:00,
"n_05_00_00" BIGINT -- 05:00:00,
"n_05_15_00" BIGINT -- 05:15:00,
"n_05_30_00" BIGINT -- 05:30:00,
"n_05_45_00" BIGINT -- 05:45:00,
"n_06_00_00" BIGINT -- 06:00:00,
"n_06_15_00" BIGINT -- 06:15:00,
"n_06_30_00" BIGINT -- 06:30:00,
"n_06_45_00" BIGINT -- 06:45:00,
"n_07_00_00" BIGINT -- 07:00:00,
"n_07_15_00" BIGINT -- 07:15:00,
"n_07_30_00" BIGINT -- 07:30:00,
"n_07_45_00" BIGINT -- 07:45:00,
"n_08_00_00" BIGINT -- 08:00:00,
"n_08_15_00" BIGINT -- 08:15:00,
"n_08_30_00" BIGINT -- 08:30:00,
"n_08_45_00" BIGINT -- 08:45:00,
"n_09_00_00" BIGINT -- 09:00:00,
"n_09_15_00" BIGINT -- 09:15:00,
"n_09_30_00" BIGINT -- 09:30:00,
"n_09_45_00" BIGINT -- 09:45:00,
"n_10_00_00" BIGINT -- 10:00:00,
"n_10_15_00" BIGINT -- 10:15:00,
"n_10_30_00" BIGINT -- 10:30:00,
"n_10_45_00" BIGINT -- 10:45:00,
"n_11_00_00" BIGINT -- 11:00:00,
"n_11_15_00" BIGINT -- 11:15:00,
"n_11_30_00" BIGINT -- 11:30:00,
"n_11_45_00" BIGINT -- 11:45:00,
"n_12_00_00" BIGINT -- 12:00:00,
"n_12_15_00" BIGINT -- 12:15:00,
"n_12_30_00" BIGINT -- 12:30:00,
"n_12_45_00" BIGINT -- 12:45:00,
"n_13_00_00" BIGINT -- 13:00:00,
"n_13_15_00" BIGINT -- 13:15:00,
"n_13_30_00" BIGINT -- 13:30:00,
"n_13_45_00" BIGINT -- 13:45:00,
"n_14_00_00" BIGINT -- 14:00:00,
"n_14_15_00" BIGINT -- 14:15:00,
"n_14_30_00" BIGINT -- 14:30:00,
"n_14_45_00" BIGINT -- 14:45:00,
"n_15_00_00" BIGINT -- 15:00:00,
"n_15_15_00" BIGINT -- 15:15:00,
"n_15_30_00" BIGINT -- 15:30:00,
"n_15_45_00" BIGINT -- 15:45:00,
"n_16_00_00" BIGINT -- 16:00:00,
"n_16_15_00" BIGINT -- 16:15:00,
"n_16_30_00" BIGINT -- 16:30:00,
"n_16_45_00" BIGINT -- 16:45:00,
"n_17_00_00" BIGINT -- 17:00:00,
"n_17_15_00" BIGINT -- 17:15:00,
"n_17_30_00" BIGINT -- 17:30:00,
"n_17_45_00" BIGINT -- 17:45:00,
"n_18_00_00" BIGINT -- 18:00:00,
"n_18_15_00" BIGINT -- 18:15:00,
"n_18_30_00" BIGINT -- 18:30:00,
"n_18_45_00" BIGINT -- 18:45:00,
"n_19_00_00" BIGINT -- 19:00:00,
"n_19_15_00" BIGINT -- 19:15:00,
"n_19_30_00" BIGINT -- 19:30:00,
"n_19_45_00" BIGINT -- 19:45:00,
"n_20_00_00" BIGINT -- 20:00:00,
"n_20_15_00" BIGINT -- 20:15:00,
"n_20_30_00" BIGINT -- 20:30:00,
"n_20_45_00" BIGINT -- 20:45:00,
"n_21_00_00" BIGINT -- 21:00:00,
"n_21_15_00" BIGINT -- 21:15:00,
"n_21_30_00" BIGINT -- 21:30:00,
"n_21_45_00" BIGINT -- 21:45:00,
"n_22_00_00" BIGINT -- 22:00:00,
"n_22_15_00" BIGINT -- 22:15:00,
"n_22_30_00" BIGINT -- 22:30:00,
"n_22_45_00" BIGINT -- 22:45:00,
"n_23_00_00" BIGINT -- 23:00:00,
"n_23_15_00" BIGINT -- 23:15:00,
"n_23_30_00" BIGINT -- 23:30:00,
"n_23_45_00" BIGINT -- 23:45:00
);CREATE TABLE n_50hertz (
"date" TIMESTAMP,
"n_00_00_00" BIGINT -- 00:00:00,
"n_00_15_00" BIGINT -- 00:15:00,
"n_00_30_00" BIGINT -- 00:30:00,
"n_00_45_00" BIGINT -- 00:45:00,
"n_01_00_00" BIGINT -- 01:00:00,
"n_01_15_00" BIGINT -- 01:15:00,
"n_01_30_00" BIGINT -- 01:30:00,
"n_01_45_00" BIGINT -- 01:45:00,
"n_02_00_00" BIGINT -- 02:00:00,
"n_02_15_00" BIGINT -- 02:15:00,
"n_02_30_00" BIGINT -- 02:30:00,
"n_02_45_00" BIGINT -- 02:45:00,
"n_03_00_00" BIGINT -- 03:00:00,
"n_03_15_00" BIGINT -- 03:15:00,
"n_03_30_00" BIGINT -- 03:30:00,
"n_03_45_00" BIGINT -- 03:45:00,
"n_04_00_00" BIGINT -- 04:00:00,
"n_04_15_00" BIGINT -- 04:15:00,
"n_04_30_00" BIGINT -- 04:30:00,
"n_04_45_00" BIGINT -- 04:45:00,
"n_05_00_00" BIGINT -- 05:00:00,
"n_05_15_00" BIGINT -- 05:15:00,
"n_05_30_00" BIGINT -- 05:30:00,
"n_05_45_00" BIGINT -- 05:45:00,
"n_06_00_00" BIGINT -- 06:00:00,
"n_06_15_00" BIGINT -- 06:15:00,
"n_06_30_00" BIGINT -- 06:30:00,
"n_06_45_00" BIGINT -- 06:45:00,
"n_07_00_00" BIGINT -- 07:00:00,
"n_07_15_00" BIGINT -- 07:15:00,
"n_07_30_00" BIGINT -- 07:30:00,
"n_07_45_00" BIGINT -- 07:45:00,
"n_08_00_00" BIGINT -- 08:00:00,
"n_08_15_00" BIGINT -- 08:15:00,
"n_08_30_00" BIGINT -- 08:30:00,
"n_08_45_00" BIGINT -- 08:45:00,
"n_09_00_00" BIGINT -- 09:00:00,
"n_09_15_00" BIGINT -- 09:15:00,
"n_09_30_00" BIGINT -- 09:30:00,
"n_09_45_00" BIGINT -- 09:45:00,
"n_10_00_00" BIGINT -- 10:00:00,
"n_10_15_00" BIGINT -- 10:15:00,
"n_10_30_00" BIGINT -- 10:30:00,
"n_10_45_00" BIGINT -- 10:45:00,
"n_11_00_00" BIGINT -- 11:00:00,
"n_11_15_00" BIGINT -- 11:15:00,
"n_11_30_00" BIGINT -- 11:30:00,
"n_11_45_00" BIGINT -- 11:45:00,
"n_12_00_00" BIGINT -- 12:00:00,
"n_12_15_00" BIGINT -- 12:15:00,
"n_12_30_00" BIGINT -- 12:30:00,
"n_12_45_00" BIGINT -- 12:45:00,
"n_13_00_00" BIGINT -- 13:00:00,
"n_13_15_00" BIGINT -- 13:15:00,
"n_13_30_00" BIGINT -- 13:30:00,
"n_13_45_00" BIGINT -- 13:45:00,
"n_14_00_00" BIGINT -- 14:00:00,
"n_14_15_00" BIGINT -- 14:15:00,
"n_14_30_00" BIGINT -- 14:30:00,
"n_14_45_00" BIGINT -- 14:45:00,
"n_15_00_00" BIGINT -- 15:00:00,
"n_15_15_00" BIGINT -- 15:15:00,
"n_15_30_00" BIGINT -- 15:30:00,
"n_15_45_00" BIGINT -- 15:45:00,
"n_16_00_00" BIGINT -- 16:00:00,
"n_16_15_00" BIGINT -- 16:15:00,
"n_16_30_00" BIGINT -- 16:30:00,
"n_16_45_00" BIGINT -- 16:45:00,
"n_17_00_00" BIGINT -- 17:00:00,
"n_17_15_00" BIGINT -- 17:15:00,
"n_17_30_00" BIGINT -- 17:30:00,
"n_17_45_00" BIGINT -- 17:45:00,
"n_18_00_00" BIGINT -- 18:00:00,
"n_18_15_00" BIGINT -- 18:15:00,
"n_18_30_00" BIGINT -- 18:30:00,
"n_18_45_00" BIGINT -- 18:45:00,
"n_19_00_00" BIGINT -- 19:00:00,
"n_19_15_00" BIGINT -- 19:15:00,
"n_19_30_00" BIGINT -- 19:30:00,
"n_19_45_00" BIGINT -- 19:45:00,
"n_20_00_00" BIGINT -- 20:00:00,
"n_20_15_00" BIGINT -- 20:15:00,
"n_20_30_00" BIGINT -- 20:30:00,
"n_20_45_00" BIGINT -- 20:45:00,
"n_21_00_00" BIGINT -- 21:00:00,
"n_21_15_00" BIGINT -- 21:15:00,
"n_21_30_00" BIGINT -- 21:30:00,
"n_21_45_00" BIGINT -- 21:45:00,
"n_22_00_00" BIGINT -- 22:00:00,
"n_22_15_00" BIGINT -- 22:15:00,
"n_22_30_00" BIGINT -- 22:30:00,
"n_22_45_00" BIGINT -- 22:45:00,
"n_23_00_00" BIGINT -- 23:00:00,
"n_23_15_00" BIGINT -- 23:15:00,
"n_23_30_00" BIGINT -- 23:30:00,
"n_23_45_00" BIGINT -- 23:45:00
);CREATE TABLE tennettso (
"date" TIMESTAMP,
"n_00_00_00" DOUBLE -- 00:00:00,
"n_00_15_00" DOUBLE -- 00:15:00,
"n_00_30_00" DOUBLE -- 00:30:00,
"n_00_45_00" DOUBLE -- 00:45:00,
"n_01_00_00" DOUBLE -- 01:00:00,
"n_01_15_00" DOUBLE -- 01:15:00,
"n_01_30_00" DOUBLE -- 01:30:00,
"n_01_45_00" DOUBLE -- 01:45:00,
"n_02_00_00" DOUBLE -- 02:00:00,
"n_02_15_00" DOUBLE -- 02:15:00,
"n_02_30_00" DOUBLE -- 02:30:00,
"n_02_45_00" DOUBLE -- 02:45:00,
"n_03_00_00" DOUBLE -- 03:00:00,
"n_03_15_00" DOUBLE -- 03:15:00,
"n_03_30_00" DOUBLE -- 03:30:00,
"n_03_45_00" DOUBLE -- 03:45:00,
"n_04_00_00" DOUBLE -- 04:00:00,
"n_04_15_00" DOUBLE -- 04:15:00,
"n_04_30_00" DOUBLE -- 04:30:00,
"n_04_45_00" DOUBLE -- 04:45:00,
"n_05_00_00" DOUBLE -- 05:00:00,
"n_05_15_00" DOUBLE -- 05:15:00,
"n_05_30_00" DOUBLE -- 05:30:00,
"n_05_45_00" DOUBLE -- 05:45:00,
"n_06_00_00" DOUBLE -- 06:00:00,
"n_06_15_00" DOUBLE -- 06:15:00,
"n_06_30_00" DOUBLE -- 06:30:00,
"n_06_45_00" DOUBLE -- 06:45:00,
"n_07_00_00" DOUBLE -- 07:00:00,
"n_07_15_00" DOUBLE -- 07:15:00,
"n_07_30_00" DOUBLE -- 07:30:00,
"n_07_45_00" DOUBLE -- 07:45:00,
"n_08_00_00" DOUBLE -- 08:00:00,
"n_08_15_00" DOUBLE -- 08:15:00,
"n_08_30_00" DOUBLE -- 08:30:00,
"n_08_45_00" DOUBLE -- 08:45:00,
"n_09_00_00" DOUBLE -- 09:00:00,
"n_09_15_00" DOUBLE -- 09:15:00,
"n_09_30_00" DOUBLE -- 09:30:00,
"n_09_45_00" DOUBLE -- 09:45:00,
"n_10_00_00" DOUBLE -- 10:00:00,
"n_10_15_00" DOUBLE -- 10:15:00,
"n_10_30_00" DOUBLE -- 10:30:00,
"n_10_45_00" DOUBLE -- 10:45:00,
"n_11_00_00" DOUBLE -- 11:00:00,
"n_11_15_00" DOUBLE -- 11:15:00,
"n_11_30_00" DOUBLE -- 11:30:00,
"n_11_45_00" DOUBLE -- 11:45:00,
"n_12_00_00" DOUBLE -- 12:00:00,
"n_12_15_00" DOUBLE -- 12:15:00,
"n_12_30_00" DOUBLE -- 12:30:00,
"n_12_45_00" DOUBLE -- 12:45:00,
"n_13_00_00" DOUBLE -- 13:00:00,
"n_13_15_00" DOUBLE -- 13:15:00,
"n_13_30_00" DOUBLE -- 13:30:00,
"n_13_45_00" DOUBLE -- 13:45:00,
"n_14_00_00" DOUBLE -- 14:00:00,
"n_14_15_00" DOUBLE -- 14:15:00,
"n_14_30_00" DOUBLE -- 14:30:00,
"n_14_45_00" DOUBLE -- 14:45:00,
"n_15_00_00" DOUBLE -- 15:00:00,
"n_15_15_00" DOUBLE -- 15:15:00,
"n_15_30_00" DOUBLE -- 15:30:00,
"n_15_45_00" DOUBLE -- 15:45:00,
"n_16_00_00" DOUBLE -- 16:00:00,
"n_16_15_00" DOUBLE -- 16:15:00,
"n_16_30_00" DOUBLE -- 16:30:00,
"n_16_45_00" DOUBLE -- 16:45:00,
"n_17_00_00" DOUBLE -- 17:00:00,
"n_17_15_00" DOUBLE -- 17:15:00,
"n_17_30_00" DOUBLE -- 17:30:00,
"n_17_45_00" DOUBLE -- 17:45:00,
"n_18_00_00" DOUBLE -- 18:00:00,
"n_18_15_00" DOUBLE -- 18:15:00,
"n_18_30_00" DOUBLE -- 18:30:00,
"n_18_45_00" DOUBLE -- 18:45:00,
"n_19_00_00" DOUBLE -- 19:00:00,
"n_19_15_00" DOUBLE -- 19:15:00,
"n_19_30_00" DOUBLE -- 19:30:00,
"n_19_45_00" DOUBLE -- 19:45:00,
"n_20_00_00" DOUBLE -- 20:00:00,
"n_20_15_00" DOUBLE -- 20:15:00,
"n_20_30_00" DOUBLE -- 20:30:00,
"n_20_45_00" DOUBLE -- 20:45:00,
"n_21_00_00" DOUBLE -- 21:00:00,
"n_21_15_00" DOUBLE -- 21:15:00,
"n_21_30_00" DOUBLE -- 21:30:00,
"n_21_45_00" DOUBLE -- 21:45:00,
"n_22_00_00" DOUBLE -- 22:00:00,
"n_22_15_00" DOUBLE -- 22:15:00,
"n_22_30_00" DOUBLE -- 22:30:00,
"n_22_45_00" DOUBLE -- 22:45:00,
"n_23_00_00" DOUBLE -- 23:00:00,
"n_23_15_00" DOUBLE -- 23:15:00,
"n_23_30_00" DOUBLE -- 23:30:00,
"n_23_45_00" DOUBLE -- 23:45:00
);CREATE TABLE transnetbw (
"date" TIMESTAMP,
"n_00_00_00" DOUBLE -- 00:00:00,
"n_00_15_00" DOUBLE -- 00:15:00,
"n_00_30_00" DOUBLE -- 00:30:00,
"n_00_45_00" DOUBLE -- 00:45:00,
"n_01_00_00" DOUBLE -- 01:00:00,
"n_01_15_00" DOUBLE -- 01:15:00,
"n_01_30_00" DOUBLE -- 01:30:00,
"n_01_45_00" DOUBLE -- 01:45:00,
"n_02_00_00" DOUBLE -- 02:00:00,
"n_02_15_00" DOUBLE -- 02:15:00,
"n_02_30_00" DOUBLE -- 02:30:00,
"n_02_45_00" DOUBLE -- 02:45:00,
"n_03_00_00" DOUBLE -- 03:00:00,
"n_03_15_00" DOUBLE -- 03:15:00,
"n_03_30_00" DOUBLE -- 03:30:00,
"n_03_45_00" DOUBLE -- 03:45:00,
"n_04_00_00" DOUBLE -- 04:00:00,
"n_04_15_00" DOUBLE -- 04:15:00,
"n_04_30_00" DOUBLE -- 04:30:00,
"n_04_45_00" DOUBLE -- 04:45:00,
"n_05_00_00" DOUBLE -- 05:00:00,
"n_05_15_00" DOUBLE -- 05:15:00,
"n_05_30_00" DOUBLE -- 05:30:00,
"n_05_45_00" DOUBLE -- 05:45:00,
"n_06_00_00" DOUBLE -- 06:00:00,
"n_06_15_00" DOUBLE -- 06:15:00,
"n_06_30_00" DOUBLE -- 06:30:00,
"n_06_45_00" DOUBLE -- 06:45:00,
"n_07_00_00" DOUBLE -- 07:00:00,
"n_07_15_00" DOUBLE -- 07:15:00,
"n_07_30_00" DOUBLE -- 07:30:00,
"n_07_45_00" DOUBLE -- 07:45:00,
"n_08_00_00" DOUBLE -- 08:00:00,
"n_08_15_00" DOUBLE -- 08:15:00,
"n_08_30_00" DOUBLE -- 08:30:00,
"n_08_45_00" DOUBLE -- 08:45:00,
"n_09_00_00" DOUBLE -- 09:00:00,
"n_09_15_00" DOUBLE -- 09:15:00,
"n_09_30_00" DOUBLE -- 09:30:00,
"n_09_45_00" DOUBLE -- 09:45:00,
"n_10_00_00" DOUBLE -- 10:00:00,
"n_10_15_00" DOUBLE -- 10:15:00,
"n_10_30_00" DOUBLE -- 10:30:00,
"n_10_45_00" DOUBLE -- 10:45:00,
"n_11_00_00" DOUBLE -- 11:00:00,
"n_11_15_00" DOUBLE -- 11:15:00,
"n_11_30_00" DOUBLE -- 11:30:00,
"n_11_45_00" DOUBLE -- 11:45:00,
"n_12_00_00" DOUBLE -- 12:00:00,
"n_12_15_00" DOUBLE -- 12:15:00,
"n_12_30_00" DOUBLE -- 12:30:00,
"n_12_45_00" DOUBLE -- 12:45:00,
"n_13_00_00" DOUBLE -- 13:00:00,
"n_13_15_00" DOUBLE -- 13:15:00,
"n_13_30_00" DOUBLE -- 13:30:00,
"n_13_45_00" DOUBLE -- 13:45:00,
"n_14_00_00" DOUBLE -- 14:00:00,
"n_14_15_00" DOUBLE -- 14:15:00,
"n_14_30_00" DOUBLE -- 14:30:00,
"n_14_45_00" DOUBLE -- 14:45:00,
"n_15_00_00" DOUBLE -- 15:00:00,
"n_15_15_00" DOUBLE -- 15:15:00,
"n_15_30_00" DOUBLE -- 15:30:00,
"n_15_45_00" DOUBLE -- 15:45:00,
"n_16_00_00" DOUBLE -- 16:00:00,
"n_16_15_00" DOUBLE -- 16:15:00,
"n_16_30_00" DOUBLE -- 16:30:00,
"n_16_45_00" DOUBLE -- 16:45:00,
"n_17_00_00" DOUBLE -- 17:00:00,
"n_17_15_00" DOUBLE -- 17:15:00,
"n_17_30_00" DOUBLE -- 17:30:00,
"n_17_45_00" DOUBLE -- 17:45:00,
"n_18_00_00" DOUBLE -- 18:00:00,
"n_18_15_00" DOUBLE -- 18:15:00,
"n_18_30_00" DOUBLE -- 18:30:00,
"n_18_45_00" DOUBLE -- 18:45:00,
"n_19_00_00" DOUBLE -- 19:00:00,
"n_19_15_00" DOUBLE -- 19:15:00,
"n_19_30_00" DOUBLE -- 19:30:00,
"n_19_45_00" DOUBLE -- 19:45:00,
"n_20_00_00" DOUBLE -- 20:00:00,
"n_20_15_00" DOUBLE -- 20:15:00,
"n_20_30_00" DOUBLE -- 20:30:00,
"n_20_45_00" DOUBLE -- 20:45:00,
"n_21_00_00" DOUBLE -- 21:00:00,
"n_21_15_00" DOUBLE -- 21:15:00,
"n_21_30_00" DOUBLE -- 21:30:00,
"n_21_45_00" DOUBLE -- 21:45:00,
"n_22_00_00" DOUBLE -- 22:00:00,
"n_22_15_00" DOUBLE -- 22:15:00,
"n_22_30_00" DOUBLE -- 22:30:00,
"n_22_45_00" DOUBLE -- 22:45:00,
"n_23_00_00" DOUBLE -- 23:00:00,
"n_23_15_00" DOUBLE -- 23:15:00,
"n_23_30_00" DOUBLE -- 23:30:00,
"n_23_45_00" DOUBLE -- 23:45:00
);Anyone who has the link will be able to view this.