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

165 rows where gameNum = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: yearID, gameID, 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
1351 1351 robinfr02 1962 2 NLS196207300 NL   43.5478701 -3.072930969 0.0 3 0.0 0.211854503 -0.014949394 0.0 0.196905109
1352 1352 mayswi01 1962 2 NLS196207300 NL 8 38.62314201 10.56087198 0.0 2 0.0 0.125264244 0.034251477 0.0 0.159515721
1353 1353 aaronha01 1962 2 NLS196207300 NL   38.10673774 5.603011936 0.0 2 0.0 0.12358942 0.018171931 0.0 0.14176135
1354 1354 boyerke01 1962 2 NLS196207300 NL 5 18.97668886 8.688952792 0.0 3 0.0 0.092319027 0.042270581 0.0 0.134589608
1355 1355 gibsobo01 1962 2 NLS196207300 NL   0.0 0.0 9.758449118 0 2.0 0.0 0.0 0.097584491 0.097584491
1356 1356 clemero01 1962 2 NLS196207300 NL 9 17.870831 0.322088779 0.0 2 0.0 0.057959452 0.001044612 0.0 0.059004064
1357 1357 farretu01 1962 2 NLS196207300 NL   0.0 0.0 10.25146687 0 1.0 0.0 0.0 0.051257334 0.051257334
1358 1358 cepedor01 1962 2 NLS196207300 NL 3 24.0938504 -9.551254381 0.0 2 0.0 0.078142218 -0.030977041 0.0 0.047165176
1359 1359 matheed01 1962 2 NLS196207300 NL   28.00922512 0.23783607 0.0 1 0.0 0.045420365 0.00038568 0.0 0.045806045
1360 1360 bankser01 1962 2 NLS196207300 NL   10.03896799 2.954316919 0.0 2 0.0 0.032558815 0.009581568 0.0 0.042140383
1361 1361 crandde01 1962 2 NLS196207300 NL 2 3.483120433 11.2755998 0.0 1 0.0 0.005648303 0.018284756 0.0 0.02393306
1362 1362 musiast01 1962 2 NLS196207300 NL   11.49730562 -4.301931972 0.0 2 0.0 0.037288559 -0.013952212 0.0 0.023336347
1363 1363 podrejo01 1962 2 NLS196207300 NL 1 0.0 0.0 2.149883205 0 2.0 0.0 0.0 0.021498832 0.021498832
1364 1364 callijo01 1962 2 NLS196207300 NL   14.78099479 -1.939554686 0.0 1 0.0 0.023969181 -0.003145224 0.0 0.020823957
1365 1365 rosebjo01 1962 2 NLS196207300 NL   -2.557514775 6.830980135 0.0 3 0.0 -0.012441964 0.033231795 0.0 0.020789831
1366 1366 davisto02 1962 2 NLS196207300 NL 7 15.54697116 -4.461792868 0.0 1 0.0 0.025211305 -0.00723534 0.0 0.017975965
1367 1367 groatdi01 1962 2 NLS196207300 NL 6 -7.651611633 10.38125042 0.0 4 0.0 -0.049632075 0.067337841 0.0 0.017705765
1368 1368 altmage01 1962 2 NLS196207300 NL   17.05812201 -8.040664474 0.0 1 0.0 0.027661819 -0.013038915 0.0 0.014622904
1369 1369 mahafar01 1962 2 NLS196207300 NL   0.0 0.0 1.386098252 0 2.0 0.0 0.0 0.013860983 0.013860983
1370 1370 willsma01 1962 2 NLS196207300 NL   4.079649669 4.028647562 0.0 1 0.0 0.006615648 0.006532942 0.0 0.01314859
1371 1371 maricju01 1962 2 NLS196207300 NL   0.0 0.0 1.249642354 0 2.0 0.0 0.0 0.012496424 0.012496424
1372 1372 willibi01 1962 2 NLS196207300 NL   10.08592317 -9.754994466 0.0 1 0.0 0.016355551 -0.01581891 0.0 0.000536641
1373 1373 bollifr01 1962 2 NLS196207300 NL   -5.474993649 4.791072263 0.0 3 0.0 -0.026635104 0.023307919 0.0 -0.003327185
1374 1374 mazerbi01 1962 2 NLS196207300 NL 4 -10.78310521 8.435903736 0.0 1 0.0 -0.017486117 0.013679844 0.0 -0.003806273
1375 1375 ashburi01 1962 2 NLS196207300 NL   6.159869826 -10.18426873 0.0 1 0.0 0.009988978 -0.01651503 0.0 -0.006526052
1376 1376 aguirha01 1962 2 NLS196207300 AL   0.0 0.0 17.07939091 0 3.0 0.0 0.0 0.256190864 0.256190864
1377 1377 marisro01 1962 2 NLS196207300 AL 8 29.32593015 -1.791984586 0.0 5 0.0 0.225584078 -0.013784497 0.0 0.211799581
1378 1378 colavro01 1962 2 NLS196207300 AL 9 18.88035452 3.691038509 0.0 5 0.0 0.145233496 0.028392604 0.0 0.1736261
1379 1379 gentiji01 1962 2 NLS196207300 AL 3 23.07629684 -4.504009438 0.0 5 0.0 0.177509976 -0.034646226 0.0 0.142863749
1380 1380 herbera01 1962 2 NLS196207300 AL   0.0 0.0 6.615470117 0 3.0 0.0 0.0 0.099232052 0.099232052
1381 1381 stenhda01 1962 2 NLS196207300 AL 1 0.0 0.0 6.469065038 0 2.0 0.0 0.0 0.06469065 0.06469065
1382 1382 robinbr01 1962 2 NLS196207300 AL   5.344380434 14.14081411 0.0 2 0.0 0.016444247 0.043510197 0.0 0.059954445
1383 1383 howarel01 1962 2 NLS196207300 AL   7.467329671 10.65136914 0.0 2 0.0 0.022976399 0.032773444 0.0 0.055749842
1384 1384 rolliri01 1962 2 NLS196207300 AL 5 9.192237331 1.573559588 0.0 3 0.0 0.042425711 0.007262583 0.0 0.049688293
1385 1385 batteea01 1962 2 NLS196207300 AL 2 1.593513114 8.020970424 0.0 3 0.0 0.007354676 0.037019863 0.0 0.044374539
1386 1386 treshto01 1962 2 NLS196207300 AL   9.786193255 2.617009592 0.0 2 0.0 0.030111364 0.008052337 0.0 0.038163701
1387 1387 aparilu01 1962 2 NLS196207300 AL 6 -10.713655 17.04894627 0.0 2 0.0 -0.032965092 0.052458296 0.0 0.019493204
1388 1388 moranbi02 1962 2 NLS196207300 AL 4 -2.049983167 4.761554663 0.0 4 0.0 -0.012615281 0.029301875 0.0 0.016686594
1389 1389 runnepe01 1962 2 NLS196207300 AL   12.7484067 -3.401081268 0.0 1 0.0 0.019612933 -0.005232433 0.0 0.014380501
1390 1390 thomale03 1962 2 NLS196207300 AL   8.621514387 -5.829273568 0.0 0 0.0 0.0 0.0 0.0 0.0
1391 1391 richabo01 1962 2 NLS196207300 AL   -6.694357716 2.38464012 0.0 0 0.0 0.0 0.0 0.0 0.0
1392 1392 kalinal01 1962 2 NLS196207300 AL   23.90618783 6.252574412 0.0 0 0.0 0.0 0.0 0.0 0.0
1393 1393 berrayo01 1962 2 NLS196207300 AL   -2.726897436 1.326998902 0.0 1 0.0 -0.004195227 0.002041537 0.0 -0.00215369
1394 1394 wagnele01 1962 2 NLS196207300 AL 7 11.6427609 -12.05186788 0.0 4 0.0 0.071647759 -0.074165341 0.0 -0.002517581
1395 1395 pappami01 1962 2 NLS196207300 AL   0.0 0.0 -1.937464046 0 1.0 0.0 0.0 -0.00968732 -0.00968732
1439 1439 bankser01 1959 2 NLS195908030 NL 6 31.6955257 14.11564696 0.0 4 0.0 0.205592599 0.091560953 0.0 0.297153552
1440 1440 mayswi01 1959 2 NLS195908030 NL 8 40.41850515 4.18835672 0.0 4 0.0 0.262174087 0.027167719 0.0 0.289341807
1441 1441 aaronha01 1959 2 NLS195908030 NL 9 44.47477691 -3.638336272 0.0 4 0.0 0.288485039 -0.023600019 0.0 0.26488502
1442 1442 drysddo01 1959 2 NLS195908030 NL 1 0.0 0.0 8.500973511 0 3.0 0.0 0.0 0.127514603 0.127514603
1443 1443 boyerke01 1959 2 NLS195908030 NL 5 17.15068181 9.038132379 0.0 3 0.0 0.083435749 0.043969293 0.0 0.127405042
1444 1444 robinfr02 1959 2 NLS195908030 NL   26.95372499 -1.408729971 0.0 3 0.0 0.13112623 -0.006853281 0.0 0.124272949
1445 1445 jonessa02 1959 2 NLS195908030 NL   0.0 0.0 10.25649027 0 2.0 0.0 0.0 0.102564903 0.102564903
1446 1446 facero01 1959 2 NLS195908030 NL   0.0 0.0 8.326020669 0 2.0 0.0 0.0 0.083260207 0.083260207
1447 1447 matheed01 1959 2 NLS195908030 NL   31.36353411 4.366456823 0.0 1 0.0 0.050859785 0.007080741 0.0 0.057940526
1448 1448 conlege01 1959 2 NLS195908030 NL   0.0 0.0 5.547256806 0 2.0 0.0 0.0 0.055472568 0.055472568
1449 1449 moonwa01 1959 2 NLS195908030 NL 7 12.79810209 -5.819516225 0.0 4 0.0 0.083014716 -0.037748213 0.0 0.045266503
1450 1450 crandde01 1959 2 NLS195908030 NL 2 -0.930817431 14.63117955 0.0 2 0.0 -0.003018867 0.047452474 0.0 0.044433607
1451 1451 cunnijo01 1959 2 NLS195908030 NL   28.98675526 -10.65900039 0.0 1 0.0 0.047005549 -0.017284865 0.0 0.029720684
1452 1452 burgesm01 1959 2 NLS195908030 NL   2.645296061 4.68557277 0.0 1 0.0 0.004289669 0.007598226 0.0 0.011887895
1453 1453 nealch01 1959 2 NLS195908030 NL   3.546952698 3.53406 0.0 1 0.0 0.005751815 0.005730908 0.0 0.011482723
1454 1454 musiast01 1959 2 NLS195908030 NL 3 14.55832902 -9.749271329 0.0 1 0.0 0.023608101 -0.015809629 0.0 0.007798472
1455 1455 groatdi01 1959 2 NLS195908030 NL   -5.748478908 8.425699982 0.0 1 0.0 -0.009321858 0.013663297 0.0 0.00434144
1456 1456 pinsova01 1959 2 NLS195908030 NL   21.37263145 -2.594765333 0.0 0 0.0 0.0 0.0 0.0 0.0
1457 1457 templjo01 1959 2 NLS195908030 NL 4 3.579665383 -4.161261149 0.0 2 0.0 0.011609726 -0.013495982 0.0 -0.001886257
1458 1458 gilliji01 1959 2 NLS195908030 NL   -6.092945194 -0.718028393 0.0 3 0.0 -0.029641355 -0.003493111 0.0 -0.033134466
1459 1459 smithha09 1959 2 NLS195908030 NL   -20.91067005 6.307077811 0.0 2 0.0 -0.067818389 0.020455387 0.0 -0.047363002
1460 1460 mantlmi01 1959 2 NLS195908030 AL 8 50.0682545 -0.912741916 0.0 4 0.0 0.316220555 -0.005764686 0.0 0.310455869
1461 1461 foxne01 1959 2 NLS195908030 AL 4 9.230516601 13.24997552 0.0 5 0.0 0.072872499 0.10460507 0.0 0.177477569
1462 1462 kalinal01 1959 2 NLS195908030 AL   24.04244692 8.920836608 0.0 2 0.0 0.075923517 0.028171063 0.0 0.10409458
1463 1463 wilheho01 1959 2 NLS195908030 AL   0.0 0.0 18.01384682 0 1.0 0.0 0.0 0.090069234 0.090069234
1464 1464 willite01 1959 2 NLS195908030 AL 7 33.21218521 -15.88501935 0.0 3 0.0 0.157320877 -0.075244829 0.0 0.082076049
1465 1465 colavro01 1959 2 NLS195908030 AL   23.27185324 1.887539497 0.0 2 0.0 0.073490063 0.005960651 0.0 0.079450714
1466 1466 runnepe01 1959 2 NLS195908030 AL 3 11.62439454 0.912887299 0.0 4 0.0 0.073417229 0.005765604 0.0 0.079182833
1467 1467 aparilu01 1959 2 NLS195908030 AL 6 -4.046646536 15.01451761 0.0 4 0.0 -0.025557768 0.094828532 0.0 0.069270765
1468 1468 berrayo01 1959 2 NLS195908030 AL 2 7.076828645 6.285647183 0.0 3 0.0 0.03352182 0.029774118 0.0 0.063295938
1469 1469 walkeje01 1959 2 NLS195908030 AL 1 0.0 0.0 4.131624091 0 3.0 0.0 0.0 0.061974361 0.061974361
1470 1470 o'delbi01 1959 2 NLS195908030 AL   0.0 0.0 8.418831057 0 1.0 0.0 0.0 0.042094155 0.042094155
1471 1471 malzofr01 1959 2 NLS195908030 AL 5 -0.588813379 5.192447307 0.0 4 0.0 -0.003718821 0.032794404 0.0 0.029075583
1472 1472 kubekto01 1959 2 NLS195908030 AL   -3.245571527 10.43721726 0.0 2 0.0 -0.010249173 0.032959633 0.0 0.02271046
1473 1473 woodlge01 1959 2 NLS195908030 AL   21.81022481 -9.622947104 0.0 1 0.0 0.034437197 -0.015194127 0.0 0.01924307
1474 1474 marisro01 1959 2 NLS195908030 AL 9 7.598021669 -1.941326772 0.0 2 0.0 0.023993753 -0.006130506 0.0 0.017863247
1475 1475 lollash01 1959 2 NLS195908030 AL   3.816879879 7.087298553 0.0 1 0.0 0.006026652 0.011190471 0.0 0.017217124
1476 1476 powervi01 1959 2 NLS195908030 AL   5.140890962 1.084303542 0.0 1 0.0 0.008117196 0.001712058 0.0 0.009829254
1477 1477 wynnea01 1959 2 NLS195908030 AL   0.0 0.0 -2.267733694 0 2.0 0.0 0.0 -0.022677337 -0.022677337
1478 1478 mclisca01 1959 2 NLS195908030 AL   0.0 0.0 -2.510442551 0 2.0 0.0 0.0 -0.025104426 -0.025104426
3330 3330 mayswi01 1961 2 ALS196107310 NL 8 36.85140976 7.03749284 0.0 4 0.0 0.252695381 0.048257094 0.0 0.300952475
3331 3331 matheed01 1961 2 ALS196107310 NL 5 36.21002075 -1.094356085 0.0 4 0.0 0.248297285 -0.007504156 0.0 0.240793129
3332 3332 aaronha01 1961 2 ALS196107310 NL   39.36823765 5.080221559 0.0 2 0.0 0.134976815 0.017417902 0.0 0.152394717
3333 3333 cepedor01 1961 2 ALS196107310 NL 7 28.48118799 -8.686857162 0.0 4 0.0 0.195299575 -0.059567021 0.0 0.135732554
3334 3334 clemero01 1961 2 ALS196107310 NL 9 22.1982164 -2.351366132 0.0 2 0.0 0.076108171 -0.008061827 0.0 0.068046344
3335 3335 koufasa01 1961 2 ALS196107310 NL   0.0 0.0 6.582390933 0 2.0 0.0 0.0 0.065823909 0.065823909
3336 3336 millest01 1961 2 ALS196107310 NL   0.0 0.0 4.303264048 0 3.0 0.0 0.0 0.064548961 0.064548961
3337 3337 bankser01 1961 2 ALS196107310 NL   18.15468578 13.67377481 0.0 1 0.0 0.031122318 0.023440757 0.0 0.054563075
3338 3338 mahafar01 1961 2 ALS196107310 NL   0.0 0.0 3.352807286 0 2.0 0.0 0.0 0.033528073 0.033528073
3339 3339 bollifr01 1961 2 ALS196107310 NL 4 -4.679768052 9.31083295 0.0 4 0.0 -0.032089838 0.063845712 0.0 0.031755874
3340 3340 burgesm01 1961 2 ALS196107310 NL 2 6.463747157 8.906224564 0.0 1 0.0 0.011080709 0.015267814 0.0 0.026348523
3341 3341 altmage01 1961 2 ALS196107310 NL   11.67462833 -4.996226299 0.0 1 0.0 0.020013649 -0.008564959 0.0 0.011448689
3342 3342 kaskoed01 1961 2 ALS196107310 NL   -9.244650504 8.912138532 0.0 1 0.0 -0.015847972 0.015277952 0.0 -0.000570021
3343 3343 stuardi01 1961 2 ALS196107310 NL   12.31318621 -13.64086258 0.0 1 0.0 0.021108319 -0.023384336 0.0 -0.002276017
3344 3344 musiast01 1961 2 ALS196107310 NL   3.72793803 -5.636083679 0.0 1 0.0 0.006390751 -0.009661858 0.0 -0.003271107

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