Data Columns of Mission Star and HWO ExEP Tables

This page contains the complete list of all public data columns in the Mission Stars, Mission Stars+ExoCat, and HWO ExEP Precursor Science Stars tables that can be returned through the Exoplanet Archive's application programming interface (API) or Table Access Protocol (TAP), and when using the interactive tables.

Note that some columns appear in all three tables while others are specific to either HWO ExEP or Mission Stars/Mission Stars+ExoCat. More details on the these tables are given on the Potential Stellar Targets for Future Exoplanet Missions page.

Query-based Access

To access these tables with Table Access Protocol (TAP) or the archive's application program interface (API), consult the following user guides:

Column names denoted with a † are default parameters that are displayed in the interactive tables when first loaded and when Reset Filters is clicked.

Database
Column Name		 Table Label Description Uncertainties Column Displayed String Name

(Not included in HWO ExEP table)		 Source Column

(Not included in HWO ExEP table)		 In Mission Stars and Mission Stars+ExoCat In HWO ExEP Precursor Science Stars
star_name† Star Name Stellar name most commonly used       X  
hip_name† HIP Name or HIP ID Name of the star as given by the Hipparcos Catalog       X X
hip_compname† HIP Component ID Component ID (usually from WDS) is Hipparcos entry resolved         X
tic_id† TIC ID Name of the star as given by the TESS Input Catalog         X
hd_name† HD Name or HD ID Name of the star as given by the Henry Draper Catalog       X X
hr_name† HR ID Name of the star as given by the Harvard Revised Photometry Catalog         X
gj_name† GJ Name or GJ ID Name of the star as given by the Gliese Jahreiss Catalog       X X
tm_name† 2MASS Name 2MASS designation       X  
constellation† Constellation ID Constellation ID, usually Bayer, Flamsteed, or Variable star identifier         X
target_group† Target Group HWO Selection Tier group for target star (A, B, C)         X
hostname† Host Name Stellar name most commonly used in the literature/IAU proper name if available         X
st_exocatflag† ExoCat List Flag indicating if a star is on the ExoCat Directing Imaging Mission star list       X  
st_coronagflag† Exo-C Probe List Flag indicating if a star is on the Exo-C Coronagrpah Probe star list       X  
st_starshadeflag† Exo-S Probe List Flag indicating if a star is on the Exo-S Starshade Probe star list       X  
st_wfirstflag† WFIRST List Flag indicating if a star is on the WFIRST coronagraph exoplanet list       X  
st_lbtiflag† LBTI List Flag indicating if a star is on the LBTI survey list       X  
st_rvflag† Known RV Data Flag indicating if a star has RV data, either a detection or a non-detection       X  
st_ppnum† Number of Planets in System Number of planets in the planetary system       X  
ra† RA (decimal degrees) Right Ascension of the planetary system in decimal degrees raerr rastr   X X
dec† Dec (decimal degrees) Declination of the planetary system in decimal degrees decerr decstr   X X
ra_str† RA (sexagesimal) Right Ascension in sexagesimal format.       X  
dec_str† Dec (sexagesimal) Declination in sexagesimal notation       X  
st_dist† Distance (pc) Distance to the system in units of parsecs

(+)st_disterr1
(-)st_disterr2

 st_diststr    X  
sy_dist† Distance (pc) Distance to the planetary system in units of parsecs         X
st_vmag† V-band [mag] Brightness of the host star as measured using the V band in units of magnitudes st_vmagerr st_vmagstr  st_vmagsrc  X  
sy_vmag† V (Johnson) Magnitude Apparent V magnitude of host star (Johnson photometric system) sy_vmagerr       X
st_vmagearth Earth Equivalent V magnitude (mag) V-band magnitude of an Earth-sized and albedo planet at the Earth Equivalent Insolation Distance at quadrature st_eeidmaserr st_eeidmasstr st_eeidmassrc X  
st_bmv† B-V [mag] Color of the star as measured by the difference between B and V bands st_bmverr st_bmvstr st_bmvsrc X  
sy_bvmag† B-V (Johnson) Color (mag) Color of the stars as measured by the difference between B and V bands sy_bvmagerr       X
sy_rcmag† R (Cousins) Magnitude Apparent Rc magnitude (Cousins photometric system)         X
st_etwin_bratio† Earth Equivalent Planet-Star Ratio Planet-star brightness ratio for hypothetical Earth twin at quadrature (for flat albedo between 0.5–1µm)         X
st_etwin_rcmap† Earth Equivalent R (Cousins) Magnitude Apparent Rc magnitude Cousins photometric system) for hypothetical Earth twin at quadrature         X
st_etwin_rvamp† Earth Equivalent Radial Velocity Amplitude (cm/s) Radial velocity amplitude of star perturbed by hypothetical Earth twin at EEID, in cm/s         X
st_etwin_astamp† Earth Equivalent Astrometric Amplitude (cm/s) Astrometric amplitude of star perturbed by hypothetical Eath twin at EEID, in uas         X
st_spttype† Stellar Spectral Type Classification of the star based on their spectral characteristics following the Morgan-Keenan system       X  
st_spectype† Spectral Type Classification of the star based on their spectral characteristics following the Morgan-Keenan system         X
st_lbol† Stellar Bolometric Luminosity [log(solar)] Amount of energy emitted by a star per unit time, measured in units of solar luminosities. The bolometric corrections are derived from V-K or B-V colors st_lbolerr st_lbolstr st_lbolsrc X  

