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

45.21 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_upper_unc_days" DOUBLE,
  "orbital_period_lower_unc_days" DOUBLE,
  "orbital_period_limit_flag" BIGINT,
  "orbit_semi_major_axis_au" DOUBLE,
  "orbit_semi_major_axis_upper_unc_au" DOUBLE,
  "orbit_semi_major_axis_lower_unc_au" DOUBLE,
  "orbit_semi_major_axis_limit_flag" BIGINT,
  "eccentricity" DOUBLE,
  "eccentricity_upper_unc" VARCHAR,
  "eccentricity_lower_unc" VARCHAR,
  "eccentricity_limit_flag" DOUBLE,
  "inclination_deg" DOUBLE,
  "inclination_upper_unc_deg" DOUBLE,
  "inclination_lower_unc_deg" DOUBLE,
  "inclination_limit_flag" BIGINT,
  "planet_mass_jupiter_mass" DOUBLE,
  "planet_mass_or_m_sin_i_upper_unc_jupiter_mass" DOUBLE,
  "planet_mass_or_m_sin_i_lower_unc_jupiter_mass" DOUBLE,
  "planet_mass_or_m_sin_i_limit_flag" DOUBLE,
  "planet_radius_jupiter_radii" DOUBLE,
  "planet_radius_upper_unc_jupiter_radii" DOUBLE,
  "planet_radius_lower_unc_jupiter_radii" DOUBLE,
  "planet_radius_limit_flag" BIGINT,
  "planet_density_g_cm_3" DOUBLE,
  "planet_density_upper_unc_g_cm_3" DOUBLE,
  "planet_density_lower_unc_g_cm_3" DOUBLE,
  "planet_density_limit_flag" DOUBLE,
  "ra_str" VARCHAR,
  "ra_sexagesimal" DOUBLE,
  "dec_str" VARCHAR,
  "dec_sexagesimal" DOUBLE,
  "effective_temperature_k" BIGINT,
  "effective_temperature_upper_unc_k" BIGINT,
  "effective_temperature_lower_unc_k" BIGINT,
  "effective_temperature_limit_flag" BIGINT,
  "effective_temperature_blend_flag" BIGINT,
  "stellar_mass_solar_mass" DOUBLE,
  "stellar_mass_upper_unc_solar_mass" DOUBLE,
  "stellar_mass_lower_unc_solar_mass" DOUBLE,
  "stellar_mass_limit_flag" BIGINT,
  "stellar_mass_blend_flag" BIGINT,
  "stellar_radius_solar_radii" DOUBLE,
  "stellar_radius_upper_unc_solar_radii" BIGINT,
  "stellar_radius_lower_unc_solar_radii" BIGINT,
  "stellar_radius_limit_flag" BIGINT,
  "stellar_radius_blend_flag" BIGINT,
  "date_of_last_update" TIMESTAMP
);