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

98,796 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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