mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
2,392 rows where prev_franch = "OAK"
This data as json, copyable, CSV (advanced)
Suggested facets: age, lg_ID, stint_ID, franch_id, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
58 | 58 | Matthew Joyce | 34 | joycema01 | 2019 | ATL | NL | 2.26128591 | 1.166603774 | RF, LF | 7 | 1 | ATL | OAK | 2019 | 2019 | |
111 | 111 | Aaron Brooks | 29 | brookaa01 | 2019 | BAL | AL | 1.720608757 | 0.27 | P | 3 | 2 | BAL | OAK | 2019 | 2019 | |
127 | 127 | Josh Lucas | 28 | lucasjo02 | 2019 | BAL | AL | 0.317466994 | 0.040754717 | P | 0 | 1 | BAL | OAK | 2019 | 2019 | |
192 | 192 | Josh Smith | 31 | smithjo07 | 2019 | BOS | AL | 0.687846373 | -0.229245283 | P | 0 | 1 | BOS | OAK | 2019 | 2019 | |
207 | 207 | Jon Lester | 35 | lestejo01 | 2019 | CHC | NL | 4.837525654 | 2.470754717 | P | 13 | 1 | CHC | OAK | 2015 | 2019 | |
381 | 381 | Dan Otero | 34 | oteroda01 | 2019 | CLE | AL | 0.610079752 | -0.050943396 | P | 1 | 1 | CLE | OAK | 2016 | 2019 | |
588 | 588 | Jesse Hahn | 29 | hahnje01 | 2019 | KCR | AL | 0.129386456 | -0.234339623 | P | 0 | 1 | KCR | OAK | 2019 | 2019 | |
625 | 625 | Jonathan Lucroy | 33 | lucrojo01 | 2019 | LAA | AL | 2.536139664 | -0.433018868 | C, 1B | 2 | 1 | ANA | OAK | 2019 | 2019 | CHC |
628 | 628 | Trevor Cahill | 31 | cahiltr01 | 2019 | LAA | AL | 2.783693499 | -0.631698113 | P | 2 | 1 | ANA | OAK | 2019 | 2019 | |
657 | 657 | Max Muncy | 28 | muncyma01 | 2019 | LAD | NL | 5.7470274 | 5.073962264 | 2B, 1B, 3B | 23 | 1 | LAD | OAK | 2018 | 2019 | |
676 | 676 | Rich Hill | 39 | hillri01 | 2019 | LAD | NL | 1.575078176 | 1.069811321 | P | 5 | 1 | LAD | OAK | 2016 | 2019 | |
880 | 880 | Jeurys Familia | 29 | familje01 | 2019 | NYM | NL | 1.672945267 | -0.427924528 | P | 1 | 1 | NYM | OAK | 2019 | 2019 | |
892 | 892 | Jed Lowrie | 35 | lowrije01 | 2019 | NYM | NL | 0.069520548 | -0.117169811 | 0 | 1 | NYM | OAK | 2019 | 2019 | ||
953 | 953 | Ryan Dull | 29 | dullry01 | 2019 | NYY | AL | 0.072749878 | -0.168113208 | P | 0 | 2 | NYY | OAK | 2019 | 2019 | |
956 | 956 | Kendrys Morales | 36 | moralke01 | 2019 | NYY | AL | 0.712297364 | -0.40245283 | 1B, P | 0 | 2 | NYY | OAK | 2019 | 2019 | |
1096 | 1096 | Wei-Chung Wang | 27 | wangwe01 | 2019 | PIT | NL | 0.08073775 | -0.015283019 | P | 0 | 2 | PIT | OAK | 2019 | 2019 | |
1149 | 1149 | Nick Martini | 29 | martini02 | 2019 | SDP | NL | 0.947443182 | 0.00509434 | LF, P | 1 | 2 | SDP | OAK | 2019 | 2019 | |
1194 | 1194 | Cory Gearrin | 33 | gearrco01 | 2019 | SEA | AL | 1.210820441 | 0.509433962 | P | 3 | 1 | SEA | OAK | 2019 | 2019 | NYY |
1202 | 1202 | Ryon Healy | 27 | healyry01 | 2019 | SEA | AL | 1.787998681 | -0.050943396 | 3B, 1B | 2 | 1 | SEA | OAK | 2018 | 2019 | |
1293 | 1293 | Corban Joseph | 30 | josepco01 | 2019 | SFG | NL | 0.170913503 | -0.249622642 | 2B, 3B | 0 | 2 | SFG | OAK | 2019 | 2019 | PIT |
1359 | 1359 | Emilio Pagan | 28 | paganem01 | 2019 | TBR | AL | 2.614576 | 1.946037736 | P | 9 | 1 | TBD | OAK | 2019 | 2019 | |
1361 | 1361 | Joey Wendle | 29 | wendljo01 | 2019 | TBR | AL | 2.405269149 | 0.794716981 | 2B, 3B, SS | 6 | 1 | TBD | OAK | 2018 | 2019 | |
1387 | 1387 | Wilmer Font | 29 | fontwi01 | 2019 | TBR | AL | 0.335577442 | 0.025471698 | P | 1 | 1 | TBD | OAK | 2018 | 2019 | NYM |
1423 | 1423 | Shawn Kelley | 35 | kellesh01 | 2019 | TEX | AL | 1.914968801 | 0.560377358 | P | 4 | 1 | TEX | OAK | 2019 | 2019 | |
1497 | 1497 | Beau Taylor | 29 | taylobe11 | 2019 | TOR | AL | 0.019443513 | -0.020377358 | C | 0 | 2 | TOR | OAK | 2019 | 2019 | |
1514 | 1514 | Edwin Jackson | 35 | jacksed01 | 2019 | TOR | AL | 0.799676446 | -1.207358491 | P | 0 | 1 | TOR | OAK | 2019 | 2019 | DET |
1528 | 1528 | Sean Doolittle | 32 | doolise01 | 2019 | WSN | NL | 2.28164519 | 0.962830189 | P | 6 | 1 | WSN | OAK | 2017 | 2019 | |
1535 | 1535 | Fernando Rodney | 42 | rodnefe01 | 2019 | WSN | NL | 1.130833625 | 0.387169811 | P | 3 | 2 | WSN | OAK | 2019 | 2019 | |
1776 | 1776 | Jon Lester | 34 | lestejo01 | 2018 | CHC | NL | 4.897584406 | 2.60392638 | P | 15 | 1 | CHC | OAK | 2015 | 2019 | |
1855 | 1855 | Dustin Garneau | 30 | garnedu01 | 2018 | CHW | AL | 0.028760331 | 0.035 | C | 0 | 1 | CHW | OAK | 2018 | 2018 | ANA |
1872 | 1872 | Trayce Thompson | 27 | thomptr01 | 2018 | CHW | AL | 1.246280992 | -1.12 | RF, LF, CF | 0 | 2 | CHW | OAK | 2018 | 2018 | |
1958 | 1958 | Dan Otero | 33 | oteroda01 | 2018 | CLE | AL | 1.62167162 | -0.32 | P | 1 | 1 | CLE | OAK | 2016 | 2019 | |
1984 | 1984 | Carlos Gonzalez | 32 | gonzaca01 | 2018 | COL | NL | 5.002909464 | 1.073374233 | RF | 11 | 1 | COL | OAK | 2009 | 2018 | CLE |
2215 | 2215 | Max Muncy | 27 | muncyma01 | 2018 | LAD | NL | 4.630373444 | 4.691042945 | 1B, 3B, 2B, LF | 19 | 1 | LAD | OAK | 2018 | 2019 | |
2230 | 2230 | Rich Hill | 38 | hillri01 | 2018 | LAD | NL | 3.593580833 | 1.381472393 | P | 8 | 1 | LAD | OAK | 2016 | 2019 | |
2260 | 2260 | Zach Neal | 29 | nealza01 | 2018 | LAD | NL | 0.015128541 | -0.064601227 | P | 0 | 1 | LAD | OAK | 2018 | 2018 | |
2369 | 2369 | Eric Sogard | 32 | sogarer01 | 2018 | MIL | NL | 1.108030431 | -0.829877301 | SS, 2B, LF | 0 | 1 | MIL | OAK | 2017 | 2018 | TOR |
2409 | 2409 | Ryan LaMarre | 29 | lamarry01 | 2018 | MIN | AL | 1.030984997 | -0.06 | CF, LF, RF, P | 1 | 1 | MIN | OAK | 2018 | 2018 | CHW |
2467 | 2467 | Bobby Wahl | 26 | wahlbo01 | 2018 | NYM | NL | 0.149672033 | -0.26 | P | 0 | 1 | NYM | OAK | 2018 | 2018 | |
2495 | 2495 | Sonny Gray | 28 | grayso01 | 2018 | NYY | AL | 3.585931795 | 1.045 | P | 8 | 1 | NYY | OAK | 2017 | 2018 | CIN |
2660 | 2660 | Ryan Lavarnway | 30 | lavarry01 | 2018 | PIT | NL | 0.060511215 | 0.19621118 | 1 | 1 | PIT | OAK | 2018 | 2018 | CIN | |
2742 | 2742 | Ryon Healy | 26 | healyry01 | 2018 | SEA | AL | 5.011046991 | -0.76 | 1B, 3B | 6 | 1 | SEA | OAK | 2018 | 2019 | |
2771 | 2771 | Ross Detwiler | 32 | detwiro01 | 2018 | SEA | AL | 0.177306252 | 0.0 | P | 0 | 1 | SEA | OAK | 2018 | 2018 | CHW |
2879 | 2879 | Joey Wendle | 28 | wendljo01 | 2018 | TBR | AL | 5.120686862 | 4.045 | 2B, 3B, LF, SS, RF | 19 | 1 | TBD | OAK | 2018 | 2019 | |
2904 | 2904 | Wilmer Font | 28 | fontwi01 | 2018 | TBR | AL | 0.65074516 | 0.8 | P | 3 | 3 | TBD | OAK | 2018 | 2019 | NYM |
2961 | 2961 | Renato Nunez | 24 | nunezre01 | 2018 | TEX | AL | 0.387044271 | 0.16 | 3B, LF | 1 | 1 | TEX | OAK | 2018 | 2018 | BAL |
3003 | 3003 | Josh Donaldson | 32 | donaljo02 | 2018 | TOR | AL | 1.523793787 | 0.67 | 3B, 1B | 4 | 1 | TOR | OAK | 2015 | 2018 | CLE |
3008 | 3008 | John Axford | 35 | axforjo01 | 2018 | TOR | AL | 1.402075101 | 0.265 | P | 3 | 1 | TOR | OAK | 2018 | 2018 | LAD |
3052 | 3052 | Sean Doolittle | 31 | doolise01 | 2018 | WSN | NL | 1.85726459 | 2.19 | P | 9 | 1 | WSN | OAK | 2017 | 2019 | |
3054 | 3054 | Gio Gonzalez | 32 | gonzagi01 | 2018 | WSN | NL | 4.073371042 | 1.27 | P | 9 | 1 | WSN | OAK | 2012 | 2018 | MIL |
3080 | 3080 | Ryan Madson | 37 | madsory01 | 2018 | WSN | NL | 1.637493265 | -0.22 | P | 1 | 1 | WSN | OAK | 2017 | 2018 | LAD |
3142 | 3142 | Adam Rosales | 34 | rosalad01 | 2017 | ARI | NL | 0.878787879 | -0.375 | SS, 3B, 2B, 1B, LF | 0 | 2 | ARI | OAK | 2017 | 2017 | CLE |
3285 | 3285 | Rajai Davis | 36 | davisra01 | 2017 | BOS | AL | 0.349010293 | -0.125 | CF, LF, RF | 0 | 2 | BOS | OAK | 2017 | 2017 | CLE |
3297 | 3297 | Jon Lester | 33 | lestejo01 | 2017 | CHC | NL | 5.090839076 | 2.08 | P | 14 | 1 | CHC | OAK | 2015 | 2019 | |
3432 | 3432 | Arismendy Alcantara | 25 | alcanar01 | 2017 | CIN | NL | 1.06440102 | -0.67 | 2B, CF, RF, SS, 3B, LF | 0 | 1 | CIN | OAK | 2017 | 2017 | |
3458 | 3458 | Dan Otero | 32 | oteroda01 | 2017 | CLE | AL | 1.457019948 | 0.64 | P | 4 | 1 | CLE | OAK | 2016 | 2019 | |
3490 | 3490 | Carlos Gonzalez | 31 | gonzaca01 | 2017 | COL | NL | 5.281718963 | -0.15 | RF | 8 | 1 | COL | OAK | 2009 | 2018 | CLE |
3560 | 3560 | Edward Mujica | 33 | mujiced01 | 2017 | DET | AL | 0.192541086 | -0.29 | P | 0 | 1 | DET | OAK | 2017 | 2017 | |
3592 | 3592 | Luke Gregerson | 33 | gregelu01 | 2017 | HOU | AL | 1.727480095 | 0.01 | P | 2 | 1 | HOU | OAK | 2015 | 2017 | STL |
3650 | 3650 | Billy Burns | 27 | burnsbi02 | 2017 | KCR | AL | 0.058 | -0.16 | CF, RF | 0 | 1 | KCR | OAK | 2016 | 2017 | |
3727 | 3727 | Rich Hill | 37 | hillri01 | 2017 | LAD | NL | 3.837211135 | 2.07 | P | 12 | 1 | LAD | OAK | 2016 | 2019 | |
3761 | 3761 | Brett Eibner | 28 | eibnebr01 | 2017 | LAD | NL | 0.356070941 | -0.175 | LF, CF, RF | 0 | 1 | LAD | OAK | 2017 | 2017 | |
3822 | 3822 | Eric Sogard | 31 | sogarer01 | 2017 | MIL | NL | 2.980237154 | 1.49 | 2B, SS, 3B, LF | 9 | 1 | MIL | OAK | 2017 | 2018 | TOR |
3837 | 3837 | Stephen Vogt | 32 | vogtst01 | 2017 | MIL | NL | 1.285787936 | 0.245 | C, LF | 3 | 2 | MIL | OAK | 2017 | 2017 | SFG |
3986 | 3986 | Sonny Gray | 27 | grayso01 | 2017 | NYY | AL | 1.843575861 | 0.775 | P | 4 | 2 | NYY | OAK | 2017 | 2018 | CIN |
4157 | 4157 | Josh Lindblom | 30 | lindbjo01 | 2017 | PIT | NL | 0.199617073 | 0.005 | P | 0 | 1 | PIT | OAK | 2017 | 2017 | |
4233 | 4233 | Danny Valencia | 32 | valenda01 | 2017 | SEA | AL | 4.7238964 | 0.295 | 1B, RF, 3B | 7 | 1 | SEA | OAK | 2017 | 2017 | BAL |
4242 | 4242 | Yonder Alonso | 30 | alonsyo01 | 2017 | SEA | AL | 1.41716892 | 0.49 | 1B | 3 | 2 | SEA | OAK | 2017 | 2017 | CLE |
4266 | 4266 | Cody Martin | 27 | martico01 | 2017 | SEA | AL | 0.033144928 | -0.06 | P | 0 | 1 | SEA | OAK | 2016 | 2017 | |
4273 | 4273 | Dillon Overton | 25 | overtdi01 | 2017 | SEA | AL | 0.34180707 | -0.19 | P | 0 | 1 | SEA | OAK | 2017 | 2017 | SDP |
4275 | 4275 | Evan Scribner | 31 | scribev01 | 2017 | SEA | AL | 0.177956697 | -0.285 | P | 0 | 1 | SEA | OAK | 2016 | 2017 | |
4430 | 4430 | Trevor Plouffe | 31 | plouftr01 | 2017 | TBR | AL | 1.080039203 | -0.52 | 3B, 1B, 2B | 0 | 2 | TBD | OAK | 2017 | 2017 | PHI |
4453 | 4453 | A.J. Griffin | 29 | griffaj01 | 2017 | TEX | AL | 2.039374304 | 0.04 | P | 3 | 1 | TEX | OAK | 2016 | 2017 | |
4483 | 4483 | Josh Donaldson | 31 | donaljo02 | 2017 | TOR | AL | 4.692985318 | 5.045 | 3B, SS | 22 | 1 | TOR | OAK | 2015 | 2018 | CLE |
4527 | 4527 | Cesar Valdez | 32 | valdece01 | 2017 | TOR | AL | 0.458504096 | -0.13 | P | 0 | 2 | TOR | OAK | 2017 | 2017 | |
4546 | 4546 | Gio Gonzalez | 31 | gonzagi01 | 2017 | WSN | NL | 5.633380344 | 4.935 | P | 23 | 1 | WSN | OAK | 2012 | 2018 | MIL |
4556 | 4556 | Sean Doolittle | 30 | doolise01 | 2017 | WSN | NL | 1.283566338 | 1.04 | P | 5 | 2 | WSN | OAK | 2017 | 2019 | |
4559 | 4559 | Ryan Madson | 36 | madsory01 | 2017 | WSN | NL | 0.694855134 | 0.95 | P | 4 | 2 | WSN | OAK | 2017 | 2018 | LAD |
4604 | 4604 | Brad Ziegler | 36 | zieglbr01 | 2016 | ARI | NL | 1.577196923 | 0.925 | P | 5 | 1 | ARI | OAK | 2011 | 2016 | BOS |
4801 | 4801 | Jon Lester | 32 | lestejo01 | 2016 | CHC | NL | 5.663225806 | 4.83 | P | 22 | 1 | CHC | OAK | 2015 | 2019 | |
4809 | 4809 | Jason Hammel | 33 | hammeja01 | 2016 | CHC | NL | 4.632352941 | 1.725 | P | 11 | 1 | CHC | OAK | 2015 | 2016 | KCR |
4816 | 4816 | Chris Coghlan | 31 | coghlch01 | 2016 | CHC | NL | 1.250884583 | 0.905 | LF, 2B, 3B, RF, 1B | 4 | 2 | CHC | OAK | 2016 | 2016 | TOR |
4855 | 4855 | Brett Lawrie | 26 | lawribr01 | 2016 | CHW | AL | 3.645768538 | 1.14 | 2B | 8 | 1 | CHW | OAK | 2016 | 2016 | |
4959 | 4959 | Dan Otero | 31 | oteroda01 | 2016 | CLE | AL | 2.025798816 | 2.108012422 | P | 9 | 1 | CLE | OAK | 2016 | 2019 | |
4978 | 4978 | Coco Crisp | 36 | crispco01 | 2016 | CLE | AL | 0.605546493 | 0.11068323 | LF, CF | 1 | 2 | CLE | OAK | 2016 | 2016 | |
4999 | 4999 | Carlos Gonzalez | 30 | gonzaca01 | 2016 | COL | NL | 6.213934565 | 2.48 | RF | 15 | 1 | COL | OAK | 2009 | 2018 | CLE |
5102 | 5102 | Luke Gregerson | 32 | gregelu01 | 2016 | HOU | AL | 2.240949921 | 0.795 | P | 5 | 1 | HOU | OAK | 2015 | 2017 | STL |
5166 | 5166 | Billy Burns | 26 | burnsbi02 | 2016 | KCR | AL | 0.384679158 | -0.37 | CF, LF, RF | 0 | 2 | KCR | OAK | 2016 | 2017 | |
5214 | 5214 | Craig Gentry | 32 | gentrcr01 | 2016 | LAA | AL | 0.375747508 | -0.305 | LF, CF | 0 | 1 | ANA | OAK | 2016 | 2016 | BAL |
5241 | 5241 | Rich Hill | 36 | hillri01 | 2016 | LAD | NL | 0.959106755 | 1.125 | P | 5 | 2 | LAD | OAK | 2016 | 2019 | |
5250 | 5250 | Josh Reddick | 29 | reddijo01 | 2016 | LAD | NL | 1.656859391 | -0.025 | RF | 2 | 2 | LAD | OAK | 2016 | 2016 | HOU |
5394 | 5394 | Fernando Abad | 30 | abadfe01 | 2016 | MIN | AL | 1.210686842 | 0.765 | P | 4 | 1 | MIN | OAK | 2016 | 2016 | BOS |
5397 | 5397 | Kurt Suzuki | 32 | suzukku01 | 2016 | MIN | AL | 3.479813415 | 0.15 | C | 4 | 1 | MIN | OAK | 2014 | 2016 | ATL |
5414 | 5414 | Tommy Milone | 29 | milonto01 | 2016 | MIN | AL | 1.914406113 | -0.28 | P | 1 | 1 | MIN | OAK | 2014 | 2016 | MIL |
5436 | 5436 | Bartolo Colon | 43 | colonba01 | 2016 | NYM | NL | 5.329546675 | 2.49 | P | 15 | 1 | NYM | OAK | 2014 | 2016 | ATL |
5508 | 5508 | Billy Butler | 30 | butlebi03 | 2016 | NYY | AL | 0.307335652 | 0.085 | 1B | 1 | 2 | NYY | OAK | 2016 | 2016 | |
5521 | 5521 | Ike Davis | 29 | davisik02 | 2016 | NYY | AL | 0.144063587 | -0.125 | 1B | 0 | 1 | NYY | OAK | 2016 | 2016 | |
5623 | 5623 | Patrick Schuster | 25 | schuspa01 | 2016 | PHI | NL | 0.052063877 | -0.475 | P | 0 | 2 | PHI | OAK | 2016 | 2016 | |
5686 | 5686 | Drew Pomeranz | 27 | pomerdr01 | 2016 | SDP | NL | 2.911490391 | 2.88 | P | 13 | 1 | SDP | OAK | 2016 | 2016 | BOS |
5694 | 5694 | Derek Norris | 27 | norride01 | 2016 | SDP | NL | 4.667720963 | 0.495 | C, 1B | 8 | 1 | SDP | OAK | 2015 | 2016 | TBD |
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 );