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
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | Renato Nunez | 25 | nunezre01 | 2019 | BAL | AL | 5.608264463 | 0.825283019 | 1B, 3B, LF | 9 | 1 | BAL | TEX | 2018 | 2019 | |
102 | 102 | Anthony Santander | 24 | santaan02 | 2019 | BAL | AL | 3.882644628 | 1.018867925 | RF, LF, CF | 8 | 1 | BAL | 2017 | 2019 | ||
103 | 103 | Pedro Severino | 25 | severpe01 | 2019 | BAL | AL | 3.269090909 | 0.886415094 | C | 6 | 1 | BAL | WSN | 2019 | 2019 | |
104 | 104 | Rio Ruiz | 25 | ruizri01 | 2019 | BAL | AL | 3.863471074 | 0.590943396 | 3B, 1B, 2B | 6 | 1 | BAL | ATL | 2019 | 2019 | |
105 | 105 | Asher Wojciechowski | 30 | wojcias01 | 2019 | BAL | AL | 2.165530176 | 0.820188679 | P | 5 | 1 | BAL | CIN | 2019 | 2019 | |
106 | 106 | Shawn Armstrong | 28 | armstsh01 | 2019 | BAL | AL | 1.898930643 | 0.53490566 | P | 4 | 2 | BAL | SEA | 2019 | 2019 | |
107 | 107 | Miguel Castro | 24 | castrmi01 | 2019 | BAL | AL | 2.240454464 | 0.499245283 | P | 4 | 1 | BAL | COL | 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 | ||
110 | 110 | Richard Bleier | 32 | bleieri01 | 2019 | BAL | AL | 1.627498961 | 0.361698113 | P | 3 | 1 | BAL | NYY | 2017 | 2019 | |
111 | 111 | Aaron Brooks | 29 | brookaa01 | 2019 | BAL | AL | 1.720608757 | 0.27 | P | 3 | 2 | BAL | OAK | 2019 | 2019 | |
112 | 112 | Paul Fry | 26 | frypa01 | 2019 | BAL | AL | 2.167920271 | -0.00509434 | P | 3 | 1 | BAL | 2018 | 2019 | ||
113 | 113 | Gabriel Ynoa | 26 | ynoaga01 | 2019 | BAL | AL | 3.122295679 | -0.219056604 | P | 3 | 1 | BAL | NYM | 2017 | 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 | ||
116 | 116 | Dwight Smith Jr. | 26 | smithdw02 | 2019 | BAL | AL | 3.719669421 | -0.799811321 | LF | 2 | 1 | BAL | TOR | 2019 | 2019 | |
117 | 117 | Hunter Harvey | 24 | harvehu01 | 2019 | BAL | AL | 0.228046258 | 0.208867925 | P | 1 | 1 | BAL | 2019 | 2019 | ||
118 | 118 | Nate Karns | 31 | karnsna01 | 2019 | BAL | AL | 0.127194632 | 0.193584906 | P | 1 | 1 | BAL | KCR | 2019 | 2019 | |
119 | 119 | Evan Phillips | 24 | phillev01 | 2019 | BAL | AL | 0.706013341 | 0.112075472 | P | 1 | 1 | BAL | ATL | 2018 | 2019 | |
120 | 120 | Keon Broxton | 29 | broxtke01 | 2019 | BAL | AL | 1.073719008 | 0.071320755 | CF, LF, RF | 1 | 2 | BAL | NYM | 2019 | 2019 | SEA |
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 | ||
124 | 124 | Jace Peterson | 29 | peterja01 | 2019 | BAL | AL | 1.035371901 | -0.157924528 | LF, 3B, 2B, RF | 1 | 1 | BAL | NYY | 2018 | 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 | ||
127 | 127 | Josh Lucas | 28 | lucasjo02 | 2019 | BAL | AL | 0.317466994 | 0.040754717 | P | 0 | 1 | BAL | OAK | 2019 | 2019 | |
128 | 128 | Ryan Eades | 27 | eadesry01 | 2019 | BAL | AL | 0.3740499 | 0.010188679 | P | 0 | 2 | BAL | MIN | 2019 | 2019 | |
129 | 129 | Jose Rondon | 25 | rondojo02 | 2019 | BAL | AL | 0.009586777 | -0.015283019 | 2B, SS, 3B, LF, 1B, P | 0 | 2 | BAL | CHW | 2019 | 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 | ||
132 | 132 | Mason Williams | 27 | willima10 | 2019 | BAL | AL | 0.325950413 | -0.091698113 | CF, LF, RF | 0 | 1 | BAL | CIN | 2019 | 2019 | |
133 | 133 | Jesus Sucre | 31 | sucreje01 | 2019 | BAL | AL | 0.64231405 | -0.101886792 | C, 1B, P | 0 | 1 | BAL | TBD | 2019 | 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 | ||
137 | 137 | Mark Trumbo | 33 | trumbma01 | 2019 | BAL | AL | 0.258842975 | -0.193584906 | 0 | 1 | BAL | SEA | 2016 | 2019 | ||
138 | 138 | Sean Gilmartin | 29 | gilmase01 | 2019 | BAL | AL | 0.066195246 | -0.219056604 | P | 0 | 1 | BAL | NYM | 2018 | 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 | ||
144 | 144 | Tayler Scott | 27 | scottta02 | 2019 | BAL | AL | 0.148601572 | -0.427924528 | P | 0 | 2 | BAL | SEA | 2019 | 2019 | |
145 | 145 | Ty Blach | 28 | blachty01 | 2019 | BAL | AL | 0.60240791 | -0.468679245 | P | 0 | 2 | BAL | SFG | 2019 | 2019 | |
146 | 146 | Alex Cobb | 31 | cobbal01 | 2019 | BAL | AL | 0.359501494 | -0.514528302 | P | 0 | 1 | BAL | TBD | 2018 | 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 | ||
151 | 151 | Dan Straily | 30 | straida01 | 2019 | BAL | AL | 1.248253202 | -1.21245283 | P | 0 | 1 | BAL | FLA | 2019 | 2019 | |
152 | 152 | Chris Davis | 33 | davisch02 | 2019 | BAL | AL | 3.32661157 | -1.21754717 | 1B, P, RF | 0 | 1 | BAL | TEX | 2011 | 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 | ||
157 | 157 | J.D. Martinez | 31 | martijd02 | 2019 | BOS | AL | 5.926206244 | 3.24 | RF, LF | 17 | 1 | BOS | ARI | 2018 | 2019 | |
158 | 158 | Chris Sale | 30 | salech01 | 2019 | BOS | AL | 4.131951293 | 2.97509434 | P | 14 | 1 | BOS | CHW | 2017 | 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 | ||
163 | 163 | David Price | 33 | priceda01 | 2019 | BOS | AL | 2.994143102 | 2.15490566 | P | 10 | 1 | BOS | TOR | 2016 | 2019 | |
164 | 164 | Rick Porcello | 30 | porceri01 | 2019 | BOS | AL | 4.863157895 | 1.380566038 | P | 10 | 1 | BOS | DET | 2015 | 2019 | |
165 | 165 | Brock Holt | 31 | holtbr01 | 2019 | BOS | AL | 2.597287922 | 1.309245283 | 2B, 1B, RF, SS, 3B, LF | 7 | 1 | BOS | PIT | 2013 | 2019 | |
166 | 166 | Matt Barnes | 29 | barnema01 | 2019 | BOS | AL | 2.560341919 | 1.253207547 | P | 7 | 1 | BOS | 2014 | 2019 | ||
167 | 167 | Mitch Moreland | 33 | morelmi01 | 2019 | BOS | AL | 2.990539262 | 1.136037736 | 1B | 7 | 1 | BOS | TEX | 2017 | 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 | ||
171 | 171 | Colten Brewer | 26 | breweco01 | 2019 | BOS | AL | 1.475490887 | 0.336226415 | P | 3 | 1 | BOS | SDP | 2019 | 2019 | |
172 | 172 | Ryan Brasier | 31 | brasiry01 | 2019 | BOS | AL | 1.826698791 | 0.193584906 | P | 3 | 1 | BOS | ANA | 2018 | 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 | ||
175 | 175 | Ryan Weber | 28 | weberry01 | 2019 | BOS | AL | 0.982765541 | 0.254716981 | P | 2 | 1 | BOS | TBD | 2019 | 2019 | |
176 | 176 | Heath Hembree | 30 | hembrhe01 | 2019 | BOS | AL | 1.078635403 | 0.198679245 | P | 2 | 1 | BOS | SFG | 2014 | 2019 | |
177 | 177 | Hector Velazquez | 30 | velazhe01 | 2019 | BOS | AL | 1.287679439 | 0.081509434 | P | 2 | 1 | BOS | 2017 | 2019 | ||
178 | 178 | Andrew Cashner | 32 | cashnan01 | 2019 | BOS | AL | 1.660020482 | 0.035660377 | P | 2 | 2 | BOS | BAL | 2019 | 2019 | |
179 | 179 | Nathan Eovaldi | 29 | eovalna01 | 2019 | BOS | AL | 1.8416163 | -0.076415094 | P | 2 | 1 | BOS | TBD | 2018 | 2019 | |
180 | 180 | Jhoulys Chacin | 31 | chacijh01 | 2019 | BOS | AL | 0.315057805 | 0.081509434 | P | 1 | 2 | BOS | MIL | 2019 | 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 | ||
183 | 183 | Sandy Leon | 30 | leonsa01 | 2019 | BOS | AL | 1.710186061 | -0.346415094 | C, 1B | 1 | 1 | BOS | WSN | 2015 | 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 | |
186 | 186 | Juan Centeno | 29 | centeju01 | 2019 | BOS | AL | 0.1371807 | -0.00509434 | C | 0 | 1 | BOS | TEX | 2019 | 2019 | |
187 | 187 | Bobby Poyner | 26 | poynebo01 | 2019 | BOS | AL | 0.32291436 | -0.086603774 | P | 0 | 1 | BOS | 2018 | 2019 | ||
188 | 188 | Erasmo Ramirez | 29 | ramirer02 | 2019 | BOS | AL | 0.052360459 | -0.091698113 | P | 0 | 1 | BOS | SEA | 2019 | 2019 | |
189 | 189 | Tyler Thornburg | 30 | thornty01 | 2019 | BOS | AL | 0.328583014 | -0.147735849 | P | 0 | 1 | BOS | MIL | 2018 | 2019 | |
190 | 190 | Chris Owings | 27 | owingch01 | 2019 | BOS | AL | 0.44812362 | -0.152830189 | 2B, 3B, CF, SS, RF, LF, P | 0 | 2 | BOS | KCR | 2019 | 2019 | |
191 | 191 | Steven Wright | 34 | wrighst01 | 2019 | BOS | AL | 0.136047689 | -0.203773585 | P | 0 | 1 | BOS | 2013 | 2019 | ||
192 | 192 | Josh Smith | 31 | smithjo07 | 2019 | BOS | AL | 0.687846373 | -0.229245283 | P | 0 | 1 | BOS | OAK | 2019 | 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 | ||
196 | 196 | Gorkys Hernandez | 31 | hernago01 | 2019 | BOS | AL | 0.42983286 | -0.560377358 | LF, RF, CF | 0 | 1 | BOS | SFG | 2019 | 2019 | |
197 | 197 | Sam Travis | 25 | travisa01 | 2019 | BOS | AL | 1.371807001 | -0.67245283 | 1B, LF, RF | 0 | 1 | BOS | 2017 | 2019 | ||
198 | 198 | Steve Pearce | 36 | pearcst01 | 2019 | BOS | AL | 0.905392621 | -0.759056604 | 1B, LF | 0 | 1 | BOS | TOR | 2018 | 2019 | |
199 | 199 | Eduardo Nunez | 32 | nunezed02 | 2019 | BOS | AL | 1.591296121 | -1.334716981 | 2B, 3B, SS, P | 0 | 1 | BOS | SFG | 2017 | 2019 | |
200 | 200 | Javier Baez | 26 | baezja01 | 2019 | CHC | NL | 5.672594142 | 4.72245283 | SS, 3B | 21 | 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 );