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

(The bold columns are indexed columns)
Column NameDescriptionDatatype
ai_civAI of CIV absorption troughREAL
alpha_nuSpectral indexREAL
amp_ciiiAmplitude of CIII emissionREAL
amp_civAmplitude of CIV emissionREAL
amp_mgiiAmplitude of MgII emissionREAL
ancillary_target1BOSS target selection flag for ancillary programsBIGINT
ancillary_target2BOSS target selection flag for ancillary programsBIGINT
bal_flag_viBAL flag from visual inspectionSMALLINT
bhwhm_ciiiBlue HWHM of CIII emissionREAL
bhwhm_civBlue HWHM of CIV emissionREAL
bhwhm_mgiiBlue HWHM of MgII emissionREAL
bi_civBALnicity Index of CIV absorption troughREAL
boss_target1BOSS target selection flag for main surveyBIGINT
cc_flagsWISE contamination and confusion flagCHAR
chi2troughChi2 of the CIV troughsREAL
decDeclination in decimal degrees(J2000)DOUBLE
dgmiDifferential color delta(g-i)REAL
eboss_target0Target selection flag for the eBOSS pilot surveyBIGINT
elatEcliptic LatitudeDOUBLE
elonEcliptic LongitudeDOUBLE
err_ai_civError on the AI of CIV troughREAL
err_bi_civError on the Balnicity index of CIV troughREAL
err_rewe_ciiiError on rest EW of CIII emissionREAL
err_rewe_civError on rest EW of CIV emissionREAL
err_rewe_mgiiError on rest EW of MgII emissionREAL
extinction_gGalactic extinction in SDSS g band from from Schlafly & Finkbeiner (2011)REAL
extinction_iGalactic extinction in SDSS i band from from Schlafly & Finkbeiner (2011)REAL
extinction_rGalactic extinction in SDSS r band from from Schlafly & Finkbeiner (2011)REAL
extinction_uGalactic extinction in SDSS u band from from Schlafly & Finkbeiner (2011)REAL
extinction_zGalactic extinction in SDSS z band from from Schlafly & Finkbeiner (2011)REAL
fiberidSpectroscopic fiber numberINTEGER
fiberid_dr7DR7 Fiber numberINTEGER
first_fluxFIRST peak flux density at 20 cmREAL
first_matchedFIRST matching flagSMALLINT
first_snrS/N of the FIRST flux densityREAL
fuvFUV flux (GALEX)REAL
fuv_ivarInverse variance of FUV fluxREAL
fwhm_ciiiFWHM of CIII emissionREAL
fwhm_civFWHM of CIV emissionREAL
fwhm_mgiiFWHM of MgII emissionREAL
galex_matchedGALEX match flagSMALLINT
glatGalactic LatitudeDOUBLE
glonGalactic LongitudeDOUBLE
hfluxH-band flux density from UKIDSSREAL
hflux_errError in H-band flux density from UKIDSSREAL
hi_gallog of Galactic HI column densityREAL
hmagH magnitude (Vega, 2MASS)REAL
hmag_errError in H magnitudeREAL
hrdflagH-Band photometry flagINTEGER
hsnrH-Band S/NREAL
htm9HTM index (order 9 => ~10 arcmin size)INTEGER
jfluxJ-band density flux from UKIDSSREAL
jflux_errError in J-band flux density from UKIDSS)REAL
jmagJ magnitude (Vega, 2MASS)REAL
jmag_errError in J magnitudeREAL
jrdflagH-Band photometry flagINTEGER
jsnrJ-Band S/NREAL
kfluxK-band flux density from UKIDSSREAL
kflux_errError in K-band flux density from UKIDSSREAL
kmagK magnitude (Vega, 2MASS)REAL
kmag_errError in K magnitudeREAL
krdflagK-Band photometry flagINTEGER
ksnrK-Band S/NREAL
miAbsolute magnitude in i band, Mi [z = 2], see DR12Q paper for cosmologyREAL
mjdModified Julian Day of the spectroscopic observationINTEGER
mjd_dr7DR7 spectroscopic MJDINTEGER
n_detection_xmmNumber of detections in XMM-NewtonSMALLINT
nciv_2000Number of CIV troughs larger than 2000 km/sINTEGER
nciv_450Number of CIV troughs larger than 450 km/sINTEGER
nest4096HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec sizeINTEGER
nspec_bossNumber of additional spectra available in SDSS-III/IVINTEGER
nuvREAL
nuv_ivarInverse variance of NUV fluxREAL
pcaqualQuality of PCA continuumREAL
ph_flagWISE photometric quality flagCHAR
plateSpectroscopic plate numberINTEGER
plate_dr7DR7 Plate numberINTEGER
psfflux_gPSF flux in g bandREAL
psfflux_iPSF flux in i bandREAL
psfflux_rPSF flux in r bandREAL
psfflux_uPSF flux in u bandREAL
psfflux_zPSF flux in z bandREAL
psffluxivar_gInverse variance of PSF flux in g bandREAL
psffluxivar_iInverse variance of PSF flux in i bandREAL
psffluxivar_rInverse variance of PSF flux in r bandREAL
psffluxivar_uInverse variance of PSF flux in u bandREAL
psffluxivar_zInverse variance of PSF flux in z bandREAL
psfmag_gPSF magnitude in g bandREAL
psfmag_iPSF magnitude in i bandREAL
psfmag_rPSF magnitude in r bandREAL
psfmag_uPSF magnitude in u bandREAL
psfmag_zPSF magnitude in z bandREAL
psfmagerr_gPSF magnitude in g bandREAL
psfmagerr_iPSF magnitude in i bandREAL
psfmagerr_rPSF magnitude in r bandREAL
psfmagerr_uPSF magnitude in u bandREAL
psfmagerr_zPSF magnitude in z bandREAL
raRight Ascension in decimal degrees(J2000)DOUBLE
random_idRandom ID in the range 0.0 => 100.0REAL
rass_countslog RASS full band count rate (counts/s)REAL
rass_counts_snrS/N of the RASS count rateREAL
rew_aliiiRest EW of AlIII troughREAL
rew_civRest EW of CIV troughREAL
rew_siivRest EW of SiIV troughREAL
rewe_ciiiRest EW of CIII emissionREAL
rewe_civRest EW of CIV emissionREAL
rewe_mgiiRest EW of MgII emissionREAL
rhwhm_ciiiRed HWHM of CIII emissionREAL
rhwhm_civRed HWHM of CIV emissionREAL
rhwhm_mgiiRed HWHM of MgII emissionREAL
ring256HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size)INTEGER
run2d2D Reduction version of spectrumCHAR
sdss2first_sepSDSS-FIRST separationREAL
sdss2mass_sepSDSS-2MASS separationREAL
sdss2rosat_sepSDSS-RASS separationREAL
sdss2wise_sepSDSS-WISE separationREAL
sdss2xmm_sepSDSS-XMM-Newton separationREAL
sdss_dr7DR7 observation flagINTEGER
sdss_joinidUnique ID based on PLATE, MJD, FIBERID for joining across data releasesBIGINT
sdssmorphoMorphology flagSMALLINT
sdssnameSDSS-DR14 designation - hhmmss.ss+ddmmss.s (J2000)CHAR
sfd_ext_gGalactic extinction in SDSS g band from from Schlegel et al. (1998)REAL
sfd_ext_iGalactic extinction in SDSS i band from from Schlegel et al. (1998)REAL
sfd_ext_rGalactic extinction in SDSS r band from from Schlegel et al. (1998)REAL
sfd_ext_uGalactic extinction in SDSS u band from from Schlegel et al. (1998)REAL
sfd_ext_zGalactic extinction in SDSS z band from from Schlegel et al. (1998)REAL
snr_1700Median SNR (1650-1750A rest)REAL
snr_3000Median SNR (2950-3050A rest)REAL
snr_5150Median SNR (5100-5250A rest)REAL
snr_specMedian SNR (whole spectrum)REAL
specobjidUnique database ID based on PLATE, MJD, FIBERID, RUN2DBIGINT
targetflux_gTarget flux in g bandREAL
targetflux_iTarget flux in i bandREAL
targetflux_rTarget flux in r bandREAL
targetflux_uTarget flux in u bandREAL
targetflux_zTarget flux in z bandREAL
thing_idUnique SDSS source identifierINTEGER
ukidss_matchedUKIDSS matching flagSMALLINT
uniformUniform sample flagSMALLINT
var_aStructure function parameter A as defined in Palanque-Delabrouille et al. (2011)REAL
var_chi2Reduced chi2 when the light curve is fitted with a constantREAL
var_gammaStructure function parameter gamma as defined in Palanque-Delabrouille et al. (2011)REAL
var_matchedVariability information flagSMALLINT
vmax_civ_2000Max velocity of CIV troughs (col60)REAL
vmax_civ_450Max velocity of CIV troughs (col63)REAL
vmin_civ_2000Min velocity of CIV troughs (col60)REAL
vmin_civ_450Min velocity of CIV troughs (col63)REAL
w1chi2chi-squared in W1 bandREAL
w1magW1 magnitude (Vega, WISE)REAL
w1mag_errError in W1 magnitudeREAL
w1snrS/N in W1 bandREAL
w2chi2chi-squared in W2 bandREAL
w2magW2 magnitude (Vega, WISE)REAL
w2mag_errError in W2 magnitudeREAL
w2snrS/N in W2 bandREAL
w3chi2chi-squared in W3 bandREAL
w3magW3 magnitude (Vega, WISE)REAL
w3mag_errError in W3 magnitudeREAL
w3snrS/N in W3 bandREAL
w4chi2chi-squared in W4 bandREAL
w4magW4 magnitude (Vega, WISE)REAL
w4mag_errError in W4 magnitudeREAL
w4snrS/N in W4 bandREAL
xmm_fluxTotal weighted average X-ray flux (0.2-12.0 keV) from XMM-NewtonREAL
xmm_flux_errError on total weighted average X-ray flux from XMM-NewtonREAL
xmm_hard_fluxHard (4.5-12.0 keV) X-ray flux from XMM-NewtonREAL
xmm_hard_flux_errError on hard X-ray flux from XMM-NewtonREAL
xmm_hard_lumHard (2.0-12.0 keV) X-ray luminosity from XMM-NewtonREAL
xmm_lum_flagFlag for upper limit for hard X-ray fluxSMALLINT
xmm_luminosityTotal (0.2-12.0 keV) X-ray luminosity from XMM-NewtonREAL
xmm_sgl_fluxTotal (0.2-12.0 keV) X-ray flux from XMM-Newton computed from longest observationREAL
xmm_sgl_flux_errError on total X-ray flux from XMM-NewtonREAL
xmm_sgl_lumTotal X-ray luminosity (0.2-12.0 keV) from XMM-Newton using the longest exposureREAL
xmm_soft_fluxSoft (0.2-2.0 keV) X-ray flux from XMM-NewtonREAL
xmm_soft_flux_errError on soft X-ray flux from XMM-NewtonREAL
xmm_soft_lumSoft (0.5-2.0 keV) X-ray luminosity from XMM-NewtonREAL
yfluxY-band flux density from UKIDSSREAL
yflux_errError in Y-band flux density from UKIDSSREAL
zciiiRedshift of the CIII emission lineREAL
zcivRedshift of the CIV emission lineREAL
zmgiiRedshift of the MgII emission lineREAL
zpcaPCA redshift (homogeneous over the full sample)REAL
zpcaerrError on PCA redshiftREAL
zpipeSDSS pipeline redshift estimateREAL
zpipeerrError on SDSS pipeline redshift estimateREAL
zviRedshift based on visual inspection (when available)REAL
zwarningQuality flag on SDSS pipeline redshift measurementINTEGER