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

(The bold columns are indexed columns)
Column NameDescriptionDatatype
allmask_gBitwise mask set if the central pixel from all images satisfy each condition in \(g\)SMALLINT
allmask_iSMALLINT
allmask_rBitwise mask set if the central pixel from all images satisfy each condition in \(r\)SMALLINT
allmask_uSMALLINT
allmask_ySMALLINT
allmask_zBitwise mask set if the central pixel from all images satisfy each condition in \(z\)SMALLINT
anymask_gBitwise mask set if the central pixel from any image satisfies each condition in \(g\)SMALLINT
anymask_iSMALLINT
anymask_rBitwise mask set if the central pixel from any image satisfies each condition in \(r\)SMALLINT
anymask_uSMALLINT
anymask_ySMALLINT
anymask_zBitwise mask set if the central pixel from any image satisfies each condition in \(z\)SMALLINT
apflux_g_1REAL
apflux_g_2REAL
apflux_g_3REAL
apflux_g_4REAL
apflux_g_5REAL
apflux_g_6REAL
apflux_g_7REAL
apflux_g_8REAL
apflux_i_1REAL
apflux_i_2REAL
apflux_i_3REAL
apflux_i_4REAL
apflux_i_5REAL
apflux_i_6REAL
apflux_i_7REAL
apflux_i_8REAL
apflux_ivar_g_1REAL
apflux_ivar_g_2REAL
apflux_ivar_g_3REAL
apflux_ivar_g_4REAL
apflux_ivar_g_5REAL
apflux_ivar_g_6REAL
apflux_ivar_g_7REAL
apflux_ivar_g_8REAL
apflux_ivar_i_1REAL
apflux_ivar_i_2REAL
apflux_ivar_i_3REAL
apflux_ivar_i_4REAL
apflux_ivar_i_5REAL
apflux_ivar_i_6REAL
apflux_ivar_i_7REAL
apflux_ivar_i_8REAL
apflux_ivar_r_1REAL
apflux_ivar_r_2REAL
apflux_ivar_r_3REAL
apflux_ivar_r_4REAL
apflux_ivar_r_5REAL
apflux_ivar_r_6REAL
apflux_ivar_r_7REAL
apflux_ivar_r_8REAL
apflux_ivar_u_1REAL
apflux_ivar_u_2REAL
apflux_ivar_u_3REAL
apflux_ivar_u_4REAL
apflux_ivar_u_5REAL
apflux_ivar_u_6REAL
apflux_ivar_u_7REAL
apflux_ivar_u_8REAL
apflux_ivar_y_1REAL
apflux_ivar_y_2REAL
apflux_ivar_y_3REAL
apflux_ivar_y_4REAL
apflux_ivar_y_5REAL
apflux_ivar_y_6REAL
apflux_ivar_y_7REAL
apflux_ivar_y_8REAL
apflux_ivar_z_1REAL
apflux_ivar_z_2REAL
apflux_ivar_z_3REAL
apflux_ivar_z_4REAL
apflux_ivar_z_5REAL
apflux_ivar_z_6REAL
apflux_ivar_z_7REAL
apflux_ivar_z_8REAL
apflux_r_1REAL
apflux_r_2REAL
apflux_r_3REAL
apflux_r_4REAL
apflux_r_5REAL
apflux_r_6REAL
apflux_r_7REAL
apflux_r_8REAL
apflux_resid_g_1REAL
apflux_resid_g_2REAL
apflux_resid_g_3REAL
apflux_resid_g_4REAL
apflux_resid_g_5REAL
apflux_resid_g_6REAL
apflux_resid_g_7REAL
apflux_resid_g_8REAL
apflux_resid_i_1REAL
apflux_resid_i_2REAL
apflux_resid_i_3REAL
apflux_resid_i_4REAL
apflux_resid_i_5REAL
apflux_resid_i_6REAL
apflux_resid_i_7REAL
apflux_resid_i_8REAL
apflux_resid_r_1REAL
apflux_resid_r_2REAL
apflux_resid_r_3REAL
apflux_resid_r_4REAL
apflux_resid_r_5REAL
apflux_resid_r_6REAL
apflux_resid_r_7REAL
apflux_resid_r_8REAL
apflux_resid_u_1REAL
apflux_resid_u_2REAL
apflux_resid_u_3REAL
apflux_resid_u_4REAL
apflux_resid_u_5REAL
apflux_resid_u_6REAL
apflux_resid_u_7REAL
apflux_resid_u_8REAL
apflux_resid_y_1REAL
apflux_resid_y_2REAL
apflux_resid_y_3REAL
apflux_resid_y_4REAL
apflux_resid_y_5REAL
apflux_resid_y_6REAL
apflux_resid_y_7REAL
apflux_resid_y_8REAL
apflux_resid_z_1REAL
apflux_resid_z_2REAL
apflux_resid_z_3REAL
apflux_resid_z_4REAL
apflux_resid_z_5REAL
apflux_resid_z_6REAL
apflux_resid_z_7REAL
apflux_resid_z_8REAL
apflux_u_1REAL
apflux_u_2REAL
apflux_u_3REAL
apflux_u_4REAL
apflux_u_5REAL
apflux_u_6REAL
apflux_u_7REAL
apflux_u_8REAL
apflux_y_1REAL
apflux_y_2REAL
apflux_y_3REAL
apflux_y_4REAL
apflux_y_5REAL
apflux_y_6REAL
apflux_y_7REAL
apflux_y_8REAL
apflux_z_1REAL
apflux_z_2REAL
apflux_z_3REAL
apflux_z_4REAL
apflux_z_5REAL
apflux_z_6REAL
apflux_z_7REAL
apflux_z_8REAL
brick_primaryTrue if the object is within the brick boundarySMALLINT
brickidBrick ID [1,662174]INTEGER
bricknameName of brick, encoding the brick sky position, e.g. 1126p222 near RA=112.6, Dec=+22.2VARCHAR(n)
brightstarinblobTrue if the object shares a blob with a bright (Tycho-2) starSMALLINT
bxX position (0-indexed) of coordinates in brick image stackREAL
byY position (0-indexed) of coordinates in brick image stackREAL
dchisq_1REAL
dchisq_2REAL
dchisq_3REAL
dchisq_4REAL
dchisq_5REAL
decDeclination at epoch J2000DOUBLE
dec_ivarInverse variance of DEC, excluding astrometric calibration errorsREAL
decals_idBIGINT
dl_uniqidBIGINT
dl_uniqid_strINTEGER
ebvGalactic extinction \(E(B-V)\) reddening from SFD98, used to compute DECAM_MW_TRANSMISSION and WISE_MW_TRANSMISSIONREAL
elatDOUBLE
elonDOUBLE
fiberflux_gPredicted \(g\)-band flux within a fiber from this object in 1 arcsec Gaussian seeingREAL
fiberflux_iREAL
fiberflux_rPredicted \(r\)-band flux within a fiber from this object in 1 arcsec Gaussian seeingREAL
fiberflux_uREAL
fiberflux_yREAL
fiberflux_zPredicted \(z\)-band flux within a fiber from this object in 1 arcsec Gaussian seeingREAL
fiberidINTEGER
fibertotflux_gPredicted \(g\)-band flux within a fiber from all sources at this location in 1 arcsec Gaussian seeingREAL
fibertotflux_iREAL
fibertotflux_rPredicted \(r\)-band flux within a fiber from all sources at this location in 1 arcsec Gaussian seeingREAL
fibertotflux_uREAL
fibertotflux_yREAL
fibertotflux_zPredicted \(z\)-band flux within a fiber from all sources at this location in 1 arcsec Gaussian seeingREAL
flux_gmodel flux in \(g\)REAL
flux_iREAL
flux_ivar_gInverse variance of FLUX_GREAL
flux_ivar_iREAL
flux_ivar_rInverse variance of FLUX_RREAL
flux_ivar_uREAL
flux_ivar_w1Inverse variance of FLUX_W1REAL
flux_ivar_w2Inverse variance of FLUX_W2REAL
flux_ivar_w3Inverse variance of FLUX_W3REAL
flux_ivar_w4Inverse variance of FLUX_W4REAL
flux_ivar_yREAL
flux_ivar_zInverse variance of FLUX_ZREAL
flux_rmodel flux in \(r\)REAL
flux_uREAL
flux_w1WISE model flux in \(W1\)REAL
flux_w2WISE model flux in \(W2\)REAL
flux_w3WISE model flux in \(W3\)REAL
flux_w4WISE model flux in \(W4\)REAL
flux_yREAL
flux_zmodel flux in \(z\)REAL
fracdevFraction of model in deVauc [0,1]REAL
fracdev_ivarInverse variance of FRACDEVREAL
fracflux_gProfile-weighted fraction of the flux from other sources divided by the total flux in \(g\) (typically [0,1])REAL
fracflux_iREAL
fracflux_rProfile-weighted fraction of the flux from other sources divided by the total flux in \(r\) (typically [0,1])REAL
fracflux_uREAL
fracflux_w1Profile-weighted fraction of the flux from other sources divided by the total flux in \(W1\) (typically [0,1])REAL
fracflux_w2Profile-weighted fraction of the flux from other sources divided by the total flux in \(W2\) (typically [0,1])REAL
fracflux_w3Profile-weighted fraction of the flux from other sources divided by the total flux in \(W3\) (typically [0,1])REAL
fracflux_w4Profile-weighted fraction of the flux from other sources divided by the total flux in \(W4\) (typically [0,1])REAL
fracflux_yREAL
fracflux_zProfile-weighted fraction of the flux from other sources divided by the total flux in \(z\) (typically [0,1])REAL
fracin_gFraction of source flux within the blob in \(g\), near unity for real sourcesREAL
fracin_iREAL
fracin_rFraction of source flux within the blob in \(r\), near unity for real sourcesREAL
fracin_uREAL
fracin_yREAL
fracin_zFraction of source flux within the blob in \(z\), near unity for real sourcesREAL
fracmasked_gProfile-weighted fraction of pixels masked from all observations of this object in \(g\), strictly between [0,1]REAL
fracmasked_iREAL
fracmasked_rProfile-weighted fraction of pixels masked from all observations of this object in \(r\), strictly between [0,1]REAL
fracmasked_uREAL
fracmasked_yREAL
fracmasked_zProfile-weighted fraction of pixels masked from all observations of this object in \(z\), strictly between [0,1]REAL
gaia_astrometric_excess_noiseGaia astrometric excess noiseREAL
gaia_astrometric_excess_noise_sigGaia astrometric excess noise uncertaintyREAL
gaia_astrometric_n_good_obs_alGaia number of good astrometric observations along scan directionSMALLINT
gaia_astrometric_n_obs_alGaia number of astrometric observations along scan directionSMALLINT
gaia_astrometric_weight_alGaia astrometric weight along scan directionREAL
gaia_duplicated_sourceGaia duplicated source flagSMALLINT
gaia_phot_bp_mean_flux_over_errorGaia BP signal-to-noiseREAL
gaia_phot_bp_mean_magGaia BP magREAL
gaia_phot_bp_n_obsGaia BP number of observationsSMALLINT
gaia_phot_g_mean_flux_over_errorGaia G band signal-to-noiseREAL
gaia_phot_g_mean_magGaia G band magREAL
gaia_phot_g_n_obsGaia G band number of observationsSMALLINT
gaia_phot_rp_mean_flux_over_errorGaia RP signal-to-noiseREAL
gaia_phot_rp_mean_magGaia RP magREAL
gaia_phot_rp_n_obsGaia RP number of observationsSMALLINT
gaia_phot_variable_flagGaia photometric variable flagSMALLINT
gaia_pointsourceThis Gaia-DR2 source is believed to be a star, not a galaxySMALLINT
galdepth_gAs for PSFDEPTH_G but for a galaxy (0.45 arcsec exp, round) detection sensitivityREAL
galdepth_iREAL
galdepth_rAs for PSFDEPTH_R but for a galaxy (0.45 arcsec exp, round) detection sensitivityREAL
galdepth_uREAL
galdepth_yREAL
galdepth_zAs for PSFDEPTH_Z but for a galaxy (0.45 arcsec exp, round) detection sensitivityREAL
glatDOUBLE
glonDOUBLE
htm9INTEGER
lc_flux_ivar_w1_1REAL
lc_flux_ivar_w1_10REAL
lc_flux_ivar_w1_11REAL
lc_flux_ivar_w1_2REAL
lc_flux_ivar_w1_3REAL
lc_flux_ivar_w1_4REAL
lc_flux_ivar_w1_5REAL
lc_flux_ivar_w1_6REAL
lc_flux_ivar_w1_7REAL
lc_flux_ivar_w1_8REAL
lc_flux_ivar_w1_9REAL
lc_flux_ivar_w2_1REAL
lc_flux_ivar_w2_10REAL
lc_flux_ivar_w2_11REAL
lc_flux_ivar_w2_2REAL
lc_flux_ivar_w2_3REAL
lc_flux_ivar_w2_4REAL
lc_flux_ivar_w2_5REAL
lc_flux_ivar_w2_6REAL
lc_flux_ivar_w2_7REAL
lc_flux_ivar_w2_8REAL
lc_flux_ivar_w2_9REAL
lc_flux_w1_1REAL
lc_flux_w1_10REAL
lc_flux_w1_11REAL
lc_flux_w1_2REAL
lc_flux_w1_3REAL
lc_flux_w1_4REAL
lc_flux_w1_5REAL
lc_flux_w1_6REAL
lc_flux_w1_7REAL
lc_flux_w1_8REAL
lc_flux_w1_9REAL
lc_flux_w2_1REAL
lc_flux_w2_10REAL
lc_flux_w2_11REAL
lc_flux_w2_2REAL
lc_flux_w2_3REAL
lc_flux_w2_4REAL
lc_flux_w2_5REAL
lc_flux_w2_6REAL
lc_flux_w2_7REAL
lc_flux_w2_8REAL
lc_flux_w2_9REAL
lc_fracflux_w1_1REAL
lc_fracflux_w1_10REAL
lc_fracflux_w1_11REAL
lc_fracflux_w1_2REAL
lc_fracflux_w1_3REAL
lc_fracflux_w1_4REAL
lc_fracflux_w1_5REAL
lc_fracflux_w1_6REAL
lc_fracflux_w1_7REAL
lc_fracflux_w1_8REAL
lc_fracflux_w1_9REAL
lc_fracflux_w2_1REAL
lc_fracflux_w2_10REAL
lc_fracflux_w2_11REAL
lc_fracflux_w2_2REAL
lc_fracflux_w2_3REAL
lc_fracflux_w2_4REAL
lc_fracflux_w2_5REAL
lc_fracflux_w2_6REAL
lc_fracflux_w2_7REAL
lc_fracflux_w2_8REAL
lc_fracflux_w2_9REAL
lc_mjd_w1_1DOUBLE
lc_mjd_w1_10DOUBLE
lc_mjd_w1_11DOUBLE
lc_mjd_w1_2DOUBLE
lc_mjd_w1_3DOUBLE
lc_mjd_w1_4DOUBLE
lc_mjd_w1_5DOUBLE
lc_mjd_w1_6DOUBLE
lc_mjd_w1_7DOUBLE
lc_mjd_w1_8DOUBLE
lc_mjd_w1_9DOUBLE
lc_mjd_w2_1DOUBLE
lc_mjd_w2_10DOUBLE
lc_mjd_w2_11DOUBLE
lc_mjd_w2_2DOUBLE
lc_mjd_w2_3DOUBLE
lc_mjd_w2_4DOUBLE
lc_mjd_w2_5DOUBLE
lc_mjd_w2_6DOUBLE
lc_mjd_w2_7DOUBLE
lc_mjd_w2_8DOUBLE
lc_mjd_w2_9DOUBLE
lc_nobs_w1_1SMALLINT
lc_nobs_w1_10SMALLINT
lc_nobs_w1_11SMALLINT
lc_nobs_w1_2SMALLINT
lc_nobs_w1_3SMALLINT
lc_nobs_w1_4SMALLINT
lc_nobs_w1_5SMALLINT
lc_nobs_w1_6SMALLINT
lc_nobs_w1_7SMALLINT
lc_nobs_w1_8SMALLINT
lc_nobs_w1_9SMALLINT
lc_nobs_w2_1SMALLINT
lc_nobs_w2_10SMALLINT
lc_nobs_w2_11SMALLINT
lc_nobs_w2_2SMALLINT
lc_nobs_w2_3SMALLINT
lc_nobs_w2_4SMALLINT
lc_nobs_w2_5SMALLINT
lc_nobs_w2_6SMALLINT
lc_nobs_w2_7SMALLINT
lc_nobs_w2_8SMALLINT
lc_nobs_w2_9SMALLINT
lc_rchisq_w1_1REAL
lc_rchisq_w1_10REAL
lc_rchisq_w1_11REAL
lc_rchisq_w1_2REAL
lc_rchisq_w1_3REAL
lc_rchisq_w1_4REAL
lc_rchisq_w1_5REAL
lc_rchisq_w1_6REAL
lc_rchisq_w1_7REAL
lc_rchisq_w1_8REAL
lc_rchisq_w1_9REAL
lc_rchisq_w2_1REAL
lc_rchisq_w2_10REAL
lc_rchisq_w2_11REAL
lc_rchisq_w2_2REAL
lc_rchisq_w2_3REAL
lc_rchisq_w2_4REAL
lc_rchisq_w2_5REAL
lc_rchisq_w2_6REAL
lc_rchisq_w2_7REAL
lc_rchisq_w2_8REAL
lc_rchisq_w2_9REAL
mjdINTEGER
mjd_maxMaximum Modified Julian Date of observations used to construct the model of this objectDOUBLE
mjd_minMinimum Modified Julian Date of observations used to construct the model of this objectDOUBLE
mw_transmission_gGalactic transmission in \(g\) filter in linear units [0,1]REAL
mw_transmission_iREAL
mw_transmission_rGalactic transmission in \(r\) filter in linear units [0,1]REAL
mw_transmission_uREAL
mw_transmission_w1Galactic transmission in \(W1\) filter in linear units [0,1]REAL
mw_transmission_w2Galactic transmission in \(W2\) filter in linear units [0,1]REAL
mw_transmission_w3Galactic transmission in \(W3\) filter in linear units [0,1]REAL
mw_transmission_w4Galactic transmission in \(W4\) filter in linear units [0,1]REAL
mw_transmission_yREAL
mw_transmission_zGalactic transmission in \(z\) filter in linear units [0,1]REAL
nest4096INTEGER
nobs_gNumber of images that contribute to the central pixel in \(g\): filter for this object (not profile-weighted)SMALLINT
nobs_iSMALLINT
nobs_rNumber of images that contribute to the central pixel in \(r\): filter for this object (not profile-weighted)SMALLINT
nobs_uSMALLINT
nobs_w1Number of images that contribute to the central pixel in \(W1\): filter for this object (not profile-weighted)SMALLINT
nobs_w2Number of images that contribute to the central pixel in \(W2\): filter for this object (not profile-weighted)SMALLINT
nobs_w3Number of images that contribute to the central pixel in \(W3\): filter for this object (not profile-weighted)SMALLINT
nobs_w4Number of images that contribute to the central pixel in \(W4\): filter for this object (not profile-weighted)SMALLINT
nobs_ySMALLINT
nobs_zNumber of images that contribute to the central pixel in \(z\): filter for this object (not profile-weighted)SMALLINT
objidCatalog object number within this brick; a unique identifier hash is BRICKID,OBJID; OBJID spans [0,N-1] and is contiguously enumerated within each blobINTEGER
parallaxReference catalog parallaxREAL
parallax_ivarReference catalog inverse-variance on parallaxREAL
plateINTEGER
pmdecReference catalog proper motion in the Dec directionREAL
pmdec_ivarReference catalog inverse-variance on pmdecREAL
pmraReference catalog proper motion in the RA directionREAL
pmra_ivarReference catalog inverse-variance on pmraREAL
psfdepth_gFor a \(5\sigma\) point source detection limit in \(g\), \(5/\sqrt(\mathrm{PSFDEPTH\_G})\) gives flux in nanomaggies and \(-2.5[\log_{10}(5 / \sqrt(\mathrm{PSFDEPTH\_G})) - 9]\) gives corresponding magnitudeREAL
psfdepth_iREAL
psfdepth_rFor a \(5\sigma\) point source detection limit in \(g\), \(5/\sqrt(\mathrm{PSFDEPTH\_R})\) gives flux in nanomaggies and \(-2.5[\log_{10}(5 / \sqrt(\mathrm{PSFDEPTH\_R})) - 9]\) gives corresponding magnitudeREAL
psfdepth_uREAL
psfdepth_yREAL
psfdepth_zFor a \(5\sigma\) point source detection limit in \(g\), \(5/\sqrt(\mathrm{PSFDEPTH\_Z})\) gives flux in nanomaggies and \(-2.5[\log_{10}(5 / \sqrt(\mathrm{PSFDEPTH\_Z})) - 9]\) gives corresponding magnitudeREAL
psfsize_gWeighted average PSF FWHM in the \(g\) bandREAL
psfsize_iREAL
psfsize_rWeighted average PSF FWHM in the \(r\) bandREAL
psfsize_uREAL
psfsize_yREAL
psfsize_zWeighted average PSF FWHM in the \(z\) bandREAL
raRight ascension at epoch J2000DOUBLE
ra_ivarInverse variance of RA (no cosine term!), excluding astrometric calibration errorsREAL
rchisq_gProfile-weighted chi^2 of model fit normalized by the number of pixels in \(g\)REAL
rchisq_iREAL
rchisq_rProfile-weighted chi^2 of model fit normalized by the number of pixels in \(r\)REAL
rchisq_uREAL
rchisq_w1Profile-weighted chi^2 of model fit normalized by the number of pixels in \(W1\)REAL
rchisq_w2Profile-weighted chi^2 of model fit normalized by the number of pixels in \(W2\)REAL
rchisq_w3Profile-weighted chi^2 of model fit normalized by the number of pixels in \(W3\)REAL
rchisq_w4Profile-weighted chi^2 of model fit normalized by the number of pixels in \(W4\)REAL
rchisq_yREAL
rchisq_zProfile-weighted chi^2 of model fit normalized by the number of pixels in \(z\)REAL
ref_catReference catalog source for this star: T2 for Tycho-2, G2 for Gaia DR2, empty otherwiseVARCHAR(n)
ref_epochReference catalog reference epoch (e.g., 2015.5 for Gaia-DR2)REAL
ref_idReference catalog identifier for this star; \(\mathrm{Tyc1} \times 1,000,000 + \mathrm{Tyc2} \times 10 + \mathrm{Tyc3}\) for Tycho2; sourceid for Gaia-DR2BIGINT
releaseUnique integer denoting the camera and filter set usedSMALLINT
ring256INTEGER
run2dVARCHAR(n)
shapedev_e1Ellipticity component 1REAL
shapedev_e1_ivarInverse variance of SHAPEDEV_E1REAL
shapedev_e2Ellipticity component 2REAL
shapedev_e2_ivarInverse variance of SHAPEDEV_E2REAL
shapedev_rHalf-light radius of deVaucouleurs model (>0)REAL
shapedev_r_ivarInverse variance of R_DEVREAL
shapeexp_e1Ellipticity component 1REAL
shapeexp_e1_ivarInverse variance of SHAPEEXP_E1REAL
shapeexp_e2Ellipticity component 2REAL
shapeexp_e2_ivarInverse variance of SHAPEEXP_E2REAL
shapeexp_rHalf-light radius of exponential model (>0)REAL
shapeexp_r_ivarInverse variance of R_EXPREAL
typeMorphological model: PSF=stellar, REX=round exponential galaxy, DEV=deVauc, EXP=exponential, COMP=composite.VARCHAR(n)
wise_coadd_idunWISE coadd file name for the center of each objectVARCHAR(n)
wisemask_w1W1 bright star bitmask, \(2^0\) \((2^1)\) for southward (northward) scansSMALLINT
wisemask_w2W2 bright star bitmask, \(2^0\) \((2^1)\) for southward (northward) scansSMALLINT