# 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] # ] ] #-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- HD112974 J130015.5+213316 S E 3419660 1 2023-07-25 HR SKY 216.0 34 view_spec view_head get_spec get_e2ds customize search_CCF HD142743 J155512.5+262911 S E 3419720 1 2023-07-25 HR SKY 900.0 59 view_spec view_head get_spec get_e2ds customize search_CCF HD108076 J122445.9+381908 S E 3419650 1 2023-07-25 HR SKY 180.0 22 view_spec view_head get_spec get_e2ds customize search_CCF TYC2584-0480-1 J162437.9+345723 S E 3419740 1 2023-07-25 HR SKY 900.0 15 view_spec view_head get_spec get_e2ds customize search_CCF HD105320 J120737.8+320142 S E 3419640 1 2023-07-25 HR SKY 180.0 18 view_spec view_head get_spec get_e2ds customize search_CCF HD164595 J180038.9+293419 S E 3419760 1 2023-07-25 HR FP 800.0 101 view_spec view_head get_spec get_e2ds customize search_CCF TYC3481-1306-1 J150143.2+465556 S E 3419730 1 2023-07-25 HR SKY 1800.0 26 view_spec view_head get_spec get_e2ds customize search_CCF HD124330 J141117.3+542433 S E 3419710 1 2023-07-25 HR FP 900.0 55 view_spec view_head get_spec get_e2ds customize search_CCF TYC0996-1081-1 J173618.4+095522 S E 3419700 1 2023-07-25 HE SKY 1800.0 18 view_spec view_head get_spec get_e2ds customize search_CCF TYC3073-1090-1 J171329.6+373037 S E 3419750 1 2023-07-25 HR SKY 600.0 24 view_spec view_head get_spec get_e2ds customize search_CCF HD150731 J164205.8+215130 S E 3419680 1 2023-07-25 HE SKY 1200.0 19 view_spec view_head get_spec get_e2ds customize search_CCF BD+172736 J142608.8+165500 S E 3419670 1 2023-07-25 HR SKY 1800.0 27 view_spec view_head get_spec get_e2ds customize search_CCF TYC0996-1158-1 J173238.9+104100 S E 3419690 1 2023-07-25 HE SKY 1800.0 19 view_spec view_head get_spec get_e2ds customize search_CCF HD157373 J172033.7+481119 S E 3419190 1 2023-07-24 HR SKY 1200.0 21 view_spec view_head get_spec get_e2ds customize search_CCF BD+064759B J210858.1+064318 S E 3419210 1 2023-07-24 HR DARK 1800.0 29 view_spec view_head get_spec get_e2ds customize search_CCF HD136655 J152109.4+253402 S E 3419090 1 2023-07-24 HR SKY 282.0 38 view_spec view_head get_spec get_e2ds customize search_CCF GSC3554-1147 J191618.3+514527 S E 3419280 1 2023-07-24 HE SKY 2100.0 14 view_spec view_head get_spec get_e2ds customize search_CCF HD185144 J193221.6+693940 S E 3419180 1 2023-07-24 HR FP 300.0 33 view_spec view_head get_spec get_e2ds customize search_CCF HD009939 J013725.1+251004 S E 3419310 1 2023-07-24 HR FP 300.0 38 view_spec view_head get_spec get_e2ds customize search_CCF HIP101180 J203032.2+652658 S E 3419230 1 2023-07-24 HR SKY 1800.0 30 view_spec view_head get_spec get_e2ds customize search_CCF HD138573 J153243.7+105806 S E 3419130 1 2023-07-24 HR FP 800.0 108 view_spec view_head get_spec get_e2ds customize search_CCF HD185144 J193221.6+693940 S E 3419270 1 2023-07-24 HE FP 120.0 226 view_spec view_head get_spec get_e2ds customize search_CCF HD158259 J172524.1+524727 S E 3419110 1 2023-07-24 HR FP 600.0 154 view_spec view_head get_spec get_e2ds customize search_CCF HD201876 J211207.6+103817 S E 3419240 1 2023-07-24 HR SKY 900.0 25 view_spec view_head get_spec get_e2ds customize search_CCF HD140614 J154430.2+032212 S E 3419080 1 2023-07-24 HR SKY 180.0 56 view_spec view_head get_spec get_e2ds customize search_CCF HD166685 J181123.8+113143 S E 3419200 1 2023-07-24 HR SKY 1800.0 30 view_spec view_head get_spec get_e2ds customize search_CCF HD124330 J141117.3+542433 S E 3419070 1 2023-07-24 HR FP 900.0 120 view_spec view_head get_spec get_e2ds customize search_CCF HD173739 J184246.7+593749 S E 3419170 1 2023-07-24 HR FP 900.0 19 view_spec view_head get_spec get_e2ds customize search_CCF HD147379A J161642.9+671419 S E 3419100 1 2023-07-24 HR FP 900.0 94 view_spec view_head get_spec get_e2ds customize search_CCF BD+183421 J173753.3+183530 S E 3419160 1 2023-07-24 HR SKY 1800.0 39 view_spec view_head get_spec get_e2ds customize search_CCF #-- end of data table ---------------------------------------------------------- # 30 lines were successfully retrieved