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 team_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21415 | 21415 | Vladimir Guerrero | 29 | guerrvl01 | 2004 | ANA | AL | 6.285258964 | 5.73 | RF | 26 | 1 | ANA | WSN | 2004 | 2009 | TEX |
21416 | 21416 | Kelvim Escobar | 28 | escobke01 | 2004 | ANA | AL | 5.82111004 | 4.23 | P | 21 | 1 | ANA | TOR | 2004 | 2009 | |
21417 | 21417 | Chone Figgins | 26 | figgich01 | 2004 | ANA | AL | 5.897051793 | 3.1 | 3B, CF, 2B, SS, RF, LF | 18 | 1 | ANA | 2002 | 2009 | SEA | |
21418 | 21418 | Adam Kennedy | 28 | kennead01 | 2004 | ANA | AL | 4.926533865 | 3.34 | 2B | 17 | 1 | ANA | STL | 2000 | 2006 | STL |
21419 | 21419 | Jose Guillen | 28 | guilljo01 | 2004 | ANA | AL | 5.739920319 | 2.905 | LF, RF | 17 | 1 | ANA | OAK | 2004 | 2004 | WSN |
21420 | 21420 | John Lackey | 25 | lackejo01 | 2004 | ANA | AL | 5.482427274 | 2.565 | P | 16 | 1 | ANA | 2002 | 2009 | BOS | |
21421 | 21421 | Francisco Rodriguez | 22 | rodrifr03 | 2004 | ANA | AL | 3.363717541 | 3.51 | P | 15 | 1 | ANA | 2002 | 2008 | NYM | |
21422 | 21422 | Darin Erstad | 30 | erstada01 | 2004 | ANA | AL | 5.018964143 | 2.47 | 1B | 15 | 1 | ANA | 1996 | 2006 | CHW | |
21423 | 21423 | David Eckstein | 29 | eckstda01 | 2004 | ANA | AL | 5.887808765 | 1.91 | SS | 14 | 1 | ANA | 2001 | 2004 | STL | |
21424 | 21424 | Bartolo Colon | 31 | colonba01 | 2004 | ANA | AL | 5.852238971 | 1.3 | P | 12 | 1 | ANA | CHW | 2004 | 2007 | BOS |
21425 | 21425 | Scot Shields | 28 | shielsc01 | 2004 | ANA | AL | 3.525488368 | 2.005 | P | 11 | 1 | ANA | 2001 | 2010 | ||
21426 | 21426 | Jarrod Washburn | 29 | washbja01 | 2004 | ANA | AL | 4.172571677 | 1.76 | P | 11 | 1 | ANA | 1998 | 2005 | SEA | |
21427 | 21427 | Garret Anderson | 32 | anderga01 | 2004 | ANA | AL | 4.390438247 | 1.39 | CF | 11 | 1 | ANA | 1994 | 2008 | ATL | |
21428 | 21428 | Jeff DaVanon | 30 | davanje02 | 2004 | ANA | AL | 3.114900398 | 1.885 | CF, RF, LF | 10 | 1 | ANA | 1999 | 2005 | ARI | |
21429 | 21429 | Ramon Ortiz | 31 | ortizra02 | 2004 | ANA | AL | 3.308731398 | 1.16 | P | 8 | 1 | ANA | 1999 | 2004 | CIN | |
21430 | 21430 | Troy Glaus | 27 | glaustr01 | 2004 | ANA | AL | 2.236812749 | 1.425 | 3B | 7 | 1 | ANA | 1998 | 2004 | ARI | |
21431 | 21431 | Kevin Gregg | 26 | greggke01 | 2004 | ANA | AL | 2.292334456 | 1.07 | P | 7 | 1 | ANA | 2003 | 2006 | FLA | |
21432 | 21432 | Bengie Molina | 29 | molinbe01 | 2004 | ANA | AL | 3.355219124 | 0.545 | C | 7 | 1 | ANA | 1998 | 2005 | TOR | |
21433 | 21433 | Robb Quinlan | 27 | quinlro01 | 2004 | ANA | AL | 1.636015936 | 1.255 | 3B, 1B, LF, RF | 6 | 1 | ANA | 2003 | 2010 | ||
21434 | 21434 | Jose Molina | 29 | molinjo01 | 2004 | ANA | AL | 2.01498008 | 0.91 | C, 1B | 6 | 1 | ANA | CHC | 2001 | 2007 | NYY |
21435 | 21435 | Aaron Sele | 34 | seleaa01 | 2004 | ANA | AL | 3.589638869 | 0.415 | P | 6 | 1 | ANA | SEA | 2002 | 2004 | SEA |
21436 | 21436 | Troy Percival | 34 | percitr01 | 2004 | ANA | AL | 1.988864737 | 0.605 | P | 5 | 1 | ANA | 1995 | 2004 | DET | |
21437 | 21437 | Brendan Donnelly | 32 | donnebr01 | 2004 | ANA | AL | 1.217464931 | 0.84 | P | 4 | 1 | ANA | 2002 | 2006 | BOS | |
21438 | 21438 | Tim Salmon | 35 | salmoti01 | 2004 | ANA | AL | 1.904063745 | -0.33 | RF, LF | 2 | 1 | ANA | 1992 | 2006 | ||
21439 | 21439 | Derrick Turnbow | 26 | turnbde01 | 2004 | ANA | AL | 0.109773061 | 0.115 | P | 1 | 1 | ANA | 2000 | 2004 | MIL | |
21440 | 21440 | Matt Hensley | 25 | henslma01 | 2004 | ANA | AL | 0.549811625 | 0.1 | P | 1 | 1 | ANA | 2004 | 2004 | ||
21441 | 21441 | Dallas McPherson | 23 | mcpheda01 | 2004 | ANA | AL | 0.397450199 | 0.08 | 3B | 1 | 1 | ANA | 2004 | 2006 | FLA | |
21442 | 21442 | Josh Paul | 29 | pauljo01 | 2004 | ANA | AL | 0.748685259 | 0.025 | C, LF | 1 | 1 | ANA | CHC | 2004 | 2005 | TBD |
21443 | 21443 | Andres Galarraga | 43 | galaran01 | 2004 | ANA | AL | 0.101673307 | 0.055 | 1B | 0 | 1 | ANA | SFG | 2004 | 2004 | |
21444 | 21444 | Scott Dunn | 26 | dunnsc01 | 2004 | ANA | AL | 0.04617043 | -0.025 | P | 0 | 1 | ANA | 2004 | 2004 | TBD | |
21445 | 21445 | Dusty Bergman | 26 | bergmdu01 | 2004 | ANA | AL | 0.032274475 | -0.035 | P | 0 | 1 | ANA | 2004 | 2004 | ||
21446 | 21446 | Adam Riggs | 31 | riggsad01 | 2004 | ANA | AL | 0.341992032 | -0.18 | LF, 1B, 2B | 0 | 1 | ANA | SDP | 2003 | 2004 | |
21447 | 21447 | Curtis Pride | 35 | pridecu01 | 2004 | ANA | AL | 0.388207171 | -0.285 | LF, RF, CF | 0 | 1 | ANA | NYY | 2004 | 2006 | |
21448 | 21448 | Alfredo Amezaga | 26 | amezaal01 | 2004 | ANA | AL | 0.970517928 | -0.335 | SS, 3B, 2B | 0 | 1 | ANA | 2002 | 2004 | COL | |
21449 | 21449 | Raul Mondesi | 33 | mondera01 | 2004 | ANA | AL | 0.341992032 | -0.56 | LF, RF, CF | 0 | 2 | ANA | PIT | 2004 | 2004 | ATL |
21450 | 21450 | Ben Weber | 34 | weberbe01 | 2004 | ANA | AL | 0.647382146 | -0.715 | P | 0 | 1 | ANA | SFG | 2000 | 2004 | CIN |
21451 | 21451 | Casey Kotchman | 21 | kotchca01 | 2004 | ANA | AL | 1.18310757 | -0.74 | 1B | 0 | 1 | ANA | 2004 | 2008 | ATL | |
21452 | 21452 | Shane Halter | 34 | haltesh01 | 2004 | ANA | AL | 1.118406375 | -0.755 | 3B, 2B, 1B, SS | 0 | 1 | ANA | DET | 2004 | 2004 | |
22760 | 22760 | Garret Anderson | 31 | anderga01 | 2003 | ANA | AL | 6.402164999 | 4.525 | LF | 22 | 1 | ANA | 1994 | 2008 | ATL | |
22761 | 22761 | Adam Kennedy | 27 | kennead01 | 2003 | ANA | AL | 4.851566344 | 3.175 | 2B | 16 | 1 | ANA | STL | 2000 | 2006 | STL |
22762 | 22762 | Jeff DaVanon | 29 | davanje02 | 2003 | ANA | AL | 3.63391832 | 3.61 | RF, CF, LF | 15 | 1 | ANA | 1999 | 2005 | ARI | |
22763 | 22763 | Tim Salmon | 34 | salmoti01 | 2003 | ANA | AL | 5.90749549 | 2.53 | RF | 15 | 1 | ANA | 1992 | 2006 | ||
22764 | 22764 | Jarrod Washburn | 28 | washbja01 | 2003 | ANA | AL | 6.09396951 | 2.01 | P | 14 | 1 | ANA | 1998 | 2005 | SEA | |
22765 | 22765 | Brendan Donnelly | 31 | donnebr01 | 2003 | ANA | AL | 2.989195939 | 2.98 | P | 13 | 1 | ANA | 2002 | 2006 | BOS | |
22766 | 22766 | Scot Shields | 27 | shielsc01 | 2003 | ANA | AL | 3.683709581 | 2.755 | P | 13 | 1 | ANA | 2001 | 2010 | ||
22767 | 22767 | Scott Spiezio | 30 | spiezsc01 | 2003 | ANA | AL | 5.526980482 | 1.57 | 1B, 3B, RF, LF | 12 | 1 | ANA | OAK | 2000 | 2003 | SEA |
22768 | 22768 | John Lackey | 24 | lackejo01 | 2003 | ANA | AL | 5.995995724 | 1.535 | P | 12 | 1 | ANA | 2002 | 2009 | BOS | |
22769 | 22769 | Bengie Molina | 28 | molinbe01 | 2003 | ANA | AL | 4.090536329 | 1.885 | C | 11 | 1 | ANA | 1998 | 2005 | TOR | |
22770 | 22770 | David Eckstein | 28 | eckstda01 | 2003 | ANA | AL | 4.91815647 | 1.43 | SS | 11 | 1 | ANA | 2001 | 2004 | STL | |
22771 | 22771 | Chone Figgins | 25 | figgich01 | 2003 | ANA | AL | 2.5684763 | 1.485 | CF, 2B, SS, LF | 8 | 1 | ANA | 2002 | 2009 | SEA | |
22772 | 22772 | Ben Weber | 33 | weberbe01 | 2003 | ANA | AL | 2.411674523 | 1.225 | P | 7 | 1 | ANA | SFG | 2000 | 2004 | CIN |
22773 | 22773 | Francisco Rodriguez | 21 | rodrifr03 | 2003 | ANA | AL | 2.771033989 | 1.215 | P | 7 | 1 | ANA | 2002 | 2008 | NYM | |
22774 | 22774 | Darin Erstad | 29 | erstada01 | 2003 | ANA | AL | 2.701656552 | 1.205 | CF | 7 | 1 | ANA | 1996 | 2006 | CHW | |
22775 | 22775 | Troy Glaus | 26 | glaustr01 | 2003 | ANA | AL | 3.491225193 | 0.9 | 3B | 7 | 1 | ANA | 1998 | 2004 | ARI | |
22776 | 22776 | Ramon Ortiz | 30 | ortizra02 | 2003 | ANA | AL | 5.290584462 | -0.03 | P | 7 | 1 | ANA | 1999 | 2004 | CIN | |
22777 | 22777 | Brad Fullmer | 28 | fullmbr01 | 2003 | ANA | AL | 2.235525668 | 1.15 | 1B | 6 | 1 | ANA | TOR | 2002 | 2003 | TEX |
22778 | 22778 | Troy Percival | 33 | percitr01 | 2003 | ANA | AL | 2.016059518 | 0.405 | P | 4 | 1 | ANA | 1995 | 2004 | DET | |
22779 | 22779 | Aaron Sele | 33 | seleaa01 | 2003 | ANA | AL | 3.595166427 | -0.32 | P | 4 | 1 | ANA | SEA | 2002 | 2004 | SEA |
22780 | 22780 | Scott Schoeneweis | 29 | schoesc01 | 2003 | ANA | AL | 1.027100592 | 0.4 | P | 3 | 1 | ANA | 1999 | 2003 | CHW | |
22781 | 22781 | Kevin Appier | 35 | appieke01 | 2003 | ANA | AL | 2.738236347 | -0.13 | P | 3 | 1 | ANA | NYM | 2002 | 2003 | KCR |
22782 | 22782 | Kevin Gregg | 25 | greggke01 | 2003 | ANA | AL | 0.655219343 | 0.505 | P | 2 | 1 | ANA | 2003 | 2006 | FLA | |
22783 | 22783 | Derrick Turnbow | 25 | turnbde01 | 2003 | ANA | AL | 0.310896496 | 0.43 | P | 2 | 1 | ANA | 2000 | 2004 | MIL | |
22784 | 22784 | Wilson Delgado | 30 | delgawi01 | 2003 | ANA | AL | 0.551746761 | 0.365 | 2B, 3B, SS | 2 | 2 | ANA | STL | 2003 | 2003 | NYM |
22785 | 22785 | Adam Riggs | 30 | riggsad01 | 2003 | ANA | AL | 0.684927013 | 0.25 | 1B, LF, 2B | 2 | 1 | ANA | SDP | 2003 | 2004 | |
22786 | 22786 | Greg Jones | 26 | jonesgr01 | 2003 | ANA | AL | 0.639239662 | 0.11 | P | 1 | 1 | ANA | 2003 | 2007 | ||
22787 | 22787 | Gary Glover | 26 | glovega01 | 2003 | ANA | AL | 0.551691963 | 0.045 | P | 1 | 2 | ANA | CHW | 2003 | 2003 | MIL |
22788 | 22788 | Alfredo Amezaga | 25 | amezaal01 | 2003 | ANA | AL | 1.141545022 | -0.165 | SS, 3B | 1 | 1 | ANA | 2002 | 2004 | COL | |
22789 | 22789 | Robb Quinlan | 26 | quinlro01 | 2003 | ANA | AL | 0.960800394 | -0.22 | 1B, LF | 1 | 1 | ANA | 2003 | 2010 | ||
22790 | 22790 | Eric Owens | 32 | owenser01 | 2003 | ANA | AL | 2.444808922 | -0.73 | CF, RF, LF | 1 | 1 | ANA | FLA | 2003 | 2003 | |
22791 | 22791 | Shawn Wooten | 30 | wootesh01 | 2003 | ANA | AL | 2.853862555 | -0.92 | 1B, C, 3B | 1 | 1 | ANA | 2000 | 2003 | PHI | |
22792 | 22792 | Rich Rodriguez | 40 | rodriri02 | 2003 | ANA | AL | 0.068005334 | 0.095 | P | 0 | 1 | ANA | TEX | 2003 | 2003 | |
22793 | 22793 | Gary Johnson | 27 | johnsga01 | 2003 | ANA | AL | 0.085615877 | 0.05 | LF, RF | 0 | 1 | ANA | 2003 | 2003 | ||
22794 | 22794 | Barry Wesson | 26 | wessoba01 | 2003 | ANA | AL | 0.104641627 | -0.02 | LF, RF | 0 | 1 | ANA | HOU | 2003 | 2003 | |
22795 | 22795 | Bart Miadich | 27 | miadiba01 | 2003 | ANA | AL | 0.043380906 | -0.07 | P | 0 | 1 | ANA | 2001 | 2003 | ||
22796 | 22796 | Julio Ramirez | 25 | ramirju02 | 2003 | ANA | AL | 0.028538626 | -0.07 | CF, RF | 0 | 1 | ANA | CHW | 2002 | 2003 | SFG |
22797 | 22797 | Trent Durrington | 27 | durritr01 | 2003 | ANA | AL | 0.161718878 | -0.11 | 2B, 3B, LF | 0 | 1 | ANA | 1999 | 2003 | MIL | |
22798 | 22798 | Tom Gregorio | 26 | gregoto01 | 2003 | ANA | AL | 0.199770379 | -0.12 | C | 0 | 1 | ANA | 2003 | 2003 | ||
22799 | 22799 | Chris Bootcheck | 24 | bootcch01 | 2003 | ANA | AL | 0.203020547 | -0.37 | P | 0 | 1 | ANA | 2003 | 2008 | PIT | |
22800 | 22800 | Mickey Callaway | 28 | callami01 | 2003 | ANA | AL | 0.915819136 | -0.405 | P | 0 | 1 | ANA | TBD | 2002 | 2003 | TEX |
22801 | 22801 | Jose Molina | 28 | molinjo01 | 2003 | ANA | AL | 1.170083648 | -0.69 | C | 0 | 1 | ANA | CHC | 2001 | 2007 | NYY |
22802 | 22802 | Benji Gil | 30 | gilbe01 | 2003 | ANA | AL | 1.28423815 | -0.865 | 2B, SS, 1B, 3B | 0 | 1 | ANA | TEX | 2000 | 2003 | |
24106 | 24106 | Darin Erstad | 28 | erstada01 | 2002 | ANA | AL | 6.09703504 | 5.01 | CF, 1B | 24 | 1 | ANA | 1996 | 2006 | CHW | |
24107 | 24107 | David Eckstein | 27 | eckstda01 | 2002 | ANA | AL | 6.45568416 | 4.88 | SS | 24 | 1 | ANA | 2001 | 2004 | STL | |
24108 | 24108 | Garret Anderson | 30 | anderga01 | 2002 | ANA | AL | 6.23497701 | 4.375 | LF, CF | 22 | 1 | ANA | 1994 | 2008 | ATL | |
24109 | 24109 | Jarrod Washburn | 27 | washbja01 | 2002 | ANA | AL | 5.494146031 | 4.375 | P | 21 | 1 | ANA | 1998 | 2005 | SEA | |
24110 | 24110 | Troy Glaus | 25 | glaustr01 | 2002 | ANA | AL | 6.170604091 | 4.03 | 3B, SS | 21 | 1 | ANA | 1998 | 2004 | ARI | |
24111 | 24111 | Adam Kennedy | 26 | kennead01 | 2002 | ANA | AL | 4.680830823 | 4.02 | 2B, CF | 19 | 1 | ANA | STL | 2000 | 2006 | STL |
24112 | 24112 | Tim Salmon | 33 | salmoti01 | 2002 | ANA | AL | 5.223402569 | 3.65 | RF | 18 | 1 | ANA | 1992 | 2006 | ||
24113 | 24113 | Scott Spiezio | 29 | spiezsc01 | 2002 | ANA | AL | 5.250990962 | 2.655 | 1B, 3B, LF, RF, 2B | 16 | 1 | ANA | OAK | 2000 | 2003 | SEA |
24114 | 24114 | Ramon Ortiz | 29 | ortizra02 | 2002 | ANA | AL | 5.858739985 | 2.23 | P | 15 | 1 | ANA | 1999 | 2004 | CIN | |
24115 | 24115 | Brad Fullmer | 27 | fullmbr01 | 2002 | ANA | AL | 4.404946884 | 2.67 | 1B | 14 | 1 | ANA | TOR | 2002 | 2003 | TEX |
24116 | 24116 | Kevin Appier | 34 | appieke01 | 2002 | ANA | AL | 5.049970412 | 2.125 | P | 14 | 1 | ANA | NYM | 2002 | 2003 | KCR |
24117 | 24117 | Troy Percival | 32 | percitr01 | 2002 | ANA | AL | 2.431375182 | 1.985 | P | 9 | 1 | ANA | 1995 | 2004 | DET | |
24118 | 24118 | John Lackey | 23 | lackejo01 | 2002 | ANA | AL | 2.904850237 | 1.46 | P | 9 | 1 | ANA | 2002 | 2009 | BOS | |
24119 | 24119 | Ben Weber | 32 | weberbe01 | 2002 | ANA | AL | 2.807296977 | 1.34 | P | 8 | 1 | ANA | SFG | 2000 | 2004 | CIN |
24120 | 24120 | Aaron Sele | 32 | seleaa01 | 2002 | ANA | AL | 4.313182811 | 0.68 | P | 8 | 1 | ANA | SEA | 2002 | 2004 | SEA |
24121 | 24121 | Brendan Donnelly | 30 | donnebr01 | 2002 | ANA | AL | 1.801795794 | 1.53 | P | 7 | 1 | ANA | 2002 | 2006 | BOS | |
24122 | 24122 | Orlando Palmeiro | 33 | palmeor01 | 2002 | ANA | AL | 2.758839385 | 1.11 | RF, LF, CF | 7 | 1 | ANA | 1995 | 2002 | STL | |
24123 | 24123 | Scott Schoeneweis | 28 | schoesc01 | 2002 | ANA | AL | 3.976215404 | 0.045 | P | 6 | 1 | ANA | 1999 | 2003 | CHW | |
24124 | 24124 | Bengie Molina | 27 | molinbe01 | 2002 | ANA | AL | 4.221024259 | -0.26 | C | 5 | 1 | ANA | 1998 | 2005 | TOR |
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 );