mlb-quasi-win-shares: quasi_winshares.csv

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

98,796 rows

View and edit SQL

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
101 Renato Nunez 25 nunezre01 2019 BAL AL 5.608264462999999 0.825283019 1B, 3B, LF 9 1 BAL TEX 2018 2019  
102 Anthony Santander 24 santaan02 2019 BAL AL 3.882644628 1.018867925 RF, LF, CF 8 1 BAL   2017 2019  
103 Pedro Severino 25 severpe01 2019 BAL AL 3.2690909089999995 0.8864150940000001 C 6 1 BAL WSN 2019 2019  
104 Rio Ruiz 25 ruizri01 2019 BAL AL 3.8634710739999996 0.590943396 3B, 1B, 2B 6 1 BAL ATL 2019 2019  
105 Asher Wojciechowski 30 wojcias01 2019 BAL AL 2.165530176 0.820188679 P 5 1 BAL CIN 2019 2019  
106 Shawn Armstrong 28 armstsh01 2019 BAL AL 1.8989306430000001 0.53490566 P 4 2 BAL SEA 2019 2019  
107 Miguel Castro 24 castrmi01 2019 BAL AL 2.240454464 0.499245283 P 4 1 BAL COL 2017 2019  
108 Mychal Givens 29 givenmy01 2019 BAL AL 2.519731894 0.438113208 P 4 1 BAL   2015 2019  
109 Austin Hays 23 haysau01 2019 BAL AL 0.632727273 0.748867925 CF 3 1 BAL   2017 2019  
110 Richard Bleier 32 bleieri01 2019 BAL AL 1.627498961 0.361698113 P 3 1 BAL NYY 2017 2019  
111 Aaron Brooks 29 brookaa01 2019 BAL AL 1.720608757 0.27 P 3 2 BAL OAK 2019 2019  
112 Paul Fry 26 frypa01 2019 BAL AL 2.167920271 -0.00509434 P 3 1 BAL   2018 2019  
113 Gabriel Ynoa 26 ynoaga01 2019 BAL AL 3.1222956789999996 -0.219056604 P 3 1 BAL NYM 2017 2019  
114 Joey Rickard 28 rickajo01 2019 BAL AL 1.2942148759999998 0.09169811300000001 RF, LF, CF 2 1 BAL   2016 2019 SFG
115 Chance Sisco 24 siscoch01 2019 BAL AL 1.859834711 -0.117169811 C, 1B 2 1 BAL   2017 2019  
116 Dwight Smith Jr. 26 smithdw02 2019 BAL AL 3.7196694210000003 -0.799811321 LF 2 1 BAL TOR 2019 2019  
117 Hunter Harvey 24 harvehu01 2019 BAL AL 0.228046258 0.208867925 P 1 1 BAL   2019 2019  
118 Nate Karns 31 karnsna01 2019 BAL AL 0.127194632 0.193584906 P 1 1 BAL KCR 2019 2019  
119 Evan Phillips 24 phillev01 2019 BAL AL 0.7060133409999999 0.112075472 P 1 1 BAL ATL 2018 2019  
120 Keon Broxton 29 broxtke01 2019 BAL AL 1.0737190079999999 0.071320755 CF, LF, RF 1 2 BAL NYM 2019 2019 SEA
121 Austin Wynns 28 wynnsau01 2019 BAL AL 0.632727273 -0.025471697999999997 C 1 1 BAL   2018 2019  
122 Tanner Scott 24 scottta01 2019 BAL AL 0.62672453 -0.035660377 P 1 1 BAL   2017 2019  
123 Dillon Tate 25 tatedi01 2019 BAL AL 0.656081135 -0.071320755 P 1 1 BAL   2019 2019  
124 Jace Peterson 29 peterja01 2019 BAL AL 1.035371901 -0.157924528 LF, 3B, 2B, RF 1 1 BAL NYY 2018 2019  
125 Branden Kline 27 klinebr01 2019 BAL AL 1.295119851 -0.16811320800000001 P 1 1 BAL   2019 2019  
126 Stevie Wilkerson 27 wilkest01 2019 BAL AL 3.374545455 -0.830377358 CF, LF, 2B, RF, P 1 1 BAL   2018 2019  
127 Josh Lucas 28 lucasjo02 2019 BAL AL 0.317466994 0.040754717 P 0 1 BAL OAK 2019 2019  
128 Ryan Eades 27 eadesry01 2019 BAL AL 0.37404990000000005 0.010188679 P 0 2 BAL MIN 2019 2019  
129 Jose Rondon 25 rondojo02 2019 BAL AL 0.009586777 -0.015283018999999998 2B, SS, 3B, LF, 1B, P 0 2 BAL CHW 2019 2019  
130 Drew Jackson 25 jacksdr01 2019 BAL AL 0.038347107000000005 -0.066226415 CF, LF 0 1 BAL   2019 2019  
131 Pedro Araujo 25 araujpe01 2019 BAL AL 0.011846559 -0.09169811300000001 P 0 1 BAL   2018 2019  
132 Mason Williams 27 willima10 2019 BAL AL 0.325950413 -0.09169811300000001 CF, LF, RF 0 1 BAL CIN 2019 2019  
133 Jesus Sucre 31 sucreje01 2019 BAL AL 0.64231405 -0.10188679199999999 C, 1B, P 0 1 BAL TBD 2019 2019  
134 Yefry Ramirez 25 ramirye01 2019 BAL AL 0.326975416 -0.13754717 P 0 1 BAL   2018 2019 PIT
135 Luis Ortiz 23 ortizlu02 2019 BAL AL 0.09716256599999999 -0.163018868 P 0 1 BAL   2018 2019  
136 Chandler Shepherd 26 shephch01 2019 BAL AL 0.351343996 -0.18339622600000002 P 0 1 BAL   2019 2019  
137 Mark Trumbo 33 trumbma01 2019 BAL AL 0.258842975 -0.193584906   0 1 BAL SEA 2016 2019  
138 Sean Gilmartin 29 gilmase01 2019 BAL AL 0.066195246 -0.219056604 P 0 1 BAL NYM 2018 2019  
139 Jimmy Yacabonis 27 yacabji01 2019 BAL AL 1.073672334 -0.295471698 P 0 1 BAL   2017 2019  
140 Matt Wotherspoon 27 wothema01 2019 BAL AL 0.148393737 -0.305660377 P 0 1 BAL   2019 2019  
141 Mike Wright 29 wrighmi01 2019 BAL AL 0.332534985 -0.310754717 P 0 1 BAL   2015 2019 SEA
142 Josh Rogers 24 rogerjo01 2019 BAL AL 0.29044852600000004 -0.356603774 P 0 1 BAL   2018 2019  
143 Tom Eshelman 25 eshelto01 2019 BAL AL 0.864175293 -0.40245283 P 0 1 BAL   2019 2019  
144 Tayler Scott 27 scottta02 2019 BAL AL 0.148601572 -0.42792452799999997 P 0 2 BAL SEA 2019 2019  
145 Ty Blach 28 blachty01 2019 BAL AL 0.60240791 -0.468679245 P 0 2 BAL SFG 2019 2019  
146 Alex Cobb 31 cobbal01 2019 BAL AL 0.359501494 -0.514528302 P 0 1 BAL TBD 2018 2019  
147 DJ Stewart 25 stewadj01 2019 BAL AL 1.275041322 -0.652075472 RF, LF 0 1 BAL   2018 2019  
148 Cedric Mullins 24 mullice01 2019 BAL AL 0.7094214879999999 -0.779433962 CF 0 1 BAL   2018 2019  
149 David Hess 25 hessda01 2019 BAL AL 2.119910532 -0.988301887 P 0 1 BAL   2018 2019  
150 Richie Martin 24 martiri01 2019 BAL AL 2.885619835 -1.039245283 SS 0 1 BAL   2019 2019  
151 Dan Straily 30 straida01 2019 BAL AL 1.2482532020000001 -1.21245283 P 0 1 BAL FLA 2019 2019  
152 Chris Davis 33 davisch02 2019 BAL AL 3.32661157 -1.21754717 1B, P, RF 0 1 BAL TEX 2011 2019  
153 Mookie Betts 26 bettsmo01 2019 BOS AL 6.374329864 6.816226415 RF, CF 28 1 BOS   2014 2019  
154 Xander Bogaerts 26 bogaexa01 2019 BOS AL 6.264585304 5.766792453 SS 25 1 BOS   2013 2019  
155 Rafael Devers 22 deverra01 2019 BOS AL 6.2920214439999995 5.476415094 3B, SS 24 1 BOS   2017 2019  
156 Eduardo Rodriguez 26 rodried05 2019 BOS AL 5.476864245 4.564528302 P 20 1 BOS   2015 2019  
157 J.D. Martinez 31 martijd02 2019 BOS AL 5.926206243999999 3.24 RF, LF 17 1 BOS ARI 2018 2019  
158 Chris Sale 30 salech01 2019 BOS AL 4.131951293 2.97509434 P 14 1 BOS CHW 2017 2019  
159 Christian Vazquez 28 vazquch01 2019 BOS AL 4.7190160830000005 2.863018868 C, 1B, 3B, 2B 14 1 BOS   2014 2019  
160 Andrew Benintendi 24 beninan01 2019 BOS AL 5.6244087039999995 1.88490566 LF, CF 12 1 BOS   2016 2019  
161 Jackie Bradley Jr. 29 bradlja02 2019 BOS AL 5.075685904 1.8492452830000001 CF, RF 12 1 BOS   2013 2019  
162 Brandon Workman 30 workmbr01 2019 BOS AL 2.6986769589999997 2.56245283 P 11 1 BOS   2013 2019  
163 David Price 33 priceda01 2019 BOS AL 2.994143102 2.15490566 P 10 1 BOS TOR 2016 2019  
164 Rick Porcello 30 porceri01 2019 BOS AL 4.863157895 1.3805660380000002 P 10 1 BOS DET 2015 2019  
165 Brock Holt 31 holtbr01 2019 BOS AL 2.597287922 1.3092452829999999 2B, 1B, RF, SS, 3B, LF 7 1 BOS PIT 2013 2019  
166 Matt Barnes 29 barnema01 2019 BOS AL 2.560341919 1.253207547 P 7 1 BOS   2014 2019  
167 Mitch Moreland 33 morelmi01 2019 BOS AL 2.990539262 1.136037736 1B 7 1 BOS TEX 2017 2019  
168 Michael Chavis 23 chavimi01 2019 BOS AL 3.4935351619999997 0.871132075 1B, 2B, 3B 7 1 BOS   2019 2019  
169 Marcus Walden 30 waldema01 2019 BOS AL 2.5729720769999997 1.130943396 P 6 1 BOS   2018 2019  
170 Josh Taylor 26 taylojo02 2019 BOS AL 1.4898614209999999 1.146226415 P 5 1 BOS   2019 2019  
171 Colten Brewer 26 breweco01 2019 BOS AL 1.4754908869999999 0.336226415 P 3 1 BOS SDP 2019 2019  
172 Ryan Brasier 31 brasiry01 2019 BOS AL 1.8266987909999999 0.193584906 P 3 1 BOS ANA 2018 2019  
173 Travis Lakins 25 lakintr01 2019 BOS AL 0.605650895 0.326037736 P 2 1 BOS   2019 2019  
174 Darwinzon Hernandez 22 hernada02 2019 BOS AL 0.7873461629999999 0.310754717 P 2 1 BOS   2019 2019  
175 Ryan Weber 28 weberry01 2019 BOS AL 0.9827655409999999 0.254716981 P 2 1 BOS TBD 2019 2019  
176 Heath Hembree 30 hembrhe01 2019 BOS AL 1.078635403 0.198679245 P 2 1 BOS SFG 2014 2019  
177 Hector Velazquez 30 velazhe01 2019 BOS AL 1.2876794390000001 0.081509434 P 2 1 BOS   2017 2019  
178 Andrew Cashner 32 cashnan01 2019 BOS AL 1.660020482 0.035660377 P 2 2 BOS BAL 2019 2019  
179 Nathan Eovaldi 29 eovalna01 2019 BOS AL 1.8416163 -0.076415094 P 2 1 BOS TBD 2018 2019  
180 Jhoulys Chacin 31 chacijh01 2019 BOS AL 0.315057805 0.081509434 P 1 2 BOS MIL 2019 2019  
181 Brian Johnson 28 johnsbr02 2019 BOS AL 1.070977748 -0.10188679199999999 P 1 1 BOS   2015 2019  
182 Marco Hernandez 26 hernama02 2019 BOS AL 1.390097761 -0.295471698 2B, SS 1 1 BOS   2016 2019  
183 Sandy Leon 30 leonsa01 2019 BOS AL 1.710186061 -0.346415094 C, 1B 1 1 BOS WSN 2015 2019  
184 Tzu-Wei Lin 25 lintz02 2019 BOS AL 0.20119836 0.00509434 2B, SS, CF 0 1 BOS   2017 2019  
185 Blake Swihart 27 swihabl01 2019 BOS AL 0.26521602 0.0 LF, RF, C, 1B 0 1 BOS   2015 2019 ARI
186 Juan Centeno 29 centeju01 2019 BOS AL 0.1371807 -0.00509434 C 0 1 BOS TEX 2019 2019  
187 Bobby Poyner 26 poynebo01 2019 BOS AL 0.32291436 -0.08660377400000001 P 0 1 BOS   2018 2019  
188 Erasmo Ramirez 29 ramirer02 2019 BOS AL 0.052360459000000005 -0.09169811300000001 P 0 1 BOS SEA 2019 2019  
189 Tyler Thornburg 30 thornty01 2019 BOS AL 0.328583014 -0.147735849 P 0 1 BOS MIL 2018 2019  
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  
191 Steven Wright 34 wrighst01 2019 BOS AL 0.136047689 -0.203773585 P 0 1 BOS   2013 2019  
192 Josh Smith 31 smithjo07 2019 BOS AL 0.687846373 -0.229245283 P 0 1 BOS OAK 2019 2019  
193 Trevor Kelley 25 kelletr01 2019 BOS AL 0.282189559 -0.254716981 P 0 1 BOS   2019 2019  
194 Mike Shawaryn 24 shawami01 2019 BOS AL 0.470150181 -0.40245283 P 0 1 BOS   2019 2019  
195 Dustin Pedroia 35 pedrodu01 2019 BOS AL 0.19205298 -0.44320754700000004 2B 0 1 BOS   2006 2019  
196 Gorkys Hernandez 31 hernago01 2019 BOS AL 0.42983286 -0.560377358 LF, RF, CF 0 1 BOS SFG 2019 2019  
197 Sam Travis 25 travisa01 2019 BOS AL 1.3718070009999999 -0.67245283 1B, LF, RF 0 1 BOS   2017 2019  
198 Steve Pearce 36 pearcst01 2019 BOS AL 0.905392621 -0.7590566040000001 1B, LF 0 1 BOS TOR 2018 2019  
199 Eduardo Nunez 32 nunezed02 2019 BOS AL 1.5912961209999998 -1.334716981 2B, 3B, SS, P 0 1 BOS SFG 2017 2019  
200 Javier Baez 26 baezja01 2019 CHC NL 5.672594142 4.72245283 SS, 3B 21 1 CHC   2014 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
);
Powered by Datasette · Query took 54.267ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub