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

1,241 rows where prev_franch = "SDP"

✎ 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
171 171 Colten Brewer 26 breweco01 2019 BOS AL 1.475490887 0.336226415 P 3 1 BOS SDP 2019 2019  
202 202 Anthony Rizzo 29 rizzoan01 2019 CHC NL 6.198396095 4.029622642 1B 20 1 CHC SDP 2012 2019  
220 220 Rowan Wick 26 wickro01 2019 CHC NL 1.064200389 0.718301887 P 3 1 CHC SDP 2019 2019  
225 225 Brad Wieck 27 wieckbr01 2019 CHC NL 0.319019007 0.356603774 P 1 2 CHC SDP 2019 2019  
278 278 Jose Ruiz 24 ruizjo01 2019 CHW AL 1.060472163 -0.025632911 P 1 1 CHW SDP 2018 2019  
295 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
358 358 Brad Hand 29 handbr01 2019 CLE AL 2.261425777 1.380566038 P 8 1 CLE SDP 2018 2019  
368 368 Adam Cimber 28 cimbead01 2019 CLE AL 2.087087698 0.361698113 P 4 1 CLE SDP 2018 2019  
376 376 Franmil Reyes 23 reyesfr01 2019 CLE AL 1.816727757 -0.127358491 RF 2 2 CLE SDP 2019 2019  
384 384 Logan Allen 22 allenlo01 2019 CLE AL 0.040944602 0.096792453 P 0 2 CLE SDP 2019 2019  
387 387 Phil Maton 26 matonph01 2019 CLE AL 0.186140064 0.040754717 P 0 2 CLE SDP 2019 2019  
388 388 Jon Edwards 31 edwarjo02 2019 CLE AL 0.201254885 0.0 P 0 1 CLE SDP 2018 2019  
422 422 Tim Melville 29 melviti01 2019 COL NL 0.955688075 0.300566038 P 2 1 COL SDP 2019 2019  
556 556 Ian Kennedy 34 kenneia01 2019 KCR AL 2.133740642 1.35509434 P 7 1 KCR SDP 2016 2019  
699 699 Rocky Gale 31 galero01 2019 LAD NL 0.149922454 -0.208867925 C 0 1 LAD SDP 2018 2019  
745 745 Tayron Guerrero 28 guerrta01 2019 MIA NL 1.224547976 -0.687735849 P 0 1 FLA SDP 2018 2019  
776 776 Jhoulys Chacin 31 chacijh01 2019 MIL NL 2.43432159 -0.224150943 P 3 1 MIL SDP 2018 2019 BOS
779 779 Cory Spangenberg 28 spangco01 2019 MIL NL 0.887453247 0.315849057 2B, 3B, SS, LF 2 1 MIL SDP 2019 2019  
783 783 Jay Jackson 31 jacksja01 2019 MIL NL 0.670757342 0.127358491 P 1 1 MIL SDP 2019 2019  
893 893 Walker Lockett 25 lockewa01 2019 NYM NL 0.530106519 -0.122264151 P 0 1 NYM SDP 2019 2019  
1039 1039 Jose Pirela 29 pireljo01 2019 PHI NL 0.169561479 0.13754717 LF, RF 1 2 PHI SDP 2019 2019  
1209 1209 Matt Wisler 26 wislema01 2019 SEA AL 0.65767696 -0.025471698 P 1 2 SEA SDP 2019 2019  
1252 1252 Alex Dickerson 29 dickeal01 2019 SFG NL 1.638758884 0.983207547 LF, RF 6 2 SFG SDP 2019 2019  
1325 1325 Tyler Webb 28 webbty01 2019 STL NL 1.436811887 0.315849057 P 3 1 STL SDP 2018 2019  
1332 1332 Jedd Gyorko 30 gyorkje01 2019 STL NL 0.627027027 -0.152830189 3B, 1B, 2B, P 1 1 STL SDP 2016 2019 LAD
1458 1458 Freddy Galvis 29 galvifr01 2019 TOR AL 4.598390882 1.650566038 SS, 2B 11 1 TOR SDP 2019 2019 CIN
1494 1494 Clayton Richard 35 richacl01 2019 TOR AL 1.329239959 -0.168113208 P 1 1 TOR SDP 2019 2019  
1697 1697 Brad Brach 32 brachbr01 2018 BAL AL 1.372880239 0.165 P 2 1 BAL SDP 2014 2018 ATL
1717 1717 Luis Sardinas 25 sardilu01 2018 BAL AL 0.192979538 -0.255 2B 0 1 BAL SDP 2018 2018  
1737 1737 Craig Kimbrel 30 kimbrcr01 2018 BOS AL 2.656381185 1.785 P 10 1 BOS SDP 2016 2018 CHC
1758 1758 Drew Pomeranz 29 pomerdr01 2018 BOS AL 1.865950124 -0.445 P 2 1 BOS SDP 2016 2018 SFG
1775 1775 Anthony Rizzo 28 rizzoan01 2018 CHC NL 6.385761589 2.787791411 1B, 2B, P 18 1 CHC SDP 2012 2019  
1803 1803 Cory Mazzoni 28 mazzoco01 2018 CHC NL 0.192414541 0.203742331 P 1 1 CHC SDP 2018 2018  
1827 1827 James Shields 36 shielja02 2018 CHW AL 5.907988373 1.28 P 11 1 CHW SDP 2016 2018  
1848 1848 Jose Rondon 24 rondojo02 2018 CHW AL 1.025785124 0.31 SS, 3B, 2B, 1B 2 1 CHW SDP 2018 2019 BAL
1856 1856 Jose Ruiz 23 ruizjo01 2018 CHW AL 0.108148742 0.02 P 0 1 CHW SDP 2018 2019  
1921 1921 Kevin Quackenbush 29 quackke01 2018 CIN NL 0.23873827 -0.42 P 0 1 CIN SDP 2018 2018  
1942 1942 Brad Hand 28 handbr01 2018 CLE AL 1.000396073 0.715 P 3 2 CLE SDP 2018 2019  
1964 1964 Jon Edwards 30 edwarjo02 2018 CLE AL 0.258989325 -0.02 P 0 1 CLE SDP 2018 2019  
1969 1969 Adam Cimber 27 cimbead01 2018 CLE AL 0.612609365 -0.1 P 0 2 CLE SDP 2018 2019  
2114 2114 Ian Kennedy 33 kenneia01 2018 KCR AL 3.346820706 0.87 P 7 1 KCR SDP 2016 2019  
2151 2151 Burch Smith 28 smithbu03 2018 KCR AL 1.854852475 -0.85 P 0 1 KCR SDP 2018 2018 MIL
2153 2153 Brandon Maurer 27 maurebr01 2018 KCR AL 0.979423526 -1.015 P 0 1 KCR SDP 2017 2018  
2192 2192 Ryan Schimpf 30 schimry01 2018 LAA AL 0.066710483 0.12 2B, 3B, LF, RF 0 1 ANA SDP 2018 2018  
2214 2214 Jabari Blash 28 blashja01 2018 LAA AL 0.428853105 -0.755 RF, LF 0 1 ANA SDP 2018 2018  
2218 2218 Yasmani Grandal 29 grandya01 2018 LAD NL 4.986556017 3.970490798 C, 1B 18 1 LAD SDP 2015 2018 MIL
2258 2258 Rocky Gale 30 galero01 2018 LAD NL 0.019253112 -0.024846626 C 0 1 LAD SDP 2018 2019  
2298 2298 Tayron Guerrero 27 guerrta01 2018 MIA NL 1.599393493 -0.643975155 P 1 1 FLA SDP 2018 2019  
2322 2322 Jhoulys Chacin 30 chacijh01 2018 MIL NL 5.243365211 2.370368098 P 15 1 MIL SDP 2018 2019 BOS
2354 2354 Jordan Lyles 27 lylesjo01 2018 MIL NL 0.411405174 0.188834356 P 1 2 MIL SDP 2018 2018 PIT
2472 2472 Buddy Baumann 30 baumabu01 2018 NYM NL 0.080664214 -0.365 P 0 2 NYM SDP 2018 2018  
2748 2748 Nick Vincent 31 vinceni01 2018 SEA AL 1.949131288 0.445 P 4 1 SEA SDP 2016 2018 SFG
2807 2807 Chase d'Arnaud 31 darnach01 2018 SFG NL 1.000172444 0.075 2B, 3B, 1B, P, SS 2 1 SFG SDP 2018 2018  
2824 2824 Jose Valdez 28 valdejo03 2018 SFG NL 0.080712503 -0.22 P 0 1 SFG SDP 2018 2018  
2839 2839 Jedd Gyorko 29 gyorkje01 2018 STL NL 3.970032351 1.7 3B, 2B, 1B, SS, P 11 1 STL SDP 2016 2019 LAD
2848 2848 Tyson Ross 31 rossty01 2018 STL NL 0.998941034 0.66 P 4 2 STL SDP 2018 2018 DET
2860 2860 Tyler Webb 27 webbty01 2018 STL NL 0.393014776 0.02 P 1 2 STL SDP 2018 2019  
3004 3004 Yangervis Solarte 30 solarya01 2018 TOR AL 4.849306015 -1.02 3B, 2B, SS, 1B 4 1 TOR SDP 2018 2018 SFG
3069 3069 Shawn Kelley 34 kellesh01 2018 WSN NL 0.802621429 0.315 P 2 1 WSN SDP 2016 2018 OAK
3161 3161 Matt Kemp 32 kempma01 2017 ATL NL 4.595520869 -0.99 LF 4 1 ATL SDP 2016 2017 LAD
3177 3177 Jace Peterson 27 peterja01 2017 ATL NL 2.115710892 -0.765 LF, 2B, 3B, 1B, SS, RF 1 1 ATL SDP 2015 2017 NYY
3202 3202 Brad Brach 31 brachbr01 2017 BAL AL 2.570036434 1.215 P 8 1 BAL SDP 2014 2018 ATL
3234 3234 Edwin Jackson 33 jacksed01 2017 BAL AL 0.106777578 -0.215 P 0 1 BAL SDP 2017 2017 WSN
3244 3244 Drew Pomeranz 28 pomerdr01 2017 BOS AL 4.641707069 3.44 P 17 1 BOS SDP 2016 2018 SFG
3248 3248 Craig Kimbrel 29 kimbrcr01 2017 BOS AL 2.652900887 3.395 P 14 1 BOS SDP 2016 2018 CHC
3292 3292 Anthony Rizzo 27 rizzoan01 2017 CHC NL 6.755098601 4.16 1B, 2B, 3B, LF 22 1 CHC SDP 2012 2019  
3302 3302 Jon Jay 32 jayjo02 2017 CHC NL 4.232934435 1.395 LF, CF, RF, P 10 1 CHC SDP 2017 2017 KCR
3356 3356 James Shields 35 shielja02 2017 CHW AL 3.430009876 0.05 P 5 1 CHW SDP 2016 2018  
3372 3372 Rymer Liriano 26 liriary01 2017 CHW AL 0.441794999 0.12 LF, RF 1 1 CHW SDP 2017 2017  
3407 3407 Patrick Kivlehan 27 kivlepa01 2017 CIN NL 2.010535259 0.035 RF, 1B, LF, 3B, CF 3 1 CIN SDP 2016 2017 ARI
3465 3465 Abraham Almonte 28 almonab01 2017 CLE AL 1.82037663 -0.065 RF, LF, CF 2 1 CLE SDP 2015 2017 KCR
3517 3517 Alexi Amarista 28 amarial01 2017 COL NL 1.740791269 -1.27 2B, SS, CF, RF, LF, 3B 0 1 COL SDP 2017 2017  
3518 3518 Justin Upton 29 uptonju01 2017 DET AL 4.921671018 4.795 LF 20 1 DET SDP 2016 2017 ANA
3626 3626 Ian Kennedy 32 kenneia01 2017 KCR AL 4.300083429 0.265 P 8 1 KCR SDP 2016 2019  
3633 3633 Ryan Buchter 30 buchtry01 2017 KCR AL 0.677310175 0.34 P 2 2 KCR SDP 2017 2017 OAK
3656 3656 Brandon Maurer 26 maurebr01 2017 KCR AL 0.567411523 -0.31 P 0 2 KCR SDP 2017 2018  
3660 3660 Trevor Cahill 29 cahiltr01 2017 KCR AL 0.559796263 -0.745 P 0 2 KCR SDP 2017 2017 OAK
3701 3701 Huston Street 33 streehu01 2017 LAA AL 0.069671739 0.12 P 0 1 ANA SDP 2014 2017  
3723 3723 Yasmani Grandal 28 grandya01 2017 LAD NL 4.76739427 3.16 C 17 1 LAD SDP 2015 2018 MIL
3734 3734 Brandon Morrow 32 morrobr01 2017 LAD NL 1.412450358 1.355 P 6 1 LAD SDP 2017 2017 CHC
3974 3974 Chase Headley 33 headlch01 2017 NYY AL 5.370200664 1.915 3B, 1B, 2B 12 1 NYY SDP 2014 2017 SDP
4023 4023 Yonder Alonso 30 alonsyo01 2017 OAK AL 3.52580698 1.78 1B 10 1 OAK SDP 2016 2017 SEA
4036 4036 Jesse Hahn 27 hahnje01 2017 OAK AL 1.942259694 0.565 P 4 1 OAK SDP 2015 2017 KCR
4043 4043 Adam Rosales 34 rosalad01 2017 OAK AL 2.119285597 -0.105 SS, 3B, 2B, 1B, LF 3 1 OAK SDP 2017 2017 ARI
4230 4230 Nick Vincent 30 vinceni01 2017 SEA AL 2.449568014 1.525 P 8 1 SEA SDP 2016 2018 SFG
4334 4334 Jedd Gyorko 28 gyorkje01 2017 STL NL 4.737306843 3.13 3B, 1B, 2B, LF 15 1 STL SDP 2016 2019 LAD
4407 4407 Brad Boxberger 29 boxbebr01 2017 TBR AL 0.976298332 0.37 P 2 1 TBD SDP 2014 2017 ARI
4411 4411 Derek Norris 28 norride01 2017 TBR AL 1.875857563 -0.045 C 2 1 TBD SDP 2017 2017  
4480 4480 Tyson Ross 30 rossty01 2017 TEX AL 1.307215215 -0.535 P 0 1 TEX SDP 2017 2017 SDP
4515 4515 Leonel Campos 29 campole01 2017 TOR AL 0.256769885 0.09 P 1 1 TOR SDP 2017 2017  
4591 4591 Shawn Kelley 33 kellesh01 2017 WSN NL 0.833349109 -0.875 P 0 1 WSN SDP 2016 2018 OAK
4651 4651 Jace Peterson 26 peterja01 2016 ATL NL 4.025859136 0.28173913 2B, LF, 3B, CF 7 1 ATL SDP 2015 2017 NYY
4652 4652 Bud Norris 31 norribu01 2016 ATL NL 1.89875543 1.066583851 P 6 1 ATL SDP 2016 2016 LAD
4658 4658 Matt Kemp 31 kempma01 2016 ATL NL 2.378019735 0.19621118 RF, LF 4 2 ATL SDP 2016 2017 LAD
4677 4677 Casey Kelly 26 kellyca01 2016 ATL NL 0.744740139 -0.070434783 P 1 1 ATL SDP 2016 2016 SFG
4712 4712 Brad Brach 30 brachbr01 2016 BAL AL 2.750172834 2.08 P 10 1 BAL SDP 2014 2018 ATL
4734 4734 Odrisamer Despaigne 29 despaod01 2016 BAL AL 0.714709707 -0.145 P 1 1 BAL SDP 2016 2016 FLA
4760 4760 Craig Kimbrel 28 kimbrcr01 2016 BOS AL 2.187430906 1.01 P 6 1 BOS SDP 2016 2018 CHC
4768 4768 Drew Pomeranz 27 pomerdr01 2016 BOS AL 1.973699449 0.54 P 4 2 BOS SDP 2016 2018 SFG
4774 4774 Tommy Layne 31 layneto01 2016 BOS AL 0.671853778 0.335 P 2 1 BOS SDP 2014 2016 NYY

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