Transiting Planets Table Data Column Definitions
The following table lists all of the data columns in the Transiting Planets Table (TD), which is simpler interface for accessing all of the transit-specific observables currently in the Exoplanet Archive. These data are a subset of what is available in the Planetary Systems and Planetary Systems Composite Data tables. Transit table data may also be retrieved by query through the archive's Table Access Protocol (TAP) service.
Query-based Access to the Transit Table
The Transiting Planets Table is connected to the archive's TAP service, which enables automated data retrieval using queries. To build a query, review the TAP User Guide and use the database column names on this page.
Citing This Table (DOI)
If you use data from this table for your research, please include the following Digital Object Identifier (DOI) as part of your acknowledgment:
10.26133/NEA37
See Acknowledging the Archive for data set-specific language. See the full list of NASA Exoplanet Archive DOIs for other data sets and services.
_______________________________________________
Skip to a subsection:
Additional Default Columns
Planet Parameter Columns
Stellar Data Columns
System Data and Position Columns
Photometry Columns
Dates
_______________________________________________
Default columns are those that display in the Transiting Planets interactive table when the table is first loaded and when the Reset Filters button is clicked. To add or remove other columns to the interactive table, click the Select Columns button in the upper-left corner of the interface to access Column Controls. For more information on using the archive's interactive tables, see the User Guide.
Note: Default parameters listed on this page are are noted with a †.
Additional Default Columns
| Database Column Name |
Table Label | Description |
|---|---|---|
| pl_name† | Planet Name | Planet name most commonly used in the literature |
| rastr† | RA [sexagesimal] | Right Ascension of the planetary system in sexagesimal format |
| decstr† | Dec [sexagesimal] | Declination of the planetary system in sexagesimal notation |
| default_flag† | Default Parameter Set | Boolean flag indicating whether given set of planet parameters has been selected as default (1=yes, 0=no) |
Planet Parameter Columns
| Database Column Name |
Table Label | Description | Uncertainties Column (positive +) (negative -) |
Limit Column |
|---|---|---|---|---|
| pl_refname† | Planetary Parameter Reference | Reference of publication used for given planet parameter set | ||
| pl_orbper† | Orbital Period [days] | Time the planet takes to make a complete orbit around the host star or system | (+) pl_orbpererr1 (-) pl_orbpererr2 |
pl_orbperlim |
| pl_rade† | Planet Radius [Earth Radius] | Length of a line segment from the center of the planet to its surface, measured in units of radius of the Earth | (+) pl_radeerr1 (-) pl_radeerr2 |
pl_radelim |
| pl_radj | Planet Radius [Jupiter Radius] | Length of a line segment from the center of the planet to its surface, measured in units of radius of Jupiter | (+) pl_radjerr1 (-) pl_radjerr2 |
pl_radjlim |
| pl_orbeccen† | Eccentricity | Amount by which the orbit of the planet deviates from a perfect circle | (+) pl_orbeccenerr1 (-) pl_orbeccenerr2 |
pl_orbeccenlim |
| pl_orbincl† | Inclination [deg] | Angle of the plane of the orbit relative to the plane perpendicular to the line-of-sight from Earth to the object | (+) pl_orbinclerr1 (-) pl_orbinclerr2 |
pl_orbincllim |
| pl_tranmid† | Time of Conjuction (Transit Midpoint) [days] | The time given by the average of the time the planet begins to cross the stellar limb and the time the planet finishes crossing the stellar limb. | (+) pl_tranmiderr1 (-) pl_tranmiderr2 |
pl_tranmidlim |
| pl_tsystemref | Time Reference Frame and Standard | Time system basis for temporal and orbital parameters | ||
| ttv_flag† | Data show Transit Timing Variations | Flag indicating if the planet orbit exhibits transit timing variations from another planet in the system (1=yes, 0=no). Note: Non-transiting planets discovered via the transit timing variations of another planet in the system will not have their TTV flag set, since they do not themselves demonstrate TTVs. |
||
| pl_imppar† | Impact Parameter | The sky-projected distance between the center of the stellar disc and the center of the planet disc at conjunction, normalized by the stellar radius | (+) pl_impparerr1 (-) pl_impparerr2 |
pl_impparlim |
| pl_trandep† | Transit Depth [%] | The size of the relative flux decrement caused by the orbiting body transiting in front of the star | (+) pl_trandeperr1 (-) pl_trandeperr2 |
pl_trandeplim |
| pl_trandur† | Transit Duration [hrs] | The length of time from the moment the planet begins to cross the stellar limb to the moment the planet finishes crossing the stellar limb | (+) pl_trandurerr1 (-) pl_trandurerr2 |
pl_trandurlim |
| pl_ratdor† | Ratio of Semi-Major Axis to Stellar Radius | The distance between the planet and the star at mid-transit divided by the stellar radius. For the case of zero orbital eccentricity, the distance at mid-transit is the semi-major axis of the planetary orbit. | (+) pl_ratdorerr1 (-) pl_ratdorerr2 |
pl_ratdorlim |
| pl_ratror† | Ratio of Planet to Stellar Radius | The planet radius divided by the stellar radius | (+) pl_ratrorerr1 (-) pl_ratrorerr2 |
pl_ratrorlim |
Stellar Data Columns
| Database Column Name |
Table Label | Description | Uncertainties Column (positive +) (negative -) |
Limit Column |
|---|---|---|---|---|
| st_refname† | Stellar Parameter Reference | Reference of publication used for given stellar parameter set | ||
| st_teff† | Stellar Effective Temperature [K] | Temperature of the star as modeled by a black body emitting the same total amount of electromagnetic radiation | (+) st_tefferr1 (-) st_tefferr2 |
st_tefflim |
| st_rad† | Stellar Radius [Solar Radius] | Length of a line segment from the center of the star to its surface, measured in units of radius of the Sun | (+) st_raderr1 (-) st_raderr2 |
st_radlim |
| st_logg† | Stellar Surface Gravity [log10(cm/s**2)] | Gravitational acceleration experienced at the stellar surface | (+) st_loggerr1 (-) st_loggerr2 |
st_logglim |
System Data and Position Columns
| Database Column Name |
Table Label | Description |
|---|---|---|
| sy_refname† | System Parameter Reference | Reference of publication used for given system parameter set |
| ra | RA [decimal] | Right Ascension of the planetary system in decimal degrees |
| dec | Dec [decimal] | Declination of the planetary system in decimal degrees |
| glat | Galactic Latitude [deg] | Galactic latitude of the planetary system in units of decimal degrees |
| glon | Galactic Longitude [deg] | Galactic longitude of the planetary system in units of decimal degrees |
| elat | Ecliptic Latitude [deg] | Ecliptic latitude of the planetary system in units of decimal degrees |
| elon | Ecliptic Longitude [deg] | Ecliptic longitude of the planetary system in units of decimal degrees |
Photometry Columns
| Database Column Name |
Table Label | Description | Uncertainties Column (positive +) (negative -) |
|---|---|---|---|
| sy_bmag | B (Johnson) Magnitude | Brightness of the host star as measured using the B (Johnson) band in units of magnitudes | (+) sy_bmagerr1 (-) sy_bmagerr2 |
| sy_vmag† | V (Johnson) Magnitude | Brightness of the host star as measured using the V (Johnson) band in units of magnitudes | (+) sy_vmagerr1 (-) sy_vmagerr2 |
| sy_jmag | J (2MASS) Magnitude | Brightness of the host star as measured using the J (2MASS) band in units of magnitudes | (+) sy_jmagerr1 (-) sy_jmagerr2 |
| sy_hmag | H (2MASS) Magnitude | Brightness of the host star as measured using the H (2MASS) band in units of magnitudes | (+) sy_hmagerr1 (-) sy_hmagerr2 |
| sy_kmag† | Ks (2MASS) Magnitude | Brightness of the host star as measured using the K (2MASS) band in units of magnitudes | (+) sy_kmagerr1 (-) sy_kmagerr2 |
| sy_umag | u (Sloan) Magnitude | Brightness of the host star as measured using the Sloan Digital Sky Survey (SDSS) u band, in units of magnitudes | (+) sy_umagerr1 (-) sy_umagerr2 |
| sy_gmag | g (Sloan) Magnitude | Brightness of the host star as measured using the Sloan Digital Sky Survey (SDSS) g band, in units of magnitudes | (+) sy_gmagerr1 (-) sy_gmagerr2 |
| sy_rmag | r (Sloan) Magnitude | Brightness of the host star as measured using the Sloan Digital Sky Survey (SDSS) r band, in units of magnitudes | (+) sy_rmagerr1 (-) sy_rmagerr2 |
| sy_imag | i (Sloan) Magnitude | Brightness of the host star as measured using the Sloan Digital Sky Survey (SDSS) i band, in units of magnitudes | (+) sy_imagerr1 (-) sy_imagerr2 |
| sy_zmag | z (Sloan) Magnitude | Brightness of the host star as measured using the Sloan Digital Sky Survey (SDSS) z band, in units of magnitudes | (+) sy_zmagerr1 (-) sy_zmagerr2 |
| sy_w1mag | W1 (WISE) Magnitude | Brightness of the host star as measured using the 3.4um (WISE) band in units of magnitudes. | (+) sy_w1magerr1 (-) sy_w1magerr2 |
| sy_w2mag | W2 (WISE) Magnitude | Brightness of the host star as measured using the 4.6µm (WISE) band in units of magnitudes. | (+) sy_w2magerr1 (-) sy_w2magerr2 |
| sy_w3mag | W3 (WISE) Magnitude | Brightness of the host star as measured using the 12.µm (WISE) band in units of magnitudes | (+) sy_w3magerr1 (-) sy_w3magerr2 |
| sy_w4mag | W4 (WISE) Magnitude | Brightness of the host star as measured using the 22.µm (WISE) band in units of magnitudes | (+) sy_w4magerr1 (-) sy_w4magerr2 |
| sy_gaiamag | Gaia Magnitude | Brightness of the host star as measuring using the Gaia band in units of magnitudes. Objects matched to Gaia using the Hipparcos or 2MASS IDs provided in Gaia DR2. | (+) sy_gaiamagerr1 (-) sy_gaiamagerr2 |
| sy_kepmag | Kepler Magnitude | Brightness of the host star as measured using the Kepler bandpass, in units of magnitudes | (+) sy_kepmagerr1 (-) sy_kepmagerr2 |
| sy_icmag | I (Cousins) Magnitude | Brightness of the host star as measured using the I (Cousins) band in units of magnitudes. | (+) sy_icmagerr1 (-) sy_icmagerr2 |
| sy_tmag | TESS Magnitude | Brightness of the host star as measured using the TESS bandpass, in units of magnitudes | (+) sy_tmagerr1 (-) sy_tmagerr2 |
| sy_kepmag | Kepler Magnitude | Brightness of the host star as measured using the Kepler bandpass, in units of magnitudes | (+) sy_kepmagerr1 (-) sy_kepmagerr2 |
Dates Columns
| Database Column Name |
Table Label | Description |
|---|---|---|
| rowupdate† | Date of Last Update | Date of last update of the planet parameters |
| pl_pubdate† | Planetary Parameter Reference Publication | Date of the publication of the given planet parameter set |
| releasedate† | Release Date | Date that the given planet parameter set was publicly released by the NASA Exoplanet Archive |
Last updated: 30 October 2023
