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,498 rows where next_franch = "KCR"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
240 | 240 | Randy Rosario | 25 | rosarra01 | 2019 | CHC | NL | 0.295761913 | -0.117169811 | P | 0 | 1 | CHC | MIN | 2018 | 2019 | KCR |
249 | 249 | Mike Montgomery | 29 | montgmi01 | 2019 | CHC | NL | 0.923602972 | -0.387169811 | P | 0 | 1 | CHC | SEA | 2016 | 2019 | KCR |
795 | 795 | Jacob Barnes | 29 | barneja01 | 2019 | MIL | NL | 0.407123182 | -0.239433962 | P | 0 | 1 | MIL | 2016 | 2019 | KCR | |
1589 | 1589 | Chris Owings | 26 | owingch01 | 2018 | ARI | NL | 3.076738197 | -0.47 | RF, CF, 3B, 2B, LF | 3 | 1 | ARI | 2013 | 2018 | KCR | |
1591 | 1591 | Brad Boxberger | 30 | boxbebr01 | 2018 | ARI | NL | 2.155735716 | -0.485 | P | 2 | 1 | ARI | TBD | 2018 | 2018 | KCR |
1611 | 1611 | Jake Diekman | 31 | diekmja01 | 2018 | ARI | NL | 0.442302496 | -0.51 | P | 0 | 2 | ARI | TEX | 2018 | 2018 | KCR |
1645 | 1645 | Lucas Duda | 32 | dudalu01 | 2018 | ATL | NL | 0.215431369 | 0.075 | 1B | 1 | 2 | ATL | KCR | 2018 | 2018 | KCR |
1787 | 1787 | Mike Montgomery | 28 | montgmi01 | 2018 | CHC | NL | 3.146294915 | 1.316871166 | P | 9 | 1 | CHC | SEA | 2016 | 2019 | KCR |
1796 | 1796 | Randy Rosario | 24 | rosarra01 | 2018 | CHC | NL | 1.473384074 | 0.089447853 | P | 3 | 1 | CHC | MIN | 2018 | 2019 | KCR |
1806 | 1806 | Terrance Gore | 27 | gorete01 | 2018 | CHC | NL | 0.048013245 | 0.119263804 | LF | 0 | 1 | CHC | KCR | 2018 | 2018 | KCR |
1880 | 1880 | Billy Hamilton | 27 | hamilbi02 | 2018 | CIN | NL | 5.472255218 | 0.79 | CF, RF | 9 | 1 | CIN | 2013 | 2018 | KCR | |
1901 | 1901 | Homer Bailey | 32 | baileho02 | 2018 | CIN | NL | 2.996938977 | -0.81 | P | 1 | 1 | CIN | 2007 | 2018 | KCR | |
1911 | 1911 | Rosell Herrera | 25 | herrero02 | 2018 | CIN | NL | 0.127948413 | -0.15 | RF, 2B, CF, 3B, LF | 0 | 1 | CIN | 2018 | 2018 | KCR | |
2009 | 2009 | Jerry Vasto | 26 | vastoje01 | 2018 | COL | NL | 0.017058147 | -0.089447853 | P | 0 | 1 | COL | 2018 | 2018 | KCR | |
2092 | 2092 | Martin Maldonado | 31 | maldoma01 | 2018 | HOU | AL | 1.080215651 | 0.37 | C | 3 | 2 | HOU | ANA | 2018 | 2018 | KCR |
2349 | 2349 | Jacob Barnes | 28 | barneja01 | 2018 | MIL | NL | 1.317403712 | 0.069570552 | P | 2 | 1 | MIL | 2016 | 2019 | KCR | |
2352 | 2352 | Jorge Lopez | 25 | lopezjo02 | 2018 | MIL | NL | 0.407110656 | 0.223619632 | P | 1 | 1 | MIL | 2015 | 2018 | KCR | |
2357 | 2357 | Brett Phillips | 24 | phillbr02 | 2018 | MIL | NL | 0.235333897 | 0.059631902 | CF, RF, LF | 1 | 1 | MIL | 2017 | 2018 | KCR | |
2618 | 2618 | Ben Lively | 26 | livelbe01 | 2018 | PHI | NL | 0.654775897 | -0.095 | P | 1 | 1 | PHI | 2017 | 2018 | KCR | |
2664 | 2664 | Enny Romero | 27 | romeren01 | 2018 | PIT | NL | 0.078090256 | 0.050310559 | P | 0 | 2 | PIT | WSN | 2018 | 2018 | KCR |
3077 | 3077 | Brian Goodwin | 27 | goodwbr01 | 2018 | WSN | NL | 0.770472507 | -0.08 | CF, LF, RF | 1 | 1 | WSN | 2016 | 2018 | KCR | |
3111 | 3111 | Chris Owings | 25 | owingch01 | 2017 | ARI | NL | 3.811372148 | 0.55 | SS, RF, 2B, LF | 7 | 1 | ARI | 2013 | 2018 | KCR | |
3269 | 3269 | Blaine Boyer | 35 | boyerbl01 | 2017 | BOS | AL | 0.992497374 | 0.3 | P | 2 | 1 | BOS | MIL | 2017 | 2017 | KCR |
3299 | 3299 | Mike Montgomery | 27 | montgmi01 | 2017 | CHC | NL | 3.800072233 | 1.97 | P | 11 | 1 | CHC | SEA | 2016 | 2019 | KCR |
3302 | 3302 | Jon Jay | 32 | jayjo02 | 2017 | CHC | NL | 4.232934435 | 1.395 | LF, CF, RF, P | 10 | 1 | CHC | SDP | 2017 | 2017 | KCR |
3322 | 3322 | Justin Grimm | 28 | grimmju01 | 2017 | CHC | NL | 1.484145796 | -0.43 | P | 1 | 1 | CHC | TEX | 2013 | 2017 | KCR |
3349 | 3349 | Melky Cabrera | 32 | cabreme01 | 2017 | CHW | AL | 4.11061434 | 0.675 | LF, RF | 7 | 1 | CHW | TOR | 2015 | 2017 | KCR |
3395 | 3395 | Billy Hamilton | 26 | hamilbi02 | 2017 | CIN | NL | 6.238572642 | 1.06 | CF | 11 | 1 | CIN | 2013 | 2018 | KCR | |
3404 | 3404 | Homer Bailey | 31 | baileho02 | 2017 | CIN | NL | 2.726467608 | 0.285 | P | 4 | 1 | CIN | 2007 | 2018 | KCR | |
3465 | 3465 | Abraham Almonte | 28 | almonab01 | 2017 | CLE | AL | 1.82037663 | -0.065 | RF, LF, CF | 2 | 1 | CLE | SDP | 2015 | 2017 | KCR |
3710 | 3710 | Mike Morin | 26 | morinmi01 | 2017 | LAA | AL | 0.349946654 | -0.175 | P | 0 | 1 | ANA | 2014 | 2017 | KCR | |
3829 | 3829 | Brett Phillips | 23 | phillbr02 | 2017 | MIL | NL | 0.976800137 | 1.235 | CF, RF, LF | 5 | 1 | MIL | 2017 | 2018 | KCR | |
3831 | 3831 | Jacob Barnes | 27 | barneja01 | 2017 | MIL | NL | 2.473063463 | 0.54 | P | 5 | 1 | MIL | 2016 | 2019 | KCR | |
3847 | 3847 | Jorge Lopez | 24 | lopezjo02 | 2017 | MIL | NL | 0.029650927 | 0.005 | P | 0 | 1 | MIL | 2015 | 2018 | KCR | |
3860 | 3860 | Wily Peralta | 28 | peralwi01 | 2017 | MIL | NL | 1.540086767 | -0.645 | P | 0 | 1 | MIL | 2012 | 2017 | KCR | |
3861 | 3861 | Neftali Feliz | 29 | felizne01 | 2017 | MIL | NL | 0.959104741 | -0.87 | P | 0 | 1 | MIL | PIT | 2017 | 2017 | KCR |
4036 | 4036 | Jesse Hahn | 27 | hahnje01 | 2017 | OAK | AL | 1.942259694 | 0.565 | P | 4 | 1 | OAK | SDP | 2015 | 2017 | KCR |
4081 | 4081 | Ben Lively | 25 | livelbe01 | 2017 | PHI | NL | 2.510353645 | 1.42 | P | 7 | 1 | PHI | 2017 | 2018 | KCR | |
4182 | 4182 | Trevor Cahill | 29 | cahiltr01 | 2017 | SDP | NL | 1.727201389 | 1.33 | P | 7 | 1 | SDP | CHC | 2017 | 2017 | KCR |
4189 | 4189 | Ryan Buchter | 30 | buchtry01 | 2017 | SDP | NL | 1.317570856 | 0.315 | P | 3 | 1 | SDP | ATL | 2016 | 2017 | KCR |
4191 | 4191 | Brandon Maurer | 26 | maurebr01 | 2017 | SDP | NL | 1.596125675 | 0.04 | P | 3 | 1 | SDP | SEA | 2015 | 2017 | KCR |
4249 | 4249 | Sam Gaviglio | 27 | gavigsa01 | 2017 | SEA | AL | 1.678652501 | -0.095 | P | 2 | 1 | SEA | 2017 | 2017 | KCR | |
4406 | 4406 | Lucas Duda | 31 | dudalu01 | 2017 | TBR | AL | 1.894805619 | 0.02 | 1B | 3 | 2 | TBD | NYM | 2017 | 2017 | KCR |
4496 | 4496 | Ryan Goins | 29 | goinsry01 | 2017 | TOR | AL | 4.342903752 | -0.065 | SS, 2B, 3B | 6 | 1 | TOR | 2013 | 2017 | KCR | |
4532 | 4532 | Glenn Sparkman | 25 | sparkgl01 | 2017 | TOR | AL | 0.02462372 | -0.215 | P | 0 | 1 | TOR | 2017 | 2017 | KCR | |
4558 | 4558 | Brian Goodwin | 26 | goodwbr01 | 2017 | WSN | NL | 2.756239316 | 0.375 | CF, LF, RF | 5 | 1 | WSN | 2016 | 2018 | KCR | |
4598 | 4598 | Chris Owings | 24 | owingch01 | 2016 | ARI | NL | 4.560917989 | 1.245 | SS, CF, 2B | 10 | 1 | ARI | 2013 | 2018 | KCR | |
4809 | 4809 | Jason Hammel | 33 | hammeja01 | 2016 | CHC | NL | 4.632352941 | 1.725 | P | 11 | 1 | CHC | OAK | 2015 | 2016 | KCR |
4814 | 4814 | Jorge Soler | 24 | solerjo01 | 2016 | CHC | NL | 2.579949452 | 0.44 | LF, RF | 5 | 1 | CHC | 2014 | 2016 | KCR | |
4824 | 4824 | Justin Grimm | 27 | grimmju01 | 2016 | CHC | NL | 1.424473435 | 0.34 | P | 3 | 1 | CHC | TEX | 2013 | 2017 | KCR |
4825 | 4825 | Travis Wood | 29 | woodtr01 | 2016 | CHC | NL | 1.93243833 | 0.26 | P, LF | 3 | 1 | CHC | CIN | 2012 | 2016 | KCR |
4827 | 4827 | Mike Montgomery | 26 | montgmi01 | 2016 | CHC | NL | 1.01961575 | 0.22 | P | 2 | 2 | CHC | SEA | 2016 | 2019 | KCR |
4849 | 4849 | Melky Cabrera | 31 | cabreme01 | 2016 | CHW | AL | 6.13324603 | 2.355 | LF | 15 | 1 | CHW | TOR | 2015 | 2017 | KCR |
4896 | 4896 | Billy Hamilton | 25 | hamilbi02 | 2016 | CIN | NL | 4.626322178 | 2.84 | CF | 16 | 1 | CIN | 2013 | 2018 | KCR | |
4919 | 4919 | Homer Bailey | 30 | baileho02 | 2016 | CIN | NL | 0.655813164 | 0.05 | P | 1 | 1 | CIN | 2007 | 2018 | KCR | |
4966 | 4966 | Abraham Almonte | 27 | almonab01 | 2016 | CLE | AL | 1.835562806 | 0.508136646 | RF, LF, CF | 4 | 1 | CLE | SDP | 2015 | 2017 | KCR |
5192 | 5192 | Mike Morin | 25 | morinmi01 | 2016 | LAA | AL | 1.775292802 | 0.115 | P | 3 | 1 | ANA | 2014 | 2017 | KCR | |
5210 | 5210 | Al Alburquerque | 30 | albural01 | 2016 | LAA | AL | 0.036402966 | -0.105 | P | 0 | 1 | ANA | DET | 2016 | 2016 | KCR |
5217 | 5217 | Daniel Nava | 33 | navada01 | 2016 | LAA | AL | 1.310299003 | -0.44 | LF, 1B, RF | 0 | 1 | ANA | TBD | 2016 | 2016 | KCR |
5345 | 5345 | Wily Peralta | 27 | peralwi01 | 2016 | MIL | NL | 3.596515015 | 0.555 | P | 7 | 1 | MIL | 2012 | 2017 | KCR | |
5353 | 5353 | Jacob Barnes | 26 | barneja01 | 2016 | MIL | NL | 0.690971176 | 0.52 | P | 2 | 1 | MIL | 2016 | 2019 | KCR | |
5555 | 5555 | Billy Burns | 26 | burnsbi02 | 2016 | OAK | AL | 2.823607869 | -0.42 | CF, LF, RF | 3 | 1 | OAK | 2014 | 2016 | KCR | |
5563 | 5563 | Jesse Hahn | 26 | hahnje01 | 2016 | OAK | AL | 1.342182209 | -0.17 | P | 1 | 1 | OAK | SDP | 2015 | 2017 | KCR |
5695 | 5695 | Ryan Buchter | 29 | buchtry01 | 2016 | SDP | NL | 2.008709735 | 1.235 | P | 7 | 1 | SDP | ATL | 2016 | 2017 | KCR |
5700 | 5700 | Brandon Maurer | 25 | maurebr01 | 2016 | SDP | NL | 2.422243805 | 0.34 | P | 5 | 1 | SDP | SEA | 2015 | 2017 | KCR |
5756 | 5756 | Nate Karns | 28 | karnsna01 | 2016 | SEA | AL | 2.355817492 | 0.75 | P | 6 | 1 | SEA | TBD | 2016 | 2016 | KCR |
5853 | 5853 | Brandon Moss | 32 | mossbr01 | 2016 | STL | NL | 4.563676446 | 1.05 | 1B, LF, RF | 9 | 1 | STL | CLE | 2015 | 2016 | KCR |
5868 | 5868 | Seth Maness | 27 | manesse01 | 2016 | STL | NL | 0.756783102 | 0.18 | P | 2 | 1 | STL | 2013 | 2016 | KCR | |
6009 | 6009 | Ryan Goins | 28 | goinsry01 | 2016 | TOR | AL | 1.833548387 | -0.65 | 2B, SS, 3B, 1B, LF, P, RF | 1 | 1 | TOR | 2013 | 2017 | KCR | |
6072 | 6072 | Brian Goodwin | 25 | goodwbr01 | 2016 | WSN | NL | 0.437660779 | -0.12 | RF, LF, CF | 0 | 1 | WSN | 2016 | 2018 | KCR | |
6094 | 6094 | Chris Owings | 23 | owingch01 | 2015 | ARI | NL | 5.383554733 | -0.97 | 2B, SS | 4 | 1 | ARI | 2013 | 2018 | KCR | |
6147 | 6147 | Jonny Gomes | 34 | gomesjo01 | 2015 | ATL | NL | 2.31918625 | -0.345 | LF, RF, P | 2 | 1 | ATL | OAK | 2015 | 2015 | KCR |
6150 | 6150 | Peter Moylan | 36 | moylape01 | 2015 | ATL | NL | 0.382507433 | 0.15 | P | 1 | 1 | ATL | LAD | 2015 | 2015 | KCR |
6291 | 6291 | Jason Hammel | 32 | hammeja01 | 2015 | CHC | NL | 4.623643444 | 1.975 | P | 13 | 1 | CHC | OAK | 2015 | 2016 | KCR |
6297 | 6297 | Jorge Soler | 23 | solerjo01 | 2015 | CHC | NL | 4.02404259 | 0.14 | RF | 7 | 1 | CHC | 2014 | 2016 | KCR | |
6298 | 6298 | Travis Wood | 28 | woodtr01 | 2015 | CHC | NL | 2.741733715 | 0.66 | P | 6 | 1 | CHC | CIN | 2012 | 2016 | KCR |
6299 | 6299 | Justin Grimm | 26 | grimmju01 | 2015 | CHC | NL | 1.567425503 | 0.615 | P | 4 | 1 | CHC | TEX | 2013 | 2017 | KCR |
6338 | 6338 | Melky Cabrera | 30 | cabreme01 | 2015 | CHW | AL | 6.551017033 | 0.74 | LF | 12 | 1 | CHW | TOR | 2015 | 2017 | KCR |
6376 | 6376 | Johnny Cueto | 29 | cuetojo01 | 2015 | CIN | NL | 3.669897594 | 3.425 | P | 14 | 1 | CIN | 2008 | 2015 | KCR | |
6381 | 6381 | Billy Hamilton | 24 | hamilbi02 | 2015 | CIN | NL | 4.494282301 | 1.06 | CF | 8 | 1 | CIN | 2013 | 2018 | KCR | |
6408 | 6408 | Homer Bailey | 29 | baileho02 | 2015 | CIN | NL | 0.31661432 | -0.205 | P | 0 | 1 | CIN | 2007 | 2018 | KCR | |
6439 | 6439 | Abraham Almonte | 26 | almonab01 | 2015 | CLE | AL | 1.868200493 | 1.142049689 | CF, LF, RF | 6 | 2 | CLE | SDP | 2015 | 2017 | KCR |
6564 | 6564 | Joba Chamberlain | 29 | chambjo03 | 2015 | DET | AL | 0.789783465 | -0.41757764 | P | 0 | 1 | DET | NYY | 2014 | 2015 | KCR |
6691 | 6691 | Mike Morin | 24 | morinmi01 | 2015 | LAA | AL | 0.92054521 | -0.215 | P | 1 | 1 | ANA | 2014 | 2017 | KCR | |
6702 | 6702 | Drew Butera | 31 | buterdr01 | 2015 | LAA | AL | 0.204088472 | -0.06 | C, 1B | 0 | 1 | ANA | LAD | 2015 | 2015 | KCR |
6839 | 6839 | Wily Peralta | 26 | peralwi01 | 2015 | MIL | NL | 3.180986959 | -0.01 | P | 4 | 1 | MIL | 2012 | 2017 | KCR | |
6849 | 6849 | Jorge Lopez | 22 | lopezjo02 | 2015 | MIL | NL | 0.29428593 | 0.06 | P | 1 | 1 | MIL | 2015 | 2018 | KCR | |
6955 | 6955 | Dillon Gee | 29 | geedi01 | 2015 | NYM | NL | 1.034057347 | -0.355 | P | 0 | 1 | NYM | 2010 | 2015 | KCR | |
7019 | 7019 | Billy Burns | 25 | burnsbi02 | 2015 | OAK | AL | 5.234146341 | 2.455 | CF | 14 | 1 | OAK | 2014 | 2016 | KCR | |
7028 | 7028 | Jesse Hahn | 25 | hahnje01 | 2015 | OAK | AL | 2.720957382 | 1.215 | P | 7 | 1 | OAK | SDP | 2015 | 2017 | KCR |
7029 | 7029 | Ben Zobrist | 34 | zobribe01 | 2015 | OAK | AL | 2.555772358 | 1.155 | 2B, LF, 3B, RF | 7 | 1 | OAK | TBD | 2015 | 2015 | KCR |
7137 | 7137 | Joakim Soria | 31 | soriajo01 | 2015 | PIT | NL | 0.892884403 | 0.78 | P | 4 | 2 | PIT | DET | 2015 | 2015 | KCR |
7179 | 7179 | Ian Kennedy | 30 | kenneia01 | 2015 | SDP | NL | 4.817450957 | 0.06 | P | 7 | 1 | SDP | ARI | 2013 | 2015 | KCR |
7181 | 7181 | Brandon Maurer | 24 | maurebr01 | 2015 | SDP | NL | 1.787356692 | 0.615 | P | 4 | 1 | SDP | SEA | 2015 | 2017 | KCR |
7327 | 7327 | Brandon Moss | 31 | mossbr01 | 2015 | STL | NL | 1.513653647 | 0.415 | RF, 1B, LF | 4 | 2 | STL | CLE | 2015 | 2016 | KCR |
7335 | 7335 | Seth Maness | 26 | manesse01 | 2015 | STL | NL | 2.339511488 | -0.23 | P | 3 | 1 | STL | 2013 | 2016 | KCR | |
7354 | 7354 | Tony Cruz | 28 | cruzto03 | 2015 | STL | NL | 1.513653647 | -0.755 | C, 3B | 0 | 1 | STL | 2011 | 2015 | KCR | |
7471 | 7471 | Ryan Goins | 27 | goinsry01 | 2015 | TOR | AL | 3.999355566 | 1.92 | 2B, SS, 3B, LF, RF | 11 | 1 | TOR | 2013 | 2017 | KCR | |
7565 | 7565 | Chris Owings | 22 | owingch01 | 2014 | ARI | NL | 3.343055556 | 1.65 | SS, 2B | 9 | 1 | ARI | 2013 | 2018 | KCR | |
7623 | 7623 | Mike Minor | 26 | minormi01 | 2014 | ATL | NL | 3.923624815 | 0.47 | P | 7 | 1 | ATL | 2010 | 2014 | KCR |
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 );