mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
761 rows where next_franch = "TBD"
This data as json, copyable, CSV (advanced)
Suggested facets: age, year_ID, lg_ID, quasi_ws, stint_ID, franch_id, prev_franch, year_acq, year_left
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
692 | 692 | Travis d'Arnaud | 30 | darnatr01 | 2019 | LAD | NL | 0.00999483 | -0.015283019 | C, 1B | 0 | 2 | LAD | NYM | 2019 | 2019 | TBD |
710 | 710 | Trevor Richards | 26 | richatr01 | 2019 | MIA | NL | 3.256753371 | 1.186981132 | P | 8 | 1 | FLA | 2018 | 2019 | TBD | |
717 | 717 | Nick Anderson | 28 | anderni01 | 2019 | MIA | NL | 1.459868518 | 0.784528302 | P | 4 | 1 | FLA | 2019 | 2019 | TBD | |
778 | 778 | Jesus Aguilar | 29 | aguilje01 | 2019 | MIL | NL | 2.583475009 | -0.341320755 | 1B, 3B | 3 | 1 | MIL | CLE | 2017 | 2019 | TBD |
1290 | 1290 | Erik Kratz | 39 | kratzer01 | 2019 | SFG | NL | 0.361934477 | -0.208867925 | C | 0 | 1 | SFG | MIL | 2019 | 2019 | TBD |
1446 | 1446 | Peter Fairbanks | 25 | fairbpe01 | 2019 | TEX | AL | 0.217088244 | -0.239433962 | P | 0 | 1 | TEX | 2019 | 2019 | TBD | |
1459 | 1459 | Eric Sogard | 33 | sogarer01 | 2019 | TOR | AL | 3.140127389 | 2.083584906 | 2B, 3B, RF, SS, LF | 10 | 1 | TOR | MIL | 2019 | 2019 | TBD |
1770 | 1770 | Jalen Beeks | 24 | beeksja02 | 2018 | BOS | AL | 0.167169706 | -0.245 | P | 0 | 1 | BOS | 2018 | 2018 | TBD | |
1838 | 1838 | Avisail Garcia | 27 | garciav01 | 2018 | CHW | AL | 3.690909091 | 0.205 | RF | 5 | 1 | CHW | DET | 2013 | 2018 | TBD |
1948 | 1948 | Yandy Diaz | 26 | diazya01 | 2018 | CLE | AL | 1.109340134 | 0.22 | 1B, 3B | 2 | 1 | CLE | 2017 | 2018 | TBD | |
2071 | 2071 | Charlie Morton | 34 | mortoch02 | 2018 | HOU | AL | 4.567731465 | 3.175 | P | 16 | 1 | HOU | PHI | 2017 | 2018 | TBD |
2276 | 2276 | Trevor Richards | 25 | richatr01 | 2018 | MIA | NL | 3.599219376 | 0.704347826 | P | 8 | 1 | FLA | 2018 | 2019 | TBD | |
2321 | 2321 | Jesus Aguilar | 28 | aguilje01 | 2018 | MIL | NL | 5.549957735 | 3.135644172 | 1B, 3B | 18 | 1 | MIL | CLE | 2017 | 2019 | TBD |
2358 | 2358 | Ji-Man Choi | 27 | choiji01 | 2018 | MIL | NL | 0.313778529 | 0.029815951 | 1B, LF | 1 | 1 | MIL | NYY | 2018 | 2018 | TBD |
2400 | 2400 | Oliver Drake | 31 | drakeol01 | 2018 | MIN | AL | 0.454553519 | 0.32 | P | 2 | 5 | MIN | TOR | 2018 | 2018 | TBD |
2413 | 2413 | Aaron Slegers | 25 | slegeaa01 | 2018 | MIN | AL | 0.29737239 | -0.045 | P | 0 | 1 | MIN | 2017 | 2018 | TBD | |
2562 | 2562 | Emilio Pagan | 27 | paganem01 | 2018 | OAK | AL | 1.499261989 | 0.05 | P | 2 | 1 | OAK | SEA | 2018 | 2018 | TBD |
2578 | 2578 | Wilmer Font | 28 | fontwi01 | 2018 | OAK | AL | 0.099657688 | -0.295 | P | 0 | 2 | OAK | LAD | 2018 | 2018 | TBD |
2625 | 2625 | Hoby Milner | 27 | milneho01 | 2018 | PHI | NL | 0.12911074 | -0.095 | P | 0 | 1 | PHI | 2017 | 2018 | TBD | |
2652 | 2652 | Tyler Glasnow | 24 | glasnty01 | 2018 | PIT | NL | 1.349497229 | 0.186149068 | P | 3 | 1 | PIT | 2016 | 2018 | TBD | |
2653 | 2653 | Austin Meadows | 23 | meadoau01 | 2018 | PIT | NL | 1.664058425 | 0.070434783 | CF, RF, LF | 3 | 1 | PIT | 2018 | 2018 | TBD | |
2670 | 2670 | Casey Sadler | 27 | sadleca02 | 2018 | PIT | NL | 0.077988576 | -0.125776398 | P | 0 | 1 | PIT | 2014 | 2018 | TBD | |
2738 | 2738 | Mike Zunino | 27 | zuninmi01 | 2018 | SEA | AL | 3.873042045 | 2.02 | C | 12 | 1 | SEA | 2013 | 2018 | TBD | |
2745 | 2745 | Guillermo Heredia | 27 | heredgu01 | 2018 | SEA | AL | 3.222753504 | -0.055 | CF, LF, RF | 5 | 1 | SEA | 2016 | 2018 | TBD | |
2840 | 2840 | Tommy Pham | 30 | phamth01 | 2018 | STL | NL | 3.910778137 | 1.195 | CF, LF | 10 | 1 | STL | 2014 | 2018 | TBD | |
3127 | 3127 | Anthony Banda | 23 | bandaan01 | 2017 | ARI | NL | 0.662771246 | 0.145 | P | 1 | 1 | ARI | 2017 | 2017 | TBD | |
3185 | 3185 | Chaz Roe | 30 | roech01 | 2017 | ATL | NL | 0.051905504 | -0.11 | P | 0 | 1 | ATL | BAL | 2016 | 2017 | TBD |
3238 | 3238 | Vidal Nuno III | 29 | nunovi01 | 2017 | BAL | AL | 0.317720908 | -0.515 | P | 0 | 1 | BAL | SEA | 2017 | 2017 | TBD |
3339 | 3339 | Avisail Garcia | 26 | garciav01 | 2017 | CHW | AL | 5.387978142 | 4.405 | RF | 20 | 1 | CHW | DET | 2013 | 2018 | TBD |
3359 | 3359 | Dan Jennings | 30 | jennida01 | 2017 | CHW | AL | 1.410302297 | 0.285 | P | 3 | 1 | CHW | FLA | 2015 | 2017 | TBD |
3462 | 3462 | Yandy Diaz | 25 | diazya01 | 2017 | CLE | AL | 1.671012393 | 0.37 | 3B, LF | 3 | 1 | CLE | 2017 | 2018 | TBD | |
3468 | 3468 | Michael Martinez | 34 | martimi02 | 2017 | CLE | AL | 0.130693707 | 0.13 | 2B, 3B, CF, LF, P, SS | 1 | 1 | CLE | BOS | 2017 | 2017 | TBD |
3575 | 3575 | Charlie Morton | 33 | mortoch02 | 2017 | HOU | AL | 4.109317839 | 2.615 | P | 14 | 1 | HOU | PHI | 2017 | 2018 | TBD |
3672 | 3672 | C.J. Cron | 27 | croncj01 | 2017 | LAA | AL | 3.574686054 | 0.54 | 1B | 7 | 1 | ANA | 2014 | 2017 | TBD | |
3705 | 3705 | Cesar Puello | 26 | puellce01 | 2017 | LAA | AL | 0.038334435 | 0.0 | LF, RF | 0 | 1 | ANA | 2017 | 2017 | TBD | |
3768 | 3768 | Sergio Romo | 34 | romose01 | 2017 | LAD | NL | 0.729669899 | -0.44 | P | 0 | 1 | LAD | SFG | 2017 | 2017 | TBD |
3798 | 3798 | Adeiny Hechavarria | 28 | hechaad01 | 2017 | MIA | NL | 0.655311973 | 0.13 | SS | 1 | 1 | FLA | TOR | 2013 | 2017 | TBD |
3826 | 3826 | Jesus Aguilar | 27 | aguilje01 | 2017 | MIL | NL | 3.099845334 | 1.12 | 1B, 3B | 8 | 1 | MIL | CLE | 2017 | 2019 | TBD |
3903 | 3903 | Aaron Slegers | 24 | slegeaa01 | 2017 | MIN | AL | 0.390885881 | -0.115 | P | 0 | 1 | MIN | 2017 | 2018 | TBD | |
3925 | 3925 | Lucas Duda | 31 | dudalu01 | 2017 | NYM | NL | 2.887596236 | 1.155 | 1B | 7 | 1 | NYM | 2010 | 2017 | TBD | |
4047 | 4047 | Trevor Plouffe | 31 | plouftr01 | 2017 | OAK | AL | 1.891201049 | -0.215 | 3B, 1B, 2B | 2 | 1 | OAK | MIN | 2017 | 2017 | TBD |
4049 | 4049 | Joey Wendle | 27 | wendljo01 | 2017 | OAK | AL | 0.13304932 | 0.155 | 2B | 1 | 1 | OAK | 2016 | 2017 | TBD | |
4095 | 4095 | Hoby Milner | 26 | milneho01 | 2017 | PHI | NL | 0.868141679 | 0.6 | P | 3 | 1 | PHI | 2017 | 2018 | TBD | |
4117 | 4117 | Ricardo Pinto | 23 | pintori01 | 2017 | PHI | NL | 0.772556262 | -0.635 | P | 0 | 1 | PHI | 2017 | 2017 | TBD | |
4168 | 4168 | Tyler Glasnow | 23 | glasnty01 | 2017 | PIT | NL | 1.820130475 | -0.82 | P | 0 | 1 | PIT | 2016 | 2018 | TBD | |
4224 | 4224 | Mike Zunino | 26 | zuninmi01 | 2017 | SEA | AL | 4.109789868 | 4.005 | C | 17 | 1 | SEA | 2013 | 2018 | TBD | |
4232 | 4232 | Guillermo Heredia | 26 | heredgu01 | 2017 | SEA | AL | 4.024759733 | 0.55 | CF, LF, RF | 7 | 1 | SEA | 2016 | 2018 | TBD | |
4254 | 4254 | Steve Cishek | 31 | cishest01 | 2017 | SEA | AL | 0.733923406 | 0.145 | P | 1 | 1 | SEA | STL | 2016 | 2017 | TBD |
4260 | 4260 | Ryan Weber | 26 | weberry01 | 2017 | SEA | AL | 0.101457019 | 0.11 | P | 0 | 1 | SEA | ATL | 2017 | 2017 | TBD |
4264 | 4264 | Danny Espinosa | 30 | espinda01 | 2017 | SEA | AL | 0.160612478 | -0.045 | 2B, 3B, 1B, SS | 0 | 2 | SEA | ANA | 2017 | 2017 | TBD |
4294 | 4294 | Denard Span | 33 | spande01 | 2017 | SFG | NL | 5.402302801 | -0.02 | CF | 7 | 1 | SFG | WSN | 2016 | 2017 | TBD |
4323 | 4323 | Christian Arroyo | 22 | arroych01 | 2017 | SFG | NL | 1.345592026 | -0.48 | 3B, SS, 2B | 0 | 1 | SFG | 2017 | 2017 | TBD | |
4331 | 4331 | Tommy Pham | 29 | phamth01 | 2017 | STL | NL | 5.219901511 | 6.18 | LF, CF, RF | 25 | 1 | STL | 2014 | 2018 | TBD | |
4442 | 4442 | Carlos Gomez | 31 | gomezca01 | 2017 | TEX | AL | 4.054479816 | 1.735 | CF | 11 | 1 | TEX | HOU | 2016 | 2017 | TBD |
4536 | 4536 | Rob Refsnyder | 26 | refsnro01 | 2017 | TOR | AL | 0.548776509 | -0.35 | 2B, LF, 1B, RF | 0 | 2 | TOR | NYY | 2017 | 2017 | TBD |
4615 | 4615 | Rickie Weeks | 33 | weeksri01 | 2016 | ARI | NL | 2.00641242 | 0.055 | LF, RF | 3 | 1 | ARI | SEA | 2016 | 2016 | TBD |
4655 | 4655 | Mallex Smith | 23 | smithma05 | 2016 | ATL | NL | 2.121469888 | 0.749627329 | CF, LF, RF | 5 | 1 | ATL | 2016 | 2016 | TBD | |
4664 | 4664 | Chaz Roe | 29 | roech01 | 2016 | ATL | NL | 0.637294962 | 0.442732919 | P | 2 | 2 | ATL | BAL | 2016 | 2017 | TBD |
4672 | 4672 | Brandon Snyder | 29 | snydebr03 | 2016 | ATL | NL | 0.463763185 | 0.22136646 | 3B, 1B, LF | 1 | 1 | ATL | BOS | 2016 | 2016 | TBD |
4730 | 4730 | Tommy Hunter | 29 | hunteto02 | 2016 | BAL | AL | 0.351114424 | 0.3 | P | 1 | 2 | BAL | CLE | 2016 | 2016 | TBD |
4857 | 4857 | Avisail Garcia | 25 | garciav01 | 2016 | CHW | AL | 4.300867572 | 0.565 | RF, LF | 7 | 1 | CHW | DET | 2013 | 2018 | TBD |
4858 | 4858 | Dan Jennings | 29 | jennida01 | 2016 | CHW | AL | 1.868098841 | 1.275 | P | 6 | 1 | CHW | FLA | 2015 | 2017 | TBD |
4915 | 4915 | Jumbo Diaz | 32 | diazju03 | 2016 | CIN | NL | 1.06956393 | 0.115 | P | 2 | 1 | CIN | 2014 | 2016 | TBD | |
4986 | 4986 | Adam Moore | 32 | mooread01 | 2016 | CLE | AL | 0.04730832 | -0.105652174 | C | 0 | 1 | CLE | SDP | 2015 | 2016 | TBD |
5093 | 5093 | Colby Rasmus | 29 | rasmuco01 | 2016 | HOU | AL | 3.912959068 | 1.68 | LF, CF, RF | 10 | 1 | HOU | TOR | 2015 | 2016 | TBD |
5176 | 5176 | C.J. Cron | 26 | croncj01 | 2016 | LAA | AL | 4.287375415 | 1.71 | 1B | 11 | 1 | ANA | 2014 | 2017 | TBD | |
5275 | 5275 | Jose De Leon | 23 | deleojo03 | 2016 | LAD | NL | 0.47742357 | -0.52 | P | 0 | 1 | LAD | 2016 | 2016 | TBD | |
5286 | 5286 | Adeiny Hechavarria | 27 | hechaad01 | 2016 | MIA | NL | 5.454014097 | 0.81 | SS | 10 | 1 | FLA | TOR | 2013 | 2017 | TBD |
5426 | 5426 | Kevin Jepsen | 31 | jepseke01 | 2016 | MIN | AL | 1.166025413 | -0.49 | P | 0 | 1 | MIN | TBD | 2015 | 2016 | TBD |
5427 | 5427 | Oswaldo Arcia | 25 | arciaos01 | 2016 | MIN | AL | 1.063535467 | -0.515 | LF, RF | 0 | 1 | MIN | 2013 | 2016 | TBD | |
5455 | 5455 | Lucas Duda | 30 | dudalu01 | 2016 | NYM | NL | 1.722375691 | 0.115 | 1B | 3 | 1 | NYM | 2010 | 2017 | TBD | |
5489 | 5489 | Nathan Eovaldi | 26 | eovalna01 | 2016 | NYY | AL | 3.428746053 | 0.99 | P | 8 | 1 | NYY | FLA | 2015 | 2016 | TBD |
5559 | 5559 | Joey Wendle | 26 | wendljo01 | 2016 | OAK | AL | 1.005668556 | 0.21 | 2B | 2 | 1 | OAK | 2016 | 2017 | TBD | |
5592 | 5592 | Peter Bourjos | 29 | bourjpe01 | 2016 | PHI | NL | 3.912982209 | 0.115 | RF, CF | 6 | 1 | PHI | STL | 2016 | 2016 | TBD |
5617 | 5617 | Taylor Featherston | 26 | feathta01 | 2016 | PHI | NL | 0.286066584 | -0.185 | 2B | 0 | 1 | PHI | ANA | 2016 | 2016 | TBD |
5662 | 5662 | Tyler Glasnow | 22 | glasnty01 | 2016 | PIT | NL | 0.573256813 | 0.085 | P | 1 | 1 | PIT | 2016 | 2018 | TBD | |
5694 | 5694 | Derek Norris | 27 | norride01 | 2016 | SDP | NL | 4.667720963 | 0.495 | C, 1B | 8 | 1 | SDP | OAK | 2015 | 2016 | TBD |
5724 | 5724 | Alexei Ramirez | 34 | ramiral03 | 2016 | SDP | NL | 4.525039536 | -1.92 | SS, RF, 2B | 1 | 1 | SDP | CHW | 2016 | 2016 | TBD |
5750 | 5750 | Mike Zunino | 25 | zuninmi01 | 2016 | SEA | AL | 1.795549823 | 1.685 | C | 8 | 1 | SEA | 2013 | 2018 | TBD | |
5752 | 5752 | Steve Cishek | 30 | cishest01 | 2016 | SEA | AL | 2.651286266 | 1.295 | P | 8 | 1 | SEA | STL | 2016 | 2017 | TBD |
5768 | 5768 | Jesus Sucre | 28 | sucreje01 | 2016 | SEA | AL | 0.271202838 | 0.55 | C | 2 | 1 | SEA | 2013 | 2016 | TBD | |
5770 | 5770 | Guillermo Heredia | 25 | heredgu01 | 2016 | SEA | AL | 1.000644953 | 0.335 | LF, RF, CF | 2 | 1 | SEA | 2016 | 2018 | TBD | |
5803 | 5803 | Denard Span | 32 | spande01 | 2016 | SFG | NL | 6.26309544 | 1.225 | CF | 12 | 1 | SFG | WSN | 2016 | 2017 | TBD |
5806 | 5806 | Matt Duffy | 25 | duffyma01 | 2016 | SFG | NL | 2.812002034 | 1.225 | 3B, SS | 7 | 1 | SFG | 2014 | 2016 | TBD | |
5863 | 5863 | Tommy Pham | 28 | phamth01 | 2016 | STL | NL | 1.799898253 | 0.175 | CF, LF, RF | 3 | 1 | STL | 2014 | 2018 | TBD | |
5950 | 5950 | Carlos Gomez | 30 | gomezca01 | 2016 | TEX | AL | 1.242788858 | 0.845 | CF, LF, RF | 5 | 2 | TEX | HOU | 2016 | 2017 | TBD |
5958 | 5958 | Bobby Wilson | 33 | wilsobo02 | 2016 | TEX | AL | 1.347947915 | -0.085 | C | 2 | 2 | TEX | DET | 2016 | 2016 | TBD |
6036 | 6036 | Wilson Ramos | 28 | ramoswi01 | 2016 | WSN | NL | 5.202195164 | 3.42 | C | 18 | 1 | WSN | MIN | 2010 | 2016 | TBD |
6171 | 6171 | Dana Eveland | 31 | evelada01 | 2015 | ATL | NL | 0.124380575 | -0.1 | P | 0 | 1 | ATL | NYM | 2015 | 2015 | TBD |
6204 | 6204 | Steve Pearce | 32 | pearcst01 | 2015 | BAL | AL | 3.149540518 | -0.11 | LF, 1B, 2B, RF | 4 | 1 | BAL | NYY | 2013 | 2015 | TBD |
6279 | 6279 | Daniel Nava | 32 | navada01 | 2015 | BOS | AL | 0.728267869 | -0.41 | RF, 1B, LF | 0 | 1 | BOS | 2010 | 2015 | TBD | |
6343 | 6343 | Avisail Garcia | 24 | garciav01 | 2015 | CHW | AL | 5.764511328 | -0.33 | RF | 8 | 1 | CHW | DET | 2013 | 2018 | TBD |
6354 | 6354 | Dan Jennings | 28 | jennida01 | 2015 | CHW | AL | 1.567438061 | 0.265 | P | 3 | 1 | CHW | FLA | 2015 | 2017 | TBD |
6390 | 6390 | Jumbo Diaz | 31 | diazju03 | 2015 | CIN | NL | 1.919854021 | 0.225 | P | 3 | 1 | CIN | 2014 | 2016 | TBD | |
6447 | 6447 | Ryan Webb | 29 | webbry01 | 2015 | CLE | AL | 1.135222652 | 0.357204969 | P | 2 | 1 | CLE | BAL | 2015 | 2015 | TBD |
6460 | 6460 | Adam Moore | 31 | mooread01 | 2015 | CLE | AL | 0.038126541 | -0.005031056 | C | 0 | 1 | CLE | SDP | 2015 | 2016 | TBD |
6483 | 6483 | Corey Dickerson | 26 | dickeco01 | 2015 | COL | NL | 2.360347826 | 0.54 | LF, CF | 5 | 1 | COL | 2013 | 2015 | TBD | |
6575 | 6575 | Colby Rasmus | 28 | rasmuco01 | 2015 | HOU | AL | 4.652662918 | 2.845 | LF, CF, RF | 14 | 1 | HOU | TOR | 2015 | 2016 | TBD |
6588 | 6588 | Hank Conger | 27 | congeha01 | 2015 | HOU | AL | 2.196824347 | 0.7 | C, LF | 5 | 1 | HOU | ANA | 2015 | 2015 | TBD |
6675 | 6675 | C.J. Cron | 25 | croncj01 | 2015 | LAA | AL | 3.926273458 | 0.335 | 1B | 7 | 1 | ANA | 2014 | 2017 | TBD |
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 );