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,036 rows where next_franch = "TEX"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1234 | 1234 | Jesse Biddle | 27 | biddlje01 | 2019 | SEA | AL | 0.284923112 | -0.376981132 | P | 0 | 2 | SEA | ATL | 2019 | 2019 | TEX |
1395 | 1395 | Ian Gibaut | 25 | gibauia01 | 2019 | TBR | AL | 0.028993432 | -0.015283019 | P | 0 | 1 | TBD | 2019 | 2019 | TEX | |
1582 | 1582 | Jeff Mathis | 35 | mathije01 | 2018 | ARI | NL | 2.170643777 | 0.39 | C, 2B, P | 4 | 1 | ARI | FLA | 2017 | 2018 | TEX |
1613 | 1613 | Shelby Miller | 27 | millesh01 | 2018 | ARI | NL | 0.465917074 | -0.7 | P | 0 | 1 | ARI | ATL | 2016 | 2018 | TEX |
1646 | 1646 | Danny Santana | 27 | santada01 | 2018 | ATL | NL | 0.313354719 | 0.065 | LF, CF, RF | 1 | 1 | ATL | MIN | 2017 | 2018 | TEX |
1664 | 1664 | Kolby Allard | 20 | allarko01 | 2018 | ATL | NL | 0.193960101 | -0.15 | P | 0 | 1 | ATL | 2018 | 2018 | TEX | |
1669 | 1669 | Carlos Perez | 27 | perezca02 | 2018 | ATL | NL | 0.215431369 | -0.28 | C | 0 | 1 | ATL | ANA | 2018 | 2018 | TEX |
1789 | 1789 | Jesse Chavez | 34 | chaveje01 | 2018 | CHC | NL | 1.355023181 | 1.550429448 | P | 7 | 2 | CHC | TEX | 2018 | 2018 | TEX |
1805 | 1805 | Eddie Butler | 27 | butleed01 | 2018 | CHC | NL | 0.397323533 | 0.019877301 | P | 1 | 1 | CHC | COL | 2017 | 2018 | TEX |
1820 | 1820 | Luke Farrell | 27 | farrelu01 | 2018 | CHC | NL | 0.916996572 | -0.506871166 | P | 0 | 1 | CHC | CIN | 2018 | 2018 | TEX |
1851 | 1851 | Jeanmar Gomez | 30 | gomezje01 | 2018 | CHW | AL | 0.905833417 | 0.065 | P | 1 | 1 | CHW | PHI | 2018 | 2018 | TEX |
1902 | 1902 | Tim Federowicz | 30 | federti01 | 2018 | CIN | NL | 0.0688953 | 0.13 | C | 0 | 2 | CIN | HOU | 2018 | 2018 | TEX |
1915 | 1915 | Yovani Gallardo | 32 | gallayo01 | 2018 | CIN | NL | 0.047828037 | -0.245 | P | 0 | 1 | CIN | SEA | 2018 | 2018 | TEX |
2390 | 2390 | Logan Forsythe | 31 | forsylo01 | 2018 | MIN | AL | 1.93900848 | 0.5 | 2B, 3B, 1B, LF | 4 | 2 | MIN | LAD | 2018 | 2018 | TEX |
2500 | 2500 | Lance Lynn | 31 | lynnla01 | 2018 | NYY | AL | 1.519409112 | 1.26 | P | 6 | 2 | NYY | MIN | 2018 | 2018 | TEX |
2555 | 2555 | Shawn Kelley | 34 | kellesh01 | 2018 | OAK | AL | 0.510501394 | 0.485 | P | 2 | 2 | OAK | WSN | 2018 | 2018 | TEX |
2609 | 2609 | Asdrubal Cabrera | 32 | cabreas01 | 2018 | PHI | NL | 1.838588074 | -0.17 | 2B, SS, 3B | 2 | 2 | PHI | NYM | 2018 | 2018 | TEX |
2613 | 2613 | Zac Curtis | 25 | curtiza01 | 2018 | PHI | NL | 0.148738729 | 0.125 | P | 1 | 1 | PHI | SEA | 2017 | 2018 | TEX |
2615 | 2615 | Drew Hutchison | 27 | hutchdr01 | 2018 | PHI | NL | 0.492376483 | 0.055 | P | 1 | 1 | PHI | PIT | 2018 | 2018 | TEX |
2812 | 2812 | Cory Gearrin | 32 | gearrco01 | 2018 | SFG | NL | 0.864776817 | -0.1 | P | 1 | 1 | SFG | ATL | 2015 | 2018 | TEX |
2817 | 2817 | Hunter Pence | 35 | pencehu01 | 2018 | SFG | NL | 2.48042766 | -0.83 | LF, RF | 1 | 1 | SFG | PHI | 2012 | 2018 | TEX |
2853 | 2853 | Patrick Wisdom | 26 | wisdopa01 | 2018 | STL | NL | 0.572790737 | 0.495 | 3B, 1B | 2 | 1 | STL | 2018 | 2018 | TEX | |
3029 | 3029 | Taylor Guerrieri | 25 | guerrta02 | 2018 | TOR | AL | 0.182612257 | -0.01 | P | 0 | 1 | TOR | 2018 | 2018 | TEX | |
3122 | 3122 | Jeff Mathis | 34 | mathije01 | 2017 | ARI | NL | 2.004426285 | -0.06 | C | 3 | 1 | ARI | FLA | 2017 | 2018 | TEX |
3124 | 3124 | Shelby Miller | 26 | millesh01 | 2017 | ARI | NL | 0.620935187 | 0.44 | P | 2 | 1 | ARI | ATL | 2016 | 2018 | TEX |
3175 | 3175 | Danny Santana | 26 | santada01 | 2017 | ATL | NL | 1.495758398 | -0.355 | LF, 2B, RF, 3B, CF | 1 | 2 | ATL | MIN | 2017 | 2018 | TEX |
3259 | 3259 | Doug Fister | 33 | fistedo01 | 2017 | BOS | AL | 2.724269986 | 0.745 | P | 6 | 1 | BOS | HOU | 2017 | 2017 | TEX |
3312 | 3312 | Eddie Butler | 26 | butleed01 | 2017 | CHC | NL | 1.433314757 | 0.645 | P | 4 | 1 | CHC | COL | 2017 | 2018 | TEX |
3342 | 3342 | Miguel Gonzalez | 33 | gonzami03 | 2017 | CHW | AL | 3.897771573 | 1.55 | P | 10 | 1 | CHW | BAL | 2016 | 2017 | TEX |
3611 | 3611 | Juan Centeno | 27 | centeju01 | 2017 | HOU | AL | 0.529637937 | -0.26 | C | 0 | 1 | HOU | MIN | 2017 | 2017 | TEX |
3621 | 3621 | Mike Minor | 29 | minormi01 | 2017 | KCR | AL | 2.876079599 | 2.535 | P | 12 | 1 | KCR | ATL | 2017 | 2017 | TEX |
3677 | 3677 | Jesse Chavez | 33 | chaveje01 | 2017 | LAA | AL | 3.821226912 | -0.05 | P | 6 | 1 | ANA | LAD | 2017 | 2017 | TEX |
3779 | 3779 | Edinson Volquez | 33 | volqued01 | 2017 | MIA | NL | 2.632935812 | 0.865 | P | 6 | 1 | FLA | KCR | 2017 | 2017 | TEX |
3856 | 3856 | Paolo Espino | 30 | espinpa01 | 2017 | MIL | NL | 0.399357866 | -0.24 | P | 0 | 1 | MIL | 2017 | 2017 | TEX | |
3884 | 3884 | Bartolo Colon | 44 | colonba01 | 2017 | MIN | AL | 2.270051544 | 0.145 | P | 4 | 2 | MIN | ATL | 2017 | 2017 | TEX |
3932 | 3932 | Rafael Montero | 26 | montera01 | 2017 | NYM | NL | 3.22392739 | 0.385 | P | 5 | 1 | NYM | 2014 | 2017 | TEX | |
4012 | 4012 | Pete Kozma | 29 | kozmape01 | 2017 | NYY | AL | 0.09164165 | -0.19 | 3B, SS, 1B, 2B | 0 | 1 | NYY | STL | 2017 | 2017 | TEX |
4057 | 4057 | Renato Nunez | 23 | nunezre01 | 2017 | OAK | AL | 0.152056366 | -0.01 | LF, 3B | 0 | 1 | OAK | 2016 | 2017 | TEX | |
4105 | 4105 | Zac Curtis | 24 | curtiza01 | 2017 | PHI | NL | 0.095484482 | 0.1 | P | 0 | 2 | PHI | SEA | 2017 | 2018 | TEX |
4145 | 4145 | Jhan Marinez | 28 | marinjh01 | 2017 | PIT | NL | 0.708521457 | 0.36 | P | 2 | 2 | PIT | MIL | 2017 | 2017 | TEX |
4165 | 4165 | Phil Gosselin | 28 | gosseph01 | 2017 | PIT | NL | 0.419060726 | -0.59 | 2B, SS, 3B, 1B | 0 | 1 | PIT | ARI | 2017 | 2017 | TEX |
4290 | 4290 | Hunter Pence | 34 | pencehu01 | 2017 | SFG | NL | 5.372400756 | 0.435 | RF | 8 | 1 | SFG | PHI | 2012 | 2018 | TEX |
4291 | 4291 | Cory Gearrin | 31 | gearrco01 | 2017 | SFG | NL | 1.956196781 | 1.335 | P | 7 | 1 | SFG | ATL | 2015 | 2018 | TEX |
4293 | 4293 | Matt Moore | 28 | moorema02 | 2017 | SFG | NL | 4.807269621 | 0.38 | P | 7 | 1 | SFG | TBD | 2016 | 2017 | TEX |
4542 | 4542 | Jason Grilli | 40 | grillja01 | 2017 | TOR | AL | 0.647143612 | -0.635 | P | 0 | 1 | TOR | ATL | 2016 | 2017 | TEX |
4616 | 4616 | Shelby Miller | 25 | millesh01 | 2016 | ARI | NL | 2.780239689 | -0.245 | P, LF | 3 | 1 | ARI | ATL | 2016 | 2018 | TEX |
4660 | 4660 | Lucas Harrell | 31 | harrelu01 | 2016 | ATL | NL | 0.817861868 | 0.457826087 | P | 3 | 1 | ATL | HOU | 2016 | 2016 | TEX |
4666 | 4666 | Dario Alvarez | 27 | alvarda01 | 2016 | ATL | NL | 0.539930454 | 0.296832298 | P | 2 | 1 | ATL | NYM | 2016 | 2016 | TEX |
4690 | 4690 | Drew Stubbs | 31 | stubbdr01 | 2016 | ATL | NL | 0.414426676 | -0.145900621 | RF, CF, LF | 0 | 1 | ATL | TEX | 2016 | 2016 | TEX |
4851 | 4851 | Miguel Gonzalez | 32 | gonzami03 | 2016 | CHW | AL | 3.717346938 | 2.5 | P | 12 | 1 | CHW | BAL | 2016 | 2017 | TEX |
4954 | 4954 | Mike Napoli | 34 | napolmi01 | 2016 | CLE | AL | 6.102773246 | 0.950869565 | 1B | 12 | 1 | CLE | TEX | 2016 | 2016 | TEX |
5078 | 5078 | Bobby Wilson | 33 | wilsobo02 | 2016 | DET | AL | 0.142529489 | -0.11068323 | C | 0 | 1 | DET | TEX | 2016 | 2016 | TEX |
5111 | 5111 | Carlos Gomez | 30 | gomezca01 | 2016 | HOU | AL | 3.030901149 | -0.805 | CF, LF, RF | 2 | 1 | HOU | MIL | 2015 | 2016 | TEX |
5144 | 5144 | Dillon Gee | 30 | geedi01 | 2016 | KCR | AL | 3.445959203 | 0.155 | P | 6 | 1 | KCR | NYM | 2016 | 2016 | TEX |
5302 | 5302 | Andrew Cashner | 29 | cashnan01 | 2016 | MIA | NL | 1.669352679 | -0.080496894 | P | 2 | 2 | FLA | SDP | 2016 | 2016 | TEX |
5334 | 5334 | Jonathan Lucroy | 30 | lucrojo01 | 2016 | MIL | NL | 3.791376912 | 2.66 | C, 1B | 13 | 1 | MIL | 2010 | 2016 | TEX | |
5348 | 5348 | Jeremy Jeffress | 28 | jeffrje01 | 2016 | MIL | NL | 1.742794014 | 1.045 | P | 6 | 1 | MIL | TOR | 2014 | 2016 | TEX |
5365 | 5365 | Will Middlebrooks | 27 | middlwi01 | 2016 | MIL | NL | 0.312586926 | -0.07 | 3B | 0 | 1 | MIL | SDP | 2016 | 2016 | TEX |
5475 | 5475 | Rafael Montero | 25 | montera01 | 2016 | NYM | NL | 0.415310594 | -0.485 | P | 0 | 1 | NYM | 2014 | 2017 | TEX | |
5485 | 5485 | Carlos Beltran | 39 | beltrca01 | 2016 | NYY | AL | 3.716840537 | 2.11 | RF | 12 | 1 | NYY | STL | 2014 | 2016 | TEX |
5572 | 5572 | Renato Nunez | 22 | nunezre01 | 2016 | OAK | AL | 0.145048349 | -0.285 | 0 | 1 | OAK | 2016 | 2017 | TEX | ||
5729 | 5729 | Tyson Ross | 29 | rossty01 | 2016 | SDP | NL | 0.151425032 | -0.105 | P | 0 | 1 | SDP | OAK | 2013 | 2016 | TEX |
5783 | 5783 | Adrian Sampson | 24 | sampsad01 | 2016 | SEA | AL | 0.131624141 | -0.06 | P | 0 | 1 | SEA | 2016 | 2016 | TEX | |
5804 | 5804 | Hunter Pence | 33 | pencehu01 | 2016 | SFG | NL | 4.345821326 | 1.865 | RF | 11 | 1 | SFG | PHI | 2012 | 2018 | TEX |
5813 | 5813 | Matt Moore | 27 | moorema02 | 2016 | SFG | NL | 1.829889507 | 0.66 | P | 4 | 2 | SFG | TBD | 2016 | 2017 | TEX |
5820 | 5820 | Cory Gearrin | 30 | gearrco01 | 2016 | SFG | NL | 1.748698249 | 0.295 | P, LF | 3 | 1 | SFG | ATL | 2015 | 2018 | TEX |
5892 | 5892 | Drew Smyly | 27 | smylydr01 | 2016 | TBR | AL | 4.932156646 | 0.915 | P | 8 | 1 | TBD | DET | 2014 | 2016 | TEX |
5923 | 5923 | Kevin Jepsen | 31 | jepseke01 | 2016 | TBR | AL | 0.565912852 | -0.355 | P | 0 | 2 | TBD | MIN | 2016 | 2016 | TEX |
6003 | 6003 | Jason Grilli | 39 | grillja01 | 2016 | TOR | AL | 1.499345106 | 0.3 | P | 3 | 2 | TOR | ATL | 2016 | 2017 | TEX |
6250 | 6250 | Mike Napoli | 33 | napolmi01 | 2015 | BOS | AL | 3.529298133 | 0.25 | 1B, LF | 5 | 1 | BOS | TEX | 2013 | 2015 | TEX |
6499 | 6499 | Drew Stubbs | 30 | stubbdr01 | 2015 | COL | NL | 1.149913043 | 0.13 | CF, LF, RF | 2 | 1 | COL | CLE | 2014 | 2015 | TEX |
6547 | 6547 | Bryan Holaday | 27 | holadbr01 | 2015 | DET | AL | 0.614807567 | 0.166024845 | C, 1B, 2B | 1 | 1 | DET | 2012 | 2015 | TEX | |
6591 | 6591 | Carlos Gomez | 29 | gomezca01 | 2015 | HOU | AL | 1.563678465 | 0.755 | CF, 2B | 4 | 2 | HOU | MIL | 2015 | 2016 | TEX |
6678 | 6678 | Cesar Ramos | 31 | ramosce01 | 2015 | LAA | AL | 1.418300436 | 0.765 | P | 5 | 1 | ANA | TBD | 2015 | 2015 | TEX |
6735 | 6735 | Justin Ruggiano | 33 | ruggiju01 | 2015 | LAD | NL | 0.605955076 | 0.615 | LF, CF, RF | 3 | 2 | LAD | SEA | 2015 | 2015 | TEX |
6791 | 6791 | Sam Dyson | 27 | dysonsa01 | 2015 | MIA | NL | 1.362904835 | 0.075 | P | 2 | 1 | FLA | TOR | 2013 | 2015 | TEX |
6823 | 6823 | Jonathan Lucroy | 29 | lucrojo01 | 2015 | MIL | NL | 4.214673437 | 1.32 | C, 1B | 10 | 1 | MIL | 2010 | 2016 | TEX | |
6830 | 6830 | Jeremy Jeffress | 27 | jeffrje01 | 2015 | MIL | NL | 2.488195321 | 1.085 | P | 7 | 1 | MIL | TOR | 2014 | 2016 | TEX |
6840 | 6840 | Kyle Lohse | 36 | lohseky01 | 2015 | MIL | NL | 4.222042898 | -0.56 | P | 4 | 1 | MIL | STL | 2013 | 2015 | TEX |
6946 | 6946 | Rafael Montero | 24 | montera01 | 2015 | NYM | NL | 0.371991171 | 0.125 | P | 1 | 1 | NYM | 2014 | 2017 | TEX | |
6972 | 6972 | Carlos Beltran | 38 | beltrca01 | 2015 | NYY | AL | 4.933995514 | 1.295 | RF | 11 | 1 | NYY | STL | 2014 | 2016 | TEX |
6991 | 6991 | Chris Martin | 29 | martich02 | 2015 | NYY | AL | 0.55059032 | 0.005 | P | 1 | 1 | NYY | COL | 2015 | 2015 | TEX |
7069 | 7069 | Cole Hamels | 31 | hamelco01 | 2015 | PHI | NL | 3.724250685 | 2.835 | P | 14 | 1 | PHI | 2006 | 2015 | TEX | |
7097 | 7097 | Jake Diekman | 28 | diekmja01 | 2015 | PHI | NL | 0.982280869 | 0.0 | P | 1 | 1 | PHI | 2012 | 2015 | TEX | |
7164 | 7164 | Tyson Ross | 28 | rossty01 | 2015 | SDP | NL | 5.639225908 | 4.505 | P | 22 | 1 | SDP | OAK | 2013 | 2016 | TEX |
7178 | 7178 | Will Venable | 32 | venabwi01 | 2015 | SDP | NL | 3.132935812 | 0.65 | CF, LF, RF | 7 | 1 | SDP | 2008 | 2015 | TEX | |
7226 | 7226 | Tom Wilhelmsen | 31 | wilheto01 | 2015 | SEA | AL | 2.148771265 | 0.905 | P | 6 | 1 | SEA | 2011 | 2015 | TEX | |
7272 | 7272 | Hunter Pence | 32 | pencehu01 | 2015 | SFG | NL | 2.230384549 | 1.125 | RF | 6 | 1 | SFG | PHI | 2012 | 2018 | TEX |
7294 | 7294 | Cory Gearrin | 29 | gearrco01 | 2015 | SFG | NL | 0.110045009 | 0.045 | P | 0 | 1 | SFG | ATL | 2015 | 2018 | TEX |
7366 | 7366 | Drew Smyly | 26 | smylydr01 | 2015 | TBR | AL | 1.780566793 | 1.33 | P | 6 | 1 | TBD | DET | 2014 | 2016 | TEX |
7399 | 7399 | Bobby Wilson | 32 | wilsobo02 | 2015 | TBR | AL | 0.565526359 | -0.245 | C | 0 | 1 | TBD | ARI | 2015 | 2015 | TEX |
7400 | 7400 | Ernesto Frieri | 29 | frierer01 | 2015 | TBR | AL | 0.58653965 | -0.255 | P | 0 | 1 | TBD | PIT | 2015 | 2015 | TEX |
7520 | 7520 | Ian Desmond | 29 | desmoia01 | 2015 | WSN | NL | 6.457877367 | 1.735 | SS | 14 | 1 | WSN | 2009 | 2015 | TEX | |
7549 | 7549 | David Carpenter | 29 | carpeda01 | 2015 | WSN | NL | 0.184408584 | 0.06 | P | 0 | 2 | WSN | NYY | 2015 | 2015 | TEX |
7697 | 7697 | Mike Napoli | 32 | napolmi01 | 2014 | BOS | AL | 4.672897196 | 2.675 | 1B | 14 | 1 | BOS | TEX | 2013 | 2015 | TEX |
7732 | 7732 | Mike Carp | 28 | carpmi01 | 2014 | BOS | AL | 0.962616822 | -0.23 | 1B, LF, 3B, P, RF | 1 | 1 | BOS | SEA | 2013 | 2014 | TEX |
7744 | 7744 | Anthony Ranaudo | 24 | ranauan01 | 2014 | BOS | AL | 1.071067251 | -0.535 | P | 0 | 1 | BOS | 2014 | 2014 | TEX | |
7783 | 7783 | Kyuji Fujikawa | 33 | fujikky01 | 2014 | CHC | NL | 0.234541313 | -0.01 | P | 0 | 1 | CHC | 2013 | 2014 | TEX | |
7925 | 7925 | Chris Gimenez | 31 | gimench01 | 2014 | CLE | AL | 0.093533301 | -0.255 | C, 1B, 3B, P | 0 | 2 | CLE | TEX | 2014 | 2014 | TEX |
7936 | 7936 | Drew Stubbs | 29 | stubbdr01 | 2014 | COL | NL | 4.216735254 | 2.655 | CF | 13 | 1 | COL | CLE | 2014 | 2015 | TEX |
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 );