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,971 rows where next_franch = "ATL"

✎ 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
34 34 John Ryan Murphy 28 murphjr01 2019 ARI NL 0.680265171 -0.030566038 C, P 1 1 ARI MIN 2017 2019 ATL
457 457 Shane Greene 30 greensh02 2019 DET AL 1.591633814 1.245759494 P 5 1 DET NYY 2015 2019 ATL
560 560 Billy Hamilton 28 hamilbi02 2019 KCR AL 2.968618896 0.412641509 CF 5 1 KCR CIN 2019 2019 ATL
873 873 Adeiny Hechavarria 30 hechaad01 2019 NYM NL 1.499657534 -0.152830189 2B, SS, 3B 2 1 NYM NYY 2019 2019 ATL
1090 1090 Francisco Cervelli 33 cervefr01 2019 PIT NL 1.228305785 -0.183396226 C, 1B 1 1 PIT NYY 2015 2019 ATL
1235 1235 Anthony Swarzak 33 swarzan01 2019 SEA AL 0.526778842 -0.478867925 P 0 1 SEA NYM 2019 2019 ATL
1257 1257 Mark Melancon 34 melanma01 2019 SFG NL 1.316289401 0.54509434 P 4 1 SFG WSN 2017 2019 ATL
1418 1418 Chris Martin 33 martich02 2019 TEX AL 1.368282155 1.018867925 P 5 1 TEX NYY 2018 2019 ATL
1585 1585 John Ryan Murphy 27 murphjr01 2018 ARI NL 2.220429185 0.19 C 4 1 ARI MIN 2017 2019 ATL
1673 1673 Kevin Gausman 27 gausmke01 2018 BAL AL 3.564477325 1.84 P 9 1 BAL   2013 2018 ATL
1695 1695 Darren O'Day 35 odayda01 2018 BAL AL 0.700966733 0.37 P 2 1 BAL TEX 2012 2018 ATL
1697 1697 Brad Brach 32 brachbr01 2018 BAL AL 1.372880239 0.165 P 2 1 BAL SDP 2014 2018 ATL
1882 1882 Adam Duvall 29 duvalad01 2018 CIN NL 3.641608688 1.025 LF, 1B, RF, 3B 8 1 CIN SFG 2015 2018 ATL
1945 1945 Josh Donaldson 32 donaljo02 2018 CLE AL 0.554670067 0.595 3B, 1B 2 2 CLE TOR 2018 2018 ATL
1974 1974 Josh Tomlin 33 tomlijo01 2018 CLE AL 1.691947377 -1.155 P 0 1 CLE   2010 2018 ATL
2038 2038 Shane Greene 29 greensh02 2018 DET AL 2.49223397 -0.31 P 3 1 DET NYY 2015 2019 ATL
2069 2069 Dallas Keuchel 30 keuchda01 2018 HOU AL 5.627913996 2.94 P 17 1 HOU   2012 2018 ATL
2088 2088 Brian McCann 34 mccanbr01 2018 HOU AL 2.046724391 0.53 C 4 1 HOU NYY 2017 2018 ATL
2124 2124 Lucas Duda 32 dudalu01 2018 KCR AL 3.312365502 0.105 1B 4 1 KCR TBD 2018 2018 ATL
2181 2181 Rene Rivera 34 riverre01 2018 LAA AL 0.829116004 0.435 C, 1B 2 1 ANA CHC 2018 2018 ATL
2296 2296 Rafael Ortega 27 ortegra01 2018 MIA NL 1.43 -0.437701863 RF, LF 1 1 FLA ANA 2018 2018 ATL
2447 2447 Jerry Blevins 34 blevije01 2018 NYM NL 1.303949018 0.03 P 2 1 NYM WSN 2015 2018 ATL
2552 2552 Matthew Joyce 33 joycema01 2018 OAK AL 2.288739172 0.125 LF, RF, CF 4 1 OAK PIT 2017 2018 ATL
2636 2636 Francisco Cervelli 32 cervefr01 2018 PIT NL 4.07442184 2.636273292 C, 1B 14 1 PIT NYY 2015 2019 ATL
2805 2805 Mark Melancon 33 melanma01 2018 SFG NL 1.416504426 0.175 P 3 1 SFG WSN 2017 2019 ATL
2918 2918 Jonny Venters 33 ventejo01 2018 TBR AL 0.436665598 0.135 P 1 1 TBD ATL 2018 2018 ATL
2952 2952 Chris Martin 32 martich02 2018 TEX AL 1.393245953 0.605 P 4 1 TEX NYY 2018 2019 ATL
3137 3137 John Ryan Murphy 26 murphjr01 2017 ARI NL 0.069118148 -0.09 C 0 1 ARI MIN 2017 2019 ATL
3196 3196 Kevin Gausman 26 gausmke01 2017 BAL AL 5.391627526 2.31 P 15 1 BAL   2013 2018 ATL
3202 3202 Brad Brach 31 brachbr01 2017 BAL AL 2.570036434 1.215 P 8 1 BAL SDP 2014 2018 ATL
3206 3206 Darren O'Day 34 odayda01 2017 BAL AL 2.020733652 0.925 P 6 1 BAL TEX 2012 2018 ATL
3231 3231 Ryan Flaherty 30 flahery01 2017 BAL AL 0.407383208 -0.115 2B, 3B, SS, LF, RF 0 1 BAL   2012 2017 ATL
3393 3393 Adam Duvall 28 duvalad01 2017 CIN NL 6.376550552 1.66 LF, 1B 13 1 CIN SFG 2015 2018 ATL
3446 3446 Josh Tomlin 32 tomlijo01 2017 CLE AL 4.026964881 1.51 P 10 1 CLE   2010 2018 ATL
3509 3509 Shane Carle 25 carlesh01 2017 COL NL 0.062215596 -0.01 P 0 1 COL   2017 2017 ATL
3526 3526 Shane Greene 28 greensh02 2017 DET AL 2.536795757 1.53 P 8 1 DET NYY 2015 2019 ATL
3539 3539 Anibal Sanchez 33 sanchan01 2017 DET AL 2.754277399 -0.165 P 3 1 DET FLA 2012 2017 ATL
3574 3574 Dallas Keuchel 29 keuchda01 2017 HOU AL 4.103242235 3.21 P 15 1 HOU   2012 2018 ATL
3578 3578 Brian McCann 33 mccanbr01 2017 HOU AL 3.707465556 1.795 C 11 1 HOU NYY 2017 2018 ATL
3629 3629 Peter Moylan 38 moylape01 2017 KCR AL 2.002265854 0.735 P 5 1 KCR ATL 2016 2017 ATL
3708 3708 Carlos Perez 26 perezca02 2017 LAA AL 0.201255783 -0.145 C 0 1 ANA   2015 2017 ATL
3733 3733 Brandon McCarthy 33 mccarbr01 2017 LAD NL 2.537345582 1.385 P 8 1 LAD NYY 2015 2017 ATL
3750 3750 Charlie Culberson 28 culbech01 2017 LAD NL 0.148362892 0.075 SS, 2B, 3B 0 1 LAD COL 2016 2017 ATL
3762 3762 Grant Dayton 29 daytogr01 2017 LAD NL 0.644466521 -0.225 P 0 1 LAD   2016 2017 ATL
3766 3766 Josh Ravin 29 ravinjo01 2017 LAD NL 0.481431686 -0.285 P 0 1 LAD   2015 2017 ATL
3891 3891 Danny Santana 26 santada01 2017 MIN AL 0.241782908 0.085 LF, 2B, RF, 3B, CF 1 1 MIN   2014 2017 ATL
3927 3927 Jerry Blevins 33 blevije01 2017 NYM NL 1.816968608 1.14 P 6 1 NYM WSN 2015 2018 ATL
4020 4020 Matthew Joyce 32 joycema01 2017 OAK AL 5.169916435 2.25 RF, LF, CF 14 1 OAK PIT 2017 2018 ATL
4137 4137 Francisco Cervelli 31 cervefr01 2017 PIT NL 3.033201445 0.525 C 6 1 PIT NYY 2015 2019 ATL
4167 4167 Chris Stewart 35 stewach01 2017 PIT NL 1.436779632 -0.7 C 0 1 PIT NYY 2014 2017 ATL
4305 4305 Mark Melancon 32 melanma01 2017 SFG NL 1.162628382 0.275 P 2 1 SFG WSN 2017 2019 ATL
4365 4365 Matt Adams 28 adamsma01 2017 STL NL 0.521990151 -0.08 1B, LF 0 1 STL   2012 2017 ATL
4377 4377 Miguel Socolovich 30 socolmi01 2017 STL NL 0.397095597 -0.38 P 0 1 STL CHC 2015 2017 ATL
4399 4399 Peter Bourjos 30 bourjpe01 2017 TBR AL 1.923227703 0.43 LF, CF, RF 4 1 TBD PHI 2017 2017 ATL
4404 4404 Chase Whitley 28 whitlch01 2017 TBR AL 1.531597204 0.32 P 3 1 TBD NYY 2016 2017 ATL
4494 4494 Jose Bautista 36 bautijo02 2017 TOR AL 6.490701468 -0.91 RF, 3B, 1B 7 1 TOR PIT 2008 2017 ATL
4623 4623 Josh Collmenter 30 collmjo01 2016 ARI NL 0.43818889 -0.02 P 1 1 ARI   2011 2016 ATL
4703 4703 Kevin Gausman 25 gausmke01 2016 BAL AL 5.198277926 3.6 P 19 1 BAL   2013 2018 ATL
4712 4712 Brad Brach 30 brachbr01 2016 BAL AL 2.750172834 2.08 P 10 1 BAL SDP 2014 2018 ATL
4722 4722 Darren O'Day 33 odayda01 2016 BAL AL 1.127145378 0.305 P 3 1 BAL TEX 2012 2018 ATL
4723 4723 Ryan Flaherty 29 flahery01 2016 BAL AL 1.684210526 0.165 3B, SS, 1B, RF, LF, 2B, P 3 1 BAL   2012 2017 ATL
4737 4737 Chaz Roe 29 roech01 2016 BAL AL 0.269215231 0.015 P 0 1 BAL NYY 2015 2016 ATL
4895 4895 Adam Duvall 27 duvalad01 2016 CIN NL 6.114791053 2.79 LF, RF, 1B, 3B 18 1 CIN SFG 2015 2018 ATL
4902 4902 Brandon Phillips 35 phillbr01 2016 CIN NL 5.873417722 0.895 2B 12 1 CIN CLE 2006 2016 ATL
4955 4955 Josh Tomlin 31 tomlijo01 2016 CLE AL 4.881923039 1.262795031 P 11 1 CLE   2010 2018 ATL
5031 5031 Jason Motte 34 motteja01 2016 COL NL 0.69889004 -0.17 P 0 1 COL CHC 2016 2016 ATL
5058 5058 Anibal Sanchez 32 sanchan01 2016 DET AL 4.472887447 -0.070434783 P 6 1 DET FLA 2012 2017 ATL
5062 5062 Shane Greene 27 greensh02 2016 DET AL 2.197700195 0.407515528 P 4 1 DET NYY 2015 2019 ATL
5094 5094 Dallas Keuchel 28 keuchda01 2016 HOU AL 4.574929292 1.39 P 10 1 HOU   2012 2018 ATL
5127 5127 Preston Tucker 25 tuckepr01 2016 HOU AL 1.351237664 -1.01 LF, RF 0 1 HOU   2015 2016 ATL
5151 5151 Peter Moylan 37 moylape01 2016 KCR AL 1.31166192 0.375 P 3 1 KCR ATL 2016 2017 ATL
5188 5188 Carlos Perez 25 perezca02 2016 LAA AL 2.803654485 0.11 C, 1B 4 1 ANA   2015 2017 ATL
5244 5244 Grant Dayton 28 daytogr01 2016 LAD NL 0.853012628 0.555 P 3 1 LAD   2016 2017 ATL
5248 5248 Charlie Culberson 27 culbech01 2016 LAD NL 0.674649333 0.28 SS, 2B, 3B, LF 2 1 LAD COL 2016 2017 ATL
5249 5249 Brandon McCarthy 32 mccarbr01 2016 LAD NL 1.159011467 0.205 P 2 1 LAD NYY 2015 2017 ATL
5251 5251 Josh Ravin 28 ravinjo01 2016 LAD NL 0.195347916 0.2 P 1 1 LAD   2015 2017 ATL
5265 5265 Micah Johnson 25 johnsmi04 2016 LAD NL 0.059527882 -0.085 2B, LF 0 1 LAD CHW 2016 2016 ATL
5363 5363 Michael Reed 23 reedmi02 2016 MIL NL 0.242002782 -0.005 CF, LF 0 1 MIL   2015 2016 ATL
5372 5372 Sam Freeman 29 freemsa01 2016 MIL NL 0.1235814 -0.26 P 0 1 MIL TEX 2016 2016 ATL
5397 5397 Kurt Suzuki 32 suzukku01 2016 MIN AL 3.479813415 0.15 C 4 1 MIN OAK 2014 2016 ATL
5429 5429 Danny Santana 25 santada01 2016 MIN AL 2.313656104 -1.065 CF, LF, RF, 2B, SS, 3B 0 1 MIN   2014 2017 ATL
5436 5436 Bartolo Colon 43 colonba01 2016 NYM NL 5.329546675 2.49 P 15 1 NYM OAK 2014 2016 ATL
5450 5450 Jerry Blevins 32 blevije01 2016 NYM NL 1.530091661 0.81 P 4 1 NYM WSN 2015 2018 ATL
5632 5632 Francisco Cervelli 30 cervefr01 2016 PIT NL 3.837373737 2.16 C, 1B 12 1 PIT NYY 2015 2019 ATL
5638 5638 Sean Rodriguez 31 rodrise01 2016 PIT NL 3.339393939 1.775 1B, 2B, SS, RF, 3B, LF, CF 10 1 PIT TBD 2015 2016 ATL
5666 5666 Chris Stewart 34 stewach01 2016 PIT NL 1.103367003 -0.145 C, 1B 1 1 PIT NYY 2014 2017 ATL
5697 5697 Matt Kemp 31 kempma01 2016 SDP NL 4.39254964 0.29 RF, LF 7 1 SDP LAD 2015 2016 ATL
5854 5854 Jaime Garcia 29 garcija02 2016 STL NL 4.751700427 0.955 P 9 1 STL   2008 2016 ATL
5859 5859 Matt Adams 27 adamsma01 2016 STL NL 3.216211633 0.565 1B 6 1 STL   2012 2017 ATL
5871 5871 Miguel Socolovich 29 socolmi01 2016 STL NL 0.372996761 0.275 P 1 1 STL CHC 2015 2017 ATL
5910 5910 Chase Whitley 27 whitlch01 2016 TBR AL 0.448478163 0.14 P 1 1 TBD NYY 2016 2017 ATL
5979 5979 Luke Jackson 24 jackslu01 2016 TEX AL 0.339793528 -0.59 P 0 1 TEX   2015 2016 ATL
5994 5994 Jose Bautista 35 bautijo02 2016 TOR AL 4.836451613 1.295 RF, 1B 10 1 TOR PIT 2008 2017 ATL
5996 5996 R.A. Dickey 41 dicker.01 2016 TOR AL 4.766068128 0.61 P 8 1 TOR NYM 2013 2016 ATL
6076 6076 Ender Inciarte 24 inciaen01 2015 ARI NL 5.471330082 3.79 RF, LF, CF 18 1 ARI   2014 2015 ATL
6088 6088 Josh Collmenter 29 collmjo01 2015 ARI NL 2.793215019 0.865 P 6 1 ARI   2011 2016 ATL
6101 6101 Jhoulys Chacin 27 chacijh01 2015 ARI NL 0.751090616 0.215 P 2 1 ARI COL 2015 2015 ATL
6191 6191 Darren O'Day 32 odayda01 2015 BAL AL 2.422613266 2.28 P 10 1 BAL TEX 2012 2018 ATL
6193 6193 Brad Brach 29 brachbr01 2015 BAL AL 2.602778215 1.435 P 8 1 BAL SDP 2014 2018 ATL
6194 6194 Kevin Gausman 24 gausmke01 2015 BAL AL 3.136914897 1.345 P 8 1 BAL   2013 2018 ATL

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