Name: Trappist-1 Solar System
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Trappist-1 Solar System

Context

On February 22, 2017 NASA announces the discovery of the Trappist-1 Solar System, which contains 7 earth sized exoplanets orbiting close to a dim star. The planets' orbits are situated in the 'Goldilocks zone', making them prime candidates for extraterrestrial life.

Content

The data published here was pulled from NASA and CalTech's Exoplanet Archive:
http://exoplanetarchive.ipac.caltech.edu/index.html

Column contents are explained further:
http://exoplanetarchive.ipac.caltech.edu/docs/API_exoplanet_columns.html

Acknowledgements

Use of the NASA Exoplanet Archive, which is operated by the California Institute of Technology, under contract with the National Aeronautics and Space Administration under the Exoplanet Exploration Program

Inspiration

A playground to work with data from an exciting discovery. A lot of questions remained to be answered, pending future studies.

Tables

Dataset

@kaggle.nasa_trappist1.dataset

46.3 kB
7 rows
55 columns

CREATE TABLE dataset (
  "rowid" BIGINT,
  "host_name" VARCHAR,
  "letter" VARCHAR,
  "default_parameter_flag" BIGINT,
  "reference" VARCHAR,
  "discovery_method" VARCHAR,
  "number_of_planets_in_system" BIGINT,
  "orbital_period_days" DOUBLE  -- Orbital Period (days),
  "orbital_period_upper_unc_days" DOUBLE  -- Orbital Period Upper Unc. (days),
  "orbital_period_lower_unc_days" DOUBLE  -- Orbital Period Lower Unc. (days),
  "orbital_period_limit_flag" BIGINT,
  "orbit_semi_major_axis_au" DOUBLE  -- Orbit Semi-Major Axis (AU),
  "orbit_semi_major_axis_upper_unc_au" DOUBLE  -- Orbit Semi-Major Axis Upper Unc (AU),
  "orbit_semi_major_axis_lower_unc_au" DOUBLE  -- Orbit Semi-Major Axis Lower Unc (AU),
  "orbit_semi_major_axis_limit_flag" BIGINT,
  "eccentricity" DOUBLE,
  "eccentricity_upper_unc" VARCHAR  -- Eccentricity Upper Unc.,
  "eccentricity_lower_unc" VARCHAR  -- Eccentricity Lower Unc.,
  "eccentricity_limit_flag" DOUBLE,
  "inclination_deg" DOUBLE  -- Inclination (deg),
  "inclination_upper_unc_deg" DOUBLE  -- Inclination Upper Unc. (deg),
  "inclination_lower_unc_deg" DOUBLE  -- Inclination Lower Unc. (deg),
  "inclination_limit_flag" BIGINT,
  "planet_mass_jupiter_mass" DOUBLE  -- Planet Mass (Jupiter Mass),
  "planet_mass_or_m_sin_i_upper_unc_jupiter_mass" DOUBLE  -- Planet Mass Or M*sin(i)Upper Unc. (Jupiter Mass),
  "planet_mass_or_m_sin_i_lower_unc_jupiter_mass" DOUBLE  -- Planet Mass Or M*sin(i)Lower Unc. (Jupiter Mass),
  "planet_mass_or_m_sin_i_limit_flag" DOUBLE  -- Planet Mass Or M*sin(i) Limit Flag,
  "planet_radius_jupiter_radii" DOUBLE  -- Planet Radius (Jupiter Radii),
  "planet_radius_upper_unc_jupiter_radii" DOUBLE  -- Planet Radius Upper Unc. (Jupiter Radii),
  "planet_radius_lower_unc_jupiter_radii" DOUBLE  -- Planet Radius Lower Unc. (Jupiter Radii),
  "planet_radius_limit_flag" BIGINT,
  "planet_density_g_cm_3" DOUBLE  -- Planet Density (g/cm**3),
  "planet_density_upper_unc_g_cm_3" DOUBLE  -- Planet Density Upper Unc. (g/cm**3),
  "planet_density_lower_unc_g_cm_3" DOUBLE  -- Planet Density Lower Unc. (g/cm**3),
  "planet_density_limit_flag" DOUBLE,
  "ra_str" VARCHAR,
  "ra_sexagesimal" DOUBLE  -- RA [sexagesimal],
  "dec_str" VARCHAR,
  "dec_sexagesimal" DOUBLE  -- Dec [sexagesimal],
  "effective_temperature_k" BIGINT  -- Effective Temperature (K),
  "effective_temperature_upper_unc_k" BIGINT  -- Effective Temperature Upper Unc. (K),
  "effective_temperature_lower_unc_k" BIGINT  -- Effective Temperature Lower Unc. (K),
  "effective_temperature_limit_flag" BIGINT,
  "effective_temperature_blend_flag" BIGINT,
  "stellar_mass_solar_mass" DOUBLE  -- Stellar Mass (Solar Mass),
  "stellar_mass_upper_unc_solar_mass" DOUBLE  -- Stellar Mass Upper Unc. (Solar Mass),
  "stellar_mass_lower_unc_solar_mass" DOUBLE  -- Stellar Mass Lower Unc. (Solar Mass),
  "stellar_mass_limit_flag" BIGINT,
  "stellar_mass_blend_flag" BIGINT,
  "stellar_radius_solar_radii" DOUBLE  -- Stellar Radius (Solar Radii),
  "stellar_radius_upper_unc_solar_radii" BIGINT  -- Stellar Radius Upper Unc. (Solar Radii),
  "stellar_radius_lower_unc_solar_radii" BIGINT  -- Stellar Radius Lower Unc. (Solar Radii),
  "stellar_radius_limit_flag" BIGINT,
  "stellar_radius_blend_flag" BIGINT,
  "date_of_last_update" TIMESTAMP
);