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,944 rows where prev_franch = "DET"

✎ 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
8 8 Robbie Ray 27 rayro02 2019 ARI NL 4.686028957 1.594528302 P 11 1 ARI DET 2015 2019  
72 72 Shane Greene 30 greensh02 2019 ATL NL 0.792363891 0.341320755 P 2 2 ATL DET 2019 2019  
164 164 Rick Porcello 30 porceri01 2019 BOS AL 4.863157895 1.380566038 P 10 1 BOS DET 2015 2019  
212 212 Nicholas Castellanos 27 casteni01 2019 CHC NL 2.275104603 1.686226415 RF, LF 8 2 CHC DET 2019 2019  
214 214 Kyle Ryan 27 ryanky01 2019 CHC NL 2.01628451 1.222641509 P 6 1 CHC DET 2019 2019  
241 241 Jim Adduci 34 adducji02 2019 CHC NL 0.05055788 -0.122264151 RF 0 1 CHC DET 2019 2019  
255 255 James McCann 29 mccanja02 2019 CHW AL 4.62745098 3.034936709 C 16 1 CHW DET 2019 2019  
300 300 Eugenio Suarez 27 suareeu01 2019 CIN NL 6.677224199 4.508490566 3B 22 1 CIN DET 2015 2019  
304 304 Jose Iglesias 29 iglesjo01 2019 CIN NL 5.356227758 1.334716981 SS 11 1 CIN DET 2019 2019  
373 373 Leonys Martin 31 martile01 2019 CLE AL 2.551149617 -0.422830189 CF 3 1 CLE DET 2018 2019  
504 504 Justin Verlander 36 verlaju01 2019 HOU AL 6.257692454 7.101509434 P 28 1 HOU DET 2017 2019  
626 626 Justin Upton 31 uptonju01 2019 LAA AL 2.422581171 -0.550188679 LF 2 1 ANA DET 2017 2019  
726 726 Bryan Holaday 31 holadbr01 2019 MIA NL 1.287744227 0.091698113 C, P 2 1 FLA DET 2018 2019  
777 777 Hernan Perez 28 perezhe01 2019 MIL NL 2.386263176 -0.249622642 2B, SS, 3B, RF, 1B, LF, P 3 1 MIL DET 2015 2019  
800 800 Alex Wilson 32 wilsoal01 2019 MIL NL 0.332784906 -0.443207547 P 0 1 MIL DET 2019 2019  
949 949 Joe Mantiply 28 mantijo01 2019 NYY AL 0.071178278 -0.096792453 P 0 1 NYY DET 2019 2019  
964 964 Mike Fiers 34 fiersmi01 2019 OAK AL 4.956039029 2.210943396 P 14 1 OAK DET 2018 2019  
1075 1075 Francisco Liriano 35 liriafr01 2019 PIT NL 2.324865759 0.799811321 P 6 1 PIT DET 2019 2019  
1218 1218 David McKay 24 mckayda02 2019 SEA AL 0.115480201 -0.061132075 P 0 2 SEA DET 2019 2019  
1300 1300 Mike Gerber 26 gerbemi01 2019 SFG NL 0.251343387 -0.499245283 LF, RF 0 1 SFG DET 2019 2019  
1517 1517 Max Scherzer 34 scherma01 2019 WSN NL 4.99171193 6.306792453 P 25 1 WSN DET 2015 2019  
1575 1575 Robbie Ray 26 rayro02 2018 ARI NL 3.368240474 0.865 P 7 1 ARI DET 2015 2019  
1622 1622 Anibal Sanchez 34 sanchan01 2018 ATL NL 3.737772777 2.32 P 12 1 ATL DET 2018 2018 WSN
1734 1734 Rick Porcello 29 porceri01 2018 BOS AL 5.275995848 2.925 P 17 1 BOS DET 2015 2019  
1769 1769 William Cuevas 27 cuevawi01 2018 BOS AL 0.421143793 -0.24 P 0 1 BOS DET 2018 2018  
1793 1793 Justin Wilson 30 wilsoju10 2018 CHC NL 1.836299812 0.660920245 P 5 1 CHC DET 2017 2018 NYM
1815 1815 Efren Navarro 32 navaref01 2018 CHC NL 0.057615894 -0.094417178 1B 0 1 CHC DET 2018 2018  
1838 1838 Avisail Garcia 27 garciav01 2018 CHW AL 3.690909091 0.205 RF 5 1 CHW DET 2013 2018 TBD
1867 1867 Bruce Rondon 27 rondobr01 2018 CHW AL 0.905432495 -0.485 P 0 1 CHW DET 2018 2018  
1874 1874 Eugenio Suarez 26 suareeu01 2018 CIN NL 5.9643645 4.055 3B, SS 20 1 CIN DET 2015 2019  
1954 1954 Leonys Martin 30 martile01 2018 CLE AL 0.157156519 0.22 CF, RF 1 2 CLE DET 2018 2019  
2066 2066 Justin Verlander 35 verlaju01 2018 HOU AL 5.85326068 6.41 P 27 1 HOU DET 2017 2019  
2157 2157 Justin Upton 30 uptonju01 2018 LAA AL 5.841932304 3.45 LF 18 1 ANA DET 2017 2019  
2160 2160 Ian Kinsler 36 kinslia01 2018 LAA AL 3.726256983 2.365 2B 12 1 ANA DET 2018 2018 BOS
2165 2165 Jose Alvarez 29 alvarjo02 2018 LAA AL 2.391549137 1.305 P 7 1 ANA DET 2014 2018 PHI
2185 2185 Jefry Marte 27 marteje01 2018 LAA AL 1.991784423 -0.275 1B, 3B, LF 2 1 ANA DET 2016 2018  
2289 2289 Bryan Holaday 30 holadbr01 2018 MIA NL 1.66 -0.030186335 C, P 2 1 FLA DET 2018 2019  
2333 2333 Hernan Perez 27 perezhe01 2018 MIL NL 3.275063398 0.64601227 2B, RF, 3B, SS, LF, 1B, CF, P 7 1 MIL DET 2015 2019  
2336 2336 Corey Knebel 26 knebeco01 2018 MIL NL 2.010509965 0.641042945 P 5 1 MIL DET 2015 2018  
2440 2440 Yoenis Cespedes 32 cespeyo01 2018 NYM NL 1.558179329 0.91 LF 5 1 NYM DET 2015 2018  
2479 2479 Matt den Dekker 30 dendema01 2018 NYM NL 0.208418891 -0.615 CF 0 1 NYM DET 2018 2018  
2551 2551 Mike Fiers 33 fiersmi01 2018 OAK AL 1.460278246 0.48 P 4 2 OAK DET 2018 2019  
2754 2754 Andrew Romine 32 rominan01 2018 SEA AL 1.252761748 -0.135 2B, SS, 1B, 3B, LF, P, CF, RF 2 1 SEA DET 2018 2018  
3045 3045 Max Scherzer 33 scherma01 2018 WSN NL 6.203642561 8.85 P 34 1 WSN DET 2015 2019  
3100 3100 Robbie Ray 25 rayro02 2017 ARI NL 4.523698998 4.47 P 20 1 ARI DET 2015 2019  
3108 3108 J.D. Martinez 29 martijd02 2017 ARI NL 2.537623425 2.41 RF 11 2 ARI DET 2017 2017 BOS
3176 3176 Ian Krol 26 krolia01 2017 ATL NL 1.324048339 -0.4 P 1 1 ATL DET 2016 2017 ANA
3252 3252 Rick Porcello 28 porceri01 2017 BOS AL 5.434628238 0.855 P 11 1 BOS DET 2015 2019  
3314 3314 Alex Avila 30 avilaal01 2017 CHC NL 1.094892972 0.54 C, 1B 3 2 CHC DET 2017 2017 ARI
3319 3319 Justin Wilson 29 wilsoju10 2017 CHC NL 0.497812677 0.035 P 1 2 CHC DET 2017 2018 NYM
3339 3339 Avisail Garcia 26 garciav01 2017 CHW AL 5.387978142 4.405 RF 20 1 CHW DET 2013 2018 TBD
3379 3379 Mike Pelfrey 33 pelfrmi01 2017 CHW AL 3.237270641 -1.05 P 1 1 CHW DET 2017 2017  
3391 3391 Eugenio Suarez 25 suareeu01 2017 CIN NL 6.228717077 3.785 3B, SS 19 1 CIN DET 2015 2019  
3583 3583 Justin Verlander 34 verlaju01 2017 HOU AL 0.962857758 1.435 P 6 2 HOU DET 2017 2019  
3668 3668 Cameron Maybin 30 maybica01 2017 LAA AL 3.708856576 1.495 LF, CF, RF 10 1 ANA DET 2017 2017 HOU
3683 3683 Justin Upton 29 uptonju01 2017 LAA AL 1.102115003 0.685 LF 4 2 ANA DET 2017 2019  
3688 3688 Jose Alvarez 28 alvarjo02 2017 LAA AL 1.579424577 0.33 P 3 1 ANA DET 2014 2018 PHI
3706 3706 Jose Valdez 27 valdejo03 2017 LAA AL 0.021735201 -0.095 P 0 1 ANA DET 2016 2017 SDP
3715 3715 Jefry Marte 26 marteje01 2017 LAA AL 1.389623265 -0.655 1B, 3B, LF 0 1 ANA DET 2016 2018  
3801 3801 Mike Aviles 36 avilemi01 2017 MIA NL 0.948735245 -0.145 SS, 2B, 3B, 1B, RF 1 1 FLA DET 2017 2017  
3817 3817 Corey Knebel 25 knebeco01 2017 MIL NL 3.279803539 3.235 P 14 1 MIL DET 2015 2018  
3823 3823 Hernan Perez 26 perezhe01 2017 MIL NL 4.56504554 0.79 LF, 3B, RF, CF, 2B, SS, 1B, P 9 1 MIL DET 2015 2019  
3919 3919 Yoenis Cespedes 31 cespeyo01 2017 NYM NL 3.18528657 1.89 LF 10 1 NYM DET 2015 2018  
4184 4184 Erick Aybar 33 aybarer01 2017 SDP NL 3.800247919 -0.02 SS, P 6 1 SDP DET 2017 2017  
4378 4378 Jhonny Peralta 35 peraljh01 2017 STL NL 0.571234505 -0.385 3B 0 1 STL DET 2014 2017  
4500 4500 Ezequiel Carrera 30 carreez01 2017 TOR AL 3.075040783 0.21 LF, RF, CF 5 1 TOR DET 2015 2017  
4541 4541 Jarrod Saltalamacchia 32 saltaja01 2017 TOR AL 0.246003263 -0.6 C 0 1 TOR DET 2017 2017 DET
4543 4543 Max Scherzer 32 scherma01 2017 WSN NL 5.594122992 7.05 P 29 1 WSN DET 2015 2019  
4596 4596 Robbie Ray 24 rayro02 2016 ARI NL 4.773369528 2.28 P 13 1 ARI DET 2015 2019  
4653 4653 Ian Krol 25 krolia01 2016 ATL NL 1.722909227 0.940807453 P 5 1 ATL DET 2016 2017 ANA
4687 4687 Matt Tuiasosopo 30 tuiasma01 2016 ATL NL 0.029601905 -0.090559006   0 1 ATL DET 2016 2016  
4752 4752 Rick Porcello 27 porceri01 2016 BOS AL 6.146769286 4.97 P 22 1 BOS DET 2015 2019  
4834 4834 Joe Nathan 41 nathajo01 2016 CHC NL 0.037656546 0.04 P 0 1 CHC DET 2016 2016 SFG
4857 4857 Avisail Garcia 25 garciav01 2016 CHW AL 4.300867572 0.565 RF, LF 7 1 CHW DET 2013 2018 TBD
4860 4860 Alex Avila 29 avilaal01 2016 CHW AL 1.98428548 0.775 C 5 1 CHW DET 2016 2016 DET
4899 4899 Eugenio Suarez 24 suareeu01 2016 CIN NL 6.305878273 1.485 3B, SS 14 1 CIN DET 2015 2019  
4945 4945 Alfredo Simon 35 simonal01 2016 CIN NL 1.646105198 -1.51 P 0 1 CIN DET 2016 2016  
4958 4958 Rajai Davis 35 davisra01 2016 CLE AL 4.683523654 1.157142857 CF, LF, RF 10 1 CLE DET 2016 2016 OAK
4991 4991 Tom Gorzelanny 33 gorzeto01 2016 CLE AL 0.09103286 -0.357204969 P 0 1 CLE DET 2016 2016  
5019 5019 Justin Miller 29 milleju02 2016 COL NL 1.036850952 0.03 P 1 1 COL DET 2015 2016 WSN
5119 5119 Danny Worth 30 worthda01 2016 HOU AL 0.375343796 -0.185 2B, 3B, SS 0 1 HOU DET 2016 2016  
5156 5156 Omar Infante 34 infanom01 2016 KCR AL 1.432929862 -0.18 2B 2 1 KCR DET 2014 2016  
5178 5178 Jefry Marte 25 marteje01 2016 LAA AL 2.736212625 1.25 1B, LF, 3B 7 1 ANA DET 2016 2018  
5187 5187 Jose Alvarez 27 alvarjo02 2016 LAA AL 1.819526035 0.405 P 4 1 ANA DET 2014 2018 PHI
5205 5205 Jose Valdez 26 valdejo03 2016 LAA AL 0.77317411 -0.11 P 1 1 ANA DET 2016 2017 SDP
5210 5210 Al Alburquerque 30 albural01 2016 LAA AL 0.036402966 -0.105 P 0 1 ANA DET 2016 2016 KCR
5324 5324 Don Kelly 36 kellydo01 2016 MIA NL 0.299123259 -0.206273292 1B 0 1 FLA DET 2015 2016  
5338 5338 Hernan Perez 25 perezhe01 2016 MIL NL 4.335883171 1.545 3B, RF, 2B, CF, 1B, SS, LF 11 1 MIL DET 2015 2019  
5358 5358 Corey Knebel 24 knebeco01 2016 MIL NL 1.146630511 0.095 P 2 1 MIL DET 2015 2018  
5424 5424 Casey Fien 32 fienca01 2016 MIN AL 0.441283082 -0.375 P 0 1 MIN DET 2012 2016 LAD
5431 5431 Yoenis Cespedes 30 cespeyo01 2016 NYM NL 5.4375 3.42 LF, CF 18 1 NYM DET 2015 2018  
5652 5652 Neftali Feliz 28 felizne01 2016 PIT NL 1.945577697 0.43 P 4 1 PIT DET 2016 2016 MIL
5658 5658 Kyle Lobstein 26 lobstky01 2016 PIT NL 0.722812925 0.145 P 1 1 PIT DET 2016 2016  
5861 5861 Jhonny Peralta 34 peraljh01 2016 STL NL 3.078514499 -0.2 3B, SS 4 1 STL DET 2014 2017  
5892 5892 Drew Smyly 27 smylydr01 2016 TBR AL 4.932156646 0.915 P 8 1 TBD DET 2014 2016 TEX
5957 5957 Bryan Holaday 28 holadbr01 2016 TEX AL 0.898631943 0.185 C, 3B, LF, P 2 1 TEX DET 2016 2016 BOS
5958 5958 Bobby Wilson 33 wilsobo02 2016 TEX AL 1.347947915 -0.085 C 2 2 TEX DET 2016 2016 TBD
5959 5959 Prince Fielder 32 fieldpr01 2016 TEX AL 3.537168287 -1.585 1B 2 1 TEX DET 2014 2016  
5998 5998 Ezequiel Carrera 29 carreez01 2016 TOR AL 2.9 0.655 RF, LF, CF 6 1 TOR DET 2015 2017  
6031 6031 Max Scherzer 31 scherma01 2016 WSN NL 6.269128994 6.125 P 27 1 WSN DET 2015 2019  

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