Dataset: PHL Exoplanet Catalog

About this Dataset

PHL Exoplanet Catalog

The Habitable Exoplanets Catalog is a database of potentially habitable worlds discovered by ground and space telescopes in the last decade. The exoplanet data comes from the NASA Exoplanet Archive and includes planets up to 2.5 Earth radii or 10 Earth masses orbiting within the optimistic stellar habitable zone to be as inclusive as possible. A more conservative sample includes planets up to 1.6 Earth radii or 3 Earth masses and thus more likely to be rocky.

You can get the field descriptions here: https://phl.upr.edu/projects/habitable-exoplanets-catalog

Tables

Phl Exoplanet Catalog 2019

@kaggle.chandrimad31_phl_exoplanet_catalog.phl_exoplanet_catalog_2019

1.42 MB
4048 rows
112 columns


CREATE TABLE phl_exoplanet_catalog_2019 (
  "p_name" VARCHAR,
  "p_status" DOUBLE,
  "p_mass" DOUBLE,
  "p_mass_error_min" DOUBLE,
  "p_mass_error_max" DOUBLE,
  "p_radius" DOUBLE,
  "p_radius_error_min" DOUBLE,
  "p_radius_error_max" DOUBLE,
  "p_year" BIGINT,
  "p_updated" VARCHAR,
  "p_period" DOUBLE,
  "p_period_error_min" DOUBLE,
  "p_period_error_max" DOUBLE,
  "p_semi_major_axis" DOUBLE,
  "p_semi_major_axis_error_min" DOUBLE,
  "p_semi_major_axis_error_max" DOUBLE,
  "p_eccentricity" DOUBLE,
  "p_eccentricity_error_min" DOUBLE,
  "p_eccentricity_error_max" DOUBLE,
  "p_inclination" DOUBLE,
  "p_inclination_error_min" DOUBLE,
  "p_inclination_error_max" DOUBLE,
  "p_omega" DOUBLE,
  "p_omega_error_min" DOUBLE,
  "p_omega_error_max" DOUBLE,
  "p_tperi" DOUBLE,
  "p_tperi_error_min" DOUBLE,
  "p_tperi_error_max" DOUBLE,
  "p_angular_distance" DOUBLE,
  "p_impact_parameter" DOUBLE,
  "p_impact_parameter_error_min" DOUBLE,
  "p_impact_parameter_error_max" DOUBLE,
  "p_temp_measured" DOUBLE,
  "p_geo_albedo" VARCHAR,
  "p_geo_albedo_error_min" DOUBLE,
  "p_geo_albedo_error_max" DOUBLE,
  "p_detection" VARCHAR,
  "p_detection_mass" VARCHAR,
  "p_detection_radius" VARCHAR,
  "p_alt_names" VARCHAR,
  "p_atmosphere" VARCHAR,
  "s_name" VARCHAR,
  "s_ra" DOUBLE,
  "s_dec" DOUBLE,
  "s_mag" DOUBLE,
  "s_distance" DOUBLE,
  "s_distance_error_min" DOUBLE,
  "s_distance_error_max" DOUBLE,
  "s_metallicity" DOUBLE,
  "s_metallicity_error_min" DOUBLE,
  "s_metallicity_error_max" DOUBLE,
  "s_mass" DOUBLE,
  "s_mass_error_min" DOUBLE,
  "s_mass_error_max" DOUBLE,
  "s_radius" DOUBLE,
  "s_radius_error_min" DOUBLE,
  "s_radius_error_max" DOUBLE,
  "s_type" VARCHAR,
  "s_age" DOUBLE,
  "s_age_error_min" DOUBLE,
  "s_age_error_max" DOUBLE,
  "s_temperature" DOUBLE,
  "s_temperature_error_min" DOUBLE,
  "s_temperature_error_max" DOUBLE,
  "s_disc" VARCHAR,
  "s_magnetic_field" VARCHAR,
  "s_log_g" DOUBLE,
  "s_alt_names" VARCHAR,
  "p_escape" DOUBLE,
  "p_potential" DOUBLE,
  "p_gravity" DOUBLE,
  "p_density" DOUBLE,
  "p_hill_sphere" DOUBLE,
  "p_distance" DOUBLE,
  "p_periastron" DOUBLE,
  "p_apastron" DOUBLE,
  "p_distance_eff" DOUBLE,
  "p_flux" DOUBLE,
  "p_flux_min" DOUBLE,
  "p_flux_max" DOUBLE,
  "p_temp_equil" DOUBLE,
  "p_temp_equil_min" DOUBLE,
  "p_temp_equil_max" DOUBLE,
  "p_type" VARCHAR,
  "s_radius_est" DOUBLE,
  "s_type_temp" VARCHAR,
  "s_ra_h" DOUBLE,
  "s_ra_t" VARCHAR,
  "s_dec_t" VARCHAR,
  "s_luminosity" DOUBLE,
  "s_hz_opt_min" DOUBLE,
  "s_hz_opt_max" DOUBLE,
  "s_hz_con_min" DOUBLE,
  "s_hz_con_max" DOUBLE,
  "s_hz_con0_min" DOUBLE,
  "s_hz_con0_max" DOUBLE,
  "s_hz_con1_min" DOUBLE,
  "s_hz_con1_max" DOUBLE,
  "s_snow_line" DOUBLE,
  "s_abio_zone" DOUBLE
);