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 Solar Data

@kaggle.erevear_space_weather_solar_geomagnetic_indices.daily_solar_data

160.11 KB
10330 rows
14 columns

date Date	radio_flux_10_7cm Radio Flux 10.7cm	sunspot_number Sunspot Number	sunspot_area_10_6_hemis Sunspot Area (10^6 Hemis.)	new_regions New Regions	stanford_mean_solar_field_goes15 Stanford Mean Solar Field (GOES15)	stanford_background_x_ray_flux Stanford Background X-Ray Flux	flares_s Flares: S	flares_1 Flares: 1	flares_2 Flares: 2	flares_3 Flares: 3
Wed Jan 01 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	72				*	A0.5	-1	-1	-1	-1
Thu Jan 02 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	72				*	A0.5	-1	-1	-1	-1
Fri Jan 03 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	73				3	A0.5	-1	-1	-1	-1
Sat Jan 04 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	74	13	10	1	*	A0.6	-1	-1	-1	-1
Sun Jan 05 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	74	15	20		5	A0.7	-1	-1	-1	-1
Mon Jan 06 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	73	15	10		8	A1.0	-1	-1	-1	-1
Tue Jan 07 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	73	12			*	A0.8	-1	-1	-1	-1
Wed Jan 08 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	74				*	A0.8	-1	-1	-1	-1
Thu Jan 09 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	74	12	20	1	*	A0.8	-1	-1	-1	-1
Fri Jan 10 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	75	13	30		*	A0.8	-1	-1	-1	-1


CREATE TABLE daily_solar_data (
  "date" TIMESTAMP,
  "radio_flux_10_7cm" BIGINT,
  "sunspot_number" BIGINT,
  "sunspot_area_10_6_hemis" BIGINT,
  "new_regions" BIGINT,
  "stanford_mean_solar_field_goes15" VARCHAR,
  "stanford_background_x_ray_flux" VARCHAR,
  "flares_c" BIGINT,
  "flares_m" BIGINT,
  "flares_x" BIGINT,
  "flares_s" BIGINT,
  "flares_1" BIGINT,
  "flares_2" BIGINT,
  "flares_3" BIGINT
);