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,982 rows where prev_franch = "SFG"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67 | 67 | Mark Melancon | 34 | melanma01 | 2019 | ATL | NL | 0.662735345 | 0.458490566 | P | 3 | 2 | ATL | SFG | 2019 | 2019 | |
145 | 145 | Ty Blach | 28 | blachty01 | 2019 | BAL | AL | 0.60240791 | -0.468679245 | P | 0 | 2 | BAL | SFG | 2019 | 2019 | |
176 | 176 | Heath Hembree | 30 | hembrhe01 | 2019 | BOS | AL | 1.078635403 | 0.198679245 | P | 2 | 1 | BOS | SFG | 2014 | 2019 | |
196 | 196 | Gorkys Hernandez | 31 | hernago01 | 2019 | BOS | AL | 0.42983286 | -0.560377358 | LF, RF, CF | 0 | 1 | BOS | SFG | 2019 | 2019 | |
199 | 199 | Eduardo Nunez | 32 | nunezed02 | 2019 | BOS | AL | 1.591296121 | -1.334716981 | 2B, 3B, SS, P | 0 | 1 | BOS | SFG | 2017 | 2019 | |
227 | 227 | Derek Holland | 32 | hollade01 | 2019 | CHC | NL | 0.43249152 | 0.188490566 | P | 1 | 2 | CHC | SFG | 2019 | 2019 | |
269 | 269 | Josh Osich | 30 | osichjo01 | 2019 | CHW | AL | 1.860860849 | 0.256329114 | P | 3 | 1 | CHW | SFG | 2019 | 2019 | |
643 | 643 | Jarrett Parker | 30 | parkeja03 | 2019 | LAA | AL | 0.141948116 | -0.152830189 | LF | 0 | 1 | ANA | SFG | 2019 | 2019 | |
647 | 647 | Chris Stratton | 28 | stratch01 | 2019 | LAA | AL | 0.773937979 | -0.40245283 | P | 0 | 1 | ANA | SFG | 2019 | 2019 | PIT |
771 | 771 | Drew Pomeranz | 30 | pomerdr01 | 2019 | MIL | NL | 0.884571644 | 0.860943396 | P | 4 | 2 | MIL | SFG | 2019 | 2019 | |
781 | 781 | Tyler Austin | 27 | austity01 | 2019 | MIL | NL | 0.216933016 | 0.219056604 | LF, 1B, RF | 1 | 3 | MIL | SFG | 2019 | 2019 | |
784 | 784 | Ray Black | 29 | blackra01 | 2019 | MIL | NL | 0.347368715 | -0.00509434 | P | 1 | 2 | MIL | SFG | 2019 | 2019 | |
822 | 822 | Ehire Adrianza | 29 | adriaeh01 | 2019 | MIN | AL | 2.183094099 | 0.81 | 3B, SS, 1B, 2B, RF, LF, P | 6 | 1 | MIN | SFG | 2017 | 2019 | |
849 | 849 | Sam Dyson | 31 | dysonsa01 | 2019 | MIN | AL | 0.36293081 | -0.254716981 | P | 0 | 2 | MIN | SFG | 2019 | 2019 | |
872 | 872 | Joe Panik | 28 | panikjo01 | 2019 | NYM | NL | 0.963356164 | 0.183396226 | 2B | 2 | 2 | NYM | SFG | 2019 | 2019 | |
901 | 901 | Aaron Altherr | 28 | altheaa01 | 2019 | NYM | NL | 0.34760274 | -0.397358491 | LF, CF, RF, P | 0 | 3 | NYM | SFG | 2019 | 2019 | |
1002 | 1002 | Nick Hundley | 35 | hundlni01 | 2019 | OAK | AL | 0.689801238 | -0.382075472 | C | 0 | 1 | OAK | SFG | 2019 | 2019 | |
1031 | 1031 | Nick Vincent | 32 | vinceni01 | 2019 | PHI | NL | 0.416925838 | 0.382075472 | P | 2 | 2 | PHI | SFG | 2019 | 2019 | |
1093 | 1093 | Kyle Crick | 26 | crickky01 | 2019 | PIT | NL | 1.775594767 | -0.448301887 | P | 1 | 1 | PIT | SFG | 2018 | 2019 | |
1095 | 1095 | Corban Joseph | 30 | josepco01 | 2019 | PIT | NL | 0.069903581 | 0.00509434 | 2B, 3B | 0 | 3 | PIT | SFG | 2019 | 2019 | |
1098 | 1098 | Williams Jerez | 27 | jerezwi01 | 2019 | PIT | NL | 0.059599717 | -0.076415094 | P | 0 | 2 | PIT | SFG | 2019 | 2019 | |
1210 | 1210 | Mac Williamson | 28 | willima11 | 2019 | SEA | AL | 0.831849654 | -0.056037736 | LF, RF | 1 | 2 | SEA | SFG | 2019 | 2019 | |
1223 | 1223 | Hunter Strickland | 30 | strichu01 | 2019 | SEA | AL | 0.147498076 | -0.13245283 | P | 0 | 1 | SEA | SFG | 2019 | 2019 | WSN |
1381 | 1381 | Matt Duffy | 28 | duffyma01 | 2019 | TBR | AL | 1.528053342 | -0.178301887 | 3B, SS | 2 | 1 | TBD | SFG | 2016 | 2019 | |
1385 | 1385 | Christian Arroyo | 24 | arroych01 | 2019 | TBR | AL | 0.537648398 | 0.086603774 | 3B, 2B | 1 | 1 | TBD | SFG | 2018 | 2019 | |
1401 | 1401 | Erik Kratz | 39 | kratzer01 | 2019 | TBR | AL | 0.160351277 | -0.315849057 | C | 0 | 2 | TBD | SFG | 2019 | 2019 | |
1408 | 1408 | Hunter Pence | 36 | pencehu01 | 2019 | TEX | AL | 3.024422442 | 1.737169811 | LF, RF | 10 | 1 | TEX | SFG | 2019 | 2019 | |
1479 | 1479 | Derek Law | 28 | lawde01 | 2019 | TOR | AL | 1.945983885 | 0.127358491 | P | 3 | 1 | TOR | SFG | 2019 | 2019 | |
1510 | 1510 | Alen Hanson | 26 | hansoal01 | 2019 | TOR | AL | 0.466644318 | -0.555283019 | 2B, RF, 1B, LF | 0 | 1 | TOR | SFG | 2019 | 2019 | |
1540 | 1540 | Gerardo Parra | 32 | parrage01 | 2019 | WSN | NL | 1.937661443 | -0.27 | RF, LF, 1B, CF, 2B, 3B, P | 2 | 2 | WSN | SFG | 2019 | 2019 | |
1749 | 1749 | Eduardo Nunez | 31 | nunezed02 | 2018 | BOS | AL | 4.634829672 | -0.71 | 2B, 3B | 5 | 1 | BOS | SFG | 2017 | 2019 | |
1750 | 1750 | Heath Hembree | 29 | hembrhe01 | 2018 | BOS | AL | 1.990700701 | 0.285 | P | 4 | 1 | BOS | SFG | 2014 | 2019 | |
1882 | 1882 | Adam Duvall | 29 | duvalad01 | 2018 | CIN | NL | 3.641608688 | 1.025 | LF, 1B, RF, 3B | 8 | 1 | CIN | SFG | 2015 | 2018 | ATL |
2103 | 2103 | Tim Federowicz | 30 | federti01 | 2018 | HOU | AL | 0.331645156 | -0.25 | C | 0 | 1 | HOU | SFG | 2018 | 2018 | CIN |
2385 | 2385 | Ehire Adrianza | 28 | adriaeh01 | 2018 | MIN | AL | 3.46183953 | 0.475 | SS, 3B, 1B, 2B, LF | 6 | 1 | MIN | SFG | 2017 | 2019 | |
2448 | 2448 | Austin Jackson | 31 | jacksau01 | 2018 | NYM | NL | 2.084188912 | -0.245 | CF, LF | 2 | 2 | NYM | SFG | 2018 | 2018 | |
2503 | 2503 | Andrew McCutchen | 31 | mccutan01 | 2018 | NYY | AL | 1.058089294 | 0.78 | RF, LF | 4 | 2 | NYY | SFG | 2018 | 2018 | PHI |
2557 | 2557 | Santiago Casilla | 37 | garcija01 | 2018 | OAK | AL | 0.739323263 | 0.3 | P | 2 | 1 | OAK | SFG | 2017 | 2018 | |
2647 | 2647 | Kyle Crick | 25 | crickky01 | 2018 | PIT | NL | 1.941630826 | 1.22757764 | P | 7 | 1 | PIT | SFG | 2018 | 2019 | |
2674 | 2674 | George Kontos | 33 | kontoge01 | 2018 | PIT | NL | 0.689898937 | -0.387391304 | P | 0 | 1 | PIT | SFG | 2017 | 2018 | CLE |
2764 | 2764 | Gordon Beckham | 31 | beckhgo01 | 2018 | SEA | AL | 0.478153339 | 0.005 | 2B, 3B, SS | 1 | 1 | SEA | SFG | 2017 | 2018 | DET |
2881 | 2881 | Matt Duffy | 27 | duffyma01 | 2018 | TBR | AL | 5.261623198 | 2.46 | 3B, SS | 14 | 1 | TBD | SFG | 2016 | 2019 | |
2900 | 2900 | Denard Span | 34 | spande01 | 2018 | TBR | AL | 1.625465738 | 0.76 | LF, CF | 4 | 1 | TBD | SFG | 2018 | 2018 | SEA |
2917 | 2917 | Christian Arroyo | 23 | arroych01 | 2018 | TBR | AL | 0.554349587 | 0.215 | 2B, 3B | 1 | 1 | TBD | SFG | 2018 | 2019 | |
2954 | 2954 | Cory Gearrin | 32 | gearrco01 | 2018 | TEX | AL | 0.680619821 | 0.59 | P | 3 | 2 | TEX | SFG | 2018 | 2018 | OAK |
2958 | 2958 | Matt Moore | 29 | moorema02 | 2018 | TEX | AL | 2.722274771 | -0.47 | P | 2 | 1 | TEX | SFG | 2018 | 2018 | DET |
3118 | 3118 | Gregor Blanco | 33 | blancgr01 | 2017 | ARI | NL | 2.527749404 | 0.28 | LF, CF, RF | 4 | 1 | ARI | SFG | 2017 | 2017 | SFG |
3224 | 3224 | Ruben Tejada | 27 | tejadru01 | 2017 | BAL | AL | 1.174779484 | -0.18 | SS, 3B, 2B | 1 | 1 | BAL | SFG | 2017 | 2017 | NYM |
3261 | 3261 | Eduardo Nunez | 30 | nunezed02 | 2017 | BOS | AL | 1.588915281 | 1.02 | 3B, 2B, LF, SS, RF | 5 | 2 | BOS | SFG | 2017 | 2019 | |
3262 | 3262 | Heath Hembree | 28 | hembrhe01 | 2017 | BOS | AL | 2.064749001 | 0.435 | P | 4 | 1 | BOS | SFG | 2014 | 2019 | |
3290 | 3290 | Pablo Sandoval | 30 | sandopa01 | 2017 | BOS | AL | 0.99192399 | -0.685 | 3B, 1B, 2B | 0 | 1 | BOS | SFG | 2015 | 2017 | SFG |
3393 | 3393 | Adam Duvall | 28 | duvalad01 | 2017 | CIN | NL | 6.376550552 | 1.66 | LF, 1B | 13 | 1 | CIN | SFG | 2015 | 2018 | ATL |
3768 | 3768 | Sergio Romo | 34 | romose01 | 2017 | LAD | NL | 0.729669899 | -0.44 | P | 0 | 1 | LAD | SFG | 2017 | 2017 | TBD |
3855 | 3855 | Andrew Susac | 27 | susacan01 | 2017 | MIL | NL | 0.11960818 | -0.22 | C | 0 | 1 | MIL | SFG | 2016 | 2017 | BAL |
3877 | 3877 | Ehire Adrianza | 27 | adriaeh01 | 2017 | MIN | AL | 1.72967773 | 0.925 | SS, LF, 2B, 3B, 1B | 5 | 1 | MIN | SFG | 2017 | 2019 | |
3955 | 3955 | Neil Ramirez | 28 | ramirne01 | 2017 | NYM | NL | 0.486290724 | -0.21 | P | 0 | 2 | NYM | SFG | 2017 | 2017 | CLE |
4038 | 4038 | Santiago Casilla | 36 | garcija01 | 2017 | OAK | AL | 2.069656979 | 0.27 | P | 4 | 1 | OAK | SFG | 2017 | 2018 | |
4144 | 4144 | George Kontos | 32 | kontoge01 | 2017 | PIT | NL | 0.49972717 | 0.47 | P | 2 | 2 | PIT | SFG | 2017 | 2018 | CLE |
4159 | 4159 | Dan Runzler | 32 | runzlda01 | 2017 | PIT | NL | 0.098566317 | -0.16 | P | 0 | 1 | PIT | SFG | 2017 | 2017 | |
4271 | 4271 | Gordon Beckham | 30 | beckhgo01 | 2017 | SEA | AL | 0.17006027 | -0.155 | 2B, SS, 3B | 0 | 1 | SEA | SFG | 2017 | 2018 | DET |
4279 | 4279 | Chris Heston | 29 | hestoch01 | 2017 | SEA | AL | 0.129472375 | -0.425 | P | 0 | 1 | SEA | SFG | 2017 | 2017 | MIN |
4341 | 4341 | Mike Leake | 29 | leakemi01 | 2017 | STL | NL | 4.30695994 | 1.41 | P | 10 | 1 | STL | SFG | 2016 | 2017 | SEA |
4581 | 4581 | Grant Green | 29 | greengr01 | 2017 | WSN | NL | 0.02974359 | -0.135 | 2B | 0 | 1 | WSN | SFG | 2017 | 2017 | |
4771 | 4771 | Heath Hembree | 27 | hembrhe01 | 2016 | BOS | AL | 1.495972794 | 0.39 | P | 3 | 1 | BOS | SFG | 2014 | 2019 | |
4793 | 4793 | Pablo Sandoval | 29 | sandopa01 | 2016 | BOS | AL | 0.064516129 | -0.21 | 3B | 0 | 1 | BOS | SFG | 2015 | 2017 | SFG |
4880 | 4880 | Hector Sanchez | 26 | sanchhe01 | 2016 | CHW | AL | 0.075953511 | -0.075 | C | 0 | 1 | CHW | SFG | 2016 | 2016 | SDP |
4895 | 4895 | Adam Duvall | 27 | duvalad01 | 2016 | CIN | NL | 6.114791053 | 2.79 | LF, RF, 1B, 3B | 18 | 1 | CIN | SFG | 2015 | 2018 | ATL |
4967 | 4967 | Marlon Byrd | 38 | byrdma01 | 2016 | CLE | AL | 1.220554649 | 0.462857143 | RF, LF | 3 | 1 | CLE | SFG | 2016 | 2016 | |
5222 | 5222 | Tim Lincecum | 32 | linceti01 | 2016 | LAA | AL | 1.115164939 | -1.135 | P | 0 | 1 | ANA | SFG | 2016 | 2016 | |
5319 | 5319 | Cody Hall | 28 | hallco01 | 2016 | MIA | NL | 0.06748302 | -0.140869565 | P | 0 | 1 | FLA | SFG | 2016 | 2016 | |
5361 | 5361 | Andrew Susac | 26 | susacan01 | 2016 | MIL | NL | 0.191585535 | 0.045 | C | 0 | 1 | MIL | SFG | 2016 | 2017 | BAL |
5456 | 5456 | Alejandro De Aza | 32 | deazaal01 | 2016 | NYM | NL | 2.673687845 | -0.34 | CF, LF, RF | 3 | 1 | NYM | SFG | 2016 | 2016 | WSN |
5654 | 5654 | Ryan Vogelsong | 38 | vogelry01 | 2016 | PIT | NL | 2.318793849 | -0.105 | P | 3 | 1 | PIT | SFG | 2016 | 2016 | |
5737 | 5737 | Nick Noonan | 27 | noonani01 | 2016 | SDP | NL | 0.20383061 | -0.535 | SS, 2B | 0 | 1 | SDP | SFG | 2016 | 2016 | |
5748 | 5748 | Nori Aoki | 34 | aokino01 | 2016 | SEA | AL | 4.367300871 | 1.54 | LF, CF | 11 | 1 | SEA | SFG | 2016 | 2016 | HOU |
5850 | 5850 | Mike Leake | 28 | leakemi01 | 2016 | STL | NL | 5.023708744 | 1.465 | P | 11 | 1 | STL | SFG | 2016 | 2017 | SEA |
5912 | 5912 | Matt Duffy | 25 | duffyma01 | 2016 | TBR | AL | 0.770636107 | 0.085 | 3B, SS | 1 | 2 | TBD | SFG | 2016 | 2019 | |
6052 | 6052 | Yusmeiro Petit | 31 | petityu01 | 2016 | WSN | NL | 1.711329093 | 0.04 | P | 3 | 1 | WSN | SFG | 2016 | 2016 | ANA |
6258 | 6258 | Pablo Sandoval | 28 | sandopa01 | 2015 | BOS | AL | 4.715067611 | -1.05 | 3B | 3 | 1 | BOS | SFG | 2015 | 2017 | SFG |
6262 | 6262 | Heath Hembree | 26 | hembrhe01 | 2015 | BOS | AL | 0.567644949 | 0.115 | P | 1 | 1 | BOS | SFG | 2014 | 2019 | |
6276 | 6276 | Jean Machi | 33 | machije01 | 2015 | BOS | AL | 0.752428318 | -0.23 | P | 0 | 2 | BOS | SFG | 2015 | 2015 | SEA |
6372 | 6372 | Conor Gillaspie | 27 | gillaco01 | 2015 | CHW | AL | 1.774433603 | -0.845 | 3B, 1B, 2B | 0 | 1 | CHW | SFG | 2013 | 2015 | ANA |
6393 | 6393 | Adam Duvall | 26 | duvalad01 | 2015 | CIN | NL | 0.712749616 | 0.245 | LF, 1B | 2 | 1 | CIN | SFG | 2015 | 2018 | ATL |
6400 | 6400 | Chris Dominguez | 28 | dominch01 | 2015 | CIN | NL | 0.227683905 | 0.085 | 1B, LF, RF | 1 | 1 | CIN | SFG | 2015 | 2015 | |
6741 | 6741 | Juan Uribe | 36 | uribeju01 | 2015 | LAD | NL | 0.87863486 | 0.2 | 3B, 2B | 2 | 1 | LAD | SFG | 2011 | 2015 | ATL |
6807 | 6807 | Erik Cordier | 29 | cordier01 | 2015 | MIA | NL | 0.262879522 | -0.11 | P | 0 | 1 | FLA | SFG | 2015 | 2015 | |
6816 | 6816 | Mike Morse | 33 | morsemi01 | 2015 | MIA | NL | 1.77989418 | -0.64 | 1B, LF | 0 | 1 | FLA | SFG | 2015 | 2015 | PIT |
6817 | 6817 | Casey McGehee | 32 | mcgehca01 | 2015 | MIA | NL | 1.227513228 | -0.65 | 3B, 1B | 0 | 2 | FLA | SFG | 2015 | 2015 | DET |
6956 | 6956 | Johnny Monell | 29 | moneljo01 | 2015 | NYM | NL | 0.520628345 | -0.38 | C | 0 | 1 | NYM | SFG | 2015 | 2015 | |
7060 | 7060 | Barry Zito | 37 | zitoba01 | 2015 | OAK | AL | 0.174788975 | -0.43 | P | 0 | 1 | OAK | SFG | 2015 | 2015 | |
7064 | 7064 | Dan Otero | 30 | oteroda01 | 2015 | OAK | AL | 1.271192548 | -0.58 | P | 0 | 1 | OAK | SFG | 2013 | 2015 | CLE |
7158 | 7158 | Travis Ishikawa | 31 | ishiktr01 | 2015 | PIT | NL | 0.643902439 | -0.24 | 1B, LF | 0 | 2 | PIT | SFG | 2015 | 2015 | |
7546 | 7546 | Dan Uggla | 35 | ugglada01 | 2015 | WSN | NL | 1.420531527 | -0.18 | 2B, 1B | 1 | 1 | WSN | SFG | 2015 | 2015 | |
7548 | 7548 | Emmanuel Burriss | 30 | burriem01 | 2015 | WSN | NL | 0.050373458 | 0.125 | 2B | 0 | 1 | WSN | SFG | 2015 | 2015 | PHI |
7608 | 7608 | Roger Kieschnick | 27 | kiescro01 | 2014 | ARI | NL | 0.412847222 | -0.48 | LF, RF | 0 | 1 | ARI | SFG | 2014 | 2014 | |
7683 | 7683 | Ramon Ramirez | 32 | ramirra02 | 2014 | BAL | AL | 0.015322178 | 0.015 | P | 0 | 1 | BAL | SFG | 2014 | 2014 | |
7739 | 7739 | Heath Hembree | 25 | hembrhe01 | 2014 | BOS | AL | 0.257743456 | -0.06 | P | 0 | 1 | BOS | SFG | 2014 | 2019 | |
7792 | 7792 | Eli Whiteside | 34 | whiteel03 | 2014 | CHC | NL | 0.261533125 | -0.47 | C | 0 | 1 | CHC | SFG | 2014 | 2014 | |
7803 | 7803 | Conor Gillaspie | 26 | gillaco01 | 2014 | CHW | AL | 4.848504874 | 1.715 | 3B | 12 | 1 | CHW | SFG | 2013 | 2015 | ANA |
7825 | 7825 | Eric Surkamp | 26 | surkaer01 | 2014 | CHW | AL | 0.860021044 | -0.2 | P | 1 | 1 | CHW | SFG | 2014 | 2014 | LAD |
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 );