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,914 rows where next_franch = "BAL"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
295 | 295 | Jose Rondon | 25 | rondojo02 | 2019 | CHW | AL | 1.529411765 | -0.712594937 | 2B, SS, 3B, LF, 1B, P | 0 | 1 | CHW | SDP | 2018 | 2019 | BAL |
837 | 837 | Ryan Eades | 27 | eadesry01 | 2019 | MIN | AL | 0.064145451 | 0.117169811 | P | 0 | 1 | MIN | 2019 | 2019 | BAL | |
903 | 903 | Keon Broxton | 29 | broxtke01 | 2019 | NYM | NL | 0.526369863 | -0.550188679 | CF, LF, RF | 0 | 1 | NYM | MIL | 2019 | 2019 | BAL |
995 | 995 | Aaron Brooks | 29 | brookaa01 | 2019 | OAK | AL | 1.063475631 | -0.076415094 | P | 1 | 1 | OAK | KCR | 2015 | 2019 | BAL |
1227 | 1227 | Tayler Scott | 27 | scottta02 | 2019 | SEA | AL | 0.173759928 | -0.183396226 | P | 0 | 1 | SEA | 2019 | 2019 | BAL | |
1228 | 1228 | Shawn Armstrong | 28 | armstsh01 | 2019 | SEA | AL | 0.11193408 | -0.219056604 | P | 0 | 1 | SEA | CLE | 2018 | 2019 | BAL |
1294 | 1294 | Ty Blach | 28 | blachty01 | 2019 | SFG | NL | 0.121795013 | -0.259811321 | P | 0 | 1 | SFG | 2016 | 2019 | BAL | |
1652 | 1652 | Rio Ruiz | 24 | ruizri01 | 2018 | ATL | NL | 0.146885024 | -0.01 | 3B | 0 | 1 | ATL | 2016 | 2018 | BAL | |
1665 | 1665 | Evan Phillips | 23 | phillev01 | 2018 | ATL | NL | 0.108609772 | -0.17 | P | 0 | 1 | ATL | 2018 | 2018 | BAL | |
1848 | 1848 | Jose Rondon | 24 | rondojo02 | 2018 | CHW | AL | 1.025785124 | 0.31 | SS, 3B, 2B, 1B | 2 | 1 | CHW | SDP | 2018 | 2019 | BAL |
1897 | 1897 | Mason Williams | 26 | willima10 | 2018 | CIN | NL | 1.299168505 | 0.04 | RF, CF, LF | 2 | 1 | CIN | NYY | 2018 | 2018 | BAL |
2262 | 2262 | Breyvic Valera | 26 | valerbr01 | 2018 | LAD | NL | 0.327302905 | -0.139141104 | 2B, 3B, SS, RF | 0 | 1 | LAD | STL | 2018 | 2018 | BAL |
2277 | 2277 | Dan Straily | 29 | straida01 | 2018 | MIA | NL | 3.46662217 | 0.674161491 | P | 7 | 1 | FLA | CIN | 2017 | 2018 | BAL |
2328 | 2328 | Jonathan Villar | 27 | villajo01 | 2018 | MIL | NL | 2.735756551 | 1.073374233 | 2B, SS | 8 | 1 | MIL | HOU | 2016 | 2018 | BAL |
2524 | 2524 | Jace Peterson | 28 | peterja01 | 2018 | NYY | AL | 0.102096335 | -0.085 | 3B, LF, 2B, RF, SS, P | 0 | 1 | NYY | ATL | 2018 | 2018 | BAL |
2570 | 2570 | Aaron Brooks | 28 | brookaa01 | 2018 | OAK | AL | 0.039472261 | 0.04 | P | 0 | 1 | OAK | KCR | 2015 | 2019 | BAL |
2575 | 2575 | Josh Lucas | 27 | lucasjo02 | 2018 | OAK | AL | 0.281484118 | -0.1 | P | 0 | 1 | OAK | STL | 2018 | 2018 | BAL |
2750 | 2750 | Shawn Armstrong | 27 | armstsh01 | 2018 | SEA | AL | 0.455194944 | 0.42 | P | 2 | 1 | SEA | CLE | 2018 | 2019 | BAL |
2756 | 2756 | John Andreoli | 28 | andrejo03 | 2018 | SEA | AL | 0.057378401 | 0.25 | LF, RF, CF | 1 | 1 | SEA | 2018 | 2018 | BAL | |
2796 | 2796 | Ty Blach | 27 | blachty01 | 2018 | SFG | NL | 3.266742468 | 0.28 | P | 6 | 1 | SFG | 2016 | 2019 | BAL | |
2931 | 2931 | Jesus Sucre | 30 | sucreje01 | 2018 | TBR | AL | 1.860359631 | -0.805 | C, P | 0 | 1 | TBD | SEA | 2017 | 2018 | BAL |
2961 | 2961 | Renato Nunez | 24 | nunezre01 | 2018 | TEX | AL | 0.387044271 | 0.16 | 3B, LF | 1 | 1 | TEX | OAK | 2018 | 2018 | BAL |
2973 | 2973 | Hanser Alberto | 25 | alberha01 | 2018 | TEX | AL | 0.283203125 | -0.245 | SS, 2B, 3B | 0 | 1 | TEX | 2015 | 2018 | BAL | |
3021 | 3021 | Dwight Smith Jr. | 25 | smithdw02 | 2018 | TOR | AL | 0.718770654 | -0.01 | LF, RF | 1 | 1 | TOR | 2017 | 2018 | BAL | |
3097 | 3097 | Pedro Severino | 24 | severpe01 | 2018 | WSN | NL | 2.077349924 | -0.885 | C | 0 | 1 | WSN | 2015 | 2018 | BAL | |
3169 | 3169 | Rio Ruiz | 23 | ruizri01 | 2017 | ATL | NL | 1.70240923 | -0.23 | 3B, 1B | 2 | 1 | ATL | 2016 | 2018 | BAL | |
3420 | 3420 | Asher Wojciechowski | 28 | wojcias01 | 2017 | CIN | NL | 1.698703428 | -0.405 | P | 1 | 1 | CIN | HOU | 2017 | 2017 | BAL |
3630 | 3630 | Nate Karns | 29 | karnsna01 | 2017 | KCR | AL | 1.238748945 | 0.685 | P | 4 | 1 | KCR | SEA | 2017 | 2017 | BAL |
3776 | 3776 | Dan Straily | 28 | straida01 | 2017 | MIA | NL | 5.180324972 | 1.24 | P | 11 | 1 | FLA | CIN | 2017 | 2018 | BAL |
3828 | 3828 | Jonathan Villar | 26 | villajo01 | 2017 | MIL | NL | 4.345763877 | -0.155 | 2B, CF | 6 | 1 | MIL | HOU | 2016 | 2018 | BAL |
3855 | 3855 | Andrew Susac | 27 | susacan01 | 2017 | MIL | NL | 0.11960818 | -0.22 | C | 0 | 1 | MIL | SFG | 2016 | 2017 | BAL |
3952 | 3952 | Sean Gilmartin | 27 | gilmase01 | 2017 | NYM | NL | 0.071639468 | -0.035 | P | 0 | 1 | NYM | 2015 | 2017 | BAL | |
4083 | 4083 | Jeremy Hellickson | 30 | hellije01 | 2017 | PHI | NL | 3.180410445 | 0.8 | P | 6 | 1 | PHI | ARI | 2016 | 2017 | BAL |
4214 | 4214 | Luis Sardinas | 24 | sardilu01 | 2017 | SDP | NL | 0.544359837 | -0.425 | 2B, SS, 3B, P | 0 | 1 | SDP | SEA | 2016 | 2017 | BAL |
4233 | 4233 | Danny Valencia | 32 | valenda01 | 2017 | SEA | AL | 4.7238964 | 0.295 | 1B, RF, 3B | 7 | 1 | SEA | OAK | 2017 | 2017 | BAL |
4287 | 4287 | Ty Blach | 26 | blachty01 | 2017 | SFG | NL | 4.5375299 | 1.88 | P | 12 | 1 | SFG | 2016 | 2019 | BAL | |
4385 | 4385 | Alex Cobb | 29 | cobbal01 | 2017 | TBR | AL | 4.895408193 | 2.275 | P | 13 | 1 | TBD | 2011 | 2017 | BAL | |
4387 | 4387 | Tim Beckham | 27 | beckhti01 | 2017 | TBR | AL | 3.268539693 | 1.345 | SS, 2B, 3B | 8 | 1 | TBD | 2013 | 2017 | BAL | |
4394 | 4394 | Colby Rasmus | 30 | rasmuco01 | 2017 | TBR | AL | 1.222149624 | 1.18 | LF, RF, CF | 5 | 1 | TBD | HOU | 2017 | 2017 | BAL |
4398 | 4398 | Jesus Sucre | 29 | sucreje01 | 2017 | TBR | AL | 1.819013394 | 0.65 | C, P | 4 | 1 | TBD | SEA | 2017 | 2018 | BAL |
4433 | 4433 | Andrew Cashner | 30 | cashnan01 | 2017 | TEX | AL | 4.804059357 | 3.42 | P | 17 | 1 | TEX | FLA | 2017 | 2017 | BAL |
4464 | 4464 | Jhan Marinez | 28 | marinjh01 | 2017 | TEX | AL | 0.124598901 | 0.085 | P | 0 | 3 | TEX | PIT | 2017 | 2017 | BAL |
4514 | 4514 | Dwight Smith Jr. | 24 | smithdw02 | 2017 | TOR | AL | 0.274388254 | 0.11 | LF, CF, RF | 1 | 1 | TOR | 2017 | 2018 | BAL | |
4582 | 4582 | Pedro Severino | 23 | severpe01 | 2017 | WSN | NL | 0.307350427 | -0.21 | C | 0 | 1 | WSN | 2015 | 2018 | BAL | |
4597 | 4597 | Welington Castillo | 29 | castiwe01 | 2016 | ARI | NL | 4.47283159 | 1.7 | C | 11 | 1 | ARI | SEA | 2015 | 2016 | BAL |
4606 | 4606 | Michael Bourn | 33 | bournmi01 | 2016 | ARI | NL | 3.503881201 | 0.06 | CF, LF, RF | 5 | 1 | ARI | ATL | 2016 | 2016 | BAL |
4683 | 4683 | Rio Ruiz | 22 | ruizri01 | 2016 | ATL | NL | 0.069071113 | 0.08552795 | 3B | 0 | 1 | ATL | 2016 | 2018 | BAL | |
4971 | 4971 | Tommy Hunter | 29 | hunteto02 | 2016 | CLE | AL | 0.604598477 | 0.246521739 | P | 2 | 1 | CLE | CHC | 2016 | 2016 | BAL |
5030 | 5030 | Miguel Castro | 21 | castrmi01 | 2016 | COL | NL | 0.534626272 | -0.12 | P | 0 | 1 | COL | TOR | 2015 | 2016 | BAL |
5181 | 5181 | Johnny Giavotella | 28 | giavojo01 | 2016 | LAA | AL | 3.535880399 | 0.305 | 2B | 6 | 1 | ANA | KCR | 2015 | 2016 | BAL |
5214 | 5214 | Craig Gentry | 32 | gentrcr01 | 2016 | LAA | AL | 0.375747508 | -0.305 | LF, CF | 0 | 1 | ANA | OAK | 2016 | 2016 | BAL |
5331 | 5331 | Jonathan Villar | 25 | villajo01 | 2016 | MIL | NL | 6.846662031 | 3.445 | SS, 3B, 2B | 20 | 1 | MIL | HOU | 2016 | 2018 | BAL |
5361 | 5361 | Andrew Susac | 26 | susacan01 | 2016 | MIL | NL | 0.191585535 | 0.045 | C | 0 | 1 | MIL | SFG | 2016 | 2017 | BAL |
5464 | 5464 | Gabriel Ynoa | 23 | ynoaga01 | 2016 | NYM | NL | 0.449808287 | 0.05 | P | 1 | 1 | NYM | 2016 | 2016 | BAL | |
5468 | 5468 | Logan Verrett | 26 | verrelo01 | 2016 | NYM | NL | 2.208149773 | -0.635 | P | 1 | 1 | NYM | TEX | 2015 | 2016 | BAL |
5472 | 5472 | Sean Gilmartin | 26 | gilmase01 | 2016 | NYM | NL | 0.404554847 | -0.3 | P | 0 | 1 | NYM | 2015 | 2017 | BAL | |
5498 | 5498 | Richard Bleier | 29 | bleieri01 | 2016 | NYY | AL | 0.484975043 | 0.455 | P | 2 | 1 | NYY | 2016 | 2016 | BAL | |
5582 | 5582 | Jeremy Hellickson | 29 | hellije01 | 2016 | PHI | NL | 5.318189635 | 3.335 | P | 18 | 1 | PHI | ARI | 2016 | 2017 | BAL |
5598 | 5598 | Alec Asher | 24 | asheral01 | 2016 | PHI | NL | 0.749358696 | 0.55 | P | 3 | 1 | PHI | 2015 | 2016 | BAL | |
5705 | 5705 | Luis Sardinas | 23 | sardilu01 | 2016 | SDP | NL | 1.222983658 | 0.395 | SS, 1B, 2B, 3B, LF, P | 3 | 2 | SDP | SEA | 2016 | 2017 | BAL |
5708 | 5708 | Edwin Jackson | 32 | jacksed01 | 2016 | SDP | NL | 2.082094192 | 0.1 | P | 3 | 2 | SDP | FLA | 2016 | 2016 | BAL |
5753 | 5753 | Seth Smith | 33 | smithse01 | 2016 | SEA | AL | 4.096098033 | 0.7 | RF, LF | 8 | 1 | SEA | SDP | 2015 | 2016 | BAL |
5758 | 5758 | Wade Miley | 29 | mileywa01 | 2016 | SEA | AL | 3.076714293 | 0.645 | P | 6 | 1 | SEA | BOS | 2016 | 2016 | BAL |
5763 | 5763 | Vidal Nuno III | 28 | nunovi01 | 2016 | SEA | AL | 1.697794722 | 0.5 | P | 4 | 1 | SEA | ARI | 2015 | 2016 | BAL |
5821 | 5821 | Ty Blach | 25 | blachty01 | 2016 | SFG | NL | 0.355959565 | 0.595 | P | 2 | 1 | SFG | 2016 | 2019 | BAL | |
5830 | 5830 | Ruben Tejada | 26 | tejadru01 | 2016 | SFG | NL | 0.373622648 | 0.04 | 3B, SS, 2B, P | 1 | 2 | SFG | STL | 2016 | 2016 | BAL |
5890 | 5890 | Steve Pearce | 33 | pearcst01 | 2016 | TBR | AL | 2.23484471 | 1.945 | 1B, 2B, LF, RF, 3B | 8 | 1 | TBD | BAL | 2016 | 2016 | BAL |
5896 | 5896 | Tim Beckham | 26 | beckhti01 | 2016 | TBR | AL | 2.071084537 | 1.12 | SS, 2B, 3B, 1B | 6 | 1 | TBD | 2013 | 2017 | BAL | |
5925 | 5925 | Alex Cobb | 28 | cobbal01 | 2016 | TBR | AL | 0.622173194 | -0.44 | P | 0 | 1 | TBD | 2011 | 2017 | BAL | |
5968 | 5968 | Drew Stubbs | 31 | stubbdr01 | 2016 | TEX | AL | 0.238997857 | -0.02 | RF, CF, LF | 0 | 2 | TEX | ATL | 2016 | 2016 | BAL |
5972 | 5972 | Hanser Alberto | 23 | alberha01 | 2016 | TEX | AL | 0.554475029 | -0.29 | 3B, SS, 2B, 1B | 0 | 1 | TEX | 2015 | 2018 | BAL | |
6055 | 6055 | Pedro Severino | 22 | severpe01 | 2016 | WSN | NL | 0.33819242 | 0.65 | C | 2 | 1 | WSN | 2015 | 2018 | BAL | |
6086 | 6086 | Welington Castillo | 28 | castiwe01 | 2015 | ARI | NL | 2.955103413 | 1.17 | C | 7 | 3 | ARI | SEA | 2015 | 2016 | BAL |
6330 | 6330 | Junior Lake | 25 | lakeju01 | 2015 | CHC | NL | 0.617551091 | -0.3 | RF, LF, CF | 0 | 1 | CHC | 2013 | 2015 | BAL | |
6516 | 6516 | Miguel Castro | 20 | castrmi01 | 2015 | COL | NL | 0.118815883 | -0.155 | P | 0 | 2 | COL | TOR | 2015 | 2016 | BAL |
6517 | 6517 | Jorge Rondon | 27 | rondojo01 | 2015 | COL | NL | 0.01560974 | -0.175 | P | 0 | 1 | COL | STL | 2015 | 2015 | BAL |
6652 | 6652 | Francisco Pena | 25 | penafr01 | 2015 | KCR | AL | 0.066633842 | -0.035 | C | 0 | 1 | KCR | 2014 | 2015 | BAL | |
6668 | 6668 | Johnny Giavotella | 27 | giavojo01 | 2015 | LAA | AL | 4.878686327 | 1.205 | 2B, SS | 12 | 1 | ANA | KCR | 2015 | 2016 | BAL |
6820 | 6820 | Gerardo Parra | 28 | parrage01 | 2015 | MIL | NL | 3.564699702 | 2.26 | RF, LF, CF | 12 | 1 | MIL | ARI | 2014 | 2015 | BAL |
6893 | 6893 | Brian Duensing | 32 | duensbr01 | 2015 | MIN | AL | 1.574596803 | -0.11 | P | 2 | 1 | MIN | 2009 | 2015 | BAL | |
6928 | 6928 | Sean Gilmartin | 25 | gilmase01 | 2015 | NYM | NL | 1.452620641 | 1.04 | P | 5 | 1 | NYM | 2015 | 2017 | BAL | |
6934 | 6934 | Logan Verrett | 25 | verrelo01 | 2015 | NYM | NL | 1.132571544 | 0.455 | P | 3 | 2 | NYM | TEX | 2015 | 2016 | BAL |
7061 | 7061 | Aaron Brooks | 25 | brookaa01 | 2015 | OAK | AL | 1.566744815 | -0.49 | P | 0 | 2 | OAK | KCR | 2015 | 2019 | BAL |
7115 | 7115 | Alec Asher | 23 | asheral01 | 2015 | PHI | NL | 0.834938739 | -0.615 | P | 0 | 1 | PHI | 2015 | 2016 | BAL | |
7131 | 7131 | Pedro Alvarez | 28 | alvarpe01 | 2015 | PIT | NL | 4.790243902 | 0.335 | 1B | 9 | 1 | PIT | 2010 | 2015 | BAL | |
7140 | 7140 | Vance Worley | 27 | worleva01 | 2015 | PIT | NL | 1.868645577 | 0.27 | P | 4 | 1 | PIT | MIN | 2014 | 2015 | BAL |
7191 | 7191 | Odrisamer Despaigne | 28 | despaod01 | 2015 | SDP | NL | 3.173288895 | -0.865 | P | 2 | 1 | SDP | 2014 | 2015 | BAL | |
7214 | 7214 | Seth Smith | 32 | smithse01 | 2015 | SEA | AL | 4.293481821 | 1.805 | LF, RF | 12 | 1 | SEA | SDP | 2015 | 2016 | BAL |
7224 | 7224 | Mark Trumbo | 29 | trumbma01 | 2015 | SEA | AL | 3.429086145 | 0.635 | RF, 1B, LF | 7 | 2 | SEA | ARI | 2015 | 2015 | BAL |
7228 | 7228 | Vidal Nuno III | 27 | nunovi01 | 2015 | SEA | AL | 2.117264355 | 0.575 | P | 5 | 2 | SEA | ARI | 2015 | 2016 | BAL |
7380 | 7380 | Tim Beckham | 25 | beckhti01 | 2015 | TBR | AL | 2.137497934 | -0.035 | 2B, SS, 3B | 3 | 1 | TBD | 2013 | 2017 | BAL | |
7408 | 7408 | Yovani Gallardo | 29 | gallayo01 | 2015 | TEX | AL | 5.165424154 | 3.385 | P | 18 | 1 | TEX | MIL | 2015 | 2015 | BAL |
7432 | 7432 | Hanser Alberto | 22 | alberha01 | 2015 | TEX | AL | 0.978426602 | 0.345 | 2B, SS, 3B | 3 | 1 | TEX | 2015 | 2018 | BAL | |
7551 | 7551 | Pedro Severino | 21 | severpe01 | 2015 | WSN | NL | 0.040298767 | 0.01 | C | 0 | 1 | WSN | 2015 | 2018 | BAL | |
7594 | 7594 | Nolan Reimold | 30 | reimono01 | 2014 | ARI | NL | 0.18125 | 0.08 | RF, LF | 0 | 2 | ARI | TOR | 2014 | 2014 | BAL |
7710 | 7710 | Andrew Miller | 29 | millean01 | 2014 | BOS | AL | 1.473312076 | 1.095 | P | 5 | 1 | BOS | FLA | 2011 | 2014 | BAL |
7742 | 7742 | Kelly Johnson | 32 | johnske05 | 2014 | BOS | AL | 0.23364486 | -0.185 | 3B, 1B, 2B, LF, RF | 0 | 2 | BOS | NYY | 2014 | 2014 | BAL |
7743 | 7743 | Ryan Lavarnway | 26 | lavarry01 | 2014 | BOS | AL | 0.093457944 | -0.25 | 1B | 0 | 1 | BOS | 2011 | 2014 | BAL | |
7768 | 7768 | Wesley Wright | 29 | wrighwe01 | 2014 | CHC | NL | 1.493857603 | 0.545 | P | 4 | 1 | CHC | TBD | 2014 | 2014 | BAL |
7778 | 7778 | Junior Lake | 24 | lakeju01 | 2014 | CHC | NL | 3.279223032 | -0.9 | LF, CF, RF | 2 | 1 | CHC | 2013 | 2015 | BAL |
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 );