# 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) # 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] # ] ] #-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- HD201891 J211159.0+174340 S E 3759930 1 2025-07-10 HR SKY 180.0 63 not public TYC3130-0576-1 J184459.1+440403 S E 3759870 1 2025-07-10 HR SKY 1800.0 38 not public HD185144 J193221.6+693940 S E 3759910 1 2025-07-10 HR FP 300.0 299 not public GSC1105-0204 J211142.4+085850 S E 3759950 1 2025-07-10 HE SKY 1800.0 32 not public HD155193 J170941.2+100219 S E 3759850 1 2025-07-10 HR FP 700.0 147 not public BD+284312 J221206.3+290356 S E 3760000 1 2025-07-10 HR FP 1800.0 92 not public HD127911 J143244.3+434523 S E 3759830 1 2025-07-10 HR SKY 900.0 48 not public HD178126 J190702.1+073658 S E 3759890 1 2025-07-10 HR FP 1800.0 88 not public TYC3615-2707-1 J222655.4+490900 S E 3760040 1 2025-07-10 HE SKY 1800.0 35 not public HD177572 J190426.3+223956 S E 3759880 1 2025-07-10 HR SKY 600.0 50 not public BD+163271 J174455.4+164109 S E 3759840 1 2025-07-10 HR SKY 800.0 49 not public HD205286 J213308.9+404927 S E 3759920 1 2025-07-10 HR FP 1000.0 127 not public HD158259 J172524.1+524727 S E 3759860 1 2025-07-10 HR FP 600.0 172 not public TYC5209-0209-1 J213847.3-000247 S E 3759990 1 2025-07-10 HR SKY 1800.0 40 not public BD+651899 J232910.3+660558 S E 3760020 1 2025-07-10 HR SKY 1800.0 69 not public HD207874 J215206.5+015423 S E 3759980 1 2025-07-10 HR FP 1200.0 110 not public BD+750855 J225233.7+760140 S E 3760010 1 2025-07-10 HR SKY 1400.0 52 not public HD201876 J211207.6+103817 S E 3759970 1 2025-07-10 HR FP 1200.0 106 not public HD167042 J181031.7+541712 S E 3759900 1 2025-07-10 HR FP 240.0 137 not public HD158259 J172524.1+524727 S E 3759280 1 2025-07-09 HR FP 600.0 214 not public HD185144 J193221.6+693940 S E 3759350 1 2025-07-09 HR FP 300.0 299 not public TYC2652-1324-1 J190409.9+363757 S E 3759330 1 2025-07-09 HE SKY 1800.0 37 not public HD206617 J214000.8+690511 S E 3759410 1 2025-07-09 HR SKY 1000.0 39 not public HD127911 J143244.3+434523 S E 3759260 1 2025-07-09 HR SKY 900.0 48 not public HD221585 J233254.1+630919 S E 3759430 1 2025-07-09 HR SKY 300.0 51 not public HD000445 J000903.7+405034 S E 3759460 1 2025-07-09 HR SKY 180.0 87 not public HD205286 J213308.9+404927 S E 3759340 1 2025-07-09 HR FP 1000.0 134 not public HD112974 J130015.5+213316 S E 3759250 1 2025-07-09 HR SKY 600.0 49 not public HD224918 J000148.9+661821 S E 3759450 1 2025-07-09 HR SKY 300.0 71 not public HD221585 J233254.1+630919 S E 3759440 1 2025-07-09 HR SKY 300.0 72 not public #-- end of data table ---------------------------------------------------------- # 30 lines were successfully retrieved