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,281 rows where prev_franch = "CLE"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46 | 46 | Josh Donaldson | 33 | donaljo02 | 2019 | ATL | NL | 6.456566347 | 5.53754717 | 3B | 28 | 1 | ATL | CLE | 2019 | 2019 | |
63 | 63 | Josh Tomlin | 34 | tomlijo01 | 2019 | ATL | NL | 2.062272326 | 0.483962264 | P | 5 | 1 | ATL | CLE | 2019 | 2019 | |
248 | 248 | Carlos Gonzalez | 33 | gonzaca01 | 2019 | CHC | NL | 0.495467225 | -0.371886792 | LF, RF | 0 | 2 | CHC | CLE | 2019 | 2019 | |
263 | 263 | Evan Marshall | 29 | marshev01 | 2019 | CHW | AL | 1.92106139 | 1.097088608 | P | 6 | 1 | CHW | CLE | 2019 | 2019 | |
297 | 297 | Yonder Alonso | 32 | alonsyo01 | 2019 | CHW | AL | 2.460784314 | -1.194493671 | 1B | 0 | 1 | CHW | CLE | 2019 | 2019 | COL |
322 | 322 | Trevor Bauer | 28 | bauertr01 | 2019 | CIN | NL | 1.595575799 | 0.142641509 | P | 3 | 2 | CIN | CLE | 2019 | 2019 | |
414 | 414 | Bryan Shaw | 31 | shawbr01 | 2019 | COL | NL | 2.187203995 | 0.178301887 | P | 4 | 1 | COL | CLE | 2018 | 2019 | |
507 | 507 | Michael Brantley | 32 | brantmi02 | 2019 | HOU | AL | 5.841726619 | 4.340377358 | LF, RF | 20 | 1 | HOU | CLE | 2019 | 2019 | |
526 | 526 | Joe Smith | 35 | smithjo05 | 2019 | HOU | AL | 0.671687879 | 0.641886792 | P | 3 | 1 | HOU | CLE | 2018 | 2019 | |
650 | 650 | Cody Allen | 30 | allenco01 | 2019 | LAA | AL | 0.606837733 | -0.438113208 | P | 0 | 1 | ANA | CLE | 2019 | 2019 | |
734 | 734 | Josh Smith | 29 | smithjo08 | 2019 | MIA | NL | 0.068004527 | -0.101886792 | P | 0 | 2 | FLA | CLE | 2019 | 2019 | |
778 | 778 | Jesus Aguilar | 29 | aguilje01 | 2019 | MIL | NL | 2.583475009 | -0.341320755 | 1B, 3B | 3 | 1 | MIL | CLE | 2017 | 2019 | TBD |
847 | 847 | Austin Adams | 32 | adamsau01 | 2019 | MIN | AL | 0.039534947 | -0.117169811 | P | 0 | 1 | MIN | CLE | 2019 | 2019 | DET |
885 | 885 | Rajai Davis | 38 | davisra01 | 2019 | NYM | NL | 0.238356164 | 0.0 | LF, RF | 0 | 1 | NYM | CLE | 2019 | 2019 | |
1022 | 1022 | Brad Miller | 29 | millebr02 | 2019 | PHI | NL | 1.216852966 | 0.636792453 | 3B, LF, 2B, RF, SS | 4 | 2 | PHI | CLE | 2019 | 2019 | |
1085 | 1085 | Erik Gonzalez | 27 | gonzaer01 | 2019 | PIT | NL | 1.438016529 | 0.173207547 | SS, 3B, LF, CF | 3 | 1 | PIT | CLE | 2019 | 2019 | |
1086 | 1086 | Melky Cabrera | 34 | cabreme01 | 2019 | PIT | NL | 3.904614325 | -0.978113208 | RF, LF | 3 | 1 | PIT | CLE | 2019 | 2019 | |
1135 | 1135 | Francisco Mejia | 23 | mejiafr01 | 2019 | SDP | NL | 2.450994318 | 0.611320755 | C, LF | 5 | 1 | SDP | CLE | 2018 | 2019 | |
1177 | 1177 | Edwin Encarnacion | 36 | encared01 | 2019 | SEA | AL | 2.763270689 | 1.844150943 | 1B, 2B | 9 | 1 | SEA | CLE | 2019 | 2019 | NYY |
1228 | 1228 | Shawn Armstrong | 28 | armstsh01 | 2019 | SEA | AL | 0.11193408 | -0.219056604 | P | 0 | 1 | SEA | CLE | 2018 | 2019 | BAL |
1328 | 1328 | Andrew Miller | 34 | millean01 | 2019 | STL | NL | 2.210460624 | -0.198679245 | P | 3 | 1 | STL | CLE | 2019 | 2019 | |
1356 | 1356 | Yandy Diaz | 27 | diazya01 | 2019 | TBR | AL | 3.244755245 | 1.823773585 | 3B, 1B | 10 | 1 | TBD | CLE | 2019 | 2019 | |
1499 | 1499 | Neil Ramirez | 30 | ramirne01 | 2019 | TOR | AL | 0.248265563 | -0.061132075 | P | 0 | 2 | TOR | CLE | 2019 | 2019 | |
1526 | 1526 | Yan Gomes | 31 | gomesya01 | 2019 | WSN | NL | 3.535732736 | 1.034150943 | C, 1B | 8 | 1 | WSN | CLE | 2019 | 2019 | |
1904 | 1904 | Kyle Crockett | 26 | crockky01 | 2018 | CIN | NL | 0.315102363 | -0.045 | P | 0 | 1 | CIN | CLE | 2018 | 2018 | |
2004 | 2004 | Bryan Shaw | 30 | shawbr01 | 2018 | COL | NL | 1.62385713 | -0.680797546 | P | 1 | 1 | COL | CLE | 2018 | 2019 | |
2057 | 2057 | Zach McAllister | 30 | mcallza01 | 2018 | DET | AL | 0.091118237 | -0.235 | P | 0 | 2 | DET | CLE | 2018 | 2018 | |
2093 | 2093 | Joe Smith | 34 | smithjo05 | 2018 | HOU | AL | 1.375970171 | 0.305 | P | 3 | 1 | HOU | CLE | 2018 | 2019 | |
2148 | 2148 | Abraham Almonte | 29 | almonab01 | 2018 | KCR | AL | 1.449759974 | -0.6 | CF, RF, LF | 0 | 1 | KCR | CLE | 2018 | 2018 | ARI |
2197 | 2197 | Oliver Drake | 31 | drakeol01 | 2018 | LAA | AL | 0.193285254 | -0.01 | P | 0 | 3 | ANA | CLE | 2018 | 2018 | TOR |
2321 | 2321 | Jesus Aguilar | 28 | aguilje01 | 2018 | MIL | NL | 5.549957735 | 3.135644172 | 1B, 3B | 18 | 1 | MIL | CLE | 2017 | 2019 | TBD |
2365 | 2365 | Boone Logan | 33 | loganbo02 | 2018 | MIL | NL | 0.270216863 | -0.218650307 | P | 0 | 1 | MIL | CLE | 2018 | 2018 | |
2422 | 2422 | Matt Belisle | 38 | belisma01 | 2018 | MIN | AL | 0.543179036 | -0.545 | P | 0 | 2 | MIN | CLE | 2018 | 2018 | |
2443 | 2443 | Jay Bruce | 31 | bruceja01 | 2018 | NYM | NL | 3.582819986 | -0.16 | RF, 1B | 4 | 1 | NYM | CLE | 2018 | 2018 | SEA |
2518 | 2518 | George Kontos | 33 | kontoge01 | 2018 | NYY | AL | 0.032074076 | 0.09 | P | 0 | 3 | NYY | CLE | 2018 | 2018 | |
2586 | 2586 | Carlos Santana | 32 | santaca01 | 2018 | PHI | NL | 6.748115147 | 1.765 | 1B, 3B | 15 | 1 | PHI | CLE | 2018 | 2018 | CLE |
2711 | 2711 | Francisco Mejia | 22 | mejiafr01 | 2018 | SDP | NL | 0.583420049 | -0.08 | C | 1 | 2 | SDP | CLE | 2018 | 2019 | |
2750 | 2750 | Shawn Armstrong | 27 | armstsh01 | 2018 | SEA | AL | 0.455194944 | 0.42 | P | 2 | 1 | SEA | CLE | 2018 | 2019 | BAL |
2828 | 2828 | Austin Jackson | 31 | jacksau01 | 2018 | SFG | NL | 1.650284532 | -1.1 | CF, LF | 0 | 1 | SFG | CLE | 2018 | 2018 | NYM |
2924 | 2924 | Adam Moore | 34 | mooread01 | 2018 | TBR | AL | 0.187915114 | -0.04 | C | 0 | 1 | TBD | CLE | 2018 | 2018 | |
3037 | 3037 | Gio Urshela | 26 | urshegi01 | 2018 | TOR | AL | 0.440846001 | -0.15 | 3B, SS | 0 | 1 | TOR | CLE | 2018 | 2018 | NYY |
3212 | 3212 | Ubaldo Jimenez | 33 | jimenub01 | 2017 | BAL | AL | 3.90155539 | -0.625 | P | 4 | 1 | BAL | CLE | 2014 | 2017 | |
3411 | 3411 | Blake Wood | 31 | woodbl01 | 2017 | CIN | NL | 1.544169598 | -0.07 | P | 2 | 1 | CIN | CLE | 2016 | 2017 | ANA |
3826 | 3826 | Jesus Aguilar | 27 | aguilje01 | 2017 | MIL | NL | 3.099845334 | 1.12 | 1B, 3B | 8 | 1 | MIL | CLE | 2017 | 2019 | TBD |
3876 | 3876 | Chris Gimenez | 34 | gimench01 | 2017 | MIN | AL | 2.092352092 | 1.055 | C, 1B, P, LF, 3B | 6 | 1 | MIN | CLE | 2017 | 2017 | CHC |
4034 | 4034 | Rajai Davis | 36 | davisra01 | 2017 | OAK | AL | 3.117155497 | 0.3 | CF, LF, RF | 5 | 1 | OAK | CLE | 2017 | 2017 | BOS |
4429 | 4429 | Michael Martinez | 34 | martimi02 | 2017 | TBR | AL | 0.274746815 | -0.345 | 2B, 3B, CF, LF, P, SS | 0 | 2 | TBD | CLE | 2017 | 2017 | |
4448 | 4448 | Mike Napoli | 35 | napolmi01 | 2017 | TEX | AL | 4.616015753 | -0.67 | 1B | 5 | 1 | TEX | CLE | 2017 | 2017 | |
4519 | 4519 | T.J. House | 27 | housetj01 | 2017 | TOR | AL | 0.032736737 | 0.005 | P | 0 | 1 | TOR | CLE | 2017 | 2017 | |
4716 | 4716 | Ubaldo Jimenez | 32 | jimenub01 | 2016 | BAL | AL | 4.008006218 | 0.645 | P | 8 | 1 | BAL | CLE | 2014 | 2017 | |
4730 | 4730 | Tommy Hunter | 29 | hunteto02 | 2016 | BAL | AL | 0.351114424 | 0.3 | P | 1 | 2 | BAL | CLE | 2016 | 2016 | TBD |
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 |
4886 | 4886 | Jerry Sands | 28 | sandsje01 | 2016 | CHW | AL | 0.550662956 | -0.305 | 1B, LF, RF | 0 | 1 | CHW | CLE | 2016 | 2016 | |
4892 | 4892 | JB Shuck | 29 | shuckja01 | 2016 | CHW | AL | 2.288099525 | -1.61 | CF, LF, RF, P | 0 | 1 | CHW | CLE | 2015 | 2016 | FLA |
4902 | 4902 | Brandon Phillips | 35 | phillbr01 | 2016 | CIN | NL | 5.873417722 | 0.895 | 2B | 12 | 1 | CIN | CLE | 2006 | 2016 | ATL |
4909 | 4909 | Blake Wood | 30 | woodbl01 | 2016 | CIN | NL | 2.569764349 | 0.5 | P | 5 | 1 | CIN | CLE | 2016 | 2017 | ANA |
4921 | 4921 | Tyler Holt | 27 | holtty01 | 2016 | CIN | NL | 2.091902202 | -0.805 | CF, RF, LF, P | 1 | 1 | CIN | CLE | 2015 | 2016 | |
5016 | 5016 | Ryan Raburn | 35 | raburry01 | 2016 | COL | NL | 2.517036786 | -0.44 | LF, 1B, RF | 2 | 1 | COL | CLE | 2016 | 2016 | WSN |
5084 | 5084 | Mike Aviles | 35 | avilemi01 | 2016 | DET | AL | 1.719855832 | -1.323167702 | RF, 2B, 3B, LF, SS, CF | 0 | 1 | DET | CLE | 2016 | 2016 | FLA |
5197 | 5197 | Joe Smith | 32 | smithjo05 | 2016 | LAA | AL | 1.271562868 | 0.115 | P | 2 | 1 | ANA | CLE | 2014 | 2016 | CHC |
5268 | 5268 | Zach Walters | 26 | walteza01 | 2016 | LAD | NL | 0.049606569 | -0.16 | 1B, LF, RF | 0 | 1 | LAD | CLE | 2016 | 2016 | |
5307 | 5307 | Chris Johnson | 31 | johnsch05 | 2016 | MIA | NL | 2.632284683 | -0.880434783 | 1B, 3B, LF | 1 | 1 | FLA | CLE | 2016 | 2016 | |
5512 | 5512 | Anthony Swarzak | 30 | swarzan01 | 2016 | NYY | AL | 0.828919222 | -0.195 | P | 1 | 1 | NYY | CLE | 2016 | 2016 | CHW |
5560 | 5560 | Ross Detwiler | 30 | detwiro01 | 2016 | OAK | AL | 1.247471357 | 0.15 | P | 2 | 2 | OAK | CLE | 2016 | 2016 | SEA |
5625 | 5625 | Frank Herrmann | 32 | herrmfr01 | 2016 | PHI | NL | 0.408535915 | -0.65 | P | 0 | 1 | PHI | CLE | 2016 | 2016 | |
5757 | 5757 | Franklin Gutierrez | 33 | gutiefr01 | 2016 | SEA | AL | 2.646565624 | 0.66 | RF, LF | 6 | 1 | SEA | CLE | 2009 | 2016 | LAD |
5853 | 5853 | Brandon Moss | 32 | mossbr01 | 2016 | STL | NL | 4.563676446 | 1.05 | 1B, LF, RF | 9 | 1 | STL | CLE | 2015 | 2016 | KCR |
5920 | 5920 | Ryan Webb | 30 | webbry01 | 2016 | TBR | AL | 0.372862659 | -0.05 | P | 0 | 1 | TBD | CLE | 2016 | 2016 | |
6004 | 6004 | Gavin Floyd | 33 | floydga01 | 2016 | TOR | AL | 1.14747889 | 0.205 | P | 2 | 1 | TOR | CLE | 2016 | 2016 | |
6146 | 6146 | Michael Bourn | 32 | bournmi01 | 2015 | ATL | NL | 1.586811645 | -0.25 | CF, LF, RF | 2 | 2 | ATL | CLE | 2015 | 2015 | ARI |
6161 | 6161 | Nick Swisher | 34 | swishni01 | 2015 | ATL | NL | 1.515608558 | -0.275 | LF, 1B, RF | 1 | 2 | ATL | CLE | 2015 | 2015 | |
6188 | 6188 | Ubaldo Jimenez | 31 | jimenub01 | 2015 | BAL | AL | 5.250521369 | 2.52 | P | 15 | 1 | BAL | CLE | 2014 | 2017 | |
6353 | 6353 | JB Shuck | 28 | shuckja01 | 2015 | CHW | AL | 1.582602944 | 0.36 | RF, CF, LF | 3 | 1 | CHW | CLE | 2015 | 2016 | FLA |
6375 | 6375 | Brandon Phillips | 34 | phillbr01 | 2015 | CIN | NL | 6.167264038 | 2.93 | 2B, SS | 16 | 1 | CIN | CLE | 2006 | 2016 | ATL |
6407 | 6407 | Tyler Holt | 26 | holtty01 | 2015 | CIN | NL | 0.128690903 | -0.03 | CF, LF, RF | 0 | 2 | CIN | CLE | 2015 | 2016 | |
6499 | 6499 | Drew Stubbs | 30 | stubbdr01 | 2015 | COL | NL | 1.149913043 | 0.13 | CF, LF, RF | 2 | 1 | COL | CLE | 2014 | 2015 | TEX |
6501 | 6501 | Rafael Betancourt | 40 | betanra01 | 2015 | COL | NL | 1.233927188 | -0.015 | P | 2 | 1 | COL | CLE | 2009 | 2015 | |
6676 | 6676 | Joe Smith | 31 | smithjo05 | 2015 | LAA | AL | 2.533645471 | 0.74 | P | 6 | 1 | ANA | CLE | 2014 | 2016 | CHC |
6687 | 6687 | David Murphy | 33 | murphda07 | 2015 | LAA | AL | 1.574396783 | -0.205 | LF, RF, P | 2 | 2 | ANA | CLE | 2015 | 2015 | |
6707 | 6707 | Vinnie Pestano | 30 | pestavi01 | 2015 | LAA | AL | 0.338890803 | -0.29 | P | 0 | 1 | ANA | CLE | 2014 | 2015 | |
7021 | 7021 | Scott Kazmir | 31 | kazmisc01 | 2015 | OAK | AL | 3.103475362 | 2.805 | P | 12 | 1 | OAK | CLE | 2014 | 2015 | HOU |
7207 | 7207 | Marc Rzepczynski | 29 | rzepcma01 | 2015 | SDP | NL | 0.509521895 | -0.39 | P | 0 | 2 | SDP | CLE | 2015 | 2015 | OAK |
7218 | 7218 | Franklin Gutierrez | 32 | gutiefr01 | 2015 | SEA | AL | 1.795283328 | 2.34 | LF, RF | 10 | 1 | SEA | CLE | 2009 | 2016 | LAD |
7227 | 7227 | Mark Lowe | 32 | lowema01 | 2015 | SEA | AL | 1.165182819 | 1.275 | P | 5 | 1 | SEA | CLE | 2015 | 2015 | TOR |
7327 | 7327 | Brandon Moss | 31 | mossbr01 | 2015 | STL | NL | 1.513653647 | 0.415 | RF, 1B, LF | 4 | 2 | STL | CLE | 2015 | 2016 | KCR |
7425 | 7425 | Chris Gimenez | 32 | gimench01 | 2015 | TEX | AL | 1.063098135 | 0.695 | C | 4 | 1 | TEX | CLE | 2015 | 2015 | CLE |
7600 | 7600 | Andy Marte | 30 | martean01 | 2014 | ARI | NL | 0.161111111 | -0.13 | 3B | 0 | 1 | ARI | CLE | 2014 | 2014 | |
7670 | 7670 | Ubaldo Jimenez | 30 | jimenub01 | 2014 | BAL | AL | 3.320282623 | 0.065 | P | 5 | 1 | BAL | CLE | 2014 | 2017 | |
7685 | 7685 | Preston Guilmet | 26 | guilmpr01 | 2014 | BAL | AL | 0.248591603 | -0.05 | P | 0 | 1 | BAL | CLE | 2014 | 2014 | TBD |
7686 | 7686 | Cord Phelps | 27 | phelpco01 | 2014 | BAL | AL | 0.02848723 | -0.1 | 0 | 1 | BAL | CLE | 2014 | 2014 | ||
7723 | 7723 | Grady Sizemore | 31 | sizemgr01 | 2014 | BOS | AL | 1.91588785 | -0.185 | LF, CF, RF | 2 | 1 | BOS | CLE | 2014 | 2014 | PHI |
7752 | 7752 | Luis Valbuena | 28 | valbulu01 | 2014 | CHC | NL | 5.502254596 | 2.435 | 3B, 2B | 14 | 1 | CHC | CLE | 2012 | 2014 | HOU |
7848 | 7848 | Brandon Phillips | 33 | phillbr01 | 2014 | CIN | NL | 5.145244444 | 1.52 | 2B | 12 | 1 | CIN | CLE | 2006 | 2016 | ATL |
7879 | 7879 | Jack Hannahan | 34 | hannaja01 | 2014 | CIN | NL | 0.515555556 | -0.32 | 1B | 0 | 1 | CIN | CLE | 2013 | 2014 | |
7936 | 7936 | Drew Stubbs | 29 | stubbdr01 | 2014 | COL | NL | 4.216735254 | 2.655 | CF | 13 | 1 | COL | CLE | 2014 | 2015 | TEX |
8004 | 8004 | Ezequiel Carrera | 27 | carreez01 | 2014 | DET | AL | 0.685556995 | 0.41 | CF, LF | 2 | 1 | DET | CLE | 2014 | 2014 | TOR |
8052 | 8052 | Matt Albers | 31 | alberma01 | 2014 | HOU | AL | 0.347570089 | 0.36 | P | 2 | 1 | HOU | CLE | 2014 | 2014 | CHW |
8136 | 8136 | Joe Smith | 30 | smithjo05 | 2014 | LAA | AL | 2.682656409 | 1.75 | P | 9 | 1 | ANA | CLE | 2014 | 2016 | CHC |
8152 | 8152 | Vinnie Pestano | 29 | pestavi01 | 2014 | LAA | AL | 0.258723514 | 0.245 | P | 1 | 2 | ANA | CLE | 2014 | 2015 | |
8163 | 8163 | Rich Hill | 34 | hillri01 | 2014 | LAA | AL | 0.0 | 0.0 | P | 0 | 1 | ANA | CLE | 2014 | 2014 | NYY |
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 );