# NASA Exoplanet Archive

> NASA's catalogue of every confirmed planet beyond the Solar System, more than 6,000 of them, run by Caltech for NASA. Search planets by size, mass, orbit, temperature, distance, star type, discovery method, facility or year; get a planet or a whole star system in full; list the planets added or updated each week; count planets by method or year; follow TESS planet candidates; translate Kepler and K2 names; or run your own ADQL query. A trigger runs when a new planet is confirmed. No account or API key required.

App · 10 actions. Web page: https://docs.lodol.com/docs/integrations/nasa-exoplanet-archive

## Actions

### Count planets

Count the confirmed exoplanets by discovery method, discovery year, facility, ground or space, or number of planets in the system, with each group's share: for a chart or a 'how many planets do we know' post. Optionally only one method or a range of years. No API key required.

**Inputs**

- Group by (`group_by`, text): What to count the planets by. Years and planets in the system are listed in order, the others biggest first. Defaults to discovery method. One of: `discovery_method` (Discovery method), `discovery_year` (Discovery year), `discovery_facility` (Discovery facility), `discovery_locale` (Ground or space), `planets_in_system` (Number of planets in the system). Default: `discovery_method`.
- Discovery method (`discovery_method`, text): Only planets found this way, such as Transit or Radial Velocity. Leave empty for every method.
- Discovered from year (`discovered_from_year`, number): Only planets discovered in this year or later, such as 2020. From 1989 to 2027.
- Discovered up to year (`discovered_to_year`, number): Only planets discovered in this year or earlier. Set both years to the same one for a single year's discoveries. From 1989 to 2027.

**Outputs**

- `adql` (text): The ADQL query sent to the archive, to reuse or adapt in 'Run an ADQL query'.
- `group_by` (text): What was counted by.
- `group_count` (number): How many groups.
- `groups` (list): Each group and its count.
- `summary` (text): One line describing the answer.
- `total` (number): All the planets counted.

**Example output**

```json
{
  "adql": "select discoverymethod as value, count(*) as planets from pscomppars group by discoverymethod",
  "group_by": "discovery_method",
  "group_count": 11,
  "groups": [
    {
      "percent": 74.2,
      "planets": 4785,
      "value": "Transit"
    },
    {
      "percent": 18.7,
      "planets": 1204,
      "value": "Radial Velocity"
    },
    {
      "percent": 4.5,
      "planets": 292,
      "value": "Microlensing"
    },
    {
      "percent": 1.5,
      "planets": 98,
      "value": "Imaging"
    },
    {
      "percent": 0.4,
      "planets": 29,
      "value": "Transit Timing Variations"
    },
    {
      "percent": 0.3,
      "planets": 17,
      "value": "Eclipse Timing Variations"
    },
    {
      "percent": 0.1,
      "planets": 9,
      "value": "Orbital Brightness Modulation"
    },
    {
      "percent": 0.1,
      "planets": 8,
      "value": "Pulsar Timing"
    },
    {
      "percent": 0.1,
      "planets": 6,
      "value": "Astrometry"
    },
    {
      "percent": 0.0,
      "planets": 2,
      "value": "Pulsation Timing Variations"
    },
    {
      "percent": 0.0,
      "planets": 1,
      "value": "Disk Kinematics"
    }
  ],
  "summary": "6,451 confirmed planets in 11 groups by discovery method.",
  "total": 6451
}
```

### Get a planet

Get one confirmed exoplanet by name with everything the archive has on it: size, mass, orbit, temperature, how and when it was found, the discovery paper, its JWST observations and its star. A name the archive doesn't have comes back with 'found' set to false rather than failing the step. No API key required.

**Inputs**

- Planet name (`name`, text, required): The planet's name, such as TRAPPIST-1 e or 51 Peg b. Case, spaces and hyphens don't matter.

**Outputs**

- `found` (true/false): True when the archive has it; false, with nothing else filled, when not.
- `planet` (object): The planet in full. Empty when not found.
- `query` (text): What was looked up, as given.
- `summary` (text): One line describing the answer.

**Example output**

