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

3,278 rows where next_franch = "BOS"

✎ 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
100 100 Andrew Cashner 32 cashnan01 2019 BAL AL 2.823014192 2.29245283 P 10 1 BAL TEX 2018 2019 BOS
597 597 Chris Owings 27 owingch01 2019 KCR AL 1.411310623 -0.820188679 2B, 3B, CF, SS, RF, LF, P 0 1 KCR ARI 2019 2019 BOS
776 776 Jhoulys Chacin 31 chacijh01 2019 MIL NL 2.43432159 -0.224150943 P 3 1 MIL SDP 2018 2019 BOS
1677 1677 Andrew Cashner 31 cashnan01 2018 BAL AL 4.421624365 0.63 P 7 1 BAL TEX 2018 2019 BOS
2160 2160 Ian Kinsler 36 kinslia01 2018 LAA AL 3.726256983 2.365 2B 12 1 ANA DET 2018 2018 BOS
2322 2322 Jhoulys Chacin 30 chacijh01 2018 MIL NL 5.243365211 2.370368098 P 15 1 MIL SDP 2018 2019 BOS
2718 2718 Colten Brewer 25 breweco01 2018 SDP NL 0.205225687 -0.15 P 0 1 SDP   2018 2018 BOS
2780 2780 Erasmo Ramirez 28 ramirer02 2018 SEA AL 1.274902239 -0.6 P 0 1 SEA TBD 2017 2018 BOS
2792 2792 Gorkys Hernandez 30 hernago01 2018 SFG NL 4.51077772 0.36 CF, LF, RF 8 1 SFG PIT 2016 2018 BOS
2901 2901 Nathan Eovaldi 28 eovalna01 2018 TBR AL 1.503093723 0.715 P 4 1 TBD NYY 2018 2018 BOS
2925 2925 Ryan Weber 27 weberry01 2018 TBR AL 0.120224814 -0.11 P 0 1 TBD SEA 2018 2018 BOS
2975 2975 Juan Centeno 28 centeju01 2018 TEX AL 0.358723958 -0.38 C 0 1 TEX HOU 2018 2018 BOS
3012 3012 Steve Pearce 35 pearcst01 2018 TOR AL 0.82419035 0.285 1B, LF, RF 2 1 TOR BAL 2017 2018 BOS
3108 3108 J.D. Martinez 29 martijd02 2017 ARI NL 2.537623425 2.41 RF 11 2 ARI DET 2017 2017 BOS
3178 3178 Chase d'Arnaud 30 darnach01 2017 ATL NL 0.098405158 0.05 SS, LF, 2B, 3B, 1B, RF 0 1 ATL PHI 2016 2017 BOS
3554 3554 William Cuevas 26 cuevawi01 2017 DET AL 0.005775708 -0.075 P 0 1 DET BOS 2017 2017 BOS
3697 3697 Brandon Phillips 36 phillbr01 2017 LAA AL 1.006278916 -0.05 2B, 3B 1 2 ANA ATL 2017 2017 BOS
3897 3897 Justin Haley 26 haleyju01 2017 MIN AL 0.426089889 -0.07 P 0 1 MIN   2017 2017 BOS
3926 3926 Addison Reed 28 reedad01 2017 NYM NL 2.017205965 1.29 P 6 1 NYM ARI 2015 2017 BOS
4034 4034 Rajai Davis 36 davisra01 2017 OAK AL 3.117155497 0.3 CF, LF, RF 5 1 OAK CLE 2017 2017 BOS
4050 4050 Josh Smith 29 smithjo07 2017 OAK AL 0.80421132 0.08 P 1 1 OAK CIN 2017 2017 BOS
4238 4238 Erasmo Ramirez 27 ramirer02 2017 SEA AL 1.715545962 0.695 P 4 2 SEA TBD 2017 2018 BOS
4295 4295 Eduardo Nunez 30 nunezed02 2017 SFG NL 3.169616773 0.635 3B, 2B, LF, SS, RF 6 1 SFG MIN 2016 2017 BOS
4301 4301 Gorkys Hernandez 29 hernago01 2017 SFG NL 3.468637223 -0.145 LF, CF, RF 4 1 SFG PIT 2016 2018 BOS
4501 4501 Steve Pearce 34 pearcst01 2017 TOR AL 3.292659054 0.145 LF, 1B 5 1 TOR BAL 2017 2018 BOS
4604 4604 Brad Ziegler 36 zieglbr01 2016 ARI NL 1.577196923 0.925 P 5 1 ARI OAK 2011 2016 BOS
4659 4659 Chase d'Arnaud 29 darnach01 2016 ATL NL 2.585233072 0.125776398 SS, 3B, 2B, LF, CF, RF 4 1 ATL PHI 2016 2017 BOS
4845 4845 Chris Sale 27 salech01 2016 CHW AL 6.308583997 5.145 P 24 1 CHW   2010 2016 BOS
4918 4918 Steve Selsky 26 selskst01 2016 CIN NL 0.543089995 0.17 RF, LF, CF 1 1 CIN   2016 2016 BOS
4936 4936 Tony Renda 25 rendato01 2016 CIN NL 0.673833882 -0.395 2B, LF, RF, 3B 0 1 CIN   2016 2016 BOS
4979 4979 Michael Martinez 33 martimi02 2016 CLE AL 0.936704731 -0.090559006 2B, CF, LF, RF, SS, 3B 1 1 CLE PIT 2015 2016 BOS
5099 5099 Doug Fister 32 fistedo01 2016 HOU AL 4.990421584 0.325 P 8 1 HOU WSN 2016 2016 BOS
5337 5337 Tyler Thornburg 27 thornty01 2016 MIL NL 2.906899669 2.21 P 11 1 MIL   2012 2016 BOS
5340 5340 Aaron Hill 34 hillaa01 2016 MIL NL 2.944367177 1.56 3B, 2B 9 1 MIL ARI 2016 2016 BOS
5351 5351 Blaine Boyer 34 boyerbl01 2016 MIL NL 1.789695691 0.44 P 4 1 MIL MIN 2016 2016 BOS
5394 5394 Fernando Abad 30 abadfe01 2016 MIN AL 1.210686842 0.765 P 4 1 MIN OAK 2016 2016 BOS
5438 5438 Addison Reed 27 reedad01 2016 NYM NL 2.852552808 2.56 P 11 1 NYM ARI 2015 2017 BOS
5686 5686 Drew Pomeranz 27 pomerdr01 2016 SDP NL 2.911490391 2.88 P 13 1 SDP OAK 2016 2016 BOS
5808 5808 Eduardo Nunez 29 nunezed02 2016 SFG NL 1.956602814 1.05 SS, 3B, 2B 6 2 SFG MIN 2016 2017 BOS
5823 5823 Gorkys Hernandez 28 hernago01 2016 SFG NL 0.560433972 0.385 CF, RF, LF 2 1 SFG PIT 2016 2018 BOS
5940 5940 Mitch Moreland 30 morelmi01 2016 TEX AL 4.808636888 0.34 1B 10 1 TEX   2010 2016 BOS
5957 5957 Bryan Holaday 28 holadbr01 2016 TEX AL 0.898631943 0.185 C, 3B, LF, P 2 1 TEX DET 2016 2016 BOS
6083 6083 Brad Ziegler 35 zieglbr01 2015 ARI NL 2.596489287 1.44 P 8 1 ARI OAK 2011 2016 BOS
6218 6218 Alejandro De Aza 31 deazaal01 2015 BAL AL 1.085380117 -0.225 LF, RF, CF 1 1 BAL CHW 2014 2015 BOS
6333 6333 Chris Sale 26 salech01 2015 CHW AL 5.806013174 4.495 P 22 1 CHW   2010 2016 BOS
6415 6415 Ryan LaMarre 26 lamarry01 2015 CIN NL 0.257381806 -0.415 CF, LF, RF 0 1 CIN   2015 2015 BOS
6461 6461 Michael Martinez 32 martimi02 2015 CLE AL 0.305012325 -0.065403727 LF, CF, 3B, RF 0 1 CLE PIT 2015 2016 BOS
6486 6486 Kyle Kendrick 30 kendrky01 2015 COL NL 4.033728488 -0.505 P 4 1 COL PHI 2015 2015 BOS
6863 6863 Luis Jimenez 27 jimenlu02 2015 MIL NL 0.162493434 -0.23 3B, 2B 0 1 MIL ANA 2015 2015 BOS
6864 6864 Tyler Thornburg 26 thornty01 2015 MIL NL 0.940884538 -0.43 P 0 1 MIL   2012 2016 BOS
6939 6939 Addison Reed 26 reedad01 2015 NYM NL 0.550175918 0.48 P 2 2 NYM ARI 2015 2017 BOS
6976 6976 Chris Young 31 youngch04 2015 NYY AL 3.30791413 0.875 RF, LF, CF 7 1 NYY NYM 2014 2015 BOS
7054 7054 Ryan Cook 28 cookry01 2015 OAK AL 0.154762648 -0.165 P 0 1 OAK ARI 2012 2015 BOS
7101 7101 Sean O'Sullivan 27 osullse01 2015 PHI NL 2.044160361 -0.645 P 1 1 PHI SDP 2014 2015 BOS
7175 7175 Craig Kimbrel 27 kimbrcr01 2015 SDP NL 2.687794314 1.365 P 8 1 SDP ATL 2015 2015 BOS
7219 7219 Carson Smith 25 smithca02 2015 SEA AL 2.626530591 2.175 P 10 1 SEA   2014 2015 BOS
7223 7223 Roenis Elias 26 eliasro01 2015 SEA AL 3.022658378 0.835 P 7 1 SEA   2014 2015 BOS
7302 7302 Jean Machi 33 machije01 2015 SFG NL 0.852824057 -0.27 P 0 1 SFG   2012 2015 BOS
7411 7411 Mitch Moreland 29 morelmi01 2015 TEX AL 4.845093268 2.225 1B 14 1 TEX   2010 2016 BOS
7427 7427 Carlos Peguero 28 pegueca01 2015 TEX AL 0.79026764 0.56 LF, RF, CF 3 1 TEX KCR 2015 2015 BOS
7447 7447 Roman Mendez 24 mendero01 2015 TEX AL 0.313013853 -0.035 P 0 1 TEX   2014 2015 BOS
7472 7472 David Price 29 priceda01 2015 TOR AL 2.065750662 2.525 P 10 2 TOR DET 2015 2015 BOS
7564 7564 Wade Miley 27 mileywa01 2014 ARI NL 5.600323944 1.03 P 11 1 ARI   2011 2014 BOS
7577 7577 Brad Ziegler 34 zieglbr01 2014 ARI NL 2.591218342 0.12 P 4 1 ARI OAK 2011 2016 BOS
7627 7627 Anthony Varvaro 29 varvaan01 2014 ATL NL 1.650422828 0.655 P 4 1 ATL SEA 2011 2014 BOS
7676 7676 Alejandro De Aza 30 deazaal01 2014 BAL AL 0.845121153 0.51 LF, CF, RF 3 2 BAL CHW 2014 2015 BOS
7682 7682 Jemile Weeks 27 weeksje01 2014 BAL AL 0.123444663 0.085 2B, SS 0 1 BAL OAK 2014 2014 BOS
7798 7798 Chris Sale 25 salech01 2014 CHW AL 4.797307175 5.54 P 23 1 CHW   2010 2016 BOS
7953 7953 Josh Rutledge 25 rutlejo01 2014 COL NL 3.401234568 -0.545 SS, 2B, 3B 3 1 COL   2012 2014 BOS
7986 7986 Rick Porcello 25 porceri01 2014 DET AL 5.943832877 3.305 P 18 1 DET   2009 2014 BOS
8184 8184 Hanley Ramirez 30 ramirha01 2014 LAD NL 5.058943782 3.64 SS 17 1 LAD FLA 2012 2014 BOS
8302 8302 Tyler Thornburg 25 thornty01 2014 MIL NL 0.907814677 0.025 P 1 1 MIL   2012 2016 BOS
8311 8311 Jeff Bianchi 27 biancje01 2014 MIL NL 0.75140056 -0.625 SS, 3B, 2B 0 1 MIL   2012 2014 BOS
8424 8424 Kelly Johnson 32 johnske05 2014 NYY AL 2.173683342 0.76 3B, 1B, 2B, LF, RF 6 1 NYY TBD 2014 2014 BOS
8428 8428 Chris Young 30 youngch04 2014 NYY AL 0.756480106 0.945 LF, CF, RF 4 2 NYY NYM 2014 2015 BOS
8440 8440 Rich Hill 34 hillri01 2014 NYY AL 0.12388501 0.135 P 1 2 NYY ANA 2014 2014 BOS
8469 8469 Yoenis Cespedes 28 cespeyo01 2014 OAK AL 4.029591509 2.63 LF, CF 13 1 OAK   2012 2014 BOS
8488 8488 Ryan Cook 27 cookry01 2014 OAK AL 1.452606763 0.36 P 3 1 OAK ARI 2012 2015 BOS
8545 8545 Sean O'Sullivan 26 osullse01 2014 PHI NL 0.296158842 -0.16 P 0 1 PHI SDP 2014 2015 BOS
8662 8662 Roenis Elias 25 eliasro01 2014 SEA AL 4.579004551 0.94 P 10 1 SEA   2014 2015 BOS
8684 8684 Carson Smith 24 smithca02 2014 SEA AL 0.225666223 0.31 P 1 1 SEA   2014 2015 BOS
8701 8701 Pablo Sandoval 27 sandopa01 2014 SFG NL 6.450061007 3.305 3B 20 1 SFG   2008 2014 BOS
8712 8712 Jean Machi 32 machije01 2014 SFG NL 2.306206917 0.85 P 6 1 SFG   2012 2015 BOS
8760 8760 Allen Craig 29 craigal01 2014 STL NL 4.024407252 -0.615 RF, 1B, LF 5 1 STL   2010 2014 BOS
8767 8767 Joe Kelly 26 kellyjo05 2014 STL NL 0.933306641 0.175 P 2 1 STL   2012 2014 BOS
8787 8787 Justin Masterson 29 masteju01 2014 STL NL 0.760290568 -0.535 P 0 2 STL CLE 2014 2014 BOS
8802 8802 Ryan Hanigan 33 hanigry01 2014 TBR AL 2.46828479 1.6 C 8 1 TBD CIN 2014 2014 BOS
8853 8853 Roman Mendez 23 mendero01 2014 TEX AL 1.096050631 0.565 P 3 1 TEX   2014 2015 BOS
8873 8873 Mitch Moreland 28 morelmi01 2014 TEX AL 1.777481679 -0.33 1B, LF, P 1 1 TEX   2010 2016 BOS
8887 8887 Alexi Ogando 30 ogandal01 2014 TEX AL 0.753457925 -0.285 P 0 1 TEX   2010 2014 BOS
8894 8894 Robbie Ross 25 rossro01 2014 TEX AL 2.228339 -0.93 P 0 1 TEX   2012 2014 BOS
8981 8981 Sandy Leon 25 leonsa01 2014 WSN NL 0.693898479 -0.06 C 1 1 WSN   2012 2014 BOS
8997 8997 Wade Miley 26 mileywa01 2013 ARI NL 5.334844631 1.445 P 13 1 ARI   2011 2014 BOS
9003 9003 Brad Ziegler 33 zieglbr01 2013 ARI NL 2.616642719 1.07 P 7 1 ARI OAK 2011 2016 BOS
9056 9056 Anthony Varvaro 28 varvaan01 2013 ATL NL 1.781370197 0.47 P 4 1 ATL SEA 2011 2014 BOS
9236 9236 Chris Sale 24 salech01 2013 CHW AL 5.710078817 5.665 P 24 1 CHW   2010 2016 BOS
9251 9251 Jake Peavy 32 peavyja01 2013 CHW AL 2.131289138 0.76 P 5 1 CHW SDP 2009 2013 BOS
9266 9266 Matt Thornton 36 thornma01 2013 CHW AL 1.079248542 0.055 P 1 1 CHW SEA 2006 2013 BOS
9390 9390 Jonathan Herrera 28 herrejo03 2013 COL NL 2.141875644 0.265 SS, 2B, 3B, LF 3 1 COL   2008 2013 BOS
9392 9392 Josh Rutledge 24 rutlejo01 2013 COL NL 3.128134662 -0.385 2B, SS 3 1 COL   2012 2014 BOS

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