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,968 rows where next_franch = "NYY"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1004 | 1004 | Ryan Dull | 29 | dullry01 | 2019 | OAK | AL | 0.187516812 | -0.40754717 | P | 0 | 1 | OAK | 2015 | 2019 | NYY | |
1005 | 1005 | Kendrys Morales | 36 | moralke01 | 2019 | OAK | AL | 1.190615836 | -0.417735849 | 1B, P | 0 | 1 | OAK | TOR | 2019 | 2019 | NYY |
1106 | 1106 | Tyler Lyons | 31 | lyonsty01 | 2019 | PIT | NL | 0.197076397 | -0.259811321 | P | 0 | 1 | PIT | STL | 2019 | 2019 | NYY |
1177 | 1177 | Edwin Encarnacion | 36 | encared01 | 2019 | SEA | AL | 2.763270689 | 1.844150943 | 1B, 2B | 9 | 1 | SEA | CLE | 2019 | 2019 | NYY |
1194 | 1194 | Cory Gearrin | 33 | gearrco01 | 2019 | SEA | AL | 1.210820441 | 0.509433962 | P | 3 | 1 | SEA | OAK | 2019 | 2019 | NYY |
1603 | 1603 | Jake Barrett | 26 | barreja01 | 2018 | ARI | NL | 0.17341503 | -0.045 | P | 0 | 1 | ARI | 2016 | 2018 | NYY | |
1702 | 1702 | Zack Britton | 30 | brittza01 | 2018 | BAL | AL | 0.508149641 | 0.165 | P | 1 | 1 | BAL | 2011 | 2018 | NYY | |
1704 | 1704 | Breyvic Valera | 26 | valerbr01 | 2018 | BAL | AL | 0.395608052 | 0.06 | 2B, 3B, SS, RF | 1 | 2 | BAL | LAD | 2018 | 2018 | NYY |
1716 | 1716 | Nestor Cortes Jr. | 23 | cortene01 | 2018 | BAL | AL | 0.152081086 | -0.21 | P | 0 | 1 | BAL | 2018 | 2018 | NYY | |
1961 | 1961 | George Kontos | 33 | kontoge01 | 2018 | CLE | AL | 0.083673474 | 0.03 | P | 0 | 2 | CLE | PIT | 2018 | 2018 | NYY |
1979 | 1979 | DJ LeMahieu | 29 | lemahdj01 | 2018 | COL | NL | 5.767242855 | 2.549263804 | 2B | 17 | 1 | COL | CHC | 2012 | 2018 | NYY |
1983 | 1983 | Adam Ottavino | 32 | ottavad01 | 2018 | COL | NL | 2.889542198 | 2.251104294 | P | 11 | 1 | COL | STL | 2012 | 2018 | NYY |
2012 | 2012 | Mike Tauchman | 27 | tauchmi01 | 2018 | COL | NL | 0.367277084 | -0.49196319 | CF, LF, RF | 0 | 1 | COL | 2017 | 2018 | NYY | |
2384 | 2384 | Lance Lynn | 31 | lynnla01 | 2018 | MIN | AL | 2.867214307 | 0.555 | P | 6 | 1 | MIN | STL | 2018 | 2018 | NYY |
2414 | 2414 | David Hale | 30 | haleda02 | 2018 | MIN | AL | 0.092550077 | -0.2 | P | 0 | 2 | MIN | NYY | 2018 | 2018 | NYY |
2559 | 2559 | Ryan Dull | 28 | dullry01 | 2018 | OAK | AL | 0.657154522 | 0.18 | P | 2 | 1 | OAK | 2015 | 2019 | NYY | |
2668 | 2668 | Adeiny Hechavarria | 29 | hechaad01 | 2018 | PIT | NL | 0.474004521 | -0.105652174 | SS, 3B | 0 | 2 | PIT | TBD | 2018 | 2018 | NYY |
2730 | 2730 | James Paxton | 29 | paxtoja01 | 2018 | SEA | AL | 4.452307489 | 3.31 | P | 17 | 1 | SEA | 2013 | 2018 | NYY | |
2766 | 2766 | Cameron Maybin | 31 | maybica01 | 2018 | SEA | AL | 0.927617477 | -0.185 | LF, CF, RF | 1 | 2 | SEA | FLA | 2018 | 2018 | NYY |
2783 | 2783 | Andrew McCutchen | 31 | mccutan01 | 2018 | SFG | NL | 5.680979479 | 1.925 | RF, LF | 15 | 1 | SFG | PIT | 2018 | 2018 | NYY |
2863 | 2863 | Luke Voit | 27 | voitlu01 | 2018 | STL | NL | 0.128384131 | 0.045 | 1B, RF | 0 | 1 | STL | 2017 | 2018 | NYY | |
2986 | 2986 | J.A. Happ | 35 | happja01 | 2018 | TOR | AL | 3.291628169 | 1.69 | P | 10 | 1 | TOR | PIT | 2016 | 2018 | NYY |
3037 | 3037 | Gio Urshela | 26 | urshegi01 | 2018 | TOR | AL | 0.440846001 | -0.15 | 3B, SS | 0 | 1 | TOR | CLE | 2018 | 2018 | NYY |
3094 | 3094 | A.J. Cole | 26 | coleaj01 | 2018 | WSN | NL | 0.236419913 | -0.34 | P | 0 | 1 | WSN | 2015 | 2018 | NYY | |
3110 | 3110 | Brandon Drury | 24 | drurybr01 | 2017 | ARI | NL | 4.739530133 | 1.38 | 2B, 3B | 11 | 1 | ARI | 2015 | 2017 | NYY | |
3141 | 3141 | Jake Barrett | 25 | barreja01 | 2017 | ARI | NL | 0.721521883 | -0.305 | P | 0 | 1 | ARI | 2016 | 2018 | NYY | |
3177 | 3177 | Jace Peterson | 27 | peterja01 | 2017 | ATL | NL | 2.115710892 | -0.765 | LF, 2B, 3B, 1B, SS, RF | 1 | 1 | ATL | SDP | 2015 | 2017 | NYY |
3208 | 3208 | Zack Britton | 29 | brittza01 | 2017 | BAL | AL | 1.376585751 | 0.815 | P | 5 | 1 | BAL | 2011 | 2018 | NYY | |
3341 | 3341 | Todd Frazier | 31 | frazito01 | 2017 | CHW | AL | 3.217420103 | 1.855 | 3B, 1B | 10 | 1 | CHW | CIN | 2016 | 2017 | NYY |
3351 | 3351 | Tommy Kahnle | 27 | kahnlto01 | 2017 | CHW | AL | 1.296779511 | 1.165 | P | 5 | 1 | CHW | COL | 2016 | 2017 | NYY |
3353 | 3353 | David Robertson | 32 | roberda08 | 2017 | CHW | AL | 1.361857592 | 0.96 | P | 5 | 1 | CHW | NYY | 2015 | 2017 | NYY |
3479 | 3479 | DJ LeMahieu | 28 | lemahdj01 | 2017 | COL | NL | 6.745566166 | 2.39 | 2B | 18 | 1 | COL | CHC | 2012 | 2018 | NYY |
3500 | 3500 | Adam Ottavino | 31 | ottavad01 | 2017 | COL | NL | 1.68348082 | 0.075 | P | 3 | 1 | COL | STL | 2012 | 2018 | NYY |
3513 | 3513 | Mike Tauchman | 26 | tauchmi01 | 2017 | COL | NL | 0.316507503 | -0.245 | CF, LF, RF | 0 | 1 | COL | 2017 | 2018 | NYY | |
3696 | 3696 | Shane Robinson | 32 | robinsh01 | 2017 | LAA | AL | 0.335426305 | 0.015 | RF, CF, LF | 1 | 1 | ANA | MIN | 2016 | 2017 | NYY |
3769 | 3769 | Giancarlo Stanton | 27 | stantmi03 | 2017 | MIA | NL | 6.768296796 | 7.575 | RF | 32 | 1 | FLA | 2010 | 2017 | NYY | |
3834 | 3834 | Neil Walker | 31 | walkene01 | 2017 | MIL | NL | 1.485134903 | 0.62 | 2B, 1B, 3B | 4 | 2 | MIL | NYM | 2017 | 2017 | NYY |
3890 | 3890 | Jaime Garcia | 30 | garcija02 | 2017 | MIN | AL | 0.189170962 | 0.145 | P | 1 | 2 | MIN | ATL | 2017 | 2017 | NYY |
4025 | 4025 | Sonny Gray | 27 | grayso01 | 2017 | OAK | AL | 2.778588405 | 1.84 | P | 9 | 1 | OAK | 2013 | 2017 | NYY | |
4054 | 4054 | Ryan Dull | 27 | dullry01 | 2017 | OAK | AL | 1.441146685 | -0.36 | P | 1 | 1 | OAK | 2015 | 2019 | NYY | |
4225 | 4225 | James Paxton | 28 | paxtoja01 | 2017 | SEA | AL | 3.783256785 | 3.98 | P | 17 | 1 | SEA | 2013 | 2018 | NYY | |
4354 | 4354 | Luke Voit | 26 | voitlu01 | 2017 | STL | NL | 1.221259976 | 0.31 | 1B | 3 | 1 | STL | 2017 | 2018 | NYY | |
4487 | 4487 | J.A. Happ | 34 | happja01 | 2017 | TOR | AL | 3.888934576 | 3.105 | P | 15 | 1 | TOR | PIT | 2016 | 2018 | NYY |
4504 | 4504 | Troy Tulowitzki | 32 | tulowtr01 | 2017 | TOR | AL | 2.460032626 | 0.15 | SS | 4 | 1 | TOR | COL | 2015 | 2017 | NYY |
4560 | 4560 | A.J. Cole | 25 | coleaj01 | 2017 | WSN | NL | 1.434135676 | 0.675 | P | 4 | 1 | WSN | 2015 | 2018 | NYY | |
4601 | 4601 | Brandon Drury | 23 | drurybr01 | 2016 | ARI | NL | 4.883901451 | 0.115 | LF, RF, 3B, 2B, 1B | 7 | 1 | ARI | 2015 | 2017 | NYY | |
4605 | 4605 | Jake Barrett | 24 | barreja01 | 2016 | ARI | NL | 1.919968206 | 0.695 | P | 5 | 1 | ARI | 2016 | 2018 | NYY | |
4613 | 4613 | Tyler Clippard | 31 | clippty01 | 2016 | ARI | NL | 1.296068832 | 0.325 | P | 3 | 1 | ARI | NYM | 2016 | 2016 | NYY |
4651 | 4651 | Jace Peterson | 26 | peterja01 | 2016 | ATL | NL | 4.025859136 | 0.28173913 | 2B, LF, 3B, CF | 7 | 1 | ATL | SDP | 2015 | 2017 | NYY |
4709 | 4709 | Zack Britton | 28 | brittza01 | 2016 | BAL | AL | 2.757444739 | 3.35 | P | 14 | 1 | BAL | 2011 | 2018 | NYY | |
4774 | 4774 | Tommy Layne | 31 | layneto01 | 2016 | BOS | AL | 0.671853778 | 0.335 | P | 2 | 1 | BOS | SDP | 2014 | 2016 | NYY |
4813 | 4813 | Aroldis Chapman | 28 | chapmar01 | 2016 | CHC | NL | 1.008159393 | 1.245 | P | 5 | 2 | CHC | NYY | 2016 | 2016 | NYY |
4843 | 4843 | Adam Warren | 28 | warread01 | 2016 | CHC | NL | 1.16107685 | -0.85 | P | 0 | 1 | CHC | NYY | 2016 | 2016 | NYY |
4847 | 4847 | Todd Frazier | 30 | frazito01 | 2016 | CHW | AL | 6.323129808 | 3.015 | 3B, 1B | 17 | 1 | CHW | CIN | 2016 | 2017 | NYY |
4856 | 4856 | David Robertson | 31 | roberda08 | 2016 | CHW | AL | 2.611518881 | 1.11 | P | 7 | 1 | CHW | NYY | 2015 | 2017 | NYY |
4865 | 4865 | Tommy Kahnle | 26 | kahnlto01 | 2016 | CHW | AL | 0.772880496 | 0.345 | P | 2 | 1 | CHW | COL | 2016 | 2017 | NYY |
4995 | 4995 | DJ LeMahieu | 27 | lemahdj01 | 2016 | COL | NL | 6.24343109 | 4.84 | 2B | 22 | 1 | COL | CHC | 2012 | 2018 | NYY |
5009 | 5009 | Adam Ottavino | 30 | ottavad01 | 2016 | COL | NL | 1.0464894 | 0.78 | P | 4 | 1 | COL | STL | 2012 | 2018 | NYY |
5028 | 5028 | David Hale | 28 | haleda02 | 2016 | COL | NL | 0.040296917 | -0.105 | P | 0 | 1 | COL | ATL | 2015 | 2016 | NYY |
5079 | 5079 | Joe Mantiply | 25 | mantijo01 | 2016 | DET | AL | 0.042723683 | -0.130807453 | P | 0 | 1 | DET | 2016 | 2016 | NYY | |
5198 | 5198 | Shane Robinson | 31 | robinsh01 | 2016 | LAA | AL | 1.069435216 | 0.03 | LF, CF, RF | 2 | 1 | ANA | MIN | 2016 | 2017 | NYY |
5219 | 5219 | Ji-Man Choi | 25 | choiji01 | 2016 | LAA | AL | 1.242857143 | -0.49 | 1B, LF | 0 | 1 | ANA | 2016 | 2016 | NYY | |
5284 | 5284 | Giancarlo Stanton | 26 | stantmi03 | 2016 | MIA | NL | 4.686264397 | 2.394782609 | RF | 13 | 1 | FLA | 2010 | 2017 | NYY | |
5336 | 5336 | Chris Carter | 29 | cartech02 | 2016 | MIL | NL | 6.493741307 | 0.935 | 1B | 12 | 1 | MIL | HOU | 2016 | 2016 | NYY |
5538 | 5538 | Ryan Dull | 26 | dullry01 | 2016 | OAK | AL | 2.645791831 | 1.76 | P | 9 | 1 | OAK | 2015 | 2019 | NYY | |
5542 | 5542 | Sonny Gray | 26 | grayso01 | 2016 | OAK | AL | 3.389251478 | 0.275 | P | 6 | 1 | OAK | 2013 | 2017 | NYY | |
5553 | 5553 | Billy Butler | 30 | butlebi03 | 2016 | OAK | AL | 2.340113371 | -0.25 | 1B | 3 | 1 | OAK | KCR | 2015 | 2016 | NYY |
5683 | 5683 | Erik Kratz | 36 | kratzer01 | 2016 | PIT | NL | 0.556565657 | -0.545 | C, 1B, P | 0 | 2 | PIT | HOU | 2016 | 2016 | NYY |
5747 | 5747 | James Paxton | 27 | paxtoja01 | 2016 | SEA | AL | 3.323950263 | 2.335 | P | 12 | 1 | SEA | 2013 | 2018 | NYY | |
5779 | 5779 | Blake Parker | 31 | parkebl01 | 2016 | SEA | AL | 0.048036935 | 0.05 | P | 0 | 1 | SEA | CHC | 2016 | 2016 | NYY |
5856 | 5856 | Matt Holliday | 36 | hollima01 | 2016 | STL | NL | 4.189927082 | 0.56 | LF, 1B | 7 | 1 | STL | OAK | 2009 | 2016 | NYY |
5985 | 5985 | J.A. Happ | 33 | happja01 | 2016 | TOR | AL | 5.335052624 | 3.835 | P | 19 | 1 | TOR | PIT | 2016 | 2018 | NYY |
5986 | 5986 | Troy Tulowitzki | 31 | tulowtr01 | 2016 | TOR | AL | 5.089032258 | 3.175 | SS | 16 | 1 | TOR | COL | 2015 | 2017 | NYY |
6065 | 6065 | A.J. Cole | 24 | coleaj01 | 2016 | WSN | NL | 1.05248151 | -0.025 | P | 1 | 1 | WSN | 2015 | 2018 | NYY | |
6112 | 6112 | Brandon Drury | 22 | drurybr01 | 2015 | ARI | NL | 0.575416176 | -0.18 | 3B, 2B, SS | 0 | 1 | ARI | 2015 | 2017 | NYY | |
6131 | 6131 | Jace Peterson | 25 | peterja01 | 2015 | ATL | NL | 6.072606103 | 0.7 | 2B | 11 | 1 | ATL | SDP | 2015 | 2017 | NYY |
6192 | 6192 | Zack Britton | 27 | brittza01 | 2015 | BAL | AL | 2.515137276 | 2.27 | P | 10 | 1 | BAL | 2011 | 2018 | NYY | |
6216 | 6216 | Chris Parmelee | 27 | parmech01 | 2015 | BAL | AL | 0.988471178 | -0.04 | 1B, RF | 1 | 1 | BAL | MIN | 2015 | 2015 | NYY |
6255 | 6255 | Tommy Layne | 30 | layneto01 | 2015 | BOS | AL | 1.473934925 | 0.355 | P | 3 | 1 | BOS | SDP | 2014 | 2016 | NYY |
6293 | 6293 | Starlin Castro | 25 | castrst01 | 2015 | CHC | NL | 5.757169844 | 0.7 | SS, 2B | 11 | 1 | CHC | 2010 | 2015 | NYY | |
6345 | 6345 | David Robertson | 30 | roberda08 | 2015 | CHW | AL | 2.633838468 | 1.125 | P | 7 | 1 | CHW | NYY | 2015 | 2017 | NYY |
6378 | 6378 | Aroldis Chapman | 27 | chapmar01 | 2015 | CIN | NL | 2.586447177 | 2.625 | P | 11 | 1 | CIN | 2010 | 2015 | NYY | |
6459 | 6459 | Anthony Swarzak | 29 | swarzan01 | 2015 | CLE | AL | 0.271584366 | 0.0 | P | 0 | 1 | CLE | MIN | 2015 | 2015 | NYY |
6475 | 6475 | DJ LeMahieu | 26 | lemahdj01 | 2015 | COL | NL | 6.253913043 | 2.125 | 2B | 15 | 1 | COL | CHC | 2012 | 2018 | NYY |
6492 | 6492 | David Hale | 27 | haleda02 | 2015 | COL | NL | 2.208096184 | -0.06 | P | 3 | 1 | COL | ATL | 2015 | 2016 | NYY |
6493 | 6493 | Adam Ottavino | 29 | ottavad01 | 2015 | COL | NL | 0.363317954 | 0.61 | P | 2 | 1 | COL | STL | 2012 | 2018 | NYY |
6751 | 6751 | Ronald Torreyes | 22 | torrero01 | 2015 | LAD | NL | 0.08079401 | 0.11 | 2B, 3B | 0 | 1 | LAD | 2015 | 2015 | NYY | |
6753 | 6753 | Sergio Santos | 31 | santose01 | 2015 | LAD | NL | 0.317458845 | -0.08 | P | 0 | 1 | LAD | TOR | 2015 | 2015 | NYY |
6770 | 6770 | Giancarlo Stanton | 25 | stantmi03 | 2015 | MIA | NL | 3.252910053 | 3.64 | RF | 15 | 1 | FLA | 2010 | 2017 | NYY | |
6815 | 6815 | Donovan Solano | 27 | solando01 | 2015 | MIA | NL | 0.961552028 | -0.62 | 3B, SS, 2B | 0 | 1 | FLA | 2012 | 2015 | NYY | |
6876 | 6876 | Aaron Hicks | 25 | hicksaa01 | 2015 | MIN | AL | 3.771885943 | 1.75 | CF, RF, LF | 11 | 1 | MIN | 2013 | 2015 | NYY | |
6950 | 6950 | Eric Young Jr. | 30 | younger03 | 2015 | NYM | NL | 0.090108752 | -0.025 | CF, LF, RF | 0 | 2 | NYM | ATL | 2015 | 2015 | NYY |
7016 | 7016 | Sonny Gray | 25 | grayso01 | 2015 | OAK | AL | 5.917703975 | 4.585 | P | 21 | 1 | OAK | 2013 | 2017 | NYY | |
7034 | 7034 | Billy Butler | 29 | butlebi03 | 2015 | OAK | AL | 5.66796748 | -0.71 | 1B | 5 | 1 | OAK | KCR | 2015 | 2016 | NYY |
7039 | 7039 | Ike Davis | 28 | davisik02 | 2015 | OAK | AL | 2.25398374 | -0.33 | 1B, P | 2 | 1 | OAK | PIT | 2015 | 2015 | NYY |
7053 | 7053 | Ryan Dull | 25 | dullry01 | 2015 | OAK | AL | 0.594282516 | -0.14 | P | 0 | 1 | OAK | 2015 | 2019 | NYY | |
7230 | 7230 | James Paxton | 26 | paxtoja01 | 2015 | SEA | AL | 1.803913813 | 0.51 | P | 4 | 1 | SEA | 2013 | 2018 | NYY | |
7246 | 7246 | Tyler Olson | 25 | olsonty01 | 2015 | SEA | AL | 0.452553799 | -0.265 | P | 0 | 1 | SEA | 2015 | 2015 | NYY | |
7260 | 7260 | Dustin Ackley | 27 | ackledu01 | 2015 | SEA | AL | 1.966262692 | -0.87 | LF, CF, 2B, 1B, RF | 0 | 1 | SEA | 2011 | 2015 | NYY | |
7324 | 7324 | Matt Holliday | 35 | hollima01 | 2015 | STL | NL | 2.776702385 | 0.85 | LF | 7 | 1 | STL | OAK | 2009 | 2016 | NYY |
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 );