Name: Planetary Systems Dataset - NASA
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Planetary Systems Dataset - NASA

The IPAC Exoplanet Archive is an extensive online repository managed by the NASA Exoplanet Science Institute as a part of the California Institute of Technology. It provides a comprehensive and accessible catalog of data on exoplanets and their host stars, including discovery methods, orbital parameters, and stellar characteristics. The dataset is constantly updated, reflecting the latest astronomical discoveries and observations. Researchers, educators, students, and anyone interested in astronomy can delve into this rich collection to expand their knowledge of our universe and the fascinating worlds beyond our solar system.

Source

Tables

Nasa Exoplanet Composite

@kaggle.kaggleprollc_planetary_systems_dataset_nasa.nasa_exoplanet_composite

4.05 MB
5,483 rows
313 columns

CREATE TABLE nasa_exoplanet_composite (
  "rowid" BIGINT,
  "pl_name" VARCHAR,
  "hostname" VARCHAR,
  "pl_letter" VARCHAR,
  "hd_name" VARCHAR,
  "hip_name" VARCHAR,
  "tic_id" VARCHAR,
  "gaia_id" VARCHAR,
  "sy_snum" BIGINT,
  "sy_pnum" BIGINT,
  "sy_mnum" BIGINT,
  "cb_flag" BIGINT,
  "discoverymethod" VARCHAR,
  "disc_year" BIGINT,
  "disc_refname" VARCHAR,
  "disc_pubdate" VARCHAR,
  "disc_locale" VARCHAR,
  "disc_facility" VARCHAR,
  "disc_telescope" VARCHAR,
  "disc_instrument" VARCHAR,
  "rv_flag" BIGINT,
  "pul_flag" BIGINT,
  "ptv_flag" BIGINT,
  "tran_flag" BIGINT,
  "ast_flag" BIGINT,
  "obm_flag" BIGINT,
  "micro_flag" BIGINT,
  "etv_flag" BIGINT,
  "ima_flag" BIGINT,
  "dkin_flag" BIGINT,
  "pl_controv_flag" BIGINT,
  "pl_orbper" DOUBLE,
  "pl_orbpererr1" DOUBLE,
  "pl_orbpererr2" DOUBLE,
  "pl_orbperlim" DOUBLE,
  "pl_orbper_reflink" VARCHAR,
  "pl_orbsmax" DOUBLE,
  "pl_orbsmaxerr1" DOUBLE,
  "pl_orbsmaxerr2" DOUBLE,
  "pl_orbsmaxlim" DOUBLE,
  "pl_orbsmax_reflink" VARCHAR,
  "pl_rade" DOUBLE,
  "pl_radeerr1" DOUBLE,
  "pl_radeerr2" DOUBLE,
  "pl_radelim" DOUBLE,
  "pl_rade_reflink" VARCHAR,
  "pl_radj" DOUBLE,
  "pl_radjerr1" DOUBLE,
  "pl_radjerr2" DOUBLE,
  "pl_radjlim" DOUBLE,
  "pl_radj_reflink" VARCHAR,
  "pl_bmasse" DOUBLE,
  "pl_bmasseerr1" DOUBLE,
  "pl_bmasseerr2" DOUBLE,
  "pl_bmasselim" DOUBLE,
  "pl_bmasse_reflink" VARCHAR,
  "pl_bmassj" DOUBLE,
  "pl_bmassjerr1" DOUBLE,
  "pl_bmassjerr2" DOUBLE,
  "pl_bmassjlim" DOUBLE,
  "pl_bmassj_reflink" VARCHAR,
  "pl_bmassprov" VARCHAR,
  "pl_dens" DOUBLE,
  "pl_denserr1" DOUBLE,
  "pl_denserr2" DOUBLE,
  "pl_denslim" DOUBLE,
  "pl_dens_reflink" VARCHAR,
  "pl_orbeccen" DOUBLE,
  "pl_orbeccenerr1" DOUBLE,
  "pl_orbeccenerr2" DOUBLE,
  "pl_orbeccenlim" DOUBLE,
  "pl_orbeccen_reflink" VARCHAR,
  "pl_insol" DOUBLE,
  "pl_insolerr1" DOUBLE,
  "pl_insolerr2" DOUBLE,
  "pl_insollim" DOUBLE,
  "pl_insol_reflink" VARCHAR,
  "pl_eqt" DOUBLE,
  "pl_eqterr1" DOUBLE,
  "pl_eqterr2" DOUBLE,
  "pl_eqtlim" DOUBLE,
  "pl_eqt_reflink" VARCHAR,
  "pl_orbincl" DOUBLE,
  "pl_orbinclerr1" DOUBLE,
  "pl_orbinclerr2" DOUBLE,
  "pl_orbincllim" DOUBLE,
  "pl_orbincl_reflink" VARCHAR,
  "pl_tranmid" DOUBLE,
  "pl_tranmiderr1" DOUBLE,
  "pl_tranmiderr2" DOUBLE,
  "pl_tranmidlim" DOUBLE,
  "pl_tranmid_systemref" VARCHAR,
  "pl_tranmid_reflink" VARCHAR,
  "ttv_flag" BIGINT,
  "pl_imppar" DOUBLE,
  "pl_impparerr1" DOUBLE,
  "pl_impparerr2" DOUBLE,
  "pl_impparlim" DOUBLE,
  "pl_imppar_reflink" VARCHAR,
  "pl_trandep" DOUBLE
);

