Kepler Telescope Exoplanet Discoveries

A dataset for the ~3,373 confirmed planets discovered by the Kepler Telescope.

@kaggle.melissamonfared_kepler_confirmed_planets

Table List

1 table(407.09 KB)

Planets

@kaggle.melissamonfared_kepler_confirmed_planets.planets

407.09 KB
3372 rows
67 columns

rowid Rowid	pl_hostname Pl Hostname	pl_letter Pl Letter	pl_discmethod Pl Discmethod	pl_pnum Pl Pnum	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_orbeccen Pl Orbeccen	pl_orbeccenerr1 Pl Orbeccenerr1	pl_orbeccenerr2 Pl Orbeccenerr2	pl_bmassj Pl Bmassj	pl_bmassjerr1 Pl Bmassjerr1	pl_bmassjerr2 Pl Bmassjerr2	pl_bmassprov Pl Bmassprov	ra_str Ra Str	ra Ra	dec_str Dec Str	dec Dec	st_dist St Dist	st_disterr1 St Disterr1	st_disterr2 St Disterr2	st_optmag St Optmag	st_optmagerr St Optmagerr	st_optband St Optband	st_teff St Teff	st_tefferr1 St Tefferr1	st_tefferr2 St Tefferr2	st_mass St Mass	st_masserr1 St Masserr1	st_masserr2 St Masserr2	st_rad St Rad	st_raderr1 St Raderr1	st_raderr2 St Raderr2	rowupdate Rowupdate
1	11 Com	b	Radial Velocity	1	326.03	0.32	-0.32	1.29	0.05	-0.05	0.231	0.005	-0.005	19.4	1.5	-1.5	Msini	12h20m43.03s	185.179276	+17d47m34.3s	17.792868	110.62	9.61	-11.63	4.74		V (Johnson)	4742	100	-100	2.7	0.3	-0.3	19	2	-2	Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
2	11 UMi	b	Radial Velocity	1	516.22	3.25	-3.25	1.54	0.07	-0.07	0.08	0.03	-0.03	10.5	2.47	-2.47	Msini	15h17m05.89s	229.274536	+71d49m26.0s	71.823898	119.47	6.22	-6.95	5.016	0.009	V (Johnson)	4340	70	-70	1.8	0.25	-0.25	24.08	1.84	-1.84	Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
3	14 And	b	Radial Velocity	1	185.84	0.23	-0.23	0.83						4.8			Msini	23h31m17.42s	352.822571	+39d14m10.3s	39.236198	76.39	3.93	-4.38			nan	4813	20	-20	2.2	0.1	-0.2	11	1	-1	Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
4	14 Her	b	Radial Velocity	1	1773.4	2.5	-2.5	2.77	0.05	-0.05	0.369	0.005	-0.005	4.64	0.19	-0.19	Msini	16h10m24.31s	242.601303	+43d49m03.5s	43.817646	18.15	0.19	-0.2	6.61	0.02	V (Johnson)	5311	87	-87	0.9	0.05	-0.05				Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
5	16 Cyg B	b	Radial Velocity	1	798.5	1	-1	1.681	0.097	-0.097	0.681	0.017	-0.017	1.68	0.15	-0.15	Msini	19h41m51.97s	295.466553	+50d31m03.1s	50.517525	21.41	0.23	-0.23	6.25		V (Johnson)	5674			0.99						Thu Sep 10 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
6	18 Del	b	Radial Velocity	1	993.3	3.2	-3.2	2.6			0.08	0.01	-0.01	10.3			Msini	20h58m25.94s	314.608063	+10d50m21.4s	10.839286	73.1	3.56	-3.94			nan	4979	18	-18	2.3			8.5			Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
7	1RXS J160929.1-210524	b	Imaging	1				330						8	1	-1	Mass	16h09m30.30s	242.376268	-21d04m58.9s	-21.083036	145	14	-14			nan	4060	300	-200	0.85	0.2	-0.1				Wed Apr 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
8	24 Sex	b	Radial Velocity	2	452.8	2.1	-4.5	1.333	0.004	-0.009	0.09	0.14	-0.06	1.99	0.26	-0.38	Msini	10h23m28.37s	155.86821	-00d54m08.1s	-0.902244	74.79	4.57	-5.21	6.441	0.01	V (Johnson)	5098	44	-44	1.54	0.08	-0.08	4.9	0.08	-0.08	Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
9	24 Sex	c	Radial Velocity	2	883	32.4	-13.8	2.08	0.05	-0.02	0.29	0.16	-0.09	0.86	0.35	-0.22	Msini	10h23m28.37s	155.86821	-00d54m08.1s	-0.902244	74.79	4.57	-5.21	6.441	0.01	V (Johnson)	5098	44	-44	1.54	0.08	-0.08	4.9	0.08	-0.08	Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
10	2MASS J01225093-2439505	b	Imaging	1				52	6	-6				24.5	2.5	-2.5	Mass	01h22m50.94s	20.712243	-24d39m50.6s	-24.664049	36	4	-4	14.24	0.07	V (Johnson)	3530	50	-50	0.4	0.05	-0.05				Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE planets (
  "rowid" BIGINT,
  "pl_hostname" VARCHAR,
  "pl_letter" VARCHAR,
  "pl_discmethod" VARCHAR,
  "pl_pnum" BIGINT,
  "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_orbeccen" DOUBLE,
  "pl_orbeccenerr1" DOUBLE,
  "pl_orbeccenerr2" DOUBLE,
  "pl_orbeccenlim" DOUBLE,
  "pl_orbincl" DOUBLE,
  "pl_orbinclerr1" DOUBLE,
  "pl_orbinclerr2" DOUBLE,
  "pl_orbincllim" DOUBLE,
  "pl_bmassj" DOUBLE,
  "pl_bmassjerr1" DOUBLE,
  "pl_bmassjerr2" DOUBLE,
  "pl_bmassjlim" DOUBLE,
  "pl_bmassprov" VARCHAR,
  "pl_radj" DOUBLE,
  "pl_radjerr1" DOUBLE,
  "pl_radjerr2" DOUBLE,
  "pl_radjlim" DOUBLE,
  "pl_dens" DOUBLE,
  "pl_denserr1" DOUBLE,
  "pl_denserr2" DOUBLE,
  "pl_denslim" DOUBLE,
  "pl_ttvflag" BIGINT,
  "pl_kepflag" BIGINT,
  "pl_k2flag" BIGINT,
  "pl_nnotes" BIGINT,
  "ra_str" VARCHAR,
  "ra" DOUBLE,
  "dec_str" VARCHAR,
  "dec" DOUBLE,
  "st_dist" DOUBLE,
  "st_disterr1" DOUBLE,
  "st_disterr2" DOUBLE,
  "st_distlim" DOUBLE,
  "st_optmag" DOUBLE,
  "st_optmagerr" DOUBLE,
  "st_optmaglim" DOUBLE,
  "st_optmagblend" DOUBLE,
  "st_optband" VARCHAR,
  "st_teff" DOUBLE,
  "st_tefferr1" DOUBLE,
  "st_tefferr2" DOUBLE,
  "st_tefflim" DOUBLE,
  "st_teffblend" DOUBLE,
  "st_mass" DOUBLE,
  "st_masserr1" DOUBLE,
  "st_masserr2" DOUBLE,
  "st_masslim" DOUBLE,
  "st_massblend" DOUBLE,
  "st_rad" DOUBLE,
  "st_raderr1" DOUBLE,
  "st_raderr2" DOUBLE,
  "st_radlim" DOUBLE,
  "st_radblend" DOUBLE,
  "rowupdate" TIMESTAMP
);