# 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: HD047127 # 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] # ] ] #-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- HD047127 J063733.9+121051 S E 158310 1 2006-10-13 HR WAVE 600.0 189 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 158350 1 2006-10-13 HR WAVE 600.0 221 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 159590 1 2006-10-14 HR WAVE 750.0 70 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 164070 1 2006-10-17 HR WAVE 800.0 147 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 164080 1 2006-10-17 HR WAVE 600.0 77 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 178600 3 2006-11-08 HR WAVE 400.0 143 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 196330 1 2006-12-09 HR WAVE 300.0 105 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 198300 1 2006-12-11 HR WAVE 900.0 247 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 202140 5 2006-12-16 HR WAVE 120.0 86 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 204090 5 2006-12-18 HR WAVE 120.0 38 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 205130 1 2006-12-19 HR WAVE 120.0 78 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 205140 2 2006-12-19 HR WAVE 350.0 112 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 206370 2 2006-12-20 HR WAVE 600.0 181 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 208080 4 2006-12-21 HR WAVE 300.0 82 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 210310 1 2006-12-23 HR WAVE 1200.0 303 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 211560 2 2006-12-26 HR WAVE 600.0 175 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 212810 2 2006-12-27 HR WAVE 600.0 218 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 215010 2 2006-12-28 HR WAVE 600.0 160 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 215080 10 2006-12-28 HR WAVE 60.0 46 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 311560 1 2007-02-16 HR WAVE 900.0 212 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 501980 2 2007-11-01 HE SKY 120.0 92 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 503140 1 2007-11-02 HE SKY 120.0 144 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 504020 2 2007-11-03 HE SKY 120.0 126 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 512910 1 2007-11-16 HR WAVE 900.0 164 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 514580 1 2007-11-18 HR WAVE 900.0 105 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 518170 1 2007-11-26 HR WAVE 900.0 129 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1487830 1 2012-11-19 HR WAVE 800.0 206 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1488670 1 2012-11-20 HR WAVE 800.0 235 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1495170 1 2012-11-30 HR WAVE 800.0 157 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1498100 1 2012-12-05 HR WAVE 800.0 194 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1498970 1 2012-12-06 HR WAVE 900.0 56 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1511590 1 2012-12-23 HR WAVE 800.0 215 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1512360 1 2012-12-26 HR WAVE 1000.0 153 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1513400 1 2012-12-28 HR WAVE 800.0 160 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1513970 1 2012-12-29 HR WAVE 800.0 193 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1514650 1 2012-12-30 HR WAVE 800.0 164 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1516240 1 2013-01-03 HR WAVE 800.0 203 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1522870 1 2013-01-20 HR WAVE 1200.0 157 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1524390 1 2013-01-23 HR WAVE 800.0 155 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1525650 1 2013-01-25 HR WAVE 800.0 146 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1526490 1 2013-01-26 HR WAVE 900.0 183 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1530180 1 2013-02-02 HR WAVE 1200.0 73 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1531560 1 2013-02-04 HR WAVE 900.0 124 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1571020 1 2013-02-20 HR WAVE 800.0 188 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1573840 1 2013-02-26 HR WAVE 800.0 219 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1577350 1 2013-03-04 HR WAVE 800.0 128 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1582020 1 2013-03-18 HR WAVE 900.0 148 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1582560 1 2013-03-19 HR WAVE 900.0 212 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1582870 1 2013-03-20 HR WAVE 800.0 176 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1583360 1 2013-03-21 HR WAVE 800.0 179 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1583910 1 2013-03-22 HR WAVE 800.0 157 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1585680 1 2013-03-26 HR WAVE 800.0 130 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1678740 1 2013-10-17 HR WAVE 600.0 159 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1699380 1 2013-11-27 HR WAVE 800.0 132 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1701010 1 2013-11-30 HR WAVE 800.0 171 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1702300 1 2013-12-02 HR WAVE 800.0 189 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1702900 1 2013-12-03 HR WAVE 800.0 178 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1706990 1 2013-12-13 HR WAVE 800.0 181 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1707810 1 2013-12-14 HR WAVE 800.0 130 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1708540 1 2013-12-15 HR WAVE 600.0 158 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1709230 1 2013-12-16 HR WAVE 800.0 212 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1710040 1 2013-12-22 HR WAVE 800.0 59 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1711370 1 2013-12-28 HR WAVE 800.0 133 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1711930 1 2013-12-29 HR WAVE 800.0 130 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1712470 1 2013-12-30 HR WAVE 800.0 177 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1714270 1 2014-01-06 HR WAVE 800.0 155 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1715140 1 2014-01-08 HR WAVE 800.0 85 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1715700 1 2014-01-09 HR WAVE 800.0 150 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1719730 1 2014-01-20 HR WAVE 1000.0 130 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1720250 1 2014-01-21 HR WAVE 900.0 152 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1720770 1 2014-01-22 HR WAVE 800.0 99 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1721260 1 2014-01-23 HR WAVE 800.0 54 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1721720 1 2014-01-24 HR WAVE 1100.0 119 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1722260 1 2014-01-25 HR WAVE 1000.0 100 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1723110 1 2014-01-27 HR WAVE 1100.0 154 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1723600 1 2014-01-28 HR WAVE 1000.0 177 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1725530 1 2014-02-05 HR WAVE 800.0 114 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1785100 1 2015-03-05 HR WAVE 1200.0 154 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 1943120 1 2016-03-21 HR WAVE 900.0 192 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 2041110 1 2016-10-06 HR WAVE 900.0 153 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 2081640 1 2017-01-03 HR WAVE 900.0 166 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 2395460 1 2017-12-08 HR FP 600.0 108 view_spec view_head get_spec get_e2ds customize search_CCF HD047127 J063733.9+121051 S E 2435970 1 2018-01-22 HR FP 900.0 160 view_spec view_head get_spec get_e2ds customize search_CCF #-- end of data table ---------------------------------------------------------- # 83 lines were successfully retrieved