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,968 rows where next_franch = "NYY"

✎ 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
1004 1004 Ryan Dull 29 dullry01 2019 OAK AL 0.187516812 -0.40754717 P 0 1 OAK   2015 2019 NYY
1005 1005 Kendrys Morales 36 moralke01 2019 OAK AL 1.190615836 -0.417735849 1B, P 0 1 OAK TOR 2019 2019 NYY
1106 1106 Tyler Lyons 31 lyonsty01 2019 PIT NL 0.197076397 -0.259811321 P 0 1 PIT STL 2019 2019 NYY
1177 1177 Edwin Encarnacion 36 encared01 2019 SEA AL 2.763270689 1.844150943 1B, 2B 9 1 SEA CLE 2019 2019 NYY
1194 1194 Cory Gearrin 33 gearrco01 2019 SEA AL 1.210820441 0.509433962 P 3 1 SEA OAK 2019 2019 NYY
1603 1603 Jake Barrett 26 barreja01 2018 ARI NL 0.17341503 -0.045 P 0 1 ARI   2016 2018 NYY
1702 1702 Zack Britton 30 brittza01 2018 BAL AL 0.508149641 0.165 P 1 1 BAL   2011 2018 NYY
1704 1704 Breyvic Valera 26 valerbr01 2018 BAL AL 0.395608052 0.06 2B, 3B, SS, RF 1 2 BAL LAD 2018 2018 NYY
1716 1716 Nestor Cortes Jr. 23 cortene01 2018 BAL AL 0.152081086 -0.21 P 0 1 BAL   2018 2018 NYY
1961 1961 George Kontos 33 kontoge01 2018 CLE AL 0.083673474 0.03 P 0 2 CLE PIT 2018 2018 NYY
1979 1979 DJ LeMahieu 29 lemahdj01 2018 COL NL 5.767242855 2.549263804 2B 17 1 COL CHC 2012 2018 NYY
1983 1983 Adam Ottavino 32 ottavad01 2018 COL NL 2.889542198 2.251104294 P 11 1 COL STL 2012 2018 NYY
2012 2012 Mike Tauchman 27 tauchmi01 2018 COL NL 0.367277084 -0.49196319 CF, LF, RF 0 1 COL   2017 2018 NYY
2384 2384 Lance Lynn 31 lynnla01 2018 MIN AL 2.867214307 0.555 P 6 1 MIN STL 2018 2018 NYY
2414 2414 David Hale 30 haleda02 2018 MIN AL 0.092550077 -0.2 P 0 2 MIN NYY 2018 2018 NYY
2559 2559 Ryan Dull 28 dullry01 2018 OAK AL 0.657154522 0.18 P 2 1 OAK   2015 2019 NYY
2668 2668 Adeiny Hechavarria 29 hechaad01 2018 PIT NL 0.474004521 -0.105652174 SS, 3B 0 2 PIT TBD 2018 2018 NYY
2730 2730 James Paxton 29 paxtoja01 2018 SEA AL 4.452307489 3.31 P 17 1 SEA   2013 2018 NYY
2766 2766 Cameron Maybin 31 maybica01 2018 SEA AL 0.927617477 -0.185 LF, CF, RF 1 2 SEA FLA 2018 2018 NYY
2783 2783 Andrew McCutchen 31 mccutan01 2018 SFG NL 5.680979479 1.925 RF, LF 15 1 SFG PIT 2018 2018 NYY
2863 2863 Luke Voit 27 voitlu01 2018 STL NL 0.128384131 0.045 1B, RF 0 1 STL   2017 2018 NYY
2986 2986 J.A. Happ 35 happja01 2018 TOR AL 3.291628169 1.69 P 10 1 TOR PIT 2016 2018 NYY
3037 3037 Gio Urshela 26 urshegi01 2018 TOR AL 0.440846001 -0.15 3B, SS 0 1 TOR CLE 2018 2018 NYY
3094 3094 A.J. Cole 26 coleaj01 2018 WSN NL 0.236419913 -0.34 P 0 1 WSN   2015 2018 NYY
3110 3110 Brandon Drury 24 drurybr01 2017 ARI NL 4.739530133 1.38 2B, 3B 11 1 ARI   2015 2017 NYY
3141 3141 Jake Barrett 25 barreja01 2017 ARI NL 0.721521883 -0.305 P 0 1 ARI   2016 2018 NYY
3177 3177 Jace Peterson 27 peterja01 2017 ATL NL 2.115710892 -0.765 LF, 2B, 3B, 1B, SS, RF 1 1 ATL SDP 2015 2017 NYY
3208 3208 Zack Britton 29 brittza01 2017 BAL AL 1.376585751 0.815 P 5 1 BAL   2011 2018 NYY
3341 3341 Todd Frazier 31 frazito01 2017 CHW AL 3.217420103 1.855 3B, 1B 10 1 CHW CIN 2016 2017 NYY
3351 3351 Tommy Kahnle 27 kahnlto01 2017 CHW AL 1.296779511 1.165 P 5 1 CHW COL 2016 2017 NYY
3353 3353 David Robertson 32 roberda08 2017 CHW AL 1.361857592 0.96 P 5 1 CHW NYY 2015 2017 NYY
3479 3479 DJ LeMahieu 28 lemahdj01 2017 COL NL 6.745566166 2.39 2B 18 1 COL CHC 2012 2018 NYY
3500 3500 Adam Ottavino 31 ottavad01 2017 COL NL 1.68348082 0.075 P 3 1 COL STL 2012 2018 NYY
3513 3513 Mike Tauchman 26 tauchmi01 2017 COL NL 0.316507503 -0.245 CF, LF, RF 0 1 COL   2017 2018 NYY
3696 3696 Shane Robinson 32 robinsh01 2017 LAA AL 0.335426305 0.015 RF, CF, LF 1 1 ANA MIN 2016 2017 NYY
3769 3769 Giancarlo Stanton 27 stantmi03 2017 MIA NL 6.768296796 7.575 RF 32 1 FLA   2010 2017 NYY
3834 3834 Neil Walker 31 walkene01 2017 MIL NL 1.485134903 0.62 2B, 1B, 3B 4 2 MIL NYM 2017 2017 NYY
3890 3890 Jaime Garcia 30 garcija02 2017 MIN AL 0.189170962 0.145 P 1 2 MIN ATL 2017 2017 NYY
4025 4025 Sonny Gray 27 grayso01 2017 OAK AL 2.778588405 1.84 P 9 1 OAK   2013 2017 NYY
4054 4054 Ryan Dull 27 dullry01 2017 OAK AL 1.441146685 -0.36 P 1 1 OAK   2015 2019 NYY
4225 4225 James Paxton 28 paxtoja01 2017 SEA AL 3.783256785 3.98 P 17 1 SEA   2013 2018 NYY
4354 4354 Luke Voit 26 voitlu01 2017 STL NL 1.221259976 0.31 1B 3 1 STL   2017 2018 NYY
4487 4487 J.A. Happ 34 happja01 2017 TOR AL 3.888934576 3.105 P 15 1 TOR PIT 2016 2018 NYY
4504 4504 Troy Tulowitzki 32 tulowtr01 2017 TOR AL 2.460032626 0.15 SS 4 1 TOR COL 2015 2017 NYY
4560 4560 A.J. Cole 25 coleaj01 2017 WSN NL 1.434135676 0.675 P 4 1 WSN   2015 2018 NYY
4601 4601 Brandon Drury 23 drurybr01 2016 ARI NL 4.883901451 0.115 LF, RF, 3B, 2B, 1B 7 1 ARI   2015 2017 NYY
4605 4605 Jake Barrett 24 barreja01 2016 ARI NL 1.919968206 0.695 P 5 1 ARI   2016 2018 NYY
4613 4613 Tyler Clippard 31 clippty01 2016 ARI NL 1.296068832 0.325 P 3 1 ARI NYM 2016 2016 NYY
4651 4651 Jace Peterson 26 peterja01 2016 ATL NL 4.025859136 0.28173913 2B, LF, 3B, CF 7 1 ATL SDP 2015 2017 NYY
4709 4709 Zack Britton 28 brittza01 2016 BAL AL 2.757444739 3.35 P 14 1 BAL   2011 2018 NYY
4774 4774 Tommy Layne 31 layneto01 2016 BOS AL 0.671853778 0.335 P 2 1 BOS SDP 2014 2016 NYY
4813 4813 Aroldis Chapman 28 chapmar01 2016 CHC NL 1.008159393 1.245 P 5 2 CHC NYY 2016 2016 NYY
4843 4843 Adam Warren 28 warread01 2016 CHC NL 1.16107685 -0.85 P 0 1 CHC NYY 2016 2016 NYY
4847 4847 Todd Frazier 30 frazito01 2016 CHW AL 6.323129808 3.015 3B, 1B 17 1 CHW CIN 2016 2017 NYY
4856 4856 David Robertson 31 roberda08 2016 CHW AL 2.611518881 1.11 P 7 1 CHW NYY 2015 2017 NYY
4865 4865 Tommy Kahnle 26 kahnlto01 2016 CHW AL 0.772880496 0.345 P 2 1 CHW COL 2016 2017 NYY
4995 4995 DJ LeMahieu 27 lemahdj01 2016 COL NL 6.24343109 4.84 2B 22 1 COL CHC 2012 2018 NYY
5009 5009 Adam Ottavino 30 ottavad01 2016 COL NL 1.0464894 0.78 P 4 1 COL STL 2012 2018 NYY
5028 5028 David Hale 28 haleda02 2016 COL NL 0.040296917 -0.105 P 0 1 COL ATL 2015 2016 NYY
5079 5079 Joe Mantiply 25 mantijo01 2016 DET AL 0.042723683 -0.130807453 P 0 1 DET   2016 2016 NYY
5198 5198 Shane Robinson 31 robinsh01 2016 LAA AL 1.069435216 0.03 LF, CF, RF 2 1 ANA MIN 2016 2017 NYY
5219 5219 Ji-Man Choi 25 choiji01 2016 LAA AL 1.242857143 -0.49 1B, LF 0 1 ANA   2016 2016 NYY
5284 5284 Giancarlo Stanton 26 stantmi03 2016 MIA NL 4.686264397 2.394782609 RF 13 1 FLA   2010 2017 NYY
5336 5336 Chris Carter 29 cartech02 2016 MIL NL 6.493741307 0.935 1B 12 1 MIL HOU 2016 2016 NYY
5538 5538 Ryan Dull 26 dullry01 2016 OAK AL 2.645791831 1.76 P 9 1 OAK   2015 2019 NYY
5542 5542 Sonny Gray 26 grayso01 2016 OAK AL 3.389251478 0.275 P 6 1 OAK   2013 2017 NYY
5553 5553 Billy Butler 30 butlebi03 2016 OAK AL 2.340113371 -0.25 1B 3 1 OAK KCR 2015 2016 NYY
5683 5683 Erik Kratz 36 kratzer01 2016 PIT NL 0.556565657 -0.545 C, 1B, P 0 2 PIT HOU 2016 2016 NYY
5747 5747 James Paxton 27 paxtoja01 2016 SEA AL 3.323950263 2.335 P 12 1 SEA   2013 2018 NYY
5779 5779 Blake Parker 31 parkebl01 2016 SEA AL 0.048036935 0.05 P 0 1 SEA CHC 2016 2016 NYY
5856 5856 Matt Holliday 36 hollima01 2016 STL NL 4.189927082 0.56 LF, 1B 7 1 STL OAK 2009 2016 NYY
5985 5985 J.A. Happ 33 happja01 2016 TOR AL 5.335052624 3.835 P 19 1 TOR PIT 2016 2018 NYY
5986 5986 Troy Tulowitzki 31 tulowtr01 2016 TOR AL 5.089032258 3.175 SS 16 1 TOR COL 2015 2017 NYY
6065 6065 A.J. Cole 24 coleaj01 2016 WSN NL 1.05248151 -0.025 P 1 1 WSN   2015 2018 NYY
6112 6112 Brandon Drury 22 drurybr01 2015 ARI NL 0.575416176 -0.18 3B, 2B, SS 0 1 ARI   2015 2017 NYY
6131 6131 Jace Peterson 25 peterja01 2015 ATL NL 6.072606103 0.7 2B 11 1 ATL SDP 2015 2017 NYY
6192 6192 Zack Britton 27 brittza01 2015 BAL AL 2.515137276 2.27 P 10 1 BAL   2011 2018 NYY
6216 6216 Chris Parmelee 27 parmech01 2015 BAL AL 0.988471178 -0.04 1B, RF 1 1 BAL MIN 2015 2015 NYY
6255 6255 Tommy Layne 30 layneto01 2015 BOS AL 1.473934925 0.355 P 3 1 BOS SDP 2014 2016 NYY
6293 6293 Starlin Castro 25 castrst01 2015 CHC NL 5.757169844 0.7 SS, 2B 11 1 CHC   2010 2015 NYY
6345 6345 David Robertson 30 roberda08 2015 CHW AL 2.633838468 1.125 P 7 1 CHW NYY 2015 2017 NYY
6378 6378 Aroldis Chapman 27 chapmar01 2015 CIN NL 2.586447177 2.625 P 11 1 CIN   2010 2015 NYY
6459 6459 Anthony Swarzak 29 swarzan01 2015 CLE AL 0.271584366 0.0 P 0 1 CLE MIN 2015 2015 NYY
6475 6475 DJ LeMahieu 26 lemahdj01 2015 COL NL 6.253913043 2.125 2B 15 1 COL CHC 2012 2018 NYY
6492 6492 David Hale 27 haleda02 2015 COL NL 2.208096184 -0.06 P 3 1 COL ATL 2015 2016 NYY
6493 6493 Adam Ottavino 29 ottavad01 2015 COL NL 0.363317954 0.61 P 2 1 COL STL 2012 2018 NYY
6751 6751 Ronald Torreyes 22 torrero01 2015 LAD NL 0.08079401 0.11 2B, 3B 0 1 LAD   2015 2015 NYY
6753 6753 Sergio Santos 31 santose01 2015 LAD NL 0.317458845 -0.08 P 0 1 LAD TOR 2015 2015 NYY
6770 6770 Giancarlo Stanton 25 stantmi03 2015 MIA NL 3.252910053 3.64 RF 15 1 FLA   2010 2017 NYY
6815 6815 Donovan Solano 27 solando01 2015 MIA NL 0.961552028 -0.62 3B, SS, 2B 0 1 FLA   2012 2015 NYY
6876 6876 Aaron Hicks 25 hicksaa01 2015 MIN AL 3.771885943 1.75 CF, RF, LF 11 1 MIN   2013 2015 NYY
6950 6950 Eric Young Jr. 30 younger03 2015 NYM NL 0.090108752 -0.025 CF, LF, RF 0 2 NYM ATL 2015 2015 NYY
7016 7016 Sonny Gray 25 grayso01 2015 OAK AL 5.917703975 4.585 P 21 1 OAK   2013 2017 NYY
7034 7034 Billy Butler 29 butlebi03 2015 OAK AL 5.66796748 -0.71 1B 5 1 OAK KCR 2015 2016 NYY
7039 7039 Ike Davis 28 davisik02 2015 OAK AL 2.25398374 -0.33 1B, P 2 1 OAK PIT 2015 2015 NYY
7053 7053 Ryan Dull 25 dullry01 2015 OAK AL 0.594282516 -0.14 P 0 1 OAK   2015 2019 NYY
7230 7230 James Paxton 26 paxtoja01 2015 SEA AL 1.803913813 0.51 P 4 1 SEA   2013 2018 NYY
7246 7246 Tyler Olson 25 olsonty01 2015 SEA AL 0.452553799 -0.265 P 0 1 SEA   2015 2015 NYY
7260 7260 Dustin Ackley 27 ackledu01 2015 SEA AL 1.966262692 -0.87 LF, CF, 2B, 1B, RF 0 1 SEA   2011 2015 NYY
7324 7324 Matt Holliday 35 hollima01 2015 STL NL 2.776702385 0.85 LF 7 1 STL OAK 2009 2016 NYY

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