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,310 rows where prev_franch = "CHC"

✎ 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
14 14 Alex Avila 32 avilaal01 2019 ARI NL 1.942206357 1.207358491 C, P 6 1 ARI CHC 2018 2019  
83 83 Arodys Vizcaino 28 vizcaar01 2019 ATL NL 0.131183086 0.020377358 P 0 1 ATL CHC 2015 2019  
361 361 Mike Freeman 31 freemmi01 2019 CLE AL 1.952015995 1.07490566 2B, 3B, SS, LF, P 6 1 CLE CHC 2019 2019  
410 410 Daniel Murphy 34 murphda08 2019 COL NL 4.673738238 -0.010188679 1B, 2B 7 1 COL CHC 2019 2019  
436 436 Chris Rusin 32 rusinch01 2019 COL NL 0.025468071 -0.173207547 P 0 1 COL CHC 2015 2019  
447 447 Wade Davis 33 daviswa01 2019 COL NL 1.457525983 -0.769245283 P 0 1 COL CHC 2018 2019  
460 460 Jeimer Candelario 25 candeje01 2019 DET AL 3.727380348 0.430632911 3B, 1B 5 1 DET CHC 2017 2019  
525 525 Martin Maldonado 32 maldoma01 2019 HOU AL 0.86235012 0.657169811 C, 1B 3 3 HOU CHC 2019 2019  
529 529 Hector Rondon 31 rondohe01 2019 HOU AL 1.950655209 0.295471698 P 3 1 HOU CHC 2018 2019  
548 548 Jorge Soler 27 solerjo01 2019 KCR AL 6.501762041 3.311320755 RF 18 1 KCR CHC 2017 2019  
563 563 Mike Montgomery 29 montgmi01 2019 KCR AL 1.853747526 0.422830189 P 4 2 KCR CHC 2019 2019  
568 568 Terrance Gore 28 gorete01 2019 KCR AL 0.564524249 0.376981132 RF, LF, CF 2 1 KCR CHC 2019 2019  
581 581 Randy Rosario 25 rosarra01 2019 KCR AL 0.102022201 0.096792453 P 0 2 KCR CHC 2019 2019  
605 605 Tommy La Stella 30 lasteto01 2019 LAA AL 2.952520803 1.935849057 2B, 3B, 1B 10 1 ANA CHC 2019 2019  
613 613 Felix Pena 29 penafe01 2019 LAA AL 2.736046649 0.713207547 P 6 1 ANA CHC 2018 2019  
867 867 Justin Wilson 31 wilsoju10 2019 NYM NL 1.400280427 0.789622642 P 4 1 NYM CHC 2019 2019  
871 871 Brad Brach 33 brachbr01 2019 NYM NL 0.49069656 0.310754717 P 2 2 NYM CHC 2019 2019  
918 918 Aroldis Chapman 31 chapmar01 2019 NYY AL 2.120747657 1.75754717 P 9 1 NYY CHC 2017 2019  
991 991 Brian Schlitter 33 schlibr01 2019 OAK AL 0.190060076 0.101886792 P 1 1 OAK CHC 2019 2019  
1016 1016 Jake Arrieta 33 arrieja01 2019 PHI NL 3.921029674 1.059622642 P 9 1 PHI CHC 2018 2019  
1158 1158 Carl Edwards Jr. 27 edwarca01 2019 SDP NL 0.027812844 -0.117169811 P 0 2 SDP CHC 2019 2019  
1186 1186 Anthony Bass 31 bassan01 2019 SEA AL 1.814483298 0.738679245 P 5 1 SEA CHC 2019 2019  
1310 1310 Dexter Fowler 33 fowlede01 2019 STL NL 5.653356582 1.75754717 RF, CF 14 1 STL CHC 2017 2019  
1417 1417 Jesse Chavez 35 chaveje01 2019 TEX AL 2.637622168 0.845660377 P 6 1 TEX CHC 2019 2019  
1427 1427 Luke Farrell 28 farrelu01 2019 TEX AL 0.303401695 0.234339623 P 1 1 TEX CHC 2019 2019  
1583 1583 Alex Avila 31 avilaal01 2018 ARI NL 2.329957082 0.35 C, 1B, P 4 1 ARI CHC 2018 2019  
1632 1632 Arodys Vizcaino 27 vizcaar01 2018 ATL NL 1.348752022 0.74 P 4 1 ATL CHC 2015 2019  
1893 1893 Dylan Floro 27 florody01 2018 CIN NL 1.040460768 0.515 P 3 1 CIN CHC 2018 2018 LAD
1979 1979 DJ LeMahieu 29 lemahdj01 2018 COL NL 5.767242855 2.549263804 2B 17 1 COL CHC 2012 2018 NYY
1989 1989 Wade Davis 32 daviswa01 2018 COL NL 2.632444558 0.939202454 P 7 1 COL CHC 2018 2019  
2002 2002 Chris Rusin 31 rusinch01 2018 COL NL 1.52739037 -0.342883436 P 1 1 COL CHC 2015 2019  
2017 2017 Jeimer Candelario 24 candeje01 2018 DET AL 5.973710483 2.235 3B 15 1 DET CHC 2017 2019  
2022 2022 Leonys Martin 30 martile01 2018 DET AL 3.242595674 2.0 CF, RF 10 1 DET CHC 2018 2018 CLE
2081 2081 Hector Rondon 30 rondohe01 2018 HOU AL 2.17467839 1.1 P 6 1 HOU CHC 2018 2019  
2115 2115 Jon Jay 33 jayjo02 2018 KCR AL 2.553881808 0.965 RF, LF, CF 6 1 KCR CHC 2018 2018 ARI
2116 2116 Jorge Soler 26 solerjo01 2018 KCR AL 2.467472273 0.895 RF 6 1 KCR CHC 2017 2019  
2128 2128 Jason Hammel 35 hammeja01 2018 KCR AL 3.836831591 -0.37 P 3 1 KCR CHC 2017 2018  
2152 2152 Justin Grimm 29 grimmju01 2018 KCR AL 0.46603131 -0.96 P 0 1 KCR CHC 2018 2018 SEA
2167 2167 Felix Pena 28 penafe01 2018 LAA AL 2.63829627 0.97 P 6 1 ANA CHC 2018 2019  
2181 2181 Rene Rivera 34 riverre01 2018 LAA AL 0.829116004 0.435 C, 1B 2 1 ANA CHC 2018 2018 ATL
2406 2406 Chris Gimenez 35 gimench01 2018 MIN AL 0.32159165 0.09 C, 1B, 3B, P 1 2 MIN CHC 2018 2018  
2493 2493 Aroldis Chapman 30 chapmar01 2018 NYY AL 1.960327423 1.765 P 8 1 NYY CHC 2017 2019  
2505 2505 Adam Warren 30 warread01 2018 NYY AL 0.753239625 0.505 P 3 1 NYY CHC 2016 2018 SEA
2585 2585 Jake Arrieta 32 arrieja01 2018 PHI NL 4.777097392 2.59 P 15 1 PHI CHC 2018 2019  
2695 2695 Clayton Richard 34 richacl01 2018 SDP NL 4.436024491 -0.23 P 6 1 SDP CHC 2016 2018 TOR
2722 2722 Matt Szczur 28 szczuma01 2018 SDP NL 0.844953174 -0.365 LF, RF, CF 0 1 SDP CHC 2017 2018  
2813 2813 Pierce Johnson 27 johnspi01 2018 SFG NL 0.988103599 -0.25 P 1 1 SFG CHC 2018 2018  
2862 2862 Dexter Fowler 32 fowlede01 2018 STL NL 3.29848459 -1.235 RF 1 1 STL CHC 2017 2019  
2978 2978 Eddie Butler 27 butleed01 2018 TEX AL 0.937488359 -0.61 P 0 2 TEX CHC 2018 2018  
3154 3154 Arodys Vizcaino 26 vizcaar01 2017 ATL NL 2.301958209 1.14 P 7 1 ATL CHC 2015 2019  
3366 3366 Zach Putnam 29 putnaza01 2017 CHW AL 0.290564272 0.375 P 1 1 CHW CHC 2014 2017  
3423 3423 Jake Buchanan 27 buchaja01 2017 CIN NL 0.292387143 -0.095 P 0 1 CIN CHC 2017 2017  
3479 3479 DJ LeMahieu 28 lemahdj01 2017 COL NL 6.745566166 2.39 2B 18 1 COL CHC 2012 2018 NYY
3486 3486 Chris Rusin 30 rusinch01 2017 COL NL 2.851548128 1.82 P 10 1 COL CHC 2015 2019  
3508 3508 Zac Rosscup 29 rosscza01 2017 COL NL 0.146237147 0.06 P 0 2 COL CHC 2017 2017 LAD
3535 3535 Jeimer Candelario 23 candeje01 2017 DET AL 1.003263708 0.485 3B, 1B 3 2 DET CHC 2017 2019  
3620 3620 Jason Hammel 34 hammeja01 2017 KCR AL 5.03537908 1.73 P 13 1 KCR CHC 2017 2018  
3641 3641 Travis Wood 30 woodtr01 2017 KCR AL 1.188328956 -0.225 P 1 1 KCR CHC 2017 2017 SDP
3661 3661 Jorge Soler 25 solerjo01 2017 KCR AL 1.063333333 -1.12 RF, LF 0 1 KCR CHC 2017 2019  
3850 3850 Quintin Berry 32 berryqu01 2017 MIL NL 0.029902045 -0.03 LF, CF 0 1 MIL CHC 2017 2017  
3975 3975 Starlin Castro 27 castrst01 2017 NYY AL 4.334650024 1.955 2B 11 1 NYY CHC 2016 2017 FLA
3982 3982 Adam Warren 29 warread01 2017 NYY AL 1.886028606 1.3 P 6 1 NYY CHC 2016 2018 SEA
3983 3983 Aroldis Chapman 29 chapmar01 2017 NYY AL 1.936780763 1.23 P 6 1 NYY CHC 2017 2019  
4147 4147 Jack Leathersich 26 leathja01 2017 PIT NL 0.147646664 0.19 P 1 2 PIT CHC 2017 2017  
4172 4172 Clayton Richard 33 richacl01 2017 SDP NL 5.617328711 1.54 P 14 1 SDP CHC 2016 2018 TOR
4182 4182 Trevor Cahill 29 cahiltr01 2017 SDP NL 1.727201389 1.33 P 7 1 SDP CHC 2017 2017 KCR
4185 4185 Matt Szczur 27 szczuma01 2017 SDP NL 2.197981229 0.38 LF, CF, RF 5 2 SDP CHC 2017 2018  
4309 4309 Tim Federowicz 29 federti01 2017 SFG NL 0.139542877 0.115 C, 1B 1 1 SFG CHC 2017 2017 HOU
4337 4337 Dexter Fowler 31 fowlede01 2017 STL NL 4.835795551 2.095 CF 13 1 STL CHC 2017 2019  
4377 4377 Miguel Socolovich 30 socolmi01 2017 STL NL 0.397095597 -0.38 P 0 1 STL CHC 2015 2017 ATL
4502 4502 Joe Smith 33 smithjo05 2017 TOR AL 1.203146251 0.905 P 4 1 TOR CHC 2017 2017 CLE
4506 4506 Brett Anderson 29 anderbr04 2017 TOR AL 0.891957472 0.46 P 3 2 TOR CHC 2017 2017 OAK
4539 4539 Miguel Montero 33 montemi01 2017 TOR AL 0.955628059 -0.555 C, 1B, P 0 2 TOR CHC 2017 2017 WSN
4540 4540 Chris Coghlan 32 coghlch01 2017 TOR AL 0.832626427 -0.595 3B, LF, 2B 0 1 TOR CHC 2017 2017  
4670 4670 Arodys Vizcaino 25 vizcaar01 2016 ATL NL 1.374708176 -0.115714286 P 2 1 ATL CHC 2015 2019  
4742 4742 Julio Borbon 30 borboju01 2016 BAL AL 0.14354067 -0.195 CF, LF 0 1 BAL CHC 2016 2016  
4861 4861 Zach Putnam 28 putnaza01 2016 CHW AL 0.732415548 0.575 P 3 1 CHW CHC 2014 2017  
4868 4868 Austin Jackson 29 jacksau01 2016 CHW AL 1.927320347 -0.105 CF 2 1 CHW CHC 2016 2016 CLE
4890 4890 Jacob Turner 25 turneja01 2016 CHW AL 0.664612088 -0.835 P 0 1 CHW CHC 2016 2016 WSN
4929 4929 Rafael Lopez 28 lopezra02 2016 CIN NL 0.070400555 -0.185 C, 1B 0 1 CIN CHC 2016 2016 TOR
4971 4971 Tommy Hunter 29 hunteto02 2016 CLE AL 0.604598477 0.246521739 P 2 1 CLE CHC 2016 2016 BAL
4995 4995 DJ LeMahieu 27 lemahdj01 2016 COL NL 6.24343109 4.84 2B 22 1 COL CHC 2012 2018 NYY
5003 5003 Chris Rusin 29 rusinch01 2016 COL NL 2.51635277 1.74 P 8 1 COL CHC 2015 2019  
5023 5023 Gonzalez Germen 28 germego01 2016 COL NL 1.125852794 -0.125 P 1 1 COL CHC 2015 2016  
5031 5031 Jason Motte 34 motteja01 2016 COL NL 0.69889004 -0.17 P 0 1 COL CHC 2016 2016 ATL
5091 5091 Luis Valbuena 30 valbulu01 2016 HOU AL 3.209189452 2.42 3B, 1B, 2B 11 1 HOU CHC 2015 2016 ANA
5367 5367 Neil Ramirez 27 ramirne01 2016 MIL NL 0.032640354 -0.085 P 0 2 MIL CHC 2016 2016 MIN
5483 5483 Starlin Castro 26 castrst01 2016 NYY AL 5.858585859 1.29 2B, SS 13 1 NYY CHC 2016 2017 FLA
5500 5500 Adam Warren 28 warread01 2016 NYY AL 1.028929408 0.315 P 2 2 NYY CHC 2016 2018 SEA
5571 5571 Arismendy Alcantara 24 alcanar01 2016 OAK AL 0.183727909 -0.27 CF, 2B, SS, RF 0 1 OAK CHC 2016 2016 CIN
5579 5579 Chris Coghlan 31 coghlch01 2016 OAK AL 1.663221074 -1.41 LF, 2B, 3B, RF, 1B 0 1 OAK CHC 2016 2016 CHC
5622 5622 James Russell 30 russeja02 2016 PHI NL 0.125194063 -0.455 P 0 1 PHI CHC 2016 2016  
5698 5698 Fernando Rodney 39 rodnefe01 2016 SDP NL 1.127286486 1.27 P 5 1 SDP CHC 2016 2016 FLA
5701 5701 Clayton Richard 32 richacl01 2016 SDP NL 1.425935923 0.675 P 4 2 SDP CHC 2016 2018 TOR
5702 5702 Andrew Cashner 29 cashnan01 2016 SDP NL 2.252447354 0.065 P 4 1 SDP CHC 2012 2016 FLA
5779 5779 Blake Parker 31 parkebl01 2016 SEA AL 0.048036935 0.05 P 0 1 SEA CHC 2016 2016 NYY
5787 5787 Donn Roach 26 roachdo01 2016 SEA AL 0.198219688 -0.18 P 0 1 SEA CHC 2016 2016  
5827 5827 Joe Nathan 41 nathajo01 2016 SFG NL 0.17221093 0.225 P 1 2 SFG CHC 2016 2016  
5871 5871 Miguel Socolovich 29 socolmi01 2016 STL NL 0.372996761 0.275 P 1 1 STL CHC 2015 2017 ATL
6135 6135 Arodys Vizcaino 24 vizcaar01 2015 ATL NL 1.196184341 1.05 P 5 1 ATL CHC 2015 2019  

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