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

761 rows where next_franch = "TBD"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, year_ID, lg_ID, quasi_ws, stint_ID, franch_id, prev_franch, year_acq, year_left

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
692 692 Travis d'Arnaud 30 darnatr01 2019 LAD NL 0.00999483 -0.015283019 C, 1B 0 2 LAD NYM 2019 2019 TBD
710 710 Trevor Richards 26 richatr01 2019 MIA NL 3.256753371 1.186981132 P 8 1 FLA   2018 2019 TBD
717 717 Nick Anderson 28 anderni01 2019 MIA NL 1.459868518 0.784528302 P 4 1 FLA   2019 2019 TBD
778 778 Jesus Aguilar 29 aguilje01 2019 MIL NL 2.583475009 -0.341320755 1B, 3B 3 1 MIL CLE 2017 2019 TBD
1290 1290 Erik Kratz 39 kratzer01 2019 SFG NL 0.361934477 -0.208867925 C 0 1 SFG MIL 2019 2019 TBD
1446 1446 Peter Fairbanks 25 fairbpe01 2019 TEX AL 0.217088244 -0.239433962 P 0 1 TEX   2019 2019 TBD
1459 1459 Eric Sogard 33 sogarer01 2019 TOR AL 3.140127389 2.083584906 2B, 3B, RF, SS, LF 10 1 TOR MIL 2019 2019 TBD
1770 1770 Jalen Beeks 24 beeksja02 2018 BOS AL 0.167169706 -0.245 P 0 1 BOS   2018 2018 TBD
1838 1838 Avisail Garcia 27 garciav01 2018 CHW AL 3.690909091 0.205 RF 5 1 CHW DET 2013 2018 TBD
1948 1948 Yandy Diaz 26 diazya01 2018 CLE AL 1.109340134 0.22 1B, 3B 2 1 CLE   2017 2018 TBD
2071 2071 Charlie Morton 34 mortoch02 2018 HOU AL 4.567731465 3.175 P 16 1 HOU PHI 2017 2018 TBD
2276 2276 Trevor Richards 25 richatr01 2018 MIA NL 3.599219376 0.704347826 P 8 1 FLA   2018 2019 TBD
2321 2321 Jesus Aguilar 28 aguilje01 2018 MIL NL 5.549957735 3.135644172 1B, 3B 18 1 MIL CLE 2017 2019 TBD
2358 2358 Ji-Man Choi 27 choiji01 2018 MIL NL 0.313778529 0.029815951 1B, LF 1 1 MIL NYY 2018 2018 TBD
2400 2400 Oliver Drake 31 drakeol01 2018 MIN AL 0.454553519 0.32 P 2 5 MIN TOR 2018 2018 TBD
2413 2413 Aaron Slegers 25 slegeaa01 2018 MIN AL 0.29737239 -0.045 P 0 1 MIN   2017 2018 TBD
2562 2562 Emilio Pagan 27 paganem01 2018 OAK AL 1.499261989 0.05 P 2 1 OAK SEA 2018 2018 TBD
2578 2578 Wilmer Font 28 fontwi01 2018 OAK AL 0.099657688 -0.295 P 0 2 OAK LAD 2018 2018 TBD
2625 2625 Hoby Milner 27 milneho01 2018 PHI NL 0.12911074 -0.095 P 0 1 PHI   2017 2018 TBD
2652 2652 Tyler Glasnow 24 glasnty01 2018 PIT NL 1.349497229 0.186149068 P 3 1 PIT   2016 2018 TBD
2653 2653 Austin Meadows 23 meadoau01 2018 PIT NL 1.664058425 0.070434783 CF, RF, LF 3 1 PIT   2018 2018 TBD
2670 2670 Casey Sadler 27 sadleca02 2018 PIT NL 0.077988576 -0.125776398 P 0 1 PIT   2014 2018 TBD
2738 2738 Mike Zunino 27 zuninmi01 2018 SEA AL 3.873042045 2.02 C 12 1 SEA   2013 2018 TBD
2745 2745 Guillermo Heredia 27 heredgu01 2018 SEA AL 3.222753504 -0.055 CF, LF, RF 5 1 SEA   2016 2018 TBD
2840 2840 Tommy Pham 30 phamth01 2018 STL NL 3.910778137 1.195 CF, LF 10 1 STL   2014 2018 TBD
3127 3127 Anthony Banda 23 bandaan01 2017 ARI NL 0.662771246 0.145 P 1 1 ARI   2017 2017 TBD
3185 3185 Chaz Roe 30 roech01 2017 ATL NL 0.051905504 -0.11 P 0 1 ATL BAL 2016 2017 TBD
3238 3238 Vidal Nuno III 29 nunovi01 2017 BAL AL 0.317720908 -0.515 P 0 1 BAL SEA 2017 2017 TBD
3339 3339 Avisail Garcia 26 garciav01 2017 CHW AL 5.387978142 4.405 RF 20 1 CHW DET 2013 2018 TBD
3359 3359 Dan Jennings 30 jennida01 2017 CHW AL 1.410302297 0.285 P 3 1 CHW FLA 2015 2017 TBD
3462 3462 Yandy Diaz 25 diazya01 2017 CLE AL 1.671012393 0.37 3B, LF 3 1 CLE   2017 2018 TBD
3468 3468 Michael Martinez 34 martimi02 2017 CLE AL 0.130693707 0.13 2B, 3B, CF, LF, P, SS 1 1 CLE BOS 2017 2017 TBD
3575 3575 Charlie Morton 33 mortoch02 2017 HOU AL 4.109317839 2.615 P 14 1 HOU PHI 2017 2018 TBD
3672 3672 C.J. Cron 27 croncj01 2017 LAA AL 3.574686054 0.54 1B 7 1 ANA   2014 2017 TBD
3705 3705 Cesar Puello 26 puellce01 2017 LAA AL 0.038334435 0.0 LF, RF 0 1 ANA   2017 2017 TBD
3768 3768 Sergio Romo 34 romose01 2017 LAD NL 0.729669899 -0.44 P 0 1 LAD SFG 2017 2017 TBD
3798 3798 Adeiny Hechavarria 28 hechaad01 2017 MIA NL 0.655311973 0.13 SS 1 1 FLA TOR 2013 2017 TBD
3826 3826 Jesus Aguilar 27 aguilje01 2017 MIL NL 3.099845334 1.12 1B, 3B 8 1 MIL CLE 2017 2019 TBD
3903 3903 Aaron Slegers 24 slegeaa01 2017 MIN AL 0.390885881 -0.115 P 0 1 MIN   2017 2018 TBD
3925 3925 Lucas Duda 31 dudalu01 2017 NYM NL 2.887596236 1.155 1B 7 1 NYM   2010 2017 TBD
4047 4047 Trevor Plouffe 31 plouftr01 2017 OAK AL 1.891201049 -0.215 3B, 1B, 2B 2 1 OAK MIN 2017 2017 TBD
4049 4049 Joey Wendle 27 wendljo01 2017 OAK AL 0.13304932 0.155 2B 1 1 OAK   2016 2017 TBD
4095 4095 Hoby Milner 26 milneho01 2017 PHI NL 0.868141679 0.6 P 3 1 PHI   2017 2018 TBD
4117 4117 Ricardo Pinto 23 pintori01 2017 PHI NL 0.772556262 -0.635 P 0 1 PHI   2017 2017 TBD
4168 4168 Tyler Glasnow 23 glasnty01 2017 PIT NL 1.820130475 -0.82 P 0 1 PIT   2016 2018 TBD
4224 4224 Mike Zunino 26 zuninmi01 2017 SEA AL 4.109789868 4.005 C 17 1 SEA   2013 2018 TBD
4232 4232 Guillermo Heredia 26 heredgu01 2017 SEA AL 4.024759733 0.55 CF, LF, RF 7 1 SEA   2016 2018 TBD
4254 4254 Steve Cishek 31 cishest01 2017 SEA AL 0.733923406 0.145 P 1 1 SEA STL 2016 2017 TBD
4260 4260 Ryan Weber 26 weberry01 2017 SEA AL 0.101457019 0.11 P 0 1 SEA ATL 2017 2017 TBD
4264 4264 Danny Espinosa 30 espinda01 2017 SEA AL 0.160612478 -0.045 2B, 3B, 1B, SS 0 2 SEA ANA 2017 2017 TBD
4294 4294 Denard Span 33 spande01 2017 SFG NL 5.402302801 -0.02 CF 7 1 SFG WSN 2016 2017 TBD
4323 4323 Christian Arroyo 22 arroych01 2017 SFG NL 1.345592026 -0.48 3B, SS, 2B 0 1 SFG   2017 2017 TBD
4331 4331 Tommy Pham 29 phamth01 2017 STL NL 5.219901511 6.18 LF, CF, RF 25 1 STL   2014 2018 TBD
4442 4442 Carlos Gomez 31 gomezca01 2017 TEX AL 4.054479816 1.735 CF 11 1 TEX HOU 2016 2017 TBD
4536 4536 Rob Refsnyder 26 refsnro01 2017 TOR AL 0.548776509 -0.35 2B, LF, 1B, RF 0 2 TOR NYY 2017 2017 TBD
4615 4615 Rickie Weeks 33 weeksri01 2016 ARI NL 2.00641242 0.055 LF, RF 3 1 ARI SEA 2016 2016 TBD
4655 4655 Mallex Smith 23 smithma05 2016 ATL NL 2.121469888 0.749627329 CF, LF, RF 5 1 ATL   2016 2016 TBD
4664 4664 Chaz Roe 29 roech01 2016 ATL NL 0.637294962 0.442732919 P 2 2 ATL BAL 2016 2017 TBD
4672 4672 Brandon Snyder 29 snydebr03 2016 ATL NL 0.463763185 0.22136646 3B, 1B, LF 1 1 ATL BOS 2016 2016 TBD
4730 4730 Tommy Hunter 29 hunteto02 2016 BAL AL 0.351114424 0.3 P 1 2 BAL CLE 2016 2016 TBD
4857 4857 Avisail Garcia 25 garciav01 2016 CHW AL 4.300867572 0.565 RF, LF 7 1 CHW DET 2013 2018 TBD
4858 4858 Dan Jennings 29 jennida01 2016 CHW AL 1.868098841 1.275 P 6 1 CHW FLA 2015 2017 TBD
4915 4915 Jumbo Diaz 32 diazju03 2016 CIN NL 1.06956393 0.115 P 2 1 CIN   2014 2016 TBD
4986 4986 Adam Moore 32 mooread01 2016 CLE AL 0.04730832 -0.105652174 C 0 1 CLE SDP 2015 2016 TBD
5093 5093 Colby Rasmus 29 rasmuco01 2016 HOU AL 3.912959068 1.68 LF, CF, RF 10 1 HOU TOR 2015 2016 TBD
5176 5176 C.J. Cron 26 croncj01 2016 LAA AL 4.287375415 1.71 1B 11 1 ANA   2014 2017 TBD
5275 5275 Jose De Leon 23 deleojo03 2016 LAD NL 0.47742357 -0.52 P 0 1 LAD   2016 2016 TBD
5286 5286 Adeiny Hechavarria 27 hechaad01 2016 MIA NL 5.454014097 0.81 SS 10 1 FLA TOR 2013 2017 TBD
5426 5426 Kevin Jepsen 31 jepseke01 2016 MIN AL 1.166025413 -0.49 P 0 1 MIN TBD 2015 2016 TBD
5427 5427 Oswaldo Arcia 25 arciaos01 2016 MIN AL 1.063535467 -0.515 LF, RF 0 1 MIN   2013 2016 TBD
5455 5455 Lucas Duda 30 dudalu01 2016 NYM NL 1.722375691 0.115 1B 3 1 NYM   2010 2017 TBD
5489 5489 Nathan Eovaldi 26 eovalna01 2016 NYY AL 3.428746053 0.99 P 8 1 NYY FLA 2015 2016 TBD
5559 5559 Joey Wendle 26 wendljo01 2016 OAK AL 1.005668556 0.21 2B 2 1 OAK   2016 2017 TBD
5592 5592 Peter Bourjos 29 bourjpe01 2016 PHI NL 3.912982209 0.115 RF, CF 6 1 PHI STL 2016 2016 TBD
5617 5617 Taylor Featherston 26 feathta01 2016 PHI NL 0.286066584 -0.185 2B 0 1 PHI ANA 2016 2016 TBD
5662 5662 Tyler Glasnow 22 glasnty01 2016 PIT NL 0.573256813 0.085 P 1 1 PIT   2016 2018 TBD
5694 5694 Derek Norris 27 norride01 2016 SDP NL 4.667720963 0.495 C, 1B 8 1 SDP OAK 2015 2016 TBD
5724 5724 Alexei Ramirez 34 ramiral03 2016 SDP NL 4.525039536 -1.92 SS, RF, 2B 1 1 SDP CHW 2016 2016 TBD
5750 5750 Mike Zunino 25 zuninmi01 2016 SEA AL 1.795549823 1.685 C 8 1 SEA   2013 2018 TBD
5752 5752 Steve Cishek 30 cishest01 2016 SEA AL 2.651286266 1.295 P 8 1 SEA STL 2016 2017 TBD
5768 5768 Jesus Sucre 28 sucreje01 2016 SEA AL 0.271202838 0.55 C 2 1 SEA   2013 2016 TBD
5770 5770 Guillermo Heredia 25 heredgu01 2016 SEA AL 1.000644953 0.335 LF, RF, CF 2 1 SEA   2016 2018 TBD
5803 5803 Denard Span 32 spande01 2016 SFG NL 6.26309544 1.225 CF 12 1 SFG WSN 2016 2017 TBD
5806 5806 Matt Duffy 25 duffyma01 2016 SFG NL 2.812002034 1.225 3B, SS 7 1 SFG   2014 2016 TBD
5863 5863 Tommy Pham 28 phamth01 2016 STL NL 1.799898253 0.175 CF, LF, RF 3 1 STL   2014 2018 TBD
5950 5950 Carlos Gomez 30 gomezca01 2016 TEX AL 1.242788858 0.845 CF, LF, RF 5 2 TEX HOU 2016 2017 TBD
5958 5958 Bobby Wilson 33 wilsobo02 2016 TEX AL 1.347947915 -0.085 C 2 2 TEX DET 2016 2016 TBD
6036 6036 Wilson Ramos 28 ramoswi01 2016 WSN NL 5.202195164 3.42 C 18 1 WSN MIN 2010 2016 TBD
6171 6171 Dana Eveland 31 evelada01 2015 ATL NL 0.124380575 -0.1 P 0 1 ATL NYM 2015 2015 TBD
6204 6204 Steve Pearce 32 pearcst01 2015 BAL AL 3.149540518 -0.11 LF, 1B, 2B, RF 4 1 BAL NYY 2013 2015 TBD
6279 6279 Daniel Nava 32 navada01 2015 BOS AL 0.728267869 -0.41 RF, 1B, LF 0 1 BOS   2010 2015 TBD
6343 6343 Avisail Garcia 24 garciav01 2015 CHW AL 5.764511328 -0.33 RF 8 1 CHW DET 2013 2018 TBD
6354 6354 Dan Jennings 28 jennida01 2015 CHW AL 1.567438061 0.265 P 3 1 CHW FLA 2015 2017 TBD
6390 6390 Jumbo Diaz 31 diazju03 2015 CIN NL 1.919854021 0.225 P 3 1 CIN   2014 2016 TBD
6447 6447 Ryan Webb 29 webbry01 2015 CLE AL 1.135222652 0.357204969 P 2 1 CLE BAL 2015 2015 TBD
6460 6460 Adam Moore 31 mooread01 2015 CLE AL 0.038126541 -0.005031056 C 0 1 CLE SDP 2015 2016 TBD
6483 6483 Corey Dickerson 26 dickeco01 2015 COL NL 2.360347826 0.54 LF, CF 5 1 COL   2013 2015 TBD
6575 6575 Colby Rasmus 28 rasmuco01 2015 HOU AL 4.652662918 2.845 LF, CF, RF 14 1 HOU TOR 2015 2016 TBD
6588 6588 Hank Conger 27 congeha01 2015 HOU AL 2.196824347 0.7 C, LF 5 1 HOU ANA 2015 2015 TBD
6675 6675 C.J. Cron 25 croncj01 2015 LAA AL 3.926273458 0.335 1B 7 1 ANA   2014 2017 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
);