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,775 rows where next_franch = "CHW" sorted by franch_id
This data as json, copyable, CSV (advanced)
Suggested facets: age, lg_ID, stint_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2208 | 2208 | Odrisamer Despaigne | 31 | despaod01 | 2018 | LAA | AL | 0.501930066 | -0.38 | P | 0 | 2 | ANA | FLA | 2018 | 2018 | CHW |
5195 | 5195 | Geovany Soto | 33 | sotoge01 | 2016 | LAA | AL | 0.828571429 | 0.335 | C, 1B, 3B | 2 | 1 | ANA | CHW | 2016 | 2016 | CHW |
6700 | 6700 | Mat Latos | 27 | latosma01 | 2015 | LAA | AL | 0.069724662 | -0.05 | P | 0 | 3 | ANA | LAD | 2015 | 2015 | CHW |
8154 | 8154 | Gordon Beckham | 27 | beckhgo01 | 2014 | LAA | AL | 0.565266017 | 0.095 | 2B, 3B, SS | 1 | 2 | ANA | CHW | 2014 | 2014 | CHW |
17927 | 17927 | Orlando Cabrera | 32 | cabreor01 | 2007 | LAA | AL | 6.582159624 | 4.495 | SS | 24 | 1 | ANA | BOS | 2005 | 2007 | CHW |
19308 | 19308 | Orlando Cabrera | 31 | cabreor01 | 2006 | LAA | AL | 6.314516129 | 2.44 | SS | 17 | 1 | ANA | BOS | 2005 | 2007 | CHW |
19333 | 19333 | Darin Erstad | 32 | erstada01 | 2006 | LAA | AL | 0.982258065 | -0.06 | CF, 1B | 1 | 1 | ANA | 1996 | 2006 | CHW | |
20675 | 20675 | Orlando Cabrera | 30 | cabreor01 | 2005 | LAA | AL | 5.523361454 | 2.75 | SS | 17 | 1 | ANA | BOS | 2005 | 2007 | CHW |
20676 | 20676 | Darin Erstad | 31 | erstada01 | 2005 | LAA | AL | 6.276119403 | 1.9 | 1B | 15 | 1 | ANA | 1996 | 2006 | CHW | |
20701 | 20701 | Bret Prinz | 28 | prinzbr01 | 2005 | LAA | AL | 0.081980043 | -0.03 | P | 0 | 1 | ANA | NYY | 2005 | 2005 | CHW |
21422 | 21422 | Darin Erstad | 30 | erstada01 | 2004 | ANA | AL | 5.018964143 | 2.47 | 1B | 15 | 1 | ANA | 1996 | 2006 | CHW | |
22774 | 22774 | Darin Erstad | 29 | erstada01 | 2003 | ANA | AL | 2.701656552 | 1.205 | CF | 7 | 1 | ANA | 1996 | 2006 | CHW | |
22780 | 22780 | Scott Schoeneweis | 29 | schoesc01 | 2003 | ANA | AL | 1.027100592 | 0.4 | P | 3 | 1 | ANA | 1999 | 2003 | CHW | |
24106 | 24106 | Darin Erstad | 28 | erstada01 | 2002 | ANA | AL | 6.09703504 | 5.01 | CF, 1B | 24 | 1 | ANA | 1996 | 2006 | CHW | |
24123 | 24123 | Scott Schoeneweis | 28 | schoesc01 | 2002 | ANA | AL | 3.976215404 | 0.045 | P | 6 | 1 | ANA | 1999 | 2003 | CHW | |
25428 | 25428 | Darin Erstad | 27 | erstada01 | 2001 | ANA | AL | 6.696984357 | 2.72 | CF, 1B | 16 | 1 | ANA | 1996 | 2006 | CHW | |
25433 | 25433 | Scott Schoeneweis | 27 | schoesc01 | 2001 | ANA | AL | 5.826001028 | 1.67 | P | 12 | 1 | ANA | 1999 | 2003 | CHW | |
25455 | 25455 | Jamie Burke | 29 | burkeja02 | 2001 | ANA | AL | 0.046766651 | 0.02 | C, 1B | 0 | 1 | ANA | 2001 | 2001 | CHW | |
26764 | 26764 | Darin Erstad | 26 | erstada01 | 2000 | ANA | AL | 6.824066782 | 8.515 | LF, CF, 1B | 34 | 1 | ANA | 1996 | 2006 | CHW | |
26770 | 26770 | Scott Schoeneweis | 26 | schoesc01 | 2000 | ANA | AL | 4.68433806 | 1.125 | P | 10 | 1 | ANA | 1999 | 2003 | CHW | |
26791 | 26791 | Ken Hill | 34 | hillke01 | 2000 | ANA | AL | 2.167654475 | -0.355 | P | 2 | 1 | ANA | TEX | 1997 | 2000 | CHW |
28149 | 28149 | Darin Erstad | 25 | erstada01 | 1999 | ANA | AL | 6.057292519 | 2.205 | 1B, LF, CF | 15 | 1 | ANA | 1996 | 2006 | CHW | |
28154 | 28154 | Ken Hill | 33 | hillke01 | 1999 | ANA | AL | 3.533065391 | 1.1 | P | 8 | 1 | ANA | TEX | 1997 | 2000 | CHW |
28172 | 28172 | Scott Schoeneweis | 25 | schoesc01 | 1999 | ANA | AL | 1.135541354 | 0.025 | 2 | 1 | ANA | 1999 | 2003 | CHW | ||
29449 | 29449 | Darin Erstad | 24 | erstada01 | 1998 | ANA | AL | 5.48410797 | 2.465 | LF, 1B, CF | 16 | 1 | ANA | 1996 | 2006 | CHW | |
29453 | 29453 | Ken Hill | 32 | hillke01 | 1998 | ANA | AL | 2.7733653 | 1.675 | P | 9 | 1 | ANA | TEX | 1997 | 2000 | CHW |
30766 | 30766 | Darin Erstad | 23 | erstada01 | 1997 | ANA | AL | 5.510364322 | 3.04 | 1B, CF | 17 | 1 | ANA | 1996 | 2006 | CHW | |
30777 | 30777 | Ken Hill | 31 | hillke01 | 1997 | ANA | AL | 2.100080127 | 1.37 | P | 7 | 2 | ANA | TEX | 1997 | 2000 | CHW |
30783 | 30783 | Chad Kreuter | 32 | kreutch01 | 1997 | ANA | AL | 2.185929648 | 0.445 | C, 1B | 4 | 2 | ANA | CHW | 1997 | 1997 | CHW |
30787 | 30787 | Chuck McElroy | 29 | mcelrch01 | 1997 | ANA | AL | 0.578186617 | 0.355 | P | 2 | 1 | ANA | CIN | 1996 | 1997 | CHW |
30802 | 30802 | Jorge Fabregas | 27 | fabrejo01 | 1997 | ANA | AL | 0.391645729 | -0.35 | C, 1B | 0 | 1 | ANA | 1994 | 1997 | CHW | |
32152 | 32152 | Don Slaught | 37 | slaugdo01 | 1996 | CAL | AL | 2.056346945 | 0.935776398 | C | 6 | 1 | ANA | PIT | 1996 | 1996 | CHW |
32154 | 32154 | Chuck McElroy | 28 | mcelrch01 | 1996 | CAL | AL | 1.198115985 | 1.00621118 | P | 5 | 2 | ANA | CIN | 1996 | 1997 | CHW |
32155 | 32155 | Darin Erstad | 22 | erstada01 | 1996 | CAL | AL | 2.102247547 | 0.684223602 | CF, LF, RF | 5 | 1 | ANA | 1996 | 2006 | CHW | |
32161 | 32161 | Jorge Fabregas | 26 | fabrejo01 | 1996 | CAL | AL | 2.561253561 | -0.231428571 | C | 3 | 1 | ANA | 1994 | 1997 | CHW | |
32167 | 32167 | Jim Abbott | 28 | abbotji01 | 1996 | CAL | AL | 3.824845452 | -1.046459627 | 2 | 1 | ANA | CHW | 1995 | 1996 | CHW | |
32179 | 32179 | Pat Borders | 33 | bordepa01 | 1996 | CAL | AL | 0.559987338 | -0.241490683 | C, 1B | 0 | 2 | ANA | STL | 1996 | 1996 | CHW |
33390 | 33390 | Tony Phillips | 36 | phillto02 | 1995 | CAL | AL | 6.5543058 | 4.502482759 | 3B, LF, CF | 22 | 1 | ANA | DET | 1995 | 1995 | CHW |
33398 | 33398 | Jim Abbott | 27 | abbotji01 | 1995 | CAL | AL | 2.645875444 | 1.809931034 | 9 | 2 | ANA | CHW | 1995 | 1996 | CHW | |
33409 | 33409 | Jorge Fabregas | 25 | fabrejo01 | 1995 | CAL | AL | 2.527943761 | -0.022344828 | C | 3 | 1 | ANA | 1994 | 1997 | CHW | |
34642 | 34642 | Andrew Lorraine | 21 | lorraan01 | 1994 | CAL | AL | 0.706155696 | -0.711391304 | 0 | 1 | ANA | 1994 | 1994 | CHW | ||
34643 | 34643 | Jorge Fabregas | 24 | fabrejo01 | 1994 | CAL | AL | 1.762322755 | -0.753652174 | C | 0 | 1 | ANA | 1994 | 1997 | CHW | |
34644 | 34644 | Joe Magrane | 29 | magrajo01 | 1994 | CAL | AL | 2.719874447 | -1.345304348 | 0 | 1 | ANA | STL | 1993 | 1994 | CHW | |
35660 | 35660 | Joe Magrane | 28 | magrajo01 | 1993 | CAL | AL | 1.361930475 | 0.665 | P | 4 | 2 | ANA | STL | 1993 | 1994 | CHW |
37909 | 37909 | Kirk McCaskill | 30 | mccaski01 | 1991 | CAL | AL | 4.955773152 | 1.565 | 12 | 1 | ANA | 1985 | 1991 | CHW | ||
37934 | 37934 | Barry Lyons | 31 | lyonsba01 | 1991 | CAL | AL | 0.047933884 | -0.015 | C, 1B | 0 | 2 | ANA | LAD | 1991 | 1991 | CHW |
37936 | 37936 | Chris Cron | 27 | cronch01 | 1991 | CAL | AL | 0.162975207 | -0.125 | 1B | 0 | 1 | ANA | 1991 | 1991 | CHW | |
37943 | 37943 | Shawn Abner | 25 | abnersh01 | 1991 | CAL | AL | 1.00661157 | -0.64 | CF, RF | 0 | 2 | ANA | SDP | 1991 | 1991 | CHW |
39003 | 39003 | Kirk McCaskill | 29 | mccaski01 | 1990 | CAL | AL | 4.800548348 | 2.725 | 14 | 1 | ANA | 1985 | 1991 | CHW | ||
40102 | 40102 | Kirk McCaskill | 28 | mccaski01 | 1989 | CAL | AL | 5.725979727 | 3.895 | 20 | 1 | ANA | 1985 | 1991 | CHW | ||
41181 | 41181 | Kirk McCaskill | 27 | mccaski01 | 1988 | CAL | AL | 3.949430432 | 1.7 | 11 | 1 | ANA | 1985 | 1991 | CHW | ||
42227 | 42227 | Kirk McCaskill | 26 | mccaski01 | 1987 | CAL | AL | 1.993862061 | -0.075 | 2 | 1 | ANA | 1985 | 1991 | CHW | ||
42228 | 42228 | Jerry Reuss | 38 | reussje01 | 1987 | CAL | AL | 2.198588969 | -0.215 | P | 2 | 3 | ANA | CIN | 1987 | 1987 | CHW |
43251 | 43251 | Kirk McCaskill | 25 | mccaski01 | 1986 | CAL | AL | 6.826143511 | 4.905 | 24 | 1 | ANA | 1985 | 1991 | CHW | ||
44268 | 44268 | Kirk McCaskill | 24 | mccaski01 | 1985 | CAL | AL | 5.149894185 | 1.375 | 12 | 1 | ANA | 1985 | 1991 | CHW | ||
44292 | 44292 | Pat Keedy | 27 | keedypa01 | 1985 | CAL | AL | 0.037042951 | 0.115 | 3B, LF | 0 | 1 | ANA | 1985 | 1985 | CHW | |
49215 | 49215 | Todd Cruz | 24 | cruzto02 | 1980 | CAL | AL | 0.425497229 | -0.0405 | SS, 3B, LF, 2B | 0 | 1 | ANA | KCR | 1980 | 1980 | CHW |
52066 | 52066 | Bobby Bonds | 31 | bondsbo01 | 1977 | CAL | AL | 6.442336005 | 5.03 | RF | 23 | 1 | ANA | NYY | 1976 | 1977 | CHW |
52081 | 52081 | Thad Bosley | 20 | bosleth01 | 1977 | CAL | AL | 2.229674464 | 0.485 | CF, LF | 4 | 1 | ANA | 1977 | 1977 | CHW | |
52095 | 52095 | John Verhoeven | 24 | verhojo01 | 1977 | CAL | AL | 0.174201618 | -0.05 | 0 | 1 | ANA | 1976 | 1977 | CHW | ||
52101 | 52101 | Don Kirkwood | 27 | kirkwdo01 | 1977 | CAL | AL | 0.630226532 | -0.315 | 0 | 1 | ANA | 1974 | 1977 | CHW | ||
52105 | 52105 | Rusty Torres | 28 | torreru01 | 1977 | CAL | AL | 0.844429903 | -0.46 | CF, RF, LF | 0 | 1 | ANA | CLE | 1976 | 1977 | CHW |
53046 | 53046 | Bobby Bonds | 30 | bondsbo01 | 1976 | CAL | AL | 4.05733945 | 1.965 | RF, CF | 12 | 1 | ANA | NYY | 1976 | 1977 | CHW |
53053 | 53053 | Rusty Torres | 27 | torreru01 | 1976 | CAL | AL | 2.945609436 | 0.77 | CF, 3B, RF | 7 | 1 | ANA | CLE | 1976 | 1977 | CHW |
53056 | 53056 | Don Kirkwood | 26 | kirkwdo01 | 1976 | CAL | AL | 4.182250569 | 0.12 | 6 | 1 | ANA | 1974 | 1977 | CHW | ||
53061 | 53061 | John Verhoeven | 23 | verhojo01 | 1976 | CAL | AL | 1.613822786 | 0.26 | 3 | 1 | ANA | 1976 | 1977 | CHW | ||
53071 | 53071 | Tim Nordbrook | 26 | nordbti01 | 1976 | CAL | AL | 0.095019659 | -0.08 | 2B, SS | 0 | 2 | ANA | BAL | 1976 | 1976 | CHW |
53938 | 53938 | Don Kirkwood | 25 | kirkwdo01 | 1975 | CAL | AL | 3.406528378 | 0.789875776 | 7 | 1 | ANA | 1974 | 1977 | CHW | ||
54861 | 54861 | Don Kirkwood | 24 | kirkwdo01 | 1974 | CAL | AL | 0.146475155 | -0.149079755 | 0 | 1 | ANA | 1974 | 1977 | CHW | ||
56651 | 56651 | Eddie Fisher | 35 | fisheed02 | 1972 | CAL | AL | 2.479554803 | -0.23516129 | P | 3 | 1 | ANA | CLE | 1969 | 1972 | CHW |
57532 | 57532 | Eddie Fisher | 34 | fisheed02 | 1971 | CAL | AL | 3.374746793 | 0.405 | P | 6 | 1 | ANA | CLE | 1969 | 1972 | CHW |
58418 | 58418 | Jay Johnstone | 24 | johnsja01 | 1970 | CAL | AL | 3.594914356 | 0.755 | CF, RF, LF | 8 | 1 | ANA | 1966 | 1970 | CHW | |
58419 | 58419 | Eddie Fisher | 33 | fisheed02 | 1970 | CAL | AL | 3.743332574 | 0.675 | P | 8 | 1 | ANA | CLE | 1969 | 1972 | CHW |
58422 | 58422 | Tom Bradley | 23 | bradlto01 | 1970 | CAL | AL | 2.000911785 | 0.505 | P | 5 | 1 | ANA | 1969 | 1970 | CHW | |
58427 | 58427 | Tom Egan | 24 | eganto01 | 1970 | CAL | AL | 2.335158043 | 0.155 | C | 4 | 1 | ANA | 1965 | 1970 | CHW | |
58436 | 58436 | Steve Kealey | 23 | kealest01 | 1970 | CAL | AL | 0.622293139 | 0.005 | P | 1 | 1 | ANA | 1968 | 1970 | CHW | |
59329 | 59329 | Jay Johnstone | 23 | johnsja01 | 1969 | CAL | AL | 6.215401185 | 2.444907975 | CF | 17 | 1 | ANA | 1966 | 1970 | CHW | |
59341 | 59341 | Eddie Fisher | 32 | fisheed02 | 1969 | CAL | AL | 2.822711472 | 0.054662577 | P | 4 | 1 | ANA | CLE | 1969 | 1972 | CHW |
59348 | 59348 | Bobby Knoop | 30 | knoopbo01 | 1969 | CAL | AL | 0.884939867 | 0.114294479 | 2B | 2 | 1 | ANA | 1964 | 1969 | CHW | |
59349 | 59349 | Steve Kealey | 22 | kealest01 | 1969 | CAL | AL | 1.070683662 | -0.019877301 | P | 2 | 1 | ANA | 1968 | 1970 | CHW | |
59350 | 59350 | Tom Egan | 23 | eganto01 | 1969 | CAL | AL | 1.467959074 | -0.198773006 | C | 2 | 1 | ANA | 1965 | 1970 | CHW | |
59367 | 59367 | Tom Bradley | 22 | bradlto01 | 1969 | CAL | AL | 0.058400927 | -0.273312883 | 0 | 1 | ANA | 1969 | 1970 | CHW | ||
60259 | 60259 | Bobby Knoop | 29 | knoopbo01 | 1968 | CAL | AL | 5.605481428 | 3.1 | 2B | 17 | 1 | ANA | 1964 | 1969 | CHW | |
60273 | 60273 | Jay Johnstone | 22 | johnsja01 | 1968 | CAL | AL | 1.29679048 | 0.4 | CF, RF, LF | 3 | 1 | ANA | 1966 | 1970 | CHW | |
60276 | 60276 | Sammy Ellis | 27 | ellissa01 | 1968 | CAL | AL | 4.793319415 | -1.215 | P | 3 | 1 | ANA | CIN | 1968 | 1968 | CHW |
60282 | 60282 | Steve Kealey | 21 | kealest01 | 1968 | CAL | AL | 0.292275574 | 0.085 | 1 | 1 | ANA | 1968 | 1970 | CHW | ||
60290 | 60290 | Woodie Held | 36 | heldwo01 | 1968 | CAL | AL | 0.55427335 | -0.24 | RF, LF, 3B, 2B, SS, CF | 0 | 1 | ANA | BAL | 1967 | 1968 | CHW |
60294 | 60294 | Tom Egan | 22 | eganto01 | 1968 | CAL | AL | 0.470609448 | -0.395 | C | 0 | 1 | ANA | 1965 | 1970 | CHW | |
60991 | 60991 | Bobby Knoop | 28 | knoopbo01 | 1967 | CAL | AL | 5.937919768 | 1.876583851 | 2B | 15 | 1 | ANA | 1964 | 1969 | CHW | |
61004 | 61004 | Woodie Held | 35 | heldwo01 | 1967 | CAL | AL | 1.747685605 | 0.69931677 | 3B, SS, CF, 2B, LF, RF | 5 | 2 | ANA | BAL | 1967 | 1968 | CHW |
61005 | 61005 | Jay Johnstone | 21 | johnsja01 | 1967 | CAL | AL | 2.49518969 | 0.291801242 | CF, LF, RF | 5 | 1 | ANA | 1966 | 1970 | CHW | |
61015 | 61015 | Tom Egan | 21 | eganto01 | 1967 | CAL | AL | 0.010528227 | -0.015093168 | C | 0 | 1 | ANA | 1965 | 1970 | CHW | |
61770 | 61770 | Bobby Knoop | 27 | knoopbo01 | 1966 | CAL | AL | 6.693892045 | 3.05 | 2B | 20 | 1 | ANA | 1964 | 1969 | CHW | |
61785 | 61785 | Jay Johnstone | 20 | johnsja01 | 1966 | CAL | AL | 2.759943182 | 0.35 | LF, CF, RF | 6 | 1 | ANA | 1966 | 1970 | CHW | |
61804 | 61804 | Tom Egan | 20 | eganto01 | 1966 | CAL | AL | 0.123579545 | -0.315 | C | 0 | 1 | ANA | 1965 | 1970 | CHW | |
62494 | 62494 | Bobby Knoop | 26 | knoopbo01 | 1965 | CAL | AL | 5.286075949 | 2.265 | 2B | 14 | 1 | ANA | 1964 | 1969 | CHW | |
62524 | 62524 | Tom Egan | 19 | eganto01 | 1965 | CAL | AL | 0.430018083 | -0.12 | C | 0 | 1 | ANA | 1965 | 1970 | CHW | |
63518 | 63518 | Bobby Knoop | 25 | knoopbo01 | 1964 | LAA | AL | 5.713308122 | 2.33 | 2B | 15 | 1 | ANA | 1964 | 1969 | CHW | |
1586 | 1586 | Jon Jay | 33 | jayjo02 | 2018 | ARI | NL | 3.186266094 | -0.17 | RF, LF, CF | 4 | 2 | ARI | KCR | 2018 | 2018 | CHW |
9010 | 9010 | Adam Eaton | 24 | eatonad02 | 2013 | ARI | NL | 2.684826203 | 0.115 | LF, CF, RF | 4 | 1 | ARI | 2012 | 2013 | CHW |
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 );