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

580 rows where prev_franch = "ARI"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, year_ID, lg_ID, quasi_ws, franch_id, year_left, 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
60 60 Ender Inciarte 28 inciaen01 2019 ATL NL 2.281121751 0.753962264 CF 6 1 ATL ARI 2016 2019  
84 84 John Ryan Murphy 28 murphjr01 2019 ATL NL 0.009917921 -0.015283019 C, P 0 2 ATL ARI 2019 2019  
157 157 J.D. Martinez 31 martijd02 2019 BOS AL 5.926206244 3.24 RF, LF 17 1 BOS ARI 2018 2019  
238 238 Allen Webster 29 webstal01 2019 CHC NL 0.298373941 -0.081509434 P 0 1 CHC ARI 2018 2019  
251 251 Daniel Descalso 32 descada01 2019 CHC NL 1.941422594 -1.151320755 2B, 3B, 1B, P 0 1 CHC ARI 2019 2019  
296 296 Jon Jay 34 jayjo02 2019 CHW AL 1.784313725 -0.871518987 RF, LF 0 1 CHW ARI 2019 2019  
344 344 David Hernandez 34 hernada01 2019 CIN NL 1.583307188 -0.784528302 P 0 1 CIN ARI 2018 2019  
352 352 Trevor Bauer 28 bauertr01 2019 CLE AL 4.549457782 2.358679245 P 14 1 CLE ARI 2013 2019 CIN
431 431 Chris Iannetta 36 iannech01 2019 COL NL 1.627373824 -0.478867925 C 1 1 COL ARI 2018 2019  
517 517 Zack Greinke 35 greinza01 2019 HOU AL 1.816800825 1.548679245 P 7 2 HOU ARI 2019 2019  
518 518 Will Harris 34 harriwi10 2019 HOU AL 2.026526588 1.533396226 P 7 1 HOU ARI 2015 2019  
565 565 Jake Diekman 32 diekmja01 2019 KCR AL 1.561827726 0.509433962 P 3 1 KCR ARI 2019 2019 OAK
577 577 Brad Boxberger 31 boxbebr01 2019 KCR AL 0.834351605 -0.020377358 P 1 1 KCR ARI 2019 2019  
597 597 Chris Owings 27 owingch01 2019 KCR AL 1.411310623 -0.820188679 2B, 3B, CF, SS, RF, LF, P 0 1 KCR ARI 2019 2019 BOS
608 608 Tyler Skaggs 27 skaggty01 2019 LAA AL 2.312139711 1.406037736 P 7 1 ANA ARI 2014 2019  
674 674 A.J. Pollock 31 polloaj01 2019 LAD NL 3.368257798 0.616415094 CF, LF 7 1 LAD ARI 2019 2019  
735 735 Deven Marrero 28 marrede01 2019 MIA NL 0.051509769 -0.112075472 SS, 3B 0 1 FLA ARI 2019 2019  
743 743 Peter O'Brien 28 obriepe01 2019 MIA NL 0.484191829 -0.565471698 RF, LF, 1B 0 1 FLA ARI 2018 2019  
762 762 Chase Anderson 31 anderch01 2019 MIL NL 3.673358098 1.421320755 P 10 1 MIL ARI 2016 2019  
921 921 Didi Gregorius 29 gregodi01 2019 NYY AL 3.200589487 0.850754717 SS 8 1 NYY ARI 2015 2019  
950 950 Jake Barrett 27 barreja01 2019 NYY AL 0.068035077 -0.142641509 P 0 1 NYY ARI 2019 2019  
1045 1045 Fernando Salas 34 salasfe01 2019 PHI NL 0.054934181 -0.010188679 P 0 1 PHI ARI 2019 2019  
1179 1179 Mitch Haniger 28 hanigmi01 2019 SEA AL 2.705901747 1.258301887 RF, CF 7 1 SEA ARI 2017 2019  
1206 1206 Kristopher Negron 33 negrokr01 2019 SEA AL 0.239037257 0.096792453 CF, RF, LF, SS, 2B, 3B 1 1 SEA ARI 2018 2019 LAD
1305 1305 Paul Goldschmidt 31 goldspa01 2019 STL NL 6.74559721 3.046415094 1B 20 1 STL ARI 2019 2019  
1390 1390 Anthony Banda 25 bandaan01 2019 TBR AL 0.046073721 0.071320755 P 0 1 TBD ARI 2018 2019  
1452 1452 Shelby Miller 28 millesh01 2019 TEX AL 1.184800841 -0.570566038 P 0 1 TEX ARI 2019 2019  
1454 1454 Jeff Mathis 36 mathije01 2019 TEX AL 2.335313531 -1.823773585 C, P 0 1 TEX ARI 2019 2019  
1489 1489 Zack Godley 29 godleza01 2019 TOR AL 0.418967738 0.13245283 P 1 2 TOR ARI 2019 2019  
1496 1496 Clay Buchholz 34 buchhcl01 2019 TOR AL 1.583359363 -0.259811321 P 1 1 TOR ARI 2019 2019  
1513 1513 Socrates Brito 26 britoso01 2019 TOR AL 0.418035535 -0.723396226 RF, CF, LF 0 1 TOR ARI 2019 2019  
1518 1518 Patrick Corbin 29 corbipa01 2019 WSN NL 5.695048435 5.328679245 P 23 1 WSN ARI 2019 2019  
1616 1616 Ender Inciarte 27 inciaen01 2018 ATL NL 6.462941077 3.195 CF 19 1 ATL ARI 2016 2019  
1729 1729 J.D. Martinez 30 martijd02 2018 BOS AL 5.992040751 6.14 LF, RF 28 1 BOS ARI 2018 2019  
1798 1798 Jorge De La Rosa 37 rosajo01 2018 CHC NL 0.569170286 0.511840491 P 2 2 CHC ARI 2018 2018  
1813 1813 Allen Webster 28 webstal01 2018 CHC NL 0.057955029 -0.059631902 P 0 1 CHC ARI 2018 2019  
1829 1829 Matt Davidson 27 davidma02 2018 CHW AL 4.755041322 1.065 1B, 3B, P 9 1 CHW ARI 2016 2018  
1884 1884 David Hernandez 33 hernada01 2018 CIN NL 2.237869844 1.435 P 7 1 CIN ARI 2018 2019  
1929 1929 Trevor Bauer 27 bauertr01 2018 CLE AL 4.977575604 5.755 P 23 1 CLE ARI 2013 2019 CIN
1966 1966 Adam Rosales 35 rosalad01 2018 CLE AL 0.194134523 -0.045 1B, 2B, 3B, SS 0 1 CLE ARI 2018 2018  
1992 1992 Chris Iannetta 35 iannech01 2018 COL NL 3.57350676 0.094417178 C 6 1 COL ARI 2018 2019  
2085 2085 Tony Sipp 34 sippto01 2018 HOU AL 1.165055035 1.045 P 5 1 HOU ARI 2014 2018 WSN
2086 2086 Will Harris 33 harriwi10 2018 HOU AL 1.616235957 0.88 P 5 1 HOU ARI 2015 2019  
2163 2163 Tyler Skaggs 26 skaggty01 2018 LAA AL 3.726936185 1.865 P 10 1 ANA ARI 2014 2019  
2283 2283 Peter O'Brien 27 obriepe01 2018 MIA NL 0.74 0.628881988 1B, RF 3 1 FLA ARI 2018 2019  
2330 2330 Chase Anderson 30 anderch01 2018 MIL NL 4.277050408 0.526748466 P 8 1 MIL ARI 2016 2019  
2367 2367 J.J. Hoover 30 hoovejj01 2018 MIL NL 0.054622409 -0.268343558 P 0 1 MIL ARI 2018 2018  
2387 2387 Fernando Rodney 41 rodnefe01 2018 MIN AL 1.763617976 0.655 P 5 1 MIN ARI 2018 2018 OAK
2463 2463 Jack Reinheimer 25 reinhja01 2018 NYM NL 0.347364819 -0.2 LF, 3B, SS, 2B 0 1 NYM ARI 2018 2018  
2485 2485 Didi Gregorius 28 gregodi01 2018 NYY AL 5.281164986 4.46 SS 20 1 NYY ARI 2015 2019  
2528 2528 Brandon Drury 25 drurybr01 2018 NYY AL 0.529044647 -0.41 3B, 2B, 1B, SS 0 1 NYY ARI 2018 2018 TOR
2728 2728 Mitch Haniger 27 hanigmi01 2018 SEA AL 6.531574608 5.31 RF, CF, LF 26 1 SEA ARI 2017 2019  
2729 2729 Jean Segura 28 segurje01 2018 SEA AL 6.043858203 4.02 SS 22 1 SEA ARI 2017 2018 PHI
2749 2749 Chris Herrmann 30 herrmch01 2018 SEA AL 0.83198681 0.55 C, 1B 3 1 SEA ARI 2018 2018 OAK
2763 2763 Kristopher Negron 32 negrokr01 2018 SEA AL 0.286892003 0.025 3B, LF, 2B, SS, RF 1 2 SEA ARI 2018 2019 LAD
2816 2816 Gregor Blanco 34 blancgr01 2018 SFG NL 2.03035006 -0.725 LF, CF, RF 1 1 SFG ARI 2018 2018  
2916 2916 Anthony Banda 24 bandaan01 2018 TBR AL 0.347253118 0.24 P 1 1 TBD ARI 2018 2019  
3144 3144 Ender Inciarte 26 inciaen01 2017 ATL NL 7.065490329 2.88 CF 19 1 ATL ARI 2016 2019  
3190 3190 Josh Collmenter 31 collmjo01 2017 ATL NL 0.456768434 -0.63 P 0 1 ATL ARI 2016 2017  
3198 3198 Welington Castillo 30 castiwe01 2017 BAL AL 3.458020255 2.08 C 12 1 BAL ARI 2017 2017 CHW
3318 3318 Miguel Montero 33 montemi01 2017 CHC NL 1.094892972 0.25 C, 1B, P 2 1 CHC ARI 2015 2017 TOR
3361 3361 Matt Davidson 26 davidma02 2017 CHW AL 4.254677927 -0.895 3B, 1B 3 1 CHW ARI 2016 2018  
3433 3433 Bronson Arroyo 40 arroybr01 2017 CIN NL 2.127243958 -1.085 P 0 1 CIN ARI 2017 2017  
3441 3441 Trevor Bauer 26 bauertr01 2017 CLE AL 5.063017046 2.97 P 15 1 CLE ARI 2013 2019 CIN
3454 3454 Bryan Shaw 29 shawbr01 2017 CLE AL 2.599421333 1.07 P 6 1 CLE ARI 2013 2017 COL
3587 3587 Will Harris 32 harriwi10 2017 HOU AL 1.741338498 0.915 P 5 1 HOU ARI 2015 2019  
3612 3612 Tony Sipp 33 sippto01 2017 HOU AL 0.888544581 -0.26 P 0 1 HOU ARI 2014 2018 WSN
3676 3676 Tyler Skaggs 25 skaggty01 2017 LAA AL 2.378962367 0.675 P 6 1 ANA ARI 2014 2019  
3816 3816 Chase Anderson 29 anderch01 2017 MIL NL 3.879476414 3.58 P 16 1 MIL ARI 2016 2019  
3926 3926 Addison Reed 28 reedad01 2017 NYM NL 2.017205965 1.29 P 6 1 NYM ARI 2015 2017 BOS
3970 3970 Didi Gregorius 27 gregodi01 2017 NYY AL 5.223574024 3.915 SS, LF 17 1 NYY ARI 2015 2019  
4000 4000 Tyler Clippard 32 clippty01 2017 NYY AL 1.282938063 -0.135 P 1 1 NYY ARI 2016 2017 CHW
4064 4064 Cesar Valdez 32 valdece01 2017 OAK AL 0.200159262 -0.24 P 0 1 OAK ARI 2017 2017 TOR
4083 4083 Jeremy Hellickson 30 hellije01 2017 PHI NL 3.180410445 0.8 P 6 1 PHI ARI 2016 2017 BAL
4141 4141 A.J. Schugel 28 schugaj01 2017 PIT NL 0.890747456 0.575 P 3 1 PIT ARI 2016 2017  
4143 4143 Daniel Hudson 30 hudsoda01 2017 PIT NL 1.922905128 0.075 P 3 1 PIT ARI 2017 2017 LAD
4165 4165 Phil Gosselin 28 gosseph01 2017 PIT NL 0.419060726 -0.59 2B, SS, 3B, 1B 0 1 PIT ARI 2017 2017 TEX
4226 4226 Jean Segura 27 segurje01 2017 SEA AL 5.347450725 3.1 SS 16 1 SEA ARI 2017 2018 PHI
4227 4227 Mitch Haniger 26 hanigmi01 2017 SEA AL 3.873595048 2.745 RF, CF, LF 13 1 SEA ARI 2017 2019  
4265 4265 Zac Curtis 24 curtiza01 2017 SEA AL 0.076647646 -0.05 P 0 1 SEA ARI 2017 2017 PHI
4272 4272 Evan Marshall 27 marshev01 2017 SEA AL 0.158819447 -0.18 P 0 1 SEA ARI 2017 2017 CLE
4280 4280 Mike Freeman 29 freemmi01 2017 SEA AL 0.321224955 -0.51 SS, 1B, 2B, 3B, P 0 1 SEA ARI 2016 2017 LAD
4281 4281 Tuffy Gosewisch 33 gosewtu01 2017 SEA AL 0.292881577 -0.58 C, 1B 0 1 SEA ARI 2017 2017  
4410 4410 Rickie Weeks 34 weeksri01 2017 TBR AL 1.061091147 0.17 1B 2 1 TBD ARI 2017 2017  
4491 4491 Dominic Leone 25 leonedo01 2017 TOR AL 2.242419039 1.78 P 9 1 TOR ARI 2017 2017 STL
4644 4644 Ender Inciarte 25 inciaen01 2016 ATL NL 5.703300442 3.481490683 CF, LF 19 1 ATL ARI 2016 2019  
4665 4665 Josh Collmenter 30 collmjo01 2016 ATL NL 0.529751437 0.30689441 P 2 2 ATL ARI 2016 2017  
4667 4667 Jhoulys Chacin 28 chacijh01 2016 ATL NL 0.719907272 0.211304348 P 2 1 ATL ARI 2016 2016 ANA
4728 4728 Nolan Reimold 32 reimono01 2016 BAL AL 2.172248804 -0.34 LF, RF, CF 2 1 BAL ARI 2015 2016  
4731 4731 Michael Bourn 33 bournmi01 2016 BAL AL 0.526315789 0.215 CF, LF, RF 1 2 BAL ARI 2016 2016  
4765 4765 Brad Ziegler 36 zieglbr01 2016 BOS AL 1.193800735 0.87 P 4 2 BOS ARI 2016 2016 FLA
4815 4815 Miguel Montero 32 montemi01 2016 CHC NL 2.775400168 0.325 C, P 5 1 CHC ARI 2015 2017 TOR
4844 4844 Adam Eaton 27 eatonad02 2016 CHW AL 6.702897365 5.98 RF, CF, LF 27 1 CHW ARI 2014 2016 WSN
4874 4874 Matt Davidson 25 davidma02 2016 CHW AL 0.018988378 0.005   0 1 CHW ARI 2016 2018  
4940 4940 Jordan Pacheco 30 pachejo01 2016 CIN NL 0.512918328 -0.595 3B, 1B, 2B 0 1 CIN ARI 2016 2016  
4951 4951 Trevor Bauer 25 bauertr01 2016 CLE AL 5.272891638 2.379689441 P 15 1 CLE ARI 2013 2019 CIN
4961 4961 Bryan Shaw 28 shawbr01 2016 CLE AL 2.348251337 0.825093168 P 6 1 CLE ARI 2013 2017 COL
5067 5067 Jarrod Saltalamacchia 31 saltaja01 2016 DET AL 2.77457405 -0.598695652 C, 1B 2 1 DET ARI 2016 2016 TOR
5098 5098 Will Harris 31 harriwi10 2016 HOU AL 2.336334547 1.665 P 8 1 HOU ARI 2015 2019  
5125 5125 Tony Sipp 32 sippto01 2016 HOU AL 1.176263191 -0.595 P 0 1 HOU ARI 2014 2018 WSN

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