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,430 rows where prev_franch = "STL"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6 | 6 | Carson Kelly | 24 | kellyca02 | 2019 | ARI | NL | 3.559068502 | 1.900188679 | C, 3B | 11 | 1 | ARI | STL | 2019 | 2019 | |
11 | 11 | Luke Weaver | 25 | weavelu01 | 2019 | ARI | NL | 1.810155165 | 1.803396226 | P | 8 | 1 | ARI | STL | 2019 | 2019 | |
208 | 208 | Jason Heyward | 29 | heywaja01 | 2019 | CHC | NL | 5.955718271 | 1.986792453 | RF, CF | 13 | 1 | CHC | STL | 2016 | 2019 | |
324 | 324 | Matt Bowman | 28 | bowmama01 | 2019 | CIN | NL | 0.663262325 | 0.229245283 | P | 2 | 1 | CIN | STL | 2019 | 2019 | |
480 | 480 | Tyson Ross | 32 | rossty01 | 2019 | DET | AL | 1.024995629 | -0.025632911 | P | 1 | 1 | DET | STL | 2019 | 2019 | |
612 | 612 | Albert Pujols | 39 | pujolal01 | 2019 | LAA | AL | 5.072279328 | 0.142641509 | 1B, 3B | 7 | 1 | ANA | STL | 2012 | 2019 | |
700 | 700 | Jedd Gyorko | 30 | gyorkje01 | 2019 | LAD | NL | 0.329829399 | -0.310754717 | 3B, 1B, 2B, P | 0 | 2 | LAD | STL | 2019 | 2019 | |
703 | 703 | Sandy Alcantara | 23 | alcansa01 | 2019 | MIA | NL | 5.563620343 | 2.358679245 | P | 15 | 1 | FLA | STL | 2018 | 2019 | |
723 | 723 | Magneuris Sierra | 23 | sierrma01 | 2019 | MIA | NL | 0.43268206 | 0.382075472 | CF, RF | 2 | 1 | FLA | STL | 2018 | 2019 | |
914 | 914 | Luke Voit | 28 | voitlu01 | 2019 | NYY | AL | 4.758146389 | 1.89 | 1B | 13 | 1 | NYY | STL | 2018 | 2019 | |
972 | 972 | Stephen Piscotty | 28 | piscost01 | 2019 | OAK | AL | 3.67579016 | 0.855849057 | RF | 8 | 1 | OAK | STL | 2018 | 2019 | |
1101 | 1101 | Steven Baron | 28 | baronst01 | 2019 | PIT | NL | 0.089876033 | -0.122264151 | C | 0 | 1 | PIT | STL | 2019 | 2019 | |
1106 | 1106 | Tyler Lyons | 31 | lyonsty01 | 2019 | PIT | NL | 0.197076397 | -0.259811321 | P | 0 | 1 | PIT | STL | 2019 | 2019 | NYY |
1125 | 1125 | Greg Garcia | 29 | garcigr01 | 2019 | SDP | NL | 3.73828125 | 1.411132075 | 2B, 3B, SS, 1B, LF | 9 | 1 | SDP | STL | 2019 | 2019 | |
1171 | 1171 | Marco Gonzales | 27 | gonzama02 | 2019 | SEA | AL | 5.650975061 | 3.397924528 | P | 18 | 1 | SEA | STL | 2017 | 2019 | |
1176 | 1176 | Mike Leake | 31 | leakemi01 | 2019 | SEA | AL | 3.949916242 | 1.569056604 | P | 10 | 1 | SEA | STL | 2017 | 2019 | ARI |
1193 | 1193 | Sam Tuivailala | 26 | tuivasa01 | 2019 | SEA | AL | 0.708915839 | 0.570566038 | P | 3 | 1 | SEA | STL | 2018 | 2019 | |
1347 | 1347 | Tommy Pham | 31 | phamth01 | 2019 | TBR | AL | 6.046186372 | 3.555849057 | LF | 19 | 1 | TBD | STL | 2018 | 2019 | |
1447 | 1447 | Patrick Wisdom | 27 | wisdopa01 | 2019 | TEX | AL | 0.267986799 | -0.280188679 | 1B, 3B | 0 | 1 | TEX | STL | 2019 | 2019 | |
1462 | 1462 | Randal Grichuk | 27 | grichra01 | 2019 | TOR | AL | 5.998323835 | 0.697924528 | RF, CF | 10 | 1 | TOR | STL | 2018 | 2019 | |
1531 | 1531 | Matt Adams | 30 | adamsma01 | 2019 | WSN | NL | 3.236094369 | 0.071320755 | 1B | 5 | 1 | WSN | STL | 2019 | 2019 | |
1562 | 1562 | Trevor Rosenthal | 29 | rosentr01 | 2019 | WSN | NL | 0.179544682 | -0.652075472 | P | 0 | 1 | WSN | STL | 2019 | 2019 | DET |
1661 | 1661 | Miguel Socolovich | 31 | socolmi01 | 2018 | ATL | NL | 0.124181772 | -0.1 | P | 0 | 1 | ATL | STL | 2018 | 2018 | |
1748 | 1748 | Joe Kelly | 30 | kellyjo05 | 2018 | BOS | AL | 2.207760807 | 0.515 | P | 5 | 1 | BOS | STL | 2014 | 2018 | LAD |
1779 | 1779 | Jason Heyward | 28 | heywaja01 | 2018 | CHC | NL | 4.695695364 | 1.79392638 | RF, CF | 13 | 1 | CHC | STL | 2016 | 2019 | |
1983 | 1983 | Adam Ottavino | 32 | ottavad01 | 2018 | COL | NL | 2.889542198 | 2.251104294 | P | 11 | 1 | COL | STL | 2012 | 2018 | NYY |
2166 | 2166 | Albert Pujols | 38 | pujolal01 | 2018 | LAA | AL | 4.745974367 | 0.155 | 1B | 7 | 1 | ANA | STL | 2012 | 2019 | |
2262 | 2262 | Breyvic Valera | 26 | valerbr01 | 2018 | LAD | NL | 0.327302905 | -0.139141104 | 2B, 3B, SS, RF | 0 | 1 | LAD | STL | 2018 | 2018 | BAL |
2288 | 2288 | Sandy Alcantara | 22 | alcansa01 | 2018 | MIA | NL | 0.973835322 | 0.271677019 | P | 2 | 1 | FLA | STL | 2018 | 2019 | |
2317 | 2317 | Magneuris Sierra | 22 | sierrma01 | 2018 | MIA | NL | 1.56 | -1.383540373 | CF, RF | 0 | 1 | FLA | STL | 2018 | 2019 | |
2384 | 2384 | Lance Lynn | 31 | lynnla01 | 2018 | MIN | AL | 2.867214307 | 0.555 | P | 6 | 1 | MIN | STL | 2018 | 2018 | NYY |
2395 | 2395 | Zach Duke | 35 | dukeza01 | 2018 | MIN | AL | 1.251885102 | 0.5 | P | 3 | 1 | MIN | STL | 2018 | 2018 | SEA |
2496 | 2496 | Luke Voit | 27 | voitlu01 | 2018 | NYY | AL | 1.373659786 | 1.62 | 1B, RF | 7 | 2 | NYY | STL | 2018 | 2019 | |
2535 | 2535 | Stephen Piscotty | 27 | piscost01 | 2018 | OAK | AL | 5.628809753 | 2.945 | RF | 17 | 1 | OAK | STL | 2018 | 2019 | |
2575 | 2575 | Josh Lucas | 27 | lucasjo02 | 2018 | OAK | AL | 0.281484118 | -0.1 | P | 0 | 1 | OAK | STL | 2018 | 2018 | BAL |
2576 | 2576 | Dean Kiekhefer | 29 | kiekhde01 | 2018 | OAK | AL | 0.03810441 | -0.135 | P | 0 | 1 | OAK | STL | 2018 | 2018 | |
2732 | 2732 | Marco Gonzales | 26 | gonzama02 | 2018 | SEA | AL | 4.57867903 | 2.92 | P | 16 | 1 | SEA | STL | 2017 | 2019 | |
2735 | 2735 | Mike Leake | 30 | leakemi01 | 2018 | SEA | AL | 5.155790585 | 1.9 | P | 14 | 1 | SEA | STL | 2017 | 2019 | ARI |
2755 | 2755 | Juan Nicasio | 31 | nicasju01 | 2018 | SEA | AL | 1.615357962 | -0.2 | P | 2 | 1 | SEA | STL | 2018 | 2018 | PHI |
2760 | 2760 | Sam Tuivailala | 25 | tuivasa01 | 2018 | SEA | AL | 0.15998152 | 0.155 | P | 1 | 2 | SEA | STL | 2018 | 2019 | |
2885 | 2885 | Tommy Pham | 30 | phamth01 | 2018 | TBR | AL | 1.634861494 | 2.595 | CF, LF | 10 | 2 | TBD | STL | 2018 | 2019 | |
2984 | 2984 | Randal Grichuk | 26 | grichra01 | 2018 | TOR | AL | 4.427627231 | 2.13 | RF, CF, LF | 13 | 1 | TOR | STL | 2018 | 2019 | |
2985 | 2985 | Aledmys Diaz | 27 | diazal02 | 2018 | TOR | AL | 4.331791143 | 1.48 | SS, 3B | 11 | 1 | TOR | STL | 2018 | 2018 | HOU |
2997 | 2997 | Seunghwan Oh | 35 | ohse01 | 2018 | TOR | AL | 1.573629256 | 1.215 | P | 6 | 1 | TOR | STL | 2018 | 2018 | COL |
3040 | 3040 | Preston Guilmet | 30 | guilmpr01 | 2018 | TOR | AL | 0.153584741 | -0.23 | P | 0 | 2 | TOR | STL | 2018 | 2018 | |
3064 | 3064 | Greg Holland | 32 | hollagr01 | 2018 | WSN | NL | 0.75287505 | 0.84 | P | 3 | 2 | WSN | STL | 2018 | 2018 | ARI |
3117 | 3117 | Jeremy Hazelbaker | 29 | hazelje01 | 2017 | ARI | NL | 0.602315288 | 0.895 | LF, RF, CF | 4 | 1 | ARI | STL | 2017 | 2017 | |
3152 | 3152 | Jaime Garcia | 30 | garcija02 | 2017 | ATL | NL | 3.225927066 | 1.56 | P | 9 | 1 | ATL | STL | 2017 | 2017 | MIN |
3157 | 3157 | Matt Adams | 28 | adamsma01 | 2017 | ATL | NL | 3.089921955 | 0.87 | 1B, LF | 7 | 2 | ATL | STL | 2017 | 2017 | WSN |
3257 | 3257 | Joe Kelly | 29 | kellyjo05 | 2017 | BOS | AL | 1.848640702 | 0.995 | P | 6 | 1 | BOS | STL | 2014 | 2018 | LAD |
3298 | 3298 | Jason Heyward | 27 | heywaja01 | 2017 | CHC | NL | 4.702174279 | 1.67 | RF, CF | 12 | 1 | CHC | STL | 2016 | 2019 | |
3303 | 3303 | John Lackey | 38 | lackejo01 | 2017 | CHC | NL | 4.834775204 | 0.84 | P | 9 | 1 | CHC | STL | 2016 | 2017 | |
3484 | 3484 | Mark Reynolds | 33 | reynoma01 | 2017 | COL | NL | 5.865279673 | 0.835 | 1B, LF | 12 | 1 | COL | STL | 2016 | 2017 | WSN |
3500 | 3500 | Adam Ottavino | 31 | ottavad01 | 2017 | COL | NL | 1.68348082 | 0.075 | P | 3 | 1 | COL | STL | 2012 | 2018 | NYY |
3632 | 3632 | Brandon Moss | 33 | mossbr01 | 2017 | KCR | AL | 3.876333333 | -0.71 | 1B, LF, RF | 4 | 1 | KCR | STL | 2017 | 2017 | |
3647 | 3647 | Seth Maness | 28 | manesse01 | 2017 | KCR | AL | 0.226616198 | -0.045 | P | 0 | 1 | KCR | STL | 2017 | 2017 | |
3690 | 3690 | Albert Pujols | 37 | pujolal01 | 2017 | LAA | AL | 6.095175149 | -1.925 | 1B | 3 | 1 | ANA | STL | 2012 | 2019 | |
3859 | 3859 | Michael Blazek | 28 | blazemi01 | 2017 | MIL | NL | 0.220082294 | -0.34 | P | 0 | 1 | MIL | STL | 2013 | 2017 | WSN |
3987 | 3987 | Matt Holliday | 37 | hollima01 | 2017 | NYY | AL | 3.913098436 | -0.01 | 1B | 4 | 1 | NYY | STL | 2017 | 2017 | COL |
4012 | 4012 | Pete Kozma | 29 | kozmape01 | 2017 | NYY | AL | 0.09164165 | -0.19 | 3B, SS, 1B, 2B | 0 | 1 | NYY | STL | 2017 | 2017 | TEX |
4106 | 4106 | Kevin Siegrist | 27 | siegrke01 | 2017 | PHI | NL | 0.124907026 | 0.09 | P | 0 | 2 | PHI | STL | 2017 | 2017 | |
4236 | 4236 | Mike Leake | 29 | leakemi01 | 2017 | SEA | AL | 0.885443077 | 1.08 | P | 4 | 2 | SEA | STL | 2017 | 2019 | ARI |
4244 | 4244 | Marco Gonzales | 25 | gonzama02 | 2017 | SEA | AL | 0.911485521 | 0.145 | P | 2 | 2 | SEA | STL | 2017 | 2019 | |
4254 | 4254 | Steve Cishek | 31 | cishest01 | 2017 | SEA | AL | 0.733923406 | 0.145 | P | 1 | 1 | SEA | STL | 2016 | 2017 | TBD |
4701 | 4701 | A.J. Pierzynski | 39 | pierza.01 | 2016 | ATL | NL | 2.555631167 | -1.499254658 | C | 0 | 1 | ATL | STL | 2015 | 2016 | |
4776 | 4776 | Joe Kelly | 28 | kellyjo05 | 2016 | BOS | AL | 1.385569442 | 0.135 | P | 2 | 1 | BOS | STL | 2014 | 2018 | LAD |
4807 | 4807 | John Lackey | 37 | lackejo01 | 2016 | CHC | NL | 5.262701613 | 2.595 | P | 15 | 1 | CHC | STL | 2016 | 2017 | |
4810 | 4810 | Jason Heyward | 26 | heywaja01 | 2016 | CHC | NL | 5.785341196 | 1.14 | RF, CF | 11 | 1 | CHC | STL | 2016 | 2019 | |
5005 | 5005 | Mark Reynolds | 32 | reynoma01 | 2016 | COL | NL | 4.335989151 | 0.895 | 1B, 2B | 8 | 1 | COL | STL | 2016 | 2017 | WSN |
5007 | 5007 | Daniel Descalso | 29 | descada01 | 2016 | COL | NL | 2.841498559 | 0.625 | SS, 1B, 2B, LF, 3B | 6 | 1 | COL | STL | 2015 | 2016 | ARI |
5009 | 5009 | Adam Ottavino | 30 | ottavad01 | 2016 | COL | NL | 1.0464894 | 0.78 | P | 4 | 1 | COL | STL | 2012 | 2018 | NYY |
5105 | 5105 | Pat Neshek | 35 | neshepa01 | 2016 | HOU | AL | 1.501277473 | 0.54 | P | 4 | 1 | HOU | STL | 2015 | 2016 | PHI |
5162 | 5162 | Tony Cruz | 29 | cruzto03 | 2016 | KCR | AL | 0.048084895 | -0.11 | C | 0 | 1 | KCR | STL | 2016 | 2016 | CIN |
5175 | 5175 | Albert Pujols | 36 | pujolal01 | 2016 | LAA | AL | 6.262458472 | 1.045 | 1B | 12 | 1 | ANA | STL | 2012 | 2019 | |
5194 | 5194 | Fernando Salas | 31 | salasfe01 | 2016 | LAA | AL | 2.068227782 | -0.085 | P | 3 | 1 | ANA | STL | 2014 | 2016 | NYM |
5326 | 5326 | Xavier Scruggs | 28 | scrugxa01 | 2016 | MIA | NL | 0.687983497 | -0.216335404 | 1B, LF | 0 | 1 | FLA | STL | 2016 | 2016 | |
5379 | 5379 | Michael Blazek | 27 | blazemi01 | 2016 | MIL | NL | 1.313849553 | -0.76 | P | 0 | 1 | MIL | STL | 2013 | 2017 | WSN |
5485 | 5485 | Carlos Beltran | 39 | beltrca01 | 2016 | NYY | AL | 3.716840537 | 2.11 | RF | 12 | 1 | NYY | STL | 2014 | 2016 | TEX |
5592 | 5592 | Peter Bourjos | 29 | bourjpe01 | 2016 | PHI | NL | 3.912982209 | 0.115 | RF, CF | 6 | 1 | PHI | STL | 2016 | 2016 | TBD |
5667 | 5667 | Eric Fryer | 30 | fryerer01 | 2016 | PIT | NL | 0.898316498 | -0.245 | C | 1 | 2 | PIT | STL | 2016 | 2016 | STL |
5692 | 5692 | Jon Jay | 31 | jayjo02 | 2016 | SDP | NL | 3.811632402 | 1.045 | CF, RF, LF | 9 | 1 | SDP | STL | 2016 | 2016 | CHC |
5741 | 5741 | Carlos Villanueva | 32 | villaca01 | 2016 | SDP | NL | 2.157199389 | -0.96 | P | 0 | 1 | SDP | STL | 2016 | 2016 | |
5752 | 5752 | Steve Cishek | 30 | cishest01 | 2016 | SEA | AL | 2.651286266 | 1.295 | P | 8 | 1 | SEA | STL | 2016 | 2017 | TBD |
5830 | 5830 | Ruben Tejada | 26 | tejadru01 | 2016 | SFG | NL | 0.373622648 | 0.04 | 3B, SS, 2B, P | 1 | 2 | SFG | STL | 2016 | 2016 | BAL |
6048 | 6048 | Matt Belisle | 36 | belisma01 | 2016 | WSN | NL | 1.229387977 | 0.86 | P | 4 | 1 | WSN | STL | 2016 | 2016 | MIN |
6124 | 6124 | Shelby Miller | 24 | millesh01 | 2015 | ATL | NL | 5.708225966 | 3.5 | P | 19 | 1 | ATL | STL | 2015 | 2015 | ARI |
6132 | 6132 | A.J. Pierzynski | 38 | pierza.01 | 2015 | ATL | NL | 4.43493511 | 1.18 | C | 10 | 1 | ATL | STL | 2015 | 2016 | |
6242 | 6242 | Joe Kelly | 27 | kellyjo05 | 2015 | BOS | AL | 3.752481668 | 1.085 | P | 8 | 1 | BOS | STL | 2014 | 2018 | LAD |
6260 | 6260 | Justin Masterson | 30 | masteju01 | 2015 | BOS | AL | 1.719466262 | -0.08 | P | 2 | 1 | BOS | STL | 2015 | 2015 | |
6274 | 6274 | Edward Mujica | 31 | mujiced01 | 2015 | BOS | AL | 0.422596727 | -0.11 | P | 0 | 1 | BOS | STL | 2014 | 2015 | OAK |
6282 | 6282 | Allen Craig | 30 | craigal01 | 2015 | BOS | AL | 0.821635544 | -0.795 | RF, LF, 1B | 0 | 1 | BOS | STL | 2014 | 2015 | |
6303 | 6303 | Jason Motte | 33 | motteja01 | 2015 | CHC | NL | 1.629822786 | 0.31 | P | 3 | 1 | CHC | STL | 2015 | 2015 | COL |
6453 | 6453 | Marc Rzepczynski | 29 | rzepcma01 | 2015 | CLE | AL | 0.681781215 | -0.020124224 | P | 1 | 1 | CLE | STL | 2013 | 2015 | SDP |
6493 | 6493 | Adam Ottavino | 29 | ottavad01 | 2015 | COL | NL | 0.363317954 | 0.61 | P | 2 | 1 | COL | STL | 2012 | 2018 | NYY |
6511 | 6511 | Daniel Descalso | 28 | descada01 | 2015 | COL | NL | 2.108173913 | -0.8 | SS, 2B, 1B, 3B, RF | 1 | 1 | COL | STL | 2015 | 2016 | ARI |
6517 | 6517 | Jorge Rondon | 27 | rondojo01 | 2015 | COL | NL | 0.01560974 | -0.175 | P | 0 | 1 | COL | STL | 2015 | 2015 | BAL |
6596 | 6596 | Pat Neshek | 34 | neshepa01 | 2015 | HOU | AL | 1.971198504 | 0.19 | P | 3 | 1 | HOU | STL | 2015 | 2016 | PHI |
6663 | 6663 | Albert Pujols | 35 | pujolal01 | 2015 | LAA | AL | 6.423927614 | 2.31 | 1B, 3B | 17 | 1 | ANA | STL | 2012 | 2019 | |
6666 | 6666 | David Freese | 32 | freesda01 | 2015 | LAA | AL | 4.56769437 | 2.29 | 3B | 14 | 1 | ANA | STL | 2014 | 2015 | PIT |
6682 | 6682 | Fernando Salas | 30 | salasfe01 | 2015 | LAA | AL | 2.030499935 | 0.145 | P | 4 | 1 | ANA | STL | 2014 | 2016 | NYM |
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 );