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,030 rows where prev_franch = "LAD"

✎ 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
2 2 Zack Greinke 35 greinza01 2019 ARI NL 4.10802053 5.023018868 P 21 1 ARI LAD 2016 2019 HOU
15 15 Tim Locastro 26 locasti01 2019 ARI NL 2.346421894 0.860943396 LF, RF, CF 6 1 ARI LAD 2019 2019  
69 69 Charlie Culberson 30 culbech01 2019 ATL NL 1.428180575 0.244528302 LF, RF, 1B, SS, P, 3B 3 1 ATL LAD 2018 2019  
77 77 Grant Dayton 31 daytogr01 2019 ATL NL 0.240101153 0.122264151 P 1 1 ATL LAD 2019 2019  
206 206 Yu Darvish 32 darviyu01 2019 CHC NL 5.034783981 2.745849057 P 14 1 CHC LAD 2018 2019  
308 308 Yasiel Puig 28 puigya01 2019 CIN NL 4.169395018 0.820188679 RF 8 1 CIN LAD 2019 2019 CLE
321 321 Kyle Farmer 28 farmeky01 2019 CIN NL 1.950533808 0.178301887 2B, 1B, C, 3B, P, SS 3 1 CIN LAD 2019 2019  
323 323 Jose Peraza 25 perazjo01 2019 CIN NL 4.014590747 -0.636792453 2B, SS, LF, 3B, CF, P 3 1 CIN LAD 2016 2019  
331 331 Alex Wood 28 woodal02 2019 CIN NL 1.015618858 -0.213962264 P 1 1 CIN LAD 2019 2019  
342 342 Scott Schebler 28 schebsc01 2019 CIN NL 0.980427046 -0.565471698 CF, LF, RF 0 1 CIN LAD 2016 2019  
345 345 Matt Kemp 34 kempma01 2019 CIN NL 0.639857651 -0.860943396 LF 0 1 CIN LAD 2019 2019  
514 514 Josh Reddick 32 reddijo01 2019 HOU AL 5.062829736 0.952641509 RF, LF, CF, 1B 9 1 HOU LAD 2017 2019  
704 704 Miguel Rojas 30 rojasmi02 2019 MIA NL 5.305506217 1.951132075 SS, 1B, 2B 13 1 FLA LAD 2015 2019  
753 753 Yasmani Grandal 30 grandya01 2019 MIL NL 6.123427406 4.065283019 C, 1B 22 1 MIL LAD 2019 2019  
1118 1118 Manny Machado 26 machama01 2019 SDP NL 6.68359375 2.684716981 3B, SS 17 1 SDP LAD 2019 2019  
1207 1207 Zac Rosscup 31 rosscza01 2019 SEA AL 0.474871854 0.066226415 P 1 1 SEA LAD 2019 2019 TOR
1263 1263 Tony Watson 34 watsoto01 2019 SFG NL 2.037589769 -0.056037736 P 3 1 SFG LAD 2018 2019  
1286 1286 Pat Venditte 34 vendipa01 2019 SFG NL 0.050990735 -0.142641509 P 0 1 SFG LAD 2019 2019  
1357 1357 Travis d'Arnaud 30 darnatr01 2019 TBR AL 3.386241665 1.599622642 C, 1B 10 3 TBD LAD 2019 2019  
1394 1394 Jose De Leon 26 deleojo03 2019 TBR AL 0.0576998 -0.010188679 P 0 1 TBD LAD 2017 2019  
1470 1470 Daniel Hudson 32 hudsoda01 2019 TOR AL 1.72353794 0.779433962 P 5 1 TOR LAD 2019 2019 WSN
1512 1512 Brock Stewart 27 stewabr01 2019 TOR AL 0.611517282 -0.67245283 P 0 2 TOR LAD 2019 2019  
1525 1525 Brian Dozier 32 doziebr01 2019 WSN NL 4.764250043 1.034150943 2B, P 9 1 WSN LAD 2019 2019  
1567 1567 Zack Greinke 34 greinza01 2018 ARI NL 5.686187576 4.15 P 20 1 ARI LAD 2016 2019 HOU
1627 1627 Charlie Culberson 29 culbech01 2018 ATL NL 3.153131859 1.11 LF, 3B, SS, 2B, 1B, RF, P 8 1 ATL LAD 2018 2019  
1635 1635 Brandon McCarthy 34 mccarbr01 2018 ATL NL 2.174757919 -0.09 P 3 1 ATL LAD 2018 2018  
1655 1655 Josh Ravin 30 ravinjo01 2018 ATL NL 0.095797367 -0.03 P 0 1 ATL LAD 2018 2018  
1704 1704 Breyvic Valera 26 valerbr01 2018 BAL AL 0.395608052 0.06 2B, 3B, SS, RF 1 2 BAL LAD 2018 2018 NYY
1753 1753 Hanley Ramirez 34 ramirha01 2018 BOS AL 1.800382044 -0.005 1B 3 1 BOS LAD 2015 2018 CLE
1792 1792 Brandon Morrow 33 morrobr01 2018 CHC NL 1.105278333 1.058466258 P 5 1 CHC LAD 2018 2018  
1800 1800 Yu Darvish 31 darviyu01 2018 CHC NL 1.084133878 0.069570552 P 2 1 CHC LAD 2018 2019  
1816 1816 Mike Freeman 30 freemmi01 2018 CHC NL 0.009602649 -0.099386503 2B 0 1 CHC LAD 2017 2018 CLE
1839 1839 Luis Avilan 28 avilalu01 2018 CHW AL 1.300090207 0.62 P 4 1 CHW LAD 2018 2018 PHI
1876 1876 Jose Peraza 24 perazjo01 2018 CIN NL 6.722212795 2.43 SS, RF 16 1 CIN LAD 2016 2019  
1879 1879 Scott Schebler 27 schebsc01 2018 CIN NL 4.232139827 1.105 RF, CF, LF 9 1 CIN LAD 2016 2019  
2031 2031 Louis Coleman 32 colemlo01 2018 DET AL 1.580550953 0.485 P 4 1 DET LAD 2018 2018  
2076 2076 Josh Reddick 31 reddijo01 2018 HOU AL 4.614605457 1.43 RF, LF 11 1 HOU LAD 2017 2019  
2270 2270 Miguel Rojas 29 rojasmi02 2018 MIA NL 5.28 1.700496894 SS, 1B, 3B, 2B 13 1 FLA LAD 2015 2019  
2390 2390 Logan Forsythe 31 forsylo01 2018 MIN AL 1.93900848 0.5 2B, 3B, 1B, LF 4 2 MIN LAD 2018 2018 TEX
2451 2451 Adrian Gonzalez 36 gonzaad01 2018 NYM NL 1.855920602 -0.44 1B 1 1 NYM LAD 2018 2018  
2508 2508 Ronald Torreyes 25 torrero01 2018 NYY AL 0.946711474 0.39 2B, 3B, SS 2 1 NYY LAD 2016 2018 MIN
2567 2567 Danny Coulombe 28 couloda01 2018 OAK AL 0.603515237 -0.12 P 1 1 OAK LAD 2015 2018  
2572 2572 Trayce Thompson 27 thomptr01 2018 OAK AL 0.065126724 -0.02 RF, LF, CF 0 1 OAK LAD 2018 2018 CHW
2578 2578 Wilmer Font 28 fontwi01 2018 OAK AL 0.099657688 -0.295 P 0 2 OAK LAD 2018 2018 TBD
2579 2579 Chris Hatcher 33 hatchch02 2018 OAK AL 0.937173085 -0.335 P 0 1 OAK LAD 2017 2018  
2789 2789 Tony Watson 33 watsoto01 2018 SFG NL 2.511311876 1.8 P 9 1 SFG LAD 2018 2019  
2897 2897 Sergio Romo 35 romose01 2018 TBR AL 2.443815085 0.45 P, 3B 5 1 TBD LAD 2017 2018 FLA
2996 2996 Curtis Granderson 37 grandcu01 2018 TOR AL 3.344679445 0.55 LF, RF, CF 7 1 TOR LAD 2018 2018 MIL
3099 3099 Zack Greinke 33 greinza01 2017 ARI NL 5.680345917 5.655 P 25 1 ARI LAD 2016 2019 HOU
3171 3171 Jim Johnson 34 johnsji04 2017 ATL NL 2.067569238 -0.37 P 2 1 ATL LAD 2016 2017 ANA
3186 3186 Micah Johnson 26 johnsmi04 2017 ATL NL 0.108245674 -0.115 LF 0 1 ATL LAD 2017 2017  
3255 3255 Hanley Ramirez 33 ramirha01 2017 BOS AL 5.079018211 -0.38 1B 7 1 BOS LAD 2015 2018 CLE
3331 3331 Mike Freeman 29 freemmi01 2017 CHC NL 0.263947413 -0.105 SS, 1B, 2B, 3B, P 0 3 CHC LAD 2017 2018 CLE
3337 3337 Brett Anderson 29 anderbr04 2017 CHC NL 0.60997247 -0.265 P 0 1 CHC LAD 2017 2017 TOR
3398 3398 Scott Schebler 26 schebsc01 2017 CIN NL 5.233305013 1.1 RF, CF 10 1 CIN LAD 2016 2019  
3402 3402 Jose Peraza 23 perazjo01 2017 CIN NL 5.105182668 -0.54 2B, SS, CF 5 1 CIN LAD 2016 2019  
3572 3572 Josh Reddick 30 reddijo01 2017 HOU AL 5.017622557 3.74 RF, LF, CF, 1B 18 1 HOU LAD 2017 2019  
3655 3655 Onelki Garcia 27 garcion01 2017 KCR AL 0.151409285 -0.28 P 0 1 KCR LAD 2017 2017  
3677 3677 Jesse Chavez 33 chaveje01 2017 LAA AL 3.821226912 -0.05 P 6 1 ANA LAD 2017 2017 TEX
3678 3678 Bud Norris 32 norribu01 2017 LAA AL 2.307504174 0.505 P 5 1 ANA LAD 2017 2017 STL
3773 3773 Dee Gordon 29 gordode01 2017 MIA NL 6.797639123 3.485 2B, SS 20 1 FLA LAD 2015 2017 SEA
3777 3777 Miguel Rojas 28 rojasmi02 2017 MIA NL 2.992917369 1.81 SS, 3B, 1B, 2B 9 1 FLA LAD 2015 2019  
3911 3911 Nick Tepesch 28 tepesni01 2017 MIN AL 0.04729274 -0.225 P 0 1 MIN LAD 2017 2017 TOR
3985 3985 Ronald Torreyes 24 torrero01 2017 NYY AL 3.079159425 0.685 2B, SS, 3B, RF 6 1 NYY LAD 2016 2018 MIN
4037 4037 Danny Coulombe 27 couloda01 2017 OAK AL 1.574977661 0.45 P 4 1 OAK LAD 2015 2018  
4045 4045 Chris Hatcher 32 hatchch02 2017 OAK AL 0.863186817 0.29 P 2 2 OAK LAD 2017 2018  
4085 4085 Howie Kendrick 33 kendrho01 2017 PHI NL 1.552771581 1.17 LF, 2B, 1B, RF 5 1 PHI LAD 2017 2017 WSN
4135 4135 Juan Nicasio 30 nicasju01 2017 PIT NL 2.226868641 1.37 P 7 1 PIT LAD 2016 2017 PHI
4204 4204 Zach Lee 25 leeza01 2017 SDP NL 0.158683883 0.01 P 0 1 SDP LAD 2017 2017  
4246 4246 Carlos Ruiz 38 ruizca01 2017 SEA AL 1.369929956 0.085 C, 1B, P 2 1 SEA LAD 2017 2017  
4278 4278 Casey Fien 33 fienca01 2017 SEA AL 0.165132766 -0.42 P 0 1 SEA LAD 2017 2017 PHI
4397 4397 Sergio Romo 34 romose01 2017 TBR AL 0.971432411 0.815 P 4 2 TBD LAD 2017 2018 FLA
4425 4425 Jose De Leon 24 deleojo03 2017 TBR AL 0.090311488 -0.175 P 0 1 TBD LAD 2017 2019  
4507 4507 Darwin Barney 31 barneda01 2017 TOR AL 3.425122349 -0.62 2B, 3B, SS, LF 3 1 TOR LAD 2015 2017  
4531 4531 J.P. Howell 34 howeljp01 2017 TOR AL 0.306871326 -0.215 P 0 1 TOR LAD 2017 2017  
4538 4538 Mike Bolsinger 29 bolsimi01 2017 TOR AL 1.094261017 -0.405 P 0 1 TOR LAD 2017 2017  
4576 4576 Joe Blanton 36 blantjo01 2017 WSN NL 1.169819402 -0.18 P 1 1 WSN LAD 2017 2017  
4589 4589 Chris Heisey 32 heisech01 2017 WSN NL 0.783247863 -0.59 LF, RF 0 1 WSN LAD 2016 2017  
4595 4595 Zack Greinke 32 greinza01 2016 ARI NL 4.344405154 2.59 P 14 1 ARI LAD 2016 2019 HOU
4649 4649 Jim Johnson 33 johnsji04 2016 ATL NL 2.442177237 1.433850932 P 8 1 ATL LAD 2016 2017 ANA
4669 4669 Chris Withrow 27 withrch01 2016 ATL NL 1.233578813 0.045279503 P 2 1 ATL LAD 2016 2016  
4756 4756 Hanley Ramirez 32 ramirha01 2016 BOS AL 5.714285714 2.915 1B 15 1 BOS LAD 2015 2018 CLE
4842 4842 Tim Federowicz 28 federti01 2016 CHC NL 0.322493682 -0.415 C 0 1 CHC LAD 2016 2016 SFG
4867 4867 Jimmy Rollins 37 rolliji01 2016 CHW AL 1.576035358 -0.05 SS 2 1 CHW LAD 2016 2016  
4906 4906 Scott Schebler 25 schebsc01 2016 CIN NL 2.83613664 0.605 RF, CF, LF 6 1 CIN LAD 2016 2019  
4911 4911 Jose Peraza 22 perazjo01 2016 CIN NL 2.574648864 0.4 SS, CF, 2B, LF 5 1 CIN LAD 2016 2019  
4922 4922 Matt Magill 26 magilma01 2016 CIN NL 0.085439735 -0.06 P 0 1 CIN LAD 2016 2016 MIN
5206 5206 Nick Buss 29 bussni01 2016 LAA AL 0.867109635 -0.155 LF, RF, CF 1 1 ANA LAD 2016 2016  
5218 5218 David Huff 31 huffda01 2016 LAA AL 0.155153383 -0.455 P 0 1 ANA LAD 2016 2016  
5293 5293 Dee Gordon 28 gordode01 2016 MIA NL 3.449888259 0.830124224 2B 7 1 FLA LAD 2015 2017 SEA
5300 5300 Miguel Rojas 27 rojasmi02 2016 MIA NL 2.133745917 -0.070434783 2B, 1B, SS, 3B 3 1 FLA LAD 2015 2019  
5389 5389 Ricky Nolasco 33 nolasri01 2016 MIN AL 3.536299985 1.065 P 7 1 MIN LAD 2014 2016 ANA
5492 5492 Ronald Torreyes 23 torrero01 2016 NYY AL 1.62311641 0.5 3B, SS, 2B, RF 4 1 NYY LAD 2016 2018 MIN
5551 5551 Danny Coulombe 26 couloda01 2016 OAK AL 1.131085895 0.345 P 3 1 OAK LAD 2015 2018  
5575 5575 Eric Surkamp 28 surkaer01 2016 OAK AL 1.120094505 -0.475 P 0 1 OAK LAD 2016 2016  
5608 5608 A.J. Ellis 35 ellisaj01 2016 PHI NL 0.357583231 0.145 C 1 2 PHI LAD 2016 2016 FLA
5641 5641 Juan Nicasio 29 nicasju01 2016 PIT NL 3.588447834 0.875 P 8 1 PIT LAD 2016 2017 PHI
5697 5697 Matt Kemp 31 kempma01 2016 SDP NL 4.39254964 0.29 RF, LF 7 1 SDP LAD 2015 2016 ATL
5778 5778 Joel Peralta 40 peraljo01 2016 SEA AL 0.764379776 -0.17 P 1 1 SEA LAD 2016 2016 CHC
5784 5784 Joe Wieland 26 wielajo01 2016 SEA AL 0.137353317 -0.115 P 0 1 SEA LAD 2016 2016  

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