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 quasi_ws descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87456 | 87456 | Babe Ruth | 28 | ruthba01 | 1923 | NYY | AL | 7.358208955 | 15.49125 | OF, 1B | 58 | 1 | NYY | BOS | 1920 | 1934 | ATL |
93057 | 93057 | Walter Johnson | 25 | johnswa01 | 1913 | WSH | AL | 10.43222568 | 13.29445161 | P, OF | 57 | 1 | MIN | 1907 | 1927 | ||
93684 | 93684 | Walter Johnson | 24 | johnswa01 | 1912 | WSH | AL | 11.29514563 | 13.03363636 | P | 57 | 1 | MIN | 1907 | 1927 | ||
98408 | 98408 | Cy Young | 34 | youngcy01 | 1901 | BOS | AL | 12.81511915 | 12.06782609 | P | 53 | 1 | BOS | 1901 | 1908 | CLE | |
88489 | 88489 | Babe Ruth | 26 | ruthba01 | 1921 | NYY | AL | 7.297385621 | 13.88647059 | OF, 1B, P | 52 | 1 | NYY | BOS | 1920 | 1934 | ATL |
91192 | 91192 | Pete Alexander | 29 | alexape01 | 1916 | PHI | NL | 11.86669887 | 10.72461039 | P | 52 | 1 | PHI | 1911 | 1917 | CHC | |
95491 | 95491 | Ed Walsh | 27 | walshed01 | 1908 | CHW | AL | 13.79207921 | 10.4625 | P | 52 | 1 | CHW | 1904 | 1916 | ATL | |
97345 | 97345 | Jack Chesbro | 30 | chesbja01 | 1904 | NYY | AL | 13.83099952 | 10.68677419 | P | 52 | 1 | NYY | PIT | 1903 | 1909 | BOS |
97727 | 97727 | Joe McGinnity | 32 | mcginjo01 | 1903 | NYG | NL | 14.43611404 | 9.611619718 | P | 51 | 1 | SFG | NYY | 1902 | 1908 | |
90248 | 90248 | Walter Johnson | 30 | johnswa01 | 1918 | WSH | AL | 11.1468114 | 11.68892308 | P, OF | 50 | 1 | MIN | 1907 | 1927 | ||
95606 | 95606 | Christy Mathewson | 27 | mathech01 | 1908 | NYG | NL | 11.67440758 | 11.67019108 | P | 50 | 1 | SFG | 1901 | 1916 | CIN | |
97728 | 97728 | Christy Mathewson | 22 | mathech01 | 1903 | NYG | NL | 12.18532207 | 10.42732394 | P | 50 | 1 | SFG | 1901 | 1916 | CIN | |
57184 | 57184 | Steve Carlton | 27 | carltst01 | 1972 | PHI | NL | 10.39 | 12.52903846 | P | 49 | 1 | PHI | STL | 1972 | 1986 | SFG |
85301 | 85301 | Babe Ruth | 32 | ruthba01 | 1927 | NYY | AL | 7.098476798 | 13.25787097 | OF | 49 | 1 | NYY | BOS | 1920 | 1934 | ATL |
86928 | 86928 | Babe Ruth | 29 | ruthba01 | 1924 | NYY | AL | 7.323938439 | 12.82235294 | OF | 49 | 1 | NYY | BOS | 1920 | 1934 | ATL |
89003 | 89003 | Babe Ruth | 25 | ruthba01 | 1920 | NYY | AL | 6.635958395 | 13.17564935 | OF, 1B, P | 49 | 1 | NYY | BOS | 1920 | 1934 | ATL |
91749 | 91749 | Pete Alexander | 28 | alexape01 | 1915 | PHI | NL | 11.53441985 | 10.75235294 | P | 49 | 1 | PHI | 1911 | 1917 | CHC | |
95732 | 95732 | Honus Wagner | 34 | wagneho01 | 1908 | PIT | NL | 7.071823204 | 12.17612903 | SS | 49 | 1 | PIT | 1901 | 1917 | ||
97972 | 97972 | Cy Young | 35 | youngcy01 | 1902 | BOS | AL | 13.05008078 | 10.35391304 | P | 49 | 1 | BOS | 1901 | 1908 | CLE | |
75581 | 75581 | Hal Newhouser | 24 | newhoha01 | 1945 | DET | AL | 9.442717053 | 10.9323871 | P | 48 | 1 | DET | 1939 | 1953 | CLE | |
90632 | 90632 | Pete Alexander | 30 | alexape01 | 1917 | PHI | NL | 11.71037464 | 10.1775974 | P | 48 | 1 | PHI | 1911 | 1917 | CHC | |
93095 | 93095 | Smoky Joe Wood | 22 | woodjo02 | 1912 | BOS | AL | 10.61572373 | 10.43006494 | P | 48 | 1 | BOS | 1908 | 1915 | CLE | |
57555 | 57555 | Fergie Jenkins | 28 | jenkife01 | 1971 | CHC | NL | 9.452908587 | 11.485 | P | 47 | 1 | CHC | PHI | 1966 | 1973 | TEX |
74645 | 74645 | Ted Williams | 27 | willite01 | 1946 | BOS | AL | 6.973698336 | 11.77615385 | OF | 47 | 1 | BOS | 1939 | 1960 | ||
76172 | 76172 | Dizzy Trout | 29 | troutdi01 | 1944 | DET | AL | 10.57 | 10.20807692 | P | 47 | 1 | DET | 1939 | 1952 | BOS | |
85302 | 85302 | Lou Gehrig | 24 | gehrilo01 | 1927 | NYY | AL | 7.365568544 | 12.70916129 | 1B | 47 | 1 | NYY | 1923 | 1939 | ||
87085 | 87085 | Rogers Hornsby | 28 | hornsro01 | 1924 | STL | NL | 6.952203137 | 12.94422078 | 2B | 47 | 1 | STL | 1915 | 1926 | SFG | |
88815 | 88815 | Pete Alexander | 33 | alexape01 | 1920 | CHC | NL | 10.98895823 | 10.38798701 | P | 47 | 1 | CHC | PHI | 1918 | 1926 | STL |
93229 | 93229 | Ed Walsh | 31 | walshed01 | 1912 | CHW | AL | 11.66832034 | 10.0378481 | P | 47 | 1 | CHW | 1904 | 1916 | ATL | |
98231 | 98231 | Rube Waddell | 25 | wadderu01 | 1902 | PHA | AL | 9.541792272 | 10.42357664 | P | 47 | 1 | OAK | CHC | 1902 | 1907 | BAL |
34502 | 34502 | Greg Maddux | 28 | maddugr01 | 1994 | ATL | NL | 8.008985769 | 11.64552632 | P | 46 | 1 | ATL | CHC | 1993 | 2003 | CHC |
68474 | 68474 | Mickey Mantle | 25 | mantlmi01 | 1957 | NYY | AL | 6.602229125 | 11.94487013 | CF | 46 | 1 | NYY | 1951 | 1968 | ||
69085 | 69085 | Mickey Mantle | 24 | mantlmi01 | 1956 | NYY | AL | 6.880640466 | 11.96590909 | CF | 46 | 1 | NYY | 1951 | 1968 | ||
77031 | 77031 | Ted Williams | 23 | willite01 | 1942 | BOS | AL | 7.156675248 | 11.84092105 | OF | 46 | 1 | BOS | 1939 | 1960 | ||
85830 | 85830 | Babe Ruth | 31 | ruthba01 | 1926 | NYY | AL | 6.783139013 | 12.26496774 | OF, 1B | 46 | 1 | NYY | BOS | 1920 | 1934 | ATL |
91880 | 91880 | Walter Johnson | 27 | johnswa01 | 1915 | WSH | AL | 10.1410471 | 10.92193548 | P, OF | 46 | 1 | MIN | 1907 | 1927 | ||
92447 | 92447 | Walter Johnson | 26 | johnswa01 | 1914 | WSH | AL | 11.0214168 | 10.68993631 | P, OF | 46 | 1 | MIN | 1907 | 1927 | ||
26545 | 26545 | Barry Bonds | 36 | bondsba01 | 2001 | SFG | NL | 6.400531826 | 12.175 | LF | 45 | 1 | SFG | PIT | 1993 | 2007 | |
44726 | 44726 | Dwight Gooden | 20 | goodedw01 | 1985 | NYM | NL | 7.138408451 | 11.485 | P | 45 | 1 | NYM | 1984 | 1994 | NYY | |
60947 | 60947 | Carl Yastrzemski | 27 | yastrca01 | 1967 | BOS | AL | 6.925373134 | 11.775 | LF, CF | 45 | 1 | BOS | 1961 | 1983 | ||
73992 | 73992 | Stan Musial | 27 | musiast01 | 1948 | STL | NL | 7.33937636 | 11.60651613 | OF, 1B | 45 | 1 | STL | 1941 | 1963 | ||
88655 | 88655 | Rogers Hornsby | 25 | hornsro01 | 1921 | STL | NL | 7.197937765 | 11.57668831 | 2B, OF, 3B, SS, 1B | 45 | 1 | STL | 1915 | 1926 | SFG | |
90407 | 90407 | Eddie Cicotte | 33 | cicoted01 | 1917 | CHW | AL | 10.20929141 | 9.5175 | P | 45 | 1 | CHW | BOS | 1912 | 1920 | |
90492 | 90492 | Ty Cobb | 30 | cobbty01 | 1917 | DET | AL | 7.290684624 | 12.00798701 | OF | 45 | 1 | DET | 1905 | 1926 | OAK | |
91328 | 91328 | Walter Johnson | 28 | johnswa01 | 1916 | WSH | AL | 11.05315615 | 10.51471698 | P | 45 | 1 | MIN | 1907 | 1927 | ||
93986 | 93986 | Ty Cobb | 24 | cobbty01 | 1911 | DET | AL | 6.991547225 | 11.42415584 | OF | 45 | 1 | DET | 1905 | 1926 | OAK | |
94420 | 94420 | Ed Walsh | 29 | walshed01 | 1910 | CHW | AL | 10.9393512 | 10.56634615 | P | 45 | 1 | CHW | 1904 | 1916 | ATL | |
97130 | 97130 | Cy Young | 37 | youngcy01 | 1904 | BOS | AL | 11.35135135 | 9.147324841 | P | 45 | 1 | BOS | 1901 | 1908 | CLE | |
97533 | 97533 | Cy Young | 36 | youngcy01 | 1903 | BOS | AL | 11.43426295 | 8.996170213 | P | 45 | 1 | BOS | 1901 | 1908 | CLE | |
25204 | 25204 | Barry Bonds | 37 | bondsba01 | 2002 | SFG | NL | 6.011176969 | 12.235 | LF | 44 | 1 | SFG | PIT | 1993 | 2007 | |
48788 | 48788 | Mike Schmidt | 31 | schmimi01 | 1981 | PHI | NL | 6.504392765 | 11.71093458 | 3B | 44 | 1 | PHI | 1972 | 1989 | ||
56716 | 56716 | Wilbur Wood | 30 | woodwi01 | 1972 | CHW | AL | 11.41963426 | 8.431363636 | P | 44 | 1 | CHW | PIT | 1967 | 1978 | |
56787 | 56787 | Gaylord Perry | 33 | perryga01 | 1972 | CLE | AL | 10.2070922 | 9.979615385 | P | 44 | 1 | CLE | SFG | 1972 | 1975 | TEX |
60794 | 60794 | Bob Gibson | 32 | gibsobo01 | 1968 | STL | NL | 8.651791751 | 10.485 | P | 44 | 1 | STL | 1959 | 1975 | ||
74897 | 74897 | Bob Feller | 27 | fellebo01 | 1946 | CLE | AL | 11.23091695 | 9.995192308 | P | 44 | 1 | CLE | 1936 | 1956 | ||
83737 | 83737 | Lefty Grove | 30 | grovele01 | 1930 | PHA | AL | 8.917457999 | 9.809415584 | P | 44 | 1 | OAK | 1925 | 1933 | BOS | |
84045 | 84045 | Rogers Hornsby | 33 | hornsro01 | 1929 | CHC | NL | 7.233490979 | 11.00677215 | 2B | 44 | 1 | CHC | ATL | 1929 | 1932 | STL |
84767 | 84767 | Babe Ruth | 33 | ruthba01 | 1928 | NYY | AL | 7.192168238 | 10.9087013 | OF | 44 | 1 | NYY | BOS | 1920 | 1934 | ATL |
86647 | 86647 | Dazzy Vance | 33 | vanceda01 | 1924 | BRO | NL | 9.392061955 | 9.467532468 | P | 44 | 1 | LAD | NYY | 1922 | 1932 | STL |
88136 | 88136 | Rogers Hornsby | 26 | hornsro01 | 1922 | STL | NL | 7.322812052 | 10.84558442 | 2B | 44 | 1 | STL | 1915 | 1926 | SFG | |
93096 | 93096 | Tris Speaker | 24 | speaktr01 | 1912 | BOS | AL | 7.337087087 | 10.9087013 | OF | 44 | 1 | BOS | 1907 | 1915 | CLE | |
94935 | 94935 | Mordecai Brown | 32 | brownmo01 | 1909 | CHC | NL | 10.21675343 | 8.894322581 | P | 44 | 1 | CHC | STL | 1904 | 1912 | CIN |
97020 | 97020 | Honus Wagner | 31 | wagneho01 | 1905 | PIT | NL | 6.783368141 | 10.94806452 | SS, OF | 44 | 1 | PIT | 1901 | 1917 | ||
98022 | 98022 | Vic Willis | 26 | willivi01 | 1902 | BSN | NL | 13.72476089 | 7.973617021 | P | 44 | 1 | ATL | 1901 | 1905 | PIT | |
22533 | 22533 | Barry Bonds | 39 | bondsba01 | 2004 | SFG | NL | 5.884887354 | 11.27 | LF | 43 | 1 | SFG | PIT | 1993 | 2007 | |
31954 | 31954 | Roger Clemens | 34 | clemero02 | 1997 | TOR | AL | 7.234744258 | 11.45 | P | 43 | 1 | TOR | BOS | 1997 | 1998 | NYY |
50986 | 50986 | Phil Niekro | 39 | niekrph01 | 1978 | ATL | NL | 9.367718698 | 9.745 | P | 43 | 1 | ATL | 1964 | 1983 | NYY | |
54055 | 54055 | Joe Morgan | 31 | morgajo02 | 1975 | CIN | NL | 6.243598383 | 10.985 | 2B | 43 | 1 | CIN | HOU | 1972 | 1979 | HOU |
60072 | 60072 | Bob Gibson | 33 | gibsobo01 | 1969 | STL | NL | 9.030814882 | 10.49 | P | 43 | 1 | STL | 1959 | 1975 | ||
62807 | 62807 | Sandy Koufax | 29 | koufasa01 | 1965 | LAD | NL | 9.551490515 | 9.535 | P | 43 | 1 | LAD | 1955 | 1966 | ||
70261 | 70261 | Willie Mays | 23 | mayswi01 | 1954 | NYG | NL | 6.806664226 | 10.9875974 | OF | 43 | 1 | SFG | 1951 | 1972 | NYM | |
70907 | 70907 | Robin Roberts | 26 | roberro01 | 1953 | PHI | NL | 10.63550037 | 9.527884615 | P | 43 | 1 | PHI | 1948 | 1961 | BAL | |
81646 | 81646 | Lou Gehrig | 31 | gehrilo01 | 1934 | NYY | AL | 7.132418464 | 11.09805195 | 1B, SS | 43 | 1 | NYY | 1923 | 1939 | ||
82700 | 82700 | Jimmie Foxx | 24 | foxxji01 | 1932 | PHA | AL | 7.088440111 | 11.44519481 | 1B, 3B | 43 | 1 | OAK | 1925 | 1935 | BOS | |
85258 | 85258 | Rogers Hornsby | 31 | hornsro01 | 1927 | NYG | NL | 7.149396288 | 10.692 | 2B | 43 | 1 | SFG | STL | 1927 | 1927 | ATL |
87328 | 87328 | Dolf Luque | 32 | luquedo01 | 1923 | CIN | NL | 9.734165067 | 9.251883117 | P | 43 | 1 | CIN | ATL | 1918 | 1929 | LAD |
89238 | 89238 | Babe Ruth | 24 | ruthba01 | 1919 | BOS | AL | 6.502994012 | 11.62173913 | OF, P, 1B | 43 | 1 | BOS | 1914 | 1919 | NYY | |
89876 | 89876 | Hippo Vaughn | 30 | vaughhi01 | 1918 | CHC | NL | 10.2041841 | 8.594656489 | P | 43 | 1 | CHC | MIN | 1913 | 1921 | |
96921 | 96921 | Christy Mathewson | 24 | mathech01 | 1905 | NYG | NL | 10.38248175 | 9.542322581 | P | 43 | 1 | SFG | 1901 | 1916 | CIN | |
97371 | 97371 | Rube Waddell | 27 | wadderu01 | 1904 | PHA | AL | 11.91261417 | 9.573677419 | P | 43 | 1 | OAK | CHC | 1902 | 1907 | BAL |
34905 | 34905 | Jeff Bagwell | 26 | bagweje01 | 1994 | HOU | NL | 6.610040447 | 11.26252174 | 1B, RF | 42 | 1 | HOU | 1991 | 2005 | ||
59131 | 59131 | Bob Gibson | 34 | gibsobo01 | 1970 | STL | NL | 8.367743393 | 10.625 | P | 42 | 1 | STL | 1959 | 1975 | ||
63061 | 63061 | Willie Mays | 34 | mayswi01 | 1965 | SFG | NL | 6.549380531 | 10.89276074 | CF, RF, LF | 42 | 1 | SFG | 1951 | 1972 | NYM | |
63822 | 63822 | Willie Mays | 33 | mayswi01 | 1964 | SFG | NL | 6.725370532 | 10.765 | CF, 3B, SS, 1B | 42 | 1 | SFG | 1951 | 1972 | NYM | |
64313 | 64313 | Sandy Koufax | 27 | koufasa01 | 1963 | LAD | NL | 8.887729644 | 9.198220859 | P | 42 | 1 | LAD | 1955 | 1966 | ||
65915 | 65915 | Mickey Mantle | 29 | mantlmi01 | 1961 | NYY | AL | 6.527526132 | 10.31631902 | CF | 42 | 1 | NYY | 1951 | 1968 | ||
73707 | 73707 | Lou Boudreau | 30 | boudrlo01 | 1948 | CLE | AL | 6.896745822 | 11.04923077 | SS, C | 42 | 1 | CLE | 1938 | 1950 | BOS | |
74064 | 74064 | Ted Williams | 28 | willite01 | 1947 | BOS | AL | 7.187679083 | 10.51452229 | OF | 42 | 1 | BOS | 1939 | 1960 | ||
74945 | 74945 | Hal Newhouser | 25 | newhoha01 | 1946 | DET | AL | 8.767475036 | 9.751354839 | P | 42 | 1 | DET | 1939 | 1953 | CLE | |
77570 | 77570 | Ted Williams | 22 | willite01 | 1941 | BOS | AL | 6.22639504 | 11.28251613 | OF | 42 | 1 | BOS | 1939 | 1960 | ||
78355 | 78355 | Bob Feller | 21 | fellebo01 | 1940 | CLE | AL | 9.784727273 | 9.176516129 | P | 42 | 1 | CLE | 1936 | 1956 | ||
80839 | 80839 | Wes Ferrell | 27 | ferrewe01 | 1935 | BOS | AL | 9.838662791 | 9.830454545 | P | 42 | 1 | BOS | CLE | 1934 | 1937 | MIN |
83216 | 83216 | Lefty Grove | 31 | grovele01 | 1931 | PHA | AL | 8.882051282 | 9.058235294 | P | 42 | 1 | OAK | 1925 | 1933 | BOS | |
83701 | 83701 | Babe Ruth | 35 | ruthba01 | 1930 | NYY | AL | 6.885844749 | 11.14012987 | OF, P | 42 | 1 | NYY | BOS | 1920 | 1934 | ATL |
85457 | 85457 | Frankie Frisch | 29 | friscfr01 | 1927 | STL | NL | 7.462681025 | 10.02176471 | 2B, SS | 42 | 1 | STL | SFG | 1927 | 1937 | |
89364 | 89364 | Eddie Cicotte | 35 | cicoted01 | 1919 | CHW | AL | 10.18450185 | 8.944714286 | P | 42 | 1 | CHW | BOS | 1912 | 1920 | |
94539 | 94539 | Ty Cobb | 23 | cobbty01 | 1910 | DET | AL | 6.609276579 | 10.91148387 | OF | 42 | 1 | DET | 1905 | 1926 | OAK | |
94597 | 94597 | Russ Ford | 27 | fordru01 | 1910 | NYY | AL | 9.000715137 | 9.932884615 | P | 42 | 1 | NYY | 1909 | 1913 | ||
94628 | 94628 | Eddie Collins | 23 | collied01 | 1910 | PHA | AL | 7.335229427 | 10.53 | 2B | 42 | 1 | OAK | 1906 | 1914 | CHW | |
94799 | 94799 | Walter Johnson | 22 | johnswa01 | 1910 | WSH | AL | 11.25271542 | 10.56611465 | P | 42 | 1 | MIN | 1907 | 1927 |
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 );