Exoplanets Confirmed & Candidates

#astronomy#astrophysics

@kaggle.ilyamarchenko_full_exoplanet_catalog

Table List

1 table(1.3 MB)

Exoplanet Confirm And Candidates

@kaggle.ilyamarchenko_full_exoplanet_catalog.exoplanet_confirm_and_candidates

1.3 MB
7414 rows
98 columns

n__name # Name	planet_status Planet Status	mass Mass	mass_error_min Mass Error Min	mass_error_max Mass Error Max	mass_sini Mass Sini	mass_sini_error_min Mass Sini Error Min	mass_sini_error_max Mass Sini Error Max	orbital_period Orbital Period	orbital_period_error_min Orbital Period Error Min	orbital_period_error_max Orbital Period Error Max	semi_major_axis Semi Major Axis	semi_major_axis_error_min Semi Major Axis Error Min	semi_major_axis_error_max Semi Major Axis Error Max	eccentricity Eccentricity	eccentricity_error_min Eccentricity Error Min	eccentricity_error_max Eccentricity Error Max	angular_distance Angular Distance	discovered Discovered	updated Updated	omega Omega	omega_error_min Omega Error Min	omega_error_max Omega Error Max	tperi Tperi	tperi_error_min Tperi Error Min	tperi_error_max Tperi Error Max	k K	k_error_min K Error Min	k_error_max K Error Max	publication Publication	detection_type Detection Type	mass_detection_type Mass Detection Type	radius_detection_type Radius Detection Type	alternate_names Alternate Names	molecules Molecules	star_name Star Name	ra Ra	dec Dec	mag_v Mag V	mag_i Mag I	mag_j Mag J	mag_h Mag H	mag_k Mag K	star_distance Star Distance	star_distance_error_min Star Distance Error Min	star_distance_error_max Star Distance Error Max	star_metallicity Star Metallicity	star_metallicity_error_min Star Metallicity Error Min	star_metallicity_error_max Star Metallicity Error Max	star_mass Star Mass	star_mass_error_min Star Mass Error Min	star_mass_error_max Star Mass Error Max	star_radius Star Radius	star_radius_error_min Star Radius Error Min	star_radius_error_max Star Radius Error Max	star_sp_type Star Sp Type	star_age Star Age	star_age_error_min Star Age Error Min	star_age_error_max Star Age Error Max	star_teff Star Teff	star_teff_error_min Star Teff Error Min	star_teff_error_max Star Teff Error Max	star_detected_disc Star Detected Disc	star_magnetic_field Star Magnetic Field	star_alternate_names Star Alternate Names
11 Com b	Confirmed				19.4	1.5	1.5	326.03	0.32	0.32	1.29	0.05	0.05	0.231	0.005	0.005	0.011664	2008	Fri Aug 21 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	94.8	1.5	1.5	2452899.6	1.6	1.6	296.7	5.6	5.6	Published in a refereed paper	Radial Velocity	nan	nan	nan	nan	11 Com	185.1791667	17.7927778	4.74					110.6	10.5	10.5	-0.35	0.09	0.09	2.7	0.3	0.3	19	2	2	G8 III				4742	100	100	nan	nan	nan
11 Oph b	Confirmed	21	3	3				730000	365000	365000	243	55	55				1.675862	2007	Mon Jun 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)										Published in a refereed paper	Imaging	nan	nan	Oph 1622-2405 b	nan	11 Oph	245.6041667	-24.0872222					14.03	145	20	20				0.0162	0.005	0.005				M9	0.011	0.002	0.002	2375	175	175	nan	nan	Oph 1622-2405, Oph 11A
11 UMi b	Confirmed				10.5	2.47	2.47	516.22	3.25	3.25	1.54	0.07	0.07	0.08	0.03	0.03	0.012887	2009	Wed Aug 12 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	117.63	21.06	21.06	2452861.05	2.06	2.06				Published in a refereed paper	Radial Velocity	nan	nan	nan	nan	11 UMi	229.275	71.8238889	5.02					119.5	6.9	6.9	0.04	0.04	0.04	1.8	0.25	0.25	24.08	1.84	1.84	K4III	1.56	0.54	0.54	4340	70	70	nan	nan	nan
11 Uma b	Unconfirmed	3.72	0.82	0.82				651.9	7.1	7.1	1.56	0.07	0.07	0.7	0.07	0.07	0.049367	2008	Thu Nov 25 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	6.24	8.9	8.9	53469.3	5	5				Published in a refereed paper	Default	nan	nan	nan	nan	11 Uma	137.0958333	66.8733333	5.16					31.6	2.9	2.9	-0.245	0.04	0.04	1.81	0.195	0.195	36.3	4.2	4.2	K5III				4090	70	70	nan	nan	nan
14 And b	Confirmed				5.33	0.57	0.57	185.84	0.23	0.23	0.83						0.010864	2008	Wed Aug 27 2014 00:00:00 GMT+0000 (Coordinated Universal Time)				2452861.4	1.5	1.5				Published in a refereed paper	Radial Velocity	nan	nan	nan	nan	14 And	352.8208333	39.2361111	5.22	4.1	3.02	2.61	2.33	76.4	4.1	4.1	-0.24			2.2	0.2	0.2	11	1	1	K0III				4813	20	20	nan	nan	nan
14 Her b	Confirmed				4.64	0.19	0.19	1773.4	2.5	2.5	2.77	0.05	0.05	0.369	0.005	0.005	0.153039	2002	Wed Aug 27 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	22.6	0.9	0.9	2451372.7	3.6	3.6				Published in a refereed paper	Radial Velocity	nan	nan	nan	nan	14 Her	242.5958333	43.8216667	6.67					18.1			0.43	0.08	0.08	0.9			0.708	0.085	0.085	K0 V	5.1			5311	87	87	nan	nan	nan
14 Her c	Unconfirmed	2.1						6906	70	70	6.9						0.381215	2006	Wed Nov 25 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	218			9100						Submitted to a professional journal	Default	nan	nan	nan	nan	14 Her	242.5958333	43.8216667	6.67					18.1			0.43	0.08	0.08	0.9			0.708	0.085	0.085	K0 V	5.1			5311	87	87	nan	nan	nan
16 Cyg B b	Confirmed				1.68	0.07	0.07	799.5	0.6	0.6	1.68	0.03	0.03	0.689	0.011	0.011	0.078468	1996	Wed Aug 27 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	83.4	2.1	2.1	2450539.3	1.6	1.6				Published in a refereed paper	Radial Velocity	nan	nan	nan	nan	16 Cyg B	295.4625	50.5175	6.2					21.41	0.24	0.24	0.08	0.04	0.04	1.01	0.04	0.04	0.98	0.13	0.13	G2.5 V	8	1.8	1.8	5766	60	60	nan	nan	nan
17 Sco b	Confirmed				4.32	0.12	0.15	578.38	2	2	1.45	0.02	0.02	0.06	0.02	0.03		2020	Mon Oct 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	57.03	106.77	113.18	2453294.28	182.91	174.23	92.4	3.84	3.9	Published in a refereed paper	Radial Velocity	Radial Velocity	nan	nan	nan	17 Sco	243.462500017	-11.837777798	5.24					116	4.53	4.91	-0.01	0.1	0.1	1.22	0.14	0.14	25.92	0.74	0.78	K3 III	5.13	1.33	2.12	4157	11	11	nan	nan	nan
18 Del b	Confirmed				10.3			993.3	3.2	3.2	2.6			0.08	0.01	0.01	0.035568	2008	Wed Aug 27 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	166.1	6.5	6.5	2451672	18	18				Published in a refereed paper	Radial Velocity	nan	nan	nan	nan	18 Del	314.6083333	10.8391667	5.52		4.03	3.44	3.67	73.1	3.5	3.5	-0.052	0.023	0.023	2.3			8.5			G6III				4979	18	18	nan	nan	nan


