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,002 rows where prev_franch = "KCR"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25 | 25 | Abraham Almonte | 30 | almonab01 | 2019 | ARI | NL | 0.37463879 | 0.504339623 | RF, CF | 2 | 1 | ARI | KCR | 2019 | 2019 | |
86 | 86 | Billy Hamilton | 28 | hamilbi02 | 2019 | ATL | NL | 0.416552668 | -0.101886792 | CF | 0 | 2 | ATL | KCR | 2019 | 2019 | |
118 | 118 | Nate Karns | 31 | karnsna01 | 2019 | BAL | AL | 0.127194632 | 0.193584906 | P | 1 | 1 | BAL | KCR | 2019 | 2019 | |
190 | 190 | Chris Owings | 27 | owingch01 | 2019 | BOS | AL | 0.44812362 | -0.152830189 | 2B, 3B, CF, SS, RF, LF, P | 0 | 2 | BOS | KCR | 2019 | 2019 | |
221 | 221 | Alec Mills | 27 | millsal02 | 2019 | CHC | NL | 0.710069702 | 0.509433962 | P | 2 | 1 | CHC | KCR | 2018 | 2019 | |
222 | 222 | Ben Zobrist | 38 | zobribe01 | 2019 | CHC | NL | 1.69874477 | 0.091698113 | 2B, RF, LF | 2 | 1 | CHC | KCR | 2016 | 2019 | |
246 | 246 | Martin Maldonado | 32 | maldoma01 | 2019 | CHC | NL | 0.131450488 | -0.244528302 | C, 1B | 0 | 2 | CHC | KCR | 2019 | 2019 | HOU |
270 | 270 | Ryan Goins | 31 | goinsry01 | 2019 | CHW | AL | 1.588235294 | 0.22556962 | 3B, SS, RF, 1B, LF | 3 | 1 | CHW | KCR | 2019 | 2019 | |
441 | 441 | Drew Butera | 35 | buterdr01 | 2019 | COL | NL | 0.456458512 | -0.40245283 | C, 1B | 0 | 1 | COL | KCR | 2018 | 2019 | |
603 | 603 | Brian Goodwin | 28 | goodwbr01 | 2019 | LAA | AL | 4.248980258 | 2.073396226 | LF, CF, RF | 12 | 1 | ANA | KCR | 2019 | 2019 | |
689 | 689 | Scott Alexander | 29 | alexasc02 | 2019 | LAD | NL | 0.595351205 | 0.010188679 | P | 1 | 1 | LAD | KCR | 2018 | 2019 | |
747 | 747 | Rosell Herrera | 26 | herrero02 | 2019 | MIA | NL | 1.225932504 | -0.774339623 | CF, RF, LF, 2B, 3B, SS | 0 | 1 | FLA | KCR | 2019 | 2019 | |
754 | 754 | Mike Moustakas | 30 | moustmi01 | 2019 | MIL | NL | 5.689561374 | 3.036226415 | 3B, 2B | 18 | 1 | MIL | KCR | 2018 | 2019 | |
756 | 756 | Lorenzo Cain | 33 | cainlo01 | 2019 | MIL | NL | 6.074124447 | 2.02754717 | CF | 16 | 1 | MIL | KCR | 2018 | 2019 | |
769 | 769 | Manny Pina | 32 | pinama01 | 2019 | MIL | NL | 1.725603536 | 0.840566038 | C, 3B | 5 | 1 | MIL | KCR | 2016 | 2019 | |
796 | 796 | Burch Smith | 29 | smithbu03 | 2019 | MIL | NL | 0.269653652 | -0.249622642 | P | 0 | 1 | MIL | KCR | 2019 | 2019 | SFG |
864 | 864 | Jason Vargas | 36 | vargaja01 | 2019 | NYM | NL | 2.565052544 | 1.21245283 | P | 7 | 1 | NYM | KCR | 2018 | 2019 | PHI |
973 | 973 | Homer Bailey | 33 | baileho02 | 2019 | OAK | AL | 2.022873073 | 1.365283019 | P | 7 | 2 | OAK | KCR | 2019 | 2019 | |
982 | 982 | Ryan Buchter | 32 | buchtry01 | 2019 | OAK | AL | 1.413859159 | 0.371886792 | P | 3 | 1 | OAK | KCR | 2018 | 2019 | |
993 | 993 | Jake Diekman | 32 | diekmja01 | 2019 | OAK | AL | 0.660710647 | 0.040754717 | P | 1 | 2 | OAK | KCR | 2019 | 2019 | |
995 | 995 | Aaron Brooks | 29 | brookaa01 | 2019 | OAK | AL | 1.063475631 | -0.076415094 | P | 1 | 1 | OAK | KCR | 2015 | 2019 | BAL |
1126 | 1126 | Matt Strahm | 27 | strahma01 | 2019 | SDP | NL | 3.431653904 | 1.304150943 | P | 9 | 1 | SDP | KCR | 2018 | 2019 | |
1127 | 1127 | Eric Hosmer | 29 | hosmeer01 | 2019 | SDP | NL | 6.745383523 | -0.249622642 | 1B | 9 | 1 | SDP | KCR | 2018 | 2019 | |
1264 | 1264 | Johnny Cueto | 33 | cuetojo01 | 2019 | SFG | NL | 0.381410697 | 0.351509434 | P | 2 | 1 | SFG | KCR | 2016 | 2019 | |
1403 | 1403 | Mike Minor | 31 | minormi01 | 2019 | TEX | AL | 6.131699208 | 5.924716981 | P | 27 | 1 | TEX | KCR | 2018 | 2019 | |
1471 | 1471 | Sam Gaviglio | 29 | gavigsa01 | 2019 | TOR | AL | 2.279077871 | 0.54 | P | 5 | 1 | TOR | KCR | 2018 | 2019 | |
1481 | 1481 | Jason Adam | 27 | adamja01 | 2019 | TOR | AL | 0.671101017 | 0.346415094 | P | 2 | 1 | TOR | KCR | 2019 | 2019 | |
1586 | 1586 | Jon Jay | 33 | jayjo02 | 2018 | ARI | NL | 3.186266094 | -0.17 | RF, LF, CF | 4 | 2 | ARI | KCR | 2018 | 2018 | CHW |
1605 | 1605 | Kris Medlen | 32 | medlekr01 | 2018 | ARI | NL | 0.108366285 | -0.1 | P | 0 | 1 | ARI | KCR | 2018 | 2018 | |
1642 | 1642 | Lane Adams | 28 | adamsla01 | 2018 | ATL | NL | 0.283977714 | 0.295 | RF, CF, LF | 1 | 1 | ATL | KCR | 2017 | 2018 | |
1645 | 1645 | Lucas Duda | 32 | dudalu01 | 2018 | ATL | NL | 0.215431369 | 0.075 | 1B | 1 | 2 | ATL | KCR | 2018 | 2018 | KCR |
1666 | 1666 | Peter Moylan | 39 | moylape01 | 2018 | ATL | NL | 0.766526771 | -0.22 | P | 0 | 1 | ATL | KCR | 2018 | 2018 | |
1773 | 1773 | Ben Zobrist | 37 | zobribe01 | 2018 | CHC | NL | 4.993377483 | 3.41392638 | 2B, RF, LF, 1B | 18 | 1 | CHC | KCR | 2016 | 2019 | |
1799 | 1799 | Alec Mills | 26 | millsal02 | 2018 | CHC | NL | 0.384060193 | 0.332944785 | P | 2 | 1 | CHC | KCR | 2018 | 2019 | |
1806 | 1806 | Terrance Gore | 27 | gorete01 | 2018 | CHC | NL | 0.048013245 | 0.119263804 | LF | 0 | 1 | CHC | KCR | 2018 | 2018 | KCR |
1834 | 1834 | Joakim Soria | 34 | soriajo01 | 2018 | CHW | AL | 1.366142127 | 1.215 | P | 5 | 1 | CHW | KCR | 2018 | 2018 | MIL |
1917 | 1917 | Tony Cruz | 31 | cruzto03 | 2018 | CIN | NL | 0.255896827 | -0.29 | C | 0 | 1 | CIN | KCR | 2018 | 2018 | |
1924 | 1924 | Brandon Finnegan | 25 | finnebr01 | 2018 | CIN | NL | 0.582477168 | -0.53 | P | 0 | 1 | CIN | KCR | 2015 | 2018 | |
1941 | 1941 | Melky Cabrera | 33 | cabreme01 | 2018 | CLE | AL | 2.56997131 | 0.185 | RF, LF | 4 | 1 | CLE | KCR | 2018 | 2018 | PIT |
2006 | 2006 | Drew Butera | 34 | buterdr01 | 2018 | COL | NL | 0.158822523 | 0.00993865 | C, 1B, P | 0 | 2 | COL | KCR | 2018 | 2019 | |
2200 | 2200 | Miguel Almonte | 25 | almonmi01 | 2018 | LAA | AL | 0.14172143 | -0.125 | P | 0 | 1 | ANA | KCR | 2018 | 2018 | |
2238 | 2238 | Scott Alexander | 28 | alexasc02 | 2018 | LAD | NL | 2.187154805 | 0.228588957 | P | 3 | 1 | LAD | KCR | 2018 | 2019 | |
2319 | 2319 | Lorenzo Cain | 32 | cainlo01 | 2018 | MIL | NL | 6.079459003 | 6.261349693 | CF | 28 | 1 | MIL | KCR | 2018 | 2019 | |
2326 | 2326 | Manny Pina | 31 | pinama01 | 2018 | MIL | NL | 3.304480135 | 1.13797546 | C, 1B | 9 | 1 | MIL | KCR | 2016 | 2019 | |
2338 | 2338 | Mike Moustakas | 29 | moustmi01 | 2018 | MIL | NL | 2.13761623 | 0.546625767 | 3B, 1B | 5 | 2 | MIL | KCR | 2018 | 2019 | |
2445 | 2445 | Jason Vargas | 35 | vargaja01 | 2018 | NYM | NL | 2.514255062 | 0.02 | P | 3 | 1 | NYM | KCR | 2018 | 2019 | PHI |
2541 | 2541 | Trevor Cahill | 30 | cahiltr01 | 2018 | OAK | AL | 3.014645074 | 1.65 | P | 9 | 1 | OAK | KCR | 2018 | 2018 | ANA |
2554 | 2554 | Ryan Buchter | 31 | buchtry01 | 2018 | OAK | AL | 1.233605857 | 0.49 | P | 3 | 1 | OAK | KCR | 2018 | 2019 | |
2570 | 2570 | Aaron Brooks | 28 | brookaa01 | 2018 | OAK | AL | 0.039472261 | 0.04 | P | 0 | 1 | OAK | KCR | 2015 | 2019 | BAL |
2681 | 2681 | Eric Hosmer | 28 | hosmeer01 | 2018 | SDP | NL | 6.809920222 | 0.67 | 1B | 12 | 1 | SDP | KCR | 2018 | 2019 | |
2693 | 2693 | Matt Strahm | 26 | strahma01 | 2018 | SDP | NL | 1.870653567 | 1.08 | P | 6 | 1 | SDP | KCR | 2018 | 2019 | |
2768 | 2768 | Justin Grimm | 29 | grimmju01 | 2018 | SEA | AL | 0.079693765 | 0.06 | P | 0 | 2 | SEA | KCR | 2018 | 2018 | |
2770 | 2770 | Mike Morin | 27 | morinmi01 | 2018 | SEA | AL | 0.092068573 | 0.025 | P | 0 | 1 | SEA | KCR | 2018 | 2018 | MIN |
2800 | 2800 | Johnny Cueto | 32 | cuetojo01 | 2018 | SFG | NL | 1.428467172 | 0.635 | P | 4 | 1 | SFG | KCR | 2016 | 2019 | |
2932 | 2932 | Mike Minor | 30 | minormi01 | 2018 | TEX | AL | 4.479145135 | 3.185 | P | 15 | 1 | TEX | KCR | 2018 | 2019 | |
2990 | 2990 | Sam Gaviglio | 28 | gavigsa01 | 2018 | TOR | AL | 3.665709403 | 0.76 | P | 8 | 1 | TOR | KCR | 2018 | 2019 | |
2991 | 2991 | Kendrys Morales | 35 | moralke01 | 2018 | TOR | AL | 4.513879709 | 0.525 | 1B, 3B, P | 8 | 1 | TOR | KCR | 2017 | 2018 | OAK |
3075 | 3075 | Tim Collins | 28 | colliti01 | 2018 | WSN | NL | 0.65417983 | -0.01 | P | 1 | 1 | WSN | KCR | 2018 | 2018 | CHC |
3076 | 3076 | Kelvin Herrera | 28 | herreke01 | 2018 | WSN | NL | 0.58618979 | -0.06 | P | 1 | 2 | WSN | KCR | 2018 | 2018 | CHW |
3125 | 3125 | Rey Fuentes | 26 | fuentre01 | 2017 | ARI | NL | 1.431733061 | -0.085 | CF, LF, RF | 2 | 1 | ARI | KCR | 2017 | 2017 | |
3162 | 3162 | Lane Adams | 27 | adamsla01 | 2017 | ATL | NL | 1.200542925 | 0.57 | LF, CF, RF | 3 | 1 | ATL | KCR | 2017 | 2018 | |
3219 | 3219 | Francisco Pena | 27 | penafr01 | 2017 | BAL | AL | 0.094740281 | 0.315 | C | 1 | 1 | BAL | KCR | 2016 | 2017 | STL |
3306 | 3306 | Wade Davis | 31 | daviswa01 | 2017 | CHC | NL | 2.31612735 | 1.49 | P | 8 | 1 | CHC | KCR | 2017 | 2017 | COL |
3308 | 3308 | Ben Zobrist | 36 | zobribe01 | 2017 | CHC | NL | 4.848811731 | 0.415 | 2B, LF, RF, 1B, SS | 8 | 1 | CHC | KCR | 2016 | 2019 | |
3368 | 3368 | Al Alburquerque | 31 | albural01 | 2017 | CHW | AL | 0.233283087 | 0.265 | P | 1 | 2 | CHW | KCR | 2017 | 2017 | |
3415 | 3415 | Luke Farrell | 26 | farrelu01 | 2017 | CIN | NL | 0.227258757 | 0.105 | P | 1 | 2 | CIN | KCR | 2017 | 2017 | CHC |
3417 | 3417 | Brandon Finnegan | 24 | finnebr01 | 2017 | CIN | NL | 0.385351805 | 0.025 | P | 1 | 1 | CIN | KCR | 2015 | 2018 | |
3489 | 3489 | Greg Holland | 31 | hollagr01 | 2017 | COL | NL | 2.474188177 | 1.28 | P | 8 | 1 | COL | KCR | 2017 | 2017 | STL |
3713 | 3713 | Brooks Pounders | 26 | poundbr01 | 2017 | LAA | AL | 0.20613704 | -0.3 | P | 0 | 1 | ANA | KCR | 2017 | 2017 | COL |
3779 | 3779 | Edinson Volquez | 33 | volqued01 | 2017 | MIA | NL | 2.632935812 | 0.865 | P | 6 | 1 | FLA | KCR | 2017 | 2017 | TEX |
3804 | 3804 | Christian Colon | 28 | colonch01 | 2017 | MIA | NL | 0.371669477 | -0.055 | 3B, 2B | 0 | 2 | FLA | KCR | 2017 | 2017 | CIN |
3820 | 3820 | Manny Pina | 30 | pinama01 | 2017 | MIL | NL | 3.578278055 | 2.15 | C | 12 | 1 | MIL | KCR | 2016 | 2019 | |
4028 | 4028 | Ryan Madson | 36 | madsory01 | 2017 | OAK | AL | 1.397846926 | 1.245 | P | 6 | 1 | OAK | KCR | 2016 | 2017 | WSN |
4082 | 4082 | Daniel Nava | 34 | navada01 | 2017 | PHI | NL | 2.130084091 | 1.085 | LF, RF, 1B | 6 | 1 | PHI | KCR | 2017 | 2017 | |
4194 | 4194 | Dusty Coleman | 30 | colemdu01 | 2017 | SDP | NL | 0.729236763 | 0.23 | SS | 2 | 1 | SDP | KCR | 2017 | 2017 | |
4201 | 4201 | Travis Wood | 30 | woodtr01 | 2017 | SDP | NL | 1.481806656 | -0.59 | P | 1 | 2 | SDP | KCR | 2017 | 2017 | |
4228 | 4228 | Jarrod Dyson | 32 | dysonja01 | 2017 | SEA | AL | 3.684639192 | 2.405 | CF, LF | 12 | 1 | SEA | KCR | 2017 | 2017 | ARI |
4289 | 4289 | Johnny Cueto | 31 | cuetojo01 | 2017 | SFG | NL | 4.128622567 | 1.425 | P | 10 | 1 | SFG | KCR | 2016 | 2019 | |
4329 | 4329 | Orlando Calixte | 25 | calixor01 | 2017 | SFG | NL | 0.548204159 | -0.74 | LF, 3B, SS, RF, CF | 0 | 1 | SFG | KCR | 2017 | 2017 | |
4395 | 4395 | Jake Odorizzi | 27 | odorija01 | 2017 | TBR | AL | 3.912686846 | 0.11 | P | 5 | 1 | TBD | KCR | 2013 | 2017 | MIN |
4422 | 4422 | Justin Marks | 29 | marksju01 | 2017 | TBR | AL | 0.022188598 | -0.06 | P | 0 | 1 | TBD | KCR | 2016 | 2017 | |
4472 | 4472 | Dillon Gee | 31 | geedi01 | 2017 | TEX | AL | 0.302962382 | -0.11 | P | 0 | 1 | TEX | KCR | 2017 | 2017 | MIN |
4493 | 4493 | Kendrys Morales | 34 | moralke01 | 2017 | TOR | AL | 5.75269168 | -0.235 | 1B | 8 | 1 | TOR | KCR | 2017 | 2018 | OAK |
4584 | 4584 | Jeremy Guthrie | 38 | guthrje01 | 2017 | WSN | NL | 0.018585126 | -0.26 | P | 0 | 1 | WSN | KCR | 2017 | 2017 | |
4743 | 4743 | Francisco Pena | 26 | penafr01 | 2016 | BAL | AL | 0.411483254 | -0.195 | C | 0 | 1 | BAL | KCR | 2016 | 2017 | STL |
4805 | 4805 | Ben Zobrist | 35 | zobribe01 | 2016 | CHC | NL | 6.166470093 | 3.84 | 2B, LF, RF, 1B, SS | 20 | 1 | CHC | KCR | 2016 | 2019 | |
4901 | 4901 | Brandon Finnegan | 23 | finnebr01 | 2016 | CIN | NL | 4.878254998 | 1.35 | P | 12 | 1 | CIN | KCR | 2015 | 2018 | |
4970 | 4970 | Joba Chamberlain | 30 | chambjo03 | 2016 | CLE | AL | 0.484898653 | 0.266645963 | P | 2 | 1 | CLE | KCR | 2016 | 2016 | |
5008 | 5008 | Jorge De La Rosa | 35 | rosajo01 | 2016 | COL | NL | 3.812826607 | 0.245 | P | 6 | 1 | COL | KCR | 2008 | 2016 | ARI |
5181 | 5181 | Johnny Giavotella | 28 | giavojo01 | 2016 | LAA | AL | 3.535880399 | 0.305 | 2B | 6 | 1 | ANA | KCR | 2015 | 2016 | BAL |
5258 | 5258 | Louis Coleman | 30 | colemlo01 | 2016 | LAD | NL | 1.4764023 | -0.23 | P | 1 | 1 | LAD | KCR | 2016 | 2016 | DET |
5357 | 5357 | Manny Pina | 29 | pinama01 | 2016 | MIL | NL | 0.816759388 | 0.19 | C | 2 | 1 | MIL | KCR | 2016 | 2019 | |
5360 | 5360 | Will Smith | 26 | smithwi04 | 2016 | MIL | NL | 0.848448328 | -0.04 | P | 1 | 1 | MIL | KCR | 2014 | 2016 | SFG |
5539 | 5539 | Ryan Madson | 35 | madsory01 | 2016 | OAK | AL | 2.819856408 | 0.9 | P | 7 | 1 | OAK | KCR | 2016 | 2017 | WSN |
5543 | 5543 | Coco Crisp | 36 | crispco01 | 2016 | OAK | AL | 4.196732244 | 0.115 | LF, CF | 6 | 1 | OAK | KCR | 2010 | 2016 | CLE |
5553 | 5553 | Billy Butler | 30 | butlebi03 | 2016 | OAK | AL | 2.340113371 | -0.25 | 1B | 3 | 1 | OAK | KCR | 2015 | 2016 | NYY |
5576 | 5576 | Brett Eibner | 27 | eibnebr01 | 2016 | OAK | AL | 1.189396465 | -0.6 | CF, RF, LF | 0 | 2 | OAK | KCR | 2016 | 2016 | LAD |
5620 | 5620 | Michael Mariot | 27 | mariomi01 | 2016 | PHI | NL | 0.700956344 | -0.28 | P | 0 | 1 | PHI | KCR | 2016 | 2016 | |
5699 | 5699 | James Shields | 34 | shielja02 | 2016 | SDP | NL | 1.911741031 | 0.615 | P | 5 | 1 | SDP | KCR | 2015 | 2016 | CHW |
5799 | 5799 | Johnny Cueto | 30 | cuetojo01 | 2016 | SFG | NL | 5.851135796 | 4.95 | P | 22 | 1 | SFG | KCR | 2016 | 2019 |
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 );