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

27 rows where asg_IP = "1.667"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: bbref_ID, yearID, gameNum, gameID, lgID

Link rowid ▼ bbref_ID yearID gameNum gameID lgID startingPos OFF600 DEF600 PITCH200 asg_PA asg_IP OFFper9innASG DEFper9innASG PITper9innASG TOTper9innASG
114 114 leecl02 2011 0 NLS201107120 NL   0.0 0.0 19.31343762 0 1.667 0.0 0.0 0.160977503 0.160977503
124 124 jurrjja01 2011 0 NLS201107120 NL   0.0 0.0 6.194421057 0 1.667 0.0 0.0 0.0516305 0.0516305
618 618 beckro01 1994 0 NLS199407120 NL   0.0 0.0 4.101743908 0 1.667 0.0 0.0 0.030766155 0.030766155
662 662 glavito02 1992 0 NLS199207140 NL 1 0.0 0.0 10.24471883 0 1.667 0.0 0.0 0.085389731 0.085389731
666 666 tewksbo01 1992 0 NLS199207140 NL   0.0 0.0 9.144261128 0 1.667 0.0 0.0 0.076217417 0.076217417
847 847 houghch01 1986 0 NLS198607150 AL   0.0 0.0 6.76343194 0 1.667 0.0 0.0 0.056366942 0.056366942
1010 1010 suttebr01 1978 0 NLS197807110 NL   0.0 0.0 7.817117512 0 1.667 0.0 0.0 0.065155674 0.065155674
1219 1219 stottme01 1970 0 NLS197007140 AL   0.0 0.0 4.365879417 0 1.667 0.0 0.0 0.028071179 0.028071179
1223 1223 wrighcl01 1970 0 NLS197007140 AL   0.0 0.0 1.398068138 0 1.667 0.0 0.0 0.008989122 0.008989122
1406 1406 millest01 1961 1 NLS196107110 NL   0.0 0.0 4.303264048 0 1.667 0.0 0.0 0.032280935 0.032280935
1427 1427 wilheho01 1961 1 NLS196107110 AL   0.0 0.0 7.861729878 0 1.667 0.0 0.0 0.065527519 0.065527519
1485 1485 facero01 1959 1 NLS195907070 NL   0.0 0.0 8.326020669 0 1.667 0.0 0.0 0.069397382 0.069397382
1547 1547 piercbi02 1957 0 NLS195707090 AL   0.0 0.0 7.964968053 0 1.667 0.0 0.0 0.066388009 0.066388009
1594 1594 fordwh01 1955 0 NLS195507120 AL   0.0 0.0 5.14035724 0 1.667 0.0 0.0 0.0350549 0.0350549
1741 1741 mastewa02 1947 0 NLS194707080 AL   0.0 0.0 3.785341752 0 1.667 0.0 0.0 0.031550823 0.031550823
1772 1772 hughste01 1944 0 NLS194407110 AL   0.0 0.0 14.15527681 0 1.667 0.0 0.0 0.132732261 0.132732261
1773 1773 newhoha01 1944 0 NLS194407110 AL   0.0 0.0 11.24780203 0 1.667 0.0 0.0 0.105469234 0.105469234
2161 2161 riverma01 2008 0 ALS200807150 AL   0.0 0.0 16.98287744 0 1.667 0.0 0.0 0.08493137 0.08493137
2165 2165 soriajo01 2008 0 ALS200807150 AL   0.0 0.0 12.84553891 0 1.667 0.0 0.0 0.06424054 0.06424054
2645 2645 swindgr01 1989 0 ALS198907110 AL   0.0 0.0 10.73334088 0 1.667 0.0 0.0 0.089462396 0.089462396
2827 2827 hootobu01 1981 0 ALS198108090 NL   0.0 0.0 5.22141289 0 1.667 0.0 0.0 0.043520476 0.043520476
2857 2857 stiebda01 1981 0 ALS198108090 AL   0.0 0.0 10.54886777 0 1.667 0.0 0.0 0.087924813 0.087924813
3125 3125 koosmje01 1969 0 ALS196907230 NL   0.0 0.0 11.84857661 0 1.667 0.0 0.0 0.098757886 0.098757886
3215 3215 malonji01 1965 0 ALS196507130 NL   0.0 0.0 15.1170644 0 1.667 0.0 0.0 0.126000732 0.126000732
3415 3415 facero01 1960 1 ALS196007110 NL   0.0 0.0 7.076453505 0 1.667 0.0 0.0 0.05898224 0.05898224
3487 3487 turlebo01 1958 0 ALS195807080 AL 1 0.0 0.0 3.302571925 0 1.667 0.0 0.0 0.027526937 0.027526937
3656 3656 sainjo01 1948 0 ALS194807130 NL   0.0 0.0 12.40833651 0 1.667 0.0 0.0 0.11635142 0.11635142

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