KEPLER_KOI 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 Objects of Interest (KOIs) table as downloaded from NExSci
Last Update: March 4, 2013

Column Name	Column Label	Description	Examples/Valid Values	Data Type
Column Name	Column Label	Description	Examples/Valid Values	Data Type
kepid	Kepler ID	Kepler ID identifying corresponding entry in the Kepler Input Catalog (or custom aperture number).	range: 757,076 to < 13 million	integer
kepoi_name	KOI Name	Kepler Object of Interest designation as a string. Examples: k1000.01, ... (Note some tables used a KOInnn.n format for the KOI name.)	example: K00757.02	string
kepoi	KOI Number	Kepler Object of Interest number. Numerical value of KOI name. Note ignore trailing 0's.	range: 1.01 to 3148.01	numeric
koi_pdisposition	Kepler Disposition	Vetting Status derived by the Kepler project. Only 2 categories are currently defined but this may change as more data is received and analyzed.	Examples: CANDIDATE, FALSE POSITIVE	string
koi_disposition	NExScI Disposition	Vetting Status derived by NExScI. Currently NExScI flags confirmed planets which are not flagged by the Kepler project. Therefore, three categories are currently defined but this may change.	Examples: CANDIDATE, FALSE POSITIVE, CONFIRMED	string
degree_ra	RA (J2000)	Right Ascension in decimal degrees of host star as given in the Kepler Input Catalog (KIC).	range: 280.25 to 301.72, although values are stored in decimal degrees, valid formats for queries include: "19 28 29.65", "19h28m29s", 292.12354	ra
degree_dec	Dec (J2000)	Declination in decimal degrees of host star as given in KIC.	range: 36.57 to 52.15, stored in decimal degrees but can be queried using values such as: "+37 14 04.5", "37.23458"	dec
koi_time0bk	Time of Transit Epoch	Time to first transit (BKJD = BJD-2454833.0). The offset corresponds to 12:00 on Jan 1, 2009 UTC. Note other tables have used an offset value of 2454900, so be careful when comparing entries with earlier data.	120.5 to 657.3	double
koi_time0bk_err1	Time err1	uncertainty in Time upper limit	0 to 100	float
koi_time0bk_err2	Time_err2	uncertainty in Time lower limit	-100 to 0	float
koi_period	Period	Average interval between transits based on a linear fit to all observed transits. For candidates with only one observed transit, the period is estimated from the duration and knowledge of the stellar radius; values are then rounded to the nearest integer and multiplied by -1.	0.29 to 201292	double
koi_period_err1	Period err1	Period uncertainty upper limit (ppm)	0 to 123278	float
koi_period_err2	Period err2	Period uncertainty lower limit (ppm)	-123278 to 0	float
koi_depth	Transit Depth	The fraction of stellar flux lost (in parts per million) at the minimum of the planetary transit. Transit depths 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.	14 to 297000 ppm	float
koi_depth_err1	Depth err1	Transit depth uncertainty upper limit (ppm)	all null	float
koi_depth_err2	Depth err2	Transit depth uncertainty lower limit (ppm)	all null	float
koi_duration	Duration	Transit duration, first contact to last contact. 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.	0.35 to 60.03	double
koi_duration_err1	Duration err1	Transit duration uncertainty upper limit	all null	float
koi_duration_err2	Duration err2	Transit duration uncertainty lower limit	all null	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	double
koi_ingress_err1	Ingress err1	Ingress duration uncertainty upper limit	all null	float
koi_ingress_err2	Ingress err2	Ingress duration uncertainty lower limit	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 3.49	float
koi_impact_err1	Impact Parameter err1	Impact uncertainty upper limit	0 to 1	float
koi_impact_err2	Impact Parameter err2	Impact uncertainty lower limit	-1 to 0	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.	9.74 to 89.95	float
koi_incl_err1	Inclination err1	Orbital Inclination uncertainty upper limit	all null	float
koi_incl_err2	Inclination err2	Orbital Inclination uncertainty lower limit	all null	float
koi_sma	Semi-major Axis	Semi-major axis for planet based on Kepler 3rd law.	0 to 63.9	float
koi_sma_err1	Semi-major Axus err1	Semi-major axis uncertainty upper limit	all null	float
koi_sma_err2	Semi-major Axis err2	Semi-major axis uncertainty lower limit	all null	float
koi_eccen	Eccentricity	Eccentricity.	all zeroes	float
koi_eccen_err1	Eccentricity err1	Uncertainty upper limit	all null	float
koi_eccen_err2	Eccentricity err2	Uncertainty lower limit	all null	float
koi_longp	Long of Periastron	Longitude of Periastron	all null	float
koi_longp_err1	Long err1	Uncertainty upper limit in Longitude of periastron	all null	float
koi_longp_err2	Long err2	Uncertainty lower limit in Longitude of periastron	all null	float
koi_ror	r/R	Ratio of planet radius to stellar radius	0.004 to 2.78	float
koi_ror_err1	r/R err1	Uncertainty upper limit in r/R*	0 to 0.77	float
koi_ror_err2	r/R err2	Uncertainty lower limit in r/R*	-0.77 to 0	float
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.	0.2 to 31021	float
koi_dor_err1	a/R err1	Uncertainty upper limit in d/R*	0 to 12187	float
koi_dor_err2	a/R err2	Uncertainty lower limit in d/R*	-12187 to 0	float
koi_prad	Planet Radius	Planetary radius; in Earth radii=6378 km	0.32 to 294	float
koi_prad_err1	Planet Radius err1	Planetary radius upper limit uncertainty; in Earth radii=6378 km	0 to 110	float
koi_prad_err2	Planet Radius err2	Planetary radius upper limit uncertainty; in Earth radii=6378 km	-110 to 0	float
koi_teq	Teq	Equilibrium surface temperature of planet. The calculation of equilibrium temperature assumes i) thermodynamic equilibrium between the incident stellar flux and the radiated heat from the planet, ii) a Bond albedo (the fraction of total power incident upon the planet scattered back into space) of 0.3, iii) that the planet and star are blackbodies, and iv) that the heat is evenly distributed between the day and night sides of the planet.	31 to 9721	integer
koi_teq_err1	Teq err1	Upper Limit uncertainty in Equilibrium surface temperature of planet	all null	integer
koi_teq_err2	Teq err2	Lower Limit uncertainty in Equilibrium surface temperature of planet	all null	integer
koi_steff	Teff	Stellar effective (photospheric) temperature in degrees K	3240 to 27740	integer
koi_steff_err1	Teff err1	Upper limit uncertainty in stellar effective temperature in degrees K	44 to 500	integer
koi_steff_err2	Teff err2	Lower limit uncertainty in stellar effective temperature in degrees K	-500 to -44	integer
koi_slogg	log(g)	Log of stellar surface gravity in cm/s2	1.63 to 4.98	float
koi_slogg_err1	log(g) err1	Upper limit uncertainty in Log of stellar surface gravity in cm/s2	0.01 to 0.5	float
koi_slogg_err2	log(g) err2	Lower limit uncertainty in Log of stellar surface gravity in cm/s2	-0.5 to -0.01	float
koi_smet	Metallicity	stellar metallicity (dex). The base-10 logarithm of the Fe to H ratio at the surface of the star, normalized by the solar Fe to H ratio.	all null	float
koi_smet_err1	Metallicity err1	Upper limit stellar metallicity uncertainty (dex)	all null	float
koi_smet_err2	Metallicity err2	Lower limit stellar metallicity uncertainty (dex)	all null	float
koi_srad	Stellar Radius	stellar photospheric radius (solar = 1)	0.27 to 25.7	float
koi_srad_err1	Stellar Radius err1	Upper limit stellar radius uncertinty (solar = 1)	0.01 to 2.2	float
koi_srad_err2	Stellar Radius err2	Lower limit stellar radius uncertinty (solar = 1)	-2.2 to -0.01	float
koi_smass	Stellar Mass	stellar Mass (solar = 1)	all null	float
koi_smass_err2	Stellar Mass err2	Lower limit stellar Mass uncertainty (solar = 1)	all null	float
koi_smass_err1	Stellar Mass err1	Upper limit stellar Mass uncertainty (solar = 1)	all null	float
koi_sage	Age	stellar Age	0 to 14	float
koi_sage_err1	Age err1	Upper limit stellar Age uncertainty	0 to 5.3	float
koi_sage_err2	Age err2	Lower limit stellar Age uncertainty	-5.3 to 0	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_quarters	Quarters	bit-map of quarters searched. A bit string indicating which quarters of Kepler data were searched for transit signatures. Reading from left to right, the bits indicate the quarters. A value of one for any bit means that the designated quarter was searched for transits, a value of zero means that quarter was not included in the transit search.	all null	string
koi_limbdark_mod	Limb Darkening Model	A reference to the limb darkening model used to calculate stellar limb darkening coefficients.	Claret (2011, AA, 529, 75)	string
koi_ldm_coeff1	Limb Darkening Coeff1	Limb Darkening Coefficient 1. Up to four coefficients define stellar limb darkening (e.g., Claret 2000). Limb darkening is the variation of specific intensity of the star as a function of μ = cos(θ). θ is the angle between the line-of-sight of an observer and a line perpendicular to the stellar surface at an observed point.	0.03 to 1.124	float
koi_ldm_coeff2	Limb Darkening Coeff2	Limb Darkening Coefficient 2	-1.4 to 1.5	float
koi_ldm_coeff3	Limb Darkening Coeff3	Limb Darkening Coefficient 3	-1.2 to 1.7	float
koi_ldm_coeff4	Limb Darkening Coeff4	Limb Darkening Coefficient 4	-0.6 to 0.43	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.	0 to 1619	integer
koi_max_sngle_ev	Max single event sigma	Maximum single event statistics. See NExSci data columns definitions page for more information.	2.55 to 553.7	float
koi_max_mult_ev	Max Multievent sigma	Maximum multi-event statistics. See NExSci data columns definitions page for more information.	7.1 to 1987	float
koi_count	KOI count	Number of planet candidates identified in system	1 to 6	integer
koi_bin_oedp_sig	Binary Discrimination	Binary discrimination odd-even depth significance. See NExSci data columns definitions page for more information.	0 to 158.4	float
koi_fp_bkgid	False Positive Bkgnd ID	The name of the background object that has been identified as the likely source of the transit-like feature in the light curve.	all null	string
koi_fp_djmag	J-band diff	Difference in J-band magnitude between the target star and the background object containing the transit, when the background object has been identified.	all null	string
koi_comment	Comments	iFalse Positive comment. A description of the reason why an object's disposition has been given as False Positive. The following keywords are short-hand for certain criterion used to determine if a KOI is a False Positive: APO: "Active Pixel Offset", the pixels showing the transit do not coincide with the target star, indicating that the transit is actually on a background object. Binary: indicates that the transit event is due to an eclipsing binary, not a planet. EB: target is an eclipsing binary, or there is an unresolved background binary. odd-even: the depth of the even numbered transits are statistically different than the depths of the odd numbered transits, this is a sign of a background eclipsing binary. V-shaped: likely a grazing eclipsing binary. SB1: target star is a single-lined spectroscopic binary. SB2: target star is a double-lined spectroscopic binary.	all null	string
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_model_snr	Transit Model SNR	Transit depth normalized by the mean uncertainty in the flux during the transits.	2.1 to 11050.1	float
koi_model_dof	Transit Model DOF	The number of degrees of freedom used when fitting the transit model to the data.	all null	float
koi_model_chisq	Transit Model chisq	The goodness of the transit fit to the data. Within the TCE table this quantity is the chi-squared statistic. Within the KOI table this quantity is the reduced-chi-squared statistic, e.g., divided by the number of degrees of freedom in the fit.	0 to 3993.1	float
koi_fwm_stat_sig	FWM motion signif.	Flux weighted centroid motion significance	0 to 0.997	float
koi_gmag	gmag	KIC g magnitude	7.6 to 20.4	float
koi_gmag_err	gmag err	gmag uncertainty	all null	float
koi_rmag	rmag	KIC r magnitude	7.2 to 18.5	float
koi_rmag_err	rmag err	rmag uncertainty	all null	float
koi_imag	imag	KIC i magnitude	7.6 to 18.2	float
koi_imag_err	imag err	i mag uncertainty	all null	float
koi_zmag	zmag	KIC z magnitude	7.6 to 16.32	float
koi_zmag_err	zmag err	zmag uncertainty	all null	float
koi_jmag	Jmag	KIC J magnitude	5.39 to 16.76	float
koi_jmag_err	Jmag err	Jmag uncertainty	0.018 to 0.14	float
koi_hmag	Hmag	KIC H magnitude	4.8 to 15.96	float
koi_hmag_err	Hmag err	Hmag uncertainty	0.014 to 0.174	float
koi_kmag	Kmag	KIC K magnitude	4.7 to 15.9	float
koi_kmag_err	Kmag err	Kmag uncertainty	0.01 to 0.14	float
koi_kepmag	kepmag	KIC kepler magnitude	6.9 to 18.5	float
koi_kepmag_err	kepmag err	kepmag uncertainty	all null	float
koi_delivname	Delivery Name	Delivery Name	CUMULATIVE	string
koi_fwm_sra	FWM SRA	The Right Ascension (J2000) of the location of the transiting object calculated from the flux-weighted centroids. This result does not reflect the systematics due to crowding which can introduce significant errors in the calculated position. In decimal hours.	18.7 to 20.1	float
koi_fwm_sra_err	FWM SRA err	Flux weighted source RA error	0 to 0.0001	float
koi_fwm_sdec	FWM SDec	The Declination (J2000) of the location of the transiting object calculated from the flux-weighted centroids. This result does not reflect the systematics due to crowding which can introduce significant errors in the calculated position. In degrees.	36.58 to 52.15	float
koi_fwm_sdec_err	FWM SDec err	Flux weighted source Dec error.	0 0.0012	float
koi_fwm_srao	FWM SRAO	The RA (J2000) flux-weighted centroid shift. This is the RA of the in-transit flux weighted centroid minus the RA of the out-of-transit flux weighted centroid.	-34.0 to 13.1	float
koi_fwm_srao_err	FWM SRAO err	Flux weighted RA centroid shift error.	0 to 0.35	float
koi_fwm_sdeco	FWM SDeco	The Dec (J2000) flux-weighted centroid shift. This is the Dec of the in-transit flux weighted centroid minus the Dec of the out-of-transit flux weighted centroid.	-13.64 to 12.99	float
koi_fwm_sdeco_err	FWM SDeco err	Flux weighted Dec centroid shift error.	0 to 0.29	float
koi_fwm_prao	FWM PRAO	The calculated Right Ascension offset of the transiting or eclipsing object from the KIC location of the target star. The accuracy of this calculation degrades when the transit source has significant flux that falls outside the photometric aperture + a halo of pixels around it.	-0.003 to 0.004	float
koi_fwm_prao_err	FWM PRAO err	Flux weighted RA offset error	0 to 0.0003	float
koi_fwm_pdeco	FWM PDeco	The calculated Declination offset of the transiting or eclipsing object from the KIC location of the target star. The accuracy of this calculation degrades when the transit source has significant flux that falls outside the photometric aperture + a halo of pixels around it.	-0.006 to 0.01	float
koi_fwm_pdeco_err	FWM PDeco err	Flux weighted Dec offset error.	0 to 0.0004	float
koi_dicco_mra	Dicco MRA	The angular offset in the RA (J2000) direction between the best-fit PRF centroids from the Out-Of-Transit image and the Difference Image by simultaneously fitting all quarters. The out-of-transit centroid is subtracted from the difference image centroid.	-11.9 to 12.4	float
koi_dicco_mra_err	Dicco MRA err	Dicco MRA uncertainty.	0.002 to 2.3	float
koi_dicco_mdec	Dicco MDec	The angular offset in the Dec (J2000) direction between the best-fit PRF centroids from the Out-Of-Transit image and the Difference Image by simultaneously fitting all quarters. The out-of-transit centroid is subtracted from the difference image centroid.	-13.3 to 16.3	float
koi_dicco_mdec_err	Dicco MDec err	DICCO MDec uncertainty.	0.003 to 3	float
koi_dicco_msky	Dicco MSky	The angular offset on the plane of the sky between the best-fit PRF centroids from the Out-Of-Transit image and the Difference Image by simultaneously fitting all quarters. The out-of-transit centroid is subtracted from the difference image centroid.	0.0 to 16.3	float
koi_dicco_msky_err	Dicco MSky err	Diff. Image Control Centroid Mean Sky offset	0.002 to 3	float
koi_dicco_fra	Dicco FRA	The angular offset in the RA (J2000) direction between the best-fit PRF centroids from the Out-Of-Transit image and the Difference Image by averaging the weighted single-quarter measurements. The out-of-transit centroids are subtracted from the difference image centroids.	-17.2 to 13.84	float
koi_dicco_fra_err	Dicco FRA err	RA angular offset error.	0.006 to 5.8	float
koi_dicco_fdec	Dicco FDec	The angular offset in the Dec (J2000) direction between the best-fit PRF centroids from the Out-Of-Transit image and the Difference Image by averaging the weighted single-quarter measurements. The out-of-transit centroids are subtracted from the difference image centroids.	-13.3 to 16.3	float
koi_dicco_fdec_err	Dicco FDec err	Dec angular offset error.	0.002 to 3	float
koi_dicco_fsky	Dicco FSky	The angular offset on the plane of the sky between the best-fit PRF centroids from the Out-Of-Transit image and the Difference Image by averaging the weighted single-quarter measurements. The out-of-transit centroids are subtracted from the difference image centroids.	0.01 to 6.5	float
koi_dicco_fsky_err	Dicco FSky err	dicco sky error	0.01 to 6.5	float
koi_dikco_mra	Dikco MRA	The angular offset in the RA (J2000) direction between the best-fit PRF centroids from the Out-Of-Transit image and the Difference Image by simultaneously fitting all quarters. The out-of-transit centroid is subtracted from the difference image centroid.	-11.2 to 12.4	float
koi_dikco_mra_err	Dikco MRA err	dikco MRA error	0.002 to 3	float
koi_dikco_mdec	Dikco MDec	The angular offset in the Dec (J2000) direction between the best-fit PRF centroids from the Out-Of-Transit image and the Difference Image by simultaneously fitting all quarters. The out-of-transit centroid is subtracted from the difference image centroid.	-13.157 to 16.284	float
koi_dikco_mdec_err	Dikco MDec err	Dikco MDec error	0.003 to 3	float
koi_dikco_msky	Dikco MSky	The angular offset on the plane of the sky between the best-fit PRF centroids from the Out-Of-Transit image and the Difference Image by simultaneously fitting all quarters. The out-of-transit centroid is subtracted from the difference image centroid.	0.002 to 16.3	float
koi_dikco_msky_err	Dikco MSky err	Dikco MSky error	0.003 to 3	float
koi_dikco_fra	Dikco FRA	The angular offset in the RA (J2000) direction between the best-fit PRF centroids from the difference image and the Kepler Input Catalog position by averaging the weighted single-quarter measurements. The KIC position is subtracted from the difference image centroids.	-13.1 to 13.83	float
koi_dikco_fra_err	Dikco FRA err	Dikco FRA error	0.011 to 5.8	float
koi_dikco_fdec	Dikco FDec	he angular offset in the Dec (J2000) direction between the best-fit PRF centroids from the difference image and the Kepler Input Catalog position by averaging the weighted single-quarter measurements. The KIC position is subtracted from the difference image centroids.	-14.4 to 14.7	float
koi_dikco_fdec_err	Dikco FDec err	Dikco FDec error	0.01 to 6.5	float
koi_dikco_fsky	Dikco FSky	The angular offset in the plane of the sky between the best-fit PRF centroids from the difference image and the Kepler Input Catalog position by averaging the weighted single-quarter measurements. The KIC position is subtracted from the difference image centroids.	0.076 to 17.11	float
koi_dikco_fsky_err	Dikco FSky err	Dikco FSky error	all null	float
rowupdate	Last Update	Date of last update	currently Jan 3rd, 2013	datetime