Dataset: Exoplanets Confirmed & Candidates

About this Dataset

Exoplanets Confirmed & Candidates

Context

There is a catalogue of full known exoplanets (confirmed and candidates), according to The Extrasolar
Planets Encyclopaedia. All data can be found on exoplanet.eu

Content

Dataset contains over 7000 rows (planets), and over 90 columns with their characteristics. Catalog on exoplanet.eu is updated over time, and I try update it periodically here.

Acknowledgements

All data was download from portal http://exoplanet.eu/ of The Extrasolar
Planets Encyclopaedia."

Inspiration

Kepler found thousands of worlds, but billions more of them remain unexplored..

Tables

Exoplanet Confirm And Candidates

@kaggle.ilyamarchenko_full_exoplanet_catalog.exoplanet_confirm_and_candidates

1.3 MB
7414 rows
98 columns


CREATE TABLE exoplanet_confirm_and_candidates (
  "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" DOUBLE,
  "geometric_albedo" DOUBLE,
  "geometric_albedo_error_min" DOUBLE,
  "geometric_albedo_error_max" DOUBLE,
  "log_g" DOUBLE,
  "publication" 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
);