O M N I 2

Hourly mean values of interplanetary magnetic field and solar wind plasma

@kaggle.ujjwal9_o_m_n_i_2

Table List

1 table(22.63 MB)

Omni Data

@kaggle.ujjwal9_o_m_n_i_2.omni_data

22.63 MB
482136 rows
56 columns

unnamed_0 Unnamed: 0	year Year	day Day	hour Hour	bartels_rotation_num Bartels Rotation Num	id_imf_sc Id IMF Sc	n__imf_avg #IMF Avg	n__plasma_avg #plasma Avg	field_mag_avg Field Mag Avg	mag_avg_field_vec Mag Avg Field Vec	lat_angle_avg_field_vec Lat Angle Avg Field Vec	long_angle_avg_field_vec Long Angle Avg Field Vec	bx_gse_gsm Bx GSE GSM	by_gse By GSE	bz_gse Bz GSE	by_gsm By GSM	bz_gsm Bz GSM	sigma_b Sigma \|B\|	sigma_b_97e94f Sigma B	sigma_bx Sigma Bx	sigma_by Sigma By	sigma_bz Sigma Bz	proton_temp Proton Temp	proton_density Proton Density	plasma_flow_speed Plasma Flow Speed	plasma_flow_long_angle Plasma Flow Long Angle	plasma_flow_lat_angle Plasma Flow Lat Angle	na_np Na/Np	flow_pressure Flow Pressure	sigma_t Sigma T	sigma_n Sigma N	sigma_v Sigma V	sigma_phi_v Sigma Phi V	sigma_theta_v Sigma Theta V	sigma_na_np Sigma-Na/Np	electric_field Electric Field	plasma_beta Plasma Beta	alfven_mach_num Alfven Mach Num	kp Kp	r R	dst Dst	ae_index AE Index	pf PF	pf_1 PF.1	pf_2 PF.2	pf_3 PF.3	pf_4 PF.4	pf_5 PF.5	ap_index Ap Index	f10_7_index F10.7 Index	pc_n_index PC(N) Index	al_index_kyoto AL Index Kyoto	au_index_kyoto AU Index Kyoto	magnetosonic_mach_num Magnetosonic Mach Num
	1963	1		1771	99	999	999	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	9999999	999.9	9999	999.9	999.9	9.999	99.99	9999999	999.9	9999	999.9	999.9	9.999	999.99	999.99	999.9	7	33	-6	119	999999.99	99999.99	99999.99	99999.99	99999.99	99999.99	3	999.9	999.9	99999	99999	99.9
