The SOPHIE archive

SOPHIE

seq	objname	date	slen	mask	ccf_offline	rv	fwhm	span	maxcpp	contrast	lines	view_head	get_ccf	view_ccf
643500	TYC2785-2130-1	2008-07-11	1	F0	1	-14.394	63.746		446	2.90	3304	view_head	get_ccf	view_ccf
643500	TYC2785-2130-1	2008-07-11	1	G2	0	-14.189 ± 0.0245	391.671	0.000	347	42.06	4760	view_head	get_ccf	view_ccf
643500	TYC2785-2130-1	2008-07-11	1	G2	1	-15.378	67.065		372	3.77	4494	view_head	get_ccf	view_ccf

Display this selection as plain text
Show only the first observation 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