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 = "KCR"

✎ 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
240 240 Randy Rosario 25 rosarra01 2019 CHC NL 0.295761913 -0.117169811 P 0 1 CHC MIN 2018 2019 KCR
249 249 Mike Montgomery 29 montgmi01 2019 CHC NL 0.923602972 -0.387169811 P 0 1 CHC SEA 2016 2019 KCR
795 795 Jacob Barnes 29 barneja01 2019 MIL NL 0.407123182 -0.239433962 P 0 1 MIL   2016 2019 KCR
1589 1589 Chris Owings 26 owingch01 2018 ARI NL 3.076738197 -0.47 RF, CF, 3B, 2B, LF 3 1 ARI   2013 2018 KCR
1591 1591 Brad Boxberger 30 boxbebr01 2018 ARI NL 2.155735716 -0.485 P 2 1 ARI TBD 2018 2018 KCR
1611 1611 Jake Diekman 31 diekmja01 2018 ARI NL 0.442302496 -0.51 P 0 2 ARI TEX 2018 2018 KCR
1645 1645 Lucas Duda 32 dudalu01 2018 ATL NL 0.215431369 0.075 1B 1 2 ATL KCR 2018 2018 KCR
1787 1787 Mike Montgomery 28 montgmi01 2018 CHC NL 3.146294915 1.316871166 P 9 1 CHC SEA 2016 2019 KCR
1796 1796 Randy Rosario 24 rosarra01 2018 CHC NL 1.473384074 0.089447853 P 3 1 CHC MIN 2018 2019 KCR
1806 1806 Terrance Gore 27 gorete01 2018 CHC NL 0.048013245 0.119263804 LF 0 1 CHC KCR 2018 2018 KCR
1880 1880 Billy Hamilton 27 hamilbi02 2018 CIN NL 5.472255218 0.79 CF, RF 9 1 CIN   2013 2018 KCR
1901 1901 Homer Bailey 32 baileho02 2018 CIN NL 2.996938977 -0.81 P 1 1 CIN   2007 2018 KCR
1911 1911 Rosell Herrera 25 herrero02 2018 CIN NL 0.127948413 -0.15 RF, 2B, CF, 3B, LF 0 1 CIN   2018 2018 KCR
2009 2009 Jerry Vasto 26 vastoje01 2018 COL NL 0.017058147 -0.089447853 P 0 1 COL   2018 2018 KCR
2092 2092 Martin Maldonado 31 maldoma01 2018 HOU AL 1.080215651 0.37 C 3 2 HOU ANA 2018 2018 KCR
2349 2349 Jacob Barnes 28 barneja01 2018 MIL NL 1.317403712 0.069570552 P 2 1 MIL   2016 2019 KCR
2352 2352 Jorge Lopez 25 lopezjo02 2018 MIL NL 0.407110656 0.223619632 P 1 1 MIL   2015 2018 KCR
2357 2357 Brett Phillips 24 phillbr02 2018 MIL NL 0.235333897 0.059631902 CF, RF, LF 1 1 MIL   2017 2018 KCR
2618 2618 Ben Lively 26 livelbe01 2018 PHI NL 0.654775897 -0.095 P 1 1 PHI   2017 2018 KCR
2664 2664 Enny Romero 27 romeren01 2018 PIT NL 0.078090256 0.050310559 P 0 2 PIT WSN 2018 2018 KCR
3077 3077 Brian Goodwin 27 goodwbr01 2018 WSN NL 0.770472507 -0.08 CF, LF, RF 1 1 WSN   2016 2018 KCR
3111 3111 Chris Owings 25 owingch01 2017 ARI NL 3.811372148 0.55 SS, RF, 2B, LF 7 1 ARI   2013 2018 KCR
3269 3269 Blaine Boyer 35 boyerbl01 2017 BOS AL 0.992497374 0.3 P 2 1 BOS MIL 2017 2017 KCR
3299 3299 Mike Montgomery 27 montgmi01 2017 CHC NL 3.800072233 1.97 P 11 1 CHC SEA 2016 2019 KCR
3302 3302 Jon Jay 32 jayjo02 2017 CHC NL 4.232934435 1.395 LF, CF, RF, P 10 1 CHC SDP 2017 2017 KCR
3322 3322 Justin Grimm 28 grimmju01 2017 CHC NL 1.484145796 -0.43 P 1 1 CHC TEX 2013 2017 KCR
3349 3349 Melky Cabrera 32 cabreme01 2017 CHW AL 4.11061434 0.675 LF, RF 7 1 CHW TOR 2015 2017 KCR
3395 3395 Billy Hamilton 26 hamilbi02 2017 CIN NL 6.238572642 1.06 CF 11 1 CIN   2013 2018 KCR
3404 3404 Homer Bailey 31 baileho02 2017 CIN NL 2.726467608 0.285 P 4 1 CIN   2007 2018 KCR
3465 3465 Abraham Almonte 28 almonab01 2017 CLE AL 1.82037663 -0.065 RF, LF, CF 2 1 CLE SDP 2015 2017 KCR
3710 3710 Mike Morin 26 morinmi01 2017 LAA AL 0.349946654 -0.175 P 0 1 ANA   2014 2017 KCR
3829 3829 Brett Phillips 23 phillbr02 2017 MIL NL 0.976800137 1.235 CF, RF, LF 5 1 MIL   2017 2018 KCR
3831 3831 Jacob Barnes 27 barneja01 2017 MIL NL 2.473063463 0.54 P 5 1 MIL   2016 2019 KCR
3847 3847 Jorge Lopez 24 lopezjo02 2017 MIL NL 0.029650927 0.005 P 0 1 MIL   2015 2018 KCR
3860 3860 Wily Peralta 28 peralwi01 2017 MIL NL 1.540086767 -0.645 P 0 1 MIL   2012 2017 KCR
3861 3861 Neftali Feliz 29 felizne01 2017 MIL NL 0.959104741 -0.87 P 0 1 MIL PIT 2017 2017 KCR
4036 4036 Jesse Hahn 27 hahnje01 2017 OAK AL 1.942259694 0.565 P 4 1 OAK SDP 2015 2017 KCR
4081 4081 Ben Lively 25 livelbe01 2017 PHI NL 2.510353645 1.42 P 7 1 PHI   2017 2018 KCR
4182 4182 Trevor Cahill 29 cahiltr01 2017 SDP NL 1.727201389 1.33 P 7 1 SDP CHC 2017 2017 KCR
4189 4189 Ryan Buchter 30 buchtry01 2017 SDP NL 1.317570856 0.315 P 3 1 SDP ATL 2016 2017 KCR
4191 4191 Brandon Maurer 26 maurebr01 2017 SDP NL 1.596125675 0.04 P 3 1 SDP SEA 2015 2017 KCR
4249 4249 Sam Gaviglio 27 gavigsa01 2017 SEA AL 1.678652501 -0.095 P 2 1 SEA   2017 2017 KCR
4406 4406 Lucas Duda 31 dudalu01 2017 TBR AL 1.894805619 0.02 1B 3 2 TBD NYM 2017 2017 KCR
4496 4496 Ryan Goins 29 goinsry01 2017 TOR AL 4.342903752 -0.065 SS, 2B, 3B 6 1 TOR   2013 2017 KCR
4532 4532 Glenn Sparkman 25 sparkgl01 2017 TOR AL 0.02462372 -0.215 P 0 1 TOR   2017 2017 KCR
4558 4558 Brian Goodwin 26 goodwbr01 2017 WSN NL 2.756239316 0.375 CF, LF, RF 5 1 WSN   2016 2018 KCR
4598 4598 Chris Owings 24 owingch01 2016 ARI NL 4.560917989 1.245 SS, CF, 2B 10 1 ARI   2013 2018 KCR
4809 4809 Jason Hammel 33 hammeja01 2016 CHC NL 4.632352941 1.725 P 11 1 CHC OAK 2015 2016 KCR
4814 4814 Jorge Soler 24 solerjo01 2016 CHC NL 2.579949452 0.44 LF, RF 5 1 CHC   2014 2016 KCR
4824 4824 Justin Grimm 27 grimmju01 2016 CHC NL 1.424473435 0.34 P 3 1 CHC TEX 2013 2017 KCR
4825 4825 Travis Wood 29 woodtr01 2016 CHC NL 1.93243833 0.26 P, LF 3 1 CHC CIN 2012 2016 KCR
4827 4827 Mike Montgomery 26 montgmi01 2016 CHC NL 1.01961575 0.22 P 2 2 CHC SEA 2016 2019 KCR
4849 4849 Melky Cabrera 31 cabreme01 2016 CHW AL 6.13324603 2.355 LF 15 1 CHW TOR 2015 2017 KCR
4896 4896 Billy Hamilton 25 hamilbi02 2016 CIN NL 4.626322178 2.84 CF 16 1 CIN   2013 2018 KCR
4919 4919 Homer Bailey 30 baileho02 2016 CIN NL 0.655813164 0.05 P 1 1 CIN   2007 2018 KCR
4966 4966 Abraham Almonte 27 almonab01 2016 CLE AL 1.835562806 0.508136646 RF, LF, CF 4 1 CLE SDP 2015 2017 KCR
5192 5192 Mike Morin 25 morinmi01 2016 LAA AL 1.775292802 0.115 P 3 1 ANA   2014 2017 KCR
5210 5210 Al Alburquerque 30 albural01 2016 LAA AL 0.036402966 -0.105 P 0 1 ANA DET 2016 2016 KCR
5217 5217 Daniel Nava 33 navada01 2016 LAA AL 1.310299003 -0.44 LF, 1B, RF 0 1 ANA TBD 2016 2016 KCR
5345 5345 Wily Peralta 27 peralwi01 2016 MIL NL 3.596515015 0.555 P 7 1 MIL   2012 2017 KCR
5353 5353 Jacob Barnes 26 barneja01 2016 MIL NL 0.690971176 0.52 P 2 1 MIL   2016 2019 KCR
5555 5555 Billy Burns 26 burnsbi02 2016 OAK AL 2.823607869 -0.42 CF, LF, RF 3 1 OAK   2014 2016 KCR
5563 5563 Jesse Hahn 26 hahnje01 2016 OAK AL 1.342182209 -0.17 P 1 1 OAK SDP 2015 2017 KCR
5695 5695 Ryan Buchter 29 buchtry01 2016 SDP NL 2.008709735 1.235 P 7 1 SDP ATL 2016 2017 KCR
5700 5700 Brandon Maurer 25 maurebr01 2016 SDP NL 2.422243805 0.34 P 5 1 SDP SEA 2015 2017 KCR
5756 5756 Nate Karns 28 karnsna01 2016 SEA AL 2.355817492 0.75 P 6 1 SEA TBD 2016 2016 KCR
5853 5853 Brandon Moss 32 mossbr01 2016 STL NL 4.563676446 1.05 1B, LF, RF 9 1 STL CLE 2015 2016 KCR
5868 5868 Seth Maness 27 manesse01 2016 STL NL 0.756783102 0.18 P 2 1 STL   2013 2016 KCR
6009 6009 Ryan Goins 28 goinsry01 2016 TOR AL 1.833548387 -0.65 2B, SS, 3B, 1B, LF, P, RF 1 1 TOR   2013 2017 KCR
6072 6072 Brian Goodwin 25 goodwbr01 2016 WSN NL 0.437660779 -0.12 RF, LF, CF 0 1 WSN   2016 2018 KCR
6094 6094 Chris Owings 23 owingch01 2015 ARI NL 5.383554733 -0.97 2B, SS 4 1 ARI   2013 2018 KCR
6147 6147 Jonny Gomes 34 gomesjo01 2015 ATL NL 2.31918625 -0.345 LF, RF, P 2 1 ATL OAK 2015 2015 KCR
6150 6150 Peter Moylan 36 moylape01 2015 ATL NL 0.382507433 0.15 P 1 1 ATL LAD 2015 2015 KCR
6291 6291 Jason Hammel 32 hammeja01 2015 CHC NL 4.623643444 1.975 P 13 1 CHC OAK 2015 2016 KCR
6297 6297 Jorge Soler 23 solerjo01 2015 CHC NL 4.02404259 0.14 RF 7 1 CHC   2014 2016 KCR
6298 6298 Travis Wood 28 woodtr01 2015 CHC NL 2.741733715 0.66 P 6 1 CHC CIN 2012 2016 KCR
6299 6299 Justin Grimm 26 grimmju01 2015 CHC NL 1.567425503 0.615 P 4 1 CHC TEX 2013 2017 KCR
6338 6338 Melky Cabrera 30 cabreme01 2015 CHW AL 6.551017033 0.74 LF 12 1 CHW TOR 2015 2017 KCR
6376 6376 Johnny Cueto 29 cuetojo01 2015 CIN NL 3.669897594 3.425 P 14 1 CIN   2008 2015 KCR
6381 6381 Billy Hamilton 24 hamilbi02 2015 CIN NL 4.494282301 1.06 CF 8 1 CIN   2013 2018 KCR
6408 6408 Homer Bailey 29 baileho02 2015 CIN NL 0.31661432 -0.205 P 0 1 CIN   2007 2018 KCR
6439 6439 Abraham Almonte 26 almonab01 2015 CLE AL 1.868200493 1.142049689 CF, LF, RF 6 2 CLE SDP 2015 2017 KCR
6564 6564 Joba Chamberlain 29 chambjo03 2015 DET AL 0.789783465 -0.41757764 P 0 1 DET NYY 2014 2015 KCR
6691 6691 Mike Morin 24 morinmi01 2015 LAA AL 0.92054521 -0.215 P 1 1 ANA   2014 2017 KCR
6702 6702 Drew Butera 31 buterdr01 2015 LAA AL 0.204088472 -0.06 C, 1B 0 1 ANA LAD 2015 2015 KCR
6839 6839 Wily Peralta 26 peralwi01 2015 MIL NL 3.180986959 -0.01 P 4 1 MIL   2012 2017 KCR
6849 6849 Jorge Lopez 22 lopezjo02 2015 MIL NL 0.29428593 0.06 P 1 1 MIL   2015 2018 KCR
6955 6955 Dillon Gee 29 geedi01 2015 NYM NL 1.034057347 -0.355 P 0 1 NYM   2010 2015 KCR
7019 7019 Billy Burns 25 burnsbi02 2015 OAK AL 5.234146341 2.455 CF 14 1 OAK   2014 2016 KCR
7028 7028 Jesse Hahn 25 hahnje01 2015 OAK AL 2.720957382 1.215 P 7 1 OAK SDP 2015 2017 KCR
7029 7029 Ben Zobrist 34 zobribe01 2015 OAK AL 2.555772358 1.155 2B, LF, 3B, RF 7 1 OAK TBD 2015 2015 KCR
7137 7137 Joakim Soria 31 soriajo01 2015 PIT NL 0.892884403 0.78 P 4 2 PIT DET 2015 2015 KCR
7179 7179 Ian Kennedy 30 kenneia01 2015 SDP NL 4.817450957 0.06 P 7 1 SDP ARI 2013 2015 KCR
7181 7181 Brandon Maurer 24 maurebr01 2015 SDP NL 1.787356692 0.615 P 4 1 SDP SEA 2015 2017 KCR
7327 7327 Brandon Moss 31 mossbr01 2015 STL NL 1.513653647 0.415 RF, 1B, LF 4 2 STL CLE 2015 2016 KCR
7335 7335 Seth Maness 26 manesse01 2015 STL NL 2.339511488 -0.23 P 3 1 STL   2013 2016 KCR
7354 7354 Tony Cruz 28 cruzto03 2015 STL NL 1.513653647 -0.755 C, 3B 0 1 STL   2011 2015 KCR
7471 7471 Ryan Goins 27 goinsry01 2015 TOR AL 3.999355566 1.92 2B, SS, 3B, LF, RF 11 1 TOR   2013 2017 KCR
7565 7565 Chris Owings 22 owingch01 2014 ARI NL 3.343055556 1.65 SS, 2B 9 1 ARI   2013 2018 KCR
7623 7623 Mike Minor 26 minormi01 2014 ATL NL 3.923624815 0.47 P 7 1 ATL   2010 2014 KCR

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