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,036 rows where next_franch = "TEX"

✎ 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
1234 1234 Jesse Biddle 27 biddlje01 2019 SEA AL 0.284923112 -0.376981132 P 0 2 SEA ATL 2019 2019 TEX
1395 1395 Ian Gibaut 25 gibauia01 2019 TBR AL 0.028993432 -0.015283019 P 0 1 TBD   2019 2019 TEX
1582 1582 Jeff Mathis 35 mathije01 2018 ARI NL 2.170643777 0.39 C, 2B, P 4 1 ARI FLA 2017 2018 TEX
1613 1613 Shelby Miller 27 millesh01 2018 ARI NL 0.465917074 -0.7 P 0 1 ARI ATL 2016 2018 TEX
1646 1646 Danny Santana 27 santada01 2018 ATL NL 0.313354719 0.065 LF, CF, RF 1 1 ATL MIN 2017 2018 TEX
1664 1664 Kolby Allard 20 allarko01 2018 ATL NL 0.193960101 -0.15 P 0 1 ATL   2018 2018 TEX
1669 1669 Carlos Perez 27 perezca02 2018 ATL NL 0.215431369 -0.28 C 0 1 ATL ANA 2018 2018 TEX
1789 1789 Jesse Chavez 34 chaveje01 2018 CHC NL 1.355023181 1.550429448 P 7 2 CHC TEX 2018 2018 TEX
1805 1805 Eddie Butler 27 butleed01 2018 CHC NL 0.397323533 0.019877301 P 1 1 CHC COL 2017 2018 TEX
1820 1820 Luke Farrell 27 farrelu01 2018 CHC NL 0.916996572 -0.506871166 P 0 1 CHC CIN 2018 2018 TEX
1851 1851 Jeanmar Gomez 30 gomezje01 2018 CHW AL 0.905833417 0.065 P 1 1 CHW PHI 2018 2018 TEX
1902 1902 Tim Federowicz 30 federti01 2018 CIN NL 0.0688953 0.13 C 0 2 CIN HOU 2018 2018 TEX
1915 1915 Yovani Gallardo 32 gallayo01 2018 CIN NL 0.047828037 -0.245 P 0 1 CIN SEA 2018 2018 TEX
2390 2390 Logan Forsythe 31 forsylo01 2018 MIN AL 1.93900848 0.5 2B, 3B, 1B, LF 4 2 MIN LAD 2018 2018 TEX
2500 2500 Lance Lynn 31 lynnla01 2018 NYY AL 1.519409112 1.26 P 6 2 NYY MIN 2018 2018 TEX
2555 2555 Shawn Kelley 34 kellesh01 2018 OAK AL 0.510501394 0.485 P 2 2 OAK WSN 2018 2018 TEX
2609 2609 Asdrubal Cabrera 32 cabreas01 2018 PHI NL 1.838588074 -0.17 2B, SS, 3B 2 2 PHI NYM 2018 2018 TEX
2613 2613 Zac Curtis 25 curtiza01 2018 PHI NL 0.148738729 0.125 P 1 1 PHI SEA 2017 2018 TEX
2615 2615 Drew Hutchison 27 hutchdr01 2018 PHI NL 0.492376483 0.055 P 1 1 PHI PIT 2018 2018 TEX
2812 2812 Cory Gearrin 32 gearrco01 2018 SFG NL 0.864776817 -0.1 P 1 1 SFG ATL 2015 2018 TEX
2817 2817 Hunter Pence 35 pencehu01 2018 SFG NL 2.48042766 -0.83 LF, RF 1 1 SFG PHI 2012 2018 TEX
2853 2853 Patrick Wisdom 26 wisdopa01 2018 STL NL 0.572790737 0.495 3B, 1B 2 1 STL   2018 2018 TEX
3029 3029 Taylor Guerrieri 25 guerrta02 2018 TOR AL 0.182612257 -0.01 P 0 1 TOR   2018 2018 TEX
3122 3122 Jeff Mathis 34 mathije01 2017 ARI NL 2.004426285 -0.06 C 3 1 ARI FLA 2017 2018 TEX
3124 3124 Shelby Miller 26 millesh01 2017 ARI NL 0.620935187 0.44 P 2 1 ARI ATL 2016 2018 TEX
3175 3175 Danny Santana 26 santada01 2017 ATL NL 1.495758398 -0.355 LF, 2B, RF, 3B, CF 1 2 ATL MIN 2017 2018 TEX
3259 3259 Doug Fister 33 fistedo01 2017 BOS AL 2.724269986 0.745 P 6 1 BOS HOU 2017 2017 TEX
3312 3312 Eddie Butler 26 butleed01 2017 CHC NL 1.433314757 0.645 P 4 1 CHC COL 2017 2018 TEX
3342 3342 Miguel Gonzalez 33 gonzami03 2017 CHW AL 3.897771573 1.55 P 10 1 CHW BAL 2016 2017 TEX
3611 3611 Juan Centeno 27 centeju01 2017 HOU AL 0.529637937 -0.26 C 0 1 HOU MIN 2017 2017 TEX
3621 3621 Mike Minor 29 minormi01 2017 KCR AL 2.876079599 2.535 P 12 1 KCR ATL 2017 2017 TEX
3677 3677 Jesse Chavez 33 chaveje01 2017 LAA AL 3.821226912 -0.05 P 6 1 ANA LAD 2017 2017 TEX
3779 3779 Edinson Volquez 33 volqued01 2017 MIA NL 2.632935812 0.865 P 6 1 FLA KCR 2017 2017 TEX
3856 3856 Paolo Espino 30 espinpa01 2017 MIL NL 0.399357866 -0.24 P 0 1 MIL   2017 2017 TEX
3884 3884 Bartolo Colon 44 colonba01 2017 MIN AL 2.270051544 0.145 P 4 2 MIN ATL 2017 2017 TEX
3932 3932 Rafael Montero 26 montera01 2017 NYM NL 3.22392739 0.385 P 5 1 NYM   2014 2017 TEX
4012 4012 Pete Kozma 29 kozmape01 2017 NYY AL 0.09164165 -0.19 3B, SS, 1B, 2B 0 1 NYY STL 2017 2017 TEX
4057 4057 Renato Nunez 23 nunezre01 2017 OAK AL 0.152056366 -0.01 LF, 3B 0 1 OAK   2016 2017 TEX
4105 4105 Zac Curtis 24 curtiza01 2017 PHI NL 0.095484482 0.1 P 0 2 PHI SEA 2017 2018 TEX
4145 4145 Jhan Marinez 28 marinjh01 2017 PIT NL 0.708521457 0.36 P 2 2 PIT MIL 2017 2017 TEX
4165 4165 Phil Gosselin 28 gosseph01 2017 PIT NL 0.419060726 -0.59 2B, SS, 3B, 1B 0 1 PIT ARI 2017 2017 TEX
4290 4290 Hunter Pence 34 pencehu01 2017 SFG NL 5.372400756 0.435 RF 8 1 SFG PHI 2012 2018 TEX
4291 4291 Cory Gearrin 31 gearrco01 2017 SFG NL 1.956196781 1.335 P 7 1 SFG ATL 2015 2018 TEX
4293 4293 Matt Moore 28 moorema02 2017 SFG NL 4.807269621 0.38 P 7 1 SFG TBD 2016 2017 TEX
4542 4542 Jason Grilli 40 grillja01 2017 TOR AL 0.647143612 -0.635 P 0 1 TOR ATL 2016 2017 TEX
4616 4616 Shelby Miller 25 millesh01 2016 ARI NL 2.780239689 -0.245 P, LF 3 1 ARI ATL 2016 2018 TEX
4660 4660 Lucas Harrell 31 harrelu01 2016 ATL NL 0.817861868 0.457826087 P 3 1 ATL HOU 2016 2016 TEX
4666 4666 Dario Alvarez 27 alvarda01 2016 ATL NL 0.539930454 0.296832298 P 2 1 ATL NYM 2016 2016 TEX
4690 4690 Drew Stubbs 31 stubbdr01 2016 ATL NL 0.414426676 -0.145900621 RF, CF, LF 0 1 ATL TEX 2016 2016 TEX
4851 4851 Miguel Gonzalez 32 gonzami03 2016 CHW AL 3.717346938 2.5 P 12 1 CHW BAL 2016 2017 TEX
4954 4954 Mike Napoli 34 napolmi01 2016 CLE AL 6.102773246 0.950869565 1B 12 1 CLE TEX 2016 2016 TEX
5078 5078 Bobby Wilson 33 wilsobo02 2016 DET AL 0.142529489 -0.11068323 C 0 1 DET TEX 2016 2016 TEX
5111 5111 Carlos Gomez 30 gomezca01 2016 HOU AL 3.030901149 -0.805 CF, LF, RF 2 1 HOU MIL 2015 2016 TEX
5144 5144 Dillon Gee 30 geedi01 2016 KCR AL 3.445959203 0.155 P 6 1 KCR NYM 2016 2016 TEX
5302 5302 Andrew Cashner 29 cashnan01 2016 MIA NL 1.669352679 -0.080496894 P 2 2 FLA SDP 2016 2016 TEX
5334 5334 Jonathan Lucroy 30 lucrojo01 2016 MIL NL 3.791376912 2.66 C, 1B 13 1 MIL   2010 2016 TEX
5348 5348 Jeremy Jeffress 28 jeffrje01 2016 MIL NL 1.742794014 1.045 P 6 1 MIL TOR 2014 2016 TEX
5365 5365 Will Middlebrooks 27 middlwi01 2016 MIL NL 0.312586926 -0.07 3B 0 1 MIL SDP 2016 2016 TEX
5475 5475 Rafael Montero 25 montera01 2016 NYM NL 0.415310594 -0.485 P 0 1 NYM   2014 2017 TEX
5485 5485 Carlos Beltran 39 beltrca01 2016 NYY AL 3.716840537 2.11 RF 12 1 NYY STL 2014 2016 TEX
5572 5572 Renato Nunez 22 nunezre01 2016 OAK AL 0.145048349 -0.285   0 1 OAK   2016 2017 TEX
5729 5729 Tyson Ross 29 rossty01 2016 SDP NL 0.151425032 -0.105 P 0 1 SDP OAK 2013 2016 TEX
5783 5783 Adrian Sampson 24 sampsad01 2016 SEA AL 0.131624141 -0.06 P 0 1 SEA   2016 2016 TEX
5804 5804 Hunter Pence 33 pencehu01 2016 SFG NL 4.345821326 1.865 RF 11 1 SFG PHI 2012 2018 TEX
5813 5813 Matt Moore 27 moorema02 2016 SFG NL 1.829889507 0.66 P 4 2 SFG TBD 2016 2017 TEX
5820 5820 Cory Gearrin 30 gearrco01 2016 SFG NL 1.748698249 0.295 P, LF 3 1 SFG ATL 2015 2018 TEX
5892 5892 Drew Smyly 27 smylydr01 2016 TBR AL 4.932156646 0.915 P 8 1 TBD DET 2014 2016 TEX
5923 5923 Kevin Jepsen 31 jepseke01 2016 TBR AL 0.565912852 -0.355 P 0 2 TBD MIN 2016 2016 TEX
6003 6003 Jason Grilli 39 grillja01 2016 TOR AL 1.499345106 0.3 P 3 2 TOR ATL 2016 2017 TEX
6250 6250 Mike Napoli 33 napolmi01 2015 BOS AL 3.529298133 0.25 1B, LF 5 1 BOS TEX 2013 2015 TEX
6499 6499 Drew Stubbs 30 stubbdr01 2015 COL NL 1.149913043 0.13 CF, LF, RF 2 1 COL CLE 2014 2015 TEX
6547 6547 Bryan Holaday 27 holadbr01 2015 DET AL 0.614807567 0.166024845 C, 1B, 2B 1 1 DET   2012 2015 TEX
6591 6591 Carlos Gomez 29 gomezca01 2015 HOU AL 1.563678465 0.755 CF, 2B 4 2 HOU MIL 2015 2016 TEX
6678 6678 Cesar Ramos 31 ramosce01 2015 LAA AL 1.418300436 0.765 P 5 1 ANA TBD 2015 2015 TEX
6735 6735 Justin Ruggiano 33 ruggiju01 2015 LAD NL 0.605955076 0.615 LF, CF, RF 3 2 LAD SEA 2015 2015 TEX
6791 6791 Sam Dyson 27 dysonsa01 2015 MIA NL 1.362904835 0.075 P 2 1 FLA TOR 2013 2015 TEX
6823 6823 Jonathan Lucroy 29 lucrojo01 2015 MIL NL 4.214673437 1.32 C, 1B 10 1 MIL   2010 2016 TEX
6830 6830 Jeremy Jeffress 27 jeffrje01 2015 MIL NL 2.488195321 1.085 P 7 1 MIL TOR 2014 2016 TEX
6840 6840 Kyle Lohse 36 lohseky01 2015 MIL NL 4.222042898 -0.56 P 4 1 MIL STL 2013 2015 TEX
6946 6946 Rafael Montero 24 montera01 2015 NYM NL 0.371991171 0.125 P 1 1 NYM   2014 2017 TEX
6972 6972 Carlos Beltran 38 beltrca01 2015 NYY AL 4.933995514 1.295 RF 11 1 NYY STL 2014 2016 TEX
6991 6991 Chris Martin 29 martich02 2015 NYY AL 0.55059032 0.005 P 1 1 NYY COL 2015 2015 TEX
7069 7069 Cole Hamels 31 hamelco01 2015 PHI NL 3.724250685 2.835 P 14 1 PHI   2006 2015 TEX
7097 7097 Jake Diekman 28 diekmja01 2015 PHI NL 0.982280869 0.0 P 1 1 PHI   2012 2015 TEX
7164 7164 Tyson Ross 28 rossty01 2015 SDP NL 5.639225908 4.505 P 22 1 SDP OAK 2013 2016 TEX
7178 7178 Will Venable 32 venabwi01 2015 SDP NL 3.132935812 0.65 CF, LF, RF 7 1 SDP   2008 2015 TEX
7226 7226 Tom Wilhelmsen 31 wilheto01 2015 SEA AL 2.148771265 0.905 P 6 1 SEA   2011 2015 TEX
7272 7272 Hunter Pence 32 pencehu01 2015 SFG NL 2.230384549 1.125 RF 6 1 SFG PHI 2012 2018 TEX
7294 7294 Cory Gearrin 29 gearrco01 2015 SFG NL 0.110045009 0.045 P 0 1 SFG ATL 2015 2018 TEX
7366 7366 Drew Smyly 26 smylydr01 2015 TBR AL 1.780566793 1.33 P 6 1 TBD DET 2014 2016 TEX
7399 7399 Bobby Wilson 32 wilsobo02 2015 TBR AL 0.565526359 -0.245 C 0 1 TBD ARI 2015 2015 TEX
7400 7400 Ernesto Frieri 29 frierer01 2015 TBR AL 0.58653965 -0.255 P 0 1 TBD PIT 2015 2015 TEX
7520 7520 Ian Desmond 29 desmoia01 2015 WSN NL 6.457877367 1.735 SS 14 1 WSN   2009 2015 TEX
7549 7549 David Carpenter 29 carpeda01 2015 WSN NL 0.184408584 0.06 P 0 2 WSN NYY 2015 2015 TEX
7697 7697 Mike Napoli 32 napolmi01 2014 BOS AL 4.672897196 2.675 1B 14 1 BOS TEX 2013 2015 TEX
7732 7732 Mike Carp 28 carpmi01 2014 BOS AL 0.962616822 -0.23 1B, LF, 3B, P, RF 1 1 BOS SEA 2013 2014 TEX
7744 7744 Anthony Ranaudo 24 ranauan01 2014 BOS AL 1.071067251 -0.535 P 0 1 BOS   2014 2014 TEX
7783 7783 Kyuji Fujikawa 33 fujikky01 2014 CHC NL 0.234541313 -0.01 P 0 1 CHC   2013 2014 TEX
7925 7925 Chris Gimenez 31 gimench01 2014 CLE AL 0.093533301 -0.255 C, 1B, 3B, P 0 2 CLE TEX 2014 2014 TEX
7936 7936 Drew Stubbs 29 stubbdr01 2014 COL NL 4.216735254 2.655 CF 13 1 COL CLE 2014 2015 TEX

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