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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65145 | 65145 | Jim Manning | 18 | manniji02 | 1962 | MIN | AL | 0.201048553 | -0.134171779 | P | 0 | 1 | MIN | 1962 | 1962 | ||
65530 | 65530 | Danny Murphy | 18 | murphda04 | 1961 | CHC | NL | 0.146174617 | 0.212884615 | RF | 1 | 1 | CHC | 1960 | 1962 | CHW | |
65575 | 65575 | Mike DeGerick | 18 | degermi01 | 1961 | CHW | AL | 0.048320295 | 0.0 | 0 | 1 | CHW | 1961 | 1962 | |||
65645 | 65645 | Sam McDowell | 18 | mcdowsa01 | 1961 | CLE | AL | 0.184253059 | 0.226397516 | P | 1 | 1 | CLE | 1961 | 1971 | SFG | |
65718 | 65718 | Lew Krausse | 18 | krausle02 | 1961 | KCA | AL | 1.65229682 | 0.13 | P | 3 | 1 | OAK | 1961 | 1969 | MIL | |
65859 | 65859 | Gary Dotter | 18 | dottega01 | 1961 | MIN | AL | 0.176100629 | -0.075465839 | P | 0 | 1 | MIN | 1961 | 1964 | ||
66253 | 66253 | Nelson Mathews | 18 | mathene01 | 1960 | CHC | NL | 0.08384532 | -0.015576923 | RF | 0 | 1 | CHC | 1960 | 1963 | OAK | |
66734 | 66734 | Tim McCarver | 18 | mccarti01 | 1960 | STL | NL | 0.108188771 | -0.188129032 | C | 0 | 1 | STL | 1959 | 1969 | PHI | |
66808 | 66808 | Bob Saverine | 18 | saverbo01 | 1959 | BAL | AL | 0.0 | 0.005225806 | 0 | 1 | BAL | 1959 | 1964 | TEX | ||
67438 | 67438 | Frank Zupo | 18 | zupofr01 | 1958 | BAL | AL | 0.02204485 | -0.026298701 | C | 0 | 1 | BAL | 1957 | 1961 | ||
67520 | 67520 | Dick Ellsworth | 18 | ellswdi01 | 1958 | CHC | NL | 0.072005878 | -0.168311688 | P | 0 | 1 | CHC | 1958 | 1966 | PHI | |
67554 | 67554 | Stover McIlwain | 18 | mcilwst01 | 1958 | CHW | AL | 0.1208923 | 0.041806452 | P | 0 | 1 | CHW | 1957 | 1958 | ||
67726 | 67726 | Lou Klimchock | 18 | klimclo01 | 1958 | KCA | AL | 0.107327905 | 0.046730769 | 2B | 0 | 1 | OAK | 1958 | 1961 | ATL | |
68068 | 68068 | Jerry Walker | 18 | walkeje01 | 1957 | BAL | AL | 0.825284091 | 0.184090909 | P | 2 | 1 | BAL | 1957 | 1960 | OAK | |
68071 | 68071 | Milt Pappas | 18 | pappami01 | 1957 | BAL | AL | 0.268465909 | 0.152532468 | P | 1 | 1 | BAL | 1957 | 1965 | CIN | |
68272 | 68272 | Don Pavletich | 18 | pavledo01 | 1957 | CIN | NL | 0.010240113 | -0.015779221 | 0 | 1 | CIN | 1957 | 1968 | CHW | ||
68275 | 68275 | Bobby Henrich | 18 | henribo01 | 1957 | CIN | NL | 0.122881356 | -0.068376623 | SS, LF, 3B, CF, 2B | 0 | 1 | CIN | 1957 | 1959 | ||
68430 | 68430 | Hawk Taylor | 18 | tayloha04 | 1957 | MLN | NL | 0.010422282 | -0.015677419 | C | 0 | 1 | ATL | 1957 | 1963 | NYM | |
68449 | 68449 | Mike McCormick | 18 | mccormi03 | 1957 | NYG | NL | 2.242135367 | 0.867857143 | P | 6 | 1 | SFG | 1956 | 1962 | BAL | |
68595 | 68595 | Von McDaniel | 18 | mcdanvo01 | 1957 | STL | NL | 2.575471698 | 0.81525974 | P | 6 | 1 | STL | 1957 | 1958 | ||
68614 | 68614 | Bob Miller | 18 | millebo04 | 1957 | STL | NL | 0.26745283 | -0.147272727 | 0 | 1 | STL | 1957 | 1961 | NYM | ||
68694 | 68694 | Gordie Sundin | 18 | sundigo01 | 1956 | BAL | AL | 0.0 | 0.0 | 0 | 1 | BAL | 1956 | 1956 | |||
68769 | 68769 | Bob Aspromonte | 18 | asprobo01 | 1956 | BRO | NL | 0.010716925 | -0.015779221 | 0 | 1 | LAD | 1956 | 1961 | HOU | ||
68885 | 68885 | Curt Flood | 18 | floodcu01 | 1956 | CIN | NL | 0.010435408 | -0.041806452 | 0 | 1 | CIN | 1956 | 1957 | STL | ||
69313 | 69313 | Roger Marquis | 18 | marquro01 | 1955 | BAL | AL | 0.01055121 | -0.015576923 | OF | 0 | 1 | BAL | 1955 | 1955 | ||
69320 | 69320 | Tex Nelson | 18 | nelsote01 | 1955 | BAL | AL | 0.400945971 | -0.280384615 | OF, 1B | 0 | 1 | BAL | 1955 | 1957 | ||
69327 | 69327 | Brooks Robinson | 18 | robinbr01 | 1955 | BAL | AL | 0.232126615 | -0.581538462 | 3B | 0 | 1 | BAL | 1955 | 1977 | ||
69334 | 69334 | Wayne Causey | 18 | causewa01 | 1955 | BAL | AL | 2.068037111 | -1.35 | 3B, 2B, SS | 0 | 1 | BAL | 1955 | 1957 | OAK | |
69567 | 69567 | Kenny Kuhn | 18 | kuhnke01 | 1955 | CLE | AL | 0.073074154 | 0.0 | SS | 0 | 1 | CLE | 1955 | 1957 | ||
69602 | 69602 | Jim Small | 18 | smallji01 | 1955 | DET | AL | 0.0519434 | 0.026298701 | OF | 0 | 1 | DET | 1955 | 1957 | OAK | |
69658 | 69658 | Clete Boyer | 18 | boyercl02 | 1955 | KCA | AL | 0.881039531 | -0.522580645 | SS, 3B, 2B | 0 | 1 | OAK | 1955 | 1957 | NYY | |
69763 | 69763 | Tom Carroll | 18 | carroto01 | 1955 | NYY | AL | 0.064064801 | -0.089415584 | SS | 0 | 1 | NYY | 1955 | 1956 | OAK | |
69847 | 69847 | Red Swanson | 18 | swansre01 | 1955 | PIT | NL | 0.061658919 | -0.157792208 | 0 | 1 | PIT | 1955 | 1957 | |||
70207 | 70207 | Bob Miller | 18 | millebo03 | 1954 | DET | AL | 2.115690528 | 1.04516129 | P | 6 | 1 | DET | 1953 | 1956 | CIN | |
70217 | 70217 | Walt Streuli | 18 | streuwa01 | 1954 | DET | AL | 0.010734777 | 0.015677419 | C | 0 | 1 | DET | 1954 | 1956 | ||
70259 | 70259 | Joey Jay | 18 | jayjo01 | 1954 | MLN | NL | 0.54206501 | -0.21038961 | 0 | 1 | ATL | 1953 | 1960 | CIN | ||
70335 | 70335 | Frank Leja | 18 | lejafr01 | 1954 | NYY | AL | 0.052365475 | -0.099290323 | 1B | 0 | 1 | NYY | 1954 | 1955 | ANA | |
70437 | 70437 | Nick Koback | 18 | kobacni01 | 1954 | PIT | NL | 0.117799114 | -0.262987013 | C | 0 | 1 | PIT | 1953 | 1955 | ||
70503 | 70503 | Harmon Killebrew | 18 | killeha01 | 1954 | WSH | AL | 0.15806686 | -0.010451613 | 2B | 0 | 1 | MIN | 1954 | 1974 | KCR | |
70545 | 70545 | Billy Consolo | 18 | consobi01 | 1953 | BOS | AL | 0.72270783 | -0.397058824 | 3B, 2B | 0 | 1 | BOS | 1953 | 1959 | MIN | |
70758 | 70758 | Reno Bertoia | 18 | bertore01 | 1953 | DET | AL | 0.010202287 | -0.061518987 | 2B | 0 | 1 | DET | 1953 | 1958 | MIN | |
70760 | 70760 | Al Kaline | 18 | kalinal01 | 1953 | DET | AL | 0.306068602 | -0.184556962 | OF | 0 | 1 | DET | 1953 | 1974 | ||
70934 | 70934 | Tom Qualters | 18 | qualtto01 | 1953 | PHI | NL | 0.010226443 | -0.192115385 | 0 | 1 | PHI | 1953 | 1958 | CHW | ||
71048 | 71048 | Dick Schofield | 18 | schofdi01 | 1953 | STL | NL | 0.425707125 | -0.061910828 | SS | 0 | 1 | STL | 1953 | 1958 | PIT | |
71584 | 71584 | Bill Bell | 18 | bellbi01 | 1952 | PIT | NL | 0.482522611 | -0.376258065 | P | 0 | 1 | PIT | 1952 | 1955 | ||
71588 | 71588 | Jim Waugh | 18 | waughji01 | 1952 | PIT | NL | 1.611830848 | -0.470322581 | P | 0 | 1 | PIT | 1952 | 1953 | ||
71862 | 71862 | Harry Chiti | 18 | chitiha01 | 1951 | CHC | NL | 0.364442802 | 0.172451613 | C | 1 | 1 | CHC | 1950 | 1956 | OAK | |
72516 | 72516 | Joe Kirrene | 18 | kirrejo01 | 1950 | CHW | AL | 0.042274052 | -0.015576923 | 3B | 0 | 1 | CHW | 1950 | 1954 | ||
72523 | 72523 | Gus Keriazakos | 18 | keriagu01 | 1950 | CHW | AL | 0.071742313 | -0.103846154 | P | 0 | 1 | CHW | 1950 | 1950 | MIN | |
72563 | 72563 | Jim Bolger | 18 | bolgeji01 | 1950 | CIN | NL | 0.01083707 | -0.015882353 | OF | 0 | 1 | CIN | 1950 | 1954 | CHC | |
73087 | 73087 | Jim Baumer | 18 | baumeji01 | 1949 | CHW | AL | 0.147421932 | 0.310324675 | SS | 1 | 1 | CHW | 1949 | 1949 | CIN | |
73517 | 73517 | Chuck Stobbs | 18 | stobbch01 | 1948 | BOS | AL | 0.213146448 | -0.020903226 | P | 0 | 1 | BOS | 1947 | 1951 | CHW | |
73592 | 73592 | Johnny Antonelli | 18 | antonjo02 | 1948 | BSN | NL | 0.120921305 | 0.052597403 | 0 | 1 | ATL | 1948 | 1953 | SFG | ||
74482 | 74482 | Curt Simmons | 18 | simmocu01 | 1947 | PHI | NL | 0.27753304 | 0.506903226 | P | 2 | 1 | PHI | 1947 | 1960 | STL | |
74571 | 74571 | Perry Currin | 18 | curripe01 | 1947 | SLB | AL | 0.032535527 | -0.00525974 | SS | 0 | 1 | BAL | 1947 | 1947 | ||
74573 | 74573 | Bud Swartz | 18 | swartbu01 | 1947 | SLB | AL | 0.164102564 | -0.115714286 | P | 0 | 1 | BAL | 1947 | 1947 | ||
74632 | 74632 | Buzz Dozier | 18 | doziebu01 | 1947 | WSH | AL | 0.143906021 | 0.131493506 | P | 1 | 1 | MIN | 1947 | 1949 | ||
74971 | 74971 | Art Houtteman | 18 | houttar01 | 1946 | DET | AL | 0.239657632 | 0.0 | P | 0 | 1 | DET | 1945 | 1953 | CLE | |
75540 | 75540 | Herm Wehmeier | 18 | wehmehe01 | 1945 | CIN | NL | 0.154185022 | -0.19987013 | P | 0 | 1 | CIN | 1945 | 1954 | PHI | |
75607 | 75607 | Billy Pierce | 18 | piercbi02 | 1945 | DET | AL | 0.30136331 | 0.083612903 | P | 1 | 1 | DET | 1945 | 1948 | CHW | |
75634 | 75634 | Whitey Lockman | 18 | lockmwh01 | 1945 | NYG | NL | 1.556200145 | 1.130844156 | OF | 6 | 1 | SFG | 1945 | 1956 | STL | |
75712 | 75712 | Carl Scheib | 18 | scheica01 | 1945 | PHA | AL | 0.263577118 | 0.047647059 | P | 0 | 1 | OAK | 1943 | 1954 | STL | |
75762 | 75762 | Don Hasenmayer | 18 | hasendo01 | 1945 | PHI | NL | 0.218045113 | -0.20512987 | 2B, 3B | 0 | 1 | PHI | 1945 | 1946 | ||
75767 | 75767 | Granny Hamner | 18 | hamnegr01 | 1945 | PHI | NL | 0.457894737 | -0.720584416 | SS | 0 | 1 | PHI | 1944 | 1959 | CLE | |
75900 | 75900 | Armando Roche | 18 | rochear01 | 1945 | WSH | AL | 0.178428133 | -0.031153846 | P | 0 | 1 | MIN | 1945 | 1945 | ||
75969 | 75969 | Roy Jarvis | 18 | jarviro01 | 1944 | BRO | NL | 0.010516772 | -0.015677419 | C | 0 | 1 | LAD | 1944 | 1944 | PIT | |
75974 | 75974 | Gene Mauch | 18 | mauchge01 | 1944 | BRO | NL | 0.178785131 | -0.094064516 | SS | 0 | 1 | LAD | 1944 | 1944 | PIT | |
75986 | 75986 | Ralph Branca | 18 | brancra01 | 1944 | BRO | NL | 1.373352855 | -0.663677419 | P | 0 | 1 | LAD | 1944 | 1953 | DET | |
75990 | 75990 | Cal McLish | 18 | mclisca01 | 1944 | BRO | NL | 2.572474378 | -2.027612903 | P | 0 | 1 | LAD | 1944 | 1946 | PIT | |
76097 | 76097 | Cass Michaels | 18 | michaca01 | 1944 | CHW | AL | 0.763157895 | -0.368181818 | SS, 3B | 0 | 1 | CHW | 1943 | 1950 | MIN | |
76123 | 76123 | Kent Peterson | 18 | peterke01 | 1944 | CIN | NL | 0.030273907 | 0.015677419 | 0 | 1 | CIN | 1944 | 1951 | PHI | ||
76157 | 76157 | Hank Ruszkowski | 18 | ruszkha01 | 1944 | CLE | AL | 0.082415631 | 0.141096774 | C | 1 | 1 | CLE | 1944 | 1947 | ||
76549 | 76549 | Rex Barney | 18 | barnere02 | 1943 | BRO | NL | 1.399319066 | -0.984705882 | P | 0 | 1 | LAD | 1943 | 1950 | ||
76578 | 76578 | Ray Martin | 18 | martira01 | 1943 | BSN | NL | 0.101867572 | -0.068823529 | P | 0 | 1 | ATL | 1943 | 1948 | ||
76840 | 76840 | Vern Benson | 18 | bensove01 | 1943 | PHA | AL | 0.021886792 | -0.020903226 | 0 | 1 | OAK | 1943 | 1946 | STL | ||
76877 | 76877 | George Eyrich | 18 | eyricge01 | 1943 | PHI | NL | 0.562544846 | -0.015477707 | P | 1 | 1 | PHI | 1943 | 1943 | ||
76956 | 76956 | Hank Schmulbach | 18 | schmuha01 | 1943 | SLB | AL | 0.0 | 0.0 | 0 | 1 | BAL | 1943 | 1943 | |||
77261 | 77261 | Ted Sepkowski | 18 | sepkote01 | 1942 | CLE | AL | 0.107526882 | -0.238846154 | 2B | 0 | 1 | CLE | 1942 | 1947 | NYY | |
77425 | 77425 | Hilly Flitcraft | 18 | flitchi01 | 1942 | PHI | NL | 0.10940349 | -0.085827815 | 0 | 1 | PHI | 1942 | 1942 | |||
78545 | 78545 | Sam File | 18 | filesa01 | 1940 | PHI | NL | 0.14480507 | -0.211764706 | SS, 3B | 0 | 1 | PHI | 1940 | 1940 | ||
78779 | 78779 | Sibby Sisti | 18 | sistisi01 | 1939 | BSN | NL | 2.536475024 | -0.367697368 | 2B, 3B, SS | 2 | 1 | ATL | 1939 | 1954 | ||
78851 | 78851 | Bob Kennedy | 18 | kennebo01 | 1939 | CHW | AL | 0.095012741 | -0.083612903 | 3B | 0 | 1 | CHW | 1939 | 1948 | CLE | |
78960 | 78960 | Hal Newhouser | 18 | newhoha01 | 1939 | DET | AL | 0.153583618 | 0.078387097 | P | 0 | 1 | DET | 1939 | 1953 | CLE | |
80009 | 80009 | Bob Feller | 18 | fellebo01 | 1937 | CLE | AL | 4.575476307 | 3.208846154 | P | 16 | 1 | CLE | 1936 | 1956 | ||
80646 | 80646 | Randy Gumpert | 18 | gumpera01 | 1936 | PHA | AL | 1.935913236 | 0.431298701 | P | 4 | 1 | OAK | 1936 | 1938 | NYY | |
80866 | 80866 | Walt Ripley | 18 | riplewa01 | 1935 | BOS | AL | 0.122093023 | -0.026298701 | 0 | 1 | BOS | 1935 | 1935 | |||
80951 | 80951 | Phil Cavarretta | 18 | cavarph01 | 1935 | CHC | NL | 6.598926655 | 1.036168831 | 1B | 14 | 1 | CHC | 1934 | 1953 | CHW | |
81351 | 81351 | Buddy Lewis | 18 | lewisbu01 | 1935 | WSH | AL | 0.281212121 | -0.468116883 | 3B | 0 | 1 | MIN | 1935 | 1949 | ||
81442 | 81442 | Elbie Fletcher | 18 | fletcel01 | 1934 | BSN | NL | 0.043291659 | 0.079934211 | 1B | 0 | 1 | ATL | 1934 | 1939 | PIT | |
81868 | 81868 | Reese Diggs | 18 | diggsre01 | 1934 | WSH | AL | 0.648805214 | -0.23516129 | P | 0 | 1 | MIN | 1934 | 1934 | ||
82206 | 82206 | Frankie Hayes | 18 | hayesfr01 | 1933 | PHA | AL | 0.052393857 | -0.165197368 | C | 0 | 1 | OAK | 1933 | 1942 | BAL | |
82527 | 82527 | Clarence Fieber | 18 | fiebecl01 | 1932 | CHW | AL | 0.167622849 | 0.10125 | 0 | 1 | CHW | 1932 | 1932 | |||
83953 | 83953 | Joe Cicero | 18 | cicerjo01 | 1929 | BOS | AL | 0.352382761 | 0.120193548 | OF | 1 | 1 | BOS | 1929 | 1930 | OAK | |
84700 | 84700 | Mel Harder | 18 | hardeme01 | 1928 | CLE | AL | 1.496364518 | -0.794322581 | P | 0 | 1 | CLE | 1928 | 1947 | ||
85277 | 85277 | Mel Ott | 18 | ottme01 | 1927 | NYG | NL | 1.881420076 | -0.036580645 | OF | 3 | 1 | SFG | 1926 | 1947 | ||
85722 | 85722 | Rufus Meadows | 18 | meadoru01 | 1926 | CIN | NL | 0.009938476 | -0.010318471 | P | 0 | 1 | CIN | 1926 | 1926 | ||
85885 | 85885 | Jimmie Foxx | 18 | foxxji01 | 1926 | PHA | AL | 0.379368342 | 0.1188 | C, OF | 1 | 1 | OAK | 1925 | 1935 | BOS | |
86170 | 86170 | Joe Ogrodowski | 18 | ogrodjo01 | 1925 | BSN | NL | 0.03295841 | -0.153529412 | 0 | 1 | ATL | 1925 | 1925 | |||
86206 | 86206 | Jumbo Brown | 18 | brownju01 | 1925 | CHC | NL | 0.184075968 | -0.015779221 | P | 0 | 1 | CHC | 1925 | 1925 | CLE | |
86274 | 86274 | Tom Sullivan | 18 | sullito03 | 1925 | CIN | NL | 0.010889974 | -0.058235294 | C | 0 | 1 | CIN | 1925 | 1925 |
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 );