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,795 rows where prev_franch = "MIN"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, stint_ID, franch_id, next_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
3 3 Eduardo Escobar 30 escobed01 2019 ARI NL 6.763216046 4.029622642 3B, 2B 21 1 ARI MIN 2018 2019  
34 34 John Ryan Murphy 28 murphjr01 2019 ARI NL 0.680265171 -0.030566038 C, P 1 1 ARI MIN 2017 2019 ATL
128 128 Ryan Eades 27 eadesry01 2019 BAL AL 0.3740499 0.010188679 P 0 2 BAL MIN 2019 2019  
240 240 Randy Rosario 25 rosarra01 2019 CHC NL 0.295761913 -0.117169811 P 0 1 CHC MIN 2018 2019 KCR
291 291 Ervin Santana 36 santaer01 2019 CHW AL 0.400622817 -0.405 P 0 1 CHW MIN 2019 2019  
338 338 Juan Graterol 30 grateju01 2019 CIN NL 0.185765125 -0.188490566 C 0 1 CIN MIN 2019 2019  
453 453 Niko Goodrum 27 goodrni01 2019 DET AL 4.629798749 1.707151899 SS, 2B, LF, 1B, CF, RF, 3B 10 1 DET MIN 2018 2019  
484 484 Austin Adams 32 adamsau01 2019 DET AL 0.293195703 0.015379747 P 0 2 DET MIN 2019 2019  
497 497 Bobby Wilson 36 wilsobo02 2019 DET AL 0.461018096 -0.645949367 C 0 1 DET MIN 2019 2019  
516 516 Ryan Pressly 30 pressry01 2019 HOU AL 2.066004379 1.558867925 P 7 1 HOU MIN 2018 2019  
630 630 Adalberto Mejia 26 mejiaad01 2019 LAA AL 0.442168977 0.13245283 P 1 2 ANA MIN 2019 2019 STL
640 640 John Curtiss 26 curtijo02 2019 LAA AL 0.037662222 0.015283019 P 0 1 ANA MIN 2019 2019  
697 697 JT Chargois 28 chargjt01 2019 LAD NL 0.426086664 -0.106981132 P 0 1 LAD MIN 2018 2019  
721 721 Tyler Kinley 28 kinlety01 2019 MIA NL 1.408294963 0.234339623 P 3 1 FLA MIN 2018 2019  
884 884 Ryan O'Rourke 31 orourry01 2019 NYM NL 0.067302396 0.010188679 P 0 1 NYM MIN 2019 2019  
922 922 Aaron Hicks 29 hicksaa01 2019 NYY AL 2.421811037 1.192075472 CF 7 1 NYY MIN 2016 2019  
929 929 David Hale 31 haleda02 2019 NYY AL 0.925520396 0.764150943 P 4 1 NYY MIN 2019 2019  
969 969 Robbie Grossman 29 grossro01 2019 OAK AL 4.526230042 1.023962264 LF, RF, CF 10 1 OAK MIN 2019 2019  
1001 1001 Fernando Rodney 42 rodnefe01 2019 OAK AL 0.347008812 -0.331132075 P 0 1 OAK MIN 2018 2019 WSN
1032 1032 Blake Parker 34 parkebl01 2019 PHI NL 0.671816339 0.239433962 P 2 2 PHI MIN 2019 2019  
1040 1040 Mike Morin 28 morinmi01 2019 PHI NL 0.888273412 -0.122264151 P 1 2 PHI MIN 2019 2019  
1052 1052 Logan Morrison 31 morrilo01 2019 PHI NL 0.359071367 -0.168113208 1B 0 1 PHI MIN 2019 2019  
1198 1198 Matt Magill 29 magilma01 2019 SEA AL 0.798391153 0.417735849 P 2 2 SEA MIN 2019 2019  
1262 1262 Tyler Austin 27 austity01 2019 SFG NL 1.477899116 0.183396226 LF, 1B, RF 3 2 SFG MIN 2019 2019 MIL
1363 1363 Oliver Drake 32 drakeol01 2019 TBR AL 1.736161138 0.952641509 P 5 1 TBD MIN 2019 2019  
1392 1392 Aaron Slegers 26 slegeaa01 2019 TBR AL 0.049087889 0.020377358 P 0 1 TBD MIN 2019 2019  
1421 1421 Logan Forsythe 32 forsylo01 2019 TEX AL 3.512541254 -0.00509434 1B, 3B, SS, 2B 5 1 TEX MIN 2019 2019  
1490 1490 Buddy Boshers 31 boshebu01 2019 TOR AL 0.637545966 0.106981132 P 1 1 TOR MIN 2019 2019  
1576 1576 Eduardo Escobar 29 escobed01 2018 ARI NL 2.220429185 1.035 3B, SS, 2B 6 2 ARI MIN 2018 2019  
1585 1585 John Ryan Murphy 27 murphjr01 2018 ARI NL 2.220429185 0.19 C 4 1 ARI MIN 2017 2019 ATL
1625 1625 Kurt Suzuki 34 suzukku01 2018 ATL NL 3.799425967 1.555 C 10 1 ATL MIN 2017 2018 WSN
1646 1646 Danny Santana 27 santada01 2018 ATL NL 0.313354719 0.065 LF, CF, RF 1 1 ATL MIN 2017 2018 TEX
1763 1763 Justin Haley 27 haleyju01 2018 BOS AL 0.135662566 -0.065 P 0 1 BOS MIN 2018 2018  
1796 1796 Randy Rosario 24 rosarra01 2018 CHC NL 1.473384074 0.089447853 P 3 1 CHC MIN 2018 2019 KCR
1817 1817 Chris Gimenez 35 gimench01 2018 CHC NL 0.307284768 -0.233558282 C, 1B, 3B, P 0 1 CHC MIN 2018 2018 MIN
1841 1841 Hector Santiago 30 santihe01 2018 CHW AL 2.630049113 0.26 P 4 1 CHW MIN 2018 2018 NYM
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
2023 2023 Niko Goodrum 26 goodrni01 2018 DET AL 4.748086522 1.28 2B, 1B, SS, LF, 3B, RF 10 1 DET MIN 2018 2019  
2084 2084 Ryan Pressly 29 pressry01 2018 HOU AL 0.935125359 1.175 P 5 2 HOU MIN 2018 2019  
2242 2242 JT Chargois 27 chargjt01 2018 LAD NL 1.029557259 0.168957055 P 2 1 LAD MIN 2018 2019  
2244 2244 Brian Dozier 31 doziebr01 2018 LAD NL 1.636514523 -0.104355828 2B 2 2 LAD MIN 2018 2018 WSN
2295 2295 Drew Rucinski 29 rucindr01 2018 MIA NL 1.211200064 -0.246521739 P 1 1 FLA MIN 2018 2018  
2301 2301 Tyler Kinley 27 kinlety01 2018 MIA NL 0.179877175 -0.045279503 P 0 2 FLA MIN 2018 2019  
2483 2483 Aaron Hicks 28 hicksaa01 2018 NYY AL 5.392542807 4.85 CF 22 1 NYY MIN 2016 2019  
2500 2500 Lance Lynn 31 lynnla01 2018 NYY AL 1.519409112 1.26 P 6 2 NYY MIN 2018 2018 TEX
2564 2564 Fernando Rodney 41 rodnefe01 2018 OAK AL 0.702684407 0.085 P 1 2 OAK MIN 2018 2019 WSN
2720 2720 Phil Hughes 32 hugheph01 2018 SDP NL 0.373871565 -0.26 P 0 2 SDP MIN 2018 2018  
2762 2762 Zach Duke 35 dukeza01 2018 SEA AL 0.474796641 0.035 P 1 2 SEA MIN 2018 2018 CIN
2946 2946 Bartolo Colon 45 colonba01 2018 TEX AL 3.972821661 0.435 P 6 1 TEX MIN 2018 2018  
3062 3062 Brandon Kintzler 33 kintzbr01 2018 WSN NL 1.454707724 0.66 P 4 1 WSN MIN 2017 2018 CHC
3132 3132 Chris Herrmann 29 herrmch01 2017 ARI NL 2.527749404 -0.855 C, LF, 1B, RF 1 1 ARI MIN 2016 2017 SEA
3137 3137 John Ryan Murphy 26 murphjr01 2017 ARI NL 0.069118148 -0.09 C 0 1 ARI MIN 2017 2019 ATL
3148 3148 Kurt Suzuki 33 suzukku01 2017 ATL NL 3.040719376 2.155 C 11 1 ATL MIN 2017 2018 WSN
3175 3175 Danny Santana 26 santada01 2017 ATL NL 1.495758398 -0.355 LF, 2B, RF, 3B, CF 1 2 ATL MIN 2017 2018 TEX
3217 3217 J.J. Hardy 34 hardyjj01 2017 BAL AL 2.53903953 -0.635 SS 2 1 BAL MIN 2011 2017  
3263 3263 Fernando Abad 31 abadfe01 2017 BOS AL 1.048525452 0.4 P 3 1 BOS MIN 2016 2017 SFG
3471 3471 Craig Breslow 36 breslcr01 2017 CLE AL 0.119789236 0.08 P 0 2 CLE MIN 2017 2017  
3611 3611 Juan Centeno 27 centeju01 2017 HOU AL 0.529637937 -0.26 C 0 1 HOU MIN 2017 2017 TEX
3670 3670 Ricky Nolasco 34 nolasri01 2017 LAA AL 5.038844759 0.67 P 9 1 ANA MIN 2016 2017  
3675 3675 Alex Meyer 27 meyeral01 2017 LAA AL 1.874487369 1.055 P 6 1 ANA MIN 2016 2017  
3696 3696 Shane Robinson 32 robinsh01 2017 LAA AL 0.335426305 0.015 RF, CF, LF 1 1 ANA MIN 2016 2017 NYY
3841 3841 Tommy Milone 30 milonto01 2017 MIL NL 0.50861615 -0.04 P 1 1 MIL MIN 2017 2017 NYM
3971 3971 Aaron Hicks 27 hicksaa01 2017 NYY AL 3.308263549 3.635 CF, LF, RF 15 1 NYY MIN 2016 2019  
3997 3997 Jaime Garcia 30 garcija02 2017 NYY AL 1.05347192 0.09 P 1 3 NYY MIN 2017 2017 TOR
4047 4047 Trevor Plouffe 31 plouftr01 2017 OAK AL 1.891201049 -0.215 3B, 1B, 2B 2 1 OAK MIN 2017 2017 TBD
4206 4206 Tim Melville 27 melviti01 2017 SDP NL 0.050875749 -0.055 P 0 2 SDP MIN 2017 2017 COL
4241 4241 Andrew Albers 31 alberan01 2017 SEA AL 1.164807471 0.54 P 3 1 SEA MIN 2017 2017  
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
4319 4319 Neil Ramirez 28 ramirne01 2017 SFG NL 0.294184729 -0.34 P 0 1 SFG MIN 2017 2017 NYM
4529 4529 Nick Tepesch 28 tepesni01 2017 TOR AL 0.372629467 -0.145 P 0 2 TOR MIN 2017 2017  
4565 4565 Brandon Kintzler 32 kintzbr01 2017 WSN NL 0.926374126 0.425 P 3 2 WSN MIN 2017 2018 CHC
4603 4603 Chris Herrmann 28 herrmch01 2016 ARI NL 1.624704691 1.145 C, RF, LF, 1B, CF 6 1 ARI MIN 2016 2017 SEA
4710 4710 J.J. Hardy 33 hardyjj01 2016 BAL AL 4.19138756 2.08 SS 13 1 BAL MIN 2011 2017  
4732 4732 Brian Duensing 33 duensbr01 2016 BAL AL 0.261994899 0.135 P 1 1 BAL MIN 2016 2016 CHC
4753 4753 David Ortiz 40 ortizda01 2016 BOS AL 5.769585253 4.86 1B 21 1 BOS MIN 2003 2016  
4792 4792 Fernando Abad 30 abadfe01 2016 BOS AL 0.442497815 -0.185 P 0 2 BOS MIN 2016 2017 SFG
5057 5057 Mike Pelfrey 32 pelfrmi01 2016 DET AL 3.273500665 0.332049689 P 6 1 DET MIN 2016 2016 CHW
5177 5177 Ricky Nolasco 33 nolasri01 2016 LAA AL 2.135018409 1.255 P 7 2 ANA MIN 2016 2017  
5196 5196 Alex Meyer 26 meyeral01 2016 LAA AL 0.630310618 0.235 P 2 2 ANA MIN 2016 2017  
5198 5198 Shane Robinson 31 robinsh01 2016 LAA AL 1.069435216 0.03 LF, CF, RF 2 1 ANA MIN 2016 2017 NYY
5203 5203 A.J. Achter 27 achteaj01 2016 LAA AL 0.837942351 0.035 P 1 1 ANA MIN 2016 2016  
5271 5271 Casey Fien 32 fienca01 2016 LAD NL 0.667422202 -0.25 P 0 2 LAD MIN 2016 2016 SEA
5351 5351 Blaine Boyer 34 boyerbl01 2016 MIL NL 1.789695691 0.44 P 4 1 MIL MIN 2016 2016 BOS
5368 5368 Josmil Pinto 27 pintojo01 2016 MIL NL 0.060500695 -0.1   0 1 MIL MIN 2016 2016  
5494 5494 Aaron Hicks 26 hicksaa01 2016 NYY AL 3.46713032 -0.26 RF, LF, CF 4 1 NYY MIN 2016 2019  
5671 5671 Pedro Florimon 29 floripe01 2016 PIT NL 0.244107744 -0.08 2B, SS 0 1 PIT MIN 2015 2016 PHI
5808 5808 Eduardo Nunez 29 nunezed02 2016 SFG NL 1.956602814 1.05 SS, 3B, 2B 6 2 SFG MIN 2016 2017 BOS
5866 5866 Eric Fryer 30 fryerer01 2016 STL NL 0.403255893 0.535 C 2 1 STL MIN 2016 2016 PIT
5915 5915 Oswaldo Arcia 25 arciaos01 2016 TBR AL 0.587610032 0.025 LF, RF 1 2 TBD MIN 2016 2016 FLA
5923 5923 Kevin Jepsen 31 jepseke01 2016 TBR AL 0.565912852 -0.355 P 0 2 TBD MIN 2016 2016 TEX
6015 6015 Scott Diamond 29 diamosc01 2016 TOR AL 0.015508449 -0.055 P 0 1 TOR MIN 2016 2016  
6030 6030 Chris Colabello 32 colabch01 2016 TOR AL 0.299354839 -0.495 1B, LF 0 1 TOR MIN 2015 2016  
6036 6036 Wilson Ramos 28 ramoswi01 2016 WSN NL 5.202195164 3.42 C 18 1 WSN MIN 2010 2016 TBD
6198 6198 J.J. Hardy 32 hardyjj01 2015 BAL AL 4.234920635 0.05 SS 6 1 BAL MIN 2011 2017  
6216 6216 Chris Parmelee 27 parmech01 2015 BAL AL 0.988471178 -0.04 1B, RF 1 1 BAL MIN 2015 2015 NYY
6234 6234 David Ortiz 39 ortizda01 2015 BOS AL 5.732775274 3.02 1B 17 1 BOS MIN 2003 2016  
6459 6459 Anthony Swarzak 29 swarzan01 2015 CLE AL 0.271584366 0.0 P 0 1 CLE MIN 2015 2015 NYY
6612 6612 Alex Presley 29 preslal01 2015 HOU AL 0.124710552 -0.16 LF, CF, RF 0 1 HOU MIN 2014 2015 MIL
6614 6614 Sam Deduno 31 dedunsa01 2015 HOU AL 0.539525444 -0.34 P 0 1 HOU MIN 2014 2015  

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