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,037 rows where prev_franch = "ATL"
This data as json, copyable, CSV (advanced)
Suggested facets: age, lg_ID, stint_ID, franch_id, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104 | 104 | Rio Ruiz | 25 | ruizri01 | 2019 | BAL | AL | 3.863471074 | 0.590943396 | 3B, 1B, 2B | 6 | 1 | BAL | ATL | 2019 | 2019 | |
119 | 119 | Evan Phillips | 24 | phillev01 | 2019 | BAL | AL | 0.706013341 | 0.112075472 | P | 1 | 1 | BAL | ATL | 2018 | 2019 | |
232 | 232 | Brad Brach | 33 | brachbr01 | 2019 | CHC | NL | 1.189527491 | -0.020377358 | P | 1 | 1 | CHC | ATL | 2019 | 2019 | NYM |
280 | 280 | Manny Banuelos | 28 | banuema01 | 2019 | CHW | AL | 1.294418749 | -0.399873418 | P | 1 | 1 | CHW | ATL | 2019 | 2019 | |
320 | 320 | Lucas Sims | 25 | simslu01 | 2019 | CIN | NL | 1.13643691 | 0.366792453 | P | 3 | 1 | CIN | ATL | 2018 | 2019 | |
327 | 327 | Kevin Gausman | 28 | gausmke01 | 2019 | CIN | NL | 0.572838117 | 0.198679245 | P | 1 | 2 | CIN | ATL | 2019 | 2019 | |
396 | 396 | Ryan Flaherty | 32 | flahery01 | 2019 | CLE | AL | 0.173942019 | -0.26490566 | 3B, 2B | 0 | 1 | CLE | ATL | 2019 | 2019 | |
440 | 440 | Wes Parsons | 26 | parsowe01 | 2019 | COL | NL | 0.47809821 | -0.290377358 | P | 0 | 2 | COL | ATL | 2019 | 2019 | |
493 | 493 | Dustin Peterson | 24 | peterdu01 | 2019 | DET | AL | 0.461018096 | -0.405 | LF, CF, RF, 1B | 0 | 1 | DET | ATL | 2019 | 2019 | |
598 | 598 | Lucas Duda | 33 | dudalu01 | 2019 | KCR | AL | 1.158248028 | -0.860943396 | 1B | 0 | 1 | KCR | ATL | 2019 | 2019 | |
606 | 606 | Andrelton Simmons | 29 | simmoan01 | 2019 | LAA | AL | 3.908304781 | 1.635283019 | SS | 10 | 1 | ANA | ATL | 2016 | 2019 | |
641 | 641 | Sam Freeman | 32 | freemsa01 | 2019 | LAA | AL | 0.038489964 | -0.035660377 | P | 0 | 1 | ANA | ATL | 2019 | 2019 | |
651 | 651 | Peter Bourjos | 32 | bourjpe01 | 2019 | LAA | AL | 0.435307554 | -0.458490566 | LF, CF, 2B | 0 | 1 | ANA | ATL | 2019 | 2019 | |
891 | 891 | Rene Rivera | 35 | riverre01 | 2019 | NYM | NL | 0.15890411 | -0.086603774 | C | 0 | 1 | NYM | ATL | 2019 | 2019 | |
1215 | 1215 | David Freitas | 30 | freitda01 | 2019 | SEA | AL | 0.038245961 | -0.020377358 | C | 0 | 1 | SEA | ATL | 2018 | 2019 | MIL |
1234 | 1234 | Jesse Biddle | 27 | biddlje01 | 2019 | SEA | AL | 0.284923112 | -0.376981132 | P | 0 | 2 | SEA | ATL | 2019 | 2019 | TEX |
1291 | 1291 | Michael Reed | 26 | reedmi02 | 2019 | SFG | NL | 0.080429884 | -0.213962264 | LF, RF | 0 | 1 | SFG | ATL | 2019 | 2019 | |
1318 | 1318 | John Gant | 26 | gantjo01 | 2019 | STL | NL | 2.374516493 | 0.764150943 | P | 6 | 1 | STL | ATL | 2017 | 2019 | |
1366 | 1366 | Chaz Roe | 32 | roech01 | 2019 | TBR | AL | 1.767164016 | 0.524716981 | P | 4 | 1 | TBD | ATL | 2017 | 2019 | |
1405 | 1405 | Danny Santana | 28 | santada01 | 2019 | TEX | AL | 4.766336634 | 2.307735849 | 1B, CF, 2B, LF, RF, SS, 3B | 14 | 1 | TEX | ATL | 2019 | 2019 | |
1419 | 1419 | Kolby Allard | 21 | allarko01 | 2019 | TEX | AL | 1.327160632 | 0.973018868 | P | 5 | 1 | TEX | ATL | 2019 | 2019 | |
1522 | 1522 | Anibal Sanchez | 35 | sanchan01 | 2019 | WSN | NL | 4.78268823 | 2.873207547 | P | 15 | 1 | WSN | ATL | 2019 | 2019 | |
1530 | 1530 | Kurt Suzuki | 35 | suzukku01 | 2019 | WSN | NL | 3.026347512 | 0.351509434 | C | 5 | 1 | WSN | ATL | 2019 | 2019 | |
1550 | 1550 | Jonny Venters | 34 | ventejo01 | 2019 | WSN | NL | 0.165370102 | -0.112075472 | P | 0 | 2 | WSN | ATL | 2019 | 2019 | |
1601 | 1601 | Chris Stewart | 36 | stewach01 | 2018 | ARI | NL | 0.009957082 | -0.015 | C | 0 | 2 | ARI | ATL | 2018 | 2018 | |
1607 | 1607 | Randall Delgado | 28 | delgara01 | 2018 | ARI | NL | 0.264348058 | -0.19 | P | 0 | 1 | ARI | ATL | 2013 | 2018 | |
1613 | 1613 | Shelby Miller | 27 | millesh01 | 2018 | ARI | NL | 0.465917074 | -0.7 | P | 0 | 1 | ARI | ATL | 2016 | 2018 | TEX |
1722 | 1722 | Evan Phillips | 23 | phillev01 | 2018 | BAL | AL | 0.131994905 | -0.415 | P | 0 | 2 | BAL | ATL | 2018 | 2019 | |
1797 | 1797 | Tommy La Stella | 29 | lasteto01 | 2018 | CHC | NL | 1.843708609 | 0.074539877 | 3B, 2B, P | 3 | 1 | CHC | ATL | 2015 | 2018 | ANA |
1898 | 1898 | Matt Wisler | 25 | wislema01 | 2018 | CIN | NL | 0.283350977 | 0.19 | P | 1 | 2 | CIN | ATL | 2018 | 2018 | SDP |
1908 | 1908 | Lucas Sims | 24 | simslu01 | 2018 | CIN | NL | 0.143082195 | -0.105 | P | 0 | 2 | CIN | ATL | 2018 | 2019 | |
1914 | 1914 | Preston Tucker | 27 | tuckepr01 | 2018 | CIN | NL | 0.413371797 | -0.235 | LF, RF | 0 | 2 | CIN | ATL | 2018 | 2018 | |
1970 | 1970 | Alexi Ogando | 34 | ogandal01 | 2018 | CLE | AL | 0.041986154 | -0.14 | P | 0 | 1 | CLE | ATL | 2018 | 2018 | |
2013 | 2013 | Daniel Castro | 25 | castrda01 | 2018 | COL | NL | 0.46654116 | -0.616196319 | 2B, SS | 0 | 1 | COL | ATL | 2018 | 2018 | |
2083 | 2083 | Evan Gattis | 31 | gattiev01 | 2018 | HOU | AL | 4.273484725 | 0.125 | C | 6 | 1 | HOU | ATL | 2015 | 2018 | |
2156 | 2156 | Andrelton Simmons | 28 | simmoan01 | 2018 | LAA | AL | 5.718041407 | 5.785 | SS | 25 | 1 | ANA | ATL | 2016 | 2019 | |
2190 | 2190 | Jim Johnson | 35 | johnsji04 | 2018 | LAA | AL | 1.98346734 | -0.4 | P | 1 | 1 | ANA | ATL | 2018 | 2018 | |
2194 | 2194 | Ian Krol | 27 | krolia01 | 2018 | LAA | AL | 0.043655262 | 0.045 | P | 0 | 1 | ANA | ATL | 2018 | 2018 | |
2201 | 2201 | Akeel Morris | 25 | morriak01 | 2018 | LAA | AL | 0.245798106 | -0.135 | P | 0 | 1 | ANA | ATL | 2018 | 2018 | |
2228 | 2228 | Matt Kemp | 33 | kempma01 | 2018 | LAD | NL | 4.871037344 | 1.321840491 | LF, RF | 10 | 1 | LAD | ATL | 2018 | 2018 | CIN |
2229 | 2229 | Alex Wood | 27 | woodal02 | 2018 | LAD | NL | 4.195648743 | 1.480858896 | P | 9 | 1 | LAD | ATL | 2015 | 2018 | CIN |
2423 | 2423 | Ervin Santana | 35 | santaer01 | 2018 | MIN | AL | 0.68744389 | -0.55 | P | 0 | 1 | MIN | ATL | 2015 | 2018 | CHW |
2436 | 2436 | Jose Bautista | 37 | bautijo02 | 2018 | NYM | NL | 2.997262149 | 0.875 | RF, LF, 3B, 1B, 2B | 7 | 2 | NYM | ATL | 2018 | 2018 | PHI |
2517 | 2517 | Chasen Shreve | 27 | shrevch01 | 2018 | NYY | AL | 1.051227836 | -0.135 | P | 1 | 1 | NYY | ATL | 2015 | 2018 | STL |
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 |
2658 | 2658 | Sean Rodriguez | 33 | rodrise01 | 2018 | PIT | NL | 1.744740045 | -0.206273292 | 2B, SS, LF, CF, RF, 1B, 3B | 2 | 1 | PIT | ATL | 2017 | 2018 | PHI |
2765 | 2765 | David Freitas | 29 | freitda01 | 2018 | SEA | AL | 1.013685078 | -0.05 | C, 1B | 1 | 1 | SEA | ATL | 2018 | 2019 | MIL |
2767 | 2767 | Rob Whalen | 24 | whalero01 | 2018 | SEA | AL | 0.087316647 | 0.095 | P | 0 | 1 | SEA | ATL | 2017 | 2018 | |
2811 | 2811 | Casey Kelly | 28 | kellyca01 | 2018 | SFG | NL | 0.593525155 | 0.105 | P | 1 | 1 | SFG | ATL | 2018 | 2018 | |
2812 | 2812 | Cory Gearrin | 32 | gearrco01 | 2018 | SFG | NL | 0.864776817 | -0.1 | P | 1 | 1 | SFG | ATL | 2015 | 2018 | TEX |
2841 | 2841 | John Gant | 25 | gantjo01 | 2018 | STL | NL | 3.239222898 | 0.83 | P | 7 | 1 | STL | ATL | 2017 | 2019 | |
2880 | 2880 | Mallex Smith | 25 | smithma05 | 2018 | TBR | AL | 5.111291106 | 3.51 | CF, RF, LF | 17 | 1 | TBD | ATL | 2017 | 2018 | SEA |
2903 | 2903 | Chaz Roe | 31 | roech01 | 2018 | TBR | AL | 1.755452413 | 0.42 | P | 4 | 1 | TBD | ATL | 2017 | 2019 | |
2918 | 2918 | Jonny Venters | 33 | ventejo01 | 2018 | TBR | AL | 0.436665598 | 0.135 | P | 1 | 1 | TBD | ATL | 2018 | 2018 | ATL |
2922 | 2922 | Brandon Snyder | 31 | snydebr03 | 2018 | TBR | AL | 0.056374534 | 0.035 | 3B | 0 | 1 | TBD | ATL | 2018 | 2018 | |
2977 | 2977 | Carlos Perez | 27 | perezca02 | 2018 | TEX | AL | 0.500325521 | -0.49 | C | 0 | 2 | TEX | ATL | 2018 | 2018 | |
3058 | 3058 | Matt Adams | 29 | adamsma01 | 2018 | WSN | NL | 2.701530183 | 1.025 | 1B, LF, RF | 6 | 1 | WSN | ATL | 2018 | 2018 | STL |
3116 | 3116 | Randall Delgado | 27 | delgara01 | 2017 | ARI | NL | 1.627602839 | 0.79 | P | 5 | 1 | ARI | ATL | 2013 | 2018 | |
3124 | 3124 | Shelby Miller | 26 | millesh01 | 2017 | ARI | NL | 0.620935187 | 0.44 | P | 2 | 1 | ARI | ATL | 2016 | 2018 | TEX |
3240 | 3240 | Paul Janish | 34 | janispa01 | 2017 | BAL | AL | 0.265272787 | -0.625 | SS | 0 | 1 | BAL | ATL | 2015 | 2017 | |
3277 | 3277 | Chase d'Arnaud | 30 | darnach01 | 2017 | BOS | AL | 0.009184481 | 0.075 | SS, LF, 2B, 3B, 1B, RF | 0 | 2 | BOS | ATL | 2017 | 2017 | SDP |
3313 | 3313 | Tommy La Stella | 28 | lasteto01 | 2017 | CHC | NL | 1.476150346 | 0.53 | 2B, 3B, 1B | 4 | 1 | CHC | ATL | 2015 | 2018 | ANA |
3582 | 3582 | Evan Gattis | 30 | gattiev01 | 2017 | HOU | AL | 3.019865428 | 1.255 | C, 1B | 8 | 1 | HOU | ATL | 2015 | 2018 | |
3621 | 3621 | Mike Minor | 29 | minormi01 | 2017 | KCR | AL | 2.876079599 | 2.535 | P | 12 | 1 | KCR | ATL | 2017 | 2017 | TEX |
3629 | 3629 | Peter Moylan | 38 | moylape01 | 2017 | KCR | AL | 2.002265854 | 0.735 | P | 5 | 1 | KCR | ATL | 2016 | 2017 | ATL |
3663 | 3663 | Andrelton Simmons | 27 | simmoan01 | 2017 | LAA | AL | 6.200594845 | 5.985 | SS | 27 | 1 | ANA | ATL | 2016 | 2019 | |
3697 | 3697 | Brandon Phillips | 36 | phillbr01 | 2017 | LAA | AL | 1.006278916 | -0.05 | 2B, 3B | 1 | 2 | ANA | ATL | 2017 | 2017 | BOS |
3724 | 3724 | Alex Wood | 26 | woodal02 | 2017 | LAD | NL | 4.354449303 | 2.865 | P | 15 | 1 | LAD | ATL | 2015 | 2018 | CIN |
3738 | 3738 | Luis Avilan | 27 | avilalu01 | 2017 | LAD | NL | 1.391036678 | 0.595 | P | 4 | 1 | LAD | ATL | 2015 | 2017 | CHW |
3806 | 3806 | Hunter Cervenka | 27 | cervehu01 | 2017 | MIA | NL | 0.119551826 | -0.255 | P | 0 | 1 | FLA | ATL | 2016 | 2017 | |
3864 | 3864 | Ervin Santana | 34 | santaer01 | 2017 | MIN | AL | 6.028787514 | 3.885 | P | 20 | 1 | MIN | ATL | 2015 | 2018 | CHW |
3884 | 3884 | Bartolo Colon | 44 | colonba01 | 2017 | MIN | AL | 2.270051544 | 0.145 | P | 4 | 2 | MIN | ATL | 2017 | 2017 | TEX |
3890 | 3890 | Jaime Garcia | 30 | garcija02 | 2017 | MIN | AL | 0.189170962 | 0.145 | P | 1 | 2 | MIN | ATL | 2017 | 2017 | NYY |
3990 | 3990 | Chasen Shreve | 26 | shrevch01 | 2017 | NYY | AL | 1.299738084 | 0.375 | P | 3 | 1 | NYY | ATL | 2015 | 2018 | STL |
4056 | 4056 | Ryan Lavarnway | 29 | lavarry01 | 2017 | OAK | AL | 0.123545797 | 0.04 | C | 0 | 1 | OAK | ATL | 2017 | 2017 | PIT |
4108 | 4108 | Pedro Beato | 30 | beatope01 | 2017 | PHI | NL | 0.015241181 | 0.015 | P | 0 | 1 | PHI | ATL | 2017 | 2017 | |
4154 | 4154 | Sean Rodriguez | 32 | rodrise01 | 2017 | PIT | NL | 1.057629451 | -0.295 | 3B, RF, 2B, SS, LF, CF, 1B | 1 | 2 | PIT | ATL | 2017 | 2018 | PHI |
4189 | 4189 | Ryan Buchter | 30 | buchtry01 | 2017 | SDP | NL | 1.317570856 | 0.315 | P | 3 | 1 | SDP | ATL | 2016 | 2017 | KCR |
4212 | 4212 | Christian Bethancourt | 25 | bethach01 | 2017 | SDP | NL | 0.059405512 | -0.295 | P, 2B | 0 | 1 | SDP | ATL | 2016 | 2017 | |
4260 | 4260 | Ryan Weber | 26 | weberry01 | 2017 | SEA | AL | 0.101457019 | 0.11 | P | 0 | 1 | SEA | ATL | 2017 | 2017 | TBD |
4267 | 4267 | Rob Whalen | 23 | whalero01 | 2017 | SEA | AL | 0.157339763 | -0.06 | P | 0 | 1 | SEA | ATL | 2017 | 2018 | |
4268 | 4268 | Shae Simmons | 26 | simmosh01 | 2017 | SEA | AL | 0.19398661 | -0.075 | P | 0 | 1 | SEA | ATL | 2017 | 2017 | |
4291 | 4291 | Cory Gearrin | 31 | gearrco01 | 2017 | SFG | NL | 1.956196781 | 1.335 | P | 7 | 1 | SFG | ATL | 2015 | 2018 | TEX |
4368 | 4368 | John Gant | 24 | gantjo01 | 2017 | STL | NL | 0.36357454 | -0.095 | P | 0 | 1 | STL | ATL | 2017 | 2019 | |
4390 | 4390 | Mallex Smith | 24 | smithma05 | 2017 | TBR | AL | 2.671675923 | 1.245 | CF, LF, RF | 7 | 1 | TBD | ATL | 2017 | 2018 | SEA |
4414 | 4414 | Chaz Roe | 30 | roech01 | 2017 | TBR | AL | 0.221399392 | 0.225 | P | 1 | 2 | TBD | ATL | 2017 | 2019 | |
4457 | 4457 | Dario Alvarez | 28 | alvarda01 | 2017 | TEX | AL | 0.558446347 | 0.165 | P | 1 | 1 | TEX | ATL | 2016 | 2017 | |
4542 | 4542 | Jason Grilli | 40 | grillja01 | 2017 | TOR | AL | 0.647143612 | -0.635 | P | 0 | 1 | TOR | ATL | 2016 | 2017 | TEX |
4606 | 4606 | Michael Bourn | 33 | bournmi01 | 2016 | ARI | NL | 3.503881201 | 0.06 | CF, LF, RF | 5 | 1 | ARI | ATL | 2016 | 2016 | BAL |
4608 | 4608 | Randall Delgado | 26 | delgara01 | 2016 | ARI | NL | 2.218276347 | 0.445 | P | 4 | 1 | ARI | ATL | 2013 | 2018 | |
4610 | 4610 | Phil Gosselin | 27 | gosseph01 | 2016 | ARI | NL | 2.348970638 | 0.375 | 2B, 3B, 1B, LF, RF | 4 | 1 | ARI | ATL | 2015 | 2016 | PIT |
4616 | 4616 | Shelby Miller | 25 | millesh01 | 2016 | ARI | NL | 2.780239689 | -0.245 | P, LF | 3 | 1 | ARI | ATL | 2016 | 2018 | TEX |
4740 | 4740 | Paul Janish | 33 | janispa01 | 2016 | BAL | AL | 0.33492823 | -0.06 | 3B, SS | 0 | 1 | BAL | ATL | 2015 | 2017 | |
4818 | 4818 | Tommy La Stella | 27 | lasteto01 | 2016 | CHC | NL | 1.651558551 | 0.57 | 3B, 2B | 4 | 1 | CHC | ATL | 2015 | 2018 | ANA |
4821 | 4821 | Trevor Cahill | 28 | cahiltr01 | 2016 | CHC | NL | 1.805521822 | 0.43 | P | 4 | 1 | CHC | ATL | 2015 | 2016 | SDP |
4984 | 4984 | Ross Detwiler | 30 | detwiro01 | 2016 | CLE | AL | 0.130932802 | -0.055341615 | P | 0 | 1 | CLE | ATL | 2016 | 2016 | OAK |
5028 | 5028 | David Hale | 28 | haleda02 | 2016 | COL | NL | 0.040296917 | -0.105 | P | 0 | 1 | COL | ATL | 2015 | 2016 | NYY |
5048 | 5048 | Cameron Maybin | 29 | maybica01 | 2016 | DET | AL | 3.715268676 | 2.153291925 | CF | 12 | 1 | DET | ATL | 2016 | 2016 | ANA |
5065 | 5065 | Erick Aybar | 32 | aybarer01 | 2016 | DET | AL | 0.864678899 | 0.206273292 | SS, 3B, 2B | 2 | 2 | DET | ATL | 2016 | 2016 | SDP |
5088 | 5088 | Evan Gattis | 29 | gattiev01 | 2016 | HOU | AL | 4.682413849 | 3.015 | C | 15 | 1 | HOU | ATL | 2015 | 2018 |
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 );