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,132 rows where prev_franch = "HOU"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53 | 53 | Dallas Keuchel | 31 | keuchda01 | 2019 | ATL | NL | 3.028895095 | 1.599622642 | P | 10 | 1 | ATL | HOU | 2019 | 2019 | |
57 | 57 | Mike Foltynewicz | 27 | foltymi01 | 2019 | ATL | NL | 3.195932885 | 0.641886792 | P | 8 | 1 | ATL | HOU | 2015 | 2019 | |
59 | 59 | Brian McCann | 35 | mccanbr01 | 2019 | ATL | NL | 3.074555404 | 0.646981132 | C | 7 | 1 | ATL | HOU | 2019 | 2019 | |
234 | 234 | Tony Kemp | 27 | kempto01 | 2019 | CHC | NL | 0.788702929 | -0.091698113 | 2B, LF, CF | 1 | 2 | CHC | HOU | 2019 | 2019 | |
293 | 293 | AJ Reed | 26 | reedaj01 | 2019 | CHW | AL | 0.480392157 | -0.51778481 | 1B, P | 0 | 1 | CHW | HOU | 2019 | 2019 | |
378 | 378 | James Hoyt | 32 | hoytja01 | 2019 | CLE | AL | 0.174234553 | 0.091698113 | P | 1 | 1 | CLE | HOU | 2019 | 2019 | |
472 | 472 | Jose Cisnero | 30 | cisnejo01 | 2019 | DET | AL | 1.07587827 | 0.184556962 | P | 2 | 1 | DET | HOU | 2019 | 2019 | |
559 | 559 | Martin Maldonado | 32 | maldoma01 | 2019 | KCR | AL | 2.559825474 | 0.911886792 | C, 1B | 6 | 1 | KCR | HOU | 2019 | 2019 | CHC |
649 | 649 | Nick Tropeano | 28 | tropeni01 | 2019 | LAA | AL | 0.362705827 | -0.433018868 | P | 0 | 1 | ANA | HOU | 2015 | 2019 | |
653 | 653 | Max Stassi | 28 | stassma01 | 2019 | LAA | AL | 0.463697177 | -0.53490566 | C, 1B, P | 0 | 2 | ANA | HOU | 2019 | 2019 | |
701 | 701 | Tyler White | 28 | whitety01 | 2019 | LAD | NL | 0.259865587 | -0.433018868 | 1B, P | 0 | 2 | LAD | HOU | 2019 | 2019 | |
815 | 815 | Marwin Gonzalez | 30 | gonzama01 | 2019 | MIN | AL | 4.282934609 | 1.518113208 | RF, 3B, 1B, LF, 2B, SS | 11 | 1 | MIN | HOU | 2019 | 2019 | |
819 | 819 | Jason Castro | 32 | castrja01 | 2019 | MIN | AL | 2.516108453 | 1.054528302 | C | 7 | 1 | MIN | HOU | 2017 | 2019 | |
863 | 863 | J.D. Davis | 26 | davisjd01 | 2019 | NYM | NL | 4.389726027 | 1.502830189 | LF, 3B | 10 | 1 | NYM | HOU | 2019 | 2019 | |
1018 | 1018 | Vince Velasquez | 27 | velasvi01 | 2019 | PHI | NL | 3.380091972 | 0.825283019 | P, LF | 8 | 1 | PHI | HOU | 2016 | 2019 | |
1067 | 1067 | Joe Musgrove | 26 | musgrjo01 | 2019 | PIT | NL | 5.062373469 | 2.649056604 | P | 15 | 1 | PIT | HOU | 2018 | 2019 | |
1074 | 1074 | Colin Moran | 26 | moranco01 | 2019 | PIT | NL | 5.023071625 | -0.157924528 | 3B, 2B, 1B, LF | 7 | 1 | PIT | HOU | 2018 | 2019 | |
1081 | 1081 | Michael Feliz | 26 | felizmi01 | 2019 | PIT | NL | 1.736921173 | 0.320943396 | P | 4 | 1 | PIT | HOU | 2018 | 2019 | |
1265 | 1265 | Jandel Gustave | 26 | gustaja01 | 2019 | SFG | NL | 0.810898373 | 0.346415094 | P | 2 | 1 | SFG | HOU | 2019 | 2019 | |
1333 | 1333 | Luke Gregerson | 35 | gregelu01 | 2019 | STL | NL | 0.090814859 | 0.00509434 | P | 0 | 1 | STL | HOU | 2018 | 2019 | |
1345 | 1345 | Charlie Morton | 35 | mortoch02 | 2019 | TBR | AL | 5.224941733 | 5.67509434 | P | 24 | 1 | TBD | HOU | 2019 | 2019 | |
1463 | 1463 | Ken Giles | 28 | gileske01 | 2019 | TOR | AL | 2.030237377 | 2.139622642 | P | 9 | 1 | TOR | HOU | 2018 | 2019 | |
1466 | 1466 | Teoscar Hernandez | 26 | hernate01 | 2019 | TOR | AL | 4.403955749 | 0.596037736 | CF, LF | 8 | 1 | TOR | HOU | 2017 | 2019 | |
1495 | 1495 | Derek Fisher | 25 | fishede01 | 2019 | TOR | AL | 1.001340932 | -0.178301887 | LF, RF, CF | 1 | 2 | TOR | HOU | 2019 | 2019 | |
1542 | 1542 | Tony Sipp | 35 | sippto01 | 2019 | WSN | NL | 0.663277908 | 0.188490566 | P | 1 | 1 | WSN | HOU | 2019 | 2019 | |
1620 | 1620 | Mike Foltynewicz | 26 | foltymi01 | 2018 | ATL | NL | 5.086130572 | 3.335 | P | 17 | 1 | ATL | HOU | 2015 | 2019 | |
1641 | 1641 | Preston Tucker | 27 | tuckepr01 | 2018 | ATL | NL | 1.390511565 | -0.045 | LF, RF | 2 | 1 | ATL | HOU | 2018 | 2018 | CIN |
1902 | 1902 | Tim Federowicz | 30 | federti01 | 2018 | CIN | NL | 0.0688953 | 0.13 | C | 0 | 2 | CIN | HOU | 2018 | 2018 | TEX |
2020 | 2020 | Mike Fiers | 33 | fiersmi01 | 2018 | DET | AL | 3.342287015 | 2.07 | P | 11 | 1 | DET | HOU | 2018 | 2018 | OAK |
2027 | 2027 | Francisco Liriano | 34 | liriafr01 | 2018 | DET | AL | 3.734145498 | 0.18 | P | 6 | 1 | DET | HOU | 2018 | 2018 | PIT |
2177 | 2177 | Nick Tropeano | 27 | tropeni01 | 2018 | LAA | AL | 2.259950666 | 0.02 | P | 3 | 1 | ANA | HOU | 2015 | 2019 | |
2191 | 2191 | Luis Valbuena | 32 | valbulu01 | 2018 | LAA | AL | 2.744659875 | -0.89 | 3B, 1B, 2B | 1 | 1 | ANA | HOU | 2017 | 2018 | |
2236 | 2236 | Josh Fields | 32 | fieldjo03 | 2018 | LAD | NL | 1.081042326 | 0.591349693 | P | 3 | 1 | LAD | HOU | 2016 | 2018 | |
2274 | 2274 | Cameron Maybin | 31 | maybica01 | 2018 | MIA | NL | 2.87 | 1.046459627 | LF, CF, RF | 8 | 1 | FLA | HOU | 2018 | 2018 | SEA |
2328 | 2328 | Jonathan Villar | 27 | villajo01 | 2018 | MIL | NL | 2.735756551 | 1.073374233 | 2B, SS | 8 | 1 | MIL | HOU | 2016 | 2018 | BAL |
2334 | 2334 | Domingo Santana | 25 | santado01 | 2018 | MIL | NL | 2.304311074 | 0.864662577 | RF | 6 | 1 | MIL | HOU | 2015 | 2018 | SEA |
2378 | 2378 | Robbie Grossman | 28 | grossro01 | 2018 | MIN | AL | 4.398238748 | 1.125 | RF, LF | 10 | 1 | MIN | HOU | 2016 | 2018 | OAK |
2408 | 2408 | Jason Castro | 31 | castrja01 | 2018 | MIN | AL | 0.699934768 | -0.02 | C | 1 | 1 | MIN | HOU | 2017 | 2019 | |
2531 | 2531 | Jed Lowrie | 34 | lowrije01 | 2018 | OAK | AL | 6.326596086 | 4.9 | 2B, 3B | 24 | 1 | OAK | HOU | 2016 | 2018 | NYM |
2589 | 2589 | Vince Velasquez | 26 | velasvi01 | 2018 | PHI | NL | 4.166262545 | 2.455 | P | 13 | 1 | PHI | HOU | 2016 | 2019 | |
2640 | 2640 | Joe Musgrove | 25 | musgrjo01 | 2018 | PIT | NL | 3.307040978 | 1.780993789 | P | 10 | 1 | PIT | HOU | 2018 | 2019 | |
2641 | 2641 | Colin Moran | 25 | moranco01 | 2018 | PIT | NL | 4.689619197 | 0.845217391 | 3B | 10 | 1 | PIT | HOU | 2018 | 2019 | |
2663 | 2663 | Michael Feliz | 25 | felizmi01 | 2018 | PIT | NL | 1.424943804 | -0.377329193 | P | 1 | 1 | PIT | HOU | 2018 | 2019 | |
2868 | 2868 | Luke Gregerson | 34 | gregelu01 | 2018 | STL | NL | 0.32466438 | -0.225 | P | 0 | 1 | STL | HOU | 2018 | 2019 | |
2975 | 2975 | Juan Centeno | 28 | centeju01 | 2018 | TEX | AL | 0.358723958 | -0.38 | C | 0 | 1 | TEX | HOU | 2018 | 2018 | BOS |
2993 | 2993 | Teoscar Hernandez | 25 | hernate01 | 2018 | TOR | AL | 5.012227363 | 0.235 | LF, RF | 8 | 1 | TOR | HOU | 2017 | 2019 | |
2998 | 2998 | Tyler Clippard | 33 | clippty01 | 2018 | TOR | AL | 2.436161162 | 0.91 | P | 6 | 1 | TOR | HOU | 2018 | 2018 | CLE |
3020 | 3020 | Ken Giles | 27 | gileske01 | 2018 | TOR | AL | 0.833657974 | 0.005 | P | 1 | 2 | TOR | HOU | 2018 | 2019 | |
3023 | 3023 | David Paulino | 24 | paulida01 | 2018 | TOR | AL | 0.124915589 | 0.08 | P | 0 | 1 | TOR | HOU | 2018 | 2018 | |
3025 | 3025 | Rhiner Cruz | 31 | cruzrh01 | 2018 | TOR | AL | 0.071672879 | 0.045 | P | 0 | 1 | TOR | HOU | 2018 | 2018 | |
3151 | 3151 | Mike Foltynewicz | 25 | foltymi01 | 2017 | ATL | NL | 4.349375898 | 1.235 | P | 10 | 1 | ATL | HOU | 2015 | 2019 | |
3259 | 3259 | Doug Fister | 33 | fistedo01 | 2017 | BOS | AL | 2.724269986 | 0.745 | P | 6 | 1 | BOS | HOU | 2017 | 2017 | TEX |
3420 | 3420 | Asher Wojciechowski | 28 | wojcias01 | 2017 | CIN | NL | 1.698703428 | -0.405 | P | 1 | 1 | CIN | HOU | 2017 | 2017 | BAL |
3505 | 3505 | Chad Qualls | 38 | quallch01 | 2017 | COL | NL | 0.404096393 | -0.015 | P | 1 | 1 | COL | HOU | 2016 | 2017 | |
3515 | 3515 | Jordan Lyles | 26 | lylesjo01 | 2017 | COL | NL | 1.046075944 | -0.38 | P | 0 | 1 | COL | HOU | 2014 | 2017 | SDP |
3530 | 3530 | J.D. Martinez | 29 | martijd02 | 2017 | DET | AL | 2.195822454 | 1.605 | RF | 7 | 1 | DET | HOU | 2014 | 2017 | ARI |
3674 | 3674 | Luis Valbuena | 31 | valbulu01 | 2017 | LAA | AL | 3.843027098 | 0.445 | 3B, 1B | 7 | 1 | ANA | HOU | 2017 | 2018 | |
3739 | 3739 | Josh Fields | 31 | fieldjo03 | 2017 | LAD | NL | 1.775128895 | 0.565 | P | 4 | 1 | LAD | HOU | 2016 | 2018 | |
3814 | 3814 | Domingo Santana | 24 | santado01 | 2017 | MIL | NL | 6.050180443 | 3.105 | RF | 18 | 1 | MIL | HOU | 2015 | 2018 | SEA |
3828 | 3828 | Jonathan Villar | 26 | villajo01 | 2017 | MIL | NL | 4.345763877 | -0.155 | 2B, CF | 6 | 1 | MIL | HOU | 2016 | 2018 | BAL |
3871 | 3871 | Jason Castro | 30 | castrja01 | 2017 | MIN | AL | 3.784832451 | 2.285 | C | 12 | 1 | MIN | HOU | 2017 | 2019 | |
3874 | 3874 | Robbie Grossman | 27 | grossro01 | 2017 | MIN | AL | 4.240500241 | 0.67 | RF, LF | 8 | 1 | MIN | HOU | 2016 | 2018 | OAK |
4017 | 4017 | Jed Lowrie | 33 | lowrije01 | 2017 | OAK | AL | 6.129772243 | 3.87 | 2B, 3B | 20 | 1 | OAK | HOU | 2016 | 2018 | NYM |
4080 | 4080 | Pat Neshek | 36 | neshepa01 | 2017 | PHI | NL | 1.435042939 | 1.88 | P | 7 | 1 | PHI | HOU | 2017 | 2017 | COL |
4091 | 4091 | Vince Velasquez | 25 | velasvi01 | 2017 | PHI | NL | 2.027581682 | 0.505 | P | 4 | 1 | PHI | HOU | 2016 | 2019 | |
4394 | 4394 | Colby Rasmus | 30 | rasmuco01 | 2017 | TBR | AL | 1.222149624 | 1.18 | LF, RF, CF | 5 | 1 | TBD | HOU | 2017 | 2017 | BAL |
4442 | 4442 | Carlos Gomez | 31 | gomezca01 | 2017 | TEX | AL | 4.054479816 | 1.735 | CF | 11 | 1 | TEX | HOU | 2016 | 2017 | TBD |
4474 | 4474 | Anthony Bass | 29 | bassan01 | 2017 | TEX | AL | 0.124241152 | -0.145 | P | 0 | 1 | TEX | HOU | 2015 | 2017 | CHC |
4505 | 4505 | Teoscar Hernandez | 24 | hernate01 | 2017 | TOR | AL | 0.898858075 | 0.53 | LF, CF, RF | 3 | 2 | TOR | HOU | 2017 | 2019 | |
4509 | 4509 | Nori Aoki | 35 | aokino01 | 2017 | TOR | AL | 0.321696574 | 0.355 | LF, RF, CF, P | 2 | 2 | TOR | HOU | 2017 | 2017 | NYM |
4566 | 4566 | Oliver Perez | 35 | perezol01 | 2017 | WSN | NL | 1.042953554 | 0.35 | P | 3 | 1 | WSN | HOU | 2016 | 2017 | CLE |
4646 | 4646 | Mike Foltynewicz | 24 | foltymi01 | 2016 | ATL | NL | 3.384154266 | 1.433850932 | P | 9 | 1 | ATL | HOU | 2015 | 2019 | |
4660 | 4660 | Lucas Harrell | 31 | harrelu01 | 2016 | ATL | NL | 0.817861868 | 0.457826087 | P | 3 | 1 | ATL | HOU | 2016 | 2016 | TEX |
4695 | 4695 | Roberto Hernandez | 35 | carmofa01 | 2016 | ATL | NL | 0.252262589 | -0.286770186 | P | 0 | 1 | ATL | HOU | 2016 | 2016 | |
4804 | 4804 | Dexter Fowler | 30 | fowlede01 | 2016 | CHC | NL | 5.384667228 | 4.34 | CF | 20 | 1 | CHC | HOU | 2015 | 2016 | STL |
4829 | 4829 | Jake Buchanan | 26 | buchaja01 | 2016 | CHC | NL | 0.132694497 | 0.16 | P | 1 | 1 | CHC | HOU | 2016 | 2016 | CIN |
4891 | 4891 | Matt Albers | 33 | alberma01 | 2016 | CHW | AL | 1.755487853 | -1.245 | P | 0 | 1 | CHW | HOU | 2015 | 2016 | WSN |
4897 | 4897 | Dan Straily | 27 | straida01 | 2016 | CIN | NL | 5.368547633 | 2.21 | P | 15 | 1 | CIN | HOU | 2016 | 2016 | FLA |
5014 | 5014 | Brandon Barnes | 30 | barnebr02 | 2016 | COL | NL | 1.071707069 | 0.055 | LF, CF, RF | 2 | 1 | COL | HOU | 2014 | 2016 | CLE |
5022 | 5022 | Chad Qualls | 37 | quallch01 | 2016 | COL | NL | 0.844081985 | -0.065 | P | 1 | 1 | COL | HOU | 2016 | 2017 | |
5024 | 5024 | Jordan Lyles | 25 | lylesjo01 | 2016 | COL | NL | 1.813668872 | -0.46 | P | 1 | 1 | COL | HOU | 2014 | 2017 | SDP |
5046 | 5046 | J.D. Martinez | 28 | martijd02 | 2016 | DET | AL | 4.912516383 | 2.022484472 | RF | 13 | 1 | DET | HOU | 2014 | 2017 | ARI |
5185 | 5185 | Nick Tropeano | 25 | tropeni01 | 2016 | LAA | AL | 1.998533214 | 0.69 | P | 5 | 1 | ANA | HOU | 2015 | 2019 | |
5237 | 5237 | Scott Kazmir | 32 | kazmisc01 | 2016 | LAD | NL | 3.707202193 | 0.525 | P | 7 | 1 | LAD | HOU | 2016 | 2016 | |
5252 | 5252 | Josh Fields | 30 | fieldjo03 | 2016 | LAD | NL | 0.488369789 | 0.18 | P | 1 | 2 | LAD | HOU | 2016 | 2018 | |
5318 | 5318 | Jarred Cosart | 26 | cosarja01 | 2016 | MIA | NL | 0.53718626 | -0.120745342 | P | 0 | 1 | FLA | HOU | 2014 | 2016 | SDP |
5327 | 5327 | Paul Clemens | 28 | clemepa02 | 2016 | MIA | NL | 0.273145556 | -0.332049689 | P | 0 | 1 | FLA | HOU | 2016 | 2016 | SDP |
5331 | 5331 | Jonathan Villar | 25 | villajo01 | 2016 | MIL | NL | 6.846662031 | 3.445 | SS, 3B, 2B | 20 | 1 | MIL | HOU | 2016 | 2018 | BAL |
5336 | 5336 | Chris Carter | 29 | cartech02 | 2016 | MIL | NL | 6.493741307 | 0.935 | 1B | 12 | 1 | MIL | HOU | 2016 | 2016 | NYY |
5352 | 5352 | Domingo Santana | 23 | santado01 | 2016 | MIL | NL | 2.833449235 | 0.01 | RF, LF, CF | 4 | 1 | MIL | HOU | 2015 | 2018 | SEA |
5378 | 5378 | Alex Presley | 30 | preslal01 | 2016 | MIL | NL | 1.300764951 | -0.655 | RF, LF, CF | 0 | 1 | MIL | HOU | 2016 | 2016 | DET |
5392 | 5392 | Robbie Grossman | 26 | grossro01 | 2016 | MIN | AL | 3.629081551 | 0.5 | LF, CF | 6 | 1 | MIN | HOU | 2016 | 2018 | OAK |
5550 | 5550 | Fernando Rodriguez Jr. | 32 | rodrife02 | 2016 | OAK | AL | 1.16549819 | 0.46 | P | 3 | 1 | OAK | HOU | 2014 | 2016 | |
5556 | 5556 | Jed Lowrie | 32 | lowrije01 | 2016 | OAK | AL | 3.568189396 | -0.63 | 2B, SS | 3 | 1 | OAK | HOU | 2016 | 2018 | NYM |
5586 | 5586 | Vince Velasquez | 24 | velasvi01 | 2016 | PHI | NL | 3.70586465 | 2.23 | P | 12 | 1 | PHI | HOU | 2016 | 2019 | |
5610 | 5610 | Brett Oberholtzer | 26 | oberhbr01 | 2016 | PHI | NL | 1.166371292 | -0.2 | P | 1 | 1 | PHI | HOU | 2016 | 2016 | ANA |
5683 | 5683 | Erik Kratz | 36 | kratzer01 | 2016 | PIT | NL | 0.556565657 | -0.545 | C, 1B, P | 0 | 2 | PIT | HOU | 2016 | 2016 | NYY |
5714 | 5714 | Brett Wallace | 29 | wallabr01 | 2016 | SDP | NL | 2.609031805 | -0.58 | 3B, 1B | 2 | 1 | SDP | HOU | 2015 | 2016 | |
5918 | 5918 | Hank Conger | 28 | congeha01 | 2016 | TBR | AL | 1.319714333 | -0.31 | C | 1 | 1 | TBD | HOU | 2016 | 2016 | |
5950 | 5950 | Carlos Gomez | 30 | gomezca01 | 2016 | TEX | AL | 1.242788858 | 0.845 | CF, LF, RF | 5 | 2 | TEX | HOU | 2016 | 2017 | TBD |
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 );