Dataset: Exoplanets Database

About this Dataset

Exoplanets Database

Context

Extrasolar planets, or exoplanets for short, are all the fuss in astronomy these days. Each week the news outlets reports increasingly exciting new discoveries. This is now your chance to take a dive in this wonderful data.

Content

This comprehensive dataset is maintened by the Extrasolar Planets Encyclopaedia, and comprises loads of data for confirmed exoplanets from several different sources, including Kepler (detections by transit), CoRoT (detections by radial velocity) and OGLE (microlensing). A plethora of data is available both for the planets and the host stars.

The data is well structured in a CSV file, but since it comes from several different sources, some parameters aren't well formated, and require some cleaning and filtering, an additional challenge!

Acknowledgements

http://exoplanet.eu/

Inspiration

There's so much data that the sky is the limit (pun intended). What kinds of relationships can you find? For example:

How does the mass of the planets correlates with their radius? What does this tells us about the planets' compositions? (Hint: There are only two kinds of planets: Gas planets and rocky planets, with low and high densities, respectively)
How does the size of the planet correlates with the orbital period? And what correlations are there with the spectral type of the host stars?
Which are the best detection methods? What are their limitations? Why does there are no planets with large orbital periods detected by transit and low mass planets detected by radial velocity?

Tables

Kepler

@kaggle.eduardowoj_exoplanets_database.kepler

518.35 KB
3732 rows
98 columns


CREATE TABLE kepler (
  "n__name" VARCHAR,
  "planet_status" VARCHAR,
  "mass" DOUBLE,
  "mass_error_min" DOUBLE,
  "mass_error_max" DOUBLE,
  "mass_sini" DOUBLE,
  "mass_sini_error_min" DOUBLE,
  "mass_sini_error_max" DOUBLE,
  "radius" DOUBLE,
  "radius_error_min" DOUBLE,
  "radius_error_max" DOUBLE,
  "orbital_period" DOUBLE,
  "orbital_period_error_min" DOUBLE,
  "orbital_period_error_max" DOUBLE,
  "semi_major_axis" DOUBLE,
  "semi_major_axis_error_min" DOUBLE,
  "semi_major_axis_error_max" DOUBLE,
  "eccentricity" DOUBLE,
  "eccentricity_error_min" DOUBLE,
  "eccentricity_error_max" DOUBLE,
  "inclination" DOUBLE,
  "inclination_error_min" DOUBLE,
  "inclination_error_max" DOUBLE,
  "angular_distance" DOUBLE,
  "discovered" DOUBLE,
  "updated" TIMESTAMP,
  "omega" DOUBLE,
  "omega_error_min" DOUBLE,
  "omega_error_max" DOUBLE,
  "tperi" DOUBLE,
  "tperi_error_min" DOUBLE,
  "tperi_error_max" DOUBLE,
  "tconj" DOUBLE,
  "tconj_error_min" DOUBLE,
  "tconj_error_max" DOUBLE,
  "tzero_tr" DOUBLE,
  "tzero_tr_error_min" DOUBLE,
  "tzero_tr_error_max" DOUBLE,
  "tzero_tr_sec" DOUBLE,
  "tzero_tr_sec_error_min" DOUBLE,
  "tzero_tr_sec_error_max" DOUBLE,
  "lambda_angle" DOUBLE,
  "lambda_angle_error_min" DOUBLE,
  "lambda_angle_error_max" DOUBLE,
  "impact_parameter" DOUBLE,
  "impact_parameter_error_min" DOUBLE,
  "impact_parameter_error_max" DOUBLE,
  "tzero_vr" DOUBLE,
  "tzero_vr_error_min" DOUBLE,
  "tzero_vr_error_max" DOUBLE,
  "k" DOUBLE,
  "k_error_min" DOUBLE,
  "k_error_max" DOUBLE,
  "temp_calculated" DOUBLE,
  "temp_calculated_error_min" DOUBLE,
  "temp_calculated_error_max" DOUBLE,
  "temp_measured" DOUBLE,
  "hot_point_lon" VARCHAR,
  "geometric_albedo" DOUBLE,
  "geometric_albedo_error_min" DOUBLE,
  "geometric_albedo_error_max" DOUBLE,
  "log_g" DOUBLE,
  "publication_status" VARCHAR,
  "detection_type" VARCHAR,
  "mass_detection_type" VARCHAR,
  "radius_detection_type" VARCHAR,
  "alternate_names" VARCHAR,
  "molecules" VARCHAR,
  "star_name" VARCHAR,
  "ra" DOUBLE,
  "dec" DOUBLE,
  "mag_v" DOUBLE,
  "mag_i" DOUBLE,
  "mag_j" DOUBLE,
  "mag_h" DOUBLE,
  "mag_k" DOUBLE,
  "star_distance" DOUBLE,
  "star_distance_error_min" DOUBLE,
  "star_distance_error_max" DOUBLE,
  "star_metallicity" DOUBLE,
  "star_metallicity_error_min" DOUBLE,
  "star_metallicity_error_max" DOUBLE,
  "star_mass" DOUBLE,
  "star_mass_error_min" DOUBLE,
  "star_mass_error_max" DOUBLE,
  "star_radius" DOUBLE,
  "star_radius_error_min" DOUBLE,
  "star_radius_error_max" DOUBLE,
  "star_sp_type" VARCHAR,
  "star_age" DOUBLE,
  "star_age_error_min" DOUBLE,
  "star_age_error_max" DOUBLE,
  "star_teff" DOUBLE,
  "star_teff_error_min" DOUBLE,
  "star_teff_error_max" DOUBLE,
  "star_detected_disc" VARCHAR,
  "star_magnetic_field" VARCHAR,
  "star_alternate_names" VARCHAR
);