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,751 rows where next_franch = "STL"

✎ 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
630 630 Adalberto Mejia 26 mejiaad01 2019 LAA AL 0.442168977 0.13245283 P 1 2 ANA MIN 2019 2019 STL
1565 1565 Paul Goldschmidt 30 goldspa01 2018 ARI NL 6.870386266 5.305 1B 26 1 ARI   2011 2018 STL
1947 1947 Andrew Miller 33 millean01 2018 CLE AL 1.305605032 0.28 P 2 1 CLE NYY 2016 2018 STL
2198 2198 Joe Hudson 27 hudsojo03 2018 LAA AL 0.114360828 -0.04 C 0 1 ANA   2018 2018 STL
2517 2517 Chasen Shreve 27 shrevch01 2018 NYY AL 1.051227836 -0.135 P 1 1 NYY ATL 2015 2018 STL
2519 2519 Giovanny Gallegos 26 gallegi01 2018 NYY AL 0.201465289 0.02 P 0 1 NYY   2017 2018 STL
2694 2694 Tyson Ross 31 rossty01 2018 SDP NL 3.448170298 0.495 P 6 1 SDP TEX 2018 2018 STL
2723 2723 Tyler Webb 27 webbty01 2018 SDP NL 0.160721914 -0.385 P 0 1 SDP MIL 2018 2018 STL
2966 2966 Drew Robinson 26 robindr01 2018 TEX AL 1.180013021 -0.31 CF, LF, 2B, 3B, RF, SS 1 1 TEX   2017 2018 STL
3058 3058 Matt Adams 29 adamsma01 2018 WSN NL 2.701530183 1.025 1B, LF, RF 6 1 WSN ATL 2018 2018 STL
3061 3061 Matt Wieters 32 wietema01 2018 WSN NL 2.643013284 0.51 C 5 1 WSN BAL 2017 2018 STL
3098 3098 Paul Goldschmidt 29 goldspa01 2017 ARI NL 6.566224038 5.615 1B 26 1 ARI   2011 2018 STL
3219 3219 Francisco Pena 27 penafr01 2017 BAL AL 0.094740281 0.315 C 1 1 BAL KCR 2016 2017 STL
3444 3444 Andrew Miller 32 millean01 2017 CLE AL 2.459726618 2.695 P 11 1 CLE NYY 2016 2018 STL
3489 3489 Greg Holland 31 hollagr01 2017 COL NL 2.474188177 1.28 P 8 1 COL KCR 2017 2017 STL
3592 3592 Luke Gregerson 33 gregelu01 2017 HOU AL 1.727480095 0.01 P 2 1 HOU OAK 2015 2017 STL
3678 3678 Bud Norris 32 norribu01 2017 LAA AL 2.307504174 0.505 P 5 1 ANA LAD 2017 2017 STL
3770 3770 Marcell Ozuna 26 ozunama01 2017 MIA NL 6.641146712 5.535 LF, CF, RF 26 1 FLA   2013 2017 STL
3990 3990 Chasen Shreve 26 shrevch01 2017 NYY AL 1.299738084 0.375 P 3 1 NYY ATL 2015 2018 STL
3996 3996 Giovanny Gallegos 25 gallegi01 2017 NYY AL 0.429557401 0.1 P 1 1 NYY   2017 2018 STL
4107 4107 Juan Nicasio 30 nicasju01 2017 PHI NL 0.038153419 0.035 P 0 2 PHI PIT 2017 2017 STL
4455 4455 Drew Robinson 25 robindr01 2017 TEX AL 1.151624549 -0.015 3B, LF, 2B, SS, CF 2 1 TEX   2017 2018 STL
4491 4491 Dominic Leone 25 leonedo01 2017 TOR AL 2.242419039 1.78 P 9 1 TOR ARI 2017 2017 STL
4563 4563 Matt Wieters 31 wietema01 2017 WSN NL 4.61025641 -0.925 C 4 1 WSN BAL 2017 2018 STL
4593 4593 Paul Goldschmidt 28 goldspa01 2016 ARI NL 6.900101249 4.815 1B 24 1 ARI   2011 2018 STL
4679 4679 John Gant 23 gantjo01 2016 ATL NL 1.106414865 -0.120745342 P 1 1 ATL   2016 2016 STL
4743 4743 Francisco Pena 26 penafr01 2016 BAL AL 0.411483254 -0.195 C 0 1 BAL KCR 2016 2017 STL
4804 4804 Dexter Fowler 30 fowlede01 2016 CHC NL 5.384667228 4.34 CF 20 1 CHC HOU 2015 2016 STL
4859 4859 Zach Duke 33 dukeza01 2016 CHW AL 1.293693977 1.04 P 5 1 CHW MIL 2015 2016 STL
4962 4962 Andrew Miller 31 millean01 2016 CLE AL 1.039177459 1.267826087 P 5 2 CLE NYY 2016 2018 STL
5102 5102 Luke Gregerson 32 gregelu01 2016 HOU AL 2.240949921 0.795 P 5 1 HOU OAK 2015 2017 STL
5281 5281 Marcell Ozuna 25 ozunama01 2016 MIA NL 6.062231391 2.490372671 CF, LF, RF 16 1 FLA   2013 2017 STL
5511 5511 Chasen Shreve 25 shrevch01 2016 NYY AL 0.942905165 -0.145 P 1 1 NYY ATL 2015 2018 STL
5667 5667 Eric Fryer 30 fryerer01 2016 PIT NL 0.898316498 -0.245 C 1 2 PIT STL 2016 2016 STL
6002 6002 Brett Cecil 29 cecilbr01 2016 TOR AL 1.217754596 0.345 P 3 1 TOR   2009 2016 STL
6074 6074 Paul Goldschmidt 27 goldspa01 2015 ARI NL 6.7782075 7.945 1B 32 1 ARI   2011 2018 STL
6287 6287 Dexter Fowler 29 fowlede01 2015 CHC NL 6.872746007 2.685 CF 19 1 CHC HOU 2015 2016 STL
6355 6355 Zach Duke 32 dukeza01 2015 CHW AL 2.250680293 0.02 P 3 1 CHW MIL 2015 2016 STL
6388 6388 Brayan Pena 33 penabr01 2015 CIN NL 3.633043181 0.005 C, 1B 4 1 CIN DET 2014 2015 STL
6446 6446 Brandon Moss 31 mossbr01 2015 CLE AL 3.574363188 -0.447763975 RF, 1B, LF 3 1 CLE OAK 2015 2015 STL
6502 6502 Michael McKenry 30 mckenmi01 2015 COL NL 1.533217391 -0.03 C 2 1 COL PIT 2014 2015 STL
6587 6587 Luke Gregerson 31 gregelu01 2015 HOU AL 2.272888031 0.845 P 5 1 HOU OAK 2015 2017 STL
6773 6773 Marcell Ozuna 24 ozunama01 2015 MIA NL 5.053262787 1.01 CF, RF 10 1 FLA   2013 2017 STL
6799 6799 Steve Cishek 29 cishest01 2015 MIA NL 1.1629467 -0.2 P 1 1 FLA   2010 2015 STL
6851 6851 Jonathan Broxton 31 broxtjo01 2015 MIL NL 1.107594663 -0.225 P 1 1 MIL CIN 2014 2015 STL
6859 6859 Preston Guilmet 27 guilmpr01 2015 MIL NL 0.036123987 -0.165 P 0 2 MIL TBD 2015 2015 STL
6894 6894 Eric Fryer 29 fryerer01 2015 MIN AL 0.261130565 0.13 C 1 1 MIN PIT 2013 2015 STL
6926 6926 Ruben Tejada 25 tejadru01 2015 NYM NL 4.074918004 0.47 SS, 3B, 2B 7 1 NYM   2010 2015 STL
6982 6982 Chasen Shreve 24 shrevch01 2015 NYY AL 1.875321147 0.53 P 4 1 NYY ATL 2015 2018 STL
7086 7086 Jerome Williams 33 willije01 2015 PHI NL 3.968075994 -0.66 P 4 1 PHI TEX 2014 2015 STL
7172 7172 Jedd Gyorko 26 gyorkje01 2015 SDP NL 4.65871624 0.665 2B, SS, 1B 9 1 SDP   2013 2015 STL
7244 7244 Steven Baron 24 baronst01 2015 SEA AL 0.104487389 -0.24 C 0 1 SEA   2015 2015 STL
7284 7284 Mike Leake 27 leakemi01 2015 SFG NL 1.537361462 0.21 P 3 2 SFG CIN 2015 2015 STL
7479 7479 Brett Cecil 28 cecilbr01 2015 TOR AL 1.825206198 1.27 P 6 1 TOR   2009 2016 STL
7559 7559 Paul Goldschmidt 26 goldspa01 2014 ARI NL 4.823263889 4.43 1B 20 1 ARI   2011 2018 STL
7611 7611 Jason Heyward 24 heywaja01 2014 ATL NL 6.595759593 5.245 RF 25 1 ATL   2010 2014 STL
7624 7624 Jordan Walden 26 waldejo01 2014 ATL NL 1.792570526 0.835 P 5 1 ATL ANA 2013 2014 STL
7700 7700 John Lackey 35 lackejo01 2014 BOS AL 3.739658538 1.71 P 10 1 BOS ANA 2010 2014 STL
7725 7725 A.J. Pierzynski 37 pierza.01 2014 BOS AL 2.560747664 -0.52 C 2 1 BOS TEX 2014 2014 STL
7769 7769 Carlos Villanueva 30 villaca01 2014 CHC NL 2.343047009 0.425 P 4 1 CHC TOR 2013 2014 STL
7858 7858 Brayan Pena 32 penabr01 2014 CIN NL 3.835733333 -0.235 1B, C 5 1 CIN DET 2014 2015 STL
7908 7908 Justin Masterson 29 masteju01 2014 CLE AL 2.63048077 0.155 P 4 1 CLE BOS 2009 2014 STL
7915 7915 George Kottaras 31 kottage01 2014 CLE AL 0.252539913 0.32 C 1 1 CLE KCR 2014 2014 STL
7944 7944 Michael McKenry 29 mckenmi01 2014 COL NL 1.909465021 1.325 C 6 1 COL PIT 2014 2015 STL
7952 7952 Matt Belisle 34 belisma01 2014 COL NL 1.863081797 0.25 P 3 1 COL CIN 2009 2014 STL
8229 8229 Marcell Ozuna 23 ozunama01 2014 MIA NL 6.055271238 4.455 CF, LF, RF 21 1 FLA   2013 2017 STL
8236 8236 Steve Cishek 28 cishest01 2014 MIA NL 2.90960929 1.525 P 8 1 FLA   2010 2015 STL
8284 8284 Mark Reynolds 30 reynoma01 2014 MIL NL 4.396708683 0.835 1B, 3B, RF 9 1 MIL NYY 2014 2014 STL
8301 8301 Jonathan Broxton 30 broxtjo01 2014 MIL NL 0.424177589 0.125 P 1 2 MIL CIN 2014 2015 STL
8352 8352 Eric Fryer 28 fryerer01 2014 MIN AL 0.756399936 -0.22 C 0 1 MIN PIT 2013 2015 STL
8371 8371 Ruben Tejada 24 tejadru01 2014 NYM NL 4.196511829 1.445 SS 10 1 NYM   2010 2015 STL
8445 8445 Dean Anna 27 annade01 2014 NYY AL 0.239392439 0.01 SS, 2B, P 0 1 NYY   2014 2014 STL
8524 8524 Jerome Williams 32 willije01 2014 PHI NL 1.556988067 0.995 P 5 3 PHI TEX 2014 2015 STL
8618 8618 Jedd Gyorko 25 gyorkje01 2014 SDP NL 4.595600072 -0.31 2B 6 1 SDP   2013 2015 STL
8872 8872 Miles Mikolas 25 mikolmi01 2014 TEX AL 1.657402413 -0.33 P 1 1 TEX SDP 2014 2014 STL
8911 8911 Brett Cecil 27 cecilbr01 2014 TOR AL 1.817226628 1.27 P 6 1 TOR   2009 2016 STL
8946 8946 Dan Johnson 34 johnsda06 2014 TOR AL 0.453346361 -0.265 1B 0 1 TOR BAL 2014 2014 STL
8992 8992 Paul Goldschmidt 25 goldspa01 2013 ARI NL 6.881684492 6.565 1B 30 1 ARI   2011 2018 STL
9041 9041 Jason Heyward 23 heywaja01 2013 ATL NL 4.422110553 3.31 RF, CF 17 1 ATL   2010 2014 STL
9055 9055 Jordan Walden 25 waldejo01 2013 ATL NL 1.638999674 0.55 P 4 1 ATL ANA 2013 2014 STL
9140 9140 John Lackey 34 lackejo01 2013 BOS AL 5.216829423 2.65 P 15 1 BOS ANA 2010 2014 STL
9188 9188 Carlos Villanueva 29 villaca01 2013 CHC NL 3.652719606 1.275 P 8 1 CHC TOR 2013 2014 STL
9323 9323 Justin Masterson 28 masteju01 2013 CLE AL 5.320675237 3.675 P 19 1 CLE BOS 2009 2014 STL
9384 9384 Matt Belisle 33 belisma01 2013 COL NL 2.653640942 0.925 P 6 1 COL CIN 2009 2014 STL
9420 9420 Jhonny Peralta 31 peraljh01 2013 DET AL 4.082966688 3.5 SS, LF 15 1 DET CLE 2010 2013 STL
9565 9565 Peter Bourjos 26 bourjpe01 2013 LAA AL 1.822671156 0.67 CF 4 1 ANA   2010 2013 STL
9603 9603 Mark Ellis 36 ellisma01 2013 LAD NL 4.809120746 2.255 2B, 3B 13 1 LAD COL 2012 2013 STL
9647 9647 Steve Cishek 27 cishest01 2013 MIA NL 2.62904984 1.785 P 9 1 FLA   2010 2015 STL
9654 9654 Marcell Ozuna 22 ozunama01 2013 MIA NL 2.958457493 1.235 RF, CF 7 1 FLA   2013 2017 STL
9726 9726 John Axford 30 axforjo01 2013 MIL NL 1.87273226 -0.61 P 1 1 MIL   2009 2013 STL
9765 9765 Eric Fryer 27 fryerer01 2013 MIN AL 0.149943448 0.42 C 1 1 MIN PIT 2013 2015 STL
9819 9819 Ruben Tejada 23 tejadru01 2013 NYM NL 2.243312319 -0.61 SS 1 1 NYM   2010 2015 STL
9916 9916 Pat Neshek 32 neshepa01 2013 OAK AL 0.853445226 0.135 P 2 1 OAK SDP 2012 2013 STL
10039 10039 Jedd Gyorko 24 gyorkje01 2013 SDP NL 5.262703076 2.295 2B, 3B 15 1 SDP   2013 2015 STL
10285 10285 Joey Butler 27 butlejo04 2013 TEX AL 0.140890688 0.213680982 LF, RF 1 1 TEX   2013 2013 STL
10315 10315 Brett Cecil 26 cecilbr01 2013 TOR AL 1.793050608 1.115 P 6 1 TOR   2009 2016 STL
10404 10404 Paul Goldschmidt 24 goldspa01 2012 ARI NL 5.893370261 3.115 1B 17 1 ARI   2011 2018 STL
10450 10450 Jason Heyward 22 heywaja01 2012 ATL NL 6.543847487 5.405 RF, CF 27 1 ATL   2010 2014 STL
10631 10631 Miguel Socolovich 25 socolmi01 2012 CHC NL 0.152747589 0.015 P 0 2 CHC BAL 2012 2012 STL
10739 10739 Justin Masterson 27 masteju01 2012 CLE AL 5.863652396 1.65 P 13 1 CLE BOS 2009 2014 STL

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