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,586 rows where next_franch = "WSN"

✎ 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
94 94 Jonny Venters 34 ventejo01 2019 ATL NL 0.126369028 -0.636792453 P 0 1 ATL TBD 2018 2019 WSN
1001 1001 Fernando Rodney 42 rodnefe01 2019 OAK AL 0.347008812 -0.331132075 P 0 1 OAK MIN 2018 2019 WSN
1197 1197 Roenis Elias 30 eliasro01 2019 SEA AL 1.89856234 0.056037736 P 3 1 SEA BOS 2018 2019 WSN
1223 1223 Hunter Strickland 30 strichu01 2019 SEA AL 0.147498076 -0.13245283 P 0 1 SEA SFG 2019 2019 WSN
1268 1268 Gerardo Parra 32 parrage01 2019 SFG NL 0.975212342 -0.045849057 RF, LF, 1B, CF, 2B, 3B, P 2 1 SFG COL 2019 2019 WSN
1415 1415 Asdrubal Cabrera 33 cabreas01 2019 TEX AL 3.522112211 0.468679245 3B, 2B, 1B 7 1 TEX PHI 2019 2019 WSN
1470 1470 Daniel Hudson 32 hudsoda01 2019 TOR AL 1.72353794 0.779433962 P 5 1 TOR LAD 2019 2019 WSN
1487 1487 Javy Guerra 33 guerrja01 2019 TOR AL 0.412695766 0.193584906 P 1 1 TOR FLA 2019 2019 WSN
1566 1566 Patrick Corbin 28 corbipa01 2018 ARI NL 5.418314233 5.475 P 24 1 ARI   2012 2018 WSN
1622 1622 Anibal Sanchez 34 sanchan01 2018 ATL NL 3.737772777 2.32 P 12 1 ATL DET 2018 2018 WSN
1625 1625 Kurt Suzuki 34 suzukku01 2018 ATL NL 3.799425967 1.555 C 10 1 ATL MIN 2017 2018 WSN
1644 1644 Jonny Venters 33 ventejo01 2018 ATL NL 0.736466897 0.14 P 1 2 ATL TBD 2018 2019 WSN
1925 1925 Tanner Rainey 25 raineta01 2018 CIN NL 0.159309565 -0.75 P 0 1 CIN   2018 2018 WSN
1933 1933 Yan Gomes 30 gomesya01 2018 CLE AL 4.021357985 2.485 C 12 1 CLE TOR 2013 2018 WSN
2085 2085 Tony Sipp 34 sippto01 2018 HOU AL 1.165055035 1.045 P 5 1 HOU ARI 2014 2018 WSN
2122 2122 Kelvin Herrera 28 herreke01 2018 KCR AL 1.067165836 1.07 P 4 1 KCR   2011 2018 WSN
2244 2244 Brian Dozier 31 doziebr01 2018 LAD NL 1.636514523 -0.104355828 2B 2 2 LAD MIN 2018 2018 WSN
2291 2291 Kyle Barraclough 28 barraky01 2018 MIA NL 1.882768602 -0.407515528 P 2 1 FLA   2015 2018 WSN
2341 2341 Dan Jennings 31 jennida01 2018 MIL NL 1.946381713 0.397546012 P 4 1 MIL TBD 2018 2018 WSN
2564 2564 Fernando Rodney 41 rodnefe01 2018 OAK AL 0.702684407 0.085 P 1 2 OAK MIN 2018 2019 WSN
2743 2743 Roenis Elias 29 eliasro01 2018 SEA AL 1.090567096 1.005 P 5 1 SEA BOS 2018 2019 WSN
2870 2870 Matt Adams 29 adamsma01 2018 STL NL 0.592542142 -0.29 1B, LF, RF 0 2 STL WSN 2018 2018 WSN
2875 2875 Greg Holland 32 hollagr01 2018 STL NL 0.659093102 -0.725 P 0 1 STL COL 2018 2018 WSN
3102 3102 Patrick Corbin 27 corbipa01 2017 ARI NL 5.324739418 2.88 P 16 1 ARI   2012 2018 WSN
3148 3148 Kurt Suzuki 33 suzukku01 2017 ATL NL 3.040719376 2.155 C 11 1 ATL MIN 2017 2018 WSN
3157 3157 Matt Adams 28 adamsma01 2017 ATL NL 3.089921955 0.87 1B, LF 7 2 ATL STL 2017 2017 WSN
3226 3226 Jeremy Hellickson 30 hellije01 2017 BAL AL 1.492325476 -0.47 P 1 2 BAL PHI 2017 2017 WSN
3234 3234 Edwin Jackson 33 jacksed01 2017 BAL AL 0.106777578 -0.215 P 0 1 BAL SDP 2017 2017 WSN
3449 3449 Yan Gomes 29 gomesya01 2017 CLE AL 3.575406406 1.55 C 9 1 CLE TOR 2013 2018 WSN
3484 3484 Mark Reynolds 33 reynoma01 2017 COL NL 5.865279673 0.835 1B, LF 12 1 COL STL 2016 2017 WSN
3612 3612 Tony Sipp 33 sippto01 2017 HOU AL 0.888544581 -0.26 P 0 1 HOU ARI 2014 2018 WSN
3631 3631 Kelvin Herrera 27 herreke01 2017 KCR AL 2.285772523 0.205 P 4 1 KCR   2011 2018 WSN
3780 3780 Kyle Barraclough 27 barraky01 2017 MIA NL 2.224212924 0.695 P 5 1 FLA   2015 2018 WSN
3838 3838 Carlos Torres 34 torreca01 2017 MIL NL 2.14396753 -0.005 P 3 1 MIL NYM 2016 2017 WSN
3859 3859 Michael Blazek 28 blazemi01 2017 MIL NL 0.220082294 -0.34 P 0 1 MIL STL 2013 2017 WSN
3878 3878 Brandon Kintzler 32 kintzbr01 2017 MIN AL 1.864193844 0.875 P 5 1 MIN MIL 2016 2017 WSN
3949 3949 Matt Reynolds 26 reynoma03 2017 NYM NL 1.289991446 -0.27 3B, SS, 2B, LF, 1B, RF 1 1 NYM   2016 2017 WSN
3962 3962 Tommy Milone 30 milonto01 2017 NYM NL 0.695003736 -0.6 P 0 2 NYM MIL 2017 2017 WSN
4028 4028 Ryan Madson 36 madsory01 2017 OAK AL 1.397846926 1.245 P 6 1 OAK KCR 2016 2017 WSN
4041 4041 Sean Doolittle 30 doolise01 2017 OAK AL 0.80717286 0.555 P 3 1 OAK   2012 2017 WSN
4085 4085 Howie Kendrick 33 kendrho01 2017 PHI NL 1.552771581 1.17 LF, 2B, 1B, RF 5 1 PHI LAD 2017 2017 WSN
4346 4346 Trevor Rosenthal 27 rosentr01 2017 STL NL 1.857840116 1.1 P 6 1 STL   2012 2017 WSN
4539 4539 Miguel Montero 33 montemi01 2017 TOR AL 0.955628059 -0.555 C, 1B, P 0 2 TOR CHC 2017 2017 WSN
4600 4600 Patrick Corbin 26 corbipa01 2016 ARI NL 4.467398694 0.52 P 8 1 ARI   2012 2018 WSN
4711 4711 Matt Wieters 30 wietema01 2016 BAL AL 4.440191388 1.495 C 11 1 BAL   2009 2016 WSN
4844 4844 Adam Eaton 27 eatonad02 2016 CHW AL 6.702897365 5.98 RF, CF, LF 27 1 CHW ARI 2014 2016 WSN
4862 4862 Mat Latos 28 latosma01 2016 CHW AL 1.670264726 0.165 P 3 1 CHW ANA 2016 2016 WSN
4890 4890 Jacob Turner 25 turneja01 2016 CHW AL 0.664612088 -0.835 P 0 1 CHW CHC 2016 2016 WSN
4891 4891 Matt Albers 33 alberma01 2016 CHW AL 1.755487853 -1.245 P 0 1 CHW HOU 2015 2016 WSN
4974 4974 Yan Gomes 28 gomesya01 2016 CLE AL 2.497879282 -0.654037267 C 2 1 CLE TOR 2013 2018 WSN
5005 5005 Mark Reynolds 32 reynoma01 2016 COL NL 4.335989151 0.895 1B, 2B 8 1 COL STL 2016 2017 WSN
5016 5016 Ryan Raburn 35 raburry01 2016 COL NL 2.517036786 -0.44 LF, 1B, RF 2 1 COL CLE 2016 2016 WSN
5019 5019 Justin Miller 29 milleju02 2016 COL NL 1.036850952 0.03 P 1 1 COL DET 2015 2016 WSN
5125 5125 Tony Sipp 32 sippto01 2016 HOU AL 1.176263191 -0.595 P 0 1 HOU ARI 2014 2018 WSN
5138 5138 Kelvin Herrera 26 herreke01 2016 KCR AL 2.772349091 1.97 P 10 1 KCR   2011 2018 WSN
5234 5234 Joe Blanton 35 blantjo01 2016 LAD NL 2.520106986 1.295 P 7 1 LAD PIT 2016 2016 WSN
5287 5287 Kyle Barraclough 26 barraky01 2016 MIA NL 2.526182535 1.786024845 P 9 1 FLA   2015 2018 WSN
5342 5342 Carlos Torres 33 torreca01 2016 MIL NL 2.778346892 1.415 P 8 1 MIL NYM 2016 2017 WSN
5379 5379 Michael Blazek 27 blazemi01 2016 MIL NL 1.313849553 -0.76 P 0 1 MIL STL 2013 2017 WSN
5393 5393 Brandon Kintzler 31 kintzbr01 2016 MIN AL 1.852745176 0.835 P 5 1 MIN MIL 2016 2017 WSN
5456 5456 Alejandro De Aza 32 deazaal01 2016 NYM NL 2.673687845 -0.34 CF, LF, RF 3 1 NYM SFG 2016 2016 WSN
5459 5459 Matt Reynolds 25 reynoma03 2016 NYM NL 0.961325967 0.195 SS, 3B, 2B, LF 2 1 NYM   2016 2017 WSN
5539 5539 Ryan Madson 35 madsory01 2016 OAK AL 2.819856408 0.9 P 7 1 OAK KCR 2016 2017 WSN
5546 5546 Sean Doolittle 29 doolise01 2016 OAK AL 1.370122938 0.76 P 4 1 OAK   2012 2017 WSN
5549 5549 Marc Rzepczynski 30 rzepcma01 2016 OAK AL 1.148240681 0.565 P 3 1 OAK SDP 2016 2016 WSN
5644 5644 Mark Melancon 31 melanma01 2016 PIT NL 1.591686492 1.275 P 6 1 PIT BOS 2013 2016 WSN
5762 5762 Adam Lind 32 lindad01 2016 SEA AL 4.021283457 -0.385 1B 5 1 SEA MIL 2016 2016 WSN
5838 5838 Grant Green 28 greengr01 2016 SFG NL 0.491608747 -0.27 2B 0 1 SFG ANA 2016 2016 WSN
5869 5869 Trevor Rosenthal 26 rosentr01 2016 STL NL 1.439753381 0.07 P 2 1 STL   2012 2017 WSN
5924 5924 Enny Romero 25 romeren01 2016 TBR AL 1.215915359 -0.38 P 0 1 TBD   2013 2016 WSN
6082 6082 Patrick Corbin 25 corbipa01 2015 ARI NL 2.307716239 1.555 P 8 1 ARI   2012 2018 WSN
6199 6199 Matt Wieters 29 wietema01 2015 BAL AL 2.73283208 0.555 C, 1B 5 1 BAL   2009 2016 WSN
6334 6334 Adam Eaton 26 eatonad02 2015 CHW AL 6.608566231 3.93 CF 22 1 CHW ARI 2014 2016 WSN
6350 6350 Matt Albers 32 alberma01 2015 CHW AL 1.139302183 0.86 P 4 1 CHW HOU 2015 2016 WSN
6436 6436 Yan Gomes 27 gomesya01 2015 CLE AL 3.707806081 0.669130435 C 7 1 CLE TOR 2013 2018 WSN
6487 6487 Justin Miller 28 milleju02 2015 COL NL 1.06590779 0.66 P 3 1 COL DET 2015 2016 WSN
6584 6584 Tony Sipp 31 sippto01 2015 HOU AL 1.820403822 1.27 P 6 1 HOU ARI 2014 2018 WSN
6613 6613 Oliver Perez 33 perezol01 2015 HOU AL 0.411067005 -0.305 P 0 2 HOU ARI 2015 2015 WSN
6631 6631 Kelvin Herrera 25 herreke01 2015 KCR AL 2.46926865 1.0 P 7 1 KCR   2011 2018 WSN
6643 6643 Jeremy Guthrie 36 guthrje01 2015 KCR AL 3.904328846 -1.225 P 3 1 KCR COL 2012 2015 WSN
6681 6681 Trevor Gott 22 gotttr01 2015 LAA AL 1.65582346 0.385 P 4 1 ANA   2015 2015 WSN
6746 6746 Chris Heisey 30 heisech01 2015 LAD NL 0.727146091 -0.005 LF, RF, CF 1 1 LAD CIN 2015 2015 WSN
6790 6790 Kyle Barraclough 25 barraky01 2015 MIA NL 0.865667428 0.285 P 2 1 FLA   2015 2018 WSN
6834 6834 Michael Blazek 26 blazemi01 2015 MIL NL 1.438835016 0.86 P 5 1 MIL STL 2013 2017 WSN
6917 6917 Daniel Murphy 30 murphda08 2015 NYM NL 5.386500949 1.755 2B, 3B, 1B 13 1 NYM   2008 2015 WSN
6978 6978 Stephen Drew 32 drewst01 2015 NYY AL 3.976930471 0.33 2B, SS, 3B 6 1 NYY BOS 2014 2015 WSN
7005 7005 David Carpenter 29 carpeda01 2015 NYY AL 0.494529132 -0.105 P 0 1 NYY ATL 2015 2015 WSN
7040 7040 Sean Doolittle 28 doolise01 2015 OAK AL 0.436392331 0.18 P 1 1 OAK   2012 2017 WSN
7082 7082 Jonathan Papelbon 34 papeljo01 2015 PHI NL 1.368008299 1.06 P 5 1 PHI BOS 2012 2015 WSN
7129 7129 Mark Melancon 30 melanma01 2015 PIT NL 2.98213892 1.675 P 10 1 PIT BOS 2013 2016 WSN
7180 7180 Shawn Kelley 31 kellesh01 2015 SDP NL 1.555500763 0.845 P 5 1 SDP NYY 2015 2015 WSN
7285 7285 Yusmeiro Petit 30 petityu01 2015 SFG NL 1.863138271 0.14 P 3 1 SFG ARI 2012 2015 WSN
7320 7320 Trevor Rosenthal 25 rosentr01 2015 STL NL 2.876057554 2.295 P 11 1 STL   2012 2017 WSN
7332 7332 Matt Belisle 35 belisma01 2015 STL NL 1.042890813 0.425 P 3 1 STL COL 2015 2015 WSN
7388 7388 Enny Romero 24 romeren01 2015 TBR AL 0.736983261 0.105 P 1 1 TBD   2013 2016 WSN
7482 7482 Ben Revere 27 reverbe01 2015 TOR AL 2.298695022 0.6 LF, CF, RF 5 2 TOR PHI 2015 2015 WSN
7672 7672 Matt Wieters 28 wietema01 2014 BAL AL 1.063523248 0.775 C 4 1 BAL   2009 2016 WSN
7777 7777 Nate Schierholtz 30 schiena01 2014 CHC NL 3.430107527 -0.86 RF, LF, CF 2 1 CHC PHI 2013 2014 WSN
7799 7799 Adam Eaton 25 eatonad02 2014 CHW AL 5.155129688 4.485 CF 21 1 CHW ARI 2014 2016 WSN
7816 7816 Moises Sierra 25 sierrmo01 2014 CHW AL 1.293573435 0.545 RF, LF, CF 3 2 CHW TOR 2014 2014 WSN

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