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,944 rows where prev_franch = "DET"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8 | 8 | Robbie Ray | 27 | rayro02 | 2019 | ARI | NL | 4.686028957 | 1.594528302 | P | 11 | 1 | ARI | DET | 2015 | 2019 | |
72 | 72 | Shane Greene | 30 | greensh02 | 2019 | ATL | NL | 0.792363891 | 0.341320755 | P | 2 | 2 | ATL | DET | 2019 | 2019 | |
164 | 164 | Rick Porcello | 30 | porceri01 | 2019 | BOS | AL | 4.863157895 | 1.380566038 | P | 10 | 1 | BOS | DET | 2015 | 2019 | |
212 | 212 | Nicholas Castellanos | 27 | casteni01 | 2019 | CHC | NL | 2.275104603 | 1.686226415 | RF, LF | 8 | 2 | CHC | DET | 2019 | 2019 | |
214 | 214 | Kyle Ryan | 27 | ryanky01 | 2019 | CHC | NL | 2.01628451 | 1.222641509 | P | 6 | 1 | CHC | DET | 2019 | 2019 | |
241 | 241 | Jim Adduci | 34 | adducji02 | 2019 | CHC | NL | 0.05055788 | -0.122264151 | RF | 0 | 1 | CHC | DET | 2019 | 2019 | |
255 | 255 | James McCann | 29 | mccanja02 | 2019 | CHW | AL | 4.62745098 | 3.034936709 | C | 16 | 1 | CHW | DET | 2019 | 2019 | |
300 | 300 | Eugenio Suarez | 27 | suareeu01 | 2019 | CIN | NL | 6.677224199 | 4.508490566 | 3B | 22 | 1 | CIN | DET | 2015 | 2019 | |
304 | 304 | Jose Iglesias | 29 | iglesjo01 | 2019 | CIN | NL | 5.356227758 | 1.334716981 | SS | 11 | 1 | CIN | DET | 2019 | 2019 | |
373 | 373 | Leonys Martin | 31 | martile01 | 2019 | CLE | AL | 2.551149617 | -0.422830189 | CF | 3 | 1 | CLE | DET | 2018 | 2019 | |
504 | 504 | Justin Verlander | 36 | verlaju01 | 2019 | HOU | AL | 6.257692454 | 7.101509434 | P | 28 | 1 | HOU | DET | 2017 | 2019 | |
626 | 626 | Justin Upton | 31 | uptonju01 | 2019 | LAA | AL | 2.422581171 | -0.550188679 | LF | 2 | 1 | ANA | DET | 2017 | 2019 | |
726 | 726 | Bryan Holaday | 31 | holadbr01 | 2019 | MIA | NL | 1.287744227 | 0.091698113 | C, P | 2 | 1 | FLA | DET | 2018 | 2019 | |
777 | 777 | Hernan Perez | 28 | perezhe01 | 2019 | MIL | NL | 2.386263176 | -0.249622642 | 2B, SS, 3B, RF, 1B, LF, P | 3 | 1 | MIL | DET | 2015 | 2019 | |
800 | 800 | Alex Wilson | 32 | wilsoal01 | 2019 | MIL | NL | 0.332784906 | -0.443207547 | P | 0 | 1 | MIL | DET | 2019 | 2019 | |
949 | 949 | Joe Mantiply | 28 | mantijo01 | 2019 | NYY | AL | 0.071178278 | -0.096792453 | P | 0 | 1 | NYY | DET | 2019 | 2019 | |
964 | 964 | Mike Fiers | 34 | fiersmi01 | 2019 | OAK | AL | 4.956039029 | 2.210943396 | P | 14 | 1 | OAK | DET | 2018 | 2019 | |
1075 | 1075 | Francisco Liriano | 35 | liriafr01 | 2019 | PIT | NL | 2.324865759 | 0.799811321 | P | 6 | 1 | PIT | DET | 2019 | 2019 | |
1218 | 1218 | David McKay | 24 | mckayda02 | 2019 | SEA | AL | 0.115480201 | -0.061132075 | P | 0 | 2 | SEA | DET | 2019 | 2019 | |
1300 | 1300 | Mike Gerber | 26 | gerbemi01 | 2019 | SFG | NL | 0.251343387 | -0.499245283 | LF, RF | 0 | 1 | SFG | DET | 2019 | 2019 | |
1517 | 1517 | Max Scherzer | 34 | scherma01 | 2019 | WSN | NL | 4.99171193 | 6.306792453 | P | 25 | 1 | WSN | DET | 2015 | 2019 | |
1575 | 1575 | Robbie Ray | 26 | rayro02 | 2018 | ARI | NL | 3.368240474 | 0.865 | P | 7 | 1 | ARI | DET | 2015 | 2019 | |
1622 | 1622 | Anibal Sanchez | 34 | sanchan01 | 2018 | ATL | NL | 3.737772777 | 2.32 | P | 12 | 1 | ATL | DET | 2018 | 2018 | WSN |
1734 | 1734 | Rick Porcello | 29 | porceri01 | 2018 | BOS | AL | 5.275995848 | 2.925 | P | 17 | 1 | BOS | DET | 2015 | 2019 | |
1769 | 1769 | William Cuevas | 27 | cuevawi01 | 2018 | BOS | AL | 0.421143793 | -0.24 | P | 0 | 1 | BOS | DET | 2018 | 2018 | |
1793 | 1793 | Justin Wilson | 30 | wilsoju10 | 2018 | CHC | NL | 1.836299812 | 0.660920245 | P | 5 | 1 | CHC | DET | 2017 | 2018 | NYM |
1815 | 1815 | Efren Navarro | 32 | navaref01 | 2018 | CHC | NL | 0.057615894 | -0.094417178 | 1B | 0 | 1 | CHC | DET | 2018 | 2018 | |
1838 | 1838 | Avisail Garcia | 27 | garciav01 | 2018 | CHW | AL | 3.690909091 | 0.205 | RF | 5 | 1 | CHW | DET | 2013 | 2018 | TBD |
1867 | 1867 | Bruce Rondon | 27 | rondobr01 | 2018 | CHW | AL | 0.905432495 | -0.485 | P | 0 | 1 | CHW | DET | 2018 | 2018 | |
1874 | 1874 | Eugenio Suarez | 26 | suareeu01 | 2018 | CIN | NL | 5.9643645 | 4.055 | 3B, SS | 20 | 1 | CIN | DET | 2015 | 2019 | |
1954 | 1954 | Leonys Martin | 30 | martile01 | 2018 | CLE | AL | 0.157156519 | 0.22 | CF, RF | 1 | 2 | CLE | DET | 2018 | 2019 | |
2066 | 2066 | Justin Verlander | 35 | verlaju01 | 2018 | HOU | AL | 5.85326068 | 6.41 | P | 27 | 1 | HOU | DET | 2017 | 2019 | |
2157 | 2157 | Justin Upton | 30 | uptonju01 | 2018 | LAA | AL | 5.841932304 | 3.45 | LF | 18 | 1 | ANA | DET | 2017 | 2019 | |
2160 | 2160 | Ian Kinsler | 36 | kinslia01 | 2018 | LAA | AL | 3.726256983 | 2.365 | 2B | 12 | 1 | ANA | DET | 2018 | 2018 | BOS |
2165 | 2165 | Jose Alvarez | 29 | alvarjo02 | 2018 | LAA | AL | 2.391549137 | 1.305 | P | 7 | 1 | ANA | DET | 2014 | 2018 | PHI |
2185 | 2185 | Jefry Marte | 27 | marteje01 | 2018 | LAA | AL | 1.991784423 | -0.275 | 1B, 3B, LF | 2 | 1 | ANA | DET | 2016 | 2018 | |
2289 | 2289 | Bryan Holaday | 30 | holadbr01 | 2018 | MIA | NL | 1.66 | -0.030186335 | C, P | 2 | 1 | FLA | DET | 2018 | 2019 | |
2333 | 2333 | Hernan Perez | 27 | perezhe01 | 2018 | MIL | NL | 3.275063398 | 0.64601227 | 2B, RF, 3B, SS, LF, 1B, CF, P | 7 | 1 | MIL | DET | 2015 | 2019 | |
2336 | 2336 | Corey Knebel | 26 | knebeco01 | 2018 | MIL | NL | 2.010509965 | 0.641042945 | P | 5 | 1 | MIL | DET | 2015 | 2018 | |
2440 | 2440 | Yoenis Cespedes | 32 | cespeyo01 | 2018 | NYM | NL | 1.558179329 | 0.91 | LF | 5 | 1 | NYM | DET | 2015 | 2018 | |
2479 | 2479 | Matt den Dekker | 30 | dendema01 | 2018 | NYM | NL | 0.208418891 | -0.615 | CF | 0 | 1 | NYM | DET | 2018 | 2018 | |
2551 | 2551 | Mike Fiers | 33 | fiersmi01 | 2018 | OAK | AL | 1.460278246 | 0.48 | P | 4 | 2 | OAK | DET | 2018 | 2019 | |
2754 | 2754 | Andrew Romine | 32 | rominan01 | 2018 | SEA | AL | 1.252761748 | -0.135 | 2B, SS, 1B, 3B, LF, P, CF, RF | 2 | 1 | SEA | DET | 2018 | 2018 | |
3045 | 3045 | Max Scherzer | 33 | scherma01 | 2018 | WSN | NL | 6.203642561 | 8.85 | P | 34 | 1 | WSN | DET | 2015 | 2019 | |
3100 | 3100 | Robbie Ray | 25 | rayro02 | 2017 | ARI | NL | 4.523698998 | 4.47 | P | 20 | 1 | ARI | DET | 2015 | 2019 | |
3108 | 3108 | J.D. Martinez | 29 | martijd02 | 2017 | ARI | NL | 2.537623425 | 2.41 | RF | 11 | 2 | ARI | DET | 2017 | 2017 | BOS |
3176 | 3176 | Ian Krol | 26 | krolia01 | 2017 | ATL | NL | 1.324048339 | -0.4 | P | 1 | 1 | ATL | DET | 2016 | 2017 | ANA |
3252 | 3252 | Rick Porcello | 28 | porceri01 | 2017 | BOS | AL | 5.434628238 | 0.855 | P | 11 | 1 | BOS | DET | 2015 | 2019 | |
3314 | 3314 | Alex Avila | 30 | avilaal01 | 2017 | CHC | NL | 1.094892972 | 0.54 | C, 1B | 3 | 2 | CHC | DET | 2017 | 2017 | ARI |
3319 | 3319 | Justin Wilson | 29 | wilsoju10 | 2017 | CHC | NL | 0.497812677 | 0.035 | P | 1 | 2 | CHC | DET | 2017 | 2018 | NYM |
3339 | 3339 | Avisail Garcia | 26 | garciav01 | 2017 | CHW | AL | 5.387978142 | 4.405 | RF | 20 | 1 | CHW | DET | 2013 | 2018 | TBD |
3379 | 3379 | Mike Pelfrey | 33 | pelfrmi01 | 2017 | CHW | AL | 3.237270641 | -1.05 | P | 1 | 1 | CHW | DET | 2017 | 2017 | |
3391 | 3391 | Eugenio Suarez | 25 | suareeu01 | 2017 | CIN | NL | 6.228717077 | 3.785 | 3B, SS | 19 | 1 | CIN | DET | 2015 | 2019 | |
3583 | 3583 | Justin Verlander | 34 | verlaju01 | 2017 | HOU | AL | 0.962857758 | 1.435 | P | 6 | 2 | HOU | DET | 2017 | 2019 | |
3668 | 3668 | Cameron Maybin | 30 | maybica01 | 2017 | LAA | AL | 3.708856576 | 1.495 | LF, CF, RF | 10 | 1 | ANA | DET | 2017 | 2017 | HOU |
3683 | 3683 | Justin Upton | 29 | uptonju01 | 2017 | LAA | AL | 1.102115003 | 0.685 | LF | 4 | 2 | ANA | DET | 2017 | 2019 | |
3688 | 3688 | Jose Alvarez | 28 | alvarjo02 | 2017 | LAA | AL | 1.579424577 | 0.33 | P | 3 | 1 | ANA | DET | 2014 | 2018 | PHI |
3706 | 3706 | Jose Valdez | 27 | valdejo03 | 2017 | LAA | AL | 0.021735201 | -0.095 | P | 0 | 1 | ANA | DET | 2016 | 2017 | SDP |
3715 | 3715 | Jefry Marte | 26 | marteje01 | 2017 | LAA | AL | 1.389623265 | -0.655 | 1B, 3B, LF | 0 | 1 | ANA | DET | 2016 | 2018 | |
3801 | 3801 | Mike Aviles | 36 | avilemi01 | 2017 | MIA | NL | 0.948735245 | -0.145 | SS, 2B, 3B, 1B, RF | 1 | 1 | FLA | DET | 2017 | 2017 | |
3817 | 3817 | Corey Knebel | 25 | knebeco01 | 2017 | MIL | NL | 3.279803539 | 3.235 | P | 14 | 1 | MIL | DET | 2015 | 2018 | |
3823 | 3823 | Hernan Perez | 26 | perezhe01 | 2017 | MIL | NL | 4.56504554 | 0.79 | LF, 3B, RF, CF, 2B, SS, 1B, P | 9 | 1 | MIL | DET | 2015 | 2019 | |
3919 | 3919 | Yoenis Cespedes | 31 | cespeyo01 | 2017 | NYM | NL | 3.18528657 | 1.89 | LF | 10 | 1 | NYM | DET | 2015 | 2018 | |
4184 | 4184 | Erick Aybar | 33 | aybarer01 | 2017 | SDP | NL | 3.800247919 | -0.02 | SS, P | 6 | 1 | SDP | DET | 2017 | 2017 | |
4378 | 4378 | Jhonny Peralta | 35 | peraljh01 | 2017 | STL | NL | 0.571234505 | -0.385 | 3B | 0 | 1 | STL | DET | 2014 | 2017 | |
4500 | 4500 | Ezequiel Carrera | 30 | carreez01 | 2017 | TOR | AL | 3.075040783 | 0.21 | LF, RF, CF | 5 | 1 | TOR | DET | 2015 | 2017 | |
4541 | 4541 | Jarrod Saltalamacchia | 32 | saltaja01 | 2017 | TOR | AL | 0.246003263 | -0.6 | C | 0 | 1 | TOR | DET | 2017 | 2017 | DET |
4543 | 4543 | Max Scherzer | 32 | scherma01 | 2017 | WSN | NL | 5.594122992 | 7.05 | P | 29 | 1 | WSN | DET | 2015 | 2019 | |
4596 | 4596 | Robbie Ray | 24 | rayro02 | 2016 | ARI | NL | 4.773369528 | 2.28 | P | 13 | 1 | ARI | DET | 2015 | 2019 | |
4653 | 4653 | Ian Krol | 25 | krolia01 | 2016 | ATL | NL | 1.722909227 | 0.940807453 | P | 5 | 1 | ATL | DET | 2016 | 2017 | ANA |
4687 | 4687 | Matt Tuiasosopo | 30 | tuiasma01 | 2016 | ATL | NL | 0.029601905 | -0.090559006 | 0 | 1 | ATL | DET | 2016 | 2016 | ||
4752 | 4752 | Rick Porcello | 27 | porceri01 | 2016 | BOS | AL | 6.146769286 | 4.97 | P | 22 | 1 | BOS | DET | 2015 | 2019 | |
4834 | 4834 | Joe Nathan | 41 | nathajo01 | 2016 | CHC | NL | 0.037656546 | 0.04 | P | 0 | 1 | CHC | DET | 2016 | 2016 | SFG |
4857 | 4857 | Avisail Garcia | 25 | garciav01 | 2016 | CHW | AL | 4.300867572 | 0.565 | RF, LF | 7 | 1 | CHW | DET | 2013 | 2018 | TBD |
4860 | 4860 | Alex Avila | 29 | avilaal01 | 2016 | CHW | AL | 1.98428548 | 0.775 | C | 5 | 1 | CHW | DET | 2016 | 2016 | DET |
4899 | 4899 | Eugenio Suarez | 24 | suareeu01 | 2016 | CIN | NL | 6.305878273 | 1.485 | 3B, SS | 14 | 1 | CIN | DET | 2015 | 2019 | |
4945 | 4945 | Alfredo Simon | 35 | simonal01 | 2016 | CIN | NL | 1.646105198 | -1.51 | P | 0 | 1 | CIN | DET | 2016 | 2016 | |
4958 | 4958 | Rajai Davis | 35 | davisra01 | 2016 | CLE | AL | 4.683523654 | 1.157142857 | CF, LF, RF | 10 | 1 | CLE | DET | 2016 | 2016 | OAK |
4991 | 4991 | Tom Gorzelanny | 33 | gorzeto01 | 2016 | CLE | AL | 0.09103286 | -0.357204969 | P | 0 | 1 | CLE | DET | 2016 | 2016 | |
5019 | 5019 | Justin Miller | 29 | milleju02 | 2016 | COL | NL | 1.036850952 | 0.03 | P | 1 | 1 | COL | DET | 2015 | 2016 | WSN |
5119 | 5119 | Danny Worth | 30 | worthda01 | 2016 | HOU | AL | 0.375343796 | -0.185 | 2B, 3B, SS | 0 | 1 | HOU | DET | 2016 | 2016 | |
5156 | 5156 | Omar Infante | 34 | infanom01 | 2016 | KCR | AL | 1.432929862 | -0.18 | 2B | 2 | 1 | KCR | DET | 2014 | 2016 | |
5178 | 5178 | Jefry Marte | 25 | marteje01 | 2016 | LAA | AL | 2.736212625 | 1.25 | 1B, LF, 3B | 7 | 1 | ANA | DET | 2016 | 2018 | |
5187 | 5187 | Jose Alvarez | 27 | alvarjo02 | 2016 | LAA | AL | 1.819526035 | 0.405 | P | 4 | 1 | ANA | DET | 2014 | 2018 | PHI |
5205 | 5205 | Jose Valdez | 26 | valdejo03 | 2016 | LAA | AL | 0.77317411 | -0.11 | P | 1 | 1 | ANA | DET | 2016 | 2017 | SDP |
5210 | 5210 | Al Alburquerque | 30 | albural01 | 2016 | LAA | AL | 0.036402966 | -0.105 | P | 0 | 1 | ANA | DET | 2016 | 2016 | KCR |
5324 | 5324 | Don Kelly | 36 | kellydo01 | 2016 | MIA | NL | 0.299123259 | -0.206273292 | 1B | 0 | 1 | FLA | DET | 2015 | 2016 | |
5338 | 5338 | Hernan Perez | 25 | perezhe01 | 2016 | MIL | NL | 4.335883171 | 1.545 | 3B, RF, 2B, CF, 1B, SS, LF | 11 | 1 | MIL | DET | 2015 | 2019 | |
5358 | 5358 | Corey Knebel | 24 | knebeco01 | 2016 | MIL | NL | 1.146630511 | 0.095 | P | 2 | 1 | MIL | DET | 2015 | 2018 | |
5424 | 5424 | Casey Fien | 32 | fienca01 | 2016 | MIN | AL | 0.441283082 | -0.375 | P | 0 | 1 | MIN | DET | 2012 | 2016 | LAD |
5431 | 5431 | Yoenis Cespedes | 30 | cespeyo01 | 2016 | NYM | NL | 5.4375 | 3.42 | LF, CF | 18 | 1 | NYM | DET | 2015 | 2018 | |
5652 | 5652 | Neftali Feliz | 28 | felizne01 | 2016 | PIT | NL | 1.945577697 | 0.43 | P | 4 | 1 | PIT | DET | 2016 | 2016 | MIL |
5658 | 5658 | Kyle Lobstein | 26 | lobstky01 | 2016 | PIT | NL | 0.722812925 | 0.145 | P | 1 | 1 | PIT | DET | 2016 | 2016 | |
5861 | 5861 | Jhonny Peralta | 34 | peraljh01 | 2016 | STL | NL | 3.078514499 | -0.2 | 3B, SS | 4 | 1 | STL | DET | 2014 | 2017 | |
5892 | 5892 | Drew Smyly | 27 | smylydr01 | 2016 | TBR | AL | 4.932156646 | 0.915 | P | 8 | 1 | TBD | DET | 2014 | 2016 | TEX |
5957 | 5957 | Bryan Holaday | 28 | holadbr01 | 2016 | TEX | AL | 0.898631943 | 0.185 | C, 3B, LF, P | 2 | 1 | TEX | DET | 2016 | 2016 | BOS |
5958 | 5958 | Bobby Wilson | 33 | wilsobo02 | 2016 | TEX | AL | 1.347947915 | -0.085 | C | 2 | 2 | TEX | DET | 2016 | 2016 | TBD |
5959 | 5959 | Prince Fielder | 32 | fieldpr01 | 2016 | TEX | AL | 3.537168287 | -1.585 | 1B | 2 | 1 | TEX | DET | 2014 | 2016 | |
5998 | 5998 | Ezequiel Carrera | 29 | carreez01 | 2016 | TOR | AL | 2.9 | 0.655 | RF, LF, CF | 6 | 1 | TOR | DET | 2015 | 2017 | |
6031 | 6031 | Max Scherzer | 31 | scherma01 | 2016 | WSN | NL | 6.269128994 | 6.125 | P | 27 | 1 | WSN | DET | 2015 | 2019 |
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 );