MLB All-Star Teams: allstar_team_talent.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
172 rows
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | yearID | gameNum | gameID | lgID | tm_OFF_talent | tm_DEF_talent | tm_PIT_talent | MLB_avg_RPG | talent_RSPG | talent_RAPG | unadj_PYTH | timeline_adj | SOS | adj_PYTH | no_1_player | no_2_player |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | 1949 | 0 | NLS194907120 | NL | 1.181951648 | 0.067845848 | 0.256855894 | 4.61 | 5.791951648 | 4.285298258 | 0.634446622 | 0.812322275 | 0.406161137 | 0.542765955 | musiast01 | kinerra01 |
102 | 102 | 2006 | 0 | NLS200607110 | NL | 1.111767124 | 0.069504701 | 0.363751065 | 4.86 | 5.971767124 | 4.426744234 | 0.633639571 | 0.974407583 | 0.487203791 | 0.621675663 | pujolal01 | beltrca01 |
103 | 103 | 2005 | 0 | ALS200507120 | NL | 0.822417467 | 0.045980764 | 0.531435294 | 4.59 | 5.412417467 | 4.012583942 | 0.633589412 | 0.971563981 | 0.485781991 | 0.62028527 | pujolal01 | clemero02 |
104 | 104 | 1941 | 0 | ALS194107080 | NL | 0.865196605 | 0.10929283 | 0.4096847 | 4.49 | 5.355196605 | 3.971022471 | 0.633497374 | 0.78957346 | 0.39478673 | 0.529967776 | mizejo01 | reisepe01 |
105 | 105 | 1980 | 0 | NLS198007080 | AL | 0.919098976 | 0.202455 | 0.217784423 | 4.29 | 5.209098976 | 3.869760577 | 0.632719677 | 0.900473934 | 0.450236967 | 0.585207672 | randowi01 | lynnfr01 |
106 | 106 | 1984 | 0 | NLS198407100 | NL | 0.77360128 | 0.238656636 | 0.27311109 | 4.26 | 5.03360128 | 3.748232274 | 0.631714239 | 0.911848341 | 0.455924171 | 0.5897219 | cartega01 | murphda05 |
107 | 107 | 2007 | 0 | NLS200707100 | AL | 0.993807056 | -0.062614289 | 0.540712042 | 4.8 | 5.793807056 | 4.321902247 | 0.630965708 | 0.977251185 | 0.488625592 | 0.620308172 | rodrial01 | beckejo02 |
108 | 108 | 2003 | 0 | ALS200307150 | AL | 1.012007575 | -0.088960608 | 0.532143069 | 4.73 | 5.742007575 | 4.286817539 | 0.6306121 | 0.965876777 | 0.482938389 | 0.61457176 | rodrial01 | muldema01 |
109 | 109 | 1951 | 0 | ALS195107100 | AL | 0.880162578 | 0.089970399 | 0.399959939 | 4.55 | 5.430162578 | 4.060069662 | 0.62997444 | 0.818009479 | 0.409004739 | 0.540914786 | willite01 | garvene01 |
110 | 110 | 1993 | 0 | ALS199307130 | NL | 1.147892873 | 0.019452419 | 0.27705077 | 4.6 | 5.747892873 | 4.303496811 | 0.629392596 | 0.937440758 | 0.468720379 | 0.599727505 | bondsba01 | larkiba01 |
111 | 111 | 2007 | 0 | NLS200707100 | NL | 0.849330444 | 0.116085763 | 0.4379631 | 4.8 | 5.649330444 | 4.245951137 | 0.627754423 | 0.977251185 | 0.488625592 | 0.617060432 | wrighda03 | beltrca01 |
112 | 112 | 1953 | 0 | NLS195307140 | AL | 1.007655214 | 0.007180682 | 0.368985626 | 4.61 | 5.617655214 | 4.233833693 | 0.62657138 | 0.823696682 | 0.411848341 | 0.54021449 | rosenal01 | piercbi02 |
113 | 113 | 1989 | 0 | ALS198907110 | NL | 0.947211831 | 0.054290532 | 0.246876623 | 4.13 | 5.077211831 | 3.828832846 | 0.626312627 | 0.926066351 | 0.463033175 | 0.59104632 | smithoz01 | mitchke01 |
114 | 114 | 2005 | 0 | ALS200507120 | AL | 1.091657733 | -0.105425984 | 0.408796719 | 4.59 | 5.681657733 | 4.286629265 | 0.626115628 | 0.971563981 | 0.485781991 | 0.612705997 | rodrial01 | guerrvl01 |
115 | 115 | 1950 | 0 | ALS195007110 | NL | 1.092985317 | 0.034095825 | 0.331172787 | 4.85 | 5.942985317 | 4.484731388 | 0.626025937 | 0.815165877 | 0.407582938 | 0.535251149 | musiast01 | kinerra01 |
116 | 116 | 1963 | 0 | ALS196307090 | NL | 0.88756209 | 0.092708553 | 0.199336252 | 3.95 | 4.83756209 | 3.657955196 | 0.625157355 | 0.852132701 | 0.426066351 | 0.553192541 | mayswi01 | aaronha01 |
117 | 117 | 2006 | 0 | NLS200607110 | AL | 0.905363805 | -0.085897899 | 0.580961904 | 4.86 | 5.765363805 | 4.364935995 | 0.624624652 | 0.974407583 | 0.487203791 | 0.612546365 | hallaro01 | rodrial01 |
118 | 118 | 1943 | 0 | ALS194307130 | NL | 0.794005405 | 0.123842774 | 0.224699702 | 3.91 | 4.704005405 | 3.561457524 | 0.624615963 | 0.795260664 | 0.397630332 | 0.523442509 | musiast01 | coopemo01 |
119 | 119 | 1971 | 0 | ALS197107130 | NL | 1.030777335 | -0.008171438 | 0.171504847 | 3.89 | 4.920777335 | 3.726666591 | 0.624490608 | 0.874881517 | 0.437440758 | 0.563922696 | benchjo01 | clemero01 |
120 | 120 | 1971 | 0 | ALS197107130 | AL | 0.828100477 | -0.010847288 | 0.32216181 | 3.89 | 4.718100477 | 3.578685478 | 0.623828805 | 0.874881517 | 0.437440758 | 0.563228806 | yastrca01 | bluevi01 |
121 | 121 | 1979 | 0 | ALS197907170 | AL | 0.901764275 | 0.094497835 | 0.298045199 | 4.46 | 5.361764275 | 4.067456966 | 0.623770557 | 0.897630332 | 0.448815166 | 0.574472919 | brettge01 | riceji01 |
122 | 122 | 1955 | 0 | NLS195507120 | NL | 1.075505854 | 0.120145173 | 0.143005516 | 4.48 | 5.555505854 | 4.216849311 | 0.623524074 | 0.829383886 | 0.414691943 | 0.539897722 | mayswi01 | musiast01 |
123 | 123 | 1991 | 0 | ALS199107090 | AL | 0.888755261 | 0.091358562 | 0.272433051 | 4.31 | 5.198755261 | 3.946208387 | 0.623508079 | 0.931753555 | 0.465876777 | 0.590917542 | ripkeca01 | griffke02 |
124 | 124 | 1933 | 0 | ALS193307060 | NL | 0.853086062 | -0.060718015 | 0.491376914 | 4.48 | 5.333086062 | 4.049341101 | 0.623384301 | 0.766824645 | 0.383412322 | 0.50721158 | warnelo01 | kleinch01 |
125 | 125 | 1936 | 0 | NLS193607070 | NL | 0.743305418 | 0.124014205 | 0.56054366 | 5.19 | 5.933305418 | 4.505442135 | 0.623349732 | 0.77535545 | 0.387677725 | 0.511674452 | hubbeca01 | medwijo01 |
126 | 126 | 1958 | 0 | ALS195807080 | AL | 1.054736708 | 0.07521514 | 0.150704633 | 4.28 | 5.334736708 | 4.054080228 | 0.623014653 | 0.837914692 | 0.418957346 | 0.543715265 | mantlmi01 | willite01 |
127 | 127 | 1996 | 0 | NLS199607090 | AL | 0.953760032 | 0.11395765 | 0.371048959 | 5.04 | 5.993760032 | 4.554993391 | 0.623005696 | 0.945971564 | 0.472985782 | 0.597284546 | belleal01 | nagych01 |
128 | 128 | 1934 | 0 | NLS193407100 | NL | 0.76890817 | 0.02850947 | 0.560984263 | 4.91 | 5.67890817 | 4.320506267 | 0.622529153 | 0.769668246 | 0.384834123 | 0.507803757 | deandi01 | hubbeca01 |
129 | 129 | 1962 | 2 | NLS196207300 | AL | 0.70912504 | 0.112984239 | 0.410426245 | 4.46 | 5.16912504 | 3.936589515 | 0.622100016 | 0.8492891 | 0.42464455 | 0.548530669 | aguirha01 | marisro01 |
130 | 130 | 1948 | 0 | ALS194807130 | NL | 0.823239738 | 0.080752826 | 0.377922818 | 4.58 | 5.403239738 | 4.121324356 | 0.621426695 | 0.809478673 | 0.404739336 | 0.527435434 | musiast01 | mizejo01 |
131 | 131 | 1957 | 0 | NLS195707090 | NL | 1.191538345 | 0.107074888 | 0.001292478 | 4.31 | 5.501538345 | 4.201632634 | 0.620879961 | 0.83507109 | 0.417535545 | 0.540010867 | mayswi01 | aaronha01 |
132 | 132 | 1962 | 1 | ALS196207100 | NL | 0.724825442 | 0.221193811 | 0.277471058 | 4.46 | 5.184825442 | 3.961335131 | 0.620707845 | 0.8492891 | 0.42464455 | 0.547064799 | mayswi01 | drysddo01 |
133 | 133 | 1959 | 2 | NLS195908030 | AL | 0.835815596 | 0.245427459 | 0.146355988 | 4.38 | 5.215815596 | 3.988216553 | 0.620361506 | 0.840758294 | 0.420379147 | 0.542364622 | mantlmi01 | foxne01 |
134 | 134 | 1935 | 0 | ALS193507080 | NL | 1.058475556 | 0.081320827 | 0.261973613 | 4.9 | 5.958475556 | 4.556705561 | 0.620302654 | 0.772511848 | 0.386255924 | 0.506938347 | vaughar01 | ottme01 |
135 | 135 | 1970 | 0 | NLS197007140 | NL | 1.056918818 | -0.126728512 | 0.339315546 | 4.34 | 5.396918818 | 4.127412966 | 0.620286542 | 0.872037915 | 0.436018957 | 0.558093875 | gibsobo01 | seaveto01 |
136 | 136 | 1973 | 0 | ALS197307240 | AL | 0.814405249 | 0.151333651 | 0.212841519 | 4.21 | 5.024405249 | 3.84582483 | 0.619916482 | 0.88056872 | 0.44028436 | 0.561976057 | jacksre01 | murcebo01 |
137 | 137 | 1966 | 0 | NLS196607120 | AL | 0.839238216 | 0.15041359 | 0.141997924 | 3.99 | 4.829238216 | 3.697588486 | 0.619782331 | 0.860663507 | 0.430331754 | 0.551844665 | robinfr02 | olivato01 |
138 | 138 | 1944 | 0 | NLS194407110 | AL | 0.699923788 | 0.067698078 | 0.372859987 | 4.17 | 4.869923788 | 3.729441935 | 0.619701164 | 0.798104265 | 0.399052133 | 0.519705761 | doerrbo01 | johnsbo01 |
139 | 139 | 1979 | 0 | ALS197907170 | NL | 0.957583375 | 0.105601735 | 0.169622812 | 4.46 | 5.417583375 | 4.184775453 | 0.615975335 | 0.897630332 | 0.448815166 | 0.566366351 | parkeda01 | winfida01 |
140 | 140 | 1962 | 1 | ALS196207100 | AL | 0.746446677 | 0.076326062 | 0.353445397 | 4.46 | 5.206446677 | 4.030228541 | 0.615056217 | 0.8492891 | 0.42464455 | 0.541127073 | pascuca02 | mantlmi01 |
141 | 141 | 1987 | 0 | ALS198707140 | NL | 0.830574561 | 0.037266519 | 0.385429192 | 4.72 | 5.550574561 | 4.297304289 | 0.614986463 | 0.920379147 | 0.460189573 | 0.576578233 | daviser01 | raineti01 |
142 | 142 | 2000 | 0 | NLS200007110 | AL | 1.098238392 | 0.019877895 | 0.284482023 | 5.14 | 6.238238392 | 4.835640082 | 0.614453707 | 0.957345972 | 0.478672986 | 0.594044931 | rodriiv01 | jeterde01 |
143 | 143 | 1995 | 0 | ALS199507110 | NL | 1.25251296 | -0.034988166 | 0.152659646 | 4.85 | 6.10251296 | 4.73232852 | 0.614279826 | 0.943127962 | 0.471563981 | 0.586974357 | bondsba01 | piazzmi01 |
144 | 144 | 1942 | 0 | NLS194207060 | NL | 0.630615188 | 0.07345551 | 0.351797845 | 4.08 | 4.710615188 | 3.654746645 | 0.614066673 | 0.792417062 | 0.396208531 | 0.510785991 | coopemo01 | ottme01 |
145 | 145 | 1991 | 0 | ALS199107090 | NL | 0.690815705 | 0.01222347 | 0.416390065 | 4.31 | 5.000815705 | 3.881386465 | 0.613900502 | 0.931753555 | 0.465876777 | 0.581037132 | glavito02 | sandbry01 |
146 | 146 | 1987 | 0 | ALS198707140 | AL | 0.867274713 | -0.004033881 | 0.36992878 | 4.72 | 5.587274713 | 4.3541051 | 0.612148353 | 0.920379147 | 0.460189573 | 0.573653277 | saberbr01 | boggswa01 |
147 | 147 | 1962 | 2 | NLS196207300 | NL | 0.813652128 | 0.15244888 | 0.196698064 | 4.46 | 5.273652128 | 4.110853056 | 0.612026701 | 0.8492891 | 0.42464455 | 0.537952814 | robinfr02 | mayswi01 |
148 | 148 | 1989 | 0 | ALS198907110 | AL | 0.706172281 | -0.029731933 | 0.389057064 | 4.13 | 4.836172281 | 3.770674869 | 0.611929795 | 0.926066351 | 0.463033175 | 0.576224544 | boggswa01 | puckeki01 |
149 | 149 | 1959 | 1 | NLS195907070 | AL | 0.721370095 | 0.19334726 | 0.198328104 | 4.38 | 5.101370095 | 3.988324636 | 0.610742025 | 0.840758294 | 0.420379147 | 0.532258928 | foxne01 | minosmi01 |
150 | 150 | 1952 | 0 | NLS195207080 | AL | 0.769717932 | 0.085275109 | 0.215571552 | 4.18 | 4.949717932 | 3.879153339 | 0.609686832 | 0.820853081 | 0.41042654 | 0.520936166 | berrayo01 | rosenal01 |
151 | 151 | 1981 | 0 | ALS198108090 | NL | 0.643005302 | 0.143997339 | 0.216713894 | 4.0 | 4.643005302 | 3.639288767 | 0.609625823 | 0.903317536 | 0.451658768 | 0.562611823 | schmimi01 | dawsoan01 |
152 | 152 | 2008 | 0 | ALS200807150 | AL | 0.819394846 | -0.068336185 | 0.430184796 | 4.65 | 5.469394846 | 4.288151389 | 0.609512005 | 0.980094787 | 0.490047393 | 0.59999535 | sizemgr01 | riverma01 |
153 | 153 | 2011 | 0 | NLS201107120 | AL | 0.889299366 | -0.0371737 | 0.257155678 | 4.28 | 5.169299366 | 4.060018022 | 0.608744071 | 0.988625592 | 0.494312796 | 0.603312441 | bautijo02 | beltrad01 |
154 | 154 | 2010 | 0 | ALS201007130 | AL | 0.772858383 | -0.023845724 | 0.35279753 | 4.38 | 5.152858383 | 4.051048194 | 0.608319539 | 0.985781991 | 0.492890995 | 0.601523244 | hamiljo03 | longoev01 |
155 | 155 | 1940 | 0 | NLS194007090 | NL | 0.691021887 | 0.114941007 | 0.333660737 | 4.68 | 5.371021887 | 4.231398256 | 0.60740776 | 0.786729858 | 0.393364929 | 0.500809789 | vaughar01 | mizejo01 |
156 | 156 | 1961 | 1 | NLS196107110 | NL | 0.952127881 | 0.076918831 | 0.13131251 | 4.53 | 5.482127881 | 4.321768659 | 0.607120974 | 0.846445498 | 0.423222749 | 0.531375922 | mayswi01 | boyerke01 |
157 | 157 | 2004 | 0 | NLS200407130 | AL | 0.993094427 | -0.113571899 | 0.338923456 | 4.81 | 5.803094427 | 4.584648443 | 0.606181786 | 0.968720379 | 0.48436019 | 0.591147436 | rodrial01 | suzukic01 |
158 | 158 | 1949 | 0 | NLS194907120 | AL | 0.891048042 | 0.092629672 | 0.171303668 | 4.61 | 5.501048042 | 4.34606666 | 0.606177215 | 0.812322275 | 0.406161137 | 0.512850499 | willite01 | dimagjo01 |
159 | 159 | 1961 | 2 | ALS196107310 | NL | 0.91978178 | 0.05325322 | 0.157168374 | 4.53 | 5.44978178 | 4.319578406 | 0.604756652 | 0.846445498 | 0.423222749 | 0.528909468 | mayswi01 | matheed01 |
160 | 160 | 1950 | 0 | ALS195007110 | AL | 0.92905268 | 0.107794343 | 0.159934797 | 4.85 | 5.77905268 | 4.58227086 | 0.604593622 | 0.815165877 | 0.407582938 | 0.512666302 | dobyla01 | willite01 |
161 | 161 | 2002 | 0 | NLS200207090 | AL | 0.615927988 | 0.021489748 | 0.405138657 | 4.62 | 5.235927988 | 4.193371594 | 0.600207888 | 0.963033175 | 0.481516588 | 0.58233447 | lowede01 | rodrial01 |
162 | 162 | 1960 | 2 | ALS196007130 | AL | 0.743714443 | 0.161444992 | 0.095169164 | 4.31 | 5.053714443 | 4.053385844 | 0.599563062 | 0.843601896 | 0.421800948 | 0.522050735 | mantlmi01 | marisro01 |
163 | 163 | 1965 | 0 | ALS196507130 | AL | 0.651975846 | 0.025031354 | 0.239774738 | 3.99 | 4.641975846 | 3.725193908 | 0.599321493 | 0.857819905 | 0.428909953 | 0.529051962 | killeha01 | mcdowsa01 |
164 | 164 | 1938 | 0 | NLS193807060 | NL | 0.887139856 | 0.07783231 | 0.147711346 | 4.89 | 5.777139856 | 4.664456344 | 0.596645068 | 0.781042654 | 0.390521327 | 0.486599244 | ottme01 | medwijo01 |
165 | 165 | 1963 | 0 | ALS196307090 | AL | 0.329206841 | 0.173255338 | 0.279704264 | 3.95 | 4.279206841 | 3.497040398 | 0.591310779 | 0.852132701 | 0.426066351 | 0.517859401 | kalinal01 | radatdi01 |
166 | 166 | 1980 | 0 | NLS198007080 | NL | 0.568958034 | -0.005197667 | 0.254886431 | 4.29 | 4.858958034 | 4.040311236 | 0.583616941 | 0.900473934 | 0.450236967 | 0.534426914 | hernake01 | suttebr01 |
167 | 167 | 1988 | 0 | NLS198807120 | NL | 0.609527297 | -0.023760211 | 0.197196157 | 4.14 | 4.749527297 | 3.966564055 | 0.581677884 | 0.923222749 | 0.461611374 | 0.543839089 | strawda01 | smithoz01 |
168 | 168 | 1943 | 0 | ALS194307130 | AL | 0.565686742 | -0.021919415 | 0.164706943 | 3.91 | 4.475686742 | 3.767212472 | 0.578191518 | 0.795260664 | 0.397630332 | 0.475022114 | hughste01 | doerrbo01 |
169 | 169 | 1985 | 0 | ALS198507160 | NL | 0.597254468 | 0.124281927 | 0.04063967 | 4.33 | 4.927254468 | 4.165078403 | 0.576281198 | 0.914691943 | 0.457345972 | 0.534070591 | smithoz01 | murphda05 |
170 | 170 | 1948 | 0 | ALS194807130 | AL | 0.538847851 | 0.145904353 | 0.089844679 | 4.58 | 5.118847851 | 4.344250968 | 0.574505863 | 0.809478673 | 0.404739336 | 0.478638756 | boudrlo01 | henrito01 |
171 | 171 | 1960 | 1 | ALS196007110 | AL | 0.628671217 | 0.08881624 | -0.01157894 | 4.31 | 4.938671217 | 4.2327627 | 0.570100642 | 0.843601896 | 0.421800948 | 0.491720033 | mantlmi01 | marisro01 |
172 | 172 | 1946 | 0 | ALS194607090 | NL | 0.435360098 | 0.064558439 | 0.130359685 | 4.01 | 4.445360098 | 3.815081876 | 0.569498347 | 0.803791469 | 0.401895735 | 0.470592058 | musiast01 | kurowwh01 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "mlb-allstar-teams/allstar_team_talent" ( "yearID" INTEGER, "gameNum" INTEGER, "gameID" TEXT, "lgID" TEXT, "tm_OFF_talent" REAL, "tm_DEF_talent" REAL, "tm_PIT_talent" REAL, "MLB_avg_RPG" REAL, "talent_RSPG" REAL, "talent_RAPG" REAL, "unadj_PYTH" REAL, "timeline_adj" REAL, "SOS" REAL, "adj_PYTH" REAL, "no_1_player" TEXT, "no_2_player" TEXT );