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

3,053 rows where next_franch = "CLE"

✎ 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
308 308 Yasiel Puig 28 puigya01 2019 CIN NL 4.169395018 0.820188679 RF 8 1 CIN LAD 2019 2019 CLE
1128 1128 Franmil Reyes 23 reyesfr01 2019 SDP NL 3.645596591 0.67245283 RF 7 1 SDP   2018 2019 CLE
1163 1163 Logan Allen 22 allenlo01 2019 SDP NL 0.681740409 -0.219056604 P 0 1 SDP   2019 2019 CLE
1167 1167 Phil Maton 26 matonph01 2019 SDP NL 0.58532255 -0.397358491 P 0 1 SDP   2017 2019 CLE
1380 1380 Hunter Wood 25 woodhu01 2019 TBR AL 0.728424089 0.336226415 P 2 1 TBD   2017 2019 CLE
1400 1400 Andrew Velazquez 24 velazan01 2019 TBR AL 0.113189136 -0.198679245 3B, 2B, CF, LF 0 1 TBD   2018 2019 CLE
1649 1649 Ryan Flaherty 31 flahery01 2018 ATL NL 1.782204964 -0.61 3B, 1B, 2B 1 1 ATL BAL 2018 2018 CLE
1753 1753 Hanley Ramirez 34 ramirha01 2018 BOS AL 1.800382044 -0.005 1B 3 1 BOS LAD 2015 2018 CLE
1816 1816 Mike Freeman 30 freemmi01 2018 CHC NL 0.009602649 -0.099386503 2B 0 1 CHC LAD 2017 2018 CLE
1984 1984 Carlos Gonzalez 32 gonzaca01 2018 COL NL 5.002909464 1.073374233 RF 11 1 COL OAK 2009 2018 CLE
2022 2022 Leonys Martin 30 martile01 2018 DET AL 3.242595674 2.0 CF, RF 10 1 DET CHC 2018 2018 CLE
2099 2099 James Hoyt 31 hoytja01 2018 HOU AL 0.005070544 0.005 P 0 1 HOU   2016 2018 CLE
2287 2287 Nick Wittgren 27 wittgni01 2018 MIA NL 0.88222086 0.311925466 P 2 1 FLA   2016 2018 CLE
2359 2359 Brad Miller 28 millebr02 2018 MIL NL 0.784446323 -0.094417178 1B, 2B, SS 1 2 MIL TBD 2018 2018 CLE
2363 2363 Oliver Drake 31 drakeol01 2018 MIL NL 0.311714452 -0.029815951 P 0 1 MIL BAL 2017 2018 CLE
2439 2439 Kevin Plawecki 27 plaweke01 2018 NYM NL 2.749144422 0.625 C, 1B 6 1 NYM   2015 2018 CLE
2516 2516 A.J. Cole 26 coleaj01 2018 NYY AL 0.885545188 -0.13 P 1 2 NYY WSN 2018 2018 CLE
2586 2586 Carlos Santana 32 santaca01 2018 PHI NL 6.748115147 1.765 1B, 3B 15 1 PHI CLE 2018 2018 CLE
2657 2657 Jordan Luplow 24 luplojo01 2018 PIT NL 1.038775865 0.191180124 LF, RF, CF 2 1 PIT   2017 2018 CLE
2661 2661 Max Moroff 25 morofma01 2018 PIT NL 0.675708572 0.005031056 2B, SS 1 1 PIT   2016 2018 CLE
2674 2674 George Kontos 33 kontoge01 2018 PIT NL 0.689898937 -0.387391304 P 0 1 PIT SFG 2017 2018 CLE
2689 2689 Franmil Reyes 22 reyesfr01 2018 SDP NL 2.866805411 1.385 RF 8 1 SDP   2018 2019 CLE
2698 2698 Adam Cimber 27 cimbead01 2018 SDP NL 1.452477574 0.775 P 4 1 SDP   2018 2018 CLE
2700 2700 Brad Hand 28 handbr01 2018 SDP NL 1.889043144 0.285 P 4 1 SDP FLA 2016 2018 CLE
2705 2705 Phil Maton 25 matonph01 2018 SDP NL 1.344582087 0.155 P 2 1 SDP   2017 2019 CLE
2779 2779 Marc Rzepczynski 32 rzepcma01 2018 SEA AL 0.240219777 -0.485 P 0 1 SEA WSN 2017 2018 CLE
2892 2892 Jake Bauers 22 bauerja01 2018 TBR AL 3.645553216 0.625 1B, LF, RF 7 1 TBD   2018 2018 CLE
2907 2907 Hunter Wood 24 woodhu01 2018 TBR AL 1.11023646 0.42 P 3 1 TBD   2017 2019 CLE
2915 2915 Andrew Velazquez 23 velazan01 2018 TBR AL 0.112749069 0.28 3B, 2B, CF, SS, LF, RF 1 1 TBD   2018 2019 CLE
2998 2998 Tyler Clippard 33 clippty01 2018 TOR AL 2.436161162 0.91 P 6 1 TOR HOU 2018 2018 CLE
3003 3003 Josh Donaldson 32 donaljo02 2018 TOR AL 1.523793787 0.67 3B, 1B 4 1 TOR OAK 2015 2018 CLE
3079 3079 Jefry Rodriguez 24 rodrije01 2018 WSN NL 1.43078161 -0.21 P 1 1 WSN   2018 2018 CLE
3142 3142 Adam Rosales 34 rosalad01 2017 ARI NL 0.878787879 -0.375 SS, 3B, 2B, 1B, LF 0 2 ARI OAK 2017 2017 CLE
3255 3255 Hanley Ramirez 33 ramirha01 2017 BOS AL 5.079018211 -0.38 1B 7 1 BOS LAD 2015 2018 CLE
3284 3284 Ben Taylor 24 taylobe10 2017 BOS AL 0.500441264 -0.09 P 0 1 BOS   2017 2017 CLE
3285 3285 Rajai Davis 36 davisra01 2017 BOS AL 0.349010293 -0.125 CF, LF, RF 0 2 BOS OAK 2017 2017 CLE
3331 3331 Mike Freeman 29 freemmi01 2017 CHC NL 0.263947413 -0.105 SS, 1B, 2B, 3B, P 0 3 CHC LAD 2017 2018 CLE
3490 3490 Carlos Gonzalez 31 gonzaca01 2017 COL NL 5.281718963 -0.15 RF 8 1 COL OAK 2009 2018 CLE
3589 3589 James Hoyt 30 hoytja01 2017 HOU AL 1.285617961 0.365 P 3 1 HOU   2016 2018 CLE
3644 3644 Melky Cabrera 32 cabreme01 2017 KCR AL 2.300666667 -0.825 LF, RF 1 2 KCR CHW 2017 2017 CLE
3788 3788 Nick Wittgren 26 wittgni01 2017 MIA NL 1.168425945 0.155 P 2 1 FLA   2016 2018 CLE
3836 3836 Oliver Drake 30 drakeol01 2017 MIL NL 1.468846256 0.33 P 3 2 MIL BAL 2017 2018 CLE
3882 3882 Matt Belisle 37 belisma01 2017 MIN AL 2.261301122 0.35 P 4 1 MIN WSN 2017 2017 CLE
3892 3892 Craig Breslow 36 breslcr01 2017 MIN AL 0.700893588 -0.095 P 1 1 MIN FLA 2017 2017 CLE
3916 3916 Jay Bruce 30 bruceja01 2017 NYM NL 4.445508982 2.405 RF, 1B 13 1 NYM CIN 2016 2017 CLE
3936 3936 Kevin Plawecki 26 plaweke01 2017 NYM NL 1.170915312 0.325 C, 1B, P 3 1 NYM   2015 2018 CLE
3955 3955 Neil Ramirez 28 ramirne01 2017 NYM NL 0.486290724 -0.21 P 0 2 NYM SFG 2017 2017 CLE
4138 4138 Max Moroff 24 morofma01 2017 PIT NL 1.396869087 0.6 2B, SS, 3B 4 1 PIT   2016 2018 CLE
4144 4144 George Kontos 32 kontoge01 2017 PIT NL 0.49972717 0.47 P 2 2 PIT SFG 2017 2018 CLE
4163 4163 Jordan Luplow 23 luplojo01 2017 PIT NL 0.868054361 -0.42 RF, LF 0 1 PIT   2017 2018 CLE
4173 4173 Brad Hand 27 handbr01 2017 SDP NL 3.183267339 2.345 P 12 1 SDP FLA 2016 2018 CLE
4195 4195 Phil Maton 24 matonph01 2017 SDP NL 1.367285749 -0.135 P 2 1 SDP   2017 2019 CLE
4242 4242 Yonder Alonso 30 alonsyo01 2017 SEA AL 1.41716892 0.49 1B 3 2 SEA OAK 2017 2017 CLE
4245 4245 Marc Rzepczynski 31 rzepcma01 2017 SEA AL 1.21008581 0.1 P 2 1 SEA WSN 2017 2018 CLE
4272 4272 Evan Marshall 27 marshev01 2017 SEA AL 0.158819447 -0.18 P 0 1 SEA ARI 2017 2017 CLE
4420 4420 Hunter Wood 23 woodhu01 2017 TBR AL 0.005303854 0.005 P 0 1 TBD   2017 2019 CLE
4483 4483 Josh Donaldson 31 donaljo02 2017 TOR AL 4.692985318 5.045 3B, SS 22 1 TOR OAK 2015 2018 CLE
4502 4502 Joe Smith 33 smithjo05 2017 TOR AL 1.203146251 0.905 P 4 1 TOR CHC 2017 2017 CLE
4535 4535 Jeff Beliveau 30 belivje01 2017 TOR AL 0.370162351 -0.26 P 0 1 TOR TBD 2017 2017 CLE
4566 4566 Oliver Perez 35 perezol01 2017 WSN NL 1.042953554 0.35 P 3 1 WSN HOU 2016 2017 CLE
4675 4675 Alexi Ogando 32 ogandal01 2016 ATL NL 0.835564506 -0.015093168 P 1 1 ATL BOS 2016 2016 CLE
4756 4756 Hanley Ramirez 32 ramirha01 2016 BOS AL 5.714285714 2.915 1B 15 1 BOS LAD 2015 2018 CLE
4784 4784 Michael Martinez 33 martimi02 2016 BOS AL 0.064516129 -0.02 2B, CF, LF, RF, SS, 3B 0 2 BOS CLE 2016 2016 CLE
4868 4868 Austin Jackson 29 jacksau01 2016 CHW AL 1.927320347 -0.105 CF 2 1 CHW CHC 2016 2016 CLE
4999 4999 Carlos Gonzalez 30 gonzaca01 2016 COL NL 6.213934565 2.48 RF 15 1 COL OAK 2009 2018 CLE
5010 5010 Boone Logan 31 loganbo02 2016 COL NL 1.774448591 0.69 P 4 1 COL NYY 2014 2016 CLE
5014 5014 Brandon Barnes 30 barnebr02 2016 COL NL 1.071707069 0.055 LF, CF, RF 2 1 COL HOU 2014 2016 CLE
5118 5118 James Hoyt 29 hoytja01 2016 HOU AL 0.550522379 -0.13 P 0 1 HOU   2016 2018 CLE
5295 5295 Nick Wittgren 25 wittgni01 2016 MIA NL 1.501813667 0.548385093 P 4 1 FLA   2016 2018 CLE
5460 5460 Kevin Plawecki 25 plaweke01 2016 NYM NL 1.512085635 0.145 C 2 1 NYM   2015 2018 CLE
5461 5461 Jay Bruce 29 bruceja01 2016 NYM NL 1.872582873 -0.125 RF, CF 2 2 NYM CIN 2016 2017 CLE
5488 5488 Andrew Miller 31 millean01 2016 NYY AL 1.87022512 2.115 P 9 1 NYY BAL 2015 2016 CLE
5509 5509 Nick Goody 24 goodyni01 2016 NYY AL 0.638076806 0.045 P 1 1 NYY   2015 2016 CLE
5516 5516 Tyler Olson 26 olsonty01 2016 NYY AL 0.066415402 -0.015 P 0 1 NYY SEA 2016 2016 CLE
5543 5543 Coco Crisp 36 crispco01 2016 OAK AL 4.196732244 0.115 LF, CF 6 1 OAK KCR 2010 2016 CLE
5670 5670 Max Moroff 23 morofma01 2016 PIT NL 0.01952862 -0.025   0 1 PIT   2016 2018 CLE
5691 5691 Brad Hand 26 handbr01 2016 SDP NL 3.214542896 1.525 P 9 1 SDP FLA 2016 2018 CLE
5790 5790 Daniel Robertson 30 roberda09 2016 SEA AL 0.196388262 -0.225 LF, RF, CF 0 1 SEA ANA 2016 2016 CLE
5899 5899 Brandon Guyer 30 guyerbr01 2016 TBR AL 2.398604883 0.72 LF, CF, RF 5 1 TBD   2011 2016 CLE
5982 5982 Josh Donaldson 30 donaljo02 2016 TOR AL 6.548387097 7.575 3B 31 1 TOR OAK 2015 2018 CLE
5984 5984 Edwin Encarnacion 33 encared01 2016 TOR AL 6.567096774 3.88 1B 20 1 TOR CIN 2009 2016 CLE
6051 6051 Oliver Perez 34 perezol01 2016 WSN NL 1.285176312 0.25 P 3 1 WSN HOU 2016 2017 CLE
6165 6165 Chris Johnson 30 johnsch05 2015 ATL NL 1.647842862 -0.445 3B, 1B 1 1 ATL ARI 2013 2015 CLE
6183 6183 Ross Detwiler 29 detwiro01 2015 ATL NL 0.446778989 -0.5 P 0 2 ATL TEX 2015 2015 CLE
6261 6261 Hanley Ramirez 31 ramirha01 2015 BOS AL 4.014810045 -1.245 LF, 3B 2 1 BOS LAD 2015 2018 CLE
6328 6328 Tommy Hunter 28 hunteto02 2015 CHC NL 0.390571443 -0.225 P 0 2 CHC BAL 2015 2015 CLE
6473 6473 Carlos Gonzalez 29 gonzaca01 2015 COL NL 6.132869565 2.95 RF 17 1 COL OAK 2009 2018 CLE
6489 6489 Boone Logan 30 loganbo02 2015 COL NL 1.226248611 0.435 P 3 1 COL NYY 2014 2016 CLE
6504 6504 Brandon Barnes 29 barnebr02 2015 COL NL 2.834434783 -0.83 LF, RF, CF 2 1 COL HOU 2014 2016 CLE
6530 6530 Rajai Davis 34 davisra01 2015 DET AL 3.499673842 1.287950311 CF, LF, RF 9 1 DET TOR 2014 2015 CLE
6552 6552 Tom Gorzelanny 32 gorzeto01 2015 DET AL 1.042643431 -0.321987578 P 1 1 DET MIL 2015 2015 CLE
6654 6654 Joba Chamberlain 29 chambjo03 2015 KCR AL 0.099153602 -0.055 P 0 2 KCR DET 2015 2015 CLE
6685 6685 Collin Cowgill 29 cowgico01 2015 LAA AL 0.719168901 0.29 LF, CF, RF 2 1 ANA NYM 2013 2015 CLE
6925 6925 Kevin Plawecki 24 plaweke01 2015 NYM NL 2.583117556 1.015 C 7 1 NYM   2015 2018 CLE
6931 6931 Juan Uribe 36 uribeju01 2015 NYM NL 1.431727948 0.675 3B, 2B 4 3 NYM ATL 2015 2015 CLE
6973 6973 Andrew Miller 30 millean01 2015 NYY AL 2.413855831 2.195 P 10 1 NYY BAL 2015 2016 CLE
6996 6996 Nick Goody 23 goodyni01 2015 NYY AL 0.107111597 0.015 P 0 1 NYY   2015 2016 CLE
7064 7064 Dan Otero 30 oteroda01 2015 OAK AL 1.271192548 -0.58 P 0 1 OAK SFG 2013 2015 CLE
7066 7066 Coco Crisp 35 crispco01 2015 OAK AL 1.310894309 -0.67 LF 0 1 OAK KCR 2010 2016 CLE
7200 7200 Jon Edwards 27 edwarjo02 2015 SDP NL 0.222010341 -0.04 P 0 2 SDP TEX 2015 2015 CLE

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