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,418 rows where next_franch = "SEA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87 | 87 | Jesse Biddle | 27 | biddlje01 | 2019 | ATL | NL | 0.328208447 | -0.219056604 | P | 0 | 1 | ATL | 2018 | 2019 | SEA | |
120 | 120 | Keon Broxton | 29 | broxtke01 | 2019 | BAL | AL | 1.073719008 | 0.071320755 | CF, LF, RF | 1 | 2 | BAL | NYM | 2019 | 2019 | SEA |
141 | 141 | Mike Wright | 29 | wrighmi01 | 2019 | BAL | AL | 0.332534985 | -0.310754717 | P | 0 | 1 | BAL | 2015 | 2019 | SEA | |
478 | 478 | David McKay | 24 | mckayda02 | 2019 | DET | AL | 0.527028325 | 0.307594937 | P | 1 | 1 | DET | 2019 | 2019 | SEA | |
836 | 836 | Matt Magill | 29 | magilma01 | 2019 | MIN | AL | 0.693097034 | -0.117169811 | P | 1 | 1 | MIN | CIN | 2018 | 2019 | SEA |
1150 | 1150 | Matt Wisler | 26 | wislema01 | 2019 | SDP | NL | 0.902489196 | -0.035660377 | P | 1 | 1 | SDP | CIN | 2019 | 2019 | SEA |
1297 | 1297 | Mac Williamson | 28 | willima11 | 2019 | SFG | NL | 0.573062923 | -0.397358491 | LF, RF | 0 | 1 | SFG | 2015 | 2019 | SEA | |
1545 | 1545 | Austin Adams | 28 | adamsau02 | 2019 | WSN | NL | 0.016793796 | -0.010188679 | P | 0 | 1 | WSN | 2017 | 2019 | SEA | |
1599 | 1599 | Kristopher Negron | 32 | negrokr01 | 2018 | ARI | NL | 0.029871245 | 0.055 | 3B, LF, 2B, SS, RF | 0 | 1 | ARI | CIN | 2017 | 2018 | SEA |
1633 | 1633 | Jesse Biddle | 26 | biddlje01 | 2018 | ATL | NL | 1.967147679 | 0.51 | P | 4 | 1 | ATL | 2018 | 2019 | SEA | |
1686 | 1686 | Tim Beckham | 28 | beckhti01 | 2018 | BAL | AL | 3.878888704 | 0.085 | SS, 3B, 2B | 5 | 1 | BAL | TBD | 2017 | 2018 | SEA |
1699 | 1699 | Mike Wright | 28 | wrighmi01 | 2018 | BAL | AL | 2.190879722 | 0.02 | P | 2 | 1 | BAL | 2015 | 2019 | SEA | |
1802 | 1802 | Anthony Bass | 30 | bassan01 | 2018 | CHC | NL | 0.40453187 | 0.213680982 | P | 1 | 1 | CHC | TEX | 2018 | 2018 | SEA |
1830 | 1830 | Omar Narvaez | 26 | narvaom01 | 2018 | CHW | AL | 3.086942149 | 1.5 | C | 8 | 1 | CHW | 2016 | 2018 | SEA | |
1935 | 1935 | Edwin Encarnacion | 35 | encared01 | 2018 | CLE | AL | 5.352566146 | 1.44 | 1B | 11 | 1 | CLE | TOR | 2017 | 2018 | SEA |
2001 | 2001 | Tom Murphy | 27 | murphto04 | 2018 | COL | NL | 0.952935136 | -0.17392638 | C | 1 | 1 | COL | 2015 | 2018 | SEA | |
2152 | 2152 | Justin Grimm | 29 | grimmju01 | 2018 | KCR | AL | 0.46603131 | -0.96 | P | 0 | 1 | KCR | CHC | 2018 | 2018 | SEA |
2256 | 2256 | Zac Rosscup | 30 | rosscza01 | 2018 | LAD | NL | 0.282495489 | 0.00993865 | P | 0 | 1 | LAD | COL | 2018 | 2018 | SEA |
2274 | 2274 | Cameron Maybin | 31 | maybica01 | 2018 | MIA | NL | 2.87 | 1.046459627 | LF, CF, RF | 8 | 1 | FLA | HOU | 2018 | 2018 | SEA |
2334 | 2334 | Domingo Santana | 25 | santado01 | 2018 | MIL | NL | 2.304311074 | 0.864662577 | RF | 6 | 1 | MIL | HOU | 2015 | 2018 | SEA |
2395 | 2395 | Zach Duke | 35 | dukeza01 | 2018 | MIN | AL | 1.251885102 | 0.5 | P | 3 | 1 | MIN | STL | 2018 | 2018 | SEA |
2397 | 2397 | Matt Magill | 28 | magilma01 | 2018 | MIN | AL | 1.697496585 | 0.215 | P | 3 | 1 | MIN | CIN | 2018 | 2019 | SEA |
2443 | 2443 | Jay Bruce | 31 | bruceja01 | 2018 | NYM | NL | 3.582819986 | -0.16 | RF, 1B | 4 | 1 | NYM | CLE | 2018 | 2018 | SEA |
2469 | 2469 | Gerson Bautista | 23 | bautige01 | 2018 | NYM | NL | 0.103781099 | -0.295 | P | 0 | 1 | NYM | 2018 | 2018 | SEA | |
2476 | 2476 | Anthony Swarzak | 32 | swarzan01 | 2018 | NYM | NL | 0.85121071 | -0.41 | P | 0 | 1 | NYM | MIL | 2018 | 2018 | SEA |
2505 | 2505 | Adam Warren | 30 | warread01 | 2018 | NYY | AL | 0.753239625 | 0.505 | P | 3 | 1 | NYY | CHC | 2016 | 2018 | SEA |
2522 | 2522 | Justus Sheffield | 22 | sheffju01 | 2018 | NYY | AL | 0.043700928 | -0.08 | P | 0 | 1 | NYY | 2018 | 2018 | SEA | |
2573 | 2573 | Cory Gearrin | 32 | gearrco01 | 2018 | OAK | AL | 0.118709894 | -0.03 | P | 0 | 3 | OAK | TEX | 2018 | 2018 | SEA |
2608 | 2608 | J.P. Crawford | 23 | crawfjp01 | 2018 | PHI | NL | 1.37148732 | 0.105 | SS, 3B | 2 | 1 | PHI | 2017 | 2018 | SEA | |
2804 | 2804 | Mac Williamson | 27 | willima11 | 2018 | SFG | NL | 1.050181066 | 0.395 | LF, RF | 3 | 1 | SFG | 2015 | 2019 | SEA | |
2814 | 2814 | Hunter Strickland | 29 | strichu01 | 2018 | SFG | NL | 1.522391543 | -0.315 | P | 1 | 1 | SFG | 2014 | 2018 | SEA | |
2859 | 2859 | Sam Tuivailala | 25 | tuivasa01 | 2018 | STL | NL | 0.876593825 | 0.045 | P | 1 | 1 | STL | 2014 | 2018 | SEA | |
2880 | 2880 | Mallex Smith | 25 | smithma05 | 2018 | TBR | AL | 5.111291106 | 3.51 | CF, RF, LF | 17 | 1 | TBD | ATL | 2017 | 2018 | SEA |
2900 | 2900 | Denard Span | 34 | spande01 | 2018 | TBR | AL | 1.625465738 | 0.76 | LF, CF | 4 | 1 | TBD | SFG | 2018 | 2018 | SEA |
2910 | 2910 | Alex Colome | 29 | colomal01 | 2018 | TBR | AL | 0.875457814 | 0.19 | P | 2 | 1 | TBD | 2013 | 2018 | SEA | |
2960 | 2960 | Connor Sadzeck | 26 | sadzeco01 | 2018 | TEX | AL | 0.310655501 | 0.21 | P | 1 | 1 | TEX | 2018 | 2018 | SEA | |
3073 | 3073 | Tommy Milone | 31 | milonto01 | 2018 | WSN | NL | 0.673370568 | 0.15 | P | 1 | 1 | WSN | NYM | 2018 | 2018 | SEA |
3082 | 3082 | Austin Adams | 27 | adamsau02 | 2018 | WSN | NL | 0.049497148 | 0.005 | P | 0 | 1 | WSN | 2017 | 2019 | SEA | |
3132 | 3132 | Chris Herrmann | 29 | herrmch01 | 2017 | ARI | NL | 2.527749404 | -0.855 | C, LF, 1B, RF | 1 | 1 | ARI | MIN | 2016 | 2017 | SEA |
3139 | 3139 | Kristopher Negron | 31 | negrokr01 | 2017 | ARI | NL | 0.306094654 | -0.195 | LF, SS, 1B, 2B | 0 | 1 | ARI | CIN | 2017 | 2018 | SEA |
3180 | 3180 | David Freitas | 28 | freitda01 | 2017 | ATL | NL | 0.167288768 | -0.01 | C | 0 | 1 | ATL | 2017 | 2017 | SEA | |
3200 | 3200 | Tim Beckham | 27 | beckhti01 | 2017 | BAL | AL | 2.179026462 | 1.975 | SS, 2B, 3B | 9 | 2 | BAL | TBD | 2017 | 2018 | SEA |
3223 | 3223 | Mike Wright | 27 | wrighmi01 | 2017 | BAL | AL | 0.518524209 | -0.03 | P | 1 | 1 | BAL | 2015 | 2019 | SEA | |
3278 | 3278 | Roenis Elias | 28 | eliasro01 | 2017 | BOS | AL | 0.004811935 | 0.005 | P | 0 | 1 | BOS | SEA | 2016 | 2017 | SEA |
3348 | 3348 | Omar Narvaez | 25 | narvaom01 | 2017 | CHW | AL | 2.833250538 | 1.255 | C, 1B | 7 | 1 | CHW | 2016 | 2018 | SEA | |
3421 | 3421 | Zach Vincej | 26 | vinceza01 | 2017 | CIN | NL | 0.11826678 | -0.025 | SS, 2B | 0 | 1 | CIN | 2017 | 2017 | SEA | |
3442 | 3442 | Edwin Encarnacion | 34 | encared01 | 2017 | CLE | AL | 6.245292129 | 2.545 | 1B | 15 | 1 | CLE | TOR | 2017 | 2018 | SEA |
3469 | 3469 | Shawn Armstrong | 26 | armstsh01 | 2017 | CLE | AL | 0.437004166 | 0.035 | P | 1 | 1 | CLE | 2015 | 2017 | SEA | |
3516 | 3516 | Tom Murphy | 26 | murphto04 | 2017 | COL | NL | 0.257162347 | -0.47 | C | 0 | 1 | COL | 2015 | 2018 | SEA | |
3545 | 3545 | Andrew Romine | 31 | rominan01 | 2017 | DET | AL | 3.293733681 | -0.67 | 2B, CF, 3B, 1B, LF, RF, SS, P, C | 2 | 1 | DET | ANA | 2014 | 2017 | SEA |
3646 | 3646 | Mike Morin | 26 | morinmi01 | 2017 | KCR | AL | 0.093075399 | 0.015 | P | 0 | 2 | KCR | ANA | 2017 | 2017 | SEA |
3716 | 3716 | Danny Espinosa | 30 | espinda01 | 2017 | LAA | AL | 2.434236616 | -1.15 | 2B, 3B, 1B, SS | 0 | 1 | ANA | WSN | 2017 | 2017 | SEA |
3773 | 3773 | Dee Gordon | 29 | gordode01 | 2017 | MIA | NL | 6.797639123 | 3.485 | 2B, SS | 20 | 1 | FLA | LAD | 2015 | 2017 | SEA |
3784 | 3784 | David Phelps | 30 | phelpda01 | 2017 | MIA | NL | 1.605410233 | 0.29 | P | 3 | 1 | FLA | NYY | 2015 | 2017 | SEA |
3792 | 3792 | Ichiro Suzuki | 43 | suzukic01 | 2017 | MIA | NL | 2.102866779 | -0.15 | RF, CF, LF | 2 | 1 | FLA | NYY | 2015 | 2017 | SEA |
3814 | 3814 | Domingo Santana | 24 | santado01 | 2017 | MIL | NL | 6.050180443 | 3.105 | RF | 18 | 1 | MIL | HOU | 2015 | 2018 | SEA |
3941 | 3941 | Chasen Bradford | 27 | bradfch02 | 2017 | NYM | NL | 0.896805053 | 0.225 | P | 2 | 1 | NYM | 2017 | 2017 | SEA | |
3954 | 3954 | Erik Goeddel | 28 | goedder01 | 2017 | NYM | NL | 0.68032269 | -0.165 | P | 0 | 1 | NYM | 2014 | 2017 | SEA | |
3982 | 3982 | Adam Warren | 29 | warread01 | 2017 | NYY | AL | 1.886028606 | 1.3 | P | 6 | 1 | NYY | CHC | 2016 | 2018 | SEA |
4023 | 4023 | Yonder Alonso | 30 | alonsyo01 | 2017 | OAK | AL | 3.52580698 | 1.78 | 1B | 10 | 1 | OAK | SDP | 2016 | 2017 | SEA |
4024 | 4024 | Ryon Healy | 25 | healyry01 | 2017 | OAK | AL | 5.749631329 | 0.695 | 1B, 3B | 10 | 1 | OAK | 2016 | 2017 | SEA | |
4093 | 4093 | J.P. Crawford | 22 | crawfjp01 | 2017 | PHI | NL | 0.865968766 | 0.685 | 3B, SS, 2B | 3 | 1 | PHI | 2017 | 2018 | SEA | |
4142 | 4142 | Wade LeBlanc | 32 | leblawa01 | 2017 | PIT | NL | 1.851464829 | 0.225 | P | 3 | 1 | PIT | SEA | 2016 | 2017 | SEA |
4292 | 4292 | Hunter Strickland | 28 | strichu01 | 2017 | SFG | NL | 2.212372505 | 1.3 | P | 7 | 1 | SFG | 2014 | 2018 | SEA | |
4318 | 4318 | Mac Williamson | 26 | willima11 | 2017 | SFG | NL | 0.727616429 | -0.255 | RF, LF | 0 | 1 | SFG | 2015 | 2019 | SEA | |
4341 | 4341 | Mike Leake | 29 | leakemi01 | 2017 | STL | NL | 4.30695994 | 1.41 | P | 10 | 1 | STL | SFG | 2016 | 2017 | SEA |
4353 | 4353 | Sam Tuivailala | 24 | tuivasa01 | 2017 | STL | NL | 0.963532037 | 0.5 | P | 3 | 1 | STL | 2014 | 2018 | SEA | |
4358 | 4358 | Juan Nicasio | 30 | nicasju01 | 2017 | STL | NL | 0.397641058 | 0.315 | P | 1 | 3 | STL | PHI | 2017 | 2017 | SEA |
4369 | 4369 | Marco Gonzales | 25 | gonzama02 | 2017 | STL | NL | 0.092728368 | -0.13 | P | 0 | 1 | STL | 2014 | 2017 | SEA | |
4390 | 4390 | Mallex Smith | 24 | smithma05 | 2017 | TBR | AL | 2.671675923 | 1.245 | CF, LF, RF | 7 | 1 | TBD | ATL | 2017 | 2018 | SEA |
4391 | 4391 | Alex Colome | 28 | colomal01 | 2017 | TBR | AL | 2.783306648 | 0.98 | P | 7 | 1 | TBD | 2013 | 2018 | SEA | |
4402 | 4402 | Erasmo Ramirez | 27 | ramirer02 | 2017 | TBR | AL | 2.236766433 | 0.235 | P | 4 | 1 | TBD | SEA | 2015 | 2017 | SEA |
4427 | 4427 | Ryan Garton | 27 | gartory01 | 2017 | TBR | AL | 0.265484634 | -0.295 | P | 0 | 1 | TBD | 2016 | 2017 | SEA | |
4537 | 4537 | Casey Lawrence | 29 | lawreca01 | 2017 | TOR | AL | 0.390943062 | -0.37 | P | 0 | 1 | TOR | 2017 | 2017 | SEA | |
4579 | 4579 | Austin Adams | 26 | adamsau02 | 2017 | WSN | NL | 0.079757026 | -0.02 | P | 0 | 1 | WSN | 2017 | 2019 | SEA | |
4592 | 4592 | Jean Segura | 26 | segurje01 | 2016 | ARI | NL | 6.792440094 | 5.235 | 2B, SS | 25 | 1 | ARI | MIL | 2016 | 2016 | SEA |
4603 | 4603 | Chris Herrmann | 28 | herrmch01 | 2016 | ARI | NL | 1.624704691 | 1.145 | C, RF, LF, 1B, CF | 6 | 1 | ARI | MIN | 2016 | 2017 | SEA |
4619 | 4619 | Mitch Haniger | 25 | hanigmi01 | 2016 | ARI | NL | 1.203847452 | 0.19 | CF, LF, RF | 2 | 1 | ARI | 2016 | 2016 | SEA | |
4632 | 4632 | Mike Freeman | 28 | freemmi01 | 2016 | ARI | NL | 0.107661154 | -0.2 | 2B, SS, LF, RF | 0 | 1 | ARI | 2016 | 2016 | SEA | |
4633 | 4633 | Zac Curtis | 23 | curtiza01 | 2016 | ARI | NL | 0.365076063 | -0.29 | P | 0 | 1 | ARI | 2016 | 2016 | SEA | |
4637 | 4637 | Evan Marshall | 26 | marshev01 | 2016 | ARI | NL | 0.377180189 | -0.41 | P | 0 | 1 | ARI | 2014 | 2016 | SEA | |
4641 | 4641 | Tuffy Gosewisch | 32 | gosewtu01 | 2016 | ARI | NL | 0.968950388 | -0.675 | C | 0 | 1 | ARI | 2013 | 2016 | SEA | |
4673 | 4673 | Shae Simmons | 25 | simmosh01 | 2016 | ATL | NL | 0.158340261 | 0.166024845 | P | 1 | 1 | ATL | 2014 | 2016 | SEA | |
4680 | 4680 | Ryan Weber | 25 | weberry01 | 2016 | ATL | NL | 0.937993935 | -0.231428571 | P | 1 | 1 | ATL | 2015 | 2016 | SEA | |
4693 | 4693 | Rob Whalen | 22 | whalero01 | 2016 | ATL | NL | 0.68774748 | -0.206273292 | P | 0 | 1 | ATL | 2016 | 2016 | SEA | |
4718 | 4718 | Yovani Gallardo | 30 | gallayo01 | 2016 | BAL | AL | 3.414082349 | 0.55 | P | 7 | 1 | BAL | TEX | 2016 | 2016 | SEA |
4724 | 4724 | Mike Wright | 26 | wrighmi01 | 2016 | BAL | AL | 1.929272674 | -0.12 | P | 3 | 1 | BAL | 2015 | 2019 | SEA | |
4738 | 4738 | Ariel Miranda | 27 | miranar01 | 2016 | BAL | AL | 0.045797534 | -0.01 | P | 0 | 1 | BAL | 2016 | 2016 | SEA | |
4796 | 4796 | Roenis Elias | 27 | eliasro01 | 2016 | BOS | AL | 0.161600635 | -0.315 | P | 0 | 1 | BOS | SEA | 2016 | 2017 | SEA |
4866 | 4866 | Omar Narvaez | 24 | narvaom01 | 2016 | CHW | AL | 1.110820101 | 0.24 | C | 2 | 1 | CHW | 2016 | 2018 | SEA | |
4977 | 4977 | Shawn Armstrong | 25 | armstsh01 | 2016 | CLE | AL | 0.27162457 | 0.140869565 | P | 1 | 1 | CLE | 2015 | 2017 | SEA | |
5012 | 5012 | Tom Murphy | 25 | murphto04 | 2016 | COL | NL | 0.481776572 | 0.68 | C | 3 | 1 | COL | 2015 | 2018 | SEA | |
5033 | 5033 | Matt Carasiti | 24 | carasma01 | 2016 | COL | NL | 0.371080261 | -0.275 | P | 0 | 1 | COL | 2016 | 2016 | SEA | |
5036 | 5036 | Christian Bergman | 28 | bergmch01 | 2016 | COL | NL | 0.641161887 | -0.425 | P | 0 | 1 | COL | 2014 | 2016 | SEA | |
5063 | 5063 | Andrew Romine | 30 | rominan01 | 2016 | DET | AL | 1.843381389 | 0.402484472 | 3B, CF, 1B, SS, 2B, RF, LF, P | 4 | 1 | DET | ANA | 2014 | 2017 | SEA |
5130 | 5130 | Jarrod Dyson | 31 | dysonja01 | 2016 | KCR | AL | 3.240921903 | 2.935 | CF, RF, LF | 14 | 1 | KCR | 2010 | 2016 | SEA | |
5253 | 5253 | Carlos Ruiz | 37 | ruizca01 | 2016 | LAD | NL | 0.396852549 | 0.165 | C | 1 | 2 | LAD | PHI | 2016 | 2016 | SEA |
5271 | 5271 | Casey Fien | 32 | fienca01 | 2016 | LAD | NL | 0.667422202 | -0.25 | P | 0 | 2 | LAD | MIN | 2016 | 2016 | SEA |
5285 | 5285 | David Phelps | 29 | phelpda01 | 2016 | MIA | NL | 3.063514862 | 2.349503106 | P | 11 | 1 | FLA | NYY | 2015 | 2017 | SEA |
5288 | 5288 | Ichiro Suzuki | 42 | suzukic01 | 2016 | MIA | NL | 3.63933299 | 1.438881988 | RF, CF, LF | 9 | 1 | FLA | NYY | 2015 | 2017 | SEA |
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 );