NASA's Confirmed Exoplanets: Regular Updated

Regularly updated exoplanet data with comprehensive column details.

@kaggle.jameskychoi_confirmed_exoplanet_latest_update_dataset

Table List

1 table(2.53 MB)

Confirmed Exoplanents 2024 December

Confirmed Exoplanents 2024 December

@kaggle.jameskychoi_confirmed_exoplanet_latest_update_dataset.confirmed_exoplanents_2024_december

2.53 MB
5788 rows
210 columns
Only the first 100 columns are shown

planet_name Planet Name	host_star_name Host Star Name	planet_letter Planet Letter	hd_id Hd Id	hip_id Hip Id	tic_id Tic Id	gaia_id Gaia Id	num_stars_in_system Num Stars In System	num_planets_in_system Num Planets In System	discovery_method Discovery Method	discovery_year Discovery Year	discovery_publication_date Discovery Publication Date	discovery_locale Discovery Locale	discovery_facility Discovery Facility	discovery_telescope Discovery Telescope	discovery_instrument Discovery Instrument	detected_by_radial_velocity Detected By Radial Velocity	detected_by_transit Detected By Transit	orbital_period_days Orbital Period Days	orbital_period_upper_unc_days Orbital Period Upper Unc Days	orbital_period_lower_unc_days Orbital Period Lower Unc Days	orbit_semi_major_axis_au Orbit Semi Major Axis Au	orbit_semi_major_axis_upper_unc_au Orbit Semi Major Axis Upper Unc Au	orbit_semi_major_axis_lower_unc_au Orbit Semi Major Axis Lower Unc Au	angular_separation_mas Angular Separation Mas	planet_radius_earth_radius Planet Radius Earth Radius	planet_radius_upper_unc_earth_radius Planet Radius Upper Unc Earth Radius	planet_radius_lower_unc_earth_radius Planet Radius Lower Unc Earth Radius	planet_radius_jupiter_radius Planet Radius Jupiter Radius	planet_radius_upper_unc_jupiter_radius Planet Radius Upper Unc Jupiter Radius	planet_radius_lower_unc_jupiter_radius Planet Radius Lower Unc Jupiter Radius	planet_mass_earth_mass Planet Mass Earth Mass	planet_mass_upper_unc_earth_mass Planet Mass Upper Unc Earth Mass	planet_mass_lower_unc_earth_mass Planet Mass Lower Unc Earth Mass	planet_mass_jupiter_mass Planet Mass Jupiter Mass	planet_mass_upper_unc_jupiter_mass Planet Mass Upper Unc Jupiter Mass	planet_mass_lower_unc_jupiter_mass Planet Mass Lower Unc Jupiter Mass	planet_mass_provenance Planet Mass Provenance	planet_density_gcm3 Planet Density Gcm3	planet_density_upper_unc_gcm3 Planet Density Upper Unc Gcm3	planet_density_lower_unc_gcm3 Planet Density Lower Unc Gcm3	eccentricity Eccentricity	eccentricity_upper_unc Eccentricity Upper Unc	eccentricity_lower_unc Eccentricity Lower Unc	insolation_flux_earth_flux Insolation Flux Earth Flux	insolation_flux_upper_unc_earth_flux Insolation Flux Upper Unc Earth Flux	insolation_flux_lower_unc_earth_flux Insolation Flux Lower Unc Earth Flux	equilibrium_temperature_k Equilibrium Temperature K	equilibrium_temperature_upper_unc_k Equilibrium Temperature Upper Unc K	equilibrium_temperature_lower_unc_k Equilibrium Temperature Lower Unc K	inclination_deg Inclination Deg	inclination_upper_unc_deg Inclination Upper Unc Deg	inclination_lower_unc_deg Inclination Lower Unc Deg	transit_midpoint_days Transit Midpoint Days	transit_midpoint_upper_unc_days Transit Midpoint Upper Unc Days	transit_midpoint_lower_unc_days Transit Midpoint Lower Unc Days	transit_midpoint_time_system Transit Midpoint Time System	impact_parameter Impact Parameter	impact_parameter_upper_unc Impact Parameter Upper Unc	impact_parameter_lower_unc Impact Parameter Lower Unc	transit_depth_percent Transit Depth Percent	transit_depth_upper_unc_percent Transit Depth Upper Unc Percent	transit_depth_lower_unc_percent Transit Depth Lower Unc Percent	transit_duration_hours Transit Duration Hours	transit_duration_upper_unc_hours Transit Duration Upper Unc Hours	transit_duration_lower_unc_hours Transit Duration Lower Unc Hours	ratio_semi_major_axis_to_stellar_radius Ratio Semi Major Axis To Stellar Radius	ratio_semi_major_axis_to_stellar_radius_upper_unc Ratio Semi Major Axis To Stellar Radius Upper Unc	ratio_semi_major_axis_to_stellar_radius_lower_unc Ratio Semi Major Axis To Stellar Radius Lower Unc
Wolf 1061 c	Wolf 1061	c	nan	HIP 80824	TIC 413948621	Gaia DR2 4330690742322011520	1	3	Radial Velocity	2015	2016-02	Ground	La Silla Observatory	3.6 m ESO Telescope	HARPS Spectrograph	1		17.8719	0.0059	-0.0059	0.089	0.0029	-0.0031	20.7	1.66			0.148			3.41	0.43	-0.41	0.01073	0.00135	-0.00129	Msini	4.1			0.11	0.1	-0.07	1.3												nan
Wolf 1061 d	Wolf 1061	d	nan	HIP 80824	TIC 413948621	Gaia DR2 4330690742322011520	1	3	Radial Velocity	2015	2016-02	Ground	La Silla Observatory	3.6 m ESO Telescope	HARPS Spectrograph	1		217.21	0.55	-0.52	0.47	0.015	-0.017	109	2.69			0.24			7.7	1.12	-1.06	0.02423	0.00352	-0.00334	Msini	2.17			0.55	0.08	-0.09	0.06												nan
Wolf 1069 b	Wolf 1069	b	nan	nan	TIC 352617553	Gaia DR2 2188318517720321664	1	1	Radial Velocity	2023	2023-02	Ground	Calar Alto Observatory	3.5 m telescope	CARMENES	1		15.564	0.015	-0.015	0.0672	0.0014	-0.0014	7.01	1.08			0.096			1.26	0.21	-0.21	0.00396	0.00066	-0.00066	Msini	5.5						0.65	0.03	-0.03	250	7	-6							BJD
Wolf 327 b	Wolf 327	b	nan	nan	TIC 4918918	Gaia DR2 796185407950360192	1	1	Transit	2024	2024-01	Space	Transiting Exoplanet Survey Satellite (TESS)	0.1 m TESS Telescope	TESS CCD Array	1	1	0.5734745	3e-7	-3e-7	0.01	0.0004	-0.0004	0.35	1.24	0.06	-0.06	0.111	0.005	-0.005	2.53	0.46	-0.46	0.00796	0.00145	-0.00145	Mass	7.24	1.66	-1.66				233.9	18.3	-18.3	996	22	-22	84.89	0.41	-0.38	2459252.981	0.0003	-0.0003	BJD	0.47	0.03	-0.03	0.081839	0.008899	-0.008899	0.9004508	0.1023305	-0.1023305	5.3	0.06	-0.06
Wolf 503 b	Wolf 503	b	nan	HIP 67285	TIC 187278212	Gaia DR2 3620325206217720320	1	1	Transit	2018	2018-11	Space	K2	0.95 m Kepler Telescope	Kepler CCD Array	1	1	6.00127	0.000021	-0.000021	0.05712	0.00063	-0.00045	1.28	2.043	0.069	-0.069	0.182	0.006	-0.006	6.27	0.85	-0.84	0.01973	0.00267	-0.00264	Mass	4.03	0.72	-0.64	0.409	0.085	-0.085	64.7	5.5	-5.5	789	16	-16	89.87	0.13	-0.13	2458191.361	0.00011	-0.00011	BJD-TDB	0.65	0.06	-0.06				1.321	0.051	-0.039
XO-1 b	XO-1	b	nan	nan	TIC 236312126	Gaia DR2 1316708918505350528	1	1	Transit	2006	2006-09	Ground	XO	Canon 200mm f/1.8L	Apogee CCD Array	1	1	3.94153	0.000027	-0.000027	0.0488	0.0005	-0.0005	0.298	12.778	0.785	-0.785	1.14	0.07	-0.07	263.7989	41.3179	-41.3179	0.83	0.13	-0.13	Mass	0.64	0.05	-0.05				321.85			1210	16	-16	88.81	0.5	-0.5	2455385.52	0.00005	-0.00005	BJD-TDB	0.24	0.045	-0.14	1.8	0.012	-0.012	2.9712	0.0072	-0.0072	11.37	0.47	-0.47
XO-2 N b	XO-2 N	b	nan	nan	TIC 356473034	Gaia DR2 934346809278715776	2	3	Transit	2007	2007-12	Ground	XO	Canon 200mm f/1.8L	Apogee CCD Array	1	1	2.61586178			0.0368			0.239	11.131	0.135	-0.135	0.993	0.012	-0.012	179.89178	7.94575	-7.94575	0.566	0.025	-0.025	Mass	0.715	0.041	-0.04	0.028	0.038	-0.022	428.04			1328	17	-28	88.01	0.33	-0.28	2454508.738	0.00014	-0.00016	HJD	0.28	0.036	-0.044	1.3363	0.013592	-0.013592	2.6839	0.0066	-0.0077
XO-2 S b	XO-2 S	b	nan	nan	TIC 356473029	Gaia DR2 934346740559239296	2	3	Radial Velocity	2014	2014-07	Ground	Roque de los Muchachos Observatory	3.58 m Telescopio Nazionale Galileo	HARPS-N Spectrograph	1		18.157	0.034	-0.034	0.13			0.859	10.9			0.971			82.6358	12.7132	-12.7132	0.26	0.04	-0.04	Msini	0.351			0.18	0.04	-0.04													nan
11 Com b	11 Com	b	HD 107383	HIP 60202	TIC 72437047	Gaia DR2 3946945413106333696	2	1	Radial Velocity	2007	2008-01	Ground	Xinglong Station	2.16 m Telescope	Coude Echelle Spectrograph	1		323.21	0.06	-0.05	1.178			12.6	12.2			1.09			4914.89849	39.09289	-39.72855	15.464	0.123	-0.125	Msini	14.9			0.238	0.007	-0.007													JD
11 UMi b	11 UMi	b	HD 136726	HIP 74793	TIC 230061010	Gaia DR2 1696798367260229376	1	1	Radial Velocity	2009	2009-10	Ground	Thueringer Landessternwarte Tautenburg	2.0 m Alfred Jensch Telescope	Coude Echelle Spectrograph	1		516.21997	3.2	-3.2	1.53	0.07	-0.07	12.2	12.3			1.09			4684.8142	794.575	-794.575	14.74	2.5	-2.5	Msini	13.8			0.08	0.03	-0.03													nan


