K2 Targets Data Column Definitions

Data Columns in the K2 Targets Table

The following table lists all of the data columns in the K2 Targets table (k2targets) that can be returned through the Exoplanet Archive's application programming interface (API), or when using the interactive table.

More information on Exoplanet Archive K2 support can be found on the K2 resources page.

Some data include more specific information that can also be retrieved as separate calls in the API. These include:

  • Uncertainties (positive and negative)
  • String Display columns

Data from parameters listed in the Stellar Columns come from Huber et al. 2016.

_______________________________________________

Skip to a subsection:

Identification Information

Stellar Columns

Photometry Columns

_______________________________________________

Identification Information

Database
Column Name
Table Label Description Uncertainties Column
Displayed String Name
epic_number† EPIC number Identification number from the EPIC (Ecliptic Plane Input Catalog)    
tm_name† 2MASS Designation The name of the object as it appears in the 2MASS Catalog    
k2_campaign† K2 Campaign number The K2 Campaign number for this target    
k2_type† K2 Object Type The K2 Object Type for this target: Star or Extended    
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 degrees) Right Ascension of the planetary system in decimal degrees raerr  
dec Dec (decimal degrees) Declination of the planetary system in decimal degrees decerr  
k2_glon Galactic Longitude (deg) Galactic longitude of the planetary system in units of decimal degrees    
k2_glat Galactic Latitude (deg) Galactic latitude of the planetary system in units of decimal degrees    

k2_plx

Parallax (mas) Difference in the angular position of a star as measured at two opposite positions within the Earth's orbit (+) k2_plxerr1
(-) k2_plxerr2
k2_plxstr
k2_pmra RA Proper Motion (mas/yr) Angular change in right ascension over time as seen from the center of mass of the Solar System (+) k2_pmraerr1
(-) k2_pmraerr2
k2_pmrastr
k2_pmdec Dec Proper Motion (mas/yr) Angular change in declination over time as seen from the center of mass of the Solar System (+) k2_pmdecerr1
(-) k2_pmdecerr2
k2_pmdecstr
k2_propid† K2 Proposal Identifiers List of K2 proposal identifiers, separated by a semi-colon    
k2_npropid Number of K2 Proposal Identifiers Number of K2 proposal identifiers associated with the EPIC number    
k2_lcflag Long cadence flag Flag indicating if the target was observed using long cadence    
k2_scflag Short cadence flag Flag indicating if the target was observed using short cadence    

† Default column: these columns display in the interactive table when the table is first loaded, and when Reset Filters is clicked.

NOTE: For the K2 Names and K2 Targets tables, the Two-Wheel Engineering Test data are designated as Campaign E. To enable sorting, this Campaign is displayed as E, but the interactive table sorting and filtering defines the Campaign as -1.

Here are a few tips on searching this field (see the user guide for general help on sorting and filtering interactive tables):

For interactive tables:

  • When using the using the arrows at the top of the columns, sorting will list the campaigns in temporal order (E,0,1, etc).
  • To see only the engineering campaign, enter -1 in the text box.
  • To see only Campaign 1, enter '1' in the text box. Use single quotes in your entered string.
  • To see Campaigns E,0 and 1, enter <2 in the text box.

For the API:

  • Add &order=k2_campaign to sort by campaings in temporal order (E,0,1, etc).
  • To select only the engineering campaign, add &where=k2_campaign=-1 or &where=k2_campaign_str='E'
  • To see Campaigns E,0 and 1, enter add &where=k2_campaign<2

Stellar Columns

