mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
98,796 rows sorted by player_ID
This data as json, copyable, CSV (advanced)
Suggested facets: lg_ID, stint_ID, franch_id, prev_franch, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6162 | 6162 | David Aardsma | 33 | aardsda01 | 2015 | ATL | NL | 0.980178394 | -0.28 | P | 1 | 1 | ATL | NYM | 2015 | 2015 | |
9829 | 9829 | David Aardsma | 31 | aardsda01 | 2013 | NYM | NL | 1.027370618 | -0.315 | P | 0 | 1 | NYM | NYY | 2013 | 2013 | ATL |
11294 | 11294 | David Aardsma | 30 | aardsda01 | 2012 | NYY | AL | 0.01514664 | -0.06 | P | 0 | 1 | NYY | SEA | 2012 | 2012 | NYM |
14261 | 14261 | David Aardsma | 28 | aardsda01 | 2010 | SEA | AL | 2.245460336 | 0.49 | P | 4 | 1 | SEA | BOS | 2009 | 2010 | NYY |
15632 | 15632 | David Aardsma | 27 | aardsda01 | 2009 | SEA | AL | 2.900937227 | 1.845 | P | 10 | 1 | SEA | BOS | 2009 | 2010 | NYY |
16107 | 16107 | David Aardsma | 26 | aardsda01 | 2008 | BOS | AL | 1.291248065 | -0.215 | P | 1 | 1 | BOS | CHW | 2008 | 2008 | SEA |
17583 | 17583 | David Aardsma | 25 | aardsda01 | 2007 | CHW | AL | 1.140911032 | -0.1 | P | 1 | 1 | CHW | CHC | 2007 | 2007 | BOS |
18920 | 18920 | David Aardsma | 24 | aardsda01 | 2006 | CHC | NL | 1.417865182 | 0.185 | P | 2 | 1 | CHC | SFG | 2006 | 2006 | CHW |
22573 | 22573 | David Aardsma | 22 | aardsda01 | 2004 | SFG | NL | 0.306831972 | -0.225 | P | 0 | 1 | SFG | 2004 | 2004 | CHC | |
53386 | 53386 | Hank Aaron | 42 | aaronha01 | 1976 | MIL | AL | 2.949314842 | 0.30689441 | LF | 5 | 1 | MIL | ATL | 1975 | 1976 | |
54276 | 54276 | Hank Aaron | 41 | aaronha01 | 1975 | MIL | AL | 5.178230845 | 0.08 | LF | 8 | 1 | MIL | ATL | 1975 | 1976 | |
54733 | 54733 | Hank Aaron | 40 | aaronha01 | 1974 | ATL | NL | 3.814081598 | 2.067239264 | LF | 11 | 1 | ATL | 1954 | 1974 | MIL | |
55640 | 55640 | Hank Aaron | 39 | aaronha01 | 1973 | ATL | NL | 4.566542499 | 4.93 | LF, RF | 20 | 1 | ATL | 1954 | 1974 | MIL | |
56531 | 56531 | Hank Aaron | 38 | aaronha01 | 1972 | ATL | NL | 5.762989973 | 4.295612903 | 1B, RF | 21 | 1 | ATL | 1954 | 1974 | MIL | |
57417 | 57417 | Hank Aaron | 37 | aaronha01 | 1971 | ATL | NL | 5.835645303 | 7.17 | 1B, RF | 31 | 1 | ATL | 1954 | 1974 | MIL | |
58301 | 58301 | Hank Aaron | 36 | aaronha01 | 1970 | ATL | NL | 6.074255692 | 5.105 | RF, 1B | 23 | 1 | ATL | 1954 | 1974 | MIL | |
59218 | 59218 | Hank Aaron | 35 | aaronha01 | 1969 | ATL | NL | 6.591143518 | 7.83 | RF, 1B | 34 | 1 | ATL | 1954 | 1974 | MIL | |
60150 | 60150 | Hank Aaron | 34 | aaronha01 | 1968 | ATL | NL | 6.953005852 | 6.917300613 | RF, 1B | 30 | 1 | ATL | 1954 | 1974 | MIL | |
60865 | 60865 | Hank Aaron | 33 | aaronha01 | 1967 | ATL | NL | 6.870042493 | 7.905 | RF, CF, 2B | 33 | 1 | ATL | 1954 | 1974 | MIL | |
61651 | 61651 | Hank Aaron | 32 | aaronha01 | 1966 | ATL | NL | 6.872890114 | 7.324785276 | RF, CF, 2B | 30 | 1 | ATL | 1954 | 1974 | MIL | |
62875 | 62875 | Hank Aaron | 31 | aaronha01 | 1965 | MLN | NL | 6.581779435 | 7.735 | RF | 31 | 1 | ATL | 1954 | 1974 | MIL | |
63633 | 63633 | Hank Aaron | 30 | aaronha01 | 1964 | MLN | NL | 6.401810585 | 6.81 | RF, 2B | 29 | 1 | ATL | 1954 | 1974 | MIL | |
64387 | 64387 | Hank Aaron | 29 | aaronha01 | 1963 | MLN | NL | 7.194579569 | 8.706257669 | RF | 35 | 1 | ATL | 1954 | 1974 | MIL | |
65152 | 65152 | Hank Aaron | 28 | aaronha01 | 1962 | MLN | NL | 6.81811773 | 8.35 | CF, RF, 1B | 34 | 1 | ATL | 1954 | 1974 | MIL | |
65875 | 65875 | Hank Aaron | 27 | aaronha01 | 1961 | MLN | NL | 7.108310502 | 9.563225806 | CF, RF, 3B | 38 | 1 | ATL | 1954 | 1974 | MIL | |
66510 | 66510 | Hank Aaron | 26 | aaronha01 | 1960 | MLN | NL | 7.157034009 | 7.879090909 | RF, CF, 2B | 35 | 1 | ATL | 1954 | 1974 | MIL | |
67136 | 67136 | Hank Aaron | 25 | aaronha01 | 1959 | MLN | NL | 7.255234657 | 8.688152866 | RF, CF, 3B | 36 | 1 | ATL | 1954 | 1974 | MIL | |
67781 | 67781 | Hank Aaron | 24 | aaronha01 | 1958 | MLN | NL | 7.163690476 | 7.426753247 | RF, CF | 32 | 1 | ATL | 1954 | 1974 | MIL | |
68397 | 68397 | Hank Aaron | 23 | aaronha01 | 1957 | MLN | NL | 7.035040431 | 8.136580645 | RF, CF | 35 | 1 | ATL | 1954 | 1974 | MIL | |
69012 | 69012 | Hank Aaron | 22 | aaronha01 | 1956 | MLN | NL | 7.053620785 | 7.357935484 | RF | 32 | 1 | ATL | 1954 | 1974 | MIL | |
69666 | 69666 | Hank Aaron | 21 | aaronha01 | 1955 | MLN | NL | 7.067986073 | 6.390584416 | OF, 2B | 29 | 1 | ATL | 1954 | 1974 | MIL | |
70240 | 70240 | Hank Aaron | 20 | aaronha01 | 1954 | MLN | NL | 5.412907957 | 1.299155844 | OF | 12 | 1 | ATL | 1954 | 1974 | MIL | |
57449 | 57449 | Tommie Aaron | 31 | aaronto01 | 1971 | ATL | NL | 0.570324846 | -0.56 | 1B, 3B | 0 | 1 | ATL | 1962 | 1971 | ||
58333 | 58333 | Tommie Aaron | 30 | aaronto01 | 1970 | ATL | NL | 0.670402802 | -0.64 | 1B, LF, RF | 0 | 1 | ATL | 1962 | 1971 | ||
59241 | 59241 | Tommie Aaron | 29 | aaronto01 | 1969 | ATL | NL | 0.680775387 | 0.0 | 1B, LF | 1 | 1 | ATL | 1962 | 1971 | ||
60173 | 60173 | Tommie Aaron | 28 | aaronto01 | 1968 | ATL | NL | 3.167937578 | -0.65595092 | LF, 1B, 3B | 2 | 1 | ATL | 1962 | 1971 | ||
62903 | 62903 | Tommie Aaron | 25 | aaronto01 | 1965 | MLN | NL | 0.175102113 | -0.045 | 1B | 0 | 1 | ATL | 1962 | 1971 | ||
64422 | 64422 | Tommie Aaron | 23 | aaronto01 | 1963 | MLN | NL | 1.511466296 | -1.197607362 | 1B, LF, 2B, 3B, CF | 0 | 1 | ATL | 1962 | 1971 | ||
65164 | 65164 | Tommie Aaron | 22 | aaronto01 | 1962 | MLN | NL | 3.904829045 | 0.86 | 1B, LF, 2B, 3B | 8 | 1 | ATL | 1962 | 1971 | ||
39378 | 39378 | Don Aase | 35 | aasedo01 | 1990 | LAD | NL | 1.266635252 | -0.56 | 0 | 1 | LAD | NYM | 1990 | 1990 | ||
40617 | 40617 | Don Aase | 34 | aasedo01 | 1989 | NYM | NL | 1.879524467 | -0.395 | P | 1 | 1 | NYM | BAL | 1989 | 1989 | LAD |
41113 | 41113 | Don Aase | 33 | aasedo01 | 1988 | BAL | AL | 1.282238798 | -0.010062112 | 2 | 1 | BAL | ANA | 1985 | 1988 | NYM | |
42151 | 42151 | Don Aase | 32 | aasedo01 | 1987 | BAL | AL | 0.358592448 | 0.14 | 1 | 1 | BAL | ANA | 1985 | 1988 | NYM | |
43178 | 43178 | Don Aase | 31 | aasedo01 | 1986 | BAL | AL | 3.669850371 | 2.085 | 11 | 1 | BAL | ANA | 1985 | 1988 | NYM | |
44197 | 44197 | Don Aase | 30 | aasedo01 | 1985 | BAL | AL | 3.592298848 | 0.875403727 | 8 | 1 | BAL | ANA | 1985 | 1988 | NYM | |
45273 | 45273 | Don Aase | 29 | aasedo01 | 1984 | CAL | AL | 1.592928298 | 1.43 | 7 | 1 | ANA | BOS | 1978 | 1984 | BAL | |
47263 | 47263 | Don Aase | 27 | aasedo01 | 1982 | CAL | AL | 2.073641065 | 0.635 | 4 | 1 | ANA | BOS | 1978 | 1984 | BAL | |
48244 | 48244 | Don Aase | 26 | aasedo01 | 1981 | CAL | AL | 3.93854214 | 2.164909091 | 11 | 1 | ANA | BOS | 1978 | 1984 | BAL | |
49186 | 49186 | Don Aase | 25 | aasedo01 | 1980 | CAL | AL | 5.747633372 | 2.2426875 | 15 | 1 | ANA | BOS | 1978 | 1984 | BAL | |
50142 | 50142 | Don Aase | 24 | aasedo01 | 1979 | CAL | AL | 5.760263238 | 1.615 | 13 | 1 | ANA | BOS | 1978 | 1984 | BAL | |
51101 | 51101 | Don Aase | 23 | aasedo01 | 1978 | CAL | AL | 4.78238007 | 1.555 | 12 | 1 | ANA | BOS | 1978 | 1984 | BAL | |
52038 | 52038 | Don Aase | 22 | aasedo01 | 1977 | BOS | AL | 2.522350993 | 2.304223602 | 11 | 1 | BOS | 1977 | 1977 | ANA | ||
19020 | 19020 | Andy Abad | 33 | abadan01 | 2006 | CIN | NL | 0.048837993 | -0.01 | 0 | 1 | CIN | BOS | 2006 | 2006 | ||
22968 | 22968 | Andy Abad | 30 | abadan01 | 2003 | BOS | AL | 0.169330055 | -0.31 | 1B, RF | 0 | 1 | BOS | OAK | 2003 | 2003 | CIN |
26357 | 26357 | Andy Abad | 28 | abadan01 | 2001 | OAK | AL | 0.00911663 | -0.015 | 1B | 0 | 1 | OAK | 2001 | 2001 | BOS | |
1275 | 1275 | Fernando Abad | 33 | abadfe01 | 2019 | SFG | NL | 0.493007563 | -0.030566038 | P | 1 | 1 | SFG | BOS | 2019 | 2019 | |
3263 | 3263 | Fernando Abad | 31 | abadfe01 | 2017 | BOS | AL | 1.048525452 | 0.4 | P | 3 | 1 | BOS | MIN | 2016 | 2017 | SFG |
4792 | 4792 | Fernando Abad | 30 | abadfe01 | 2016 | BOS | AL | 0.442497815 | -0.185 | P | 0 | 2 | BOS | MIN | 2016 | 2017 | SFG |
5394 | 5394 | Fernando Abad | 30 | abadfe01 | 2016 | MIN | AL | 1.210686842 | 0.765 | P | 4 | 1 | MIN | OAK | 2016 | 2016 | BOS |
7046 | 7046 | Fernando Abad | 29 | abadfe01 | 2015 | OAK | AL | 1.233510769 | -0.22 | P | 1 | 1 | OAK | WSN | 2014 | 2015 | MIN |
8482 | 8482 | Fernando Abad | 28 | abadfe01 | 2014 | OAK | AL | 1.827122385 | 1.195 | P | 6 | 1 | OAK | WSN | 2014 | 2015 | MIN |
10376 | 10376 | Fernando Abad | 27 | abadfe01 | 2013 | WSN | NL | 0.901519747 | 0.42 | P | 3 | 1 | WSN | HOU | 2013 | 2013 | OAK |
10904 | 10904 | Fernando Abad | 26 | abadfe01 | 2012 | HOU | NL | 1.216324837 | 0.05 | P | 2 | 1 | HOU | 2010 | 2012 | WSN | |
12363 | 12363 | Fernando Abad | 25 | abadfe01 | 2011 | HOU | NL | 0.642746504 | -0.68 | P | 0 | 1 | HOU | 2010 | 2012 | WSN | |
13724 | 13724 | Fernando Abad | 24 | abadfe01 | 2010 | HOU | NL | 0.625180452 | 0.175 | P | 2 | 1 | HOU | 2010 | 2012 | WSN | |
94372 | 94372 | Ed Abbaticchio | 33 | abbated01 | 1910 | BSN | NL | 2.195793499 | 0.092866242 | SS, 2B | 3 | 2 | ATL | PIT | 1910 | 1910 | |
94715 | 94715 | Ed Abbaticchio | 33 | abbated01 | 1910 | PIT | NL | 0.021919879 | -0.073636364 | SS, 2B | 0 | 1 | PIT | ATL | 1907 | 1910 | ATL |
95248 | 95248 | Ed Abbaticchio | 32 | abbated01 | 1909 | PIT | NL | 1.161519745 | 0.641688312 | SS, 2B, OF | 4 | 1 | PIT | ATL | 1907 | 1910 | ATL |
95736 | 95736 | Ed Abbaticchio | 31 | abbated01 | 1908 | PIT | NL | 6.552486188 | 3.783483871 | 2B | 23 | 1 | PIT | ATL | 1907 | 1910 | ATL |
96173 | 96173 | Ed Abbaticchio | 30 | abbated01 | 1907 | PIT | NL | 6.666277713 | 2.342292994 | 2B | 17 | 1 | PIT | ATL | 1907 | 1910 | ATL |
96780 | 96780 | Ed Abbaticchio | 28 | abbated01 | 1905 | BSN | NL | 7.536334913 | 2.383269231 | SS, OF | 17 | 1 | ATL | 1903 | 1905 | PIT | |
97180 | 97180 | Ed Abbaticchio | 27 | abbated01 | 1904 | BSN | NL | 7.329101369 | 1.703612903 | SS | 15 | 1 | ATL | 1903 | 1905 | PIT | |
97590 | 97590 | Ed Abbaticchio | 26 | abbated01 | 1903 | BSN | NL | 6.863760792 | -0.885214286 | 2B, SS | 7 | 1 | ATL | 1903 | 1905 | PIT | |
97011 | 97011 | Fred Abbott | 30 | abbotfr01 | 1905 | PHI | NL | 1.557558685 | -0.172451613 | C, 1B | 2 | 1 | PHI | CLE | 1905 | 1905 | |
97292 | 97292 | Fred Abbott | 29 | abbotfr01 | 1904 | CLE | AL | 1.619405941 | -0.431298701 | C, 1B | 1 | 1 | CLE | 1903 | 1904 | PHI | |
97684 | 97684 | Fred Abbott | 28 | abbotfr01 | 1903 | CLE | AL | 3.395121951 | 0.792642857 | C, 1B | 7 | 1 | CLE | 1903 | 1904 | PHI | |
45492 | 45492 | Glenn Abbott | 33 | abbotgl01 | 1984 | DET | AL | 1.276404325 | -0.885 | 0 | 1 | DET | SEA | 1983 | 1984 | ||
46456 | 46456 | Glenn Abbott | 32 | abbotgl01 | 1983 | DET | AL | 1.29488422 | 0.97 | 5 | 2 | DET | SEA | 1983 | 1984 | ||
46957 | 46957 | Glenn Abbott | 32 | abbotgl01 | 1983 | SEA | AL | 2.295382584 | 1.085 | 6 | 1 | SEA | OAK | 1977 | 1983 | DET | |
48900 | 48900 | Glenn Abbott | 30 | abbotgl01 | 1981 | SEA | AL | 4.530095814 | 2.025 | 11 | 1 | SEA | OAK | 1977 | 1983 | DET | |
49836 | 49836 | Glenn Abbott | 29 | abbotgl01 | 1980 | SEA | AL | 5.779160653 | 2.385276074 | 15 | 1 | SEA | OAK | 1977 | 1983 | DET | |
50817 | 50817 | Glenn Abbott | 28 | abbotgl01 | 1979 | SEA | AL | 2.948006518 | 0.06 | 3 | 1 | SEA | OAK | 1977 | 1983 | DET | |
51777 | 51777 | Glenn Abbott | 27 | abbotgl01 | 1978 | SEA | AL | 4.202531878 | 0.435375 | 7 | 1 | SEA | OAK | 1977 | 1983 | DET | |
52739 | 52739 | Glenn Abbott | 26 | abbotgl01 | 1977 | SEA | AL | 5.534102732 | 1.31 | 12 | 1 | SEA | OAK | 1977 | 1983 | DET | |
53590 | 53590 | Glenn Abbott | 25 | abbotgl01 | 1976 | OAK | AL | 1.355110937 | -0.22136646 | 1 | 1 | OAK | 1973 | 1976 | SEA | ||
54467 | 54467 | Glenn Abbott | 24 | abbotgl01 | 1975 | OAK | AL | 2.786125857 | 0.105 | 4 | 1 | OAK | 1973 | 1976 | SEA | ||
55373 | 55373 | Glenn Abbott | 23 | abbotgl01 | 1974 | OAK | AL | 2.528303913 | 1.225 | 7 | 1 | OAK | 1973 | 1976 | SEA | ||
56290 | 56290 | Glenn Abbott | 22 | abbotgl01 | 1973 | OAK | AL | 0.537968893 | -0.025 | 1 | 1 | OAK | 1973 | 1976 | SEA | ||
25952 | 25952 | Jeff Abbott | 28 | abbotje01 | 2001 | FLA | NL | 0.458025751 | 0.065 | CF, RF, LF | 1 | 1 | FLA | CHW | 2001 | 2001 | |
27076 | 27076 | Jeff Abbott | 27 | abbotje01 | 2000 | CHW | AL | 2.197244834 | -0.24 | CF, LF, RF | 3 | 1 | CHW | 1997 | 2000 | FLA | |
28450 | 28450 | Jeff Abbott | 26 | abbotje01 | 1999 | CHW | AL | 0.594967142 | -0.345 | LF | 0 | 1 | CHW | 1997 | 2000 | FLA | |
29748 | 29748 | Jeff Abbott | 25 | abbotje01 | 1998 | CHW | AL | 2.416280926 | -0.725521472 | CF, RF, LF | 1 | 1 | CHW | 1997 | 2000 | FLA | |
31011 | 31011 | Jeff Abbott | 24 | abbotje01 | 1997 | CHW | AL | 0.356576606 | -0.216335404 | LF, RF, CF | 0 | 1 | CHW | 1997 | 2000 | FLA | |
28830 | 28830 | Jim Abbott | 31 | abbotji01 | 1999 | MIL | NL | 2.092809833 | -0.820062112 | P | 1 | 1 | MIL | CHW | 1999 | 1999 | |
29739 | 29739 | Jim Abbott | 30 | abbotji01 | 1998 | CHW | AL | 0.899361396 | 0.511840491 | 3 | 1 | CHW | ANA | 1998 | 1998 | MIL | |
32167 | 32167 | Jim Abbott | 28 | abbotji01 | 1996 | CAL | AL | 3.824845452 | -1.046459627 | 2 | 1 | ANA | CHW | 1995 | 1996 | CHW | |
33398 | 33398 | Jim Abbott | 27 | abbotji01 | 1995 | CAL | AL | 2.645875444 | 1.809931034 | 9 | 2 | ANA | CHW | 1995 | 1996 | CHW | |
33481 | 33481 | Jim Abbott | 27 | abbotji01 | 1995 | CHW | AL | 3.40624528 | 2.35737931 | 11 | 1 | CHW | NYY | 1995 | 1995 | ANA | |
35150 | 35150 | Jim Abbott | 26 | abbotji01 | 1994 | NYY | AL | 6.238011707 | 2.25079646 | 15 | 1 | NYY | ANA | 1993 | 1994 | CHW | |
36293 | 36293 | Jim Abbott | 25 | abbotji01 | 1993 | NYY | AL | 5.818724367 | 1.94 | 13 | 1 | NYY | ANA | 1993 | 1994 | 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 );