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 age
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98793 | 98793 | Leo Harrison | harribe01 | 1901 | WSH | AL | 0.036989796 | -0.01173913 | 0 | 1 | MIN | 1901 | 1901 | ||||
98072 | 98072 | Hillebrand | 0 | hilde01 | 1902 | CHC | NL | 0.05952381 | -0.028723404 | OF | 0 | 1 | CHC | 1902 | 1902 | ||
98223 | 98223 | John O'Neill | 0 | o'neijo01 | 1902 | NYG | NL | 0.102723046 | -0.209784173 | C | 0 | 1 | SFG | 1902 | 1902 | ||
76133 | 76133 | Joe Nuxhall | 15 | nuxhajo01 | 1944 | CIN | NL | 0.020182605 | -0.188129032 | 0 | 1 | CIN | 1944 | 1960 | OAK | ||
68852 | 68852 | Jim Derrington | 16 | derriji01 | 1956 | CHW | AL | 0.181425486 | -0.189350649 | P | 0 | 1 | CHW | 1956 | 1957 | ||
69652 | 69652 | Alex George | 16 | georgal01 | 1955 | KCA | AL | 0.116764275 | -0.308322581 | SS | 0 | 1 | OAK | 1955 | 1955 | ||
75991 | 75991 | Tommy Brown | 16 | brownto02 | 1944 | BRO | NL | 1.68268359 | -2.121677419 | SS | 0 | 1 | LAD | 1944 | 1951 | PHI | |
76344 | 76344 | Putsy Caballero | 16 | cabalpu01 | 1944 | PHI | NL | 0.042584435 | -0.21038961 | 3B | 0 | 1 | PHI | 1944 | 1952 | ||
76849 | 76849 | Carl Scheib | 16 | scheica01 | 1943 | PHA | AL | 0.56241033 | -0.475548387 | P | 0 | 1 | OAK | 1943 | 1954 | STL | |
76876 | 76876 | Roger McKee | 16 | mckeero01 | 1943 | PHI | NL | 0.401817747 | 0.005159236 | P | 1 | 1 | PHI | 1943 | 1944 | ||
95321 | 95321 | Coonie Blank | 16 | blankco01 | 1909 | STL | NL | 0.021625652 | -0.021038961 | C | 0 | 1 | STL | 1909 | 1909 | ||
63458 | 63458 | Larry Dierker | 17 | dierkla01 | 1964 | HOU | NL | 0.254901961 | 0.01 | P | 0 | 1 | HOU | 1964 | 1976 | STL | |
63578 | 63578 | Willie Crawford | 17 | crawfwi01 | 1964 | LAD | NL | 0.174451522 | 0.177804878 | RF, LF | 1 | 1 | LAD | 1964 | 1975 | STL | |
64223 | 64223 | Jay Dahl | 17 | dahlja01 | 1963 | HOU | NL | 0.077223627 | -0.125 | 0 | 1 | HOU | 1963 | 1963 | |||
65078 | 65078 | Ed Kirkpatrick | 17 | kirkped01 | 1962 | LAA | AL | 0.059927673 | -0.125 | C | 0 | 1 | ANA | 1962 | 1968 | KCR | |
65214 | 65214 | Ed Kranepool | 17 | kraneed01 | 1962 | NYM | NL | 0.059855521 | 0.130807453 | 1B | 0 | 1 | NYM | 1962 | 1979 | ||
66268 | 66268 | Danny Murphy | 17 | murphda04 | 1960 | CHC | NL | 0.848933863 | -0.784038462 | CF, RF | 0 | 1 | CHC | 1960 | 1962 | CHW | |
67362 | 67362 | Tim McCarver | 17 | mccarti01 | 1959 | STL | NL | 0.275836839 | -0.394480519 | C | 0 | 1 | STL | 1959 | 1969 | PHI | |
68082 | 68082 | Frank Zupo | 17 | zupofr01 | 1957 | BAL | AL | 0.13741571 | -0.178831169 | C | 0 | 1 | BAL | 1957 | 1961 | ||
68152 | 68152 | Rod Miller | 17 | millero03 | 1957 | BRO | NL | 0.010582011 | -0.015779221 | 0 | 1 | LAD | 1957 | 1957 | |||
68184 | 68184 | Jim Woods | 17 | woodsji01 | 1957 | CHC | NL | 0.0 | 0.0 | 0 | 1 | CHC | 1957 | 1957 | PHI | ||
68233 | 68233 | Stover McIlwain | 17 | mcilwst01 | 1957 | CHW | AL | 0.029964328 | 0.015677419 | 0 | 1 | CHW | 1957 | 1958 | |||
68238 | 68238 | Jim Derrington | 17 | derriji01 | 1957 | CHW | AL | 1.108680143 | -0.459870968 | P | 0 | 1 | CHW | 1956 | 1957 | ||
68263 | 68263 | Dave Skaugstad | 17 | skaugda01 | 1957 | CIN | NL | 0.170527824 | 0.131493506 | P | 1 | 1 | CIN | 1957 | 1957 | ||
68269 | 68269 | Claude Osteen | 17 | osteecl01 | 1957 | CIN | NL | 0.120372582 | 0.047337662 | P | 0 | 1 | CIN | 1957 | 1961 | TEX | |
68685 | 68685 | Ron Moeller | 17 | moellro01 | 1956 | BAL | AL | 0.267515924 | 0.105194805 | P | 1 | 1 | BAL | 1956 | 1958 | ANA | |
68697 | 68697 | George Werley | 17 | werlege01 | 1956 | BAL | AL | 0.030867222 | -0.063116883 | 0 | 1 | BAL | 1956 | 1956 | |||
69080 | 69080 | Mike McCormick | 17 | mccormi03 | 1956 | NYG | NL | 0.203193033 | -0.236688312 | P | 0 | 1 | SFG | 1956 | 1962 | BAL | |
69364 | 69364 | Jim Pagliaroni | 17 | pagliji01 | 1955 | BOS | AL | 0.010292813 | -0.015779221 | C | 0 | 1 | BOS | 1955 | 1962 | PIT | |
69797 | 69797 | Fred Van Dusen | 17 | vandufr01 | 1955 | PHI | NL | 0.010752688 | 0.015779221 | 0 | 1 | PHI | 1955 | 1955 | |||
70753 | 70753 | Bob Miller | 17 | millebo03 | 1953 | DET | AL | 1.07844523 | -0.092278481 | P | 1 | 1 | DET | 1953 | 1956 | CIN | |
70793 | 70793 | Joey Jay | 17 | jayjo01 | 1953 | MLN | NL | 0.302811824 | 0.294076433 | P | 1 | 1 | ATL | 1953 | 1960 | CIN | |
70968 | 70968 | Nick Koback | 17 | kobacni01 | 1953 | PIT | NL | 0.191629956 | -0.152532468 | C | 0 | 1 | PIT | 1953 | 1955 | ||
72482 | 72482 | Harry Chiti | 17 | chitiha01 | 1950 | CHC | NL | 0.065192956 | 0.00525974 | C | 0 | 1 | CHC | 1950 | 1956 | OAK | |
74094 | 74094 | Chuck Stobbs | 17 | stobbch01 | 1947 | BOS | AL | 0.27168184 | -0.092866242 | P | 0 | 1 | BOS | 1947 | 1951 | CHW | |
75385 | 75385 | Tommy Brown | 17 | brownto02 | 1945 | BRO | NL | 2.083832335 | -0.151548387 | SS, OF | 3 | 1 | LAD | 1944 | 1951 | PHI | |
75395 | 75395 | Erv Palica | 17 | palicer01 | 1945 | BRO | NL | 0.0 | 0.0 | 0 | 1 | LAD | 1945 | 1954 | BAL | ||
75616 | 75616 | Art Houtteman | 17 | houttar01 | 1945 | DET | AL | 0.763453719 | -0.339677419 | P | 0 | 1 | DET | 1945 | 1953 | CLE | |
75761 | 75761 | Putsy Caballero | 17 | cabalpu01 | 1945 | PHI | NL | 0.010902256 | -0.120974026 | 3B | 0 | 1 | PHI | 1944 | 1952 | ||
75972 | 75972 | Charlie Osgood | 17 | osgooch01 | 1944 | BRO | NL | 0.092240117 | -0.026129032 | 0 | 1 | LAD | 1944 | 1944 | |||
75989 | 75989 | Eddie Miksis | 17 | miksied01 | 1944 | BRO | NL | 1.030643699 | -0.888387097 | 3B, SS | 0 | 1 | LAD | 1944 | 1951 | CHC | |
76015 | 76015 | Harry MacPherson | 17 | macphha01 | 1944 | BSN | NL | 0.030354132 | 0.036580645 | 0 | 1 | ATL | 1944 | 1944 | |||
76017 | 76017 | Gene Patton | 17 | pattoge01 | 1944 | BSN | NL | 0.0 | 0.0 | 0 | 1 | ATL | 1944 | 1944 | |||
76289 | 76289 | Carl Scheib | 17 | scheica01 | 1944 | PHA | AL | 1.111323004 | 0.256064516 | P | 2 | 1 | OAK | 1943 | 1954 | STL | |
76323 | 76323 | Granny Hamner | 17 | hamnegr01 | 1944 | PHI | NL | 0.862334802 | 0.347142857 | SS | 2 | 1 | PHI | 1944 | 1959 | CLE | |
76338 | 76338 | Roger McKee | 17 | mckeero01 | 1944 | PHI | NL | 0.060330381 | -0.047337662 | 0 | 1 | PHI | 1943 | 1944 | |||
76471 | 76471 | Eddie Yost | 17 | yosted01 | 1944 | WSH | AL | 0.173295985 | -0.341883117 | 3B, SS | 0 | 1 | MIN | 1944 | 1958 | DET | |
76545 | 76545 | Chris Haughey | 17 | haughch01 | 1943 | BRO | NL | 0.214494163 | -0.291176471 | P | 0 | 1 | LAD | 1943 | 1943 | ||
76655 | 76655 | Cass Michaels | 17 | michaca01 | 1943 | CHW | AL | 0.085973689 | -0.203806452 | 3B | 0 | 1 | CHW | 1943 | 1950 | MIN | |
77821 | 77821 | Vern Freiburger | 17 | freibve01 | 1941 | CLE | AL | 0.085862324 | -0.120193548 | 1B | 0 | 1 | CLE | 1941 | 1941 | ||
80535 | 80535 | Bob Feller | 17 | fellebo01 | 1936 | CLE | AL | 1.882409639 | 1.300127389 | P | 6 | 1 | CLE | 1936 | 1956 | ||
81467 | 81467 | Phil Cavarretta | 17 | cavarph01 | 1934 | CHC | NL | 0.25 | 0.410328947 | 1B | 2 | 1 | CHC | 1934 | 1953 | CHW | |
85806 | 85806 | Mel Ott | 17 | ottme01 | 1926 | NYG | NL | 0.679339478 | 0.305761589 | OF | 2 | 1 | SFG | 1926 | 1947 | ||
86436 | 86436 | Jimmie Foxx | 17 | foxxji01 | 1925 | PHA | AL | 0.093481375 | 0.227647059 | C | 1 | 1 | OAK | 1925 | 1935 | BOS | |
87122 | 87122 | Ed Clough | 17 | clouged01 | 1924 | STL | NL | 0.162434653 | -0.326103896 | OF | 0 | 1 | STL | 1924 | 1926 | ||
89626 | 89626 | Lefty Weinert | 17 | weinele01 | 1919 | PHI | NL | 0.134185304 | -0.076304348 | P | 0 | 1 | PHI | 1919 | 1924 | CHC | |
91178 | 91178 | Charlie Grimm | 17 | grimmch01 | 1916 | PHA | AL | 0.271715792 | -0.315584416 | OF | 0 | 1 | OAK | 1916 | 1916 | STL | |
92291 | 92291 | Ben Rochefort | 17 | rochebe01 | 1914 | PHA | AL | 0.02145764 | 0.015477707 | 1B | 0 | 1 | OAK | 1914 | 1914 | ||
92850 | 92850 | Harry Hanson | 17 | hansoha01 | 1913 | NYY | AL | 0.022673964 | -0.021176471 | C | 0 | 1 | NYY | 1913 | 1913 | ||
93004 | 93004 | George Tomer | 17 | tomerge01 | 1913 | SLB | AL | 0.011199073 | -0.015677419 | 0 | 1 | BAL | 1913 | 1913 | |||
93085 | 93085 | Merito Acosta | 17 | acostme01 | 1913 | WSH | AL | 0.290895062 | -0.020903226 | OF | 0 | 1 | MIN | 1913 | 1918 | OAK | |
93546 | 93546 | Mike Loan | 17 | loanmi01 | 1912 | PHI | NL | 0.021973859 | 0.015986842 | C | 0 | 1 | PHI | 1912 | 1912 | ||
97475 | 97475 | Art Bader | 17 | baderar01 | 1904 | SLB | AL | 0.044031125 | -0.015576923 | OF | 0 | 1 | BAL | 1904 | 1904 | ||
97621 | 97621 | George Moriarty | 17 | moriage02 | 1903 | CHC | NL | 0.060517529 | -0.128201439 | 3B | 0 | 1 | CHC | 1903 | 1904 | NYY | |
35379 | 35379 | Alex Rodriguez | 18 | rodrial01 | 1994 | SEA | AL | 0.784682412 | -0.397767857 | SS | 0 | 1 | SEA | 1994 | 2000 | TEX | |
51646 | 51646 | Tim Conroy | 18 | conroti01 | 1978 | OAK | AL | 0.122873576 | -0.24 | 0 | 1 | OAK | 1978 | 1985 | STL | ||
51647 | 51647 | Mike Morgan | 18 | morgami01 | 1978 | OAK | AL | 0.324737309 | -0.255 | 0 | 1 | OAK | 1978 | 1979 | NYY | ||
51935 | 51935 | Brian Milner | 18 | milnebr01 | 1978 | TOR | AL | 0.086783042 | 0.065403727 | C | 0 | 1 | TOR | 1978 | 1978 | ||
52725 | 52725 | Brian Greer | 18 | greerbr01 | 1977 | SDP | NL | 0.009726648 | -0.015 | 0 | 1 | SDP | 1977 | 1979 | |||
53222 | 53222 | Alfredo Griffin | 18 | griffal01 | 1976 | CLE | AL | 0.038474295 | -0.13245283 | SS | 0 | 1 | CLE | 1976 | 1978 | TOR | |
55184 | 55184 | Robin Yount | 18 | yountro01 | 1974 | MIL | AL | 3.467805519 | 1.15 | SS | 8 | 1 | MIL | 1974 | 1993 | ||
56503 | 56503 | David Clyde | 18 | clydeda01 | 1973 | TEX | AL | 2.741258741 | 0.11 | 4 | 1 | TEX | 1973 | 1975 | CLE | ||
58165 | 58165 | Mike Ivie | 18 | iviemi01 | 1971 | SDP | NL | 0.199782451 | 0.150931677 | C | 1 | 1 | SDP | 1971 | 1977 | SFG | |
58173 | 58173 | Jay Franklin | 18 | frankja02 | 1971 | SDP | NL | 0.16550765 | -0.30689441 | P | 0 | 1 | SDP | 1971 | 1971 | ||
59246 | 59246 | Mike McQueen | 18 | mcquemi01 | 1969 | ATL | NL | 0.087197232 | 0.045 | 0 | 1 | ATL | 1969 | 1972 | CIN | ||
60327 | 60327 | Jimmy McMath | 18 | mcmatji01 | 1968 | CHC | NL | 0.146069437 | -0.084478528 | LF | 0 | 1 | CHC | 1968 | 1968 | ||
60821 | 60821 | Ted Simmons | 18 | simmote01 | 1968 | STL | NL | 0.041428571 | 0.07 | C | 0 | 1 | STL | 1968 | 1980 | MIL | |
60972 | 60972 | Ken Brett | 18 | brettke01 | 1967 | BOS | AL | 0.05756053 | 0.05 | 0 | 1 | BOS | 1967 | 1971 | MIL | ||
61676 | 61676 | Charlie Vaughan | 18 | vaughch01 | 1966 | ATL | NL | 0.200090744 | 0.218650307 | P | 1 | 1 | ATL | 1966 | 1969 | ||
61799 | 61799 | Willie Montanez | 18 | montawi01 | 1966 | CAL | AL | 0.020596591 | -0.03 | 1B | 0 | 1 | ANA | 1966 | 1966 | PHI | |
62483 | 62483 | Jerry Moses | 18 | mosesje01 | 1965 | BOS | AL | 0.040187078 | 0.09 | 0 | 1 | BOS | 1965 | 1970 | ANA | ||
62664 | 62664 | Ralph Gagliano | 18 | gaglira01 | 1965 | CLE | AL | 0.0 | 0.0 | 0 | 1 | CLE | 1965 | 1965 | |||
62667 | 62667 | Mike Hedlund | 18 | hedlumi01 | 1965 | CLE | AL | 0.1536 | -0.06 | P | 0 | 1 | CLE | 1965 | 1968 | KCR | |
62723 | 62723 | Larry Dierker | 18 | dierkla01 | 1965 | HOU | NL | 4.215328467 | 1.32 | P | 9 | 1 | HOU | 1964 | 1976 | STL | |
62803 | 62803 | Skip Lockwood | 18 | lockwsk01 | 1965 | KCA | AL | 0.41814665 | -0.265 | 3B | 0 | 1 | OAK | 1965 | 1965 | MIL | |
62836 | 62836 | Willie Crawford | 18 | crawfwi01 | 1965 | LAD | NL | 0.300196323 | -0.305 | RF, LF, CF | 0 | 1 | LAD | 1964 | 1975 | STL | |
62945 | 62945 | Kevin Collins | 18 | collike01 | 1965 | NYM | NL | 0.249775704 | -0.113597561 | 3B, SS | 0 | 1 | NYM | 1965 | 1969 | WSN | |
62947 | 62947 | Jim Bethke | 18 | bethkji01 | 1965 | NYM | NL | 1.154903758 | -0.400060976 | P | 0 | 1 | NYM | 1965 | 1965 | ||
63161 | 63161 | Joe Coleman | 18 | colemjo05 | 1965 | WSA | AL | 0.52658463 | 0.495 | P | 2 | 1 | TEX | 1965 | 1970 | DET | |
63508 | 63508 | Dave Duncan | 18 | duncada01 | 1964 | KCA | AL | 0.551235528 | -0.660920245 | C | 0 | 1 | OAK | 1964 | 1972 | CLE | |
63655 | 63655 | Bill Southworth | 18 | southbi02 | 1964 | MLN | NL | 0.090877437 | 0.18 | 3B | 1 | 1 | ATL | 1964 | 1964 | ||
63770 | 63770 | Rick Wise | 18 | wiseri01 | 1964 | PHI | NL | 1.98447843 | 0.09 | P | 3 | 1 | PHI | 1964 | 1971 | STL | |
63779 | 63779 | Dave Bennett | 18 | benneda01 | 1964 | PHI | NL | 0.028760557 | -0.01 | 0 | 1 | PHI | 1964 | 1964 | |||
63960 | 63960 | Wally Bunker | 18 | bunkewa01 | 1963 | BAL | AL | 0.115702479 | -0.17 | P | 0 | 1 | BAL | 1963 | 1968 | KCR | |
64210 | 64210 | John Paciorek | 18 | paciojo01 | 1963 | HOU | NL | 0.052271089 | 0.21 | RF | 1 | 1 | HOU | 1963 | 1963 | ||
64225 | 64225 | Sonny Jackson | 18 | jacksso01 | 1963 | HOU | NL | 0.031362653 | -0.185 | SS | 0 | 1 | HOU | 1963 | 1967 | ATL | |
64260 | 64260 | Tony La Russa | 18 | larusto01 | 1963 | KCA | AL | 0.536755719 | -0.05 | SS, 2B | 1 | 1 | OAK | 1963 | 1971 | ATL | |
64302 | 64302 | Ed Kirkpatrick | 18 | kirkped01 | 1963 | LAA | AL | 0.86673699 | -0.08552795 | C, LF | 1 | 1 | ANA | 1962 | 1968 | KCR | |
64462 | 64462 | Ed Kranepool | 18 | kraneed01 | 1963 | NYM | NL | 3.107142857 | -1.38 | RF, 1B, LF | 0 | 1 | NYM | 1962 | 1979 | ||
65070 | 65070 | Dick Simpson | 18 | simpsdi01 | 1962 | LAA | AL | 0.109867401 | 0.205 | LF, RF | 1 | 1 | ANA | 1962 | 1965 | CIN |
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 );