NASA Solar Wave And Mag
Develop the Oracle of DSCOVR
@kaggle.asisheriberto_nasa_solar_wave
Develop the Oracle of DSCOVR
@kaggle.asisheriberto_nasa_solar_wave
This dataset is for the competition nasa space apps challenge and contains different data, both on magnetism and solar waves over different time periods.
CREATE TABLE dsc_fc_summed_spectra_2022_v01 (
"n_2022_01_01_00_00_00" TIMESTAMP -- 2022-01-01–00:00:00,
"n__6_1717" DOUBLE -- -6.1717,
"n_1_12483" DOUBLE -- 1.12483,
"n__4_90228" DOUBLE -- -4.90228,
"n_38_0314" DOUBLE -- 38.0314,
"n_0_231726" DOUBLE -- 0.231726,
"n_46_0427" DOUBLE -- 46.0427,
"n_44_9743" DOUBLE -- 44.9743,
"n_55_9143" DOUBLE -- 55.9143,
"n_43_7069" DOUBLE -- 43.7069,
"n_65_9537" DOUBLE -- 65.9537,
"n_63_3898" DOUBLE -- 63.3898,
"n_153_751" DOUBLE -- 153.751,
"n_113_728" DOUBLE -- 113.728,
"n_247_075" DOUBLE -- 247.075,
"n_311_317" DOUBLE -- 311.317,
"n_410_73" DOUBLE -- 410.73,
"n_451_121" DOUBLE -- 451.121,
"n_475_199" DOUBLE -- 475.199,
"n_447_67" DOUBLE -- 447.67,
"n_467_265" DOUBLE -- 467.265,
"n_419_028" DOUBLE -- 419.028,
"n_462_876" DOUBLE -- 462.876,
"n_454_962" DOUBLE -- 454.962,
"n_410_064" DOUBLE -- 410.064,
"n_394_014" DOUBLE -- 394.014,
"n_356_12" DOUBLE -- 356.12,
"n_315_868" DOUBLE -- 315.868,
"n_365_553" DOUBLE -- 365.553,
"n_292_86" DOUBLE -- 292.86,
"n_0" DOUBLE -- 0,
"n_0_1" DOUBLE -- 0.1,
"n_0_2" DOUBLE -- 0.2,
"n_0_3" DOUBLE -- 0.3,
"n_0_4" DOUBLE -- 0.4,
"n_0_5" DOUBLE -- 0.5,
"n_0_6" DOUBLE -- 0.6,
"n_0_7" DOUBLE -- 0.7,
"n_0_8" DOUBLE -- 0.8,
"n_0_9" DOUBLE -- 0.9,
"n_0_10" DOUBLE -- 0.10,
"n_0_11" DOUBLE -- 0.11,
"n_0_12" DOUBLE -- 0.12,
"n_0_13" DOUBLE -- 0.13,
"n_0_14" DOUBLE -- 0.14,
"n_0_15" DOUBLE -- 0.15,
"n_0_16" DOUBLE -- 0.16,
"n_0_17" DOUBLE -- 0.17,
"n_0_18" DOUBLE -- 0.18,
"n_0_19" DOUBLE -- 0.19,
"n_0_20" DOUBLE -- 0.20,
"n_0_21" DOUBLE -- 0.21,
"n_0_22" DOUBLE -- 0.22,
"n_0_23" DOUBLE -- 0.23
);
CREATE TABLE mag_7_day (
"time_tag" TIMESTAMP,
"bx_gsm" DOUBLE,
"by_gsm" DOUBLE,
"bz_gsm" DOUBLE,
"lon_gsm" DOUBLE,
"lat_gsm" DOUBLE,
"bt" DOUBLE
);
CREATE TABLE mag_7_day_trasf (
"column1" BIGINT,
"bx_gsm" DOUBLE,
"by_gsm" DOUBLE,
"bz_gsm" DOUBLE,
"lon_gsm" DOUBLE,
"lat_gsm" DOUBLE,
"bt" DOUBLE
);
CREATE TABLE mag_and_solarwind (
"timestamp" BIGINT,
"source" BIGINT,
"bt_med" DOUBLE,
"bt_min" DOUBLE,
"bt_max" DOUBLE,
"bx_med" DOUBLE,
"bx_min" DOUBLE,
"bx_max" DOUBLE,
"by_med" DOUBLE,
"by_min" DOUBLE,
"by_max" DOUBLE,
"bz_med" DOUBLE,
"bz_min" DOUBLE,
"bz_max" DOUBLE,
"phi_mean" DOUBLE,
"phi_min" DOUBLE,
"phi_max" DOUBLE,
"theta_med" DOUBLE,
"theta_min" DOUBLE,
"theta_max" DOUBLE,
"dens_med" DOUBLE,
"dens_min" DOUBLE,
"dens_max" DOUBLE,
"speed_med" DOUBLE,
"speed_min" DOUBLE,
"speed_max" DOUBLE,
"temp_med" BIGINT,
"temp_min" BIGINT,
"temp_max" BIGINT,
"n__1" VARCHAR -- 1
);
CREATE TABLE plasma_7_day (
"n_0" VARCHAR -- 0,
"n_1" VARCHAR -- 1,
"n_2" VARCHAR -- 2,
"n_3" VARCHAR -- 3
);
CREATE TABLE plasma_7_day_transf (
"column1" BIGINT,
"density" DOUBLE,
"speed" DOUBLE,
"temperature" DOUBLE
);
Anyone who has the link will be able to view this.