mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
2,890 rows where next_franch = "CIN"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64 | 64 | Kevin Gausman | 28 | gausmke01 | 2019 | ATL | NL | 2.250572207 | -0.142641509 | P | 4 | 1 | ATL | BAL | 2018 | 2019 | CIN |
352 | 352 | Trevor Bauer | 28 | bauertr01 | 2019 | CLE | AL | 4.549457782 | 2.358679245 | P | 14 | 1 | CLE | ARI | 2013 | 2019 | CIN |
1231 | 1231 | R.J. Alaniz | 28 | alanirj01 | 2019 | SEA | AL | 0.078939737 | -0.305660377 | P | 0 | 1 | SEA | 2019 | 2019 | CIN | |
1458 | 1458 | Freddy Galvis | 29 | galvifr01 | 2019 | TOR | AL | 4.598390882 | 1.650566038 | SS, 2B | 11 | 1 | TOR | SDP | 2019 | 2019 | CIN |
1629 | 1629 | Kevin Gausman | 27 | gausmke01 | 2018 | ATL | NL | 1.649498591 | 0.95 | P | 5 | 2 | ATL | BAL | 2018 | 2019 | CIN |
1641 | 1641 | Preston Tucker | 27 | tuckepr01 | 2018 | ATL | NL | 1.390511565 | -0.045 | LF, RF | 2 | 1 | ATL | HOU | 2018 | 2018 | CIN |
1648 | 1648 | Matt Wisler | 25 | wislema01 | 2018 | ATL | NL | 0.713552404 | -0.165 | P | 1 | 1 | ATL | 2015 | 2018 | CIN | |
1668 | 1668 | Lucas Sims | 24 | simslu01 | 2018 | ATL | NL | 0.229144936 | -0.235 | P | 0 | 1 | ATL | 2017 | 2018 | CIN | |
1929 | 1929 | Trevor Bauer | 27 | bauertr01 | 2018 | CLE | AL | 4.977575604 | 5.755 | P | 23 | 1 | CLE | ARI | 2013 | 2019 | CIN |
2018 | 2018 | Jose Iglesias | 28 | iglesjo01 | 2018 | DET | AL | 4.477870216 | 2.335 | SS | 13 | 1 | DET | BOS | 2013 | 2018 | CIN |
2103 | 2103 | Tim Federowicz | 30 | federti01 | 2018 | HOU | AL | 0.331645156 | -0.25 | C | 0 | 1 | HOU | SFG | 2018 | 2018 | CIN |
2224 | 2224 | Yasiel Puig | 27 | puigya01 | 2018 | LAD | NL | 4.274190871 | 2.231226994 | RF | 12 | 1 | LAD | 2013 | 2018 | CIN | |
2228 | 2228 | Matt Kemp | 33 | kempma01 | 2018 | LAD | NL | 4.871037344 | 1.321840491 | LF, RF | 10 | 1 | LAD | ATL | 2018 | 2018 | CIN |
2229 | 2229 | Alex Wood | 27 | woodal02 | 2018 | LAD | NL | 4.195648743 | 1.480858896 | P | 9 | 1 | LAD | ATL | 2015 | 2018 | CIN |
2245 | 2245 | Kyle Farmer | 27 | farmeky01 | 2018 | LAD | NL | 0.741244813 | 0.193803681 | 3B, 1B, C | 1 | 1 | LAD | 2017 | 2018 | CIN | |
2272 | 2272 | Derek Dietrich | 28 | dietrde01 | 2018 | MIA | NL | 5.51 | 0.568509317 | LF, 1B, 2B, 3B, RF | 10 | 1 | FLA | 2013 | 2018 | CIN | |
2411 | 2411 | Juan Graterol | 29 | grateju01 | 2018 | MIN | AL | 0.075668624 | -0.02 | C | 0 | 2 | MIN | ANA | 2018 | 2018 | CIN |
2461 | 2461 | Matt Harvey | 29 | harvema01 | 2018 | NYM | NL | 0.642668983 | -0.165 | P | 0 | 1 | NYM | 2012 | 2018 | CIN | |
2495 | 2495 | Sonny Gray | 28 | grayso01 | 2018 | NYY | AL | 3.585931795 | 1.045 | P | 8 | 1 | NYY | OAK | 2017 | 2018 | CIN |
2660 | 2660 | Ryan Lavarnway | 30 | lavarry01 | 2018 | PIT | NL | 0.060511215 | 0.19621118 | 1 | 1 | PIT | OAK | 2018 | 2018 | CIN | |
2762 | 2762 | Zach Duke | 35 | dukeza01 | 2018 | SEA | AL | 0.474796641 | 0.035 | P | 1 | 2 | SEA | MIN | 2018 | 2018 | CIN |
2872 | 2872 | Matt Bowman | 27 | bowmama01 | 2018 | STL | NL | 0.741113577 | -0.36 | P | 0 | 1 | STL | 2016 | 2018 | CIN | |
3049 | 3049 | Tanner Roark | 31 | roarkta01 | 2018 | WSN | NL | 5.177611044 | 2.995 | P | 15 | 1 | WSN | 2013 | 2018 | CIN | |
3129 | 3129 | David Hernandez | 32 | hernada01 | 2017 | ARI | NL | 0.658567623 | 0.065 | P | 1 | 2 | ARI | ANA | 2017 | 2017 | CIN |
3168 | 3168 | Lucas Sims | 23 | simslu01 | 2017 | ATL | NL | 1.637465984 | -0.01 | P | 2 | 1 | ATL | 2017 | 2018 | CIN | |
3188 | 3188 | Matt Wisler | 24 | wislema01 | 2017 | ATL | NL | 0.651566737 | -0.435 | P | 0 | 1 | ATL | 2015 | 2018 | CIN | |
3334 | 3334 | Dylan Floro | 26 | florody01 | 2017 | CHC | NL | 0.157315034 | -0.115 | P | 0 | 1 | CHC | TBD | 2017 | 2017 | CIN |
3441 | 3441 | Trevor Bauer | 26 | bauertr01 | 2017 | CLE | AL | 5.063017046 | 2.97 | P | 15 | 1 | CLE | ARI | 2013 | 2019 | CIN |
3472 | 3472 | Kyle Crockett | 25 | crockky01 | 2017 | CLE | AL | 0.030800037 | -0.025 | P | 0 | 1 | CLE | 2014 | 2017 | CIN | |
3524 | 3524 | Jose Iglesias | 27 | iglesjo01 | 2017 | DET | AL | 4.628263708 | 1.57 | SS | 10 | 1 | DET | BOS | 2013 | 2018 | CIN |
3651 | 3651 | Luke Farrell | 26 | farrelu01 | 2017 | KCR | AL | 0.074460319 | -0.16 | P | 0 | 1 | KCR | 2017 | 2017 | CIN | |
3686 | 3686 | Cliff Pennington | 33 | pennicl01 | 2017 | LAA | AL | 2.079643093 | 0.335 | 2B, 3B, SS | 4 | 1 | ANA | TOR | 2016 | 2017 | CIN |
3722 | 3722 | Yasiel Puig | 26 | puigya01 | 2017 | LAD | NL | 5.637789905 | 3.35 | RF | 19 | 1 | LAD | 2013 | 2018 | CIN | |
3724 | 3724 | Alex Wood | 26 | woodal02 | 2017 | LAD | NL | 4.354449303 | 2.865 | P | 15 | 1 | LAD | ATL | 2015 | 2018 | CIN |
3755 | 3755 | Kyle Farmer | 26 | farmeky01 | 2017 | LAD | NL | 0.19781719 | -0.085 | 3B, C, 1B | 0 | 1 | LAD | 2017 | 2018 | CIN | |
3775 | 3775 | Derek Dietrich | 27 | dietrde01 | 2017 | MIA | NL | 4.538279933 | 1.555 | 3B, 1B, 2B, LF | 11 | 1 | FLA | 2013 | 2018 | CIN | |
3804 | 3804 | Christian Colon | 28 | colonch01 | 2017 | MIA | NL | 0.371669477 | -0.055 | 3B, 2B | 0 | 2 | FLA | KCR | 2017 | 2017 | CIN |
3830 | 3830 | Jared Hughes | 31 | hugheja02 | 2017 | MIL | NL | 1.795446814 | 0.85 | P | 5 | 1 | MIL | PIT | 2017 | 2017 | CIN |
3965 | 3965 | Matt Harvey | 28 | harvema01 | 2017 | NYM | NL | 2.636736008 | -1.17 | P | 0 | 1 | NYM | 2012 | 2018 | CIN | |
3986 | 3986 | Sonny Gray | 27 | grayso01 | 2017 | NYY | AL | 1.843575861 | 0.775 | P | 4 | 2 | NYY | OAK | 2017 | 2018 | CIN |
4010 | 4010 | Mason Williams | 25 | willima10 | 2017 | NYY | AL | 0.155790804 | -0.175 | CF, RF | 0 | 1 | NYY | 2015 | 2017 | CIN | |
4215 | 4215 | Kevin Quackenbush | 28 | quackke01 | 2017 | SDP | NL | 0.645940311 | -0.44 | P | 0 | 1 | SDP | 2014 | 2017 | CIN | |
4240 | 4240 | Yovani Gallardo | 31 | gallayo01 | 2017 | SEA | AL | 3.499551984 | -0.105 | P | 4 | 1 | SEA | BAL | 2017 | 2017 | CIN |
4352 | 4352 | Matt Bowman | 26 | bowmama01 | 2017 | STL | NL | 2.22548082 | 0.445 | P | 4 | 1 | STL | 2016 | 2018 | CIN | |
4413 | 4413 | Curt Casali | 28 | casalcu01 | 2017 | TBR | AL | 0.123162365 | 0.26 | C | 1 | 1 | TBD | 2014 | 2017 | CIN | |
4473 | 4473 | Phil Gosselin | 28 | gosseph01 | 2017 | TEX | AL | 0.076140466 | -0.135 | 2B, SS, 3B, 1B | 0 | 2 | TEX | PIT | 2017 | 2017 | CIN |
4552 | 4552 | Tanner Roark | 30 | roarkta01 | 2017 | WSN | NL | 5.00108851 | 1.815 | P | 13 | 1 | WSN | 2013 | 2018 | CIN | |
4650 | 4650 | Matt Wisler | 23 | wislema01 | 2016 | ATL | NL | 4.553020103 | 0.437701863 | P | 8 | 1 | ATL | 2015 | 2018 | CIN | |
4829 | 4829 | Jake Buchanan | 26 | buchaja01 | 2016 | CHC | NL | 0.132694497 | 0.16 | P | 1 | 1 | CHC | HOU | 2016 | 2016 | CIN |
4951 | 4951 | Trevor Bauer | 25 | bauertr01 | 2016 | CLE | AL | 5.272891638 | 2.379689441 | P | 15 | 1 | CLE | ARI | 2013 | 2019 | CIN |
4976 | 4976 | Kyle Crockett | 24 | crockky01 | 2016 | CLE | AL | 0.453791947 | 0.191180124 | P | 1 | 1 | CLE | 2014 | 2017 | CIN | |
5047 | 5047 | Jose Iglesias | 26 | iglesjo01 | 2016 | DET | AL | 4.874508519 | 1.977204969 | SS | 13 | 1 | DET | BOS | 2013 | 2018 | CIN |
5162 | 5162 | Tony Cruz | 29 | cruzto03 | 2016 | KCR | AL | 0.048084895 | -0.11 | C | 0 | 1 | KCR | STL | 2016 | 2016 | CIN |
5193 | 5193 | Cliff Pennington | 32 | pennicl01 | 2016 | LAA | AL | 1.811295681 | 0.11 | 2B, SS, 1B, 3B | 3 | 1 | ANA | TOR | 2016 | 2017 | CIN |
5232 | 5232 | Yasiel Puig | 25 | puigya01 | 2016 | LAD | NL | 3.651043449 | 1.135 | RF, LF, CF | 9 | 1 | LAD | 2013 | 2018 | CIN | |
5242 | 5242 | Alex Wood | 25 | woodal02 | 2016 | LAD | NL | 1.515085546 | 0.94 | P | 5 | 1 | LAD | ATL | 2015 | 2018 | CIN |
5283 | 5283 | Derek Dietrich | 26 | dietrde01 | 2016 | MIA | NL | 4.107959429 | 2.435031056 | 2B, 1B, 3B, LF | 13 | 1 | FLA | 2013 | 2018 | CIN | |
5322 | 5322 | Austin Brice | 24 | briceau01 | 2016 | MIA | NL | 0.321055579 | -0.19621118 | P | 0 | 1 | FLA | 2016 | 2016 | CIN | |
5341 | 5341 | Scooter Gennett | 26 | gennesc01 | 2016 | MIL | NL | 5.465229485 | 0.56 | 2B | 9 | 1 | MIL | 2013 | 2016 | CIN | |
5443 | 5443 | Matt Harvey | 27 | harvema01 | 2016 | NYM | NL | 2.576719958 | 0.88 | P | 6 | 1 | NYM | 2012 | 2018 | CIN | |
5520 | 5520 | Mason Williams | 24 | willima10 | 2016 | NYY | AL | 0.278522934 | -0.105 | RF, CF, LF | 0 | 1 | NYY | 2015 | 2017 | CIN | |
5571 | 5571 | Arismendy Alcantara | 24 | alcanar01 | 2016 | OAK | AL | 0.183727909 | -0.27 | CF, 2B, SS, RF | 0 | 1 | OAK | CHC | 2016 | 2016 | CIN |
5706 | 5706 | Kevin Quackenbush | 27 | quackke01 | 2016 | SDP | NL | 1.829955319 | 0.19 | P | 3 | 1 | SDP | 2014 | 2017 | CIN | |
5727 | 5727 | Patrick Kivlehan | 26 | kivlepa01 | 2016 | SDP | NL | 0.193639079 | -0.035 | RF, LF | 0 | 1 | SDP | 2016 | 2016 | CIN | |
5771 | 5771 | Drew Storen | 28 | storedr01 | 2016 | SEA | AL | 0.560186076 | 0.285 | P | 2 | 2 | SEA | TOR | 2016 | 2016 | CIN |
5860 | 5860 | Matt Bowman | 25 | bowmama01 | 2016 | STL | NL | 2.026524982 | 0.565 | P | 4 | 1 | STL | 2016 | 2018 | CIN | |
5898 | 5898 | Curt Casali | 27 | casalcu01 | 2016 | TBR | AL | 2.466035542 | 0.795 | C | 5 | 1 | TBD | 2014 | 2017 | CIN | |
6026 | 6026 | Scott Feldman | 33 | feldmsc01 | 2016 | TOR | AL | 0.351134685 | -0.275 | P | 0 | 2 | TOR | HOU | 2016 | 2016 | CIN |
6033 | 6033 | Tanner Roark | 29 | roarkta01 | 2016 | WSN | NL | 5.827106232 | 4.445 | P | 22 | 1 | WSN | 2013 | 2018 | CIN | |
6116 | 6116 | Jordan Pacheco | 29 | pachejo01 | 2015 | ARI | NL | 0.760719691 | -0.275 | C, 1B, 3B | 0 | 1 | ARI | COL | 2014 | 2015 | CIN |
6134 | 6134 | Matt Wisler | 22 | wislema01 | 2015 | ATL | NL | 2.981565907 | 0.4 | P | 6 | 1 | ATL | 2015 | 2018 | CIN | |
6430 | 6430 | Trevor Bauer | 24 | bauertr01 | 2015 | CLE | AL | 5.101607869 | 1.710559006 | P | 11 | 1 | CLE | ARI | 2013 | 2019 | CIN |
6451 | 6451 | Kyle Crockett | 23 | crockky01 | 2015 | CLE | AL | 0.453963714 | 0.11068323 | P | 1 | 1 | CLE | 2014 | 2017 | CIN | |
6466 | 6466 | Tyler Holt | 26 | holtty01 | 2015 | CLE | AL | 0.200164339 | -0.321987578 | CF, LF, RF | 0 | 1 | CLE | 2014 | 2015 | CIN | |
6529 | 6529 | Jose Iglesias | 25 | iglesjo01 | 2015 | DET | AL | 4.29419439 | 1.504285714 | SS | 10 | 1 | DET | BOS | 2013 | 2018 | CIN |
6533 | 6533 | Alfredo Simon | 34 | simonal01 | 2015 | DET | AL | 5.325206653 | 0.357204969 | P | 9 | 1 | DET | CIN | 2015 | 2015 | CIN |
6603 | 6603 | Dan Straily | 26 | straida01 | 2015 | HOU | AL | 0.423186671 | 0.005 | P | 1 | 1 | HOU | CHC | 2015 | 2015 | CIN |
6611 | 6611 | Asher Wojciechowski | 26 | wojcias01 | 2015 | HOU | AL | 0.387729137 | -0.14 | P | 0 | 1 | HOU | 2015 | 2015 | CIN | |
6646 | 6646 | Brandon Finnegan | 22 | finnebr01 | 2015 | KCR | AL | 0.644124528 | 0.16 | P | 2 | 1 | KCR | 2014 | 2015 | CIN | |
6697 | 6697 | Ryan Mattheus | 31 | matthry01 | 2015 | LAA | AL | 0.018716355 | 0.02 | P | 0 | 1 | ANA | WSN | 2015 | 2015 | CIN |
6721 | 6721 | Yasiel Puig | 24 | puigya01 | 2015 | LAD | NL | 3.140867143 | 1.305 | RF | 8 | 1 | LAD | 2013 | 2018 | CIN | |
6734 | 6734 | Alex Wood | 24 | woodal02 | 2015 | LAD | NL | 1.931435196 | 0.49 | P | 4 | 2 | LAD | ATL | 2015 | 2018 | CIN |
6739 | 6739 | Scott Schebler | 24 | schebsc01 | 2015 | LAD | NL | 0.40397005 | 0.435 | LF, RF | 2 | 1 | LAD | 2015 | 2015 | CIN | |
6756 | 6756 | Jose Peraza | 21 | perazjo01 | 2015 | LAD | NL | 0.252481282 | -0.145 | 2B, CF | 0 | 1 | LAD | 2015 | 2015 | CIN | |
6784 | 6784 | Derek Dietrich | 25 | dietrde01 | 2015 | MIA | NL | 2.956261023 | 0.445 | LF, 3B, 1B, 2B | 5 | 1 | FLA | 2013 | 2018 | CIN | |
6831 | 6831 | Scooter Gennett | 25 | gennesc01 | 2015 | MIL | NL | 3.970933287 | 0.425 | 2B | 7 | 1 | MIL | 2013 | 2016 | CIN | |
6913 | 6913 | Matt Harvey | 26 | harvema01 | 2015 | NYM | NL | 5.185224963 | 4.25 | P | 20 | 1 | NYM | 2012 | 2018 | CIN | |
6940 | 6940 | Dilson Herrera | 21 | herredi01 | 2015 | NYM | NL | 1.031244606 | 0.225 | 2B | 2 | 1 | NYM | 2014 | 2015 | CIN | |
6988 | 6988 | Mason Williams | 23 | willima10 | 2015 | NYY | AL | 0.20442166 | 0.16 | CF | 1 | 1 | NYY | 2015 | 2017 | CIN | |
7008 | 7008 | Caleb Cotham | 27 | cothaca01 | 2015 | NYY | AL | 0.227320674 | -0.135 | P | 0 | 1 | NYY | 2015 | 2015 | CIN | |
7189 | 7189 | Kevin Quackenbush | 26 | quackke01 | 2015 | SDP | NL | 1.356956589 | 0.125 | P | 2 | 1 | SDP | 2014 | 2017 | CIN | |
7247 | 7247 | JC Ramirez | 26 | ramirjc01 | 2015 | SEA | AL | 0.24465593 | -0.275 | P | 0 | 2 | SEA | ARI | 2015 | 2015 | CIN |
7368 | 7368 | Curt Casali | 26 | casalcu01 | 2015 | TBR | AL | 1.083126756 | 1.1 | C | 5 | 1 | TBD | 2014 | 2017 | CIN | |
7440 | 7440 | Ross Ohlendorf | 32 | ohlenro01 | 2015 | TEX | AL | 0.579224681 | 0.075 | P | 1 | 1 | TEX | WSN | 2015 | 2015 | CIN |
7512 | 7512 | Steve Delabar | 31 | delabst01 | 2015 | TOR | AL | 0.868932521 | -0.31 | P | 0 | 1 | TOR | SEA | 2012 | 2015 | CIN |
7533 | 7533 | Tanner Roark | 28 | roarkta01 | 2015 | WSN | NL | 3.262510124 | 0.275 | P | 5 | 1 | WSN | 2013 | 2018 | CIN | |
7552 | 7552 | Abel De Los Santos | 22 | delosab01 | 2015 | WSN | NL | 0.026606956 | -0.05 | P | 0 | 1 | WSN | 2015 | 2015 | CIN | |
7572 | 7572 | Bronson Arroyo | 37 | arroybr01 | 2014 | ARI | NL | 2.404983821 | 0.585 | P | 5 | 1 | ARI | CIN | 2014 | 2014 | CIN |
7606 | 7606 | Jordan Pacheco | 28 | pachejo01 | 2014 | ARI | NL | 0.855902778 | -0.33 | C, 1B, 3B, 2B | 0 | 2 | ARI | COL | 2014 | 2015 | CIN |
7705 | 7705 | Burke Badenhop | 31 | badenbu01 | 2014 | BOS | AL | 2.232999992 | 1.13 | P | 6 | 1 | BOS | MIL | 2014 | 2014 | CIN |
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 );