Stellar Hosts for Planetary Systems Column Definitions
The following table lists all of the data columns in the Stellar Hosts Table (stellarhosts), which lists all of the stellar parameters currently in the Exoplanet Archive for stars in systems with confirmed planets. In addition to listing stellar parameter sets associated with planetary parameter sets (as is the case for the Planetary Systems table), Stellar Hosts includes stellar parameters for confirmed planet-hosting stars that are not associated with a specific planetary solution. The table also includes stellar parameters of non-planet-hosting stars in a planetary system.
The Stellar Hosts Table data can be accessed from a web-based user interface and by querying the archive's Table Access Protocol (TAP) service.
Query-based Access to the Transit Table
The Stellar Hosts 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/NEA40
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:
Names Columns
System Composition
Stellar Data Columns
System Data and Position Columns
Photometry Columns
Dates
_______________________________________________
Default columns are those that display in the Stellar Hosts 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 †.
Names
| Database Column Name | Table Label | Description |
|---|---|---|
| sy_name† | System Name | Name of the system star is in |
| hostname† | Host Name | Stellar name most commonly used in the literature |
| hd_name | HD ID | Name of the star as given by the Henry Draper Catalog |
| hip_name | HIP ID | Name of the star as given by the Hipparcos Catalog |
| tic_id† | TIC ID | Name of the star as given by the TESS Input Catalog |
| gaia_id | GAIA ID | Name of the star as given by the Gaia Catalog |
System Composition
| Database Column Name | Table Label | Description |
|---|---|---|
| sy_snum† | Number of Stars | Number of stars in the planetary system |
| sy_pnum† | Number of Planets | Number of confirmed planets in the planetary system |
| sy_mnum | Number of Moons | Number of moons in the planetary system |
| cb_flag | Circumbinary Flag | Flag indicating whether the planet orbits a binary system (1=yes, 0=no) |
Stellar Data
| 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_spectype† | Spectral Type | Classification of the star based on their spectral characteristics following the Morgan-Keenan system | ||
| 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_mass† | Stellar Mass [Solar mass] | Amount of matter contained in the star, measured in units of masses of the Sun | (+) st_masserr1 (-) st_masserr2 |
st_masslim |
| st_met† | Stellar Metallicity [dex] | Measurement of the metal content of the photosphere of the star as compared to the hydrogen content | (+) st_meterr1 (-) st_meterr2 |
st_metlim |
| st_metratio† | Stellar Metallicity Ratio | Ratio for the Metallicity Value ([Fe/H] denotes iron abundance, [M/H] refers to a general metal content) | (+) st_metratioerr1 (-) st_metratioerr2 |
st_metratiolim |
| st_lum | Stellar Luminosity [log10(Solar)] | Amount of energy emitted by a star per unit time, measured in units of solar luminosities | (+) st_lumerr1 (-) st_lumerr2 |
st_lumlim |
| st_logg† | Stellar Surface Gravity [log10(cm/s**2)] | Gravitational acceleration experienced at the stellar surface | (+) st_loggerr1 (-) st_loggerr2 |
st_logglim |
| st_age | Stellar Age [Gyr] | The age of the host star | (+) st_ageerr1 (-) st_ageerr2 |
st_agelim |
| st_dens | Stellar Density [g/cm**3] | Amount of mass per unit of volume of the star | (+) st_denserr1 (-) st_denserr2 |
st_denslim |
| st_vsin | Stellar Rotational Velocity [km/s] | Rotational velocity at the equator of the star multiplied by the sine of the inclination | (+) st_vsinerr1 (-) st_vsinerr2 |
st_vsinlim |
| st_rotp | Stellar Rotational Period [days] | The time required for the planet host star to complete one rotation, assuming it is a solid body | (+) st_rotperr1 (-) st_rotperr2 |
st_rotplim |
| st_radv | Systemic Radial Velocity [km/s] | Velocity of the star in the direction of the line of sight | (+) st_radverr1 (-) st_radverr2 |
st_radvlim |
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 |
| rastr† | RA [sexagesimal] | Right Ascension of the planetary system in sexagesimal format |
| decstr† | Dec [sexagesimal] | Declination of the planetary system in sexagesimal notation |
| 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 |
| sy_pm | Total Proper Motion [mas/yr] | Angular change in position over time as seen from the center of mass of the Solar System |
| sy_pmra | Proper Motion (RA) [mas/yr] | Angular change in right ascension over time as seen from the center of mass of the Solar System |
| sy_pmdec | Proper Motion (Dec) [mas/yr] | Angular change in declination over time as seen from the center of mass of the Solar System |
| sy_dist† | Distance [pc] | Distance to the planetary system in units of parsecs |
| sy_plx | Parallax [mas] | Difference in the angular position of a star as measured at two opposite positions within the Earth's orbit |
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_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 |
Last updated: 23 February 2024
