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

3,029 rows where next_franch = "PHI"

✎ 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
325 325 Jared Hughes 33 hugheja02 2019 CIN NL 1.449513691 0.020377358 P 2 1 CIN MIL 2018 2019 PHI
377 377 Brad Miller 29 millebr02 2019 CLE AL 0.386537821 0.147735849 3B, LF, 2B, RF, SS 1 1 CLE MIL 2019 2019 PHI
831 831 Blake Parker 34 parkebl01 2019 MIN AL 1.287406119 0.045849057 P 2 1 MIN ANA 2019 2019 PHI
834 834 Mike Morin 28 morinmi01 2019 MIN AL 0.584721861 0.142641509 P 1 1 MIN SEA 2019 2019 PHI
864 864 Jason Vargas 36 vargaja01 2019 NYM NL 2.565052544 1.21245283 P 7 1 NYM KCR 2018 2019 PHI
1079 1079 Corey Dickerson 30 dickeco01 2019 PIT NL 1.418044077 0.54 LF 4 1 PIT TBD 2018 2019 PHI
1160 1160 Jose Pirela 29 pireljo01 2019 SDP NL 0.051491477 -0.13245283 LF, RF 0 1 SDP NYY 2016 2019 PHI
1190 1190 Jay Bruce 32 bruceja01 2019 SEA AL 1.75931421 0.453396226 LF, RF, 1B 4 1 SEA NYM 2019 2019 PHI
1296 1296 Nick Vincent 32 vinceni01 2019 SFG NL 0.683567224 -0.320943396 P 0 1 SFG SEA 2019 2019 PHI
1453 1453 Drew Smyly 30 smylydr01 2019 TEX AL 1.430486287 -0.80490566 P 0 1 TEX TBD 2019 2019 PHI
1597 1597 Fernando Salas 33 salasfe01 2018 ARI NL 1.101047812 -0.12 P 1 1 ARI ANA 2018 2018 PHI
1839 1839 Luis Avilan 28 avilalu01 2018 CHW AL 1.300090207 0.62 P 4 1 CHW LAD 2018 2018 PHI
1877 1877 Jared Hughes 32 hugheja02 2018 CIN NL 2.881136849 2.315 P 11 1 CIN MIL 2018 2019 PHI
1912 1912 Phil Gosselin 29 gosseph01 2018 CIN NL 0.275581198 -0.155 3B, 1B, 2B, LF 0 1 CIN TEX 2018 2018 PHI
2165 2165 Jose Alvarez 29 alvarjo02 2018 LAA AL 2.391549137 1.305 P 7 1 ANA DET 2014 2018 PHI
2267 2267 J.T. Realmuto 27 realmjt01 2018 MIA NL 5.31 4.613478261 C, 1B 22 1 FLA   2014 2018 PHI
2273 2273 Justin Bour 30 bourju01 2018 MIA NL 4.47 0.598695652 1B 9 1 FLA   2014 2018 PHI
2399 2399 Logan Morrison 30 morrilo01 2018 MIN AL 3.395629485 -0.505 1B, LF 3 1 MIN TBD 2018 2018 PHI
2431 2431 Asdrubal Cabrera 32 cabreas01 2018 NYM NL 4.039356605 1.81 2B, SS, 3B 11 1 NYM TBD 2016 2018 PHI
2436 2436 Jose Bautista 37 bautijo02 2018 NYM NL 2.997262149 0.875 RF, LF, 3B, 1B, 2B 7 2 NYM ATL 2018 2018 PHI
2445 2445 Jason Vargas 35 vargaja01 2018 NYM NL 2.514255062 0.02 P 3 1 NYM KCR 2018 2019 PHI
2499 2499 David Robertson 33 roberda08 2018 NYY AL 2.524279884 1.175 P 7 1 NYY CHW 2017 2018 PHI
2503 2503 Andrew McCutchen 31 mccutan01 2018 NYY AL 1.058089294 0.78 RF, LF 4 2 NYY SFG 2018 2018 PHI
2633 2633 Corey Dickerson 29 dickeco01 2018 PIT NL 5.375412972 3.250062112 LF 18 1 PIT TBD 2018 2019 PHI
2658 2658 Sean Rodriguez 33 rodrise01 2018 PIT NL 1.744740045 -0.206273292 2B, SS, LF, CF, RF, 1B, 3B 2 1 PIT ATL 2017 2018 PHI
2696 2696 Jose Pirela 28 pireljo01 2018 SDP NL 4.757891086 -0.43 2B, LF, 1B, RF 6 1 SDP NYY 2016 2019 PHI
2729 2729 Jean Segura 28 segurje01 2018 SEA AL 6.043858203 4.02 SS 22 1 SEA ARI 2017 2018 PHI
2755 2755 Juan Nicasio 31 nicasju01 2018 SEA AL 1.615357962 -0.2 P 2 1 SEA STL 2018 2018 PHI
2888 2888 Wilson Ramos 30 ramoswi01 2018 TBR AL 2.959663049 1.75 C 9 1 TBD WSN 2017 2018 PHI
3013 3013 Aaron Loup 30 loupaa01 2018 TOR AL 0.887412633 0.225 P 2 1 TOR   2012 2018 PHI
3050 3050 Bryce Harper 25 harpebr03 2018 WSN NL 6.7782075 2.35 RF, CF, 1B 15 1 WSN   2012 2018 PHI
3225 3225 Hyun Soo Kim 29 kimhy01 2017 BAL AL 1.34531199 -0.345 LF, RF 1 1 BAL   2016 2017 PHI
3296 3296 Jake Arrieta 31 arrieja01 2017 CHC NL 4.743309471 2.24 P 14 1 CHC BAL 2013 2017 PHI
3369 3369 Rob Brantly 27 brantro01 2017 CHW AL 0.345752608 0.245 C, P 1 1 CHW FLA 2015 2017 PHI
3440 3440 Carlos Santana 31 santaca01 2017 CLE AL 6.2266216 3.095 1B, RF 17 1 CLE   2010 2017 PHI
3495 3495 Pat Neshek 36 neshepa01 2017 COL NL 0.842045389 0.835 P 4 2 COL PHI 2017 2017 PHI
3688 3688 Jose Alvarez 28 alvarjo02 2017 LAA AL 1.579424577 0.33 P 3 1 ANA DET 2014 2018 PHI
3772 3772 J.T. Realmuto 26 realmjt01 2017 MIA NL 5.66306914 4.145 C, 1B 20 1 FLA   2014 2018 PHI
3774 3774 Justin Bour 29 bourju01 2017 MIA NL 4.195952782 2.395 1B 13 1 FLA   2014 2018 PHI
3918 3918 Asdrubal Cabrera 31 cabreas01 2017 NYM NL 5.358426005 1.345 SS, 3B, 2B 11 1 NYM TBD 2016 2018 PHI
3951 3951 Ty Kelly 28 kellyty01 2017 NYM NL 0.009923011 -0.015 2B, LF, 3B, RF, CF 0 1 NYM   2016 2017 PHI
3980 3980 David Robertson 32 roberda08 2017 NYY AL 1.214731994 1.45 P 6 2 NYY CHW 2017 2018 PHI
4135 4135 Juan Nicasio 30 nicasju01 2017 PIT NL 2.226868641 1.37 P 7 1 PIT LAD 2016 2017 PHI
4154 4154 Sean Rodriguez 32 rodrise01 2017 PIT NL 1.057629451 -0.295 3B, RF, 2B, SS, LF, CF, 1B 1 2 PIT ATL 2017 2018 PHI
4174 4174 Jose Pirela 27 pireljo01 2017 SDP NL 3.533203471 1.975 LF, 2B, 1B, RF, 3B 12 1 SDP NYY 2016 2019 PHI
4226 4226 Jean Segura 27 segurje01 2017 SEA AL 5.347450725 3.1 SS 16 1 SEA ARI 2017 2018 PHI
4265 4265 Zac Curtis 24 curtiza01 2017 SEA AL 0.076647646 -0.05 P 0 1 SEA ARI 2017 2017 PHI
4278 4278 Casey Fien 33 fienca01 2017 SEA AL 0.165132766 -0.42 P 0 1 SEA LAD 2017 2017 PHI
4362 4362 Kevin Siegrist 27 siegrke01 2017 STL NL 0.985747175 -0.05 P 1 1 STL   2013 2017 PHI
4392 4392 Tommy Hunter 30 hunteto02 2017 TBR AL 2.038236868 1.205 P 6 1 TBD BAL 2017 2017 PHI
4405 4405 Wilson Ramos 29 ramoswi01 2017 TBR AL 2.122182293 0.165 C 3 1 TBD WSN 2017 2018 PHI
4430 4430 Trevor Plouffe 31 plouftr01 2017 TBR AL 1.080039203 -0.52 3B, 1B, 2B 0 2 TBD OAK 2017 2017 PHI
4499 4499 Aaron Loup 29 loupaa01 2017 TOR AL 1.682620837 0.715 P 5 1 TOR   2012 2018 PHI
4547 4547 Bryce Harper 24 harpebr03 2017 WSN NL 4.877948718 4.705 RF 21 1 WSN   2012 2018 PHI
4717 4717 Hyun Soo Kim 28 kimhy01 2016 BAL AL 3.311004785 0.83 LF 7 1 BAL   2016 2017 PHI
4764 4764 Clay Buchholz 31 buchhcl01 2016 BOS AL 3.717355064 0.285 P 5 1 BOS   2007 2016 PHI
4803 4803 Jake Arrieta 30 arrieja01 2016 CHC NL 5.543681214 4.445 P 21 1 CHC BAL 2013 2017 PHI
4950 4950 Carlos Santana 30 santaca01 2016 CLE AL 6.509624796 3.26515528 1B 19 1 CLE   2010 2017 PHI
5105 5105 Pat Neshek 35 neshepa01 2016 HOU AL 1.501277473 0.54 P 4 1 HOU STL 2015 2016 PHI
5163 5163 Daniel Nava 33 navada01 2016 KCR AL 0.115403747 -0.16 LF, 1B, RF 0 2 KCR ANA 2016 2016 PHI
5187 5187 Jose Alvarez 27 alvarjo02 2016 LAA AL 1.819526035 0.405 P 4 1 ANA DET 2014 2018 PHI
5233 5233 Howie Kendrick 32 kendrho01 2016 LAD NL 5.387273349 0.555 LF, 2B, 3B, 1B 9 1 LAD ANA 2015 2016 PHI
5260 5260 A.J. Ellis 35 ellisaj01 2016 LAD NL 1.597331509 -0.315 C 1 1 LAD   2008 2016 PHI
5282 5282 J.T. Realmuto 25 realmjt01 2016 MIA NL 5.434072546 2.369627329 C 14 1 FLA   2014 2018 PHI
5290 5290 Justin Bour 28 bourju01 2016 MIA NL 3.200618876 1.232608696 1B 8 1 FLA   2014 2018 PHI
5432 5432 Asdrubal Cabrera 30 cabreas01 2016 NYM NL 5.687845304 3.2 SS 17 1 NYM TBD 2016 2018 PHI
5457 5457 Ty Kelly 27 kellyty01 2016 NYM NL 0.710980663 0.445 3B, LF, 2B, 1B, CF, RF 2 1 NYM   2016 2017 PHI
5566 5566 Patrick Schuster 25 schuspa01 2016 OAK AL 0.138676411 -0.12 P 0 1 OAK   2016 2016 PHI
5641 5641 Juan Nicasio 29 nicasju01 2016 PIT NL 3.588447834 0.875 P 8 1 PIT LAD 2016 2017 PHI
5669 5669 Drew Hutchison 25 hutchdr01 2016 PIT NL 0.222411659 0.03 P 0 2 PIT TOR 2016 2016 PHI
5671 5671 Pedro Florimon 29 floripe01 2016 PIT NL 0.244107744 -0.08 2B, SS 0 1 PIT MIN 2015 2016 PHI
5736 5736 Jose Pirela 26 pireljo01 2016 SDP NL 0.41785275 -0.53 2B, RF 0 1 SDP NYY 2016 2019 PHI
5858 5858 Kevin Siegrist 26 siegrke01 2016 STL NL 2.471771589 0.88 P 6 1 STL   2013 2017 PHI
5967 5967 Phil Klein 27 kleinph01 2016 TEX AL 0.219272245 -0.01 P 0 1 TEX   2014 2016 PHI
5992 5992 Michael Saunders 29 saundmi01 2016 TOR AL 5.22 1.485 LF, RF, CF 12 1 TOR SEA 2015 2016 PHI
5999 5999 Joaquin Benoit 38 benoijo01 2016 TOR AL 0.855256802 1.015 P 4 2 TOR SEA 2016 2016 PHI
6010 6010 Jimmy Paredes 27 paredji01 2016 TOR AL 0.159032258 0.01 LF, RF, 3B, 2B 0 1 TOR BAL 2016 2016 PHI
6012 6012 Aaron Loup 28 loupaa01 2016 TOR AL 0.354402189 0.0 P 0 1 TOR   2012 2018 PHI
6037 6037 Bryce Harper 23 harpebr03 2016 WSN NL 6.236666095 2.205 RF 16 1 WSN   2012 2018 PHI
6084 6084 Jeremy Hellickson 28 hellije01 2015 ARI NL 3.985039027 0.8 P 8 1 ARI TBD 2015 2015 PHI
6109 6109 David Hernandez 30 hernada01 2015 ARI NL 0.904260835 -0.12 P 1 1 ARI BAL 2011 2015 PHI
6210 6210 David Lough 29 loughda01 2015 BAL AL 1.395488722 -0.13 LF, CF, RF 2 1 BAL KCR 2014 2015 PHI
6236 6236 Clay Buchholz 30 buchhcl01 2015 BOS AL 3.148935666 2.92 P 13 1 BOS   2007 2016 PHI
6267 6267 Dalier Hinojosa 29 hinojda01 2015 BOS AL 0.039087832 -0.005 P 0 1 BOS   2015 2015 PHI
6283 6283 Jake Arrieta 29 arrieja01 2015 CHC NL 6.170990376 7.89 P 33 1 CHC BAL 2013 2017 PHI
6332 6332 James Russell 29 russeja02 2015 CHC NL 1.043605359 -0.405 P 0 1 CHC ATL 2015 2015 PHI
6366 6366 Rob Brantly 25 brantro01 2015 CHW AL 0.345295188 -0.405 C 0 1 CHW FLA 2015 2017 PHI
6429 6429 Carlos Santana 29 santaca01 2015 CLE AL 6.348069022 1.554596273 1B 12 1 CLE   2010 2017 PHI
6512 6512 Kenny Roberts 27 roberke02 2015 COL NL 0.202269895 0.05 P 0 1 COL   2015 2015 PHI
6594 6594 Vince Velasquez 23 velasvi01 2015 HOU AL 1.396716339 0.535 P 3 1 HOU   2015 2015 PHI
6596 6596 Pat Neshek 34 neshepa01 2015 HOU AL 1.971198504 0.19 P 3 1 HOU STL 2015 2016 PHI
6599 6599 Brett Oberholtzer 25 oberhbr01 2015 HOU AL 1.082756902 0.28 P 2 1 HOU   2013 2015 PHI
6651 6651 Michael Mariot 26 mariomi01 2015 KCR AL 0.045314542 -0.035 P 0 1 KCR   2014 2015 PHI
6656 6656 Erik Kratz 35 kratzer01 2015 KCR AL 0.047595602 -0.11 C, 1B 0 1 KCR TOR 2014 2015 PHI
6680 6680 Jose Alvarez 26 alvarjo02 2015 LAA AL 1.946201471 0.415 P 4 1 ANA DET 2014 2018 PHI
6683 6683 Taylor Featherston 25 feathta01 2015 LAA AL 1.642426273 0.14 3B, 2B, SS 3 1 ANA   2015 2015 PHI
6719 6719 Howie Kendrick 31 kendrho01 2015 LAD NL 4.999129375 1.79 2B 12 1 LAD ANA 2015 2016 PHI
6727 6727 A.J. Ellis 34 ellisaj01 2015 LAD NL 2.191537524 1.045 C 6 1 LAD   2008 2016 PHI
6772 6772 J.T. Realmuto 24 realmjt01 2015 MIA NL 4.77707231 1.29 C 10 1 FLA   2014 2018 PHI
6779 6779 Justin Bour 27 bourju01 2015 MIA NL 4.562257496 0.46 1B 7 1 FLA   2014 2018 PHI

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