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,430 rows where prev_franch = "STL"

✎ 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
6 6 Carson Kelly 24 kellyca02 2019 ARI NL 3.559068502 1.900188679 C, 3B 11 1 ARI STL 2019 2019  
11 11 Luke Weaver 25 weavelu01 2019 ARI NL 1.810155165 1.803396226 P 8 1 ARI STL 2019 2019  
208 208 Jason Heyward 29 heywaja01 2019 CHC NL 5.955718271 1.986792453 RF, CF 13 1 CHC STL 2016 2019  
324 324 Matt Bowman 28 bowmama01 2019 CIN NL 0.663262325 0.229245283 P 2 1 CIN STL 2019 2019  
480 480 Tyson Ross 32 rossty01 2019 DET AL 1.024995629 -0.025632911 P 1 1 DET STL 2019 2019  
612 612 Albert Pujols 39 pujolal01 2019 LAA AL 5.072279328 0.142641509 1B, 3B 7 1 ANA STL 2012 2019  
700 700 Jedd Gyorko 30 gyorkje01 2019 LAD NL 0.329829399 -0.310754717 3B, 1B, 2B, P 0 2 LAD STL 2019 2019  
703 703 Sandy Alcantara 23 alcansa01 2019 MIA NL 5.563620343 2.358679245 P 15 1 FLA STL 2018 2019  
723 723 Magneuris Sierra 23 sierrma01 2019 MIA NL 0.43268206 0.382075472 CF, RF 2 1 FLA STL 2018 2019  
914 914 Luke Voit 28 voitlu01 2019 NYY AL 4.758146389 1.89 1B 13 1 NYY STL 2018 2019  
972 972 Stephen Piscotty 28 piscost01 2019 OAK AL 3.67579016 0.855849057 RF 8 1 OAK STL 2018 2019  
1101 1101 Steven Baron 28 baronst01 2019 PIT NL 0.089876033 -0.122264151 C 0 1 PIT STL 2019 2019  
1106 1106 Tyler Lyons 31 lyonsty01 2019 PIT NL 0.197076397 -0.259811321 P 0 1 PIT STL 2019 2019 NYY
1125 1125 Greg Garcia 29 garcigr01 2019 SDP NL 3.73828125 1.411132075 2B, 3B, SS, 1B, LF 9 1 SDP STL 2019 2019  
1171 1171 Marco Gonzales 27 gonzama02 2019 SEA AL 5.650975061 3.397924528 P 18 1 SEA STL 2017 2019  
1176 1176 Mike Leake 31 leakemi01 2019 SEA AL 3.949916242 1.569056604 P 10 1 SEA STL 2017 2019 ARI
1193 1193 Sam Tuivailala 26 tuivasa01 2019 SEA AL 0.708915839 0.570566038 P 3 1 SEA STL 2018 2019  
1347 1347 Tommy Pham 31 phamth01 2019 TBR AL 6.046186372 3.555849057 LF 19 1 TBD STL 2018 2019  
1447 1447 Patrick Wisdom 27 wisdopa01 2019 TEX AL 0.267986799 -0.280188679 1B, 3B 0 1 TEX STL 2019 2019  
1462 1462 Randal Grichuk 27 grichra01 2019 TOR AL 5.998323835 0.697924528 RF, CF 10 1 TOR STL 2018 2019  
1531 1531 Matt Adams 30 adamsma01 2019 WSN NL 3.236094369 0.071320755 1B 5 1 WSN STL 2019 2019  
1562 1562 Trevor Rosenthal 29 rosentr01 2019 WSN NL 0.179544682 -0.652075472 P 0 1 WSN STL 2019 2019 DET
1661 1661 Miguel Socolovich 31 socolmi01 2018 ATL NL 0.124181772 -0.1 P 0 1 ATL STL 2018 2018  
1748 1748 Joe Kelly 30 kellyjo05 2018 BOS AL 2.207760807 0.515 P 5 1 BOS STL 2014 2018 LAD
1779 1779 Jason Heyward 28 heywaja01 2018 CHC NL 4.695695364 1.79392638 RF, CF 13 1 CHC STL 2016 2019  
1983 1983 Adam Ottavino 32 ottavad01 2018 COL NL 2.889542198 2.251104294 P 11 1 COL STL 2012 2018 NYY
2166 2166 Albert Pujols 38 pujolal01 2018 LAA AL 4.745974367 0.155 1B 7 1 ANA STL 2012 2019  
2262 2262 Breyvic Valera 26 valerbr01 2018 LAD NL 0.327302905 -0.139141104 2B, 3B, SS, RF 0 1 LAD STL 2018 2018 BAL
2288 2288 Sandy Alcantara 22 alcansa01 2018 MIA NL 0.973835322 0.271677019 P 2 1 FLA STL 2018 2019  
2317 2317 Magneuris Sierra 22 sierrma01 2018 MIA NL 1.56 -1.383540373 CF, RF 0 1 FLA STL 2018 2019  
2384 2384 Lance Lynn 31 lynnla01 2018 MIN AL 2.867214307 0.555 P 6 1 MIN STL 2018 2018 NYY
2395 2395 Zach Duke 35 dukeza01 2018 MIN AL 1.251885102 0.5 P 3 1 MIN STL 2018 2018 SEA
2496 2496 Luke Voit 27 voitlu01 2018 NYY AL 1.373659786 1.62 1B, RF 7 2 NYY STL 2018 2019  
2535 2535 Stephen Piscotty 27 piscost01 2018 OAK AL 5.628809753 2.945 RF 17 1 OAK STL 2018 2019  
2575 2575 Josh Lucas 27 lucasjo02 2018 OAK AL 0.281484118 -0.1 P 0 1 OAK STL 2018 2018 BAL
2576 2576 Dean Kiekhefer 29 kiekhde01 2018 OAK AL 0.03810441 -0.135 P 0 1 OAK STL 2018 2018  
2732 2732 Marco Gonzales 26 gonzama02 2018 SEA AL 4.57867903 2.92 P 16 1 SEA STL 2017 2019  
2735 2735 Mike Leake 30 leakemi01 2018 SEA AL 5.155790585 1.9 P 14 1 SEA STL 2017 2019 ARI
2755 2755 Juan Nicasio 31 nicasju01 2018 SEA AL 1.615357962 -0.2 P 2 1 SEA STL 2018 2018 PHI
2760 2760 Sam Tuivailala 25 tuivasa01 2018 SEA AL 0.15998152 0.155 P 1 2 SEA STL 2018 2019  
2885 2885 Tommy Pham 30 phamth01 2018 TBR AL 1.634861494 2.595 CF, LF 10 2 TBD STL 2018 2019  
2984 2984 Randal Grichuk 26 grichra01 2018 TOR AL 4.427627231 2.13 RF, CF, LF 13 1 TOR STL 2018 2019  
2985 2985 Aledmys Diaz 27 diazal02 2018 TOR AL 4.331791143 1.48 SS, 3B 11 1 TOR STL 2018 2018 HOU
2997 2997 Seunghwan Oh 35 ohse01 2018 TOR AL 1.573629256 1.215 P 6 1 TOR STL 2018 2018 COL
3040 3040 Preston Guilmet 30 guilmpr01 2018 TOR AL 0.153584741 -0.23 P 0 2 TOR STL 2018 2018  
3064 3064 Greg Holland 32 hollagr01 2018 WSN NL 0.75287505 0.84 P 3 2 WSN STL 2018 2018 ARI
3117 3117 Jeremy Hazelbaker 29 hazelje01 2017 ARI NL 0.602315288 0.895 LF, RF, CF 4 1 ARI STL 2017 2017  
3152 3152 Jaime Garcia 30 garcija02 2017 ATL NL 3.225927066 1.56 P 9 1 ATL STL 2017 2017 MIN
3157 3157 Matt Adams 28 adamsma01 2017 ATL NL 3.089921955 0.87 1B, LF 7 2 ATL STL 2017 2017 WSN
3257 3257 Joe Kelly 29 kellyjo05 2017 BOS AL 1.848640702 0.995 P 6 1 BOS STL 2014 2018 LAD
3298 3298 Jason Heyward 27 heywaja01 2017 CHC NL 4.702174279 1.67 RF, CF 12 1 CHC STL 2016 2019  
3303 3303 John Lackey 38 lackejo01 2017 CHC NL 4.834775204 0.84 P 9 1 CHC STL 2016 2017  
3484 3484 Mark Reynolds 33 reynoma01 2017 COL NL 5.865279673 0.835 1B, LF 12 1 COL STL 2016 2017 WSN
3500 3500 Adam Ottavino 31 ottavad01 2017 COL NL 1.68348082 0.075 P 3 1 COL STL 2012 2018 NYY
3632 3632 Brandon Moss 33 mossbr01 2017 KCR AL 3.876333333 -0.71 1B, LF, RF 4 1 KCR STL 2017 2017  
3647 3647 Seth Maness 28 manesse01 2017 KCR AL 0.226616198 -0.045 P 0 1 KCR STL 2017 2017  
3690 3690 Albert Pujols 37 pujolal01 2017 LAA AL 6.095175149 -1.925 1B 3 1 ANA STL 2012 2019  
3859 3859 Michael Blazek 28 blazemi01 2017 MIL NL 0.220082294 -0.34 P 0 1 MIL STL 2013 2017 WSN
3987 3987 Matt Holliday 37 hollima01 2017 NYY AL 3.913098436 -0.01 1B 4 1 NYY STL 2017 2017 COL
4012 4012 Pete Kozma 29 kozmape01 2017 NYY AL 0.09164165 -0.19 3B, SS, 1B, 2B 0 1 NYY STL 2017 2017 TEX
4106 4106 Kevin Siegrist 27 siegrke01 2017 PHI NL 0.124907026 0.09 P 0 2 PHI STL 2017 2017  
4236 4236 Mike Leake 29 leakemi01 2017 SEA AL 0.885443077 1.08 P 4 2 SEA STL 2017 2019 ARI
4244 4244 Marco Gonzales 25 gonzama02 2017 SEA AL 0.911485521 0.145 P 2 2 SEA STL 2017 2019  
4254 4254 Steve Cishek 31 cishest01 2017 SEA AL 0.733923406 0.145 P 1 1 SEA STL 2016 2017 TBD
4701 4701 A.J. Pierzynski 39 pierza.01 2016 ATL NL 2.555631167 -1.499254658 C 0 1 ATL STL 2015 2016  
4776 4776 Joe Kelly 28 kellyjo05 2016 BOS AL 1.385569442 0.135 P 2 1 BOS STL 2014 2018 LAD
4807 4807 John Lackey 37 lackejo01 2016 CHC NL 5.262701613 2.595 P 15 1 CHC STL 2016 2017  
4810 4810 Jason Heyward 26 heywaja01 2016 CHC NL 5.785341196 1.14 RF, CF 11 1 CHC STL 2016 2019  
5005 5005 Mark Reynolds 32 reynoma01 2016 COL NL 4.335989151 0.895 1B, 2B 8 1 COL STL 2016 2017 WSN
5007 5007 Daniel Descalso 29 descada01 2016 COL NL 2.841498559 0.625 SS, 1B, 2B, LF, 3B 6 1 COL STL 2015 2016 ARI
5009 5009 Adam Ottavino 30 ottavad01 2016 COL NL 1.0464894 0.78 P 4 1 COL STL 2012 2018 NYY
5105 5105 Pat Neshek 35 neshepa01 2016 HOU AL 1.501277473 0.54 P 4 1 HOU STL 2015 2016 PHI
5162 5162 Tony Cruz 29 cruzto03 2016 KCR AL 0.048084895 -0.11 C 0 1 KCR STL 2016 2016 CIN
5175 5175 Albert Pujols 36 pujolal01 2016 LAA AL 6.262458472 1.045 1B 12 1 ANA STL 2012 2019  
5194 5194 Fernando Salas 31 salasfe01 2016 LAA AL 2.068227782 -0.085 P 3 1 ANA STL 2014 2016 NYM
5326 5326 Xavier Scruggs 28 scrugxa01 2016 MIA NL 0.687983497 -0.216335404 1B, LF 0 1 FLA STL 2016 2016  
5379 5379 Michael Blazek 27 blazemi01 2016 MIL NL 1.313849553 -0.76 P 0 1 MIL STL 2013 2017 WSN
5485 5485 Carlos Beltran 39 beltrca01 2016 NYY AL 3.716840537 2.11 RF 12 1 NYY STL 2014 2016 TEX
5592 5592 Peter Bourjos 29 bourjpe01 2016 PHI NL 3.912982209 0.115 RF, CF 6 1 PHI STL 2016 2016 TBD
5667 5667 Eric Fryer 30 fryerer01 2016 PIT NL 0.898316498 -0.245 C 1 2 PIT STL 2016 2016 STL
5692 5692 Jon Jay 31 jayjo02 2016 SDP NL 3.811632402 1.045 CF, RF, LF 9 1 SDP STL 2016 2016 CHC
5741 5741 Carlos Villanueva 32 villaca01 2016 SDP NL 2.157199389 -0.96 P 0 1 SDP STL 2016 2016  
5752 5752 Steve Cishek 30 cishest01 2016 SEA AL 2.651286266 1.295 P 8 1 SEA STL 2016 2017 TBD
5830 5830 Ruben Tejada 26 tejadru01 2016 SFG NL 0.373622648 0.04 3B, SS, 2B, P 1 2 SFG STL 2016 2016 BAL
6048 6048 Matt Belisle 36 belisma01 2016 WSN NL 1.229387977 0.86 P 4 1 WSN STL 2016 2016 MIN
6124 6124 Shelby Miller 24 millesh01 2015 ATL NL 5.708225966 3.5 P 19 1 ATL STL 2015 2015 ARI
6132 6132 A.J. Pierzynski 38 pierza.01 2015 ATL NL 4.43493511 1.18 C 10 1 ATL STL 2015 2016  
6242 6242 Joe Kelly 27 kellyjo05 2015 BOS AL 3.752481668 1.085 P 8 1 BOS STL 2014 2018 LAD
6260 6260 Justin Masterson 30 masteju01 2015 BOS AL 1.719466262 -0.08 P 2 1 BOS STL 2015 2015  
6274 6274 Edward Mujica 31 mujiced01 2015 BOS AL 0.422596727 -0.11 P 0 1 BOS STL 2014 2015 OAK
6282 6282 Allen Craig 30 craigal01 2015 BOS AL 0.821635544 -0.795 RF, LF, 1B 0 1 BOS STL 2014 2015  
6303 6303 Jason Motte 33 motteja01 2015 CHC NL 1.629822786 0.31 P 3 1 CHC STL 2015 2015 COL
6453 6453 Marc Rzepczynski 29 rzepcma01 2015 CLE AL 0.681781215 -0.020124224 P 1 1 CLE STL 2013 2015 SDP
6493 6493 Adam Ottavino 29 ottavad01 2015 COL NL 0.363317954 0.61 P 2 1 COL STL 2012 2018 NYY
6511 6511 Daniel Descalso 28 descada01 2015 COL NL 2.108173913 -0.8 SS, 2B, 1B, 3B, RF 1 1 COL STL 2015 2016 ARI
6517 6517 Jorge Rondon 27 rondojo01 2015 COL NL 0.01560974 -0.175 P 0 1 COL STL 2015 2015 BAL
6596 6596 Pat Neshek 34 neshepa01 2015 HOU AL 1.971198504 0.19 P 3 1 HOU STL 2015 2016 PHI
6663 6663 Albert Pujols 35 pujolal01 2015 LAA AL 6.423927614 2.31 1B, 3B 17 1 ANA STL 2012 2019  
6666 6666 David Freese 32 freesda01 2015 LAA AL 4.56769437 2.29 3B 14 1 ANA STL 2014 2015 PIT
6682 6682 Fernando Salas 30 salasfe01 2015 LAA AL 2.030499935 0.145 P 4 1 ANA STL 2014 2016 NYM

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