NASA Exo-Planetary System

Data on discovered exo-planetary system taken from NASA

@kaggle.sathyanarayanrao89_nasa_exoplanetary_system

Table List

1 table(2.64 MB)

Exoplanets

@kaggle.sathyanarayanrao89_nasa_exoplanetary_system.exoplanets

2.64 MB
32552 rows
93 columns

unnamed_0 Unnamed: 0	pl_name Pl Name	hostname Hostname	default_flag Default Flag	sy_snum Sy Snum	sy_pnum Sy Pnum	discoverymethod Discoverymethod	disc_year Disc Year	disc_facility Disc Facility	soltype Soltype	pl_refname Pl Refname	pl_orbper Pl Orbper	pl_orbpererr1 Pl Orbpererr1	pl_orbpererr2 Pl Orbpererr2	pl_orbsmax Pl Orbsmax	pl_orbsmaxerr1 Pl Orbsmaxerr1	pl_orbsmaxerr2 Pl Orbsmaxerr2	pl_bmasse Pl Bmasse	pl_bmasseerr1 Pl Bmasseerr1	pl_bmasseerr2 Pl Bmasseerr2	pl_bmassj Pl Bmassj	pl_bmassjerr1 Pl Bmassjerr1	pl_bmassjerr2 Pl Bmassjerr2	pl_bmassprov Pl Bmassprov	pl_orbeccen Pl Orbeccen	pl_orbeccenerr1 Pl Orbeccenerr1	pl_orbeccenerr2 Pl Orbeccenerr2	st_refname St Refname	st_spectype St Spectype	st_teff St Teff	st_tefferr1 St Tefferr1	st_tefferr2 St Tefferr2	st_rad St Rad	st_raderr1 St Raderr1	st_raderr2 St Raderr2	st_mass St Mass	st_masserr1 St Masserr1	st_masserr2 St Masserr2	st_met St Met	st_meterr1 St Meterr1	st_meterr2 St Meterr2	st_metratio St Metratio	st_logg St Logg	st_loggerr1 St Loggerr1	st_loggerr2 St Loggerr2	sy_refname Sy Refname	rastr Rastr	ra Ra	decstr Decstr	dec Dec	sy_dist Sy Dist	sy_disterr1 Sy Disterr1	sy_disterr2 Sy Disterr2	sy_vmag Sy Vmag	sy_vmagerr1 Sy Vmagerr1	sy_vmagerr2 Sy Vmagerr2	sy_kmag Sy Kmag	sy_kmagerr1 Sy Kmagerr1	sy_kmagerr2 Sy Kmagerr2	sy_gaiamag Sy Gaiamag	sy_gaiamagerr1 Sy Gaiamagerr1	sy_gaiamagerr2 Sy Gaiamagerr2	rowupdate Rowupdate	pl_pubdate Pl Pubdate	releasedate Releasedate
	11 Com b	11 Com	1	2	1	Radial Velocity	2007	Xinglong Station	Published Confirmed	<a refstr=LIU_ET_AL__2008 href=https://ui.adsabs.harvard.edu/abs/2008ApJ...672..553L/abstract target=ref> Liu et al. 2008 </a>	326.03	0.32	-0.32	1.29	0.05	-0.05	6165.6	476.7	-476.7	19.4	1.5	-1.5	Msini	0.231	0.005	-0.005	<a refstr=LIU_ET_AL__2008 href=https://ui.adsabs.harvard.edu/abs/2008ApJ...672..553L/abstract target=ref> Liu et al. 2008 </a>	G8 III	4742	100	-100	19	2	-2	2.7	0.3	-0.3	-0.35	0.09	-0.09	[Fe/H]	2.31	0.1	-0.1	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	12h20m42.91s	185.1787793	+17d47m35.71s	17.7932516	93.1846	1.9238	-1.9238	4.72307	0.023	-0.023	2.282	0.346	-0.346	4.44038	0.0038479	-0.0038479	Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2008-01	2014-05-14
