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

(The bold columns are indexed columns)
Column NameDescriptionDatatype
ancillary_target1BOSS ancillary science target selection information at plate designBIGINT
ancillary_target2BOSS ancillary target selection information at plate designBIGINT
anyandmaskFor each bit, records whether any pixel in the spectrum has that bit set in its ANDMASKINTEGER
anyormaskFor each bit, records whether any pixel in the spectrum has that bit set in its ORMASKINTEGER
bestobjidObject ID of photoObj match (position-based)BIGINT
bluefiberSet to 1 if this hole was designated a "blue fiber", 0 if designated a "red fiber" (high redshift LRGs are preferentially in "red fibers")INTEGER
boss_target1BOSS target selection information at plateBIGINT
bossprimaryBest version of spectrum at this location, among BOSS platesSMALLINT
bossspecobjidIndex of BOSS observation in spAll flat fileINTEGER
chi68p68-th percentile value of abs(chi) of the best-fit synthetic spectrum to the actual spectrum (around 1.0 for a good fit)REAL
chunkChunk nameCHAR
classSpectroscopic class (GALAXY, QSO, or STAR)CHAR
class_noqsoClassification in "z_noqso" redshiftCHAR
class_personPerson-assigned classification, if this object has been inspectedSMALLINT
comments_personComments from person for inspected objectsCHAR
cxx of Normal unit vector in J2000DOUBLE
cyy of Normal unit vector in J2000DOUBLE
czz of Normal unit vector in J2000DOUBLE
decDeclination of fiber, J2000DOUBLE
deredsn2Dereddened signal-to-noise-squared measure for plate (only set for BOSS spectrograph)REAL
designidDesign ID numberINTEGER
dofDegrees of freedom in best fitINTEGER
eboss_target0EBOSS target selection information, for SEQUELS platesBIGINT
eboss_target1EBOSS target selection information, for eBOSS platesBIGINT
eboss_target2EBOSS target selection information, for TDSS, SPIDERS, ELG, etc. platesBIGINT
eboss_target_idEBOSS unique target identifier for every spectroscopic target,BIGINT
elatEcliptic LatitudeDOUBLE
elodiebv(B-V) colorREAL
elodiedofDegrees of freedom for fitINTEGER
elodiefehMetallicity ([Fe/H])REAL
elodiefilenameFile name for best-fit Elodie starCHAR
elodielogglog10(gravity)REAL
elodieobjectStar name (mostly Henry Draper names)CHAR
elodierchi2Reduced chi^2REAL
elodiesptypeSpectral typeCHAR
elodieteffEffective temperatureREAL
elodiezRedshiftREAL
elodiezerrRedshift error (negative for invalid fit)REAL
elodiezmodelerrStandard deviation in redshift among the 12 best-fit starsREAL
elonEcliptic LongitudeDOUBLE
fiberidFiber IDSMALLINT
firstreleaseName of first release this object was associated withCHAR
fluxobjidObject ID of photoObj match (flux-based)BIGINT
fracnsighi_1Fraction of pixels high by more than 1 sigma relative to best-fitREAL
fracnsighi_10Fraction of pixels high by more than 10 sigma relative to best-fitREAL
fracnsighi_2Fraction of pixels high by more than 2 sigma relative to best-fitREAL
fracnsighi_3Fraction of pixels high by more than 3 sigma relative to best-fitREAL
fracnsighi_4Fraction of pixels high by more than 4 sigma relative to best-fitREAL
fracnsighi_5Fraction of pixels high by more than 5 sigma relative to best-fitREAL
fracnsighi_6Fraction of pixels high by more than 6 sigma relative to best-fitREAL
fracnsighi_7Fraction of pixels high by more than 7 sigma relative to best-fitREAL
fracnsighi_8Fraction of pixels high by more than 8 sigma relative to best-fitREAL
fracnsighi_9Fraction of pixels high by more than 9 sigma relative to best-fitREAL
fracnsiglo_1Fraction of pixels low by more than 1 sigma relative to best-fitREAL
fracnsiglo_10Fraction of pixels low by more than 10 sigma relative to best-fitREAL
fracnsiglo_2Fraction of pixels low by more than 2 sigma relative to best-fitREAL
fracnsiglo_3Fraction of pixels low by more than 3 sigma relative to best-fitREAL
fracnsiglo_4Fraction of pixels low by more than 4 sigma relative to best-fitREAL
fracnsiglo_5Fraction of pixels low by more than 5 sigma relative to best-fitREAL
fracnsiglo_6Fraction of pixels low by more than 6 sigma relative to best-fitREAL
fracnsiglo_7Fraction of pixels low by more than 7 sigma relative to best-fitREAL
fracnsiglo_8Fraction of pixels low by more than 8 sigma relative to best-fitREAL
fracnsiglo_9Fraction of pixels low by more than 9 sigma relative to best-fitREAL
fracnsigma_1Fraction of pixels deviant by more than 1 sigma relative to best-fitREAL
fracnsigma_10Fraction of pixels deviant by more than 10 sigma relative to best-fitREAL
fracnsigma_2Fraction of pixels deviant by more than 2 sigma relative to best-fitREAL
fracnsigma_3Fraction of pixels deviant by more than 3 sigma relative to best-fitREAL
fracnsigma_4Fraction of pixels deviant by more than 4 sigma relative to best-fitREAL
fracnsigma_5Fraction of pixels deviant by more than 5 sigma relative to best-fitREAL
fracnsigma_6Fraction of pixels deviant by more than 6 sigma relative to best-fitREAL
fracnsigma_7Fraction of pixels deviant by more than 7 sigma relative to best-fitREAL
fracnsigma_8Fraction of pixels deviant by more than 8 sigma relative to best-fitREAL
fracnsigma_9Fraction of pixels deviant by more than 9 sigma relative to best-fitREAL
glatGalactic LatitudeDOUBLE
glonGalactic LongitudeDOUBLE
htm9HTM index (order 9 => ~10 arcmin size)INTEGER
instrumentInstrument used (SDSS or BOSS spectrograph)CHAR
lambdaeffEffective wavelength that hole was drilled for (accounting for atmopheric refraction)REAL
legacy_target1for Legacy program, target selection information at plate designBIGINT
legacy_target2for Legacy program target selection information at plate design, secondary/qa/calibrationBIGINT
legacyprimaryBest version of spectrum at this location, among Legacy platesSMALLINT
mjdMJD of observationINTEGER
nest4096HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec sizeINTEGER
npolyNumber of polynomial terms used in the fitINTEGER
platePlate numberSMALLINT
plateidDatabase ID of PlateBIGINT
platerunPlate drill run nameCHAR
platesn2Overall signal-to-noise-squared measure for plate (only set for SDSS spectrograph)REAL
primtargettarget selection information at plate design, primary science selection (for backwards compatibility)BIGINT
programnameProgram nameCHAR
raRight ascension of fiber, J2000DOUBLE
random_idRandom ID in the range 0.0 => 100.0REAL
rchi2Reduced chi-squared of best fitREAL
rchi2diffDifference in reduced chi-squared between best and second best fitREAL
rchi2diff_noqsoReduced chi-squared difference from next best redshift, for "z_noqso" redshiftREAL
ring256HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size)INTEGER
run1d1D Reduction version of spectrumCHAR
run2d2D Reduction version of spectrumCHAR
scienceprimaryBest version of spectrum at this location (defines default view SpecObj)SMALLINT
sdssprimaryBest version of spectrum at this location among SDSS plates (defines default view SpecObj)SMALLINT
sectargettarget selection information at plate design, secondary/qa/calib selection (for backwards compatibility)BIGINT
segue1_target1SEGUE-1 target selection information at plate design, primary science selectionBIGINT
segue1_target2SEGUE-1 target selection information at plate design, secondary/qa/calib selectionBIGINT
segue1primaryBest version of spectrum at this location, among SEGUE-1 platesSMALLINT
segue2_target1SEGUE-2 target selection information at plate design, primary science selectionBIGINT
segue2_target2SEGUE-2 target selection information at plate design, secondary/qa/calib selectionBIGINT
segue2primaryBest version of spectrum at this location, among SEGUE-1 platesSMALLINT
segueprimaryBest version of spectrum at this location, among SEGUE platesSMALLINT
sn1_g(S/N)^2 at g=20.20 for spectrograph #1REAL
sn1_i(S/N)^2 at i=19.90 for spectrograph #1REAL
sn1_r(S/N)^2 at r=20.25 for spectrograph #1REAL
sn2_g(S/N)^2 at g=20.20 for spectrograph #2REAL
sn2_i(S/N)^2 at i=19.90 for spectrograph #2REAL
sn2_r(S/N)^2 at r=20.25 for spectrograph #2REAL
snmedianMedian signal-to-noise over all good pixelsREAL
snmedian_gMedian signal-to-noise over all good pixels in g-bandREAL
snmedian_iMedian signal-to-noise over all good pixels in i-bandREAL
snmedian_rMedian signal-to-noise over all good pixels in r-bandREAL
snmedian_uMedian signal-to-noise over all good pixels in u-bandREAL
snmedian_zMedian signal-to-noise over all good pixels in z-bandREAL
snturnoffSignal to noise measure for MS turnoff stars on plate (-9999 if not appropriate)REAL
sourcetypeFor Legacy, SEGUE-2 and BOSS science targets, type of object targeted as (target bits contain full information and are recommended)CHAR
special_target1for Special program target selection information at plate designBIGINT
special_target2for Special program target selection information at plate design, secondary/qa/calibrationBIGINT
specobjidUnique database ID based on PLATE, MJD, FIBERID, RUN2DBIGINT
spectroflux_gSpectrum projected onto g filterREAL
spectroflux_iSpectrum projected onto i filterREAL
spectroflux_rSpectrum projected onto r filterREAL
spectroflux_uSpectrum projected onto u filterREAL
spectroflux_zSpectrum projected onto z filterREAL
spectrofluxivar_gInverse variance of spectrum projected onto g filterREAL
spectrofluxivar_iInverse variance of spectrum projected onto i filterREAL
spectrofluxivar_rInverse variance of spectrum projected onto r filterREAL
spectrofluxivar_uInverse variance of spectrum projected onto u filterREAL
spectrofluxivar_zInverse variance of spectrum projected onto z filterREAL
spectrographidwhich spectrograph (1,2)SMALLINT
spectroskyflux_gSky spectrum projected onto g filterREAL
spectroskyflux_iSky spectrum projected onto i filterREAL
spectroskyflux_rSky spectrum projected onto r filterREAL
spectroskyflux_uSky spectrum projected onto u filterREAL
spectroskyflux_zSky spectrum projected onto z filterREAL
spectrosynflux_gBest-fit template spectrum projected onto g filterREAL
spectrosynflux_iBest-fit template spectrum projected onto i filterREAL
spectrosynflux_rBest-fit template spectrum projected onto r filterREAL
spectrosynflux_uBest-fit template spectrum projected onto u filterREAL
spectrosynflux_zBest-fit template spectrum projected onto z filterREAL
spectrosynfluxivar_gInverse variance of best-fit template spectrum projected onto g filterREAL
spectrosynfluxivar_iInverse variance of best-fit template spectrum projected onto i filterREAL
spectrosynfluxivar_rInverse variance of best-fit template spectrum projected onto r filterREAL
spectrosynfluxivar_uInverse variance of best-fit template spectrum projected onto u filterREAL
spectrosynfluxivar_zInverse variance of best-fit template spectrum projected onto z filterREAL
subclassSpectroscopic subclassCHAR
subclass_noqsoSub-classification in "z_noqso" redshiftCHAR
surveySurvey nameCHAR
targetobjidObject ID of original targetBIGINT
targettypeNature of target: SCIENCE, STANDARD, or SKYCHAR
tcolumn_0Which column of the template file corresponds to template #0SMALLINT
tcolumn_1Which column of the template file corresponds to template #1SMALLINT
tcolumn_2Which column of the template file corresponds to template #2SMALLINT
tcolumn_3Which column of the template file corresponds to template #3SMALLINT
tcolumn_4Which column of the template file corresponds to template #4SMALLINT
tcolumn_5Which column of the template file corresponds to template #5SMALLINT
tcolumn_6Which column of the template file corresponds to template #6SMALLINT
tcolumn_7Which column of the template file corresponds to template #7SMALLINT
tcolumn_8Which column of the template file corresponds to template #8SMALLINT
tcolumn_9Which column of the template file corresponds to template #9SMALLINT
tfileFile name of best fit template sourceCHAR
theta_0Coefficient for template #0 of fitREAL
theta_1Coefficient for template #1 of fitREAL
theta_2Coefficient for template #2 of fitREAL
theta_3Coefficient for template #3 of fitREAL
theta_4Coefficient for template #4 of fitREAL
theta_5Coefficient for template #5 of fitREAL
theta_6Coefficient for template #6 of fitREAL
theta_7Coefficient for template #7 of fitREAL
theta_8Coefficient for template #8 of fitREAL
theta_9Coefficient for template #9 of fitREAL
thing_idUnique identifier from global resolveINTEGER
thing_id_targetingthing_id value from the version of resolve from which the targeting was createdBIGINT
tileTile numberINTEGER
veldispVelocity dispersionREAL
veldispchi2Chi-squared associated with velocity dispersion fitREAL
veldispdofNumber of degrees of freedom in velocity dispersion fitINTEGER
veldisperrError in velocity dispersionREAL
veldispnpixNumber of pixels overlapping best template in velocity dispersion fitREAL
veldispzRedshift associated with best fit velocity dispersionREAL
veldispzerrError in redshift associated with best fit velocity dispersionREAL
wavemaxMaximum observed (vacuum) wavelengthREAL
waveminMinimum observed (vacuum) wavelengthREAL
wcoverageCoverage in wavelength, in units of log10 wavelengthREAL
xfocalX focal plane position (+RA direction)REAL
yfocalY focal plane position (+Dec direction)REAL
zFinal RedshiftREAL
z_noqsoBest redshift when excluding QSO fit (right redshift to use for galaxy targets)REAL
z_personPerson-assigned redshift, if this object has been inspectedREAL
zerrRedshift errorREAL
zerr_noqsoError in "z_noqso" redshiftREAL
zoffsetWasher thickness used (for backstopping BOSS quasar targets, so they are closer to 4000 Angstrom focal plan)REAL
zwarningBitmask of warning values; 0 means all is wellINTEGER
zwarning_noqsoWarnings in "z_noqso" redshiftINTEGER