The SOPHIE archive

SOPHIE

seq	objname	date	slen	mask	ccf_offline	rv	fwhm	span	maxcpp	contrast	lines	view_head	get_ccf	view_ccf
183760	HD080699	2006-11-14	1	G2	0	42.889	8.464		3362	34.23	4763	view_head	get_ccf	view_ccf
195530	HD080699	2006-12-08	1	G2	0	42.906	8.450		1256	29.66	4753	view_head	get_ccf	view_ccf
197470	HD080699	2006-12-10	1	G2	0	42.898	8.450		1952	32.15	4752	view_head	get_ccf	view_ccf
203210	HD080699	2006-12-17	1	G2	0	42.904	8.461		774	27.77	4750	view_head	get_ccf	view_ccf

Display this selection as plain text
Show all the observations, even for long series
Search the spectra for the same objects
Apply the same selection to the Elodie archive
Get the wget commands to download all the selected crosscorrelation functions	Explanations

Constrain any fields, choose the fields to display, and order the recordsSQL
Field		Constraint	Show	Sort
seq
objname
date
slen
mask
ccf_offline
rv	rv err
fwhm
span
maxcpp
contrast
lines
view_head
get_ccf
view_ccf
ra
dec
sseq
dvrms
obstype
expno
nexp
sn26
targetname
target_sptype
target_mv
mjd
bjd