```json
{
  "found": true,
  "planet": {
    "circumbinary": false,
    "controversial": false,
    "dec_deg": -5.0434618,
    "density_g_cm3": 4.901605,
    "detection_methods": [
      "Transit",
      "Transit Timing Variations"
    ],
    "discovery": {
      "facility": "Multiple Observatories",
      "instrument": "Multiple Instruments",
      "locale": "Multiple Locales",
      "method": "Transit",
      "published": "2017-02",
      "reference": "Gillon et al. 2017",
      "reference_url": "https://ui.adsabs.harvard.edu/abs/2017Natur.542..456G/abstract",
      "telescope": "Multiple Telescopes",
      "year": 2017
    },
    "discovery_facility": "Multiple Observatories",
    "discovery_method": "Transit",
    "discovery_year": 2017,
    "distance_light_years": 40.54,
    "distance_parsecs": 12.42988881,
    "eccentricity": 0.0051,
    "emission_spectroscopy_metric": 0.2,
    "equilibrium_temperature_k": 249.7,
    "host_star": "TRAPPIST-1",
    "inclination_deg": 89.793,
    "insolation_earth": 0.646,
    "jwst_observations": 21,
    "letter": "e",
    "mass_earth": 0.692,
    "mass_jupiter": 0.00217728,
    "mass_kind": "measured",
    "name": "TRAPPIST-1 e",
    "orbital_period_days": 6.101013,
    "planets_in_system": 7,
    "ra_deg": 346.6263919,
    "radial_velocity_amplitude_m_s": null,
    "radius_earth": 0.92,
    "radius_jupiter": 0.08207704,
    "semi_major_axis_au": 0.02925,
    "star": {
      "age_gyr": 7.6,
      "dec_deg": -5.0434618,
      "dec_text": "-05d02m36.46s",
      "distance_light_years": 40.54,
      "distance_parsecs": 12.42988881,
      "gaia_dr3_id": "Gaia DR3 2635476908753563008",
      "hd_name": null,
      "hip_name": null,
      "luminosity_log_sun": -3.25727,
      "mass_sun": 0.0898,
      "metallicity_dex": 0.052,
      "moons_in_system": 0,
      "name": "TRAPPIST-1",
      "planets_in_system": 7,
      "ra_deg": 346.6263919,
      "ra_text": "23h06m30.33s",
      "radius_sun": 0.1192,
      "spectral_type": "M8.0 V",
      "stars_in_system": 1,
      "surface_gravity_log_g": 5.2396,
      "temperature_k": 2566.0,
      "tic_id": "TIC 278892590",
      "url": "https://exoplanetarchive.ipac.caltech.edu/overview/TRAPPIST-1",
      "v_magnitude": 17.02
    },
    "star_mass_sun": 0.0898,
    "star_radius_sun": 0.1192,
    "star_spectral_type": "M8.0 V",
    "star_temperature_k": 2566.0,
    "stars_in_system": 1,
    "summary": "TRAPPIST-1 e: 0.92 Earth radii, orbits TRAPPIST-1 every 6.1 days, 40.54 light-years away. Found by Transit in 2017.",
    "transit_depth_percent": 0.5012,
    "transit_duration_hours": 0.9293,
    "transmission_spectroscopy_metric": 20.1,
    "url": "https://exoplanetarchive.ipac.caltech.edu/overview/TRAPPIST-1%20e"
  },
  "query": "trappist-1e",
  "summary": "TRAPPIST-1 e: 0.92 Earth radii, orbits TRAPPIST-1 every 6.1 days, 40.54 light-years away. Found by Transit in 2017."
}
```

### Get a random planet

Get a confirmed exoplanet picked at random, with everything the archive has on it: for a 'planet of the day' post or a quiz. Optionally only planets found by one method. No API key required.

**Inputs**

- Discovery method (`discovery_method`, text): Only planets found this way, such as Transit or Radial Velocity. Leave empty for every method.

**Outputs**

- `picked_from` (number): How many planets it was picked from.
- `planet` (object): The planet picked.
- `summary` (text): One line describing the answer.

**Example output**

```json
{
  "picked_from": 98,
  "planet": {
    "circumbinary": false,
    "controversial": false,
    "dec_deg": 30.5510888,
    "density_g_cm3": 8.05,
    "detection_methods": [
      "Imaging"
    ],
    "discovery": {
      "facility": "Subaru Telescope",
      "instrument": "Subaru Coronagraphic Extreme Adaptive Optics (SCExAO)",
      "locale": "Ground",
      "method": "Imaging",
      "published": "2022-04",
      "reference": "Currie et al. 2022",
      "reference_url": "https://ui.adsabs.harvard.edu/abs/2022NatAs...6..751C/abstract",
      "telescope": "8.2 m Subaru Telescope",
      "year": 2022
    },
    "discovery_facility": "Subaru Telescope",
    "discovery_method": "Imaging",
    "discovery_year": 2022,
    "distance_light_years": 528.79,
    "distance_parsecs": 162.127,
    "eccentricity": 0.4,
    "emission_spectroscopy_metric": 0.0,
    "equilibrium_temperature_k": 83.63,
    "host_star": "AB Aur",
    "inclination_deg": 42.6,
    "insolation_earth": 0.0067,
    "jwst_observations": 0,
    "letter": "b",
    "mass_earth": 2860.455663,
    "mass_jupiter": 9.0,
    "mass_kind": "measured",
    "name": "AB Aur b",
    "orbital_period_days": null,
    "planets_in_system": 1,
    "ra_deg": 73.9410446,
    "radial_velocity_amplitude_m_s": null,
    "radius_earth": 12.5,
    "radius_jupiter": 1.12,
    "semi_major_axis_au": 93.9,
    "star": {
      "age_gyr": 0.003,
      "dec_deg": 30.5510888,
      "dec_text": "+30d33m03.92s",
      "distance_light_years": 528.79,
      "distance_parsecs": 162.127,
      "gaia_dr3_id": "Gaia DR3 156917493449670656",
      "hd_name": null,
      "hip_name": null,
      "luminosity_log_sun": 1.77085,
      "mass_sun": 2.4,
      "metallicity_dex": null,
      "moons_in_system": 0,
      "name": "AB Aur",
      "planets_in_system": 1,
      "ra_deg": 73.9410446,
      "ra_text": "04h55m45.85s",
      "radius_sun": 2.95887,
      "spectral_type": null,
      "stars_in_system": 1,
      "surface_gravity_log_g": 3.77411,
      "temperature_k": 9770.0,
      "tic_id": "TIC 96680681",
      "url": "https://exoplanetarchive.ipac.caltech.edu/overview/AB%20Aur",
      "v_magnitude": 7.076
    },
    "star_mass_sun": 2.4,
    "star_radius_sun": 2.95887,
    "star_spectral_type": null,
    "star_temperature_k": 9770.0,
    "stars_in_system": 1,
    "summary": "AB Aur b: 12.5 Earth radii, orbits AB Aur, 528.79 light-years away. Found by Imaging in 2022.",
    "transit_depth_percent": null,
    "transit_duration_hours": null,
    "transmission_spectroscopy_metric": null,
    "url": "https://exoplanetarchive.ipac.caltech.edu/overview/AB%20Aur%20b"
  },
  "summary": "AB Aur b: 12.5 Earth radii, orbits AB Aur, 528.79 light-years away. Found by Imaging in 2022."
}
```

