spacer link to MAST page spacer logo image spacer
 
link to STScI page


User Specified Search Field

You may now search on any column in the mission database. Select the field you wish to search on and type in the qualification. NOTE that if you choose a field in BOTH the form and in the User Option field, then you may not get results or the result you expect.

In the table below is a list of all the column names available for search. Where reasonable a range or set of valid values is listed. Additional useful notes are included. If you click on the field name, a more detailed description of the data will be found. The column label is used in the search forms and search results. The column name needs to be specified for GET requests.


Column Name Column Label Data Type Valid Values Notes UCDs
kic_kepler_id Kepler ID long range: 1 to 13,161,029 Unique Kepler ID. Also used in Kepler Target Catalog and in naming data files. ID_MAIN
kic_degree_ra RA (J2000) double range: 0.327 to 347.5596 degrees Right Ascension (J2000) in decimal degrees. All but roughly 36,000 photometric standards, are within the Kepler FOV. POS_EQ_RA_MAIN
kic_dec Dec (J2000) double range: -0.503 to 85.398 degrees Declination (J2000) in decimal degrees. All but roughly 36,000 photometric standards, are within the Kepler FOV. POS_EQ_DEC_MAIN
kic_pmra RA PM (arcsec/yr) float range: -8.572 to 9.04 arcsec/yr RA proper motion POS_PM
kic_pmdec Dec PM (arcsec/yr) float range: -8.75 to 8.848 arcsec/yr Dec proper motion POS_PM
kic_umag u Mag float range: 8.391 to 21.146 u-band SDSS magnitude accurate to 0.04 magnitude PHOT_MAG_U
kic_gmag g Mag float range: 2.872 to 25.4 g-band SDSS magnitude PHOT_MAG_G
kic_rmag r Mag float range: 2.895 to 25.114 r-band SDSS magnitude PHOT_MAG_M
kic_imag i Mag float range: 5.659 to 26.141 i-band SDSS magnitude PHOT_MAG_I
kic_zmag z Mag float range: 5.307 to 19.416 z-band SDSS magnitude accurate to 0.03 magnitude PHOT_MAG_Z
kic_gredmag gred Mag float range: 6.783 to 19.133 gred-band SDSS magnitude PHOT_MAG_UNDEF
kic_d51mag D51 Mag float range: 7.018 to 19.902 D51-band magnitude PHOT_MAG_UNDEF
kic_jmag J Mag float range: 0.001 to 19.873 2MASS J-band magnitude PHOT_MAG_J
kic_hmag H Mag float range: 0.0001 to 20.519 2MASS H-band magnitude PHOT_MAG_H
kic_kmag K Mag float range: 0.001 to 18.734 2MASS K-band magnitude PHOT_MAG_K
kic_kepmag Kepler Mag float range: 2.982 to 25.0 Kepler-band magnitude PHOT_MAG_UNDEF
kic_2mass_id 2MASS ID char range: 2MASS catalog ID, a sexagesimal, equatorial position-based source name in the form: hhmmssss+ddmmsss[ABC...] (Note this entry was added by MAST, and was not included in the KIC). ID_CATALOG
kic_tmid 2MASS Designation long range: 79221107 to 1316970448 Unique integer designation for 2MASS catalog provided by KIC ID_CATALOG
kic_scpid SCP ID long range: 79224191 to 1316970448 Unique SCP processing ID
kic_altid Alt ID long range: 0 to 46836725 ID from alternate source catalog (see Alt ID Source entry) ID_CATALOG
kic_altsource Alt ID Source long 0 - null, 1 - Hipparcos catalog ID, 2 - Tycho2 ID, 3 - UCAC2 ID, 4 - General Catalog of Var. Stars ID, 5 - Lepine proper motion catalog star. altid>0 is 2MASS ID, altid< 0 is a pseudo-id generated by SCP processing, 6 - altid contains 2MASS ID coming from Astroseiseismology catalog, 11 - NED ID, 12 - Extended 2MASS ID, 13 - FIRST ID, 14 - NVSS catalog ID, 15 - VLBA catalog ID, 16 - CHANDRA catalog ID Source catalog that was used for deriving stellar parameters. ID_CATALOG
kic_galaxy Star/Gal ID long 1 - galaxy, 0 - star Star/galaxy indicator based on the USNO-B star/galaxy estimator. 1 = USNO-B values 0 to 5, 0 = values 6 to 11. The values 0 - 11 were a measure of the similarity between a given image to a stellar point spread function. 0 is quite dissimilar, 11 means quite similar. ID_GROUP
kic_blend Isolated/Blend ID long Not yet (and may never be) determined. All values are null. Isolated/blended indicator ID_GROUP
kic_variable Var. ID long 0 - constant, 1 - variable Constant/variable indicator based on data from the General Catalog of Variable Stars. (Additional catalogs will be used in future versions.) ID_GROUP
kic_teff Teff (deg K) long range: 3103 to 19337 degrees K Derived Effective Temperature accurate to 200 K PHYS_TEMP_EFFEC
kic_logg Log G (cm/s/s) float range: -0.435 to 6.158 Derived Log10 surface gravity accurate to 0.5 dex PHYS_GRAVITY_SURFACE
kic_feh Metallicity (solar=0.0) float range: -2.63 - 0.618 Derived Log10 Fe/H metallicity accurate to 0.5 dex. PHYS_ABUND_[FE/H]
kic_ebminusv E(B-V) float range: 0.001 to 1.459 Derived Excess B-V reddening accurate to 0.1 magnitude PHOT_COLOR_EXCESS
kic_av A_V float range: 0.003 to 4.523 Derived A-V extinction PHOT_EXTINCTION
kic_radius Radius (solar=1.0) float range: 0.097 to 316.303 Estimated Stellar Radius (solar = 1.0) PHYS_SIZE_RADIUS
kic_cq Kepmag Source char SCP, 2MASS, UNCAL, PHOTO, and TYBV. SCP - SCP values for sdssg and sdssr were used to compute KEPMAG using equation below . The error for KEPMAG is roughly 0.03 mag., NOCAL - No calibration to optical mag. possible, used for entries from non-optical catalogs. KEPMAG field is null. , 2MASS - Objects found only in 2MASS Catalog with no optical counterpart, KEPMAG is null, UNCAL - KEPMAG copied from a single color of the parent catalog, uncertainty could be 1.0 mag or higher, PHOTO - parent catalog contained a red and blue mag. obtained from Photographic photometry. Values used to compute KEPMAG on the basis of: sdssg=blue sdssr=red color=sdssg-sdssr if (color<=0.8) kepmag = 0.8*sdssr + 0.2*sdssg else kepmag = 0.9*sdssr+0.1*sdssg, internal photographic errors have errors of 0.2 mag suggest KEPMAG errors of 0.03 mag, TYBV - parent catalog is Tycho-2 and this gives B and V magnitudes. KEPMAG value computed from sdssg=0.54*b+0.46*v-0.07 sdssr=-0.44*b+1.44*v+0.12 using same transformation as above to calc. KEPMAG. Errors same as for TYCHO-2 catalog. Source of Kepler-band magnitude
kic_pq Photometry Qual long range: 0 to 8 which is the count of non-null entries in USNO-B1.0 (O,E,J,F,N), UCAC-2 (R), TYcho-2 (B,V). In general the more colors the more likely the star is real. For NOCAL and 2MASS entries, this value = 0. Photometry quality indicator. Placeholder for SCP values not yet determined.
kic_aq Astrophysics Qual long range: 0 to 6 which is the count of non-null entries in Teff, logG, FeH, AV, E(B-V), and Radius. Astrophysics quality indicator. Placeholder for SCP values not yet determined.
kic_catkey Catalog key long range: 1 to 13363924 Unique integer key to CATKEY database (not currently available)
kic_scpkey Scp Key long range: 262005541 to 1305757193 Unique integer key to SCPKEY database table (not currently available)
kic_parallax Parallax (arcsec) float range: -.0297 - 0.0529 arcsec Parallax in arcsec POS_PARLX
kic_glon Gal Lon (deg) float range: 2.85 to 348.8598 degrees Galactic Longitude POS_GAL_LON
kic_glat Gal Lat (deg) float range: -58.363 to 79.231 degrees Galactic Latitude POS_GAL_LAT
kic_pmtotal Total PM (arcsec/yr) float range: 0.0 to 9.61 arcsec/yr Total proper motion accurate to 20 mas/yr POS_PM
kic_grcolor g-r color float range: -11.54 to 11.43 g-r SDSS color
kic_jkcolor J-K color float range: -7.76 to 8.205 J-K color
kic_gkcolor G-K color float range: -6.674 to 16.452 G-K color
kic_ra RA hours (J2000) float range: 0.218 to 23.17 hours Right Ascension (J2000) in decimal hours
kic_fov_flag FOV Flag long 0 - outside FOV, 1 - in FOV but not listed in Kepler Target Catalog, 2 - in FOV and listed in KTC Serves two purposes: 1) a rough estimate for flagging entries which are clearly outside the Kepler field of view. (About 40,000 entries of the 13 million fall in this category.), 2) a value of 2 indicates entries listed in the Kepler Target Catalog (i.e., observed targets).