mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
580 rows where prev_franch = "ARI"
This data as json, copyable, CSV (advanced)
Suggested facets: age, year_ID, lg_ID, quasi_ws, stint_ID, franch_id, year_acq, year_left, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60 | 60 | Ender Inciarte | 28 | inciaen01 | 2019 | ATL | NL | 2.281121751 | 0.753962264 | CF | 6 | 1 | ATL | ARI | 2016 | 2019 | |
84 | 84 | John Ryan Murphy | 28 | murphjr01 | 2019 | ATL | NL | 0.009917921 | -0.015283019 | C, P | 0 | 2 | ATL | ARI | 2019 | 2019 | |
157 | 157 | J.D. Martinez | 31 | martijd02 | 2019 | BOS | AL | 5.926206244 | 3.24 | RF, LF | 17 | 1 | BOS | ARI | 2018 | 2019 | |
238 | 238 | Allen Webster | 29 | webstal01 | 2019 | CHC | NL | 0.298373941 | -0.081509434 | P | 0 | 1 | CHC | ARI | 2018 | 2019 | |
251 | 251 | Daniel Descalso | 32 | descada01 | 2019 | CHC | NL | 1.941422594 | -1.151320755 | 2B, 3B, 1B, P | 0 | 1 | CHC | ARI | 2019 | 2019 | |
296 | 296 | Jon Jay | 34 | jayjo02 | 2019 | CHW | AL | 1.784313725 | -0.871518987 | RF, LF | 0 | 1 | CHW | ARI | 2019 | 2019 | |
344 | 344 | David Hernandez | 34 | hernada01 | 2019 | CIN | NL | 1.583307188 | -0.784528302 | P | 0 | 1 | CIN | ARI | 2018 | 2019 | |
352 | 352 | Trevor Bauer | 28 | bauertr01 | 2019 | CLE | AL | 4.549457782 | 2.358679245 | P | 14 | 1 | CLE | ARI | 2013 | 2019 | CIN |
431 | 431 | Chris Iannetta | 36 | iannech01 | 2019 | COL | NL | 1.627373824 | -0.478867925 | C | 1 | 1 | COL | ARI | 2018 | 2019 | |
517 | 517 | Zack Greinke | 35 | greinza01 | 2019 | HOU | AL | 1.816800825 | 1.548679245 | P | 7 | 2 | HOU | ARI | 2019 | 2019 | |
518 | 518 | Will Harris | 34 | harriwi10 | 2019 | HOU | AL | 2.026526588 | 1.533396226 | P | 7 | 1 | HOU | ARI | 2015 | 2019 | |
565 | 565 | Jake Diekman | 32 | diekmja01 | 2019 | KCR | AL | 1.561827726 | 0.509433962 | P | 3 | 1 | KCR | ARI | 2019 | 2019 | OAK |
577 | 577 | Brad Boxberger | 31 | boxbebr01 | 2019 | KCR | AL | 0.834351605 | -0.020377358 | P | 1 | 1 | KCR | ARI | 2019 | 2019 | |
597 | 597 | Chris Owings | 27 | owingch01 | 2019 | KCR | AL | 1.411310623 | -0.820188679 | 2B, 3B, CF, SS, RF, LF, P | 0 | 1 | KCR | ARI | 2019 | 2019 | BOS |
608 | 608 | Tyler Skaggs | 27 | skaggty01 | 2019 | LAA | AL | 2.312139711 | 1.406037736 | P | 7 | 1 | ANA | ARI | 2014 | 2019 | |
674 | 674 | A.J. Pollock | 31 | polloaj01 | 2019 | LAD | NL | 3.368257798 | 0.616415094 | CF, LF | 7 | 1 | LAD | ARI | 2019 | 2019 | |
735 | 735 | Deven Marrero | 28 | marrede01 | 2019 | MIA | NL | 0.051509769 | -0.112075472 | SS, 3B | 0 | 1 | FLA | ARI | 2019 | 2019 | |
743 | 743 | Peter O'Brien | 28 | obriepe01 | 2019 | MIA | NL | 0.484191829 | -0.565471698 | RF, LF, 1B | 0 | 1 | FLA | ARI | 2018 | 2019 | |
762 | 762 | Chase Anderson | 31 | anderch01 | 2019 | MIL | NL | 3.673358098 | 1.421320755 | P | 10 | 1 | MIL | ARI | 2016 | 2019 | |
921 | 921 | Didi Gregorius | 29 | gregodi01 | 2019 | NYY | AL | 3.200589487 | 0.850754717 | SS | 8 | 1 | NYY | ARI | 2015 | 2019 | |
950 | 950 | Jake Barrett | 27 | barreja01 | 2019 | NYY | AL | 0.068035077 | -0.142641509 | P | 0 | 1 | NYY | ARI | 2019 | 2019 | |
1045 | 1045 | Fernando Salas | 34 | salasfe01 | 2019 | PHI | NL | 0.054934181 | -0.010188679 | P | 0 | 1 | PHI | ARI | 2019 | 2019 | |
1179 | 1179 | Mitch Haniger | 28 | hanigmi01 | 2019 | SEA | AL | 2.705901747 | 1.258301887 | RF, CF | 7 | 1 | SEA | ARI | 2017 | 2019 | |
1206 | 1206 | Kristopher Negron | 33 | negrokr01 | 2019 | SEA | AL | 0.239037257 | 0.096792453 | CF, RF, LF, SS, 2B, 3B | 1 | 1 | SEA | ARI | 2018 | 2019 | LAD |
1305 | 1305 | Paul Goldschmidt | 31 | goldspa01 | 2019 | STL | NL | 6.74559721 | 3.046415094 | 1B | 20 | 1 | STL | ARI | 2019 | 2019 | |
1390 | 1390 | Anthony Banda | 25 | bandaan01 | 2019 | TBR | AL | 0.046073721 | 0.071320755 | P | 0 | 1 | TBD | ARI | 2018 | 2019 | |
1452 | 1452 | Shelby Miller | 28 | millesh01 | 2019 | TEX | AL | 1.184800841 | -0.570566038 | P | 0 | 1 | TEX | ARI | 2019 | 2019 | |
1454 | 1454 | Jeff Mathis | 36 | mathije01 | 2019 | TEX | AL | 2.335313531 | -1.823773585 | C, P | 0 | 1 | TEX | ARI | 2019 | 2019 | |
1489 | 1489 | Zack Godley | 29 | godleza01 | 2019 | TOR | AL | 0.418967738 | 0.13245283 | P | 1 | 2 | TOR | ARI | 2019 | 2019 | |
1496 | 1496 | Clay Buchholz | 34 | buchhcl01 | 2019 | TOR | AL | 1.583359363 | -0.259811321 | P | 1 | 1 | TOR | ARI | 2019 | 2019 | |
1513 | 1513 | Socrates Brito | 26 | britoso01 | 2019 | TOR | AL | 0.418035535 | -0.723396226 | RF, CF, LF | 0 | 1 | TOR | ARI | 2019 | 2019 | |
1518 | 1518 | Patrick Corbin | 29 | corbipa01 | 2019 | WSN | NL | 5.695048435 | 5.328679245 | P | 23 | 1 | WSN | ARI | 2019 | 2019 | |
1616 | 1616 | Ender Inciarte | 27 | inciaen01 | 2018 | ATL | NL | 6.462941077 | 3.195 | CF | 19 | 1 | ATL | ARI | 2016 | 2019 | |
1729 | 1729 | J.D. Martinez | 30 | martijd02 | 2018 | BOS | AL | 5.992040751 | 6.14 | LF, RF | 28 | 1 | BOS | ARI | 2018 | 2019 | |
1798 | 1798 | Jorge De La Rosa | 37 | rosajo01 | 2018 | CHC | NL | 0.569170286 | 0.511840491 | P | 2 | 2 | CHC | ARI | 2018 | 2018 | |
1813 | 1813 | Allen Webster | 28 | webstal01 | 2018 | CHC | NL | 0.057955029 | -0.059631902 | P | 0 | 1 | CHC | ARI | 2018 | 2019 | |
1829 | 1829 | Matt Davidson | 27 | davidma02 | 2018 | CHW | AL | 4.755041322 | 1.065 | 1B, 3B, P | 9 | 1 | CHW | ARI | 2016 | 2018 | |
1884 | 1884 | David Hernandez | 33 | hernada01 | 2018 | CIN | NL | 2.237869844 | 1.435 | P | 7 | 1 | CIN | ARI | 2018 | 2019 | |
1929 | 1929 | Trevor Bauer | 27 | bauertr01 | 2018 | CLE | AL | 4.977575604 | 5.755 | P | 23 | 1 | CLE | ARI | 2013 | 2019 | CIN |
1966 | 1966 | Adam Rosales | 35 | rosalad01 | 2018 | CLE | AL | 0.194134523 | -0.045 | 1B, 2B, 3B, SS | 0 | 1 | CLE | ARI | 2018 | 2018 | |
1992 | 1992 | Chris Iannetta | 35 | iannech01 | 2018 | COL | NL | 3.57350676 | 0.094417178 | C | 6 | 1 | COL | ARI | 2018 | 2019 | |
2085 | 2085 | Tony Sipp | 34 | sippto01 | 2018 | HOU | AL | 1.165055035 | 1.045 | P | 5 | 1 | HOU | ARI | 2014 | 2018 | WSN |
2086 | 2086 | Will Harris | 33 | harriwi10 | 2018 | HOU | AL | 1.616235957 | 0.88 | P | 5 | 1 | HOU | ARI | 2015 | 2019 | |
2163 | 2163 | Tyler Skaggs | 26 | skaggty01 | 2018 | LAA | AL | 3.726936185 | 1.865 | P | 10 | 1 | ANA | ARI | 2014 | 2019 | |
2283 | 2283 | Peter O'Brien | 27 | obriepe01 | 2018 | MIA | NL | 0.74 | 0.628881988 | 1B, RF | 3 | 1 | FLA | ARI | 2018 | 2019 | |
2330 | 2330 | Chase Anderson | 30 | anderch01 | 2018 | MIL | NL | 4.277050408 | 0.526748466 | P | 8 | 1 | MIL | ARI | 2016 | 2019 | |
2367 | 2367 | J.J. Hoover | 30 | hoovejj01 | 2018 | MIL | NL | 0.054622409 | -0.268343558 | P | 0 | 1 | MIL | ARI | 2018 | 2018 | |
2387 | 2387 | Fernando Rodney | 41 | rodnefe01 | 2018 | MIN | AL | 1.763617976 | 0.655 | P | 5 | 1 | MIN | ARI | 2018 | 2018 | OAK |
2463 | 2463 | Jack Reinheimer | 25 | reinhja01 | 2018 | NYM | NL | 0.347364819 | -0.2 | LF, 3B, SS, 2B | 0 | 1 | NYM | ARI | 2018 | 2018 | |
2485 | 2485 | Didi Gregorius | 28 | gregodi01 | 2018 | NYY | AL | 5.281164986 | 4.46 | SS | 20 | 1 | NYY | ARI | 2015 | 2019 | |
2528 | 2528 | Brandon Drury | 25 | drurybr01 | 2018 | NYY | AL | 0.529044647 | -0.41 | 3B, 2B, 1B, SS | 0 | 1 | NYY | ARI | 2018 | 2018 | TOR |
2728 | 2728 | Mitch Haniger | 27 | hanigmi01 | 2018 | SEA | AL | 6.531574608 | 5.31 | RF, CF, LF | 26 | 1 | SEA | ARI | 2017 | 2019 | |
2729 | 2729 | Jean Segura | 28 | segurje01 | 2018 | SEA | AL | 6.043858203 | 4.02 | SS | 22 | 1 | SEA | ARI | 2017 | 2018 | PHI |
2749 | 2749 | Chris Herrmann | 30 | herrmch01 | 2018 | SEA | AL | 0.83198681 | 0.55 | C, 1B | 3 | 1 | SEA | ARI | 2018 | 2018 | OAK |
2763 | 2763 | Kristopher Negron | 32 | negrokr01 | 2018 | SEA | AL | 0.286892003 | 0.025 | 3B, LF, 2B, SS, RF | 1 | 2 | SEA | ARI | 2018 | 2019 | LAD |
2816 | 2816 | Gregor Blanco | 34 | blancgr01 | 2018 | SFG | NL | 2.03035006 | -0.725 | LF, CF, RF | 1 | 1 | SFG | ARI | 2018 | 2018 | |
2916 | 2916 | Anthony Banda | 24 | bandaan01 | 2018 | TBR | AL | 0.347253118 | 0.24 | P | 1 | 1 | TBD | ARI | 2018 | 2019 | |
3144 | 3144 | Ender Inciarte | 26 | inciaen01 | 2017 | ATL | NL | 7.065490329 | 2.88 | CF | 19 | 1 | ATL | ARI | 2016 | 2019 | |
3190 | 3190 | Josh Collmenter | 31 | collmjo01 | 2017 | ATL | NL | 0.456768434 | -0.63 | P | 0 | 1 | ATL | ARI | 2016 | 2017 | |
3198 | 3198 | Welington Castillo | 30 | castiwe01 | 2017 | BAL | AL | 3.458020255 | 2.08 | C | 12 | 1 | BAL | ARI | 2017 | 2017 | CHW |
3318 | 3318 | Miguel Montero | 33 | montemi01 | 2017 | CHC | NL | 1.094892972 | 0.25 | C, 1B, P | 2 | 1 | CHC | ARI | 2015 | 2017 | TOR |
3361 | 3361 | Matt Davidson | 26 | davidma02 | 2017 | CHW | AL | 4.254677927 | -0.895 | 3B, 1B | 3 | 1 | CHW | ARI | 2016 | 2018 | |
3433 | 3433 | Bronson Arroyo | 40 | arroybr01 | 2017 | CIN | NL | 2.127243958 | -1.085 | P | 0 | 1 | CIN | ARI | 2017 | 2017 | |
3441 | 3441 | Trevor Bauer | 26 | bauertr01 | 2017 | CLE | AL | 5.063017046 | 2.97 | P | 15 | 1 | CLE | ARI | 2013 | 2019 | CIN |
3454 | 3454 | Bryan Shaw | 29 | shawbr01 | 2017 | CLE | AL | 2.599421333 | 1.07 | P | 6 | 1 | CLE | ARI | 2013 | 2017 | COL |
3587 | 3587 | Will Harris | 32 | harriwi10 | 2017 | HOU | AL | 1.741338498 | 0.915 | P | 5 | 1 | HOU | ARI | 2015 | 2019 | |
3612 | 3612 | Tony Sipp | 33 | sippto01 | 2017 | HOU | AL | 0.888544581 | -0.26 | P | 0 | 1 | HOU | ARI | 2014 | 2018 | WSN |
3676 | 3676 | Tyler Skaggs | 25 | skaggty01 | 2017 | LAA | AL | 2.378962367 | 0.675 | P | 6 | 1 | ANA | ARI | 2014 | 2019 | |
3816 | 3816 | Chase Anderson | 29 | anderch01 | 2017 | MIL | NL | 3.879476414 | 3.58 | P | 16 | 1 | MIL | ARI | 2016 | 2019 | |
3926 | 3926 | Addison Reed | 28 | reedad01 | 2017 | NYM | NL | 2.017205965 | 1.29 | P | 6 | 1 | NYM | ARI | 2015 | 2017 | BOS |
3970 | 3970 | Didi Gregorius | 27 | gregodi01 | 2017 | NYY | AL | 5.223574024 | 3.915 | SS, LF | 17 | 1 | NYY | ARI | 2015 | 2019 | |
4000 | 4000 | Tyler Clippard | 32 | clippty01 | 2017 | NYY | AL | 1.282938063 | -0.135 | P | 1 | 1 | NYY | ARI | 2016 | 2017 | CHW |
4064 | 4064 | Cesar Valdez | 32 | valdece01 | 2017 | OAK | AL | 0.200159262 | -0.24 | P | 0 | 1 | OAK | ARI | 2017 | 2017 | TOR |
4083 | 4083 | Jeremy Hellickson | 30 | hellije01 | 2017 | PHI | NL | 3.180410445 | 0.8 | P | 6 | 1 | PHI | ARI | 2016 | 2017 | BAL |
4141 | 4141 | A.J. Schugel | 28 | schugaj01 | 2017 | PIT | NL | 0.890747456 | 0.575 | P | 3 | 1 | PIT | ARI | 2016 | 2017 | |
4143 | 4143 | Daniel Hudson | 30 | hudsoda01 | 2017 | PIT | NL | 1.922905128 | 0.075 | P | 3 | 1 | PIT | ARI | 2017 | 2017 | LAD |
4165 | 4165 | Phil Gosselin | 28 | gosseph01 | 2017 | PIT | NL | 0.419060726 | -0.59 | 2B, SS, 3B, 1B | 0 | 1 | PIT | ARI | 2017 | 2017 | TEX |
4226 | 4226 | Jean Segura | 27 | segurje01 | 2017 | SEA | AL | 5.347450725 | 3.1 | SS | 16 | 1 | SEA | ARI | 2017 | 2018 | PHI |
4227 | 4227 | Mitch Haniger | 26 | hanigmi01 | 2017 | SEA | AL | 3.873595048 | 2.745 | RF, CF, LF | 13 | 1 | SEA | ARI | 2017 | 2019 | |
4265 | 4265 | Zac Curtis | 24 | curtiza01 | 2017 | SEA | AL | 0.076647646 | -0.05 | P | 0 | 1 | SEA | ARI | 2017 | 2017 | PHI |
4272 | 4272 | Evan Marshall | 27 | marshev01 | 2017 | SEA | AL | 0.158819447 | -0.18 | P | 0 | 1 | SEA | ARI | 2017 | 2017 | CLE |
4280 | 4280 | Mike Freeman | 29 | freemmi01 | 2017 | SEA | AL | 0.321224955 | -0.51 | SS, 1B, 2B, 3B, P | 0 | 1 | SEA | ARI | 2016 | 2017 | LAD |
4281 | 4281 | Tuffy Gosewisch | 33 | gosewtu01 | 2017 | SEA | AL | 0.292881577 | -0.58 | C, 1B | 0 | 1 | SEA | ARI | 2017 | 2017 | |
4410 | 4410 | Rickie Weeks | 34 | weeksri01 | 2017 | TBR | AL | 1.061091147 | 0.17 | 1B | 2 | 1 | TBD | ARI | 2017 | 2017 | |
4491 | 4491 | Dominic Leone | 25 | leonedo01 | 2017 | TOR | AL | 2.242419039 | 1.78 | P | 9 | 1 | TOR | ARI | 2017 | 2017 | STL |
4644 | 4644 | Ender Inciarte | 25 | inciaen01 | 2016 | ATL | NL | 5.703300442 | 3.481490683 | CF, LF | 19 | 1 | ATL | ARI | 2016 | 2019 | |
4665 | 4665 | Josh Collmenter | 30 | collmjo01 | 2016 | ATL | NL | 0.529751437 | 0.30689441 | P | 2 | 2 | ATL | ARI | 2016 | 2017 | |
4667 | 4667 | Jhoulys Chacin | 28 | chacijh01 | 2016 | ATL | NL | 0.719907272 | 0.211304348 | P | 2 | 1 | ATL | ARI | 2016 | 2016 | ANA |
4728 | 4728 | Nolan Reimold | 32 | reimono01 | 2016 | BAL | AL | 2.172248804 | -0.34 | LF, RF, CF | 2 | 1 | BAL | ARI | 2015 | 2016 | |
4731 | 4731 | Michael Bourn | 33 | bournmi01 | 2016 | BAL | AL | 0.526315789 | 0.215 | CF, LF, RF | 1 | 2 | BAL | ARI | 2016 | 2016 | |
4765 | 4765 | Brad Ziegler | 36 | zieglbr01 | 2016 | BOS | AL | 1.193800735 | 0.87 | P | 4 | 2 | BOS | ARI | 2016 | 2016 | FLA |
4815 | 4815 | Miguel Montero | 32 | montemi01 | 2016 | CHC | NL | 2.775400168 | 0.325 | C, P | 5 | 1 | CHC | ARI | 2015 | 2017 | TOR |
4844 | 4844 | Adam Eaton | 27 | eatonad02 | 2016 | CHW | AL | 6.702897365 | 5.98 | RF, CF, LF | 27 | 1 | CHW | ARI | 2014 | 2016 | WSN |
4874 | 4874 | Matt Davidson | 25 | davidma02 | 2016 | CHW | AL | 0.018988378 | 0.005 | 0 | 1 | CHW | ARI | 2016 | 2018 | ||
4940 | 4940 | Jordan Pacheco | 30 | pachejo01 | 2016 | CIN | NL | 0.512918328 | -0.595 | 3B, 1B, 2B | 0 | 1 | CIN | ARI | 2016 | 2016 | |
4951 | 4951 | Trevor Bauer | 25 | bauertr01 | 2016 | CLE | AL | 5.272891638 | 2.379689441 | P | 15 | 1 | CLE | ARI | 2013 | 2019 | CIN |
4961 | 4961 | Bryan Shaw | 28 | shawbr01 | 2016 | CLE | AL | 2.348251337 | 0.825093168 | P | 6 | 1 | CLE | ARI | 2013 | 2017 | COL |
5067 | 5067 | Jarrod Saltalamacchia | 31 | saltaja01 | 2016 | DET | AL | 2.77457405 | -0.598695652 | C, 1B | 2 | 1 | DET | ARI | 2016 | 2016 | TOR |
5098 | 5098 | Will Harris | 31 | harriwi10 | 2016 | HOU | AL | 2.336334547 | 1.665 | P | 8 | 1 | HOU | ARI | 2015 | 2019 | |
5125 | 5125 | Tony Sipp | 32 | sippto01 | 2016 | HOU | AL | 1.176263191 | -0.595 | P | 0 | 1 | HOU | ARI | 2014 | 2018 | WSN |
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 );