Dataset: Planetary Systems Dataset - NASA

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

3.86 MB
5483 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.29 MB
34951 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
);