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,418 rows where next_franch = "SEA"

✎ 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
87 87 Jesse Biddle 27 biddlje01 2019 ATL NL 0.328208447 -0.219056604 P 0 1 ATL   2018 2019 SEA
120 120 Keon Broxton 29 broxtke01 2019 BAL AL 1.073719008 0.071320755 CF, LF, RF 1 2 BAL NYM 2019 2019 SEA
141 141 Mike Wright 29 wrighmi01 2019 BAL AL 0.332534985 -0.310754717 P 0 1 BAL   2015 2019 SEA
478 478 David McKay 24 mckayda02 2019 DET AL 0.527028325 0.307594937 P 1 1 DET   2019 2019 SEA
836 836 Matt Magill 29 magilma01 2019 MIN AL 0.693097034 -0.117169811 P 1 1 MIN CIN 2018 2019 SEA
1150 1150 Matt Wisler 26 wislema01 2019 SDP NL 0.902489196 -0.035660377 P 1 1 SDP CIN 2019 2019 SEA
1297 1297 Mac Williamson 28 willima11 2019 SFG NL 0.573062923 -0.397358491 LF, RF 0 1 SFG   2015 2019 SEA
1545 1545 Austin Adams 28 adamsau02 2019 WSN NL 0.016793796 -0.010188679 P 0 1 WSN   2017 2019 SEA
1599 1599 Kristopher Negron 32 negrokr01 2018 ARI NL 0.029871245 0.055 3B, LF, 2B, SS, RF 0 1 ARI CIN 2017 2018 SEA
1633 1633 Jesse Biddle 26 biddlje01 2018 ATL NL 1.967147679 0.51 P 4 1 ATL   2018 2019 SEA
1686 1686 Tim Beckham 28 beckhti01 2018 BAL AL 3.878888704 0.085 SS, 3B, 2B 5 1 BAL TBD 2017 2018 SEA
1699 1699 Mike Wright 28 wrighmi01 2018 BAL AL 2.190879722 0.02 P 2 1 BAL   2015 2019 SEA
1802 1802 Anthony Bass 30 bassan01 2018 CHC NL 0.40453187 0.213680982 P 1 1 CHC TEX 2018 2018 SEA
1830 1830 Omar Narvaez 26 narvaom01 2018 CHW AL 3.086942149 1.5 C 8 1 CHW   2016 2018 SEA
1935 1935 Edwin Encarnacion 35 encared01 2018 CLE AL 5.352566146 1.44 1B 11 1 CLE TOR 2017 2018 SEA
2001 2001 Tom Murphy 27 murphto04 2018 COL NL 0.952935136 -0.17392638 C 1 1 COL   2015 2018 SEA
2152 2152 Justin Grimm 29 grimmju01 2018 KCR AL 0.46603131 -0.96 P 0 1 KCR CHC 2018 2018 SEA
2256 2256 Zac Rosscup 30 rosscza01 2018 LAD NL 0.282495489 0.00993865 P 0 1 LAD COL 2018 2018 SEA
2274 2274 Cameron Maybin 31 maybica01 2018 MIA NL 2.87 1.046459627 LF, CF, RF 8 1 FLA HOU 2018 2018 SEA
2334 2334 Domingo Santana 25 santado01 2018 MIL NL 2.304311074 0.864662577 RF 6 1 MIL HOU 2015 2018 SEA
2395 2395 Zach Duke 35 dukeza01 2018 MIN AL 1.251885102 0.5 P 3 1 MIN STL 2018 2018 SEA
2397 2397 Matt Magill 28 magilma01 2018 MIN AL 1.697496585 0.215 P 3 1 MIN CIN 2018 2019 SEA
2443 2443 Jay Bruce 31 bruceja01 2018 NYM NL 3.582819986 -0.16 RF, 1B 4 1 NYM CLE 2018 2018 SEA
2469 2469 Gerson Bautista 23 bautige01 2018 NYM NL 0.103781099 -0.295 P 0 1 NYM   2018 2018 SEA
2476 2476 Anthony Swarzak 32 swarzan01 2018 NYM NL 0.85121071 -0.41 P 0 1 NYM MIL 2018 2018 SEA
2505 2505 Adam Warren 30 warread01 2018 NYY AL 0.753239625 0.505 P 3 1 NYY CHC 2016 2018 SEA
2522 2522 Justus Sheffield 22 sheffju01 2018 NYY AL 0.043700928 -0.08 P 0 1 NYY   2018 2018 SEA
2573 2573 Cory Gearrin 32 gearrco01 2018 OAK AL 0.118709894 -0.03 P 0 3 OAK TEX 2018 2018 SEA
2608 2608 J.P. Crawford 23 crawfjp01 2018 PHI NL 1.37148732 0.105 SS, 3B 2 1 PHI   2017 2018 SEA
2804 2804 Mac Williamson 27 willima11 2018 SFG NL 1.050181066 0.395 LF, RF 3 1 SFG   2015 2019 SEA
2814 2814 Hunter Strickland 29 strichu01 2018 SFG NL 1.522391543 -0.315 P 1 1 SFG   2014 2018 SEA
2859 2859 Sam Tuivailala 25 tuivasa01 2018 STL NL 0.876593825 0.045 P 1 1 STL   2014 2018 SEA
2880 2880 Mallex Smith 25 smithma05 2018 TBR AL 5.111291106 3.51 CF, RF, LF 17 1 TBD ATL 2017 2018 SEA
2900 2900 Denard Span 34 spande01 2018 TBR AL 1.625465738 0.76 LF, CF 4 1 TBD SFG 2018 2018 SEA
2910 2910 Alex Colome 29 colomal01 2018 TBR AL 0.875457814 0.19 P 2 1 TBD   2013 2018 SEA
2960 2960 Connor Sadzeck 26 sadzeco01 2018 TEX AL 0.310655501 0.21 P 1 1 TEX   2018 2018 SEA
3073 3073 Tommy Milone 31 milonto01 2018 WSN NL 0.673370568 0.15 P 1 1 WSN NYM 2018 2018 SEA
3082 3082 Austin Adams 27 adamsau02 2018 WSN NL 0.049497148 0.005 P 0 1 WSN   2017 2019 SEA
3132 3132 Chris Herrmann 29 herrmch01 2017 ARI NL 2.527749404 -0.855 C, LF, 1B, RF 1 1 ARI MIN 2016 2017 SEA
3139 3139 Kristopher Negron 31 negrokr01 2017 ARI NL 0.306094654 -0.195 LF, SS, 1B, 2B 0 1 ARI CIN 2017 2018 SEA
3180 3180 David Freitas 28 freitda01 2017 ATL NL 0.167288768 -0.01 C 0 1 ATL   2017 2017 SEA
3200 3200 Tim Beckham 27 beckhti01 2017 BAL AL 2.179026462 1.975 SS, 2B, 3B 9 2 BAL TBD 2017 2018 SEA
3223 3223 Mike Wright 27 wrighmi01 2017 BAL AL 0.518524209 -0.03 P 1 1 BAL   2015 2019 SEA
3278 3278 Roenis Elias 28 eliasro01 2017 BOS AL 0.004811935 0.005 P 0 1 BOS SEA 2016 2017 SEA
3348 3348 Omar Narvaez 25 narvaom01 2017 CHW AL 2.833250538 1.255 C, 1B 7 1 CHW   2016 2018 SEA
3421 3421 Zach Vincej 26 vinceza01 2017 CIN NL 0.11826678 -0.025 SS, 2B 0 1 CIN   2017 2017 SEA
3442 3442 Edwin Encarnacion 34 encared01 2017 CLE AL 6.245292129 2.545 1B 15 1 CLE TOR 2017 2018 SEA
3469 3469 Shawn Armstrong 26 armstsh01 2017 CLE AL 0.437004166 0.035 P 1 1 CLE   2015 2017 SEA
3516 3516 Tom Murphy 26 murphto04 2017 COL NL 0.257162347 -0.47 C 0 1 COL   2015 2018 SEA
3545 3545 Andrew Romine 31 rominan01 2017 DET AL 3.293733681 -0.67 2B, CF, 3B, 1B, LF, RF, SS, P, C 2 1 DET ANA 2014 2017 SEA
3646 3646 Mike Morin 26 morinmi01 2017 KCR AL 0.093075399 0.015 P 0 2 KCR ANA 2017 2017 SEA
3716 3716 Danny Espinosa 30 espinda01 2017 LAA AL 2.434236616 -1.15 2B, 3B, 1B, SS 0 1 ANA WSN 2017 2017 SEA
3773 3773 Dee Gordon 29 gordode01 2017 MIA NL 6.797639123 3.485 2B, SS 20 1 FLA LAD 2015 2017 SEA
3784 3784 David Phelps 30 phelpda01 2017 MIA NL 1.605410233 0.29 P 3 1 FLA NYY 2015 2017 SEA
3792 3792 Ichiro Suzuki 43 suzukic01 2017 MIA NL 2.102866779 -0.15 RF, CF, LF 2 1 FLA NYY 2015 2017 SEA
3814 3814 Domingo Santana 24 santado01 2017 MIL NL 6.050180443 3.105 RF 18 1 MIL HOU 2015 2018 SEA
3941 3941 Chasen Bradford 27 bradfch02 2017 NYM NL 0.896805053 0.225 P 2 1 NYM   2017 2017 SEA
3954 3954 Erik Goeddel 28 goedder01 2017 NYM NL 0.68032269 -0.165 P 0 1 NYM   2014 2017 SEA
3982 3982 Adam Warren 29 warread01 2017 NYY AL 1.886028606 1.3 P 6 1 NYY CHC 2016 2018 SEA
4023 4023 Yonder Alonso 30 alonsyo01 2017 OAK AL 3.52580698 1.78 1B 10 1 OAK SDP 2016 2017 SEA
4024 4024 Ryon Healy 25 healyry01 2017 OAK AL 5.749631329 0.695 1B, 3B 10 1 OAK   2016 2017 SEA
4093 4093 J.P. Crawford 22 crawfjp01 2017 PHI NL 0.865968766 0.685 3B, SS, 2B 3 1 PHI   2017 2018 SEA
4142 4142 Wade LeBlanc 32 leblawa01 2017 PIT NL 1.851464829 0.225 P 3 1 PIT SEA 2016 2017 SEA
4292 4292 Hunter Strickland 28 strichu01 2017 SFG NL 2.212372505 1.3 P 7 1 SFG   2014 2018 SEA
4318 4318 Mac Williamson 26 willima11 2017 SFG NL 0.727616429 -0.255 RF, LF 0 1 SFG   2015 2019 SEA
4341 4341 Mike Leake 29 leakemi01 2017 STL NL 4.30695994 1.41 P 10 1 STL SFG 2016 2017 SEA
4353 4353 Sam Tuivailala 24 tuivasa01 2017 STL NL 0.963532037 0.5 P 3 1 STL   2014 2018 SEA
4358 4358 Juan Nicasio 30 nicasju01 2017 STL NL 0.397641058 0.315 P 1 3 STL PHI 2017 2017 SEA
4369 4369 Marco Gonzales 25 gonzama02 2017 STL NL 0.092728368 -0.13 P 0 1 STL   2014 2017 SEA
4390 4390 Mallex Smith 24 smithma05 2017 TBR AL 2.671675923 1.245 CF, LF, RF 7 1 TBD ATL 2017 2018 SEA
4391 4391 Alex Colome 28 colomal01 2017 TBR AL 2.783306648 0.98 P 7 1 TBD   2013 2018 SEA
4402 4402 Erasmo Ramirez 27 ramirer02 2017 TBR AL 2.236766433 0.235 P 4 1 TBD SEA 2015 2017 SEA
4427 4427 Ryan Garton 27 gartory01 2017 TBR AL 0.265484634 -0.295 P 0 1 TBD   2016 2017 SEA
4537 4537 Casey Lawrence 29 lawreca01 2017 TOR AL 0.390943062 -0.37 P 0 1 TOR   2017 2017 SEA
4579 4579 Austin Adams 26 adamsau02 2017 WSN NL 0.079757026 -0.02 P 0 1 WSN   2017 2019 SEA
4592 4592 Jean Segura 26 segurje01 2016 ARI NL 6.792440094 5.235 2B, SS 25 1 ARI MIL 2016 2016 SEA
4603 4603 Chris Herrmann 28 herrmch01 2016 ARI NL 1.624704691 1.145 C, RF, LF, 1B, CF 6 1 ARI MIN 2016 2017 SEA
4619 4619 Mitch Haniger 25 hanigmi01 2016 ARI NL 1.203847452 0.19 CF, LF, RF 2 1 ARI   2016 2016 SEA
4632 4632 Mike Freeman 28 freemmi01 2016 ARI NL 0.107661154 -0.2 2B, SS, LF, RF 0 1 ARI   2016 2016 SEA
4633 4633 Zac Curtis 23 curtiza01 2016 ARI NL 0.365076063 -0.29 P 0 1 ARI   2016 2016 SEA
4637 4637 Evan Marshall 26 marshev01 2016 ARI NL 0.377180189 -0.41 P 0 1 ARI   2014 2016 SEA
4641 4641 Tuffy Gosewisch 32 gosewtu01 2016 ARI NL 0.968950388 -0.675 C 0 1 ARI   2013 2016 SEA
4673 4673 Shae Simmons 25 simmosh01 2016 ATL NL 0.158340261 0.166024845 P 1 1 ATL   2014 2016 SEA
4680 4680 Ryan Weber 25 weberry01 2016 ATL NL 0.937993935 -0.231428571 P 1 1 ATL   2015 2016 SEA
4693 4693 Rob Whalen 22 whalero01 2016 ATL NL 0.68774748 -0.206273292 P 0 1 ATL   2016 2016 SEA
4718 4718 Yovani Gallardo 30 gallayo01 2016 BAL AL 3.414082349 0.55 P 7 1 BAL TEX 2016 2016 SEA
4724 4724 Mike Wright 26 wrighmi01 2016 BAL AL 1.929272674 -0.12 P 3 1 BAL   2015 2019 SEA
4738 4738 Ariel Miranda 27 miranar01 2016 BAL AL 0.045797534 -0.01 P 0 1 BAL   2016 2016 SEA
4796 4796 Roenis Elias 27 eliasro01 2016 BOS AL 0.161600635 -0.315 P 0 1 BOS SEA 2016 2017 SEA
4866 4866 Omar Narvaez 24 narvaom01 2016 CHW AL 1.110820101 0.24 C 2 1 CHW   2016 2018 SEA
4977 4977 Shawn Armstrong 25 armstsh01 2016 CLE AL 0.27162457 0.140869565 P 1 1 CLE   2015 2017 SEA
5012 5012 Tom Murphy 25 murphto04 2016 COL NL 0.481776572 0.68 C 3 1 COL   2015 2018 SEA
5033 5033 Matt Carasiti 24 carasma01 2016 COL NL 0.371080261 -0.275 P 0 1 COL   2016 2016 SEA
5036 5036 Christian Bergman 28 bergmch01 2016 COL NL 0.641161887 -0.425 P 0 1 COL   2014 2016 SEA
5063 5063 Andrew Romine 30 rominan01 2016 DET AL 1.843381389 0.402484472 3B, CF, 1B, SS, 2B, RF, LF, P 4 1 DET ANA 2014 2017 SEA
5130 5130 Jarrod Dyson 31 dysonja01 2016 KCR AL 3.240921903 2.935 CF, RF, LF 14 1 KCR   2010 2016 SEA
5253 5253 Carlos Ruiz 37 ruizca01 2016 LAD NL 0.396852549 0.165 C 1 2 LAD PHI 2016 2016 SEA
5271 5271 Casey Fien 32 fienca01 2016 LAD NL 0.667422202 -0.25 P 0 2 LAD MIN 2016 2016 SEA
5285 5285 David Phelps 29 phelpda01 2016 MIA NL 3.063514862 2.349503106 P 11 1 FLA NYY 2015 2017 SEA
5288 5288 Ichiro Suzuki 42 suzukic01 2016 MIA NL 3.63933299 1.438881988 RF, CF, LF 9 1 FLA NYY 2015 2017 SEA

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