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,438 rows where prev_franch = "NYY"

✎ 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
110 110 Richard Bleier 32 bleieri01 2019 BAL AL 1.627498961 0.361698113 P 3 1 BAL NYY 2017 2019  
124 124 Jace Peterson 29 peterja01 2019 BAL AL 1.035371901 -0.157924528 LF, 3B, 2B, RF 1 1 BAL NYY 2018 2019  
299 299 Sonny Gray 29 grayso01 2019 CIN NL 4.966111658 5.175849057 P 22 1 CIN NYY 2019 2019  
366 366 Nick Goody 27 goodyni01 2019 CLE AL 1.329276093 0.550188679 P 4 1 CLE NYY 2017 2019  
374 374 Tyler Olson 29 olsonty01 2019 CLE AL 0.919105386 0.173207547 P 2 1 CLE NYY 2017 2019  
380 380 A.J. Cole 27 coleaj01 2019 CLE AL 0.71867871 0.050943396 P 1 1 CLE NYY 2019 2019  
433 433 Joe Harvey 27 harvejo01 2019 COL NL 0.193170994 -0.025471698 P 0 2 COL NYY 2019 2019  
457 457 Shane Greene 30 greensh02 2019 DET AL 1.591633814 1.245759494 P 5 1 DET NYY 2015 2019 ATL
705 705 Caleb Smith 27 smithca03 2019 MIA NL 4.371415983 2.007169811 P 12 1 FLA NYY 2018 2019  
706 706 Starlin Castro 29 castrst01 2019 MIA NL 6.830195382 0.779433962 2B, 3B, SS 12 1 FLA NYY 2018 2019  
707 707 Garrett Cooper 28 coopega03 2019 MIA NL 4.337122558 1.395849057 1B, RF 10 1 FLA NYY 2018 2019  
712 712 Neil Walker 33 walkene01 2019 MIA NL 3.842628774 0.387169811 1B, 3B, 2B 7 1 FLA NYY 2019 2019  
750 750 Martin Prado 35 pradoma01 2019 MIA NL 2.575488455 -1.319433962 1B, 3B 0 1 FLA NYY 2015 2019  
810 810 Michael Pineda 30 pinedmi01 2019 MIN AL 4.047686676 2.516603774 P 13 1 MIN NYY 2019 2019  
841 841 Tyler Austin 27 austity01 2019 MIN AL 0.046251994 -0.025471698 LF, 1B, RF 0 1 MIN NYY 2018 2019 SFG
842 842 Ronald Torreyes 26 torrero01 2019 MIN AL 0.092503987 -0.030566038 SS, 2B, LF 0 1 MIN NYY 2019 2019  
860 860 Todd Frazier 33 frazito01 2019 NYM NL 4.866438356 1.849245283 3B, 1B 12 1 NYM NYY 2018 2019  
873 873 Adeiny Hechavarria 30 hechaad01 2019 NYM NL 1.499657534 -0.152830189 2B, SS, 3B 2 1 NYM NYY 2019 2019 ATL
1015 1015 Andrew McCutchen 32 mccutan01 2019 PHI NL 2.613241617 1.492641509 LF, CF 9 1 PHI NYY 2019 2019  
1049 1049 David Robertson 34 roberda08 2019 PHI NL 0.236749923 -0.061132075 P 0 1 PHI NYY 2019 2019  
1090 1090 Francisco Cervelli 33 cervefr01 2019 PIT NL 1.228305785 -0.183396226 C, 1B 1 1 PIT NYY 2015 2019 ATL
1160 1160 Jose Pirela 29 pireljo01 2019 SDP NL 0.051491477 -0.13245283 LF, RF 0 1 SDP NYY 2016 2019 PHI
1201 1201 Justus Sheffield 23 sheffju01 2019 SEA AL 0.898556222 0.157924528 P 2 1 SEA NYY 2019 2019  
1232 1232 Nick Rumbelow 27 rumbeni01 2019 SEA AL 0.044609174 -0.315849057 P 0 1 SEA NYY 2018 2019  
1247 1247 Donovan Solano 31 solando01 2019 SFG NL 2.231929277 1.665849057 2B, SS, 3B 9 1 SFG NYY 2019 2019  
1313 1313 Giovanny Gallegos 27 gallegi01 2019 STL NL 2.28619792 2.007169811 P 10 1 STL NYY 2018 2019  
1336 1336 Chasen Shreve 28 shrevch01 2019 STL NL 0.069197028 -0.030566038 P 0 1 STL NYY 2018 2019  
1402 1402 Lance Lynn 32 lynnla01 2019 TEX AL 5.884396037 6.765283019 P 29 1 TEX NYY 2019 2019  
1418 1418 Chris Martin 33 martich02 2019 TEX AL 1.368282155 1.018867925 P 5 1 TEX NYY 2018 2019 ATL
1477 1477 Billy McKinney 24 mckinbi01 2019 TOR AL 2.634596044 0.112075472 RF, LF, 1B 4 1 TOR NYY 2018 2019  
1478 1478 Brandon Drury 26 drurybr01 2019 TOR AL 4.306738183 -0.382075472 3B, RF, 2B, 1B, LF, SS 4 1 TOR NYY 2018 2019  
1505 1505 Breyvic Valera 27 valerbr01 2019 TOR AL 0.106939323 -0.213962264 2B, SS 0 2 TOR NYY 2019 2019  
1683 1683 Richard Bleier 31 bleieri01 2018 BAL AL 1.190106238 1.18 P 5 1 BAL NYY 2017 2019  
1700 1700 Jace Peterson 28 peterja01 2018 BAL AL 2.267509566 -0.22 3B, LF, 2B, RF, SS, P 2 2 BAL NYY 2018 2019  
1711 1711 Corban Joseph 29 josepco01 2018 BAL AL 0.183330561 -0.085 1B, 2B 0 1 BAL NYY 2018 2018 OAK
1897 1897 Mason Williams 26 willima10 2018 CIN NL 1.299168505 0.04 RF, CF, LF 2 1 CIN NYY 2018 2018 BAL
1947 1947 Andrew Miller 33 millean01 2018 CLE AL 1.305605032 0.28 P 2 1 CLE NYY 2016 2018 STL
1955 1955 Tyler Olson 28 olsonty01 2018 CLE AL 0.837232799 0.165 P 1 1 CLE NYY 2017 2019  
1973 1973 Nick Goody 26 goodyni01 2018 CLE AL 0.383503424 -0.365 P 0 1 CLE NYY 2017 2019  
2000 2000 Matt Holliday 38 hollima01 2018 COL NL 0.645216498 0.114294479 LF, 1B 1 1 COL NYY 2018 2018  
2038 2038 Shane Greene 29 greensh02 2018 DET AL 2.49223397 -0.31 P 3 1 DET NYY 2015 2019 ATL
2088 2088 Brian McCann 34 mccanbr01 2018 HOU AL 2.046724391 0.53 C 4 1 HOU NYY 2017 2018 ATL
2170 2170 Blake Parker 33 parkebl01 2018 LAA AL 2.192833336 0.545 P 5 1 ANA NYY 2017 2018 MIN
2209 2209 Eric Young Jr. 33 younger03 2018 LAA AL 1.115018074 -0.42 CF, LF 0 1 ANA NYY 2017 2018  
2269 2269 Starlin Castro 28 castrst01 2018 MIA NL 6.47 2.802298137 2B 18 1 FLA NYY 2018 2019  
2279 2279 Caleb Smith 26 smithca03 2018 MIA NL 2.191434178 0.840186335 P 6 1 FLA NYY 2018 2019  
2286 2286 Martin Prado 34 pradoma01 2018 MIA NL 2.09 -0.080496894 3B, 1B 3 1 FLA NYY 2015 2019  
2293 2293 Garrett Cooper 27 coopega03 2018 MIA NL 0.38 0.020124224 LF, 1B, RF 1 1 FLA NYY 2018 2019  
2339 2339 Erik Kratz 38 kratzer01 2018 MIL NL 2.147421809 0.397546012 C, P, 1B 5 1 MIL NYY 2018 2018 SFG
2358 2358 Ji-Man Choi 27 choiji01 2018 MIL NL 0.313778529 0.029815951 1B, LF 1 1 MIL NYY 2018 2018 TBD
2368 2368 Mike Zagurski 35 zagurmi01 2018 MIL NL 0.041111566 -0.357791411 P 0 1 MIL NYY 2018 2018  
2396 2396 Tyler Austin 26 austity01 2018 MIN AL 1.286366601 0.305 1B 3 2 MIN NYY 2018 2019 SFG
2414 2414 David Hale 30 haleda02 2018 MIN AL 0.092550077 -0.2 P 0 2 MIN NYY 2018 2018 NYY
2416 2416 Phil Hughes 32 hugheph01 2018 MIN AL 0.25753065 -0.215 P 0 1 MIN NYY 2014 2018 SDP
2432 2432 Todd Frazier 32 frazito01 2018 NYM NL 4.684462697 1.69 3B 11 1 NYM NYY 2018 2019  
2568 2568 Dustin Fowler 23 fowledu01 2018 OAK AL 1.888675008 -0.755 CF, LF, RF 1 1 OAK NYY 2018 2018  
2636 2636 Francisco Cervelli 32 cervefr01 2018 PIT NL 4.07442184 2.636273292 C, 1B 14 1 PIT NYY 2015 2019 ATL
2643 2643 Ivan Nova 31 novaiv01 2018 PIT NL 4.616476279 0.623850932 P 9 1 PIT NYY 2016 2018 CHW
2696 2696 Jose Pirela 28 pireljo01 2018 SDP NL 4.757891086 -0.43 2B, LF, 1B, RF 6 1 SDP NYY 2016 2019 PHI
2713 2713 Bryan Mitchell 27 mitchbr01 2018 SDP NL 1.76809056 -0.61 P 1 1 SDP NYY 2018 2018  
2724 2724 Chase Headley 34 headlch01 2018 SDP NL 0.603537981 -0.42 3B, 1B 0 1 SDP NYY 2018 2018  
2734 2734 Robinson Cano 35 canoro01 2018 SEA AL 3.327947238 3.07 2B, 1B, 3B 14 1 SEA NYY 2014 2018 NYM
2741 2741 Ben Gamel 26 gamelbe01 2018 SEA AL 2.801978566 0.69 LF, RF, CF, 1B 7 1 SEA NYY 2016 2018 MIL
2747 2747 James Pazos 27 pazosja01 2018 SEA AL 1.544376062 0.64 P 4 1 SEA NYY 2017 2018 COL
2761 2761 Adam Warren 30 warread01 2018 SEA AL 0.659577277 0.135 P 1 2 SEA NYY 2018 2018 SDP
2777 2777 Nick Rumbelow 26 rumbeni01 2018 SEA AL 0.372531226 -0.255 P 0 1 SEA NYY 2018 2019  
2861 2861 Chasen Shreve 27 shrevch01 2018 STL NL 0.408149506 0.005 P 1 2 STL NYY 2018 2019  
2864 2864 Giovanny Gallegos 26 gallegi01 2018 STL NL 0.019723971 0.02 P 0 2 STL NYY 2018 2019  
2901 2901 Nathan Eovaldi 28 eovalna01 2018 TBR AL 1.503093723 0.715 P 4 1 TBD NYY 2018 2018 BOS
2952 2952 Chris Martin 32 martich02 2018 TEX AL 1.393245953 0.605 P 4 1 TEX NYY 2018 2019 ATL
3014 3014 Billy McKinney 23 mckinbi01 2018 TOR AL 1.226701917 0.205 LF, RF, 1B 2 2 TOR NYY 2018 2019  
3017 3017 Jaime Garcia 31 garcija02 2018 TOR AL 2.032130903 -0.27 P 2 1 TOR NYY 2018 2018 CHC
3036 3036 Brandon Drury 25 drurybr01 2018 TOR AL 0.277924653 -0.075 3B, 2B, 1B, SS 0 2 TOR NYY 2018 2019  
3209 3209 Richard Bleier 30 bleieri01 2017 BAL AL 1.712538226 0.795 P 5 1 BAL NYY 2017 2019  
3265 3265 Chris Young 33 youngch04 2017 BOS AL 2.534916865 -0.29 LF, RF 3 1 BOS NYY 2016 2017 ANA
3345 3345 Anthony Swarzak 31 swarzan01 2017 CHW AL 1.88424953 1.8 P 8 1 CHW NYY 2017 2017 MIL
3353 3353 David Robertson 32 roberda08 2017 CHW AL 1.361857592 0.96 P 5 1 CHW NYY 2015 2017 NYY
3362 3362 Tyler Clippard 32 clippty01 2017 CHW AL 0.386725973 0.4 P 2 2 CHW NYY 2017 2017 HOU
3444 3444 Andrew Miller 32 millean01 2017 CLE AL 2.459726618 2.695 P 11 1 CLE NYY 2016 2018 STL
3457 3457 Nick Goody 25 goodyni01 2017 CLE AL 1.410998074 0.79 P 4 1 CLE NYY 2017 2019  
3459 3459 Tyler Olson 27 olsonty01 2017 CLE AL 0.659782618 0.88 P 3 1 CLE NYY 2017 2019  
3526 3526 Shane Greene 28 greensh02 2017 DET AL 2.536795757 1.53 P 8 1 DET NYY 2015 2019 ATL
3531 3531 Justin Wilson 29 wilsoju10 2017 DET AL 1.747151526 1.23 P 6 1 DET NYY 2016 2017 CHC
3578 3578 Brian McCann 33 mccanbr01 2017 HOU AL 3.707465556 1.795 C 11 1 HOU NYY 2017 2018 ATL
3671 3671 Blake Parker 32 parkebl01 2017 LAA AL 2.365663204 1.645 P 8 1 ANA NYY 2017 2018 MIN
3682 3682 Eric Young Jr. 32 younger03 2017 LAA AL 1.197951091 0.725 LF, CF, RF 4 1 ANA NYY 2017 2018  
3709 3709 Kirby Yates 30 yateski01 2017 LAA AL 0.028434406 -0.165 P 0 1 ANA NYY 2017 2017 SDP
3733 3733 Brandon McCarthy 33 mccarbr01 2017 LAD NL 2.537345582 1.385 P 8 1 LAD NYY 2015 2017 ATL
3784 3784 David Phelps 30 phelpda01 2017 MIA NL 1.605410233 0.29 P 3 1 FLA NYY 2015 2017 SEA
3790 3790 Martin Prado 33 pradoma01 2017 MIA NL 1.43777403 0.05 3B 2 1 FLA NYY 2015 2019  
3792 3792 Ichiro Suzuki 43 suzukic01 2017 MIA NL 2.102866779 -0.15 RF, CF, LF 2 1 FLA NYY 2015 2017 SEA
3852 3852 Tyler Webb 26 webbty01 2017 MIL NL 0.083962031 -0.125 P 0 2 MIL NYY 2017 2017 SDP
3894 3894 Phil Hughes 31 hugheph01 2017 MIN AL 1.368100583 -0.185 P 1 1 MIN NYY 2014 2018 SDP
3917 3917 Curtis Granderson 36 grandcu01 2017 NYM NL 3.919589393 2.14 CF, RF, LF 12 1 NYM NYY 2014 2017 LAD
4130 4130 Ivan Nova 30 novaiv01 2017 PIT NL 5.319082617 1.485 P 12 1 PIT NYY 2016 2018 CHW
4137 4137 Francisco Cervelli 31 cervefr01 2017 PIT NL 3.033201445 0.525 C 6 1 PIT NYY 2015 2019 ATL
4153 4153 Johnny Barbato 24 barbajo01 2017 PIT NL 0.632264389 0.025 P 1 1 PIT NYY 2017 2017 DET
4167 4167 Chris Stewart 35 stewach01 2017 PIT NL 1.436779632 -0.7 C 0 1 PIT NYY 2014 2017 ATL
4174 4174 Jose Pirela 27 pireljo01 2017 SDP NL 3.533203471 1.975 LF, 2B, 1B, RF, 3B 12 1 SDP NYY 2016 2019 PHI
4175 4175 Yangervis Solarte 29 solarya01 2017 SDP NL 5.258721445 1.035 2B, SS, 3B, 1B 12 1 SDP NYY 2014 2017 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
);