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,772 rows where next_franch = "OAK"
This data as json, copyable, CSV (advanced)
Suggested facets: age, lg_ID, stint_ID, franch_id, prev_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
305 | 305 | Tanner Roark | 32 | roarkta01 | 2019 | CIN | NL | 3.125062659 | 1.874716981 | P | 10 | 1 | CIN | WSN | 2019 | 2019 | OAK |
557 | 557 | Homer Bailey | 33 | baileho02 | 2019 | KCR | AL | 2.606832458 | 1.090188679 | P | 6 | 1 | KCR | CIN | 2019 | 2019 | OAK |
565 | 565 | Jake Diekman | 32 | diekmja01 | 2019 | KCR | AL | 1.561827726 | 0.509433962 | P | 3 | 1 | KCR | ARI | 2019 | 2019 | OAK |
617 | 617 | Dustin Garneau | 31 | garnedu01 | 2019 | LAA | AL | 0.775983031 | 0.555283019 | C, 1B | 3 | 1 | ANA | CHW | 2019 | 2019 | OAK |
1711 | 1711 | Corban Joseph | 29 | josepco01 | 2018 | BAL | AL | 0.183330561 | -0.085 | 1B, 2B | 0 | 1 | BAL | NYY | 2018 | 2018 | OAK |
2020 | 2020 | Mike Fiers | 33 | fiersmi01 | 2018 | DET | AL | 3.342287015 | 2.07 | P | 11 | 1 | DET | HOU | 2018 | 2018 | OAK |
2266 | 2266 | Wilmer Font | 28 | fontwi01 | 2018 | LAD | NL | 0.288835068 | -0.606257669 | P | 0 | 1 | LAD | TEX | 2017 | 2018 | OAK |
2348 | 2348 | Joakim Soria | 34 | soriajo01 | 2018 | MIL | NL | 0.799359384 | 0.168957055 | P | 2 | 2 | MIL | CHW | 2018 | 2018 | OAK |
2378 | 2378 | Robbie Grossman | 28 | grossro01 | 2018 | MIN | AL | 4.398238748 | 1.125 | RF, LF | 10 | 1 | MIN | HOU | 2016 | 2018 | OAK |
2387 | 2387 | Fernando Rodney | 41 | rodnefe01 | 2018 | MIN | AL | 1.763617976 | 0.655 | P | 5 | 1 | MIN | ARI | 2018 | 2018 | OAK |
2438 | 2438 | Jeurys Familia | 28 | familje01 | 2018 | NYM | NL | 1.655110168 | 1.115 | P | 6 | 1 | NYM | 2012 | 2018 | OAK | |
2672 | 2672 | Tanner Anderson | 25 | anderta01 | 2018 | PIT | NL | 0.29904094 | -0.216335404 | P | 0 | 1 | PIT | 2018 | 2018 | OAK | |
2749 | 2749 | Chris Herrmann | 30 | herrmch01 | 2018 | SEA | AL | 0.83198681 | 0.55 | C, 1B | 3 | 1 | SEA | ARI | 2018 | 2018 | OAK |
2803 | 2803 | Nick Hundley | 34 | hundlni01 | 2018 | SFG | NL | 3.050525953 | -0.255 | C | 4 | 1 | SFG | COL | 2017 | 2018 | OAK |
2935 | 2935 | Jurickson Profar | 25 | profaju01 | 2018 | TEX | AL | 5.607421875 | 2.425 | SS, 3B, 1B, 2B, LF | 14 | 1 | TEX | 2012 | 2018 | OAK | |
2954 | 2954 | Cory Gearrin | 32 | gearrco01 | 2018 | TEX | AL | 0.680619821 | 0.59 | P | 3 | 2 | TEX | SFG | 2018 | 2018 | OAK |
2991 | 2991 | Kendrys Morales | 35 | moralke01 | 2018 | TOR | AL | 4.513879709 | 0.525 | 1B, 3B, P | 8 | 1 | TOR | KCR | 2017 | 2018 | OAK |
2992 | 2992 | Marco Estrada | 34 | estrama01 | 2018 | TOR | AL | 4.104091449 | 0.51 | P | 8 | 1 | TOR | MIL | 2015 | 2018 | OAK |
3027 | 3027 | Carlos Ramirez | 27 | ramirca01 | 2018 | TOR | AL | 0.042286999 | 0.015 | P | 0 | 1 | TOR | 2017 | 2018 | OAK | |
3069 | 3069 | Shawn Kelley | 34 | kellesh01 | 2018 | WSN | NL | 0.802621429 | 0.315 | P | 2 | 1 | WSN | SDP | 2016 | 2018 | OAK |
3493 | 3493 | Jonathan Lucroy | 31 | lucrojo01 | 2017 | COL | NL | 1.730900409 | 0.765 | C, 1B | 5 | 2 | COL | TEX | 2017 | 2017 | OAK |
3504 | 3504 | Dustin Garneau | 29 | garnedu01 | 2017 | COL | NL | 0.731923602 | 0.04 | C | 1 | 1 | COL | 2015 | 2017 | OAK | |
3633 | 3633 | Ryan Buchter | 30 | buchtry01 | 2017 | KCR | AL | 0.677310175 | 0.34 | P | 2 | 2 | KCR | SDP | 2017 | 2017 | OAK |
3660 | 3660 | Trevor Cahill | 29 | cahiltr01 | 2017 | KCR | AL | 0.559796263 | -0.745 | P | 0 | 2 | KCR | SDP | 2017 | 2017 | OAK |
3666 | 3666 | Yusmeiro Petit | 32 | petityu01 | 2017 | LAA | AL | 2.855350326 | 1.875 | P | 10 | 1 | ANA | WSN | 2017 | 2017 | OAK |
3745 | 3745 | Chris Hatcher | 32 | hatchch02 | 2017 | LAD | NL | 0.83849352 | -0.005 | P | 1 | 1 | LAD | FLA | 2015 | 2017 | OAK |
3764 | 3764 | Wilmer Font | 27 | fontwi01 | 2017 | LAD | NL | 0.077781307 | -0.265 | P | 0 | 1 | LAD | TEX | 2017 | 2018 | OAK |
3767 | 3767 | Trayce Thompson | 26 | thomptr01 | 2017 | LAD | NL | 0.543997271 | -0.41 | CF, RF, LF | 0 | 1 | LAD | CHW | 2016 | 2017 | OAK |
3851 | 3851 | Wei-Chung Wang | 25 | wangwe01 | 2017 | MIL | NL | 0.032293089 | -0.03 | P | 0 | 1 | MIL | 2014 | 2017 | OAK | |
3874 | 3874 | Robbie Grossman | 27 | grossro01 | 2017 | MIN | AL | 4.240500241 | 0.67 | RF, LF | 8 | 1 | MIN | HOU | 2016 | 2018 | OAK |
3942 | 3942 | Jeurys Familia | 27 | familje01 | 2017 | NYM | NL | 0.899731172 | 0.12 | P | 2 | 1 | NYM | 2012 | 2018 | OAK | |
4004 | 4004 | Dustin Fowler | 22 | fowledu01 | 2017 | NYY | AL | 0.0 | 0.0 | RF | 0 | 1 | NYY | 2017 | 2017 | OAK | |
4237 | 4237 | Emilio Pagan | 26 | paganem01 | 2017 | SEA | AL | 1.534235314 | 0.73 | P | 4 | 1 | SEA | 2017 | 2017 | OAK | |
4270 | 4270 | Boog Powell | 24 | powelbo02 | 2017 | SEA | AL | 0.40625509 | -0.085 | CF, LF, RF | 0 | 1 | SEA | 2017 | 2017 | OAK | |
4299 | 4299 | Nick Hundley | 33 | hundlni01 | 2017 | SFG | NL | 3.020106548 | 0.17 | C | 4 | 1 | SFG | COL | 2017 | 2018 | OAK |
4345 | 4345 | Stephen Piscotty | 26 | piscost01 | 2017 | STL | NL | 3.949397181 | 0.52 | RF | 7 | 1 | STL | 2015 | 2017 | OAK | |
4363 | 4363 | Josh Lucas | 26 | lucasjo02 | 2017 | STL | NL | 0.16036553 | -0.025 | P | 0 | 1 | STL | 2017 | 2017 | OAK | |
4460 | 4460 | Jurickson Profar | 24 | profaju01 | 2017 | TEX | AL | 0.666229078 | -0.055 | LF, SS, 3B, 1B, 2B | 1 | 1 | TEX | 2012 | 2018 | OAK | |
4488 | 4488 | Marco Estrada | 33 | estrama01 | 2017 | TOR | AL | 4.977122692 | 2.245 | P | 14 | 1 | TOR | MIL | 2015 | 2018 | OAK |
4493 | 4493 | Kendrys Morales | 34 | moralke01 | 2017 | TOR | AL | 5.75269168 | -0.235 | 1B | 8 | 1 | TOR | KCR | 2017 | 2018 | OAK |
4506 | 4506 | Brett Anderson | 29 | anderbr04 | 2017 | TOR | AL | 0.891957472 | 0.46 | P | 3 | 2 | TOR | CHC | 2017 | 2017 | OAK |
4510 | 4510 | Carlos Ramirez | 26 | ramirca01 | 2017 | TOR | AL | 0.538495601 | 0.32 | P | 2 | 1 | TOR | 2017 | 2018 | OAK | |
4570 | 4570 | Blake Treinen | 29 | treinbl01 | 2017 | WSN | NL | 1.196057227 | 0.09 | P | 2 | 1 | WSN | 2014 | 2017 | OAK | |
4572 | 4572 | Edwin Jackson | 33 | jacksed01 | 2017 | WSN | NL | 1.98990052 | -0.185 | P | 2 | 2 | WSN | BAL | 2017 | 2017 | OAK |
4591 | 4591 | Shawn Kelley | 33 | kellesh01 | 2017 | WSN | NL | 0.833349109 | -0.875 | P | 0 | 1 | WSN | SDP | 2016 | 2018 | OAK |
4786 | 4786 | Ryan LaMarre | 27 | lamarry01 | 2016 | BOS | AL | 0.055299539 | -0.09 | LF, P, RF | 0 | 1 | BOS | CIN | 2016 | 2016 | OAK |
4913 | 4913 | Josh Smith | 28 | smithjo07 | 2016 | CIN | NL | 1.647015207 | 0.03 | P | 3 | 1 | CIN | 2015 | 2016 | OAK | |
4958 | 4958 | Rajai Davis | 35 | davisra01 | 2016 | CLE | AL | 4.683523654 | 1.157142857 | CF, LF, RF | 10 | 1 | CLE | DET | 2016 | 2016 | OAK |
4984 | 4984 | Ross Detwiler | 30 | detwiro01 | 2016 | CLE | AL | 0.130932802 | -0.055341615 | P | 0 | 1 | CLE | ATL | 2016 | 2016 | OAK |
5021 | 5021 | Dustin Garneau | 28 | garnedu01 | 2016 | COL | NL | 0.737413121 | -0.05 | C | 1 | 1 | COL | 2015 | 2017 | OAK | |
5150 | 5150 | Brett Eibner | 27 | eibnebr01 | 2016 | KCR | AL | 0.81744321 | 0.47 | CF, RF, LF | 3 | 1 | KCR | 2016 | 2016 | OAK | |
5239 | 5239 | Trayce Thompson | 25 | thomptr01 | 2016 | LAD | NL | 2.599384194 | 0.795 | CF, RF, LF | 6 | 1 | LAD | CHW | 2016 | 2017 | OAK |
5274 | 5274 | Chris Hatcher | 31 | hatchch02 | 2016 | LAD | NL | 1.244798128 | -0.49 | P | 0 | 1 | LAD | FLA | 2015 | 2017 | OAK |
5392 | 5392 | Robbie Grossman | 26 | grossro01 | 2016 | MIN | AL | 3.629081551 | 0.5 | LF, CF | 6 | 1 | MIN | HOU | 2016 | 2018 | OAK |
5398 | 5398 | Trevor Plouffe | 30 | plouftr01 | 2016 | MIN | AL | 3.209264919 | 0.1 | 3B, 1B | 4 | 1 | MIN | 2010 | 2016 | OAK | |
5439 | 5439 | Jeurys Familia | 26 | familje01 | 2016 | NYM | NL | 3.06043115 | 1.945 | P | 10 | 1 | NYM | 2012 | 2018 | OAK | |
5640 | 5640 | Matthew Joyce | 31 | joycema01 | 2016 | PIT | NL | 2.860942761 | 1.785 | RF, LF | 9 | 1 | PIT | ANA | 2016 | 2016 | OAK |
5690 | 5690 | Adam Rosales | 33 | rosalad01 | 2016 | SDP | NL | 2.527499561 | 1.745 | 3B, 2B, SS, LF, 1B, RF | 9 | 1 | SDP | TEX | 2016 | 2016 | OAK |
5811 | 5811 | Santiago Casilla | 35 | garcija01 | 2016 | SFG | NL | 2.627178157 | 0.42 | P | 5 | 1 | SFG | OAK | 2010 | 2016 | OAK |
5845 | 5845 | Stephen Piscotty | 25 | piscost01 | 2016 | STL | NL | 6.383245718 | 2.44 | RF, CF, 1B | 16 | 1 | STL | 2015 | 2017 | OAK | |
5873 | 5873 | Dean Kiekhefer | 27 | kiekhde01 | 2016 | STL | NL | 0.452557303 | 0.005 | P | 1 | 1 | STL | 2016 | 2016 | OAK | |
5927 | 5927 | Jaff Decker | 26 | deckeja01 | 2016 | TBR | AL | 0.549078226 | -0.655 | RF, LF, CF | 0 | 1 | TBD | PIT | 2016 | 2016 | OAK |
5949 | 5949 | Jurickson Profar | 23 | profaju01 | 2016 | TEX | AL | 2.934893687 | 0.12 | 3B, 2B, 1B, LF, SS | 6 | 1 | TEX | 2012 | 2018 | OAK | |
5987 | 5987 | Marco Estrada | 32 | estrama01 | 2016 | TOR | AL | 4.84097686 | 3.08 | P | 16 | 1 | TOR | MIL | 2015 | 2018 | OAK |
6043 | 6043 | Shawn Kelley | 32 | kellesh01 | 2016 | WSN | NL | 1.973621895 | 1.285 | P | 7 | 1 | WSN | SDP | 2016 | 2018 | OAK |
6044 | 6044 | Blake Treinen | 28 | treinbl01 | 2016 | WSN | NL | 2.279873569 | 1.25 | P | 7 | 1 | WSN | 2014 | 2017 | OAK | |
6152 | 6152 | Ryan Lavarnway | 27 | lavarry01 | 2015 | ATL | NL | 0.752718344 | 0.105 | C, 1B | 1 | 2 | ATL | BAL | 2015 | 2015 | OAK |
6159 | 6159 | Cody Martin | 25 | martico01 | 2015 | ATL | NL | 0.789147671 | -0.17 | P | 1 | 1 | ATL | 2015 | 2015 | OAK | |
6247 | 6247 | Rich Hill | 35 | hillri01 | 2015 | BOS | AL | 0.810089095 | 1.42 | P | 5 | 1 | BOS | NYY | 2015 | 2015 | OAK |
6274 | 6274 | Edward Mujica | 31 | mujiced01 | 2015 | BOS | AL | 0.422596727 | -0.11 | P | 0 | 1 | BOS | STL | 2014 | 2015 | OAK |
6289 | 6289 | Chris Coghlan | 30 | coghlch01 | 2015 | CHC | NL | 5.010132234 | 2.51 | LF, RF, 2B, 1B, 3B | 15 | 1 | CHC | FLA | 2014 | 2015 | OAK |
6327 | 6327 | Arismendy Alcantara | 23 | alcanar01 | 2015 | CHC | NL | 0.318736047 | -0.21 | 2B, 3B | 0 | 1 | CHC | 2014 | 2015 | OAK | |
6331 | 6331 | Brian Schlitter | 29 | schlibr01 | 2015 | CHC | NL | 0.293781201 | -0.325 | P | 0 | 1 | CHC | 2010 | 2015 | OAK | |
6359 | 6359 | Frankie Montas | 22 | montafr02 | 2015 | CHW | AL | 0.30068243 | 0.105 | P | 1 | 1 | CHW | 2015 | 2015 | OAK | |
6414 | 6414 | Josh Smith | 27 | smithjo07 | 2015 | CIN | NL | 0.839391471 | -0.375 | P | 0 | 1 | CIN | 2015 | 2016 | OAK | |
6482 | 6482 | John Axford | 32 | axforjo01 | 2015 | COL | NL | 2.21031893 | 0.765 | P | 5 | 1 | COL | PIT | 2015 | 2015 | OAK |
6513 | 6513 | Simon Castro | 27 | castrsi01 | 2015 | COL | NL | 0.238035901 | 0.035 | P | 0 | 1 | COL | CHW | 2015 | 2015 | OAK |
6518 | 6518 | Matt McBride | 30 | mcbrima02 | 2015 | COL | NL | 0.43373913 | -0.54 | 1B, LF, RF | 0 | 1 | COL | 2012 | 2015 | OAK | |
6519 | 6519 | Dustin Garneau | 27 | garnedu01 | 2015 | COL | NL | 0.766608696 | -0.57 | C | 0 | 1 | COL | 2015 | 2017 | OAK | |
6585 | 6585 | Jed Lowrie | 31 | lowrije01 | 2015 | HOU | AL | 2.522990407 | 1.1 | 3B, SS | 6 | 1 | HOU | OAK | 2015 | 2015 | OAK |
6630 | 6630 | Ryan Madson | 34 | madsory01 | 2015 | KCR | AL | 2.178487877 | 1.315 | P | 8 | 1 | KCR | PHI | 2015 | 2015 | OAK |
6649 | 6649 | Aaron Brooks | 25 | brookaa01 | 2015 | KCR | AL | 0.064806276 | 0.04 | P | 0 | 1 | KCR | 2014 | 2015 | OAK | |
6743 | 6743 | Chris Hatcher | 30 | hatchch02 | 2015 | LAD | NL | 1.315944818 | 0.125 | P | 2 | 1 | LAD | FLA | 2015 | 2017 | OAK |
6755 | 6755 | Danny Coulombe | 25 | couloda01 | 2015 | LAD | NL | 0.161894273 | -0.105 | P | 0 | 1 | LAD | 2014 | 2015 | OAK | |
6762 | 6762 | Eric Surkamp | 27 | surkaer01 | 2015 | LAD | NL | 0.099327614 | -0.25 | P | 0 | 1 | LAD | CHW | 2015 | 2015 | OAK |
6826 | 6826 | Khris Davis | 27 | daviskh01 | 2015 | MIL | NL | 4.468569427 | 1.05 | LF | 9 | 1 | MIL | 2013 | 2015 | OAK | |
6868 | 6868 | Trevor Plouffe | 29 | plouftr01 | 2015 | MIN | AL | 6.112389528 | 2.69 | 3B, 1B | 18 | 1 | MIN | 2010 | 2016 | OAK | |
6920 | 6920 | Jeurys Familia | 25 | familje01 | 2015 | NYM | NL | 2.970071239 | 2.21 | P | 11 | 1 | NYM | 2012 | 2018 | OAK | |
7162 | 7162 | Andrew Lambo | 26 | lamboan01 | 2015 | PIT | NL | 0.263414634 | -0.43 | RF, LF | 0 | 1 | PIT | 2013 | 2015 | OAK | |
7171 | 7171 | Yonder Alonso | 28 | alonsyo01 | 2015 | SDP | NL | 4.089091547 | 1.365 | 1B, 3B | 10 | 1 | SDP | CIN | 2012 | 2015 | OAK |
7207 | 7207 | Marc Rzepczynski | 29 | rzepcma01 | 2015 | SDP | NL | 0.509521895 | -0.39 | P | 0 | 2 | SDP | CLE | 2015 | 2015 | OAK |
7277 | 7277 | Santiago Casilla | 34 | garcija01 | 2015 | SFG | NL | 2.274989889 | 0.65 | P | 5 | 1 | SFG | OAK | 2010 | 2016 | OAK |
7323 | 7323 | Stephen Piscotty | 24 | piscost01 | 2015 | STL | NL | 2.566194262 | 1.16 | LF, RF, 1B, CF | 7 | 1 | STL | 2015 | 2017 | OAK | |
7458 | 7458 | Jake Smolinski | 26 | smolija01 | 2015 | TEX | AL | 0.696188159 | -0.425 | LF, RF | 0 | 1 | TEX | 2014 | 2015 | OAK | |
7468 | 7468 | Marco Estrada | 31 | estrama01 | 2015 | TOR | AL | 5.030056545 | 2.94 | P | 15 | 1 | TOR | MIL | 2015 | 2018 | OAK |
7478 | 7478 | Liam Hendriks | 26 | hendrli01 | 2015 | TOR | AL | 1.806984675 | 1.305 | P | 6 | 1 | TOR | KCR | 2015 | 2015 | OAK |
7485 | 7485 | Danny Valencia | 30 | valenda01 | 2015 | TOR | AL | 1.616561946 | 0.67 | 3B, LF, 1B, RF, 2B | 4 | 1 | TOR | KCR | 2014 | 2015 | OAK |
7495 | 7495 | Felix Doubront | 27 | doubrfe01 | 2015 | TOR | AL | 0.595304286 | 0.085 | P | 1 | 1 | TOR | CHC | 2015 | 2015 | OAK |
7535 | 7535 | Blake Treinen | 27 | treinbl01 | 2015 | WSN | NL | 2.140293375 | 0.255 | P | 4 | 1 | WSN | 2014 | 2017 | OAK | |
7593 | 7593 | Cody Ross | 33 | rossco01 | 2014 | ARI | NL | 2.205208333 | -0.795 | LF, RF | 1 | 1 | ARI | BOS | 2013 | 2014 | OAK |
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 );