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,890 rows where next_franch = "CIN"

✎ 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
64 64 Kevin Gausman 28 gausmke01 2019 ATL NL 2.250572207 -0.142641509 P 4 1 ATL BAL 2018 2019 CIN
352 352 Trevor Bauer 28 bauertr01 2019 CLE AL 4.549457782 2.358679245 P 14 1 CLE ARI 2013 2019 CIN
1231 1231 R.J. Alaniz 28 alanirj01 2019 SEA AL 0.078939737 -0.305660377 P 0 1 SEA   2019 2019 CIN
1458 1458 Freddy Galvis 29 galvifr01 2019 TOR AL 4.598390882 1.650566038 SS, 2B 11 1 TOR SDP 2019 2019 CIN
1629 1629 Kevin Gausman 27 gausmke01 2018 ATL NL 1.649498591 0.95 P 5 2 ATL BAL 2018 2019 CIN
1641 1641 Preston Tucker 27 tuckepr01 2018 ATL NL 1.390511565 -0.045 LF, RF 2 1 ATL HOU 2018 2018 CIN
1648 1648 Matt Wisler 25 wislema01 2018 ATL NL 0.713552404 -0.165 P 1 1 ATL   2015 2018 CIN
1668 1668 Lucas Sims 24 simslu01 2018 ATL NL 0.229144936 -0.235 P 0 1 ATL   2017 2018 CIN
1929 1929 Trevor Bauer 27 bauertr01 2018 CLE AL 4.977575604 5.755 P 23 1 CLE ARI 2013 2019 CIN
2018 2018 Jose Iglesias 28 iglesjo01 2018 DET AL 4.477870216 2.335 SS 13 1 DET BOS 2013 2018 CIN
2103 2103 Tim Federowicz 30 federti01 2018 HOU AL 0.331645156 -0.25 C 0 1 HOU SFG 2018 2018 CIN
2224 2224 Yasiel Puig 27 puigya01 2018 LAD NL 4.274190871 2.231226994 RF 12 1 LAD   2013 2018 CIN
2228 2228 Matt Kemp 33 kempma01 2018 LAD NL 4.871037344 1.321840491 LF, RF 10 1 LAD ATL 2018 2018 CIN
2229 2229 Alex Wood 27 woodal02 2018 LAD NL 4.195648743 1.480858896 P 9 1 LAD ATL 2015 2018 CIN
2245 2245 Kyle Farmer 27 farmeky01 2018 LAD NL 0.741244813 0.193803681 3B, 1B, C 1 1 LAD   2017 2018 CIN
2272 2272 Derek Dietrich 28 dietrde01 2018 MIA NL 5.51 0.568509317 LF, 1B, 2B, 3B, RF 10 1 FLA   2013 2018 CIN
2411 2411 Juan Graterol 29 grateju01 2018 MIN AL 0.075668624 -0.02 C 0 2 MIN ANA 2018 2018 CIN
2461 2461 Matt Harvey 29 harvema01 2018 NYM NL 0.642668983 -0.165 P 0 1 NYM   2012 2018 CIN
2495 2495 Sonny Gray 28 grayso01 2018 NYY AL 3.585931795 1.045 P 8 1 NYY OAK 2017 2018 CIN
2660 2660 Ryan Lavarnway 30 lavarry01 2018 PIT NL 0.060511215 0.19621118   1 1 PIT OAK 2018 2018 CIN
2762 2762 Zach Duke 35 dukeza01 2018 SEA AL 0.474796641 0.035 P 1 2 SEA MIN 2018 2018 CIN
2872 2872 Matt Bowman 27 bowmama01 2018 STL NL 0.741113577 -0.36 P 0 1 STL   2016 2018 CIN
3049 3049 Tanner Roark 31 roarkta01 2018 WSN NL 5.177611044 2.995 P 15 1 WSN   2013 2018 CIN
3129 3129 David Hernandez 32 hernada01 2017 ARI NL 0.658567623 0.065 P 1 2 ARI ANA 2017 2017 CIN
3168 3168 Lucas Sims 23 simslu01 2017 ATL NL 1.637465984 -0.01 P 2 1 ATL   2017 2018 CIN
3188 3188 Matt Wisler 24 wislema01 2017 ATL NL 0.651566737 -0.435 P 0 1 ATL   2015 2018 CIN
3334 3334 Dylan Floro 26 florody01 2017 CHC NL 0.157315034 -0.115 P 0 1 CHC TBD 2017 2017 CIN
3441 3441 Trevor Bauer 26 bauertr01 2017 CLE AL 5.063017046 2.97 P 15 1 CLE ARI 2013 2019 CIN
3472 3472 Kyle Crockett 25 crockky01 2017 CLE AL 0.030800037 -0.025 P 0 1 CLE   2014 2017 CIN
3524 3524 Jose Iglesias 27 iglesjo01 2017 DET AL 4.628263708 1.57 SS 10 1 DET BOS 2013 2018 CIN
3651 3651 Luke Farrell 26 farrelu01 2017 KCR AL 0.074460319 -0.16 P 0 1 KCR   2017 2017 CIN
3686 3686 Cliff Pennington 33 pennicl01 2017 LAA AL 2.079643093 0.335 2B, 3B, SS 4 1 ANA TOR 2016 2017 CIN
3722 3722 Yasiel Puig 26 puigya01 2017 LAD NL 5.637789905 3.35 RF 19 1 LAD   2013 2018 CIN
3724 3724 Alex Wood 26 woodal02 2017 LAD NL 4.354449303 2.865 P 15 1 LAD ATL 2015 2018 CIN
3755 3755 Kyle Farmer 26 farmeky01 2017 LAD NL 0.19781719 -0.085 3B, C, 1B 0 1 LAD   2017 2018 CIN
3775 3775 Derek Dietrich 27 dietrde01 2017 MIA NL 4.538279933 1.555 3B, 1B, 2B, LF 11 1 FLA   2013 2018 CIN
3804 3804 Christian Colon 28 colonch01 2017 MIA NL 0.371669477 -0.055 3B, 2B 0 2 FLA KCR 2017 2017 CIN
3830 3830 Jared Hughes 31 hugheja02 2017 MIL NL 1.795446814 0.85 P 5 1 MIL PIT 2017 2017 CIN
3965 3965 Matt Harvey 28 harvema01 2017 NYM NL 2.636736008 -1.17 P 0 1 NYM   2012 2018 CIN
3986 3986 Sonny Gray 27 grayso01 2017 NYY AL 1.843575861 0.775 P 4 2 NYY OAK 2017 2018 CIN
4010 4010 Mason Williams 25 willima10 2017 NYY AL 0.155790804 -0.175 CF, RF 0 1 NYY   2015 2017 CIN
4215 4215 Kevin Quackenbush 28 quackke01 2017 SDP NL 0.645940311 -0.44 P 0 1 SDP   2014 2017 CIN
4240 4240 Yovani Gallardo 31 gallayo01 2017 SEA AL 3.499551984 -0.105 P 4 1 SEA BAL 2017 2017 CIN
4352 4352 Matt Bowman 26 bowmama01 2017 STL NL 2.22548082 0.445 P 4 1 STL   2016 2018 CIN
4413 4413 Curt Casali 28 casalcu01 2017 TBR AL 0.123162365 0.26 C 1 1 TBD   2014 2017 CIN
4473 4473 Phil Gosselin 28 gosseph01 2017 TEX AL 0.076140466 -0.135 2B, SS, 3B, 1B 0 2 TEX PIT 2017 2017 CIN
4552 4552 Tanner Roark 30 roarkta01 2017 WSN NL 5.00108851 1.815 P 13 1 WSN   2013 2018 CIN
4650 4650 Matt Wisler 23 wislema01 2016 ATL NL 4.553020103 0.437701863 P 8 1 ATL   2015 2018 CIN
4829 4829 Jake Buchanan 26 buchaja01 2016 CHC NL 0.132694497 0.16 P 1 1 CHC HOU 2016 2016 CIN
4951 4951 Trevor Bauer 25 bauertr01 2016 CLE AL 5.272891638 2.379689441 P 15 1 CLE ARI 2013 2019 CIN
4976 4976 Kyle Crockett 24 crockky01 2016 CLE AL 0.453791947 0.191180124 P 1 1 CLE   2014 2017 CIN
5047 5047 Jose Iglesias 26 iglesjo01 2016 DET AL 4.874508519 1.977204969 SS 13 1 DET BOS 2013 2018 CIN
5162 5162 Tony Cruz 29 cruzto03 2016 KCR AL 0.048084895 -0.11 C 0 1 KCR STL 2016 2016 CIN
5193 5193 Cliff Pennington 32 pennicl01 2016 LAA AL 1.811295681 0.11 2B, SS, 1B, 3B 3 1 ANA TOR 2016 2017 CIN
5232 5232 Yasiel Puig 25 puigya01 2016 LAD NL 3.651043449 1.135 RF, LF, CF 9 1 LAD   2013 2018 CIN
5242 5242 Alex Wood 25 woodal02 2016 LAD NL 1.515085546 0.94 P 5 1 LAD ATL 2015 2018 CIN
5283 5283 Derek Dietrich 26 dietrde01 2016 MIA NL 4.107959429 2.435031056 2B, 1B, 3B, LF 13 1 FLA   2013 2018 CIN
5322 5322 Austin Brice 24 briceau01 2016 MIA NL 0.321055579 -0.19621118 P 0 1 FLA   2016 2016 CIN
5341 5341 Scooter Gennett 26 gennesc01 2016 MIL NL 5.465229485 0.56 2B 9 1 MIL   2013 2016 CIN
5443 5443 Matt Harvey 27 harvema01 2016 NYM NL 2.576719958 0.88 P 6 1 NYM   2012 2018 CIN
5520 5520 Mason Williams 24 willima10 2016 NYY AL 0.278522934 -0.105 RF, CF, LF 0 1 NYY   2015 2017 CIN
5571 5571 Arismendy Alcantara 24 alcanar01 2016 OAK AL 0.183727909 -0.27 CF, 2B, SS, RF 0 1 OAK CHC 2016 2016 CIN
5706 5706 Kevin Quackenbush 27 quackke01 2016 SDP NL 1.829955319 0.19 P 3 1 SDP   2014 2017 CIN
5727 5727 Patrick Kivlehan 26 kivlepa01 2016 SDP NL 0.193639079 -0.035 RF, LF 0 1 SDP   2016 2016 CIN
5771 5771 Drew Storen 28 storedr01 2016 SEA AL 0.560186076 0.285 P 2 2 SEA TOR 2016 2016 CIN
5860 5860 Matt Bowman 25 bowmama01 2016 STL NL 2.026524982 0.565 P 4 1 STL   2016 2018 CIN
5898 5898 Curt Casali 27 casalcu01 2016 TBR AL 2.466035542 0.795 C 5 1 TBD   2014 2017 CIN
6026 6026 Scott Feldman 33 feldmsc01 2016 TOR AL 0.351134685 -0.275 P 0 2 TOR HOU 2016 2016 CIN
6033 6033 Tanner Roark 29 roarkta01 2016 WSN NL 5.827106232 4.445 P 22 1 WSN   2013 2018 CIN
6116 6116 Jordan Pacheco 29 pachejo01 2015 ARI NL 0.760719691 -0.275 C, 1B, 3B 0 1 ARI COL 2014 2015 CIN
6134 6134 Matt Wisler 22 wislema01 2015 ATL NL 2.981565907 0.4 P 6 1 ATL   2015 2018 CIN
6430 6430 Trevor Bauer 24 bauertr01 2015 CLE AL 5.101607869 1.710559006 P 11 1 CLE ARI 2013 2019 CIN
6451 6451 Kyle Crockett 23 crockky01 2015 CLE AL 0.453963714 0.11068323 P 1 1 CLE   2014 2017 CIN
6466 6466 Tyler Holt 26 holtty01 2015 CLE AL 0.200164339 -0.321987578 CF, LF, RF 0 1 CLE   2014 2015 CIN
6529 6529 Jose Iglesias 25 iglesjo01 2015 DET AL 4.29419439 1.504285714 SS 10 1 DET BOS 2013 2018 CIN
6533 6533 Alfredo Simon 34 simonal01 2015 DET AL 5.325206653 0.357204969 P 9 1 DET CIN 2015 2015 CIN
6603 6603 Dan Straily 26 straida01 2015 HOU AL 0.423186671 0.005 P 1 1 HOU CHC 2015 2015 CIN
6611 6611 Asher Wojciechowski 26 wojcias01 2015 HOU AL 0.387729137 -0.14 P 0 1 HOU   2015 2015 CIN
6646 6646 Brandon Finnegan 22 finnebr01 2015 KCR AL 0.644124528 0.16 P 2 1 KCR   2014 2015 CIN
6697 6697 Ryan Mattheus 31 matthry01 2015 LAA AL 0.018716355 0.02 P 0 1 ANA WSN 2015 2015 CIN
6721 6721 Yasiel Puig 24 puigya01 2015 LAD NL 3.140867143 1.305 RF 8 1 LAD   2013 2018 CIN
6734 6734 Alex Wood 24 woodal02 2015 LAD NL 1.931435196 0.49 P 4 2 LAD ATL 2015 2018 CIN
6739 6739 Scott Schebler 24 schebsc01 2015 LAD NL 0.40397005 0.435 LF, RF 2 1 LAD   2015 2015 CIN
6756 6756 Jose Peraza 21 perazjo01 2015 LAD NL 0.252481282 -0.145 2B, CF 0 1 LAD   2015 2015 CIN
6784 6784 Derek Dietrich 25 dietrde01 2015 MIA NL 2.956261023 0.445 LF, 3B, 1B, 2B 5 1 FLA   2013 2018 CIN
6831 6831 Scooter Gennett 25 gennesc01 2015 MIL NL 3.970933287 0.425 2B 7 1 MIL   2013 2016 CIN
6913 6913 Matt Harvey 26 harvema01 2015 NYM NL 5.185224963 4.25 P 20 1 NYM   2012 2018 CIN
6940 6940 Dilson Herrera 21 herredi01 2015 NYM NL 1.031244606 0.225 2B 2 1 NYM   2014 2015 CIN
6988 6988 Mason Williams 23 willima10 2015 NYY AL 0.20442166 0.16 CF 1 1 NYY   2015 2017 CIN
7008 7008 Caleb Cotham 27 cothaca01 2015 NYY AL 0.227320674 -0.135 P 0 1 NYY   2015 2015 CIN
7189 7189 Kevin Quackenbush 26 quackke01 2015 SDP NL 1.356956589 0.125 P 2 1 SDP   2014 2017 CIN
7247 7247 JC Ramirez 26 ramirjc01 2015 SEA AL 0.24465593 -0.275 P 0 2 SEA ARI 2015 2015 CIN
7368 7368 Curt Casali 26 casalcu01 2015 TBR AL 1.083126756 1.1 C 5 1 TBD   2014 2017 CIN
7440 7440 Ross Ohlendorf 32 ohlenro01 2015 TEX AL 0.579224681 0.075 P 1 1 TEX WSN 2015 2015 CIN
7512 7512 Steve Delabar 31 delabst01 2015 TOR AL 0.868932521 -0.31 P 0 1 TOR SEA 2012 2015 CIN
7533 7533 Tanner Roark 28 roarkta01 2015 WSN NL 3.262510124 0.275 P 5 1 WSN   2013 2018 CIN
7552 7552 Abel De Los Santos 22 delosab01 2015 WSN NL 0.026606956 -0.05 P 0 1 WSN   2015 2015 CIN
7572 7572 Bronson Arroyo 37 arroybr01 2014 ARI NL 2.404983821 0.585 P 5 1 ARI CIN 2014 2014 CIN
7606 7606 Jordan Pacheco 28 pachejo01 2014 ARI NL 0.855902778 -0.33 C, 1B, 3B, 2B 0 2 ARI COL 2014 2015 CIN
7705 7705 Burke Badenhop 31 badenbu01 2014 BOS AL 2.232999992 1.13 P 6 1 BOS MIL 2014 2014 CIN

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