mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
2,522 rows where next_franch = "SFG"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
114 | 114 | Joey Rickard | 28 | rickajo01 | 2019 | BAL | AL | 1.294214876 | 0.091698113 | RF, LF, CF | 2 | 1 | BAL | 2016 | 2019 | SFG | |
341 | 341 | Wandy Peralta | 27 | peralwa01 | 2019 | CIN | NL | 0.916662159 | -0.514528302 | P | 0 | 1 | CIN | 2016 | 2019 | SFG | |
343 | 343 | Scooter Gennett | 29 | gennesc01 | 2019 | CIN | NL | 0.743060498 | -0.641886792 | 2B | 0 | 1 | CIN | MIL | 2017 | 2019 | SFG |
789 | 789 | Mauricio Dubon | 24 | dubonma01 | 2019 | MIL | NL | 0.019721183 | -0.025471698 | 2B, SS | 0 | 1 | MIL | 2019 | 2019 | SFG | |
796 | 796 | Burch Smith | 29 | smithbu03 | 2019 | MIL | NL | 0.269653652 | -0.249622642 | P | 0 | 1 | MIL | KCR | 2019 | 2019 | SFG |
841 | 841 | Tyler Austin | 27 | austity01 | 2019 | MIN | AL | 0.046251994 | -0.025471698 | LF, 1B, RF | 0 | 1 | MIN | NYY | 2018 | 2019 | SFG |
999 | 999 | Corban Joseph | 30 | josepco01 | 2019 | OAK | AL | 0.377973281 | -0.219056604 | 2B, 3B | 0 | 1 | OAK | BAL | 2019 | 2019 | SFG |
1061 | 1061 | Aaron Altherr | 28 | altheaa01 | 2019 | PHI | NL | 0.299226139 | -0.565471698 | LF, CF, RF, P | 0 | 1 | PHI | 2014 | 2019 | SFG | |
1165 | 1165 | Alex Dickerson | 29 | dickeal01 | 2019 | SDP | NL | 0.195667614 | -0.249622642 | LF, RF | 0 | 1 | SDP | 2015 | 2019 | SFG | |
1508 | 1508 | Kevin Pillar | 30 | pillake01 | 2019 | TOR | AL | 0.165269863 | -0.331132075 | CF, RF | 0 | 1 | TOR | 2013 | 2019 | SFG | |
1561 | 1561 | Kyle Barraclough | 29 | barraky01 | 2019 | WSN | NL | 0.960944092 | -0.641886792 | P | 0 | 1 | WSN | FLA | 2019 | 2019 | SFG |
1651 | 1651 | Michael Reed | 25 | reedmi02 | 2018 | ATL | NL | 0.068546345 | -0.005 | LF | 0 | 1 | ATL | MIL | 2018 | 2018 | SFG |
1688 | 1688 | Joey Rickard | 27 | rickajo01 | 2018 | BAL | AL | 2.219264681 | 0.52 | RF, LF, CF | 4 | 1 | BAL | 2016 | 2019 | SFG | |
1758 | 1758 | Drew Pomeranz | 29 | pomerdr01 | 2018 | BOS | AL | 1.865950124 | -0.445 | P | 2 | 1 | BOS | SDP | 2016 | 2018 | SFG |
1873 | 1873 | Scooter Gennett | 28 | gennesc01 | 2018 | CIN | NL | 6.279314441 | 4.325 | 2B | 21 | 1 | CIN | MIL | 2017 | 2019 | SFG |
1900 | 1900 | Wandy Peralta | 26 | peralwa01 | 2018 | CIN | NL | 1.264026699 | -0.315 | P | 1 | 1 | CIN | 2016 | 2019 | SFG | |
1986 | 1986 | Gerardo Parra | 31 | parrage01 | 2018 | COL | NL | 4.397398597 | 0.233558282 | LF, RF | 8 | 1 | COL | BAL | 2016 | 2018 | SFG |
2062 | 2062 | Mike Gerber | 25 | gerbemi01 | 2018 | DET | AL | 0.453577371 | -0.525 | LF, CF, RF | 0 | 1 | DET | 2018 | 2018 | SFG | |
2206 | 2206 | Williams Jerez | 26 | jerezwi01 | 2018 | LAA | AL | 0.467396012 | -0.365 | P | 0 | 1 | ANA | 2018 | 2018 | SFG | |
2248 | 2248 | Pat Venditte | 33 | vendipa01 | 2018 | LAD | NL | 0.258193769 | 0.15404908 | P | 1 | 1 | LAD | SEA | 2018 | 2018 | SFG |
2339 | 2339 | Erik Kratz | 38 | kratzer01 | 2018 | MIL | NL | 2.147421809 | 0.397546012 | C, P, 1B | 5 | 1 | MIL | NYY | 2018 | 2018 | SFG |
2396 | 2396 | Tyler Austin | 26 | austity01 | 2018 | MIN | AL | 1.286366601 | 0.305 | 1B | 3 | 2 | MIN | NYY | 2018 | 2019 | SFG |
2611 | 2611 | Aaron Altherr | 27 | altheaa01 | 2018 | PHI | NL | 2.832419465 | -0.63 | RF, CF, LF | 2 | 1 | PHI | 2014 | 2019 | SFG | |
2748 | 2748 | Nick Vincent | 31 | vinceni01 | 2018 | SEA | AL | 1.949131288 | 0.445 | P | 4 | 1 | SEA | SDP | 2016 | 2018 | SFG |
2982 | 2982 | Kevin Pillar | 29 | pillake01 | 2018 | TOR | AL | 5.194315929 | 2.225 | CF | 14 | 1 | TOR | 2013 | 2019 | SFG | |
3004 | 3004 | Yangervis Solarte | 30 | solarya01 | 2018 | TOR | AL | 4.849306015 | -1.02 | 3B, 2B, SS, 1B | 4 | 1 | TOR | SDP | 2018 | 2018 | SFG |
3093 | 3093 | Trevor Gott | 25 | gotttr01 | 2018 | WSN | NL | 0.45743739 | -0.245 | P | 0 | 1 | WSN | ANA | 2016 | 2018 | SFG |
3118 | 3118 | Gregor Blanco | 33 | blancgr01 | 2017 | ARI | NL | 2.527749404 | 0.28 | LF, CF, RF | 4 | 1 | ARI | SFG | 2017 | 2017 | SFG |
3210 | 3210 | Joey Rickard | 26 | rickajo01 | 2017 | BAL | AL | 2.624305782 | 0.48 | RF, LF, CF | 5 | 1 | BAL | 2016 | 2019 | SFG | |
3244 | 3244 | Drew Pomeranz | 28 | pomerdr01 | 2017 | BOS | AL | 4.641707069 | 3.44 | P | 17 | 1 | BOS | SDP | 2016 | 2018 | SFG |
3263 | 3263 | Fernando Abad | 31 | abadfe01 | 2017 | BOS | AL | 1.048525452 | 0.4 | P | 3 | 1 | BOS | MIN | 2016 | 2017 | SFG |
3290 | 3290 | Pablo Sandoval | 30 | sandopa01 | 2017 | BOS | AL | 0.99192399 | -0.685 | 3B, 1B, 2B | 0 | 1 | BOS | SFG | 2015 | 2017 | SFG |
3329 | 3329 | Pierce Johnson | 26 | johnspi01 | 2017 | CHC | NL | 0.029986295 | -0.065 | P | 0 | 1 | CHC | 2017 | 2017 | SFG | |
3365 | 3365 | Derek Holland | 30 | hollade01 | 2017 | CHW | AL | 3.768239164 | -1.16 | P | 2 | 1 | CHW | TEX | 2017 | 2017 | SFG |
3376 | 3376 | Alen Hanson | 24 | hansoal01 | 2017 | CHW | AL | 1.680741845 | -0.35 | RF, 2B, CF, LF, SS, 3B | 1 | 2 | CHW | PIT | 2017 | 2017 | SFG |
3392 | 3392 | Scooter Gennett | 27 | gennesc01 | 2017 | CIN | NL | 4.898215803 | 2.205 | 2B, 3B, LF, RF, P | 13 | 1 | CIN | MIL | 2017 | 2019 | SFG |
3403 | 3403 | Wandy Peralta | 25 | peralwa01 | 2017 | CIN | NL | 2.050853567 | 0.56 | P | 4 | 1 | CIN | 2016 | 2019 | SFG | |
3447 | 3447 | Austin Jackson | 30 | jacksau01 | 2017 | CLE | AL | 2.968614196 | 1.83 | CF, LF, RF | 9 | 1 | CLE | CHW | 2017 | 2017 | SFG |
3488 | 3488 | Gerardo Parra | 30 | parrage01 | 2017 | COL | NL | 4.20361528 | 0.75 | LF, RF, 1B, CF | 9 | 1 | COL | BAL | 2016 | 2018 | SFG |
3514 | 3514 | Cristhian Adames | 25 | adamecr01 | 2017 | COL | NL | 0.138472033 | -0.355 | 1B, 2B, SS | 0 | 1 | COL | 2014 | 2017 | SFG | |
3605 | 3605 | Jandel Gustave | 24 | gustaja01 | 2017 | HOU | AL | 0.131805466 | -0.11 | P | 0 | 1 | HOU | 2016 | 2017 | SFG | |
3743 | 3743 | Tony Watson | 32 | watsoto01 | 2017 | LAD | NL | 0.695066997 | 0.24 | P | 2 | 2 | LAD | PIT | 2017 | 2017 | SFG |
3837 | 3837 | Stephen Vogt | 32 | vogtst01 | 2017 | MIL | NL | 1.285787936 | 0.245 | C, LF | 3 | 2 | MIL | OAK | 2017 | 2017 | SFG |
4076 | 4076 | Aaron Altherr | 26 | altheaa01 | 2017 | PHI | NL | 4.100909559 | 1.515 | LF, RF, CF | 9 | 1 | PHI | 2014 | 2019 | SFG | |
4122 | 4122 | Andrew McCutchen | 30 | mccutan01 | 2017 | PIT | NL | 6.485463616 | 3.115 | CF, RF | 19 | 1 | PIT | 2009 | 2017 | SFG | |
4213 | 4213 | Jose Valdez | 27 | valdejo03 | 2017 | SDP | NL | 0.347499534 | -0.39 | P | 0 | 2 | SDP | ANA | 2017 | 2017 | SFG |
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 |
4230 | 4230 | Nick Vincent | 30 | vinceni01 | 2017 | SEA | AL | 2.449568014 | 1.525 | P | 8 | 1 | SEA | SDP | 2016 | 2018 | SFG |
4382 | 4382 | Evan Longoria | 31 | longoev01 | 2017 | TBR | AL | 6.413917021 | 2.95 | 3B | 17 | 1 | TBD | 2008 | 2017 | SFG | |
4482 | 4482 | Sam Dyson | 29 | dysonsa01 | 2017 | TEX | AL | 0.618394875 | -1.195 | P | 0 | 1 | TEX | FLA | 2015 | 2017 | SFG |
4486 | 4486 | Kevin Pillar | 28 | pillake01 | 2017 | TOR | AL | 5.979771615 | 2.52 | CF | 16 | 1 | TOR | 2013 | 2019 | SFG | |
4586 | 4586 | Trevor Gott | 24 | gotttr01 | 2017 | WSN | NL | 0.062165756 | -0.285 | P | 0 | 1 | WSN | ANA | 2016 | 2018 | SFG |
4671 | 4671 | Gordon Beckham | 29 | beckhgo01 | 2016 | ATL | NL | 2.693773392 | -0.593664596 | 2B, 3B, SS | 2 | 1 | ATL | CHW | 2016 | 2016 | SFG |
4677 | 4677 | Casey Kelly | 26 | kellyca01 | 2016 | ATL | NL | 0.744740139 | -0.070434783 | P | 1 | 1 | ATL | SDP | 2016 | 2016 | SFG |
4725 | 4725 | Joey Rickard | 25 | rickajo01 | 2016 | BAL | AL | 2.698564593 | -0.345 | RF, LF, CF | 3 | 1 | BAL | 2016 | 2019 | SFG | |
4745 | 4745 | Drew Stubbs | 31 | stubbdr01 | 2016 | BAL | AL | 0.258373206 | -0.25 | RF, CF, LF | 0 | 3 | BAL | TEX | 2016 | 2016 | SFG |
4768 | 4768 | Drew Pomeranz | 27 | pomerdr01 | 2016 | BOS | AL | 1.973699449 | 0.54 | P | 4 | 2 | BOS | SDP | 2016 | 2018 | SFG |
4779 | 4779 | Aaron Hill | 34 | hillaa01 | 2016 | BOS | AL | 1.262672811 | -0.265 | 3B, 2B | 1 | 2 | BOS | MIL | 2016 | 2016 | SFG |
4792 | 4792 | Fernando Abad | 30 | abadfe01 | 2016 | BOS | AL | 0.442497815 | -0.185 | P | 0 | 2 | BOS | MIN | 2016 | 2017 | SFG |
4793 | 4793 | Pablo Sandoval | 29 | sandopa01 | 2016 | BOS | AL | 0.064516129 | -0.21 | 3B | 0 | 1 | BOS | SFG | 2015 | 2017 | SFG |
4834 | 4834 | Joe Nathan | 41 | nathajo01 | 2016 | CHC | NL | 0.037656546 | 0.04 | P | 0 | 1 | CHC | DET | 2016 | 2016 | SFG |
4842 | 4842 | Tim Federowicz | 28 | federti01 | 2016 | CHC | NL | 0.322493682 | -0.415 | C | 0 | 1 | CHC | LAD | 2016 | 2016 | SFG |
4926 | 4926 | Wandy Peralta | 24 | peralwa01 | 2016 | CIN | NL | 0.172396152 | -0.145 | P | 0 | 1 | CIN | 2016 | 2019 | SFG | |
5011 | 5011 | Nick Hundley | 32 | hundlni01 | 2016 | COL | NL | 3.116799458 | -0.11 | C | 4 | 1 | COL | BAL | 2015 | 2016 | SFG |
5025 | 5025 | Cristhian Adames | 24 | adamecr01 | 2016 | COL | NL | 2.517036786 | -0.705 | SS, 2B, 3B | 1 | 1 | COL | 2014 | 2017 | SFG | |
5040 | 5040 | Gerardo Parra | 29 | parrage01 | 2016 | COL | NL | 3.746058654 | -2.315 | LF, 1B, RF, CF | 0 | 1 | COL | BAL | 2016 | 2018 | SFG |
5112 | 5112 | Jandel Gustave | 23 | gustaja01 | 2016 | HOU | AL | 0.325014282 | 0.135 | P | 1 | 1 | HOU | 2016 | 2017 | SFG | |
5321 | 5321 | Bryan Morris | 29 | morribr01 | 2016 | MIA | NL | 0.585777929 | -0.160993789 | P | 0 | 1 | FLA | PIT | 2014 | 2016 | SFG |
5360 | 5360 | Will Smith | 26 | smithwi04 | 2016 | MIL | NL | 0.848448328 | -0.04 | P | 1 | 1 | MIL | KCR | 2014 | 2016 | SFG |
5385 | 5385 | Eduardo Nunez | 29 | nunezed02 | 2016 | MIN | AL | 3.69438636 | 1.65 | SS, 3B, 2B | 9 | 1 | MIN | NYY | 2014 | 2016 | SFG |
5422 | 5422 | Neil Ramirez | 27 | ramirne01 | 2016 | MIN | AL | 0.362924404 | -0.3 | P | 0 | 3 | MIN | MIL | 2016 | 2016 | SFG |
5462 | 5462 | Justin Ruggiano | 34 | ruggiju01 | 2016 | NYM | NL | 0.220303867 | 0.21 | CF, LF, RF | 1 | 2 | NYM | TEX | 2016 | 2016 | SFG |
5514 | 5514 | Donovan Solano | 28 | solando01 | 2016 | NYY | AL | 0.2208975 | 0.01 | 2B, 3B | 0 | 1 | NYY | FLA | 2016 | 2016 | SFG |
5600 | 5600 | Aaron Altherr | 25 | altheaa01 | 2016 | PHI | NL | 2.319182667 | -0.295 | RF, LF, CF | 3 | 1 | PHI | 2014 | 2019 | SFG | |
5639 | 5639 | Andrew McCutchen | 29 | mccutan01 | 2016 | PIT | NL | 6.590909091 | 0.24 | CF | 10 | 1 | PIT | 2009 | 2017 | SFG | |
5678 | 5678 | Mike Morse | 34 | morsemi01 | 2016 | PIT | NL | 0.078114478 | -0.21 | 1B | 0 | 1 | PIT | FLA | 2015 | 2016 | SFG |
5696 | 5696 | Alex Dickerson | 26 | dickeal01 | 2016 | SDP | NL | 2.904586189 | 0.935 | LF | 7 | 1 | SDP | 2015 | 2019 | SFG | |
5760 | 5760 | Nick Vincent | 29 | vinceni01 | 2016 | SEA | AL | 2.109413966 | 0.51 | P | 5 | 1 | SEA | SDP | 2016 | 2018 | SFG |
5880 | 5880 | Ruben Tejada | 26 | tejadru01 | 2016 | STL | NL | 0.393420383 | -0.46 | 3B, SS, 2B, P | 0 | 1 | STL | NYM | 2016 | 2016 | SFG |
5882 | 5882 | Evan Longoria | 30 | longoev01 | 2016 | TBR | AL | 6.598571666 | 4.185 | 3B | 20 | 1 | TBD | 2008 | 2017 | SFG | |
5891 | 5891 | Matt Moore | 27 | moorema02 | 2016 | TBR | AL | 3.676477962 | 1.22 | P | 8 | 1 | TBD | 2011 | 2016 | SFG | |
5938 | 5938 | Sam Dyson | 28 | dysonsa01 | 2016 | TEX | AL | 2.927863046 | 1.98 | P | 11 | 1 | TEX | FLA | 2015 | 2017 | SFG |
5988 | 5988 | Kevin Pillar | 27 | pillake01 | 2016 | TOR | AL | 5.463225806 | 2.925 | CF | 16 | 1 | TOR | 2013 | 2019 | SFG | |
6045 | 6045 | Mark Melancon | 31 | melanma01 | 2016 | WSN | NL | 1.06148748 | 1.105 | P | 5 | 2 | WSN | PIT | 2016 | 2016 | SFG |
6063 | 6063 | Trevor Gott | 23 | gotttr01 | 2016 | WSN | NL | 0.166488749 | 0.16 | P | 1 | 1 | WSN | ANA | 2016 | 2018 | SFG |
6122 | 6122 | Matt Reynolds | 30 | reynoma02 | 2015 | ARI | NL | 0.505969871 | -0.335 | P | 0 | 1 | ARI | COL | 2013 | 2015 | SFG |
6245 | 6245 | Alejandro De Aza | 31 | deazaal01 | 2015 | BOS | AL | 1.661944623 | 1.15 | LF, RF, CF | 6 | 2 | BOS | BAL | 2015 | 2015 | SFG |
6258 | 6258 | Pablo Sandoval | 28 | sandopa01 | 2015 | BOS | AL | 4.715067611 | -1.05 | 3B | 3 | 1 | BOS | SFG | 2015 | 2017 | SFG |
6337 | 6337 | Jeff Samardzija | 30 | samarje01 | 2015 | CHW | AL | 5.986422632 | 1.315 | P | 13 | 1 | CHW | OAK | 2015 | 2015 | SFG |
6379 | 6379 | Mike Leake | 27 | leakemi01 | 2015 | CIN | NL | 3.797579116 | 2.045 | P | 10 | 1 | CIN | 2010 | 2015 | SFG | |
6383 | 6383 | Marlon Byrd | 37 | byrdma01 | 2015 | CIN | NL | 3.840928486 | 0.89 | LF, RF, CF | 7 | 1 | CIN | PHI | 2015 | 2015 | SFG |
6478 | 6478 | Nick Hundley | 31 | hundlni01 | 2015 | COL | NL | 3.923826087 | 1.515 | C | 10 | 1 | COL | BAL | 2015 | 2016 | SFG |
6507 | 6507 | Cristhian Adames | 23 | adamecr01 | 2015 | COL | NL | 0.585043478 | 0.035 | SS, 2B | 1 | 1 | COL | 2014 | 2017 | SFG | |
6633 | 6633 | Johnny Cueto | 29 | cuetojo01 | 2015 | KCR | AL | 2.274600569 | 0.64 | P | 6 | 2 | KCR | CIN | 2015 | 2015 | SFG |
6655 | 6655 | Orlando Calixte | 23 | calixor01 | 2015 | KCR | AL | 0.028557361 | -0.07 | SS | 0 | 1 | KCR | 2015 | 2015 | SFG | |
6690 | 6690 | Conor Gillaspie | 27 | gillaco01 | 2015 | LAA | AL | 0.660857909 | -0.17 | 3B, 1B, 2B | 1 | 2 | ANA | CHW | 2015 | 2015 | SFG |
6710 | 6710 | Grant Green | 27 | greengr01 | 2015 | LAA | AL | 0.427613941 | -0.555 | 2B, 1B, LF, SS | 0 | 1 | ANA | OAK | 2013 | 2015 | SFG |
6785 | 6785 | Bryan Morris | 28 | morribr01 | 2015 | MIA | NL | 2.154303559 | 0.29 | P | 4 | 1 | FLA | PIT | 2014 | 2016 | SFG |
6796 | 6796 | Vin Mazzaro | 28 | mazzavi01 | 2015 | MIA | NL | 0.264975198 | 0.065 | P | 1 | 1 | FLA | PIT | 2015 | 2015 | SFG |
6829 | 6829 | Will Smith | 25 | smithwi04 | 2015 | MIL | NL | 2.248406785 | 1.16 | P | 7 | 1 | MIL | KCR | 2014 | 2016 | SFG |
Advanced export
JSON shape: default, array, newline-delimited
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 );