MLB All-Star Teams: allstar_player_talent.csv

Table actions

This table contains data behind the story The Best MLB All-Star Teams Ever.

Estimates of most talented MLB All-Star teams, 1933-2015

allstar_team_talent.csv contains team talent estimates with the following headers:

Header Definition
yearID The season in question
gameNum Order of All-Star Game for the season (in years w/ multiple ASGs; set to 0 when only 1 per year)
gameID Game ID at Baseball-Reference.com
lgID League of All-Star team
tm_OFF_talent Total runs of offensive talent above average per game (36 plate appearances)
tm_DEF_talent Total runs of fielding talent above average per game (36 plate appearances)
tm_PIT_talent Total runs of pitching talent above average per game (9 innings)
MLB_avg_RPG MLB average runs scored/game that season
talent_RSPG Expected runs scored per game based on talent (MLB R/G + team OFF talent)
talent_RAPG Expected runs allowed per game based on talent (MLB R/G - team DEF talent- team PIT talent)
unadj_PYTH Unadjusted pythagorean talent rating; PYTH =(RSPG^1.83)/(RSPG^1.83+RAPG^1.83)
timeline_adj Estimate of relative league quality where 2015 MLB = 1.00
SOS Strength of schedule faced; adjusts an assumed .500 SOS downward based on timeline adjustment
adj_PYTH Adjusted pythagorean record; =(SOSunadj_Pyth)/((2unadj_Pyth*SOS)-SOS-unadj_Pyth+1)
no_1_player Best player according to combo of actual PA/IP and talent
no_2_player 2nd-best player according to combo of actual PA/IP and talent

allstar_player_talent.csv contains team player estimates with the following headers:

Header Definition
bbref_ID Player's ID at Baseball-Reference.com
yearID The season in question
gameNum Order of All-Star Game for the season (in years w/ multiple ASGs; set to 0 when only 1 per year)
gameID Game ID at Baseball-Reference.com
lgID League of All-Star team
startingPos Postion (according to baseball convention; 1=pitcher, 2=catcher, etc.) if starter
OFF600 Estimate of offensive talent, in runs above league average per 600 plate appearances
DEF600 Estimate of fielding talent, in runs above league average per 600 plate appearances
PITCH200 Estimate of pitching talent, in runs above league average per 200 innings pitched
asg_PA Number of plate appearances in the All-Star Game itself
asg_IP Number of innings pitched in the All-Star Game itself
OFFper9innASG Expected offensive runs added above average (from talent) based on PA in ASG, scaled to a 9-inning game
DEFper9innASG Expected defensive runs added above average (from talent) based on PA in ASG, scaled to a 9-inning game
PITper9innASG Expected pitching runs added above average (from talent) based on IP in ASG, scaled to a 9-inning game
TOTper9innASG Expected runs added above average (from talent) based on PA/IP in ASG, scaled to a 9-inning game

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

