# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophiecc
# Description of the table:        Cross-correlation functions
# Object:                          HD147187
# 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                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
1389080 HD147187 2012-06-28    1 G2 0 -22.157  0.0019     7.900  -0.011     907  47.27 4747 view_head   get_ccf   view_ccf  
1391330 HD147187 2012-07-03    1 G2 0 -22.159  0.0018     7.888  -0.017     968  47.38 4746 view_head   get_ccf   view_ccf  
2604070 HD147187 2018-09-18    1 G2 0 -22.176  0.0019     7.974  -0.027     754  46.21 4752 view_head   get_ccf   view_ccf  
2705320 HD147187 2019-03-24    1 G2 0 -22.168  0.0029     7.885  -0.016     442  47.02 4760 view_head   get_ccf   view_ccf  
2714700 HD147187 2019-04-24    1 G2 0 -22.160  0.0019     7.882  -0.012     893  47.32 4752 view_head   get_ccf   view_ccf  
2737020 HD147187 2019-06-06    1 G2 0 -22.165  0.0020     7.888  -0.020     854  47.83 4747 view_head   get_ccf   view_ccf  
3035270 HD147187 2021-05-27    1 G2 0 -22.200  0.1000     7.886  -0.017    1407  47.78 4747 view_head   get_ccf   view_ccf  
3340300 HD147187 2023-01-30    1 G2 0 -22.200  0.1000     7.920  -0.015     508  46.54 4770 view_head   get_ccf   view_ccf  
3392770 HD147187 2023-05-31    1 G2 0 -22.200  0.1000     7.889  -0.018     650  47.10 4747 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 9 lines were successfully retrieved