# 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) # Order by: date desc # 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 #------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ---------- 3414740 HD189733 2023-07-14 1 K5 0 -2.066 0.0016 7.791 0.033 2287 34.04 6951 view_head get_ccf view_ccf 3414170 HD189733 2023-07-13 1 K5 0 -2.402 0.0018 7.778 0.039 1780 33.91 6951 view_head get_ccf view_ccf 3413630 HD189733 2023-07-12 1 K5 0 -2.178 0.0020 7.873 0.056 1465 33.48 6953 view_head get_ccf view_ccf 3412750 HD189733 2023-07-11 1 K5 0 -2.282 0.0029 7.909 0.029 778 32.67 6953 view_head get_ccf view_ccf 3412130 HD189733 2023-07-10 1 K5 0 -2.173 0.0015 7.890 -0.001 2430 34.03 6954 view_head get_ccf view_ccf 3411610 HD189733 2023-07-09 1 K5 0 -2.132 0.0019 7.835 0.018 1647 33.76 6954 view_head get_ccf view_ccf 3410860 HD189733 2023-07-08 1 K5 0 -2.356 0.0016 7.847 0.029 2235 33.95 6954 view_head get_ccf view_ccf 3409240 HD189733 2023-07-05 1 K5 0 -2.039 0.0022 7.785 0.016 1273 33.39 6954 view_head get_ccf view_ccf 3408580 HD189733 2023-07-04 1 K5 0 -2.418 0.0015 7.778 0.025 2370 34.17 6957 view_head get_ccf view_ccf 3408010 HD189733 2023-07-03 1 K5 0 -2.116 0.0019 7.795 0.035 1646 33.63 6957 view_head get_ccf view_ccf 3407400 HD189733 2023-07-02 1 K5 0 -2.335 0.0021 7.800 0.022 1319 33.39 6959 view_head get_ccf view_ccf 3406790 HD189733 2023-07-01 1 K5 0 -2.181 0.0017 7.796 0.032 1970 33.91 6959 view_head get_ccf view_ccf 3406290 HD189733 2023-06-30 1 K5 0 -2.259 0.0028 7.851 0.079 864 32.64 6960 view_head get_ccf view_ccf 3405340 HD189733 2023-06-28 1 K5 0 -2.062 0.0021 7.862 0.004 1305 33.27 6964 view_head get_ccf view_ccf 3404840 HD189733 2023-06-25 1 K5 0 -2.424 0.0021 7.857 0.013 1308 33.23 6967 view_head get_ccf view_ccf 3404190 HD189733 2023-06-24 1 K5 0 -2.025 0.0017 7.836 0.013 1904 33.85 6967 view_head get_ccf view_ccf 3403370 HD189733 2023-06-23 1 K5 0 -2.398 0.0026 7.842 0.010 924 33.12 6967 view_head get_ccf view_ccf 3396070 HD145675 2023-06-10 1 K5 0 -13.323 0.0007 7.086 -0.000 6088 42.65 6938 view_head get_ccf view_ccf 3396110 HD164595 2023-06-10 1 G2 0 2.100 0.1000 7.375 -0.029 10999 41.21 4741 view_head get_ccf view_ccf 3396080 HD145675 2023-06-10 1 K5 0 -13.325 0.0007 7.082 0.000 6107 42.65 6938 view_head get_ccf view_ccf 3396090 HD158259 2023-06-10 1 G2 0 13.500 0.1000 7.759 -0.004 15353 37.79 4748 view_head get_ccf view_ccf 3396190 TYC1124-0343-1 2023-06-10 1 G2 0 -44.846 0.0186 19.805 0.022 257 15.50 4760 view_head get_ccf view_ccf 3396120 BD+641268 2023-06-10 1 G2 0 -49.483 0.0044 10.380 0.132 898 25.40 4767 view_head get_ccf view_ccf 3396130 HD185144 2023-06-10 1 K5 0 26.800 0.1000 6.624 -0.001 35018 33.59 6987 view_head get_ccf view_ccf 3396200 TYC5209-0209-1 2023-06-10 1 G2 0 -33.341 0.0049 10.197 -0.017 570 27.65 4757 view_head get_ccf view_ccf 3396040 TYC3451-1010-1 2023-06-10 1 G2 0 -26.813 0.0024 7.514 -0.056 548 46.88 4692 view_head get_ccf view_ccf 3396060 HD138573 2023-06-10 1 G2 0 -35.700 0.1000 7.475 -0.028 7448 41.48 4693 view_head get_ccf view_ccf 3396230 TYC2743-1716-1 2023-06-10 1 G2 0 -3.885 0.0039 7.728 -0.027 354 39.82 4767 view_head get_ccf view_ccf 3396210 HD193030 2023-06-10 1 G2 0 -67.300 0.1000 7.267 -0.016 817 43.11 4760 view_head get_ccf view_ccf 3396050 HD109246 2023-06-10 1 G2 0 -19.500 0.1000 7.792 -0.018 3320 41.08 4729 view_head get_ccf view_ccf #-- end of data table ---------------------------------------------------------- # 30 lines were successfully retrieved