astro query:docs

- Index
- Modules

### Navigation

- next »
- « previous |
- astroquery v0.4.11 »
- NASA Exoplanet Archive (`astroquery.ipac.nexsci.nasa_exoplanet_archive`)

# NASA Exoplanet Archive (`astroquery.ipac.nexsci.nasa_exoplanet_archive`)

This module can be used to query the NASA Exoplanet Archive via the TAP service or the API. A full discussion of the available tables and query syntax through the two interfaces is available at [1] and [2]. More information about the development of a more integrated NASA Exoplanet Archive and ongoing transition to fully TAP supported services can be found at [3].

NOTE: the `exoplanet` and `exomultpars` tables are no longer available and have been replaced by the Planetary Systems table (`ps`). Likewise, the `compositepars` table has been replaced by the Planetary Systems Composite Parameters table (`pscomppars`). Both the `ps` and `pscomppars` tables are accessible through the Exoplanet Archive TAP service. Database column names have changed; this document contains the current definitions and a mapping between the new and deprecated names.

## Query methods

The `query_object` method can be used to query for a specific planet or planet host. For example, the following query searches the `ps` table of confirmed exoplanets for information about the planet K2-18 b.

    >>> from astroquery.ipac.nexsci.nasa_exoplanet_archive import NasaExoplanetArchive
    >>> NasaExoplanetArchive.query_object("K2-18 b")
    <QTable masked=True length=11>
    pl_name pl_letter hostname ... sy_kmagerr1 sy_kmagerr2      sky_coord
                               ...                               deg,deg
      str7     str1     str5   ...   float64     float64          object
    ------- --------- -------- ... ----------- ----------- --------------------
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315
    K2-18 b         b    K2-18 ...       0.019      -0.019 172.560141,7.5878315

Similarly, cone searches can be executed using the `query_region` method:

    >>> import astropy.units as u
    >>> from astropy.coordinates import SkyCoord
    >>> from astroquery.ipac.nexsci.nasa_exoplanet_archive import NasaExoplanetArchive
    >>> NasaExoplanetArchive.query_region(
    ...     table="pscomppars", coordinates=SkyCoord(ra=172.56 * u.deg, dec=7.59 * u.deg),
    ...     radius=1.0 * u.deg)
    <QTable masked=True length=2>
    pl_name pl_letter hostname ...   htm20         sky_coord
                               ...                  deg,deg
      str7     str1     str5   ...   int32           object
    ------- --------- -------- ... ---------- --------------------
    K2-18 b         b    K2-18 ... -244884223 172.560141,7.5878315
    K2-18 c         c    K2-18 ... -244884223 172.560141,7.5878315

The most general queries can be performed using the `query_criteria` method. For example, a full table can be queried as follows:

    >>> from astroquery.ipac.nexsci.nasa_exoplanet_archive import NasaExoplanetArchive
    >>> NasaExoplanetArchive.query_criteria(table="cumulative", select="*")
    <QTable masked=True length=9564>
     kepid   kepoi_name kepler_name  ... koi_fittype koi_score      sky_coord
                                     ...                             deg,deg
     int64      str9       str14     ...     str7     float64         object
    -------- ---------- ------------ ... ----------- --------- -------------------
    10797460  K00752.01 Kepler-227 b ...     LS+MCMC       1.0 291.93423,48.141651
    10797460  K00752.02 Kepler-227 c ...     LS+MCMC     0.969 291.93423,48.141651
    10811496  K00753.01              ...     LS+MCMC       0.0 297.00482,48.134129
    10848459  K00754.01              ...     LS+MCMC       0.0  285.53461,48.28521
    10854555  K00755.01 Kepler-664 b ...     LS+MCMC       1.0   288.75488,48.2262
         ...        ...          ... ...         ...       ...                 ...
    10155286  K07988.01              ...     LS+MCMC     0.092 296.76288,47.145142
    10156110  K07989.01              ...     LS+MCMC       0.0 297.00977,47.121021

A list of accessible tables can be found in the `TAP_TABLES` attribute:

    >>> from astroquery.ipac.nexsci.nasa_exoplanet_archive import NasaExoplanetArchive
    >>> NasaExoplanetArchive.TAP_TABLES
    ['spectra',
    'TD',
    'pscomppars',
    'superwasptimeseries',
    'kelttimeseries',
    'DI_STARS_EXEP',
    'stellarhosts',
    'transitspec',
    'emissionspec',
    'ps',
    'keplernames',
    'k2names',
    'toi',
    'CUMULATIVE',
    'Q1_Q6_KOI',
    'Q1_Q8_KOI',
    'Q1_Q12_KOI',
    'Q1_Q16_KOI',
    'Q1_Q17_DR24_KOI',
    'Q1_Q17_DR25_KOI',
    'Q1_Q17_DR25_SUP_KOI',
    'Q1_Q12_TCE',
    'Q1_Q16_TCE',
    'Q1_Q17_DR24_TCE',
    'Q1_Q17_DR25_TCE',
    'stellarhosts',
    'ukirttimeseries',
    'ml',
    'object_aliases',
    'k2pandc',
    'K2TARGETS',
    'KEPLERTIMESERIES',
    'KEPLERSTELLAR',
    'Q1_Q12_KS',
    'Q1_Q16_KS',
    'Q1_Q17_DR24_KS',
    'Q1_Q17_DR25_KS',
    'Q1_Q17_DR25_SUP_KS']

## Example queries

Specific searches can be executed using the `where`, `select`, `order`, and other parameters as described in the documentation [1], [2].

In this section, we demonstrate

