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,132 rows where prev_franch = "HOU"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, lg_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
53 53 Dallas Keuchel 31 keuchda01 2019 ATL NL 3.028895095 1.599622642 P 10 1 ATL HOU 2019 2019  
57 57 Mike Foltynewicz 27 foltymi01 2019 ATL NL 3.195932885 0.641886792 P 8 1 ATL HOU 2015 2019  
59 59 Brian McCann 35 mccanbr01 2019 ATL NL 3.074555404 0.646981132 C 7 1 ATL HOU 2019 2019  
234 234 Tony Kemp 27 kempto01 2019 CHC NL 0.788702929 -0.091698113 2B, LF, CF 1 2 CHC HOU 2019 2019  
293 293 AJ Reed 26 reedaj01 2019 CHW AL 0.480392157 -0.51778481 1B, P 0 1 CHW HOU 2019 2019  
378 378 James Hoyt 32 hoytja01 2019 CLE AL 0.174234553 0.091698113 P 1 1 CLE HOU 2019 2019  
472 472 Jose Cisnero 30 cisnejo01 2019 DET AL 1.07587827 0.184556962 P 2 1 DET HOU 2019 2019  
559 559 Martin Maldonado 32 maldoma01 2019 KCR AL 2.559825474 0.911886792 C, 1B 6 1 KCR HOU 2019 2019 CHC
649 649 Nick Tropeano 28 tropeni01 2019 LAA AL 0.362705827 -0.433018868 P 0 1 ANA HOU 2015 2019  
653 653 Max Stassi 28 stassma01 2019 LAA AL 0.463697177 -0.53490566 C, 1B, P 0 2 ANA HOU 2019 2019  
701 701 Tyler White 28 whitety01 2019 LAD NL 0.259865587 -0.433018868 1B, P 0 2 LAD HOU 2019 2019  
815 815 Marwin Gonzalez 30 gonzama01 2019 MIN AL 4.282934609 1.518113208 RF, 3B, 1B, LF, 2B, SS 11 1 MIN HOU 2019 2019  
819 819 Jason Castro 32 castrja01 2019 MIN AL 2.516108453 1.054528302 C 7 1 MIN HOU 2017 2019  
863 863 J.D. Davis 26 davisjd01 2019 NYM NL 4.389726027 1.502830189 LF, 3B 10 1 NYM HOU 2019 2019  
1018 1018 Vince Velasquez 27 velasvi01 2019 PHI NL 3.380091972 0.825283019 P, LF 8 1 PHI HOU 2016 2019  
1067 1067 Joe Musgrove 26 musgrjo01 2019 PIT NL 5.062373469 2.649056604 P 15 1 PIT HOU 2018 2019  
1074 1074 Colin Moran 26 moranco01 2019 PIT NL 5.023071625 -0.157924528 3B, 2B, 1B, LF 7 1 PIT HOU 2018 2019  
1081 1081 Michael Feliz 26 felizmi01 2019 PIT NL 1.736921173 0.320943396 P 4 1 PIT HOU 2018 2019  
1265 1265 Jandel Gustave 26 gustaja01 2019 SFG NL 0.810898373 0.346415094 P 2 1 SFG HOU 2019 2019  
1333 1333 Luke Gregerson 35 gregelu01 2019 STL NL 0.090814859 0.00509434 P 0 1 STL HOU 2018 2019  
1345 1345 Charlie Morton 35 mortoch02 2019 TBR AL 5.224941733 5.67509434 P 24 1 TBD HOU 2019 2019  
1463 1463 Ken Giles 28 gileske01 2019 TOR AL 2.030237377 2.139622642 P 9 1 TOR HOU 2018 2019  
1466 1466 Teoscar Hernandez 26 hernate01 2019 TOR AL 4.403955749 0.596037736 CF, LF 8 1 TOR HOU 2017 2019  
1495 1495 Derek Fisher 25 fishede01 2019 TOR AL 1.001340932 -0.178301887 LF, RF, CF 1 2 TOR HOU 2019 2019  
1542 1542 Tony Sipp 35 sippto01 2019 WSN NL 0.663277908 0.188490566 P 1 1 WSN HOU 2019 2019  
1620 1620 Mike Foltynewicz 26 foltymi01 2018 ATL NL 5.086130572 3.335 P 17 1 ATL HOU 2015 2019  
1641 1641 Preston Tucker 27 tuckepr01 2018 ATL NL 1.390511565 -0.045 LF, RF 2 1 ATL HOU 2018 2018 CIN
1902 1902 Tim Federowicz 30 federti01 2018 CIN NL 0.0688953 0.13 C 0 2 CIN HOU 2018 2018 TEX
2020 2020 Mike Fiers 33 fiersmi01 2018 DET AL 3.342287015 2.07 P 11 1 DET HOU 2018 2018 OAK
2027 2027 Francisco Liriano 34 liriafr01 2018 DET AL 3.734145498 0.18 P 6 1 DET HOU 2018 2018 PIT
2177 2177 Nick Tropeano 27 tropeni01 2018 LAA AL 2.259950666 0.02 P 3 1 ANA HOU 2015 2019  
2191 2191 Luis Valbuena 32 valbulu01 2018 LAA AL 2.744659875 -0.89 3B, 1B, 2B 1 1 ANA HOU 2017 2018  
2236 2236 Josh Fields 32 fieldjo03 2018 LAD NL 1.081042326 0.591349693 P 3 1 LAD HOU 2016 2018  
2274 2274 Cameron Maybin 31 maybica01 2018 MIA NL 2.87 1.046459627 LF, CF, RF 8 1 FLA HOU 2018 2018 SEA
2328 2328 Jonathan Villar 27 villajo01 2018 MIL NL 2.735756551 1.073374233 2B, SS 8 1 MIL HOU 2016 2018 BAL
2334 2334 Domingo Santana 25 santado01 2018 MIL NL 2.304311074 0.864662577 RF 6 1 MIL HOU 2015 2018 SEA
2378 2378 Robbie Grossman 28 grossro01 2018 MIN AL 4.398238748 1.125 RF, LF 10 1 MIN HOU 2016 2018 OAK
2408 2408 Jason Castro 31 castrja01 2018 MIN AL 0.699934768 -0.02 C 1 1 MIN HOU 2017 2019  
2531 2531 Jed Lowrie 34 lowrije01 2018 OAK AL 6.326596086 4.9 2B, 3B 24 1 OAK HOU 2016 2018 NYM
2589 2589 Vince Velasquez 26 velasvi01 2018 PHI NL 4.166262545 2.455 P 13 1 PHI HOU 2016 2019  
2640 2640 Joe Musgrove 25 musgrjo01 2018 PIT NL 3.307040978 1.780993789 P 10 1 PIT HOU 2018 2019  
2641 2641 Colin Moran 25 moranco01 2018 PIT NL 4.689619197 0.845217391 3B 10 1 PIT HOU 2018 2019  
2663 2663 Michael Feliz 25 felizmi01 2018 PIT NL 1.424943804 -0.377329193 P 1 1 PIT HOU 2018 2019  
2868 2868 Luke Gregerson 34 gregelu01 2018 STL NL 0.32466438 -0.225 P 0 1 STL HOU 2018 2019  
2975 2975 Juan Centeno 28 centeju01 2018 TEX AL 0.358723958 -0.38 C 0 1 TEX HOU 2018 2018 BOS
2993 2993 Teoscar Hernandez 25 hernate01 2018 TOR AL 5.012227363 0.235 LF, RF 8 1 TOR HOU 2017 2019  
2998 2998 Tyler Clippard 33 clippty01 2018 TOR AL 2.436161162 0.91 P 6 1 TOR HOU 2018 2018 CLE
3020 3020 Ken Giles 27 gileske01 2018 TOR AL 0.833657974 0.005 P 1 2 TOR HOU 2018 2019  
3023 3023 David Paulino 24 paulida01 2018 TOR AL 0.124915589 0.08 P 0 1 TOR HOU 2018 2018  
3025 3025 Rhiner Cruz 31 cruzrh01 2018 TOR AL 0.071672879 0.045 P 0 1 TOR HOU 2018 2018  
3151 3151 Mike Foltynewicz 25 foltymi01 2017 ATL NL 4.349375898 1.235 P 10 1 ATL HOU 2015 2019  
3259 3259 Doug Fister 33 fistedo01 2017 BOS AL 2.724269986 0.745 P 6 1 BOS HOU 2017 2017 TEX
3420 3420 Asher Wojciechowski 28 wojcias01 2017 CIN NL 1.698703428 -0.405 P 1 1 CIN HOU 2017 2017 BAL
3505 3505 Chad Qualls 38 quallch01 2017 COL NL 0.404096393 -0.015 P 1 1 COL HOU 2016 2017  
3515 3515 Jordan Lyles 26 lylesjo01 2017 COL NL 1.046075944 -0.38 P 0 1 COL HOU 2014 2017 SDP
3530 3530 J.D. Martinez 29 martijd02 2017 DET AL 2.195822454 1.605 RF 7 1 DET HOU 2014 2017 ARI
3674 3674 Luis Valbuena 31 valbulu01 2017 LAA AL 3.843027098 0.445 3B, 1B 7 1 ANA HOU 2017 2018  
3739 3739 Josh Fields 31 fieldjo03 2017 LAD NL 1.775128895 0.565 P 4 1 LAD HOU 2016 2018  
3814 3814 Domingo Santana 24 santado01 2017 MIL NL 6.050180443 3.105 RF 18 1 MIL HOU 2015 2018 SEA
3828 3828 Jonathan Villar 26 villajo01 2017 MIL NL 4.345763877 -0.155 2B, CF 6 1 MIL HOU 2016 2018 BAL
3871 3871 Jason Castro 30 castrja01 2017 MIN AL 3.784832451 2.285 C 12 1 MIN HOU 2017 2019  
3874 3874 Robbie Grossman 27 grossro01 2017 MIN AL 4.240500241 0.67 RF, LF 8 1 MIN HOU 2016 2018 OAK
4017 4017 Jed Lowrie 33 lowrije01 2017 OAK AL 6.129772243 3.87 2B, 3B 20 1 OAK HOU 2016 2018 NYM
4080 4080 Pat Neshek 36 neshepa01 2017 PHI NL 1.435042939 1.88 P 7 1 PHI HOU 2017 2017 COL
4091 4091 Vince Velasquez 25 velasvi01 2017 PHI NL 2.027581682 0.505 P 4 1 PHI HOU 2016 2019  
4394 4394 Colby Rasmus 30 rasmuco01 2017 TBR AL 1.222149624 1.18 LF, RF, CF 5 1 TBD HOU 2017 2017 BAL
4442 4442 Carlos Gomez 31 gomezca01 2017 TEX AL 4.054479816 1.735 CF 11 1 TEX HOU 2016 2017 TBD
4474 4474 Anthony Bass 29 bassan01 2017 TEX AL 0.124241152 -0.145 P 0 1 TEX HOU 2015 2017 CHC
4505 4505 Teoscar Hernandez 24 hernate01 2017 TOR AL 0.898858075 0.53 LF, CF, RF 3 2 TOR HOU 2017 2019  
4509 4509 Nori Aoki 35 aokino01 2017 TOR AL 0.321696574 0.355 LF, RF, CF, P 2 2 TOR HOU 2017 2017 NYM
4566 4566 Oliver Perez 35 perezol01 2017 WSN NL 1.042953554 0.35 P 3 1 WSN HOU 2016 2017 CLE
4646 4646 Mike Foltynewicz 24 foltymi01 2016 ATL NL 3.384154266 1.433850932 P 9 1 ATL HOU 2015 2019  
4660 4660 Lucas Harrell 31 harrelu01 2016 ATL NL 0.817861868 0.457826087 P 3 1 ATL HOU 2016 2016 TEX
4695 4695 Roberto Hernandez 35 carmofa01 2016 ATL NL 0.252262589 -0.286770186 P 0 1 ATL HOU 2016 2016  
4804 4804 Dexter Fowler 30 fowlede01 2016 CHC NL 5.384667228 4.34 CF 20 1 CHC HOU 2015 2016 STL
4829 4829 Jake Buchanan 26 buchaja01 2016 CHC NL 0.132694497 0.16 P 1 1 CHC HOU 2016 2016 CIN
4891 4891 Matt Albers 33 alberma01 2016 CHW AL 1.755487853 -1.245 P 0 1 CHW HOU 2015 2016 WSN
4897 4897 Dan Straily 27 straida01 2016 CIN NL 5.368547633 2.21 P 15 1 CIN HOU 2016 2016 FLA
5014 5014 Brandon Barnes 30 barnebr02 2016 COL NL 1.071707069 0.055 LF, CF, RF 2 1 COL HOU 2014 2016 CLE
5022 5022 Chad Qualls 37 quallch01 2016 COL NL 0.844081985 -0.065 P 1 1 COL HOU 2016 2017  
5024 5024 Jordan Lyles 25 lylesjo01 2016 COL NL 1.813668872 -0.46 P 1 1 COL HOU 2014 2017 SDP
5046 5046 J.D. Martinez 28 martijd02 2016 DET AL 4.912516383 2.022484472 RF 13 1 DET HOU 2014 2017 ARI
5185 5185 Nick Tropeano 25 tropeni01 2016 LAA AL 1.998533214 0.69 P 5 1 ANA HOU 2015 2019  
5237 5237 Scott Kazmir 32 kazmisc01 2016 LAD NL 3.707202193 0.525 P 7 1 LAD HOU 2016 2016  
5252 5252 Josh Fields 30 fieldjo03 2016 LAD NL 0.488369789 0.18 P 1 2 LAD HOU 2016 2018  
5318 5318 Jarred Cosart 26 cosarja01 2016 MIA NL 0.53718626 -0.120745342 P 0 1 FLA HOU 2014 2016 SDP
5327 5327 Paul Clemens 28 clemepa02 2016 MIA NL 0.273145556 -0.332049689 P 0 1 FLA HOU 2016 2016 SDP
5331 5331 Jonathan Villar 25 villajo01 2016 MIL NL 6.846662031 3.445 SS, 3B, 2B 20 1 MIL HOU 2016 2018 BAL
5336 5336 Chris Carter 29 cartech02 2016 MIL NL 6.493741307 0.935 1B 12 1 MIL HOU 2016 2016 NYY
5352 5352 Domingo Santana 23 santado01 2016 MIL NL 2.833449235 0.01 RF, LF, CF 4 1 MIL HOU 2015 2018 SEA
5378 5378 Alex Presley 30 preslal01 2016 MIL NL 1.300764951 -0.655 RF, LF, CF 0 1 MIL HOU 2016 2016 DET
5392 5392 Robbie Grossman 26 grossro01 2016 MIN AL 3.629081551 0.5 LF, CF 6 1 MIN HOU 2016 2018 OAK
5550 5550 Fernando Rodriguez Jr. 32 rodrife02 2016 OAK AL 1.16549819 0.46 P 3 1 OAK HOU 2014 2016  
5556 5556 Jed Lowrie 32 lowrije01 2016 OAK AL 3.568189396 -0.63 2B, SS 3 1 OAK HOU 2016 2018 NYM
5586 5586 Vince Velasquez 24 velasvi01 2016 PHI NL 3.70586465 2.23 P 12 1 PHI HOU 2016 2019  
5610 5610 Brett Oberholtzer 26 oberhbr01 2016 PHI NL 1.166371292 -0.2 P 1 1 PHI HOU 2016 2016 ANA
5683 5683 Erik Kratz 36 kratzer01 2016 PIT NL 0.556565657 -0.545 C, 1B, P 0 2 PIT HOU 2016 2016 NYY
5714 5714 Brett Wallace 29 wallabr01 2016 SDP NL 2.609031805 -0.58 3B, 1B 2 1 SDP HOU 2015 2016  
5918 5918 Hank Conger 28 congeha01 2016 TBR AL 1.319714333 -0.31 C 1 1 TBD HOU 2016 2016  
5950 5950 Carlos Gomez 30 gomezca01 2016 TEX AL 1.242788858 0.845 CF, LF, RF 5 2 TEX HOU 2016 2017 TBD

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