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 bbref_ID

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
1104 aaronha01 1974 0 NLS197407230 NL 9 20.77349345 -6.853186805 0.0 2 0.0 0.069244978 -0.022843956000000002 0.0 0.046401022
1139 aaronha01 1972 0 NLS197207250 NL 9 31.812861699999996 -9.466043268 0.0 3 0.0 0.15906430900000001 -0.047330215999999994 0.0 0.111734092
1190 aaronha01 1970 0 NLS197007140 NL 9 28.99826752 -2.654269312 0.0 2 0.0 0.069595842 -0.0063702459999999995 0.0 0.063225596
1229 aaronha01 1968 0 NLS196807090 NL 9 29.53238315 -0.36886911899999997 0.0 4 0.0 0.22149287399999998 -0.002766518 0.0 0.218726355
1279 aaronha01 1966 0 NLS196607120 NL 7 30.87815399 1.127031556 0.0 4 0.0 0.211735913 0.0077282159999999996 0.0 0.21946412899999998
1323 aaronha01 1964 0 NLS196407070 NL   38.79245862 -4.13221168 0.0 1 0.0 0.064654098 -0.006887019 0.0 0.057767078
1353 aaronha01 1962 2 NLS196207300 NL   38.10673774 5.603011936000001 0.0 2 0.0 0.12358942 0.018171931000000002 0.0 0.14176135
1403 aaronha01 1961 1 NLS196107110 NL   39.36823765 5.080221559 0.0 1 0.0 0.057612055 0.007434471 0.0 0.065046526
1441 aaronha01 1959 2 NLS195908030 NL 9 44.47477691 -3.638336272 0.0 4 0.0 0.288485039 -0.023600019 0.0 0.26488502
1481 aaronha01 1959 1 NLS195907070 NL 9 44.47477691 -3.638336272 0.0 4 0.0 0.344320853 -0.028167765 0.0 0.316153089
1519 aaronha01 1957 0 NLS195707090 NL 9 36.3811343 1.364571671 0.0 4 0.0 0.249470635 0.009357063 0.0 0.258827698
1567 aaronha01 1955 0 NLS195507120 NL   17.40299584 -1.87152689 0.0 3 0.0 0.069611983 -0.007486108000000001 0.0 0.062125876
3020 aaronha01 1975 0 ALS197507150 AL   6.378331031 -8.397255834 0.0 1 0.0 0.010071049 -0.013258825 0.0 -0.003187776
3028 aaronha01 1973 0 ALS197307240 NL 3 33.63172515 -8.881880257 0.0 2 0.0 0.103482231 -0.027328862000000002 0.0 0.076153369
3079 aaronha01 1971 0 ALS197107130 NL 9 38.83753467 -6.917492362000001 0.0 2 0.0 0.145640755 -0.025940596 0.0 0.119700159
3119 aaronha01 1969 0 ALS196907230 NL 9 34.25782354 -1.300521582 0.0 4 0.0 0.200533601 -0.007612809 0.0 0.19292079199999998
3168 aaronha01 1967 0 ALS196707110 NL 8 35.6302295 -1.012322589 0.0 6 0.0 0.256537652 -0.007288723 0.0 0.24924893
3213 aaronha01 1965 0 ALS196507130 NL 9 36.61615287 -2.70739808 0.0 5 0.0 0.281662714 -0.020826139 0.0 0.260836575
3253 aaronha01 1963 0 ALS196307090 NL 9 43.19936545 -0.926122744 0.0 4 0.0 0.29622422 -0.006350555999999999 0.0 0.289873664
3332 aaronha01 1961 2 ALS196107310 NL   39.36823765 5.080221559 0.0 2 0.0 0.134976815 0.017417902 0.0 0.15239471699999999
3365 aaronha01 1960 2 ALS196007130 NL 9 40.42510995 -0.6687061089999999 0.0 3 0.0 0.20212555 -0.003343531 0.0 0.19878201899999998
3412 aaronha01 1960 1 ALS196007110 NL 9 40.42510995 -0.6687061089999999 0.0 4 0.0 0.262216929 -0.004337553 0.0 0.257879376
3460 aaronha01 1958 0 ALS195807080 NL 9 36.74368207 1.55634606 0.0 4 0.0 0.259367168 0.010985972 0.0 0.27035314
3501 aaronha01 1956 0 ALS195607100 NL   25.01939176 1.5599298380000002 0.0 1 0.0 0.039504303 0.0024630470000000003 0.0 0.04196735
853 aasedo01 1986 0 NLS198607150 AL   0.0 0.0 4.751520128 0 0.667 0.0 0.0 0.015844558999999998 0.015844558999999998
345 abreubo01 2004 0 NLS200407130 NL   30.14559417 -2.62318423 0.0 1 0.0 0.047598307 -0.00414187 0.0 0.043456437
2197 abreubo01 2005 0 ALS200507120 NL 9 25.2726891 -6.305986227000001 0.0 3 0.0 0.113727101 -0.028376937999999997 0.0 0.085350163
1991 abreujo02 2014 0 ALS201407150 AL   32.83711423 -13.40606359 0.0 1 0.0 0.059703844000000006 -0.024374661000000002 0.0 0.035329183
3378 adcocjo01 1960 2 ALS196007130 NL 3 14.95981524 -4.938371308 0.0 2 0.0 0.049866050999999995 -0.016461238 0.0 0.033404813
3417 adcocjo01 1960 1 ALS196007110 NL 3 14.95981524 -4.938371308 0.0 3 0.0 0.07277748 -0.024024509 0.0 0.04875297
1312 ageeto01 1966 0 NLS196607120 AL   9.855369499 9.490104253 0.0 0 0.0 0.0 0.0 0.0 0.0
3208 ageeto01 1967 0 ALS196707110 AL   9.209678296 12.05890944 0.0 0 0.0 0.0 0.0 0.0 0.0
709 aguilri01 1992 0 NLS199207140 AL   0.0 0.0 2.3128278190000002 0 0.667 0.0 0.0 0.007712424 0.007712424
2556 aguilri01 1993 0 ALS199307130 AL   0.0 0.0 7.209478602000001 0 1.0 0.0 0.0 0.036047393 0.036047393
2601 aguilri01 1991 0 ALS199107090 AL   0.0 0.0 6.950240107000001 0 1.3330000000000002 0.0 0.0 0.04632335 0.04632335
1376 aguirha01 1962 2 NLS196207300 AL   0.0 0.0 17.07939091 0 3.0 0.0 0.0 0.25619086399999996 0.25619086399999996
454 alfoned01 2000 0 NLS200007110 NL   23.57111137 4.444511658 0.0 2 0.0 0.076446848 0.014414632 0.0 0.09086148
1123 allendi01 1974 0 NLS197407230 AL 3 34.77316061 -10.63342411 0.0 2 0.0 0.115910535 -0.035444747 0.0 0.080465788
1162 allendi01 1972 0 NLS197207250 AL 3 36.23920494 -10.532477499999999 0.0 3 0.0 0.19185461399999998 -0.055760175 0.0 0.136094439
1192 allendi01 1970 0 NLS197007140 NL 3 26.465388 -18.57228498 0.0 4 0.0 0.127033862 -0.08914696800000001 0.0 0.037886894
1284 allendi01 1966 0 NLS196607120 NL   39.66153459 -3.87313706 0.0 1 0.0 0.067991202 -0.006639664 0.0 0.061351539000000004
3170 allendi01 1967 0 ALS196707110 NL 5 38.94674138 -7.904635101 0.0 4 0.0 0.18694435899999998 -0.037942248 0.0 0.14900211
3214 allendi01 1965 0 ALS196507130 NL 5 30.78082448 -1.48568609 0.0 3 0.0 0.142065344 -0.006857013 0.0 0.135208331
1873 allenjo02 1938 0 NLS193807060 AL   0.0 0.0 11.18805562 0 3.0 0.0 0.0 0.18879843899999998 0.18879843899999998
3172 alleyge01 1967 0 ALS196707110 NL 6 0.791992823 16.00917764 0.0 5 0.0 0.004751957 0.096055066 0.0 0.10080702300000001
1337 allisbo01 1964 0 NLS196407070 AL 3 31.82906887 0.682263842 0.0 4 0.0 0.212193792 0.0045484259999999995 0.0 0.21674221800000001
3279 allisbo01 1963 0 ALS196307090 AL   21.99881956 1.8435017130000002 0.0 1 0.0 0.037712262 0.003160289 0.0 0.040872551
478 alomaro01 2000 0 NLS200007110 AL 4 15.4955517 7.88198924 0.0 3 0.0 0.0648651 0.032994374 0.0 0.097859474
535 alomaro01 1998 0 NLS199807070 AL 4 9.288565862 4.231785669 0.0 5 0.0 0.055731395 0.025390713999999998 0.0 0.081122109
593 alomaro01 1996 0 NLS199607090 AL 4 15.95091919 -3.175297069 0.0 3 0.0 0.08444604300000001 -0.016810396000000002 0.0 0.06763564700000001
637 alomaro01 1994 0 NLS199407120 AL 4 23.37936828 -1.739027493 0.0 3 0.0 0.091484485 -0.00680489 0.0 0.084679594
688 alomaro01 1992 0 NLS199207140 AL 4 18.84685513 2.889737017 0.0 3 0.0 0.07889381200000001 0.012096573999999999 0.0 0.09099038599999999
727 alomaro01 1990 0 NLS199007100 NL   9.528013478 6.285821175 0.0 1 0.0 0.018441316 0.012166105 0.0 0.030607422000000002
2336 alomaro01 2001 0 ALS200107100 AL   27.17405632 3.3847579110000003 0.0 2 0.0 0.09881475 0.012308211000000001 0.0 0.11112296099999999
2396 alomaro01 1999 0 ALS199907130 AL 4 16.68939202 6.812096962999999 0.0 2 0.0 0.058903737000000005 0.024042695 0.0 0.082946432
2453 alomaro01 1997 0 ALS199707080 AL 4 16.34495164 -1.912080428 0.0 2 0.0 0.063270781 -0.007401601999999999 0.0 0.055869179000000005
2510 alomaro01 1995 0 ALS199507110 AL   15.99938599 -3.989117694 0.0 1 0.0 0.026665643 -0.006648529 0.0 0.020017114
2544 alomaro01 1993 0 ALS199307130 AL 4 26.78344738 0.034830696 0.0 3 0.0 0.120525513 0.000156738 0.0 0.12068225099999999
2598 alomaro01 1991 0 ALS199107090 AL 4 12.40152295 2.586652114 0.0 4 0.0 0.08267682 0.017244347 0.0 0.09992116699999999
1227 alomasa01 1970 0 NLS197007140 AL   -14.91263932 5.417399648 0.0 1 0.0 -0.019037412 0.006915829 0.0 -0.012121583
554 alomasa02 1998 0 NLS199807070 AL   -16.35285358 9.584946248 0.0 1 0.0 -0.019623424 0.011501935 0.0 -0.008121489
603 alomasa02 1996 0 NLS199607090 AL   -9.614835567 8.192839544 0.0 2 0.0 -0.033934714 0.028915904 0.0 -0.005018809
711 alomasa02 1992 0 NLS199207140 AL 2 -13.75734311 10.87900305 0.0 3 0.0 -0.057588877999999996 0.045540013 0.0 -0.012048865
759 alomasa02 1990 0 NLS199007100 AL 2 -1.293553597 3.095624204 0.0 3 0.0 -0.005970247 0.014287496 0.0 0.008317249
2459 alomasa02 1997 0 ALS199707080 AL   -1.2028033679999999 8.071854027999999 0.0 1 0.0 -0.002328007 0.015622943 0.0 0.013294937
2616 alomasa02 1991 0 ALS199107090 AL 2 -11.49270072 3.830308515 0.0 2 0.0 -0.038309002 0.012767695 0.0 -0.025541307000000003
1245 aloufe01 1968 0 NLS196807090 NL   16.08406973 -5.626075029 0.0 0 0.0 0.0 0.0 0.0 0.0
3302 aloufe01 1962 1 ALS196207100 NL   16.179243 -1.151902661 0.0 1 0.0 0.028551605 -0.002032769 0.0 0.026518836
1237 alouma01 1968 0 NLS196807090 NL   17.91315064 -5.154917286 0.0 1 0.0 0.033587157 -0.00966547 0.0 0.023921687999999997
3126 alouma01 1969 0 ALS196907230 NL 8 17.1039972 -3.7709915689999995 0.0 5 0.0 0.125151199 -0.027592621 0.0 0.097558578
354 aloumo01 2004 0 NLS200407130 NL   7.365783853 -8.230764381 0.0 2 0.0 0.02326037 -0.025991887999999998 0.0 -0.002731517
511 aloumo01 1998 0 NLS199807070 NL   20.41435641 -3.789661455 0.0 3 0.0 0.087490099 -0.016241406 0.0 0.071248693
617 aloumo01 1994 0 NLS199407120 NL   19.16485306 1.9107782969999998 0.0 1 0.0 0.029484389 0.0029396590000000003 0.0 0.032424048
2211 aloumo01 2005 0 ALS200507120 NL   14.38892069 -7.957575075 0.0 2 0.0 0.043166762000000004 -0.023872725 0.0 0.019294037
2324 aloumo01 2001 0 ALS200107100 NL   21.03503017 -11.15694712 0.0 1 0.0 0.039440682000000005 -0.020919276 0.0 0.018521406
2434 aloumo01 1997 0 ALS199707080 NL   8.385602597 -4.252147054 0.0 2 0.0 0.0304931 -0.015462353 0.0 0.015030746999999999
1368 altmage01 1962 2 NLS196207300 NL   17.05812201 -8.040664474 0.0 1 0.0 0.027661819 -0.013038915 0.0 0.014622903999999999
1408 altmage01 1961 1 NLS196107110 NL   11.67462833 -4.996226299 0.0 1 0.0 0.017084822 -0.0073115509999999995 0.0 0.009773271
3341 altmage01 1961 2 ALS196107310 NL   11.67462833 -4.996226299 0.0 1 0.0 0.020013648999999998 -0.008564959 0.0 0.011448689
44 altuvjo01 2015 0 NLS201507140 AL 4 8.917639485 1.3888149230000002 0.0 2 0.0 0.028160967000000002 0.0043857309999999995 0.0 0.032546698
2000 altuvjo01 2014 0 ALS201407150 AL   10.0698384 -3.4986291730000003 0.0 1 0.0 0.018308796999999998 -0.006361144 0.0 0.011947653
2040 altuvjo01 2012 0 ALS201207100 NL   2.031136054 -6.304772966 0.0 1 0.0 0.0030467040000000003 -0.009457159 0.0 -0.006410455
81 alvarpe01 2013 0 NLS201307160 NL   1.541331175 -0.8415766990000001 0.0 1 0.0 0.0029832220000000002 -0.001628858 0.0 0.001354364
645 alvarwi01 1994 0 NLS199407120 AL   0.0 0.0 8.407345845 0 1.0 0.0 0.0 0.042036729 0.042036729
3209 alvisma01 1967 0 ALS196707110 AL   -4.063761836 -0.956661159 0.0 1 0.0 -0.004688956 -0.00110384 0.0 -0.005792795999999999
3248 alvisma01 1965 0 ALS196507130 AL   1.3271976890000001 -2.954860079 0.0 1 0.0 0.0019907970000000003 -0.00443229 0.0 -0.0024414939999999998
594 anderbr01 1996 0 NLS199607090 AL 9 20.2459395 -1.681977736 0.0 2 0.0 0.071456257 -0.0059363919999999995 0.0 0.065519865
699 anderbr01 1992 0 NLS199207140 AL   9.711161227 -1.182045168 0.0 3 0.0 0.040651373 -0.004948096 0.0 0.035703277
2446 anderbr01 1997 0 ALS199707080 AL 7 21.10515095 -6.527918561 0.0 4 0.0 0.163394717 -0.05053872400000001 0.0 0.112855993
427 anderga01 2002 0 NLS200207090 AL   3.255068323 1.6066109869999998 0.0 4 0.0 0.016982965 0.008382318 0.0 0.025365283
2249 anderga01 2005 0 ALS200507120 AL   0.438852814 -8.779993757 0.0 2 0.0 0.001504638 -0.030102836 0.0 -0.028598198
2285 anderga01 2003 0 ALS200307150 AL 7 10.21483069 -1.740974894 0.0 4 0.0 0.06809887099999999 -0.011606499 0.0 0.056492372
3158 andremi01 1969 0 ALS196907230 AL   13.32669724 0.06263879900000001 0.0 1 0.0 0.022845767000000003 0.00010738100000000001 0.0 0.022953147
2065 andruel01 2012 0 ALS201207100 AL   -0.993358044 8.788727016000001 0.0 1 0.0 -0.0017029 0.015066389 0.0 0.01336349
2124 andruel01 2010 0 ALS201007130 AL   -8.437853524 7.293773882000001 0.0 1 0.0 -0.014464892 0.012503611999999999 0.0 -0.001961279
2904 andujjo01 1979 0 ALS197907170 NL   0.0 0.0 -3.656107825 0 2.0 0.0 0.0 -0.036561078 -0.036561078
1491 antonjo02 1959 1 NLS195907070 NL   0.0 0.0 5.278918346 0 0.33299999999999996 0.0 0.0 0.008789399 0.008789399
3492 antonjo02 1956 0 ALS195607100 NL   0.0 0.0 11.33827169 0 4.0 0.0 0.0 0.226765434 0.226765434
3534 antonjo02 1954 0 ALS195407130 NL   0.0 0.0 11.74152359 0 2.0 0.0 0.0 0.13209214 0.13209214
1208 aparilu01 1970 0 NLS197007140 AL 6 1.6364208969999998 10.65457151 0.0 6 0.0 0.012534288000000001 0.08160948400000001 0.0 0.09414377199999999

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 117.268ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub