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,030 rows where prev_franch = "LAD"
This data as json, copyable, CSV (advanced)
Suggested facets: age, lg_ID, stint_ID, franch_id, next_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | Zack Greinke | 35 | greinza01 | 2019 | ARI | NL | 4.10802053 | 5.023018868 | P | 21 | 1 | ARI | LAD | 2016 | 2019 | HOU |
15 | 15 | Tim Locastro | 26 | locasti01 | 2019 | ARI | NL | 2.346421894 | 0.860943396 | LF, RF, CF | 6 | 1 | ARI | LAD | 2019 | 2019 | |
69 | 69 | Charlie Culberson | 30 | culbech01 | 2019 | ATL | NL | 1.428180575 | 0.244528302 | LF, RF, 1B, SS, P, 3B | 3 | 1 | ATL | LAD | 2018 | 2019 | |
77 | 77 | Grant Dayton | 31 | daytogr01 | 2019 | ATL | NL | 0.240101153 | 0.122264151 | P | 1 | 1 | ATL | LAD | 2019 | 2019 | |
206 | 206 | Yu Darvish | 32 | darviyu01 | 2019 | CHC | NL | 5.034783981 | 2.745849057 | P | 14 | 1 | CHC | LAD | 2018 | 2019 | |
308 | 308 | Yasiel Puig | 28 | puigya01 | 2019 | CIN | NL | 4.169395018 | 0.820188679 | RF | 8 | 1 | CIN | LAD | 2019 | 2019 | CLE |
321 | 321 | Kyle Farmer | 28 | farmeky01 | 2019 | CIN | NL | 1.950533808 | 0.178301887 | 2B, 1B, C, 3B, P, SS | 3 | 1 | CIN | LAD | 2019 | 2019 | |
323 | 323 | Jose Peraza | 25 | perazjo01 | 2019 | CIN | NL | 4.014590747 | -0.636792453 | 2B, SS, LF, 3B, CF, P | 3 | 1 | CIN | LAD | 2016 | 2019 | |
331 | 331 | Alex Wood | 28 | woodal02 | 2019 | CIN | NL | 1.015618858 | -0.213962264 | P | 1 | 1 | CIN | LAD | 2019 | 2019 | |
342 | 342 | Scott Schebler | 28 | schebsc01 | 2019 | CIN | NL | 0.980427046 | -0.565471698 | CF, LF, RF | 0 | 1 | CIN | LAD | 2016 | 2019 | |
345 | 345 | Matt Kemp | 34 | kempma01 | 2019 | CIN | NL | 0.639857651 | -0.860943396 | LF | 0 | 1 | CIN | LAD | 2019 | 2019 | |
514 | 514 | Josh Reddick | 32 | reddijo01 | 2019 | HOU | AL | 5.062829736 | 0.952641509 | RF, LF, CF, 1B | 9 | 1 | HOU | LAD | 2017 | 2019 | |
704 | 704 | Miguel Rojas | 30 | rojasmi02 | 2019 | MIA | NL | 5.305506217 | 1.951132075 | SS, 1B, 2B | 13 | 1 | FLA | LAD | 2015 | 2019 | |
753 | 753 | Yasmani Grandal | 30 | grandya01 | 2019 | MIL | NL | 6.123427406 | 4.065283019 | C, 1B | 22 | 1 | MIL | LAD | 2019 | 2019 | |
1118 | 1118 | Manny Machado | 26 | machama01 | 2019 | SDP | NL | 6.68359375 | 2.684716981 | 3B, SS | 17 | 1 | SDP | LAD | 2019 | 2019 | |
1207 | 1207 | Zac Rosscup | 31 | rosscza01 | 2019 | SEA | AL | 0.474871854 | 0.066226415 | P | 1 | 1 | SEA | LAD | 2019 | 2019 | TOR |
1263 | 1263 | Tony Watson | 34 | watsoto01 | 2019 | SFG | NL | 2.037589769 | -0.056037736 | P | 3 | 1 | SFG | LAD | 2018 | 2019 | |
1286 | 1286 | Pat Venditte | 34 | vendipa01 | 2019 | SFG | NL | 0.050990735 | -0.142641509 | P | 0 | 1 | SFG | LAD | 2019 | 2019 | |
1357 | 1357 | Travis d'Arnaud | 30 | darnatr01 | 2019 | TBR | AL | 3.386241665 | 1.599622642 | C, 1B | 10 | 3 | TBD | LAD | 2019 | 2019 | |
1394 | 1394 | Jose De Leon | 26 | deleojo03 | 2019 | TBR | AL | 0.0576998 | -0.010188679 | P | 0 | 1 | TBD | LAD | 2017 | 2019 | |
1470 | 1470 | Daniel Hudson | 32 | hudsoda01 | 2019 | TOR | AL | 1.72353794 | 0.779433962 | P | 5 | 1 | TOR | LAD | 2019 | 2019 | WSN |
1512 | 1512 | Brock Stewart | 27 | stewabr01 | 2019 | TOR | AL | 0.611517282 | -0.67245283 | P | 0 | 2 | TOR | LAD | 2019 | 2019 | |
1525 | 1525 | Brian Dozier | 32 | doziebr01 | 2019 | WSN | NL | 4.764250043 | 1.034150943 | 2B, P | 9 | 1 | WSN | LAD | 2019 | 2019 | |
1567 | 1567 | Zack Greinke | 34 | greinza01 | 2018 | ARI | NL | 5.686187576 | 4.15 | P | 20 | 1 | ARI | LAD | 2016 | 2019 | HOU |
1627 | 1627 | Charlie Culberson | 29 | culbech01 | 2018 | ATL | NL | 3.153131859 | 1.11 | LF, 3B, SS, 2B, 1B, RF, P | 8 | 1 | ATL | LAD | 2018 | 2019 | |
1635 | 1635 | Brandon McCarthy | 34 | mccarbr01 | 2018 | ATL | NL | 2.174757919 | -0.09 | P | 3 | 1 | ATL | LAD | 2018 | 2018 | |
1655 | 1655 | Josh Ravin | 30 | ravinjo01 | 2018 | ATL | NL | 0.095797367 | -0.03 | P | 0 | 1 | ATL | LAD | 2018 | 2018 | |
1704 | 1704 | Breyvic Valera | 26 | valerbr01 | 2018 | BAL | AL | 0.395608052 | 0.06 | 2B, 3B, SS, RF | 1 | 2 | BAL | LAD | 2018 | 2018 | NYY |
1753 | 1753 | Hanley Ramirez | 34 | ramirha01 | 2018 | BOS | AL | 1.800382044 | -0.005 | 1B | 3 | 1 | BOS | LAD | 2015 | 2018 | CLE |
1792 | 1792 | Brandon Morrow | 33 | morrobr01 | 2018 | CHC | NL | 1.105278333 | 1.058466258 | P | 5 | 1 | CHC | LAD | 2018 | 2018 | |
1800 | 1800 | Yu Darvish | 31 | darviyu01 | 2018 | CHC | NL | 1.084133878 | 0.069570552 | P | 2 | 1 | CHC | LAD | 2018 | 2019 | |
1816 | 1816 | Mike Freeman | 30 | freemmi01 | 2018 | CHC | NL | 0.009602649 | -0.099386503 | 2B | 0 | 1 | CHC | LAD | 2017 | 2018 | CLE |
1839 | 1839 | Luis Avilan | 28 | avilalu01 | 2018 | CHW | AL | 1.300090207 | 0.62 | P | 4 | 1 | CHW | LAD | 2018 | 2018 | PHI |
1876 | 1876 | Jose Peraza | 24 | perazjo01 | 2018 | CIN | NL | 6.722212795 | 2.43 | SS, RF | 16 | 1 | CIN | LAD | 2016 | 2019 | |
1879 | 1879 | Scott Schebler | 27 | schebsc01 | 2018 | CIN | NL | 4.232139827 | 1.105 | RF, CF, LF | 9 | 1 | CIN | LAD | 2016 | 2019 | |
2031 | 2031 | Louis Coleman | 32 | colemlo01 | 2018 | DET | AL | 1.580550953 | 0.485 | P | 4 | 1 | DET | LAD | 2018 | 2018 | |
2076 | 2076 | Josh Reddick | 31 | reddijo01 | 2018 | HOU | AL | 4.614605457 | 1.43 | RF, LF | 11 | 1 | HOU | LAD | 2017 | 2019 | |
2270 | 2270 | Miguel Rojas | 29 | rojasmi02 | 2018 | MIA | NL | 5.28 | 1.700496894 | SS, 1B, 3B, 2B | 13 | 1 | FLA | LAD | 2015 | 2019 | |
2390 | 2390 | Logan Forsythe | 31 | forsylo01 | 2018 | MIN | AL | 1.93900848 | 0.5 | 2B, 3B, 1B, LF | 4 | 2 | MIN | LAD | 2018 | 2018 | TEX |
2451 | 2451 | Adrian Gonzalez | 36 | gonzaad01 | 2018 | NYM | NL | 1.855920602 | -0.44 | 1B | 1 | 1 | NYM | LAD | 2018 | 2018 | |
2508 | 2508 | Ronald Torreyes | 25 | torrero01 | 2018 | NYY | AL | 0.946711474 | 0.39 | 2B, 3B, SS | 2 | 1 | NYY | LAD | 2016 | 2018 | MIN |
2567 | 2567 | Danny Coulombe | 28 | couloda01 | 2018 | OAK | AL | 0.603515237 | -0.12 | P | 1 | 1 | OAK | LAD | 2015 | 2018 | |
2572 | 2572 | Trayce Thompson | 27 | thomptr01 | 2018 | OAK | AL | 0.065126724 | -0.02 | RF, LF, CF | 0 | 1 | OAK | LAD | 2018 | 2018 | CHW |
2578 | 2578 | Wilmer Font | 28 | fontwi01 | 2018 | OAK | AL | 0.099657688 | -0.295 | P | 0 | 2 | OAK | LAD | 2018 | 2018 | TBD |
2579 | 2579 | Chris Hatcher | 33 | hatchch02 | 2018 | OAK | AL | 0.937173085 | -0.335 | P | 0 | 1 | OAK | LAD | 2017 | 2018 | |
2789 | 2789 | Tony Watson | 33 | watsoto01 | 2018 | SFG | NL | 2.511311876 | 1.8 | P | 9 | 1 | SFG | LAD | 2018 | 2019 | |
2897 | 2897 | Sergio Romo | 35 | romose01 | 2018 | TBR | AL | 2.443815085 | 0.45 | P, 3B | 5 | 1 | TBD | LAD | 2017 | 2018 | FLA |
2996 | 2996 | Curtis Granderson | 37 | grandcu01 | 2018 | TOR | AL | 3.344679445 | 0.55 | LF, RF, CF | 7 | 1 | TOR | LAD | 2018 | 2018 | MIL |
3099 | 3099 | Zack Greinke | 33 | greinza01 | 2017 | ARI | NL | 5.680345917 | 5.655 | P | 25 | 1 | ARI | LAD | 2016 | 2019 | HOU |
3171 | 3171 | Jim Johnson | 34 | johnsji04 | 2017 | ATL | NL | 2.067569238 | -0.37 | P | 2 | 1 | ATL | LAD | 2016 | 2017 | ANA |
3186 | 3186 | Micah Johnson | 26 | johnsmi04 | 2017 | ATL | NL | 0.108245674 | -0.115 | LF | 0 | 1 | ATL | LAD | 2017 | 2017 | |
3255 | 3255 | Hanley Ramirez | 33 | ramirha01 | 2017 | BOS | AL | 5.079018211 | -0.38 | 1B | 7 | 1 | BOS | LAD | 2015 | 2018 | CLE |
3331 | 3331 | Mike Freeman | 29 | freemmi01 | 2017 | CHC | NL | 0.263947413 | -0.105 | SS, 1B, 2B, 3B, P | 0 | 3 | CHC | LAD | 2017 | 2018 | CLE |
3337 | 3337 | Brett Anderson | 29 | anderbr04 | 2017 | CHC | NL | 0.60997247 | -0.265 | P | 0 | 1 | CHC | LAD | 2017 | 2017 | TOR |
3398 | 3398 | Scott Schebler | 26 | schebsc01 | 2017 | CIN | NL | 5.233305013 | 1.1 | RF, CF | 10 | 1 | CIN | LAD | 2016 | 2019 | |
3402 | 3402 | Jose Peraza | 23 | perazjo01 | 2017 | CIN | NL | 5.105182668 | -0.54 | 2B, SS, CF | 5 | 1 | CIN | LAD | 2016 | 2019 | |
3572 | 3572 | Josh Reddick | 30 | reddijo01 | 2017 | HOU | AL | 5.017622557 | 3.74 | RF, LF, CF, 1B | 18 | 1 | HOU | LAD | 2017 | 2019 | |
3655 | 3655 | Onelki Garcia | 27 | garcion01 | 2017 | KCR | AL | 0.151409285 | -0.28 | P | 0 | 1 | KCR | LAD | 2017 | 2017 | |
3677 | 3677 | Jesse Chavez | 33 | chaveje01 | 2017 | LAA | AL | 3.821226912 | -0.05 | P | 6 | 1 | ANA | LAD | 2017 | 2017 | TEX |
3678 | 3678 | Bud Norris | 32 | norribu01 | 2017 | LAA | AL | 2.307504174 | 0.505 | P | 5 | 1 | ANA | LAD | 2017 | 2017 | STL |
3773 | 3773 | Dee Gordon | 29 | gordode01 | 2017 | MIA | NL | 6.797639123 | 3.485 | 2B, SS | 20 | 1 | FLA | LAD | 2015 | 2017 | SEA |
3777 | 3777 | Miguel Rojas | 28 | rojasmi02 | 2017 | MIA | NL | 2.992917369 | 1.81 | SS, 3B, 1B, 2B | 9 | 1 | FLA | LAD | 2015 | 2019 | |
3911 | 3911 | Nick Tepesch | 28 | tepesni01 | 2017 | MIN | AL | 0.04729274 | -0.225 | P | 0 | 1 | MIN | LAD | 2017 | 2017 | TOR |
3985 | 3985 | Ronald Torreyes | 24 | torrero01 | 2017 | NYY | AL | 3.079159425 | 0.685 | 2B, SS, 3B, RF | 6 | 1 | NYY | LAD | 2016 | 2018 | MIN |
4037 | 4037 | Danny Coulombe | 27 | couloda01 | 2017 | OAK | AL | 1.574977661 | 0.45 | P | 4 | 1 | OAK | LAD | 2015 | 2018 | |
4045 | 4045 | Chris Hatcher | 32 | hatchch02 | 2017 | OAK | AL | 0.863186817 | 0.29 | P | 2 | 2 | OAK | LAD | 2017 | 2018 | |
4085 | 4085 | Howie Kendrick | 33 | kendrho01 | 2017 | PHI | NL | 1.552771581 | 1.17 | LF, 2B, 1B, RF | 5 | 1 | PHI | LAD | 2017 | 2017 | WSN |
4135 | 4135 | Juan Nicasio | 30 | nicasju01 | 2017 | PIT | NL | 2.226868641 | 1.37 | P | 7 | 1 | PIT | LAD | 2016 | 2017 | PHI |
4204 | 4204 | Zach Lee | 25 | leeza01 | 2017 | SDP | NL | 0.158683883 | 0.01 | P | 0 | 1 | SDP | LAD | 2017 | 2017 | |
4246 | 4246 | Carlos Ruiz | 38 | ruizca01 | 2017 | SEA | AL | 1.369929956 | 0.085 | C, 1B, P | 2 | 1 | SEA | LAD | 2017 | 2017 | |
4278 | 4278 | Casey Fien | 33 | fienca01 | 2017 | SEA | AL | 0.165132766 | -0.42 | P | 0 | 1 | SEA | LAD | 2017 | 2017 | PHI |
4397 | 4397 | Sergio Romo | 34 | romose01 | 2017 | TBR | AL | 0.971432411 | 0.815 | P | 4 | 2 | TBD | LAD | 2017 | 2018 | FLA |
4425 | 4425 | Jose De Leon | 24 | deleojo03 | 2017 | TBR | AL | 0.090311488 | -0.175 | P | 0 | 1 | TBD | LAD | 2017 | 2019 | |
4507 | 4507 | Darwin Barney | 31 | barneda01 | 2017 | TOR | AL | 3.425122349 | -0.62 | 2B, 3B, SS, LF | 3 | 1 | TOR | LAD | 2015 | 2017 | |
4531 | 4531 | J.P. Howell | 34 | howeljp01 | 2017 | TOR | AL | 0.306871326 | -0.215 | P | 0 | 1 | TOR | LAD | 2017 | 2017 | |
4538 | 4538 | Mike Bolsinger | 29 | bolsimi01 | 2017 | TOR | AL | 1.094261017 | -0.405 | P | 0 | 1 | TOR | LAD | 2017 | 2017 | |
4576 | 4576 | Joe Blanton | 36 | blantjo01 | 2017 | WSN | NL | 1.169819402 | -0.18 | P | 1 | 1 | WSN | LAD | 2017 | 2017 | |
4589 | 4589 | Chris Heisey | 32 | heisech01 | 2017 | WSN | NL | 0.783247863 | -0.59 | LF, RF | 0 | 1 | WSN | LAD | 2016 | 2017 | |
4595 | 4595 | Zack Greinke | 32 | greinza01 | 2016 | ARI | NL | 4.344405154 | 2.59 | P | 14 | 1 | ARI | LAD | 2016 | 2019 | HOU |
4649 | 4649 | Jim Johnson | 33 | johnsji04 | 2016 | ATL | NL | 2.442177237 | 1.433850932 | P | 8 | 1 | ATL | LAD | 2016 | 2017 | ANA |
4669 | 4669 | Chris Withrow | 27 | withrch01 | 2016 | ATL | NL | 1.233578813 | 0.045279503 | P | 2 | 1 | ATL | LAD | 2016 | 2016 | |
4756 | 4756 | Hanley Ramirez | 32 | ramirha01 | 2016 | BOS | AL | 5.714285714 | 2.915 | 1B | 15 | 1 | BOS | LAD | 2015 | 2018 | CLE |
4842 | 4842 | Tim Federowicz | 28 | federti01 | 2016 | CHC | NL | 0.322493682 | -0.415 | C | 0 | 1 | CHC | LAD | 2016 | 2016 | SFG |
4867 | 4867 | Jimmy Rollins | 37 | rolliji01 | 2016 | CHW | AL | 1.576035358 | -0.05 | SS | 2 | 1 | CHW | LAD | 2016 | 2016 | |
4906 | 4906 | Scott Schebler | 25 | schebsc01 | 2016 | CIN | NL | 2.83613664 | 0.605 | RF, CF, LF | 6 | 1 | CIN | LAD | 2016 | 2019 | |
4911 | 4911 | Jose Peraza | 22 | perazjo01 | 2016 | CIN | NL | 2.574648864 | 0.4 | SS, CF, 2B, LF | 5 | 1 | CIN | LAD | 2016 | 2019 | |
4922 | 4922 | Matt Magill | 26 | magilma01 | 2016 | CIN | NL | 0.085439735 | -0.06 | P | 0 | 1 | CIN | LAD | 2016 | 2016 | MIN |
5206 | 5206 | Nick Buss | 29 | bussni01 | 2016 | LAA | AL | 0.867109635 | -0.155 | LF, RF, CF | 1 | 1 | ANA | LAD | 2016 | 2016 | |
5218 | 5218 | David Huff | 31 | huffda01 | 2016 | LAA | AL | 0.155153383 | -0.455 | P | 0 | 1 | ANA | LAD | 2016 | 2016 | |
5293 | 5293 | Dee Gordon | 28 | gordode01 | 2016 | MIA | NL | 3.449888259 | 0.830124224 | 2B | 7 | 1 | FLA | LAD | 2015 | 2017 | SEA |
5300 | 5300 | Miguel Rojas | 27 | rojasmi02 | 2016 | MIA | NL | 2.133745917 | -0.070434783 | 2B, 1B, SS, 3B | 3 | 1 | FLA | LAD | 2015 | 2019 | |
5389 | 5389 | Ricky Nolasco | 33 | nolasri01 | 2016 | MIN | AL | 3.536299985 | 1.065 | P | 7 | 1 | MIN | LAD | 2014 | 2016 | ANA |
5492 | 5492 | Ronald Torreyes | 23 | torrero01 | 2016 | NYY | AL | 1.62311641 | 0.5 | 3B, SS, 2B, RF | 4 | 1 | NYY | LAD | 2016 | 2018 | MIN |
5551 | 5551 | Danny Coulombe | 26 | couloda01 | 2016 | OAK | AL | 1.131085895 | 0.345 | P | 3 | 1 | OAK | LAD | 2015 | 2018 | |
5575 | 5575 | Eric Surkamp | 28 | surkaer01 | 2016 | OAK | AL | 1.120094505 | -0.475 | P | 0 | 1 | OAK | LAD | 2016 | 2016 | |
5608 | 5608 | A.J. Ellis | 35 | ellisaj01 | 2016 | PHI | NL | 0.357583231 | 0.145 | C | 1 | 2 | PHI | LAD | 2016 | 2016 | FLA |
5641 | 5641 | Juan Nicasio | 29 | nicasju01 | 2016 | PIT | NL | 3.588447834 | 0.875 | P | 8 | 1 | PIT | LAD | 2016 | 2017 | PHI |
5697 | 5697 | Matt Kemp | 31 | kempma01 | 2016 | SDP | NL | 4.39254964 | 0.29 | RF, LF | 7 | 1 | SDP | LAD | 2015 | 2016 | ATL |
5778 | 5778 | Joel Peralta | 40 | peraljo01 | 2016 | SEA | AL | 0.764379776 | -0.17 | P | 1 | 1 | SEA | LAD | 2016 | 2016 | CHC |
5784 | 5784 | Joe Wieland | 26 | wielajo01 | 2016 | SEA | AL | 0.137353317 | -0.115 | P | 0 | 1 | SEA | LAD | 2016 | 2016 |
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 );