NASA Exoplanet Archive (July 2023)

Properties of all the confirmed exoplanets and their host stars

@kaggle.vardanadibekyan_nasa_exoplanet_archive_july_2023

Table List

1 table(4.91 MB)

Nea Full

@kaggle.vardanadibekyan_nasa_exoplanet_archive_july_2023.nea_full

4.91 MB
5470 rows
353 columns
Only the first 100 columns are shown

pl_name Pl Name	pl_letter Pl Letter	hostname Hostname	hd_name Hd Name	hip_name Hip Name	tic_id Tic Id	gaia_id Gaia Id	default_flag Default Flag	pl_refname Pl Refname	sy_refname Sy Refname	disc_pubdate Disc Pubdate	disc_year Disc Year	discoverymethod Discoverymethod	disc_locale Disc Locale	disc_facility Disc Facility	disc_instrument Disc Instrument	disc_telescope Disc Telescope	disc_refname Disc Refname	ra Ra	rastr Rastr	dec Dec	decstr Decstr	glon Glon	glat Glat	elon Elon	elat Elat	pl_orbper Pl Orbper	pl_orbpererr1 Pl Orbpererr1	pl_orbpererr2 Pl Orbpererr2	pl_orbperstr Pl Orbperstr	pl_orblpererr1 Pl Orblpererr1	pl_orblper Pl Orblper	pl_orblpererr2 Pl Orblpererr2	pl_orblperstr Pl Orblperstr	pl_orbsmax Pl Orbsmax	pl_orbsmaxerr1 Pl Orbsmaxerr1	pl_orbsmaxerr2 Pl Orbsmaxerr2	pl_orbsmaxstr Pl Orbsmaxstr	pl_orbincl Pl Orbincl	pl_orbinclerr2 Pl Orbinclerr2	pl_orbinclstr Pl Orbinclstr	pl_orbtper Pl Orbtper	pl_orbtpererr1 Pl Orbtpererr1	pl_orbtpererr2 Pl Orbtpererr2	pl_orbtperstr Pl Orbtperstr	pl_orbeccen Pl Orbeccen	pl_orbeccenerr1 Pl Orbeccenerr1	pl_orbeccenerr2 Pl Orbeccenerr2	pl_orbeccenstr Pl Orbeccenstr	pl_eqtstr Pl Eqtstr	pl_occdepstr Pl Occdepstr	pl_insolstr Pl Insolstr	pl_dens Pl Dens	pl_denserr1 Pl Denserr1	pl_denserr2 Pl Denserr2	pl_densstr Pl Densstr	pl_trandep Pl Trandep	pl_trandeperr1 Pl Trandeperr1	pl_trandeperr2 Pl Trandeperr2	pl_trandepstr Pl Trandepstr	pl_tranmid Pl Tranmid	pl_tranmidstr Pl Tranmidstr	pl_trandur Pl Trandur	pl_trandurstr Pl Trandurstr	sy_kmagstr Sy Kmagstr	sy_umagstr Sy Umagstr	sy_rmagstr Sy Rmagstr
OGLE-TR-10 b	b	OGLE-TR-10	nan	nan	TIC 130150682	Gaia DR2 4056443366649948160	1	<a refstr=TORRES_ET_AL__2008 href=https://ui.adsabs.harvard.edu/abs/2008ApJ...677.1324T/abstract target=ref> Torres et al. 2008 </a>	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	2005-05	2004	Transit	Ground	OGLE	OGLE CCD Array	1.3 m Warsaw University Telescope	<a refstr=KONACKI_ET_AL__2005 href=https://ui.adsabs.harvard.edu/abs/2005ApJ...624..372K/abstract target=ref> Konacki et al. 2005 </a>	267.8677483	17h51m28.26s	-29.8764758	-29d52m35.31s	359.85149	-1.57666	268.13944	-6.45096	3.101278			3.101278				nan	0.0434	0.0013	-0.0015	<div><span class=supersubNumber">0.0434</span> <span class="superscript">+0.0013</span><span class="subscript">-0.0015</span></div>"	90	-3.9	<div><span class=supersubNumber">90.0</span> <span class="superscript">+0.0</span><span class="subscript">-3.9</span></div>"				nan				nan	nan	nan	nan	0.4	0.18	-0.12	<div><span class=supersubNumber">0.40</span> <span class="superscript">+0.18</span><span class="subscript">-0.12</span></div>"	1.21	0.044	-0.044	1.210±0.044		nan		nan	12.856	nan	nan
BD-08 2823 c	c	BD-08 2823	nan	HIP 49067	TIC 33355302	Gaia DR2 3770419611540574080	1	<a refstr=HEBRARD_ET_AL__2010 href=https://ui.adsabs.harvard.edu/abs/2010A%26A...512A..46H/abstract target=ref> Hébrard et al. 2010 </a>	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	2010-03	2009	Radial Velocity	Ground	La Silla Observatory	HARPS Spectrograph	3.6 m ESO Telescope	<a refstr=HEBRARD_ET_AL__2010 href=https://ui.adsabs.harvard.edu/abs/2010A%26A...512A..46H/abstract target=ref> Hébrard et al. 2010 </a>	150.1971964	10h00m47.33s	-9.5165689	-09d30m59.65s	248.49513	34.75486	155.83616	-20.28382	237.6	1.5	-1.5	237.6±1.5	21	-233	-21	-233±21	0.68	0.02	-0.02	0.68±0.02			nan	2454193	13	-13	2454193±13	0.19	0.09	-0.09	0.19±0.09	nan	nan	nan				nan				nan		nan		nan	7.323±0.021	nan	nan
HR 8799 c	c	HR 8799	HD 218396	HIP 114189	TIC 245368902	Gaia DR2 2832463659640297472	1	<a refstr=MAROIS_ET_AL__2008 href=https://ui.adsabs.harvard.edu/abs/2008Sci...322.1348M/abstract target=ref> Marois et al. 2008 </a>	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	2008-11	2008	Imaging	Ground	Gemini Observatory	NIRI Camera	8.19 m Gemini North Telescope	<a refstr=MAROIS_ET_AL__2008 href=https://ui.adsabs.harvard.edu/abs/2008Sci...322.1348M/abstract target=ref> Marois et al. 2008 </a>	346.8701486	23h07m28.84s	21.1340376	+21d08m02.54s	92.7646	-35.57552	356.78792	24.52435	69000			69000				nan	38			38			nan				nan				nan	nan	nan	nan				nan				nan		nan		nan	5.240±0.018	nan	nan
HD 110014 b	b	HD 110014	HD 110014	HIP 61740	TIC 32448045	Gaia DR2 3676091134604409728	1	<a refstr=DE_MEDEIROS_ET_AL__2009 href=https://ui.adsabs.harvard.edu/abs/2009A%26A...504..617D/abstract target=ref> de Medeiros et al. 2009 </a>	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	2009-09	2009	Radial Velocity	Ground	La Silla Observatory	FEROS Spectrograph	Multiple Telescopes	<a refstr=DE_MEDEIROS_ET_AL__2009 href=https://ui.adsabs.harvard.edu/abs/2009A%26A...504..617D/abstract target=ref> de Medeiros et al. 2009 </a>	189.8111935	12h39m14.69s	-7.9956702	-07d59m44.41s	297.69653	54.75208	192.15381	-3.46834	835.477	6.04	-6.04	835.477±6.04	3.8	290.6	-3.8	290.6±3.8	2.14	0.03	-0.03	2.14±0.03			nan	2451796.9065	5.1	-5.1	2451796.9065±5.1	0.462	0.069	-0.069	0.462±0.069	nan	nan	nan				nan				nan		nan		nan	2.011±0.312	nan	nan
HIP 5158 b	b	HIP 5158	nan	HIP 5158	TIC 268634769	Gaia DR2 2351405057377686272	1	<a refstr=LO_CURTO_ET_AL__2010 href=https://ui.adsabs.harvard.edu/abs/2010A%26A...512A..48L/abstract target=ref> Lo Curto et al. 2010 </a>	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	2010-03	2009	Radial Velocity	Ground	La Silla Observatory	HARPS Spectrograph	3.6 m ESO Telescope	<a refstr=LO_CURTO_ET_AL__2010 href=https://ui.adsabs.harvard.edu/abs/2010A%26A...512A..48L/abstract target=ref> Lo Curto et al. 2010 </a>	16.5094891	01h06m02.28s	-22.4536134	-22d27m13.01s	159.04576	-84.27097	5.73781	-27.05769	345.72	5.37	-5.37	345.72±5.37	11	-108	-11	-108±11	0.89			0.89			nan	2454580.49	15.21	-15.21	2454580.49±15.21	0.52	0.08	-0.08	0.52±0.08	nan	nan	nan				nan				nan		nan		nan	7.669±0.020	nan	nan
HD 44219 b	b	HD 44219	HD 44219	HIP 30114	TIC 443055162	Gaia DR2 3001428566419966592	1	<a refstr=NAEF_ET_AL__2010 href=https://ui.adsabs.harvard.edu/abs/2010A%26A...523A..15N/abstract target=ref> Naef et al. 2010 </a>	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	2010-11	2010	Radial Velocity	Ground	La Silla Observatory	HARPS Spectrograph	3.6 m ESO Telescope	<a refstr=NAEF_ET_AL__2010 href=https://ui.adsabs.harvard.edu/abs/2010A%26A...523A..15N/abstract target=ref> Naef et al. 2010 </a>	95.0599971	06h20m14.40s	-10.7250799	-10d43m30.29s	219.07812	-11.74314	96.0042	-34.05896	472.3	6.3	-5	<div><span class=supersubNumber">472.3</span> <span class="superscript">+6.3</span><span class="subscript">-5.0</span> </div>"	6.2	147.4	-3.2	<div><span class=supersubNumber">147.4</span> <span class="superscript">+6.2</span><span class="subscript">-3.2</span> </div>"	1.19	0.02	-0.02	1.19±0.02			nan	2454585.6	7.2	-3.1	<div><span class=supersubNumber">2454585.6</span> <span class="superscript">+7.2</span><span class="subscript">-3.1</span> </div>"	0.61	0.07	-0.09	<div><span class=supersubNumber">0.61</span> <span class="superscript">+0.07</span><span class="subscript">-0.09</span> </div>"	nan	nan	nan				nan				nan		nan		nan	6.115±0.017	nan	nan
HD 132563 b	b	HD 132563	HD 132563	HIP 73261 A	TIC 284680749	Gaia DR2 1585765117538284800	1	<a refstr=DESIDERA_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011A%26A...533A..90D/abstract target=ref> Desidera et al. 2011 </a>	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	2011-09	2011	Radial Velocity	Ground	Roque de los Muchachos Observatory	SARG Spectrograph	3.58 m Telescopio Nazionale Galileo	<a refstr=DESIDERA_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011A%26A...533A..90D/abstract target=ref> Desidera et al. 2011 </a>	224.5892892	14h58m21.43s	44.0428571	+44d02m34.29s	74.89413	59.44282	200.01297	56.98824	1544	34	-34	1544.0±34.0	35	158	-35	158.0±35.0	2.62	0.04	-0.04	2.62±0.04			nan	2452593	148	-148	2452593.0±148.0	0.22	0.09	-0.09	0.22±0.09	nan	nan	nan				nan				nan		nan		nan	7.431±0.021	nan	nan
Kepler-24 c	c	Kepler-24	nan	nan	TIC 122376177	Gaia DR2 2052823535171095296	1	<a refstr=FORD_ET_AL__2012 href=https://ui.adsabs.harvard.edu/abs/2012ApJ...750..113F/abstract target=ref> Ford et al. 2012 </a>	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	2012-05	2011	Transit	Space	Kepler	Kepler CCD Array	0.95 m Kepler Telescope	<a refstr=FORD_ET_AL__2012 href=https://ui.adsabs.harvard.edu/abs/2012ApJ...750..113F/abstract target=ref> Ford et al. 2012 </a>	290.4132621	19h21m39.18s	38.3437283	+38d20m37.42s	70.54989	11.01831	302.60761	59.49349	12.3335			12.3335				nan	0.106			0.106			nan				nan				nan	nan	nan	nan				nan				nan	2454970.586	2454970.5860	3.71	3.71	13.372±0.037	nan	nan
CHXR 73 b	b	CHXR 73	nan	nan	TIC 454291479	Gaia DR2 5201175987817179136	1	<a refstr=LUHMAN_ET_AL__2006 href=https://ui.adsabs.harvard.edu/abs/2006ApJ...649..894L/abstract target=ref> Luhman et al. 2006 </a>	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	2006-10	2006	Imaging	Space	Hubble Space Telescope	ACS Camera	2.4 m Hubble Space Telescope	<a refstr=LUHMAN_ET_AL__2006 href=https://ui.adsabs.harvard.edu/abs/2006ApJ...649..894L/abstract target=ref> Luhman et al. 2006 </a>	166.6193985	11h06m28.66s	-77.6258725	-77d37m33.14s	297.2776	-15.92181	238.71128	-66.3331				nan				nan	210			210			nan				nan				nan	nan	nan	nan				nan				nan		nan		nan	10.703±0.023	nan	nan
alf Ari b	b	alf Ari	HD 12929	HIP 9884	TIC 306349516	nan	1	<a refstr=LEE_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011A%26A...529A.134L/abstract target=ref> Lee et al. 2011 </a>	<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>	2011-05	2010	Radial Velocity	Ground	Bohyunsan Optical Astronomical Observatory	BOES Echelle Spectrograph	1.8 m Telescope	<a refstr=LEE_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011A%26A...529A.134L/abstract target=ref> Lee et al. 2011 </a>	31.793286	02h07m10.39s	23.462421	+23d27m44.72s	144.57834	-36.20556	37.66242	9.96514	380.8	0.3	-0.3	380.8±0.3	6.84	89.16	-6.84	89.16±6.84	1.2			1.2			nan	2451213.52	7.36	-7.36	2451213.52±7.36	0.25	0.03	-0.03	0.25±0.03	nan	nan	nan				nan				nan		nan		nan	-0.783±0.176	nan	nan


