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 def_pos
This data as json, copyable, CSV (advanced)
Suggested facets: lg_ID, stint_ID, franch_id, prev_franch
next_franch 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42 | 42 | Yasmany Tomas | 28 | tomasya01 | 2019 | ARI | NL | 0.059153493 | -0.198679245 | 0 | 1 | ARI | 2015 | 2019 | |||
137 | 137 | Mark Trumbo | 33 | trumbma01 | 2019 | BAL | AL | 0.258842975 | -0.193584906 | 0 | 1 | BAL | SEA | 2016 | 2019 | ||
393 | 393 | Hanley Ramirez | 35 | ramirha01 | 2019 | CLE | AL | 0.550816395 | -0.203773585 | 0 | 1 | CLE | BOS | 2019 | 2019 | ||
602 | 602 | Shohei Ohtani | 24 | ohtansh01 | 2019 | LAA | AL | 4.021863273 | 2.16 | 12 | 1 | ANA | 2018 | 2019 | |||
804 | 804 | Nelson Cruz | 38 | cruzne02 | 2019 | MIN | AL | 4.745454545 | 4.156981132 | 19 | 1 | MIN | SEA | 2019 | 2019 | ||
838 | 838 | Jorge Alcala | 23 | alcaljo01 | 2019 | MIN | AL | 0.049418683 | 0.050943396 | 0 | 1 | MIN | 2019 | 2019 | |||
892 | 892 | Jed Lowrie | 35 | lowrije01 | 2019 | NYM | NL | 0.069520548 | -0.117169811 | 0 | 1 | NYM | OAK | 2019 | 2019 | ||
1046 | 1046 | Rob Brantly | 29 | brantro01 | 2019 | PHI | NL | 0.009974205 | -0.015283019 | 0 | 1 | PHI | CHW | 2019 | 2019 | ||
1047 | 1047 | Dylan Cozens | 25 | cozendy01 | 2019 | PHI | NL | 0.009974205 | -0.015283019 | 0 | 1 | PHI | 2018 | 2019 | |||
1048 | 1048 | Mitch Walding | 26 | waldimi01 | 2019 | PHI | NL | 0.019948409 | -0.025471698 | 0 | 1 | PHI | 2018 | 2019 | |||
1051 | 1051 | Deivy Grullon | 23 | grullde01 | 2019 | PHI | NL | 0.039896819 | -0.122264151 | 0 | 1 | PHI | 2019 | 2019 | |||
1334 | 1334 | Joe Hudson | 28 | hudsojo03 | 2019 | STL | NL | 0.010113339 | -0.015283019 | 0 | 1 | STL | ANA | 2019 | 2019 | ||
1546 | 1546 | Tres Barrera | 24 | barretr01 | 2019 | WSN | NL | 0.009987946 | -0.015283019 | 0 | 1 | WSN | 2019 | 2019 | |||
1654 | 1654 | Dustin Peterson | 23 | peterdu01 | 2018 | ATL | NL | 0.01958467 | -0.025 | 0 | 1 | ATL | 2018 | 2018 | DET | ||
1762 | 1762 | Tony Renda | 27 | rendato01 | 2018 | BOS | AL | 0.0 | 0.005 | 0 | 1 | BOS | CIN | 2018 | 2018 | ||
2660 | 2660 | Ryan Lavarnway | 30 | lavarry01 | 2018 | PIT | NL | 0.060511215 | 0.19621118 | 1 | 1 | PIT | OAK | 2018 | 2018 | CIN | |
3181 | 3181 | Tony Sanchez | 29 | sanchto01 | 2017 | ATL | NL | 0.009840516 | -0.015 | 0 | 1 | ATL | PIT | 2017 | 2017 | ||
3540 | 3540 | Victor Martinez | 38 | martivi01 | 2017 | DET | AL | 4.117167102 | -0.8 | 3 | 1 | DET | BOS | 2011 | 2018 | ||
4158 | 4158 | John Bormann | 24 | bormajo01 | 2017 | PIT | NL | 0.009977636 | -0.015 | 0 | 1 | PIT | 2017 | 2017 | |||
4367 | 4367 | Alberto Rosario | 30 | rosaral01 | 2017 | STL | NL | 0.029546612 | -0.09 | 0 | 1 | STL | 2016 | 2017 | |||
4687 | 4687 | Matt Tuiasosopo | 30 | tuiasma01 | 2016 | ATL | NL | 0.029601905 | -0.090559006 | 0 | 1 | ATL | DET | 2016 | 2016 | ||
4729 | 4729 | Trey Mancini | 24 | mancitr01 | 2016 | BAL | AL | 0.14354067 | 0.355 | 1 | 1 | BAL | 2016 | 2019 | |||
4863 | 4863 | Justin Morneau | 35 | morneju01 | 2016 | CHW | AL | 2.069733181 | 0.165 | 3 | 1 | CHW | COL | 2016 | 2016 | ||
4874 | 4874 | Matt Davidson | 25 | davidma02 | 2016 | CHW | AL | 0.018988378 | 0.005 | 0 | 1 | CHW | ARI | 2016 | 2018 | ||
5368 | 5368 | Josmil Pinto | 27 | pintojo01 | 2016 | MIL | NL | 0.060500695 | -0.1 | 0 | 1 | MIL | MIN | 2016 | 2016 | ||
5565 | 5565 | Andrew Lambo | 27 | lamboan01 | 2016 | OAK | AL | 0.00966989 | -0.015 | 0 | 1 | OAK | PIT | 2016 | 2016 | ||
5572 | 5572 | Renato Nunez | 22 | nunezre01 | 2016 | OAK | AL | 0.145048349 | -0.285 | 0 | 1 | OAK | 2016 | 2017 | TEX | ||
5670 | 5670 | Max Moroff | 23 | morofma01 | 2016 | PIT | NL | 0.01952862 | -0.025 | 0 | 1 | PIT | 2016 | 2018 | CLE | ||
5875 | 5875 | Michael McKenry | 31 | mckenmi01 | 2016 | STL | NL | 0.019671019 | -0.025 | 0 | 1 | STL | COL | 2016 | 2016 | ||
6070 | 6070 | Spencer Kieboom | 25 | kiebosp01 | 2016 | WSN | NL | 0.009946836 | 0.065 | 0 | 1 | WSN | 2016 | 2018 | |||
6406 | 6406 | Kyle Waldrop | 23 | waldrky02 | 2015 | CIN | NL | 0.0098993 | -0.015 | 0 | 1 | CIN | 2015 | 2016 | |||
7001 | 7001 | Gary Sanchez | 22 | sanchga02 | 2015 | NYY | AL | 0.018583787 | -0.025 | 0 | 1 | NYY | 2015 | 2019 | |||
7152 | 7152 | Elias Diaz | 24 | diazel01 | 2015 | PIT | NL | 0.019512195 | -0.025 | 0 | 1 | PIT | 2015 | 2019 | |||
7159 | 7159 | Steve Lombardozzi | 26 | lombast02 | 2015 | PIT | NL | 0.107317073 | -0.285 | 0 | 1 | PIT | BAL | 2015 | 2015 | FLA | |
7347 | 7347 | Dean Anna | 28 | annade01 | 2015 | STL | NL | 0.010024196 | -0.015 | 0 | 1 | STL | NYY | 2015 | 2015 | ||
7686 | 7686 | Cord Phelps | 27 | phelpco01 | 2014 | BAL | AL | 0.02848723 | -0.1 | 0 | 1 | BAL | CLE | 2014 | 2014 | ||
7928 | 7928 | Jason Giambi | 43 | giambja01 | 2014 | CLE | AL | 0.654733108 | -0.53 | 0 | 1 | CLE | COL | 2013 | 2014 | ||
8500 | 8500 | Bryan Anderson | 27 | anderbr05 | 2014 | OAK | AL | 0.009327758 | -0.025 | 0 | 1 | OAK | CHW | 2014 | 2015 | ||
8592 | 8592 | Matt Hague | 28 | haguema01 | 2014 | PIT | NL | 0.019741321 | -0.085 | 0 | 1 | PIT | 2012 | 2014 | TOR | ||
8774 | 8774 | Audry Perez | 25 | perezau01 | 2014 | STL | NL | 0.010111576 | 0.015 | 0 | 1 | STL | 2013 | 2014 | |||
8826 | 8826 | Vince Belnome | 26 | belnovi01 | 2014 | TBR | AL | 0.131391586 | -0.115 | 0 | 1 | TBD | 2014 | 2014 | |||
8829 | 8829 | Jerry Sands | 26 | sandsje01 | 2014 | TBR | AL | 0.206472492 | -0.14 | 0 | 1 | TBD | LAD | 2014 | 2014 | CLE | |
9073 | 9073 | Christian Bethancourt | 21 | bethach01 | 2013 | ATL | NL | 0.010050251 | -0.015 | 0 | 1 | ATL | 2013 | 2015 | SDP | ||
9352 | 9352 | Jason Giambi | 42 | giambja01 | 2013 | CLE | AL | 2.0390625 | -0.675 | 1 | 1 | CLE | COL | 2013 | 2014 | ||
9683 | 9683 | Jordan Brown | 29 | brownjo05 | 2013 | MIA | NL | 0.17283085 | -0.115 | 0 | 1 | FLA | CLE | 2013 | 2013 | ||
9855 | 9855 | Travis Hafner | 36 | hafnetr01 | 2013 | NYY | AL | 2.878818061 | -0.14 | 4 | 1 | NYY | CLE | 2013 | 2013 | ||
10252 | 10252 | Freddy Guzman | 32 | guzmafr01 | 2013 | TBR | AL | 0.0 | 0.0 | 0 | 1 | TBD | NYY | 2013 | 2013 | ||
10747 | 10747 | Travis Hafner | 35 | hafnetr01 | 2012 | CLE | AL | 2.470683511 | 0.645 | 5 | 1 | CLE | TEX | 2003 | 2012 | NYY | |
10867 | 10867 | Brad Eldred | 31 | eldrebr01 | 2012 | DET | AL | 0.161665847 | -0.075 | 0 | 1 | DET | COL | 2012 | 2012 | ||
10965 | 10965 | Clint Robinson | 27 | robincl01 | 2012 | KCR | AL | 0.037865187 | -0.1 | 0 | 1 | KCR | 2012 | 2012 | LAD | ||
11101 | 11101 | Adam Greenberg | 31 | greenad01 | 2012 | MIA | NL | 0.010146956 | -0.015 | 0 | 1 | FLA | CHC | 2012 | 2012 | ||
11239 | 11239 | Josh Satin | 27 | satinjo01 | 2012 | NYM | NL | 0.010083449 | -0.015 | 0 | 1 | NYM | 2011 | 2014 | |||
11536 | 11536 | Luis Jimenez | 30 | jimenlu01 | 2012 | SEA | AL | 0.173048235 | -0.32 | 0 | 1 | SEA | 2012 | 2012 | |||
11890 | 11890 | Antoan Richardson | 27 | richaan01 | 2011 | ATL | NL | 0.039889959 | 0.09 | 0 | 1 | ATL | 2011 | 2011 | NYY | ||
11914 | 11914 | Vladimir Guerrero | 36 | guerrvl01 | 2011 | BAL | AL | 5.579651068 | -0.19 | 8 | 1 | BAL | TEX | 2011 | 2011 | ||
12136 | 12136 | Travis Hafner | 34 | hafnetr01 | 2011 | CLE | AL | 3.487581699 | 1.44 | 10 | 1 | CLE | TEX | 2003 | 2012 | NYY | |
12437 | 12437 | Chris Pettit | 26 | pettich01 | 2011 | LAA | AL | 0.0 | 0.0 | 0 | 1 | ANA | 2009 | 2011 | |||
12533 | 12533 | Eric Farris | 25 | farrier01 | 2011 | MIL | NL | 0.010079944 | -0.015 | 0 | 1 | MIL | 2011 | 2012 | |||
12540 | 12540 | Jeremy Reed | 30 | reedje03 | 2011 | MIL | NL | 0.070559611 | -0.195 | 0 | 1 | MIL | TOR | 2011 | 2011 | ||
12895 | 12895 | Jack Cust | 32 | custja01 | 2011 | SEA | AL | 2.63370333 | 0.03 | 4 | 1 | SEA | OAK | 2011 | 2011 | ||
12960 | 12960 | Ryan Rohlinger | 27 | rohliry01 | 2011 | SFG | NL | 0.010116867 | -0.015 | 0 | 1 | SFG | 2008 | 2011 | |||
13043 | 13043 | Russ Canzler | 25 | canzlru01 | 2011 | TBR | AL | 0.04732376 | 0.0 | 0 | 1 | TBD | 2011 | 2011 | CLE | ||
13049 | 13049 | Manny Ramirez | 39 | ramirma02 | 2011 | TBR | AL | 0.160900783 | -0.305 | 0 | 1 | TBD | CHW | 2011 | 2011 | ||
13189 | 13189 | Corey Brown | 25 | brownco01 | 2011 | WSN | NL | 0.030308309 | -0.090559006 | 0 | 1 | WSN | 2011 | 2013 | BOS | ||
13516 | 13516 | Travis Hafner | 33 | hafnetr01 | 2010 | CLE | AL | 4.360618389 | 2.13 | 12 | 1 | CLE | TEX | 2003 | 2012 | NYY | |
13938 | 13938 | Jim Thome | 39 | thomeji01 | 2010 | MIN | AL | 3.162790698 | 3.325 | 14 | 1 | MIN | LAD | 2010 | 2011 | CLE | |
14290 | 14290 | Ken Griffey Jr. | 40 | griffke02 | 2010 | SEA | AL | 1.049773756 | -0.83 | 0 | 1 | SEA | CHW | 2009 | 2010 | ||
14797 | 14797 | Jim Thome | 38 | thomeji01 | 2009 | CHW | AL | 3.959076772 | 1.17 | 9 | 1 | CHW | PHI | 2006 | 2009 | LAD | |
14874 | 14874 | Wilkin Castillo | 25 | castiwi01 | 2009 | CIN | NL | 0.029958678 | 0.075 | 0 | 1 | CIN | 2008 | 2009 | FLA | ||
14886 | 14886 | Travis Hafner | 32 | hafnetr01 | 2009 | CLE | AL | 3.526591522 | 1.355 | 8 | 1 | CLE | TEX | 2003 | 2012 | NYY | |
15237 | 15237 | Jim Thome | 38 | thomeji01 | 2009 | LAD | NL | 0.163841808 | -0.1 | 0 | 2 | LAD | CHW | 2009 | 2009 | MIN | |
15320 | 15320 | Jason Pridie | 25 | pridija01 | 2009 | MIN | AL | 0.0 | 0.0 | 0 | 1 | MIN | 2008 | 2009 | NYM | ||
15370 | 15370 | Robinson Cancel | 33 | cancero01 | 2009 | NYM | NL | 0.009948542 | -0.015 | 0 | 1 | NYM | MIL | 2008 | 2009 | HOU | |
15374 | 15374 | Marlon Anderson | 35 | anderma02 | 2009 | NYM | NL | 0.039794168 | -0.105 | 0 | 1 | NYM | LAD | 2007 | 2009 | ||
15392 | 15392 | Hideki Matsui | 35 | matsuhi01 | 2009 | NYY | AL | 4.769350568 | 2.55 | 14 | 1 | NYY | 2003 | 2009 | ANA | ||
15467 | 15467 | Eric Munson | 31 | munsoer01 | 2009 | OAK | AL | 0.009309791 | -0.02 | 0 | 1 | OAK | HOU | 2009 | 2009 | ||
15608 | 15608 | Craig Stansberry | 27 | stanscr01 | 2009 | SDP | NL | 0.009897611 | -0.015 | 0 | 1 | SDP | 2007 | 2009 | |||
15614 | 15614 | Cliff Floyd | 36 | floydcl01 | 2009 | SDP | NL | 0.168259386 | -0.205 | 0 | 1 | SDP | TBD | 2009 | 2009 | ||
16016 | 16016 | Brayan Pena | 26 | penabr01 | 2008 | ATL | NL | 0.144302538 | 0.035 | 0 | 1 | ATL | 2005 | 2008 | KCR | ||
16088 | 16088 | David Ortiz | 32 | ortizda01 | 2008 | BOS | AL | 4.466436637 | 1.755 | 11 | 1 | BOS | MIN | 2003 | 2016 | ||
16173 | 16173 | Jim Thome | 37 | thomeji01 | 2008 | CHW | AL | 5.62435567 | 1.878404908 | 13 | 1 | CHW | PHI | 2006 | 2009 | LAD | |
16301 | 16301 | Travis Hafner | 31 | hafnetr01 | 2008 | CLE | AL | 2.161834979 | -0.975 | 0 | 1 | CLE | TEX | 2003 | 2012 | NYY | |
16431 | 16431 | Jason Wood | 38 | woodja02 | 2008 | FLA | NL | 0.029677639 | -0.010062112 | 0 | 1 | FLA | DET | 2006 | 2008 | ||
16474 | 16474 | J.R. House | 28 | housejr01 | 2008 | HOU | NL | 0.030446194 | -0.090559006 | 0 | 1 | HOU | BAL | 2008 | 2008 | ||
16649 | 16649 | Vinny Rottino | 28 | rottivi01 | 2008 | MIL | NL | 0.009853891 | -0.015 | 0 | 1 | MIL | 2006 | 2008 | FLA | ||
16651 | 16651 | Angel Salome | 22 | saloman01 | 2008 | MIL | NL | 0.029561672 | -0.09 | 0 | 1 | MIL | 2008 | 2008 | |||
16684 | 16684 | Randy Ruiz | 30 | ruizra01 | 2008 | MIN | AL | 0.625336927 | 0.15404908 | 1 | 1 | MIN | 2008 | 2008 | TOR | ||
16738 | 16738 | Abraham Nunez | 32 | nunezab01 | 2008 | NYM | NL | 0.019281915 | -0.025 | 0 | 1 | NYM | PHI | 2008 | 2008 | ||
16822 | 16822 | Frank Thomas | 40 | thomafr04 | 2008 | OAK | AL | 2.057544548 | 0.166024845 | 3 | 2 | OAK | TOR | 2008 | 2008 | ||
16876 | 16876 | Chris Snelling | 26 | snellch02 | 2008 | PHI | NL | 0.03930205 | 0.185 | 1 | 1 | PHI | OAK | 2008 | 2008 | ||
16883 | 16883 | Andy Tracy | 34 | tracyan01 | 2008 | PHI | NL | 0.03930205 | -0.025 | 0 | 1 | PHI | COL | 2008 | 2009 | ||
17075 | 17075 | Kevin Frandsen | 26 | frandke01 | 2008 | SFG | NL | 0.00998107 | -0.015 | 0 | 1 | SFG | 2006 | 2009 | ANA | ||
17150 | 17150 | Cliff Floyd | 35 | floydcl01 | 2008 | TBR | AL | 2.621677543 | 0.77 | 6 | 1 | TBD | CHC | 2008 | 2008 | SDP | |
17217 | 17217 | Ryan Roberts | 27 | roberry01 | 2008 | TEX | AL | 0.008981109 | -0.02 | 0 | 1 | TEX | TOR | 2008 | 2008 | ARI | |
17269 | 17269 | Hector Luna | 28 | lunahe01 | 2008 | TOR | AL | 0.009397278 | 0.005 | 0 | 1 | TOR | CLE | 2007 | 2008 | FLA | |
17273 | 17273 | Frank Thomas | 40 | thomafr04 | 2008 | TOR | AL | 0.676604018 | -0.21 | 0 | 1 | TOR | OAK | 2007 | 2008 | OAK | |
17636 | 17636 | Jerry Gil | 24 | gilje01 | 2007 | CIN | NL | 0.0 | 0.0 | 0 | 1 | CIN | ARI | 2007 | 2007 | ||
18216 | 18216 | Mike Piazza | 38 | piazzmi01 | 2007 | OAK | AL | 3.007881463 | -0.095 | 3 | 1 | OAK | SDP | 2007 | 2007 | ||
18234 | 18234 | Kevin Melillo | 25 | melilke01 | 2007 | OAK | AL | 0.009142497 | 0.015 | 0 | 1 | OAK | 2007 | 2007 | |||
18377 | 18377 | Drew Macias | 24 | maciadr01 | 2007 | SDP | NL | 0.0 | 0.0 | 0 | 1 | SDP | 2007 | 2009 |
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 );