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 sorted by quasi_ws

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
39 Joel Payamps 25 payamjo01 2019 ARI NL 0.06585285 0.0 P 0 1 ARI   2019 2019  
40 Caleb Joseph 33 josepca01 2019 ARI NL 0.37463879 -0.040754717 C, P 0 1 ARI BAL 2019 2019  
41 Robby Scott 29 scottro02 2019 ARI NL 0.153556874 -0.056037736 P 0 1 ARI BOS 2019 2019  
42 Yasmany Tomas 28 tomasya01 2019 ARI NL 0.059153493 -0.198679245   0 1 ARI   2015 2019  
43 Matt Koch 28 kochma01 2019 ARI NL 0.380449876 -0.611320755 P 0 1 ARI   2016 2019  
44 Blake Swihart 27 swihabl01 2019 ARI NL 0.690124086 -0.738679245 LF, RF, C, 1B 0 2 ARI BOS 2019 2019  
83 Arodys Vizcaino 28 vizcaar01 2019 ATL NL 0.131183086 0.020377358 P 0 1 ATL CHC 2015 2019  
84 John Ryan Murphy 28 murphjr01 2019 ATL NL 0.009917921 -0.015283018999999998 C, P 0 2 ATL ARI 2019 2019  
85 Huascar Ynoa 21 ynoahu01 2019 ATL NL 0.047839703 -0.09169811300000001 P 0 1 ATL   2019 2019  
86 Billy Hamilton 28 hamilbi02 2019 ATL NL 0.41655266799999996 -0.10188679199999999 CF 0 2 ATL KCR 2019 2019  
87 Jesse Biddle 27 biddlje01 2019 ATL NL 0.328208447 -0.219056604 P 0 1 ATL   2018 2019 SEA
88 Dan Winkler 29 winklda01 2019 ATL NL 0.75294879 -0.28528301899999997 P 0 1 ATL   2015 2019  
89 Alex Jackson 23 jacksal02 2019 ATL NL 0.14876881 -0.326037736 C 0 1 ATL   2019 2019  
90 Bryse Wilson 21 wilsobr02 2019 ATL NL 0.511493683 -0.326037736 P 0 1 ATL   2018 2019  
91 Shane Carle 27 carlesh01 2019 ATL NL 0.22746425 -0.392264151 P 0 1 ATL COL 2018 2019  
92 Chad Sobotka 25 sobotch01 2019 ATL NL 0.780930503 -0.42283018899999997 P 0 1 ATL   2018 2019  
93 Kyle Wright 23 wrighky01 2019 ATL NL 0.45563055 -0.453396226 P 0 1 ATL   2018 2019  
94 Jonny Venters 34 ventejo01 2019 ATL NL 0.126369028 -0.636792453 P 0 1 ATL TBD 2018 2019 WSN
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  
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  
235 Xavier Cedeno 32 cedenxa01 2019 CHC NL 0.055455359 0.071320755 P 0 1 CHC MIL 2019 2019  
236 James Norwood 25 norwoja01 2019 CHC NL 0.164658212 0.010188679 P 0 1 CHC   2018 2019  
237 Tony Barnette 35 barneto01 2019 CHC NL 0.031746184 -0.061132075 P 0 1 CHC TEX 2019 2019  
238 Allen Webster 29 webstal01 2019 CHC NL 0.29837394100000003 -0.081509434 P 0 1 CHC ARI 2018 2019  
239 Taylor Davis 29 davista01 2019 CHC NL 0.20223152 -0.10698113199999999 C, 1B, P 0 1 CHC   2017 2019  
240 Randy Rosario 25 rosarra01 2019 CHC NL 0.295761913 -0.117169811 P 0 1 CHC MIN 2018 2019 KCR
241 Jim Adduci 34 adducji02 2019 CHC NL 0.05055788 -0.122264151 RF 0 1 CHC DET 2019 2019  
242 Dillon Maples 27 mapledi01 2019 CHC NL 0.279687896 -0.127358491 P 0 1 CHC   2017 2019  
243 Jonathan Lucroy 33 lucrojo01 2019 CHC NL 0.546025105 -0.152830189 C, 1B 0 2 CHC ANA 2019 2019  
244 Carl Edwards Jr. 27 edwarca01 2019 CHC NL 0.496787589 -0.16811320800000001 P 0 1 CHC   2015 2019 SDP
245 Mark Zagunis 26 zagunma01 2019 CHC NL 0.40446304 -0.208867925 RF, LF 0 1 CHC   2017 2019  
246 Martin Maldonado 32 maldoma01 2019 CHC NL 0.131450488 -0.244528302 C, 1B 0 2 CHC KCR 2019 2019 HOU
247 Adbert Alzolay 24 alzolad01 2019 CHC NL 0.308520664 -0.27 P 0 1 CHC   2019 2019  
248 Carlos Gonzalez 33 gonzaca01 2019 CHC NL 0.495467225 -0.371886792 LF, RF 0 2 CHC CLE 2019 2019  
249 Mike Montgomery 29 montgmi01 2019 CHC NL 0.9236029720000001 -0.38716981100000003 P 0 1 CHC SEA 2016 2019 KCR
250 Craig Kimbrel 31 kimbrcr01 2019 CHC NL 0.853329379 -0.769245283 P 0 1 CHC BOS 2019 2019  
251 Daniel Descalso 32 descada01 2019 CHC NL 1.941422594 -1.151320755 2B, 3B, 1B, P 0 1 CHC ARI 2019 2019  
285 Thyago Vieira 25 vieirth01 2019 CHW AL 0.133844441 -0.025632911 P 0 1 CHW SEA 2018 2019  
286 Caleb Frare 25 frareca01 2019 CHW AL 0.074125933 -0.09740506300000001 P 0 1 CHW   2018 2019  
287 Hector Santiago 31 santihe01 2019 CHW AL 0.51963136 -0.148670886 P 0 2 CHW NYM 2019 2019  
288 Odrisamer Despaigne 32 despaod01 2019 CHW AL 0.392053345 -0.199936709 P 0 1 CHW ANA 2019 2019  
289 Seby Zavala 25 zavalse01 2019 CHW AL 0.117647059 -0.21531645600000002 C 0 1 CHW   2019 2019  
290 Carson Fulmer 25 fulmeca01 2019 CHW AL 0.781750085 -0.328101266 P 0 1 CHW   2016 2019  
291 Ervin Santana 36 santaer01 2019 CHW AL 0.400622817 -0.405 P 0 1 CHW MIN 2019 2019  
292 Nicky Delmonico 26 delmoni01 2019 CHW AL 0.666666667 -0.507531646 LF, 1B 0 1 CHW   2017 2019  
293 AJ Reed 26 reedaj01 2019 CHW AL 0.48039215700000004 -0.51778481 1B, P 0 1 CHW HOU 2019 2019  
294 Matt Skole 29 skolema01 2019 CHW AL 0.784313725 -0.548544304 1B 0 1 CHW   2018 2019  
295 Jose Rondon 25 rondojo02 2019 CHW AL 1.529411765 -0.712594937 2B, SS, 3B, LF, 1B, P 0 1 CHW SDP 2018 2019 BAL
296 Jon Jay 34 jayjo02 2019 CHW AL 1.784313725 -0.8715189870000001 RF, LF 0 1 CHW ARI 2019 2019  
297 Yonder Alonso 32 alonsyo01 2019 CHW AL 2.460784314 -1.194493671 1B 0 1 CHW CLE 2019 2019 COL
298 Daniel Palka 27 palkada01 2019 CHW AL 0.87254902 -1.302151899 RF, 1B 0 1 CHW   2018 2019  
332 Christian Colon 30 colonch01 2019 CIN NL 0.061921708 0.10698113199999999 2B 0 1 CIN FLA 2019 2019  
333 R.J. Alaniz 28 alanirj01 2019 CIN NL 0.222551597 0.045849057 P 0 2 CIN SEA 2019 2019  
334 Joel Kuhnel 24 kuhnejo01 2019 CIN NL 0.206092473 0.0 P 0 1 CIN   2019 2019  
335 Jimmy Herget 25 hergeji01 2019 CIN NL 0.10264233099999999 -0.020377358 P 0 1 CIN   2019 2019  
336 Keury Mella 25 mellake01 2019 CIN NL 0.066088938 -0.025471697999999997 P 0 1 CIN   2017 2019  
337 Zach Duke 36 dukeza01 2019 CIN NL 0.66795772 -0.178301887 P 0 1 CIN SEA 2019 2019  
338 Juan Graterol 30 grateju01 2019 CIN NL 0.185765125 -0.18849056600000003 C 0 1 CIN MIN 2019 2019  
339 Brian O'Grady 27 ogradbr01 2019 CIN NL 0.41281138799999995 -0.244528302 CF, LF, 1B 0 1 CIN   2019 2019  
340 Sal Romano 25 romansa01 2019 CIN NL 0.313228246 -0.295471698 P 0 1 CIN   2017 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 3136.075ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub