Choose a database in the left panel then select the table you want!

(The bold columns are indexed columns)
Column NameDescriptionDatatype
aCatalog identifier of an optical source from either the Tycho 2 or USNO-A2.0 catalog that falls within ~5" of the TWOMASS source position.CHAR
b_m_optBlue magnitude of associated optical source.REAL
bl_flgBlend flag.CHAR
cc_flgContamination and confusion flag.CHAR
coaddSequence number of the Atlas Image in which the position of this source falls.SMALLINT
coadd_keyUnique identification number of the record in the Atlas Image Data Table (NOT YET AVAILABLE) that corresponds to Image in which the position of this source falls.INTEGER
dateThe observation reference date for this source expressed in ISO standard format. (YYYY-MM-DD)CHAR
decJ2000 declination with respect to the ICRSDOUBLE
designationSexagesimal, equatorial position-based source name in the form: hhmmssss+ddmmsss[ABC...].CHAR
dist_edge_ewThe distance from the source to the nearest East or West scan edge.INTEGER
dist_edge_flgTwo character flag that specifies to which scan edges a source lies closest, and to which edges the dist_edge_ns and dist_edge_ew values refer.CHAR
dist_edge_nsThe distance from the source to the nearest North or South scan edge.INTEGER
dist_optDistance separating TWOMASS source position and associated optical source within 5 arcsec.REAL
dup_srcDuplicate source flag.SMALLINT
err_angPosition angle on the sky of the semi-major axis of the position uncertainty ellipse (East of North)SMALLINT
err_majSemi-major axis length of the one sigma position uncertainty ellipseREAL
err_minSemi-minor axis length of the one sigma position uncertainty ellipseREAL
ext_keyUnique identification number of the record in the XSC that corresponds to this point source.INTEGER
gal_contamExtended source "contamination" flag.SMALLINT
glatGalactic latitude rounded to 0.001 deg.REAL
glonGalactic longitude rounded to 0.001 deg.REAL
h_cmsigCorrected photometric uncertainty for the default H-band magnitude.REAL
h_mDefault H-band magnitudeREAL
h_m_stdapH-band "standard" aperture magnitude.REAL
h_msig_stdapUncertainty in the H-band standard aperture magnitude.REAL
h_msigcomCombined, or total photometric uncertainty for the default H-band magnitude.REAL
h_psfchiReduced chi-squared goodness-of-fit value for the H-band profile-fit photometry made on the 1.3 s Read_2 exposures.REAL
h_snrH-band "scan" signal-to-noise ratio.REAL
hemisHemisphere code for the TWOMASS Observatory from which this source was observed.CHAR
j_cmsigCorrected photometric uncertainty for the default J-band magnitude.REAL
j_mDefault J-band magnitudeREAL
j_m_stdapJ-band "standard" aperture magnitude.REAL
j_msig_stdapUncertainty in the J-band standard aperture magnitude.REAL
j_msigcomCombined, or total photometric uncertainty for the default J-band magnitude.REAL
j_psfchiReduced chi-squared goodness-of-fit value for the J-band profile-fit photometry made on the 1.3 s Read_2 exposures.REAL
j_snrJ-band "scan" signal-to-noise ratio.REAL
jdateThe Julian Date of the source measurement accurate to +-30 seconds.DOUBLE
k_cmsigCorrected photometric uncertainty for the default Ks-band magnitude.REAL
k_mDefault Ks-band magnitudeREAL
k_m_stdapKs-band "standard" aperture magnitude.REAL
k_msig_stdapUncertainty in the Ks-band standard aperture magnitude.REAL
k_msigcomCombined, or total photometric uncertainty for the default Ks-band magnitude.REAL
k_psfchiReduced chi-squared goodness-of-fit value for the Ks-band profile-fit photometry made on the 1.3 s Read_2 exposures.REAL
k_snrKs-band "scan" signal-to-noise ratio.REAL
mp_flgMinor Planet Flag.SMALLINT
ndetFrame detection statistics.CHAR
nopt_mchsThe number of USNO-A2.0 or Tycho 2 optical sources found within a 5" radius of the TWOMASS position.SMALLINT
ph_qualPhotometric quality flag.CHAR
phi_optPosition angle on the sky of the vector from the the associated optical source to the TWOMASS source position, in degrees East of North.SMALLINT
proxProximity.REAL
pts_keyA unique identification number for the PSC source.INTEGER
pxcntrThe pts_key value of the nearest source in the PSC.INTEGER
pxpaThe position angle on the sky of the vector from the source to the nearest neighbor in the PSC, in degrees East of North.SMALLINT
raJ2000 right ascension with respect to the ICRSDOUBLE
rd_flgRead flag.CHAR
scanThe nightly scan number in which the source was detected.SMALLINT
scan_keyUnique identification number of the record in the Scan Information Table that corresponds to the survey scan in which this source was detected.INTEGER
use_srcUse source flag.SMALLINT
vr_m_optVisual or red magnitude of the associated optical source.REAL
x_scanMean cross-scan focal plane position of the source in the Universal scan (U-scan) coordinate system.REAL