### Get a star system

Get a star and every confirmed planet orbiting it, innermost first: the star's type, temperature, size, mass, age and distance, and each planet's size and orbit. A star the archive doesn't list comes back with 'found' set to false. No API key required.

**Inputs**

- Star name (`host`, text, required): The star's name as the archive writes it, such as TRAPPIST-1, Kepler-90 or tau Cet. A planet's name finds its star too.

**Outputs**

- `count` (number): How many rows are listed.
- `found` (true/false): True when the archive has it; false, with nothing else filled, when not.
- `planets` (list): Its planets, innermost first.
- `query` (text): What was looked up, as given.
- `star` (object): The star. Empty when not found.
- `summary` (text): One line describing the answer.

**Example output**

```json
{
  "count": 2,
  "found": true,
  "planets": [
    {
      "dec_deg": -62.6761821,
      "density_g_cm3": 4.31,
      "discovery_facility": "La Silla Observatory",
      "discovery_method": "Radial Velocity",
      "discovery_year": 2025,
      "distance_light_years": 4.24,
      "distance_parsecs": 1.30119,
      "eccentricity": 0.0,
      "equilibrium_temperature_k": 282.0,
      "host_star": "Proxima Cen",
      "insolation_earth": 1.814,
      "letter": "d",
      "mass_earth": 0.26,
      "mass_jupiter": 0.00081805,
      "mass_kind": "minimum (M sin i)",
      "name": "Proxima Cen d",
      "orbital_period_days": 5.12338,
      "planets_in_system": 2,
      "ra_deg": 217.3934657,
      "radius_earth": 0.692,
      "radius_jupiter": 0.0618,
      "semi_major_axis_au": 0.02881,
      "star_mass_sun": 0.1221,
      "star_radius_sun": 0.141,
      "star_spectral_type": "M5.5 V",
      "star_temperature_k": 2900.0,
      "stars_in_system": 3,
      "summary": "Proxima Cen d: 0.69 Earth radii, orbits Proxima Cen every 5.1 days, 4.24 light-years away. Found by Radial Velocity in 2025.",
      "url": "https://exoplanetarchive.ipac.caltech.edu/overview/Proxima%20Cen%20d"
    },
    {
      "dec_deg": -62.6761821,
      "density_g_cm3": 5.46,
      "discovery_facility": "European Southern Observatory",
      "discovery_method": "Radial Velocity",
      "discovery_year": 2016,
      "distance_light_years": 4.24,
      "distance_parsecs": 1.30119,
      "eccentricity": 0.0,
      "equilibrium_temperature_k": 218.0,
      "host_star": "Proxima Cen",
      "insolation_earth": 0.641,
      "letter": "b",
      "mass_earth": 1.055,
      "mass_jupiter": 0.0033194,
      "mass_kind": "minimum (M sin i)",
      "name": "Proxima Cen b",
      "orbital_period_days": 11.18465,
      "planets_in_system": 2,
      "ra_deg": 217.3934657,
      "radius_earth": 1.02,
      "radius_jupiter": 0.0913,
      "semi_major_axis_au": 0.04848,
      "star_mass_sun": 0.1221,
      "star_radius_sun": 0.141,
      "star_spectral_type": "M5.5 V",
      "star_temperature_k": 2900.0,
      "stars_in_system": 3,
      "summary": "Proxima Cen b: 1.02 Earth radii, orbits Proxima Cen every 11.2 days, 4.24 light-years away. Found by Radial Velocity in 2016.",
      "url": "https://exoplanetarchive.ipac.caltech.edu/overview/Proxima%20Cen%20b"
    }
  ],
  "query": "Proxima Cen b",
  "star": {
    "age_gyr": null,
    "dec_deg": -62.6761821,
    "dec_text": "-62d40m34.26s",
    "distance_light_years": 4.24,
    "distance_parsecs": 1.30119,
    "gaia_dr3_id": "Gaia DR3 5853498713190525696",
    "hd_name": null,
    "hip_name": "HIP 70890",
    "luminosity_log_sun": -2.82102,
    "mass_sun": 0.1221,
    "metallicity_dex": null,
    "moons_in_system": 0,
    "name": "Proxima Cen",
    "planets_in_system": 2,
    "ra_deg": 217.3934657,
    "ra_text": "14h29m34.43s",
    "radius_sun": 0.141,
    "spectral_type": "M5.5 V",
    "stars_in_system": 3,
    "surface_gravity_log_g": 5.16372,
    "temperature_k": 2900.0,
    "tic_id": "TIC 388857263",
    "url": "https://exoplanetarchive.ipac.caltech.edu/overview/Proxima%20Cen",
    "v_magnitude": 11.01
  },
  "summary": "Proxima Cen, 4.24 light-years away: 2 confirmed planets (Proxima Cen d, Proxima Cen b)."
}
```

