mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
622 rows where prev_franch = "COL" sorted by franch_id
This data as json, copyable, CSV (advanced)
Suggested facets: age, year_ID, lg_ID, quasi_ws, stint_ID, franch_id, year_acq, year_left, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3702 | 3702 | Jason Gurka | 29 | gurkaja01 | 2017 | LAA | AL | 0.020147241 | 0.035 | P | 0 | 1 | ANA | COL | 2017 | 2017 | |
5200 | 5200 | Rafael Ortega | 25 | ortegra01 | 2016 | LAA | AL | 1.946179402 | -0.365 | LF, CF, RF | 2 | 1 | ANA | COL | 2016 | 2016 | FLA |
6672 | 6672 | Chris Iannetta | 32 | iannech01 | 2015 | LAA | AL | 3.080764075 | 1.05 | C, 1B | 8 | 1 | ANA | COL | 2012 | 2015 | SEA |
8134 | 8134 | Chris Iannetta | 31 | iannech01 | 2014 | LAA | AL | 3.456462694 | 2.045 | C | 11 | 1 | ANA | COL | 2012 | 2015 | SEA |
9559 | 9559 | Chris Iannetta | 30 | iannech01 | 2013 | LAA | AL | 3.71043771 | 0.595 | C | 7 | 1 | ANA | COL | 2012 | 2015 | SEA |
9591 | 9591 | Thomas Field | 26 | fieldth01 | 2013 | LAA | AL | 0.251082251 | -0.4 | 2B, SS, 3B | 0 | 1 | ANA | COL | 2013 | 2013 | TEX |
10990 | 10990 | Chris Iannetta | 29 | iannech01 | 2012 | LAA | AL | 2.407942238 | 0.595 | C | 5 | 1 | ANA | COL | 2012 | 2015 | SEA |
13815 | 13815 | Brian Fuentes | 34 | fuentbr01 | 2010 | LAA | AL | 1.61374033 | 0.14 | P | 3 | 1 | ANA | COL | 2009 | 2010 | MIN |
15169 | 15169 | Brian Fuentes | 33 | fuentbr01 | 2009 | LAA | AL | 2.464972341 | 0.35 | P | 5 | 1 | ANA | COL | 2009 | 2010 | MIN |
24139 | 24139 | Sal Fasano | 30 | fasansa01 | 2002 | ANA | AL | 0.009196131 | 0.04 | C | 0 | 1 | ANA | COL | 2002 | 2002 | BAL |
26803 | 26803 | Scott Karl | 28 | karlsc01 | 2000 | ANA | AL | 0.56190445 | -0.15 | P | 0 | 2 | ANA | COL | 2000 | 2000 | |
26808 | 26808 | Edgard Clemente | 24 | clemeed02 | 2000 | ANA | AL | 0.730823752 | -0.925 | LF, RF, CF | 0 | 1 | ANA | COL | 2000 | 2000 | |
28174 | 28174 | Steve Decker | 33 | deckest01 | 1999 | ANA | AL | 0.750040923 | 0.15 | C, 1B | 1 | 1 | ANA | COL | 1999 | 1999 | |
1573 | 1573 | Daniel Descalso | 31 | descada01 | 2018 | ARI | NL | 4.211845494 | 1.32 | 2B, 3B, 1B, LF, P | 10 | 1 | ARI | COL | 2017 | 2018 | CHC |
1610 | 1610 | Jorge De La Rosa | 37 | rosajo01 | 2018 | ARI | NL | 1.02933483 | -0.415 | P | 0 | 1 | ARI | COL | 2017 | 2018 | CHC |
3114 | 3114 | Daniel Descalso | 30 | descada01 | 2017 | ARI | NL | 3.929860402 | 0.02 | 2B, LF, 1B, 3B, P, SS | 6 | 1 | ARI | COL | 2017 | 2018 | CHC |
3119 | 3119 | Jorge De La Rosa | 36 | rosajo01 | 2017 | ARI | NL | 1.687754684 | 0.315 | P | 3 | 1 | ARI | COL | 2017 | 2018 | CHC |
6101 | 6101 | Jhoulys Chacin | 27 | chacijh01 | 2015 | ARI | NL | 0.751090616 | 0.215 | P | 2 | 1 | ARI | COL | 2015 | 2015 | ATL |
6116 | 6116 | Jordan Pacheco | 29 | pachejo01 | 2015 | ARI | NL | 0.760719691 | -0.275 | C, 1B, 3B | 0 | 1 | ARI | COL | 2014 | 2015 | CIN |
6122 | 6122 | Matt Reynolds | 30 | reynoma02 | 2015 | ARI | NL | 0.505969871 | -0.335 | P | 0 | 1 | ARI | COL | 2013 | 2015 | SFG |
7591 | 7591 | Will Harris | 29 | harriwi10 | 2014 | ARI | NL | 0.789414222 | 0.12 | P | 1 | 1 | ARI | COL | 2013 | 2014 | HOU |
7606 | 7606 | Jordan Pacheco | 28 | pachejo01 | 2014 | ARI | NL | 0.855902778 | -0.33 | C, 1B, 3B, 2B | 0 | 2 | ARI | COL | 2014 | 2015 | CIN |
9008 | 9008 | Will Harris | 28 | harriwi10 | 2013 | ARI | NL | 1.511719779 | 0.81 | P | 5 | 1 | ARI | COL | 2013 | 2014 | HOU |
9011 | 9011 | Matt Reynolds | 28 | reynoma02 | 2013 | ARI | NL | 0.834316232 | 0.56 | P | 3 | 1 | ARI | COL | 2013 | 2015 | SFG |
9014 | 9014 | Wil Nieves | 35 | nievewi01 | 2013 | ARI | NL | 1.996657754 | -0.02 | C | 3 | 1 | ARI | COL | 2012 | 2013 | PHI |
10428 | 10428 | Wil Nieves | 34 | nievewi01 | 2012 | ARI | NL | 0.381512896 | 0.1 | C, 1B | 1 | 2 | ARI | COL | 2012 | 2013 | PHI |
11857 | 11857 | Melvin Mora | 39 | morame01 | 2011 | ARI | NL | 1.366253708 | -0.89 | 3B, 1B | 0 | 1 | ARI | COL | 2011 | 2011 | |
15979 | 15979 | Jeff Salazar | 27 | salazje01 | 2008 | ARI | NL | 1.526315789 | -0.645 | LF, RF, CF | 0 | 1 | ARI | COL | 2007 | 2008 | PIT |
17343 | 17343 | Jeff Salazar | 26 | salazje01 | 2007 | ARI | NL | 1.041129313 | 0.72 | RF, LF, CF | 4 | 1 | ARI | COL | 2007 | 2008 | PIT |
20096 | 20096 | Royce Clayton | 35 | claytro01 | 2005 | ARI | NL | 5.560314539 | 0.12 | SS | 9 | 1 | ARI | COL | 2005 | 2005 | WSN |
20097 | 20097 | Shawn Estes | 32 | estessh01 | 2005 | ARI | NL | 3.456476877 | 0.685 | P | 8 | 1 | ARI | COL | 2005 | 2005 | SDP |
20121 | 20121 | Javier Lopez | 27 | lopezja02 | 2005 | ARI | NL | 0.487984283 | -0.455 | P | 0 | 2 | ARI | COL | 2005 | 2005 | BOS |
21484 | 21484 | Jeff Fassero | 41 | fasseje01 | 2004 | ARI | NL | 0.02634503 | 0.025 | P | 0 | 2 | ARI | COL | 2004 | 2004 | SFG |
21485 | 21485 | Bobby Estalella | 29 | estalbo02 | 2004 | ARI | NL | 0.140508739 | 0.0 | C | 0 | 1 | ARI | COL | 2004 | 2004 | TOR |
22835 | 22835 | Mike Myers | 34 | myersmi01 | 2003 | ARI | NL | 1.144692565 | -0.1 | P | 1 | 1 | ARI | COL | 2002 | 2003 | SEA |
24165 | 24165 | Mike Myers | 33 | myersmi01 | 2002 | ARI | NL | 1.377863159 | 0.49 | P | 4 | 1 | ARI | COL | 2002 | 2003 | SEA |
25500 | 25500 | Juan Sosa | 25 | sosaju01 | 2001 | ARI | NL | 0.009694133 | -0.005 | 3B | 0 | 1 | ARI | COL | 2001 | 2001 | |
26849 | 26849 | Lenny Harris | 35 | harrile01 | 2000 | ARI | NL | 0.902222222 | -1.01 | 3B, 1B, LF, RF, 2B | 0 | 1 | ARI | COL | 1999 | 2000 | NYM |
28220 | 28220 | Lenny Harris | 34 | harrile01 | 1999 | ARI | NL | 0.289951675 | 0.185 | 2B, RF, 3B, LF | 1 | 2 | ARI | COL | 1999 | 2000 | NYM |
91 | 91 | Shane Carle | 27 | carlesh01 | 2019 | ATL | NL | 0.22746425 | -0.392264151 | P | 0 | 1 | ATL | COL | 2018 | 2019 | |
1630 | 1630 | Shane Carle | 26 | carlesh01 | 2018 | ATL | NL | 2.244585527 | 0.705 | P | 5 | 1 | ATL | COL | 2018 | 2019 | |
1650 | 1650 | Rex Brothers | 30 | brothre01 | 2018 | ATL | NL | 0.0 | 0.0 | P | 0 | 1 | ATL | COL | 2017 | 2018 | |
3167 | 3167 | Jason Motte | 35 | motteja01 | 2017 | ATL | NL | 1.167161409 | 0.17 | P | 2 | 1 | ATL | COL | 2017 | 2017 | |
3174 | 3174 | Rex Brothers | 29 | brothre01 | 2017 | ATL | NL | 0.650345431 | -0.11 | P | 1 | 1 | ATL | COL | 2017 | 2018 | |
14633 | 14633 | Vladimir Nunez | 34 | nunezvl01 | 2009 | ATL | NL | 0.018641811 | -0.18 | P | 0 | 1 | ATL | COL | 2008 | 2009 | |
15999 | 15999 | Mike Hampton | 35 | hamptmi01 | 2008 | ATL | NL | 2.227051056 | 0.38 | P | 4 | 1 | ATL | COL | 2003 | 2008 | HOU |
16002 | 16002 | Vladimir Nunez | 33 | nunezvl01 | 2008 | ATL | NL | 0.808667793 | 0.24 | P | 2 | 1 | ATL | COL | 2008 | 2009 | |
16025 | 16025 | Elmer Dessens | 37 | desseel01 | 2008 | ATL | NL | 0.108740354 | -0.405 | P | 0 | 1 | ATL | COL | 2008 | 2008 | NYM |
20142 | 20142 | Mike Hampton | 32 | hamptmi01 | 2005 | ATL | NL | 1.939460356 | 1.485 | P | 7 | 1 | ATL | COL | 2003 | 2008 | HOU |
20159 | 20159 | Adam Bernero | 28 | bernead01 | 2005 | ATL | NL | 1.293750598 | -0.3 | P | 1 | 1 | ATL | COL | 2005 | 2005 | PHI |
21514 | 21514 | Mike Hampton | 31 | hamptmi01 | 2004 | ATL | NL | 4.849149775 | 1.98 | P | 13 | 1 | ATL | COL | 2003 | 2008 | HOU |
22853 | 22853 | Mike Hampton | 30 | hamptmi01 | 2003 | ATL | NL | 5.301804384 | 2.82 | P | 17 | 1 | ATL | COL | 2003 | 2008 | HOU |
26859 | 26859 | Andres Galarraga | 39 | galaran01 | 2000 | ATL | NL | 5.411884897 | 1.33 | 1B | 12 | 1 | ATL | COL | 1998 | 2000 | TEX |
26864 | 26864 | Walt Weiss | 36 | weisswa01 | 2000 | ATL | NL | 2.241784437 | 1.065 | SS | 7 | 1 | ATL | COL | 1998 | 2000 | |
26892 | 26892 | Stan Belinda | 33 | belinst01 | 2000 | ATL | NL | 0.270295187 | -0.3 | P | 0 | 2 | ATL | COL | 2000 | 2000 | |
28256 | 28256 | Walt Weiss | 35 | weisswa01 | 1999 | ATL | NL | 3.183282981 | -0.4 | SS | 4 | 1 | ATL | COL | 1998 | 2000 | |
29539 | 29539 | Andres Galarraga | 37 | galaran01 | 1998 | ATL | NL | 6.466620785 | 5.01 | 1B | 24 | 1 | ATL | COL | 1998 | 2000 | TEX |
29544 | 29544 | Walt Weiss | 34 | weisswa01 | 1998 | ATL | NL | 4.231245699 | 2.785 | SS | 14 | 1 | ATL | COL | 1998 | 2000 | |
29559 | 29559 | Greg Colbrunn | 28 | colbrgr01 | 1998 | ATL | NL | 0.4889883 | 0.195 | 1B, RF, C | 1 | 2 | ATL | COL | 1998 | 1998 | ARI |
107 | 107 | Miguel Castro | 24 | castrmi01 | 2019 | BAL | AL | 2.240454464 | 0.499245283 | P | 4 | 1 | BAL | COL | 2017 | 2019 | |
1684 | 1684 | Miguel Castro | 23 | castrmi01 | 2018 | BAL | AL | 2.614431697 | 0.55 | P | 5 | 1 | BAL | COL | 2017 | 2019 | |
3211 | 3211 | Miguel Castro | 22 | castrmi01 | 2017 | BAL | AL | 1.997483283 | 0.405 | P | 4 | 1 | BAL | COL | 2017 | 2019 | |
6227 | 6227 | Jorge Rondon | 27 | rondojo01 | 2015 | BAL | AL | 0.250257354 | -0.305 | P | 0 | 2 | BAL | COL | 2015 | 2015 | PIT |
9096 | 9096 | Jason Hammel | 30 | hammeja01 | 2013 | BAL | AL | 3.793838975 | 0.08 | P | 6 | 1 | BAL | COL | 2012 | 2013 | CHC |
10495 | 10495 | Jason Hammel | 29 | hammeja01 | 2012 | BAL | AL | 3.178942699 | 2.66 | P | 13 | 1 | BAL | COL | 2012 | 2013 | CHC |
10516 | 10516 | Matt Lindstrom | 32 | lindsma01 | 2012 | BAL | AL | 0.921248931 | 0.495 | P | 3 | 1 | BAL | COL | 2012 | 2012 | ARI |
13332 | 13332 | Garrett Atkins | 30 | atkinga01 | 2010 | BAL | AL | 1.448094612 | -1.255 | 1B | 0 | 1 | BAL | COL | 2010 | 2010 | |
18832 | 18832 | Danny Ardoin | 31 | ardoida01 | 2006 | BAL | AL | 0.139916372 | -0.19 | C | 0 | 2 | BAL | COL | 2006 | 2006 | LAD |
20195 | 20195 | Eric Byrnes | 29 | byrneer01 | 2005 | BAL | AL | 1.716200752 | -0.145 | LF, RF, CF | 2 | 3 | BAL | COL | 2005 | 2005 | ARI |
20218 | 20218 | Steve Reed | 40 | reedst01 | 2005 | BAL | AL | 0.864332341 | -0.32 | P | 0 | 1 | BAL | COL | 2005 | 2005 | |
21576 | 21576 | Jack Cust | 25 | custja01 | 2004 | BAL | AL | 0.009048362 | -0.015 | 0 | 1 | BAL | COL | 2003 | 2004 | SDP | |
22905 | 22905 | Jack Cust | 24 | custja01 | 2003 | BAL | AL | 0.783153834 | 0.303128834 | LF | 2 | 1 | BAL | COL | 2003 | 2004 | SDP |
25576 | 25576 | John Wasdin | 28 | wasdijo01 | 2001 | BAL | AL | 1.465928976 | 0.545 | P | 4 | 2 | BAL | COL | 2001 | 2001 | TOR |
3286 | 3286 | Kyle Kendrick | 32 | kendrky01 | 2017 | BOS | AL | 0.222730665 | -0.21 | P | 0 | 1 | BOS | COL | 2017 | 2017 | |
3288 | 3288 | Josh Rutledge | 28 | rutlejo01 | 2017 | BOS | AL | 1.083768804 | -0.45 | 3B, 2B, 1B | 0 | 1 | BOS | COL | 2015 | 2017 | |
4777 | 4777 | Josh Rutledge | 27 | rutlejo01 | 2016 | BOS | AL | 0.516129032 | 0.295 | 3B, 2B, SS | 1 | 1 | BOS | COL | 2015 | 2017 | |
6264 | 6264 | Josh Rutledge | 26 | rutlejo01 | 2015 | BOS | AL | 0.793625241 | 0.095 | 2B, 3B | 1 | 1 | BOS | COL | 2015 | 2017 | |
7730 | 7730 | Jonathan Herrera | 29 | herrejo03 | 2014 | BOS | AL | 0.971962617 | -0.085 | SS, 3B, 2B, 1B | 1 | 1 | BOS | COL | 2014 | 2014 | CHC |
9163 | 9163 | Franklin Morales | 27 | moralfr01 | 2013 | BOS | AL | 0.814364217 | -0.025 | P | 1 | 1 | BOS | COL | 2011 | 2013 | COL |
9173 | 9173 | Clayton Mortensen | 28 | mortecl01 | 2013 | BOS | AL | 0.781872606 | -0.265 | P | 0 | 1 | BOS | COL | 2012 | 2013 | |
10560 | 10560 | Franklin Morales | 26 | moralfr01 | 2012 | BOS | AL | 2.433420925 | 0.5 | P | 5 | 1 | BOS | COL | 2011 | 2013 | COL |
10569 | 10569 | Clayton Mortensen | 27 | mortecl01 | 2012 | BOS | AL | 1.108495268 | 0.21 | P | 2 | 1 | BOS | COL | 2012 | 2013 | |
10577 | 10577 | Aaron Cook | 33 | cookaa01 | 2012 | BOS | AL | 2.620295394 | -0.895 | P | 1 | 1 | BOS | COL | 2012 | 2012 | |
11978 | 11978 | Franklin Morales | 25 | moralfr01 | 2011 | BOS | AL | 0.924607125 | 0.18 | P | 2 | 2 | BOS | COL | 2011 | 2013 | COL |
18865 | 18865 | Gabe Kapler | 30 | kaplega01 | 2006 | BOS | AL | 1.329694323 | 0.305 | RF, LF, CF | 3 | 1 | BOS | COL | 2003 | 2006 | MIL |
18885 | 18885 | Dustan Mohr | 30 | mohrdu01 | 2006 | BOS | AL | 0.388958203 | -0.07 | CF, LF, RF | 0 | 1 | BOS | COL | 2006 | 2006 | TBD |
20236 | 20236 | Mark Bellhorn | 30 | bellhma01 | 2005 | BOS | AL | 3.045931964 | 0.535 | 2B, 3B, SS | 6 | 1 | BOS | COL | 2004 | 2005 | NYY |
20242 | 20242 | Gabe Kapler | 29 | kaplega01 | 2005 | BOS | AL | 0.945602759 | 0.47 | RF, CF, LF | 3 | 1 | BOS | COL | 2003 | 2006 | MIL |
21597 | 21597 | Mark Bellhorn | 29 | bellhma01 | 2004 | BOS | AL | 5.539125077 | 3.53 | 2B, 3B, SS | 18 | 1 | BOS | COL | 2004 | 2005 | NYY |
21612 | 21612 | Gabe Kapler | 28 | kaplega01 | 2004 | BOS | AL | 2.769562539 | 0.05 | RF, LF, CF | 4 | 1 | BOS | COL | 2003 | 2006 | MIL |
22944 | 22944 | Gabe Kapler | 27 | kaplega01 | 2003 | BOS | AL | 1.532882606 | 0.18 | RF, LF, CF, 1B | 2 | 2 | BOS | COL | 2003 | 2006 | MIL |
22946 | 22946 | Todd Jones | 35 | jonesto02 | 2003 | BOS | AL | 0.740998447 | 0.15 | P | 1 | 2 | BOS | COL | 2003 | 2003 | CIN |
24292 | 24292 | Rolando Arrojo | 36 | arrojro01 | 2002 | BOS | AL | 2.628731443 | 0.245 | P | 4 | 1 | BOS | COL | 2000 | 2002 | |
24297 | 24297 | Benny Agbayani | 30 | agbaybe01 | 2002 | BOS | AL | 0.395245642 | 0.26 | LF, RF, CF | 1 | 2 | BOS | COL | 2002 | 2002 | |
25612 | 25612 | Rolando Arrojo | 35 | arrojro01 | 2001 | BOS | AL | 3.538323409 | 1.70552795 | P | 10 | 1 | BOS | COL | 2000 | 2002 | |
25621 | 25621 | Mike Lansing | 33 | lansimi01 | 2001 | BOS | AL | 3.55121013 | -0.08552795 | SS, 2B | 5 | 1 | BOS | COL | 2000 | 2001 | |
25634 | 25634 | Bret Saberhagen | 37 | saberbr01 | 2001 | BOS | AL | 0.40526734 | 0.02515528 | 1 | 1 | BOS | COL | 1997 | 2001 | ||
26964 | 26964 | Rolando Arrojo | 34 | arrojro01 | 2000 | BOS | AL | 1.954187929 | 0.855 | P | 5 | 2 | BOS | COL | 2000 | 2002 | |
26984 | 26984 | Rich Croushore | 29 | crousri01 | 2000 | BOS | AL | 0.113487249 | -0.005 | P | 0 | 2 | BOS | COL | 2000 | 2000 | |
26998 | 26998 | Mike Lansing | 32 | lansimi01 | 2000 | BOS | AL | 1.351811024 | -1.14 | 2B, 3B | 0 | 2 | BOS | COL | 2000 | 2001 |
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 );