# 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:                          HD206860
# 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]                                                                                                            
#                                      ]   ]                                                                                                                          
#-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ----------
HD206860              J214431.3+144619 S   E    498640    1 2007-10-27 HR DARK  300.0 226 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1631540    2 2013-07-18 HR WAVE  450.0 185 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1632370    2 2013-07-19 HR WAVE  500.0 161 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1633440    2 2013-07-20 HR WAVE  400.0 194 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1665180    2 2013-09-25 HR WAVE  450.0 200 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1666410    2 2013-09-27 HR WAVE  450.0 217 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1668520    2 2013-09-30 HR WAVE  450.0 184 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1674850    2 2014-08-09 HR WAVE  500.0 135 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1675610    2 2014-08-10 HR WAVE  550.0 169 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1678270    2 2014-08-13 HR WAVE  700.0 162 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1688470    2 2013-11-07 HR WAVE  350.0 182 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1689470    2 2013-11-09 HR WAVE  900.0  54 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1690040    2 2013-11-10 HR WAVE  800.0 125 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1690790    2 2013-11-11 HR WAVE  450.0 142 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1692581    2 2014-09-11 HR WAVE  600.0 136 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1712170    2 2014-10-13 HR WAVE  550.0 225 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1846970    2 2015-08-02 HR WAVE  500.0 217 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1873240    2 2015-09-30 HR WAVE  350.0 122 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1977370    2 2016-05-26 HR WAVE  300.0  83 view_spec view_head get_spec get_e2ds customize search_CCF
HD206860              J214431.3+144619 S   E   1978080    2 2016-05-27 HR WAVE  240.0 126 view_spec view_head get_spec get_e2ds customize search_CCF
#-- end of data table ----------------------------------------------------------
# 20 lines were successfully retrieved