KEPLER_FOV_NEW

Master ID

A unique ID for all targets in table.
example: 19045085+3723043

Table key

Unique sequential number.
range: 756,968 to 12,984,453

RA (J2000)

Right Ascension (J2000) in decimal degrees for all targets (not just KIC).
range: 279.61 to 301.86 degrees

Dec (J2000)

Declination (J2000) in decimal degrees for all targets (not just KIC).
range: 36.5 to 52.48 degrees

Kepler_ID

Unique Kepler ID. Also used in Kepler Target Catalog and in naming data files. Note there are 4,374,730 entries in the KIC_CT joined table
range: 756,968 to 12,984,453

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: 19045085+3723043

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: 79225944 to 1305757552

twoMass conflict flag

Describes 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 '2MASS ID' contained a null entry and MAST could not find a match, 0 - KIC non-null value agreed with value found by MAST, 1 - a new entry replaced a null KIC entry, 2 - a null entry 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.

KIC RA (J2000)

Right Ascension (J2000) in decimal degrees from KIC. All but roughly 36,000 photometric standards, are within the Kepler FOV.
range: 279.61 to 301.86 degrees

KIC Dec (J2000)

Declination (J2000) in decimal degrees from KIC. All but roughly 36,000 photometric standards, are within the Kepler FOV.
range: 36.5 to 52.48 degrees

Data Availability Flag

Data availability flag. 0 = not observed or planned to be observed, 1 = target is either planned to be observed or has been observed but data has not yet been archived, and 2 means data for the particular target has been archived. The flag values will be updated quarterly.
0, 1 or 2

RA_PM (arcsec/yr)

RA proper motion
range: -8.36 to 8.04 arcsec/yr

Dec_PM (arcsec/yr)

Dec proper motion
range: -7.2 to 8.848 arcsec/yr

SCP_ID

SCP processing ID
range: 79226018 to 1305757552

Alt_ID

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

Alt_ID_Source

Source catalog that was used for deriving stellar parameters.
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

A flag where 0 = star and 1 = galaxy. The original USNO-B catalog codes these with 11 values, depending on the degree that measured image profile was consistent with a point source. The USNO-B codes were star = 6-11 and galaxy = 0-5.
1? = USNO-B values 0 to 5 (i.e., a galaxy), 0? = values 6 to 11 (i.e., a star). 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.

Isolated/Blend_ID

Isolated/blended indicator
Not yet (and may never be) determined. 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

Teff

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

Log_G

Derived Log10 surface gravity accurate to 0.5 dex
range: -0.44 to 6.16

Metallicity (solar=0.0)

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

E(B-V)

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

A_V

Derived A-V extinction
range: 0.003 to 1.53

Radius (solar=1.0)

Estimated Stellar Radius (solar = 1.0)
range: 0.097 to 316.30

Kepmag_Source

Source of Kepler-band magnitude.
SCP, NOCAL, 2MASS, UNCAL, PHOTO, 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.
range: Integer from 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. Stars with low values (e.g., < 3) may not be real and should be verified by other means.

Astrophysics_Qual

Astrophysics quality indicator. Placeholder for SCP values not yet determined.
range: currently 0 to 6 which is the count of all non-null entries in Teff, logG, FeH, AV, E(B-V), and Radius.

Catalog_key

Unique integer key to CATKEY database table (not currently available).
range: 584772 to 12812825

Scp_Key

Unique integer key to SCPKEY database table (not currently available).
range: 262005541 to 1305757193

Parallax (arcsec)

Parallax in arcsec
range: -0.0297 to 0.028 arcsec

Gal_Lon (deg)

Galactic Longitude
range: 68.099 to 84.53 degrees

Gal_Lat (deg)

Galactic Latitude
range: 5.50 to 21.48 degrees

Total_PM (arcsec/yr)

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

RA_hours (J2000)

Right Ascension (J2000) in decimal hours
range: 18.64 to 20.12 hours

Skygroup_ID

An integer value from 1 to 84 describing the module/channel where the target falls. It's equivalent to the channel number during season 2. The sky group is an integer that groups stars together on the sky depending on which channel they fall on (or near) during season 2. Due to slight asymmetries in the CCD array layout, positions are not perfectly maintainted upon seasonal rotation of the spacecraft. Therefore, there are objects that fall off silicon during season 2 but are on silicon in subsequent seasons. This is especially problematic for Module 13 due to the center gap. Such stars are assigned the sky group corresponding to the other stars that fall on the same channel during other seasons.
range: 1 - 84

Crowding season 0

A floating point number between 0 and 1 representing the fraction of light in the aperture due to the target star for season N. A value of 1 means all the light is from the target while a value of 0.5 means half of the light through the aperture is due to the target.
range: 8e-05 to 0.999

