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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98796 | 98796 | Jack O'Brien | 28 | o'brija02 | 1901 | WSH | AL | 0.628826531 | -0.375652174 | OF, 3B | 0 | 1 | MIN | 1901 | 1901 | CLE | |
98795 | 98795 | Charlie Luskey | 25 | luskech01 | 1901 | WSH | AL | 0.542517007 | -0.305217391 | OF, C | 0 | 1 | MIN | 1901 | 1901 | ||
98794 | 98794 | Tim Jordan | 22 | jordati01 | 1901 | WSH | AL | 0.283588435 | -0.176086957 | 1B | 0 | 1 | MIN | 1901 | 1901 | NYY | |
98793 | 98793 | Leo Harrison | harribe01 | 1901 | WSH | AL | 0.036989796 | -0.01173913 | 0 | 1 | MIN | 1901 | 1901 | ||||
98792 | 98792 | Bill Everitt | 32 | everibi01 | 1901 | WSH | AL | 1.68920068 | -0.55173913 | 1B | 1 | 1 | MIN | 1901 | 1901 | ||
98791 | 98791 | Joe Quinn | 38 | quinnjo02 | 1901 | WSH | AL | 3.50170068 | -0.105652174 | 2B | 5 | 1 | MIN | 1901 | 1901 | ||
98790 | 98790 | Dale Gear | 29 | gearda01 | 1901 | WSH | AL | 2.527636054 | 0.827608696 | OF, P | 6 | 1 | MIN | 1901 | 1901 | ||
98789 | 98789 | Irv Waldron | 29 | waldrir01 | 1901 | WSH | AL | 4.463435374 | 1.179782609 | OF | 10 | 2 | MIN | BAL | 1901 | 1901 | |
98788 | 98788 | Billy Clingman | 31 | clingbi01 | 1901 | WSH | AL | 6.621173469 | 1.056521739 | SS | 12 | 1 | MIN | 1901 | 1901 | CLE | |
98787 | 98787 | Pop Foster | 23 | fostepo01 | 1901 | WSH | AL | 5.400510204 | 1.825434783 | OF, SS | 13 | 1 | MIN | 1901 | 1901 | CHW | |
98786 | 98786 | Bill Coughlin | 22 | coughbi01 | 1901 | WSH | AL | 6.756802721 | 1.854782609 | 3B | 15 | 1 | MIN | 1901 | 1904 | DET | |
98785 | 98785 | Boileryard Clarke | 32 | clarkbo02 | 1901 | WSH | AL | 5.733418367 | 2.324347826 | C, 1B | 15 | 1 | MIN | 1901 | 1904 | SFG | |
98784 | 98784 | Mike Grady | 31 | gradymi01 | 1901 | WSH | AL | 4.722363946 | 3.022826087 | 1B, C, OF | 15 | 1 | MIN | 1901 | 1901 | STL | |
98783 | 98783 | Win Mercer | 27 | mercewi01 | 1901 | WSH | AL | 7.398039216 | 1.848913043 | P, OF, 1B, 3B, SS | 16 | 1 | MIN | 1901 | 1901 | DET | |
98782 | 98782 | John Farrell | 24 | farrejo02 | 1901 | WSH | AL | 7.570578231 | 2.289130435 | 2B, OF, 3B | 17 | 1 | MIN | 1901 | 1901 | STL | |
98781 | 98781 | Sam Dungan | 34 | dungasa01 | 1901 | WSH | AL | 7.521258503 | 2.44173913 | OF, 1B | 18 | 1 | MIN | 1901 | 1901 | ||
98780 | 98780 | Watty Lee | 21 | leewa01 | 1901 | WSH | AL | 10.78823529 | 2.242173913 | P, OF | 22 | 1 | MIN | 1901 | 1903 | PIT | |
98779 | 98779 | Casey Patten | 27 | patteca01 | 1901 | WSH | AL | 10.47254902 | 2.55326087 | P | 22 | 1 | MIN | 1901 | 1908 | BOS | |
98778 | 98778 | Bill Carrick | 27 | carribi01 | 1901 | WSH | AL | 13.34117647 | 3.128478261 | P | 28 | 1 | MIN | 1901 | 1902 | ||
98777 | 98777 | Theodore Breitenstein | 32 | breitte01 | 1901 | STL | NL | 0.496193227 | -0.707323944 | P | 0 | 1 | STL | 1901 | 1901 | ||
98776 | 98776 | Chauncey Fisher | 29 | fishech04 | 1901 | STL | NL | 0.099238645 | -0.154014085 | P | 0 | 2 | STL | SFG | 1901 | 1901 | |
98775 | 98775 | Mike Heydon | 26 | heydomi01 | 1901 | STL | NL | 0.564897635 | -0.096971831 | C, OF | 0 | 1 | STL | 1901 | 1901 | CHW | |
98774 | 98774 | Bob Wicker | 24 | wickebo01 | 1901 | STL | NL | 0.099238645 | -0.057042254 | P, OF | 0 | 1 | STL | 1901 | 1903 | CHC | |
98773 | 98773 | Farmer Burns | 25 | burnsfa01 | 1901 | STL | NL | 0.033079548 | 0.0 | P | 0 | 1 | STL | 1901 | 1901 | ||
98772 | 98772 | Bill Richardson | 23 | richabi01 | 1901 | STL | NL | 0.691711389 | 0.017112676 | 1B | 1 | 1 | STL | 1901 | 1901 | ||
98771 | 98771 | Bill Magee | 25 | mageebi01 | 1901 | STL | NL | 0.264636388 | 0.142605634 | P | 1 | 1 | STL | 1901 | 1901 | SFG | |
98770 | 98770 | Cowboy Jones | 26 | jonesco01 | 1901 | STL | NL | 2.525072197 | -0.347957746 | P | 2 | 1 | STL | 1901 | 1901 | ||
98769 | 98769 | Stan Yerkes | 26 | yerkest01 | 1901 | STL | NL | 1.124704647 | 0.313732394 | P | 2 | 2 | STL | NYY | 1901 | 1903 | |
98768 | 98768 | Jack Ryan | 32 | ryanja01 | 1901 | STL | NL | 3.700655933 | -0.701619718 | C, 2B, 1B, OF | 3 | 1 | STL | 1901 | 1903 | MIN | |
98767 | 98767 | Pete Childs | 29 | childpe01 | 1901 | STL | NL | 1.0952097 | 0.359366197 | 2B, OF, SS | 3 | 1 | STL | 1901 | 1901 | CHC | |
98766 | 98766 | Mike O'Neill | 23 | o'neimi01 | 1901 | STL | NL | 1.356261486 | 1.038169014 | P | 5 | 1 | STL | 1901 | 1904 | CIN | |
98765 | 98765 | Art Nichols | 29 | nichoar01 | 1901 | STL | NL | 3.896640827 | 0.216760563 | C, OF | 6 | 1 | STL | 1901 | 1903 | ||
98764 | 98764 | Pop Schriver | 35 | schripo01 | 1901 | STL | NL | 2.178890877 | 1.323380282 | C, 1B | 7 | 1 | STL | 1901 | 1901 | ||
98763 | 98763 | Ed Murphy | 24 | murphed01 | 1901 | STL | NL | 5.458125492 | 0.467746479 | P | 9 | 1 | STL | 1901 | 1903 | ||
98762 | 98762 | Dan McGann | 29 | mcganda01 | 1901 | STL | NL | 5.40687736 | 1.905211268 | 1B | 13 | 1 | STL | 1901 | 1901 | NYY | |
98761 | 98761 | Dick Padden | 30 | paddedi01 | 1901 | STL | NL | 6.236931028 | 1.990774648 | 2B, SS | 15 | 1 | STL | 1901 | 1901 | BAL | |
98760 | 98760 | Willie Sudhoff | 26 | sudhowi01 | 1901 | STL | NL | 9.140981885 | 1.426056338 | P | 17 | 1 | STL | 1901 | 1901 | BAL | |
98759 | 98759 | Patsy Donovan | 36 | donovpa01 | 1901 | STL | NL | 6.663486384 | 3.091690141 | OF | 18 | 1 | STL | 1901 | 1903 | MIN | |
98758 | 98758 | Otto Krueger | 24 | kruegot01 | 1901 | STL | NL | 6.870999801 | 3.262816901 | 3B | 19 | 1 | STL | 1901 | 1902 | PIT | |
98757 | 98757 | Jack Harper | 23 | harpeja01 | 1901 | STL | NL | 10.21055395 | 1.985070423 | P | 20 | 1 | STL | 1901 | 1901 | BAL | |
98756 | 98756 | Jack Powell | 26 | powelja01 | 1901 | STL | NL | 11.19191389 | 2.874929577 | P | 24 | 1 | STL | 1901 | 1901 | BAL | |
98755 | 98755 | Emmet Heidrick | 24 | heidrem01 | 1901 | STL | NL | 6.213873981 | 5.059647887 | OF | 24 | 1 | STL | 1901 | 1901 | BAL | |
98754 | 98754 | Bobby Wallace | 27 | wallabo01 | 1901 | STL | NL | 6.721129 | 8.476478873 | SS | 34 | 1 | STL | 1901 | 1901 | BAL | |
98753 | 98753 | Jesse Burkett | 32 | burkeje01 | 1901 | STL | NL | 7.758696084 | 8.236901408 | OF | 35 | 1 | STL | 1901 | 1901 | BAL | |
98752 | 98752 | Rube Waddell | 24 | wadderu01 | 1901 | PIT | NL | 0.276473955 | -0.399214286 | P, 1B | 0 | 1 | PIT | 1901 | 1901 | CHC | |
98751 | 98751 | Ed Poole | 26 | pooleed01 | 1901 | PIT | NL | 0.965489241 | -0.381857143 | P, OF, 2B, 3B | 0 | 1 | PIT | 1901 | 1902 | CIN | |
98750 | 98750 | Truck Eagan | 23 | eagantr01 | 1901 | PIT | NL | 0.141291108 | -0.046285714 | 2B, SS, 3B | 0 | 1 | PIT | 1901 | 1901 | CLE | |
98749 | 98749 | Mike Smith | 33 | smithel01 | 1901 | PIT | NL | 0.070645554 | -0.011571429 | OF | 0 | 1 | PIT | 1901 | 1901 | ATL | |
98748 | 98748 | Jiggs Donahue | 21 | donahji02 | 1901 | PIT | NL | 0.0 | 0.0 | C, 1B, OF | 0 | 1 | PIT | 1901 | 1901 | BAL | |
98747 | 98747 | Jud Smith | 32 | smithju01 | 1901 | PIT | NL | 0.282582217 | 0.011571429 | 3B | 0 | 1 | PIT | 1901 | 1901 | ||
98746 | 98746 | Terry Turner | 20 | turnete01 | 1901 | PIT | NL | 0.082419813 | 0.092571429 | 3B | 0 | 1 | PIT | 1901 | 1901 | CLE | |
98745 | 98745 | Jimmy Burke | 26 | burkeji01 | 1901 | PIT | NL | 0.682907024 | -0.098357143 | 3B, SS | 1 | 3 | PIT | CHW | 1901 | 1902 | STL |
98744 | 98744 | George Merritt | 21 | merrige01 | 1901 | PIT | NL | 0.865483686 | 0.034714286 | P | 1 | 1 | PIT | 1901 | 1903 | ||
98743 | 98743 | Lew Carr | 28 | carrle01 | 1901 | PIT | NL | 0.376776289 | 0.208285714 | SS, 3B | 1 | 1 | PIT | 1901 | 1901 | ||
98742 | 98742 | Snake Wiltse | 29 | wiltssn01 | 1901 | PIT | NL | 1.598740698 | -0.324 | P | 2 | 1 | PIT | 1901 | 1901 | OAK | |
98741 | 98741 | George Yeager | 28 | yeagege01 | 1901 | PIT | NL | 1.177425903 | 0.138857143 | C, 1B, 3B, OF, 2B | 2 | 2 | PIT | CLE | 1901 | 1901 | SFG |
98740 | 98740 | Jack O'Connor | 35 | o'conja01 | 1901 | PIT | NL | 2.590336987 | -0.410785714 | C | 3 | 1 | PIT | 1901 | 1902 | NYY | |
98739 | 98739 | Chief Zimmer | 40 | zimmech01 | 1901 | PIT | NL | 3.143727162 | 0.393428571 | C | 6 | 1 | PIT | 1901 | 1902 | PHI | |
98738 | 98738 | Bones Ely | 38 | elybo01 | 1901 | PIT | NL | 2.978887536 | 0.405 | SS, 3B | 6 | 1 | PIT | 1901 | 1901 | OAK | |
98737 | 98737 | Ed Doheny | 27 | dohened01 | 1901 | PIT | NL | 2.764739554 | 0.804214286 | P | 7 | 2 | PIT | SFG | 1901 | 1903 | |
98736 | 98736 | Sam Leever | 29 | leevesa01 | 1901 | PIT | NL | 6.346880366 | 2.163857143 | P | 16 | 1 | PIT | 1901 | 1910 | ||
98735 | 98735 | Kitty Bransfield | 26 | branski01 | 1901 | PIT | NL | 7.170523752 | 2.482071429 | 1B | 18 | 1 | PIT | 1901 | 1904 | PHI | |
98734 | 98734 | Tommy Leach | 23 | leachto01 | 1901 | PIT | NL | 4.803897686 | 3.529285714 | 3B, SS | 18 | 1 | PIT | 1901 | 1912 | CHC | |
98733 | 98733 | Lefty Davis | 26 | davisle01 | 1901 | PIT | NL | 4.721477873 | 3.807 | OF, 2B | 19 | 2 | PIT | LAD | 1901 | 1902 | NYY |
98732 | 98732 | Claude Ritchey | 27 | ritchcl01 | 1901 | PIT | NL | 7.19407227 | 3.812785714 | 2B, SS | 22 | 1 | PIT | 1901 | 1906 | ATL | |
98731 | 98731 | Ginger Beaumont | 24 | beaumgi01 | 1901 | PIT | NL | 7.252943565 | 4.570714286 | OF | 25 | 1 | PIT | 1901 | 1906 | ATL | |
98730 | 98730 | Fred Clarke | 28 | clarkfr01 | 1901 | PIT | NL | 7.076329679 | 6.051857143 | OF, 3B, SS | 29 | 1 | PIT | 1901 | 1915 | ||
98729 | 98729 | Jesse Tannehill | 26 | tanneje01 | 1901 | PIT | NL | 9.099599313 | 5.369142857 | P, OF | 30 | 1 | PIT | 1901 | 1902 | NYY | |
98728 | 98728 | Deacon Phillippe | 29 | phillde01 | 1901 | PIT | NL | 10.6742988 | 5.531142857 | P | 33 | 1 | PIT | 1901 | 1911 | ||
98727 | 98727 | Jack Chesbro | 27 | chesbja01 | 1901 | PIT | NL | 10.37378363 | 5.739428571 | P | 33 | 1 | PIT | 1901 | 1902 | NYY | |
98726 | 98726 | Honus Wagner | 27 | wagneho01 | 1901 | PIT | NL | 7.288266342 | 8.458714286 | SS, OF, 3B, 2B | 36 | 1 | PIT | 1901 | 1917 | ||
98725 | 98725 | Joe Dolan | 28 | dolanjo02 | 1901 | PHI | NL | 0.465240642 | -0.480214286 | SS, 3B, 2B, OF | 0 | 1 | PHI | 1901 | 1901 | OAK | |
98724 | 98724 | Jack Dunn | 28 | dunnja01 | 1901 | PHI | NL | 0.157219251 | -0.428142857 | 3B, SS, P, 2B, OF | 0 | 1 | PHI | 1901 | 1901 | NYY | |
98723 | 98723 | George Browne | 25 | brownge01 | 1901 | PHI | NL | 0.334018922 | -0.127285714 | OF | 0 | 1 | PHI | 1901 | 1902 | SFG | |
98722 | 98722 | Bert Conn | 21 | connbe01 | 1901 | PHI | NL | 0.226655697 | -0.023142857 | 2B | 0 | 1 | PHI | 1901 | 1901 | ||
98721 | 98721 | Jimmy Slagle | 27 | slaglji01 | 1901 | PHI | NL | 2.49321267 | -0.173571429 | OF | 3 | 1 | PHI | 1901 | 1901 | ATL | |
98720 | 98720 | Shad Barry | 22 | barrysh01 | 1901 | PHI | NL | 3.35211847 | -0.543857143 | 2B, 3B, OF, SS | 4 | 2 | PHI | ATL | 1901 | 1904 | CHC |
98719 | 98719 | Fred Jacklitsch | 25 | jacklfr01 | 1901 | PHI | NL | 1.598519128 | 0.399214286 | C, 3B | 4 | 1 | PHI | 1901 | 1902 | LAD | |
98718 | 98718 | Bill Hallman | 34 | hallmbi01 | 1901 | PHI | NL | 6.012340601 | -1.388571429 | 2B, 3B, SS | 5 | 2 | PHI | CLE | 1901 | 1903 | |
98717 | 98717 | Klondike Douglass | 29 | douglkl01 | 1901 | PHI | NL | 2.254627725 | 0.995142857 | C, 1B, OF | 6 | 1 | PHI | 1901 | 1904 | ||
98716 | 98716 | Happy Townsend | 22 | townsha01 | 1901 | PHI | NL | 4.840106952 | 0.410785714 | P, OF | 9 | 1 | PHI | 1901 | 1901 | MIN | |
98715 | 98715 | Monte Cross | 31 | crossmo01 | 1901 | PHI | NL | 6.525298231 | 0.017357143 | SS | 10 | 1 | PHI | 1901 | 1901 | OAK | |
98714 | 98714 | Ed McFarland | 27 | mcfared01 | 1901 | PHI | NL | 3.769642123 | 1.515857143 | C | 10 | 1 | PHI | 1901 | 1901 | CHW | |
98713 | 98713 | Hughie Jennings | 32 | jennihu01 | 1901 | PHI | NL | 4.139448787 | 1.452214286 | 1B, 2B, SS | 11 | 1 | PHI | 1901 | 1902 | LAD | |
98712 | 98712 | Harry Wolverton | 27 | wolveha01 | 1901 | PHI | NL | 4.926779103 | 2.991214286 | 3B | 16 | 1 | PHI | 1901 | 1901 | MIN | |
98711 | 98711 | Doc White | 22 | whitedo01 | 1901 | PHI | NL | 7.973262032 | 3.436714286 | P, OF | 22 | 1 | PHI | 1901 | 1902 | CHW | |
98710 | 98710 | Roy Thomas | 27 | thomaro01 | 1901 | PHI | NL | 7.193336076 | 4.993071429 | OF | 26 | 1 | PHI | 1901 | 1908 | PIT | |
98709 | 98709 | Bill Duggleby | 27 | dugglbi01 | 1901 | PHI | NL | 9.590374332 | 4.061571429 | P | 27 | 1 | PHI | 1901 | 1901 | OAK | |
98708 | 98708 | Red Donahue | 28 | donahre01 | 1901 | PHI | NL | 9.94973262 | 4.628571429 | P | 29 | 1 | PHI | 1901 | 1901 | BAL | |
98707 | 98707 | Al Orth | 28 | orthal01 | 1901 | PHI | NL | 9.489304813 | 6.705642857 | P, OF | 34 | 1 | PHI | 1901 | 1901 | MIN | |
98706 | 98706 | Ed Delahanty | 33 | delahed01 | 1901 | PHI | NL | 7.408062526 | 7.926428571 | OF, 1B | 35 | 1 | PHI | 1901 | 1901 | MIN | |
98705 | 98705 | Elmer Flick | 25 | flickel01 | 1901 | PHI | NL | 7.300699301 | 7.949571429 | OF | 35 | 1 | PHI | 1901 | 1901 | OAK | |
98704 | 98704 | Harry Lochhead | 25 | lochhha01 | 1901 | PHA | AL | 0.448860071 | -0.679927007 | SS | 0 | 2 | OAK | DET | 1901 | 1901 | |
98703 | 98703 | Bob Lindemann | 23 | lindebo01 | 1901 | PHA | AL | 0.121313533 | -0.325182482 | OF | 0 | 1 | OAK | 1901 | 1901 | ||
98702 | 98702 | Morgan Murphy | 34 | murphmo01 | 1901 | PHA | AL | 0.339677892 | -0.242408759 | C, 1B | 0 | 1 | OAK | 1901 | 1901 | ||
98701 | 98701 | Pete Loos | 23 | loospe01 | 1901 | PHA | AL | 0.034980566 | -0.218759124 | 0 | 1 | OAK | 1901 | 1901 | |||
98700 | 98700 | Fred Ketchum | 25 | ketchfr01 | 1901 | PHA | AL | 0.266889772 | -0.201021898 | OF | 0 | 1 | OAK | 1901 | 1901 | ||
98699 | 98699 | Bock Baker | 22 | bakerbo01 | 1901 | PHA | AL | 0.209883398 | -0.177372263 | P | 0 | 2 | OAK | CLE | 1901 | 1901 | |
98698 | 98698 | John McPherson | 32 | mcphejo01 | 1901 | PHA | AL | 0.139922265 | -0.165547445 | P | 0 | 1 | OAK | 1901 | 1901 | PHI | |
98697 | 98697 | Charlie Carr | 24 | carrch01 | 1901 | PHA | AL | 0.097050826 | -0.124160584 | 1B | 0 | 1 | OAK | 1901 | 1901 | DET |
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 );