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,967 rows where next_franch = "ANA"

✎ 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
547 547 Max Stassi 28 stassma01 2019 HOU AL 0.90871303 -0.448301887 C, 1B, P 0 1 HOU   2013 2019 ANA
850 850 Adalberto Mejia 26 mejiaad01 2019 MIN AL 0.454651887 -0.438113208 P 0 1 MIN   2016 2019 ANA
1391 1391 Anthony Bemboom 29 bemboan01 2019 TBR AL 0.04716214 0.050943396 C 0 1 TBD   2019 2019 ANA
1398 1398 Kean Wong 24 wongke01 2019 TBR AL 0.132053993 -0.122264151 2B, RF 0 1 TBD   2019 2019 ANA
1640 1640 Sam Freeman 31 freemsa01 2018 ATL NL 1.458445921 0.095 P 2 1 ATL MIL 2017 2018 ANA
1647 1647 Peter Bourjos 31 bourjpe01 2018 ATL NL 0.460239743 0.025 LF, CF, RF 1 1 ATL TBD 2018 2018 ANA
1797 1797 Tommy La Stella 29 lasteto01 2018 CHC NL 1.843708609 0.074539877 3B, 2B, P 3 1 CHC ATL 2015 2018 ANA
1840 1840 Kevan Smith 30 smithke04 2018 CHW AL 1.792727273 0.495 C 4 1 CHW   2016 2018 ANA
1855 1855 Dustin Garneau 30 garnedu01 2018 CHW AL 0.028760331 0.035 C 0 1 CHW OAK 2018 2018 ANA
1881 1881 Matt Harvey 29 harvema01 2018 CIN NL 3.607600524 1.195 P 8 2 CIN NYM 2018 2018 ANA
1944 1944 Cody Allen 29 allenco01 2018 CLE AL 2.622864583 -0.055 P 3 1 CLE   2012 2018 ANA
1968 1968 Oliver Drake 31 drakeol01 2018 CLE AL 0.073164484 -0.085 P 0 2 CLE MIL 2018 2018 ANA
2077 2077 Max Stassi 27 stassma01 2018 HOU AL 2.368893972 1.86 C 9 1 HOU   2013 2019 ANA
2129 2129 Brian Goodwin 27 goodwbr01 2018 KCR AL 0.969707002 0.42 CF, LF, RF 2 2 KCR WSN 2018 2018 ANA
2307 2307 Odrisamer Despaigne 31 despaod01 2018 MIA NL 0.641250449 -0.22136646 P 0 1 FLA BAL 2016 2018 ANA
2310 2310 Dillon Peters 25 peterdi01 2018 MIA NL 0.733423536 -0.347142857 P 0 1 FLA   2017 2018 ANA
2314 2314 Junichi Tazawa 32 tazawju01 2018 MIA NL 0.505809335 -0.684223602 P 0 1 FLA BOS 2017 2018 ANA
2392 2392 Adalberto Mejia 25 mejiaad01 2018 MIN AL 0.589131168 0.645 P 3 1 MIN   2016 2019 ANA
2410 2410 John Curtiss 25 curtijo02 2018 MIN AL 0.136862836 0.035 P 0 1 MIN   2017 2018 ANA
2473 2473 Hansel Robles 27 robleha01 2018 NYM NL 0.612597443 -0.385 P 0 1 NYM   2015 2018 ANA
2541 2541 Trevor Cahill 30 cahiltr01 2018 OAK AL 3.014645074 1.65 P 9 1 OAK KCR 2018 2018 ANA
2547 2547 Jonathan Lucroy 32 lucrojo01 2018 OAK AL 4.223933269 0.005 C 6 1 OAK COL 2018 2018 ANA
2605 2605 Luis Garcia 31 garcilu03 2018 PHI NL 1.646975662 0.145 P 3 1 PHI   2013 2018 ANA
2617 2617 Justin Bour 30 bourju01 2018 PHI NL 0.536668951 -0.085 1B 1 2 PHI FLA 2018 2018 ANA
2798 2798 Chris Stratton 27 stratch01 2018 SFG NL 3.887171791 -0.075 P 6 1 SFG   2016 2018 ANA
3026 3026 Deck McGuire 29 mcguide02 2018 TOR AL 0.156144487 0.015 P 0 1 TOR CIN 2018 2018 ANA
3149 3149 Brandon Phillips 36 phillbr01 2017 ATL NL 4.910417374 1.17 2B, 3B 11 1 ATL CIN 2017 2017 ANA
3159 3159 Sam Freeman 30 freemsa01 2017 ATL NL 1.914397113 1.14 P 6 1 ATL MIL 2017 2018 ANA
3171 3171 Jim Johnson 34 johnsji04 2017 ATL NL 2.067569238 -0.37 P 2 1 ATL LAD 2016 2017 ANA
3172 3172 Akeel Morris 24 morriak01 2017 ATL NL 0.174646754 0.205 P 1 1 ATL NYM 2017 2017 ANA
3176 3176 Ian Krol 26 krolia01 2017 ATL NL 1.324048339 -0.4 P 1 1 ATL DET 2016 2017 ANA
3265 3265 Chris Young 33 youngch04 2017 BOS AL 2.534916865 -0.29 LF, RF 3 1 BOS NYY 2016 2017 ANA
3280 3280 Noe Ramirez 27 ramirno01 2017 BOS AL 0.112723156 -0.035 P 0 1 BOS   2015 2017 ANA
3313 3313 Tommy La Stella 28 lasteto01 2017 CHC NL 1.476150346 0.53 2B, 3B, 1B 4 1 CHC ATL 2015 2018 ANA
3317 3317 Rene Rivera 33 riverre01 2017 CHC NL 0.488791505 0.505 C, 1B 2 2 CHC NYM 2017 2017 ANA
3321 3321 Felix Pena 27 penafe01 2017 CHC NL 0.651862872 -0.115 P 1 1 CHC   2016 2017 ANA
3355 3355 Kevan Smith 29 smithke04 2017 CHW AL 2.823646299 0.3 C 5 1 CHW   2016 2018 ANA
3390 3390 Zack Cozart 31 cozarza01 2017 CIN NL 4.996771453 4.95 SS 21 1 CIN   2011 2017 ANA
3411 3411 Blake Wood 31 woodbl01 2017 CIN NL 1.544169598 -0.07 P 2 1 CIN CLE 2016 2017 ANA
3450 3450 Cody Allen 28 allenco01 2017 CLE AL 2.704599642 1.55 P 8 1 CLE   2012 2018 ANA
3518 3518 Justin Upton 29 uptonju01 2017 DET AL 4.921671018 4.795 LF 20 1 DET SDP 2016 2017 ANA
3521 3521 Ian Kinsler 35 kinslia01 2017 DET AL 5.80189295 2.445 2B 14 1 DET TEX 2014 2017 ANA
3595 3595 Max Stassi 26 stassma01 2017 HOU AL 0.288048702 0.16 C, 1B 1 1 HOU   2013 2019 ANA
3648 3648 Miguel Almonte 24 almonmi01 2017 KCR AL 0.039420169 -0.05 P 0 1 KCR   2015 2017 ANA
3783 3783 Odrisamer Despaigne 30 despaod01 2017 MIA NL 1.494397824 0.325 P 3 1 FLA BAL 2016 2018 ANA
3799 3799 Dillon Peters 24 peterdi01 2017 MIA NL 0.893487243 0.025 P 1 1 FLA   2017 2018 ANA
3802 3802 Junichi Tazawa 31 tazawju01 2017 MIA NL 1.780366604 -0.53 P 1 1 FLA BOS 2017 2018 ANA
3842 3842 Nick Franklin 26 frankni01 2017 MIL NL 0.887094002 -0.13 LF, 2B, RF, SS 1 1 MIL TBD 2017 2017 ANA
3875 3875 Adalberto Mejia 24 mejiaad01 2017 MIN AL 2.780813141 0.935 P 7 1 MIN   2016 2019 ANA
3900 3900 John Curtiss 24 curtijo02 2017 MIN AL 0.168331808 -0.09 P 0 1 MIN   2017 2018 ANA
3944 3944 Hansel Robles 26 robleha01 2017 NYM NL 1.878265758 -0.15 P 2 1 NYM   2015 2018 ANA
3959 3959 Fernando Salas 32 salasfe01 2017 NYM NL 1.389402068 -0.475 P 0 1 NYM ANA 2016 2017 ANA
4078 4078 Luis Garcia 30 garcilu03 2017 PHI NL 2.214008572 1.67 P 8 1 PHI   2013 2018 ANA
4188 4188 Ryan Schimpf 29 schimry01 2017 SDP NL 2.023375243 0.14 3B 4 1 SDP   2016 2017 ANA
4192 4192 Jabari Blash 27 blashja01 2017 SDP NL 2.002833363 -0.205 RF, LF 3 1 SDP   2016 2017 ANA
4296 4296 Chris Stratton 26 stratch01 2017 SFG NL 1.556530853 1.02 P 5 1 SFG   2016 2018 ANA
4297 4297 Jarrett Parker 28 parkeja03 2017 SFG NL 1.764220656 0.41 LF, RF 4 1 SFG   2015 2017 ANA
4421 4421 Cesar Puello 26 puellce01 2017 TBR AL 0.331590983 -0.03 LF, RF 0 2 TBD ANA 2017 2017 ANA
4528 4528 Taylor Cole 27 coleta01 2017 TOR AL 0.032025069 -0.145 P 0 1 TOR   2017 2017 ANA
4649 4649 Jim Johnson 33 johnsji04 2016 ATL NL 2.442177237 1.433850932 P 8 1 ATL LAD 2016 2017 ANA
4653 4653 Ian Krol 25 krolia01 2016 ATL NL 1.722909227 0.940807453 P 5 1 ATL DET 2016 2017 ANA
4667 4667 Jhoulys Chacin 28 chacijh01 2016 ATL NL 0.719907272 0.211304348 P 2 1 ATL ARI 2016 2016 ANA
4741 4741 Parker Bridwell 24 bridwpa01 2016 BAL AL 0.066530201 -0.135 P 0 1 BAL   2016 2016 ANA
4763 4763 Chris Young 32 youngch04 2016 BOS AL 2.092165899 0.92 LF, CF, RF 5 1 BOS NYY 2016 2017 ANA
4795 4795 Noe Ramirez 26 ramirno01 2016 BOS AL 0.310426515 -0.225 P 0 1 BOS   2015 2017 ANA
4818 4818 Tommy La Stella 27 lasteto01 2016 CHC NL 1.651558551 0.57 3B, 2B 4 1 CHC ATL 2015 2018 ANA
4830 4830 Felix Pena 26 penafe01 2016 CHC NL 0.290493359 0.12 P 1 1 CHC   2016 2017 ANA
4883 4883 Kevan Smith 28 smithke04 2016 CHW AL 0.151907022 -0.16 C 0 1 CHW   2016 2018 ANA
4898 4898 Zack Cozart 30 cozarza01 2016 CIN NL 5.10906884 1.975 SS 14 1 CIN   2011 2017 ANA
4909 4909 Blake Wood 30 woodbl01 2016 CIN NL 2.569764349 0.5 P 5 1 CIN CLE 2016 2017 ANA
4916 4916 John Lamb 25 lambjo02 2016 CIN NL 1.985336336 -0.38 P 2 1 CIN   2015 2016 ANA
4934 4934 Daniel Wright 25 wrighda04 2016 CIN NL 0.402223985 -0.38 P 0 1 CIN   2016 2016 ANA
4935 4935 JC Ramirez 27 ramirjc01 2016 CIN NL 0.936652058 -0.39 P 0 1 CIN SEA 2016 2016 ANA
4960 4960 Cody Allen 27 allenco01 2016 CLE AL 2.63370111 1.428819876 P 8 1 CLE   2012 2018 ANA
5029 5029 Jason Gurka 28 gurkaja01 2016 COL NL 0.266133964 -0.11 P 0 1 COL   2015 2016 ANA
5042 5042 Ian Kinsler 34 kinslia01 2016 DET AL 6.451834862 5.735403727 2B 26 1 DET TEX 2014 2017 ANA
5045 5045 Justin Upton 28 uptonju01 2016 DET AL 5.948230668 1.886645963 LF, CF 14 1 DET SDP 2016 2017 ANA
5048 5048 Cameron Maybin 29 maybica01 2016 DET AL 3.715268676 2.153291925 CF 12 1 DET ATL 2016 2016 ANA
5091 5091 Luis Valbuena 30 valbulu01 2016 HOU AL 3.209189452 2.42 3B, 1B, 2B 11 1 HOU CHC 2015 2016 ANA
5120 5120 Max Stassi 25 stassma01 2016 HOU AL 0.121986734 -0.215 C 0 1 HOU   2013 2019 ANA
5168 5168 Brooks Pounders 25 poundbr01 2016 KCR AL 0.377657152 -0.555 P 0 1 KCR   2016 2016 ANA
5255 5255 Jesse Chavez 32 chaveje01 2016 LAD NL 0.667422202 -0.04 P 1 2 LAD TOR 2016 2016 ANA
5259 5259 Bud Norris 31 norribu01 2016 LAD NL 1.160200197 -0.28 P 1 2 LAD ATL 2016 2016 ANA
5314 5314 Odrisamer Despaigne 29 despaod01 2016 MIA NL 0.048202157 -0.040248447 P 0 2 FLA BAL 2016 2018 ANA
5320 5320 Cody Ege 25 egeco01 2016 MIA NL 0.108235752 -0.160993789 P 0 1 FLA   2016 2016 ANA
5343 5343 Martin Maldonado 29 maldoma01 2016 MIL NL 2.551112656 1.135 C 7 1 MIL   2011 2016 ANA
5362 5362 Damien Magnifico 25 magnida01 2016 MIL NL 0.047454052 -0.005 P 0 1 MIL   2016 2016 ANA
5380 5380 Ramon Flores 24 florera02 2016 MIL NL 2.914116829 -1.355 RF, CF, LF, 1B 0 1 MIL NYY 2016 2016 ANA
5389 5389 Ricky Nolasco 33 nolasri01 2016 MIN AL 3.536299985 1.065 P 7 1 MIN LAD 2014 2016 ANA
5416 5416 Adalberto Mejia 23 mejiaad01 2016 MIN AL 0.035558142 -0.01 P 0 1 MIN   2016 2019 ANA
5420 5420 Alex Meyer 26 meyeral01 2016 MIN AL 0.086305194 -0.155 P 0 1 MIN   2015 2016 ANA
5444 5444 Hansel Robles 25 robleha01 2016 NYM NL 2.482991311 0.785 P 6 1 NYM   2015 2018 ANA
5458 5458 Fernando Salas 31 salasfe01 2016 NYM NL 0.58507295 0.365 P 2 2 NYM ANA 2016 2017 ANA
5501 5501 Kirby Yates 29 yateski01 2016 NYY AL 1.079963329 0.12 P 2 1 NYY TBD 2016 2016 ANA
5507 5507 Blake Parker 31 parkebl01 2016 NYY AL 0.581491291 0.11 P 1 2 NYY SEA 2016 2016 ANA
5517 5517 Eric Young Jr. 31 younger03 2016 NYY AL 0.009604239 -0.025 CF 0 1 NYY NYM 2016 2016 ANA
5593 5593 David Hernandez 31 hernada01 2016 PHI NL 2.230621146 0.61 P 5 1 PHI ARI 2016 2016 ANA
5610 5610 Brett Oberholtzer 26 oberhbr01 2016 PHI NL 1.166371292 -0.2 P 1 1 PHI HOU 2016 2016 ANA
5612 5612 Andrew Bailey 32 bailean01 2016 PHI NL 0.968197517 -0.3 P 1 1 PHI NYY 2016 2016 ANA
5616 5616 Luis Garcia 29 garcilu03 2016 PHI NL 0.452223427 -0.115 P 0 1 PHI   2013 2018 ANA

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