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

1,498 rows where next_franch = "HOU"

✎ 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
2 2 Zack Greinke 35 greinza01 2019 ARI NL 4.10802053 5.023018868 P 21 1 ARI LAD 2016 2019 HOU
246 246 Martin Maldonado 32 maldoma01 2019 CHC NL 0.131450488 -0.244528302 C, 1B 0 2 CHC KCR 2019 2019 HOU
1472 1472 Aaron Sanchez 26 sanchaa01 2019 TOR AL 3.321218306 0.331132075 P 5 1 TOR   2014 2019 HOU
1476 1476 Joe Biagini 29 biagijo01 2019 TOR AL 1.654232648 0.53490566 P 4 1 TOR   2016 2019 HOU
1567 1567 Zack Greinke 34 greinza01 2018 ARI NL 5.686187576 4.15 P 20 1 ARI LAD 2016 2019 HOU
1932 1932 Michael Brantley 31 brantmi02 2018 CLE AL 5.833280204 3.54 LF 18 1 CLE   2009 2018 HOU
2168 2168 Martin Maldonado 31 maldoma01 2018 LAA AL 2.763720013 0.835 C 6 1 ANA MIL 2017 2018 HOU
2327 2327 Wade Miley 31 mileywa01 2018 MIL NL 2.195318998 1.485828221 P 8 1 MIL BAL 2018 2018 HOU
2386 2386 Ryan Pressly 29 pressry01 2018 MIN AL 1.506037649 0.815 P 5 1 MIN   2013 2018 HOU
2941 2941 Robinson Chirinos 34 chiriro01 2018 TEX AL 4.021484375 0.875 C 8 1 TEX TBD 2013 2018 HOU
2985 2985 Aledmys Diaz 27 diazal02 2018 TOR AL 4.331791143 1.48 SS, 3B 11 1 TOR STL 2018 2018 HOU
2995 2995 Aaron Sanchez 25 sanchaa01 2018 TOR AL 3.015636389 0.685 P 7 1 TOR   2014 2019 HOU
3009 3009 Roberto Osuna 23 osunaro01 2018 TOR AL 0.581676609 0.51 P 2 1 TOR   2015 2018 HOU
3018 3018 Joe Biagini 28 biagijo01 2018 TOR AL 2.034690649 -0.495 P 2 1 TOR   2016 2019 HOU
3099 3099 Zack Greinke 33 greinza01 2017 ARI NL 5.680345917 5.655 P 25 1 ARI LAD 2016 2019 HOU
3316 3316 Hector Rondon 29 rondohe01 2017 CHC NL 1.60690376 0.205 P 3 1 CHC   2013 2017 HOU
3362 3362 Tyler Clippard 32 clippty01 2017 CHW AL 0.386725973 0.4 P 2 2 CHW NYY 2017 2017 HOU
3445 3445 Michael Brantley 30 brantmi02 2017 CLE AL 3.500724288 1.815 LF 10 1 CLE   2009 2018 HOU
3461 3461 Joe Smith 33 smithjo05 2017 CLE AL 0.711200862 0.575 P 3 2 CLE TOR 2017 2017 HOU
3519 3519 Justin Verlander 34 verlaju01 2017 DET AL 5.093543959 3.785 P 17 1 DET   2005 2017 HOU
3665 3665 Martin Maldonado 30 maldoma01 2017 LAA AL 4.513879709 2.345 C, 1B 14 1 ANA MIL 2017 2018 HOU
3668 3668 Cameron Maybin 30 maybica01 2017 LAA AL 3.708856576 1.495 LF, CF, RF 10 1 ANA DET 2017 2017 HOU
3887 3887 Ryan Pressly 28 pressry01 2017 MIN AL 1.889281757 0.015 P 3 1 MIN   2013 2018 HOU
4123 4123 Gerrit Cole 26 colege01 2017 PIT NL 5.805069318 3.165 P 18 1 PIT   2013 2017 HOU
4309 4309 Tim Federowicz 29 federti01 2017 SFG NL 0.139542877 0.115 C, 1B 1 1 SFG CHC 2017 2017 HOU
4441 4441 Robinson Chirinos 33 chiriro01 2017 TEX AL 2.9409255 2.31 C 11 1 TEX TBD 2013 2018 HOU
4489 4489 Roberto Osuna 22 osunaro01 2017 TOR AL 2.568837518 2.13 P 10 1 TOR   2015 2018 HOU
4492 4492 Joe Biagini 27 biagijo01 2017 TOR AL 4.002659154 0.585 P 8 1 TOR   2016 2019 HOU
4503 4503 Francisco Liriano 33 liriafr01 2017 TOR AL 2.21205453 0.27 P 4 1 TOR PIT 2016 2017 HOU
4516 4516 Aaron Sanchez 24 sanchaa01 2017 TOR AL 0.958190058 -0.025 P 1 1 TOR   2014 2019 HOU
4595 4595 Zack Greinke 32 greinza01 2016 ARI NL 4.344405154 2.59 P 14 1 ARI LAD 2016 2019 HOU
4739 4739 Ashur Tolliver 28 tollias01 2016 BAL AL 0.098196513 -0.035 P 0 1 BAL   2016 2016 HOU
4819 4819 Hector Rondon 28 rondohe01 2016 CHC NL 1.851895161 0.515 P 4 1 CHC   2013 2017 HOU
4932 4932 Dayan Diaz 27 diazda01 2016 CIN NL 0.170879471 -0.355 P 0 1 CIN   2016 2016 HOU
4985 4985 Michael Brantley 29 brantmi02 2016 CLE AL 0.40685155 -0.075465839 LF 0 1 CLE   2009 2018 HOU
5041 5041 Justin Verlander 33 verlaju01 2016 DET AL 6.43480128 6.324037267 P 28 1 DET   2005 2017 HOU
5250 5250 Josh Reddick 29 reddijo01 2016 LAD NL 1.656859391 -0.025 RF 2 2 LAD OAK 2016 2016 HOU
5390 5390 Ryan Pressly 27 pressry01 2016 MIN AL 2.716601823 1.05 P 6 1 MIN   2013 2018 HOU
5408 5408 Juan Centeno 26 centeju01 2016 MIN AL 1.791217629 -0.085 C 2 1 MIN MIL 2016 2016 HOU
5486 5486 Brian McCann 32 mccanbr01 2016 NYY AL 4.725285643 1.32 C, 1B 11 1 NYY ATL 2014 2016 HOU
5601 5601 Charlie Morton 32 mortoch02 2016 PHI NL 0.487735205 0.335 P 2 1 PHI PIT 2016 2016 HOU
5636 5636 Gerrit Cole 25 colege01 2016 PIT NL 3.266964614 2.255 P 11 1 PIT   2013 2017 HOU
5748 5748 Nori Aoki 34 aokino01 2016 SEA AL 4.367300871 1.54 LF, CF 11 1 SEA SFG 2016 2016 HOU
5952 5952 Robinson Chirinos 32 chiriro01 2016 TEX AL 1.625185429 0.445 C 4 1 TEX TBD 2013 2018 HOU
5953 5953 Carlos Beltran 39 beltrca01 2016 TEX AL 1.969342344 0.085 RF 4 2 TEX NYY 2016 2016 HOU
5983 5983 Aaron Sanchez 23 sanchaa01 2016 TOR AL 5.252974891 4.205 P 20 1 TOR   2014 2019 HOU
5993 5993 Roberto Osuna 21 osunaro01 2016 TOR AL 2.912369602 1.91 P 10 1 TOR   2015 2018 HOU
5997 5997 Joe Biagini 26 biagijo01 2016 TOR AL 1.989909522 0.985 P 6 1 TOR   2016 2019 HOU
6000 6000 Francisco Liriano 32 liriafr01 2016 TOR AL 1.27754503 0.65 P 4 2 TOR PIT 2016 2017 HOU
6098 6098 Oliver Perez 33 perezol01 2015 ARI NL 0.850493975 0.385 P 2 1 ARI SEA 2014 2015 HOU
6294 6294 Hector Rondon 27 rondohe01 2015 CHC NL 2.884973667 1.82 P 10 1 CHC   2013 2017 HOU
6427 6427 Michael Brantley 28 brantmi02 2015 CLE AL 5.68085456 3.471428571 LF, CF 17 1 CLE   2009 2018 HOU
6528 6528 Justin Verlander 32 verlaju01 2015 DET AL 3.79693879 2.716770186 P 13 1 DET   2005 2017 HOU
6824 6824 Carlos Gomez 29 gomezca01 2015 MIL NL 3.188933637 1.565 CF, 2B 9 1 MIL MIN 2010 2015 HOU
6825 6825 Mike Fiers 30 fiersmi01 2015 MIL NL 3.454200563 1.255 P 9 1 MIL   2011 2015 HOU
6889 6889 Ryan Pressly 26 pressry01 2015 MIN AL 0.829448599 0.58 P 3 1 MIN   2013 2018 HOU
6964 6964 Brian McCann 31 mccanbr01 2015 NYY AL 4.971163089 2.7 C, 1B 15 1 NYY ATL 2014 2016 HOU
7021 7021 Scott Kazmir 31 kazmisc01 2015 OAK AL 3.103475362 2.805 P 12 1 OAK CLE 2014 2015 HOU
7075 7075 Ken Giles 24 gileske01 2015 PHI NL 2.586570314 1.915 P 9 1 PHI   2014 2015 HOU
7106 7106 Erik Kratz 35 kratzer01 2015 PHI NL 0.232040355 -0.055 C, 1B 0 2 PHI KCR 2015 2015 HOU
7119 7119 Gerrit Cole 24 colege01 2015 PIT NL 5.541962514 4.9 P 24 1 PIT   2013 2017 HOU
7418 7418 Robinson Chirinos 31 chiriro01 2015 TEX AL 2.56836983 1.315 C 8 1 TEX TBD 2013 2018 HOU
7474 7474 Roberto Osuna 20 osunaro01 2015 TOR AL 2.691339323 1.57 P 8 1 TOR   2015 2018 HOU
7475 7475 Aaron Sanchez 22 sanchaa01 2015 TOR AL 2.946644239 1.07 P 7 1 TOR   2014 2019 HOU
7532 7532 Doug Fister 31 fistedo01 2015 WSN NL 2.996639495 0.375 P 5 1 WSN DET 2014 2015 HOU
7576 7576 Oliver Perez 32 perezol01 2014 ARI NL 1.937315022 0.41 P 4 1 ARI SEA 2014 2015 HOU
7591 7591 Will Harris 29 harriwi10 2014 ARI NL 0.789414222 0.12 P 1 1 ARI COL 2013 2014 HOU
7619 7619 Evan Gattis 27 gattiev01 2014 ATL NL 4.075346066 2.17 C 12 1 ATL   2013 2014 HOU
7752 7752 Luis Valbuena 28 valbulu01 2014 CHC NL 5.502254596 2.435 3B, 2B 14 1 CHC CLE 2012 2014 HOU
7758 7758 Hector Rondon 26 rondohe01 2014 CHC NL 2.304006084 1.67 P 8 1 CHC   2013 2017 HOU
7790 7790 Dan Straily 25 straida01 2014 CHC NL 0.293053405 -0.395 P 0 2 CHC OAK 2014 2014 HOU
7791 7791 Jose Veras 33 verasjo01 2014 CHC NL 0.347030441 -0.4 P 0 1 CHC DET 2014 2014 HOU
7887 7887 Michael Brantley 27 brantmi02 2014 CLE AL 6.322851153 6.62 LF, CF 29 1 CLE   2009 2018 HOU
7987 7987 Justin Verlander 31 verlaju01 2014 DET AL 5.857918354 2.145 P 14 1 DET   2005 2017 HOU
8019 8019 Danny Worth 28 worthda01 2014 DET AL 0.431994819 -0.11 SS, 2B, P, 1B 0 1 DET   2010 2014 HOU
8135 8135 Hank Conger 26 congeha01 2014 LAA AL 2.409330564 1.78 C 9 1 ANA   2010 2014 HOU
8169 8169 Joe Thatcher 32 thatcjo01 2014 LAA AL 0.185169622 -0.14 P 0 2 ANA ARI 2014 2014 HOU
8224 8224 Roberto Hernandez 33 carmofa01 2014 LAD NL 1.246685705 -0.43 P 0 2 LAD PHI 2014 2014 HOU
8267 8267 Jake Marisnick 23 marisja01 2014 MIA NL 0.504605937 -0.235 RF, CF, LF 0 1 FLA   2013 2014 HOU
8274 8274 Carlos Gomez 28 gomezca01 2014 MIL NL 6.539215686 5.12 CF 25 1 MIL MIN 2010 2015 HOU
8285 8285 Mike Fiers 29 fiersmi01 2014 MIL NL 1.946987575 1.81 P 8 1 MIL   2011 2015 HOU
8332 8332 Sam Deduno 30 dedunsa01 2014 MIN AL 2.312689759 0.29 P 4 1 MIN SDP 2012 2014 HOU
8338 8338 Ryan Pressly 25 pressry01 2014 MIN AL 0.820156777 0.28 P 2 1 MIN   2013 2018 HOU
8390 8390 Kyle Farnsworth 38 farnsky01 2014 NYM NL 0.677704865 0.04 P 1 1 NYM PIT 2014 2014 HOU
8408 8408 Brian McCann 30 mccanbr01 2014 NYY AL 5.151725277 2.745 C, 1B 16 1 NYY ATL 2014 2016 HOU
8466 8466 Scott Kazmir 30 kazmisc01 2014 OAK AL 5.275680012 2.64 P 15 1 OAK CLE 2014 2015 HOU
8472 8472 Jed Lowrie 30 lowrije01 2014 OAK AL 5.279511097 1.3 SS 11 1 OAK HOU 2013 2014 HOU
8478 8478 Luke Gregerson 30 gregelu01 2014 OAK AL 2.734013444 1.325 P 8 1 OAK SDP 2014 2014 HOU
8518 8518 Ken Giles 23 gileske01 2014 PHI NL 1.512065641 1.91 P 8 1 PHI   2014 2015 HOU
8564 8564 Gerrit Cole 23 colege01 2014 PIT NL 3.800169726 1.925 P 11 1 PIT   2013 2017 HOU
8754 8754 Pat Neshek 33 neshepa01 2014 STL NL 2.484589601 2.14 P 10 1 STL OAK 2014 2014 HOU
8837 8837 Robinson Chirinos 30 chiriro01 2014 TEX AL 3.265156562 1.98 C 10 1 TEX TBD 2013 2018 HOU
8907 8907 Colby Rasmus 27 rasmuco01 2014 TOR AL 3.551213157 1.31 CF 9 1 TOR STL 2011 2014 HOU
8914 8914 Aaron Sanchez 21 sanchaa01 2014 TOR AL 1.14422235 1.02 P 5 1 TOR   2014 2019 HOU
8960 8960 Doug Fister 30 fistedo01 2014 WSN NL 4.517278028 2.685 P 14 1 WSN DET 2014 2015 HOU
9008 9008 Will Harris 28 harriwi10 2013 ARI NL 1.511719779 0.81 P 5 1 ARI COL 2013 2014 HOU
9024 9024 Tony Sipp 29 sippto01 2013 ARI NL 1.065344726 -0.365 P 1 1 ARI CLE 2013 2013 HOU
9047 9047 Evan Gattis 26 gattiev01 2013 ATL NL 3.83919598 1.47 LF, C, 1B 10 1 ATL   2013 2014 HOU
9095 9095 Scott Feldman 30 feldmsc01 2013 BAL AL 2.481919886 0.855 P 6 2 BAL CHC 2013 2013 HOU
9119 9119 L.J. Hoes 23 hoeslj01 2013 BAL AL 0.028440667 -0.095 RF, CF, LF 0 1 BAL   2012 2013 HOU

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