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

899 rows where next_franch = "FLA"

✎ 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
386 386 Josh Smith 29 smithjo08 2019 CLE AL 0.163053726 0.056037736 P 0 1 CLE   2019 2019 FLA
616 616 Cesar Puello 28 puellce01 2019 LAA AL 0.473160385 0.830377358 CF, LF, RF 3 1 ANA TBD 2019 2019 FLA
1362 1362 Ryne Stanek 27 stanery01 2019 TBR AL 1.51009849 1.008679245 P 5 1 TBD   2017 2019 FLA
1609 1609 Deven Marrero 27 marrede01 2018 ARI NL 0.846351931 -0.395 3B, 2B 0 1 ARI BOS 2018 2018 FLA
1923 1923 Austin Brice 26 briceau01 2018 CIN NL 0.973441229 -0.485 P 0 1 CIN FLA 2017 2018 FLA
2120 2120 Rosell Herrera 25 herrero02 2018 KCR AL 2.774706174 0.675 RF, 2B, CF, 3B, LF 5 2 KCR CIN 2018 2018 FLA
2347 2347 Curtis Granderson 37 grandcu01 2018 MIL NL 0.529501268 0.33791411 LF, RF, CF 2 2 MIL TOR 2018 2018 FLA
2415 2415 Tyler Kinley 27 kinlety01 2018 MIN AL 0.05017476 -0.2 P 0 1 MIN   2018 2018 FLA
2502 2502 Neil Walker 32 walkene01 2018 NYY AL 3.694031045 -0.02 1B, 2B, 3B, RF, LF 5 1 NYY MIL 2018 2018 FLA
2590 2590 Jorge Alfaro 25 alfarjo01 2018 PHI NL 3.746744345 2.195 C, 3B 12 1 PHI   2016 2018 FLA
2666 2666 Christopher Bostick 25 bostich01 2018 PIT NL 0.020170405 -0.02515528 2B, LF 0 1 PIT   2017 2018 FLA
2893 2893 Ryne Stanek 26 stanery01 2018 TBR AL 1.890280005 1.3 P 6 1 TBD   2017 2019 FLA
2897 2897 Sergio Romo 35 romose01 2018 TBR AL 2.443815085 0.45 P, 3B 5 1 TBD LAD 2017 2018 FLA
3024 3024 Jon Berti 28 bertijo01 2018 TOR AL 0.143754131 0.045 2B 0 1 TOR   2018 2018 FLA
3419 3419 Austin Brice 25 briceau01 2017 CIN NL 0.879817562 -0.09 P 1 1 CIN FLA 2017 2018 FLA
3426 3426 Chad Wallach 25 wallach01 2017 CIN NL 0.108411215 -0.2 C, 1B 0 1 CIN   2017 2017 FLA
3561 3561 Bryan Holaday 29 holadbr01 2017 DET AL 0.274477807 -0.3 C, 2B 0 1 DET BOS 2017 2017 FLA
3598 3598 Cameron Maybin 30 maybica01 2017 HOU AL 0.585389298 -0.06 LF, CF, RF 1 2 HOU ANA 2017 2017 FLA
3649 3649 Christian Colon 28 colonch01 2017 KCR AL 0.183666667 -0.095 3B, 2B 0 1 KCR   2014 2017 FLA
3849 3849 Yadiel Rivera 25 riverya01 2017 MIL NL 0.019934697 -0.025 3B 0 1 MIL   2015 2017 FLA
3858 3858 Lewis Brinson 23 brinsle01 2017 MIL NL 0.548204159 -0.275 CF, LF 0 1 MIL   2017 2017 FLA
3902 3902 Drew Rucinski 28 rucindr01 2017 MIN AL 0.078905535 -0.11 P 0 1 MIN ANA 2017 2017 FLA
3975 3975 Starlin Castro 27 castrst01 2017 NYY AL 4.334650024 1.955 2B 11 1 NYY CHC 2016 2017 FLA
3993 3993 Garrett Cooper 26 coopega03 2017 NYY AL 0.412387423 0.15 1B 1 1 NYY   2017 2017 FLA
4009 4009 Caleb Smith 25 smithca03 2017 NYY AL 0.394347778 -0.15 P 0 1 NYY   2017 2017 FLA
4096 4096 Jorge Alfaro 24 alfarjo01 2017 PHI NL 1.134717693 0.515 C, 1B 3 1 PHI   2016 2018 FLA
4148 4148 Christopher Bostick 24 bostich01 2017 PIT NL 0.319284363 0.185 2B, LF 1 1 PIT   2017 2018 FLA
4262 4262 Tyler Cloyd 30 cloydty01 2017 SEA AL 0.029001812 0.025 P 0 1 SEA PHI 2017 2017 FLA
4360 4360 Magneuris Sierra 21 sierrma01 2017 STL NL 0.63032773 0.155 RF, CF, LF 1 1 STL   2017 2017 FLA
4366 4366 Sandy Alcantara 21 alcansa01 2017 STL NL 0.142563667 -0.09 P 0 1 STL   2017 2017 FLA
4397 4397 Sergio Romo 34 romose01 2017 TBR AL 0.971432411 0.815 P 4 2 TBD LAD 2017 2018 FLA
4428 4428 Ryne Stanek 25 stanery01 2017 TBR AL 0.566393171 -0.33 P 0 1 TBD   2017 2019 FLA
4577 4577 Jacob Turner 26 turneja01 2017 WSN NL 1.2442096 -0.205 P 1 1 WSN CHW 2017 2017 FLA
4640 4640 Peter O'Brien 25 obriepe01 2016 ARI NL 0.655754303 -0.635 LF, 1B 0 1 ARI   2015 2016 FLA
4656 4656 Jeff Francoeur 32 francje02 2016 ATL NL 2.723375298 0.437701863 LF, RF, 3B 5 1 ATL PHI 2016 2016 FLA
4661 4661 Hunter Cervenka 26 cervehu01 2016 ATL NL 1.083401435 0.387391304 P 3 1 ATL   2016 2016 FLA
4719 4719 Vance Worley 28 worleva01 2016 BAL AL 2.225925166 0.81 P 6 1 BAL PIT 2016 2016 FLA
4734 4734 Odrisamer Despaigne 29 despaod01 2016 BAL AL 0.714709707 -0.145 P 1 1 BAL SDP 2016 2016 FLA
4765 4765 Brad Ziegler 36 zieglbr01 2016 BOS AL 1.193800735 0.87 P 4 2 BOS ARI 2016 2016 FLA
4772 4772 Junichi Tazawa 30 tazawju01 2016 BOS AL 1.691131724 0.255 P 3 1 BOS   2009 2016 FLA
4892 4892 JB Shuck 29 shuckja01 2016 CHW AL 2.288099525 -1.61 CF, LF, RF, P 0 1 CHW CLE 2015 2016 FLA
4897 4897 Dan Straily 27 straida01 2016 CIN NL 5.368547633 2.21 P 15 1 CIN HOU 2016 2016 FLA
5084 5084 Mike Aviles 35 avilemi01 2016 DET AL 1.719855832 -1.323167702 RF, 2B, 3B, LF, SS, CF 0 1 DET CLE 2016 2016 FLA
5141 5141 Edinson Volquez 32 volqued01 2016 KCR AL 5.304579749 0.32 P 9 1 KCR PIT 2015 2016 FLA
5152 5152 Christian Colon 27 colonch01 2016 KCR AL 1.54833361 0.32 2B, 3B, SS 3 1 KCR   2014 2017 FLA
5200 5200 Rafael Ortega 25 ortegra01 2016 LAA AL 1.946179402 -0.365 LF, CF, RF 2 1 ANA COL 2016 2016 FLA
5212 5212 Javy Guerra 30 guerrja01 2016 LAA AL 0.155671944 -0.125 P 0 1 ANA CHW 2016 2016 FLA
5374 5374 Yadiel Rivera 24 riverya01 2016 MIL NL 0.715924896 -0.31 3B, 2B, SS 0 1 MIL   2015 2017 FLA
5483 5483 Starlin Castro 26 castrst01 2016 NYY AL 5.858585859 1.29 2B, SS 13 1 NYY CHC 2016 2017 FLA
5608 5608 A.J. Ellis 35 ellisaj01 2016 PHI NL 0.357583231 0.145 C 1 2 PHI LAD 2016 2016 FLA
5619 5619 Jorge Alfaro 23 alfarjo01 2016 PHI NL 0.173683283 -0.275 C 0 1 PHI   2016 2018 FLA
5649 5649 Jeff Locke 28 lockeje01 2016 PIT NL 3.47169919 -0.105 P 5 1 PIT   2011 2016 FLA
5698 5698 Fernando Rodney 39 rodnefe01 2016 SDP NL 1.127286486 1.27 P 5 1 SDP CHC 2016 2016 FLA
5702 5702 Andrew Cashner 29 cashnan01 2016 SDP NL 2.252447354 0.065 P 4 1 SDP CHC 2012 2016 FLA
5703 5703 Colin Rea 25 reaco01 2016 SDP NL 2.759964139 0.02 P 4 1 SDP   2015 2016 FLA
5726 5726 Tayron Guerrero 25 guerrta01 2016 SDP NL 0.03370624 0.005 P 0 1 SDP   2016 2016 FLA
5915 5915 Oswaldo Arcia 25 arciaos01 2016 TBR AL 0.587610032 0.025 LF, RF 1 2 TBD MIN 2016 2016 FLA
6107 6107 Peter O'Brien 24 obriepe01 2015 ARI NL 0.117033799 0.12 LF 1 1 ARI   2015 2016 FLA
6157 6157 Edwin Jackson 31 jacksed01 2015 ATL NL 0.781070367 -0.075 P 1 2 ATL CHC 2015 2015 FLA
6187 6187 Wei-Yin Chen 29 chenwe02 2015 BAL AL 5.459781279 3.265 P 17 1 BAL   2012 2015 FLA
6248 6248 Junichi Tazawa 29 tazawju01 2015 BOS AL 2.050692069 0.795 P 5 1 BOS   2009 2016 FLA
6259 6259 Craig Breslow 34 breslcr01 2015 BOS AL 1.815716936 -0.07 P 2 1 BOS ARI 2012 2015 FLA
6353 6353 JB Shuck 28 shuckja01 2015 CHW AL 1.582602944 0.36 RF, CF, LF 3 1 CHW CLE 2015 2016 FLA
6367 6367 Hector Noesi 28 noesihe01 2015 CHW AL 0.713460068 -0.42 P 0 1 CHW TEX 2014 2015 FLA
6455 6455 Chris Johnson 30 johnsch05 2015 CLE AL 0.886442071 -0.120745342 3B, 1B 1 2 CLE ATL 2015 2015 FLA
6619 6619 Edinson Volquez 31 volqued01 2015 KCR AL 5.572641782 2.545 P 17 1 KCR PIT 2015 2016 FLA
6641 6641 Christian Colon 26 colonch01 2015 KCR AL 1.132775316 0.365 SS, 2B, 3B 3 1 KCR   2014 2017 FLA
6698 6698 Jo-Jo Reyes 30 reyesjo03 2015 LAA AL 0.00539031 0.005 P 0 1 ANA BAL 2015 2015 FLA
6857 6857 Yadiel Rivera 23 riverya01 2015 MIL NL 0.152337594 -0.055 2B, SS, 3B 0 1 MIL   2015 2017 FLA
7107 7107 Nefi Ogando 26 ogandne01 2015 PHI NL 0.069591058 -0.075 P 0 1 PHI   2015 2015 FLA
7117 7117 Dustin McGowan 33 mcgowdu01 2015 PHI NL 0.564016027 -0.645 P 0 1 PHI TOR 2015 2015 FLA
7133 7133 Jeff Locke 27 lockeje01 2015 PIT NL 4.509066237 0.21 P 8 1 PIT   2011 2016 FLA
7159 7159 Steve Lombardozzi 26 lombast02 2015 PIT NL 0.107317073 -0.285   0 1 PIT BAL 2015 2015 FLA
7173 7173 Andrew Cashner 28 cashnan01 2015 SDP NL 5.313148219 0.27 P 9 1 SDP CHC 2012 2016 FLA
7187 7187 Colin Rea 24 reaco01 2015 SDP NL 0.90625315 0.33 P 2 1 SDP   2015 2016 FLA
7299 7299 Cody Hall 27 hallco01 2015 SFG NL 0.189433915 -0.11 P 0 1 SFG   2015 2015 FLA
7306 7306 Casey McGehee 32 mcgehca01 2015 SFG NL 1.380237972 -0.72 3B, 1B 0 1 SFG FLA 2015 2015 FLA
7348 7348 Xavier Scruggs 27 scrugxa01 2015 STL NL 0.431040442 -0.115 1B 0 1 STL   2014 2015 FLA
7450 7450 Tomas Telis 24 telisto01 2015 TEX AL 0.112895377 -0.09 C 0 1 TEX   2014 2015 FLA
7558 7558 Tyler Moore 28 moorety01 2015 WSN NL 2.014938336 -1.16 1B, LF, P, RF 0 1 WSN   2012 2015 FLA
7656 7656 Wei-Yin Chen 28 chenwe02 2014 BAL AL 4.945197244 2.105 P 14 1 BAL   2012 2015 FLA
7707 7707 Junichi Tazawa 28 tazawju01 2014 BOS AL 2.311827746 0.84 P 6 1 BOS   2009 2016 FLA
7747 7747 Craig Breslow 33 breslcr01 2014 BOS AL 1.41622991 -1.11 P 0 1 BOS ARI 2012 2015 FLA
7806 7806 Hector Noesi 27 noesihe01 2014 CHW AL 4.52805259 0.505 P 8 3 CHW TEX 2014 2015 FLA
7838 7838 Andre Rienzo 25 rienzan01 2014 CHW AL 1.488917237 -1.0 P 0 1 CHW   2013 2014 FLA
7853 7853 Mat Latos 26 latosma01 2014 CIN NL 2.864835543 1.33 P 8 1 CIN SDP 2012 2014 FLA
7962 7962 Nick Masset 32 masseni01 2014 COL NL 1.262887025 -0.32 P 1 1 COL CIN 2014 2014 FLA
8005 8005 Don Kelly 34 kellydo01 2014 DET AL 1.737370466 -0.245 3B, 1B, RF, LF, CF, 2B 2 1 DET PIT 2009 2014 FLA
8041 8041 Jarred Cosart 24 cosarja01 2014 HOU AL 3.276547223 0.675 P 6 1 HOU   2013 2014 FLA
8045 8045 Enrique Hernandez 22 hernaen02 2014 HOU AL 0.855627383 0.815 CF, LF, SS, 2B, 3B, RF 4 1 HOU   2014 2014 FLA
8073 8073 Paul Clemens 26 clemepa02 2014 HOU AL 0.602354944 -0.6 P 0 1 HOU   2013 2014 FLA
8095 8095 Christian Colon 25 colonch01 2014 KCR AL 0.471153846 0.65 2B, 3B, SS 3 1 KCR   2014 2017 FLA
8183 8183 Dee Gordon 26 gordode01 2014 LAD NL 6.422487223 3.05 2B 18 1 LAD   2011 2014 FLA
8192 8192 Dan Haren 33 harenda01 2014 LAD NL 5.254116344 0.85 P 9 1 LAD WSN 2014 2014 FLA
8196 8196 Miguel Rojas 25 rojasmi02 2014 LAD NL 1.600681431 0.625 SS, 3B, 2B, LF 4 1 LAD   2014 2014 FLA
8416 8416 Ichiro Suzuki 40 suzukic01 2014 NYY AL 3.686643553 1.015 RF, LF, CF 9 1 NYY SEA 2012 2014 FLA
8420 8420 Martin Prado 30 pradoma01 2014 NYY AL 1.311870563 1.65 3B, 2B, RF, LF 7 2 NYY ARI 2014 2014 FLA
8427 8427 David Phelps 27 phelpda01 2014 NYY AL 3.146515734 0.065 P 5 1 NYY   2012 2014 FLA
8551 8551 Reid Brignac 28 brignre01 2014 PHI NL 0.90083632 -0.35 3B, 2B, SS 0 1 PHI NYY 2014 2014 FLA
8573 8573 Jeff Locke 26 lockeje01 2014 PIT NL 3.597349484 0.275 P 6 1 PIT   2011 2016 FLA

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