1	11 Com b	11 Com		2	1	Radial Velocity	2007	Xinglong Station	Published Confirmed	<a refstr=KUNITOMO_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011ApJ...737...66K/abstract target=ref> Kunitomo et al. 2011</a>				1.21	0.06	-0.05	5434.7	540.3	-413.2	17.1	1.7	-1.3	Msini				<a refstr=KUNITOMO_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011ApJ...737...66K/abstract target=ref> Kunitomo et al. 2011</a>	nan							2.6	0.4	-0.3				nan				<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	12h20m42.91s	185.1787793	+17d47m35.71s	17.7932516	93.1846	1.9238	-1.9238	4.72307	0.023	-0.023	2.282	0.346	-0.346	4.44038	0.0038479	-0.0038479	Wed Jul 23 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2011-08	2014-07-23
2	11 UMi b	11 UMi		1	1	Radial Velocity	2009	Thueringer Landessternwarte Tautenburg	Published Confirmed	<a refstr=KUNITOMO_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011ApJ...737...66K/abstract target=ref> Kunitomo et al. 2011</a>				1.51	0.06	-0.05	3432.4	381.4	-413.2	10.8	1.2	-1.3	Msini				<a refstr=KUNITOMO_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011ApJ...737...66K/abstract target=ref> Kunitomo et al. 2011</a>	nan							1.7	0.4	-0.3				nan				<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	15h17m05.90s	229.2745954	+71d49m26.19s	71.8239428	125.321	1.9765	-1.9765	5.013	0.005	-0.005	1.939	0.27	-0.27	4.56216	0.0039035	-0.0039035	Wed Apr 25 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2011-08	2014-07-23
3	11 UMi b	11 UMi	1	1	1	Radial Velocity	2009	Thueringer Landessternwarte Tautenburg	Published Confirmed	<a refstr=STASSUN_ET_AL__2017 href=https://ui.adsabs.harvard.edu/abs/2017AJ....153..136S/abstract target=ref>Stassun et al. 2017</a>	516.21997	3.2	-3.2	1.53	0.07	-0.07	4684.8142	794.575	-794.575	14.74	2.5	-2.5	Msini	0.08	0.03	-0.03	<a refstr=STASSUN_ET_AL__2017 href=https://ui.adsabs.harvard.edu/abs/2017AJ....153..136S/abstract target=ref>Stassun et al. 2017</a>	nan	4213	46	-46	29.79	2.84	-2.84	2.78	0.69	-0.69	-0.02			[Fe/H]	1.93	0.07	-0.07	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	15h17m05.90s	229.2745954	+71d49m26.19s	71.8239428	125.321	1.9765	-1.9765	5.013	0.005	-0.005	1.939	0.27	-0.27	4.56216	0.0039035	-0.0039035	Tue Sep 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2017-03	2018-09-06
4	11 UMi b	11 UMi		1	1	Radial Velocity	2009	Thueringer Landessternwarte Tautenburg	Published Confirmed	<a refstr=DOLLINGER_ET_AL__2009 href=https://ui.adsabs.harvard.edu/abs/2009A&A...505.1311D/abstract target=ref> Dollinger et al. 2009 </a>	516.22	3.25	-3.25	1.54	0.07	-0.07	3337.07	785.01	-785.01	10.5	2.47	-2.47	Msini	0.08	0.03	-0.03	<a refstr=DOLLINGER_ET_AL__2009 href=https://ui.adsabs.harvard.edu/abs/2009A&A...505.1311D/abstract target=ref> Dollinger et al. 2009 </a>	K4 III	4340	70	-70	24.08	1.84	-1.84	1.8	0.25	-0.25	0.04	0.04	-0.04	[Fe/H]	1.6	0.15	-0.15	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	15h17m05.90s	229.2745954	+71d49m26.19s	71.8239428	125.321	1.9765	-1.9765	5.013	0.005	-0.005	1.939	0.27	-0.27	4.56216	0.0039035	-0.0039035	Wed Apr 25 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2009-10	2014-05-14
5	14 And b	14 And		1	1	Radial Velocity	2008	Okayama Astrophysical Observatory	Published Confirmed	<a refstr=KUNITOMO_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011ApJ...737...66K/abstract target=ref> Kunitomo et al. 2011</a>				0.68	0.03	-0.06	1017	127.1	-190.7	3.2	0.4	-0.6	Msini				<a refstr=KUNITOMO_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011ApJ...737...66K/abstract target=ref> Kunitomo et al. 2011</a>	nan							1.2	0.4	-0.3				nan				<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	23h31m17.80s	352.82415	+39d14m09.01s	39.2358367	75.4392	0.714	-0.714	5.23133	0.023	-0.023	2.331	0.24	-0.24	4.91781	0.0028262	-0.0028262	Wed Jul 23 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2011-08	2014-07-23
6	14 And b	14 And	1	1	1	Radial Velocity	2008	Okayama Astrophysical Observatory	Published Confirmed	<a refstr=SATO_ET_AL__2008 href=https://ui.adsabs.harvard.edu/abs/2008PASJ...60.1317S/abstract target=ref> Sato et al. 2008 </a>	185.84	0.23	-0.23	0.83			1525.5			4.8			Msini				<a refstr=SATO_ET_AL__2008 href=https://ui.adsabs.harvard.edu/abs/2008PASJ...60.1317S/abstract target=ref> Sato et al. 2008 </a>	K0 III	4813	20	-20	11	1	-1	2.2	0.1	-0.2	-0.24	0.03	-0.03	[Fe/H]	2.63	0.07	-0.07	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	23h31m17.80s	352.82415	+39d14m09.01s	39.2358367	75.4392	0.714	-0.714	5.23133	0.023	-0.023	2.331	0.24	-0.24	4.91781	0.0028262	-0.0028262	Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2008-12	2014-05-14
7	14 Her b	14 Her		1	2	Radial Velocity	2002	W. M. Keck Observatory	Published Confirmed	<a refstr=ROSENTHAL_ET_AL__2021 href=https://ui.adsabs.harvard.edu/abs/2021arXiv210511583R/abstract target=ref>Rosenthal et al. 2021</a>	1766.41	0.67	-0.68	2.83	0.041	-0.041	1541.46777	47.67426	-47.67426	4.85	0.15	-0.15	Msini	0.3674	0.0035	-0.0038	<a refstr=ROSENTHAL_ET_AL__2021 href=https://ui.adsabs.harvard.edu/abs/2021arXiv210511583R/abstract target=ref>Rosenthal et al. 2021</a>	nan	5314.94	81.56	-81.56	1	0.02	-0.02	0.97	0.04	-0.04	0.405	0.047	-0.047	[Fe/H]	4.43	0.03	-0.03	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	16h10m24.50s	242.6021014	+43d48m58.90s	43.8163621	17.9323	0.0073	-0.0073	6.61935	0.023	-0.023	4.714	0.016	-0.016	6.383	0.0003512	-0.0003512	Mon Sep 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021-05	2021-09-20
8	14 Her b	14 Her		1	2	Radial Velocity	2002	W. M. Keck Observatory	Published Confirmed	<a refstr=BUTLER_ET_AL__2003 href=https://ui.adsabs.harvard.edu/abs/2003ApJ...582..455B/abstract target=ref> Butler et al. 2003 </a>	1724	50	-50	2.82			1554.12			4.89			Msini	0.37	0.04	-0.04	<a refstr=BUTLER_ET_AL__2003 href=https://ui.adsabs.harvard.edu/abs/2003ApJ...582..455B/abstract target=ref> Butler et al. 2003 </a>	K0 V							1			0.35			[Fe/H]				<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	16h10m24.50s	242.6021014	+43d48m58.90s	43.8163621	17.9323	0.0073	-0.0073	6.61935	0.023	-0.023	4.714	0.016	-0.016	6.383	0.0003512	-0.0003512	Wed Apr 25 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2003-01	2014-08-21
9	14 Her b	14 Her		1	2	Radial Velocity	2002	W. M. Keck Observatory	Published Confirmed	<a refstr=GOZDZIEWSKI_ET_AL__2008 href=https://ui.adsabs.harvard.edu/abs/2008MNRAS.385..957G/abstract target=ref> Gozdziewski et al. 2008</a>	1766			2.864			1581.138			4.975			Msini	0.359			<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	nan	5280	163.21	-128.17	1	0.05	-0.08	0.91	0.14	-0.09	0.4	0.1	-0.1	[M/H]	4.4	0.09	-0.09	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	16h10m24.50s	242.6021014	+43d48m58.90s	43.8163621	17.9323	0.0073	-0.0073	6.61935	0.023	-0.023	4.714	0.016	-0.016	6.383	0.0003512	-0.0003512	Wed Apr 25 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2008-04	2014-08-21