Crowding season 1

A floating point number between 0 and 1 representing the fraction of light in the aperture due to the target star for season 1. A value of 1 means all the light is from the target while a value of 0.5 means half of the light through the aperture is due to the target.
range: 2e-05 to 0.999

Crowding season 2

A floating point number between 0 and 1 representing the fraction of light in the aperture due to the target star for season 2. A value of 1 means all the light is from the target while a value of 0.5 means half of the light through the aperture is due to the target.
range: 1e-04 to 0.999

Crowding season 3

A floating point number between 0 and 1 representing the fraction of light in the aperture due to the target star for season 3. A value of 1 means all the light is from the target while a value of 0.5 means half of the light through the aperture is due to the target.
range: 8.4e-05 to 0.999

Seasons_on_CCD

Number of seasons a target is on the detector. For targets with a known Kepler magnitude, this represents the number of seasons with a distance of 0 or greater. For targets with unknown Kepler magnitudes, this is based on the number of seasons with MAST-derived distances (described below) greater than zero.
range 1 to 4 and null (note: null values indicate a non-observable target and by default are not displayed. To see the non-observable entries from the MAST target search page, set "Season's on CCD" to "unspecified".)

Contamination season 0

Measure of light contamination defined as 1 - crowding value. A value of 0 implies no contamination, 1 implies all background.
range 0.001 - 0.999

Contamination season 1

Measure of light contamination defined as 1 - crowding value. A value of 0 implies no contamination, 1 implies all background.
range 0.001 - 0.999

Contamination season 2

Measure of light contamination defined as 1 - crowding value. A value of 0 implies no contamination, 1 implies all background.
range 0.001 - 0.999

Contamination season 3

Measure of light contamination defined as 1 - crowding value. A value of 0 implies no contamination, 1 implies all background.
range 9e-04 - 0.999

Flux Fraction season 0

The fraction of target flux that falls within the photometric aperture. A value of 1 means all the flux from the target falls within the aperture, while a value of 0 means no flux from the target falls within the photometric aperture.
range 0.106 - 0.999

Flux Fraction season 1

The fraction of target flux that falls within the photometric aperture. A value of 1 means all the flux from the target falls within the aperture, while a value of 0 means no flux from the target falls within the photometric aperture.
range 0.104 to 0.999

Flux Fraction season 2

The fraction of target flux that falls within the photometric aperture. A value of 1 means all the flux from the target falls within the aperture, while a value of 0 means no flux from the target falls within the photometric aperture.
range 0.087 to 0.999

Flux Fraction season 3

The fraction of target flux that falls within the photometric aperture. A value of 1 means all the flux from the target falls within the aperture, while a value of 0 means no flux from the target falls within the photometric aperture.
range 0.103 to 0.999

SNR season 0

The ratio of target flux collected within the photometric aperture to the statistical 1-sigma uncertainty in the collected target flux.
range 0.04 to 608602

SNR season 1

The ratio of target flux collected within the photometric aperture to the statistical 1-sigma uncertainty in the collected target flux.
range 0.03 to 607510

SNR season 2

The ratio of target flux collected within the photometric aperture to the statistical 1-sigma uncertainty in the collected target flux.
range 0.04 to 607071

SNR season 3

The ratio of target flux collected within the photometric aperture to the statistical 1-sigma uncertainty in the collected target flux.
range 0.05 to 606119

Edge_Distance_0 (px)

The shortest distance from the edge of the CCD to a pixel in the photometric aperture for season 0. Values of 0 or greater are observable. For targets with undefined Kepler magnitudes, the distance represents the distance in pixels from the nearest edge to the target (i.e., not to the photometric aperture).
range 0 to 511 and null

Edge_Distance_1 (px)

The shortest distance from the edge of the CCD to a pixel in the photometric aperture for season 1. Values of 0 or greater are observable. For targets with undefined Kepler magnitudes, the distance represents the distance in pixels from the nearest edge to the target (i.e., not to the photometric aperture).
range 0 to 511 and null

Edge_Distance_2 (px)

The shortest distance from the edge of the CCD to a pixel in the photometric aperture for season 2. Values of 0 or greater are observable. For targets with undefined Kepler magnitudes, the distance represents the distance in pixels from the nearest edge to the target (i.e., not to the photometric aperture).
range 0 to 511 and null

Edge_Distance_3 (px)

The shortest distance from the edge of the CCD to a pixel in the photometric aperture for season 3. Values of 0 or greater are observable. For targets with undefined Kepler magnitudes, the distance represents the distance in pixels from the nearest edge to the target (i.e., not to the photometric aperture).
range 0 to 511 and null

Channel_0

