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,914 rows where next_franch = "BAL"

✎ 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
295 295 Jose Rondon 25 rondojo02 2019 CHW AL 1.529411765 -0.712594937 2B, SS, 3B, LF, 1B, P 0 1 CHW SDP 2018 2019 BAL
837 837 Ryan Eades 27 eadesry01 2019 MIN AL 0.064145451 0.117169811 P 0 1 MIN   2019 2019 BAL
903 903 Keon Broxton 29 broxtke01 2019 NYM NL 0.526369863 -0.550188679 CF, LF, RF 0 1 NYM MIL 2019 2019 BAL
995 995 Aaron Brooks 29 brookaa01 2019 OAK AL 1.063475631 -0.076415094 P 1 1 OAK KCR 2015 2019 BAL
1227 1227 Tayler Scott 27 scottta02 2019 SEA AL 0.173759928 -0.183396226 P 0 1 SEA   2019 2019 BAL
1228 1228 Shawn Armstrong 28 armstsh01 2019 SEA AL 0.11193408 -0.219056604 P 0 1 SEA CLE 2018 2019 BAL
1294 1294 Ty Blach 28 blachty01 2019 SFG NL 0.121795013 -0.259811321 P 0 1 SFG   2016 2019 BAL
1652 1652 Rio Ruiz 24 ruizri01 2018 ATL NL 0.146885024 -0.01 3B 0 1 ATL   2016 2018 BAL
1665 1665 Evan Phillips 23 phillev01 2018 ATL NL 0.108609772 -0.17 P 0 1 ATL   2018 2018 BAL
1848 1848 Jose Rondon 24 rondojo02 2018 CHW AL 1.025785124 0.31 SS, 3B, 2B, 1B 2 1 CHW SDP 2018 2019 BAL
1897 1897 Mason Williams 26 willima10 2018 CIN NL 1.299168505 0.04 RF, CF, LF 2 1 CIN NYY 2018 2018 BAL
2262 2262 Breyvic Valera 26 valerbr01 2018 LAD NL 0.327302905 -0.139141104 2B, 3B, SS, RF 0 1 LAD STL 2018 2018 BAL
2277 2277 Dan Straily 29 straida01 2018 MIA NL 3.46662217 0.674161491 P 7 1 FLA CIN 2017 2018 BAL
2328 2328 Jonathan Villar 27 villajo01 2018 MIL NL 2.735756551 1.073374233 2B, SS 8 1 MIL HOU 2016 2018 BAL
2524 2524 Jace Peterson 28 peterja01 2018 NYY AL 0.102096335 -0.085 3B, LF, 2B, RF, SS, P 0 1 NYY ATL 2018 2018 BAL
2570 2570 Aaron Brooks 28 brookaa01 2018 OAK AL 0.039472261 0.04 P 0 1 OAK KCR 2015 2019 BAL
2575 2575 Josh Lucas 27 lucasjo02 2018 OAK AL 0.281484118 -0.1 P 0 1 OAK STL 2018 2018 BAL
2750 2750 Shawn Armstrong 27 armstsh01 2018 SEA AL 0.455194944 0.42 P 2 1 SEA CLE 2018 2019 BAL
2756 2756 John Andreoli 28 andrejo03 2018 SEA AL 0.057378401 0.25 LF, RF, CF 1 1 SEA   2018 2018 BAL
2796 2796 Ty Blach 27 blachty01 2018 SFG NL 3.266742468 0.28 P 6 1 SFG   2016 2019 BAL
2931 2931 Jesus Sucre 30 sucreje01 2018 TBR AL 1.860359631 -0.805 C, P 0 1 TBD SEA 2017 2018 BAL
2961 2961 Renato Nunez 24 nunezre01 2018 TEX AL 0.387044271 0.16 3B, LF 1 1 TEX OAK 2018 2018 BAL
2973 2973 Hanser Alberto 25 alberha01 2018 TEX AL 0.283203125 -0.245 SS, 2B, 3B 0 1 TEX   2015 2018 BAL
3021 3021 Dwight Smith Jr. 25 smithdw02 2018 TOR AL 0.718770654 -0.01 LF, RF 1 1 TOR   2017 2018 BAL
3097 3097 Pedro Severino 24 severpe01 2018 WSN NL 2.077349924 -0.885 C 0 1 WSN   2015 2018 BAL
3169 3169 Rio Ruiz 23 ruizri01 2017 ATL NL 1.70240923 -0.23 3B, 1B 2 1 ATL   2016 2018 BAL
3420 3420 Asher Wojciechowski 28 wojcias01 2017 CIN NL 1.698703428 -0.405 P 1 1 CIN HOU 2017 2017 BAL
3630 3630 Nate Karns 29 karnsna01 2017 KCR AL 1.238748945 0.685 P 4 1 KCR SEA 2017 2017 BAL
3776 3776 Dan Straily 28 straida01 2017 MIA NL 5.180324972 1.24 P 11 1 FLA CIN 2017 2018 BAL
3828 3828 Jonathan Villar 26 villajo01 2017 MIL NL 4.345763877 -0.155 2B, CF 6 1 MIL HOU 2016 2018 BAL
3855 3855 Andrew Susac 27 susacan01 2017 MIL NL 0.11960818 -0.22 C 0 1 MIL SFG 2016 2017 BAL
3952 3952 Sean Gilmartin 27 gilmase01 2017 NYM NL 0.071639468 -0.035 P 0 1 NYM   2015 2017 BAL
4083 4083 Jeremy Hellickson 30 hellije01 2017 PHI NL 3.180410445 0.8 P 6 1 PHI ARI 2016 2017 BAL
4214 4214 Luis Sardinas 24 sardilu01 2017 SDP NL 0.544359837 -0.425 2B, SS, 3B, P 0 1 SDP SEA 2016 2017 BAL
4233 4233 Danny Valencia 32 valenda01 2017 SEA AL 4.7238964 0.295 1B, RF, 3B 7 1 SEA OAK 2017 2017 BAL
4287 4287 Ty Blach 26 blachty01 2017 SFG NL 4.5375299 1.88 P 12 1 SFG   2016 2019 BAL
4385 4385 Alex Cobb 29 cobbal01 2017 TBR AL 4.895408193 2.275 P 13 1 TBD   2011 2017 BAL
4387 4387 Tim Beckham 27 beckhti01 2017 TBR AL 3.268539693 1.345 SS, 2B, 3B 8 1 TBD   2013 2017 BAL
4394 4394 Colby Rasmus 30 rasmuco01 2017 TBR AL 1.222149624 1.18 LF, RF, CF 5 1 TBD HOU 2017 2017 BAL
4398 4398 Jesus Sucre 29 sucreje01 2017 TBR AL 1.819013394 0.65 C, P 4 1 TBD SEA 2017 2018 BAL
4433 4433 Andrew Cashner 30 cashnan01 2017 TEX AL 4.804059357 3.42 P 17 1 TEX FLA 2017 2017 BAL
4464 4464 Jhan Marinez 28 marinjh01 2017 TEX AL 0.124598901 0.085 P 0 3 TEX PIT 2017 2017 BAL
4514 4514 Dwight Smith Jr. 24 smithdw02 2017 TOR AL 0.274388254 0.11 LF, CF, RF 1 1 TOR   2017 2018 BAL
4582 4582 Pedro Severino 23 severpe01 2017 WSN NL 0.307350427 -0.21 C 0 1 WSN   2015 2018 BAL
4597 4597 Welington Castillo 29 castiwe01 2016 ARI NL 4.47283159 1.7 C 11 1 ARI SEA 2015 2016 BAL
4606 4606 Michael Bourn 33 bournmi01 2016 ARI NL 3.503881201 0.06 CF, LF, RF 5 1 ARI ATL 2016 2016 BAL
4683 4683 Rio Ruiz 22 ruizri01 2016 ATL NL 0.069071113 0.08552795 3B 0 1 ATL   2016 2018 BAL
4971 4971 Tommy Hunter 29 hunteto02 2016 CLE AL 0.604598477 0.246521739 P 2 1 CLE CHC 2016 2016 BAL
5030 5030 Miguel Castro 21 castrmi01 2016 COL NL 0.534626272 -0.12 P 0 1 COL TOR 2015 2016 BAL
5181 5181 Johnny Giavotella 28 giavojo01 2016 LAA AL 3.535880399 0.305 2B 6 1 ANA KCR 2015 2016 BAL
5214 5214 Craig Gentry 32 gentrcr01 2016 LAA AL 0.375747508 -0.305 LF, CF 0 1 ANA OAK 2016 2016 BAL
5331 5331 Jonathan Villar 25 villajo01 2016 MIL NL 6.846662031 3.445 SS, 3B, 2B 20 1 MIL HOU 2016 2018 BAL
5361 5361 Andrew Susac 26 susacan01 2016 MIL NL 0.191585535 0.045 C 0 1 MIL SFG 2016 2017 BAL
5464 5464 Gabriel Ynoa 23 ynoaga01 2016 NYM NL 0.449808287 0.05 P 1 1 NYM   2016 2016 BAL
5468 5468 Logan Verrett 26 verrelo01 2016 NYM NL 2.208149773 -0.635 P 1 1 NYM TEX 2015 2016 BAL
5472 5472 Sean Gilmartin 26 gilmase01 2016 NYM NL 0.404554847 -0.3 P 0 1 NYM   2015 2017 BAL
5498 5498 Richard Bleier 29 bleieri01 2016 NYY AL 0.484975043 0.455 P 2 1 NYY   2016 2016 BAL
5582 5582 Jeremy Hellickson 29 hellije01 2016 PHI NL 5.318189635 3.335 P 18 1 PHI ARI 2016 2017 BAL
5598 5598 Alec Asher 24 asheral01 2016 PHI NL 0.749358696 0.55 P 3 1 PHI   2015 2016 BAL
5705 5705 Luis Sardinas 23 sardilu01 2016 SDP NL 1.222983658 0.395 SS, 1B, 2B, 3B, LF, P 3 2 SDP SEA 2016 2017 BAL
5708 5708 Edwin Jackson 32 jacksed01 2016 SDP NL 2.082094192 0.1 P 3 2 SDP FLA 2016 2016 BAL
5753 5753 Seth Smith 33 smithse01 2016 SEA AL 4.096098033 0.7 RF, LF 8 1 SEA SDP 2015 2016 BAL
5758 5758 Wade Miley 29 mileywa01 2016 SEA AL 3.076714293 0.645 P 6 1 SEA BOS 2016 2016 BAL
5763 5763 Vidal Nuno III 28 nunovi01 2016 SEA AL 1.697794722 0.5 P 4 1 SEA ARI 2015 2016 BAL
5821 5821 Ty Blach 25 blachty01 2016 SFG NL 0.355959565 0.595 P 2 1 SFG   2016 2019 BAL
5830 5830 Ruben Tejada 26 tejadru01 2016 SFG NL 0.373622648 0.04 3B, SS, 2B, P 1 2 SFG STL 2016 2016 BAL
5890 5890 Steve Pearce 33 pearcst01 2016 TBR AL 2.23484471 1.945 1B, 2B, LF, RF, 3B 8 1 TBD BAL 2016 2016 BAL
5896 5896 Tim Beckham 26 beckhti01 2016 TBR AL 2.071084537 1.12 SS, 2B, 3B, 1B 6 1 TBD   2013 2017 BAL
5925 5925 Alex Cobb 28 cobbal01 2016 TBR AL 0.622173194 -0.44 P 0 1 TBD   2011 2017 BAL
5968 5968 Drew Stubbs 31 stubbdr01 2016 TEX AL 0.238997857 -0.02 RF, CF, LF 0 2 TEX ATL 2016 2016 BAL
5972 5972 Hanser Alberto 23 alberha01 2016 TEX AL 0.554475029 -0.29 3B, SS, 2B, 1B 0 1 TEX   2015 2018 BAL
6055 6055 Pedro Severino 22 severpe01 2016 WSN NL 0.33819242 0.65 C 2 1 WSN   2015 2018 BAL
6086 6086 Welington Castillo 28 castiwe01 2015 ARI NL 2.955103413 1.17 C 7 3 ARI SEA 2015 2016 BAL
6330 6330 Junior Lake 25 lakeju01 2015 CHC NL 0.617551091 -0.3 RF, LF, CF 0 1 CHC   2013 2015 BAL
6516 6516 Miguel Castro 20 castrmi01 2015 COL NL 0.118815883 -0.155 P 0 2 COL TOR 2015 2016 BAL
6517 6517 Jorge Rondon 27 rondojo01 2015 COL NL 0.01560974 -0.175 P 0 1 COL STL 2015 2015 BAL
6652 6652 Francisco Pena 25 penafr01 2015 KCR AL 0.066633842 -0.035 C 0 1 KCR   2014 2015 BAL
6668 6668 Johnny Giavotella 27 giavojo01 2015 LAA AL 4.878686327 1.205 2B, SS 12 1 ANA KCR 2015 2016 BAL
6820 6820 Gerardo Parra 28 parrage01 2015 MIL NL 3.564699702 2.26 RF, LF, CF 12 1 MIL ARI 2014 2015 BAL
6893 6893 Brian Duensing 32 duensbr01 2015 MIN AL 1.574596803 -0.11 P 2 1 MIN   2009 2015 BAL
6928 6928 Sean Gilmartin 25 gilmase01 2015 NYM NL 1.452620641 1.04 P 5 1 NYM   2015 2017 BAL
6934 6934 Logan Verrett 25 verrelo01 2015 NYM NL 1.132571544 0.455 P 3 2 NYM TEX 2015 2016 BAL
7061 7061 Aaron Brooks 25 brookaa01 2015 OAK AL 1.566744815 -0.49 P 0 2 OAK KCR 2015 2019 BAL
7115 7115 Alec Asher 23 asheral01 2015 PHI NL 0.834938739 -0.615 P 0 1 PHI   2015 2016 BAL
7131 7131 Pedro Alvarez 28 alvarpe01 2015 PIT NL 4.790243902 0.335 1B 9 1 PIT   2010 2015 BAL
7140 7140 Vance Worley 27 worleva01 2015 PIT NL 1.868645577 0.27 P 4 1 PIT MIN 2014 2015 BAL
7191 7191 Odrisamer Despaigne 28 despaod01 2015 SDP NL 3.173288895 -0.865 P 2 1 SDP   2014 2015 BAL
7214 7214 Seth Smith 32 smithse01 2015 SEA AL 4.293481821 1.805 LF, RF 12 1 SEA SDP 2015 2016 BAL
7224 7224 Mark Trumbo 29 trumbma01 2015 SEA AL 3.429086145 0.635 RF, 1B, LF 7 2 SEA ARI 2015 2015 BAL
7228 7228 Vidal Nuno III 27 nunovi01 2015 SEA AL 2.117264355 0.575 P 5 2 SEA ARI 2015 2016 BAL
7380 7380 Tim Beckham 25 beckhti01 2015 TBR AL 2.137497934 -0.035 2B, SS, 3B 3 1 TBD   2013 2017 BAL
7408 7408 Yovani Gallardo 29 gallayo01 2015 TEX AL 5.165424154 3.385 P 18 1 TEX MIL 2015 2015 BAL
7432 7432 Hanser Alberto 22 alberha01 2015 TEX AL 0.978426602 0.345 2B, SS, 3B 3 1 TEX   2015 2018 BAL
7551 7551 Pedro Severino 21 severpe01 2015 WSN NL 0.040298767 0.01 C 0 1 WSN   2015 2018 BAL
7594 7594 Nolan Reimold 30 reimono01 2014 ARI NL 0.18125 0.08 RF, LF 0 2 ARI TOR 2014 2014 BAL
7710 7710 Andrew Miller 29 millean01 2014 BOS AL 1.473312076 1.095 P 5 1 BOS FLA 2011 2014 BAL
7742 7742 Kelly Johnson 32 johnske05 2014 BOS AL 0.23364486 -0.185 3B, 1B, 2B, LF, RF 0 2 BOS NYY 2014 2014 BAL
7743 7743 Ryan Lavarnway 26 lavarry01 2014 BOS AL 0.093457944 -0.25 1B 0 1 BOS   2011 2014 BAL
7768 7768 Wesley Wright 29 wrighwe01 2014 CHC NL 1.493857603 0.545 P 4 1 CHC TBD 2014 2014 BAL
7778 7778 Junior Lake 24 lakeju01 2014 CHC NL 3.279223032 -0.9 LF, CF, RF 2 1 CHC   2013 2015 BAL

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