home / fivethirtyeight

MLB All-Star Teams: allstar_player_talent.csv

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

3,930 rows

View and edit SQL

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
1 goldspa01 2015 0 NLS201507140 NL 3 36.75572404 -0.11721352199999999 0.0 3 0.0 0.18377862 -0.000586068 0.0 0.183192553
2 mccutan01 2015 0 NLS201507140 NL 8 33.67616805 -0.168658418 0.0 3 0.0 0.16838084 -0.0008432919999999999 0.0 0.167537548
3 harpebr03 2015 0 NLS201507140 NL 9 30.92545388 1.3829693719999998 0.0 3 0.0 0.154627269 0.006914846999999999 0.0 0.16154211599999999
4 greinza01 2015 0 NLS201507140 NL 1 0.0 0.0 15.64561093 0 2.0 0.0 0.0 0.156456109 0.156456109
5 poseybu01 2015 0 NLS201507140 NL 2 21.69296916 7.59554639 0.0 2 0.0 0.072309897 0.025318487999999997 0.0 0.097628385
6 frazito01 2015 0 NLS201507140 NL 5 14.53426139 4.787243006000001 0.0 3 0.0 0.072671307 0.023936215 0.0 0.09660752199999999
7 rizzoan01 2015 0 NLS201507140 NL 0 22.17114817 0.670664775 0.0 2 0.0 0.073903827 0.002235549 0.0 0.076139376
8 kershcl01 2015 0 NLS201507140 NL   0.0 0.0 14.69587484 0 1.0 0.0 0.0 0.073479374 0.073479374
9 peraljh01 2015 0 NLS201507140 NL 6 7.193125866 10.38504755 0.0 2 0.0 0.023977086 0.034616825 0.0 0.058593911
10 crawfbr01 2015 0 NLS201507140 NL   2.372143139 13.07962617 0.0 2 0.0 0.007907144 0.043598754 0.0 0.051505898
11 degroja01 2015 0 NLS201507140 NL   0.0 0.0 9.670052969 0 1.0 0.0 0.0 0.048350265 0.048350265
12 polloaj01 2015 0 NLS201507140 NL   13.55430376 14.748542800000001 0.0 1 0.0 0.022590506 0.024580905 0.0 0.047171410999999996
13 tulowtr01 2015 0 NLS201507140 NL   19.62542057 8.049826759 0.0 1 0.0 0.032709034 0.013416378 0.0 0.046125412000000005
14 arenano01 2015 0 NLS201507140 NL   4.151574702 22.3198544 0.0 1 0.0 0.006919291 0.037199757 0.0 0.044119049
15 melanma01 2015 0 NLS201507140 NL   0.0 0.0 8.36372438 0 1.0 0.0 0.0 0.041818622 0.041818622
16 chapmar01 2015 0 NLS201507140 NL   0.0 0.0 7.730133295 0 1.0 0.0 0.0 0.038650666 0.038650666
17 rodrifr03 2015 0 NLS201507140 NL   0.0 0.0 7.605978192 0 1.0 0.0 0.0 0.038029891 0.038029891
18 panikjo01 2015 0 NLS201507140 NL   8.338986979 1.7931204669999998 0.0 2 0.0 0.027796623 0.005977068 0.0 0.033773691
19 bryankr01 2015 0 NLS201507140 NL   9.858185237999999 -0.7896018340000001 0.0 2 0.0 0.032860617 -0.0026320059999999997 0.0 0.030228611000000002
20 bumgama01 2015 0 NLS201507140 NL   0.0 0.0 4.773869255 0 1.0 0.0 0.0 0.023869346 0.023869346
21 molinya01 2015 0 NLS201507140 NL   -1.401576855 15.00442152 0.0 1 0.0 -0.002335961 0.025007368999999998 0.0 0.022671407999999997
22 colege01 2015 0 NLS201507140 NL   0.0 0.0 4.063585062 0 1.0 0.0 0.0 0.020317925 0.020317925
23 uptonju01 2015 0 NLS201507140 NL   15.79394445 -3.6487258110000003 0.0 1 0.0 0.026323241 -0.00608121 0.0 0.020242031
24 gonzaad01 2015 0 NLS201507140 NL   10.73627332 1.379488667 0.0 1 0.0 0.017893789 0.002299148 0.0 0.020192937
25 pederjo01 2015 0 NLS201507140 NL 7 3.696578417 1.397402342 0.0 2 0.0 0.012321928000000001 0.004658008 0.0 0.016979936
26 grandya01 2015 0 NLS201507140 NL   10.50556912 -2.937029926 0.0 1 0.0 0.017509282 -0.00489505 0.0 0.012614232
27 lemahdj01 2015 0 NLS201507140 NL 4 -12.17119639 14.98804875 0.0 2 0.0 -0.040570655 0.049960162 0.0 0.009389508000000001
28 braunry02 2015 0 NLS201507140 NL   11.95682091 -7.153399742 0.0 1 0.0 0.019928035 -0.011922333 0.0 0.008005702
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 cainlo01 2015 0 NLS201507140 AL 9 5.858901822000001 19.86794018 0.0 3 0.0 0.027752693 0.094111296 0.0 0.121863988
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 donaljo02 2015 0 NLS201507140 AL 5 19.12438229 12.85819769 0.0 2 0.0 0.060392786 0.040604835 0.0 0.100997621
33 machama01 2015 0 NLS201507140 AL   11.89500486 18.31611284 0.0 2 0.0 0.037563173 0.057840355999999996 0.0 0.09540353
34 hernafe02 2015 0 NLS201507140 AL   0.0 0.0 13.68661117 0 1.0 0.0 0.0 0.06843305599999999 0.06843305599999999
35 betande01 2015 0 NLS201507140 AL   0.0 0.0 10.51321504 0 1.0 0.0 0.0 0.052566075 0.052566075
36 gardnbr01 2015 0 NLS201507140 AL   12.80781841 1.336028519 0.0 2 0.0 0.040445742 0.004219037 0.0 0.04466478
37 jonesad01 2015 0 NLS201507140 AL 7 10.53875953 2.682464564 0.0 2 0.0 0.033280292999999996 0.008470941 0.0 0.041751234
38 perezsa02 2015 0 NLS201507140 AL 2 -2.533871697 15.63544474 0.0 2 0.0 -0.008001699999999999 0.049375089000000004 0.0 0.041373388999999997
39 priceda01 2015 0 NLS201507140 AL   0.0 0.0 7.869745063 0 1.0 0.0 0.0 0.039348725 0.039348725
40 perkigl01 2015 0 NLS201507140 AL   0.0 0.0 7.684233817000001 0 1.0 0.0 0.0 0.038421169 0.038421169
41 daviswa01 2015 0 NLS201507140 AL   0.0 0.0 7.568068633999999 0 1.0 0.0 0.0 0.037840343 0.037840343
42 archech01 2015 0 NLS201507140 AL   0.0 0.0 5.405436997000001 0 1.3330000000000002 0.0 0.0 0.036027237999999996 0.036027237999999996
43 martiru01 2015 0 NLS201507140 AL   8.472729454 12.95907107 0.0 1 0.0 0.013377993999999999 0.020461691 0.0 0.033839685
44 altuvjo01 2015 0 NLS201507140 AL 4 8.917639485 1.3888149230000002 0.0 2 0.0 0.028160967000000002 0.0043857309999999995 0.0 0.032546698
45 cruzne02 2015 0 NLS201507140 AL 0 17.87237529 -9.002923165 0.0 2 0.0 0.05643908 -0.028430284 0.0 0.028008796000000002
46 pujolal01 2015 0 NLS201507140 AL 3 9.859501597000001 -5.29621644 0.0 3 0.0 0.046702902000000004 -0.025087341000000003 0.0 0.021615561000000002
47 kipnija01 2015 0 NLS201507140 AL   13.8838169 -0.322665407 0.0 1 0.0 0.021921816 -0.000509472 0.0 0.021412344
48 brittza01 2015 0 NLS201507140 AL   0.0 0.0 6.354951044 0 0.667 0.0 0.0 0.021193762 0.021193762
49 doziebr01 2015 0 NLS201507140 AL   9.096503426 4.1387151289999995 0.0 1 0.0 0.0143629 0.006534813 0.0 0.020897713999999998
50 martijd02 2015 0 NLS201507140 AL   15.96245909 -7.676506516 0.0 1 0.0 0.025203883 -0.0121208 0.0 0.013083083
51 vogtst01 2015 0 NLS201507140 AL   7.336364395 0.538745787 0.0 1 0.0 0.011583733 0.000850651 0.0 0.012434384
52 holtbr01 2015 0 NLS201507140 AL   6.348839212000001 0.63514577 0.0 1 0.0 0.010024483 0.001002862 0.0 0.011027345
53 iglesjo01 2015 0 NLS201507140 AL   -1.62677861 4.65610196 0.0 2 0.0 -0.005137196 0.01470348 0.0 0.009566284
54 moustmi01 2015 0 NLS201507140 AL   -8.244947262 2.311793635 0.0 0 0.0 0.0 0.0 0.0 0.0
55 teixema01 2015 0 NLS201507140 AL   1.503351193 -2.774522189 0.0 2 0.0 0.004747425 -0.008761649 0.0 -0.004014224
56 escobal02 2015 0 NLS201507140 AL 6 -10.60471541 7.377942818999999 0.0 2 0.0 -0.033488575 0.023298767 0.0 -0.010189808
57 fieldpr01 2015 0 NLS201507140 AL   10.17888542 -14.08814163 0.0 2 0.0 0.032143849 -0.044488868 0.0 -0.01234502
58 wrighda03 2013 0 NLS201307160 NL 5 22.33806657 6.610164471 0.0 3 0.0 0.129704903 0.038381599999999995 0.0 0.168086503
59 mccutan01 2013 0 NLS201307160 NL   31.82050161 4.206932741 0.0 2 0.0 0.123176135 0.016284901 0.0 0.13946103599999998
60 vottojo01 2013 0 NLS201307160 NL 3 32.62009308 -1.941205775 0.0 2 0.0 0.12627132800000002 -0.007514345 0.0 0.11875698300000001
61 harvema01 2013 0 NLS201307160 NL 1 0.0 0.0 11.573843400000001 0 2.0 0.0 0.0 0.115738434 0.115738434
62 molinya01 2013 0 NLS201307160 NL 2 13.24493862 14.95291802 0.0 2 0.0 0.05127073 0.057882262999999996 0.0 0.109152993
63 kershcl01 2013 0 NLS201307160 NL   0.0 0.0 19.2235995 0 1.0 0.0 0.0 0.096117997 0.096117997
64 tulowtr01 2013 0 NLS201307160 NL 6 15.22694025 8.537136659 0.0 2 0.0 0.058942995 0.033046981 0.0 0.091989975
65 leecl02 2013 0 NLS201307160 NL   0.0 0.0 18.04254459 0 1.0 0.0 0.0 0.09021272300000001 0.09021272300000001
66 goldspa01 2013 0 NLS201307160 NL   23.82314261 -1.756812026 0.0 2 0.0 0.09221861699999999 -0.006800563000000001 0.0 0.08541805400000001
67 harpebr03 2013 0 NLS201307160 NL 8 17.28839515 4.591078426 0.0 2 0.0 0.06692282 0.017771916000000002 0.0 0.08469473599999999
68 carpema01 2013 0 NLS201307160 NL   19.90048053 -1.2528766470000001 0.0 2 0.0 0.077034118 -0.004849845 0.0 0.072184273
69 gonzaca01 2013 0 NLS201307160 NL 7 19.7923236 -2.128000637 0.0 2 0.0 0.07661544599999999 -0.008237422 0.0 0.06837802400000001
70 kimbrcr01 2013 0 NLS201307160 NL   0.0 0.0 13.35429036 0 1.0 0.0 0.0 0.066771452 0.066771452
71 gomezca01 2013 0 NLS201307160 NL   7.253967272000001 23.62815151 0.0 1 0.0 0.014039936999999999 0.045731905999999996 0.0 0.059771843
72 fernajo02 2013 0 NLS201307160 NL   0.0 0.0 11.6166679 0 1.0 0.0 0.0 0.058083339000000005 0.058083339000000005
73 poseybu01 2013 0 NLS201307160 NL   22.86849366 6.599924081 0.0 1 0.0 0.044261601 0.012774047 0.0 0.057035647
74 chapmar01 2013 0 NLS201307160 NL   0.0 0.0 8.278667249 0 1.0 0.0 0.0 0.041393336 0.041393336
75 beltrca01 2013 0 NLS201307160 NL 9 14.64398539 -6.867289242000001 0.0 2 0.0 0.056686395 -0.026583055 0.0 0.03010334
76 phillbr01 2013 0 NLS201307160 NL 4 -0.251916125 6.139187517000001 0.0 2 0.0 -0.000975159 0.023764597000000002 0.0 0.022789438
77 grillja01 2013 0 NLS201307160 NL   0.0 0.0 3.461209526 0 1.0 0.0 0.0 0.017306048 0.017306048
78 segurje01 2013 0 NLS201307160 NL   2.34936249 6.0466945160000005 0.0 1 0.0 0.004547153 0.01170328 0.0 0.016250433
79 craigal01 2013 0 NLS201307160 NL   16.70931488 -9.731161689 0.0 1 0.0 0.032340609 -0.018834506 0.0 0.013506103
80 corbipa01 2013 0 NLS201307160 NL   0.0 0.0 0.863964958 0 1.0 0.0 0.0 0.004319825 0.004319825
81 alvarpe01 2013 0 NLS201307160 NL   1.541331175 -0.8415766990000001 0.0 1 0.0 0.0029832220000000002 -0.001628858 0.0 0.001354364
82 browndo01 2013 0 NLS201307160 NL   8.214554582 -13.01373283 0.0 1 0.0 0.015899138 -0.02518787 0.0 -0.009288732
83 cuddymi01 2013 0 NLS201307160 NL 0 14.29032129 -18.345854199999998 0.0 2 0.0 0.055317372999999996 -0.07101621 0.0 -0.015698837
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 salech01 2013 0 NLS201307160 AL   0.0 0.0 17.92905256 0 2.0 0.0 0.0 0.17931044899999998 0.17931044899999998
86 cabremi01 2013 0 NLS201307160 AL 5 41.97734268 -8.441702232 0.0 3 0.0 0.22223299100000002 -0.044691365 0.0 0.177541626
87 pedrodu01 2013 0 NLS201307160 AL   11.87000456 12.63811425 0.0 2 0.0 0.041894134 0.044605109000000004 0.0 0.086499243
88 bautijo02 2013 0 NLS201307160 AL 9 27.55944119 -3.1305280189999998 0.0 2 0.0 0.097268616 -0.011048922 0.0 0.086219694
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 mauerjo01 2013 0 NLS201307160 AL 2 17.08688412 0.809616388 0.0 2 0.0 0.06030665 0.00285747 0.0 0.063164119
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 nathajo01 2013 0 NLS201307160 AL   0.0 0.0 11.52333118 0 1.0 0.0 0.0 0.057623058 0.057623058
93 canoro01 2013 0 NLS201307160 AL 4 25.26117507 7.292741231 0.0 1 0.0 0.044578544000000005 0.012869543 0.0 0.057448088
94 riverma01 2013 0 NLS201307160 AL   0.0 0.0 11.28793255 0 1.0 0.0 0.0 0.056445935 0.056445935
95 hernafe02 2013 0 NLS201307160 AL   0.0 0.0 10.9692711 0 1.0 0.0 0.0 0.05485245 0.05485245
96 jonesad01 2013 0 NLS201307160 AL 8 12.34095119 -3.143886779 0.0 3 0.0 0.065334447 -0.016644106000000002 0.0 0.048690341
97 ortizda01 2013 0 NLS201307160 AL 0 24.837510199999997 -11.6019817 0.0 2 0.0 0.087661801 -0.040948171 0.0 0.04671363
98 machama01 2013 0 NLS201307160 AL   -1.757951064 22.17290001 0.0 1 0.0 -0.003102267 0.039128647 0.0 0.03602638
99 balfogr01 2013 0 NLS201307160 AL   0.0 0.0 6.761375442 0 1.0 0.0 0.0 0.033810634 0.033810634
100 gordoal01 2013 0 NLS201307160 AL   10.21968962 8.607640534 0.0 1 0.0 0.018034746 0.015189953999999999 0.0 0.033224699999999996

Next page

Advanced export

JSON shape: default, array

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
)
Powered by Datasette · Query took 25.258ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub