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

1,813 rows where next_franch = "SDP"

✎ 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
244 244 Carl Edwards Jr. 27 edwarca01 2019 CHC NL 0.496787589 -0.168113208 P 0 1 CHC   2015 2019 SDP
998 998 Nick Martini 29 martini02 2019 OAK AL 0.122841316 -0.010188679 LF, P 0 1 OAK   2018 2019 SDP
1756 1756 Ian Kinsler 36 kinslia01 2018 BOS AL 1.320280166 0.0 2B 2 2 BOS ANA 2018 2018 SDP
1790 1790 Carl Edwards Jr. 26 edwarca01 2018 CHC NL 1.829187586 1.217484663 P 6 1 CHC   2015 2019 SDP
1898 1898 Matt Wisler 25 wislema01 2018 CIN NL 0.283350977 0.19 P 1 2 CIN ATL 2018 2018 SDP
1962 1962 Francisco Mejia 22 mejiafr01 2018 CLE AL 0.036978004 0.005 C 0 1 CLE   2017 2018 SDP
2169 2169 Garrett Richards 30 richaga01 2018 LAA AL 2.257788992 0.555 P 5 1 ANA   2011 2018 SDP
2225 2225 Manny Machado 25 machama01 2018 LAD NL 2.849460581 2.598957055 SS, 3B 11 2 LAD BAL 2018 2018 SDP
2416 2416 Phil Hughes 32 hugheph01 2018 MIN AL 0.25753065 -0.215 P 0 1 MIN NYY 2014 2018 SDP
2546 2546 Nick Martini 28 martini02 2018 OAK AL 1.665383381 1.315 LF, CF, RF 6 1 OAK   2018 2019 SDP
2622 2622 Aaron Loup 30 loupaa01 2018 PHI NL 0.107707356 0.045 P 0 2 PHI TOR 2018 2018 SDP
2761 2761 Adam Warren 30 warread01 2018 SEA AL 0.659577277 0.135 P 1 2 SEA NYY 2018 2018 SDP
2849 2849 Greg Garcia 28 garcigr01 2018 STL NL 2.054146092 0.345 2B, SS, 3B, P 4 1 STL   2014 2018 SDP
3277 3277 Chase d'Arnaud 30 darnach01 2017 BOS AL 0.009184481 0.075 SS, LF, 2B, 3B, 1B, RF 0 2 BOS ATL 2017 2017 SDP
3309 3309 Carl Edwards Jr. 25 edwarca01 2017 CHC NL 2.378912725 1.28 P 7 1 CHC   2015 2019 SDP
3326 3326 Matt Szczur 27 szczuma01 2017 CHC NL 0.224844092 -0.05 LF, CF, RF 0 1 CHC   2014 2017 SDP
3475 3475 Francisco Mejia 21 mejiafr01 2017 CLE AL 0.130693707 -0.2 C 0 1 CLE   2017 2018 SDP
3515 3515 Jordan Lyles 26 lylesjo01 2017 COL NL 1.046075944 -0.38 P 0 1 COL HOU 2014 2017 SDP
3614 3614 Eric Hosmer 27 hosmeer01 2017 KCR AL 6.486333333 4.06 1B 22 1 KCR   2011 2017 SDP
3639 3639 Matt Strahm 25 strahma01 2017 KCR AL 0.993866078 -0.085 P 1 1 KCR   2016 2017 SDP
3641 3641 Travis Wood 30 woodtr01 2017 KCR AL 1.188328956 -0.225 P 1 1 KCR CHC 2017 2017 SDP
3681 3681 Garrett Richards 29 richaga01 2017 LAA AL 0.770210157 0.925 P 4 1 ANA   2011 2018 SDP
3706 3706 Jose Valdez 27 valdejo03 2017 LAA AL 0.021735201 -0.095 P 0 1 ANA DET 2016 2017 SDP
3709 3709 Kirby Yates 30 yateski01 2017 LAA AL 0.028434406 -0.165 P 0 1 ANA NYY 2017 2017 SDP
3786 3786 A.J. Ellis 36 ellisaj01 2017 MIA NL 1.594266442 0.2 C 3 1 FLA PHI 2017 2017 SDP
3852 3852 Tyler Webb 26 webbty01 2017 MIL NL 0.083962031 -0.125 P 0 2 MIL NYY 2017 2017 SDP
3894 3894 Phil Hughes 31 hugheph01 2017 MIN AL 1.368100583 -0.185 P 1 1 MIN NYY 2014 2018 SDP
3906 3906 Tim Melville 27 melviti01 2017 MIN AL 0.097114505 -0.16 P 0 1 MIN CIN 2017 2017 SDP
3974 3974 Chase Headley 33 headlch01 2017 NYY AL 5.370200664 1.915 3B, 1B, 2B 12 1 NYY SDP 2014 2017 SDP
3999 3999 Bryan Mitchell 26 mitchbr01 2017 NYY AL 0.685179264 -0.05 P, 1B 1 1 NYY   2014 2017 SDP
4074 4074 Freddy Galvis 27 galvifr01 2017 PHI NL 6.599279217 1.32 SS, CF, LF 12 1 PHI   2012 2017 SDP
4273 4273 Dillon Overton 25 overtdi01 2017 SEA AL 0.34180707 -0.19 P 0 1 SEA OAK 2017 2017 SDP
4347 4347 Greg Garcia 27 garcigr01 2017 STL NL 2.856172525 0.815 3B, 2B, SS 6 1 STL   2014 2018 SDP
4480 4480 Tyson Ross 30 rossty01 2017 TEX AL 1.307215215 -0.535 P 0 1 TEX SDP 2017 2017 SDP
4511 4511 Rafael Lopez 29 lopezra02 2017 TOR AL 0.596084829 0.315 C, 3B 2 1 TOR CIN 2017 2017 SDP
4631 4631 Keith Hessler 27 hesslke01 2016 ARI NL 0.045683315 -0.02 P 0 1 ARI   2015 2016 SDP
4820 4820 Matt Szczur 26 szczuma01 2016 CHC NL 1.954507161 0.45 LF, CF, RF 4 1 CHC   2014 2017 SDP
4821 4821 Trevor Cahill 28 cahiltr01 2016 CHC NL 1.805521822 0.43 P 4 1 CHC ATL 2015 2016 SDP
4823 4823 Carl Edwards Jr. 24 edwarca01 2016 CHC NL 1.129696395 0.43 P 3 1 CHC   2015 2019 SDP
4840 4840 Clayton Richard 32 richacl01 2016 CHC NL 0.368197343 -0.315 P 0 1 CHC SDP 2015 2016 SDP
4880 4880 Hector Sanchez 26 sanchhe01 2016 CHW AL 0.075953511 -0.075 C 0 1 CHW SFG 2016 2016 SDP
4884 4884 Erik Johnson 26 johnser04 2016 CHW AL 0.322979367 -0.23 P 0 1 CHW   2013 2016 SDP
5024 5024 Jordan Lyles 25 lylesjo01 2016 COL NL 1.813668872 -0.46 P 1 1 COL HOU 2014 2017 SDP
5065 5065 Erick Aybar 32 aybarer01 2016 DET AL 0.864678899 0.206273292 SS, 3B, 2B 2 2 DET ATL 2016 2016 SDP
5136 5136 Eric Hosmer 26 hosmeer01 2016 KCR AL 6.414524954 0.705 1B 12 1 KCR   2011 2017 SDP
5147 5147 Matt Strahm 24 strahma01 2016 KCR AL 0.922917769 0.94 P 4 1 KCR   2016 2017 SDP
5179 5179 Jhoulys Chacin 28 chacijh01 2016 LAA AL 3.303854388 0.865 P 7 2 ANA ATL 2016 2016 SDP
5182 5182 Jered Weaver 33 weaveje02 2016 LAA AL 5.178244153 -0.39 P 6 1 ANA   2006 2016 SDP
5189 5189 Garrett Richards 28 richaga01 2016 LAA AL 1.008496989 0.595 P 3 1 ANA   2011 2018 SDP
5205 5205 Jose Valdez 26 valdejo03 2016 LAA AL 0.77317411 -0.11 P 1 1 ANA DET 2016 2017 SDP
5313 5313 Oswaldo Arcia 25 arciaos01 2016 MIA NL 0.019941551 -0.02515528 LF, RF 0 3 FLA TBD 2016 2016 SDP
5318 5318 Jarred Cosart 26 cosarja01 2016 MIA NL 0.53718626 -0.120745342 P 0 1 FLA HOU 2014 2016 SDP
5323 5323 Edwin Jackson 32 jacksed01 2016 MIA NL 0.306935755 -0.19621118 P 0 1 FLA ATL 2016 2016 SDP
5325 5325 Jake Esch 26 eschja01 2016 MIA NL 0.355089223 -0.211304348 P 0 1 FLA   2016 2016 SDP
5327 5327 Paul Clemens 28 clemepa02 2016 MIA NL 0.273145556 -0.332049689 P 0 1 FLA HOU 2016 2016 SDP
5406 5406 Phil Hughes 30 hugheph01 2016 MIN AL 1.611281753 0.08 P 2 1 MIN NYY 2014 2018 SDP
5481 5481 Chase Headley 32 headlch01 2016 NYY AL 5.08064249 2.67 3B 15 1 NYY SDP 2014 2017 SDP
5499 5499 Bryan Mitchell 25 mitchbr01 2016 NYY AL 0.714322094 0.4 P 2 1 NYY   2014 2017 SDP
5584 5584 Freddy Galvis 26 galvifr01 2016 PHI NL 6.375198168 1.735 SS 15 1 PHI   2012 2017 SDP
5795 5795 Luis Sardinas 23 sardilu01 2016 SEA AL 0.720090293 -0.495 SS, 1B, 2B, 3B, LF, P 0 1 SEA MIL 2016 2016 SDP
5851 5851 Greg Garcia 26 garcigr01 2016 STL NL 2.527725962 1.705 3B, SS, 2B 9 1 STL   2014 2018 SDP
6119 6119 Keith Hessler 26 hesslke01 2015 ARI NL 0.34737941 -0.315 P 0 1 ARI   2015 2016 SDP
6166 6166 Christian Bethancourt 23 bethach01 2015 ATL NL 1.627499123 -0.555 C 1 1 ATL   2013 2015 SDP
6231 6231 Bud Norris 30 norribu01 2015 BAL AL 1.751140231 -1.0 P 0 1 BAL HOU 2013 2015 SDP
6266 6266 Jemile Weeks 28 weeksje01 2015 BOS AL 0.084030908 0.045 2B 0 1 BOS BAL 2014 2015 SDP
6302 6302 Clayton Richard 31 richacl01 2015 CHC NL 1.213985006 0.465 P 3 1 CHC SDP 2015 2016 SDP
6306 6306 Trevor Cahill 27 cahiltr01 2015 CHC NL 0.512003568 0.33 P 2 2 CHC ATL 2015 2016 SDP
6311 6311 Fernando Rodney 38 rodnefe01 2015 CHC NL 0.389082363 0.15 P 1 2 CHC SEA 2015 2015 SDP
6320 6320 Carl Edwards Jr. 23 edwarca01 2015 CHC NL 0.086078468 -0.025 P 0 1 CHC   2015 2019 SDP
6329 6329 Matt Szczur 25 szczuma01 2015 CHC NL 0.796840117 -0.295 LF, CF, RF 0 1 CHC   2014 2017 SDP
6340 6340 Alexei Ramirez 33 ramiral03 2015 CHW AL 5.965933521 0.545 SS, P 11 1 CHW   2008 2015 SDP
6356 6356 Erik Johnson 25 johnser04 2015 CHW AL 0.97385205 0.34 P 2 1 CHW   2013 2016 SDP
6453 6453 Marc Rzepczynski 29 rzepcma01 2015 CLE AL 0.681781215 -0.020124224 P 1 1 CLE STL 2013 2015 SDP
6490 6490 Jordan Lyles 24 lylesjo01 2015 COL NL 1.403512612 0.24 P 3 1 COL HOU 2014 2017 SDP
6500 6500 Christian Friedrich 27 friedch01 2015 COL NL 1.723891153 0.01 P 2 1 COL   2012 2015 SDP
6618 6618 Eric Hosmer 25 hosmeer01 2015 KCR AL 6.349253241 3.54 1B, RF 21 1 KCR   2011 2017 SDP
6657 6657 Dusty Coleman 28 colemdu01 2015 KCR AL 0.047595602 -0.195 3B 0 1 KCR   2015 2015 SDP
6664 6664 Garrett Richards 27 richaga01 2015 LAA AL 5.805264346 2.35 P 16 1 ANA   2011 2018 SDP
6671 6671 Jered Weaver 32 weaveje02 2015 LAA AL 4.451947095 0.56 P 9 1 ANA   2006 2016 SDP
6757 6757 Zach Lee 23 leeza01 2015 LAD NL 0.127470438 -0.16 P 0 1 LAD   2015 2015 SDP
6781 6781 Carter Capps 24 cappsca01 2015 MIA NL 1.131358222 1.31 P 5 1 FLA SEA 2014 2015 SDP
6792 6792 Jarred Cosart 25 cosarja01 2015 MIA NL 1.954958792 -0.125 P 2 1 FLA HOU 2014 2016 SDP
6793 6793 Brad Hand 25 handbr01 2015 MIA NL 2.33284491 -0.335 P 2 1 FLA   2011 2015 SDP
6878 6878 Phil Hughes 29 hugheph01 2015 MIN AL 4.195824558 1.39 P 11 1 MIN NYY 2014 2018 SDP
6970 6970 Chase Headley 31 headlch01 2015 NYY AL 5.965395707 1.235 3B, 1B 12 1 NYY SDP 2014 2017 SDP
7010 7010 Bryan Mitchell 24 mitchbr01 2015 NYY AL 0.728547382 -0.305 P 0 1 NYY   2014 2017 SDP
7014 7014 Jose Pirela 25 pireljo01 2015 NYY AL 0.724767703 -0.6 2B, LF, RF 0 1 NYY   2014 2015 SDP
7031 7031 Drew Pomeranz 26 pomerdr01 2015 OAK AL 3.136516279 0.815 P 6 1 OAK COL 2014 2015 SDP
7070 7070 Freddy Galvis 25 galvifr01 2015 PHI NL 6.083492781 1.125 SS, 2B 12 1 PHI   2012 2017 SDP
7301 7301 Nick Noonan 26 noonani01 2015 SFG NL 0.240041386 -0.25 SS, 1B 0 1 SFG   2013 2015 SDP
7326 7326 Carlos Villanueva 31 villaca01 2015 STL NL 1.516998197 0.42 P 4 1 STL CHC 2015 2015 SDP
7331 7331 Greg Garcia 25 garcigr01 2015 STL NL 0.872105081 0.465 SS, 2B, 3B 3 1 STL   2014 2018 SDP
7336 7336 Jon Jay 30 jayjo02 2015 STL NL 2.455928102 -0.25 CF, LF, RF 3 1 STL   2010 2015 SDP
7386 7386 Jose Dominguez 24 dominjo01 2015 TBR AL 0.101977916 0.17 P 1 1 TBD LAD 2015 2015 SDP
7445 7445 Adam Rosales 32 rosalad01 2015 TEX AL 1.175993512 -0.31 1B, 2B, 3B, P, LF 1 1 TEX OAK 2013 2015 SDP
7454 7454 Jon Edwards 27 edwarjo02 2015 TEX AL 0.185125336 -0.135 P 0 1 TEX   2014 2015 SDP
7534 7534 Matt Thornton 38 thornma01 2015 WSN NL 1.412207702 0.76 P 4 1 WSN NYY 2014 2015 SDP
7541 7541 Craig Stammen 31 stammcr01 2015 WSN NL 0.173666337 0.155 P 1 1 WSN   2009 2015 SDP
7614 7614 Justin Upton 26 uptonju01 2014 ATL NL 6.514455931 3.42 LF 19 1 ATL ARI 2013 2014 SDP
7620 7620 Craig Kimbrel 26 kimbrcr01 2014 ATL NL 2.676276347 2.455 P 11 1 ATL   2010 2014 SDP

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