TESS Exoplanet Dataset

This file was produced by the NASA Exoplanet Archive

@kaggle.mithunmeenakshis_tess_exoplanet_dataset

Table List

1 table(1.17 MB)

Tess Exoplanet Data

@kaggle.mithunmeenakshis_tess_exoplanet_dataset.tess_exoplanet_data

1.17 MB
7208 rows
27 columns

rowid Rowid	toi Toi	toipfx Toipfx	tid Tid	ctoi_alias Ctoi Alias	pl_pnum Pl Pnum	tfopwg_disp Tfopwg Disp	rastr Rastr	ra Ra	decstr Decstr	dec Dec	st_pmra St Pmra	st_pmdec St Pmdec	pl_tranmid Pl Tranmid	pl_orbper Pl Orbper	pl_trandurh Pl Trandurh	pl_trandep Pl Trandep	pl_rade Pl Rade	pl_insol Pl Insol	pl_eqt Pl Eqt	st_tmag St Tmag	st_dist St Dist	st_teff St Teff	st_logg St Logg	st_rad St Rad	toi_created Toi Created	rowupdate Rowupdate
1	1000.01	1000	50365310	50365310.01	1	FP	07h29m25.85s	112.357708	-12d41m45.46s	-12.69596	-5.964	-0.076	2459229.630046	2.1713484	2.0172196	656.8860989	5.8181633	22601.9485814	3127.2040524	9.604	485.735	10249	4.19	2.16986	Wed Jul 24 2019 15:58:33 GMT+0000 (Coordinated Universal Time)	Fri Oct 29 2021 12:59:15 GMT+0000 (Coordinated Universal Time)
2	1001.01	1001	88863718	88863718.01	1	PC	08h10m19.31s	122.580465	-05d30m49.87s	-5.513852	-4.956	-15.555	2459987.948873	1.9316462	3.166	1286	11.2154	44464.5	4045	9.42344	295.862	7070	4.03	2.01	Wed Jul 24 2019 15:58:33 GMT+0000 (Coordinated Universal Time)	Mon Apr 03 2023 14:31:04 GMT+0000 (Coordinated Universal Time)
3	1002.01	1002	124709665	124709665.01	1	FP	06h58m54.47s	104.726966	-10d34m49.64s	-10.580455	-1.462	-2.249	2459224.687802	1.8675574	1.408	1500	23.7529	2860.61	2037	9.299501	943.109	8924		5.73	Wed Jul 24 2019 15:58:33 GMT+0000 (Coordinated Universal Time)	Mon Jul 11 2022 16:02:02 GMT+0000 (Coordinated Universal Time)
4	1003.01	1003	106997505	106997505.01	1	FP	07h22m14.39s	110.559945	-25d12m25.26s	-25.207017	-0.939	1.64	2458493.3957	2.74323	3.167	383.41		1177.36	1631	9.3003	7728.17	5388.5	4.15		Wed Jul 24 2019 15:58:33 GMT+0000 (Coordinated Universal Time)	Wed Feb 23 2022 10:10:02 GMT+0000 (Coordinated Universal Time)
5	1004.01	1004	238597883	238597883.01	1	FP	08h08m42.77s	122.178195	-48d48m10.12s	-48.802811	-4.496	9.347	2459987.047262	3.5730141	3.37	755	11.3113	54679.3	4260	9.1355	356.437	9219	4.14	2.15	Wed Jul 24 2019 15:58:33 GMT+0000 (Coordinated Universal Time)	Wed Mar 08 2023 16:02:02 GMT+0000 (Coordinated Universal Time)
6	1005.01	1005	169904935	169904935.01	1	FP	08h02m49.15s	120.704811	-11d06m05.48s	-11.101521	-26.932	-2.901	2458492.5552	4.55072	2.599	3620	6.54449	254.05	1112	9.1309	100.711	5613		1.09	Wed Jul 24 2019 15:58:33 GMT+0000 (Coordinated Universal Time)	Wed Feb 23 2022 10:10:02 GMT+0000 (Coordinated Universal Time)
7	1006.01	1006	156115721	156115721.01	1	FP	08h17m26.22s	124.359239	-27d16m24.68s	-27.273521	-29.1	-6.8	2459229.984579	2.5047918	4.3797563	2270.5402194	8.6950898	1750.932635	1649.8220699	9.2386		6616		1.53429	Wed Jul 24 2019 15:58:33 GMT+0000 (Coordinated Universal Time)	Fri Oct 29 2021 12:59:15 GMT+0000 (Coordinated Universal Time)
8	1007.01	1007	65212867	65212867.01	1	PC	07h31m00.57s	112.752393	-04d27m48.09s	-4.463359	0.357	3.399	2459247.930695	6.9989206	3.953	2840	14.7752	448.744	1282	8.87759	283.291	6596	3.71	2.7	Wed Jul 24 2019 15:58:33 GMT+0000 (Coordinated Universal Time)	Fri Oct 29 2021 12:59:15 GMT+0000 (Coordinated Universal Time)
9	1008.01	1008	440801822	440801822.01	1	FP	07h17m31.88s	109.382839	+13d23m42.79s	13.395219	-17.9	1.3	2460258.236122	2.0483755	2.767	483	3.19621	5644.4		8.9362	144.297	6858.5	4.2	1.57	Wed Jul 24 2019 15:58:33 GMT+0000 (Coordinated Universal Time)	Fri Dec 08 2023 16:02:02 GMT+0000 (Coordinated Universal Time)
10	1009.01	1009	107782586	107782586.01	1	PC	07h26m40.28s	111.667845	-24d27m43.6s	-24.462111	-3.297	4.849	2459229.230924	1.9600277	2.0065257	1707.6272693		1063.3422958	1456.4246534	8.4331	866.147	8868.7			Wed Jul 24 2019 15:58:33 GMT+0000 (Coordinated Universal Time)	Wed Jan 17 2024 10:08:02 GMT+0000 (Coordinated Universal Time)


CREATE TABLE tess_exoplanet_data (
  "rowid" BIGINT,
  "toi" DOUBLE,
  "toipfx" BIGINT,
  "tid" BIGINT,
  "ctoi_alias" DOUBLE,
  "pl_pnum" BIGINT,
  "tfopwg_disp" VARCHAR,
  "rastr" VARCHAR,
  "ra" DOUBLE,
  "decstr" VARCHAR,
  "dec" DOUBLE,
  "st_pmra" DOUBLE,
  "st_pmdec" DOUBLE,
  "pl_tranmid" DOUBLE,
  "pl_orbper" DOUBLE,
  "pl_trandurh" DOUBLE,
  "pl_trandep" DOUBLE,
  "pl_rade" DOUBLE,
  "pl_insol" DOUBLE,
  "pl_eqt" DOUBLE,
  "st_tmag" DOUBLE,
  "st_dist" DOUBLE,
  "st_teff" DOUBLE,
  "st_logg" DOUBLE,
  "st_rad" DOUBLE,
  "toi_created" TIMESTAMP,
  "rowupdate" TIMESTAMP
);