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,365 rows where next_franch = "DET"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
847 | 847 | Austin Adams | 32 | adamsau01 | 2019 | MIN | AL | 0.039534947 | -0.117169811 | P | 0 | 1 | MIN | CLE | 2019 | 2019 | DET |
1514 | 1514 | Edwin Jackson | 35 | jacksed01 | 2019 | TOR | AL | 0.799676446 | -1.207358491 | P | 0 | 1 | TOR | OAK | 2019 | 2019 | DET |
1562 | 1562 | Trevor Rosenthal | 29 | rosentr01 | 2019 | WSN | NL | 0.179544682 | -0.652075472 | P | 0 | 1 | WSN | STL | 2019 | 2019 | DET |
1654 | 1654 | Dustin Peterson | 23 | peterdu01 | 2018 | ATL | NL | 0.01958467 | -0.025 | 0 | 1 | ATL | 2018 | 2018 | DET | ||
1920 | 1920 | Brandon Dixon | 26 | dixonbr01 | 2018 | CIN | NL | 1.22043102 | -0.405 | 1B, RF, 2B, LF, 3B, P | 0 | 1 | CIN | 2018 | 2018 | DET | |
1956 | 1956 | Zach McAllister | 30 | mcallza01 | 2018 | CLE | AL | 1.151755412 | -0.125 | P | 1 | 1 | CLE | 2011 | 2018 | DET | |
2311 | 2311 | Jacob Turner | 27 | turneja01 | 2018 | MIA | NL | 0.156262583 | -0.402484472 | P | 0 | 1 | FLA | WSN | 2018 | 2018 | DET |
2402 | 2402 | Bobby Wilson | 35 | wilsobo02 | 2018 | MIN | AL | 1.428245271 | 0.055 | C | 2 | 1 | MIN | TBD | 2018 | 2018 | DET |
2645 | 2645 | Jordy Mercer | 31 | mercejo03 | 2018 | PIT | NL | 4.397148322 | 0.538322981 | SS | 8 | 1 | PIT | 2012 | 2018 | DET | |
2648 | 2648 | Josh Harrison | 30 | harrijo05 | 2018 | PIT | NL | 3.771865762 | 0.296832298 | 2B, 3B | 7 | 1 | PIT | 2011 | 2018 | DET | |
2673 | 2673 | Josh Smoker | 29 | smokejo01 | 2018 | PIT | NL | 0.162484672 | -0.337080745 | P | 0 | 1 | PIT | NYM | 2018 | 2018 | DET |
2764 | 2764 | Gordon Beckham | 31 | beckhgo01 | 2018 | SEA | AL | 0.478153339 | 0.005 | 2B, 3B, SS | 1 | 1 | SEA | SFG | 2017 | 2018 | DET |
2848 | 2848 | Tyson Ross | 31 | rossty01 | 2018 | STL | NL | 0.998941034 | 0.66 | P | 4 | 2 | STL | SDP | 2018 | 2018 | DET |
2958 | 2958 | Matt Moore | 29 | moorema02 | 2018 | TEX | AL | 2.722274771 | -0.47 | P | 2 | 1 | TEX | SFG | 2018 | 2018 | DET |
3034 | 3034 | Jose Fernandez | 25 | fernajo04 | 2018 | TOR | AL | 0.384064242 | -0.05 | P | 0 | 1 | TOR | 2018 | 2018 | DET | |
3089 | 3089 | Carlos Torres | 35 | torreca01 | 2018 | WSN | NL | 0.187919686 | -0.145 | P | 0 | 1 | WSN | MIL | 2018 | 2018 | DET |
3323 | 3323 | Leonys Martin | 29 | martile01 | 2017 | CHC | NL | 0.156413282 | 0.09 | CF, RF, LF, P | 0 | 2 | CHC | SEA | 2017 | 2017 | DET |
3336 | 3336 | Jeimer Candelario | 23 | candeje01 | 2017 | CHC | NL | 0.351929884 | -0.19 | 3B, 1B | 0 | 1 | CHC | 2016 | 2017 | DET | |
3456 | 3456 | Zach McAllister | 29 | mcallza01 | 2017 | CLE | AL | 1.496118177 | 0.92 | P | 5 | 1 | CLE | 2011 | 2018 | DET | |
3586 | 3586 | Mike Fiers | 32 | fiersmi01 | 2017 | HOU | AL | 4.296105014 | -0.135 | P | 6 | 1 | HOU | MIL | 2015 | 2017 | DET |
3604 | 3604 | Francisco Liriano | 33 | liriafr01 | 2017 | HOU | AL | 0.457729001 | -0.07 | P | 0 | 2 | HOU | TOR | 2017 | 2017 | DET |
3910 | 3910 | Niko Goodrum | 25 | goodrni01 | 2017 | MIN | AL | 0.167388167 | -0.205 | 2B, RF | 0 | 1 | MIN | 2017 | 2017 | DET | |
4124 | 4124 | Josh Harrison | 29 | harrijo05 | 2017 | PIT | NL | 5.407878892 | 3.01 | 2B, 3B, LF, RF | 17 | 1 | PIT | 2011 | 2018 | DET | |
4131 | 4131 | Jordy Mercer | 30 | mercejo03 | 2017 | PIT | NL | 5.567521073 | 1.44 | SS | 12 | 1 | PIT | 2012 | 2018 | DET | |
4153 | 4153 | Johnny Barbato | 24 | barbajo01 | 2017 | PIT | NL | 0.632264389 | 0.025 | P | 1 | 1 | PIT | NYY | 2017 | 2017 | DET |
4271 | 4271 | Gordon Beckham | 30 | beckhgo01 | 2017 | SEA | AL | 0.17006027 | -0.155 | 2B, SS, 3B | 0 | 1 | SEA | SFG | 2017 | 2018 | DET |
4481 | 4481 | Pete Kozma | 29 | kozmape01 | 2017 | TEX | AL | 0.390219888 | -0.545 | 3B, SS, 1B, 2B | 0 | 2 | TEX | NYY | 2017 | 2017 | DET |
4541 | 4541 | Jarrod Saltalamacchia | 32 | saltaja01 | 2017 | TOR | AL | 0.246003263 | -0.6 | C | 0 | 1 | TOR | DET | 2017 | 2017 | DET |
4663 | 4663 | Erick Aybar | 32 | aybarer01 | 2016 | ATL | NL | 3.631167064 | -0.830124224 | SS, 3B, 2B | 3 | 1 | ATL | ANA | 2016 | 2016 | DET |
4780 | 4780 | William Cuevas | 25 | cuevawi01 | 2016 | BOS | AL | 0.100969688 | 0.035 | P | 0 | 1 | BOS | 2016 | 2016 | DET | |
4794 | 4794 | Bryan Holaday | 28 | holadbr01 | 2016 | BOS | AL | 0.322580645 | -0.22 | C, 3B, LF, P | 0 | 2 | BOS | TEX | 2016 | 2016 | DET |
4837 | 4837 | Jeimer Candelario | 22 | candeje01 | 2016 | CHC | NL | 0.136815501 | -0.18 | 3B | 0 | 1 | CHC | 2016 | 2017 | DET | |
4860 | 4860 | Alex Avila | 29 | avilaal01 | 2016 | CHW | AL | 1.98428548 | 0.775 | C | 5 | 1 | CHW | DET | 2016 | 2016 | DET |
4965 | 4965 | Zach McAllister | 28 | mcallza01 | 2016 | CLE | AL | 1.635897603 | 0.684223602 | P | 4 | 1 | CLE | 2011 | 2018 | DET | |
5095 | 5095 | Mike Fiers | 31 | fiersmi01 | 2016 | HOU | AL | 4.642738733 | 0.87 | P | 9 | 1 | HOU | MIL | 2015 | 2017 | DET |
5258 | 5258 | Louis Coleman | 30 | colemlo01 | 2016 | LAD | NL | 1.4764023 | -0.23 | P | 1 | 1 | LAD | KCR | 2016 | 2016 | DET |
5378 | 5378 | Alex Presley | 30 | preslal01 | 2016 | MIL | NL | 1.300764951 | -0.655 | RF, LF, CF | 0 | 1 | MIL | HOU | 2016 | 2016 | DET |
5618 | 5618 | Daniel Stumpf | 25 | stumpda01 | 2016 | PHI | NL | 0.176054151 | -0.235 | P | 0 | 1 | PHI | 2016 | 2016 | DET | |
5634 | 5634 | Josh Harrison | 28 | harrijo05 | 2016 | PIT | NL | 5.096969697 | 1.5 | 2B, RF | 12 | 1 | PIT | 2011 | 2018 | DET | |
5635 | 5635 | Jordy Mercer | 29 | mercejo03 | 2016 | PIT | NL | 5.702356902 | 1.15 | SS | 12 | 1 | PIT | 2012 | 2018 | DET | |
5929 | 5929 | Mikie Mahtook | 26 | mahtomi01 | 2016 | TBR | AL | 1.888058462 | -1.055 | LF, CF, RF | 0 | 1 | TBD | 2015 | 2016 | DET | |
6062 | 6062 | Matt den Dekker | 28 | dendema01 | 2016 | WSN | NL | 0.387926599 | 0.185 | CF, RF, LF | 1 | 1 | WSN | NYM | 2015 | 2016 | DET |
6091 | 6091 | Jarrod Saltalamacchia | 30 | saltaja01 | 2015 | ARI | NL | 1.89204641 | 0.59 | C, 1B | 4 | 2 | ARI | FLA | 2015 | 2015 | DET |
6130 | 6130 | Cameron Maybin | 28 | maybica01 | 2015 | ATL | NL | 5.645387583 | 0.9 | CF | 11 | 1 | ATL | SDP | 2015 | 2015 | DET |
6441 | 6441 | Zach McAllister | 27 | mcallza01 | 2015 | CLE | AL | 2.118984792 | 0.945838509 | P | 5 | 1 | CLE | 2011 | 2018 | DET | |
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 |
6592 | 6592 | Mike Fiers | 30 | fiersmi01 | 2015 | HOU | AL | 1.723196091 | 0.695 | P | 4 | 2 | HOU | MIL | 2015 | 2017 | DET |
6686 | 6686 | Efren Navarro | 29 | navaref01 | 2015 | LAA | AL | 0.855227882 | 0.165 | 1B, LF, RF | 2 | 1 | ANA | 2011 | 2015 | DET | |
6817 | 6817 | Casey McGehee | 32 | mcgehca01 | 2015 | MIA | NL | 1.227513228 | -0.65 | 3B, 1B | 0 | 2 | FLA | SFG | 2015 | 2015 | DET |
6828 | 6828 | Francisco Rodriguez | 33 | rodrifr03 | 2015 | MIL | NL | 2.138944876 | 1.355 | P | 7 | 1 | MIL | BAL | 2014 | 2015 | DET |
6872 | 6872 | Mike Pelfrey | 31 | pelfrmi01 | 2015 | MIN | AL | 4.570130182 | 1.875 | P | 13 | 1 | MIN | NYM | 2013 | 2015 | DET |
6958 | 6958 | Bobby Parnell | 30 | parnebo01 | 2015 | NYM | NL | 0.74163909 | -0.5 | P | 0 | 1 | NYM | 2008 | 2015 | DET | |
6975 | 6975 | Justin Wilson | 27 | wilsoju10 | 2015 | NYY | AL | 2.251576056 | 1.54 | P | 8 | 1 | NYY | PIT | 2015 | 2015 | DET |
7058 | 7058 | Edward Mujica | 31 | mujiced01 | 2015 | OAK | AL | 1.141248421 | -0.355 | P | 0 | 2 | OAK | BOS | 2015 | 2015 | DET |
7127 | 7127 | Josh Harrison | 27 | harrijo05 | 2015 | PIT | NL | 4.380487805 | 1.525 | 3B, 2B, RF, LF | 12 | 1 | PIT | 2011 | 2018 | DET | |
7132 | 7132 | Jordy Mercer | 28 | mercejo03 | 2015 | PIT | NL | 4.195121951 | 0.34 | SS | 8 | 1 | PIT | 2012 | 2018 | DET | |
7165 | 7165 | Justin Upton | 27 | uptonju01 | 2015 | SDP | NL | 6.306559102 | 3.83 | LF | 21 | 1 | SDP | ATL | 2015 | 2015 | DET |
7243 | 7243 | Logan Kensing | 32 | kensilo01 | 2015 | SEA | AL | 0.505065315 | -0.18 | P | 0 | 1 | SEA | COL | 2015 | 2015 | DET |
7253 | 7253 | John Hicks | 25 | hicksjo02 | 2015 | SEA | AL | 0.322961022 | -0.55 | C, 3B | 0 | 1 | SEA | 2015 | 2015 | DET | |
7367 | 7367 | Mikie Mahtook | 25 | mahtomi01 | 2015 | TBR | AL | 1.102297141 | 1.34 | LF, CF, RF | 5 | 1 | TBD | 2015 | 2016 | DET | |
7396 | 7396 | Marc Krauss | 27 | krausma01 | 2015 | TBR | AL | 0.095851925 | -0.18 | 1B, LF | 0 | 2 | TBD | ANA | 2015 | 2015 | DET |
7436 | 7436 | Bobby Wilson | 32 | wilsobo02 | 2015 | TEX | AL | 0.827899432 | 0.25 | C | 2 | 2 | TEX | TBD | 2015 | 2015 | DET |
7437 | 7437 | Neftali Feliz | 27 | felizne01 | 2015 | TEX | AL | 0.902871068 | 0.075 | P | 2 | 1 | TEX | 2009 | 2015 | DET | |
7493 | 7493 | Daniel Norris | 22 | norrida01 | 2015 | TOR | AL | 0.669819118 | 0.16 | P | 1 | 1 | TOR | 2014 | 2015 | DET | |
7496 | 7496 | Mark Lowe | 32 | lowema01 | 2015 | TOR | AL | 0.649867059 | 0.085 | P | 1 | 2 | TOR | SEA | 2015 | 2015 | DET |
7514 | 7514 | Matthew Boyd | 24 | boydma01 | 2015 | TOR | AL | 0.190358929 | -0.45 | P | 0 | 1 | TOR | 2015 | 2015 | DET | |
7517 | 7517 | Jordan Zimmermann | 29 | zimmejo02 | 2015 | WSN | NL | 5.59641262 | 3.03 | P | 16 | 1 | WSN | 2009 | 2015 | DET | |
7536 | 7536 | Matt den Dekker | 27 | dendema01 | 2015 | WSN | NL | 1.108216085 | 0.5 | LF, RF, CF | 3 | 1 | WSN | NYM | 2015 | 2016 | DET |
7706 | 7706 | Yoenis Cespedes | 28 | cespeyo01 | 2014 | BOS | AL | 1.990654206 | 1.085 | LF, CF | 6 | 2 | BOS | OAK | 2014 | 2014 | DET |
7721 | 7721 | Alex Wilson | 27 | wilsoal01 | 2014 | BOS | AL | 0.676637246 | 0.26 | P | 2 | 1 | BOS | 2013 | 2014 | DET | |
7847 | 7847 | Alfredo Simon | 33 | simonal01 | 2014 | CIN | NL | 5.467142234 | 1.64 | P | 12 | 1 | CIN | BAL | 2012 | 2014 | DET |
7902 | 7902 | Zach McAllister | 26 | mcallza01 | 2014 | CLE | AL | 2.457308895 | 0.655 | P | 5 | 1 | CLE | 2011 | 2018 | DET | |
7904 | 7904 | Mike Aviles | 33 | avilemi01 | 2014 | CLE | AL | 3.49814546 | -0.155 | 3B, 2B, LF, SS, CF, RF | 5 | 1 | CLE | BOS | 2013 | 2015 | DET |
8067 | 8067 | Jose Cisnero | 25 | cisnejo01 | 2014 | HOU | AL | 0.16289851 | -0.155 | P | 0 | 1 | HOU | 2013 | 2014 | DET | |
8148 | 8148 | Efren Navarro | 28 | navaref01 | 2014 | LAA | AL | 1.612398147 | 0.2 | 1B, LF, RF | 3 | 1 | ANA | 2011 | 2015 | DET | |
8264 | 8264 | Randy Wolf | 37 | wolfra02 | 2014 | MIA | NL | 0.618999698 | -0.145 | P | 0 | 1 | FLA | BAL | 2014 | 2014 | DET |
8290 | 8290 | Francisco Rodriguez | 32 | rodrifr03 | 2014 | MIL | NL | 2.608654858 | 0.39 | P | 5 | 1 | MIL | BAL | 2014 | 2015 | DET |
8297 | 8297 | Tom Gorzelanny | 31 | gorzeto01 | 2014 | MIL | NL | 0.44825993 | 0.41 | P | 2 | 1 | MIL | WSN | 2013 | 2014 | DET |
8356 | 8356 | Mike Pelfrey | 30 | pelfrmi01 | 2014 | MIN | AL | 0.677860845 | -0.64 | P | 0 | 1 | MIN | NYM | 2013 | 2015 | DET |
8395 | 8395 | Bobby Parnell | 29 | parnebo01 | 2014 | NYM | NL | 0.053832289 | -0.06 | P | 0 | 1 | NYM | 2008 | 2015 | DET | |
8426 | 8426 | Shane Greene | 25 | greensh02 | 2014 | NYY | AL | 2.054298166 | 0.805 | P | 5 | 1 | NYY | 2014 | 2014 | DET | |
8508 | 8508 | Jim Johnson | 31 | johnsji04 | 2014 | OAK | AL | 1.052201144 | -0.96 | P | 0 | 1 | OAK | BAL | 2014 | 2014 | DET |
8560 | 8560 | Josh Harrison | 26 | harrijo05 | 2014 | PIT | NL | 5.428863172 | 5.125 | 3B, LF, RF, 2B, SS | 23 | 1 | PIT | 2011 | 2018 | DET | |
8563 | 8563 | Jordy Mercer | 27 | mercejo03 | 2014 | PIT | NL | 5.478216474 | 2.395 | SS, RF | 15 | 1 | PIT | 2012 | 2018 | DET | |
8795 | 8795 | David Price | 28 | priceda01 | 2014 | TBR | AL | 4.689064577 | 2.925 | P | 14 | 1 | TBD | 2008 | 2014 | DET | |
8846 | 8846 | Joakim Soria | 30 | soriajo01 | 2014 | TEX | AL | 1.276265465 | 1.145 | P | 5 | 1 | TEX | KCR | 2013 | 2014 | DET |
8851 | 8851 | Neftali Feliz | 26 | felizne01 | 2014 | TEX | AL | 1.285491481 | 0.59 | P | 4 | 1 | TEX | 2009 | 2015 | DET | |
8859 | 8859 | Josh Wilson | 33 | wilsojo03 | 2014 | TEX | AL | 0.695536309 | 0.305 | 2B, 3B, SS | 2 | 1 | TEX | ARI | 2014 | 2014 | DET |
8869 | 8869 | Jim Adduci | 29 | adducji02 | 2014 | TEX | AL | 1.101265823 | -0.055 | LF, RF, 1B | 1 | 1 | TEX | 2013 | 2014 | DET | |
8913 | 8913 | Anthony Gose | 23 | gosean01 | 2014 | TOR | AL | 2.587852141 | 0.765 | CF, RF, LF | 6 | 1 | TOR | 2012 | 2014 | DET | |
8937 | 8937 | Daniel Norris | 21 | norrida01 | 2014 | TOR | AL | 0.180121582 | -0.065 | P | 0 | 1 | TOR | 2014 | 2015 | DET | |
8953 | 8953 | Jordan Zimmermann | 28 | zimmejo02 | 2014 | WSN | NL | 5.499694184 | 5.265 | P | 23 | 1 | WSN | 2009 | 2015 | DET | |
9145 | 9145 | Jose Iglesias | 23 | iglesjo01 | 2013 | BOS | AL | 2.136313553 | 1.665 | SS, 3B, 2B | 8 | 1 | BOS | 2011 | 2013 | DET | |
9162 | 9162 | Alex Wilson | 26 | wilsoal01 | 2013 | BOS | AL | 0.721333525 | 0.07 | P | 1 | 1 | BOS | 2013 | 2014 | DET | |
9299 | 9299 | Alfredo Simon | 32 | simonal01 | 2013 | CIN | NL | 2.322683275 | 0.62 | P | 5 | 1 | CIN | BAL | 2012 | 2014 | DET |
9334 | 9334 | Zach McAllister | 25 | mcallza01 | 2013 | CLE | AL | 3.825425029 | 1.22 | P | 10 | 1 | CLE | 2011 | 2018 | DET | |
9339 | 9339 | Mike Aviles | 32 | avilemi01 | 2013 | CLE | AL | 3.719401042 | 0.37 | 3B, SS, 2B, LF, RF | 7 | 1 | CLE | BOS | 2013 | 2015 | DET |
9355 | 9355 | Ezequiel Carrera | 26 | carreez01 | 2013 | CLE | AL | 0.047200521 | 0.025 | RF, CF, LF | 0 | 2 | CLE | PHI | 2013 | 2013 | DET |
9463 | 9463 | Jose Veras | 32 | verasjo01 | 2013 | HOU | AL | 1.606767064 | 0.85 | P | 5 | 1 | HOU | MIL | 2013 | 2013 | DET |
9476 | 9476 | Jose Cisnero | 24 | cisnejo01 | 2013 | HOU | AL | 1.368099398 | 0.06 | P | 2 | 1 | HOU | 2013 | 2014 | DET |
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 );