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

139 rows where asg_IP = "3.0"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: gameNum, lgID

Link rowid ▼ bbref_ID yearID gameNum gameID lgID startingPos OFF600 DEF600 PITCH200 asg_PA asg_IP OFFper9innASG DEFper9innASG PITper9innASG TOTper9innASG
605 605 maddugr01 1994 0 NLS199407120 NL 1 0.0 0.0 24.35338874 0 3.0 0.0 0.0 0.328737874 0.328737874
767 767 goodedw01 1988 0 NLS198807120 NL 1 0.0 0.0 4.44901455 0 3.0 0.0 0.0 0.066735218 0.066735218
814 814 goodedw01 1986 0 NLS198607150 NL 1 0.0 0.0 14.86469343 0 3.0 0.0 0.0 0.222970401 0.222970401
817 817 valenfe01 1986 0 NLS198607150 NL   0.0 0.0 8.696229782 0 3.0 0.0 0.0 0.130443447 0.130443447
837 837 higuete01 1986 0 NLS198607150 AL   0.0 0.0 20.01516307 0 3.0 0.0 0.0 0.300194091 0.300194091
838 838 clemero02 1986 0 NLS198607150 AL 1 0.0 0.0 18.01554048 0 3.0 0.0 0.0 0.270203085 0.270203085
906 906 rogerst01 1982 0 NLS198207130 NL 1 0.0 0.0 11.58055349 0 3.0 0.0 0.0 0.173708302 0.173708302
936 936 eckerde01 1982 0 NLS198207130 AL 1 0.0 0.0 4.91788879 0 3.0 0.0 0.0 0.082989373 0.082989373
968 968 welchbo01 1980 0 NLS198007080 NL   0.0 0.0 1.26286771 0 3.0 0.0 0.0 0.018943016 0.018943016
991 991 stonest01 1980 0 NLS198007080 AL 1 0.0 0.0 2.098426288 0 3.0 0.0 0.0 0.035410944 0.035410944
1003 1003 bluevi01 1978 0 NLS197807110 NL 1 0.0 0.0 9.279916571 0 3.0 0.0 0.0 0.139198749 0.139198749
1029 1029 sorenla01 1978 0 NLS197807110 AL   0.0 0.0 4.502465788 0 3.0 0.0 0.0 0.07597911 0.07597911
1053 1053 jonesra01 1976 0 NLS197607130 NL 1 0.0 0.0 7.147265443 0 3.0 0.0 0.0 0.107208982 0.107208982
1098 1098 messean01 1974 0 NLS197407230 NL 1 0.0 0.0 6.580242291 0 3.0 0.0 0.0 0.098703634 0.098703634
1116 1116 perryga01 1974 0 NLS197407230 AL 1 0.0 0.0 15.62292686 0 3.0 0.0 0.0 0.263636891 0.263636891
1166 1166 palmeji01 1972 0 NLS197207250 AL 1 0.0 0.0 6.826261966 0 3.0 0.0 0.0 0.09874053 0.09874053
1180 1180 seaveto01 1970 0 NLS197007140 NL 1 0.0 0.0 12.18393709 0 3.0 0.0 0.0 0.137069292 0.137069292
1203 1203 osteecl01 1970 0 NLS197007140 NL   0.0 0.0 -2.828085853 0 3.0 0.0 0.0 -0.031815966 -0.031815966
1205 1205 mcdowsa01 1970 0 NLS197007140 AL   0.0 0.0 15.12898066 0 3.0 0.0 0.0 0.175058917 0.175058917
1206 1206 palmeji01 1970 0 NLS197007140 AL 1 0.0 0.0 10.08912042 0 3.0 0.0 0.0 0.116742201 0.116742201
1233 1233 drysddo01 1968 0 NLS196807090 NL 1 0.0 0.0 5.127472257 0 3.0 0.0 0.0 0.076912084 0.076912084
1277 1277 koufasa01 1966 0 NLS196607120 NL 1 0.0 0.0 19.61157296 0 3.0 0.0 0.0 0.264756235 0.264756235
1278 1278 maricju01 1966 0 NLS196607120 NL   0.0 0.0 19.43764854 0 3.0 0.0 0.0 0.262408255 0.262408255
1307 1307 mclaide01 1966 0 NLS196607120 AL 1 0.0 0.0 0.716072886 0 3.0 0.0 0.0 0.010357853 0.010357853
1315 1315 drysddo01 1964 0 NLS196407070 NL 1 0.0 0.0 9.660718187 0 3.0 0.0 0.0 0.144910773 0.144910773
1336 1336 chancde01 1964 0 NLS196407070 AL 1 0.0 0.0 14.54105126 0 3.0 0.0 0.0 0.226496126 0.226496126
1376 1376 aguirha01 1962 2 NLS196207300 AL   0.0 0.0 17.07939091 0 3.0 0.0 0.0 0.256190864 0.256190864
1380 1380 herbera01 1962 2 NLS196207300 AL   0.0 0.0 6.615470117 0 3.0 0.0 0.0 0.099232052 0.099232052
1404 1404 mccormi03 1961 1 NLS196107110 NL   0.0 0.0 4.635355454 0 3.0 0.0 0.0 0.062577299 0.062577299
1405 1405 spahnwa01 1961 1 NLS196107110 NL 1 0.0 0.0 2.840595605 0 3.0 0.0 0.0 0.038348041 0.038348041
1429 1429 fordwh01 1961 1 NLS196107110 AL 1 0.0 0.0 3.609324405 0 3.0 0.0 0.0 0.054139866 0.054139866
1442 1442 drysddo01 1959 2 NLS195908030 NL 1 0.0 0.0 8.500973511 0 3.0 0.0 0.0 0.127514603 0.127514603
1469 1469 walkeje01 1959 2 NLS195908030 AL 1 0.0 0.0 4.131624091 0 3.0 0.0 0.0 0.061974361 0.061974361
1483 1483 drysddo01 1959 1 NLS195907070 NL 1 0.0 0.0 8.500973511 0 3.0 0.0 0.0 0.127514603 0.127514603
1495 1495 burdele01 1959 1 NLS195907070 NL   0.0 0.0 -6.48329598 0 3.0 0.0 0.0 -0.09724944 -0.09724944
1498 1498 durenry01 1959 1 NLS195907070 AL   0.0 0.0 10.23327345 0 3.0 0.0 0.0 0.17268649 0.17268649
1517 1517 wynnea01 1959 1 NLS195907070 AL 1 0.0 0.0 -2.267733694 0 3.0 0.0 0.0 -0.038268006 -0.038268006
1543 1543 bunniji01 1957 0 NLS195707090 AL 1 0.0 0.0 8.656111029 0 3.0 0.0 0.0 0.129841665 0.129841665
1557 1557 loesbi01 1957 0 NLS195707090 AL   0.0 0.0 -0.317292511 0 3.0 0.0 0.0 -0.004759388 -0.004759388
1563 1563 roberro01 1955 0 NLS195507120 NL 1 0.0 0.0 8.773444849 0 3.0 0.0 0.0 0.098701255 0.098701255
1579 1579 haddiha01 1955 0 NLS195507120 NL   0.0 0.0 -0.33352461 0 3.0 0.0 0.0 -0.003752152 -0.003752152
1585 1585 piercbi02 1955 0 NLS195507120 AL 1 0.0 0.0 12.62149188 0 3.0 0.0 0.0 0.154900128 0.154900128
1586 1586 wynnea01 1955 0 NLS195507120 AL   0.0 0.0 11.51347691 0 3.0 0.0 0.0 0.141301762 0.141301762
1601 1601 roberro01 1953 0 NLS195307140 NL 1 0.0 0.0 17.9775353 0 3.0 0.0 0.0 0.26966303 0.26966303
1620 1620 piercbi02 1953 0 NLS195307140 AL 1 0.0 0.0 14.06102987 0 3.0 0.0 0.0 0.237279879 0.237279879
1644 1644 simmocu01 1952 0 NLS195207080 NL 1 0.0 0.0 4.40643245 0 3.0 0.0 0.0 0.118973676 0.118973676
1701 1701 raschvi01 1949 0 NLS194907120 AL   0.0 0.0 1.056088797 0 3.0 0.0 0.0 0.015841332 0.015841332
1708 1708 brisslo01 1949 0 NLS194907120 AL   0.0 0.0 -2.004021137 0 3.0 0.0 0.0 -0.030060317 -0.030060317
1709 1709 blackew01 1947 0 NLS194707080 NL 1 0.0 0.0 17.3088896 0 3.0 0.0 0.0 0.259633344 0.259633344
1712 1712 brechha01 1947 0 NLS194707080 NL   0.0 0.0 9.463311847 0 3.0 0.0 0.0 0.141949678 0.141949678
1733 1733 newhoha01 1947 0 NLS194707080 AL 1 0.0 0.0 15.94339821 0 3.0 0.0 0.0 0.239150973 0.239150973
1739 1739 sheasp01 1947 0 NLS194707080 AL   0.0 0.0 3.040067676 0 3.0 0.0 0.0 0.045601015 0.045601015
1752 1752 sewelri01 1944 0 NLS194407110 NL   0.0 0.0 8.834325131 0 3.0 0.0 0.0 0.132514877 0.132514877
1758 1758 waltebu01 1944 0 NLS194407110 NL 1 0.0 0.0 3.573642143 0 3.0 0.0 0.0 0.053604632 0.053604632
1774 1774 borowha01 1944 0 NLS194407110 AL 1 0.0 0.0 5.047842241 0 3.0 0.0 0.0 0.085182338 0.085182338
1782 1782 coopemo01 1942 0 NLS194207060 NL 1 0.0 0.0 12.01856953 0 3.0 0.0 0.0 0.180278543 0.180278543
1785 1785 vandejo01 1942 0 NLS194207060 NL   0.0 0.0 7.628010542 0 3.0 0.0 0.0 0.114420158 0.114420158
1838 1838 newsobo01 1940 0 NLS194007090 AL   0.0 0.0 18.71137779 0 3.0 0.0 0.0 0.3157545 0.3157545
1847 1847 ruffire01 1940 0 NLS194007090 AL 1 0.0 0.0 5.912908893 0 3.0 0.0 0.0 0.099780338 0.099780338
1858 1858 leebi02 1938 0 NLS193807060 NL   0.0 0.0 12.9097611 0 3.0 0.0 0.0 0.193646416 0.193646416
1862 1862 vandejo01 1938 0 NLS193807060 NL 1 0.0 0.0 2.687504861 0 3.0 0.0 0.0 0.040312573 0.040312573
1865 1865 brownma01 1938 0 NLS193807060 NL   0.0 0.0 -5.74984287 0 3.0 0.0 0.0 -0.086247643 -0.086247643
1870 1870 gomezle01 1938 0 NLS193807060 AL 1 0.0 0.0 13.84719493 0 3.0 0.0 0.0 0.233671414 0.233671414
1873 1873 allenjo02 1938 0 NLS193807060 AL   0.0 0.0 11.18805562 0 3.0 0.0 0.0 0.188798439 0.188798439
1882 1882 hubbeca01 1936 0 NLS193607070 NL   0.0 0.0 17.70252303 0 3.0 0.0 0.0 0.265537845 0.265537845
1885 1885 deandi01 1936 0 NLS193607070 NL 1 0.0 0.0 13.8481122 0 3.0 0.0 0.0 0.207721683 0.207721683
1896 1896 grovele01 1936 0 NLS193607070 AL 1 0.0 0.0 31.81132614 0 3.0 0.0 0.0 0.536816129 0.536816129
1903 1903 rowesc01 1936 0 NLS193607070 AL   0.0 0.0 6.161323112 0 3.0 0.0 0.0 0.103972328 0.103972328
1913 1913 deandi01 1934 0 NLS193407100 NL   0.0 0.0 16.15870266 0 3.0 0.0 0.0 0.24238054 0.24238054
1914 1914 hubbeca01 1934 0 NLS193407100 NL 1 0.0 0.0 15.90505898 0 3.0 0.0 0.0 0.238575885 0.238575885
1938 1938 gomezle01 1934 0 NLS193407100 AL 1 0.0 0.0 13.85184316 0 3.0 0.0 0.0 0.207777647 0.207777647
2137 2137 cookaa01 2008 0 ALS200807150 NL   0.0 0.0 7.902887209 0 3.0 0.0 0.0 0.072740831 0.072740831
2669 2669 smithle02 1987 0 ALS198707140 NL   0.0 0.0 9.445973809 0 3.0 0.0 0.0 0.098092805 0.098092805
2695 2695 saberbr01 1987 0 ALS198707140 AL 1 0.0 0.0 16.34822133 0 3.0 0.0 0.0 0.169769991 0.169769991
2739 2739 hoytla01 1985 0 ALS198507160 NL 1 0.0 0.0 0.1124642 0 3.0 0.0 0.0 0.001686963 0.001686963
2743 2743 ryanno01 1985 0 ALS198507160 NL   0.0 0.0 -1.922880044 0 3.0 0.0 0.0 -0.028843201 -0.028843201
2798 2798 stiebda01 1983 0 ALS198307060 AL 1 0.0 0.0 15.99689985 0 3.0 0.0 0.0 0.239953498 0.239953498
2934 2934 suttodo01 1977 0 ALS197707190 NL 1 0.0 0.0 6.019728247 0 3.0 0.0 0.0 0.101582914 0.101582914
2981 2981 reussje01 1975 0 ALS197507150 NL 1 0.0 0.0 6.505220515 0 3.0 0.0 0.0 0.097578308 0.097578308
3096 3096 ellisdo01 1971 0 ALS197107130 NL 1 0.0 0.0 -1.557609054 0 3.0 0.0 0.0 -0.026284653 -0.026284653
3099 3099 bluevi01 1971 0 ALS197107130 AL 1 0.0 0.0 10.69905844 0 3.0 0.0 0.0 0.160485877 0.160485877
3120 3120 carltst01 1969 0 ALS196907230 NL 1 0.0 0.0 10.00233205 0 3.0 0.0 0.0 0.150034981 0.150034981
3173 3173 maricju01 1967 0 ALS196707110 NL 1 0.0 0.0 8.431129297 0 3.0 0.0 0.0 0.075880164 0.075880164
3176 3176 jenkife01 1967 0 ALS196707110 NL   0.0 0.0 5.78456837 0 3.0 0.0 0.0 0.052061115 0.052061115
3199 3199 chancde01 1967 0 ALS196707110 AL 1 0.0 0.0 5.915371631 0 3.0 0.0 0.0 0.053238345 0.053238345
3200 3200 peterga01 1967 0 ALS196707110 AL   0.0 0.0 5.561862975 0 3.0 0.0 0.0 0.050056767 0.050056767
3212 3212 maricju01 1965 0 ALS196507130 NL 1 0.0 0.0 18.62363531 0 3.0 0.0 0.0 0.27935453 0.27935453
3275 3275 mcbrike01 1963 0 ALS196307090 AL 1 0.0 0.0 3.281512961 0 3.0 0.0 0.0 0.049222694 0.049222694
3293 3293 drysddo01 1962 1 ALS196207100 NL 1 0.0 0.0 8.054103845 0 3.0 0.0 0.0 0.120811558 0.120811558
3311 3311 pascuca02 1962 1 ALS196207100 AL   0.0 0.0 11.82209703 0 3.0 0.0 0.0 0.177331455 0.177331455
3314 3314 bunniji01 1962 1 ALS196207100 AL 1 0.0 0.0 8.820136068 0 3.0 0.0 0.0 0.132302041 0.132302041
3336 3336 millest01 1961 2 ALS196107310 NL   0.0 0.0 4.303264048 0 3.0 0.0 0.0 0.064548961 0.064548961
3352 3352 pascuca02 1961 2 ALS196107310 AL   0.0 0.0 12.60356542 0 3.0 0.0 0.0 0.189053481 0.189053481
3354 3354 bunniji01 1961 2 ALS196107310 AL 1 0.0 0.0 8.202748936 0 3.0 0.0 0.0 0.123041234 0.123041234
3355 3355 schwado01 1961 2 ALS196107310 AL   0.0 0.0 6.115439129 0 3.0 0.0 0.0 0.091731587 0.091731587
3399 3399 fordwh01 1960 2 ALS196007130 AL 1 0.0 0.0 1.961114532 0 3.0 0.0 0.0 0.029416718 0.029416718
3418 3418 frienbo01 1960 1 ALS196007110 NL 1 0.0 0.0 2.633460373 0 3.0 0.0 0.0 0.039501906 0.039501906
3465 3465 spahnwa01 1958 0 ALS195807080 NL 1 0.0 0.0 4.230746471 0 3.0 0.0 0.0 0.071393847 0.071393847
3477 3477 o'delbi01 1958 0 ALS195807080 AL   0.0 0.0 6.591674353 0 3.0 0.0 0.0 0.098875115 0.098875115
3496 3496 frienbo01 1956 0 ALS195607100 NL 1 0.0 0.0 7.264650361 0 3.0 0.0 0.0 0.108969755 0.108969755

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