The Exoplanet Archive has numerous interactive tables that display planetary and stellar data, such as the Confirmed Planets, and Kepler Objects of Interest (KOI) tables. Upon initial loading, these tables display an array of default columns, or parameters, which users may further customize using the tables' built-in web interface tools. See the User Guide for more information on sorting and filtering within interactive tables.
An alternate method of customizing the table is to directly amend the table's URL to specify which columns/parameters to display. This page provides the steps for this approach, and includes some examples.
To bypass the interactive tables and access data directly through wget, see the Application Programming Interface (API) help document.
&constraint=column operator valueto specify a default column
&addcol=column&constraint=column operator valuefor non-default columns
where column is the name of the table column/parameter, operator is either < , > , like , or between, and value is the numeric or alpha string to be compared.
pl_massjstr. Multiple filters can be used by chaining constraints together, with the & symbol between each. However, each column can only be used once, and may only have one filter.
likeoperator; the value to be matched must be enclosed in single quotes ( ' ). For example
&constraint=koi_pdisposition like 'CANDIDATE'
period in (20,50] requests data within a period greater than 20, and less than and equal to 50.
Clicking on the links below will return pre-filtered tables. More functional examples are listed on the Exoplanet and Candidate Statistics page.
For planets by discovery method and in mass and radius bins, see the Exoplanet and Candidate Statistics page.
Only the most recently added planets and updated parameters (default and non-default), sorted with the most recent updates at the top (in this example, the date string is 2016-11-10): http://exoplanetarchive.ipac.caltech.edu/cgi-bin/TblView/nph-tblView?app=ExoTbls&config=exomultpars&constraint=rowupdate%3E%272016-11-10%27&constraint=order+by+rowupdate+desc.
All confirmed planets where the stellar effective temperature is between 4000 and 6000 K:
All planets in orbits greater than 1 AU:
All planets with radii between 0.75 and 1.5 Earth radii and orbits between 0.5 and 2 AU:
Likely Habitable Zone Earth-Sized Planet Candidates
Last updated: 17 November 2016