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,498 rows where next_franch = "HOU"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | Zack Greinke | 35 | greinza01 | 2019 | ARI | NL | 4.10802053 | 5.023018868 | P | 21 | 1 | ARI | LAD | 2016 | 2019 | HOU |
246 | 246 | Martin Maldonado | 32 | maldoma01 | 2019 | CHC | NL | 0.131450488 | -0.244528302 | C, 1B | 0 | 2 | CHC | KCR | 2019 | 2019 | HOU |
1472 | 1472 | Aaron Sanchez | 26 | sanchaa01 | 2019 | TOR | AL | 3.321218306 | 0.331132075 | P | 5 | 1 | TOR | 2014 | 2019 | HOU | |
1476 | 1476 | Joe Biagini | 29 | biagijo01 | 2019 | TOR | AL | 1.654232648 | 0.53490566 | P | 4 | 1 | TOR | 2016 | 2019 | HOU | |
1567 | 1567 | Zack Greinke | 34 | greinza01 | 2018 | ARI | NL | 5.686187576 | 4.15 | P | 20 | 1 | ARI | LAD | 2016 | 2019 | HOU |
1932 | 1932 | Michael Brantley | 31 | brantmi02 | 2018 | CLE | AL | 5.833280204 | 3.54 | LF | 18 | 1 | CLE | 2009 | 2018 | HOU | |
2168 | 2168 | Martin Maldonado | 31 | maldoma01 | 2018 | LAA | AL | 2.763720013 | 0.835 | C | 6 | 1 | ANA | MIL | 2017 | 2018 | HOU |
2327 | 2327 | Wade Miley | 31 | mileywa01 | 2018 | MIL | NL | 2.195318998 | 1.485828221 | P | 8 | 1 | MIL | BAL | 2018 | 2018 | HOU |
2386 | 2386 | Ryan Pressly | 29 | pressry01 | 2018 | MIN | AL | 1.506037649 | 0.815 | P | 5 | 1 | MIN | 2013 | 2018 | HOU | |
2941 | 2941 | Robinson Chirinos | 34 | chiriro01 | 2018 | TEX | AL | 4.021484375 | 0.875 | C | 8 | 1 | TEX | TBD | 2013 | 2018 | HOU |
2985 | 2985 | Aledmys Diaz | 27 | diazal02 | 2018 | TOR | AL | 4.331791143 | 1.48 | SS, 3B | 11 | 1 | TOR | STL | 2018 | 2018 | HOU |
2995 | 2995 | Aaron Sanchez | 25 | sanchaa01 | 2018 | TOR | AL | 3.015636389 | 0.685 | P | 7 | 1 | TOR | 2014 | 2019 | HOU | |
3009 | 3009 | Roberto Osuna | 23 | osunaro01 | 2018 | TOR | AL | 0.581676609 | 0.51 | P | 2 | 1 | TOR | 2015 | 2018 | HOU | |
3018 | 3018 | Joe Biagini | 28 | biagijo01 | 2018 | TOR | AL | 2.034690649 | -0.495 | P | 2 | 1 | TOR | 2016 | 2019 | HOU | |
3099 | 3099 | Zack Greinke | 33 | greinza01 | 2017 | ARI | NL | 5.680345917 | 5.655 | P | 25 | 1 | ARI | LAD | 2016 | 2019 | HOU |
3316 | 3316 | Hector Rondon | 29 | rondohe01 | 2017 | CHC | NL | 1.60690376 | 0.205 | P | 3 | 1 | CHC | 2013 | 2017 | HOU | |
3362 | 3362 | Tyler Clippard | 32 | clippty01 | 2017 | CHW | AL | 0.386725973 | 0.4 | P | 2 | 2 | CHW | NYY | 2017 | 2017 | HOU |
3445 | 3445 | Michael Brantley | 30 | brantmi02 | 2017 | CLE | AL | 3.500724288 | 1.815 | LF | 10 | 1 | CLE | 2009 | 2018 | HOU | |
3461 | 3461 | Joe Smith | 33 | smithjo05 | 2017 | CLE | AL | 0.711200862 | 0.575 | P | 3 | 2 | CLE | TOR | 2017 | 2017 | HOU |
3519 | 3519 | Justin Verlander | 34 | verlaju01 | 2017 | DET | AL | 5.093543959 | 3.785 | P | 17 | 1 | DET | 2005 | 2017 | HOU | |
3665 | 3665 | Martin Maldonado | 30 | maldoma01 | 2017 | LAA | AL | 4.513879709 | 2.345 | C, 1B | 14 | 1 | ANA | MIL | 2017 | 2018 | HOU |
3668 | 3668 | Cameron Maybin | 30 | maybica01 | 2017 | LAA | AL | 3.708856576 | 1.495 | LF, CF, RF | 10 | 1 | ANA | DET | 2017 | 2017 | HOU |
3887 | 3887 | Ryan Pressly | 28 | pressry01 | 2017 | MIN | AL | 1.889281757 | 0.015 | P | 3 | 1 | MIN | 2013 | 2018 | HOU | |
4123 | 4123 | Gerrit Cole | 26 | colege01 | 2017 | PIT | NL | 5.805069318 | 3.165 | P | 18 | 1 | PIT | 2013 | 2017 | HOU | |
4309 | 4309 | Tim Federowicz | 29 | federti01 | 2017 | SFG | NL | 0.139542877 | 0.115 | C, 1B | 1 | 1 | SFG | CHC | 2017 | 2017 | HOU |
4441 | 4441 | Robinson Chirinos | 33 | chiriro01 | 2017 | TEX | AL | 2.9409255 | 2.31 | C | 11 | 1 | TEX | TBD | 2013 | 2018 | HOU |
4489 | 4489 | Roberto Osuna | 22 | osunaro01 | 2017 | TOR | AL | 2.568837518 | 2.13 | P | 10 | 1 | TOR | 2015 | 2018 | HOU | |
4492 | 4492 | Joe Biagini | 27 | biagijo01 | 2017 | TOR | AL | 4.002659154 | 0.585 | P | 8 | 1 | TOR | 2016 | 2019 | HOU | |
4503 | 4503 | Francisco Liriano | 33 | liriafr01 | 2017 | TOR | AL | 2.21205453 | 0.27 | P | 4 | 1 | TOR | PIT | 2016 | 2017 | HOU |
4516 | 4516 | Aaron Sanchez | 24 | sanchaa01 | 2017 | TOR | AL | 0.958190058 | -0.025 | P | 1 | 1 | TOR | 2014 | 2019 | HOU | |
4595 | 4595 | Zack Greinke | 32 | greinza01 | 2016 | ARI | NL | 4.344405154 | 2.59 | P | 14 | 1 | ARI | LAD | 2016 | 2019 | HOU |
4739 | 4739 | Ashur Tolliver | 28 | tollias01 | 2016 | BAL | AL | 0.098196513 | -0.035 | P | 0 | 1 | BAL | 2016 | 2016 | HOU | |
4819 | 4819 | Hector Rondon | 28 | rondohe01 | 2016 | CHC | NL | 1.851895161 | 0.515 | P | 4 | 1 | CHC | 2013 | 2017 | HOU | |
4932 | 4932 | Dayan Diaz | 27 | diazda01 | 2016 | CIN | NL | 0.170879471 | -0.355 | P | 0 | 1 | CIN | 2016 | 2016 | HOU | |
4985 | 4985 | Michael Brantley | 29 | brantmi02 | 2016 | CLE | AL | 0.40685155 | -0.075465839 | LF | 0 | 1 | CLE | 2009 | 2018 | HOU | |
5041 | 5041 | Justin Verlander | 33 | verlaju01 | 2016 | DET | AL | 6.43480128 | 6.324037267 | P | 28 | 1 | DET | 2005 | 2017 | HOU | |
5250 | 5250 | Josh Reddick | 29 | reddijo01 | 2016 | LAD | NL | 1.656859391 | -0.025 | RF | 2 | 2 | LAD | OAK | 2016 | 2016 | HOU |
5390 | 5390 | Ryan Pressly | 27 | pressry01 | 2016 | MIN | AL | 2.716601823 | 1.05 | P | 6 | 1 | MIN | 2013 | 2018 | HOU | |
5408 | 5408 | Juan Centeno | 26 | centeju01 | 2016 | MIN | AL | 1.791217629 | -0.085 | C | 2 | 1 | MIN | MIL | 2016 | 2016 | HOU |
5486 | 5486 | Brian McCann | 32 | mccanbr01 | 2016 | NYY | AL | 4.725285643 | 1.32 | C, 1B | 11 | 1 | NYY | ATL | 2014 | 2016 | HOU |
5601 | 5601 | Charlie Morton | 32 | mortoch02 | 2016 | PHI | NL | 0.487735205 | 0.335 | P | 2 | 1 | PHI | PIT | 2016 | 2016 | HOU |
5636 | 5636 | Gerrit Cole | 25 | colege01 | 2016 | PIT | NL | 3.266964614 | 2.255 | P | 11 | 1 | PIT | 2013 | 2017 | HOU | |
5748 | 5748 | Nori Aoki | 34 | aokino01 | 2016 | SEA | AL | 4.367300871 | 1.54 | LF, CF | 11 | 1 | SEA | SFG | 2016 | 2016 | HOU |
5952 | 5952 | Robinson Chirinos | 32 | chiriro01 | 2016 | TEX | AL | 1.625185429 | 0.445 | C | 4 | 1 | TEX | TBD | 2013 | 2018 | HOU |
5953 | 5953 | Carlos Beltran | 39 | beltrca01 | 2016 | TEX | AL | 1.969342344 | 0.085 | RF | 4 | 2 | TEX | NYY | 2016 | 2016 | HOU |
5983 | 5983 | Aaron Sanchez | 23 | sanchaa01 | 2016 | TOR | AL | 5.252974891 | 4.205 | P | 20 | 1 | TOR | 2014 | 2019 | HOU | |
5993 | 5993 | Roberto Osuna | 21 | osunaro01 | 2016 | TOR | AL | 2.912369602 | 1.91 | P | 10 | 1 | TOR | 2015 | 2018 | HOU | |
5997 | 5997 | Joe Biagini | 26 | biagijo01 | 2016 | TOR | AL | 1.989909522 | 0.985 | P | 6 | 1 | TOR | 2016 | 2019 | HOU | |
6000 | 6000 | Francisco Liriano | 32 | liriafr01 | 2016 | TOR | AL | 1.27754503 | 0.65 | P | 4 | 2 | TOR | PIT | 2016 | 2017 | HOU |
6098 | 6098 | Oliver Perez | 33 | perezol01 | 2015 | ARI | NL | 0.850493975 | 0.385 | P | 2 | 1 | ARI | SEA | 2014 | 2015 | HOU |
6294 | 6294 | Hector Rondon | 27 | rondohe01 | 2015 | CHC | NL | 2.884973667 | 1.82 | P | 10 | 1 | CHC | 2013 | 2017 | HOU | |
6427 | 6427 | Michael Brantley | 28 | brantmi02 | 2015 | CLE | AL | 5.68085456 | 3.471428571 | LF, CF | 17 | 1 | CLE | 2009 | 2018 | HOU | |
6528 | 6528 | Justin Verlander | 32 | verlaju01 | 2015 | DET | AL | 3.79693879 | 2.716770186 | P | 13 | 1 | DET | 2005 | 2017 | HOU | |
6824 | 6824 | Carlos Gomez | 29 | gomezca01 | 2015 | MIL | NL | 3.188933637 | 1.565 | CF, 2B | 9 | 1 | MIL | MIN | 2010 | 2015 | HOU |
6825 | 6825 | Mike Fiers | 30 | fiersmi01 | 2015 | MIL | NL | 3.454200563 | 1.255 | P | 9 | 1 | MIL | 2011 | 2015 | HOU | |
6889 | 6889 | Ryan Pressly | 26 | pressry01 | 2015 | MIN | AL | 0.829448599 | 0.58 | P | 3 | 1 | MIN | 2013 | 2018 | HOU | |
6964 | 6964 | Brian McCann | 31 | mccanbr01 | 2015 | NYY | AL | 4.971163089 | 2.7 | C, 1B | 15 | 1 | NYY | ATL | 2014 | 2016 | HOU |
7021 | 7021 | Scott Kazmir | 31 | kazmisc01 | 2015 | OAK | AL | 3.103475362 | 2.805 | P | 12 | 1 | OAK | CLE | 2014 | 2015 | HOU |
7075 | 7075 | Ken Giles | 24 | gileske01 | 2015 | PHI | NL | 2.586570314 | 1.915 | P | 9 | 1 | PHI | 2014 | 2015 | HOU | |
7106 | 7106 | Erik Kratz | 35 | kratzer01 | 2015 | PHI | NL | 0.232040355 | -0.055 | C, 1B | 0 | 2 | PHI | KCR | 2015 | 2015 | HOU |
7119 | 7119 | Gerrit Cole | 24 | colege01 | 2015 | PIT | NL | 5.541962514 | 4.9 | P | 24 | 1 | PIT | 2013 | 2017 | HOU | |
7418 | 7418 | Robinson Chirinos | 31 | chiriro01 | 2015 | TEX | AL | 2.56836983 | 1.315 | C | 8 | 1 | TEX | TBD | 2013 | 2018 | HOU |
7474 | 7474 | Roberto Osuna | 20 | osunaro01 | 2015 | TOR | AL | 2.691339323 | 1.57 | P | 8 | 1 | TOR | 2015 | 2018 | HOU | |
7475 | 7475 | Aaron Sanchez | 22 | sanchaa01 | 2015 | TOR | AL | 2.946644239 | 1.07 | P | 7 | 1 | TOR | 2014 | 2019 | HOU | |
7532 | 7532 | Doug Fister | 31 | fistedo01 | 2015 | WSN | NL | 2.996639495 | 0.375 | P | 5 | 1 | WSN | DET | 2014 | 2015 | HOU |
7576 | 7576 | Oliver Perez | 32 | perezol01 | 2014 | ARI | NL | 1.937315022 | 0.41 | P | 4 | 1 | ARI | SEA | 2014 | 2015 | HOU |
7591 | 7591 | Will Harris | 29 | harriwi10 | 2014 | ARI | NL | 0.789414222 | 0.12 | P | 1 | 1 | ARI | COL | 2013 | 2014 | HOU |
7619 | 7619 | Evan Gattis | 27 | gattiev01 | 2014 | ATL | NL | 4.075346066 | 2.17 | C | 12 | 1 | ATL | 2013 | 2014 | HOU | |
7752 | 7752 | Luis Valbuena | 28 | valbulu01 | 2014 | CHC | NL | 5.502254596 | 2.435 | 3B, 2B | 14 | 1 | CHC | CLE | 2012 | 2014 | HOU |
7758 | 7758 | Hector Rondon | 26 | rondohe01 | 2014 | CHC | NL | 2.304006084 | 1.67 | P | 8 | 1 | CHC | 2013 | 2017 | HOU | |
7790 | 7790 | Dan Straily | 25 | straida01 | 2014 | CHC | NL | 0.293053405 | -0.395 | P | 0 | 2 | CHC | OAK | 2014 | 2014 | HOU |
7791 | 7791 | Jose Veras | 33 | verasjo01 | 2014 | CHC | NL | 0.347030441 | -0.4 | P | 0 | 1 | CHC | DET | 2014 | 2014 | HOU |
7887 | 7887 | Michael Brantley | 27 | brantmi02 | 2014 | CLE | AL | 6.322851153 | 6.62 | LF, CF | 29 | 1 | CLE | 2009 | 2018 | HOU | |
7987 | 7987 | Justin Verlander | 31 | verlaju01 | 2014 | DET | AL | 5.857918354 | 2.145 | P | 14 | 1 | DET | 2005 | 2017 | HOU | |
8019 | 8019 | Danny Worth | 28 | worthda01 | 2014 | DET | AL | 0.431994819 | -0.11 | SS, 2B, P, 1B | 0 | 1 | DET | 2010 | 2014 | HOU | |
8135 | 8135 | Hank Conger | 26 | congeha01 | 2014 | LAA | AL | 2.409330564 | 1.78 | C | 9 | 1 | ANA | 2010 | 2014 | HOU | |
8169 | 8169 | Joe Thatcher | 32 | thatcjo01 | 2014 | LAA | AL | 0.185169622 | -0.14 | P | 0 | 2 | ANA | ARI | 2014 | 2014 | HOU |
8224 | 8224 | Roberto Hernandez | 33 | carmofa01 | 2014 | LAD | NL | 1.246685705 | -0.43 | P | 0 | 2 | LAD | PHI | 2014 | 2014 | HOU |
8267 | 8267 | Jake Marisnick | 23 | marisja01 | 2014 | MIA | NL | 0.504605937 | -0.235 | RF, CF, LF | 0 | 1 | FLA | 2013 | 2014 | HOU | |
8274 | 8274 | Carlos Gomez | 28 | gomezca01 | 2014 | MIL | NL | 6.539215686 | 5.12 | CF | 25 | 1 | MIL | MIN | 2010 | 2015 | HOU |
8285 | 8285 | Mike Fiers | 29 | fiersmi01 | 2014 | MIL | NL | 1.946987575 | 1.81 | P | 8 | 1 | MIL | 2011 | 2015 | HOU | |
8332 | 8332 | Sam Deduno | 30 | dedunsa01 | 2014 | MIN | AL | 2.312689759 | 0.29 | P | 4 | 1 | MIN | SDP | 2012 | 2014 | HOU |
8338 | 8338 | Ryan Pressly | 25 | pressry01 | 2014 | MIN | AL | 0.820156777 | 0.28 | P | 2 | 1 | MIN | 2013 | 2018 | HOU | |
8390 | 8390 | Kyle Farnsworth | 38 | farnsky01 | 2014 | NYM | NL | 0.677704865 | 0.04 | P | 1 | 1 | NYM | PIT | 2014 | 2014 | HOU |
8408 | 8408 | Brian McCann | 30 | mccanbr01 | 2014 | NYY | AL | 5.151725277 | 2.745 | C, 1B | 16 | 1 | NYY | ATL | 2014 | 2016 | HOU |
8466 | 8466 | Scott Kazmir | 30 | kazmisc01 | 2014 | OAK | AL | 5.275680012 | 2.64 | P | 15 | 1 | OAK | CLE | 2014 | 2015 | HOU |
8472 | 8472 | Jed Lowrie | 30 | lowrije01 | 2014 | OAK | AL | 5.279511097 | 1.3 | SS | 11 | 1 | OAK | HOU | 2013 | 2014 | HOU |
8478 | 8478 | Luke Gregerson | 30 | gregelu01 | 2014 | OAK | AL | 2.734013444 | 1.325 | P | 8 | 1 | OAK | SDP | 2014 | 2014 | HOU |
8518 | 8518 | Ken Giles | 23 | gileske01 | 2014 | PHI | NL | 1.512065641 | 1.91 | P | 8 | 1 | PHI | 2014 | 2015 | HOU | |
8564 | 8564 | Gerrit Cole | 23 | colege01 | 2014 | PIT | NL | 3.800169726 | 1.925 | P | 11 | 1 | PIT | 2013 | 2017 | HOU | |
8754 | 8754 | Pat Neshek | 33 | neshepa01 | 2014 | STL | NL | 2.484589601 | 2.14 | P | 10 | 1 | STL | OAK | 2014 | 2014 | HOU |
8837 | 8837 | Robinson Chirinos | 30 | chiriro01 | 2014 | TEX | AL | 3.265156562 | 1.98 | C | 10 | 1 | TEX | TBD | 2013 | 2018 | HOU |
8907 | 8907 | Colby Rasmus | 27 | rasmuco01 | 2014 | TOR | AL | 3.551213157 | 1.31 | CF | 9 | 1 | TOR | STL | 2011 | 2014 | HOU |
8914 | 8914 | Aaron Sanchez | 21 | sanchaa01 | 2014 | TOR | AL | 1.14422235 | 1.02 | P | 5 | 1 | TOR | 2014 | 2019 | HOU | |
8960 | 8960 | Doug Fister | 30 | fistedo01 | 2014 | WSN | NL | 4.517278028 | 2.685 | P | 14 | 1 | WSN | DET | 2014 | 2015 | HOU |
9008 | 9008 | Will Harris | 28 | harriwi10 | 2013 | ARI | NL | 1.511719779 | 0.81 | P | 5 | 1 | ARI | COL | 2013 | 2014 | HOU |
9024 | 9024 | Tony Sipp | 29 | sippto01 | 2013 | ARI | NL | 1.065344726 | -0.365 | P | 1 | 1 | ARI | CLE | 2013 | 2013 | HOU |
9047 | 9047 | Evan Gattis | 26 | gattiev01 | 2013 | ATL | NL | 3.83919598 | 1.47 | LF, C, 1B | 10 | 1 | ATL | 2013 | 2014 | HOU | |
9095 | 9095 | Scott Feldman | 30 | feldmsc01 | 2013 | BAL | AL | 2.481919886 | 0.855 | P | 6 | 2 | BAL | CHC | 2013 | 2013 | HOU |
9119 | 9119 | L.J. Hoes | 23 | hoeslj01 | 2013 | BAL | AL | 0.028440667 | -0.095 | RF, CF, LF | 0 | 1 | BAL | 2012 | 2013 | HOU |
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 );