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,795 rows where prev_franch = "MIN"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | Eduardo Escobar | 30 | escobed01 | 2019 | ARI | NL | 6.763216046 | 4.029622642 | 3B, 2B | 21 | 1 | ARI | MIN | 2018 | 2019 | |
34 | 34 | John Ryan Murphy | 28 | murphjr01 | 2019 | ARI | NL | 0.680265171 | -0.030566038 | C, P | 1 | 1 | ARI | MIN | 2017 | 2019 | ATL |
128 | 128 | Ryan Eades | 27 | eadesry01 | 2019 | BAL | AL | 0.3740499 | 0.010188679 | P | 0 | 2 | BAL | MIN | 2019 | 2019 | |
240 | 240 | Randy Rosario | 25 | rosarra01 | 2019 | CHC | NL | 0.295761913 | -0.117169811 | P | 0 | 1 | CHC | MIN | 2018 | 2019 | KCR |
291 | 291 | Ervin Santana | 36 | santaer01 | 2019 | CHW | AL | 0.400622817 | -0.405 | P | 0 | 1 | CHW | MIN | 2019 | 2019 | |
338 | 338 | Juan Graterol | 30 | grateju01 | 2019 | CIN | NL | 0.185765125 | -0.188490566 | C | 0 | 1 | CIN | MIN | 2019 | 2019 | |
453 | 453 | Niko Goodrum | 27 | goodrni01 | 2019 | DET | AL | 4.629798749 | 1.707151899 | SS, 2B, LF, 1B, CF, RF, 3B | 10 | 1 | DET | MIN | 2018 | 2019 | |
484 | 484 | Austin Adams | 32 | adamsau01 | 2019 | DET | AL | 0.293195703 | 0.015379747 | P | 0 | 2 | DET | MIN | 2019 | 2019 | |
497 | 497 | Bobby Wilson | 36 | wilsobo02 | 2019 | DET | AL | 0.461018096 | -0.645949367 | C | 0 | 1 | DET | MIN | 2019 | 2019 | |
516 | 516 | Ryan Pressly | 30 | pressry01 | 2019 | HOU | AL | 2.066004379 | 1.558867925 | P | 7 | 1 | HOU | MIN | 2018 | 2019 | |
630 | 630 | Adalberto Mejia | 26 | mejiaad01 | 2019 | LAA | AL | 0.442168977 | 0.13245283 | P | 1 | 2 | ANA | MIN | 2019 | 2019 | STL |
640 | 640 | John Curtiss | 26 | curtijo02 | 2019 | LAA | AL | 0.037662222 | 0.015283019 | P | 0 | 1 | ANA | MIN | 2019 | 2019 | |
697 | 697 | JT Chargois | 28 | chargjt01 | 2019 | LAD | NL | 0.426086664 | -0.106981132 | P | 0 | 1 | LAD | MIN | 2018 | 2019 | |
721 | 721 | Tyler Kinley | 28 | kinlety01 | 2019 | MIA | NL | 1.408294963 | 0.234339623 | P | 3 | 1 | FLA | MIN | 2018 | 2019 | |
884 | 884 | Ryan O'Rourke | 31 | orourry01 | 2019 | NYM | NL | 0.067302396 | 0.010188679 | P | 0 | 1 | NYM | MIN | 2019 | 2019 | |
922 | 922 | Aaron Hicks | 29 | hicksaa01 | 2019 | NYY | AL | 2.421811037 | 1.192075472 | CF | 7 | 1 | NYY | MIN | 2016 | 2019 | |
929 | 929 | David Hale | 31 | haleda02 | 2019 | NYY | AL | 0.925520396 | 0.764150943 | P | 4 | 1 | NYY | MIN | 2019 | 2019 | |
969 | 969 | Robbie Grossman | 29 | grossro01 | 2019 | OAK | AL | 4.526230042 | 1.023962264 | LF, RF, CF | 10 | 1 | OAK | MIN | 2019 | 2019 | |
1001 | 1001 | Fernando Rodney | 42 | rodnefe01 | 2019 | OAK | AL | 0.347008812 | -0.331132075 | P | 0 | 1 | OAK | MIN | 2018 | 2019 | WSN |
1032 | 1032 | Blake Parker | 34 | parkebl01 | 2019 | PHI | NL | 0.671816339 | 0.239433962 | P | 2 | 2 | PHI | MIN | 2019 | 2019 | |
1040 | 1040 | Mike Morin | 28 | morinmi01 | 2019 | PHI | NL | 0.888273412 | -0.122264151 | P | 1 | 2 | PHI | MIN | 2019 | 2019 | |
1052 | 1052 | Logan Morrison | 31 | morrilo01 | 2019 | PHI | NL | 0.359071367 | -0.168113208 | 1B | 0 | 1 | PHI | MIN | 2019 | 2019 | |
1198 | 1198 | Matt Magill | 29 | magilma01 | 2019 | SEA | AL | 0.798391153 | 0.417735849 | P | 2 | 2 | SEA | MIN | 2019 | 2019 | |
1262 | 1262 | Tyler Austin | 27 | austity01 | 2019 | SFG | NL | 1.477899116 | 0.183396226 | LF, 1B, RF | 3 | 2 | SFG | MIN | 2019 | 2019 | MIL |
1363 | 1363 | Oliver Drake | 32 | drakeol01 | 2019 | TBR | AL | 1.736161138 | 0.952641509 | P | 5 | 1 | TBD | MIN | 2019 | 2019 | |
1392 | 1392 | Aaron Slegers | 26 | slegeaa01 | 2019 | TBR | AL | 0.049087889 | 0.020377358 | P | 0 | 1 | TBD | MIN | 2019 | 2019 | |
1421 | 1421 | Logan Forsythe | 32 | forsylo01 | 2019 | TEX | AL | 3.512541254 | -0.00509434 | 1B, 3B, SS, 2B | 5 | 1 | TEX | MIN | 2019 | 2019 | |
1490 | 1490 | Buddy Boshers | 31 | boshebu01 | 2019 | TOR | AL | 0.637545966 | 0.106981132 | P | 1 | 1 | TOR | MIN | 2019 | 2019 | |
1576 | 1576 | Eduardo Escobar | 29 | escobed01 | 2018 | ARI | NL | 2.220429185 | 1.035 | 3B, SS, 2B | 6 | 2 | ARI | MIN | 2018 | 2019 | |
1585 | 1585 | John Ryan Murphy | 27 | murphjr01 | 2018 | ARI | NL | 2.220429185 | 0.19 | C | 4 | 1 | ARI | MIN | 2017 | 2019 | ATL |
1625 | 1625 | Kurt Suzuki | 34 | suzukku01 | 2018 | ATL | NL | 3.799425967 | 1.555 | C | 10 | 1 | ATL | MIN | 2017 | 2018 | WSN |
1646 | 1646 | Danny Santana | 27 | santada01 | 2018 | ATL | NL | 0.313354719 | 0.065 | LF, CF, RF | 1 | 1 | ATL | MIN | 2017 | 2018 | TEX |
1763 | 1763 | Justin Haley | 27 | haleyju01 | 2018 | BOS | AL | 0.135662566 | -0.065 | P | 0 | 1 | BOS | MIN | 2018 | 2018 | |
1796 | 1796 | Randy Rosario | 24 | rosarra01 | 2018 | CHC | NL | 1.473384074 | 0.089447853 | P | 3 | 1 | CHC | MIN | 2018 | 2019 | KCR |
1817 | 1817 | Chris Gimenez | 35 | gimench01 | 2018 | CHC | NL | 0.307284768 | -0.233558282 | C, 1B, 3B, P | 0 | 1 | CHC | MIN | 2018 | 2018 | MIN |
1841 | 1841 | Hector Santiago | 30 | santihe01 | 2018 | CHW | AL | 2.630049113 | 0.26 | P | 4 | 1 | CHW | MIN | 2018 | 2018 | NYM |
1843 | 1843 | Ryan LaMarre | 29 | lamarry01 | 2018 | CHW | AL | 0.680661157 | 0.615 | CF, LF, RF, P | 3 | 2 | CHW | MIN | 2018 | 2018 | MIN |
1963 | 1963 | Matt Belisle | 38 | belisma01 | 2018 | CLE | AL | 0.256598654 | -0.005 | P | 0 | 1 | CLE | MIN | 2018 | 2018 | MIN |
2023 | 2023 | Niko Goodrum | 26 | goodrni01 | 2018 | DET | AL | 4.748086522 | 1.28 | 2B, 1B, SS, LF, 3B, RF | 10 | 1 | DET | MIN | 2018 | 2019 | |
2084 | 2084 | Ryan Pressly | 29 | pressry01 | 2018 | HOU | AL | 0.935125359 | 1.175 | P | 5 | 2 | HOU | MIN | 2018 | 2019 | |
2242 | 2242 | JT Chargois | 27 | chargjt01 | 2018 | LAD | NL | 1.029557259 | 0.168957055 | P | 2 | 1 | LAD | MIN | 2018 | 2019 | |
2244 | 2244 | Brian Dozier | 31 | doziebr01 | 2018 | LAD | NL | 1.636514523 | -0.104355828 | 2B | 2 | 2 | LAD | MIN | 2018 | 2018 | WSN |
2295 | 2295 | Drew Rucinski | 29 | rucindr01 | 2018 | MIA | NL | 1.211200064 | -0.246521739 | P | 1 | 1 | FLA | MIN | 2018 | 2018 | |
2301 | 2301 | Tyler Kinley | 27 | kinlety01 | 2018 | MIA | NL | 0.179877175 | -0.045279503 | P | 0 | 2 | FLA | MIN | 2018 | 2019 | |
2483 | 2483 | Aaron Hicks | 28 | hicksaa01 | 2018 | NYY | AL | 5.392542807 | 4.85 | CF | 22 | 1 | NYY | MIN | 2016 | 2019 | |
2500 | 2500 | Lance Lynn | 31 | lynnla01 | 2018 | NYY | AL | 1.519409112 | 1.26 | P | 6 | 2 | NYY | MIN | 2018 | 2018 | TEX |
2564 | 2564 | Fernando Rodney | 41 | rodnefe01 | 2018 | OAK | AL | 0.702684407 | 0.085 | P | 1 | 2 | OAK | MIN | 2018 | 2019 | WSN |
2720 | 2720 | Phil Hughes | 32 | hugheph01 | 2018 | SDP | NL | 0.373871565 | -0.26 | P | 0 | 2 | SDP | MIN | 2018 | 2018 | |
2762 | 2762 | Zach Duke | 35 | dukeza01 | 2018 | SEA | AL | 0.474796641 | 0.035 | P | 1 | 2 | SEA | MIN | 2018 | 2018 | CIN |
2946 | 2946 | Bartolo Colon | 45 | colonba01 | 2018 | TEX | AL | 3.972821661 | 0.435 | P | 6 | 1 | TEX | MIN | 2018 | 2018 | |
3062 | 3062 | Brandon Kintzler | 33 | kintzbr01 | 2018 | WSN | NL | 1.454707724 | 0.66 | P | 4 | 1 | WSN | MIN | 2017 | 2018 | CHC |
3132 | 3132 | Chris Herrmann | 29 | herrmch01 | 2017 | ARI | NL | 2.527749404 | -0.855 | C, LF, 1B, RF | 1 | 1 | ARI | MIN | 2016 | 2017 | SEA |
3137 | 3137 | John Ryan Murphy | 26 | murphjr01 | 2017 | ARI | NL | 0.069118148 | -0.09 | C | 0 | 1 | ARI | MIN | 2017 | 2019 | ATL |
3148 | 3148 | Kurt Suzuki | 33 | suzukku01 | 2017 | ATL | NL | 3.040719376 | 2.155 | C | 11 | 1 | ATL | MIN | 2017 | 2018 | WSN |
3175 | 3175 | Danny Santana | 26 | santada01 | 2017 | ATL | NL | 1.495758398 | -0.355 | LF, 2B, RF, 3B, CF | 1 | 2 | ATL | MIN | 2017 | 2018 | TEX |
3217 | 3217 | J.J. Hardy | 34 | hardyjj01 | 2017 | BAL | AL | 2.53903953 | -0.635 | SS | 2 | 1 | BAL | MIN | 2011 | 2017 | |
3263 | 3263 | Fernando Abad | 31 | abadfe01 | 2017 | BOS | AL | 1.048525452 | 0.4 | P | 3 | 1 | BOS | MIN | 2016 | 2017 | SFG |
3471 | 3471 | Craig Breslow | 36 | breslcr01 | 2017 | CLE | AL | 0.119789236 | 0.08 | P | 0 | 2 | CLE | MIN | 2017 | 2017 | |
3611 | 3611 | Juan Centeno | 27 | centeju01 | 2017 | HOU | AL | 0.529637937 | -0.26 | C | 0 | 1 | HOU | MIN | 2017 | 2017 | TEX |
3670 | 3670 | Ricky Nolasco | 34 | nolasri01 | 2017 | LAA | AL | 5.038844759 | 0.67 | P | 9 | 1 | ANA | MIN | 2016 | 2017 | |
3675 | 3675 | Alex Meyer | 27 | meyeral01 | 2017 | LAA | AL | 1.874487369 | 1.055 | P | 6 | 1 | ANA | MIN | 2016 | 2017 | |
3696 | 3696 | Shane Robinson | 32 | robinsh01 | 2017 | LAA | AL | 0.335426305 | 0.015 | RF, CF, LF | 1 | 1 | ANA | MIN | 2016 | 2017 | NYY |
3841 | 3841 | Tommy Milone | 30 | milonto01 | 2017 | MIL | NL | 0.50861615 | -0.04 | P | 1 | 1 | MIL | MIN | 2017 | 2017 | NYM |
3971 | 3971 | Aaron Hicks | 27 | hicksaa01 | 2017 | NYY | AL | 3.308263549 | 3.635 | CF, LF, RF | 15 | 1 | NYY | MIN | 2016 | 2019 | |
3997 | 3997 | Jaime Garcia | 30 | garcija02 | 2017 | NYY | AL | 1.05347192 | 0.09 | P | 1 | 3 | NYY | MIN | 2017 | 2017 | TOR |
4047 | 4047 | Trevor Plouffe | 31 | plouftr01 | 2017 | OAK | AL | 1.891201049 | -0.215 | 3B, 1B, 2B | 2 | 1 | OAK | MIN | 2017 | 2017 | TBD |
4206 | 4206 | Tim Melville | 27 | melviti01 | 2017 | SDP | NL | 0.050875749 | -0.055 | P | 0 | 2 | SDP | MIN | 2017 | 2017 | COL |
4241 | 4241 | Andrew Albers | 31 | alberan01 | 2017 | SEA | AL | 1.164807471 | 0.54 | P | 3 | 1 | SEA | MIN | 2017 | 2017 | |
4295 | 4295 | Eduardo Nunez | 30 | nunezed02 | 2017 | SFG | NL | 3.169616773 | 0.635 | 3B, 2B, LF, SS, RF | 6 | 1 | SFG | MIN | 2016 | 2017 | BOS |
4319 | 4319 | Neil Ramirez | 28 | ramirne01 | 2017 | SFG | NL | 0.294184729 | -0.34 | P | 0 | 1 | SFG | MIN | 2017 | 2017 | NYM |
4529 | 4529 | Nick Tepesch | 28 | tepesni01 | 2017 | TOR | AL | 0.372629467 | -0.145 | P | 0 | 2 | TOR | MIN | 2017 | 2017 | |
4565 | 4565 | Brandon Kintzler | 32 | kintzbr01 | 2017 | WSN | NL | 0.926374126 | 0.425 | P | 3 | 2 | WSN | MIN | 2017 | 2018 | CHC |
4603 | 4603 | Chris Herrmann | 28 | herrmch01 | 2016 | ARI | NL | 1.624704691 | 1.145 | C, RF, LF, 1B, CF | 6 | 1 | ARI | MIN | 2016 | 2017 | SEA |
4710 | 4710 | J.J. Hardy | 33 | hardyjj01 | 2016 | BAL | AL | 4.19138756 | 2.08 | SS | 13 | 1 | BAL | MIN | 2011 | 2017 | |
4732 | 4732 | Brian Duensing | 33 | duensbr01 | 2016 | BAL | AL | 0.261994899 | 0.135 | P | 1 | 1 | BAL | MIN | 2016 | 2016 | CHC |
4753 | 4753 | David Ortiz | 40 | ortizda01 | 2016 | BOS | AL | 5.769585253 | 4.86 | 1B | 21 | 1 | BOS | MIN | 2003 | 2016 | |
4792 | 4792 | Fernando Abad | 30 | abadfe01 | 2016 | BOS | AL | 0.442497815 | -0.185 | P | 0 | 2 | BOS | MIN | 2016 | 2017 | SFG |
5057 | 5057 | Mike Pelfrey | 32 | pelfrmi01 | 2016 | DET | AL | 3.273500665 | 0.332049689 | P | 6 | 1 | DET | MIN | 2016 | 2016 | CHW |
5177 | 5177 | Ricky Nolasco | 33 | nolasri01 | 2016 | LAA | AL | 2.135018409 | 1.255 | P | 7 | 2 | ANA | MIN | 2016 | 2017 | |
5196 | 5196 | Alex Meyer | 26 | meyeral01 | 2016 | LAA | AL | 0.630310618 | 0.235 | P | 2 | 2 | ANA | MIN | 2016 | 2017 | |
5198 | 5198 | Shane Robinson | 31 | robinsh01 | 2016 | LAA | AL | 1.069435216 | 0.03 | LF, CF, RF | 2 | 1 | ANA | MIN | 2016 | 2017 | NYY |
5203 | 5203 | A.J. Achter | 27 | achteaj01 | 2016 | LAA | AL | 0.837942351 | 0.035 | P | 1 | 1 | ANA | MIN | 2016 | 2016 | |
5271 | 5271 | Casey Fien | 32 | fienca01 | 2016 | LAD | NL | 0.667422202 | -0.25 | P | 0 | 2 | LAD | MIN | 2016 | 2016 | SEA |
5351 | 5351 | Blaine Boyer | 34 | boyerbl01 | 2016 | MIL | NL | 1.789695691 | 0.44 | P | 4 | 1 | MIL | MIN | 2016 | 2016 | BOS |
5368 | 5368 | Josmil Pinto | 27 | pintojo01 | 2016 | MIL | NL | 0.060500695 | -0.1 | 0 | 1 | MIL | MIN | 2016 | 2016 | ||
5494 | 5494 | Aaron Hicks | 26 | hicksaa01 | 2016 | NYY | AL | 3.46713032 | -0.26 | RF, LF, CF | 4 | 1 | NYY | MIN | 2016 | 2019 | |
5671 | 5671 | Pedro Florimon | 29 | floripe01 | 2016 | PIT | NL | 0.244107744 | -0.08 | 2B, SS | 0 | 1 | PIT | MIN | 2015 | 2016 | PHI |
5808 | 5808 | Eduardo Nunez | 29 | nunezed02 | 2016 | SFG | NL | 1.956602814 | 1.05 | SS, 3B, 2B | 6 | 2 | SFG | MIN | 2016 | 2017 | BOS |
5866 | 5866 | Eric Fryer | 30 | fryerer01 | 2016 | STL | NL | 0.403255893 | 0.535 | C | 2 | 1 | STL | MIN | 2016 | 2016 | PIT |
5915 | 5915 | Oswaldo Arcia | 25 | arciaos01 | 2016 | TBR | AL | 0.587610032 | 0.025 | LF, RF | 1 | 2 | TBD | MIN | 2016 | 2016 | FLA |
5923 | 5923 | Kevin Jepsen | 31 | jepseke01 | 2016 | TBR | AL | 0.565912852 | -0.355 | P | 0 | 2 | TBD | MIN | 2016 | 2016 | TEX |
6015 | 6015 | Scott Diamond | 29 | diamosc01 | 2016 | TOR | AL | 0.015508449 | -0.055 | P | 0 | 1 | TOR | MIN | 2016 | 2016 | |
6030 | 6030 | Chris Colabello | 32 | colabch01 | 2016 | TOR | AL | 0.299354839 | -0.495 | 1B, LF | 0 | 1 | TOR | MIN | 2015 | 2016 | |
6036 | 6036 | Wilson Ramos | 28 | ramoswi01 | 2016 | WSN | NL | 5.202195164 | 3.42 | C | 18 | 1 | WSN | MIN | 2010 | 2016 | TBD |
6198 | 6198 | J.J. Hardy | 32 | hardyjj01 | 2015 | BAL | AL | 4.234920635 | 0.05 | SS | 6 | 1 | BAL | MIN | 2011 | 2017 | |
6216 | 6216 | Chris Parmelee | 27 | parmech01 | 2015 | BAL | AL | 0.988471178 | -0.04 | 1B, RF | 1 | 1 | BAL | MIN | 2015 | 2015 | NYY |
6234 | 6234 | David Ortiz | 39 | ortizda01 | 2015 | BOS | AL | 5.732775274 | 3.02 | 1B | 17 | 1 | BOS | MIN | 2003 | 2016 | |
6459 | 6459 | Anthony Swarzak | 29 | swarzan01 | 2015 | CLE | AL | 0.271584366 | 0.0 | P | 0 | 1 | CLE | MIN | 2015 | 2015 | NYY |
6612 | 6612 | Alex Presley | 29 | preslal01 | 2015 | HOU | AL | 0.124710552 | -0.16 | LF, CF, RF | 0 | 1 | HOU | MIN | 2014 | 2015 | MIL |
6614 | 6614 | Sam Deduno | 31 | dedunsa01 | 2015 | HOU | AL | 0.539525444 | -0.34 | P | 0 | 1 | HOU | MIN | 2014 | 2015 |
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 );