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,522 rows where next_franch = "SFG"

✎ 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
114 114 Joey Rickard 28 rickajo01 2019 BAL AL 1.294214876 0.091698113 RF, LF, CF 2 1 BAL   2016 2019 SFG
341 341 Wandy Peralta 27 peralwa01 2019 CIN NL 0.916662159 -0.514528302 P 0 1 CIN   2016 2019 SFG
343 343 Scooter Gennett 29 gennesc01 2019 CIN NL 0.743060498 -0.641886792 2B 0 1 CIN MIL 2017 2019 SFG
789 789 Mauricio Dubon 24 dubonma01 2019 MIL NL 0.019721183 -0.025471698 2B, SS 0 1 MIL   2019 2019 SFG
796 796 Burch Smith 29 smithbu03 2019 MIL NL 0.269653652 -0.249622642 P 0 1 MIL KCR 2019 2019 SFG
841 841 Tyler Austin 27 austity01 2019 MIN AL 0.046251994 -0.025471698 LF, 1B, RF 0 1 MIN NYY 2018 2019 SFG
999 999 Corban Joseph 30 josepco01 2019 OAK AL 0.377973281 -0.219056604 2B, 3B 0 1 OAK BAL 2019 2019 SFG
1061 1061 Aaron Altherr 28 altheaa01 2019 PHI NL 0.299226139 -0.565471698 LF, CF, RF, P 0 1 PHI   2014 2019 SFG
1165 1165 Alex Dickerson 29 dickeal01 2019 SDP NL 0.195667614 -0.249622642 LF, RF 0 1 SDP   2015 2019 SFG
1508 1508 Kevin Pillar 30 pillake01 2019 TOR AL 0.165269863 -0.331132075 CF, RF 0 1 TOR   2013 2019 SFG
1561 1561 Kyle Barraclough 29 barraky01 2019 WSN NL 0.960944092 -0.641886792 P 0 1 WSN FLA 2019 2019 SFG
1651 1651 Michael Reed 25 reedmi02 2018 ATL NL 0.068546345 -0.005 LF 0 1 ATL MIL 2018 2018 SFG
1688 1688 Joey Rickard 27 rickajo01 2018 BAL AL 2.219264681 0.52 RF, LF, CF 4 1 BAL   2016 2019 SFG
1758 1758 Drew Pomeranz 29 pomerdr01 2018 BOS AL 1.865950124 -0.445 P 2 1 BOS SDP 2016 2018 SFG
1873 1873 Scooter Gennett 28 gennesc01 2018 CIN NL 6.279314441 4.325 2B 21 1 CIN MIL 2017 2019 SFG
1900 1900 Wandy Peralta 26 peralwa01 2018 CIN NL 1.264026699 -0.315 P 1 1 CIN   2016 2019 SFG
1986 1986 Gerardo Parra 31 parrage01 2018 COL NL 4.397398597 0.233558282 LF, RF 8 1 COL BAL 2016 2018 SFG
2062 2062 Mike Gerber 25 gerbemi01 2018 DET AL 0.453577371 -0.525 LF, CF, RF 0 1 DET   2018 2018 SFG
2206 2206 Williams Jerez 26 jerezwi01 2018 LAA AL 0.467396012 -0.365 P 0 1 ANA   2018 2018 SFG
2248 2248 Pat Venditte 33 vendipa01 2018 LAD NL 0.258193769 0.15404908 P 1 1 LAD SEA 2018 2018 SFG
2339 2339 Erik Kratz 38 kratzer01 2018 MIL NL 2.147421809 0.397546012 C, P, 1B 5 1 MIL NYY 2018 2018 SFG
2396 2396 Tyler Austin 26 austity01 2018 MIN AL 1.286366601 0.305 1B 3 2 MIN NYY 2018 2019 SFG
2611 2611 Aaron Altherr 27 altheaa01 2018 PHI NL 2.832419465 -0.63 RF, CF, LF 2 1 PHI   2014 2019 SFG
2748 2748 Nick Vincent 31 vinceni01 2018 SEA AL 1.949131288 0.445 P 4 1 SEA SDP 2016 2018 SFG
2982 2982 Kevin Pillar 29 pillake01 2018 TOR AL 5.194315929 2.225 CF 14 1 TOR   2013 2019 SFG
3004 3004 Yangervis Solarte 30 solarya01 2018 TOR AL 4.849306015 -1.02 3B, 2B, SS, 1B 4 1 TOR SDP 2018 2018 SFG
3093 3093 Trevor Gott 25 gotttr01 2018 WSN NL 0.45743739 -0.245 P 0 1 WSN ANA 2016 2018 SFG
3118 3118 Gregor Blanco 33 blancgr01 2017 ARI NL 2.527749404 0.28 LF, CF, RF 4 1 ARI SFG 2017 2017 SFG
3210 3210 Joey Rickard 26 rickajo01 2017 BAL AL 2.624305782 0.48 RF, LF, CF 5 1 BAL   2016 2019 SFG
3244 3244 Drew Pomeranz 28 pomerdr01 2017 BOS AL 4.641707069 3.44 P 17 1 BOS SDP 2016 2018 SFG
3263 3263 Fernando Abad 31 abadfe01 2017 BOS AL 1.048525452 0.4 P 3 1 BOS MIN 2016 2017 SFG
3290 3290 Pablo Sandoval 30 sandopa01 2017 BOS AL 0.99192399 -0.685 3B, 1B, 2B 0 1 BOS SFG 2015 2017 SFG
3329 3329 Pierce Johnson 26 johnspi01 2017 CHC NL 0.029986295 -0.065 P 0 1 CHC   2017 2017 SFG
3365 3365 Derek Holland 30 hollade01 2017 CHW AL 3.768239164 -1.16 P 2 1 CHW TEX 2017 2017 SFG
3376 3376 Alen Hanson 24 hansoal01 2017 CHW AL 1.680741845 -0.35 RF, 2B, CF, LF, SS, 3B 1 2 CHW PIT 2017 2017 SFG
3392 3392 Scooter Gennett 27 gennesc01 2017 CIN NL 4.898215803 2.205 2B, 3B, LF, RF, P 13 1 CIN MIL 2017 2019 SFG
3403 3403 Wandy Peralta 25 peralwa01 2017 CIN NL 2.050853567 0.56 P 4 1 CIN   2016 2019 SFG
3447 3447 Austin Jackson 30 jacksau01 2017 CLE AL 2.968614196 1.83 CF, LF, RF 9 1 CLE CHW 2017 2017 SFG
3488 3488 Gerardo Parra 30 parrage01 2017 COL NL 4.20361528 0.75 LF, RF, 1B, CF 9 1 COL BAL 2016 2018 SFG
3514 3514 Cristhian Adames 25 adamecr01 2017 COL NL 0.138472033 -0.355 1B, 2B, SS 0 1 COL   2014 2017 SFG
3605 3605 Jandel Gustave 24 gustaja01 2017 HOU AL 0.131805466 -0.11 P 0 1 HOU   2016 2017 SFG
3743 3743 Tony Watson 32 watsoto01 2017 LAD NL 0.695066997 0.24 P 2 2 LAD PIT 2017 2017 SFG
3837 3837 Stephen Vogt 32 vogtst01 2017 MIL NL 1.285787936 0.245 C, LF 3 2 MIL OAK 2017 2017 SFG
4076 4076 Aaron Altherr 26 altheaa01 2017 PHI NL 4.100909559 1.515 LF, RF, CF 9 1 PHI   2014 2019 SFG
4122 4122 Andrew McCutchen 30 mccutan01 2017 PIT NL 6.485463616 3.115 CF, RF 19 1 PIT   2009 2017 SFG
4213 4213 Jose Valdez 27 valdejo03 2017 SDP NL 0.347499534 -0.39 P 0 2 SDP ANA 2017 2017 SFG
4217 4217 Chase d'Arnaud 30 darnach01 2017 SDP NL 0.523817956 -0.64 SS, LF, 2B, 3B, 1B, RF 0 3 SDP BOS 2017 2017 SFG
4230 4230 Nick Vincent 30 vinceni01 2017 SEA AL 2.449568014 1.525 P 8 1 SEA SDP 2016 2018 SFG
4382 4382 Evan Longoria 31 longoev01 2017 TBR AL 6.413917021 2.95 3B 17 1 TBD   2008 2017 SFG
4482 4482 Sam Dyson 29 dysonsa01 2017 TEX AL 0.618394875 -1.195 P 0 1 TEX FLA 2015 2017 SFG
4486 4486 Kevin Pillar 28 pillake01 2017 TOR AL 5.979771615 2.52 CF 16 1 TOR   2013 2019 SFG
4586 4586 Trevor Gott 24 gotttr01 2017 WSN NL 0.062165756 -0.285 P 0 1 WSN ANA 2016 2018 SFG
4671 4671 Gordon Beckham 29 beckhgo01 2016 ATL NL 2.693773392 -0.593664596 2B, 3B, SS 2 1 ATL CHW 2016 2016 SFG
4677 4677 Casey Kelly 26 kellyca01 2016 ATL NL 0.744740139 -0.070434783 P 1 1 ATL SDP 2016 2016 SFG
4725 4725 Joey Rickard 25 rickajo01 2016 BAL AL 2.698564593 -0.345 RF, LF, CF 3 1 BAL   2016 2019 SFG
4745 4745 Drew Stubbs 31 stubbdr01 2016 BAL AL 0.258373206 -0.25 RF, CF, LF 0 3 BAL TEX 2016 2016 SFG
4768 4768 Drew Pomeranz 27 pomerdr01 2016 BOS AL 1.973699449 0.54 P 4 2 BOS SDP 2016 2018 SFG
4779 4779 Aaron Hill 34 hillaa01 2016 BOS AL 1.262672811 -0.265 3B, 2B 1 2 BOS MIL 2016 2016 SFG
4792 4792 Fernando Abad 30 abadfe01 2016 BOS AL 0.442497815 -0.185 P 0 2 BOS MIN 2016 2017 SFG
4793 4793 Pablo Sandoval 29 sandopa01 2016 BOS AL 0.064516129 -0.21 3B 0 1 BOS SFG 2015 2017 SFG
4834 4834 Joe Nathan 41 nathajo01 2016 CHC NL 0.037656546 0.04 P 0 1 CHC DET 2016 2016 SFG
4842 4842 Tim Federowicz 28 federti01 2016 CHC NL 0.322493682 -0.415 C 0 1 CHC LAD 2016 2016 SFG
4926 4926 Wandy Peralta 24 peralwa01 2016 CIN NL 0.172396152 -0.145 P 0 1 CIN   2016 2019 SFG
5011 5011 Nick Hundley 32 hundlni01 2016 COL NL 3.116799458 -0.11 C 4 1 COL BAL 2015 2016 SFG
5025 5025 Cristhian Adames 24 adamecr01 2016 COL NL 2.517036786 -0.705 SS, 2B, 3B 1 1 COL   2014 2017 SFG
5040 5040 Gerardo Parra 29 parrage01 2016 COL NL 3.746058654 -2.315 LF, 1B, RF, CF 0 1 COL BAL 2016 2018 SFG
5112 5112 Jandel Gustave 23 gustaja01 2016 HOU AL 0.325014282 0.135 P 1 1 HOU   2016 2017 SFG
5321 5321 Bryan Morris 29 morribr01 2016 MIA NL 0.585777929 -0.160993789 P 0 1 FLA PIT 2014 2016 SFG
5360 5360 Will Smith 26 smithwi04 2016 MIL NL 0.848448328 -0.04 P 1 1 MIL KCR 2014 2016 SFG
5385 5385 Eduardo Nunez 29 nunezed02 2016 MIN AL 3.69438636 1.65 SS, 3B, 2B 9 1 MIN NYY 2014 2016 SFG
5422 5422 Neil Ramirez 27 ramirne01 2016 MIN AL 0.362924404 -0.3 P 0 3 MIN MIL 2016 2016 SFG
5462 5462 Justin Ruggiano 34 ruggiju01 2016 NYM NL 0.220303867 0.21 CF, LF, RF 1 2 NYM TEX 2016 2016 SFG
5514 5514 Donovan Solano 28 solando01 2016 NYY AL 0.2208975 0.01 2B, 3B 0 1 NYY FLA 2016 2016 SFG
5600 5600 Aaron Altherr 25 altheaa01 2016 PHI NL 2.319182667 -0.295 RF, LF, CF 3 1 PHI   2014 2019 SFG
5639 5639 Andrew McCutchen 29 mccutan01 2016 PIT NL 6.590909091 0.24 CF 10 1 PIT   2009 2017 SFG
5678 5678 Mike Morse 34 morsemi01 2016 PIT NL 0.078114478 -0.21 1B 0 1 PIT FLA 2015 2016 SFG
5696 5696 Alex Dickerson 26 dickeal01 2016 SDP NL 2.904586189 0.935 LF 7 1 SDP   2015 2019 SFG
5760 5760 Nick Vincent 29 vinceni01 2016 SEA AL 2.109413966 0.51 P 5 1 SEA SDP 2016 2018 SFG
5880 5880 Ruben Tejada 26 tejadru01 2016 STL NL 0.393420383 -0.46 3B, SS, 2B, P 0 1 STL NYM 2016 2016 SFG
5882 5882 Evan Longoria 30 longoev01 2016 TBR AL 6.598571666 4.185 3B 20 1 TBD   2008 2017 SFG
5891 5891 Matt Moore 27 moorema02 2016 TBR AL 3.676477962 1.22 P 8 1 TBD   2011 2016 SFG
5938 5938 Sam Dyson 28 dysonsa01 2016 TEX AL 2.927863046 1.98 P 11 1 TEX FLA 2015 2017 SFG
5988 5988 Kevin Pillar 27 pillake01 2016 TOR AL 5.463225806 2.925 CF 16 1 TOR   2013 2019 SFG
6045 6045 Mark Melancon 31 melanma01 2016 WSN NL 1.06148748 1.105 P 5 2 WSN PIT 2016 2016 SFG
6063 6063 Trevor Gott 23 gotttr01 2016 WSN NL 0.166488749 0.16 P 1 1 WSN ANA 2016 2018 SFG
6122 6122 Matt Reynolds 30 reynoma02 2015 ARI NL 0.505969871 -0.335 P 0 1 ARI COL 2013 2015 SFG
6245 6245 Alejandro De Aza 31 deazaal01 2015 BOS AL 1.661944623 1.15 LF, RF, CF 6 2 BOS BAL 2015 2015 SFG
6258 6258 Pablo Sandoval 28 sandopa01 2015 BOS AL 4.715067611 -1.05 3B 3 1 BOS SFG 2015 2017 SFG
6337 6337 Jeff Samardzija 30 samarje01 2015 CHW AL 5.986422632 1.315 P 13 1 CHW OAK 2015 2015 SFG
6379 6379 Mike Leake 27 leakemi01 2015 CIN NL 3.797579116 2.045 P 10 1 CIN   2010 2015 SFG
6383 6383 Marlon Byrd 37 byrdma01 2015 CIN NL 3.840928486 0.89 LF, RF, CF 7 1 CIN PHI 2015 2015 SFG
6478 6478 Nick Hundley 31 hundlni01 2015 COL NL 3.923826087 1.515 C 10 1 COL BAL 2015 2016 SFG
6507 6507 Cristhian Adames 23 adamecr01 2015 COL NL 0.585043478 0.035 SS, 2B 1 1 COL   2014 2017 SFG
6633 6633 Johnny Cueto 29 cuetojo01 2015 KCR AL 2.274600569 0.64 P 6 2 KCR CIN 2015 2015 SFG
6655 6655 Orlando Calixte 23 calixor01 2015 KCR AL 0.028557361 -0.07 SS 0 1 KCR   2015 2015 SFG
6690 6690 Conor Gillaspie 27 gillaco01 2015 LAA AL 0.660857909 -0.17 3B, 1B, 2B 1 2 ANA CHW 2015 2015 SFG
6710 6710 Grant Green 27 greengr01 2015 LAA AL 0.427613941 -0.555 2B, 1B, LF, SS 0 1 ANA OAK 2013 2015 SFG
6785 6785 Bryan Morris 28 morribr01 2015 MIA NL 2.154303559 0.29 P 4 1 FLA PIT 2014 2016 SFG
6796 6796 Vin Mazzaro 28 mazzavi01 2015 MIA NL 0.264975198 0.065 P 1 1 FLA PIT 2015 2015 SFG
6829 6829 Will Smith 25 smithwi04 2015 MIL NL 2.248406785 1.16 P 7 1 MIL KCR 2014 2016 SFG

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