mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
952 rows where next_franch = "COL"
This data as json, copyable, CSV (advanced)
Suggested facets: age, lg_ID, quasi_ws, stint_ID, franch_id, prev_franch, year_left
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79 | 79 | Wes Parsons | 26 | parsowe01 | 2019 | ATL | NL | 0.507481968 | -0.045849057 | P | 1 | 1 | ATL | 2018 | 2019 | COL | |
297 | 297 | Yonder Alonso | 32 | alonsyo01 | 2019 | CHW | AL | 2.460784314 | -1.194493671 | 1B | 0 | 1 | CHW | CLE | 2019 | 2019 | COL |
946 | 946 | Joe Harvey | 27 | harvejo01 | 2019 | NYY | AL | 0.190112921 | 0.0 | P | 0 | 1 | NYY | 2019 | 2019 | COL | |
1659 | 1659 | Wes Parsons | 25 | parsowe01 | 2018 | ATL | NL | 0.15374886 | -0.1 | P | 0 | 1 | ATL | 2018 | 2019 | COL | |
1795 | 1795 | Daniel Murphy | 33 | murphda08 | 2018 | CHC | NL | 1.401986755 | 0.31803681 | 2B, 1B | 3 | 2 | CHC | WSN | 2018 | 2018 | COL |
2149 | 2149 | Drew Butera | 34 | buterdr01 | 2018 | KCR | AL | 1.593775865 | -0.71 | C, 1B, P | 0 | 1 | KCR | ANA | 2015 | 2018 | COL |
2747 | 2747 | James Pazos | 27 | pazosja01 | 2018 | SEA | AL | 1.544376062 | 0.64 | P | 4 | 1 | SEA | NYY | 2017 | 2018 | COL |
2997 | 2997 | Seunghwan Oh | 35 | ohse01 | 2018 | TOR | AL | 1.573629256 | 1.215 | P | 6 | 1 | TOR | STL | 2018 | 2018 | COL |
3067 | 3067 | Mark Reynolds | 34 | reynoma01 | 2018 | WSN | NL | 2.291911888 | -0.1 | 1B, 3B, 2B, CF, P, RF | 3 | 1 | WSN | COL | 2018 | 2018 | COL |
3109 | 3109 | Chris Iannetta | 34 | iannech01 | 2017 | ARI | NL | 3.120190671 | 2.06 | C, 3B | 11 | 1 | ARI | SEA | 2017 | 2017 | COL |
3306 | 3306 | Wade Davis | 31 | daviswa01 | 2017 | CHC | NL | 2.31612735 | 1.49 | P | 8 | 1 | CHC | KCR | 2017 | 2017 | COL |
3324 | 3324 | Zac Rosscup | 29 | rosscza01 | 2017 | CHC | NL | 0.013159814 | 0.01 | P | 0 | 1 | CHC | 2013 | 2017 | COL | |
3454 | 3454 | Bryan Shaw | 29 | shawbr01 | 2017 | CLE | AL | 2.599421333 | 1.07 | P | 6 | 1 | CLE | ARI | 2013 | 2017 | COL |
3643 | 3643 | Drew Butera | 33 | buterdr01 | 2017 | KCR | AL | 1.711 | -0.475 | C, 1B | 1 | 1 | KCR | ANA | 2015 | 2018 | COL |
3713 | 3713 | Brooks Pounders | 26 | poundbr01 | 2017 | LAA | AL | 0.20613704 | -0.3 | P | 0 | 1 | ANA | KCR | 2017 | 2017 | COL |
3987 | 3987 | Matt Holliday | 37 | hollima01 | 2017 | NYY | AL | 3.913098436 | -0.01 | 1B | 4 | 1 | NYY | STL | 2017 | 2017 | COL |
4080 | 4080 | Pat Neshek | 36 | neshepa01 | 2017 | PHI | NL | 1.435042939 | 1.88 | P | 7 | 1 | PHI | HOU | 2017 | 2017 | COL |
4206 | 4206 | Tim Melville | 27 | melviti01 | 2017 | SDP | NL | 0.050875749 | -0.055 | P | 0 | 2 | SDP | MIN | 2017 | 2017 | COL |
4243 | 4243 | James Pazos | 26 | pazosja01 | 2017 | SEA | AL | 1.778777804 | 0.085 | P | 3 | 1 | SEA | NYY | 2017 | 2018 | COL |
4454 | 4454 | Jonathan Lucroy | 31 | lucrojo01 | 2017 | TEX | AL | 2.912372826 | -0.47 | C, 1B | 3 | 1 | TEX | MIL | 2016 | 2017 | COL |
4699 | 4699 | Daniel Castro | 23 | castrda01 | 2016 | ATL | NL | 1.371554951 | -1.00621118 | SS, 2B, 3B | 0 | 1 | ATL | 2015 | 2016 | COL | |
4798 | 4798 | Ryan Hanigan | 35 | hanigry01 | 2016 | BOS | AL | 1.041474654 | -0.925 | C | 0 | 1 | BOS | TBD | 2015 | 2016 | COL |
4961 | 4961 | Bryan Shaw | 28 | shawbr01 | 2016 | CLE | AL | 2.348251337 | 0.825093168 | P | 6 | 1 | CLE | ARI | 2013 | 2017 | COL |
5149 | 5149 | Drew Butera | 32 | buterdr01 | 2016 | KCR | AL | 1.279058199 | 0.605 | C, 1B, P | 4 | 1 | KCR | ANA | 2015 | 2018 | COL |
5297 | 5297 | Mike Dunn | 31 | dunnmi01 | 2016 | MIA | NL | 1.341821457 | 0.422608696 | P | 3 | 1 | FLA | ATL | 2011 | 2016 | COL |
5723 | 5723 | Alexi Amarista | 27 | amarial01 | 2016 | SDP | NL | 1.528729573 | -0.575 | 2B, SS, 3B, LF, RF, P | 1 | 1 | SDP | ANA | 2012 | 2016 | COL |
5932 | 5932 | Ian Desmond | 30 | desmoia01 | 2016 | TEX | AL | 6.472061975 | 3.11 | CF, LF | 21 | 1 | TEX | WSN | 2016 | 2016 | COL |
5942 | 5942 | Jonathan Lucroy | 30 | lucrojo01 | 2016 | TEX | AL | 1.606065601 | 1.56 | C, 1B | 8 | 2 | TEX | MIL | 2016 | 2017 | COL |
5971 | 5971 | Chi Chi Gonzalez | 24 | gonzach01 | 2016 | TEX | AL | 0.287279982 | -0.265 | P | 0 | 1 | TEX | 2015 | 2016 | COL | |
6141 | 6141 | Daniel Castro | 22 | castrda01 | 2015 | ATL | NL | 1.017186952 | 0.385 | 2B, SS, 3B | 3 | 1 | ATL | 2015 | 2016 | COL | |
6220 | 6220 | Gerardo Parra | 28 | parrage01 | 2015 | BAL | AL | 2.306432749 | -0.73 | RF, LF, CF | 1 | 2 | BAL | MIL | 2015 | 2015 | COL |
6251 | 6251 | Ryan Hanigan | 34 | hanigry01 | 2015 | BOS | AL | 1.876690277 | 0.665 | C | 4 | 1 | BOS | TBD | 2015 | 2016 | COL |
6303 | 6303 | Jason Motte | 33 | motteja01 | 2015 | CHC | NL | 1.629822786 | 0.31 | P | 3 | 1 | CHC | STL | 2015 | 2015 | COL |
6315 | 6315 | Zac Rosscup | 27 | rosscza01 | 2015 | CHC | NL | 0.991439502 | -0.235 | P | 1 | 1 | CHC | 2013 | 2017 | COL | |
6322 | 6322 | Gonzalez Germen | 27 | germego01 | 2015 | CHC | NL | 0.148715925 | -0.045 | P | 0 | 1 | CHC | NYM | 2015 | 2015 | COL |
6438 | 6438 | Ryan Raburn | 34 | raburry01 | 2015 | CLE | AL | 1.915858669 | 1.167204969 | LF, RF, P | 6 | 1 | CLE | DET | 2013 | 2015 | COL |
6442 | 6442 | Bryan Shaw | 27 | shawbr01 | 2015 | CLE | AL | 2.316405735 | 0.689254658 | P | 5 | 1 | CLE | ARI | 2013 | 2017 | COL |
6595 | 6595 | Chad Qualls | 36 | quallch01 | 2015 | HOU | AL | 1.586173756 | 0.205 | P | 3 | 1 | HOU | FLA | 2014 | 2015 | COL |
6635 | 6635 | Greg Holland | 29 | hollagr01 | 2015 | KCR | AL | 1.816968562 | 0.54 | P | 5 | 1 | KCR | 2010 | 2015 | COL | |
6659 | 6659 | Drew Butera | 31 | buterdr01 | 2015 | KCR | AL | 0.94239291 | -0.37 | C, 1B | 0 | 2 | KCR | ANA | 2015 | 2018 | COL |
6787 | 6787 | Mike Dunn | 30 | dunnmi01 | 2015 | MIA | NL | 2.070118731 | 0.025 | P | 3 | 1 | FLA | ATL | 2011 | 2016 | COL |
7186 | 7186 | Alexi Amarista | 26 | amarial01 | 2015 | SDP | NL | 3.631357418 | -0.75 | SS, 2B, LF, CF, 3B, P | 3 | 1 | SDP | ANA | 2012 | 2016 | COL |
7325 | 7325 | Mark Reynolds | 31 | reynoma01 | 2015 | STL | NL | 4.330452817 | -0.28 | 1B, 3B, LF, 2B, RF | 6 | 1 | STL | MIL | 2015 | 2015 | COL |
7369 | 7369 | Jake McGee | 28 | mcgeeja01 | 2015 | TBR | AL | 1.434356052 | 1.04 | P | 5 | 1 | TBD | 2010 | 2015 | COL | |
7424 | 7424 | Chi Chi Gonzalez | 23 | gonzach01 | 2015 | TEX | AL | 1.907446796 | 0.5 | P | 5 | 1 | TEX | 2015 | 2016 | COL | |
7481 | 7481 | Jose Reyes | 32 | reyesjo01 | 2015 | TOR | AL | 2.906073788 | 0.715 | SS | 6 | 1 | TOR | FLA | 2013 | 2015 | COL |
7508 | 7508 | Miguel Castro | 20 | castrmi01 | 2015 | TOR | AL | 0.474573971 | -0.105 | P | 0 | 1 | TOR | 2015 | 2015 | COL | |
7630 | 7630 | David Hale | 26 | haleda02 | 2014 | ATL | NL | 2.256364887 | 0.15 | P | 4 | 1 | ATL | 2013 | 2014 | COL | |
7678 | 7678 | Nick Hundley | 30 | hundlni01 | 2014 | BAL | AL | 1.652259332 | 0.025 | C | 3 | 2 | BAL | SDP | 2014 | 2014 | COL |
7786 | 7786 | Chris Rusin | 27 | rusinch01 | 2014 | CHC | NL | 0.232273784 | -0.115 | P | 0 | 1 | CHC | 2012 | 2014 | COL | |
7789 | 7789 | Zac Rosscup | 26 | rosscza01 | 2014 | CHC | NL | 0.325341039 | -0.355 | P | 0 | 1 | CHC | 2013 | 2017 | COL | |
7901 | 7901 | Bryan Shaw | 26 | shawbr01 | 2014 | CLE | AL | 2.654772935 | 1.215 | P | 7 | 1 | CLE | ARI | 2013 | 2017 | COL |
7931 | 7931 | Ryan Raburn | 33 | raburry01 | 2014 | CLE | AL | 1.982905983 | -1.4 | RF, LF, 1B | 0 | 1 | CLE | DET | 2013 | 2015 | COL |
8018 | 8018 | Justin Miller | 27 | milleju02 | 2014 | DET | AL | 0.244382447 | -0.105 | P | 0 | 1 | DET | 2014 | 2014 | COL | |
8047 | 8047 | Chad Qualls | 35 | quallch01 | 2014 | HOU | AL | 1.891859949 | 0.47 | P | 4 | 1 | HOU | FLA | 2014 | 2015 | COL |
8089 | 8089 | Greg Holland | 28 | hollagr01 | 2014 | KCR | AL | 2.49083129 | 2.4 | P | 11 | 1 | KCR | 2010 | 2015 | COL | |
8159 | 8159 | Jairo Diaz | 23 | diazja01 | 2014 | LAA | AL | 0.084899714 | 0.08 | P | 0 | 1 | ANA | 2014 | 2014 | COL | |
8243 | 8243 | Mike Dunn | 29 | dunnmi01 | 2014 | MIA | NL | 2.243312905 | 0.635 | P | 5 | 1 | FLA | ATL | 2011 | 2016 | COL |
8517 | 8517 | Kyle Kendrick | 29 | kendrky01 | 2014 | PHI | NL | 5.433096404 | 0.735 | P | 9 | 1 | PHI | 2007 | 2014 | COL | |
8585 | 8585 | John Axford | 31 | axforjo01 | 2014 | PIT | NL | 0.257797515 | 0.055 | P | 1 | 2 | PIT | CLE | 2014 | 2014 | COL |
8608 | 8608 | Alexi Amarista | 25 | amarial01 | 2014 | SDP | NL | 4.834197818 | 1.38 | SS, 3B, 2B, CF, LF | 12 | 1 | SDP | ANA | 2012 | 2016 | COL |
8766 | 8766 | Daniel Descalso | 27 | descada01 | 2014 | STL | NL | 1.860529986 | -0.025 | 2B, SS, 3B, 1B, P | 3 | 1 | STL | 2010 | 2014 | COL | |
8775 | 8775 | Jorge Rondon | 26 | rondojo01 | 2014 | STL | NL | 0.014558142 | 0.015 | P | 0 | 1 | STL | 2014 | 2014 | COL | |
8797 | 8797 | Jake McGee | 27 | mcgeeja01 | 2014 | TBR | AL | 2.75641223 | 2.575 | P | 11 | 1 | TBD | 2010 | 2015 | COL | |
8898 | 8898 | Jose Reyes | 31 | reyesjo01 | 2014 | TOR | AL | 6.186288878 | 3.49 | SS | 19 | 1 | TOR | FLA | 2013 | 2015 | COL |
9060 | 9060 | David Hale | 25 | haleda02 | 2013 | ATL | NL | 0.306548675 | 0.52 | P | 2 | 1 | ATL | 2013 | 2014 | COL | |
9110 | 9110 | Jair Jurrjens | 27 | jurrjja01 | 2013 | BAL | AL | 0.180455611 | 0.055 | P | 0 | 1 | BAL | ATL | 2013 | 2013 | COL |
9126 | 9126 | Jason Pridie | 29 | pridija01 | 2013 | BAL | AL | 0.094802223 | -0.33 | CF, LF | 0 | 1 | BAL | PHI | 2013 | 2013 | COL |
9163 | 9163 | Franklin Morales | 27 | moralfr01 | 2013 | BOS | AL | 0.814364217 | -0.025 | P | 1 | 1 | BOS | COL | 2011 | 2013 | COL |
9204 | 9204 | Chris Rusin | 26 | rusinch01 | 2013 | CHC | NL | 1.853404073 | 0.34 | P | 3 | 1 | CHC | 2012 | 2014 | COL | |
9214 | 9214 | Zac Rosscup | 25 | rosscza01 | 2013 | CHC | NL | 0.138458692 | 0.055 | P | 0 | 1 | CHC | 2013 | 2017 | COL | |
9269 | 9269 | Simon Castro | 25 | castrsi01 | 2013 | CHW | AL | 0.150210538 | 0.075 | P | 0 | 1 | CHW | 2013 | 2013 | COL | |
9333 | 9333 | Ryan Raburn | 32 | raburry01 | 2013 | CLE | AL | 2.614908854 | 2.18 | RF, LF, 2B, P | 11 | 1 | CLE | DET | 2013 | 2015 | COL |
9335 | 9335 | Drew Stubbs | 28 | stubbdr01 | 2013 | CLE | AL | 4.540690104 | 0.905 | RF, CF | 10 | 1 | CLE | CIN | 2013 | 2013 | COL |
9341 | 9341 | Bryan Shaw | 25 | shawbr01 | 2013 | CLE | AL | 2.385715282 | 0.875 | P | 6 | 1 | CLE | ARI | 2013 | 2017 | COL |
9457 | 9457 | Brandon Barnes | 27 | barnebr02 | 2013 | HOU | AL | 4.305972639 | 1.125 | CF, RF, LF | 9 | 1 | HOU | 2012 | 2013 | COL | |
9467 | 9467 | Jordan Lyles | 22 | lylesjo01 | 2013 | HOU | AL | 4.275610032 | -0.43 | P | 4 | 1 | HOU | 2011 | 2013 | COL | |
9509 | 9509 | Greg Holland | 27 | hollagr01 | 2013 | KCR | AL | 2.748049992 | 3.105 | P | 13 | 1 | KCR | 2010 | 2015 | COL | |
9653 | 9653 | Mike Dunn | 28 | dunnmi01 | 2013 | MIA | NL | 2.385315925 | 1.26 | P | 7 | 1 | FLA | ATL | 2011 | 2016 | COL |
9778 | 9778 | Pedro Hernandez | 24 | hernape02 | 2013 | MIN | AL | 1.543459282 | -0.55 | P | 0 | 1 | MIN | CHW | 2013 | 2013 | COL |
9792 | 9792 | LaTroy Hawkins | 40 | hawkila01 | 2013 | NYM | NL | 2.312983255 | 0.92 | P | 6 | 1 | NYM | ANA | 2013 | 2013 | COL |
9828 | 9828 | Collin McHugh | 26 | mchugco01 | 2013 | NYM | NL | 0.132488971 | -0.235 | P | 0 | 1 | NYM | 2012 | 2013 | COL | |
9856 | 9856 | Boone Logan | 28 | loganbo02 | 2013 | NYY | AL | 1.310213659 | 0.35 | P | 3 | 1 | NYY | ATL | 2010 | 2013 | COL |
9918 | 9918 | Brett Anderson | 25 | anderbr04 | 2013 | OAK | AL | 1.273589793 | -0.165 | P | 2 | 1 | OAK | 2009 | 2013 | COL | |
9939 | 9939 | Kyle Kendrick | 28 | kendrky01 | 2013 | PHI | NL | 5.216433597 | 1.295 | P | 12 | 1 | PHI | 2007 | 2014 | COL | |
10012 | 10012 | Justin Morneau | 32 | morneju01 | 2013 | PIT | NL | 0.921907395 | 0.04 | 1B | 2 | 2 | PIT | MIN | 2013 | 2013 | COL |
10032 | 10032 | Michael McKenry | 28 | mckenmi01 | 2013 | PIT | NL | 1.222529371 | -0.66 | C | 0 | 1 | PIT | COL | 2011 | 2013 | COL |
10048 | 10048 | Alexi Amarista | 24 | amarial01 | 2013 | SDP | NL | 3.969581749 | 0.05 | CF, 2B, SS, LF, 3B | 6 | 1 | SDP | ANA | 2012 | 2016 | COL |
10190 | 10190 | Daniel Descalso | 26 | descada01 | 2013 | STL | NL | 3.561578045 | 0.075 | SS, 2B, 3B | 6 | 1 | STL | 2010 | 2014 | COL | |
10215 | 10215 | Mitchell Boggs | 29 | boggsmi01 | 2013 | STL | NL | 0.441147147 | -1.015 | P | 0 | 1 | STL | 2008 | 2013 | COL | |
10238 | 10238 | Jake McGee | 26 | mcgeeja01 | 2013 | TBR | AL | 2.152581855 | 0.352822086 | P | 4 | 1 | TBD | 2010 | 2015 | COL | |
10309 | 10309 | Jose Reyes | 30 | reyesjo01 | 2013 | TOR | AL | 3.967673469 | 2.525 | SS | 13 | 1 | TOR | FLA | 2013 | 2015 | COL |
10348 | 10348 | Aaron Laffey | 28 | laffeaa01 | 2013 | TOR | AL | 0.074062723 | -0.075 | P | 0 | 2 | TOR | NYM | 2013 | 2013 | COL |
10431 | 10431 | Ryan Wheeler | 23 | wheelry01 | 2012 | ARI | NL | 1.194737753 | -0.23 | 3B, 1B | 1 | 1 | ARI | 2012 | 2012 | COL | |
10560 | 10560 | Franklin Morales | 26 | moralfr01 | 2012 | BOS | AL | 2.433420925 | 0.5 | P | 5 | 1 | BOS | COL | 2011 | 2013 | COL |
10621 | 10621 | Chris Volstad | 25 | volstch01 | 2012 | CHC | NL | 3.292032067 | -0.78 | P | 2 | 1 | CHC | FLA | 2012 | 2012 | COL |
10626 | 10626 | Chris Rusin | 25 | rusinch01 | 2012 | CHC | NL | 0.881909132 | -0.055 | P | 1 | 1 | CHC | 2012 | 2014 | COL | |
10629 | 10629 | Manny Corpas | 29 | corpama01 | 2012 | CHC | NL | 1.446305676 | -0.415 | P | 1 | 1 | CHC | COL | 2012 | 2012 | COL |
10883 | 10883 | Wilton Lopez | 28 | lopezwi01 | 2012 | HOU | NL | 2.447407914 | 1.845 | P | 9 | 1 | HOU | 2009 | 2012 | COL | |
10886 | 10886 | Jordan Lyles | 21 | lylesjo01 | 2012 | HOU | NL | 4.063025097 | 0.29 | P | 6 | 1 | HOU | 2011 | 2013 | COL |
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 );