# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophies
# Description of the table:        Spectra (series truncated to the first observation)
# Object:                          HD015028
# Order by:                        ra,seq
# Description of each column
# $link[objname]: ------ Designation of the object
# $j2000: -------------- J2000 coordinates
# $link['S']: ---------- Link to Simbad database
# $link['E']: ---------- <NA>
# seq: ----------------- Sequence number
# $link[slen]: --------- Length of the series
# date: ---------------- Calendar date of observation
# mode: ---------------- Observation mode: High resolution or High efficiency
# fiber_b: ------------- Use of the second fiber (DARK, WAVE or SKY)
# exptime: ------------- exposure time
# sn26: ---------------- Signal/noise in order 26
# $link[view_spec]: ---- <NA>
# $link[view_head]: ---- <NA>
# $link[get_spec]: ----- <NA>
# $link[get_e2ds]: ----- <NA>
# $link[customize]: ---- <NA>
# $link[search_ccf]: --- <NA>
#-------------------- ---------------- --- --- --------------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ----------
#$link[objname]       $j2000           $li $li seq     $lin date            mode            fibe exptim sn2 $link[vie $link[vie $link[ge $link[ge $link[cus $link[sear
#                                      nk[ nk[         k[sl                                 r_b  e      6   w_spec]   w_head]   t_spec]  t_e2ds]  tomize]   ch_ccf]   
#                                      'S' 'E'         en]                                                                                                            
#                                      ]   ]                                                                                                                          
#-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ----------
HD015028              J022547.1+201648 S   E    171620    1 2006-11-03 HR WAVE  500.0  79 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E    171650    1 2006-11-03 HR WAVE  500.0  70 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E    173090    1 2006-11-05 HR WAVE  500.0 105 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E    173220    1 2006-11-05 HR WAVE  400.0 106 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E    177520    1 2006-11-07 HR WAVE  300.0 101 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E    499440    1 2007-10-28 HR DARK  300.0  82 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E    877930    1 2009-10-23 HR DARK  480.0  70 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E    879730    1 2009-10-25 HR DARK  300.0  90 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   2033140    1 2016-09-23 HR SKY   120.0  39 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   2328440    1 2017-10-06 HR SKY  1800.0  52 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   2381380    1 2017-11-20 HR SKY   180.0  32 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   2381390    1 2017-11-20 HR SKY   600.0  51 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   2614590    1 2018-10-02 HR SKY   180.0  54 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   2650080    1 2018-12-08 HR SKY   180.0  66 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   2653480    1 2018-12-12 HR SKY  1200.0  51 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   2858030    1 2020-02-05 HR SKY  1300.0   5 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   2858760    1 2020-02-06 HR SKY  1000.0  62 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   2946950    1 2020-10-08 HR SKY   607.0  51 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   3280390    1 2022-09-16 HR SKY   607.0  50 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   3294560    1 2022-10-17 HR SKY   180.0  34 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   3327560    1 2022-12-22 HR SKY  1111.0  51 view_spec view_head get_spec get_e2ds customize search_CCF
HD015028              J022547.1+201648 S   E   3439850    1 2023-08-30 HR SKY  1800.0  38 not public                                                 
HD015028              J022547.1+201648 S   E   3445840    1 2023-09-10 HR SKY   180.0  57 not public                                                 
#-- end of data table ----------------------------------------------------------
# 23 lines were successfully retrieved