Integer channel number for season 0. There are 21 modules, each with 4 outputs for a total of 84 channels. CHANNEL is an integer ranging from 1 to 84 that uniquely specifies the MODULE/OUTPUT pair. An object can have a non-zero channel number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
range: 1 to 84

Module_0

Integer module number for season 0. A module refers to a pair of CCDs that share a field flattener and are read out simultaneously by the detector electronics. There are 21 modules on the focal plane. MODULE is an integer from the set [2-4,6-20,22-24]. An object can have a non-zero module number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
2-4,6-20,22-24

Output_0

Each module has four output channels (two per CCD). Each output is read out by a unique analog signal chain (e.g. amplifier). OUTPUT is an integer ranging from 1 to 4. An object can have a non-zero output number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
range 1 to 4

Row_0

Row number for season 0 with values ranging from -232 to 1098. Each channel has 1132 columns and 1070 rows. There are 1024 science rows enumerated as rows 20 through 1043. Collateral data is enumerated as rows 0 through 19 and 1044 through 1069. Values outside 0 through 1069 are enumerated in order to provide information about how far off a target is from the CCD channel.
range 20 to 1043

Column_0

Column number for season 0 defined like the Row values. Each channel has 1132 columns. There are 1100 science channels described as columns 12 - 1111. Collateral values range from 0-11 and 1112-1131. Other values ranging from -205 to -1 describe how far a target is from the CCD channel.
range 13 to 1111

Channel_1

Integer channel number for season 1. There are 21 modules, each with 4 outputs for a total of 84 channels. CHANNEL is an integer ranging from 1 to 84 that uniquely specifies the MODULE/OUTPUT pair. An object can have a non-zero channel number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
range: 1 to 84

Module_1

Integer module number for season 1. A module refers to a pair of CCDs that share a field flattener and are read out simultaneously by the detector electronics. There are 21 modules on the focal plane. MODULE is an integer from the set [2-4,6-20,22-24]. An object can have a non-zero module number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
2-4,6-20,22-24

Output_1

Each module has four output channels (two per CCD). Each output is read out by a unique analog signal chain (e.g. amplifier). OUTPUT is an integer ranging from 1 to 4. An object can have a non-zero output number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
range 1 to 4

Row_1

Row number for season 1 with values ranging from -232 to 1098. Each channel has 1132 columns and 1070 rows. There are 1024 science rows enumerated as rows 20 through 1043. Collateral data is enumerated as rows 0 through 19 and 1044 through 1069. Values outside 0 through 1069 are enumerated in order to provide information about how far off a target is from the CCD channel.
range 20 to 1043

Column_1

Column number for season 1 defined like the Row values. Each channel has 1132 columns. There are 1100 science channels described as columns 12 - 1111. Collateral values range from 0-11 and 1112-1131. Other values ranging from -205 to -1 describe how far a target is from the CCD channel.
range 13 to 1111

Channel_2

Integer channel number for season 2. There are 21 modules, each with 4 outputs for a total of 84 channels. CHANNEL is an integer ranging from 1 to 84 that uniquely specifies the MODULE/OUTPUT pair. An object can have a non-zero channel number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
range: 1 to 84

Module_2

Integer module number for season 2. A module refers to a pair of CCDs that share a field flattener and are read out simultaneously by the detector electronics. There are 21 modules on the focal plane. MODULE is an integer from the set [2-4,6-20,22-24]. An object can have a non-zero module number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
2-4,6-20,22-24

Output_2

Each module has four output channels (two per CCD). Each output is read out by a unique analog signal chain (e.g. amplifier). OUTPUT is an integer ranging from 1 to 4. An object can have a non-zero output number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
range 1 to 4

Row_2

Row number for season 2 with values ranging from -232 to 1098. Each channel has 1132 columns and 1070 rows. There are 1024 science rows enumerated as rows 20 through 1043. Collateral data is enumerated as rows 0 through 19 and 1044 through 1069. Values outside 0 through 1069 are enumerated in order to provide information about how far off a target is from the CCD channel.
range 20 to 1043

Column_2

Column number for season 2 defined like the Row values. Each channel has 1132 columns. There are 1100 science channels described as columns 12 - 1111. Collateral values range from 0-11 and 1112-1131. Other values ranging from -205 to -1 describe how far a target is from the CCD channel.
range 13 to 1111

Channel_3

Integer channel number for season 3. There are 21 modules, each with 4 outputs for a total of 84 channels. CHANNEL is an integer ranging from 1 to 84 that uniquely specifies the MODULE/OUTPUT pair. An object can have a non-zero channel number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
range: 1 to 84

Module_3

Integer module number for season 3. A module refers to a pair of CCDs that share a field flattener and are read out simultaneously by the detector electronics. There are 21 modules on the focal plane. MODULE is an integer from the set [2-4,6-20,22-24]. An object can have a non-zero module number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
2-4,6-20,22-24

