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

Table: skymapper_dr1.master
(The bold columns are indexed columns)
Column NameDescriptionDatatype
aMean r-band semi-major axis lengthREAL
allwise_cntrUnique identifier (cntr) of closest AllWISE sourceBIGINT
allwise_distDistance on sky to closest AllWISE sourceREAL
apass_distDistance on sky to closest APASS DR9 sourceREAL
apass_recno0BIGINT
bMean r-band semi-minor axis lengthREAL
class_star0REAL
dej2000Mean ICRS Declination of the objectDOUBLE
e_aError in mean r-band semi-major axis lengthREAL
e_bError in mean r-band semi-minor axis lengthREAL
e_dej2000RMS variation around the mean Declination, in milliarcsecondsINTEGER
e_g_petroError in g-band Petrosian magnitudeREAL
e_g_psfError in g-band PSF magnitudeREAL
e_i_petroError in i-band Petrosian magnitudeREAL
e_i_psfError in i-band PSF magnitudeREAL
e_paError in mean r-band position angleREAL
e_r_petroError in r-band Petrosian magnitudeREAL
e_r_psfError in r-band PSF magnitudeREAL
e_raj2000RMS variation around the mean Right AscensionINTEGER
e_u_petroError in u-band Petrosian magnitudeREAL
e_u_psfError in u-band PSF magnitudeREAL
e_v_petroError in v-band Petrosian magnitudeDOUBLE
e_v_psfError in v-band PSF magnitudeREAL
e_z_petroError in z-band Petrosian magnitudeREAL
e_z_psfError in z-band PSF magnitudeREAL
ebmv_sfdE(B-V) from Schlegel+1998 extinction maps at the ICRS coordinatesREAL
edr_distDistance to closest Early Data Release sourceREAL
edr_idobject_id of closest Early Data Release sourceBIGINT
elatEcliptic latitudeDOUBLE
elonEcliptic longitudeDOUBLE
flagsBitwise OR of Source Extractor flags from photometry tableINTEGER
g_flags0SMALLINT
g_nchNumber of g-band child sources combined into this object_idSMALLINT
g_ngoodNumber of g-band observations usedSMALLINT
g_nimaflags0INTEGER
g_nvisit0SMALLINT
g_petroMean g-band ZP-corrected Petrosian magnitudeDOUBLE
g_psfMean g-band PSF magnitudeREAL
gaia_dr1_distDistance on sky to closest Gaia DR1 sourceREAL
gaia_dr1_idUnique identifier (source_id) of closest Gaia DR1 sourceBIGINT
galex_bcs_distDistance on sky to closest GALEX AIS sourceREAL
galex_bcs_id0BIGINT
glat0REAL
glon0REAL
htm9HTM index (order 9 => ~10 arcmin size)INTEGER
i_flags0SMALLINT
i_nchNumber of i-band child sources combined into this object_idSMALLINT
i_ngoodNumber of i-band observations usedSMALLINT
i_nimaflags0INTEGER
i_nvisit0SMALLINT
i_petroMean i-band Petrosian magnitudeREAL
i_psfMean i-band PSF magnitudeREAL
mean_epochMean MJD epoch of the observationsDOUBLE
nch_max0SMALLINT
nest4096HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size)INTEGER
ngoodNumber of observations used across all filtersSMALLINT
ngood_min0SMALLINT
nimaflags0INTEGER
object_idGlobal unique object ID in the master table.BIGINT
paMean r-band position angle (E of N, -90..+90 deg)REAL
proxDistance to closest EDR sourceREAL
prox_idobject_id of next-closest DR1 sourceBIGINT
ps1_dr1_distDistance on sky to closest Pan-STARRS1 DR1 sourceREAL
ps1_dr1_idUnique identifier (objID) of closest Pan-STARRS1 DR1 sourceBIGINT
r_flags0SMALLINT
r_nchNumber of r-band child sources combined into this object_idSMALLINT
r_ngoodNumber of r-band observations usedSMALLINT
r_nimaflags0INTEGER
r_nvisit0SMALLINT
r_petroMean r-band Petrosian magnitudeREAL
r_psfMean r-band PSF magnitudeREAL
radius_petroMean r-band Petrosian radiusDOUBLE
raj2000Mean ICRS Right Ascension of the objectDOUBLE
random_idRandom ID in the range 0.0 => 100.0REAL
ring256HEALPIX index (Nsides 256 => ~14 arcmin size)INTEGER
rms_epochRMS variation around the mean epochREAL
smss_j0VARCHAR
twomass_cat12MASS catalogue of closest match (point source PSC, or extended XSC)VARCHAR
twomass_cat20VARCHAR
twomass_dist1Distance on sky to closest 2MASS sourceREAL
twomass_dist2Distance on sky to second closest 2MASS sourceREAL
twomass_key1Unique identifier (pts_key/ext_key) of closest 2MASS sourceBIGINT
twomass_key2Unique identifier (pts_key/ext_key) of second closest 2MASS sourceBIGINT
u_flags0SMALLINT
u_nchNumber of u-band child sources combined into this object_idSMALLINT
u_ngoodNumber of u-band observations usedSMALLINT
u_nimaflags0INTEGER
u_nvisit0SMALLINT
u_petroMean u-band ZP-corrected Petrosian magnitudeDOUBLE
u_psfMean u-band ZP-corrected PSF magnitudeDOUBLE
ucac4_distDistance on sky to closest UCAC4 sourceREAL
ucac4_mposUnique identifier (mpos) of closest UCAC4 sourceBIGINT
v_flags0SMALLINT
v_nchNumber of v-band child sources combined into this object_idSMALLINT
v_ngoodNumber of v-band observations usedSMALLINT
v_nimaflags0INTEGER
v_nvisit0SMALLINT
v_petroMean v-band Petrosian magnitudeREAL
v_psfMean v-band PSF magnitudeREAL
z_flags0SMALLINT
z_nchNumber of z-band child sources combined into this object_idSMALLINT
z_ngoodNumber of z-band observations usedSMALLINT
z_nimaflags0INTEGER
z_nvisit0SMALLINT
z_petroMean z-band Petrosian magnitudeREAL
z_psfMean z-band PSF magnitudeREAL