mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
701 rows where prev_franch = "FLA"
This data as json, copyable, CSV (advanced)
Suggested facets: age, year_ID, lg_ID, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17 | 17 | Zac Gallen | 23 | galleza01 | 2019 | ARI | NL | 1.209048353 | 1.003584906 | P | 5 | 2 | ARI | FLA | 2019 | 2019 | |
80 | 80 | Rafael Ortega | 28 | ortegra01 | 2019 | ATL | NL | 0.872777018 | -0.315849057 | LF, RF, CF | 1 | 1 | ATL | FLA | 2019 | 2019 | |
151 | 151 | Dan Straily | 30 | straida01 | 2019 | BAL | AL | 1.248253202 | -1.21245283 | P | 0 | 1 | BAL | FLA | 2019 | 2019 | |
302 | 302 | Anthony DeSclafani | 29 | desclan01 | 2019 | CIN | NL | 4.579019304 | 2.496226415 | P | 14 | 1 | CIN | FLA | 2015 | 2019 | |
311 | 311 | Derek Dietrich | 29 | dietrde01 | 2019 | CIN | NL | 3.158007117 | 1.049433962 | 2B, 1B, LF, 3B | 7 | 1 | CIN | FLA | 2019 | 2019 | |
332 | 332 | Christian Colon | 30 | colonch01 | 2019 | CIN | NL | 0.061921708 | 0.106981132 | 2B | 0 | 1 | CIN | FLA | 2019 | 2019 | |
363 | 363 | Nick Wittgren | 28 | wittgni01 | 2019 | CLE | AL | 2.032736456 | 0.697924528 | P | 5 | 1 | CLE | FLA | 2019 | 2019 | |
430 | 430 | Mike Dunn | 34 | dunnmi01 | 2019 | COL | NL | 0.573870355 | -0.106981132 | P | 1 | 1 | COL | FLA | 2017 | 2019 | |
461 | 461 | Miguel Cabrera | 36 | cabremi01 | 2019 | DET | AL | 5.32623034 | -0.302468354 | 1B | 5 | 1 | DET | FLA | 2008 | 2019 | |
520 | 520 | Jake Marisnick | 28 | marisja01 | 2019 | HOU | AL | 2.893045564 | 1.258301887 | CF | 7 | 1 | HOU | FLA | 2014 | 2019 | |
578 | 578 | Brian Flynn | 29 | flynnbr01 | 2019 | KCR | AL | 0.972308751 | -0.061132075 | P | 1 | 1 | KCR | FLA | 2016 | 2019 | |
611 | 611 | Andrew Heaney | 28 | heanean01 | 2019 | LAA | AL | 2.766828273 | 1.105471698 | P | 7 | 1 | ANA | FLA | 2015 | 2019 | |
621 | 621 | Dillon Peters | 26 | peterdi01 | 2019 | LAA | AL | 1.865004287 | 0.13245283 | P | 3 | 1 | ANA | FLA | 2019 | 2019 | |
667 | 667 | Enrique Hernandez | 27 | hernaen02 | 2019 | LAD | NL | 4.497673617 | 1.436603774 | 2B, CF, RF, LF, SS, 1B | 11 | 1 | LAD | FLA | 2015 | 2019 | |
752 | 752 | Christian Yelich | 27 | yelicch01 | 2019 | MIL | NL | 5.719143149 | 7.621132075 | RF, LF, CF | 32 | 1 | MIL | FLA | 2018 | 2019 | |
829 | 829 | Sergio Romo | 36 | romose01 | 2019 | MIN | AL | 0.786992532 | 0.331132075 | P | 2 | 2 | MIN | FLA | 2019 | 2019 | |
934 | 934 | Giancarlo Stanton | 29 | stantmi03 | 2019 | NYY | AL | 0.569837891 | 0.244528302 | LF, RF | 2 | 1 | NYY | FLA | 2018 | 2019 | |
1007 | 1007 | J.T. Realmuto | 28 | realmjt01 | 2019 | PHI | NL | 5.914703353 | 5.175849057 | C, 1B | 25 | 1 | PHI | FLA | 2019 | 2019 | |
1089 | 1089 | JB Shuck | 32 | shuckja01 | 2019 | PIT | NL | 0.569214876 | 0.00509434 | RF, LF, CF, P | 1 | 1 | PIT | FLA | 2019 | 2019 | |
1185 | 1185 | Dee Gordon | 31 | gordode01 | 2019 | SEA | AL | 4.006264425 | 0.27 | 2B, SS | 6 | 1 | SEA | FLA | 2018 | 2019 | |
1216 | 1216 | Ichiro Suzuki | 45 | suzukic01 | 2019 | SEA | AL | 0.057368942 | -0.045849057 | RF | 0 | 1 | SEA | FLA | 2018 | 2019 | |
1308 | 1308 | Marcell Ozuna | 28 | ozunama01 | 2019 | STL | NL | 5.400523104 | 2.302641509 | LF | 15 | 1 | STL | FLA | 2018 | 2019 | |
1365 | 1365 | Nick Anderson | 28 | anderni01 | 2019 | TBR | AL | 0.857363525 | 0.94754717 | P | 4 | 2 | TBD | FLA | 2019 | 2019 | |
1371 | 1371 | Trevor Richards | 26 | richatr01 | 2019 | TBR | AL | 0.686560635 | 0.54509434 | P | 3 | 2 | TBD | FLA | 2019 | 2019 | |
1441 | 1441 | Edinson Volquez | 35 | volqued01 | 2019 | TEX | AL | 0.387471205 | -0.112075472 | P | 0 | 1 | TEX | FLA | 2019 | 2019 | |
1487 | 1487 | Javy Guerra | 33 | guerrja01 | 2019 | TOR | AL | 0.412695766 | 0.193584906 | P | 1 | 1 | TOR | FLA | 2019 | 2019 | WSN |
1561 | 1561 | Kyle Barraclough | 29 | barraky01 | 2019 | WSN | NL | 0.960944092 | -0.641886792 | P | 0 | 1 | WSN | FLA | 2019 | 2019 | SFG |
1582 | 1582 | Jeff Mathis | 35 | mathije01 | 2018 | ARI | NL | 2.170643777 | 0.39 | C, 2B, P | 4 | 1 | ARI | FLA | 2017 | 2018 | TEX |
1595 | 1595 | Brad Ziegler | 38 | zieglbr01 | 2018 | ARI | NL | 0.812988593 | 0.105 | P | 1 | 2 | ARI | FLA | 2018 | 2018 | |
1887 | 1887 | Anthony DeSclafani | 28 | desclan01 | 2018 | CIN | NL | 3.258536235 | 0.635 | P | 6 | 1 | CIN | FLA | 2015 | 2019 | |
1923 | 1923 | Austin Brice | 26 | briceau01 | 2018 | CIN | NL | 0.973441229 | -0.485 | P | 0 | 1 | CIN | FLA | 2017 | 2018 | FLA |
2011 | 2011 | Mike Dunn | 33 | dunnmi01 | 2018 | COL | NL | 0.414983532 | -0.362760736 | P | 0 | 1 | COL | FLA | 2017 | 2019 | |
2030 | 2030 | Miguel Cabrera | 35 | cabremi01 | 2018 | DET | AL | 1.515141431 | 0.63 | 1B | 4 | 1 | DET | FLA | 2008 | 2019 | |
2056 | 2056 | Jacob Turner | 27 | turneja01 | 2018 | DET | AL | 0.028687225 | -0.23 | P | 0 | 2 | DET | FLA | 2018 | 2018 | |
2080 | 2080 | Jake Marisnick | 27 | marisja01 | 2018 | HOU | AL | 2.226760333 | 1.37 | CF, LF, RF | 7 | 1 | HOU | FLA | 2014 | 2019 | |
2125 | 2125 | Brian Flynn | 28 | flynnbr01 | 2018 | KCR | AL | 1.957800127 | 0.255 | P | 3 | 1 | KCR | FLA | 2016 | 2019 | |
2159 | 2159 | Andrew Heaney | 27 | heanean01 | 2018 | LAA | AL | 5.352514734 | 2.1 | P | 13 | 1 | ANA | FLA | 2015 | 2019 | |
2193 | 2193 | Junichi Tazawa | 32 | tazawju01 | 2018 | LAA | AL | 0.180947898 | 0.05 | P | 0 | 2 | ANA | FLA | 2018 | 2018 | |
2208 | 2208 | Odrisamer Despaigne | 31 | despaod01 | 2018 | LAA | AL | 0.501930066 | -0.38 | P | 0 | 2 | ANA | FLA | 2018 | 2018 | CHW |
2222 | 2222 | Enrique Hernandez | 26 | hernaen02 | 2018 | LAD | NL | 4.44746888 | 2.892147239 | CF, 2B, SS, RF, LF, 3B, 1B, P | 14 | 1 | LAD | FLA | 2015 | 2019 | |
2318 | 2318 | Christian Yelich | 26 | yelicch01 | 2018 | MIL | NL | 6.383431953 | 7.563312883 | LF, RF, CF | 33 | 1 | MIL | FLA | 2018 | 2019 | |
2470 | 2470 | AJ Ramos | 31 | ramosaj01 | 2018 | NYM | NL | 0.681948097 | -0.33 | P | 0 | 1 | NYM | FLA | 2017 | 2018 | |
2484 | 2484 | Giancarlo Stanton | 28 | stantmi03 | 2018 | NYY | AL | 6.543446952 | 4.155 | RF, LF | 21 | 1 | NYY | FLA | 2018 | 2019 | |
2617 | 2617 | Justin Bour | 30 | bourju01 | 2018 | PHI | NL | 0.536668951 | -0.085 | 1B | 1 | 2 | PHI | FLA | 2018 | 2018 | ANA |
2700 | 2700 | Brad Hand | 28 | handbr01 | 2018 | SDP | NL | 1.889043144 | 0.285 | P | 4 | 1 | SDP | FLA | 2016 | 2018 | CLE |
2704 | 2704 | A.J. Ellis | 37 | ellisaj01 | 2018 | SDP | NL | 1.840790843 | 0.09 | C, LF | 3 | 1 | SDP | FLA | 2018 | 2018 | |
2739 | 2739 | Dee Gordon | 30 | gordode01 | 2018 | SEA | AL | 5.623083265 | 0.315 | 2B, CF, SS | 10 | 1 | SEA | FLA | 2018 | 2019 | |
2766 | 2766 | Cameron Maybin | 31 | maybica01 | 2018 | SEA | AL | 0.927617477 | -0.185 | LF, CF, RF | 1 | 2 | SEA | FLA | 2018 | 2018 | NYY |
2778 | 2778 | Ichiro Suzuki | 44 | suzukic01 | 2018 | SEA | AL | 0.449464138 | -0.47 | LF, RF | 0 | 1 | SEA | FLA | 2018 | 2019 | |
2832 | 2832 | Marcell Ozuna | 27 | ozunama01 | 2018 | STL | NL | 6.201941086 | 2.85 | LF | 18 | 1 | STL | FLA | 2018 | 2019 | |
2896 | 2896 | Adeiny Hechavarria | 29 | hechaad01 | 2018 | TBR | AL | 2.226794103 | 0.73 | SS, 3B | 5 | 1 | TBD | FLA | 2017 | 2018 | PIT |
3113 | 3113 | Fernando Rodney | 40 | rodnefe01 | 2017 | ARI | NL | 2.392462074 | 0.77 | P | 6 | 1 | ARI | FLA | 2017 | 2017 | MIN |
3122 | 3122 | Jeff Mathis | 34 | mathije01 | 2017 | ARI | NL | 2.004426285 | -0.06 | C | 3 | 1 | ARI | FLA | 2017 | 2018 | TEX |
3359 | 3359 | Dan Jennings | 30 | jennida01 | 2017 | CHW | AL | 1.410302297 | 0.285 | P | 3 | 1 | CHW | FLA | 2015 | 2017 | TBD |
3369 | 3369 | Rob Brantly | 27 | brantro01 | 2017 | CHW | AL | 0.345752608 | 0.245 | C, P | 1 | 1 | CHW | FLA | 2015 | 2017 | PHI |
3419 | 3419 | Austin Brice | 25 | briceau01 | 2017 | CIN | NL | 0.879817562 | -0.09 | P | 1 | 1 | CIN | FLA | 2017 | 2018 | FLA |
3498 | 3498 | Mike Dunn | 32 | dunnmi01 | 2017 | COL | NL | 1.588785024 | 0.445 | P | 4 | 1 | COL | FLA | 2017 | 2019 | |
3533 | 3533 | Miguel Cabrera | 34 | cabremi01 | 2017 | DET | AL | 5.006853786 | -0.425 | 1B | 5 | 1 | DET | FLA | 2008 | 2019 | |
3539 | 3539 | Anibal Sanchez | 33 | sanchan01 | 2017 | DET | AL | 2.754277399 | -0.165 | P | 3 | 1 | DET | FLA | 2012 | 2017 | ATL |
3581 | 3581 | Jake Marisnick | 26 | marisja01 | 2017 | HOU | AL | 2.406600449 | 1.63 | CF, LF, RF | 8 | 1 | HOU | FLA | 2014 | 2019 | |
3645 | 3645 | Brian Flynn | 27 | flynnbr01 | 2017 | KCR | AL | 0.036931522 | 0.015 | P | 0 | 1 | KCR | FLA | 2016 | 2019 | |
3714 | 3714 | Andrew Heaney | 26 | heanean01 | 2017 | LAA | AL | 0.603176629 | -0.52 | P | 0 | 1 | ANA | FLA | 2015 | 2019 | |
3729 | 3729 | Enrique Hernandez | 25 | hernaen02 | 2017 | LAD | NL | 3.382673943 | 1.415 | CF, LF, SS, RF, 3B, 2B, 1B | 9 | 1 | LAD | FLA | 2015 | 2019 | |
3745 | 3745 | Chris Hatcher | 32 | hatchch02 | 2017 | LAD | NL | 0.83849352 | -0.005 | P | 1 | 1 | LAD | FLA | 2015 | 2017 | OAK |
3892 | 3892 | Craig Breslow | 36 | breslcr01 | 2017 | MIN | AL | 0.700893588 | -0.095 | P | 1 | 1 | MIN | FLA | 2017 | 2017 | CLE |
3946 | 3946 | AJ Ramos | 30 | ramosaj01 | 2017 | NYM | NL | 0.690160504 | 0.09 | P | 1 | 2 | NYM | FLA | 2017 | 2018 | |
4109 | 4109 | Henderson Alvarez III | 27 | alvarhe01 | 2017 | PHI | NL | 0.419687606 | -0.005 | P | 0 | 1 | PHI | FLA | 2017 | 2017 | |
4173 | 4173 | Brad Hand | 27 | handbr01 | 2017 | SDP | NL | 3.183267339 | 2.345 | P | 12 | 1 | SDP | FLA | 2016 | 2018 | CLE |
4198 | 4198 | Jarred Cosart | 27 | cosarja01 | 2017 | SDP | NL | 0.657750753 | 0.06 | P | 1 | 1 | SDP | FLA | 2016 | 2017 | |
4205 | 4205 | Jake Esch | 27 | eschja01 | 2017 | SDP | NL | 0.0 | 0.0 | P | 0 | 1 | SDP | FLA | 2017 | 2017 | |
4207 | 4207 | Carter Capps | 26 | cappsca01 | 2017 | SDP | NL | 0.248372579 | -0.06 | P | 0 | 1 | SDP | FLA | 2017 | 2017 | |
4253 | 4253 | David Phelps | 30 | phelpda01 | 2017 | SEA | AL | 0.369329198 | 0.21 | P | 1 | 2 | SEA | FLA | 2017 | 2017 | TOR |
4316 | 4316 | Bryan Morris | 30 | morribr01 | 2017 | SFG | NL | 0.510214994 | -0.075 | P | 0 | 1 | SFG | FLA | 2017 | 2017 | |
4389 | 4389 | Adeiny Hechavarria | 28 | hechaad01 | 2017 | TBR | AL | 2.662201895 | 1.325 | SS | 7 | 2 | TBD | FLA | 2017 | 2018 | PIT |
4433 | 4433 | Andrew Cashner | 30 | cashnan01 | 2017 | TEX | AL | 4.804059357 | 3.42 | P | 17 | 1 | TEX | FLA | 2017 | 2017 | BAL |
4482 | 4482 | Sam Dyson | 29 | dysonsa01 | 2017 | TEX | AL | 0.618394875 | -1.195 | P | 0 | 1 | TEX | FLA | 2015 | 2017 | SFG |
4508 | 4508 | Tom Koehler | 31 | koehlto01 | 2017 | TOR | AL | 0.452478639 | 0.39 | P | 2 | 2 | TOR | FLA | 2017 | 2017 | |
4689 | 4689 | Reid Brignac | 30 | brignre01 | 2016 | ATL | NL | 0.286151752 | -0.100621118 | 3B, 2B | 0 | 1 | ATL | FLA | 2016 | 2016 | |
4858 | 4858 | Dan Jennings | 29 | jennida01 | 2016 | CHW | AL | 1.868098841 | 1.275 | P | 6 | 1 | CHW | FLA | 2015 | 2017 | TBD |
4900 | 4900 | Anthony DeSclafani | 26 | desclan01 | 2016 | CIN | NL | 3.497973545 | 2.415 | P | 13 | 1 | CIN | FLA | 2015 | 2019 | |
5043 | 5043 | Miguel Cabrera | 33 | cabremi01 | 2016 | DET | AL | 6.451834862 | 4.799627329 | 1B, 3B | 23 | 1 | DET | FLA | 2008 | 2019 | |
5058 | 5058 | Anibal Sanchez | 32 | sanchan01 | 2016 | DET | AL | 4.472887447 | -0.070434783 | P | 6 | 1 | DET | FLA | 2012 | 2017 | ATL |
5082 | 5082 | Casey McGehee | 33 | mcgehca01 | 2016 | DET | AL | 0.912188729 | -0.367267081 | 3B, 1B | 0 | 1 | DET | FLA | 2016 | 2016 | |
5101 | 5101 | Jake Marisnick | 25 | marisja01 | 2016 | HOU | AL | 2.91829801 | 1.115 | CF, LF, RF | 7 | 1 | HOU | FLA | 2014 | 2019 | |
5145 | 5145 | Brian Flynn | 26 | flynnbr01 | 2016 | KCR | AL | 1.616604339 | 0.695 | P | 5 | 1 | KCR | FLA | 2016 | 2019 | |
5201 | 5201 | Cody Ege | 25 | egeco01 | 2016 | LAA | AL | 0.235945151 | 0.215 | P | 1 | 2 | ANA | FLA | 2016 | 2016 | |
5208 | 5208 | Andrew Heaney | 25 | heanean01 | 2016 | LAA | AL | 0.174547556 | -0.015 | P | 0 | 1 | ANA | FLA | 2015 | 2019 | |
5246 | 5246 | Enrique Hernandez | 24 | hernaen02 | 2016 | LAD | NL | 2.420800547 | 0.005 | LF, CF, 2B, RF, 3B, SS | 3 | 1 | LAD | FLA | 2015 | 2019 | |
5274 | 5274 | Chris Hatcher | 31 | hatchch02 | 2016 | LAD | NL | 1.244798128 | -0.49 | P | 0 | 1 | LAD | FLA | 2015 | 2017 | OAK |
5489 | 5489 | Nathan Eovaldi | 26 | eovalna01 | 2016 | NYY | AL | 3.428746053 | 0.99 | P | 8 | 1 | NYY | FLA | 2015 | 2016 | TBD |
5514 | 5514 | Donovan Solano | 28 | solando01 | 2016 | NYY | AL | 0.2208975 | 0.01 | 2B, 3B | 0 | 1 | NYY | FLA | 2016 | 2016 | SFG |
5655 | 5655 | Arquimedes Caminero | 29 | caminar01 | 2016 | PIT | NL | 1.130134861 | 0.19 | P | 2 | 1 | PIT | FLA | 2015 | 2016 | SEA |
5661 | 5661 | Zach Phillips | 29 | phillza01 | 2016 | PIT | NL | 0.190752703 | 0.09 | P | 1 | 1 | PIT | FLA | 2016 | 2016 | |
5678 | 5678 | Mike Morse | 34 | morsemi01 | 2016 | PIT | NL | 0.078114478 | -0.21 | 1B | 0 | 1 | PIT | FLA | 2015 | 2016 | SFG |
5691 | 5691 | Brad Hand | 26 | handbr01 | 2016 | SDP | NL | 3.214542896 | 1.525 | P | 9 | 1 | SDP | FLA | 2016 | 2018 | CLE |
5707 | 5707 | Paul Clemens | 28 | clemepa02 | 2016 | SDP | NL | 1.98350597 | 0.125 | P | 3 | 2 | SDP | FLA | 2016 | 2016 | |
5708 | 5708 | Edwin Jackson | 32 | jacksed01 | 2016 | SDP | NL | 2.082094192 | 0.1 | P | 3 | 2 | SDP | FLA | 2016 | 2016 | BAL |
5722 | 5722 | Jarred Cosart | 26 | cosarja01 | 2016 | SDP | NL | 1.059975225 | -0.285 | P | 1 | 2 | SDP | FLA | 2016 | 2017 | |
5738 | 5738 | Oswaldo Arcia | 25 | arciaos01 | 2016 | SDP | NL | 0.458618872 | -0.565 | LF, RF | 0 | 4 | SDP | FLA | 2016 | 2016 | |
5839 | 5839 | Vin Mazzaro | 29 | mazzavi01 | 2016 | SFG | NL | 0.02136612 | -0.28 | P | 0 | 1 | SFG | FLA | 2016 | 2016 |
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 );