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

245 rows where asg_IP = "2.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
4 4 greinza01 2015 0 NLS201507140 NL 1 0.0 0.0 15.64561093 0 2.0 0.0 0.0 0.156456109 0.156456109
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
61 61 harvema01 2013 0 NLS201307160 NL 1 0.0 0.0 11.5738434 0 2.0 0.0 0.0 0.115738434 0.115738434
85 85 salech01 2013 0 NLS201307160 AL   0.0 0.0 17.92905256 0 2.0 0.0 0.0 0.179310449 0.179310449
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
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
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
253 253 beckejo02 2007 0 NLS200707100 AL   0.0 0.0 13.82337217 0 2.0 0.0 0.0 0.138233722 0.138233722
261 261 harenda01 2007 0 NLS200707100 AL 1 0.0 0.0 7.052303494 0 2.0 0.0 0.0 0.070523035 0.070523035
289 289 pennybr01 2006 0 NLS200607110 NL 1 0.0 0.0 5.344406774 0 2.0 0.0 0.0 0.053444068 0.053444068
303 303 hallaro01 2006 0 NLS200607110 AL   0.0 0.0 13.83407012 0 2.0 0.0 0.0 0.138340701 0.138340701
312 312 rogerke01 2006 0 NLS200607110 AL 1 0.0 0.0 7.283722252 0 2.0 0.0 0.0 0.072837223 0.072837223
336 336 pavanca01 2004 0 NLS200407130 NL   0.0 0.0 7.566686472 0 2.0 0.0 0.0 0.075666865 0.075666865
362 362 muldema01 2004 0 NLS200407130 AL 1 0.0 0.0 6.868901399 0 2.0 0.0 0.0 0.068689014 0.068689014
386 386 schilcu01 2002 0 NLS200207090 NL 1 0.0 0.0 23.50389474 0 2.0 0.0 0.0 0.192304593 0.192304593
407 407 padilvi01 2002 0 NLS200207090 NL   0.0 0.0 1.540411321 0 2.0 0.0 0.0 0.012603365 0.012603365
415 415 lowede01 2002 0 NLS200207090 AL 1 0.0 0.0 16.79840627 0 2.0 0.0 0.0 0.137441506 0.137441506
418 418 buehrma01 2002 0 NLS200207090 AL   0.0 0.0 10.70041109 0 2.0 0.0 0.0 0.087548818 0.087548818
430 430 garcifr03 2002 0 NLS200207090 AL   0.0 0.0 2.656242521 0 2.0 0.0 0.0 0.021732893 0.021732893
461 461 kileda01 2000 0 NLS200007110 NL   0.0 0.0 3.628677402 0 2.0 0.0 0.0 0.036286774 0.036286774
479 479 wellsda01 2000 0 NLS200007110 AL 1 0.0 0.0 8.354145016 0 2.0 0.0 0.0 0.08354145 0.08354145
503 503 maddugr01 1998 0 NLS199807070 NL 1 0.0 0.0 18.93113172 0 2.0 0.0 0.0 0.189311317 0.189311317
534 534 wellsda01 1998 0 NLS199807070 AL 1 0.0 0.0 9.431822861 0 2.0 0.0 0.0 0.094318229 0.094318229
559 559 smoltjo01 1996 0 NLS199607090 NL 1 0.0 0.0 15.07648008 0 2.0 0.0 0.0 0.150764801 0.150764801
584 584 nagych01 1996 0 NLS199607090 AL 1 0.0 0.0 14.7057998 0 2.0 0.0 0.0 0.165440248 0.165440248
592 592 finlech01 1996 0 NLS199607090 AL   0.0 0.0 6.24067673 0 2.0 0.0 0.0 0.070207613 0.070207613
600 600 pavliro01 1996 0 NLS199607090 AL   0.0 0.0 0.669310566 0 2.0 0.0 0.0 0.007529744 0.007529744
613 613 hillke01 1994 0 NLS199407120 NL   0.0 0.0 7.236759 0 2.0 0.0 0.0 0.065124319 0.065124319
631 631 coneda01 1994 0 NLS199407120 AL   0.0 0.0 22.64972608 0 2.0 0.0 0.0 0.226497261 0.226497261
634 634 keyji01 1994 0 NLS199407120 AL 1 0.0 0.0 14.04705325 0 2.0 0.0 0.0 0.140470533 0.140470533
734 734 armstja01 1990 0 NLS199007100 NL 1 0.0 0.0 1.15302733 0 2.0 0.0 0.0 0.011530273 0.011530273
742 742 saberbr01 1990 0 NLS199007100 AL   0.0 0.0 16.1898546 0 2.0 0.0 0.0 0.161898546 0.161898546
743 743 stiebda01 1990 0 NLS199007100 AL   0.0 0.0 11.99940614 0 2.0 0.0 0.0 0.119994061 0.119994061
756 756 welchbo01 1990 0 NLS199007100 AL 1 0.0 0.0 2.174653771 0 2.0 0.0 0.0 0.021746538 0.021746538
789 789 violafr01 1988 0 NLS198807120 AL 1 0.0 0.0 18.2058263 0 2.0 0.0 0.0 0.182058263 0.182058263
791 791 gubicma01 1988 0 NLS198807120 AL   0.0 0.0 15.33501462 0 2.0 0.0 0.0 0.153350146 0.153350146
863 863 sotoma01 1984 0 NLS198407100 NL   0.0 0.0 11.22594403 0 2.0 0.0 0.0 0.11225944 0.11225944
866 866 goodedw01 1984 0 NLS198407100 NL   0.0 0.0 6.480918094 0 2.0 0.0 0.0 0.064809181 0.064809181
870 870 leach01 1984 0 NLS198407100 NL 1 0.0 0.0 3.150659496 0 2.0 0.0 0.0 0.031506595 0.031506595
871 871 valenfe01 1984 0 NLS198407100 NL   0.0 0.0 2.98597578 0 2.0 0.0 0.0 0.029859758 0.029859758
882 882 stiebda01 1984 0 NLS198407100 AL 1 0.0 0.0 18.66941597 0 2.0 0.0 0.0 0.21003093 0.21003093
889 889 dotsori01 1984 0 NLS198407100 AL   0.0 0.0 7.82801438 0 2.0 0.0 0.0 0.088065162 0.088065162
902 902 morrija02 1984 0 NLS198407100 AL   0.0 0.0 -0.350342827 0 2.0 0.0 0.0 -0.003941357 -0.003941357
907 907 sotoma01 1982 0 NLS198207130 NL   0.0 0.0 12.19109587 0 2.0 0.0 0.0 0.121910959 0.121910959
908 908 carltst01 1982 0 NLS198207130 NL   0.0 0.0 11.65026027 0 2.0 0.0 0.0 0.116502603 0.116502603
935 935 quiseda01 1982 0 NLS198207130 AL   0.0 0.0 8.534174875 0 2.0 0.0 0.0 0.096009467 0.096009467
955 955 suttebr01 1980 0 NLS198007080 NL   0.0 0.0 9.710777044 0 2.0 0.0 0.0 0.09710777 0.09710777
956 956 richaj.01 1980 0 NLS198007080 NL 1 0.0 0.0 9.180127577 0 2.0 0.0 0.0 0.091801276 0.091801276
1007 1007 rogerst01 1978 0 NLS197807110 NL   0.0 0.0 9.626416385 0 2.0 0.0 0.0 0.096264164 0.096264164
1012 1012 fingero01 1978 0 NLS197807110 NL   0.0 0.0 5.436003921 0 2.0 0.0 0.0 0.054360039 0.054360039
1048 1048 montejo01 1976 0 NLS197607130 NL   0.0 0.0 15.26616379 0 2.0 0.0 0.0 0.152661638 0.152661638
1050 1050 seaveto01 1976 0 NLS197607130 NL   0.0 0.0 12.83029259 0 2.0 0.0 0.0 0.128302926 0.128302926
1071 1071 fidryma01 1976 0 NLS197607130 AL 1 0.0 0.0 15.3272999 0 2.0 0.0 0.0 0.172432124 0.172432124
1072 1072 tananfr01 1976 0 NLS197607130 AL   0.0 0.0 14.38900129 0 2.0 0.0 0.0 0.161876264 0.161876264
1076 1076 tiantlu01 1976 0 NLS197607130 AL   0.0 0.0 8.347521372 0 2.0 0.0 0.0 0.093909615 0.093909615
1085 1085 hunteca01 1976 0 NLS197607130 AL   0.0 0.0 1.14589909 0 2.0 0.0 0.0 0.012891365 0.012891365
1105 1105 marshmi01 1974 0 NLS197407230 NL   0.0 0.0 4.463464937 0 2.0 0.0 0.0 0.044634649 0.044634649
1113 1113 brettke01 1974 0 NLS197407230 NL   0.0 0.0 -0.593641015 0 2.0 0.0 0.0 -0.00593641 -0.00593641
1119 1119 tiantlu01 1974 0 NLS197407230 AL   0.0 0.0 13.3265118 0 2.0 0.0 0.0 0.149923258 0.149923258
1124 1124 hunteca01 1974 0 NLS197407230 AL   0.0 0.0 6.399185995 0 2.0 0.0 0.0 0.071990842 0.071990842
1137 1137 gibsobo01 1972 0 NLS197207250 NL 1 0.0 0.0 13.83641372 0 2.0 0.0 0.0 0.124527723 0.124527723
1140 1140 mcgratu01 1972 0 NLS197207250 NL   0.0 0.0 11.30396502 0 2.0 0.0 0.0 0.101735685 0.101735685
1141 1141 suttodo01 1972 0 NLS197207250 NL   0.0 0.0 8.817838695 0 2.0 0.0 0.0 0.079360548 0.079360548
1151 1151 stonebi01 1972 0 NLS197207250 NL   0.0 0.0 3.301589106 0 2.0 0.0 0.0 0.029714302 0.029714302
1158 1158 woodwi01 1972 0 NLS197207250 AL   0.0 0.0 17.9389289 0 2.0 0.0 0.0 0.172988707 0.172988707
1163 1163 perryga01 1972 0 NLS197207250 AL   0.0 0.0 12.75267949 0 2.0 0.0 0.0 0.122976659 0.122976659
1165 1165 lolicmi01 1972 0 NLS197207250 AL   0.0 0.0 10.99802714 0 2.0 0.0 0.0 0.106056192 0.106056192
1179 1179 gibsobo01 1970 0 NLS197007140 NL   0.0 0.0 22.18499983 0 2.0 0.0 0.0 0.166387499 0.166387499
1183 1183 perryga01 1970 0 NLS197007140 NL   0.0 0.0 12.48004706 0 2.0 0.0 0.0 0.093600353 0.093600353
1202 1202 merriji01 1970 0 NLS197007140 NL   0.0 0.0 -3.456750923 0 2.0 0.0 0.0 -0.025925632 -0.025925632
1214 1214 perryji01 1970 0 NLS197007140 AL   0.0 0.0 7.092637104 0 2.0 0.0 0.0 0.054713066 0.054713066
1232 1232 seaveto01 1968 0 NLS196807090 NL   0.0 0.0 11.30004933 0 2.0 0.0 0.0 0.113000493 0.113000493
1235 1235 maricju01 1968 0 NLS196807090 NL   0.0 0.0 4.967191017 0 2.0 0.0 0.0 0.04967191 0.04967191
1252 1252 tiantlu01 1968 0 NLS196807090 AL 1 0.0 0.0 15.12125206 0 2.0 0.0 0.0 0.170114086 0.170114086
1258 1258 mclaide01 1968 0 NLS196807090 AL   0.0 0.0 3.926317335 0 2.0 0.0 0.0 0.04417107 0.04417107
1274 1274 odombl01 1968 0 NLS196807090 AL   0.0 0.0 -1.788518129 0 2.0 0.0 0.0 -0.020120829 -0.020120829
1281 1281 bunniji01 1966 0 NLS196607120 NL   0.0 0.0 16.39456191 0 2.0 0.0 0.0 0.147551057 0.147551057
1286 1286 perryga01 1966 0 NLS196607120 NL   0.0 0.0 5.08806796 0 2.0 0.0 0.0 0.045792612 0.045792612
1299 1299 siebeso01 1966 0 NLS196607120 AL   0.0 0.0 10.00115155 0 2.0 0.0 0.0 0.09644312 0.09644312
1303 1303 stottme01 1966 0 NLS196607120 AL   0.0 0.0 2.257917558 0 2.0 0.0 0.0 0.021773554 0.021773554
1308 1308 kaatji01 1966 0 NLS196607120 AL   0.0 0.0 1.017264452 0 2.0 0.0 0.0 0.009809686 0.009809686
1321 1321 farretu01 1964 0 NLS196407070 NL   0.0 0.0 7.657105285 0 2.0 0.0 0.0 0.076571053 0.076571053
1325 1325 bunniji01 1964 0 NLS196407070 NL   0.0 0.0 4.74073738 0 2.0 0.0 0.0 0.047407374 0.047407374
1343 1343 pascuca02 1964 0 NLS196407070 AL   0.0 0.0 3.908169687 0 2.0 0.0 0.0 0.040583278 0.040583278
1355 1355 gibsobo01 1962 2 NLS196207300 NL   0.0 0.0 9.758449118 0 2.0 0.0 0.0 0.097584491 0.097584491
1363 1363 podrejo01 1962 2 NLS196207300 NL 1 0.0 0.0 2.149883205 0 2.0 0.0 0.0 0.021498832 0.021498832
1369 1369 mahafar01 1962 2 NLS196207300 NL   0.0 0.0 1.386098252 0 2.0 0.0 0.0 0.013860983 0.013860983
1371 1371 maricju01 1962 2 NLS196207300 NL   0.0 0.0 1.249642354 0 2.0 0.0 0.0 0.012496424 0.012496424
1381 1381 stenhda01 1962 2 NLS196207300 AL 1 0.0 0.0 6.469065038 0 2.0 0.0 0.0 0.06469065 0.06469065
1413 1413 purkebo01 1961 1 NLS196107110 NL   0.0 0.0 -0.673256872 0 2.0 0.0 0.0 -0.006059312 -0.006059312
1424 1424 bunniji01 1961 1 NLS196107110 AL   0.0 0.0 8.202748936 0 2.0 0.0 0.0 0.082027489 0.082027489
1428 1428 donovdi01 1961 1 NLS196107110 AL   0.0 0.0 5.911357482 0 2.0 0.0 0.0 0.059113575 0.059113575
1445 1445 jonessa02 1959 2 NLS195908030 NL   0.0 0.0 10.25649027 0 2.0 0.0 0.0 0.102564903 0.102564903
1446 1446 facero01 1959 2 NLS195908030 NL   0.0 0.0 8.326020669 0 2.0 0.0 0.0 0.083260207 0.083260207
1448 1448 conlege01 1959 2 NLS195908030 NL   0.0 0.0 5.547256806 0 2.0 0.0 0.0 0.055472568 0.055472568
1477 1477 wynnea01 1959 2 NLS195908030 AL   0.0 0.0 -2.267733694 0 2.0 0.0 0.0 -0.022677337 -0.022677337
1478 1478 mclisca01 1959 2 NLS195908030 AL   0.0 0.0 -2.510442551 0 2.0 0.0 0.0 -0.025104426 -0.025104426
1526 1526 jacksla01 1957 0 NLS195707090 NL   0.0 0.0 3.219960752 0 2.0 0.0 0.0 0.032199608 0.032199608
1603 1603 spahnwa01 1953 0 NLS195307140 NL   0.0 0.0 19.19113661 0 2.0 0.0 0.0 0.191911366 0.191911366
1608 1608 simmocu01 1953 0 NLS195307140 NL   0.0 0.0 6.891624915 0 2.0 0.0 0.0 0.068916249 0.068916249

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