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,011 rows where next_franch = "NYM"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
232 | 232 | Brad Brach | 33 | brachbr01 | 2019 | CHC | NL | 1.189527491 | -0.020377358 | P | 1 | 1 | CHC | ATL | 2019 | 2019 | NYM |
782 | 782 | Donnie Hart | 28 | hartdo01 | 2019 | MIL | NL | 0.133113963 | 0.13245283 | P | 1 | 1 | MIL | BAL | 2019 | 2019 | NYM |
1256 | 1256 | Joe Panik | 28 | panikjo01 | 2019 | SFG | NL | 3.900849367 | -0.382075472 | 2B | 6 | 1 | SFG | 2014 | 2019 | NYM | |
1279 | 1279 | Aaron Altherr | 28 | altheaa01 | 2019 | SFG | NL | 0.010053735 | -0.015283019 | LF, CF, RF, P | 0 | 2 | SFG | PHI | 2019 | 2019 | NYM |
1387 | 1387 | Wilmer Font | 29 | fontwi01 | 2019 | TBR | AL | 0.335577442 | 0.025471698 | P | 1 | 1 | TBD | OAK | 2018 | 2019 | NYM |
1455 | 1455 | Marcus Stroman | 28 | stromma01 | 2019 | TOR | AL | 3.655409887 | 3.183962264 | P | 14 | 1 | TOR | 2014 | 2019 | NYM | |
1660 | 1660 | Rene Rivera | 34 | riverre01 | 2018 | ATL | NL | 0.03916934 | -0.1 | C, 1B | 0 | 2 | ATL | ANA | 2018 | 2018 | NYM |
1667 | 1667 | Jose Bautista | 37 | bautijo02 | 2018 | ATL | NL | 0.391693399 | -0.225 | RF, LF, 3B, 1B, 2B | 0 | 1 | ATL | TOR | 2018 | 2018 | NYM |
1793 | 1793 | Justin Wilson | 30 | wilsoju10 | 2018 | CHC | NL | 1.836299812 | 0.660920245 | P | 5 | 1 | CHC | DET | 2017 | 2018 | NYM |
1841 | 1841 | Hector Santiago | 30 | santihe01 | 2018 | CHW | AL | 2.630049113 | 0.26 | P | 4 | 1 | CHW | MIN | 2018 | 2018 | NYM |
1852 | 1852 | Chris Beck | 27 | beckch02 | 2018 | CHW | AL | 0.426982059 | 0.01 | P | 1 | 1 | CHW | 2015 | 2018 | NYM | |
1910 | 1910 | Devin Mesoraco | 30 | mesorde01 | 2018 | CIN | NL | 0.442898354 | -0.13 | C, 1B | 0 | 1 | CIN | 2011 | 2018 | NYM | |
1957 | 1957 | Rajai Davis | 37 | davisra01 | 2018 | CLE | AL | 1.996812241 | -0.315 | CF, LF, RF | 1 | 1 | CLE | BOS | 2018 | 2018 | NYM |
2008 | 2008 | Brooks Pounders | 27 | poundbr01 | 2018 | COL | NL | 0.266067873 | -0.089447853 | P | 0 | 1 | COL | ANA | 2018 | 2018 | NYM |
2104 | 2104 | J.D. Davis | 25 | davisjd01 | 2018 | HOU | AL | 1.070740075 | -0.635 | 3B, 1B, LF, P | 0 | 1 | HOU | 2017 | 2018 | NYM | |
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 |
2531 | 2531 | Jed Lowrie | 34 | lowrije01 | 2018 | OAK | AL | 6.326596086 | 4.9 | 2B, 3B | 24 | 1 | OAK | HOU | 2016 | 2018 | NYM |
2553 | 2553 | Jeurys Familia | 28 | familje01 | 2018 | OAK | AL | 1.06076816 | 0.515 | P | 3 | 2 | OAK | NYM | 2018 | 2018 | NYM |
2600 | 2600 | Wilson Ramos | 30 | ramoswi01 | 2018 | PHI | NL | 1.003769705 | 0.75 | C | 4 | 2 | PHI | TBD | 2018 | 2018 | NYM |
2621 | 2621 | Luis Avilan | 28 | avilalu01 | 2018 | PHI | NL | 0.194504492 | 0.06 | P | 0 | 2 | PHI | CHW | 2018 | 2018 | NYM |
2719 | 2719 | Buddy Baumann | 30 | baumabu01 | 2018 | SDP | NL | 0.009917414 | -0.215 | P | 0 | 1 | SDP | 2016 | 2018 | NYM | |
2725 | 2725 | Walker Lockett | 24 | lockewa01 | 2018 | SDP | NL | 0.372276805 | -0.475 | P | 0 | 1 | SDP | 2018 | 2018 | NYM | |
2733 | 2733 | Edwin Diaz | 24 | diazed04 | 2018 | SEA | AL | 3.256059531 | 3.325 | P | 15 | 1 | SEA | 2016 | 2018 | NYM | |
2734 | 2734 | Robinson Cano | 35 | canoro01 | 2018 | SEA | AL | 3.327947238 | 3.07 | 2B, 1B, 3B | 14 | 1 | SEA | NYY | 2014 | 2018 | NYM |
2797 | 2797 | Joe Panik | 27 | panikjo01 | 2018 | SFG | NL | 3.920675979 | 0.02 | 2B, 1B | 6 | 1 | SFG | 2014 | 2019 | NYM | |
2828 | 2828 | Austin Jackson | 31 | jacksau01 | 2018 | SFG | NL | 1.650284532 | -1.1 | CF, LF | 0 | 1 | SFG | CLE | 2018 | 2018 | NYM |
2898 | 2898 | Carlos Gomez | 32 | gomezca01 | 2018 | TBR | AL | 3.83346833 | -0.05 | RF, CF, 2B, P | 5 | 1 | TBD | TEX | 2018 | 2018 | NYM |
2904 | 2904 | Wilmer Font | 28 | fontwi01 | 2018 | TBR | AL | 0.65074516 | 0.8 | P | 3 | 3 | TBD | OAK | 2018 | 2019 | NYM |
2994 | 2994 | Marcus Stroman | 27 | stromma01 | 2018 | TOR | AL | 2.92333196 | 0.815 | P | 7 | 1 | TOR | 2014 | 2019 | NYM | |
3138 | 3138 | Jack Reinheimer | 24 | reinhja01 | 2017 | ARI | NL | 0.049370106 | -0.105 | SS | 0 | 1 | ARI | 2017 | 2017 | NYM | |
3224 | 3224 | Ruben Tejada | 27 | tejadru01 | 2017 | BAL | AL | 1.174779484 | -0.18 | SS, 3B, 2B | 1 | 1 | BAL | SFG | 2017 | 2017 | NYM |
3319 | 3319 | Justin Wilson | 29 | wilsoju10 | 2017 | CHC | NL | 0.497812677 | 0.035 | P | 1 | 2 | CHC | DET | 2017 | 2018 | NYM |
3387 | 3387 | Chris Beck | 26 | beckch02 | 2017 | CHW | AL | 1.633605358 | -0.97 | P | 0 | 1 | CHW | 2015 | 2018 | NYM | |
3410 | 3410 | Devin Mesoraco | 29 | mesorde01 | 2017 | CIN | NL | 1.626168224 | -0.065 | C | 2 | 1 | CIN | 2011 | 2018 | NYM | |
3463 | 3463 | Jay Bruce | 30 | bruceja01 | 2017 | CLE | AL | 1.577659746 | 0.33 | RF, 1B | 3 | 2 | CLE | NYM | 2017 | 2017 | NYM |
3551 | 3551 | Matt den Dekker | 29 | dendema01 | 2017 | DET | AL | 0.075718016 | 0.015 | RF, LF | 0 | 1 | DET | WSN | 2017 | 2017 | NYM |
3597 | 3597 | J.D. Davis | 24 | davisjd01 | 2017 | HOU | AL | 0.631848766 | 0.055 | 3B, 1B, P | 1 | 1 | HOU | 2017 | 2018 | NYM | |
3617 | 3617 | Jason Vargas | 34 | vargaja01 | 2017 | KCR | AL | 5.016764 | 2.835 | P | 16 | 1 | KCR | ANA | 2014 | 2017 | NYM |
3749 | 3749 | Adrian Gonzalez | 35 | gonzaad01 | 2017 | LAD | NL | 2.492496589 | -1.05 | 1B | 1 | 1 | LAD | BOS | 2012 | 2017 | NYM |
3785 | 3785 | AJ Ramos | 30 | ramosaj01 | 2017 | MIA | NL | 1.457749496 | 0.28 | P | 3 | 1 | FLA | 2012 | 2017 | NYM | |
3824 | 3824 | Keon Broxton | 27 | broxtke01 | 2017 | MIL | NL | 4.614882282 | 0.585 | CF | 9 | 1 | MIL | PIT | 2016 | 2018 | NYM |
3833 | 3833 | Anthony Swarzak | 31 | swarzan01 | 2017 | MIL | NL | 1.111029045 | 0.685 | P | 4 | 2 | MIL | CHW | 2017 | 2017 | NYM |
3841 | 3841 | Tommy Milone | 30 | milonto01 | 2017 | MIL | NL | 0.50861615 | -0.04 | P | 1 | 1 | MIL | MIN | 2017 | 2017 | NYM |
3979 | 3979 | Todd Frazier | 31 | frazito01 | 2017 | NYY | AL | 2.208563754 | 1.395 | 3B, 1B | 7 | 2 | NYY | CHW | 2017 | 2017 | NYM |
4017 | 4017 | Jed Lowrie | 33 | lowrije01 | 2017 | OAK | AL | 6.129772243 | 3.87 | 2B, 3B | 20 | 1 | OAK | HOU | 2016 | 2018 | NYM |
4055 | 4055 | Bobby Wahl | 25 | wahlbo01 | 2017 | OAK | AL | 0.176160575 | 0.07 | P | 0 | 1 | OAK | 2017 | 2017 | NYM | |
4104 | 4104 | Ty Kelly | 28 | kellyty01 | 2017 | PHI | NL | 1.035181054 | -0.175 | 2B, LF, 3B, RF, CF | 1 | 2 | PHI | NYM | 2017 | 2017 | NYM |
4197 | 4197 | Buddy Baumann | 29 | baumabu01 | 2017 | SDP | NL | 0.593853235 | 0.16 | P | 1 | 1 | SDP | 2016 | 2018 | NYM | |
4222 | 4222 | Robinson Cano | 34 | canoro01 | 2017 | SEA | AL | 6.122169734 | 3.31 | 2B | 18 | 1 | SEA | NYY | 2014 | 2018 | NYM |
4231 | 4231 | Edwin Diaz | 23 | diazed04 | 2017 | SEA | AL | 2.988370386 | 0.84 | P | 7 | 1 | SEA | 2016 | 2018 | NYM | |
4288 | 4288 | Joe Panik | 26 | panikjo01 | 2017 | SFG | NL | 5.7112906 | 1.575 | 2B | 12 | 1 | SFG | 2014 | 2019 | NYM | |
4319 | 4319 | Neil Ramirez | 28 | ramirne01 | 2017 | SFG | NL | 0.294184729 | -0.34 | P | 0 | 1 | SFG | MIN | 2017 | 2017 | NYM |
4484 | 4484 | Marcus Stroman | 26 | stromma01 | 2017 | TOR | AL | 5.349894492 | 4.54 | P | 21 | 1 | TOR | 2014 | 2019 | NYM | |
4509 | 4509 | Nori Aoki | 35 | aokino01 | 2017 | TOR | AL | 0.321696574 | 0.355 | LF, RF, CF, P | 2 | 2 | TOR | HOU | 2017 | 2017 | NYM |
4590 | 4590 | Jose Lobaton | 32 | lobatjo01 | 2017 | WSN | NL | 1.566495726 | -0.86 | C | 0 | 1 | WSN | TBD | 2014 | 2017 | NYM |
4697 | 4697 | Kelly Johnson | 34 | johnske05 | 2016 | ATL | NL | 1.302483838 | -0.669130435 | 2B, 3B, LF, 1B, SS | 0 | 1 | ATL | NYM | 2016 | 2016 | NYM |
4887 | 4887 | Chris Beck | 25 | beckch02 | 2016 | CHW | AL | 0.701326625 | -0.315 | P | 0 | 1 | CHW | 2015 | 2018 | NYM | |
4905 | 4905 | Jay Bruce | 29 | bruceja01 | 2016 | CIN | NL | 4.043003295 | 0.565 | RF, CF | 8 | 1 | CIN | 2008 | 2016 | NYM | |
4931 | 4931 | Devin Mesoraco | 28 | mesorde01 | 2016 | CIN | NL | 0.553147217 | -0.32 | C | 0 | 1 | CIN | 2011 | 2018 | NYM | |
5154 | 5154 | Jason Vargas | 33 | vargaja01 | 2016 | KCR | AL | 0.336205759 | 0.445 | P | 2 | 1 | KCR | ANA | 2014 | 2017 | NYM |
5194 | 5194 | Fernando Salas | 31 | salasfe01 | 2016 | LAA | AL | 2.068227782 | -0.085 | P | 3 | 1 | ANA | STL | 2014 | 2016 | NYM |
5230 | 5230 | Adrian Gonzalez | 34 | gonzaad01 | 2016 | LAD | NL | 6.280191584 | 1.575 | 1B | 14 | 1 | LAD | BOS | 2012 | 2017 | NYM |
5292 | 5292 | AJ Ramos | 29 | ramosaj01 | 2016 | MIA | NL | 2.430557246 | 1.353354037 | P | 7 | 1 | FLA | 2012 | 2017 | NYM | |
5339 | 5339 | Keon Broxton | 26 | broxtke01 | 2016 | MIL | NL | 2.460361613 | 1.875 | CF | 9 | 1 | MIL | PIT | 2016 | 2018 | NYM |
5412 | 5412 | Ryan O'Rourke | 28 | orourry01 | 2016 | MIN | AL | 0.701606906 | 0.13 | P | 1 | 1 | MIN | 2015 | 2016 | NYM | |
5556 | 5556 | Jed Lowrie | 32 | lowrije01 | 2016 | OAK | AL | 3.568189396 | -0.63 | 2B, SS | 3 | 1 | OAK | HOU | 2016 | 2018 | NYM |
5648 | 5648 | Jon Niese | 29 | niesejo01 | 2016 | PIT | NL | 3.196855505 | 0.105 | P | 5 | 1 | PIT | NYM | 2016 | 2016 | NYM |
5717 | 5717 | Buddy Baumann | 28 | baumabu01 | 2016 | SDP | NL | 0.321423924 | 0.2 | P | 1 | 1 | SDP | 2016 | 2018 | NYM | |
5742 | 5742 | Robinson Cano | 33 | canoro01 | 2016 | SEA | AL | 6.686552725 | 6.815 | 2B | 30 | 1 | SEA | NYY | 2014 | 2018 | NYM |
5751 | 5751 | Edwin Diaz | 22 | diazed04 | 2016 | SEA | AL | 2.049282104 | 1.655 | P | 8 | 1 | SEA | 2016 | 2018 | NYM | |
5802 | 5802 | Joe Panik | 25 | panikjo01 | 2016 | SFG | NL | 5.171724021 | 1.56 | 2B | 12 | 1 | SFG | 2014 | 2019 | NYM | |
5966 | 5966 | Justin Ruggiano | 34 | ruggiju01 | 2016 | TEX | AL | 0.038239657 | 0.06 | CF, LF, RF | 0 | 1 | TEX | LAD | 2016 | 2016 | NYM |
5990 | 5990 | Marcus Stroman | 25 | stromma01 | 2016 | TOR | AL | 5.581285822 | 2.38 | P | 15 | 1 | TOR | 2014 | 2019 | NYM | |
6049 | 6049 | Jose Lobaton | 31 | lobatjo01 | 2016 | WSN | NL | 1.13393929 | 0.48 | C | 3 | 1 | WSN | TBD | 2014 | 2017 | NYM |
6096 | 6096 | Addison Reed | 26 | reedad01 | 2015 | ARI | NL | 1.440622775 | 0.305 | P | 3 | 1 | ARI | CHW | 2014 | 2015 | NYM |
6136 | 6136 | Juan Uribe | 36 | uribeju01 | 2015 | ATL | NL | 1.69870221 | 0.945 | 3B, 2B | 5 | 2 | ATL | LAD | 2015 | 2015 | NYM |
6143 | 6143 | Kelly Johnson | 33 | johnske05 | 2015 | ATL | NL | 2.003858295 | 0.03 | 2B, LF, 1B, 3B, RF, SS | 3 | 1 | ATL | BAL | 2015 | 2015 | NYM |
6181 | 6181 | Eric Young Jr. | 30 | younger03 | 2015 | ATL | NL | 0.864608909 | -0.475 | CF, LF, RF | 0 | 1 | ATL | NYM | 2015 | 2015 | NYM |
6362 | 6362 | Chris Beck | 24 | beckch02 | 2015 | CHW | AL | 0.172331423 | -0.005 | P | 0 | 1 | CHW | 2015 | 2018 | NYM | |
6380 | 6380 | Jay Bruce | 28 | bruceja01 | 2015 | CIN | NL | 6.424645844 | 0.495 | RF | 9 | 1 | CIN | 2008 | 2016 | NYM | |
6410 | 6410 | Devin Mesoraco | 27 | mesorde01 | 2015 | CIN | NL | 0.504864311 | -0.24 | C | 0 | 1 | CIN | 2011 | 2018 | NYM | |
6503 | 6503 | Jose Reyes | 32 | reyesjo01 | 2015 | COL | NL | 2.098086957 | -0.26 | SS | 2 | 2 | COL | TOR | 2015 | 2015 | NYM |
6527 | 6527 | Yoenis Cespedes | 29 | cespeyo01 | 2015 | DET | AL | 4.038812785 | 3.677701863 | LF, CF | 17 | 1 | DET | BOS | 2015 | 2015 | NYM |
6639 | 6639 | Jason Vargas | 32 | vargaja01 | 2015 | KCR | AL | 1.208985995 | 0.405 | P | 3 | 1 | KCR | ANA | 2014 | 2017 | NYM |
6682 | 6682 | Fernando Salas | 30 | salasfe01 | 2015 | LAA | AL | 2.030499935 | 0.145 | P | 4 | 1 | ANA | STL | 2014 | 2016 | NYM |
6699 | 6699 | Adam Wilk | 27 | wilkad01 | 2015 | LAA | AL | 0.03024563 | -0.045 | P | 0 | 1 | ANA | DET | 2015 | 2015 | NYM |
6714 | 6714 | Adrian Gonzalez | 33 | gonzaad01 | 2015 | LAD | NL | 6.493818562 | 3.54 | 1B | 19 | 1 | LAD | BOS | 2012 | 2017 | NYM |
6774 | 6774 | AJ Ramos | 28 | ramosaj01 | 2015 | MIA | NL | 2.847256636 | 1.64 | P | 9 | 1 | FLA | 2012 | 2017 | NYM | |
6896 | 6896 | Ryan O'Rourke | 27 | orourry01 | 2015 | MIN | AL | 0.522424979 | -0.105 | P | 1 | 1 | MIN | 2015 | 2016 | NYM | |
6908 | 6908 | Tim Stauffer | 33 | staufti01 | 2015 | MIN | AL | 0.360651335 | -0.395 | P | 0 | 1 | MIN | SDP | 2015 | 2015 | NYM |
7035 | 7035 | Tyler Clippard | 30 | clippty01 | 2015 | OAK | AL | 1.527247047 | 0.605 | P | 4 | 1 | OAK | WSN | 2015 | 2015 | NYM |
7057 | 7057 | Eric O'Flaherty | 30 | oflaher01 | 2015 | OAK | AL | 0.635999827 | -0.315 | P | 0 | 1 | OAK | ATL | 2014 | 2015 | NYM |
7124 | 7124 | Neil Walker | 29 | walkene01 | 2015 | PIT | NL | 5.882926829 | 2.495 | 2B | 17 | 1 | PIT | 2009 | 2015 | NYM | |
7135 | 7135 | Antonio Bastardo | 29 | bastaan01 | 2015 | PIT | NL | 1.609281655 | 0.735 | P | 5 | 1 | PIT | PHI | 2015 | 2015 | NYM |
7213 | 7213 | Robinson Cano | 32 | canoro01 | 2015 | SEA | AL | 6.402227317 | 3.075 | 2B | 18 | 1 | SEA | NYY | 2014 | 2018 | NYM |
7266 | 7266 | Joe Panik | 24 | panikjo01 | 2015 | SFG | NL | 4.320744956 | 3.535 | 2B | 16 | 1 | SFG | 2014 | 2019 | NYM | |
7291 | 7291 | Alejandro De Aza | 31 | deazaal01 | 2015 | SFG | NL | 0.750129333 | -0.08 | LF, RF, CF | 1 | 3 | SFG | BOS | 2015 | 2015 | NYM |
7360 | 7360 | Asdrubal Cabrera | 29 | cabreas01 | 2015 | TBR | AL | 5.281441084 | 2.19 | SS | 13 | 1 | TBD | WSN | 2015 | 2015 | NYM |
7385 | 7385 | James Loney | 31 | loneyja01 | 2015 | TBR | AL | 3.719054702 | -0.81 | 1B | 2 | 1 | TBD | BOS | 2013 | 2015 | NYM |
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 );