mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
3,029 rows where next_franch = "PHI"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
325 | 325 | Jared Hughes | 33 | hugheja02 | 2019 | CIN | NL | 1.449513691 | 0.020377358 | P | 2 | 1 | CIN | MIL | 2018 | 2019 | PHI |
377 | 377 | Brad Miller | 29 | millebr02 | 2019 | CLE | AL | 0.386537821 | 0.147735849 | 3B, LF, 2B, RF, SS | 1 | 1 | CLE | MIL | 2019 | 2019 | PHI |
831 | 831 | Blake Parker | 34 | parkebl01 | 2019 | MIN | AL | 1.287406119 | 0.045849057 | P | 2 | 1 | MIN | ANA | 2019 | 2019 | PHI |
834 | 834 | Mike Morin | 28 | morinmi01 | 2019 | MIN | AL | 0.584721861 | 0.142641509 | P | 1 | 1 | MIN | SEA | 2019 | 2019 | PHI |
864 | 864 | Jason Vargas | 36 | vargaja01 | 2019 | NYM | NL | 2.565052544 | 1.21245283 | P | 7 | 1 | NYM | KCR | 2018 | 2019 | PHI |
1079 | 1079 | Corey Dickerson | 30 | dickeco01 | 2019 | PIT | NL | 1.418044077 | 0.54 | LF | 4 | 1 | PIT | TBD | 2018 | 2019 | PHI |
1160 | 1160 | Jose Pirela | 29 | pireljo01 | 2019 | SDP | NL | 0.051491477 | -0.13245283 | LF, RF | 0 | 1 | SDP | NYY | 2016 | 2019 | PHI |
1190 | 1190 | Jay Bruce | 32 | bruceja01 | 2019 | SEA | AL | 1.75931421 | 0.453396226 | LF, RF, 1B | 4 | 1 | SEA | NYM | 2019 | 2019 | PHI |
1296 | 1296 | Nick Vincent | 32 | vinceni01 | 2019 | SFG | NL | 0.683567224 | -0.320943396 | P | 0 | 1 | SFG | SEA | 2019 | 2019 | PHI |
1453 | 1453 | Drew Smyly | 30 | smylydr01 | 2019 | TEX | AL | 1.430486287 | -0.80490566 | P | 0 | 1 | TEX | TBD | 2019 | 2019 | PHI |
1597 | 1597 | Fernando Salas | 33 | salasfe01 | 2018 | ARI | NL | 1.101047812 | -0.12 | P | 1 | 1 | ARI | ANA | 2018 | 2018 | PHI |
1839 | 1839 | Luis Avilan | 28 | avilalu01 | 2018 | CHW | AL | 1.300090207 | 0.62 | P | 4 | 1 | CHW | LAD | 2018 | 2018 | PHI |
1877 | 1877 | Jared Hughes | 32 | hugheja02 | 2018 | CIN | NL | 2.881136849 | 2.315 | P | 11 | 1 | CIN | MIL | 2018 | 2019 | PHI |
1912 | 1912 | Phil Gosselin | 29 | gosseph01 | 2018 | CIN | NL | 0.275581198 | -0.155 | 3B, 1B, 2B, LF | 0 | 1 | CIN | TEX | 2018 | 2018 | PHI |
2165 | 2165 | Jose Alvarez | 29 | alvarjo02 | 2018 | LAA | AL | 2.391549137 | 1.305 | P | 7 | 1 | ANA | DET | 2014 | 2018 | PHI |
2267 | 2267 | J.T. Realmuto | 27 | realmjt01 | 2018 | MIA | NL | 5.31 | 4.613478261 | C, 1B | 22 | 1 | FLA | 2014 | 2018 | PHI | |
2273 | 2273 | Justin Bour | 30 | bourju01 | 2018 | MIA | NL | 4.47 | 0.598695652 | 1B | 9 | 1 | FLA | 2014 | 2018 | PHI | |
2399 | 2399 | Logan Morrison | 30 | morrilo01 | 2018 | MIN | AL | 3.395629485 | -0.505 | 1B, LF | 3 | 1 | MIN | TBD | 2018 | 2018 | PHI |
2431 | 2431 | Asdrubal Cabrera | 32 | cabreas01 | 2018 | NYM | NL | 4.039356605 | 1.81 | 2B, SS, 3B | 11 | 1 | NYM | TBD | 2016 | 2018 | PHI |
2436 | 2436 | Jose Bautista | 37 | bautijo02 | 2018 | NYM | NL | 2.997262149 | 0.875 | RF, LF, 3B, 1B, 2B | 7 | 2 | NYM | ATL | 2018 | 2018 | PHI |
2445 | 2445 | Jason Vargas | 35 | vargaja01 | 2018 | NYM | NL | 2.514255062 | 0.02 | P | 3 | 1 | NYM | KCR | 2018 | 2019 | PHI |
2499 | 2499 | David Robertson | 33 | roberda08 | 2018 | NYY | AL | 2.524279884 | 1.175 | P | 7 | 1 | NYY | CHW | 2017 | 2018 | PHI |
2503 | 2503 | Andrew McCutchen | 31 | mccutan01 | 2018 | NYY | AL | 1.058089294 | 0.78 | RF, LF | 4 | 2 | NYY | SFG | 2018 | 2018 | PHI |
2633 | 2633 | Corey Dickerson | 29 | dickeco01 | 2018 | PIT | NL | 5.375412972 | 3.250062112 | LF | 18 | 1 | PIT | TBD | 2018 | 2019 | PHI |
2658 | 2658 | Sean Rodriguez | 33 | rodrise01 | 2018 | PIT | NL | 1.744740045 | -0.206273292 | 2B, SS, LF, CF, RF, 1B, 3B | 2 | 1 | PIT | ATL | 2017 | 2018 | PHI |
2696 | 2696 | Jose Pirela | 28 | pireljo01 | 2018 | SDP | NL | 4.757891086 | -0.43 | 2B, LF, 1B, RF | 6 | 1 | SDP | NYY | 2016 | 2019 | PHI |
2729 | 2729 | Jean Segura | 28 | segurje01 | 2018 | SEA | AL | 6.043858203 | 4.02 | SS | 22 | 1 | SEA | ARI | 2017 | 2018 | PHI |
2755 | 2755 | Juan Nicasio | 31 | nicasju01 | 2018 | SEA | AL | 1.615357962 | -0.2 | P | 2 | 1 | SEA | STL | 2018 | 2018 | PHI |
2888 | 2888 | Wilson Ramos | 30 | ramoswi01 | 2018 | TBR | AL | 2.959663049 | 1.75 | C | 9 | 1 | TBD | WSN | 2017 | 2018 | PHI |
3013 | 3013 | Aaron Loup | 30 | loupaa01 | 2018 | TOR | AL | 0.887412633 | 0.225 | P | 2 | 1 | TOR | 2012 | 2018 | PHI | |
3050 | 3050 | Bryce Harper | 25 | harpebr03 | 2018 | WSN | NL | 6.7782075 | 2.35 | RF, CF, 1B | 15 | 1 | WSN | 2012 | 2018 | PHI | |
3225 | 3225 | Hyun Soo Kim | 29 | kimhy01 | 2017 | BAL | AL | 1.34531199 | -0.345 | LF, RF | 1 | 1 | BAL | 2016 | 2017 | PHI | |
3296 | 3296 | Jake Arrieta | 31 | arrieja01 | 2017 | CHC | NL | 4.743309471 | 2.24 | P | 14 | 1 | CHC | BAL | 2013 | 2017 | PHI |
3369 | 3369 | Rob Brantly | 27 | brantro01 | 2017 | CHW | AL | 0.345752608 | 0.245 | C, P | 1 | 1 | CHW | FLA | 2015 | 2017 | PHI |
3440 | 3440 | Carlos Santana | 31 | santaca01 | 2017 | CLE | AL | 6.2266216 | 3.095 | 1B, RF | 17 | 1 | CLE | 2010 | 2017 | PHI | |
3495 | 3495 | Pat Neshek | 36 | neshepa01 | 2017 | COL | NL | 0.842045389 | 0.835 | P | 4 | 2 | COL | PHI | 2017 | 2017 | PHI |
3688 | 3688 | Jose Alvarez | 28 | alvarjo02 | 2017 | LAA | AL | 1.579424577 | 0.33 | P | 3 | 1 | ANA | DET | 2014 | 2018 | PHI |
3772 | 3772 | J.T. Realmuto | 26 | realmjt01 | 2017 | MIA | NL | 5.66306914 | 4.145 | C, 1B | 20 | 1 | FLA | 2014 | 2018 | PHI | |
3774 | 3774 | Justin Bour | 29 | bourju01 | 2017 | MIA | NL | 4.195952782 | 2.395 | 1B | 13 | 1 | FLA | 2014 | 2018 | PHI | |
3918 | 3918 | Asdrubal Cabrera | 31 | cabreas01 | 2017 | NYM | NL | 5.358426005 | 1.345 | SS, 3B, 2B | 11 | 1 | NYM | TBD | 2016 | 2018 | PHI |
3951 | 3951 | Ty Kelly | 28 | kellyty01 | 2017 | NYM | NL | 0.009923011 | -0.015 | 2B, LF, 3B, RF, CF | 0 | 1 | NYM | 2016 | 2017 | PHI | |
3980 | 3980 | David Robertson | 32 | roberda08 | 2017 | NYY | AL | 1.214731994 | 1.45 | P | 6 | 2 | NYY | CHW | 2017 | 2018 | PHI |
4135 | 4135 | Juan Nicasio | 30 | nicasju01 | 2017 | PIT | NL | 2.226868641 | 1.37 | P | 7 | 1 | PIT | LAD | 2016 | 2017 | PHI |
4154 | 4154 | Sean Rodriguez | 32 | rodrise01 | 2017 | PIT | NL | 1.057629451 | -0.295 | 3B, RF, 2B, SS, LF, CF, 1B | 1 | 2 | PIT | ATL | 2017 | 2018 | PHI |
4174 | 4174 | Jose Pirela | 27 | pireljo01 | 2017 | SDP | NL | 3.533203471 | 1.975 | LF, 2B, 1B, RF, 3B | 12 | 1 | SDP | NYY | 2016 | 2019 | PHI |
4226 | 4226 | Jean Segura | 27 | segurje01 | 2017 | SEA | AL | 5.347450725 | 3.1 | SS | 16 | 1 | SEA | ARI | 2017 | 2018 | PHI |
4265 | 4265 | Zac Curtis | 24 | curtiza01 | 2017 | SEA | AL | 0.076647646 | -0.05 | P | 0 | 1 | SEA | ARI | 2017 | 2017 | PHI |
4278 | 4278 | Casey Fien | 33 | fienca01 | 2017 | SEA | AL | 0.165132766 | -0.42 | P | 0 | 1 | SEA | LAD | 2017 | 2017 | PHI |
4362 | 4362 | Kevin Siegrist | 27 | siegrke01 | 2017 | STL | NL | 0.985747175 | -0.05 | P | 1 | 1 | STL | 2013 | 2017 | PHI | |
4392 | 4392 | Tommy Hunter | 30 | hunteto02 | 2017 | TBR | AL | 2.038236868 | 1.205 | P | 6 | 1 | TBD | BAL | 2017 | 2017 | PHI |
4405 | 4405 | Wilson Ramos | 29 | ramoswi01 | 2017 | TBR | AL | 2.122182293 | 0.165 | C | 3 | 1 | TBD | WSN | 2017 | 2018 | PHI |
4430 | 4430 | Trevor Plouffe | 31 | plouftr01 | 2017 | TBR | AL | 1.080039203 | -0.52 | 3B, 1B, 2B | 0 | 2 | TBD | OAK | 2017 | 2017 | PHI |
4499 | 4499 | Aaron Loup | 29 | loupaa01 | 2017 | TOR | AL | 1.682620837 | 0.715 | P | 5 | 1 | TOR | 2012 | 2018 | PHI | |
4547 | 4547 | Bryce Harper | 24 | harpebr03 | 2017 | WSN | NL | 4.877948718 | 4.705 | RF | 21 | 1 | WSN | 2012 | 2018 | PHI | |
4717 | 4717 | Hyun Soo Kim | 28 | kimhy01 | 2016 | BAL | AL | 3.311004785 | 0.83 | LF | 7 | 1 | BAL | 2016 | 2017 | PHI | |
4764 | 4764 | Clay Buchholz | 31 | buchhcl01 | 2016 | BOS | AL | 3.717355064 | 0.285 | P | 5 | 1 | BOS | 2007 | 2016 | PHI | |
4803 | 4803 | Jake Arrieta | 30 | arrieja01 | 2016 | CHC | NL | 5.543681214 | 4.445 | P | 21 | 1 | CHC | BAL | 2013 | 2017 | PHI |
4950 | 4950 | Carlos Santana | 30 | santaca01 | 2016 | CLE | AL | 6.509624796 | 3.26515528 | 1B | 19 | 1 | CLE | 2010 | 2017 | PHI | |
5105 | 5105 | Pat Neshek | 35 | neshepa01 | 2016 | HOU | AL | 1.501277473 | 0.54 | P | 4 | 1 | HOU | STL | 2015 | 2016 | PHI |
5163 | 5163 | Daniel Nava | 33 | navada01 | 2016 | KCR | AL | 0.115403747 | -0.16 | LF, 1B, RF | 0 | 2 | KCR | ANA | 2016 | 2016 | PHI |
5187 | 5187 | Jose Alvarez | 27 | alvarjo02 | 2016 | LAA | AL | 1.819526035 | 0.405 | P | 4 | 1 | ANA | DET | 2014 | 2018 | PHI |
5233 | 5233 | Howie Kendrick | 32 | kendrho01 | 2016 | LAD | NL | 5.387273349 | 0.555 | LF, 2B, 3B, 1B | 9 | 1 | LAD | ANA | 2015 | 2016 | PHI |
5260 | 5260 | A.J. Ellis | 35 | ellisaj01 | 2016 | LAD | NL | 1.597331509 | -0.315 | C | 1 | 1 | LAD | 2008 | 2016 | PHI | |
5282 | 5282 | J.T. Realmuto | 25 | realmjt01 | 2016 | MIA | NL | 5.434072546 | 2.369627329 | C | 14 | 1 | FLA | 2014 | 2018 | PHI | |
5290 | 5290 | Justin Bour | 28 | bourju01 | 2016 | MIA | NL | 3.200618876 | 1.232608696 | 1B | 8 | 1 | FLA | 2014 | 2018 | PHI | |
5432 | 5432 | Asdrubal Cabrera | 30 | cabreas01 | 2016 | NYM | NL | 5.687845304 | 3.2 | SS | 17 | 1 | NYM | TBD | 2016 | 2018 | PHI |
5457 | 5457 | Ty Kelly | 27 | kellyty01 | 2016 | NYM | NL | 0.710980663 | 0.445 | 3B, LF, 2B, 1B, CF, RF | 2 | 1 | NYM | 2016 | 2017 | PHI | |
5566 | 5566 | Patrick Schuster | 25 | schuspa01 | 2016 | OAK | AL | 0.138676411 | -0.12 | P | 0 | 1 | OAK | 2016 | 2016 | PHI | |
5641 | 5641 | Juan Nicasio | 29 | nicasju01 | 2016 | PIT | NL | 3.588447834 | 0.875 | P | 8 | 1 | PIT | LAD | 2016 | 2017 | PHI |
5669 | 5669 | Drew Hutchison | 25 | hutchdr01 | 2016 | PIT | NL | 0.222411659 | 0.03 | P | 0 | 2 | PIT | TOR | 2016 | 2016 | PHI |
5671 | 5671 | Pedro Florimon | 29 | floripe01 | 2016 | PIT | NL | 0.244107744 | -0.08 | 2B, SS | 0 | 1 | PIT | MIN | 2015 | 2016 | PHI |
5736 | 5736 | Jose Pirela | 26 | pireljo01 | 2016 | SDP | NL | 0.41785275 | -0.53 | 2B, RF | 0 | 1 | SDP | NYY | 2016 | 2019 | PHI |
5858 | 5858 | Kevin Siegrist | 26 | siegrke01 | 2016 | STL | NL | 2.471771589 | 0.88 | P | 6 | 1 | STL | 2013 | 2017 | PHI | |
5967 | 5967 | Phil Klein | 27 | kleinph01 | 2016 | TEX | AL | 0.219272245 | -0.01 | P | 0 | 1 | TEX | 2014 | 2016 | PHI | |
5992 | 5992 | Michael Saunders | 29 | saundmi01 | 2016 | TOR | AL | 5.22 | 1.485 | LF, RF, CF | 12 | 1 | TOR | SEA | 2015 | 2016 | PHI |
5999 | 5999 | Joaquin Benoit | 38 | benoijo01 | 2016 | TOR | AL | 0.855256802 | 1.015 | P | 4 | 2 | TOR | SEA | 2016 | 2016 | PHI |
6010 | 6010 | Jimmy Paredes | 27 | paredji01 | 2016 | TOR | AL | 0.159032258 | 0.01 | LF, RF, 3B, 2B | 0 | 1 | TOR | BAL | 2016 | 2016 | PHI |
6012 | 6012 | Aaron Loup | 28 | loupaa01 | 2016 | TOR | AL | 0.354402189 | 0.0 | P | 0 | 1 | TOR | 2012 | 2018 | PHI | |
6037 | 6037 | Bryce Harper | 23 | harpebr03 | 2016 | WSN | NL | 6.236666095 | 2.205 | RF | 16 | 1 | WSN | 2012 | 2018 | PHI | |
6084 | 6084 | Jeremy Hellickson | 28 | hellije01 | 2015 | ARI | NL | 3.985039027 | 0.8 | P | 8 | 1 | ARI | TBD | 2015 | 2015 | PHI |
6109 | 6109 | David Hernandez | 30 | hernada01 | 2015 | ARI | NL | 0.904260835 | -0.12 | P | 1 | 1 | ARI | BAL | 2011 | 2015 | PHI |
6210 | 6210 | David Lough | 29 | loughda01 | 2015 | BAL | AL | 1.395488722 | -0.13 | LF, CF, RF | 2 | 1 | BAL | KCR | 2014 | 2015 | PHI |
6236 | 6236 | Clay Buchholz | 30 | buchhcl01 | 2015 | BOS | AL | 3.148935666 | 2.92 | P | 13 | 1 | BOS | 2007 | 2016 | PHI | |
6267 | 6267 | Dalier Hinojosa | 29 | hinojda01 | 2015 | BOS | AL | 0.039087832 | -0.005 | P | 0 | 1 | BOS | 2015 | 2015 | PHI | |
6283 | 6283 | Jake Arrieta | 29 | arrieja01 | 2015 | CHC | NL | 6.170990376 | 7.89 | P | 33 | 1 | CHC | BAL | 2013 | 2017 | PHI |
6332 | 6332 | James Russell | 29 | russeja02 | 2015 | CHC | NL | 1.043605359 | -0.405 | P | 0 | 1 | CHC | ATL | 2015 | 2015 | PHI |
6366 | 6366 | Rob Brantly | 25 | brantro01 | 2015 | CHW | AL | 0.345295188 | -0.405 | C | 0 | 1 | CHW | FLA | 2015 | 2017 | PHI |
6429 | 6429 | Carlos Santana | 29 | santaca01 | 2015 | CLE | AL | 6.348069022 | 1.554596273 | 1B | 12 | 1 | CLE | 2010 | 2017 | PHI | |
6512 | 6512 | Kenny Roberts | 27 | roberke02 | 2015 | COL | NL | 0.202269895 | 0.05 | P | 0 | 1 | COL | 2015 | 2015 | PHI | |
6594 | 6594 | Vince Velasquez | 23 | velasvi01 | 2015 | HOU | AL | 1.396716339 | 0.535 | P | 3 | 1 | HOU | 2015 | 2015 | PHI | |
6596 | 6596 | Pat Neshek | 34 | neshepa01 | 2015 | HOU | AL | 1.971198504 | 0.19 | P | 3 | 1 | HOU | STL | 2015 | 2016 | PHI |
6599 | 6599 | Brett Oberholtzer | 25 | oberhbr01 | 2015 | HOU | AL | 1.082756902 | 0.28 | P | 2 | 1 | HOU | 2013 | 2015 | PHI | |
6651 | 6651 | Michael Mariot | 26 | mariomi01 | 2015 | KCR | AL | 0.045314542 | -0.035 | P | 0 | 1 | KCR | 2014 | 2015 | PHI | |
6656 | 6656 | Erik Kratz | 35 | kratzer01 | 2015 | KCR | AL | 0.047595602 | -0.11 | C, 1B | 0 | 1 | KCR | TOR | 2014 | 2015 | PHI |
6680 | 6680 | Jose Alvarez | 26 | alvarjo02 | 2015 | LAA | AL | 1.946201471 | 0.415 | P | 4 | 1 | ANA | DET | 2014 | 2018 | PHI |
6683 | 6683 | Taylor Featherston | 25 | feathta01 | 2015 | LAA | AL | 1.642426273 | 0.14 | 3B, 2B, SS | 3 | 1 | ANA | 2015 | 2015 | PHI | |
6719 | 6719 | Howie Kendrick | 31 | kendrho01 | 2015 | LAD | NL | 4.999129375 | 1.79 | 2B | 12 | 1 | LAD | ANA | 2015 | 2016 | PHI |
6727 | 6727 | A.J. Ellis | 34 | ellisaj01 | 2015 | LAD | NL | 2.191537524 | 1.045 | C | 6 | 1 | LAD | 2008 | 2016 | PHI | |
6772 | 6772 | J.T. Realmuto | 24 | realmjt01 | 2015 | MIA | NL | 4.77707231 | 1.29 | C | 10 | 1 | FLA | 2014 | 2018 | PHI | |
6779 | 6779 | Justin Bour | 27 | bourju01 | 2015 | MIA | NL | 4.562257496 | 0.46 | 1B | 7 | 1 | FLA | 2014 | 2018 | PHI |
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 );