+--------------------------------+-----+------------+-----------+-------+-------+------------+-----------+--------+-------+--------+------+ | game_id | N | pitch_type | avg_speed | pfx_x | pfx_z | spin_angle | spin_rate | avg_x | avg_y | avg_z | gs | +--------------------------------+-----+------------+-----------+-------+-------+------------+-----------+--------+-------+--------+------+ | gid_2007_07_10_aasmlb_nasmlb_1 | 8 | NULL | 93.38 | 3.26 | 9.39 | 158 | 2264 | 18.492 | 600 | 77.666 | 45 | | gid_2007_07_19_clemlb_texmlb_1 | 98 | NULL | 90.04 | 5.27 | 8.70 | 159 | 2252 | 26.738 | 600 | 76.310 | 41 | | gid_2007_08_03_clemlb_minmlb_1 | 107 | NULL | 87.35 | 4.46 | 7.57 | 171 | 2016 | 31.317 | 600 | 77.680 | 49 | | gid_2007_08_08_clemlb_chamlb_1 | 106 | NULL | 89.89 | 3.41 | 7.86 | 171 | 2013 | 29.399 | 600 | 70.510 | 60 | | gid_2007_08_24_clemlb_kcamlb_1 | 118 | NULL | 90.68 | 4.98 | 6.62 | 165 | 1909 | 27.106 | 600 | 75.530 | 68 | | gid_2007_09_03_clemlb_minmlb_1 | 100 | NULL | 89.35 | 4.88 | 6.55 | 168 | 1983 | 32.725 | 600 | 76.970 | 75 | | gid_2007_09_08_clemlb_anamlb_1 | 103 | NULL | 89.97 | 3.33 | 4.51 | 175 | 1680 | 30.213 | 600 | 75.462 | 75 | | gid_2007_09_14_kcamlb_clemlb_1 | 115 | NULL | 89.96 | 5.15 | 5.55 | 163 | 1877 | 29.163 | 600 | 74.884 | 58 | | gid_2007_09_19_detmlb_clemlb_1 | 100 | NULL | 90.87 | 5.07 | 7.27 | 158 | 1968 | 26.164 | 600 | 75.137 | 65 | | gid_2007_09_28_clemlb_kcamlb_1 | 96 | NULL | 88.06 | 4.74 | 6.89 | 165 | 1929 | 28.379 | 600 | 75.878 | 52 | | gid_2007_10_04_nyamlb_clemlb_1 | 106 | NULL | 91.72 | 3.81 | 7.06 | 172 | 1939 | 29.762 | 600 | 75.927 | 46 | | gid_2007_10_12_clemlb_bosmlb_1 | 83 | NULL | 89.46 | 3.21 | 7.06 | 169 | 1775 | 30.400 | 600 | 70.283 | 17 | | gid_2007_10_18_bosmlb_clemlb_1 | 110 | NULL | 91.90 | 6.28 | 6.81 | 154 | 2049 | 29.132 | 600 | 71.994 | 40 | | gid_2008_03_31_chamlb_clemlb_1 | 1 | CH | 84.40 | 11.23 | 2.79 | 104 | 2063 | 29.700 | 600 | 66.276 | 42 | | gid_2008_03_31_chamlb_clemlb_1 | 52 | FA | 89.81 | 7.96 | 8.09 | 136 | 2211 | 28.686 | 600 | 71.559 | 42 | | gid_2008_03_31_chamlb_clemlb_1 | 1 | FS | 84.80 | 8.95 | 5.97 | 124 | 1910 | 31.236 | 600 | 67.896 | 42 | | gid_2008_03_31_chamlb_clemlb_1 | 17 | SL | 80.83 | -6.42 | -0.37 | 270 | 1118 | 30.230 | 600 | 72.304 | 42 | | gid_2008_04_05_clemlb_oakmlb_1 | 3 | CH | 82.90 | 9.58 | 5.36 | 120 | 1948 | 32.452 | 600 | 71.900 | 40 | | gid_2008_04_05_clemlb_oakmlb_1 | 9 | CU | 77.84 | -5.20 | -1.71 | 289 | 951 | 30.873 | 600 | 74.375 | 40 | | gid_2008_04_05_clemlb_oakmlb_1 | 87 | FA | 90.67 | 6.91 | 9.59 | 145 | 2327 | 29.952 | 600 | 73.201 | 40 | | gid_2008_04_05_clemlb_oakmlb_1 | 1 | FC | 80.50 | -7.97 | 0.25 | 268 | 1370 | 33.480 | 600 | 72.600 | 40 | | gid_2008_04_05_clemlb_oakmlb_1 | 6 | SL | 79.08 | -7.23 | -0.52 | 273 | 1224 | 31.892 | 600 | 74.450 | 40 | | gid_2008_04_11_oakmlb_clemlb_1 | 21 | CH | 84.90 | 9.68 | 4.87 | 117 | 1994 | 29.247 | 600 | 70.158 | 2 | | gid_2008_04_11_oakmlb_clemlb_1 | 53 | FA | 93.82 | 6.50 | 7.28 | 138 | 1986 | 27.579 | 600 | 71.668 | 2 | | gid_2008_04_11_oakmlb_clemlb_1 | 1 | FC | 82.10 | -4.97 | 0.38 | 265 | 888 | 32.100 | 600 | 72.300 | 2 | | gid_2008_04_11_oakmlb_clemlb_1 | 1 | IN | 73.20 | 5.32 | 8.12 | 147 | 1539 | 38.364 | 600 | 84.300 | 2 | | gid_2008_04_11_oakmlb_clemlb_1 | 12 | SL | 80.88 | -5.34 | -1.76 | 285 | 998 | 29.904 | 600 | 72.527 | 2 | | gid_2008_04_16_detmlb_clemlb_1 | 21 | CH | 85.14 | 10.70 | 5.81 | 118 | 2232 | 25.929 | 600 | 67.340 | 6 | | gid_2008_04_16_detmlb_clemlb_1 | 1 | CU | 78.80 | -4.27 | -2.88 | 303 | 858 | 26.712 | 600 | 69.012 | 6 | | gid_2008_04_16_detmlb_clemlb_1 | 64 | FA | 94.12 | 7.56 | 8.28 | 138 | 2277 | 23.892 | 600 | 69.492 | 6 | | gid_2008_04_16_detmlb_clemlb_1 | 6 | SL | 81.45 | -5.51 | -1.11 | 280 | 994 | 26.474 | 600 | 70.324 | 6 | | gid_2008_04_22_clemlb_kcamlb_1 | 9 | CH | 85.74 | 12.89 | 7.95 | 122 | 2757 | 26.769 | 600 | 74.745 | 73 | | gid_2008_04_22_clemlb_kcamlb_1 | 1 | CU | 78.10 | -3.11 | -2.23 | 305 | 620 | 29.532 | 600 | 78.780 | 73 | | gid_2008_04_22_clemlb_kcamlb_1 | 65 | FA | 93.88 | 8.77 | 10.63 | 141 | 2773 | 25.164 | 600 | 77.640 | 73 | | gid_2008_04_22_clemlb_kcamlb_1 | 26 | SL | 81.20 | -3.85 | 0.83 | 255 | 736 | 27.667 | 600 | 77.510 | 73 | | gid_2008_04_27_nyamlb_clemlb_1 | 18 | CH | 84.78 | 10.44 | 1.63 | 104 | 2106 | 30.497 | 600 | 70.634 | 77 | | gid_2008_04_27_nyamlb_clemlb_1 | 13 | CU | 80.48 | -4.69 | -6.87 | 297 | 1710 | 30.220 | 600 | 73.059 | 77 | | gid_2008_04_27_nyamlb_clemlb_1 | 70 | FA | 92.99 | 6.99 | 3.96 | 115 | 1756 | 27.730 | 600 | 72.534 | 77 | | gid_2008_04_27_nyamlb_clemlb_1 | 10 | SL | 81.91 | -4.16 | -2.60 | 260 | 1285 | 30.394 | 600 | 71.713 | 77 | | gid_2008_05_03_kcamlb_clemlb_1 | 18 | CH | 84.73 | 10.00 | 6.48 | 123 | 2175 | 31.040 | 600 | 71.071 | 42 | | gid_2008_05_03_kcamlb_clemlb_1 | 6 | CU | 78.55 | -5.46 | -2.46 | 294 | 1009 | 30.694 | 600 | 74.474 | 42 | | gid_2008_05_03_kcamlb_clemlb_1 | 60 | FA | 93.11 | 6.31 | 8.77 | 144 | 2175 | 28.089 | 600 | 73.724 | 42 | | gid_2008_05_03_kcamlb_clemlb_1 | 18 | SL | 80.10 | -5.47 | -1.95 | 287 | 1004 | 30.521 | 600 | 74.067 | 42 | | gid_2008_05_09_tormlb_clemlb_1 | 25 | CH | 85.48 | 10.40 | 8.74 | 130 | 2488 | 32.497 | 600 | 71.922 | 68 | | gid_2008_05_09_tormlb_clemlb_1 | 63 | FA | 93.45 | 6.80 | 11.10 | 149 | 2607 | 29.578 | 600 | 73.882 | 68 | | gid_2008_05_09_tormlb_clemlb_1 | 18 | SL | 80.74 | -4.92 | 1.78 | 250 | 962 | 31.533 | 600 | 73.505 | 68 | | gid_2008_05_14_oakmlb_clemlb_1 | 31 | CH | 84.23 | 9.05 | 7.29 | 132 | 2136 | 30.149 | 600 | 72.370 | 86 | | gid_2008_05_14_oakmlb_clemlb_1 | 5 | CU | 78.98 | -5.10 | -1.24 | 283 | 905 | 29.789 | 600 | 74.578 | 86 | | gid_2008_05_14_oakmlb_clemlb_1 | 65 | FA | 91.76 | 5.39 | 9.88 | 151 | 2246 | 27.603 | 600 | 75.272 | 86 | | gid_2008_05_14_oakmlb_clemlb_1 | 16 | SL | 79.74 | -5.82 | 0.62 | 261 | 1038 | 29.381 | 600 | 74.250 | 86 | | gid_2008_05_20_clemlb_chamlb_1 | 21 | CH | 85.30 | 9.22 | 8.14 | 135 | 2362 | 30.936 | 600 | 70.618 | 62 | | gid_2008_05_20_clemlb_chamlb_1 | 67 | FA | 92.82 | 6.56 | 11.33 | 150 | 2640 | 28.330 | 600 | 73.311 | 62 | | gid_2008_05_20_clemlb_chamlb_1 | 22 | SL | 80.51 | -4.87 | 2.30 | 243 | 1012 | 31.046 | 600 | 73.432 | 62 | | gid_2008_05_25_texmlb_clemlb_1 | 6 | CH | 84.53 | 8.50 | 6.41 | 122 | 1953 | 29.074 | 600 | 74.520 | 66 | | gid_2008_05_25_texmlb_clemlb_1 | 74 | FA | 92.83 | 6.07 | 8.83 | 146 | 2157 | 27.199 | 600 | 75.736 | 66 | | gid_2008_05_25_texmlb_clemlb_1 | 18 | SL | 81.10 | -5.87 | 0.26 | 265 | 1038 | 29.547 | 600 | 75.844 | 66 | | gid_2008_05_31_clemlb_kcamlb_1 | 13 | CH | 85.86 | 10.71 | 6.63 | 122 | 2345 | 33.782 | 600 | 74.195 | 54 | | gid_2008_05_31_clemlb_kcamlb_1 | 1 | CU | 79.60 | -2.54 | -2.39 | 313 | 588 | 34.380 | 600 | 77.844 | 54 | | gid_2008_05_31_clemlb_kcamlb_1 | 53 | FA | 93.48 | 7.74 | 9.23 | 140 | 2447 | 30.703 | 600 | 76.783 | 54 | | gid_2008_05_31_clemlb_kcamlb_1 | 35 | SL | 81.45 | -2.40 | 0.37 | 263 | 599 | 32.759 | 600 | 76.472 | 54 | | gid_2008_06_05_clemlb_texmlb_1 | 13 | CH | 84.32 | 7.03 | 7.69 | 150 | 2148 | 30.741 | 600 | 74.908 | 41 | | gid_2008_06_05_clemlb_texmlb_1 | 2 | CU | 79.75 | -7.54 | 0.80 | 264 | 1320 | 30.978 | 600 | 75.672 | 41 | | gid_2008_06_05_clemlb_texmlb_1 | 53 | FA | 93.31 | 8.41 | 11.56 | 144 | 2911 | 29.026 | 600 | 76.591 | 41 | | gid_2008_06_05_clemlb_texmlb_1 | 39 | SL | 80.88 | -4.04 | 2.53 | 237 | 935 | 30.842 | 600 | 76.812 | 41 | | gid_2008_06_10_minmlb_clemlb_1 | 13 | CH | 85.98 | 8.65 | 6.03 | 125 | 1950 | 31.924 | 600 | 71.316 | 82 | | gid_2008_06_10_minmlb_clemlb_1 | 1 | CU | 77.80 | -4.43 | -2.71 | 301 | 862 | 28.260 | 600 | 76.044 | 82 | | gid_2008_06_10_minmlb_clemlb_1 | 71 | FA | 94.25 | 6.41 | 8.71 | 144 | 2223 | 30.103 | 600 | 73.495 | 82 | | gid_2008_06_10_minmlb_clemlb_1 | 21 | SL | 81.68 | -4.23 | -0.86 | 278 | 798 | 32.183 | 600 | 73.351 | 82 | | gid_2008_06_15_sdnmlb_clemlb_1 | 7 | CH | 86.51 | 8.90 | 7.18 | 129 | 2134 | 33.425 | 600 | 70.786 | 67 | | gid_2008_06_15_sdnmlb_clemlb_1 | 77 | FA | 93.17 | 6.10 | 8.82 | 146 | 2169 | 31.138 | 600 | 73.101 | 67 | | gid_2008_06_15_sdnmlb_clemlb_1 | 28 | SL | 81.46 | -5.05 | 0.53 | 262 | 897 | 32.386 | 600 | 73.363 | 67 | +--------------------------------+-----+------------+-----------+-------+-------+------------+-----------+--------+-------+--------+------+