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,775 rows where next_franch = "CHW"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
888 | 888 | Hector Santiago | 31 | santihe01 | 2019 | NYM | NL | 0.17546696 | -0.071320755 | P | 0 | 1 | NYM | CHW | 2019 | 2019 | CHW |
1498 | 1498 | Jimmy Cordero | 27 | cordeji01 | 2019 | TOR | AL | 0.034495847 | -0.056037736 | P | 0 | 1 | TOR | WSN | 2019 | 2019 | CHW |
1586 | 1586 | Jon Jay | 33 | jayjo02 | 2018 | ARI | NL | 3.186266094 | -0.17 | RF, LF, CF | 4 | 2 | ARI | KCR | 2018 | 2018 | CHW |
1937 | 1937 | Yonder Alonso | 31 | alonsyo01 | 2018 | CLE | AL | 5.30634364 | 1.125 | 1B | 10 | 1 | CLE | SEA | 2018 | 2018 | CHW |
1967 | 1967 | Evan Marshall | 28 | marshev01 | 2018 | CLE | AL | 0.215459196 | -0.06 | P | 0 | 1 | CLE | SEA | 2018 | 2018 | CHW |
2035 | 2035 | James McCann | 28 | mccanja02 | 2018 | DET | AL | 4.41031614 | -0.615 | C | 4 | 1 | DET | 2014 | 2018 | CHW | |
2102 | 2102 | AJ Reed | 25 | reedaj01 | 2018 | HOU | AL | 0.028426728 | -0.09 | 1B | 0 | 1 | HOU | 2016 | 2018 | CHW | |
2137 | 2137 | Ryan Goins | 30 | goinsry01 | 2018 | KCR | AL | 1.152127131 | -0.22 | 2B, 3B, SS | 1 | 1 | KCR | TOR | 2018 | 2018 | CHW |
2208 | 2208 | Odrisamer Despaigne | 31 | despaod01 | 2018 | LAA | AL | 0.501930066 | -0.38 | P | 0 | 2 | ANA | FLA | 2018 | 2018 | CHW |
2409 | 2409 | Ryan LaMarre | 29 | lamarry01 | 2018 | MIN | AL | 1.030984997 | -0.06 | CF, LF, RF, P | 1 | 1 | MIN | OAK | 2018 | 2018 | CHW |
2423 | 2423 | Ervin Santana | 35 | santaer01 | 2018 | MIN | AL | 0.68744389 | -0.55 | P | 0 | 1 | MIN | ATL | 2015 | 2018 | CHW |
2572 | 2572 | Trayce Thompson | 27 | thomptr01 | 2018 | OAK | AL | 0.065126724 | -0.02 | RF, LF, CF | 0 | 1 | OAK | LAD | 2018 | 2018 | CHW |
2643 | 2643 | Ivan Nova | 31 | novaiv01 | 2018 | PIT | NL | 4.616476279 | 0.623850932 | P | 9 | 1 | PIT | NYY | 2016 | 2018 | CHW |
2744 | 2744 | Alex Colome | 29 | colomal01 | 2018 | SEA | AL | 1.795782665 | 0.865 | P | 5 | 2 | SEA | TBD | 2018 | 2018 | CHW |
2771 | 2771 | Ross Detwiler | 32 | detwiro01 | 2018 | SEA | AL | 0.177306252 | 0.0 | P | 0 | 1 | SEA | OAK | 2018 | 2018 | CHW |
2826 | 2826 | Josh Osich | 29 | osichjo01 | 2018 | SFG | NL | 0.318237869 | -0.325 | P | 0 | 1 | SFG | 2015 | 2018 | CHW | |
3076 | 3076 | Kelvin Herrera | 28 | herreke01 | 2018 | WSN | NL | 0.58618979 | -0.06 | P | 1 | 2 | WSN | KCR | 2018 | 2018 | CHW |
3198 | 3198 | Welington Castillo | 30 | castiwe01 | 2017 | BAL | AL | 3.458020255 | 2.08 | C | 12 | 1 | BAL | ARI | 2017 | 2017 | CHW |
3528 | 3528 | James McCann | 27 | mccanja02 | 2017 | DET | AL | 3.700718016 | 1.14 | C | 8 | 1 | DET | 2014 | 2018 | CHW | |
3562 | 3562 | Bruce Rondon | 26 | rondobr01 | 2017 | DET | AL | 0.525641891 | -0.33 | P | 0 | 1 | DET | 2013 | 2017 | CHW | |
3608 | 3608 | AJ Reed | 24 | reedaj01 | 2017 | HOU | AL | 0.055751362 | -0.185 | 1B | 0 | 1 | HOU | 2016 | 2018 | CHW | |
3628 | 3628 | Joakim Soria | 33 | soriajo01 | 2017 | KCR | AL | 2.04029238 | 1.375 | P | 7 | 1 | KCR | PIT | 2016 | 2017 | CHW |
3636 | 3636 | Al Alburquerque | 31 | albural01 | 2017 | KCR | AL | 0.212032727 | 0.135 | P | 1 | 1 | KCR | ANA | 2017 | 2017 | CHW |
3738 | 3738 | Luis Avilan | 27 | avilalu01 | 2017 | LAD | NL | 1.391036678 | 0.595 | P | 4 | 1 | LAD | ATL | 2015 | 2017 | CHW |
3857 | 3857 | Rob Scahill | 30 | scahiro01 | 2017 | MIL | NL | 0.635978136 | -0.26 | P | 0 | 1 | MIL | PIT | 2016 | 2017 | CHW |
3864 | 3864 | Ervin Santana | 34 | santaer01 | 2017 | MIN | AL | 6.028787514 | 3.885 | P | 20 | 1 | MIN | ATL | 2015 | 2018 | CHW |
3888 | 3888 | Hector Santiago | 29 | santihe01 | 2017 | MIN | AL | 2.102478443 | -0.145 | P | 3 | 1 | MIN | ANA | 2016 | 2017 | CHW |
4000 | 4000 | Tyler Clippard | 32 | clippty01 | 2017 | NYY | AL | 1.282938063 | -0.135 | P | 1 | 1 | NYY | ARI | 2016 | 2017 | CHW |
4048 | 4048 | Dustin Garneau | 29 | garnedu01 | 2017 | OAK | AL | 0.494183189 | 0.17 | C | 1 | 2 | OAK | COL | 2017 | 2017 | CHW |
4116 | 4116 | Jeanmar Gomez | 29 | gomezje01 | 2017 | PHI | NL | 0.723602802 | -0.565 | P | 0 | 1 | PHI | PIT | 2015 | 2017 | CHW |
4130 | 4130 | Ivan Nova | 30 | novaiv01 | 2017 | PIT | NL | 5.319082617 | 1.485 | P | 12 | 1 | PIT | NYY | 2016 | 2018 | CHW |
4161 | 4161 | Alen Hanson | 24 | hansoal01 | 2017 | PIT | NL | 0.588680544 | -0.305 | RF, 2B, CF, LF, SS, 3B | 0 | 1 | PIT | 2016 | 2017 | CHW | |
4203 | 4203 | Jose Ruiz | 22 | ruizjo01 | 2017 | SDP | NL | 0.016958583 | 0.015 | P | 0 | 1 | SDP | 2017 | 2017 | CHW | |
4263 | 4263 | Thyago Vieira | 23 | vieirth01 | 2017 | SEA | AL | 0.014796843 | 0.015 | P | 0 | 1 | SEA | 2017 | 2017 | CHW | |
4324 | 4324 | Josh Osich | 28 | osichjo01 | 2017 | SFG | NL | 1.188464569 | -0.485 | P | 0 | 1 | SFG | 2015 | 2018 | CHW | |
4409 | 4409 | Danny Farquhar | 30 | farquda01 | 2017 | TBR | AL | 1.124027685 | 0.195 | P | 2 | 1 | TBD | SEA | 2016 | 2017 | CHW |
4431 | 4431 | Xavier Cedeno | 30 | cedenxa01 | 2017 | TBR | AL | 0.153714435 | -0.74 | P | 0 | 1 | TBD | WSN | 2015 | 2017 | CHW |
4461 | 4461 | Miguel Gonzalez | 33 | gonzami03 | 2017 | TEX | AL | 0.647168124 | -0.12 | P | 1 | 2 | TEX | CHW | 2017 | 2017 | CHW |
4785 | 4785 | Yoan Moncada | 21 | moncayo01 | 2016 | BOS | AL | 0.184331797 | -0.07 | 3B | 0 | 1 | BOS | 2016 | 2016 | CHW | |
5055 | 5055 | James McCann | 26 | mccanja02 | 2016 | DET | AL | 3.54423329 | 0.769751553 | C | 7 | 1 | DET | 2014 | 2018 | CHW | |
5057 | 5057 | Mike Pelfrey | 32 | pelfrmi01 | 2016 | DET | AL | 3.273500665 | 0.332049689 | P | 6 | 1 | DET | MIN | 2016 | 2016 | CHW |
5061 | 5061 | Bruce Rondon | 25 | rondobr01 | 2016 | DET | AL | 1.224628015 | 0.709378882 | P | 4 | 1 | DET | 2013 | 2017 | CHW | |
5126 | 5126 | AJ Reed | 23 | reedaj01 | 2016 | HOU | AL | 1.323086879 | -0.635 | 1B | 0 | 1 | HOU | 2016 | 2018 | CHW | |
5146 | 5146 | Joakim Soria | 32 | soriajo01 | 2016 | KCR | AL | 2.507060173 | 0.295 | P | 5 | 1 | KCR | PIT | 2016 | 2017 | CHW |
5195 | 5195 | Geovany Soto | 33 | sotoge01 | 2016 | LAA | AL | 0.828571429 | 0.335 | C, 1B, 3B | 2 | 1 | ANA | CHW | 2016 | 2016 | CHW |
5247 | 5247 | Luis Avilan | 26 | avilalu01 | 2016 | LAD | NL | 0.637060064 | 0.41 | P | 2 | 1 | LAD | ATL | 2015 | 2017 | CHW |
5356 | 5356 | Rob Scahill | 29 | scahiro01 | 2016 | MIL | NL | 0.392186402 | 0.33 | P | 2 | 2 | MIL | PIT | 2016 | 2017 | CHW |
5382 | 5382 | Ervin Santana | 33 | santaer01 | 2016 | MIN | AL | 5.143709068 | 3.585 | P | 16 | 1 | MIN | ATL | 2015 | 2018 | CHW |
5404 | 5404 | Hector Santiago | 28 | santihe01 | 2016 | MIN | AL | 1.73052978 | 0.16 | P | 2 | 2 | MIN | ANA | 2016 | 2017 | CHW |
5496 | 5496 | Tyler Clippard | 31 | clippty01 | 2016 | NYY | AL | 0.874809005 | 0.535 | P | 3 | 2 | NYY | ARI | 2016 | 2017 | CHW |
5512 | 5512 | Anthony Swarzak | 30 | swarzan01 | 2016 | NYY | AL | 0.828919222 | -0.195 | P | 1 | 1 | NYY | CLE | 2016 | 2016 | CHW |
5594 | 5594 | Jeanmar Gomez | 28 | gomezje01 | 2016 | PHI | NL | 2.7587836 | 0.16 | P | 5 | 1 | PHI | PIT | 2015 | 2017 | CHW |
5614 | 5614 | Cody Asche | 26 | ascheco01 | 2016 | PHI | NL | 2.227232693 | -0.695 | LF | 1 | 1 | PHI | 2013 | 2016 | CHW | |
5643 | 5643 | Ivan Nova | 29 | novaiv01 | 2016 | PIT | NL | 1.801864012 | 1.53 | P | 7 | 2 | PIT | NYY | 2016 | 2018 | CHW |
5681 | 5681 | Alen Hanson | 23 | hansoal01 | 2016 | PIT | NL | 0.322222222 | -0.31 | 2B | 0 | 1 | PIT | 2016 | 2017 | CHW | |
5699 | 5699 | James Shields | 34 | shielja02 | 2016 | SDP | NL | 1.911741031 | 0.615 | P | 5 | 1 | SDP | KCR | 2015 | 2016 | CHW |
5739 | 5739 | Jose Rondon | 22 | rondojo02 | 2016 | SDP | NL | 0.264979793 | -0.65 | SS | 0 | 1 | SDP | 2016 | 2016 | CHW | |
5840 | 5840 | Josh Osich | 27 | osichjo01 | 2016 | SFG | NL | 1.257609843 | -0.665 | P | 0 | 1 | SFG | 2015 | 2018 | CHW | |
5900 | 5900 | Xavier Cedeno | 29 | cedenxa01 | 2016 | TBR | AL | 1.585518728 | 0.72 | P | 4 | 1 | TBD | WSN | 2015 | 2017 | CHW |
5914 | 5914 | Danny Farquhar | 29 | farquda01 | 2016 | TBR | AL | 1.121496264 | 0.05 | P | 1 | 1 | TBD | SEA | 2016 | 2017 | CHW |
5944 | 5944 | Derek Holland | 29 | hollade01 | 2016 | TEX | AL | 2.873486275 | 0.92 | P | 8 | 1 | TEX | 2009 | 2016 | CHW | |
5976 | 5976 | Anthony Ranaudo | 26 | ranauan01 | 2016 | TEX | AL | 0.122433541 | -0.375 | P | 0 | 1 | TEX | BOS | 2015 | 2016 | CHW |
6058 | 6058 | Reynaldo Lopez | 22 | lopezre01 | 2016 | WSN | NL | 1.105251628 | 0.135 | P | 2 | 1 | WSN | 2016 | 2016 | CHW | |
6073 | 6073 | Lucas Giolito | 21 | giolilu01 | 2016 | WSN | NL | 0.554573051 | -0.505 | P | 0 | 1 | WSN | 2016 | 2016 | CHW | |
6176 | 6176 | Manny Banuelos | 24 | banuema01 | 2015 | ATL | NL | 0.720317146 | -0.285 | P | 0 | 1 | ATL | 2015 | 2015 | CHW | |
6196 | 6196 | Miguel Gonzalez | 31 | gonzami03 | 2015 | BAL | AL | 4.150202856 | 0.54 | P | 7 | 1 | BAL | 2012 | 2015 | CHW | |
6310 | 6310 | Austin Jackson | 28 | jacksau01 | 2015 | CHC | NL | 0.786879615 | 0.1 | CF, RF, LF | 2 | 2 | CHC | SEA | 2015 | 2015 | CHW |
6319 | 6319 | Mike Olt | 26 | oltmi01 | 2015 | CHC | NL | 0.159368023 | -0.015 | 3B, 1B | 0 | 1 | CHC | TEX | 2014 | 2015 | CHW |
6374 | 6374 | Todd Frazier | 29 | frazito01 | 2015 | CIN | NL | 6.71172555 | 4.155 | 3B | 20 | 1 | CIN | 2011 | 2015 | CHW | |
6421 | 6421 | David Holmberg | 23 | holmbda01 | 2015 | CIN | NL | 0.795768611 | -0.7 | P | 0 | 1 | CIN | ARI | 2014 | 2015 | CHW |
6454 | 6454 | Jerry Sands | 27 | sandsje01 | 2015 | CLE | AL | 1.267707477 | -0.115714286 | RF, 1B, LF | 1 | 1 | CLE | TBD | 2015 | 2015 | CHW |
6485 | 6485 | Justin Morneau | 34 | morneju01 | 2015 | COL | NL | 1.835826087 | 0.44 | 1B | 4 | 1 | COL | PIT | 2014 | 2015 | CHW |
6508 | 6508 | Tommy Kahnle | 25 | kahnlto01 | 2015 | COL | NL | 1.050752703 | -0.145 | P | 1 | 1 | COL | 2014 | 2015 | CHW | |
6538 | 6538 | James McCann | 25 | mccanja02 | 2015 | DET | AL | 4.019895629 | 0.160993789 | C | 6 | 1 | DET | 2014 | 2018 | CHW | |
6546 | 6546 | Alex Avila | 28 | avilaal01 | 2015 | DET | AL | 2.071428571 | -0.30689441 | C, 1B | 2 | 1 | DET | 2009 | 2015 | CHW | |
6563 | 6563 | Bruce Rondon | 24 | rondobr01 | 2015 | DET | AL | 1.141050794 | -0.382360248 | P | 0 | 1 | DET | 2013 | 2017 | CHW | |
6700 | 6700 | Mat Latos | 27 | latosma01 | 2015 | LAA | AL | 0.069724662 | -0.05 | P | 0 | 3 | ANA | LAD | 2015 | 2015 | CHW |
6722 | 6722 | Jimmy Rollins | 36 | rolliji01 | 2015 | LAD | NL | 5.685878461 | 0.18 | SS | 8 | 1 | LAD | PHI | 2015 | 2015 | CHW |
6747 | 6747 | Luis Avilan | 25 | avilalu01 | 2015 | LAD | NL | 0.585838164 | -0.065 | P | 1 | 2 | LAD | ATL | 2015 | 2017 | CHW |
6879 | 6879 | Ervin Santana | 32 | santaer01 | 2015 | MIN | AL | 2.997413318 | 1.495 | P | 9 | 1 | MIN | ATL | 2015 | 2018 | CHW |
7022 | 7022 | Brett Lawrie | 25 | lawribr01 | 2015 | OAK | AL | 5.677398374 | 1.525 | 3B, 2B | 12 | 1 | OAK | TOR | 2015 | 2015 | CHW |
7081 | 7081 | Jeanmar Gomez | 27 | gomezje01 | 2015 | PHI | NL | 2.080752119 | 1.07 | P | 6 | 1 | PHI | PIT | 2015 | 2017 | CHW |
7087 | 7087 | Cody Asche | 25 | ascheco01 | 2015 | PHI | NL | 4.600452253 | -0.83 | LF, 3B | 4 | 1 | PHI | 2013 | 2016 | CHW | |
7150 | 7150 | Chris Volstad | 28 | volstch01 | 2015 | PIT | NL | 0.037330167 | 0.035 | P | 0 | 1 | PIT | COL | 2015 | 2015 | CHW |
7168 | 7168 | James Shields | 33 | shielja02 | 2015 | SDP | NL | 5.759515518 | 1.42 | P | 13 | 1 | SDP | KCR | 2015 | 2016 | CHW |
7287 | 7287 | Josh Osich | 26 | osichjo01 | 2015 | SFG | NL | 0.949794411 | 0.09 | P | 2 | 1 | SFG | 2015 | 2018 | CHW | |
7305 | 7305 | Hector Sanchez | 25 | sanchhe01 | 2015 | SFG | NL | 0.590101742 | -0.355 | C | 0 | 1 | SFG | 2011 | 2015 | CHW | |
7370 | 7370 | Xavier Cedeno | 28 | cedenxa01 | 2015 | TBR | AL | 1.424834305 | 0.995 | P | 5 | 2 | TBD | WSN | 2015 | 2017 | CHW |
7434 | 7434 | Derek Holland | 28 | hollade01 | 2015 | TEX | AL | 1.635224114 | 0.145 | P | 3 | 1 | TEX | 2009 | 2016 | CHW | |
7456 | 7456 | Anthony Ranaudo | 25 | ranauan01 | 2015 | TEX | AL | 0.365679675 | -0.18 | P | 0 | 1 | TEX | BOS | 2015 | 2016 | CHW |
7486 | 7486 | Dioner Navarro | 31 | navardi01 | 2015 | TOR | AL | 1.794103432 | 0.425 | C | 4 | 1 | TOR | CHC | 2014 | 2015 | CHW |
7636 | 7636 | Emilio Bonifacio | 29 | bonifem01 | 2014 | ATL | NL | 1.300858595 | -0.195 | CF, 2B, 3B, RF, LF, SS | 1 | 2 | ATL | CHC | 2014 | 2014 | CHW |
7661 | 7661 | Miguel Gonzalez | 30 | gonzami03 | 2014 | BAL | AL | 4.212167051 | 1.24 | P | 10 | 1 | BAL | 2012 | 2015 | CHW | |
7781 | 7781 | Mike Olt | 25 | oltmi01 | 2014 | CHC | NL | 2.595213319 | -0.625 | 3B, 1B | 1 | 1 | CHC | TEX | 2014 | 2015 | CHW |
7788 | 7788 | Jacob Turner | 23 | turneja01 | 2014 | CHC | NL | 0.943291836 | -0.275 | P | 0 | 2 | CHC | FLA | 2014 | 2014 | CHW |
7842 | 7842 | Todd Frazier | 28 | frazito01 | 2014 | CIN | NL | 6.805333333 | 4.84 | 3B, 1B | 24 | 1 | CIN | 2011 | 2015 | CHW | |
7885 | 7885 | David Holmberg | 22 | holmbda01 | 2014 | CIN | NL | 0.763909817 | -0.555 | P | 0 | 1 | CIN | ARI | 2014 | 2015 | CHW |
7929 | 7929 | JB Shuck | 27 | shuckja01 | 2014 | CLE | AL | 0.243186583 | -0.535 | LF, RF | 0 | 2 | CLE | ANA | 2014 | 2014 | CHW |
7935 | 7935 | Justin Morneau | 33 | morneju01 | 2014 | COL | NL | 5.469821674 | 2.73 | 1B | 15 | 1 | COL | PIT | 2014 | 2015 | CHW |
7957 | 7957 | Tommy Kahnle | 24 | kahnlto01 | 2014 | COL | NL | 1.998824736 | -0.11 | P | 2 | 1 | COL | 2014 | 2015 | CHW |
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 );