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,002 rows where prev_franch = "KCR"

✎ 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
25 25 Abraham Almonte 30 almonab01 2019 ARI NL 0.37463879 0.504339623 RF, CF 2 1 ARI KCR 2019 2019  
86 86 Billy Hamilton 28 hamilbi02 2019 ATL NL 0.416552668 -0.101886792 CF 0 2 ATL KCR 2019 2019  
118 118 Nate Karns 31 karnsna01 2019 BAL AL 0.127194632 0.193584906 P 1 1 BAL KCR 2019 2019  
190 190 Chris Owings 27 owingch01 2019 BOS AL 0.44812362 -0.152830189 2B, 3B, CF, SS, RF, LF, P 0 2 BOS KCR 2019 2019  
221 221 Alec Mills 27 millsal02 2019 CHC NL 0.710069702 0.509433962 P 2 1 CHC KCR 2018 2019  
222 222 Ben Zobrist 38 zobribe01 2019 CHC NL 1.69874477 0.091698113 2B, RF, LF 2 1 CHC KCR 2016 2019  
246 246 Martin Maldonado 32 maldoma01 2019 CHC NL 0.131450488 -0.244528302 C, 1B 0 2 CHC KCR 2019 2019 HOU
270 270 Ryan Goins 31 goinsry01 2019 CHW AL 1.588235294 0.22556962 3B, SS, RF, 1B, LF 3 1 CHW KCR 2019 2019  
441 441 Drew Butera 35 buterdr01 2019 COL NL 0.456458512 -0.40245283 C, 1B 0 1 COL KCR 2018 2019  
603 603 Brian Goodwin 28 goodwbr01 2019 LAA AL 4.248980258 2.073396226 LF, CF, RF 12 1 ANA KCR 2019 2019  
689 689 Scott Alexander 29 alexasc02 2019 LAD NL 0.595351205 0.010188679 P 1 1 LAD KCR 2018 2019  
747 747 Rosell Herrera 26 herrero02 2019 MIA NL 1.225932504 -0.774339623 CF, RF, LF, 2B, 3B, SS 0 1 FLA KCR 2019 2019  
754 754 Mike Moustakas 30 moustmi01 2019 MIL NL 5.689561374 3.036226415 3B, 2B 18 1 MIL KCR 2018 2019  
756 756 Lorenzo Cain 33 cainlo01 2019 MIL NL 6.074124447 2.02754717 CF 16 1 MIL KCR 2018 2019  
769 769 Manny Pina 32 pinama01 2019 MIL NL 1.725603536 0.840566038 C, 3B 5 1 MIL KCR 2016 2019  
796 796 Burch Smith 29 smithbu03 2019 MIL NL 0.269653652 -0.249622642 P 0 1 MIL KCR 2019 2019 SFG
864 864 Jason Vargas 36 vargaja01 2019 NYM NL 2.565052544 1.21245283 P 7 1 NYM KCR 2018 2019 PHI
973 973 Homer Bailey 33 baileho02 2019 OAK AL 2.022873073 1.365283019 P 7 2 OAK KCR 2019 2019  
982 982 Ryan Buchter 32 buchtry01 2019 OAK AL 1.413859159 0.371886792 P 3 1 OAK KCR 2018 2019  
993 993 Jake Diekman 32 diekmja01 2019 OAK AL 0.660710647 0.040754717 P 1 2 OAK KCR 2019 2019  
995 995 Aaron Brooks 29 brookaa01 2019 OAK AL 1.063475631 -0.076415094 P 1 1 OAK KCR 2015 2019 BAL
1126 1126 Matt Strahm 27 strahma01 2019 SDP NL 3.431653904 1.304150943 P 9 1 SDP KCR 2018 2019  
1127 1127 Eric Hosmer 29 hosmeer01 2019 SDP NL 6.745383523 -0.249622642 1B 9 1 SDP KCR 2018 2019  
1264 1264 Johnny Cueto 33 cuetojo01 2019 SFG NL 0.381410697 0.351509434 P 2 1 SFG KCR 2016 2019  
1403 1403 Mike Minor 31 minormi01 2019 TEX AL 6.131699208 5.924716981 P 27 1 TEX KCR 2018 2019  
1471 1471 Sam Gaviglio 29 gavigsa01 2019 TOR AL 2.279077871 0.54 P 5 1 TOR KCR 2018 2019  
1481 1481 Jason Adam 27 adamja01 2019 TOR AL 0.671101017 0.346415094 P 2 1 TOR KCR 2019 2019  
1586 1586 Jon Jay 33 jayjo02 2018 ARI NL 3.186266094 -0.17 RF, LF, CF 4 2 ARI KCR 2018 2018 CHW
1605 1605 Kris Medlen 32 medlekr01 2018 ARI NL 0.108366285 -0.1 P 0 1 ARI KCR 2018 2018  
1642 1642 Lane Adams 28 adamsla01 2018 ATL NL 0.283977714 0.295 RF, CF, LF 1 1 ATL KCR 2017 2018  
1645 1645 Lucas Duda 32 dudalu01 2018 ATL NL 0.215431369 0.075 1B 1 2 ATL KCR 2018 2018 KCR
1666 1666 Peter Moylan 39 moylape01 2018 ATL NL 0.766526771 -0.22 P 0 1 ATL KCR 2018 2018  
1773 1773 Ben Zobrist 37 zobribe01 2018 CHC NL 4.993377483 3.41392638 2B, RF, LF, 1B 18 1 CHC KCR 2016 2019  
1799 1799 Alec Mills 26 millsal02 2018 CHC NL 0.384060193 0.332944785 P 2 1 CHC KCR 2018 2019  
1806 1806 Terrance Gore 27 gorete01 2018 CHC NL 0.048013245 0.119263804 LF 0 1 CHC KCR 2018 2018 KCR
1834 1834 Joakim Soria 34 soriajo01 2018 CHW AL 1.366142127 1.215 P 5 1 CHW KCR 2018 2018 MIL
1917 1917 Tony Cruz 31 cruzto03 2018 CIN NL 0.255896827 -0.29 C 0 1 CIN KCR 2018 2018  
1924 1924 Brandon Finnegan 25 finnebr01 2018 CIN NL 0.582477168 -0.53 P 0 1 CIN KCR 2015 2018  
1941 1941 Melky Cabrera 33 cabreme01 2018 CLE AL 2.56997131 0.185 RF, LF 4 1 CLE KCR 2018 2018 PIT
2006 2006 Drew Butera 34 buterdr01 2018 COL NL 0.158822523 0.00993865 C, 1B, P 0 2 COL KCR 2018 2019  
2200 2200 Miguel Almonte 25 almonmi01 2018 LAA AL 0.14172143 -0.125 P 0 1 ANA KCR 2018 2018  
2238 2238 Scott Alexander 28 alexasc02 2018 LAD NL 2.187154805 0.228588957 P 3 1 LAD KCR 2018 2019  
2319 2319 Lorenzo Cain 32 cainlo01 2018 MIL NL 6.079459003 6.261349693 CF 28 1 MIL KCR 2018 2019  
2326 2326 Manny Pina 31 pinama01 2018 MIL NL 3.304480135 1.13797546 C, 1B 9 1 MIL KCR 2016 2019  
2338 2338 Mike Moustakas 29 moustmi01 2018 MIL NL 2.13761623 0.546625767 3B, 1B 5 2 MIL KCR 2018 2019  
2445 2445 Jason Vargas 35 vargaja01 2018 NYM NL 2.514255062 0.02 P 3 1 NYM KCR 2018 2019 PHI
2541 2541 Trevor Cahill 30 cahiltr01 2018 OAK AL 3.014645074 1.65 P 9 1 OAK KCR 2018 2018 ANA
2554 2554 Ryan Buchter 31 buchtry01 2018 OAK AL 1.233605857 0.49 P 3 1 OAK KCR 2018 2019  
2570 2570 Aaron Brooks 28 brookaa01 2018 OAK AL 0.039472261 0.04 P 0 1 OAK KCR 2015 2019 BAL
2681 2681 Eric Hosmer 28 hosmeer01 2018 SDP NL 6.809920222 0.67 1B 12 1 SDP KCR 2018 2019  
2693 2693 Matt Strahm 26 strahma01 2018 SDP NL 1.870653567 1.08 P 6 1 SDP KCR 2018 2019  
2768 2768 Justin Grimm 29 grimmju01 2018 SEA AL 0.079693765 0.06 P 0 2 SEA KCR 2018 2018  
2770 2770 Mike Morin 27 morinmi01 2018 SEA AL 0.092068573 0.025 P 0 1 SEA KCR 2018 2018 MIN
2800 2800 Johnny Cueto 32 cuetojo01 2018 SFG NL 1.428467172 0.635 P 4 1 SFG KCR 2016 2019  
2932 2932 Mike Minor 30 minormi01 2018 TEX AL 4.479145135 3.185 P 15 1 TEX KCR 2018 2019  
2990 2990 Sam Gaviglio 28 gavigsa01 2018 TOR AL 3.665709403 0.76 P 8 1 TOR KCR 2018 2019  
2991 2991 Kendrys Morales 35 moralke01 2018 TOR AL 4.513879709 0.525 1B, 3B, P 8 1 TOR KCR 2017 2018 OAK
3075 3075 Tim Collins 28 colliti01 2018 WSN NL 0.65417983 -0.01 P 1 1 WSN KCR 2018 2018 CHC
3076 3076 Kelvin Herrera 28 herreke01 2018 WSN NL 0.58618979 -0.06 P 1 2 WSN KCR 2018 2018 CHW
3125 3125 Rey Fuentes 26 fuentre01 2017 ARI NL 1.431733061 -0.085 CF, LF, RF 2 1 ARI KCR 2017 2017  
3162 3162 Lane Adams 27 adamsla01 2017 ATL NL 1.200542925 0.57 LF, CF, RF 3 1 ATL KCR 2017 2018  
3219 3219 Francisco Pena 27 penafr01 2017 BAL AL 0.094740281 0.315 C 1 1 BAL KCR 2016 2017 STL
3306 3306 Wade Davis 31 daviswa01 2017 CHC NL 2.31612735 1.49 P 8 1 CHC KCR 2017 2017 COL
3308 3308 Ben Zobrist 36 zobribe01 2017 CHC NL 4.848811731 0.415 2B, LF, RF, 1B, SS 8 1 CHC KCR 2016 2019  
3368 3368 Al Alburquerque 31 albural01 2017 CHW AL 0.233283087 0.265 P 1 2 CHW KCR 2017 2017  
3415 3415 Luke Farrell 26 farrelu01 2017 CIN NL 0.227258757 0.105 P 1 2 CIN KCR 2017 2017 CHC
3417 3417 Brandon Finnegan 24 finnebr01 2017 CIN NL 0.385351805 0.025 P 1 1 CIN KCR 2015 2018  
3489 3489 Greg Holland 31 hollagr01 2017 COL NL 2.474188177 1.28 P 8 1 COL KCR 2017 2017 STL
3713 3713 Brooks Pounders 26 poundbr01 2017 LAA AL 0.20613704 -0.3 P 0 1 ANA KCR 2017 2017 COL
3779 3779 Edinson Volquez 33 volqued01 2017 MIA NL 2.632935812 0.865 P 6 1 FLA KCR 2017 2017 TEX
3804 3804 Christian Colon 28 colonch01 2017 MIA NL 0.371669477 -0.055 3B, 2B 0 2 FLA KCR 2017 2017 CIN
3820 3820 Manny Pina 30 pinama01 2017 MIL NL 3.578278055 2.15 C 12 1 MIL KCR 2016 2019  
4028 4028 Ryan Madson 36 madsory01 2017 OAK AL 1.397846926 1.245 P 6 1 OAK KCR 2016 2017 WSN
4082 4082 Daniel Nava 34 navada01 2017 PHI NL 2.130084091 1.085 LF, RF, 1B 6 1 PHI KCR 2017 2017  
4194 4194 Dusty Coleman 30 colemdu01 2017 SDP NL 0.729236763 0.23 SS 2 1 SDP KCR 2017 2017  
4201 4201 Travis Wood 30 woodtr01 2017 SDP NL 1.481806656 -0.59 P 1 2 SDP KCR 2017 2017  
4228 4228 Jarrod Dyson 32 dysonja01 2017 SEA AL 3.684639192 2.405 CF, LF 12 1 SEA KCR 2017 2017 ARI
4289 4289 Johnny Cueto 31 cuetojo01 2017 SFG NL 4.128622567 1.425 P 10 1 SFG KCR 2016 2019  
4329 4329 Orlando Calixte 25 calixor01 2017 SFG NL 0.548204159 -0.74 LF, 3B, SS, RF, CF 0 1 SFG KCR 2017 2017  
4395 4395 Jake Odorizzi 27 odorija01 2017 TBR AL 3.912686846 0.11 P 5 1 TBD KCR 2013 2017 MIN
4422 4422 Justin Marks 29 marksju01 2017 TBR AL 0.022188598 -0.06 P 0 1 TBD KCR 2016 2017  
4472 4472 Dillon Gee 31 geedi01 2017 TEX AL 0.302962382 -0.11 P 0 1 TEX KCR 2017 2017 MIN
4493 4493 Kendrys Morales 34 moralke01 2017 TOR AL 5.75269168 -0.235 1B 8 1 TOR KCR 2017 2018 OAK
4584 4584 Jeremy Guthrie 38 guthrje01 2017 WSN NL 0.018585126 -0.26 P 0 1 WSN KCR 2017 2017  
4743 4743 Francisco Pena 26 penafr01 2016 BAL AL 0.411483254 -0.195 C 0 1 BAL KCR 2016 2017 STL
4805 4805 Ben Zobrist 35 zobribe01 2016 CHC NL 6.166470093 3.84 2B, LF, RF, 1B, SS 20 1 CHC KCR 2016 2019  
4901 4901 Brandon Finnegan 23 finnebr01 2016 CIN NL 4.878254998 1.35 P 12 1 CIN KCR 2015 2018  
4970 4970 Joba Chamberlain 30 chambjo03 2016 CLE AL 0.484898653 0.266645963 P 2 1 CLE KCR 2016 2016  
5008 5008 Jorge De La Rosa 35 rosajo01 2016 COL NL 3.812826607 0.245 P 6 1 COL KCR 2008 2016 ARI
5181 5181 Johnny Giavotella 28 giavojo01 2016 LAA AL 3.535880399 0.305 2B 6 1 ANA KCR 2015 2016 BAL
5258 5258 Louis Coleman 30 colemlo01 2016 LAD NL 1.4764023 -0.23 P 1 1 LAD KCR 2016 2016 DET
5357 5357 Manny Pina 29 pinama01 2016 MIL NL 0.816759388 0.19 C 2 1 MIL KCR 2016 2019  
5360 5360 Will Smith 26 smithwi04 2016 MIL NL 0.848448328 -0.04 P 1 1 MIL KCR 2014 2016 SFG
5539 5539 Ryan Madson 35 madsory01 2016 OAK AL 2.819856408 0.9 P 7 1 OAK KCR 2016 2017 WSN
5543 5543 Coco Crisp 36 crispco01 2016 OAK AL 4.196732244 0.115 LF, CF 6 1 OAK KCR 2010 2016 CLE
5553 5553 Billy Butler 30 butlebi03 2016 OAK AL 2.340113371 -0.25 1B 3 1 OAK KCR 2015 2016 NYY
5576 5576 Brett Eibner 27 eibnebr01 2016 OAK AL 1.189396465 -0.6 CF, RF, LF 0 2 OAK KCR 2016 2016 LAD
5620 5620 Michael Mariot 27 mariomi01 2016 PHI NL 0.700956344 -0.28 P 0 1 PHI KCR 2016 2016  
5699 5699 James Shields 34 shielja02 2016 SDP NL 1.911741031 0.615 P 5 1 SDP KCR 2015 2016 CHW
5799 5799 Johnny Cueto 30 cuetojo01 2016 SFG NL 5.851135796 4.95 P 22 1 SFG KCR 2016 2019  

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