mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
1,795 rows where prev_franch = "MIN" sorted by franch_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
630 | 630 | Adalberto Mejia | 26 | mejiaad01 | 2019 | LAA | AL | 0.442168977 | 0.13245283 | P | 1 | 2 | ANA | MIN | 2019 | 2019 | STL |
640 | 640 | John Curtiss | 26 | curtijo02 | 2019 | LAA | AL | 0.037662222 | 0.015283019 | P | 0 | 1 | ANA | MIN | 2019 | 2019 | |
3670 | 3670 | Ricky Nolasco | 34 | nolasri01 | 2017 | LAA | AL | 5.038844759 | 0.67 | P | 9 | 1 | ANA | MIN | 2016 | 2017 | |
3675 | 3675 | Alex Meyer | 27 | meyeral01 | 2017 | LAA | AL | 1.874487369 | 1.055 | P | 6 | 1 | ANA | MIN | 2016 | 2017 | |
3696 | 3696 | Shane Robinson | 32 | robinsh01 | 2017 | LAA | AL | 0.335426305 | 0.015 | RF, CF, LF | 1 | 1 | ANA | MIN | 2016 | 2017 | NYY |
5177 | 5177 | Ricky Nolasco | 33 | nolasri01 | 2016 | LAA | AL | 2.135018409 | 1.255 | P | 7 | 2 | ANA | MIN | 2016 | 2017 | |
5196 | 5196 | Alex Meyer | 26 | meyeral01 | 2016 | LAA | AL | 0.630310618 | 0.235 | P | 2 | 2 | ANA | MIN | 2016 | 2017 | |
5198 | 5198 | Shane Robinson | 31 | robinsh01 | 2016 | LAA | AL | 1.069435216 | 0.03 | LF, CF, RF | 2 | 1 | ANA | MIN | 2016 | 2017 | NYY |
5203 | 5203 | A.J. Achter | 27 | achteaj01 | 2016 | LAA | AL | 0.837942351 | 0.035 | P | 1 | 1 | ANA | MIN | 2016 | 2016 | |
9592 | 9592 | Brendan Harris | 32 | harribr01 | 2013 | LAA | AL | 1.088023088 | -0.41 | SS, 3B, 1B, 2B, LF | 0 | 1 | ANA | MIN | 2013 | 2013 | |
10975 | 10975 | Torii Hunter | 36 | hunteto01 | 2012 | LAA | AL | 5.55825402 | 5.025 | RF | 22 | 1 | ANA | MIN | 2008 | 2012 | DET |
12414 | 12414 | Torii Hunter | 35 | hunteto01 | 2011 | LAA | AL | 6.204384374 | 2.785 | RF, CF | 17 | 1 | ANA | MIN | 2008 | 2012 | DET |
13795 | 13795 | Torii Hunter | 34 | hunteto01 | 2010 | LAA | AL | 6.179778987 | 3.12 | CF, RF | 19 | 1 | ANA | MIN | 2008 | 2012 | DET |
13835 | 13835 | Mike Ryan | 32 | ryanmi03 | 2010 | LAA | AL | 0.392215075 | -0.245 | LF, 1B | 0 | 1 | ANA | MIN | 2010 | 2010 | |
15151 | 15151 | Torii Hunter | 33 | hunteto01 | 2009 | LAA | AL | 4.672504378 | 4.525 | CF | 21 | 1 | ANA | MIN | 2008 | 2012 | DET |
16528 | 16528 | Torii Hunter | 32 | hunteto01 | 2008 | LAA | AL | 5.749877711 | 2.935 | CF | 19 | 1 | ANA | MIN | 2008 | 2012 | DET |
19334 | 19334 | J.C. Romero | 30 | romerj.01 | 2006 | LAA | AL | 1.330584832 | -0.475 | P | 1 | 1 | ANA | MIN | 2006 | 2006 | BOS |
29487 | 29487 | Rich Robertson | 29 | roberri02 | 1998 | ANA | AL | 0.193376751 | -0.525 | 0 | 1 | ANA | MIN | 1998 | 1998 | ||
32142 | 32142 | Chili Davis | 36 | davisch01 | 1996 | CAL | AL | 5.719214941 | 2.359565217 | 15 | 1 | ANA | MIN | 1993 | 1996 | KCR | |
33393 | 33393 | Chili Davis | 35 | davisch01 | 1995 | CAL | AL | 5.320913884 | 3.726 | 18 | 1 | ANA | MIN | 1993 | 1996 | KCR | |
34611 | 34611 | Chili Davis | 34 | davisch01 | 1994 | CAL | AL | 6.10938555 | 4.275391304 | LF | 21 | 1 | ANA | MIN | 1993 | 1996 | KCR |
35650 | 35650 | Chili Davis | 33 | davisch01 | 1993 | CAL | AL | 6.143865988 | 0.49 | P | 10 | 1 | ANA | MIN | 1993 | 1996 | KCR |
35689 | 35689 | Gary Gaetti | 34 | gaettga01 | 1993 | CAL | AL | 0.533420923 | -0.37 | 3B, 1B | 0 | 1 | ANA | MIN | 1991 | 1993 | KCR |
36840 | 36840 | Bert Blyleven | 41 | blylebe01 | 1992 | CAL | AL | 3.605538462 | 0.825 | 8 | 1 | ANA | MIN | 1989 | 1992 | ||
36844 | 36844 | Gary Gaetti | 33 | gaettga01 | 1992 | CAL | AL | 4.765511412 | -1.025 | 3B, 1B | 4 | 1 | ANA | MIN | 1991 | 1993 | KCR |
37908 | 37908 | Gary Gaetti | 32 | gaettga01 | 1991 | CAL | AL | 6.078016529 | 1.325 | 3B | 13 | 1 | ANA | MIN | 1991 | 1993 | KCR |
39014 | 39014 | Bert Blyleven | 39 | blylebe01 | 1990 | CAL | AL | 3.709637345 | 0.77 | 7 | 1 | ANA | MIN | 1989 | 1992 | ||
40100 | 40100 | Bert Blyleven | 38 | blylebe01 | 1989 | CAL | AL | 6.474626866 | 5.64 | 26 | 1 | ANA | MIN | 1989 | 1992 | ||
42233 | 42233 | Tack Wilson | 31 | wilsota01 | 1987 | CAL | AL | 0.036819552 | -0.005 | LF | 0 | 1 | ANA | MIN | 1987 | 1987 | |
43268 | 43268 | Rob Wilfong | 32 | wilforo01 | 1986 | CAL | AL | 2.910592346 | 0.45 | 2B | 5 | 1 | ANA | MIN | 1982 | 1986 | SFG |
43269 | 43269 | Doug Corbett | 33 | corbedo01 | 1986 | CAL | AL | 2.494681727 | 0.125 | 4 | 1 | ANA | MIN | 1982 | 1986 | BAL | |
44273 | 44273 | Rod Carew | 39 | carewro01 | 1985 | CAL | AL | 4.797062111 | 0.295 | 1B | 9 | 1 | ANA | MIN | 1979 | 1985 | |
44279 | 44279 | Rob Wilfong | 31 | wilforo01 | 1985 | CAL | AL | 2.250359253 | 0.135 | 2B | 4 | 1 | ANA | MIN | 1982 | 1986 | SFG |
44286 | 44286 | Geoff Zahn | 39 | zahnge01 | 1985 | CAL | AL | 1.026476578 | 0.215 | 2 | 1 | ANA | MIN | 1981 | 1985 | ||
44299 | 44299 | Doug Corbett | 32 | corbedo01 | 1985 | CAL | AL | 1.384769438 | -0.6 | 0 | 1 | ANA | MIN | 1982 | 1986 | BAL | |
45259 | 45259 | Geoff Zahn | 38 | zahnge01 | 1984 | CAL | AL | 5.778851767 | 3.875 | 20 | 1 | ANA | MIN | 1981 | 1985 | ||
45268 | 45268 | Doug Corbett | 31 | corbedo01 | 1984 | CAL | AL | 2.634172714 | 2.09 | 10 | 1 | ANA | MIN | 1982 | 1986 | BAL | |
45269 | 45269 | Rod Carew | 38 | carewro01 | 1984 | CAL | AL | 3.555627635 | 0.935 | 1B | 8 | 1 | ANA | MIN | 1979 | 1985 | |
45274 | 45274 | Rob Wilfong | 30 | wilforo01 | 1984 | CAL | AL | 3.16996432 | 0.93 | 2B, SS | 7 | 1 | ANA | MIN | 1982 | 1986 | SFG |
46243 | 46243 | Geoff Zahn | 37 | zahnge01 | 1983 | CAL | AL | 4.816785574 | 3.225 | 16 | 1 | ANA | MIN | 1981 | 1985 | ||
46246 | 46246 | Rod Carew | 37 | carewro01 | 1983 | CAL | AL | 4.939307277 | 2.25 | 1B, 2B | 13 | 1 | ANA | MIN | 1979 | 1985 | |
46266 | 46266 | Doug Corbett | 30 | corbedo01 | 1983 | CAL | AL | 0.483204238 | 0.17 | 1 | 1 | ANA | MIN | 1982 | 1986 | BAL | |
46271 | 46271 | Rob Wilfong | 29 | wilforo01 | 1983 | CAL | AL | 1.750873848 | -0.32 | 2B, 3B, SS | 1 | 1 | ANA | MIN | 1982 | 1986 | SFG |
47249 | 47249 | Rod Carew | 36 | carewro01 | 1982 | CAL | AL | 5.58992126 | 4.505 | 1B | 20 | 1 | ANA | MIN | 1979 | 1985 | |
47251 | 47251 | Geoff Zahn | 36 | zahnge01 | 1982 | CAL | AL | 6.032681735 | 3.145 | 17 | 1 | ANA | MIN | 1981 | 1985 | ||
47264 | 47264 | Rob Wilfong | 28 | wilforo01 | 1982 | CAL | AL | 1.013858268 | 0.675 | 2B, 3B, CF, SS, LF | 3 | 2 | ANA | MIN | 1982 | 1986 | SFG |
47270 | 47270 | Doug Corbett | 29 | corbedo01 | 1982 | CAL | AL | 2.113518778 | -0.32 | 2 | 2 | ANA | MIN | 1982 | 1986 | BAL | |
48240 | 48240 | Rod Carew | 35 | carewro01 | 1981 | CAL | AL | 5.82629444 | 4.182545455 | 1B | 19 | 1 | ANA | MIN | 1979 | 1985 | |
48241 | 48241 | Dan Ford | 29 | fordda01 | 1981 | CAL | AL | 5.66022429 | 2.746636364 | RF | 15 | 1 | ANA | MIN | 1979 | 1981 | BAL |
48247 | 48247 | Geoff Zahn | 35 | zahnge01 | 1981 | CAL | AL | 6.44936988 | 0.382909091 | 9 | 1 | ANA | MIN | 1981 | 1985 | ||
49183 | 49183 | Rod Carew | 34 | carewro01 | 1980 | CAL | AL | 5.786762308 | 3.26025 | 1B | 18 | 1 | ANA | MIN | 1979 | 1985 | |
49202 | 49202 | Dan Ford | 28 | fordda01 | 1980 | CAL | AL | 2.354417998 | -0.354375 | RF | 2 | 1 | ANA | MIN | 1979 | 1981 | BAL |
50137 | 50137 | Dan Ford | 27 | fordda01 | 1979 | CAL | AL | 5.771510062 | 2.305 | RF, CF | 15 | 1 | ANA | MIN | 1979 | 1981 | BAL |
50139 | 50139 | Rod Carew | 33 | carewro01 | 1979 | CAL | AL | 4.530819205 | 2.41 | 1B | 14 | 1 | ANA | MIN | 1979 | 1985 | |
51095 | 51095 | Lyman Bostock | 27 | bostoly01 | 1978 | CAL | AL | 5.953271028 | 2.59 | RF, CF | 17 | 1 | ANA | MIN | 1978 | 1978 | |
56644 | 56644 | Leo Cardenas | 33 | cardele01 | 1972 | CAL | AL | 6.686327078 | 1.290774194 | SS | 14 | 1 | ANA | MIN | 1972 | 1972 | CLE |
60265 | 60265 | Don Mincher | 30 | minchdo01 | 1968 | CAL | AL | 4.779300397 | 0.81 | 1B | 9 | 1 | ANA | MIN | 1967 | 1968 | MIL |
60287 | 60287 | Pete Cimino | 25 | ciminpe01 | 1968 | CAL | AL | 0.204592902 | -0.06 | 0 | 1 | ANA | MIN | 1967 | 1968 | ||
60296 | 60296 | Jimmie Hall | 30 | hallji02 | 1968 | CAL | AL | 1.485034259 | -0.58 | RF, LF, CF | 0 | 1 | ANA | MIN | 1967 | 1968 | CLE |
60987 | 60987 | Don Mincher | 29 | minchdo01 | 1967 | CAL | AL | 5.927391541 | 4.432360248 | 1B, RF | 23 | 1 | ANA | MIN | 1967 | 1968 | MIL |
60992 | 60992 | Jimmie Hall | 29 | hallji02 | 1967 | CAL | AL | 4.706117263 | 1.318136646 | RF, CF, LF | 12 | 1 | ANA | MIN | 1967 | 1968 | CLE |
61006 | 61006 | Pete Cimino | 24 | ciminpe01 | 1967 | CAL | AL | 2.593800979 | 0.160993789 | P | 5 | 1 | ANA | MIN | 1967 | 1968 | |
62528 | 62528 | Don Lee | 31 | leedo01 | 1965 | CAL | AL | 0.407861272 | -0.35 | P | 0 | 1 | ANA | MIN | 1962 | 1965 | HOU |
63525 | 63525 | Don Lee | 30 | leedo01 | 1964 | LAA | AL | 2.644115574 | 1.135 | P | 7 | 1 | ANA | MIN | 1962 | 1965 | HOU |
63538 | 63538 | Vic Power | 36 | powervi01 | 1964 | LAA | AL | 2.475418693 | -0.405 | 1B, 3B, 2B | 3 | 2 | ANA | MIN | 1964 | 1964 | PHI |
63542 | 63542 | Lenny Green | 31 | greenle01 | 1964 | LAA | AL | 1.086259679 | -0.13 | CF, LF | 1 | 2 | ANA | MIN | 1964 | 1964 | BAL |
63546 | 63546 | Jack Spring | 31 | sprinja01 | 1964 | LAA | AL | 0.098661029 | -0.045 | 0 | 1 | ANA | MIN | 1961 | 1964 | CHC | |
64285 | 64285 | Don Lee | 29 | leedo01 | 1963 | LAA | AL | 4.444342648 | 0.799937888 | P | 8 | 1 | ANA | MIN | 1962 | 1965 | HOU |
64297 | 64297 | Jack Spring | 30 | sprinja01 | 1963 | LAA | AL | 1.106275767 | 0.02515528 | P | 2 | 1 | ANA | MIN | 1961 | 1964 | CHC |
64309 | 64309 | Tom Morgan | 33 | morgato01 | 1963 | LAA | AL | 0.471369675 | -0.261614907 | P | 0 | 1 | ANA | MIN | 1961 | 1963 | |
65048 | 65048 | Don Lee | 28 | leedo01 | 1962 | LAA | AL | 4.392905866 | 2.505 | P | 15 | 2 | ANA | MIN | 1962 | 1965 | HOU |
65063 | 65063 | Tom Morgan | 32 | morgato01 | 1962 | LAA | AL | 1.680763984 | 0.41 | P | 4 | 1 | ANA | MIN | 1961 | 1963 | |
65067 | 65067 | Jack Spring | 29 | sprinja01 | 1962 | LAA | AL | 1.862210095 | -0.055 | P | 3 | 1 | ANA | MIN | 1961 | 1964 | CHC |
65762 | 65762 | Tom Morgan | 31 | morgato01 | 1961 | LAA | AL | 2.677329624 | 1.875 | P | 9 | 1 | ANA | MIN | 1961 | 1963 | |
65775 | 65775 | Jack Spring | 28 | sprinja01 | 1961 | LAA | AL | 1.109874826 | 0.43 | P | 3 | 1 | ANA | MIN | 1961 | 1964 | CHC |
65781 | 65781 | Tex Clevenger | 28 | clevete01 | 1961 | LAA | AL | 0.467315716 | 0.28 | P | 1 | 1 | ANA | MIN | 1961 | 1961 | NYY |
65795 | 65795 | Julio Becquer | 29 | becquju01 | 1961 | LAA | AL | 0.089860561 | -0.18 | 1B, LF, RF, P | 0 | 1 | ANA | MIN | 1961 | 1961 | MIN |
65796 | 65796 | Faye Throneberry | 30 | thronfa01 | 1961 | LAA | AL | 0.369426752 | -0.23 | LF, RF | 0 | 1 | ANA | MIN | 1961 | 1961 | |
3 | 3 | Eduardo Escobar | 30 | escobed01 | 2019 | ARI | NL | 6.763216046 | 4.029622642 | 3B, 2B | 21 | 1 | ARI | MIN | 2018 | 2019 | |
34 | 34 | John Ryan Murphy | 28 | murphjr01 | 2019 | ARI | NL | 0.680265171 | -0.030566038 | C, P | 1 | 1 | ARI | MIN | 2017 | 2019 | ATL |
1576 | 1576 | Eduardo Escobar | 29 | escobed01 | 2018 | ARI | NL | 2.220429185 | 1.035 | 3B, SS, 2B | 6 | 2 | ARI | MIN | 2018 | 2019 | |
1585 | 1585 | John Ryan Murphy | 27 | murphjr01 | 2018 | ARI | NL | 2.220429185 | 0.19 | C | 4 | 1 | ARI | MIN | 2017 | 2019 | ATL |
3132 | 3132 | Chris Herrmann | 29 | herrmch01 | 2017 | ARI | NL | 2.527749404 | -0.855 | C, LF, 1B, RF | 1 | 1 | ARI | MIN | 2016 | 2017 | SEA |
3137 | 3137 | John Ryan Murphy | 26 | murphjr01 | 2017 | ARI | NL | 0.069118148 | -0.09 | C | 0 | 1 | ARI | MIN | 2017 | 2019 | ATL |
4603 | 4603 | Chris Herrmann | 28 | herrmch01 | 2016 | ARI | NL | 1.624704691 | 1.145 | C, RF, LF, 1B, CF | 6 | 1 | ARI | MIN | 2016 | 2017 | SEA |
9025 | 9025 | Jason Kubel | 31 | kubelja01 | 2013 | ARI | NL | 2.58790107 | -0.955 | LF, RF | 1 | 1 | ARI | MIN | 2012 | 2013 | CLE |
10408 | 10408 | Jason Kubel | 30 | kubelja01 | 2012 | ARI | NL | 5.732733253 | 1.39 | LF, RF | 12 | 1 | ARI | MIN | 2012 | 2013 | CLE |
13227 | 13227 | Kevin Mulvey | 25 | mulveke01 | 2010 | ARI | NL | 0.048091485 | -0.11 | P | 0 | 1 | ARI | MIN | 2009 | 2010 | |
13233 | 13233 | Augie Ojeda | 35 | ojedaau01 | 2010 | ARI | NL | 0.916996047 | -0.335 | 2B, 3B, SS | 0 | 1 | ARI | MIN | 2007 | 2010 | |
14563 | 14563 | Augie Ojeda | 34 | ojedaau01 | 2009 | ARI | NL | 3.039729501 | 1.465 | 2B, SS, 3B | 8 | 1 | ARI | MIN | 2007 | 2010 | |
14589 | 14589 | Bobby Korecky | 29 | korecbo01 | 2009 | ARI | NL | 0.131270574 | -0.18 | P | 0 | 1 | ARI | MIN | 2009 | 2009 | TOR |
14593 | 14593 | Kevin Mulvey | 24 | mulveke01 | 2009 | ARI | NL | 0.58707118 | -0.345 | P | 0 | 2 | ARI | MIN | 2009 | 2010 | |
15955 | 15955 | Augie Ojeda | 33 | ojedaau01 | 2008 | ARI | NL | 2.731301939 | 0.78 | 2B, 3B, SS | 6 | 1 | ARI | MIN | 2007 | 2010 | |
17348 | 17348 | Augie Ojeda | 32 | ojedaau01 | 2007 | ARI | NL | 1.334262809 | 0.235 | 2B, SS, 3B, P | 3 | 1 | ARI | MIN | 2007 | 2010 | |
17353 | 17353 | Jeff Cirillo | 37 | cirilje01 | 2007 | ARI | NL | 0.44475427 | 0.075 | 3B, 1B, 2B, P | 1 | 2 | ARI | MIN | 2007 | 2007 | |
17363 | 17363 | J.D. Durbin | 25 | durbijd01 | 2007 | ARI | NL | 0.013023908 | -0.115 | P | 0 | 1 | ARI | MIN | 2007 | 2007 | PHI |
18748 | 18748 | Terry Mulholland | 43 | mulhote01 | 2006 | ARI | NL | 0.121310236 | -0.12 | P | 0 | 1 | ARI | MIN | 2006 | 2006 | |
21496 | 21496 | Mike Fetters | 39 | fettemi01 | 2004 | ARI | NL | 0.491773899 | -0.48 | P | 0 | 1 | ARI | MIN | 2004 | 2004 | |
22817 | 22817 | Chad Moeller | 28 | moellch01 | 2003 | ARI | NL | 2.637700761 | 0.81 | C | 6 | 1 | ARI | MIN | 2001 | 2003 | MIL |
22845 | 22845 | Quinton McCracken | 32 | mccraqu01 | 2003 | ARI | NL | 2.216060862 | -1.745 | RF, CF, LF | 0 | 1 | ARI | MIN | 2002 | 2003 | SEA |
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 );