KEPLER_CP Field Descriptions

You may submit queries using any of the fields listed below. The "Column label" is the name displayed on the search forms and in search results. The "Column name" is the actual column name in the table and needs to be specified in GET requests. (See the MAST Services web page for information on submitting GET requests.) If the "Column name" is in italics, it means the table is indexed on that field and queries with that field will run faster. Clicking on "Data Type" entries will display information on search options.

When using the "user-specified field" form element on a MAST search form, simply select the column "label" in the forms pulldown menu and type in the qualification in the adjacent box. If you specify constraints on the same column in more than one form element, they will all be included in the query and you may not get results you expect. Note the entries in the table below may be sorted by clicking on the column headings.

Kepler Confirmed exoplanets (with data from the Kepler KOI table compiled by http://nexsci.caltech.edu)
Last Update: March 18, 2013

Column Name	Column Label	Description	Examples/Valid Values	Data Type
Column Name	Column Label	Description	Examples/Valid Values	Data Type
kepler_name	Planet Name	Planet name in the form kepler-n[b,c,d..] where n is a sequential number followed by a letter (starting with b) to distinguish planets in multiple planetary systems.	example: kepler-7b	string
kepid	Kepler ID	Kepler ID identifying corresponding star entry in the Kepler Input Catalog. Note planets in the same star system are assigned the same Kepler ID.	range: 2571238 to 12644769	integer
kepoi_name	KOI Name	Kepler assigned Object of Interest (KOI) name in the form KNNNNN.DD where NNNNN designates the host star and DD is a 2-digit number designating a transiting object. Note some planets have not been assigned a KOI name.	example: K00203.01	string
alt_name	Alt Name	Additional name as provided by the planet discovery publication. This name is given for a confirmed planet not listed in the KOI candidate lists or lacking a KOI name.	example: KOI-55 c	string
koi	KOI Number	The Kepler Object of Interest (KOI) number stored as a floating point number (i.e., not as a string). This field can be searched using numberical operators or for sorting output by KOI number.	range: 1.01 to 2937.02	numeric
degree_ra	RA (J2000)	Right Ascension in decimal degrees.	range: 281.288 to 300.102	ra
ra_err	RA Error	Right Ascension uncertainty in decimal degrees.	range: 0	real
degree_dec	Dec (J2000)	Declination in decimal degrees as extracted from Kepler Input Catalog	range: 37.85 to 51.76	dec
dec_err	Dec Error	Right Ascension uncertainty in decimal degrees.	range: 0	real
tm_designation	2mass Name	2Mass designation	examples: 2MASS J19024305+5014286	string
koi_teq	Planet temp	Computed planet temperatures are based on an assumption that the planet is in equilibrium with radiation from its star balanced by its own black body radiation, taking into account some reflection of radiation from the planet (albedo). Actual albedo is unknown. The planet temperatures calculated do not take into account atmospheric properties, since these are unknown. If Earth did not have atmosphere, its temperature would be below the freezing point of water. In the case of Jupiter, not only does it have an atmosphere to complicate things, but a significant internal heat source as well.	range: roughly 250 to 3370 degrees K	integer
koi_prad	Planet Radius	Estimated planet radius (earth = 1.0)	range: 0.34 to 23	float
koi_duration	Transit duration	Duration of transit	range: roughly 0.4 to 13.54	float
koi_period	Period	Estimated Planet period in earth days	range: roughly 0.4 to 580	float
koi_period_err1	Period err1	Lower uncertainty limit in Planet period in earth days	range: roughly 0 to 15	float
koi_ingress	Ingress Duration	The time between first and second contact of the planetary transit. Contact times are typically computed from a best-fit model produced by a Mandel-Agol (2002) model fit to a multi-quarter Kepler light curve, assuming a linear orbital ephemeris.	all null	float
koi_impact	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.	0 to 0.977	float
koi_incl	Inclination	The angle between the plane of the sky (perpendicular to the line of sight) and the orbital plane of the planet candidate.	79.6 to 90.76	float
koi_sparprov	Provenance	Provenance of stellar parameters. A flag describing the source of the stellar parameters. KIC = the parameters are extracted from the Kepler Input Catalog (Brown et al. 2011). Uncertainties of Teff = 200 K, log(g) = 0.3 dex and [Fe/H] = 0.4. J-K = the star is unclassified in the KIC, J-K has been used to estimate temperature. The host star is assumed to be on the ZAMS with corresponding log(g) based on the Schmidt-Kaler relation. Solar = the star is unclassified in the KIC, so the host star is assumed to have solar properties. SME = Spectroscopic parameters derived from SME analysis (Valenti and Piskunov 1996). Stellar parameters are derived based on stellar evolution models. SPC = Spectroscopic parameters derived from SPC analysis (Buchhave et al. 2012). Stellar parameters are derived based on stellar evolution models. Pinsonneault = uses a revised Teff scale from Pinsonneault et al. (2012) with [Fe/H] fixed at -0.2. The quantity log(g) is taken from the KIC. Values are then revised by fitting to Yonsei-Yale stellar evolution models (Yi et al. 2001). Astero = host star properties have been measured by comparison with astroseismologial models.	examples: SPC, Solar, SME, null, Pinsonneault, KIC, J-K	string
koi_dor	a/R	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.	3.57 to 186	float
koi_num_transits	Transit Number	The number of expected transits or partially-observed transits associated with the planet candidate occurring within the searched light curve. This does not include transits that fall completely within data gaps.	9 to 824	integer
koi_trans_mod	Transit Model	A reference to the transit model used to fit the data (e.g., Mandel-Agol 2002).	Mandel and Agol (2002, ApJ, 580, 171)	string
koi_time0bk	Time of transit	The time corresponding to the center of the first detected transit in Barycentric Julian Day (BJD) minus a constant offset of 2,454,833.0 days. The offset corresponds to 12:00 on Jan 1, 2009 UTC.	range: 120.6 to 295.3	float
koi_time0bk_err1	Time of transit err1	Lower uncertainty limit	range: 0 to 1.1	float
koi_depth	Transit Depth	The fraction of stellar flux lost (in parts per million) at the minimum of the planetary transit.	range: 17 to 37408	real
koi_sma	Semi-major Axis	Estimated semi-major axis in AU.	range: 0.01 to 1.4	float
koi_ror	r/R	Ratio of planet to stellar radius	range: 0.004 to 0.17	float
koi_ror_err1	r/R err1	Ratio of planet to stellar radiusi lower uncertainty	range: 0 to 0.12	float
koi_sage	Age	stellar Age	0.26 to 14	float
koi_smet	Metallicity	Derived Log10 Fe/H metallicity accurate to 0.5 dex.	range:	float
koi_smass	Stellar Mass	Estimated Stellar Mass (solar = 1.0) obtained from NExScI's Exoplanet table. (Note most other table entries come from the Kepler KOI table also provided by NExScI or the NExScI planet names table..)	range: roughly 0.69 to 1.08	float
koi_srad	Stellar Radius	Estimated Stellar Radius (solar = 1.0)	range: 0.5 to 3.14	float
koi_steff	Stellar Teff	Derived Effective Temperature accurate to 200 K	range: 3855 to 9071 degrees K	integer
koi_slogg	Logg	Stellar Surface Gravity (cm/s2)	range: 3.58 to 4.75	float
koi_kepmag	KEP Mag	A magnitude computed according to a hierarchical scheme and depends on what pre-existing catalog source is available, SCP, Tycho 2, or photographic photometry, in order of preferred selection. For SCP stars the magnitude is synthesized from the Sloan-like g and r magnitudes according to the following prescription: if one defines 'color' as g - r, then for color less than or equal to 0.8 kepmag = 0.8r + 0.2g, while for color greater than 0.8 kepmag = 0.9r + 0.1g. Empirical measurements for presumed constant stars suggest that the r.m.s. for this quantity is slightly larger 0.02 mags. except for very faint and bright stars.	range: 8.2 to 15.98	float
koi_gmag	g Mag	KIC g-bad magnitude	range: 8.7 to 17.4	float
koi_rmag	r Mag	KIC r-band magnitude	range: 8.3 to 16.1	float
koi_imag	i Mag	KIC i-band magnitude	range: 9.8 to 15.6	float
koi_zmag	z Mag	KIC z-band magnitude	range: 9.8 to 15.5	float
koi_jmag	J Mag	KIC J-band magnitude (from 2MASS)	range: 7.2 to 14.5	float
koi_hmag	H Mag	KIC H-band magnitude (from 2MASS)	range: 7.0 to 14.0	float
koi_kmag	K Mag	KIC K-band magnitude (from 2MASS)	range: 6.9 to 14.1	float
koi_list_flag	KOI List	Designates entries included in Kepler Objects of Interest (KOI) catalog. Some entries not in KOI list may still have a KOI name if the star is in the KOI list but not the planet. Note in general, less metadata is available for the non-KOI planets.	yes or no	string
koi_vet_date	Last Update	Date of last update.	example: 9/8/2011 12:00:00 Note, as with all MAST datetime fields, the following examples are valid date formats when submitting queries: "< Jan 10 2008", "Jul 1 2009 .. Aug 1 2009", "1/1/2008", "2009 Jul 15 14:30:20"	datetime