Database
Column Name
Table Label Description Uncertainties Column
Displayed String Name
k2_ebmv E(B-V) [mag] Stellar E(B-V) Reddening (+) k2_ebmverr1
(-) k2_ebmverr2
k2_ebmvstr
k2_dist† Distance (pc) Distance to the star in units of parsecs (+) k2_disterr1
(-) k2_disterr2
k2_diststr
k2_teff† Effective Temperature (K) Temperature of the star as modeled by a
black body emitting the same total amount
of electromagnetic radiation.
(+) k2_tefferr1
(-) k2_tefferr2
k2_teffstr
k2_logg Stellar Surface Gravity [log10 (cm/s**2)] Gravitational acceleration experienced at the stellar surface. (+) k2_loggerr1
(-) k2_loggerr2
k2_loggstr
k2_metfe Stellar Metallicity [dex] Measurement of the metal content of the photosphere of the star as compared to the hydrogen content. (+) k2_metfeerr1
(-) k2_metfeerr2
k2_metfestr
k2_rad† 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. (+) k2_raderr1
(-) k2_raderr2
k2_radstr
k2_mass† Stellar Mass [Solar mass] Amount of matter contained in the star, measured in units of masses of the Sun. (+) k2_masserr1
(-) k2_masserr2
k2_massstr
k2_dens Stellar Density [glem**3] Amount of mass per unit of volume of the star. (+) k2_denserr1
(-) k2_denserr2
k2_densstr
k2_star_prov Provenance of Stellar Parameters Flag indicating which observables were used to derive the classification.
hip: Hipparcos parallax and colors
apo: APOGEE spectroscopic classification
rav: RAVE spectroscopic classification
lam: LAMOST spectroscopic classification
rpm: reduced proper motions and colors
col: colors only
   


Photometry Columns

Database
Column Name
Table Label Description Uncertainties Column Displayed String Name
k2_kepmag† Kepler-band [mag] Brightness of the host star in the Kepler-band in units of magnitudes k2_kepmagerr st_kepmagstr
k2_kepmagflag† Kepler-band magnitude flag Origin of the derived Kepler-band magnitude: gri, BV, JHK, J    
k2_bjmag B-band (Johnson) [mag] Brightness of the host star as measured using the B (Johnson) band in units of magnitudes k2_bjmagerr k2_bjmagstr
k2_vjmag† V-band (Johnson) [mag] Brightness of the host star as measured using the V (Johnson) band in units of magnitudes k2_vjmagerr st_vjmagstr
k2_umag u-band (Sloan) [mag] Brightness of the host star as measured using the u (Sloan) band in units of magnitudes k2_umagerr k2_umagstr
k2_gmag g-band (Sloan) [mag] Brightness of the host star as measured using the g (Sloan) band in units of magnitudes k2_gmagerr k2_gmagstr
k2_rmag r-band (Sloan) [mag] Brightness of the host star as measured using the r (Sloan) band in units of magnitudes k2_rmagerr k2_rmagstr
k2_imag i-band (Sloan) [mag] Brightness of the host star as measured using the i (Sloan) band in units of magnitudes k2_imagerr k2_imagstr
k2_zmag z-band (Sloan) [mag] Brightness of the host star as measured using the z (Sloan) band in units of magnitudes k2_zmagerr k2_zmagstr
k2_jmag J-band (2MASS) [mag] Brightness of the host star as measured using the J (2MASS) band in units of magnitudes k2_jmagerr k2_jmagstr
k2_hmag H-band (2MASS) [mag] Brightness of the host star as measured using the H (2MASS) band in units of magnitudes k2_hmagerr k2_hmagstr
k2_kmag† Ks-band (2MASS) [mag] Brightness of the host star as measured using the K (2MASS) band in units of magnitudes k2_kmagerr k2_kmagstr
k2_w1mag WISE 3.4um [mag] Brightness of the host star as measured using the 3.4um (WISE) band in units of magnitudes k2_w1magerr k2_w1magstr
k2_w2mag WISE 4.6um [mag] Brightness of the host star as measured using the 4.6um (WISE) band in units of magnitudes k2_w2magerr k2_w2magstr
k2_w3mag WISE 12.um [mag] Brightness of the host star as measured using the 12.um (WISE) band in units of magnitudes k2_w3magerr k2_w3magstr
k2_w4mag WISE 22.um [mag] Brightness of the host star as measured using the 22.um (WISE) band in units of magnitudes k2_w4magerr k2_w4magstr




Last updated: 14 December 2016