mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
1,132 rows where prev_franch = "HOU" sorted by year_left
This data as json, copyable, CSV (advanced)
Suggested facets: age, lg_ID, stint_ID, franch_id, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64820 | 64820 | Dean Stone | 31 | stonede01 | 1962 | CHW | AL | 0.87761194 | 0.575 | P | 3 | 2 | CHW | HOU | 1962 | 1962 | BAL |
64941 | 64941 | Don Buddin | 28 | buddido01 | 1962 | DET | AL | 1.069031473 | -0.005031056 | SS, 3B, 2B | 2 | 2 | DET | HOU | 1962 | 1962 | |
63962 | 63962 | George Brunet | 28 | brunege01 | 1963 | BAL | AL | 0.578512397 | -0.355 | P | 0 | 2 | BAL | HOU | 1963 | 1963 | ANA |
64407 | 64407 | Norm Larker | 32 | larkeno01 | 1963 | MLN | NL | 1.783530229 | -0.188834356 | 1B | 2 | 1 | ATL | HOU | 1963 | 1963 | SFG |
64594 | 64594 | Joey Amalfitano | 29 | amalfjo01 | 1963 | SFG | NL | 1.560949868 | -0.505 | 2B, 3B | 0 | 1 | SFG | HOU | 1963 | 1963 | CHC |
63236 | 63236 | Roman Mejias | 33 | mejiaro01 | 1964 | BOS | AL | 1.115975287 | -0.05 | LF, CF, RF | 1 | 1 | BOS | HOU | 1963 | 1964 | |
63284 | 63284 | Merritt Ranew | 26 | ranewme01 | 1964 | CHC | NL | 0.367929515 | -0.5 | C | 0 | 1 | CHC | HOU | 1963 | 1964 | ATL |
63353 | 63353 | Johnny Temple | 36 | templjo01 | 1964 | CIN | NL | 0.051011434 | -0.024846626 | 0 | 1 | CIN | HOU | 1964 | 1964 | ||
63354 | 63354 | Jim Dickson | 26 | dicksji01 | 1964 | CIN | NL | 0.143149284 | -0.064601227 | 0 | 1 | CIN | HOU | 1964 | 1964 | OAK | |
63357 | 63357 | Hal Smith | 33 | smithha08 | 1964 | CIN | NL | 0.795778364 | -0.427361963 | C | 0 | 1 | CIN | HOU | 1964 | 1964 | |
63498 | 63498 | George Williams | 24 | willige01 | 1964 | KCA | AL | 1.002246414 | -0.054662577 | 2B, 3B, LF, SS | 1 | 1 | OAK | HOU | 1964 | 1964 | |
63879 | 63879 | Bobby Shantz | 38 | shantbo01 | 1964 | STL | NL | 0.503806228 | 0.255 | P | 1 | 1 | STL | HOU | 1962 | 1964 | CHC |
63980 | 63980 | Roman Mejias | 32 | mejiaro01 | 1963 | BOS | AL | 3.882290935 | -0.28173913 | CF, RF, LF | 4 | 1 | BOS | HOU | 1963 | 1964 | |
64009 | 64009 | Merritt Ranew | 25 | ranewme01 | 1963 | CHC | NL | 1.741993848 | 1.26 | C, 1B | 6 | 1 | CHC | HOU | 1963 | 1964 | ATL |
64611 | 64611 | Bobby Shantz | 37 | shantbo01 | 1963 | STL | NL | 2.276993166 | 1.47 | P | 7 | 1 | STL | HOU | 1962 | 1964 | CHC |
65385 | 65385 | Bobby Shantz | 36 | shantbo01 | 1962 | STL | NL | 1.655125285 | 0.849754601 | P | 4 | 2 | STL | HOU | 1962 | 1964 | CHC |
62447 | 62447 | Don Larsen | 35 | larsedo01 | 1965 | BAL | AL | 1.534852245 | 0.395 | P | 4 | 2 | BAL | HOU | 1965 | 1965 | CHC |
62906 | 62906 | Frank Thomas | 36 | thomafr03 | 1965 | MLN | NL | 0.370804475 | -0.145 | 1B, LF, RF, 3B | 0 | 3 | ATL | HOU | 1965 | 1965 | CHC |
62909 | 62909 | Bobby Tiefenauer | 35 | tiefebo01 | 1965 | MLN | NL | 0.202991945 | -0.17 | P | 0 | 1 | ATL | HOU | 1963 | 1965 | NYY |
63134 | 63134 | Carl Warwick | 28 | warwica01 | 1965 | STL | NL | 0.816475495 | -0.815 | RF, 1B, LF, CF | 0 | 1 | STL | HOU | 1964 | 1965 | BAL |
63650 | 63650 | Bobby Tiefenauer | 34 | tiefebo01 | 1964 | MLN | NL | 2.137081784 | 0.19 | P | 4 | 1 | ATL | HOU | 1963 | 1965 | NYY |
63874 | 63874 | Carl Warwick | 27 | warwica01 | 1964 | STL | NL | 1.742228432 | 0.13 | RF, LF | 3 | 1 | STL | HOU | 1964 | 1965 | BAL |
64402 | 64402 | Bobby Tiefenauer | 33 | tiefebo01 | 1963 | MLN | NL | 0.846467391 | 0.919325153 | P | 4 | 1 | ATL | HOU | 1963 | 1965 | NYY |
61742 | 61742 | Eddie Kasko | 35 | kaskoed01 | 1966 | BOS | AL | 1.533484084 | 0.9 | SS, 3B, 2B | 5 | 1 | BOS | HOU | 1966 | 1966 | |
61794 | 61794 | Al Spangler | 32 | spangal01 | 1966 | CAL | AL | 0.11328125 | 0.395 | RF | 1 | 1 | ANA | HOU | 1965 | 1966 | CHC |
61829 | 61829 | Robin Roberts | 39 | roberro01 | 1966 | CHC | NL | 1.392318244 | -0.075 | P | 1 | 2 | CHC | HOU | 1966 | 1966 | |
61855 | 61855 | Don Lee | 32 | leedo01 | 1966 | CHC | NL | 0.547325103 | -0.615 | P | 0 | 2 | CHC | HOU | 1966 | 1966 | |
61955 | 61955 | Don McMahon | 36 | mcmahdo02 | 1966 | CLE | AL | 0.353021354 | 0.04 | P | 1 | 1 | CLE | HOU | 1964 | 1966 | BOS |
61964 | 61964 | Jim Gentile | 32 | gentiji01 | 1966 | CLE | AL | 0.540501792 | -0.465 | 1B | 0 | 2 | CLE | HOU | 1966 | 1966 | |
62073 | 62073 | Ernie Fazio | 24 | fazioer01 | 1966 | KCA | AL | 0.403958944 | 0.0658125 | 2B, SS | 1 | 1 | OAK | HOU | 1966 | 1966 | |
62305 | 62305 | Dave Roberts | 33 | roberda03 | 1966 | PIT | NL | 0.160971379 | -0.24 | 1B | 0 | 1 | PIT | HOU | 1966 | 1966 | |
62508 | 62508 | Al Spangler | 31 | spangal01 | 1965 | CAL | AL | 1.090777577 | 0.195 | LF, CF, RF | 2 | 2 | ANA | HOU | 1965 | 1966 | CHC |
62654 | 62654 | Don McMahon | 35 | mcmahdo02 | 1965 | CLE | AL | 2.448 | 0.39 | P | 5 | 1 | CLE | HOU | 1964 | 1966 | BOS |
63365 | 63365 | Don McMahon | 34 | mcmahdo02 | 1964 | CLE | AL | 2.851445216 | 1.753353659 | P | 10 | 1 | CLE | HOU | 1964 | 1966 | BOS |
60889 | 60889 | Bob Bruce | 34 | brucebo01 | 1967 | ATL | NL | 1.116918845 | -0.235 | P | 1 | 1 | ATL | HOU | 1967 | 1967 | |
60896 | 60896 | Jim Beauchamp | 27 | beaucji01 | 1967 | ATL | NL | 0.041076487 | -0.09 | 0 | 1 | ATL | HOU | 1965 | 1967 | CIN | |
60902 | 60902 | Dave Nicholson | 27 | nichoda01 | 1967 | ATL | NL | 0.297804533 | -0.34 | LF, CF | 0 | 1 | ATL | HOU | 1967 | 1967 | |
61104 | 61104 | Jack Lamabe | 30 | lamabja01 | 1967 | CHW | AL | 0.140908074 | 0.065 | P | 0 | 1 | CHW | HOU | 1966 | 1967 | NYM |
61111 | 61111 | Aurelio Monteagudo | 23 | monteau01 | 1967 | CHW | AL | 0.037575486 | -0.215 | 0 | 1 | CHW | HOU | 1967 | 1967 | KCR | |
61130 | 61130 | Don Nottebart | 31 | nottedo01 | 1967 | CIN | NL | 2.269754768 | 1.47 | P | 8 | 1 | CIN | HOU | 1966 | 1967 | NYY |
61222 | 61222 | Jim Landis | 33 | landiji01 | 1967 | DET | AL | 0.567832168 | -0.109325153 | LF, RF, CF | 0 | 2 | DET | HOU | 1967 | 1967 | BOS |
61226 | 61226 | Bill Heath | 28 | heathbi01 | 1967 | DET | AL | 0.334615385 | -0.626134969 | C | 0 | 2 | DET | HOU | 1967 | 1967 | CHC |
61367 | 61367 | Carroll Hardy | 34 | hardyca01 | 1967 | MIN | AL | 0.092536784 | 0.212378049 | RF, LF | 1 | 1 | MIN | HOU | 1967 | 1967 | |
61368 | 61368 | Walt Bond | 29 | bondwa01 | 1967 | MIN | AL | 0.205637298 | 0.103719512 | LF | 1 | 1 | MIN | HOU | 1967 | 1967 | |
61614 | 61614 | Hal Woodeshick | 34 | woodeha01 | 1967 | STL | NL | 1.194539249 | -1.036397516 | P | 0 | 1 | STL | HOU | 1965 | 1967 | |
61875 | 61875 | Jack Lamabe | 29 | lamabja01 | 1966 | CHW | AL | 3.454134659 | 0.31803681 | P | 6 | 1 | CHW | HOU | 1966 | 1967 | NYM |
61908 | 61908 | Don Nottebart | 30 | nottedo01 | 1966 | CIN | NL | 3.272218334 | 1.5136875 | P | 9 | 1 | CIN | HOU | 1966 | 1967 | NYY |
62361 | 62361 | Hal Woodeshick | 33 | woodeha01 | 1966 | STL | NL | 2.023749715 | 1.065 | P | 6 | 1 | STL | HOU | 1965 | 1967 | |
62904 | 62904 | Jim Beauchamp | 25 | beaucji01 | 1965 | MLN | NL | 0.041200497 | -0.11 | LF, 1B | 0 | 2 | ATL | HOU | 1965 | 1967 | CIN |
63113 | 63113 | Hal Woodeshick | 32 | woodeha01 | 1965 | STL | NL | 1.714872263 | 1.525 | P | 7 | 2 | STL | HOU | 1965 | 1967 | |
60288 | 60288 | Larry Sherry | 32 | sherrla01 | 1968 | CAL | AL | 0.087682672 | -0.17 | 0 | 1 | ANA | HOU | 1968 | 1968 | ||
60477 | 60477 | Eddie Mathews | 36 | matheed01 | 1968 | DET | AL | 0.580305424 | 0.251890244 | 1B, 3B | 2 | 1 | DET | HOU | 1967 | 1968 | |
60818 | 60818 | Ron Davis | 26 | davisro01 | 1968 | STL | NL | 0.901071429 | -0.075 | CF, RF, LF | 1 | 2 | STL | HOU | 1968 | 1968 | PIT |
61205 | 61205 | Eddie Mathews | 35 | matheed01 | 1967 | DET | AL | 1.297902098 | 0.785153374 | 1B, 3B | 4 | 2 | DET | HOU | 1967 | 1968 | |
59242 | 59242 | Ken Johnson | 36 | johnske02 | 1969 | ATL | NL | 0.842906574 | -0.05 | P | 1 | 1 | ATL | HOU | 1965 | 1969 | NYY |
59244 | 59244 | Claude Raymond | 32 | raymocl01 | 1969 | ATL | NL | 1.395155709 | -0.495 | P | 1 | 1 | ATL | HOU | 1967 | 1969 | WSN |
59506 | 59506 | Lee Maye | 34 | mayele01 | 1969 | CLE | AL | 1.22083482 | 0.327018634 | RF, LF, CF | 3 | 1 | CLE | HOU | 1967 | 1969 | TEX |
59519 | 59519 | Gary Kroll | 27 | krollga01 | 1969 | CLE | AL | 0.701461378 | -0.035217391 | 1 | 1 | CLE | HOU | 1969 | 1969 | ||
59635 | 59635 | Chris Zachary | 25 | zachach02 | 1969 | KCR | AL | 0.525716887 | -0.382638037 | P | 0 | 1 | KCR | HOU | 1969 | 1969 | STL |
59738 | 59738 | Steve Shea | 26 | sheast01 | 1969 | MON | NL | 0.461430575 | 0.005 | 1 | 1 | WSN | HOU | 1969 | 1969 | ||
59822 | 59822 | Dick Simpson | 25 | simpsdi01 | 1969 | NYY | AL | 0.146385434 | -0.01 | CF, LF | 0 | 1 | NYY | HOU | 1969 | 1969 | MIL |
59888 | 59888 | Turk Farrell | 35 | farretu01 | 1969 | PHI | NL | 2.177126918 | 0.25 | P | 3 | 1 | PHI | HOU | 1967 | 1969 | |
59931 | 59931 | Bo Belinsky | 32 | belinbo01 | 1969 | PIT | NL | 0.513258012 | -0.035 | P | 1 | 1 | PIT | HOU | 1969 | 1969 | CIN |
60005 | 60005 | Dooley Womack | 29 | womacdo01 | 1969 | SEP | AL | 0.411295832 | 0.342883436 | P | 2 | 2 | MIL | HOU | 1969 | 1969 | OAK |
60084 | 60084 | Dave Giusti | 29 | giustda01 | 1969 | STL | NL | 2.866468843 | 1.155 | P | 7 | 1 | STL | HOU | 1969 | 1969 | PIT |
60087 | 60087 | Joe Hoerner | 32 | hoernjo01 | 1969 | STL | NL | 1.533896371 | 0.755 | P | 4 | 1 | STL | HOU | 1966 | 1969 | PHI |
60091 | 60091 | Byron Browne | 26 | brownby01 | 1969 | STL | NL | 0.655714538 | 0.51 | RF, LF, CF | 2 | 1 | STL | HOU | 1969 | 1969 | PHI |
60162 | 60162 | Ken Johnson | 35 | johnske02 | 1968 | ATL | NL | 3.845806014 | 0.516809816 | P | 7 | 1 | ATL | HOU | 1965 | 1969 | NYY |
60170 | 60170 | Claude Raymond | 31 | raymocl01 | 1968 | ATL | NL | 1.718742935 | 0.347852761 | P | 3 | 1 | ATL | HOU | 1967 | 1969 | WSN |
60425 | 60425 | Lee Maye | 33 | mayele01 | 1968 | CLE | AL | 3.314285714 | 1.385 | LF, RF, 1B | 9 | 1 | CLE | HOU | 1967 | 1969 | TEX |
60720 | 60720 | Turk Farrell | 34 | farretu01 | 1968 | PHI | NL | 2.397790055 | -0.415 | P | 3 | 1 | PHI | HOU | 1967 | 1969 | |
60809 | 60809 | Joe Hoerner | 31 | hoernjo01 | 1968 | STL | NL | 1.39148073 | 1.12 | P | 5 | 1 | STL | HOU | 1966 | 1969 | PHI |
60870 | 60870 | Ken Johnson | 34 | johnske02 | 1967 | ATL | NL | 6.07565337 | 2.54 | P | 16 | 1 | ATL | HOU | 1965 | 1969 | NYY |
60884 | 60884 | Claude Raymond | 30 | raymocl01 | 1967 | ATL | NL | 0.991746905 | 0.305 | P | 2 | 2 | ATL | HOU | 1967 | 1969 | WSN |
61164 | 61164 | Lee Maye | 32 | mayele01 | 1967 | CLE | AL | 3.377738201 | 0.835 | RF, LF, CF, 2B | 7 | 1 | CLE | HOU | 1967 | 1969 | TEX |
61482 | 61482 | Turk Farrell | 33 | farretu01 | 1967 | PHI | NL | 2.660546247 | 2.095 | P | 10 | 2 | PHI | HOU | 1967 | 1969 | |
61603 | 61603 | Joe Hoerner | 30 | hoernjo01 | 1967 | STL | NL | 1.892150171 | 0.39242236 | P | 4 | 1 | STL | HOU | 1966 | 1969 | PHI |
61655 | 61655 | Ken Johnson | 33 | johnske02 | 1966 | ATL | NL | 6.164700544 | 2.703312883 | P | 16 | 1 | ATL | HOU | 1965 | 1969 | NYY |
62358 | 62358 | Joe Hoerner | 29 | hoernjo01 | 1966 | STL | NL | 2.186800639 | 2.015 | P | 9 | 1 | STL | HOU | 1966 | 1969 | PHI |
62882 | 62882 | Ken Johnson | 32 | johnske02 | 1965 | MLN | NL | 5.210126582 | 2.255 | P | 13 | 2 | ATL | HOU | 1965 | 1969 | NYY |
58334 | 58334 | Bob Aspromonte | 32 | asprobo01 | 1970 | ATL | NL | 1.442381786 | -0.775 | 3B, SS, 1B, LF | 0 | 1 | ATL | HOU | 1969 | 1970 | NYM |
58785 | 58785 | Sandy Valdespino | 31 | valdesa01 | 1970 | MIL | AL | 0.090893261 | -0.238527607 | LF | 0 | 1 | MIL | HOU | 1969 | 1970 | KCR |
58861 | 58861 | Jose Herrera | 28 | herrejo01 | 1970 | MON | NL | 0.009969062 | -0.015 | 0 | 1 | WSN | HOU | 1969 | 1970 | ||
58868 | 58868 | Carroll Sembera | 28 | sembeca01 | 1970 | MON | NL | 0.194624652 | -0.645 | 0 | 1 | WSN | HOU | 1969 | 1970 | ||
58969 | 58969 | Tommy Davis | 31 | davisto02 | 1970 | OAK | AL | 2.166696035 | -0.59 | LF, 1B, RF | 1 | 2 | OAK | HOU | 1970 | 1970 | CHC |
59074 | 59074 | Tom Dukes | 27 | dukesto01 | 1970 | SDP | NL | 2.012034251 | -0.04 | P | 2 | 1 | SDP | HOU | 1969 | 1970 | BAL |
59079 | 59079 | Ron Willis | 26 | williro01 | 1970 | SDP | NL | 1.632955334 | -0.445 | P | 1 | 1 | SDP | HOU | 1970 | 1970 | |
59239 | 59239 | Bob Aspromonte | 31 | asprobo01 | 1969 | ATL | NL | 2.217677396 | -0.225 | LF, 3B, SS, 2B | 3 | 1 | ATL | HOU | 1969 | 1970 | NYM |
59732 | 59732 | Carroll Sembera | 27 | sembeca01 | 1969 | MON | NL | 0.971949509 | 0.15 | P | 2 | 1 | WSN | HOU | 1969 | 1970 | |
59733 | 59733 | Jose Herrera | 27 | herrejo01 | 1969 | MON | NL | 1.33262637 | 0.13 | LF, CF, 2B, 3B | 2 | 1 | WSN | HOU | 1969 | 1970 | |
59974 | 59974 | Tom Dukes | 26 | dukesto01 | 1969 | SDP | NL | 0.659479728 | -0.32 | P | 0 | 1 | SDP | HOU | 1969 | 1970 | BAL |
60022 | 60022 | Sandy Valdespino | 30 | valdesa01 | 1969 | SEP | AL | 0.400621654 | -0.16398773 | LF | 0 | 2 | MIL | HOU | 1969 | 1970 | KCR |
57434 | 57434 | Hal King | 27 | kingha01 | 1971 | ATL | NL | 2.372958736 | 0.145 | C | 4 | 1 | ATL | HOU | 1970 | 1971 | TEX |
57566 | 57566 | Brock Davis | 27 | davisbr02 | 1971 | CHC | NL | 3.532577904 | -0.055 | CF, RF, LF | 5 | 1 | CHC | HOU | 1970 | 1971 | MIL |
57582 | 57582 | Hector Torres | 25 | torrehe01 | 1971 | CHC | NL | 0.646954674 | -0.07 | SS, 2B | 1 | 1 | CHC | HOU | 1971 | 1971 | WSN |
57808 | 57808 | Chuck Harrison | 30 | harrich02 | 1971 | KCR | AL | 1.679926673 | -0.52826087 | 1B | 1 | 1 | KCR | HOU | 1969 | 1971 | |
57885 | 57885 | Danny Walton | 23 | waltoda01 | 1971 | MIL | AL | 0.814072184 | -0.291801242 | LF, RF, 3B | 0 | 1 | MIL | HOU | 1969 | 1971 | NYY |
57927 | 57927 | Rusty Staub | 27 | staubru01 | 1971 | MON | NL | 7.091972355 | 5.825 | RF | 28 | 1 | WSN | HOU | 1969 | 1971 | NYM |
57947 | 57947 | Howie Reed | 34 | reedho01 | 1971 | MON | NL | 1.65930746 | -0.345 | P | 1 | 1 | WSN | HOU | 1969 | 1971 | |
57952 | 57952 | Ron Brand | 31 | brandro01 | 1971 | MON | NL | 0.626971469 | -0.205 | SS, 3B, LF, 2B, C, CF | 0 | 1 | WSN | HOU | 1969 | 1971 |
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 );