# 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) # SQL constraint on fields: get_spec is not null # Order by: date desc # 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] # ] ] #-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- HD189733 J200043.8+224239 S E 3414740 1 2023-07-14 HR FP 360.0 89 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3414170 1 2023-07-13 HR FP 360.0 78 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3413630 1 2023-07-12 HR FP 360.0 71 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3412750 1 2023-07-11 HR FP 360.0 50 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3412130 1 2023-07-10 HR FP 360.0 93 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3411610 1 2023-07-09 HR FP 360.0 75 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3410860 1 2023-07-08 HR FP 360.0 88 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3409240 1 2023-07-05 HR FP 360.0 65 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3408580 1 2023-07-04 HR FP 360.0 91 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3408010 1 2023-07-03 HR FP 360.0 75 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3407400 1 2023-07-02 HR FP 360.0 66 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3406790 1 2023-07-01 HR FP 360.0 83 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3406290 1 2023-06-30 HR FP 360.0 53 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3405340 1 2023-06-28 HR FP 360.0 67 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3404840 1 2023-06-25 HR FP 360.0 67 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3404190 1 2023-06-24 HR FP 360.0 83 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3403370 1 2023-06-23 HR FP 360.0 56 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3367530 1 2023-03-21 HR LAMP 6.0 3 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3367010 1 2023-03-21 HR LAMP 15.0 4 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3367610 1 2023-03-21 HR LAMP 6.0 4 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3367340 1 2023-03-21 HR LAMP 12.0 6 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3366950 1 2023-03-21 HR LAMP 15.0 4 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3366990 1 2023-03-21 HR LAMP 15.0 4 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3366970 1 2023-03-21 HR LAMP 15.0 4 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3367250 1 2023-03-21 HR LAMP 15.0 4 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3367430 1 2023-03-21 HR LAMP 6.0 4 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3367330 1 2023-03-21 HR LAMP 15.0 1 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3367170 1 2023-03-21 HR LAMP 15.0 3 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3367410 1 2023-03-21 HR LAMP 6.0 4 view_spec view_head get_spec get_e2ds customize search_CCF  S E 3366930 1 2023-03-21 HR LAMP 15.0 4 view_spec view_head get_spec get_e2ds customize search_CCF #-- end of data table ---------------------------------------------------------- # 30 lines were successfully retrieved