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

987 rows where prev_franch = "TOR"

✎ 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
116 116 Dwight Smith Jr. 26 smithdw02 2019 BAL AL 3.719669421 -0.799811321 LF 2 1 BAL TOR 2019 2019  
163 163 David Price 33 priceda01 2019 BOS AL 2.994143102 2.15490566 P 10 1 BOS TOR 2016 2019  
198 198 Steve Pearce 36 pearcst01 2019 BOS AL 0.905392621 -0.759056604 1B, LF 0 1 BOS TOR 2018 2019  
230 230 David Phelps 32 phelpda01 2019 CHC NL 0.512962068 0.127358491 P 1 2 CHC TOR 2019 2019  
266 266 Jimmy Cordero 27 cordeji01 2019 CHW AL 1.017892599 0.733101266 P 4 2 CHW TOR 2019 2019  
330 330 Freddy Galvis 29 galvifr01 2019 CIN NL 1.197153025 -0.066226415 SS, 2B 1 2 CIN TOR 2019 2019  
362 362 Tyler Clippard 34 clippty01 2019 CLE AL 1.761911981 1.044339623 P 6 1 CLE TOR 2019 2019  
443 443 Seunghwan Oh 36 ohse01 2019 COL NL 0.556383297 -0.463584906 P 0 1 COL TOR 2018 2019  
450 450 Matthew Boyd 28 boydma01 2019 DET AL 5.260354928 3.501455696 P 16 1 DET TOR 2015 2019  
452 452 Daniel Norris 26 norrida01 2019 DET AL 4.164620018 2.465886076 P 12 1 DET TOR 2015 2019  
491 491 Jose Fernandez 26 fernajo04 2019 DET AL 0.090440791 -0.29221519 P 0 1 DET TOR 2019 2019  
494 494 Edwin Jackson 35 jacksed01 2019 DET AL 1.020186599 -0.430632911 P 0 2 DET TOR 2019 2019  
515 515 Roberto Osuna 24 osunaro01 2019 HOU AL 2.654881423 1.747358491 P 8 1 HOU TOR 2018 2019  
521 521 Aledmys Diaz 28 diazal02 2019 HOU AL 2.2068745 1.049433962 1B, 2B, 3B, SS, LF 6 1 HOU TOR 2019 2019  
538 538 Aaron Sanchez 26 sanchaa01 2019 HOU AL 0.535417536 -0.025471698 P 1 2 HOU TOR 2019 2019  
546 546 Joe Biagini 29 biagijo01 2019 HOU AL 0.339262264 -0.433018868 P 0 2 HOU TOR 2019 2019  
567 567 Glenn Sparkman 27 sparkgl01 2019 KCR AL 3.652353498 -0.463584906 P 3 1 KCR TOR 2018 2019  
620 620 Taylor Cole 29 coleta01 2019 LAA AL 1.587917935 0.142641509 P 3 1 ANA TOR 2018 2019  
672 672 Russell Martin 36 martiru01 2019 LAD NL 2.458728244 0.998490566 C, 3B, P 7 1 LAD TOR 2019 2019  
696 696 Zac Rosscup 31 rosscza01 2019 LAD NL 0.083976598 -0.101886792 P 0 3 LAD TOR 2019 2019  
709 709 Jon Berti 29 bertijo01 2019 MIA NL 2.802131439 1.737169811 SS, 3B, CF, LF, RF 9 1 FLA TOR 2019 2019  
787 787 Jake Petricka 31 petrija01 2019 MIL NL 0.136246056 0.056037736 P 0 1 MIL TOR 2019 2019  
869 869 Marcus Stroman 28 stromma01 2019 NYM NL 1.499581506 0.616415094 P 4 2 NYM TOR 2019 2019  
909 909 Gio Urshela 27 urshegi01 2019 NYY AL 4.425740953 3.209433962 3B, 1B, LF 16 1 NYY TOR 2019 2019  
916 916 J.A. Happ 36 happja01 2019 NYY AL 4.588464069 1.243018868 P 11 1 NYY TOR 2018 2019  
947 947 Troy Tulowitzki 34 tulowtr01 2019 NYY AL 0.123464876 -0.020377358 SS 0 1 NYY TOR 2019 2019  
963 963 Liam Hendriks 30 hendrli01 2019 OAK AL 3.303846687 3.739245283 P 16 1 OAK TOR 2016 2019  
965 965 Brett Anderson 31 anderbr04 2019 OAK AL 4.691881934 2.210943396 P 13 1 OAK TOR 2018 2019  
1000 1000 Marco Estrada 35 estrama01 2019 OAK AL 0.649363776 -0.305660377 P 0 1 OAK TOR 2019 2019  
1005 1005 Kendrys Morales 36 moralke01 2019 OAK AL 1.190615836 -0.417735849 1B, P 0 1 OAK TOR 2019 2019 NYY
1239 1239 Kevin Pillar 30 pillake01 2019 SFG NL 6.213208528 1.676037736 CF, RF 16 2 SFG TOR 2019 2019  
1276 1276 Yangervis Solarte 31 solarya01 2019 SFG NL 0.784191368 -0.26490566 2B, LF, SS, 3B 1 1 SFG TOR 2019 2019  
1344 1344 Dominic Leone 27 leonedo01 2019 STL NL 0.910644874 -0.387169811 P 0 1 STL TOR 2018 2019  
1370 1370 Eric Sogard 33 sogarer01 2019 TBR AL 1.122458936 0.601132075 2B, 3B, RF, SS, LF 3 2 TBD TOR 2019 2019  
1431 1431 Taylor Guerrieri 26 guerrta02 2019 TEX AL 0.59808855 0.045849057 P 1 1 TEX TOR 2019 2019  
1534 1534 Daniel Hudson 32 hudsoda01 2019 WSN NL 0.909638274 0.621509434 P 3 2 WSN TOR 2019 2019  
1538 1538 Javy Guerra 33 guerrja01 2019 WSN NL 1.355110406 0.106981132 P 2 2 WSN TOR 2019 2019  
1667 1667 Jose Bautista 37 bautijo02 2018 ATL NL 0.391693399 -0.225 RF, LF, 3B, 1B, 2B 0 1 ATL TOR 2018 2018 NYM
1733 1733 David Price 32 priceda01 2018 BOS AL 4.879133688 3.385 P 18 1 BOS TOR 2016 2019  
1743 1743 Steve Pearce 35 pearcst01 2018 BOS AL 1.523400191 1.18 1B, LF, RF 6 2 BOS TOR 2018 2019  
1811 1811 Jaime Garcia 31 garcija02 2018 CHC NL 0.23210845 0.0 P 0 2 CHC TOR 2018 2018  
1933 1933 Yan Gomes 30 gomesya01 2018 CLE AL 4.021357985 2.485 C 12 1 CLE TOR 2013 2018 WSN
1935 1935 Edwin Encarnacion 35 encared01 2018 CLE AL 5.352566146 1.44 1B 11 1 CLE TOR 2017 2018 SEA
1945 1945 Josh Donaldson 32 donaljo02 2018 CLE AL 0.554670067 0.595 3B, 1B 2 2 CLE TOR 2018 2018 ATL
1971 1971 Jeff Beliveau 31 belivje01 2018 CLE AL 0.128996606 -0.285 P 0 1 CLE TOR 2018 2018  
1994 1994 Seunghwan Oh 35 ohse01 2018 COL NL 0.806242516 0.511840491 P 3 2 COL TOR 2018 2019  
2019 2019 Matthew Boyd 27 boydma01 2018 DET AL 4.784057885 2.07 P 13 1 DET TOR 2015 2019  
2042 2042 Daniel Norris 25 norrida01 2018 DET AL 1.211872549 0.14 P 2 1 DET TOR 2015 2019  
2055 2055 Jarrod Saltalamacchia 33 saltaja01 2018 DET AL 0.077204659 -0.225 1B, C 0 1 DET TOR 2018 2018  
2089 2089 Roberto Osuna 23 osunaro01 2018 HOU AL 0.835469664 0.715 P 3 2 HOU TOR 2018 2019  
2130 2130 Glenn Sparkman 26 sparkgl01 2018 KCR AL 1.129432963 0.245 P 2 1 KCR TOR 2018 2019  
2137 2137 Ryan Goins 30 goinsry01 2018 KCR AL 1.152127131 -0.22 2B, 3B, SS 1 1 KCR TOR 2018 2018 CHW
2174 2174 Taylor Cole 28 coleta01 2018 LAA AL 0.996478807 0.565 P 3 1 ANA TOR 2018 2019  
2211 2211 Deck McGuire 29 mcguide02 2018 LAA AL 0.64286064 -0.49 P 0 2 ANA TOR 2018 2018  
2263 2263 John Axford 35 axforjo01 2018 LAD NL 0.07607495 -0.203742331 P 0 2 LAD TOR 2018 2018  
2347 2347 Curtis Granderson 37 grandcu01 2018 MIL NL 0.529501268 0.33791411 LF, RF, CF 2 2 MIL TOR 2018 2018 FLA
2400 2400 Oliver Drake 31 drakeol01 2018 MIN AL 0.454553519 0.32 P 2 5 MIN TOR 2018 2018 TBD
2454 2454 Scott Copeland 30 copelsc01 2018 NYM NL 0.029189964 0.025 P 0 1 NYM TOR 2018 2018  
2497 2497 J.A. Happ 35 happja01 2018 NYY AL 1.789984011 1.545 P 7 2 NYY TOR 2018 2019  
2548 2548 Brett Anderson 30 anderbr04 2018 OAK AL 2.201604433 0.685 P 5 1 OAK TOR 2018 2019  
2563 2563 Liam Hendriks 29 hendrli01 2018 OAK AL 0.608498121 0.14 P 1 1 OAK TOR 2016 2019  
2569 2569 Carlos Ramirez 27 ramirca01 2018 OAK AL 0.102002575 0.05 P 0 2 OAK TOR 2018 2018  
2582 2582 Kendall Graveman 27 graveke01 2018 OAK AL 0.940934675 -0.675 P 0 1 OAK TOR 2015 2018  
2622 2622 Aaron Loup 30 loupaa01 2018 PHI NL 0.107707356 0.045 P 0 2 PHI TOR 2018 2018 SDP
2706 2706 Rafael Lopez 30 lopezra02 2018 SDP NL 1.176899063 -0.04 C, 1B, 3B 2 1 SDP TOR 2018 2018  
2775 2775 Casey Lawrence 30 lawreca01 2018 SEA AL 0.485092481 -0.215 P 0 1 SEA TOR 2017 2018  
2858 2858 Dominic Leone 26 leonedo01 2018 STL NL 0.734669111 0.075 P 1 1 STL TOR 2018 2019  
2876 2876 Brett Cecil 31 cecilbr01 2018 STL NL 0.808585182 -0.835 P 0 1 STL TOR 2017 2018  
2921 2921 Rob Refsnyder 27 refsnro01 2018 TBR AL 0.967762838 -0.245 LF, RF, 1B 1 1 TBD TOR 2018 2018  
3092 3092 Miguel Montero 34 montemi01 2018 WSN NL 0.126786615 -0.235 C 0 1 WSN TOR 2018 2018  
3146 3146 R.A. Dickey 42 dicker.01 2017 ATL NL 5.424125155 1.845 P 13 1 ATL TOR 2017 2017  
3254 3254 David Price 31 priceda01 2017 BOS AL 2.081042881 1.63 P 8 1 BOS TOR 2016 2019  
3349 3349 Melky Cabrera 32 cabreme01 2017 CHW AL 4.11061434 0.675 LF, RF 7 1 CHW TOR 2015 2017 KCR
3401 3401 Scott Feldman 34 feldmsc01 2017 CIN NL 3.30019238 0.28 P 5 1 CIN TOR 2017 2017  
3442 3442 Edwin Encarnacion 34 encared01 2017 CLE AL 6.245292129 2.545 1B 15 1 CLE TOR 2017 2018 SEA
3449 3449 Yan Gomes 29 gomesya01 2017 CLE AL 3.575406406 1.55 C 9 1 CLE TOR 2013 2018 WSN
3461 3461 Joe Smith 33 smithjo05 2017 CLE AL 0.711200862 0.575 P 3 2 CLE TOR 2017 2017 HOU
3523 3523 Matthew Boyd 26 boydma01 2017 DET AL 3.93404442 1.66 P 10 1 DET TOR 2015 2019  
3532 3532 Daniel Norris 24 norrida01 2017 DET AL 2.80253081 0.93 P 6 1 DET TOR 2015 2019  
3604 3604 Francisco Liriano 33 liriafr01 2017 HOU AL 0.457729001 -0.07 P 0 2 HOU TOR 2017 2017 DET
3686 3686 Cliff Pennington 33 pennicl01 2017 LAA AL 2.079643093 0.335 2B, 3B, SS 4 1 ANA TOR 2016 2017 CIN
3798 3798 Adeiny Hechavarria 28 hechaad01 2017 MIA NL 0.655311973 0.13 SS 1 1 FLA TOR 2013 2017 TBD
3943 3943 Nori Aoki 35 aokino01 2017 NYM NL 1.15106929 0.05 LF, RF, CF, P 2 3 NYM TOR 2017 2017  
4026 4026 Kendall Graveman 26 graveke01 2017 OAK AL 3.01729875 1.445 P 9 1 OAK TOR 2015 2018  
4033 4033 Liam Hendriks 28 hendrli01 2017 OAK AL 2.13721073 0.56 P 5 1 OAK TOR 2016 2019  
4094 4094 Joaquin Benoit 39 benoijo01 2017 PHI NL 1.405317591 0.6 P 3 1 PHI TOR 2017 2017 PIT
4119 4119 Michael Saunders 30 saundmi01 2017 PHI NL 2.130084091 -0.72 RF, LF 0 1 PHI TOR 2017 2017 TOR
4258 4258 Casey Lawrence 29 lawreca01 2017 SEA AL 0.838980991 -0.15 P 1 2 SEA TOR 2017 2018  
4350 4350 Brett Cecil 30 cecilbr01 2017 STL NL 2.203662381 0.73 P 5 1 STL TOR 2017 2018  
4458 4458 Jason Grilli 40 grillja01 2017 TEX AL 0.453523646 0.085 P 1 2 TEX TOR 2017 2017  
4755 4755 David Price 30 priceda01 2016 BOS AL 6.339717201 3.59 P 18 1 BOS TOR 2016 2019  
4828 4828 Munenori Kawasaki 35 kawasmu01 2016 CHC NL 0.254085931 0.21 2B, 3B 1 1 CHC TOR 2016 2016  
4849 4849 Melky Cabrera 31 cabreme01 2016 CHW AL 6.13324603 2.355 LF 15 1 CHW TOR 2015 2017 KCR
4871 4871 Dioner Navarro 32 navardi01 2016 CHW AL 2.829268293 -1.095 C 1 1 CHW TOR 2016 2016 TOR
4924 4924 Steve Delabar 32 delabst01 2016 CIN NL 0.214762128 -0.125 P 0 1 CIN TOR 2016 2016  
4974 4974 Yan Gomes 28 gomesya01 2016 CLE AL 2.497879282 -0.654037267 C 2 1 CLE TOR 2013 2018 WSN
5030 5030 Miguel Castro 21 castrmi01 2016 COL NL 0.534626272 -0.12 P 0 1 COL TOR 2015 2016 BAL
5052 5052 Daniel Norris 23 norrida01 2016 DET AL 1.907249687 1.428819876 P 7 1 DET TOR 2015 2019  
5053 5053 Matthew Boyd 25 boydma01 2016 DET AL 2.868734076 1.167204969 P 7 1 DET TOR 2015 2019  
5071 5071 Anthony Gose 25 gosean01 2016 DET AL 0.959698558 -0.105652174 CF 1 1 DET TOR 2015 2016  

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