The SOPHIE archive

SOPHIE

seq	objname	date	slen	mask	ccf_offline	rv	fwhm	span	maxcpp	contrast	lines	view_head	get_ccf	view_ccf
342650	HD068788	2007-04-06	1	K5	0	-11.486	6.919		1179	25.00	6903	view_head	get_ccf	view_ccf
343690	HD068788	2007-04-08	1	K5	0	-11.483	6.839		1813	28.28	6904	view_head	get_ccf	view_ccf
1126580	HD068788	2011-03-08	1	K5	0	-11.483 ± 0.0025	6.795	-0.002	746	36.48	6912	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