Follow Us
|
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 |
|---|---|---|---|---|---|
| kic_kepler_id | Kepler ID | long | range: 482,249 to 13,160,229 | 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. | |
| ads_pep_id | Proposal ID | long | -1 | Proposal ID associated with exposure. | |
| ads_data_set_name | Dataset Name | char | KPLR00000020_2010203153838, KPLR02961618_2010169030214, KPLR001028012-2009168180601 | Dataset name associated with exposure. | ID_MAIN |
| kic_degree_ra | RA (J2000) | double | although values are stored in decimal degrees, valid formats for queries include: "19 28 29.65", "19h28m29s", 292.12354 | Right Ascension in decimal degrees (from KIC) | POS_EQ_RA_MAIN |
| kic_dec | Dec (J2000) | double | 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 |
| ktc_target_category | Target Category | char | examples: GO, Planetary, Astroseismology, Comparison, PDQ stellar, PPA stellar, SO | Target category | CLASS_OBJECT |
| ktc_obsv_start_time_mjd | Planned Observation Start Time (MJD) | float | example: 343433.0033 | Planned Start time in Julian Date for this set of contiguous data | TIME_DATE |
| ktc_obsv_stop_time_mjd | Planned Observation Stop Time (MJD) | float | example: 343473.023 | Planned Stop time in Julian Date for this set of contiguous data | TIME_DATE |
| ktc_obsv_start_time | Planned Observation Start Time | char | 2012-03-29 04:00:00 | Planned start time in standard date format | TIME_DATE |
| ktc_obsv_stop_time | Planned Observation Stop Time | char | 2012-03-29 04:00:00 | Planned stop time in standard date format | TIME_DATE |
| ktc_counter | KTC Counter | float | integers from 1 to 120,985 | Sequential ID for this view. Values change after each update. | |
| ads_start_time | Actual Start Time | char | 2012-03-29 04:00:00 (currently all null) | Start time from START_TIME FITS keyword (?) | TIME_DATE |
| ads_end_time | Actual End Time | char | 2012-03-29 04:00:00 (currently all null) | End time from END_TIME FITS keyword | TIME_DATE |
| ads_release_date | Release Date | char | 2012-03-29 04: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" | Date on which data becomes public | TIME_DATE |
| kic_pmra | RA PM | float | range: -8.572 to 9.04 arcsec/yr | RA proper motion | POS_PM |
| kic_pmdec | Dec PM | 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 magnitude accurate to 0.04 magnitude | PHOT_MAG_U |
| kic_gmag | G Mag | float | range: 2.872 to 25.4 | G-band magnitude | PHOT_MAG_G |
| kic_rmag | R Mag | float | range: 2.895 to 25.114 | R-band magnitude | PHOT_MAG_M |
| kic_imag | I Mag | float | range: 5.659 to 26.141 | I-band magnitude | PHOT_MAG_I |
| kic_zmag | Z Mag | float | range: 5.307 to 19.416 | Z-band magnitude accurate to 0.03 magnitude | PHOT_MAG_Z |
| kic_gredmag | GRed Mag | float | range: 6.783 to 19.133 | GRed-band 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_tmid | 2MASS ID | long | range: 79221107 to 1316970448 | Unique 2MASS catalog ID | 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 | 0 - galaxy, 1 - star ? | Star/galaxy indicator based on the USNO-B star/galaxy estimator. 0 = USNO-B values 0 to 5, 1 = 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 | long | range: 3103 to 19337 degrees K | Derived Effective Temperature accurate to 200 K | PHYS_TEMP_EFFEC |
| kic_logg | Log G | float | range: -0.435 to 6.158 | Derived Log10 surface gravity accurate to 0.5 dex | PHYS_GRAVITY_SURFACE |
| kic_feh | Metallicity | 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 | 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 | float | range: -.0297 - 0.0529 arcsec | Parallax in arcsec | POS_PARLX |
| kic_glon | Gal Lon | float | range: 2.85 to 348.8598 degrees | Galactic Longitude | POS_GAL_LON |
| kic_glat | Gal Lat | float | range: -58.363 to 79.231 degrees | Galactic Latitude | POS_GAL_LAT |
| kic_pmtotal | Total PM | 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 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 |
 |
|
|
|
|
|
|
|
|
|