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

622 rows where prev_franch = "COL"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, year_ID, lg_ID, quasi_ws, stint_ID, franch_id, year_acq, year_left, 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
91 91 Shane Carle 27 carlesh01 2019 ATL NL 0.22746425 -0.392264151 P 0 1 ATL COL 2018 2019  
107 107 Miguel Castro 24 castrmi01 2019 BAL AL 2.240454464 0.499245283 P 4 1 BAL COL 2017 2019  
216 216 Tyler Chatwood 29 chatwty01 2019 CHC NL 2.483937943 1.110566038 P 6 1 CHC COL 2018 2019  
383 383 Carlos Gonzalez 33 gonzaca01 2019 CLE AL 1.130623126 -0.203773585 LF, RF 1 1 CLE COL 2019 2019 CHC
523 523 Collin McHugh 32 mchugco01 2019 HOU AL 1.911383032 0.473773585 P 4 1 HOU COL 2014 2019  
887 887 Brooks Pounders 28 poundbr01 2019 NYM NL 0.186183265 -0.015283019 P 0 1 NYM COL 2019 2019  
905 905 DJ LeMahieu 30 lemahdj01 2019 NYY AL 6.116260029 5.853396226 2B, 3B, 1B 27 1 NYY COL 2019 2019  
913 913 Mike Tauchman 28 tauchmi01 2019 NYY AL 2.811200262 3.168679245 LF, RF, CF 14 1 NYY COL 2019 2019  
917 917 Adam Ottavino 33 ottavad01 2019 NYY AL 2.374839913 1.788113208 P 9 1 NYY COL 2019 2019  
1054 1054 Pat Neshek 38 neshepa01 2019 PHI NL 0.561742999 -0.208867925 P 0 1 PHI COL 2018 2019  
1173 1173 Tom Murphy 28 murphto04 2019 SEA AL 2.610286845 2.817169811 C, P, LF 12 1 SEA COL 2019 2019  
1217 1217 Matt Carasiti 27 carasma01 2019 SEA AL 0.253367775 -0.061132075 P 0 1 SEA COL 2019 2019  
1268 1268 Gerardo Parra 32 parrage01 2019 SFG NL 0.975212342 -0.045849057 RF, LF, 1B, CF, 2B, 3B, P 2 1 SFG COL 2019 2019 WSN
1272 1272 Cristhian Adames 27 adamecr01 2019 SFG NL 0.221182181 0.13245283 2B, 3B 1 1 SFG COL 2019 2019  
1547 1547 Justin Miller 32 milleju02 2019 WSN NL 0.485171227 -0.050943396 P 0 1 WSN COL 2018 2019  
1573 1573 Daniel Descalso 31 descada01 2018 ARI NL 4.211845494 1.32 2B, 3B, 1B, LF, P 10 1 ARI COL 2017 2018 CHC
1610 1610 Jorge De La Rosa 37 rosajo01 2018 ARI NL 1.02933483 -0.415 P 0 1 ARI COL 2017 2018 CHC
1630 1630 Shane Carle 26 carlesh01 2018 ATL NL 2.244585527 0.705 P 5 1 ATL COL 2018 2019  
1650 1650 Rex Brothers 30 brothre01 2018 ATL NL 0.0 0.0 P 0 1 ATL COL 2017 2018  
1684 1684 Miguel Castro 23 castrmi01 2018 BAL AL 2.614431697 0.55 P 5 1 BAL COL 2017 2019  
1794 1794 Tyler Chatwood 28 chatwty01 2018 CHC NL 2.585534355 -0.16398773 P 4 1 CHC COL 2018 2019  
1805 1805 Eddie Butler 27 butleed01 2018 CHC NL 0.397323533 0.019877301 P 1 1 CHC COL 2017 2018 TEX
1960 1960 Brandon Barnes 32 barnebr02 2018 CLE AL 0.194134523 0.055 RF, CF, LF, 2B 0 1 CLE COL 2018 2018  
2078 2078 Collin McHugh 31 mchugco01 2018 HOU AL 2.094817319 1.695 P 8 1 HOU COL 2014 2019  
2141 2141 Jerry Vasto 26 vastoje01 2018 KCR AL 0.136000579 -0.055 P 0 2 KCR COL 2018 2018  
2256 2256 Zac Rosscup 30 rosscza01 2018 LAD NL 0.282495489 0.00993865 P 0 1 LAD COL 2018 2018 SEA
2480 2480 Jose Reyes 35 reyesjo01 2018 NYM NL 2.491101985 -1.035 3B, SS, 2B, P 0 1 NYM COL 2016 2018  
2512 2512 David Hale 30 haleda02 2018 NYY AL 0.23253705 0.165 P 1 1 NYY COL 2018 2018 MIN
2547 2547 Jonathan Lucroy 32 lucrojo01 2018 OAK AL 4.223933269 0.005 C 6 1 OAK COL 2018 2018 ANA
2602 2602 Pat Neshek 37 neshepa01 2018 PHI NL 0.871226256 0.555 P 3 1 PHI COL 2018 2019  
2702 2702 Jordan Lyles 27 lylesjo01 2018 SDP NL 1.738388153 0.16 P 3 1 SDP COL 2017 2018 MIL
2773 2773 Christian Bergman 30 bergmch01 2018 SEA AL 0.372135232 -0.07 P 0 1 SEA COL 2017 2018  
2803 2803 Nick Hundley 34 hundlni01 2018 SFG NL 3.050525953 -0.255 C 4 1 SFG COL 2017 2018 OAK
2875 2875 Greg Holland 32 hollagr01 2018 STL NL 0.659093102 -0.725 P 0 1 STL COL 2018 2018 WSN
3065 3065 Justin Miller 31 milleju02 2018 WSN NL 1.682554113 0.435 P 3 1 WSN COL 2018 2019  
3067 3067 Mark Reynolds 34 reynoma01 2018 WSN NL 2.291911888 -0.1 1B, 3B, 2B, CF, P, RF 3 1 WSN COL 2018 2018 COL
3114 3114 Daniel Descalso 30 descada01 2017 ARI NL 3.929860402 0.02 2B, LF, 1B, 3B, P, SS 6 1 ARI COL 2017 2018 CHC
3119 3119 Jorge De La Rosa 36 rosajo01 2017 ARI NL 1.687754684 0.315 P 3 1 ARI COL 2017 2018 CHC
3167 3167 Jason Motte 35 motteja01 2017 ATL NL 1.167161409 0.17 P 2 1 ATL COL 2017 2017  
3174 3174 Rex Brothers 29 brothre01 2017 ATL NL 0.650345431 -0.11 P 1 1 ATL COL 2017 2018  
3211 3211 Miguel Castro 22 castrmi01 2017 BAL AL 1.997483283 0.405 P 4 1 BAL COL 2017 2019  
3286 3286 Kyle Kendrick 32 kendrky01 2017 BOS AL 0.222730665 -0.21 P 0 1 BOS COL 2017 2017  
3288 3288 Josh Rutledge 28 rutlejo01 2017 BOS AL 1.083768804 -0.45 3B, 2B, 1B 0 1 BOS COL 2015 2017  
3312 3312 Eddie Butler 26 butleed01 2017 CHC NL 1.433314757 0.645 P 4 1 CHC COL 2017 2018 TEX
3351 3351 Tommy Kahnle 27 kahnlto01 2017 CHW AL 1.296779511 1.165 P 5 1 CHW COL 2016 2017 NYY
3467 3467 Boone Logan 32 loganbo02 2017 CLE AL 0.583724344 0.17 P 1 1 CLE COL 2017 2017 MIL
3584 3584 Collin McHugh 30 mchugco01 2017 HOU AL 1.793558568 1.18 P 6 1 HOU COL 2014 2019  
3702 3702 Jason Gurka 29 gurkaja01 2017 LAA AL 0.020147241 0.035 P 0 1 ANA COL 2017 2017  
3750 3750 Charlie Culberson 28 culbech01 2017 LAD NL 0.148362892 0.075 SS, 2B, 3B 0 1 LAD COL 2016 2017 ATL
3920 3920 Jose Reyes 34 reyesjo01 2017 NYM NL 5.566809239 0.795 SS, 3B, 2B, CF, LF 10 1 NYM COL 2016 2018  
4048 4048 Dustin Garneau 29 garnedu01 2017 OAK AL 0.494183189 0.17 C 1 2 OAK COL 2017 2017 CHW
4051 4051 Simon Castro 29 castrsi01 2017 OAK AL 0.986192853 -0.06 P 1 1 OAK COL 2017 2017  
4065 4065 John Axford 34 axforjo01 2017 OAK AL 0.543646852 -0.295 P 0 1 OAK COL 2016 2017 TOR
4211 4211 Jordan Lyles 26 lylesjo01 2017 SDP NL 0.651239868 -0.255 P 0 2 SDP COL 2017 2018 MIL
4248 4248 Christian Bergman 29 bergmch01 2017 SEA AL 1.558107554 -0.045 P 2 1 SEA COL 2017 2018  
4299 4299 Nick Hundley 33 hundlni01 2017 SFG NL 3.020106548 0.17 C 4 1 SFG COL 2017 2018 OAK
4384 4384 Corey Dickerson 28 dickeco01 2017 TBR AL 5.959163672 2.565 LF 15 1 TBD COL 2016 2017 PIT
4504 4504 Troy Tulowitzki 32 tulowtr01 2017 TOR AL 2.460032626 0.15 SS 4 1 TOR COL 2015 2017 NYY
4574 4574 Ryan Raburn 36 raburry01 2017 WSN NL 0.684102564 -0.03 LF 1 1 WSN COL 2017 2017  
4777 4777 Josh Rutledge 27 rutlejo01 2016 BOS AL 0.516129032 0.295 3B, 2B, SS 1 1 BOS COL 2015 2017  
4863 4863 Justin Morneau 35 morneju01 2016 CHW AL 2.069733181 0.165   3 1 CHW COL 2016 2016  
4865 4865 Tommy Kahnle 26 kahnlto01 2016 CHW AL 0.772880496 0.345 P 2 1 CHW COL 2016 2017 NYY
5090 5090 Collin McHugh 29 mchugco01 2016 HOU AL 5.110339293 1.745 P 12 1 HOU COL 2014 2019  
5200 5200 Rafael Ortega 25 ortegra01 2016 LAA AL 1.946179402 -0.365 LF, CF, RF 2 1 ANA COL 2016 2016 FLA
5248 5248 Charlie Culberson 27 culbech01 2016 LAD NL 0.674649333 0.28 SS, 2B, 3B, LF 2 1 LAD COL 2016 2017 ATL
5263 5263 Chin-hui Tsao 35 tsaoch01 2016 LAD NL 0.053245185 -0.06 P 0 1 LAD COL 2007 2016  
5276 5276 Brett Anderson 28 anderbr04 2016 LAD NL 0.311546245 -0.53 P 0 1 LAD COL 2015 2016 CHC
5440 5440 Jose Reyes 33 reyesjo01 2016 NYM NL 2.793853591 1.03 3B, SS 7 1 NYM COL 2016 2018  
5544 5544 John Axford 33 axforjo01 2016 OAK AL 2.246249684 0.59 P 5 1 OAK COL 2016 2017 TOR
5569 5569 Matt McBride 31 mcbrima02 2016 OAK AL 0.425475158 -0.21 C, 1B, RF 0 1 OAK COL 2016 2016  
5663 5663 Rob Scahill 29 scahiro01 2016 PIT NL 0.381705147 0.01 P 1 1 PIT COL 2015 2016 MIL
5693 5693 Christian Friedrich 28 friedch01 2016 SDP NL 3.613147024 0.885 P 8 1 SDP COL 2016 2016  
5875 5875 Michael McKenry 31 mckenmi01 2016 STL NL 0.019671019 -0.025   0 1 STL COL 2016 2016  
5888 5888 Corey Dickerson 27 dickeco01 2016 TBR AL 5.278857333 1.31 LF, RF 10 1 TBD COL 2016 2017 PIT
5986 5986 Troy Tulowitzki 31 tulowtr01 2016 TOR AL 5.089032258 3.175 SS 16 1 TOR COL 2015 2017 NYY
6101 6101 Jhoulys Chacin 27 chacijh01 2015 ARI NL 0.751090616 0.215 P 2 1 ARI COL 2015 2015 ATL
6116 6116 Jordan Pacheco 29 pachejo01 2015 ARI NL 0.760719691 -0.275 C, 1B, 3B 0 1 ARI COL 2014 2015 CIN
6122 6122 Matt Reynolds 30 reynoma02 2015 ARI NL 0.505969871 -0.335 P 0 1 ARI COL 2013 2015 SFG
6227 6227 Jorge Rondon 27 rondojo01 2015 BAL AL 0.250257354 -0.305 P 0 2 BAL COL 2015 2015 PIT
6264 6264 Josh Rutledge 26 rutlejo01 2015 BOS AL 0.793625241 0.095 2B, 3B 1 1 BOS COL 2015 2017  
6574 6574 Collin McHugh 28 mchugco01 2015 HOU AL 5.752734497 3.13 P 16 1 HOU COL 2014 2019  
6634 6634 Franklin Morales 29 moralfr01 2015 KCR AL 1.789849628 0.585 P 5 1 KCR COL 2015 2015 TOR
6643 6643 Jeremy Guthrie 36 guthrje01 2015 KCR AL 3.904328846 -1.225 P 3 1 KCR COL 2012 2015 WSN
6672 6672 Chris Iannetta 32 iannech01 2015 LAA AL 3.080764075 1.05 C, 1B 8 1 ANA COL 2012 2015 SEA
6720 6720 Brett Anderson 27 anderbr04 2015 LAD NL 4.952163227 1.515 P 11 1 LAD COL 2015 2016 CHC
6733 6733 Juan Nicasio 28 nicasju01 2015 LAD NL 1.806399258 0.56 P 4 1 LAD COL 2015 2015 PIT
6764 6764 Chin-hui Tsao 34 tsaoch01 2015 LAD NL 0.183025736 -0.3 P 0 1 LAD COL 2007 2016  
6795 6795 Nick Masset 33 masseni01 2015 MIA NL 0.263850689 0.115 P 1 1 FLA COL 2015 2015 ATL
6852 6852 Hector Gomez 27 gomezhe01 2015 MIL NL 1.360882507 -0.355 2B, 3B, SS, LF 1 1 MIL COL 2014 2015  
6902 6902 Doug Bernier 35 bernido01 2015 MIN AL 0.058029015 0.01 2B, 3B 0 1 MIN COL 2013 2015  
6927 6927 Michael Cuddyer 36 cuddymi01 2015 NYM NL 4.084930088 0.32 LF, 1B, RF 7 1 NYM COL 2015 2015  
6938 6938 Carlos Torres 32 torreca01 2015 NYM NL 1.739766581 0.045 P 3 1 NYM COL 2013 2015 MIL
6991 6991 Chris Martin 29 martich02 2015 NYY AL 0.55059032 0.005 P 1 1 NYY COL 2015 2015 TEX
7031 7031 Drew Pomeranz 26 pomerdr01 2015 OAK AL 3.136516279 0.815 P 6 1 OAK COL 2014 2015 SDP
7055 7055 Jason Pridie 31 pridija01 2015 OAK AL 0.094308943 -0.195 RF, CF, LF 0 1 OAK COL 2015 2015  
7108 7108 Kenny Roberts 27 roberke02 2015 PHI NL 0.097406953 -0.09 P 0 2 PHI COL 2015 2015  
7148 7148 Rob Scahill 28 scahiro01 2015 PIT NL 0.821453651 -0.185 P 1 1 PIT COL 2015 2016 MIL
7150 7150 Chris Volstad 28 volstch01 2015 PIT NL 0.037330167 0.035 P 0 1 PIT COL 2015 2015 CHW
7243 7243 Logan Kensing 32 kensilo01 2015 SEA AL 0.505065315 -0.18 P 0 1 SEA COL 2015 2015 DET
7292 7292 Jackson Williams 29 willija01 2015 SFG NL 0.140024142 0.095 C 0 1 SFG COL 2015 2015  

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