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,173 rows where prev_franch = "WSN"

✎ 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
29 29 Greg Holland 33 hollagr01 2019 ARI NL 1.398574851 0.0 P 2 1 ARI WSN 2019 2019  
103 103 Pedro Severino 25 severpe01 2019 BAL AL 3.269090909 0.886415094 C 6 1 BAL WSN 2019 2019  
183 183 Sandy Leon 30 leonsa01 2019 BOS AL 1.710186061 -0.346415094 C, 1B 1 1 BOS WSN 2015 2019  
215 215 Brandon Kintzler 34 kintzbr01 2019 CHC NL 1.897989791 1.21245283 P 6 1 CHC WSN 2018 2019  
231 231 Tim Collins 29 colliti01 2019 CHC NL 0.241612568 0.096792453 P 1 1 CHC WSN 2019 2019  
252 252 Lucas Giolito 24 giolilu01 2019 CHW AL 5.336638701 5.598227848 P 24 1 CHW WSN 2017 2019  
261 261 Reynaldo Lopez 25 lopezre01 2019 CHW AL 5.288221184 1.209873418 P 11 1 CHW WSN 2017 2019  
273 273 Kelvin Herrera 29 herreke01 2019 CHW AL 1.506084708 0.025632911 P 2 1 CHW WSN 2019 2019  
305 305 Tanner Roark 32 roarkta01 2019 CIN NL 3.125062659 1.874716981 P 10 1 CIN WSN 2019 2019 OAK
367 367 Oliver Perez 37 perezol01 2019 CLE AL 1.458787339 0.514528302 P 4 1 CLE WSN 2018 2019  
371 371 Jefry Rodriguez 25 rodrije01 2019 CLE AL 1.234653169 0.387169811 P 3 1 CLE WSN 2019 2019  
449 449 Mark Reynolds 35 reynoma01 2019 COL NL 1.607527802 -0.932264151 1B, P 0 1 COL WSN 2019 2019  
459 459 Jordan Zimmermann 33 zimmejo02 2019 DET AL 3.26641731 0.487025316 P 5 1 DET WSN 2016 2019  
486 486 Carlos Torres 36 torreca01 2019 DET AL 0.096801121 -0.010253165 P 0 1 DET WSN 2019 2019  
488 488 Trevor Rosenthal 29 rosentr01 2019 DET AL 0.266668472 -0.11278481 P 0 2 DET WSN 2019 2019  
519 519 Brad Peacock 31 peacobr01 2019 HOU AL 2.63822673 1.380566038 P 7 1 HOU WSN 2013 2019  
766 766 Gio Gonzalez 33 gonzagi01 2019 MIL NL 2.306003645 1.207358491 P 7 1 MIL WSN 2018 2019  
775 775 Matt Albers 36 alberma01 2019 MIL NL 2.049857145 -0.015283019 P 3 1 MIL WSN 2018 2019  
986 986 Blake Treinen 31 treinbl01 2019 OAK AL 2.281112189 -0.331132075 P 2 1 OAK WSN 2017 2019  
1008 1008 Bryce Harper 26 harpebr03 2019 PHI NL 6.632846088 4.284339623 RF 23 1 PHI WSN 2019 2019  
1069 1069 Felipe Vazquez 27 riverfe01 2019 PIT NL 2.374452723 2.526792453 P 11 1 PIT WSN 2016 2019  
1130 1130 Craig Stammen 35 stammcr01 2019 SDP NL 3.190509031 0.590943396 P 6 1 SDP WSN 2017 2019  
1181 1181 Tommy Milone 32 milonto01 2019 SEA AL 3.426118197 0.703018868 P 7 1 SEA WSN 2019 2019  
1189 1189 Austin Adams 28 adamsau02 2019 SEA AL 1.10407706 0.713207547 P 4 2 SEA WSN 2019 2019  
1257 1257 Mark Melancon 34 melanma01 2019 SFG NL 1.316289401 0.54509434 P 4 1 SFG WSN 2017 2019 ATL
1258 1258 Trevor Gott 26 gotttr01 2019 SFG NL 1.641998791 0.53490566 P 4 1 SFG WSN 2019 2019  
1280 1280 Kyle Barraclough 29 barraky01 2019 SFG NL 0.298222956 -0.045849057 P 0 2 SFG WSN 2019 2019  
1326 1326 Matt Wieters 33 wietema01 2019 STL NL 1.850741064 0.091698113 C 3 1 STL WSN 2019 2019  
1439 1439 David Carpenter 33 carpeda01 2019 TEX AL 0.067840076 -0.040754717 P 0 1 TEX WSN 2019 2019  
1498 1498 Jimmy Cordero 27 cordeji01 2019 TOR AL 0.034495847 -0.056037736 P 0 1 TOR WSN 2019 2019 CHW
1751 1751 Sandy Leon 29 leonsa01 2018 BOS AL 2.659025788 0.0 C 4 1 BOS WSN 2015 2019  
1795 1795 Daniel Murphy 33 murphda08 2018 CHC NL 1.401986755 0.31803681 2B, 1B 3 2 CHC WSN 2018 2018 COL
1819 1819 Brandon Kintzler 33 kintzbr01 2018 CHC NL 0.573495288 -0.422392638 P 0 2 CHC WSN 2018 2019  
1822 1822 Reynaldo Lopez 24 lopezre01 2018 CHW AL 5.33266513 2.675 P 15 1 CHW WSN 2017 2019  
1842 1842 Lucas Giolito 23 giolilu01 2018 CHW AL 4.873208379 -0.665 P 4 1 CHW WSN 2017 2019  
1938 1938 Oliver Perez 36 perezol01 2018 CLE AL 0.985553993 1.12 P 5 1 CLE WSN 2018 2019  
2026 2026 Jordan Zimmermann 32 zimmejo02 2018 DET AL 3.68868651 0.745 P 7 1 DET WSN 2016 2019  
2087 2087 Brad Peacock 30 peacobr01 2018 HOU AL 1.939483148 0.665 P 5 1 HOU WSN 2013 2019  
2129 2129 Brian Goodwin 27 goodwbr01 2018 KCR AL 0.969707002 0.42 CF, LF, RF 2 2 KCR WSN 2018 2018 ANA
2255 2255 Ryan Madson 37 madsory01 2018 LAD NL 0.214921338 0.00993865 P 0 2 LAD WSN 2018 2018  
2311 2311 Jacob Turner 27 turneja01 2018 MIA NL 0.156262583 -0.402484472 P 0 1 FLA WSN 2018 2018 DET
2342 2342 Gio Gonzalez 32 gonzagi01 2018 MIL NL 0.689439024 0.591349693 P 3 2 MIL WSN 2018 2019  
2370 2370 Matt Albers 35 alberma01 2018 MIL NL 1.138143776 -1.257239264 P 0 1 MIL WSN 2018 2019  
2447 2447 Jerry Blevins 34 blevije01 2018 NYM NL 1.303949018 0.03 P 2 1 NYM WSN 2015 2018 ATL
2475 2475 Jose Lobaton 33 lobatjo01 2018 NYM NL 0.565708419 -0.405 C 0 1 NYM WSN 2018 2018  
2516 2516 A.J. Cole 26 coleaj01 2018 NYY AL 0.885545188 -0.13 P 1 2 NYY WSN 2018 2018 CLE
2534 2534 Blake Treinen 30 treinbl01 2018 OAK AL 3.579078864 3.92 P 17 1 OAK WSN 2017 2019  
2543 2543 Edwin Jackson 34 jacksed01 2018 OAK AL 2.534822616 1.14 P 7 1 OAK WSN 2018 2018 TOR
2555 2555 Shawn Kelley 34 kellesh01 2018 OAK AL 0.510501394 0.485 P 2 2 OAK WSN 2018 2018 TEX
2639 2639 Felipe Vazquez 26 riverfe01 2018 PIT NL 2.850599367 1.81621118 P 10 1 PIT WSN 2016 2019  
2664 2664 Enny Romero 27 romeren01 2018 PIT NL 0.078090256 0.050310559 P 0 2 PIT WSN 2018 2018 KCR
2685 2685 Craig Stammen 34 stammcr01 2018 SDP NL 2.988231525 1.835 P 10 1 SDP WSN 2017 2019  
2779 2779 Marc Rzepczynski 32 rzepcma01 2018 SEA AL 0.240219777 -0.485 P 0 1 SEA WSN 2017 2018 CLE
2805 2805 Mark Melancon 33 melanma01 2018 SFG NL 1.416504426 0.175 P 3 1 SFG WSN 2017 2019 ATL
2870 2870 Matt Adams 29 adamsma01 2018 STL NL 0.592542142 -0.29 1B, LF, RF 0 2 STL WSN 2018 2018 WSN
2888 2888 Wilson Ramos 30 ramoswi01 2018 TBR AL 2.959663049 1.75 C 9 1 TBD WSN 2017 2018 PHI
3260 3260 Sandy Leon 28 leonsa01 2017 BOS AL 2.764528899 0.59 C 6 1 BOS WSN 2015 2019  
3357 3357 Lucas Giolito 22 giolilu01 2017 CHW AL 1.321937491 0.89 P 4 1 CHW WSN 2017 2019  
3358 3358 Reynaldo Lopez 23 lopezre01 2017 CHW AL 1.404844471 0.33 P 3 1 CHW WSN 2017 2019  
3529 3529 Jordan Zimmermann 31 zimmejo02 2017 DET AL 4.738180427 0.69 P 8 1 DET WSN 2016 2019  
3551 3551 Matt den Dekker 29 dendema01 2017 DET AL 0.075718016 0.015 RF, LF 0 1 DET WSN 2017 2017 NYM
3573 3573 Brad Peacock 29 peacobr01 2017 HOU AL 3.519431892 3.34 P 15 1 HOU WSN 2013 2019  
3666 3666 Yusmeiro Petit 32 petityu01 2017 LAA AL 2.855350326 1.875 P 10 1 ANA WSN 2017 2017 OAK
3673 3673 Yunel Escobar 34 escobyu01 2017 LAA AL 3.651354924 0.505 3B 7 1 ANA WSN 2016 2017  
3679 3679 Ben Revere 29 reverbe01 2017 LAA AL 2.951751487 0.065 LF, CF 5 1 ANA WSN 2017 2017  
3716 3716 Danny Espinosa 30 espinda01 2017 LAA AL 2.434236616 -1.15 2B, 3B, 1B, SS 0 1 ANA WSN 2017 2017 SEA
3794 3794 Tyler Moore 30 moorety01 2017 MIA NL 1.98549747 -0.265 1B, LF, RF 2 1 FLA WSN 2017 2017  
3882 3882 Matt Belisle 37 belisma01 2017 MIN AL 2.261301122 0.35 P 4 1 MIN WSN 2017 2017 CLE
3927 3927 Jerry Blevins 33 blevije01 2017 NYM NL 1.816968608 1.14 P 6 1 NYM WSN 2015 2018 ATL
4029 4029 Blake Treinen 29 treinbl01 2017 OAK AL 1.833601809 1.21 P 6 2 OAK WSN 2017 2019  
4132 4132 Felipe Vazquez 25 riverfe01 2017 PIT NL 2.784498452 2.435 P 11 1 PIT WSN 2016 2019  
4180 4180 Craig Stammen 33 stammcr01 2017 SDP NL 2.749006483 1.125 P 8 1 SDP WSN 2017 2019  
4245 4245 Marc Rzepczynski 31 rzepcma01 2017 SEA AL 1.21008581 0.1 P 2 1 SEA WSN 2017 2018 CLE
4294 4294 Denard Span 33 spande01 2017 SFG NL 5.402302801 -0.02 CF 7 1 SFG WSN 2016 2017 TBD
4305 4305 Mark Melancon 32 melanma01 2017 SFG NL 1.162628382 0.275 P 2 1 SFG WSN 2017 2019 ATL
4325 4325 Chris Marrero 28 marrech01 2017 SFG NL 0.408661282 -0.535 LF 0 1 SFG WSN 2017 2017  
4379 4379 Steven Souza Jr. 28 souzast01 2017 TBR AL 5.845475335 3.925 RF, CF 19 1 TBD WSN 2015 2017 ARI
4405 4405 Wilson Ramos 29 ramoswi01 2017 TBR AL 2.122182293 0.165 C 3 1 TBD WSN 2017 2018 PHI
4431 4431 Xavier Cedeno 30 cedenxa01 2017 TBR AL 0.153714435 -0.74 P 0 1 TBD WSN 2015 2017 CHW
4534 4534 Mat Latos 29 latosma01 2017 TOR AL 0.399245858 -0.235 P 0 1 TOR WSN 2017 2017  
4759 4759 Sandy Leon 27 leonsa01 2016 BOS AL 2.608294931 2.495 C 10 1 BOS WSN 2015 2019  
4927 4927 Abel De Los Santos 23 delosab01 2016 CIN NL 0.108291073 -0.155 P 0 1 CIN WSN 2016 2016  
5054 5054 Jordan Zimmermann 30 zimmejo02 2016 DET AL 2.913473027 0.910621118 P 7 1 DET WSN 2016 2019  
5099 5099 Doug Fister 32 fistedo01 2016 HOU AL 4.990421584 0.325 P 8 1 HOU WSN 2016 2016 BOS
5113 5113 Brad Peacock 28 peacobr01 2016 HOU AL 0.680547719 0.095 P 1 1 HOU WSN 2013 2019  
5174 5174 Yunel Escobar 33 escobyu01 2016 LAA AL 5.462790698 1.61 3B 12 1 ANA WSN 2016 2017  
5450 5450 Jerry Blevins 32 blevije01 2016 NYM NL 1.530091661 0.81 P 4 1 NYM WSN 2015 2018 ATL
5624 5624 Emmanuel Burriss 31 burriem01 2016 PHI NL 0.510833187 -0.62 2B, LF, SS, 1B 0 1 PHI WSN 2016 2016  
5656 5656 Felipe Vazquez 24 riverfe01 2016 PIT NL 0.9663472 0.13 P 2 2 PIT WSN 2016 2019  
5730 5730 Matt Thornton 39 thornma01 2016 SDP NL 0.351030756 -0.13 P 0 1 SDP WSN 2016 2016  
5803 5803 Denard Span 32 spande01 2016 SFG NL 6.26309544 1.225 CF 12 1 SFG WSN 2016 2017 TBD
5893 5893 Steven Souza Jr. 27 souzast01 2016 TBR AL 4.508221226 0.915 RF, CF 8 1 TBD WSN 2015 2017 ARI
5900 5900 Xavier Cedeno 29 cedenxa01 2016 TBR AL 1.585518728 0.72 P 4 1 TBD WSN 2015 2017 CHW
5932 5932 Ian Desmond 30 desmoia01 2016 TEX AL 6.472061975 3.11 CF, LF 21 1 TEX WSN 2016 2016 COL
6027 6027 Drew Storen 28 storedr01 2016 TOR AL 0.965620384 -0.365 P 0 1 TOR WSN 2016 2016 SEA
6280 6280 Sandy Leon 26 leonsa01 2015 BOS AL 1.195106246 -0.56 C, 3B 0 1 BOS WSN 2015 2019  
6308 6308 Edwin Jackson 31 jacksed01 2015 CHC NL 0.705824227 0.22 P 2 1 CHC WSN 2013 2015 ATL
6326 6326 Rafael Soriano 35 soriara01 2015 CHC NL 0.219663413 -0.205 P 0 1 CHC WSN 2015 2015  
6352 6352 Adam LaRoche 35 larocad01 2015 CHW AL 4.642301968 -0.99 1B, P 4 1 CHW WSN 2015 2015  
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

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