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,971 rows where next_franch = "ATL"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34 | 34 | John Ryan Murphy | 28 | murphjr01 | 2019 | ARI | NL | 0.680265171 | -0.030566038 | C, P | 1 | 1 | ARI | MIN | 2017 | 2019 | ATL |
457 | 457 | Shane Greene | 30 | greensh02 | 2019 | DET | AL | 1.591633814 | 1.245759494 | P | 5 | 1 | DET | NYY | 2015 | 2019 | ATL |
560 | 560 | Billy Hamilton | 28 | hamilbi02 | 2019 | KCR | AL | 2.968618896 | 0.412641509 | CF | 5 | 1 | KCR | CIN | 2019 | 2019 | ATL |
873 | 873 | Adeiny Hechavarria | 30 | hechaad01 | 2019 | NYM | NL | 1.499657534 | -0.152830189 | 2B, SS, 3B | 2 | 1 | NYM | NYY | 2019 | 2019 | ATL |
1090 | 1090 | Francisco Cervelli | 33 | cervefr01 | 2019 | PIT | NL | 1.228305785 | -0.183396226 | C, 1B | 1 | 1 | PIT | NYY | 2015 | 2019 | ATL |
1235 | 1235 | Anthony Swarzak | 33 | swarzan01 | 2019 | SEA | AL | 0.526778842 | -0.478867925 | P | 0 | 1 | SEA | NYM | 2019 | 2019 | ATL |
1257 | 1257 | Mark Melancon | 34 | melanma01 | 2019 | SFG | NL | 1.316289401 | 0.54509434 | P | 4 | 1 | SFG | WSN | 2017 | 2019 | ATL |
1418 | 1418 | Chris Martin | 33 | martich02 | 2019 | TEX | AL | 1.368282155 | 1.018867925 | P | 5 | 1 | TEX | NYY | 2018 | 2019 | ATL |
1585 | 1585 | John Ryan Murphy | 27 | murphjr01 | 2018 | ARI | NL | 2.220429185 | 0.19 | C | 4 | 1 | ARI | MIN | 2017 | 2019 | ATL |
1673 | 1673 | Kevin Gausman | 27 | gausmke01 | 2018 | BAL | AL | 3.564477325 | 1.84 | P | 9 | 1 | BAL | 2013 | 2018 | ATL | |
1695 | 1695 | Darren O'Day | 35 | odayda01 | 2018 | BAL | AL | 0.700966733 | 0.37 | P | 2 | 1 | BAL | TEX | 2012 | 2018 | ATL |
1697 | 1697 | Brad Brach | 32 | brachbr01 | 2018 | BAL | AL | 1.372880239 | 0.165 | P | 2 | 1 | BAL | SDP | 2014 | 2018 | ATL |
1882 | 1882 | Adam Duvall | 29 | duvalad01 | 2018 | CIN | NL | 3.641608688 | 1.025 | LF, 1B, RF, 3B | 8 | 1 | CIN | SFG | 2015 | 2018 | ATL |
1945 | 1945 | Josh Donaldson | 32 | donaljo02 | 2018 | CLE | AL | 0.554670067 | 0.595 | 3B, 1B | 2 | 2 | CLE | TOR | 2018 | 2018 | ATL |
1974 | 1974 | Josh Tomlin | 33 | tomlijo01 | 2018 | CLE | AL | 1.691947377 | -1.155 | P | 0 | 1 | CLE | 2010 | 2018 | ATL | |
2038 | 2038 | Shane Greene | 29 | greensh02 | 2018 | DET | AL | 2.49223397 | -0.31 | P | 3 | 1 | DET | NYY | 2015 | 2019 | ATL |
2069 | 2069 | Dallas Keuchel | 30 | keuchda01 | 2018 | HOU | AL | 5.627913996 | 2.94 | P | 17 | 1 | HOU | 2012 | 2018 | ATL | |
2088 | 2088 | Brian McCann | 34 | mccanbr01 | 2018 | HOU | AL | 2.046724391 | 0.53 | C | 4 | 1 | HOU | NYY | 2017 | 2018 | ATL |
2124 | 2124 | Lucas Duda | 32 | dudalu01 | 2018 | KCR | AL | 3.312365502 | 0.105 | 1B | 4 | 1 | KCR | TBD | 2018 | 2018 | ATL |
2181 | 2181 | Rene Rivera | 34 | riverre01 | 2018 | LAA | AL | 0.829116004 | 0.435 | C, 1B | 2 | 1 | ANA | CHC | 2018 | 2018 | ATL |
2296 | 2296 | Rafael Ortega | 27 | ortegra01 | 2018 | MIA | NL | 1.43 | -0.437701863 | RF, LF | 1 | 1 | FLA | ANA | 2018 | 2018 | ATL |
2447 | 2447 | Jerry Blevins | 34 | blevije01 | 2018 | NYM | NL | 1.303949018 | 0.03 | P | 2 | 1 | NYM | WSN | 2015 | 2018 | ATL |
2552 | 2552 | Matthew Joyce | 33 | joycema01 | 2018 | OAK | AL | 2.288739172 | 0.125 | LF, RF, CF | 4 | 1 | OAK | PIT | 2017 | 2018 | ATL |
2636 | 2636 | Francisco Cervelli | 32 | cervefr01 | 2018 | PIT | NL | 4.07442184 | 2.636273292 | C, 1B | 14 | 1 | PIT | NYY | 2015 | 2019 | ATL |
2805 | 2805 | Mark Melancon | 33 | melanma01 | 2018 | SFG | NL | 1.416504426 | 0.175 | P | 3 | 1 | SFG | WSN | 2017 | 2019 | ATL |
2918 | 2918 | Jonny Venters | 33 | ventejo01 | 2018 | TBR | AL | 0.436665598 | 0.135 | P | 1 | 1 | TBD | ATL | 2018 | 2018 | ATL |
2952 | 2952 | Chris Martin | 32 | martich02 | 2018 | TEX | AL | 1.393245953 | 0.605 | P | 4 | 1 | TEX | NYY | 2018 | 2019 | ATL |
3137 | 3137 | John Ryan Murphy | 26 | murphjr01 | 2017 | ARI | NL | 0.069118148 | -0.09 | C | 0 | 1 | ARI | MIN | 2017 | 2019 | ATL |
3196 | 3196 | Kevin Gausman | 26 | gausmke01 | 2017 | BAL | AL | 5.391627526 | 2.31 | P | 15 | 1 | BAL | 2013 | 2018 | ATL | |
3202 | 3202 | Brad Brach | 31 | brachbr01 | 2017 | BAL | AL | 2.570036434 | 1.215 | P | 8 | 1 | BAL | SDP | 2014 | 2018 | ATL |
3206 | 3206 | Darren O'Day | 34 | odayda01 | 2017 | BAL | AL | 2.020733652 | 0.925 | P | 6 | 1 | BAL | TEX | 2012 | 2018 | ATL |
3231 | 3231 | Ryan Flaherty | 30 | flahery01 | 2017 | BAL | AL | 0.407383208 | -0.115 | 2B, 3B, SS, LF, RF | 0 | 1 | BAL | 2012 | 2017 | ATL | |
3393 | 3393 | Adam Duvall | 28 | duvalad01 | 2017 | CIN | NL | 6.376550552 | 1.66 | LF, 1B | 13 | 1 | CIN | SFG | 2015 | 2018 | ATL |
3446 | 3446 | Josh Tomlin | 32 | tomlijo01 | 2017 | CLE | AL | 4.026964881 | 1.51 | P | 10 | 1 | CLE | 2010 | 2018 | ATL | |
3509 | 3509 | Shane Carle | 25 | carlesh01 | 2017 | COL | NL | 0.062215596 | -0.01 | P | 0 | 1 | COL | 2017 | 2017 | ATL | |
3526 | 3526 | Shane Greene | 28 | greensh02 | 2017 | DET | AL | 2.536795757 | 1.53 | P | 8 | 1 | DET | NYY | 2015 | 2019 | ATL |
3539 | 3539 | Anibal Sanchez | 33 | sanchan01 | 2017 | DET | AL | 2.754277399 | -0.165 | P | 3 | 1 | DET | FLA | 2012 | 2017 | ATL |
3574 | 3574 | Dallas Keuchel | 29 | keuchda01 | 2017 | HOU | AL | 4.103242235 | 3.21 | P | 15 | 1 | HOU | 2012 | 2018 | ATL | |
3578 | 3578 | Brian McCann | 33 | mccanbr01 | 2017 | HOU | AL | 3.707465556 | 1.795 | C | 11 | 1 | HOU | NYY | 2017 | 2018 | ATL |
3629 | 3629 | Peter Moylan | 38 | moylape01 | 2017 | KCR | AL | 2.002265854 | 0.735 | P | 5 | 1 | KCR | ATL | 2016 | 2017 | ATL |
3708 | 3708 | Carlos Perez | 26 | perezca02 | 2017 | LAA | AL | 0.201255783 | -0.145 | C | 0 | 1 | ANA | 2015 | 2017 | ATL | |
3733 | 3733 | Brandon McCarthy | 33 | mccarbr01 | 2017 | LAD | NL | 2.537345582 | 1.385 | P | 8 | 1 | LAD | NYY | 2015 | 2017 | ATL |
3750 | 3750 | Charlie Culberson | 28 | culbech01 | 2017 | LAD | NL | 0.148362892 | 0.075 | SS, 2B, 3B | 0 | 1 | LAD | COL | 2016 | 2017 | ATL |
3762 | 3762 | Grant Dayton | 29 | daytogr01 | 2017 | LAD | NL | 0.644466521 | -0.225 | P | 0 | 1 | LAD | 2016 | 2017 | ATL | |
3766 | 3766 | Josh Ravin | 29 | ravinjo01 | 2017 | LAD | NL | 0.481431686 | -0.285 | P | 0 | 1 | LAD | 2015 | 2017 | ATL | |
3891 | 3891 | Danny Santana | 26 | santada01 | 2017 | MIN | AL | 0.241782908 | 0.085 | LF, 2B, RF, 3B, CF | 1 | 1 | MIN | 2014 | 2017 | ATL | |
3927 | 3927 | Jerry Blevins | 33 | blevije01 | 2017 | NYM | NL | 1.816968608 | 1.14 | P | 6 | 1 | NYM | WSN | 2015 | 2018 | ATL |
4020 | 4020 | Matthew Joyce | 32 | joycema01 | 2017 | OAK | AL | 5.169916435 | 2.25 | RF, LF, CF | 14 | 1 | OAK | PIT | 2017 | 2018 | ATL |
4137 | 4137 | Francisco Cervelli | 31 | cervefr01 | 2017 | PIT | NL | 3.033201445 | 0.525 | C | 6 | 1 | PIT | NYY | 2015 | 2019 | ATL |
4167 | 4167 | Chris Stewart | 35 | stewach01 | 2017 | PIT | NL | 1.436779632 | -0.7 | C | 0 | 1 | PIT | NYY | 2014 | 2017 | ATL |
4305 | 4305 | Mark Melancon | 32 | melanma01 | 2017 | SFG | NL | 1.162628382 | 0.275 | P | 2 | 1 | SFG | WSN | 2017 | 2019 | ATL |
4365 | 4365 | Matt Adams | 28 | adamsma01 | 2017 | STL | NL | 0.521990151 | -0.08 | 1B, LF | 0 | 1 | STL | 2012 | 2017 | ATL | |
4377 | 4377 | Miguel Socolovich | 30 | socolmi01 | 2017 | STL | NL | 0.397095597 | -0.38 | P | 0 | 1 | STL | CHC | 2015 | 2017 | ATL |
4399 | 4399 | Peter Bourjos | 30 | bourjpe01 | 2017 | TBR | AL | 1.923227703 | 0.43 | LF, CF, RF | 4 | 1 | TBD | PHI | 2017 | 2017 | ATL |
4404 | 4404 | Chase Whitley | 28 | whitlch01 | 2017 | TBR | AL | 1.531597204 | 0.32 | P | 3 | 1 | TBD | NYY | 2016 | 2017 | ATL |
4494 | 4494 | Jose Bautista | 36 | bautijo02 | 2017 | TOR | AL | 6.490701468 | -0.91 | RF, 3B, 1B | 7 | 1 | TOR | PIT | 2008 | 2017 | ATL |
4623 | 4623 | Josh Collmenter | 30 | collmjo01 | 2016 | ARI | NL | 0.43818889 | -0.02 | P | 1 | 1 | ARI | 2011 | 2016 | ATL | |
4703 | 4703 | Kevin Gausman | 25 | gausmke01 | 2016 | BAL | AL | 5.198277926 | 3.6 | P | 19 | 1 | BAL | 2013 | 2018 | ATL | |
4712 | 4712 | Brad Brach | 30 | brachbr01 | 2016 | BAL | AL | 2.750172834 | 2.08 | P | 10 | 1 | BAL | SDP | 2014 | 2018 | ATL |
4722 | 4722 | Darren O'Day | 33 | odayda01 | 2016 | BAL | AL | 1.127145378 | 0.305 | P | 3 | 1 | BAL | TEX | 2012 | 2018 | ATL |
4723 | 4723 | Ryan Flaherty | 29 | flahery01 | 2016 | BAL | AL | 1.684210526 | 0.165 | 3B, SS, 1B, RF, LF, 2B, P | 3 | 1 | BAL | 2012 | 2017 | ATL | |
4737 | 4737 | Chaz Roe | 29 | roech01 | 2016 | BAL | AL | 0.269215231 | 0.015 | P | 0 | 1 | BAL | NYY | 2015 | 2016 | ATL |
4895 | 4895 | Adam Duvall | 27 | duvalad01 | 2016 | CIN | NL | 6.114791053 | 2.79 | LF, RF, 1B, 3B | 18 | 1 | CIN | SFG | 2015 | 2018 | ATL |
4902 | 4902 | Brandon Phillips | 35 | phillbr01 | 2016 | CIN | NL | 5.873417722 | 0.895 | 2B | 12 | 1 | CIN | CLE | 2006 | 2016 | ATL |
4955 | 4955 | Josh Tomlin | 31 | tomlijo01 | 2016 | CLE | AL | 4.881923039 | 1.262795031 | P | 11 | 1 | CLE | 2010 | 2018 | ATL | |
5031 | 5031 | Jason Motte | 34 | motteja01 | 2016 | COL | NL | 0.69889004 | -0.17 | P | 0 | 1 | COL | CHC | 2016 | 2016 | ATL |
5058 | 5058 | Anibal Sanchez | 32 | sanchan01 | 2016 | DET | AL | 4.472887447 | -0.070434783 | P | 6 | 1 | DET | FLA | 2012 | 2017 | ATL |
5062 | 5062 | Shane Greene | 27 | greensh02 | 2016 | DET | AL | 2.197700195 | 0.407515528 | P | 4 | 1 | DET | NYY | 2015 | 2019 | ATL |
5094 | 5094 | Dallas Keuchel | 28 | keuchda01 | 2016 | HOU | AL | 4.574929292 | 1.39 | P | 10 | 1 | HOU | 2012 | 2018 | ATL | |
5127 | 5127 | Preston Tucker | 25 | tuckepr01 | 2016 | HOU | AL | 1.351237664 | -1.01 | LF, RF | 0 | 1 | HOU | 2015 | 2016 | ATL | |
5151 | 5151 | Peter Moylan | 37 | moylape01 | 2016 | KCR | AL | 1.31166192 | 0.375 | P | 3 | 1 | KCR | ATL | 2016 | 2017 | ATL |
5188 | 5188 | Carlos Perez | 25 | perezca02 | 2016 | LAA | AL | 2.803654485 | 0.11 | C, 1B | 4 | 1 | ANA | 2015 | 2017 | ATL | |
5244 | 5244 | Grant Dayton | 28 | daytogr01 | 2016 | LAD | NL | 0.853012628 | 0.555 | P | 3 | 1 | LAD | 2016 | 2017 | ATL | |
5248 | 5248 | Charlie Culberson | 27 | culbech01 | 2016 | LAD | NL | 0.674649333 | 0.28 | SS, 2B, 3B, LF | 2 | 1 | LAD | COL | 2016 | 2017 | ATL |
5249 | 5249 | Brandon McCarthy | 32 | mccarbr01 | 2016 | LAD | NL | 1.159011467 | 0.205 | P | 2 | 1 | LAD | NYY | 2015 | 2017 | ATL |
5251 | 5251 | Josh Ravin | 28 | ravinjo01 | 2016 | LAD | NL | 0.195347916 | 0.2 | P | 1 | 1 | LAD | 2015 | 2017 | ATL | |
5265 | 5265 | Micah Johnson | 25 | johnsmi04 | 2016 | LAD | NL | 0.059527882 | -0.085 | 2B, LF | 0 | 1 | LAD | CHW | 2016 | 2016 | ATL |
5363 | 5363 | Michael Reed | 23 | reedmi02 | 2016 | MIL | NL | 0.242002782 | -0.005 | CF, LF | 0 | 1 | MIL | 2015 | 2016 | ATL | |
5372 | 5372 | Sam Freeman | 29 | freemsa01 | 2016 | MIL | NL | 0.1235814 | -0.26 | P | 0 | 1 | MIL | TEX | 2016 | 2016 | ATL |
5397 | 5397 | Kurt Suzuki | 32 | suzukku01 | 2016 | MIN | AL | 3.479813415 | 0.15 | C | 4 | 1 | MIN | OAK | 2014 | 2016 | ATL |
5429 | 5429 | Danny Santana | 25 | santada01 | 2016 | MIN | AL | 2.313656104 | -1.065 | CF, LF, RF, 2B, SS, 3B | 0 | 1 | MIN | 2014 | 2017 | ATL | |
5436 | 5436 | Bartolo Colon | 43 | colonba01 | 2016 | NYM | NL | 5.329546675 | 2.49 | P | 15 | 1 | NYM | OAK | 2014 | 2016 | ATL |
5450 | 5450 | Jerry Blevins | 32 | blevije01 | 2016 | NYM | NL | 1.530091661 | 0.81 | P | 4 | 1 | NYM | WSN | 2015 | 2018 | ATL |
5632 | 5632 | Francisco Cervelli | 30 | cervefr01 | 2016 | PIT | NL | 3.837373737 | 2.16 | C, 1B | 12 | 1 | PIT | NYY | 2015 | 2019 | ATL |
5638 | 5638 | Sean Rodriguez | 31 | rodrise01 | 2016 | PIT | NL | 3.339393939 | 1.775 | 1B, 2B, SS, RF, 3B, LF, CF | 10 | 1 | PIT | TBD | 2015 | 2016 | ATL |
5666 | 5666 | Chris Stewart | 34 | stewach01 | 2016 | PIT | NL | 1.103367003 | -0.145 | C, 1B | 1 | 1 | PIT | NYY | 2014 | 2017 | ATL |
5697 | 5697 | Matt Kemp | 31 | kempma01 | 2016 | SDP | NL | 4.39254964 | 0.29 | RF, LF | 7 | 1 | SDP | LAD | 2015 | 2016 | ATL |
5854 | 5854 | Jaime Garcia | 29 | garcija02 | 2016 | STL | NL | 4.751700427 | 0.955 | P | 9 | 1 | STL | 2008 | 2016 | ATL | |
5859 | 5859 | Matt Adams | 27 | adamsma01 | 2016 | STL | NL | 3.216211633 | 0.565 | 1B | 6 | 1 | STL | 2012 | 2017 | ATL | |
5871 | 5871 | Miguel Socolovich | 29 | socolmi01 | 2016 | STL | NL | 0.372996761 | 0.275 | P | 1 | 1 | STL | CHC | 2015 | 2017 | ATL |
5910 | 5910 | Chase Whitley | 27 | whitlch01 | 2016 | TBR | AL | 0.448478163 | 0.14 | P | 1 | 1 | TBD | NYY | 2016 | 2017 | ATL |
5979 | 5979 | Luke Jackson | 24 | jackslu01 | 2016 | TEX | AL | 0.339793528 | -0.59 | P | 0 | 1 | TEX | 2015 | 2016 | ATL | |
5994 | 5994 | Jose Bautista | 35 | bautijo02 | 2016 | TOR | AL | 4.836451613 | 1.295 | RF, 1B | 10 | 1 | TOR | PIT | 2008 | 2017 | ATL |
5996 | 5996 | R.A. Dickey | 41 | dicker.01 | 2016 | TOR | AL | 4.766068128 | 0.61 | P | 8 | 1 | TOR | NYM | 2013 | 2016 | ATL |
6076 | 6076 | Ender Inciarte | 24 | inciaen01 | 2015 | ARI | NL | 5.471330082 | 3.79 | RF, LF, CF | 18 | 1 | ARI | 2014 | 2015 | ATL | |
6088 | 6088 | Josh Collmenter | 29 | collmjo01 | 2015 | ARI | NL | 2.793215019 | 0.865 | P | 6 | 1 | ARI | 2011 | 2016 | ATL | |
6101 | 6101 | Jhoulys Chacin | 27 | chacijh01 | 2015 | ARI | NL | 0.751090616 | 0.215 | P | 2 | 1 | ARI | COL | 2015 | 2015 | ATL |
6191 | 6191 | Darren O'Day | 32 | odayda01 | 2015 | BAL | AL | 2.422613266 | 2.28 | P | 10 | 1 | BAL | TEX | 2012 | 2018 | ATL |
6193 | 6193 | Brad Brach | 29 | brachbr01 | 2015 | BAL | AL | 2.602778215 | 1.435 | P | 8 | 1 | BAL | SDP | 2014 | 2018 | ATL |
6194 | 6194 | Kevin Gausman | 24 | gausmke01 | 2015 | BAL | AL | 3.136914897 | 1.345 | P | 8 | 1 | BAL | 2013 | 2018 | ATL |
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 );