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,392 rows where prev_franch = "OAK"

✎ 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
58 58 Matthew Joyce 34 joycema01 2019 ATL NL 2.26128591 1.166603774 RF, LF 7 1 ATL OAK 2019 2019  
111 111 Aaron Brooks 29 brookaa01 2019 BAL AL 1.720608757 0.27 P 3 2 BAL OAK 2019 2019  
127 127 Josh Lucas 28 lucasjo02 2019 BAL AL 0.317466994 0.040754717 P 0 1 BAL OAK 2019 2019  
192 192 Josh Smith 31 smithjo07 2019 BOS AL 0.687846373 -0.229245283 P 0 1 BOS OAK 2019 2019  
207 207 Jon Lester 35 lestejo01 2019 CHC NL 4.837525654 2.470754717 P 13 1 CHC OAK 2015 2019  
381 381 Dan Otero 34 oteroda01 2019 CLE AL 0.610079752 -0.050943396 P 1 1 CLE OAK 2016 2019  
588 588 Jesse Hahn 29 hahnje01 2019 KCR AL 0.129386456 -0.234339623 P 0 1 KCR OAK 2019 2019  
625 625 Jonathan Lucroy 33 lucrojo01 2019 LAA AL 2.536139664 -0.433018868 C, 1B 2 1 ANA OAK 2019 2019 CHC
628 628 Trevor Cahill 31 cahiltr01 2019 LAA AL 2.783693499 -0.631698113 P 2 1 ANA OAK 2019 2019  
657 657 Max Muncy 28 muncyma01 2019 LAD NL 5.7470274 5.073962264 2B, 1B, 3B 23 1 LAD OAK 2018 2019  
676 676 Rich Hill 39 hillri01 2019 LAD NL 1.575078176 1.069811321 P 5 1 LAD OAK 2016 2019  
880 880 Jeurys Familia 29 familje01 2019 NYM NL 1.672945267 -0.427924528 P 1 1 NYM OAK 2019 2019  
892 892 Jed Lowrie 35 lowrije01 2019 NYM NL 0.069520548 -0.117169811   0 1 NYM OAK 2019 2019  
953 953 Ryan Dull 29 dullry01 2019 NYY AL 0.072749878 -0.168113208 P 0 2 NYY OAK 2019 2019  
956 956 Kendrys Morales 36 moralke01 2019 NYY AL 0.712297364 -0.40245283 1B, P 0 2 NYY OAK 2019 2019  
1096 1096 Wei-Chung Wang 27 wangwe01 2019 PIT NL 0.08073775 -0.015283019 P 0 2 PIT OAK 2019 2019  
1149 1149 Nick Martini 29 martini02 2019 SDP NL 0.947443182 0.00509434 LF, P 1 2 SDP OAK 2019 2019  
1194 1194 Cory Gearrin 33 gearrco01 2019 SEA AL 1.210820441 0.509433962 P 3 1 SEA OAK 2019 2019 NYY
1202 1202 Ryon Healy 27 healyry01 2019 SEA AL 1.787998681 -0.050943396 3B, 1B 2 1 SEA OAK 2018 2019  
1293 1293 Corban Joseph 30 josepco01 2019 SFG NL 0.170913503 -0.249622642 2B, 3B 0 2 SFG OAK 2019 2019 PIT
1359 1359 Emilio Pagan 28 paganem01 2019 TBR AL 2.614576 1.946037736 P 9 1 TBD OAK 2019 2019  
1361 1361 Joey Wendle 29 wendljo01 2019 TBR AL 2.405269149 0.794716981 2B, 3B, SS 6 1 TBD OAK 2018 2019  
1387 1387 Wilmer Font 29 fontwi01 2019 TBR AL 0.335577442 0.025471698 P 1 1 TBD OAK 2018 2019 NYM
1423 1423 Shawn Kelley 35 kellesh01 2019 TEX AL 1.914968801 0.560377358 P 4 1 TEX OAK 2019 2019  
1497 1497 Beau Taylor 29 taylobe11 2019 TOR AL 0.019443513 -0.020377358 C 0 2 TOR OAK 2019 2019  
1514 1514 Edwin Jackson 35 jacksed01 2019 TOR AL 0.799676446 -1.207358491 P 0 1 TOR OAK 2019 2019 DET
1528 1528 Sean Doolittle 32 doolise01 2019 WSN NL 2.28164519 0.962830189 P 6 1 WSN OAK 2017 2019  
1535 1535 Fernando Rodney 42 rodnefe01 2019 WSN NL 1.130833625 0.387169811 P 3 2 WSN OAK 2019 2019  
1776 1776 Jon Lester 34 lestejo01 2018 CHC NL 4.897584406 2.60392638 P 15 1 CHC OAK 2015 2019  
1855 1855 Dustin Garneau 30 garnedu01 2018 CHW AL 0.028760331 0.035 C 0 1 CHW OAK 2018 2018 ANA
1872 1872 Trayce Thompson 27 thomptr01 2018 CHW AL 1.246280992 -1.12 RF, LF, CF 0 2 CHW OAK 2018 2018  
1958 1958 Dan Otero 33 oteroda01 2018 CLE AL 1.62167162 -0.32 P 1 1 CLE OAK 2016 2019  
1984 1984 Carlos Gonzalez 32 gonzaca01 2018 COL NL 5.002909464 1.073374233 RF 11 1 COL OAK 2009 2018 CLE
2215 2215 Max Muncy 27 muncyma01 2018 LAD NL 4.630373444 4.691042945 1B, 3B, 2B, LF 19 1 LAD OAK 2018 2019  
2230 2230 Rich Hill 38 hillri01 2018 LAD NL 3.593580833 1.381472393 P 8 1 LAD OAK 2016 2019  
2260 2260 Zach Neal 29 nealza01 2018 LAD NL 0.015128541 -0.064601227 P 0 1 LAD OAK 2018 2018  
2369 2369 Eric Sogard 32 sogarer01 2018 MIL NL 1.108030431 -0.829877301 SS, 2B, LF 0 1 MIL OAK 2017 2018 TOR
2409 2409 Ryan LaMarre 29 lamarry01 2018 MIN AL 1.030984997 -0.06 CF, LF, RF, P 1 1 MIN OAK 2018 2018 CHW
2467 2467 Bobby Wahl 26 wahlbo01 2018 NYM NL 0.149672033 -0.26 P 0 1 NYM OAK 2018 2018  
2495 2495 Sonny Gray 28 grayso01 2018 NYY AL 3.585931795 1.045 P 8 1 NYY OAK 2017 2018 CIN
2660 2660 Ryan Lavarnway 30 lavarry01 2018 PIT NL 0.060511215 0.19621118   1 1 PIT OAK 2018 2018 CIN
2742 2742 Ryon Healy 26 healyry01 2018 SEA AL 5.011046991 -0.76 1B, 3B 6 1 SEA OAK 2018 2019  
2771 2771 Ross Detwiler 32 detwiro01 2018 SEA AL 0.177306252 0.0 P 0 1 SEA OAK 2018 2018 CHW
2879 2879 Joey Wendle 28 wendljo01 2018 TBR AL 5.120686862 4.045 2B, 3B, LF, SS, RF 19 1 TBD OAK 2018 2019  
2904 2904 Wilmer Font 28 fontwi01 2018 TBR AL 0.65074516 0.8 P 3 3 TBD OAK 2018 2019 NYM
2961 2961 Renato Nunez 24 nunezre01 2018 TEX AL 0.387044271 0.16 3B, LF 1 1 TEX OAK 2018 2018 BAL
3003 3003 Josh Donaldson 32 donaljo02 2018 TOR AL 1.523793787 0.67 3B, 1B 4 1 TOR OAK 2015 2018 CLE
3008 3008 John Axford 35 axforjo01 2018 TOR AL 1.402075101 0.265 P 3 1 TOR OAK 2018 2018 LAD
3052 3052 Sean Doolittle 31 doolise01 2018 WSN NL 1.85726459 2.19 P 9 1 WSN OAK 2017 2019  
3054 3054 Gio Gonzalez 32 gonzagi01 2018 WSN NL 4.073371042 1.27 P 9 1 WSN OAK 2012 2018 MIL
3080 3080 Ryan Madson 37 madsory01 2018 WSN NL 1.637493265 -0.22 P 1 1 WSN OAK 2017 2018 LAD
3142 3142 Adam Rosales 34 rosalad01 2017 ARI NL 0.878787879 -0.375 SS, 3B, 2B, 1B, LF 0 2 ARI OAK 2017 2017 CLE
3285 3285 Rajai Davis 36 davisra01 2017 BOS AL 0.349010293 -0.125 CF, LF, RF 0 2 BOS OAK 2017 2017 CLE
3297 3297 Jon Lester 33 lestejo01 2017 CHC NL 5.090839076 2.08 P 14 1 CHC OAK 2015 2019  
3432 3432 Arismendy Alcantara 25 alcanar01 2017 CIN NL 1.06440102 -0.67 2B, CF, RF, SS, 3B, LF 0 1 CIN OAK 2017 2017  
3458 3458 Dan Otero 32 oteroda01 2017 CLE AL 1.457019948 0.64 P 4 1 CLE OAK 2016 2019  
3490 3490 Carlos Gonzalez 31 gonzaca01 2017 COL NL 5.281718963 -0.15 RF 8 1 COL OAK 2009 2018 CLE
3560 3560 Edward Mujica 33 mujiced01 2017 DET AL 0.192541086 -0.29 P 0 1 DET OAK 2017 2017  
3592 3592 Luke Gregerson 33 gregelu01 2017 HOU AL 1.727480095 0.01 P 2 1 HOU OAK 2015 2017 STL
3650 3650 Billy Burns 27 burnsbi02 2017 KCR AL 0.058 -0.16 CF, RF 0 1 KCR OAK 2016 2017  
3727 3727 Rich Hill 37 hillri01 2017 LAD NL 3.837211135 2.07 P 12 1 LAD OAK 2016 2019  
3761 3761 Brett Eibner 28 eibnebr01 2017 LAD NL 0.356070941 -0.175 LF, CF, RF 0 1 LAD OAK 2017 2017  
3822 3822 Eric Sogard 31 sogarer01 2017 MIL NL 2.980237154 1.49 2B, SS, 3B, LF 9 1 MIL OAK 2017 2018 TOR
3837 3837 Stephen Vogt 32 vogtst01 2017 MIL NL 1.285787936 0.245 C, LF 3 2 MIL OAK 2017 2017 SFG
3986 3986 Sonny Gray 27 grayso01 2017 NYY AL 1.843575861 0.775 P 4 2 NYY OAK 2017 2018 CIN
4157 4157 Josh Lindblom 30 lindbjo01 2017 PIT NL 0.199617073 0.005 P 0 1 PIT OAK 2017 2017  
4233 4233 Danny Valencia 32 valenda01 2017 SEA AL 4.7238964 0.295 1B, RF, 3B 7 1 SEA OAK 2017 2017 BAL
4242 4242 Yonder Alonso 30 alonsyo01 2017 SEA AL 1.41716892 0.49 1B 3 2 SEA OAK 2017 2017 CLE
4266 4266 Cody Martin 27 martico01 2017 SEA AL 0.033144928 -0.06 P 0 1 SEA OAK 2016 2017  
4273 4273 Dillon Overton 25 overtdi01 2017 SEA AL 0.34180707 -0.19 P 0 1 SEA OAK 2017 2017 SDP
4275 4275 Evan Scribner 31 scribev01 2017 SEA AL 0.177956697 -0.285 P 0 1 SEA OAK 2016 2017  
4430 4430 Trevor Plouffe 31 plouftr01 2017 TBR AL 1.080039203 -0.52 3B, 1B, 2B 0 2 TBD OAK 2017 2017 PHI
4453 4453 A.J. Griffin 29 griffaj01 2017 TEX AL 2.039374304 0.04 P 3 1 TEX OAK 2016 2017  
4483 4483 Josh Donaldson 31 donaljo02 2017 TOR AL 4.692985318 5.045 3B, SS 22 1 TOR OAK 2015 2018 CLE
4527 4527 Cesar Valdez 32 valdece01 2017 TOR AL 0.458504096 -0.13 P 0 2 TOR OAK 2017 2017  
4546 4546 Gio Gonzalez 31 gonzagi01 2017 WSN NL 5.633380344 4.935 P 23 1 WSN OAK 2012 2018 MIL
4556 4556 Sean Doolittle 30 doolise01 2017 WSN NL 1.283566338 1.04 P 5 2 WSN OAK 2017 2019  
4559 4559 Ryan Madson 36 madsory01 2017 WSN NL 0.694855134 0.95 P 4 2 WSN OAK 2017 2018 LAD
4604 4604 Brad Ziegler 36 zieglbr01 2016 ARI NL 1.577196923 0.925 P 5 1 ARI OAK 2011 2016 BOS
4801 4801 Jon Lester 32 lestejo01 2016 CHC NL 5.663225806 4.83 P 22 1 CHC OAK 2015 2019  
4809 4809 Jason Hammel 33 hammeja01 2016 CHC NL 4.632352941 1.725 P 11 1 CHC OAK 2015 2016 KCR
4816 4816 Chris Coghlan 31 coghlch01 2016 CHC NL 1.250884583 0.905 LF, 2B, 3B, RF, 1B 4 2 CHC OAK 2016 2016 TOR
4855 4855 Brett Lawrie 26 lawribr01 2016 CHW AL 3.645768538 1.14 2B 8 1 CHW OAK 2016 2016  
4959 4959 Dan Otero 31 oteroda01 2016 CLE AL 2.025798816 2.108012422 P 9 1 CLE OAK 2016 2019  
4978 4978 Coco Crisp 36 crispco01 2016 CLE AL 0.605546493 0.11068323 LF, CF 1 2 CLE OAK 2016 2016  
4999 4999 Carlos Gonzalez 30 gonzaca01 2016 COL NL 6.213934565 2.48 RF 15 1 COL OAK 2009 2018 CLE
5102 5102 Luke Gregerson 32 gregelu01 2016 HOU AL 2.240949921 0.795 P 5 1 HOU OAK 2015 2017 STL
5166 5166 Billy Burns 26 burnsbi02 2016 KCR AL 0.384679158 -0.37 CF, LF, RF 0 2 KCR OAK 2016 2017  
5214 5214 Craig Gentry 32 gentrcr01 2016 LAA AL 0.375747508 -0.305 LF, CF 0 1 ANA OAK 2016 2016 BAL
5241 5241 Rich Hill 36 hillri01 2016 LAD NL 0.959106755 1.125 P 5 2 LAD OAK 2016 2019  
5250 5250 Josh Reddick 29 reddijo01 2016 LAD NL 1.656859391 -0.025 RF 2 2 LAD OAK 2016 2016 HOU
5394 5394 Fernando Abad 30 abadfe01 2016 MIN AL 1.210686842 0.765 P 4 1 MIN OAK 2016 2016 BOS
5397 5397 Kurt Suzuki 32 suzukku01 2016 MIN AL 3.479813415 0.15 C 4 1 MIN OAK 2014 2016 ATL
5414 5414 Tommy Milone 29 milonto01 2016 MIN AL 1.914406113 -0.28 P 1 1 MIN OAK 2014 2016 MIL
5436 5436 Bartolo Colon 43 colonba01 2016 NYM NL 5.329546675 2.49 P 15 1 NYM OAK 2014 2016 ATL
5508 5508 Billy Butler 30 butlebi03 2016 NYY AL 0.307335652 0.085 1B 1 2 NYY OAK 2016 2016  
5521 5521 Ike Davis 29 davisik02 2016 NYY AL 0.144063587 -0.125 1B 0 1 NYY OAK 2016 2016  
5623 5623 Patrick Schuster 25 schuspa01 2016 PHI NL 0.052063877 -0.475 P 0 2 PHI OAK 2016 2016  
5686 5686 Drew Pomeranz 27 pomerdr01 2016 SDP NL 2.911490391 2.88 P 13 1 SDP OAK 2016 2016 BOS
5694 5694 Derek Norris 27 norride01 2016 SDP NL 4.667720963 0.495 C, 1B 8 1 SDP OAK 2015 2016 TBD

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