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,136 rows where prev_franch = "BOS"

✎ 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
41 41 Robby Scott 29 scottro02 2019 ARI NL 0.153556874 -0.056037736 P 0 1 ARI BOS 2019 2019  
44 44 Blake Swihart 27 swihabl01 2019 ARI NL 0.690124086 -0.738679245 LF, RF, C, 1B 0 2 ARI BOS 2019 2019  
250 250 Craig Kimbrel 31 kimbrcr01 2019 CHC NL 0.853329379 -0.769245283 P 0 1 CHC BOS 2019 2019  
253 253 Yoan Moncada 24 moncayo01 2019 CHW AL 5.392156863 4.880506329 3B 22 1 CHW BOS 2017 2019  
393 393 Hanley Ramirez 35 ramirha01 2019 CLE AL 0.550816395 -0.203773585   0 1 CLE BOS 2019 2019  
614 614 Noe Ramirez 29 ramirno01 2019 LAA AL 1.800337009 0.927169811 P 5 1 ANA BOS 2017 2019  
686 686 Joe Kelly 31 kellyjo05 2019 LAD NL 1.525600073 -0.112075472 P 2 1 LAD BOS 2019 2019  
785 785 Travis Shaw 29 shawtr01 2019 MIL NL 2.632777967 -0.973018868 3B, 1B, 2B 1 1 MIL BOS 2017 2019  
1140 1140 Ian Kinsler 37 kinslia01 2019 SDP NL 2.893821023 -0.234339623 2B, P 3 1 SDP BOS 2019 2019  
1197 1197 Roenis Elias 30 eliasro01 2019 SEA AL 1.89856234 0.056037736 P 3 1 SEA BOS 2018 2019 WSN
1248 1248 Pablo Sandoval 32 sandopa01 2019 SFG NL 2.975905703 1.202264151 3B, 1B, P 9 1 SFG BOS 2017 2019  
1269 1269 Drew Pomeranz 30 pomerdr01 2019 SFG NL 2.036715642 -0.468679245 P 2 1 SFG BOS 2019 2019 MIL
1275 1275 Fernando Abad 33 abadfe01 2019 SFG NL 0.493007563 -0.030566038 P 1 1 SFG BOS 2019 2019  
1364 1364 Jalen Beeks 25 beeksja02 2019 TBR AL 2.844035569 0.27509434 P 5 1 TBD BOS 2018 2019  
1609 1609 Deven Marrero 27 marrede01 2018 ARI NL 0.846351931 -0.395 3B, 2B 0 1 ARI BOS 2018 2018 FLA
1825 1825 Yoan Moncada 23 moncayo01 2018 CHW AL 6.231404959 2.04 2B 14 1 CHW BOS 2017 2019  
1957 1957 Rajai Davis 37 davisra01 2018 CLE AL 1.996812241 -0.315 CF, LF, RF 1 1 CLE BOS 2018 2018 NYM
1965 1965 Ben Taylor 25 taylobe10 2018 CLE AL 0.136268229 -0.02 P 0 1 CLE BOS 2018 2018  
2018 2018 Jose Iglesias 28 iglesjo01 2018 DET AL 4.477870216 2.335 SS 13 1 DET BOS 2013 2018 CIN
2029 2029 Alex Wilson 31 wilsoal01 2018 DET AL 2.195098401 0.715 P 5 1 DET BOS 2015 2018 MIL
2039 2039 Victor Martinez 39 martivi01 2018 DET AL 4.90249584 -1.445 1B 3 1 DET BOS 2011 2018  
2154 2154 Blaine Boyer 36 boyerbl01 2018 KCR AL 0.596248874 -1.305 P 0 1 KCR BOS 2018 2018  
2178 2178 Noe Ramirez 28 ramirno01 2018 LAA AL 2.346206715 -0.015 P 3 1 ANA BOS 2017 2019  
2212 2212 Chris Young 34 youngch04 2018 LAA AL 1.219848833 -0.54 RF, CF, LF 0 1 ANA BOS 2018 2018  
2290 2290 Brad Ziegler 38 zieglbr01 2018 MIA NL 1.845899368 -0.327018634 P 2 1 FLA BOS 2017 2018 ARI
2314 2314 Junichi Tazawa 32 tazawju01 2018 MIA NL 0.505809335 -0.684223602 P 0 1 FLA BOS 2017 2018 ANA
2320 2320 Travis Shaw 28 shawtr01 2018 MIL NL 5.755874894 3.821411043 3B, 2B, 1B 21 1 MIL BOS 2017 2019  
2403 2403 Addison Reed 29 reedad01 2018 MIN AL 1.786022745 -0.045 P 2 1 MIN BOS 2018 2018  
2743 2743 Roenis Elias 29 eliasro01 2018 SEA AL 1.090567096 1.005 P 5 1 SEA BOS 2018 2019 WSN
2774 2774 Ryan Cook 31 cookry01 2018 SEA AL 0.472074183 -0.145 P 0 1 SEA BOS 2018 2018  
2801 2801 Pablo Sandoval 31 sandopa01 2018 SFG NL 2.520434558 0.095 3B, 1B, 2B, P 4 1 SFG BOS 2017 2019  
2911 2911 Jalen Beeks 24 beeksja02 2018 TBR AL 1.345062364 0.17 P 2 2 TBD BOS 2018 2019  
2937 2937 Adrian Beltre 39 beltrad01 2018 TEX AL 4.540690104 1.665 3B 11 1 TEX BOS 2011 2018  
2951 2951 Doug Fister 34 fistedo01 2018 TEX AL 1.893076134 0.61 P 4 1 TEX BOS 2018 2018  
3134 3134 Rubby De La Rosa 28 delarru01 2017 ARI NL 0.245161306 -0.03 P 0 1 ARI BOS 2015 2017  
3315 3315 Koji Uehara 42 ueharko01 2017 CHC NL 1.451396945 0.395 P 3 1 CHC BOS 2017 2017  
3347 3347 Yoan Moncada 22 moncayo01 2017 CHW AL 2.218579235 1.39 2B 7 1 CHW BOS 2017 2019  
3468 3468 Michael Martinez 34 martimi02 2017 CLE AL 0.130693707 0.13 2B, 3B, CF, LF, P, SS 1 1 CLE BOS 2017 2017 TBD
3506 3506 Ryan Hanigan 36 hanigry01 2017 COL NL 1.107776262 -0.345 C 1 1 COL BOS 2017 2017  
3524 3524 Jose Iglesias 27 iglesjo01 2017 DET AL 4.628263708 1.57 SS 10 1 DET BOS 2013 2018 CIN
3534 3534 Alex Wilson 30 wilsoal01 2017 DET AL 2.060352393 0.395 P 4 1 DET BOS 2015 2018 MIL
3540 3540 Victor Martinez 38 martivi01 2017 DET AL 4.117167102 -0.8   3 1 DET BOS 2011 2018  
3554 3554 William Cuevas 26 cuevawi01 2017 DET AL 0.005775708 -0.075 P 0 1 DET BOS 2017 2017 BOS
3561 3561 Bryan Holaday 29 holadbr01 2017 DET AL 0.274477807 -0.3 C, 2B 0 1 DET BOS 2017 2017 FLA
3692 3692 Noe Ramirez 27 ramirno01 2017 LAA AL 0.261765258 0.185 P 1 2 ANA BOS 2017 2019  
3749 3749 Adrian Gonzalez 35 gonzaad01 2017 LAD NL 2.492496589 -1.05 1B 1 1 LAD BOS 2012 2017 NYM
3793 3793 Brad Ziegler 37 zieglbr01 2017 MIA NL 1.734416413 -0.155 P 2 1 FLA BOS 2017 2018 ARI
3802 3802 Junichi Tazawa 31 tazawju01 2017 MIA NL 1.780366604 -0.53 P 1 1 FLA BOS 2017 2018 ANA
3812 3812 Travis Shaw 27 shawtr01 2017 MIL NL 6.040213095 3.71 3B, 1B 20 1 MIL BOS 2017 2019  
3978 3978 Jacoby Ellsbury 33 ellsbja01 2017 NYY AL 3.748143467 1.67 CF, 2B 9 1 NYY BOS 2014 2017  
4007 4007 Tommy Layne 32 layneto01 2017 NYY AL 0.27267338 -0.135 P 0 1 NYY BOS 2016 2017  
4058 4058 Ryan LaMarre 28 lamarry01 2017 OAK AL 0.076028183 -0.065 CF 0 1 OAK BOS 2017 2017 MIN
4111 4111 Clay Buchholz 32 buchhcl01 2017 PHI NL 0.209843803 -0.155 P 0 1 PHI BOS 2017 2017 ARI
4217 4217 Chase d'Arnaud 30 darnach01 2017 SDP NL 0.523817956 -0.64 SS, LF, 2B, 3B, 1B, RF 0 3 SDP BOS 2017 2017 SFG
4261 4261 Jean Machi 35 machije01 2017 SEA AL 0.23822917 0.04 P 0 1 SEA BOS 2017 2017  
4312 4312 Pablo Sandoval 30 sandopa01 2017 SFG NL 1.704416566 -0.365 3B, 1B, 2B 1 2 SFG BOS 2017 2019  
4328 4328 Aaron Hill 35 hillaa01 2017 SFG NL 0.797387867 -0.71 2B, 3B, LF 0 1 SFG BOS 2017 2017  
4435 4435 Adrian Beltre 38 beltrad01 2017 TEX AL 3.702330161 3.185 3B 15 1 TEX BOS 2011 2018  
4607 4607 Rubby De La Rosa 27 delarru01 2016 ARI NL 1.520824884 0.585 P 4 1 ARI BOS 2015 2017  
4639 4639 Edwin Escobar 24 escobed02 2016 ARI NL 0.852462369 -0.57 P 0 1 ARI BOS 2016 2016  
4672 4672 Brandon Snyder 29 snydebr03 2016 ATL NL 0.463763185 0.22136646 3B, 1B, LF 1 1 ATL BOS 2016 2016 TBD
4675 4675 Alexi Ogando 32 ogandal01 2016 ATL NL 0.835564506 -0.015093168 P 1 1 ATL BOS 2016 2016 CLE
4812 4812 David Ross 39 rossda01 2016 CHC NL 2.00336984 1.795 C 8 1 CHC BOS 2015 2016  
4832 4832 Ryan Kalish 28 kalisry01 2016 CHC NL 0.097725358 0.11 LF, RF 0 1 CHC BOS 2014 2016  
4912 4912 Ivan De Jesus 29 dejesiv02 2016 CIN NL 2.443904977 0.04 SS, 2B, 3B, 1B, LF 4 1 CIN BOS 2015 2016  
5047 5047 Jose Iglesias 26 iglesjo01 2016 DET AL 4.874508519 1.977204969 SS 13 1 DET BOS 2013 2018 CIN
5050 5050 Victor Martinez 37 martivi01 2016 DET AL 5.796199214 1.298012422 1B 12 1 DET BOS 2011 2018  
5051 5051 Alex Wilson 29 wilsoal01 2016 DET AL 2.493591927 1.453975155 P 8 1 DET BOS 2015 2018 MIL
5230 5230 Adrian Gonzalez 34 gonzaad01 2016 LAD NL 6.280191584 1.575 1B 14 1 LAD BOS 2012 2017 NYM
5277 5277 Carl Crawford 34 crawfca02 2016 LAD NL 0.863154294 -0.87 LF 0 1 LAD BOS 2013 2016  
5316 5316 Craig Breslow 35 breslcr01 2016 MIA NL 0.386493658 -0.055341615 P 0 1 FLA BOS 2016 2016 MIN
5423 5423 Pat Light 25 lightpa01 2016 MIN AL 0.373888584 -0.34 P 0 2 MIN BOS 2016 2016  
5480 5480 Jacoby Ellsbury 32 ellsbja01 2016 NYY AL 6.012253684 2.285 CF 16 1 NYY BOS 2014 2017  
5506 5506 Tommy Layne 31 layneto01 2016 NYY AL 0.562289905 0.21 P 1 2 NYY BOS 2016 2017  
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
5607 5607 Dalier Hinojosa 30 hinojda01 2016 PHI NL 0.336007624 0.16 P 1 1 PHI BOS 2015 2016  
5644 5644 Mark Melancon 31 melanma01 2016 PIT NL 1.591686492 1.275 P 6 1 PIT BOS 2013 2016 WSN
5721 5721 Jemile Weeks 29 weeksje01 2016 SDP NL 0.580917238 -0.1 2B, 3B 1 1 SDP BOS 2016 2016  
5758 5758 Wade Miley 29 mileywa01 2016 SEA AL 3.076714293 0.645 P 6 1 SEA BOS 2016 2016 BAL
5780 5780 Jonathan Aro 25 arojo01 2016 SEA AL 0.0251692 0.025 P 0 1 SEA BOS 2016 2016  
5815 5815 Jake Peavy 35 peavyja01 2016 SFG NL 3.059438512 -0.045 P 4 1 SFG BOS 2014 2016  
5930 5930 Adrian Beltre 37 beltrad01 2016 TEX AL 6.118345146 5.985 3B 29 1 TEX BOS 2011 2018  
5976 5976 Anthony Ranaudo 26 ranauan01 2016 TEX AL 0.122433541 -0.375 P 0 1 TEX BOS 2015 2016 CHW
6087 6087 Rubby De La Rosa 26 delarru01 2015 ARI NL 5.149616642 -0.075 P 7 1 ARI BOS 2015 2017  
6123 6123 Allen Webster 25 webstal01 2015 ARI NL 0.706615598 -0.9 P 0 1 ARI BOS 2015 2015 CHC
6228 6228 Ryan Lavarnway 27 lavarry01 2015 BAL AL 0.310108605 -0.36 C, 1B 0 1 BAL BOS 2015 2015 ATL
6305 6305 David Ross 38 rossda01 2015 CHC NL 1.812811266 0.145 C, P 3 1 CHC BOS 2015 2016  
6316 6316 Jonathan Herrera 30 herrejo03 2015 CHC NL 1.314786193 -0.315 2B, 3B, SS 1 1 CHC BOS 2015 2015  
6389 6389 Burke Badenhop 32 badenbu01 2015 CIN NL 1.872944507 0.335 P 3 1 CIN BOS 2015 2015  
6397 6397 Ivan De Jesus 28 dejesiv02 2015 CIN NL 2.197644649 -0.215 2B, LF, 3B, SS, 1B 2 1 CIN BOS 2015 2016  
6471 6471 Mike Aviles 34 avilemi01 2015 CLE AL 3.021528348 -1.111863354 LF, 3B, SS, 2B, CF, RF 0 1 CLE BOS 2013 2015 DET
6527 6527 Yoenis Cespedes 29 cespeyo01 2015 DET AL 4.038812785 3.677701863 LF, CF 17 1 DET BOS 2015 2015 NYM
6529 6529 Jose Iglesias 25 iglesjo01 2015 DET AL 4.29419439 1.504285714 SS 10 1 DET BOS 2013 2018 CIN
6535 6535 Alex Wilson 28 wilsoal01 2015 DET AL 2.131233861 1.277888199 P 7 1 DET BOS 2015 2018 MIL
6554 6554 Victor Martinez 36 martivi01 2015 DET AL 4.587410307 -1.821242236 1B 1 1 DET BOS 2011 2018  
6693 6693 Shane Victorino 34 victosh01 2015 LAA AL 0.952412869 -0.32 RF, LF, CF 1 2 ANA BOS 2015 2015  
6714 6714 Adrian Gonzalez 33 gonzaad01 2015 LAD NL 6.493818562 3.54 1B 19 1 LAD BOS 2012 2017 NYM
6737 6737 Carl Crawford 33 crawfca02 2015 LAD NL 1.949155494 0.135 LF 3 1 LAD BOS 2013 2016  
6813 6813 Jarrod Saltalamacchia 30 saltaja01 2015 MIA NL 0.337566138 -0.35 C, 1B 0 1 FLA BOS 2014 2015 ARI

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