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_left
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98387 | 98387 | Mike Donlin | 23 | donlimi01 | 1901 | BLA | AL | 6.831730769 | 5.355671642 | OF, 1B | 25 | 1 | NYY | 1901 | 1901 | 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 | |
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 | ||
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 | |
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 | ||
98413 | 98413 | Ted Lewis | 28 | lewiste01 | 1901 | BOS | AL | 10.91700904 | 3.128478261 | P | 24 | 1 | BOS | 1901 | 1901 | ||
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 | ||
98423 | 98423 | Win Kellum | 25 | kelluwi01 | 1901 | BOS | AL | 1.656532457 | -0.375652174 | P | 1 | 1 | BOS | 1901 | 1901 | CIN | |
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 | |
98433 | 98433 | Jimmy Sheckard | 22 | sheckji01 | 1901 | BRO | NL | 7.384904871 | 7.798467153 | OF, 3B | 34 | 1 | LAD | 1901 | 1901 | NYY | |
98435 | 98435 | Tom Daly | 35 | dalyto01 | 1901 | BRO | NL | 6.984737612 | 4.653065693 | 2B | 24 | 1 | LAD | 1901 | 1901 | CHW | |
98438 | 98438 | Joe Kelley | 29 | kellejo01 | 1901 | BRO | NL | 6.536065231 | 3.712992701 | 1B, 3B | 21 | 1 | LAD | 1901 | 1901 | NYY | |
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 | |
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 | |
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 | |
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 | |
98461 | 98461 | Billy Hamilton | 35 | hamilbi01 | 1901 | BSN | NL | 5.321675302 | 3.025928571 | OF | 17 | 1 | ATL | 1901 | 1901 | ||
98465 | 98465 | Bobby Lowe | 35 | lowebo01 | 1901 | BSN | NL | 6.498704663 | -0.156214286 | 3B, 2B | 9 | 1 | ATL | 1901 | 1901 | CHC | |
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 | |
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 | ||
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 | |
98486 | 98486 | Barry McCormick | 26 | mccorba01 | 1901 | CHC | NL | 5.540334227 | 1.284428571 | SS, 3B | 10 | 1 | CHC | 1901 | 1901 | BAL | |
98491 | 98491 | Cupid Childs | 33 | childcu01 | 1901 | CHC | NL | 3.278729111 | 1.024071429 | 2B | 7 | 1 | CHC | 1901 | 1901 | ||
98492 | 98492 | Pete Childs | 29 | childpe01 | 1901 | CHC | NL | 2.883845678 | 0.711642857 | 2B, OF, SS | 5 | 2 | CHC | STL | 1901 | 1901 | PHI |
98494 | 98494 | Fred Raymer | 25 | raymefr01 | 1901 | CHC | NL | 5.827522179 | -0.914142857 | 3B, SS, 1B, 2B | 4 | 1 | CHC | 1901 | 1901 | ATL | |
98496 | 98496 | Jack Doyle | 31 | doyleja01 | 1901 | CHC | NL | 3.577883227 | -0.306642857 | 1B | 3 | 1 | CHC | 1901 | 1901 | SFG | |
98497 | 98497 | Cozy Dolan | 28 | dolanco01 | 1901 | CHC | NL | 2.153909635 | -0.179357143 | OF | 2 | 1 | CHC | 1901 | 1901 | LAD | |
98499 | 98499 | Bert Cunningham | 35 | cunnibe01 | 1901 | CHC | NL | 0.356828194 | 0.046285714 | P | 1 | 1 | CHC | 1901 | 1901 | ||
98500 | 98500 | Harry Croft | 25 | croftha01 | 1901 | CHC | NL | 0.143593976 | 0.011571429 | OF | 0 | 1 | CHC | 1901 | 1901 | ||
98501 | 98501 | Larry Hoffman | 22 | hoffmla01 | 1901 | CHC | NL | 0.275221787 | 0.005785714 | 3B, 2B | 0 | 1 | CHC | 1901 | 1901 | ||
98502 | 98502 | Charlie Ferguson | 26 | ferguch02 | 1901 | CHC | NL | 0.079295154 | 0.005785714 | P | 0 | 1 | CHC | 1901 | 1901 | ||
98503 | 98503 | Jim Delahanty | 22 | delahji01 | 1901 | CHC | NL | 0.837631525 | -0.381857143 | 3B, 2B | 0 | 1 | CHC | 1901 | 1901 | SFG | |
98504 | 98504 | Eddie Hickey | 28 | hickeed01 | 1901 | CHC | NL | 0.478646586 | -0.480214286 | 3B | 0 | 1 | CHC | 1901 | 1901 | ||
98505 | 98505 | Bill Gannon | 28 | gannobi01 | 1901 | CHC | NL | 0.753868372 | -0.8505 | OF | 0 | 1 | CHC | 1901 | 1901 | ||
98509 | 98509 | Dummy Hoy | 39 | hoydu01 | 1901 | CHW | AL | 7.684580405 | 5.327080292 | OF | 27 | 1 | CHW | 1901 | 1901 | CIN | |
98512 | 98512 | Fred Hartman | 36 | hartmfr01 | 1901 | CHW | AL | 6.174038859 | 4.647153285 | 3B | 23 | 1 | CHW | 1901 | 1901 | STL | |
98517 | 98517 | Frank Shugart | 34 | shugafr01 | 1901 | CHW | AL | 5.454733361 | 0.739051095 | SS | 10 | 1 | CHW | 1901 | 1901 | ||
98518 | 98518 | Joe Sugden | 30 | sugdejo01 | 1901 | CHW | AL | 2.062009095 | 0.880948905 | C, 1B | 6 | 1 | CHW | 1901 | 1901 | BAL | |
98519 | 98519 | Zaza Harvey | 22 | harveza01 | 1901 | CHW | AL | 3.17415115 | 0.52620438 | OF, P | 6 | 1 | CHW | 1901 | 1901 | CLE | |
98520 | 98520 | John Skopec | 21 | skopejo01 | 1901 | CHW | AL | 2.357612267 | 0.585328467 | P | 5 | 1 | CHW | 1901 | 1901 | DET | |
98521 | 98521 | Jimmy Burke | 26 | burkeji01 | 1901 | CHW | AL | 2.038032245 | 0.354744526 | 3B, SS | 4 | 2 | CHW | BAL | 1901 | 1901 | PIT |
98523 | 98523 | Pop Foster | 23 | fostepo01 | 1901 | CHW | AL | 0.467548574 | 0.212846715 | OF, SS | 1 | 2 | CHW | MIN | 1901 | 1901 | |
98524 | 98524 | Dave Brain | 22 | brainda01 | 1901 | CHW | AL | 0.251756924 | 0.147810219 | 2B | 1 | 1 | CHW | 1901 | 1901 | STL | |
98525 | 98525 | Frank Dupee | 24 | dupeefr01 | 1901 | CHW | AL | 0.0 | 0.0 | 0 | 1 | CHW | 1901 | 1901 | |||
98526 | 98526 | Jack McAleese | 22 | mcaleja01 | 1901 | CHW | AL | 0.103504929 | -0.059124088 | P | 0 | 1 | CHW | 1901 | 1901 | BAL | |
98535 | 98535 | Dick Harley | 28 | harledi01 | 1901 | CIN | NL | 7.106907895 | 0.193943662 | OF | 10 | 1 | CIN | 1901 | 1901 | DET | |
98536 | 98536 | Doc Newton | 23 | newtodo01 | 1901 | CIN | NL | 5.585988939 | -0.678802817 | P | 5 | 1 | CIN | 1901 | 1901 | LAD | |
98538 | 98538 | Charlie Irwin | 32 | irwinch01 | 1901 | CIN | NL | 3.350740132 | -0.045633803 | 3B | 4 | 1 | CIN | 1901 | 1901 | LAD | |
98541 | 98541 | Algie McBride | 32 | mcbrial01 | 1901 | CIN | NL | 1.574013158 | 0.096971831 | OF | 2 | 1 | CIN | 1901 | 1901 | SFG | |
98544 | 98544 | Charlie Case | 21 | casech01 | 1901 | CIN | NL | 0.895970503 | -0.131197183 | P | 1 | 1 | CIN | 1901 | 1901 | PIT | |
98546 | 98546 | Charlie Krause | 27 | krausch01 | 1901 | CIN | NL | 0.047697368 | -0.011408451 | 2B | 0 | 1 | CIN | 1901 | 1901 | ||
98547 | 98547 | Gus Weyhing | 34 | weyhigu01 | 1901 | CIN | NL | 0.298656834 | -0.102676056 | P | 0 | 2 | CIN | CLE | 1901 | 1901 | |
98549 | 98549 | Mike Kahoe | 27 | kahoemi01 | 1901 | CIN | NL | 0.166940789 | -0.125492958 | C, 1B | 0 | 1 | CIN | 1901 | 1901 | CHC | |
98550 | 98550 | Chink Heileman | 28 | heilech01 | 1901 | CIN | NL | 0.178865132 | -0.256690141 | 3B, 2B | 0 | 1 | CIN | 1901 | 1901 | ||
98551 | 98551 | Amos Rusie | 30 | rusieam01 | 1901 | CIN | NL | 0.73005004 | -0.302323944 | P | 0 | 1 | CIN | 1901 | 1901 | ||
98552 | 98552 | Doc Parker | 29 | parkedo01 | 1901 | CIN | NL | 0.265472742 | -0.325140845 | P | 0 | 1 | CIN | 1901 | 1901 | ||
98553 | 98553 | Dick Scott | 18 | scottdi01 | 1901 | CIN | NL | 0.696865947 | -0.353661972 | P | 0 | 1 | CIN | 1901 | 1901 | ||
98554 | 98554 | Jerry Hurley | 26 | hurleje02 | 1901 | CIN | NL | 0.286184211 | -0.370774648 | C | 0 | 1 | CIN | 1901 | 1901 | LAD | |
98555 | 98555 | Pete O'Brien | 24 | o'bripe02 | 1901 | CIN | NL | 0.667763158 | -0.399295775 | 2B | 0 | 1 | CIN | 1901 | 1901 | BAL | |
98556 | 98556 | Whitey Guese | 29 | guesewh01 | 1901 | CIN | NL | 1.471161443 | -0.815704225 | P | 0 | 1 | CIN | 1901 | 1901 | ||
98557 | 98557 | Barney McFadden | 26 | mcfadba01 | 1901 | CIN | NL | 1.526468264 | -1.021056338 | P | 0 | 1 | CIN | 1901 | 1901 | PHI | |
98558 | 98558 | Bill Fox | 29 | foxbi01 | 1901 | CIN | NL | 2.0390625 | -1.100915493 | 2B | 0 | 1 | CIN | 1901 | 1901 | ||
98563 | 98563 | Pete Dowling | 24 | dowlipe01 | 1901 | CLE | AL | 9.170357751 | 2.371304348 | P | 20 | 2 | CLE | BAL | 1901 | 1901 | |
98564 | 98564 | Candy LaChance | 31 | lachaca01 | 1901 | CLE | AL | 6.968896464 | 1.555434783 | 1B | 14 | 1 | CLE | 1901 | 1901 | BOS |
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 );