Pre-generated API Queries

This page contains a collection of pre-generated URLs that will return data through the Exoplanet Archive's Application Programming Interface (API). They can be copied and pasted into a web browser (for https:// queries) or a command-line interface (for wget queries). Note that you must have wget installed for wget queries.

Note: The default file format for all of the queries on this page is IPAC table format. To change formats, refer to the instruction in the File Format section of the API User Guide.

To request a specific pre-built query for this page, please submit a Helpdesk ticket.

To Return This... Copy This...
All confirmed planets and columns https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=exoplanets&where=*
wget "https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=exoplanets&where=*" -O "confirmed_planets.tbl"
Confirmed planets in the Kepler field (default columns) https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=exoplanets&format=ipac&where=pl_kepflag=1
wget "https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=exoplanets&format=ipac&where=pl_kepflag=1" -O "confirmed_kepler_field.tbl"
Stars known to host exoplanets listed in ascending order

https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=exoplanets&select=distinct pl_hostname&order=pl_hostname&format=ipac

wget "https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=exoplanets&select=distinct pl_hostname&order=pl_hostname&format=ipac" -O "stars_hosting_exoplanets.tbl"

Confirmed planets that transit their host stars (default columns)

https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=exoplanets&format=ipac&where=pl_tranflag=1

wget "https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=exoplanets&format=ipac&where=pl_tranflag=1" -O "planets_transit_host.tbl"

A current list of non-confirmed planet candidates https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=cumulative&format=ipac&where=koi_disposition like 'CANDIDATE'
wget "https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=cumulative&format=ipac&where=koi_disposition like 'CANDIDATE'" -O nonconf_planet_cand.tbl"
K2 targets from campaign 9 https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=k2targets&format=ipac&where=k2_campaign=9
wget "https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=k2targets&format=ipac&where=k2_campaign=9" -O k2_targets_c0.tbl"
Confirmed planets in the Mission Star list https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=missionstars&format=ipac&where=st_ppnum>0
wget "https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=missionstars&format=ipac&where=st_ppnum>0" -O "confirmed_mission_star.tbl"
All default parameters for one particular KOI or another https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=koi&format=ipac&where=kepoi_name='K00007.01' OR kepoi_name='K00742.01'
wget "https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=koi&format=ipac&where=kepoi_name='K00007.01' OR kepoi_name='K00742.01' -O "koi_OR.tbl"
All microlensing planets with time series https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=exoplanets&format=ipac&where=pl_discmethod like 'Microlensing' and st_nts > 0
wget "https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?&table=exoplanets&format=ipac&where=pl_discmethod like 'Microlensing' and st_nts > 0" -O "micro_ts.tbl"
All planetary candidates smaller than 2Re with equilibrium temperatures between 180-303K https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?table=cumulative&where=koi_prad<2 and koi_teq>180 and koi_teq<303 and koi_disposition like 'CANDIDATE'
wget "https://exoplanetarchive.ipac.caltech.edu/cgi-bin/nstedAPI/nph-nstedAPI?table=cumulative&where=koi_prad<2 and koi_teq>180 and koi_teq<303 and koi_disposition like 'CANDIDATE'" -O "koi_teff_180-303.tbl"

 

Last updated: 25 April 2017