mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
764 rows where next_franch = "ARI"
This data as json, copyable, CSV (advanced)
Suggested facets: age, lg_ID, stint_ID, franch_id, prev_franch, year_acq, year_left
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185 | 185 | Blake Swihart | 27 | swihabl01 | 2019 | BOS | AL | 0.26521602 | 0.0 | LF, RF, C, 1B | 0 | 1 | BOS | 2015 | 2019 | ARI | |
714 | 714 | Zac Gallen | 23 | galleza01 | 2019 | MIA | NL | 1.062156068 | 1.059622642 | P | 5 | 1 | FLA | 2019 | 2019 | ARI | |
1176 | 1176 | Mike Leake | 31 | leakemi01 | 2019 | SEA | AL | 3.949916242 | 1.569056604 | P | 10 | 1 | SEA | STL | 2017 | 2019 | ARI |
1657 | 1657 | Chris Stewart | 36 | stewach01 | 2018 | ATL | NL | 0.156677359 | -0.065 | C | 0 | 1 | ATL | PIT | 2018 | 2018 | ARI |
1679 | 1679 | Adam Jones | 32 | jonesad01 | 2018 | BAL | AL | 5.914822825 | 0.275 | CF, RF, LF | 7 | 1 | BAL | SEA | 2008 | 2018 | ARI |
1693 | 1693 | Caleb Joseph | 32 | josepca01 | 2018 | BAL | AL | 2.701713525 | -0.04 | C, 1B | 3 | 1 | BAL | 2014 | 2018 | ARI | |
1757 | 1757 | Blake Swihart | 26 | swihabl01 | 2018 | BOS | AL | 1.911174785 | -0.27 | C, RF, 1B, LF, 3B, 2B | 2 | 1 | BOS | 2015 | 2019 | ARI | |
1771 | 1771 | Robby Scott | 28 | scottro02 | 2018 | BOS | AL | 0.250680829 | -0.33 | P | 0 | 1 | BOS | 2016 | 2018 | ARI | |
2115 | 2115 | Jon Jay | 33 | jayjo02 | 2018 | KCR | AL | 2.553881808 | 0.965 | RF, LF, CF | 6 | 1 | KCR | CHC | 2018 | 2018 | ARI |
2148 | 2148 | Abraham Almonte | 29 | almonab01 | 2018 | KCR | AL | 1.449759974 | -0.6 | CF, RF, LF | 0 | 1 | KCR | CLE | 2018 | 2018 | ARI |
2247 | 2247 | Tim Locastro | 25 | locasti01 | 2018 | LAD | NL | 0.134771784 | 0.15404908 | CF, LF | 1 | 1 | LAD | 2017 | 2018 | ARI | |
2290 | 2290 | Brad Ziegler | 38 | zieglbr01 | 2018 | MIA | NL | 1.845899368 | -0.327018634 | P | 2 | 1 | FLA | BOS | 2017 | 2018 | ARI |
2375 | 2375 | Eduardo Escobar | 29 | escobed01 | 2018 | MIN | AL | 3.859099804 | 2.37 | 3B, SS, 2B | 13 | 1 | MIN | CHW | 2012 | 2018 | ARI |
2437 | 2437 | Wilmer Flores | 26 | florewi01 | 2018 | NYM | NL | 4.257700205 | 0.445 | 1B, 2B, 3B | 7 | 1 | NYM | 2013 | 2018 | ARI | |
2735 | 2735 | Mike Leake | 30 | leakemi01 | 2018 | SEA | AL | 5.155790585 | 1.9 | P | 14 | 1 | SEA | STL | 2017 | 2019 | ARI |
2845 | 2845 | Luke Weaver | 24 | weavelu01 | 2018 | STL | NL | 3.534350142 | 0.125 | P | 6 | 1 | STL | 2016 | 2018 | ARI | |
2873 | 2873 | Carson Kelly | 23 | kellyca02 | 2018 | STL | NL | 0.414779499 | -0.515 | C | 0 | 1 | STL | 2016 | 2018 | ARI | |
2908 | 2908 | Matt Andriese | 28 | andrima01 | 2018 | TBR | AL | 1.810271903 | 0.25 | P | 3 | 1 | TBD | 2015 | 2018 | ARI | |
2949 | 2949 | Jake Diekman | 31 | diekmja01 | 2018 | TEX | AL | 1.405772384 | 0.73 | P | 4 | 1 | TEX | PHI | 2015 | 2018 | ARI |
3064 | 3064 | Greg Holland | 32 | hollagr01 | 2018 | WSN | NL | 0.75287505 | 0.84 | P | 3 | 2 | WSN | STL | 2018 | 2018 | ARI |
3195 | 3195 | Adam Jones | 31 | jonesad01 | 2017 | BAL | AL | 6.016007841 | 2.11 | CF | 16 | 1 | BAL | SEA | 2008 | 2018 | ARI |
3201 | 3201 | Caleb Joseph | 31 | josepca01 | 2017 | BAL | AL | 2.520091473 | 1.315 | C, 3B | 8 | 1 | BAL | 2014 | 2018 | ARI | |
3230 | 3230 | Stefan Crichton | 25 | crichst01 | 2017 | BAL | AL | 0.269069254 | -0.11 | P | 0 | 1 | BAL | 2017 | 2017 | ARI | |
3264 | 3264 | Deven Marrero | 26 | marrede01 | 2017 | BOS | AL | 1.726682502 | 0.295 | 3B, 2B, SS, 1B | 3 | 1 | BOS | 2015 | 2017 | ARI | |
3273 | 3273 | Robby Scott | 27 | scottro02 | 2017 | BOS | AL | 1.223470265 | 0.045 | P | 2 | 1 | BOS | 2016 | 2018 | ARI | |
3279 | 3279 | Blake Swihart | 25 | swihabl01 | 2017 | BOS | AL | 0.06429137 | 0.0 | C | 0 | 1 | BOS | 2015 | 2019 | ARI | |
3314 | 3314 | Alex Avila | 30 | avilaal01 | 2017 | CHC | NL | 1.094892972 | 0.54 | C, 1B | 3 | 2 | CHC | DET | 2017 | 2017 | ARI |
3407 | 3407 | Patrick Kivlehan | 27 | kivlepa01 | 2017 | CIN | NL | 2.010535259 | 0.035 | RF, 1B, LF, 3B, CF | 3 | 1 | CIN | SDP | 2016 | 2017 | ARI |
3530 | 3530 | J.D. Martinez | 29 | martijd02 | 2017 | DET | AL | 2.195822454 | 1.605 | RF | 7 | 1 | DET | HOU | 2014 | 2017 | ARI |
3680 | 3680 | David Hernandez | 32 | hernada01 | 2017 | LAA | AL | 1.022298785 | 0.975 | P | 4 | 1 | ANA | PHI | 2017 | 2017 | ARI |
3691 | 3691 | Fernando Salas | 32 | salasfe01 | 2017 | LAA | AL | 0.323497198 | 0.3 | P | 1 | 2 | ANA | NYM | 2017 | 2017 | ARI |
3711 | 3711 | Troy Scribner | 25 | scribtr01 | 2017 | LAA | AL | 0.644761328 | -0.185 | P | 0 | 1 | ANA | 2017 | 2017 | ARI | |
3752 | 3752 | Tim Locastro | 24 | locasti01 | 2017 | LAD | NL | 0.009890859 | -0.01 | LF | 0 | 1 | LAD | 2017 | 2018 | ARI | |
3793 | 3793 | Brad Ziegler | 37 | zieglbr01 | 2017 | MIA | NL | 1.734416413 | -0.155 | P | 2 | 1 | FLA | BOS | 2017 | 2018 | ARI |
3872 | 3872 | Eduardo Escobar | 28 | escobed01 | 2017 | MIN | AL | 4.640371974 | 1.475 | 3B, SS, 2B, LF, C | 11 | 1 | MIN | CHW | 2012 | 2018 | ARI |
3929 | 3929 | Wilmer Flores | 25 | florewi01 | 2017 | NYM | NL | 3.592130026 | 0.445 | 3B, 1B, 2B | 6 | 1 | NYM | 2013 | 2018 | ARI | |
4043 | 4043 | Adam Rosales | 34 | rosalad01 | 2017 | OAK | AL | 2.119285597 | -0.105 | SS, 3B, 2B, 1B, LF | 3 | 1 | OAK | SDP | 2017 | 2017 | ARI |
4111 | 4111 | Clay Buchholz | 32 | buchhcl01 | 2017 | PHI | NL | 0.209843803 | -0.155 | P | 0 | 1 | PHI | BOS | 2017 | 2017 | ARI |
4228 | 4228 | Jarrod Dyson | 32 | dysonja01 | 2017 | SEA | AL | 3.684639192 | 2.405 | CF, LF | 12 | 1 | SEA | KCR | 2017 | 2017 | ARI |
4236 | 4236 | Mike Leake | 29 | leakemi01 | 2017 | SEA | AL | 0.885443077 | 1.08 | P | 4 | 2 | SEA | STL | 2017 | 2019 | ARI |
4349 | 4349 | Luke Weaver | 23 | weavelu01 | 2017 | STL | NL | 1.579655014 | 1.08 | P | 5 | 1 | STL | 2016 | 2018 | ARI | |
4376 | 4376 | Carson Kelly | 22 | kellyca02 | 2017 | STL | NL | 0.738665308 | -0.36 | C | 0 | 1 | STL | 2016 | 2018 | ARI | |
4379 | 4379 | Steven Souza Jr. | 28 | souzast01 | 2017 | TBR | AL | 5.845475335 | 3.925 | RF, CF | 19 | 1 | TBD | WSN | 2015 | 2017 | ARI |
4400 | 4400 | Matt Andriese | 27 | andrima01 | 2017 | TBR | AL | 2.297395806 | 0.35 | P | 4 | 1 | TBD | 2015 | 2018 | ARI | |
4407 | 4407 | Brad Boxberger | 29 | boxbebr01 | 2017 | TBR | AL | 0.976298332 | 0.37 | P | 2 | 1 | TBD | SDP | 2014 | 2017 | ARI |
4456 | 4456 | Jake Diekman | 30 | diekmja01 | 2017 | TEX | AL | 0.377783051 | 0.21 | P | 1 | 1 | TEX | PHI | 2015 | 2018 | ARI |
4708 | 4708 | Adam Jones | 30 | jonesad01 | 2016 | BAL | AL | 6.43062201 | 1.725 | CF | 15 | 1 | BAL | SEA | 2008 | 2018 | ARI |
4746 | 4746 | T.J. McFarland | 27 | mcfartj01 | 2016 | BAL | AL | 0.671697159 | -0.355 | P | 0 | 1 | BAL | 2013 | 2016 | ARI | |
4748 | 4748 | Caleb Joseph | 30 | josepca01 | 2016 | BAL | AL | 1.349282297 | -0.705 | C, 1B | 0 | 1 | BAL | 2014 | 2018 | ARI | |
4775 | 4775 | Blake Swihart | 24 | swihabl01 | 2016 | BOS | AL | 0.68202765 | 0.275 | LF, C | 2 | 1 | BOS | 2015 | 2019 | ARI | |
4778 | 4778 | Robby Scott | 26 | scottro02 | 2016 | BOS | AL | 0.186609672 | 0.22 | P | 1 | 1 | BOS | 2016 | 2018 | ARI | |
4787 | 4787 | Deven Marrero | 25 | marrede01 | 2016 | BOS | AL | 0.129032258 | -0.12 | 2B, 3B, SS | 0 | 1 | BOS | 2015 | 2017 | ARI | |
4928 | 4928 | Patrick Kivlehan | 26 | kivlepa01 | 2016 | CIN | NL | 0.050286111 | -0.165 | RF, LF | 0 | 2 | CIN | SDP | 2016 | 2017 | ARI |
4944 | 4944 | J.J. Hoover | 28 | hoovejj01 | 2016 | CIN | NL | 0.509605049 | -1.22 | P | 0 | 1 | CIN | 2012 | 2016 | ARI | |
5007 | 5007 | Daniel Descalso | 29 | descada01 | 2016 | COL | NL | 2.841498559 | 0.625 | SS, 1B, 2B, LF, 3B | 6 | 1 | COL | STL | 2015 | 2016 | ARI |
5008 | 5008 | Jorge De La Rosa | 35 | rosajo01 | 2016 | COL | NL | 3.812826607 | 0.245 | P | 6 | 1 | COL | KCR | 2008 | 2016 | ARI |
5046 | 5046 | J.D. Martinez | 28 | martijd02 | 2016 | DET | AL | 4.912516383 | 2.022484472 | RF | 13 | 1 | DET | HOU | 2014 | 2017 | ARI |
5164 | 5164 | Rey Fuentes | 25 | fuentre01 | 2016 | KCR | AL | 0.423147073 | -0.215 | RF, LF | 0 | 1 | KCR | SDP | 2016 | 2016 | ARI |
5167 | 5167 | Kris Medlen | 30 | medlekr01 | 2016 | KCR | AL | 0.678104841 | -0.405 | P | 0 | 1 | KCR | ATL | 2015 | 2016 | ARI |
5294 | 5294 | Jeff Mathis | 33 | mathije01 | 2016 | MIA | NL | 1.316142341 | 0.664099379 | C | 4 | 1 | FLA | TOR | 2013 | 2016 | ARI |
5330 | 5330 | Fernando Rodney | 39 | rodnefe01 | 2016 | MIA | NL | 1.269323466 | -0.628881988 | P | 0 | 2 | FLA | SDP | 2016 | 2016 | ARI |
5402 | 5402 | Eduardo Escobar | 27 | escobed01 | 2016 | MIN | AL | 3.517130449 | -0.385 | SS, 3B, 2B, LF, P | 3 | 1 | MIN | CHW | 2012 | 2018 | ARI |
5425 | 5425 | John Ryan Murphy | 25 | murphjr01 | 2016 | MIN | AL | 0.839633264 | -0.465 | C | 0 | 1 | MIN | NYY | 2016 | 2016 | ARI |
5445 | 5445 | Wilmer Flores | 24 | florewi01 | 2016 | NYM | NL | 3.354627072 | 0.615 | 3B, 1B, 2B, SS | 6 | 1 | NYM | 2013 | 2018 | ARI | |
5754 | 5754 | Taijuan Walker | 23 | walketa01 | 2016 | SEA | AL | 3.690225774 | 0.55 | P | 7 | 1 | SEA | 2013 | 2016 | ARI | |
5759 | 5759 | Ketel Marte | 22 | marteke01 | 2016 | SEA | AL | 4.357949049 | -0.025 | SS | 6 | 1 | SEA | 2015 | 2016 | ARI | |
5766 | 5766 | Chris Iannetta | 33 | iannech01 | 2016 | SEA | AL | 3.160915834 | -0.205 | C | 4 | 1 | SEA | ANA | 2016 | 2016 | ARI |
5776 | 5776 | Tom Wilhelmsen | 32 | wilheto01 | 2016 | SEA | AL | 0.829995978 | 0.08 | P | 1 | 2 | SEA | TEX | 2016 | 2016 | ARI |
5832 | 5832 | Gregor Blanco | 32 | blancgr01 | 2016 | SFG | NL | 2.694015935 | -0.845 | RF, LF, CF | 1 | 1 | SFG | KCR | 2012 | 2016 | ARI |
5864 | 5864 | Jeremy Hazelbaker | 28 | hazelje01 | 2016 | STL | NL | 2.203154146 | 0.13 | LF, CF, RF | 3 | 1 | STL | 2016 | 2016 | ARI | |
5870 | 5870 | Luke Weaver | 22 | weavelu01 | 2016 | STL | NL | 0.967230315 | 0.06 | P | 2 | 1 | STL | 2016 | 2018 | ARI | |
5876 | 5876 | Carson Kelly | 21 | kellyca02 | 2016 | STL | NL | 0.137697134 | -0.055 | C | 0 | 1 | STL | 2016 | 2018 | ARI | |
5889 | 5889 | Matt Andriese | 26 | andrima01 | 2016 | TBR | AL | 3.802537231 | 1.475 | P | 9 | 1 | TBD | 2015 | 2018 | ARI | |
5893 | 5893 | Steven Souza Jr. | 27 | souzast01 | 2016 | TBR | AL | 4.508221226 | 0.915 | RF, CF | 8 | 1 | TBD | WSN | 2015 | 2017 | ARI |
5922 | 5922 | Brad Boxberger | 28 | boxbebr01 | 2016 | TBR | AL | 0.863862007 | -0.19 | P | 0 | 1 | TBD | SDP | 2014 | 2017 | ARI |
5948 | 5948 | Jake Diekman | 29 | diekmja01 | 2016 | TEX | AL | 1.824294081 | 0.91 | P | 6 | 1 | TEX | PHI | 2015 | 2018 | ARI |
6124 | 6124 | Shelby Miller | 24 | millesh01 | 2015 | ATL | NL | 5.708225966 | 3.5 | P | 19 | 1 | ATL | STL | 2015 | 2015 | ARI |
6146 | 6146 | Michael Bourn | 32 | bournmi01 | 2015 | ATL | NL | 1.586811645 | -0.25 | CF, LF, RF | 2 | 2 | ATL | CLE | 2015 | 2015 | ARI |
6149 | 6149 | Phil Gosselin | 26 | gosseph01 | 2015 | ATL | NL | 0.42721852 | 0.235 | 2B, 3B, LF | 1 | 1 | ATL | 2013 | 2015 | ARI | |
6186 | 6186 | Adam Jones | 29 | jonesad01 | 2015 | BAL | AL | 5.630409357 | 3.38 | CF | 18 | 1 | BAL | SEA | 2008 | 2018 | ARI |
6189 | 6189 | Caleb Joseph | 29 | josepca01 | 2015 | BAL | AL | 3.440267335 | 2.185 | C, 1B | 11 | 1 | BAL | 2014 | 2018 | ARI | |
6217 | 6217 | T.J. McFarland | 26 | mcfartj01 | 2015 | BAL | AL | 1.101691877 | -0.195 | P | 1 | 1 | BAL | 2013 | 2016 | ARI | |
6224 | 6224 | Christian Walker | 24 | walkech02 | 2015 | BAL | AL | 0.116290727 | -0.035 | 1B | 0 | 1 | BAL | 2014 | 2015 | ARI | |
6246 | 6246 | Blake Swihart | 23 | swihabl01 | 2015 | BOS | AL | 2.885061172 | 0.635 | C | 6 | 1 | BOS | 2015 | 2019 | ARI | |
6277 | 6277 | Deven Marrero | 24 | marrede01 | 2015 | BOS | AL | 0.522858983 | -0.39 | 3B, SS, 2B | 0 | 1 | BOS | 2015 | 2017 | ARI | |
6364 | 6364 | Kyle Drabek | 27 | drabeky01 | 2015 | CHW | AL | 0.082974389 | -0.045 | P | 0 | 1 | CHW | TOR | 2015 | 2015 | ARI |
6386 | 6386 | J.J. Hoover | 27 | hoovejj01 | 2015 | CIN | NL | 2.210523695 | 0.495 | P | 4 | 1 | CIN | 2012 | 2016 | ARI | |
6419 | 6419 | Kristopher Negron | 29 | negrokr01 | 2015 | CIN | NL | 1.059225124 | -0.57 | LF, SS, 2B, CF, 1B, 3B, RF | 0 | 1 | CIN | 2012 | 2015 | ARI | |
6477 | 6477 | Jorge De La Rosa | 34 | rosajo01 | 2015 | COL | NL | 4.222661907 | 1.79 | P | 11 | 1 | COL | KCR | 2008 | 2016 | ARI |
6511 | 6511 | Daniel Descalso | 28 | descada01 | 2015 | COL | NL | 2.108173913 | -0.8 | SS, 2B, 1B, 3B, RF | 1 | 1 | COL | STL | 2015 | 2016 | ARI |
6523 | 6523 | J.D. Martinez | 27 | martijd02 | 2015 | DET | AL | 6.214285714 | 5.106521739 | RF | 24 | 1 | DET | HOU | 2014 | 2017 | ARI |
6637 | 6637 | Kris Medlen | 29 | medlekr01 | 2015 | KCR | AL | 1.666269046 | 0.335 | P | 4 | 1 | KCR | ATL | 2015 | 2016 | ARI |
6713 | 6713 | Zack Greinke | 31 | greinza01 | 2015 | LAD | NL | 6.082160909 | 7.83 | P | 31 | 1 | LAD | ANA | 2013 | 2015 | ARI |
6812 | 6812 | Jeff Mathis | 32 | mathije01 | 2015 | MIA | NL | 1.05361552 | -0.31 | C | 0 | 1 | FLA | TOR | 2013 | 2016 | ARI |
6813 | 6813 | Jarrod Saltalamacchia | 30 | saltaja01 | 2015 | MIA | NL | 0.337566138 | -0.35 | C, 1B | 0 | 1 | FLA | BOS | 2014 | 2015 | ARI |
6827 | 6827 | Jean Segura | 25 | segurje01 | 2015 | MIL | NL | 5.931010331 | 0.08 | SS | 9 | 1 | MIL | ANA | 2012 | 2015 | ARI |
6860 | 6860 | Tyler Wagner | 24 | wagnety01 | 2015 | MIL | NL | 0.397934784 | -0.165 | P | 0 | 1 | MIL | 2015 | 2015 | ARI | |
6871 | 6871 | Eduardo Escobar | 26 | escobed01 | 2015 | MIN | AL | 4.313490078 | 2.005 | SS, LF, 2B, 3B, RF | 13 | 1 | MIN | CHW | 2012 | 2018 | ARI |
6897 | 6897 | Chris Herrmann | 27 | herrmch01 | 2015 | MIN | AL | 1.092879773 | -0.28 | C, 1B, RF | 1 | 1 | MIN | 2012 | 2015 | ARI | |
6921 | 6921 | Wilmer Flores | 23 | florewi01 | 2015 | NYM | NL | 5.10616261 | 1.145 | SS, 2B | 11 | 1 | NYM | 2013 | 2018 | ARI |
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 );