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,054 rows where prev_franch = "SEA"

✎ 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
1 1 Ketel Marte 25 marteke01 2019 ARI NL 6.191398946 7.15754717 CF, 2B, SS 30 1 ARI SEA 2017 2019  
10 10 Jarrod Dyson 34 dysonja01 2019 ARI NL 4.387217406 1.21245283 CF, RF, LF 10 1 ARI SEA 2018 2019  
38 38 Mike Leake 31 leakemi01 2019 ARI NL 1.679247681 -0.468679245 P 1 2 ARI SEA 2019 2019  
70 70 Anthony Swarzak 33 swarzan01 2019 ATL NL 1.343673848 0.112075472 P 3 2 ATL SEA 2019 2019  
106 106 Shawn Armstrong 28 armstsh01 2019 BAL AL 1.898930643 0.53490566 P 4 2 BAL SEA 2019 2019  
137 137 Mark Trumbo 33 trumbma01 2019 BAL AL 0.258842975 -0.193584906   0 1 BAL SEA 2016 2019  
144 144 Tayler Scott 27 scottta02 2019 BAL AL 0.148601572 -0.427924528 P 0 2 BAL SEA 2019 2019  
188 188 Erasmo Ramirez 29 ramirer02 2019 BOS AL 0.052360459 -0.091698113 P 0 1 BOS SEA 2019 2019  
249 249 Mike Montgomery 29 montgmi01 2019 CHC NL 0.923602972 -0.387169811 P 0 1 CHC SEA 2016 2019 KCR
264 264 Alex Colome 30 colomal01 2019 CHW AL 2.37508273 1.056075949 P 6 1 CHW SEA 2019 2019  
282 282 Ross Detwiler 33 detwiro01 2019 CHW AL 1.736603505 -0.579303797 P 1 1 CHW SEA 2019 2019  
285 285 Thyago Vieira 25 vieirth01 2019 CHW AL 0.133844441 -0.025632911 P 0 1 CHW SEA 2018 2019  
333 333 R.J. Alaniz 28 alanirj01 2019 CIN NL 0.222551597 0.045849057 P 0 2 CIN SEA 2019 2019  
337 337 Zach Duke 36 dukeza01 2019 CIN NL 0.66795772 -0.178301887 P 0 1 CIN SEA 2019 2019  
426 426 James Pazos 28 pazosja01 2019 COL NL 0.257730773 0.300566038 P 1 1 COL SEA 2019 2019  
476 476 Gordon Beckham 32 beckhgo01 2019 DET AL 2.314899374 -0.358860759 2B, SS, 3B, 1B 2 1 DET SEA 2019 2019  
482 482 John Hicks 29 hicksjo02 2019 DET AL 3.187891087 -0.81 C, 1B 1 1 DET SEA 2016 2019  
666 666 Chris Taylor 28 tayloch03 2019 LAD NL 4.017921765 1.925660377 LF, SS, 2B, CF, 3B, RF 12 1 LAD SEA 2016 2019  
690 690 Kristopher Negron 33 negrokr01 2019 LAD NL 0.539720834 -0.015283019 CF, RF, LF, SS, 2B, 3B 1 2 LAD SEA 2019 2019  
759 759 Eric Thames 32 thameer01 2019 MIL NL 4.417545053 1.783018868 1B, RF 13 1 MIL SEA 2017 2019  
764 764 Ben Gamel 27 gamelbe01 2019 MIL NL 3.372322339 0.759056604 LF, CF, RF 8 1 MIL SEA 2019 2019  
792 792 David Freitas 30 freitda01 2019 MIL NL 0.147908875 -0.13245283 C 0 2 MIL SEA 2019 2019  
804 804 Nelson Cruz 38 cruzne02 2019 MIN AL 4.745454545 4.156981132   19 1 MIN SEA 2019 2019  
834 834 Mike Morin 28 morinmi01 2019 MIN AL 0.584721861 0.142641509 P 1 1 MIN SEA 2019 2019 PHI
845 845 Chase De Jong 25 dejonch01 2019 MIN AL 0.014825605 -0.112075472 P 0 1 MIN SEA 2018 2019  
865 865 Robinson Cano 36 canoro01 2019 NYM NL 4.141438356 0.667358491 2B 7 1 NYM SEA 2019 2019  
874 874 Edwin Diaz 25 diazed04 2019 NYM NL 2.0465637 -0.361698113 P 2 1 NYM SEA 2019 2019  
910 910 James Paxton 30 paxtoja01 2019 NYY AL 4.25665365 2.898679245 P 15 1 NYY SEA 2019 2019  
920 920 Cameron Maybin 32 maybica01 2019 NYY AL 2.469297527 1.518113208 LF, RF, CF 8 1 NYY SEA 2019 2019  
927 927 Edwin Encarnacion 36 encared01 2019 NYY AL 1.870967742 0.738679245 1B, 2B 5 2 NYY SEA 2019 2019  
939 939 Cory Gearrin 33 gearrco01 2019 NYY AL 0.321214791 0.010188679 P 1 2 NYY SEA 2019 2019  
996 996 Chris Herrmann 31 herrmch01 2019 OAK AL 0.888237211 -0.244528302 C, LF 1 1 OAK SEA 2019 2019  
1013 1013 Jean Segura 29 segurje01 2019 PHI NL 6.164058469 1.956226415 SS 15 1 PHI SEA 2019 2019  
1027 1027 Jay Bruce 32 bruceja01 2019 PHI NL 1.486156492 0.188490566 LF, RF, 1B 3 2 PHI SEA 2019 2019  
1028 1028 Juan Nicasio 32 nicasju01 2019 PHI NL 1.396107121 0.13754717 P 3 1 PHI SEA 2019 2019  
1100 1100 Parker Markel 28 markepa01 2019 PIT NL 0.386788919 -0.117169811 P 0 2 PIT SEA 2019 2019  
1170 1170 Adam Warren 31 warread01 2019 SDP NL 0.861947591 -0.53490566 P 0 1 SDP SEA 2019 2019  
1296 1296 Nick Vincent 32 vinceni01 2019 SFG NL 0.683567224 -0.320943396 P 0 1 SFG SEA 2019 2019 PHI
1367 1367 Guillermo Heredia 28 heredgu01 2019 TBR AL 2.141161164 0.27509434 CF, RF, LF 4 1 TBD SEA 2019 2019  
1369 1369 Mike Zunino 28 zuninmi01 2019 TBR AL 2.678809563 0.224150943 C 4 1 TBD SEA 2019 2019  
1410 1410 Adrian Sampson 27 sampsad01 2019 TEX AL 3.610657601 1.054528302 P 8 1 TEX SEA 2018 2019  
1445 1445 Jesse Biddle 27 biddlje01 2019 TEX AL 0.120233489 -0.224150943 P 0 3 TEX SEA 2019 2019  
1467 1467 Justin Smoak 32 smoakju01 2019 TOR AL 4.783104257 0.310754717 1B 7 1 TOR SEA 2015 2019  
1488 1488 David Phelps 32 phelpda01 2019 TOR AL 0.55716019 0.163018868 P 1 1 TOR SEA 2019 2019 CHC
1501 1501 Zac Rosscup 31 rosscza01 2019 TOR AL 0.017561522 -0.076415094 P 0 2 TOR SEA 2019 2019 LAD
1553 1553 Hunter Strickland 30 strichu01 2019 WSN NL 0.671751842 -0.173207547 P 0 2 WSN SEA 2019 2019  
1556 1556 Roenis Elias 30 eliasro01 2019 WSN NL 0.120175788 -0.239433962 P 0 2 WSN SEA 2019 2019  
1569 1569 Ketel Marte 24 marteke01 2018 ARI NL 5.775107296 2.94 2B, SS 17 1 ARI SEA 2017 2019  
1584 1584 Jarrod Dyson 33 dysonja01 2018 ARI NL 2.359828326 0.22 CF, RF, LF 4 1 ARI SEA 2018 2019  
1593 1593 Taijuan Walker 25 walketa01 2018 ARI NL 0.352190425 0.15 P 1 1 ARI SEA 2017 2018  
1670 1670 Jose Ramirez 28 ramirjo02 2018 ATL NL 0.190067101 -0.435 P 0 1 ATL SEA 2016 2018  
1679 1679 Adam Jones 32 jonesad01 2018 BAL AL 5.914822825 0.275 CF, RF, LF 7 1 BAL SEA 2008 2018 ARI
1685 1685 Mark Trumbo 32 trumbma01 2018 BAL AL 3.454333722 0.26 RF, 1B 5 1 BAL SEA 2016 2019  
1701 1701 Danny Valencia 33 valenda01 2018 BAL AL 2.721011479 -0.26 3B, RF, 1B, P 2 1 BAL SEA 2018 2018  
1719 1719 John Andreoli 28 andrejo03 2018 BAL AL 0.588587589 -0.345 LF, RF, CF 0 2 BAL SEA 2018 2018  
1759 1759 Carson Smith 28 smithca02 2018 BOS AL 0.469215528 0.18 P 1 1 BOS SEA 2016 2018  
1787 1787 Mike Montgomery 28 montgmi01 2018 CHC NL 3.146294915 1.316871166 P 9 1 CHC SEA 2016 2019 KCR
1865 1865 Thyago Vieira 24 vieirth01 2018 CHW AL 0.427633557 -0.305 P 0 1 CHW SEA 2018 2019  
1915 1915 Yovani Gallardo 32 gallayo01 2018 CIN NL 0.047828037 -0.245 P 0 1 CIN SEA 2018 2018 TEX
1937 1937 Yonder Alonso 31 alonsyo01 2018 CLE AL 5.30634364 1.125 1B 10 1 CLE SEA 2018 2018 CHW
1959 1959 Marc Rzepczynski 32 rzepcma01 2018 CLE AL 0.076103017 0.075 P 0 2 CLE SEA 2018 2018  
1967 1967 Evan Marshall 28 marshev01 2018 CLE AL 0.215459196 -0.06 P 0 1 CLE SEA 2018 2018 CHW
2034 2034 John Hicks 28 hicksjo02 2018 DET AL 3.010981697 -0.015 1B, C 4 1 DET SEA 2016 2019  
2219 2219 Chris Taylor 27 tayloch03 2018 LAD NL 5.814439834 3.592822086 SS, CF, LF, 2B 18 1 LAD SEA 2016 2019  
2248 2248 Pat Venditte 33 vendipa01 2018 LAD NL 0.258193769 0.15404908 P 1 1 LAD SEA 2018 2018 SFG
2249 2249 Erik Goeddel 29 goedder01 2018 LAD NL 0.777655042 0.139141104 P 1 2 LAD SEA 2018 2018  
2308 2308 Tyler Cloyd 31 cloydty01 2018 MIA NL 0.309528905 -0.30689441 P 0 1 FLA SEA 2018 2018  
2332 2332 Eric Thames 31 thameer01 2018 MIL NL 2.725950972 0.745398773 RF, 1B, LF 7 1 MIL SEA 2017 2019  
2404 2404 Chase De Jong 24 dejonch01 2018 MIN AL 0.492358462 0.145 P 1 1 MIN SEA 2018 2019  
2417 2417 Taylor Motter 28 motteta01 2018 MIN AL 0.198630137 -0.31 1B, RF, 2B, 3B, LF, P, SS 0 2 MIN SEA 2018 2018  
2562 2562 Emilio Pagan 27 paganem01 2018 OAK AL 1.499261989 0.05 P 2 1 OAK SEA 2018 2018 TBD
2580 2580 Boog Powell 25 powelbo02 2018 OAK AL 0.232595444 -0.37 CF 0 1 OAK SEA 2017 2018  
2613 2613 Zac Curtis 25 curtiza01 2018 PHI NL 0.148738729 0.125 P 1 1 PHI SEA 2017 2018 TEX
2866 2866 Steven Baron 27 baronst01 2018 STL NL 0.049378512 -0.02 C 0 1 STL SEA 2018 2018 PIT
2909 2909 Brad Miller 28 millebr02 2018 TBR AL 1.634861494 0.245 1B, 2B, SS 3 1 TBD SEA 2016 2018 MIL
2925 2925 Ryan Weber 27 weberry01 2018 TBR AL 0.120224814 -0.11 P 0 1 TBD SEA 2018 2018 BOS
2931 2931 Jesus Sucre 30 sucreje01 2018 TBR AL 1.860359631 -0.805 C, P 0 1 TBD SEA 2017 2018 BAL
2962 2962 Adrian Sampson 26 sampsad01 2018 TEX AL 0.624429828 0.095 P 1 1 TEX SEA 2018 2019  
2983 2983 Justin Smoak 31 smoakju01 2018 TOR AL 5.692663582 1.985 1B 14 1 TOR SEA 2015 2019  
3103 3103 Taijuan Walker 24 walketa01 2017 ARI NL 4.369766322 2.955 P 15 1 ARI SEA 2017 2018  
3109 3109 Chris Iannetta 34 iannech01 2017 ARI NL 3.120190671 2.06 C, 3B 11 1 ARI SEA 2017 2017 COL
3112 3112 Ketel Marte 23 marteke01 2017 ARI NL 2.517875383 0.905 SS, 3B 6 1 ARI SEA 2017 2019  
3130 3130 Tom Wilhelmsen 33 wilheto01 2017 ARI NL 0.707659935 -0.005 P 1 1 ARI SEA 2017 2017  
3160 3160 Jose Ramirez 27 ramirjo02 2017 ATL NL 2.186443019 0.34 P 4 1 ATL SEA 2016 2018  
3195 3195 Adam Jones 31 jonesad01 2017 BAL AL 6.016007841 2.11 CF 16 1 BAL SEA 2008 2018 ARI
3203 3203 Wade Miley 30 mileywa01 2017 BAL AL 4.520199582 0.375 P 8 1 BAL SEA 2016 2017 MIL
3205 3205 Seth Smith 34 smithse01 2017 BAL AL 3.53381248 0.415 RF, LF 7 1 BAL SEA 2017 2017  
3207 3207 Mark Trumbo 31 trumbma01 2017 BAL AL 5.712838942 -0.885 RF, 1B, 3B 6 1 BAL SEA 2016 2019  
3238 3238 Vidal Nuno III 29 nunovi01 2017 BAL AL 0.317720908 -0.515 P 0 1 BAL SEA 2017 2017 TBD
3274 3274 Carson Smith 27 smithca02 2017 BOS AL 0.180090249 0.225 P 1 1 BOS SEA 2016 2018  
3278 3278 Roenis Elias 28 eliasro01 2017 BOS AL 0.004811935 0.005 P 0 1 BOS SEA 2016 2017 SEA
3299 3299 Mike Montgomery 27 montgmi01 2017 CHC NL 3.800072233 1.97 P 11 1 CHC SEA 2016 2019 KCR
3323 3323 Leonys Martin 29 martile01 2017 CHC NL 0.156413282 0.09 CF, RF, LF, P 0 2 CHC SEA 2017 2017 DET
3412 3412 Drew Storen 29 storedr01 2017 CIN NL 1.524620458 -0.135 P 2 1 CIN SEA 2017 2017  
3470 3470 Daniel Robertson 31 roberda09 2017 CLE AL 0.8215033 -0.095 RF, LF, CF 1 1 CLE SEA 2017 2017  
3537 3537 John Hicks 27 hicksjo02 2017 DET AL 1.798302872 0.365 1B, C 3 1 DET SEA 2016 2019  
3591 3591 Nori Aoki 35 aokino01 2017 HOU AL 2.081384172 0.135 LF, RF, CF, P 3 1 HOU SEA 2017 2017 TOR
3630 3630 Nate Karns 29 karnsna01 2017 KCR AL 1.238748945 0.685 P 4 1 KCR SEA 2017 2017 BAL
3635 3635 Sam Gaviglio 27 gavigsa01 2017 KCR AL 0.258022924 0.305 P 1 2 KCR SEA 2017 2017 TOR
3658 3658 Chris Young 38 youngch03 2017 KCR AL 0.636098181 -0.43 P 0 1 KCR SEA 2015 2017  

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