# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophiecc
# Description of the table:        Cross-correlation functions
# Object:                          HD197140
# 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                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
2770910 HD197140 2019-08-06    1 G2 0 -38.300  0.1000     8.116  -0.013     867  37.80 4743 view_head   get_ccf   view_ccf  
2903770 HD197140 2020-07-19    1 G2 0 -38.300  0.1000     8.068  -0.003     866  37.95 4751 view_head   get_ccf   view_ccf  
2516860 HD197140 2018-05-25    1 G2 0 -38.250  0.0058     8.058   0.063     233  36.73 4762 view_head   get_ccf   view_ccf  
2604060 HD197140 2018-09-18    1 G2 0 -38.218  0.0025     8.077  -0.019     902  37.86 4719 view_head   get_ccf   view_ccf  
2585930 HD197140 2018-08-21    1 G2 0 -38.215  0.0025     8.107  -0.001     890  38.00 4734 view_head   get_ccf   view_ccf  
 172890 HD197140 2006-11-05    1 G2 0 -38.212             8.089            2555  31.62 4705 view_head   get_ccf   view_ccf  
2280580 HD197140 2017-09-08    1 G2 0 -38.217  0.0018     8.118  -0.013    1516  37.59 4723 view_head   get_ccf   view_ccf  
 177250 HD197140 2006-11-07    1 G2 0 -38.235             8.076            2638  33.01 4705 view_head   get_ccf   view_ccf  
2607350 HD197140 2018-09-23    1 G2 0 -38.214  0.0020     8.088  -0.002    1354  38.23 4718 view_head   get_ccf   view_ccf  
2328280 HD197140 2017-10-06    1 G2 0 -38.211  0.0026     8.070  -0.001     886  37.78 4712 view_head   get_ccf   view_ccf  
2595950 HD197140 2018-09-06    1 G2 0 -38.214  0.0025     8.083  -0.018     905  38.25 4724 view_head   get_ccf   view_ccf  
2547950 HD197140 2018-07-27    1 G2 0 -38.214  0.0025     8.080  -0.009     908  38.00 4747 view_head   get_ccf   view_ccf  
 171270 HD197140 2006-11-03    1 G2 0 -38.217             8.080            2199  31.85 4706 view_head   get_ccf   view_ccf  
2008100 HD197140 2016-08-02    1 G2 0 -38.226  0.0032     8.140   0.001     577  38.50 4743 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 14 lines were successfully retrieved