Developing a More Integrated NASA Exoplanet Archive

The NASA Exoplanet Archive team's effort to provide a more integrated and streamlined user experience is still underway.

A significant part of this transition is the development of the new Planetary Systems (PS) and the Planetary Systems Composite Parameters (PSCP) tables, which are more integrated and more complete than the Confirmed Planets, Extended Planet Parameters, and Composite Parameters tables.

The Planetary Systems Table combines data from the Confirmed Planets and Extended Planet Parameters tables into a single table and provides access to all of the planetary solutions served by the NASA Exoplanet Archive in a single location.

The Planetary Systems Composite Parameters Table is similar to our existing Composite Parameters Table: it's a more complete table of planet parameters combined from multiple references and calculations. The new Planetary Systems Composite Parameters Table is built from the new (currently in Beta) Planetary Systems Table, and is thus more extensive and more complete.

The retiring Confirmed Planets, Extended Planet Parameters, and Composite Parameters tables will continue to be maintained for the coming months—with the aim of decomissioning these tables near the end of 2020/early 2021.

Which Data Table Should You Use?

Use the following table and this graphic as a guide. (Click to enlarge)

 

Table NameContains...Status
Planetary Systems (PS) All data from the Confirmed Planets and Extended Planet Data tables. Displays all solutions for planet and host star solutions, regardless of their relationship, including atypical systems such as free-floating planets and those with multiple stars. Also contains Kepler, K2, and TESS candidate solutions for confirmed planet systems, a nearly complete identification of published stellar companions, and projected and true planet obliquities. Each set of parameters is displayed in a separate row.

Use this table when you need a self-consistent set of planetary parameters for a given planet, or if you want a comprehensive list of published planet parameters in the archive.

Beta release as of August 2020 (previously in alpha since December 2019).

Improvements: various bug fixes and expanded and updated data content, including Gaia IDs, improved stellar multiplicity reporting, and improved detection flag reporting.

Available as:

Planetary Systems Composite Parameters (PSCP) Same data as the Planetary Systems table except the confirmed planet data includes parameters or calculations that are combined from different references into one parameter set, or row. References are given for each value.

Use this table when you need a more "filled-in" table to enable a statistical view of the known exoplanet population and their host environments.

Differences between the Planetary Systems and Planetary Systems Composite Parameters tables: (Click to enlarge)

Alpha release as of August 2020

Available as:

Documentation:

Confirmed Planets All confirmed planets with one default set of self-consistent, published parameters. How the archive designates parameter sets as default is explained in our FAQ. Still being updated with new data as part of regular archive release schedule.

Scheduled to be retired in late 2020/early 2021; to be replaced by Planetary Systems Table.

Available as:

Extended Planet Data All confirmed planets with all self-consistent sets of published parameters—those both designated as default by the archive as well as non-default. Each set of parameters is displayed in a separate row. Still being updated with new data as part of regular archive release schedule.

Scheduled to be retiring in late 2020/early 2021; to be replaced by Planetary Systems Table.

Available as:

Composite Planet Data (a.k.a. Composite Parameters) All confirmed planets with parameters or calculations combined from different references. Still being updated with new data as part of regular archive release schedule.

Scheduled to be retired in late 2020/early 2021; to be replaced by Planetary Systems Composite Parameters Table.

Available as:

Making the Transition

To help with the coming transition, the Exoplanet Archive has provided some resources.

If you are a current user of the archive's application programming interface (API), you will need to eventually update your queries to point to one of the new tables, as well as update the database column names for the data you are retrieving. Use the following documents to identify the new database names for your scripts/queries:

  • Master list of columns in the Planetary Systems, Confirmed Planets, Extended Planet Data, Planetary Systems Composite Parameters, and Composite Parameters tables: PDF   CSV
  • Column mapping between the Planetary Systems, Confirmed Planets, and Extended Planet Data tables: PDF  CSV
  • Column mapping between the new Planetary Systems Composite Parameters Table and the old Composite Parameters Table: PDF  CSV
  • A list of parameters in the Confirmed Planets, Extended Planet Data and Composite Parameters tables, but not in the Planetary Systems Table: PDF  CSV

Accessing Data With Table Access Protocol

In addition to the new integrated content of the Planetary Systems tables, the new tables are connected to a new Table Access Protocol (TAP) service for a more IVOA-integrated API experience. An overview of the new NASA Exoplanet Archive TAP service describes how to use the TAP interface to extract data from the PS and PSCP tables.

Tell Us What You Think

As always, we want to hear your feedback on what is working and what can be improved. Please send us your feedback through the Helpdesk, follow the archive on social media, or subscribe to our email list to stay informed. See our Connect page for links.



Last updated: 4 August 2020