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 sorted by gameID

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
3901 warnelo01 1933 0 ALS193307060 NL   0.0 0.0 12.79789356 0 4.0 0.0 0.0 0.287952605 0.287952605
3902 kleinch01 1933 0 ALS193307060 NL 9 40.1483588 -8.983145989 0.0 4 0.0 0.301112691 -0.067373595 0.0 0.233739096
3903 bergewa01 1933 0 ALS193307060 NL 8 24.95351208 1.3631165969999999 0.0 4 0.0 0.18715134100000003 0.010223374 0.0 0.197374715
3904 hubbeca01 1933 0 ALS193307060 NL   0.0 0.0 16.37031596 0 2.0 0.0 0.0 0.184166054 0.184166054
3905 terrybi01 1933 0 ALS193307060 NL 3 23.90453958 0.46440734899999997 0.0 4 0.0 0.179284047 0.003483055 0.0 0.182767102
3906 hafeych01 1933 0 ALS193307060 NL 7 16.968916 -4.280230897 0.0 4 0.0 0.12726687 -0.032101732 0.0 0.09516513800000001
3907 martipe01 1933 0 ALS193307060 NL 5 8.033297719 -2.476872976 0.0 4 0.0 0.060249733 -0.018576547 0.0 0.041673186
3908 o'doule01 1933 0 ALS193307060 NL   23.76155428 -6.552150631 0.0 1 0.0 0.044552914000000006 -0.012285282 0.0 0.032267632000000004
3909 hallabi01 1933 0 ALS193307060 NL 1 0.0 0.0 1.711844846 0 2.0 0.0 0.0 0.019258255 0.019258255
3910 hartnga01 1933 0 ALS193307060 NL   5.296228442 3.76333949 0.0 1 0.0 0.009930428 0.007056262 0.0 0.01698669
3911 cuccito01 1933 0 ALS193307060 NL   5.383621477 0.8269258290000001 0.0 1 0.0 0.01009429 0.001550486 0.0 0.011644776
3912 engliwo01 1933 0 ALS193307060 NL   -1.2237230270000001 7.260989100000001 0.0 1 0.0 -0.002294481 0.013614355 0.0 0.011319873999999999
3913 traynpi01 1933 0 ALS193307060 NL   2.87572713 -0.287841024 0.0 1 0.0 0.005391988 -0.000539702 0.0 0.004852286
3914 wanerpa01 1933 0 ALS193307060 NL   21.74414826 -4.017255173 0.0 0 0.0 0.0 0.0 0.0 0.0
3915 friscfr01 1933 0 ALS193307060 NL 4 -1.599591727 1.4815529619999999 0.0 4 0.0 -0.011996938 0.011111646999999999 0.0 -0.0008852910000000001
3916 bartedi01 1933 0 ALS193307060 NL 6 -5.677608573 4.086488513 0.0 2 0.0 -0.021291032 0.015324332 0.0 -0.0059667
3917 wilsoji01 1933 0 ALS193307060 NL 2 -19.39508818 4.1575105269999995 0.0 1 0.0 -0.03636579 0.0077953319999999994 0.0 -0.028570457999999996
3918 ruthba01 1933 0 ALS193307060 AL 9 55.50303461 -6.338839423 0.0 4 0.0 0.38059223700000006 -0.043466327 0.0 0.33712591
3919 grovele01 1933 0 ALS193307060 AL   0.0 0.0 21.6859293 0 3.0 0.0 0.0 0.325288939 0.325288939
3920 gehrilo01 1933 0 ALS193307060 AL 3 49.77068377 -10.14679686 0.0 4 0.0 0.341284689 -0.069578036 0.0 0.271706653
3921 cronijo01 1933 0 ALS193307060 AL 6 18.00227698 16.06112687 0.0 4 0.0 0.123444185 0.110133441 0.0 0.233577626
3922 gehrich01 1933 0 ALS193307060 AL 4 12.247297099999999 9.558550697000001 0.0 5 0.0 0.10497683199999999 0.081930435 0.0 0.186907267
3923 chapmbe01 1933 0 ALS193307060 AL 7 19.65216808 1.484490986 0.0 5 0.0 0.168447155 0.012724208 0.0 0.181171363
3924 simmoal01 1933 0 ALS193307060 AL 8 24.14678644 -0.791354687 0.0 4 0.0 0.165577964 -0.005426431999999999 0.0 0.16015153199999999
3925 gomezle01 1933 0 ALS193307060 AL 1 0.0 0.0 4.410599144 0 3.0 0.0 0.0 0.066158987 0.066158987
3926 ferreri01 1933 0 ALS193307060 AL 2 5.239201375 4.011308178 0.0 4 0.0 0.035925952000000004 0.027506113 0.0 0.063432066
3927 crowdal01 1933 0 ALS193307060 AL   0.0 0.0 4.165896955 0 3.0 0.0 0.0 0.062488454000000006 0.062488454000000006
3928 averiea01 1933 0 ALS193307060 AL   18.04619736 -3.1848909180000002 0.0 1 0.0 0.030936337999999997 -0.005459813000000001 0.0 0.025476525
3929 westsa01 1933 0 ALS193307060 AL   3.3106510410000003 3.534473626 0.0 0 0.0 0.0 0.0 0.0 0.0
3930 dykesji01 1933 0 ALS193307060 AL 5 -8.767194647 3.3247786169999998 0.0 4 0.0 -0.060117906 0.022798482000000002 0.0 -0.037319424
3870 vaughar01 1935 0 ALS193507080 NL 6 43.41451153 5.783198426 0.0 4 0.0 0.325608836 0.043373987999999995 0.0 0.368982825
3871 ottme01 1935 0 ALS193507080 NL 9 35.1641809 0.062294749 0.0 4 0.0 0.263731357 0.000467211 0.0 0.264198567
3872 medwijo01 1935 0 ALS193507080 NL 7 23.52028082 -2.539032897 0.0 4 0.0 0.176402106 -0.019042747 0.0 0.157359359
3873 schumha02 1935 0 ALS193507080 NL   0.0 0.0 5.678319761 0 4.0 0.0 0.0 0.127762195 0.127762195
3874 hermabi01 1935 0 ALS193507080 NL 4 8.923282287000001 11.72122296 0.0 3 0.0 0.050193463 0.065931879 0.0 0.11612534199999999
3875 bergewa01 1935 0 ALS193507080 NL 8 29.17374239 -1.5259149230000002 0.0 2 0.0 0.10940153400000001 -0.005722181 0.0 0.103679353
3876 terrybi01 1935 0 ALS193507080 NL 3 16.30465492 1.599331777 0.0 3 0.0 0.091713684 0.008996241 0.0 0.100709925
3877 deandi01 1935 0 ALS193507080 NL   0.0 0.0 14.17529946 0 1.0 0.0 0.0 0.079736059 0.079736059
3878 colliri02 1935 0 ALS193507080 NL   25.28364637 -5.03819969 0.0 1 0.0 0.047406837 -0.009446624 0.0 0.037960213
3879 walkebi01 1935 0 ALS193507080 NL 1 0.0 0.0 3.3658019980000002 0 2.0 0.0 0.0 0.037865272 0.037865272
3880 wanerpa01 1935 0 ALS193507080 NL   23.35791855 -5.044089826 0.0 1 0.0 0.043796097 -0.009457668 0.0 0.034338429
3881 martipe01 1935 0 ALS193507080 NL 5 4.746616959 -1.873833191 0.0 4 0.0 0.035599627 -0.014053748999999999 0.0 0.021545877999999997
3882 moorejo02 1935 0 ALS193507080 NL   8.022858805 -2.545108963 0.0 2 0.0 0.030085721 -0.009544159 0.0 0.020541562
3883 derripa01 1935 0 ALS193507080 NL   0.0 0.0 2.952904175 0 1.0 0.0 0.0 0.016610086 0.016610086
3884 whitebu01 1935 0 ALS193507080 NL   -22.58382345 6.076721349 0.0 0 0.0 0.0 0.0 0.0 0.0
3885 hartnga01 1935 0 ALS193507080 NL   18.19906759 5.029568318 0.0 0 0.0 0.0 0.0 0.0 0.0
3886 mancugu01 1935 0 ALS193507080 NL   -7.929994407000001 1.692405269 0.0 1 0.0 -0.01486874 0.00317326 0.0 -0.01169548
3887 wilsoji01 1935 0 ALS193507080 NL 2 -17.88354958 4.73695569 0.0 3 0.0 -0.100594966 0.026645376000000002 0.0 -0.073949591
3888 foxxji01 1935 0 ALS193507080 AL 5 55.2268459 -1.28125107 0.0 4 0.0 0.41420134399999997 -0.009609383 0.0 0.404591961
3889 gehrilo01 1935 0 ALS193507080 AL 3 53.74475644 -3.271023978 0.0 4 0.0 0.403085673 -0.02453268 0.0 0.37855299299999995
3890 gehrich01 1935 0 ALS193507080 AL 4 26.56014566 13.105753 0.0 4 0.0 0.199201092 0.098293147 0.0 0.29749424
3891 gomezle01 1935 0 ALS193507080 AL 1 0.0 0.0 9.637991612 0 6.0 0.0 0.0 0.28913974800000003 0.28913974800000003
3892 hardeme01 1935 0 ALS193507080 AL   0.0 0.0 16.75413652 0 3.0 0.0 0.0 0.251312048 0.251312048
3893 cronijo01 1935 0 ALS193507080 AL 6 6.682279144 10.61255101 0.0 4 0.0 0.050117094 0.079594133 0.0 0.12971122599999999
3894 johnsbo01 1935 0 ALS193507080 AL 7 19.86815403 -4.804449616 0.0 4 0.0 0.149011155 -0.036033372 0.0 0.11297778300000001
3895 vosmijo01 1935 0 ALS193507080 AL 9 16.89507431 -1.880687733 0.0 4 0.0 0.126713057 -0.014105158000000001 0.0 0.112607899
3896 simmoal01 1935 0 ALS193507080 AL 8 5.555578105 1.188247953 0.0 4 0.0 0.041666836 0.00891186 0.0 0.050578695
3897 cramedo01 1935 0 ALS193507080 AL   -1.902294741 -2.54729396 0.0 0 0.0 0.0 0.0 0.0 0.0
3898 chapmbe01 1935 0 ALS193507080 AL   8.249815219 4.118376472 0.0 0 0.0 0.0 0.0 0.0 0.0
3899 bluegos01 1935 0 ALS193507080 AL   -19.48996509 5.9455818339999995 0.0 0 0.0 0.0 0.0 0.0 0.0
3900 hemslro01 1935 0 ALS193507080 AL 2 -10.72560027 3.5257508580000003 0.0 4 0.0 -0.080442002 0.026443131 0.0 -0.053998871
3839 vaughar01 1937 0 ALS193707070 NL 5 34.35527628 7.089103739 0.0 5 0.0 0.257664572 0.053168278 0.0 0.31083285
3840 medwijo01 1937 0 ALS193707070 NL 7 41.67896033 -1.747166601 0.0 5 0.0 0.312592202 -0.01310375 0.0 0.299488453
3841 hermabi01 1937 0 ALS193707070 NL 4 19.28434179 10.3723411 0.0 5 0.0 0.14463256300000002 0.077792558 0.0 0.222425122
3842 deandi01 1937 0 ALS193707070 NL 1 0.0 0.0 12.56613201 0 3.0 0.0 0.0 0.21205347800000002 0.21205347800000002
3843 mizejo01 1937 0 ALS193707070 NL 3 39.58514006 -6.288563977999999 0.0 4 0.0 0.23751084 -0.037731384 0.0 0.19977945600000002
3844 bartedi01 1937 0 ALS193707070 NL 6 4.895523758 22.8281957 0.0 4 0.0 0.029373142999999997 0.136969174 0.0 0.166342317
3845 wanerpa01 1937 0 ALS193707070 NL 9 24.16426452 -3.8840207039999997 0.0 5 0.0 0.18123198399999998 -0.029130155 0.0 0.152101829
3846 mungova01 1937 0 ALS193707070 NL   0.0 0.0 12.1761739 0 2.0 0.0 0.0 0.136981956 0.136981956
3847 hartnga01 1937 0 ALS193707070 NL 2 21.61898841 4.68401234 0.0 3 0.0 0.09728544800000001 0.021078056 0.0 0.11836350300000001
3848 demarfr02 1937 0 ALS193707070 NL 8 17.93175152 -4.573330759 0.0 5 0.0 0.134488136 -0.034299981 0.0 0.100188156
3849 ottme01 1937 0 ALS193707070 NL   36.19008403 -0.10824309900000001 0.0 1 0.0 0.054285125999999996 -0.000162365 0.0 0.054122761
3850 hubbeca01 1937 0 ALS193707070 NL   0.0 0.0 10.74329489 0 0.667 0.0 0.0 0.040307499999999996 0.040307499999999996
3851 grissle01 1937 0 ALS193707070 NL   0.0 0.0 5.500011237000001 0 1.0 0.0 0.0 0.030937562999999998 0.030937562999999998
3852 colliri02 1937 0 ALS193707070 NL   11.22978887 -3.383425265 0.0 1 0.0 0.016844683 -0.005075138 0.0 0.011769545
3853 moorejo02 1937 0 ALS193707070 NL   6.720089905 -4.304637738 0.0 1 0.0 0.010080135 -0.006456956999999999 0.0 0.003623178
3854 blantcy01 1937 0 ALS193707070 NL   0.0 0.0 1.7375085630000002 0 0.33299999999999996 0.0 0.0 0.003254571 0.003254571
3855 whitebu01 1937 0 ALS193707070 NL   -15.10477866 15.09467982 0.0 0 0.0 0.0 0.0 0.0 0.0
3856 mancugu01 1937 0 ALS193707070 NL   -4.009379163 3.008717907 0.0 1 0.0 -0.006014069 0.004513077 0.0 -0.001500992
3857 waltebu01 1937 0 ALS193707070 NL   0.0 0.0 -0.283872423 0 1.0 0.0 0.0 -0.0015967820000000001 -0.0015967820000000001
3858 gehrich01 1937 0 ALS193707070 AL 4 30.43779294 8.683070857999999 0.0 5 0.0 0.253648275 0.072358924 0.0 0.326007198
3859 gehrilo01 1937 0 ALS193707070 AL 3 53.42194566 -6.284880514 0.0 4 0.0 0.35614630399999997 -0.041899202999999996 0.0 0.31424710100000003
3860 dimagjo01 1937 0 ALS193707070 AL 9 32.62296497 3.391718712 0.0 5 0.0 0.271858041 0.028264322999999997 0.0 0.300122364
3861 gomezle01 1937 0 ALS193707070 AL 1 0.0 0.0 16.652717300000003 0 3.0 0.0 0.0 0.24979076 0.24979076
3862 dickebi01 1937 0 ALS193707070 AL 2 26.24005543 4.611197038 0.0 4 0.0 0.174933703 0.030741314 0.0 0.20567501600000002
3863 averiea01 1937 0 ALS193707070 AL 8 19.78920019 -5.738650234 0.0 4 0.0 0.131928001 -0.038257667999999995 0.0 0.09367033300000001
3864 bridgto01 1937 0 ALS193707070 AL   0.0 0.0 5.858638103 0 3.0 0.0 0.0 0.08787957199999999 0.08787957199999999
3865 rolfere01 1937 0 ALS193707070 AL 5 0.11434116 6.798669566 0.0 5 0.0 0.000952843 0.05665558 0.0 0.057608423
3866 hardeme01 1937 0 ALS193707070 AL   0.0 0.0 2.994070218 0 3.0 0.0 0.0 0.044911053 0.044911053
3867 foxxji01 1937 0 ALS193707070 AL   29.62913813 -4.1574572519999995 0.0 1 0.0 0.049381897 -0.006929095 0.0 0.042452801
3868 cronijo01 1937 0 ALS193707070 AL 6 2.9683360889999997 0.975208486 0.0 4 0.0 0.019788906999999998 0.00650139 0.0 0.026290297
3869 westsa01 1937 0 ALS193707070 AL 7 1.6604519869999999 -0.686757554 0.0 4 0.0 0.01106968 -0.0045783840000000004 0.0 0.006491296
3811 ottme01 1939 0 ALS193907110 NL 8 39.93511686 -0.341475277 0.0 4 0.0 0.26623411199999997 -0.002276502 0.0 0.26395761100000004
3812 vaughar01 1939 0 ALS193907110 NL 6 18.52686579 12.72692006 0.0 4 0.0 0.123512439 0.084846134 0.0 0.208358572
3813 leebi02 1939 0 ALS193907110 NL   0.0 0.0 10.60326558 0 3.0 0.0 0.0 0.178930107 0.178930107
3814 medwijo01 1939 0 ALS193907110 NL 7 28.06683026 -2.404018572 0.0 4 0.0 0.187112202 -0.01602679 0.0 0.17108541100000002
3815 lombaer01 1939 0 ALS193907110 NL 2 18.2860047 1.53937803 0.0 4 0.0 0.12190669800000001 0.01026252 0.0 0.132169218
3816 freylo01 1939 0 ALS193907110 NL 4 4.863931338 12.92826659 0.0 4 0.0 0.032426209 0.086188444 0.0 0.11861465300000001
3817 derripa01 1939 0 ALS193907110 NL 1 0.0 0.0 5.58369129 0 3.0 0.0 0.0 0.094224791 0.094224791
3818 mccorfr01 1939 0 ALS193907110 NL 3 13.29543373 -0.158899025 0.0 4 0.0 0.088636225 -0.0010593269999999999 0.0 0.08757689800000001

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