mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
899 rows where next_franch = "FLA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
386 | 386 | Josh Smith | 29 | smithjo08 | 2019 | CLE | AL | 0.163053726 | 0.056037736 | P | 0 | 1 | CLE | 2019 | 2019 | FLA | |
616 | 616 | Cesar Puello | 28 | puellce01 | 2019 | LAA | AL | 0.473160385 | 0.830377358 | CF, LF, RF | 3 | 1 | ANA | TBD | 2019 | 2019 | FLA |
1362 | 1362 | Ryne Stanek | 27 | stanery01 | 2019 | TBR | AL | 1.51009849 | 1.008679245 | P | 5 | 1 | TBD | 2017 | 2019 | FLA | |
1609 | 1609 | Deven Marrero | 27 | marrede01 | 2018 | ARI | NL | 0.846351931 | -0.395 | 3B, 2B | 0 | 1 | ARI | BOS | 2018 | 2018 | FLA |
1923 | 1923 | Austin Brice | 26 | briceau01 | 2018 | CIN | NL | 0.973441229 | -0.485 | P | 0 | 1 | CIN | FLA | 2017 | 2018 | FLA |
2120 | 2120 | Rosell Herrera | 25 | herrero02 | 2018 | KCR | AL | 2.774706174 | 0.675 | RF, 2B, CF, 3B, LF | 5 | 2 | KCR | CIN | 2018 | 2018 | FLA |
2347 | 2347 | Curtis Granderson | 37 | grandcu01 | 2018 | MIL | NL | 0.529501268 | 0.33791411 | LF, RF, CF | 2 | 2 | MIL | TOR | 2018 | 2018 | FLA |
2415 | 2415 | Tyler Kinley | 27 | kinlety01 | 2018 | MIN | AL | 0.05017476 | -0.2 | P | 0 | 1 | MIN | 2018 | 2018 | FLA | |
2502 | 2502 | Neil Walker | 32 | walkene01 | 2018 | NYY | AL | 3.694031045 | -0.02 | 1B, 2B, 3B, RF, LF | 5 | 1 | NYY | MIL | 2018 | 2018 | FLA |
2590 | 2590 | Jorge Alfaro | 25 | alfarjo01 | 2018 | PHI | NL | 3.746744345 | 2.195 | C, 3B | 12 | 1 | PHI | 2016 | 2018 | FLA | |
2666 | 2666 | Christopher Bostick | 25 | bostich01 | 2018 | PIT | NL | 0.020170405 | -0.02515528 | 2B, LF | 0 | 1 | PIT | 2017 | 2018 | FLA | |
2893 | 2893 | Ryne Stanek | 26 | stanery01 | 2018 | TBR | AL | 1.890280005 | 1.3 | P | 6 | 1 | TBD | 2017 | 2019 | FLA | |
2897 | 2897 | Sergio Romo | 35 | romose01 | 2018 | TBR | AL | 2.443815085 | 0.45 | P, 3B | 5 | 1 | TBD | LAD | 2017 | 2018 | FLA |
3024 | 3024 | Jon Berti | 28 | bertijo01 | 2018 | TOR | AL | 0.143754131 | 0.045 | 2B | 0 | 1 | TOR | 2018 | 2018 | FLA | |
3419 | 3419 | Austin Brice | 25 | briceau01 | 2017 | CIN | NL | 0.879817562 | -0.09 | P | 1 | 1 | CIN | FLA | 2017 | 2018 | FLA |
3426 | 3426 | Chad Wallach | 25 | wallach01 | 2017 | CIN | NL | 0.108411215 | -0.2 | C, 1B | 0 | 1 | CIN | 2017 | 2017 | FLA | |
3561 | 3561 | Bryan Holaday | 29 | holadbr01 | 2017 | DET | AL | 0.274477807 | -0.3 | C, 2B | 0 | 1 | DET | BOS | 2017 | 2017 | FLA |
3598 | 3598 | Cameron Maybin | 30 | maybica01 | 2017 | HOU | AL | 0.585389298 | -0.06 | LF, CF, RF | 1 | 2 | HOU | ANA | 2017 | 2017 | FLA |
3649 | 3649 | Christian Colon | 28 | colonch01 | 2017 | KCR | AL | 0.183666667 | -0.095 | 3B, 2B | 0 | 1 | KCR | 2014 | 2017 | FLA | |
3849 | 3849 | Yadiel Rivera | 25 | riverya01 | 2017 | MIL | NL | 0.019934697 | -0.025 | 3B | 0 | 1 | MIL | 2015 | 2017 | FLA | |
3858 | 3858 | Lewis Brinson | 23 | brinsle01 | 2017 | MIL | NL | 0.548204159 | -0.275 | CF, LF | 0 | 1 | MIL | 2017 | 2017 | FLA | |
3902 | 3902 | Drew Rucinski | 28 | rucindr01 | 2017 | MIN | AL | 0.078905535 | -0.11 | P | 0 | 1 | MIN | ANA | 2017 | 2017 | FLA |
3975 | 3975 | Starlin Castro | 27 | castrst01 | 2017 | NYY | AL | 4.334650024 | 1.955 | 2B | 11 | 1 | NYY | CHC | 2016 | 2017 | FLA |
3993 | 3993 | Garrett Cooper | 26 | coopega03 | 2017 | NYY | AL | 0.412387423 | 0.15 | 1B | 1 | 1 | NYY | 2017 | 2017 | FLA | |
4009 | 4009 | Caleb Smith | 25 | smithca03 | 2017 | NYY | AL | 0.394347778 | -0.15 | P | 0 | 1 | NYY | 2017 | 2017 | FLA | |
4096 | 4096 | Jorge Alfaro | 24 | alfarjo01 | 2017 | PHI | NL | 1.134717693 | 0.515 | C, 1B | 3 | 1 | PHI | 2016 | 2018 | FLA | |
4148 | 4148 | Christopher Bostick | 24 | bostich01 | 2017 | PIT | NL | 0.319284363 | 0.185 | 2B, LF | 1 | 1 | PIT | 2017 | 2018 | FLA | |
4262 | 4262 | Tyler Cloyd | 30 | cloydty01 | 2017 | SEA | AL | 0.029001812 | 0.025 | P | 0 | 1 | SEA | PHI | 2017 | 2017 | FLA |
4360 | 4360 | Magneuris Sierra | 21 | sierrma01 | 2017 | STL | NL | 0.63032773 | 0.155 | RF, CF, LF | 1 | 1 | STL | 2017 | 2017 | FLA | |
4366 | 4366 | Sandy Alcantara | 21 | alcansa01 | 2017 | STL | NL | 0.142563667 | -0.09 | P | 0 | 1 | STL | 2017 | 2017 | FLA | |
4397 | 4397 | Sergio Romo | 34 | romose01 | 2017 | TBR | AL | 0.971432411 | 0.815 | P | 4 | 2 | TBD | LAD | 2017 | 2018 | FLA |
4428 | 4428 | Ryne Stanek | 25 | stanery01 | 2017 | TBR | AL | 0.566393171 | -0.33 | P | 0 | 1 | TBD | 2017 | 2019 | FLA | |
4577 | 4577 | Jacob Turner | 26 | turneja01 | 2017 | WSN | NL | 1.2442096 | -0.205 | P | 1 | 1 | WSN | CHW | 2017 | 2017 | FLA |
4640 | 4640 | Peter O'Brien | 25 | obriepe01 | 2016 | ARI | NL | 0.655754303 | -0.635 | LF, 1B | 0 | 1 | ARI | 2015 | 2016 | FLA | |
4656 | 4656 | Jeff Francoeur | 32 | francje02 | 2016 | ATL | NL | 2.723375298 | 0.437701863 | LF, RF, 3B | 5 | 1 | ATL | PHI | 2016 | 2016 | FLA |
4661 | 4661 | Hunter Cervenka | 26 | cervehu01 | 2016 | ATL | NL | 1.083401435 | 0.387391304 | P | 3 | 1 | ATL | 2016 | 2016 | FLA | |
4719 | 4719 | Vance Worley | 28 | worleva01 | 2016 | BAL | AL | 2.225925166 | 0.81 | P | 6 | 1 | BAL | PIT | 2016 | 2016 | FLA |
4734 | 4734 | Odrisamer Despaigne | 29 | despaod01 | 2016 | BAL | AL | 0.714709707 | -0.145 | P | 1 | 1 | BAL | SDP | 2016 | 2016 | FLA |
4765 | 4765 | Brad Ziegler | 36 | zieglbr01 | 2016 | BOS | AL | 1.193800735 | 0.87 | P | 4 | 2 | BOS | ARI | 2016 | 2016 | FLA |
4772 | 4772 | Junichi Tazawa | 30 | tazawju01 | 2016 | BOS | AL | 1.691131724 | 0.255 | P | 3 | 1 | BOS | 2009 | 2016 | FLA | |
4892 | 4892 | JB Shuck | 29 | shuckja01 | 2016 | CHW | AL | 2.288099525 | -1.61 | CF, LF, RF, P | 0 | 1 | CHW | CLE | 2015 | 2016 | FLA |
4897 | 4897 | Dan Straily | 27 | straida01 | 2016 | CIN | NL | 5.368547633 | 2.21 | P | 15 | 1 | CIN | HOU | 2016 | 2016 | FLA |
5084 | 5084 | Mike Aviles | 35 | avilemi01 | 2016 | DET | AL | 1.719855832 | -1.323167702 | RF, 2B, 3B, LF, SS, CF | 0 | 1 | DET | CLE | 2016 | 2016 | FLA |
5141 | 5141 | Edinson Volquez | 32 | volqued01 | 2016 | KCR | AL | 5.304579749 | 0.32 | P | 9 | 1 | KCR | PIT | 2015 | 2016 | FLA |
5152 | 5152 | Christian Colon | 27 | colonch01 | 2016 | KCR | AL | 1.54833361 | 0.32 | 2B, 3B, SS | 3 | 1 | KCR | 2014 | 2017 | FLA | |
5200 | 5200 | Rafael Ortega | 25 | ortegra01 | 2016 | LAA | AL | 1.946179402 | -0.365 | LF, CF, RF | 2 | 1 | ANA | COL | 2016 | 2016 | FLA |
5212 | 5212 | Javy Guerra | 30 | guerrja01 | 2016 | LAA | AL | 0.155671944 | -0.125 | P | 0 | 1 | ANA | CHW | 2016 | 2016 | FLA |
5374 | 5374 | Yadiel Rivera | 24 | riverya01 | 2016 | MIL | NL | 0.715924896 | -0.31 | 3B, 2B, SS | 0 | 1 | MIL | 2015 | 2017 | FLA | |
5483 | 5483 | Starlin Castro | 26 | castrst01 | 2016 | NYY | AL | 5.858585859 | 1.29 | 2B, SS | 13 | 1 | NYY | CHC | 2016 | 2017 | FLA |
5608 | 5608 | A.J. Ellis | 35 | ellisaj01 | 2016 | PHI | NL | 0.357583231 | 0.145 | C | 1 | 2 | PHI | LAD | 2016 | 2016 | FLA |
5619 | 5619 | Jorge Alfaro | 23 | alfarjo01 | 2016 | PHI | NL | 0.173683283 | -0.275 | C | 0 | 1 | PHI | 2016 | 2018 | FLA | |
5649 | 5649 | Jeff Locke | 28 | lockeje01 | 2016 | PIT | NL | 3.47169919 | -0.105 | P | 5 | 1 | PIT | 2011 | 2016 | FLA | |
5698 | 5698 | Fernando Rodney | 39 | rodnefe01 | 2016 | SDP | NL | 1.127286486 | 1.27 | P | 5 | 1 | SDP | CHC | 2016 | 2016 | FLA |
5702 | 5702 | Andrew Cashner | 29 | cashnan01 | 2016 | SDP | NL | 2.252447354 | 0.065 | P | 4 | 1 | SDP | CHC | 2012 | 2016 | FLA |
5703 | 5703 | Colin Rea | 25 | reaco01 | 2016 | SDP | NL | 2.759964139 | 0.02 | P | 4 | 1 | SDP | 2015 | 2016 | FLA | |
5726 | 5726 | Tayron Guerrero | 25 | guerrta01 | 2016 | SDP | NL | 0.03370624 | 0.005 | P | 0 | 1 | SDP | 2016 | 2016 | FLA | |
5915 | 5915 | Oswaldo Arcia | 25 | arciaos01 | 2016 | TBR | AL | 0.587610032 | 0.025 | LF, RF | 1 | 2 | TBD | MIN | 2016 | 2016 | FLA |
6107 | 6107 | Peter O'Brien | 24 | obriepe01 | 2015 | ARI | NL | 0.117033799 | 0.12 | LF | 1 | 1 | ARI | 2015 | 2016 | FLA | |
6157 | 6157 | Edwin Jackson | 31 | jacksed01 | 2015 | ATL | NL | 0.781070367 | -0.075 | P | 1 | 2 | ATL | CHC | 2015 | 2015 | FLA |
6187 | 6187 | Wei-Yin Chen | 29 | chenwe02 | 2015 | BAL | AL | 5.459781279 | 3.265 | P | 17 | 1 | BAL | 2012 | 2015 | FLA | |
6248 | 6248 | Junichi Tazawa | 29 | tazawju01 | 2015 | BOS | AL | 2.050692069 | 0.795 | P | 5 | 1 | BOS | 2009 | 2016 | FLA | |
6259 | 6259 | Craig Breslow | 34 | breslcr01 | 2015 | BOS | AL | 1.815716936 | -0.07 | P | 2 | 1 | BOS | ARI | 2012 | 2015 | FLA |
6353 | 6353 | JB Shuck | 28 | shuckja01 | 2015 | CHW | AL | 1.582602944 | 0.36 | RF, CF, LF | 3 | 1 | CHW | CLE | 2015 | 2016 | FLA |
6367 | 6367 | Hector Noesi | 28 | noesihe01 | 2015 | CHW | AL | 0.713460068 | -0.42 | P | 0 | 1 | CHW | TEX | 2014 | 2015 | FLA |
6455 | 6455 | Chris Johnson | 30 | johnsch05 | 2015 | CLE | AL | 0.886442071 | -0.120745342 | 3B, 1B | 1 | 2 | CLE | ATL | 2015 | 2015 | FLA |
6619 | 6619 | Edinson Volquez | 31 | volqued01 | 2015 | KCR | AL | 5.572641782 | 2.545 | P | 17 | 1 | KCR | PIT | 2015 | 2016 | FLA |
6641 | 6641 | Christian Colon | 26 | colonch01 | 2015 | KCR | AL | 1.132775316 | 0.365 | SS, 2B, 3B | 3 | 1 | KCR | 2014 | 2017 | FLA | |
6698 | 6698 | Jo-Jo Reyes | 30 | reyesjo03 | 2015 | LAA | AL | 0.00539031 | 0.005 | P | 0 | 1 | ANA | BAL | 2015 | 2015 | FLA |
6857 | 6857 | Yadiel Rivera | 23 | riverya01 | 2015 | MIL | NL | 0.152337594 | -0.055 | 2B, SS, 3B | 0 | 1 | MIL | 2015 | 2017 | FLA | |
7107 | 7107 | Nefi Ogando | 26 | ogandne01 | 2015 | PHI | NL | 0.069591058 | -0.075 | P | 0 | 1 | PHI | 2015 | 2015 | FLA | |
7117 | 7117 | Dustin McGowan | 33 | mcgowdu01 | 2015 | PHI | NL | 0.564016027 | -0.645 | P | 0 | 1 | PHI | TOR | 2015 | 2015 | FLA |
7133 | 7133 | Jeff Locke | 27 | lockeje01 | 2015 | PIT | NL | 4.509066237 | 0.21 | P | 8 | 1 | PIT | 2011 | 2016 | FLA | |
7159 | 7159 | Steve Lombardozzi | 26 | lombast02 | 2015 | PIT | NL | 0.107317073 | -0.285 | 0 | 1 | PIT | BAL | 2015 | 2015 | FLA | |
7173 | 7173 | Andrew Cashner | 28 | cashnan01 | 2015 | SDP | NL | 5.313148219 | 0.27 | P | 9 | 1 | SDP | CHC | 2012 | 2016 | FLA |
7187 | 7187 | Colin Rea | 24 | reaco01 | 2015 | SDP | NL | 0.90625315 | 0.33 | P | 2 | 1 | SDP | 2015 | 2016 | FLA | |
7299 | 7299 | Cody Hall | 27 | hallco01 | 2015 | SFG | NL | 0.189433915 | -0.11 | P | 0 | 1 | SFG | 2015 | 2015 | FLA | |
7306 | 7306 | Casey McGehee | 32 | mcgehca01 | 2015 | SFG | NL | 1.380237972 | -0.72 | 3B, 1B | 0 | 1 | SFG | FLA | 2015 | 2015 | FLA |
7348 | 7348 | Xavier Scruggs | 27 | scrugxa01 | 2015 | STL | NL | 0.431040442 | -0.115 | 1B | 0 | 1 | STL | 2014 | 2015 | FLA | |
7450 | 7450 | Tomas Telis | 24 | telisto01 | 2015 | TEX | AL | 0.112895377 | -0.09 | C | 0 | 1 | TEX | 2014 | 2015 | FLA | |
7558 | 7558 | Tyler Moore | 28 | moorety01 | 2015 | WSN | NL | 2.014938336 | -1.16 | 1B, LF, P, RF | 0 | 1 | WSN | 2012 | 2015 | FLA | |
7656 | 7656 | Wei-Yin Chen | 28 | chenwe02 | 2014 | BAL | AL | 4.945197244 | 2.105 | P | 14 | 1 | BAL | 2012 | 2015 | FLA | |
7707 | 7707 | Junichi Tazawa | 28 | tazawju01 | 2014 | BOS | AL | 2.311827746 | 0.84 | P | 6 | 1 | BOS | 2009 | 2016 | FLA | |
7747 | 7747 | Craig Breslow | 33 | breslcr01 | 2014 | BOS | AL | 1.41622991 | -1.11 | P | 0 | 1 | BOS | ARI | 2012 | 2015 | FLA |
7806 | 7806 | Hector Noesi | 27 | noesihe01 | 2014 | CHW | AL | 4.52805259 | 0.505 | P | 8 | 3 | CHW | TEX | 2014 | 2015 | FLA |
7838 | 7838 | Andre Rienzo | 25 | rienzan01 | 2014 | CHW | AL | 1.488917237 | -1.0 | P | 0 | 1 | CHW | 2013 | 2014 | FLA | |
7853 | 7853 | Mat Latos | 26 | latosma01 | 2014 | CIN | NL | 2.864835543 | 1.33 | P | 8 | 1 | CIN | SDP | 2012 | 2014 | FLA |
7962 | 7962 | Nick Masset | 32 | masseni01 | 2014 | COL | NL | 1.262887025 | -0.32 | P | 1 | 1 | COL | CIN | 2014 | 2014 | FLA |
8005 | 8005 | Don Kelly | 34 | kellydo01 | 2014 | DET | AL | 1.737370466 | -0.245 | 3B, 1B, RF, LF, CF, 2B | 2 | 1 | DET | PIT | 2009 | 2014 | FLA |
8041 | 8041 | Jarred Cosart | 24 | cosarja01 | 2014 | HOU | AL | 3.276547223 | 0.675 | P | 6 | 1 | HOU | 2013 | 2014 | FLA | |
8045 | 8045 | Enrique Hernandez | 22 | hernaen02 | 2014 | HOU | AL | 0.855627383 | 0.815 | CF, LF, SS, 2B, 3B, RF | 4 | 1 | HOU | 2014 | 2014 | FLA | |
8073 | 8073 | Paul Clemens | 26 | clemepa02 | 2014 | HOU | AL | 0.602354944 | -0.6 | P | 0 | 1 | HOU | 2013 | 2014 | FLA | |
8095 | 8095 | Christian Colon | 25 | colonch01 | 2014 | KCR | AL | 0.471153846 | 0.65 | 2B, 3B, SS | 3 | 1 | KCR | 2014 | 2017 | FLA | |
8183 | 8183 | Dee Gordon | 26 | gordode01 | 2014 | LAD | NL | 6.422487223 | 3.05 | 2B | 18 | 1 | LAD | 2011 | 2014 | FLA | |
8192 | 8192 | Dan Haren | 33 | harenda01 | 2014 | LAD | NL | 5.254116344 | 0.85 | P | 9 | 1 | LAD | WSN | 2014 | 2014 | FLA |
8196 | 8196 | Miguel Rojas | 25 | rojasmi02 | 2014 | LAD | NL | 1.600681431 | 0.625 | SS, 3B, 2B, LF | 4 | 1 | LAD | 2014 | 2014 | FLA | |
8416 | 8416 | Ichiro Suzuki | 40 | suzukic01 | 2014 | NYY | AL | 3.686643553 | 1.015 | RF, LF, CF | 9 | 1 | NYY | SEA | 2012 | 2014 | FLA |
8420 | 8420 | Martin Prado | 30 | pradoma01 | 2014 | NYY | AL | 1.311870563 | 1.65 | 3B, 2B, RF, LF | 7 | 2 | NYY | ARI | 2014 | 2014 | FLA |
8427 | 8427 | David Phelps | 27 | phelpda01 | 2014 | NYY | AL | 3.146515734 | 0.065 | P | 5 | 1 | NYY | 2012 | 2014 | FLA | |
8551 | 8551 | Reid Brignac | 28 | brignre01 | 2014 | PHI | NL | 0.90083632 | -0.35 | 3B, 2B, SS | 0 | 1 | PHI | NYY | 2014 | 2014 | FLA |
8573 | 8573 | Jeff Locke | 26 | lockeje01 | 2014 | PIT | NL | 3.597349484 | 0.275 | P | 6 | 1 | PIT | 2011 | 2016 | FLA |
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 );