mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
2,792 rows where next_franch = "LAD"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
540 | 540 | Tyler White | 28 | whitety01 | 2019 | HOU | AL | 2.345963229 | -0.708113208 | 1B, P | 1 | 1 | HOU | 2016 | 2019 | LAD | |
900 | 900 | Travis d'Arnaud | 30 | darnatr01 | 2019 | NYM | NL | 0.248287671 | -0.310754717 | C, 1B | 0 | 1 | NYM | 2013 | 2019 | LAD | |
1206 | 1206 | Kristopher Negron | 33 | negrokr01 | 2019 | SEA | AL | 0.239037257 | 0.096792453 | CF, RF, LF, SS, 2B, 3B | 1 | 1 | SEA | ARI | 2018 | 2019 | LAD |
1332 | 1332 | Jedd Gyorko | 30 | gyorkje01 | 2019 | STL | NL | 0.627027027 | -0.152830189 | 3B, 1B, 2B, P | 1 | 1 | STL | SDP | 2016 | 2019 | LAD |
1376 | 1376 | Adam Kolarek | 30 | kolarad01 | 2019 | TBR | AL | 1.386996015 | 0.259811321 | P, 1B | 3 | 1 | TBD | 2017 | 2019 | LAD | |
1382 | 1382 | Casey Sadler | 28 | sadleca02 | 2019 | TBR | AL | 0.377393052 | 0.229245283 | P | 1 | 1 | TBD | PIT | 2019 | 2019 | LAD |
1501 | 1501 | Zac Rosscup | 31 | rosscza01 | 2019 | TOR | AL | 0.017561522 | -0.076415094 | P | 0 | 2 | TOR | SEA | 2019 | 2019 | LAD |
1571 | 1571 | A.J. Pollock | 30 | polloaj01 | 2018 | ARI | NL | 4.580257511 | 2.545 | CF | 14 | 1 | ARI | 2012 | 2018 | LAD | |
1672 | 1672 | Manny Machado | 25 | machama01 | 2018 | BAL | AL | 3.98502745 | 3.355 | SS, 3B | 14 | 1 | BAL | 2012 | 2018 | LAD | |
1748 | 1748 | Joe Kelly | 30 | kellyjo05 | 2018 | BOS | AL | 2.207760807 | 0.515 | P | 5 | 1 | BOS | STL | 2014 | 2018 | LAD |
1893 | 1893 | Dylan Floro | 27 | florody01 | 2018 | CIN | NL | 1.040460768 | 0.515 | P | 3 | 1 | CIN | CHC | 2018 | 2018 | LAD |
2079 | 2079 | Tyler White | 27 | whitety01 | 2018 | HOU | AL | 2.245711485 | 1.555 | 1B | 8 | 1 | HOU | 2016 | 2019 | LAD | |
2379 | 2379 | Brian Dozier | 31 | doziebr01 | 2018 | MIN | AL | 4.369863014 | 1.06 | 2B | 10 | 1 | MIN | 2012 | 2018 | LAD | |
2456 | 2456 | Travis d'Arnaud | 29 | darnatr01 | 2018 | NYM | NL | 0.158795346 | -0.03 | C | 0 | 1 | NYM | 2013 | 2019 | LAD | |
2644 | 2644 | David Freese | 35 | freesda01 | 2018 | PIT | NL | 2.672578682 | 1.378509317 | 3B, 1B | 8 | 1 | PIT | ANA | 2016 | 2018 | LAD |
2757 | 2757 | Erik Goeddel | 29 | goedder01 | 2018 | SEA | AL | 0.242843236 | 0.25 | P | 1 | 1 | SEA | NYM | 2018 | 2018 | LAD |
2763 | 2763 | Kristopher Negron | 32 | negrokr01 | 2018 | SEA | AL | 0.286892003 | 0.025 | 3B, LF, 2B, SS, RF | 1 | 2 | SEA | ARI | 2018 | 2019 | LAD |
2839 | 2839 | Jedd Gyorko | 29 | gyorkje01 | 2018 | STL | NL | 3.970032351 | 1.7 | 3B, 2B, 1B, SS, P | 11 | 1 | STL | SDP | 2016 | 2019 | LAD |
2906 | 2906 | Adam Kolarek | 29 | kolarad01 | 2018 | TBR | AL | 1.129281507 | 0.575 | P | 3 | 1 | TBD | 2017 | 2019 | LAD | |
2928 | 2928 | Jaime Schultz | 27 | schulja02 | 2018 | TBR | AL | 0.731084069 | -0.215 | P | 0 | 1 | TBD | 2018 | 2018 | LAD | |
2988 | 2988 | Russell Martin | 35 | martiru01 | 2018 | TOR | AL | 3.373430271 | 1.225 | C, 3B, SS, LF | 9 | 1 | TOR | PIT | 2015 | 2018 | LAD |
3008 | 3008 | John Axford | 35 | axforjo01 | 2018 | TOR | AL | 1.402075101 | 0.265 | P | 3 | 1 | TOR | OAK | 2018 | 2018 | LAD |
3080 | 3080 | Ryan Madson | 37 | madsory01 | 2018 | WSN | NL | 1.637493265 | -0.22 | P | 1 | 1 | WSN | OAK | 2017 | 2018 | LAD |
3106 | 3106 | A.J. Pollock | 29 | polloaj01 | 2017 | ARI | NL | 4.601293837 | 2.65 | CF | 14 | 1 | ARI | 2012 | 2018 | LAD | |
3161 | 3161 | Matt Kemp | 32 | kempma01 | 2017 | ATL | NL | 4.595520869 | -0.99 | LF | 4 | 1 | ATL | SDP | 2016 | 2017 | LAD |
3193 | 3193 | Manny Machado | 24 | machama01 | 2017 | BAL | AL | 6.537079386 | 2.995 | 3B | 19 | 1 | BAL | 2012 | 2018 | LAD | |
3257 | 3257 | Joe Kelly | 29 | kellyjo05 | 2017 | BOS | AL | 1.848640702 | 0.995 | P | 6 | 1 | BOS | STL | 2014 | 2018 | LAD |
3429 | 3429 | Tony Cingrani | 27 | cingrto01 | 2017 | CIN | NL | 0.687938499 | -0.29 | P | 0 | 1 | CIN | 2012 | 2017 | LAD | |
3508 | 3508 | Zac Rosscup | 29 | rosscza01 | 2017 | COL | NL | 0.146237147 | 0.06 | P | 0 | 2 | COL | CHC | 2017 | 2017 | LAD |
3596 | 3596 | Tyler White | 26 | whitety01 | 2017 | HOU | AL | 0.622556873 | 0.09 | 1B, 2B, LF, P | 1 | 1 | HOU | 2016 | 2019 | LAD | |
3623 | 3623 | Scott Alexander | 27 | alexasc02 | 2017 | KCR | AL | 2.678779662 | 1.685 | P | 9 | 1 | KCR | 2015 | 2017 | LAD | |
3862 | 3862 | Brian Dozier | 30 | doziebr01 | 2017 | MIN | AL | 6.556036556 | 4.73 | 2B | 24 | 1 | MIN | 2012 | 2018 | LAD | |
3917 | 3917 | Curtis Granderson | 36 | grandcu01 | 2017 | NYM | NL | 3.919589393 | 2.14 | CF, RF, LF | 12 | 1 | NYM | NYY | 2014 | 2017 | LAD |
3922 | 3922 | Travis d'Arnaud | 28 | darnatr01 | 2017 | NYM | NL | 3.731052181 | 1.365 | C, 2B, 3B | 9 | 1 | NYM | 2013 | 2019 | LAD | |
4061 | 4061 | Zach Neal | 28 | nealza01 | 2017 | OAK | AL | 0.247135415 | -0.195 | P | 0 | 1 | OAK | 2016 | 2017 | LAD | |
4125 | 4125 | David Freese | 34 | freesda01 | 2017 | PIT | NL | 5.018751075 | 1.965 | 3B, 1B | 13 | 1 | PIT | ANA | 2016 | 2018 | LAD |
4139 | 4139 | Tony Watson | 32 | watsoto01 | 2017 | PIT | NL | 1.859780095 | 0.275 | P | 4 | 1 | PIT | 2011 | 2017 | LAD | |
4143 | 4143 | Daniel Hudson | 30 | hudsoda01 | 2017 | PIT | NL | 1.922905128 | 0.075 | P | 3 | 1 | PIT | ARI | 2017 | 2017 | LAD |
4208 | 4208 | Rocky Gale | 29 | galero01 | 2017 | SDP | NL | 0.102709403 | -0.085 | C | 0 | 1 | SDP | 2015 | 2017 | LAD | |
4280 | 4280 | Mike Freeman | 29 | freemmi01 | 2017 | SEA | AL | 0.321224955 | -0.51 | SS, 1B, 2B, 3B, P | 0 | 1 | SEA | ARI | 2016 | 2017 | LAD |
4334 | 4334 | Jedd Gyorko | 28 | gyorkje01 | 2017 | STL | NL | 4.737306843 | 3.13 | 3B, 1B, 2B, LF | 15 | 1 | STL | SDP | 2016 | 2019 | LAD |
4372 | 4372 | Breyvic Valera | 25 | valerbr01 | 2017 | STL | NL | 0.108337579 | -0.225 | 2B | 0 | 1 | STL | 2017 | 2017 | LAD | |
4426 | 4426 | Adam Kolarek | 28 | kolarad01 | 2017 | TBR | AL | 0.228698274 | -0.23 | P | 0 | 1 | TBD | 2017 | 2019 | LAD | |
4436 | 4436 | Yu Darvish | 30 | darviyu01 | 2017 | TEX | AL | 3.948936792 | 3.055 | P | 15 | 1 | TEX | 2012 | 2017 | LAD | |
4490 | 4490 | Russell Martin | 34 | martiru01 | 2017 | TOR | AL | 3.453507341 | 1.835 | C, 3B | 10 | 1 | TOR | PIT | 2015 | 2018 | LAD |
4559 | 4559 | Ryan Madson | 36 | madsory01 | 2017 | WSN | NL | 0.694855134 | 0.95 | P | 4 | 2 | WSN | OAK | 2017 | 2018 | LAD |
4617 | 4617 | A.J. Pollock | 28 | polloaj01 | 2016 | ARI | NL | 0.450219372 | 0.445 | CF | 2 | 1 | ARI | 2012 | 2018 | LAD | |
4652 | 4652 | Bud Norris | 31 | norribu01 | 2016 | ATL | NL | 1.89875543 | 1.066583851 | P | 6 | 1 | ATL | SDP | 2016 | 2016 | LAD |
4658 | 4658 | Matt Kemp | 31 | kempma01 | 2016 | ATL | NL | 2.378019735 | 0.19621118 | RF, LF | 4 | 2 | ATL | SDP | 2016 | 2017 | LAD |
4702 | 4702 | Manny Machado | 23 | machama01 | 2016 | BAL | AL | 6.660287081 | 6.61 | 3B, SS | 30 | 1 | BAL | 2012 | 2018 | LAD | |
4776 | 4776 | Joe Kelly | 28 | kellyjo05 | 2016 | BOS | AL | 1.385569442 | 0.135 | P | 2 | 1 | BOS | STL | 2014 | 2018 | LAD |
4910 | 4910 | Tony Cingrani | 26 | cingrto01 | 2016 | CIN | NL | 2.340998193 | 0.42 | P | 5 | 1 | CIN | 2012 | 2017 | LAD | |
5108 | 5108 | Tyler White | 25 | whitety01 | 2016 | HOU | AL | 2.589872189 | -0.155 | 1B, 3B, 2B, P | 3 | 1 | HOU | 2016 | 2019 | LAD | |
5116 | 5116 | Josh Fields | 30 | fieldjo03 | 2016 | HOU | AL | 0.313630931 | -0.085 | P | 0 | 1 | HOU | 2013 | 2016 | LAD | |
5157 | 5157 | Scott Alexander | 26 | alexasc02 | 2016 | KCR | AL | 0.46685256 | 0.245 | P | 1 | 1 | KCR | 2015 | 2017 | LAD | |
5381 | 5381 | Brian Dozier | 29 | doziebr01 | 2016 | MIN | AL | 6.446517613 | 6.31 | 2B | 26 | 1 | MIN | 2012 | 2018 | LAD | |
5410 | 5410 | JT Chargois | 25 | chargjt01 | 2016 | MIN | AL | 0.617715844 | 0.24 | P | 1 | 1 | MIN | 2016 | 2016 | LAD | |
5424 | 5424 | Casey Fien | 32 | fienca01 | 2016 | MIN | AL | 0.441283082 | -0.375 | P | 0 | 1 | MIN | DET | 2012 | 2016 | LAD |
5433 | 5433 | Curtis Granderson | 35 | grandcu01 | 2016 | NYM | NL | 6.338743094 | 2.955 | RF, CF, LF | 17 | 1 | NYM | NYY | 2014 | 2017 | LAD |
5452 | 5452 | Travis d'Arnaud | 27 | darnatr01 | 2016 | NYM | NL | 2.763812155 | 0.185 | C | 4 | 1 | NYM | 2013 | 2019 | LAD | |
5533 | 5533 | Rich Hill | 36 | hillri01 | 2016 | OAK | AL | 2.178144157 | 2.79 | P | 11 | 1 | OAK | BOS | 2016 | 2016 | LAD |
5536 | 5536 | Josh Reddick | 29 | reddijo01 | 2016 | OAK | AL | 2.63021007 | 1.915 | RF | 9 | 1 | OAK | BOS | 2012 | 2016 | LAD |
5548 | 5548 | Zach Neal | 27 | nealza01 | 2016 | OAK | AL | 1.617891458 | 0.595 | P | 4 | 1 | OAK | 2016 | 2017 | LAD | |
5564 | 5564 | Max Muncy | 25 | muncyma01 | 2016 | OAK | AL | 1.286095365 | -0.18 | 2B, RF, LF, 3B | 1 | 1 | OAK | 2015 | 2016 | LAD | |
5576 | 5576 | Brett Eibner | 27 | eibnebr01 | 2016 | OAK | AL | 1.189396465 | -0.6 | CF, RF, LF | 0 | 2 | OAK | KCR | 2016 | 2016 | LAD |
5591 | 5591 | Carlos Ruiz | 37 | ruizca01 | 2016 | PHI | NL | 1.9718161 | 0.895 | C | 6 | 1 | PHI | 2006 | 2016 | LAD | |
5633 | 5633 | David Freese | 33 | freesda01 | 2016 | PIT | NL | 4.804040404 | 1.765 | 3B, 1B, 2B | 12 | 1 | PIT | ANA | 2016 | 2018 | LAD |
5646 | 5646 | Tony Watson | 31 | watsoto01 | 2016 | PIT | NL | 2.422709131 | 0.6 | P | 5 | 1 | PIT | 2011 | 2017 | LAD | |
5716 | 5716 | Brandon Morrow | 31 | morrobr01 | 2016 | SDP | NL | 0.444557982 | 0.22 | P | 1 | 1 | SDP | TOR | 2015 | 2016 | LAD |
5757 | 5757 | Franklin Gutierrez | 33 | gutiefr01 | 2016 | SEA | AL | 2.646565624 | 0.66 | RF, LF | 6 | 1 | SEA | CLE | 2009 | 2016 | LAD |
5774 | 5774 | Mike Freeman | 28 | freemmi01 | 2016 | SEA | AL | 0.121573686 | 0.145 | 2B, SS, LF, RF | 1 | 2 | SEA | ARI | 2016 | 2017 | LAD |
5781 | 5781 | Chris Taylor | 25 | tayloch03 | 2016 | SEA | AL | 0.028055466 | 0.01 | 3B, 2B, SS | 0 | 1 | SEA | 2014 | 2016 | LAD | |
5786 | 5786 | Pat Venditte | 31 | vendipa01 | 2016 | SEA | AL | 0.240919186 | -0.17 | P | 0 | 2 | SEA | TOR | 2016 | 2016 | LAD |
5817 | 5817 | Sergio Romo | 33 | romose01 | 2016 | SFG | NL | 1.039627936 | 0.415 | P | 3 | 1 | SFG | 2008 | 2016 | LAD | |
5847 | 5847 | Jedd Gyorko | 27 | gyorkje01 | 2016 | STL | NL | 4.307953197 | 2.6 | 2B, 3B, SS, 1B | 14 | 1 | STL | SDP | 2016 | 2019 | LAD |
5884 | 5884 | Logan Forsythe | 29 | forsylo01 | 2016 | TBR | AL | 5.461883408 | 3.035 | 2B | 15 | 1 | TBD | SDP | 2014 | 2016 | LAD |
5936 | 5936 | Yu Darvish | 29 | darviyu01 | 2016 | TEX | AL | 2.75987854 | 2.69 | P | 13 | 1 | TEX | 2012 | 2017 | LAD | |
5989 | 5989 | Russell Martin | 33 | martiru01 | 2016 | TOR | AL | 5.00483871 | 2.69 | C, 2B, 3B | 15 | 1 | TOR | PIT | 2015 | 2018 | LAD |
6007 | 6007 | Jesse Chavez | 32 | chaveje01 | 2016 | TOR | AL | 1.312268349 | -0.125 | P | 1 | 1 | TOR | OAK | 2016 | 2016 | LAD |
6075 | 6075 | A.J. Pollock | 27 | polloaj01 | 2015 | ARI | NL | 6.563645536 | 7.02 | CF | 29 | 1 | ARI | 2012 | 2018 | LAD | |
6129 | 6129 | Alex Wood | 24 | woodal02 | 2015 | ATL | NL | 3.264222002 | 2.38 | P | 12 | 1 | ATL | 2013 | 2015 | LAD | |
6133 | 6133 | Jim Johnson | 32 | johnsji04 | 2015 | ATL | NL | 1.976610505 | 1.05 | P | 6 | 1 | ATL | DET | 2015 | 2015 | LAD |
6140 | 6140 | Luis Avilan | 25 | avilalu01 | 2015 | ATL | NL | 1.478295342 | 0.39 | P | 3 | 1 | ATL | 2012 | 2015 | LAD | |
6163 | 6163 | Alberto Callaspo | 32 | callaal01 | 2015 | ATL | NL | 1.251139951 | -0.43 | 3B, 2B | 1 | 1 | ATL | OAK | 2015 | 2015 | LAD |
6168 | 6168 | Ian Thomas | 28 | thomaia01 | 2015 | ATL | NL | 0.124479683 | -0.065 | P | 0 | 1 | ATL | 2014 | 2015 | LAD | |
6184 | 6184 | Manny Machado | 22 | machama01 | 2015 | BAL | AL | 6.909607352 | 6.85 | 3B, SS | 30 | 1 | BAL | 2012 | 2018 | LAD | |
6242 | 6242 | Joe Kelly | 27 | kellyjo05 | 2015 | BOS | AL | 3.752481668 | 1.085 | P | 8 | 1 | BOS | STL | 2014 | 2018 | LAD |
6347 | 6347 | Trayce Thompson | 24 | thomptr01 | 2015 | CHW | AL | 1.294856954 | 1.445 | RF, LF, CF | 6 | 1 | CHW | 2015 | 2015 | LAD | |
6368 | 6368 | Micah Johnson | 24 | johnsmi04 | 2015 | CHW | AL | 1.093434761 | -0.56 | 2B | 0 | 1 | CHW | 2015 | 2015 | LAD | |
6412 | 6412 | Tony Cingrani | 25 | cingrto01 | 2015 | CIN | NL | 1.180207514 | -0.305 | P | 0 | 1 | CIN | 2012 | 2017 | LAD | |
6468 | 6468 | Zach Walters | 25 | walteza01 | 2015 | CLE | AL | 0.285949055 | -0.482981366 | LF, 2B, 3B, SS, RF | 0 | 1 | CLE | WSN | 2014 | 2015 | LAD |
6590 | 6590 | Josh Fields | 29 | fieldjo03 | 2015 | HOU | AL | 1.44634687 | 0.87 | P | 4 | 1 | HOU | 2013 | 2016 | LAD | |
6600 | 6600 | Scott Kazmir | 31 | kazmisc01 | 2015 | HOU | AL | 2.060343152 | -0.055 | P | 2 | 2 | HOU | OAK | 2015 | 2015 | LAD |
6648 | 6648 | Louis Coleman | 29 | colemlo01 | 2015 | KCR | AL | 0.069542119 | 0.07 | P | 0 | 1 | KCR | 2011 | 2015 | LAD | |
6650 | 6650 | Scott Alexander | 25 | alexasc02 | 2015 | KCR | AL | 0.093321037 | 0.01 | P | 0 | 1 | KCR | 2015 | 2017 | LAD | |
6778 | 6778 | Mat Latos | 27 | latosma01 | 2015 | MIA | NL | 2.532956388 | 1.105 | P | 7 | 1 | FLA | CIN | 2015 | 2015 | LAD |
6867 | 6867 | Brian Dozier | 28 | doziebr01 | 2015 | MIN | AL | 6.808737702 | 2.855 | 2B | 20 | 1 | MIN | 2012 | 2018 | LAD | |
6884 | 6884 | Casey Fien | 31 | fienca01 | 2015 | MIN | AL | 2.077331901 | 0.895 | P | 6 | 1 | MIN | DET | 2012 | 2016 | LAD |
6911 | 6911 | Curtis Granderson | 34 | grandcu01 | 2015 | NYM | NL | 6.82824098 | 5.14 | RF, CF | 25 | 1 | NYM | NYY | 2014 | 2017 | LAD |
6918 | 6918 | Travis d'Arnaud | 26 | darnatr01 | 2015 | NYM | NL | 2.683238391 | 2.5 | C | 11 | 1 | NYM | 2013 | 2019 | LAD |
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 );