mlb-quasi-win-shares: quasi_winshares.csv

Table actions

This table contains data behind the story The Twins’ Magical Run Will Likely Go Through The Yankees. (Because Of Course.)

quasi_winshares.csv contains Quasi-Win Shares (QWS), prorated to 162 team games, for every player from 1901 as of Sept. 27, 2019.

Column Description
name_common Player name
age Player's age on June 30 of season
player_ID Player's Baseball-Reference.com ID
year_ID Season
team_ID Baseball-Reference ID of team
lg_ID League of team
pct_PT Share of total team playing time (measured by plate appearances and leverage-weighted innings) for player
WAR162 Wins Above Replacement per 162 team games, averaging B-R and FG WAR
def_pos Defensive positions played, in order of innings/games. (Will not include DH or any position for players with 0 PA.)
quasi_ws Quasi Win Shares. Three times total wins created per 162 games; generated by adding WAR162 to wins BELOW replacement (determined by playing time) and rounding to nearest whole number
stint_ID Order of team stints for player within season
franch_id Lahman DB franchise ID for team
prev_franch Previous franchise played for (NULL if player debuted for team)
year_acq First season for player with that franchise
year_left Last season for player with that franchise
next_franch Next franchise played for (NULL if player retired with or is currently on team)

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

965 rows where prev_franch = "MIL"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, lg_ID, stint_ID, franch_id, next_franch

