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
ktc_kepler_id Kepler ID long range: 757,076 to 12,984,404 Non-unique Kepler ID identifying corresponding entry in the Kepler Input Catalog. Note multiple observations can be made with the same Kepler ID. Also used in naming data files.
ktc_investigation_id Investigation ID char EX, STKS, GO1000, etc Investigation ID assigned by the Kepler project describing a particular GO or project observing program.
ads_pep_id Pep ID long range 13 to 56 An integer representation of the investigation ID used by Data Management.
ads_data_set_name Dataset Name char KPLR00000020_2010203153838, KPLR02961618_2010169030214, KPLR001028012-2009168180601 Dataset name associated with exposure in the form kplr[kepler_id]_[timestamp]. ID_MAIN
kic_degree_ra RA (J2000) double range: 279.63 to 301.82, although values are stored in decimal degrees, valid formats for queries include: "19 28 29.65", "19h28m29s", 292.12354 Right Ascension in decimal degrees (converted from the KIC decimal hours value) POS_EQ_RA_MAIN
kic_dec Dec (J2000) double range: 36.56 to 52.47, stored in decimal degrees but can be queried using values such as: "+37 14 04.5", "37.23458" Declination in decimal degrees (from KIC) POS_EQ_DEC_MAIN
ktc_target_type Target Type char Either LC (long cadence) or SC (short cadence) 2-character Target type CLASS_OBJECT
ads_start_time Actual Start Time char range: 2009-05-02 00:40:43 to 2009-05-13 00:15:49 Start time from LC_START FITS keyword (?) TIME_DATE
ads_end_time Actual End Time char range: 2009-05-11 17:51:31 to 2009-06-15 11:47:11 End time from LC_END FITS keyword TIME_DATE
ads_release_date Release Date char range: 2009-10-14 12:00:00 to 2011-11-17 14:57:43 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" Date on which data becomes public TIME_DATE
kic_pmra RA PM float range: -0.80 to 0.89 arcsec/yr RA proper motion POS_PM
kic_pmdec Dec PM float range: -0.81 to 0.71 arcsec/yr Dec proper motion POS_PM
kic_umag U Mag float range: 10.23 to 20.8 U-band magnitude accurate to 0.04 magnitude PHOT_MAG_U
kic_gmag G Mag float range: 6.39 to 21.21 G-band magnitude PHOT_MAG_G
kic_rmag R Mag float range: 5.9 to 17.41 R-band magnitude PHOT_MAG_M
kic_imag I Mag float range: 6.82 to 18.31 I-band magnitude PHOT_MAG_I
kic_zmag Z Mag float range: 5.842 to 17.63 Z-band magnitude accurate to 0.03 magnitude PHOT_MAG_Z
kic_gredmag GRed Mag float range: 8.52 to 18.27 GRed-band magnitude PHOT_MAG_UNDEF
kic_d51mag D51 Mag float range: 7.9 to 17.51 D51-band magnitude PHOT_MAG_UNDEF
kic_jmag J Mag float range: 1.07 to 17.02 2MASS J-band magnitude PHOT_MAG_J
kic_hmag H Mag float range: 0.01 to 16.72 2MASS H-band magnitude PHOT_MAG_H
kic_kmag K Mag float range: 0.001 to 17.12 2MASS K-band magnitude PHOT_MAG_K
kic_kepmag KEP Mag float range: 5.86 to 17.43 Kepler-band magnitude as derived in the Kepler Input Catalog. Relative to B and V magnitudes from the Tycho-2 catalog, the Kepler magnitude is calculated as follows: blue = 0.54*B + 0.46*V - 0.07 red = -0.44*B + 1.44*V + 0.12 color = blue - red if color <= 0.8 kepmag = 0.8*red + 0.2*blue else kepmag = 0.9*red + 0.1*blue PHOT_MAG_UNDEF
kic_2mass_id 2MASS ID char example: 19245798+3644595 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: 79221108 to 1305757434 Unique 2MASS catalog ID ID_CATALOG
kic_scpid SCP ID long range: 79226018 to 1305757434 Unique SCP processing ID
kic_altid Alt ID long range: -1224784 to 1065212930 ID from alternate source catalog (see Alt ID Source entry) ID_CATALOG
kic_altsource Alt ID Source long current range is from 1 to 5 but the definitions are: 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 0 = star, 1 = galaxy. 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, currently all 0's 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 long range: 3124 to 19333 degrees K Derived Effective Temperature accurate to 200 K PHYS_TEMP_EFFEC
kic_logg Log G float range: -0.054 to 6.158 Derived Log10 surface gravity accurate to 0.5 dex PHYS_GRAVITY_SURFACE
kic_feh Metallicity float range: -2.57 to 0.62 Derived Log10 Fe/H metallicity accurate to 0.5 dex. PHYS_ABUND_[FE/H]
kic_ebminusv E(B-V) float range: 0.001 to 0.42 Derived Excess B-V reddening accurate to 0.1 magnitude PHOT_COLOR_EXCESS
kic_av A_V float range: 0.003 to 1.31 Derived A-V extinction PHOT_EXTINCTION
kic_radius Radius float range: 0.18 to 291.3 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: 1 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: 584880 to 12812776 Unique integer key to CATKEY database (not currently available)
kic_scpkey Scp Key long range: 262005541 to 1305756149 Unique integer key to SCPKEY database table (not currently available)
kic_parallax Parallax float range: -.029 - 0.028 arcsec Parallax in arcsec POS_PARLX
kic_glon Gal Lon float range: 68.12 to 84.52 degrees Galactic Longitude POS_GAL_LON
kic_glat Gal Lat float range: 5.553 to 21.48 degrees Galactic Latitude POS_GAL_LAT
kic_pmtotal Total PM float range: 0.0 to 0.93 arcsec/yr Total proper motion accurate to 20 mas/yr POS_PM
kic_grcolor G-R color float range: -1.86 to 9.72 G-R color
kic_jkcolor J-K color float range: -1.317 to 8.022 J-K color
kic_gkcolor G-K color float range: -4.89 to 14.573 G-K color
kic_ra RA hours (J2000) float range: 18.64 to 20.12 hours Right Ascension (J2000) in decimal hours
ads_completion_time Processing Date char Date file was ingested into archive