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,340 rows where next_franch = "PIT"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134 | 134 | Yefry Ramirez | 25 | ramirye01 | 2019 | BAL | AL | 0.326975416 | -0.13754717 | P | 0 | 1 | BAL | 2018 | 2019 | PIT | |
647 | 647 | Chris Stratton | 28 | stratch01 | 2019 | LAA | AL | 0.773937979 | -0.40245283 | P | 0 | 1 | ANA | SFG | 2019 | 2019 | PIT |
990 | 990 | Wei-Chung Wang | 27 | wangwe01 | 2019 | OAK | AL | 0.641782893 | 0.168113208 | P | 1 | 1 | OAK | MIL | 2019 | 2019 | PIT |
1058 | 1058 | Yacksel Rios | 26 | riosya01 | 2019 | PHI | NL | 0.045915137 | -0.239433962 | P | 0 | 1 | PHI | 2017 | 2019 | PIT | |
1229 | 1229 | Parker Markel | 28 | markepa01 | 2019 | SEA | AL | 0.083462326 | -0.244528302 | P | 0 | 1 | SEA | 2019 | 2019 | PIT | |
1277 | 1277 | Williams Jerez | 27 | jerezwi01 | 2019 | SFG | NL | 0.168026612 | 0.030566038 | P | 0 | 1 | SFG | ANA | 2019 | 2019 | PIT |
1293 | 1293 | Corban Joseph | 30 | josepco01 | 2019 | SFG | NL | 0.170913503 | -0.249622642 | 2B, 3B | 0 | 2 | SFG | OAK | 2019 | 2019 | PIT |
1692 | 1692 | Yefry Ramirez | 24 | ramirye01 | 2018 | BAL | AL | 1.847928674 | 0.17 | P | 3 | 1 | BAL | 2018 | 2019 | PIT | |
1941 | 1941 | Melky Cabrera | 33 | cabreme01 | 2018 | CLE | AL | 2.56997131 | 0.185 | RF, LF | 4 | 1 | CLE | KCR | 2018 | 2018 | PIT |
1943 | 1943 | Erik Gonzalez | 26 | gonzaer01 | 2018 | CLE | AL | 1.32196366 | 0.39 | 2B, 3B, SS, 1B | 3 | 1 | CLE | 2016 | 2018 | PIT | |
2027 | 2027 | Francisco Liriano | 34 | liriafr01 | 2018 | DET | AL | 3.734145498 | 0.18 | P | 6 | 1 | DET | HOU | 2018 | 2018 | PIT |
2315 | 2315 | JB Shuck | 31 | shuckja01 | 2018 | MIA | NL | 1.42 | -0.769751553 | RF, LF, CF | 0 | 1 | FLA | CHW | 2018 | 2018 | PIT |
2354 | 2354 | Jordan Lyles | 27 | lylesjo01 | 2018 | MIL | NL | 0.411405174 | 0.188834356 | P | 1 | 2 | MIL | SDP | 2018 | 2018 | PIT |
2619 | 2619 | Yacksel Rios | 25 | riosya01 | 2018 | PHI | NL | 0.953387636 | -0.28 | P | 1 | 1 | PHI | 2017 | 2019 | PIT | |
2866 | 2866 | Steven Baron | 27 | baronst01 | 2018 | STL | NL | 0.049378512 | -0.02 | C | 0 | 1 | STL | SEA | 2018 | 2018 | PIT |
2874 | 2874 | Tyler Lyons | 30 | lyonsty01 | 2018 | STL | NL | 0.578537278 | -0.61 | P | 0 | 1 | STL | 2013 | 2018 | PIT | |
2891 | 2891 | Chris Archer | 29 | archech01 | 2018 | TBR | AL | 2.558746983 | 1.155 | P | 7 | 1 | TBD | 2012 | 2018 | PIT | |
2896 | 2896 | Adeiny Hechavarria | 29 | hechaad01 | 2018 | TBR | AL | 2.226794103 | 0.73 | SS, 3B | 5 | 1 | TBD | FLA | 2017 | 2018 | PIT |
2947 | 2947 | Keone Kela | 25 | kelake01 | 2018 | TEX | AL | 1.451020922 | 1.085 | P | 5 | 1 | TEX | 2015 | 2018 | PIT | |
3086 | 3086 | Enny Romero | 27 | romeren01 | 2018 | WSN | NL | 0.03259933 | -0.095 | P | 0 | 1 | WSN | TBD | 2017 | 2018 | PIT |
3183 | 3183 | Sean Rodriguez | 32 | rodrise01 | 2017 | ATL | NL | 0.462504242 | -0.1 | 3B, RF, 2B, SS, LF, CF, 1B | 0 | 1 | ATL | PIT | 2017 | 2017 | PIT |
3237 | 3237 | Richard Rodriguez | 27 | rodriri05 | 2017 | BAL | AL | 0.11404972 | -0.31 | P | 0 | 1 | BAL | 2017 | 2017 | PIT | |
3332 | 3332 | Jack Leathersich | 26 | leathja01 | 2017 | CHC | NL | 0.015771686 | -0.105 | P | 0 | 1 | CHC | NYM | 2017 | 2017 | PIT |
3430 | 3430 | Rookie Davis | 24 | davisro03 | 2017 | CIN | NL | 0.680820062 | -0.49 | P | 0 | 1 | CIN | 2017 | 2017 | PIT | |
3464 | 3464 | Erik Gonzalez | 25 | gonzaer01 | 2017 | CLE | AL | 1.073555448 | 0.265 | 2B, SS, 3B, LF | 2 | 1 | CLE | 2016 | 2018 | PIT | |
3585 | 3585 | Joe Musgrove | 24 | musgrjo01 | 2017 | HOU | AL | 3.343289578 | 0.5 | P | 6 | 1 | HOU | 2016 | 2017 | PIT | |
3593 | 3593 | Michael Feliz | 24 | felizmi01 | 2017 | HOU | AL | 1.265332473 | -0.02 | P | 2 | 1 | HOU | 2015 | 2017 | PIT | |
3594 | 3594 | Colin Moran | 24 | moranco01 | 2017 | HOU | AL | 0.111502723 | 0.165 | 1B, 3B, SS | 1 | 1 | HOU | 2016 | 2017 | PIT | |
3853 | 3853 | Jhan Marinez | 28 | marinjh01 | 2017 | MIL | NL | 0.435467411 | -0.185 | P | 0 | 1 | MIL | TBD | 2016 | 2017 | PIT |
3948 | 3948 | Josh Smoker | 28 | smokejo01 | 2017 | NYM | NL | 1.628486178 | -0.24 | P | 1 | 1 | NYM | 2016 | 2017 | PIT | |
4056 | 4056 | Ryan Lavarnway | 29 | lavarry01 | 2017 | OAK | AL | 0.123545797 | 0.04 | C | 0 | 1 | OAK | ATL | 2017 | 2017 | PIT |
4094 | 4094 | Joaquin Benoit | 39 | benoijo01 | 2017 | PHI | NL | 1.405317591 | 0.6 | P | 3 | 1 | PHI | TOR | 2017 | 2017 | PIT |
4103 | 4103 | Yacksel Rios | 24 | riosya01 | 2017 | PHI | NL | 0.363517295 | 0.02 | P | 1 | 1 | PHI | 2017 | 2019 | PIT | |
4302 | 4302 | George Kontos | 32 | kontoge01 | 2017 | SFG | NL | 1.755866967 | 0.355 | P | 3 | 1 | SFG | NYY | 2012 | 2017 | PIT |
4304 | 4304 | Kyle Crick | 24 | crickky01 | 2017 | SFG | NL | 0.761471906 | 0.275 | P | 2 | 1 | SFG | 2017 | 2017 | PIT | |
4348 | 4348 | Tyler Lyons | 29 | lyonsty01 | 2017 | STL | NL | 1.694995218 | 1.1 | P | 5 | 1 | STL | 2013 | 2018 | PIT | |
4383 | 4383 | Chris Archer | 28 | archech01 | 2017 | TBR | AL | 5.486860856 | 3.075 | P | 16 | 1 | TBD | 2012 | 2018 | PIT | |
4384 | 4384 | Corey Dickerson | 28 | dickeco01 | 2017 | TBR | AL | 5.959163672 | 2.565 | LF | 15 | 1 | TBD | COL | 2016 | 2017 | PIT |
4389 | 4389 | Adeiny Hechavarria | 28 | hechaad01 | 2017 | TBR | AL | 2.662201895 | 1.325 | SS | 7 | 2 | TBD | FLA | 2017 | 2018 | PIT |
4446 | 4446 | Keone Kela | 24 | kelake01 | 2017 | TEX | AL | 1.239038458 | 1.02 | P | 5 | 1 | TEX | 2015 | 2018 | PIT | |
4561 | 4561 | Enny Romero | 26 | romeren01 | 2017 | WSN | NL | 1.668039925 | 0.535 | P | 4 | 1 | WSN | TBD | 2017 | 2018 | PIT |
4610 | 4610 | Phil Gosselin | 27 | gosseph01 | 2016 | ARI | NL | 2.348970638 | 0.375 | 2B, 3B, 1B, LF, RF | 4 | 1 | ARI | ATL | 2015 | 2016 | PIT |
4614 | 4614 | Daniel Hudson | 29 | hudsoda01 | 2016 | ARI | NL | 2.067169998 | 0.06 | P | 3 | 1 | ARI | CHW | 2010 | 2016 | PIT |
4982 | 4982 | Erik Gonzalez | 24 | gonzaer01 | 2016 | CLE | AL | 0.160848287 | -0.010062112 | SS, 2B, 3B, RF | 0 | 1 | CLE | 2016 | 2018 | PIT | |
5104 | 5104 | Joe Musgrove | 23 | musgrjo01 | 2016 | HOU | AL | 1.715745683 | 0.64 | P | 4 | 1 | HOU | 2016 | 2017 | PIT | |
5107 | 5107 | Michael Feliz | 23 | felizmi01 | 2016 | HOU | AL | 1.884876756 | 0.29 | P | 3 | 1 | HOU | 2015 | 2017 | PIT | |
5121 | 5121 | Colin Moran | 23 | moranco01 | 2016 | HOU | AL | 0.234589872 | -0.3 | 3B | 0 | 1 | HOU | 2016 | 2017 | PIT | |
5123 | 5123 | Erik Kratz | 36 | kratzer01 | 2016 | HOU | AL | 0.281507847 | -0.365 | C, 1B, P | 0 | 1 | HOU | PHI | 2016 | 2016 | PIT |
5350 | 5350 | Jhan Marinez | 27 | marinjh01 | 2016 | MIL | NL | 1.484784574 | 0.61 | P | 4 | 2 | MIL | TBD | 2016 | 2017 | PIT |
5377 | 5377 | Jake Elmore | 29 | elmorja01 | 2016 | MIL | NL | 0.998261474 | -0.545 | LF, 3B, RF, 2B, CF | 0 | 1 | MIL | TBD | 2016 | 2016 | PIT |
5467 | 5467 | Antonio Bastardo | 30 | bastaan01 | 2016 | NYM | NL | 1.14278566 | -0.135 | P | 1 | 1 | NYM | PIT | 2016 | 2016 | PIT |
5471 | 5471 | Josh Smoker | 27 | smokejo01 | 2016 | NYM | NL | 0.522124573 | -0.135 | P | 0 | 1 | NYM | 2016 | 2017 | PIT | |
5491 | 5491 | Ivan Nova | 29 | novaiv01 | 2016 | NYY | AL | 2.7513497 | 0.455 | P | 5 | 1 | NYY | 2010 | 2016 | PIT | |
5522 | 5522 | Johnny Barbato | 23 | barbajo01 | 2016 | NYY | AL | 0.359529388 | -0.15 | P | 0 | 1 | NYY | 2016 | 2016 | PIT | |
5523 | 5523 | Phil Coke | 33 | cokeph01 | 2016 | NYY | AL | 0.154935316 | -0.165 | P | 0 | 1 | NYY | TOR | 2016 | 2016 | PIT |
5772 | 5772 | Wade LeBlanc | 31 | leblawa01 | 2016 | SEA | AL | 1.219286127 | 0.0 | P | 2 | 1 | SEA | NYY | 2016 | 2016 | PIT |
5816 | 5816 | George Kontos | 31 | kontoge01 | 2016 | SFG | NL | 1.5269654 | 0.46 | P | 3 | 1 | SFG | NYY | 2012 | 2017 | PIT |
5866 | 5866 | Eric Fryer | 30 | fryerer01 | 2016 | STL | NL | 0.403255893 | 0.535 | C | 2 | 1 | STL | MIN | 2016 | 2016 | PIT |
5867 | 5867 | Tyler Lyons | 28 | lyonsty01 | 2016 | STL | NL | 1.248767746 | 0.235 | P | 2 | 1 | STL | 2013 | 2018 | PIT | |
5886 | 5886 | Chris Archer | 27 | archech01 | 2016 | TBR | AL | 5.663541092 | 2.4 | P | 13 | 1 | TBD | 2012 | 2018 | PIT | |
5888 | 5888 | Corey Dickerson | 27 | dickeco01 | 2016 | TBR | AL | 5.278857333 | 1.31 | LF, RF | 10 | 1 | TBD | COL | 2016 | 2017 | PIT |
5963 | 5963 | Keone Kela | 23 | kelake01 | 2016 | TEX | AL | 1.090281223 | -0.215 | P | 1 | 1 | TEX | 2015 | 2018 | PIT | |
6014 | 6014 | Drew Hutchison | 25 | hutchdr01 | 2016 | TOR | AL | 0.400293541 | -0.03 | P | 0 | 1 | TOR | 2012 | 2016 | PIT | |
6050 | 6050 | Felipe Vazquez | 24 | riverfe01 | 2016 | WSN | NL | 1.617520959 | 0.37 | P | 3 | 1 | WSN | 2015 | 2016 | PIT | |
6092 | 6092 | Daniel Hudson | 28 | hudsoda01 | 2015 | ARI | NL | 2.289035764 | 0.325 | P | 4 | 1 | ARI | CHW | 2010 | 2016 | PIT |
6095 | 6095 | Phil Gosselin | 26 | gosseph01 | 2015 | ARI | NL | 0.741214058 | 0.585 | 2B, 3B, LF | 3 | 2 | ARI | ATL | 2015 | 2016 | PIT |
6121 | 6121 | A.J. Schugel | 26 | schugaj01 | 2015 | ARI | NL | 0.163333172 | -0.33 | P | 0 | 1 | ARI | 2015 | 2015 | PIT | |
6200 | 6200 | Travis Snider | 27 | snidetr01 | 2015 | BAL | AL | 2.287050961 | 0.49 | LF, RF | 5 | 1 | BAL | PIT | 2015 | 2015 | PIT |
6227 | 6227 | Jorge Rondon | 27 | rondojo01 | 2015 | BAL | AL | 0.250257354 | -0.305 | P | 0 | 2 | BAL | COL | 2015 | 2015 | PIT |
6539 | 6539 | Joakim Soria | 31 | soriajo01 | 2015 | DET | AL | 1.763758854 | 0.357204969 | P | 4 | 1 | DET | TEX | 2014 | 2015 | PIT |
6545 | 6545 | Kyle Lobstein | 25 | lobstky01 | 2015 | DET | AL | 1.716600066 | -0.065403727 | P | 2 | 1 | DET | 2014 | 2015 | PIT | |
6565 | 6565 | Neftali Feliz | 27 | felizne01 | 2015 | DET | AL | 0.931310319 | -0.437701863 | P | 0 | 2 | DET | TEX | 2015 | 2015 | PIT |
6610 | 6610 | Michael Feliz | 22 | felizmi01 | 2015 | HOU | AL | 0.123800882 | -0.11 | P | 0 | 1 | HOU | 2015 | 2017 | PIT | |
6640 | 6640 | Joe Blanton | 34 | blantjo01 | 2015 | KCR | AL | 0.990788251 | 0.4 | P | 3 | 1 | KCR | ANA | 2015 | 2015 | PIT |
6666 | 6666 | David Freese | 32 | freesda01 | 2015 | LAA | AL | 4.56769437 | 2.29 | 3B | 14 | 1 | ANA | STL | 2014 | 2015 | PIT |
6694 | 6694 | Matthew Joyce | 30 | joycema01 | 2015 | LAA | AL | 2.760053619 | -1.095 | LF, RF | 1 | 1 | ANA | TBD | 2015 | 2015 | PIT |
6733 | 6733 | Juan Nicasio | 28 | nicasju01 | 2015 | LAD | NL | 1.806399258 | 0.56 | P | 4 | 1 | LAD | COL | 2015 | 2015 | PIT |
6816 | 6816 | Mike Morse | 33 | morsemi01 | 2015 | MIA | NL | 1.77989418 | -0.64 | 1B, LF | 0 | 1 | FLA | SFG | 2015 | 2015 | PIT |
6833 | 6833 | Aramis Ramirez | 37 | ramirar01 | 2015 | MIL | NL | 3.067063562 | 0.43 | 3B, 1B | 6 | 1 | MIL | CHC | 2012 | 2015 | PIT |
6836 | 6836 | Jason Rogers | 27 | rogerja02 | 2015 | MIL | NL | 1.716336894 | 0.595 | 1B, 3B, LF | 4 | 1 | MIL | 2014 | 2015 | PIT | |
6922 | 6922 | Jon Niese | 28 | niesejo01 | 2015 | NYM | NL | 4.890072913 | 0.98 | P | 10 | 1 | NYM | 2008 | 2015 | PIT | |
6980 | 6980 | Ivan Nova | 28 | novaiv01 | 2015 | NYY | AL | 2.630212326 | 0.615 | P | 5 | 1 | NYY | 2010 | 2016 | PIT | |
6995 | 6995 | Cole Figueroa | 28 | figueco01 | 2015 | NYY | AL | 0.074335149 | 0.015 | 3B | 0 | 1 | NYY | TBD | 2015 | 2015 | PIT |
7222 | 7222 | J.A. Happ | 32 | happja01 | 2015 | SEA | AL | 2.894625753 | 0.885 | P | 7 | 1 | SEA | TOR | 2015 | 2015 | PIT |
7276 | 7276 | George Kontos | 30 | kontoge01 | 2015 | SFG | NL | 2.244482361 | 0.735 | P | 5 | 1 | SFG | NYY | 2012 | 2017 | PIT |
7278 | 7278 | Ryan Vogelsong | 37 | vogelry01 | 2015 | SFG | NL | 3.831022354 | -0.16 | P | 5 | 1 | SFG | PIT | 2011 | 2015 | PIT |
7298 | 7298 | Travis Ishikawa | 31 | ishiktr01 | 2015 | SFG | NL | 0.060010347 | -0.09 | 1B, LF | 0 | 1 | SFG | PIT | 2014 | 2015 | PIT |
7333 | 7333 | Tyler Lyons | 27 | lyonsty01 | 2015 | STL | NL | 1.413596249 | 0.315 | P | 3 | 1 | STL | 2013 | 2018 | PIT | |
7357 | 7357 | Chris Archer | 26 | archech01 | 2015 | TBR | AL | 5.662202403 | 4.53 | P | 21 | 1 | TBD | 2012 | 2018 | PIT | |
7371 | 7371 | John Jaso | 31 | jasojo01 | 2015 | TBR | AL | 2.070401587 | 0.845 | LF, RF | 5 | 1 | TBD | OAK | 2015 | 2015 | PIT |
7416 | 7416 | Keone Kela | 22 | kelake01 | 2015 | TEX | AL | 2.176290916 | 1.625 | P | 8 | 1 | TEX | 2015 | 2018 | PIT | |
7483 | 7483 | Drew Hutchison | 24 | hutchdr01 | 2015 | TOR | AL | 4.223728699 | -0.025 | P | 5 | 1 | TOR | 2012 | 2016 | PIT | |
7530 | 7530 | Felipe Vazquez | 23 | riverfe01 | 2015 | WSN | NL | 1.485513596 | 1.005 | P | 5 | 1 | WSN | 2015 | 2016 | PIT | |
7598 | 7598 | Daniel Hudson | 27 | hudsoda01 | 2014 | ARI | NL | 0.074176476 | -0.085 | P | 0 | 1 | ARI | CHW | 2010 | 2016 | PIT |
7692 | 7692 | Steve Lombardozzi | 25 | lombast02 | 2014 | BAL | AL | 0.702685003 | -0.235 | 2B | 0 | 1 | BAL | WSN | 2014 | 2014 | PIT |
7865 | 7865 | Curtis Partch | 27 | partccu01 | 2014 | CIN | NL | 0.135508369 | 0.125 | P | 1 | 1 | CIN | 2013 | 2014 | PIT | |
7914 | 7914 | John Axford | 31 | axforjo01 | 2014 | CLE | AL | 1.455653913 | -0.13 | P | 2 | 1 | CLE | STL | 2014 | 2014 | PIT |
7968 | 7968 | Rob Scahill | 27 | scahiro01 | 2014 | COL | NL | 0.488137184 | -0.2 | P | 0 | 1 | COL | 2012 | 2014 | PIT | |
8001 | 8001 | Kyle Lobstein | 24 | lobstky01 | 2014 | DET | AL | 1.047108452 | 0.48 | P | 3 | 1 | DET | 2014 | 2015 | PIT | |
8020 | 8020 | Joakim Soria | 30 | soriajo01 | 2014 | DET | AL | 0.387674157 | -0.125 | P | 0 | 2 | DET | TEX | 2014 | 2015 | PIT |
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 );