Choose a database in the left panel then select the table you want!
Table: sdss_dr13.dr12qso
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| ai_civ | AI of CIV trough | DOUBLE |
| alpha_nu | Spectral index | DOUBLE |
| amp_ciii | Amplitude of CIII] complex | DOUBLE |
| amp_civ | Amplitude of CIV emission | DOUBLE |
| amp_mgii | Amplitude of MgII emission | DOUBLE |
| ancillary_target1 | Ancillary TS flag 1 | BIGINT |
| ancillary_target2 | Ancillary TS flag 2 | BIGINT |
| bal_flag_vi | BAL flag from visual inspection | SMALLINT |
| bhwhm_ciii | Blue HWHM of CIII] complex | DOUBLE |
| bhwhm_civ | Blue HWHM of CIV emission | DOUBLE |
| bhwhm_mgii | Blue HWHM of MgII emission | DOUBLE |
| bi_civ | BI of CIV trough | DOUBLE |
| boss_target1 | Main survey TS flag | BIGINT |
| cc_flags | WISE contamination and confusion flag | CHAR |
| chi2trough | Chi2 of the CIV troughs | DOUBLE |
| col_number | Camera column number | SMALLINT |
| dec | Declination (J2000) | DOUBLE |
| dgmi | Differential color delta(g-i) | DOUBLE |
| eboss_target0 | SEQUELS TS flag | BIGINT |
| err_ai_civ | Error on AI of CIV trough | DOUBLE |
| err_bi_civ | Error on BI of CIV trough | DOUBLE |
| err_flux02_12kev | Error on total flux from XMM-Newton | DOUBLE |
| err_flux02_12kev_sgl | Error on total flux (0.2-12 keV) from XMM-Newton | DOUBLE |
| err_flux02_2kev | Error on soft (0.2-2 keV) X-ray flux from XMM-Newton | DOUBLE |
| err_flux2_12kev | Error on hard (4.5-12 keV) X-ray flux from XMM-Newton | DOUBLE |
| err_hmag | Error on H-band magnitude | DOUBLE |
| err_jmag | Error on J-band magnitude | DOUBLE |
| err_kmag | Error on K-band magnitude | DOUBLE |
| err_psfmag_g | Error on PSF magnitude in g-band | REAL |
| err_psfmag_i | Error on PSF magnitude in i-band | REAL |
| err_psfmag_r | Error on PSF magnitude in r-band | REAL |
| err_psfmag_u | Error on PSF magnitude in u-band | REAL |
| err_psfmag_z | Error on PSF magnitude in z-band | REAL |
| err_rewe_ciii | Error on rest EW of CIII] complex | DOUBLE |
| err_rewe_civ | Error on rest EW of CIV emission | DOUBLE |
| err_rewe_mgii | Error on rest EW of MgII emission | DOUBLE |
| err_w1mag | Error on w1 magnitude | DOUBLE |
| err_w2mag | Error on w2 magnitude | DOUBLE |
| err_w3mag | Error on w3 magnitude | DOUBLE |
| err_w4mag | Error on w4 magnitude | DOUBLE |
| err_zpca | Error on PCA redshift | DOUBLE |
| err_zpipe | Error on pipeline redshift | REAL |
| extinction_g | g-band Galactic extinction from Schlegel et al. (1998) | REAL |
| extinction_i | i-band Galactic extinction from Schlegel et al. (1998) | REAL |
| extinction_r | r-band Galactic extinction from Schlegel et al. (1998) | REAL |
| extinction_recal_g | g-band Galactic extinction from Schlafly & Finkbeiner (2011) | REAL |
| extinction_recal_i | i-band Galactic extinction from Schlafly & Finkbeiner (2011) | REAL |
| extinction_recal_r | r-band Galactic extinction from Schlafly & Finkbeiner (2011) | REAL |
| extinction_recal_u | u-band Galactic extinction from Schlafly & Finkbeiner (2011) | REAL |
| extinction_recal_z | z-band Galactic extinction from Schlafly & Finkbeiner (2011) | REAL |
| extinction_u | u-band Galactic extinction from Schlegel et al. (1998) | REAL |
| extinction_z | z-band Galactic extinction from Schlegel et al. (1998) | REAL |
| fiberid | Fiber number | INTEGER |
| fiberid_dr7 | DR7 Fiber number | INTEGER |
| fiberid_duplicate_1 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_10 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_11 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_12 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_13 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_14 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_15 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_16 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_17 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_18 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_19 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_2 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_20 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_21 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_22 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_23 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_24 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_25 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_26 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_27 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_28 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_29 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_3 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_30 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_31 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_32 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_4 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_5 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_6 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_7 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_8 | Fiber number of each duplicate spectrum | INTEGER |
| fiberid_duplicate_9 | Fiber number of each duplicate spectrum | INTEGER |
| field_number | Field number | SMALLINT |
| first_flux | FIRST peak flux density at 20 cm | DOUBLE |
| first_matched | FIRST match flag | SMALLINT |
| first_snr | SNR of the FIRST flux density | DOUBLE |
| flux02_12kev | Total weighted average flux (0.2-12 keV) from XMM-Newton | DOUBLE |
| flux02_12kev_sgl | Total flux (0.2-12 keV) from XMM-Newton computed from the longest observation | DOUBLE |
| flux02_2kev | Soft (0.2-2 keV) X-ray flux from XMM-Newton | DOUBLE |
| flux2_12kev | Hard (4.5-12 keV) X-ray flux from XMM-Newton | DOUBLE |
| fuv | fuv flux (GALEX) | DOUBLE |
| fuv_ivar | Inverse variance of fuv flux | DOUBLE |
| fwhm_ciii | FWHM of CIII] complex | DOUBLE |
| fwhm_civ | FWHM of CIV emission | DOUBLE |
| fwhm_mgii | FWHM of MgII emission | DOUBLE |
| galex_matched | GALEX match flag | SMALLINT |
| hflux | H-band flux from UKIDSS | REAL |
| hflux_err | Error in H-band flux from UKIDSS | REAL |
| hi_gal | log of Galactic HI column density | DOUBLE |
| hmag | H-band magnitude (Vega, 2MASS) | DOUBLE |
| hrdflag | H-band photometry flag | INTEGER |
| hsnr | H-band SNR | DOUBLE |
| ivar_psfflux_g | Inverse variance of PSF flux in g-band | REAL |
| ivar_psfflux_i | Inverse variance of PSF flux in i-band | REAL |
| ivar_psfflux_r | Inverse variance of PSF flux in r-band | REAL |
| ivar_psfflux_u | Inverse variance of PSF flux in u-band | REAL |
| ivar_psfflux_z | Inverse variance of PSF flux in z-band | REAL |
| jflux | J-band flux from UKIDSS | REAL |
| jflux_err | Error in J-band flux from UKIDSS | REAL |
| jmag | J-band magnitude (Vega, 2MASS) | DOUBLE |
| jrdflag | J-band photometry flag | INTEGER |
| jsnr | J-band SNR | DOUBLE |
| kflux | K-band flux from UKIDSS | REAL |
| kflux_err | Error in K-band flux from UKIDSS | REAL |
| kmag | K-band magnitude (Vega, 2MASS) | DOUBLE |
| krdflag | K-band photometry flag | INTEGER |
| ksnr | K-band SNR | DOUBLE |
| lum02_2kev | Total (0.2-12 keV) X-ray luminosity from XMM-Newton | DOUBLE |
| lum02_2kev_sgl | Total X-ray luminosity (0.2-12 keV) from XMM-Newton using the longest exposure | DOUBLE |
| lum05_2kev | Soft (0.5-2 keV) X-ray luminosity from XMM-Newton | DOUBLE |
| lum2_12kev | Hard (2-12 keV) X-ray luminosity from XMM-Newton | DOUBLE |
| lumx2_10_upper | Flag for upper limit for hard X-ray flux | SMALLINT |
| mi | Absolute Magnitude Mi[z=2] | DOUBLE |
| mjd | Spectroscopic MJD | INTEGER |
| mjd_dr7 | DR7 spectroscopic MJD | INTEGER |
| mjd_duplicate_1 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_10 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_11 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_12 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_13 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_14 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_15 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_16 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_17 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_18 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_19 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_2 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_20 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_21 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_22 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_23 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_24 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_25 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_26 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_27 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_28 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_29 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_3 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_30 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_31 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_32 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_4 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_5 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_6 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_7 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_8 | MJD of each duplicate spectrum | INTEGER |
| mjd_duplicate_9 | MJD of each duplicate spectrum | INTEGER |
| n_detection_xmm | Number of detections in XMM-Newton | SMALLINT |
| nciv_2000 | Number of CIV troughs larger than 2000 km/s | INTEGER |
| nciv_450 | Number of CIV troughs larger than 450 km/s | INTEGER |
| nspec_boss | Number of additional spectra available in SDSS/BOSS | INTEGER |
| nuv | nuv flux (GALEX) | DOUBLE |
| nuv_ivar | Inverse variance of nuv flux | DOUBLE |
| obj_id | Object identification number | CHAR |
| pca_qual | Quality of PCA continuum | DOUBLE |
| ph_flag | WISE photometric quality flag | CHAR |
| photo_mjd | Photometric MJD | INTEGER |
| plate | Plate number | INTEGER |
| plate_dr7 | DR7 plate number | INTEGER |
| plate_duplicate_1 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_10 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_11 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_12 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_13 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_14 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_15 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_16 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_17 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_18 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_19 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_2 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_20 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_21 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_22 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_23 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_24 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_25 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_26 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_27 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_28 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_29 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_3 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_30 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_31 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_32 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_4 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_5 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_6 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_7 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_8 | Plate number of each duplicate spectrum | INTEGER |
| plate_duplicate_9 | Plate number of each duplicate spectrum | INTEGER |
| 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 |
| 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 |
| ra | Right ascension (J2000) | DOUBLE |
| rass_counts | log RASS full band count rate | DOUBLE |
| rass_counts_snr | SNR of RASS count rate | DOUBLE |
| rerun_number | Photometric Processing Rerun number | CHAR |
| rew_aliii | Rest EW of AlIII trough | DOUBLE |
| rew_civ | Rest EW of CIV trough | DOUBLE |
| rew_siiv | Rest EW of SiIV trough | DOUBLE |
| rewe_ciii | Rest EW of CIII] complex | DOUBLE |
| rewe_civ | Rest EW of CIV emission | DOUBLE |
| rewe_mgii | Rest EW of MgII emission | DOUBLE |
| rhwhm_ciii | Red HWHM of CIII] complex | DOUBLE |
| rhwhm_civ | Red HWHM of CIV emission | DOUBLE |
| rhwhm_mgii | Red HWHM of MgII emission | DOUBLE |
| run_number | Imaging Run Number | SMALLINT |
| sdss2first_sep | SDSS-FIRST separation | DOUBLE |
| sdss2mass_sep | SDSS-2MASS separation | DOUBLE |
| sdss2rosat_sep | SDSS-RASS separation | DOUBLE |
| sdss2wise_sep | SDSS-WISE separation | DOUBLE |
| sdss2xmm_sep | SDSS-XMM-Newton separation | DOUBLE |
| sdss_dr7 | DR7 observation flag | INTEGER |
| sdss_morpho | Morphology flag | SMALLINT |
| sdss_name | SDSS-DR12 designation | CHAR |
| snr_1700 | Median SNR (1650-1750A rest) | DOUBLE |
| snr_3000 | Median SNR (2950-3050A rest) | DOUBLE |
| snr_5150 | Median SNR (5100-5250A rest) | DOUBLE |
| snr_duplicate_1 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_10 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_11 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_12 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_13 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_14 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_15 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_16 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_17 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_18 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_19 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_2 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_20 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_21 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_22 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_23 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_24 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_25 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_26 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_27 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_28 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_29 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_3 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_30 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_31 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_32 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_4 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_5 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_6 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_7 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_8 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_duplicate_9 | Median SNR (whole spectrum) for each duplicate spectrum | DOUBLE |
| snr_spec | Median SNR (whole spectrum) | DOUBLE |
| target_flux_g | g-band target flux | DOUBLE |
| target_flux_i | i-band target flux | DOUBLE |
| target_flux_r | r-band target flux | DOUBLE |
| target_flux_u | u-band target flux | DOUBLE |
| target_flux_z | z-band target flux | DOUBLE |
| thing_id | Unique identifier | INTEGER |
| ukidss_matched | UKIDSS flag | SMALLINT |
| uniform | Uniform sample flag | SMALLINT |
| var_a | Structure function parameter A as defined in Palanque-Delabrouille et al. (2011) | DOUBLE |
| var_chi2 | Reduced chi2 when the light curve is fitted with a constant | DOUBLE |
| var_gamma | Structure function parameter gamma as defined in Palanque-Delabrouille et al. (2011) | DOUBLE |
| var_matched | Variability information flag | SMALLINT |
| vmax_civ_2000 | Max velocity of CIV troughs (col60) | DOUBLE |
| vmax_civ_450 | Max velocity of CIV troughs (col63) | DOUBLE |
| vmin_civ_2000 | Min velocity of CIV troughs (col60) | DOUBLE |
| vmin_civ_450 | Min velocity of CIV troughs (col63) | DOUBLE |
| w1chi2 | Chi2 in w1 band | DOUBLE |
| w1mag | w1 magnitude (Vega, WISE) | DOUBLE |
| w1snr | SNR in w1 band | DOUBLE |
| w2chi2 | Chi2 in w2 band | DOUBLE |
| w2mag | w2 magnitude (Vega, WISE) | DOUBLE |
| w2snr | SNR in w2 band | DOUBLE |
| w3chi2 | Chi2 in w3 band | DOUBLE |
| w3mag | w3 magnitude (Vega, WISE) | DOUBLE |
| w3snr | SNR in w3 band | DOUBLE |
| w4chi2 | Chi2 in w4 band | DOUBLE |
| w4mag | w4 magnitude (Vega, WISE) | DOUBLE |
| w4snr | SNR in w4 band | DOUBLE |
| yflux | Y-band flux from UKIDSS | REAL |
| yflux_err | Error in Y-band flux from UKIDSS | REAL |
| z_ciii | CIII] complex redshift | DOUBLE |
| z_civ | CIV redshift | DOUBLE |
| z_mgii | MgII redshift | DOUBLE |
| z_pca | PCA redshift | DOUBLE |
| z_pipe | BOSS pipeline redshift | REAL |
| z_vi | Visual inspection redshift | DOUBLE |
| zwarning | zwarning flag | INTEGER |
