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 year_acq
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90670 | 90670 | Honus Wagner | 43 | wagneho01 | 1917 | PIT | NL | 2.894497154 | 0.077388535 | 1B, 3B, 2B, SS | 3 | 1 | PIT | 1901 | 1917 | ||
91090 | 91090 | Christy Mathewson | 35 | mathech01 | 1916 | NYG | NL | 1.946023406 | -0.010451613 | P | 3 | 1 | SFG | 1901 | 1916 | CIN | |
91225 | 91225 | Honus Wagner | 42 | wagneho01 | 1916 | PIT | NL | 5.320597692 | 2.868535032 | SS, 1B, 2B | 15 | 1 | PIT | 1901 | 1917 | ||
91627 | 91627 | Christy Mathewson | 34 | mathech01 | 1915 | NYG | NL | 5.644508671 | 0.569612903 | P | 10 | 1 | SFG | 1901 | 1916 | CIN | |
91772 | 91772 | Honus Wagner | 41 | wagneho01 | 1915 | PIT | NL | 6.903446962 | 5.695632911 | SS, 2B, 1B | 25 | 1 | PIT | 1901 | 1917 | ||
91793 | 91793 | Fred Clarke | 42 | clarkfr01 | 1915 | PIT | NL | 0.02209103 | 0.015379747 | OF | 0 | 1 | PIT | 1901 | 1915 | ||
92068 | 92068 | Billy Sullivan | 39 | sullibi03 | 1914 | CHW | AL | 0.0 | 0.0 | 0 | 1 | CHW | 1901 | 1914 | DET | ||
92202 | 92202 | Christy Mathewson | 33 | mathech01 | 1914 | NYG | NL | 9.411708253 | 2.715576923 | P | 21 | 1 | SFG | 1901 | 1916 | CIN | |
92275 | 92275 | Eddie Plank | 38 | planked01 | 1914 | PHA | AL | 5.63697479 | 2.73955414 | P | 17 | 1 | OAK | 1901 | 1914 | BAL | |
92338 | 92338 | Honus Wagner | 40 | wagneho01 | 1914 | PIT | NL | 6.783368141 | 3.588607595 | SS, 3B, 1B | 20 | 1 | PIT | 1901 | 1917 | ||
92368 | 92368 | Fred Clarke | 41 | clarkfr01 | 1914 | PIT | NL | 0.022023923 | -0.020506329 | 0 | 1 | PIT | 1901 | 1915 | |||
92657 | 92657 | Jimmy Callahan | 39 | callani01 | 1913 | CHW | AL | 0.104504505 | -0.079411765 | OF | 0 | 1 | CHW | 1901 | 1913 | ||
92791 | 92791 | Christy Mathewson | 32 | mathech01 | 1913 | NYG | NL | 9.059210526 | 6.459230769 | P | 34 | 1 | SFG | 1901 | 1916 | CIN | |
92870 | 92870 | Eddie Plank | 37 | planked01 | 1913 | PHA | AL | 7.548005908 | 3.96 | P | 24 | 1 | OAK | 1901 | 1914 | BAL | |
92944 | 92944 | Honus Wagner | 39 | wagneho01 | 1913 | PIT | NL | 4.956799399 | 3.088451613 | SS | 16 | 1 | PIT | 1901 | 1917 | ||
92971 | 92971 | Fred Clarke | 40 | clarkfr01 | 1913 | PIT | NL | 0.152516905 | -0.209032258 | OF | 0 | 1 | PIT | 1901 | 1915 | ||
93213 | 93213 | Frank Chance | 35 | chancfr01 | 1912 | CHC | NL | 0.098157202 | 0.090592105 | 1B | 0 | 1 | CHC | 1901 | 1912 | NYY | |
93240 | 93240 | Jimmy Callahan | 38 | callani01 | 1912 | CHW | AL | 4.806210251 | -0.425506329 | OF | 6 | 1 | CHW | 1901 | 1913 | ||
93250 | 93250 | Billy Sullivan | 37 | sullibi03 | 1912 | CHW | AL | 1.160867939 | 0.117911392 | C | 2 | 1 | CHW | 1901 | 1914 | DET | |
93414 | 93414 | Christy Mathewson | 31 | mathech01 | 1912 | NYG | NL | 9.524506218 | 7.90012987 | P | 39 | 1 | SFG | 1901 | 1916 | CIN | |
93489 | 93489 | Eddie Plank | 36 | planked01 | 1912 | PHA | AL | 8.042772861 | 4.261764706 | P | 24 | 1 | OAK | 1901 | 1914 | BAL | |
93560 | 93560 | Honus Wagner | 38 | wagneho01 | 1912 | PIT | NL | 6.883564208 | 8.803421053 | SS | 37 | 1 | PIT | 1901 | 1917 | ||
93575 | 93575 | Tommy Leach | 34 | leachto01 | 1912 | PIT | NL | 1.194309247 | 0.698092105 | OF, 3B | 4 | 1 | PIT | 1901 | 1912 | CHC | |
93861 | 93861 | Frank Chance | 34 | chancfr01 | 1911 | CHC | NL | 1.33345595 | 1.057643312 | 1B | 5 | 1 | CHC | 1901 | 1912 | NYY | |
93874 | 93874 | Johnny Kling | 35 | klingjo01 | 1911 | CHC | NL | 0.949420636 | -0.180573248 | C, 3B | 1 | 1 | CHC | 1901 | 1911 | ATL | |
93892 | 93892 | Jimmy Callahan | 37 | callani01 | 1911 | CHW | AL | 5.503489908 | 0.60487013 | OF | 8 | 1 | CHW | 1901 | 1913 | ||
93898 | 93898 | Billy Sullivan | 36 | sullibi03 | 1911 | CHW | AL | 3.140162234 | 0.241948052 | C | 4 | 1 | CHW | 1901 | 1914 | DET | |
94015 | 94015 | Christy Mathewson | 30 | mathech01 | 1911 | NYG | NL | 9.482548206 | 7.705519481 | P | 36 | 1 | SFG | 1901 | 1916 | CIN | |
94081 | 94081 | Eddie Plank | 35 | planked01 | 1911 | PHA | AL | 7.834302326 | 5.147763158 | P | 28 | 1 | OAK | 1901 | 1914 | BAL | |
94093 | 94093 | Harry Davis | 37 | davisha01 | 1911 | PHA | AL | 2.343651529 | -0.245131579 | 1B | 3 | 1 | OAK | 1901 | 1911 | CLE | |
94148 | 94148 | Honus Wagner | 37 | wagneho01 | 1911 | PIT | NL | 6.008524833 | 7.080967742 | SS, 1B, OF | 29 | 1 | PIT | 1901 | 1917 | ||
94151 | 94151 | Fred Clarke | 38 | clarkfr01 | 1911 | PIT | NL | 4.955151964 | 4.05 | OF | 19 | 1 | PIT | 1901 | 1915 | ||
94157 | 94157 | Tommy Leach | 33 | leachto01 | 1911 | PIT | NL | 4.793921423 | 0.742064516 | OF, SS, 3B | 9 | 1 | PIT | 1901 | 1912 | CHC | |
94170 | 94170 | Deacon Phillippe | 39 | phillde01 | 1911 | PIT | NL | 0.183317168 | 0.078387097 | P | 0 | 1 | PIT | 1901 | 1911 | ||
94402 | 94402 | Frank Chance | 33 | chancfr01 | 1910 | CHC | NL | 3.866666667 | 2.729805195 | 1B | 15 | 1 | CHC | 1901 | 1912 | NYY | |
94403 | 94403 | Johnny Kling | 34 | klingjo01 | 1910 | CHC | NL | 3.767238095 | 2.245909091 | C | 14 | 1 | CHC | 1901 | 1911 | ATL | |
94442 | 94442 | Billy Sullivan | 35 | sullibi03 | 1910 | CHW | AL | 1.77038204 | -0.124615385 | C | 2 | 1 | CHW | 1901 | 1914 | DET | |
94527 | 94527 | Bill Bradley | 32 | bradlbi01 | 1910 | CLE | AL | 2.468537883 | -0.729503106 | 3B | 1 | 1 | CLE | 1901 | 1910 | ||
94569 | 94569 | Christy Mathewson | 29 | mathech01 | 1910 | NYG | NL | 9.623535039 | 8.972709677 | P | 39 | 1 | SFG | 1901 | 1916 | CIN | |
94635 | 94635 | Eddie Plank | 34 | planked01 | 1910 | PHA | AL | 7.429175476 | 2.686064516 | P | 19 | 1 | OAK | 1901 | 1914 | BAL | |
94637 | 94637 | Harry Davis | 36 | davisha01 | 1910 | PHA | AL | 6.323473644 | 1.891741935 | 1B | 15 | 1 | OAK | 1901 | 1911 | CLE | |
94688 | 94688 | Honus Wagner | 36 | wagneho01 | 1910 | PIT | NL | 6.992441421 | 6.001363636 | SS, 1B, 2B | 29 | 1 | PIT | 1901 | 1917 | ||
94694 | 94694 | Fred Clarke | 37 | clarkfr01 | 1910 | PIT | NL | 5.633408919 | 2.256428571 | OF | 16 | 1 | PIT | 1901 | 1915 | ||
94695 | 94695 | Tommy Leach | 32 | leachto01 | 1910 | PIT | NL | 6.455404384 | 1.798831169 | OF, SS, 2B | 16 | 1 | PIT | 1901 | 1912 | CHC | |
94698 | 94698 | Deacon Phillippe | 38 | phillde01 | 1910 | PIT | NL | 3.704081633 | 1.725194805 | P | 11 | 1 | PIT | 1901 | 1911 | ||
94700 | 94700 | Sam Leever | 38 | leevesa01 | 1910 | PIT | NL | 3.387755102 | 0.946753247 | P | 8 | 1 | PIT | 1901 | 1910 | ||
94944 | 94944 | Frank Chance | 32 | chancfr01 | 1909 | CHC | NL | 4.167664671 | 2.273225806 | 1B | 14 | 1 | CHC | 1901 | 1912 | NYY | |
94977 | 94977 | Frank Isbell | 33 | isbelfr01 | 1909 | CHW | AL | 5.240765296 | 0.830377358 | 1B, OF, 2B | 9 | 1 | CHW | 1901 | 1909 | ||
94985 | 94985 | Billy Sullivan | 34 | sullibi03 | 1909 | CHW | AL | 3.263118015 | -0.830377358 | C | 2 | 1 | CHW | 1901 | 1914 | DET | |
95036 | 95036 | Emil Haberer | 31 | haberem01 | 1909 | CIN | NL | 0.174534512 | -0.211528662 | C | 0 | 1 | CIN | 1901 | 1909 | ||
95058 | 95058 | Bill Bradley | 31 | bradlbi01 | 1909 | CLE | AL | 4.295023697 | -0.637548387 | 3B, 1B, 2B | 4 | 1 | CLE | 1901 | 1910 | ||
95107 | 95107 | Christy Mathewson | 28 | mathech01 | 1909 | NYG | NL | 8.010208817 | 9.456878981 | P | 40 | 1 | SFG | 1901 | 1916 | CIN | |
95175 | 95175 | Eddie Plank | 33 | planked01 | 1909 | PHA | AL | 8.053818182 | 5.193529412 | P | 26 | 1 | OAK | 1901 | 1914 | BAL | |
95178 | 95178 | Harry Davis | 35 | davisha01 | 1909 | PHA | AL | 6.854235962 | 3.435882353 | 1B | 20 | 1 | OAK | 1901 | 1911 | CLE | |
95232 | 95232 | Honus Wagner | 35 | wagneho01 | 1909 | PIT | NL | 6.404641587 | 9.91987013 | SS, OF | 41 | 1 | PIT | 1901 | 1917 | ||
95234 | 95234 | Fred Clarke | 36 | clarkfr01 | 1909 | PIT | NL | 7.251356916 | 5.764675325 | OF | 30 | 1 | PIT | 1901 | 1915 | ||
95237 | 95237 | Tommy Leach | 31 | leachto01 | 1909 | PIT | NL | 7.446752761 | 4.05 | OF, 3B | 26 | 1 | PIT | 1901 | 1912 | CHC | |
95244 | 95244 | Deacon Phillippe | 37 | phillde01 | 1909 | PIT | NL | 3.94530321 | 1.40961039 | P | 11 | 1 | PIT | 1901 | 1911 | ||
95247 | 95247 | Sam Leever | 37 | leevesa01 | 1909 | PIT | NL | 2.107491082 | 0.320844156 | P | 5 | 1 | PIT | 1901 | 1910 | ||
95372 | 95372 | Cy Young | 41 | youngcy01 | 1908 | BOS | AL | 9.106104651 | 8.471032258 | P | 37 | 1 | BOS | 1901 | 1908 | CLE | |
95385 | 95385 | George Winter | 30 | wintege01 | 1908 | BOS | AL | 4.456395349 | 0.344903226 | P | 7 | 1 | BOS | 1901 | 1908 | DET | |
95390 | 95390 | Lou Criger | 36 | crigelo01 | 1908 | BOS | AL | 2.945490196 | 0.240387097 | C | 4 | 1 | BOS | 1901 | 1908 | BAL | |
95469 | 95469 | Johnny Kling | 32 | klingjo01 | 1908 | CHC | NL | 5.086759713 | 4.347341772 | C, OF, 1B | 21 | 1 | CHC | 1901 | 1911 | ATL | |
95470 | 95470 | Frank Chance | 31 | chancfr01 | 1908 | CHC | NL | 5.65560166 | 3.865443038 | 1B | 21 | 1 | CHC | 1901 | 1912 | NYY | |
95492 | 95492 | Fielder Jones | 36 | jonesfi01 | 1908 | CHW | AL | 7.236211487 | 5.010576923 | OF | 26 | 1 | CHW | 1901 | 1908 | ||
95500 | 95500 | Frank Isbell | 32 | isbelfr01 | 1908 | CHW | AL | 3.99315329 | 1.786153846 | 1B, 2B | 11 | 1 | CHW | 1901 | 1909 | ||
95502 | 95502 | Billy Sullivan | 33 | sullibi03 | 1908 | CHW | AL | 5.206542412 | 0.685384615 | C | 10 | 1 | CHW | 1901 | 1914 | DET | |
95553 | 95553 | Bill Bradley | 30 | bradlbi01 | 1908 | CLE | AL | 7.226411483 | 3.178089172 | 3B, SS | 20 | 1 | CLE | 1901 | 1910 | ||
95606 | 95606 | Christy Mathewson | 27 | mathech01 | 1908 | NYG | NL | 11.67440758 | 11.67019108 | P | 50 | 1 | SFG | 1901 | 1916 | CIN | |
95669 | 95669 | Eddie Plank | 32 | planked01 | 1908 | PHA | AL | 8.253815261 | 6.242675159 | P | 29 | 1 | OAK | 1901 | 1914 | BAL | |
95670 | 95670 | Harry Davis | 34 | davisha01 | 1908 | PHA | AL | 6.713790447 | 3.312229299 | 1B | 18 | 1 | OAK | 1901 | 1911 | CLE | |
95703 | 95703 | Socks Seybold | 37 | seyboso01 | 1908 | PHA | AL | 1.686825886 | -0.768726115 | OF | 0 | 1 | OAK | 1901 | 1908 | ||
95728 | 95728 | Roy Thomas | 34 | thomaro01 | 1908 | PHI | NL | 0.29586031 | -0.141096774 | OF | 0 | 1 | PHI | 1901 | 1908 | PIT | |
95732 | 95732 | Honus Wagner | 34 | wagneho01 | 1908 | PIT | NL | 7.071823204 | 12.17612903 | SS | 49 | 1 | PIT | 1901 | 1917 | ||
95734 | 95734 | Tommy Leach | 30 | leachto01 | 1908 | PIT | NL | 7.38121547 | 5.126516129 | 3B, OF | 28 | 1 | PIT | 1901 | 1912 | CHC | |
95735 | 95735 | Fred Clarke | 35 | clarkfr01 | 1908 | PIT | NL | 7.171270718 | 4.980193548 | OF | 28 | 1 | PIT | 1901 | 1915 | ||
95741 | 95741 | Sam Leever | 36 | leevesa01 | 1908 | PIT | NL | 5.770382696 | 2.03283871 | P | 16 | 1 | PIT | 1901 | 1910 | ||
95761 | 95761 | Deacon Phillippe | 36 | phillde01 | 1908 | PIT | NL | 0.359400998 | -0.491225806 | P | 0 | 1 | PIT | 1901 | 1911 | ||
95841 | 95841 | Casey Patten | 34 | patteca01 | 1908 | WSH | AL | 0.545717036 | -0.229935484 | P | 0 | 1 | MIN | 1901 | 1908 | BOS | |
95842 | 95842 | Cy Young | 40 | youngcy01 | 1907 | BOS | AL | 10.1980198 | 7.143677419 | P | 31 | 1 | BOS | 1901 | 1908 | CLE | |
95843 | 95843 | George Winter | 29 | wintege01 | 1907 | BOS | AL | 7.623762376 | 3.590129032 | P | 18 | 1 | BOS | 1901 | 1908 | DET | |
95844 | 95844 | Freddy Parent | 31 | parenfr01 | 1907 | BOS | AL | 5.042994242 | 3.15116129 | OF, SS, 3B, 2B | 14 | 1 | BOS | 1901 | 1907 | CHW | |
95847 | 95847 | Hobe Ferris | 32 | ferriho01 | 1907 | BOS | AL | 6.490211132 | 1.865612903 | 2B | 12 | 1 | BOS | 1901 | 1907 | BAL | |
95856 | 95856 | Jimmy Collins | 37 | colliji01 | 1907 | BOS | AL | 1.937044146 | 0.888387097 | 3B | 4 | 1 | BOS | 1901 | 1907 | OAK | |
95859 | 95859 | Lou Criger | 35 | crigelo01 | 1907 | BOS | AL | 2.861036468 | 0.162 | C | 3 | 1 | BOS | 1901 | 1908 | BAL | |
95864 | 95864 | Buck Freeman | 35 | freembu01 | 1907 | BOS | AL | 0.166986564 | 0.114967742 | OF | 1 | 1 | BOS | 1901 | 1907 | ||
95903 | 95903 | Fred Tenney | 35 | tennefr02 | 1907 | BSN | NL | 7.561226508 | 4.316447368 | 1B | 22 | 1 | ATL | 1901 | 1907 | SFG | |
95934 | 95934 | Frank Chance | 30 | chancfr01 | 1907 | CHC | NL | 5.175702414 | 5.027225806 | 1B | 24 | 1 | CHC | 1901 | 1912 | NYY | |
95939 | 95939 | Johnny Kling | 31 | klingjo01 | 1907 | CHC | NL | 4.211713494 | 3.381096774 | C, 1B | 18 | 1 | CHC | 1901 | 1911 | ATL | |
95958 | 95958 | Fielder Jones | 35 | jonesfi01 | 1907 | CHW | AL | 7.418734372 | 4.111910828 | OF | 23 | 1 | CHW | 1901 | 1908 | ||
95962 | 95962 | Frank Isbell | 31 | isbelfr01 | 1907 | CHW | AL | 5.979611464 | 2.063694268 | 2B, OF, SS, P | 15 | 1 | CHW | 1901 | 1909 | ||
95965 | 95965 | Billy Sullivan | 32 | sullibi03 | 1907 | CHW | AL | 4.049624928 | 0.237324841 | C, 2B | 7 | 1 | CHW | 1901 | 1914 | DET | |
95967 | 95967 | Roy Patterson | 30 | pattero01 | 1907 | CHW | AL | 2.867709815 | 0.149617834 | P | 5 | 1 | CHW | 1901 | 1907 | ||
96014 | 96014 | Bill Bradley | 29 | bradlbi01 | 1907 | CLE | AL | 6.653140851 | 1.563607595 | 3B | 15 | 1 | CLE | 1901 | 1910 | ||
96031 | 96031 | Earl Moore | 29 | mooreea01 | 1907 | CLE | AL | 0.583054093 | -0.276835443 | P | 0 | 1 | CLE | 1901 | 1907 | NYY | |
96057 | 96057 | Christy Mathewson | 26 | mathech01 | 1907 | NYG | NL | 9.649890591 | 7.859612903 | P | 36 | 1 | SFG | 1901 | 1916 | CIN | |
96070 | 96070 | Frank Bowerman | 38 | bowerfr01 | 1907 | NYG | NL | 3.929324483 | 0.987677419 | C, 1B | 8 | 1 | SFG | 1901 | 1907 | ATL | |
96090 | 96090 | Jimmy Williams | 30 | williji01 | 1907 | NYY | AL | 6.378842315 | 1.183026316 | 2B | 14 | 1 | NYY | 1901 | 1907 | BAL | |
96118 | 96118 | Eddie Plank | 31 | planked01 | 1907 | PHA | AL | 10.66289091 | 6.3504 | P | 34 | 1 | OAK | 1901 | 1914 | BAL | |
96122 | 96122 | Harry Davis | 33 | davisha01 | 1907 | PHA | AL | 7.339151131 | 4.131 | 1B | 23 | 1 | OAK | 1901 | 1911 | CLE |
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 );