NASA Exoplanet Archive

Exoplanets specifies Confirmed Planets.

@kaggle.santoshd3_nasa_exoplanet_archive

Table List

1 table(598.89 KB)

Planets List

@kaggle.santoshd3_nasa_exoplanet_archive.planets_list

598.89 KB
4367 rows
82 columns

pl_hostname Pl Hostname	pl_letter Pl Letter	pl_name Pl Name	pl_discmethod Pl Discmethod	pl_pnum Pl Pnum	pl_orbper Pl Orbper	pl_orbpererr1 Pl Orbpererr1	pl_orbpererr2 Pl Orbpererr2	pl_orbpern Pl Orbpern	pl_orbsmax Pl Orbsmax	pl_orbsmaxerr1 Pl Orbsmaxerr1	pl_orbsmaxerr2 Pl Orbsmaxerr2	pl_orbsmaxn Pl Orbsmaxn	pl_orbeccen Pl Orbeccen	pl_orbeccenerr1 Pl Orbeccenerr1	pl_orbeccenerr2 Pl Orbeccenerr2	pl_orbeccenn Pl Orbeccenn	pl_bmassj Pl Bmassj	pl_bmassjerr1 Pl Bmassjerr1	pl_bmassjerr2 Pl Bmassjerr2	pl_bmassn Pl Bmassn	pl_bmassprov Pl Bmassprov	ra_str Ra Str	dec_str Dec Str	ra Ra	st_raerr St Raerr	dec Dec	st_decerr St Decerr	st_posn St Posn	st_dist St Dist	st_disterr1 St Disterr1	st_disterr2 St Disterr2	st_distn St Distn	st_optmag St Optmag	st_optmagerr St Optmagerr	st_optband St Optband	gaia_gmag Gaia Gmag	st_teff St Teff	st_tefferr1 St Tefferr1	st_tefferr2 St Tefferr2	st_teffn St Teffn	st_mass St Mass	st_masserr1 St Masserr1	st_masserr2 St Masserr2	st_massn St Massn	st_rad St Rad	st_raderr1 St Raderr1	st_raderr2 St Raderr2	st_radn St Radn	rowupdate Rowupdate	pl_facility Pl Facility
HD 180314	b	HD 180314 b	Radial Velocity	1	396.03	0.62	-0.62	2	1.46	0.06	-0.06	3	0.26	0.01	-0.01	2	20.13	1.66	-1.66	3	Msini	19h14m50.21s	+31d51m37.3s	288.709198	0.000001	31.86035	0.000001	2	122.79	0.45	-0.45	2	6.608	0.01	V (Johnson)	6.342	4924	25	-25	4	2.2	0.27	-0.27	4	8.13	0.3	-0.3	4	Thu Sep 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Subaru Telescope
HD 180902	b	HD 180902 b	Radial Velocity	1	510.9	1.5	-1.5	3	1.4	0.11	-0.11	3	0.107	0.022	-0.022	3	1.685	0.041	-0.041	3	Msini	19h19m17.71s	-23d33m29.4s	289.823792	0.000002	-23.558155	0.000002	2	104.89	0.57	-0.57	2	7.78		V (Johnson)	7.521	4961			6	1.41			5	4.16			5	Thu Dec 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	W. M. Keck Observatory
HD 181342	b	HD 181342 b	Radial Velocity	1	564.1	4.1	-4.1	4	1.592	0.091	-0.091	4	0.022	0.051	-0.051	4	2.54	0.19	-0.19	4	Msini	19h21m04.23s	-23d37m10.5s	290.267639	0.000002	-23.619572	0.000001	3	120.81	0.69	-0.69	4	7.55		V (Johnson)	7.284	4945			7	1.69			6	4.71			6	Thu Dec 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	W. M. Keck Observatory
HD 181433	b	HD 181433 b	Radial Velocity	3	9.3743	0.0019	-0.0019	3	0.08			3	0.4	0.06	-0.06	3	0.02			3	Msini	19h25m09.57s	-66d28m07.7s	291.289856	0.000002	-66.468796	0.000002	3	26.9	0.02	-0.02	5	8.4		V (Johnson)	8.092	4918	15	-15	6	0.63	0.07	-0.07	5	0.79	0.01	-0.01	4	Thu Sep 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	La Silla Observatory
HD 181433	c	HD 181433 c	Radial Velocity	3	962	15	-15	2	1.76			2	0.28	0.02	-0.02	2	0.64			2	Msini	19h25m09.57s	-66d28m07.7s	291.289856	0.000002	-66.468796	0.000002	3	26.9	0.02	-0.02	5	8.4		V (Johnson)	8.092	4918	15	-15	6	0.63	0.07	-0.07	5	0.79	0.01	-0.01	4	Wed Jul 23 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	La Silla Observatory
HD 181433	d	HD 181433 d	Radial Velocity	3	2172	158	-158	2	3			2	0.48	0.05	-0.05	2	0.54			2	Msini	19h25m09.57s	-66d28m07.7s	291.289856	0.000002	-66.468796	0.000002	3	26.9	0.02	-0.02	5	8.4		V (Johnson)	8.092	4918	15	-15	6	0.63	0.07	-0.07	5	0.79	0.01	-0.01	4	Wed Jul 23 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	La Silla Observatory
HD 181720	b	HD 181720 b	Radial Velocity	1	956	14	-14	2	1.85	0.04	-0.04	2	0.26	0.06	-0.06	2	0.4	0.06	-0.06	2	Msini	19h22m52.98s	-32d55m08.6s	290.720764	0.000004	-32.919056	0.000002	2	60.31	0.24	-0.24	4	7.849	0.013	V (Johnson)	7.675	5736	37	-37	3	1.03	0.2	-0.2	2	1.5	0.07	-0.07	3	Thu Sep 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	La Silla Observatory
HD 183263	b	HD 183263 b	Radial Velocity	2	626.51599	1.1	-1.1	5	1.49	0.02	-0.02	5	0.36	0.01	-0.01	5	3.95	0.22	-0.22	5	Msini	19h28m24.57s	+08d21m29.0s	292.102386	0.000003	8.358054	0.000002	2	54.28	0.11	-0.11	3	7.861	0.012	V (Johnson)	7.718	5948	27	-27	5	1.31	0.07	-0.07	5	1.23	0.02	-0.02	4	Thu Sep 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	W. M. Keck Observatory
HD 212301	b	HD 212301 b	Radial Velocity	1	2.24571	0.00028	-0.00028	2	0.03			2				2	0.51	0.04	-0.04	2	Msini	22h27m30.92s	-77d43m04.5s	336.878845	0.000002	-77.717926	0.000002	2	54.32	0.09	-0.09	2	7.764	0.011	V (Johnson)	7.635	6239	24	-24	5	1.55	0.16	-0.16	4	1.16	0.02	-0.02	3	Thu Sep 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	La Silla Observatory
HD 213240	b	HD 213240 b	Radial Velocity	1	882.70001	7.6	-7.6	2	1.89	0.03	-0.03	2	0.42	0.01	-0.01	2	5.58	0.31	-0.31	2	Msini	22h31m00.37s	-49d25m59.8s	337.751526	0.000002	-49.43327	0.000001	2	40.92	0.06	-0.06	2	6.814	0.01	V (Johnson)	6.658	5979	19	-19	8	1.57	0.12	-0.12	6	1.51	0.02	-0.02	3	Thu Sep 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	La Silla Observatory


