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,751 rows where next_franch = "STL"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
630 | 630 | Adalberto Mejia | 26 | mejiaad01 | 2019 | LAA | AL | 0.442168977 | 0.13245283 | P | 1 | 2 | ANA | MIN | 2019 | 2019 | STL |
1565 | 1565 | Paul Goldschmidt | 30 | goldspa01 | 2018 | ARI | NL | 6.870386266 | 5.305 | 1B | 26 | 1 | ARI | 2011 | 2018 | STL | |
1947 | 1947 | Andrew Miller | 33 | millean01 | 2018 | CLE | AL | 1.305605032 | 0.28 | P | 2 | 1 | CLE | NYY | 2016 | 2018 | STL |
2198 | 2198 | Joe Hudson | 27 | hudsojo03 | 2018 | LAA | AL | 0.114360828 | -0.04 | C | 0 | 1 | ANA | 2018 | 2018 | STL | |
2517 | 2517 | Chasen Shreve | 27 | shrevch01 | 2018 | NYY | AL | 1.051227836 | -0.135 | P | 1 | 1 | NYY | ATL | 2015 | 2018 | STL |
2519 | 2519 | Giovanny Gallegos | 26 | gallegi01 | 2018 | NYY | AL | 0.201465289 | 0.02 | P | 0 | 1 | NYY | 2017 | 2018 | STL | |
2694 | 2694 | Tyson Ross | 31 | rossty01 | 2018 | SDP | NL | 3.448170298 | 0.495 | P | 6 | 1 | SDP | TEX | 2018 | 2018 | STL |
2723 | 2723 | Tyler Webb | 27 | webbty01 | 2018 | SDP | NL | 0.160721914 | -0.385 | P | 0 | 1 | SDP | MIL | 2018 | 2018 | STL |
2966 | 2966 | Drew Robinson | 26 | robindr01 | 2018 | TEX | AL | 1.180013021 | -0.31 | CF, LF, 2B, 3B, RF, SS | 1 | 1 | TEX | 2017 | 2018 | STL | |
3058 | 3058 | Matt Adams | 29 | adamsma01 | 2018 | WSN | NL | 2.701530183 | 1.025 | 1B, LF, RF | 6 | 1 | WSN | ATL | 2018 | 2018 | STL |
3061 | 3061 | Matt Wieters | 32 | wietema01 | 2018 | WSN | NL | 2.643013284 | 0.51 | C | 5 | 1 | WSN | BAL | 2017 | 2018 | STL |
3098 | 3098 | Paul Goldschmidt | 29 | goldspa01 | 2017 | ARI | NL | 6.566224038 | 5.615 | 1B | 26 | 1 | ARI | 2011 | 2018 | STL | |
3219 | 3219 | Francisco Pena | 27 | penafr01 | 2017 | BAL | AL | 0.094740281 | 0.315 | C | 1 | 1 | BAL | KCR | 2016 | 2017 | STL |
3444 | 3444 | Andrew Miller | 32 | millean01 | 2017 | CLE | AL | 2.459726618 | 2.695 | P | 11 | 1 | CLE | NYY | 2016 | 2018 | STL |
3489 | 3489 | Greg Holland | 31 | hollagr01 | 2017 | COL | NL | 2.474188177 | 1.28 | P | 8 | 1 | COL | KCR | 2017 | 2017 | STL |
3592 | 3592 | Luke Gregerson | 33 | gregelu01 | 2017 | HOU | AL | 1.727480095 | 0.01 | P | 2 | 1 | HOU | OAK | 2015 | 2017 | STL |
3678 | 3678 | Bud Norris | 32 | norribu01 | 2017 | LAA | AL | 2.307504174 | 0.505 | P | 5 | 1 | ANA | LAD | 2017 | 2017 | STL |
3770 | 3770 | Marcell Ozuna | 26 | ozunama01 | 2017 | MIA | NL | 6.641146712 | 5.535 | LF, CF, RF | 26 | 1 | FLA | 2013 | 2017 | STL | |
3990 | 3990 | Chasen Shreve | 26 | shrevch01 | 2017 | NYY | AL | 1.299738084 | 0.375 | P | 3 | 1 | NYY | ATL | 2015 | 2018 | STL |
3996 | 3996 | Giovanny Gallegos | 25 | gallegi01 | 2017 | NYY | AL | 0.429557401 | 0.1 | P | 1 | 1 | NYY | 2017 | 2018 | STL | |
4107 | 4107 | Juan Nicasio | 30 | nicasju01 | 2017 | PHI | NL | 0.038153419 | 0.035 | P | 0 | 2 | PHI | PIT | 2017 | 2017 | STL |
4455 | 4455 | Drew Robinson | 25 | robindr01 | 2017 | TEX | AL | 1.151624549 | -0.015 | 3B, LF, 2B, SS, CF | 2 | 1 | TEX | 2017 | 2018 | STL | |
4491 | 4491 | Dominic Leone | 25 | leonedo01 | 2017 | TOR | AL | 2.242419039 | 1.78 | P | 9 | 1 | TOR | ARI | 2017 | 2017 | STL |
4563 | 4563 | Matt Wieters | 31 | wietema01 | 2017 | WSN | NL | 4.61025641 | -0.925 | C | 4 | 1 | WSN | BAL | 2017 | 2018 | STL |
4593 | 4593 | Paul Goldschmidt | 28 | goldspa01 | 2016 | ARI | NL | 6.900101249 | 4.815 | 1B | 24 | 1 | ARI | 2011 | 2018 | STL | |
4679 | 4679 | John Gant | 23 | gantjo01 | 2016 | ATL | NL | 1.106414865 | -0.120745342 | P | 1 | 1 | ATL | 2016 | 2016 | STL | |
4743 | 4743 | Francisco Pena | 26 | penafr01 | 2016 | BAL | AL | 0.411483254 | -0.195 | C | 0 | 1 | BAL | KCR | 2016 | 2017 | STL |
4804 | 4804 | Dexter Fowler | 30 | fowlede01 | 2016 | CHC | NL | 5.384667228 | 4.34 | CF | 20 | 1 | CHC | HOU | 2015 | 2016 | STL |
4859 | 4859 | Zach Duke | 33 | dukeza01 | 2016 | CHW | AL | 1.293693977 | 1.04 | P | 5 | 1 | CHW | MIL | 2015 | 2016 | STL |
4962 | 4962 | Andrew Miller | 31 | millean01 | 2016 | CLE | AL | 1.039177459 | 1.267826087 | P | 5 | 2 | CLE | NYY | 2016 | 2018 | STL |
5102 | 5102 | Luke Gregerson | 32 | gregelu01 | 2016 | HOU | AL | 2.240949921 | 0.795 | P | 5 | 1 | HOU | OAK | 2015 | 2017 | STL |
5281 | 5281 | Marcell Ozuna | 25 | ozunama01 | 2016 | MIA | NL | 6.062231391 | 2.490372671 | CF, LF, RF | 16 | 1 | FLA | 2013 | 2017 | STL | |
5511 | 5511 | Chasen Shreve | 25 | shrevch01 | 2016 | NYY | AL | 0.942905165 | -0.145 | P | 1 | 1 | NYY | ATL | 2015 | 2018 | STL |
5667 | 5667 | Eric Fryer | 30 | fryerer01 | 2016 | PIT | NL | 0.898316498 | -0.245 | C | 1 | 2 | PIT | STL | 2016 | 2016 | STL |
6002 | 6002 | Brett Cecil | 29 | cecilbr01 | 2016 | TOR | AL | 1.217754596 | 0.345 | P | 3 | 1 | TOR | 2009 | 2016 | STL | |
6074 | 6074 | Paul Goldschmidt | 27 | goldspa01 | 2015 | ARI | NL | 6.7782075 | 7.945 | 1B | 32 | 1 | ARI | 2011 | 2018 | STL | |
6287 | 6287 | Dexter Fowler | 29 | fowlede01 | 2015 | CHC | NL | 6.872746007 | 2.685 | CF | 19 | 1 | CHC | HOU | 2015 | 2016 | STL |
6355 | 6355 | Zach Duke | 32 | dukeza01 | 2015 | CHW | AL | 2.250680293 | 0.02 | P | 3 | 1 | CHW | MIL | 2015 | 2016 | STL |
6388 | 6388 | Brayan Pena | 33 | penabr01 | 2015 | CIN | NL | 3.633043181 | 0.005 | C, 1B | 4 | 1 | CIN | DET | 2014 | 2015 | STL |
6446 | 6446 | Brandon Moss | 31 | mossbr01 | 2015 | CLE | AL | 3.574363188 | -0.447763975 | RF, 1B, LF | 3 | 1 | CLE | OAK | 2015 | 2015 | STL |
6502 | 6502 | Michael McKenry | 30 | mckenmi01 | 2015 | COL | NL | 1.533217391 | -0.03 | C | 2 | 1 | COL | PIT | 2014 | 2015 | STL |
6587 | 6587 | Luke Gregerson | 31 | gregelu01 | 2015 | HOU | AL | 2.272888031 | 0.845 | P | 5 | 1 | HOU | OAK | 2015 | 2017 | STL |
6773 | 6773 | Marcell Ozuna | 24 | ozunama01 | 2015 | MIA | NL | 5.053262787 | 1.01 | CF, RF | 10 | 1 | FLA | 2013 | 2017 | STL | |
6799 | 6799 | Steve Cishek | 29 | cishest01 | 2015 | MIA | NL | 1.1629467 | -0.2 | P | 1 | 1 | FLA | 2010 | 2015 | STL | |
6851 | 6851 | Jonathan Broxton | 31 | broxtjo01 | 2015 | MIL | NL | 1.107594663 | -0.225 | P | 1 | 1 | MIL | CIN | 2014 | 2015 | STL |
6859 | 6859 | Preston Guilmet | 27 | guilmpr01 | 2015 | MIL | NL | 0.036123987 | -0.165 | P | 0 | 2 | MIL | TBD | 2015 | 2015 | STL |
6894 | 6894 | Eric Fryer | 29 | fryerer01 | 2015 | MIN | AL | 0.261130565 | 0.13 | C | 1 | 1 | MIN | PIT | 2013 | 2015 | STL |
6926 | 6926 | Ruben Tejada | 25 | tejadru01 | 2015 | NYM | NL | 4.074918004 | 0.47 | SS, 3B, 2B | 7 | 1 | NYM | 2010 | 2015 | STL | |
6982 | 6982 | Chasen Shreve | 24 | shrevch01 | 2015 | NYY | AL | 1.875321147 | 0.53 | P | 4 | 1 | NYY | ATL | 2015 | 2018 | STL |
7086 | 7086 | Jerome Williams | 33 | willije01 | 2015 | PHI | NL | 3.968075994 | -0.66 | P | 4 | 1 | PHI | TEX | 2014 | 2015 | STL |
7172 | 7172 | Jedd Gyorko | 26 | gyorkje01 | 2015 | SDP | NL | 4.65871624 | 0.665 | 2B, SS, 1B | 9 | 1 | SDP | 2013 | 2015 | STL | |
7244 | 7244 | Steven Baron | 24 | baronst01 | 2015 | SEA | AL | 0.104487389 | -0.24 | C | 0 | 1 | SEA | 2015 | 2015 | STL | |
7284 | 7284 | Mike Leake | 27 | leakemi01 | 2015 | SFG | NL | 1.537361462 | 0.21 | P | 3 | 2 | SFG | CIN | 2015 | 2015 | STL |
7479 | 7479 | Brett Cecil | 28 | cecilbr01 | 2015 | TOR | AL | 1.825206198 | 1.27 | P | 6 | 1 | TOR | 2009 | 2016 | STL | |
7559 | 7559 | Paul Goldschmidt | 26 | goldspa01 | 2014 | ARI | NL | 4.823263889 | 4.43 | 1B | 20 | 1 | ARI | 2011 | 2018 | STL | |
7611 | 7611 | Jason Heyward | 24 | heywaja01 | 2014 | ATL | NL | 6.595759593 | 5.245 | RF | 25 | 1 | ATL | 2010 | 2014 | STL | |
7624 | 7624 | Jordan Walden | 26 | waldejo01 | 2014 | ATL | NL | 1.792570526 | 0.835 | P | 5 | 1 | ATL | ANA | 2013 | 2014 | STL |
7700 | 7700 | John Lackey | 35 | lackejo01 | 2014 | BOS | AL | 3.739658538 | 1.71 | P | 10 | 1 | BOS | ANA | 2010 | 2014 | STL |
7725 | 7725 | A.J. Pierzynski | 37 | pierza.01 | 2014 | BOS | AL | 2.560747664 | -0.52 | C | 2 | 1 | BOS | TEX | 2014 | 2014 | STL |
7769 | 7769 | Carlos Villanueva | 30 | villaca01 | 2014 | CHC | NL | 2.343047009 | 0.425 | P | 4 | 1 | CHC | TOR | 2013 | 2014 | STL |
7858 | 7858 | Brayan Pena | 32 | penabr01 | 2014 | CIN | NL | 3.835733333 | -0.235 | 1B, C | 5 | 1 | CIN | DET | 2014 | 2015 | STL |
7908 | 7908 | Justin Masterson | 29 | masteju01 | 2014 | CLE | AL | 2.63048077 | 0.155 | P | 4 | 1 | CLE | BOS | 2009 | 2014 | STL |
7915 | 7915 | George Kottaras | 31 | kottage01 | 2014 | CLE | AL | 0.252539913 | 0.32 | C | 1 | 1 | CLE | KCR | 2014 | 2014 | STL |
7944 | 7944 | Michael McKenry | 29 | mckenmi01 | 2014 | COL | NL | 1.909465021 | 1.325 | C | 6 | 1 | COL | PIT | 2014 | 2015 | STL |
7952 | 7952 | Matt Belisle | 34 | belisma01 | 2014 | COL | NL | 1.863081797 | 0.25 | P | 3 | 1 | COL | CIN | 2009 | 2014 | STL |
8229 | 8229 | Marcell Ozuna | 23 | ozunama01 | 2014 | MIA | NL | 6.055271238 | 4.455 | CF, LF, RF | 21 | 1 | FLA | 2013 | 2017 | STL | |
8236 | 8236 | Steve Cishek | 28 | cishest01 | 2014 | MIA | NL | 2.90960929 | 1.525 | P | 8 | 1 | FLA | 2010 | 2015 | STL | |
8284 | 8284 | Mark Reynolds | 30 | reynoma01 | 2014 | MIL | NL | 4.396708683 | 0.835 | 1B, 3B, RF | 9 | 1 | MIL | NYY | 2014 | 2014 | STL |
8301 | 8301 | Jonathan Broxton | 30 | broxtjo01 | 2014 | MIL | NL | 0.424177589 | 0.125 | P | 1 | 2 | MIL | CIN | 2014 | 2015 | STL |
8352 | 8352 | Eric Fryer | 28 | fryerer01 | 2014 | MIN | AL | 0.756399936 | -0.22 | C | 0 | 1 | MIN | PIT | 2013 | 2015 | STL |
8371 | 8371 | Ruben Tejada | 24 | tejadru01 | 2014 | NYM | NL | 4.196511829 | 1.445 | SS | 10 | 1 | NYM | 2010 | 2015 | STL | |
8445 | 8445 | Dean Anna | 27 | annade01 | 2014 | NYY | AL | 0.239392439 | 0.01 | SS, 2B, P | 0 | 1 | NYY | 2014 | 2014 | STL | |
8524 | 8524 | Jerome Williams | 32 | willije01 | 2014 | PHI | NL | 1.556988067 | 0.995 | P | 5 | 3 | PHI | TEX | 2014 | 2015 | STL |
8618 | 8618 | Jedd Gyorko | 25 | gyorkje01 | 2014 | SDP | NL | 4.595600072 | -0.31 | 2B | 6 | 1 | SDP | 2013 | 2015 | STL | |
8872 | 8872 | Miles Mikolas | 25 | mikolmi01 | 2014 | TEX | AL | 1.657402413 | -0.33 | P | 1 | 1 | TEX | SDP | 2014 | 2014 | STL |
8911 | 8911 | Brett Cecil | 27 | cecilbr01 | 2014 | TOR | AL | 1.817226628 | 1.27 | P | 6 | 1 | TOR | 2009 | 2016 | STL | |
8946 | 8946 | Dan Johnson | 34 | johnsda06 | 2014 | TOR | AL | 0.453346361 | -0.265 | 1B | 0 | 1 | TOR | BAL | 2014 | 2014 | STL |
8992 | 8992 | Paul Goldschmidt | 25 | goldspa01 | 2013 | ARI | NL | 6.881684492 | 6.565 | 1B | 30 | 1 | ARI | 2011 | 2018 | STL | |
9041 | 9041 | Jason Heyward | 23 | heywaja01 | 2013 | ATL | NL | 4.422110553 | 3.31 | RF, CF | 17 | 1 | ATL | 2010 | 2014 | STL | |
9055 | 9055 | Jordan Walden | 25 | waldejo01 | 2013 | ATL | NL | 1.638999674 | 0.55 | P | 4 | 1 | ATL | ANA | 2013 | 2014 | STL |
9140 | 9140 | John Lackey | 34 | lackejo01 | 2013 | BOS | AL | 5.216829423 | 2.65 | P | 15 | 1 | BOS | ANA | 2010 | 2014 | STL |
9188 | 9188 | Carlos Villanueva | 29 | villaca01 | 2013 | CHC | NL | 3.652719606 | 1.275 | P | 8 | 1 | CHC | TOR | 2013 | 2014 | STL |
9323 | 9323 | Justin Masterson | 28 | masteju01 | 2013 | CLE | AL | 5.320675237 | 3.675 | P | 19 | 1 | CLE | BOS | 2009 | 2014 | STL |
9384 | 9384 | Matt Belisle | 33 | belisma01 | 2013 | COL | NL | 2.653640942 | 0.925 | P | 6 | 1 | COL | CIN | 2009 | 2014 | STL |
9420 | 9420 | Jhonny Peralta | 31 | peraljh01 | 2013 | DET | AL | 4.082966688 | 3.5 | SS, LF | 15 | 1 | DET | CLE | 2010 | 2013 | STL |
9565 | 9565 | Peter Bourjos | 26 | bourjpe01 | 2013 | LAA | AL | 1.822671156 | 0.67 | CF | 4 | 1 | ANA | 2010 | 2013 | STL | |
9603 | 9603 | Mark Ellis | 36 | ellisma01 | 2013 | LAD | NL | 4.809120746 | 2.255 | 2B, 3B | 13 | 1 | LAD | COL | 2012 | 2013 | STL |
9647 | 9647 | Steve Cishek | 27 | cishest01 | 2013 | MIA | NL | 2.62904984 | 1.785 | P | 9 | 1 | FLA | 2010 | 2015 | STL | |
9654 | 9654 | Marcell Ozuna | 22 | ozunama01 | 2013 | MIA | NL | 2.958457493 | 1.235 | RF, CF | 7 | 1 | FLA | 2013 | 2017 | STL | |
9726 | 9726 | John Axford | 30 | axforjo01 | 2013 | MIL | NL | 1.87273226 | -0.61 | P | 1 | 1 | MIL | 2009 | 2013 | STL | |
9765 | 9765 | Eric Fryer | 27 | fryerer01 | 2013 | MIN | AL | 0.149943448 | 0.42 | C | 1 | 1 | MIN | PIT | 2013 | 2015 | STL |
9819 | 9819 | Ruben Tejada | 23 | tejadru01 | 2013 | NYM | NL | 2.243312319 | -0.61 | SS | 1 | 1 | NYM | 2010 | 2015 | STL | |
9916 | 9916 | Pat Neshek | 32 | neshepa01 | 2013 | OAK | AL | 0.853445226 | 0.135 | P | 2 | 1 | OAK | SDP | 2012 | 2013 | STL |
10039 | 10039 | Jedd Gyorko | 24 | gyorkje01 | 2013 | SDP | NL | 5.262703076 | 2.295 | 2B, 3B | 15 | 1 | SDP | 2013 | 2015 | STL | |
10285 | 10285 | Joey Butler | 27 | butlejo04 | 2013 | TEX | AL | 0.140890688 | 0.213680982 | LF, RF | 1 | 1 | TEX | 2013 | 2013 | STL | |
10315 | 10315 | Brett Cecil | 26 | cecilbr01 | 2013 | TOR | AL | 1.793050608 | 1.115 | P | 6 | 1 | TOR | 2009 | 2016 | STL | |
10404 | 10404 | Paul Goldschmidt | 24 | goldspa01 | 2012 | ARI | NL | 5.893370261 | 3.115 | 1B | 17 | 1 | ARI | 2011 | 2018 | STL | |
10450 | 10450 | Jason Heyward | 22 | heywaja01 | 2012 | ATL | NL | 6.543847487 | 5.405 | RF, CF | 27 | 1 | ATL | 2010 | 2014 | STL | |
10631 | 10631 | Miguel Socolovich | 25 | socolmi01 | 2012 | CHC | NL | 0.152747589 | 0.015 | P | 0 | 2 | CHC | BAL | 2012 | 2012 | STL |
10739 | 10739 | Justin Masterson | 27 | masteju01 | 2012 | CLE | AL | 5.863652396 | 1.65 | P | 13 | 1 | CLE | BOS | 2009 | 2014 | STL |
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 );