# 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] # ] ] #-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- TYC2150-4857-1 J193941.4+283420 S E 3586170 1 2024-07-10 HR SKY 1800.0 29 view_spec view_head get_spec get_e2ds customize search_CCF BD+284248 J215730.7+285613 S E 3586190 1 2024-07-10 HR SKY 666.0 50 view_spec view_head get_spec get_e2ds customize search_CCF HD216961 J225642.1+435314 S E 3586200 1 2024-07-10 HR SKY 1400.0 39 view_spec view_head get_spec get_e2ds customize search_CCF BD+432940 J181817.8+431109 S E 3586140 1 2024-07-10 HR SKY 888.0 44 view_spec view_head get_spec get_e2ds customize search_CCF HD148049 J162307.2+502040 S E 3586100 1 2024-07-10 HR SKY 900.0 68 view_spec view_head get_spec get_e2ds customize search_CCF HD224016 J235429.7+293817 S E 3586210 1 2024-07-10 HR SKY 444.0 52 view_spec view_head get_spec get_e2ds customize search_CCF TYC4412-1753-1 J153359.4+692101 S E 3586090 1 2024-07-10 HR SKY 1800.0 36 view_spec view_head get_spec get_e2ds customize search_CCF HD112974 J130015.5+213316 S E 3586060 1 2024-07-10 HR SKY 555.0 57 view_spec view_head get_spec get_e2ds customize search_CCF HD172558 J184022.0+132212 S E 3586130 1 2024-07-10 HR SKY 555.0 49 view_spec view_head get_spec get_e2ds customize search_CCF HD159333 J173352.8+080614 S E 3586110 1 2024-07-10 HR SKY 555.0 50 view_spec view_head get_spec get_e2ds customize search_CCF HD177572 J190426.3+223956 S E 3586180 1 2024-07-10 HR SKY 666.0 50 view_spec view_head get_spec get_e2ds customize search_CCF HD128717 J143621.3+573338 S E 3586070 1 2024-07-10 HR SKY 555.0 49 view_spec view_head get_spec get_e2ds customize search_CCF HD124330 J141117.3+542433 S E 3586080 1 2024-07-10 HR FP 900.0 112 view_spec view_head get_spec get_e2ds customize search_CCF HD173701 J184435.2+435000 S E 3586150 1 2024-07-10 HR FP 1000.0 162 view_spec view_head get_spec get_e2ds customize search_CCF HD167042 J181031.7+541712 S E 3586160 1 2024-07-10 HR FP 600.0 262 view_spec view_head get_spec get_e2ds customize search_CCF HD164595 J180038.9+293419 S E 3586120 1 2024-07-10 HR FP 800.0 156 view_spec view_head get_spec get_e2ds customize search_CCF HD158259 J172524.1+524727 S E 3585610 1 2024-07-09 HR FP 600.0 194 view_spec view_head get_spec get_e2ds customize search_CCF HD164595 J180038.9+293419 S E 3585660 1 2024-07-09 HR FP 800.0 150 view_spec view_head get_spec get_e2ds customize search_CCF HD185144 J193221.6+693940 S E 3585540 1 2024-07-09 HE FP 120.0 304 view_spec view_head get_spec get_e2ds customize search_CCF HD185144 J193221.6+693940 S E 3585670 1 2024-07-09 HR FP 300.0 351 view_spec view_head get_spec get_e2ds customize search_CCF HD173701 J184435.2+435000 S E 3585630 1 2024-07-09 HR FP 1000.0 161 view_spec view_head get_spec get_e2ds customize search_CCF HD225261 J000456.3+231611 S E 3585700 1 2024-07-09 HR FP 1000.0 121 view_spec view_head get_spec get_e2ds customize search_CCF BD+183421 J173753.3+183530 S E 3585600 1 2024-07-09 HR SKY 1800.0 70 view_spec view_head get_spec get_e2ds customize search_CCF BD+183330 J171503.0+182027 S E 3585590 1 2024-07-09 HR SKY 1800.0 51 view_spec view_head get_spec get_e2ds customize search_CCF BD+621529 J170722.4+622833 S E 3585580 1 2024-07-09 HR SKY 600.0 34 view_spec view_head get_spec get_e2ds customize search_CCF TYC2150-4857-1 J193941.4+283420 S E 3585690 1 2024-07-09 HR SKY 1800.0 29 view_spec view_head get_spec get_e2ds customize search_CCF HD124330 J141117.3+542433 S E 3585490 1 2024-07-09 HR FP 900.0 133 view_spec view_head get_spec get_e2ds customize search_CCF TYC3083-0295-1 J165631.1+441809 S E 3585520 1 2024-07-09 HE SKY 1600.0 28 view_spec view_head get_spec get_e2ds customize search_CCF BD+621529 J170722.4+622833 S E 3585570 1 2024-07-09 HR SKY 600.0 31 view_spec view_head get_spec get_e2ds customize search_CCF TYC3502-0393-1 J163012.0+495345 S E 3585510 1 2024-07-09 HE SKY 3600.0 52 view_spec view_head get_spec get_e2ds customize search_CCF #-- end of data table ---------------------------------------------------------- # 30 lines were successfully retrieved