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

2,365 rows where next_franch = "DET"

✎ 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
847 847 Austin Adams 32 adamsau01 2019 MIN AL 0.039534947 -0.117169811 P 0 1 MIN CLE 2019 2019 DET
1514 1514 Edwin Jackson 35 jacksed01 2019 TOR AL 0.799676446 -1.207358491 P 0 1 TOR OAK 2019 2019 DET
1562 1562 Trevor Rosenthal 29 rosentr01 2019 WSN NL 0.179544682 -0.652075472 P 0 1 WSN STL 2019 2019 DET
1654 1654 Dustin Peterson 23 peterdu01 2018 ATL NL 0.01958467 -0.025   0 1 ATL   2018 2018 DET
1920 1920 Brandon Dixon 26 dixonbr01 2018 CIN NL 1.22043102 -0.405 1B, RF, 2B, LF, 3B, P 0 1 CIN   2018 2018 DET
1956 1956 Zach McAllister 30 mcallza01 2018 CLE AL 1.151755412 -0.125 P 1 1 CLE   2011 2018 DET
2311 2311 Jacob Turner 27 turneja01 2018 MIA NL 0.156262583 -0.402484472 P 0 1 FLA WSN 2018 2018 DET
2402 2402 Bobby Wilson 35 wilsobo02 2018 MIN AL 1.428245271 0.055 C 2 1 MIN TBD 2018 2018 DET
2645 2645 Jordy Mercer 31 mercejo03 2018 PIT NL 4.397148322 0.538322981 SS 8 1 PIT   2012 2018 DET
2648 2648 Josh Harrison 30 harrijo05 2018 PIT NL 3.771865762 0.296832298 2B, 3B 7 1 PIT   2011 2018 DET
2673 2673 Josh Smoker 29 smokejo01 2018 PIT NL 0.162484672 -0.337080745 P 0 1 PIT NYM 2018 2018 DET
2764 2764 Gordon Beckham 31 beckhgo01 2018 SEA AL 0.478153339 0.005 2B, 3B, SS 1 1 SEA SFG 2017 2018 DET
2848 2848 Tyson Ross 31 rossty01 2018 STL NL 0.998941034 0.66 P 4 2 STL SDP 2018 2018 DET
2958 2958 Matt Moore 29 moorema02 2018 TEX AL 2.722274771 -0.47 P 2 1 TEX SFG 2018 2018 DET
3034 3034 Jose Fernandez 25 fernajo04 2018 TOR AL 0.384064242 -0.05 P 0 1 TOR   2018 2018 DET
3089 3089 Carlos Torres 35 torreca01 2018 WSN NL 0.187919686 -0.145 P 0 1 WSN MIL 2018 2018 DET
3323 3323 Leonys Martin 29 martile01 2017 CHC NL 0.156413282 0.09 CF, RF, LF, P 0 2 CHC SEA 2017 2017 DET
3336 3336 Jeimer Candelario 23 candeje01 2017 CHC NL 0.351929884 -0.19 3B, 1B 0 1 CHC   2016 2017 DET
3456 3456 Zach McAllister 29 mcallza01 2017 CLE AL 1.496118177 0.92 P 5 1 CLE   2011 2018 DET
3586 3586 Mike Fiers 32 fiersmi01 2017 HOU AL 4.296105014 -0.135 P 6 1 HOU MIL 2015 2017 DET
3604 3604 Francisco Liriano 33 liriafr01 2017 HOU AL 0.457729001 -0.07 P 0 2 HOU TOR 2017 2017 DET
3910 3910 Niko Goodrum 25 goodrni01 2017 MIN AL 0.167388167 -0.205 2B, RF 0 1 MIN   2017 2017 DET
4124 4124 Josh Harrison 29 harrijo05 2017 PIT NL 5.407878892 3.01 2B, 3B, LF, RF 17 1 PIT   2011 2018 DET
4131 4131 Jordy Mercer 30 mercejo03 2017 PIT NL 5.567521073 1.44 SS 12 1 PIT   2012 2018 DET
4153 4153 Johnny Barbato 24 barbajo01 2017 PIT NL 0.632264389 0.025 P 1 1 PIT NYY 2017 2017 DET
4271 4271 Gordon Beckham 30 beckhgo01 2017 SEA AL 0.17006027 -0.155 2B, SS, 3B 0 1 SEA SFG 2017 2018 DET
4481 4481 Pete Kozma 29 kozmape01 2017 TEX AL 0.390219888 -0.545 3B, SS, 1B, 2B 0 2 TEX NYY 2017 2017 DET
4541 4541 Jarrod Saltalamacchia 32 saltaja01 2017 TOR AL 0.246003263 -0.6 C 0 1 TOR DET 2017 2017 DET
4663 4663 Erick Aybar 32 aybarer01 2016 ATL NL 3.631167064 -0.830124224 SS, 3B, 2B 3 1 ATL ANA 2016 2016 DET
4780 4780 William Cuevas 25 cuevawi01 2016 BOS AL 0.100969688 0.035 P 0 1 BOS   2016 2016 DET
4794 4794 Bryan Holaday 28 holadbr01 2016 BOS AL 0.322580645 -0.22 C, 3B, LF, P 0 2 BOS TEX 2016 2016 DET
4837 4837 Jeimer Candelario 22 candeje01 2016 CHC NL 0.136815501 -0.18 3B 0 1 CHC   2016 2017 DET
4860 4860 Alex Avila 29 avilaal01 2016 CHW AL 1.98428548 0.775 C 5 1 CHW DET 2016 2016 DET
4965 4965 Zach McAllister 28 mcallza01 2016 CLE AL 1.635897603 0.684223602 P 4 1 CLE   2011 2018 DET
5095 5095 Mike Fiers 31 fiersmi01 2016 HOU AL 4.642738733 0.87 P 9 1 HOU MIL 2015 2017 DET
5258 5258 Louis Coleman 30 colemlo01 2016 LAD NL 1.4764023 -0.23 P 1 1 LAD KCR 2016 2016 DET
5378 5378 Alex Presley 30 preslal01 2016 MIL NL 1.300764951 -0.655 RF, LF, CF 0 1 MIL HOU 2016 2016 DET
5618 5618 Daniel Stumpf 25 stumpda01 2016 PHI NL 0.176054151 -0.235 P 0 1 PHI   2016 2016 DET
5634 5634 Josh Harrison 28 harrijo05 2016 PIT NL 5.096969697 1.5 2B, RF 12 1 PIT   2011 2018 DET
5635 5635 Jordy Mercer 29 mercejo03 2016 PIT NL 5.702356902 1.15 SS 12 1 PIT   2012 2018 DET
5929 5929 Mikie Mahtook 26 mahtomi01 2016 TBR AL 1.888058462 -1.055 LF, CF, RF 0 1 TBD   2015 2016 DET
6062 6062 Matt den Dekker 28 dendema01 2016 WSN NL 0.387926599 0.185 CF, RF, LF 1 1 WSN NYM 2015 2016 DET
6091 6091 Jarrod Saltalamacchia 30 saltaja01 2015 ARI NL 1.89204641 0.59 C, 1B 4 2 ARI FLA 2015 2015 DET
6130 6130 Cameron Maybin 28 maybica01 2015 ATL NL 5.645387583 0.9 CF 11 1 ATL SDP 2015 2015 DET
6441 6441 Zach McAllister 27 mcallza01 2015 CLE AL 2.118984792 0.945838509 P 5 1 CLE   2011 2018 DET
6471 6471 Mike Aviles 34 avilemi01 2015 CLE AL 3.021528348 -1.111863354 LF, 3B, SS, 2B, CF, RF 0 1 CLE BOS 2013 2015 DET
6592 6592 Mike Fiers 30 fiersmi01 2015 HOU AL 1.723196091 0.695 P 4 2 HOU MIL 2015 2017 DET
6686 6686 Efren Navarro 29 navaref01 2015 LAA AL 0.855227882 0.165 1B, LF, RF 2 1 ANA   2011 2015 DET
6817 6817 Casey McGehee 32 mcgehca01 2015 MIA NL 1.227513228 -0.65 3B, 1B 0 2 FLA SFG 2015 2015 DET
6828 6828 Francisco Rodriguez 33 rodrifr03 2015 MIL NL 2.138944876 1.355 P 7 1 MIL BAL 2014 2015 DET
6872 6872 Mike Pelfrey 31 pelfrmi01 2015 MIN AL 4.570130182 1.875 P 13 1 MIN NYM 2013 2015 DET
6958 6958 Bobby Parnell 30 parnebo01 2015 NYM NL 0.74163909 -0.5 P 0 1 NYM   2008 2015 DET
6975 6975 Justin Wilson 27 wilsoju10 2015 NYY AL 2.251576056 1.54 P 8 1 NYY PIT 2015 2015 DET
7058 7058 Edward Mujica 31 mujiced01 2015 OAK AL 1.141248421 -0.355 P 0 2 OAK BOS 2015 2015 DET
7127 7127 Josh Harrison 27 harrijo05 2015 PIT NL 4.380487805 1.525 3B, 2B, RF, LF 12 1 PIT   2011 2018 DET
7132 7132 Jordy Mercer 28 mercejo03 2015 PIT NL 4.195121951 0.34 SS 8 1 PIT   2012 2018 DET
7165 7165 Justin Upton 27 uptonju01 2015 SDP NL 6.306559102 3.83 LF 21 1 SDP ATL 2015 2015 DET
7243 7243 Logan Kensing 32 kensilo01 2015 SEA AL 0.505065315 -0.18 P 0 1 SEA COL 2015 2015 DET
7253 7253 John Hicks 25 hicksjo02 2015 SEA AL 0.322961022 -0.55 C, 3B 0 1 SEA   2015 2015 DET
7367 7367 Mikie Mahtook 25 mahtomi01 2015 TBR AL 1.102297141 1.34 LF, CF, RF 5 1 TBD   2015 2016 DET
7396 7396 Marc Krauss 27 krausma01 2015 TBR AL 0.095851925 -0.18 1B, LF 0 2 TBD ANA 2015 2015 DET
7436 7436 Bobby Wilson 32 wilsobo02 2015 TEX AL 0.827899432 0.25 C 2 2 TEX TBD 2015 2015 DET
7437 7437 Neftali Feliz 27 felizne01 2015 TEX AL 0.902871068 0.075 P 2 1 TEX   2009 2015 DET
7493 7493 Daniel Norris 22 norrida01 2015 TOR AL 0.669819118 0.16 P 1 1 TOR   2014 2015 DET
7496 7496 Mark Lowe 32 lowema01 2015 TOR AL 0.649867059 0.085 P 1 2 TOR SEA 2015 2015 DET
7514 7514 Matthew Boyd 24 boydma01 2015 TOR AL 0.190358929 -0.45 P 0 1 TOR   2015 2015 DET
7517 7517 Jordan Zimmermann 29 zimmejo02 2015 WSN NL 5.59641262 3.03 P 16 1 WSN   2009 2015 DET
7536 7536 Matt den Dekker 27 dendema01 2015 WSN NL 1.108216085 0.5 LF, RF, CF 3 1 WSN NYM 2015 2016 DET
7706 7706 Yoenis Cespedes 28 cespeyo01 2014 BOS AL 1.990654206 1.085 LF, CF 6 2 BOS OAK 2014 2014 DET
7721 7721 Alex Wilson 27 wilsoal01 2014 BOS AL 0.676637246 0.26 P 2 1 BOS   2013 2014 DET
7847 7847 Alfredo Simon 33 simonal01 2014 CIN NL 5.467142234 1.64 P 12 1 CIN BAL 2012 2014 DET
7902 7902 Zach McAllister 26 mcallza01 2014 CLE AL 2.457308895 0.655 P 5 1 CLE   2011 2018 DET
7904 7904 Mike Aviles 33 avilemi01 2014 CLE AL 3.49814546 -0.155 3B, 2B, LF, SS, CF, RF 5 1 CLE BOS 2013 2015 DET
8067 8067 Jose Cisnero 25 cisnejo01 2014 HOU AL 0.16289851 -0.155 P 0 1 HOU   2013 2014 DET
8148 8148 Efren Navarro 28 navaref01 2014 LAA AL 1.612398147 0.2 1B, LF, RF 3 1 ANA   2011 2015 DET
8264 8264 Randy Wolf 37 wolfra02 2014 MIA NL 0.618999698 -0.145 P 0 1 FLA BAL 2014 2014 DET
8290 8290 Francisco Rodriguez 32 rodrifr03 2014 MIL NL 2.608654858 0.39 P 5 1 MIL BAL 2014 2015 DET
8297 8297 Tom Gorzelanny 31 gorzeto01 2014 MIL NL 0.44825993 0.41 P 2 1 MIL WSN 2013 2014 DET
8356 8356 Mike Pelfrey 30 pelfrmi01 2014 MIN AL 0.677860845 -0.64 P 0 1 MIN NYM 2013 2015 DET
8395 8395 Bobby Parnell 29 parnebo01 2014 NYM NL 0.053832289 -0.06 P 0 1 NYM   2008 2015 DET
8426 8426 Shane Greene 25 greensh02 2014 NYY AL 2.054298166 0.805 P 5 1 NYY   2014 2014 DET
8508 8508 Jim Johnson 31 johnsji04 2014 OAK AL 1.052201144 -0.96 P 0 1 OAK BAL 2014 2014 DET
8560 8560 Josh Harrison 26 harrijo05 2014 PIT NL 5.428863172 5.125 3B, LF, RF, 2B, SS 23 1 PIT   2011 2018 DET
8563 8563 Jordy Mercer 27 mercejo03 2014 PIT NL 5.478216474 2.395 SS, RF 15 1 PIT   2012 2018 DET
8795 8795 David Price 28 priceda01 2014 TBR AL 4.689064577 2.925 P 14 1 TBD   2008 2014 DET
8846 8846 Joakim Soria 30 soriajo01 2014 TEX AL 1.276265465 1.145 P 5 1 TEX KCR 2013 2014 DET
8851 8851 Neftali Feliz 26 felizne01 2014 TEX AL 1.285491481 0.59 P 4 1 TEX   2009 2015 DET
8859 8859 Josh Wilson 33 wilsojo03 2014 TEX AL 0.695536309 0.305 2B, 3B, SS 2 1 TEX ARI 2014 2014 DET
8869 8869 Jim Adduci 29 adducji02 2014 TEX AL 1.101265823 -0.055 LF, RF, 1B 1 1 TEX   2013 2014 DET
8913 8913 Anthony Gose 23 gosean01 2014 TOR AL 2.587852141 0.765 CF, RF, LF 6 1 TOR   2012 2014 DET
8937 8937 Daniel Norris 21 norrida01 2014 TOR AL 0.180121582 -0.065 P 0 1 TOR   2014 2015 DET
8953 8953 Jordan Zimmermann 28 zimmejo02 2014 WSN NL 5.499694184 5.265 P 23 1 WSN   2009 2015 DET
9145 9145 Jose Iglesias 23 iglesjo01 2013 BOS AL 2.136313553 1.665 SS, 3B, 2B 8 1 BOS   2011 2013 DET
9162 9162 Alex Wilson 26 wilsoal01 2013 BOS AL 0.721333525 0.07 P 1 1 BOS   2013 2014 DET
9299 9299 Alfredo Simon 32 simonal01 2013 CIN NL 2.322683275 0.62 P 5 1 CIN BAL 2012 2014 DET
9334 9334 Zach McAllister 25 mcallza01 2013 CLE AL 3.825425029 1.22 P 10 1 CLE   2011 2018 DET
9339 9339 Mike Aviles 32 avilemi01 2013 CLE AL 3.719401042 0.37 3B, SS, 2B, LF, RF 7 1 CLE BOS 2013 2015 DET
9355 9355 Ezequiel Carrera 26 carreez01 2013 CLE AL 0.047200521 0.025 RF, CF, LF 0 2 CLE PHI 2013 2013 DET
9463 9463 Jose Veras 32 verasjo01 2013 HOU AL 1.606767064 0.85 P 5 1 HOU MIL 2013 2013 DET
9476 9476 Jose Cisnero 24 cisnejo01 2013 HOU AL 1.368099398 0.06 P 2 1 HOU   2013 2014 DET

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