mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
486 rows where prev_franch = "TBD"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19 | 19 | Matt Andriese | 29 | andrima01 | 2019 | ARI | NL | 2.076110881 | 0.356603774 | P | 4 | 1 | ARI | TBD | 2018 | 2019 | |
94 | 94 | Jonny Venters | 34 | ventejo01 | 2019 | ATL | NL | 0.126369028 | -0.636792453 | P | 0 | 1 | ATL | TBD | 2018 | 2019 | WSN |
133 | 133 | Jesus Sucre | 31 | sucreje01 | 2019 | BAL | AL | 0.64231405 | -0.101886792 | C, 1B, P | 0 | 1 | BAL | TBD | 2019 | 2019 | |
146 | 146 | Alex Cobb | 31 | cobbal01 | 2019 | BAL | AL | 0.359501494 | -0.514528302 | P | 0 | 1 | BAL | TBD | 2018 | 2019 | |
175 | 175 | Ryan Weber | 28 | weberry01 | 2019 | BOS | AL | 0.982765541 | 0.254716981 | P | 2 | 1 | BOS | TBD | 2019 | 2019 | |
179 | 179 | Nathan Eovaldi | 29 | eovalna01 | 2019 | BOS | AL | 1.8416163 | -0.076415094 | P | 2 | 1 | BOS | TBD | 2018 | 2019 | |
217 | 217 | Steve Cishek | 33 | cishest01 | 2019 | CHC | NL | 2.207414619 | 0.983207547 | P | 6 | 1 | CHC | TBD | 2018 | 2019 | |
314 | 314 | Curt Casali | 30 | casalcu01 | 2019 | CIN | NL | 2.342704626 | 0.957735849 | C, 1B | 6 | 1 | CIN | TBD | 2018 | 2019 | |
370 | 370 | Jake Bauers | 23 | bauerja01 | 2019 | CLE | AL | 4.000666445 | -0.621509434 | LF, 1B | 4 | 1 | CLE | TBD | 2019 | 2019 | |
379 | 379 | Hunter Wood | 25 | woodhu01 | 2019 | CLE | AL | 0.379526959 | 0.091698113 | P | 1 | 2 | CLE | TBD | 2019 | 2019 | |
389 | 389 | Andrew Velazquez | 24 | velazan01 | 2019 | CLE | AL | 0.067644119 | -0.045849057 | 3B, 2B, CF, LF | 0 | 2 | CLE | TBD | 2019 | 2019 | |
423 | 423 | Jake McGee | 32 | mcgeeja01 | 2019 | COL | NL | 1.077894146 | 0.056037736 | P | 2 | 1 | COL | TBD | 2016 | 2019 | |
495 | 495 | Mikie Mahtook | 29 | mahtomi01 | 2019 | DET | AL | 0.245222391 | -0.528037975 | CF, LF | 0 | 1 | DET | TBD | 2017 | 2019 | |
616 | 616 | Cesar Puello | 28 | puellce01 | 2019 | LAA | AL | 0.473160385 | 0.830377358 | CF, LF, RF | 3 | 1 | ANA | TBD | 2019 | 2019 | FLA |
642 | 642 | Kean Wong | 24 | wongke01 | 2019 | LAA | AL | 0.037852831 | -0.142641509 | 2B, RF | 0 | 2 | ANA | TBD | 2019 | 2019 | |
645 | 645 | Anthony Bemboom | 29 | bemboan01 | 2019 | LAA | AL | 0.425844347 | -0.290377358 | C | 0 | 2 | ANA | TBD | 2019 | 2019 | |
683 | 683 | Casey Sadler | 28 | sadleca02 | 2019 | LAD | NL | 0.62551217 | 0.198679245 | P | 2 | 2 | LAD | TBD | 2019 | 2019 | |
688 | 688 | Adam Kolarek | 30 | kolarad01 | 2019 | LAD | NL | 0.372119722 | 0.203773585 | P, 1B | 1 | 2 | LAD | TBD | 2019 | 2019 | |
693 | 693 | Jaime Schultz | 28 | schulja02 | 2019 | LAD | NL | 0.080950414 | -0.081509434 | P | 0 | 1 | LAD | TBD | 2019 | 2019 | |
720 | 720 | Sergio Romo | 36 | romose01 | 2019 | MIA | NL | 1.39984623 | 0.392264151 | P | 3 | 1 | FLA | TBD | 2019 | 2019 | MIN |
739 | 739 | Ryne Stanek | 27 | stanery01 | 2019 | MIA | NL | 0.771115354 | -0.494150943 | P | 0 | 2 | FLA | TBD | 2019 | 2019 | |
794 | 794 | Jake Faria | 25 | fariaja01 | 2019 | MIL | NL | 0.173341785 | -0.198679245 | P | 0 | 2 | MIL | TBD | 2019 | 2019 | |
805 | 805 | Jake Odorizzi | 29 | odorija01 | 2019 | MIN | AL | 4.408097134 | 3.988867925 | P | 18 | 1 | MIN | TBD | 2018 | 2019 | |
818 | 818 | C.J. Cron | 29 | croncj01 | 2019 | MIN | AL | 4.541945774 | 0.860943396 | 1B | 9 | 1 | MIN | TBD | 2019 | 2019 | |
878 | 878 | Wilmer Font | 29 | fontwi01 | 2019 | NYM | NL | 0.810332864 | -0.076415094 | P | 1 | 2 | NYM | TBD | 2019 | 2019 | TOR |
899 | 899 | Carlos Gomez | 33 | gomezca01 | 2019 | NYM | NL | 0.983219178 | -0.305660377 | CF, LF, RF | 0 | 1 | NYM | TBD | 2019 | 2019 | |
1037 | 1037 | Tommy Hunter | 32 | hunteto02 | 2019 | PHI | NL | 0.13528567 | 0.229245283 | P | 1 | 1 | PHI | TBD | 2018 | 2019 | |
1072 | 1072 | Chris Archer | 30 | archech01 | 2019 | PIT | NL | 3.575559197 | 0.799811321 | P | 8 | 1 | PIT | TBD | 2018 | 2019 | |
1079 | 1079 | Corey Dickerson | 30 | dickeco01 | 2019 | PIT | NL | 1.418044077 | 0.54 | LF | 4 | 1 | PIT | TBD | 2018 | 2019 | PHI |
1129 | 1129 | Wil Myers | 28 | myerswi01 | 2019 | SDP | NL | 4.943181818 | 0.081509434 | LF, CF, 1B, RF, 3B | 7 | 1 | SDP | TBD | 2015 | 2019 | |
1184 | 1184 | Mallex Smith | 26 | smithma05 | 2019 | SEA | AL | 5.354434553 | -0.076415094 | CF, RF, LF | 7 | 1 | SEA | TBD | 2019 | 2019 | |
1221 | 1221 | Ryan Garton | 29 | gartory01 | 2019 | SEA | AL | 0.049491515 | -0.091698113 | P | 0 | 1 | SEA | TBD | 2017 | 2019 | |
1241 | 1241 | Evan Longoria | 33 | longoev01 | 2019 | SFG | NL | 4.996706535 | 2.272075472 | 3B | 15 | 1 | SFG | TBD | 2018 | 2019 | |
1428 | 1428 | Ian Gibaut | 25 | gibauia01 | 2019 | TEX | AL | 0.312794937 | 0.178301887 | P | 1 | 2 | TEX | TBD | 2019 | 2019 | |
1453 | 1453 | Drew Smyly | 30 | smylydr01 | 2019 | TEX | AL | 1.430486287 | -0.80490566 | P | 0 | 1 | TEX | TBD | 2019 | 2019 | PHI |
1511 | 1511 | Luke Maile | 28 | mailelu01 | 2019 | TOR | AL | 1.215219578 | -0.565471698 | C, P | 0 | 1 | TOR | TBD | 2017 | 2019 | |
1588 | 1588 | Steven Souza Jr. | 29 | souzast01 | 2018 | ARI | NL | 2.70832618 | -0.335 | RF, CF | 3 | 1 | ARI | TBD | 2018 | 2018 | |
1591 | 1591 | Brad Boxberger | 30 | boxbebr01 | 2018 | ARI | NL | 2.155735716 | -0.485 | P | 2 | 1 | ARI | TBD | 2018 | 2018 | KCR |
1612 | 1612 | Matt Andriese | 28 | andrima01 | 2018 | ARI | NL | 0.415645549 | -0.69 | P | 0 | 2 | ARI | TBD | 2018 | 2019 | |
1644 | 1644 | Jonny Venters | 33 | ventejo01 | 2018 | ATL | NL | 0.736466897 | 0.14 | P | 1 | 2 | ATL | TBD | 2018 | 2019 | WSN |
1647 | 1647 | Peter Bourjos | 31 | bourjpe01 | 2018 | ATL | NL | 0.460239743 | 0.025 | LF, CF, RF | 1 | 1 | ATL | TBD | 2018 | 2018 | ANA |
1662 | 1662 | Chase Whitley | 29 | whitlch01 | 2018 | ATL | NL | 0.025427696 | -0.11 | P | 0 | 1 | ATL | TBD | 2018 | 2018 | |
1674 | 1674 | Alex Cobb | 30 | cobbal01 | 2018 | BAL | AL | 4.402358028 | 1.315 | P | 9 | 1 | BAL | TBD | 2018 | 2019 | |
1686 | 1686 | Tim Beckham | 28 | beckhti01 | 2018 | BAL | AL | 3.878888704 | 0.085 | SS, 3B, 2B | 5 | 1 | BAL | TBD | 2017 | 2018 | SEA |
1721 | 1721 | Colby Rasmus | 31 | rasmuco01 | 2018 | BAL | AL | 0.472799867 | -0.375 | RF, LF, CF | 0 | 1 | BAL | TBD | 2018 | 2018 | |
1744 | 1744 | Nathan Eovaldi | 28 | eovalna01 | 2018 | BOS | AL | 1.497006927 | 1.135 | P | 6 | 2 | BOS | TBD | 2018 | 2019 | |
1786 | 1786 | Steve Cishek | 32 | cishest01 | 2018 | CHC | NL | 2.53493183 | 1.570306748 | P, LF | 9 | 1 | CHC | TBD | 2018 | 2019 | |
1844 | 1844 | Xavier Cedeno | 31 | cedenxa01 | 2018 | CHW | AL | 0.837927233 | 0.51 | P | 3 | 1 | CHW | TBD | 2018 | 2018 | MIL |
1860 | 1860 | Danny Farquhar | 31 | farquda01 | 2018 | CHW | AL | 0.268216899 | -0.08 | P | 0 | 1 | CHW | TBD | 2017 | 2018 | |
1891 | 1891 | Curt Casali | 29 | casalcu01 | 2018 | CIN | NL | 1.53538096 | 0.705 | C, 1B, 2B | 4 | 1 | CIN | TBD | 2018 | 2019 | |
1950 | 1950 | Brandon Guyer | 32 | guyerbr01 | 2018 | CLE | AL | 2.043034747 | -0.035 | RF, LF, CF, P | 2 | 1 | CLE | TBD | 2016 | 2018 | |
2003 | 2003 | Jake McGee | 31 | mcgeeja01 | 2018 | COL | NL | 1.524841451 | -0.506871166 | P | 1 | 1 | COL | TBD | 2016 | 2019 | |
2037 | 2037 | Mikie Mahtook | 28 | mahtomi01 | 2018 | DET | AL | 2.412645591 | 0.02 | LF, RF, CF | 3 | 1 | DET | TBD | 2017 | 2019 | |
2124 | 2124 | Lucas Duda | 32 | dudalu01 | 2018 | KCR | AL | 3.312365502 | 0.105 | 1B | 4 | 1 | KCR | TBD | 2018 | 2018 | ATL |
2253 | 2253 | Logan Forsythe | 31 | forsylo01 | 2018 | LAD | NL | 2.03120332 | -0.631104294 | 2B, 3B, 1B, LF | 1 | 1 | LAD | TBD | 2017 | 2018 | MIN |
2341 | 2341 | Dan Jennings | 31 | jennida01 | 2018 | MIL | NL | 1.946381713 | 0.397546012 | P | 4 | 1 | MIL | TBD | 2018 | 2018 | WSN |
2359 | 2359 | Brad Miller | 28 | millebr02 | 2018 | MIL | NL | 0.784446323 | -0.094417178 | 1B, 2B, SS | 1 | 2 | MIL | TBD | 2018 | 2018 | CLE |
2376 | 2376 | Jake Odorizzi | 28 | odorija01 | 2018 | MIN | AL | 4.579862676 | 1.97 | P | 13 | 1 | MIN | TBD | 2018 | 2019 | |
2399 | 2399 | Logan Morrison | 30 | morrilo01 | 2018 | MIN | AL | 3.395629485 | -0.505 | 1B, LF | 3 | 1 | MIN | TBD | 2018 | 2018 | PHI |
2402 | 2402 | Bobby Wilson | 35 | wilsobo02 | 2018 | MIN | AL | 1.428245271 | 0.055 | C | 2 | 1 | MIN | TBD | 2018 | 2018 | DET |
2405 | 2405 | Johnny Field | 26 | fieldjo04 | 2018 | MIN | AL | 0.510763209 | 0.12 | RF, LF, CF, P | 1 | 2 | MIN | TBD | 2018 | 2018 | |
2431 | 2431 | Asdrubal Cabrera | 32 | cabreas01 | 2018 | NYM | NL | 4.039356605 | 1.81 | 2B, SS, 3B | 11 | 1 | NYM | TBD | 2016 | 2018 | PHI |
2596 | 2596 | Tommy Hunter | 31 | hunteto02 | 2018 | PHI | NL | 2.319850735 | 1.06 | P | 7 | 1 | PHI | TBD | 2018 | 2019 | |
2600 | 2600 | Wilson Ramos | 30 | ramoswi01 | 2018 | PHI | NL | 1.003769705 | 0.75 | C | 4 | 2 | PHI | TBD | 2018 | 2018 | NYM |
2623 | 2623 | Trevor Plouffe | 32 | plouftr01 | 2018 | PHI | NL | 0.119259767 | 0.01 | 3B, 2B, RF | 0 | 1 | PHI | TBD | 2018 | 2018 | |
2633 | 2633 | Corey Dickerson | 29 | dickeco01 | 2018 | PIT | NL | 5.375412972 | 3.250062112 | LF | 18 | 1 | PIT | TBD | 2018 | 2019 | PHI |
2650 | 2650 | Chris Archer | 29 | archech01 | 2018 | PIT | NL | 1.492611857 | 0.623850932 | P | 4 | 2 | PIT | TBD | 2018 | 2019 | |
2668 | 2668 | Adeiny Hechavarria | 29 | hechaad01 | 2018 | PIT | NL | 0.474004521 | -0.105652174 | SS, 3B | 0 | 2 | PIT | TBD | 2018 | 2018 | NYY |
2682 | 2682 | Wil Myers | 27 | myerswi01 | 2018 | SDP | NL | 3.45022546 | 1.99 | 3B, LF, RF, 1B, CF | 11 | 1 | SDP | TBD | 2015 | 2019 | |
2740 | 2740 | Denard Span | 34 | spande01 | 2018 | SEA | AL | 3.136685903 | 0.96 | LF, CF | 8 | 2 | SEA | TBD | 2018 | 2018 | |
2744 | 2744 | Alex Colome | 29 | colomal01 | 2018 | SEA | AL | 1.795782665 | 0.865 | P | 5 | 2 | SEA | TBD | 2018 | 2018 | CHW |
2769 | 2769 | Taylor Motter | 28 | motteta01 | 2018 | SEA | AL | 0.162572135 | 0.06 | 1B, RF, 2B, 3B, LF, P, SS | 0 | 1 | SEA | TBD | 2017 | 2018 | MIN |
2780 | 2780 | Erasmo Ramirez | 28 | ramirer02 | 2018 | SEA | AL | 1.274902239 | -0.6 | P | 0 | 1 | SEA | TBD | 2017 | 2018 | BOS |
2786 | 2786 | Evan Longoria | 32 | longoev01 | 2018 | SFG | NL | 5.120882911 | 1.225 | 3B | 12 | 1 | SFG | TBD | 2018 | 2019 | |
2941 | 2941 | Robinson Chirinos | 34 | chiriro01 | 2018 | TEX | AL | 4.021484375 | 0.875 | C | 8 | 1 | TEX | TBD | 2013 | 2018 | HOU |
2976 | 2976 | Kevin Jepsen | 33 | jepseke01 | 2018 | TEX | AL | 0.610983087 | -0.45 | P | 0 | 1 | TEX | TBD | 2018 | 2018 | |
2989 | 2989 | Luke Maile | 27 | mailelu01 | 2018 | TOR | AL | 2.213813615 | 1.54 | C | 8 | 1 | TOR | TBD | 2017 | 2019 | |
3086 | 3086 | Enny Romero | 27 | romeren01 | 2018 | WSN | NL | 0.03259933 | -0.095 | P | 0 | 1 | WSN | TBD | 2017 | 2018 | PIT |
3200 | 3200 | Tim Beckham | 27 | beckhti01 | 2017 | BAL | AL | 2.179026462 | 1.975 | SS, 2B, 3B | 9 | 2 | BAL | TBD | 2017 | 2018 | SEA |
3334 | 3334 | Dylan Floro | 26 | florody01 | 2017 | CHC | NL | 0.157315034 | -0.115 | P | 0 | 1 | CHC | TBD | 2017 | 2017 | CIN |
3371 | 3371 | Danny Farquhar | 30 | farquda01 | 2017 | CHW | AL | 0.554307227 | 0.165 | P | 1 | 2 | CHW | TBD | 2017 | 2018 | |
3466 | 3466 | Brandon Guyer | 31 | guyerbr01 | 2017 | CLE | AL | 1.792370835 | -0.205 | RF, LF | 2 | 1 | CLE | TBD | 2016 | 2018 | |
3491 | 3491 | Jake McGee | 30 | mcgeeja01 | 2017 | COL | NL | 2.072023314 | 1.43 | P | 7 | 1 | COL | TBD | 2016 | 2019 | |
3527 | 3527 | Mikie Mahtook | 27 | mahtomi01 | 2017 | DET | AL | 3.587140992 | 1.155 | CF, RF, LF | 8 | 1 | DET | TBD | 2017 | 2019 | |
3728 | 3728 | Logan Forsythe | 30 | forsylo01 | 2017 | LAD | NL | 4.342087312 | 1.845 | 2B, 3B, LF, SS, 1B | 12 | 1 | LAD | TBD | 2017 | 2018 | MIN |
3842 | 3842 | Nick Franklin | 26 | frankni01 | 2017 | MIL | NL | 0.887094002 | -0.13 | LF, 2B, RF, SS | 1 | 1 | MIL | TBD | 2017 | 2017 | ANA |
3853 | 3853 | Jhan Marinez | 28 | marinjh01 | 2017 | MIL | NL | 0.435467411 | -0.185 | P | 0 | 1 | MIL | TBD | 2016 | 2017 | PIT |
3918 | 3918 | Asdrubal Cabrera | 31 | cabreas01 | 2017 | NYM | NL | 5.358426005 | 1.345 | SS, 3B, 2B | 11 | 1 | NYM | TBD | 2016 | 2018 | PHI |
3939 | 3939 | Rene Rivera | 33 | riverre01 | 2017 | NYM | NL | 1.85560308 | 0.22 | C, 1B | 3 | 1 | NYM | TBD | 2016 | 2017 | CHC |
4052 | 4052 | Stephen Vogt | 32 | vogtst01 | 2017 | OAK | AL | 1.653612977 | -0.325 | C, LF | 1 | 1 | OAK | TBD | 2013 | 2017 | MIL |
4066 | 4066 | Jaff Decker | 27 | deckeja01 | 2017 | OAK | AL | 0.589218417 | -0.31 | CF, RF, LF | 0 | 1 | OAK | TBD | 2017 | 2017 | |
4140 | 4140 | John Jaso | 33 | jasojo01 | 2017 | PIT | NL | 3.013246172 | -0.015 | RF, 1B, LF | 4 | 1 | PIT | TBD | 2016 | 2017 | |
4171 | 4171 | Wil Myers | 26 | myerswi01 | 2017 | SDP | NL | 6.665840269 | 1.45 | 1B, 2B | 15 | 1 | SDP | TBD | 2015 | 2019 | |
4238 | 4238 | Erasmo Ramirez | 27 | ramirer02 | 2017 | SEA | AL | 1.715545962 | 0.695 | P | 4 | 2 | SEA | TBD | 2017 | 2018 | BOS |
4250 | 4250 | Taylor Motter | 27 | motteta01 | 2017 | SEA | AL | 2.645381984 | -0.575 | SS, 2B, 1B, LF, 3B, RF | 2 | 1 | SEA | TBD | 2017 | 2018 | MIN |
4251 | 4251 | Ryan Garton | 27 | gartory01 | 2017 | SEA | AL | 0.288291822 | 0.24 | P | 1 | 2 | SEA | TBD | 2017 | 2019 | |
4293 | 4293 | Matt Moore | 28 | moorema02 | 2017 | SFG | NL | 4.807269621 | 0.38 | P | 7 | 1 | SFG | TBD | 2016 | 2017 | TEX |
4441 | 4441 | Robinson Chirinos | 33 | chiriro01 | 2017 | TEX | AL | 2.9409255 | 2.31 | C | 11 | 1 | TEX | TBD | 2013 | 2018 | HOU |
4459 | 4459 | Ernesto Frieri | 31 | frierer01 | 2017 | TEX | AL | 0.212502966 | 0.065 | P | 1 | 1 | TEX | TBD | 2017 | 2017 | |
4517 | 4517 | Luke Maile | 26 | mailelu01 | 2017 | TOR | AL | 1.286786297 | -0.365 | C | 1 | 1 | TOR | TBD | 2017 | 2019 |
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 );