mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
3,053 rows where next_franch = "CLE"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308 | 308 | Yasiel Puig | 28 | puigya01 | 2019 | CIN | NL | 4.169395018 | 0.820188679 | RF | 8 | 1 | CIN | LAD | 2019 | 2019 | CLE |
1128 | 1128 | Franmil Reyes | 23 | reyesfr01 | 2019 | SDP | NL | 3.645596591 | 0.67245283 | RF | 7 | 1 | SDP | 2018 | 2019 | CLE | |
1163 | 1163 | Logan Allen | 22 | allenlo01 | 2019 | SDP | NL | 0.681740409 | -0.219056604 | P | 0 | 1 | SDP | 2019 | 2019 | CLE | |
1167 | 1167 | Phil Maton | 26 | matonph01 | 2019 | SDP | NL | 0.58532255 | -0.397358491 | P | 0 | 1 | SDP | 2017 | 2019 | CLE | |
1380 | 1380 | Hunter Wood | 25 | woodhu01 | 2019 | TBR | AL | 0.728424089 | 0.336226415 | P | 2 | 1 | TBD | 2017 | 2019 | CLE | |
1400 | 1400 | Andrew Velazquez | 24 | velazan01 | 2019 | TBR | AL | 0.113189136 | -0.198679245 | 3B, 2B, CF, LF | 0 | 1 | TBD | 2018 | 2019 | CLE | |
1649 | 1649 | Ryan Flaherty | 31 | flahery01 | 2018 | ATL | NL | 1.782204964 | -0.61 | 3B, 1B, 2B | 1 | 1 | ATL | BAL | 2018 | 2018 | CLE |
1753 | 1753 | Hanley Ramirez | 34 | ramirha01 | 2018 | BOS | AL | 1.800382044 | -0.005 | 1B | 3 | 1 | BOS | LAD | 2015 | 2018 | CLE |
1816 | 1816 | Mike Freeman | 30 | freemmi01 | 2018 | CHC | NL | 0.009602649 | -0.099386503 | 2B | 0 | 1 | CHC | LAD | 2017 | 2018 | CLE |
1984 | 1984 | Carlos Gonzalez | 32 | gonzaca01 | 2018 | COL | NL | 5.002909464 | 1.073374233 | RF | 11 | 1 | COL | OAK | 2009 | 2018 | CLE |
2022 | 2022 | Leonys Martin | 30 | martile01 | 2018 | DET | AL | 3.242595674 | 2.0 | CF, RF | 10 | 1 | DET | CHC | 2018 | 2018 | CLE |
2099 | 2099 | James Hoyt | 31 | hoytja01 | 2018 | HOU | AL | 0.005070544 | 0.005 | P | 0 | 1 | HOU | 2016 | 2018 | CLE | |
2287 | 2287 | Nick Wittgren | 27 | wittgni01 | 2018 | MIA | NL | 0.88222086 | 0.311925466 | P | 2 | 1 | FLA | 2016 | 2018 | CLE | |
2359 | 2359 | Brad Miller | 28 | millebr02 | 2018 | MIL | NL | 0.784446323 | -0.094417178 | 1B, 2B, SS | 1 | 2 | MIL | TBD | 2018 | 2018 | CLE |
2363 | 2363 | Oliver Drake | 31 | drakeol01 | 2018 | MIL | NL | 0.311714452 | -0.029815951 | P | 0 | 1 | MIL | BAL | 2017 | 2018 | CLE |
2439 | 2439 | Kevin Plawecki | 27 | plaweke01 | 2018 | NYM | NL | 2.749144422 | 0.625 | C, 1B | 6 | 1 | NYM | 2015 | 2018 | CLE | |
2516 | 2516 | A.J. Cole | 26 | coleaj01 | 2018 | NYY | AL | 0.885545188 | -0.13 | P | 1 | 2 | NYY | WSN | 2018 | 2018 | CLE |
2586 | 2586 | Carlos Santana | 32 | santaca01 | 2018 | PHI | NL | 6.748115147 | 1.765 | 1B, 3B | 15 | 1 | PHI | CLE | 2018 | 2018 | CLE |
2657 | 2657 | Jordan Luplow | 24 | luplojo01 | 2018 | PIT | NL | 1.038775865 | 0.191180124 | LF, RF, CF | 2 | 1 | PIT | 2017 | 2018 | CLE | |
2661 | 2661 | Max Moroff | 25 | morofma01 | 2018 | PIT | NL | 0.675708572 | 0.005031056 | 2B, SS | 1 | 1 | PIT | 2016 | 2018 | CLE | |
2674 | 2674 | George Kontos | 33 | kontoge01 | 2018 | PIT | NL | 0.689898937 | -0.387391304 | P | 0 | 1 | PIT | SFG | 2017 | 2018 | CLE |
2689 | 2689 | Franmil Reyes | 22 | reyesfr01 | 2018 | SDP | NL | 2.866805411 | 1.385 | RF | 8 | 1 | SDP | 2018 | 2019 | CLE | |
2698 | 2698 | Adam Cimber | 27 | cimbead01 | 2018 | SDP | NL | 1.452477574 | 0.775 | P | 4 | 1 | SDP | 2018 | 2018 | CLE | |
2700 | 2700 | Brad Hand | 28 | handbr01 | 2018 | SDP | NL | 1.889043144 | 0.285 | P | 4 | 1 | SDP | FLA | 2016 | 2018 | CLE |
2705 | 2705 | Phil Maton | 25 | matonph01 | 2018 | SDP | NL | 1.344582087 | 0.155 | P | 2 | 1 | SDP | 2017 | 2019 | CLE | |
2779 | 2779 | Marc Rzepczynski | 32 | rzepcma01 | 2018 | SEA | AL | 0.240219777 | -0.485 | P | 0 | 1 | SEA | WSN | 2017 | 2018 | CLE |
2892 | 2892 | Jake Bauers | 22 | bauerja01 | 2018 | TBR | AL | 3.645553216 | 0.625 | 1B, LF, RF | 7 | 1 | TBD | 2018 | 2018 | CLE | |
2907 | 2907 | Hunter Wood | 24 | woodhu01 | 2018 | TBR | AL | 1.11023646 | 0.42 | P | 3 | 1 | TBD | 2017 | 2019 | CLE | |
2915 | 2915 | Andrew Velazquez | 23 | velazan01 | 2018 | TBR | AL | 0.112749069 | 0.28 | 3B, 2B, CF, SS, LF, RF | 1 | 1 | TBD | 2018 | 2019 | CLE | |
2998 | 2998 | Tyler Clippard | 33 | clippty01 | 2018 | TOR | AL | 2.436161162 | 0.91 | P | 6 | 1 | TOR | HOU | 2018 | 2018 | CLE |
3003 | 3003 | Josh Donaldson | 32 | donaljo02 | 2018 | TOR | AL | 1.523793787 | 0.67 | 3B, 1B | 4 | 1 | TOR | OAK | 2015 | 2018 | CLE |
3079 | 3079 | Jefry Rodriguez | 24 | rodrije01 | 2018 | WSN | NL | 1.43078161 | -0.21 | P | 1 | 1 | WSN | 2018 | 2018 | CLE | |
3142 | 3142 | Adam Rosales | 34 | rosalad01 | 2017 | ARI | NL | 0.878787879 | -0.375 | SS, 3B, 2B, 1B, LF | 0 | 2 | ARI | OAK | 2017 | 2017 | CLE |
3255 | 3255 | Hanley Ramirez | 33 | ramirha01 | 2017 | BOS | AL | 5.079018211 | -0.38 | 1B | 7 | 1 | BOS | LAD | 2015 | 2018 | CLE |
3284 | 3284 | Ben Taylor | 24 | taylobe10 | 2017 | BOS | AL | 0.500441264 | -0.09 | P | 0 | 1 | BOS | 2017 | 2017 | CLE | |
3285 | 3285 | Rajai Davis | 36 | davisra01 | 2017 | BOS | AL | 0.349010293 | -0.125 | CF, LF, RF | 0 | 2 | BOS | OAK | 2017 | 2017 | CLE |
3331 | 3331 | Mike Freeman | 29 | freemmi01 | 2017 | CHC | NL | 0.263947413 | -0.105 | SS, 1B, 2B, 3B, P | 0 | 3 | CHC | LAD | 2017 | 2018 | CLE |
3490 | 3490 | Carlos Gonzalez | 31 | gonzaca01 | 2017 | COL | NL | 5.281718963 | -0.15 | RF | 8 | 1 | COL | OAK | 2009 | 2018 | CLE |
3589 | 3589 | James Hoyt | 30 | hoytja01 | 2017 | HOU | AL | 1.285617961 | 0.365 | P | 3 | 1 | HOU | 2016 | 2018 | CLE | |
3644 | 3644 | Melky Cabrera | 32 | cabreme01 | 2017 | KCR | AL | 2.300666667 | -0.825 | LF, RF | 1 | 2 | KCR | CHW | 2017 | 2017 | CLE |
3788 | 3788 | Nick Wittgren | 26 | wittgni01 | 2017 | MIA | NL | 1.168425945 | 0.155 | P | 2 | 1 | FLA | 2016 | 2018 | CLE | |
3836 | 3836 | Oliver Drake | 30 | drakeol01 | 2017 | MIL | NL | 1.468846256 | 0.33 | P | 3 | 2 | MIL | BAL | 2017 | 2018 | CLE |
3882 | 3882 | Matt Belisle | 37 | belisma01 | 2017 | MIN | AL | 2.261301122 | 0.35 | P | 4 | 1 | MIN | WSN | 2017 | 2017 | CLE |
3892 | 3892 | Craig Breslow | 36 | breslcr01 | 2017 | MIN | AL | 0.700893588 | -0.095 | P | 1 | 1 | MIN | FLA | 2017 | 2017 | CLE |
3916 | 3916 | Jay Bruce | 30 | bruceja01 | 2017 | NYM | NL | 4.445508982 | 2.405 | RF, 1B | 13 | 1 | NYM | CIN | 2016 | 2017 | CLE |
3936 | 3936 | Kevin Plawecki | 26 | plaweke01 | 2017 | NYM | NL | 1.170915312 | 0.325 | C, 1B, P | 3 | 1 | NYM | 2015 | 2018 | CLE | |
3955 | 3955 | Neil Ramirez | 28 | ramirne01 | 2017 | NYM | NL | 0.486290724 | -0.21 | P | 0 | 2 | NYM | SFG | 2017 | 2017 | CLE |
4138 | 4138 | Max Moroff | 24 | morofma01 | 2017 | PIT | NL | 1.396869087 | 0.6 | 2B, SS, 3B | 4 | 1 | PIT | 2016 | 2018 | CLE | |
4144 | 4144 | George Kontos | 32 | kontoge01 | 2017 | PIT | NL | 0.49972717 | 0.47 | P | 2 | 2 | PIT | SFG | 2017 | 2018 | CLE |
4163 | 4163 | Jordan Luplow | 23 | luplojo01 | 2017 | PIT | NL | 0.868054361 | -0.42 | RF, LF | 0 | 1 | PIT | 2017 | 2018 | CLE | |
4173 | 4173 | Brad Hand | 27 | handbr01 | 2017 | SDP | NL | 3.183267339 | 2.345 | P | 12 | 1 | SDP | FLA | 2016 | 2018 | CLE |
4195 | 4195 | Phil Maton | 24 | matonph01 | 2017 | SDP | NL | 1.367285749 | -0.135 | P | 2 | 1 | SDP | 2017 | 2019 | CLE | |
4242 | 4242 | Yonder Alonso | 30 | alonsyo01 | 2017 | SEA | AL | 1.41716892 | 0.49 | 1B | 3 | 2 | SEA | OAK | 2017 | 2017 | CLE |
4245 | 4245 | Marc Rzepczynski | 31 | rzepcma01 | 2017 | SEA | AL | 1.21008581 | 0.1 | P | 2 | 1 | SEA | WSN | 2017 | 2018 | CLE |
4272 | 4272 | Evan Marshall | 27 | marshev01 | 2017 | SEA | AL | 0.158819447 | -0.18 | P | 0 | 1 | SEA | ARI | 2017 | 2017 | CLE |
4420 | 4420 | Hunter Wood | 23 | woodhu01 | 2017 | TBR | AL | 0.005303854 | 0.005 | P | 0 | 1 | TBD | 2017 | 2019 | CLE | |
4483 | 4483 | Josh Donaldson | 31 | donaljo02 | 2017 | TOR | AL | 4.692985318 | 5.045 | 3B, SS | 22 | 1 | TOR | OAK | 2015 | 2018 | CLE |
4502 | 4502 | Joe Smith | 33 | smithjo05 | 2017 | TOR | AL | 1.203146251 | 0.905 | P | 4 | 1 | TOR | CHC | 2017 | 2017 | CLE |
4535 | 4535 | Jeff Beliveau | 30 | belivje01 | 2017 | TOR | AL | 0.370162351 | -0.26 | P | 0 | 1 | TOR | TBD | 2017 | 2017 | CLE |
4566 | 4566 | Oliver Perez | 35 | perezol01 | 2017 | WSN | NL | 1.042953554 | 0.35 | P | 3 | 1 | WSN | HOU | 2016 | 2017 | CLE |
4675 | 4675 | Alexi Ogando | 32 | ogandal01 | 2016 | ATL | NL | 0.835564506 | -0.015093168 | P | 1 | 1 | ATL | BOS | 2016 | 2016 | CLE |
4756 | 4756 | Hanley Ramirez | 32 | ramirha01 | 2016 | BOS | AL | 5.714285714 | 2.915 | 1B | 15 | 1 | BOS | LAD | 2015 | 2018 | CLE |
4784 | 4784 | Michael Martinez | 33 | martimi02 | 2016 | BOS | AL | 0.064516129 | -0.02 | 2B, CF, LF, RF, SS, 3B | 0 | 2 | BOS | CLE | 2016 | 2016 | CLE |
4868 | 4868 | Austin Jackson | 29 | jacksau01 | 2016 | CHW | AL | 1.927320347 | -0.105 | CF | 2 | 1 | CHW | CHC | 2016 | 2016 | CLE |
4999 | 4999 | Carlos Gonzalez | 30 | gonzaca01 | 2016 | COL | NL | 6.213934565 | 2.48 | RF | 15 | 1 | COL | OAK | 2009 | 2018 | CLE |
5010 | 5010 | Boone Logan | 31 | loganbo02 | 2016 | COL | NL | 1.774448591 | 0.69 | P | 4 | 1 | COL | NYY | 2014 | 2016 | CLE |
5014 | 5014 | Brandon Barnes | 30 | barnebr02 | 2016 | COL | NL | 1.071707069 | 0.055 | LF, CF, RF | 2 | 1 | COL | HOU | 2014 | 2016 | CLE |
5118 | 5118 | James Hoyt | 29 | hoytja01 | 2016 | HOU | AL | 0.550522379 | -0.13 | P | 0 | 1 | HOU | 2016 | 2018 | CLE | |
5295 | 5295 | Nick Wittgren | 25 | wittgni01 | 2016 | MIA | NL | 1.501813667 | 0.548385093 | P | 4 | 1 | FLA | 2016 | 2018 | CLE | |
5460 | 5460 | Kevin Plawecki | 25 | plaweke01 | 2016 | NYM | NL | 1.512085635 | 0.145 | C | 2 | 1 | NYM | 2015 | 2018 | CLE | |
5461 | 5461 | Jay Bruce | 29 | bruceja01 | 2016 | NYM | NL | 1.872582873 | -0.125 | RF, CF | 2 | 2 | NYM | CIN | 2016 | 2017 | CLE |
5488 | 5488 | Andrew Miller | 31 | millean01 | 2016 | NYY | AL | 1.87022512 | 2.115 | P | 9 | 1 | NYY | BAL | 2015 | 2016 | CLE |
5509 | 5509 | Nick Goody | 24 | goodyni01 | 2016 | NYY | AL | 0.638076806 | 0.045 | P | 1 | 1 | NYY | 2015 | 2016 | CLE | |
5516 | 5516 | Tyler Olson | 26 | olsonty01 | 2016 | NYY | AL | 0.066415402 | -0.015 | P | 0 | 1 | NYY | SEA | 2016 | 2016 | CLE |
5543 | 5543 | Coco Crisp | 36 | crispco01 | 2016 | OAK | AL | 4.196732244 | 0.115 | LF, CF | 6 | 1 | OAK | KCR | 2010 | 2016 | CLE |
5670 | 5670 | Max Moroff | 23 | morofma01 | 2016 | PIT | NL | 0.01952862 | -0.025 | 0 | 1 | PIT | 2016 | 2018 | CLE | ||
5691 | 5691 | Brad Hand | 26 | handbr01 | 2016 | SDP | NL | 3.214542896 | 1.525 | P | 9 | 1 | SDP | FLA | 2016 | 2018 | CLE |
5790 | 5790 | Daniel Robertson | 30 | roberda09 | 2016 | SEA | AL | 0.196388262 | -0.225 | LF, RF, CF | 0 | 1 | SEA | ANA | 2016 | 2016 | CLE |
5899 | 5899 | Brandon Guyer | 30 | guyerbr01 | 2016 | TBR | AL | 2.398604883 | 0.72 | LF, CF, RF | 5 | 1 | TBD | 2011 | 2016 | CLE | |
5982 | 5982 | Josh Donaldson | 30 | donaljo02 | 2016 | TOR | AL | 6.548387097 | 7.575 | 3B | 31 | 1 | TOR | OAK | 2015 | 2018 | CLE |
5984 | 5984 | Edwin Encarnacion | 33 | encared01 | 2016 | TOR | AL | 6.567096774 | 3.88 | 1B | 20 | 1 | TOR | CIN | 2009 | 2016 | CLE |
6051 | 6051 | Oliver Perez | 34 | perezol01 | 2016 | WSN | NL | 1.285176312 | 0.25 | P | 3 | 1 | WSN | HOU | 2016 | 2017 | CLE |
6165 | 6165 | Chris Johnson | 30 | johnsch05 | 2015 | ATL | NL | 1.647842862 | -0.445 | 3B, 1B | 1 | 1 | ATL | ARI | 2013 | 2015 | CLE |
6183 | 6183 | Ross Detwiler | 29 | detwiro01 | 2015 | ATL | NL | 0.446778989 | -0.5 | P | 0 | 2 | ATL | TEX | 2015 | 2015 | CLE |
6261 | 6261 | Hanley Ramirez | 31 | ramirha01 | 2015 | BOS | AL | 4.014810045 | -1.245 | LF, 3B | 2 | 1 | BOS | LAD | 2015 | 2018 | CLE |
6328 | 6328 | Tommy Hunter | 28 | hunteto02 | 2015 | CHC | NL | 0.390571443 | -0.225 | P | 0 | 2 | CHC | BAL | 2015 | 2015 | CLE |
6473 | 6473 | Carlos Gonzalez | 29 | gonzaca01 | 2015 | COL | NL | 6.132869565 | 2.95 | RF | 17 | 1 | COL | OAK | 2009 | 2018 | CLE |
6489 | 6489 | Boone Logan | 30 | loganbo02 | 2015 | COL | NL | 1.226248611 | 0.435 | P | 3 | 1 | COL | NYY | 2014 | 2016 | CLE |
6504 | 6504 | Brandon Barnes | 29 | barnebr02 | 2015 | COL | NL | 2.834434783 | -0.83 | LF, RF, CF | 2 | 1 | COL | HOU | 2014 | 2016 | CLE |
6530 | 6530 | Rajai Davis | 34 | davisra01 | 2015 | DET | AL | 3.499673842 | 1.287950311 | CF, LF, RF | 9 | 1 | DET | TOR | 2014 | 2015 | CLE |
6552 | 6552 | Tom Gorzelanny | 32 | gorzeto01 | 2015 | DET | AL | 1.042643431 | -0.321987578 | P | 1 | 1 | DET | MIL | 2015 | 2015 | CLE |
6654 | 6654 | Joba Chamberlain | 29 | chambjo03 | 2015 | KCR | AL | 0.099153602 | -0.055 | P | 0 | 2 | KCR | DET | 2015 | 2015 | CLE |
6685 | 6685 | Collin Cowgill | 29 | cowgico01 | 2015 | LAA | AL | 0.719168901 | 0.29 | LF, CF, RF | 2 | 1 | ANA | NYM | 2013 | 2015 | CLE |
6925 | 6925 | Kevin Plawecki | 24 | plaweke01 | 2015 | NYM | NL | 2.583117556 | 1.015 | C | 7 | 1 | NYM | 2015 | 2018 | CLE | |
6931 | 6931 | Juan Uribe | 36 | uribeju01 | 2015 | NYM | NL | 1.431727948 | 0.675 | 3B, 2B | 4 | 3 | NYM | ATL | 2015 | 2015 | CLE |
6973 | 6973 | Andrew Miller | 30 | millean01 | 2015 | NYY | AL | 2.413855831 | 2.195 | P | 10 | 1 | NYY | BAL | 2015 | 2016 | CLE |
6996 | 6996 | Nick Goody | 23 | goodyni01 | 2015 | NYY | AL | 0.107111597 | 0.015 | P | 0 | 1 | NYY | 2015 | 2016 | CLE | |
7064 | 7064 | Dan Otero | 30 | oteroda01 | 2015 | OAK | AL | 1.271192548 | -0.58 | P | 0 | 1 | OAK | SFG | 2013 | 2015 | CLE |
7066 | 7066 | Coco Crisp | 35 | crispco01 | 2015 | OAK | AL | 1.310894309 | -0.67 | LF | 0 | 1 | OAK | KCR | 2010 | 2016 | CLE |
7200 | 7200 | Jon Edwards | 27 | edwarjo02 | 2015 | SDP | NL | 0.222010341 | -0.04 | P | 0 | 2 | SDP | TEX | 2015 | 2015 | CLE |
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 );