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

1,931 rows where lgID = "AL"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: gameNum, 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

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