### List newly confirmed planets

List the planets the archive added as confirmed since a day (30 days ago unless you choose), newest first, with the day each was added. The archive adds planets weekly. No API key required.

**Inputs**

- Added since (`since`, date): Only planets the archive added as confirmed on or after this day. Defaults to 30 days ago; the archive adds planets weekly.
- Discovery method (`discovery_method`, text): Only planets found this way, such as Transit or Radial Velocity. Leave empty for every method.
- Most rows (`limit`, number): The most planets to return, 1 to 300. Defaults to 50. From 1 to 300. Default: `50`.

**Outputs**

- `count` (number): How many rows are listed.
- `has_more` (true/false): True when more matched than 'Most rows' allowed: raise it or narrow the search to see the rest.
- `planets` (list): The planets, most recently added first.
- `since` (text): The day listed from, as YYYY-MM-DD.
- `summary` (text): One line describing the answer.

**Example output**

```json
{
  "count": 2,
  "has_more": true,
  "planets": [
    {
      "dec_deg": -24.2705088,
      "density_g_cm3": 2.24,
      "discovery_facility": "W. M. Keck Observatory",
      "discovery_method": "Imaging",
      "discovery_year": 2026,
      "distance_light_years": 442.74,
      "distance_parsecs": 135.745,
      "eccentricity": 0.0,
      "equilibrium_temperature_k": null,
      "first_released": "2026-10-15",
      "host_star": "Elias 2-24",
      "insolation_earth": null,
      "letter": "b",
      "mass_earth": 937.59380065,
      "mass_jupiter": 2.95,
      "mass_kind": "measured",
      "name": "Elias 2-24 b",
      "orbital_period_days": null,
      "planets_in_system": 1,
      "ra_deg": 246.6003317,
      "radius_earth": 13.2,
      "radius_jupiter": 1.17,
      "semi_major_axis_au": 54.9,
      "star_mass_sun": 0.78,
      "star_radius_sun": null,
      "star_spectral_type": "K6",
      "star_temperature_k": 4483.0,
      "stars_in_system": 1,
      "summary": "Elias 2-24 b: 13.2 Earth radii, orbits Elias 2-24, 442.74 light-years away. Found by Imaging in 2026.",
      "url": "https://exoplanetarchive.ipac.caltech.edu/overview/Elias%202-24%20b"
    },
    {
      "dec_deg": 71.8429482,
      "density_g_cm3": 1.95,
      "discovery_facility": "Transiting Exoplanet Survey Satellite (TESS)",
      "discovery_method": "Transit",
      "discovery_year": 2026,
      "distance_light_years": 1338.72,
      "distance_parsecs": 410.453,
      "eccentricity": null,
      "equilibrium_temperature_k": null,
      "first_released": "2026-10-15",
      "host_star": "TIC 219893931",
      "insolation_earth": null,
      "letter": "b",
      "mass_earth": 8.85,
      "mass_jupiter": 0.0279,
      "mass_kind": "estimated from the radius",
      "name": "TIC 219893931 b",
      "orbital_period_days": 6.410389,
      "planets_in_system": 1,
      "ra_deg": 262.562118,
      "radius_earth": 2.92,
      "radius_jupiter": 0.2605054,
      "semi_major_axis_au": null,
      "star_mass_sun": 1.14,
      "star_radius_sun": 1.284,
      "star_spectral_type": null,
      "star_temperature_k": 5956.0,
      "stars_in_system": 1,
      "summary": "TIC 219893931 b: 2.92 Earth radii, orbits TIC 219893931 every 6.4 days, 1,338.72 light-years away. Found by Transit in 2026.",
      "url": "https://exoplanetarchive.ipac.caltech.edu/overview/TIC%20219893931%20b"
    }
  ],
  "since": "2026-10-10",
  "summary": "2 planets added to the archive as confirmed since 2026-10-10. More match: raise 'Most rows' or narrow the search."
}
```

