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,982 rows where prev_franch = "SFG"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, 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
67 67 Mark Melancon 34 melanma01 2019 ATL NL 0.662735345 0.458490566 P 3 2 ATL SFG 2019 2019  
145 145 Ty Blach 28 blachty01 2019 BAL AL 0.60240791 -0.468679245 P 0 2 BAL SFG 2019 2019  
176 176 Heath Hembree 30 hembrhe01 2019 BOS AL 1.078635403 0.198679245 P 2 1 BOS SFG 2014 2019  
196 196 Gorkys Hernandez 31 hernago01 2019 BOS AL 0.42983286 -0.560377358 LF, RF, CF 0 1 BOS SFG 2019 2019  
199 199 Eduardo Nunez 32 nunezed02 2019 BOS AL 1.591296121 -1.334716981 2B, 3B, SS, P 0 1 BOS SFG 2017 2019  
227 227 Derek Holland 32 hollade01 2019 CHC NL 0.43249152 0.188490566 P 1 2 CHC SFG 2019 2019  
269 269 Josh Osich 30 osichjo01 2019 CHW AL 1.860860849 0.256329114 P 3 1 CHW SFG 2019 2019  
643 643 Jarrett Parker 30 parkeja03 2019 LAA AL 0.141948116 -0.152830189 LF 0 1 ANA SFG 2019 2019  
647 647 Chris Stratton 28 stratch01 2019 LAA AL 0.773937979 -0.40245283 P 0 1 ANA SFG 2019 2019 PIT
771 771 Drew Pomeranz 30 pomerdr01 2019 MIL NL 0.884571644 0.860943396 P 4 2 MIL SFG 2019 2019  
781 781 Tyler Austin 27 austity01 2019 MIL NL 0.216933016 0.219056604 LF, 1B, RF 1 3 MIL SFG 2019 2019  
784 784 Ray Black 29 blackra01 2019 MIL NL 0.347368715 -0.00509434 P 1 2 MIL SFG 2019 2019  
822 822 Ehire Adrianza 29 adriaeh01 2019 MIN AL 2.183094099 0.81 3B, SS, 1B, 2B, RF, LF, P 6 1 MIN SFG 2017 2019  
849 849 Sam Dyson 31 dysonsa01 2019 MIN AL 0.36293081 -0.254716981 P 0 2 MIN SFG 2019 2019  
872 872 Joe Panik 28 panikjo01 2019 NYM NL 0.963356164 0.183396226 2B 2 2 NYM SFG 2019 2019  
901 901 Aaron Altherr 28 altheaa01 2019 NYM NL 0.34760274 -0.397358491 LF, CF, RF, P 0 3 NYM SFG 2019 2019  
1002 1002 Nick Hundley 35 hundlni01 2019 OAK AL 0.689801238 -0.382075472 C 0 1 OAK SFG 2019 2019  
1031 1031 Nick Vincent 32 vinceni01 2019 PHI NL 0.416925838 0.382075472 P 2 2 PHI SFG 2019 2019  
1093 1093 Kyle Crick 26 crickky01 2019 PIT NL 1.775594767 -0.448301887 P 1 1 PIT SFG 2018 2019  
1095 1095 Corban Joseph 30 josepco01 2019 PIT NL 0.069903581 0.00509434 2B, 3B 0 3 PIT SFG 2019 2019  
1098 1098 Williams Jerez 27 jerezwi01 2019 PIT NL 0.059599717 -0.076415094 P 0 2 PIT SFG 2019 2019  
1210 1210 Mac Williamson 28 willima11 2019 SEA AL 0.831849654 -0.056037736 LF, RF 1 2 SEA SFG 2019 2019  
1223 1223 Hunter Strickland 30 strichu01 2019 SEA AL 0.147498076 -0.13245283 P 0 1 SEA SFG 2019 2019 WSN
1381 1381 Matt Duffy 28 duffyma01 2019 TBR AL 1.528053342 -0.178301887 3B, SS 2 1 TBD SFG 2016 2019  
1385 1385 Christian Arroyo 24 arroych01 2019 TBR AL 0.537648398 0.086603774 3B, 2B 1 1 TBD SFG 2018 2019  
1401 1401 Erik Kratz 39 kratzer01 2019 TBR AL 0.160351277 -0.315849057 C 0 2 TBD SFG 2019 2019  
1408 1408 Hunter Pence 36 pencehu01 2019 TEX AL 3.024422442 1.737169811 LF, RF 10 1 TEX SFG 2019 2019  
1479 1479 Derek Law 28 lawde01 2019 TOR AL 1.945983885 0.127358491 P 3 1 TOR SFG 2019 2019  
1510 1510 Alen Hanson 26 hansoal01 2019 TOR AL 0.466644318 -0.555283019 2B, RF, 1B, LF 0 1 TOR SFG 2019 2019  
1540 1540 Gerardo Parra 32 parrage01 2019 WSN NL 1.937661443 -0.27 RF, LF, 1B, CF, 2B, 3B, P 2 2 WSN SFG 2019 2019  
1749 1749 Eduardo Nunez 31 nunezed02 2018 BOS AL 4.634829672 -0.71 2B, 3B 5 1 BOS SFG 2017 2019  
1750 1750 Heath Hembree 29 hembrhe01 2018 BOS AL 1.990700701 0.285 P 4 1 BOS SFG 2014 2019  
1882 1882 Adam Duvall 29 duvalad01 2018 CIN NL 3.641608688 1.025 LF, 1B, RF, 3B 8 1 CIN SFG 2015 2018 ATL
2103 2103 Tim Federowicz 30 federti01 2018 HOU AL 0.331645156 -0.25 C 0 1 HOU SFG 2018 2018 CIN
2385 2385 Ehire Adrianza 28 adriaeh01 2018 MIN AL 3.46183953 0.475 SS, 3B, 1B, 2B, LF 6 1 MIN SFG 2017 2019  
2448 2448 Austin Jackson 31 jacksau01 2018 NYM NL 2.084188912 -0.245 CF, LF 2 2 NYM SFG 2018 2018  
2503 2503 Andrew McCutchen 31 mccutan01 2018 NYY AL 1.058089294 0.78 RF, LF 4 2 NYY SFG 2018 2018 PHI
2557 2557 Santiago Casilla 37 garcija01 2018 OAK AL 0.739323263 0.3 P 2 1 OAK SFG 2017 2018  
2647 2647 Kyle Crick 25 crickky01 2018 PIT NL 1.941630826 1.22757764 P 7 1 PIT SFG 2018 2019  
2674 2674 George Kontos 33 kontoge01 2018 PIT NL 0.689898937 -0.387391304 P 0 1 PIT SFG 2017 2018 CLE
2764 2764 Gordon Beckham 31 beckhgo01 2018 SEA AL 0.478153339 0.005 2B, 3B, SS 1 1 SEA SFG 2017 2018 DET
2881 2881 Matt Duffy 27 duffyma01 2018 TBR AL 5.261623198 2.46 3B, SS 14 1 TBD SFG 2016 2019  
2900 2900 Denard Span 34 spande01 2018 TBR AL 1.625465738 0.76 LF, CF 4 1 TBD SFG 2018 2018 SEA
2917 2917 Christian Arroyo 23 arroych01 2018 TBR AL 0.554349587 0.215 2B, 3B 1 1 TBD SFG 2018 2019  
2954 2954 Cory Gearrin 32 gearrco01 2018 TEX AL 0.680619821 0.59 P 3 2 TEX SFG 2018 2018 OAK
2958 2958 Matt Moore 29 moorema02 2018 TEX AL 2.722274771 -0.47 P 2 1 TEX SFG 2018 2018 DET
3118 3118 Gregor Blanco 33 blancgr01 2017 ARI NL 2.527749404 0.28 LF, CF, RF 4 1 ARI SFG 2017 2017 SFG
3224 3224 Ruben Tejada 27 tejadru01 2017 BAL AL 1.174779484 -0.18 SS, 3B, 2B 1 1 BAL SFG 2017 2017 NYM
3261 3261 Eduardo Nunez 30 nunezed02 2017 BOS AL 1.588915281 1.02 3B, 2B, LF, SS, RF 5 2 BOS SFG 2017 2019  
3262 3262 Heath Hembree 28 hembrhe01 2017 BOS AL 2.064749001 0.435 P 4 1 BOS SFG 2014 2019  
3290 3290 Pablo Sandoval 30 sandopa01 2017 BOS AL 0.99192399 -0.685 3B, 1B, 2B 0 1 BOS SFG 2015 2017 SFG
3393 3393 Adam Duvall 28 duvalad01 2017 CIN NL 6.376550552 1.66 LF, 1B 13 1 CIN SFG 2015 2018 ATL
3768 3768 Sergio Romo 34 romose01 2017 LAD NL 0.729669899 -0.44 P 0 1 LAD SFG 2017 2017 TBD
3855 3855 Andrew Susac 27 susacan01 2017 MIL NL 0.11960818 -0.22 C 0 1 MIL SFG 2016 2017 BAL
3877 3877 Ehire Adrianza 27 adriaeh01 2017 MIN AL 1.72967773 0.925 SS, LF, 2B, 3B, 1B 5 1 MIN SFG 2017 2019  
3955 3955 Neil Ramirez 28 ramirne01 2017 NYM NL 0.486290724 -0.21 P 0 2 NYM SFG 2017 2017 CLE
4038 4038 Santiago Casilla 36 garcija01 2017 OAK AL 2.069656979 0.27 P 4 1 OAK SFG 2017 2018  
4144 4144 George Kontos 32 kontoge01 2017 PIT NL 0.49972717 0.47 P 2 2 PIT SFG 2017 2018 CLE
4159 4159 Dan Runzler 32 runzlda01 2017 PIT NL 0.098566317 -0.16 P 0 1 PIT SFG 2017 2017  
4271 4271 Gordon Beckham 30 beckhgo01 2017 SEA AL 0.17006027 -0.155 2B, SS, 3B 0 1 SEA SFG 2017 2018 DET
4279 4279 Chris Heston 29 hestoch01 2017 SEA AL 0.129472375 -0.425 P 0 1 SEA SFG 2017 2017 MIN
4341 4341 Mike Leake 29 leakemi01 2017 STL NL 4.30695994 1.41 P 10 1 STL SFG 2016 2017 SEA
4581 4581 Grant Green 29 greengr01 2017 WSN NL 0.02974359 -0.135 2B 0 1 WSN SFG 2017 2017  
4771 4771 Heath Hembree 27 hembrhe01 2016 BOS AL 1.495972794 0.39 P 3 1 BOS SFG 2014 2019  
4793 4793 Pablo Sandoval 29 sandopa01 2016 BOS AL 0.064516129 -0.21 3B 0 1 BOS SFG 2015 2017 SFG
4880 4880 Hector Sanchez 26 sanchhe01 2016 CHW AL 0.075953511 -0.075 C 0 1 CHW SFG 2016 2016 SDP
4895 4895 Adam Duvall 27 duvalad01 2016 CIN NL 6.114791053 2.79 LF, RF, 1B, 3B 18 1 CIN SFG 2015 2018 ATL
4967 4967 Marlon Byrd 38 byrdma01 2016 CLE AL 1.220554649 0.462857143 RF, LF 3 1 CLE SFG 2016 2016  
5222 5222 Tim Lincecum 32 linceti01 2016 LAA AL 1.115164939 -1.135 P 0 1 ANA SFG 2016 2016  
5319 5319 Cody Hall 28 hallco01 2016 MIA NL 0.06748302 -0.140869565 P 0 1 FLA SFG 2016 2016  
5361 5361 Andrew Susac 26 susacan01 2016 MIL NL 0.191585535 0.045 C 0 1 MIL SFG 2016 2017 BAL
5456 5456 Alejandro De Aza 32 deazaal01 2016 NYM NL 2.673687845 -0.34 CF, LF, RF 3 1 NYM SFG 2016 2016 WSN
5654 5654 Ryan Vogelsong 38 vogelry01 2016 PIT NL 2.318793849 -0.105 P 3 1 PIT SFG 2016 2016  
5737 5737 Nick Noonan 27 noonani01 2016 SDP NL 0.20383061 -0.535 SS, 2B 0 1 SDP SFG 2016 2016  
5748 5748 Nori Aoki 34 aokino01 2016 SEA AL 4.367300871 1.54 LF, CF 11 1 SEA SFG 2016 2016 HOU
5850 5850 Mike Leake 28 leakemi01 2016 STL NL 5.023708744 1.465 P 11 1 STL SFG 2016 2017 SEA
5912 5912 Matt Duffy 25 duffyma01 2016 TBR AL 0.770636107 0.085 3B, SS 1 2 TBD SFG 2016 2019  
6052 6052 Yusmeiro Petit 31 petityu01 2016 WSN NL 1.711329093 0.04 P 3 1 WSN SFG 2016 2016 ANA
6258 6258 Pablo Sandoval 28 sandopa01 2015 BOS AL 4.715067611 -1.05 3B 3 1 BOS SFG 2015 2017 SFG
6262 6262 Heath Hembree 26 hembrhe01 2015 BOS AL 0.567644949 0.115 P 1 1 BOS SFG 2014 2019  
6276 6276 Jean Machi 33 machije01 2015 BOS AL 0.752428318 -0.23 P 0 2 BOS SFG 2015 2015 SEA
6372 6372 Conor Gillaspie 27 gillaco01 2015 CHW AL 1.774433603 -0.845 3B, 1B, 2B 0 1 CHW SFG 2013 2015 ANA
6393 6393 Adam Duvall 26 duvalad01 2015 CIN NL 0.712749616 0.245 LF, 1B 2 1 CIN SFG 2015 2018 ATL
6400 6400 Chris Dominguez 28 dominch01 2015 CIN NL 0.227683905 0.085 1B, LF, RF 1 1 CIN SFG 2015 2015  
6741 6741 Juan Uribe 36 uribeju01 2015 LAD NL 0.87863486 0.2 3B, 2B 2 1 LAD SFG 2011 2015 ATL
6807 6807 Erik Cordier 29 cordier01 2015 MIA NL 0.262879522 -0.11 P 0 1 FLA SFG 2015 2015  
6816 6816 Mike Morse 33 morsemi01 2015 MIA NL 1.77989418 -0.64 1B, LF 0 1 FLA SFG 2015 2015 PIT
6817 6817 Casey McGehee 32 mcgehca01 2015 MIA NL 1.227513228 -0.65 3B, 1B 0 2 FLA SFG 2015 2015 DET
6956 6956 Johnny Monell 29 moneljo01 2015 NYM NL 0.520628345 -0.38 C 0 1 NYM SFG 2015 2015  
7060 7060 Barry Zito 37 zitoba01 2015 OAK AL 0.174788975 -0.43 P 0 1 OAK SFG 2015 2015  
7064 7064 Dan Otero 30 oteroda01 2015 OAK AL 1.271192548 -0.58 P 0 1 OAK SFG 2013 2015 CLE
7158 7158 Travis Ishikawa 31 ishiktr01 2015 PIT NL 0.643902439 -0.24 1B, LF 0 2 PIT SFG 2015 2015  
7546 7546 Dan Uggla 35 ugglada01 2015 WSN NL 1.420531527 -0.18 2B, 1B 1 1 WSN SFG 2015 2015  
7548 7548 Emmanuel Burriss 30 burriem01 2015 WSN NL 0.050373458 0.125 2B 0 1 WSN SFG 2015 2015 PHI
7608 7608 Roger Kieschnick 27 kiescro01 2014 ARI NL 0.412847222 -0.48 LF, RF 0 1 ARI SFG 2014 2014  
7683 7683 Ramon Ramirez 32 ramirra02 2014 BAL AL 0.015322178 0.015 P 0 1 BAL SFG 2014 2014  
7739 7739 Heath Hembree 25 hembrhe01 2014 BOS AL 0.257743456 -0.06 P 0 1 BOS SFG 2014 2019  
7792 7792 Eli Whiteside 34 whiteel03 2014 CHC NL 0.261533125 -0.47 C 0 1 CHC SFG 2014 2014  
7803 7803 Conor Gillaspie 26 gillaco01 2014 CHW AL 4.848504874 1.715 3B 12 1 CHW SFG 2013 2015 ANA
7825 7825 Eric Surkamp 26 surkaer01 2014 CHW AL 0.860021044 -0.2 P 1 1 CHW SFG 2014 2014 LAD

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