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,923 rows where prev_franch = "PHI"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
347 | 347 | Carlos Santana | 33 | santaca01 | 2019 | CLE | AL | 6.561479507 | 4.686792453 | 1B | 24 | 1 | CLE | PHI | 2019 | 2019 | |
479 | 479 | Daniel Stumpf | 28 | stumpda01 | 2019 | DET | AL | 0.989729409 | 0.11278481 | P | 1 | 1 | DET | PHI | 2017 | 2019 | |
584 | 584 | Ben Lively | 27 | livelbe01 | 2019 | KCR | AL | 0.020290853 | -0.112075472 | P | 0 | 1 | KCR | PHI | 2018 | 2019 | |
624 | 624 | Luis Garcia | 32 | garcilu03 | 2019 | LAA | AL | 1.629615396 | -0.101886792 | P | 2 | 1 | ANA | PHI | 2019 | 2019 | |
635 | 635 | Justin Bour | 31 | bourju01 | 2019 | LAA | AL | 1.599282101 | -0.468679245 | 1B | 1 | 1 | ANA | PHI | 2019 | 2019 | |
708 | 708 | Jorge Alfaro | 26 | alfarjo01 | 2019 | MIA | NL | 4.738898757 | 1.161509434 | C | 10 | 1 | FLA | PHI | 2019 | 2019 | |
861 | 861 | Wilson Ramos | 31 | ramoswi01 | 2019 | NYM | NL | 5.194178082 | 1.747358491 | C | 12 | 1 | NYM | PHI | 2019 | 2019 | |
877 | 877 | Luis Avilan | 29 | avilalu01 | 2019 | NYM | NL | 0.898967715 | 0.010188679 | P | 1 | 1 | NYM | PHI | 2019 | 2019 | |
1103 | 1103 | Yacksel Rios | 26 | riosya01 | 2019 | PIT | NL | 0.214558981 | -0.142641509 | P | 0 | 2 | PIT | PHI | 2019 | 2019 | |
1148 | 1148 | Aaron Loup | 31 | loupaa01 | 2019 | SDP | NL | 0.095716273 | 0.13754717 | P | 1 | 1 | SDP | PHI | 2019 | 2019 | |
1178 | 1178 | J.P. Crawford | 24 | crawfjp01 | 2019 | SEA | AL | 3.662050775 | 1.130943396 | SS | 8 | 1 | SEA | PHI | 2019 | 2019 | |
1279 | 1279 | Aaron Altherr | 28 | altheaa01 | 2019 | SFG | NL | 0.010053735 | -0.015283019 | LF, CF, RF, P | 0 | 2 | SFG | PHI | 2019 | 2019 | NYM |
1393 | 1393 | Hoby Milner | 28 | milneho01 | 2019 | TBR | AL | 0.101046415 | 0.00509434 | P | 0 | 1 | TBD | PHI | 2018 | 2019 | |
1397 | 1397 | Ricardo Pinto | 25 | pintori01 | 2019 | TBR | AL | 0.035500208 | -0.117169811 | P | 0 | 1 | TBD | PHI | 2019 | 2019 | |
1415 | 1415 | Asdrubal Cabrera | 33 | cabreas01 | 2019 | TEX | AL | 3.522112211 | 0.468679245 | 3B, 2B, 1B | 7 | 1 | TEX | PHI | 2019 | 2019 | WSN |
1524 | 1524 | Howie Kendrick | 35 | kendrho01 | 2019 | WSN | NL | 3.655588083 | 2.842641509 | 1B, 2B, 3B | 13 | 1 | WSN | PHI | 2017 | 2019 | |
1572 | 1572 | Clay Buchholz | 33 | buchhcl01 | 2018 | ARI | NL | 2.635512471 | 2.29 | P | 11 | 1 | ARI | PHI | 2018 | 2018 | TOR |
1851 | 1851 | Jeanmar Gomez | 30 | gomezje01 | 2018 | CHW | AL | 0.905833417 | 0.065 | P | 1 | 1 | CHW | PHI | 2018 | 2018 | TEX |
2043 | 2043 | Daniel Stumpf | 27 | stumpda01 | 2018 | DET | AL | 1.306945918 | 0.05 | P | 2 | 1 | DET | PHI | 2017 | 2019 | |
2071 | 2071 | Charlie Morton | 34 | mortoch02 | 2018 | HOU | AL | 4.567731465 | 3.175 | P | 16 | 1 | HOU | PHI | 2017 | 2018 | TBD |
2094 | 2094 | Ken Giles | 27 | gileske01 | 2018 | HOU | AL | 0.919523685 | 0.295 | P | 2 | 1 | HOU | PHI | 2016 | 2018 | TOR |
2134 | 2134 | Ben Lively | 26 | livelbe01 | 2018 | KCR | AL | 0.219355773 | 0.14 | P | 1 | 2 | KCR | PHI | 2018 | 2019 | |
2243 | 2243 | Chase Utley | 39 | utleych01 | 2018 | LAD | NL | 1.800165975 | -0.054662577 | 2B, 1B | 2 | 1 | LAD | PHI | 2015 | 2018 | |
2462 | 2462 | Ty Kelly | 29 | kellyty01 | 2018 | NYM | NL | 0.119096509 | -0.19 | 2B, 3B, LF | 0 | 1 | NYM | PHI | 2018 | 2018 | |
2679 | 2679 | Freddy Galvis | 28 | galvifr01 | 2018 | SDP | NL | 6.598681929 | 1.77 | SS, 2B | 15 | 1 | SDP | PHI | 2018 | 2018 | TOR |
2817 | 2817 | Hunter Pence | 35 | pencehu01 | 2018 | SFG | NL | 2.48042766 | -0.83 | LF, RF | 1 | 1 | SFG | PHI | 2012 | 2018 | TEX |
2929 | 2929 | Hoby Milner | 27 | milneho01 | 2018 | TBR | AL | 0.094138298 | -0.31 | P | 0 | 2 | TBD | PHI | 2018 | 2019 | |
2942 | 2942 | Cole Hamels | 34 | hamelco01 | 2018 | TEX | AL | 3.279419767 | 0.905 | P | 7 | 1 | TEX | PHI | 2015 | 2018 | CHC |
2949 | 2949 | Jake Diekman | 31 | diekmja01 | 2018 | TEX | AL | 1.405772384 | 0.73 | P | 4 | 1 | TEX | PHI | 2015 | 2018 | ARI |
2972 | 2972 | Zac Curtis | 25 | curtiza01 | 2018 | TEX | AL | 0.157475139 | -0.185 | P | 0 | 2 | TEX | PHI | 2018 | 2018 | |
2974 | 2974 | Drew Hutchison | 27 | hutchdr01 | 2018 | TEX | AL | 0.611903397 | -0.375 | P | 0 | 2 | TEX | PHI | 2018 | 2018 | |
3032 | 3032 | Darnell Sweeney | 27 | sweenda02 | 2018 | TOR | AL | 0.038334435 | -0.045 | 3B, LF | 0 | 1 | TOR | PHI | 2018 | 2018 | |
3044 | 3044 | Mark Leiter Jr. | 27 | leitema02 | 2018 | TOR | AL | 0.192492875 | -0.345 | P | 0 | 2 | TOR | PHI | 2018 | 2018 | |
3071 | 3071 | Howie Kendrick | 34 | kendrho01 | 2018 | WSN | NL | 1.560450647 | 0.09 | 2B, LF, 1B | 2 | 1 | WSN | PHI | 2017 | 2019 | |
3178 | 3178 | Chase d'Arnaud | 30 | darnach01 | 2017 | ATL | NL | 0.098405158 | 0.05 | SS, LF, 2B, 3B, 1B, RF | 0 | 1 | ATL | PHI | 2016 | 2017 | BOS |
3215 | 3215 | Alec Asher | 25 | asheral01 | 2017 | BAL | AL | 1.668495676 | 0.1 | P | 3 | 1 | BAL | PHI | 2017 | 2017 | MIL |
3226 | 3226 | Jeremy Hellickson | 30 | hellije01 | 2017 | BAL | AL | 1.492325476 | -0.47 | P | 1 | 2 | BAL | PHI | 2017 | 2017 | WSN |
3386 | 3386 | Cody Asche | 27 | ascheco01 | 2017 | CHW | AL | 0.595462825 | -0.905 | 1B, 3B, LF | 0 | 1 | CHW | PHI | 2017 | 2017 | |
3495 | 3495 | Pat Neshek | 36 | neshepa01 | 2017 | COL | NL | 0.842045389 | 0.835 | P | 4 | 2 | COL | PHI | 2017 | 2017 | PHI |
3536 | 3536 | Daniel Stumpf | 26 | stumpda01 | 2017 | DET | AL | 1.17477891 | 0.435 | P | 3 | 1 | DET | PHI | 2017 | 2019 | |
3575 | 3575 | Charlie Morton | 33 | mortoch02 | 2017 | HOU | AL | 4.109317839 | 2.615 | P | 14 | 1 | HOU | PHI | 2017 | 2018 | TBD |
3580 | 3580 | Ken Giles | 26 | gileske01 | 2017 | HOU | AL | 2.350505703 | 1.92 | P | 9 | 1 | HOU | PHI | 2016 | 2018 | TOR |
3680 | 3680 | David Hernandez | 32 | hernada01 | 2017 | LAA | AL | 1.022298785 | 0.975 | P | 4 | 1 | ANA | PHI | 2017 | 2017 | ARI |
3700 | 3700 | Andrew Bailey | 33 | bailean01 | 2017 | LAA | AL | 0.073840134 | 0.125 | P | 0 | 1 | ANA | PHI | 2016 | 2017 | |
3731 | 3731 | Chase Utley | 38 | utleych01 | 2017 | LAD | NL | 3.491473397 | 1.07 | 2B, 1B | 9 | 1 | LAD | PHI | 2015 | 2018 | |
3786 | 3786 | A.J. Ellis | 36 | ellisaj01 | 2017 | MIA | NL | 1.594266442 | 0.2 | C | 3 | 1 | FLA | PHI | 2017 | 2017 | SDP |
3795 | 3795 | Dustin McGowan | 35 | mcgowdu01 | 2017 | MIA | NL | 2.167334313 | -0.385 | P | 2 | 1 | FLA | PHI | 2016 | 2017 | |
4164 | 4164 | Joaquin Benoit | 39 | benoijo01 | 2017 | PIT | NL | 0.318160308 | -0.485 | P | 0 | 2 | PIT | PHI | 2017 | 2017 | |
4262 | 4262 | Tyler Cloyd | 30 | cloydty01 | 2017 | SEA | AL | 0.029001812 | 0.025 | P | 0 | 1 | SEA | PHI | 2017 | 2017 | FLA |
4290 | 4290 | Hunter Pence | 34 | pencehu01 | 2017 | SFG | NL | 5.372400756 | 0.435 | RF | 8 | 1 | SFG | PHI | 2012 | 2018 | TEX |
4358 | 4358 | Juan Nicasio | 30 | nicasju01 | 2017 | STL | NL | 0.397641058 | 0.315 | P | 1 | 3 | STL | PHI | 2017 | 2017 | SEA |
4399 | 4399 | Peter Bourjos | 30 | bourjpe01 | 2017 | TBR | AL | 1.923227703 | 0.43 | LF, CF, RF | 4 | 1 | TBD | PHI | 2017 | 2017 | ATL |
4417 | 4417 | Taylor Featherston | 27 | feathta01 | 2017 | TBR | AL | 0.44527932 | -0.01 | 2B, SS, 1B, 3B | 1 | 1 | TBD | PHI | 2017 | 2017 | |
4438 | 4438 | Cole Hamels | 33 | hamelco01 | 2017 | TEX | AL | 4.266004709 | 2.305 | P | 13 | 1 | TEX | PHI | 2015 | 2018 | CHC |
4456 | 4456 | Jake Diekman | 30 | diekmja01 | 2017 | TEX | AL | 0.377783051 | 0.21 | P | 1 | 1 | TEX | PHI | 2015 | 2018 | ARI |
4525 | 4525 | Michael Saunders | 30 | saundmi01 | 2017 | TOR | AL | 0.189233279 | -0.115 | RF, LF | 0 | 2 | TOR | PHI | 2017 | 2017 | |
4562 | 4562 | Howie Kendrick | 33 | kendrho01 | 2017 | WSN | NL | 1.764786325 | 0.3 | LF, 2B, 1B, RF | 4 | 2 | WSN | PHI | 2017 | 2019 | |
4568 | 4568 | Jayson Werth | 38 | werthja01 | 2017 | WSN | NL | 2.865299145 | -0.495 | LF, RF | 3 | 1 | WSN | PHI | 2011 | 2017 | |
4634 | 4634 | Adam Loewen | 32 | loewead01 | 2016 | ARI | NL | 0.143199622 | -0.35 | P | 0 | 1 | ARI | PHI | 2016 | 2016 | |
4656 | 4656 | Jeff Francoeur | 32 | francje02 | 2016 | ATL | NL | 2.723375298 | 0.437701863 | LF, RF, 3B | 5 | 1 | ATL | PHI | 2016 | 2016 | FLA |
4659 | 4659 | Chase d'Arnaud | 29 | darnach01 | 2016 | ATL | NL | 2.585233072 | 0.125776398 | SS, 3B, 2B, LF, CF, RF | 4 | 1 | ATL | PHI | 2016 | 2017 | BOS |
4788 | 4788 | Sean O'Sullivan | 28 | osullse01 | 2016 | BOS | AL | 0.534574309 | -0.125 | P | 0 | 1 | BOS | PHI | 2016 | 2016 | |
4972 | 4972 | Jeff Manship | 31 | manshje01 | 2016 | CLE | AL | 1.334741994 | 0.08552795 | P | 2 | 1 | CLE | PHI | 2015 | 2016 | |
5103 | 5103 | Ken Giles | 25 | gileske01 | 2016 | HOU | AL | 2.47450487 | 0.585 | P | 5 | 1 | HOU | PHI | 2016 | 2018 | TOR |
5123 | 5123 | Erik Kratz | 36 | kratzer01 | 2016 | HOU | AL | 0.281507847 | -0.365 | C, 1B, P | 0 | 1 | HOU | PHI | 2016 | 2016 | PIT |
5202 | 5202 | Andrew Bailey | 32 | bailean01 | 2016 | LAA | AL | 0.393172777 | 0.195 | P | 1 | 2 | ANA | PHI | 2016 | 2017 | |
5220 | 5220 | Brett Oberholtzer | 26 | oberhbr01 | 2016 | LAA | AL | 0.441813777 | -0.53 | P | 0 | 2 | ANA | PHI | 2016 | 2016 | |
5229 | 5229 | Chase Utley | 37 | utleych01 | 2016 | LAD | NL | 5.605542251 | 2.025 | 2B, 3B | 14 | 1 | LAD | PHI | 2015 | 2018 | |
5253 | 5253 | Carlos Ruiz | 37 | ruizca01 | 2016 | LAD | NL | 0.396852549 | 0.165 | C | 1 | 2 | LAD | PHI | 2016 | 2016 | SEA |
5298 | 5298 | Dustin McGowan | 34 | mcgowdu01 | 2016 | MIA | NL | 1.702850744 | 0.266645963 | P | 3 | 1 | FLA | PHI | 2016 | 2017 | |
5305 | 5305 | Nefi Ogando | 27 | ogandne01 | 2016 | MIA | NL | 0.338681014 | 0.186149068 | P | 1 | 1 | FLA | PHI | 2016 | 2016 | |
5804 | 5804 | Hunter Pence | 33 | pencehu01 | 2016 | SFG | NL | 4.345821326 | 1.865 | RF | 11 | 1 | SFG | PHI | 2012 | 2018 | TEX |
5879 | 5879 | Jerome Williams | 34 | willije01 | 2016 | STL | NL | 0.272663758 | -0.24 | P | 0 | 1 | STL | PHI | 2016 | 2016 | |
5931 | 5931 | Cole Hamels | 32 | hamelco01 | 2016 | TEX | AL | 5.549274498 | 4.13 | P | 23 | 1 | TEX | PHI | 2015 | 2018 | CHC |
5948 | 5948 | Jake Diekman | 29 | diekmja01 | 2016 | TEX | AL | 1.824294081 | 0.91 | P | 6 | 1 | TEX | PHI | 2015 | 2018 | ARI |
6042 | 6042 | Jayson Werth | 37 | werthja01 | 2016 | WSN | NL | 6.027782542 | 0.75 | LF, RF | 11 | 1 | WSN | PHI | 2011 | 2017 | |
6057 | 6057 | Jonathan Papelbon | 35 | papeljo01 | 2016 | WSN | NL | 1.328989141 | 0.16 | P | 2 | 1 | WSN | PHI | 2015 | 2016 | |
6108 | 6108 | JC Ramirez | 26 | ramirjc01 | 2015 | ARI | NL | 0.540959466 | 0.12 | P | 1 | 1 | ARI | PHI | 2015 | 2015 | SEA |
6383 | 6383 | Marlon Byrd | 37 | byrdma01 | 2015 | CIN | NL | 3.840928486 | 0.89 | LF, RF, CF | 7 | 1 | CIN | PHI | 2015 | 2015 | SFG |
6440 | 6440 | Jeff Manship | 30 | manshje01 | 2015 | CLE | AL | 1.103154806 | 1.172236025 | P | 5 | 1 | CLE | PHI | 2015 | 2016 | |
6486 | 6486 | Kyle Kendrick | 30 | kendrky01 | 2015 | COL | NL | 4.033728488 | -0.505 | P | 4 | 1 | COL | PHI | 2015 | 2015 | BOS |
6630 | 6630 | Ryan Madson | 34 | madsory01 | 2015 | KCR | AL | 2.178487877 | 1.315 | P | 8 | 1 | KCR | PHI | 2015 | 2015 | OAK |
6722 | 6722 | Jimmy Rollins | 36 | rolliji01 | 2015 | LAD | NL | 5.685878461 | 0.18 | SS | 8 | 1 | LAD | PHI | 2015 | 2015 | CHW |
6731 | 6731 | Chase Utley | 36 | utleych01 | 2015 | LAD | NL | 1.423994428 | 0.595 | 2B, 1B, 3B | 4 | 2 | LAD | PHI | 2015 | 2018 | |
6808 | 6808 | Reid Brignac | 29 | brignre01 | 2015 | MIA | NL | 0.173897707 | -0.125 | 3B | 0 | 1 | FLA | PHI | 2015 | 2015 | ATL |
6848 | 6848 | Cesar Jimenez | 30 | jimence01 | 2015 | MIL | NL | 0.526704341 | 0.135 | P | 1 | 2 | MIL | PHI | 2015 | 2015 | |
7126 | 7126 | A.J. Burnett | 38 | burnea.01 | 2015 | PIT | NL | 4.36962429 | 2.605 | P | 15 | 1 | PIT | PHI | 2015 | 2015 | |
7135 | 7135 | Antonio Bastardo | 29 | bastaan01 | 2015 | PIT | NL | 1.609281655 | 0.735 | P | 5 | 1 | PIT | PHI | 2015 | 2015 | NYM |
7203 | 7203 | Wil Nieves | 37 | nievewi01 | 2015 | SDP | NL | 0.142406173 | -0.225 | C, 1B | 0 | 1 | SDP | PHI | 2015 | 2015 | |
7272 | 7272 | Hunter Pence | 32 | pencehu01 | 2015 | SFG | NL | 2.230384549 | 1.125 | RF | 6 | 1 | SFG | PHI | 2012 | 2018 | TEX |
7379 | 7379 | Grady Sizemore | 32 | sizemgr01 | 2015 | TBR | AL | 1.840356966 | 0.195 | LF, RF | 3 | 2 | TBD | PHI | 2015 | 2015 | |
7417 | 7417 | Cole Hamels | 31 | hamelco01 | 2015 | TEX | AL | 2.344523441 | 1.49 | P | 8 | 2 | TEX | PHI | 2015 | 2018 | CHC |
7428 | 7428 | Jake Diekman | 28 | diekmja01 | 2015 | TEX | AL | 0.765393397 | 0.52 | P | 3 | 2 | TEX | PHI | 2015 | 2018 | ARI |
7482 | 7482 | Ben Revere | 27 | reverbe01 | 2015 | TOR | AL | 2.298695022 | 0.6 | LF, CF, RF | 5 | 2 | TOR | PHI | 2015 | 2015 | WSN |
7538 | 7538 | Jayson Werth | 36 | werthja01 | 2015 | WSN | NL | 3.808233455 | -0.78 | LF, RF | 3 | 1 | WSN | PHI | 2011 | 2017 | |
7545 | 7545 | Jonathan Papelbon | 34 | papeljo01 | 2015 | WSN | NL | 0.794478731 | -0.16 | P | 1 | 2 | WSN | PHI | 2015 | 2016 | |
7777 | 7777 | Nate Schierholtz | 30 | schiena01 | 2014 | CHC | NL | 3.430107527 | -0.86 | RF, LF, CF | 2 | 1 | CHC | PHI | 2013 | 2014 | WSN |
7880 | 7880 | Roger Bernadina | 30 | bernaro01 | 2014 | CIN | NL | 0.732088889 | -0.325 | LF, RF, CF, 1B | 0 | 1 | CIN | PHI | 2014 | 2014 | LAD |
8068 | 8068 | Raul Valdes | 36 | valdera02 | 2014 | HOU | AL | 0.137879456 | -0.345 | P | 0 | 1 | HOU | PHI | 2014 | 2014 | |
8224 | 8224 | Roberto Hernandez | 33 | carmofa01 | 2014 | LAD | NL | 1.246685705 | -0.43 | P | 0 | 2 | LAD | PHI | 2014 | 2014 | HOU |
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 );