# 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:                          HD199871
# 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                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
1681630 HD199871 2014-08-19    1 M5 0 -31.746  0.0029     7.402   0.095    5053  14.91 7159 view_head   get_ccf   view_ccf  
1823620 HD199871 2015-05-17    1 G2 0 -53.729  0.0010     9.706   0.191    2211  48.45 4761 view_head   get_ccf   view_ccf  
2367120 HD199871 2017-10-31    1 G2 0 -56.814  0.0010     9.499   0.103    2394  48.59 4708 view_head   get_ccf   view_ccf  
2389980 HD199871 2017-11-28    1 G2 0 -57.875  0.0010     9.500   0.111    2358  47.98 4703 view_head   get_ccf   view_ccf  
2753060 HD199871 2019-07-09    1 G2 0 -36.200  0.1000     9.662   0.148    2340  48.66 4758 view_head   get_ccf   view_ccf  
2766400 HD199871 2019-07-30    1 G2 0 -38.500  0.1000     9.607   0.130    2273  48.48 4751 view_head   get_ccf   view_ccf  
2907440 HD199871 2020-07-26    1 G2 0 -58.700  0.1000    59.541   0.000    5912   5.91 4751 view_head   get_ccf   view_ccf  
2937680 HD199871 2020-09-23    1 G2 0 999.000  0.1000     0.000   0.000    2437   0.00 4724 view_head   get_ccf   view_ccf  
2941490 HD199871 2020-09-29    1 G2 0 -66.700  0.1000    63.152   0.000    2417   7.50 4721 view_head   get_ccf   view_ccf  
2944550 HD199871 2020-10-04    1 G2 0 999.000  0.1000     0.000   0.000     701   0.00 4717 view_head   get_ccf   view_ccf  
2944570 HD199871 2020-10-04    1 G2 0 999.000  0.1000     0.000   0.000    2374   0.00 4717 view_head   get_ccf   view_ccf  
3071970 HD199871 2021-08-04    1 G2 0 -31.800  0.1000     9.918   0.000    2333  48.62 4749 view_head   get_ccf   view_ccf  
3083530 HD199871 2021-08-25    1 G2 0 -32.100  0.1000     9.940   0.000    2338  48.62 4741 view_head   get_ccf   view_ccf  
3092890 HD199871 2021-09-11    1 G2 0 -32.700  0.1000     9.622   0.127    2337  48.50 4724 view_head   get_ccf   view_ccf  
3103400 HD199871 2021-10-01    1 G2 0 -34.000  0.1000     9.568   0.149     860  47.99 4717 view_head   get_ccf   view_ccf  
3124270 HD199871 2021-11-09    1 G2 0 -37.500  0.1000     9.569   0.163    2367  48.72 4705 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 16 lines were successfully retrieved