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_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98385 | 98385 | Joe McGinnity | 30 | mcginjo01 | 1901 | BLA | AL | 14.68782423 | 6.812462687 | P, 3B | 40 | 1 | NYY | 1901 | 1902 | SFG | |
98386 | 98386 | Harry Howell | 24 | howelha01 | 1901 | BLA | AL | 11.32987489 | 4.739104478 | P, OF, SS, 1B, 2B | 30 | 1 | NYY | 1901 | 1903 | BAL | |
98387 | 98387 | Mike Donlin | 23 | donlimi01 | 1901 | BLA | AL | 6.831730769 | 5.355671642 | OF, 1B | 25 | 1 | NYY | 1901 | 1901 | CIN | |
98388 | 98388 | Jimmy Williams | 24 | williji01 | 1901 | BLA | AL | 7.199300699 | 4.920447761 | 2B | 24 | 1 | NYY | 1901 | 1907 | BAL | |
98389 | 98389 | Frank Foreman | 38 | foremfr01 | 1901 | BLA | AL | 7.356728715 | 4.025820896 | P | 22 | 2 | NYY | BOS | 1901 | 1902 | |
98390 | 98390 | John McGraw | 28 | mcgrajo01 | 1901 | BLA | AL | 3.903846154 | 4.503358209 | 3B | 19 | 1 | NYY | 1901 | 1902 | SFG | |
98391 | 98391 | Cy Seymour | 28 | seymocy01 | 1901 | BLA | AL | 7.427447552 | 2.097537313 | OF, 1B | 16 | 1 | NYY | 1901 | 1902 | CIN | |
98392 | 98392 | Jerry Nops | 26 | nopsje01 | 1901 | BLA | AL | 6.792798291 | 1.976641791 | P | 15 | 1 | NYY | 1901 | 1901 | ||
98393 | 98393 | Bill Keister | 29 | keistbi01 | 1901 | BLA | AL | 5.982517483 | 1.861791045 | SS | 14 | 1 | NYY | 1901 | 1901 | MIN | |
98394 | 98394 | Steve Brodie | 32 | brodist01 | 1901 | BLA | AL | 4.436188811 | 1.160597015 | OF | 9 | 1 | NYY | 1901 | 1901 | SFG | |
98395 | 98395 | Wilbert Robinson | 37 | robinwi01 | 1901 | BLA | AL | 3.219405594 | 1.033656716 | C | 7 | 1 | NYY | 1901 | 1902 | ||
98396 | 98396 | Jim Jackson | 23 | jacksji01 | 1901 | BLA | AL | 5.057255245 | -0.471492537 | OF | 6 | 1 | NYY | 1901 | 1901 | SFG | |
98397 | 98397 | Jimmy Hart | 25 | hartbu01 | 1901 | BLA | AL | 2.953234266 | 0.405 | 1B | 5 | 1 | NYY | 1901 | 1901 | ||
98398 | 98398 | Roger Bresnahan | 22 | bresnro01 | 1901 | BLA | AL | 4.093968531 | -0.048358209 | C, OF, 3B, 2B, P | 5 | 1 | NYY | 1901 | 1902 | SFG | |
98399 | 98399 | Jack Dunn | 28 | dunnja01 | 1901 | BLA | AL | 5.107954545 | -1.335895522 | 3B, SS, P, 2B, OF | 3 | 2 | NYY | PHI | 1901 | 1901 | SFG |
98400 | 98400 | Frank Foutz | 24 | foutzfr01 | 1901 | BLA | AL | 1.039335664 | 0.163208955 | 1B | 2 | 1 | NYY | 1901 | 1901 | ||
98401 | 98401 | Stan Yerkes | 26 | yerkest01 | 1901 | BLA | AL | 0.307598413 | 0.042313433 | P | 1 | 1 | NYY | 1901 | 1901 | STL | |
98402 | 98402 | Crazy Schmit | 35 | schmicr01 | 1901 | BLA | AL | 0.871528837 | -0.054402985 | P | 1 | 1 | NYY | 1901 | 1901 | ||
98403 | 98403 | Tacks Latimer | 23 | latimta01 | 1901 | BLA | AL | 0.050699301 | -0.060447761 | C | 0 | 1 | NYY | 1901 | 1901 | LAD | |
98404 | 98404 | George Rohe | 26 | rohege01 | 1901 | BLA | AL | 0.532342657 | -0.193432836 | 1B, 3B | 0 | 1 | NYY | 1901 | 1901 | CHW | |
98405 | 98405 | Slats Jordan | 22 | jordasl01 | 1901 | BLA | AL | 0.038024476 | -0.211567164 | 1B | 0 | 1 | NYY | 1901 | 1902 | ||
98406 | 98406 | Bill Karns | 25 | karnsbi01 | 1901 | BLA | AL | 0.653646628 | -0.247835821 | P | 0 | 1 | NYY | 1901 | 1901 | ||
98407 | 98407 | Chappie Snodgrass | 31 | snodgch01 | 1901 | BLA | AL | 0.126748252 | -0.350597015 | OF | 0 | 1 | NYY | 1901 | 1901 | ||
98408 | 98408 | Cy Young | 34 | youngcy01 | 1901 | BOS | AL | 12.81511915 | 12.06782609 | P | 53 | 1 | BOS | 1901 | 1908 | CLE | |
98409 | 98409 | Jimmy Collins | 31 | colliji01 | 1901 | BOS | AL | 7.415800416 | 7.912173913 | 3B | 33 | 1 | BOS | 1901 | 1907 | OAK | |
98410 | 98410 | Freddy Parent | 25 | parenfr01 | 1901 | BOS | AL | 7.09022869 | 5.834347826 | SS | 27 | 1 | BOS | 1901 | 1907 | CHW | |
98411 | 98411 | Buck Freeman | 29 | freembu01 | 1901 | BOS | AL | 6.607900208 | 5.646521739 | 1B, 2B, OF | 26 | 1 | BOS | 1901 | 1907 | ||
98412 | 98412 | Chick Stahl | 28 | stahlch01 | 1901 | BOS | AL | 7.186694387 | 5.135869565 | OF | 25 | 1 | BOS | 1901 | 1906 | ||
98413 | 98413 | Ted Lewis | 28 | lewiste01 | 1901 | BOS | AL | 10.91700904 | 3.128478261 | P | 24 | 1 | BOS | 1901 | 1901 | ||
98414 | 98414 | George Winter | 23 | wintege01 | 1901 | BOS | AL | 8.317173377 | 2.746956522 | P | 19 | 1 | BOS | 1901 | 1908 | DET | |
98415 | 98415 | Hobe Ferris | 26 | ferriho01 | 1901 | BOS | AL | 6.800831601 | 1.89 | 2B, SS | 15 | 1 | BOS | 1901 | 1907 | BAL | |
98416 | 98416 | Tommy Dowd | 32 | dowdto01 | 1901 | BOS | AL | 7.741372141 | 1.291304348 | OF, 1B, 3B | 14 | 1 | BOS | 1901 | 1901 | ||
98417 | 98417 | Ossee Schrecongost | 26 | schreos01 | 1901 | BOS | AL | 3.701871102 | 1.678695652 | C, 1B | 10 | 1 | BOS | 1901 | 1901 | CLE | |
98418 | 98418 | Charlie Hemphill | 25 | hemphch01 | 1901 | BOS | AL | 7.174636175 | 0.14673913 | OF | 10 | 1 | BOS | 1901 | 1901 | CLE | |
98419 | 98419 | Nig Cuppy | 31 | cuppyni01 | 1901 | BOS | AL | 3.221035333 | 0.786521739 | P, OF | 7 | 1 | BOS | 1901 | 1901 | ||
98420 | 98420 | Lou Criger | 29 | crigelo01 | 1901 | BOS | AL | 3.472765073 | 0.164347826 | C, 1B | 5 | 1 | BOS | 1901 | 1908 | BAL | |
98421 | 98421 | Fred Mitchell | 23 | mitchfr01 | 1901 | BOS | AL | 3.750205423 | 0.129130435 | P, 2B, SS | 5 | 1 | BOS | 1901 | 1902 | OAK | |
98422 | 98422 | George Prentiss | 25 | prentge01 | 1901 | BOS | AL | 0.345110929 | 0.240652174 | P | 1 | 1 | BOS | 1901 | 1902 | NYY | |
98423 | 98423 | Win Kellum | 25 | kelluwi01 | 1901 | BOS | AL | 1.656532457 | -0.375652174 | P | 1 | 1 | BOS | 1901 | 1901 | CIN | |
98424 | 98424 | Harry Gleason | 26 | gleasha01 | 1901 | BOS | AL | 0.012058212 | 0.088043478 | 3B | 0 | 1 | BOS | 1901 | 1903 | BAL | |
98425 | 98425 | Jack Slattery | 23 | slattja01 | 1901 | BOS | AL | 0.048232848 | 0.023478261 | C | 0 | 1 | BOS | 1901 | 1901 | CLE | |
98426 | 98426 | Frank Morrissey | 25 | morrifr01 | 1901 | BOS | AL | 0.149548069 | -0.046956522 | P | 0 | 1 | BOS | 1901 | 1901 | CHC | |
98427 | 98427 | Ben Beville | 23 | bevilbe01 | 1901 | BOS | AL | 0.310599836 | -0.076304348 | P, 1B | 0 | 1 | BOS | 1901 | 1901 | ||
98428 | 98428 | Larry McLean | 19 | mcleala01 | 1901 | BOS | AL | 0.229106029 | -0.117391304 | 1B | 0 | 1 | BOS | 1901 | 1901 | CHC | |
98429 | 98429 | Frank Foreman | 38 | foremfr01 | 1901 | BOS | AL | 0.276088743 | -0.293478261 | P | 0 | 1 | BOS | 1901 | 1901 | NYY | |
98430 | 98430 | Jake Volz | 23 | volzja01 | 1901 | BOS | AL | 0.24157765 | -0.358043478 | P | 0 | 1 | BOS | 1901 | 1901 | ATL | |
98431 | 98431 | Charlie Jones | 25 | jonesch03 | 1901 | BOS | AL | 0.518503119 | -0.563478261 | OF | 0 | 1 | BOS | 1901 | 1901 | CHW | |
98432 | 98432 | Bill Donovan | 24 | donovbi01 | 1901 | BRO | NL | 12.146663 | 6.137080292 | P | 37 | 1 | LAD | 1901 | 1902 | DET | |
98433 | 98433 | Jimmy Sheckard | 22 | sheckji01 | 1901 | BRO | NL | 7.384904871 | 7.798467153 | OF, 3B | 34 | 1 | LAD | 1901 | 1901 | NYY | |
98434 | 98434 | Frank Kitson | 31 | kitsofr01 | 1901 | BRO | NL | 9.712716287 | 4.150510949 | P, OF, 1B | 27 | 1 | LAD | 1901 | 1902 | DET | |
98435 | 98435 | Tom Daly | 35 | dalyto01 | 1901 | BRO | NL | 6.984737612 | 4.653065693 | 2B | 24 | 1 | LAD | 1901 | 1901 | CHW | |
98436 | 98436 | Bill Dahlen | 31 | dahlebi01 | 1901 | BRO | NL | 6.705833159 | 4.28649635 | SS, 2B | 23 | 1 | LAD | 1901 | 1903 | SFG | |
98437 | 98437 | Willie Keeler | 29 | keelewi01 | 1901 | BRO | NL | 7.821450972 | 3.819416058 | OF, 3B, 2B | 23 | 1 | LAD | 1901 | 1902 | NYY | |
98438 | 98438 | Joe Kelley | 29 | kellejo01 | 1901 | BRO | NL | 6.536065231 | 3.712992701 | 1B, 3B | 21 | 1 | LAD | 1901 | 1901 | NYY | |
98439 | 98439 | Jay Hughes | 27 | hugheja01 | 1901 | BRO | NL | 8.674539962 | 2.400437956 | P | 20 | 1 | LAD | 1901 | 1902 | ||
98440 | 98440 | Tom McCreery | 26 | mccreto01 | 1901 | BRO | NL | 4.486723814 | 2.447737226 | OF, 1B, SS | 14 | 1 | LAD | 1901 | 1903 | ATL | |
98441 | 98441 | Doc Newton | 23 | newtodo01 | 1901 | BRO | NL | 3.633617138 | 2.057518248 | P | 12 | 2 | LAD | CIN | 1901 | 1902 | NYY |
98442 | 98442 | Duke Farrell | 34 | farredu01 | 1901 | BRO | NL | 3.589379051 | 1.501751825 | C, 1B | 10 | 1 | LAD | 1901 | 1902 | BOS | |
98443 | 98443 | Deacon McGuire | 37 | mcguide01 | 1901 | BRO | NL | 3.953167468 | 1.247518248 | C, 1B | 10 | 1 | LAD | 1901 | 1901 | DET | |
98444 | 98444 | Brickyard Kennedy | 33 | kennebr01 | 1901 | BRO | NL | 2.953034881 | 0.957810219 | P | 7 | 1 | LAD | 1901 | 1901 | SFG | |
98445 | 98445 | Cozy Dolan | 28 | dolanco01 | 1901 | BRO | NL | 3.346853439 | -0.407956204 | OF | 4 | 2 | LAD | CHC | 1901 | 1902 | CHW |
98446 | 98446 | Charlie Irwin | 32 | irwinch01 | 1901 | BRO | NL | 3.201338072 | -0.520291971 | 3B | 3 | 2 | LAD | CIN | 1901 | 1902 | |
98447 | 98447 | Gene Wright | 22 | wrighge02 | 1901 | BRO | NL | 0.311452898 | 0.348832117 | P | 2 | 1 | LAD | 1901 | 1901 | CLE | |
98448 | 98448 | Frank Gatins | 30 | gatinfr01 | 1901 | BRO | NL | 2.510140079 | -0.733138686 | 3B, SS | 2 | 1 | LAD | 1901 | 1901 | ||
98449 | 98449 | Doc McJames | 26 | mcjamdo01 | 1901 | BRO | NL | 3.149134853 | -1.005109489 | P | 2 | 1 | LAD | 1901 | 1901 | ||
98450 | 98450 | John Gochnaur | 25 | gochnjo01 | 1901 | BRO | NL | 0.145515367 | 0.23649635 | SS | 1 | 1 | LAD | 1901 | 1901 | CLE | |
98451 | 98451 | Gene McCann | 26 | mccange01 | 1901 | BRO | NL | 1.176599835 | -0.413868613 | P | 1 | 1 | LAD | 1901 | 1902 | ||
98452 | 98452 | Hughie Hearne | 28 | hearnhu01 | 1901 | BRO | NL | 0.060631403 | 0.029562044 | C | 0 | 1 | LAD | 1901 | 1903 | ||
98453 | 98453 | Farmer Steelman | 26 | steelfa01 | 1901 | BRO | NL | 0.036378842 | 0.005912409 | C, OF | 0 | 1 | LAD | 1901 | 1901 | OAK | |
98454 | 98454 | Kid Carsey | 28 | carseki01 | 1901 | BRO | NL | 0.242241143 | -0.301532847 | P | 0 | 1 | LAD | 1901 | 1901 | ||
98455 | 98455 | Lefty Davis | 26 | davisle01 | 1901 | BRO | NL | 1.236880619 | -0.739051095 | OF, 2B | 0 | 1 | LAD | 1901 | 1901 | PIT | |
98456 | 98456 | Vic Willis | 25 | willivi01 | 1901 | BSN | NL | 10.15360253 | 7.365214286 | P | 37 | 1 | ATL | 1901 | 1905 | PIT | |
98457 | 98457 | Kid Nichols | 31 | nichoki01 | 1901 | BSN | NL | 10.67458432 | 6.694071429 | P, OF, 1B | 36 | 1 | ATL | 1901 | 1901 | STL | |
98458 | 98458 | Bill Dinneen | 25 | dinnebi01 | 1901 | BSN | NL | 10.28661916 | 5.606357143 | P, OF, 1B | 32 | 1 | ATL | 1901 | 1901 | BOS | |
98459 | 98459 | Togie Pittinger | 29 | pittito01 | 1901 | BSN | NL | 9.355502771 | 3.419357143 | P | 24 | 1 | ATL | 1901 | 1904 | PHI | |
98460 | 98460 | Gene DeMontreville | 28 | demonge01 | 1901 | BSN | NL | 7.750863558 | 2.852357143 | 2B, 3B | 20 | 1 | ATL | 1901 | 1902 | MIN | |
98461 | 98461 | Billy Hamilton | 35 | hamilbi01 | 1901 | BSN | NL | 5.321675302 | 3.025928571 | OF | 17 | 1 | ATL | 1901 | 1901 | ||
98462 | 98462 | Fred Tenney | 29 | tennefr02 | 1901 | BSN | NL | 6.360967185 | 1.747285714 | 1B, C | 15 | 1 | ATL | 1901 | 1907 | SFG | |
98463 | 98463 | Herman Long | 35 | longhe01 | 1901 | BSN | NL | 6.999568221 | 1.463785714 | SS | 15 | 1 | ATL | 1901 | 1902 | NYY | |
98464 | 98464 | Malachi Kittridge | 31 | kittrma01 | 1901 | BSN | NL | 5.34671848 | 1.585285714 | C | 13 | 1 | ATL | 1901 | 1903 | MIN | |
98465 | 98465 | Bobby Lowe | 35 | lowebo01 | 1901 | BSN | NL | 6.498704663 | -0.156214286 | 3B, 2B | 9 | 1 | ATL | 1901 | 1901 | CHC | |
98466 | 98466 | Duff Cooley | 28 | cooledu01 | 1901 | BSN | NL | 3.293177893 | 0.312428571 | OF, 1B | 6 | 1 | ATL | 1901 | 1904 | DET | |
98467 | 98467 | Jimmy Slagle | 27 | slaglji01 | 1901 | BSN | NL | 3.706390328 | 0.295071429 | OF | 6 | 2 | ATL | PHI | 1901 | 1901 | CHC |
98468 | 98468 | Frank Murphy | 25 | murphfr01 | 1901 | BSN | NL | 2.316493955 | -0.023142857 | OF, 2B | 3 | 1 | ATL | 1901 | 1901 | SFG | |
98469 | 98469 | Bob Lawson | 25 | lawsobo01 | 1901 | BSN | NL | 1.529691211 | -0.248785714 | P, OF, 3B | 2 | 1 | ATL | 1901 | 1901 | NYY | |
98470 | 98470 | Fred Crolius | 24 | crolifr01 | 1901 | BSN | NL | 2.779792746 | -0.844714286 | OF | 2 | 1 | ATL | 1901 | 1901 | PIT | |
98471 | 98471 | Billy Lush | 27 | lushbi01 | 1901 | BSN | NL | 0.375647668 | 0.138857143 | OF | 1 | 1 | ATL | 1901 | 1902 | DET | |
98472 | 98472 | Pat Carney | 24 | carnepa01 | 1901 | BSN | NL | 0.738773748 | -0.104142857 | OF | 1 | 1 | ATL | 1901 | 1904 | ||
98473 | 98473 | Fred Brown | 22 | brownfr01 | 1901 | BSN | NL | 0.175302245 | -0.231428571 | OF | 0 | 1 | ATL | 1901 | 1902 | ||
98474 | 98474 | John Hinton | 25 | hintojo01 | 1901 | BSN | NL | 0.187823834 | -0.260357143 | 3B | 0 | 1 | ATL | 1901 | 1901 | ||
98475 | 98475 | Shad Barry | 22 | barrysh01 | 1901 | BSN | NL | 0.538428325 | -0.2835 | 2B, 3B, OF, SS | 0 | 1 | ATL | 1901 | 1901 | PHI | |
98476 | 98476 | Joe Rickert | 24 | rickejo01 | 1901 | BSN | NL | 0.801381693 | -0.2835 | OF | 0 | 1 | ATL | 1901 | 1901 | ||
98477 | 98477 | George Grosart | 21 | grossge01 | 1901 | BSN | NL | 0.325561313 | -0.352928571 | OF | 0 | 1 | ATL | 1901 | 1901 | ||
98478 | 98478 | Mike Smith | 33 | smithel01 | 1901 | BSN | NL | 0.801381693 | -0.491785714 | OF | 0 | 2 | ATL | PIT | 1901 | 1901 | |
98479 | 98479 | Daff Gammons | 25 | gammoda01 | 1901 | BSN | NL | 1.289723661 | -1.041428571 | OF, 2B, 3B | 0 | 1 | ATL | 1901 | 1901 | ||
98480 | 98480 | Pat Moran | 25 | moranpa01 | 1901 | BSN | NL | 2.391623489 | -1.128214286 | C, 1B, 3B, SS, OF, 2B | 0 | 1 | ATL | 1901 | 1905 | CHC | |
98481 | 98481 | Topsy Hartsel | 27 | hartsto01 | 1901 | CHC | NL | 7.61048071 | 6.6825 | OF | 28 | 1 | CHC | 1901 | 1901 | OAK | |
98482 | 98482 | Danny Green | 24 | greenda01 | 1901 | CHC | NL | 7.012172478 | 4.732714286 | OF | 22 | 1 | CHC | 1901 | 1901 | CHW | |
98483 | 98483 | Rube Waddell | 24 | wadderu01 | 1901 | CHC | NL | 9.660792952 | 3.818571429 | P, 1B | 22 | 2 | CHC | PIT | 1901 | 1901 | OAK |
98484 | 98484 | Tom Hughes | 22 | hugheto01 | 1901 | CHC | NL | 12.2246696 | 1.915071429 | P, OF | 20 | 1 | CHC | 1901 | 1901 | NYY |
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 );