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,011 rows where next_franch = "NYM"

✎ 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
232 232 Brad Brach 33 brachbr01 2019 CHC NL 1.189527491 -0.020377358 P 1 1 CHC ATL 2019 2019 NYM
782 782 Donnie Hart 28 hartdo01 2019 MIL NL 0.133113963 0.13245283 P 1 1 MIL BAL 2019 2019 NYM
1256 1256 Joe Panik 28 panikjo01 2019 SFG NL 3.900849367 -0.382075472 2B 6 1 SFG   2014 2019 NYM
1279 1279 Aaron Altherr 28 altheaa01 2019 SFG NL 0.010053735 -0.015283019 LF, CF, RF, P 0 2 SFG PHI 2019 2019 NYM
1387 1387 Wilmer Font 29 fontwi01 2019 TBR AL 0.335577442 0.025471698 P 1 1 TBD OAK 2018 2019 NYM
1455 1455 Marcus Stroman 28 stromma01 2019 TOR AL 3.655409887 3.183962264 P 14 1 TOR   2014 2019 NYM
1660 1660 Rene Rivera 34 riverre01 2018 ATL NL 0.03916934 -0.1 C, 1B 0 2 ATL ANA 2018 2018 NYM
1667 1667 Jose Bautista 37 bautijo02 2018 ATL NL 0.391693399 -0.225 RF, LF, 3B, 1B, 2B 0 1 ATL TOR 2018 2018 NYM
1793 1793 Justin Wilson 30 wilsoju10 2018 CHC NL 1.836299812 0.660920245 P 5 1 CHC DET 2017 2018 NYM
1841 1841 Hector Santiago 30 santihe01 2018 CHW AL 2.630049113 0.26 P 4 1 CHW MIN 2018 2018 NYM
1852 1852 Chris Beck 27 beckch02 2018 CHW AL 0.426982059 0.01 P 1 1 CHW   2015 2018 NYM
1910 1910 Devin Mesoraco 30 mesorde01 2018 CIN NL 0.442898354 -0.13 C, 1B 0 1 CIN   2011 2018 NYM
1957 1957 Rajai Davis 37 davisra01 2018 CLE AL 1.996812241 -0.315 CF, LF, RF 1 1 CLE BOS 2018 2018 NYM
2008 2008 Brooks Pounders 27 poundbr01 2018 COL NL 0.266067873 -0.089447853 P 0 1 COL ANA 2018 2018 NYM
2104 2104 J.D. Davis 25 davisjd01 2018 HOU AL 1.070740075 -0.635 3B, 1B, LF, P 0 1 HOU   2017 2018 NYM
2335 2335 Keon Broxton 28 broxtke01 2018 MIL NL 0.872696534 1.361595092 CF, RF 5 1 MIL PIT 2016 2018 NYM
2520 2520 Adeiny Hechavarria 29 hechaad01 2018 NYY AL 0.343414946 -0.035 SS, 3B 0 3 NYY PIT 2018 2018 NYM
2531 2531 Jed Lowrie 34 lowrije01 2018 OAK AL 6.326596086 4.9 2B, 3B 24 1 OAK HOU 2016 2018 NYM
2553 2553 Jeurys Familia 28 familje01 2018 OAK AL 1.06076816 0.515 P 3 2 OAK NYM 2018 2018 NYM
2600 2600 Wilson Ramos 30 ramoswi01 2018 PHI NL 1.003769705 0.75 C 4 2 PHI TBD 2018 2018 NYM
2621 2621 Luis Avilan 28 avilalu01 2018 PHI NL 0.194504492 0.06 P 0 2 PHI CHW 2018 2018 NYM
2719 2719 Buddy Baumann 30 baumabu01 2018 SDP NL 0.009917414 -0.215 P 0 1 SDP   2016 2018 NYM
2725 2725 Walker Lockett 24 lockewa01 2018 SDP NL 0.372276805 -0.475 P 0 1 SDP   2018 2018 NYM
2733 2733 Edwin Diaz 24 diazed04 2018 SEA AL 3.256059531 3.325 P 15 1 SEA   2016 2018 NYM
2734 2734 Robinson Cano 35 canoro01 2018 SEA AL 3.327947238 3.07 2B, 1B, 3B 14 1 SEA NYY 2014 2018 NYM
2797 2797 Joe Panik 27 panikjo01 2018 SFG NL 3.920675979 0.02 2B, 1B 6 1 SFG   2014 2019 NYM
2828 2828 Austin Jackson 31 jacksau01 2018 SFG NL 1.650284532 -1.1 CF, LF 0 1 SFG CLE 2018 2018 NYM
2898 2898 Carlos Gomez 32 gomezca01 2018 TBR AL 3.83346833 -0.05 RF, CF, 2B, P 5 1 TBD TEX 2018 2018 NYM
2904 2904 Wilmer Font 28 fontwi01 2018 TBR AL 0.65074516 0.8 P 3 3 TBD OAK 2018 2019 NYM
2994 2994 Marcus Stroman 27 stromma01 2018 TOR AL 2.92333196 0.815 P 7 1 TOR   2014 2019 NYM
3138 3138 Jack Reinheimer 24 reinhja01 2017 ARI NL 0.049370106 -0.105 SS 0 1 ARI   2017 2017 NYM
3224 3224 Ruben Tejada 27 tejadru01 2017 BAL AL 1.174779484 -0.18 SS, 3B, 2B 1 1 BAL SFG 2017 2017 NYM
3319 3319 Justin Wilson 29 wilsoju10 2017 CHC NL 0.497812677 0.035 P 1 2 CHC DET 2017 2018 NYM
3387 3387 Chris Beck 26 beckch02 2017 CHW AL 1.633605358 -0.97 P 0 1 CHW   2015 2018 NYM
3410 3410 Devin Mesoraco 29 mesorde01 2017 CIN NL 1.626168224 -0.065 C 2 1 CIN   2011 2018 NYM
3463 3463 Jay Bruce 30 bruceja01 2017 CLE AL 1.577659746 0.33 RF, 1B 3 2 CLE NYM 2017 2017 NYM
3551 3551 Matt den Dekker 29 dendema01 2017 DET AL 0.075718016 0.015 RF, LF 0 1 DET WSN 2017 2017 NYM
3597 3597 J.D. Davis 24 davisjd01 2017 HOU AL 0.631848766 0.055 3B, 1B, P 1 1 HOU   2017 2018 NYM
3617 3617 Jason Vargas 34 vargaja01 2017 KCR AL 5.016764 2.835 P 16 1 KCR ANA 2014 2017 NYM
3749 3749 Adrian Gonzalez 35 gonzaad01 2017 LAD NL 2.492496589 -1.05 1B 1 1 LAD BOS 2012 2017 NYM
3785 3785 AJ Ramos 30 ramosaj01 2017 MIA NL 1.457749496 0.28 P 3 1 FLA   2012 2017 NYM
3824 3824 Keon Broxton 27 broxtke01 2017 MIL NL 4.614882282 0.585 CF 9 1 MIL PIT 2016 2018 NYM
3833 3833 Anthony Swarzak 31 swarzan01 2017 MIL NL 1.111029045 0.685 P 4 2 MIL CHW 2017 2017 NYM
3841 3841 Tommy Milone 30 milonto01 2017 MIL NL 0.50861615 -0.04 P 1 1 MIL MIN 2017 2017 NYM
3979 3979 Todd Frazier 31 frazito01 2017 NYY AL 2.208563754 1.395 3B, 1B 7 2 NYY CHW 2017 2017 NYM
4017 4017 Jed Lowrie 33 lowrije01 2017 OAK AL 6.129772243 3.87 2B, 3B 20 1 OAK HOU 2016 2018 NYM
4055 4055 Bobby Wahl 25 wahlbo01 2017 OAK AL 0.176160575 0.07 P 0 1 OAK   2017 2017 NYM
4104 4104 Ty Kelly 28 kellyty01 2017 PHI NL 1.035181054 -0.175 2B, LF, 3B, RF, CF 1 2 PHI NYM 2017 2017 NYM
4197 4197 Buddy Baumann 29 baumabu01 2017 SDP NL 0.593853235 0.16 P 1 1 SDP   2016 2018 NYM
4222 4222 Robinson Cano 34 canoro01 2017 SEA AL 6.122169734 3.31 2B 18 1 SEA NYY 2014 2018 NYM
4231 4231 Edwin Diaz 23 diazed04 2017 SEA AL 2.988370386 0.84 P 7 1 SEA   2016 2018 NYM
4288 4288 Joe Panik 26 panikjo01 2017 SFG NL 5.7112906 1.575 2B 12 1 SFG   2014 2019 NYM
4319 4319 Neil Ramirez 28 ramirne01 2017 SFG NL 0.294184729 -0.34 P 0 1 SFG MIN 2017 2017 NYM
4484 4484 Marcus Stroman 26 stromma01 2017 TOR AL 5.349894492 4.54 P 21 1 TOR   2014 2019 NYM
4509 4509 Nori Aoki 35 aokino01 2017 TOR AL 0.321696574 0.355 LF, RF, CF, P 2 2 TOR HOU 2017 2017 NYM
4590 4590 Jose Lobaton 32 lobatjo01 2017 WSN NL 1.566495726 -0.86 C 0 1 WSN TBD 2014 2017 NYM
4697 4697 Kelly Johnson 34 johnske05 2016 ATL NL 1.302483838 -0.669130435 2B, 3B, LF, 1B, SS 0 1 ATL NYM 2016 2016 NYM
4887 4887 Chris Beck 25 beckch02 2016 CHW AL 0.701326625 -0.315 P 0 1 CHW   2015 2018 NYM
4905 4905 Jay Bruce 29 bruceja01 2016 CIN NL 4.043003295 0.565 RF, CF 8 1 CIN   2008 2016 NYM
4931 4931 Devin Mesoraco 28 mesorde01 2016 CIN NL 0.553147217 -0.32 C 0 1 CIN   2011 2018 NYM
5154 5154 Jason Vargas 33 vargaja01 2016 KCR AL 0.336205759 0.445 P 2 1 KCR ANA 2014 2017 NYM
5194 5194 Fernando Salas 31 salasfe01 2016 LAA AL 2.068227782 -0.085 P 3 1 ANA STL 2014 2016 NYM
5230 5230 Adrian Gonzalez 34 gonzaad01 2016 LAD NL 6.280191584 1.575 1B 14 1 LAD BOS 2012 2017 NYM
5292 5292 AJ Ramos 29 ramosaj01 2016 MIA NL 2.430557246 1.353354037 P 7 1 FLA   2012 2017 NYM
5339 5339 Keon Broxton 26 broxtke01 2016 MIL NL 2.460361613 1.875 CF 9 1 MIL PIT 2016 2018 NYM
5412 5412 Ryan O'Rourke 28 orourry01 2016 MIN AL 0.701606906 0.13 P 1 1 MIN   2015 2016 NYM
5556 5556 Jed Lowrie 32 lowrije01 2016 OAK AL 3.568189396 -0.63 2B, SS 3 1 OAK HOU 2016 2018 NYM
5648 5648 Jon Niese 29 niesejo01 2016 PIT NL 3.196855505 0.105 P 5 1 PIT NYM 2016 2016 NYM
5717 5717 Buddy Baumann 28 baumabu01 2016 SDP NL 0.321423924 0.2 P 1 1 SDP   2016 2018 NYM
5742 5742 Robinson Cano 33 canoro01 2016 SEA AL 6.686552725 6.815 2B 30 1 SEA NYY 2014 2018 NYM
5751 5751 Edwin Diaz 22 diazed04 2016 SEA AL 2.049282104 1.655 P 8 1 SEA   2016 2018 NYM
5802 5802 Joe Panik 25 panikjo01 2016 SFG NL 5.171724021 1.56 2B 12 1 SFG   2014 2019 NYM
5966 5966 Justin Ruggiano 34 ruggiju01 2016 TEX AL 0.038239657 0.06 CF, LF, RF 0 1 TEX LAD 2016 2016 NYM
5990 5990 Marcus Stroman 25 stromma01 2016 TOR AL 5.581285822 2.38 P 15 1 TOR   2014 2019 NYM
6049 6049 Jose Lobaton 31 lobatjo01 2016 WSN NL 1.13393929 0.48 C 3 1 WSN TBD 2014 2017 NYM
6096 6096 Addison Reed 26 reedad01 2015 ARI NL 1.440622775 0.305 P 3 1 ARI CHW 2014 2015 NYM
6136 6136 Juan Uribe 36 uribeju01 2015 ATL NL 1.69870221 0.945 3B, 2B 5 2 ATL LAD 2015 2015 NYM
6143 6143 Kelly Johnson 33 johnske05 2015 ATL NL 2.003858295 0.03 2B, LF, 1B, 3B, RF, SS 3 1 ATL BAL 2015 2015 NYM
6181 6181 Eric Young Jr. 30 younger03 2015 ATL NL 0.864608909 -0.475 CF, LF, RF 0 1 ATL NYM 2015 2015 NYM
6362 6362 Chris Beck 24 beckch02 2015 CHW AL 0.172331423 -0.005 P 0 1 CHW   2015 2018 NYM
6380 6380 Jay Bruce 28 bruceja01 2015 CIN NL 6.424645844 0.495 RF 9 1 CIN   2008 2016 NYM
6410 6410 Devin Mesoraco 27 mesorde01 2015 CIN NL 0.504864311 -0.24 C 0 1 CIN   2011 2018 NYM
6503 6503 Jose Reyes 32 reyesjo01 2015 COL NL 2.098086957 -0.26 SS 2 2 COL TOR 2015 2015 NYM
6527 6527 Yoenis Cespedes 29 cespeyo01 2015 DET AL 4.038812785 3.677701863 LF, CF 17 1 DET BOS 2015 2015 NYM
6639 6639 Jason Vargas 32 vargaja01 2015 KCR AL 1.208985995 0.405 P 3 1 KCR ANA 2014 2017 NYM
6682 6682 Fernando Salas 30 salasfe01 2015 LAA AL 2.030499935 0.145 P 4 1 ANA STL 2014 2016 NYM
6699 6699 Adam Wilk 27 wilkad01 2015 LAA AL 0.03024563 -0.045 P 0 1 ANA DET 2015 2015 NYM
6714 6714 Adrian Gonzalez 33 gonzaad01 2015 LAD NL 6.493818562 3.54 1B 19 1 LAD BOS 2012 2017 NYM
6774 6774 AJ Ramos 28 ramosaj01 2015 MIA NL 2.847256636 1.64 P 9 1 FLA   2012 2017 NYM
6896 6896 Ryan O'Rourke 27 orourry01 2015 MIN AL 0.522424979 -0.105 P 1 1 MIN   2015 2016 NYM
6908 6908 Tim Stauffer 33 staufti01 2015 MIN AL 0.360651335 -0.395 P 0 1 MIN SDP 2015 2015 NYM
7035 7035 Tyler Clippard 30 clippty01 2015 OAK AL 1.527247047 0.605 P 4 1 OAK WSN 2015 2015 NYM
7057 7057 Eric O'Flaherty 30 oflaher01 2015 OAK AL 0.635999827 -0.315 P 0 1 OAK ATL 2014 2015 NYM
7124 7124 Neil Walker 29 walkene01 2015 PIT NL 5.882926829 2.495 2B 17 1 PIT   2009 2015 NYM
7135 7135 Antonio Bastardo 29 bastaan01 2015 PIT NL 1.609281655 0.735 P 5 1 PIT PHI 2015 2015 NYM
7213 7213 Robinson Cano 32 canoro01 2015 SEA AL 6.402227317 3.075 2B 18 1 SEA NYY 2014 2018 NYM
7266 7266 Joe Panik 24 panikjo01 2015 SFG NL 4.320744956 3.535 2B 16 1 SFG   2014 2019 NYM
7291 7291 Alejandro De Aza 31 deazaal01 2015 SFG NL 0.750129333 -0.08 LF, RF, CF 1 3 SFG BOS 2015 2015 NYM
7360 7360 Asdrubal Cabrera 29 cabreas01 2015 TBR AL 5.281441084 2.19 SS 13 1 TBD WSN 2015 2015 NYM
7385 7385 James Loney 31 loneyja01 2015 TBR AL 3.719054702 -0.81 1B 2 1 TBD BOS 2013 2015 NYM

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