NASA Exoplanets Observations
A Multi-Source Dataset
@kaggle.ljunes_nasa_exoplanets_a_multi_source_dataset
A Multi-Source Dataset
@kaggle.ljunes_nasa_exoplanets_a_multi_source_dataset
This dataset presents a comprehensive collection of exoplanetary data sourced from NASA’s Exoplanet Archive. It includes essential attributes for each exoplanet, such as radius, mass, orbital period, discovery method, and more. These observations contribute to NASA’s mission to identify and study planets beyond our solar system, offering valuable insights into the field of exoplanetary science.
This dataset includes information sourced from NASA's Exoplanet Archive. NASA is the original source of the data.
This dataset was retrieved from the publicly accessible NASA Exoplanet Archive on November 10, 2024. Managed by the California Institute of Technology’s Infrared Processing and Analysis Center (IPAC) on behalf of NASA, this archive serves as a critical resource for astronomers and researchers globally.
To improve usability, the following data cleaning steps were applied:
pl_refname
, st_refname
, and sy_refname
columns were formatted to display only the hyperlink references, originally encoded with HTML markup for NASA’s web interface.pl_controv_flag
value of 1 were removed, as this flag indicates planets with disputed existence. Only planets with a pl_controv_flag
of 0, indicating no controversy, were retained.This dataset is derived from NASA's Exoplanet Archive. While NASA provides open access to its data, it's important to note that the inclusion of this information does not imply any endorsement by NASA or its employees of any products, services, or activities associated with this dataset. Users are advised to avoid using NASA's name, logos, or imagery in a manner that could be interpreted as an endorsement.
CREATE TABLE nasa_exoplanet_archive_data (
"pl_name" VARCHAR,
"hostname" VARCHAR,
"default_flag" BIGINT,
"sy_snum" BIGINT,
"sy_pnum" BIGINT,
"discoverymethod" VARCHAR,
"disc_year" BIGINT,
"disc_facility" VARCHAR,
"soltype" VARCHAR,
"pl_refname" VARCHAR,
"pl_orbper" DOUBLE,
"pl_orbpererr1" DOUBLE,
"pl_orbpererr2" DOUBLE,
"pl_orbperlim" DOUBLE,
"pl_orbsmax" DOUBLE,
"pl_orbsmaxerr1" DOUBLE,
"pl_orbsmaxerr2" DOUBLE,
"pl_orbsmaxlim" DOUBLE,
"pl_rade" DOUBLE,
"pl_radeerr1" DOUBLE,
"pl_radeerr2" DOUBLE,
"pl_radelim" DOUBLE,
"pl_radj" DOUBLE,
"pl_radjerr1" DOUBLE,
"pl_radjerr2" DOUBLE,
"pl_radjlim" DOUBLE,
"pl_bmasse" DOUBLE,
"pl_bmasseerr1" DOUBLE,
"pl_bmasseerr2" DOUBLE,
"pl_bmasselim" DOUBLE,
"pl_bmassj" DOUBLE,
"pl_bmassjerr1" DOUBLE,
"pl_bmassjerr2" DOUBLE,
"pl_bmassjlim" DOUBLE,
"pl_bmassprov" VARCHAR,
"pl_orbeccen" DOUBLE,
"pl_orbeccenerr1" DOUBLE,
"pl_orbeccenerr2" DOUBLE,
"pl_orbeccenlim" DOUBLE,
"pl_insol" DOUBLE,
"pl_insolerr1" DOUBLE,
"pl_insolerr2" DOUBLE,
"pl_insollim" DOUBLE,
"pl_eqt" DOUBLE,
"pl_eqterr1" DOUBLE,
"pl_eqterr2" DOUBLE,
"pl_eqtlim" DOUBLE,
"ttv_flag" BIGINT,
"st_refname" VARCHAR,
"st_spectype" VARCHAR,
"st_teff" DOUBLE,
"st_tefferr1" DOUBLE,
"st_tefferr2" DOUBLE,
"st_tefflim" DOUBLE,
"st_rad" DOUBLE,
"st_raderr1" DOUBLE,
"st_raderr2" DOUBLE,
"st_radlim" DOUBLE,
"st_mass" DOUBLE,
"st_masserr1" DOUBLE,
"st_masserr2" DOUBLE,
"st_masslim" DOUBLE,
"st_met" DOUBLE,
"st_meterr1" DOUBLE,
"st_meterr2" DOUBLE,
"st_metlim" DOUBLE,
"st_metratio" VARCHAR,
"st_logg" DOUBLE,
"st_loggerr1" DOUBLE,
"st_loggerr2" DOUBLE,
"st_logglim" DOUBLE,
"sy_refname" VARCHAR,
"rastr" VARCHAR,
"ra" DOUBLE,
"decstr" VARCHAR,
"dec" DOUBLE,
"sy_dist" DOUBLE,
"sy_disterr1" DOUBLE,
"sy_disterr2" DOUBLE,
"sy_vmag" DOUBLE,
"sy_vmagerr1" DOUBLE,
"sy_vmagerr2" DOUBLE,
"sy_kmag" DOUBLE,
"sy_kmagerr1" DOUBLE,
"sy_kmagerr2" DOUBLE,
"sy_gaiamag" DOUBLE,
"sy_gaiamagerr1" DOUBLE,
"sy_gaiamagerr2" DOUBLE,
"rowupdate" TIMESTAMP,
"pl_pubdate" VARCHAR,
"releasedate" VARCHAR
);
Anyone who has the link will be able to view this.