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

16 rows where asg_IP = "1.333"

✎ 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
42 42 archech01 2015 0 NLS201507140 AL   0.0 0.0 5.405436997 0 1.333 0.0 0.0 0.036027238 0.036027238
508 508 glavito02 1998 0 NLS199807070 NL   0.0 0.0 15.98592044 0 1.333 0.0 0.0 0.10654616 0.10654616
660 660 maddugr01 1992 0 NLS199207140 NL   0.0 0.0 15.08877355 0 1.333 0.0 0.0 0.100566676 0.100566676
1677 1677 spahnwa01 1949 0 NLS194907120 NL 1 0.0 0.0 7.244878197 0 1.333 0.0 0.0 0.048287113 0.048287113
1743 1743 pagejo01 1947 0 NLS194707080 AL   0.0 0.0 3.473562211 0 1.333 0.0 0.0 0.023151292 0.023151292
1776 1776 muncrbo01 1944 0 NLS194407110 AL   0.0 0.0 6.707554105 0 1.333 0.0 0.0 0.050294079 0.050294079
2601 2601 aguilri01 1991 0 ALS199107090 AL   0.0 0.0 6.950240107 0 1.333 0.0 0.0 0.04632335 0.04632335
2651 2651 jonesdo01 1989 0 ALS198907110 AL   0.0 0.0 8.792402347 0 1.333 0.0 0.0 0.058601362 0.058601362
2686 2686 reuscri01 1987 0 ALS198707140 NL   0.0 0.0 4.159063694 0 1.333 0.0 0.0 0.01919088 0.01919088
2789 2789 dawlebi01 1983 0 ALS198307060 NL   0.0 0.0 1.384864116 0 1.333 0.0 0.0 0.010383884 0.010383884
2902 2902 lacosmi01 1979 0 ALS197907170 NL   0.0 0.0 -1.31767422 0 1.333 0.0 0.0 -0.008782299 -0.008782299
3072 3072 hunteca01 1973 0 ALS197307240 AL 1 0.0 0.0 -1.385163138 0 1.333 0.0 0.0 -0.009232112 -0.009232112
3420 3420 buhlbo01 1960 1 ALS196007110 NL   0.0 0.0 5.468108852 0 1.333 0.0 0.0 0.036444945 0.036444945
3539 3539 grissma01 1954 0 ALS195407130 NL   0.0 0.0 7.228763558 0 1.333 0.0 0.0 0.054202173 0.054202173
3650 3650 grayte01 1950 0 ALS195007110 AL   0.0 0.0 1.180722277 0 1.333 0.0 0.0 0.005058973 0.005058973
3706 3706 higbeki01 1946 0 ALS194607090 NL   0.0 0.0 1.022940511 0 1.333 0.0 0.0 0.007670136 0.007670136

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