The SOPHIE archive
objname
RA (J2000) Dec
S
E
seq
slen
date
mode
fiber_b
exptime
sn26
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
Display this selection as plain text
Show only the first observation for long series
Search the CCF for the same objects
Apply the same selection to the Elodie archive
Get the wget commands to download all the selected 1D spectra
Explanations
Get the wget commands to download all the selected E2D spectra
Explanations
Sky search
Object name or list
Near object or position
Objects list from file
in a
square box
disk
rectangular box
of
by
arcmin half-side
Constrain any fields, choose the fields to display, and order the records
SQL
Field
Constraint
Show
Sort
objname
RA (J2000) Dec
ra
dec
S
E
seq
slen
date
mode
fiber_b
exptime
sn26
view_spec
view_head
get_spec
get_e2ds
customize
search_ccf
sseq
targetname
target_mv
target_sptype
obstype
guid_seeing
expno
nexp
mjd
bjd
Choose the fields to display, set SQL constrains, and order the records
field constraints
SELECT
[List of fields to display]
Fields list
$link[objname],$j2000,$link['S'],$link['E'],seq,$link[slen],date,mode,fiber_b,exptime,sn26,$link[view_spec],$link[view_head],$link[get_spec],$link[get_e2ds],$link[customize],$link[search_ccf]
FROM sophie
WHERE
[SQL constraints]
ORDER BY
[Sort key]
Output as
HTML table
plain HTML
Expanded table
Formatted text
VOTable
CSV
separator
TAB
other
Default
Reset
Submit
Save to file
Home