mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
622 rows where prev_franch = "COL"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
91 | 91 | Shane Carle | 27 | carlesh01 | 2019 | ATL | NL | 0.22746425 | -0.392264151 | P | 0 | 1 | ATL | COL | 2018 | 2019 | |
107 | 107 | Miguel Castro | 24 | castrmi01 | 2019 | BAL | AL | 2.240454464 | 0.499245283 | P | 4 | 1 | BAL | COL | 2017 | 2019 | |
216 | 216 | Tyler Chatwood | 29 | chatwty01 | 2019 | CHC | NL | 2.483937943 | 1.110566038 | P | 6 | 1 | CHC | COL | 2018 | 2019 | |
383 | 383 | Carlos Gonzalez | 33 | gonzaca01 | 2019 | CLE | AL | 1.130623126 | -0.203773585 | LF, RF | 1 | 1 | CLE | COL | 2019 | 2019 | CHC |
523 | 523 | Collin McHugh | 32 | mchugco01 | 2019 | HOU | AL | 1.911383032 | 0.473773585 | P | 4 | 1 | HOU | COL | 2014 | 2019 | |
887 | 887 | Brooks Pounders | 28 | poundbr01 | 2019 | NYM | NL | 0.186183265 | -0.015283019 | P | 0 | 1 | NYM | COL | 2019 | 2019 | |
905 | 905 | DJ LeMahieu | 30 | lemahdj01 | 2019 | NYY | AL | 6.116260029 | 5.853396226 | 2B, 3B, 1B | 27 | 1 | NYY | COL | 2019 | 2019 | |
913 | 913 | Mike Tauchman | 28 | tauchmi01 | 2019 | NYY | AL | 2.811200262 | 3.168679245 | LF, RF, CF | 14 | 1 | NYY | COL | 2019 | 2019 | |
917 | 917 | Adam Ottavino | 33 | ottavad01 | 2019 | NYY | AL | 2.374839913 | 1.788113208 | P | 9 | 1 | NYY | COL | 2019 | 2019 | |
1054 | 1054 | Pat Neshek | 38 | neshepa01 | 2019 | PHI | NL | 0.561742999 | -0.208867925 | P | 0 | 1 | PHI | COL | 2018 | 2019 | |
1173 | 1173 | Tom Murphy | 28 | murphto04 | 2019 | SEA | AL | 2.610286845 | 2.817169811 | C, P, LF | 12 | 1 | SEA | COL | 2019 | 2019 | |
1217 | 1217 | Matt Carasiti | 27 | carasma01 | 2019 | SEA | AL | 0.253367775 | -0.061132075 | P | 0 | 1 | SEA | COL | 2019 | 2019 | |
1268 | 1268 | Gerardo Parra | 32 | parrage01 | 2019 | SFG | NL | 0.975212342 | -0.045849057 | RF, LF, 1B, CF, 2B, 3B, P | 2 | 1 | SFG | COL | 2019 | 2019 | WSN |
1272 | 1272 | Cristhian Adames | 27 | adamecr01 | 2019 | SFG | NL | 0.221182181 | 0.13245283 | 2B, 3B | 1 | 1 | SFG | COL | 2019 | 2019 | |
1547 | 1547 | Justin Miller | 32 | milleju02 | 2019 | WSN | NL | 0.485171227 | -0.050943396 | P | 0 | 1 | WSN | COL | 2018 | 2019 | |
1573 | 1573 | Daniel Descalso | 31 | descada01 | 2018 | ARI | NL | 4.211845494 | 1.32 | 2B, 3B, 1B, LF, P | 10 | 1 | ARI | COL | 2017 | 2018 | CHC |
1610 | 1610 | Jorge De La Rosa | 37 | rosajo01 | 2018 | ARI | NL | 1.02933483 | -0.415 | P | 0 | 1 | ARI | COL | 2017 | 2018 | CHC |
1630 | 1630 | Shane Carle | 26 | carlesh01 | 2018 | ATL | NL | 2.244585527 | 0.705 | P | 5 | 1 | ATL | COL | 2018 | 2019 | |
1650 | 1650 | Rex Brothers | 30 | brothre01 | 2018 | ATL | NL | 0.0 | 0.0 | P | 0 | 1 | ATL | COL | 2017 | 2018 | |
1684 | 1684 | Miguel Castro | 23 | castrmi01 | 2018 | BAL | AL | 2.614431697 | 0.55 | P | 5 | 1 | BAL | COL | 2017 | 2019 | |
1794 | 1794 | Tyler Chatwood | 28 | chatwty01 | 2018 | CHC | NL | 2.585534355 | -0.16398773 | P | 4 | 1 | CHC | COL | 2018 | 2019 | |
1805 | 1805 | Eddie Butler | 27 | butleed01 | 2018 | CHC | NL | 0.397323533 | 0.019877301 | P | 1 | 1 | CHC | COL | 2017 | 2018 | TEX |
1960 | 1960 | Brandon Barnes | 32 | barnebr02 | 2018 | CLE | AL | 0.194134523 | 0.055 | RF, CF, LF, 2B | 0 | 1 | CLE | COL | 2018 | 2018 | |
2078 | 2078 | Collin McHugh | 31 | mchugco01 | 2018 | HOU | AL | 2.094817319 | 1.695 | P | 8 | 1 | HOU | COL | 2014 | 2019 | |
2141 | 2141 | Jerry Vasto | 26 | vastoje01 | 2018 | KCR | AL | 0.136000579 | -0.055 | P | 0 | 2 | KCR | COL | 2018 | 2018 | |
2256 | 2256 | Zac Rosscup | 30 | rosscza01 | 2018 | LAD | NL | 0.282495489 | 0.00993865 | P | 0 | 1 | LAD | COL | 2018 | 2018 | SEA |
2480 | 2480 | Jose Reyes | 35 | reyesjo01 | 2018 | NYM | NL | 2.491101985 | -1.035 | 3B, SS, 2B, P | 0 | 1 | NYM | COL | 2016 | 2018 | |
2512 | 2512 | David Hale | 30 | haleda02 | 2018 | NYY | AL | 0.23253705 | 0.165 | P | 1 | 1 | NYY | COL | 2018 | 2018 | MIN |
2547 | 2547 | Jonathan Lucroy | 32 | lucrojo01 | 2018 | OAK | AL | 4.223933269 | 0.005 | C | 6 | 1 | OAK | COL | 2018 | 2018 | ANA |
2602 | 2602 | Pat Neshek | 37 | neshepa01 | 2018 | PHI | NL | 0.871226256 | 0.555 | P | 3 | 1 | PHI | COL | 2018 | 2019 | |
2702 | 2702 | Jordan Lyles | 27 | lylesjo01 | 2018 | SDP | NL | 1.738388153 | 0.16 | P | 3 | 1 | SDP | COL | 2017 | 2018 | MIL |
2773 | 2773 | Christian Bergman | 30 | bergmch01 | 2018 | SEA | AL | 0.372135232 | -0.07 | P | 0 | 1 | SEA | COL | 2017 | 2018 | |
2803 | 2803 | Nick Hundley | 34 | hundlni01 | 2018 | SFG | NL | 3.050525953 | -0.255 | C | 4 | 1 | SFG | COL | 2017 | 2018 | OAK |
2875 | 2875 | Greg Holland | 32 | hollagr01 | 2018 | STL | NL | 0.659093102 | -0.725 | P | 0 | 1 | STL | COL | 2018 | 2018 | WSN |
3065 | 3065 | Justin Miller | 31 | milleju02 | 2018 | WSN | NL | 1.682554113 | 0.435 | P | 3 | 1 | WSN | COL | 2018 | 2019 | |
3067 | 3067 | Mark Reynolds | 34 | reynoma01 | 2018 | WSN | NL | 2.291911888 | -0.1 | 1B, 3B, 2B, CF, P, RF | 3 | 1 | WSN | COL | 2018 | 2018 | COL |
3114 | 3114 | Daniel Descalso | 30 | descada01 | 2017 | ARI | NL | 3.929860402 | 0.02 | 2B, LF, 1B, 3B, P, SS | 6 | 1 | ARI | COL | 2017 | 2018 | CHC |
3119 | 3119 | Jorge De La Rosa | 36 | rosajo01 | 2017 | ARI | NL | 1.687754684 | 0.315 | P | 3 | 1 | ARI | COL | 2017 | 2018 | CHC |
3167 | 3167 | Jason Motte | 35 | motteja01 | 2017 | ATL | NL | 1.167161409 | 0.17 | P | 2 | 1 | ATL | COL | 2017 | 2017 | |
3174 | 3174 | Rex Brothers | 29 | brothre01 | 2017 | ATL | NL | 0.650345431 | -0.11 | P | 1 | 1 | ATL | COL | 2017 | 2018 | |
3211 | 3211 | Miguel Castro | 22 | castrmi01 | 2017 | BAL | AL | 1.997483283 | 0.405 | P | 4 | 1 | BAL | COL | 2017 | 2019 | |
3286 | 3286 | Kyle Kendrick | 32 | kendrky01 | 2017 | BOS | AL | 0.222730665 | -0.21 | P | 0 | 1 | BOS | COL | 2017 | 2017 | |
3288 | 3288 | Josh Rutledge | 28 | rutlejo01 | 2017 | BOS | AL | 1.083768804 | -0.45 | 3B, 2B, 1B | 0 | 1 | BOS | COL | 2015 | 2017 | |
3312 | 3312 | Eddie Butler | 26 | butleed01 | 2017 | CHC | NL | 1.433314757 | 0.645 | P | 4 | 1 | CHC | COL | 2017 | 2018 | TEX |
3351 | 3351 | Tommy Kahnle | 27 | kahnlto01 | 2017 | CHW | AL | 1.296779511 | 1.165 | P | 5 | 1 | CHW | COL | 2016 | 2017 | NYY |
3467 | 3467 | Boone Logan | 32 | loganbo02 | 2017 | CLE | AL | 0.583724344 | 0.17 | P | 1 | 1 | CLE | COL | 2017 | 2017 | MIL |
3584 | 3584 | Collin McHugh | 30 | mchugco01 | 2017 | HOU | AL | 1.793558568 | 1.18 | P | 6 | 1 | HOU | COL | 2014 | 2019 | |
3702 | 3702 | Jason Gurka | 29 | gurkaja01 | 2017 | LAA | AL | 0.020147241 | 0.035 | P | 0 | 1 | ANA | COL | 2017 | 2017 | |
3750 | 3750 | Charlie Culberson | 28 | culbech01 | 2017 | LAD | NL | 0.148362892 | 0.075 | SS, 2B, 3B | 0 | 1 | LAD | COL | 2016 | 2017 | ATL |
3920 | 3920 | Jose Reyes | 34 | reyesjo01 | 2017 | NYM | NL | 5.566809239 | 0.795 | SS, 3B, 2B, CF, LF | 10 | 1 | NYM | COL | 2016 | 2018 | |
4048 | 4048 | Dustin Garneau | 29 | garnedu01 | 2017 | OAK | AL | 0.494183189 | 0.17 | C | 1 | 2 | OAK | COL | 2017 | 2017 | CHW |
4051 | 4051 | Simon Castro | 29 | castrsi01 | 2017 | OAK | AL | 0.986192853 | -0.06 | P | 1 | 1 | OAK | COL | 2017 | 2017 | |
4065 | 4065 | John Axford | 34 | axforjo01 | 2017 | OAK | AL | 0.543646852 | -0.295 | P | 0 | 1 | OAK | COL | 2016 | 2017 | TOR |
4211 | 4211 | Jordan Lyles | 26 | lylesjo01 | 2017 | SDP | NL | 0.651239868 | -0.255 | P | 0 | 2 | SDP | COL | 2017 | 2018 | MIL |
4248 | 4248 | Christian Bergman | 29 | bergmch01 | 2017 | SEA | AL | 1.558107554 | -0.045 | P | 2 | 1 | SEA | COL | 2017 | 2018 | |
4299 | 4299 | Nick Hundley | 33 | hundlni01 | 2017 | SFG | NL | 3.020106548 | 0.17 | C | 4 | 1 | SFG | COL | 2017 | 2018 | OAK |
4384 | 4384 | Corey Dickerson | 28 | dickeco01 | 2017 | TBR | AL | 5.959163672 | 2.565 | LF | 15 | 1 | TBD | COL | 2016 | 2017 | PIT |
4504 | 4504 | Troy Tulowitzki | 32 | tulowtr01 | 2017 | TOR | AL | 2.460032626 | 0.15 | SS | 4 | 1 | TOR | COL | 2015 | 2017 | NYY |
4574 | 4574 | Ryan Raburn | 36 | raburry01 | 2017 | WSN | NL | 0.684102564 | -0.03 | LF | 1 | 1 | WSN | COL | 2017 | 2017 | |
4777 | 4777 | Josh Rutledge | 27 | rutlejo01 | 2016 | BOS | AL | 0.516129032 | 0.295 | 3B, 2B, SS | 1 | 1 | BOS | COL | 2015 | 2017 | |
4863 | 4863 | Justin Morneau | 35 | morneju01 | 2016 | CHW | AL | 2.069733181 | 0.165 | 3 | 1 | CHW | COL | 2016 | 2016 | ||
4865 | 4865 | Tommy Kahnle | 26 | kahnlto01 | 2016 | CHW | AL | 0.772880496 | 0.345 | P | 2 | 1 | CHW | COL | 2016 | 2017 | NYY |
5090 | 5090 | Collin McHugh | 29 | mchugco01 | 2016 | HOU | AL | 5.110339293 | 1.745 | P | 12 | 1 | HOU | COL | 2014 | 2019 | |
5200 | 5200 | Rafael Ortega | 25 | ortegra01 | 2016 | LAA | AL | 1.946179402 | -0.365 | LF, CF, RF | 2 | 1 | ANA | COL | 2016 | 2016 | FLA |
5248 | 5248 | Charlie Culberson | 27 | culbech01 | 2016 | LAD | NL | 0.674649333 | 0.28 | SS, 2B, 3B, LF | 2 | 1 | LAD | COL | 2016 | 2017 | ATL |
5263 | 5263 | Chin-hui Tsao | 35 | tsaoch01 | 2016 | LAD | NL | 0.053245185 | -0.06 | P | 0 | 1 | LAD | COL | 2007 | 2016 | |
5276 | 5276 | Brett Anderson | 28 | anderbr04 | 2016 | LAD | NL | 0.311546245 | -0.53 | P | 0 | 1 | LAD | COL | 2015 | 2016 | CHC |
5440 | 5440 | Jose Reyes | 33 | reyesjo01 | 2016 | NYM | NL | 2.793853591 | 1.03 | 3B, SS | 7 | 1 | NYM | COL | 2016 | 2018 | |
5544 | 5544 | John Axford | 33 | axforjo01 | 2016 | OAK | AL | 2.246249684 | 0.59 | P | 5 | 1 | OAK | COL | 2016 | 2017 | TOR |
5569 | 5569 | Matt McBride | 31 | mcbrima02 | 2016 | OAK | AL | 0.425475158 | -0.21 | C, 1B, RF | 0 | 1 | OAK | COL | 2016 | 2016 | |
5663 | 5663 | Rob Scahill | 29 | scahiro01 | 2016 | PIT | NL | 0.381705147 | 0.01 | P | 1 | 1 | PIT | COL | 2015 | 2016 | MIL |
5693 | 5693 | Christian Friedrich | 28 | friedch01 | 2016 | SDP | NL | 3.613147024 | 0.885 | P | 8 | 1 | SDP | COL | 2016 | 2016 | |
5875 | 5875 | Michael McKenry | 31 | mckenmi01 | 2016 | STL | NL | 0.019671019 | -0.025 | 0 | 1 | STL | COL | 2016 | 2016 | ||
5888 | 5888 | Corey Dickerson | 27 | dickeco01 | 2016 | TBR | AL | 5.278857333 | 1.31 | LF, RF | 10 | 1 | TBD | COL | 2016 | 2017 | PIT |
5986 | 5986 | Troy Tulowitzki | 31 | tulowtr01 | 2016 | TOR | AL | 5.089032258 | 3.175 | SS | 16 | 1 | TOR | COL | 2015 | 2017 | NYY |
6101 | 6101 | Jhoulys Chacin | 27 | chacijh01 | 2015 | ARI | NL | 0.751090616 | 0.215 | P | 2 | 1 | ARI | COL | 2015 | 2015 | ATL |
6116 | 6116 | Jordan Pacheco | 29 | pachejo01 | 2015 | ARI | NL | 0.760719691 | -0.275 | C, 1B, 3B | 0 | 1 | ARI | COL | 2014 | 2015 | CIN |
6122 | 6122 | Matt Reynolds | 30 | reynoma02 | 2015 | ARI | NL | 0.505969871 | -0.335 | P | 0 | 1 | ARI | COL | 2013 | 2015 | SFG |
6227 | 6227 | Jorge Rondon | 27 | rondojo01 | 2015 | BAL | AL | 0.250257354 | -0.305 | P | 0 | 2 | BAL | COL | 2015 | 2015 | PIT |
6264 | 6264 | Josh Rutledge | 26 | rutlejo01 | 2015 | BOS | AL | 0.793625241 | 0.095 | 2B, 3B | 1 | 1 | BOS | COL | 2015 | 2017 | |
6574 | 6574 | Collin McHugh | 28 | mchugco01 | 2015 | HOU | AL | 5.752734497 | 3.13 | P | 16 | 1 | HOU | COL | 2014 | 2019 | |
6634 | 6634 | Franklin Morales | 29 | moralfr01 | 2015 | KCR | AL | 1.789849628 | 0.585 | P | 5 | 1 | KCR | COL | 2015 | 2015 | TOR |
6643 | 6643 | Jeremy Guthrie | 36 | guthrje01 | 2015 | KCR | AL | 3.904328846 | -1.225 | P | 3 | 1 | KCR | COL | 2012 | 2015 | WSN |
6672 | 6672 | Chris Iannetta | 32 | iannech01 | 2015 | LAA | AL | 3.080764075 | 1.05 | C, 1B | 8 | 1 | ANA | COL | 2012 | 2015 | SEA |
6720 | 6720 | Brett Anderson | 27 | anderbr04 | 2015 | LAD | NL | 4.952163227 | 1.515 | P | 11 | 1 | LAD | COL | 2015 | 2016 | CHC |
6733 | 6733 | Juan Nicasio | 28 | nicasju01 | 2015 | LAD | NL | 1.806399258 | 0.56 | P | 4 | 1 | LAD | COL | 2015 | 2015 | PIT |
6764 | 6764 | Chin-hui Tsao | 34 | tsaoch01 | 2015 | LAD | NL | 0.183025736 | -0.3 | P | 0 | 1 | LAD | COL | 2007 | 2016 | |
6795 | 6795 | Nick Masset | 33 | masseni01 | 2015 | MIA | NL | 0.263850689 | 0.115 | P | 1 | 1 | FLA | COL | 2015 | 2015 | ATL |
6852 | 6852 | Hector Gomez | 27 | gomezhe01 | 2015 | MIL | NL | 1.360882507 | -0.355 | 2B, 3B, SS, LF | 1 | 1 | MIL | COL | 2014 | 2015 | |
6902 | 6902 | Doug Bernier | 35 | bernido01 | 2015 | MIN | AL | 0.058029015 | 0.01 | 2B, 3B | 0 | 1 | MIN | COL | 2013 | 2015 | |
6927 | 6927 | Michael Cuddyer | 36 | cuddymi01 | 2015 | NYM | NL | 4.084930088 | 0.32 | LF, 1B, RF | 7 | 1 | NYM | COL | 2015 | 2015 | |
6938 | 6938 | Carlos Torres | 32 | torreca01 | 2015 | NYM | NL | 1.739766581 | 0.045 | P | 3 | 1 | NYM | COL | 2013 | 2015 | MIL |
6991 | 6991 | Chris Martin | 29 | martich02 | 2015 | NYY | AL | 0.55059032 | 0.005 | P | 1 | 1 | NYY | COL | 2015 | 2015 | TEX |
7031 | 7031 | Drew Pomeranz | 26 | pomerdr01 | 2015 | OAK | AL | 3.136516279 | 0.815 | P | 6 | 1 | OAK | COL | 2014 | 2015 | SDP |
7055 | 7055 | Jason Pridie | 31 | pridija01 | 2015 | OAK | AL | 0.094308943 | -0.195 | RF, CF, LF | 0 | 1 | OAK | COL | 2015 | 2015 | |
7108 | 7108 | Kenny Roberts | 27 | roberke02 | 2015 | PHI | NL | 0.097406953 | -0.09 | P | 0 | 2 | PHI | COL | 2015 | 2015 | |
7148 | 7148 | Rob Scahill | 28 | scahiro01 | 2015 | PIT | NL | 0.821453651 | -0.185 | P | 1 | 1 | PIT | COL | 2015 | 2016 | MIL |
7150 | 7150 | Chris Volstad | 28 | volstch01 | 2015 | PIT | NL | 0.037330167 | 0.035 | P | 0 | 1 | PIT | COL | 2015 | 2015 | CHW |
7243 | 7243 | Logan Kensing | 32 | kensilo01 | 2015 | SEA | AL | 0.505065315 | -0.18 | P | 0 | 1 | SEA | COL | 2015 | 2015 | DET |
7292 | 7292 | Jackson Williams | 29 | willija01 | 2015 | SFG | NL | 0.140024142 | 0.095 | C | 0 | 1 | SFG | COL | 2015 | 2015 |
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 );