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,176 rows where prev_franch = "PIT"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, lg_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
71 71 Francisco Cervelli 33 cervefr01 2019 ATL NL 0.30745554 0.463584906 C, 1B 2 2 ATL PIT 2019 2019  
165 165 Brock Holt 31 holtbr01 2019 BOS AL 2.597287922 1.309245283 2B, 1B, RF, SS, 3B, LF 7 1 BOS PIT 2013 2019  
257 257 Ivan Nova 32 novaiv01 2019 CHW AL 5.468501452 1.978860759 P 14 1 CHW PIT 2019 2019  
326 326 Ryan Lavarnway 31 lavarry01 2019 CIN NL 0.196085409 0.208867925 C 1 1 CIN PIT 2019 2019  
355 355 Jordan Luplow 25 luplojo01 2019 CLE AL 2.473842053 1.676037736 RF, LF, CF 9 1 CLE PIT 2019 2019  
397 397 Max Moroff 26 morofma01 2019 CLE AL 0.338220593 -0.290377358 2B, SS, 3B 0 1 CLE PIT 2019 2019  
464 464 Jordy Mercer 32 mercejo03 2019 DET AL 2.569930661 0.410126582 SS, 2B, 1B, 3B 4 1 DET PIT 2019 2019  
502 502 Josh Harrison 31 harrijo05 2019 DET AL 1.441907661 -0.794620253 2B 0 1 DET PIT 2019 2019  
505 505 Gerrit Cole 28 colege01 2019 HOU AL 5.97893196 7.01490566 P 28 1 HOU PIT 2018 2019  
670 670 David Freese 36 freesda01 2019 LAD NL 1.839048768 1.502830189 1B, 3B 7 1 LAD PIT 2018 2019  
768 768 Jordan Lyles 28 lylesjo01 2019 MIL NL 1.593452434 1.237924528 P 6 2 MIL PIT 2019 2019  
948 948 Tyler Lyons 31 lyonsty01 2019 NYY AL 0.16714728 -0.050943396 P 0 2 NYY PIT 2019 2019  
994 994 Tanner Anderson 26 anderta01 2019 OAK AL 0.612779902 4.41864e-18 P 1 1 OAK PIT 2019 2019  
1025 1025 Corey Dickerson 30 dickeco01 2019 PHI NL 1.366466036 0.341320755 LF 3 2 PHI PIT 2019 2019  
1034 1034 Sean Rodriguez 34 rodrise01 2019 PHI NL 1.256749785 0.081509434 3B, LF, SS, RF, 2B, CF, P, 1B 2 1 PHI PIT 2019 2019  
1188 1188 Wade LeBlanc 34 leblawa01 2019 SEA AL 3.51692973 0.076415094 P 5 1 SEA PIT 2018 2019  
1346 1346 Austin Meadows 24 meadoau01 2019 TBR AL 5.489673118 4.034716981 RF, LF, CF 20 1 TBD PIT 2018 2019  
1358 1358 Tyler Glasnow 25 glasnty01 2019 TBR AL 1.503926621 2.261886792 P 9 1 TBD PIT 2018 2019  
1382 1382 Casey Sadler 28 sadleca02 2019 TBR AL 0.377393052 0.229245283 P 1 1 TBD PIT 2019 2019 LAD
1483 1483 Nick Kingham 27 kinghni01 2019 TOR AL 0.642093146 0.229245283 P 2 2 TOR PIT 2019 2019  
1657 1657 Chris Stewart 36 stewach01 2018 ATL NL 0.156677359 -0.065 C 0 1 ATL PIT 2018 2018 ARI
1706 1706 Pedro Alvarez 31 alvarpe01 2018 BAL AL 1.225420063 -0.125 3B, 1B 1 1 BAL PIT 2016 2018  
1738 1738 Brock Holt 30 holtbr01 2018 BOS AL 3.388411334 1.34 2B, SS, RF, 1B, LF, 3B 9 1 BOS PIT 2013 2019  
1866 1866 Chris Volstad 31 volstch01 2018 CHW AL 1.366342588 -0.45 P 0 1 CHW PIT 2017 2018  
1961 1961 George Kontos 33 kontoge01 2018 CLE AL 0.083673474 0.03 P 0 2 CLE PIT 2018 2018 NYY
2052 2052 Josh Smoker 29 smokejo01 2018 DET AL 0.031040278 0.035 P 0 2 DET PIT 2018 2018  
2060 2060 Johnny Barbato 25 barbajo01 2018 DET AL 0.154200093 -0.395 P 0 1 DET PIT 2018 2018  
2067 2067 Gerrit Cole 27 colege01 2018 HOU AL 5.479454313 5.505 P 24 1 HOU PIT 2018 2019  
2147 2147 Enny Romero 27 romeren01 2018 KCR AL 0.11306793 -0.485 P 0 3 KCR PIT 2018 2018  
2239 2239 David Freese 35 freesda01 2018 LAD NL 0.452448133 0.601288344 3B, 1B 2 2 LAD PIT 2018 2019  
2252 2252 Daniel Hudson 31 hudsoda01 2018 LAD NL 1.33880385 -0.248466258 P 1 1 LAD PIT 2018 2018 TOR
2300 2300 Christopher Bostick 25 bostich01 2018 MIA NL 0.16 -0.010062112 2B, LF 0 2 FLA PIT 2018 2018  
2335 2335 Keon Broxton 28 broxtke01 2018 MIL NL 0.872696534 1.361595092 CF, RF 5 1 MIL PIT 2016 2018 NYM
2520 2520 Adeiny Hechavarria 29 hechaad01 2018 NYY AL 0.343414946 -0.035 SS, 3B 0 3 NYY PIT 2018 2018 NYM
2552 2552 Matthew Joyce 33 joycema01 2018 OAK AL 2.288739172 0.125 LF, RF, CF 4 1 OAK PIT 2017 2018 ATL
2615 2615 Drew Hutchison 27 hutchdr01 2018 PHI NL 0.492376483 0.055 P 1 1 PHI PIT 2018 2018 TEX
2628 2628 Pedro Florimon 31 floripe01 2018 PHI NL 0.755311857 -0.32 SS, 2B, RF, P, 3B, CF 0 1 PHI PIT 2017 2018  
2736 2736 Wade LeBlanc 33 leblawa01 2018 SEA AL 4.209909746 2.01 P 13 1 SEA PIT 2018 2019  
2783 2783 Andrew McCutchen 31 mccutan01 2018 SFG NL 5.680979479 1.925 RF, LF 15 1 SFG PIT 2018 2018 NYY
2792 2792 Gorkys Hernandez 30 hernago01 2018 SFG NL 4.51077772 0.36 CF, LF, RF 8 1 SFG PIT 2016 2018 BOS
2902 2902 Tyler Glasnow 24 glasnty01 2018 TBR AL 1.475825752 0.565 P 4 2 TBD PIT 2018 2019  
2926 2926 Austin Meadows 23 meadoau01 2018 TBR AL 0.244289648 -0.115 CF, RF, LF 0 2 TBD PIT 2018 2019  
2986 2986 J.A. Happ 35 happja01 2018 TOR AL 3.291628169 1.69 P 10 1 TOR PIT 2016 2018 NYY
2988 2988 Russell Martin 35 martiru01 2018 TOR AL 3.373430271 1.225 C, 3B, SS, LF 9 1 TOR PIT 2015 2018 LAD
3028 3028 Brandon Cumpton 29 cumptbr01 2018 TOR AL 0.034556567 0.005 P 0 1 TOR PIT 2018 2018  
3043 3043 Gift Ngoepe 28 ngoepgi01 2018 TOR AL 0.182088566 -0.295 SS, 2B, 3B 0 1 TOR PIT 2018 2018  
3181 3181 Tony Sanchez 29 sanchto01 2017 ATL NL 0.009840516 -0.015   0 1 ATL PIT 2017 2017  
3183 3183 Sean Rodriguez 32 rodrise01 2017 ATL NL 0.462504242 -0.1 3B, RF, 2B, SS, LF, CF, 1B 0 1 ATL PIT 2017 2017 PIT
3220 3220 Pedro Alvarez 30 alvarpe01 2017 BAL AL 0.322116955 0.1 1B 1 1 BAL PIT 2016 2018  
3276 3276 Brock Holt 29 holtbr01 2017 BOS AL 1.506254949 -0.435 2B, LF, 3B, 1B, RF 1 1 BOS PIT 2013 2019  
3373 3373 Chris Volstad 30 volstch01 2017 CHW AL 0.497441876 0.03 P 1 1 CHW PIT 2017 2018  
3376 3376 Alen Hanson 24 hansoal01 2017 CHW AL 1.680741845 -0.35 RF, 2B, CF, LF, SS, 3B 1 2 CHW PIT 2017 2017 SFG
3628 3628 Joakim Soria 33 soriajo01 2017 KCR AL 2.04029238 1.375 P 7 1 KCR PIT 2016 2017 CHW
3698 3698 Deolis Guerra 28 guerrde01 2017 LAA AL 0.662477005 -0.06 P 1 1 ANA PIT 2016 2017 MIL
3743 3743 Tony Watson 32 watsoto01 2017 LAD NL 0.695066997 0.24 P 2 2 LAD PIT 2017 2017 SFG
3805 3805 Steve Lombardozzi 28 lombast02 2017 MIA NL 0.078246206 -0.2 2B 0 1 FLA PIT 2017 2017  
3808 3808 Jeff Locke 29 lockeje01 2017 MIA NL 0.917377276 -0.465 P 0 1 FLA PIT 2017 2017  
3824 3824 Keon Broxton 27 broxtke01 2017 MIL NL 4.614882282 0.585 CF 9 1 MIL PIT 2016 2018 NYM
3830 3830 Jared Hughes 31 hugheja02 2017 MIL NL 1.795446814 0.85 P 5 1 MIL PIT 2017 2017 CIN
3857 3857 Rob Scahill 30 scahiro01 2017 MIL NL 0.635978136 -0.26 P 0 1 MIL PIT 2016 2017 CHW
3861 3861 Neftali Feliz 29 felizne01 2017 MIL NL 0.959104741 -0.87 P 0 1 MIL PIT 2017 2017 KCR
3923 3923 Neil Walker 31 walkene01 2017 NYM NL 2.966980325 1.27 2B, 1B, 3B 8 1 NYM PIT 2016 2017 MIL
4003 4003 Erik Kratz 37 kratzer01 2017 NYY AL 0.01832833 0.105 C 0 1 NYY PIT 2017 2017 MIL
4020 4020 Matthew Joyce 32 joycema01 2017 OAK AL 5.169916435 2.25 RF, LF, CF 14 1 OAK PIT 2017 2018 ATL
4099 4099 Pedro Florimon 30 floripe01 2017 PHI NL 0.487729535 0.62 CF, RF, SS, 2B, 3B, LF 2 1 PHI PIT 2017 2018  
4107 4107 Juan Nicasio 30 nicasju01 2017 PHI NL 0.038153419 0.035 P 0 2 PHI PIT 2017 2017 STL
4116 4116 Jeanmar Gomez 29 gomezje01 2017 PHI NL 0.723602802 -0.565 P 0 1 PHI PIT 2015 2017 CHW
4301 4301 Gorkys Hernandez 29 hernago01 2017 SFG NL 3.468637223 -0.145 LF, CF, RF 4 1 SFG PIT 2016 2018 BOS
4320 4320 Mike Morse 35 morsemi01 2017 SFG NL 0.398693934 -0.375 1B, LF 0 1 SFG PIT 2017 2017  
4374 4374 Eric Fryer 31 fryerer01 2017 STL NL 0.817456274 -0.275 C 0 1 STL PIT 2017 2017  
4464 4464 Jhan Marinez 28 marinjh01 2017 TEX AL 0.124598901 0.085 P 0 3 TEX PIT 2017 2017 BAL
4473 4473 Phil Gosselin 28 gosseph01 2017 TEX AL 0.076140466 -0.135 2B, SS, 3B, 1B 0 2 TEX PIT 2017 2017 CIN
4487 4487 J.A. Happ 34 happja01 2017 TOR AL 3.888934576 3.105 P 15 1 TOR PIT 2016 2018 NYY
4490 4490 Russell Martin 34 martiru01 2017 TOR AL 3.453507341 1.835 C, 3B 10 1 TOR PIT 2015 2018 LAD
4494 4494 Jose Bautista 36 bautijo02 2017 TOR AL 6.490701468 -0.91 RF, 3B, 1B 7 1 TOR PIT 2008 2017 ATL
4503 4503 Francisco Liriano 33 liriafr01 2017 TOR AL 2.21205453 0.27 P 4 1 TOR PIT 2016 2017 HOU
4714 4714 Pedro Alvarez 29 alvarpe01 2016 BAL AL 3.598086124 1.06 3B 9 1 BAL PIT 2016 2018  
4719 4719 Vance Worley 28 worleva01 2016 BAL AL 2.225925166 0.81 P 6 1 BAL PIT 2016 2016 FLA
4761 4761 Brock Holt 28 holtbr01 2016 BOS AL 2.986175115 0.85 LF, 3B, 2B, SS, RF 6 1 BOS PIT 2013 2019  
4979 4979 Michael Martinez 33 martimi02 2016 CLE AL 0.936704731 -0.090559006 2B, CF, LF, RF, SS, 3B 1 1 CLE PIT 2015 2016 BOS
5141 5141 Edinson Volquez 32 volqued01 2016 KCR AL 5.304579749 0.32 P 9 1 KCR PIT 2015 2016 FLA
5146 5146 Joakim Soria 32 soriajo01 2016 KCR AL 2.507060173 0.295 P 5 1 KCR PIT 2016 2017 CHW
5190 5190 Deolis Guerra 27 guerrde01 2016 LAA AL 1.518345939 0.4 P 3 1 ANA PIT 2016 2017 MIL
5234 5234 Joe Blanton 35 blantjo01 2016 LAD NL 2.520106986 1.295 P 7 1 LAD PIT 2016 2016 WSN
5321 5321 Bryan Morris 29 morribr01 2016 MIA NL 0.585777929 -0.160993789 P 0 1 FLA PIT 2014 2016 SFG
5339 5339 Keon Broxton 26 broxtke01 2016 MIL NL 2.460361613 1.875 CF 9 1 MIL PIT 2016 2018 NYM
5356 5356 Rob Scahill 29 scahiro01 2016 MIL NL 0.392186402 0.33 P 2 2 MIL PIT 2016 2017 CHW
5435 5435 Neil Walker 30 walkene01 2016 NYM NL 4.586325967 3.1 2B 15 1 NYM PIT 2016 2017 MIL
5467 5467 Antonio Bastardo 30 bastaan01 2016 NYM NL 1.14278566 -0.135 P 1 1 NYM PIT 2016 2016 PIT
5474 5474 Jon Niese 29 niesejo01 2016 NYM NL 0.253528307 -0.425 P 0 2 NYM PIT 2016 2016  
5565 5565 Andrew Lambo 27 lamboan01 2016 OAK AL 0.00966989 -0.015   0 1 OAK PIT 2016 2016  
5594 5594 Jeanmar Gomez 28 gomezje01 2016 PHI NL 2.7587836 0.16 P 5 1 PHI PIT 2015 2017 CHW
5601 5601 Charlie Morton 32 mortoch02 2016 PHI NL 0.487735205 0.335 P 2 1 PHI PIT 2016 2016 HOU
5791 5791 Arquimedes Caminero 29 caminar01 2016 SEA AL 0.56047988 -0.23 P 0 2 SEA PIT 2016 2016  
5823 5823 Gorkys Hernandez 28 hernago01 2016 SFG NL 0.560433972 0.385 CF, RF, LF 2 1 SFG PIT 2016 2018 BOS
5831 5831 Javier Lopez 38 lopezja02 2016 SFG NL 0.998984827 -0.245 P 1 1 SFG PIT 2010 2016  
5927 5927 Jaff Decker 26 deckeja01 2016 TBR AL 0.549078226 -0.655 RF, LF, CF 0 1 TBD PIT 2016 2016 OAK
5985 5985 J.A. Happ 33 happja01 2016 TOR AL 5.335052624 3.835 P 19 1 TOR PIT 2016 2018 NYY
5989 5989 Russell Martin 33 martiru01 2016 TOR AL 5.00483871 2.69 C, 2B, 3B 15 1 TOR PIT 2015 2018 LAD
5994 5994 Jose Bautista 35 bautijo02 2016 TOR AL 4.836451613 1.295 RF, 1B 10 1 TOR PIT 2008 2017 ATL

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