Nasa Exoplanet Planetary

@kaggle.kaggleprollc_planetary_systems_dataset_nasa.nasa_exoplanet_planetary

6.59 MB
34,951 rows
287 columns

CREATE TABLE nasa_exoplanet_planetary (
  "rowid" BIGINT,
  "pl_name" VARCHAR,
  "hostname" VARCHAR,
  "pl_letter" VARCHAR,
  "hd_name" VARCHAR,
  "hip_name" VARCHAR,
  "tic_id" VARCHAR,
  "gaia_id" VARCHAR,
  "default_flag" BIGINT,
  "sy_snum" BIGINT,
  "sy_pnum" BIGINT,
  "sy_mnum" BIGINT,
  "cb_flag" BIGINT,
  "discoverymethod" VARCHAR,
  "disc_year" BIGINT,
  "disc_refname" VARCHAR,
  "disc_pubdate" VARCHAR,
  "disc_locale" VARCHAR,
  "disc_facility" VARCHAR,
  "disc_telescope" VARCHAR,
  "disc_instrument" VARCHAR,
  "rv_flag" BIGINT,
  "pul_flag" BIGINT,
  "ptv_flag" BIGINT,
  "tran_flag" BIGINT,
  "ast_flag" BIGINT,
  "obm_flag" BIGINT,
  "micro_flag" BIGINT,
  "etv_flag" BIGINT,
  "ima_flag" BIGINT,
  "dkin_flag" BIGINT,
  "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_masse" DOUBLE,
  "pl_masseerr1" DOUBLE,
  "pl_masseerr2" DOUBLE,
  "pl_masselim" DOUBLE,
  "pl_massj" DOUBLE,
  "pl_massjerr1" DOUBLE,
  "pl_massjerr2" DOUBLE,
  "pl_massjlim" DOUBLE,
  "pl_msinie" DOUBLE,
  "pl_msinieerr1" DOUBLE,
  "pl_msinieerr2" DOUBLE,
  "pl_msinielim" DOUBLE,
  "pl_msinij" DOUBLE,
  "pl_msinijerr1" DOUBLE,
  "pl_msinijerr2" DOUBLE,
  "pl_msinijlim" DOUBLE,
  "pl_cmasse" DOUBLE,
  "pl_cmasseerr1" DOUBLE,
  "pl_cmasseerr2" DOUBLE,
  "pl_cmasselim" DOUBLE,
  "pl_cmassj" DOUBLE,
  "pl_cmassjerr1" DOUBLE,
  "pl_cmassjerr2" DOUBLE,
  "pl_cmassjlim" 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_dens" DOUBLE,
  "pl_denserr1" DOUBLE,
  "pl_denserr2" DOUBLE,
  "pl_denslim" DOUBLE,
  "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,
  "pl_orbincl" DOUBLE
);