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,102 rows where prev_franch = "BAL"

✎ 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
5 5 Christian Walker 28 walkech02 2019 ARI NL 5.826619072 2.190566038 1B 15 1 ARI BAL 2017 2019  
13 13 Adam Jones 33 jonesad01 2019 ARI NL 5.156212817 -0.106981132 RF, CF 7 1 ARI BAL 2019 2019  
26 26 Stefan Crichton 27 crichst01 2019 ARI NL 0.678483912 0.356603774 P 2 1 ARI BAL 2019 2019  
36 36 T.J. McFarland 30 mcfartj01 2019 ARI NL 1.642729282 -0.336226415 P 1 1 ARI BAL 2017 2019  
40 40 Caleb Joseph 33 josepca01 2019 ARI NL 0.37463879 -0.040754717 C, P 0 1 ARI BAL 2019 2019  
54 54 Nick Markakis 35 markani01 2019 ATL NL 4.53248974 0.433018868 RF, LF 9 1 ATL BAL 2015 2019  
64 64 Kevin Gausman 28 gausmke01 2019 ATL NL 2.250572207 -0.142641509 P 4 1 ATL BAL 2018 2019 CIN
78 78 Darren O'Day 36 odayda01 2019 ATL NL 0.100393172 0.117169811 P 1 1 ATL BAL 2019 2019  
178 178 Andrew Cashner 32 cashnan01 2019 BOS AL 1.660020482 0.035660377 P 2 2 BOS BAL 2019 2019  
223 223 Pedro Strop 34 stroppe01 2019 CHC NL 1.297122942 0.050943396 P 2 1 CHC BAL 2013 2019  
283 283 Welington Castillo 32 castiwe01 2019 CHW AL 2.392156863 -0.635696203 C 1 1 CHW BAL 2018 2019  
744 744 Wei-Yin Chen 33 chenwe02 2019 MIA NL 1.629724336 -0.67245283 P 0 1 FLA BAL 2016 2019  
782 782 Donnie Hart 28 hartdo01 2019 MIL NL 0.133113963 0.13245283 P 1 1 MIL BAL 2019 2019 NYM
898 898 Ruben Tejada 29 tejadru01 2019 NYM NL 0.089383562 -0.259811321 2B, 3B, SS 0 1 NYM BAL 2019 2019  
919 919 Zack Britton 31 brittza01 2019 NYY AL 2.220620311 1.574150943 P 8 1 NYY BAL 2018 2019  
938 938 Nestor Cortes Jr. 24 cortene01 2019 NYY AL 1.79851893 -0.280188679 P 2 1 NYY BAL 2019 2019  
940 940 Breyvic Valera 27 valerbr01 2019 NYY AL 0.351400033 0.00509434 2B, SS 1 1 NYY BAL 2019 2019 TOR
999 999 Corban Joseph 30 josepco01 2019 OAK AL 0.377973281 -0.219056604 2B, 3B 0 1 OAK BAL 2019 2019 SFG
1080 1080 Richard Rodriguez 29 rodriri05 2019 PIT NL 2.154066214 0.336226415 P 4 1 PIT BAL 2018 2019  
1105 1105 Yefry Ramirez 25 ramirye01 2019 PIT NL 0.231405834 -0.168113208 P 0 2 PIT BAL 2019 2019  
1187 1187 Tim Beckham 29 beckhti01 2019 SEA AL 3.13616881 0.382075472 SS, LF, 3B, 2B, 1B 5 1 SEA BAL 2019 2019  
1219 1219 Mike Wright 29 wrighmi01 2019 SEA AL 0.263954745 -0.066226415 P 0 2 SEA BAL 2019 2019  
1233 1233 Keon Broxton 29 broxtke01 2019 SEA AL 0.602373887 -0.320943396 CF, LF, RF 0 3 SEA BAL 2019 2019  
1273 1273 Joey Rickard 28 rickajo01 2019 SFG NL 0.502686774 0.106981132 RF, LF, CF 1 2 SFG BAL 2019 2019  
1544 1544 Jeremy Hellickson 32 hellije01 2019 WSN NL 1.075573305 -0.157924528 P 1 1 WSN BAL 2018 2019  
1578 1578 T.J. McFarland 29 mcfartj01 2018 ARI NL 1.814990393 0.9 P 5 1 ARI BAL 2017 2019  
1606 1606 Christian Walker 27 walkech02 2018 ARI NL 0.527725322 -0.16 1B, LF 0 1 ARI BAL 2017 2019  
1619 1619 Nick Markakis 34 markani01 2018 ATL NL 6.903596151 2.59 RF, LF 18 1 ATL BAL 2015 2019  
1629 1629 Kevin Gausman 27 gausmke01 2018 ATL NL 1.649498591 0.95 P 5 2 ATL BAL 2018 2019 CIN
1637 1637 Brad Brach 32 brachbr01 2018 ATL NL 0.888688125 0.35 P 2 2 ATL BAL 2018 2018 CHC
1649 1649 Ryan Flaherty 31 flahery01 2018 ATL NL 1.782204964 -0.61 3B, 1B, 2B 1 1 ATL BAL 2018 2018 CLE
1788 1788 Pedro Strop 33 stroppe01 2018 CHC NL 2.210700833 1.45601227 P 8 1 CHC BAL 2013 2019  
1821 1821 Brian Duensing 35 duensbr01 2018 CHC NL 1.124068065 -1.142944785 P, LF 0 1 CHC BAL 2017 2018  
1845 1845 Welington Castillo 31 castiwe01 2018 CHW AL 1.735206612 0.385 C 3 1 CHW BAL 2018 2019  
1986 1986 Gerardo Parra 31 parrage01 2018 COL NL 4.397398597 0.233558282 LF, RF 8 1 COL BAL 2016 2018 SFG
2210 2210 Parker Bridwell 26 bridwpa01 2018 LAA AL 0.133918316 -0.46 P 0 1 ANA BAL 2017 2018  
2225 2225 Manny Machado 25 machama01 2018 LAD NL 2.849460581 2.598957055 SS, 3B 11 2 LAD BAL 2018 2018 SDP
2278 2278 Wei-Yin Chen 32 chenwe02 2018 MIA NL 3.798648418 0.321987578 P 7 1 FLA BAL 2016 2019  
2307 2307 Odrisamer Despaigne 31 despaod01 2018 MIA NL 0.641250449 -0.22136646 P 0 1 FLA BAL 2016 2018 ANA
2327 2327 Wade Miley 31 mileywa01 2018 MIL NL 2.195318998 1.485828221 P 8 1 MIL BAL 2018 2018 HOU
2351 2351 Jonathan Schoop 26 schoojo01 2018 MIL NL 1.313947591 -0.114294479 2B, SS 2 2 MIL BAL 2018 2018 MIN
2361 2361 Alec Asher 26 asheral01 2018 MIL NL 0.048639035 0.044723926 P 0 1 MIL BAL 2018 2018  
2363 2363 Oliver Drake 31 drakeol01 2018 MIL NL 0.311714452 -0.029815951 P 0 1 MIL BAL 2017 2018 CLE
2509 2509 Zack Britton 30 brittza01 2018 NYY AL 0.808116364 0.235 P 2 2 NYY BAL 2018 2019  
2646 2646 Richard Rodriguez 28 rodriri05 2018 PIT NL 2.0091972 1.484161491 P 7 1 PIT BAL 2018 2019  
2731 2731 Nelson Cruz 37 cruzne02 2018 SEA AL 5.651772465 2.7 RF 17 1 SEA BAL 2015 2018 MIN
2758 2758 Ariel Miranda 29 miranar01 2018 SEA AL 0.138845348 0.18 P 1 1 SEA BAL 2016 2018  
2877 2877 Francisco Pena 28 penafr01 2018 STL NL 1.402349736 -0.94 C, 1B 0 1 STL BAL 2018 2018  
2905 2905 Vidal Nuno III 30 nunovi01 2018 TBR AL 0.828105116 0.59 P 3 1 TBD BAL 2018 2018  
3012 3012 Steve Pearce 35 pearcst01 2018 TOR AL 0.82419035 0.285 1B, LF, RF 2 1 TOR BAL 2017 2018 BOS
3056 3056 Jeremy Hellickson 31 hellije01 2018 WSN NL 2.581328611 1.265 P 7 1 WSN BAL 2018 2019  
3061 3061 Matt Wieters 32 wietema01 2018 WSN NL 2.643013284 0.51 C 5 1 WSN BAL 2017 2018 STL
3128 3128 Christian Walker 26 walkech02 2017 ARI NL 0.148110317 0.105 1B 1 1 ARI BAL 2017 2019  
3131 3131 T.J. McFarland 28 mcfartj01 2017 ARI NL 1.394401842 -0.35 P 1 1 ARI BAL 2017 2019  
3150 3150 Nick Markakis 33 markani01 2017 ATL NL 6.593145572 0.575 RF 11 1 ATL BAL 2015 2019  
3185 3185 Chaz Roe 30 roech01 2017 ATL NL 0.051905504 -0.11 P 0 1 ATL BAL 2016 2017 TBD
3296 3296 Jake Arrieta 31 arrieja01 2017 CHC NL 4.743309471 2.24 P 14 1 CHC BAL 2013 2017 PHI
3310 3310 Brian Duensing 34 duensbr01 2017 CHC NL 1.7658261 1.065 P 6 1 CHC BAL 2017 2018  
3311 3311 Pedro Strop 32 stroppe01 2017 CHC NL 2.109186756 1.04 P 6 1 CHC BAL 2013 2019  
3342 3342 Miguel Gonzalez 33 gonzami03 2017 CHW AL 3.897771573 1.55 P 10 1 CHW BAL 2016 2017 TEX
3488 3488 Gerardo Parra 30 parrage01 2017 COL NL 4.20361528 0.75 LF, RF, 1B, CF 9 1 COL BAL 2016 2018 SFG
3601 3601 Ashur Tolliver 29 tollias01 2017 HOU AL 0.09565311 0.03 P 0 1 HOU BAL 2017 2017  
3667 3667 Parker Bridwell 25 bridwpa01 2017 LAA AL 3.530630257 1.515 P 10 1 ANA BAL 2017 2018  
3783 3783 Odrisamer Despaigne 30 despaod01 2017 MIA NL 1.494397824 0.325 P 3 1 FLA BAL 2016 2018 ANA
3787 3787 Wei-Yin Chen 31 chenwe02 2017 MIA NL 0.77998417 0.435 P 2 1 FLA BAL 2016 2019  
3803 3803 Vance Worley 29 worleva01 2017 MIA NL 1.846902888 -0.65 P 1 1 FLA BAL 2017 2017  
3836 3836 Oliver Drake 30 drakeol01 2017 MIL NL 1.468846256 0.33 P 3 2 MIL BAL 2017 2018 CLE
4121 4121 Hyun Soo Kim 29 kimhy01 2017 PHI NL 0.965505406 -0.84 LF, RF 0 2 PHI BAL 2017 2017  
4221 4221 Nelson Cruz 36 cruzne02 2017 SEA AL 6.093826356 4.035 RF 20 1 SEA BAL 2015 2018 MIN
4234 4234 Ariel Miranda 28 miranar01 2017 SEA AL 4.308840644 0.245 P 7 1 SEA BAL 2016 2018  
4240 4240 Yovani Gallardo 31 gallayo01 2017 SEA AL 3.499551984 -0.105 P 4 1 SEA BAL 2017 2017 CIN
4322 4322 Drew Stubbs 32 stubbdr01 2017 SFG NL 0.23921636 -0.425 CF 0 1 SFG BAL 2017 2017  
4392 4392 Tommy Hunter 30 hunteto02 2017 TBR AL 2.038236868 1.205 P 6 1 TBD BAL 2017 2017 PHI
4501 4501 Steve Pearce 34 pearcst01 2017 TOR AL 3.292659054 0.145 LF, 1B 5 1 TOR BAL 2017 2018 BOS
4563 4563 Matt Wieters 31 wietema01 2017 WSN NL 4.61025641 -0.925 C 4 1 WSN BAL 2017 2018 STL
4572 4572 Edwin Jackson 33 jacksed01 2017 WSN NL 1.98990052 -0.185 P 2 2 WSN BAL 2017 2017 OAK
4645 4645 Nick Markakis 32 markani01 2016 ATL NL 6.749234433 1.479130435 RF, 1B 14 1 ATL BAL 2015 2019  
4664 4664 Chaz Roe 29 roech01 2016 ATL NL 0.637294962 0.442732919 P 2 2 ATL BAL 2016 2017 TBD
4803 4803 Jake Arrieta 30 arrieja01 2016 CHC NL 5.543681214 4.445 P 21 1 CHC BAL 2013 2017 PHI
4817 4817 Pedro Strop 31 stroppe01 2016 CHC NL 1.548999051 0.74 P, LF 4 1 CHC BAL 2013 2019  
4839 4839 Brian Matusz 29 matusbr01 2016 CHC NL 0.083830645 -0.295 P 0 2 CHC BAL 2016 2016  
4851 4851 Miguel Gonzalez 32 gonzami03 2016 CHW AL 3.717346938 2.5 P 12 1 CHW BAL 2016 2017 TEX
5011 5011 Nick Hundley 32 hundlni01 2016 COL NL 3.116799458 -0.11 C 4 1 COL BAL 2015 2016 SFG
5040 5040 Gerardo Parra 29 parrage01 2016 COL NL 3.746058654 -2.315 LF, 1B, RF, CF 0 1 COL BAL 2016 2018 SFG
5106 5106 Scott Feldman 33 feldmsc01 2016 HOU AL 1.797882444 0.305 P 3 1 HOU BAL 2014 2016 TOR
5296 5296 Wei-Yin Chen 30 chenwe02 2016 MIA NL 3.36879519 -0.256583851 P 4 1 FLA BAL 2016 2019  
5314 5314 Odrisamer Despaigne 29 despaod01 2016 MIA NL 0.048202157 -0.040248447 P 0 2 FLA BAL 2016 2018 ANA
5488 5488 Andrew Miller 31 millean01 2016 NYY AL 1.87022512 2.115 P 9 1 NYY BAL 2015 2016 CLE
5505 5505 Chris Parmelee 28 parmech01 2016 NYY AL 0.076833913 0.3 1B 1 1 NYY BAL 2016 2016  
5609 5609 David Lough 30 loughda01 2016 PHI NL 0.807116435 -0.075 LF, RF 1 1 PHI BAL 2016 2016  
5675 5675 Jorge Rondon 28 rondojo01 2016 PIT NL 0.062618819 -0.105 P 0 1 PIT BAL 2016 2016  
5744 5744 Nelson Cruz 35 cruzne02 2016 SEA AL 6.237665269 4.545 RF 22 1 SEA BAL 2015 2018 MIN
5764 5764 Ariel Miranda 27 miranar01 2016 SEA AL 1.645301761 0.4 P 4 2 SEA BAL 2016 2018  
5777 5777 Steve Johnson 28 johnsst02 2016 SEA AL 0.403980343 -0.01 P 1 1 SEA BAL 2016 2016  
5794 5794 Steve Clevenger 30 clevest01 2016 SEA AL 0.710738471 -0.26 C 0 1 SEA BAL 2016 2016  
5890 5890 Steve Pearce 33 pearcst01 2016 TBR AL 2.23484471 1.945 1B, 2B, LF, RF, 3B 8 1 TBD BAL 2016 2016 BAL
6010 6010 Jimmy Paredes 27 paredji01 2016 TOR AL 0.159032258 0.01 LF, RF, 3B, 2B 0 1 TOR BAL 2016 2016 PHI
6024 6024 Junior Lake 26 lakeju01 2016 TOR AL 0.36483871 -0.18 RF, 1B 0 1 TOR BAL 2016 2016  
6109 6109 David Hernandez 30 hernada01 2015 ARI NL 0.904260835 -0.12 P 1 1 ARI BAL 2011 2015 PHI
6127 6127 Nick Markakis 31 markani01 2015 ATL NL 6.97790249 1.565 RF 15 1 ATL BAL 2015 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
);