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 prev_franch
This data as json, copyable, CSV (advanced)
Suggested facets: lg_ID, stint_ID, franch_id, next_franch
prev_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | 4 | Nick Ahmed | 29 | ahmedni01 | 2019 | ARI | NL | 6.043515213 | 3.749433962 | SS | 19 | 1 | ARI | 2014 | 2019 | ||
7 | 7 | David Peralta | 31 | peralda01 | 2019 | ARI | NL | 4.170321265 | 1.793207547 | LF | 11 | 1 | ARI | 2014 | 2019 | ||
9 | 9 | Merrill Kelly | 30 | kellyme01 | 2019 | ARI | NL | 5.131034581 | 1.207358491 | P | 11 | 1 | ARI | 2019 | 2019 | ||
12 | 12 | Archie Bradley | 26 | bradlar01 | 2019 | ARI | NL | 2.517175312 | 1.054528302 | P | 7 | 1 | ARI | 2015 | 2019 | ||
18 | 18 | Andrew Chafin | 29 | chafian01 | 2019 | ARI | NL | 1.840637053 | 0.876226415 | P | 5 | 1 | ARI | 2014 | 2019 | ||
20 | 20 | Alex Young | 25 | youngal01 | 2019 | ARI | NL | 2.232212069 | 0.356603774 | P | 4 | 1 | ARI | 2019 | 2019 | ||
21 | 21 | Kevin Ginkel | 25 | ginkeke01 | 2019 | ARI | NL | 0.792728629 | 0.580754717 | P | 3 | 1 | ARI | 2019 | 2019 | ||
22 | 22 | Yoan Lopez | 26 | lopezyo01 | 2019 | ARI | NL | 2.070174147 | 0.168113208 | P | 3 | 1 | ARI | 2018 | 2019 | ||
23 | 23 | Ildemaro Vargas | 27 | vargail01 | 2019 | ARI | NL | 2.080231175 | 0.142641509 | 2B, 3B, SS, LF, RF | 3 | 1 | ARI | 2017 | 2019 | ||
24 | 24 | Yoshihisa Hirano | 35 | hiranyo01 | 2019 | ARI | NL | 1.914521955 | 0.066226415 | P | 3 | 1 | ARI | 2018 | 2019 | ||
27 | 27 | Jon Duplantier | 24 | duplajo01 | 2019 | ARI | NL | 0.931219169 | 0.254716981 | P | 2 | 1 | ARI | 2019 | 2019 | ||
28 | 28 | Josh Rojas | 25 | rojasjo01 | 2019 | ARI | NL | 1.42954275 | 0.071320755 | LF, RF, 2B | 2 | 1 | ARI | 2019 | 2019 | ||
30 | 30 | Taylor Clarke | 26 | clarkta01 | 2019 | ARI | NL | 2.273419989 | -0.27509434 | P | 2 | 1 | ARI | 2019 | 2019 | ||
31 | 31 | Jake Lamb | 28 | lambja01 | 2019 | ARI | NL | 2.168961414 | -0.382075472 | 3B, 1B | 2 | 1 | ARI | 2014 | 2019 | ||
32 | 32 | Domingo Leyba | 23 | leybado01 | 2019 | ARI | NL | 0.28590855 | 0.101886792 | 2B, SS, 3B | 1 | 1 | ARI | 2019 | 2019 | ||
33 | 33 | Kevin Cron | 26 | cronke01 | 2019 | ARI | NL | 0.749277579 | 0.066226415 | 1B, 3B | 1 | 1 | ARI | 2019 | 2019 | ||
35 | 35 | Jimmie Sherfy | 27 | sherfji01 | 2019 | ARI | NL | 0.531811654 | -0.061132075 | P | 1 | 1 | ARI | 2017 | 2019 | ||
37 | 37 | Zack Godley | 29 | godleza01 | 2019 | ARI | NL | 1.876806232 | -0.397358491 | P | 1 | 1 | ARI | 2015 | 2019 | TOR | |
39 | 39 | Joel Payamps | 25 | payamjo01 | 2019 | ARI | NL | 0.06585285 | 0.0 | P | 0 | 1 | ARI | 2019 | 2019 | ||
42 | 42 | Yasmany Tomas | 28 | tomasya01 | 2019 | ARI | NL | 0.059153493 | -0.198679245 | 0 | 1 | ARI | 2015 | 2019 | |||
43 | 43 | Matt Koch | 28 | kochma01 | 2019 | ARI | NL | 0.380449876 | -0.611320755 | P | 0 | 1 | ARI | 2016 | 2019 | ||
45 | 45 | Ronald Acuna Jr. | 21 | acunaro01 | 2019 | ATL | NL | 7.091313269 | 5.634339623 | CF, LF, RF | 29 | 1 | ATL | 2018 | 2019 | ||
47 | 47 | Ozzie Albies | 22 | albieoz01 | 2019 | ATL | NL | 6.823529412 | 5.028113208 | 2B | 27 | 1 | ATL | 2017 | 2019 | ||
48 | 48 | Freddie Freeman | 29 | freemfr01 | 2019 | ATL | NL | 6.754103967 | 4.406603774 | 1B | 25 | 1 | ATL | 2010 | 2019 | ||
49 | 49 | Mike Soroka | 21 | sorokmi01 | 2019 | ATL | NL | 4.798613093 | 4.773396226 | P | 23 | 1 | ATL | 2018 | 2019 | ||
50 | 50 | Max Fried | 25 | friedma01 | 2019 | ATL | NL | 4.630522227 | 3.097358491 | P | 17 | 1 | ATL | 2017 | 2019 | ||
51 | 51 | Julio Teheran | 28 | teherju01 | 2019 | ATL | NL | 4.940026052 | 1.971509434 | P | 15 | 1 | ATL | 2011 | 2019 | ||
52 | 52 | Dansby Swanson | 25 | swansda01 | 2019 | ATL | NL | 5.256497948 | 1.451886792 | SS | 14 | 1 | ATL | 2016 | 2019 | ||
61 | 61 | Sean Newcomb | 26 | newcose01 | 2019 | ATL | NL | 2.291491701 | 0.733584906 | P | 6 | 1 | ATL | 2017 | 2019 | ||
62 | 62 | Austin Riley | 22 | rileyau01 | 2019 | ATL | NL | 2.915868673 | 0.310754717 | LF, 1B, 3B, RF | 6 | 1 | ATL | 2019 | 2019 | ||
66 | 66 | Jacob Webb | 25 | webbja01 | 2019 | ATL | NL | 0.992297746 | 0.529811321 | P | 3 | 1 | ATL | 2019 | 2019 | ||
75 | 75 | Johan Camargo | 25 | camarjo01 | 2019 | ATL | NL | 2.459644323 | -0.662264151 | SS, 3B, LF, RF, 2B, 1B | 2 | 1 | ATL | 2017 | 2019 | ||
76 | 76 | Jeremy Walker | 24 | walkeje02 | 2019 | ATL | NL | 0.164279736 | 0.152830189 | P | 1 | 1 | ATL | 2019 | 2019 | ||
79 | 79 | Wes Parsons | 26 | parsowe01 | 2019 | ATL | NL | 0.507481968 | -0.045849057 | P | 1 | 1 | ATL | 2018 | 2019 | COL | |
81 | 81 | Touki Toussaint | 23 | toussto01 | 2019 | ATL | NL | 1.316344038 | -0.40245283 | P | 1 | 1 | ATL | 2018 | 2019 | ||
82 | 82 | A.J. Minter | 25 | minteaj01 | 2019 | ATL | NL | 1.054679916 | -0.448301887 | P | 1 | 1 | ATL | 2017 | 2019 | ||
85 | 85 | Huascar Ynoa | 21 | ynoahu01 | 2019 | ATL | NL | 0.047839703 | -0.091698113 | P | 0 | 1 | ATL | 2019 | 2019 | ||
87 | 87 | Jesse Biddle | 27 | biddlje01 | 2019 | ATL | NL | 0.328208447 | -0.219056604 | P | 0 | 1 | ATL | 2018 | 2019 | SEA | |
88 | 88 | Dan Winkler | 29 | winklda01 | 2019 | ATL | NL | 0.75294879 | -0.285283019 | P | 0 | 1 | ATL | 2015 | 2019 | ||
89 | 89 | Alex Jackson | 23 | jacksal02 | 2019 | ATL | NL | 0.14876881 | -0.326037736 | C | 0 | 1 | ATL | 2019 | 2019 | ||
90 | 90 | Bryse Wilson | 21 | wilsobr02 | 2019 | ATL | NL | 0.511493683 | -0.326037736 | P | 0 | 1 | ATL | 2018 | 2019 | ||
92 | 92 | Chad Sobotka | 25 | sobotch01 | 2019 | ATL | NL | 0.780930503 | -0.422830189 | P | 0 | 1 | ATL | 2018 | 2019 | ||
93 | 93 | Kyle Wright | 23 | wrighky01 | 2019 | ATL | NL | 0.45563055 | -0.453396226 | P | 0 | 1 | ATL | 2018 | 2019 | ||
96 | 96 | John Means | 26 | meansjo01 | 2019 | BAL | AL | 4.629510501 | 4.019433962 | P | 17 | 1 | BAL | 2018 | 2019 | ||
97 | 97 | Trey Mancini | 27 | mancitr01 | 2019 | BAL | AL | 6.375206612 | 3.357169811 | RF, 1B, LF | 17 | 1 | BAL | 2016 | 2019 | ||
99 | 99 | Dylan Bundy | 26 | bundydy01 | 2019 | BAL | AL | 4.712384454 | 2.445283019 | P | 13 | 1 | BAL | 2012 | 2019 | ||
102 | 102 | Anthony Santander | 24 | santaan02 | 2019 | BAL | AL | 3.882644628 | 1.018867925 | RF, LF, CF | 8 | 1 | BAL | 2017 | 2019 | ||
108 | 108 | Mychal Givens | 29 | givenmy01 | 2019 | BAL | AL | 2.519731894 | 0.438113208 | P | 4 | 1 | BAL | 2015 | 2019 | ||
109 | 109 | Austin Hays | 23 | haysau01 | 2019 | BAL | AL | 0.632727273 | 0.748867925 | CF | 3 | 1 | BAL | 2017 | 2019 | ||
112 | 112 | Paul Fry | 26 | frypa01 | 2019 | BAL | AL | 2.167920271 | -0.00509434 | P | 3 | 1 | BAL | 2018 | 2019 | ||
114 | 114 | Joey Rickard | 28 | rickajo01 | 2019 | BAL | AL | 1.294214876 | 0.091698113 | RF, LF, CF | 2 | 1 | BAL | 2016 | 2019 | SFG | |
115 | 115 | Chance Sisco | 24 | siscoch01 | 2019 | BAL | AL | 1.859834711 | -0.117169811 | C, 1B | 2 | 1 | BAL | 2017 | 2019 | ||
117 | 117 | Hunter Harvey | 24 | harvehu01 | 2019 | BAL | AL | 0.228046258 | 0.208867925 | P | 1 | 1 | BAL | 2019 | 2019 | ||
121 | 121 | Austin Wynns | 28 | wynnsau01 | 2019 | BAL | AL | 0.632727273 | -0.025471698 | C | 1 | 1 | BAL | 2018 | 2019 | ||
122 | 122 | Tanner Scott | 24 | scottta01 | 2019 | BAL | AL | 0.62672453 | -0.035660377 | P | 1 | 1 | BAL | 2017 | 2019 | ||
123 | 123 | Dillon Tate | 25 | tatedi01 | 2019 | BAL | AL | 0.656081135 | -0.071320755 | P | 1 | 1 | BAL | 2019 | 2019 | ||
125 | 125 | Branden Kline | 27 | klinebr01 | 2019 | BAL | AL | 1.295119851 | -0.168113208 | P | 1 | 1 | BAL | 2019 | 2019 | ||
126 | 126 | Stevie Wilkerson | 27 | wilkest01 | 2019 | BAL | AL | 3.374545455 | -0.830377358 | CF, LF, 2B, RF, P | 1 | 1 | BAL | 2018 | 2019 | ||
130 | 130 | Drew Jackson | 25 | jacksdr01 | 2019 | BAL | AL | 0.038347107 | -0.066226415 | CF, LF | 0 | 1 | BAL | 2019 | 2019 | ||
131 | 131 | Pedro Araujo | 25 | araujpe01 | 2019 | BAL | AL | 0.011846559 | -0.091698113 | P | 0 | 1 | BAL | 2018 | 2019 | ||
134 | 134 | Yefry Ramirez | 25 | ramirye01 | 2019 | BAL | AL | 0.326975416 | -0.13754717 | P | 0 | 1 | BAL | 2018 | 2019 | PIT | |
135 | 135 | Luis Ortiz | 23 | ortizlu02 | 2019 | BAL | AL | 0.097162566 | -0.163018868 | P | 0 | 1 | BAL | 2018 | 2019 | ||
136 | 136 | Chandler Shepherd | 26 | shephch01 | 2019 | BAL | AL | 0.351343996 | -0.183396226 | P | 0 | 1 | BAL | 2019 | 2019 | ||
139 | 139 | Jimmy Yacabonis | 27 | yacabji01 | 2019 | BAL | AL | 1.073672334 | -0.295471698 | P | 0 | 1 | BAL | 2017 | 2019 | ||
140 | 140 | Matt Wotherspoon | 27 | wothema01 | 2019 | BAL | AL | 0.148393737 | -0.305660377 | P | 0 | 1 | BAL | 2019 | 2019 | ||
141 | 141 | Mike Wright | 29 | wrighmi01 | 2019 | BAL | AL | 0.332534985 | -0.310754717 | P | 0 | 1 | BAL | 2015 | 2019 | SEA | |
142 | 142 | Josh Rogers | 24 | rogerjo01 | 2019 | BAL | AL | 0.290448526 | -0.356603774 | P | 0 | 1 | BAL | 2018 | 2019 | ||
143 | 143 | Tom Eshelman | 25 | eshelto01 | 2019 | BAL | AL | 0.864175293 | -0.40245283 | P | 0 | 1 | BAL | 2019 | 2019 | ||
147 | 147 | DJ Stewart | 25 | stewadj01 | 2019 | BAL | AL | 1.275041322 | -0.652075472 | RF, LF | 0 | 1 | BAL | 2018 | 2019 | ||
148 | 148 | Cedric Mullins | 24 | mullice01 | 2019 | BAL | AL | 0.709421488 | -0.779433962 | CF | 0 | 1 | BAL | 2018 | 2019 | ||
149 | 149 | David Hess | 25 | hessda01 | 2019 | BAL | AL | 2.119910532 | -0.988301887 | P | 0 | 1 | BAL | 2018 | 2019 | ||
150 | 150 | Richie Martin | 24 | martiri01 | 2019 | BAL | AL | 2.885619835 | -1.039245283 | SS | 0 | 1 | BAL | 2019 | 2019 | ||
153 | 153 | Mookie Betts | 26 | bettsmo01 | 2019 | BOS | AL | 6.374329864 | 6.816226415 | RF, CF | 28 | 1 | BOS | 2014 | 2019 | ||
154 | 154 | Xander Bogaerts | 26 | bogaexa01 | 2019 | BOS | AL | 6.264585304 | 5.766792453 | SS | 25 | 1 | BOS | 2013 | 2019 | ||
155 | 155 | Rafael Devers | 22 | deverra01 | 2019 | BOS | AL | 6.292021444 | 5.476415094 | 3B, SS | 24 | 1 | BOS | 2017 | 2019 | ||
156 | 156 | Eduardo Rodriguez | 26 | rodried05 | 2019 | BOS | AL | 5.476864245 | 4.564528302 | P | 20 | 1 | BOS | 2015 | 2019 | ||
159 | 159 | Christian Vazquez | 28 | vazquch01 | 2019 | BOS | AL | 4.719016083 | 2.863018868 | C, 1B, 3B, 2B | 14 | 1 | BOS | 2014 | 2019 | ||
160 | 160 | Andrew Benintendi | 24 | beninan01 | 2019 | BOS | AL | 5.624408704 | 1.88490566 | LF, CF | 12 | 1 | BOS | 2016 | 2019 | ||
161 | 161 | Jackie Bradley Jr. | 29 | bradlja02 | 2019 | BOS | AL | 5.075685904 | 1.849245283 | CF, RF | 12 | 1 | BOS | 2013 | 2019 | ||
162 | 162 | Brandon Workman | 30 | workmbr01 | 2019 | BOS | AL | 2.698676959 | 2.56245283 | P | 11 | 1 | BOS | 2013 | 2019 | ||
166 | 166 | Matt Barnes | 29 | barnema01 | 2019 | BOS | AL | 2.560341919 | 1.253207547 | P | 7 | 1 | BOS | 2014 | 2019 | ||
168 | 168 | Michael Chavis | 23 | chavimi01 | 2019 | BOS | AL | 3.493535162 | 0.871132075 | 1B, 2B, 3B | 7 | 1 | BOS | 2019 | 2019 | ||
169 | 169 | Marcus Walden | 30 | waldema01 | 2019 | BOS | AL | 2.572972077 | 1.130943396 | P | 6 | 1 | BOS | 2018 | 2019 | ||
170 | 170 | Josh Taylor | 26 | taylojo02 | 2019 | BOS | AL | 1.489861421 | 1.146226415 | P | 5 | 1 | BOS | 2019 | 2019 | ||
173 | 173 | Travis Lakins | 25 | lakintr01 | 2019 | BOS | AL | 0.605650895 | 0.326037736 | P | 2 | 1 | BOS | 2019 | 2019 | ||
174 | 174 | Darwinzon Hernandez | 22 | hernada02 | 2019 | BOS | AL | 0.787346163 | 0.310754717 | P | 2 | 1 | BOS | 2019 | 2019 | ||
177 | 177 | Hector Velazquez | 30 | velazhe01 | 2019 | BOS | AL | 1.287679439 | 0.081509434 | P | 2 | 1 | BOS | 2017 | 2019 | ||
181 | 181 | Brian Johnson | 28 | johnsbr02 | 2019 | BOS | AL | 1.070977748 | -0.101886792 | P | 1 | 1 | BOS | 2015 | 2019 | ||
182 | 182 | Marco Hernandez | 26 | hernama02 | 2019 | BOS | AL | 1.390097761 | -0.295471698 | 2B, SS | 1 | 1 | BOS | 2016 | 2019 | ||
184 | 184 | Tzu-Wei Lin | 25 | lintz02 | 2019 | BOS | AL | 0.20119836 | 0.00509434 | 2B, SS, CF | 0 | 1 | BOS | 2017 | 2019 | ||
185 | 185 | Blake Swihart | 27 | swihabl01 | 2019 | BOS | AL | 0.26521602 | 0.0 | LF, RF, C, 1B | 0 | 1 | BOS | 2015 | 2019 | ARI | |
187 | 187 | Bobby Poyner | 26 | poynebo01 | 2019 | BOS | AL | 0.32291436 | -0.086603774 | P | 0 | 1 | BOS | 2018 | 2019 | ||
191 | 191 | Steven Wright | 34 | wrighst01 | 2019 | BOS | AL | 0.136047689 | -0.203773585 | P | 0 | 1 | BOS | 2013 | 2019 | ||
193 | 193 | Trevor Kelley | 25 | kelletr01 | 2019 | BOS | AL | 0.282189559 | -0.254716981 | P | 0 | 1 | BOS | 2019 | 2019 | ||
194 | 194 | Mike Shawaryn | 24 | shawami01 | 2019 | BOS | AL | 0.470150181 | -0.40245283 | P | 0 | 1 | BOS | 2019 | 2019 | ||
195 | 195 | Dustin Pedroia | 35 | pedrodu01 | 2019 | BOS | AL | 0.19205298 | -0.443207547 | 2B | 0 | 1 | BOS | 2006 | 2019 | ||
197 | 197 | Sam Travis | 25 | travisa01 | 2019 | BOS | AL | 1.371807001 | -0.67245283 | 1B, LF, RF | 0 | 1 | BOS | 2017 | 2019 | ||
200 | 200 | Javier Baez | 26 | baezja01 | 2019 | CHC | NL | 5.672594142 | 4.72245283 | SS, 3B | 21 | 1 | CHC | 2014 | 2019 | ||
201 | 201 | Kris Bryant | 27 | bryankr01 | 2019 | CHC | NL | 6.410739191 | 4.279245283 | 3B, RF, LF, 1B | 21 | 1 | CHC | 2015 | 2019 | ||
203 | 203 | Kyle Hendricks | 29 | hendrky01 | 2019 | CHC | NL | 4.961144891 | 4.156981132 | P | 18 | 1 | CHC | 2014 | 2019 |
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 );