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,522 rows where next_franch = "SFG" sorted by franch_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2206 | 2206 | Williams Jerez | 26 | jerezwi01 | 2018 | LAA | AL | 0.467396012 | -0.365 | P | 0 | 1 | ANA | 2018 | 2018 | SFG | |
6690 | 6690 | Conor Gillaspie | 27 | gillaco01 | 2015 | LAA | AL | 0.660857909 | -0.17 | 3B, 1B, 2B | 1 | 2 | ANA | CHW | 2015 | 2015 | SFG |
6710 | 6710 | Grant Green | 27 | greengr01 | 2015 | LAA | AL | 0.427613941 | -0.555 | 2B, 1B, LF, SS | 0 | 1 | ANA | OAK | 2013 | 2015 | SFG |
8156 | 8156 | Grant Green | 26 | greengr01 | 2014 | LAA | AL | 0.95446557 | -0.075 | LF, 2B, 3B, 1B, SS | 1 | 1 | ANA | OAK | 2013 | 2015 | SFG |
9566 | 9566 | Grant Green | 25 | greengr01 | 2013 | LAA | AL | 1.274009941 | 0.345 | 2B | 3 | 2 | ANA | OAK | 2013 | 2015 | SFG |
9577 | 9577 | J.C. Gutierrez | 29 | gutieju01 | 2013 | LAA | AL | 0.82487628 | -0.085 | P | 1 | 2 | ANA | KCR | 2013 | 2013 | SFG |
15172 | 15172 | Shane Loux | 29 | louxsh01 | 2009 | LAA | AL | 1.258768143 | -0.1 | P | 2 | 1 | ANA | DET | 2008 | 2009 | SFG |
16553 | 16553 | Shane Loux | 28 | louxsh01 | 2008 | LAA | AL | 0.313117135 | 0.13 | P | 1 | 1 | ANA | DET | 2008 | 2009 | SFG |
20691 | 20691 | Steve Finley | 40 | finlest01 | 2005 | LAA | AL | 4.140168722 | -1.005 | CF | 3 | 1 | ANA | LAD | 2005 | 2005 | SFG |
22796 | 22796 | Julio Ramirez | 25 | ramirju02 | 2003 | ANA | AL | 0.028538626 | -0.07 | CF, RF | 0 | 1 | ANA | CHW | 2002 | 2003 | SFG |
24137 | 24137 | Julio Ramirez | 24 | ramirju02 | 2002 | ANA | AL | 0.321864595 | 0.08 | CF, RF | 1 | 1 | ANA | CHW | 2002 | 2003 | SFG |
32153 | 32153 | J.T. Snow | 28 | snowj.01 | 1996 | CAL | AL | 5.884457107 | -0.72447205 | 1B | 6 | 1 | ANA | NYY | 1993 | 1996 | SFG |
33397 | 33397 | J.T. Snow | 27 | snowj.01 | 1995 | CAL | AL | 6.1771529 | 0.960827586 | 1B | 11 | 1 | ANA | NYY | 1993 | 1996 | SFG |
34620 | 34620 | Mark Leiter | 31 | leitema01 | 1994 | CAL | AL | 4.139207274 | 1.021304348 | 9 | 1 | ANA | DET | 1994 | 1994 | SFG | |
34646 | 34646 | J.T. Snow | 26 | snowj.01 | 1994 | CAL | AL | 3.237452172 | -1.612956522 | 1B | 0 | 1 | ANA | NYY | 1993 | 1996 | SFG |
35649 | 35649 | Scott Sanderson | 36 | sandesc01 | 1993 | CAL | AL | 3.819462378 | 1.87 | P | 11 | 1 | ANA | NYY | 1993 | 1993 | SFG |
35657 | 35657 | J.T. Snow | 25 | snowj.01 | 1993 | CAL | AL | 4.657907702 | -0.175 | 1B | 6 | 1 | ANA | NYY | 1993 | 1996 | SFG |
35659 | 35659 | Steve Frey | 29 | freyst01 | 1993 | CAL | AL | 1.947663207 | 0.825 | 5 | 1 | ANA | WSN | 1992 | 1993 | SFG | |
36856 | 36856 | Steve Frey | 28 | freyst01 | 1992 | CAL | AL | 1.480032389 | 0.085 | 2 | 1 | ANA | WSN | 1992 | 1993 | SFG | |
43268 | 43268 | Rob Wilfong | 32 | wilforo01 | 1986 | CAL | AL | 2.910592346 | 0.45 | 2B | 5 | 1 | ANA | MIN | 1982 | 1986 | SFG |
44279 | 44279 | Rob Wilfong | 31 | wilforo01 | 1985 | CAL | AL | 2.250359253 | 0.135 | 2B | 4 | 1 | ANA | MIN | 1982 | 1986 | SFG |
45274 | 45274 | Rob Wilfong | 30 | wilforo01 | 1984 | CAL | AL | 3.16996432 | 0.93 | 2B, SS | 7 | 1 | ANA | MIN | 1982 | 1986 | SFG |
46258 | 46258 | Ricky Adams | 24 | adamsri02 | 1983 | CAL | AL | 1.133460439 | 0.775 | SS, 3B, 2B | 4 | 1 | ANA | 1982 | 1983 | SFG | |
46267 | 46267 | Bob Lacey | 29 | laceybo01 | 1983 | CAL | AL | 0.434883814 | 0.12 | 1 | 1 | ANA | TEX | 1983 | 1983 | SFG | |
46271 | 46271 | Rob Wilfong | 29 | wilforo01 | 1983 | CAL | AL | 1.750873848 | -0.32 | 2B, 3B, SS | 1 | 1 | ANA | MIN | 1982 | 1986 | SFG |
47264 | 47264 | Rob Wilfong | 28 | wilforo01 | 1982 | CAL | AL | 1.013858268 | 0.675 | 2B, 3B, CF, SS, LF | 3 | 2 | ANA | MIN | 1982 | 1986 | SFG |
47280 | 47280 | Ricky Adams | 23 | adamsri02 | 1982 | CAL | AL | 0.146141732 | -0.18 | SS | 0 | 1 | ANA | 1982 | 1983 | SFG | |
49211 | 49211 | Jim Barr | 32 | barrji01 | 1980 | CAL | AL | 1.645113429 | -0.415125 | 1 | 1 | ANA | SFG | 1979 | 1980 | SFG | |
50140 | 50140 | Jim Barr | 31 | barrji01 | 1979 | CAL | AL | 5.183080429 | 2.095 | 14 | 1 | ANA | SFG | 1979 | 1980 | SFG | |
51123 | 51123 | Tom Griffin | 30 | griffto02 | 1978 | CAL | AL | 1.531190538 | -0.67 | 0 | 1 | ANA | SDP | 1978 | 1978 | SFG | |
55756 | 55756 | Steve Barber | 35 | barbest01 | 1973 | CAL | AL | 2.576333257 | 0.755 | 6 | 1 | ANA | ATL | 1972 | 1973 | SFG | |
56646 | 56646 | Steve Barber | 34 | barbest01 | 1972 | CAL | AL | 1.768207113 | 0.731612903 | P | 5 | 2 | ANA | ATL | 1972 | 1973 | SFG |
56664 | 56664 | Don Rose | 25 | rosedo01 | 1972 | CAL | AL | 1.30075006 | -0.376258065 | P | 1 | 1 | ANA | NYM | 1972 | 1972 | SFG |
61779 | 61779 | Norm Siebern | 32 | siebeno01 | 1966 | CAL | AL | 4.160511364 | 0.665 | 1B | 9 | 1 | ANA | BAL | 1966 | 1966 | SFG |
63544 | 63544 | Jack Hiatt | 21 | hiattja01 | 1964 | LAA | AL | 0.188006483 | 0.035 | C, 1B | 0 | 1 | ANA | 1964 | 1964 | SFG | |
3118 | 3118 | Gregor Blanco | 33 | blancgr01 | 2017 | ARI | NL | 2.527749404 | 0.28 | LF, CF, RF | 4 | 1 | ARI | SFG | 2017 | 2017 | SFG |
6122 | 6122 | Matt Reynolds | 30 | reynoma02 | 2015 | ARI | NL | 0.505969871 | -0.335 | P | 0 | 1 | ARI | COL | 2013 | 2015 | SFG |
9011 | 9011 | Matt Reynolds | 28 | reynoma02 | 2013 | ARI | NL | 0.834316232 | 0.56 | P | 3 | 1 | ARI | COL | 2013 | 2015 | SFG |
11844 | 11844 | Cole Gillespie | 27 | gilleco01 | 2011 | ARI | NL | 0.070842785 | 0.11 | LF, RF | 0 | 1 | ARI | 2010 | 2011 | SFG | |
13239 | 13239 | Cole Gillespie | 26 | gilleco01 | 2010 | ARI | NL | 1.126310363 | -0.57 | LF, RF, CF | 0 | 1 | ARI | 2010 | 2011 | SFG | |
14578 | 14578 | Yusmeiro Petit | 24 | petityu01 | 2009 | ARI | NL | 2.506700751 | -0.45 | P | 2 | 1 | ARI | FLA | 2007 | 2009 | SFG |
15943 | 15943 | Randy Johnson | 44 | johnsra05 | 2008 | ARI | NL | 5.290954357 | 3.355 | P | 18 | 1 | ARI | NYY | 2007 | 2008 | SFG |
15960 | 15960 | Yusmeiro Petit | 23 | petityu01 | 2008 | ARI | NL | 1.394652185 | 0.24 | P | 3 | 1 | ARI | FLA | 2007 | 2009 | SFG |
15965 | 15965 | Brandon Medders | 28 | meddebr01 | 2008 | ARI | NL | 0.441527947 | 0.015 | P | 1 | 1 | ARI | 2005 | 2008 | SFG | |
17339 | 17339 | Randy Johnson | 43 | johnsra05 | 2007 | ARI | NL | 1.600938866 | 1.34 | P | 7 | 1 | ARI | NYY | 2007 | 2008 | SFG |
17349 | 17349 | Yusmeiro Petit | 22 | petityu01 | 2007 | ARI | NL | 1.464738842 | 0.165 | P | 3 | 1 | ARI | FLA | 2007 | 2009 | SFG |
17368 | 17368 | Brandon Medders | 27 | meddebr01 | 2007 | ARI | NL | 0.762599916 | -0.31 | P | 0 | 1 | ARI | 2005 | 2008 | SFG | |
18727 | 18727 | Brandon Medders | 26 | meddebr01 | 2006 | ARI | NL | 2.060776357 | 0.635 | P | 5 | 1 | ARI | 2005 | 2008 | SFG | |
20102 | 20102 | Brandon Medders | 25 | meddebr01 | 2005 | ARI | NL | 0.766641298 | 0.675 | P | 3 | 1 | ARI | 2005 | 2008 | SFG | |
20103 | 20103 | Tim Worrell | 37 | worreti01 | 2005 | ARI | NL | 1.125183625 | 0.325 | P | 3 | 2 | ARI | PHI | 2005 | 2005 | SFG |
21484 | 21484 | Jeff Fassero | 41 | fasseje01 | 2004 | ARI | NL | 0.02634503 | 0.025 | P | 0 | 2 | ARI | COL | 2004 | 2004 | SFG |
25466 | 25466 | Reggie Sanders | 33 | sandere02 | 2001 | ARI | NL | 4.808290155 | 3.13 | RF | 15 | 1 | ARI | ATL | 2001 | 2001 | SFG |
25489 | 25489 | Troy Brohawn | 28 | brohatr01 | 2001 | ARI | NL | 1.470219031 | 0.12 | P | 2 | 1 | ARI | 2001 | 2001 | SFG | |
28232 | 28232 | Dante Powell | 25 | powelda01 | 1999 | ARI | NL | 0.270621563 | -0.425 | CF, RF | 0 | 1 | ARI | SFG | 1999 | 1999 | SFG |
29507 | 29507 | Alan Embree | 28 | embreal01 | 1998 | ARI | NL | 1.14141688 | 0.04 | P | 2 | 2 | ARI | ATL | 1998 | 1998 | SFG |
29517 | 29517 | Chris Jones | 32 | jonesch05 | 1998 | ARI | NL | 0.342480028 | -0.085 | RF, LF | 0 | 1 | ARI | SDP | 1998 | 1998 | SFG |
29530 | 29530 | Felix Rodriguez | 25 | rodrife01 | 1998 | ARI | NL | 1.236767896 | -0.45 | 0 | 1 | ARI | CIN | 1998 | 1998 | SFG | |
1651 | 1651 | Michael Reed | 25 | reedmi02 | 2018 | ATL | NL | 0.068546345 | -0.005 | LF | 0 | 1 | ATL | MIL | 2018 | 2018 | SFG |
4671 | 4671 | Gordon Beckham | 29 | beckhgo01 | 2016 | ATL | NL | 2.693773392 | -0.593664596 | 2B, 3B, SS | 2 | 1 | ATL | CHW | 2016 | 2016 | SFG |
4677 | 4677 | Casey Kelly | 26 | kellyca01 | 2016 | ATL | NL | 0.744740139 | -0.070434783 | P | 1 | 1 | ATL | SDP | 2016 | 2016 | SFG |
7631 | 7631 | Ramiro Pena | 28 | penara02 | 2014 | ATL | NL | 1.676888032 | 0.365 | 2B, 3B, SS | 3 | 1 | ATL | NYY | 2013 | 2014 | SFG |
7648 | 7648 | Dan Uggla | 34 | ugglada01 | 2014 | ATL | NL | 1.473628877 | -0.81 | 2B | 0 | 1 | ATL | FLA | 2011 | 2014 | SFG |
9046 | 9046 | Tim Hudson | 37 | hudsoti01 | 2013 | ATL | NL | 3.679577615 | 1.605 | P | 10 | 1 | ATL | OAK | 2005 | 2013 | SFG |
9052 | 9052 | Dan Uggla | 33 | ugglada01 | 2013 | ATL | NL | 5.396984925 | -0.28 | 2B | 7 | 1 | ATL | FLA | 2011 | 2014 | SFG |
9054 | 9054 | Ramiro Pena | 27 | penara02 | 2013 | ATL | NL | 1.075376884 | 0.915 | 3B, 2B, SS | 4 | 1 | ATL | NYY | 2013 | 2014 | SFG |
9068 | 9068 | Cory Gearrin | 27 | gearrco01 | 2013 | ATL | NL | 0.822331351 | -0.015 | P | 1 | 1 | ATL | 2011 | 2013 | SFG | |
10452 | 10452 | Dan Uggla | 32 | ugglada01 | 2012 | ATL | NL | 6.332755633 | 3.075 | 2B | 20 | 1 | ATL | FLA | 2011 | 2014 | SFG |
10458 | 10458 | Tim Hudson | 36 | hudsoti01 | 2012 | ATL | NL | 5.004209727 | 1.96 | P | 14 | 1 | ATL | OAK | 2005 | 2013 | SFG |
10472 | 10472 | Cory Gearrin | 26 | gearrco01 | 2012 | ATL | NL | 0.595009551 | 0.36 | P | 2 | 1 | ATL | 2011 | 2013 | SFG | |
11860 | 11860 | Tim Hudson | 35 | hudsoti01 | 2011 | ATL | NL | 5.644089551 | 2.885 | P | 18 | 1 | ATL | OAK | 2005 | 2013 | SFG |
11861 | 11861 | Dan Uggla | 31 | ugglada01 | 2011 | ATL | NL | 6.701513067 | 1.965 | 2B | 17 | 1 | ATL | FLA | 2011 | 2014 | SFG |
11899 | 11899 | Cory Gearrin | 25 | gearrco01 | 2011 | ATL | NL | 0.573931587 | -0.325 | P | 0 | 1 | ATL | 2011 | 2013 | SFG | |
13248 | 13248 | Tim Hudson | 34 | hudsoti01 | 2010 | ATL | NL | 6.481191744 | 3.985 | P | 22 | 1 | ATL | OAK | 2005 | 2013 | SFG |
14616 | 14616 | Tim Hudson | 33 | hudsoti01 | 2009 | ATL | NL | 1.159093431 | 1.09 | P | 5 | 1 | ATL | OAK | 2005 | 2013 | SFG |
15988 | 15988 | Tim Hudson | 32 | hudsoti01 | 2008 | ATL | NL | 3.968111701 | 2.405 | P | 12 | 1 | ATL | OAK | 2005 | 2013 | SFG |
17373 | 17373 | Tim Hudson | 31 | hudsoti01 | 2007 | ATL | NL | 6.305288183 | 5.435 | P | 24 | 1 | ATL | OAK | 2005 | 2013 | SFG |
18760 | 18760 | Tim Hudson | 30 | hudsoti01 | 2006 | ATL | NL | 6.176359356 | 1.58 | P | 13 | 1 | ATL | OAK | 2005 | 2013 | SFG |
20134 | 20134 | Tim Hudson | 29 | hudsoti01 | 2005 | ATL | NL | 5.342245137 | 2.515 | P | 15 | 1 | ATL | OAK | 2005 | 2013 | SFG |
24195 | 24195 | Damian Moss | 25 | mossda01 | 2002 | ATL | NL | 4.564321861 | 1.499254658 | P | 12 | 1 | ATL | 2001 | 2002 | SFG | |
25543 | 25543 | Damian Moss | 24 | mossda01 | 2001 | ATL | NL | 0.187760557 | 0.07 | P | 0 | 1 | ATL | 2001 | 2002 | SFG | |
30842 | 30842 | Chris Brock | 27 | brockch01 | 1997 | ATL | NL | 0.788218807 | -0.235 | P | 0 | 1 | ATL | 1997 | 1997 | SFG | |
32022 | 32022 | Dean Hartgraves | 29 | hartgde01 | 1996 | ATL | NL | 0.553675495 | -0.045 | P | 1 | 2 | ATL | HOU | 1996 | 1996 | SFG |
45161 | 45161 | Alex Trevino | 26 | trevial01 | 1984 | ATL | NL | 2.946905767 | 1.33 | C | 8 | 2 | ATL | CIN | 1984 | 1984 | SFG |
49079 | 49079 | Doyle Alexander | 29 | alexado01 | 1980 | ATL | NL | 6.41554381 | 1.740745342 | P | 16 | 1 | ATL | TEX | 1980 | 1980 | SFG |
52953 | 52953 | Darrell Evans | 29 | evansda01 | 1976 | ATL | NL | 1.732720523 | -0.055 | 1B, 3B | 2 | 1 | ATL | 1969 | 1976 | SFG | |
52970 | 52970 | Marty Perez | 30 | perezma01 | 1976 | ATL | NL | 1.117553474 | -0.4 | 2B, SS, 3B | 0 | 1 | ATL | ANA | 1971 | 1976 | SFG |
53818 | 53818 | Darrell Evans | 28 | evansda01 | 1975 | ATL | NL | 6.968595625 | 3.114223602 | 3B, 1B | 20 | 1 | ATL | 1969 | 1976 | SFG | |
53823 | 53823 | Marty Perez | 29 | perezma01 | 1975 | ATL | NL | 5.208539167 | 0.311925466 | 2B, SS | 9 | 1 | ATL | ANA | 1971 | 1976 | SFG |
53853 | 53853 | Craig Robinson | 26 | robincr01 | 1975 | ATL | NL | 0.173959068 | -0.447763975 | SS, 2B | 0 | 1 | ATL | PHI | 1974 | 1975 | SFG |
54724 | 54724 | Darrell Evans | 27 | evansda01 | 1974 | ATL | NL | 7.088999828 | 6.96202454 | 3B | 30 | 1 | ATL | 1969 | 1976 | SFG | |
54731 | 54731 | Marty Perez | 28 | perezma01 | 1974 | ATL | NL | 4.902392839 | 2.181533742 | 2B, SS, 3B | 13 | 1 | ATL | ANA | 1971 | 1976 | SFG |
54737 | 54737 | Craig Robinson | 25 | robincr01 | 1974 | ATL | NL | 5.052160441 | -0.313067485 | SS | 6 | 1 | ATL | PHI | 1974 | 1975 | SFG |
55637 | 55637 | Darrell Evans | 26 | evansda01 | 1973 | ATL | NL | 7.198442262 | 9.365 | 3B, 1B | 36 | 1 | ATL | 1969 | 1976 | SFG | |
55646 | 55646 | Marty Perez | 27 | perezma01 | 1973 | ATL | NL | 5.568235693 | 1.08 | SS | 10 | 1 | ATL | ANA | 1971 | 1976 | SFG |
56532 | 56532 | Darrell Evans | 25 | evansda01 | 1972 | ATL | NL | 5.509206928 | 4.279935484 | 3B | 21 | 1 | ATL | 1969 | 1976 | SFG | |
56557 | 56557 | Marty Perez | 26 | perezma01 | 1972 | ATL | NL | 5.477484047 | -2.330709677 | SS | 1 | 1 | ATL | ANA | 1971 | 1976 | SFG |
57427 | 57427 | Darrell Evans | 24 | evansda01 | 1971 | ATL | NL | 3.106233538 | 1.305 | 3B, LF | 9 | 1 | ATL | 1969 | 1976 | SFG | |
57436 | 57436 | Marty Perez | 25 | perezma01 | 1971 | ATL | NL | 4.532045654 | -1.415 | SS, 2B | 3 | 1 | ATL | ANA | 1971 | 1976 | SFG |
58318 | 58318 | Darrell Evans | 23 | evansda01 | 1970 | ATL | NL | 0.528196147 | 0.345 | 3B | 2 | 1 | ATL | 1969 | 1976 | SFG | |
59256 | 59256 | Darrell Evans | 22 | evansda01 | 1969 | ATL | NL | 0.2888138 | -0.33 | 3B | 0 | 1 | ATL | 1969 | 1976 | SFG |
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 );