# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophiecc
# Description of the table:        Cross-correlation functions
# Object:                          HD196218
# Order by:                        ra
# 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                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
2034820 HD196218 2016-09-26    1 G2 0   7.915  0.0093     8.273   0.059     158  29.24 4688 view_head   get_ccf   view_ccf  
2311510 HD196218 2017-10-02    1 G2 0   8.112  0.0023     8.137   0.036    1651  29.94 4686 view_head   get_ccf   view_ccf  
1997900 HD196218 2016-07-14    1 G2 0   8.863  0.0032     8.169   0.060     887  30.17 4729 view_head   get_ccf   view_ccf  
1901950 HD196218 2015-12-20    1 G2 0  14.515  0.0027     8.332   0.021     825  27.90 4691 view_head   get_ccf   view_ccf  
1901950 HD196218 2015-12-20    1 G2 0  14.515  0.0027     8.332   0.021     825  27.90 4691 view_head   get_ccf   view_ccf  
2044100 HD196218 2016-10-16    1 G2 0   7.845  0.0047     8.184   0.059     503  28.99 4680 view_head   get_ccf   view_ccf  
2044110 HD196218 2016-10-16    1 G2 0   7.576  0.0314     8.369  -0.173      71  17.00 4680 view_head   get_ccf   view_ccf  
1997400 HD196218 2016-07-13    1 G2 0   8.884  0.0033     8.178   0.056     849  30.03 4729 view_head   get_ccf   view_ccf  
2903480 HD196218 2020-07-18    1 G2 0  12.107  0.0027     8.208   0.014    1077  29.50 4728 view_head   get_ccf   view_ccf  
2920790 HD196218 2020-08-19    1 G2 0  12.252  0.0020     8.146   0.041    2138  30.24 4709 view_head   get_ccf   view_ccf  
3059900 HD196218 2021-07-13    1 G2 0  13.741  0.0053     8.149   0.067     387  29.76 4730 view_head   get_ccf   view_ccf  
2940000 HD196218 2020-09-27    1 G2 0  12.138  0.1025     7.817  -0.197      26  13.40 4688 view_head   get_ccf   view_ccf  
2611090 HD196218 2018-09-28    1 G2 0   9.469  0.0036     8.164   0.018     681  29.40 4688 view_head   get_ccf   view_ccf  
2777290 HD196218 2019-08-16    1 G2 0  10.725  0.0054     8.159   0.072     370  30.05 4713 view_head   get_ccf   view_ccf  
3114520 HD196218 2021-10-25    1 G2 0  14.277  0.0054     8.177   0.040     376  29.21 4679 view_head   get_ccf   view_ccf  
2721550 HD196218 2019-05-05    1 G2 0  10.331  0.0041     8.148   0.019     539  29.65 4762 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 16 lines were successfully retrieved