# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophiecc
# Description of the table:        Cross-correlation functions
# SQL constraint on fields:        [sseq =419230]
# Order by:                        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                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
 419230 HD217014 2007-08-06   20 G2 0 -33.181             7.946            5535  43.32 4748 view_head   get_ccf   view_ccf  
 419240 HD217014 2007-08-06   20 G2 0 -33.183             7.944            5043  43.25 4748 view_head   get_ccf   view_ccf  
 419250 HD217014 2007-08-06   20 G2 0 -33.186             7.947            4624  43.21 4748 view_head   get_ccf   view_ccf  
 419260 HD217014 2007-08-06   20 G2 0 -33.179             7.945            3029  42.82 4748 view_head   get_ccf   view_ccf  
 419270 HD217014 2007-08-06   20 G2 0 -33.180             7.947            4380  43.16 4748 view_head   get_ccf   view_ccf  
 419280 HD217014 2007-08-06   20 G2 0 -33.175             7.948            4668  43.20 4748 view_head   get_ccf   view_ccf  
 419290 HD217014 2007-08-06   20 G2 0 -33.181             7.953            5149  43.27 4748 view_head   get_ccf   view_ccf  
 419300 HD217014 2007-08-06   20 G2 0 -33.184             7.946            5295  43.32 4748 view_head   get_ccf   view_ccf  
 419310 HD217014 2007-08-06   20 G2 0 -33.176             7.943            2948  42.80 4748 view_head   get_ccf   view_ccf  
 419320 HD217014 2007-08-06   20 G2 0 -33.179             7.933            2784  42.82 4748 view_head   get_ccf   view_ccf  
 419330 HD217014 2007-08-06   20 G2 0 -33.185             7.942            3643  43.03 4748 view_head   get_ccf   view_ccf  
 419340 HD217014 2007-08-06   20 G2 0 -33.187             7.920            1105  41.75 4748 view_head   get_ccf   view_ccf  
 419350 HD217014 2007-08-06   20 G2 0 -33.174             7.931            1613  42.24 4748 view_head   get_ccf   view_ccf  
 419360 HD217014 2007-08-06   20 G2 0 -33.193             7.936             783  41.14 4748 view_head   get_ccf   view_ccf  
 419370 HD217014 2007-08-06   20 G2 0 -33.193             7.934             537  40.00 4748 view_head   get_ccf   view_ccf  
 419380 HD217014 2007-08-06   20 G2 0 -33.185             7.945            1025  41.45 4748 view_head   get_ccf   view_ccf  
 419390 HD217014 2007-08-06   20 G2 0 -33.191             7.918            1269  41.92 4748 view_head   get_ccf   view_ccf  
 419400 HD217014 2007-08-06   20 G2 0 -33.208             7.953             172  31.45 4748 view_head   get_ccf   view_ccf  
 419410 HD217014 2007-08-06   20 G2 0 -33.179             7.946            2638  42.66 4747 view_head   get_ccf   view_ccf  
 419420 HD217014 2007-08-06   20 G2 0 -33.194             7.915             567  40.14 4747 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 20 lines were successfully retrieved