CREATE TABLE confirmed_exoplanents_2024_december (
  "planet_name" VARCHAR,
  "host_star_name" VARCHAR,
  "planet_letter" VARCHAR,
  "hd_id" VARCHAR,
  "hip_id" VARCHAR,
  "tic_id" VARCHAR,
  "gaia_id" VARCHAR,
  "num_stars_in_system" BIGINT,
  "num_planets_in_system" BIGINT,
  "num_moons_in_system" BIGINT,
  "is_circumbinary" BIGINT,
  "discovery_method" VARCHAR,
  "discovery_year" BIGINT,
  "discovery_publication_date" VARCHAR,
  "discovery_locale" VARCHAR,
  "discovery_facility" VARCHAR,
  "discovery_telescope" VARCHAR,
  "discovery_instrument" VARCHAR,
  "detected_by_radial_velocity" BIGINT,
  "detected_by_pulsar_timing" BIGINT,
  "detected_by_pulsation_timing_variations" BIGINT,
  "detected_by_transit" BIGINT,
  "detected_by_astrometry" BIGINT,
  "detected_by_orbital_brightness_modulation" BIGINT,
  "detected_by_microlensing" BIGINT,
  "detected_by_eclipse_timing_variations" BIGINT,
  "detected_by_imaging" BIGINT,
  "detected_by_disk_kinematics" BIGINT,
  "is_controversial" BIGINT,
  "orbital_period_days" DOUBLE,
  "orbital_period_upper_unc_days" DOUBLE,
  "orbital_period_lower_unc_days" DOUBLE,
  "orbital_period_limit_flag" DOUBLE,
  "orbit_semi_major_axis_au" DOUBLE,
  "orbit_semi_major_axis_upper_unc_au" DOUBLE,
  "orbit_semi_major_axis_lower_unc_au" DOUBLE,
  "orbit_semi_major_axis_limit_flag" DOUBLE,
  "angular_separation_mas" DOUBLE,
  "angular_separation_upper_unc_mas" VARCHAR,
  "angular_separation_lower_unc_mas" VARCHAR,
  "angular_separation_limit_flag" DOUBLE,
  "planet_radius_earth_radius" DOUBLE,
  "planet_radius_upper_unc_earth_radius" DOUBLE,
  "planet_radius_lower_unc_earth_radius" DOUBLE,
  "planet_radius_earth_limit_flag" DOUBLE,
  "planet_radius_jupiter_radius" DOUBLE,
  "planet_radius_upper_unc_jupiter_radius" DOUBLE,
  "planet_radius_lower_unc_jupiter_radius" DOUBLE,
  "planet_radius_jupiter_limit_flag" DOUBLE,
  "planet_mass_earth_mass" DOUBLE,
  "planet_mass_upper_unc_earth_mass" DOUBLE,
  "planet_mass_lower_unc_earth_mass" DOUBLE,
  "planet_mass_earth_limit_flag" DOUBLE,
  "planet_mass_jupiter_mass" DOUBLE,
  "planet_mass_upper_unc_jupiter_mass" DOUBLE,
  "planet_mass_lower_unc_jupiter_mass" DOUBLE,
  "planet_mass_jupiter_limit_flag" DOUBLE,
  "planet_mass_provenance" VARCHAR,
  "planet_density_gcm3" DOUBLE,
  "planet_density_upper_unc_gcm3" DOUBLE,
  "planet_density_lower_unc_gcm3" DOUBLE,
  "planet_density_limit_flag" DOUBLE,
  "eccentricity" DOUBLE,
  "eccentricity_upper_unc" DOUBLE,
  "eccentricity_lower_unc" DOUBLE,
  "eccentricity_limit_flag" DOUBLE,
  "insolation_flux_earth_flux" DOUBLE,
  "insolation_flux_upper_unc_earth_flux" DOUBLE,
  "insolation_flux_lower_unc_earth_flux" DOUBLE,
  "insolation_flux_limit_flag" DOUBLE,
  "equilibrium_temperature_k" DOUBLE,
  "equilibrium_temperature_upper_unc_k" DOUBLE,
  "equilibrium_temperature_lower_unc_k" DOUBLE,
  "equilibrium_temperature_limit_flag" DOUBLE,
  "inclination_deg" DOUBLE,
  "inclination_upper_unc_deg" DOUBLE,
  "inclination_lower_unc_deg" DOUBLE,
  "inclination_limit_flag" DOUBLE,
  "transit_midpoint_days" DOUBLE,
  "transit_midpoint_upper_unc_days" DOUBLE,
  "transit_midpoint_lower_unc_days" DOUBLE,
  "transit_midpoint_limit_flag" DOUBLE,
  "transit_midpoint_time_system" VARCHAR,
  "data_show_transit_timing_variations" BIGINT,
  "impact_parameter" DOUBLE,
  "impact_parameter_upper_unc" DOUBLE,
  "impact_parameter_lower_unc" DOUBLE,
  "impact_parameter_limit_flag" DOUBLE,
  "transit_depth_percent" DOUBLE,
  "transit_depth_upper_unc_percent" DOUBLE,
  "transit_depth_lower_unc_percent" DOUBLE,
  "transit_depth_limit_flag" DOUBLE,
  "transit_duration_hours" DOUBLE,
  "transit_duration_upper_unc_hours" DOUBLE,
  "transit_duration_lower_unc_hours" DOUBLE,
  "transit_duration_limit_flag" DOUBLE,
  "ratio_semi_major_axis_to_stellar_radius" DOUBLE,
  "ratio_semi_major_axis_to_stellar_radius_upper_unc" DOUBLE,
  "ratio_semi_major_axis_to_stellar_radius_lower_unc" DOUBLE,
  "ratio_semi_major_axis_to_stellar_radius_limit_flag" DOUBLE
);