1. The number of confirmed planets discovered by TESS:

    >>> from astroquery.ipac.nexsci.nasa_exoplanet_archive import NasaExoplanetArchive
    >>> NasaExoplanetArchive.query_criteria(table="pscomppars", select="count(*)",
    ...                                     where="disc_facility like '%TESS%'")
    <QTable masked=True length=1>
    count(*)
     int32
    --------
         131

2. The list of 10 confirmed planets discovered by TESS and their host star coordinates:

    >>> from astroquery.ipac.nexsci.nasa_exoplanet_archive import NasaExoplanetArchive
    >>> NasaExoplanetArchive.query_criteria(table="pscomppars", select="top 10 pl_name,ra,dec",
    ...                                     where="disc_facility like '%TESS%'")
    <QTable masked=True length=10>
       pl_name         ra         dec            sky_coord
                      deg         deg             deg,deg
        str13       float64     float64            object
    ------------- ----------- ----------- -----------------------
    WD 1856+534 b  284.415675  53.5090244   284.415675,53.5090244
       TOI-1201 b  42.2476999 -14.5372835  42.2476999,-14.5372835
      HD 213885 b 338.9837166  -59.864829  338.9837166,-59.864829
      HD 219666 b 349.5592665 -56.9039857 349.5592665,-56.9039857
              ...         ...         ...                     ...

3. The list of confirmed planets discovered using microlensing that have data available in the archive:

    >>> from astroquery.ipac.nexsci.nasa_exoplanet_archive import NasaExoplanetArchive
    >>> NasaExoplanetArchive.query_criteria(
    ...     table="pscomppars", where="discoverymethod like 'Microlensing'")
    <QTable masked=True length=108>
           pl_name        pl_letter ...    htm20           sky_coord
                                    ...                     deg,deg
            str24            str1   ...    int32             object
    --------------------- --------- ... ----------- -----------------------
    OGLE-2016-BLG-1227L b         b ...  -768415656  265.597125,-33.7597778
    OGLE-2015-BLG-0966L b         b ...  2084638177   268.75425,-29.0471111
    OGLE-2017-BLG-0173L b         b ...  1462336374  267.970612,-29.2713604
    OGLE-2017-BLG-1140L b         b ...  -925663673  266.883057,-24.5226669
                      ...       ... ...         ...                     ...
    OGLE-2012-BLG-0358L b         b ...  2111594269      265.694875,-24.261
    OGLE-2017-BLG-0482L b         b ...  -287458961  269.048889,-30.5283604
      MOA-2010-BLG-353L b         b ... -1953724135  271.303917,-27.2932333
    OGLE-2014-BLG-1722L c         c ...   361334854   268.75238,-31.4690552

4. The list of confirmed planets where the host star name starts with “Kepler” using a wildcard search:

    >>> from astroquery.ipac.nexsci.nasa_exoplanet_archive import NasaExoplanetArchive
    >>> NasaExoplanetArchive.query_criteria(
    ...     table="pscomppars", where="hostname like 'Kepler%'", order="hostname")
    <QTable masked=True length=2370>
       pl_name    pl_letter   hostname  ...    htm20          sky_coord
                                        ...                    deg,deg
        str14        str1      str12    ...    int32            object
    ------------- --------- ----------- ... ----------- ----------------------
      Kepler-10 c         c   Kepler-10 ...   512815427  285.679298,50.2414842
      Kepler-10 b         b   Kepler-10 ...   512815427  285.679298,50.2414842
     Kepler-100 b         b  Kepler-100 ...  -383871624 291.3861294,41.9901394
     Kepler-100 d         d  Kepler-100 ...  -383871624 291.3861294,41.9901394
     Kepler-100 c         c  Kepler-100 ...  -383871624 291.3861294,41.9901394
    Kepler-1000 b         b Kepler-1000 ... -1745355506 286.6854729,47.0981948
              ...       ...         ... ...         ...                    ...
     Kepler-995 b         b  Kepler-995 ...  -369943676  284.6157154,39.130998
     Kepler-996 b         b  Kepler-996 ...  -288530943 291.9127633,41.5335891
     Kepler-997 b         b  Kepler-997 ...   604179197 289.2333767,49.9388952
     Kepler-998 b         b  Kepler-998 ...  1883599570 296.7541629,49.2087085
     Kepler-999 b         b  Kepler-999 ... -1948748132 299.6604865,46.1984679

5. The Kepler Objects of Interest that were vetted more recently than January 24, 2015 using a date search:

    >>> from astroquery.ipac.nexsci.nasa_exoplanet_archive import NasaExoplanetArchive
    >>> NasaExoplanetArchive.query_criteria(
    ...     table="koi", where="koi_vet_date>to_date('2015-01-24','yyyy-mm-dd')",
    ...     select="kepoi_name,koi_vet_date", order="koi_vet_date")
    <QTable length=34652>
    kepoi_name koi_vet_date
       str9       str10
    ---------- ------------
     K00866.01   2015-09-24
     K00867.01   2015-09-24
     K00124.01   2015-09-24
           ...          ...
     K06823.01   2018-08-16
     K06824.01   2018-08-16
     K06825.01   2018-08-16

## References

[1] (1,2)

NASA Exoplanet Archive TAP Documentation

[2] (1,2)

NASA Exoplanet Archive API Documentation

[3]

Developing a More Integrated NASA Exoplanet Archive

## Reference/API

### astroquery.ipac.nexsci.nasa_exoplanet_archive Package

#### NASA Exoplanet Archive Query Tool

Module to query the NASA Exoplanet Archive via the API.

#### Classes

`NasaExoplanetArchiveClass`() | The interface for querying the NASA Exoplanet Archive TAP and API services
`Conf`() | Configuration parameters for `astroquery.ipac.nexsci.nasa_exoplanet_archive`.