The SOPHIE archive

leda did not return a position for the name 'KOI-246'
The object name (KOI-246) was resolved at position J192407.8+490225 by simbad
A cone search within 1.00 arcmin of this position matched 2 records in the table sophie

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
TYC3551-0189-1	J192407.8+490225	S	E	1642251	1	2014-06-03	HE	SKY	2400.0	44	view_spec	view_head	get_spec	get_e2ds	customize	search_CCF
TYC3551-0189-1	J192407.8+490225	S	E	1685280	1	2013-11-02	HE	SKY	1800.0	48	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

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]

Home

Sky search

in a	of by arcmin half-side

The SOPHIE archive

document.write(table_description);