wds_designation

(† HWO table only)

 WDS Designation WDS (Washington Double Star) Catalog designation       X X
wds_comp† WDS Component WDS (Washington Double Star) Catalog Component ID (letter)         X
wds_sep WDS Separation (arc) WDS (Washington Double Star) Catalog separation (arcsecs)       X X
wds_deltamag† WDS Delta Mag (mag) WDS (Washington Double Star) Catalog Delta Magnitude (mag)       X X
sy_plx† Parallax (mas) Difference in the angular position of a star as measured at two opposite positions within the Earth's orbit sy_plxerr       X
st_fracplxunc Fractional Parallax Uncertainty Fractional parallax uncertainty       X  
st_pmra RA Proper Motion (mas/yr) Angular change in right ascension over time as seen from the center of mass of the Solar System st_pmraerr st_pmrastr   X  
st_pmdec Dec Proper Motion (mas/yr) Angular change in declination over time as seen from the center of mass of the Solar System st_pmdecerr
st_pmdecstr   X  
st_glon Galactic Longitude (deg) Galactic longitude of the planetary system in units of decimal degrees st_glonerr
st_glonstr   X  
st_glat Galactic Latitude (deg) Galactic latitude of the planetary system in units of decimal degrees st_glaterr
st_glonstr   X  
st_vmk V-K [mag] Color of the star as measured by the difference between V and K bands. The source column is for the K magnitude st_vmkerr st_vmkstr st_vmksrc X  
st_mbol Stellar Bolometric Magnitude [mag] Apparent magnitude of the star at a distance of 10 parsec st_mbolerr st_mbolstr st_mbolsrc X  
st_mbolflag Stellar Bolometric Magnitude Contamination flag Flag indicating if more than 1 star contributes to the value       X  
sy_disksflag† Disks Flag Flag indicating if star has an infrared excess indicative of a dust disk, as measured by IRAS, Spitzer, Herschel, WISE, or LBTI (Y=yes, N=no).         X
sy_disksflag_reflink Disks Flag Reference Reference of publication used for given parameter set         X
sy_planets_flag† Planets Flag Flag indicating if star has one or more confirmed exoplanets in NASA Exoplanet Archive (Y=yes, N=no)         X
sy_pnum† Number of Planets Number of planets in the planetary system         X
st_lum† Stellar Luminosity [log10(Solar)] The amount of energy emitted by a star per unit time, measured as a logarithm of the value in units of solar luminosities. st_lumerr       X
st_spttag Spectral Type Tag Spectral type tags are: O, B, A, F, G, K, M, GIANT, or WD (white dwarf)       X  
st_lumclass Spectral Luminosity Class The spectral luminosity class is WD (white dwarf), GIANT or MAINSEQ       X  
st_eeidau Earth Equivalent Insolation Distance (au) The distance where an Earth-sized planet would receive the same incoming stellar radiation as does the Earth in au st_eeidauerr st_eeidaustr st_eeidausrc X  
st_eei_orbsep† Earth Equivalent Insolation Distance (au) Orbital separation where irradiance equals that of Earth from the Sun, in astronomical units         X
st_eeidmas† Earth Equivalent Insolation Distance (mas) The distance where an Earth-sized planet would receive the same incoming stellar radiation as does the Earth in milliarcseconds st_eeidmaserr st_eeidmasstr st_eeidmassrc X  
st_eei_angsep† Earth Equivalent Insolation Distance (mas) Angular separation where irradiance equals that of Earth from the Sun, in milliarcseconds         X
st_eei_orbper† Orbital Period at EEID (days) Orbital period where irradiance equals that of Earth from the Sun, in days         X
st_fpbearth Fractional Planet Brightness Fractional planet brightness of an Earth-sized and albedo planet at the Earth Equivalent Insolation Distance at quadrature, relative to the star in V-band st_fpbeartherr st_fpbearthstr st_fpbearthsrc X  

