Space Weather: Solar + Geomagnetic Indices

A collection of indexes related to solar weather including k/a indices

@kaggle.erevear_space_weather_solar_geomagnetic_indices

Table List

2 tables(1 MB)

Daily Geomagnetic Data

@kaggle.erevear_space_weather_solar_geomagnetic_indices.daily_geomagnetic_data

864.91 KB
78672 rows
7 columns

timestamp Timestamp	middle_latitude_a Middle Latitude A	high_latitude_a High Latitude A	estimated_a Estimated A	middle_latitude_k Middle Latitude K	high_latitude_k High Latitude K	estimated_k Estimated K
Wed Jan 01 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	4	*	2	1	*	1
Wed Jan 01 1997 03:00:00 GMT+0000 (Coordinated Universal Time)	4	*	2	1	*	1
Wed Jan 01 1997 06:00:00 GMT+0000 (Coordinated Universal Time)	4	*	2	1	*
Wed Jan 01 1997 09:00:00 GMT+0000 (Coordinated Universal Time)	4	*	2	1	*
Wed Jan 01 1997 12:00:00 GMT+0000 (Coordinated Universal Time)	4	*	2	1	*
Wed Jan 01 1997 15:00:00 GMT+0000 (Coordinated Universal Time)	4	*	2	1	*	1
Wed Jan 01 1997 18:00:00 GMT+0000 (Coordinated Universal Time)	4	*	2	1	*	1
Wed Jan 01 1997 21:00:00 GMT+0000 (Coordinated Universal Time)	4	*	2	2	*	2
Thu Jan 02 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	4	*	5	1	*	1
Thu Jan 02 1997 03:00:00 GMT+0000 (Coordinated Universal Time)	4	*	5	1	*	1


CREATE TABLE daily_geomagnetic_data (
  "timestamp" TIMESTAMP,
  "middle_latitude_a" BIGINT,
  "high_latitude_a" VARCHAR,
  "estimated_a" BIGINT,
  "middle_latitude_k" BIGINT,
  "high_latitude_k" VARCHAR,
  "estimated_k" DOUBLE
);