# 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: HD171067 # 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']: ---------- # 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]: ---- # $link[view_head]: ---- # $link[get_spec]: ----- # $link[get_e2ds]: ----- # $link[customize]: ---- # $link[search_ccf]: --- #-------------------- ---------------- --- --- --------------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- #$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] # ] ] #-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- HD171067 J183210.5+134412 S E 367470 1 2007-05-05 HR WAVE 600.0 53 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 374880 1 2007-05-24 HR DARK 200.0 89 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 380930 1 2007-06-04 HR WAVE 900.0 9 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 400480 1 2007-07-12 HR WAVE 739.0 214 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 401260 1 2007-07-13 HR WAVE 739.0 196 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 402330 1 2007-07-14 HR WAVE 799.0 223 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 402740 1 2007-07-15 HR WAVE 754.0 196 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 403550 1 2007-07-16 HR WAVE 769.0 180 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 404520 1 2007-07-17 HR WAVE 900.0 200 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 405340 1 2007-07-18 HR WAVE 900.0 226 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1154060 1 2011-05-08 HR DARK 300.0 107 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1361390 1 2012-05-02 HR WAVE 800.0 145 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1362530 1 2012-05-05 HR WAVE 900.0 134 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1363000 1 2012-05-06 HR WAVE 900.0 149 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1363510 1 2012-05-07 HR WAVE 900.0 172 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1364370 1 2012-05-08 HR WAVE 800.0 183 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1365200 1 2012-05-10 HR WAVE 800.0 189 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1365690 1 2012-05-11 HR WAVE 800.0 162 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1366170 1 2012-05-12 HR WAVE 800.0 77 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1366180 1 2012-05-12 HR WAVE 800.0 73 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1366670 1 2012-05-13 HR WAVE 800.0 100 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1367200 1 2012-05-14 HR WAVE 800.0 119 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1601981 1 2013-06-23 HR WAVE 1200.0 100 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1602811 1 2013-06-25 HR WAVE 800.0 95 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1603220 1 2013-06-26 HR WAVE 800.0 108 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1603600 1 2013-06-27 HR WAVE 800.0 97 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1607300 1 2013-05-20 HR WAVE 800.0 122 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1608740 1 2013-05-23 HR WAVE 1200.0 104 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1609560 1 2013-05-25 HR WAVE 1200.0 108 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1611580 1 2013-05-29 HR WAVE 800.0 120 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1615490 1 2013-06-07 HR WAVE 800.0 82 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1616570 1 2013-06-10 HR WAVE 900.0 142 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1619000 1 2013-06-16 HR WAVE 800.0 164 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1620570 1 2013-06-20 HR WAVE 1000.0 120 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1621500 1 2013-06-22 HR WAVE 800.0 116 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1629040 1 2013-07-12 HR WAVE 800.0 122 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1629570 1 2013-07-13 HR WAVE 800.0 121 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1629940 1 2013-07-14 HR WAVE 800.0 137 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1630400 1 2013-07-15 HR WAVE 800.0 166 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1630840 1 2013-07-16 HR WAVE 800.0 142 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1633870 1 2013-07-21 HR WAVE 800.0 158 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1634440 1 2013-07-22 HR WAVE 1000.0 117 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1635590 1 2013-07-24 HR WAVE 900.0 146 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1635980 1 2013-07-25 HR WAVE 800.0 138 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1636740 1 2013-07-27 HR WAVE 1000.0 102 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1644160 1 2013-08-12 HR WAVE 800.0 139 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1645050 1 2013-08-14 HR WAVE 800.0 157 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1646040 1 2013-08-16 HR WAVE 800.0 151 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1647000 1 2013-08-18 HR WAVE 800.0 138 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1653641 1 2014-06-25 HR WAVE 800.0 103 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1654120 1 2014-06-26 HR WAVE 900.0 130 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1654300 1 2014-06-26 HR WAVE 800.0 114 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1654681 1 2014-06-27 HR WAVE 900.0 105 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1656000 1 2014-06-30 HR WAVE 900.0 95 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1656141 1 2014-06-30 HR WAVE 900.0 149 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1656780 1 2014-07-02 HR WAVE 800.0 114 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1656920 1 2014-07-02 HR WAVE 800.0 143 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1659810 1 2014-07-08 HR WAVE 800.0 90 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1659931 1 2014-07-08 HR WAVE 800.0 77 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1660740 1 2014-07-09 HR WAVE 800.0 77 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1661101 1 2014-07-10 HR WAVE 1200.0 89 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1661211 1 2014-07-10 HR WAVE 900.0 129 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1661691 1 2014-07-11 HR WAVE 900.0 119 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1662131 1 2014-07-12 HR WAVE 800.0 102 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1662311 1 2014-07-12 HR WAVE 800.0 129 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1663030 1 2014-07-14 HR WAVE 800.0 125 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1663190 1 2014-07-14 HR WAVE 800.0 129 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1667851 1 2014-07-20 HR WAVE 1200.0 115 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1668461 1 2014-07-21 HR WAVE 800.0 68 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1669221 1 2014-07-22 HR WAVE 900.0 97 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1669351 1 2014-07-22 HR WAVE 600.0 136 view_spec view_head get_spec get_e2ds customize search_CCF HD171067 J183210.5+134412 S E 1739490 1 2014-03-03 HE SKY 4000.0 125 view_spec view_head get_spec get_e2ds customize search_CCF #-- end of data table ---------------------------------------------------------- # 72 lines were successfully retrieved