Choose a database in the left panel then select the table you want!
Table: sdss_dr14.dr14q
(The bold columns are indexed columns)
Column Name | Description | Datatype |
---|---|---|
ancillary_target1 | BOSS target selection flag for ancillary programs | BIGINT |
ancillary_target2 | BOSS target selection flag for ancillary programs | BIGINT |
bi_civ | BALnicity Index of CIV absorption trough | REAL |
boss_target1 | BOSS target selection flag for main survey | BIGINT |
cc_flags | WISE contamination and confusion flag | CHAR |
dec | Declination in decimal degrees(J2000) | DOUBLE |
disk_only | TRUE if the object is not listed in specobjall. | CHAR |
eboss_target0 | Target selection flag for the eBOSS pilot survey | BIGINT |
eboss_target1 | eBOSS target selection flag | BIGINT |
eboss_target2 | eBOSS target selection flag | BIGINT |
elat | Ecliptic Latitude | DOUBLE |
elon | Ecliptic Longitude | DOUBLE |
err_bi_civ | Error on the Balnicity index of CIV trough | REAL |
extinction_g | Galactic extinction in SDSS g band from from Schlafly & Finkbeiner (2011) | REAL |
extinction_i | Galactic extinction in SDSS i band from from Schlafly & Finkbeiner (2011) | REAL |
extinction_r | Galactic extinction in SDSS r band from from Schlafly & Finkbeiner (2011) | REAL |
extinction_u | Galactic extinction in SDSS u band from from Schlafly & Finkbeiner (2011) | REAL |
extinction_z | Galactic extinction in SDSS z band from from Schlafly & Finkbeiner (2011) | REAL |
fiberid | Spectroscopic fiber number | SMALLINT |
first_flux | FIRST peak flux density at 20 cm | REAL |
first_matched | FIRST matching flag | SMALLINT |
first_snr | S/N of the FIRST flux density | REAL |
fuv | FUV flux (GALEX) | REAL |
fuv_ivar | Inverse variance of FUV flux | REAL |
galex_matched | GALEX match flag | SMALLINT |
glat | Galactic Latitude | DOUBLE |
glon | Galactic Longitude | DOUBLE |
hflux | H-band flux density from UKIDSS | REAL |
hflux_err | Error in H-band flux density from UKIDSS | REAL |
hmag | H magnitude (Vega, 2MASS) | REAL |
hmag_err | Error in H magnitude | REAL |
hrdflag | H-Band photometry flag | SMALLINT |
hsnr | H-Band S/N | REAL |
htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
instrument | Spectrograph used for the observation (SDSS or BOSS) | CHAR |
jflux | J-band density flux from UKIDSS | REAL |
jflux_err | Error in J-band flux density from UKIDSS) | REAL |
jmag | J magnitude (Vega, 2MASS) | REAL |
jmag_err | Error in J magnitude | REAL |
jrdflag | H-Band photometry flag | SMALLINT |
jsnr | J-Band S/N | REAL |
kflux | K-band flux density from UKIDSS | REAL |
kflux_err | Error in K-band flux density from UKIDSS | REAL |
kmag | K magnitude (Vega, 2MASS) | REAL |
kmag_err | Error in K magnitude | REAL |
krdflag | K-Band photometry flag | SMALLINT |
ksnr | K-Band S/N | REAL |
mi | Absolute magnitude in i band, Mi [z = 2], see DR14Q paper for cosmology | REAL |
mjd | Modified Julian Day of the spectroscopic observation | INTEGER |
n_spec | Number of additional spectra available in SDSS-I/II/III/IV | SMALLINT |
n_spec_boss | Number of additional spectra available in SDSS-III/IV | SMALLINT |
n_spec_sdss | Number of additional spectra available in SDSS-I/II | SMALLINT |
nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size | INTEGER |
nuv | NUV flux (GALEX) | REAL |
nuv_ivar | Inverse variance of NUV flux | REAL |
ph_flags | WISE photometric quality flag | CHAR |
plate | Spectroscopic plate number | SMALLINT |
psfflux_g | PSF flux in g band | REAL |
psfflux_i | PSF flux in i band | REAL |
psfflux_r | PSF flux in r band | REAL |
psfflux_u | PSF flux in u band | REAL |
psfflux_z | PSF flux in z band | REAL |
psffluxivar_g | Inverse variance of PSF flux in g band | REAL |
psffluxivar_i | Inverse variance of PSF flux in i band | REAL |
psffluxivar_r | Inverse variance of PSF flux in r band | REAL |
psffluxivar_u | Inverse variance of PSF flux in u band | REAL |
psffluxivar_z | Inverse variance of PSF flux in z band | REAL |
psfmag_g | PSF magnitude in g band | REAL |
psfmag_i | PSF magnitude in i band | REAL |
psfmag_r | PSF magnitude in r band | REAL |
psfmag_u | PSF magnitude in u band | REAL |
psfmag_z | PSF magnitude in z band | REAL |
psfmagerr_g | PSF magnitude in g band | REAL |
psfmagerr_i | PSF magnitude in i band | REAL |
psfmagerr_r | PSF magnitude in r band | REAL |
psfmagerr_u | PSF magnitude in u band | REAL |
psfmagerr_z | PSF magnitude in z band | REAL |
ra | Right Ascension in decimal degrees(J2000) | DOUBLE |
random_id | Random ID in the range 0.0 => 100.0 | REAL |
rass_counts | log RASS full band count rate (counts/s) | REAL |
rass_counts_snr | S/N of the RASS count rate | REAL |
ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
run2d | 2D Reduction version of spectrum | CHAR |
sdss2first_sep | SDSS-FIRST separation | REAL |
sdss2mass_sep | SDSS-2MASS separation | REAL |
sdss2rosat_sep | SDSS-RASS separation | REAL |
sdss2wise_sep | SDSS-WISE separation | REAL |
sdss2xmm_sep | SDSS-XMM-Newton separation | REAL |
sdss_joinid | Unique ID based on PLATE, MJD, FIBERID for joining across data releases | BIGINT |
sdssname | SDSS-DR14 designation - hhmmss.ss+ddmmss.s (J2000) | CHAR |
specobjid | Unique database ID based on PLATE, MJD, FIBERID, RUN2D | BIGINT |
thing_id | Unique SDSS source identifier | INTEGER |
ukidss_matched | UKIDSS matching flag | SMALLINT |
w1chi2 | chi-squared in W1 band | REAL |
w1mag | W1 magnitude (Vega, WISE) | REAL |
w1mag_err | Error in W1 magnitude | REAL |
w1snr | S/N in W1 band | REAL |
w2chi2 | chi-squared in W2 band | REAL |
w2mag | W2 magnitude (Vega, WISE) | REAL |
w2mag_err | Error in W2 magnitude | REAL |
w2snr | S/N in W2 band | REAL |
w3chi2 | chi-squared in W3 band | REAL |
w3mag | W3 magnitude (Vega, WISE) | REAL |
w3mag_err | Error in W3 magnitude | REAL |
w3snr | S/N in W3 band | REAL |
w4chi2 | chi-squared in W4 band | REAL |
w4mag | W4 magnitude (Vega, WISE) | REAL |
w4mag_err | Error in W4 magnitude | REAL |
w4snr | S/N in W4 band | REAL |
xmm_flux | Total (0.2-12.0 keV) X-ray flux from XMM-Newton | REAL |
xmm_flux_err | Error on total X-ray flux from XMM-Newton | REAL |
xmm_hard_flux | Hard (4.5-12.0 keV) X-ray flux from XMM-Newton | REAL |
xmm_hard_flux_err | Error on hard X-ray flux from XMM-Newton | REAL |
xmm_luminosity | Total (0.2-12.0 keV) X-ray luminosity from XMM-Newton | REAL |
xmm_soft_flux | Soft (0.2-2.0 keV) X-ray flux from XMM-Newton | REAL |
xmm_soft_flux_err | Error on soft X-ray flux from XMM-Newton | REAL |
yflux | Y-band flux density from UKIDSS | REAL |
yflux_err | Error in Y-band flux density from UKIDSS | REAL |
z | Redshift (most robust estimate for each quasar) | REAL |
zerr | Error on redshift given in Col. #9 | REAL |
zmgii | Redshift of the MgII emission line | REAL |
zpca | PCA redshift (homogeneous over the full sample) | REAL |
zpcaerr | Error on PCA redshift | REAL |
zpipe | SDSS pipeline redshift estimate | REAL |
zpipeerr | Error on SDSS pipeline redshift estimate | REAL |
zsource | Origin of the Z measurement (VI, PIPE, AUTO, OTHER) | CHAR |
zvi | Redshift based on visual inspection (when available) | REAL |
zwarning | Quality flag on SDSS pipeline redshift measurement | INTEGER |