| name | type | length | unit | ucd | description |
| specobjid | bigint | 8 | | | 64 bit unique spectrum id f(p,mjd,fiber) |
| plate | int | 4 | | | plate number |
| mjd | int | 4 | | | Modified Julian Date of (last) observation |
| fiberid | int | 4 | | | Fiber number (1-640) 1-320 on spec#1 |
| targettype | varchar | 64 | | | SEGUE or Legacy Target type string, see primtarget in specobjall table |
| ra | float | 8 | degrees | | RA (J2000) |
| dec | float | 8 | degrees | | DEC (J2000) |
| brun | int | 4 | | | SDSS Run number (best version of sky) |
| brerun | int | 4 | | | SDSS Rerun number (best version of sky) |
| bcamcol | int | 4 | | | SDSS Camcol number (best version of sky) |
| bfield | int | 4 | | | SDSS Field number (best version of sky) |
| bobj | int | 4 | | | SDSS object number (best version of sky) |
| zbsubclass | varchar | 64 | | | SpecBS subclass (type of star) |
| zbelodiesptype | varchar | 64 | | | SpecBS ELODIE spectral type (type of best match template star) |
| zbclass | varchar | 64 | | | SpecBS class (STAR, GALAXY, QSO) |
| zbrchi2 | real | 4 | | | SpecBS rchi2 reduced chi-square per dof |
| zbdof | real | 4 | | | SpecBS degrees of freedom measure for best fit template |
| zbvdisp | real | 4 | km/s | | SpecBS Velocity dispersion (for galaxies) |
| zbvdisperr | real | 4 | km/s | | SpecBS error in Velocity disp |
| zbzwarning | real | 4 | | | SpecBS warning flag |
| spec_cln | int | 4 | | | Spectro1d(Chicago) class 1= star, 2 = Galaxy, 3,4 = QSO, 6= redstar |
| spz | real | 4 | | | Spectro1d(Chicago) redshift (Legacy primary objects hand inspected) |
| spzerr | real | 4 | | | Spectro1d(Chicago) redhisft error |
| vel_dis | real | 4 | km/s | | Spectro1d(Chicago) Velocity dispersion (for galaxies) |
| vel_disperr | real | 4 | km/s | | Spectro1d(Chicago) Vel disp error |
| spz_conf | real | 4 | | | Spectro1d(Chicago) redshift confidence |
| spz_status | int | 4 | | | Spectro1d(Chicago) redshift status |
| spz_warning | int | 4 | | | Spectro1d(Chicago) redshift warning |
| eclass | real | 4 | | | Spectro1d(Chicago) galaxy Principal component class |
| ecoeff1 | real | 4 | | | Galaxy Prin. comp. 1 (for galaxies) |
| ecoeff2 | real | 4 | | | Galaxy Prin. comp. 2 (for galaxies) |
| ecoeff3 | real | 4 | | | Galaxy Prin. comp. 3 (for galaxies) |
| ecoeff4 | real | 4 | | | Galaxy Prin. comp. 4 (for galaxies) |
| ecoeff5 | real | 4 | | | Galaxy Prin. comp. 5 (for galaxies) |