1	1963	1	1	1771	99	999	999	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	9999999	999.9	9999	999.9	999.9	9.999	99.99	9999999	999.9	9999	999.9	999.9	9.999	999.99	999.99	999.9	7	33	-5	143	999999.99	99999.99	99999.99	99999.99	99999.99	99999.99	3	999.9	999.9	99999	99999	99.9
2	1963	1	2	1771	99	999	999	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	9999999	999.9	9999	999.9	999.9	9.999	99.99	9999999	999.9	9999	999.9	999.9	9.999	999.99	999.99	999.9	7	33	-5	66	999999.99	99999.99	99999.99	99999.99	99999.99	99999.99	3	999.9	999.9	99999	99999	99.9
3	1963	1	3	1771	99	999	999	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	9999999	999.9	9999	999.9	999.9	9.999	99.99	9999999	999.9	9999	999.9	999.9	9.999	999.99	999.99	999.9	20	33	-3	51	999999.99	99999.99	99999.99	99999.99	99999.99	99999.99	7	999.9	999.9	99999	99999	99.9
4	1963	1	4	1771	99	999	999	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	9999999	999.9	9999	999.9	999.9	9.999	99.99	9999999	999.9	9999	999.9	999.9	9.999	999.99	999.99	999.9	20	33	-3	95	999999.99	99999.99	99999.99	99999.99	99999.99	99999.99	7	999.9	999.9	99999	99999	99.9
5	1963	1	5	1771	99	999	999	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	9999999	999.9	9999	999.9	999.9	9.999	99.99	9999999	999.9	9999	999.9	999.9	9.999	999.99	999.99	999.9	20	33	-6	57	999999.99	99999.99	99999.99	99999.99	99999.99	99999.99	7	999.9	999.9	99999	99999	99.9
6	1963	1	6	1771	99	999	999	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	9999999	999.9	9999	999.9	999.9	9.999	99.99	9999999	999.9	9999	999.9	999.9	9.999	999.99	999.99	999.9	17	33	-8	52	999999.99	99999.99	99999.99	99999.99	99999.99	99999.99	6	999.9	999.9	99999	99999	99.9
7	1963	1	7	1771	99	999	999	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	9999999	999.9	9999	999.9	999.9	9.999	99.99	9999999	999.9	9999	999.9	999.9	9.999	999.99	999.99	999.9	17	33	-9	60	999999.99	99999.99	99999.99	99999.99	99999.99	99999.99	6	999.9	999.9	99999	99999	99.9
8	1963	1	8	1771	99	999	999	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	9999999	999.9	9999	999.9	999.9	9.999	99.99	9999999	999.9	9999	999.9	999.9	9.999	999.99	999.99	999.9	17	33	-6	113	999999.99	99999.99	99999.99	99999.99	99999.99	99999.99	6	999.9	999.9	99999	99999	99.9
9	1963	1	9	1771	99	999	999	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	999.9	9999999	999.9	9999	999.9	999.9	9.999	99.99	9999999	999.9	9999	999.9	999.9	9.999	999.99	999.99	999.9	10	33	-2	76	999999.99	99999.99	99999.99	99999.99	99999.99	99999.99	4	999.9	999.9	99999	99999	99.9


CREATE TABLE omni_data (
  "unnamed_0" BIGINT,
  "year" BIGINT,
  "day" DOUBLE,
  "hour" DOUBLE,
  "bartels_rotation_num" BIGINT,
  "id_imf_sc" BIGINT,
  "id_sw_plasma_sc" DOUBLE,
  "n__imf_avg" BIGINT,
  "n__plasma_avg" BIGINT,
  "field_mag_avg" DOUBLE,
  "mag_avg_field_vec" DOUBLE,
  "lat_angle_avg_field_vec" DOUBLE,
  "long_angle_avg_field_vec" DOUBLE,
  "bx_gse_gsm" DOUBLE,
  "by_gse" DOUBLE,
  "bz_gse" DOUBLE,
  "by_gsm" DOUBLE,
  "bz_gsm" DOUBLE,
  "sigma_b" DOUBLE,
  "sigma_b_97e94f" DOUBLE,
  "sigma_bx" DOUBLE,
  "sigma_by" DOUBLE,
  "sigma_bz" DOUBLE,
  "proton_temp" DOUBLE,
  "proton_density" DOUBLE,
  "plasma_flow_speed" DOUBLE,
  "plasma_flow_long_angle" DOUBLE,
  "plasma_flow_lat_angle" DOUBLE,
  "na_np" DOUBLE,
  "flow_pressure" DOUBLE,
  "sigma_t" DOUBLE,
  "sigma_n" DOUBLE,
  "sigma_v" DOUBLE,
  "sigma_phi_v" DOUBLE,
  "sigma_theta_v" DOUBLE,
  "sigma_na_np" DOUBLE,
  "electric_field" DOUBLE,
  "plasma_beta" DOUBLE,
  "alfven_mach_num" DOUBLE,
  "kp" DOUBLE,
  "r" DOUBLE,
  "dst" DOUBLE,
  "ae_index" DOUBLE,
  "pf" DOUBLE,
  "pf_1" DOUBLE,
  "pf_2" DOUBLE,
  "pf_3" DOUBLE,
  "pf_4" DOUBLE,
  "pf_5" DOUBLE,
  "flag" DOUBLE,
  "ap_index" DOUBLE,
  "f10_7_index" DOUBLE,
  "pc_n_index" DOUBLE,
  "al_index_kyoto" DOUBLE,
  "au_index_kyoto" DOUBLE,
  "magnetosonic_mach_num" DOUBLE
);