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,244 rows where next_franch = "MIN"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
720 | 720 | Sergio Romo | 36 | romose01 | 2019 | MIA | NL | 1.39984623 | 0.392264151 | P | 3 | 1 | FLA | TBD | 2019 | 2019 | MIN |
1251 | 1251 | Sam Dyson | 31 | dysonsa01 | 2019 | SFG | NL | 1.753498531 | 1.151320755 | P | 6 | 1 | SFG | TEX | 2017 | 2019 | MIN |
1817 | 1817 | Chris Gimenez | 35 | gimench01 | 2018 | CHC | NL | 0.307284768 | -0.233558282 | C, 1B, 3B, P | 0 | 1 | CHC | MIN | 2018 | 2018 | MIN |
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 |
2072 | 2072 | Marwin Gonzalez | 29 | gonzama01 | 2018 | HOU | AL | 5.230517889 | 1.985 | LF, SS, 2B, 1B, 3B, CF, RF | 13 | 1 | HOU | 2012 | 2018 | MIN | |
2170 | 2170 | Blake Parker | 33 | parkebl01 | 2018 | LAA | AL | 2.192833336 | 0.545 | P | 5 | 1 | ANA | NYY | 2017 | 2018 | MIN |
2186 | 2186 | Juan Graterol | 29 | grateju01 | 2018 | LAA | AL | 0.009530069 | 0.18 | C | 1 | 1 | ANA | 2016 | 2018 | MIN | |
2253 | 2253 | Logan Forsythe | 31 | forsylo01 | 2018 | LAD | NL | 2.03120332 | -0.631104294 | 2B, 3B, 1B, LF | 1 | 1 | LAD | TBD | 2017 | 2018 | MIN |
2351 | 2351 | Jonathan Schoop | 26 | schoojo01 | 2018 | MIL | NL | 1.313947591 | -0.114294479 | 2B, SS | 2 | 2 | MIL | BAL | 2018 | 2018 | MIN |
2508 | 2508 | Ronald Torreyes | 25 | torrero01 | 2018 | NYY | AL | 0.946711474 | 0.39 | 2B, 3B, SS | 2 | 1 | NYY | LAD | 2016 | 2018 | MIN |
2511 | 2511 | Tyler Austin | 26 | austity01 | 2018 | NYY | AL | 1.225156025 | 0.15 | 1B | 2 | 1 | NYY | 2016 | 2018 | MIN | |
2512 | 2512 | David Hale | 30 | haleda02 | 2018 | NYY | AL | 0.23253705 | 0.165 | P | 1 | 1 | NYY | COL | 2018 | 2018 | MIN |
2731 | 2731 | Nelson Cruz | 37 | cruzne02 | 2018 | SEA | AL | 5.651772465 | 2.7 | RF | 17 | 1 | SEA | BAL | 2015 | 2018 | MIN |
2769 | 2769 | Taylor Motter | 28 | motteta01 | 2018 | SEA | AL | 0.162572135 | 0.06 | 1B, RF, 2B, 3B, LF, P, SS | 0 | 1 | SEA | TBD | 2017 | 2018 | MIN |
2770 | 2770 | Mike Morin | 27 | morinmi01 | 2018 | SEA | AL | 0.092068573 | 0.025 | P | 0 | 1 | SEA | KCR | 2018 | 2018 | MIN |
2794 | 2794 | Sam Dyson | 30 | dysonsa01 | 2018 | SFG | NL | 2.280848854 | 0.895 | P | 6 | 1 | SFG | TEX | 2017 | 2019 | MIN |
2882 | 2882 | C.J. Cron | 28 | croncj01 | 2018 | TBR | AL | 5.261623198 | 2.095 | 1B | 13 | 1 | TBD | ANA | 2018 | 2018 | MIN |
2912 | 2912 | Johnny Field | 26 | fieldjo04 | 2018 | TBR | AL | 1.681840272 | 0.04 | RF, LF, CF, P | 2 | 1 | TBD | 2018 | 2018 | MIN | |
2959 | 2959 | Martin Perez | 27 | perezma02 | 2018 | TEX | AL | 2.591590857 | -0.505 | P | 2 | 1 | TEX | 2012 | 2018 | MIN | |
3033 | 3033 | Oliver Drake | 31 | drakeol01 | 2018 | TOR | AL | 0.02687733 | -0.05 | P | 0 | 4 | TOR | ANA | 2018 | 2018 | MIN |
3113 | 3113 | Fernando Rodney | 40 | rodnefe01 | 2017 | ARI | NL | 2.392462074 | 0.77 | P | 6 | 1 | ARI | FLA | 2017 | 2017 | MIN |
3152 | 3152 | Jaime Garcia | 30 | garcija02 | 2017 | ATL | NL | 3.225927066 | 1.56 | P | 9 | 1 | ATL | STL | 2017 | 2017 | MIN |
3191 | 3191 | Bartolo Colon | 44 | colonba01 | 2017 | ATL | NL | 1.798525709 | -1.21 | P | 0 | 1 | ATL | NYM | 2017 | 2017 | MIN |
3270 | 3270 | Addison Reed | 28 | reedad01 | 2017 | BOS | AL | 0.933896579 | 0.28 | P | 2 | 2 | BOS | NYM | 2017 | 2017 | MIN |
3570 | 3570 | Marwin Gonzalez | 28 | gonzama01 | 2017 | HOU | AL | 4.785325216 | 4.045 | LF, SS, 1B, 2B, 3B, RF | 19 | 1 | HOU | 2012 | 2018 | MIN | |
3671 | 3671 | Blake Parker | 32 | parkebl01 | 2017 | LAA | AL | 2.365663204 | 1.645 | P | 8 | 1 | ANA | NYY | 2017 | 2018 | MIN |
3699 | 3699 | Juan Graterol | 28 | grateju01 | 2017 | LAA | AL | 0.833773959 | -0.065 | C | 1 | 1 | ANA | 2016 | 2018 | MIN | |
3728 | 3728 | Logan Forsythe | 30 | forsylo01 | 2017 | LAD | NL | 4.342087312 | 1.845 | 2B, 3B, LF, SS, 1B | 12 | 1 | LAD | TBD | 2017 | 2018 | MIN |
3958 | 3958 | Adam Wilk | 29 | wilkad01 | 2017 | NYM | NL | 0.103776327 | -0.275 | P | 0 | 1 | NYM | ANA | 2017 | 2017 | MIN |
3984 | 3984 | Michael Pineda | 28 | pinedmi01 | 2017 | NYY | AL | 2.70379725 | 0.875 | P | 6 | 1 | NYY | SEA | 2014 | 2017 | MIN |
3985 | 3985 | Ronald Torreyes | 24 | torrero01 | 2017 | NYY | AL | 3.079159425 | 0.685 | 2B, SS, 3B, RF | 6 | 1 | NYY | LAD | 2016 | 2018 | MIN |
4008 | 4008 | Tyler Austin | 25 | austity01 | 2017 | NYY | AL | 0.421551588 | -0.145 | 1B, RF | 0 | 1 | NYY | 2016 | 2018 | MIN | |
4058 | 4058 | Ryan LaMarre | 28 | lamarry01 | 2017 | OAK | AL | 0.076028183 | -0.065 | CF | 0 | 1 | OAK | BOS | 2017 | 2017 | MIN |
4221 | 4221 | Nelson Cruz | 36 | cruzne02 | 2017 | SEA | AL | 6.093826356 | 4.035 | RF | 20 | 1 | SEA | BAL | 2015 | 2018 | MIN |
4250 | 4250 | Taylor Motter | 27 | motteta01 | 2017 | SEA | AL | 2.645381984 | -0.575 | SS, 2B, 1B, LF, 3B, RF | 2 | 1 | SEA | TBD | 2017 | 2018 | MIN |
4274 | 4274 | Chase De Jong | 23 | dejonch01 | 2017 | SEA | AL | 0.901374345 | -0.28 | P | 0 | 1 | SEA | 2017 | 2017 | MIN | |
4279 | 4279 | Chris Heston | 29 | hestoch01 | 2017 | SEA | AL | 0.129472375 | -0.425 | P | 0 | 1 | SEA | SFG | 2017 | 2017 | MIN |
4303 | 4303 | Sam Dyson | 29 | dysonsa01 | 2017 | SFG | NL | 1.580280271 | 0.265 | P | 3 | 2 | SFG | TEX | 2017 | 2019 | MIN |
4338 | 4338 | Lance Lynn | 30 | lynnla01 | 2017 | STL | NL | 5.21123508 | 1.91 | P | 12 | 1 | STL | 2011 | 2017 | MIN | |
4361 | 4361 | Zach Duke | 34 | dukeza01 | 2017 | STL | NL | 0.586370559 | 0.005 | P | 1 | 1 | STL | CHW | 2016 | 2017 | MIN |
4381 | 4381 | Logan Morrison | 29 | morrilo01 | 2017 | TBR | AL | 5.693890885 | 3.345 | 1B | 17 | 1 | TBD | SEA | 2016 | 2017 | MIN |
4395 | 4395 | Jake Odorizzi | 27 | odorija01 | 2017 | TBR | AL | 3.912686846 | 0.11 | P | 5 | 1 | TBD | KCR | 2013 | 2017 | MIN |
4437 | 4437 | Martin Perez | 26 | perezma02 | 2017 | TEX | AL | 5.304141493 | 2.145 | P | 14 | 1 | TEX | 2012 | 2018 | MIN | |
4472 | 4472 | Dillon Gee | 31 | geedi01 | 2017 | TEX | AL | 0.302962382 | -0.11 | P | 0 | 1 | TEX | KCR | 2017 | 2017 | MIN |
4791 | 4791 | Pat Light | 25 | lightpa01 | 2016 | BOS | AL | 0.039700004 | -0.17 | P | 0 | 1 | BOS | 2016 | 2016 | MIN | |
4922 | 4922 | Matt Magill | 26 | magilma01 | 2016 | CIN | NL | 0.085439735 | -0.06 | P | 0 | 1 | CIN | LAD | 2016 | 2016 | MIN |
4938 | 4938 | Tim Melville | 26 | melviti01 | 2016 | CIN | NL | 0.225227231 | -0.445 | P | 0 | 1 | CIN | 2016 | 2016 | MIN | |
4992 | 4992 | Austin Adams | 29 | adamsau01 | 2016 | CLE | AL | 0.377397536 | -0.467888199 | P | 0 | 1 | CLE | 2014 | 2016 | MIN | |
4993 | 4993 | Chris Gimenez | 33 | gimench01 | 2016 | CLE | AL | 1.466557912 | -0.578571429 | C, 1B, 3B, P | 0 | 1 | CLE | TEX | 2016 | 2016 | MIN |
5092 | 5092 | Jason Castro | 29 | castrja01 | 2016 | HOU | AL | 3.528231678 | 1.985 | C, 1B | 11 | 1 | HOU | 2010 | 2016 | MIN | |
5096 | 5096 | Marwin Gonzalez | 27 | gonzama01 | 2016 | HOU | AL | 4.860702152 | 0.865 | 1B, 3B, LF, 2B, SS, CF | 9 | 1 | HOU | 2012 | 2018 | MIN | |
5180 | 5180 | Hector Santiago | 28 | santihe01 | 2016 | LAA | AL | 3.491573387 | 0.775 | P | 7 | 1 | ANA | CHW | 2014 | 2016 | MIN |
5199 | 5199 | Gregorio Petit | 31 | petitgr01 | 2016 | LAA | AL | 2.148504983 | -0.14 | 2B, SS, 3B, LF, RF | 2 | 1 | ANA | NYY | 2016 | 2016 | MIN |
5207 | 5207 | Juan Graterol | 27 | grateju01 | 2016 | LAA | AL | 0.144518272 | 0.08 | C | 0 | 1 | ANA | 2016 | 2018 | MIN | |
5266 | 5266 | Nick Tepesch | 27 | tepesni01 | 2016 | LAD | NL | 0.111146228 | -0.11 | P | 0 | 1 | LAD | TEX | 2016 | 2016 | MIN |
5316 | 5316 | Craig Breslow | 35 | breslcr01 | 2016 | MIA | NL | 0.386493658 | -0.055341615 | P | 0 | 1 | FLA | BOS | 2016 | 2016 | MIN |
5367 | 5367 | Neil Ramirez | 27 | ramirne01 | 2016 | MIL | NL | 0.032640354 | -0.085 | P | 0 | 2 | MIL | CHC | 2016 | 2016 | MIN |
5482 | 5482 | Michael Pineda | 27 | pinedmi01 | 2016 | NYY | AL | 5.019303249 | 2.16 | P | 14 | 1 | NYY | SEA | 2014 | 2017 | MIN |
5492 | 5492 | Ronald Torreyes | 23 | torrero01 | 2016 | NYY | AL | 1.62311641 | 0.5 | 3B, SS, 2B, RF | 4 | 1 | NYY | LAD | 2016 | 2018 | MIN |
5510 | 5510 | Tyler Austin | 24 | austity01 | 2016 | NYY | AL | 0.86438152 | 0.025 | 1B, RF, LF | 1 | 1 | NYY | 2016 | 2018 | MIN | |
5744 | 5744 | Nelson Cruz | 35 | cruzne02 | 2016 | SEA | AL | 6.237665269 | 4.545 | RF | 22 | 1 | SEA | BAL | 2015 | 2018 | MIN |
5829 | 5829 | Ehire Adrianza | 26 | adriaeh01 | 2016 | SFG | NL | 0.698084421 | 0.06 | SS, 2B, 3B | 1 | 1 | SFG | 2013 | 2016 | MIN | |
5862 | 5862 | Zach Duke | 33 | dukeza01 | 2016 | STL | NL | 0.825856576 | 0.645 | P | 3 | 2 | STL | CHW | 2016 | 2017 | MIN |
5885 | 5885 | Jake Odorizzi | 26 | odorija01 | 2016 | TBR | AL | 5.307325879 | 2.485 | P | 13 | 1 | TBD | KCR | 2013 | 2017 | MIN |
5897 | 5897 | Logan Morrison | 28 | morrilo01 | 2016 | TBR | AL | 3.833914632 | 0.48 | 1B | 6 | 1 | TBD | SEA | 2016 | 2017 | MIN |
5909 | 5909 | Bobby Wilson | 33 | wilsobo02 | 2016 | TBR | AL | 0.915130377 | 0.145 | C | 1 | 3 | TBD | TEX | 2016 | 2016 | MIN |
5935 | 5935 | Martin Perez | 25 | perezma02 | 2016 | TEX | AL | 5.493966114 | 2.085 | P | 16 | 1 | TEX | 2012 | 2018 | MIN | |
6048 | 6048 | Matt Belisle | 36 | belisma01 | 2016 | WSN | NL | 1.229387977 | 0.86 | P | 4 | 1 | WSN | STL | 2016 | 2016 | MIN |
6448 | 6448 | Austin Adams | 28 | adamsau01 | 2015 | CLE | AL | 0.752079784 | 0.181118012 | P | 1 | 1 | CLE | 2014 | 2016 | MIN | |
6579 | 6579 | Jason Castro | 28 | castrja01 | 2015 | HOU | AL | 3.597419782 | 1.955 | C | 10 | 1 | HOU | 2010 | 2016 | MIN | |
6580 | 6580 | Marwin Gonzalez | 26 | gonzama01 | 2015 | HOU | AL | 3.549454185 | 1.71 | 1B, SS, 3B, 2B, LF | 9 | 1 | HOU | 2012 | 2018 | MIN | |
6615 | 6615 | Robbie Grossman | 25 | grossro01 | 2015 | HOU | AL | 0.518028449 | -0.34 | LF, RF | 0 | 1 | HOU | 2013 | 2015 | MIN | |
6667 | 6667 | Hector Santiago | 27 | santihe01 | 2015 | LAA | AL | 5.004503809 | 1.3 | P | 12 | 1 | ANA | CHW | 2014 | 2016 | MIN |
6705 | 6705 | Drew Rucinski | 26 | rucindr01 | 2015 | LAA | AL | 0.202286366 | -0.21 | P | 0 | 1 | ANA | 2014 | 2015 | MIN | |
6845 | 6845 | Neal Cotts | 35 | cottsne01 | 2015 | MIL | NL | 1.136815647 | 0.235 | P | 2 | 1 | MIL | TEX | 2015 | 2015 | MIN |
6853 | 6853 | Logan Schafer | 28 | schaflo01 | 2015 | MIL | NL | 1.452285064 | -0.405 | CF, LF | 1 | 1 | MIL | 2011 | 2015 | MIN | |
6858 | 6858 | Brandon Kintzler | 30 | kintzbr01 | 2015 | MIL | NL | 0.17548161 | -0.16 | P | 0 | 1 | MIL | 2010 | 2015 | MIN | |
6865 | 6865 | Juan Centeno | 25 | centeju01 | 2015 | MIL | NL | 0.233584311 | -0.48 | C | 0 | 1 | MIL | NYM | 2015 | 2015 | MIN |
6966 | 6966 | Michael Pineda | 26 | pinedmi01 | 2015 | NYY | AL | 4.471698314 | 2.785 | P | 14 | 1 | NYY | SEA | 2014 | 2017 | MIN |
6981 | 6981 | John Ryan Murphy | 24 | murphjr01 | 2015 | NYY | AL | 1.598205703 | 0.6 | C | 4 | 1 | NYY | 2013 | 2015 | MIN | |
7046 | 7046 | Fernando Abad | 29 | abadfe01 | 2015 | OAK | AL | 1.233510769 | -0.22 | P | 1 | 1 | OAK | WSN | 2014 | 2015 | MIN |
7210 | 7210 | Nelson Cruz | 34 | cruzne02 | 2015 | SEA | AL | 6.221749099 | 5.055 | RF | 24 | 1 | SEA | BAL | 2015 | 2018 | MIN |
7289 | 7289 | Ehire Adrianza | 25 | adriaeh01 | 2015 | SFG | NL | 1.340231074 | 0.015 | 2B, SS, 1B, 3B | 2 | 1 | SFG | 2013 | 2016 | MIN | |
7313 | 7313 | Lance Lynn | 28 | lynnla01 | 2015 | STL | NL | 4.768318048 | 3.18 | P | 17 | 1 | STL | 2011 | 2017 | MIN | |
7359 | 7359 | Jake Odorizzi | 25 | odorija01 | 2015 | TBR | AL | 4.546824894 | 3.15 | P | 15 | 1 | TBD | KCR | 2013 | 2017 | MIN |
7378 | 7378 | Kevin Jepsen | 30 | jepseke01 | 2015 | TBR | AL | 1.737718929 | 0.325 | P | 3 | 1 | TBD | ANA | 2015 | 2015 | MIN |
7421 | 7421 | Martin Perez | 24 | perezma02 | 2015 | TEX | AL | 2.19268688 | 0.94 | P | 6 | 1 | TEX | 2012 | 2018 | MIN | |
7506 | 7506 | Andrew Albers | 29 | alberan01 | 2015 | TOR | AL | 0.089580672 | -0.08 | P | 0 | 1 | TOR | MIN | 2015 | 2015 | MIN |
7617 | 7617 | Ervin Santana | 31 | santaer01 | 2014 | ATL | NL | 5.291494016 | 2.135 | P | 14 | 1 | ATL | KCR | 2014 | 2014 | MIN |
7638 | 7638 | Jordan Schafer | 27 | schafjo02 | 2014 | ATL | NL | 0.945155073 | -0.255 | LF, CF, RF | 1 | 1 | ATL | HOU | 2013 | 2014 | MIN |
7920 | 7920 | Austin Adams | 27 | adamsau01 | 2014 | CLE | AL | 0.116169466 | -0.08 | P | 0 | 1 | CLE | 2014 | 2016 | MIN | |
7992 | 7992 | Torii Hunter | 38 | hunteto01 | 2014 | DET | AL | 5.503238342 | 0.915 | RF | 10 | 1 | DET | ANA | 2013 | 2014 | MIN |
8034 | 8034 | Jason Castro | 27 | castrja01 | 2014 | HOU | AL | 4.922260898 | 1.775 | C | 12 | 1 | HOU | 2010 | 2016 | MIN | |
8038 | 8038 | Robbie Grossman | 24 | grossro01 | 2014 | HOU | AL | 4.057019725 | 1.11 | LF, RF, CF | 9 | 1 | HOU | 2013 | 2015 | MIN | |
8039 | 8039 | Marwin Gonzalez | 25 | gonzama01 | 2014 | HOU | AL | 2.980275153 | 1.39 | SS, 2B, 3B, LF, 1B, RF | 8 | 1 | HOU | 2012 | 2018 | MIN | |
8141 | 8141 | Hector Santiago | 26 | santihe01 | 2014 | LAA | AL | 3.482100432 | 0.515 | P | 7 | 1 | ANA | CHW | 2014 | 2016 | MIN |
8161 | 8161 | Drew Rucinski | 25 | rucindr01 | 2014 | LAA | AL | 0.113070321 | 0.045 | P | 0 | 1 | ANA | 2014 | 2015 | MIN | |
8296 | 8296 | Brandon Kintzler | 29 | kintzbr01 | 2014 | MIL | NL | 1.74149157 | 0.075 | P | 3 | 1 | MIL | 2010 | 2015 | MIN | |
8300 | 8300 | Logan Schafer | 27 | schaflo01 | 2014 | MIL | NL | 1.380952381 | -0.18 | LF, RF, CF | 2 | 1 | MIL | 2011 | 2015 | MIN |
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 );