The SOPHIE archive

SOPHIE

seq	objname	date	slen	mask	ccf_offline	rv	fwhm	span	maxcpp	contrast	lines	view_head	get_ccf	view_ccf
1704060	HD074011	2013-12-05	1	G2	0	58.414 ± 0.0012	7.522	-0.031	5969	28.51	4756	view_head	get_ccf	view_ccf
1704400	HD074011	2013-12-06	1	G2	0	58.410 ± 0.0008	7.521	-0.037	12308	28.74	4755	view_head	get_ccf	view_ccf
1899250	HD074011	2015-12-11	1	G2	0	58.304 ± 0.0006	7.497	-0.005	24246	29.19	4750	view_head	get_ccf	view_ccf
1899250	HD074011	2015-12-11	1	G2	0	58.304 ± 0.0006	7.497	-0.005	24246	29.19	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