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,340 rows where next_franch = "PIT"

✎ 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
134 134 Yefry Ramirez 25 ramirye01 2019 BAL AL 0.326975416 -0.13754717 P 0 1 BAL   2018 2019 PIT
647 647 Chris Stratton 28 stratch01 2019 LAA AL 0.773937979 -0.40245283 P 0 1 ANA SFG 2019 2019 PIT
990 990 Wei-Chung Wang 27 wangwe01 2019 OAK AL 0.641782893 0.168113208 P 1 1 OAK MIL 2019 2019 PIT
1058 1058 Yacksel Rios 26 riosya01 2019 PHI NL 0.045915137 -0.239433962 P 0 1 PHI   2017 2019 PIT
1229 1229 Parker Markel 28 markepa01 2019 SEA AL 0.083462326 -0.244528302 P 0 1 SEA   2019 2019 PIT
1277 1277 Williams Jerez 27 jerezwi01 2019 SFG NL 0.168026612 0.030566038 P 0 1 SFG ANA 2019 2019 PIT
1293 1293 Corban Joseph 30 josepco01 2019 SFG NL 0.170913503 -0.249622642 2B, 3B 0 2 SFG OAK 2019 2019 PIT
1692 1692 Yefry Ramirez 24 ramirye01 2018 BAL AL 1.847928674 0.17 P 3 1 BAL   2018 2019 PIT
1941 1941 Melky Cabrera 33 cabreme01 2018 CLE AL 2.56997131 0.185 RF, LF 4 1 CLE KCR 2018 2018 PIT
1943 1943 Erik Gonzalez 26 gonzaer01 2018 CLE AL 1.32196366 0.39 2B, 3B, SS, 1B 3 1 CLE   2016 2018 PIT
2027 2027 Francisco Liriano 34 liriafr01 2018 DET AL 3.734145498 0.18 P 6 1 DET HOU 2018 2018 PIT
2315 2315 JB Shuck 31 shuckja01 2018 MIA NL 1.42 -0.769751553 RF, LF, CF 0 1 FLA CHW 2018 2018 PIT
2354 2354 Jordan Lyles 27 lylesjo01 2018 MIL NL 0.411405174 0.188834356 P 1 2 MIL SDP 2018 2018 PIT
2619 2619 Yacksel Rios 25 riosya01 2018 PHI NL 0.953387636 -0.28 P 1 1 PHI   2017 2019 PIT
2866 2866 Steven Baron 27 baronst01 2018 STL NL 0.049378512 -0.02 C 0 1 STL SEA 2018 2018 PIT
2874 2874 Tyler Lyons 30 lyonsty01 2018 STL NL 0.578537278 -0.61 P 0 1 STL   2013 2018 PIT
2891 2891 Chris Archer 29 archech01 2018 TBR AL 2.558746983 1.155 P 7 1 TBD   2012 2018 PIT
2896 2896 Adeiny Hechavarria 29 hechaad01 2018 TBR AL 2.226794103 0.73 SS, 3B 5 1 TBD FLA 2017 2018 PIT
2947 2947 Keone Kela 25 kelake01 2018 TEX AL 1.451020922 1.085 P 5 1 TEX   2015 2018 PIT
3086 3086 Enny Romero 27 romeren01 2018 WSN NL 0.03259933 -0.095 P 0 1 WSN TBD 2017 2018 PIT
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
3237 3237 Richard Rodriguez 27 rodriri05 2017 BAL AL 0.11404972 -0.31 P 0 1 BAL   2017 2017 PIT
3332 3332 Jack Leathersich 26 leathja01 2017 CHC NL 0.015771686 -0.105 P 0 1 CHC NYM 2017 2017 PIT
3430 3430 Rookie Davis 24 davisro03 2017 CIN NL 0.680820062 -0.49 P 0 1 CIN   2017 2017 PIT
3464 3464 Erik Gonzalez 25 gonzaer01 2017 CLE AL 1.073555448 0.265 2B, SS, 3B, LF 2 1 CLE   2016 2018 PIT
3585 3585 Joe Musgrove 24 musgrjo01 2017 HOU AL 3.343289578 0.5 P 6 1 HOU   2016 2017 PIT
3593 3593 Michael Feliz 24 felizmi01 2017 HOU AL 1.265332473 -0.02 P 2 1 HOU   2015 2017 PIT
3594 3594 Colin Moran 24 moranco01 2017 HOU AL 0.111502723 0.165 1B, 3B, SS 1 1 HOU   2016 2017 PIT
3853 3853 Jhan Marinez 28 marinjh01 2017 MIL NL 0.435467411 -0.185 P 0 1 MIL TBD 2016 2017 PIT
3948 3948 Josh Smoker 28 smokejo01 2017 NYM NL 1.628486178 -0.24 P 1 1 NYM   2016 2017 PIT
4056 4056 Ryan Lavarnway 29 lavarry01 2017 OAK AL 0.123545797 0.04 C 0 1 OAK ATL 2017 2017 PIT
4094 4094 Joaquin Benoit 39 benoijo01 2017 PHI NL 1.405317591 0.6 P 3 1 PHI TOR 2017 2017 PIT
4103 4103 Yacksel Rios 24 riosya01 2017 PHI NL 0.363517295 0.02 P 1 1 PHI   2017 2019 PIT
4302 4302 George Kontos 32 kontoge01 2017 SFG NL 1.755866967 0.355 P 3 1 SFG NYY 2012 2017 PIT
4304 4304 Kyle Crick 24 crickky01 2017 SFG NL 0.761471906 0.275 P 2 1 SFG   2017 2017 PIT
4348 4348 Tyler Lyons 29 lyonsty01 2017 STL NL 1.694995218 1.1 P 5 1 STL   2013 2018 PIT
4383 4383 Chris Archer 28 archech01 2017 TBR AL 5.486860856 3.075 P 16 1 TBD   2012 2018 PIT
4384 4384 Corey Dickerson 28 dickeco01 2017 TBR AL 5.959163672 2.565 LF 15 1 TBD COL 2016 2017 PIT
4389 4389 Adeiny Hechavarria 28 hechaad01 2017 TBR AL 2.662201895 1.325 SS 7 2 TBD FLA 2017 2018 PIT
4446 4446 Keone Kela 24 kelake01 2017 TEX AL 1.239038458 1.02 P 5 1 TEX   2015 2018 PIT
4561 4561 Enny Romero 26 romeren01 2017 WSN NL 1.668039925 0.535 P 4 1 WSN TBD 2017 2018 PIT
4610 4610 Phil Gosselin 27 gosseph01 2016 ARI NL 2.348970638 0.375 2B, 3B, 1B, LF, RF 4 1 ARI ATL 2015 2016 PIT
4614 4614 Daniel Hudson 29 hudsoda01 2016 ARI NL 2.067169998 0.06 P 3 1 ARI CHW 2010 2016 PIT
4982 4982 Erik Gonzalez 24 gonzaer01 2016 CLE AL 0.160848287 -0.010062112 SS, 2B, 3B, RF 0 1 CLE   2016 2018 PIT
5104 5104 Joe Musgrove 23 musgrjo01 2016 HOU AL 1.715745683 0.64 P 4 1 HOU   2016 2017 PIT
5107 5107 Michael Feliz 23 felizmi01 2016 HOU AL 1.884876756 0.29 P 3 1 HOU   2015 2017 PIT
5121 5121 Colin Moran 23 moranco01 2016 HOU AL 0.234589872 -0.3 3B 0 1 HOU   2016 2017 PIT
5123 5123 Erik Kratz 36 kratzer01 2016 HOU AL 0.281507847 -0.365 C, 1B, P 0 1 HOU PHI 2016 2016 PIT
5350 5350 Jhan Marinez 27 marinjh01 2016 MIL NL 1.484784574 0.61 P 4 2 MIL TBD 2016 2017 PIT
5377 5377 Jake Elmore 29 elmorja01 2016 MIL NL 0.998261474 -0.545 LF, 3B, RF, 2B, CF 0 1 MIL TBD 2016 2016 PIT
5467 5467 Antonio Bastardo 30 bastaan01 2016 NYM NL 1.14278566 -0.135 P 1 1 NYM PIT 2016 2016 PIT
5471 5471 Josh Smoker 27 smokejo01 2016 NYM NL 0.522124573 -0.135 P 0 1 NYM   2016 2017 PIT
5491 5491 Ivan Nova 29 novaiv01 2016 NYY AL 2.7513497 0.455 P 5 1 NYY   2010 2016 PIT
5522 5522 Johnny Barbato 23 barbajo01 2016 NYY AL 0.359529388 -0.15 P 0 1 NYY   2016 2016 PIT
5523 5523 Phil Coke 33 cokeph01 2016 NYY AL 0.154935316 -0.165 P 0 1 NYY TOR 2016 2016 PIT
5772 5772 Wade LeBlanc 31 leblawa01 2016 SEA AL 1.219286127 0.0 P 2 1 SEA NYY 2016 2016 PIT
5816 5816 George Kontos 31 kontoge01 2016 SFG NL 1.5269654 0.46 P 3 1 SFG NYY 2012 2017 PIT
5866 5866 Eric Fryer 30 fryerer01 2016 STL NL 0.403255893 0.535 C 2 1 STL MIN 2016 2016 PIT
5867 5867 Tyler Lyons 28 lyonsty01 2016 STL NL 1.248767746 0.235 P 2 1 STL   2013 2018 PIT
5886 5886 Chris Archer 27 archech01 2016 TBR AL 5.663541092 2.4 P 13 1 TBD   2012 2018 PIT
5888 5888 Corey Dickerson 27 dickeco01 2016 TBR AL 5.278857333 1.31 LF, RF 10 1 TBD COL 2016 2017 PIT
5963 5963 Keone Kela 23 kelake01 2016 TEX AL 1.090281223 -0.215 P 1 1 TEX   2015 2018 PIT
6014 6014 Drew Hutchison 25 hutchdr01 2016 TOR AL 0.400293541 -0.03 P 0 1 TOR   2012 2016 PIT
6050 6050 Felipe Vazquez 24 riverfe01 2016 WSN NL 1.617520959 0.37 P 3 1 WSN   2015 2016 PIT
6092 6092 Daniel Hudson 28 hudsoda01 2015 ARI NL 2.289035764 0.325 P 4 1 ARI CHW 2010 2016 PIT
6095 6095 Phil Gosselin 26 gosseph01 2015 ARI NL 0.741214058 0.585 2B, 3B, LF 3 2 ARI ATL 2015 2016 PIT
6121 6121 A.J. Schugel 26 schugaj01 2015 ARI NL 0.163333172 -0.33 P 0 1 ARI   2015 2015 PIT
6200 6200 Travis Snider 27 snidetr01 2015 BAL AL 2.287050961 0.49 LF, RF 5 1 BAL PIT 2015 2015 PIT
6227 6227 Jorge Rondon 27 rondojo01 2015 BAL AL 0.250257354 -0.305 P 0 2 BAL COL 2015 2015 PIT
6539 6539 Joakim Soria 31 soriajo01 2015 DET AL 1.763758854 0.357204969 P 4 1 DET TEX 2014 2015 PIT
6545 6545 Kyle Lobstein 25 lobstky01 2015 DET AL 1.716600066 -0.065403727 P 2 1 DET   2014 2015 PIT
6565 6565 Neftali Feliz 27 felizne01 2015 DET AL 0.931310319 -0.437701863 P 0 2 DET TEX 2015 2015 PIT
6610 6610 Michael Feliz 22 felizmi01 2015 HOU AL 0.123800882 -0.11 P 0 1 HOU   2015 2017 PIT
6640 6640 Joe Blanton 34 blantjo01 2015 KCR AL 0.990788251 0.4 P 3 1 KCR ANA 2015 2015 PIT
6666 6666 David Freese 32 freesda01 2015 LAA AL 4.56769437 2.29 3B 14 1 ANA STL 2014 2015 PIT
6694 6694 Matthew Joyce 30 joycema01 2015 LAA AL 2.760053619 -1.095 LF, RF 1 1 ANA TBD 2015 2015 PIT
6733 6733 Juan Nicasio 28 nicasju01 2015 LAD NL 1.806399258 0.56 P 4 1 LAD COL 2015 2015 PIT
6816 6816 Mike Morse 33 morsemi01 2015 MIA NL 1.77989418 -0.64 1B, LF 0 1 FLA SFG 2015 2015 PIT
6833 6833 Aramis Ramirez 37 ramirar01 2015 MIL NL 3.067063562 0.43 3B, 1B 6 1 MIL CHC 2012 2015 PIT
6836 6836 Jason Rogers 27 rogerja02 2015 MIL NL 1.716336894 0.595 1B, 3B, LF 4 1 MIL   2014 2015 PIT
6922 6922 Jon Niese 28 niesejo01 2015 NYM NL 4.890072913 0.98 P 10 1 NYM   2008 2015 PIT
6980 6980 Ivan Nova 28 novaiv01 2015 NYY AL 2.630212326 0.615 P 5 1 NYY   2010 2016 PIT
6995 6995 Cole Figueroa 28 figueco01 2015 NYY AL 0.074335149 0.015 3B 0 1 NYY TBD 2015 2015 PIT
7222 7222 J.A. Happ 32 happja01 2015 SEA AL 2.894625753 0.885 P 7 1 SEA TOR 2015 2015 PIT
7276 7276 George Kontos 30 kontoge01 2015 SFG NL 2.244482361 0.735 P 5 1 SFG NYY 2012 2017 PIT
7278 7278 Ryan Vogelsong 37 vogelry01 2015 SFG NL 3.831022354 -0.16 P 5 1 SFG PIT 2011 2015 PIT
7298 7298 Travis Ishikawa 31 ishiktr01 2015 SFG NL 0.060010347 -0.09 1B, LF 0 1 SFG PIT 2014 2015 PIT
7333 7333 Tyler Lyons 27 lyonsty01 2015 STL NL 1.413596249 0.315 P 3 1 STL   2013 2018 PIT
7357 7357 Chris Archer 26 archech01 2015 TBR AL 5.662202403 4.53 P 21 1 TBD   2012 2018 PIT
7371 7371 John Jaso 31 jasojo01 2015 TBR AL 2.070401587 0.845 LF, RF 5 1 TBD OAK 2015 2015 PIT
7416 7416 Keone Kela 22 kelake01 2015 TEX AL 2.176290916 1.625 P 8 1 TEX   2015 2018 PIT
7483 7483 Drew Hutchison 24 hutchdr01 2015 TOR AL 4.223728699 -0.025 P 5 1 TOR   2012 2016 PIT
7530 7530 Felipe Vazquez 23 riverfe01 2015 WSN NL 1.485513596 1.005 P 5 1 WSN   2015 2016 PIT
7598 7598 Daniel Hudson 27 hudsoda01 2014 ARI NL 0.074176476 -0.085 P 0 1 ARI CHW 2010 2016 PIT
7692 7692 Steve Lombardozzi 25 lombast02 2014 BAL AL 0.702685003 -0.235 2B 0 1 BAL WSN 2014 2014 PIT
7865 7865 Curtis Partch 27 partccu01 2014 CIN NL 0.135508369 0.125 P 1 1 CIN   2013 2014 PIT
7914 7914 John Axford 31 axforjo01 2014 CLE AL 1.455653913 -0.13 P 2 1 CLE STL 2014 2014 PIT
7968 7968 Rob Scahill 27 scahiro01 2014 COL NL 0.488137184 -0.2 P 0 1 COL   2012 2014 PIT
8001 8001 Kyle Lobstein 24 lobstky01 2014 DET AL 1.047108452 0.48 P 3 1 DET   2014 2015 PIT
8020 8020 Joakim Soria 30 soriajo01 2014 DET AL 0.387674157 -0.125 P 0 2 DET TEX 2014 2015 PIT

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