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,142 rows where prev_franch = "ANA" sorted by def_pos
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1334 | 1334 | Joe Hudson | 28 | hudsojo03 | 2019 | STL | NL | 0.010113339 | -0.015283019 | 0 | 1 | STL | ANA | 2019 | 2019 | ||
25800 | 25800 | Chuck Finley | 38 | finlech01 | 2001 | CLE | AL | 3.097891566 | 1.025 | 7 | 1 | CLE | ANA | 2000 | 2002 | STL | |
26343 | 26343 | Mike Magnante | 36 | magnami01 | 2001 | OAK | AL | 1.920391198 | 0.52 | 4 | 1 | OAK | ANA | 2000 | 2002 | ||
26403 | 26403 | Matt Walbeck | 31 | walbema01 | 2001 | PHI | NL | 0.009897611 | 0.025 | 0 | 1 | PHI | ANA | 2001 | 2001 | DET | |
27252 | 27252 | Steve Sparks | 34 | sparkst01 | 2000 | DET | AL | 2.571565367 | 1.745 | 8 | 1 | DET | ANA | 2000 | 2003 | OAK | |
28313 | 28313 | Mike Fetters | 34 | fettemi01 | 1999 | BAL | AL | 0.79963912 | -0.3 | 0 | 1 | BAL | ANA | 1999 | 1999 | LAD | |
28531 | 28531 | Rich DeLucia | 34 | delucri01 | 1999 | CLE | AL | 0.217002044 | -0.17 | 0 | 1 | CLE | ANA | 1999 | 1999 | ||
28989 | 28989 | Jason Grimsley | 31 | grimsja01 | 1999 | NYY | AL | 2.251675691 | 0.52 | 5 | 1 | NYY | ANA | 1999 | 2000 | KCR | |
29007 | 29007 | Jeff Juden | 28 | judenje01 | 1999 | NYY | AL | 0.13422049 | -0.165 | 0 | 1 | NYY | ANA | 1999 | 1999 | ||
29376 | 29376 | Matt Perisho | 24 | perisma01 | 1999 | TEX | AL | 0.194592266 | 0.445 | 2 | 1 | TEX | ANA | 1998 | 2000 | DET | |
29442 | 29442 | Dave Hollins | 33 | hollida01 | 1999 | TOR | AL | 0.950220542 | -0.535 | 0 | 1 | TOR | ANA | 1999 | 1999 | CLE | |
29739 | 29739 | Jim Abbott | 30 | abbotji01 | 1998 | CHW | AL | 0.899361396 | 0.511840491 | 3 | 1 | CHW | ANA | 1998 | 1998 | MIL | |
30669 | 30669 | Brad Pennington | 29 | pennibr01 | 1998 | TBD | AL | 0.0 | 0.0 | 0 | 1 | TBD | ANA | 1998 | 1998 | ||
30711 | 30711 | Scott Bailes | 36 | bailesc01 | 1998 | TEX | AL | 0.999810418 | -0.11 | 1 | 1 | TEX | ANA | 1997 | 1998 | ||
30712 | 30712 | Greg Cadaret | 36 | cadargr01 | 1998 | TEX | AL | 0.253395478 | 0.045 | 0 | 2 | TEX | ANA | 1998 | 1998 | ||
30720 | 30720 | Matt Perisho | 23 | perisma01 | 1998 | TEX | AL | 0.140469232 | -0.5 | 0 | 1 | TEX | ANA | 1998 | 2000 | DET | |
31085 | 31085 | Brian Anderson | 25 | anderbr02 | 1997 | CLE | AL | 1.350772321 | 0.382360248 | 3 | 1 | CLE | ANA | 1996 | 1997 | ARI | |
31285 | 31285 | Chili Davis | 37 | davisch01 | 1997 | KCR | AL | 5.239961759 | 2.465217391 | 13 | 1 | KCR | ANA | 1997 | 1997 | NYY | |
31329 | 31329 | Mitch Williams | 32 | willimi02 | 1997 | KCR | AL | 0.137176451 | -0.176086957 | 0 | 1 | KCR | ANA | 1997 | 1997 | ||
31366 | 31366 | Eddie Murray | 41 | murraed02 | 1997 | LAD | NL | 0.089475489 | 0.05 | 0 | 2 | LAD | ANA | 1997 | 1997 | ||
31389 | 31389 | Mike Fetters | 32 | fettemi01 | 1997 | MIL | AL | 2.582035948 | 1.09173913 | 7 | 1 | MIL | ANA | 1992 | 1997 | OAK | |
31801 | 31801 | Mark Holzemer | 27 | holzema01 | 1997 | SEA | AL | 0.249605828 | 0.05 | 0 | 1 | SEA | ANA | 1997 | 1997 | OAK | |
31935 | 31935 | Scott Bailes | 35 | bailesc01 | 1997 | TEX | AL | 0.613887323 | 0.245 | 2 | 1 | TEX | ANA | 1997 | 1998 | ||
32260 | 32260 | Joe Magrane | 31 | magrajo01 | 1996 | CHW | AL | 1.7135127 | -0.44 | 1 | 1 | CHW | ANA | 1996 | 1996 | ||
32261 | 32261 | Kirk McCaskill | 35 | mccaski01 | 1996 | CHW | AL | 1.700081222 | -0.45 | 1 | 1 | CHW | ANA | 1992 | 1996 | ||
32300 | 32300 | Lee Smith | 38 | smithle02 | 1996 | CIN | NL | 1.439796505 | 0.355 | 3 | 2 | CIN | ANA | 1996 | 1996 | WSN | |
32346 | 32346 | Brian Anderson | 24 | anderbr02 | 1996 | CLE | AL | 1.496290624 | 0.558447205 | 4 | 1 | CLE | ANA | 1996 | 1997 | ARI | |
32582 | 32582 | Julio Valera | 27 | valerju01 | 1996 | KCR | AL | 1.760559843 | -0.045279503 | 2 | 1 | KCR | ANA | 1996 | 1996 | ||
32645 | 32645 | Mike Fetters | 31 | fettemi01 | 1996 | MIL | AL | 2.507043297 | 1.39 | 8 | 1 | MIL | ANA | 1992 | 1997 | OAK | |
32719 | 32719 | Erik Bennett | 27 | benneer01 | 1996 | MIN | AL | 0.827528491 | -0.645 | 0 | 1 | MIN | ANA | 1996 | 1996 | ||
33499 | 33499 | Kirk McCaskill | 34 | mccaski01 | 1995 | CHW | AL | 3.004846403 | -0.128482759 | 3 | 1 | CHW | ANA | 1992 | 1996 | ||
33505 | 33505 | Andrew Lorraine | 22 | lorraan01 | 1995 | CHW | AL | 0.211613445 | 0.139655172 | 1 | 1 | CHW | ANA | 1995 | 1995 | OAK | |
33601 | 33601 | John Farrell | 32 | farrejo03 | 1995 | CLE | AL | 0.127627275 | 0.084375 | 0 | 1 | CLE | ANA | 1995 | 1995 | DET | |
33728 | 33728 | Bryan Harvey | 32 | harvebr01 | 1995 | FLA | NL | 0.0 | 0.0 | 0 | 1 | FLA | ANA | 1993 | 1995 | ||
33904 | 33904 | Mike Fetters | 30 | fettemi01 | 1995 | MIL | AL | 1.72775407 | 0.68625 | 4 | 1 | MIL | ANA | 1992 | 1997 | OAK | |
34697 | 34697 | Kirk McCaskill | 33 | mccaski01 | 1994 | CHW | AL | 2.71455811 | 0.974867257 | 6 | 1 | CHW | ANA | 1992 | 1996 | ||
34892 | 34892 | Bryan Harvey | 31 | harvebr01 | 1994 | FLA | NL | 0.449278344 | 0.063391304 | 1 | 1 | FLA | ANA | 1993 | 1995 | ||
35014 | 35014 | Mike Fetters | 29 | fettemi01 | 1994 | MIL | AL | 2.498413423 | 1.718608696 | 8 | 1 | MIL | ANA | 1992 | 1997 | OAK | |
35150 | 35150 | Jim Abbott | 26 | abbotji01 | 1994 | NYY | AL | 6.238011707 | 2.25079646 | 15 | 1 | NYY | ANA | 1993 | 1994 | CHW | |
35415 | 35415 | Steve Frey | 30 | freyst01 | 1994 | SFG | NL | 1.290200568 | -0.457826087 | 0 | 1 | SFG | ANA | 1994 | 1995 | SEA | |
35577 | 35577 | Fernando Valenzuela | 32 | valenfe01 | 1993 | BAL | AL | 4.734530176 | 0.925 | 9 | 1 | BAL | ANA | 1993 | 1993 | PHI | |
35743 | 35743 | Kirk McCaskill | 32 | mccaski01 | 1993 | CHW | AL | 3.434585381 | 0.325 | 6 | 1 | CHW | ANA | 1992 | 1996 | ||
35844 | 35844 | Cliff Young | 28 | youngcl01 | 1993 | CLE | AL | 1.866820512 | 0.07 | 3 | 1 | CLE | ANA | 1993 | 1993 | ||
35959 | 35959 | Bryan Harvey | 30 | harvebr01 | 1993 | FLA | NL | 3.159426677 | 3.285 | 14 | 1 | FLA | ANA | 1993 | 1995 | ||
36132 | 36132 | Mike Fetters | 28 | fettemi01 | 1993 | MIL | AL | 1.862999409 | 0.265 | 3 | 1 | MIL | ANA | 1992 | 1997 | OAK | |
36293 | 36293 | Jim Abbott | 25 | abbotji01 | 1993 | NYY | AL | 5.818724367 | 1.94 | 13 | 1 | NYY | ANA | 1993 | 1994 | CHW | |
36312 | 36312 | Rich Monteleone | 30 | monteri01 | 1993 | NYY | AL | 2.354348696 | -0.435 | 2 | 1 | NYY | ANA | 1990 | 1993 | SFG | |
36316 | 36316 | Mike Witt | 32 | wittmi01 | 1993 | NYY | AL | 1.120795893 | -0.115 | 1 | 1 | NYY | ANA | 1990 | 1993 | ||
36657 | 36657 | Gene Nelson | 32 | nelsoge01 | 1993 | TEX | AL | 0.280903508 | 0.17 | 1 | 2 | TEX | ANA | 1993 | 1993 | ||
36688 | 36688 | Mark Eichhorn | 32 | eichhma01 | 1993 | TOR | AL | 2.008486675 | 1.28 | 7 | 1 | TOR | ANA | 1992 | 1993 | BAL | |
36916 | 36916 | Kirk McCaskill | 31 | mccaski01 | 1992 | CHW | AL | 5.485205024 | 1.42 | 12 | 1 | CHW | ANA | 1992 | 1996 | ||
37192 | 37192 | Mike Fetters | 27 | fettemi01 | 1992 | MIL | AL | 2.281271271 | 1.365 | 7 | 1 | MIL | ANA | 1992 | 1997 | OAK | |
37356 | 37356 | Rich Monteleone | 29 | monteri01 | 1992 | NYY | AL | 2.985901602 | 1.315 | 7 | 1 | NYY | ANA | 1990 | 1993 | SFG | |
37671 | 37671 | Bob McClure | 40 | mcclubo01 | 1992 | STL | NL | 1.758301517 | -0.225 | 2 | 1 | STL | ANA | 1991 | 1992 | FLA | |
37692 | 37692 | Brian Downing | 41 | downibr01 | 1992 | TEX | AL | 3.635460083 | 2.395 | 12 | 1 | TEX | ANA | 1991 | 1992 | ||
37731 | 37731 | Floyd Bannister | 37 | bannifl01 | 1992 | TEX | AL | 1.164314707 | -0.39 | 0 | 1 | TEX | ANA | 1992 | 1992 | ||
37760 | 37760 | Mark Eichhorn | 31 | eichhma01 | 1992 | TOR | AL | 0.734770114 | 0.27 | 2 | 2 | TOR | ANA | 1992 | 1993 | BAL | |
38458 | 38458 | Rich Monteleone | 28 | monteri01 | 1991 | NYY | AL | 1.319254473 | 0.12 | 2 | 1 | NYY | ANA | 1990 | 1993 | SFG | |
38466 | 38466 | Mike Witt | 30 | wittmi01 | 1991 | NYY | AL | 0.148906345 | -0.135 | 0 | 1 | NYY | ANA | 1990 | 1993 | ||
38777 | 38777 | Brian Downing | 40 | downibr01 | 1991 | TEX | AL | 4.286956522 | 2.42 | 13 | 1 | TEX | ANA | 1991 | 1992 | ||
38846 | 38846 | Dave Parker | 40 | parkeda01 | 1991 | TOR | AL | 0.376195881 | 0.125 | 1 | 2 | TOR | ANA | 1991 | 1991 | ||
39214 | 39214 | Dan Petry | 31 | petryda01 | 1990 | DET | AL | 4.143294286 | 1.09 | 9 | 1 | DET | ANA | 1990 | 1991 | ATL | |
39564 | 39564 | Mike Witt | 29 | wittmi01 | 1990 | NYY | AL | 2.608845053 | 0.85 | 6 | 2 | NYY | ANA | 1990 | 1993 | ||
39583 | 39583 | Rich Monteleone | 27 | monteri01 | 1990 | NYY | AL | 0.152403119 | 0.07 | 0 | 1 | NYY | ANA | 1990 | 1993 | SFG | |
39792 | 39792 | Vance Lovelace | 26 | lovelva01 | 1990 | SEA | AL | 0.049637119 | -0.04 | 0 | 1 | SEA | ANA | 1990 | 1990 | ||
39971 | 39971 | Jim Eppard | 30 | epparji01 | 1990 | TOR | AL | 0.055921581 | -0.005 | 0 | 1 | TOR | ANA | 1990 | 1990 | ||
40195 | 40195 | Jerry Reuss | 40 | reussje01 | 1989 | CHW | AL | 3.003000778 | 0.115714286 | 4 | 1 | CHW | ANA | 1988 | 1989 | MIL | |
40496 | 40496 | Ray Krawczyk | 29 | krawcra01 | 1989 | MIL | AL | 0.032438905 | 0.005 | 0 | 1 | MIL | ANA | 1989 | 1989 | ||
40534 | 40534 | Mike Cook | 25 | cookmi01 | 1989 | MIN | AL | 0.520789314 | -0.025 | 1 | 1 | MIN | ANA | 1989 | 1989 | BAL | |
40575 | 40575 | Urbano Lugo | 26 | lugour01 | 1989 | MON | NL | 0.062391753 | -0.025 | 0 | 1 | WSN | ANA | 1989 | 1989 | DET | |
41046 | 41046 | DeWayne Buice | 31 | buicede01 | 1989 | TOR | AL | 0.375486038 | -0.25 | 0 | 1 | TOR | ANA | 1989 | 1989 | ||
41113 | 41113 | Don Aase | 33 | aasedo01 | 1988 | BAL | AL | 1.282238798 | -0.010062112 | 2 | 1 | BAL | ANA | 1985 | 1988 | NYM | |
41257 | 41257 | Jerry Reuss | 39 | reussje01 | 1988 | CHW | AL | 5.025449732 | 2.535652174 | 15 | 1 | CHW | ANA | 1988 | 1989 | MIL | |
41846 | 41846 | Miguel Garcia | 21 | garcimi02 | 1988 | PIT | NL | 0.031798216 | -0.0759375 | 0 | 1 | PIT | ANA | 1987 | 1989 | ||
42151 | 42151 | Don Aase | 32 | aasedo01 | 1987 | BAL | AL | 0.358592448 | 0.14 | 1 | 1 | BAL | ANA | 1985 | 1988 | NYM | |
42166 | 42166 | Doug Corbett | 34 | corbedo01 | 1987 | BAL | AL | 0.656061184 | -0.45 | 0 | 1 | BAL | ANA | 1987 | 1987 | ||
42756 | 42756 | Al Holland | 34 | hollaal01 | 1987 | NYY | AL | 0.121357463 | -0.19 | 0 | 1 | NYY | ANA | 1986 | 1987 | ||
42880 | 42880 | Miguel Garcia | 20 | garcimi02 | 1987 | PIT | NL | 0.009942238 | 0.01 | 0 | 2 | PIT | ANA | 1987 | 1989 | ||
43178 | 43178 | Don Aase | 31 | aasedo01 | 1986 | BAL | AL | 3.669850371 | 2.085 | 11 | 1 | BAL | ANA | 1985 | 1988 | NYM | |
43467 | 43467 | Jim Slaton | 36 | slatoji01 | 1986 | DET | AL | 1.005036915 | 0.065 | 2 | 2 | DET | ANA | 1986 | 1986 | ||
43780 | 43780 | Al Holland | 33 | hollaal01 | 1986 | NYY | AL | 1.125185173 | 0.005 | 2 | 1 | NYY | ANA | 1986 | 1987 | ||
44182 | 44182 | Dave Schuler | 31 | schulda01 | 1985 | ATL | NL | 0.213027281 | -0.16 | 0 | 1 | ATL | ANA | 1985 | 1985 | ||
44197 | 44197 | Don Aase | 30 | aasedo01 | 1985 | BAL | AL | 3.592298848 | 0.875403727 | 8 | 1 | BAL | ANA | 1985 | 1988 | NYM | |
44221 | 44221 | Dan Ford | 33 | fordda01 | 1985 | BAL | AL | 0.765614939 | -0.729503106 | 0 | 1 | BAL | ANA | 1982 | 1985 | ||
44238 | 44238 | Bruce Kison | 35 | kisonbr01 | 1985 | BOS | AL | 2.963504208 | 1.113128834 | 6 | 1 | BOS | ANA | 1985 | 1985 | ||
44241 | 44241 | Mark Clear | 29 | clearma01 | 1985 | BOS | AL | 1.463627117 | 0.392576687 | 3 | 1 | BOS | ANA | 1981 | 1985 | MIL | |
44257 | 44257 | Jim Dorsey | 29 | dorseji01 | 1985 | BOS | AL | 0.11746827 | -0.402515337 | 0 | 1 | BOS | ANA | 1984 | 1985 | ||
44778 | 44778 | Don Baylor | 36 | baylodo01 | 1985 | NYY | AL | 5.245670301 | 0.734534161 | 9 | 1 | NYY | ANA | 1983 | 1985 | BOS | |
44831 | 44831 | Tommy John | 42 | johnto01 | 1985 | OAK | AL | 1.322344352 | -0.315 | 1 | 2 | OAK | ANA | 1985 | 1985 | NYY | |
45062 | 45062 | Andy Hassler | 33 | hasslan01 | 1985 | STL | NL | 0.255686894 | 0.02 | 0 | 1 | STL | ANA | 1984 | 1985 | ||
45242 | 45242 | Mark Clear | 28 | clearma01 | 1984 | BOS | AL | 2.415765589 | -0.05 | 3 | 1 | BOS | ANA | 1981 | 1985 | MIL | |
45250 | 45250 | Jim Dorsey | 28 | dorseji01 | 1984 | BOS | AL | 0.047299535 | -0.04 | 0 | 1 | BOS | ANA | 1984 | 1985 | ||
45785 | 45785 | Curt Brown | 24 | browncu03 | 1984 | NYY | AL | 0.588085364 | 0.415 | 2 | 1 | NYY | ANA | 1984 | 1984 | WSN | |
46063 | 46063 | Andy Hassler | 32 | hasslan01 | 1984 | STL | NL | 0.080390533 | -0.325 | 0 | 1 | STL | ANA | 1984 | 1985 | ||
46236 | 46236 | Mark Clear | 27 | clearma01 | 1983 | BOS | AL | 2.966640416 | -1.12 | 1 | 1 | BOS | ANA | 1981 | 1985 | MIL | |
46519 | 46519 | Steve Renko | 38 | renkost01 | 1983 | KCR | AL | 3.576316244 | 1.421226994 | 10 | 1 | KCR | ANA | 1983 | 1983 | ||
46772 | 46772 | Dave LaRoche | 35 | larocda01 | 1983 | NYY | AL | 0.015059008 | -0.085 | 0 | 1 | NYY | ANA | 1981 | 1983 | ||
47220 | 47220 | Mark Clear | 26 | clearma01 | 1982 | BOS | AL | 4.874892902 | 1.91 | 13 | 1 | BOS | ANA | 1981 | 1985 | MIL | |
47527 | 47527 | Dave Frost | 29 | frostda01 | 1982 | KCR | AL | 2.416385593 | -0.12 | 3 | 1 | KCR | ANA | 1982 | 1982 | ||
47755 | 47755 | Dave LaRoche | 34 | larocda01 | 1982 | NYY | AL | 1.659022426 | 0.945 | 5 | 1 | NYY | ANA | 1981 | 1983 |
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 );