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,054 rows where prev_franch = "SEA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | Ketel Marte | 25 | marteke01 | 2019 | ARI | NL | 6.191398946 | 7.15754717 | CF, 2B, SS | 30 | 1 | ARI | SEA | 2017 | 2019 | |
10 | 10 | Jarrod Dyson | 34 | dysonja01 | 2019 | ARI | NL | 4.387217406 | 1.21245283 | CF, RF, LF | 10 | 1 | ARI | SEA | 2018 | 2019 | |
38 | 38 | Mike Leake | 31 | leakemi01 | 2019 | ARI | NL | 1.679247681 | -0.468679245 | P | 1 | 2 | ARI | SEA | 2019 | 2019 | |
70 | 70 | Anthony Swarzak | 33 | swarzan01 | 2019 | ATL | NL | 1.343673848 | 0.112075472 | P | 3 | 2 | ATL | SEA | 2019 | 2019 | |
106 | 106 | Shawn Armstrong | 28 | armstsh01 | 2019 | BAL | AL | 1.898930643 | 0.53490566 | P | 4 | 2 | BAL | SEA | 2019 | 2019 | |
137 | 137 | Mark Trumbo | 33 | trumbma01 | 2019 | BAL | AL | 0.258842975 | -0.193584906 | 0 | 1 | BAL | SEA | 2016 | 2019 | ||
144 | 144 | Tayler Scott | 27 | scottta02 | 2019 | BAL | AL | 0.148601572 | -0.427924528 | P | 0 | 2 | BAL | SEA | 2019 | 2019 | |
188 | 188 | Erasmo Ramirez | 29 | ramirer02 | 2019 | BOS | AL | 0.052360459 | -0.091698113 | P | 0 | 1 | BOS | SEA | 2019 | 2019 | |
249 | 249 | Mike Montgomery | 29 | montgmi01 | 2019 | CHC | NL | 0.923602972 | -0.387169811 | P | 0 | 1 | CHC | SEA | 2016 | 2019 | KCR |
264 | 264 | Alex Colome | 30 | colomal01 | 2019 | CHW | AL | 2.37508273 | 1.056075949 | P | 6 | 1 | CHW | SEA | 2019 | 2019 | |
282 | 282 | Ross Detwiler | 33 | detwiro01 | 2019 | CHW | AL | 1.736603505 | -0.579303797 | P | 1 | 1 | CHW | SEA | 2019 | 2019 | |
285 | 285 | Thyago Vieira | 25 | vieirth01 | 2019 | CHW | AL | 0.133844441 | -0.025632911 | P | 0 | 1 | CHW | SEA | 2018 | 2019 | |
333 | 333 | R.J. Alaniz | 28 | alanirj01 | 2019 | CIN | NL | 0.222551597 | 0.045849057 | P | 0 | 2 | CIN | SEA | 2019 | 2019 | |
337 | 337 | Zach Duke | 36 | dukeza01 | 2019 | CIN | NL | 0.66795772 | -0.178301887 | P | 0 | 1 | CIN | SEA | 2019 | 2019 | |
426 | 426 | James Pazos | 28 | pazosja01 | 2019 | COL | NL | 0.257730773 | 0.300566038 | P | 1 | 1 | COL | SEA | 2019 | 2019 | |
476 | 476 | Gordon Beckham | 32 | beckhgo01 | 2019 | DET | AL | 2.314899374 | -0.358860759 | 2B, SS, 3B, 1B | 2 | 1 | DET | SEA | 2019 | 2019 | |
482 | 482 | John Hicks | 29 | hicksjo02 | 2019 | DET | AL | 3.187891087 | -0.81 | C, 1B | 1 | 1 | DET | SEA | 2016 | 2019 | |
666 | 666 | Chris Taylor | 28 | tayloch03 | 2019 | LAD | NL | 4.017921765 | 1.925660377 | LF, SS, 2B, CF, 3B, RF | 12 | 1 | LAD | SEA | 2016 | 2019 | |
690 | 690 | Kristopher Negron | 33 | negrokr01 | 2019 | LAD | NL | 0.539720834 | -0.015283019 | CF, RF, LF, SS, 2B, 3B | 1 | 2 | LAD | SEA | 2019 | 2019 | |
759 | 759 | Eric Thames | 32 | thameer01 | 2019 | MIL | NL | 4.417545053 | 1.783018868 | 1B, RF | 13 | 1 | MIL | SEA | 2017 | 2019 | |
764 | 764 | Ben Gamel | 27 | gamelbe01 | 2019 | MIL | NL | 3.372322339 | 0.759056604 | LF, CF, RF | 8 | 1 | MIL | SEA | 2019 | 2019 | |
792 | 792 | David Freitas | 30 | freitda01 | 2019 | MIL | NL | 0.147908875 | -0.13245283 | C | 0 | 2 | MIL | SEA | 2019 | 2019 | |
804 | 804 | Nelson Cruz | 38 | cruzne02 | 2019 | MIN | AL | 4.745454545 | 4.156981132 | 19 | 1 | MIN | SEA | 2019 | 2019 | ||
834 | 834 | Mike Morin | 28 | morinmi01 | 2019 | MIN | AL | 0.584721861 | 0.142641509 | P | 1 | 1 | MIN | SEA | 2019 | 2019 | PHI |
845 | 845 | Chase De Jong | 25 | dejonch01 | 2019 | MIN | AL | 0.014825605 | -0.112075472 | P | 0 | 1 | MIN | SEA | 2018 | 2019 | |
865 | 865 | Robinson Cano | 36 | canoro01 | 2019 | NYM | NL | 4.141438356 | 0.667358491 | 2B | 7 | 1 | NYM | SEA | 2019 | 2019 | |
874 | 874 | Edwin Diaz | 25 | diazed04 | 2019 | NYM | NL | 2.0465637 | -0.361698113 | P | 2 | 1 | NYM | SEA | 2019 | 2019 | |
910 | 910 | James Paxton | 30 | paxtoja01 | 2019 | NYY | AL | 4.25665365 | 2.898679245 | P | 15 | 1 | NYY | SEA | 2019 | 2019 | |
920 | 920 | Cameron Maybin | 32 | maybica01 | 2019 | NYY | AL | 2.469297527 | 1.518113208 | LF, RF, CF | 8 | 1 | NYY | SEA | 2019 | 2019 | |
927 | 927 | Edwin Encarnacion | 36 | encared01 | 2019 | NYY | AL | 1.870967742 | 0.738679245 | 1B, 2B | 5 | 2 | NYY | SEA | 2019 | 2019 | |
939 | 939 | Cory Gearrin | 33 | gearrco01 | 2019 | NYY | AL | 0.321214791 | 0.010188679 | P | 1 | 2 | NYY | SEA | 2019 | 2019 | |
996 | 996 | Chris Herrmann | 31 | herrmch01 | 2019 | OAK | AL | 0.888237211 | -0.244528302 | C, LF | 1 | 1 | OAK | SEA | 2019 | 2019 | |
1013 | 1013 | Jean Segura | 29 | segurje01 | 2019 | PHI | NL | 6.164058469 | 1.956226415 | SS | 15 | 1 | PHI | SEA | 2019 | 2019 | |
1027 | 1027 | Jay Bruce | 32 | bruceja01 | 2019 | PHI | NL | 1.486156492 | 0.188490566 | LF, RF, 1B | 3 | 2 | PHI | SEA | 2019 | 2019 | |
1028 | 1028 | Juan Nicasio | 32 | nicasju01 | 2019 | PHI | NL | 1.396107121 | 0.13754717 | P | 3 | 1 | PHI | SEA | 2019 | 2019 | |
1100 | 1100 | Parker Markel | 28 | markepa01 | 2019 | PIT | NL | 0.386788919 | -0.117169811 | P | 0 | 2 | PIT | SEA | 2019 | 2019 | |
1170 | 1170 | Adam Warren | 31 | warread01 | 2019 | SDP | NL | 0.861947591 | -0.53490566 | P | 0 | 1 | SDP | SEA | 2019 | 2019 | |
1296 | 1296 | Nick Vincent | 32 | vinceni01 | 2019 | SFG | NL | 0.683567224 | -0.320943396 | P | 0 | 1 | SFG | SEA | 2019 | 2019 | PHI |
1367 | 1367 | Guillermo Heredia | 28 | heredgu01 | 2019 | TBR | AL | 2.141161164 | 0.27509434 | CF, RF, LF | 4 | 1 | TBD | SEA | 2019 | 2019 | |
1369 | 1369 | Mike Zunino | 28 | zuninmi01 | 2019 | TBR | AL | 2.678809563 | 0.224150943 | C | 4 | 1 | TBD | SEA | 2019 | 2019 | |
1410 | 1410 | Adrian Sampson | 27 | sampsad01 | 2019 | TEX | AL | 3.610657601 | 1.054528302 | P | 8 | 1 | TEX | SEA | 2018 | 2019 | |
1445 | 1445 | Jesse Biddle | 27 | biddlje01 | 2019 | TEX | AL | 0.120233489 | -0.224150943 | P | 0 | 3 | TEX | SEA | 2019 | 2019 | |
1467 | 1467 | Justin Smoak | 32 | smoakju01 | 2019 | TOR | AL | 4.783104257 | 0.310754717 | 1B | 7 | 1 | TOR | SEA | 2015 | 2019 | |
1488 | 1488 | David Phelps | 32 | phelpda01 | 2019 | TOR | AL | 0.55716019 | 0.163018868 | P | 1 | 1 | TOR | SEA | 2019 | 2019 | CHC |
1501 | 1501 | Zac Rosscup | 31 | rosscza01 | 2019 | TOR | AL | 0.017561522 | -0.076415094 | P | 0 | 2 | TOR | SEA | 2019 | 2019 | LAD |
1553 | 1553 | Hunter Strickland | 30 | strichu01 | 2019 | WSN | NL | 0.671751842 | -0.173207547 | P | 0 | 2 | WSN | SEA | 2019 | 2019 | |
1556 | 1556 | Roenis Elias | 30 | eliasro01 | 2019 | WSN | NL | 0.120175788 | -0.239433962 | P | 0 | 2 | WSN | SEA | 2019 | 2019 | |
1569 | 1569 | Ketel Marte | 24 | marteke01 | 2018 | ARI | NL | 5.775107296 | 2.94 | 2B, SS | 17 | 1 | ARI | SEA | 2017 | 2019 | |
1584 | 1584 | Jarrod Dyson | 33 | dysonja01 | 2018 | ARI | NL | 2.359828326 | 0.22 | CF, RF, LF | 4 | 1 | ARI | SEA | 2018 | 2019 | |
1593 | 1593 | Taijuan Walker | 25 | walketa01 | 2018 | ARI | NL | 0.352190425 | 0.15 | P | 1 | 1 | ARI | SEA | 2017 | 2018 | |
1670 | 1670 | Jose Ramirez | 28 | ramirjo02 | 2018 | ATL | NL | 0.190067101 | -0.435 | P | 0 | 1 | ATL | SEA | 2016 | 2018 | |
1679 | 1679 | Adam Jones | 32 | jonesad01 | 2018 | BAL | AL | 5.914822825 | 0.275 | CF, RF, LF | 7 | 1 | BAL | SEA | 2008 | 2018 | ARI |
1685 | 1685 | Mark Trumbo | 32 | trumbma01 | 2018 | BAL | AL | 3.454333722 | 0.26 | RF, 1B | 5 | 1 | BAL | SEA | 2016 | 2019 | |
1701 | 1701 | Danny Valencia | 33 | valenda01 | 2018 | BAL | AL | 2.721011479 | -0.26 | 3B, RF, 1B, P | 2 | 1 | BAL | SEA | 2018 | 2018 | |
1719 | 1719 | John Andreoli | 28 | andrejo03 | 2018 | BAL | AL | 0.588587589 | -0.345 | LF, RF, CF | 0 | 2 | BAL | SEA | 2018 | 2018 | |
1759 | 1759 | Carson Smith | 28 | smithca02 | 2018 | BOS | AL | 0.469215528 | 0.18 | P | 1 | 1 | BOS | SEA | 2016 | 2018 | |
1787 | 1787 | Mike Montgomery | 28 | montgmi01 | 2018 | CHC | NL | 3.146294915 | 1.316871166 | P | 9 | 1 | CHC | SEA | 2016 | 2019 | KCR |
1865 | 1865 | Thyago Vieira | 24 | vieirth01 | 2018 | CHW | AL | 0.427633557 | -0.305 | P | 0 | 1 | CHW | SEA | 2018 | 2019 | |
1915 | 1915 | Yovani Gallardo | 32 | gallayo01 | 2018 | CIN | NL | 0.047828037 | -0.245 | P | 0 | 1 | CIN | SEA | 2018 | 2018 | TEX |
1937 | 1937 | Yonder Alonso | 31 | alonsyo01 | 2018 | CLE | AL | 5.30634364 | 1.125 | 1B | 10 | 1 | CLE | SEA | 2018 | 2018 | CHW |
1959 | 1959 | Marc Rzepczynski | 32 | rzepcma01 | 2018 | CLE | AL | 0.076103017 | 0.075 | P | 0 | 2 | CLE | SEA | 2018 | 2018 | |
1967 | 1967 | Evan Marshall | 28 | marshev01 | 2018 | CLE | AL | 0.215459196 | -0.06 | P | 0 | 1 | CLE | SEA | 2018 | 2018 | CHW |
2034 | 2034 | John Hicks | 28 | hicksjo02 | 2018 | DET | AL | 3.010981697 | -0.015 | 1B, C | 4 | 1 | DET | SEA | 2016 | 2019 | |
2219 | 2219 | Chris Taylor | 27 | tayloch03 | 2018 | LAD | NL | 5.814439834 | 3.592822086 | SS, CF, LF, 2B | 18 | 1 | LAD | SEA | 2016 | 2019 | |
2248 | 2248 | Pat Venditte | 33 | vendipa01 | 2018 | LAD | NL | 0.258193769 | 0.15404908 | P | 1 | 1 | LAD | SEA | 2018 | 2018 | SFG |
2249 | 2249 | Erik Goeddel | 29 | goedder01 | 2018 | LAD | NL | 0.777655042 | 0.139141104 | P | 1 | 2 | LAD | SEA | 2018 | 2018 | |
2308 | 2308 | Tyler Cloyd | 31 | cloydty01 | 2018 | MIA | NL | 0.309528905 | -0.30689441 | P | 0 | 1 | FLA | SEA | 2018 | 2018 | |
2332 | 2332 | Eric Thames | 31 | thameer01 | 2018 | MIL | NL | 2.725950972 | 0.745398773 | RF, 1B, LF | 7 | 1 | MIL | SEA | 2017 | 2019 | |
2404 | 2404 | Chase De Jong | 24 | dejonch01 | 2018 | MIN | AL | 0.492358462 | 0.145 | P | 1 | 1 | MIN | SEA | 2018 | 2019 | |
2417 | 2417 | Taylor Motter | 28 | motteta01 | 2018 | MIN | AL | 0.198630137 | -0.31 | 1B, RF, 2B, 3B, LF, P, SS | 0 | 2 | MIN | SEA | 2018 | 2018 | |
2562 | 2562 | Emilio Pagan | 27 | paganem01 | 2018 | OAK | AL | 1.499261989 | 0.05 | P | 2 | 1 | OAK | SEA | 2018 | 2018 | TBD |
2580 | 2580 | Boog Powell | 25 | powelbo02 | 2018 | OAK | AL | 0.232595444 | -0.37 | CF | 0 | 1 | OAK | SEA | 2017 | 2018 | |
2613 | 2613 | Zac Curtis | 25 | curtiza01 | 2018 | PHI | NL | 0.148738729 | 0.125 | P | 1 | 1 | PHI | SEA | 2017 | 2018 | TEX |
2866 | 2866 | Steven Baron | 27 | baronst01 | 2018 | STL | NL | 0.049378512 | -0.02 | C | 0 | 1 | STL | SEA | 2018 | 2018 | PIT |
2909 | 2909 | Brad Miller | 28 | millebr02 | 2018 | TBR | AL | 1.634861494 | 0.245 | 1B, 2B, SS | 3 | 1 | TBD | SEA | 2016 | 2018 | MIL |
2925 | 2925 | Ryan Weber | 27 | weberry01 | 2018 | TBR | AL | 0.120224814 | -0.11 | P | 0 | 1 | TBD | SEA | 2018 | 2018 | BOS |
2931 | 2931 | Jesus Sucre | 30 | sucreje01 | 2018 | TBR | AL | 1.860359631 | -0.805 | C, P | 0 | 1 | TBD | SEA | 2017 | 2018 | BAL |
2962 | 2962 | Adrian Sampson | 26 | sampsad01 | 2018 | TEX | AL | 0.624429828 | 0.095 | P | 1 | 1 | TEX | SEA | 2018 | 2019 | |
2983 | 2983 | Justin Smoak | 31 | smoakju01 | 2018 | TOR | AL | 5.692663582 | 1.985 | 1B | 14 | 1 | TOR | SEA | 2015 | 2019 | |
3103 | 3103 | Taijuan Walker | 24 | walketa01 | 2017 | ARI | NL | 4.369766322 | 2.955 | P | 15 | 1 | ARI | SEA | 2017 | 2018 | |
3109 | 3109 | Chris Iannetta | 34 | iannech01 | 2017 | ARI | NL | 3.120190671 | 2.06 | C, 3B | 11 | 1 | ARI | SEA | 2017 | 2017 | COL |
3112 | 3112 | Ketel Marte | 23 | marteke01 | 2017 | ARI | NL | 2.517875383 | 0.905 | SS, 3B | 6 | 1 | ARI | SEA | 2017 | 2019 | |
3130 | 3130 | Tom Wilhelmsen | 33 | wilheto01 | 2017 | ARI | NL | 0.707659935 | -0.005 | P | 1 | 1 | ARI | SEA | 2017 | 2017 | |
3160 | 3160 | Jose Ramirez | 27 | ramirjo02 | 2017 | ATL | NL | 2.186443019 | 0.34 | P | 4 | 1 | ATL | SEA | 2016 | 2018 | |
3195 | 3195 | Adam Jones | 31 | jonesad01 | 2017 | BAL | AL | 6.016007841 | 2.11 | CF | 16 | 1 | BAL | SEA | 2008 | 2018 | ARI |
3203 | 3203 | Wade Miley | 30 | mileywa01 | 2017 | BAL | AL | 4.520199582 | 0.375 | P | 8 | 1 | BAL | SEA | 2016 | 2017 | MIL |
3205 | 3205 | Seth Smith | 34 | smithse01 | 2017 | BAL | AL | 3.53381248 | 0.415 | RF, LF | 7 | 1 | BAL | SEA | 2017 | 2017 | |
3207 | 3207 | Mark Trumbo | 31 | trumbma01 | 2017 | BAL | AL | 5.712838942 | -0.885 | RF, 1B, 3B | 6 | 1 | BAL | SEA | 2016 | 2019 | |
3238 | 3238 | Vidal Nuno III | 29 | nunovi01 | 2017 | BAL | AL | 0.317720908 | -0.515 | P | 0 | 1 | BAL | SEA | 2017 | 2017 | TBD |
3274 | 3274 | Carson Smith | 27 | smithca02 | 2017 | BOS | AL | 0.180090249 | 0.225 | P | 1 | 1 | BOS | SEA | 2016 | 2018 | |
3278 | 3278 | Roenis Elias | 28 | eliasro01 | 2017 | BOS | AL | 0.004811935 | 0.005 | P | 0 | 1 | BOS | SEA | 2016 | 2017 | SEA |
3299 | 3299 | Mike Montgomery | 27 | montgmi01 | 2017 | CHC | NL | 3.800072233 | 1.97 | P | 11 | 1 | CHC | SEA | 2016 | 2019 | KCR |
3323 | 3323 | Leonys Martin | 29 | martile01 | 2017 | CHC | NL | 0.156413282 | 0.09 | CF, RF, LF, P | 0 | 2 | CHC | SEA | 2017 | 2017 | DET |
3412 | 3412 | Drew Storen | 29 | storedr01 | 2017 | CIN | NL | 1.524620458 | -0.135 | P | 2 | 1 | CIN | SEA | 2017 | 2017 | |
3470 | 3470 | Daniel Robertson | 31 | roberda09 | 2017 | CLE | AL | 0.8215033 | -0.095 | RF, LF, CF | 1 | 1 | CLE | SEA | 2017 | 2017 | |
3537 | 3537 | John Hicks | 27 | hicksjo02 | 2017 | DET | AL | 1.798302872 | 0.365 | 1B, C | 3 | 1 | DET | SEA | 2016 | 2019 | |
3591 | 3591 | Nori Aoki | 35 | aokino01 | 2017 | HOU | AL | 2.081384172 | 0.135 | LF, RF, CF, P | 3 | 1 | HOU | SEA | 2017 | 2017 | TOR |
3630 | 3630 | Nate Karns | 29 | karnsna01 | 2017 | KCR | AL | 1.238748945 | 0.685 | P | 4 | 1 | KCR | SEA | 2017 | 2017 | BAL |
3635 | 3635 | Sam Gaviglio | 27 | gavigsa01 | 2017 | KCR | AL | 0.258022924 | 0.305 | P | 1 | 2 | KCR | SEA | 2017 | 2017 | TOR |
3658 | 3658 | Chris Young | 38 | youngch03 | 2017 | KCR | AL | 0.636098181 | -0.43 | P | 0 | 1 | KCR | SEA | 2015 | 2017 |
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 );