Link rowid ▼ name_common age player_ID year_ID team_ID lg_ID pct_PT WAR162 def_pos quasi_ws stint_ID franch_id prev_franch year_acq year_left next_franch
95 95 Jonathan Villar 28 villajo01 2019 BAL AL 6.710743802 3.999056604 2B, SS 20 1 BAL MIL 2018 2019  
180 180 Jhoulys Chacin 31 chacijh01 2019 BOS AL 0.315057805 0.081509434 P 1 2 BOS MIL 2019 2019  
189 189 Tyler Thornburg 30 thornty01 2019 BOS AL 0.328583014 -0.147735849 P 0 1 BOS MIL 2018 2019  
235 235 Xavier Cedeno 32 cedenxa01 2019 CHC NL 0.055455359 0.071320755 P 0 1 CHC MIL 2019 2019  
325 325 Jared Hughes 33 hugheja02 2019 CIN NL 1.449513691 0.020377358 P 2 1 CIN MIL 2018 2019 PHI
343 343 Scooter Gennett 29 gennesc01 2019 CIN NL 0.743060498 -0.641886792 2B 0 1 CIN MIL 2017 2019 SFG
377 377 Brad Miller 29 millebr02 2019 CLE AL 0.386537821 0.147735849 3B, LF, 2B, RF, SS 1 1 CLE MIL 2019 2019 PHI
513 513 Wade Miley 32 mileywa01 2019 HOU AL 4.851244757 2.047924528 P 12 1 HOU MIL 2019 2019  
569 569 Brett Phillips 25 phillbr02 2019 KCR AL 0.720255076 0.315849057 CF, LF, RF 2 1 KCR MIL 2018 2019  
571 571 Jorge Lopez 26 lopezjo02 2019 KCR AL 3.353515188 -0.713207547 P 2 1 KCR MIL 2018 2019  
591 591 Jacob Barnes 29 barneja01 2019 KCR AL 0.323414508 -0.336226415 P 0 2 KCR MIL 2019 2019  
592 592 Wily Peralta 30 peralwi01 2019 KCR AL 1.255709491 -0.371886792 P 0 1 KCR MIL 2018 2019  
722 722 Curtis Granderson 38 grandcu01 2019 MIA NL 3.66749556 -0.850754717 LF, RF 3 1 FLA MIL 2019 2019  
738 738 Yadiel Rivera 27 riverya01 2019 MIA NL 0.679928952 -0.433018868 3B, SS, 1B, RF, 2B, CF 0 1 FLA MIL 2018 2019  
751 751 Lewis Brinson 25 brinsle01 2019 MIA NL 2.513676732 -1.808490566 CF, RF 0 1 FLA MIL 2018 2019  
814 814 Jonathan Schoop 27 schoojo01 2019 MIN AL 4.190430622 1.563962264 2B 11 1 MIN MIL 2019 2019  
882 882 Donnie Hart 28 hartdo01 2019 NYM NL 0.015173085 0.010188679 P 0 2 NYM MIL 2019 2019  
903 903 Keon Broxton 29 broxtke01 2019 NYM NL 0.526369863 -0.550188679 CF, LF, RF 0 1 NYM MIL 2019 2019 BAL
926 926 CC Sabathia 38 sabatc.01 2019 NYY AL 3.085304573 0.366792453 P 6 1 NYY MIL 2009 2019  
975 975 Joakim Soria 35 soriajo01 2019 OAK AL 2.115213121 0.621509434 P 5 1 OAK MIL 2019 2019  
976 976 Khris Davis 31 daviskh01 2019 OAK AL 4.942000652 -0.636792453 LF 5 1 OAK MIL 2016 2019  
990 990 Wei-Chung Wang 27 wangwe01 2019 OAK AL 0.641782893 0.168113208 P 1 1 OAK MIL 2019 2019 PIT
1076 1076 Jordan Lyles 28 lylesjo01 2019 PIT NL 2.460064406 0.356603774 P 5 1 PIT MIL 2019 2019 MIL
1110 1110 Jake Elmore 32 elmorja01 2019 PIT NL 0.359504132 -0.427924528 3B, RF, LF, 2B 0 1 PIT MIL 2019 2019  
1183 1183 Domingo Santana 26 santado01 2019 SEA AL 4.818991098 0.203773585 LF, RF 7 1 SEA MIL 2019 2019  
1246 1246 Will Smith 29 smithwi04 2019 SFG NL 2.798371534 1.762641509 P 10 1 SFG MIL 2016 2019  
1249 1249 Stephen Vogt 34 vogtst01 2019 SFG NL 2.754723522 1.156415094 C, LF, 1B 8 1 SFG MIL 2019 2019  
1261 1261 Mauricio Dubon 24 dubonma01 2019 SFG NL 0.965158606 0.524716981 2B, SS 3 2 SFG MIL 2019 2019  
1271 1271 Burch Smith 29 smithbu03 2019 SFG NL 0.262480878 0.152830189 P 1 2 SFG MIL 2019 2019  
1290 1290 Erik Kratz 39 kratzer01 2019 SFG NL 0.361934477 -0.208867925 C 0 1 SFG MIL 2019 2019 TBD
1353 1353 Ji-Man Choi 28 choiji01 2019 TBR AL 4.574727598 1.732075472 1B 12 1 TBD MIL 2018 2019  
1379 1379 Jesus Aguilar 29 aguilje01 2019 TBR AL 0.943242804 0.346415094 1B, 3B 2 2 TBD MIL 2019 2019  
1459 1459 Eric Sogard 33 sogarer01 2019 TOR AL 3.140127389 2.083584906 2B, 3B, RF, SS, LF 10 1 TOR MIL 2019 2019 TBD
1548 1548 Michael Blazek 30 blazemi01 2019 WSN NL 0.080117192 -0.061132075 P 0 1 WSN MIL 2019 2019  
1558 1558 Dan Jennings 32 jennida01 2019 WSN NL 0.136610084 -0.27509434 P 0 1 WSN MIL 2019 2019  
1640 1640 Sam Freeman 31 freemsa01 2018 ATL NL 1.458445921 0.095 P 2 1 ATL MIL 2017 2018 ANA
1651 1651 Michael Reed 25 reedmi02 2018 ATL NL 0.068546345 -0.005 LF 0 1 ATL MIL 2018 2018 SFG
1680 1680 Jonathan Villar 27 villajo01 2018 BAL AL 2.277158543 1.26 2B, SS 6 2 BAL MIL 2018 2019  
1720 1720 Andrew Susac 28 susacan01 2018 BAL AL 0.250873399 -0.365 C 0 1 BAL MIL 2018 2018  
1767 1767 Tyler Thornburg 29 thornty01 2018 BOS AL 0.598094966 -0.175 P 0 1 BOS MIL 2018 2019  
1858 1858 Rob Scahill 31 scahiro01 2018 CHW AL 0.122531823 -0.04 P 0 1 CHW MIL 2018 2018  
1873 1873 Scooter Gennett 28 gennesc01 2018 CIN NL 6.279314441 4.325 2B 21 1 CIN MIL 2017 2019 SFG
1877 1877 Jared Hughes 32 hugheja02 2018 CIN NL 2.881136849 2.315 P 11 1 CIN MIL 2018 2019 PHI
1968 1968 Oliver Drake 31 drakeol01 2018 CLE AL 0.073164484 -0.085 P 0 2 CLE MIL 2018 2018 ANA
2121 2121 Alcides Escobar 31 escobal02 2018 KCR AL 5.098162556 -0.475 SS, 3B, CF, 2B 5 1 KCR MIL 2011 2018  
2123 2123 Brett Phillips 24 phillbr02 2018 KCR AL 1.18093031 0.735 CF, RF, LF 4 2 KCR MIL 2018 2019  
2131 2131 Wily Peralta 29 peralwi01 2018 KCR AL 1.093737796 0.16 P 2 1 KCR MIL 2018 2019  
2136 2136 Jorge Lopez 25 lopezjo02 2018 KCR AL 0.950907276 -0.08 P 1 2 KCR MIL 2018 2019  
2168 2168 Martin Maldonado 31 maldoma01 2018 LAA AL 2.763720013 0.835 C 6 1 ANA MIL 2017 2018 HOU
2280 2280 Lewis Brinson 24 brinsle01 2018 MIA NL 4.06 -0.578571429 CF 5 1 FLA MIL 2018 2019  
2297 2297 Yadiel Rivera 26 riverya01 2018 MIA NL 1.6 -0.543354037 3B, SS, 2B, LF, 1B, CF, RF 1 1 FLA MIL 2018 2019  
2476 2476 Anthony Swarzak 32 swarzan01 2018 NYM NL 0.85121071 -0.41 P 0 1 NYM MIL 2018 2018 SEA
2490 2490 CC Sabathia 37 sabatc.01 2018 NYY AL 4.301584612 2.275 P 13 1 NYY MIL 2009 2019  
2502 2502 Neil Walker 32 walkene01 2018 NYY AL 3.694031045 -0.02 1B, 2B, 3B, RF, LF 5 1 NYY MIL 2018 2018 FLA
2536 2536 Khris Davis 30 daviskh01 2018 OAK AL 6.084696824 2.8 LF 17 1 OAK MIL 2016 2019  
2723 2723 Tyler Webb 27 webbty01 2018 SDP NL 0.160721914 -0.385 P 0 1 SDP MIL 2018 2018 STL
2790 2790 Will Smith 28 smithwi04 2018 SFG NL 2.054853846 1.475 P 8 1 SFG MIL 2016 2019  
2869 2869 Preston Guilmet 30 guilmpr01 2018 STL NL 0.047454703 -0.245 P 0 1 STL MIL 2018 2018 TOR
2895 2895 Ji-Man Choi 27 choiji01 2018 TBR AL 1.775797829 1.055 1B, LF 6 2 TBD MIL 2018 2019  
2992 2992 Marco Estrada 34 estrama01 2018 TOR AL 4.104091449 0.51 P 8 1 TOR MIL 2015 2018 OAK
3089 3089 Carlos Torres 35 torreca01 2018 WSN NL 0.187919686 -0.145 P 0 1 WSN MIL 2018 2018 DET
3159 3159 Sam Freeman 30 freemsa01 2017 ATL NL 1.914397113 1.14 P 6 1 ATL MIL 2017 2018 ANA
3269 3269 Blaine Boyer 35 boyerbl01 2017 BOS AL 0.992497374 0.3 P 2 1 BOS MIL 2017 2017 KCR
3392 3392 Scooter Gennett 27 gennesc01 2017 CIN NL 4.898215803 2.205 2B, 3B, LF, RF, P 13 1 CIN MIL 2017 2019 SFG
3538 3538 Alex Presley 31 preslal01 2017 DET AL 2.498694517 0.145 RF, CF, LF 3 1 DET MIL 2016 2017  
3566 3566 Francisco Rodriguez 35 rodrifr03 2017 DET AL 0.961707809 -0.83 P 0 1 DET MIL 2016 2017  
3586 3586 Mike Fiers 32 fiersmi01 2017 HOU AL 4.296105014 -0.135 P 6 1 HOU MIL 2015 2017 DET
3613 3613 Lorenzo Cain 31 cainlo01 2017 KCR AL 6.235 4.785 CF 24 1 KCR MIL 2011 2017 MIL
3622 3622 Alcides Escobar 30 escobal02 2017 KCR AL 6.080333333 0.06 SS 10 1 KCR MIL 2011 2018  
3637 3637 Neftali Feliz 29 felizne01 2017 KCR AL 0.453929218 0.125 P 1 2 KCR MIL 2017 2017  
3665 3665 Martin Maldonado 30 maldoma01 2017 LAA AL 4.513879709 2.345 C, 1B 14 1 ANA MIL 2017 2018 HOU
3703 3703 Nick Franklin 26 frankni01 2017 LAA AL 0.287508262 0.01 LF, 2B, RF, SS 0 2 ANA MIL 2017 2017 MIL
3704 3704 Damien Magnifico 26 magnida01 2017 LAA AL 0.005706731 0.005 P 0 1 ANA MIL 2017 2017  
3707 3707 Ramon Flores 25 florera02 2017 LAA AL 0.086252479 -0.135 RF 0 1 ANA MIL 2017 2017  
3878 3878 Brandon Kintzler 32 kintzbr01 2017 MIN AL 1.864193844 0.875 P 5 1 MIN MIL 2016 2017 WSN
3962 3962 Tommy Milone 30 milonto01 2017 NYM NL 0.695003736 -0.6 P 0 2 NYM MIL 2017 2017 WSN
3973 3973 CC Sabathia 36 sabatc.01 2017 NYY AL 4.195075683 2.345 P 12 1 NYY MIL 2009 2019  
4016 4016 Chris Carter 30 cartech02 2017 NYY AL 1.906146311 -0.72 1B, RF 0 1 NYY MIL 2017 2017  
4018 4018 Khris Davis 29 daviskh01 2017 OAK AL 6.196296903 2.615 LF 17 1 OAK MIL 2016 2019  
4070 4070 Chris Smith 36 smithch08 2017 OAK AL 1.415514045 -0.9 P 0 1 OAK MIL 2016 2017  
4145 4145 Jhan Marinez 28 marinjh01 2017 PIT NL 0.708521457 0.36 P 2 2 PIT MIL 2017 2017 TEX
4370 4370 Jonathan Broxton 33 broxtjo01 2017 STL NL 0.403194843 -0.195 P 0 1 STL MIL 2015 2017  
4408 4408 Shane Peterson 29 petersh01 2017 TBR AL 0.833714472 0.27 LF, RF 2 1 TBD MIL 2017 2017  
4454 4454 Jonathan Lucroy 31 lucrojo01 2017 TEX AL 2.912372826 -0.47 C, 1B 3 1 TEX MIL 2016 2017 COL
4462 4462 Jeremy Jeffress 29 jeffrje01 2017 TEX AL 1.215835873 -0.23 P 1 1 TEX MIL 2016 2017 MIL
4465 4465 Paolo Espino 30 espinpa01 2017 TEX AL 0.15730739 0.025 P 0 2 TEX MIL 2017 2017  
4469 4469 Will Middlebrooks 28 middlwi01 2017 TEX AL 0.371184772 -0.07 3B, 1B 0 1 TEX MIL 2017 2017  
4488 4488 Marco Estrada 33 estrama01 2017 TOR AL 4.977122692 2.245 P 14 1 TOR MIL 2015 2018 OAK
4592 4592 Jean Segura 26 segurje01 2016 ARI NL 6.792440094 5.235 2B, SS 25 1 ARI MIL 2016 2016 SEA
4618 4618 Tyler Wagner 25 wagnety01 2016 ARI NL 0.404121632 0.37 P 2 1 ARI MIL 2016 2016  
4691 4691 Blake Lalli 33 lallibl01 2016 ATL NL 0.128274923 -0.181118012 1B 0 1 ATL MIL 2016 2016  
4779 4779 Aaron Hill 34 hillaa01 2016 BOS AL 1.262672811 -0.265 3B, 2B 1 2 BOS MIL 2016 2016 SFG
4859 4859 Zach Duke 33 dukeza01 2016 CHW AL 1.293693977 1.04 P 5 1 CHW MIL 2015 2016 STL
4917 4917 Hernan Iribarren 32 iribahe01 2016 CIN NL 0.452574996 0.18 CF, 2B, 1B, RF 1 1 CIN MIL 2016 2016  
5056 5056 Francisco Rodriguez 34 rodrifr03 2016 DET AL 2.556871344 0.945838509 P 6 1 DET MIL 2016 2017  
5075 5075 Alex Presley 30 preslal01 2016 DET AL 0.04750983 -0.02515528 RF, LF, CF 0 2 DET MIL 2016 2017  
5095 5095 Mike Fiers 31 fiersmi01 2016 HOU AL 4.642738733 0.87 P 9 1 HOU MIL 2015 2017 DET
5111 5111 Carlos Gomez 30 gomezca01 2016 HOU AL 3.030901149 -0.805 CF, LF, RF 2 1 HOU MIL 2015 2016 TEX
5131 5131 Lorenzo Cain 30 cainlo01 2016 KCR AL 4.173768861 2.585 CF, RF 14 1 KCR MIL 2011 2017 MIL
5137 5137 Alcides Escobar 29 escobal02 2016 KCR AL 6.558779639 0.51 SS 12 1 KCR MIL 2011 2018  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "mlb-quasi-win-shares/quasi_winshares" (
"name_common" TEXT,
  "age" INTEGER,
  "player_ID" TEXT,
  "year_ID" INTEGER,
  "team_ID" TEXT,
  "lg_ID" TEXT,
  "pct_PT" REAL,
  "WAR162" REAL,
  "def_pos" TEXT,
  "quasi_ws" INTEGER,
  "stint_ID" INTEGER,
  "franch_id" TEXT,
  "prev_franch" TEXT,
  "year_acq" INTEGER,
  "year_left" INTEGER,
  "next_franch" TEXT
);