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,244 rows where next_franch = "MIN"

✎ 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
720 720 Sergio Romo 36 romose01 2019 MIA NL 1.39984623 0.392264151 P 3 1 FLA TBD 2019 2019 MIN
1251 1251 Sam Dyson 31 dysonsa01 2019 SFG NL 1.753498531 1.151320755 P 6 1 SFG TEX 2017 2019 MIN
1817 1817 Chris Gimenez 35 gimench01 2018 CHC NL 0.307284768 -0.233558282 C, 1B, 3B, P 0 1 CHC MIN 2018 2018 MIN
1843 1843 Ryan LaMarre 29 lamarry01 2018 CHW AL 0.680661157 0.615 CF, LF, RF, P 3 2 CHW MIN 2018 2018 MIN
1963 1963 Matt Belisle 38 belisma01 2018 CLE AL 0.256598654 -0.005 P 0 1 CLE MIN 2018 2018 MIN
2072 2072 Marwin Gonzalez 29 gonzama01 2018 HOU AL 5.230517889 1.985 LF, SS, 2B, 1B, 3B, CF, RF 13 1 HOU   2012 2018 MIN
2170 2170 Blake Parker 33 parkebl01 2018 LAA AL 2.192833336 0.545 P 5 1 ANA NYY 2017 2018 MIN
2186 2186 Juan Graterol 29 grateju01 2018 LAA AL 0.009530069 0.18 C 1 1 ANA   2016 2018 MIN
2253 2253 Logan Forsythe 31 forsylo01 2018 LAD NL 2.03120332 -0.631104294 2B, 3B, 1B, LF 1 1 LAD TBD 2017 2018 MIN
2351 2351 Jonathan Schoop 26 schoojo01 2018 MIL NL 1.313947591 -0.114294479 2B, SS 2 2 MIL BAL 2018 2018 MIN
2508 2508 Ronald Torreyes 25 torrero01 2018 NYY AL 0.946711474 0.39 2B, 3B, SS 2 1 NYY LAD 2016 2018 MIN
2511 2511 Tyler Austin 26 austity01 2018 NYY AL 1.225156025 0.15 1B 2 1 NYY   2016 2018 MIN
2512 2512 David Hale 30 haleda02 2018 NYY AL 0.23253705 0.165 P 1 1 NYY COL 2018 2018 MIN
2731 2731 Nelson Cruz 37 cruzne02 2018 SEA AL 5.651772465 2.7 RF 17 1 SEA BAL 2015 2018 MIN
2769 2769 Taylor Motter 28 motteta01 2018 SEA AL 0.162572135 0.06 1B, RF, 2B, 3B, LF, P, SS 0 1 SEA TBD 2017 2018 MIN
2770 2770 Mike Morin 27 morinmi01 2018 SEA AL 0.092068573 0.025 P 0 1 SEA KCR 2018 2018 MIN
2794 2794 Sam Dyson 30 dysonsa01 2018 SFG NL 2.280848854 0.895 P 6 1 SFG TEX 2017 2019 MIN
2882 2882 C.J. Cron 28 croncj01 2018 TBR AL 5.261623198 2.095 1B 13 1 TBD ANA 2018 2018 MIN
2912 2912 Johnny Field 26 fieldjo04 2018 TBR AL 1.681840272 0.04 RF, LF, CF, P 2 1 TBD   2018 2018 MIN
2959 2959 Martin Perez 27 perezma02 2018 TEX AL 2.591590857 -0.505 P 2 1 TEX   2012 2018 MIN
3033 3033 Oliver Drake 31 drakeol01 2018 TOR AL 0.02687733 -0.05 P 0 4 TOR ANA 2018 2018 MIN
3113 3113 Fernando Rodney 40 rodnefe01 2017 ARI NL 2.392462074 0.77 P 6 1 ARI FLA 2017 2017 MIN
3152 3152 Jaime Garcia 30 garcija02 2017 ATL NL 3.225927066 1.56 P 9 1 ATL STL 2017 2017 MIN
3191 3191 Bartolo Colon 44 colonba01 2017 ATL NL 1.798525709 -1.21 P 0 1 ATL NYM 2017 2017 MIN
3270 3270 Addison Reed 28 reedad01 2017 BOS AL 0.933896579 0.28 P 2 2 BOS NYM 2017 2017 MIN
3570 3570 Marwin Gonzalez 28 gonzama01 2017 HOU AL 4.785325216 4.045 LF, SS, 1B, 2B, 3B, RF 19 1 HOU   2012 2018 MIN
3671 3671 Blake Parker 32 parkebl01 2017 LAA AL 2.365663204 1.645 P 8 1 ANA NYY 2017 2018 MIN
3699 3699 Juan Graterol 28 grateju01 2017 LAA AL 0.833773959 -0.065 C 1 1 ANA   2016 2018 MIN
3728 3728 Logan Forsythe 30 forsylo01 2017 LAD NL 4.342087312 1.845 2B, 3B, LF, SS, 1B 12 1 LAD TBD 2017 2018 MIN
3958 3958 Adam Wilk 29 wilkad01 2017 NYM NL 0.103776327 -0.275 P 0 1 NYM ANA 2017 2017 MIN
3984 3984 Michael Pineda 28 pinedmi01 2017 NYY AL 2.70379725 0.875 P 6 1 NYY SEA 2014 2017 MIN
3985 3985 Ronald Torreyes 24 torrero01 2017 NYY AL 3.079159425 0.685 2B, SS, 3B, RF 6 1 NYY LAD 2016 2018 MIN
4008 4008 Tyler Austin 25 austity01 2017 NYY AL 0.421551588 -0.145 1B, RF 0 1 NYY   2016 2018 MIN
4058 4058 Ryan LaMarre 28 lamarry01 2017 OAK AL 0.076028183 -0.065 CF 0 1 OAK BOS 2017 2017 MIN
4221 4221 Nelson Cruz 36 cruzne02 2017 SEA AL 6.093826356 4.035 RF 20 1 SEA BAL 2015 2018 MIN
4250 4250 Taylor Motter 27 motteta01 2017 SEA AL 2.645381984 -0.575 SS, 2B, 1B, LF, 3B, RF 2 1 SEA TBD 2017 2018 MIN
4274 4274 Chase De Jong 23 dejonch01 2017 SEA AL 0.901374345 -0.28 P 0 1 SEA   2017 2017 MIN
4279 4279 Chris Heston 29 hestoch01 2017 SEA AL 0.129472375 -0.425 P 0 1 SEA SFG 2017 2017 MIN
4303 4303 Sam Dyson 29 dysonsa01 2017 SFG NL 1.580280271 0.265 P 3 2 SFG TEX 2017 2019 MIN
4338 4338 Lance Lynn 30 lynnla01 2017 STL NL 5.21123508 1.91 P 12 1 STL   2011 2017 MIN
4361 4361 Zach Duke 34 dukeza01 2017 STL NL 0.586370559 0.005 P 1 1 STL CHW 2016 2017 MIN
4381 4381 Logan Morrison 29 morrilo01 2017 TBR AL 5.693890885 3.345 1B 17 1 TBD SEA 2016 2017 MIN
4395 4395 Jake Odorizzi 27 odorija01 2017 TBR AL 3.912686846 0.11 P 5 1 TBD KCR 2013 2017 MIN
4437 4437 Martin Perez 26 perezma02 2017 TEX AL 5.304141493 2.145 P 14 1 TEX   2012 2018 MIN
4472 4472 Dillon Gee 31 geedi01 2017 TEX AL 0.302962382 -0.11 P 0 1 TEX KCR 2017 2017 MIN
4791 4791 Pat Light 25 lightpa01 2016 BOS AL 0.039700004 -0.17 P 0 1 BOS   2016 2016 MIN
4922 4922 Matt Magill 26 magilma01 2016 CIN NL 0.085439735 -0.06 P 0 1 CIN LAD 2016 2016 MIN
4938 4938 Tim Melville 26 melviti01 2016 CIN NL 0.225227231 -0.445 P 0 1 CIN   2016 2016 MIN
4992 4992 Austin Adams 29 adamsau01 2016 CLE AL 0.377397536 -0.467888199 P 0 1 CLE   2014 2016 MIN
4993 4993 Chris Gimenez 33 gimench01 2016 CLE AL 1.466557912 -0.578571429 C, 1B, 3B, P 0 1 CLE TEX 2016 2016 MIN
5092 5092 Jason Castro 29 castrja01 2016 HOU AL 3.528231678 1.985 C, 1B 11 1 HOU   2010 2016 MIN
5096 5096 Marwin Gonzalez 27 gonzama01 2016 HOU AL 4.860702152 0.865 1B, 3B, LF, 2B, SS, CF 9 1 HOU   2012 2018 MIN
5180 5180 Hector Santiago 28 santihe01 2016 LAA AL 3.491573387 0.775 P 7 1 ANA CHW 2014 2016 MIN
5199 5199 Gregorio Petit 31 petitgr01 2016 LAA AL 2.148504983 -0.14 2B, SS, 3B, LF, RF 2 1 ANA NYY 2016 2016 MIN
5207 5207 Juan Graterol 27 grateju01 2016 LAA AL 0.144518272 0.08 C 0 1 ANA   2016 2018 MIN
5266 5266 Nick Tepesch 27 tepesni01 2016 LAD NL 0.111146228 -0.11 P 0 1 LAD TEX 2016 2016 MIN
5316 5316 Craig Breslow 35 breslcr01 2016 MIA NL 0.386493658 -0.055341615 P 0 1 FLA BOS 2016 2016 MIN
5367 5367 Neil Ramirez 27 ramirne01 2016 MIL NL 0.032640354 -0.085 P 0 2 MIL CHC 2016 2016 MIN
5482 5482 Michael Pineda 27 pinedmi01 2016 NYY AL 5.019303249 2.16 P 14 1 NYY SEA 2014 2017 MIN
5492 5492 Ronald Torreyes 23 torrero01 2016 NYY AL 1.62311641 0.5 3B, SS, 2B, RF 4 1 NYY LAD 2016 2018 MIN
5510 5510 Tyler Austin 24 austity01 2016 NYY AL 0.86438152 0.025 1B, RF, LF 1 1 NYY   2016 2018 MIN
5744 5744 Nelson Cruz 35 cruzne02 2016 SEA AL 6.237665269 4.545 RF 22 1 SEA BAL 2015 2018 MIN
5829 5829 Ehire Adrianza 26 adriaeh01 2016 SFG NL 0.698084421 0.06 SS, 2B, 3B 1 1 SFG   2013 2016 MIN
5862 5862 Zach Duke 33 dukeza01 2016 STL NL 0.825856576 0.645 P 3 2 STL CHW 2016 2017 MIN
5885 5885 Jake Odorizzi 26 odorija01 2016 TBR AL 5.307325879 2.485 P 13 1 TBD KCR 2013 2017 MIN
5897 5897 Logan Morrison 28 morrilo01 2016 TBR AL 3.833914632 0.48 1B 6 1 TBD SEA 2016 2017 MIN
5909 5909 Bobby Wilson 33 wilsobo02 2016 TBR AL 0.915130377 0.145 C 1 3 TBD TEX 2016 2016 MIN
5935 5935 Martin Perez 25 perezma02 2016 TEX AL 5.493966114 2.085 P 16 1 TEX   2012 2018 MIN
6048 6048 Matt Belisle 36 belisma01 2016 WSN NL 1.229387977 0.86 P 4 1 WSN STL 2016 2016 MIN
6448 6448 Austin Adams 28 adamsau01 2015 CLE AL 0.752079784 0.181118012 P 1 1 CLE   2014 2016 MIN
6579 6579 Jason Castro 28 castrja01 2015 HOU AL 3.597419782 1.955 C 10 1 HOU   2010 2016 MIN
6580 6580 Marwin Gonzalez 26 gonzama01 2015 HOU AL 3.549454185 1.71 1B, SS, 3B, 2B, LF 9 1 HOU   2012 2018 MIN
6615 6615 Robbie Grossman 25 grossro01 2015 HOU AL 0.518028449 -0.34 LF, RF 0 1 HOU   2013 2015 MIN
6667 6667 Hector Santiago 27 santihe01 2015 LAA AL 5.004503809 1.3 P 12 1 ANA CHW 2014 2016 MIN
6705 6705 Drew Rucinski 26 rucindr01 2015 LAA AL 0.202286366 -0.21 P 0 1 ANA   2014 2015 MIN
6845 6845 Neal Cotts 35 cottsne01 2015 MIL NL 1.136815647 0.235 P 2 1 MIL TEX 2015 2015 MIN
6853 6853 Logan Schafer 28 schaflo01 2015 MIL NL 1.452285064 -0.405 CF, LF 1 1 MIL   2011 2015 MIN
6858 6858 Brandon Kintzler 30 kintzbr01 2015 MIL NL 0.17548161 -0.16 P 0 1 MIL   2010 2015 MIN
6865 6865 Juan Centeno 25 centeju01 2015 MIL NL 0.233584311 -0.48 C 0 1 MIL NYM 2015 2015 MIN
6966 6966 Michael Pineda 26 pinedmi01 2015 NYY AL 4.471698314 2.785 P 14 1 NYY SEA 2014 2017 MIN
6981 6981 John Ryan Murphy 24 murphjr01 2015 NYY AL 1.598205703 0.6 C 4 1 NYY   2013 2015 MIN
7046 7046 Fernando Abad 29 abadfe01 2015 OAK AL 1.233510769 -0.22 P 1 1 OAK WSN 2014 2015 MIN
7210 7210 Nelson Cruz 34 cruzne02 2015 SEA AL 6.221749099 5.055 RF 24 1 SEA BAL 2015 2018 MIN
7289 7289 Ehire Adrianza 25 adriaeh01 2015 SFG NL 1.340231074 0.015 2B, SS, 1B, 3B 2 1 SFG   2013 2016 MIN
7313 7313 Lance Lynn 28 lynnla01 2015 STL NL 4.768318048 3.18 P 17 1 STL   2011 2017 MIN
7359 7359 Jake Odorizzi 25 odorija01 2015 TBR AL 4.546824894 3.15 P 15 1 TBD KCR 2013 2017 MIN
7378 7378 Kevin Jepsen 30 jepseke01 2015 TBR AL 1.737718929 0.325 P 3 1 TBD ANA 2015 2015 MIN
7421 7421 Martin Perez 24 perezma02 2015 TEX AL 2.19268688 0.94 P 6 1 TEX   2012 2018 MIN
7506 7506 Andrew Albers 29 alberan01 2015 TOR AL 0.089580672 -0.08 P 0 1 TOR MIN 2015 2015 MIN
7617 7617 Ervin Santana 31 santaer01 2014 ATL NL 5.291494016 2.135 P 14 1 ATL KCR 2014 2014 MIN
7638 7638 Jordan Schafer 27 schafjo02 2014 ATL NL 0.945155073 -0.255 LF, CF, RF 1 1 ATL HOU 2013 2014 MIN
7920 7920 Austin Adams 27 adamsau01 2014 CLE AL 0.116169466 -0.08 P 0 1 CLE   2014 2016 MIN
7992 7992 Torii Hunter 38 hunteto01 2014 DET AL 5.503238342 0.915 RF 10 1 DET ANA 2013 2014 MIN
8034 8034 Jason Castro 27 castrja01 2014 HOU AL 4.922260898 1.775 C 12 1 HOU   2010 2016 MIN
8038 8038 Robbie Grossman 24 grossro01 2014 HOU AL 4.057019725 1.11 LF, RF, CF 9 1 HOU   2013 2015 MIN
8039 8039 Marwin Gonzalez 25 gonzama01 2014 HOU AL 2.980275153 1.39 SS, 2B, 3B, LF, 1B, RF 8 1 HOU   2012 2018 MIN
8141 8141 Hector Santiago 26 santihe01 2014 LAA AL 3.482100432 0.515 P 7 1 ANA CHW 2014 2016 MIN
8161 8161 Drew Rucinski 25 rucindr01 2014 LAA AL 0.113070321 0.045 P 0 1 ANA   2014 2015 MIN
8296 8296 Brandon Kintzler 29 kintzbr01 2014 MIL NL 1.74149157 0.075 P 3 1 MIL   2010 2015 MIN
8300 8300 Logan Schafer 27 schaflo01 2014 MIL NL 1.380952381 -0.18 LF, RF, CF 2 1 MIL   2011 2015 MIN

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