Choose a database in the left panel then select the table you want!
Table: sdss_dr8.galspecindx
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| best_model_z | Metallicity of best fitting (min chisq) model Z = 0.004 / 0.017 / 0.050 (0.2 1.0, 2.5 x solar) | REAL |
| bh_cai | Restframe index measurement | REAL |
| bh_cai_err | Error on index measurement | REAL |
| bh_cai_model | Index of best fit model spectrum | REAL |
| bh_cai_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| bh_cai_sub_err | Error in the above index measurement | REAL |
| bh_cnb | Restframe index measurement | REAL |
| bh_cnb_err | Error on index measurement | REAL |
| bh_cnb_model | Index of best fit model spectrum | REAL |
| bh_cnb_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| bh_cnb_sub_err | Error in the above index measurement | REAL |
| bh_fc | Restframe index measurement | REAL |
| bh_fc_err | Error on index measurement | REAL |
| bh_fc_model | Index of best fit model spectrum | REAL |
| bh_fc_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| bh_fc_sub_err | Error in the above index measurement | REAL |
| bh_g | Restframe index measurement | REAL |
| bh_g_err | Error on index measurement | REAL |
| bh_g_model | Index of best fit model spectrum | REAL |
| bh_g_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| bh_g_sub_err | Error in the above index measurement | REAL |
| bh_hb | Restframe index measurement | REAL |
| bh_hb_err | Error on index measurement | REAL |
| bh_hb_model | Index of best fit model spectrum | REAL |
| bh_hb_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| bh_hb_sub_err | Error in the above index measurement | REAL |
| bh_hk | Restframe index measurement | REAL |
| bh_hk_err | Error on index measurement | REAL |
| bh_hk_model | Index of best fit model spectrum | REAL |
| bh_hk_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| bh_hk_sub_err | Error in the above index measurement | REAL |
| bh_mgg | Restframe index measurement | REAL |
| bh_mgg_err | Error on index measurement | REAL |
| bh_mgg_model | Index of best fit model spectrum | REAL |
| bh_mgg_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| bh_mgg_sub_err | Error in the above index measurement | REAL |
| bh_mh | Restframe index measurement | REAL |
| bh_mh_err | Error on index measurement | REAL |
| bh_mh_model | Index of best fit model spectrum | REAL |
| bh_mh_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| bh_mh_sub_err | Error in the above index measurement | REAL |
| bh_nad | Restframe index measurement | REAL |
| bh_nad_err | Error on index measurement | REAL |
| bh_nad_model | Index of best fit model spectrum | REAL |
| bh_nad_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| bh_nad_sub_err | Error in the above index measurement | REAL |
| d4000 | 4000AA break, Bruzual (1983) definition | REAL |
| d4000_blue | The flux in the blue window of the Bruzual (1983) definition of D4000 | REAL |
| d4000_err | Uncertainty estimate for 4000AA break, Bruzual (1983) definition | REAL |
| d4000_model | 4000AA break, Bruzual (1983) definition measured off best-fit CB08 model | REAL |
| d4000_n | 4000AA break, Balogh et al (1999) definition | REAL |
| d4000_n_blue | The flux in the blue window of the Balogh et al (1999) definition of D4000 | REAL |
| d4000_n_err | Uncertainty estimate for 4000AA break, Balogh et al (1999) definition | REAL |
| d4000_n_model | 4000AA break, Balogh et al (1999) definition measured off best-fit CB08 model | REAL |
| d4000_n_red | The flux in the red window of the Balogh et al (1999) definition of D4000 | REAL |
| d4000_n_sub | 4000AA break, Balogh et al (1999) definition after correction for emission lines | REAL |
| d4000_n_sub_blue | The flux in the blue window of the Balogh et al (1999)q definition of D4000 after subtraction of emission lines | REAL |
| d4000_n_sub_err | Uncertainty estimate for 4000AA break, Balogh et al (1999) definition after correction for emission lines | REAL |
| d4000_n_sub_red | The flux in the red window of the Balogh et al (1999) definition of D4000 after subtraction of emission lines | REAL |
| d4000_red | The flux in the red window of the Bruzual (1983) definition of D4000 | REAL |
| d4000_sub | 4000AA break, Bruzual (1983) definition after correction for emission lines | REAL |
| d4000_sub_blue | The flux in the blue window of the Bruzual (1983) definition of D4000 after subtraction of emission lines | REAL |
| d4000_sub_err | Uncertainty estimate for 4000AA break, Bruzual (1983) definition after correction for emission lines | REAL |
| d4000_sub_red | The flux in the red window of the Bruzual (1983) definition of D4000 after subtraction of emission lines | REAL |
| dtt_caii8498 | Restframe index measurement | REAL |
| dtt_caii8498_err | Error on index measurement | REAL |
| dtt_caii8498_model | Index of best fit model spectrum | REAL |
| dtt_caii8498_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| dtt_caii8498_sub_err | Error in the above index measurement | REAL |
| dtt_caii8542 | Restframe index measurement | REAL |
| dtt_caii8542_err | Error on index measurement | REAL |
| dtt_caii8542_model | Index of best fit model spectrum | REAL |
| dtt_caii8542_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| dtt_caii8542_sub_err | Error in the above index measurement | REAL |
| dtt_caii8662 | Restframe index measurement | REAL |
| dtt_caii8662_err | Error on index measurement | REAL |
| dtt_caii8662_model | Index of best fit model spectrum | REAL |
| dtt_caii8662_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| dtt_caii8662_sub_err | Error in the above index measurement | REAL |
| dtt_mgi8807 | Restframe index measurement | REAL |
| dtt_mgi8807_err | Error on index measurement | REAL |
| dtt_mgi8807_model | Index of best fit model spectrum | REAL |
| dtt_mgi8807_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| dtt_mgi8807_sub_err | Error in the above index measurement | REAL |
| fiberid | Fiber number (1 - 640) | SMALLINT |
| lick_c4668 | Restframe index measurement | REAL |
| lick_c4668_err | Error on index measurement | REAL |
| lick_c4668_model | Index of best fit model spectrum | REAL |
| lick_c4668_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_c4668_sub_err | Error in the above index measurement | REAL |
| lick_ca4227 | Restframe index measurement | REAL |
| lick_ca4227_err | Error on index measurement | REAL |
| lick_ca4227_model | Index of best fit model spectrum | REAL |
| lick_ca4227_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_ca4227_sub_err | Error in the above index measurement | REAL |
| lick_ca4455 | Restframe index measurement | REAL |
| lick_ca4455_err | Error on index measurement | REAL |
| lick_ca4455_model | Index of best fit model spectrum | REAL |
| lick_ca4455_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_ca4455_sub_err | Error in the above index measurement | REAL |
| lick_cn1 | Restframe index measurement | REAL |
| lick_cn1_err | Error on index measurement | REAL |
| lick_cn1_model | Index of best fit model spectrum | REAL |
| lick_cn1_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_cn1_sub_err | Error in the above index measurement | REAL |
| lick_cn2 | Restframe index measurement | REAL |
| lick_cn2_err | Error on index measurement | REAL |
| lick_cn2_model | Index of best fit model spectrum | REAL |
| lick_cn2_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_cn2_sub_err | Error in the above index measurement | REAL |
| lick_fe4383 | Restframe index measurement | REAL |
| lick_fe4383_err | Error on index measurement | REAL |
| lick_fe4383_model | Index of best fit model spectrum | REAL |
| lick_fe4383_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_fe4383_sub_err | Error in the above index measurement | REAL |
| lick_fe4531 | Restframe index measurement | REAL |
| lick_fe4531_err | Error on index measurement | REAL |
| lick_fe4531_model | Index of best fit model spectrum | REAL |
| lick_fe4531_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_fe4531_sub_err | Error in the above index measurement | REAL |
| lick_fe5015 | Restframe index measurement | REAL |
| lick_fe5015_err | Error on index measurement | REAL |
| lick_fe5015_model | Index of best fit model spectrum | REAL |
| lick_fe5015_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_fe5015_sub_err | Error in the above index measurement | REAL |
| lick_fe5270 | Restframe index measurement | REAL |
| lick_fe5270_err | Error on index measurement | REAL |
| lick_fe5270_model | Index of best fit model spectrum | REAL |
| lick_fe5270_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_fe5270_sub_err | Error in the above index measurement | REAL |
| lick_fe5335 | Restframe index measurement | REAL |
| lick_fe5335_err | Error on index measurement | REAL |
| lick_fe5335_model | Index of best fit model spectrum | REAL |
| lick_fe5335_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_fe5335_sub_err | Error in the above index measurement | REAL |
| lick_fe5406 | Restframe index measurement | REAL |
| lick_fe5406_err | Error on index measurement | REAL |
| lick_fe5406_model | Index of best fit model spectrum | REAL |
| lick_fe5406_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_fe5406_sub_err | Error in the above index measurement | REAL |
| lick_fe5709 | Restframe index measurement | REAL |
| lick_fe5709_err | Error on index measurement | REAL |
| lick_fe5709_model | Index of best fit model spectrum | REAL |
| lick_fe5709_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_fe5709_sub_err | Error in the above index measurement | REAL |
| lick_fe5782 | Restframe index measurement | REAL |
| lick_fe5782_err | Error on index measurement | REAL |
| lick_fe5782_model | Index of best fit model spectrum | REAL |
| lick_fe5782_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_fe5782_sub_err | Error in the above index measurement | REAL |
| lick_g4300 | Restframe index measurement | REAL |
| lick_g4300_err | Error on index measurement | REAL |
| lick_g4300_model | Index of best fit model spectrum | REAL |
| lick_g4300_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_g4300_sub_err | Error in the above index measurement | REAL |
| lick_hb | Restframe index measurement | REAL |
| lick_hb_err | Error on index measurement | REAL |
| lick_hb_model | Index of best fit model spectrum | REAL |
| lick_hb_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_hb_sub_err | Error in the above index measurement | REAL |
| lick_hd_a | Restframe index measurement | REAL |
| lick_hd_a_err | Error on index measurement | REAL |
| lick_hd_a_model | Index of best fit model spectrum | REAL |
| lick_hd_a_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_hd_a_sub_err | Error in the above index measurement | REAL |
| lick_hd_f | Restframe index measurement | REAL |
| lick_hd_f_err | Error on index measurement | REAL |
| lick_hd_f_model | Index of best fit model spectrum | REAL |
| lick_hd_f_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_hd_f_sub_err | Error in the above index measurement | REAL |
| lick_hg_a | Restframe index measurement | REAL |
| lick_hg_a_err | Error on index measurement | REAL |
| lick_hg_a_model | Index of best fit model spectrum | REAL |
| lick_hg_a_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_hg_a_sub_err | Error in the above index measurement | REAL |
| lick_hg_f | Restframe index measurement | REAL |
| lick_hg_f_err | Error on index measurement | REAL |
| lick_hg_f_model | Index of best fit model spectrum | REAL |
| lick_hg_f_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_hg_f_sub_err | Error in the above index measurement | REAL |
| lick_mg1 | Restframe index measurement | REAL |
| lick_mg1_err | Error on index measurement | REAL |
| lick_mg1_model | Index of best fit model spectrum | REAL |
| lick_mg1_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_mg1_sub_err | Error in the above index measurement | REAL |
| lick_mg2 | Restframe index measurement | REAL |
| lick_mg2_err | Error on index measurement | REAL |
| lick_mg2_model | Index of best fit model spectrum | REAL |
| lick_mg2_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_mg2_sub_err | Error in the above index measurement | REAL |
| lick_mgb | Restframe index measurement | REAL |
| lick_mgb_err | Error on index measurement | REAL |
| lick_mgb_model | Index of best fit model spectrum | REAL |
| lick_mgb_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_mgb_sub_err | Error in the above index measurement | REAL |
| lick_nad | Restframe index measurement | REAL |
| lick_nad_err | Error on index measurement | REAL |
| lick_nad_model | Index of best fit model spectrum | REAL |
| lick_nad_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_nad_sub_err | Error in the above index measurement | REAL |
| lick_tio1 | Restframe index measurement | REAL |
| lick_tio1_err | Error on index measurement | REAL |
| lick_tio1_model | Index of best fit model spectrum | REAL |
| lick_tio1_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_tio1_sub_err | Error in the above index measurement | REAL |
| lick_tio2 | Restframe index measurement | REAL |
| lick_tio2_err | Error on index measurement | REAL |
| lick_tio2_model | Index of best fit model spectrum | REAL |
| lick_tio2_sub | Restframe index measurement on the data after subtracting all 3-sigma emission lines | REAL |
| lick_tio2_sub_err | Error in the above index measurement | REAL |
| mjd | Modified Julian Date of plate observation | INTEGER |
| model_chisq | Reduced chi-squared of best fit model (best of 4 Zs) | REAL |
| model_chisq_040 | The chi^2 of the best fit Z=0.004 CB08 model | REAL |
| model_chisq_080 | The chi^2 of the best fit Z=0.008 CB08 model | REAL |
| model_chisq_170 | The chi^2 of the best fit Z=0.017 CB08 model | REAL |
| model_chisq_400 | The chi^2 of the best fit Z=0.04 CB08 model | REAL |
| model_coef_040_1 | The scaling coefficients of the best fit Z=0.004 CB08 model | REAL |
| model_coef_040_10 | The scaling coefficients of the best fit Z=0.004 CB08 model | REAL |
| model_coef_040_2 | The scaling coefficients of the best fit Z=0.004 CB08 model | REAL |
| model_coef_040_3 | The scaling coefficients of the best fit Z=0.004 CB08 model | REAL |
| model_coef_040_4 | The scaling coefficients of the best fit Z=0.004 CB08 model | REAL |
| model_coef_040_5 | The scaling coefficients of the best fit Z=0.004 CB08 model | REAL |
| model_coef_040_6 | The scaling coefficients of the best fit Z=0.004 CB08 model | REAL |
| model_coef_040_7 | The scaling coefficients of the best fit Z=0.004 CB08 model | REAL |
| model_coef_040_8 | The scaling coefficients of the best fit Z=0.004 CB08 model | REAL |
| model_coef_040_9 | The scaling coefficients of the best fit Z=0.004 CB08 model | REAL |
| model_coef_080_1 | The scaling coefficients of the best fit Z=0.008 CB08 model | REAL |
| model_coef_080_10 | The scaling coefficients of the best fit Z=0.008 CB08 model | REAL |
| model_coef_080_2 | The scaling coefficients of the best fit Z=0.008 CB08 model | REAL |
| model_coef_080_3 | The scaling coefficients of the best fit Z=0.008 CB08 model | REAL |
| model_coef_080_4 | The scaling coefficients of the best fit Z=0.008 CB08 model | REAL |
| model_coef_080_5 | The scaling coefficients of the best fit Z=0.008 CB08 model | REAL |
| model_coef_080_6 | The scaling coefficients of the best fit Z=0.008 CB08 model | REAL |
| model_coef_080_7 | The scaling coefficients of the best fit Z=0.008 CB08 model | REAL |
| model_coef_080_8 | The scaling coefficients of the best fit Z=0.008 CB08 model | REAL |
| model_coef_080_9 | The scaling coefficients of the best fit Z=0.008 CB08 model | REAL |
| model_coef_1 | Coeficients of best fit model (best of 4 Zs) | REAL |
| model_coef_10 | Coeficients of best fit model (best of 4 Zs) | REAL |
| model_coef_170_1 | The scaling coefficients of the best fit Z=0.017 CB08 model | REAL |
| model_coef_170_10 | The scaling coefficients of the best fit Z=0.017 CB08 model | REAL |
| model_coef_170_2 | The scaling coefficients of the best fit Z=0.017 CB08 model | REAL |
| model_coef_170_3 | The scaling coefficients of the best fit Z=0.017 CB08 model | REAL |
| model_coef_170_4 | The scaling coefficients of the best fit Z=0.017 CB08 model | REAL |
| model_coef_170_5 | The scaling coefficients of the best fit Z=0.017 CB08 model | REAL |
| model_coef_170_6 | The scaling coefficients of the best fit Z=0.017 CB08 model | REAL |
| model_coef_170_7 | The scaling coefficients of the best fit Z=0.017 CB08 model | REAL |
| model_coef_170_8 | The scaling coefficients of the best fit Z=0.017 CB08 model | REAL |
| model_coef_170_9 | The scaling coefficients of the best fit Z=0.017 CB08 model | REAL |
| model_coef_2 | Coeficients of best fit model (best of 4 Zs) | REAL |
| model_coef_3 | Coeficients of best fit model (best of 4 Zs) | REAL |
| model_coef_4 | Coeficients of best fit model (best of 4 Zs) | REAL |
| model_coef_400_1 | The scaling coefficients of the best fit Z=0.04 CB08 model | REAL |
| model_coef_400_10 | The scaling coefficients of the best fit Z=0.04 CB08 model | REAL |
| model_coef_400_2 | The scaling coefficients of the best fit Z=0.04 CB08 model | REAL |
| model_coef_400_3 | The scaling coefficients of the best fit Z=0.04 CB08 model | REAL |
| model_coef_400_4 | The scaling coefficients of the best fit Z=0.04 CB08 model | REAL |
| model_coef_400_5 | The scaling coefficients of the best fit Z=0.04 CB08 model | REAL |
| model_coef_400_6 | The scaling coefficients of the best fit Z=0.04 CB08 model | REAL |
| model_coef_400_7 | The scaling coefficients of the best fit Z=0.04 CB08 model | REAL |
| model_coef_400_8 | The scaling coefficients of the best fit Z=0.04 CB08 model | REAL |
| model_coef_400_9 | The scaling coefficients of the best fit Z=0.04 CB08 model | REAL |
| model_coef_5 | Coeficients of best fit model (best of 4 Zs) | REAL |
| model_coef_6 | Coeficients of best fit model (best of 4 Zs) | REAL |
| model_coef_7 | Coeficients of best fit model (best of 4 Zs) | REAL |
| model_coef_8 | Coeficients of best fit model (best of 4 Zs) | REAL |
| model_coef_9 | Coeficients of best fit model (best of 4 Zs) | REAL |
| plateid | Plate number | SMALLINT |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| sdss_joinid | Unique ID based on PLATE, MJD, FIBERID for joining across data releases | BIGINT |
| specobjid | Unique ID | BIGINT |
| tauv_cont | V-band optical depth (TauV = A_V / 1.086) affecting the stars from best fit model (best of 4 Zs) | REAL |
| tauv_model_040 | Dust attenuation of the best fit Z=0.004 CB08 model | REAL |
| tauv_model_080 | Dust attenuation of the best fit Z=0.008 CB08 model | REAL |
| tauv_model_170 | Dust attenuation of the best fit Z=0.017 CB08 model | REAL |
| tauv_model_400 | Dust attenuation of the best fit Z=0.04 CB08 model | REAL |
