The SOPHIE archive

leda did not return a position for the name 'TYC5165-481-1'
The object name (TYC5165-481-1) was resolved at position J201240.2-020839 by simbad
A cone search within 1.00 arcmin of this position matched no record in the table sophie

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

Constrain any fields, choose the fields to display, and order the recordsSQL
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 recordsfield constraints
SELECT [List of fields to display]
$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]

Query Description

Type of request:                 Extract data from a table
Name of the selected table:      sophie
Description of the table:        Spectra
Object:                          TYC5165-481-1

Home

Sky search

in a	of by arcmin half-side

The SOPHIE archive

document.write(table_description);

Query Description