Data Lab is hiring a Software Engineer. More information.

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_rBitwise mask set if the central pixel from all images satisfy each condition in (r)SMALLINT
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_rBitwise mask set if the central pixel from any image satisfies each condition in (r)SMALLINT
anymask_zBitwise mask set if the central pixel from any image satisfies each condition in (z)SMALLINT
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_1Difference in X^2 between successfully more-complex model fitsREAL
dchisq_2Difference in X^2 between successfully more-complex model fitsREAL
dchisq_3Difference in X^2 between successfully more-complex model fitsREAL
dchisq_4Difference in X^2 between successfully more-complex model fitsREAL
dchisq_5Difference in X^2 between successfully more-complex model fitsREAL
decDeclination at epoch J2000DOUBLE
dec_ivarInverse variance of DEC, excluding astrometric calibration errorsREAL
decals_idUnique DECaLS object IDBIGINT
dered_flux_gDereddened G-band fluxREAL
dered_flux_rDereddened R-band fluxREAL
dered_flux_w1Dereddened W1 fluxREAL
dered_flux_w2Dereddened W1 fluxREAL
dered_flux_w3Dereddened W1 fluxREAL
dered_flux_w4Dereddened W1 fluxREAL
dered_flux_zDereddened Z-band fluxREAL
dered_mag_gDereddened G-band magnitudeREAL
dered_mag_rDereddened R-band magnitudeREAL
dered_mag_w1Dereddened W1 magnitudeREAL
dered_mag_w2Dereddened W2 magnitudeREAL
dered_mag_w3Dereddened W3 magnitudeREAL
dered_mag_w4Dereddened W4 magnitudeREAL
dered_mag_zDereddened Z-band magnitudeREAL
ebvGalactic extinction (E(B-V)) reddening from SFD98, used to compute DECAM_MW_TRANSMISSION and WISE_MW_TRANSMISSIONREAL
elatEcliptic LatitudeDOUBLE
elonEcliptic LongitudeDOUBLE
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
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_ivar_gInverse variance of FLUX_GREAL
flux_ivar_rInverse variance of FLUX_RREAL
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_zInverse variance of FLUX_ZREAL
flux_rmodel flux in (r)REAL
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_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_rProfile-weighted fraction of the flux from other sources divided by the total flux in (r) (typically [0,1])REAL
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_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_rFraction of source flux within the blob in (r), near unity for real sourcesREAL
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_rProfile-weighted fraction of pixels masked from all observations of this object in (r), strictly between [0,1]REAL
fracmasked_zProfile-weighted fraction of pixels masked from all observations of this object in (z), strictly between [0,1]REAL
g_rComputed (g-r) colorREAL
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_rAs for PSFDEPTH_R but for a galaxy (0.45 arcsec exp, round) detection sensitivityREAL
galdepth_zAs for PSFDEPTH_Z but for a galaxy (0.45 arcsec exp, round) detection sensitivityREAL
glatGalactic LatitudeDOUBLE
glonGalactic LongitudeDOUBLE
htm9HTM index (order 9 => ~10 arcmin size)INTEGER
mag_gConverted G magnitudeREAL
mag_rConverted R magnitudeREAL
mag_w1W1 magnitudeREAL
mag_w2W2 magnitudeREAL
mag_w3W3 magnitudeREAL
mag_w4W4 magnitudeREAL
mag_zConverted Z magnitudeREAL
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_rGalactic transmission in (r) filter in linear units [0,1]REAL
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_zGalactic transmission in (z) filter in linear units [0,1]REAL
nest4096HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec sizeINTEGER
nobs_gNumber of images that contribute to the central pixel in (g): filter for this object (not profile-weighted)SMALLINT
nobs_rNumber of images that contribute to the central pixel in (r): filter for this object (not profile-weighted)SMALLINT
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_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
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 (5sigma) 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_rFor a (5sigma) 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_zFor a (5sigma) 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_rWeighted average PSF FWHM in the (r) bandREAL
psfsize_zWeighted average PSF FWHM in the (z) bandREAL
r_zComputed (r-z) colorREAL
raRight ascension at epoch J2000DOUBLE
ra_ivarInverse variance of RA (no cosine term!), excluding astrometric calibration errorsREAL
random_idRandom ID in the range 0.0 => 100.0REAL
rchisq_gProfile-weighted chi^2 of model fit normalized by the number of pixels in (g)REAL
rchisq_rProfile-weighted chi^2 of model fit normalized by the number of pixels in (r)REAL
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_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} imes 1,000,000 + mathrm{Tyc2} imes 10 + mathrm{Tyc3}) for Tycho2; sourceid for Gaia-DR2BIGINT
releaseUnique integer denoting the camera and filter set usedSMALLINT
ring256HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size)INTEGER
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
snr_gSignal-to-Noise ratio in GREAL
snr_rSignal-to-Noise ratio in RREAL
snr_w1Signal-to-Noise ratio in W1REAL
snr_w2Signal-to-Noise ratio in W2REAL
snr_w3Signal-to-Noise ratio in W3REAL
snr_w4Signal-to-Noise ratio in W4REAL
snr_zSignal-to-Noise ratio in ZREAL
typeMorphological model: PSF=stellar, REX=round exponential galaxy, DEV=deVauc, EXP=exponential, COMP=composite.VARCHAR(n)
w1_w2Computed (w1-w2) colorREAL
w2_w3Computed (w2-w3) colorREAL
w3_w4Computed (w3-d4) colorREAL
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
z_w1Computed (z-w1 colorREAL