Name: NASA Exoplanet Archive
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

NASA Exoplanet Archive

Context

The NASA Exoplanet Archive is an online astronomical exoplanet and stellar catalog and data service that collates and cross-correlates astronomical data and information on exoplanets and their host stars, and provides tools to work with these data.

Content

These data include stellar parameters (such as positions, magnitudes, and temperatures), exoplanet parameters (such as masses and orbital parameters) and discovery/characterization data (such as published radial velocity curves, photometric light curves, images, and spectra).

Acknowledgements

All confirmed planets (and hosts) in the archive with parameters derived from a single, published reference that are designated as the archive's default parameter set "Confirmed Planets"

Inspiration

Explore your foundings

Tables

Planets List

@kaggle.santoshd3_nasa_exoplanet_archive.planets_list

613.26 kB
4,367 rows
82 columns

CREATE TABLE planets_list (
  "pl_hostname" VARCHAR,
  "pl_letter" VARCHAR,
  "pl_name" VARCHAR,
  "pl_discmethod" VARCHAR,
  "pl_controvflag" BIGINT,
  "pl_pnum" BIGINT,
  "pl_orbper" DOUBLE,
  "pl_orbpererr1" DOUBLE,
  "pl_orbpererr2" DOUBLE,
  "pl_orbperlim" DOUBLE,
  "pl_orbpern" BIGINT,
  "pl_orbsmax" DOUBLE,
  "pl_orbsmaxerr1" DOUBLE,
  "pl_orbsmaxerr2" DOUBLE,
  "pl_orbsmaxlim" DOUBLE,
  "pl_orbsmaxn" BIGINT,
  "pl_orbeccen" DOUBLE,
  "pl_orbeccenerr1" DOUBLE,
  "pl_orbeccenerr2" DOUBLE,
  "pl_orbeccenlim" DOUBLE,
  "pl_orbeccenn" BIGINT,
  "pl_orbincl" DOUBLE,
  "pl_orbinclerr1" DOUBLE,
  "pl_orbinclerr2" DOUBLE,
  "pl_orbincllim" DOUBLE,
  "pl_orbincln" BIGINT,
  "pl_bmassj" DOUBLE,
  "pl_bmassjerr1" DOUBLE,
  "pl_bmassjerr2" DOUBLE,
  "pl_bmassjlim" DOUBLE,
  "pl_bmassn" BIGINT,
  "pl_bmassprov" VARCHAR,
  "pl_radj" DOUBLE,
  "pl_radjerr1" DOUBLE,
  "pl_radjerr2" DOUBLE,
  "pl_radjlim" DOUBLE,
  "pl_radn" BIGINT,
  "pl_dens" DOUBLE,
  "pl_denserr1" DOUBLE,
  "pl_denserr2" DOUBLE,
  "pl_denslim" DOUBLE,
  "pl_densn" BIGINT,
  "pl_ttvflag" BIGINT,
  "pl_kepflag" BIGINT,
  "pl_k2flag" BIGINT,
  "ra_str" VARCHAR,
  "dec_str" VARCHAR,
  "ra" DOUBLE,
  "st_raerr" DOUBLE,
  "dec" DOUBLE,
  "st_decerr" DOUBLE,
  "st_posn" BIGINT,
  "st_dist" DOUBLE,
  "st_disterr1" DOUBLE,
  "st_disterr2" DOUBLE,
  "st_distlim" DOUBLE,
  "st_distn" BIGINT,
  "st_optmag" DOUBLE,
  "st_optmagerr" DOUBLE,
  "st_optmaglim" DOUBLE,
  "st_optband" VARCHAR,
  "gaia_gmag" DOUBLE,
  "gaia_gmagerr" VARCHAR,
  "gaia_gmaglim" DOUBLE,
  "st_teff" DOUBLE,
  "st_tefferr1" DOUBLE,
  "st_tefferr2" DOUBLE,
  "st_tefflim" DOUBLE,
  "st_teffn" BIGINT,
  "st_mass" DOUBLE,
  "st_masserr1" DOUBLE,
  "st_masserr2" DOUBLE,
  "st_masslim" DOUBLE,
  "st_massn" BIGINT,
  "st_rad" DOUBLE,
  "st_raderr1" DOUBLE,
  "st_raderr2" DOUBLE,
  "st_radlim" DOUBLE,
  "st_radn" BIGINT,
  "pl_nnotes" BIGINT,
  "rowupdate" TIMESTAMP,
  "pl_facility" VARCHAR
);