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

952 rows where next_franch = "COL"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, lg_ID, quasi_ws, stint_ID, franch_id, prev_franch, year_left

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
79 79 Wes Parsons 26 parsowe01 2019 ATL NL 0.507481968 -0.045849057 P 1 1 ATL   2018 2019 COL
297 297 Yonder Alonso 32 alonsyo01 2019 CHW AL 2.460784314 -1.194493671 1B 0 1 CHW CLE 2019 2019 COL
946 946 Joe Harvey 27 harvejo01 2019 NYY AL 0.190112921 0.0 P 0 1 NYY   2019 2019 COL
1659 1659 Wes Parsons 25 parsowe01 2018 ATL NL 0.15374886 -0.1 P 0 1 ATL   2018 2019 COL
1795 1795 Daniel Murphy 33 murphda08 2018 CHC NL 1.401986755 0.31803681 2B, 1B 3 2 CHC WSN 2018 2018 COL
2149 2149 Drew Butera 34 buterdr01 2018 KCR AL 1.593775865 -0.71 C, 1B, P 0 1 KCR ANA 2015 2018 COL
2747 2747 James Pazos 27 pazosja01 2018 SEA AL 1.544376062 0.64 P 4 1 SEA NYY 2017 2018 COL
2997 2997 Seunghwan Oh 35 ohse01 2018 TOR AL 1.573629256 1.215 P 6 1 TOR STL 2018 2018 COL
3067 3067 Mark Reynolds 34 reynoma01 2018 WSN NL 2.291911888 -0.1 1B, 3B, 2B, CF, P, RF 3 1 WSN COL 2018 2018 COL
3109 3109 Chris Iannetta 34 iannech01 2017 ARI NL 3.120190671 2.06 C, 3B 11 1 ARI SEA 2017 2017 COL
3306 3306 Wade Davis 31 daviswa01 2017 CHC NL 2.31612735 1.49 P 8 1 CHC KCR 2017 2017 COL
3324 3324 Zac Rosscup 29 rosscza01 2017 CHC NL 0.013159814 0.01 P 0 1 CHC   2013 2017 COL
3454 3454 Bryan Shaw 29 shawbr01 2017 CLE AL 2.599421333 1.07 P 6 1 CLE ARI 2013 2017 COL
3643 3643 Drew Butera 33 buterdr01 2017 KCR AL 1.711 -0.475 C, 1B 1 1 KCR ANA 2015 2018 COL
3713 3713 Brooks Pounders 26 poundbr01 2017 LAA AL 0.20613704 -0.3 P 0 1 ANA KCR 2017 2017 COL
3987 3987 Matt Holliday 37 hollima01 2017 NYY AL 3.913098436 -0.01 1B 4 1 NYY STL 2017 2017 COL
4080 4080 Pat Neshek 36 neshepa01 2017 PHI NL 1.435042939 1.88 P 7 1 PHI HOU 2017 2017 COL
4206 4206 Tim Melville 27 melviti01 2017 SDP NL 0.050875749 -0.055 P 0 2 SDP MIN 2017 2017 COL
4243 4243 James Pazos 26 pazosja01 2017 SEA AL 1.778777804 0.085 P 3 1 SEA NYY 2017 2018 COL
4454 4454 Jonathan Lucroy 31 lucrojo01 2017 TEX AL 2.912372826 -0.47 C, 1B 3 1 TEX MIL 2016 2017 COL
4699 4699 Daniel Castro 23 castrda01 2016 ATL NL 1.371554951 -1.00621118 SS, 2B, 3B 0 1 ATL   2015 2016 COL
4798 4798 Ryan Hanigan 35 hanigry01 2016 BOS AL 1.041474654 -0.925 C 0 1 BOS TBD 2015 2016 COL
4961 4961 Bryan Shaw 28 shawbr01 2016 CLE AL 2.348251337 0.825093168 P 6 1 CLE ARI 2013 2017 COL
5149 5149 Drew Butera 32 buterdr01 2016 KCR AL 1.279058199 0.605 C, 1B, P 4 1 KCR ANA 2015 2018 COL
5297 5297 Mike Dunn 31 dunnmi01 2016 MIA NL 1.341821457 0.422608696 P 3 1 FLA ATL 2011 2016 COL
5723 5723 Alexi Amarista 27 amarial01 2016 SDP NL 1.528729573 -0.575 2B, SS, 3B, LF, RF, P 1 1 SDP ANA 2012 2016 COL
5932 5932 Ian Desmond 30 desmoia01 2016 TEX AL 6.472061975 3.11 CF, LF 21 1 TEX WSN 2016 2016 COL
5942 5942 Jonathan Lucroy 30 lucrojo01 2016 TEX AL 1.606065601 1.56 C, 1B 8 2 TEX MIL 2016 2017 COL
5971 5971 Chi Chi Gonzalez 24 gonzach01 2016 TEX AL 0.287279982 -0.265 P 0 1 TEX   2015 2016 COL
6141 6141 Daniel Castro 22 castrda01 2015 ATL NL 1.017186952 0.385 2B, SS, 3B 3 1 ATL   2015 2016 COL
6220 6220 Gerardo Parra 28 parrage01 2015 BAL AL 2.306432749 -0.73 RF, LF, CF 1 2 BAL MIL 2015 2015 COL
6251 6251 Ryan Hanigan 34 hanigry01 2015 BOS AL 1.876690277 0.665 C 4 1 BOS TBD 2015 2016 COL
6303 6303 Jason Motte 33 motteja01 2015 CHC NL 1.629822786 0.31 P 3 1 CHC STL 2015 2015 COL
6315 6315 Zac Rosscup 27 rosscza01 2015 CHC NL 0.991439502 -0.235 P 1 1 CHC   2013 2017 COL
6322 6322 Gonzalez Germen 27 germego01 2015 CHC NL 0.148715925 -0.045 P 0 1 CHC NYM 2015 2015 COL
6438 6438 Ryan Raburn 34 raburry01 2015 CLE AL 1.915858669 1.167204969 LF, RF, P 6 1 CLE DET 2013 2015 COL
6442 6442 Bryan Shaw 27 shawbr01 2015 CLE AL 2.316405735 0.689254658 P 5 1 CLE ARI 2013 2017 COL
6595 6595 Chad Qualls 36 quallch01 2015 HOU AL 1.586173756 0.205 P 3 1 HOU FLA 2014 2015 COL
6635 6635 Greg Holland 29 hollagr01 2015 KCR AL 1.816968562 0.54 P 5 1 KCR   2010 2015 COL
6659 6659 Drew Butera 31 buterdr01 2015 KCR AL 0.94239291 -0.37 C, 1B 0 2 KCR ANA 2015 2018 COL
6787 6787 Mike Dunn 30 dunnmi01 2015 MIA NL 2.070118731 0.025 P 3 1 FLA ATL 2011 2016 COL
7186 7186 Alexi Amarista 26 amarial01 2015 SDP NL 3.631357418 -0.75 SS, 2B, LF, CF, 3B, P 3 1 SDP ANA 2012 2016 COL
7325 7325 Mark Reynolds 31 reynoma01 2015 STL NL 4.330452817 -0.28 1B, 3B, LF, 2B, RF 6 1 STL MIL 2015 2015 COL
7369 7369 Jake McGee 28 mcgeeja01 2015 TBR AL 1.434356052 1.04 P 5 1 TBD   2010 2015 COL
7424 7424 Chi Chi Gonzalez 23 gonzach01 2015 TEX AL 1.907446796 0.5 P 5 1 TEX   2015 2016 COL
7481 7481 Jose Reyes 32 reyesjo01 2015 TOR AL 2.906073788 0.715 SS 6 1 TOR FLA 2013 2015 COL
7508 7508 Miguel Castro 20 castrmi01 2015 TOR AL 0.474573971 -0.105 P 0 1 TOR   2015 2015 COL
7630 7630 David Hale 26 haleda02 2014 ATL NL 2.256364887 0.15 P 4 1 ATL   2013 2014 COL
7678 7678 Nick Hundley 30 hundlni01 2014 BAL AL 1.652259332 0.025 C 3 2 BAL SDP 2014 2014 COL
7786 7786 Chris Rusin 27 rusinch01 2014 CHC NL 0.232273784 -0.115 P 0 1 CHC   2012 2014 COL
7789 7789 Zac Rosscup 26 rosscza01 2014 CHC NL 0.325341039 -0.355 P 0 1 CHC   2013 2017 COL
7901 7901 Bryan Shaw 26 shawbr01 2014 CLE AL 2.654772935 1.215 P 7 1 CLE ARI 2013 2017 COL
7931 7931 Ryan Raburn 33 raburry01 2014 CLE AL 1.982905983 -1.4 RF, LF, 1B 0 1 CLE DET 2013 2015 COL
8018 8018 Justin Miller 27 milleju02 2014 DET AL 0.244382447 -0.105 P 0 1 DET   2014 2014 COL
8047 8047 Chad Qualls 35 quallch01 2014 HOU AL 1.891859949 0.47 P 4 1 HOU FLA 2014 2015 COL
8089 8089 Greg Holland 28 hollagr01 2014 KCR AL 2.49083129 2.4 P 11 1 KCR   2010 2015 COL
8159 8159 Jairo Diaz 23 diazja01 2014 LAA AL 0.084899714 0.08 P 0 1 ANA   2014 2014 COL
8243 8243 Mike Dunn 29 dunnmi01 2014 MIA NL 2.243312905 0.635 P 5 1 FLA ATL 2011 2016 COL
8517 8517 Kyle Kendrick 29 kendrky01 2014 PHI NL 5.433096404 0.735 P 9 1 PHI   2007 2014 COL
8585 8585 John Axford 31 axforjo01 2014 PIT NL 0.257797515 0.055 P 1 2 PIT CLE 2014 2014 COL
8608 8608 Alexi Amarista 25 amarial01 2014 SDP NL 4.834197818 1.38 SS, 3B, 2B, CF, LF 12 1 SDP ANA 2012 2016 COL
8766 8766 Daniel Descalso 27 descada01 2014 STL NL 1.860529986 -0.025 2B, SS, 3B, 1B, P 3 1 STL   2010 2014 COL
8775 8775 Jorge Rondon 26 rondojo01 2014 STL NL 0.014558142 0.015 P 0 1 STL   2014 2014 COL
8797 8797 Jake McGee 27 mcgeeja01 2014 TBR AL 2.75641223 2.575 P 11 1 TBD   2010 2015 COL
8898 8898 Jose Reyes 31 reyesjo01 2014 TOR AL 6.186288878 3.49 SS 19 1 TOR FLA 2013 2015 COL
9060 9060 David Hale 25 haleda02 2013 ATL NL 0.306548675 0.52 P 2 1 ATL   2013 2014 COL
9110 9110 Jair Jurrjens 27 jurrjja01 2013 BAL AL 0.180455611 0.055 P 0 1 BAL ATL 2013 2013 COL
9126 9126 Jason Pridie 29 pridija01 2013 BAL AL 0.094802223 -0.33 CF, LF 0 1 BAL PHI 2013 2013 COL
9163 9163 Franklin Morales 27 moralfr01 2013 BOS AL 0.814364217 -0.025 P 1 1 BOS COL 2011 2013 COL
9204 9204 Chris Rusin 26 rusinch01 2013 CHC NL 1.853404073 0.34 P 3 1 CHC   2012 2014 COL
9214 9214 Zac Rosscup 25 rosscza01 2013 CHC NL 0.138458692 0.055 P 0 1 CHC   2013 2017 COL
9269 9269 Simon Castro 25 castrsi01 2013 CHW AL 0.150210538 0.075 P 0 1 CHW   2013 2013 COL
9333 9333 Ryan Raburn 32 raburry01 2013 CLE AL 2.614908854 2.18 RF, LF, 2B, P 11 1 CLE DET 2013 2015 COL
9335 9335 Drew Stubbs 28 stubbdr01 2013 CLE AL 4.540690104 0.905 RF, CF 10 1 CLE CIN 2013 2013 COL
9341 9341 Bryan Shaw 25 shawbr01 2013 CLE AL 2.385715282 0.875 P 6 1 CLE ARI 2013 2017 COL
9457 9457 Brandon Barnes 27 barnebr02 2013 HOU AL 4.305972639 1.125 CF, RF, LF 9 1 HOU   2012 2013 COL
9467 9467 Jordan Lyles 22 lylesjo01 2013 HOU AL 4.275610032 -0.43 P 4 1 HOU   2011 2013 COL
9509 9509 Greg Holland 27 hollagr01 2013 KCR AL 2.748049992 3.105 P 13 1 KCR   2010 2015 COL
9653 9653 Mike Dunn 28 dunnmi01 2013 MIA NL 2.385315925 1.26 P 7 1 FLA ATL 2011 2016 COL
9778 9778 Pedro Hernandez 24 hernape02 2013 MIN AL 1.543459282 -0.55 P 0 1 MIN CHW 2013 2013 COL
9792 9792 LaTroy Hawkins 40 hawkila01 2013 NYM NL 2.312983255 0.92 P 6 1 NYM ANA 2013 2013 COL
9828 9828 Collin McHugh 26 mchugco01 2013 NYM NL 0.132488971 -0.235 P 0 1 NYM   2012 2013 COL
9856 9856 Boone Logan 28 loganbo02 2013 NYY AL 1.310213659 0.35 P 3 1 NYY ATL 2010 2013 COL
9918 9918 Brett Anderson 25 anderbr04 2013 OAK AL 1.273589793 -0.165 P 2 1 OAK   2009 2013 COL
9939 9939 Kyle Kendrick 28 kendrky01 2013 PHI NL 5.216433597 1.295 P 12 1 PHI   2007 2014 COL
10012 10012 Justin Morneau 32 morneju01 2013 PIT NL 0.921907395 0.04 1B 2 2 PIT MIN 2013 2013 COL
10032 10032 Michael McKenry 28 mckenmi01 2013 PIT NL 1.222529371 -0.66 C 0 1 PIT COL 2011 2013 COL
10048 10048 Alexi Amarista 24 amarial01 2013 SDP NL 3.969581749 0.05 CF, 2B, SS, LF, 3B 6 1 SDP ANA 2012 2016 COL
10190 10190 Daniel Descalso 26 descada01 2013 STL NL 3.561578045 0.075 SS, 2B, 3B 6 1 STL   2010 2014 COL
10215 10215 Mitchell Boggs 29 boggsmi01 2013 STL NL 0.441147147 -1.015 P 0 1 STL   2008 2013 COL
10238 10238 Jake McGee 26 mcgeeja01 2013 TBR AL 2.152581855 0.352822086 P 4 1 TBD   2010 2015 COL
10309 10309 Jose Reyes 30 reyesjo01 2013 TOR AL 3.967673469 2.525 SS 13 1 TOR FLA 2013 2015 COL
10348 10348 Aaron Laffey 28 laffeaa01 2013 TOR AL 0.074062723 -0.075 P 0 2 TOR NYM 2013 2013 COL
10431 10431 Ryan Wheeler 23 wheelry01 2012 ARI NL 1.194737753 -0.23 3B, 1B 1 1 ARI   2012 2012 COL
10560 10560 Franklin Morales 26 moralfr01 2012 BOS AL 2.433420925 0.5 P 5 1 BOS COL 2011 2013 COL
10621 10621 Chris Volstad 25 volstch01 2012 CHC NL 3.292032067 -0.78 P 2 1 CHC FLA 2012 2012 COL
10626 10626 Chris Rusin 25 rusinch01 2012 CHC NL 0.881909132 -0.055 P 1 1 CHC   2012 2014 COL
10629 10629 Manny Corpas 29 corpama01 2012 CHC NL 1.446305676 -0.415 P 1 1 CHC COL 2012 2012 COL
10883 10883 Wilton Lopez 28 lopezwi01 2012 HOU NL 2.447407914 1.845 P 9 1 HOU   2009 2012 COL
10886 10886 Jordan Lyles 21 lylesjo01 2012 HOU NL 4.063025097 0.29 P 6 1 HOU   2011 2013 COL

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