K2 Names Table Data Column Definitions

The following tables list all of the data columns in the K2 Names table (k2names) that can be returned through the NASA Exoplanet Archive's Application Programming Interface (API) and displayed in the interactive table.

Additional Links:

Questions about the structure and use of this table in the archive format should be submitted through the Exoplanet Archive's Helpdesk. Questions about the content descriptions should be sent to the Kepler Science Center.

Target Labels and Flags

Database Column Name Table Label Description
epic_host† EPIC ID Target identification number, as listed in the Ecliptic Plane Input Catalog (EPIC).
k2_campaign† K2 Campaign number The K2 Campaign number for this target.
k2_name† K2 Name K2 number name of the form "K2-N" plus a lower-case letter identifying the planet. In general, these numbers are easier to remember than the corresponding EPIC designations and are intended to clearly indicate a class of objects that have been confirmed or validated as planets—a step up from the planet candidate designation.
alt_name† Confirmed Name The planet name as used in the Exoplanet Archive confirmed planet table.
k2_kepmag† Stellar Kepler Magnitude Value Brightness of the host star in the Kepler-band in units of magnitudes
tm_designation† 2MASS Name 2MASS designation from the 2MASS point source catalog (Skrutskie et al. 2006, ApJ, 131, 1163).
last_update† Date of Last Update Date of last update for this Kepler planet
† Default column: these columns display in the interactive table when the table is first loaded, and when Reset Filters is clicked.

Ecliptic Plane Input Catalog (EPIC) Parameters

Database Column Name Table Label Description
ra_str† RA [decimal degrees] EPIC Right Ascension
dec_str† Dec [decimal degrees] EPIC Declination
ra RA [decimal degrees] EPIC Right Ascension
dec Dec [decimal degrees] EPIC Declination
† 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


Last updated: 22 February 2016