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,772 rows where next_franch = "OAK"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, lg_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
305 305 Tanner Roark 32 roarkta01 2019 CIN NL 3.125062659 1.874716981 P 10 1 CIN WSN 2019 2019 OAK
557 557 Homer Bailey 33 baileho02 2019 KCR AL 2.606832458 1.090188679 P 6 1 KCR CIN 2019 2019 OAK
565 565 Jake Diekman 32 diekmja01 2019 KCR AL 1.561827726 0.509433962 P 3 1 KCR ARI 2019 2019 OAK
617 617 Dustin Garneau 31 garnedu01 2019 LAA AL 0.775983031 0.555283019 C, 1B 3 1 ANA CHW 2019 2019 OAK
1711 1711 Corban Joseph 29 josepco01 2018 BAL AL 0.183330561 -0.085 1B, 2B 0 1 BAL NYY 2018 2018 OAK
2020 2020 Mike Fiers 33 fiersmi01 2018 DET AL 3.342287015 2.07 P 11 1 DET HOU 2018 2018 OAK
2266 2266 Wilmer Font 28 fontwi01 2018 LAD NL 0.288835068 -0.606257669 P 0 1 LAD TEX 2017 2018 OAK
2348 2348 Joakim Soria 34 soriajo01 2018 MIL NL 0.799359384 0.168957055 P 2 2 MIL CHW 2018 2018 OAK
2378 2378 Robbie Grossman 28 grossro01 2018 MIN AL 4.398238748 1.125 RF, LF 10 1 MIN HOU 2016 2018 OAK
2387 2387 Fernando Rodney 41 rodnefe01 2018 MIN AL 1.763617976 0.655 P 5 1 MIN ARI 2018 2018 OAK
2438 2438 Jeurys Familia 28 familje01 2018 NYM NL 1.655110168 1.115 P 6 1 NYM   2012 2018 OAK
2672 2672 Tanner Anderson 25 anderta01 2018 PIT NL 0.29904094 -0.216335404 P 0 1 PIT   2018 2018 OAK
2749 2749 Chris Herrmann 30 herrmch01 2018 SEA AL 0.83198681 0.55 C, 1B 3 1 SEA ARI 2018 2018 OAK
2803 2803 Nick Hundley 34 hundlni01 2018 SFG NL 3.050525953 -0.255 C 4 1 SFG COL 2017 2018 OAK
2935 2935 Jurickson Profar 25 profaju01 2018 TEX AL 5.607421875 2.425 SS, 3B, 1B, 2B, LF 14 1 TEX   2012 2018 OAK
2954 2954 Cory Gearrin 32 gearrco01 2018 TEX AL 0.680619821 0.59 P 3 2 TEX SFG 2018 2018 OAK
2991 2991 Kendrys Morales 35 moralke01 2018 TOR AL 4.513879709 0.525 1B, 3B, P 8 1 TOR KCR 2017 2018 OAK
2992 2992 Marco Estrada 34 estrama01 2018 TOR AL 4.104091449 0.51 P 8 1 TOR MIL 2015 2018 OAK
3027 3027 Carlos Ramirez 27 ramirca01 2018 TOR AL 0.042286999 0.015 P 0 1 TOR   2017 2018 OAK
3069 3069 Shawn Kelley 34 kellesh01 2018 WSN NL 0.802621429 0.315 P 2 1 WSN SDP 2016 2018 OAK
3493 3493 Jonathan Lucroy 31 lucrojo01 2017 COL NL 1.730900409 0.765 C, 1B 5 2 COL TEX 2017 2017 OAK
3504 3504 Dustin Garneau 29 garnedu01 2017 COL NL 0.731923602 0.04 C 1 1 COL   2015 2017 OAK
3633 3633 Ryan Buchter 30 buchtry01 2017 KCR AL 0.677310175 0.34 P 2 2 KCR SDP 2017 2017 OAK
3660 3660 Trevor Cahill 29 cahiltr01 2017 KCR AL 0.559796263 -0.745 P 0 2 KCR SDP 2017 2017 OAK
3666 3666 Yusmeiro Petit 32 petityu01 2017 LAA AL 2.855350326 1.875 P 10 1 ANA WSN 2017 2017 OAK
3745 3745 Chris Hatcher 32 hatchch02 2017 LAD NL 0.83849352 -0.005 P 1 1 LAD FLA 2015 2017 OAK
3764 3764 Wilmer Font 27 fontwi01 2017 LAD NL 0.077781307 -0.265 P 0 1 LAD TEX 2017 2018 OAK
3767 3767 Trayce Thompson 26 thomptr01 2017 LAD NL 0.543997271 -0.41 CF, RF, LF 0 1 LAD CHW 2016 2017 OAK
3851 3851 Wei-Chung Wang 25 wangwe01 2017 MIL NL 0.032293089 -0.03 P 0 1 MIL   2014 2017 OAK
3874 3874 Robbie Grossman 27 grossro01 2017 MIN AL 4.240500241 0.67 RF, LF 8 1 MIN HOU 2016 2018 OAK
3942 3942 Jeurys Familia 27 familje01 2017 NYM NL 0.899731172 0.12 P 2 1 NYM   2012 2018 OAK
4004 4004 Dustin Fowler 22 fowledu01 2017 NYY AL 0.0 0.0 RF 0 1 NYY   2017 2017 OAK
4237 4237 Emilio Pagan 26 paganem01 2017 SEA AL 1.534235314 0.73 P 4 1 SEA   2017 2017 OAK
4270 4270 Boog Powell 24 powelbo02 2017 SEA AL 0.40625509 -0.085 CF, LF, RF 0 1 SEA   2017 2017 OAK
4299 4299 Nick Hundley 33 hundlni01 2017 SFG NL 3.020106548 0.17 C 4 1 SFG COL 2017 2018 OAK
4345 4345 Stephen Piscotty 26 piscost01 2017 STL NL 3.949397181 0.52 RF 7 1 STL   2015 2017 OAK
4363 4363 Josh Lucas 26 lucasjo02 2017 STL NL 0.16036553 -0.025 P 0 1 STL   2017 2017 OAK
4460 4460 Jurickson Profar 24 profaju01 2017 TEX AL 0.666229078 -0.055 LF, SS, 3B, 1B, 2B 1 1 TEX   2012 2018 OAK
4488 4488 Marco Estrada 33 estrama01 2017 TOR AL 4.977122692 2.245 P 14 1 TOR MIL 2015 2018 OAK
4493 4493 Kendrys Morales 34 moralke01 2017 TOR AL 5.75269168 -0.235 1B 8 1 TOR KCR 2017 2018 OAK
4506 4506 Brett Anderson 29 anderbr04 2017 TOR AL 0.891957472 0.46 P 3 2 TOR CHC 2017 2017 OAK
4510 4510 Carlos Ramirez 26 ramirca01 2017 TOR AL 0.538495601 0.32 P 2 1 TOR   2017 2018 OAK
4570 4570 Blake Treinen 29 treinbl01 2017 WSN NL 1.196057227 0.09 P 2 1 WSN   2014 2017 OAK
4572 4572 Edwin Jackson 33 jacksed01 2017 WSN NL 1.98990052 -0.185 P 2 2 WSN BAL 2017 2017 OAK
4591 4591 Shawn Kelley 33 kellesh01 2017 WSN NL 0.833349109 -0.875 P 0 1 WSN SDP 2016 2018 OAK
4786 4786 Ryan LaMarre 27 lamarry01 2016 BOS AL 0.055299539 -0.09 LF, P, RF 0 1 BOS CIN 2016 2016 OAK
4913 4913 Josh Smith 28 smithjo07 2016 CIN NL 1.647015207 0.03 P 3 1 CIN   2015 2016 OAK
4958 4958 Rajai Davis 35 davisra01 2016 CLE AL 4.683523654 1.157142857 CF, LF, RF 10 1 CLE DET 2016 2016 OAK
4984 4984 Ross Detwiler 30 detwiro01 2016 CLE AL 0.130932802 -0.055341615 P 0 1 CLE ATL 2016 2016 OAK
5021 5021 Dustin Garneau 28 garnedu01 2016 COL NL 0.737413121 -0.05 C 1 1 COL   2015 2017 OAK
5150 5150 Brett Eibner 27 eibnebr01 2016 KCR AL 0.81744321 0.47 CF, RF, LF 3 1 KCR   2016 2016 OAK
5239 5239 Trayce Thompson 25 thomptr01 2016 LAD NL 2.599384194 0.795 CF, RF, LF 6 1 LAD CHW 2016 2017 OAK
5274 5274 Chris Hatcher 31 hatchch02 2016 LAD NL 1.244798128 -0.49 P 0 1 LAD FLA 2015 2017 OAK
5392 5392 Robbie Grossman 26 grossro01 2016 MIN AL 3.629081551 0.5 LF, CF 6 1 MIN HOU 2016 2018 OAK
5398 5398 Trevor Plouffe 30 plouftr01 2016 MIN AL 3.209264919 0.1 3B, 1B 4 1 MIN   2010 2016 OAK
5439 5439 Jeurys Familia 26 familje01 2016 NYM NL 3.06043115 1.945 P 10 1 NYM   2012 2018 OAK
5640 5640 Matthew Joyce 31 joycema01 2016 PIT NL 2.860942761 1.785 RF, LF 9 1 PIT ANA 2016 2016 OAK
5690 5690 Adam Rosales 33 rosalad01 2016 SDP NL 2.527499561 1.745 3B, 2B, SS, LF, 1B, RF 9 1 SDP TEX 2016 2016 OAK
5811 5811 Santiago Casilla 35 garcija01 2016 SFG NL 2.627178157 0.42 P 5 1 SFG OAK 2010 2016 OAK
5845 5845 Stephen Piscotty 25 piscost01 2016 STL NL 6.383245718 2.44 RF, CF, 1B 16 1 STL   2015 2017 OAK
5873 5873 Dean Kiekhefer 27 kiekhde01 2016 STL NL 0.452557303 0.005 P 1 1 STL   2016 2016 OAK
5927 5927 Jaff Decker 26 deckeja01 2016 TBR AL 0.549078226 -0.655 RF, LF, CF 0 1 TBD PIT 2016 2016 OAK
5949 5949 Jurickson Profar 23 profaju01 2016 TEX AL 2.934893687 0.12 3B, 2B, 1B, LF, SS 6 1 TEX   2012 2018 OAK
5987 5987 Marco Estrada 32 estrama01 2016 TOR AL 4.84097686 3.08 P 16 1 TOR MIL 2015 2018 OAK
6043 6043 Shawn Kelley 32 kellesh01 2016 WSN NL 1.973621895 1.285 P 7 1 WSN SDP 2016 2018 OAK
6044 6044 Blake Treinen 28 treinbl01 2016 WSN NL 2.279873569 1.25 P 7 1 WSN   2014 2017 OAK
6152 6152 Ryan Lavarnway 27 lavarry01 2015 ATL NL 0.752718344 0.105 C, 1B 1 2 ATL BAL 2015 2015 OAK
6159 6159 Cody Martin 25 martico01 2015 ATL NL 0.789147671 -0.17 P 1 1 ATL   2015 2015 OAK
6247 6247 Rich Hill 35 hillri01 2015 BOS AL 0.810089095 1.42 P 5 1 BOS NYY 2015 2015 OAK
6274 6274 Edward Mujica 31 mujiced01 2015 BOS AL 0.422596727 -0.11 P 0 1 BOS STL 2014 2015 OAK
6289 6289 Chris Coghlan 30 coghlch01 2015 CHC NL 5.010132234 2.51 LF, RF, 2B, 1B, 3B 15 1 CHC FLA 2014 2015 OAK
6327 6327 Arismendy Alcantara 23 alcanar01 2015 CHC NL 0.318736047 -0.21 2B, 3B 0 1 CHC   2014 2015 OAK
6331 6331 Brian Schlitter 29 schlibr01 2015 CHC NL 0.293781201 -0.325 P 0 1 CHC   2010 2015 OAK
6359 6359 Frankie Montas 22 montafr02 2015 CHW AL 0.30068243 0.105 P 1 1 CHW   2015 2015 OAK
6414 6414 Josh Smith 27 smithjo07 2015 CIN NL 0.839391471 -0.375 P 0 1 CIN   2015 2016 OAK
6482 6482 John Axford 32 axforjo01 2015 COL NL 2.21031893 0.765 P 5 1 COL PIT 2015 2015 OAK
6513 6513 Simon Castro 27 castrsi01 2015 COL NL 0.238035901 0.035 P 0 1 COL CHW 2015 2015 OAK
6518 6518 Matt McBride 30 mcbrima02 2015 COL NL 0.43373913 -0.54 1B, LF, RF 0 1 COL   2012 2015 OAK
6519 6519 Dustin Garneau 27 garnedu01 2015 COL NL 0.766608696 -0.57 C 0 1 COL   2015 2017 OAK
6585 6585 Jed Lowrie 31 lowrije01 2015 HOU AL 2.522990407 1.1 3B, SS 6 1 HOU OAK 2015 2015 OAK
6630 6630 Ryan Madson 34 madsory01 2015 KCR AL 2.178487877 1.315 P 8 1 KCR PHI 2015 2015 OAK
6649 6649 Aaron Brooks 25 brookaa01 2015 KCR AL 0.064806276 0.04 P 0 1 KCR   2014 2015 OAK
6743 6743 Chris Hatcher 30 hatchch02 2015 LAD NL 1.315944818 0.125 P 2 1 LAD FLA 2015 2017 OAK
6755 6755 Danny Coulombe 25 couloda01 2015 LAD NL 0.161894273 -0.105 P 0 1 LAD   2014 2015 OAK
6762 6762 Eric Surkamp 27 surkaer01 2015 LAD NL 0.099327614 -0.25 P 0 1 LAD CHW 2015 2015 OAK
6826 6826 Khris Davis 27 daviskh01 2015 MIL NL 4.468569427 1.05 LF 9 1 MIL   2013 2015 OAK
6868 6868 Trevor Plouffe 29 plouftr01 2015 MIN AL 6.112389528 2.69 3B, 1B 18 1 MIN   2010 2016 OAK
6920 6920 Jeurys Familia 25 familje01 2015 NYM NL 2.970071239 2.21 P 11 1 NYM   2012 2018 OAK
7162 7162 Andrew Lambo 26 lamboan01 2015 PIT NL 0.263414634 -0.43 RF, LF 0 1 PIT   2013 2015 OAK
7171 7171 Yonder Alonso 28 alonsyo01 2015 SDP NL 4.089091547 1.365 1B, 3B 10 1 SDP CIN 2012 2015 OAK
7207 7207 Marc Rzepczynski 29 rzepcma01 2015 SDP NL 0.509521895 -0.39 P 0 2 SDP CLE 2015 2015 OAK
7277 7277 Santiago Casilla 34 garcija01 2015 SFG NL 2.274989889 0.65 P 5 1 SFG OAK 2010 2016 OAK
7323 7323 Stephen Piscotty 24 piscost01 2015 STL NL 2.566194262 1.16 LF, RF, 1B, CF 7 1 STL   2015 2017 OAK
7458 7458 Jake Smolinski 26 smolija01 2015 TEX AL 0.696188159 -0.425 LF, RF 0 1 TEX   2014 2015 OAK
7468 7468 Marco Estrada 31 estrama01 2015 TOR AL 5.030056545 2.94 P 15 1 TOR MIL 2015 2018 OAK
7478 7478 Liam Hendriks 26 hendrli01 2015 TOR AL 1.806984675 1.305 P 6 1 TOR KCR 2015 2015 OAK
7485 7485 Danny Valencia 30 valenda01 2015 TOR AL 1.616561946 0.67 3B, LF, 1B, RF, 2B 4 1 TOR KCR 2014 2015 OAK
7495 7495 Felix Doubront 27 doubrfe01 2015 TOR AL 0.595304286 0.085 P 1 1 TOR CHC 2015 2015 OAK
7535 7535 Blake Treinen 27 treinbl01 2015 WSN NL 2.140293375 0.255 P 4 1 WSN   2014 2017 OAK
7593 7593 Cody Ross 33 rossco01 2014 ARI NL 2.205208333 -0.795 LF, RF 1 1 ARI BOS 2013 2014 OAK

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