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

1,595 rows where next_franch = "MIL"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, lg_ID, stint_ID, franch_id, prev_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
1076 1076 Jordan Lyles 28 lylesjo01 2019 PIT NL 2.460064406 0.356603774 P 5 1 PIT MIL 2019 2019 MIL
1215 1215 David Freitas 30 freitda01 2019 SEA AL 0.038245961 -0.020377358 C 0 1 SEA ATL 2018 2019 MIL
1262 1262 Tyler Austin 27 austity01 2019 SFG NL 1.477899116 0.183396226 LF, 1B, RF 3 2 SFG MIN 2019 2019 MIL
1269 1269 Drew Pomeranz 30 pomerdr01 2019 SFG NL 2.036715642 -0.468679245 P 2 1 SFG BOS 2019 2019 MIL
1278 1278 Ray Black 29 blackra01 2019 SFG NL 0.029720314 0.00509434 P 0 1 SFG   2018 2019 MIL
1386 1386 Jake Faria 25 fariaja01 2019 TBR AL 0.226780307 0.061132075 P 1 1 TBD   2017 2019 MIL
1676 1676 Jonathan Schoop 26 schoojo01 2018 BAL AL 3.541174513 1.07 2B, SS 7 1 BAL   2013 2018 MIL
1705 1705 Donnie Hart 27 hartdo01 2018 BAL AL 0.564667646 -0.01 P 1 1 BAL   2016 2018 MIL
1834 1834 Joakim Soria 34 soriajo01 2018 CHW AL 1.366142127 1.215 P 5 1 CHW KCR 2018 2018 MIL
1844 1844 Xavier Cedeno 31 cedenxa01 2018 CHW AL 0.837927233 0.51 P 3 1 CHW TBD 2018 2018 MIL
1854 1854 Tyler Saladino 28 saladty01 2018 CHW AL 0.086280992 0.045 SS, 2B, 3B 0 1 CHW   2015 2018 MIL
2029 2029 Alex Wilson 31 wilsoal01 2018 DET AL 2.195098401 0.715 P 5 1 DET BOS 2015 2018 MIL
2110 2110 Mike Moustakas 29 moustmi01 2018 KCR AL 4.003641781 1.91 3B, 1B 10 1 KCR   2011 2018 MIL
2151 2151 Burch Smith 28 smithbu03 2018 KCR AL 1.854852475 -0.85 P 0 1 KCR SDP 2018 2018 MIL
2218 2218 Yasmani Grandal 29 grandya01 2018 LAD NL 4.986556017 3.970490798 C, 1B 18 1 LAD SDP 2015 2018 MIL
2692 2692 Cory Spangenberg 27 spangco01 2018 SDP NL 3.309399931 0.62 2B, 3B, LF, P, SS 7 1 SDP   2014 2018 MIL
2702 2702 Jordan Lyles 27 lylesjo01 2018 SDP NL 1.738388153 0.16 P 3 1 SDP COL 2017 2018 MIL
2741 2741 Ben Gamel 26 gamelbe01 2018 SEA AL 2.801978566 0.69 LF, RF, CF, 1B 7 1 SEA NYY 2016 2018 MIL
2765 2765 David Freitas 29 freitda01 2018 SEA AL 1.013685078 -0.05 C, 1B 1 1 SEA ATL 2018 2019 MIL
2823 2823 Ray Black 28 blackra01 2018 SFG NL 0.66924117 -0.21 P 0 1 SFG   2018 2019 MIL
2909 2909 Brad Miller 28 millebr02 2018 TBR AL 1.634861494 0.245 1B, 2B, SS 3 1 TBD SEA 2016 2018 MIL
2914 2914 Jake Faria 24 fariaja01 2018 TBR AL 1.603470101 -0.07 P 2 1 TBD   2017 2019 MIL
2948 2948 Alex Claudio 26 claudal01 2018 TEX AL 2.253479463 0.87 P 5 1 TEX   2014 2018 MIL
2996 2996 Curtis Granderson 37 grandcu01 2018 TOR AL 3.344679445 0.55 LF, RF, CF 7 1 TOR LAD 2018 2018 MIL
3016 3016 Jake Petricka 30 petrija01 2018 TOR AL 1.30454879 0.01 P 2 1 TOR CHW 2018 2018 MIL
3054 3054 Gio Gonzalez 32 gonzagi01 2018 WSN NL 4.073371042 1.27 P 9 1 WSN OAK 2012 2018 MIL
3120 3120 J.J. Hoover 29 hoovejj01 2017 ARI NL 1.340355259 0.22 P 3 1 ARI CIN 2017 2017 MIL
3192 3192 Jonathan Schoop 25 schoojo01 2017 BAL AL 6.394968964 4.46 2B, SS 23 1 BAL   2013 2018 MIL
3203 3203 Wade Miley 30 mileywa01 2017 BAL AL 4.520199582 0.375 P 8 1 BAL SEA 2016 2017 MIL
3214 3214 Donnie Hart 26 hartdo01 2017 BAL AL 1.281382146 0.375 P 3 1 BAL   2016 2018 MIL
3215 3215 Alec Asher 25 asheral01 2017 BAL AL 1.668495676 0.1 P 3 1 BAL PHI 2017 2017 MIL
3227 3227 Oliver Drake 30 drakeol01 2017 BAL AL 0.06503958 -0.025 P 0 1 BAL   2015 2017 MIL
3345 3345 Anthony Swarzak 31 swarzan01 2017 CHW AL 1.88424953 1.8 P 8 1 CHW NYY 2017 2017 MIL
3378 3378 Tyler Saladino 27 saladty01 2017 CHW AL 2.698791191 -0.94 2B, 3B, SS, 1B 1 1 CHW   2015 2018 MIL
3467 3467 Boone Logan 32 loganbo02 2017 CLE AL 0.583724344 0.17 P 1 1 CLE COL 2017 2017 MIL
3534 3534 Alex Wilson 30 wilsoal01 2017 DET AL 2.060352393 0.395 P 4 1 DET BOS 2015 2018 MIL
3613 3613 Lorenzo Cain 31 cainlo01 2017 KCR AL 6.235 4.785 CF 24 1 KCR MIL 2011 2017 MIL
3618 3618 Mike Moustakas 28 moustmi01 2017 KCR AL 5.780666667 1.93 3B 15 1 KCR   2011 2018 MIL
3698 3698 Deolis Guerra 28 guerrde01 2017 LAA AL 0.662477005 -0.06 P 1 1 ANA PIT 2016 2017 MIL
3703 3703 Nick Franklin 26 frankni01 2017 LAA AL 0.287508262 0.01 LF, 2B, RF, SS 0 2 ANA MIL 2017 2017 MIL
3723 3723 Yasmani Grandal 28 grandya01 2017 LAD NL 4.76739427 3.16 C 17 1 LAD SDP 2015 2018 MIL
3771 3771 Christian Yelich 25 yelicch01 2017 MIA NL 6.797639123 4.41 CF 22 1 FLA   2013 2017 MIL
3923 3923 Neil Walker 31 walkene01 2017 NYM NL 2.966980325 1.27 2B, 1B, 3B 8 1 NYM PIT 2016 2017 MIL
3995 3995 Ji-Man Choi 26 choiji01 2017 NYY AL 0.164954969 0.125 1B 1 1 NYY ANA 2017 2017 MIL
4003 4003 Erik Kratz 37 kratzer01 2017 NYY AL 0.01832833 0.105 C 0 1 NYY PIT 2017 2017 MIL
4005 4005 Tyler Webb 26 webbty01 2017 NYY AL 0.155727133 -0.035 P 0 1 NYY   2017 2017 MIL
4052 4052 Stephen Vogt 32 vogtst01 2017 OAK AL 1.653612977 -0.325 C, LF 1 1 OAK TBD 2013 2017 MIL
4169 4169 Jhoulys Chacin 29 chacijh01 2017 SDP NL 5.106098096 2.795 P 17 1 SDP ANA 2017 2017 MIL
4179 4179 Cory Spangenberg 26 spangco01 2017 SDP NL 4.991676997 0.47 3B, LF, 2B 10 1 SDP   2014 2018 MIL
4211 4211 Jordan Lyles 26 lylesjo01 2017 SDP NL 0.651239868 -0.255 P 0 2 SDP COL 2017 2018 MIL
4229 4229 Ben Gamel 25 gamelbe01 2017 SEA AL 5.19628604 1.395 LF, RF, 1B 11 1 SEA NYY 2016 2018 MIL
4388 4388 Jake Faria 23 fariaja01 2017 TBR AL 2.315205075 1.38 P 7 1 TBD   2017 2019 MIL
4393 4393 Brad Miller 27 millebr02 2017 TBR AL 3.855929435 0.25 2B 6 1 TBD SEA 2016 2018 MIL
4416 4416 Dan Jennings 30 jennida01 2017 TBR AL 0.61553897 0.105 P 1 2 TBD CHW 2017 2017 MIL
4440 4440 Alex Claudio 25 claudal01 2017 TEX AL 2.953167722 2.335 P 11 1 TEX   2014 2018 MIL
4462 4462 Jeremy Jeffress 29 jeffrje01 2017 TEX AL 1.215835873 -0.23 P 1 1 TEX MIL 2016 2017 MIL
4546 4546 Gio Gonzalez 31 gonzagi01 2017 WSN NL 5.633380344 4.935 P 23 1 WSN OAK 2012 2018 MIL
4554 4554 Matt Albers 34 alberma01 2017 WSN NL 1.909696258 1.73 P 8 1 WSN CHW 2017 2017 MIL
4706 4706 Jonathan Schoop 24 schoojo01 2016 BAL AL 6.19138756 2.325 2B 16 1 BAL   2013 2018 MIL
4721 4721 Wade Miley 29 mileywa01 2016 BAL AL 1.554021713 0.325 P 3 2 BAL SEA 2016 2017 MIL
4726 4726 Donnie Hart 25 hartdo01 2016 BAL AL 0.482215021 0.52 P 2 1 BAL   2016 2018 MIL
4733 4733 Oliver Drake 29 drakeol01 2016 BAL AL 0.498512341 0.06 P 1 1 BAL   2015 2017 MIL
4758 4758 Travis Shaw 26 shawtr01 2016 BOS AL 4.884792627 1.83 3B, 1B, LF 11 1 BOS   2015 2016 MIL
4835 4835 Neil Ramirez 27 ramirne01 2016 CHC NL 0.224544592 -0.01 P 0 1 CHC   2014 2016 MIL
4854 4854 Tyler Saladino 26 saladty01 2016 CHW AL 3.02864626 1.445 2B, SS, 3B, 1B, CF, LF, RF 8 1 CHW   2015 2018 MIL
4987 4987 Jesus Aguilar 26 aguilje01 2016 CLE AL 0.056769984 -0.155962733 1B 0 1 CLE   2014 2016 MIL
5051 5051 Alex Wilson 29 wilsoal01 2016 DET AL 2.493591927 1.453975155 P 8 1 DET BOS 2015 2018 MIL
5131 5131 Lorenzo Cain 30 cainlo01 2016 KCR AL 4.173768861 2.585 CF, RF 14 1 KCR MIL 2011 2017 MIL
5148 5148 Mike Moustakas 27 moustmi01 2016 KCR AL 1.08671862 0.78 3B 4 1 KCR   2011 2018 MIL
5184 5184 Jett Bandy 26 bandyje01 2016 LAA AL 2.225581395 0.73 C 5 1 ANA   2015 2016 MIL
5190 5190 Deolis Guerra 27 guerrde01 2016 LAA AL 1.518345939 0.4 P 3 1 ANA PIT 2016 2017 MIL
5226 5226 Yasmani Grandal 27 grandya01 2016 LAD NL 4.534040369 4.245 C, 1B 19 1 LAD SDP 2015 2018 MIL
5278 5278 Christian Yelich 24 yelicch01 2016 MIA NL 6.570740932 5.418447205 LF, CF 25 1 FLA   2013 2017 MIL
5414 5414 Tommy Milone 29 milonto01 2016 MIN AL 1.914406113 -0.28 P 1 1 MIN OAK 2014 2016 MIL
5435 5435 Neil Walker 30 walkene01 2016 NYM NL 4.586325967 3.1 2B 15 1 NYM PIT 2016 2017 MIL
5535 5535 Stephen Vogt 31 vogtst01 2016 OAK AL 5.14438146 1.17 C, 1B 11 1 OAK TBD 2013 2017 MIL
5652 5652 Neftali Feliz 28 felizne01 2016 PIT NL 1.945577697 0.43 P 4 1 PIT DET 2016 2016 MIL
5653 5653 Jared Hughes 30 hugheja02 2016 PIT NL 1.608814287 0.28 P 3 1 PIT   2011 2016 MIL
5663 5663 Rob Scahill 29 scahiro01 2016 PIT NL 0.381705147 0.01 P 1 1 PIT COL 2015 2016 MIL
5711 5711 Cory Spangenberg 25 spangco01 2016 SDP NL 0.540151116 0.24 2B 2 1 SDP   2014 2018 MIL
5733 5733 Michael Kirkman 29 kirkmmi01 2016 SDP NL 0.08623939 -0.27 P 0 1 SDP TEX 2016 2016 MIL
5789 5789 Ben Gamel 24 gamelbe01 2016 SEA AL 0.439535634 -0.21 RF, LF, CF 0 2 SEA NYY 2016 2018 MIL
5887 5887 Brad Miller 26 millebr02 2016 TBR AL 5.789403754 1.945 SS, 1B, LF 12 1 TBD SEA 2016 2018 MIL
5904 5904 Nick Franklin 25 frankni01 2016 TBR AL 1.839893705 0.125 LF, 1B, 2B, RF, SS 2 1 TBD SEA 2014 2016 MIL
5919 5919 Jhan Marinez 27 marinjh01 2016 TBR AL 0.062879206 0.03 P 0 1 TBD CHW 2016 2016 MIL
5947 5947 Alex Claudio 24 claudal01 2016 TEX AL 1.360399916 1.015 P 6 1 TEX   2014 2018 MIL
5955 5955 Jeremy Jeffress 28 jeffrje01 2016 TEX AL 0.437367715 0.25 P 2 2 TEX MIL 2016 2017 MIL
6039 6039 Gio Gonzalez 30 gonzagi01 2016 WSN NL 4.868870985 1.805 P 13 1 WSN OAK 2012 2018 MIL
6081 6081 Chase Anderson 27 anderch01 2015 ARI NL 4.16700428 1.045 P 9 1 ARI   2014 2015 MIL
6093 6093 Aaron Hill 33 hillaa01 2015 ARI NL 3.442744241 -0.22 2B, 3B 4 1 ARI TOR 2011 2015 MIL
6195 6195 Jonathan Schoop 23 schoojo01 2015 BAL AL 3.110776942 1.34 2B 8 1 BAL   2013 2018 MIL
6213 6213 Oliver Drake 28 drakeol01 2015 BAL AL 0.370553826 0.12 P 1 1 BAL   2015 2017 MIL
6243 6243 Travis Shaw 25 shawtr01 2015 BOS AL 2.315518352 1.29 1B, 3B, LF 7 1 BOS   2015 2016 MIL
6312 6312 Neil Ramirez 26 ramirne01 2015 CHC NL 0.296567223 0.14 P 1 1 CHC   2014 2016 MIL
6318 6318 Quintin Berry 30 berryqu01 2015 CHC NL 0.009960501 -0.01 CF, LF, RF 0 1 CHC BAL 2015 2015 MIL
6348 6348 Tyler Saladino 25 saladty01 2015 CHW AL 2.43624938 0.785 3B, SS, 1B 6 1 CHW   2015 2018 MIL
6363 6363 Junior Guerra 30 guerrju02 2015 CHW AL 0.073599878 -0.025 P 0 1 CHW   2015 2015 MIL
6462 6462 Jesus Aguilar 25 aguilje01 2015 CLE AL 0.190632703 -0.115714286 1B 0 1 CLE   2014 2016 MIL
6535 6535 Alex Wilson 28 wilsoal01 2015 DET AL 2.131233861 1.277888199 P 7 1 DET BOS 2015 2018 MIL
6568 6568 Hernan Perez 24 perezhe01 2015 DET AL 0.32159165 -0.669130435 3B, 2B, 1B, SS 0 1 DET   2012 2015 MIL

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