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,967 rows where next_franch = "ANA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
547 | 547 | Max Stassi | 28 | stassma01 | 2019 | HOU | AL | 0.90871303 | -0.448301887 | C, 1B, P | 0 | 1 | HOU | 2013 | 2019 | ANA | |
850 | 850 | Adalberto Mejia | 26 | mejiaad01 | 2019 | MIN | AL | 0.454651887 | -0.438113208 | P | 0 | 1 | MIN | 2016 | 2019 | ANA | |
1391 | 1391 | Anthony Bemboom | 29 | bemboan01 | 2019 | TBR | AL | 0.04716214 | 0.050943396 | C | 0 | 1 | TBD | 2019 | 2019 | ANA | |
1398 | 1398 | Kean Wong | 24 | wongke01 | 2019 | TBR | AL | 0.132053993 | -0.122264151 | 2B, RF | 0 | 1 | TBD | 2019 | 2019 | ANA | |
1640 | 1640 | Sam Freeman | 31 | freemsa01 | 2018 | ATL | NL | 1.458445921 | 0.095 | P | 2 | 1 | ATL | MIL | 2017 | 2018 | ANA |
1647 | 1647 | Peter Bourjos | 31 | bourjpe01 | 2018 | ATL | NL | 0.460239743 | 0.025 | LF, CF, RF | 1 | 1 | ATL | TBD | 2018 | 2018 | ANA |
1797 | 1797 | Tommy La Stella | 29 | lasteto01 | 2018 | CHC | NL | 1.843708609 | 0.074539877 | 3B, 2B, P | 3 | 1 | CHC | ATL | 2015 | 2018 | ANA |
1840 | 1840 | Kevan Smith | 30 | smithke04 | 2018 | CHW | AL | 1.792727273 | 0.495 | C | 4 | 1 | CHW | 2016 | 2018 | ANA | |
1855 | 1855 | Dustin Garneau | 30 | garnedu01 | 2018 | CHW | AL | 0.028760331 | 0.035 | C | 0 | 1 | CHW | OAK | 2018 | 2018 | ANA |
1881 | 1881 | Matt Harvey | 29 | harvema01 | 2018 | CIN | NL | 3.607600524 | 1.195 | P | 8 | 2 | CIN | NYM | 2018 | 2018 | ANA |
1944 | 1944 | Cody Allen | 29 | allenco01 | 2018 | CLE | AL | 2.622864583 | -0.055 | P | 3 | 1 | CLE | 2012 | 2018 | ANA | |
1968 | 1968 | Oliver Drake | 31 | drakeol01 | 2018 | CLE | AL | 0.073164484 | -0.085 | P | 0 | 2 | CLE | MIL | 2018 | 2018 | ANA |
2077 | 2077 | Max Stassi | 27 | stassma01 | 2018 | HOU | AL | 2.368893972 | 1.86 | C | 9 | 1 | HOU | 2013 | 2019 | ANA | |
2129 | 2129 | Brian Goodwin | 27 | goodwbr01 | 2018 | KCR | AL | 0.969707002 | 0.42 | CF, LF, RF | 2 | 2 | KCR | WSN | 2018 | 2018 | ANA |
2307 | 2307 | Odrisamer Despaigne | 31 | despaod01 | 2018 | MIA | NL | 0.641250449 | -0.22136646 | P | 0 | 1 | FLA | BAL | 2016 | 2018 | ANA |
2310 | 2310 | Dillon Peters | 25 | peterdi01 | 2018 | MIA | NL | 0.733423536 | -0.347142857 | P | 0 | 1 | FLA | 2017 | 2018 | ANA | |
2314 | 2314 | Junichi Tazawa | 32 | tazawju01 | 2018 | MIA | NL | 0.505809335 | -0.684223602 | P | 0 | 1 | FLA | BOS | 2017 | 2018 | ANA |
2392 | 2392 | Adalberto Mejia | 25 | mejiaad01 | 2018 | MIN | AL | 0.589131168 | 0.645 | P | 3 | 1 | MIN | 2016 | 2019 | ANA | |
2410 | 2410 | John Curtiss | 25 | curtijo02 | 2018 | MIN | AL | 0.136862836 | 0.035 | P | 0 | 1 | MIN | 2017 | 2018 | ANA | |
2473 | 2473 | Hansel Robles | 27 | robleha01 | 2018 | NYM | NL | 0.612597443 | -0.385 | P | 0 | 1 | NYM | 2015 | 2018 | ANA | |
2541 | 2541 | Trevor Cahill | 30 | cahiltr01 | 2018 | OAK | AL | 3.014645074 | 1.65 | P | 9 | 1 | OAK | KCR | 2018 | 2018 | ANA |
2547 | 2547 | Jonathan Lucroy | 32 | lucrojo01 | 2018 | OAK | AL | 4.223933269 | 0.005 | C | 6 | 1 | OAK | COL | 2018 | 2018 | ANA |
2605 | 2605 | Luis Garcia | 31 | garcilu03 | 2018 | PHI | NL | 1.646975662 | 0.145 | P | 3 | 1 | PHI | 2013 | 2018 | ANA | |
2617 | 2617 | Justin Bour | 30 | bourju01 | 2018 | PHI | NL | 0.536668951 | -0.085 | 1B | 1 | 2 | PHI | FLA | 2018 | 2018 | ANA |
2798 | 2798 | Chris Stratton | 27 | stratch01 | 2018 | SFG | NL | 3.887171791 | -0.075 | P | 6 | 1 | SFG | 2016 | 2018 | ANA | |
3026 | 3026 | Deck McGuire | 29 | mcguide02 | 2018 | TOR | AL | 0.156144487 | 0.015 | P | 0 | 1 | TOR | CIN | 2018 | 2018 | ANA |
3149 | 3149 | Brandon Phillips | 36 | phillbr01 | 2017 | ATL | NL | 4.910417374 | 1.17 | 2B, 3B | 11 | 1 | ATL | CIN | 2017 | 2017 | ANA |
3159 | 3159 | Sam Freeman | 30 | freemsa01 | 2017 | ATL | NL | 1.914397113 | 1.14 | P | 6 | 1 | ATL | MIL | 2017 | 2018 | ANA |
3171 | 3171 | Jim Johnson | 34 | johnsji04 | 2017 | ATL | NL | 2.067569238 | -0.37 | P | 2 | 1 | ATL | LAD | 2016 | 2017 | ANA |
3172 | 3172 | Akeel Morris | 24 | morriak01 | 2017 | ATL | NL | 0.174646754 | 0.205 | P | 1 | 1 | ATL | NYM | 2017 | 2017 | ANA |
3176 | 3176 | Ian Krol | 26 | krolia01 | 2017 | ATL | NL | 1.324048339 | -0.4 | P | 1 | 1 | ATL | DET | 2016 | 2017 | ANA |
3265 | 3265 | Chris Young | 33 | youngch04 | 2017 | BOS | AL | 2.534916865 | -0.29 | LF, RF | 3 | 1 | BOS | NYY | 2016 | 2017 | ANA |
3280 | 3280 | Noe Ramirez | 27 | ramirno01 | 2017 | BOS | AL | 0.112723156 | -0.035 | P | 0 | 1 | BOS | 2015 | 2017 | ANA | |
3313 | 3313 | Tommy La Stella | 28 | lasteto01 | 2017 | CHC | NL | 1.476150346 | 0.53 | 2B, 3B, 1B | 4 | 1 | CHC | ATL | 2015 | 2018 | ANA |
3317 | 3317 | Rene Rivera | 33 | riverre01 | 2017 | CHC | NL | 0.488791505 | 0.505 | C, 1B | 2 | 2 | CHC | NYM | 2017 | 2017 | ANA |
3321 | 3321 | Felix Pena | 27 | penafe01 | 2017 | CHC | NL | 0.651862872 | -0.115 | P | 1 | 1 | CHC | 2016 | 2017 | ANA | |
3355 | 3355 | Kevan Smith | 29 | smithke04 | 2017 | CHW | AL | 2.823646299 | 0.3 | C | 5 | 1 | CHW | 2016 | 2018 | ANA | |
3390 | 3390 | Zack Cozart | 31 | cozarza01 | 2017 | CIN | NL | 4.996771453 | 4.95 | SS | 21 | 1 | CIN | 2011 | 2017 | ANA | |
3411 | 3411 | Blake Wood | 31 | woodbl01 | 2017 | CIN | NL | 1.544169598 | -0.07 | P | 2 | 1 | CIN | CLE | 2016 | 2017 | ANA |
3450 | 3450 | Cody Allen | 28 | allenco01 | 2017 | CLE | AL | 2.704599642 | 1.55 | P | 8 | 1 | CLE | 2012 | 2018 | ANA | |
3518 | 3518 | Justin Upton | 29 | uptonju01 | 2017 | DET | AL | 4.921671018 | 4.795 | LF | 20 | 1 | DET | SDP | 2016 | 2017 | ANA |
3521 | 3521 | Ian Kinsler | 35 | kinslia01 | 2017 | DET | AL | 5.80189295 | 2.445 | 2B | 14 | 1 | DET | TEX | 2014 | 2017 | ANA |
3595 | 3595 | Max Stassi | 26 | stassma01 | 2017 | HOU | AL | 0.288048702 | 0.16 | C, 1B | 1 | 1 | HOU | 2013 | 2019 | ANA | |
3648 | 3648 | Miguel Almonte | 24 | almonmi01 | 2017 | KCR | AL | 0.039420169 | -0.05 | P | 0 | 1 | KCR | 2015 | 2017 | ANA | |
3783 | 3783 | Odrisamer Despaigne | 30 | despaod01 | 2017 | MIA | NL | 1.494397824 | 0.325 | P | 3 | 1 | FLA | BAL | 2016 | 2018 | ANA |
3799 | 3799 | Dillon Peters | 24 | peterdi01 | 2017 | MIA | NL | 0.893487243 | 0.025 | P | 1 | 1 | FLA | 2017 | 2018 | ANA | |
3802 | 3802 | Junichi Tazawa | 31 | tazawju01 | 2017 | MIA | NL | 1.780366604 | -0.53 | P | 1 | 1 | FLA | BOS | 2017 | 2018 | ANA |
3842 | 3842 | Nick Franklin | 26 | frankni01 | 2017 | MIL | NL | 0.887094002 | -0.13 | LF, 2B, RF, SS | 1 | 1 | MIL | TBD | 2017 | 2017 | ANA |
3875 | 3875 | Adalberto Mejia | 24 | mejiaad01 | 2017 | MIN | AL | 2.780813141 | 0.935 | P | 7 | 1 | MIN | 2016 | 2019 | ANA | |
3900 | 3900 | John Curtiss | 24 | curtijo02 | 2017 | MIN | AL | 0.168331808 | -0.09 | P | 0 | 1 | MIN | 2017 | 2018 | ANA | |
3944 | 3944 | Hansel Robles | 26 | robleha01 | 2017 | NYM | NL | 1.878265758 | -0.15 | P | 2 | 1 | NYM | 2015 | 2018 | ANA | |
3959 | 3959 | Fernando Salas | 32 | salasfe01 | 2017 | NYM | NL | 1.389402068 | -0.475 | P | 0 | 1 | NYM | ANA | 2016 | 2017 | ANA |
4078 | 4078 | Luis Garcia | 30 | garcilu03 | 2017 | PHI | NL | 2.214008572 | 1.67 | P | 8 | 1 | PHI | 2013 | 2018 | ANA | |
4188 | 4188 | Ryan Schimpf | 29 | schimry01 | 2017 | SDP | NL | 2.023375243 | 0.14 | 3B | 4 | 1 | SDP | 2016 | 2017 | ANA | |
4192 | 4192 | Jabari Blash | 27 | blashja01 | 2017 | SDP | NL | 2.002833363 | -0.205 | RF, LF | 3 | 1 | SDP | 2016 | 2017 | ANA | |
4296 | 4296 | Chris Stratton | 26 | stratch01 | 2017 | SFG | NL | 1.556530853 | 1.02 | P | 5 | 1 | SFG | 2016 | 2018 | ANA | |
4297 | 4297 | Jarrett Parker | 28 | parkeja03 | 2017 | SFG | NL | 1.764220656 | 0.41 | LF, RF | 4 | 1 | SFG | 2015 | 2017 | ANA | |
4421 | 4421 | Cesar Puello | 26 | puellce01 | 2017 | TBR | AL | 0.331590983 | -0.03 | LF, RF | 0 | 2 | TBD | ANA | 2017 | 2017 | ANA |
4528 | 4528 | Taylor Cole | 27 | coleta01 | 2017 | TOR | AL | 0.032025069 | -0.145 | P | 0 | 1 | TOR | 2017 | 2017 | ANA | |
4649 | 4649 | Jim Johnson | 33 | johnsji04 | 2016 | ATL | NL | 2.442177237 | 1.433850932 | P | 8 | 1 | ATL | LAD | 2016 | 2017 | ANA |
4653 | 4653 | Ian Krol | 25 | krolia01 | 2016 | ATL | NL | 1.722909227 | 0.940807453 | P | 5 | 1 | ATL | DET | 2016 | 2017 | ANA |
4667 | 4667 | Jhoulys Chacin | 28 | chacijh01 | 2016 | ATL | NL | 0.719907272 | 0.211304348 | P | 2 | 1 | ATL | ARI | 2016 | 2016 | ANA |
4741 | 4741 | Parker Bridwell | 24 | bridwpa01 | 2016 | BAL | AL | 0.066530201 | -0.135 | P | 0 | 1 | BAL | 2016 | 2016 | ANA | |
4763 | 4763 | Chris Young | 32 | youngch04 | 2016 | BOS | AL | 2.092165899 | 0.92 | LF, CF, RF | 5 | 1 | BOS | NYY | 2016 | 2017 | ANA |
4795 | 4795 | Noe Ramirez | 26 | ramirno01 | 2016 | BOS | AL | 0.310426515 | -0.225 | P | 0 | 1 | BOS | 2015 | 2017 | ANA | |
4818 | 4818 | Tommy La Stella | 27 | lasteto01 | 2016 | CHC | NL | 1.651558551 | 0.57 | 3B, 2B | 4 | 1 | CHC | ATL | 2015 | 2018 | ANA |
4830 | 4830 | Felix Pena | 26 | penafe01 | 2016 | CHC | NL | 0.290493359 | 0.12 | P | 1 | 1 | CHC | 2016 | 2017 | ANA | |
4883 | 4883 | Kevan Smith | 28 | smithke04 | 2016 | CHW | AL | 0.151907022 | -0.16 | C | 0 | 1 | CHW | 2016 | 2018 | ANA | |
4898 | 4898 | Zack Cozart | 30 | cozarza01 | 2016 | CIN | NL | 5.10906884 | 1.975 | SS | 14 | 1 | CIN | 2011 | 2017 | ANA | |
4909 | 4909 | Blake Wood | 30 | woodbl01 | 2016 | CIN | NL | 2.569764349 | 0.5 | P | 5 | 1 | CIN | CLE | 2016 | 2017 | ANA |
4916 | 4916 | John Lamb | 25 | lambjo02 | 2016 | CIN | NL | 1.985336336 | -0.38 | P | 2 | 1 | CIN | 2015 | 2016 | ANA | |
4934 | 4934 | Daniel Wright | 25 | wrighda04 | 2016 | CIN | NL | 0.402223985 | -0.38 | P | 0 | 1 | CIN | 2016 | 2016 | ANA | |
4935 | 4935 | JC Ramirez | 27 | ramirjc01 | 2016 | CIN | NL | 0.936652058 | -0.39 | P | 0 | 1 | CIN | SEA | 2016 | 2016 | ANA |
4960 | 4960 | Cody Allen | 27 | allenco01 | 2016 | CLE | AL | 2.63370111 | 1.428819876 | P | 8 | 1 | CLE | 2012 | 2018 | ANA | |
5029 | 5029 | Jason Gurka | 28 | gurkaja01 | 2016 | COL | NL | 0.266133964 | -0.11 | P | 0 | 1 | COL | 2015 | 2016 | ANA | |
5042 | 5042 | Ian Kinsler | 34 | kinslia01 | 2016 | DET | AL | 6.451834862 | 5.735403727 | 2B | 26 | 1 | DET | TEX | 2014 | 2017 | ANA |
5045 | 5045 | Justin Upton | 28 | uptonju01 | 2016 | DET | AL | 5.948230668 | 1.886645963 | LF, CF | 14 | 1 | DET | SDP | 2016 | 2017 | ANA |
5048 | 5048 | Cameron Maybin | 29 | maybica01 | 2016 | DET | AL | 3.715268676 | 2.153291925 | CF | 12 | 1 | DET | ATL | 2016 | 2016 | ANA |
5091 | 5091 | Luis Valbuena | 30 | valbulu01 | 2016 | HOU | AL | 3.209189452 | 2.42 | 3B, 1B, 2B | 11 | 1 | HOU | CHC | 2015 | 2016 | ANA |
5120 | 5120 | Max Stassi | 25 | stassma01 | 2016 | HOU | AL | 0.121986734 | -0.215 | C | 0 | 1 | HOU | 2013 | 2019 | ANA | |
5168 | 5168 | Brooks Pounders | 25 | poundbr01 | 2016 | KCR | AL | 0.377657152 | -0.555 | P | 0 | 1 | KCR | 2016 | 2016 | ANA | |
5255 | 5255 | Jesse Chavez | 32 | chaveje01 | 2016 | LAD | NL | 0.667422202 | -0.04 | P | 1 | 2 | LAD | TOR | 2016 | 2016 | ANA |
5259 | 5259 | Bud Norris | 31 | norribu01 | 2016 | LAD | NL | 1.160200197 | -0.28 | P | 1 | 2 | LAD | ATL | 2016 | 2016 | ANA |
5314 | 5314 | Odrisamer Despaigne | 29 | despaod01 | 2016 | MIA | NL | 0.048202157 | -0.040248447 | P | 0 | 2 | FLA | BAL | 2016 | 2018 | ANA |
5320 | 5320 | Cody Ege | 25 | egeco01 | 2016 | MIA | NL | 0.108235752 | -0.160993789 | P | 0 | 1 | FLA | 2016 | 2016 | ANA | |
5343 | 5343 | Martin Maldonado | 29 | maldoma01 | 2016 | MIL | NL | 2.551112656 | 1.135 | C | 7 | 1 | MIL | 2011 | 2016 | ANA | |
5362 | 5362 | Damien Magnifico | 25 | magnida01 | 2016 | MIL | NL | 0.047454052 | -0.005 | P | 0 | 1 | MIL | 2016 | 2016 | ANA | |
5380 | 5380 | Ramon Flores | 24 | florera02 | 2016 | MIL | NL | 2.914116829 | -1.355 | RF, CF, LF, 1B | 0 | 1 | MIL | NYY | 2016 | 2016 | ANA |
5389 | 5389 | Ricky Nolasco | 33 | nolasri01 | 2016 | MIN | AL | 3.536299985 | 1.065 | P | 7 | 1 | MIN | LAD | 2014 | 2016 | ANA |
5416 | 5416 | Adalberto Mejia | 23 | mejiaad01 | 2016 | MIN | AL | 0.035558142 | -0.01 | P | 0 | 1 | MIN | 2016 | 2019 | ANA | |
5420 | 5420 | Alex Meyer | 26 | meyeral01 | 2016 | MIN | AL | 0.086305194 | -0.155 | P | 0 | 1 | MIN | 2015 | 2016 | ANA | |
5444 | 5444 | Hansel Robles | 25 | robleha01 | 2016 | NYM | NL | 2.482991311 | 0.785 | P | 6 | 1 | NYM | 2015 | 2018 | ANA | |
5458 | 5458 | Fernando Salas | 31 | salasfe01 | 2016 | NYM | NL | 0.58507295 | 0.365 | P | 2 | 2 | NYM | ANA | 2016 | 2017 | ANA |
5501 | 5501 | Kirby Yates | 29 | yateski01 | 2016 | NYY | AL | 1.079963329 | 0.12 | P | 2 | 1 | NYY | TBD | 2016 | 2016 | ANA |
5507 | 5507 | Blake Parker | 31 | parkebl01 | 2016 | NYY | AL | 0.581491291 | 0.11 | P | 1 | 2 | NYY | SEA | 2016 | 2016 | ANA |
5517 | 5517 | Eric Young Jr. | 31 | younger03 | 2016 | NYY | AL | 0.009604239 | -0.025 | CF | 0 | 1 | NYY | NYM | 2016 | 2016 | ANA |
5593 | 5593 | David Hernandez | 31 | hernada01 | 2016 | PHI | NL | 2.230621146 | 0.61 | P | 5 | 1 | PHI | ARI | 2016 | 2016 | ANA |
5610 | 5610 | Brett Oberholtzer | 26 | oberhbr01 | 2016 | PHI | NL | 1.166371292 | -0.2 | P | 1 | 1 | PHI | HOU | 2016 | 2016 | ANA |
5612 | 5612 | Andrew Bailey | 32 | bailean01 | 2016 | PHI | NL | 0.968197517 | -0.3 | P | 1 | 1 | PHI | NYY | 2016 | 2016 | ANA |
5616 | 5616 | Luis Garcia | 29 | garcilu03 | 2016 | PHI | NL | 0.452223427 | -0.115 | P | 0 | 1 | PHI | 2013 | 2018 | ANA |
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 );