3,930 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ bbref_ID yearID gameNum gameID lgID startingPos OFF600 DEF600 PITCH200 asg_PA asg_IP OFFper9innASG DEFper9innASG PITper9innASG TOTper9innASG
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
113 113 hallaro01 2011 0 NLS201107120 NL 1 0.0 0.0 24.34538571 0 2.0 0.0 0.0 0.243453857 0.243453857
114 114 leecl02 2011 0 NLS201107120 NL   0.0 0.0 19.31343762 0 1.667 0.0 0.0 0.160977503 0.160977503
115 115 tulowtr01 2011 0 NLS201107120 NL 6 19.16301815 17.49129322 0.0 2 0.0 0.071861318 0.06559235 0.0 0.137453668
116 116 vottojo01 2011 0 NLS201107120 NL   35.88958903 -4.59918942 0.0 2 0.0 0.134585959 -0.01724696 0.0 0.117338999
117 117 kempma01 2011 0 NLS201107120 NL 8 25.37596005 -8.175108938 0.0 3 0.0 0.142739775 -0.045984988 0.0 0.096754787
118 118 kershcl01 2011 0 NLS201107120 NL   0.0 0.0 16.1022013 0 1.0 0.0 0.0 0.080511007 0.080511007
119 119 weeksri01 2011 0 NLS201107120 NL 4 15.48799121 -2.730136539 0.0 3 0.0 0.087119951 -0.015357018 0.0 0.071762933
120 120 uptonju01 2011 0 NLS201107120 NL   18.83261606 -0.014771112 0.0 2 0.0 0.07062231 -5.54e-05 0.0 0.070566919
121 121 beltrca01 2011 0 NLS201107120 NL 0 21.76533628 -4.519213063 0.0 2 0.0 0.081620011 -0.016947049 0.0 0.064672962
122 122 pencehu01 2011 0 NLS201107120 NL   17.13588238 -0.803201073 0.0 2 0.0 0.064259559 -0.003012004 0.0 0.061247555
123 123 rolensc01 2011 0 NLS201107120 NL 5 1.999578038 14.18877009 0.0 2 0.0 0.007498418 0.053207888 0.0 0.060706305
124 124 jurrjja01 2011 0 NLS201107120 NL   0.0 0.0 6.194421057 0 1.667 0.0 0.0 0.0516305 0.0516305
125 125 fieldpr01 2011 0 NLS201107120 NL 3 26.56729954 -13.27004361 0.0 2 0.0 0.099627373 -0.049762664 0.0 0.04986471
126 126 sandopa01 2011 0 NLS201107120 NL   17.39130858 4.992126569 0.0 1 0.0 0.032608704 0.009360237 0.0 0.041968941
127 127 mccanbr01 2011 0 NLS201107120 NL 2 6.898105768 4.124312822 0.0 2 0.0 0.025867897 0.015466173 0.0 0.04133407
128 128 hollima01 2011 0 NLS201107120 NL 7 24.66926671 -2.970826343 0.0 1 0.0 0.046254875 -0.005570299 0.0 0.040684576
129 129 mccutan01 2011 0 NLS201107120 NL   18.89080073 0.59577391 0.0 1 0.0 0.035420251 0.001117076 0.0 0.036537327
130 130 ventejo01 2011 0 NLS201107120 NL   0.0 0.0 8.499595994 0 0.667 0.0 0.0 0.028346153 0.028346153
131 131 phillbr01 2011 0 NLS201107120 NL   5.02078537 7.295901081 0.0 1 0.0 0.009413973 0.013679815 0.0 0.023093787
132 132 molinya01 2011 0 NLS201107120 NL   -3.500604043 13.66045647 0.0 1 0.0 -0.006563633 0.025613356 0.0 0.019049723
133 133 clippty01 2011 0 NLS201107120 NL   0.0 0.0 10.23779111 0 0.333 0.0 0.0 0.017045922 0.017045922
134 134 bruceja01 2011 0 NLS201107120 NL   7.896284182 0.502227133 0.0 1 0.0 0.014805533 0.000941676 0.0 0.015747209
135 135 wilsobr01 2011 0 NLS201107120 NL   0.0 0.0 4.379006264 0 0.667 0.0 0.0 0.014603986 0.014603986
136 136 berkmla01 2011 0 NLS201107120 NL 9 19.75138899 -12.74078977 0.0 1 0.0 0.037033854 -0.023888981 0.0 0.013144874
137 137 hanrajo01 2011 0 NLS201107120 NL   0.0 0.0 7.039759669 0 0.333 0.0 0.0 0.0117212 0.0117212
138 138 kimbrcr01 2011 0 NLS201107120 NL   0.0 0.0 6.181542059 0 0.333 0.0 0.0 0.010292268 0.010292268
139 139 castrst01 2011 0 NLS201107120 NL   4.183514633 0.075908508 0.0 1 0.0 0.00784409 0.000142328 0.0 0.007986418
140 140 ethiean01 2011 0 NLS201107120 NL   11.77153736 -8.379707384 0.0 1 0.0 0.022071633 -0.015711951 0.0 0.006359681
141 141 bellhe01 2011 0 NLS201107120 NL   0.0 0.0 3.800850729 0 0.333 0.0 0.0 0.006328416 0.006328416
142 142 montemi01 2011 0 NLS201107120 NL   4.007291287 10.07138704 0.0 0 0.0 0.0 0.0 0.0 0.0
143 143 sanchga01 2011 0 NLS201107120 NL   4.247945866 -6.802700781 0.0 1 0.0 0.007964898 -0.012755064 0.0 -0.004790165
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
173 173 pujolal01 2009 0 NLS200907140 NL 3 45.58625441 8.495816577 0.0 3 0.0 0.248652297 0.046340818 0.0 0.294993114
174 174 linceti01 2009 0 NLS200907140 NL 1 0.0 0.0 21.18482474 0 2.0 0.0 0.0 0.211848247 0.211848247
175 175 ramirha01 2009 0 NLS200907140 NL 6 34.19939353 0.385439402 0.0 3 0.0 0.186542147 0.002102397 0.0 0.188644543
176 176 utleych01 2009 0 NLS200907140 NL 4 29.63289698 16.62816179 0.0 2 0.0 0.107755989 0.060466043 0.0 0.168222032
177 177 wrighda03 2009 0 NLS200907140 NL 5 26.91391573 0.548753971 0.0 2 0.0 0.097868784 0.001995469 0.0 0.099864253
178 178 zimmery01 2009 0 NLS200907140 NL   11.86255364 15.34891289 0.0 2 0.0 0.043136559 0.055814229 0.0 0.098950787
179 179 harenda01 2009 0 NLS200907140 NL   0.0 0.0 16.76076276 0 1.0 0.0 0.0 0.083803814 0.083803814
180 180 braunry02 2009 0 NLS200907140 NL 9 31.36811556 -9.012681301 0.0 2 0.0 0.114065875 -0.032773387 0.0 0.081292488
181 181 victosh01 2009 0 NLS200907140 NL 8 9.096773788 5.273754314 0.0 2 0.0 0.033079177 0.019177288 0.0 0.052256466
182 182 hudsoor01 2009 0 NLS200907140 NL   5.103076882 8.00538696 0.0 2 0.0 0.018556643 0.029110498 0.0 0.047667141
183 183 hoffmtr01 2009 0 NLS200907140 NL   0.0 0.0 7.619243468 0 1.0 0.0 0.0 0.038096217 0.038096217
184 184 werthja01 2009 0 NLS200907140 NL   19.32194642 0.651104279 0.0 1 0.0 0.035130812 0.001183826 0.0 0.036314638
185 185 gonzaad01 2009 0 NLS200907140 NL   22.5704326 -3.446992167 0.0 1 0.0 0.04103715 -0.006267258 0.0 0.034769892
186 186 frankry01 2009 0 NLS200907140 NL   0.0 0.0 6.906596378 0 1.0 0.0 0.0 0.034532982 0.034532982
187 187 cordefr01 2009 0 NLS200907140 NL   0.0 0.0 6.282308165 0 1.0 0.0 0.0 0.031411541 0.031411541
188 188 fieldpr01 2009 0 NLS200907140 NL   27.80972941 -12.00790433 0.0 1 0.0 0.050563144 -0.021832553 0.0 0.028730591
189 189 mccanbr01 2009 0 NLS200907140 NL   9.140459698 6.155693375 0.0 1 0.0 0.016619018 0.01119217 0.0 0.027811187
190 190 uptonju01 2009 0 NLS200907140 NL   9.270154532 -2.086543521 0.0 2 0.0 0.033709653 -0.007587431 0.0 0.026122222
191 191 molinya01 2009 0 NLS200907140 NL 2 -8.904718741 15.68099662 0.0 2 0.0 -0.032380795 0.057021806 0.0 0.02464101
192 192 bellhe01 2009 0 NLS200907140 NL   0.0 0.0 4.908224521 0 1.0 0.0 0.0 0.024541123 0.024541123
193 193 billich01 2009 0 NLS200907140 NL   0.0 0.0 2.765197542 0 1.0 0.0 0.0 0.013825988 0.013825988
194 194 howarry01 2009 0 NLS200907140 NL   15.15056232 -9.934215533 0.0 1 0.0 0.027546477 -0.01806221 0.0 0.009484267
195 195 rodrifr03 2009 0 NLS200907140 NL   0.0 0.0 0.779599272 0 1.0 0.0 0.0 0.003897996 0.003897996
196 196 ibanera01 2009 0 NLS200907140 NL 7 10.40356564 -11.89587866 0.0 2 0.0 0.037831148 -0.043257741 0.0 -0.005426593
197 197 tejadmi01 2009 0 NLS200907140 NL   -4.105198366 0.181268714 0.0 2 0.0 -0.014927994 0.000659159 0.0 -0.014268835
198 198 hawpebr01 2009 0 NLS200907140 NL   13.83524256 -21.71989219 0.0 2 0.0 0.050309973 -0.078981426 0.0 -0.028671453
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);