<p>As I commented, the information is in the Wikipedia table, but hidden in a wiki-link.  But with some text editing, one can extract it.</p>
<p>Trappist1-b doesn't appear in the Wikipedia table, and it isn't indicated as being an exoplanet that has received a proper name yet.</p>
<p>The database begins as below, the rest can be found in <a href="https://gist.github.com/zeimusu/3f775cae237b94fa8cd13b2a3fdfc687" rel="nofollow noreferrer">this table</a>:</p>
<div class="s-table-container">
<table class="s-table">
<thead>
<tr>
<th>Identification</th>
<th>Proper name</th>
</tr>
</thead>
<tbody>
<tr>
<td>14 Andromedae b</td>
<td>Spe</td>
</tr>
<tr>
<td>18 Delphini b</td>
<td>Arion</td>
</tr>
<tr>
<td>41 Lyncis b</td>
<td>Arkas</td>
</tr>
<tr>
<td>42 Draconis b</td>
<td>Orbitar</td>
</tr>
<tr>
<td>47 Ursae Majoris b</td>
<td>Taphao Thong</td>
</tr>
<tr>
<td>47 Ursae Majoris c</td>
<td>Taphao Kaew</td>
</tr>
<tr>
<td>51 Pegasi b</td>
<td>Dimidium</td>
</tr>
<tr>
<td>55 Cancri b</td>
<td>Galileo</td>
</tr>
<tr>
<td>55 Cancri c</td>
<td>Brahe</td>
</tr>
<tr>
<td>55 Cancri d</td>
<td>Lipperhey</td>
</tr>
<tr>
<td>55 Cancri e</td>
<td>Janssen</td>
</tr>
<tr>
<td>55 Cancri f</td>
<td>Harriot</td>
</tr>
<tr>
<td>Epsilon Eridani b</td>
<td>Ægir</td>
</tr>
<tr>
<td>Epsilon Tauri b</td>
<td>Amateru</td>
</tr>
</tbody>
</table>
</div>
CC BY-SA 4.0
2022-04-08T13:33:03.503Z
Thank you, I'm just surprised the list is so short given that there have been about 5,000 exoplanets discovered so far.
Joe Molnar
CC BY-SA 4.0
2022-04-08T15:54:19.743Z
Most don't have proper names, most probably will never have proper names. But note that the full linked list is about 145 names, not the dozen or so listed above.
James K
CC BY-SA 4.0
2022-04-07T15:41:26.983Z
2022-04-07T15:41:26.983Z
James K
<p>For a project I am working on, I use data from the NASA Exoplanet Archive at
<a href="https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+*+from+ps&amp;format=json" rel="nofollow noreferrer">https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+*+from+ps&amp;format=json</a></p>
<p>I take this json data down and import it to an sql database.
What's missing is the common planet name. The kind of name I find at <a href="https://en.wikipedia.org/wiki/List_of_proper_names_of_exoplanets" rel="nofollow noreferrer">https://en.wikipedia.org/wiki/List_of_proper_names_of_exoplanets</a>.
I am looking for a table of common names keyed with the official designation so I can run a 1-to-1 match, e.g. &quot;TRAPPIST-1 b&quot;
As a bonus, it would be nice find a table witgh exoplanet type, i.e. Hot-Jupiter, super-earth, etc.
Thank you</p>

CC BY-SA 4.0
2022-04-07T04:47:40.030Z
That information is in the wikipedia table, in the form of a wiki link to the planet's page.
James K
<exoplanet><nasa>
Data base of exoplanets with common names to use beside Nasa Exoplanet Archive
Joe Molnar
# Data base of exoplanets with common names to use beside Nasa Exoplanet Archive

(Asked by: username_0 on 2022-04-06)

For a project I am working on, I use data from the NASA Exoplanet Archive at
[https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+\*+from+ps&format=json](https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+*+from+ps&format=json)

I take this json data down and import it to an sql database.
What's missing is the common planet name. The kind of name I find at <https://en.wikipedia.org/wiki/List_of_proper_names_of_exoplanets>.
I am looking for a table of common names keyed with the official designation so I can run a 1-to-1 match, e.g. "TRAPPIST-1 b"
As a bonus, it would be nice find a table witgh exoplanet type, i.e. Hot-Jupiter, super-earth, etc.
Thank you

**Tags:** exoplanet, nasa

> **Comments:**
> **username_1**: That information is in the wikipedia table, in the form of a wiki link to the planet's page.  

---

## 1 answers

### Answer by username_1 on 2022-04-07. Score: 2

As I commented, the information is in the Wikipedia table, but hidden in a wiki-link. But with some text editing, one can extract it.

Trappist1-b doesn't appear in the Wikipedia table, and it isn't indicated as being an exoplanet that has received a proper name yet.

The database begins as below, the rest can be found in [this table](https://gist.github.com/zeimusu/3f775cae237b94fa8cd13b2a3fdfc687):

| Identification | Proper name |
| --- | --- |
| 14 Andromedae b | Spe |
| 18 Delphini b | Arion |
| 41 Lyncis b | Arkas |
| 42 Draconis b | Orbitar |
| 47 Ursae Majoris b | Taphao Thong |
| 47 Ursae Majoris c | Taphao Kaew |
| 51 Pegasi b | Dimidium |
| 55 Cancri b | Galileo |
| 55 Cancri c | Brahe |
| 55 Cancri d | Lipperhey |
| 55 Cancri e | Janssen |
| 55 Cancri f | Harriot |
| Epsilon Eridani b | Ægir |
| Epsilon Tauri b | Amateru |

> **Comments:**
> **username_0**: Thank you, I'm just surprised the list is so short given that there have been about 5,000 exoplanets discovered so far.  
> **username_1**: Most don't have proper names, most probably will never have proper names. But note that the full linked list is about 145 names, not the dozen or so listed above.  

---

