mlb-quasi-win-shares: quasi_winshares.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
1,173 rows where prev_franch = "WSN"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29 | 29 | Greg Holland | 33 | hollagr01 | 2019 | ARI | NL | 1.398574851 | 0.0 | P | 2 | 1 | ARI | WSN | 2019 | 2019 | |
103 | 103 | Pedro Severino | 25 | severpe01 | 2019 | BAL | AL | 3.269090909 | 0.886415094 | C | 6 | 1 | BAL | WSN | 2019 | 2019 | |
183 | 183 | Sandy Leon | 30 | leonsa01 | 2019 | BOS | AL | 1.710186061 | -0.346415094 | C, 1B | 1 | 1 | BOS | WSN | 2015 | 2019 | |
215 | 215 | Brandon Kintzler | 34 | kintzbr01 | 2019 | CHC | NL | 1.897989791 | 1.21245283 | P | 6 | 1 | CHC | WSN | 2018 | 2019 | |
231 | 231 | Tim Collins | 29 | colliti01 | 2019 | CHC | NL | 0.241612568 | 0.096792453 | P | 1 | 1 | CHC | WSN | 2019 | 2019 | |
252 | 252 | Lucas Giolito | 24 | giolilu01 | 2019 | CHW | AL | 5.336638701 | 5.598227848 | P | 24 | 1 | CHW | WSN | 2017 | 2019 | |
261 | 261 | Reynaldo Lopez | 25 | lopezre01 | 2019 | CHW | AL | 5.288221184 | 1.209873418 | P | 11 | 1 | CHW | WSN | 2017 | 2019 | |
273 | 273 | Kelvin Herrera | 29 | herreke01 | 2019 | CHW | AL | 1.506084708 | 0.025632911 | P | 2 | 1 | CHW | WSN | 2019 | 2019 | |
305 | 305 | Tanner Roark | 32 | roarkta01 | 2019 | CIN | NL | 3.125062659 | 1.874716981 | P | 10 | 1 | CIN | WSN | 2019 | 2019 | OAK |
367 | 367 | Oliver Perez | 37 | perezol01 | 2019 | CLE | AL | 1.458787339 | 0.514528302 | P | 4 | 1 | CLE | WSN | 2018 | 2019 | |
371 | 371 | Jefry Rodriguez | 25 | rodrije01 | 2019 | CLE | AL | 1.234653169 | 0.387169811 | P | 3 | 1 | CLE | WSN | 2019 | 2019 | |
449 | 449 | Mark Reynolds | 35 | reynoma01 | 2019 | COL | NL | 1.607527802 | -0.932264151 | 1B, P | 0 | 1 | COL | WSN | 2019 | 2019 | |
459 | 459 | Jordan Zimmermann | 33 | zimmejo02 | 2019 | DET | AL | 3.26641731 | 0.487025316 | P | 5 | 1 | DET | WSN | 2016 | 2019 | |
486 | 486 | Carlos Torres | 36 | torreca01 | 2019 | DET | AL | 0.096801121 | -0.010253165 | P | 0 | 1 | DET | WSN | 2019 | 2019 | |
488 | 488 | Trevor Rosenthal | 29 | rosentr01 | 2019 | DET | AL | 0.266668472 | -0.11278481 | P | 0 | 2 | DET | WSN | 2019 | 2019 | |
519 | 519 | Brad Peacock | 31 | peacobr01 | 2019 | HOU | AL | 2.63822673 | 1.380566038 | P | 7 | 1 | HOU | WSN | 2013 | 2019 | |
766 | 766 | Gio Gonzalez | 33 | gonzagi01 | 2019 | MIL | NL | 2.306003645 | 1.207358491 | P | 7 | 1 | MIL | WSN | 2018 | 2019 | |
775 | 775 | Matt Albers | 36 | alberma01 | 2019 | MIL | NL | 2.049857145 | -0.015283019 | P | 3 | 1 | MIL | WSN | 2018 | 2019 | |
986 | 986 | Blake Treinen | 31 | treinbl01 | 2019 | OAK | AL | 2.281112189 | -0.331132075 | P | 2 | 1 | OAK | WSN | 2017 | 2019 | |
1008 | 1008 | Bryce Harper | 26 | harpebr03 | 2019 | PHI | NL | 6.632846088 | 4.284339623 | RF | 23 | 1 | PHI | WSN | 2019 | 2019 | |
1069 | 1069 | Felipe Vazquez | 27 | riverfe01 | 2019 | PIT | NL | 2.374452723 | 2.526792453 | P | 11 | 1 | PIT | WSN | 2016 | 2019 | |
1130 | 1130 | Craig Stammen | 35 | stammcr01 | 2019 | SDP | NL | 3.190509031 | 0.590943396 | P | 6 | 1 | SDP | WSN | 2017 | 2019 | |
1181 | 1181 | Tommy Milone | 32 | milonto01 | 2019 | SEA | AL | 3.426118197 | 0.703018868 | P | 7 | 1 | SEA | WSN | 2019 | 2019 | |
1189 | 1189 | Austin Adams | 28 | adamsau02 | 2019 | SEA | AL | 1.10407706 | 0.713207547 | P | 4 | 2 | SEA | WSN | 2019 | 2019 | |
1257 | 1257 | Mark Melancon | 34 | melanma01 | 2019 | SFG | NL | 1.316289401 | 0.54509434 | P | 4 | 1 | SFG | WSN | 2017 | 2019 | ATL |
1258 | 1258 | Trevor Gott | 26 | gotttr01 | 2019 | SFG | NL | 1.641998791 | 0.53490566 | P | 4 | 1 | SFG | WSN | 2019 | 2019 | |
1280 | 1280 | Kyle Barraclough | 29 | barraky01 | 2019 | SFG | NL | 0.298222956 | -0.045849057 | P | 0 | 2 | SFG | WSN | 2019 | 2019 | |
1326 | 1326 | Matt Wieters | 33 | wietema01 | 2019 | STL | NL | 1.850741064 | 0.091698113 | C | 3 | 1 | STL | WSN | 2019 | 2019 | |
1439 | 1439 | David Carpenter | 33 | carpeda01 | 2019 | TEX | AL | 0.067840076 | -0.040754717 | P | 0 | 1 | TEX | WSN | 2019 | 2019 | |
1498 | 1498 | Jimmy Cordero | 27 | cordeji01 | 2019 | TOR | AL | 0.034495847 | -0.056037736 | P | 0 | 1 | TOR | WSN | 2019 | 2019 | CHW |
1751 | 1751 | Sandy Leon | 29 | leonsa01 | 2018 | BOS | AL | 2.659025788 | 0.0 | C | 4 | 1 | BOS | WSN | 2015 | 2019 | |
1795 | 1795 | Daniel Murphy | 33 | murphda08 | 2018 | CHC | NL | 1.401986755 | 0.31803681 | 2B, 1B | 3 | 2 | CHC | WSN | 2018 | 2018 | COL |
1819 | 1819 | Brandon Kintzler | 33 | kintzbr01 | 2018 | CHC | NL | 0.573495288 | -0.422392638 | P | 0 | 2 | CHC | WSN | 2018 | 2019 | |
1822 | 1822 | Reynaldo Lopez | 24 | lopezre01 | 2018 | CHW | AL | 5.33266513 | 2.675 | P | 15 | 1 | CHW | WSN | 2017 | 2019 | |
1842 | 1842 | Lucas Giolito | 23 | giolilu01 | 2018 | CHW | AL | 4.873208379 | -0.665 | P | 4 | 1 | CHW | WSN | 2017 | 2019 | |
1938 | 1938 | Oliver Perez | 36 | perezol01 | 2018 | CLE | AL | 0.985553993 | 1.12 | P | 5 | 1 | CLE | WSN | 2018 | 2019 | |
2026 | 2026 | Jordan Zimmermann | 32 | zimmejo02 | 2018 | DET | AL | 3.68868651 | 0.745 | P | 7 | 1 | DET | WSN | 2016 | 2019 | |
2087 | 2087 | Brad Peacock | 30 | peacobr01 | 2018 | HOU | AL | 1.939483148 | 0.665 | P | 5 | 1 | HOU | WSN | 2013 | 2019 | |
2129 | 2129 | Brian Goodwin | 27 | goodwbr01 | 2018 | KCR | AL | 0.969707002 | 0.42 | CF, LF, RF | 2 | 2 | KCR | WSN | 2018 | 2018 | ANA |
2255 | 2255 | Ryan Madson | 37 | madsory01 | 2018 | LAD | NL | 0.214921338 | 0.00993865 | P | 0 | 2 | LAD | WSN | 2018 | 2018 | |
2311 | 2311 | Jacob Turner | 27 | turneja01 | 2018 | MIA | NL | 0.156262583 | -0.402484472 | P | 0 | 1 | FLA | WSN | 2018 | 2018 | DET |
2342 | 2342 | Gio Gonzalez | 32 | gonzagi01 | 2018 | MIL | NL | 0.689439024 | 0.591349693 | P | 3 | 2 | MIL | WSN | 2018 | 2019 | |
2370 | 2370 | Matt Albers | 35 | alberma01 | 2018 | MIL | NL | 1.138143776 | -1.257239264 | P | 0 | 1 | MIL | WSN | 2018 | 2019 | |
2447 | 2447 | Jerry Blevins | 34 | blevije01 | 2018 | NYM | NL | 1.303949018 | 0.03 | P | 2 | 1 | NYM | WSN | 2015 | 2018 | ATL |
2475 | 2475 | Jose Lobaton | 33 | lobatjo01 | 2018 | NYM | NL | 0.565708419 | -0.405 | C | 0 | 1 | NYM | WSN | 2018 | 2018 | |
2516 | 2516 | A.J. Cole | 26 | coleaj01 | 2018 | NYY | AL | 0.885545188 | -0.13 | P | 1 | 2 | NYY | WSN | 2018 | 2018 | CLE |
2534 | 2534 | Blake Treinen | 30 | treinbl01 | 2018 | OAK | AL | 3.579078864 | 3.92 | P | 17 | 1 | OAK | WSN | 2017 | 2019 | |
2543 | 2543 | Edwin Jackson | 34 | jacksed01 | 2018 | OAK | AL | 2.534822616 | 1.14 | P | 7 | 1 | OAK | WSN | 2018 | 2018 | TOR |
2555 | 2555 | Shawn Kelley | 34 | kellesh01 | 2018 | OAK | AL | 0.510501394 | 0.485 | P | 2 | 2 | OAK | WSN | 2018 | 2018 | TEX |
2639 | 2639 | Felipe Vazquez | 26 | riverfe01 | 2018 | PIT | NL | 2.850599367 | 1.81621118 | P | 10 | 1 | PIT | WSN | 2016 | 2019 | |
2664 | 2664 | Enny Romero | 27 | romeren01 | 2018 | PIT | NL | 0.078090256 | 0.050310559 | P | 0 | 2 | PIT | WSN | 2018 | 2018 | KCR |
2685 | 2685 | Craig Stammen | 34 | stammcr01 | 2018 | SDP | NL | 2.988231525 | 1.835 | P | 10 | 1 | SDP | WSN | 2017 | 2019 | |
2779 | 2779 | Marc Rzepczynski | 32 | rzepcma01 | 2018 | SEA | AL | 0.240219777 | -0.485 | P | 0 | 1 | SEA | WSN | 2017 | 2018 | CLE |
2805 | 2805 | Mark Melancon | 33 | melanma01 | 2018 | SFG | NL | 1.416504426 | 0.175 | P | 3 | 1 | SFG | WSN | 2017 | 2019 | ATL |
2870 | 2870 | Matt Adams | 29 | adamsma01 | 2018 | STL | NL | 0.592542142 | -0.29 | 1B, LF, RF | 0 | 2 | STL | WSN | 2018 | 2018 | WSN |
2888 | 2888 | Wilson Ramos | 30 | ramoswi01 | 2018 | TBR | AL | 2.959663049 | 1.75 | C | 9 | 1 | TBD | WSN | 2017 | 2018 | PHI |
3260 | 3260 | Sandy Leon | 28 | leonsa01 | 2017 | BOS | AL | 2.764528899 | 0.59 | C | 6 | 1 | BOS | WSN | 2015 | 2019 | |
3357 | 3357 | Lucas Giolito | 22 | giolilu01 | 2017 | CHW | AL | 1.321937491 | 0.89 | P | 4 | 1 | CHW | WSN | 2017 | 2019 | |
3358 | 3358 | Reynaldo Lopez | 23 | lopezre01 | 2017 | CHW | AL | 1.404844471 | 0.33 | P | 3 | 1 | CHW | WSN | 2017 | 2019 | |
3529 | 3529 | Jordan Zimmermann | 31 | zimmejo02 | 2017 | DET | AL | 4.738180427 | 0.69 | P | 8 | 1 | DET | WSN | 2016 | 2019 | |
3551 | 3551 | Matt den Dekker | 29 | dendema01 | 2017 | DET | AL | 0.075718016 | 0.015 | RF, LF | 0 | 1 | DET | WSN | 2017 | 2017 | NYM |
3573 | 3573 | Brad Peacock | 29 | peacobr01 | 2017 | HOU | AL | 3.519431892 | 3.34 | P | 15 | 1 | HOU | WSN | 2013 | 2019 | |
3666 | 3666 | Yusmeiro Petit | 32 | petityu01 | 2017 | LAA | AL | 2.855350326 | 1.875 | P | 10 | 1 | ANA | WSN | 2017 | 2017 | OAK |
3673 | 3673 | Yunel Escobar | 34 | escobyu01 | 2017 | LAA | AL | 3.651354924 | 0.505 | 3B | 7 | 1 | ANA | WSN | 2016 | 2017 | |
3679 | 3679 | Ben Revere | 29 | reverbe01 | 2017 | LAA | AL | 2.951751487 | 0.065 | LF, CF | 5 | 1 | ANA | WSN | 2017 | 2017 | |
3716 | 3716 | Danny Espinosa | 30 | espinda01 | 2017 | LAA | AL | 2.434236616 | -1.15 | 2B, 3B, 1B, SS | 0 | 1 | ANA | WSN | 2017 | 2017 | SEA |
3794 | 3794 | Tyler Moore | 30 | moorety01 | 2017 | MIA | NL | 1.98549747 | -0.265 | 1B, LF, RF | 2 | 1 | FLA | WSN | 2017 | 2017 | |
3882 | 3882 | Matt Belisle | 37 | belisma01 | 2017 | MIN | AL | 2.261301122 | 0.35 | P | 4 | 1 | MIN | WSN | 2017 | 2017 | CLE |
3927 | 3927 | Jerry Blevins | 33 | blevije01 | 2017 | NYM | NL | 1.816968608 | 1.14 | P | 6 | 1 | NYM | WSN | 2015 | 2018 | ATL |
4029 | 4029 | Blake Treinen | 29 | treinbl01 | 2017 | OAK | AL | 1.833601809 | 1.21 | P | 6 | 2 | OAK | WSN | 2017 | 2019 | |
4132 | 4132 | Felipe Vazquez | 25 | riverfe01 | 2017 | PIT | NL | 2.784498452 | 2.435 | P | 11 | 1 | PIT | WSN | 2016 | 2019 | |
4180 | 4180 | Craig Stammen | 33 | stammcr01 | 2017 | SDP | NL | 2.749006483 | 1.125 | P | 8 | 1 | SDP | WSN | 2017 | 2019 | |
4245 | 4245 | Marc Rzepczynski | 31 | rzepcma01 | 2017 | SEA | AL | 1.21008581 | 0.1 | P | 2 | 1 | SEA | WSN | 2017 | 2018 | CLE |
4294 | 4294 | Denard Span | 33 | spande01 | 2017 | SFG | NL | 5.402302801 | -0.02 | CF | 7 | 1 | SFG | WSN | 2016 | 2017 | TBD |
4305 | 4305 | Mark Melancon | 32 | melanma01 | 2017 | SFG | NL | 1.162628382 | 0.275 | P | 2 | 1 | SFG | WSN | 2017 | 2019 | ATL |
4325 | 4325 | Chris Marrero | 28 | marrech01 | 2017 | SFG | NL | 0.408661282 | -0.535 | LF | 0 | 1 | SFG | WSN | 2017 | 2017 | |
4379 | 4379 | Steven Souza Jr. | 28 | souzast01 | 2017 | TBR | AL | 5.845475335 | 3.925 | RF, CF | 19 | 1 | TBD | WSN | 2015 | 2017 | ARI |
4405 | 4405 | Wilson Ramos | 29 | ramoswi01 | 2017 | TBR | AL | 2.122182293 | 0.165 | C | 3 | 1 | TBD | WSN | 2017 | 2018 | PHI |
4431 | 4431 | Xavier Cedeno | 30 | cedenxa01 | 2017 | TBR | AL | 0.153714435 | -0.74 | P | 0 | 1 | TBD | WSN | 2015 | 2017 | CHW |
4534 | 4534 | Mat Latos | 29 | latosma01 | 2017 | TOR | AL | 0.399245858 | -0.235 | P | 0 | 1 | TOR | WSN | 2017 | 2017 | |
4759 | 4759 | Sandy Leon | 27 | leonsa01 | 2016 | BOS | AL | 2.608294931 | 2.495 | C | 10 | 1 | BOS | WSN | 2015 | 2019 | |
4927 | 4927 | Abel De Los Santos | 23 | delosab01 | 2016 | CIN | NL | 0.108291073 | -0.155 | P | 0 | 1 | CIN | WSN | 2016 | 2016 | |
5054 | 5054 | Jordan Zimmermann | 30 | zimmejo02 | 2016 | DET | AL | 2.913473027 | 0.910621118 | P | 7 | 1 | DET | WSN | 2016 | 2019 | |
5099 | 5099 | Doug Fister | 32 | fistedo01 | 2016 | HOU | AL | 4.990421584 | 0.325 | P | 8 | 1 | HOU | WSN | 2016 | 2016 | BOS |
5113 | 5113 | Brad Peacock | 28 | peacobr01 | 2016 | HOU | AL | 0.680547719 | 0.095 | P | 1 | 1 | HOU | WSN | 2013 | 2019 | |
5174 | 5174 | Yunel Escobar | 33 | escobyu01 | 2016 | LAA | AL | 5.462790698 | 1.61 | 3B | 12 | 1 | ANA | WSN | 2016 | 2017 | |
5450 | 5450 | Jerry Blevins | 32 | blevije01 | 2016 | NYM | NL | 1.530091661 | 0.81 | P | 4 | 1 | NYM | WSN | 2015 | 2018 | ATL |
5624 | 5624 | Emmanuel Burriss | 31 | burriem01 | 2016 | PHI | NL | 0.510833187 | -0.62 | 2B, LF, SS, 1B | 0 | 1 | PHI | WSN | 2016 | 2016 | |
5656 | 5656 | Felipe Vazquez | 24 | riverfe01 | 2016 | PIT | NL | 0.9663472 | 0.13 | P | 2 | 2 | PIT | WSN | 2016 | 2019 | |
5730 | 5730 | Matt Thornton | 39 | thornma01 | 2016 | SDP | NL | 0.351030756 | -0.13 | P | 0 | 1 | SDP | WSN | 2016 | 2016 | |
5803 | 5803 | Denard Span | 32 | spande01 | 2016 | SFG | NL | 6.26309544 | 1.225 | CF | 12 | 1 | SFG | WSN | 2016 | 2017 | TBD |
5893 | 5893 | Steven Souza Jr. | 27 | souzast01 | 2016 | TBR | AL | 4.508221226 | 0.915 | RF, CF | 8 | 1 | TBD | WSN | 2015 | 2017 | ARI |
5900 | 5900 | Xavier Cedeno | 29 | cedenxa01 | 2016 | TBR | AL | 1.585518728 | 0.72 | P | 4 | 1 | TBD | WSN | 2015 | 2017 | CHW |
5932 | 5932 | Ian Desmond | 30 | desmoia01 | 2016 | TEX | AL | 6.472061975 | 3.11 | CF, LF | 21 | 1 | TEX | WSN | 2016 | 2016 | COL |
6027 | 6027 | Drew Storen | 28 | storedr01 | 2016 | TOR | AL | 0.965620384 | -0.365 | P | 0 | 1 | TOR | WSN | 2016 | 2016 | SEA |
6280 | 6280 | Sandy Leon | 26 | leonsa01 | 2015 | BOS | AL | 1.195106246 | -0.56 | C, 3B | 0 | 1 | BOS | WSN | 2015 | 2019 | |
6308 | 6308 | Edwin Jackson | 31 | jacksed01 | 2015 | CHC | NL | 0.705824227 | 0.22 | P | 2 | 1 | CHC | WSN | 2013 | 2015 | ATL |
6326 | 6326 | Rafael Soriano | 35 | soriara01 | 2015 | CHC | NL | 0.219663413 | -0.205 | P | 0 | 1 | CHC | WSN | 2015 | 2015 | |
6352 | 6352 | Adam LaRoche | 35 | larocad01 | 2015 | CHW | AL | 4.642301968 | -0.99 | 1B, P | 4 | 1 | CHW | WSN | 2015 | 2015 | |
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 |
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 );