### List recently updated planets

List the planets whose parameters the archive added or revised since a day (14 days ago unless you choose), such as a new mass or radius from a new paper, most recent first. Newly added planets are included. No API key required.

**Inputs**

- Updated since (`since`, date): Only planets whose parameters were added or revised on or after this day. Defaults to 14 days ago.
- Most rows (`limit`, number): The most planets to return, 1 to 300. Defaults to 50. From 1 to 300. Default: `50`.

**Outputs**

- `count` (number): How many rows are listed.
- `has_more` (true/false): True when more matched than 'Most rows' allowed: raise it or narrow the search to see the rest.
- `planets` (list): The planets, most recently updated first.
- `since` (text): The day listed from, as YYYY-MM-DD.
- `summary` (text): One line describing the answer.

**Example output**

```json
{
  "count": 2,
  "has_more": true,
  "planets": [
    {
      "dec_deg": -24.2705088,
      "density_g_cm3": 2.24,
      "discovery_facility": "W. M. Keck Observatory",
      "discovery_method": "Imaging",
      "discovery_year": 2026,
      "distance_light_years": 442.74,
      "distance_parsecs": 135.745,
      "eccentricity": 0.0,
      "equilibrium_temperature_k": null,
      "host_star": "Elias 2-24",
      "insolation_earth": null,
      "last_updated": "2026-10-15",
      "letter": "b",
      "mass_earth": 937.59380065,
      "mass_jupiter": 2.95,
      "mass_kind": "measured",
      "name": "Elias 2-24 b",
      "orbital_period_days": null,
      "planets_in_system": 1,
      "ra_deg": 246.6003317,
      "radius_earth": 13.2,
      "radius_jupiter": 1.17,
      "semi_major_axis_au": 54.9,
      "star_mass_sun": 0.78,
      "star_radius_sun": null,
      "star_spectral_type": "K6",
      "star_temperature_k": 4483.0,
      "stars_in_system": 1,
      "summary": "Elias 2-24 b: 13.2 Earth radii, orbits Elias 2-24, 442.74 light-years away. Found by Imaging in 2026.",
      "updated_solutions": 1,
      "url": "https://exoplanetarchive.ipac.caltech.edu/overview/Elias%202-24%20b"
    },
    {
      "dec_deg": -46.7147234,
      "density_g_cm3": 2.4,
      "discovery_facility": "Transiting Exoplanet Survey Satellite (TESS)",
      "discovery_method": "Transit",
      "discovery_year": 2022,
      "distance_light_years": 73.3,
      "distance_parsecs": 22.4751,
      "eccentricity": 0.25,
      "equilibrium_temperature_k": 723.0,
      "host_star": "GJ 3090",
      "insolation_earth": 45.4,
      "last_updated": "2026-10-15",
      "letter": "b",
      "mass_earth": 4.52,
      "mass_jupiter": 0.01422151,
      "mass_kind": "measured",
      "name": "GJ 3090 b",
      "orbital_period_days": 2.85310198,
      "planets_in_system": 2,
      "ra_deg": 20.4384281,
      "radius_earth": 2.18,
      "radius_jupiter": 0.19448691,
      "semi_major_axis_au": 0.0316,
      "star_mass_sun": 0.519,
      "star_radius_sun": 0.516,
      "star_spectral_type": "M2 V",
      "star_temperature_k": 3707.0,
      "stars_in_system": 1,
      "summary": "GJ 3090 b: 2.18 Earth radii, orbits GJ 3090 every 2.9 days, 73.3 light-years away. Found by Transit in 2022.",
      "updated_solutions": 1,
      "url": "https://exoplanetarchive.ipac.caltech.edu/overview/GJ%203090%20b"
    }
  ],
  "since": "2026-10-14",
  "summary": "2 planets with parameters added or revised since 2026-10-14. More match: raise 'Most rows' or narrow the search."
}
```

### List TESS Objects of Interest

List TESS Objects of Interest (TOIs), the planet candidates found by NASA's TESS mission, with their disposition (planet candidate, confirmed, false positive and so on), size, orbit and star. Filter by disposition, TOI or TIC number, size, distance, or when they were created or updated. No API key required.

**Inputs**