CREATE TABLE nea_full (
  "pl_name" VARCHAR,
  "pl_letter" VARCHAR,
  "hostname" VARCHAR,
  "hd_name" VARCHAR,
  "hip_name" VARCHAR,
  "tic_id" VARCHAR,
  "gaia_id" VARCHAR,
  "default_flag" BIGINT,
  "pl_refname" VARCHAR,
  "sy_refname" VARCHAR,
  "disc_pubdate" VARCHAR,
  "disc_year" BIGINT,
  "discoverymethod" VARCHAR,
  "disc_locale" VARCHAR,
  "disc_facility" VARCHAR,
  "disc_instrument" VARCHAR,
  "disc_telescope" VARCHAR,
  "disc_refname" VARCHAR,
  "ra" DOUBLE,
  "rastr" VARCHAR,
  "dec" DOUBLE,
  "decstr" VARCHAR,
  "glon" DOUBLE,
  "glat" DOUBLE,
  "elon" DOUBLE,
  "elat" DOUBLE,
  "pl_orbper" DOUBLE,
  "pl_orbpererr1" DOUBLE,
  "pl_orbpererr2" DOUBLE,
  "pl_orbperlim" DOUBLE,
  "pl_orbperstr" VARCHAR,
  "pl_orblpererr1" DOUBLE,
  "pl_orblper" DOUBLE,
  "pl_orblpererr2" DOUBLE,
  "pl_orblperlim" DOUBLE,
  "pl_orblperstr" VARCHAR,
  "pl_orbsmax" DOUBLE,
  "pl_orbsmaxerr1" DOUBLE,
  "pl_orbsmaxerr2" DOUBLE,
  "pl_orbsmaxlim" DOUBLE,
  "pl_orbsmaxstr" VARCHAR,
  "pl_orbincl" DOUBLE,
  "pl_orbinclerr1" DOUBLE,
  "pl_orbinclerr2" DOUBLE,
  "pl_orbincllim" DOUBLE,
  "pl_orbinclstr" VARCHAR,
  "pl_orbtper" DOUBLE,
  "pl_orbtpererr1" DOUBLE,
  "pl_orbtpererr2" DOUBLE,
  "pl_orbtperlim" DOUBLE,
  "pl_orbtperstr" VARCHAR,
  "pl_orbeccen" DOUBLE,
  "pl_orbeccenerr1" DOUBLE,
  "pl_orbeccenerr2" DOUBLE,
  "pl_orbeccenlim" DOUBLE,
  "pl_orbeccenstr" VARCHAR,
  "pl_eqt" DOUBLE,
  "pl_eqterr1" DOUBLE,
  "pl_eqterr2" DOUBLE,
  "pl_eqtlim" DOUBLE,
  "pl_eqtstr" VARCHAR,
  "pl_occdep" DOUBLE,
  "pl_occdeperr1" DOUBLE,
  "pl_occdeperr2" DOUBLE,
  "pl_occdeplim" DOUBLE,
  "pl_occdepstr" VARCHAR,
  "pl_insol" DOUBLE,
  "pl_insolerr1" DOUBLE,
  "pl_insolerr2" DOUBLE,
  "pl_insollim" DOUBLE,
  "pl_insolstr" VARCHAR,
  "pl_dens" DOUBLE,
  "pl_denserr1" DOUBLE,
  "pl_denserr2" DOUBLE,
  "pl_denslim" DOUBLE,
  "pl_densstr" VARCHAR,
  "pl_trandep" DOUBLE,
  "pl_trandeperr1" DOUBLE,
  "pl_trandeperr2" DOUBLE,
  "pl_trandeplim" DOUBLE,
  "pl_trandepstr" VARCHAR,
  "pl_tranmid" DOUBLE,
  "pl_tranmiderr1" DOUBLE,
  "pl_tranmiderr2" DOUBLE,
  "pl_tranmidlim" DOUBLE,
  "pl_tranmidstr" VARCHAR,
  "pl_trandur" DOUBLE,
  "pl_trandurerr1" DOUBLE,
  "pl_trandurerr2" DOUBLE,
  "pl_trandurlim" DOUBLE,
  "pl_trandurstr" VARCHAR,
  "sy_kmagstr" VARCHAR,
  "sy_umag" DOUBLE,
  "sy_umagerr1" DOUBLE,
  "sy_umagerr2" DOUBLE,
  "sy_umagstr" VARCHAR,
  "sy_rmag" DOUBLE,
  "sy_rmagerr1" DOUBLE,
  "sy_rmagerr2" DOUBLE,
  "sy_rmagstr" VARCHAR
);