mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
1,306 rows where next_franch = "TOR"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37 | 37 | Zack Godley | 29 | godleza01 | 2019 | ARI | NL | 1.876806232 | -0.397358491 | P | 1 | 1 | ARI | 2015 | 2019 | TOR | |
392 | 392 | Neil Ramirez | 30 | ramirne01 | 2019 | CLE | AL | 0.408928393 | -0.168113208 | P | 0 | 1 | CLE | NYM | 2018 | 2019 | TOR |
535 | 535 | Derek Fisher | 25 | fishede01 | 2019 | HOU | AL | 0.556354916 | 0.198679245 | LF, RF, CF | 1 | 1 | HOU | 2017 | 2019 | TOR | |
695 | 695 | Brock Stewart | 27 | stewabr01 | 2019 | LAD | NL | 0.063549858 | -0.096792453 | P | 0 | 1 | LAD | 2016 | 2019 | TOR | |
878 | 878 | Wilmer Font | 29 | fontwi01 | 2019 | NYM | NL | 0.810332864 | -0.076415094 | P | 1 | 2 | NYM | TBD | 2019 | 2019 | TOR |
940 | 940 | Breyvic Valera | 27 | valerbr01 | 2019 | NYY | AL | 0.351400033 | 0.00509434 | 2B, SS | 1 | 1 | NYY | BAL | 2019 | 2019 | TOR |
992 | 992 | Beau Taylor | 29 | taylobe11 | 2019 | OAK | AL | 0.264581297 | 0.076415094 | C | 1 | 1 | OAK | 2018 | 2019 | TOR | |
1115 | 1115 | Nick Kingham | 27 | kinghni01 | 2019 | PIT | NL | 1.206616136 | -0.845660377 | P | 0 | 1 | PIT | 2018 | 2019 | TOR | |
1207 | 1207 | Zac Rosscup | 31 | rosscza01 | 2019 | SEA | AL | 0.474871854 | 0.066226415 | P | 1 | 1 | SEA | LAD | 2019 | 2019 | TOR |
1572 | 1572 | Clay Buchholz | 33 | buchhcl01 | 2018 | ARI | NL | 2.635512471 | 2.29 | P | 11 | 1 | ARI | PHI | 2018 | 2018 | TOR |
1574 | 1574 | Zack Godley | 28 | godleza01 | 2018 | ARI | NL | 4.960510143 | 0.575 | P | 9 | 1 | ARI | 2015 | 2019 | TOR | |
1608 | 1608 | Socrates Brito | 25 | britoso01 | 2018 | ARI | NL | 0.438111588 | -0.34 | RF, LF, CF | 0 | 1 | ARI | 2015 | 2018 | TOR | |
1951 | 1951 | Neil Ramirez | 29 | ramirne01 | 2018 | CLE | AL | 1.363429379 | -0.04 | P | 2 | 1 | CLE | NYM | 2018 | 2019 | TOR |
2094 | 2094 | Ken Giles | 27 | gileske01 | 2018 | HOU | AL | 0.919523685 | 0.295 | P | 2 | 1 | HOU | PHI | 2016 | 2018 | TOR |
2097 | 2097 | Derek Fisher | 24 | fishede01 | 2018 | HOU | AL | 0.814899526 | 0.05 | LF, CF, RF | 1 | 1 | HOU | 2017 | 2019 | TOR | |
2145 | 2145 | Jason Adam | 26 | adamja01 | 2018 | KCR | AL | 0.822085613 | -0.315 | P | 0 | 1 | KCR | 2018 | 2018 | TOR | |
2182 | 2182 | Matt Shoemaker | 31 | shoemma01 | 2018 | LAA | AL | 0.916918674 | 0.345 | P | 2 | 1 | ANA | 2013 | 2018 | TOR | |
2197 | 2197 | Oliver Drake | 31 | drakeol01 | 2018 | LAA | AL | 0.193285254 | -0.01 | P | 0 | 3 | ANA | CLE | 2018 | 2018 | TOR |
2252 | 2252 | Daniel Hudson | 31 | hudsoda01 | 2018 | LAD | NL | 1.33880385 | -0.248466258 | P | 1 | 1 | LAD | PIT | 2018 | 2018 | TOR |
2264 | 2264 | Brock Stewart | 26 | stewabr01 | 2018 | LAD | NL | 0.447996926 | -0.462147239 | P | 0 | 1 | LAD | 2016 | 2019 | TOR | |
2312 | 2312 | Javy Guerra | 32 | guerrja01 | 2018 | MIA | NL | 1.086779093 | -0.543354037 | P | 0 | 1 | FLA | ANA | 2017 | 2018 | TOR |
2369 | 2369 | Eric Sogard | 32 | sogarer01 | 2018 | MIL | NL | 1.108030431 | -0.829877301 | SS, 2B, LF | 0 | 1 | MIL | OAK | 2017 | 2018 | TOR |
2525 | 2525 | Billy McKinney | 23 | mckinbi01 | 2018 | NYY | AL | 0.03712594 | -0.165 | LF, RF, 1B | 0 | 1 | NYY | 2018 | 2018 | TOR | |
2528 | 2528 | Brandon Drury | 25 | drurybr01 | 2018 | NYY | AL | 0.529044647 | -0.41 | 3B, 2B, 1B, SS | 0 | 1 | NYY | ARI | 2018 | 2018 | TOR |
2543 | 2543 | Edwin Jackson | 34 | jacksed01 | 2018 | OAK | AL | 2.534822616 | 1.14 | P | 7 | 1 | OAK | WSN | 2018 | 2018 | TOR |
2571 | 2571 | Beau Taylor | 28 | taylobe11 | 2018 | OAK | AL | 0.055822907 | 0.015 | C | 0 | 1 | OAK | 2018 | 2019 | TOR | |
2629 | 2629 | Mark Leiter Jr. | 27 | leitema02 | 2018 | PHI | NL | 0.377271644 | -0.465 | P | 0 | 1 | PHI | 2017 | 2018 | TOR | |
2659 | 2659 | Nick Kingham | 26 | kinghni01 | 2018 | PIT | NL | 2.040107926 | -0.372298137 | P | 2 | 1 | PIT | 2018 | 2019 | TOR | |
2679 | 2679 | Freddy Galvis | 28 | galvifr01 | 2018 | SDP | NL | 6.598681929 | 1.77 | SS, 2B | 15 | 1 | SDP | PHI | 2018 | 2018 | TOR |
2695 | 2695 | Clayton Richard | 34 | richacl01 | 2018 | SDP | NL | 4.436024491 | -0.23 | P | 6 | 1 | SDP | CHC | 2016 | 2018 | TOR |
2795 | 2795 | Alen Hanson | 25 | hansoal01 | 2018 | SFG | NL | 3.100534575 | 0.56 | 2B, LF, SS, 3B, RF | 6 | 1 | SFG | CHW | 2018 | 2018 | TOR |
2822 | 2822 | Derek Law | 27 | lawde01 | 2018 | SFG | NL | 0.278650308 | -0.2 | P | 0 | 1 | SFG | 2016 | 2018 | TOR | |
2869 | 2869 | Preston Guilmet | 30 | guilmpr01 | 2018 | STL | NL | 0.047454703 | -0.245 | P | 0 | 1 | STL | MIL | 2018 | 2018 | TOR |
3090 | 3090 | Jimmy Cordero | 26 | cordeji01 | 2018 | WSN | NL | 0.497214554 | -0.165 | P | 0 | 1 | WSN | 2018 | 2018 | TOR | |
3101 | 3101 | Zack Godley | 27 | godleza01 | 2017 | ARI | NL | 4.328230522 | 3.43 | P | 16 | 1 | ARI | 2015 | 2019 | TOR | |
3318 | 3318 | Miguel Montero | 33 | montemi01 | 2017 | CHC | NL | 1.094892972 | 0.25 | C, 1B, P | 2 | 1 | CHC | ARI | 2015 | 2017 | TOR |
3337 | 3337 | Brett Anderson | 29 | anderbr04 | 2017 | CHC | NL | 0.60997247 | -0.265 | P | 0 | 1 | CHC | LAD | 2017 | 2017 | TOR |
3384 | 3384 | Jake Petricka | 29 | petrija01 | 2017 | CHW | AL | 0.824495615 | -0.375 | P | 0 | 1 | CHW | 2013 | 2017 | TOR | |
3413 | 3413 | Deck McGuire | 28 | mcguide02 | 2017 | CIN | NL | 0.322348325 | 0.23 | P | 1 | 1 | CIN | 2017 | 2017 | TOR | |
3476 | 3476 | Gio Urshela | 25 | urshegi01 | 2017 | CLE | AL | 1.540318687 | -0.655 | 3B, 2B, SS, 1B | 0 | 1 | CLE | 2015 | 2017 | TOR | |
3580 | 3580 | Ken Giles | 26 | gileske01 | 2017 | HOU | AL | 2.350505703 | 1.92 | P | 9 | 1 | HOU | PHI | 2016 | 2018 | TOR |
3590 | 3590 | Derek Fisher | 23 | fishede01 | 2017 | HOU | AL | 1.542454342 | 0.145 | LF, RF, CF | 3 | 1 | HOU | 2017 | 2019 | TOR | |
3591 | 3591 | Nori Aoki | 35 | aokino01 | 2017 | HOU | AL | 2.081384172 | 0.135 | LF, RF, CF, P | 3 | 1 | HOU | SEA | 2017 | 2017 | TOR |
3599 | 3599 | David Paulino | 23 | paulida01 | 2017 | HOU | AL | 0.821261029 | -0.11 | P | 1 | 1 | HOU | 2016 | 2017 | TOR | |
3602 | 3602 | Teoscar Hernandez | 24 | hernate01 | 2017 | HOU | AL | 0.0 | 0.0 | LF, CF, RF | 0 | 1 | HOU | 2016 | 2017 | TOR | |
3607 | 3607 | Tyler Clippard | 32 | clippty01 | 2017 | HOU | AL | 0.407015279 | -0.17 | P | 0 | 3 | HOU | CHW | 2017 | 2017 | TOR |
3635 | 3635 | Sam Gaviglio | 27 | gavigsa01 | 2017 | KCR | AL | 0.258022924 | 0.305 | P | 1 | 2 | KCR | SEA | 2017 | 2017 | TOR |
3684 | 3684 | Matt Shoemaker | 30 | shoemma01 | 2017 | LAA | AL | 2.173718555 | 0.415 | P | 4 | 1 | ANA | 2013 | 2018 | TOR | |
3746 | 3746 | Brock Stewart | 25 | stewabr01 | 2017 | LAD | NL | 0.77480412 | -0.05 | P | 1 | 1 | LAD | 2016 | 2019 | TOR | |
3748 | 3748 | Curtis Granderson | 36 | grandcu01 | 2017 | LAD | NL | 1.305593452 | -0.215 | CF, RF, LF | 1 | 2 | LAD | NYM | 2017 | 2017 | TOR |
3797 | 3797 | Javy Guerra | 31 | guerrja01 | 2017 | MIA | NL | 0.650063053 | 0.2 | P | 1 | 1 | FLA | ANA | 2017 | 2018 | TOR |
3811 | 3811 | Tom Koehler | 31 | koehlto01 | 2017 | MIA | NL | 1.59585422 | -1.405 | P | 0 | 1 | FLA | 2012 | 2017 | TOR | |
3822 | 3822 | Eric Sogard | 31 | sogarer01 | 2017 | MIL | NL | 2.980237154 | 1.49 | 2B, SS, 3B, LF | 9 | 1 | MIL | OAK | 2017 | 2018 | TOR |
3893 | 3893 | Buddy Boshers | 29 | boshebu01 | 2017 | MIN | AL | 0.982525652 | -0.115 | P | 1 | 1 | MIN | ANA | 2016 | 2017 | TOR |
3911 | 3911 | Nick Tepesch | 28 | tepesni01 | 2017 | MIN | AL | 0.04729274 | -0.225 | P | 0 | 1 | MIN | LAD | 2017 | 2017 | TOR |
3997 | 3997 | Jaime Garcia | 30 | garcija02 | 2017 | NYY | AL | 1.05347192 | 0.09 | P | 1 | 3 | NYY | MIN | 2017 | 2017 | TOR |
4013 | 4013 | Rob Refsnyder | 26 | refsnro01 | 2017 | NYY | AL | 0.366566598 | -0.25 | 2B, LF, 1B, RF | 0 | 1 | NYY | 2015 | 2017 | TOR | |
4064 | 4064 | Cesar Valdez | 32 | valdece01 | 2017 | OAK | AL | 0.200159262 | -0.24 | P | 0 | 1 | OAK | ARI | 2017 | 2017 | TOR |
4065 | 4065 | John Axford | 34 | axforjo01 | 2017 | OAK | AL | 0.543646852 | -0.295 | P | 0 | 1 | OAK | COL | 2016 | 2017 | TOR |
4097 | 4097 | Mark Leiter Jr. | 26 | leitema02 | 2017 | PHI | NL | 2.292435044 | -0.035 | P | 3 | 1 | PHI | 2017 | 2018 | TOR | |
4119 | 4119 | Michael Saunders | 30 | saundmi01 | 2017 | PHI | NL | 2.130084091 | -0.72 | RF, LF | 0 | 1 | PHI | TOR | 2017 | 2017 | TOR |
4152 | 4152 | Gift Ngoepe | 27 | ngoepgi01 | 2017 | PIT | NL | 0.628591089 | 0.03 | 2B, SS, 3B | 1 | 1 | PIT | 2017 | 2017 | TOR | |
4172 | 4172 | Clayton Richard | 33 | richacl01 | 2017 | SDP | NL | 5.617328711 | 1.54 | P | 14 | 1 | SDP | CHC | 2016 | 2018 | TOR |
4175 | 4175 | Yangervis Solarte | 29 | solarya01 | 2017 | SDP | NL | 5.258721445 | 1.035 | 2B, SS, 3B, 1B | 12 | 1 | SDP | NYY | 2014 | 2017 | TOR |
4253 | 4253 | David Phelps | 30 | phelpda01 | 2017 | SEA | AL | 0.369329198 | 0.21 | P | 1 | 2 | SEA | FLA | 2017 | 2017 | TOR |
4307 | 4307 | Derek Law | 26 | lawde01 | 2017 | SFG | NL | 1.146331711 | 0.04 | P | 2 | 1 | SFG | 2016 | 2018 | TOR | |
4343 | 4343 | Randal Grichuk | 25 | grichra01 | 2017 | STL | NL | 4.353200883 | 1.275 | LF, RF, CF | 9 | 1 | STL | 2014 | 2017 | TOR | |
4355 | 4355 | Seunghwan Oh | 34 | ohse01 | 2017 | STL | NL | 2.277250027 | -0.07 | P | 3 | 1 | STL | 2016 | 2017 | TOR | |
4356 | 4356 | Aledmys Diaz | 26 | diazal02 | 2017 | STL | NL | 2.964510104 | -0.18 | SS, 3B, LF, 2B | 3 | 1 | STL | 2016 | 2017 | TOR | |
4478 | 4478 | Mike Hauschild | 27 | hauscmi01 | 2017 | TEX | AL | 0.169266432 | -0.315 | P | 0 | 1 | TEX | 2017 | 2017 | TOR | |
4621 | 4621 | Zack Godley | 26 | godleza01 | 2016 | ARI | NL | 2.077224232 | -0.305 | P | 2 | 1 | ARI | 2015 | 2019 | TOR | |
4635 | 4635 | Dominic Leone | 24 | leonedo01 | 2016 | ARI | NL | 0.600911296 | -0.365 | P | 0 | 1 | ARI | SEA | 2015 | 2016 | TOR |
4636 | 4636 | Socrates Brito | 23 | britoso01 | 2016 | ARI | NL | 0.949375633 | -0.38 | CF, RF, LF | 0 | 1 | ARI | 2015 | 2018 | TOR | |
4678 | 4678 | Jason Grilli | 39 | grillja01 | 2016 | ATL | NL | 0.591858192 | -0.115714286 | P | 1 | 1 | ATL | ANA | 2015 | 2016 | TOR |
4727 | 4727 | Steve Pearce | 33 | pearcst01 | 2016 | BAL | AL | 0.669856459 | 0.185 | 1B, 2B, LF, RF, 3B | 2 | 2 | BAL | TBD | 2016 | 2016 | TOR |
4815 | 4815 | Miguel Montero | 32 | montemi01 | 2016 | CHC | NL | 2.775400168 | 0.325 | C, P | 5 | 1 | CHC | ARI | 2015 | 2017 | TOR |
4816 | 4816 | Chris Coghlan | 31 | coghlch01 | 2016 | CHC | NL | 1.250884583 | 0.905 | LF, 2B, 3B, RF, 1B | 4 | 2 | CHC | OAK | 2016 | 2016 | TOR |
4831 | 4831 | Joe Smith | 32 | smithjo05 | 2016 | CHC | NL | 0.383389469 | 0.035 | P | 1 | 2 | CHC | ANA | 2016 | 2016 | TOR |
4871 | 4871 | Dioner Navarro | 32 | navardi01 | 2016 | CHW | AL | 2.829268293 | -1.095 | C | 1 | 1 | CHW | TOR | 2016 | 2016 | TOR |
4879 | 4879 | Jake Petricka | 28 | petrija01 | 2016 | CHW | AL | 0.236867985 | -0.075 | P | 0 | 1 | CHW | 2013 | 2017 | TOR | |
4929 | 4929 | Rafael Lopez | 28 | lopezra02 | 2016 | CIN | NL | 0.070400555 | -0.185 | C, 1B | 0 | 1 | CIN | CHC | 2016 | 2016 | TOR |
4981 | 4981 | T.J. House | 26 | housetj01 | 2016 | CLE | AL | 0.062620036 | 0.02515528 | P | 0 | 1 | CLE | 2014 | 2016 | TOR | |
5067 | 5067 | Jarrod Saltalamacchia | 31 | saltaja01 | 2016 | DET | AL | 2.77457405 | -0.598695652 | C, 1B | 2 | 1 | DET | ARI | 2016 | 2016 | TOR |
5103 | 5103 | Ken Giles | 25 | gileske01 | 2016 | HOU | AL | 2.47450487 | 0.585 | P | 5 | 1 | HOU | PHI | 2016 | 2018 | TOR |
5106 | 5106 | Scott Feldman | 33 | feldmsc01 | 2016 | HOU | AL | 1.797882444 | 0.305 | P | 3 | 1 | HOU | BAL | 2014 | 2016 | TOR |
5110 | 5110 | Teoscar Hernandez | 23 | hernate01 | 2016 | HOU | AL | 1.050962627 | 0.135 | LF, CF, RF | 2 | 1 | HOU | 2016 | 2017 | TOR | |
5114 | 5114 | David Paulino | 22 | paulida01 | 2016 | HOU | AL | 0.13807219 | 0.005 | P | 0 | 1 | HOU | 2016 | 2017 | TOR | |
5135 | 5135 | Kendrys Morales | 33 | moralke01 | 2016 | KCR | AL | 5.943292986 | 0.965 | 1B, RF | 12 | 1 | KCR | SEA | 2015 | 2016 | TOR |
5173 | 5173 | Matt Shoemaker | 29 | shoemma01 | 2016 | LAA | AL | 4.679492403 | 2.74 | P | 14 | 1 | ANA | 2013 | 2018 | TOR | |
5245 | 5245 | J.P. Howell | 33 | howeljp01 | 2016 | LAD | NL | 1.227165304 | 0.255 | P | 3 | 1 | LAD | TBD | 2013 | 2016 | TOR |
5270 | 5270 | Brock Stewart | 24 | stewabr01 | 2016 | LAD | NL | 0.728096948 | -0.225 | P | 0 | 1 | LAD | 2016 | 2019 | TOR | |
5273 | 5273 | Mike Bolsinger | 28 | bolsimi01 | 2016 | LAD | NL | 0.776983457 | -0.43 | P | 0 | 1 | LAD | ARI | 2015 | 2016 | TOR |
5291 | 5291 | Tom Koehler | 30 | koehlto01 | 2016 | MIA | NL | 4.825571488 | 0.50310559 | P | 8 | 1 | FLA | 2012 | 2017 | TOR | |
5403 | 5403 | Buddy Boshers | 28 | boshebu01 | 2016 | MIN | AL | 0.988586763 | 0.315 | P | 2 | 1 | MIN | ANA | 2016 | 2017 | TOR |
5503 | 5503 | Rob Refsnyder | 25 | refsnro01 | 2016 | NYY | AL | 1.680741845 | -0.22 | 1B, RF, 2B, LF, 3B | 2 | 1 | NYY | 2015 | 2017 | TOR | |
5544 | 5544 | John Axford | 33 | axforjo01 | 2016 | OAK | AL | 2.246249684 | 0.59 | P | 5 | 1 | OAK | COL | 2016 | 2017 | TOR |
5647 | 5647 | Francisco Liriano | 32 | liriafr01 | 2016 | PIT | NL | 3.201249808 | 0.16 | P | 5 | 1 | PIT | CHW | 2013 | 2016 | TOR |
5685 | 5685 | Yangervis Solarte | 28 | solarya01 | 2016 | SDP | NL | 4.514848006 | 2.395 | 3B, 2B, 1B | 14 | 1 | SDP | NYY | 2014 | 2017 | TOR |
5688 | 5688 | Melvin Upton Jr. | 31 | uptonbj01 | 2016 | SDP | NL | 3.811632402 | 1.63 | LF, CF, RF | 10 | 1 | SDP | ATL | 2015 | 2016 | TOR |
5701 | 5701 | Clayton Richard | 32 | richacl01 | 2016 | SDP | NL | 1.425935923 | 0.675 | P | 4 | 2 | SDP | CHC | 2016 | 2018 | TOR |
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 );