- Dispositions (`dispositions`, list): Only TOIs with one of these verdicts from the TESS Follow-up Observing Program. Leave empty for all. One or more of: `PC` (Planet candidate), `CP` (Confirmed planet), `KP` (Known planet, found before TESS), `APC` (Ambiguous planet candidate), `FP` (False positive), `FA` (False alarm).
- TOI number (`toi`, text): One star's TOIs, such as 700, or one TOI, such as 700.01. 'TOI-' in front is fine.
- TIC number (`tic_id`, text): Only TOIs of the star with this TESS Input Catalog number.
- Created since (`created_since`, date): Only TOIs created on or after this day.
- Updated since (`updated_since`, date): Only TOIs changed on or after this day, such as a new disposition.
- Largest radius (Earth radii) (`max_radius_earth`, number): Only candidates at most this big, in Earth radii. From 0 to 1000.0.
- Farthest (parsecs) (`max_distance_parsecs`, number): Only candidates whose star is at most this far, in parsecs. From 0 to 100000.0.
- Sort by (`sort`, text): The order to list them in. Sorting on a measurement lists only TOIs that have it. Defaults to newest first. One of: `created` (Newest first), `updated` (Recently updated first), `smallest` (Smallest planet first), `shortest_orbit` (Shortest orbit first), `nearest` (Nearest star first), `brightest` (Brightest star first). Default: `created`.
- Most rows (`limit`, number): The most TOIs to return, 1 to 1,000. Defaults to 50. From 1 to 1000. Default: `50`.

**Outputs**

- `adql` (text): The ADQL query sent to the archive, to reuse or adapt in 'Run an ADQL query'.
- `count` (number): How many rows are listed.
- `has_more` (true/false): True when more matched than 'Most rows' allowed: raise it or narrow the search to see the rest.
- `sort` (text): The sort used.
- `summary` (text): One line describing the answer.
- `tois` (list): The TOIs, in the order asked for.

**Example output**

```json
{
  "adql": "select toi, toipfx, tid, tfopwg_disp, pl_pnum, pl_orbper, pl_trandurh, pl_trandep, pl_rade, pl_insol, pl_eqt, st_dist, st_teff, st_rad, st_tmag, ra, dec, toi_created, rowupdate from toi where tfopwg_disp in ('PC') order by toi_created desc, toi",
  "count": 2,
  "has_more": true,
  "sort": "created",
  "summary": "Found 2 TESS Objects of Interest. More match: raise 'Most rows' or narrow the search.",
  "tois": [
    {
      "candidates_for_star": 1,
      "created": "2026-08-27 20:16:53",
      "dec_deg": -39.314925,
      "disposition": "PC",
      "disposition_label": "Planet candidate",
      "equilibrium_temperature_k": 793.0208267,
      "exofop_url": "https://exofop.ipac.caltech.edu/tess/target.php?id=225040372",
      "host_toi": "TOI-7926",
      "insolation_earth": 65.6546988,
      "name": "TOI-7926.01",
      "orbital_period_days": 7.5760123,
      "ra_deg": 257.870686,
      "radius_earth": 2.4217545,
      "star_distance_parsecs": 73.4288,
      "star_radius_sun": 0.798331,
      "star_temperature_k": 4790.0,
      "summary": "TOI-7926.01: Planet candidate, 2.42 Earth radii, every 7.6 days.",
      "tess_magnitude": 9.8401,
      "tic_id": 225040372,
      "toi": "7926.01",
      "transit_depth_ppm": 1195.7932493,
      "transit_duration_hours": 1.6845624,
      "updated": "2026-08-28 12:06:31"
    },
    {
      "candidates_for_star": 1,
      "created": "2026-08-27 20:16:53",
      "dec_deg": -85.975009,
      "disposition": "PC",
      "disposition_label": "Planet candidate",
      "equilibrium_temperature_k": 1849.2565414,
      "exofop_url": "https://exofop.ipac.caltech.edu/tess/target.php?id=346792281",
      "host_toi": "TOI-7927",
      "insolation_earth": 1941.404784,
      "name": "TOI-7927.01",
      "orbital_period_days": 1.7154769,
      "ra_deg": 289.06346,
      "radius_earth": 3.4806507,
      "star_distance_parsecs": 293.296,
      "star_radius_sun": 1.83081,
      "star_temperature_k": 5899.0,
      "summary": "TOI-7927.01: Planet candidate, 3.48 Earth radii, every 1.7 days.",
      "tess_magnitude": 10.3403,
      "tic_id": 346792281,
      "toi": "7927.01",
      "transit_depth_ppm": 339.7294407,
      "transit_duration_hours": 1.2602108,
      "updated": "2026-08-28 12:06:31"
    }
  ]
}
```

### Look up Kepler and K2 names

Find a Kepler or K2 planet's other names: its Kepler Object of Interest (KOI), Kepler or K2 name, star number (KIC or EPIC) and the name the archive files it under. Give any one of them, or a star's to list its planets. Nothing found comes back with 'found' set to false. No API key required.

**Inputs**

- Name or number (`identifier`, text, required): A KOI such as KOI-571.05 (or KOI-571 for the star), a Kepler or K2 name such as Kepler-186 f or K2-18 b, or a star number such as KIC 8120608 or EPIC 211529065.

**Outputs**

- `count` (number): How many rows are listed.
- `found` (true/false): True when the archive has it; false, with nothing else filled, when not.
- `matches` (list): Each matching planet's names.
- `query` (text): What was looked up, as given.
- `summary` (text): One line describing the answer.

**Example output**

