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,306 rows where next_franch = "TOR"

✎ 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
37 37 Zack Godley 29 godleza01 2019 ARI NL 1.876806232 -0.397358491 P 1 1 ARI   2015 2019 TOR
392 392 Neil Ramirez 30 ramirne01 2019 CLE AL 0.408928393 -0.168113208 P 0 1 CLE NYM 2018 2019 TOR
535 535 Derek Fisher 25 fishede01 2019 HOU AL 0.556354916 0.198679245 LF, RF, CF 1 1 HOU   2017 2019 TOR
695 695 Brock Stewart 27 stewabr01 2019 LAD NL 0.063549858 -0.096792453 P 0 1 LAD   2016 2019 TOR
878 878 Wilmer Font 29 fontwi01 2019 NYM NL 0.810332864 -0.076415094 P 1 2 NYM TBD 2019 2019 TOR
940 940 Breyvic Valera 27 valerbr01 2019 NYY AL 0.351400033 0.00509434 2B, SS 1 1 NYY BAL 2019 2019 TOR
992 992 Beau Taylor 29 taylobe11 2019 OAK AL 0.264581297 0.076415094 C 1 1 OAK   2018 2019 TOR
1115 1115 Nick Kingham 27 kinghni01 2019 PIT NL 1.206616136 -0.845660377 P 0 1 PIT   2018 2019 TOR
1207 1207 Zac Rosscup 31 rosscza01 2019 SEA AL 0.474871854 0.066226415 P 1 1 SEA LAD 2019 2019 TOR
1572 1572 Clay Buchholz 33 buchhcl01 2018 ARI NL 2.635512471 2.29 P 11 1 ARI PHI 2018 2018 TOR
1574 1574 Zack Godley 28 godleza01 2018 ARI NL 4.960510143 0.575 P 9 1 ARI   2015 2019 TOR
1608 1608 Socrates Brito 25 britoso01 2018 ARI NL 0.438111588 -0.34 RF, LF, CF 0 1 ARI   2015 2018 TOR
1951 1951 Neil Ramirez 29 ramirne01 2018 CLE AL 1.363429379 -0.04 P 2 1 CLE NYM 2018 2019 TOR
2094 2094 Ken Giles 27 gileske01 2018 HOU AL 0.919523685 0.295 P 2 1 HOU PHI 2016 2018 TOR
2097 2097 Derek Fisher 24 fishede01 2018 HOU AL 0.814899526 0.05 LF, CF, RF 1 1 HOU   2017 2019 TOR
2145 2145 Jason Adam 26 adamja01 2018 KCR AL 0.822085613 -0.315 P 0 1 KCR   2018 2018 TOR
2182 2182 Matt Shoemaker 31 shoemma01 2018 LAA AL 0.916918674 0.345 P 2 1 ANA   2013 2018 TOR
2197 2197 Oliver Drake 31 drakeol01 2018 LAA AL 0.193285254 -0.01 P 0 3 ANA CLE 2018 2018 TOR
2252 2252 Daniel Hudson 31 hudsoda01 2018 LAD NL 1.33880385 -0.248466258 P 1 1 LAD PIT 2018 2018 TOR
2264 2264 Brock Stewart 26 stewabr01 2018 LAD NL 0.447996926 -0.462147239 P 0 1 LAD   2016 2019 TOR
2312 2312 Javy Guerra 32 guerrja01 2018 MIA NL 1.086779093 -0.543354037 P 0 1 FLA ANA 2017 2018 TOR
2369 2369 Eric Sogard 32 sogarer01 2018 MIL NL 1.108030431 -0.829877301 SS, 2B, LF 0 1 MIL OAK 2017 2018 TOR
2525 2525 Billy McKinney 23 mckinbi01 2018 NYY AL 0.03712594 -0.165 LF, RF, 1B 0 1 NYY   2018 2018 TOR
2528 2528 Brandon Drury 25 drurybr01 2018 NYY AL 0.529044647 -0.41 3B, 2B, 1B, SS 0 1 NYY ARI 2018 2018 TOR
2543 2543 Edwin Jackson 34 jacksed01 2018 OAK AL 2.534822616 1.14 P 7 1 OAK WSN 2018 2018 TOR
2571 2571 Beau Taylor 28 taylobe11 2018 OAK AL 0.055822907 0.015 C 0 1 OAK   2018 2019 TOR
2629 2629 Mark Leiter Jr. 27 leitema02 2018 PHI NL 0.377271644 -0.465 P 0 1 PHI   2017 2018 TOR
2659 2659 Nick Kingham 26 kinghni01 2018 PIT NL 2.040107926 -0.372298137 P 2 1 PIT   2018 2019 TOR
2679 2679 Freddy Galvis 28 galvifr01 2018 SDP NL 6.598681929 1.77 SS, 2B 15 1 SDP PHI 2018 2018 TOR
2695 2695 Clayton Richard 34 richacl01 2018 SDP NL 4.436024491 -0.23 P 6 1 SDP CHC 2016 2018 TOR
2795 2795 Alen Hanson 25 hansoal01 2018 SFG NL 3.100534575 0.56 2B, LF, SS, 3B, RF 6 1 SFG CHW 2018 2018 TOR
2822 2822 Derek Law 27 lawde01 2018 SFG NL 0.278650308 -0.2 P 0 1 SFG   2016 2018 TOR
2869 2869 Preston Guilmet 30 guilmpr01 2018 STL NL 0.047454703 -0.245 P 0 1 STL MIL 2018 2018 TOR
3090 3090 Jimmy Cordero 26 cordeji01 2018 WSN NL 0.497214554 -0.165 P 0 1 WSN   2018 2018 TOR
3101 3101 Zack Godley 27 godleza01 2017 ARI NL 4.328230522 3.43 P 16 1 ARI   2015 2019 TOR
3318 3318 Miguel Montero 33 montemi01 2017 CHC NL 1.094892972 0.25 C, 1B, P 2 1 CHC ARI 2015 2017 TOR
3337 3337 Brett Anderson 29 anderbr04 2017 CHC NL 0.60997247 -0.265 P 0 1 CHC LAD 2017 2017 TOR
3384 3384 Jake Petricka 29 petrija01 2017 CHW AL 0.824495615 -0.375 P 0 1 CHW   2013 2017 TOR
3413 3413 Deck McGuire 28 mcguide02 2017 CIN NL 0.322348325 0.23 P 1 1 CIN   2017 2017 TOR
3476 3476 Gio Urshela 25 urshegi01 2017 CLE AL 1.540318687 -0.655 3B, 2B, SS, 1B 0 1 CLE   2015 2017 TOR
3580 3580 Ken Giles 26 gileske01 2017 HOU AL 2.350505703 1.92 P 9 1 HOU PHI 2016 2018 TOR
3590 3590 Derek Fisher 23 fishede01 2017 HOU AL 1.542454342 0.145 LF, RF, CF 3 1 HOU   2017 2019 TOR
3591 3591 Nori Aoki 35 aokino01 2017 HOU AL 2.081384172 0.135 LF, RF, CF, P 3 1 HOU SEA 2017 2017 TOR
3599 3599 David Paulino 23 paulida01 2017 HOU AL 0.821261029 -0.11 P 1 1 HOU   2016 2017 TOR
3602 3602 Teoscar Hernandez 24 hernate01 2017 HOU AL 0.0 0.0 LF, CF, RF 0 1 HOU   2016 2017 TOR
3607 3607 Tyler Clippard 32 clippty01 2017 HOU AL 0.407015279 -0.17 P 0 3 HOU CHW 2017 2017 TOR
3635 3635 Sam Gaviglio 27 gavigsa01 2017 KCR AL 0.258022924 0.305 P 1 2 KCR SEA 2017 2017 TOR
3684 3684 Matt Shoemaker 30 shoemma01 2017 LAA AL 2.173718555 0.415 P 4 1 ANA   2013 2018 TOR
3746 3746 Brock Stewart 25 stewabr01 2017 LAD NL 0.77480412 -0.05 P 1 1 LAD   2016 2019 TOR
3748 3748 Curtis Granderson 36 grandcu01 2017 LAD NL 1.305593452 -0.215 CF, RF, LF 1 2 LAD NYM 2017 2017 TOR
3797 3797 Javy Guerra 31 guerrja01 2017 MIA NL 0.650063053 0.2 P 1 1 FLA ANA 2017 2018 TOR
3811 3811 Tom Koehler 31 koehlto01 2017 MIA NL 1.59585422 -1.405 P 0 1 FLA   2012 2017 TOR
3822 3822 Eric Sogard 31 sogarer01 2017 MIL NL 2.980237154 1.49 2B, SS, 3B, LF 9 1 MIL OAK 2017 2018 TOR
3893 3893 Buddy Boshers 29 boshebu01 2017 MIN AL 0.982525652 -0.115 P 1 1 MIN ANA 2016 2017 TOR
3911 3911 Nick Tepesch 28 tepesni01 2017 MIN AL 0.04729274 -0.225 P 0 1 MIN LAD 2017 2017 TOR
3997 3997 Jaime Garcia 30 garcija02 2017 NYY AL 1.05347192 0.09 P 1 3 NYY MIN 2017 2017 TOR
4013 4013 Rob Refsnyder 26 refsnro01 2017 NYY AL 0.366566598 -0.25 2B, LF, 1B, RF 0 1 NYY   2015 2017 TOR
4064 4064 Cesar Valdez 32 valdece01 2017 OAK AL 0.200159262 -0.24 P 0 1 OAK ARI 2017 2017 TOR
4065 4065 John Axford 34 axforjo01 2017 OAK AL 0.543646852 -0.295 P 0 1 OAK COL 2016 2017 TOR
4097 4097 Mark Leiter Jr. 26 leitema02 2017 PHI NL 2.292435044 -0.035 P 3 1 PHI   2017 2018 TOR
4119 4119 Michael Saunders 30 saundmi01 2017 PHI NL 2.130084091 -0.72 RF, LF 0 1 PHI TOR 2017 2017 TOR
4152 4152 Gift Ngoepe 27 ngoepgi01 2017 PIT NL 0.628591089 0.03 2B, SS, 3B 1 1 PIT   2017 2017 TOR
4172 4172 Clayton Richard 33 richacl01 2017 SDP NL 5.617328711 1.54 P 14 1 SDP CHC 2016 2018 TOR
4175 4175 Yangervis Solarte 29 solarya01 2017 SDP NL 5.258721445 1.035 2B, SS, 3B, 1B 12 1 SDP NYY 2014 2017 TOR
4253 4253 David Phelps 30 phelpda01 2017 SEA AL 0.369329198 0.21 P 1 2 SEA FLA 2017 2017 TOR
4307 4307 Derek Law 26 lawde01 2017 SFG NL 1.146331711 0.04 P 2 1 SFG   2016 2018 TOR
4343 4343 Randal Grichuk 25 grichra01 2017 STL NL 4.353200883 1.275 LF, RF, CF 9 1 STL   2014 2017 TOR
4355 4355 Seunghwan Oh 34 ohse01 2017 STL NL 2.277250027 -0.07 P 3 1 STL   2016 2017 TOR
4356 4356 Aledmys Diaz 26 diazal02 2017 STL NL 2.964510104 -0.18 SS, 3B, LF, 2B 3 1 STL   2016 2017 TOR
4478 4478 Mike Hauschild 27 hauscmi01 2017 TEX AL 0.169266432 -0.315 P 0 1 TEX   2017 2017 TOR
4621 4621 Zack Godley 26 godleza01 2016 ARI NL 2.077224232 -0.305 P 2 1 ARI   2015 2019 TOR
4635 4635 Dominic Leone 24 leonedo01 2016 ARI NL 0.600911296 -0.365 P 0 1 ARI SEA 2015 2016 TOR
4636 4636 Socrates Brito 23 britoso01 2016 ARI NL 0.949375633 -0.38 CF, RF, LF 0 1 ARI   2015 2018 TOR
4678 4678 Jason Grilli 39 grillja01 2016 ATL NL 0.591858192 -0.115714286 P 1 1 ATL ANA 2015 2016 TOR
4727 4727 Steve Pearce 33 pearcst01 2016 BAL AL 0.669856459 0.185 1B, 2B, LF, RF, 3B 2 2 BAL TBD 2016 2016 TOR
4815 4815 Miguel Montero 32 montemi01 2016 CHC NL 2.775400168 0.325 C, P 5 1 CHC ARI 2015 2017 TOR
4816 4816 Chris Coghlan 31 coghlch01 2016 CHC NL 1.250884583 0.905 LF, 2B, 3B, RF, 1B 4 2 CHC OAK 2016 2016 TOR
4831 4831 Joe Smith 32 smithjo05 2016 CHC NL 0.383389469 0.035 P 1 2 CHC ANA 2016 2016 TOR
4871 4871 Dioner Navarro 32 navardi01 2016 CHW AL 2.829268293 -1.095 C 1 1 CHW TOR 2016 2016 TOR
4879 4879 Jake Petricka 28 petrija01 2016 CHW AL 0.236867985 -0.075 P 0 1 CHW   2013 2017 TOR
4929 4929 Rafael Lopez 28 lopezra02 2016 CIN NL 0.070400555 -0.185 C, 1B 0 1 CIN CHC 2016 2016 TOR
4981 4981 T.J. House 26 housetj01 2016 CLE AL 0.062620036 0.02515528 P 0 1 CLE   2014 2016 TOR
5067 5067 Jarrod Saltalamacchia 31 saltaja01 2016 DET AL 2.77457405 -0.598695652 C, 1B 2 1 DET ARI 2016 2016 TOR
5103 5103 Ken Giles 25 gileske01 2016 HOU AL 2.47450487 0.585 P 5 1 HOU PHI 2016 2018 TOR
5106 5106 Scott Feldman 33 feldmsc01 2016 HOU AL 1.797882444 0.305 P 3 1 HOU BAL 2014 2016 TOR
5110 5110 Teoscar Hernandez 23 hernate01 2016 HOU AL 1.050962627 0.135 LF, CF, RF 2 1 HOU   2016 2017 TOR
5114 5114 David Paulino 22 paulida01 2016 HOU AL 0.13807219 0.005 P 0 1 HOU   2016 2017 TOR
5135 5135 Kendrys Morales 33 moralke01 2016 KCR AL 5.943292986 0.965 1B, RF 12 1 KCR SEA 2015 2016 TOR
5173 5173 Matt Shoemaker 29 shoemma01 2016 LAA AL 4.679492403 2.74 P 14 1 ANA   2013 2018 TOR
5245 5245 J.P. Howell 33 howeljp01 2016 LAD NL 1.227165304 0.255 P 3 1 LAD TBD 2013 2016 TOR
5270 5270 Brock Stewart 24 stewabr01 2016 LAD NL 0.728096948 -0.225 P 0 1 LAD   2016 2019 TOR
5273 5273 Mike Bolsinger 28 bolsimi01 2016 LAD NL 0.776983457 -0.43 P 0 1 LAD ARI 2015 2016 TOR
5291 5291 Tom Koehler 30 koehlto01 2016 MIA NL 4.825571488 0.50310559 P 8 1 FLA   2012 2017 TOR
5403 5403 Buddy Boshers 28 boshebu01 2016 MIN AL 0.988586763 0.315 P 2 1 MIN ANA 2016 2017 TOR
5503 5503 Rob Refsnyder 25 refsnro01 2016 NYY AL 1.680741845 -0.22 1B, RF, 2B, LF, 3B 2 1 NYY   2015 2017 TOR
5544 5544 John Axford 33 axforjo01 2016 OAK AL 2.246249684 0.59 P 5 1 OAK COL 2016 2017 TOR
5647 5647 Francisco Liriano 32 liriafr01 2016 PIT NL 3.201249808 0.16 P 5 1 PIT CHW 2013 2016 TOR
5685 5685 Yangervis Solarte 28 solarya01 2016 SDP NL 4.514848006 2.395 3B, 2B, 1B 14 1 SDP NYY 2014 2017 TOR
5688 5688 Melvin Upton Jr. 31 uptonbj01 2016 SDP NL 3.811632402 1.63 LF, CF, RF 10 1 SDP ATL 2015 2016 TOR
5701 5701 Clayton Richard 32 richacl01 2016 SDP NL 1.425935923 0.675 P 4 2 SDP CHC 2016 2018 TOR

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