CREATE TABLE planets_list (
  "pl_hostname" VARCHAR,
  "pl_letter" VARCHAR,
  "pl_name" VARCHAR,
  "pl_discmethod" VARCHAR,
  "pl_controvflag" BIGINT,
  "pl_pnum" BIGINT,
  "pl_orbper" DOUBLE,
  "pl_orbpererr1" DOUBLE,
  "pl_orbpererr2" DOUBLE,
  "pl_orbperlim" DOUBLE,
  "pl_orbpern" BIGINT,
  "pl_orbsmax" DOUBLE,
  "pl_orbsmaxerr1" DOUBLE,
  "pl_orbsmaxerr2" DOUBLE,
  "pl_orbsmaxlim" DOUBLE,
  "pl_orbsmaxn" BIGINT,
  "pl_orbeccen" DOUBLE,
  "pl_orbeccenerr1" DOUBLE,
  "pl_orbeccenerr2" DOUBLE,
  "pl_orbeccenlim" DOUBLE,
  "pl_orbeccenn" BIGINT,
  "pl_orbincl" DOUBLE,
  "pl_orbinclerr1" DOUBLE,
  "pl_orbinclerr2" DOUBLE,
  "pl_orbincllim" DOUBLE,
  "pl_orbincln" BIGINT,
  "pl_bmassj" DOUBLE,
  "pl_bmassjerr1" DOUBLE,
  "pl_bmassjerr2" DOUBLE,
  "pl_bmassjlim" DOUBLE,
  "pl_bmassn" BIGINT,
  "pl_bmassprov" VARCHAR,
  "pl_radj" DOUBLE,
  "pl_radjerr1" DOUBLE,
  "pl_radjerr2" DOUBLE,
  "pl_radjlim" DOUBLE,
  "pl_radn" BIGINT,
  "pl_dens" DOUBLE,
  "pl_denserr1" DOUBLE,
  "pl_denserr2" DOUBLE,
  "pl_denslim" DOUBLE,
  "pl_densn" BIGINT,
  "pl_ttvflag" BIGINT,
  "pl_kepflag" BIGINT,
  "pl_k2flag" BIGINT,
  "ra_str" VARCHAR,
  "dec_str" VARCHAR,
  "ra" DOUBLE,
  "st_raerr" DOUBLE,
  "dec" DOUBLE,
  "st_decerr" DOUBLE,
  "st_posn" BIGINT,
  "st_dist" DOUBLE,
  "st_disterr1" DOUBLE,
  "st_disterr2" DOUBLE,
  "st_distlim" DOUBLE,
  "st_distn" BIGINT,
  "st_optmag" DOUBLE,
  "st_optmagerr" DOUBLE,
  "st_optmaglim" DOUBLE,
  "st_optband" VARCHAR,
  "gaia_gmag" DOUBLE,
  "gaia_gmagerr" VARCHAR,
  "gaia_gmaglim" DOUBLE,
  "st_teff" DOUBLE,
  "st_tefferr1" DOUBLE,
  "st_tefferr2" DOUBLE,
  "st_tefflim" DOUBLE,
  "st_teffn" BIGINT,
  "st_mass" DOUBLE,
  "st_masserr1" DOUBLE,
  "st_masserr2" DOUBLE,
  "st_masslim" DOUBLE,
  "st_massn" BIGINT,
  "st_rad" DOUBLE,
  "st_raderr1" DOUBLE,
  "st_raderr2" DOUBLE,
  "st_radlim" DOUBLE,
  "st_radn" BIGINT,
  "pl_nnotes" BIGINT,
  "rowupdate" TIMESTAMP,
  "pl_facility" VARCHAR
);