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
CREATE TABLE amprion (
"date" TIMESTAMP,
"n_00_00_00" BIGINT,
"n_00_15_00" BIGINT,
"n_00_30_00" BIGINT,
"n_00_45_00" BIGINT,
"n_01_00_00" BIGINT,
"n_01_15_00" BIGINT,
"n_01_30_00" BIGINT,
"n_01_45_00" BIGINT,
"n_02_00_00" BIGINT,
"n_02_15_00" BIGINT,
"n_02_30_00" BIGINT,
"n_02_45_00" BIGINT,
"n_03_00_00" BIGINT,
"n_03_15_00" BIGINT,
"n_03_30_00" BIGINT,
"n_03_45_00" BIGINT,
"n_04_00_00" BIGINT,
"n_04_15_00" BIGINT,
"n_04_30_00" BIGINT,
"n_04_45_00" BIGINT,
"n_05_00_00" BIGINT,
"n_05_15_00" BIGINT,
"n_05_30_00" BIGINT,
"n_05_45_00" BIGINT,
"n_06_00_00" BIGINT,
"n_06_15_00" BIGINT,
"n_06_30_00" BIGINT,
"n_06_45_00" BIGINT,
"n_07_00_00" BIGINT,
"n_07_15_00" BIGINT,
"n_07_30_00" BIGINT,
"n_07_45_00" BIGINT,
"n_08_00_00" BIGINT,
"n_08_15_00" BIGINT,
"n_08_30_00" BIGINT,
"n_08_45_00" BIGINT,
"n_09_00_00" BIGINT,
"n_09_15_00" BIGINT,
"n_09_30_00" BIGINT,
"n_09_45_00" BIGINT,
"n_10_00_00" BIGINT,
"n_10_15_00" BIGINT,
"n_10_30_00" BIGINT,
"n_10_45_00" BIGINT,
"n_11_00_00" BIGINT,
"n_11_15_00" BIGINT,
"n_11_30_00" BIGINT,
"n_11_45_00" BIGINT,
"n_12_00_00" BIGINT,
"n_12_15_00" BIGINT,
"n_12_30_00" BIGINT,
"n_12_45_00" BIGINT,
"n_13_00_00" BIGINT,
"n_13_15_00" BIGINT,
"n_13_30_00" BIGINT,
"n_13_45_00" BIGINT,
"n_14_00_00" BIGINT,
"n_14_15_00" BIGINT,
"n_14_30_00" BIGINT,
"n_14_45_00" BIGINT,
"n_15_00_00" BIGINT,
"n_15_15_00" BIGINT,
"n_15_30_00" BIGINT,
"n_15_45_00" BIGINT,
"n_16_00_00" BIGINT,
"n_16_15_00" BIGINT,
"n_16_30_00" BIGINT,
"n_16_45_00" BIGINT,
"n_17_00_00" BIGINT,
"n_17_15_00" BIGINT,
"n_17_30_00" BIGINT,
"n_17_45_00" BIGINT,
"n_18_00_00" BIGINT,
"n_18_15_00" BIGINT,
"n_18_30_00" BIGINT,
"n_18_45_00" BIGINT,
"n_19_00_00" BIGINT,
"n_19_15_00" BIGINT,
"n_19_30_00" BIGINT,
"n_19_45_00" BIGINT,
"n_20_00_00" BIGINT,
"n_20_15_00" BIGINT,
"n_20_30_00" BIGINT,
"n_20_45_00" BIGINT,
"n_21_00_00" BIGINT,
"n_21_15_00" BIGINT,
"n_21_30_00" BIGINT,
"n_21_45_00" BIGINT,
"n_22_00_00" BIGINT,
"n_22_15_00" BIGINT,
"n_22_30_00" BIGINT,
"n_22_45_00" BIGINT,
"n_23_00_00" BIGINT,
"n_23_15_00" BIGINT,
"n_23_30_00" BIGINT,
"n_23_45_00" BIGINT
);
CREATE TABLE n_50hertz (
"date" TIMESTAMP,
"n_00_00_00" BIGINT,
"n_00_15_00" BIGINT,
"n_00_30_00" BIGINT,
"n_00_45_00" BIGINT,
"n_01_00_00" BIGINT,
"n_01_15_00" BIGINT,
"n_01_30_00" BIGINT,
"n_01_45_00" BIGINT,
"n_02_00_00" BIGINT,
"n_02_15_00" BIGINT,
"n_02_30_00" BIGINT,
"n_02_45_00" BIGINT,
"n_03_00_00" BIGINT,
"n_03_15_00" BIGINT,
"n_03_30_00" BIGINT,
"n_03_45_00" BIGINT,
"n_04_00_00" BIGINT,
"n_04_15_00" BIGINT,
"n_04_30_00" BIGINT,
"n_04_45_00" BIGINT,
"n_05_00_00" BIGINT,
"n_05_15_00" BIGINT,
"n_05_30_00" BIGINT,
"n_05_45_00" BIGINT,
"n_06_00_00" BIGINT,
"n_06_15_00" BIGINT,
"n_06_30_00" BIGINT,
"n_06_45_00" BIGINT,
"n_07_00_00" BIGINT,
"n_07_15_00" BIGINT,
"n_07_30_00" BIGINT,
"n_07_45_00" BIGINT,
"n_08_00_00" BIGINT,
"n_08_15_00" BIGINT,
"n_08_30_00" BIGINT,
"n_08_45_00" BIGINT,
"n_09_00_00" BIGINT,
"n_09_15_00" BIGINT,
"n_09_30_00" BIGINT,
"n_09_45_00" BIGINT,
"n_10_00_00" BIGINT,
"n_10_15_00" BIGINT,
"n_10_30_00" BIGINT,
"n_10_45_00" BIGINT,
"n_11_00_00" BIGINT,
"n_11_15_00" BIGINT,
"n_11_30_00" BIGINT,
"n_11_45_00" BIGINT,
"n_12_00_00" BIGINT,
"n_12_15_00" BIGINT,
"n_12_30_00" BIGINT,
"n_12_45_00" BIGINT,
"n_13_00_00" BIGINT,
"n_13_15_00" BIGINT,
"n_13_30_00" BIGINT,
"n_13_45_00" BIGINT,
"n_14_00_00" BIGINT,
"n_14_15_00" BIGINT,
"n_14_30_00" BIGINT,
"n_14_45_00" BIGINT,
"n_15_00_00" BIGINT,
"n_15_15_00" BIGINT,
"n_15_30_00" BIGINT,
"n_15_45_00" BIGINT,
"n_16_00_00" BIGINT,
"n_16_15_00" BIGINT,
"n_16_30_00" BIGINT,
"n_16_45_00" BIGINT,
"n_17_00_00" BIGINT,
"n_17_15_00" BIGINT,
"n_17_30_00" BIGINT,
"n_17_45_00" BIGINT,
"n_18_00_00" BIGINT,
"n_18_15_00" BIGINT,
"n_18_30_00" BIGINT,
"n_18_45_00" BIGINT,
"n_19_00_00" BIGINT,
"n_19_15_00" BIGINT,
"n_19_30_00" BIGINT,
"n_19_45_00" BIGINT,
"n_20_00_00" BIGINT,
"n_20_15_00" BIGINT,
"n_20_30_00" BIGINT,
"n_20_45_00" BIGINT,
"n_21_00_00" BIGINT,
"n_21_15_00" BIGINT,
"n_21_30_00" BIGINT,
"n_21_45_00" BIGINT,
"n_22_00_00" BIGINT,
"n_22_15_00" BIGINT,
"n_22_30_00" BIGINT,
"n_22_45_00" BIGINT,
"n_23_00_00" BIGINT,
"n_23_15_00" BIGINT,
"n_23_30_00" BIGINT,
"n_23_45_00" BIGINT
);
CREATE TABLE tennettso (
"date" TIMESTAMP,
"n_00_00_00" DOUBLE,
"n_00_15_00" DOUBLE,
"n_00_30_00" DOUBLE,
"n_00_45_00" DOUBLE,
"n_01_00_00" DOUBLE,
"n_01_15_00" DOUBLE,
"n_01_30_00" DOUBLE,
"n_01_45_00" DOUBLE,
"n_02_00_00" DOUBLE,
"n_02_15_00" DOUBLE,
"n_02_30_00" DOUBLE,
"n_02_45_00" DOUBLE,
"n_03_00_00" DOUBLE,
"n_03_15_00" DOUBLE,
"n_03_30_00" DOUBLE,
"n_03_45_00" DOUBLE,
"n_04_00_00" DOUBLE,
"n_04_15_00" DOUBLE,
"n_04_30_00" DOUBLE,
"n_04_45_00" DOUBLE,
"n_05_00_00" DOUBLE,
"n_05_15_00" DOUBLE,
"n_05_30_00" DOUBLE,
"n_05_45_00" DOUBLE,
"n_06_00_00" DOUBLE,
"n_06_15_00" DOUBLE,
"n_06_30_00" DOUBLE,
"n_06_45_00" DOUBLE,
"n_07_00_00" DOUBLE,
"n_07_15_00" DOUBLE,
"n_07_30_00" DOUBLE,
"n_07_45_00" DOUBLE,
"n_08_00_00" DOUBLE,
"n_08_15_00" DOUBLE,
"n_08_30_00" DOUBLE,
"n_08_45_00" DOUBLE,
"n_09_00_00" DOUBLE,
"n_09_15_00" DOUBLE,
"n_09_30_00" DOUBLE,
"n_09_45_00" DOUBLE,
"n_10_00_00" DOUBLE,
"n_10_15_00" DOUBLE,
"n_10_30_00" DOUBLE,
"n_10_45_00" DOUBLE,
"n_11_00_00" DOUBLE,
"n_11_15_00" DOUBLE,
"n_11_30_00" DOUBLE,
"n_11_45_00" DOUBLE,
"n_12_00_00" DOUBLE,
"n_12_15_00" DOUBLE,
"n_12_30_00" DOUBLE,
"n_12_45_00" DOUBLE,
"n_13_00_00" DOUBLE,
"n_13_15_00" DOUBLE,
"n_13_30_00" DOUBLE,
"n_13_45_00" DOUBLE,
"n_14_00_00" DOUBLE,
"n_14_15_00" DOUBLE,
"n_14_30_00" DOUBLE,
"n_14_45_00" DOUBLE,
"n_15_00_00" DOUBLE,
"n_15_15_00" DOUBLE,
"n_15_30_00" DOUBLE,
"n_15_45_00" DOUBLE,
"n_16_00_00" DOUBLE,
"n_16_15_00" DOUBLE,
"n_16_30_00" DOUBLE,
"n_16_45_00" DOUBLE,
"n_17_00_00" DOUBLE,
"n_17_15_00" DOUBLE,
"n_17_30_00" DOUBLE,
"n_17_45_00" DOUBLE,
"n_18_00_00" DOUBLE,
"n_18_15_00" DOUBLE,
"n_18_30_00" DOUBLE,
"n_18_45_00" DOUBLE,
"n_19_00_00" DOUBLE,
"n_19_15_00" DOUBLE,
"n_19_30_00" DOUBLE,
"n_19_45_00" DOUBLE,
"n_20_00_00" DOUBLE,
"n_20_15_00" DOUBLE,
"n_20_30_00" DOUBLE,
"n_20_45_00" DOUBLE,
"n_21_00_00" DOUBLE,
"n_21_15_00" DOUBLE,
"n_21_30_00" DOUBLE,
"n_21_45_00" DOUBLE,
"n_22_00_00" DOUBLE,
"n_22_15_00" DOUBLE,
"n_22_30_00" DOUBLE,
"n_22_45_00" DOUBLE,
"n_23_00_00" DOUBLE,
"n_23_15_00" DOUBLE,
"n_23_30_00" DOUBLE,
"n_23_45_00" DOUBLE
);
CREATE TABLE transnetbw (
"date" TIMESTAMP,
"n_00_00_00" DOUBLE,
"n_00_15_00" DOUBLE,
"n_00_30_00" DOUBLE,
"n_00_45_00" DOUBLE,
"n_01_00_00" DOUBLE,
"n_01_15_00" DOUBLE,
"n_01_30_00" DOUBLE,
"n_01_45_00" DOUBLE,
"n_02_00_00" DOUBLE,
"n_02_15_00" DOUBLE,
"n_02_30_00" DOUBLE,
"n_02_45_00" DOUBLE,
"n_03_00_00" DOUBLE,
"n_03_15_00" DOUBLE,
"n_03_30_00" DOUBLE,
"n_03_45_00" DOUBLE,
"n_04_00_00" DOUBLE,
"n_04_15_00" DOUBLE,
"n_04_30_00" DOUBLE,
"n_04_45_00" DOUBLE,
"n_05_00_00" DOUBLE,
"n_05_15_00" DOUBLE,
"n_05_30_00" DOUBLE,
"n_05_45_00" DOUBLE,
"n_06_00_00" DOUBLE,
"n_06_15_00" DOUBLE,
"n_06_30_00" DOUBLE,
"n_06_45_00" DOUBLE,
"n_07_00_00" DOUBLE,
"n_07_15_00" DOUBLE,
"n_07_30_00" DOUBLE,
"n_07_45_00" DOUBLE,
"n_08_00_00" DOUBLE,
"n_08_15_00" DOUBLE,
"n_08_30_00" DOUBLE,
"n_08_45_00" DOUBLE,
"n_09_00_00" DOUBLE,
"n_09_15_00" DOUBLE,
"n_09_30_00" DOUBLE,
"n_09_45_00" DOUBLE,
"n_10_00_00" DOUBLE,
"n_10_15_00" DOUBLE,
"n_10_30_00" DOUBLE,
"n_10_45_00" DOUBLE,
"n_11_00_00" DOUBLE,
"n_11_15_00" DOUBLE,
"n_11_30_00" DOUBLE,
"n_11_45_00" DOUBLE,
"n_12_00_00" DOUBLE,
"n_12_15_00" DOUBLE,
"n_12_30_00" DOUBLE,
"n_12_45_00" DOUBLE,
"n_13_00_00" DOUBLE,
"n_13_15_00" DOUBLE,
"n_13_30_00" DOUBLE,
"n_13_45_00" DOUBLE,
"n_14_00_00" DOUBLE,
"n_14_15_00" DOUBLE,
"n_14_30_00" DOUBLE,
"n_14_45_00" DOUBLE,
"n_15_00_00" DOUBLE,
"n_15_15_00" DOUBLE,
"n_15_30_00" DOUBLE,
"n_15_45_00" DOUBLE,
"n_16_00_00" DOUBLE,
"n_16_15_00" DOUBLE,
"n_16_30_00" DOUBLE,
"n_16_45_00" DOUBLE,
"n_17_00_00" DOUBLE,
"n_17_15_00" DOUBLE,
"n_17_30_00" DOUBLE,
"n_17_45_00" DOUBLE,
"n_18_00_00" DOUBLE,
"n_18_15_00" DOUBLE,
"n_18_30_00" DOUBLE,
"n_18_45_00" DOUBLE,
"n_19_00_00" DOUBLE,
"n_19_15_00" DOUBLE,
"n_19_30_00" DOUBLE,
"n_19_45_00" DOUBLE,
"n_20_00_00" DOUBLE,
"n_20_15_00" DOUBLE,
"n_20_30_00" DOUBLE,
"n_20_45_00" DOUBLE,
"n_21_00_00" DOUBLE,
"n_21_15_00" DOUBLE,
"n_21_30_00" DOUBLE,
"n_21_45_00" DOUBLE,
"n_22_00_00" DOUBLE,
"n_22_15_00" DOUBLE,
"n_22_30_00" DOUBLE,
"n_22_45_00" DOUBLE,
"n_23_00_00" DOUBLE,
"n_23_15_00" DOUBLE,
"n_23_30_00" DOUBLE,
"n_23_45_00" DOUBLE
);
Anyone who has the link will be able to view this.