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

169 rows where gameNum = 1

✎ 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
1396 1396 mayswi01 1961 1 NLS196107110 NL 8 36.85140976 7.03749284 0.0 5 0.0 0.269644462 0.05149385 0.0 0.321138312
1397 1397 boyerke01 1961 1 NLS196107110 NL   27.07916755 8.455183607 0.0 3 0.0 0.11888415 0.037120318 0.0 0.156004468
1398 1398 clemero01 1961 1 NLS196107110 NL 9 22.1982164 -2.351366132 0.0 5 0.0 0.162425974 -0.017205118 0.0 0.145220856
1399 1399 robinfr02 1961 1 NLS196107110 NL   38.81206392 -3.478673538 0.0 2 0.0 0.113596285 -0.010181484 0.0 0.103414801
1400 1400 matheed01 1961 1 NLS196107110 NL 5 36.21002075 -1.094356085 0.0 2 0.0 0.105980549 -0.003202993 0.0 0.102777555
1401 1401 burgesm01 1961 1 NLS196107110 NL 2 6.463747157 8.906224564 0.0 4 0.0 0.037836569 0.052133997 0.0 0.089970566
1402 1402 cepedor01 1961 1 NLS196107110 NL 7 28.48118799 -8.686857162 0.0 3 0.0 0.125039362 -0.038137422 0.0 0.08690194
1403 1403 aaronha01 1961 1 NLS196107110 NL   39.36823765 5.080221559 0.0 1 0.0 0.057612055 0.007434471 0.0 0.065046526
1404 1404 mccormi03 1961 1 NLS196107110 NL   0.0 0.0 4.635355454 0 3.0 0.0 0.0 0.062577299 0.062577299
1405 1405 spahnwa01 1961 1 NLS196107110 NL 1 0.0 0.0 2.840595605 0 3.0 0.0 0.0 0.038348041 0.038348041
1406 1406 millest01 1961 1 NLS196107110 NL   0.0 0.0 4.303264048 0 1.667 0.0 0.0 0.032280935 0.032280935
1407 1407 bollifr01 1961 1 NLS196107110 NL 4 -4.679768052 9.31083295 0.0 3 0.0 -0.020545323 0.040876828 0.0 0.020331504
1408 1408 altmage01 1961 1 NLS196107110 NL   11.67462833 -4.996226299 0.0 1 0.0 0.017084822 -0.007311551 0.0 0.009773271
1409 1409 facero01 1961 1 NLS196107110 NL   0.0 0.0 2.779811246 0 0.333 0.0 0.0 0.004165547 0.004165547
1410 1410 koufasa01 1961 1 NLS196107110 NL   0.0 0.0 6.582390933 0 0.0 0.0 0.0 0.0 0.0
1411 1411 stuardi01 1961 1 NLS196107110 NL   12.31318621 -13.64086258 0.0 1 0.0 0.018019297 -0.019962238 0.0 -0.001942941
1412 1412 musiast01 1961 1 NLS196107110 NL   3.72793803 -5.636083679 0.0 1 0.0 0.005455519 -0.008247927 0.0 -0.002792408
1413 1413 purkebo01 1961 1 NLS196107110 NL   0.0 0.0 -0.673256872 0 2.0 0.0 0.0 -0.006059312 -0.006059312
1414 1414 whitebi03 1961 1 NLS196107110 NL 3 5.580021656 -7.30747354 0.0 4 0.0 0.032663541 -0.042775455 0.0 -0.010111913
1415 1415 zimmedo01 1961 1 NLS196107110 NL   -16.31416323 2.182396685 0.0 1 0.0 -0.023874385 0.003193751 0.0 -0.020680634
1416 1416 willsma01 1961 1 NLS196107110 NL 6 -9.251649293 4.330939805 0.0 5 0.0 -0.067694995 0.031689803 0.0 -0.036005191
1417 1417 marisro01 1961 1 NLS196107110 AL 9 35.1166478 0.166446402 0.0 5 0.0 0.277236693 0.001314051 0.0 0.278550744
1418 1418 cashno01 1961 1 NLS196107110 AL 3 41.10516371 -3.474498978 0.0 4 0.0 0.25961156 -0.021944204 0.0 0.237667356
1419 1419 mantlmi01 1961 1 NLS196107110 AL 8 49.54352053 -0.924540858 0.0 3 0.0 0.234679834 -0.004379404 0.0 0.23030043
1420 1420 colavro01 1961 1 NLS196107110 AL 7 18.37548488 3.144902125 0.0 4 0.0 0.116055694 0.01986254 0.0 0.135918234
1421 1421 kalinal01 1961 1 NLS196107110 AL   23.76192699 7.414889957 0.0 2 0.0 0.075037664 0.023415442 0.0 0.098453106
1422 1422 gentiji01 1961 1 NLS196107110 AL   33.99886231 -2.931455139 0.0 2 0.0 0.107364828 -0.009257227 0.0 0.098107602
1423 1423 romanjo01 1961 1 NLS196107110 AL 2 16.84954434 3.517188626 0.0 3 0.0 0.079813631 0.016660367 0.0 0.096473998
1424 1424 bunniji01 1961 1 NLS196107110 AL   0.0 0.0 8.202748936 0 2.0 0.0 0.0 0.082027489 0.082027489
1425 1425 killeha01 1961 1 NLS196107110 AL   29.59438543 -7.029144709 0.0 2 0.0 0.093455954 -0.022197299 0.0 0.071258655
1426 1426 kubekto01 1961 1 NLS196107110 AL 6 -3.623744571 14.16071501 0.0 4 0.0 -0.022886808 0.089436095 0.0 0.066549287
1427 1427 wilheho01 1961 1 NLS196107110 AL   0.0 0.0 7.861729878 0 1.667 0.0 0.0 0.065527519 0.065527519
1428 1428 donovdi01 1961 1 NLS196107110 AL   0.0 0.0 5.911357482 0 2.0 0.0 0.0 0.059113575 0.059113575
1429 1429 fordwh01 1961 1 NLS196107110 AL 1 0.0 0.0 3.609324405 0 3.0 0.0 0.0 0.054139866 0.054139866
1430 1430 robinbr01 1961 1 NLS196107110 AL 5 -1.845967248 14.11488995 0.0 2 0.0 -0.00582937 0.044573337 0.0 0.038743966
1431 1431 berrayo01 1961 1 NLS196107110 AL   7.280707054 1.964416887 0.0 1 0.0 0.011495853 0.003101711 0.0 0.014597564
1432 1432 howsedi01 1961 1 NLS196107110 AL   9.136755317 -4.607673839 0.0 1 0.0 0.014426456 -0.007275274 0.0 0.007151181
1433 1433 brandja01 1961 1 NLS196107110 AL   7.878421481 -4.668882409 0.0 1 0.0 0.012439613 -0.00737192 0.0 0.005067693
1434 1434 fornimi01 1961 1 NLS196107110 AL   0.0 0.0 1.495720546 0 0.333 0.0 0.0 0.002490375 0.002490375
1435 1435 foxne01 1961 1 NLS196107110 AL   -8.963773889 10.22974326 0.0 1 0.0 -0.014153327 0.016152226 0.0 0.001998899
1436 1436 laryfr01 1961 1 NLS196107110 AL   0.0 0.0 5.926619463 0 0.0 0.0 0.0 0.0 0.0
1437 1437 howarel01 1961 1 NLS196107110 AL   8.711862656 5.916388861 0.0 0 0.0 0.0 0.0 0.0 0.0
1438 1438 templjo01 1961 1 NLS196107110 AL 4 -7.320928667 -4.456525137 0.0 3 0.0 -0.034678083 -0.021109856 0.0 -0.055787939
1479 1479 bankser01 1959 1 NLS195907070 NL 6 31.6955257 14.11564696 0.0 4 0.0 0.245384715 0.109282428 0.0 0.354667143
1480 1480 mayswi01 1959 1 NLS195907070 NL 8 40.41850515 4.18835672 0.0 4 0.0 0.312917459 0.032425988 0.0 0.345343447
1481 1481 aaronha01 1959 1 NLS195907070 NL 9 44.47477691 -3.638336272 0.0 4 0.0 0.344320853 -0.028167765 0.0 0.316153089
1482 1482 matheed01 1959 1 NLS195907070 NL 5 31.36353411 4.366456823 0.0 3 0.0 0.182110843 0.02535362 0.0 0.207464463
1483 1483 drysddo01 1959 1 NLS195907070 NL 1 0.0 0.0 8.500973511 0 3.0 0.0 0.0 0.127514603 0.127514603
1484 1484 crandde01 1959 1 NLS195907070 NL 2 -0.930817431 14.63117955 0.0 3 0.0 -0.005404746 0.084955236 0.0 0.07955049
1485 1485 facero01 1959 1 NLS195907070 NL   0.0 0.0 8.326020669 0 1.667 0.0 0.0 0.069397382 0.069397382
1486 1486 cepedor01 1959 1 NLS195907070 NL 3 17.17392001 -9.651371854 0.0 4 0.0 0.132959381 -0.074720298 0.0 0.058239083
1487 1487 boyerke01 1959 1 NLS195907070 NL   17.15068181 9.038132379 0.0 1 0.0 0.033194868 0.017493159 0.0 0.050688027
1488 1488 moonwa01 1959 1 NLS195907070 NL 7 12.79810209 -5.819516225 0.0 3 0.0 0.074311561 -0.033790739 0.0 0.040520821
1489 1489 elstodo01 1959 1 NLS195907070 NL   0.0 0.0 4.781117879 0 1.0 0.0 0.0 0.023905589 0.023905589
1490 1490 musiast01 1959 1 NLS195907070 NL   14.55832902 -9.749271329 0.0 1 0.0 0.028177411 -0.018869557 0.0 0.009307854
1491 1491 antonjo02 1959 1 NLS195907070 NL   0.0 0.0 5.278918346 0 0.333 0.0 0.0 0.008789399 0.008789399
1492 1492 mazerbi01 1959 1 NLS195907070 NL   -7.469482804 10.77332249 0.0 1 0.0 -0.014457063 0.020851592 0.0 0.006394528
1493 1493 groatdi01 1959 1 NLS195907070 NL   -5.748478908 8.425699982 0.0 1 0.0 -0.011126088 0.016307806 0.0 0.005181718
1494 1494 templjo01 1959 1 NLS195907070 NL 4 3.579665383 -4.161261149 0.0 2 0.0 0.013856769 -0.016108108 0.0 -0.002251338
1495 1495 burdele01 1959 1 NLS195907070 NL   0.0 0.0 -6.48329598 0 3.0 0.0 0.0 -0.09724944 -0.09724944
1496 1496 foxne01 1959 1 NLS195907070 AL 4 9.230516601 13.24997552 0.0 5 0.0 0.074842026 0.107432234 0.0 0.18227426
1497 1497 minosmi01 1959 1 NLS195907070 AL 7 20.66943881 0.629403297 0.0 5 0.0 0.167590044 0.00510327 0.0 0.172693314
1498 1498 durenry01 1959 1 NLS195907070 AL   0.0 0.0 10.23327345 0 3.0 0.0 0.0 0.17268649 0.17268649
1499 1499 kalinal01 1959 1 NLS195907070 AL 8 24.04244692 8.920836608 0.0 3 0.0 0.116963255 0.043398665 0.0 0.16036192
1500 1500 colavro01 1959 1 NLS195907070 AL 9 23.27185324 1.887539497 0.0 3 0.0 0.113214421 0.009182625 0.0 0.122397046
1501 1501 killeha01 1959 1 NLS195907070 AL 5 15.83810022 -4.167650636 0.0 3 0.0 0.077050217 -0.020275057 0.0 0.05677516
1502 1502 aparilu01 1959 1 NLS195907070 AL 6 -4.046646536 15.01451761 0.0 3 0.0 -0.019686389 0.073043599 0.0 0.053357211
1503 1503 bunniji01 1959 1 NLS195907070 AL   0.0 0.0 5.940212666 0 1.0 0.0 0.0 0.033413696 0.033413696
1504 1504 skowrbi01 1959 1 NLS195907070 AL 3 8.16535438 -1.3875927 0.0 3 0.0 0.039723346 -0.006750451 0.0 0.032972895
1505 1505 triangu01 1959 1 NLS195907070 AL 2 1.843316906 3.001590356 0.0 4 0.0 0.01195665 0.019469775 0.0 0.031426425
1506 1506 willite01 1959 1 NLS195907070 AL   33.21218521 -15.88501935 0.0 1 0.0 0.053857598 -0.025759491 0.0 0.028098107
1507 1507 kuennha01 1959 1 NLS195907070 AL   13.65398585 -6.810328695 0.0 2 0.0 0.044283197 -0.022087553 0.0 0.022195645
1508 1508 daleybu01 1959 1 NLS195907070 AL   0.0 0.0 5.858738225 0 0.667 0.0 0.0 0.021981253 0.021981253
1509 1509 lollash01 1959 1 NLS195907070 AL   3.816879879 7.087298553 0.0 1 0.0 0.006189535 0.011492917 0.0 0.017682452
1510 1510 malzofr01 1959 1 NLS195907070 AL   -0.588813379 5.192447307 0.0 2 0.0 -0.001909665 0.01684037 0.0 0.014930705
1511 1511 powervi01 1959 1 NLS195907070 AL   5.140890962 1.084303542 0.0 1 0.0 0.00833658 0.00175833 0.0 0.01009491
1512 1512 sievero01 1959 1 NLS195907070 AL   17.85822135 -12.02621638 0.0 1 0.0 0.028959278 -0.019501973 0.0 0.009457305
1513 1513 fordwh01 1959 1 NLS195907070 AL   0.0 0.0 4.545703635 0 0.333 0.0 0.0 0.008514671 0.008514671
1514 1514 runnepe01 1959 1 NLS195907070 AL   11.62439454 0.912887299 0.0 0 0.0 0.0 0.0 0.0 0.0
1515 1515 mcdougi01 1959 1 NLS195907070 AL   -1.23334908 12.71716347 0.0 0 0.0 0.0 0.0 0.0 0.0
1516 1516 mantlmi01 1959 1 NLS195907070 AL   50.0682545 -0.912741916 0.0 0 0.0 0.0 0.0 0.0 0.0
1517 1517 wynnea01 1959 1 NLS195907070 AL 1 0.0 0.0 -2.267733694 0 3.0 0.0 0.0 -0.038268006 -0.038268006
3292 3292 mayswi01 1962 1 ALS196207100 NL 8 38.62314201 10.56087198 0.0 4 0.0 0.272633944 0.074547332 0.0 0.347181275
3293 3293 drysddo01 1962 1 ALS196207100 NL 1 0.0 0.0 8.054103845 0 3.0 0.0 0.0 0.120811558 0.120811558
3294 3294 crandde01 1962 1 ALS196207100 NL 2 3.483120433 11.2755998 0.0 4 0.0 0.024586732 0.079592469 0.0 0.104179202
3295 3295 boyerke01 1962 1 ALS196207100 NL 5 18.97668886 8.688952792 0.0 2 0.0 0.066976549 0.030666892 0.0 0.097643441
3296 3296 clemero01 1962 1 ALS196207100 NL 9 17.870831 0.322088779 0.0 3 0.0 0.094610282 0.001705176 0.0 0.096315458
3297 3297 purkebo01 1962 1 ALS196207100 NL   0.0 0.0 9.520259259 0 2.0 0.0 0.0 0.095202593 0.095202593
3298 3298 davisto02 1962 1 ALS196207100 NL 7 15.54697116 -4.461792868 0.0 4 0.0 0.109743326 -0.031495008 0.0 0.078248317
3299 3299 cepedor01 1962 1 ALS196207100 NL 3 24.0938504 -9.551254381 0.0 3 0.0 0.127555679 -0.050565464 0.0 0.076990214
3300 3300 shawbo01 1962 1 ALS196207100 NL   0.0 0.0 4.896048418 0 2.0 0.0 0.0 0.048960484 0.048960484
3301 3301 bankser01 1962 1 ALS196207100 NL   10.03896799 2.954316919 0.0 2 0.0 0.035431652 0.010427001 0.0 0.045858653
3302 3302 aloufe01 1962 1 ALS196207100 NL   16.179243 -1.151902661 0.0 1 0.0 0.028551605 -0.002032769 0.0 0.026518836
3303 3303 callijo01 1962 1 ALS196207100 NL   14.78099479 -1.939554686 0.0 1 0.0 0.026084108 -0.003422744 0.0 0.022661365
3304 3304 davenji01 1962 1 ALS196207100 NL   5.129964105 6.012439863 0.0 1 0.0 0.009052878 0.010610188 0.0 0.019663066
3305 3305 groatdi01 1962 1 ALS196207100 NL 6 -7.651611633 10.38125042 0.0 3 0.0 -0.040508532 0.054959561 0.0 0.014451029
3306 3306 willsma01 1962 1 ALS196207100 NL   4.079649669 4.028647562 0.0 1 0.0 0.007199382 0.007109378 0.0 0.01430876
3307 3307 musiast01 1962 1 ALS196207100 NL   11.49730562 -4.301931972 0.0 1 0.0 0.020289363 -0.007591645 0.0 0.012697718
3308 3308 maricju01 1962 1 ALS196207100 NL   0.0 0.0 1.249642354 0 2.0 0.0 0.0 0.012496424 0.012496424
3309 3309 bollifr01 1962 1 ALS196207100 NL   -5.474993649 4.791072263 0.0 2 0.0 -0.019323507 0.016909667 0.0 -0.00241384

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