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,378 rows where prev_franch = "TEX"

✎ 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
56 56 Luke Jackson 27 jackslu01 2019 ATL NL 2.794560783 0.94245283 P 8 1 ATL TEX 2017 2019  
73 73 Chris Martin 33 martich02 2019 ATL NL 0.531953431 0.259811321 P 2 2 ATL TEX 2019 2019  
98 98 Hanser Alberto 26 alberha01 2019 BAL AL 5.196033058 2.465660377 2B, 3B, LF, P, RF 13 1 BAL TEX 2019 2019  
100 100 Andrew Cashner 32 cashnan01 2019 BAL AL 2.823014192 2.29245283 P 10 1 BAL TEX 2018 2019 BOS
101 101 Renato Nunez 25 nunezre01 2019 BAL AL 5.608264463 0.825283019 1B, 3B, LF 9 1 BAL TEX 2018 2019  
152 152 Chris Davis 33 davisch02 2019 BAL AL 3.32661157 -1.21754717 1B, P, RF 0 1 BAL TEX 2011 2019  
167 167 Mitch Moreland 33 morelmi01 2019 BOS AL 2.990539262 1.136037736 1B 7 1 BOS TEX 2017 2019  
186 186 Juan Centeno 29 centeju01 2019 BOS AL 0.1371807 -0.00509434 C 0 1 BOS TEX 2019 2019  
209 209 Cole Hamels 35 hamelco01 2019 CHC NL 3.900159305 2.384150943 P 12 1 CHC TEX 2018 2019  
237 237 Tony Barnette 35 barneto01 2019 CHC NL 0.031746184 -0.061132075 P 0 1 CHC TEX 2019 2019  
258 258 Leury Garcia 28 garcile02 2019 CHW AL 5.970588235 1.384177215 CF, RF, LF, SS, 2B, 3B 13 1 CHW TEX 2013 2019  
416 416 Ian Desmond 33 desmoia01 2019 COL NL 4.743199316 -1.034150943 CF, LF, P 4 1 COL TEX 2017 2019  
417 417 Chi Chi Gonzalez 27 gonzach01 2019 COL NL 1.660304692 0.117169811 P 3 1 COL TEX 2019 2019  
470 470 Matt Moore 30 moorema02 2019 DET AL 0.290093103 0.63056962 P 2 1 DET TEX 2019 2019  
511 511 Robinson Chirinos 35 chiriro01 2019 HOU AL 3.97793765 3.163584906 C 14 1 HOU TEX 2019 2019  
772 772 Alex Claudio 27 claudal01 2019 MIL NL 2.037084077 0.371886792 P 4 1 MIL TEX 2019 2019  
780 780 Jeremy Jeffress 31 jeffrje01 2019 MIL NL 1.587971271 -0.081509434 P 2 1 MIL TEX 2017 2019  
817 817 Martin Perez 28 perezma02 2019 MIN AL 4.355565073 1.008679245 P 9 1 MIN TEX 2019 2019  
968 968 Jurickson Profar 26 profaju01 2019 OAK AL 4.838057999 1.125849057 2B, LF, 1B 10 1 OAK TEX 2019 2019  
1024 1024 Drew Smyly 30 smylydr01 2019 PHI NL 1.811188154 0.366792453 P 4 2 PHI TEX 2019 2019  
1078 1078 Keone Kela 26 kelake01 2019 PIT NL 0.997778728 0.774339623 P 4 1 PIT TEX 2018 2019  
1200 1200 Connor Sadzeck 27 sadzeco01 2019 SEA AL 0.613016393 0.254716981 P 2 1 SEA TEX 2019 2019  
1251 1251 Sam Dyson 31 dysonsa01 2019 SFG NL 1.753498531 1.151320755 P 6 1 SFG TEX 2017 2019 MIN
1309 1309 Miles Mikolas 30 mikolmi01 2019 STL NL 5.153531055 2.047924528 P 14 1 STL TEX 2018 2019  
1339 1339 Drew Robinson 27 robindr01 2019 STL NL 0.070793374 -0.101886792 CF, RF 0 1 STL TEX 2019 2019  
1399 1399 Peter Fairbanks 25 fairbpe01 2019 TBR AL 0.38064644 -0.13754717 P 0 2 TBD TEX 2019 2019  
1504 1504 Ryan Feierabend 33 feierry01 2019 TOR AL 0.135944996 -0.173207547 P 0 1 TOR TEX 2019 2019  
1529 1529 Asdrubal Cabrera 33 cabreas01 2019 WSN NL 1.408300327 1.192075472 3B, 2B, 1B 5 2 WSN TEX 2019 2019  
1611 1611 Jake Diekman 31 diekmja01 2018 ARI NL 0.442302496 -0.51 P 0 2 ARI TEX 2018 2018 KCR
1639 1639 Luke Jackson 26 jackslu01 2018 ATL NL 1.076143466 0.12 P 2 1 ATL TEX 2017 2019  
1677 1677 Andrew Cashner 31 cashnan01 2018 BAL AL 4.421624365 0.63 P 7 1 BAL TEX 2018 2019 BOS
1681 1681 Renato Nunez 24 nunezre01 2018 BAL AL 2.122774913 1.07 3B, LF 6 2 BAL TEX 2018 2019  
1695 1695 Darren O'Day 35 odayda01 2018 BAL AL 0.700966733 0.37 P 2 1 BAL TEX 2012 2018 ATL
1712 1712 Jhan Marinez 29 marinjh01 2018 BAL AL 0.183235164 -0.125 P 0 1 BAL TEX 2018 2018  
1727 1727 Chris Davis 32 davisch02 2018 BAL AL 5.036765929 -2.975 1B 0 1 BAL TEX 2011 2019  
1739 1739 Mitch Moreland 32 morelmi01 2018 BOS AL 4.23782235 0.82 1B 9 1 BOS TEX 2017 2019  
1785 1785 Cole Hamels 34 hamelco01 2018 CHC NL 2.046879362 2.131840491 P 9 2 CHC TEX 2018 2019  
1789 1789 Jesse Chavez 34 chaveje01 2018 CHC NL 1.355023181 1.550429448 P 7 2 CHC TEX 2018 2018 TEX
1802 1802 Anthony Bass 30 bassan01 2018 CHC NL 0.40453187 0.213680982 P 1 1 CHC TEX 2018 2018 SEA
1837 1837 Leury Garcia 27 garcile02 2018 CHW AL 2.636363636 0.455 LF, CF, RF, 2B, SS, 3B 5 1 CHW TEX 2013 2019  
1868 1868 Miguel Gonzalez 34 gonzami03 2018 CHW AL 0.346747519 -0.495 P 0 1 CHW TEX 2018 2018  
1912 1912 Phil Gosselin 29 gosseph01 2018 CIN NL 0.275581198 -0.155 3B, 1B, 2B, LF 0 1 CIN TEX 2018 2018 PHI
1987 1987 Ian Desmond 32 desmoia01 2018 COL NL 6.144446346 -0.611226994 1B, LF, SS, CF 8 1 COL TEX 2017 2019  
2040 2040 Pete Kozma 30 kozmape01 2018 DET AL 0.704492512 0.325 SS, 3B, 2B 2 1 DET TEX 2018 2018  
2045 2045 Jim Adduci 33 adducji02 2018 DET AL 1.785357737 -0.305 1B 2 1 DET TEX 2017 2018 CHC
2266 2266 Wilmer Font 28 fontwi01 2018 LAD NL 0.288835068 -0.606257669 P 0 1 LAD TEX 2017 2018 OAK
2303 2303 Tomas Telis 27 telisto01 2018 MIA NL 0.31 -0.11068323 C, 1B 0 1 FLA TEX 2015 2018  
2323 2323 Jeremy Jeffress 30 jeffrje01 2018 MIL NL 3.063101152 2.524417178 P 12 1 MIL TEX 2017 2019  
2573 2573 Cory Gearrin 32 gearrco01 2018 OAK AL 0.118709894 -0.03 P 0 3 OAK TEX 2018 2018 SEA
2581 2581 Jake Smolinski 29 smolija01 2018 OAK AL 0.381456529 -0.37 CF, LF, P 0 1 OAK TEX 2015 2018  
2656 2656 Keone Kela 25 kelake01 2018 PIT NL 0.488775857 0.311925466 P 2 2 PIT TEX 2018 2019  
2694 2694 Tyson Ross 31 rossty01 2018 SDP NL 3.448170298 0.495 P 6 1 SDP TEX 2018 2018 STL
2794 2794 Sam Dyson 30 dysonsa01 2018 SFG NL 2.280848854 0.895 P 6 1 SFG TEX 2017 2019 MIN
2830 2830 Miles Mikolas 29 mikolmi01 2018 STL NL 5.525445992 4.415 P 22 1 STL TEX 2018 2019  
2898 2898 Carlos Gomez 32 gomezca01 2018 TBR AL 3.83346833 -0.05 RF, CF, 2B, P 5 1 TBD TEX 2018 2018 NYM
3019 3019 Mike Hauschild 28 hauscmi01 2018 TOR AL 0.24317584 0.08 P 1 1 TOR TEX 2018 2018  
3166 3166 Luke Jackson 25 jackslu01 2017 ATL NL 1.198915364 0.2 P 2 1 ATL TEX 2017 2019  
3204 3204 Chris Davis 31 davisch02 2017 BAL AL 4.964390722 0.0 1B, 3B 8 1 BAL TEX 2011 2019  
3206 3206 Darren O'Day 34 odayda01 2017 BAL AL 2.020733652 0.925 P 6 1 BAL TEX 2012 2018 ATL
3250 3250 Mitch Moreland 31 morelmi01 2017 BOS AL 5.290261283 1.435 1B, P 12 1 BOS TEX 2017 2019  
3281 3281 Robbie Ross 28 rossro01 2017 BOS AL 0.216108299 -0.04 P 0 1 BOS TEX 2015 2017  
3322 3322 Justin Grimm 28 grimmju01 2017 CHC NL 1.484145796 -0.43 P 1 1 CHC TEX 2013 2017 KCR
3346 3346 Leury Garcia 26 garcile02 2017 CHW AL 3.130981951 1.21 CF, LF, RF, 2B, SS 8 1 CHW TEX 2013 2019  
3365 3365 Derek Holland 30 hollade01 2017 CHW AL 3.768239164 -1.16 P 2 1 CHW TEX 2017 2017 SFG
3431 3431 Lisalverto Bonilla 27 bonilli01 2017 CIN NL 0.905741422 -0.545 P 0 1 CIN TEX 2017 2017  
3493 3493 Jonathan Lucroy 31 lucrojo01 2017 COL NL 1.730900409 0.765 C, 1B 5 2 COL TEX 2017 2017 OAK
3502 3502 Ian Desmond 31 desmoia01 2017 COL NL 3.689290587 -0.97 LF, 1B, CF, SS 3 1 COL TEX 2017 2019  
3521 3521 Ian Kinsler 35 kinslia01 2017 DET AL 5.80189295 2.445 2B 14 1 DET TEX 2014 2017 ANA
3541 3541 Jim Adduci 32 adducji02 2017 DET AL 0.880221932 0.375 RF 2 1 DET TEX 2017 2018 CHC
3588 3588 Carlos Beltran 40 beltrca01 2017 HOU AL 4.729573855 -0.95 LF, RF 4 1 HOU TEX 2017 2017  
3737 3737 Yu Darvish 30 darviyu01 2017 LAD NL 1.404777541 0.69 P 4 2 LAD TEX 2017 2017 CHC
3764 3764 Wilmer Font 27 fontwi01 2017 LAD NL 0.077781307 -0.265 P 0 1 LAD TEX 2017 2018 OAK
3807 3807 Tomas Telis 26 telisto01 2017 MIA NL 1.085666105 -0.36 1B, C 0 1 FLA TEX 2015 2018  
3832 3832 Matt Garza 33 garzama01 2017 MIL NL 3.080173535 0.18 P 5 1 MIL TEX 2014 2017  
3839 3839 Jeremy Jeffress 29 jeffrje01 2017 MIL NL 0.742251756 0.24 P 2 2 MIL TEX 2017 2019  
3885 3885 Dillon Gee 31 geedi01 2017 MIN AL 1.130220627 0.57 P 3 2 MIN TEX 2017 2017  
4059 4059 Jake Smolinski 28 smolija01 2017 OAK AL 0.275602163 -0.08 CF, LF, RF 0 1 OAK TEX 2015 2018  
4115 4115 Andres Blanco 33 blancan01 2017 PHI NL 1.433327613 -0.435 3B, 2B, 1B, SS, P 0 1 PHI TEX 2014 2017  
4259 4259 Leonys Martin 29 martile01 2017 SEA AL 1.152630722 -0.335 CF, RF, LF, P 1 1 SEA TEX 2016 2017 CHC
4303 4303 Sam Dyson 29 dysonsa01 2017 SFG NL 1.580280271 0.265 P 3 2 SFG TEX 2017 2019 MIN
4522 4522 Lucas Harrell 32 harrelu01 2017 TOR AL 0.167669027 -0.05 P 0 1 TOR TEX 2017 2017  
4690 4690 Drew Stubbs 31 stubbdr01 2016 ATL NL 0.414426676 -0.145900621 RF, CF, LF 0 1 ATL TEX 2016 2016 TEX
4704 4704 Chris Davis 30 davisch02 2016 BAL AL 6.363636364 3.09 1B, RF 19 1 BAL TEX 2011 2019  
4718 4718 Yovani Gallardo 30 gallayo01 2016 BAL AL 3.414082349 0.55 P 7 1 BAL TEX 2016 2016 SEA
4722 4722 Darren O'Day 33 odayda01 2016 BAL AL 1.127145378 0.305 P 3 1 BAL TEX 2012 2018 ATL
4745 4745 Drew Stubbs 31 stubbdr01 2016 BAL AL 0.258373206 -0.25 RF, CF, LF 0 3 BAL TEX 2016 2016 SFG
4766 4766 Robbie Ross 27 rossro01 2016 BOS AL 1.663862538 0.825 P 4 1 BOS TEX 2015 2017  
4767 4767 Koji Uehara 41 ueharko01 2016 BOS AL 1.565693469 0.67 P 4 1 BOS TEX 2013 2016 CHC
4794 4794 Bryan Holaday 28 holadbr01 2016 BOS AL 0.322580645 -0.22 C, 3B, LF, P 0 2 BOS TEX 2016 2016 DET
4824 4824 Justin Grimm 27 grimmju01 2016 CHC NL 1.424473435 0.34 P 3 1 CHC TEX 2013 2017 KCR
4841 4841 Spencer Patton 28 pattosp01 2016 CHC NL 0.494117647 -0.34 P, LF 0 1 CHC TEX 2016 2016  
4881 4881 Leury Garcia 25 garcile02 2016 CHW AL 0.474709445 -0.08 CF 0 1 CHW TEX 2013 2019  
4889 4889 Anthony Ranaudo 26 ranauan01 2016 CHW AL 0.663526443 -0.47 P 0 2 CHW TEX 2016 2016  
4914 4914 Ross Ohlendorf 33 ohlenro01 2016 CIN NL 2.101463598 -0.13 P 3 1 CIN TEX 2016 2016  
4954 4954 Mike Napoli 34 napolmi01 2016 CLE AL 6.102773246 0.950869565 1B 12 1 CLE TEX 2016 2016 TEX
4993 4993 Chris Gimenez 33 gimench01 2016 CLE AL 1.466557912 -0.578571429 C, 1B, 3B, P 0 1 CLE TEX 2016 2016 MIN
5042 5042 Ian Kinsler 34 kinslia01 2016 DET AL 6.451834862 5.735403727 2B 26 1 DET TEX 2014 2017 ANA
5078 5078 Bobby Wilson 33 wilsobo02 2016 DET AL 0.142529489 -0.11068323 C 0 1 DET TEX 2016 2016 TEX
5266 5266 Nick Tepesch 27 tepesni01 2016 LAD NL 0.111146228 -0.11 P 0 1 LAD TEX 2016 2016 MIN
5272 5272 Will Venable 33 venabwi01 2016 LAD NL 0.188504961 -0.295 RF, LF 0 1 LAD TEX 2016 2016  

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