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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
96124 | 96124 | Socks Seybold | 36 | seyboso01 | 1907 | PHA | AL | 7.293137644 | 3.1806 | OF | 20 | 1 | OAK | 1901 | 1908 | ||
96147 | 96147 | Roy Thomas | 33 | thomaro01 | 1907 | PHI | NL | 6.281022656 | 3.10409396 | OF | 20 | 1 | PHI | 1901 | 1908 | PIT | |
96166 | 96166 | Honus Wagner | 33 | wagneho01 | 1907 | PIT | NL | 6.542201478 | 9.364012739 | SS, 1B | 38 | 1 | PIT | 1901 | 1917 | ||
96167 | 96167 | Tommy Leach | 29 | leachto01 | 1907 | PIT | NL | 6.959548814 | 5.654522293 | OF, 3B, SS, 2B | 28 | 1 | PIT | 1901 | 1912 | CHC | |
96168 | 96168 | Fred Clarke | 34 | clarkfr01 | 1907 | PIT | NL | 6.688837028 | 5.453312102 | OF | 27 | 1 | PIT | 1901 | 1915 | ||
96171 | 96171 | Sam Leever | 35 | leevesa01 | 1907 | PIT | NL | 6.67644901 | 2.729235669 | P | 19 | 1 | PIT | 1901 | 1910 | ||
96172 | 96172 | Deacon Phillippe | 35 | phillde01 | 1907 | PIT | NL | 6.594277329 | 2.445477707 | P | 18 | 1 | PIT | 1901 | 1911 | ||
96265 | 96265 | Casey Patten | 33 | patteca01 | 1907 | WSH | AL | 7.403812825 | -0.352402597 | P | 5 | 1 | MIN | 1901 | 1908 | BOS | |
96289 | 96289 | Cy Young | 39 | youngcy01 | 1906 | BOS | AL | 8.742402315 | 3.898451613 | P | 21 | 1 | BOS | 1901 | 1908 | CLE | |
96290 | 96290 | Chick Stahl | 33 | stahlch01 | 1906 | BOS | AL | 7.564724286 | 4.081354839 | OF | 20 | 1 | BOS | 1901 | 1906 | ||
96294 | 96294 | Freddy Parent | 30 | parenfr01 | 1906 | BOS | AL | 7.405944466 | 1.254193548 | SS, 2B | 11 | 1 | BOS | 1901 | 1907 | CHW | |
96295 | 96295 | Hobe Ferris | 31 | ferriho01 | 1906 | BOS | AL | 5.874853344 | 1.008580645 | 2B, 3B | 9 | 1 | BOS | 1901 | 1907 | BAL | |
96296 | 96296 | George Winter | 28 | wintege01 | 1906 | BOS | AL | 6.311143271 | 0.752516129 | P | 9 | 1 | BOS | 1901 | 1908 | DET | |
96298 | 96298 | Buck Freeman | 34 | freembu01 | 1906 | BOS | AL | 4.944857255 | 0.951096774 | OF, 1B, 3B | 8 | 1 | BOS | 1901 | 1907 | ||
96301 | 96301 | Jimmy Collins | 36 | colliji01 | 1906 | BOS | AL | 1.678529527 | 0.893612903 | 3B | 4 | 1 | BOS | 1901 | 1907 | OAK | |
96309 | 96309 | Lou Criger | 34 | crigelo01 | 1906 | BOS | AL | 0.215486899 | 0.109741935 | C | 1 | 1 | BOS | 1901 | 1908 | BAL | |
96347 | 96347 | Fred Tenney | 34 | tennefr02 | 1906 | BSN | NL | 7.392156863 | 3.447828947 | 1B | 19 | 1 | ATL | 1901 | 1907 | SFG | |
96369 | 96369 | Frank Chance | 29 | chancfr01 | 1906 | CHC | NL | 6.398616183 | 7.90012987 | 1B | 35 | 1 | CHC | 1901 | 1912 | NYY | |
96376 | 96376 | Johnny Kling | 30 | klingjo01 | 1906 | CHC | NL | 4.180280607 | 4.386623377 | C, OF | 21 | 1 | CHC | 1901 | 1911 | ATL | |
96394 | 96394 | Fielder Jones | 34 | jonesfi01 | 1906 | CHW | AL | 6.947327351 | 4.265649351 | OF | 25 | 1 | CHW | 1901 | 1908 | ||
96396 | 96396 | Frank Isbell | 30 | isbelfr01 | 1906 | CHW | AL | 6.981271947 | 3.797532468 | 2B, OF, C, P | 23 | 1 | CHW | 1901 | 1909 | ||
96399 | 96399 | Billy Sullivan | 31 | sullibi03 | 1906 | CHW | AL | 4.888021849 | 1.835649351 | C | 14 | 1 | CHW | 1901 | 1914 | DET | |
96402 | 96402 | Roy Patterson | 29 | pattero01 | 1906 | CHW | AL | 4.342718447 | 1.299155844 | P | 11 | 1 | CHW | 1901 | 1907 | ||
96428 | 96428 | Tommy Corcoran | 37 | corcoto01 | 1906 | CIN | NL | 5.233424872 | -0.804774194 | SS | 4 | 1 | CIN | 1901 | 1906 | SFG | |
96459 | 96459 | Bill Bradley | 28 | bradlbi01 | 1906 | CLE | AL | 3.658627087 | 3.012993631 | 3B | 13 | 1 | CLE | 1901 | 1910 | ||
96475 | 96475 | Earl Moore | 28 | mooreea01 | 1906 | CLE | AL | 0.882019821 | -0.490127389 | P | 0 | 1 | CLE | 1901 | 1907 | NYY | |
96503 | 96503 | Christy Mathewson | 25 | mathech01 | 1906 | NYG | NL | 8.393704721 | 4.028684211 | P | 26 | 1 | SFG | 1901 | 1916 | CIN | |
96513 | 96513 | Frank Bowerman | 37 | bowerfr01 | 1906 | NYG | NL | 3.563218391 | 0.905921053 | C, 1B | 9 | 1 | SFG | 1901 | 1907 | ATL | |
96527 | 96527 | Jimmy Williams | 29 | williji01 | 1906 | NYY | AL | 6.441937366 | 3.485612903 | 2B | 20 | 1 | NYY | 1901 | 1907 | BAL | |
96552 | 96552 | Harry Davis | 32 | davisha01 | 1906 | PHA | AL | 7.191437803 | 5.457986577 | 1B | 26 | 1 | OAK | 1901 | 1911 | CLE | |
96554 | 96554 | Eddie Plank | 30 | planked01 | 1906 | PHA | AL | 6.724659607 | 4.278322148 | P | 22 | 1 | OAK | 1901 | 1914 | BAL | |
96557 | 96557 | Socks Seybold | 35 | seyboso01 | 1906 | PHA | AL | 5.376009693 | 3.250872483 | OF | 17 | 1 | OAK | 1901 | 1908 | ||
96585 | 96585 | Roy Thomas | 32 | thomaro01 | 1906 | PHI | NL | 7.314890155 | 3.944805195 | OF | 22 | 1 | PHI | 1901 | 1908 | PIT | |
96606 | 96606 | Honus Wagner | 32 | wagneho01 | 1906 | PIT | NL | 6.635640876 | 9.961948052 | SS, OF, 3B | 40 | 1 | PIT | 1901 | 1917 | ||
96608 | 96608 | Sam Leever | 34 | leevesa01 | 1906 | PIT | NL | 8.051546392 | 4.207792208 | P | 25 | 1 | PIT | 1901 | 1910 | ||
96609 | 96609 | Claude Ritchey | 32 | ritchcl01 | 1906 | PIT | NL | 6.590653481 | 4.597012987 | 2B | 24 | 1 | PIT | 1901 | 1906 | ATL | |
96610 | 96610 | Deacon Phillippe | 34 | phillde01 | 1906 | PIT | NL | 6.762886598 | 3.792272727 | P | 22 | 1 | PIT | 1901 | 1911 | ||
96612 | 96612 | Fred Clarke | 33 | clarkfr01 | 1906 | PIT | NL | 5.375993795 | 3.965844156 | OF | 20 | 1 | PIT | 1901 | 1915 | ||
96614 | 96614 | Tommy Leach | 28 | leachto01 | 1906 | PIT | NL | 5.915842544 | 2.808701299 | 3B, OF, SS | 17 | 1 | PIT | 1901 | 1912 | CHC | |
96618 | 96618 | Ginger Beaumont | 29 | beaumgi01 | 1906 | PIT | NL | 3.925150281 | 0.257727273 | OF | 7 | 1 | PIT | 1901 | 1906 | ATL | |
96698 | 96698 | Casey Patten | 32 | patteca01 | 1906 | WSH | AL | 8.996211164 | 3.363377483 | P | 21 | 1 | MIN | 1901 | 1908 | BOS | |
96726 | 96726 | Cy Young | 38 | youngcy01 | 1905 | BOS | AL | 9.92971246 | 8.025882353 | P | 37 | 1 | BOS | 1901 | 1908 | CLE | |
96728 | 96728 | Jimmy Collins | 35 | colliji01 | 1905 | BOS | AL | 6.238242097 | 4.563529412 | 3B | 22 | 1 | BOS | 1901 | 1907 | OAK | |
96729 | 96729 | George Winter | 27 | wintege01 | 1905 | BOS | AL | 8.185303514 | 3.197647059 | P | 21 | 1 | BOS | 1901 | 1908 | DET | |
96731 | 96731 | Freddy Parent | 29 | parenfr01 | 1905 | BOS | AL | 7.713955281 | 2.165294118 | SS | 17 | 1 | BOS | 1901 | 1907 | CHW | |
96733 | 96733 | Hobe Ferris | 30 | ferriho01 | 1905 | BOS | AL | 6.238242097 | 2.408823529 | 2B | 16 | 1 | BOS | 1901 | 1907 | BAL | |
96735 | 96735 | Chick Stahl | 32 | stahlch01 | 1905 | BOS | AL | 6.350038551 | 1.450588235 | OF | 13 | 1 | BOS | 1901 | 1906 | ||
96736 | 96736 | Lou Criger | 33 | crigelo01 | 1905 | BOS | AL | 4.214726291 | 2.085882353 | C | 12 | 1 | BOS | 1901 | 1908 | BAL | |
96737 | 96737 | Buck Freeman | 33 | freembu01 | 1905 | BOS | AL | 5.757517348 | 1.228235294 | 1B, OF, 3B | 11 | 1 | BOS | 1901 | 1907 | ||
96777 | 96777 | Vic Willis | 29 | willivi01 | 1905 | BSN | NL | 10.44654545 | 2.949230769 | P | 22 | 1 | ATL | 1901 | 1905 | PIT | |
96778 | 96778 | Fred Tenney | 33 | tennefr02 | 1905 | BSN | NL | 7.238546603 | 3.972115385 | 1B, P | 21 | 1 | ATL | 1901 | 1907 | SFG | |
96786 | 96786 | Pat Moran | 29 | moranpa01 | 1905 | BSN | NL | 3.19549763 | 0.384230769 | C | 5 | 1 | ATL | 1901 | 1905 | CHC | |
96800 | 96800 | Frank Chance | 28 | chancfr01 | 1905 | CHC | NL | 5.552250191 | 6.192580645 | 1B | 27 | 1 | CHC | 1901 | 1912 | NYY | |
96814 | 96814 | Johnny Kling | 29 | klingjo01 | 1905 | CHC | NL | 4.700610221 | 0.318774194 | C, OF, 1B | 8 | 1 | CHC | 1901 | 1911 | ATL | |
96821 | 96821 | Fielder Jones | 33 | jonesfi01 | 1905 | CHW | AL | 7.265112753 | 4.818987342 | OF | 24 | 1 | CHW | 1901 | 1908 | ||
96826 | 96826 | Frank Isbell | 29 | isbelfr01 | 1905 | CHW | AL | 4.275535342 | 3.926962025 | 2B, OF, 1B, SS | 18 | 1 | CHW | 1901 | 1909 | ||
96829 | 96829 | Jimmy Callahan | 31 | callani01 | 1905 | CHW | AL | 4.264544249 | 2.153164557 | OF | 12 | 1 | CHW | 1901 | 1913 | ||
96833 | 96833 | Billy Sullivan | 30 | sullibi03 | 1905 | CHW | AL | 3.835891605 | 0.702341772 | C, 1B, 3B | 7 | 1 | CHW | 1901 | 1914 | DET | |
96834 | 96834 | Roy Patterson | 28 | pattero01 | 1905 | CHW | AL | 2.609670638 | 0.866392405 | P | 6 | 1 | CHW | 1901 | 1907 | ||
96843 | 96843 | Tommy Corcoran | 36 | corcoto01 | 1905 | CIN | NL | 7.061723749 | 2.262774194 | SS | 17 | 1 | CIN | 1901 | 1906 | SFG | |
96845 | 96845 | Harry Steinfeldt | 29 | steinha01 | 1905 | CIN | NL | 4.682348513 | 1.557290323 | 3B, 1B, 2B, OF | 11 | 1 | CIN | 1901 | 1905 | CHC | |
96851 | 96851 | Noodles Hahn | 26 | hahnno01 | 1905 | CIN | NL | 2.368074201 | 0.590516129 | P | 5 | 1 | CIN | 1901 | 1905 | NYY | |
96866 | 96866 | Bill Bradley | 27 | bradlbi01 | 1905 | CLE | AL | 6.755109911 | 5.048129032 | 3B | 24 | 1 | CLE | 1901 | 1910 | ||
96870 | 96870 | Earl Moore | 27 | mooreea01 | 1905 | CLE | AL | 9.827196289 | 1.520709677 | P | 17 | 1 | CLE | 1901 | 1907 | NYY | |
96913 | 96913 | Jimmy Barrett | 30 | barreji01 | 1905 | DET | AL | 0.875956504 | -0.078896104 | OF | 1 | 1 | DET | 1901 | 1905 | CIN | |
96921 | 96921 | Christy Mathewson | 24 | mathech01 | 1905 | NYG | NL | 10.38248175 | 9.542322581 | P | 43 | 1 | SFG | 1901 | 1916 | CIN | |
96935 | 96935 | Frank Bowerman | 36 | bowerfr01 | 1905 | NYG | NL | 3.59408755 | 1.442322581 | C, 1B, 2B | 10 | 1 | SFG | 1901 | 1907 | ATL | |
96949 | 96949 | Jimmy Williams | 28 | williji01 | 1905 | NYY | AL | 6.171690956 | 1.550723684 | 2B | 13 | 1 | NYY | 1901 | 1907 | BAL | |
96978 | 96978 | Eddie Plank | 29 | planked01 | 1905 | PHA | AL | 10.5253012 | 7.210065789 | P | 36 | 1 | OAK | 1901 | 1914 | BAL | |
96979 | 96979 | Harry Davis | 31 | davisha01 | 1905 | PHA | AL | 7.363478261 | 6.138947368 | 1B | 29 | 1 | OAK | 1901 | 1911 | CLE | |
96982 | 96982 | Socks Seybold | 34 | seyboso01 | 1905 | PHA | AL | 6.265120773 | 4.401710526 | OF | 22 | 1 | OAK | 1901 | 1908 | ||
96984 | 96984 | Lave Cross | 39 | crossla01 | 1905 | PHA | AL | 7.060869565 | 2.488618421 | 3B | 18 | 1 | OAK | 1901 | 1905 | MIN | |
96995 | 96995 | Doc Powers | 34 | powerdo01 | 1905 | PHA | AL | 1.46821256 | -1.049802632 | C, 1B | 0 | 1 | OAK | 1901 | 1905 | NYY | |
96996 | 96996 | Roy Thomas | 31 | thomaro01 | 1905 | PHI | NL | 7.352112676 | 5.879032258 | OF | 29 | 1 | PHI | 1901 | 1908 | PIT | |
97020 | 97020 | Honus Wagner | 31 | wagneho01 | 1905 | PIT | NL | 6.783368141 | 10.94806452 | SS, OF | 44 | 1 | PIT | 1901 | 1917 | ||
97021 | 97021 | Deacon Phillippe | 33 | phillde01 | 1905 | PIT | NL | 8.904255319 | 4.891354839 | P | 30 | 1 | PIT | 1901 | 1911 | ||
97022 | 97022 | Fred Clarke | 32 | clarkfr01 | 1905 | PIT | NL | 6.651224606 | 4.055225806 | OF | 24 | 1 | PIT | 1901 | 1915 | ||
97023 | 97023 | Claude Ritchey | 31 | ritchcl01 | 1905 | PIT | NL | 6.563128916 | 3.078 | 2B, SS | 21 | 1 | PIT | 1901 | 1906 | ATL | |
97024 | 97024 | Sam Leever | 33 | leevesa01 | 1905 | PIT | NL | 7.329787234 | 2.022387097 | P | 19 | 1 | PIT | 1901 | 1910 | ||
97026 | 97026 | Ginger Beaumont | 28 | beaumgi01 | 1905 | PIT | NL | 4.625023733 | 3.083225806 | OF | 17 | 1 | PIT | 1901 | 1906 | ATL | |
97027 | 97027 | Tommy Leach | 27 | leachto01 | 1905 | PIT | NL | 6.100626543 | 1.938774194 | OF, 3B, 2B, SS | 16 | 1 | PIT | 1901 | 1912 | CHC | |
97105 | 97105 | Casey Patten | 31 | patteca01 | 1905 | WSH | AL | 9.546855885 | 1.441168831 | P | 17 | 1 | MIN | 1901 | 1908 | BOS | |
97130 | 97130 | Cy Young | 37 | youngcy01 | 1904 | BOS | AL | 11.35135135 | 9.147324841 | P | 45 | 1 | BOS | 1901 | 1908 | CLE | |
97131 | 97131 | Freddy Parent | 28 | parenfr01 | 1904 | BOS | AL | 7.265298293 | 6.320063694 | SS | 30 | 1 | BOS | 1901 | 1907 | CHW | |
97133 | 97133 | Jimmy Collins | 34 | colliji01 | 1904 | BOS | AL | 7.521197007 | 5.314012739 | 3B | 27 | 1 | BOS | 1901 | 1907 | OAK | |
97135 | 97135 | Chick Stahl | 31 | stahlch01 | 1904 | BOS | AL | 7.576827163 | 4.648471338 | OF | 26 | 1 | BOS | 1901 | 1906 | ||
97136 | 97136 | Buck Freeman | 32 | freembu01 | 1904 | BOS | AL | 7.254172262 | 3.178089172 | OF | 21 | 1 | BOS | 1901 | 1907 | ||
97139 | 97139 | Hobe Ferris | 29 | ferriho01 | 1904 | BOS | AL | 6.697870708 | 0.815159236 | 2B | 13 | 1 | BOS | 1901 | 1907 | BAL | |
97140 | 97140 | Lou Criger | 32 | crigelo01 | 1904 | BOS | AL | 3.749472473 | 1.558089172 | C | 10 | 1 | BOS | 1901 | 1908 | BAL | |
97142 | 97142 | George Winter | 26 | wintege01 | 1904 | BOS | AL | 4.052631579 | 1.011210191 | P | 9 | 1 | BOS | 1901 | 1908 | DET | |
97176 | 97176 | Vic Willis | 28 | willivi01 | 1904 | BSN | NL | 11.14762386 | 3.417677419 | P, 1B | 26 | 1 | ATL | 1901 | 1905 | PIT | |
97177 | 97177 | Togie Pittinger | 32 | pittito01 | 1904 | BSN | NL | 10.68048534 | 2.560645161 | P | 23 | 1 | ATL | 1901 | 1904 | PHI | |
97178 | 97178 | Fred Tenney | 32 | tennefr02 | 1904 | BSN | NL | 7.145010911 | 3.219096774 | 1B, OF | 20 | 1 | ATL | 1901 | 1907 | SFG | |
97182 | 97182 | Duff Cooley | 31 | cooledu01 | 1904 | BSN | NL | 5.683792898 | 1.38483871 | OF, 1B | 12 | 1 | ATL | 1901 | 1904 | DET | |
97185 | 97185 | Pat Moran | 28 | moranpa01 | 1904 | BSN | NL | 4.86689149 | 0.757741935 | C, 3B, 1B | 9 | 1 | ATL | 1901 | 1905 | CHC | |
97199 | 97199 | Pat Carney | 27 | carnepa01 | 1904 | BSN | NL | 3.451696092 | -2.262774194 | OF, P, 1B | 0 | 1 | ATL | 1901 | 1904 | ||
97201 | 97201 | Frank Chance | 27 | chancfr01 | 1904 | CHC | NL | 5.89519478 | 6.329423077 | 1B, C | 29 | 1 | CHC | 1901 | 1912 | NYY | |
97210 | 97210 | Johnny Kling | 28 | klingjo01 | 1904 | CHC | NL | 5.539648013 | 0.81 | C, OF, 1B | 12 | 1 | CHC | 1901 | 1911 | ATL | |
97232 | 97232 | Fielder Jones | 32 | jonesfi01 | 1904 | CHW | AL | 7.294094565 | 3.582692308 | OF | 21 | 1 | CHW | 1901 | 1908 | ||
97235 | 97235 | Jimmy Callahan | 30 | callani01 | 1904 | CHW | AL | 6.315479694 | 2.050961538 | OF, 2B | 15 | 1 | CHW | 1901 | 1913 |
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 );