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,792 rows where next_franch = "LAD"

✎ 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
540 540 Tyler White 28 whitety01 2019 HOU AL 2.345963229 -0.708113208 1B, P 1 1 HOU   2016 2019 LAD
900 900 Travis d'Arnaud 30 darnatr01 2019 NYM NL 0.248287671 -0.310754717 C, 1B 0 1 NYM   2013 2019 LAD
1206 1206 Kristopher Negron 33 negrokr01 2019 SEA AL 0.239037257 0.096792453 CF, RF, LF, SS, 2B, 3B 1 1 SEA ARI 2018 2019 LAD
1332 1332 Jedd Gyorko 30 gyorkje01 2019 STL NL 0.627027027 -0.152830189 3B, 1B, 2B, P 1 1 STL SDP 2016 2019 LAD
1376 1376 Adam Kolarek 30 kolarad01 2019 TBR AL 1.386996015 0.259811321 P, 1B 3 1 TBD   2017 2019 LAD
1382 1382 Casey Sadler 28 sadleca02 2019 TBR AL 0.377393052 0.229245283 P 1 1 TBD PIT 2019 2019 LAD
1501 1501 Zac Rosscup 31 rosscza01 2019 TOR AL 0.017561522 -0.076415094 P 0 2 TOR SEA 2019 2019 LAD
1571 1571 A.J. Pollock 30 polloaj01 2018 ARI NL 4.580257511 2.545 CF 14 1 ARI   2012 2018 LAD
1672 1672 Manny Machado 25 machama01 2018 BAL AL 3.98502745 3.355 SS, 3B 14 1 BAL   2012 2018 LAD
1748 1748 Joe Kelly 30 kellyjo05 2018 BOS AL 2.207760807 0.515 P 5 1 BOS STL 2014 2018 LAD
1893 1893 Dylan Floro 27 florody01 2018 CIN NL 1.040460768 0.515 P 3 1 CIN CHC 2018 2018 LAD
2079 2079 Tyler White 27 whitety01 2018 HOU AL 2.245711485 1.555 1B 8 1 HOU   2016 2019 LAD
2379 2379 Brian Dozier 31 doziebr01 2018 MIN AL 4.369863014 1.06 2B 10 1 MIN   2012 2018 LAD
2456 2456 Travis d'Arnaud 29 darnatr01 2018 NYM NL 0.158795346 -0.03 C 0 1 NYM   2013 2019 LAD
2644 2644 David Freese 35 freesda01 2018 PIT NL 2.672578682 1.378509317 3B, 1B 8 1 PIT ANA 2016 2018 LAD
2757 2757 Erik Goeddel 29 goedder01 2018 SEA AL 0.242843236 0.25 P 1 1 SEA NYM 2018 2018 LAD
2763 2763 Kristopher Negron 32 negrokr01 2018 SEA AL 0.286892003 0.025 3B, LF, 2B, SS, RF 1 2 SEA ARI 2018 2019 LAD
2839 2839 Jedd Gyorko 29 gyorkje01 2018 STL NL 3.970032351 1.7 3B, 2B, 1B, SS, P 11 1 STL SDP 2016 2019 LAD
2906 2906 Adam Kolarek 29 kolarad01 2018 TBR AL 1.129281507 0.575 P 3 1 TBD   2017 2019 LAD
2928 2928 Jaime Schultz 27 schulja02 2018 TBR AL 0.731084069 -0.215 P 0 1 TBD   2018 2018 LAD
2988 2988 Russell Martin 35 martiru01 2018 TOR AL 3.373430271 1.225 C, 3B, SS, LF 9 1 TOR PIT 2015 2018 LAD
3008 3008 John Axford 35 axforjo01 2018 TOR AL 1.402075101 0.265 P 3 1 TOR OAK 2018 2018 LAD
3080 3080 Ryan Madson 37 madsory01 2018 WSN NL 1.637493265 -0.22 P 1 1 WSN OAK 2017 2018 LAD
3106 3106 A.J. Pollock 29 polloaj01 2017 ARI NL 4.601293837 2.65 CF 14 1 ARI   2012 2018 LAD
3161 3161 Matt Kemp 32 kempma01 2017 ATL NL 4.595520869 -0.99 LF 4 1 ATL SDP 2016 2017 LAD
3193 3193 Manny Machado 24 machama01 2017 BAL AL 6.537079386 2.995 3B 19 1 BAL   2012 2018 LAD
3257 3257 Joe Kelly 29 kellyjo05 2017 BOS AL 1.848640702 0.995 P 6 1 BOS STL 2014 2018 LAD
3429 3429 Tony Cingrani 27 cingrto01 2017 CIN NL 0.687938499 -0.29 P 0 1 CIN   2012 2017 LAD
3508 3508 Zac Rosscup 29 rosscza01 2017 COL NL 0.146237147 0.06 P 0 2 COL CHC 2017 2017 LAD
3596 3596 Tyler White 26 whitety01 2017 HOU AL 0.622556873 0.09 1B, 2B, LF, P 1 1 HOU   2016 2019 LAD
3623 3623 Scott Alexander 27 alexasc02 2017 KCR AL 2.678779662 1.685 P 9 1 KCR   2015 2017 LAD
3862 3862 Brian Dozier 30 doziebr01 2017 MIN AL 6.556036556 4.73 2B 24 1 MIN   2012 2018 LAD
3917 3917 Curtis Granderson 36 grandcu01 2017 NYM NL 3.919589393 2.14 CF, RF, LF 12 1 NYM NYY 2014 2017 LAD
3922 3922 Travis d'Arnaud 28 darnatr01 2017 NYM NL 3.731052181 1.365 C, 2B, 3B 9 1 NYM   2013 2019 LAD
4061 4061 Zach Neal 28 nealza01 2017 OAK AL 0.247135415 -0.195 P 0 1 OAK   2016 2017 LAD
4125 4125 David Freese 34 freesda01 2017 PIT NL 5.018751075 1.965 3B, 1B 13 1 PIT ANA 2016 2018 LAD
4139 4139 Tony Watson 32 watsoto01 2017 PIT NL 1.859780095 0.275 P 4 1 PIT   2011 2017 LAD
4143 4143 Daniel Hudson 30 hudsoda01 2017 PIT NL 1.922905128 0.075 P 3 1 PIT ARI 2017 2017 LAD
4208 4208 Rocky Gale 29 galero01 2017 SDP NL 0.102709403 -0.085 C 0 1 SDP   2015 2017 LAD
4280 4280 Mike Freeman 29 freemmi01 2017 SEA AL 0.321224955 -0.51 SS, 1B, 2B, 3B, P 0 1 SEA ARI 2016 2017 LAD
4334 4334 Jedd Gyorko 28 gyorkje01 2017 STL NL 4.737306843 3.13 3B, 1B, 2B, LF 15 1 STL SDP 2016 2019 LAD
4372 4372 Breyvic Valera 25 valerbr01 2017 STL NL 0.108337579 -0.225 2B 0 1 STL   2017 2017 LAD
4426 4426 Adam Kolarek 28 kolarad01 2017 TBR AL 0.228698274 -0.23 P 0 1 TBD   2017 2019 LAD
4436 4436 Yu Darvish 30 darviyu01 2017 TEX AL 3.948936792 3.055 P 15 1 TEX   2012 2017 LAD
4490 4490 Russell Martin 34 martiru01 2017 TOR AL 3.453507341 1.835 C, 3B 10 1 TOR PIT 2015 2018 LAD
4559 4559 Ryan Madson 36 madsory01 2017 WSN NL 0.694855134 0.95 P 4 2 WSN OAK 2017 2018 LAD
4617 4617 A.J. Pollock 28 polloaj01 2016 ARI NL 0.450219372 0.445 CF 2 1 ARI   2012 2018 LAD
4652 4652 Bud Norris 31 norribu01 2016 ATL NL 1.89875543 1.066583851 P 6 1 ATL SDP 2016 2016 LAD
4658 4658 Matt Kemp 31 kempma01 2016 ATL NL 2.378019735 0.19621118 RF, LF 4 2 ATL SDP 2016 2017 LAD
4702 4702 Manny Machado 23 machama01 2016 BAL AL 6.660287081 6.61 3B, SS 30 1 BAL   2012 2018 LAD
4776 4776 Joe Kelly 28 kellyjo05 2016 BOS AL 1.385569442 0.135 P 2 1 BOS STL 2014 2018 LAD
4910 4910 Tony Cingrani 26 cingrto01 2016 CIN NL 2.340998193 0.42 P 5 1 CIN   2012 2017 LAD
5108 5108 Tyler White 25 whitety01 2016 HOU AL 2.589872189 -0.155 1B, 3B, 2B, P 3 1 HOU   2016 2019 LAD
5116 5116 Josh Fields 30 fieldjo03 2016 HOU AL 0.313630931 -0.085 P 0 1 HOU   2013 2016 LAD
5157 5157 Scott Alexander 26 alexasc02 2016 KCR AL 0.46685256 0.245 P 1 1 KCR   2015 2017 LAD
5381 5381 Brian Dozier 29 doziebr01 2016 MIN AL 6.446517613 6.31 2B 26 1 MIN   2012 2018 LAD
5410 5410 JT Chargois 25 chargjt01 2016 MIN AL 0.617715844 0.24 P 1 1 MIN   2016 2016 LAD
5424 5424 Casey Fien 32 fienca01 2016 MIN AL 0.441283082 -0.375 P 0 1 MIN DET 2012 2016 LAD
5433 5433 Curtis Granderson 35 grandcu01 2016 NYM NL 6.338743094 2.955 RF, CF, LF 17 1 NYM NYY 2014 2017 LAD
5452 5452 Travis d'Arnaud 27 darnatr01 2016 NYM NL 2.763812155 0.185 C 4 1 NYM   2013 2019 LAD
5533 5533 Rich Hill 36 hillri01 2016 OAK AL 2.178144157 2.79 P 11 1 OAK BOS 2016 2016 LAD
5536 5536 Josh Reddick 29 reddijo01 2016 OAK AL 2.63021007 1.915 RF 9 1 OAK BOS 2012 2016 LAD
5548 5548 Zach Neal 27 nealza01 2016 OAK AL 1.617891458 0.595 P 4 1 OAK   2016 2017 LAD
5564 5564 Max Muncy 25 muncyma01 2016 OAK AL 1.286095365 -0.18 2B, RF, LF, 3B 1 1 OAK   2015 2016 LAD
5576 5576 Brett Eibner 27 eibnebr01 2016 OAK AL 1.189396465 -0.6 CF, RF, LF 0 2 OAK KCR 2016 2016 LAD
5591 5591 Carlos Ruiz 37 ruizca01 2016 PHI NL 1.9718161 0.895 C 6 1 PHI   2006 2016 LAD
5633 5633 David Freese 33 freesda01 2016 PIT NL 4.804040404 1.765 3B, 1B, 2B 12 1 PIT ANA 2016 2018 LAD
5646 5646 Tony Watson 31 watsoto01 2016 PIT NL 2.422709131 0.6 P 5 1 PIT   2011 2017 LAD
5716 5716 Brandon Morrow 31 morrobr01 2016 SDP NL 0.444557982 0.22 P 1 1 SDP TOR 2015 2016 LAD
5757 5757 Franklin Gutierrez 33 gutiefr01 2016 SEA AL 2.646565624 0.66 RF, LF 6 1 SEA CLE 2009 2016 LAD
5774 5774 Mike Freeman 28 freemmi01 2016 SEA AL 0.121573686 0.145 2B, SS, LF, RF 1 2 SEA ARI 2016 2017 LAD
5781 5781 Chris Taylor 25 tayloch03 2016 SEA AL 0.028055466 0.01 3B, 2B, SS 0 1 SEA   2014 2016 LAD
5786 5786 Pat Venditte 31 vendipa01 2016 SEA AL 0.240919186 -0.17 P 0 2 SEA TOR 2016 2016 LAD
5817 5817 Sergio Romo 33 romose01 2016 SFG NL 1.039627936 0.415 P 3 1 SFG   2008 2016 LAD
5847 5847 Jedd Gyorko 27 gyorkje01 2016 STL NL 4.307953197 2.6 2B, 3B, SS, 1B 14 1 STL SDP 2016 2019 LAD
5884 5884 Logan Forsythe 29 forsylo01 2016 TBR AL 5.461883408 3.035 2B 15 1 TBD SDP 2014 2016 LAD
5936 5936 Yu Darvish 29 darviyu01 2016 TEX AL 2.75987854 2.69 P 13 1 TEX   2012 2017 LAD
5989 5989 Russell Martin 33 martiru01 2016 TOR AL 5.00483871 2.69 C, 2B, 3B 15 1 TOR PIT 2015 2018 LAD
6007 6007 Jesse Chavez 32 chaveje01 2016 TOR AL 1.312268349 -0.125 P 1 1 TOR OAK 2016 2016 LAD
6075 6075 A.J. Pollock 27 polloaj01 2015 ARI NL 6.563645536 7.02 CF 29 1 ARI   2012 2018 LAD
6129 6129 Alex Wood 24 woodal02 2015 ATL NL 3.264222002 2.38 P 12 1 ATL   2013 2015 LAD
6133 6133 Jim Johnson 32 johnsji04 2015 ATL NL 1.976610505 1.05 P 6 1 ATL DET 2015 2015 LAD
6140 6140 Luis Avilan 25 avilalu01 2015 ATL NL 1.478295342 0.39 P 3 1 ATL   2012 2015 LAD
6163 6163 Alberto Callaspo 32 callaal01 2015 ATL NL 1.251139951 -0.43 3B, 2B 1 1 ATL OAK 2015 2015 LAD
6168 6168 Ian Thomas 28 thomaia01 2015 ATL NL 0.124479683 -0.065 P 0 1 ATL   2014 2015 LAD
6184 6184 Manny Machado 22 machama01 2015 BAL AL 6.909607352 6.85 3B, SS 30 1 BAL   2012 2018 LAD
6242 6242 Joe Kelly 27 kellyjo05 2015 BOS AL 3.752481668 1.085 P 8 1 BOS STL 2014 2018 LAD
6347 6347 Trayce Thompson 24 thomptr01 2015 CHW AL 1.294856954 1.445 RF, LF, CF 6 1 CHW   2015 2015 LAD
6368 6368 Micah Johnson 24 johnsmi04 2015 CHW AL 1.093434761 -0.56 2B 0 1 CHW   2015 2015 LAD
6412 6412 Tony Cingrani 25 cingrto01 2015 CIN NL 1.180207514 -0.305 P 0 1 CIN   2012 2017 LAD
6468 6468 Zach Walters 25 walteza01 2015 CLE AL 0.285949055 -0.482981366 LF, 2B, 3B, SS, RF 0 1 CLE WSN 2014 2015 LAD
6590 6590 Josh Fields 29 fieldjo03 2015 HOU AL 1.44634687 0.87 P 4 1 HOU   2013 2016 LAD
6600 6600 Scott Kazmir 31 kazmisc01 2015 HOU AL 2.060343152 -0.055 P 2 2 HOU OAK 2015 2015 LAD
6648 6648 Louis Coleman 29 colemlo01 2015 KCR AL 0.069542119 0.07 P 0 1 KCR   2011 2015 LAD
6650 6650 Scott Alexander 25 alexasc02 2015 KCR AL 0.093321037 0.01 P 0 1 KCR   2015 2017 LAD
6778 6778 Mat Latos 27 latosma01 2015 MIA NL 2.532956388 1.105 P 7 1 FLA CIN 2015 2015 LAD
6867 6867 Brian Dozier 28 doziebr01 2015 MIN AL 6.808737702 2.855 2B 20 1 MIN   2012 2018 LAD
6884 6884 Casey Fien 31 fienca01 2015 MIN AL 2.077331901 0.895 P 6 1 MIN DET 2012 2016 LAD
6911 6911 Curtis Granderson 34 grandcu01 2015 NYM NL 6.82824098 5.14 RF, CF 25 1 NYM NYY 2014 2017 LAD
6918 6918 Travis d'Arnaud 26 darnatr01 2015 NYM NL 2.683238391 2.5 C 11 1 NYM   2013 2019 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
);