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

KEPLER Search Output Columns

This document defines the catalog entries describing the KEPLER Data Archive.

Clicking on entries in this column will mark the entry for retrieval. To mark all entries, click one of the buttons labelled 'Mark All','Mark public', or 'Mark Proprietary'. (Unmarking all entries can be done the same way using the appropriate button.) For missions with proprietary data, the mark button element will have a yellow background and a '@' symbol to indicate data sets not yet public.

To Retrieve:
Click the button labelled 'Submit marked data for retrieval from STDADS'. This will send all the marked data set names to the data retrieval page. Follow the directions on the displayed pages.

To Coplot:
After selecting up to 15 observations to be plotted, click on the "Plot marked spectra" button to coplot the selected observations.

The spectra that you selected will be automatically scaled to the full range of wavelengths and nearly the full range of fluxes (i.e., y axis plot scale runs from 0 (or .25 * the minimum flux for spectra with negative fluxes) to the 10th highest flux). Each spectrum is automatically assigned a color, up to a maximum of 15.

For plotting Kepler light curves, y-axis scaling is slightly different. Plots scale simply from the minimum to the maximum flux. It is also recommended that only Kepler light curves from the same target be co-plotted due to the differences in flux values.

The spectra are labelled by their dataset names, with a summary of the datasets plotted given below the plot. After inspecting the plot, you may wish to change the selection of datasets which are displayed. Use your browser "Back" button to do this.

Plot range
Adjust the minimum and maximum wavelengths (in Angstroms) and minimum and maximum fluxes (in erg /cm2/sec/A) to select the spectral region of interest and to exclude noisy data. Note Kepler light curves are in units of time and uncalibrated fluxes.

Plot dimensions
Adjust the X size and Y size in pixels to create the size of plot desired. The maximum dimensions are 850 by 640 pixels.

Redraw plot
Use this button to replot the spectra when you have changed the plot range or plot dimensions.

Column Information

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

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).)

Pep ID
An integer representation of the investigation ID used by Data Management.
range -1 to 210

Dataset Name
Dataset name associated with exposure in the form kplr[kepler_id]_[timestamp].
KPLR00000020-2010203153838, KPLR02961618-2010169030214, KPLR001028012-2009168180601

A sequential number indicating the quarter in which the exposure was made.
range 0 to greater than 14

Data Release
Describes the latest data release for a particular exposure.
range: 12 to greater than 20

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

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"

Target Type
2-character Target type
Either LC (long cadence) or SC (short cadence)

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.

Current number of known papers referencing this dataset.
range: 0 to 7

Actual Start Time
Start time from LC_START FITS keyword (?)
example: 2009-05-02 00:40:43

Actual End Time
End time from LC_END FITS keyword
example: 2009-05-11 17:51:31

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"

RA proper motion
range: -0.80 to 0.9 arcsec/yr

Dec PM
Dec proper motion
range: -0.8 to 0.71 arcsec/yr

U Mag
U-band magnitude accurate to 0.04 magnitude
range: 10.23 to 20.8

G Mag
G-band magnitude
range: 5.4 to 21.5

R Mag
R-band magnitude
range: 5. to 20.3

I Mag
I-band magnitude
range: 6.6 to 20.7

Z Mag
Z-band magnitude accurate to 0.03 magnitude
range: 5.8 to 17.7

GRed Mag
GRed-band magnitude
range: 8.5 to 18.6

D51 Mag
D51-band magnitude
range: 7.9 to 19.

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

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

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

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

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

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 for information on the pts_key/cntr field.
range: 79221108 to 1305757552

2MASS 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.

Unique SCP processing ID
range: 79226018 to 1305757552

Alt ID
ID from alternate source catalog (see Alt ID Source entry)
range: -1224784 to 1065212930

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

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.

Isolated/Blend ID
Isolated/blended indicator
Never populated. All values are null.

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

Derived Effective Temperature accurate to 200 K
range: 3109 to 19337 degrees K

Log G
Derived Log10 surface gravity accurate to 0.5 dex
range: -0.354 to 6.158

Derived Log10 Fe/H metallicity accurate to 0.5 dex.
range: -2.57 to 0.62

Derived Excess B-V reddening accurate to 0.1 magnitude
range: 0.001 to 0.48

Derived A-V extinction
range: 0.003 to 1.49

Estimated Stellar Radius (solar = 1.0)
range: 0.1 to 291.3

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.

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.

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.

Catalog key
Unique integer key to CATKEY database (not currently available)
range: 584880 to 12812794

Scp Key
Unique integer key to SCPKEY database table (not currently available)
range: 262005541 to 1305756193

Parallax in arcsec
range: -.029 - 0.028 arcsec

Gal Lon
Galactic Longitude
range: 68.1 to 84.5 degrees

Gal Lat
Galactic Latitude
range: 5.5 to 21.48 degrees

Total PM
Total proper motion accurate to 20 mas/yr
range: 0.0 to 0.93 arcsec/yr

G-R color
G-R color.
range: -4.72 to 9.7

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

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

Processing Date
Date file was ingested into archive
2011-04-07 23:11:44

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

1.0 - the crowding value
range: 1 to 0

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

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.

RMS Combined Differential Photometric Precision (CDPP) on 6.0-hour time scales in units of parts per million.

RMS Combined Differential Photometric Precision (CDPP) on 12-hour time scales in units of parts per million.

Module number.
range 2 to 24

Ouput number.
range 1 to 4

Channel number.
range 1 to 84

Skygroup Number.
range 1 to 84

Condition flag
Flags various categories of data as a semi-colon separated list.
See the condition_flag page for currently flagged conditions.