# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophiescc
# Description of the table:        Cross-correlation functions (series truncated to the first observation)
# Object:                          HD197345
# Order by:                        ra,seq
# Description of each column
# seq: ----------------- Sequence number
# $link[objname]: ------ Designation of the object
# date: ---------------- Observation date
# $link[slen]: --------- Length of the series
# mask: ---------------- Name of the mask
# ccf_offline: --------- Offline CCF
# $field[rv]: ---------- Radial velocity
# fwhm: ---------------- FWHM of the correlation peak
# span: ---------------- Bissector span
# maxcpp: -------------- Maximum number of counts per pixel
# contrast: ------------ Contrast of the CCF
# lines: --------------- Number of lines used for the CCF
# $link['view_head']: -- See the header of the cross-correlation file
# $link['get_ccf']: ---- Download the cross-correlation function FITS file
# $link['view_ccf']: --- View the cross-correlation function
#-------------- ------- --------------- ---- -- --------------- ---------------- -------- ------- --------------- ------ --------------- ----------- --------- ----------
#seq    $link[o date            $lin ma c $field[rv]       fwhm     span    maxcpp  contra l $link['view $link['ge $link['vie
#       bjname]                 k[sl sk c                                           st     i _head']     t_ccf']   w_ccf']   
#                               en]     f                                                  n                                 
#                                       _                                                  e                                 
#                                       o                                                  s                                 
#                                       f                                                                                    
#                                       f                                                                                    
#                                       l                                                                                    
#                                       i                                                                                    
#                                       n                                                                                    
#                                       e                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
 856350 HD197345 2009-09-28    1 G2 0  -2.428  0.0143    35.105   0.000  127041   1.24 4727 view_head   get_ccf   view_ccf  
 857810 HD197345 2009-09-29    1 G2 0  -4.727  0.0142    38.722   0.000  136894   1.28 4727 view_head   get_ccf   view_ccf  
 859150 HD197345 2009-09-30    1 G2 0  -6.719  0.0135    38.171   0.000  138483   1.32 4727 view_head   get_ccf   view_ccf  
 860170 HD197345 2009-10-01    1 G2 0  -6.856  0.0131    40.512   0.000  128935   1.44 4727 view_head   get_ccf   view_ccf  
 861260 HD197345 2009-10-02    1 G2 0  -6.650  0.0145    40.229   0.000  103222   1.46 4726 view_head   get_ccf   view_ccf  
 862170 HD197345 2009-10-03    1 G2 0  -6.866  0.0110    39.256   0.000  191515   1.36 4726 view_head   get_ccf   view_ccf  
 862180 HD197345 2009-10-03    1 G2 0  -6.868  0.0150    38.995   0.000  103951   1.35 4726 view_head   get_ccf   view_ccf  
 863290 HD197345 2009-10-04    1 G2 0  -7.241  0.0126    39.633   0.000  155133   1.37 4725 view_head   get_ccf   view_ccf  
 864390 HD197345 2009-10-05    1 G2 0  -7.045  0.0121    39.703   0.000  153349   1.42 4725 view_head   get_ccf   view_ccf  
 864400 HD197345 2009-10-05    1 G2 0  -7.009  0.0138    39.448   0.000  116873   1.41 4725 view_head   get_ccf   view_ccf  
 864880 HD197345 2009-10-06    1 G2 0  -6.574  0.0115    38.655   0.000  157915   1.47 4725 view_head   get_ccf   view_ccf  
 864890 HD197345 2009-10-06    1 G2 0  -6.536  0.0118    38.944   0.000  149101   1.48 4725 view_head   get_ccf   view_ccf  
 866770 HD197345 2009-10-07    1 G2 0  -5.913  0.0315    38.536   0.000   21044   1.46 4725 view_head   get_ccf   view_ccf  
 866780 HD197345 2009-10-07    1 G2 0  -5.878  0.0395    39.636   0.000   13212   1.50 4725 view_head   get_ccf   view_ccf  
 868260 HD197345 2009-10-08    1 G2 0  -5.493  0.0145    37.487   0.000   94553   1.48 4725 view_head   get_ccf   view_ccf  
 868690 HD197345 2009-10-09    1 G2 0  -5.174  0.0137    35.241   0.000  114186   1.38 4725 view_head   get_ccf   view_ccf  
 869640 HD197345 2009-10-10    1 G2 0  -5.384  0.0149    40.263   0.000   98876   1.45 4724 view_head   get_ccf   view_ccf  
 870390 HD197345 2009-10-11    1 G2 0  -5.572  0.0254    39.293   0.000   41058   1.31 4724 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 18 lines were successfully retrieved