CREATE TABLE exoplanets (
  "unnamed_0" BIGINT,
  "pl_name" VARCHAR,
  "hostname" VARCHAR,
  "default_flag" BIGINT,
  "sy_snum" BIGINT,
  "sy_pnum" BIGINT,
  "discoverymethod" VARCHAR,
  "disc_year" BIGINT,
  "disc_facility" VARCHAR,
  "soltype" VARCHAR,
  "pl_controv_flag" BIGINT,
  "pl_refname" VARCHAR,
  "pl_orbper" DOUBLE,
  "pl_orbpererr1" DOUBLE,
  "pl_orbpererr2" DOUBLE,
  "pl_orbperlim" DOUBLE,
  "pl_orbsmax" DOUBLE,
  "pl_orbsmaxerr1" DOUBLE,
  "pl_orbsmaxerr2" DOUBLE,
  "pl_orbsmaxlim" DOUBLE,
  "pl_rade" DOUBLE,
  "pl_radeerr1" DOUBLE,
  "pl_radeerr2" DOUBLE,
  "pl_radelim" DOUBLE,
  "pl_radj" DOUBLE,
  "pl_radjerr1" DOUBLE,
  "pl_radjerr2" DOUBLE,
  "pl_radjlim" DOUBLE,
  "pl_bmasse" DOUBLE,
  "pl_bmasseerr1" DOUBLE,
  "pl_bmasseerr2" DOUBLE,
  "pl_bmasselim" DOUBLE,
  "pl_bmassj" DOUBLE,
  "pl_bmassjerr1" DOUBLE,
  "pl_bmassjerr2" DOUBLE,
  "pl_bmassjlim" DOUBLE,
  "pl_bmassprov" VARCHAR,
  "pl_orbeccen" DOUBLE,
  "pl_orbeccenerr1" DOUBLE,
  "pl_orbeccenerr2" DOUBLE,
  "pl_orbeccenlim" DOUBLE,
  "pl_insol" DOUBLE,
  "pl_insolerr1" DOUBLE,
  "pl_insolerr2" DOUBLE,
  "pl_insollim" DOUBLE,
  "pl_eqt" DOUBLE,
  "pl_eqterr1" DOUBLE,
  "pl_eqterr2" DOUBLE,
  "pl_eqtlim" DOUBLE,
  "ttv_flag" BIGINT,
  "st_refname" VARCHAR,
  "st_spectype" VARCHAR,
  "st_teff" DOUBLE,
  "st_tefferr1" DOUBLE,
  "st_tefferr2" DOUBLE,
  "st_tefflim" DOUBLE,
  "st_rad" DOUBLE,
  "st_raderr1" DOUBLE,
  "st_raderr2" DOUBLE,
  "st_radlim" DOUBLE,
  "st_mass" DOUBLE,
  "st_masserr1" DOUBLE,
  "st_masserr2" DOUBLE,
  "st_masslim" DOUBLE,
  "st_met" DOUBLE,
  "st_meterr1" DOUBLE,
  "st_meterr2" DOUBLE,
  "st_metlim" DOUBLE,
  "st_metratio" VARCHAR,
  "st_logg" DOUBLE,
  "st_loggerr1" DOUBLE,
  "st_loggerr2" DOUBLE,
  "st_logglim" DOUBLE,
  "sy_refname" VARCHAR,
  "rastr" VARCHAR,
  "ra" DOUBLE,
  "decstr" VARCHAR,
  "dec" DOUBLE,
  "sy_dist" DOUBLE,
  "sy_disterr1" DOUBLE,
  "sy_disterr2" DOUBLE,
  "sy_vmag" DOUBLE,
  "sy_vmagerr1" DOUBLE,
  "sy_vmagerr2" DOUBLE,
  "sy_kmag" DOUBLE,
  "sy_kmagerr1" DOUBLE,
  "sy_kmagerr2" DOUBLE,
  "sy_gaiamag" DOUBLE,
  "sy_gaiamagerr1" DOUBLE,
  "sy_gaiamagerr2" DOUBLE,
  "rowupdate" TIMESTAMP,
  "pl_pubdate" VARCHAR,
  "releasedate" VARCHAR
);