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,310 rows where prev_franch = "CHC"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14 | 14 | Alex Avila | 32 | avilaal01 | 2019 | ARI | NL | 1.942206357 | 1.207358491 | C, P | 6 | 1 | ARI | CHC | 2018 | 2019 | |
83 | 83 | Arodys Vizcaino | 28 | vizcaar01 | 2019 | ATL | NL | 0.131183086 | 0.020377358 | P | 0 | 1 | ATL | CHC | 2015 | 2019 | |
361 | 361 | Mike Freeman | 31 | freemmi01 | 2019 | CLE | AL | 1.952015995 | 1.07490566 | 2B, 3B, SS, LF, P | 6 | 1 | CLE | CHC | 2019 | 2019 | |
410 | 410 | Daniel Murphy | 34 | murphda08 | 2019 | COL | NL | 4.673738238 | -0.010188679 | 1B, 2B | 7 | 1 | COL | CHC | 2019 | 2019 | |
436 | 436 | Chris Rusin | 32 | rusinch01 | 2019 | COL | NL | 0.025468071 | -0.173207547 | P | 0 | 1 | COL | CHC | 2015 | 2019 | |
447 | 447 | Wade Davis | 33 | daviswa01 | 2019 | COL | NL | 1.457525983 | -0.769245283 | P | 0 | 1 | COL | CHC | 2018 | 2019 | |
460 | 460 | Jeimer Candelario | 25 | candeje01 | 2019 | DET | AL | 3.727380348 | 0.430632911 | 3B, 1B | 5 | 1 | DET | CHC | 2017 | 2019 | |
525 | 525 | Martin Maldonado | 32 | maldoma01 | 2019 | HOU | AL | 0.86235012 | 0.657169811 | C, 1B | 3 | 3 | HOU | CHC | 2019 | 2019 | |
529 | 529 | Hector Rondon | 31 | rondohe01 | 2019 | HOU | AL | 1.950655209 | 0.295471698 | P | 3 | 1 | HOU | CHC | 2018 | 2019 | |
548 | 548 | Jorge Soler | 27 | solerjo01 | 2019 | KCR | AL | 6.501762041 | 3.311320755 | RF | 18 | 1 | KCR | CHC | 2017 | 2019 | |
563 | 563 | Mike Montgomery | 29 | montgmi01 | 2019 | KCR | AL | 1.853747526 | 0.422830189 | P | 4 | 2 | KCR | CHC | 2019 | 2019 | |
568 | 568 | Terrance Gore | 28 | gorete01 | 2019 | KCR | AL | 0.564524249 | 0.376981132 | RF, LF, CF | 2 | 1 | KCR | CHC | 2019 | 2019 | |
581 | 581 | Randy Rosario | 25 | rosarra01 | 2019 | KCR | AL | 0.102022201 | 0.096792453 | P | 0 | 2 | KCR | CHC | 2019 | 2019 | |
605 | 605 | Tommy La Stella | 30 | lasteto01 | 2019 | LAA | AL | 2.952520803 | 1.935849057 | 2B, 3B, 1B | 10 | 1 | ANA | CHC | 2019 | 2019 | |
613 | 613 | Felix Pena | 29 | penafe01 | 2019 | LAA | AL | 2.736046649 | 0.713207547 | P | 6 | 1 | ANA | CHC | 2018 | 2019 | |
867 | 867 | Justin Wilson | 31 | wilsoju10 | 2019 | NYM | NL | 1.400280427 | 0.789622642 | P | 4 | 1 | NYM | CHC | 2019 | 2019 | |
871 | 871 | Brad Brach | 33 | brachbr01 | 2019 | NYM | NL | 0.49069656 | 0.310754717 | P | 2 | 2 | NYM | CHC | 2019 | 2019 | |
918 | 918 | Aroldis Chapman | 31 | chapmar01 | 2019 | NYY | AL | 2.120747657 | 1.75754717 | P | 9 | 1 | NYY | CHC | 2017 | 2019 | |
991 | 991 | Brian Schlitter | 33 | schlibr01 | 2019 | OAK | AL | 0.190060076 | 0.101886792 | P | 1 | 1 | OAK | CHC | 2019 | 2019 | |
1016 | 1016 | Jake Arrieta | 33 | arrieja01 | 2019 | PHI | NL | 3.921029674 | 1.059622642 | P | 9 | 1 | PHI | CHC | 2018 | 2019 | |
1158 | 1158 | Carl Edwards Jr. | 27 | edwarca01 | 2019 | SDP | NL | 0.027812844 | -0.117169811 | P | 0 | 2 | SDP | CHC | 2019 | 2019 | |
1186 | 1186 | Anthony Bass | 31 | bassan01 | 2019 | SEA | AL | 1.814483298 | 0.738679245 | P | 5 | 1 | SEA | CHC | 2019 | 2019 | |
1310 | 1310 | Dexter Fowler | 33 | fowlede01 | 2019 | STL | NL | 5.653356582 | 1.75754717 | RF, CF | 14 | 1 | STL | CHC | 2017 | 2019 | |
1417 | 1417 | Jesse Chavez | 35 | chaveje01 | 2019 | TEX | AL | 2.637622168 | 0.845660377 | P | 6 | 1 | TEX | CHC | 2019 | 2019 | |
1427 | 1427 | Luke Farrell | 28 | farrelu01 | 2019 | TEX | AL | 0.303401695 | 0.234339623 | P | 1 | 1 | TEX | CHC | 2019 | 2019 | |
1583 | 1583 | Alex Avila | 31 | avilaal01 | 2018 | ARI | NL | 2.329957082 | 0.35 | C, 1B, P | 4 | 1 | ARI | CHC | 2018 | 2019 | |
1632 | 1632 | Arodys Vizcaino | 27 | vizcaar01 | 2018 | ATL | NL | 1.348752022 | 0.74 | P | 4 | 1 | ATL | CHC | 2015 | 2019 | |
1893 | 1893 | Dylan Floro | 27 | florody01 | 2018 | CIN | NL | 1.040460768 | 0.515 | P | 3 | 1 | CIN | CHC | 2018 | 2018 | LAD |
1979 | 1979 | DJ LeMahieu | 29 | lemahdj01 | 2018 | COL | NL | 5.767242855 | 2.549263804 | 2B | 17 | 1 | COL | CHC | 2012 | 2018 | NYY |
1989 | 1989 | Wade Davis | 32 | daviswa01 | 2018 | COL | NL | 2.632444558 | 0.939202454 | P | 7 | 1 | COL | CHC | 2018 | 2019 | |
2002 | 2002 | Chris Rusin | 31 | rusinch01 | 2018 | COL | NL | 1.52739037 | -0.342883436 | P | 1 | 1 | COL | CHC | 2015 | 2019 | |
2017 | 2017 | Jeimer Candelario | 24 | candeje01 | 2018 | DET | AL | 5.973710483 | 2.235 | 3B | 15 | 1 | DET | CHC | 2017 | 2019 | |
2022 | 2022 | Leonys Martin | 30 | martile01 | 2018 | DET | AL | 3.242595674 | 2.0 | CF, RF | 10 | 1 | DET | CHC | 2018 | 2018 | CLE |
2081 | 2081 | Hector Rondon | 30 | rondohe01 | 2018 | HOU | AL | 2.17467839 | 1.1 | P | 6 | 1 | HOU | CHC | 2018 | 2019 | |
2115 | 2115 | Jon Jay | 33 | jayjo02 | 2018 | KCR | AL | 2.553881808 | 0.965 | RF, LF, CF | 6 | 1 | KCR | CHC | 2018 | 2018 | ARI |
2116 | 2116 | Jorge Soler | 26 | solerjo01 | 2018 | KCR | AL | 2.467472273 | 0.895 | RF | 6 | 1 | KCR | CHC | 2017 | 2019 | |
2128 | 2128 | Jason Hammel | 35 | hammeja01 | 2018 | KCR | AL | 3.836831591 | -0.37 | P | 3 | 1 | KCR | CHC | 2017 | 2018 | |
2152 | 2152 | Justin Grimm | 29 | grimmju01 | 2018 | KCR | AL | 0.46603131 | -0.96 | P | 0 | 1 | KCR | CHC | 2018 | 2018 | SEA |
2167 | 2167 | Felix Pena | 28 | penafe01 | 2018 | LAA | AL | 2.63829627 | 0.97 | P | 6 | 1 | ANA | CHC | 2018 | 2019 | |
2181 | 2181 | Rene Rivera | 34 | riverre01 | 2018 | LAA | AL | 0.829116004 | 0.435 | C, 1B | 2 | 1 | ANA | CHC | 2018 | 2018 | ATL |
2406 | 2406 | Chris Gimenez | 35 | gimench01 | 2018 | MIN | AL | 0.32159165 | 0.09 | C, 1B, 3B, P | 1 | 2 | MIN | CHC | 2018 | 2018 | |
2493 | 2493 | Aroldis Chapman | 30 | chapmar01 | 2018 | NYY | AL | 1.960327423 | 1.765 | P | 8 | 1 | NYY | CHC | 2017 | 2019 | |
2505 | 2505 | Adam Warren | 30 | warread01 | 2018 | NYY | AL | 0.753239625 | 0.505 | P | 3 | 1 | NYY | CHC | 2016 | 2018 | SEA |
2585 | 2585 | Jake Arrieta | 32 | arrieja01 | 2018 | PHI | NL | 4.777097392 | 2.59 | P | 15 | 1 | PHI | CHC | 2018 | 2019 | |
2695 | 2695 | Clayton Richard | 34 | richacl01 | 2018 | SDP | NL | 4.436024491 | -0.23 | P | 6 | 1 | SDP | CHC | 2016 | 2018 | TOR |
2722 | 2722 | Matt Szczur | 28 | szczuma01 | 2018 | SDP | NL | 0.844953174 | -0.365 | LF, RF, CF | 0 | 1 | SDP | CHC | 2017 | 2018 | |
2813 | 2813 | Pierce Johnson | 27 | johnspi01 | 2018 | SFG | NL | 0.988103599 | -0.25 | P | 1 | 1 | SFG | CHC | 2018 | 2018 | |
2862 | 2862 | Dexter Fowler | 32 | fowlede01 | 2018 | STL | NL | 3.29848459 | -1.235 | RF | 1 | 1 | STL | CHC | 2017 | 2019 | |
2978 | 2978 | Eddie Butler | 27 | butleed01 | 2018 | TEX | AL | 0.937488359 | -0.61 | P | 0 | 2 | TEX | CHC | 2018 | 2018 | |
3154 | 3154 | Arodys Vizcaino | 26 | vizcaar01 | 2017 | ATL | NL | 2.301958209 | 1.14 | P | 7 | 1 | ATL | CHC | 2015 | 2019 | |
3366 | 3366 | Zach Putnam | 29 | putnaza01 | 2017 | CHW | AL | 0.290564272 | 0.375 | P | 1 | 1 | CHW | CHC | 2014 | 2017 | |
3423 | 3423 | Jake Buchanan | 27 | buchaja01 | 2017 | CIN | NL | 0.292387143 | -0.095 | P | 0 | 1 | CIN | CHC | 2017 | 2017 | |
3479 | 3479 | DJ LeMahieu | 28 | lemahdj01 | 2017 | COL | NL | 6.745566166 | 2.39 | 2B | 18 | 1 | COL | CHC | 2012 | 2018 | NYY |
3486 | 3486 | Chris Rusin | 30 | rusinch01 | 2017 | COL | NL | 2.851548128 | 1.82 | P | 10 | 1 | COL | CHC | 2015 | 2019 | |
3508 | 3508 | Zac Rosscup | 29 | rosscza01 | 2017 | COL | NL | 0.146237147 | 0.06 | P | 0 | 2 | COL | CHC | 2017 | 2017 | LAD |
3535 | 3535 | Jeimer Candelario | 23 | candeje01 | 2017 | DET | AL | 1.003263708 | 0.485 | 3B, 1B | 3 | 2 | DET | CHC | 2017 | 2019 | |
3620 | 3620 | Jason Hammel | 34 | hammeja01 | 2017 | KCR | AL | 5.03537908 | 1.73 | P | 13 | 1 | KCR | CHC | 2017 | 2018 | |
3641 | 3641 | Travis Wood | 30 | woodtr01 | 2017 | KCR | AL | 1.188328956 | -0.225 | P | 1 | 1 | KCR | CHC | 2017 | 2017 | SDP |
3661 | 3661 | Jorge Soler | 25 | solerjo01 | 2017 | KCR | AL | 1.063333333 | -1.12 | RF, LF | 0 | 1 | KCR | CHC | 2017 | 2019 | |
3850 | 3850 | Quintin Berry | 32 | berryqu01 | 2017 | MIL | NL | 0.029902045 | -0.03 | LF, CF | 0 | 1 | MIL | CHC | 2017 | 2017 | |
3975 | 3975 | Starlin Castro | 27 | castrst01 | 2017 | NYY | AL | 4.334650024 | 1.955 | 2B | 11 | 1 | NYY | CHC | 2016 | 2017 | FLA |
3982 | 3982 | Adam Warren | 29 | warread01 | 2017 | NYY | AL | 1.886028606 | 1.3 | P | 6 | 1 | NYY | CHC | 2016 | 2018 | SEA |
3983 | 3983 | Aroldis Chapman | 29 | chapmar01 | 2017 | NYY | AL | 1.936780763 | 1.23 | P | 6 | 1 | NYY | CHC | 2017 | 2019 | |
4147 | 4147 | Jack Leathersich | 26 | leathja01 | 2017 | PIT | NL | 0.147646664 | 0.19 | P | 1 | 2 | PIT | CHC | 2017 | 2017 | |
4172 | 4172 | Clayton Richard | 33 | richacl01 | 2017 | SDP | NL | 5.617328711 | 1.54 | P | 14 | 1 | SDP | CHC | 2016 | 2018 | TOR |
4182 | 4182 | Trevor Cahill | 29 | cahiltr01 | 2017 | SDP | NL | 1.727201389 | 1.33 | P | 7 | 1 | SDP | CHC | 2017 | 2017 | KCR |
4185 | 4185 | Matt Szczur | 27 | szczuma01 | 2017 | SDP | NL | 2.197981229 | 0.38 | LF, CF, RF | 5 | 2 | SDP | CHC | 2017 | 2018 | |
4309 | 4309 | Tim Federowicz | 29 | federti01 | 2017 | SFG | NL | 0.139542877 | 0.115 | C, 1B | 1 | 1 | SFG | CHC | 2017 | 2017 | HOU |
4337 | 4337 | Dexter Fowler | 31 | fowlede01 | 2017 | STL | NL | 4.835795551 | 2.095 | CF | 13 | 1 | STL | CHC | 2017 | 2019 | |
4377 | 4377 | Miguel Socolovich | 30 | socolmi01 | 2017 | STL | NL | 0.397095597 | -0.38 | P | 0 | 1 | STL | CHC | 2015 | 2017 | ATL |
4502 | 4502 | Joe Smith | 33 | smithjo05 | 2017 | TOR | AL | 1.203146251 | 0.905 | P | 4 | 1 | TOR | CHC | 2017 | 2017 | CLE |
4506 | 4506 | Brett Anderson | 29 | anderbr04 | 2017 | TOR | AL | 0.891957472 | 0.46 | P | 3 | 2 | TOR | CHC | 2017 | 2017 | OAK |
4539 | 4539 | Miguel Montero | 33 | montemi01 | 2017 | TOR | AL | 0.955628059 | -0.555 | C, 1B, P | 0 | 2 | TOR | CHC | 2017 | 2017 | WSN |
4540 | 4540 | Chris Coghlan | 32 | coghlch01 | 2017 | TOR | AL | 0.832626427 | -0.595 | 3B, LF, 2B | 0 | 1 | TOR | CHC | 2017 | 2017 | |
4670 | 4670 | Arodys Vizcaino | 25 | vizcaar01 | 2016 | ATL | NL | 1.374708176 | -0.115714286 | P | 2 | 1 | ATL | CHC | 2015 | 2019 | |
4742 | 4742 | Julio Borbon | 30 | borboju01 | 2016 | BAL | AL | 0.14354067 | -0.195 | CF, LF | 0 | 1 | BAL | CHC | 2016 | 2016 | |
4861 | 4861 | Zach Putnam | 28 | putnaza01 | 2016 | CHW | AL | 0.732415548 | 0.575 | P | 3 | 1 | CHW | CHC | 2014 | 2017 | |
4868 | 4868 | Austin Jackson | 29 | jacksau01 | 2016 | CHW | AL | 1.927320347 | -0.105 | CF | 2 | 1 | CHW | CHC | 2016 | 2016 | CLE |
4890 | 4890 | Jacob Turner | 25 | turneja01 | 2016 | CHW | AL | 0.664612088 | -0.835 | P | 0 | 1 | CHW | CHC | 2016 | 2016 | WSN |
4929 | 4929 | Rafael Lopez | 28 | lopezra02 | 2016 | CIN | NL | 0.070400555 | -0.185 | C, 1B | 0 | 1 | CIN | CHC | 2016 | 2016 | TOR |
4971 | 4971 | Tommy Hunter | 29 | hunteto02 | 2016 | CLE | AL | 0.604598477 | 0.246521739 | P | 2 | 1 | CLE | CHC | 2016 | 2016 | BAL |
4995 | 4995 | DJ LeMahieu | 27 | lemahdj01 | 2016 | COL | NL | 6.24343109 | 4.84 | 2B | 22 | 1 | COL | CHC | 2012 | 2018 | NYY |
5003 | 5003 | Chris Rusin | 29 | rusinch01 | 2016 | COL | NL | 2.51635277 | 1.74 | P | 8 | 1 | COL | CHC | 2015 | 2019 | |
5023 | 5023 | Gonzalez Germen | 28 | germego01 | 2016 | COL | NL | 1.125852794 | -0.125 | P | 1 | 1 | COL | CHC | 2015 | 2016 | |
5031 | 5031 | Jason Motte | 34 | motteja01 | 2016 | COL | NL | 0.69889004 | -0.17 | P | 0 | 1 | COL | CHC | 2016 | 2016 | ATL |
5091 | 5091 | Luis Valbuena | 30 | valbulu01 | 2016 | HOU | AL | 3.209189452 | 2.42 | 3B, 1B, 2B | 11 | 1 | HOU | CHC | 2015 | 2016 | ANA |
5367 | 5367 | Neil Ramirez | 27 | ramirne01 | 2016 | MIL | NL | 0.032640354 | -0.085 | P | 0 | 2 | MIL | CHC | 2016 | 2016 | MIN |
5483 | 5483 | Starlin Castro | 26 | castrst01 | 2016 | NYY | AL | 5.858585859 | 1.29 | 2B, SS | 13 | 1 | NYY | CHC | 2016 | 2017 | FLA |
5500 | 5500 | Adam Warren | 28 | warread01 | 2016 | NYY | AL | 1.028929408 | 0.315 | P | 2 | 2 | NYY | CHC | 2016 | 2018 | SEA |
5571 | 5571 | Arismendy Alcantara | 24 | alcanar01 | 2016 | OAK | AL | 0.183727909 | -0.27 | CF, 2B, SS, RF | 0 | 1 | OAK | CHC | 2016 | 2016 | CIN |
5579 | 5579 | Chris Coghlan | 31 | coghlch01 | 2016 | OAK | AL | 1.663221074 | -1.41 | LF, 2B, 3B, RF, 1B | 0 | 1 | OAK | CHC | 2016 | 2016 | CHC |
5622 | 5622 | James Russell | 30 | russeja02 | 2016 | PHI | NL | 0.125194063 | -0.455 | P | 0 | 1 | PHI | CHC | 2016 | 2016 | |
5698 | 5698 | Fernando Rodney | 39 | rodnefe01 | 2016 | SDP | NL | 1.127286486 | 1.27 | P | 5 | 1 | SDP | CHC | 2016 | 2016 | FLA |
5701 | 5701 | Clayton Richard | 32 | richacl01 | 2016 | SDP | NL | 1.425935923 | 0.675 | P | 4 | 2 | SDP | CHC | 2016 | 2018 | TOR |
5702 | 5702 | Andrew Cashner | 29 | cashnan01 | 2016 | SDP | NL | 2.252447354 | 0.065 | P | 4 | 1 | SDP | CHC | 2012 | 2016 | FLA |
5779 | 5779 | Blake Parker | 31 | parkebl01 | 2016 | SEA | AL | 0.048036935 | 0.05 | P | 0 | 1 | SEA | CHC | 2016 | 2016 | NYY |
5787 | 5787 | Donn Roach | 26 | roachdo01 | 2016 | SEA | AL | 0.198219688 | -0.18 | P | 0 | 1 | SEA | CHC | 2016 | 2016 | |
5827 | 5827 | Joe Nathan | 41 | nathajo01 | 2016 | SFG | NL | 0.17221093 | 0.225 | P | 1 | 2 | SFG | CHC | 2016 | 2016 | |
5871 | 5871 | Miguel Socolovich | 29 | socolmi01 | 2016 | STL | NL | 0.372996761 | 0.275 | P | 1 | 1 | STL | CHC | 2015 | 2017 | ATL |
6135 | 6135 | Arodys Vizcaino | 24 | vizcaar01 | 2015 | ATL | NL | 1.196184341 | 1.05 | P | 5 | 1 | ATL | CHC | 2015 | 2019 |
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 );