MLB All-Star Teams: allstar_player_talent.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
3,930 rows sorted by lgID
This data as json, copyable, CSV (advanced)
Suggested facets: gameNum, lgID, startingPos, asg_PA, asg_IP
Link | rowid | bbref_ID | yearID | gameNum | gameID | lgID ▼ | startingPos | OFF600 | DEF600 | PITCH200 | asg_PA | asg_IP | OFFper9innASG | DEFper9innASG | PITper9innASG | TOTper9innASG |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29 | 29 | troutmi01 | 2015 | 0 | NLS201507140 | AL | 8 | 50.64962847 | -1.205686239 | 0.0 | 4 | 0.0 | 0.31989239 | -0.00761486 | 0.0 | 0.31227753 |
30 | 30 | cainlo01 | 2015 | 0 | NLS201507140 | AL | 9 | 5.858901822 | 19.86794018 | 0.0 | 3 | 0.0 | 0.027752693 | 0.094111296 | 0.0 | 0.121863988 |
31 | 31 | keuchda01 | 2015 | 0 | NLS201507140 | AL | 1 | 0.0 | 0.0 | 10.85397806 | 0 | 2.0 | 0.0 | 0.0 | 0.108539781 | 0.108539781 |
32 | 32 | donaljo02 | 2015 | 0 | NLS201507140 | AL | 5 | 19.12438229 | 12.85819769 | 0.0 | 2 | 0.0 | 0.060392786 | 0.040604835 | 0.0 | 0.100997621 |
33 | 33 | machama01 | 2015 | 0 | NLS201507140 | AL | 11.89500486 | 18.31611284 | 0.0 | 2 | 0.0 | 0.037563173 | 0.057840356 | 0.0 | 0.09540353 | |
34 | 34 | hernafe02 | 2015 | 0 | NLS201507140 | AL | 0.0 | 0.0 | 13.68661117 | 0 | 1.0 | 0.0 | 0.0 | 0.068433056 | 0.068433056 | |
35 | 35 | betande01 | 2015 | 0 | NLS201507140 | AL | 0.0 | 0.0 | 10.51321504 | 0 | 1.0 | 0.0 | 0.0 | 0.052566075 | 0.052566075 | |
36 | 36 | gardnbr01 | 2015 | 0 | NLS201507140 | AL | 12.80781841 | 1.336028519 | 0.0 | 2 | 0.0 | 0.040445742 | 0.004219037 | 0.0 | 0.04466478 | |
37 | 37 | jonesad01 | 2015 | 0 | NLS201507140 | AL | 7 | 10.53875953 | 2.682464564 | 0.0 | 2 | 0.0 | 0.033280293 | 0.008470941 | 0.0 | 0.041751234 |
38 | 38 | perezsa02 | 2015 | 0 | NLS201507140 | AL | 2 | -2.533871697 | 15.63544474 | 0.0 | 2 | 0.0 | -0.0080017 | 0.049375089 | 0.0 | 0.041373389 |
39 | 39 | priceda01 | 2015 | 0 | NLS201507140 | AL | 0.0 | 0.0 | 7.869745063 | 0 | 1.0 | 0.0 | 0.0 | 0.039348725 | 0.039348725 | |
40 | 40 | perkigl01 | 2015 | 0 | NLS201507140 | AL | 0.0 | 0.0 | 7.684233817 | 0 | 1.0 | 0.0 | 0.0 | 0.038421169 | 0.038421169 | |
41 | 41 | daviswa01 | 2015 | 0 | NLS201507140 | AL | 0.0 | 0.0 | 7.568068634 | 0 | 1.0 | 0.0 | 0.0 | 0.037840343 | 0.037840343 | |
42 | 42 | archech01 | 2015 | 0 | NLS201507140 | AL | 0.0 | 0.0 | 5.405436997 | 0 | 1.333 | 0.0 | 0.0 | 0.036027238 | 0.036027238 | |
43 | 43 | martiru01 | 2015 | 0 | NLS201507140 | AL | 8.472729454 | 12.95907107 | 0.0 | 1 | 0.0 | 0.013377994 | 0.020461691 | 0.0 | 0.033839685 | |
44 | 44 | altuvjo01 | 2015 | 0 | NLS201507140 | AL | 4 | 8.917639485 | 1.388814923 | 0.0 | 2 | 0.0 | 0.028160967 | 0.004385731 | 0.0 | 0.032546698 |
45 | 45 | cruzne02 | 2015 | 0 | NLS201507140 | AL | 0 | 17.87237529 | -9.002923165 | 0.0 | 2 | 0.0 | 0.05643908 | -0.028430284 | 0.0 | 0.028008796 |
46 | 46 | pujolal01 | 2015 | 0 | NLS201507140 | AL | 3 | 9.859501597 | -5.29621644 | 0.0 | 3 | 0.0 | 0.046702902 | -0.025087341 | 0.0 | 0.021615561 |
47 | 47 | kipnija01 | 2015 | 0 | NLS201507140 | AL | 13.8838169 | -0.322665407 | 0.0 | 1 | 0.0 | 0.021921816 | -0.000509472 | 0.0 | 0.021412344 | |
48 | 48 | brittza01 | 2015 | 0 | NLS201507140 | AL | 0.0 | 0.0 | 6.354951044 | 0 | 0.667 | 0.0 | 0.0 | 0.021193762 | 0.021193762 | |
49 | 49 | doziebr01 | 2015 | 0 | NLS201507140 | AL | 9.096503426 | 4.138715129 | 0.0 | 1 | 0.0 | 0.0143629 | 0.006534813 | 0.0 | 0.020897714 | |
50 | 50 | martijd02 | 2015 | 0 | NLS201507140 | AL | 15.96245909 | -7.676506516 | 0.0 | 1 | 0.0 | 0.025203883 | -0.0121208 | 0.0 | 0.013083083 | |
51 | 51 | vogtst01 | 2015 | 0 | NLS201507140 | AL | 7.336364395 | 0.538745787 | 0.0 | 1 | 0.0 | 0.011583733 | 0.000850651 | 0.0 | 0.012434384 | |
52 | 52 | holtbr01 | 2015 | 0 | NLS201507140 | AL | 6.348839212 | 0.63514577 | 0.0 | 1 | 0.0 | 0.010024483 | 0.001002862 | 0.0 | 0.011027345 | |
53 | 53 | iglesjo01 | 2015 | 0 | NLS201507140 | AL | -1.62677861 | 4.65610196 | 0.0 | 2 | 0.0 | -0.005137196 | 0.01470348 | 0.0 | 0.009566284 | |
54 | 54 | moustmi01 | 2015 | 0 | NLS201507140 | AL | -8.244947262 | 2.311793635 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
55 | 55 | teixema01 | 2015 | 0 | NLS201507140 | AL | 1.503351193 | -2.774522189 | 0.0 | 2 | 0.0 | 0.004747425 | -0.008761649 | 0.0 | -0.004014224 | |
56 | 56 | escobal02 | 2015 | 0 | NLS201507140 | AL | 6 | -10.60471541 | 7.377942819 | 0.0 | 2 | 0.0 | -0.033488575 | 0.023298767 | 0.0 | -0.010189808 |
57 | 57 | fieldpr01 | 2015 | 0 | NLS201507140 | AL | 10.17888542 | -14.08814163 | 0.0 | 2 | 0.0 | 0.032143849 | -0.044488868 | 0.0 | -0.01234502 | |
84 | 84 | troutmi01 | 2013 | 0 | NLS201307160 | AL | 7 | 49.36717733 | 2.097973191 | 0.0 | 3 | 0.0 | 0.261355645 | 0.011106917 | 0.0 | 0.272462562 |
85 | 85 | salech01 | 2013 | 0 | NLS201307160 | AL | 0.0 | 0.0 | 17.92905256 | 0 | 2.0 | 0.0 | 0.0 | 0.179310449 | 0.179310449 | |
86 | 86 | cabremi01 | 2013 | 0 | NLS201307160 | AL | 5 | 41.97734268 | -8.441702232 | 0.0 | 3 | 0.0 | 0.222232991 | -0.044691365 | 0.0 | 0.177541626 |
87 | 87 | pedrodu01 | 2013 | 0 | NLS201307160 | AL | 11.87000456 | 12.63811425 | 0.0 | 2 | 0.0 | 0.041894134 | 0.044605109 | 0.0 | 0.086499243 | |
88 | 88 | bautijo02 | 2013 | 0 | NLS201307160 | AL | 9 | 27.55944119 | -3.130528019 | 0.0 | 2 | 0.0 | 0.097268616 | -0.011048922 | 0.0 | 0.086219694 |
89 | 89 | scherma01 | 2013 | 0 | NLS201307160 | AL | 1 | 0.0 | 0.0 | 13.25917481 | 0 | 1.0 | 0.0 | 0.0 | 0.066303241 | 0.066303241 |
90 | 90 | mauerjo01 | 2013 | 0 | NLS201307160 | AL | 2 | 17.08688412 | 0.809616388 | 0.0 | 2 | 0.0 | 0.06030665 | 0.00285747 | 0.0 | 0.063164119 |
91 | 91 | davisch02 | 2013 | 0 | NLS201307160 | AL | 3 | 23.8561755 | -12.59528528 | 0.0 | 3 | 0.0 | 0.1262974 | -0.066680922 | 0.0 | 0.059616478 |
92 | 92 | nathajo01 | 2013 | 0 | NLS201307160 | AL | 0.0 | 0.0 | 11.52333118 | 0 | 1.0 | 0.0 | 0.0 | 0.057623058 | 0.057623058 | |
93 | 93 | canoro01 | 2013 | 0 | NLS201307160 | AL | 4 | 25.26117507 | 7.292741231 | 0.0 | 1 | 0.0 | 0.044578544 | 0.012869543 | 0.0 | 0.057448088 |
94 | 94 | riverma01 | 2013 | 0 | NLS201307160 | AL | 0.0 | 0.0 | 11.28793255 | 0 | 1.0 | 0.0 | 0.0 | 0.056445935 | 0.056445935 | |
95 | 95 | hernafe02 | 2013 | 0 | NLS201307160 | AL | 0.0 | 0.0 | 10.9692711 | 0 | 1.0 | 0.0 | 0.0 | 0.05485245 | 0.05485245 | |
96 | 96 | jonesad01 | 2013 | 0 | NLS201307160 | AL | 8 | 12.34095119 | -3.143886779 | 0.0 | 3 | 0.0 | 0.065334447 | -0.016644106 | 0.0 | 0.048690341 |
97 | 97 | ortizda01 | 2013 | 0 | NLS201307160 | AL | 0 | 24.8375102 | -11.6019817 | 0.0 | 2 | 0.0 | 0.087661801 | -0.040948171 | 0.0 | 0.04671363 |
98 | 98 | machama01 | 2013 | 0 | NLS201307160 | AL | -1.757951064 | 22.17290001 | 0.0 | 1 | 0.0 | -0.003102267 | 0.039128647 | 0.0 | 0.03602638 | |
99 | 99 | balfogr01 | 2013 | 0 | NLS201307160 | AL | 0.0 | 0.0 | 6.761375442 | 0 | 1.0 | 0.0 | 0.0 | 0.033810634 | 0.033810634 | |
100 | 100 | gordoal01 | 2013 | 0 | NLS201307160 | AL | 10.21968962 | 8.607640534 | 0.0 | 1 | 0.0 | 0.018034746 | 0.015189954 | 0.0 | 0.0332247 | |
101 | 101 | perezsa02 | 2013 | 0 | NLS201307160 | AL | 2.214183682 | 16.10082041 | 0.0 | 1 | 0.0 | 0.003907383 | 0.028413212 | 0.0 | 0.032320595 | |
102 | 102 | encared01 | 2013 | 0 | NLS201307160 | AL | 22.14417243 | -13.42327449 | 0.0 | 2 | 0.0 | 0.078155903 | -0.047376263 | 0.0 | 0.03077964 | |
103 | 103 | kipnija01 | 2013 | 0 | NLS201307160 | AL | 14.46098089 | 2.244011536 | 0.0 | 1 | 0.0 | 0.025519378 | 0.00396002 | 0.0 | 0.029479398 | |
104 | 104 | hardyjj01 | 2013 | 0 | NLS201307160 | AL | 6 | -7.312302464 | 13.9260301 | 0.0 | 2 | 0.0 | -0.025808126 | 0.049150694 | 0.0 | 0.023342568 |
105 | 105 | hollagr01 | 2013 | 0 | NLS201307160 | AL | 0.0 | 0.0 | 10.7408449 | 0 | 0.333 | 0.0 | 0.0 | 0.017885494 | 0.017885494 | |
106 | 106 | hunteto01 | 2013 | 0 | NLS201307160 | AL | 9.977153215 | -3.821687424 | 0.0 | 1 | 0.0 | 0.017606741 | -0.006744154 | 0.0 | 0.010862587 | |
107 | 107 | moorema02 | 2013 | 0 | NLS201307160 | AL | 0.0 | 0.0 | 1.770579886 | 0 | 1.0 | 0.0 | 0.0 | 0.008853883 | 0.008853883 | |
108 | 108 | fieldpr01 | 2013 | 0 | NLS201307160 | AL | 18.74564244 | -14.08792985 | 0.0 | 1 | 0.0 | 0.033080545 | -0.024861053 | 0.0 | 0.008219493 | |
109 | 109 | peraljh01 | 2013 | 0 | NLS201307160 | AL | -2.074780189 | 5.339437194 | 0.0 | 1 | 0.0 | -0.003661377 | 0.009422536 | 0.0 | 0.005761159 | |
110 | 110 | delabst01 | 2013 | 0 | NLS201307160 | AL | 0.0 | 0.0 | 0.268531742 | 0 | 0.333 | 0.0 | 0.0 | 0.000447155 | 0.000447155 | |
111 | 111 | cecilbr01 | 2013 | 0 | NLS201307160 | AL | 0.0 | 0.0 | 0.031395755 | 0 | 0.333 | 0.0 | 0.0 | 5.23e-05 | 5.23e-05 | |
112 | 112 | cruzne02 | 2013 | 0 | NLS201307160 | AL | 4.125407084 | -12.0511154 | 0.0 | 2 | 0.0 | 0.01456026 | -0.042533348 | 0.0 | -0.027973088 | |
144 | 144 | bautijo02 | 2011 | 0 | NLS201107120 | AL | 9 | 35.60554755 | -2.181436008 | 0.0 | 2 | 0.0 | 0.125666638 | -0.007699186 | 0.0 | 0.117967453 |
145 | 145 | beltrad01 | 2011 | 0 | NLS201107120 | AL | 5 | 13.78177631 | 15.88992584 | 0.0 | 2 | 0.0 | 0.048641563 | 0.056082091 | 0.0 | 0.104723655 |
146 | 146 | gonzaad01 | 2011 | 0 | NLS201107120 | AL | 3 | 27.03116743 | -0.894081295 | 0.0 | 2 | 0.0 | 0.09540412 | -0.003155581 | 0.0 | 0.092248539 |
147 | 147 | canoro01 | 2011 | 0 | NLS201107120 | AL | 4 | 18.38827361 | 6.589744082 | 0.0 | 2 | 0.0 | 0.064899789 | 0.02325792 | 0.0 | 0.08815771 |
148 | 148 | weaveje02 | 2011 | 0 | NLS201107120 | AL | 1 | 0.0 | 0.0 | 14.96546966 | 0 | 1.0 | 0.0 | 0.0 | 0.084180767 | 0.084180767 |
149 | 149 | hamiljo03 | 2011 | 0 | NLS201107120 | AL | 7 | 22.73972221 | 0.911282486 | 0.0 | 2 | 0.0 | 0.080257843 | 0.003216291 | 0.0 | 0.083474134 |
150 | 150 | ellsbja01 | 2011 | 0 | NLS201107120 | AL | 17.17220657 | 4.423719362 | 0.0 | 2 | 0.0 | 0.060607788 | 0.015613127 | 0.0 | 0.076220915 | |
151 | 151 | roberda08 | 2011 | 0 | NLS201107120 | AL | 0.0 | 0.0 | 12.06493726 | 0 | 1.0 | 0.0 | 0.0 | 0.067865272 | 0.067865272 | |
152 | 152 | grandcu01 | 2011 | 0 | NLS201107120 | AL | 8 | 12.5582827 | 5.129422341 | 0.0 | 2 | 0.0 | 0.044323351 | 0.018103844 | 0.0 | 0.062427194 |
153 | 153 | wilsocj01 | 2011 | 0 | NLS201107120 | AL | 0.0 | 0.0 | 10.07250782 | 0 | 1.0 | 0.0 | 0.0 | 0.056657856 | 0.056657856 | |
154 | 154 | cabremi01 | 2011 | 0 | NLS201107120 | AL | 38.92148186 | -9.163162813 | 0.0 | 1 | 0.0 | 0.068684968 | -0.016170287 | 0.0 | 0.052514681 | |
155 | 155 | youklke01 | 2011 | 0 | NLS201107120 | AL | 25.02126434 | 2.321159895 | 0.0 | 1 | 0.0 | 0.044155172 | 0.004096165 | 0.0 | 0.048251337 | |
156 | 156 | cabreas01 | 2011 | 0 | NLS201107120 | AL | 6 | 7.879348375 | 5.686032546 | 0.0 | 2 | 0.0 | 0.027809465 | 0.02006835 | 0.0 | 0.047877815 |
157 | 157 | avilaal01 | 2011 | 0 | NLS201107120 | AL | 2 | 9.448968837 | 2.232548935 | 0.0 | 2 | 0.0 | 0.033349302 | 0.007879584 | 0.0 | 0.041228886 |
158 | 158 | ogandal01 | 2011 | 0 | NLS201107120 | AL | 0.0 | 0.0 | 8.67284933 | 0 | 0.667 | 0.0 | 0.0 | 0.032539447 | 0.032539447 | |
159 | 159 | joycema01 | 2011 | 0 | NLS201107120 | AL | 14.1033585 | -6.371765333 | 0.0 | 2 | 0.0 | 0.049776559 | -0.022488584 | 0.0 | 0.027287976 | |
160 | 160 | wietema01 | 2011 | 0 | NLS201107120 | AL | -4.256747922 | 16.85713757 | 0.0 | 1 | 0.0 | -0.007511908 | 0.02974789 | 0.0 | 0.022235982 | |
161 | 161 | kendrho01 | 2011 | 0 | NLS201107120 | AL | 7.305810546 | 3.489972263 | 0.0 | 1 | 0.0 | 0.012892607 | 0.006158775 | 0.0 | 0.019051381 | |
162 | 162 | perezch01 | 2011 | 0 | NLS201107120 | AL | 0.0 | 0.0 | 2.919871082 | 0 | 1.0 | 0.0 | 0.0 | 0.016424275 | 0.016424275 | |
163 | 163 | konerpa01 | 2011 | 0 | NLS201107120 | AL | 16.48263479 | -12.33066211 | 0.0 | 2 | 0.0 | 0.058174005 | -0.043519984 | 0.0 | 0.014654021 | |
164 | 164 | gonzagi01 | 2011 | 0 | NLS201107120 | AL | 0.0 | 0.0 | 6.957228549 | 0 | 0.333 | 0.0 | 0.0 | 0.013031759 | 0.013031759 | |
165 | 165 | peraljh01 | 2011 | 0 | NLS201107120 | AL | -3.704664242 | 4.564025648 | 0.0 | 2 | 0.0 | -0.013075286 | 0.016108326 | 0.0 | 0.00303304 | |
166 | 166 | ortizda01 | 2011 | 0 | NLS201107120 | AL | 0 | 11.4683505 | -10.95633507 | 0.0 | 2 | 0.0 | 0.040476531 | -0.038669418 | 0.0 | 0.001807113 |
167 | 167 | pinedmi01 | 2011 | 0 | NLS201107120 | AL | 0.0 | 0.0 | 0.041908386 | 0 | 1.0 | 0.0 | 0.0 | 0.000235735 | 0.000235735 | |
168 | 168 | waldejo01 | 2011 | 0 | NLS201107120 | AL | 0.0 | 0.0 | -0.239273713 | 0 | 1.0 | 0.0 | 0.0 | -0.001345915 | -0.001345915 | |
169 | 169 | youngmi02 | 2011 | 0 | NLS201107120 | AL | 7.183120904 | -10.96708656 | 0.0 | 1 | 0.0 | 0.012676096 | -0.019353682 | 0.0 | -0.006677586 | |
170 | 170 | leagubr01 | 2011 | 0 | NLS201107120 | AL | 0.0 | 0.0 | -2.210403119 | 0 | 1.0 | 0.0 | 0.0 | -0.012433518 | -0.012433518 | |
171 | 171 | cuddymi01 | 2011 | 0 | NLS201107120 | AL | 8.912997817 | -17.48328217 | 0.0 | 1 | 0.0 | 0.01572882 | -0.030852851 | 0.0 | -0.015124031 | |
172 | 172 | quentca01 | 2011 | 0 | NLS201107120 | AL | 7.469216739 | -15.75233897 | 0.0 | 2 | 0.0 | 0.026361941 | -0.05559649 | 0.0 | -0.029234549 | |
199 | 199 | mauerjo01 | 2009 | 0 | NLS200907140 | AL | 2 | 30.50796472 | 4.11301208 | 0.0 | 3 | 0.0 | 0.152539824 | 0.02056506 | 0.0 | 0.173104884 |
200 | 200 | hallaro01 | 2009 | 0 | NLS200907140 | AL | 1 | 0.0 | 0.0 | 15.26684483 | 0 | 2.0 | 0.0 | 0.0 | 0.152668448 | 0.152668448 |
201 | 201 | teixema01 | 2009 | 0 | NLS200907140 | AL | 3 | 27.9064565 | -1.424037157 | 0.0 | 3 | 0.0 | 0.139532283 | -0.007120186 | 0.0 | 0.132412097 |
202 | 202 | greinza01 | 2009 | 0 | NLS200907140 | AL | 0.0 | 0.0 | 25.38187665 | 0 | 1.0 | 0.0 | 0.0 | 0.126909383 | 0.126909383 | |
203 | 203 | riverma01 | 2009 | 0 | NLS200907140 | AL | 0.0 | 0.0 | 17.15800622 | 0 | 1.0 | 0.0 | 0.0 | 0.085790031 | 0.085790031 | |
204 | 204 | hillaa01 | 2009 | 0 | NLS200907140 | AL | 4 | 4.279925399 | 11.7738293 | 0.0 | 3 | 0.0 | 0.021399627 | 0.058869147 | 0.0 | 0.080268774 |
205 | 205 | suzukic01 | 2009 | 0 | NLS200907140 | AL | 9 | 14.40557118 | 0.88825214 | 0.0 | 3 | 0.0 | 0.072027856 | 0.004441261 | 0.0 | 0.076469117 |
206 | 206 | nathajo01 | 2009 | 0 | NLS200907140 | AL | 0.0 | 0.0 | 14.13005441 | 0 | 1.0 | 0.0 | 0.0 | 0.070650272 | 0.070650272 | |
207 | 207 | papeljo01 | 2009 | 0 | NLS200907140 | AL | 0.0 | 0.0 | 13.65231166 | 0 | 1.0 | 0.0 | 0.0 | 0.068261558 | 0.068261558 | |
208 | 208 | jeterde01 | 2009 | 0 | NLS200907140 | AL | 6 | 14.31804794 | -0.957088633 | 0.0 | 3 | 0.0 | 0.07159024 | -0.004785443 | 0.0 | 0.066804797 |
209 | 209 | crawfca02 | 2009 | 0 | NLS200907140 | AL | 10.9754156 | 2.075603097 | 0.0 | 3 | 0.0 | 0.054877078 | 0.010378015 | 0.0 | 0.065255093 | |
210 | 210 | buehrma01 | 2009 | 0 | NLS200907140 | AL | 0.0 | 0.0 | 12.57512652 | 0 | 1.0 | 0.0 | 0.0 | 0.062875633 | 0.062875633 | |
211 | 211 | hernafe02 | 2009 | 0 | NLS200907140 | AL | 0.0 | 0.0 | 11.45124395 | 0 | 1.0 | 0.0 | 0.0 | 0.05725622 | 0.05725622 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "mlb-allstar-teams/allstar_player_talent" ( "bbref_ID" TEXT, "yearID" INTEGER, "gameNum" INTEGER, "gameID" TEXT, "lgID" TEXT, "startingPos" INTEGER, "OFF600" REAL, "DEF600" REAL, "PITCH200" REAL, "asg_PA" INTEGER, "asg_IP" REAL, "OFFper9innASG" REAL, "DEFper9innASG" REAL, "PITper9innASG" REAL, "TOTper9innASG" REAL );