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

63 rows where asg_IP = "0.667"

✎ 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
48 48 brittza01 2015 0 NLS201507140 AL   0.0 0.0 6.354951044 0 0.667 0.0 0.0 0.021193762 0.021193762
130 130 ventejo01 2011 0 NLS201107120 NL   0.0 0.0 8.499595994 0 0.667 0.0 0.0 0.028346153 0.028346153
135 135 wilsobr01 2011 0 NLS201107120 NL   0.0 0.0 4.379006264 0 0.667 0.0 0.0 0.014603986 0.014603986
158 158 ogandal01 2011 0 NLS201107120 AL   0.0 0.0 8.67284933 0 0.667 0.0 0.0 0.032539447 0.032539447
264 264 putzjj01 2007 0 NLS200707100 AL   0.0 0.0 15.25629424 0 0.667 0.0 0.0 0.050879741 0.050879741
371 371 rodrifr03 2004 0 NLS200407130 AL   0.0 0.0 9.927184854 0 0.667 0.0 0.0 0.033107161 0.033107161
399 399 remlimi01 2002 0 NLS200207090 NL   0.0 0.0 8.315251078 0 0.667 0.0 0.0 0.022689296 0.022689296
433 433 guarded01 2002 0 NLS200207090 AL   0.0 0.0 6.623899546 0 0.667 0.0 0.0 0.018074213 0.018074213
509 509 brownke01 1998 0 NLS199807070 NL   0.0 0.0 23.10342914 0 0.667 0.0 0.0 0.077049936 0.077049936
575 575 wohlema01 1996 0 NLS199607090 NL   0.0 0.0 4.333621266 0 0.667 0.0 0.0 0.014452627 0.014452627
621 621 drabedo01 1994 0 NLS199407120 NL   0.0 0.0 5.906470543 0 0.667 0.0 0.0 0.017726499 0.017726499
624 624 hudekjo01 1994 0 NLS199407120 NL   0.0 0.0 1.325469238 0 0.667 0.0 0.0 0.003977998 0.003977998
702 702 eckerde01 1992 0 NLS199207140 AL   0.0 0.0 10.26892684 0 0.667 0.0 0.0 0.034243066 0.034243066
703 703 montgje01 1992 0 NLS199207140 AL   0.0 0.0 10.02192616 0 0.667 0.0 0.0 0.03341941 0.03341941
709 709 aguilri01 1992 0 NLS199207140 AL   0.0 0.0 2.312827819 0 0.667 0.0 0.0 0.007712424 0.007712424
733 733 smithda02 1990 0 NLS199007100 NL   0.0 0.0 4.116381132 0 0.667 0.0 0.0 0.013728131 0.013728131
776 776 davisma01 1988 0 NLS198807120 NL   0.0 0.0 3.125340938 0 0.667 0.0 0.0 0.010423012 0.010423012
803 803 jonesdo01 1988 0 NLS198807120 AL   0.0 0.0 7.981706075 0 0.667 0.0 0.0 0.02661899 0.02661899
848 848 righeda01 1986 0 NLS198607150 AL   0.0 0.0 10.44268355 0 0.667 0.0 0.0 0.03482248 0.03482248
853 853 aasedo01 1986 0 NLS198607150 AL   0.0 0.0 4.751520128 0 0.667 0.0 0.0 0.015844559 0.015844559
911 911 mintogr01 1982 0 NLS198207130 NL   0.0 0.0 12.49444831 0 0.667 0.0 0.0 0.041668985 0.041668985
917 917 valenfe01 1982 0 NLS198207130 NL   0.0 0.0 7.574970264 0 0.667 0.0 0.0 0.025262526 0.025262526
998 998 farmeed01 1980 0 NLS198007080 AL   0.0 0.0 4.528192207 0 0.667 0.0 0.0 0.016989211 0.016989211
1036 1036 kernji01 1978 0 NLS197807110 AL   0.0 0.0 5.16257803 0 0.667 0.0 0.0 0.019369347 0.019369347
1247 1247 reedro01 1968 0 NLS196807090 NL   0.0 0.0 -4.239589381 0 0.667 0.0 0.0 -0.014139031 -0.014139031
1262 1262 johnto01 1968 0 NLS196807090 AL   0.0 0.0 8.830783395 0 0.667 0.0 0.0 0.033131995 0.033131995
1508 1508 daleybu01 1959 1 NLS195907070 AL   0.0 0.0 5.858738225 0 0.667 0.0 0.0 0.021981253 0.021981253
1553 1553 mossido01 1957 0 NLS195707090 AL   0.0 0.0 0.942137864 0 0.667 0.0 0.0 0.00314203 0.00314203
1573 1573 jonessa02 1955 0 NLS195507120 NL   0.0 0.0 2.039933376 0 0.667 0.0 0.0 0.005102383 0.005102383
1892 1892 daviscu01 1936 0 NLS193607070 NL   0.0 0.0 11.80760213 0 0.667 0.0 0.0 0.039378353 0.039378353
1961 1961 chapmar01 2014 0 ALS201407150 NL   0.0 0.0 8.28027011 0 0.667 0.0 0.0 0.031066538 0.031066538
1966 1966 clippty01 2014 0 ALS201407150 NL   0.0 0.0 4.91531776 0 0.667 0.0 0.0 0.018441658 0.018441658
2001 2001 doolise01 2014 0 ALS201407150 AL   0.0 0.0 3.206735686 0 0.667 0.0 0.0 0.010694464 0.010694464
2008 2008 kazmisc01 2014 0 ALS201407150 AL   0.0 0.0 -1.985688749 0 0.667 0.0 0.0 -0.006622272 -0.006622272
2024 2024 kimbrcr01 2012 0 ALS201207100 NL   0.0 0.0 12.11885797 0 0.667 0.0 0.0 0.040420883 0.040420883
2081 2081 hallaro01 2010 0 ALS201007130 NL   0.0 0.0 20.48679724 0 0.667 0.0 0.0 0.068323469 0.068323469
2086 2086 kuoho01 2010 0 ALS201007130 NL   0.0 0.0 12.18064915 0 0.667 0.0 0.0 0.040622465 0.040622465
2152 2152 lidgebr01 2008 0 ALS200807150 NL   0.0 0.0 6.097454481 0 0.667 0.0 0.0 0.012478018 0.012478018
2158 2158 wilsobr01 2008 0 ALS200807150 NL   0.0 0.0 -0.915233835 0 0.667 0.0 0.0 -0.001872963 -0.001872963
2208 2208 peavyja01 2005 0 ALS200507120 NL   0.0 0.0 11.20866594 0 0.667 0.0 0.0 0.042053514 0.042053514
2234 2234 ryanb.01 2005 0 ALS200507120 AL   0.0 0.0 11.60950572 0 0.667 0.0 0.0 0.038717702 0.038717702
2292 2292 hasegsh01 2003 0 ALS200307150 AL   0.0 0.0 11.40407556 0 0.667 0.0 0.0 0.038032592 0.038032592
2348 2348 stantmi02 2001 0 ALS200107100 AL   0.0 0.0 9.522135704 0 0.667 0.0 0.0 0.031756323 0.031756323
2370 2370 hamptmi01 1999 0 ALS199907130 NL   0.0 0.0 12.91038328 0 0.667 0.0 0.0 0.061188245 0.061188245
2477 2477 henketo01 1995 0 ALS199507110 NL   0.0 0.0 9.540589352 0 0.667 0.0 0.0 0.031817865 0.031817865
2514 2514 ontivst02 1995 0 ALS199507110 AL   0.0 0.0 3.153993428 0 0.667 0.0 0.0 0.010518568 0.010518568
2541 2541 burkejo03 1993 0 ALS199307130 NL   0.0 0.0 -3.423453413 0 0.667 0.0 0.0 -0.012844369 -0.012844369
2610 2610 reardje01 1991 0 ALS199107090 AL   0.0 0.0 4.968303759 0 0.667 0.0 0.0 0.016569293 0.016569293
2688 2688 francjo01 1987 0 ALS198707140 NL   0.0 0.0 6.586342525 0 0.667 0.0 0.0 0.015206852 0.015206852
2760 2760 hernawi01 1985 0 ALS198507160 AL   0.0 0.0 8.404518354 0 0.667 0.0 0.0 0.028029069 0.028029069
2784 2784 hammaat01 1983 0 ALS198307060 NL   0.0 0.0 7.020589482 0 0.667 0.0 0.0 0.026340374 0.026340374
2786 2786 perezpa01 1983 0 ALS198307060 NL   0.0 0.0 5.621876757 0 0.667 0.0 0.0 0.021092579 0.021092579
2894 2894 sambijo01 1979 0 ALS197907170 NL   0.0 0.0 6.926726649 0 0.667 0.0 0.0 0.023100633 0.023100633
3070 3070 holtzke01 1973 0 ALS197307240 AL   0.0 0.0 -1.014683724 0 0.667 0.0 0.0 -0.00338397 -0.00338397
3160 3160 knowlda01 1969 0 ALS196907230 AL   0.0 0.0 5.644649436 0 0.667 0.0 0.0 0.018824906 0.018824906
3423 3423 lawve01 1960 1 ALS196007110 NL   0.0 0.0 5.319742546 0 0.667 0.0 0.0 0.017741341 0.017741341
3469 3469 jacksla01 1958 0 ALS195807080 NL   0.0 0.0 3.940613069 0 0.667 0.0 0.0 0.014784688 0.014784688
3541 3541 spahnwa01 1954 0 ALS195407130 NL   0.0 0.0 11.82001114 0 0.667 0.0 0.0 0.044347204 0.044347204
3545 3545 erskica01 1954 0 ALS195407130 NL   0.0 0.0 1.587375268 0 0.667 0.0 0.0 0.005955634 0.005955634
3565 3565 lemonbo01 1954 0 ALS195407130 AL   0.0 0.0 4.068419516 0 0.667 0.0 0.0 0.013568179 0.013568179
3568 3568 keegabo01 1954 0 ALS195407130 AL   0.0 0.0 2.174337192 0 0.667 0.0 0.0 0.007251415 0.007251415
3649 3649 fellebo01 1950 0 ALS195007110 AL   0.0 0.0 3.384228146 0 0.667 0.0 0.0 0.007255543 0.007255543
3850 3850 hubbeca01 1937 0 ALS193707070 NL   0.0 0.0 10.74329489 0 0.667 0.0 0.0 0.0403075 0.0403075

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