home / fivethirtyeight

MLB All-Star Teams: allstar_team_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

172 rows

View and edit SQL

Link rowid yearID gameNum gameID lgID tm_OFF_talent tm_DEF_talent tm_PIT_talent MLB_avg_RPG talent_RSPG talent_RAPG unadj_PYTH timeline_adj SOS adj_PYTH no_1_player no_2_player
101 1949 0 NLS194907120 NL 1.181951648 0.067845848 0.256855894 4.61 5.7919516479999995 4.285298258 0.634446622 0.812322275 0.406161137 0.542765955 musiast01 kinerra01
102 2006 0 NLS200607110 NL 1.111767124 0.069504701 0.363751065 4.86 5.971767123999999 4.426744234 0.633639571 0.974407583 0.487203791 0.621675663 pujolal01 beltrca01
103 2005 0 ALS200507120 NL 0.8224174670000001 0.045980764 0.531435294 4.59 5.412417467 4.012583942 0.6335894120000001 0.971563981 0.485781991 0.62028527 pujolal01 clemero02
104 1941 0 ALS194107080 NL 0.865196605 0.10929283 0.40968469999999996 4.49 5.355196605 3.9710224710000004 0.633497374 0.78957346 0.39478673 0.529967776 mizejo01 reisepe01
105 1980 0 NLS198007080 AL 0.9190989759999999 0.202455 0.217784423 4.29 5.209098976 3.869760577 0.632719677 0.9004739340000001 0.45023696700000004 0.585207672 randowi01 lynnfr01
106 1984 0 NLS198407100 NL 0.77360128 0.238656636 0.27311109 4.26 5.03360128 3.748232274 0.631714239 0.9118483409999999 0.455924171 0.5897219 cartega01 murphda05
107 2007 0 NLS200707100 AL 0.993807056 -0.062614289 0.540712042 4.8 5.793807056 4.321902247 0.630965708 0.977251185 0.48862559200000005 0.620308172 rodrial01 beckejo02
108 2003 0 ALS200307150 AL 1.012007575 -0.08896060800000001 0.532143069 4.73 5.742007575 4.286817538999999 0.6306121 0.9658767770000001 0.48293838899999997 0.61457176 rodrial01 muldema01
109 1951 0 ALS195107100 AL 0.880162578 0.089970399 0.399959939 4.55 5.430162577999999 4.060069662 0.62997444 0.8180094790000001 0.409004739 0.540914786 willite01 garvene01
110 1993 0 ALS199307130 NL 1.147892873 0.019452419 0.27705077 4.6 5.747892873 4.3034968110000005 0.629392596 0.9374407579999999 0.46872037899999996 0.599727505 bondsba01 larkiba01
111 2007 0 NLS200707100 NL 0.849330444 0.11608576300000001 0.43796309999999994 4.8 5.649330443999999 4.245951137 0.627754423 0.977251185 0.48862559200000005 0.617060432 wrighda03 beltrca01
112 1953 0 NLS195307140 AL 1.0076552140000001 0.007180682 0.368985626 4.61 5.617655214 4.233833693 0.62657138 0.823696682 0.411848341 0.54021449 rosenal01 piercbi02
113 1989 0 ALS198907110 NL 0.947211831 0.054290532 0.24687662300000002 4.13 5.0772118310000005 3.828832846 0.626312627 0.9260663509999999 0.463033175 0.59104632 smithoz01 mitchke01
114 2005 0 ALS200507120 AL 1.091657733 -0.105425984 0.408796719 4.59 5.681657733 4.286629265 0.626115628 0.971563981 0.485781991 0.6127059970000001 rodrial01 guerrvl01
115 1950 0 ALS195007110 NL 1.0929853170000001 0.034095825 0.33117278699999997 4.85 5.942985317000001 4.484731388 0.626025937 0.815165877 0.40758293799999995 0.535251149 musiast01 kinerra01
116 1963 0 ALS196307090 NL 0.88756209 0.09270855300000001 0.199336252 3.95 4.83756209 3.657955196 0.625157355 0.8521327009999999 0.426066351 0.553192541 mayswi01 aaronha01
117 2006 0 NLS200607110 AL 0.905363805 -0.085897899 0.580961904 4.86 5.765363805 4.364935995 0.6246246520000001 0.974407583 0.487203791 0.612546365 hallaro01 rodrial01
118 1943 0 ALS194307130 NL 0.794005405 0.123842774 0.224699702 3.91 4.704005405 3.5614575239999997 0.624615963 0.7952606640000001 0.39763033200000003 0.523442509 musiast01 coopemo01
119 1971 0 ALS197107130 NL 1.030777335 -0.008171438 0.171504847 3.89 4.920777335 3.7266665910000003 0.624490608 0.874881517 0.437440758 0.563922696 benchjo01 clemero01
120 1971 0 ALS197107130 AL 0.828100477 -0.010847288 0.32216181 3.89 4.718100477 3.578685478 0.623828805 0.874881517 0.437440758 0.563228806 yastrca01 bluevi01
121 1979 0 ALS197907170 AL 0.901764275 0.094497835 0.298045199 4.46 5.361764275 4.067456966 0.6237705570000001 0.897630332 0.448815166 0.574472919 brettge01 riceji01
122 1955 0 NLS195507120 NL 1.075505854 0.12014517300000001 0.143005516 4.48 5.555505854 4.216849311 0.623524074 0.8293838859999999 0.41469194299999995 0.5398977220000001 mayswi01 musiast01
123 1991 0 ALS199107090 AL 0.8887552609999999 0.09135856199999999 0.27243305100000004 4.31 5.1987552610000005 3.946208387 0.6235080789999999 0.931753555 0.465876777 0.590917542 ripkeca01 griffke02
124 1933 0 ALS193307060 NL 0.853086062 -0.060718015 0.491376914 4.48 5.333086062 4.049341101 0.623384301 0.766824645 0.383412322 0.50721158 warnelo01 kleinch01
125 1936 0 NLS193607070 NL 0.7433054179999999 0.124014205 0.56054366 5.19 5.933305418 4.505442135 0.623349732 0.77535545 0.387677725 0.5116744520000001 hubbeca01 medwijo01
126 1958 0 ALS195807080 AL 1.054736708 0.07521514 0.150704633 4.28 5.334736708 4.054080228 0.6230146529999999 0.837914692 0.418957346 0.543715265 mantlmi01 willite01
127 1996 0 NLS199607090 AL 0.953760032 0.11395765 0.371048959 5.04 5.993760032000001 4.554993391 0.623005696 0.945971564 0.472985782 0.597284546 belleal01 nagych01
128 1934 0 NLS193407100 NL 0.76890817 0.02850947 0.5609842629999999 4.91 5.67890817 4.320506267 0.622529153 0.769668246 0.384834123 0.507803757 deandi01 hubbeca01
129 1962 2 NLS196207300 AL 0.70912504 0.112984239 0.410426245 4.46 5.16912504 3.936589515 0.622100016 0.8492890999999999 0.42464455 0.548530669 aguirha01 marisro01
130 1948 0 ALS194807130 NL 0.8232397379999999 0.080752826 0.377922818 4.58 5.403239738 4.121324356000001 0.621426695 0.809478673 0.404739336 0.527435434 musiast01 mizejo01
131 1957 0 NLS195707090 NL 1.191538345 0.10707488800000001 0.0012924780000000001 4.31 5.501538345 4.201632634 0.620879961 0.83507109 0.417535545 0.540010867 mayswi01 aaronha01
132 1962 1 ALS196207100 NL 0.724825442 0.22119381100000002 0.277471058 4.46 5.184825442 3.9613351310000002 0.620707845 0.8492890999999999 0.42464455 0.5470647989999999 mayswi01 drysddo01
133 1959 2 NLS195908030 AL 0.835815596 0.245427459 0.14635598800000002 4.38 5.2158155960000006 3.988216553 0.6203615060000001 0.840758294 0.420379147 0.542364622 mantlmi01 foxne01
134 1935 0 ALS193507080 NL 1.0584755559999999 0.081320827 0.261973613 4.9 5.958475556000001 4.556705561 0.620302654 0.772511848 0.386255924 0.5069383470000001 vaughar01 ottme01
135 1970 0 NLS197007140 NL 1.056918818 -0.126728512 0.339315546 4.34 5.396918818 4.1274129660000005 0.620286542 0.872037915 0.43601895700000004 0.558093875 gibsobo01 seaveto01
136 1973 0 ALS197307240 AL 0.8144052490000001 0.15133365099999999 0.21284151899999998 4.21 5.024405249 3.84582483 0.619916482 0.88056872 0.44028436 0.5619760570000001 jacksre01 murcebo01
137 1966 0 NLS196607120 AL 0.8392382159999999 0.15041359 0.141997924 3.99 4.829238216 3.6975884860000003 0.619782331 0.860663507 0.430331754 0.551844665 robinfr02 olivato01
138 1944 0 NLS194407110 AL 0.699923788 0.067698078 0.372859987 4.17 4.869923788 3.729441935 0.619701164 0.798104265 0.399052133 0.519705761 doerrbo01 johnsbo01
139 1979 0 ALS197907170 NL 0.957583375 0.105601735 0.16962281199999998 4.46 5.417583375 4.184775453 0.615975335 0.897630332 0.448815166 0.566366351 parkeda01 winfida01
140 1962 1 ALS196207100 AL 0.746446677 0.076326062 0.35344539700000005 4.46 5.206446677 4.0302285410000005 0.615056217 0.8492890999999999 0.42464455 0.541127073 pascuca02 mantlmi01
141 1987 0 ALS198707140 NL 0.8305745609999999 0.037266519 0.38542919200000003 4.72 5.550574561 4.2973042889999995 0.6149864629999999 0.920379147 0.46018957299999996 0.576578233 daviser01 raineti01
142 2000 0 NLS200007110 AL 1.098238392 0.019877895 0.28448202300000003 5.14 6.238238392 4.835640082 0.614453707 0.957345972 0.478672986 0.594044931 rodriiv01 jeterde01
143 1995 0 ALS199507110 NL 1.25251296 -0.034988166 0.152659646 4.85 6.10251296 4.73232852 0.614279826 0.943127962 0.471563981 0.586974357 bondsba01 piazzmi01
144 1942 0 NLS194207060 NL 0.6306151879999999 0.07345551 0.351797845 4.08 4.710615188 3.654746645 0.614066673 0.7924170620000001 0.39620853100000003 0.510785991 coopemo01 ottme01
145 1991 0 ALS199107090 NL 0.690815705 0.01222347 0.416390065 4.31 5.000815705 3.881386465 0.613900502 0.931753555 0.465876777 0.5810371320000001 glavito02 sandbry01
146 1987 0 ALS198707140 AL 0.8672747129999999 -0.004033881 0.36992878 4.72 5.587274712999999 4.3541051 0.6121483529999999 0.920379147 0.46018957299999996 0.573653277 saberbr01 boggswa01
147 1962 2 NLS196207300 NL 0.813652128 0.15244888 0.19669806399999998 4.46 5.273652128 4.110853056 0.612026701 0.8492890999999999 0.42464455 0.537952814 robinfr02 mayswi01
148 1989 0 ALS198907110 AL 0.706172281 -0.029731933 0.389057064 4.13 4.8361722810000005 3.7706748689999996 0.611929795 0.9260663509999999 0.463033175 0.576224544 boggswa01 puckeki01
149 1959 1 NLS195907070 AL 0.721370095 0.19334726 0.19832810399999998 4.38 5.101370095 3.988324636 0.610742025 0.840758294 0.420379147 0.532258928 foxne01 minosmi01
150 1952 0 NLS195207080 AL 0.769717932 0.085275109 0.215571552 4.18 4.9497179319999995 3.8791533389999997 0.6096868320000001 0.820853081 0.41042654 0.520936166 berrayo01 rosenal01
151 1981 0 ALS198108090 NL 0.6430053020000001 0.143997339 0.216713894 4.0 4.643005302 3.639288767 0.609625823 0.903317536 0.451658768 0.562611823 schmimi01 dawsoan01
152 2008 0 ALS200807150 AL 0.8193948459999999 -0.068336185 0.43018479600000004 4.65 5.469394846 4.288151388999999 0.609512005 0.9800947870000001 0.490047393 0.59999535 sizemgr01 riverma01
153 2011 0 NLS201107120 AL 0.8892993659999999 -0.0371737 0.257155678 4.28 5.169299366000001 4.0600180219999995 0.608744071 0.988625592 0.494312796 0.603312441 bautijo02 beltrad01
154 2010 0 ALS201007130 AL 0.772858383 -0.023845724 0.35279753 4.38 5.152858383 4.051048194 0.608319539 0.985781991 0.492890995 0.601523244 hamiljo03 longoev01
155 1940 0 NLS194007090 NL 0.691021887 0.114941007 0.333660737 4.68 5.371021887 4.231398256 0.60740776 0.786729858 0.393364929 0.500809789 vaughar01 mizejo01
156 1961 1 NLS196107110 NL 0.9521278809999999 0.076918831 0.13131251 4.53 5.482127881 4.321768659 0.607120974 0.846445498 0.423222749 0.5313759220000001 mayswi01 boyerke01
157 2004 0 NLS200407130 AL 0.9930944270000001 -0.113571899 0.338923456 4.81 5.803094427 4.584648443 0.6061817860000001 0.9687203790000001 0.48436019 0.591147436 rodrial01 suzukic01
158 1949 0 NLS194907120 AL 0.891048042 0.092629672 0.17130366800000002 4.61 5.501048042000001 4.34606666 0.606177215 0.812322275 0.406161137 0.512850499 willite01 dimagjo01
159 1961 2 ALS196107310 NL 0.91978178 0.05325322 0.157168374 4.53 5.44978178 4.319578406000001 0.6047566520000001 0.846445498 0.423222749 0.5289094679999999 mayswi01 matheed01
160 1950 0 ALS195007110 AL 0.92905268 0.107794343 0.159934797 4.85 5.77905268 4.58227086 0.604593622 0.815165877 0.40758293799999995 0.5126663020000001 dobyla01 willite01
161 2002 0 NLS200207090 AL 0.6159279879999999 0.021489748 0.405138657 4.62 5.235927988 4.193371593999999 0.600207888 0.963033175 0.48151658799999997 0.58233447 lowede01 rodrial01
162 1960 2 ALS196007130 AL 0.743714443 0.16144499199999998 0.095169164 4.31 5.0537144430000005 4.053385844 0.599563062 0.8436018959999999 0.42180094799999995 0.522050735 mantlmi01 marisro01
163 1965 0 ALS196507130 AL 0.651975846 0.025031354 0.23977473800000002 3.99 4.641975846 3.725193908 0.5993214929999999 0.857819905 0.42890995299999995 0.529051962 killeha01 mcdowsa01
164 1938 0 NLS193807060 NL 0.8871398559999999 0.07783231 0.147711346 4.89 5.777139856 4.6644563439999995 0.596645068 0.7810426540000001 0.39052132700000003 0.486599244 ottme01 medwijo01
165 1963 0 ALS196307090 AL 0.32920684100000003 0.173255338 0.279704264 3.95 4.279206841000001 3.497040398 0.591310779 0.8521327009999999 0.426066351 0.517859401 kalinal01 radatdi01
166 1980 0 NLS198007080 NL 0.568958034 -0.005197667 0.254886431 4.29 4.858958034 4.040311236 0.5836169410000001 0.9004739340000001 0.45023696700000004 0.534426914 hernake01 suttebr01
167 1988 0 NLS198807120 NL 0.6095272970000001 -0.023760211 0.19719615699999998 4.14 4.749527297 3.966564055 0.581677884 0.923222749 0.46161137399999996 0.543839089 strawda01 smithoz01
168 1943 0 ALS194307130 AL 0.565686742 -0.021919415 0.164706943 3.91 4.475686742 3.7672124719999998 0.578191518 0.7952606640000001 0.39763033200000003 0.475022114 hughste01 doerrbo01
169 1985 0 ALS198507160 NL 0.5972544679999999 0.12428192699999999 0.04063967 4.33 4.927254468 4.165078403 0.576281198 0.914691943 0.45734597200000005 0.534070591 smithoz01 murphda05
170 1948 0 ALS194807130 AL 0.538847851 0.14590435300000001 0.08984467900000001 4.58 5.118847851 4.344250968 0.574505863 0.809478673 0.404739336 0.478638756 boudrlo01 henrito01
171 1960 1 ALS196007110 AL 0.6286712170000001 0.08881624 -0.01157894 4.31 4.938671217 4.2327627 0.570100642 0.8436018959999999 0.42180094799999995 0.49172003299999995 mantlmi01 marisro01
172 1946 0 ALS194607090 NL 0.435360098 0.06455843900000001 0.130359685 4.01 4.445360098 3.8150818760000003 0.569498347 0.8037914690000001 0.401895735 0.470592058 musiast01 kurowwh01

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "mlb-allstar-teams/allstar_team_talent" (
"yearID" INTEGER,
  "gameNum" INTEGER,
  "gameID" TEXT,
  "lgID" TEXT,
  "tm_OFF_talent" REAL,
  "tm_DEF_talent" REAL,
  "tm_PIT_talent" REAL,
  "MLB_avg_RPG" REAL,
  "talent_RSPG" REAL,
  "talent_RAPG" REAL,
  "unadj_PYTH" REAL,
  "timeline_adj" REAL,
  "SOS" REAL,
  "adj_PYTH" REAL,
  "no_1_player" TEXT,
  "no_2_player" TEXT
)
Powered by Datasette · Query took 5.605ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub