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,241 rows where prev_franch = "SDP"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
171 | 171 | Colten Brewer | 26 | breweco01 | 2019 | BOS | AL | 1.475490887 | 0.336226415 | P | 3 | 1 | BOS | SDP | 2019 | 2019 | |
202 | 202 | Anthony Rizzo | 29 | rizzoan01 | 2019 | CHC | NL | 6.198396095 | 4.029622642 | 1B | 20 | 1 | CHC | SDP | 2012 | 2019 | |
220 | 220 | Rowan Wick | 26 | wickro01 | 2019 | CHC | NL | 1.064200389 | 0.718301887 | P | 3 | 1 | CHC | SDP | 2019 | 2019 | |
225 | 225 | Brad Wieck | 27 | wieckbr01 | 2019 | CHC | NL | 0.319019007 | 0.356603774 | P | 1 | 2 | CHC | SDP | 2019 | 2019 | |
278 | 278 | Jose Ruiz | 24 | ruizjo01 | 2019 | CHW | AL | 1.060472163 | -0.025632911 | P | 1 | 1 | CHW | SDP | 2018 | 2019 | |
295 | 295 | Jose Rondon | 25 | rondojo02 | 2019 | CHW | AL | 1.529411765 | -0.712594937 | 2B, SS, 3B, LF, 1B, P | 0 | 1 | CHW | SDP | 2018 | 2019 | BAL |
358 | 358 | Brad Hand | 29 | handbr01 | 2019 | CLE | AL | 2.261425777 | 1.380566038 | P | 8 | 1 | CLE | SDP | 2018 | 2019 | |
368 | 368 | Adam Cimber | 28 | cimbead01 | 2019 | CLE | AL | 2.087087698 | 0.361698113 | P | 4 | 1 | CLE | SDP | 2018 | 2019 | |
376 | 376 | Franmil Reyes | 23 | reyesfr01 | 2019 | CLE | AL | 1.816727757 | -0.127358491 | RF | 2 | 2 | CLE | SDP | 2019 | 2019 | |
384 | 384 | Logan Allen | 22 | allenlo01 | 2019 | CLE | AL | 0.040944602 | 0.096792453 | P | 0 | 2 | CLE | SDP | 2019 | 2019 | |
387 | 387 | Phil Maton | 26 | matonph01 | 2019 | CLE | AL | 0.186140064 | 0.040754717 | P | 0 | 2 | CLE | SDP | 2019 | 2019 | |
388 | 388 | Jon Edwards | 31 | edwarjo02 | 2019 | CLE | AL | 0.201254885 | 0.0 | P | 0 | 1 | CLE | SDP | 2018 | 2019 | |
422 | 422 | Tim Melville | 29 | melviti01 | 2019 | COL | NL | 0.955688075 | 0.300566038 | P | 2 | 1 | COL | SDP | 2019 | 2019 | |
556 | 556 | Ian Kennedy | 34 | kenneia01 | 2019 | KCR | AL | 2.133740642 | 1.35509434 | P | 7 | 1 | KCR | SDP | 2016 | 2019 | |
699 | 699 | Rocky Gale | 31 | galero01 | 2019 | LAD | NL | 0.149922454 | -0.208867925 | C | 0 | 1 | LAD | SDP | 2018 | 2019 | |
745 | 745 | Tayron Guerrero | 28 | guerrta01 | 2019 | MIA | NL | 1.224547976 | -0.687735849 | P | 0 | 1 | FLA | SDP | 2018 | 2019 | |
776 | 776 | Jhoulys Chacin | 31 | chacijh01 | 2019 | MIL | NL | 2.43432159 | -0.224150943 | P | 3 | 1 | MIL | SDP | 2018 | 2019 | BOS |
779 | 779 | Cory Spangenberg | 28 | spangco01 | 2019 | MIL | NL | 0.887453247 | 0.315849057 | 2B, 3B, SS, LF | 2 | 1 | MIL | SDP | 2019 | 2019 | |
783 | 783 | Jay Jackson | 31 | jacksja01 | 2019 | MIL | NL | 0.670757342 | 0.127358491 | P | 1 | 1 | MIL | SDP | 2019 | 2019 | |
893 | 893 | Walker Lockett | 25 | lockewa01 | 2019 | NYM | NL | 0.530106519 | -0.122264151 | P | 0 | 1 | NYM | SDP | 2019 | 2019 | |
1039 | 1039 | Jose Pirela | 29 | pireljo01 | 2019 | PHI | NL | 0.169561479 | 0.13754717 | LF, RF | 1 | 2 | PHI | SDP | 2019 | 2019 | |
1209 | 1209 | Matt Wisler | 26 | wislema01 | 2019 | SEA | AL | 0.65767696 | -0.025471698 | P | 1 | 2 | SEA | SDP | 2019 | 2019 | |
1252 | 1252 | Alex Dickerson | 29 | dickeal01 | 2019 | SFG | NL | 1.638758884 | 0.983207547 | LF, RF | 6 | 2 | SFG | SDP | 2019 | 2019 | |
1325 | 1325 | Tyler Webb | 28 | webbty01 | 2019 | STL | NL | 1.436811887 | 0.315849057 | P | 3 | 1 | STL | SDP | 2018 | 2019 | |
1332 | 1332 | Jedd Gyorko | 30 | gyorkje01 | 2019 | STL | NL | 0.627027027 | -0.152830189 | 3B, 1B, 2B, P | 1 | 1 | STL | SDP | 2016 | 2019 | LAD |
1458 | 1458 | Freddy Galvis | 29 | galvifr01 | 2019 | TOR | AL | 4.598390882 | 1.650566038 | SS, 2B | 11 | 1 | TOR | SDP | 2019 | 2019 | CIN |
1494 | 1494 | Clayton Richard | 35 | richacl01 | 2019 | TOR | AL | 1.329239959 | -0.168113208 | P | 1 | 1 | TOR | SDP | 2019 | 2019 | |
1697 | 1697 | Brad Brach | 32 | brachbr01 | 2018 | BAL | AL | 1.372880239 | 0.165 | P | 2 | 1 | BAL | SDP | 2014 | 2018 | ATL |
1717 | 1717 | Luis Sardinas | 25 | sardilu01 | 2018 | BAL | AL | 0.192979538 | -0.255 | 2B | 0 | 1 | BAL | SDP | 2018 | 2018 | |
1737 | 1737 | Craig Kimbrel | 30 | kimbrcr01 | 2018 | BOS | AL | 2.656381185 | 1.785 | P | 10 | 1 | BOS | SDP | 2016 | 2018 | CHC |
1758 | 1758 | Drew Pomeranz | 29 | pomerdr01 | 2018 | BOS | AL | 1.865950124 | -0.445 | P | 2 | 1 | BOS | SDP | 2016 | 2018 | SFG |
1775 | 1775 | Anthony Rizzo | 28 | rizzoan01 | 2018 | CHC | NL | 6.385761589 | 2.787791411 | 1B, 2B, P | 18 | 1 | CHC | SDP | 2012 | 2019 | |
1803 | 1803 | Cory Mazzoni | 28 | mazzoco01 | 2018 | CHC | NL | 0.192414541 | 0.203742331 | P | 1 | 1 | CHC | SDP | 2018 | 2018 | |
1827 | 1827 | James Shields | 36 | shielja02 | 2018 | CHW | AL | 5.907988373 | 1.28 | P | 11 | 1 | CHW | SDP | 2016 | 2018 | |
1848 | 1848 | Jose Rondon | 24 | rondojo02 | 2018 | CHW | AL | 1.025785124 | 0.31 | SS, 3B, 2B, 1B | 2 | 1 | CHW | SDP | 2018 | 2019 | BAL |
1856 | 1856 | Jose Ruiz | 23 | ruizjo01 | 2018 | CHW | AL | 0.108148742 | 0.02 | P | 0 | 1 | CHW | SDP | 2018 | 2019 | |
1921 | 1921 | Kevin Quackenbush | 29 | quackke01 | 2018 | CIN | NL | 0.23873827 | -0.42 | P | 0 | 1 | CIN | SDP | 2018 | 2018 | |
1942 | 1942 | Brad Hand | 28 | handbr01 | 2018 | CLE | AL | 1.000396073 | 0.715 | P | 3 | 2 | CLE | SDP | 2018 | 2019 | |
1964 | 1964 | Jon Edwards | 30 | edwarjo02 | 2018 | CLE | AL | 0.258989325 | -0.02 | P | 0 | 1 | CLE | SDP | 2018 | 2019 | |
1969 | 1969 | Adam Cimber | 27 | cimbead01 | 2018 | CLE | AL | 0.612609365 | -0.1 | P | 0 | 2 | CLE | SDP | 2018 | 2019 | |
2114 | 2114 | Ian Kennedy | 33 | kenneia01 | 2018 | KCR | AL | 3.346820706 | 0.87 | P | 7 | 1 | KCR | SDP | 2016 | 2019 | |
2151 | 2151 | Burch Smith | 28 | smithbu03 | 2018 | KCR | AL | 1.854852475 | -0.85 | P | 0 | 1 | KCR | SDP | 2018 | 2018 | MIL |
2153 | 2153 | Brandon Maurer | 27 | maurebr01 | 2018 | KCR | AL | 0.979423526 | -1.015 | P | 0 | 1 | KCR | SDP | 2017 | 2018 | |
2192 | 2192 | Ryan Schimpf | 30 | schimry01 | 2018 | LAA | AL | 0.066710483 | 0.12 | 2B, 3B, LF, RF | 0 | 1 | ANA | SDP | 2018 | 2018 | |
2214 | 2214 | Jabari Blash | 28 | blashja01 | 2018 | LAA | AL | 0.428853105 | -0.755 | RF, LF | 0 | 1 | ANA | SDP | 2018 | 2018 | |
2218 | 2218 | Yasmani Grandal | 29 | grandya01 | 2018 | LAD | NL | 4.986556017 | 3.970490798 | C, 1B | 18 | 1 | LAD | SDP | 2015 | 2018 | MIL |
2258 | 2258 | Rocky Gale | 30 | galero01 | 2018 | LAD | NL | 0.019253112 | -0.024846626 | C | 0 | 1 | LAD | SDP | 2018 | 2019 | |
2298 | 2298 | Tayron Guerrero | 27 | guerrta01 | 2018 | MIA | NL | 1.599393493 | -0.643975155 | P | 1 | 1 | FLA | SDP | 2018 | 2019 | |
2322 | 2322 | Jhoulys Chacin | 30 | chacijh01 | 2018 | MIL | NL | 5.243365211 | 2.370368098 | P | 15 | 1 | MIL | SDP | 2018 | 2019 | BOS |
2354 | 2354 | Jordan Lyles | 27 | lylesjo01 | 2018 | MIL | NL | 0.411405174 | 0.188834356 | P | 1 | 2 | MIL | SDP | 2018 | 2018 | PIT |
2472 | 2472 | Buddy Baumann | 30 | baumabu01 | 2018 | NYM | NL | 0.080664214 | -0.365 | P | 0 | 2 | NYM | SDP | 2018 | 2018 | |
2748 | 2748 | Nick Vincent | 31 | vinceni01 | 2018 | SEA | AL | 1.949131288 | 0.445 | P | 4 | 1 | SEA | SDP | 2016 | 2018 | SFG |
2807 | 2807 | Chase d'Arnaud | 31 | darnach01 | 2018 | SFG | NL | 1.000172444 | 0.075 | 2B, 3B, 1B, P, SS | 2 | 1 | SFG | SDP | 2018 | 2018 | |
2824 | 2824 | Jose Valdez | 28 | valdejo03 | 2018 | SFG | NL | 0.080712503 | -0.22 | P | 0 | 1 | SFG | SDP | 2018 | 2018 | |
2839 | 2839 | Jedd Gyorko | 29 | gyorkje01 | 2018 | STL | NL | 3.970032351 | 1.7 | 3B, 2B, 1B, SS, P | 11 | 1 | STL | SDP | 2016 | 2019 | LAD |
2848 | 2848 | Tyson Ross | 31 | rossty01 | 2018 | STL | NL | 0.998941034 | 0.66 | P | 4 | 2 | STL | SDP | 2018 | 2018 | DET |
2860 | 2860 | Tyler Webb | 27 | webbty01 | 2018 | STL | NL | 0.393014776 | 0.02 | P | 1 | 2 | STL | SDP | 2018 | 2019 | |
3004 | 3004 | Yangervis Solarte | 30 | solarya01 | 2018 | TOR | AL | 4.849306015 | -1.02 | 3B, 2B, SS, 1B | 4 | 1 | TOR | SDP | 2018 | 2018 | SFG |
3069 | 3069 | Shawn Kelley | 34 | kellesh01 | 2018 | WSN | NL | 0.802621429 | 0.315 | P | 2 | 1 | WSN | SDP | 2016 | 2018 | OAK |
3161 | 3161 | Matt Kemp | 32 | kempma01 | 2017 | ATL | NL | 4.595520869 | -0.99 | LF | 4 | 1 | ATL | SDP | 2016 | 2017 | LAD |
3177 | 3177 | Jace Peterson | 27 | peterja01 | 2017 | ATL | NL | 2.115710892 | -0.765 | LF, 2B, 3B, 1B, SS, RF | 1 | 1 | ATL | SDP | 2015 | 2017 | NYY |
3202 | 3202 | Brad Brach | 31 | brachbr01 | 2017 | BAL | AL | 2.570036434 | 1.215 | P | 8 | 1 | BAL | SDP | 2014 | 2018 | ATL |
3234 | 3234 | Edwin Jackson | 33 | jacksed01 | 2017 | BAL | AL | 0.106777578 | -0.215 | P | 0 | 1 | BAL | SDP | 2017 | 2017 | WSN |
3244 | 3244 | Drew Pomeranz | 28 | pomerdr01 | 2017 | BOS | AL | 4.641707069 | 3.44 | P | 17 | 1 | BOS | SDP | 2016 | 2018 | SFG |
3248 | 3248 | Craig Kimbrel | 29 | kimbrcr01 | 2017 | BOS | AL | 2.652900887 | 3.395 | P | 14 | 1 | BOS | SDP | 2016 | 2018 | CHC |
3292 | 3292 | Anthony Rizzo | 27 | rizzoan01 | 2017 | CHC | NL | 6.755098601 | 4.16 | 1B, 2B, 3B, LF | 22 | 1 | CHC | SDP | 2012 | 2019 | |
3302 | 3302 | Jon Jay | 32 | jayjo02 | 2017 | CHC | NL | 4.232934435 | 1.395 | LF, CF, RF, P | 10 | 1 | CHC | SDP | 2017 | 2017 | KCR |
3356 | 3356 | James Shields | 35 | shielja02 | 2017 | CHW | AL | 3.430009876 | 0.05 | P | 5 | 1 | CHW | SDP | 2016 | 2018 | |
3372 | 3372 | Rymer Liriano | 26 | liriary01 | 2017 | CHW | AL | 0.441794999 | 0.12 | LF, RF | 1 | 1 | CHW | SDP | 2017 | 2017 | |
3407 | 3407 | Patrick Kivlehan | 27 | kivlepa01 | 2017 | CIN | NL | 2.010535259 | 0.035 | RF, 1B, LF, 3B, CF | 3 | 1 | CIN | SDP | 2016 | 2017 | ARI |
3465 | 3465 | Abraham Almonte | 28 | almonab01 | 2017 | CLE | AL | 1.82037663 | -0.065 | RF, LF, CF | 2 | 1 | CLE | SDP | 2015 | 2017 | KCR |
3517 | 3517 | Alexi Amarista | 28 | amarial01 | 2017 | COL | NL | 1.740791269 | -1.27 | 2B, SS, CF, RF, LF, 3B | 0 | 1 | COL | SDP | 2017 | 2017 | |
3518 | 3518 | Justin Upton | 29 | uptonju01 | 2017 | DET | AL | 4.921671018 | 4.795 | LF | 20 | 1 | DET | SDP | 2016 | 2017 | ANA |
3626 | 3626 | Ian Kennedy | 32 | kenneia01 | 2017 | KCR | AL | 4.300083429 | 0.265 | P | 8 | 1 | KCR | SDP | 2016 | 2019 | |
3633 | 3633 | Ryan Buchter | 30 | buchtry01 | 2017 | KCR | AL | 0.677310175 | 0.34 | P | 2 | 2 | KCR | SDP | 2017 | 2017 | OAK |
3656 | 3656 | Brandon Maurer | 26 | maurebr01 | 2017 | KCR | AL | 0.567411523 | -0.31 | P | 0 | 2 | KCR | SDP | 2017 | 2018 | |
3660 | 3660 | Trevor Cahill | 29 | cahiltr01 | 2017 | KCR | AL | 0.559796263 | -0.745 | P | 0 | 2 | KCR | SDP | 2017 | 2017 | OAK |
3701 | 3701 | Huston Street | 33 | streehu01 | 2017 | LAA | AL | 0.069671739 | 0.12 | P | 0 | 1 | ANA | SDP | 2014 | 2017 | |
3723 | 3723 | Yasmani Grandal | 28 | grandya01 | 2017 | LAD | NL | 4.76739427 | 3.16 | C | 17 | 1 | LAD | SDP | 2015 | 2018 | MIL |
3734 | 3734 | Brandon Morrow | 32 | morrobr01 | 2017 | LAD | NL | 1.412450358 | 1.355 | P | 6 | 1 | LAD | SDP | 2017 | 2017 | CHC |
3974 | 3974 | Chase Headley | 33 | headlch01 | 2017 | NYY | AL | 5.370200664 | 1.915 | 3B, 1B, 2B | 12 | 1 | NYY | SDP | 2014 | 2017 | SDP |
4023 | 4023 | Yonder Alonso | 30 | alonsyo01 | 2017 | OAK | AL | 3.52580698 | 1.78 | 1B | 10 | 1 | OAK | SDP | 2016 | 2017 | SEA |
4036 | 4036 | Jesse Hahn | 27 | hahnje01 | 2017 | OAK | AL | 1.942259694 | 0.565 | P | 4 | 1 | OAK | SDP | 2015 | 2017 | KCR |
4043 | 4043 | Adam Rosales | 34 | rosalad01 | 2017 | OAK | AL | 2.119285597 | -0.105 | SS, 3B, 2B, 1B, LF | 3 | 1 | OAK | SDP | 2017 | 2017 | ARI |
4230 | 4230 | Nick Vincent | 30 | vinceni01 | 2017 | SEA | AL | 2.449568014 | 1.525 | P | 8 | 1 | SEA | SDP | 2016 | 2018 | SFG |
4334 | 4334 | Jedd Gyorko | 28 | gyorkje01 | 2017 | STL | NL | 4.737306843 | 3.13 | 3B, 1B, 2B, LF | 15 | 1 | STL | SDP | 2016 | 2019 | LAD |
4407 | 4407 | Brad Boxberger | 29 | boxbebr01 | 2017 | TBR | AL | 0.976298332 | 0.37 | P | 2 | 1 | TBD | SDP | 2014 | 2017 | ARI |
4411 | 4411 | Derek Norris | 28 | norride01 | 2017 | TBR | AL | 1.875857563 | -0.045 | C | 2 | 1 | TBD | SDP | 2017 | 2017 | |
4480 | 4480 | Tyson Ross | 30 | rossty01 | 2017 | TEX | AL | 1.307215215 | -0.535 | P | 0 | 1 | TEX | SDP | 2017 | 2017 | SDP |
4515 | 4515 | Leonel Campos | 29 | campole01 | 2017 | TOR | AL | 0.256769885 | 0.09 | P | 1 | 1 | TOR | SDP | 2017 | 2017 | |
4591 | 4591 | Shawn Kelley | 33 | kellesh01 | 2017 | WSN | NL | 0.833349109 | -0.875 | P | 0 | 1 | WSN | SDP | 2016 | 2018 | OAK |
4651 | 4651 | Jace Peterson | 26 | peterja01 | 2016 | ATL | NL | 4.025859136 | 0.28173913 | 2B, LF, 3B, CF | 7 | 1 | ATL | SDP | 2015 | 2017 | NYY |
4652 | 4652 | Bud Norris | 31 | norribu01 | 2016 | ATL | NL | 1.89875543 | 1.066583851 | P | 6 | 1 | ATL | SDP | 2016 | 2016 | LAD |
4658 | 4658 | Matt Kemp | 31 | kempma01 | 2016 | ATL | NL | 2.378019735 | 0.19621118 | RF, LF | 4 | 2 | ATL | SDP | 2016 | 2017 | LAD |
4677 | 4677 | Casey Kelly | 26 | kellyca01 | 2016 | ATL | NL | 0.744740139 | -0.070434783 | P | 1 | 1 | ATL | SDP | 2016 | 2016 | SFG |
4712 | 4712 | Brad Brach | 30 | brachbr01 | 2016 | BAL | AL | 2.750172834 | 2.08 | P | 10 | 1 | BAL | SDP | 2014 | 2018 | ATL |
4734 | 4734 | Odrisamer Despaigne | 29 | despaod01 | 2016 | BAL | AL | 0.714709707 | -0.145 | P | 1 | 1 | BAL | SDP | 2016 | 2016 | FLA |
4760 | 4760 | Craig Kimbrel | 28 | kimbrcr01 | 2016 | BOS | AL | 2.187430906 | 1.01 | P | 6 | 1 | BOS | SDP | 2016 | 2018 | CHC |
4768 | 4768 | Drew Pomeranz | 27 | pomerdr01 | 2016 | BOS | AL | 1.973699449 | 0.54 | P | 4 | 2 | BOS | SDP | 2016 | 2018 | SFG |
4774 | 4774 | Tommy Layne | 31 | layneto01 | 2016 | BOS | AL | 0.671853778 | 0.335 | P | 2 | 1 | BOS | SDP | 2014 | 2016 | NYY |
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 );