st_teff

(† HWO table only)

 Effective Temperature (K) Temperature of the star as modeled by a black body emitting the same total amount of electromagnetic radiation
 st_tefferr st_teffstr st_teffsrc X X

st_rad

(† HWO table only)

 Stellar Radius (solar radii) Length of a line segment from the center of the star to its surface, measured in units of radius of the Sun.
st_raderr st_radstr st_radsrc X X
st_diam† Stellar Angular Diameter (mas) Angular diameter of star, measured in units of milliarcseconds         X

st_mass

(† HWO table only)		 Stellar Mass (solar mass) Amount of matter contained in the star, measured in units of masses of the Sun st_masserr st_massstr st_masssrc X X

st_logg

(† HWO table only)

 Stellar Surface Gravity [log10(cm/s**2)] Gravitational acceleration experienced at the stellar surface st_loggerr st_loggstr st_loggsrc X X
st_log_rhk† Stellar Ca II Chromospheric Activity Index (log R HK) Activity index is a measure of the emission-line cores of the Ca II H and K lines         X
st_age Stellar Age (Gyr) Age of the star in Gyr st_ageerr st_agestr st_agesrc X  
st_actclass Stellar Activity Class The stellar chromospheric activity classes are: VI = very inactive;I = inactive;A = active; VA = very active     st_actclasssrc X  
st_metfe Stellar Metallicity (dex) Measurement of the metal content of the photosphere of the star as compared to the hydrogen content [Fe/H]. st_metfeerr st_metfestr st_metfesrc X  
st_met† Stellar Metallicity (dex) Measurement of the metal content of the photosphere of the star as compared to the hydrogen content st_meterr       X
st_metratio Metallicity Ratio Ratio for the Metallicity Value [Fe/H] denotes iron abundance; [M/H] refers to a general metal content st_metfeerr st_metfestr st_metfesrc X  
st_probeflag Probel List Flag indicating whether a star is in any of the probe lists (Exo-C, Exo-S, WFIRST, RV or LBTI). st_metfeerr st_metfestr st_metfesrc X  
st_k2flag K2 target List Flag indicating if a star is in the K2 target list       X  
st_k2campaign K2 Campaign number K2 Campaign Number for a given target       X  
st_nts Number of Time Series Number of literature time series available for this star in the NASA Exoplanet Archive       X  
st_nplc Number of Planet Transit Light Curves Number of literature transit light curves available for this star in the NASA Exoplanet Archive       X  
st_nglc Number of General Light Curves Number of Hipparcos light curves available for this star in the NASA Exoplanet Archive       X  
st_nrvc Number of Radial Velocity Light Curves Number of literature radial velocity curves available for this star in the NASA Exoplanet Archive       X  
st_naxa Number of Amateur Light Curves Number of literature amateur light curves available for this star in the NASA Exoplanet Archive       X  
st_nimg Number of Images Number of literature images available for this star in the NASA Exoplanet Archive       X  
st_nspec Number of Spectra Number of literature of spectra available for this star in the NASA Exoplanet Archive       X  
st_j2m J-band (2MASS) Stellar J (2MASS) Magnitude Value st_j2merr st_j2mstr st_j2mlim X  
st_h2m H-band (2MASS) Stellar H (2MASS) Magnitude Value st_h2merr st_h2mstr st_h2mlim X  
st_ks2m Ks-band (2MASS) Stellar Ks (2MASS) Magnitude Value st_ks2merr st_ks2mstr st_ks2mlim X  
st_wise1 WISE 3.4 micron Stellar WISE 3.4 micron Magnitude Value st_wise1err st_wise1str st_wise1lim X  
st_wise2 WISE 4.6 micron Stellar WISE 4.6 micron Magnitude Value st_wise2err st_wise2str st_wise2lim X  
st_wise3 WISE 12 micron Stellar WISE 12 micron Magnitude Value st_wise3err st_wise3str st_wise3lim X  
st_wise4 WISE 22 micron Stellar WISE 22 micron Magnitude Value st_wise4err st_wise4str st_wise4lim X  


Last updated: 27 February 2023