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,962 rows where prev_franch = "CHW" sorted by year_left
This data as json, copyable, CSV (advanced)
Suggested facets: age, lg_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
97946 | 97946 | Jack Katoll | 30 | katolja01 | 1902 | BLA | AL | 5.108108108 | -0.046285714 | P, OF | 5 | 2 | NYY | CHW | 1902 | 1902 | |
98069 | 98069 | Sammy Strang | 25 | stransa01 | 1902 | CHC | NL | 0.130952381 | 0.103404255 | 3B, 2B | 0 | 2 | CHC | CHW | 1902 | 1902 | LAD |
98108 | 98108 | Dummy Hoy | 40 | hoydu01 | 1902 | CIN | NL | 4.072727273 | 2.131276596 | OF | 11 | 1 | CIN | CHW | 1902 | 1902 | |
98148 | 98148 | Zaza Harvey | 23 | harveza01 | 1902 | CLE | AL | 0.60492282 | 0.254233577 | OF | 2 | 1 | CLE | CHW | 1901 | 1902 | |
98181 | 98181 | Sam McMackin | 29 | mcmacsa01 | 1902 | DET | AL | 0.293952968 | 0.130072993 | P | 1 | 2 | DET | CHW | 1902 | 1902 | |
98304 | 98304 | Jimmy Burke | 27 | burkeji01 | 1902 | PIT | NL | 2.696845555 | 1.608510638 | 2B, OF, 3B, SS | 9 | 1 | PIT | CHW | 1901 | 1902 | STL |
98352 | 98352 | Fred Hartman | 37 | hartmfr01 | 1902 | STL | NL | 5.522028799 | -0.879428571 | 3B, SS, 1B | 5 | 1 | STL | CHW | 1902 | 1902 | |
98570 | 98570 | Zaza Harvey | 22 | harveza01 | 1901 | CLE | AL | 2.248828291 | 1.490869565 | OF, P | 8 | 2 | CLE | CHW | 1901 | 1902 | |
98745 | 98745 | Jimmy Burke | 26 | burkeji01 | 1901 | PIT | NL | 0.682907024 | -0.098357143 | 3B, SS | 1 | 3 | PIT | CHW | 1901 | 1902 | STL |
97588 | 97588 | Wiley Piatt | 28 | piattwi01 | 1903 | BSN | NL | 6.629651163 | 2.123357143 | P | 16 | 1 | ATL | CHW | 1903 | 1903 | |
97656 | 97656 | Tom Daly | 37 | dalyto01 | 1903 | CIN | NL | 3.968672712 | 0.867446809 | 2B | 8 | 2 | CIN | CHW | 1903 | 1903 | |
97716 | 97716 | John Skopec | 23 | skopejo01 | 1903 | DET | AL | 1.391743892 | 0.118248175 | P | 2 | 1 | DET | CHW | 1903 | 1903 | |
97745 | 97745 | George Davis | 32 | davisge01 | 1903 | NYG | NL | 0.19028091 | -0.096971831 | SS | 0 | 1 | SFG | CHW | 1903 | 1903 | CHW |
97756 | 97756 | Herm McFarland | 33 | mcfarhe01 | 1903 | NYY | AL | 5.402774719 | 1.578308824 | OF | 13 | 1 | NYY | CHW | 1902 | 1903 | |
97937 | 97937 | Herm McFarland | 32 | mcfarhe01 | 1902 | BLA | AL | 3.399002494 | 2.505214286 | OF | 11 | 2 | NYY | CHW | 1902 | 1903 | |
97155 | 97155 | Ned Garvin | 30 | garvine01 | 1904 | BRO | NL | 5.705383848 | 0.746883117 | P | 9 | 1 | LAD | CHW | 1902 | 1904 | NYY |
97313 | 97313 | Frank Huelsman | 30 | huelsfr01 | 1904 | DET | AL | 0.210345486 | 0.115 | OF | 1 | 2 | DET | CHW | 1904 | 1904 | BAL |
97530 | 97530 | Davey Dunkle | 31 | dunklda01 | 1904 | WSH | AL | 2.427682737 | -0.804840764 | P | 0 | 1 | MIN | CHW | 1903 | 1904 | |
97556 | 97556 | Ned Garvin | 29 | garvine01 | 1903 | BRO | NL | 10.49706458 | 2.762158273 | P | 23 | 1 | LAD | CHW | 1902 | 1904 | NYY |
97920 | 97920 | Davey Dunkle | 30 | dunklda01 | 1903 | WSH | AL | 4.304635762 | 0.347142857 | P | 6 | 2 | MIN | CHW | 1903 | 1904 | |
98010 | 98010 | Ned Garvin | 28 | garvine01 | 1902 | BRO | NL | 0.601910828 | 0.585957447 | P | 3 | 2 | LAD | CHW | 1902 | 1904 | NYY |
96862 | 96862 | Cozy Dolan | 32 | dolanco01 | 1905 | CIN | NL | 0.949567181 | -0.55916129 | OF, 1B, P | 0 | 1 | CIN | CHW | 1903 | 1905 | ATL |
97028 | 97028 | Patsy Flaherty | 29 | flahepa02 | 1905 | PIT | NL | 5.989361702 | 1.128774194 | P, OF | 14 | 1 | PIT | CHW | 1904 | 1905 | ATL |
97061 | 97061 | Joe Sugden | 34 | sugdejo01 | 1905 | SLB | AL | 3.355555556 | -0.088269231 | C, 1B | 3 | 1 | BAL | CHW | 1902 | 1905 | DET |
97089 | 97089 | Dave Brain | 26 | brainda01 | 1905 | STL | NL | 1.932190026 | 0.073636364 | 3B, SS, OF | 3 | 1 | STL | CHW | 1903 | 1905 | PIT |
97261 | 97261 | Cozy Dolan | 31 | dolanco01 | 1904 | CIN | NL | 5.786697248 | 1.89343949 | OF, 1B | 14 | 1 | CIN | CHW | 1903 | 1905 | ATL |
97426 | 97426 | Patsy Flaherty | 28 | flahepa02 | 1904 | PIT | NL | 7.538195303 | 3.883846154 | P, OF | 23 | 2 | PIT | CHW | 1904 | 1905 | ATL |
97463 | 97463 | Joe Sugden | 33 | sugdejo01 | 1904 | SLB | AL | 4.304042513 | 2.284615385 | C, 1B | 12 | 1 | BAL | CHW | 1902 | 1905 | DET |
97485 | 97485 | Dave Brain | 25 | brainda01 | 1904 | STL | NL | 5.85697446 | 3.313636364 | SS, 3B, OF, 2B, 1B | 17 | 1 | STL | CHW | 1903 | 1905 | PIT |
97659 | 97659 | Cozy Dolan | 30 | dolanco01 | 1903 | CIN | NL | 5.044517725 | -0.281489362 | OF, 1B | 6 | 2 | CIN | CHW | 1903 | 1905 | ATL |
97863 | 97863 | Joe Sugden | 32 | sugdejo01 | 1903 | SLB | AL | 3.547906161 | 0.687625899 | C, 1B | 7 | 1 | BAL | CHW | 1902 | 1905 | DET |
97885 | 97885 | Dave Brain | 24 | brainda01 | 1903 | STL | NL | 6.263444372 | 0.18647482 | SS, 3B | 8 | 1 | STL | CHW | 1903 | 1905 | PIT |
98329 | 98329 | Joe Sugden | 31 | sugdejo01 | 1902 | SLB | AL | 2.852258337 | 1.019784173 | C, 1B, P | 8 | 1 | BAL | CHW | 1902 | 1905 | DET |
96313 | 96313 | Ed Hughes | 25 | hugheed01 | 1906 | BOS | AL | 0.303907381 | -0.109741935 | P | 0 | 1 | BOS | CHW | 1905 | 1906 | |
96514 | 96514 | Sam Mertes | 33 | mertesa01 | 1906 | NYG | NL | 3.344827586 | 0.959210526 | OF | 8 | 1 | SFG | CHW | 1903 | 1906 | STL |
96688 | 96688 | Jack Slattery | 28 | slattja01 | 1906 | STL | NL | 0.113591853 | -0.021038961 | C | 0 | 1 | STL | CHW | 1906 | 1906 | MIN |
96751 | 96751 | Ed Hughes | 24 | hugheed01 | 1905 | BOS | AL | 1.032194642 | -0.344117647 | P | 0 | 1 | BOS | CHW | 1905 | 1906 | |
96927 | 96927 | Sam Mertes | 32 | mertesa01 | 1905 | NYG | NL | 6.891415577 | 3.919354839 | OF | 22 | 1 | SFG | CHW | 1903 | 1906 | STL |
97328 | 97328 | Sam Mertes | 31 | mertesa01 | 1904 | NYG | NL | 6.723202428 | 4.529808917 | OF, SS | 24 | 1 | SFG | CHW | 1903 | 1906 | STL |
97730 | 97730 | Sam Mertes | 30 | mertesa01 | 1903 | NYG | NL | 7.040393685 | 4.688873239 | OF, 1B, C | 25 | 1 | SFG | CHW | 1903 | 1906 | STL |
95882 | 95882 | Elmer Stricklett | 30 | stricel01 | 1907 | BRO | NL | 7.111821086 | 2.085882353 | P, OF | 16 | 1 | LAD | CHW | 1905 | 1907 | |
96116 | 96116 | Clark Griffith | 37 | griffcl01 | 1907 | NYY | AL | 0.262434391 | -0.580855263 | P | 0 | 1 | NYY | CHW | 1903 | 1907 | CIN |
96138 | 96138 | Claude Berry | 27 | berrycl01 | 1907 | PHA | AL | 0.241570805 | 0.0486 | C | 0 | 1 | OAK | CHW | 1906 | 1907 | |
96181 | 96181 | Bill Hallman | 31 | hallmbi02 | 1907 | PIT | NL | 3.936600545 | -0.325031847 | OF | 5 | 1 | PIT | CHW | 1906 | 1907 | |
96261 | 96261 | Charlie Jones | 31 | jonesch03 | 1907 | WSH | AL | 5.375993795 | 1.704155844 | OF, 2B, 1B, SS | 9 | 1 | MIN | CHW | 1905 | 1907 | BAL |
96272 | 96272 | Mike Heydon | 32 | heydomi01 | 1907 | WSH | AL | 2.170641846 | -0.073636364 | C | 2 | 1 | MIN | CHW | 1905 | 1907 | |
96321 | 96321 | Elmer Stricklett | 29 | stricel01 | 1906 | BRO | NL | 9.083044983 | 2.694705882 | P | 21 | 1 | LAD | CHW | 1905 | 1907 | |
96545 | 96545 | Clark Griffith | 36 | griffcl01 | 1906 | NYY | AL | 1.845813896 | 0.172451613 | P | 3 | 1 | NYY | CHW | 1903 | 1907 | CIN |
96569 | 96569 | Claude Berry | 26 | berrycl01 | 1906 | PHA | AL | 0.374798061 | 0.086979866 | C | 1 | 1 | OAK | CHW | 1906 | 1907 | |
96623 | 96623 | Bill Hallman | 30 | hallmbi02 | 1906 | PIT | NL | 1.180919139 | 0.473376623 | OF | 3 | 1 | PIT | CHW | 1906 | 1907 | |
96707 | 96707 | Charlie Jones | 30 | jonesch03 | 1906 | WSH | AL | 6.397575758 | 1.174768212 | OF, 2B | 11 | 1 | MIN | CHW | 1905 | 1907 | BAL |
96713 | 96713 | Mike Heydon | 31 | heydomi01 | 1906 | WSH | AL | 1.886464646 | -0.193112583 | C | 2 | 1 | MIN | CHW | 1905 | 1907 | |
96758 | 96758 | Elmer Stricklett | 28 | stricel01 | 1905 | BRO | NL | 7.400148478 | 0.705483871 | P | 11 | 1 | LAD | CHW | 1905 | 1907 | |
96950 | 96950 | Clark Griffith | 35 | griffcl01 | 1905 | NYY | AL | 3.154395469 | 2.803026316 | P, OF | 12 | 1 | NYY | CHW | 1903 | 1907 | CIN |
97112 | 97112 | Charlie Jones | 29 | jonesch03 | 1905 | WSH | AL | 6.794979079 | 0.646948052 | OF | 11 | 1 | MIN | CHW | 1905 | 1907 | BAL |
97115 | 97115 | Mike Heydon | 30 | heydomi01 | 1905 | WSH | AL | 3.143255629 | 0.59961039 | C | 6 | 1 | MIN | CHW | 1905 | 1907 | |
97356 | 97356 | Clark Griffith | 34 | griffcl01 | 1904 | NYY | AL | 3.05214872 | 0.851806452 | P | 7 | 1 | NYY | CHW | 1903 | 1907 | CIN |
97750 | 97750 | Clark Griffith | 33 | griffcl01 | 1903 | NYY | AL | 7.44672586 | 4.216764706 | P | 24 | 1 | NYY | CHW | 1903 | 1907 | CIN |
95397 | 95397 | Ed McFarland | 34 | mcfared01 | 1908 | BOS | AL | 0.568627451 | 0.229935484 | C | 1 | 1 | BOS | CHW | 1908 | 1908 | |
95566 | 95566 | Charlie Hickman | 32 | hickmch01 | 1908 | CLE | AL | 2.331100478 | 0.185732484 | OF, 1B, 2B | 4 | 1 | CLE | CHW | 1908 | 1908 | |
94927 | 94927 | Al Shaw | 36 | shawal01 | 1909 | BSN | NL | 0.551202483 | -0.297870968 | C | 0 | 1 | ATL | CHW | 1909 | 1909 | |
95276 | 95276 | Jack McAleese | 30 | mcaleja01 | 1909 | SLB | AL | 3.652244566 | -0.226168831 | OF, 3B | 4 | 1 | BAL | CHW | 1909 | 1909 | |
95345 | 95345 | Jiggs Donahue | 29 | donahji02 | 1909 | WSH | AL | 3.691638664 | -0.109038462 | 1B | 3 | 2 | MIN | CHW | 1909 | 1909 | |
95355 | 95355 | Frank Hemphill | 31 | hemphfr01 | 1909 | WSH | AL | 0.034394149 | -0.093461538 | OF | 0 | 1 | MIN | CHW | 1909 | 1909 | |
95357 | 95357 | Gavvy Cravath | 28 | cravaga01 | 1909 | WSH | AL | 0.080253014 | -0.109038462 | OF | 0 | 2 | MIN | CHW | 1909 | 1909 | PHI |
94484 | 94484 | Frank Roth | 31 | rothfr01 | 1910 | CIN | NL | 0.334947839 | -0.103846154 | C, OF | 0 | 1 | CIN | CHW | 1909 | 1910 | |
95014 | 95014 | Frank Roth | 30 | rothfr01 | 1909 | CIN | NL | 1.767161933 | 0.299235669 | C | 3 | 1 | CIN | CHW | 1909 | 1910 | |
93745 | 93745 | Billy Purtell | 25 | purtebi01 | 1911 | BOS | AL | 0.94469697 | 0.190588235 | 3B, 2B, SS, OF | 2 | 1 | BOS | CHW | 1910 | 1911 | DET |
93758 | 93758 | Frank Smith | 31 | smithfr03 | 1911 | BOS | AL | 0.072592593 | -0.084705882 | P | 0 | 1 | BOS | CHW | 1910 | 1911 | CIN |
93791 | 93791 | George Browne | 35 | brownge01 | 1911 | BRO | NL | 0.146978558 | 0.089415584 | OF | 0 | 1 | LAD | CHW | 1911 | 1911 | PHI |
93935 | 93935 | Dave Altizer | 34 | altizda01 | 1911 | CIN | NL | 0.905761982 | 0.193584906 | SS, 1B, 2B, OF | 2 | 1 | CIN | CHW | 1910 | 1911 | |
93937 | 93937 | Bill Burns | 31 | burnsbi01 | 1911 | CIN | NL | 0.502698897 | 0.224150943 | P | 1 | 1 | CIN | CHW | 1910 | 1911 | PHI |
94192 | 94192 | Paul Meloan | 22 | meloapa01 | 1911 | SLB | AL | 2.641961011 | 0.186513158 | OF | 4 | 2 | BAL | CHW | 1911 | 1911 | |
94308 | 94308 | Billy Purtell | 24 | purtebi01 | 1910 | BOS | AL | 2.165706855 | 0.435759494 | 3B, SS | 4 | 2 | BOS | CHW | 1910 | 1911 | DET |
94324 | 94324 | Frank Smith | 30 | smithfr03 | 1910 | BOS | AL | 0.791346825 | -0.276835443 | P | 0 | 2 | BOS | CHW | 1910 | 1911 | CIN |
94466 | 94466 | Bill Burns | 30 | burnsbi01 | 1910 | CIN | NL | 5.429811867 | 0.467307692 | P | 9 | 2 | CIN | CHW | 1910 | 1911 | PHI |
94470 | 94470 | Dave Altizer | 33 | altizda01 | 1910 | CIN | NL | 0.140461997 | 0.321923077 | SS | 1 | 1 | CIN | CHW | 1910 | 1911 | |
93453 | 93453 | Del Paddock | 25 | paddode01 | 1912 | NYY | AL | 2.061479347 | 0.841764706 | 3B, 2B, OF | 5 | 2 | NYY | CHW | 1912 | 1912 | |
93508 | 93508 | Roy Crabb | 21 | crabbro01 | 1912 | PHA | AL | 1.342182891 | -0.238235294 | P | 1 | 2 | OAK | CHW | 1912 | 1912 | |
92845 | 92845 | Rollie Zeider | 29 | zeidero01 | 1913 | NYY | AL | 2.142689601 | -0.338823529 | SS, 2B, 3B, 1B | 2 | 2 | NYY | CHW | 1913 | 1913 | CHC |
92862 | 92862 | Babe Borton | 24 | bortoba01 | 1913 | NYY | AL | 1.473807662 | -0.672352941 | 1B | 0 | 2 | NYY | CHW | 1913 | 1913 | BAL |
92029 | 92029 | Jimmy Johnston | 24 | johnsji01 | 1914 | CHC | NL | 1.214029794 | -0.223269231 | OF, 2B | 1 | 1 | CHC | CHW | 1914 | 1914 | LAD |
92095 | 92095 | Marty Berghammer | 26 | berghma01 | 1914 | CIN | NL | 1.397179788 | 0.294076433 | SS, 2B | 3 | 1 | CIN | CHW | 1913 | 1914 | |
92393 | 92393 | Wiley Taylor | 26 | taylowi01 | 1914 | SLB | AL | 1.483050847 | 0.076415094 | P | 2 | 1 | BAL | CHW | 1913 | 1914 | |
92403 | 92403 | Bobby Messenger | 30 | messebo01 | 1914 | SLB | AL | 0.022171254 | -0.025471698 | OF | 0 | 1 | BAL | CHW | 1914 | 1914 | |
92687 | 92687 | Marty Berghammer | 25 | berghma01 | 1913 | CIN | NL | 2.299848943 | -0.389423077 | SS, 2B | 2 | 1 | CIN | CHW | 1913 | 1914 | |
92998 | 92998 | Wiley Taylor | 25 | taylowi01 | 1913 | SLB | AL | 0.961909354 | -0.167225806 | P | 1 | 1 | BAL | CHW | 1913 | 1914 | |
91479 | 91479 | Polly McLarry | 24 | mclarpo01 | 1915 | CHC | NL | 1.611417697 | -0.389423077 | 2B, 1B | 1 | 1 | CHC | CHW | 1915 | 1915 | |
91547 | 91547 | Phil Douglas | 25 | douglph01 | 1915 | CIN | NL | 1.350419385 | -0.394875 | P | 0 | 1 | CIN | CHW | 1914 | 1915 | LAD |
91641 | 91641 | Howard Baker | 27 | bakerho01 | 1915 | NYG | NL | 0.033130236 | -0.083612903 | 3B | 0 | 2 | SFG | CHW | 1915 | 1915 | |
91870 | 91870 | Fred Lamlein | 27 | lamlifr01 | 1915 | STL | NL | 0.570951586 | 0.405 | P | 2 | 1 | STL | CHW | 1915 | 1915 | |
91885 | 91885 | Chick Gandil | 27 | gandich01 | 1915 | WSH | AL | 6.014236245 | 3.020516129 | 1B | 17 | 1 | MIN | CHW | 1912 | 1915 | CLE |
92084 | 92084 | Phil Douglas | 24 | douglph01 | 1914 | CIN | NL | 7.19018995 | 1.460063694 | P | 13 | 1 | CIN | CHW | 1914 | 1915 | LAD |
92449 | 92449 | Chick Gandil | 26 | gandich01 | 1914 | WSH | AL | 6.679713963 | 3.879745223 | 1B | 20 | 1 | MIN | CHW | 1912 | 1915 | CLE |
93059 | 93059 | Chick Gandil | 25 | gandich01 | 1913 | WSH | AL | 6.746527778 | 4.055225806 | 1B | 23 | 1 | MIN | CHW | 1912 | 1915 | CLE |
93690 | 93690 | Chick Gandil | 24 | gandich01 | 1912 | WSH | AL | 5.517401392 | 2.777142857 | 1B | 17 | 1 | MIN | CHW | 1912 | 1915 | CLE |
90927 | 90927 | Dutch Zwilling | 27 | zwilldu01 | 1916 | CHC | NL | 0.649335863 | -0.659423077 | OF | 0 | 1 | CHC | CHW | 1916 | 1916 | |
90977 | 90977 | Johnny Beall | 34 | bealljo01 | 1916 | CIN | NL | 0.27587519 | 0.386709677 | OF | 1 | 1 | CIN | CHW | 1915 | 1916 | STL |
91018 | 91018 | Tom Daly | 24 | dalyto02 | 1916 | CLE | AL | 0.810508664 | -0.165095541 | C, OF | 1 | 1 | CLE | CHW | 1916 | 1916 | CHC |
91021 | 91021 | Larry Chappell | 26 | chappla01 | 1916 | CLE | AL | 0.032420347 | 0.0 | OF | 0 | 1 | CLE | CHW | 1916 | 1916 | ATL |
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 );