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,037 rows where prev_franch = "ATL"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, lg_ID, 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
104 104 Rio Ruiz 25 ruizri01 2019 BAL AL 3.863471074 0.590943396 3B, 1B, 2B 6 1 BAL ATL 2019 2019  
119 119 Evan Phillips 24 phillev01 2019 BAL AL 0.706013341 0.112075472 P 1 1 BAL ATL 2018 2019  
232 232 Brad Brach 33 brachbr01 2019 CHC NL 1.189527491 -0.020377358 P 1 1 CHC ATL 2019 2019 NYM
280 280 Manny Banuelos 28 banuema01 2019 CHW AL 1.294418749 -0.399873418 P 1 1 CHW ATL 2019 2019  
320 320 Lucas Sims 25 simslu01 2019 CIN NL 1.13643691 0.366792453 P 3 1 CIN ATL 2018 2019  
327 327 Kevin Gausman 28 gausmke01 2019 CIN NL 0.572838117 0.198679245 P 1 2 CIN ATL 2019 2019  
396 396 Ryan Flaherty 32 flahery01 2019 CLE AL 0.173942019 -0.26490566 3B, 2B 0 1 CLE ATL 2019 2019  
440 440 Wes Parsons 26 parsowe01 2019 COL NL 0.47809821 -0.290377358 P 0 2 COL ATL 2019 2019  
493 493 Dustin Peterson 24 peterdu01 2019 DET AL 0.461018096 -0.405 LF, CF, RF, 1B 0 1 DET ATL 2019 2019  
598 598 Lucas Duda 33 dudalu01 2019 KCR AL 1.158248028 -0.860943396 1B 0 1 KCR ATL 2019 2019  
606 606 Andrelton Simmons 29 simmoan01 2019 LAA AL 3.908304781 1.635283019 SS 10 1 ANA ATL 2016 2019  
641 641 Sam Freeman 32 freemsa01 2019 LAA AL 0.038489964 -0.035660377 P 0 1 ANA ATL 2019 2019  
651 651 Peter Bourjos 32 bourjpe01 2019 LAA AL 0.435307554 -0.458490566 LF, CF, 2B 0 1 ANA ATL 2019 2019  
891 891 Rene Rivera 35 riverre01 2019 NYM NL 0.15890411 -0.086603774 C 0 1 NYM ATL 2019 2019  
1215 1215 David Freitas 30 freitda01 2019 SEA AL 0.038245961 -0.020377358 C 0 1 SEA ATL 2018 2019 MIL
1234 1234 Jesse Biddle 27 biddlje01 2019 SEA AL 0.284923112 -0.376981132 P 0 2 SEA ATL 2019 2019 TEX
1291 1291 Michael Reed 26 reedmi02 2019 SFG NL 0.080429884 -0.213962264 LF, RF 0 1 SFG ATL 2019 2019  
1318 1318 John Gant 26 gantjo01 2019 STL NL 2.374516493 0.764150943 P 6 1 STL ATL 2017 2019  
1366 1366 Chaz Roe 32 roech01 2019 TBR AL 1.767164016 0.524716981 P 4 1 TBD ATL 2017 2019  
1405 1405 Danny Santana 28 santada01 2019 TEX AL 4.766336634 2.307735849 1B, CF, 2B, LF, RF, SS, 3B 14 1 TEX ATL 2019 2019  
1419 1419 Kolby Allard 21 allarko01 2019 TEX AL 1.327160632 0.973018868 P 5 1 TEX ATL 2019 2019  
1522 1522 Anibal Sanchez 35 sanchan01 2019 WSN NL 4.78268823 2.873207547 P 15 1 WSN ATL 2019 2019  
1530 1530 Kurt Suzuki 35 suzukku01 2019 WSN NL 3.026347512 0.351509434 C 5 1 WSN ATL 2019 2019  
1550 1550 Jonny Venters 34 ventejo01 2019 WSN NL 0.165370102 -0.112075472 P 0 2 WSN ATL 2019 2019  
1601 1601 Chris Stewart 36 stewach01 2018 ARI NL 0.009957082 -0.015 C 0 2 ARI ATL 2018 2018  
1607 1607 Randall Delgado 28 delgara01 2018 ARI NL 0.264348058 -0.19 P 0 1 ARI ATL 2013 2018  
1613 1613 Shelby Miller 27 millesh01 2018 ARI NL 0.465917074 -0.7 P 0 1 ARI ATL 2016 2018 TEX
1722 1722 Evan Phillips 23 phillev01 2018 BAL AL 0.131994905 -0.415 P 0 2 BAL ATL 2018 2019  
1797 1797 Tommy La Stella 29 lasteto01 2018 CHC NL 1.843708609 0.074539877 3B, 2B, P 3 1 CHC ATL 2015 2018 ANA
1898 1898 Matt Wisler 25 wislema01 2018 CIN NL 0.283350977 0.19 P 1 2 CIN ATL 2018 2018 SDP
1908 1908 Lucas Sims 24 simslu01 2018 CIN NL 0.143082195 -0.105 P 0 2 CIN ATL 2018 2019  
1914 1914 Preston Tucker 27 tuckepr01 2018 CIN NL 0.413371797 -0.235 LF, RF 0 2 CIN ATL 2018 2018  
1970 1970 Alexi Ogando 34 ogandal01 2018 CLE AL 0.041986154 -0.14 P 0 1 CLE ATL 2018 2018  
2013 2013 Daniel Castro 25 castrda01 2018 COL NL 0.46654116 -0.616196319 2B, SS 0 1 COL ATL 2018 2018  
2083 2083 Evan Gattis 31 gattiev01 2018 HOU AL 4.273484725 0.125 C 6 1 HOU ATL 2015 2018  
2156 2156 Andrelton Simmons 28 simmoan01 2018 LAA AL 5.718041407 5.785 SS 25 1 ANA ATL 2016 2019  
2190 2190 Jim Johnson 35 johnsji04 2018 LAA AL 1.98346734 -0.4 P 1 1 ANA ATL 2018 2018  
2194 2194 Ian Krol 27 krolia01 2018 LAA AL 0.043655262 0.045 P 0 1 ANA ATL 2018 2018  
2201 2201 Akeel Morris 25 morriak01 2018 LAA AL 0.245798106 -0.135 P 0 1 ANA ATL 2018 2018  
2228 2228 Matt Kemp 33 kempma01 2018 LAD NL 4.871037344 1.321840491 LF, RF 10 1 LAD ATL 2018 2018 CIN
2229 2229 Alex Wood 27 woodal02 2018 LAD NL 4.195648743 1.480858896 P 9 1 LAD ATL 2015 2018 CIN
2423 2423 Ervin Santana 35 santaer01 2018 MIN AL 0.68744389 -0.55 P 0 1 MIN ATL 2015 2018 CHW
2436 2436 Jose Bautista 37 bautijo02 2018 NYM NL 2.997262149 0.875 RF, LF, 3B, 1B, 2B 7 2 NYM ATL 2018 2018 PHI
2517 2517 Chasen Shreve 27 shrevch01 2018 NYY AL 1.051227836 -0.135 P 1 1 NYY ATL 2015 2018 STL
2524 2524 Jace Peterson 28 peterja01 2018 NYY AL 0.102096335 -0.085 3B, LF, 2B, RF, SS, P 0 1 NYY ATL 2018 2018 BAL
2658 2658 Sean Rodriguez 33 rodrise01 2018 PIT NL 1.744740045 -0.206273292 2B, SS, LF, CF, RF, 1B, 3B 2 1 PIT ATL 2017 2018 PHI
2765 2765 David Freitas 29 freitda01 2018 SEA AL 1.013685078 -0.05 C, 1B 1 1 SEA ATL 2018 2019 MIL
2767 2767 Rob Whalen 24 whalero01 2018 SEA AL 0.087316647 0.095 P 0 1 SEA ATL 2017 2018  
2811 2811 Casey Kelly 28 kellyca01 2018 SFG NL 0.593525155 0.105 P 1 1 SFG ATL 2018 2018  
2812 2812 Cory Gearrin 32 gearrco01 2018 SFG NL 0.864776817 -0.1 P 1 1 SFG ATL 2015 2018 TEX
2841 2841 John Gant 25 gantjo01 2018 STL NL 3.239222898 0.83 P 7 1 STL ATL 2017 2019  
2880 2880 Mallex Smith 25 smithma05 2018 TBR AL 5.111291106 3.51 CF, RF, LF 17 1 TBD ATL 2017 2018 SEA
2903 2903 Chaz Roe 31 roech01 2018 TBR AL 1.755452413 0.42 P 4 1 TBD ATL 2017 2019  
2918 2918 Jonny Venters 33 ventejo01 2018 TBR AL 0.436665598 0.135 P 1 1 TBD ATL 2018 2018 ATL
2922 2922 Brandon Snyder 31 snydebr03 2018 TBR AL 0.056374534 0.035 3B 0 1 TBD ATL 2018 2018  
2977 2977 Carlos Perez 27 perezca02 2018 TEX AL 0.500325521 -0.49 C 0 2 TEX ATL 2018 2018  
3058 3058 Matt Adams 29 adamsma01 2018 WSN NL 2.701530183 1.025 1B, LF, RF 6 1 WSN ATL 2018 2018 STL
3116 3116 Randall Delgado 27 delgara01 2017 ARI NL 1.627602839 0.79 P 5 1 ARI ATL 2013 2018  
3124 3124 Shelby Miller 26 millesh01 2017 ARI NL 0.620935187 0.44 P 2 1 ARI ATL 2016 2018 TEX
3240 3240 Paul Janish 34 janispa01 2017 BAL AL 0.265272787 -0.625 SS 0 1 BAL ATL 2015 2017  
3277 3277 Chase d'Arnaud 30 darnach01 2017 BOS AL 0.009184481 0.075 SS, LF, 2B, 3B, 1B, RF 0 2 BOS ATL 2017 2017 SDP
3313 3313 Tommy La Stella 28 lasteto01 2017 CHC NL 1.476150346 0.53 2B, 3B, 1B 4 1 CHC ATL 2015 2018 ANA
3582 3582 Evan Gattis 30 gattiev01 2017 HOU AL 3.019865428 1.255 C, 1B 8 1 HOU ATL 2015 2018  
3621 3621 Mike Minor 29 minormi01 2017 KCR AL 2.876079599 2.535 P 12 1 KCR ATL 2017 2017 TEX
3629 3629 Peter Moylan 38 moylape01 2017 KCR AL 2.002265854 0.735 P 5 1 KCR ATL 2016 2017 ATL
3663 3663 Andrelton Simmons 27 simmoan01 2017 LAA AL 6.200594845 5.985 SS 27 1 ANA ATL 2016 2019  
3697 3697 Brandon Phillips 36 phillbr01 2017 LAA AL 1.006278916 -0.05 2B, 3B 1 2 ANA ATL 2017 2017 BOS
3724 3724 Alex Wood 26 woodal02 2017 LAD NL 4.354449303 2.865 P 15 1 LAD ATL 2015 2018 CIN
3738 3738 Luis Avilan 27 avilalu01 2017 LAD NL 1.391036678 0.595 P 4 1 LAD ATL 2015 2017 CHW
3806 3806 Hunter Cervenka 27 cervehu01 2017 MIA NL 0.119551826 -0.255 P 0 1 FLA ATL 2016 2017  
3864 3864 Ervin Santana 34 santaer01 2017 MIN AL 6.028787514 3.885 P 20 1 MIN ATL 2015 2018 CHW
3884 3884 Bartolo Colon 44 colonba01 2017 MIN AL 2.270051544 0.145 P 4 2 MIN ATL 2017 2017 TEX
3890 3890 Jaime Garcia 30 garcija02 2017 MIN AL 0.189170962 0.145 P 1 2 MIN ATL 2017 2017 NYY
3990 3990 Chasen Shreve 26 shrevch01 2017 NYY AL 1.299738084 0.375 P 3 1 NYY ATL 2015 2018 STL
4056 4056 Ryan Lavarnway 29 lavarry01 2017 OAK AL 0.123545797 0.04 C 0 1 OAK ATL 2017 2017 PIT
4108 4108 Pedro Beato 30 beatope01 2017 PHI NL 0.015241181 0.015 P 0 1 PHI ATL 2017 2017  
4154 4154 Sean Rodriguez 32 rodrise01 2017 PIT NL 1.057629451 -0.295 3B, RF, 2B, SS, LF, CF, 1B 1 2 PIT ATL 2017 2018 PHI
4189 4189 Ryan Buchter 30 buchtry01 2017 SDP NL 1.317570856 0.315 P 3 1 SDP ATL 2016 2017 KCR
4212 4212 Christian Bethancourt 25 bethach01 2017 SDP NL 0.059405512 -0.295 P, 2B 0 1 SDP ATL 2016 2017  
4260 4260 Ryan Weber 26 weberry01 2017 SEA AL 0.101457019 0.11 P 0 1 SEA ATL 2017 2017 TBD
4267 4267 Rob Whalen 23 whalero01 2017 SEA AL 0.157339763 -0.06 P 0 1 SEA ATL 2017 2018  
4268 4268 Shae Simmons 26 simmosh01 2017 SEA AL 0.19398661 -0.075 P 0 1 SEA ATL 2017 2017  
4291 4291 Cory Gearrin 31 gearrco01 2017 SFG NL 1.956196781 1.335 P 7 1 SFG ATL 2015 2018 TEX
4368 4368 John Gant 24 gantjo01 2017 STL NL 0.36357454 -0.095 P 0 1 STL ATL 2017 2019  
4390 4390 Mallex Smith 24 smithma05 2017 TBR AL 2.671675923 1.245 CF, LF, RF 7 1 TBD ATL 2017 2018 SEA
4414 4414 Chaz Roe 30 roech01 2017 TBR AL 0.221399392 0.225 P 1 2 TBD ATL 2017 2019  
4457 4457 Dario Alvarez 28 alvarda01 2017 TEX AL 0.558446347 0.165 P 1 1 TEX ATL 2016 2017  
4542 4542 Jason Grilli 40 grillja01 2017 TOR AL 0.647143612 -0.635 P 0 1 TOR ATL 2016 2017 TEX
4606 4606 Michael Bourn 33 bournmi01 2016 ARI NL 3.503881201 0.06 CF, LF, RF 5 1 ARI ATL 2016 2016 BAL
4608 4608 Randall Delgado 26 delgara01 2016 ARI NL 2.218276347 0.445 P 4 1 ARI ATL 2013 2018  
4610 4610 Phil Gosselin 27 gosseph01 2016 ARI NL 2.348970638 0.375 2B, 3B, 1B, LF, RF 4 1 ARI ATL 2015 2016 PIT
4616 4616 Shelby Miller 25 millesh01 2016 ARI NL 2.780239689 -0.245 P, LF 3 1 ARI ATL 2016 2018 TEX
4740 4740 Paul Janish 33 janispa01 2016 BAL AL 0.33492823 -0.06 3B, SS 0 1 BAL ATL 2015 2017  
4818 4818 Tommy La Stella 27 lasteto01 2016 CHC NL 1.651558551 0.57 3B, 2B 4 1 CHC ATL 2015 2018 ANA
4821 4821 Trevor Cahill 28 cahiltr01 2016 CHC NL 1.805521822 0.43 P 4 1 CHC ATL 2015 2016 SDP
4984 4984 Ross Detwiler 30 detwiro01 2016 CLE AL 0.130932802 -0.055341615 P 0 1 CLE ATL 2016 2016 OAK
5028 5028 David Hale 28 haleda02 2016 COL NL 0.040296917 -0.105 P 0 1 COL ATL 2015 2016 NYY
5048 5048 Cameron Maybin 29 maybica01 2016 DET AL 3.715268676 2.153291925 CF 12 1 DET ATL 2016 2016 ANA
5065 5065 Erick Aybar 32 aybarer01 2016 DET AL 0.864678899 0.206273292 SS, 3B, 2B 2 2 DET ATL 2016 2016 SDP
5088 5088 Evan Gattis 29 gattiev01 2016 HOU AL 4.682413849 3.015 C 15 1 HOU ATL 2015 2018  

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