Dataset: NASA's Confirmed Exoplanets: Regular Updated

About this Dataset

NASA's Confirmed Exoplanets: Regular Updated

As of 2024-Dec-10, 5,788 exoplanets have been confirmed (See column descriptions below).

This dataset provides a comprehensive catalog of confirmed exoplanets, including a wide range of parameters related to their physical characteristics, orbital properties, discovery details, and the properties of their host stars. The data is compiled from reputable sources, primarily the NASA Exoplanet Archive, and is presented with user-friendly, snake_case column names for ease of use in data analysis and modeling.

If you enjoy the dataset, please consider up-voting as a bit of effort went into curating this dataset. 💜

Planet Identification & System: Unique identifiers for the planet and its host star, including catalog names and system composition (number of stars, planets, and moons).

Discovery Information: Details about how, when, and where each exoplanet was discovered, including the discovery method, year, publication date, and the facility, telescope, and instrument used.

Detection Flags : A series of boolean flags indicating which methods have been used to detect each planet, including radial velocity, transit, microlensing, imaging, etc.

Orbital Parameters: Key properties of the planet's orbit around its host star, such as orbital period, semi-major axis, eccentricity, inclination, and transit information.

Planet Properties: Physical characteristics of the exoplanets, including radius, mass, density, equilibrium temperature, and insolation flux.

Stellar Properties:Detailed information about the host stars, including spectral type, temperature, radius, mass, metallicity, luminosity, age, and rotational velocity.

Astrometric Properties: Data regarding the host star's position and motion, including Right Ascension (RA), Declination (Dec), proper motion, parallax, and distance.

Magnitude Data: Apparent magnitudes of the host star across various photometric bands (e.g., Johnson, 2MASS, Sloan, WISE, Gaia, TESS, Kepler). These values represent the brightness of the star as observed in these specific bands.

After loading the raw data from the NASA Exoplanet Archive into a SQL Database, I created a view to extract a large subset (over 200 columns) of the data, transforming it into a user-friendly format with human-readable, snake_case column names (e.g., planet_name, orbital_period_days, stellar_effective_temp_k).

NASA Exoplanet Archives offers two main datasets on Confirmed Planets:

The detailed system dataset ("PS" table)
The streamlined composite dataset ("PSCompPars")

The system dataset provides comprehensive exoplanet information, while the composite dataset offers a concise summary (one row per exoplanet) and makes our lives a lot easier.

For further exploration, visit the NASA Exoplanet Archive website: https://exoplanetarchive.ipac.caltech.edu/index.html

Caveat: Parameters in a given row may come from different sources and include calculated values.

If you enjoy the dataset, please consider up-voting as a bit of effort went into curating this dataset.

Tables

Confirmed Exoplanents 2024 December

@kaggle.jameskychoi_confirmed_exoplanet_latest_update_dataset.confirmed_exoplanents_2024_december

2.53 MB
5788 rows
210 columns


