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,923 rows where prev_franch = "PHI"

✎ 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
347 347 Carlos Santana 33 santaca01 2019 CLE AL 6.561479507 4.686792453 1B 24 1 CLE PHI 2019 2019  
479 479 Daniel Stumpf 28 stumpda01 2019 DET AL 0.989729409 0.11278481 P 1 1 DET PHI 2017 2019  
584 584 Ben Lively 27 livelbe01 2019 KCR AL 0.020290853 -0.112075472 P 0 1 KCR PHI 2018 2019  
624 624 Luis Garcia 32 garcilu03 2019 LAA AL 1.629615396 -0.101886792 P 2 1 ANA PHI 2019 2019  
635 635 Justin Bour 31 bourju01 2019 LAA AL 1.599282101 -0.468679245 1B 1 1 ANA PHI 2019 2019  
708 708 Jorge Alfaro 26 alfarjo01 2019 MIA NL 4.738898757 1.161509434 C 10 1 FLA PHI 2019 2019  
861 861 Wilson Ramos 31 ramoswi01 2019 NYM NL 5.194178082 1.747358491 C 12 1 NYM PHI 2019 2019  
877 877 Luis Avilan 29 avilalu01 2019 NYM NL 0.898967715 0.010188679 P 1 1 NYM PHI 2019 2019  
1103 1103 Yacksel Rios 26 riosya01 2019 PIT NL 0.214558981 -0.142641509 P 0 2 PIT PHI 2019 2019  
1148 1148 Aaron Loup 31 loupaa01 2019 SDP NL 0.095716273 0.13754717 P 1 1 SDP PHI 2019 2019  
1178 1178 J.P. Crawford 24 crawfjp01 2019 SEA AL 3.662050775 1.130943396 SS 8 1 SEA PHI 2019 2019  
1279 1279 Aaron Altherr 28 altheaa01 2019 SFG NL 0.010053735 -0.015283019 LF, CF, RF, P 0 2 SFG PHI 2019 2019 NYM
1393 1393 Hoby Milner 28 milneho01 2019 TBR AL 0.101046415 0.00509434 P 0 1 TBD PHI 2018 2019  
1397 1397 Ricardo Pinto 25 pintori01 2019 TBR AL 0.035500208 -0.117169811 P 0 1 TBD PHI 2019 2019  
1415 1415 Asdrubal Cabrera 33 cabreas01 2019 TEX AL 3.522112211 0.468679245 3B, 2B, 1B 7 1 TEX PHI 2019 2019 WSN
1524 1524 Howie Kendrick 35 kendrho01 2019 WSN NL 3.655588083 2.842641509 1B, 2B, 3B 13 1 WSN PHI 2017 2019  
1572 1572 Clay Buchholz 33 buchhcl01 2018 ARI NL 2.635512471 2.29 P 11 1 ARI PHI 2018 2018 TOR
1851 1851 Jeanmar Gomez 30 gomezje01 2018 CHW AL 0.905833417 0.065 P 1 1 CHW PHI 2018 2018 TEX
2043 2043 Daniel Stumpf 27 stumpda01 2018 DET AL 1.306945918 0.05 P 2 1 DET PHI 2017 2019  
2071 2071 Charlie Morton 34 mortoch02 2018 HOU AL 4.567731465 3.175 P 16 1 HOU PHI 2017 2018 TBD
2094 2094 Ken Giles 27 gileske01 2018 HOU AL 0.919523685 0.295 P 2 1 HOU PHI 2016 2018 TOR
2134 2134 Ben Lively 26 livelbe01 2018 KCR AL 0.219355773 0.14 P 1 2 KCR PHI 2018 2019  
2243 2243 Chase Utley 39 utleych01 2018 LAD NL 1.800165975 -0.054662577 2B, 1B 2 1 LAD PHI 2015 2018  
2462 2462 Ty Kelly 29 kellyty01 2018 NYM NL 0.119096509 -0.19 2B, 3B, LF 0 1 NYM PHI 2018 2018  
2679 2679 Freddy Galvis 28 galvifr01 2018 SDP NL 6.598681929 1.77 SS, 2B 15 1 SDP PHI 2018 2018 TOR
2817 2817 Hunter Pence 35 pencehu01 2018 SFG NL 2.48042766 -0.83 LF, RF 1 1 SFG PHI 2012 2018 TEX
2929 2929 Hoby Milner 27 milneho01 2018 TBR AL 0.094138298 -0.31 P 0 2 TBD PHI 2018 2019  
2942 2942 Cole Hamels 34 hamelco01 2018 TEX AL 3.279419767 0.905 P 7 1 TEX PHI 2015 2018 CHC
2949 2949 Jake Diekman 31 diekmja01 2018 TEX AL 1.405772384 0.73 P 4 1 TEX PHI 2015 2018 ARI
2972 2972 Zac Curtis 25 curtiza01 2018 TEX AL 0.157475139 -0.185 P 0 2 TEX PHI 2018 2018  
2974 2974 Drew Hutchison 27 hutchdr01 2018 TEX AL 0.611903397 -0.375 P 0 2 TEX PHI 2018 2018  
3032 3032 Darnell Sweeney 27 sweenda02 2018 TOR AL 0.038334435 -0.045 3B, LF 0 1 TOR PHI 2018 2018  
3044 3044 Mark Leiter Jr. 27 leitema02 2018 TOR AL 0.192492875 -0.345 P 0 2 TOR PHI 2018 2018  
3071 3071 Howie Kendrick 34 kendrho01 2018 WSN NL 1.560450647 0.09 2B, LF, 1B 2 1 WSN PHI 2017 2019  
3178 3178 Chase d'Arnaud 30 darnach01 2017 ATL NL 0.098405158 0.05 SS, LF, 2B, 3B, 1B, RF 0 1 ATL PHI 2016 2017 BOS
3215 3215 Alec Asher 25 asheral01 2017 BAL AL 1.668495676 0.1 P 3 1 BAL PHI 2017 2017 MIL
3226 3226 Jeremy Hellickson 30 hellije01 2017 BAL AL 1.492325476 -0.47 P 1 2 BAL PHI 2017 2017 WSN
3386 3386 Cody Asche 27 ascheco01 2017 CHW AL 0.595462825 -0.905 1B, 3B, LF 0 1 CHW PHI 2017 2017  
3495 3495 Pat Neshek 36 neshepa01 2017 COL NL 0.842045389 0.835 P 4 2 COL PHI 2017 2017 PHI
3536 3536 Daniel Stumpf 26 stumpda01 2017 DET AL 1.17477891 0.435 P 3 1 DET PHI 2017 2019  
3575 3575 Charlie Morton 33 mortoch02 2017 HOU AL 4.109317839 2.615 P 14 1 HOU PHI 2017 2018 TBD
3580 3580 Ken Giles 26 gileske01 2017 HOU AL 2.350505703 1.92 P 9 1 HOU PHI 2016 2018 TOR
3680 3680 David Hernandez 32 hernada01 2017 LAA AL 1.022298785 0.975 P 4 1 ANA PHI 2017 2017 ARI
3700 3700 Andrew Bailey 33 bailean01 2017 LAA AL 0.073840134 0.125 P 0 1 ANA PHI 2016 2017  
3731 3731 Chase Utley 38 utleych01 2017 LAD NL 3.491473397 1.07 2B, 1B 9 1 LAD PHI 2015 2018  
3786 3786 A.J. Ellis 36 ellisaj01 2017 MIA NL 1.594266442 0.2 C 3 1 FLA PHI 2017 2017 SDP
3795 3795 Dustin McGowan 35 mcgowdu01 2017 MIA NL 2.167334313 -0.385 P 2 1 FLA PHI 2016 2017  
4164 4164 Joaquin Benoit 39 benoijo01 2017 PIT NL 0.318160308 -0.485 P 0 2 PIT PHI 2017 2017  
4262 4262 Tyler Cloyd 30 cloydty01 2017 SEA AL 0.029001812 0.025 P 0 1 SEA PHI 2017 2017 FLA
4290 4290 Hunter Pence 34 pencehu01 2017 SFG NL 5.372400756 0.435 RF 8 1 SFG PHI 2012 2018 TEX
4358 4358 Juan Nicasio 30 nicasju01 2017 STL NL 0.397641058 0.315 P 1 3 STL PHI 2017 2017 SEA
4399 4399 Peter Bourjos 30 bourjpe01 2017 TBR AL 1.923227703 0.43 LF, CF, RF 4 1 TBD PHI 2017 2017 ATL
4417 4417 Taylor Featherston 27 feathta01 2017 TBR AL 0.44527932 -0.01 2B, SS, 1B, 3B 1 1 TBD PHI 2017 2017  
4438 4438 Cole Hamels 33 hamelco01 2017 TEX AL 4.266004709 2.305 P 13 1 TEX PHI 2015 2018 CHC
4456 4456 Jake Diekman 30 diekmja01 2017 TEX AL 0.377783051 0.21 P 1 1 TEX PHI 2015 2018 ARI
4525 4525 Michael Saunders 30 saundmi01 2017 TOR AL 0.189233279 -0.115 RF, LF 0 2 TOR PHI 2017 2017  
4562 4562 Howie Kendrick 33 kendrho01 2017 WSN NL 1.764786325 0.3 LF, 2B, 1B, RF 4 2 WSN PHI 2017 2019  
4568 4568 Jayson Werth 38 werthja01 2017 WSN NL 2.865299145 -0.495 LF, RF 3 1 WSN PHI 2011 2017  
4634 4634 Adam Loewen 32 loewead01 2016 ARI NL 0.143199622 -0.35 P 0 1 ARI PHI 2016 2016  
4656 4656 Jeff Francoeur 32 francje02 2016 ATL NL 2.723375298 0.437701863 LF, RF, 3B 5 1 ATL PHI 2016 2016 FLA
4659 4659 Chase d'Arnaud 29 darnach01 2016 ATL NL 2.585233072 0.125776398 SS, 3B, 2B, LF, CF, RF 4 1 ATL PHI 2016 2017 BOS
4788 4788 Sean O'Sullivan 28 osullse01 2016 BOS AL 0.534574309 -0.125 P 0 1 BOS PHI 2016 2016  
4972 4972 Jeff Manship 31 manshje01 2016 CLE AL 1.334741994 0.08552795 P 2 1 CLE PHI 2015 2016  
5103 5103 Ken Giles 25 gileske01 2016 HOU AL 2.47450487 0.585 P 5 1 HOU PHI 2016 2018 TOR
5123 5123 Erik Kratz 36 kratzer01 2016 HOU AL 0.281507847 -0.365 C, 1B, P 0 1 HOU PHI 2016 2016 PIT
5202 5202 Andrew Bailey 32 bailean01 2016 LAA AL 0.393172777 0.195 P 1 2 ANA PHI 2016 2017  
5220 5220 Brett Oberholtzer 26 oberhbr01 2016 LAA AL 0.441813777 -0.53 P 0 2 ANA PHI 2016 2016  
5229 5229 Chase Utley 37 utleych01 2016 LAD NL 5.605542251 2.025 2B, 3B 14 1 LAD PHI 2015 2018  
5253 5253 Carlos Ruiz 37 ruizca01 2016 LAD NL 0.396852549 0.165 C 1 2 LAD PHI 2016 2016 SEA
5298 5298 Dustin McGowan 34 mcgowdu01 2016 MIA NL 1.702850744 0.266645963 P 3 1 FLA PHI 2016 2017  
5305 5305 Nefi Ogando 27 ogandne01 2016 MIA NL 0.338681014 0.186149068 P 1 1 FLA PHI 2016 2016  
5804 5804 Hunter Pence 33 pencehu01 2016 SFG NL 4.345821326 1.865 RF 11 1 SFG PHI 2012 2018 TEX
5879 5879 Jerome Williams 34 willije01 2016 STL NL 0.272663758 -0.24 P 0 1 STL PHI 2016 2016  
5931 5931 Cole Hamels 32 hamelco01 2016 TEX AL 5.549274498 4.13 P 23 1 TEX PHI 2015 2018 CHC
5948 5948 Jake Diekman 29 diekmja01 2016 TEX AL 1.824294081 0.91 P 6 1 TEX PHI 2015 2018 ARI
6042 6042 Jayson Werth 37 werthja01 2016 WSN NL 6.027782542 0.75 LF, RF 11 1 WSN PHI 2011 2017  
6057 6057 Jonathan Papelbon 35 papeljo01 2016 WSN NL 1.328989141 0.16 P 2 1 WSN PHI 2015 2016  
6108 6108 JC Ramirez 26 ramirjc01 2015 ARI NL 0.540959466 0.12 P 1 1 ARI PHI 2015 2015 SEA
6383 6383 Marlon Byrd 37 byrdma01 2015 CIN NL 3.840928486 0.89 LF, RF, CF 7 1 CIN PHI 2015 2015 SFG
6440 6440 Jeff Manship 30 manshje01 2015 CLE AL 1.103154806 1.172236025 P 5 1 CLE PHI 2015 2016  
6486 6486 Kyle Kendrick 30 kendrky01 2015 COL NL 4.033728488 -0.505 P 4 1 COL PHI 2015 2015 BOS
6630 6630 Ryan Madson 34 madsory01 2015 KCR AL 2.178487877 1.315 P 8 1 KCR PHI 2015 2015 OAK
6722 6722 Jimmy Rollins 36 rolliji01 2015 LAD NL 5.685878461 0.18 SS 8 1 LAD PHI 2015 2015 CHW
6731 6731 Chase Utley 36 utleych01 2015 LAD NL 1.423994428 0.595 2B, 1B, 3B 4 2 LAD PHI 2015 2018  
6808 6808 Reid Brignac 29 brignre01 2015 MIA NL 0.173897707 -0.125 3B 0 1 FLA PHI 2015 2015 ATL
6848 6848 Cesar Jimenez 30 jimence01 2015 MIL NL 0.526704341 0.135 P 1 2 MIL PHI 2015 2015  
7126 7126 A.J. Burnett 38 burnea.01 2015 PIT NL 4.36962429 2.605 P 15 1 PIT PHI 2015 2015  
7135 7135 Antonio Bastardo 29 bastaan01 2015 PIT NL 1.609281655 0.735 P 5 1 PIT PHI 2015 2015 NYM
7203 7203 Wil Nieves 37 nievewi01 2015 SDP NL 0.142406173 -0.225 C, 1B 0 1 SDP PHI 2015 2015  
7272 7272 Hunter Pence 32 pencehu01 2015 SFG NL 2.230384549 1.125 RF 6 1 SFG PHI 2012 2018 TEX
7379 7379 Grady Sizemore 32 sizemgr01 2015 TBR AL 1.840356966 0.195 LF, RF 3 2 TBD PHI 2015 2015  
7417 7417 Cole Hamels 31 hamelco01 2015 TEX AL 2.344523441 1.49 P 8 2 TEX PHI 2015 2018 CHC
7428 7428 Jake Diekman 28 diekmja01 2015 TEX AL 0.765393397 0.52 P 3 2 TEX PHI 2015 2018 ARI
7482 7482 Ben Revere 27 reverbe01 2015 TOR AL 2.298695022 0.6 LF, CF, RF 5 2 TOR PHI 2015 2015 WSN
7538 7538 Jayson Werth 36 werthja01 2015 WSN NL 3.808233455 -0.78 LF, RF 3 1 WSN PHI 2011 2017  
7545 7545 Jonathan Papelbon 34 papeljo01 2015 WSN NL 0.794478731 -0.16 P 1 2 WSN PHI 2015 2016  
7777 7777 Nate Schierholtz 30 schiena01 2014 CHC NL 3.430107527 -0.86 RF, LF, CF 2 1 CHC PHI 2013 2014 WSN
7880 7880 Roger Bernadina 30 bernaro01 2014 CIN NL 0.732088889 -0.325 LF, RF, CF, 1B 0 1 CIN PHI 2014 2014 LAD
8068 8068 Raul Valdes 36 valdera02 2014 HOU AL 0.137879456 -0.345 P 0 1 HOU PHI 2014 2014  
8224 8224 Roberto Hernandez 33 carmofa01 2014 LAD NL 1.246685705 -0.43 P 0 2 LAD PHI 2014 2014 HOU

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