# 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: GJ0047 # 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] # ] ] #-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- GJ0047 J010120.0+612156 S E 2675270 1 2019-01-25 HE SKY 3000.0 68 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 454460 1 2007-09-23 HR SKY 1800.0 53 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 459050 1 2007-10-01 HR SKY 1800.0 54 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 723530 1 2009-01-03 HR SKY 1800.0 41 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 818790 1 2009-07-28 HR SKY 1800.0 48 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 930610 1 2011-09-27 HR SKY 1800.0 43 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 934520 1 2011-09-30 HR SKY 1800.0 46 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 935320 1 2011-10-01 HR SKY 1800.0 47 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 936830 1 2011-10-03 HR SKY 1800.0 46 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 940520 1 2011-10-08 HR SKY 1800.0 20 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1017330 1 2010-08-30 HR SKY 1800.0 33 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1019970 1 2010-09-03 HR SKY 1800.0 54 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1233900 1 2011-08-30 HR SKY 1800.0 43 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1235290 1 2011-09-01 HR SKY 1800.0 26 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1236570 1 2011-09-04 HR SKY 1800.0 40 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1240130 1 2011-09-08 HR SKY 1800.0 36 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1241260 1 2011-09-10 HR SKY 1800.0 47 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1247960 1 2011-09-20 HR SKY 1800.0 43 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1249290 1 2011-09-22 HR SKY 1800.0 50 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1251980 1 2011-10-21 HR SKY 1800.0 29 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1252510 1 2011-10-22 HR SKY 1800.0 41 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1450030 1 2012-09-07 HR SKY 1800.0 54 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1636060 1 2013-07-25 HR SKY 1800.0 44 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1636410 1 2013-07-26 HR SKY 1800.0 46 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1644340 1 2013-08-12 HR SKY 1800.0 49 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1645260 1 2013-08-14 HR SKY 1800.0 40 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1646260 1 2013-08-16 HR SKY 1800.0 41 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1646750 1 2013-08-17 HR SKY 1800.0 45 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1647760 1 2013-08-19 HR SKY 1800.0 28 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1652200 1 2013-08-28 HR SKY 1800.0 40 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1653150 1 2013-08-30 HR SKY 1800.0 46 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1653660 1 2013-08-31 HR SKY 1800.0 43 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1654110 1 2013-09-01 HR SKY 1800.0 25 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1654690 1 2013-09-02 HR SKY 1800.0 42 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1714900 1 2014-01-08 HR SKY 1800.0 38 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1716220 1 2014-01-10 HR SKY 1800.0 47 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 1716580 1 2014-01-11 HR SKY 1800.0 24 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 2251670 1 2017-07-29 HR SKY 1800.0 37 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 2252830 1 2017-07-31 HR SKY 1800.0 29 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 2259900 1 2017-08-04 HR SKY 1800.0 47 view_spec view_head get_spec get_e2ds customize search_CCF GJ0047 J010120.4+612157 S E 2265100 1 2017-08-13 HR SKY 1800.0 54 view_spec view_head get_spec get_e2ds customize search_CCF #-- end of data table ---------------------------------------------------------- # 41 lines were successfully retrieved