Dataset: All Exoplanets Dataset

About this Dataset

All Exoplanets Dataset

The Exoplanet dataset consists of known exoplanets that were discovered using a variety of methods, and many have been detected using multiple methods. The data was produced by the NASA Exoplanet Archive

Source: http://exoplanetarchive.ipac.caltech.edu

Tables

All Exoplanets 2021

@kaggle.shivamb_all_exoplanets_dataset.all_exoplanets_2021

274.28 KB
4575 rows
23 columns


CREATE TABLE all_exoplanets_2021 (
  "no" BIGINT,
  "planet_name" VARCHAR,
  "planet_host" VARCHAR,
  "num_stars" BIGINT,
  "num_planets" BIGINT,
  "discovery_method" VARCHAR,
  "discovery_year" BIGINT,
  "discovery_facility" VARCHAR,
  "orbital_period_days" DOUBLE,
  "orbit_semi_major_axis" DOUBLE,
  "mass" DOUBLE,
  "eccentricity" DOUBLE,
  "insolation_flux" DOUBLE,
  "equilibrium_temperature" DOUBLE,
  "spectral_type" VARCHAR,
  "stellar_effective_temperature" DOUBLE,
  "stellar_radius" DOUBLE,
  "stellar_mass" DOUBLE,
  "stellar_metallicity" DOUBLE,
  "stellar_metallicity_ratio" VARCHAR,
  "stellar_surface_gravity" DOUBLE,
  "distance" DOUBLE,
  "gaia_magnitude" DOUBLE
);