mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
98,796 rows sorted by franch_id
This data as json, copyable, CSV (advanced)
Suggested facets: lg_ID, stint_ID, franch_id, prev_franch
next_franch 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
599 | 599 | Mike Trout | 27 | troutmi01 | 2019 | LAA | AL | 5.677924621 | 8.589056604 | CF | 33 | 1 | ANA | 2011 | 2019 | ||
600 | 600 | David Fletcher | 25 | fletcda02 | 2019 | LAA | AL | 6.056452929 | 3.729056604 | 3B, 2B, SS, LF, RF | 19 | 1 | ANA | 2018 | 2019 | ||
601 | 601 | Kole Calhoun | 31 | calhoko01 | 2019 | LAA | AL | 5.876651982 | 2.282264151 | RF, CF | 15 | 1 | ANA | 2012 | 2019 | ||
602 | 602 | Shohei Ohtani | 24 | ohtansh01 | 2019 | LAA | AL | 4.021863273 | 2.16 | 12 | 1 | ANA | 2018 | 2019 | |||
603 | 603 | Brian Goodwin | 28 | goodwbr01 | 2019 | LAA | AL | 4.248980258 | 2.073396226 | LF, CF, RF | 12 | 1 | ANA | KCR | 2019 | 2019 | |
604 | 604 | Hansel Robles | 28 | robleha01 | 2019 | LAA | AL | 2.627767759 | 2.236415094 | P | 10 | 1 | ANA | NYM | 2018 | 2019 | |
605 | 605 | Tommy La Stella | 30 | lasteto01 | 2019 | LAA | AL | 2.952520803 | 1.935849057 | 2B, 3B, 1B | 10 | 1 | ANA | CHC | 2019 | 2019 | |
606 | 606 | Andrelton Simmons | 29 | simmoan01 | 2019 | LAA | AL | 3.908304781 | 1.635283019 | SS | 10 | 1 | ANA | ATL | 2016 | 2019 | |
607 | 607 | Luis Rengifo | 22 | rengilu01 | 2019 | LAA | AL | 3.842062327 | 1.416226415 | 2B, SS | 9 | 1 | ANA | 2019 | 2019 | ||
608 | 608 | Tyler Skaggs | 27 | skaggty01 | 2019 | LAA | AL | 2.312139711 | 1.406037736 | P | 7 | 1 | ANA | ARI | 2014 | 2019 | |
609 | 609 | Griffin Canning | 23 | cannigr01 | 2019 | LAA | AL | 2.747893694 | 1.248113208 | P | 7 | 1 | ANA | 2019 | 2019 | ||
610 | 610 | Ty Buttrey | 26 | buttrty01 | 2019 | LAA | AL | 2.756688444 | 1.161509434 | P | 7 | 1 | ANA | 2018 | 2019 | ||
611 | 611 | Andrew Heaney | 28 | heanean01 | 2019 | LAA | AL | 2.766828273 | 1.105471698 | P | 7 | 1 | ANA | FLA | 2015 | 2019 | |
612 | 612 | Albert Pujols | 39 | pujolal01 | 2019 | LAA | AL | 5.072279328 | 0.142641509 | 1B, 3B | 7 | 1 | ANA | STL | 2012 | 2019 | |
613 | 613 | Felix Pena | 29 | penafe01 | 2019 | LAA | AL | 2.736046649 | 0.713207547 | P | 6 | 1 | ANA | CHC | 2018 | 2019 | |
614 | 614 | Noe Ramirez | 29 | ramirno01 | 2019 | LAA | AL | 1.800337009 | 0.927169811 | P | 5 | 1 | ANA | BOS | 2017 | 2019 | |
615 | 615 | Cam Bedrosian | 27 | bedroca01 | 2019 | LAA | AL | 2.027551956 | 0.723396226 | P | 5 | 1 | ANA | 2014 | 2019 | ||
616 | 616 | Cesar Puello | 28 | puellce01 | 2019 | LAA | AL | 0.473160385 | 0.830377358 | CF, LF, RF | 3 | 1 | ANA | TBD | 2019 | 2019 | FLA |
617 | 617 | Dustin Garneau | 31 | garnedu01 | 2019 | LAA | AL | 0.775983031 | 0.555283019 | C, 1B | 3 | 1 | ANA | CHW | 2019 | 2019 | OAK |
618 | 618 | Luke Bard | 28 | bardlu01 | 2019 | LAA | AL | 1.542081769 | 0.356603774 | P | 3 | 1 | ANA | 2018 | 2019 | ||
619 | 619 | Kevan Smith | 31 | smithke04 | 2019 | LAA | AL | 1.958883994 | 0.234339623 | C | 3 | 1 | ANA | CHW | 2019 | 2019 | |
620 | 620 | Taylor Cole | 29 | coleta01 | 2019 | LAA | AL | 1.587917935 | 0.142641509 | P | 3 | 1 | ANA | TOR | 2018 | 2019 | |
621 | 621 | Dillon Peters | 26 | peterdi01 | 2019 | LAA | AL | 1.865004287 | 0.13245283 | P | 3 | 1 | ANA | FLA | 2019 | 2019 | |
622 | 622 | Patrick Sandoval | 22 | sandopa02 | 2019 | LAA | AL | 1.005705502 | 0.310754717 | P | 2 | 1 | ANA | 2019 | 2019 | ||
623 | 623 | Matt Thaiss | 24 | thaisma01 | 2019 | LAA | AL | 1.485723609 | -0.086603774 | 3B, 1B | 2 | 1 | ANA | 2019 | 2019 | ||
624 | 624 | Luis Garcia | 32 | garcilu03 | 2019 | LAA | AL | 1.629615396 | -0.101886792 | P | 2 | 1 | ANA | PHI | 2019 | 2019 | |
625 | 625 | Jonathan Lucroy | 33 | lucrojo01 | 2019 | LAA | AL | 2.536139664 | -0.433018868 | C, 1B | 2 | 1 | ANA | OAK | 2019 | 2019 | CHC |
626 | 626 | Justin Upton | 31 | uptonju01 | 2019 | LAA | AL | 2.422581171 | -0.550188679 | LF | 2 | 1 | ANA | DET | 2017 | 2019 | |
627 | 627 | Jaime Barria | 22 | barrija01 | 2019 | LAA | AL | 2.476187661 | -0.585849057 | P | 2 | 1 | ANA | 2018 | 2019 | ||
628 | 628 | Trevor Cahill | 31 | cahiltr01 | 2019 | LAA | AL | 2.783693499 | -0.631698113 | P | 2 | 1 | ANA | OAK | 2019 | 2019 | |
629 | 629 | Keynan Middleton | 25 | middlke01 | 2019 | LAA | AL | 0.251529843 | 0.290377358 | P | 1 | 1 | ANA | 2017 | 2019 | ||
630 | 630 | Adalberto Mejia | 26 | mejiaad01 | 2019 | LAA | AL | 0.442168977 | 0.13245283 | P | 1 | 2 | ANA | MIN | 2019 | 2019 | STL |
631 | 631 | Michael Hermosillo | 24 | hermomi01 | 2019 | LAA | AL | 0.406917931 | 0.071320755 | LF, CF, RF | 1 | 1 | ANA | 2018 | 2019 | ||
632 | 632 | Jose Rodriguez | 23 | rodrijo07 | 2019 | LAA | AL | 0.449049576 | 0.071320755 | P | 1 | 1 | ANA | 2019 | 2019 | ||
633 | 633 | Wilfredo Tovar | 27 | tovarwi01 | 2019 | LAA | AL | 0.832762278 | -0.061132075 | SS | 1 | 1 | ANA | NYM | 2019 | 2019 | |
634 | 634 | Justin Anderson | 26 | anderju01 | 2019 | LAA | AL | 1.361892867 | -0.157924528 | P | 1 | 1 | ANA | 2018 | 2019 | ||
635 | 635 | Justin Bour | 31 | bourju01 | 2019 | LAA | AL | 1.599282101 | -0.468679245 | 1B | 1 | 1 | ANA | PHI | 2019 | 2019 | |
636 | 636 | Matt Harvey | 30 | harvema01 | 2019 | LAA | AL | 1.731686227 | -0.489056604 | P | 1 | 1 | ANA | CIN | 2019 | 2019 | |
637 | 637 | Kaleb Cowart | 27 | cowarka01 | 2019 | LAA | AL | 0.160874531 | 0.086603774 | 3B, 2B | 0 | 1 | ANA | 2015 | 2019 | ||
638 | 638 | JC Ramirez | 30 | ramirjc01 | 2019 | LAA | AL | 0.151476631 | 0.030566038 | P | 0 | 1 | ANA | CIN | 2016 | 2019 | |
639 | 639 | Matt Ramsey | 29 | ramsema01 | 2019 | LAA | AL | 0.016606557 | 0.020377358 | P | 0 | 1 | ANA | 2019 | 2019 | ||
640 | 640 | John Curtiss | 26 | curtijo02 | 2019 | LAA | AL | 0.037662222 | 0.015283019 | P | 0 | 1 | ANA | MIN | 2019 | 2019 | |
641 | 641 | Sam Freeman | 32 | freemsa01 | 2019 | LAA | AL | 0.038489964 | -0.035660377 | P | 0 | 1 | ANA | ATL | 2019 | 2019 | |
642 | 642 | Kean Wong | 24 | wongke01 | 2019 | LAA | AL | 0.037852831 | -0.142641509 | 2B, RF | 0 | 2 | ANA | TBD | 2019 | 2019 | |
643 | 643 | Jarrett Parker | 30 | parkeja03 | 2019 | LAA | AL | 0.141948116 | -0.152830189 | LF | 0 | 1 | ANA | SFG | 2019 | 2019 | |
644 | 644 | Jared Walsh | 25 | walshja01 | 2019 | LAA | AL | 0.785446239 | -0.244528302 | 1B, P | 0 | 1 | ANA | 2019 | 2019 | ||
645 | 645 | Anthony Bemboom | 29 | bemboan01 | 2019 | LAA | AL | 0.425844347 | -0.290377358 | C | 0 | 2 | ANA | TBD | 2019 | 2019 | |
646 | 646 | Jake Jewell | 26 | jewelja01 | 2019 | LAA | AL | 0.532651432 | -0.341320755 | P | 0 | 1 | ANA | 2018 | 2019 | ||
647 | 647 | Chris Stratton | 28 | stratch01 | 2019 | LAA | AL | 0.773937979 | -0.40245283 | P | 0 | 1 | ANA | SFG | 2019 | 2019 | PIT |
648 | 648 | Taylor Ward | 25 | wardta01 | 2019 | LAA | AL | 0.387991516 | -0.412641509 | LF, 3B | 0 | 1 | ANA | 2018 | 2019 | ||
649 | 649 | Nick Tropeano | 28 | tropeni01 | 2019 | LAA | AL | 0.362705827 | -0.433018868 | P | 0 | 1 | ANA | HOU | 2015 | 2019 | |
650 | 650 | Cody Allen | 30 | allenco01 | 2019 | LAA | AL | 0.606837733 | -0.438113208 | P | 0 | 1 | ANA | CLE | 2019 | 2019 | |
651 | 651 | Peter Bourjos | 32 | bourjpe01 | 2019 | LAA | AL | 0.435307554 | -0.458490566 | LF, CF, 2B | 0 | 1 | ANA | ATL | 2019 | 2019 | |
652 | 652 | Miguel Del Pozo | 26 | delpomi01 | 2019 | LAA | AL | 0.301349514 | -0.463584906 | P | 0 | 1 | ANA | 2019 | 2019 | ||
653 | 653 | Max Stassi | 28 | stassma01 | 2019 | LAA | AL | 0.463697177 | -0.53490566 | C, 1B, P | 0 | 2 | ANA | HOU | 2019 | 2019 | |
654 | 654 | Zack Cozart | 33 | cozarza01 | 2019 | LAA | AL | 1.012563224 | -0.860943396 | 3B, SS, 2B | 0 | 1 | ANA | CIN | 2018 | 2019 | |
655 | 655 | Jose Suarez | 21 | suarejo01 | 2019 | LAA | AL | 2.276495107 | -1.08509434 | P | 0 | 1 | ANA | 2019 | 2019 | ||
2155 | 2155 | Mike Trout | 26 | troutmi01 | 2018 | LAA | AL | 5.794281959 | 9.975 | CF | 37 | 1 | ANA | 2011 | 2019 | ||
2156 | 2156 | Andrelton Simmons | 28 | simmoan01 | 2018 | LAA | AL | 5.718041407 | 5.785 | SS | 25 | 1 | ANA | ATL | 2016 | 2019 | |
2157 | 2157 | Justin Upton | 30 | uptonju01 | 2018 | LAA | AL | 5.841932304 | 3.45 | LF | 18 | 1 | ANA | DET | 2017 | 2019 | |
2158 | 2158 | Shohei Ohtani | 23 | ohtansh01 | 2018 | LAA | AL | 3.497535327 | 3.86 | P | 16 | 1 | ANA | 2018 | 2019 | ||
2159 | 2159 | Andrew Heaney | 27 | heanean01 | 2018 | LAA | AL | 5.352514734 | 2.1 | P | 13 | 1 | ANA | FLA | 2015 | 2019 | |
2160 | 2160 | Ian Kinsler | 36 | kinslia01 | 2018 | LAA | AL | 3.726256983 | 2.365 | 2B | 12 | 1 | ANA | DET | 2018 | 2018 | BOS |
2161 | 2161 | Jaime Barria | 21 | barrija01 | 2018 | LAA | AL | 3.845880957 | 1.905 | P | 11 | 1 | ANA | 2018 | 2019 | ||
2162 | 2162 | David Fletcher | 24 | fletcda02 | 2018 | LAA | AL | 2.925731186 | 1.925 | 2B, 3B, SS, RF | 10 | 1 | ANA | 2018 | 2019 | ||
2163 | 2163 | Tyler Skaggs | 26 | skaggty01 | 2018 | LAA | AL | 3.726936185 | 1.865 | P | 10 | 1 | ANA | ARI | 2014 | 2019 | |
2164 | 2164 | Kole Calhoun | 30 | calhoko01 | 2018 | LAA | AL | 5.260598094 | 0.37 | RF, CF | 8 | 1 | ANA | 2012 | 2019 | ||
2165 | 2165 | Jose Alvarez | 29 | alvarjo02 | 2018 | LAA | AL | 2.391549137 | 1.305 | P | 7 | 1 | ANA | DET | 2014 | 2018 | PHI |
2166 | 2166 | Albert Pujols | 38 | pujolal01 | 2018 | LAA | AL | 4.745974367 | 0.155 | 1B | 7 | 1 | ANA | STL | 2012 | 2019 | |
2167 | 2167 | Felix Pena | 28 | penafe01 | 2018 | LAA | AL | 2.63829627 | 0.97 | P | 6 | 1 | ANA | CHC | 2018 | 2019 | |
2168 | 2168 | Martin Maldonado | 31 | maldoma01 | 2018 | LAA | AL | 2.763720013 | 0.835 | C | 6 | 1 | ANA | MIL | 2017 | 2018 | HOU |
2169 | 2169 | Garrett Richards | 30 | richaga01 | 2018 | LAA | AL | 2.257788992 | 0.555 | P | 5 | 1 | ANA | 2011 | 2018 | SDP | |
2170 | 2170 | Blake Parker | 33 | parkebl01 | 2018 | LAA | AL | 2.192833336 | 0.545 | P | 5 | 1 | ANA | NYY | 2017 | 2018 | MIN |
2171 | 2171 | Justin Anderson | 25 | anderju01 | 2018 | LAA | AL | 1.951727644 | 0.425 | P | 4 | 1 | ANA | 2018 | 2019 | ||
2172 | 2172 | Cam Bedrosian | 26 | bedroca01 | 2018 | LAA | AL | 2.135944414 | 0.28 | P | 4 | 1 | ANA | 2014 | 2019 | ||
2173 | 2173 | Zack Cozart | 32 | cozarza01 | 2018 | LAA | AL | 2.41110746 | 0.19 | 3B, 2B, SS | 4 | 1 | ANA | CIN | 2018 | 2019 | |
2174 | 2174 | Taylor Cole | 28 | coleta01 | 2018 | LAA | AL | 0.996478807 | 0.565 | P | 3 | 1 | ANA | TOR | 2018 | 2019 | |
2175 | 2175 | Jose Briceno | 25 | bricejo01 | 2018 | LAA | AL | 1.219848833 | 0.51 | C, 1B | 3 | 1 | ANA | 2018 | 2018 | ||
2176 | 2176 | Hansel Robles | 27 | robleha01 | 2018 | LAA | AL | 1.172365225 | 0.425 | P | 3 | 2 | ANA | NYM | 2018 | 2019 | |
2177 | 2177 | Nick Tropeano | 27 | tropeni01 | 2018 | LAA | AL | 2.259950666 | 0.02 | P | 3 | 1 | ANA | HOU | 2015 | 2019 | |
2178 | 2178 | Noe Ramirez | 28 | ramirno01 | 2018 | LAA | AL | 2.346206715 | -0.015 | P | 3 | 1 | ANA | BOS | 2017 | 2019 | |
2179 | 2179 | Keynan Middleton | 24 | middlke01 | 2018 | LAA | AL | 0.827130134 | 0.465 | P | 2 | 1 | ANA | 2017 | 2019 | ||
2180 | 2180 | Ty Buttrey | 25 | buttrty01 | 2018 | LAA | AL | 0.736287118 | 0.455 | P | 2 | 1 | ANA | 2018 | 2019 | ||
2181 | 2181 | Rene Rivera | 34 | riverre01 | 2018 | LAA | AL | 0.829116004 | 0.435 | C, 1B | 2 | 1 | ANA | CHC | 2018 | 2018 | ATL |
2182 | 2182 | Matt Shoemaker | 31 | shoemma01 | 2018 | LAA | AL | 0.916918674 | 0.345 | P | 2 | 1 | ANA | 2013 | 2018 | TOR | |
2183 | 2183 | Jose Miguel Fernandez | 30 | fernajo03 | 2018 | LAA | AL | 1.172198488 | 0.225 | 1B, 3B, 2B | 2 | 1 | ANA | 2018 | 2018 | ||
2184 | 2184 | Taylor Ward | 24 | wardta01 | 2018 | LAA | AL | 1.400920145 | 0.045 | 3B | 2 | 1 | ANA | 2018 | 2019 | ||
2185 | 2185 | Jefry Marte | 27 | marteje01 | 2018 | LAA | AL | 1.991784423 | -0.275 | 1B, 3B, LF | 2 | 1 | ANA | DET | 2016 | 2018 | |
2186 | 2186 | Juan Graterol | 29 | grateju01 | 2018 | LAA | AL | 0.009530069 | 0.18 | C | 1 | 1 | ANA | 2016 | 2018 | MIN | |
2187 | 2187 | Blake Wood | 32 | woodbl01 | 2018 | LAA | AL | 0.354303576 | 0.165 | P | 1 | 1 | ANA | CIN | 2017 | 2018 | |
2188 | 2188 | Michael Hermosillo | 23 | hermomi01 | 2018 | LAA | AL | 0.590864279 | -0.07 | CF, RF, LF | 1 | 1 | ANA | 2018 | 2019 | ||
2189 | 2189 | Francisco Arcia | 28 | arciafr01 | 2018 | LAA | AL | 1.010187315 | -0.155 | C, P, 1B | 1 | 1 | ANA | 2018 | 2018 | ||
2190 | 2190 | Jim Johnson | 35 | johnsji04 | 2018 | LAA | AL | 1.98346734 | -0.4 | P | 1 | 1 | ANA | ATL | 2018 | 2018 | |
2191 | 2191 | Luis Valbuena | 32 | valbulu01 | 2018 | LAA | AL | 2.744659875 | -0.89 | 3B, 1B, 2B | 1 | 1 | ANA | HOU | 2017 | 2018 | |
2192 | 2192 | Ryan Schimpf | 30 | schimry01 | 2018 | LAA | AL | 0.066710483 | 0.12 | 2B, 3B, LF, RF | 0 | 1 | ANA | SDP | 2018 | 2018 | |
2193 | 2193 | Junichi Tazawa | 32 | tazawju01 | 2018 | LAA | AL | 0.180947898 | 0.05 | P | 0 | 2 | ANA | FLA | 2018 | 2018 | |
2194 | 2194 | Ian Krol | 27 | krolia01 | 2018 | LAA | AL | 0.043655262 | 0.045 | P | 0 | 1 | ANA | ATL | 2018 | 2018 | |
2195 | 2195 | Nolan Fontana | 27 | fontano01 | 2018 | LAA | AL | 0.114360828 | 0.03 | 2B, 3B, SS | 0 | 1 | ANA | 2017 | 2018 | ||
2196 | 2196 | Osmer Morales | 25 | moralos01 | 2018 | LAA | AL | 0.032899618 | 0.025 | P | 0 | 1 | ANA | 2018 | 2018 | ||
2197 | 2197 | Oliver Drake | 31 | drakeol01 | 2018 | LAA | AL | 0.193285254 | -0.01 | P | 0 | 3 | ANA | CLE | 2018 | 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 );