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,176 rows where prev_franch = "PIT"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
71 | 71 | Francisco Cervelli | 33 | cervefr01 | 2019 | ATL | NL | 0.30745554 | 0.463584906 | C, 1B | 2 | 2 | ATL | PIT | 2019 | 2019 | |
165 | 165 | Brock Holt | 31 | holtbr01 | 2019 | BOS | AL | 2.597287922 | 1.309245283 | 2B, 1B, RF, SS, 3B, LF | 7 | 1 | BOS | PIT | 2013 | 2019 | |
257 | 257 | Ivan Nova | 32 | novaiv01 | 2019 | CHW | AL | 5.468501452 | 1.978860759 | P | 14 | 1 | CHW | PIT | 2019 | 2019 | |
326 | 326 | Ryan Lavarnway | 31 | lavarry01 | 2019 | CIN | NL | 0.196085409 | 0.208867925 | C | 1 | 1 | CIN | PIT | 2019 | 2019 | |
355 | 355 | Jordan Luplow | 25 | luplojo01 | 2019 | CLE | AL | 2.473842053 | 1.676037736 | RF, LF, CF | 9 | 1 | CLE | PIT | 2019 | 2019 | |
397 | 397 | Max Moroff | 26 | morofma01 | 2019 | CLE | AL | 0.338220593 | -0.290377358 | 2B, SS, 3B | 0 | 1 | CLE | PIT | 2019 | 2019 | |
464 | 464 | Jordy Mercer | 32 | mercejo03 | 2019 | DET | AL | 2.569930661 | 0.410126582 | SS, 2B, 1B, 3B | 4 | 1 | DET | PIT | 2019 | 2019 | |
502 | 502 | Josh Harrison | 31 | harrijo05 | 2019 | DET | AL | 1.441907661 | -0.794620253 | 2B | 0 | 1 | DET | PIT | 2019 | 2019 | |
505 | 505 | Gerrit Cole | 28 | colege01 | 2019 | HOU | AL | 5.97893196 | 7.01490566 | P | 28 | 1 | HOU | PIT | 2018 | 2019 | |
670 | 670 | David Freese | 36 | freesda01 | 2019 | LAD | NL | 1.839048768 | 1.502830189 | 1B, 3B | 7 | 1 | LAD | PIT | 2018 | 2019 | |
768 | 768 | Jordan Lyles | 28 | lylesjo01 | 2019 | MIL | NL | 1.593452434 | 1.237924528 | P | 6 | 2 | MIL | PIT | 2019 | 2019 | |
948 | 948 | Tyler Lyons | 31 | lyonsty01 | 2019 | NYY | AL | 0.16714728 | -0.050943396 | P | 0 | 2 | NYY | PIT | 2019 | 2019 | |
994 | 994 | Tanner Anderson | 26 | anderta01 | 2019 | OAK | AL | 0.612779902 | 4.41864e-18 | P | 1 | 1 | OAK | PIT | 2019 | 2019 | |
1025 | 1025 | Corey Dickerson | 30 | dickeco01 | 2019 | PHI | NL | 1.366466036 | 0.341320755 | LF | 3 | 2 | PHI | PIT | 2019 | 2019 | |
1034 | 1034 | Sean Rodriguez | 34 | rodrise01 | 2019 | PHI | NL | 1.256749785 | 0.081509434 | 3B, LF, SS, RF, 2B, CF, P, 1B | 2 | 1 | PHI | PIT | 2019 | 2019 | |
1188 | 1188 | Wade LeBlanc | 34 | leblawa01 | 2019 | SEA | AL | 3.51692973 | 0.076415094 | P | 5 | 1 | SEA | PIT | 2018 | 2019 | |
1346 | 1346 | Austin Meadows | 24 | meadoau01 | 2019 | TBR | AL | 5.489673118 | 4.034716981 | RF, LF, CF | 20 | 1 | TBD | PIT | 2018 | 2019 | |
1358 | 1358 | Tyler Glasnow | 25 | glasnty01 | 2019 | TBR | AL | 1.503926621 | 2.261886792 | P | 9 | 1 | TBD | PIT | 2018 | 2019 | |
1382 | 1382 | Casey Sadler | 28 | sadleca02 | 2019 | TBR | AL | 0.377393052 | 0.229245283 | P | 1 | 1 | TBD | PIT | 2019 | 2019 | LAD |
1483 | 1483 | Nick Kingham | 27 | kinghni01 | 2019 | TOR | AL | 0.642093146 | 0.229245283 | P | 2 | 2 | TOR | PIT | 2019 | 2019 | |
1657 | 1657 | Chris Stewart | 36 | stewach01 | 2018 | ATL | NL | 0.156677359 | -0.065 | C | 0 | 1 | ATL | PIT | 2018 | 2018 | ARI |
1706 | 1706 | Pedro Alvarez | 31 | alvarpe01 | 2018 | BAL | AL | 1.225420063 | -0.125 | 3B, 1B | 1 | 1 | BAL | PIT | 2016 | 2018 | |
1738 | 1738 | Brock Holt | 30 | holtbr01 | 2018 | BOS | AL | 3.388411334 | 1.34 | 2B, SS, RF, 1B, LF, 3B | 9 | 1 | BOS | PIT | 2013 | 2019 | |
1866 | 1866 | Chris Volstad | 31 | volstch01 | 2018 | CHW | AL | 1.366342588 | -0.45 | P | 0 | 1 | CHW | PIT | 2017 | 2018 | |
1961 | 1961 | George Kontos | 33 | kontoge01 | 2018 | CLE | AL | 0.083673474 | 0.03 | P | 0 | 2 | CLE | PIT | 2018 | 2018 | NYY |
2052 | 2052 | Josh Smoker | 29 | smokejo01 | 2018 | DET | AL | 0.031040278 | 0.035 | P | 0 | 2 | DET | PIT | 2018 | 2018 | |
2060 | 2060 | Johnny Barbato | 25 | barbajo01 | 2018 | DET | AL | 0.154200093 | -0.395 | P | 0 | 1 | DET | PIT | 2018 | 2018 | |
2067 | 2067 | Gerrit Cole | 27 | colege01 | 2018 | HOU | AL | 5.479454313 | 5.505 | P | 24 | 1 | HOU | PIT | 2018 | 2019 | |
2147 | 2147 | Enny Romero | 27 | romeren01 | 2018 | KCR | AL | 0.11306793 | -0.485 | P | 0 | 3 | KCR | PIT | 2018 | 2018 | |
2239 | 2239 | David Freese | 35 | freesda01 | 2018 | LAD | NL | 0.452448133 | 0.601288344 | 3B, 1B | 2 | 2 | LAD | PIT | 2018 | 2019 | |
2252 | 2252 | Daniel Hudson | 31 | hudsoda01 | 2018 | LAD | NL | 1.33880385 | -0.248466258 | P | 1 | 1 | LAD | PIT | 2018 | 2018 | TOR |
2300 | 2300 | Christopher Bostick | 25 | bostich01 | 2018 | MIA | NL | 0.16 | -0.010062112 | 2B, LF | 0 | 2 | FLA | PIT | 2018 | 2018 | |
2335 | 2335 | Keon Broxton | 28 | broxtke01 | 2018 | MIL | NL | 0.872696534 | 1.361595092 | CF, RF | 5 | 1 | MIL | PIT | 2016 | 2018 | NYM |
2520 | 2520 | Adeiny Hechavarria | 29 | hechaad01 | 2018 | NYY | AL | 0.343414946 | -0.035 | SS, 3B | 0 | 3 | NYY | PIT | 2018 | 2018 | NYM |
2552 | 2552 | Matthew Joyce | 33 | joycema01 | 2018 | OAK | AL | 2.288739172 | 0.125 | LF, RF, CF | 4 | 1 | OAK | PIT | 2017 | 2018 | ATL |
2615 | 2615 | Drew Hutchison | 27 | hutchdr01 | 2018 | PHI | NL | 0.492376483 | 0.055 | P | 1 | 1 | PHI | PIT | 2018 | 2018 | TEX |
2628 | 2628 | Pedro Florimon | 31 | floripe01 | 2018 | PHI | NL | 0.755311857 | -0.32 | SS, 2B, RF, P, 3B, CF | 0 | 1 | PHI | PIT | 2017 | 2018 | |
2736 | 2736 | Wade LeBlanc | 33 | leblawa01 | 2018 | SEA | AL | 4.209909746 | 2.01 | P | 13 | 1 | SEA | PIT | 2018 | 2019 | |
2783 | 2783 | Andrew McCutchen | 31 | mccutan01 | 2018 | SFG | NL | 5.680979479 | 1.925 | RF, LF | 15 | 1 | SFG | PIT | 2018 | 2018 | NYY |
2792 | 2792 | Gorkys Hernandez | 30 | hernago01 | 2018 | SFG | NL | 4.51077772 | 0.36 | CF, LF, RF | 8 | 1 | SFG | PIT | 2016 | 2018 | BOS |
2902 | 2902 | Tyler Glasnow | 24 | glasnty01 | 2018 | TBR | AL | 1.475825752 | 0.565 | P | 4 | 2 | TBD | PIT | 2018 | 2019 | |
2926 | 2926 | Austin Meadows | 23 | meadoau01 | 2018 | TBR | AL | 0.244289648 | -0.115 | CF, RF, LF | 0 | 2 | TBD | PIT | 2018 | 2019 | |
2986 | 2986 | J.A. Happ | 35 | happja01 | 2018 | TOR | AL | 3.291628169 | 1.69 | P | 10 | 1 | TOR | PIT | 2016 | 2018 | NYY |
2988 | 2988 | Russell Martin | 35 | martiru01 | 2018 | TOR | AL | 3.373430271 | 1.225 | C, 3B, SS, LF | 9 | 1 | TOR | PIT | 2015 | 2018 | LAD |
3028 | 3028 | Brandon Cumpton | 29 | cumptbr01 | 2018 | TOR | AL | 0.034556567 | 0.005 | P | 0 | 1 | TOR | PIT | 2018 | 2018 | |
3043 | 3043 | Gift Ngoepe | 28 | ngoepgi01 | 2018 | TOR | AL | 0.182088566 | -0.295 | SS, 2B, 3B | 0 | 1 | TOR | PIT | 2018 | 2018 | |
3181 | 3181 | Tony Sanchez | 29 | sanchto01 | 2017 | ATL | NL | 0.009840516 | -0.015 | 0 | 1 | ATL | PIT | 2017 | 2017 | ||
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 |
3220 | 3220 | Pedro Alvarez | 30 | alvarpe01 | 2017 | BAL | AL | 0.322116955 | 0.1 | 1B | 1 | 1 | BAL | PIT | 2016 | 2018 | |
3276 | 3276 | Brock Holt | 29 | holtbr01 | 2017 | BOS | AL | 1.506254949 | -0.435 | 2B, LF, 3B, 1B, RF | 1 | 1 | BOS | PIT | 2013 | 2019 | |
3373 | 3373 | Chris Volstad | 30 | volstch01 | 2017 | CHW | AL | 0.497441876 | 0.03 | P | 1 | 1 | CHW | PIT | 2017 | 2018 | |
3376 | 3376 | Alen Hanson | 24 | hansoal01 | 2017 | CHW | AL | 1.680741845 | -0.35 | RF, 2B, CF, LF, SS, 3B | 1 | 2 | CHW | PIT | 2017 | 2017 | SFG |
3628 | 3628 | Joakim Soria | 33 | soriajo01 | 2017 | KCR | AL | 2.04029238 | 1.375 | P | 7 | 1 | KCR | PIT | 2016 | 2017 | CHW |
3698 | 3698 | Deolis Guerra | 28 | guerrde01 | 2017 | LAA | AL | 0.662477005 | -0.06 | P | 1 | 1 | ANA | PIT | 2016 | 2017 | MIL |
3743 | 3743 | Tony Watson | 32 | watsoto01 | 2017 | LAD | NL | 0.695066997 | 0.24 | P | 2 | 2 | LAD | PIT | 2017 | 2017 | SFG |
3805 | 3805 | Steve Lombardozzi | 28 | lombast02 | 2017 | MIA | NL | 0.078246206 | -0.2 | 2B | 0 | 1 | FLA | PIT | 2017 | 2017 | |
3808 | 3808 | Jeff Locke | 29 | lockeje01 | 2017 | MIA | NL | 0.917377276 | -0.465 | P | 0 | 1 | FLA | PIT | 2017 | 2017 | |
3824 | 3824 | Keon Broxton | 27 | broxtke01 | 2017 | MIL | NL | 4.614882282 | 0.585 | CF | 9 | 1 | MIL | PIT | 2016 | 2018 | NYM |
3830 | 3830 | Jared Hughes | 31 | hugheja02 | 2017 | MIL | NL | 1.795446814 | 0.85 | P | 5 | 1 | MIL | PIT | 2017 | 2017 | CIN |
3857 | 3857 | Rob Scahill | 30 | scahiro01 | 2017 | MIL | NL | 0.635978136 | -0.26 | P | 0 | 1 | MIL | PIT | 2016 | 2017 | CHW |
3861 | 3861 | Neftali Feliz | 29 | felizne01 | 2017 | MIL | NL | 0.959104741 | -0.87 | P | 0 | 1 | MIL | PIT | 2017 | 2017 | KCR |
3923 | 3923 | Neil Walker | 31 | walkene01 | 2017 | NYM | NL | 2.966980325 | 1.27 | 2B, 1B, 3B | 8 | 1 | NYM | PIT | 2016 | 2017 | MIL |
4003 | 4003 | Erik Kratz | 37 | kratzer01 | 2017 | NYY | AL | 0.01832833 | 0.105 | C | 0 | 1 | NYY | PIT | 2017 | 2017 | MIL |
4020 | 4020 | Matthew Joyce | 32 | joycema01 | 2017 | OAK | AL | 5.169916435 | 2.25 | RF, LF, CF | 14 | 1 | OAK | PIT | 2017 | 2018 | ATL |
4099 | 4099 | Pedro Florimon | 30 | floripe01 | 2017 | PHI | NL | 0.487729535 | 0.62 | CF, RF, SS, 2B, 3B, LF | 2 | 1 | PHI | PIT | 2017 | 2018 | |
4107 | 4107 | Juan Nicasio | 30 | nicasju01 | 2017 | PHI | NL | 0.038153419 | 0.035 | P | 0 | 2 | PHI | PIT | 2017 | 2017 | STL |
4116 | 4116 | Jeanmar Gomez | 29 | gomezje01 | 2017 | PHI | NL | 0.723602802 | -0.565 | P | 0 | 1 | PHI | PIT | 2015 | 2017 | CHW |
4301 | 4301 | Gorkys Hernandez | 29 | hernago01 | 2017 | SFG | NL | 3.468637223 | -0.145 | LF, CF, RF | 4 | 1 | SFG | PIT | 2016 | 2018 | BOS |
4320 | 4320 | Mike Morse | 35 | morsemi01 | 2017 | SFG | NL | 0.398693934 | -0.375 | 1B, LF | 0 | 1 | SFG | PIT | 2017 | 2017 | |
4374 | 4374 | Eric Fryer | 31 | fryerer01 | 2017 | STL | NL | 0.817456274 | -0.275 | C | 0 | 1 | STL | PIT | 2017 | 2017 | |
4464 | 4464 | Jhan Marinez | 28 | marinjh01 | 2017 | TEX | AL | 0.124598901 | 0.085 | P | 0 | 3 | TEX | PIT | 2017 | 2017 | BAL |
4473 | 4473 | Phil Gosselin | 28 | gosseph01 | 2017 | TEX | AL | 0.076140466 | -0.135 | 2B, SS, 3B, 1B | 0 | 2 | TEX | PIT | 2017 | 2017 | CIN |
4487 | 4487 | J.A. Happ | 34 | happja01 | 2017 | TOR | AL | 3.888934576 | 3.105 | P | 15 | 1 | TOR | PIT | 2016 | 2018 | NYY |
4490 | 4490 | Russell Martin | 34 | martiru01 | 2017 | TOR | AL | 3.453507341 | 1.835 | C, 3B | 10 | 1 | TOR | PIT | 2015 | 2018 | LAD |
4494 | 4494 | Jose Bautista | 36 | bautijo02 | 2017 | TOR | AL | 6.490701468 | -0.91 | RF, 3B, 1B | 7 | 1 | TOR | PIT | 2008 | 2017 | ATL |
4503 | 4503 | Francisco Liriano | 33 | liriafr01 | 2017 | TOR | AL | 2.21205453 | 0.27 | P | 4 | 1 | TOR | PIT | 2016 | 2017 | HOU |
4714 | 4714 | Pedro Alvarez | 29 | alvarpe01 | 2016 | BAL | AL | 3.598086124 | 1.06 | 3B | 9 | 1 | BAL | PIT | 2016 | 2018 | |
4719 | 4719 | Vance Worley | 28 | worleva01 | 2016 | BAL | AL | 2.225925166 | 0.81 | P | 6 | 1 | BAL | PIT | 2016 | 2016 | FLA |
4761 | 4761 | Brock Holt | 28 | holtbr01 | 2016 | BOS | AL | 2.986175115 | 0.85 | LF, 3B, 2B, SS, RF | 6 | 1 | BOS | PIT | 2013 | 2019 | |
4979 | 4979 | Michael Martinez | 33 | martimi02 | 2016 | CLE | AL | 0.936704731 | -0.090559006 | 2B, CF, LF, RF, SS, 3B | 1 | 1 | CLE | PIT | 2015 | 2016 | BOS |
5141 | 5141 | Edinson Volquez | 32 | volqued01 | 2016 | KCR | AL | 5.304579749 | 0.32 | P | 9 | 1 | KCR | PIT | 2015 | 2016 | FLA |
5146 | 5146 | Joakim Soria | 32 | soriajo01 | 2016 | KCR | AL | 2.507060173 | 0.295 | P | 5 | 1 | KCR | PIT | 2016 | 2017 | CHW |
5190 | 5190 | Deolis Guerra | 27 | guerrde01 | 2016 | LAA | AL | 1.518345939 | 0.4 | P | 3 | 1 | ANA | PIT | 2016 | 2017 | MIL |
5234 | 5234 | Joe Blanton | 35 | blantjo01 | 2016 | LAD | NL | 2.520106986 | 1.295 | P | 7 | 1 | LAD | PIT | 2016 | 2016 | WSN |
5321 | 5321 | Bryan Morris | 29 | morribr01 | 2016 | MIA | NL | 0.585777929 | -0.160993789 | P | 0 | 1 | FLA | PIT | 2014 | 2016 | SFG |
5339 | 5339 | Keon Broxton | 26 | broxtke01 | 2016 | MIL | NL | 2.460361613 | 1.875 | CF | 9 | 1 | MIL | PIT | 2016 | 2018 | NYM |
5356 | 5356 | Rob Scahill | 29 | scahiro01 | 2016 | MIL | NL | 0.392186402 | 0.33 | P | 2 | 2 | MIL | PIT | 2016 | 2017 | CHW |
5435 | 5435 | Neil Walker | 30 | walkene01 | 2016 | NYM | NL | 4.586325967 | 3.1 | 2B | 15 | 1 | NYM | PIT | 2016 | 2017 | MIL |
5467 | 5467 | Antonio Bastardo | 30 | bastaan01 | 2016 | NYM | NL | 1.14278566 | -0.135 | P | 1 | 1 | NYM | PIT | 2016 | 2016 | PIT |
5474 | 5474 | Jon Niese | 29 | niesejo01 | 2016 | NYM | NL | 0.253528307 | -0.425 | P | 0 | 2 | NYM | PIT | 2016 | 2016 | |
5565 | 5565 | Andrew Lambo | 27 | lamboan01 | 2016 | OAK | AL | 0.00966989 | -0.015 | 0 | 1 | OAK | PIT | 2016 | 2016 | ||
5594 | 5594 | Jeanmar Gomez | 28 | gomezje01 | 2016 | PHI | NL | 2.7587836 | 0.16 | P | 5 | 1 | PHI | PIT | 2015 | 2017 | CHW |
5601 | 5601 | Charlie Morton | 32 | mortoch02 | 2016 | PHI | NL | 0.487735205 | 0.335 | P | 2 | 1 | PHI | PIT | 2016 | 2016 | HOU |
5791 | 5791 | Arquimedes Caminero | 29 | caminar01 | 2016 | SEA | AL | 0.56047988 | -0.23 | P | 0 | 2 | SEA | PIT | 2016 | 2016 | |
5823 | 5823 | Gorkys Hernandez | 28 | hernago01 | 2016 | SFG | NL | 0.560433972 | 0.385 | CF, RF, LF | 2 | 1 | SFG | PIT | 2016 | 2018 | BOS |
5831 | 5831 | Javier Lopez | 38 | lopezja02 | 2016 | SFG | NL | 0.998984827 | -0.245 | P | 1 | 1 | SFG | PIT | 2010 | 2016 | |
5927 | 5927 | Jaff Decker | 26 | deckeja01 | 2016 | TBR | AL | 0.549078226 | -0.655 | RF, LF, CF | 0 | 1 | TBD | PIT | 2016 | 2016 | OAK |
5985 | 5985 | J.A. Happ | 33 | happja01 | 2016 | TOR | AL | 5.335052624 | 3.835 | P | 19 | 1 | TOR | PIT | 2016 | 2018 | NYY |
5989 | 5989 | Russell Martin | 33 | martiru01 | 2016 | TOR | AL | 5.00483871 | 2.69 | C, 2B, 3B | 15 | 1 | TOR | PIT | 2015 | 2018 | LAD |
5994 | 5994 | Jose Bautista | 35 | bautijo02 | 2016 | TOR | AL | 4.836451613 | 1.295 | RF, 1B | 10 | 1 | TOR | PIT | 2008 | 2017 | ATL |
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 );