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,775 rows where next_franch = "CHW"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, lg_ID, stint_ID, franch_id, prev_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
888 888 Hector Santiago 31 santihe01 2019 NYM NL 0.17546696 -0.071320755 P 0 1 NYM CHW 2019 2019 CHW
1498 1498 Jimmy Cordero 27 cordeji01 2019 TOR AL 0.034495847 -0.056037736 P 0 1 TOR WSN 2019 2019 CHW
1586 1586 Jon Jay 33 jayjo02 2018 ARI NL 3.186266094 -0.17 RF, LF, CF 4 2 ARI KCR 2018 2018 CHW
1937 1937 Yonder Alonso 31 alonsyo01 2018 CLE AL 5.30634364 1.125 1B 10 1 CLE SEA 2018 2018 CHW
1967 1967 Evan Marshall 28 marshev01 2018 CLE AL 0.215459196 -0.06 P 0 1 CLE SEA 2018 2018 CHW
2035 2035 James McCann 28 mccanja02 2018 DET AL 4.41031614 -0.615 C 4 1 DET   2014 2018 CHW
2102 2102 AJ Reed 25 reedaj01 2018 HOU AL 0.028426728 -0.09 1B 0 1 HOU   2016 2018 CHW
2137 2137 Ryan Goins 30 goinsry01 2018 KCR AL 1.152127131 -0.22 2B, 3B, SS 1 1 KCR TOR 2018 2018 CHW
2208 2208 Odrisamer Despaigne 31 despaod01 2018 LAA AL 0.501930066 -0.38 P 0 2 ANA FLA 2018 2018 CHW
2409 2409 Ryan LaMarre 29 lamarry01 2018 MIN AL 1.030984997 -0.06 CF, LF, RF, P 1 1 MIN OAK 2018 2018 CHW
2423 2423 Ervin Santana 35 santaer01 2018 MIN AL 0.68744389 -0.55 P 0 1 MIN ATL 2015 2018 CHW
2572 2572 Trayce Thompson 27 thomptr01 2018 OAK AL 0.065126724 -0.02 RF, LF, CF 0 1 OAK LAD 2018 2018 CHW
2643 2643 Ivan Nova 31 novaiv01 2018 PIT NL 4.616476279 0.623850932 P 9 1 PIT NYY 2016 2018 CHW
2744 2744 Alex Colome 29 colomal01 2018 SEA AL 1.795782665 0.865 P 5 2 SEA TBD 2018 2018 CHW
2771 2771 Ross Detwiler 32 detwiro01 2018 SEA AL 0.177306252 0.0 P 0 1 SEA OAK 2018 2018 CHW
2826 2826 Josh Osich 29 osichjo01 2018 SFG NL 0.318237869 -0.325 P 0 1 SFG   2015 2018 CHW
3076 3076 Kelvin Herrera 28 herreke01 2018 WSN NL 0.58618979 -0.06 P 1 2 WSN KCR 2018 2018 CHW
3198 3198 Welington Castillo 30 castiwe01 2017 BAL AL 3.458020255 2.08 C 12 1 BAL ARI 2017 2017 CHW
3528 3528 James McCann 27 mccanja02 2017 DET AL 3.700718016 1.14 C 8 1 DET   2014 2018 CHW
3562 3562 Bruce Rondon 26 rondobr01 2017 DET AL 0.525641891 -0.33 P 0 1 DET   2013 2017 CHW
3608 3608 AJ Reed 24 reedaj01 2017 HOU AL 0.055751362 -0.185 1B 0 1 HOU   2016 2018 CHW
3628 3628 Joakim Soria 33 soriajo01 2017 KCR AL 2.04029238 1.375 P 7 1 KCR PIT 2016 2017 CHW
3636 3636 Al Alburquerque 31 albural01 2017 KCR AL 0.212032727 0.135 P 1 1 KCR ANA 2017 2017 CHW
3738 3738 Luis Avilan 27 avilalu01 2017 LAD NL 1.391036678 0.595 P 4 1 LAD ATL 2015 2017 CHW
3857 3857 Rob Scahill 30 scahiro01 2017 MIL NL 0.635978136 -0.26 P 0 1 MIL PIT 2016 2017 CHW
3864 3864 Ervin Santana 34 santaer01 2017 MIN AL 6.028787514 3.885 P 20 1 MIN ATL 2015 2018 CHW
3888 3888 Hector Santiago 29 santihe01 2017 MIN AL 2.102478443 -0.145 P 3 1 MIN ANA 2016 2017 CHW
4000 4000 Tyler Clippard 32 clippty01 2017 NYY AL 1.282938063 -0.135 P 1 1 NYY ARI 2016 2017 CHW
4048 4048 Dustin Garneau 29 garnedu01 2017 OAK AL 0.494183189 0.17 C 1 2 OAK COL 2017 2017 CHW
4116 4116 Jeanmar Gomez 29 gomezje01 2017 PHI NL 0.723602802 -0.565 P 0 1 PHI PIT 2015 2017 CHW
4130 4130 Ivan Nova 30 novaiv01 2017 PIT NL 5.319082617 1.485 P 12 1 PIT NYY 2016 2018 CHW
4161 4161 Alen Hanson 24 hansoal01 2017 PIT NL 0.588680544 -0.305 RF, 2B, CF, LF, SS, 3B 0 1 PIT   2016 2017 CHW
4203 4203 Jose Ruiz 22 ruizjo01 2017 SDP NL 0.016958583 0.015 P 0 1 SDP   2017 2017 CHW
4263 4263 Thyago Vieira 23 vieirth01 2017 SEA AL 0.014796843 0.015 P 0 1 SEA   2017 2017 CHW
4324 4324 Josh Osich 28 osichjo01 2017 SFG NL 1.188464569 -0.485 P 0 1 SFG   2015 2018 CHW
4409 4409 Danny Farquhar 30 farquda01 2017 TBR AL 1.124027685 0.195 P 2 1 TBD SEA 2016 2017 CHW
4431 4431 Xavier Cedeno 30 cedenxa01 2017 TBR AL 0.153714435 -0.74 P 0 1 TBD WSN 2015 2017 CHW
4461 4461 Miguel Gonzalez 33 gonzami03 2017 TEX AL 0.647168124 -0.12 P 1 2 TEX CHW 2017 2017 CHW
4785 4785 Yoan Moncada 21 moncayo01 2016 BOS AL 0.184331797 -0.07 3B 0 1 BOS   2016 2016 CHW
5055 5055 James McCann 26 mccanja02 2016 DET AL 3.54423329 0.769751553 C 7 1 DET   2014 2018 CHW
5057 5057 Mike Pelfrey 32 pelfrmi01 2016 DET AL 3.273500665 0.332049689 P 6 1 DET MIN 2016 2016 CHW
5061 5061 Bruce Rondon 25 rondobr01 2016 DET AL 1.224628015 0.709378882 P 4 1 DET   2013 2017 CHW
5126 5126 AJ Reed 23 reedaj01 2016 HOU AL 1.323086879 -0.635 1B 0 1 HOU   2016 2018 CHW
5146 5146 Joakim Soria 32 soriajo01 2016 KCR AL 2.507060173 0.295 P 5 1 KCR PIT 2016 2017 CHW
5195 5195 Geovany Soto 33 sotoge01 2016 LAA AL 0.828571429 0.335 C, 1B, 3B 2 1 ANA CHW 2016 2016 CHW
5247 5247 Luis Avilan 26 avilalu01 2016 LAD NL 0.637060064 0.41 P 2 1 LAD ATL 2015 2017 CHW
5356 5356 Rob Scahill 29 scahiro01 2016 MIL NL 0.392186402 0.33 P 2 2 MIL PIT 2016 2017 CHW
5382 5382 Ervin Santana 33 santaer01 2016 MIN AL 5.143709068 3.585 P 16 1 MIN ATL 2015 2018 CHW
5404 5404 Hector Santiago 28 santihe01 2016 MIN AL 1.73052978 0.16 P 2 2 MIN ANA 2016 2017 CHW
5496 5496 Tyler Clippard 31 clippty01 2016 NYY AL 0.874809005 0.535 P 3 2 NYY ARI 2016 2017 CHW
5512 5512 Anthony Swarzak 30 swarzan01 2016 NYY AL 0.828919222 -0.195 P 1 1 NYY CLE 2016 2016 CHW
5594 5594 Jeanmar Gomez 28 gomezje01 2016 PHI NL 2.7587836 0.16 P 5 1 PHI PIT 2015 2017 CHW
5614 5614 Cody Asche 26 ascheco01 2016 PHI NL 2.227232693 -0.695 LF 1 1 PHI   2013 2016 CHW
5643 5643 Ivan Nova 29 novaiv01 2016 PIT NL 1.801864012 1.53 P 7 2 PIT NYY 2016 2018 CHW
5681 5681 Alen Hanson 23 hansoal01 2016 PIT NL 0.322222222 -0.31 2B 0 1 PIT   2016 2017 CHW
5699 5699 James Shields 34 shielja02 2016 SDP NL 1.911741031 0.615 P 5 1 SDP KCR 2015 2016 CHW
5739 5739 Jose Rondon 22 rondojo02 2016 SDP NL 0.264979793 -0.65 SS 0 1 SDP   2016 2016 CHW
5840 5840 Josh Osich 27 osichjo01 2016 SFG NL 1.257609843 -0.665 P 0 1 SFG   2015 2018 CHW
5900 5900 Xavier Cedeno 29 cedenxa01 2016 TBR AL 1.585518728 0.72 P 4 1 TBD WSN 2015 2017 CHW
5914 5914 Danny Farquhar 29 farquda01 2016 TBR AL 1.121496264 0.05 P 1 1 TBD SEA 2016 2017 CHW
5944 5944 Derek Holland 29 hollade01 2016 TEX AL 2.873486275 0.92 P 8 1 TEX   2009 2016 CHW
5976 5976 Anthony Ranaudo 26 ranauan01 2016 TEX AL 0.122433541 -0.375 P 0 1 TEX BOS 2015 2016 CHW
6058 6058 Reynaldo Lopez 22 lopezre01 2016 WSN NL 1.105251628 0.135 P 2 1 WSN   2016 2016 CHW
6073 6073 Lucas Giolito 21 giolilu01 2016 WSN NL 0.554573051 -0.505 P 0 1 WSN   2016 2016 CHW
6176 6176 Manny Banuelos 24 banuema01 2015 ATL NL 0.720317146 -0.285 P 0 1 ATL   2015 2015 CHW
6196 6196 Miguel Gonzalez 31 gonzami03 2015 BAL AL 4.150202856 0.54 P 7 1 BAL   2012 2015 CHW
6310 6310 Austin Jackson 28 jacksau01 2015 CHC NL 0.786879615 0.1 CF, RF, LF 2 2 CHC SEA 2015 2015 CHW
6319 6319 Mike Olt 26 oltmi01 2015 CHC NL 0.159368023 -0.015 3B, 1B 0 1 CHC TEX 2014 2015 CHW
6374 6374 Todd Frazier 29 frazito01 2015 CIN NL 6.71172555 4.155 3B 20 1 CIN   2011 2015 CHW
6421 6421 David Holmberg 23 holmbda01 2015 CIN NL 0.795768611 -0.7 P 0 1 CIN ARI 2014 2015 CHW
6454 6454 Jerry Sands 27 sandsje01 2015 CLE AL 1.267707477 -0.115714286 RF, 1B, LF 1 1 CLE TBD 2015 2015 CHW
6485 6485 Justin Morneau 34 morneju01 2015 COL NL 1.835826087 0.44 1B 4 1 COL PIT 2014 2015 CHW
6508 6508 Tommy Kahnle 25 kahnlto01 2015 COL NL 1.050752703 -0.145 P 1 1 COL   2014 2015 CHW
6538 6538 James McCann 25 mccanja02 2015 DET AL 4.019895629 0.160993789 C 6 1 DET   2014 2018 CHW
6546 6546 Alex Avila 28 avilaal01 2015 DET AL 2.071428571 -0.30689441 C, 1B 2 1 DET   2009 2015 CHW
6563 6563 Bruce Rondon 24 rondobr01 2015 DET AL 1.141050794 -0.382360248 P 0 1 DET   2013 2017 CHW
6700 6700 Mat Latos 27 latosma01 2015 LAA AL 0.069724662 -0.05 P 0 3 ANA LAD 2015 2015 CHW
6722 6722 Jimmy Rollins 36 rolliji01 2015 LAD NL 5.685878461 0.18 SS 8 1 LAD PHI 2015 2015 CHW
6747 6747 Luis Avilan 25 avilalu01 2015 LAD NL 0.585838164 -0.065 P 1 2 LAD ATL 2015 2017 CHW
6879 6879 Ervin Santana 32 santaer01 2015 MIN AL 2.997413318 1.495 P 9 1 MIN ATL 2015 2018 CHW
7022 7022 Brett Lawrie 25 lawribr01 2015 OAK AL 5.677398374 1.525 3B, 2B 12 1 OAK TOR 2015 2015 CHW
7081 7081 Jeanmar Gomez 27 gomezje01 2015 PHI NL 2.080752119 1.07 P 6 1 PHI PIT 2015 2017 CHW
7087 7087 Cody Asche 25 ascheco01 2015 PHI NL 4.600452253 -0.83 LF, 3B 4 1 PHI   2013 2016 CHW
7150 7150 Chris Volstad 28 volstch01 2015 PIT NL 0.037330167 0.035 P 0 1 PIT COL 2015 2015 CHW
7168 7168 James Shields 33 shielja02 2015 SDP NL 5.759515518 1.42 P 13 1 SDP KCR 2015 2016 CHW
7287 7287 Josh Osich 26 osichjo01 2015 SFG NL 0.949794411 0.09 P 2 1 SFG   2015 2018 CHW
7305 7305 Hector Sanchez 25 sanchhe01 2015 SFG NL 0.590101742 -0.355 C 0 1 SFG   2011 2015 CHW
7370 7370 Xavier Cedeno 28 cedenxa01 2015 TBR AL 1.424834305 0.995 P 5 2 TBD WSN 2015 2017 CHW
7434 7434 Derek Holland 28 hollade01 2015 TEX AL 1.635224114 0.145 P 3 1 TEX   2009 2016 CHW
7456 7456 Anthony Ranaudo 25 ranauan01 2015 TEX AL 0.365679675 -0.18 P 0 1 TEX BOS 2015 2016 CHW
7486 7486 Dioner Navarro 31 navardi01 2015 TOR AL 1.794103432 0.425 C 4 1 TOR CHC 2014 2015 CHW
7636 7636 Emilio Bonifacio 29 bonifem01 2014 ATL NL 1.300858595 -0.195 CF, 2B, 3B, RF, LF, SS 1 2 ATL CHC 2014 2014 CHW
7661 7661 Miguel Gonzalez 30 gonzami03 2014 BAL AL 4.212167051 1.24 P 10 1 BAL   2012 2015 CHW
7781 7781 Mike Olt 25 oltmi01 2014 CHC NL 2.595213319 -0.625 3B, 1B 1 1 CHC TEX 2014 2015 CHW
7788 7788 Jacob Turner 23 turneja01 2014 CHC NL 0.943291836 -0.275 P 0 2 CHC FLA 2014 2014 CHW
7842 7842 Todd Frazier 28 frazito01 2014 CIN NL 6.805333333 4.84 3B, 1B 24 1 CIN   2011 2015 CHW
7885 7885 David Holmberg 22 holmbda01 2014 CIN NL 0.763909817 -0.555 P 0 1 CIN ARI 2014 2015 CHW
7929 7929 JB Shuck 27 shuckja01 2014 CLE AL 0.243186583 -0.535 LF, RF 0 2 CLE ANA 2014 2014 CHW
7935 7935 Justin Morneau 33 morneju01 2014 COL NL 5.469821674 2.73 1B 15 1 COL PIT 2014 2015 CHW
7957 7957 Tommy Kahnle 24 kahnlto01 2014 COL NL 1.998824736 -0.11 P 2 1 COL   2014 2015 CHW

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