```json
{
  "count": 1,
  "found": true,
  "matches": [
    {
      "candidate_name": "K00571.05",
      "koi": "KOI-571.05",
      "mission": "Kepler",
      "mission_name": "Kepler-186 f",
      "planet_name": "Kepler-186 f",
      "star_id": "KIC 8120608"
    }
  ],
  "query": "KOI-571.05",
  "summary": "Kepler-186 f (KOI-571.05, KIC 8120608)"
}
```

### Run an ADQL query

For researchers: run your own ADQL (the archive's SQL) SELECT on its catalogue tables of planets, stars, TESS and Kepler candidates, and get the rows back as they come, up to 1,000. No API key required.

**Inputs**

- ADQL query (`query`, text, required): One ADQL SELECT on the archive's catalogue tables: ps, pscomppars, stellarhosts, toi, keplernames, k2names, k2pandc, ml, cumulative, td, spectra, nexolist, di_stars_exep, keplerstellar, k2targets, or TAP_SCHEMA.columns for their columns. Use 'Most rows' rather than TOP, which the archive applies before ORDER BY.
- Most rows (`max_rows`, number): The most rows to return, 1 to 1,000. Defaults to 100. From 1 to 1000. Default: `100`.

**Outputs**

- `adql` (text): The ADQL query sent to the archive, to reuse or adapt in 'Run an ADQL query'.
- `columns` (list): The column names, in order.
- `count` (number): How many rows are listed.
- `has_more` (true/false): True when more matched than 'Most rows' allowed: raise it or narrow the search to see the rest.
- `rows` (list): The rows, as the archive returned them.
- `summary` (text): One line describing the answer.

**Example output**

```json
{
  "adql": "select distinct hostname, sy_pnum, sy_dist from pscomppars where sy_pnum >= 6 order by sy_pnum desc, hostname",
  "columns": [
    "hostname",
    "sy_pnum",
    "sy_dist"
  ],
  "count": 3,
  "has_more": true,
  "rows": [
    {
      "hostname": "KOI-351",
      "sy_dist": 848.254,
      "sy_pnum": 8
    },
    {
      "hostname": "55 Cnc",
      "sy_dist": 12.5855,
      "sy_pnum": 7
    },
    {
      "hostname": "55 Cnc B",
      "sy_dist": 12.4773,
      "sy_pnum": 7
    }
  ],
  "summary": "The query returned 3 rows. More match: raise 'Most rows' or narrow the search."
}
```

### Search planets

Search the confirmed exoplanets by any mix of name, discovery method, facility and year, host star type, radius, mass, orbit, temperature and distance, sorted as you choose: the nearest planets, Earth-sized ones, a year's discoveries, the hottest giants. Each planet comes with its size, orbit, temperature, distance, star and discovery. No API key required.

**Inputs**

- Name contains (`name_contains`, text): Only planets whose name, or their star's name, contains this text, ignoring case, such as TRAPPIST or Kepler-186.
- Discovery method (`discovery_method`, text): Only planets found this way, such as Transit or Radial Velocity. Leave empty for every method.
- Discovery facility (`discovery_facility`, text): Only planets found by this observatory or mission, such as Kepler, K2 or TESS. Leave empty for every facility.
- Discovered from year (`discovered_from_year`, number): Only planets discovered in this year or later, such as 2020. From 1989 to 2027.
- Discovered up to year (`discovered_to_year`, number): Only planets discovered in this year or earlier. Set both years to the same one for a single year's discoveries. From 1989 to 2027.
- Host star type (`star_type`, text): Only planets orbiting this type of star, judged by the star's temperature, such as G for stars like the Sun. One of: `M` (M: red dwarf, cooler than 3,700 K), `K` (K: orange dwarf, 3,700 to 5,200 K), `G` (G: like the Sun, 5,200 to 6,000 K), `F` (F: 6,000 to 7,500 K), `A` (A: 7,500 to 10,000 K), `BO` (B or O: hotter than 10,000 K).
- Smallest radius (Earth radii) (`min_radius_earth`, number): Only planets at least this big, in Earth radii (Earth is 1, Jupiter 11.2). From 0 to 1000.0.
- Largest radius (Earth radii) (`max_radius_earth`, number): Only planets at most this big, in Earth radii. 1.6 keeps to rocky sizes. From 0 to 1000.0.
- Smallest mass (Earth masses) (`min_mass_earth`, number): Only planets at least this heavy, in Earth masses (Jupiter is 318). From 0 to 100000.0.
- Largest mass (Earth masses) (`max_mass_earth`, number): Only planets at most this heavy, in Earth masses. From 0 to 100000.0.
- Shortest orbit (days) (`min_orbital_period_days`, number): Only planets taking at least this many days to orbit their star. From 0 to 100000000.0.
- Longest orbit (days) (`max_orbital_period_days`, number): Only planets taking at most this many days to orbit their star (Earth: 365). From 0 to 100000000.0.
- Coolest (kelvin) (`min_temperature_k`, number): Only planets with an equilibrium temperature of at least this, in kelvin. From 0 to 100000.0.
- Hottest (kelvin) (`max_temperature_k`, number): Only planets with an equilibrium temperature of at most this, in kelvin (Earth's is about 255). From 0 to 100000.0.
- Farthest (parsecs) (`max_distance_parsecs`, number): Only planets at most this far from Earth, in parsecs (1 parsec is 3.26 light-years). From 0 to 100000.0.
- Sort by (`sort`, text): The order to list them in. Sorting on a measurement lists only planets that have it. Defaults to planet name. One of: `name` (Planet name, A to Z), `newest` (Newest discoveries first), `oldest` (Oldest discoveries first), `nearest` (Nearest to Earth first), `farthest` (Farthest from Earth first), `smallest` (Smallest radius first), `largest` (Largest radius first), `lightest` (Lightest mass first), `heaviest` (Heaviest mass first), `shortest_orbit` (Shortest orbit first), and 3 more. Default: `name`.
- Most rows (`limit`, number): The most planets to return, 1 to 1,000. Defaults to 50. From 1 to 1000. Default: `50`.

**Outputs**

- `adql` (text): The ADQL query sent to the archive, to reuse or adapt in 'Run an ADQL query'.
- `count` (number): How many rows are listed.
- `has_more` (true/false): True when more matched than 'Most rows' allowed: raise it or narrow the search to see the rest.
- `planets` (list): The planets, in the order asked for.
- `sort` (text): The sort used.
- `summary` (text): One line describing the answer.

**Example output**

```json
{
  "adql": "select pl_name, hostname, pl_letter, discoverymethod, disc_year, disc_facility, pl_orbper, pl_orbsmax, pl_orbeccen, pl_rade, pl_radj, pl_bmasse, pl_bmassj, pl_bmassprov, pl_dens, pl_eqt, pl_insol, sy_dist, st_spectype, st_teff, st_rad, st_mass, sy_pnum, sy_snum, ra, dec from pscomppars where pl_rade >= 0.8 and pl_rade <= 1.25 and sy_dist is not null order by sy_dist, pl_name",
  "count": 2,
  "has_more": true,
  "planets": [
    {
      "dec_deg": -62.6761821,
      "density_g_cm3": 5.46,
      "discovery_facility": "European Southern Observatory",
      "discovery_method": "Radial Velocity",
      "discovery_year": 2016,
      "distance_light_years": 4.24,
      "distance_parsecs": 1.30119,
      "eccentricity": 0.0,
      "equilibrium_temperature_k": 218.0,
      "host_star": "Proxima Cen",
      "insolation_earth": 0.641,
      "letter": "b",
      "mass_earth": 1.055,
      "mass_jupiter": 0.0033194,
      "mass_kind": "minimum (M sin i)",
      "name": "Proxima Cen b",
      "orbital_period_days": 11.18465,
      "planets_in_system": 2,
      "ra_deg": 217.3934657,
      "radius_earth": 1.02,
      "radius_jupiter": 0.0913,
      "semi_major_axis_au": 0.04848,
      "star_mass_sun": 0.1221,
      "star_radius_sun": 0.141,
      "star_spectral_type": "M5.5 V",
      "star_temperature_k": 2900.0,
      "stars_in_system": 3,
      "summary": "Proxima Cen b: 1.02 Earth radii, orbits Proxima Cen every 11.2 days, 4.24 light-years away. Found by Radial Velocity in 2016.",
      "url": "https://exoplanetarchive.ipac.caltech.edu/overview/Proxima%20Cen%20b"
    },
    {
      "dec_deg": -35.8473489,
      "density_g_cm3": 5.71,
      "discovery_facility": "Multiple Observatories",
      "discovery_method": "Radial Velocity",
      "discovery_year": 2026,
      "distance_light_years": 10.72,
      "distance_parsecs": 3.28679,
      "eccentricity": null,
      "equilibrium_temperature_k": 544.0,
      "host_star": "GJ 887",
      "insolation_earth": 20.9,
      "letter": "e",
      "mass_earth": 1.46,
      "mass_jupiter": 0.00459367,
      "mass_kind": "minimum (M sin i)",
      "name": "GJ 887 e",
      "orbital_period_days": 4.4249,
      "planets_in_system": 4,
      "ra_deg": 346.5027573,
      "radius_earth": 1.12,
      "radius_jupiter": 0.0999,
      "semi_major_axis_au": 0.0417,
      "star_mass_sun": 0.495,
      "star_radius_sun": 0.468,
      "star_spectral_type": "M1 V",
      "star_temperature_k": 3688.0,
      "stars_in_system": 1,
      "summary": "GJ 887 e: 1.12 Earth radii, orbits GJ 887 every 4.4 days, 10.72 light-years away. Found by Radial Velocity in 2026.",
      "url": "https://exoplanetarchive.ipac.caltech.edu/overview/GJ%20887%20e"
    }
  ],
  "sort": "nearest",
  "summary": "Found 2 planets. More match: raise 'Most rows' or narrow the search."
}
```
