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


KEPLER 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_KTC_KIC_SCIENCE_V View. Combines kepler taget catalog with the KIC, SCIENCE table, and other parameters added by MAST.
Last Update: June 10, 2013

Column Name Column Label Description Examples/Valid Values Data Type
Column Name Column Label Description Examples/Valid Values Data Type
ktc_kepler_id Kepler ID 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. range: 757,076 to < 13 million and 100 million to 100,004,144 integer
ktc_investigation_id Investigation ID Investigation ID assigned by the Kepler project describing a particular GO or project observing program. EX, STKS, GO1000, etc. (Note wild cards are added automatically before and after the user-entered ID(s).) string
sci_data_set_name Dataset Name Dataset name associated with exposure in the form kplr[kepler_id]_[timestamp]. KPLR00000020-2010203153838, KPLR02961618-2010169030214, KPLR001028012-2009168180601 string
sci_data_quarter Quarter A sequential number indicating the quarter in which the exposure was made. range 0 to greater than 14 integer
sci_data_rel Data Release Describes the latest data release for a particular exposure. range: 12 to greater than 20 integer
sci_ra RA (J2000) Right Ascension in decimal degrees as extracted from the ingested FITS file headers (i.e., these are not extracted from KIC.) 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 ra
sci_dec Dec (J2000) Declination in decimal degrees (from the FITS file headers of ingested files (i.e., they are not extracted from KIC) range: 36.56 to 52.47, stored in decimal degrees but can be queried using values such as: "+37 14 04.5", "37.23458" dec
ktc_target_type Target Type 2-character Target type Either LC (long cadence) or SC (short cadence) ustring
sci_archive_class Archive Class archive class in science table used to distinguish long and short cadence light curves and target pixel files CLC, CSC, TPL or TPS. Note if both a light curve and a target pixel file exist, or just a light curve file exists, the archive class will refer to the light curve. string
refnum Ref Current number of known papers referencing this dataset. range: 0 to 7 integer
sci_start_time Actual Start Time Start time from LC_START FITS keyword (?) example: 2009-05-02 00:40:43 datetime
sci_end_time Actual End Time End time from LC_END FITS keyword example: 2009-05-11 17:51:31 datetime
sci_release_date Release Date Date on which data becomes public. As of November, 2012, most Kepler data is now public. example: 2009-10-14 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
kic_pmra RA PM RA proper motion range: -0.80 to 0.9 arcsec/yr float
kic_pmdec Dec PM Dec proper motion range: -0.8 to 0.71 arcsec/yr float
kic_umag U Mag U-band magnitude accurate to 0.04 magnitude range: 10.23 to 20.8 float
kic_gmag G Mag G-band magnitude range: 5.4 to 21.5 float
kic_rmag R Mag R-band magnitude range: 5. to 20.3 float
kic_imag I Mag I-band magnitude range: 6.6 to 20.7 float
kic_zmag Z Mag Z-band magnitude accurate to 0.03 magnitude range: 5.8 to 17.7 float
kic_gredmag GRed Mag GRed-band magnitude range: 8.5 to 18.6 float
kic_d51mag D51 Mag D51-band magnitude range: 7.9 to 19. float
twoMass_jmag J Mag 2MASS J-band magnitude. . In some cases KIC values were replaced with values based on cross-correlations performed by MAST. (See 2mass_conflict_flag). range: 1.07 to 17.3 float
twoMass_hmag H Mag 2MASS H-band magnitude. In some cases KIC values were replaced with values based on cross-correlations performed by MAST. (See 2mass_conflict_flag). range: 0.01 to 18 float
twoMass_kmag K Mag 2MASS K-band magnitude. In some cases KIC values were replaced with values based on cross-correlations performed by MAST. (See 2mass_conflict_flag). range: 0.001 to 17.4 float
kic_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: 5. to 20.7 float
twoMass_2mass_id 2MASS ID 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). example: 19245798+3644595 string
twoMass_tmid 2MASS Designation A unique identification number which was defined during final processing to identify a 2Mass catalog entry. The unique identification number is referred to as pts_key/cntr. See the User's Guide to the 2Mass All Sky Data Release, at http://www.ipac.caltech.edu/2mass/releases/allsky/doc/explsup.html for information on the pts_key/cntr field. range: 79221108 to 1305757552 integer
twoMass_conflictFlag twoMass conflict flag Describes the difference (if any) between 2MASS values derived by MAST staff and the original KIC 2MASS entries. (See the KIC table to find the original uncorrected values.) Conditions currently flagged include: null - KIC contained a null entry and MAST could not find a match, 0 - KIC entry agreed with MAST found entry, 1 - a new 2MASS entry replaced a null KIC entry, 2 - a null value replaced a KIC non-null entry, 3 - a new non-null entry replaced a non-null KIC entry. See the 2mass notes for more information. string
kic_scpid SCP ID Unique SCP processing ID range: 79226018 to 1305757552 integer
kic_altid Alt ID ID from alternate source catalog (see Alt ID Source entry) range: -1224784 to 1065212930 integer
kic_altsource Alt ID Source Source catalog that was used for deriving stellar parameters. current range is from 1 to 14: 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 integer
kic_galaxy Star/Gal ID 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. 0 = star, 1 = galaxy. integer
kic_blend Isolated/Blend ID Isolated/blended indicator Never populated. All values are null. integer
kic_variable Var. ID Constant/variable indicator based on data from the General Catalog of Variable Stars. (Additional catalogs will be used in future versions.) 0 - constant, 1 - variable, currently all 0's integer
kic_teff Teff Derived Effective Temperature accurate to 200 K range: 3109 to 19337 degrees K integer
kic_logg Log G Derived Log10 surface gravity accurate to 0.5 dex range: -0.354 to 6.158 float
kic_feh Metallicity Derived Log10 Fe/H metallicity accurate to 0.5 dex. range: -2.57 to 0.62 float
kic_ebminusv E(B-V) Derived Excess B-V reddening accurate to 0.1 magnitude range: 0.001 to 0.48 float
kic_av A_V Derived A-V extinction range: 0.003 to 1.49 float
kic_radius Radius Estimated Stellar Radius (solar = 1.0) range: 0.1 to 291.3 float
kic_cq Kepmag Source Source of Kepler-band magnitude 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. string
kic_pq Photometry Qual Photometry quality indicator. Placeholder for SCP values not yet determined. 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. integer
kic_aq Astrophysics Qual Astrophysics quality indicator. Placeholder for SCP values not yet determined. range: 0 to 6 which is the count of non-null entries in Teff, logG, FeH, AV, E(B-V), and Radius. integer
kic_catkey Catalog key Unique integer key to CATKEY database (not currently available) range: 584880 to 12812794 integer
kic_scpkey Scp Key Unique integer key to SCPKEY database table (not currently available) range: 262005541 to 1305756193 integer
kic_parallax Parallax Parallax in arcsec range: -.029 - 0.028 arcsec float
kic_glon Gal Lon Galactic Longitude range: 68.1 to 84.5 degrees float
kic_glat Gal Lat Galactic Latitude range: 5.5 to 21.48 degrees float
kic_pmtotal Total PM Total proper motion accurate to 20 mas/yr range: 0.0 to 0.93 arcsec/yr float
kic_grcolor G-R color G-R color. range: -4.72 to 9.7 float
twoMass_jkcolor J-K color J-K color. In some cases KIC values were replaced with values based on cross-correlations performed by MAST. (See 2mass_conflict_flag). range: -1.32 to 8.02 float
twoMass_gkcolor G-K color G-K color. In some cases KIC values were replaced with values based on cross-correlations performed by MAST. (See 2mass_conflict_flag). range: -4.89 to 14.57 float
sci_generation_date Processing Date Date file was ingested into archive 2011-04-07 23:11:44 datetime
sci_crowdsap crowding The ratio of target flux to total flux in optimal aperture. This value is not to be confused with the Crowding values given on the Target Search page which give predictive values. range: 0 to 1 float
sci_contamination contamination 1.0 - the crowding value range: 1 to 0 float
sci_flfrcsap flux fraction The fraction of target flux obtained in the optimal aperture averaged for the specified data. The flux fraction in any given cadence will differ from this mean value. This value is not to be confused with the Flux Fraction value given on the Target Search page which gives a predictive values. range: 0.19 to 1 float
sci_Cdpp3_0 cdpp3 The RMS Combined Differential Photometric Precision (CDPP) time series calculated by the Kepler pipeline for a transit duration of length 3-hrs over a single quarter, in units of parts per million. float
sci_Cdpp6_0 cdpp6 RMS Combined Differential Photometric Precision (CDPP) on 6.0-hour time scales in units of parts per million. float
sci_Cdpp12_0 cdpp12 RMS Combined Differential Photometric Precision (CDPP) on 12-hour time scales in units of parts per million. float
sci_module Module Module number. range 2 to 24 integer
sci_output Output Ouput number. range 1 to 4 integer
sci_channel Channel Channel number. range 1 to 84 integer
sci_skygroup_id Skygroup_ID Skygroup Number. range 1 to 84 integer
condition_flag Condition flag Flags various categories of data as a semi-colon separated list. See the condition_flag page for currently flagged conditions. string

spacer
spacer
spacer
spacer