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

(The bold columns are indexed columns)
Column NameDescriptionDatatype
class_bestSource classification based on visual inspection results.CHAR
conf_bestVisual inspection redshift and classification confidence flag.SMALLINT
decDeclination of the X-ray detection (J2000).DOUBLE
detml_xmmslDetection likelihood of the XMMSL detection in the 0.2-12 keV range.REAL
dr14_sn_median_allMedian signal to noise ratio per pixel of the spectrum.REAL
dr14_zwarningWarning flag for SDSS spectra.SMALLINT
edd_ratio1Eddington ratio defined as l_bol1/l_edd1.REAL
edd_ratio2Eddington ratio defined as l_bol2/l_edd2.REAL
errf_2rxsUncertainty in the flux in the 0.1-2.4 keV range (2RXS).REAL
errf_xmmslUncertainty in the flux in the 0.2-12 keV range (XMMSL).REAL
errfden_2rxsUncertainty in the flux density at 2 keV (2RXS).REAL
errfwhm1_hbUncertainty in the FWHM of the first Gaussian used to fit the H beta line.REAL
errfwhm1_mgiiUncertainty in the FWHM of the first Gaussian used to fit the MgII line.REAL
errfwhm1_oiii4959Uncertainty in the FWHM of the first Gaussian used to fit the [OIII]4959 line.REAL
errfwhm1_oiii5007Uncertainty in the FWHM of the first Gaussian used to fit the [OIII]5007 line.REAL
errfwhm2_hbUncertainty in the FWHM of the second Gaussian used to fit the H beta line.REAL
errfwhm2_mgiiUncertainty in the FWHM of the second Gaussian used to fit the MgII line.REAL
errfwhm2_oiii4959Uncertainty in the FWHM of the second Gaussian used to fit the [OIII]4959 line.REAL
errfwhm2_oiii5007Uncertainty in the FWHM of the second Gaussian used to fit the [OIII]5007 line.REAL
errfwhm3_hbUncertainty in the FWHM of the third Gaussian used to fit the H beta line.REAL
errfwhm3_mgiiUncertainty in the FWHM of the third Gaussian used to fit the MgII line.REAL
errfwhm4_hbUncertainty in the FWHM of the fourth Gaussian used to fit the H beta line.REAL
errfwhm_heiiUncertainty in the FWHM of the Gaussian used to fit the HeII line.REAL
errl_2500Uncertainty in the monochromatic luminosity at 2500 Ang.REAL
errl_3000Uncertainty in the monochromatic luminosity at 3000 Ang.REAL
errl_5100Uncertainty in the monochromatic luminosity at 5100 Ang.REAL
errl_bol1Uncertainty in the bolometric luminosity derived from the monochromatic luminosity at 3000 Ang.REAL
errl_bol2Uncertainty in the bolometric luminosity derived from the monochromatic luminosity at 5100 Ang.REAL
errlogbhma_hbUncertainty in the black hole mass derived from the H beta line using the Assef et al. (2011) calibration.REAL
errlogbhmmd_hbUncertainty in the black hole mass derived from the H beta line using the McLure & Dunlop (2004) calibration.REAL
errlogbhms_mgiiUncertainty in the black hole mass derived from the MgII line using the Shen & Liu (2012) calibration.REAL
errlogbhmvp_hbUncertainty in the black hole mass derived from the H beta line using the Vestergaard & Peterson (2006) calibration.REAL
errnorm1_hbUncertainty in the normalisation of the first Gaussian used to fit the H beta line.REAL
errnorm1_mgiiUncertainty in the normalisation of the first Gaussian used to fit the MgII line.REAL
errnorm1_oiii4959Uncertainty in the normalisation of the first Gaussian used to fit the [OIII]4959 line.REAL
errnorm1_oiii5007Uncertainty in the normalisation of the first Gaussian used to fit the [OIII]5007 line.REAL
errnorm2_hbUncertainty in the normalisation of the second Gaussian used to fit the H beta line.REAL
errnorm2_mgiiUncertainty in the normalisation of the second Gaussian used to fit the MgII line.REAL
errnorm2_oiii4959Uncertainty in the normalisation of the second Gaussian used to fit the [OIII]4959 line.REAL
errnorm2_oiii5007Uncertainty in the normalisation of the second Gaussian used to fit the [OIII]5007 line.REAL
errnorm3_hbUncertainty in the normalisation of the third Gaussian used to fit the H beta line.REAL
errnorm3_mgiiUncertainty in the normalisation of the third Gaussian used to fit the MgII line.REAL
errnorm4_hbUncertainty in the normalisation of the fourth Gaussian used to fit the H beta line.REAL
errnorm_feii1Uncertainty in the normalisation of the iron template model used to fit the MgII continuum region.REAL
errnorm_feii2Uncertainty in the normalisation of the iron template model used to fit the H beta continuum region.REAL
errnorm_gal1Uncertainty in the normalisation of the galaxy model used to fit the MgII continuum region.REAL
errnorm_gal2Uncertainty in the normalisation of the galaxy model used to fit the H beta continuum region.REAL
errnorm_heiiUncertainty in the normalisation of the Gaussian used to fit the HeII line.REAL
errnorm_pl1Uncertainty in the normalisation of the power law fit to the MgII continuum region.REAL
errnorm_pl2Uncertainty in the normalisation of the power law fit to the H beta continuum region.REAL
errpeak1_hbUncertainty in the wavelength of the peak of the first Gaussian used to fit the H beta line.REAL
errpeak1_mgiiUncertainty in the wavelength of the peak of the first Gaussian used to fit the MgII line.REAL
errpeak1_oiii4959Uncertainty in the wavelength of the peak of the first Gaussian used to fit the [OIII]4959 line.REAL
errpeak1_oiii5007Uncertainty in the wavelength of the peak of the first Gaussian used to fit the [OIII]5007 line.REAL
errpeak2_hbUncertainty in the wavelength of the peak of the second Gaussian used to fit the H beta line.REAL
errpeak2_mgiiUncertainty in the wavelength of the peak of the second Gaussian used to fit the MgII line.REAL
errpeak2_oiii4959Uncertainty in the wavelength of the peak of the second Gaussian used to fit the [OIII]4959 line.REAL
errpeak2_oiii5007Uncertainty in the wavelength of the peak of the second Gaussian used to fit the [OIII]5007 line.REAL
errpeak3_hbUncertainty in the wavelength of the peak of the third Gaussian used to fit the H beta line.REAL
errpeak3_mgiiUncertainty in the wavelength of the peak of the third Gaussian used to fit the MgII line.REAL
errpeak4_hbUncertainty in the wavelength of the peak of the fourth Gaussian used to fit the H beta line.REAL
errpeak_heiiUncertainty in the wavelength of the peak of the Gaussian used to fit the HeII line.REAL
errslope_pl1Uncertainty in the slope of the power law fit to the MgII continuum region.REAL
errslope_pl2Uncertainty in the slope of the power law fit to the H beta continuum region.REAL
errvirialfwhm_hbUncertainty in the FWHM of the H beta broad line profile.REAL
errvirialfwhm_mgiiUncertainty in the FWHM of the MgII broad line profile.REAL
errwidth1_hbUncertainty in the width of the first Gaussian used to fit the H beta line.REAL
errwidth1_mgiiUncertainty in the width of the first Gaussian used to fit the MgII line.REAL
errwidth1_oiii4959Uncertainty in the width of the first Gaussian used to fit the [OIII]4959 line.REAL
errwidth1_oiii5007Uncertainty in the width of the first Gaussian used to fit the [OIII]5007 line.REAL
errwidth2_hbUncertainty in the width of the second Gaussian used to fit the H beta line.REAL
errwidth2_mgiiUncertainty in the width of the second Gaussian used to fit the MgII line.REAL
errwidth2_oiii4959Uncertainty in the width of the second Gaussian used to fit the [OIII]4959 line.REAL
errwidth2_oiii5007Uncertainty in the width of the second Gaussian used to fit the [OIII]5007 line.REAL
errwidth3_hbUncertainty in the width of the third Gaussian used to fit the H beta line.REAL
errwidth3_mgiiUncertainty in the width of the third Gaussian used to fit the MgII line.REAL
errwidth4_hbUncertainty in the width of the fourth Gaussian used to fit the H beta line.REAL
errwidth_feii1Uncertainty in the FWHM of the Gaussian kernel convolved with the iron template used to fit the MgII continuum region.REAL
errwidth_feii2Uncertainty in the FWHM of the Gaussian kernel convolved with the iron template used to fit the H beta continuum region.REAL
errwidth_heiiUncertainty in the width of the Gaussian used to fit the HeII line.REAL
eximl_2rxsExistence likelihood of the 2RXS detection.REAL
exptimeExposure time of the X-ray detection.REAL
f_2rxsFlux in the 0.1-2.4 keV range (2RXS).REAL
f_xmmslFlux in the 0.2-12 keV range (XMMSL).REAL
fden_2rxsFlux density at 2 keV (2RXS).REAL
fiberidSDSS fibre identification.SMALLINT
fwhm1_hbFWHM of the first Gaussian used to fit the H beta line.REAL
fwhm1_mgiiFWHM of the first Gaussian used to fit the MgII line.REAL
fwhm1_oiii4959FWHM of the first Gaussian used to fit the [OIII]4959 line.REAL
fwhm1_oiii5007FWHM of the first Gaussian used to fit the [OIII]5007 line.REAL
fwhm2_hbFWHM of the second Gaussian used to fit the H beta line.REAL
fwhm2_mgiiFWHM of the second Gaussian used to fit the MgII line.REAL
fwhm2_oiii4959FWHM of the second Gaussian used to fit the [OIII]4959 line.REAL
fwhm2_oiii5007FWHM of the second Gaussian used to fit the [OIII]5007 line.REAL
fwhm3_hbFWHM of the third Gaussian used to fit the H beta line.REAL
fwhm3_mgiiFWHM of the third Gaussian used to fit the MgII line.REAL
fwhm4_hbFWHM of the fourth Gaussian used to fit the H beta line.REAL
fwhm_heiiFWHM of the Gaussian used to fit the HeII line.REAL
hb_chiReduced chi-squared of the fit to the H beta region.REAL
htm9HTM index (order 9 => ~10 arcmin size)INTEGER
l_2500Monochromatic luminosity at 2500 Ang.REAL
l_3000Monochromatic luminosity at 3000 Ang.REAL
l_5100Monochromatic luminosity at 5100 Ang.REAL
l_bol1Bolometric luminosity derived from the monochromatic luminosity at 3000 Ang.REAL
l_bol2Bolometric luminosity derived from the monochromatic luminosity at 5100 Ang.REAL
l_edd1Eddington luminosity based on the black hole mass estimate derived using the Shen & Liu (2012) calibration.REAL
l_edd2Eddington luminosity based on the black hole mass estimate derived using the Assef et al. (2011) calibration.REAL
logbhma_hbBlack hole mass derived from the H beta line using the Assef et al. (2011) calibration.REAL
logbhmmd_hbBlack hole mass derived from the H beta line using the McLure & Dunlop (2004) calibration.REAL
logbhms_mgiiBlack hole mass derived from the MgII line using the Shen & Liu (2012) calibration.REAL
logbhmvp_hbBlack hole mass derived from the H beta line using the Vestergaard & Peterson (2006) calibration.REAL
mgii_chiReduced chi-squared of the fit to the MgII region.REAL
mjdMJD that the SDSS spectrum was taken.INTEGER
nameName of the X-ray detection.CHAR
nest4096HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec sizeINTEGER
norm1_hbNormalisation of the first Gaussian used to fit the H beta line.REAL
norm1_mgiiNormalisation of the first Gaussian used to fit the MgII line.REAL
norm1_oiii4959Normalisation of the first Gaussian used to fit the [OIII]4959 line.REAL
norm1_oiii5007Normalisation of the first Gaussian used to fit the [OIII]5007 line.REAL
norm2_hbNormalisation of the second Gaussian used to fit the H beta line.REAL
norm2_mgiiNormalisation of the second Gaussian used to fit the MgII line.REAL
norm2_oiii4959Normalisation of the second Gaussian used to fit the [OIII]4959 line.REAL
norm2_oiii5007Normalisation of the second Gaussian used to fit the [OIII]5007 line.REAL
norm3_hbNormalisation of the third Gaussian used to fit the H beta line.REAL
norm3_mgiiNormalisation of the third Gaussian used to fit the MgII line.REAL
norm4_hbNormalisation of the fourth Gaussian used to fit the H beta line.REAL
norm_feii1Normalisation of the iron template model used to fit the MgII continuum region.REAL
norm_feii2Normalisation of the iron template model used to fit the H beta continuum region.REAL
norm_gal1Normalisation of the galaxy model used to fit the MgII continuum region.REAL
norm_gal2Normalisation of the galaxy model used to fit the H beta continuum region.REAL
norm_heiiNormalisation of the Gaussian used to fit the HeII line.REAL
norm_pl1Normalisation of the power law fit to the MgII continuum region.REAL
norm_pl2Normalisation of the power law fit to the H beta continuum region.REAL
oiii_hbeta_ratioFlux ratio of [OIII]5007 to H betaREAL
peak1_hbWavelength of the peak of the first Gaussian used to fit the H beta line.REAL
peak1_mgiiWavelength of the peak of the first Gaussian used to fit the MgII line.REAL
peak1_oiii4959Wavelength of the peak of the first Gaussian used to fit the [OIII]4959 line.REAL
peak1_oiii5007Wavelength of the peak of the first Gaussian used to fit the [OIII]5007 line.REAL
peak2_hbWavelength of the peak of the second Gaussian used to fit the H beta line.REAL
peak2_mgiiWavelength of the peak of the second Gaussian used to fit the MgII line.REAL
peak2_oiii4959Wavelength of the peak of the second Gaussian used to fit the [OIII]4959 line.REAL
peak2_oiii5007Wavelength of the peak of the second Gaussian used to fit the [OIII]5007 line.REAL
peak3_hbWavelength of the peak of the third Gaussian used to fit the H beta line.REAL
peak3_mgiiWavelength of the peak of the third Gaussian used to fit the MgII line.REAL
peak4_hbWavelength of the peak of the fourth Gaussian used to fit the H beta line.REAL
peak_heiiWavelength of the peak of the Gaussian used to fit the HeII line.REAL
plateSDSS plate number.SMALLINT
plug_decDeclination of the drilled fibre position.DOUBLE
plug_raRight ascension of the drilled fibre position.DOUBLE
r_feiiFlux ratio of the blue component of the FeII emission to H beta.REAL
raRight ascension of the X-ray detection (J2000).DOUBLE
random_idRandom ID in the range 0.0 => 100.0REAL
redshiftSource redshift based on the visual inspection results.REAL
ring256HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size)INTEGER
run2dSpectroscopic reprocessing number.CHAR
slope_pl1Slope of the power law fit to the MgII continuum region.REAL
slope_pl2Slope of the power law fit to the H beta continuum region.REAL
specobjidUnique database ID based on PLATE, MJD, FIBERID, RUN2DBIGINT
virialfwhm_hbFWHM of the H beta broad line profile.REAL
virialfwhm_mgiiFWHM of the MgII broad line profile.REAL
width1_hbWidth of the first Gaussian used to fit the H beta line.REAL
width1_mgiiWidth of the first Gaussian used to fit the MgII line.REAL
width1_oiii4959Width of the first Gaussian used to fit the [OIII]4959 line.REAL
width1_oiii5007Width of the first Gaussian used to fit the [OIII]5007 line.REAL
width2_hbWidth of the second Gaussian used to fit the H beta line.REAL
width2_mgiiWidth of the second Gaussian used to fit the MgII line.REAL
width2_oiii4959Width of the second Gaussian used to fit the [OIII]4959 line.REAL
width2_oiii5007Width of the second Gaussian used to fit the [OIII]5007 line.REAL
width3_hbWidth of the third Gaussian used to fit the H beta line.REAL
width3_mgiiWidth of the third Gaussian used to fit the MgII line.REAL
width4_hbWidth of the fourth Gaussian used to fit the H beta line.REAL
width_feii1FWHM of the Gaussian kernel convolved with the iron template used to fit the MgII continuum region.REAL
width_feii2FWHM of the Gaussian kernel convolved with the iron template used to fit the H beta continuum region.REAL
width_heiiWidth of the Gaussian used to fit the HeII line.REAL
xray_detectionFlag indicating whether the X-ray source was detected in the 2RXS or XMMSL survey.CHAR