# 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: HD173667 # 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] # ] ] #-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- HD173667 J184539.7+203247 S E 1629421 1 2014-05-05 HR WAVE 300.0 377 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1630000 1 2014-05-07 HR WAVE 300.0 270 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1630411 1 2014-05-08 HR WAVE 300.0 346 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1630811 1 2014-05-09 HR WAVE 300.0 206 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1631270 1 2014-05-10 HR WAVE 300.0 235 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1671260 2 2014-08-03 HR WAVE 600.0 502 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1671780 2 2014-08-04 HR WAVE 600.0 474 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1672630 2 2014-08-05 HR WAVE 600.0 264 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1673220 2 2014-08-06 HR WAVE 600.0 350 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1680210 1 2013-10-22 HR WAVE 300.0 46 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1680850 1 2013-10-24 HR WAVE 300.0 265 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1681290 1 2013-10-25 HR WAVE 60.0 135 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1681940 1 2013-10-26 HR WAVE 100.0 180 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1699291 1 2014-09-23 HR WAVE 480.0 118 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1700190 1 2014-09-25 HR WAVE 600.0 602 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1700230 1 2014-09-25 HR WAVE 300.0 374 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1700240 1 2014-09-25 HR WAVE 300.0 348 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1700660 1 2014-09-26 HR WAVE 300.0 483 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1700670 1 2014-09-26 HR WAVE 300.0 416 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1722161 1 2014-11-06 HR WAVE 250.0 320 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1722170 1 2014-11-06 HR WAVE 250.0 321 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1722890 2 2014-11-07 HR WAVE 250.0 311 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1723610 2 2014-11-08 HR WAVE 250.0 440 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1788590 2 2015-03-11 HR WAVE 250.0 289 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1789210 2 2015-03-12 HR WAVE 250.0 311 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1817260 1 2015-05-05 HR WAVE 600.0 408 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1824400 1 2015-05-18 HR WAVE 300.0 254 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1825680 1 2015-06-24 HR WAVE 250.0 325 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1826010 1 2015-06-25 HR WAVE 250.0 241 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1826361 1 2015-06-26 HR WAVE 250.0 294 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1826380 1 2015-05-20 HR WAVE 300.0 228 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1827750 2 2015-05-23 HR WAVE 600.0 404 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1829260 1 2015-05-26 HR WAVE 250.0 236 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1829270 1 2015-05-26 HR WAVE 250.0 248 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1840250 1 2015-06-22 HR WAVE 250.0 336 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1855590 1 2015-08-25 HR WAVE 250.0 250 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1867570 1 2015-09-17 HR WAVE 250.0 289 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1868470 1 2015-09-19 HR WAVE 250.0 188 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1869520 2 2015-09-21 HR WAVE 250.0 318 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1880710 1 2015-10-14 HR WAVE 750.0 290 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1881120 2 2015-10-15 HR WAVE 250.0 233 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1881540 2 2015-10-16 HR WAVE 250.0 313 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1882380 2 2015-10-19 HR WAVE 250.0 283 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1884230 2 2015-10-22 HR WAVE 250.0 408 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1885000 2 2015-10-23 HR WAVE 250.0 412 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1886150 2 2015-10-25 HR WAVE 250.0 339 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1886390 2 2015-11-16 HR WAVE 250.0 366 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1886580 1 2015-10-26 HR WAVE 250.0 5 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1886590 2 2015-10-26 HR WAVE 250.0 5 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1886890 2 2015-11-17 HR WAVE 250.0 207 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1887211 2 2015-11-18 HR WAVE 250.0 313 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1889461 1 2015-11-22 HR WAVE 300.0 265 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1988660 1 2016-06-22 HR WAVE 400.0 487 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 1989060 1 2016-06-23 HR WAVE 450.0 503 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2005700 2 2016-07-27 HR WAVE 300.0 306 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2006050 1 2016-07-28 HR WAVE 300.0 338 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2006060 1 2016-07-28 HR WAVE 300.0 331 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2006170 2 2016-07-28 HR WAVE 300.0 346 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2006550 2 2016-07-29 HR WAVE 250.0 323 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2007190 1 2016-07-31 HR WAVE 300.0 195 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2007200 1 2016-07-31 HR WAVE 300.0 215 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2009710 2 2016-08-06 HR WAVE 300.0 287 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2011780 1 2016-08-10 HR WAVE 432.0 289 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2012320 1 2016-08-11 HR WAVE 300.0 342 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2012790 2 2016-08-12 HR WAVE 200.0 257 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2013310 2 2016-08-13 HR WAVE 300.0 320 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2013730 2 2016-08-14 HR WAVE 300.0 400 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2014970 1 2016-08-17 HR WAVE 300.0 340 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2014980 1 2016-08-17 HR WAVE 300.0 325 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2015310 2 2016-08-18 HR WAVE 300.0 305 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2015610 2 2016-08-19 HR WAVE 300.0 258 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2016050 2 2016-08-20 HR WAVE 300.0 257 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2016490 2 2016-08-21 HR WAVE 300.0 214 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2032160 1 2016-09-22 HR WAVE 300.0 361 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2032170 1 2016-09-22 HR WAVE 300.0 345 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2056660 1 2016-11-23 HR WAVE 600.0 41 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2232260 1 2017-06-22 HR WAVE 300.0 330 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2233280 1 2017-06-24 HR WAVE 420.0 155 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2243980 2 2017-07-14 HR WAVE 300.0 229 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2244070 2 2017-07-14 HR WAVE 300.0 239 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2244480 2 2017-07-15 HR WAVE 300.0 265 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2266270 1 2017-08-16 HR WAVE 300.0 393 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2266300 1 2017-08-16 HR WAVE 300.0 385 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2267190 1 2017-08-18 HR WAVE 300.0 17 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2267200 1 2017-08-18 HR WAVE 300.0 140 view_spec view_head get_spec get_e2ds customize search_CCF HD173667 J184539.7+203247 S E 2267260 1 2017-08-18 HR WAVE 300.0 40 view_spec view_head get_spec get_e2ds customize search_CCF #-- end of data table ---------------------------------------------------------- # 86 lines were successfully retrieved