mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
98,796 rows sorted by name_common
This data as json, copyable, CSV (advanced)
Suggested facets: lg_ID, franch_id, prev_franch, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5203 | 5203 | A.J. Achter | 27 | achteaj01 | 2016 | LAA | AL | 0.837942351 | 0.035 | P | 1 | 1 | ANA | MIN | 2016 | 2016 | |
6905 | 6905 | A.J. Achter | 26 | achteaj01 | 2015 | MIN | AL | 0.29287461 | -0.195 | P | 0 | 1 | MIN | 2014 | 2015 | ANA | |
8347 | 8347 | A.J. Achter | 25 | achteaj01 | 2014 | MIN | AL | 0.268137943 | -0.065 | P | 0 | 1 | MIN | 2014 | 2015 | ANA | |
7126 | 7126 | A.J. Burnett | 38 | burnea.01 | 2015 | PIT | NL | 4.36962429 | 2.605 | P | 15 | 1 | PIT | PHI | 2015 | 2015 | |
8516 | 8516 | A.J. Burnett | 37 | burnea.01 | 2014 | PHI | NL | 5.83352562 | 1.005 | P | 11 | 1 | PHI | PIT | 2014 | 2014 | PIT |
9990 | 9990 | A.J. Burnett | 36 | burnea.01 | 2013 | PIT | NL | 5.211286557 | 2.555 | P | 16 | 1 | PIT | NYY | 2012 | 2013 | PHI |
11400 | 11400 | A.J. Burnett | 35 | burnea.01 | 2012 | PIT | NL | 5.66007779 | 2.725 | P | 17 | 1 | PIT | NYY | 2012 | 2013 | PHI |
12652 | 12652 | A.J. Burnett | 34 | burnea.01 | 2011 | NYY | AL | 5.121135344 | 0.225 | P | 7 | 1 | NYY | TOR | 2009 | 2011 | PIT |
14033 | 14033 | A.J. Burnett | 33 | burnea.01 | 2010 | NYY | AL | 5.248659266 | 0.32 | P | 8 | 1 | NYY | TOR | 2009 | 2011 | PIT |
15389 | 15389 | A.J. Burnett | 32 | burnea.01 | 2009 | NYY | AL | 5.686155045 | 3.625 | P | 19 | 1 | NYY | TOR | 2009 | 2011 | PIT |
17234 | 17234 | A.J. Burnett | 31 | burnea.01 | 2008 | TOR | AL | 6.1281575 | 3.625 | P | 19 | 1 | TOR | FLA | 2006 | 2008 | NYY |
18622 | 18622 | A.J. Burnett | 30 | burnea.01 | 2007 | TOR | AL | 4.519604756 | 2.345 | P | 13 | 1 | TOR | FLA | 2006 | 2008 | NYY |
19995 | 19995 | A.J. Burnett | 29 | burnea.01 | 2006 | TOR | AL | 3.841408007 | 2.365 | P | 12 | 1 | TOR | FLA | 2006 | 2008 | NYY |
20541 | 20541 | A.J. Burnett | 28 | burnea.01 | 2005 | FLA | NL | 5.912099355 | 4.415 | P | 21 | 1 | FLA | 1999 | 2005 | TOR | |
21918 | 21918 | A.J. Burnett | 27 | burnea.01 | 2004 | FLA | NL | 3.301259665 | 2.25 | P | 12 | 1 | FLA | 1999 | 2005 | TOR | |
23279 | 23279 | A.J. Burnett | 26 | burnea.01 | 2003 | FLA | NL | 0.657359313 | 0.165 | P | 1 | 1 | FLA | 1999 | 2005 | TOR | |
24592 | 24592 | A.J. Burnett | 25 | burnea.01 | 2002 | FLA | NL | 5.593406185 | 4.39 | P | 21 | 1 | FLA | 1999 | 2005 | TOR | |
25935 | 25935 | A.J. Burnett | 24 | burnea.01 | 2001 | FLA | NL | 4.881566948 | 1.245 | P | 10 | 1 | FLA | 1999 | 2005 | TOR | |
27296 | 27296 | A.J. Burnett | 23 | burnea.01 | 2000 | FLA | NL | 2.297101713 | 1.272857143 | P | 7 | 1 | FLA | 1999 | 2005 | TOR | |
28648 | 28648 | A.J. Burnett | 22 | burnea.01 | 1999 | FLA | NL | 1.150087033 | 0.32 | P | 3 | 1 | FLA | 1999 | 2005 | TOR | |
380 | 380 | A.J. Cole | 27 | coleaj01 | 2019 | CLE | AL | 0.71867871 | 0.050943396 | P | 1 | 1 | CLE | NYY | 2019 | 2019 | |
2516 | 2516 | A.J. Cole | 26 | coleaj01 | 2018 | NYY | AL | 0.885545188 | -0.13 | P | 1 | 2 | NYY | WSN | 2018 | 2018 | CLE |
3094 | 3094 | A.J. Cole | 26 | coleaj01 | 2018 | WSN | NL | 0.236419913 | -0.34 | P | 0 | 1 | WSN | 2015 | 2018 | NYY | |
4560 | 4560 | A.J. Cole | 25 | coleaj01 | 2017 | WSN | NL | 1.434135676 | 0.675 | P | 4 | 1 | WSN | 2015 | 2018 | NYY | |
6065 | 6065 | A.J. Cole | 24 | coleaj01 | 2016 | WSN | NL | 1.05248151 | -0.025 | P | 1 | 1 | WSN | 2015 | 2018 | NYY | |
7555 | 7555 | A.J. Cole | 23 | coleaj01 | 2015 | WSN | NL | 0.193559388 | -0.14 | P | 0 | 1 | WSN | 2015 | 2018 | NYY | |
2704 | 2704 | A.J. Ellis | 37 | ellisaj01 | 2018 | SDP | NL | 1.840790843 | 0.09 | C, LF | 3 | 1 | SDP | FLA | 2018 | 2018 | |
3786 | 3786 | A.J. Ellis | 36 | ellisaj01 | 2017 | MIA | NL | 1.594266442 | 0.2 | C | 3 | 1 | FLA | PHI | 2017 | 2017 | SDP |
5260 | 5260 | A.J. Ellis | 35 | ellisaj01 | 2016 | LAD | NL | 1.597331509 | -0.315 | C | 1 | 1 | LAD | 2008 | 2016 | PHI | |
5608 | 5608 | A.J. Ellis | 35 | ellisaj01 | 2016 | PHI | NL | 0.357583231 | 0.145 | C | 1 | 2 | PHI | LAD | 2016 | 2016 | FLA |
6727 | 6727 | A.J. Ellis | 34 | ellisaj01 | 2015 | LAD | NL | 2.191537524 | 1.045 | C | 6 | 1 | LAD | 2008 | 2016 | PHI | |
8202 | 8202 | A.J. Ellis | 33 | ellisaj01 | 2014 | LAD | NL | 3.428620102 | -0.93 | C | 2 | 1 | LAD | 2008 | 2016 | PHI | |
9604 | 9604 | A.J. Ellis | 32 | ellisaj01 | 2013 | LAD | NL | 4.488512696 | 2.16 | C | 12 | 1 | LAD | 2008 | 2016 | PHI | |
11021 | 11021 | A.J. Ellis | 31 | ellisaj01 | 2012 | LAD | NL | 5.090371915 | 2.945 | C | 16 | 1 | LAD | 2008 | 2016 | PHI | |
12477 | 12477 | A.J. Ellis | 30 | ellisaj01 | 2011 | LAD | NL | 1.040041783 | 0.342111801 | C | 2 | 1 | LAD | 2008 | 2016 | PHI | |
13862 | 13862 | A.J. Ellis | 29 | ellisaj01 | 2010 | LAD | NL | 1.283540802 | -0.085 | C | 2 | 1 | LAD | 2008 | 2016 | PHI | |
15240 | 15240 | A.J. Ellis | 28 | ellisaj01 | 2009 | LAD | NL | 0.096377534 | -0.13 | C | 0 | 1 | LAD | 2008 | 2016 | PHI | |
16603 | 16603 | A.J. Ellis | 27 | ellisaj01 | 2008 | LAD | NL | 0.029840508 | -0.085 | C | 0 | 1 | LAD | 2008 | 2016 | PHI | |
4453 | 4453 | A.J. Griffin | 29 | griffaj01 | 2017 | TEX | AL | 2.039374304 | 0.04 | P | 3 | 1 | TEX | OAK | 2016 | 2017 | |
5945 | 5945 | A.J. Griffin | 28 | griffaj01 | 2016 | TEX | AL | 3.273344315 | 0.545 | P | 8 | 1 | TEX | OAK | 2016 | 2017 | |
9894 | 9894 | A.J. Griffin | 25 | griffaj01 | 2013 | OAK | AL | 5.642613067 | 2.135 | P | 15 | 1 | OAK | 2012 | 2013 | TEX | |
11313 | 11313 | A.J. Griffin | 24 | griffaj01 | 2012 | OAK | AL | 2.266007905 | 1.755 | P | 9 | 1 | OAK | 2012 | 2013 | TEX | |
4477 | 4477 | A.J. Jimenez | 27 | jimenaj01 | 2017 | TEX | AL | 0.123728257 | -0.225 | C | 0 | 1 | TEX | 2017 | 2017 | ||
82 | 82 | A.J. Minter | 25 | minteaj01 | 2019 | ATL | NL | 1.054679916 | -0.448301887 | P | 1 | 1 | ATL | 2017 | 2019 | ||
1628 | 1628 | A.J. Minter | 24 | minteaj01 | 2018 | ATL | NL | 2.130801514 | 1.08 | P | 6 | 1 | ATL | 2017 | 2019 | ||
3164 | 3164 | A.J. Minter | 23 | minteaj01 | 2017 | ATL | NL | 0.460279689 | 0.475 | P | 2 | 1 | ATL | 2017 | 2019 | ||
4923 | 4923 | A.J. Morris | 29 | morriaj01 | 2016 | CIN | NL | 0.212335437 | -0.09 | P | 0 | 1 | CIN | 2016 | 2016 | ||
17210 | 17210 | A.J. Murray | 26 | murraaj01 | 2008 | TEX | AL | 0.211463096 | 0.18 | P | 1 | 1 | TEX | 2007 | 2008 | ||
18601 | 18601 | A.J. Murray | 25 | murraaj01 | 2007 | TEX | AL | 0.676634243 | -0.04 | P | 1 | 1 | TEX | 2007 | 2008 | ||
4701 | 4701 | A.J. Pierzynski | 39 | pierza.01 | 2016 | ATL | NL | 2.555631167 | -1.499254658 | C | 0 | 1 | ATL | STL | 2015 | 2016 | |
6132 | 6132 | A.J. Pierzynski | 38 | pierza.01 | 2015 | ATL | NL | 4.43493511 | 1.18 | C | 10 | 1 | ATL | STL | 2015 | 2016 | |
7725 | 7725 | A.J. Pierzynski | 37 | pierza.01 | 2014 | BOS | AL | 2.560747664 | -0.52 | C | 2 | 1 | BOS | TEX | 2014 | 2014 | STL |
8786 | 8786 | A.J. Pierzynski | 37 | pierza.01 | 2014 | STL | NL | 0.889818689 | -0.47 | C | 0 | 2 | STL | BOS | 2014 | 2014 | ATL |
10267 | 10267 | A.J. Pierzynski | 36 | pierza.01 | 2013 | TEX | AL | 4.968744939 | 1.063435583 | C | 10 | 1 | TEX | CHW | 2013 | 2013 | BOS |
10654 | 10654 | A.J. Pierzynski | 35 | pierza.01 | 2012 | CHW | AL | 4.953194285 | 3.28 | C | 16 | 1 | CHW | SFG | 2005 | 2012 | TEX |
12055 | 12055 | A.J. Pierzynski | 34 | pierza.01 | 2011 | CHW | AL | 4.725435881 | 1.25 | C | 10 | 1 | CHW | SFG | 2005 | 2012 | TEX |
13439 | 13439 | A.J. Pierzynski | 33 | pierza.01 | 2010 | CHW | AL | 4.789689706 | 1.055 | C | 10 | 1 | CHW | SFG | 2005 | 2012 | TEX |
14793 | 14793 | A.J. Pierzynski | 32 | pierza.01 | 2009 | CHW | AL | 5.079391062 | 1.85 | C | 13 | 1 | CHW | SFG | 2005 | 2012 | TEX |
16177 | 16177 | A.J. Pierzynski | 31 | pierza.01 | 2008 | CHW | AL | 5.325386598 | 1.023680982 | C | 10 | 1 | CHW | SFG | 2005 | 2012 | TEX |
17565 | 17565 | A.J. Pierzynski | 30 | pierza.01 | 2007 | CHW | AL | 4.853995396 | 1.04 | C | 10 | 1 | CHW | SFG | 2005 | 2012 | TEX |
18954 | 18954 | A.J. Pierzynski | 29 | pierza.01 | 2006 | CHW | AL | 5.006199332 | 2.05 | C | 13 | 1 | CHW | SFG | 2005 | 2012 | TEX |
20328 | 20328 | A.J. Pierzynski | 28 | pierza.01 | 2005 | CHW | AL | 4.708591963 | 1.93 | C | 13 | 1 | CHW | SFG | 2005 | 2012 | TEX |
22548 | 22548 | A.J. Pierzynski | 27 | pierza.01 | 2004 | SFG | NL | 4.864331524 | 0.375 | C | 9 | 1 | SFG | MIN | 2004 | 2004 | CHW |
23479 | 23479 | A.J. Pierzynski | 26 | pierza.01 | 2003 | MIN | AL | 4.909321899 | 4.05 | C | 19 | 1 | MIN | 1998 | 2003 | SFG | |
24823 | 24823 | A.J. Pierzynski | 25 | pierza.01 | 2002 | MIN | AL | 4.407323396 | 2.23378882 | C | 13 | 1 | MIN | 1998 | 2003 | SFG | |
26153 | 26153 | A.J. Pierzynski | 24 | pierza.01 | 2001 | MIN | AL | 3.827793092 | 1.77 | C | 11 | 1 | MIN | 1998 | 2003 | SFG | |
27526 | 27526 | A.J. Pierzynski | 23 | pierza.01 | 2000 | MIN | AL | 0.888888889 | 0.61 | C | 3 | 1 | MIN | 1998 | 2003 | SFG | |
28871 | 28871 | A.J. Pierzynski | 22 | pierza.01 | 1999 | MIN | AL | 0.228084549 | 0.155962733 | C | 1 | 1 | MIN | 1998 | 2003 | SFG | |
30203 | 30203 | A.J. Pierzynski | 21 | pierza.01 | 1998 | MIN | AL | 0.120697935 | -0.075 | C | 0 | 1 | MIN | 1998 | 2003 | SFG | |
674 | 674 | A.J. Pollock | 31 | polloaj01 | 2019 | LAD | NL | 3.368257798 | 0.616415094 | CF, LF | 7 | 1 | LAD | ARI | 2019 | 2019 | |
1571 | 1571 | A.J. Pollock | 30 | polloaj01 | 2018 | ARI | NL | 4.580257511 | 2.545 | CF | 14 | 1 | ARI | 2012 | 2018 | LAD | |
3106 | 3106 | A.J. Pollock | 29 | polloaj01 | 2017 | ARI | NL | 4.601293837 | 2.65 | CF | 14 | 1 | ARI | 2012 | 2018 | LAD | |
4617 | 4617 | A.J. Pollock | 28 | polloaj01 | 2016 | ARI | NL | 0.450219372 | 0.445 | CF | 2 | 1 | ARI | 2012 | 2018 | LAD | |
6075 | 6075 | A.J. Pollock | 27 | polloaj01 | 2015 | ARI | NL | 6.563645536 | 7.02 | CF | 29 | 1 | ARI | 2012 | 2018 | LAD | |
7560 | 7560 | A.J. Pollock | 26 | polloaj01 | 2014 | ARI | NL | 2.889930556 | 3.305 | CF, LF | 14 | 1 | ARI | 2012 | 2018 | LAD | |
8995 | 8995 | A.J. Pollock | 25 | polloaj01 | 2013 | ARI | NL | 4.671791444 | 2.72 | CF, LF, RF | 15 | 1 | ARI | 2012 | 2018 | LAD | |
10430 | 10430 | A.J. Pollock | 24 | polloaj01 | 2012 | ARI | NL | 0.933702614 | -0.05 | CF, LF, RF | 1 | 1 | ARI | 2012 | 2018 | LAD | |
989 | 989 | A.J. Puk | 24 | pukaj01 | 2019 | OAK | AL | 0.338107388 | 0.168113208 | P | 1 | 1 | OAK | 2019 | 2019 | ||
29937 | 29937 | A.J. Sager | 33 | sagera.01 | 1998 | DET | AL | 1.83608661 | -0.545 | P | 0 | 1 | DET | COL | 1996 | 1998 | |
31167 | 31167 | A.J. Sager | 32 | sagera.01 | 1997 | DET | AL | 3.239494874 | 1.085 | 8 | 1 | DET | COL | 1996 | 1998 | ||
32421 | 32421 | A.J. Sager | 31 | sagera.01 | 1996 | DET | AL | 2.395718008 | 1.175 | 7 | 1 | DET | COL | 1996 | 1998 | ||
33647 | 33647 | A.J. Sager | 30 | sagera.01 | 1995 | COL | NL | 0.345239699 | -0.21375 | P | 0 | 1 | COL | SDP | 1995 | 1995 | DET |
35322 | 35322 | A.J. Sager | 29 | sagera.01 | 1994 | SDP | NL | 1.572643588 | 0.062307692 | P | 2 | 1 | SDP | 1994 | 1994 | COL | |
4141 | 4141 | A.J. Schugel | 28 | schugaj01 | 2017 | PIT | NL | 0.890747456 | 0.575 | P | 3 | 1 | PIT | ARI | 2016 | 2017 | |
5650 | 5650 | A.J. Schugel | 27 | schugaj01 | 2016 | PIT | NL | 1.39439227 | 0.65 | P | 4 | 1 | PIT | ARI | 2016 | 2017 | |
6121 | 6121 | A.J. Schugel | 26 | schugaj01 | 2015 | ARI | NL | 0.163333172 | -0.33 | P | 0 | 1 | ARI | 2015 | 2015 | PIT | |
22387 | 22387 | AJ Hinch | 30 | hincha.01 | 2004 | PHI | NL | 0.104607313 | 0.01 | C | 0 | 1 | PHI | DET | 2004 | 2004 | |
23244 | 23244 | AJ Hinch | 29 | hincha.01 | 2003 | DET | AL | 0.785855915 | -0.195 | C | 0 | 1 | DET | KCR | 2003 | 2003 | PHI |
24687 | 24687 | AJ Hinch | 28 | hincha.01 | 2002 | KCR | AL | 2.063389392 | 0.705 | C | 5 | 1 | KCR | OAK | 2001 | 2002 | DET |
26055 | 26055 | AJ Hinch | 27 | hincha.01 | 2001 | KCR | AL | 1.262918427 | -0.6 | C | 0 | 1 | KCR | OAK | 2001 | 2002 | DET |
27726 | 27726 | AJ Hinch | 26 | hincha.01 | 2000 | OAK | AL | 0.081447964 | -0.005031056 | C | 0 | 1 | OAK | 1998 | 2000 | KCR | |
29042 | 29042 | AJ Hinch | 25 | hincha.01 | 1999 | OAK | AL | 2.060133977 | -0.505 | C | 1 | 1 | OAK | 1998 | 2000 | KCR | |
30349 | 30349 | AJ Hinch | 24 | hincha.01 | 1998 | OAK | AL | 3.619792498 | 0.66 | C | 7 | 1 | OAK | 1998 | 2000 | KCR | |
2470 | 2470 | AJ Ramos | 31 | ramosaj01 | 2018 | NYM | NL | 0.681948097 | -0.33 | P | 0 | 1 | NYM | FLA | 2017 | 2018 | |
3785 | 3785 | AJ Ramos | 30 | ramosaj01 | 2017 | MIA | NL | 1.457749496 | 0.28 | P | 3 | 1 | FLA | 2012 | 2017 | NYM | |
3946 | 3946 | AJ Ramos | 30 | ramosaj01 | 2017 | NYM | NL | 0.690160504 | 0.09 | P | 1 | 2 | NYM | FLA | 2017 | 2018 | |
5292 | 5292 | AJ Ramos | 29 | ramosaj01 | 2016 | MIA | NL | 2.430557246 | 1.353354037 | P | 7 | 1 | FLA | 2012 | 2017 | NYM | |
6774 | 6774 | AJ Ramos | 28 | ramosaj01 | 2015 | MIA | NL | 2.847256636 | 1.64 | P | 9 | 1 | FLA | 2012 | 2017 | NYM | |
8238 | 8238 | AJ Ramos | 27 | ramosaj01 | 2014 | MIA | NL | 2.234731442 | 1.325 | P | 7 | 1 | FLA | 2012 | 2017 | NYM | |
9661 | 9661 | AJ Ramos | 26 | ramosaj01 | 2013 | MIA | NL | 2.410523053 | 0.785 | P | 5 | 1 | FLA | 2012 | 2017 | 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 );