Data Columns in the Combined Table
The following table lists all of the data columns in the table containing data from both the Kepler Planetary Candidates and Confirmed Planets tables. Use this page as a reference when using the Exoplanet Archive's application programming interface.
There are similar documents specifically for each table: Confirmed Planets and Kepler Planetary Candidates.
Some data include more specific information that can also be retrieved as separate calls in the API. These include:
- Uncertainties (positive and negative)
- Limits
- Flags
- Number of Measurements
| Database Column Name |
Table Label | Description | Uncertainties Column (positive +) (negative -) |
Limit Column | Flag Column | Number of Measurements |
|---|---|---|---|---|---|---|
| ra | RA | Right Ascension (deg) | st_posn | |||
| dec | Dec | Declination (deg) | st_posn | |||
| pl_eqt | Planet Equilibrium | Planet Equilibrium Temperature (K) | (+) pl_eqterr1 (-) pl_eqterr2 |
pl_eqtlim | ||
| pl_msinie | Planet Mass*sin(i) in Earth Masses | Planet Mass*sin(i) in Earth Masses | (+) pl_msinieerr1 (-) pl_msinieerr2 |
pl_msinin | ||
| pl_msinij | Planet Mass*sin(i) in Jupiter Masses | Planet Mass*sin(i) in Jupiter Masses | (+) pl_msinijerr1 (-) pl_msinijerr2 |
pl_msinin | ||
| pl_massj | Planet Mass (value) | Planet Mass (Jupiter) | (+) pl_massjerr1 (-) pl_massjerr2 |
pl_massjlim | pl_massn | |
| pl_masslim | Planet Mass (limit flag) | Planet Mass Limit Flag: 0 = '=' +1 = '>' -1 = '<' |
||||
| pl_method | Discovery Method | Discovery Method | ||||
| pl_masse | MassE (value) | Planet Mass (Earth) | (+) pl_masseerr1 (-) pl_masseerr2 |
pl_masselim | pl_massn | |
| pl_name | Planet Name | Planet Common Name | ||||
| pl_orbeccen | Eccentricity (value) | Eccentricity | (+) pl_orbeccenerr1 (-) pl_orbeccenerr2 |
pl_orbeccenlim | pl_orbeccenn | |
| pl_orbincl | Inclination (value) | Inclination (deg) | (+) pl_orbinclerr1 (-) pl_orbinclerr2 |
pl_orbincllim | pl_orbincln |
|
| pl_orbper | Period (value) | Orbital Period (days) | (+) pl_orbpererr1 (-) pl_orbpererr2 |
pl_orbperlim | pl_orbpern | |
| pl_orbsmax | Semi-Major Axis (value) | Semi-Major Axis (au) | (+) pl_orbsmaxerr1 (-) pl_orbsmaxerr2 |
pl_orbsmaxlim | pl_orbsmaxn | |
| pl_orbtper | Time of Periastron | Time of Periastron (Julian Days) | (+) pl_orbtpererr1 (-) pl_orbtpererr2 |
pl_orbtperlim | pl_orbtpern | |
| pl_pnum | Number of Planets in System | Number of Planets in System | ||||
| pl_rade | RadiusE (value) | Planet Radius (Earth) | (+) pl_radeerr1 (-) pl_radeerr2 |
pl_radelim | pl_radn | |
| pl_radj | Planet Radius (value) | Planet Radius (Jupiter) | (+) pl_radjerr1 (-) pl_radjerr2 |
pl_radjlim | pl_radn | |
| pl_radlim | Planet Radius (limit flag) | Planet Radius Limit Flag: 0 = '=' +1 = '>' -1 = '<' |
||||
| pl_snum | Number of Planets in System | Number of Planets in System | ||||
| pl_status | Status | Planet Status | ||||
| pl_tranflag | Planet Transit Flag | Transit Flag (1=yes, 0=no) | ||||
| st_elat | Elat [deg] | Ecliptic Latitude (deg) | st_elaterr | st_posn | ||
| st_elon | Elon [deg] | Ecliptic Longitude (deg) | st_posn | |||
| st_glon | Glon [deg] | Galactic Longitude (deg) | st_glonerr | st_posn | ||
| st_glat | Glat [deg | Galactic Latitude (deg) | st_posn | |||
| st_h | H (value) | H (2MASS) system magnitude | st_herr | st_hlim | st_hblend | |
| st_hzrad | Stellar Habitable Zone Radius (au) | Stellar Habitable Zone Radius (au) | ||||
| st_hzang | Stellar Habitable Zone Angular Radius (mas) | Stellar Habitable Zone Angular Radius (mas) | ||||
| st_j | J (value) | J (2MASS) system magnitude | st_jerr | st_jlim | st_jblend | |
| st_k | Ks (value) | K (2MASS) system magnitude | st_kerr | st_klim | st_kblend | |
| st_logg | Stellar Surface Gravity | Stellar Surface Gravity | st_loggerr | st_logglim | st_loggblend | st_loggn |
| st_metfe | Metallicity (value) | [Fe/H] (dex) | st_metfeerr | st_metfelim | st_metfeblend | st_metfen |
| st_plx | Parallax (value) | Parallax (mas) | (+) st_plxerr1 (-) st_plxerr2 |
st_plxlim | st_plxblend | st_plxn |
| st_pmdec | PM Dec (value) | Dec Proper Motion (mas/yr) | st_pmdecerr |
st_pmdeclim | st_pmdecblend | st_pmn |
| st_pmra | PM RA (value) | RA Proper Motion (mas/yr) | (+) st_pmraerr1 (-) st_pmraerr2 |
st_pmralim | st_pmrablend | st_pmn |
| st_pm | PM (value) | Proper Motion (mas/yr) | st_pmerr |
st_pmerrlim | st_pmerrblend | st_pmn |
| st_rad | Radius (value) | Stellar Radius (solar mass) | st_raderr | st_radlim | st_radblend | st_radn |
| st_radv | RV (value) | Radial Velocity (km/sec) | st_radverr | st_radvlim | st_radvblend | st_radvn |
| st_rah | RA (hours) | Right Ascension (hours) | st_raherr | st_posn | ||
| st_teff | Teff [K] | Stellar Effective Temperature (K) | st_tefferr | st_tefflim | st_teffblend | st_teffn |
Last updated: 19 October 2012
