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,378 rows where prev_franch = "TEX"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
56 | 56 | Luke Jackson | 27 | jackslu01 | 2019 | ATL | NL | 2.794560783 | 0.94245283 | P | 8 | 1 | ATL | TEX | 2017 | 2019 | |
73 | 73 | Chris Martin | 33 | martich02 | 2019 | ATL | NL | 0.531953431 | 0.259811321 | P | 2 | 2 | ATL | TEX | 2019 | 2019 | |
98 | 98 | Hanser Alberto | 26 | alberha01 | 2019 | BAL | AL | 5.196033058 | 2.465660377 | 2B, 3B, LF, P, RF | 13 | 1 | BAL | TEX | 2019 | 2019 | |
100 | 100 | Andrew Cashner | 32 | cashnan01 | 2019 | BAL | AL | 2.823014192 | 2.29245283 | P | 10 | 1 | BAL | TEX | 2018 | 2019 | BOS |
101 | 101 | Renato Nunez | 25 | nunezre01 | 2019 | BAL | AL | 5.608264463 | 0.825283019 | 1B, 3B, LF | 9 | 1 | BAL | TEX | 2018 | 2019 | |
152 | 152 | Chris Davis | 33 | davisch02 | 2019 | BAL | AL | 3.32661157 | -1.21754717 | 1B, P, RF | 0 | 1 | BAL | TEX | 2011 | 2019 | |
167 | 167 | Mitch Moreland | 33 | morelmi01 | 2019 | BOS | AL | 2.990539262 | 1.136037736 | 1B | 7 | 1 | BOS | TEX | 2017 | 2019 | |
186 | 186 | Juan Centeno | 29 | centeju01 | 2019 | BOS | AL | 0.1371807 | -0.00509434 | C | 0 | 1 | BOS | TEX | 2019 | 2019 | |
209 | 209 | Cole Hamels | 35 | hamelco01 | 2019 | CHC | NL | 3.900159305 | 2.384150943 | P | 12 | 1 | CHC | TEX | 2018 | 2019 | |
237 | 237 | Tony Barnette | 35 | barneto01 | 2019 | CHC | NL | 0.031746184 | -0.061132075 | P | 0 | 1 | CHC | TEX | 2019 | 2019 | |
258 | 258 | Leury Garcia | 28 | garcile02 | 2019 | CHW | AL | 5.970588235 | 1.384177215 | CF, RF, LF, SS, 2B, 3B | 13 | 1 | CHW | TEX | 2013 | 2019 | |
416 | 416 | Ian Desmond | 33 | desmoia01 | 2019 | COL | NL | 4.743199316 | -1.034150943 | CF, LF, P | 4 | 1 | COL | TEX | 2017 | 2019 | |
417 | 417 | Chi Chi Gonzalez | 27 | gonzach01 | 2019 | COL | NL | 1.660304692 | 0.117169811 | P | 3 | 1 | COL | TEX | 2019 | 2019 | |
470 | 470 | Matt Moore | 30 | moorema02 | 2019 | DET | AL | 0.290093103 | 0.63056962 | P | 2 | 1 | DET | TEX | 2019 | 2019 | |
511 | 511 | Robinson Chirinos | 35 | chiriro01 | 2019 | HOU | AL | 3.97793765 | 3.163584906 | C | 14 | 1 | HOU | TEX | 2019 | 2019 | |
772 | 772 | Alex Claudio | 27 | claudal01 | 2019 | MIL | NL | 2.037084077 | 0.371886792 | P | 4 | 1 | MIL | TEX | 2019 | 2019 | |
780 | 780 | Jeremy Jeffress | 31 | jeffrje01 | 2019 | MIL | NL | 1.587971271 | -0.081509434 | P | 2 | 1 | MIL | TEX | 2017 | 2019 | |
817 | 817 | Martin Perez | 28 | perezma02 | 2019 | MIN | AL | 4.355565073 | 1.008679245 | P | 9 | 1 | MIN | TEX | 2019 | 2019 | |
968 | 968 | Jurickson Profar | 26 | profaju01 | 2019 | OAK | AL | 4.838057999 | 1.125849057 | 2B, LF, 1B | 10 | 1 | OAK | TEX | 2019 | 2019 | |
1024 | 1024 | Drew Smyly | 30 | smylydr01 | 2019 | PHI | NL | 1.811188154 | 0.366792453 | P | 4 | 2 | PHI | TEX | 2019 | 2019 | |
1078 | 1078 | Keone Kela | 26 | kelake01 | 2019 | PIT | NL | 0.997778728 | 0.774339623 | P | 4 | 1 | PIT | TEX | 2018 | 2019 | |
1200 | 1200 | Connor Sadzeck | 27 | sadzeco01 | 2019 | SEA | AL | 0.613016393 | 0.254716981 | P | 2 | 1 | SEA | TEX | 2019 | 2019 | |
1251 | 1251 | Sam Dyson | 31 | dysonsa01 | 2019 | SFG | NL | 1.753498531 | 1.151320755 | P | 6 | 1 | SFG | TEX | 2017 | 2019 | MIN |
1309 | 1309 | Miles Mikolas | 30 | mikolmi01 | 2019 | STL | NL | 5.153531055 | 2.047924528 | P | 14 | 1 | STL | TEX | 2018 | 2019 | |
1339 | 1339 | Drew Robinson | 27 | robindr01 | 2019 | STL | NL | 0.070793374 | -0.101886792 | CF, RF | 0 | 1 | STL | TEX | 2019 | 2019 | |
1399 | 1399 | Peter Fairbanks | 25 | fairbpe01 | 2019 | TBR | AL | 0.38064644 | -0.13754717 | P | 0 | 2 | TBD | TEX | 2019 | 2019 | |
1504 | 1504 | Ryan Feierabend | 33 | feierry01 | 2019 | TOR | AL | 0.135944996 | -0.173207547 | P | 0 | 1 | TOR | TEX | 2019 | 2019 | |
1529 | 1529 | Asdrubal Cabrera | 33 | cabreas01 | 2019 | WSN | NL | 1.408300327 | 1.192075472 | 3B, 2B, 1B | 5 | 2 | WSN | TEX | 2019 | 2019 | |
1611 | 1611 | Jake Diekman | 31 | diekmja01 | 2018 | ARI | NL | 0.442302496 | -0.51 | P | 0 | 2 | ARI | TEX | 2018 | 2018 | KCR |
1639 | 1639 | Luke Jackson | 26 | jackslu01 | 2018 | ATL | NL | 1.076143466 | 0.12 | P | 2 | 1 | ATL | TEX | 2017 | 2019 | |
1677 | 1677 | Andrew Cashner | 31 | cashnan01 | 2018 | BAL | AL | 4.421624365 | 0.63 | P | 7 | 1 | BAL | TEX | 2018 | 2019 | BOS |
1681 | 1681 | Renato Nunez | 24 | nunezre01 | 2018 | BAL | AL | 2.122774913 | 1.07 | 3B, LF | 6 | 2 | BAL | TEX | 2018 | 2019 | |
1695 | 1695 | Darren O'Day | 35 | odayda01 | 2018 | BAL | AL | 0.700966733 | 0.37 | P | 2 | 1 | BAL | TEX | 2012 | 2018 | ATL |
1712 | 1712 | Jhan Marinez | 29 | marinjh01 | 2018 | BAL | AL | 0.183235164 | -0.125 | P | 0 | 1 | BAL | TEX | 2018 | 2018 | |
1727 | 1727 | Chris Davis | 32 | davisch02 | 2018 | BAL | AL | 5.036765929 | -2.975 | 1B | 0 | 1 | BAL | TEX | 2011 | 2019 | |
1739 | 1739 | Mitch Moreland | 32 | morelmi01 | 2018 | BOS | AL | 4.23782235 | 0.82 | 1B | 9 | 1 | BOS | TEX | 2017 | 2019 | |
1785 | 1785 | Cole Hamels | 34 | hamelco01 | 2018 | CHC | NL | 2.046879362 | 2.131840491 | P | 9 | 2 | CHC | TEX | 2018 | 2019 | |
1789 | 1789 | Jesse Chavez | 34 | chaveje01 | 2018 | CHC | NL | 1.355023181 | 1.550429448 | P | 7 | 2 | CHC | TEX | 2018 | 2018 | TEX |
1802 | 1802 | Anthony Bass | 30 | bassan01 | 2018 | CHC | NL | 0.40453187 | 0.213680982 | P | 1 | 1 | CHC | TEX | 2018 | 2018 | SEA |
1837 | 1837 | Leury Garcia | 27 | garcile02 | 2018 | CHW | AL | 2.636363636 | 0.455 | LF, CF, RF, 2B, SS, 3B | 5 | 1 | CHW | TEX | 2013 | 2019 | |
1868 | 1868 | Miguel Gonzalez | 34 | gonzami03 | 2018 | CHW | AL | 0.346747519 | -0.495 | P | 0 | 1 | CHW | TEX | 2018 | 2018 | |
1912 | 1912 | Phil Gosselin | 29 | gosseph01 | 2018 | CIN | NL | 0.275581198 | -0.155 | 3B, 1B, 2B, LF | 0 | 1 | CIN | TEX | 2018 | 2018 | PHI |
1987 | 1987 | Ian Desmond | 32 | desmoia01 | 2018 | COL | NL | 6.144446346 | -0.611226994 | 1B, LF, SS, CF | 8 | 1 | COL | TEX | 2017 | 2019 | |
2040 | 2040 | Pete Kozma | 30 | kozmape01 | 2018 | DET | AL | 0.704492512 | 0.325 | SS, 3B, 2B | 2 | 1 | DET | TEX | 2018 | 2018 | |
2045 | 2045 | Jim Adduci | 33 | adducji02 | 2018 | DET | AL | 1.785357737 | -0.305 | 1B | 2 | 1 | DET | TEX | 2017 | 2018 | CHC |
2266 | 2266 | Wilmer Font | 28 | fontwi01 | 2018 | LAD | NL | 0.288835068 | -0.606257669 | P | 0 | 1 | LAD | TEX | 2017 | 2018 | OAK |
2303 | 2303 | Tomas Telis | 27 | telisto01 | 2018 | MIA | NL | 0.31 | -0.11068323 | C, 1B | 0 | 1 | FLA | TEX | 2015 | 2018 | |
2323 | 2323 | Jeremy Jeffress | 30 | jeffrje01 | 2018 | MIL | NL | 3.063101152 | 2.524417178 | P | 12 | 1 | MIL | TEX | 2017 | 2019 | |
2573 | 2573 | Cory Gearrin | 32 | gearrco01 | 2018 | OAK | AL | 0.118709894 | -0.03 | P | 0 | 3 | OAK | TEX | 2018 | 2018 | SEA |
2581 | 2581 | Jake Smolinski | 29 | smolija01 | 2018 | OAK | AL | 0.381456529 | -0.37 | CF, LF, P | 0 | 1 | OAK | TEX | 2015 | 2018 | |
2656 | 2656 | Keone Kela | 25 | kelake01 | 2018 | PIT | NL | 0.488775857 | 0.311925466 | P | 2 | 2 | PIT | TEX | 2018 | 2019 | |
2694 | 2694 | Tyson Ross | 31 | rossty01 | 2018 | SDP | NL | 3.448170298 | 0.495 | P | 6 | 1 | SDP | TEX | 2018 | 2018 | STL |
2794 | 2794 | Sam Dyson | 30 | dysonsa01 | 2018 | SFG | NL | 2.280848854 | 0.895 | P | 6 | 1 | SFG | TEX | 2017 | 2019 | MIN |
2830 | 2830 | Miles Mikolas | 29 | mikolmi01 | 2018 | STL | NL | 5.525445992 | 4.415 | P | 22 | 1 | STL | TEX | 2018 | 2019 | |
2898 | 2898 | Carlos Gomez | 32 | gomezca01 | 2018 | TBR | AL | 3.83346833 | -0.05 | RF, CF, 2B, P | 5 | 1 | TBD | TEX | 2018 | 2018 | NYM |
3019 | 3019 | Mike Hauschild | 28 | hauscmi01 | 2018 | TOR | AL | 0.24317584 | 0.08 | P | 1 | 1 | TOR | TEX | 2018 | 2018 | |
3166 | 3166 | Luke Jackson | 25 | jackslu01 | 2017 | ATL | NL | 1.198915364 | 0.2 | P | 2 | 1 | ATL | TEX | 2017 | 2019 | |
3204 | 3204 | Chris Davis | 31 | davisch02 | 2017 | BAL | AL | 4.964390722 | 0.0 | 1B, 3B | 8 | 1 | BAL | TEX | 2011 | 2019 | |
3206 | 3206 | Darren O'Day | 34 | odayda01 | 2017 | BAL | AL | 2.020733652 | 0.925 | P | 6 | 1 | BAL | TEX | 2012 | 2018 | ATL |
3250 | 3250 | Mitch Moreland | 31 | morelmi01 | 2017 | BOS | AL | 5.290261283 | 1.435 | 1B, P | 12 | 1 | BOS | TEX | 2017 | 2019 | |
3281 | 3281 | Robbie Ross | 28 | rossro01 | 2017 | BOS | AL | 0.216108299 | -0.04 | P | 0 | 1 | BOS | TEX | 2015 | 2017 | |
3322 | 3322 | Justin Grimm | 28 | grimmju01 | 2017 | CHC | NL | 1.484145796 | -0.43 | P | 1 | 1 | CHC | TEX | 2013 | 2017 | KCR |
3346 | 3346 | Leury Garcia | 26 | garcile02 | 2017 | CHW | AL | 3.130981951 | 1.21 | CF, LF, RF, 2B, SS | 8 | 1 | CHW | TEX | 2013 | 2019 | |
3365 | 3365 | Derek Holland | 30 | hollade01 | 2017 | CHW | AL | 3.768239164 | -1.16 | P | 2 | 1 | CHW | TEX | 2017 | 2017 | SFG |
3431 | 3431 | Lisalverto Bonilla | 27 | bonilli01 | 2017 | CIN | NL | 0.905741422 | -0.545 | P | 0 | 1 | CIN | TEX | 2017 | 2017 | |
3493 | 3493 | Jonathan Lucroy | 31 | lucrojo01 | 2017 | COL | NL | 1.730900409 | 0.765 | C, 1B | 5 | 2 | COL | TEX | 2017 | 2017 | OAK |
3502 | 3502 | Ian Desmond | 31 | desmoia01 | 2017 | COL | NL | 3.689290587 | -0.97 | LF, 1B, CF, SS | 3 | 1 | COL | TEX | 2017 | 2019 | |
3521 | 3521 | Ian Kinsler | 35 | kinslia01 | 2017 | DET | AL | 5.80189295 | 2.445 | 2B | 14 | 1 | DET | TEX | 2014 | 2017 | ANA |
3541 | 3541 | Jim Adduci | 32 | adducji02 | 2017 | DET | AL | 0.880221932 | 0.375 | RF | 2 | 1 | DET | TEX | 2017 | 2018 | CHC |
3588 | 3588 | Carlos Beltran | 40 | beltrca01 | 2017 | HOU | AL | 4.729573855 | -0.95 | LF, RF | 4 | 1 | HOU | TEX | 2017 | 2017 | |
3737 | 3737 | Yu Darvish | 30 | darviyu01 | 2017 | LAD | NL | 1.404777541 | 0.69 | P | 4 | 2 | LAD | TEX | 2017 | 2017 | CHC |
3764 | 3764 | Wilmer Font | 27 | fontwi01 | 2017 | LAD | NL | 0.077781307 | -0.265 | P | 0 | 1 | LAD | TEX | 2017 | 2018 | OAK |
3807 | 3807 | Tomas Telis | 26 | telisto01 | 2017 | MIA | NL | 1.085666105 | -0.36 | 1B, C | 0 | 1 | FLA | TEX | 2015 | 2018 | |
3832 | 3832 | Matt Garza | 33 | garzama01 | 2017 | MIL | NL | 3.080173535 | 0.18 | P | 5 | 1 | MIL | TEX | 2014 | 2017 | |
3839 | 3839 | Jeremy Jeffress | 29 | jeffrje01 | 2017 | MIL | NL | 0.742251756 | 0.24 | P | 2 | 2 | MIL | TEX | 2017 | 2019 | |
3885 | 3885 | Dillon Gee | 31 | geedi01 | 2017 | MIN | AL | 1.130220627 | 0.57 | P | 3 | 2 | MIN | TEX | 2017 | 2017 | |
4059 | 4059 | Jake Smolinski | 28 | smolija01 | 2017 | OAK | AL | 0.275602163 | -0.08 | CF, LF, RF | 0 | 1 | OAK | TEX | 2015 | 2018 | |
4115 | 4115 | Andres Blanco | 33 | blancan01 | 2017 | PHI | NL | 1.433327613 | -0.435 | 3B, 2B, 1B, SS, P | 0 | 1 | PHI | TEX | 2014 | 2017 | |
4259 | 4259 | Leonys Martin | 29 | martile01 | 2017 | SEA | AL | 1.152630722 | -0.335 | CF, RF, LF, P | 1 | 1 | SEA | TEX | 2016 | 2017 | CHC |
4303 | 4303 | Sam Dyson | 29 | dysonsa01 | 2017 | SFG | NL | 1.580280271 | 0.265 | P | 3 | 2 | SFG | TEX | 2017 | 2019 | MIN |
4522 | 4522 | Lucas Harrell | 32 | harrelu01 | 2017 | TOR | AL | 0.167669027 | -0.05 | P | 0 | 1 | TOR | TEX | 2017 | 2017 | |
4690 | 4690 | Drew Stubbs | 31 | stubbdr01 | 2016 | ATL | NL | 0.414426676 | -0.145900621 | RF, CF, LF | 0 | 1 | ATL | TEX | 2016 | 2016 | TEX |
4704 | 4704 | Chris Davis | 30 | davisch02 | 2016 | BAL | AL | 6.363636364 | 3.09 | 1B, RF | 19 | 1 | BAL | TEX | 2011 | 2019 | |
4718 | 4718 | Yovani Gallardo | 30 | gallayo01 | 2016 | BAL | AL | 3.414082349 | 0.55 | P | 7 | 1 | BAL | TEX | 2016 | 2016 | SEA |
4722 | 4722 | Darren O'Day | 33 | odayda01 | 2016 | BAL | AL | 1.127145378 | 0.305 | P | 3 | 1 | BAL | TEX | 2012 | 2018 | ATL |
4745 | 4745 | Drew Stubbs | 31 | stubbdr01 | 2016 | BAL | AL | 0.258373206 | -0.25 | RF, CF, LF | 0 | 3 | BAL | TEX | 2016 | 2016 | SFG |
4766 | 4766 | Robbie Ross | 27 | rossro01 | 2016 | BOS | AL | 1.663862538 | 0.825 | P | 4 | 1 | BOS | TEX | 2015 | 2017 | |
4767 | 4767 | Koji Uehara | 41 | ueharko01 | 2016 | BOS | AL | 1.565693469 | 0.67 | P | 4 | 1 | BOS | TEX | 2013 | 2016 | CHC |
4794 | 4794 | Bryan Holaday | 28 | holadbr01 | 2016 | BOS | AL | 0.322580645 | -0.22 | C, 3B, LF, P | 0 | 2 | BOS | TEX | 2016 | 2016 | DET |
4824 | 4824 | Justin Grimm | 27 | grimmju01 | 2016 | CHC | NL | 1.424473435 | 0.34 | P | 3 | 1 | CHC | TEX | 2013 | 2017 | KCR |
4841 | 4841 | Spencer Patton | 28 | pattosp01 | 2016 | CHC | NL | 0.494117647 | -0.34 | P, LF | 0 | 1 | CHC | TEX | 2016 | 2016 | |
4881 | 4881 | Leury Garcia | 25 | garcile02 | 2016 | CHW | AL | 0.474709445 | -0.08 | CF | 0 | 1 | CHW | TEX | 2013 | 2019 | |
4889 | 4889 | Anthony Ranaudo | 26 | ranauan01 | 2016 | CHW | AL | 0.663526443 | -0.47 | P | 0 | 2 | CHW | TEX | 2016 | 2016 | |
4914 | 4914 | Ross Ohlendorf | 33 | ohlenro01 | 2016 | CIN | NL | 2.101463598 | -0.13 | P | 3 | 1 | CIN | TEX | 2016 | 2016 | |
4954 | 4954 | Mike Napoli | 34 | napolmi01 | 2016 | CLE | AL | 6.102773246 | 0.950869565 | 1B | 12 | 1 | CLE | TEX | 2016 | 2016 | TEX |
4993 | 4993 | Chris Gimenez | 33 | gimench01 | 2016 | CLE | AL | 1.466557912 | -0.578571429 | C, 1B, 3B, P | 0 | 1 | CLE | TEX | 2016 | 2016 | MIN |
5042 | 5042 | Ian Kinsler | 34 | kinslia01 | 2016 | DET | AL | 6.451834862 | 5.735403727 | 2B | 26 | 1 | DET | TEX | 2014 | 2017 | ANA |
5078 | 5078 | Bobby Wilson | 33 | wilsobo02 | 2016 | DET | AL | 0.142529489 | -0.11068323 | C | 0 | 1 | DET | TEX | 2016 | 2016 | TEX |
5266 | 5266 | Nick Tepesch | 27 | tepesni01 | 2016 | LAD | NL | 0.111146228 | -0.11 | P | 0 | 1 | LAD | TEX | 2016 | 2016 | MIN |
5272 | 5272 | Will Venable | 33 | venabwi01 | 2016 | LAD | NL | 0.188504961 | -0.295 | RF, LF | 0 | 1 | LAD | TEX | 2016 | 2016 |
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 );