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

701 rows where prev_franch = "FLA"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, year_ID, lg_ID, stint_ID, franch_id, year_acq, year_left, 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
17 17 Zac Gallen 23 galleza01 2019 ARI NL 1.209048353 1.003584906 P 5 2 ARI FLA 2019 2019  
80 80 Rafael Ortega 28 ortegra01 2019 ATL NL 0.872777018 -0.315849057 LF, RF, CF 1 1 ATL FLA 2019 2019  
151 151 Dan Straily 30 straida01 2019 BAL AL 1.248253202 -1.21245283 P 0 1 BAL FLA 2019 2019  
302 302 Anthony DeSclafani 29 desclan01 2019 CIN NL 4.579019304 2.496226415 P 14 1 CIN FLA 2015 2019  
311 311 Derek Dietrich 29 dietrde01 2019 CIN NL 3.158007117 1.049433962 2B, 1B, LF, 3B 7 1 CIN FLA 2019 2019  
332 332 Christian Colon 30 colonch01 2019 CIN NL 0.061921708 0.106981132 2B 0 1 CIN FLA 2019 2019  
363 363 Nick Wittgren 28 wittgni01 2019 CLE AL 2.032736456 0.697924528 P 5 1 CLE FLA 2019 2019  
430 430 Mike Dunn 34 dunnmi01 2019 COL NL 0.573870355 -0.106981132 P 1 1 COL FLA 2017 2019  
461 461 Miguel Cabrera 36 cabremi01 2019 DET AL 5.32623034 -0.302468354 1B 5 1 DET FLA 2008 2019  
520 520 Jake Marisnick 28 marisja01 2019 HOU AL 2.893045564 1.258301887 CF 7 1 HOU FLA 2014 2019  
578 578 Brian Flynn 29 flynnbr01 2019 KCR AL 0.972308751 -0.061132075 P 1 1 KCR FLA 2016 2019  
611 611 Andrew Heaney 28 heanean01 2019 LAA AL 2.766828273 1.105471698 P 7 1 ANA FLA 2015 2019  
621 621 Dillon Peters 26 peterdi01 2019 LAA AL 1.865004287 0.13245283 P 3 1 ANA FLA 2019 2019  
667 667 Enrique Hernandez 27 hernaen02 2019 LAD NL 4.497673617 1.436603774 2B, CF, RF, LF, SS, 1B 11 1 LAD FLA 2015 2019  
752 752 Christian Yelich 27 yelicch01 2019 MIL NL 5.719143149 7.621132075 RF, LF, CF 32 1 MIL FLA 2018 2019  
829 829 Sergio Romo 36 romose01 2019 MIN AL 0.786992532 0.331132075 P 2 2 MIN FLA 2019 2019  
934 934 Giancarlo Stanton 29 stantmi03 2019 NYY AL 0.569837891 0.244528302 LF, RF 2 1 NYY FLA 2018 2019  
1007 1007 J.T. Realmuto 28 realmjt01 2019 PHI NL 5.914703353 5.175849057 C, 1B 25 1 PHI FLA 2019 2019  
1089 1089 JB Shuck 32 shuckja01 2019 PIT NL 0.569214876 0.00509434 RF, LF, CF, P 1 1 PIT FLA 2019 2019  
1185 1185 Dee Gordon 31 gordode01 2019 SEA AL 4.006264425 0.27 2B, SS 6 1 SEA FLA 2018 2019  
1216 1216 Ichiro Suzuki 45 suzukic01 2019 SEA AL 0.057368942 -0.045849057 RF 0 1 SEA FLA 2018 2019  
1308 1308 Marcell Ozuna 28 ozunama01 2019 STL NL 5.400523104 2.302641509 LF 15 1 STL FLA 2018 2019  
1365 1365 Nick Anderson 28 anderni01 2019 TBR AL 0.857363525 0.94754717 P 4 2 TBD FLA 2019 2019  
1371 1371 Trevor Richards 26 richatr01 2019 TBR AL 0.686560635 0.54509434 P 3 2 TBD FLA 2019 2019  
1441 1441 Edinson Volquez 35 volqued01 2019 TEX AL 0.387471205 -0.112075472 P 0 1 TEX FLA 2019 2019  
1487 1487 Javy Guerra 33 guerrja01 2019 TOR AL 0.412695766 0.193584906 P 1 1 TOR FLA 2019 2019 WSN
1561 1561 Kyle Barraclough 29 barraky01 2019 WSN NL 0.960944092 -0.641886792 P 0 1 WSN FLA 2019 2019 SFG
1582 1582 Jeff Mathis 35 mathije01 2018 ARI NL 2.170643777 0.39 C, 2B, P 4 1 ARI FLA 2017 2018 TEX
1595 1595 Brad Ziegler 38 zieglbr01 2018 ARI NL 0.812988593 0.105 P 1 2 ARI FLA 2018 2018  
1887 1887 Anthony DeSclafani 28 desclan01 2018 CIN NL 3.258536235 0.635 P 6 1 CIN FLA 2015 2019  
1923 1923 Austin Brice 26 briceau01 2018 CIN NL 0.973441229 -0.485 P 0 1 CIN FLA 2017 2018 FLA
2011 2011 Mike Dunn 33 dunnmi01 2018 COL NL 0.414983532 -0.362760736 P 0 1 COL FLA 2017 2019  
2030 2030 Miguel Cabrera 35 cabremi01 2018 DET AL 1.515141431 0.63 1B 4 1 DET FLA 2008 2019  
2056 2056 Jacob Turner 27 turneja01 2018 DET AL 0.028687225 -0.23 P 0 2 DET FLA 2018 2018  
2080 2080 Jake Marisnick 27 marisja01 2018 HOU AL 2.226760333 1.37 CF, LF, RF 7 1 HOU FLA 2014 2019  
2125 2125 Brian Flynn 28 flynnbr01 2018 KCR AL 1.957800127 0.255 P 3 1 KCR FLA 2016 2019  
2159 2159 Andrew Heaney 27 heanean01 2018 LAA AL 5.352514734 2.1 P 13 1 ANA FLA 2015 2019  
2193 2193 Junichi Tazawa 32 tazawju01 2018 LAA AL 0.180947898 0.05 P 0 2 ANA FLA 2018 2018  
2208 2208 Odrisamer Despaigne 31 despaod01 2018 LAA AL 0.501930066 -0.38 P 0 2 ANA FLA 2018 2018 CHW
2222 2222 Enrique Hernandez 26 hernaen02 2018 LAD NL 4.44746888 2.892147239 CF, 2B, SS, RF, LF, 3B, 1B, P 14 1 LAD FLA 2015 2019  
2318 2318 Christian Yelich 26 yelicch01 2018 MIL NL 6.383431953 7.563312883 LF, RF, CF 33 1 MIL FLA 2018 2019  
2470 2470 AJ Ramos 31 ramosaj01 2018 NYM NL 0.681948097 -0.33 P 0 1 NYM FLA 2017 2018  
2484 2484 Giancarlo Stanton 28 stantmi03 2018 NYY AL 6.543446952 4.155 RF, LF 21 1 NYY FLA 2018 2019  
2617 2617 Justin Bour 30 bourju01 2018 PHI NL 0.536668951 -0.085 1B 1 2 PHI FLA 2018 2018 ANA
2700 2700 Brad Hand 28 handbr01 2018 SDP NL 1.889043144 0.285 P 4 1 SDP FLA 2016 2018 CLE
2704 2704 A.J. Ellis 37 ellisaj01 2018 SDP NL 1.840790843 0.09 C, LF 3 1 SDP FLA 2018 2018  
2739 2739 Dee Gordon 30 gordode01 2018 SEA AL 5.623083265 0.315 2B, CF, SS 10 1 SEA FLA 2018 2019  
2766 2766 Cameron Maybin 31 maybica01 2018 SEA AL 0.927617477 -0.185 LF, CF, RF 1 2 SEA FLA 2018 2018 NYY
2778 2778 Ichiro Suzuki 44 suzukic01 2018 SEA AL 0.449464138 -0.47 LF, RF 0 1 SEA FLA 2018 2019  
2832 2832 Marcell Ozuna 27 ozunama01 2018 STL NL 6.201941086 2.85 LF 18 1 STL FLA 2018 2019  
2896 2896 Adeiny Hechavarria 29 hechaad01 2018 TBR AL 2.226794103 0.73 SS, 3B 5 1 TBD FLA 2017 2018 PIT
3113 3113 Fernando Rodney 40 rodnefe01 2017 ARI NL 2.392462074 0.77 P 6 1 ARI FLA 2017 2017 MIN
3122 3122 Jeff Mathis 34 mathije01 2017 ARI NL 2.004426285 -0.06 C 3 1 ARI FLA 2017 2018 TEX
3359 3359 Dan Jennings 30 jennida01 2017 CHW AL 1.410302297 0.285 P 3 1 CHW FLA 2015 2017 TBD
3369 3369 Rob Brantly 27 brantro01 2017 CHW AL 0.345752608 0.245 C, P 1 1 CHW FLA 2015 2017 PHI
3419 3419 Austin Brice 25 briceau01 2017 CIN NL 0.879817562 -0.09 P 1 1 CIN FLA 2017 2018 FLA
3498 3498 Mike Dunn 32 dunnmi01 2017 COL NL 1.588785024 0.445 P 4 1 COL FLA 2017 2019  
3533 3533 Miguel Cabrera 34 cabremi01 2017 DET AL 5.006853786 -0.425 1B 5 1 DET FLA 2008 2019  
3539 3539 Anibal Sanchez 33 sanchan01 2017 DET AL 2.754277399 -0.165 P 3 1 DET FLA 2012 2017 ATL
3581 3581 Jake Marisnick 26 marisja01 2017 HOU AL 2.406600449 1.63 CF, LF, RF 8 1 HOU FLA 2014 2019  
3645 3645 Brian Flynn 27 flynnbr01 2017 KCR AL 0.036931522 0.015 P 0 1 KCR FLA 2016 2019  
3714 3714 Andrew Heaney 26 heanean01 2017 LAA AL 0.603176629 -0.52 P 0 1 ANA FLA 2015 2019  
3729 3729 Enrique Hernandez 25 hernaen02 2017 LAD NL 3.382673943 1.415 CF, LF, SS, RF, 3B, 2B, 1B 9 1 LAD FLA 2015 2019  
3745 3745 Chris Hatcher 32 hatchch02 2017 LAD NL 0.83849352 -0.005 P 1 1 LAD FLA 2015 2017 OAK
3892 3892 Craig Breslow 36 breslcr01 2017 MIN AL 0.700893588 -0.095 P 1 1 MIN FLA 2017 2017 CLE
3946 3946 AJ Ramos 30 ramosaj01 2017 NYM NL 0.690160504 0.09 P 1 2 NYM FLA 2017 2018  
4109 4109 Henderson Alvarez III 27 alvarhe01 2017 PHI NL 0.419687606 -0.005 P 0 1 PHI FLA 2017 2017  
4173 4173 Brad Hand 27 handbr01 2017 SDP NL 3.183267339 2.345 P 12 1 SDP FLA 2016 2018 CLE
4198 4198 Jarred Cosart 27 cosarja01 2017 SDP NL 0.657750753 0.06 P 1 1 SDP FLA 2016 2017  
4205 4205 Jake Esch 27 eschja01 2017 SDP NL 0.0 0.0 P 0 1 SDP FLA 2017 2017  
4207 4207 Carter Capps 26 cappsca01 2017 SDP NL 0.248372579 -0.06 P 0 1 SDP FLA 2017 2017  
4253 4253 David Phelps 30 phelpda01 2017 SEA AL 0.369329198 0.21 P 1 2 SEA FLA 2017 2017 TOR
4316 4316 Bryan Morris 30 morribr01 2017 SFG NL 0.510214994 -0.075 P 0 1 SFG FLA 2017 2017  
4389 4389 Adeiny Hechavarria 28 hechaad01 2017 TBR AL 2.662201895 1.325 SS 7 2 TBD FLA 2017 2018 PIT
4433 4433 Andrew Cashner 30 cashnan01 2017 TEX AL 4.804059357 3.42 P 17 1 TEX FLA 2017 2017 BAL
4482 4482 Sam Dyson 29 dysonsa01 2017 TEX AL 0.618394875 -1.195 P 0 1 TEX FLA 2015 2017 SFG
4508 4508 Tom Koehler 31 koehlto01 2017 TOR AL 0.452478639 0.39 P 2 2 TOR FLA 2017 2017  
4689 4689 Reid Brignac 30 brignre01 2016 ATL NL 0.286151752 -0.100621118 3B, 2B 0 1 ATL FLA 2016 2016  
4858 4858 Dan Jennings 29 jennida01 2016 CHW AL 1.868098841 1.275 P 6 1 CHW FLA 2015 2017 TBD
4900 4900 Anthony DeSclafani 26 desclan01 2016 CIN NL 3.497973545 2.415 P 13 1 CIN FLA 2015 2019  
5043 5043 Miguel Cabrera 33 cabremi01 2016 DET AL 6.451834862 4.799627329 1B, 3B 23 1 DET FLA 2008 2019  
5058 5058 Anibal Sanchez 32 sanchan01 2016 DET AL 4.472887447 -0.070434783 P 6 1 DET FLA 2012 2017 ATL
5082 5082 Casey McGehee 33 mcgehca01 2016 DET AL 0.912188729 -0.367267081 3B, 1B 0 1 DET FLA 2016 2016  
5101 5101 Jake Marisnick 25 marisja01 2016 HOU AL 2.91829801 1.115 CF, LF, RF 7 1 HOU FLA 2014 2019  
5145 5145 Brian Flynn 26 flynnbr01 2016 KCR AL 1.616604339 0.695 P 5 1 KCR FLA 2016 2019  
5201 5201 Cody Ege 25 egeco01 2016 LAA AL 0.235945151 0.215 P 1 2 ANA FLA 2016 2016  
5208 5208 Andrew Heaney 25 heanean01 2016 LAA AL 0.174547556 -0.015 P 0 1 ANA FLA 2015 2019  
5246 5246 Enrique Hernandez 24 hernaen02 2016 LAD NL 2.420800547 0.005 LF, CF, 2B, RF, 3B, SS 3 1 LAD FLA 2015 2019  
5274 5274 Chris Hatcher 31 hatchch02 2016 LAD NL 1.244798128 -0.49 P 0 1 LAD FLA 2015 2017 OAK
5489 5489 Nathan Eovaldi 26 eovalna01 2016 NYY AL 3.428746053 0.99 P 8 1 NYY FLA 2015 2016 TBD
5514 5514 Donovan Solano 28 solando01 2016 NYY AL 0.2208975 0.01 2B, 3B 0 1 NYY FLA 2016 2016 SFG
5655 5655 Arquimedes Caminero 29 caminar01 2016 PIT NL 1.130134861 0.19 P 2 1 PIT FLA 2015 2016 SEA
5661 5661 Zach Phillips 29 phillza01 2016 PIT NL 0.190752703 0.09 P 1 1 PIT FLA 2016 2016  
5678 5678 Mike Morse 34 morsemi01 2016 PIT NL 0.078114478 -0.21 1B 0 1 PIT FLA 2015 2016 SFG
5691 5691 Brad Hand 26 handbr01 2016 SDP NL 3.214542896 1.525 P 9 1 SDP FLA 2016 2018 CLE
5707 5707 Paul Clemens 28 clemepa02 2016 SDP NL 1.98350597 0.125 P 3 2 SDP FLA 2016 2016  
5708 5708 Edwin Jackson 32 jacksed01 2016 SDP NL 2.082094192 0.1 P 3 2 SDP FLA 2016 2016 BAL
5722 5722 Jarred Cosart 26 cosarja01 2016 SDP NL 1.059975225 -0.285 P 1 2 SDP FLA 2016 2017  
5738 5738 Oswaldo Arcia 25 arciaos01 2016 SDP NL 0.458618872 -0.565 LF, RF 0 4 SDP FLA 2016 2016  
5839 5839 Vin Mazzaro 29 mazzavi01 2016 SFG NL 0.02136612 -0.28 P 0 1 SFG FLA 2016 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
);