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,281 rows where prev_franch = "CLE"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, lg_ID, stint_ID, franch_id, next_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
46 46 Josh Donaldson 33 donaljo02 2019 ATL NL 6.456566347 5.53754717 3B 28 1 ATL CLE 2019 2019  
63 63 Josh Tomlin 34 tomlijo01 2019 ATL NL 2.062272326 0.483962264 P 5 1 ATL CLE 2019 2019  
248 248 Carlos Gonzalez 33 gonzaca01 2019 CHC NL 0.495467225 -0.371886792 LF, RF 0 2 CHC CLE 2019 2019  
263 263 Evan Marshall 29 marshev01 2019 CHW AL 1.92106139 1.097088608 P 6 1 CHW CLE 2019 2019  
297 297 Yonder Alonso 32 alonsyo01 2019 CHW AL 2.460784314 -1.194493671 1B 0 1 CHW CLE 2019 2019 COL
322 322 Trevor Bauer 28 bauertr01 2019 CIN NL 1.595575799 0.142641509 P 3 2 CIN CLE 2019 2019  
414 414 Bryan Shaw 31 shawbr01 2019 COL NL 2.187203995 0.178301887 P 4 1 COL CLE 2018 2019  
507 507 Michael Brantley 32 brantmi02 2019 HOU AL 5.841726619 4.340377358 LF, RF 20 1 HOU CLE 2019 2019  
526 526 Joe Smith 35 smithjo05 2019 HOU AL 0.671687879 0.641886792 P 3 1 HOU CLE 2018 2019  
650 650 Cody Allen 30 allenco01 2019 LAA AL 0.606837733 -0.438113208 P 0 1 ANA CLE 2019 2019  
734 734 Josh Smith 29 smithjo08 2019 MIA NL 0.068004527 -0.101886792 P 0 2 FLA CLE 2019 2019  
778 778 Jesus Aguilar 29 aguilje01 2019 MIL NL 2.583475009 -0.341320755 1B, 3B 3 1 MIL CLE 2017 2019 TBD
847 847 Austin Adams 32 adamsau01 2019 MIN AL 0.039534947 -0.117169811 P 0 1 MIN CLE 2019 2019 DET
885 885 Rajai Davis 38 davisra01 2019 NYM NL 0.238356164 0.0 LF, RF 0 1 NYM CLE 2019 2019  
1022 1022 Brad Miller 29 millebr02 2019 PHI NL 1.216852966 0.636792453 3B, LF, 2B, RF, SS 4 2 PHI CLE 2019 2019  
1085 1085 Erik Gonzalez 27 gonzaer01 2019 PIT NL 1.438016529 0.173207547 SS, 3B, LF, CF 3 1 PIT CLE 2019 2019  
1086 1086 Melky Cabrera 34 cabreme01 2019 PIT NL 3.904614325 -0.978113208 RF, LF 3 1 PIT CLE 2019 2019  
1135 1135 Francisco Mejia 23 mejiafr01 2019 SDP NL 2.450994318 0.611320755 C, LF 5 1 SDP CLE 2018 2019  
1177 1177 Edwin Encarnacion 36 encared01 2019 SEA AL 2.763270689 1.844150943 1B, 2B 9 1 SEA CLE 2019 2019 NYY
1228 1228 Shawn Armstrong 28 armstsh01 2019 SEA AL 0.11193408 -0.219056604 P 0 1 SEA CLE 2018 2019 BAL
1328 1328 Andrew Miller 34 millean01 2019 STL NL 2.210460624 -0.198679245 P 3 1 STL CLE 2019 2019  
1356 1356 Yandy Diaz 27 diazya01 2019 TBR AL 3.244755245 1.823773585 3B, 1B 10 1 TBD CLE 2019 2019  
1499 1499 Neil Ramirez 30 ramirne01 2019 TOR AL 0.248265563 -0.061132075 P 0 2 TOR CLE 2019 2019  
1526 1526 Yan Gomes 31 gomesya01 2019 WSN NL 3.535732736 1.034150943 C, 1B 8 1 WSN CLE 2019 2019  
1904 1904 Kyle Crockett 26 crockky01 2018 CIN NL 0.315102363 -0.045 P 0 1 CIN CLE 2018 2018  
2004 2004 Bryan Shaw 30 shawbr01 2018 COL NL 1.62385713 -0.680797546 P 1 1 COL CLE 2018 2019  
2057 2057 Zach McAllister 30 mcallza01 2018 DET AL 0.091118237 -0.235 P 0 2 DET CLE 2018 2018  
2093 2093 Joe Smith 34 smithjo05 2018 HOU AL 1.375970171 0.305 P 3 1 HOU CLE 2018 2019  
2148 2148 Abraham Almonte 29 almonab01 2018 KCR AL 1.449759974 -0.6 CF, RF, LF 0 1 KCR CLE 2018 2018 ARI
2197 2197 Oliver Drake 31 drakeol01 2018 LAA AL 0.193285254 -0.01 P 0 3 ANA CLE 2018 2018 TOR
2321 2321 Jesus Aguilar 28 aguilje01 2018 MIL NL 5.549957735 3.135644172 1B, 3B 18 1 MIL CLE 2017 2019 TBD
2365 2365 Boone Logan 33 loganbo02 2018 MIL NL 0.270216863 -0.218650307 P 0 1 MIL CLE 2018 2018  
2422 2422 Matt Belisle 38 belisma01 2018 MIN AL 0.543179036 -0.545 P 0 2 MIN CLE 2018 2018  
2443 2443 Jay Bruce 31 bruceja01 2018 NYM NL 3.582819986 -0.16 RF, 1B 4 1 NYM CLE 2018 2018 SEA
2518 2518 George Kontos 33 kontoge01 2018 NYY AL 0.032074076 0.09 P 0 3 NYY CLE 2018 2018  
2586 2586 Carlos Santana 32 santaca01 2018 PHI NL 6.748115147 1.765 1B, 3B 15 1 PHI CLE 2018 2018 CLE
2711 2711 Francisco Mejia 22 mejiafr01 2018 SDP NL 0.583420049 -0.08 C 1 2 SDP CLE 2018 2019  
2750 2750 Shawn Armstrong 27 armstsh01 2018 SEA AL 0.455194944 0.42 P 2 1 SEA CLE 2018 2019 BAL
2828 2828 Austin Jackson 31 jacksau01 2018 SFG NL 1.650284532 -1.1 CF, LF 0 1 SFG CLE 2018 2018 NYM
2924 2924 Adam Moore 34 mooread01 2018 TBR AL 0.187915114 -0.04 C 0 1 TBD CLE 2018 2018  
3037 3037 Gio Urshela 26 urshegi01 2018 TOR AL 0.440846001 -0.15 3B, SS 0 1 TOR CLE 2018 2018 NYY
3212 3212 Ubaldo Jimenez 33 jimenub01 2017 BAL AL 3.90155539 -0.625 P 4 1 BAL CLE 2014 2017  
3411 3411 Blake Wood 31 woodbl01 2017 CIN NL 1.544169598 -0.07 P 2 1 CIN CLE 2016 2017 ANA
3826 3826 Jesus Aguilar 27 aguilje01 2017 MIL NL 3.099845334 1.12 1B, 3B 8 1 MIL CLE 2017 2019 TBD
3876 3876 Chris Gimenez 34 gimench01 2017 MIN AL 2.092352092 1.055 C, 1B, P, LF, 3B 6 1 MIN CLE 2017 2017 CHC
4034 4034 Rajai Davis 36 davisra01 2017 OAK AL 3.117155497 0.3 CF, LF, RF 5 1 OAK CLE 2017 2017 BOS
4429 4429 Michael Martinez 34 martimi02 2017 TBR AL 0.274746815 -0.345 2B, 3B, CF, LF, P, SS 0 2 TBD CLE 2017 2017  
4448 4448 Mike Napoli 35 napolmi01 2017 TEX AL 4.616015753 -0.67 1B 5 1 TEX CLE 2017 2017  
4519 4519 T.J. House 27 housetj01 2017 TOR AL 0.032736737 0.005 P 0 1 TOR CLE 2017 2017  
4716 4716 Ubaldo Jimenez 32 jimenub01 2016 BAL AL 4.008006218 0.645 P 8 1 BAL CLE 2014 2017  
4730 4730 Tommy Hunter 29 hunteto02 2016 BAL AL 0.351114424 0.3 P 1 2 BAL CLE 2016 2016 TBD
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
4886 4886 Jerry Sands 28 sandsje01 2016 CHW AL 0.550662956 -0.305 1B, LF, RF 0 1 CHW CLE 2016 2016  
4892 4892 JB Shuck 29 shuckja01 2016 CHW AL 2.288099525 -1.61 CF, LF, RF, P 0 1 CHW CLE 2015 2016 FLA
4902 4902 Brandon Phillips 35 phillbr01 2016 CIN NL 5.873417722 0.895 2B 12 1 CIN CLE 2006 2016 ATL
4909 4909 Blake Wood 30 woodbl01 2016 CIN NL 2.569764349 0.5 P 5 1 CIN CLE 2016 2017 ANA
4921 4921 Tyler Holt 27 holtty01 2016 CIN NL 2.091902202 -0.805 CF, RF, LF, P 1 1 CIN CLE 2015 2016  
5016 5016 Ryan Raburn 35 raburry01 2016 COL NL 2.517036786 -0.44 LF, 1B, RF 2 1 COL CLE 2016 2016 WSN
5084 5084 Mike Aviles 35 avilemi01 2016 DET AL 1.719855832 -1.323167702 RF, 2B, 3B, LF, SS, CF 0 1 DET CLE 2016 2016 FLA
5197 5197 Joe Smith 32 smithjo05 2016 LAA AL 1.271562868 0.115 P 2 1 ANA CLE 2014 2016 CHC
5268 5268 Zach Walters 26 walteza01 2016 LAD NL 0.049606569 -0.16 1B, LF, RF 0 1 LAD CLE 2016 2016  
5307 5307 Chris Johnson 31 johnsch05 2016 MIA NL 2.632284683 -0.880434783 1B, 3B, LF 1 1 FLA CLE 2016 2016  
5512 5512 Anthony Swarzak 30 swarzan01 2016 NYY AL 0.828919222 -0.195 P 1 1 NYY CLE 2016 2016 CHW
5560 5560 Ross Detwiler 30 detwiro01 2016 OAK AL 1.247471357 0.15 P 2 2 OAK CLE 2016 2016 SEA
5625 5625 Frank Herrmann 32 herrmfr01 2016 PHI NL 0.408535915 -0.65 P 0 1 PHI CLE 2016 2016  
5757 5757 Franklin Gutierrez 33 gutiefr01 2016 SEA AL 2.646565624 0.66 RF, LF 6 1 SEA CLE 2009 2016 LAD
5853 5853 Brandon Moss 32 mossbr01 2016 STL NL 4.563676446 1.05 1B, LF, RF 9 1 STL CLE 2015 2016 KCR
5920 5920 Ryan Webb 30 webbry01 2016 TBR AL 0.372862659 -0.05 P 0 1 TBD CLE 2016 2016  
6004 6004 Gavin Floyd 33 floydga01 2016 TOR AL 1.14747889 0.205 P 2 1 TOR CLE 2016 2016  
6146 6146 Michael Bourn 32 bournmi01 2015 ATL NL 1.586811645 -0.25 CF, LF, RF 2 2 ATL CLE 2015 2015 ARI
6161 6161 Nick Swisher 34 swishni01 2015 ATL NL 1.515608558 -0.275 LF, 1B, RF 1 2 ATL CLE 2015 2015  
6188 6188 Ubaldo Jimenez 31 jimenub01 2015 BAL AL 5.250521369 2.52 P 15 1 BAL CLE 2014 2017  
6353 6353 JB Shuck 28 shuckja01 2015 CHW AL 1.582602944 0.36 RF, CF, LF 3 1 CHW CLE 2015 2016 FLA
6375 6375 Brandon Phillips 34 phillbr01 2015 CIN NL 6.167264038 2.93 2B, SS 16 1 CIN CLE 2006 2016 ATL
6407 6407 Tyler Holt 26 holtty01 2015 CIN NL 0.128690903 -0.03 CF, LF, RF 0 2 CIN CLE 2015 2016  
6499 6499 Drew Stubbs 30 stubbdr01 2015 COL NL 1.149913043 0.13 CF, LF, RF 2 1 COL CLE 2014 2015 TEX
6501 6501 Rafael Betancourt 40 betanra01 2015 COL NL 1.233927188 -0.015 P 2 1 COL CLE 2009 2015  
6676 6676 Joe Smith 31 smithjo05 2015 LAA AL 2.533645471 0.74 P 6 1 ANA CLE 2014 2016 CHC
6687 6687 David Murphy 33 murphda07 2015 LAA AL 1.574396783 -0.205 LF, RF, P 2 2 ANA CLE 2015 2015  
6707 6707 Vinnie Pestano 30 pestavi01 2015 LAA AL 0.338890803 -0.29 P 0 1 ANA CLE 2014 2015  
7021 7021 Scott Kazmir 31 kazmisc01 2015 OAK AL 3.103475362 2.805 P 12 1 OAK CLE 2014 2015 HOU
7207 7207 Marc Rzepczynski 29 rzepcma01 2015 SDP NL 0.509521895 -0.39 P 0 2 SDP CLE 2015 2015 OAK
7218 7218 Franklin Gutierrez 32 gutiefr01 2015 SEA AL 1.795283328 2.34 LF, RF 10 1 SEA CLE 2009 2016 LAD
7227 7227 Mark Lowe 32 lowema01 2015 SEA AL 1.165182819 1.275 P 5 1 SEA CLE 2015 2015 TOR
7327 7327 Brandon Moss 31 mossbr01 2015 STL NL 1.513653647 0.415 RF, 1B, LF 4 2 STL CLE 2015 2016 KCR
7425 7425 Chris Gimenez 32 gimench01 2015 TEX AL 1.063098135 0.695 C 4 1 TEX CLE 2015 2015 CLE
7600 7600 Andy Marte 30 martean01 2014 ARI NL 0.161111111 -0.13 3B 0 1 ARI CLE 2014 2014  
7670 7670 Ubaldo Jimenez 30 jimenub01 2014 BAL AL 3.320282623 0.065 P 5 1 BAL CLE 2014 2017  
7685 7685 Preston Guilmet 26 guilmpr01 2014 BAL AL 0.248591603 -0.05 P 0 1 BAL CLE 2014 2014 TBD
7686 7686 Cord Phelps 27 phelpco01 2014 BAL AL 0.02848723 -0.1   0 1 BAL CLE 2014 2014  
7723 7723 Grady Sizemore 31 sizemgr01 2014 BOS AL 1.91588785 -0.185 LF, CF, RF 2 1 BOS CLE 2014 2014 PHI
7752 7752 Luis Valbuena 28 valbulu01 2014 CHC NL 5.502254596 2.435 3B, 2B 14 1 CHC CLE 2012 2014 HOU
7848 7848 Brandon Phillips 33 phillbr01 2014 CIN NL 5.145244444 1.52 2B 12 1 CIN CLE 2006 2016 ATL
7879 7879 Jack Hannahan 34 hannaja01 2014 CIN NL 0.515555556 -0.32 1B 0 1 CIN CLE 2013 2014  
7936 7936 Drew Stubbs 29 stubbdr01 2014 COL NL 4.216735254 2.655 CF 13 1 COL CLE 2014 2015 TEX
8004 8004 Ezequiel Carrera 27 carreez01 2014 DET AL 0.685556995 0.41 CF, LF 2 1 DET CLE 2014 2014 TOR
8052 8052 Matt Albers 31 alberma01 2014 HOU AL 0.347570089 0.36 P 2 1 HOU CLE 2014 2014 CHW
8136 8136 Joe Smith 30 smithjo05 2014 LAA AL 2.682656409 1.75 P 9 1 ANA CLE 2014 2016 CHC
8152 8152 Vinnie Pestano 29 pestavi01 2014 LAA AL 0.258723514 0.245 P 1 2 ANA CLE 2014 2015  
8163 8163 Rich Hill 34 hillri01 2014 LAA AL 0.0 0.0 P 0 1 ANA CLE 2014 2014 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
);