CREATE TABLE confirmed_exoplanents_2024_december (
  "planet_name" VARCHAR,
  "host_star_name" VARCHAR,
  "planet_letter" VARCHAR,
  "hd_id" VARCHAR,
  "hip_id" VARCHAR,
  "tic_id" VARCHAR,
  "gaia_id" VARCHAR,
  "num_stars_in_system" BIGINT,
  "num_planets_in_system" BIGINT,
  "num_moons_in_system" BIGINT,
  "is_circumbinary" BIGINT,
  "discovery_method" VARCHAR,
  "discovery_year" BIGINT,
  "discovery_publication_date" VARCHAR,
  "discovery_locale" VARCHAR,
  "discovery_facility" VARCHAR,
  "discovery_telescope" VARCHAR,
  "discovery_instrument" VARCHAR,
  "detected_by_radial_velocity" BIGINT,
  "detected_by_pulsar_timing" BIGINT,
  "detected_by_pulsation_timing_variations" BIGINT,
  "detected_by_transit" BIGINT,
  "detected_by_astrometry" BIGINT,
  "detected_by_orbital_brightness_modulation" BIGINT,
  "detected_by_microlensing" BIGINT,
  "detected_by_eclipse_timing_variations" BIGINT,
  "detected_by_imaging" BIGINT,
  "detected_by_disk_kinematics" BIGINT,
  "is_controversial" BIGINT,
  "orbital_period_days" DOUBLE,
  "orbital_period_upper_unc_days" DOUBLE,
  "orbital_period_lower_unc_days" DOUBLE,
  "orbital_period_limit_flag" DOUBLE,
  "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" DOUBLE,
  "angular_separation_mas" DOUBLE,
  "angular_separation_upper_unc_mas" VARCHAR,
  "angular_separation_lower_unc_mas" VARCHAR,
  "angular_separation_limit_flag" DOUBLE,
  "planet_radius_earth_radius" DOUBLE,
  "planet_radius_upper_unc_earth_radius" DOUBLE,
  "planet_radius_lower_unc_earth_radius" DOUBLE,
  "planet_radius_earth_limit_flag" DOUBLE,
  "planet_radius_jupiter_radius" DOUBLE,
  "planet_radius_upper_unc_jupiter_radius" DOUBLE,
  "planet_radius_lower_unc_jupiter_radius" DOUBLE,
  "planet_radius_jupiter_limit_flag" DOUBLE,
  "planet_mass_earth_mass" DOUBLE,
  "planet_mass_upper_unc_earth_mass" DOUBLE,
  "planet_mass_lower_unc_earth_mass" DOUBLE,
  "planet_mass_earth_limit_flag" DOUBLE,
  "planet_mass_jupiter_mass" DOUBLE,
  "planet_mass_upper_unc_jupiter_mass" DOUBLE,
  "planet_mass_lower_unc_jupiter_mass" DOUBLE,
  "planet_mass_jupiter_limit_flag" DOUBLE,
  "planet_mass_provenance" VARCHAR,
  "planet_density_gcm3" DOUBLE,
  "planet_density_upper_unc_gcm3" DOUBLE,
  "planet_density_lower_unc_gcm3" DOUBLE,
  "planet_density_limit_flag" DOUBLE,
  "eccentricity" DOUBLE,
  "eccentricity_upper_unc" DOUBLE,
  "eccentricity_lower_unc" DOUBLE,
  "eccentricity_limit_flag" DOUBLE,
  "insolation_flux_earth_flux" DOUBLE,
  "insolation_flux_upper_unc_earth_flux" DOUBLE,
  "insolation_flux_lower_unc_earth_flux" DOUBLE,
  "insolation_flux_limit_flag" DOUBLE,
  "equilibrium_temperature_k" DOUBLE,
  "equilibrium_temperature_upper_unc_k" DOUBLE,
  "equilibrium_temperature_lower_unc_k" DOUBLE,
  "equilibrium_temperature_limit_flag" DOUBLE,
  "inclination_deg" DOUBLE,
  "inclination_upper_unc_deg" DOUBLE,
  "inclination_lower_unc_deg" DOUBLE,
  "inclination_limit_flag" DOUBLE,
  "transit_midpoint_days" DOUBLE,
  "transit_midpoint_upper_unc_days" DOUBLE,
  "transit_midpoint_lower_unc_days" DOUBLE,
  "transit_midpoint_limit_flag" DOUBLE,
  "transit_midpoint_time_system" VARCHAR,
  "data_show_transit_timing_variations" BIGINT,
  "impact_parameter" DOUBLE,
  "impact_parameter_upper_unc" DOUBLE,
  "impact_parameter_lower_unc" DOUBLE,
  "impact_parameter_limit_flag" DOUBLE,
  "transit_depth_percent" DOUBLE,
  "transit_depth_upper_unc_percent" DOUBLE,
  "transit_depth_lower_unc_percent" DOUBLE,
  "transit_depth_limit_flag" DOUBLE,
  "transit_duration_hours" DOUBLE,
  "transit_duration_upper_unc_hours" DOUBLE,
  "transit_duration_lower_unc_hours" DOUBLE,
  "transit_duration_limit_flag" DOUBLE,
  "ratio_semi_major_axis_to_stellar_radius" DOUBLE,
  "ratio_semi_major_axis_to_stellar_radius_upper_unc" DOUBLE,
  "ratio_semi_major_axis_to_stellar_radius_lower_unc" DOUBLE,
  "ratio_semi_major_axis_to_stellar_radius_limit_flag" DOUBLE
);