CREATE TABLE exoplanet_confirm_and_candidates (
  "n__name" VARCHAR,
  "planet_status" VARCHAR,
  "mass" DOUBLE,
  "mass_error_min" DOUBLE,
  "mass_error_max" DOUBLE,
  "mass_sini" DOUBLE,
  "mass_sini_error_min" DOUBLE,
  "mass_sini_error_max" DOUBLE,
  "radius" DOUBLE,
  "radius_error_min" DOUBLE,
  "radius_error_max" DOUBLE,
  "orbital_period" DOUBLE,
  "orbital_period_error_min" DOUBLE,
  "orbital_period_error_max" DOUBLE,
  "semi_major_axis" DOUBLE,
  "semi_major_axis_error_min" DOUBLE,
  "semi_major_axis_error_max" DOUBLE,
  "eccentricity" DOUBLE,
  "eccentricity_error_min" DOUBLE,
  "eccentricity_error_max" DOUBLE,
  "inclination" DOUBLE,
  "inclination_error_min" DOUBLE,
  "inclination_error_max" DOUBLE,
  "angular_distance" DOUBLE,
  "discovered" DOUBLE,
  "updated" TIMESTAMP,
  "omega" DOUBLE,
  "omega_error_min" DOUBLE,
  "omega_error_max" DOUBLE,
  "tperi" DOUBLE,
  "tperi_error_min" DOUBLE,
  "tperi_error_max" DOUBLE,
  "tconj" DOUBLE,
  "tconj_error_min" DOUBLE,
  "tconj_error_max" DOUBLE,
  "tzero_tr" DOUBLE,
  "tzero_tr_error_min" DOUBLE,
  "tzero_tr_error_max" DOUBLE,
  "tzero_tr_sec" DOUBLE,
  "tzero_tr_sec_error_min" DOUBLE,
  "tzero_tr_sec_error_max" DOUBLE,
  "lambda_angle" DOUBLE,
  "lambda_angle_error_min" DOUBLE,
  "lambda_angle_error_max" DOUBLE,
  "impact_parameter" DOUBLE,
  "impact_parameter_error_min" DOUBLE,
  "impact_parameter_error_max" DOUBLE,
  "tzero_vr" DOUBLE,
  "tzero_vr_error_min" DOUBLE,
  "tzero_vr_error_max" DOUBLE,
  "k" DOUBLE,
  "k_error_min" DOUBLE,
  "k_error_max" DOUBLE,
  "temp_calculated" DOUBLE,
  "temp_calculated_error_min" DOUBLE,
  "temp_calculated_error_max" DOUBLE,
  "temp_measured" DOUBLE,
  "hot_point_lon" DOUBLE,
  "geometric_albedo" DOUBLE,
  "geometric_albedo_error_min" DOUBLE,
  "geometric_albedo_error_max" DOUBLE,
  "log_g" DOUBLE,
  "publication" VARCHAR,
  "detection_type" VARCHAR,
  "mass_detection_type" VARCHAR,
  "radius_detection_type" VARCHAR,
  "alternate_names" VARCHAR,
  "molecules" VARCHAR,
  "star_name" VARCHAR,
  "ra" DOUBLE,
  "dec" DOUBLE,
  "mag_v" DOUBLE,
  "mag_i" DOUBLE,
  "mag_j" DOUBLE,
  "mag_h" DOUBLE,
  "mag_k" DOUBLE,
  "star_distance" DOUBLE,
  "star_distance_error_min" DOUBLE,
  "star_distance_error_max" DOUBLE,
  "star_metallicity" DOUBLE,
  "star_metallicity_error_min" DOUBLE,
  "star_metallicity_error_max" DOUBLE,
  "star_mass" DOUBLE,
  "star_mass_error_min" DOUBLE,
  "star_mass_error_max" DOUBLE,
  "star_radius" DOUBLE,
  "star_radius_error_min" DOUBLE,
  "star_radius_error_max" DOUBLE,
  "star_sp_type" VARCHAR,
  "star_age" DOUBLE,
  "star_age_error_min" DOUBLE,
  "star_age_error_max" DOUBLE,
  "star_teff" DOUBLE,
  "star_teff_error_min" DOUBLE,
  "star_teff_error_max" DOUBLE,
  "star_detected_disc" VARCHAR,
  "star_magnetic_field" VARCHAR,
  "star_alternate_names" VARCHAR
);