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