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,595 rows where next_franch = "MIL"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076 | 1076 | Jordan Lyles | 28 | lylesjo01 | 2019 | PIT | NL | 2.460064406 | 0.356603774 | P | 5 | 1 | PIT | MIL | 2019 | 2019 | MIL |
1215 | 1215 | David Freitas | 30 | freitda01 | 2019 | SEA | AL | 0.038245961 | -0.020377358 | C | 0 | 1 | SEA | ATL | 2018 | 2019 | MIL |
1262 | 1262 | Tyler Austin | 27 | austity01 | 2019 | SFG | NL | 1.477899116 | 0.183396226 | LF, 1B, RF | 3 | 2 | SFG | MIN | 2019 | 2019 | MIL |
1269 | 1269 | Drew Pomeranz | 30 | pomerdr01 | 2019 | SFG | NL | 2.036715642 | -0.468679245 | P | 2 | 1 | SFG | BOS | 2019 | 2019 | MIL |
1278 | 1278 | Ray Black | 29 | blackra01 | 2019 | SFG | NL | 0.029720314 | 0.00509434 | P | 0 | 1 | SFG | 2018 | 2019 | MIL | |
1386 | 1386 | Jake Faria | 25 | fariaja01 | 2019 | TBR | AL | 0.226780307 | 0.061132075 | P | 1 | 1 | TBD | 2017 | 2019 | MIL | |
1676 | 1676 | Jonathan Schoop | 26 | schoojo01 | 2018 | BAL | AL | 3.541174513 | 1.07 | 2B, SS | 7 | 1 | BAL | 2013 | 2018 | MIL | |
1705 | 1705 | Donnie Hart | 27 | hartdo01 | 2018 | BAL | AL | 0.564667646 | -0.01 | P | 1 | 1 | BAL | 2016 | 2018 | MIL | |
1834 | 1834 | Joakim Soria | 34 | soriajo01 | 2018 | CHW | AL | 1.366142127 | 1.215 | P | 5 | 1 | CHW | KCR | 2018 | 2018 | MIL |
1844 | 1844 | Xavier Cedeno | 31 | cedenxa01 | 2018 | CHW | AL | 0.837927233 | 0.51 | P | 3 | 1 | CHW | TBD | 2018 | 2018 | MIL |
1854 | 1854 | Tyler Saladino | 28 | saladty01 | 2018 | CHW | AL | 0.086280992 | 0.045 | SS, 2B, 3B | 0 | 1 | CHW | 2015 | 2018 | MIL | |
2029 | 2029 | Alex Wilson | 31 | wilsoal01 | 2018 | DET | AL | 2.195098401 | 0.715 | P | 5 | 1 | DET | BOS | 2015 | 2018 | MIL |
2110 | 2110 | Mike Moustakas | 29 | moustmi01 | 2018 | KCR | AL | 4.003641781 | 1.91 | 3B, 1B | 10 | 1 | KCR | 2011 | 2018 | MIL | |
2151 | 2151 | Burch Smith | 28 | smithbu03 | 2018 | KCR | AL | 1.854852475 | -0.85 | P | 0 | 1 | KCR | SDP | 2018 | 2018 | MIL |
2218 | 2218 | Yasmani Grandal | 29 | grandya01 | 2018 | LAD | NL | 4.986556017 | 3.970490798 | C, 1B | 18 | 1 | LAD | SDP | 2015 | 2018 | MIL |
2692 | 2692 | Cory Spangenberg | 27 | spangco01 | 2018 | SDP | NL | 3.309399931 | 0.62 | 2B, 3B, LF, P, SS | 7 | 1 | SDP | 2014 | 2018 | MIL | |
2702 | 2702 | Jordan Lyles | 27 | lylesjo01 | 2018 | SDP | NL | 1.738388153 | 0.16 | P | 3 | 1 | SDP | COL | 2017 | 2018 | MIL |
2741 | 2741 | Ben Gamel | 26 | gamelbe01 | 2018 | SEA | AL | 2.801978566 | 0.69 | LF, RF, CF, 1B | 7 | 1 | SEA | NYY | 2016 | 2018 | MIL |
2765 | 2765 | David Freitas | 29 | freitda01 | 2018 | SEA | AL | 1.013685078 | -0.05 | C, 1B | 1 | 1 | SEA | ATL | 2018 | 2019 | MIL |
2823 | 2823 | Ray Black | 28 | blackra01 | 2018 | SFG | NL | 0.66924117 | -0.21 | P | 0 | 1 | SFG | 2018 | 2019 | MIL | |
2909 | 2909 | Brad Miller | 28 | millebr02 | 2018 | TBR | AL | 1.634861494 | 0.245 | 1B, 2B, SS | 3 | 1 | TBD | SEA | 2016 | 2018 | MIL |
2914 | 2914 | Jake Faria | 24 | fariaja01 | 2018 | TBR | AL | 1.603470101 | -0.07 | P | 2 | 1 | TBD | 2017 | 2019 | MIL | |
2948 | 2948 | Alex Claudio | 26 | claudal01 | 2018 | TEX | AL | 2.253479463 | 0.87 | P | 5 | 1 | TEX | 2014 | 2018 | MIL | |
2996 | 2996 | Curtis Granderson | 37 | grandcu01 | 2018 | TOR | AL | 3.344679445 | 0.55 | LF, RF, CF | 7 | 1 | TOR | LAD | 2018 | 2018 | MIL |
3016 | 3016 | Jake Petricka | 30 | petrija01 | 2018 | TOR | AL | 1.30454879 | 0.01 | P | 2 | 1 | TOR | CHW | 2018 | 2018 | MIL |
3054 | 3054 | Gio Gonzalez | 32 | gonzagi01 | 2018 | WSN | NL | 4.073371042 | 1.27 | P | 9 | 1 | WSN | OAK | 2012 | 2018 | MIL |
3120 | 3120 | J.J. Hoover | 29 | hoovejj01 | 2017 | ARI | NL | 1.340355259 | 0.22 | P | 3 | 1 | ARI | CIN | 2017 | 2017 | MIL |
3192 | 3192 | Jonathan Schoop | 25 | schoojo01 | 2017 | BAL | AL | 6.394968964 | 4.46 | 2B, SS | 23 | 1 | BAL | 2013 | 2018 | MIL | |
3203 | 3203 | Wade Miley | 30 | mileywa01 | 2017 | BAL | AL | 4.520199582 | 0.375 | P | 8 | 1 | BAL | SEA | 2016 | 2017 | MIL |
3214 | 3214 | Donnie Hart | 26 | hartdo01 | 2017 | BAL | AL | 1.281382146 | 0.375 | P | 3 | 1 | BAL | 2016 | 2018 | MIL | |
3215 | 3215 | Alec Asher | 25 | asheral01 | 2017 | BAL | AL | 1.668495676 | 0.1 | P | 3 | 1 | BAL | PHI | 2017 | 2017 | MIL |
3227 | 3227 | Oliver Drake | 30 | drakeol01 | 2017 | BAL | AL | 0.06503958 | -0.025 | P | 0 | 1 | BAL | 2015 | 2017 | MIL | |
3345 | 3345 | Anthony Swarzak | 31 | swarzan01 | 2017 | CHW | AL | 1.88424953 | 1.8 | P | 8 | 1 | CHW | NYY | 2017 | 2017 | MIL |
3378 | 3378 | Tyler Saladino | 27 | saladty01 | 2017 | CHW | AL | 2.698791191 | -0.94 | 2B, 3B, SS, 1B | 1 | 1 | CHW | 2015 | 2018 | MIL | |
3467 | 3467 | Boone Logan | 32 | loganbo02 | 2017 | CLE | AL | 0.583724344 | 0.17 | P | 1 | 1 | CLE | COL | 2017 | 2017 | MIL |
3534 | 3534 | Alex Wilson | 30 | wilsoal01 | 2017 | DET | AL | 2.060352393 | 0.395 | P | 4 | 1 | DET | BOS | 2015 | 2018 | MIL |
3613 | 3613 | Lorenzo Cain | 31 | cainlo01 | 2017 | KCR | AL | 6.235 | 4.785 | CF | 24 | 1 | KCR | MIL | 2011 | 2017 | MIL |
3618 | 3618 | Mike Moustakas | 28 | moustmi01 | 2017 | KCR | AL | 5.780666667 | 1.93 | 3B | 15 | 1 | KCR | 2011 | 2018 | MIL | |
3698 | 3698 | Deolis Guerra | 28 | guerrde01 | 2017 | LAA | AL | 0.662477005 | -0.06 | P | 1 | 1 | ANA | PIT | 2016 | 2017 | MIL |
3703 | 3703 | Nick Franklin | 26 | frankni01 | 2017 | LAA | AL | 0.287508262 | 0.01 | LF, 2B, RF, SS | 0 | 2 | ANA | MIL | 2017 | 2017 | MIL |
3723 | 3723 | Yasmani Grandal | 28 | grandya01 | 2017 | LAD | NL | 4.76739427 | 3.16 | C | 17 | 1 | LAD | SDP | 2015 | 2018 | MIL |
3771 | 3771 | Christian Yelich | 25 | yelicch01 | 2017 | MIA | NL | 6.797639123 | 4.41 | CF | 22 | 1 | FLA | 2013 | 2017 | MIL | |
3923 | 3923 | Neil Walker | 31 | walkene01 | 2017 | NYM | NL | 2.966980325 | 1.27 | 2B, 1B, 3B | 8 | 1 | NYM | PIT | 2016 | 2017 | MIL |
3995 | 3995 | Ji-Man Choi | 26 | choiji01 | 2017 | NYY | AL | 0.164954969 | 0.125 | 1B | 1 | 1 | NYY | ANA | 2017 | 2017 | MIL |
4003 | 4003 | Erik Kratz | 37 | kratzer01 | 2017 | NYY | AL | 0.01832833 | 0.105 | C | 0 | 1 | NYY | PIT | 2017 | 2017 | MIL |
4005 | 4005 | Tyler Webb | 26 | webbty01 | 2017 | NYY | AL | 0.155727133 | -0.035 | P | 0 | 1 | NYY | 2017 | 2017 | MIL | |
4052 | 4052 | Stephen Vogt | 32 | vogtst01 | 2017 | OAK | AL | 1.653612977 | -0.325 | C, LF | 1 | 1 | OAK | TBD | 2013 | 2017 | MIL |
4169 | 4169 | Jhoulys Chacin | 29 | chacijh01 | 2017 | SDP | NL | 5.106098096 | 2.795 | P | 17 | 1 | SDP | ANA | 2017 | 2017 | MIL |
4179 | 4179 | Cory Spangenberg | 26 | spangco01 | 2017 | SDP | NL | 4.991676997 | 0.47 | 3B, LF, 2B | 10 | 1 | SDP | 2014 | 2018 | MIL | |
4211 | 4211 | Jordan Lyles | 26 | lylesjo01 | 2017 | SDP | NL | 0.651239868 | -0.255 | P | 0 | 2 | SDP | COL | 2017 | 2018 | MIL |
4229 | 4229 | Ben Gamel | 25 | gamelbe01 | 2017 | SEA | AL | 5.19628604 | 1.395 | LF, RF, 1B | 11 | 1 | SEA | NYY | 2016 | 2018 | MIL |
4388 | 4388 | Jake Faria | 23 | fariaja01 | 2017 | TBR | AL | 2.315205075 | 1.38 | P | 7 | 1 | TBD | 2017 | 2019 | MIL | |
4393 | 4393 | Brad Miller | 27 | millebr02 | 2017 | TBR | AL | 3.855929435 | 0.25 | 2B | 6 | 1 | TBD | SEA | 2016 | 2018 | MIL |
4416 | 4416 | Dan Jennings | 30 | jennida01 | 2017 | TBR | AL | 0.61553897 | 0.105 | P | 1 | 2 | TBD | CHW | 2017 | 2017 | MIL |
4440 | 4440 | Alex Claudio | 25 | claudal01 | 2017 | TEX | AL | 2.953167722 | 2.335 | P | 11 | 1 | TEX | 2014 | 2018 | MIL | |
4462 | 4462 | Jeremy Jeffress | 29 | jeffrje01 | 2017 | TEX | AL | 1.215835873 | -0.23 | P | 1 | 1 | TEX | MIL | 2016 | 2017 | MIL |
4546 | 4546 | Gio Gonzalez | 31 | gonzagi01 | 2017 | WSN | NL | 5.633380344 | 4.935 | P | 23 | 1 | WSN | OAK | 2012 | 2018 | MIL |
4554 | 4554 | Matt Albers | 34 | alberma01 | 2017 | WSN | NL | 1.909696258 | 1.73 | P | 8 | 1 | WSN | CHW | 2017 | 2017 | MIL |
4706 | 4706 | Jonathan Schoop | 24 | schoojo01 | 2016 | BAL | AL | 6.19138756 | 2.325 | 2B | 16 | 1 | BAL | 2013 | 2018 | MIL | |
4721 | 4721 | Wade Miley | 29 | mileywa01 | 2016 | BAL | AL | 1.554021713 | 0.325 | P | 3 | 2 | BAL | SEA | 2016 | 2017 | MIL |
4726 | 4726 | Donnie Hart | 25 | hartdo01 | 2016 | BAL | AL | 0.482215021 | 0.52 | P | 2 | 1 | BAL | 2016 | 2018 | MIL | |
4733 | 4733 | Oliver Drake | 29 | drakeol01 | 2016 | BAL | AL | 0.498512341 | 0.06 | P | 1 | 1 | BAL | 2015 | 2017 | MIL | |
4758 | 4758 | Travis Shaw | 26 | shawtr01 | 2016 | BOS | AL | 4.884792627 | 1.83 | 3B, 1B, LF | 11 | 1 | BOS | 2015 | 2016 | MIL | |
4835 | 4835 | Neil Ramirez | 27 | ramirne01 | 2016 | CHC | NL | 0.224544592 | -0.01 | P | 0 | 1 | CHC | 2014 | 2016 | MIL | |
4854 | 4854 | Tyler Saladino | 26 | saladty01 | 2016 | CHW | AL | 3.02864626 | 1.445 | 2B, SS, 3B, 1B, CF, LF, RF | 8 | 1 | CHW | 2015 | 2018 | MIL | |
4987 | 4987 | Jesus Aguilar | 26 | aguilje01 | 2016 | CLE | AL | 0.056769984 | -0.155962733 | 1B | 0 | 1 | CLE | 2014 | 2016 | MIL | |
5051 | 5051 | Alex Wilson | 29 | wilsoal01 | 2016 | DET | AL | 2.493591927 | 1.453975155 | P | 8 | 1 | DET | BOS | 2015 | 2018 | MIL |
5131 | 5131 | Lorenzo Cain | 30 | cainlo01 | 2016 | KCR | AL | 4.173768861 | 2.585 | CF, RF | 14 | 1 | KCR | MIL | 2011 | 2017 | MIL |
5148 | 5148 | Mike Moustakas | 27 | moustmi01 | 2016 | KCR | AL | 1.08671862 | 0.78 | 3B | 4 | 1 | KCR | 2011 | 2018 | MIL | |
5184 | 5184 | Jett Bandy | 26 | bandyje01 | 2016 | LAA | AL | 2.225581395 | 0.73 | C | 5 | 1 | ANA | 2015 | 2016 | MIL | |
5190 | 5190 | Deolis Guerra | 27 | guerrde01 | 2016 | LAA | AL | 1.518345939 | 0.4 | P | 3 | 1 | ANA | PIT | 2016 | 2017 | MIL |
5226 | 5226 | Yasmani Grandal | 27 | grandya01 | 2016 | LAD | NL | 4.534040369 | 4.245 | C, 1B | 19 | 1 | LAD | SDP | 2015 | 2018 | MIL |
5278 | 5278 | Christian Yelich | 24 | yelicch01 | 2016 | MIA | NL | 6.570740932 | 5.418447205 | LF, CF | 25 | 1 | FLA | 2013 | 2017 | MIL | |
5414 | 5414 | Tommy Milone | 29 | milonto01 | 2016 | MIN | AL | 1.914406113 | -0.28 | P | 1 | 1 | MIN | OAK | 2014 | 2016 | MIL |
5435 | 5435 | Neil Walker | 30 | walkene01 | 2016 | NYM | NL | 4.586325967 | 3.1 | 2B | 15 | 1 | NYM | PIT | 2016 | 2017 | MIL |
5535 | 5535 | Stephen Vogt | 31 | vogtst01 | 2016 | OAK | AL | 5.14438146 | 1.17 | C, 1B | 11 | 1 | OAK | TBD | 2013 | 2017 | MIL |
5652 | 5652 | Neftali Feliz | 28 | felizne01 | 2016 | PIT | NL | 1.945577697 | 0.43 | P | 4 | 1 | PIT | DET | 2016 | 2016 | MIL |
5653 | 5653 | Jared Hughes | 30 | hugheja02 | 2016 | PIT | NL | 1.608814287 | 0.28 | P | 3 | 1 | PIT | 2011 | 2016 | MIL | |
5663 | 5663 | Rob Scahill | 29 | scahiro01 | 2016 | PIT | NL | 0.381705147 | 0.01 | P | 1 | 1 | PIT | COL | 2015 | 2016 | MIL |
5711 | 5711 | Cory Spangenberg | 25 | spangco01 | 2016 | SDP | NL | 0.540151116 | 0.24 | 2B | 2 | 1 | SDP | 2014 | 2018 | MIL | |
5733 | 5733 | Michael Kirkman | 29 | kirkmmi01 | 2016 | SDP | NL | 0.08623939 | -0.27 | P | 0 | 1 | SDP | TEX | 2016 | 2016 | MIL |
5789 | 5789 | Ben Gamel | 24 | gamelbe01 | 2016 | SEA | AL | 0.439535634 | -0.21 | RF, LF, CF | 0 | 2 | SEA | NYY | 2016 | 2018 | MIL |
5887 | 5887 | Brad Miller | 26 | millebr02 | 2016 | TBR | AL | 5.789403754 | 1.945 | SS, 1B, LF | 12 | 1 | TBD | SEA | 2016 | 2018 | MIL |
5904 | 5904 | Nick Franklin | 25 | frankni01 | 2016 | TBR | AL | 1.839893705 | 0.125 | LF, 1B, 2B, RF, SS | 2 | 1 | TBD | SEA | 2014 | 2016 | MIL |
5919 | 5919 | Jhan Marinez | 27 | marinjh01 | 2016 | TBR | AL | 0.062879206 | 0.03 | P | 0 | 1 | TBD | CHW | 2016 | 2016 | MIL |
5947 | 5947 | Alex Claudio | 24 | claudal01 | 2016 | TEX | AL | 1.360399916 | 1.015 | P | 6 | 1 | TEX | 2014 | 2018 | MIL | |
5955 | 5955 | Jeremy Jeffress | 28 | jeffrje01 | 2016 | TEX | AL | 0.437367715 | 0.25 | P | 2 | 2 | TEX | MIL | 2016 | 2017 | MIL |
6039 | 6039 | Gio Gonzalez | 30 | gonzagi01 | 2016 | WSN | NL | 4.868870985 | 1.805 | P | 13 | 1 | WSN | OAK | 2012 | 2018 | MIL |
6081 | 6081 | Chase Anderson | 27 | anderch01 | 2015 | ARI | NL | 4.16700428 | 1.045 | P | 9 | 1 | ARI | 2014 | 2015 | MIL | |
6093 | 6093 | Aaron Hill | 33 | hillaa01 | 2015 | ARI | NL | 3.442744241 | -0.22 | 2B, 3B | 4 | 1 | ARI | TOR | 2011 | 2015 | MIL |
6195 | 6195 | Jonathan Schoop | 23 | schoojo01 | 2015 | BAL | AL | 3.110776942 | 1.34 | 2B | 8 | 1 | BAL | 2013 | 2018 | MIL | |
6213 | 6213 | Oliver Drake | 28 | drakeol01 | 2015 | BAL | AL | 0.370553826 | 0.12 | P | 1 | 1 | BAL | 2015 | 2017 | MIL | |
6243 | 6243 | Travis Shaw | 25 | shawtr01 | 2015 | BOS | AL | 2.315518352 | 1.29 | 1B, 3B, LF | 7 | 1 | BOS | 2015 | 2016 | MIL | |
6312 | 6312 | Neil Ramirez | 26 | ramirne01 | 2015 | CHC | NL | 0.296567223 | 0.14 | P | 1 | 1 | CHC | 2014 | 2016 | MIL | |
6318 | 6318 | Quintin Berry | 30 | berryqu01 | 2015 | CHC | NL | 0.009960501 | -0.01 | CF, LF, RF | 0 | 1 | CHC | BAL | 2015 | 2015 | MIL |
6348 | 6348 | Tyler Saladino | 25 | saladty01 | 2015 | CHW | AL | 2.43624938 | 0.785 | 3B, SS, 1B | 6 | 1 | CHW | 2015 | 2018 | MIL | |
6363 | 6363 | Junior Guerra | 30 | guerrju02 | 2015 | CHW | AL | 0.073599878 | -0.025 | P | 0 | 1 | CHW | 2015 | 2015 | MIL | |
6462 | 6462 | Jesus Aguilar | 25 | aguilje01 | 2015 | CLE | AL | 0.190632703 | -0.115714286 | 1B | 0 | 1 | CLE | 2014 | 2016 | MIL | |
6535 | 6535 | Alex Wilson | 28 | wilsoal01 | 2015 | DET | AL | 2.131233861 | 1.277888199 | P | 7 | 1 | DET | BOS | 2015 | 2018 | MIL |
6568 | 6568 | Hernan Perez | 24 | perezhe01 | 2015 | DET | AL | 0.32159165 | -0.669130435 | 3B, 2B, 1B, SS | 0 | 1 | DET | 2012 | 2015 | MIL |
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 );