mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
1,142 rows where prev_franch = "ANA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
172 | 172 | Ryan Brasier | 31 | brasiry01 | 2019 | BOS | AL | 1.826698791 | 0.193584906 | P | 3 | 1 | BOS | ANA | 2018 | 2019 | |
243 | 243 | Jonathan Lucroy | 33 | lucrojo01 | 2019 | CHC | NL | 0.546025105 | -0.152830189 | C, 1B | 0 | 2 | CHC | ANA | 2019 | 2019 | |
288 | 288 | Odrisamer Despaigne | 32 | despaod01 | 2019 | CHW | AL | 0.392053345 | -0.199936709 | P | 0 | 1 | CHW | ANA | 2019 | 2019 | |
411 | 411 | Jairo Diaz | 28 | diazja01 | 2019 | COL | NL | 1.845291336 | 0.850754717 | P | 5 | 1 | COL | ANA | 2015 | 2019 | |
724 | 724 | Cesar Puello | 28 | puellce01 | 2019 | MIA | NL | 0.99928952 | 0.224150943 | CF, LF, RF | 2 | 2 | FLA | ANA | 2019 | 2019 | |
793 | 793 | Deolis Guerra | 30 | guerrde01 | 2019 | MIL | NL | 0.011451716 | -0.13245283 | P | 0 | 1 | MIL | ANA | 2019 | 2019 | |
831 | 831 | Blake Parker | 34 | parkebl01 | 2019 | MIN | AL | 1.287406119 | 0.045849057 | P | 2 | 1 | MIN | ANA | 2019 | 2019 | PHI |
970 | 970 | Yusmeiro Petit | 34 | petityu01 | 2019 | OAK | AL | 2.876138151 | 1.762641509 | P | 9 | 1 | OAK | ANA | 2018 | 2019 | |
988 | 988 | Dustin Garneau | 31 | garnedu01 | 2019 | OAK | AL | 0.179537309 | 0.208867925 | C, 1B | 1 | 2 | OAK | ANA | 2019 | 2019 | |
1020 | 1020 | Jose Alvarez | 30 | alvarjo02 | 2019 | PHI | NL | 1.890309773 | 0.555283019 | P | 5 | 1 | PHI | ANA | 2019 | 2019 | |
1084 | 1084 | Chris Stratton | 28 | stratch01 | 2019 | PIT | NL | 1.037882715 | 0.387169811 | P | 3 | 2 | PIT | ANA | 2019 | 2019 | |
1120 | 1120 | Kirby Yates | 32 | yateski01 | 2019 | SDP | NL | 2.827388552 | 3.10754717 | P | 13 | 1 | SDP | ANA | 2017 | 2019 | |
1157 | 1157 | Garrett Richards | 31 | richaga01 | 2019 | SDP | NL | 0.14993879 | -0.112075472 | P | 0 | 1 | SDP | ANA | 2019 | 2019 | |
1277 | 1277 | Williams Jerez | 27 | jerezwi01 | 2019 | SFG | NL | 0.168026612 | 0.030566038 | P | 0 | 1 | SFG | ANA | 2019 | 2019 | PIT |
1334 | 1334 | Joe Hudson | 28 | hudsojo03 | 2019 | STL | NL | 0.010113339 | -0.015283019 | 0 | 1 | STL | ANA | 2019 | 2019 | ||
1335 | 1335 | Adalberto Mejia | 26 | mejiaad01 | 2019 | STL | NL | 0.0530211 | -0.030566038 | P | 0 | 3 | STL | ANA | 2019 | 2019 | |
1474 | 1474 | Matt Shoemaker | 32 | shoemma01 | 2019 | TOR | AL | 0.840548798 | 0.922075472 | P | 4 | 1 | TOR | ANA | 2019 | 2019 | |
1597 | 1597 | Fernando Salas | 33 | salasfe01 | 2018 | ARI | NL | 1.101047812 | -0.12 | P | 1 | 1 | ARI | ANA | 2018 | 2018 | PHI |
1604 | 1604 | Troy Scribner | 26 | scribtr01 | 2018 | ARI | NL | 0.099335761 | -0.05 | P | 0 | 1 | ARI | ANA | 2018 | 2018 | |
1660 | 1660 | Rene Rivera | 34 | riverre01 | 2018 | ATL | NL | 0.03916934 | -0.1 | C, 1B | 0 | 2 | ATL | ANA | 2018 | 2018 | NYM |
1669 | 1669 | Carlos Perez | 27 | perezca02 | 2018 | ATL | NL | 0.215431369 | -0.28 | C | 0 | 1 | ATL | ANA | 2018 | 2018 | TEX |
1687 | 1687 | Craig Gentry | 34 | gentrcr01 | 2018 | BAL | AL | 1.630677092 | 0.85 | LF, RF, CF | 4 | 1 | BAL | ANA | 2017 | 2018 | |
1746 | 1746 | Ryan Brasier | 30 | brasiry01 | 2018 | BOS | AL | 1.097146428 | 1.11 | P | 5 | 1 | BOS | ANA | 2018 | 2019 | |
1756 | 1756 | Ian Kinsler | 36 | kinslia01 | 2018 | BOS | AL | 1.320280166 | 0.0 | 2B | 2 | 2 | BOS | ANA | 2018 | 2018 | SDP |
1768 | 1768 | Brandon Phillips | 37 | phillbr01 | 2018 | BOS | AL | 0.249283668 | -0.185 | 2B, 3B | 0 | 1 | BOS | ANA | 2018 | 2018 | |
1919 | 1919 | Cliff Pennington | 34 | pennicl01 | 2018 | CIN | NL | 0.334634312 | -0.385 | 3B, SS, P | 0 | 1 | CIN | ANA | 2018 | 2018 | |
2008 | 2008 | Brooks Pounders | 27 | poundbr01 | 2018 | COL | NL | 0.266067873 | -0.089447853 | P | 0 | 1 | COL | ANA | 2018 | 2018 | NYM |
2092 | 2092 | Martin Maldonado | 31 | maldoma01 | 2018 | HOU | AL | 1.080215651 | 0.37 | C | 3 | 2 | HOU | ANA | 2018 | 2018 | KCR |
2149 | 2149 | Drew Butera | 34 | buterdr01 | 2018 | KCR | AL | 1.593775865 | -0.71 | C, 1B, P | 0 | 1 | KCR | ANA | 2015 | 2018 | COL |
2296 | 2296 | Rafael Ortega | 27 | ortegra01 | 2018 | MIA | NL | 1.43 | -0.437701863 | RF, LF | 1 | 1 | FLA | ANA | 2018 | 2018 | ATL |
2312 | 2312 | Javy Guerra | 32 | guerrja01 | 2018 | MIA | NL | 1.086779093 | -0.543354037 | P | 0 | 1 | FLA | ANA | 2017 | 2018 | TOR |
2360 | 2360 | Jett Bandy | 28 | bandyje01 | 2018 | MIL | NL | 0.696196112 | -0.193803681 | C | 1 | 1 | MIL | ANA | 2017 | 2018 | |
2362 | 2362 | Nick Franklin | 27 | frankni01 | 2018 | MIL | NL | 0.019611158 | -0.014907975 | 2B | 0 | 1 | MIL | ANA | 2018 | 2018 | |
2407 | 2407 | Gregorio Petit | 33 | petitgr01 | 2018 | MIN | AL | 0.633724723 | 0.065 | 2B, SS, 3B, 1B | 1 | 1 | MIN | ANA | 2018 | 2018 | |
2411 | 2411 | Juan Graterol | 29 | grateju01 | 2018 | MIN | AL | 0.075668624 | -0.02 | C | 0 | 2 | MIN | ANA | 2018 | 2018 | CIN |
2521 | 2521 | Shane Robinson | 33 | robinsh01 | 2018 | NYY | AL | 0.501200192 | -0.065 | RF, LF, CF | 0 | 1 | NYY | ANA | 2018 | 2018 | |
2542 | 2542 | Yusmeiro Petit | 33 | petityu01 | 2018 | OAK | AL | 3.025783286 | 1.14 | P | 8 | 1 | OAK | ANA | 2018 | 2019 | |
2644 | 2644 | David Freese | 35 | freesda01 | 2018 | PIT | NL | 2.672578682 | 1.378509317 | 3B, 1B | 8 | 1 | PIT | ANA | 2016 | 2018 | LAD |
2687 | 2687 | Kirby Yates | 31 | yateski01 | 2018 | SDP | NL | 2.524305852 | 1.87 | P | 9 | 1 | SDP | ANA | 2017 | 2019 | |
2852 | 2852 | Bud Norris | 33 | norribu01 | 2018 | STL | NL | 2.13687748 | 0.035 | P | 3 | 1 | STL | ANA | 2018 | 2018 | |
2882 | 2882 | C.J. Cron | 28 | croncj01 | 2018 | TBR | AL | 5.261623198 | 2.095 | 1B | 13 | 1 | TBD | ANA | 2018 | 2018 | MIN |
2950 | 2950 | Jesse Chavez | 34 | chaveje01 | 2018 | TEX | AL | 1.425712418 | 0.675 | P | 4 | 1 | TEX | ANA | 2018 | 2018 | CHC |
3033 | 3033 | Oliver Drake | 31 | drakeol01 | 2018 | TOR | AL | 0.02687733 | -0.05 | P | 0 | 4 | TOR | ANA | 2018 | 2018 | MIN |
3093 | 3093 | Trevor Gott | 25 | gotttr01 | 2018 | WSN | NL | 0.45743739 | -0.245 | P | 0 | 1 | WSN | ANA | 2016 | 2018 | SFG |
3129 | 3129 | David Hernandez | 32 | hernada01 | 2017 | ARI | NL | 0.658567623 | 0.065 | P | 1 | 2 | ARI | ANA | 2017 | 2017 | CIN |
3216 | 3216 | Craig Gentry | 33 | gentrcr01 | 2017 | BAL | AL | 1.108461287 | 0.115 | RF, LF, CF | 2 | 1 | BAL | ANA | 2017 | 2018 | |
3236 | 3236 | Johnny Giavotella | 29 | giavojo01 | 2017 | BAL | AL | 0.094740281 | -0.275 | 2B | 0 | 1 | BAL | ANA | 2017 | 2017 | |
3380 | 3380 | Geovany Soto | 34 | sotoge01 | 2017 | CHW | AL | 0.461003477 | -0.1 | C | 0 | 1 | CHW | ANA | 2017 | 2017 | |
3485 | 3485 | Tyler Chatwood | 27 | chatwty01 | 2017 | COL | NL | 4.233303642 | 1.53 | P | 11 | 1 | COL | ANA | 2012 | 2017 | CHC |
3511 | 3511 | Jairo Diaz | 26 | diazja01 | 2017 | COL | NL | 0.079294386 | -0.07 | P | 0 | 1 | COL | ANA | 2015 | 2019 | |
3542 | 3542 | Efren Navarro | 31 | navaref01 | 2017 | DET | AL | 0.653067885 | 0.25 | 1B | 2 | 1 | DET | ANA | 2017 | 2017 | CHC |
3545 | 3545 | Andrew Romine | 31 | rominan01 | 2017 | DET | AL | 3.293733681 | -0.67 | 2B, CF, 3B, 1B, LF, RF, SS, P, C | 2 | 1 | DET | ANA | 2014 | 2017 | SEA |
3598 | 3598 | Cameron Maybin | 30 | maybica01 | 2017 | HOU | AL | 0.585389298 | -0.06 | LF, CF, RF | 1 | 2 | HOU | ANA | 2017 | 2017 | FLA |
3617 | 3617 | Jason Vargas | 34 | vargaja01 | 2017 | KCR | AL | 5.016764 | 2.835 | P | 16 | 1 | KCR | ANA | 2014 | 2017 | NYM |
3636 | 3636 | Al Alburquerque | 31 | albural01 | 2017 | KCR | AL | 0.212032727 | 0.135 | P | 1 | 1 | KCR | ANA | 2017 | 2017 | CHW |
3643 | 3643 | Drew Butera | 33 | buterdr01 | 2017 | KCR | AL | 1.711 | -0.475 | C, 1B | 1 | 1 | KCR | ANA | 2015 | 2018 | COL |
3646 | 3646 | Mike Morin | 26 | morinmi01 | 2017 | KCR | AL | 0.093075399 | 0.015 | P | 0 | 2 | KCR | ANA | 2017 | 2017 | SEA |
3797 | 3797 | Javy Guerra | 31 | guerrja01 | 2017 | MIA | NL | 0.650063053 | 0.2 | P | 1 | 1 | FLA | ANA | 2017 | 2018 | TOR |
3843 | 3843 | Jett Bandy | 27 | bandyje01 | 2017 | MIL | NL | 1.873861488 | -0.475 | C | 1 | 1 | MIL | ANA | 2017 | 2018 | |
3854 | 3854 | Kirk Nieuwenhuis | 29 | nieuwki01 | 2017 | MIL | NL | 0.308987799 | -0.19 | CF, LF | 0 | 1 | MIL | ANA | 2016 | 2017 | |
3888 | 3888 | Hector Santiago | 29 | santihe01 | 2017 | MIN | AL | 2.102478443 | -0.145 | P | 3 | 1 | MIN | ANA | 2016 | 2017 | CHW |
3893 | 3893 | Buddy Boshers | 29 | boshebu01 | 2017 | MIN | AL | 0.982525652 | -0.115 | P | 1 | 1 | MIN | ANA | 2016 | 2017 | TOR |
3902 | 3902 | Drew Rucinski | 28 | rucindr01 | 2017 | MIN | AL | 0.078905535 | -0.11 | P | 0 | 1 | MIN | ANA | 2017 | 2017 | FLA |
3958 | 3958 | Adam Wilk | 29 | wilkad01 | 2017 | NYM | NL | 0.103776327 | -0.275 | P | 0 | 1 | NYM | ANA | 2017 | 2017 | MIN |
3959 | 3959 | Fernando Salas | 32 | salasfe01 | 2017 | NYM | NL | 1.389402068 | -0.475 | P | 0 | 1 | NYM | ANA | 2016 | 2017 | ANA |
3995 | 3995 | Ji-Man Choi | 26 | choiji01 | 2017 | NYY | AL | 0.164954969 | 0.125 | 1B | 1 | 1 | NYY | ANA | 2017 | 2017 | MIL |
4125 | 4125 | David Freese | 34 | freesda01 | 2017 | PIT | NL | 5.018751075 | 1.965 | 3B, 1B | 13 | 1 | PIT | ANA | 2016 | 2018 | LAD |
4169 | 4169 | Jhoulys Chacin | 29 | chacijh01 | 2017 | SDP | NL | 5.106098096 | 2.795 | P | 17 | 1 | SDP | ANA | 2017 | 2017 | MIL |
4186 | 4186 | Kirby Yates | 30 | yateski01 | 2017 | SDP | NL | 1.719479177 | 0.515 | P | 4 | 2 | SDP | ANA | 2017 | 2019 | |
4213 | 4213 | Jose Valdez | 27 | valdejo03 | 2017 | SDP | NL | 0.347499534 | -0.39 | P | 0 | 2 | SDP | ANA | 2017 | 2017 | SFG |
4219 | 4219 | Jered Weaver | 34 | weaveje02 | 2017 | SDP | NL | 1.211478769 | -1.2 | P | 0 | 1 | SDP | ANA | 2017 | 2017 | |
4264 | 4264 | Danny Espinosa | 30 | espinda01 | 2017 | SEA | AL | 0.160612478 | -0.045 | 2B, 3B, 1B, SS | 0 | 2 | SEA | ANA | 2017 | 2017 | TBD |
4326 | 4326 | Conor Gillaspie | 29 | gillaco01 | 2017 | SFG | NL | 0.867159306 | -0.545 | 3B, 1B | 0 | 1 | SFG | ANA | 2016 | 2017 | |
4421 | 4421 | Cesar Puello | 26 | puellce01 | 2017 | TBR | AL | 0.331590983 | -0.03 | LF, RF | 0 | 2 | TBD | ANA | 2017 | 2017 | ANA |
4586 | 4586 | Trevor Gott | 24 | gotttr01 | 2017 | WSN | NL | 0.062165756 | -0.285 | P | 0 | 1 | WSN | ANA | 2016 | 2018 | SFG |
4663 | 4663 | Erick Aybar | 32 | aybarer01 | 2016 | ATL | NL | 3.631167064 | -0.830124224 | SS, 3B, 2B | 3 | 1 | ATL | ANA | 2016 | 2016 | DET |
4678 | 4678 | Jason Grilli | 39 | grillja01 | 2016 | ATL | NL | 0.591858192 | -0.115714286 | P | 1 | 1 | ATL | ANA | 2015 | 2016 | TOR |
4831 | 4831 | Joe Smith | 32 | smithjo05 | 2016 | CHC | NL | 0.383389469 | 0.035 | P | 1 | 2 | CHC | ANA | 2016 | 2016 | TOR |
4862 | 4862 | Mat Latos | 28 | latosma01 | 2016 | CHW | AL | 1.670264726 | 0.165 | P | 3 | 1 | CHW | ANA | 2016 | 2016 | WSN |
4990 | 4990 | Collin Cowgill | 30 | cowgico01 | 2016 | CLE | AL | 0.132463295 | -0.216335404 | RF | 0 | 1 | CLE | ANA | 2016 | 2016 | |
5000 | 5000 | Tyler Chatwood | 26 | chatwty01 | 2016 | COL | NL | 4.568624507 | 2.78 | P | 14 | 1 | COL | ANA | 2012 | 2017 | CHC |
5063 | 5063 | Andrew Romine | 30 | rominan01 | 2016 | DET | AL | 1.843381389 | 0.402484472 | 3B, CF, 1B, SS, 2B, RF, LF, P | 4 | 1 | DET | ANA | 2014 | 2017 | SEA |
5149 | 5149 | Drew Butera | 32 | buterdr01 | 2016 | KCR | AL | 1.279058199 | 0.605 | C, 1B, P | 4 | 1 | KCR | ANA | 2015 | 2018 | COL |
5154 | 5154 | Jason Vargas | 33 | vargaja01 | 2016 | KCR | AL | 0.336205759 | 0.445 | P | 2 | 1 | KCR | ANA | 2014 | 2017 | NYM |
5163 | 5163 | Daniel Nava | 33 | navada01 | 2016 | KCR | AL | 0.115403747 | -0.16 | LF, 1B, RF | 0 | 2 | KCR | ANA | 2016 | 2016 | PHI |
5233 | 5233 | Howie Kendrick | 32 | kendrho01 | 2016 | LAD | NL | 5.387273349 | 0.555 | LF, 2B, 3B, 1B | 9 | 1 | LAD | ANA | 2015 | 2016 | PHI |
5312 | 5312 | Jo-Jo Reyes | 31 | reyesjo03 | 2016 | MIA | NL | 0.0306741 | -0.020124224 | P | 0 | 1 | FLA | ANA | 2016 | 2016 | |
5344 | 5344 | Kirk Nieuwenhuis | 28 | nieuwki01 | 2016 | MIL | NL | 3.9527121 | 0.645 | CF, RF, LF | 7 | 1 | MIL | ANA | 2016 | 2017 | |
5403 | 5403 | Buddy Boshers | 28 | boshebu01 | 2016 | MIN | AL | 0.988586763 | 0.315 | P | 2 | 1 | MIN | ANA | 2016 | 2017 | TOR |
5404 | 5404 | Hector Santiago | 28 | santihe01 | 2016 | MIN | AL | 1.73052978 | 0.16 | P | 2 | 2 | MIN | ANA | 2016 | 2017 | CHW |
5458 | 5458 | Fernando Salas | 31 | salasfe01 | 2016 | NYM | NL | 0.58507295 | 0.365 | P | 2 | 2 | NYM | ANA | 2016 | 2017 | ANA |
5495 | 5495 | Mark Teixeira | 36 | teixema01 | 2016 | NYY | AL | 4.206656731 | -0.795 | 1B | 4 | 1 | NYY | ANA | 2009 | 2016 | |
5617 | 5617 | Taylor Featherston | 26 | feathta01 | 2016 | PHI | NL | 0.286066584 | -0.185 | 2B | 0 | 1 | PHI | ANA | 2016 | 2016 | TBD |
5633 | 5633 | David Freese | 33 | freesda01 | 2016 | PIT | NL | 4.804040404 | 1.765 | 3B, 1B, 2B | 12 | 1 | PIT | ANA | 2016 | 2018 | LAD |
5640 | 5640 | Matthew Joyce | 31 | joycema01 | 2016 | PIT | NL | 2.860942761 | 1.785 | RF, LF | 9 | 1 | PIT | ANA | 2016 | 2016 | OAK |
5723 | 5723 | Alexi Amarista | 27 | amarial01 | 2016 | SDP | NL | 1.528729573 | -0.575 | 2B, SS, 3B, LF, RF, P | 1 | 1 | SDP | ANA | 2012 | 2016 | COL |
5765 | 5765 | Shawn O'Malley | 28 | omallsh01 | 2016 | SEA | AL | 2.169622702 | 0.175 | SS, RF, LF, 2B, 3B, CF | 4 | 1 | SEA | ANA | 2015 | 2016 | |
5766 | 5766 | Chris Iannetta | 33 | iannech01 | 2016 | SEA | AL | 3.160915834 | -0.205 | C | 4 | 1 | SEA | ANA | 2016 | 2016 | ARI |
5790 | 5790 | Daniel Robertson | 30 | roberda09 | 2016 | SEA | AL | 0.196388262 | -0.225 | LF, RF, CF | 0 | 1 | SEA | ANA | 2016 | 2016 | CLE |
5810 | 5810 | Conor Gillaspie | 28 | gillaco01 | 2016 | SFG | NL | 2.015595864 | 0.93 | 3B, 1B | 5 | 1 | SFG | ANA | 2016 | 2017 |
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 );