Output_3

Each module has four output channels (two per CCD). Each output is read out by a unique analog signal chain (e.g. amplifier). OUTPUT is an integer ranging from 1 to 4. An object can have a non-zero output number if it is off, but near, a CCD. Such cases can be identified by examining the expected ROW and COLUMN values for a specified season.
range 1 to 4

Row_3

Row number for season 3 with values ranging from -232 to 1098. Each channel has 1132 columns and 1070 rows. There are 1024 science rows enumerated as rows 20 through 1043. Collateral data is enumerated as rows 0 through 19 and 1044 through 1069. Values outside 0 through 1069 are enumerated in order to provide information about how far off a target is from the CCD channel.
range 21 to 1043

Column_3

Column number for season 3 defined like the Row values. Each channel has 1132 columns. There are 1100 science channels described as columns 12 - 1111. Collateral values range from 0-11 and 1112-1131. Other values ranging from -205 to -1 describe how far a target is from the CCD channel.
range 13 to 1111

u

u-band magnitude accurate to 0.04 magnitude
range: 10.23 to 20.8

g

g-band magnitude from the Kepler Input Catalog
range: 6.39 to 21.21

r

r-band magnitude from the Kepler Input Catalog
range: 5.9 to 17.41

i

i-band magnitude from the Kepler Input Catalog
range: 6.82 to 18.31

z

z-band magnitude accurate to 0.03 magnitude from the Kepler Input Catalog
range: 5.842 to 17.63

gred

GRed-band magnitude from the Kepler Input Catalog
range: 8.52 to 18.27

d51mag

D51 magnitude from the Kepler Input Catalog
range:

J

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

H

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

K

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

kepmag

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.86 to 17.43

FUV

Galex Far-UV magnitude.
range:

NUV

Galex Near-UV magnitude.
range:

ID_USNO

USNO ID
range:

ra_USNO

USNO Right Ascension in decimal degrees
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_USNO

USNO Declination in decimal degrees
range: 36.56 to 52.47, stored in decimal degrees but can be queried using values such as: "+37 14 04.5", "37.23458"

ID_GALEX

GALEX ID
range:

ra_GALEX

GALEX Right Ascension in decimal degrees
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_GALEX

GALEX Declination in decimal degrees
range: 36.56 to 52.47, stored in decimal degrees but can be queried using values such as: "+37 14 04.5", "37.23458"

2MASS RA (J2000)

Right Ascension (J2000) in decimal degrees from 2MASS. All but roughly 36,000 photometric standards, are within the Kepler FOV.
range: 279.61 to 301.86 degrees

2MASS Dec (J2000)

Declination (J2000) in decimal degrees from 2MASS. All but roughly 36,000 photometric standards, are within the Kepler FOV.
range: 36.5 to 52.48 degrees

ID_IRT

WFCAM Science Archive designation
range:

ra_IRT

UKIRT/WFCAM Right Ascension in decimal degrees
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_IRT

UKIRT/WFCAM Declination in decimal degrees
range: 36.56 to 52.47, stored in decimal degrees but can be queried using values such as: "+37 14 04.5", "37.23458"

pStar_IRT

image-profile-based probability that the source is a star.
range:

J_IRT

J band magnitude in a 2 arcsec diameter aperture on the WFCAM MKO (Vega based) system. This is the default UKIRT magnitude to use for stars. The photometric pipeline provides a maximum likelihood estimate in cases where apertures around multiple sources overlap
range:

JErr_IRT

Error in J_IRT
range:

jClass_IRT

Discrete Image classification flag. -1 = star (i.e. pstar>0.9), 0 = noise, +1 = extended
range:

jppErrBits_IRT

Error bits information relating to reliability of photometry. The number ranges from 0 to 2**32 -1 The flags are ranked in order of severity and are given in . Our Color Table restricts entries to those with severity flag values less than 256.
range:

Sep_IRT

Spatial separation of KIC coordinates from UKIRT/WFCAM coordinates in arcsec.
range:

gr

kic_gmag - kic_rmag
range:

gi

kic_gmag - kic_imag
range:

iz

kic_imag - kic_zmag
range:

gK

kic_gmag - 2mass_Kmag
range:

JH

2mass_jmag - 2mass_hmag
range:

HK

2mass_hmag - 2mass_kmag
range:

JK

2mass_jmag - 2mass_kmag
range:

gJ

kic_gmag - 2mass_jmag
range:

FUVNUV

galexFUV - galexNUV
range:

NUVg

galexNUV - kic_gmag
range:

gJ_KIC_IRT

kic_gmag - IRT_J
range: