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

764 rows where next_franch = "ARI"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, lg_ID, stint_ID, franch_id, prev_franch, year_acq, year_left

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
185 185 Blake Swihart 27 swihabl01 2019 BOS AL 0.26521602 0.0 LF, RF, C, 1B 0 1 BOS   2015 2019 ARI
714 714 Zac Gallen 23 galleza01 2019 MIA NL 1.062156068 1.059622642 P 5 1 FLA   2019 2019 ARI
1176 1176 Mike Leake 31 leakemi01 2019 SEA AL 3.949916242 1.569056604 P 10 1 SEA STL 2017 2019 ARI
1657 1657 Chris Stewart 36 stewach01 2018 ATL NL 0.156677359 -0.065 C 0 1 ATL PIT 2018 2018 ARI
1679 1679 Adam Jones 32 jonesad01 2018 BAL AL 5.914822825 0.275 CF, RF, LF 7 1 BAL SEA 2008 2018 ARI
1693 1693 Caleb Joseph 32 josepca01 2018 BAL AL 2.701713525 -0.04 C, 1B 3 1 BAL   2014 2018 ARI
1757 1757 Blake Swihart 26 swihabl01 2018 BOS AL 1.911174785 -0.27 C, RF, 1B, LF, 3B, 2B 2 1 BOS   2015 2019 ARI
1771 1771 Robby Scott 28 scottro02 2018 BOS AL 0.250680829 -0.33 P 0 1 BOS   2016 2018 ARI
2115 2115 Jon Jay 33 jayjo02 2018 KCR AL 2.553881808 0.965 RF, LF, CF 6 1 KCR CHC 2018 2018 ARI
2148 2148 Abraham Almonte 29 almonab01 2018 KCR AL 1.449759974 -0.6 CF, RF, LF 0 1 KCR CLE 2018 2018 ARI
2247 2247 Tim Locastro 25 locasti01 2018 LAD NL 0.134771784 0.15404908 CF, LF 1 1 LAD   2017 2018 ARI
2290 2290 Brad Ziegler 38 zieglbr01 2018 MIA NL 1.845899368 -0.327018634 P 2 1 FLA BOS 2017 2018 ARI
2375 2375 Eduardo Escobar 29 escobed01 2018 MIN AL 3.859099804 2.37 3B, SS, 2B 13 1 MIN CHW 2012 2018 ARI
2437 2437 Wilmer Flores 26 florewi01 2018 NYM NL 4.257700205 0.445 1B, 2B, 3B 7 1 NYM   2013 2018 ARI
2735 2735 Mike Leake 30 leakemi01 2018 SEA AL 5.155790585 1.9 P 14 1 SEA STL 2017 2019 ARI
2845 2845 Luke Weaver 24 weavelu01 2018 STL NL 3.534350142 0.125 P 6 1 STL   2016 2018 ARI
2873 2873 Carson Kelly 23 kellyca02 2018 STL NL 0.414779499 -0.515 C 0 1 STL   2016 2018 ARI
2908 2908 Matt Andriese 28 andrima01 2018 TBR AL 1.810271903 0.25 P 3 1 TBD   2015 2018 ARI
2949 2949 Jake Diekman 31 diekmja01 2018 TEX AL 1.405772384 0.73 P 4 1 TEX PHI 2015 2018 ARI
3064 3064 Greg Holland 32 hollagr01 2018 WSN NL 0.75287505 0.84 P 3 2 WSN STL 2018 2018 ARI
3195 3195 Adam Jones 31 jonesad01 2017 BAL AL 6.016007841 2.11 CF 16 1 BAL SEA 2008 2018 ARI
3201 3201 Caleb Joseph 31 josepca01 2017 BAL AL 2.520091473 1.315 C, 3B 8 1 BAL   2014 2018 ARI
3230 3230 Stefan Crichton 25 crichst01 2017 BAL AL 0.269069254 -0.11 P 0 1 BAL   2017 2017 ARI
3264 3264 Deven Marrero 26 marrede01 2017 BOS AL 1.726682502 0.295 3B, 2B, SS, 1B 3 1 BOS   2015 2017 ARI
3273 3273 Robby Scott 27 scottro02 2017 BOS AL 1.223470265 0.045 P 2 1 BOS   2016 2018 ARI
3279 3279 Blake Swihart 25 swihabl01 2017 BOS AL 0.06429137 0.0 C 0 1 BOS   2015 2019 ARI
3314 3314 Alex Avila 30 avilaal01 2017 CHC NL 1.094892972 0.54 C, 1B 3 2 CHC DET 2017 2017 ARI
3407 3407 Patrick Kivlehan 27 kivlepa01 2017 CIN NL 2.010535259 0.035 RF, 1B, LF, 3B, CF 3 1 CIN SDP 2016 2017 ARI
3530 3530 J.D. Martinez 29 martijd02 2017 DET AL 2.195822454 1.605 RF 7 1 DET HOU 2014 2017 ARI
3680 3680 David Hernandez 32 hernada01 2017 LAA AL 1.022298785 0.975 P 4 1 ANA PHI 2017 2017 ARI
3691 3691 Fernando Salas 32 salasfe01 2017 LAA AL 0.323497198 0.3 P 1 2 ANA NYM 2017 2017 ARI
3711 3711 Troy Scribner 25 scribtr01 2017 LAA AL 0.644761328 -0.185 P 0 1 ANA   2017 2017 ARI
3752 3752 Tim Locastro 24 locasti01 2017 LAD NL 0.009890859 -0.01 LF 0 1 LAD   2017 2018 ARI
3793 3793 Brad Ziegler 37 zieglbr01 2017 MIA NL 1.734416413 -0.155 P 2 1 FLA BOS 2017 2018 ARI
3872 3872 Eduardo Escobar 28 escobed01 2017 MIN AL 4.640371974 1.475 3B, SS, 2B, LF, C 11 1 MIN CHW 2012 2018 ARI
3929 3929 Wilmer Flores 25 florewi01 2017 NYM NL 3.592130026 0.445 3B, 1B, 2B 6 1 NYM   2013 2018 ARI
4043 4043 Adam Rosales 34 rosalad01 2017 OAK AL 2.119285597 -0.105 SS, 3B, 2B, 1B, LF 3 1 OAK SDP 2017 2017 ARI
4111 4111 Clay Buchholz 32 buchhcl01 2017 PHI NL 0.209843803 -0.155 P 0 1 PHI BOS 2017 2017 ARI
4228 4228 Jarrod Dyson 32 dysonja01 2017 SEA AL 3.684639192 2.405 CF, LF 12 1 SEA KCR 2017 2017 ARI
4236 4236 Mike Leake 29 leakemi01 2017 SEA AL 0.885443077 1.08 P 4 2 SEA STL 2017 2019 ARI
4349 4349 Luke Weaver 23 weavelu01 2017 STL NL 1.579655014 1.08 P 5 1 STL   2016 2018 ARI
4376 4376 Carson Kelly 22 kellyca02 2017 STL NL 0.738665308 -0.36 C 0 1 STL   2016 2018 ARI
4379 4379 Steven Souza Jr. 28 souzast01 2017 TBR AL 5.845475335 3.925 RF, CF 19 1 TBD WSN 2015 2017 ARI
4400 4400 Matt Andriese 27 andrima01 2017 TBR AL 2.297395806 0.35 P 4 1 TBD   2015 2018 ARI
4407 4407 Brad Boxberger 29 boxbebr01 2017 TBR AL 0.976298332 0.37 P 2 1 TBD SDP 2014 2017 ARI
4456 4456 Jake Diekman 30 diekmja01 2017 TEX AL 0.377783051 0.21 P 1 1 TEX PHI 2015 2018 ARI
4708 4708 Adam Jones 30 jonesad01 2016 BAL AL 6.43062201 1.725 CF 15 1 BAL SEA 2008 2018 ARI
4746 4746 T.J. McFarland 27 mcfartj01 2016 BAL AL 0.671697159 -0.355 P 0 1 BAL   2013 2016 ARI
4748 4748 Caleb Joseph 30 josepca01 2016 BAL AL 1.349282297 -0.705 C, 1B 0 1 BAL   2014 2018 ARI
4775 4775 Blake Swihart 24 swihabl01 2016 BOS AL 0.68202765 0.275 LF, C 2 1 BOS   2015 2019 ARI
4778 4778 Robby Scott 26 scottro02 2016 BOS AL 0.186609672 0.22 P 1 1 BOS   2016 2018 ARI
4787 4787 Deven Marrero 25 marrede01 2016 BOS AL 0.129032258 -0.12 2B, 3B, SS 0 1 BOS   2015 2017 ARI
4928 4928 Patrick Kivlehan 26 kivlepa01 2016 CIN NL 0.050286111 -0.165 RF, LF 0 2 CIN SDP 2016 2017 ARI
4944 4944 J.J. Hoover 28 hoovejj01 2016 CIN NL 0.509605049 -1.22 P 0 1 CIN   2012 2016 ARI
5007 5007 Daniel Descalso 29 descada01 2016 COL NL 2.841498559 0.625 SS, 1B, 2B, LF, 3B 6 1 COL STL 2015 2016 ARI
5008 5008 Jorge De La Rosa 35 rosajo01 2016 COL NL 3.812826607 0.245 P 6 1 COL KCR 2008 2016 ARI
5046 5046 J.D. Martinez 28 martijd02 2016 DET AL 4.912516383 2.022484472 RF 13 1 DET HOU 2014 2017 ARI
5164 5164 Rey Fuentes 25 fuentre01 2016 KCR AL 0.423147073 -0.215 RF, LF 0 1 KCR SDP 2016 2016 ARI
5167 5167 Kris Medlen 30 medlekr01 2016 KCR AL 0.678104841 -0.405 P 0 1 KCR ATL 2015 2016 ARI
5294 5294 Jeff Mathis 33 mathije01 2016 MIA NL 1.316142341 0.664099379 C 4 1 FLA TOR 2013 2016 ARI
5330 5330 Fernando Rodney 39 rodnefe01 2016 MIA NL 1.269323466 -0.628881988 P 0 2 FLA SDP 2016 2016 ARI
5402 5402 Eduardo Escobar 27 escobed01 2016 MIN AL 3.517130449 -0.385 SS, 3B, 2B, LF, P 3 1 MIN CHW 2012 2018 ARI
5425 5425 John Ryan Murphy 25 murphjr01 2016 MIN AL 0.839633264 -0.465 C 0 1 MIN NYY 2016 2016 ARI
5445 5445 Wilmer Flores 24 florewi01 2016 NYM NL 3.354627072 0.615 3B, 1B, 2B, SS 6 1 NYM   2013 2018 ARI
5754 5754 Taijuan Walker 23 walketa01 2016 SEA AL 3.690225774 0.55 P 7 1 SEA   2013 2016 ARI
5759 5759 Ketel Marte 22 marteke01 2016 SEA AL 4.357949049 -0.025 SS 6 1 SEA   2015 2016 ARI
5766 5766 Chris Iannetta 33 iannech01 2016 SEA AL 3.160915834 -0.205 C 4 1 SEA ANA 2016 2016 ARI
5776 5776 Tom Wilhelmsen 32 wilheto01 2016 SEA AL 0.829995978 0.08 P 1 2 SEA TEX 2016 2016 ARI
5832 5832 Gregor Blanco 32 blancgr01 2016 SFG NL 2.694015935 -0.845 RF, LF, CF 1 1 SFG KCR 2012 2016 ARI
5864 5864 Jeremy Hazelbaker 28 hazelje01 2016 STL NL 2.203154146 0.13 LF, CF, RF 3 1 STL   2016 2016 ARI
5870 5870 Luke Weaver 22 weavelu01 2016 STL NL 0.967230315 0.06 P 2 1 STL   2016 2018 ARI
5876 5876 Carson Kelly 21 kellyca02 2016 STL NL 0.137697134 -0.055 C 0 1 STL   2016 2018 ARI
5889 5889 Matt Andriese 26 andrima01 2016 TBR AL 3.802537231 1.475 P 9 1 TBD   2015 2018 ARI
5893 5893 Steven Souza Jr. 27 souzast01 2016 TBR AL 4.508221226 0.915 RF, CF 8 1 TBD WSN 2015 2017 ARI
5922 5922 Brad Boxberger 28 boxbebr01 2016 TBR AL 0.863862007 -0.19 P 0 1 TBD SDP 2014 2017 ARI
5948 5948 Jake Diekman 29 diekmja01 2016 TEX AL 1.824294081 0.91 P 6 1 TEX PHI 2015 2018 ARI
6124 6124 Shelby Miller 24 millesh01 2015 ATL NL 5.708225966 3.5 P 19 1 ATL STL 2015 2015 ARI
6146 6146 Michael Bourn 32 bournmi01 2015 ATL NL 1.586811645 -0.25 CF, LF, RF 2 2 ATL CLE 2015 2015 ARI
6149 6149 Phil Gosselin 26 gosseph01 2015 ATL NL 0.42721852 0.235 2B, 3B, LF 1 1 ATL   2013 2015 ARI
6186 6186 Adam Jones 29 jonesad01 2015 BAL AL 5.630409357 3.38 CF 18 1 BAL SEA 2008 2018 ARI
6189 6189 Caleb Joseph 29 josepca01 2015 BAL AL 3.440267335 2.185 C, 1B 11 1 BAL   2014 2018 ARI
6217 6217 T.J. McFarland 26 mcfartj01 2015 BAL AL 1.101691877 -0.195 P 1 1 BAL   2013 2016 ARI
6224 6224 Christian Walker 24 walkech02 2015 BAL AL 0.116290727 -0.035 1B 0 1 BAL   2014 2015 ARI
6246 6246 Blake Swihart 23 swihabl01 2015 BOS AL 2.885061172 0.635 C 6 1 BOS   2015 2019 ARI
6277 6277 Deven Marrero 24 marrede01 2015 BOS AL 0.522858983 -0.39 3B, SS, 2B 0 1 BOS   2015 2017 ARI
6364 6364 Kyle Drabek 27 drabeky01 2015 CHW AL 0.082974389 -0.045 P 0 1 CHW TOR 2015 2015 ARI
6386 6386 J.J. Hoover 27 hoovejj01 2015 CIN NL 2.210523695 0.495 P 4 1 CIN   2012 2016 ARI
6419 6419 Kristopher Negron 29 negrokr01 2015 CIN NL 1.059225124 -0.57 LF, SS, 2B, CF, 1B, 3B, RF 0 1 CIN   2012 2015 ARI
6477 6477 Jorge De La Rosa 34 rosajo01 2015 COL NL 4.222661907 1.79 P 11 1 COL KCR 2008 2016 ARI
6511 6511 Daniel Descalso 28 descada01 2015 COL NL 2.108173913 -0.8 SS, 2B, 1B, 3B, RF 1 1 COL STL 2015 2016 ARI
6523 6523 J.D. Martinez 27 martijd02 2015 DET AL 6.214285714 5.106521739 RF 24 1 DET HOU 2014 2017 ARI
6637 6637 Kris Medlen 29 medlekr01 2015 KCR AL 1.666269046 0.335 P 4 1 KCR ATL 2015 2016 ARI
6713 6713 Zack Greinke 31 greinza01 2015 LAD NL 6.082160909 7.83 P 31 1 LAD ANA 2013 2015 ARI
6812 6812 Jeff Mathis 32 mathije01 2015 MIA NL 1.05361552 -0.31 C 0 1 FLA TOR 2013 2016 ARI
6813 6813 Jarrod Saltalamacchia 30 saltaja01 2015 MIA NL 0.337566138 -0.35 C, 1B 0 1 FLA BOS 2014 2015 ARI
6827 6827 Jean Segura 25 segurje01 2015 MIL NL 5.931010331 0.08 SS 9 1 MIL ANA 2012 2015 ARI
6860 6860 Tyler Wagner 24 wagnety01 2015 MIL NL 0.397934784 -0.165 P 0 1 MIL   2015 2015 ARI
6871 6871 Eduardo Escobar 26 escobed01 2015 MIN AL 4.313490078 2.005 SS, LF, 2B, 3B, RF 13 1 MIN CHW 2012 2018 ARI
6897 6897 Chris Herrmann 27 herrmch01 2015 MIN AL 1.092879773 -0.28 C, 1B, RF 1 1 MIN   2012 2015 ARI
6921 6921 Wilmer Flores 23 florewi01 2015 NYM NL 5.10616261 1.145 SS, 2B 11 1 NYM   2013 2018 ARI

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