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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
201 | 201 | Kris Bryant | 27 | bryankr01 | 2019 | CHC | NL | 6.410739191 | 4.279245283 | 3B, RF, LF, 1B | 21 | 1 | CHC | 2015 | 2019 | ||
202 | 202 | Anthony Rizzo | 29 | rizzoan01 | 2019 | CHC | NL | 6.198396095 | 4.029622642 | 1B | 20 | 1 | CHC | SDP | 2012 | 2019 | |
203 | 203 | Kyle Hendricks | 29 | hendrky01 | 2019 | CHC | NL | 4.961144891 | 4.156981132 | P | 18 | 1 | CHC | 2014 | 2019 | ||
204 | 204 | Kyle Schwarber | 26 | schwaky01 | 2019 | CHC | NL | 6.056834031 | 2.394339623 | LF, C | 15 | 1 | CHC | 2015 | 2019 | ||
205 | 205 | Willson Contreras | 27 | contrwi01 | 2019 | CHC | NL | 4.05474198 | 3.092264151 | C, 1B, RF, LF | 14 | 1 | CHC | 2016 | 2019 | ||
206 | 206 | Yu Darvish | 32 | darviyu01 | 2019 | CHC | NL | 5.034783981 | 2.745849057 | P | 14 | 1 | CHC | LAD | 2018 | 2019 | |
207 | 207 | Jon Lester | 35 | lestejo01 | 2019 | CHC | NL | 4.837525654 | 2.470754717 | P | 13 | 1 | CHC | OAK | 2015 | 2019 | |
208 | 208 | Jason Heyward | 29 | heywaja01 | 2019 | CHC | NL | 5.955718271 | 1.986792453 | RF, CF | 13 | 1 | CHC | STL | 2016 | 2019 | |
209 | 209 | Cole Hamels | 35 | hamelco01 | 2019 | CHC | NL | 3.900159305 | 2.384150943 | P | 12 | 1 | CHC | TEX | 2018 | 2019 | |
210 | 210 | Jose Quintana | 30 | quintjo01 | 2019 | CHC | NL | 4.870276464 | 2.047924528 | P | 12 | 1 | CHC | CHW | 2017 | 2019 | |
211 | 211 | David Bote | 26 | boteda01 | 2019 | CHC | NL | 3.528940028 | 1.696415094 | 3B, 2B, SS, RF | 9 | 1 | CHC | 2018 | 2019 | ||
212 | 212 | Nicholas Castellanos | 27 | casteni01 | 2019 | CHC | NL | 2.275104603 | 1.686226415 | RF, LF | 8 | 2 | CHC | DET | 2019 | 2019 | |
213 | 213 | Victor Caratini | 25 | caratvi01 | 2019 | CHC | NL | 2.689679219 | 1.095283019 | C, 1B, 3B, P | 7 | 1 | CHC | 2017 | 2019 | ||
214 | 214 | Kyle Ryan | 27 | ryanky01 | 2019 | CHC | NL | 2.01628451 | 1.222641509 | P | 6 | 1 | CHC | DET | 2019 | 2019 | |
215 | 215 | Brandon Kintzler | 34 | kintzbr01 | 2019 | CHC | NL | 1.897989791 | 1.21245283 | P | 6 | 1 | CHC | WSN | 2018 | 2019 | |
216 | 216 | Tyler Chatwood | 29 | chatwty01 | 2019 | CHC | NL | 2.483937943 | 1.110566038 | P | 6 | 1 | CHC | COL | 2018 | 2019 | |
217 | 217 | Steve Cishek | 33 | cishest01 | 2019 | CHC | NL | 2.207414619 | 0.983207547 | P | 6 | 1 | CHC | TBD | 2018 | 2019 | |
218 | 218 | Ian Happ | 24 | happia01 | 2019 | CHC | NL | 1.44595537 | 0.667358491 | LF, 2B, CF, 1B, RF, 3B | 4 | 1 | CHC | 2017 | 2019 | ||
219 | 219 | Addison Russell | 25 | russead02 | 2019 | CHC | NL | 2.366108787 | 0.249622642 | 2B, SS | 4 | 1 | CHC | 2015 | 2019 | ||
220 | 220 | Rowan Wick | 26 | wickro01 | 2019 | CHC | NL | 1.064200389 | 0.718301887 | P | 3 | 1 | CHC | SDP | 2019 | 2019 | |
221 | 221 | Alec Mills | 27 | millsal02 | 2019 | CHC | NL | 0.710069702 | 0.509433962 | P | 2 | 1 | CHC | KCR | 2018 | 2019 | |
222 | 222 | Ben Zobrist | 38 | zobribe01 | 2019 | CHC | NL | 1.69874477 | 0.091698113 | 2B, RF, LF | 2 | 1 | CHC | KCR | 2016 | 2019 | |
223 | 223 | Pedro Strop | 34 | stroppe01 | 2019 | CHC | NL | 1.297122942 | 0.050943396 | P | 2 | 1 | CHC | BAL | 2013 | 2019 | |
224 | 224 | Albert Almora | 25 | almoral01 | 2019 | CHC | NL | 3.630055788 | -0.830377358 | CF | 2 | 1 | CHC | 2016 | 2019 | ||
225 | 225 | Brad Wieck | 27 | wieckbr01 | 2019 | CHC | NL | 0.319019007 | 0.356603774 | P | 1 | 2 | CHC | SDP | 2019 | 2019 | |
226 | 226 | Nico Hoerner | 22 | hoernni01 | 2019 | CHC | NL | 0.697698745 | 0.198679245 | SS | 1 | 1 | CHC | 2019 | 2019 | ||
227 | 227 | Derek Holland | 32 | hollade01 | 2019 | CHC | NL | 0.43249152 | 0.188490566 | P | 1 | 2 | CHC | SFG | 2019 | 2019 | |
228 | 228 | Danny Hultzen | 29 | hultzda01 | 2019 | CHC | NL | 0.085393215 | 0.152830189 | P | 1 | 1 | CHC | 2019 | 2019 | ||
229 | 229 | Duane Underwood Jr. | 24 | underdu01 | 2019 | CHC | NL | 0.230159831 | 0.13245283 | P | 1 | 1 | CHC | 2018 | 2019 | ||
230 | 230 | David Phelps | 32 | phelpda01 | 2019 | CHC | NL | 0.512962068 | 0.127358491 | P | 1 | 2 | CHC | TOR | 2019 | 2019 | |
231 | 231 | Tim Collins | 29 | colliti01 | 2019 | CHC | NL | 0.241612568 | 0.096792453 | P | 1 | 1 | CHC | WSN | 2019 | 2019 | |
232 | 232 | Brad Brach | 33 | brachbr01 | 2019 | CHC | NL | 1.189527491 | -0.020377358 | P | 1 | 1 | CHC | ATL | 2019 | 2019 | NYM |
233 | 233 | Robel Garcia | 26 | garciro02 | 2019 | CHC | NL | 0.758368201 | -0.030566038 | 2B, LF, RF | 1 | 1 | CHC | 2019 | 2019 | ||
234 | 234 | Tony Kemp | 27 | kempto01 | 2019 | CHC | NL | 0.788702929 | -0.091698113 | 2B, LF, CF | 1 | 2 | CHC | HOU | 2019 | 2019 | |
235 | 235 | Xavier Cedeno | 32 | cedenxa01 | 2019 | CHC | NL | 0.055455359 | 0.071320755 | P | 0 | 1 | CHC | MIL | 2019 | 2019 | |
236 | 236 | James Norwood | 25 | norwoja01 | 2019 | CHC | NL | 0.164658212 | 0.010188679 | P | 0 | 1 | CHC | 2018 | 2019 | ||
237 | 237 | Tony Barnette | 35 | barneto01 | 2019 | CHC | NL | 0.031746184 | -0.061132075 | P | 0 | 1 | CHC | TEX | 2019 | 2019 | |
238 | 238 | Allen Webster | 29 | webstal01 | 2019 | CHC | NL | 0.298373941 | -0.081509434 | P | 0 | 1 | CHC | ARI | 2018 | 2019 | |
239 | 239 | Taylor Davis | 29 | davista01 | 2019 | CHC | NL | 0.20223152 | -0.106981132 | C, 1B, P | 0 | 1 | CHC | 2017 | 2019 | ||
240 | 240 | Randy Rosario | 25 | rosarra01 | 2019 | CHC | NL | 0.295761913 | -0.117169811 | P | 0 | 1 | CHC | MIN | 2018 | 2019 | KCR |
241 | 241 | Jim Adduci | 34 | adducji02 | 2019 | CHC | NL | 0.05055788 | -0.122264151 | RF | 0 | 1 | CHC | DET | 2019 | 2019 | |
242 | 242 | Dillon Maples | 27 | mapledi01 | 2019 | CHC | NL | 0.279687896 | -0.127358491 | P | 0 | 1 | CHC | 2017 | 2019 | ||
243 | 243 | Jonathan Lucroy | 33 | lucrojo01 | 2019 | CHC | NL | 0.546025105 | -0.152830189 | C, 1B | 0 | 2 | CHC | ANA | 2019 | 2019 | |
244 | 244 | Carl Edwards Jr. | 27 | edwarca01 | 2019 | CHC | NL | 0.496787589 | -0.168113208 | P | 0 | 1 | CHC | 2015 | 2019 | SDP | |
245 | 245 | Mark Zagunis | 26 | zagunma01 | 2019 | CHC | NL | 0.40446304 | -0.208867925 | RF, LF | 0 | 1 | CHC | 2017 | 2019 | ||
246 | 246 | Martin Maldonado | 32 | maldoma01 | 2019 | CHC | NL | 0.131450488 | -0.244528302 | C, 1B | 0 | 2 | CHC | KCR | 2019 | 2019 | HOU |
247 | 247 | Adbert Alzolay | 24 | alzolad01 | 2019 | CHC | NL | 0.308520664 | -0.27 | P | 0 | 1 | CHC | 2019 | 2019 | ||
248 | 248 | Carlos Gonzalez | 33 | gonzaca01 | 2019 | CHC | NL | 0.495467225 | -0.371886792 | LF, RF | 0 | 2 | CHC | CLE | 2019 | 2019 | |
249 | 249 | Mike Montgomery | 29 | montgmi01 | 2019 | CHC | NL | 0.923602972 | -0.387169811 | P | 0 | 1 | CHC | SEA | 2016 | 2019 | KCR |
250 | 250 | Craig Kimbrel | 31 | kimbrcr01 | 2019 | CHC | NL | 0.853329379 | -0.769245283 | P | 0 | 1 | CHC | BOS | 2019 | 2019 | |
251 | 251 | Daniel Descalso | 32 | descada01 | 2019 | CHC | NL | 1.941422594 | -1.151320755 | 2B, 3B, 1B, P | 0 | 1 | CHC | ARI | 2019 | 2019 | |
252 | 252 | Lucas Giolito | 24 | giolilu01 | 2019 | CHW | AL | 5.336638701 | 5.598227848 | P | 24 | 1 | CHW | WSN | 2017 | 2019 | |
253 | 253 | Yoan Moncada | 24 | moncayo01 | 2019 | CHW | AL | 5.392156863 | 4.880506329 | 3B | 22 | 1 | CHW | BOS | 2017 | 2019 | |
254 | 254 | Tim Anderson | 26 | anderti01 | 2019 | CHW | AL | 5.019607843 | 3.942341772 | SS | 19 | 1 | CHW | 2016 | 2019 | ||
255 | 255 | James McCann | 29 | mccanja02 | 2019 | CHW | AL | 4.62745098 | 3.034936709 | C | 16 | 1 | CHW | DET | 2019 | 2019 | |
256 | 256 | Jose Abreu | 32 | abreujo02 | 2019 | CHW | AL | 6.68627451 | 2.107025316 | 1B | 16 | 1 | CHW | 2014 | 2019 | ||
257 | 257 | Ivan Nova | 32 | novaiv01 | 2019 | CHW | AL | 5.468501452 | 1.978860759 | P | 14 | 1 | CHW | PIT | 2019 | 2019 | |
258 | 258 | Leury Garcia | 28 | garcile02 | 2019 | CHW | AL | 5.970588235 | 1.384177215 | CF, RF, LF, SS, 2B, 3B | 13 | 1 | CHW | TEX | 2013 | 2019 | |
259 | 259 | Yolmer Sanchez | 27 | sanchca01 | 2019 | CHW | AL | 5.323529412 | 1.594367089 | 2B | 12 | 1 | CHW | 2014 | 2019 | ||
260 | 260 | Eloy Jimenez | 22 | jimenel02 | 2019 | CHW | AL | 4.823529412 | 1.50721519 | LF | 11 | 1 | CHW | 2019 | 2019 | ||
261 | 261 | Reynaldo Lopez | 25 | lopezre01 | 2019 | CHW | AL | 5.288221184 | 1.209873418 | P | 11 | 1 | CHW | WSN | 2017 | 2019 | |
262 | 262 | Aaron Bummer | 25 | bummeaa01 | 2019 | CHW | AL | 2.514497328 | 1.932721519 | P | 9 | 1 | CHW | 2017 | 2019 | ||
263 | 263 | Evan Marshall | 29 | marshev01 | 2019 | CHW | AL | 1.92106139 | 1.097088608 | P | 6 | 1 | CHW | CLE | 2019 | 2019 | |
264 | 264 | Alex Colome | 30 | colomal01 | 2019 | CHW | AL | 2.37508273 | 1.056075949 | P | 6 | 1 | CHW | SEA | 2019 | 2019 | |
265 | 265 | Adam Engel | 27 | engelad01 | 2019 | CHW | AL | 2.333333333 | 0.74335443 | CF | 6 | 1 | CHW | 2017 | 2019 | ||
266 | 266 | Jimmy Cordero | 27 | cordeji01 | 2019 | CHW | AL | 1.017892599 | 0.733101266 | P | 4 | 2 | CHW | TOR | 2019 | 2019 | |
267 | 267 | Dylan Cease | 23 | ceasedy01 | 2019 | CHW | AL | 2.193409923 | 0.29221519 | P | 4 | 1 | CHW | 2019 | 2019 | ||
268 | 268 | Carlos Rodon | 26 | rodonca01 | 2019 | CHW | AL | 1.041619324 | 0.512658228 | P | 3 | 1 | CHW | 2015 | 2019 | ||
269 | 269 | Josh Osich | 30 | osichjo01 | 2019 | CHW | AL | 1.860860849 | 0.256329114 | P | 3 | 1 | CHW | SFG | 2019 | 2019 | |
270 | 270 | Ryan Goins | 31 | goinsry01 | 2019 | CHW | AL | 1.588235294 | 0.22556962 | 3B, SS, RF, 1B, LF | 3 | 1 | CHW | KCR | 2019 | 2019 | |
271 | 271 | Jace Fry | 25 | fryja01 | 2019 | CHW | AL | 1.758616336 | 0.092278481 | P | 3 | 1 | CHW | 2017 | 2019 | ||
272 | 272 | Juan Minaya | 28 | minayju01 | 2019 | CHW | AL | 0.617912492 | 0.312721519 | P | 2 | 1 | CHW | 2016 | 2019 | ||
273 | 273 | Kelvin Herrera | 29 | herreke01 | 2019 | CHW | AL | 1.506084708 | 0.025632911 | P | 2 | 1 | CHW | WSN | 2019 | 2019 | |
274 | 274 | Ryan Cordell | 27 | cordery01 | 2019 | CHW | AL | 2.382352941 | -0.522911392 | RF, CF, LF | 2 | 1 | CHW | 2018 | 2019 | ||
275 | 275 | Nate Jones | 33 | jonesna01 | 2019 | CHW | AL | 0.312143018 | 0.061518987 | P | 1 | 1 | CHW | 2012 | 2019 | ||
276 | 276 | Danny Mendick | 25 | mendida01 | 2019 | CHW | AL | 0.294117647 | 0.056392405 | 2B, SS, 3B | 1 | 1 | CHW | 2019 | 2019 | ||
277 | 277 | Ryan Burr | 25 | burrry01 | 2019 | CHW | AL | 0.489798885 | 0.051265823 | P | 1 | 1 | CHW | 2018 | 2019 | ||
278 | 278 | Jose Ruiz | 24 | ruizjo01 | 2019 | CHW | AL | 1.060472163 | -0.025632911 | P | 1 | 1 | CHW | SDP | 2018 | 2019 | |
279 | 279 | Zack Collins | 24 | colliza01 | 2019 | CHW | AL | 0.931372549 | -0.251202532 | C, 1B | 1 | 1 | CHW | 2019 | 2019 | ||
280 | 280 | Manny Banuelos | 28 | banuema01 | 2019 | CHW | AL | 1.294418749 | -0.399873418 | P | 1 | 1 | CHW | ATL | 2019 | 2019 | |
281 | 281 | Charlie Tilson | 26 | tilsoch01 | 2019 | CHW | AL | 1.539215686 | -0.492151899 | RF, LF, CF | 1 | 1 | CHW | 2016 | 2019 | ||
282 | 282 | Ross Detwiler | 33 | detwiro01 | 2019 | CHW | AL | 1.736603505 | -0.579303797 | P | 1 | 1 | CHW | SEA | 2019 | 2019 | |
283 | 283 | Welington Castillo | 32 | castiwe01 | 2019 | CHW | AL | 2.392156863 | -0.635696203 | C | 1 | 1 | CHW | BAL | 2018 | 2019 | |
284 | 284 | Dylan Covey | 27 | coveydy01 | 2019 | CHW | AL | 1.904136683 | -0.661329114 | P | 1 | 1 | CHW | 2017 | 2019 | ||
285 | 285 | Thyago Vieira | 25 | vieirth01 | 2019 | CHW | AL | 0.133844441 | -0.025632911 | P | 0 | 1 | CHW | SEA | 2018 | 2019 | |
286 | 286 | Caleb Frare | 25 | frareca01 | 2019 | CHW | AL | 0.074125933 | -0.097405063 | P | 0 | 1 | CHW | 2018 | 2019 | ||
287 | 287 | Hector Santiago | 31 | santihe01 | 2019 | CHW | AL | 0.51963136 | -0.148670886 | P | 0 | 2 | CHW | NYM | 2019 | 2019 | |
288 | 288 | Odrisamer Despaigne | 32 | despaod01 | 2019 | CHW | AL | 0.392053345 | -0.199936709 | P | 0 | 1 | CHW | ANA | 2019 | 2019 | |
289 | 289 | Seby Zavala | 25 | zavalse01 | 2019 | CHW | AL | 0.117647059 | -0.215316456 | C | 0 | 1 | CHW | 2019 | 2019 | ||
290 | 290 | Carson Fulmer | 25 | fulmeca01 | 2019 | CHW | AL | 0.781750085 | -0.328101266 | P | 0 | 1 | CHW | 2016 | 2019 | ||
291 | 291 | Ervin Santana | 36 | santaer01 | 2019 | CHW | AL | 0.400622817 | -0.405 | P | 0 | 1 | CHW | MIN | 2019 | 2019 | |
292 | 292 | Nicky Delmonico | 26 | delmoni01 | 2019 | CHW | AL | 0.666666667 | -0.507531646 | LF, 1B | 0 | 1 | CHW | 2017 | 2019 | ||
293 | 293 | AJ Reed | 26 | reedaj01 | 2019 | CHW | AL | 0.480392157 | -0.51778481 | 1B, P | 0 | 1 | CHW | HOU | 2019 | 2019 | |
294 | 294 | Matt Skole | 29 | skolema01 | 2019 | CHW | AL | 0.784313725 | -0.548544304 | 1B | 0 | 1 | CHW | 2018 | 2019 | ||
295 | 295 | Jose Rondon | 25 | rondojo02 | 2019 | CHW | AL | 1.529411765 | -0.712594937 | 2B, SS, 3B, LF, 1B, P | 0 | 1 | CHW | SDP | 2018 | 2019 | BAL |
296 | 296 | Jon Jay | 34 | jayjo02 | 2019 | CHW | AL | 1.784313725 | -0.871518987 | RF, LF | 0 | 1 | CHW | ARI | 2019 | 2019 | |
297 | 297 | Yonder Alonso | 32 | alonsyo01 | 2019 | CHW | AL | 2.460784314 | -1.194493671 | 1B | 0 | 1 | CHW | CLE | 2019 | 2019 | COL |
298 | 298 | Daniel Palka | 27 | palkada01 | 2019 | CHW | AL | 0.87254902 | -1.302151899 | RF, 1B | 0 | 1 | CHW | 2018 | 2019 | ||
299 | 299 | Sonny Gray | 29 | grayso01 | 2019 | CIN | NL | 4.966111658 | 5.175849057 | P | 22 | 1 | CIN | NYY | 2019 | 2019 | |
300 | 300 | Eugenio Suarez | 27 | suareeu01 | 2019 | CIN | NL | 6.677224199 | 4.508490566 | 3B | 22 | 1 | CIN | DET | 2015 | 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 );