mlb-quasi-win-shares: quasi_winshares.csv

Table actions

This table contains data behind the story The Twins’ Magical Run Will Likely Go Through The Yankees. (Because Of Course.)

quasi_winshares.csv contains Quasi-Win Shares (QWS), prorated to 162 team games, for every player from 1901 as of Sept. 27, 2019.

Column Description
name_common Player name
age Player's age on June 30 of season
player_ID Player's Baseball-Reference.com ID
year_ID Season
team_ID Baseball-Reference ID of team
lg_ID League of team
pct_PT Share of total team playing time (measured by plate appearances and leverage-weighted innings) for player
WAR162 Wins Above Replacement per 162 team games, averaging B-R and FG WAR
def_pos Defensive positions played, in order of innings/games. (Will not include DH or any position for players with 0 PA.)
quasi_ws Quasi Win Shares. Three times total wins created per 162 games; generated by adding WAR162 to wins BELOW replacement (determined by playing time) and rounding to nearest whole number
stint_ID Order of team stints for player within season
franch_id Lahman DB franchise ID for team
prev_franch Previous franchise played for (NULL if player debuted for team)
year_acq First season for player with that franchise
year_left Last season for player with that franchise
next_franch Next franchise played for (NULL if player retired with or is currently on team)

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

2,276 rows where prev_franch = "CIN"

✎ View and edit SQL

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
68 68 Adam Duvall 30 duvalad01 2019 ATL NL 1.229822161 0.417735849 LF, RF 3 1 ATL CIN 2018 2019  
105 105 Asher Wojciechowski 30 wojcias01 2019 BAL AL 2.165530176 0.820188679 P 5 1 BAL CIN 2019 2019  
132 132 Mason Williams 27 willima10 2019 BAL AL 0.325950413 -0.091698113 CF, LF, RF 0 1 BAL CIN 2019 2019  
364 364 Yasiel Puig 28 puigya01 2019 CLE AL 1.971342886 0.682641509 RF 5 2 CLE CIN 2019 2019  
466 466 Brandon Dixon 27 dixonbr01 2019 DET AL 4.080500592 -0.256329114 1B, LF, RF, 3B, 2B, P 4 1 DET CIN 2019 2019  
557 557 Homer Bailey 33 baileho02 2019 KCR AL 2.606832458 1.090188679 P 6 1 KCR CIN 2019 2019 OAK
560 560 Billy Hamilton 28 hamilbi02 2019 KCR AL 2.968618896 0.412641509 CF 5 1 KCR CIN 2019 2019 ATL
636 636 Matt Harvey 30 harvema01 2019 LAA AL 1.731686227 -0.489056604 P 1 1 ANA CIN 2019 2019  
638 638 JC Ramirez 30 ramirjc01 2019 LAA AL 0.151476631 0.030566038 P 0 1 ANA CIN 2016 2019  
654 654 Zack Cozart 33 cozarza01 2019 LAA AL 1.012563224 -0.860943396 3B, SS, 2B 0 1 ANA CIN 2018 2019  
684 684 Dylan Floro 28 florody01 2019 LAD NL 1.543353684 0.081509434 P 2 1 LAD CIN 2018 2019  
725 725 Austin Brice 27 briceau01 2019 MIA NL 1.291878677 0.163018868 P 2 1 FLA CIN 2019 2019  
728 728 Chad Wallach 27 wallach01 2019 MIA NL 0.556305506 0.178301887 C 1 1 FLA CIN 2018 2019  
733 733 Wilkin Castillo 35 castiwi01 2019 MIA NL 0.072113677 -0.081509434 C 0 1 FLA CIN 2019 2019  
836 836 Matt Magill 29 magilma01 2019 MIN AL 0.693097034 -0.117169811 P 1 1 MIN CIN 2018 2019 SEA
983 983 Tanner Roark 32 roarkta01 2019 OAK AL 1.327877271 0.208867925 P 3 2 OAK CIN 2019 2019  
1057 1057 Jared Hughes 33 hugheja02 2019 PHI NL 0.719473791 -0.229245283 P 0 2 PHI CIN 2019 2019  
1059 1059 Phil Gosselin 30 gosseph01 2019 PHI NL 0.578503869 -0.315849057 SS, LF, 3B 0 1 PHI CIN 2019 2019  
1102 1102 Rookie Davis 26 davisro03 2019 PIT NL 0.239034598 -0.13245283 P 0 1 PIT CIN 2019 2019  
1150 1150 Matt Wisler 26 wislema01 2019 SDP NL 0.902489196 -0.035660377 P 1 1 SDP CIN 2019 2019 SEA
1274 1274 Scooter Gennett 29 gennesc01 2019 SFG NL 0.673600277 0.071320755 2B 1 2 SFG CIN 2019 2019  
1282 1282 Wandy Peralta 27 peralwa01 2019 SFG NL 0.152486579 -0.076415094 P 0 2 SFG CIN 2019 2019  
1406 1406 Shin-Soo Choo 36 choosh01 2019 TEX AL 6.173267327 1.61490566 RF, LF 14 1 TEX CIN 2014 2019  
1448 1448 Tim Federowicz 31 federti01 2019 TEX AL 0.794389439 -0.290377358 C, P 0 1 TEX CIN 2019 2019  
1536 1536 Tanner Rainey 26 raineta01 2019 WSN NL 1.392909286 0.315849057 P 3 1 WSN CIN 2019 2019  
1594 1594 Patrick Kivlehan 28 kivlepa01 2018 ARI NL 0.139399142 0.12 LF 1 1 ARI CIN 2018 2018  
1599 1599 Kristopher Negron 32 negrokr01 2018 ARI NL 0.029871245 0.055 3B, LF, 2B, SS, RF 0 1 ARI CIN 2017 2018 SEA
1671 1671 Adam Duvall 29 duvalad01 2018 ATL NL 0.558163093 -0.485 LF, 1B, RF, 3B 0 2 ATL CIN 2018 2019  
1762 1762 Tony Renda 27 rendato01 2018 BOS AL 0.0 0.005   0 1 BOS CIN 2018 2018  
1820 1820 Luke Farrell 27 farrelu01 2018 CHC NL 0.916996572 -0.506871166 P 0 1 CHC CIN 2018 2018 TEX
2120 2120 Rosell Herrera 25 herrero02 2018 KCR AL 2.774706174 0.675 RF, 2B, CF, 3B, LF 5 2 KCR CIN 2018 2018 FLA
2173 2173 Zack Cozart 32 cozarza01 2018 LAA AL 2.41110746 0.19 3B, 2B, SS 4 1 ANA CIN 2018 2019  
2187 2187 Blake Wood 32 woodbl01 2018 LAA AL 0.354303576 0.165 P 1 1 ANA CIN 2017 2018  
2204 2204 John Lamb 27 lambjo02 2018 LAA AL 0.295780217 -0.27 P 0 1 ANA CIN 2018 2018  
2207 2207 JC Ramirez 29 ramirjc01 2018 LAA AL 0.197186812 -0.365 P 0 1 ANA CIN 2016 2019  
2233 2233 Dylan Floro 27 florody01 2018 LAD NL 0.940755123 0.854723926 P 4 2 LAD CIN 2018 2019  
2246 2246 Tony Cingrani 28 cingrto01 2018 LAD NL 0.747878231 0.15404908 P 1 1 LAD CIN 2017 2018  
2257 2257 Daniel Corcino 27 corcida01 2018 LAD NL 0.065701093 -0.00993865 P 0 1 LAD CIN 2018 2018  
2277 2277 Dan Straily 29 straida01 2018 MIA NL 3.46662217 0.674161491 P 7 1 FLA CIN 2017 2018 BAL
2292 2292 Chad Wallach 26 wallach01 2018 MIA NL 0.52 0.19621118 C 1 1 FLA CIN 2018 2019  
2397 2397 Matt Magill 28 magilma01 2018 MIN AL 1.697496585 0.215 P 3 1 MIN CIN 2018 2019 SEA
2441 2441 Devin Mesoraco 30 mesorde01 2018 NYM NL 2.272758385 0.305 C, 1B 4 2 NYM CIN 2018 2018  
2772 2772 Zach Vincej 27 vinceza01 2018 SEA AL 0.038252267 -0.02 3B 0 1 SEA CIN 2018 2018  
2933 2933 Shin-Soo Choo 35 choosh01 2018 TEX AL 6.277669271 2.525 RF, LF 15 1 TEX CIN 2014 2019  
2953 2953 Yovani Gallardo 32 gallayo01 2018 TEX AL 2.638833398 0.365 P 4 2 TEX CIN 2018 2018  
3026 3026 Deck McGuire 29 mcguide02 2018 TOR AL 0.156144487 0.015 P 0 1 TOR CIN 2018 2018 ANA
3120 3120 J.J. Hoover 29 hoovejj01 2017 ARI NL 1.340355259 0.22 P 3 1 ARI CIN 2017 2017 MIL
3139 3139 Kristopher Negron 31 negrokr01 2017 ARI NL 0.306094654 -0.195 LF, SS, 1B, 2B 0 1 ARI CIN 2017 2018 SEA
3149 3149 Brandon Phillips 36 phillbr01 2017 ATL NL 4.910417374 1.17 2B, 3B 11 1 ATL CIN 2017 2017 ANA
3283 3283 Steve Selsky 27 selskst01 2017 BOS AL 0.082660333 -0.075 3B, CF 0 1 BOS CIN 2017 2017  
3341 3341 Todd Frazier 31 frazito01 2017 CHW AL 3.217420103 1.855 3B, 1B 10 1 CHW CIN 2016 2017 NYY
3377 3377 David Holmberg 25 holmbda01 2017 CHW AL 1.384832441 -0.415 P 1 1 CHW CIN 2017 2017  
3610 3610 Dayan Diaz 28 diazda01 2017 HOU AL 0.254572843 -0.215 P 0 1 HOU CIN 2017 2017  
3669 3669 JC Ramirez 28 ramirjc01 2017 LAA AL 4.12353477 1.325 P 10 1 ANA CIN 2016 2019  
3693 3693 Blake Wood 31 woodbl01 2017 LAA AL 0.463138418 0.11 P 1 2 ANA CIN 2017 2018  
3695 3695 Daniel Wright 26 wrighda04 2017 LAA AL 0.427458945 0.04 P 1 1 ANA CIN 2016 2017  
3742 3742 Tony Cingrani 27 cingrto01 2017 LAD NL 0.532282908 0.32 P 2 2 LAD CIN 2017 2018  
3776 3776 Dan Straily 28 straida01 2017 MIA NL 5.180324972 1.24 P 11 1 FLA CIN 2017 2018 BAL
3906 3906 Tim Melville 27 melviti01 2017 MIN AL 0.097114505 -0.16 P 0 1 MIN CIN 2017 2017 SDP
3916 3916 Jay Bruce 30 bruceja01 2017 NYM NL 4.445508982 2.405 RF, 1B 13 1 NYM CIN 2016 2017 CLE
4050 4050 Josh Smith 29 smithjo07 2017 OAK AL 0.80421132 0.08 P 1 1 OAK CIN 2017 2017 BOS
4418 4418 Jumbo Diaz 33 diazju03 2017 TBR AL 1.06417686 -0.27 P 1 1 TBD CIN 2017 2017  
4443 4443 Shin-Soo Choo 34 choosh01 2017 TEX AL 6.05316705 0.68 RF 11 1 TEX CIN 2014 2019  
4511 4511 Rafael Lopez 29 lopezra02 2017 TOR AL 0.596084829 0.315 C, 3B 2 1 TOR CIN 2017 2017 SDP
4744 4744 Logan Ondrusek 31 ondrulo01 2016 BAL AL 0.178342197 -0.205 P 0 1 BAL CIN 2016 2016  
4786 4786 Ryan LaMarre 27 lamarry01 2016 BOS AL 0.055299539 -0.09 LF, P, RF 0 1 BOS CIN 2016 2016 OAK
4825 4825 Travis Wood 29 woodtr01 2016 CHC NL 1.93243833 0.26 P, LF 3 1 CHC CIN 2012 2016 KCR
4847 4847 Todd Frazier 30 frazito01 2016 CHW AL 6.323129808 3.015 3B, 1B 17 1 CHW CIN 2016 2017 NYY
5191 5191 JC Ramirez 27 ramirjc01 2016 LAA AL 1.513678892 0.385 P 3 2 ANA CIN 2016 2019  
5204 5204 Daniel Wright 25 wrighda04 2016 LAA AL 0.775766914 -0.085 P 1 2 ANA CIN 2016 2017  
5461 5461 Jay Bruce 29 bruceja01 2016 NYM NL 1.872582873 -0.125 RF, CF 2 2 NYM CIN 2016 2017 CLE
5490 5490 Aroldis Chapman 28 chapmar01 2016 NYY AL 1.397983091 1.385 P 6 1 NYY CIN 2016 2016 CHC
5672 5672 Curtis Partch 29 partccu01 2016 PIT NL 0.015679672 -0.09 P 0 1 PIT CIN 2016 2016  
5877 5877 Brayan Pena 34 penabr01 2016 STL NL 0.137697134 -0.22 C, 1B 0 1 STL CIN 2016 2016  
5951 5951 Shin-Soo Choo 33 choosh01 2016 TEX AL 2.007582001 0.445 RF 5 1 TEX CIN 2014 2019  
5984 5984 Edwin Encarnacion 33 encared01 2016 TOR AL 6.567096774 3.88 1B 20 1 TOR CIN 2009 2016 CLE
6298 6298 Travis Wood 28 woodtr01 2015 CHC NL 2.741733715 0.66 P 6 1 CHC CIN 2012 2016 KCR
6533 6533 Alfredo Simon 34 simonal01 2015 DET AL 5.325206653 0.357204969 P 9 1 DET CIN 2015 2015 CIN
6633 6633 Johnny Cueto 29 cuetojo01 2015 KCR AL 2.274600569 0.64 P 6 2 KCR CIN 2015 2015 SFG
6746 6746 Chris Heisey 30 heisech01 2015 LAD NL 0.727146091 -0.005 LF, RF, CF 1 1 LAD CIN 2015 2015 WSN
6778 6778 Mat Latos 27 latosma01 2015 MIA NL 2.532956388 1.105 P 7 1 FLA CIN 2015 2015 LAD
6851 6851 Jonathan Broxton 31 broxtjo01 2015 MIL NL 1.107594663 -0.225 P 1 1 MIL CIN 2014 2015 STL
7171 7171 Yonder Alonso 28 alonsyo01 2015 SDP NL 4.089091547 1.365 1B, 3B 10 1 SDP CIN 2012 2015 OAK
7280 7280 Marlon Byrd 37 byrdma01 2015 SFG NL 1.560269012 0.575 LF, RF, CF 4 2 SFG CIN 2015 2015 CLE
7284 7284 Mike Leake 27 leakemi01 2015 SFG NL 1.537361462 0.21 P 3 2 SFG CIN 2015 2015 STL
7308 7308 Jeremy Affeldt 36 affelje01 2015 SFG NL 1.19167552 -0.855 P 0 1 SFG CIN 2009 2015  
7403 7403 Jake Elmore 28 elmorja01 2015 TBR AL 1.51446042 -0.88 1B, 3B, 2B, SS, LF, P 0 1 TBD CIN 2015 2015 MIL
7407 7407 Shin-Soo Choo 32 choosh01 2015 TEX AL 6.143390105 3.395 RF 20 1 TEX CIN 2014 2019  
7465 7465 Edwin Encarnacion 32 encared01 2015 TOR AL 5.830836153 4.495 1B 21 1 TOR CIN 2009 2016 CLE
7511 7511 Todd Redmond 30 redmoto01 2015 TOR AL 0.386011261 -0.225 P 0 1 TOR CIN 2013 2015  
7569 7569 Didi Gregorius 24 gregodi01 2014 ARI NL 3.010763889 0.715 SS, 2B, 3B 6 1 ARI CIN 2013 2014 NYY
7572 7572 Bronson Arroyo 37 arroybr01 2014 ARI NL 2.404983821 0.585 P 5 1 ARI CIN 2014 2014 CIN
7607 7607 Xavier Paul 29 paulxa01 2014 ARI NL 0.211458333 -0.345 LF 0 1 ARI CIN 2014 2014  
7757 7757 Travis Wood 27 woodtr01 2014 CHC NL 4.802575969 1.175 P 10 1 CHC CIN 2012 2016 KCR
7839 7839 Paul Konerko 38 konerpa01 2014 CHW AL 2.146373699 -1.005 1B 0 1 CHW CIN 1999 2014  
7952 7952 Matt Belisle 34 belisma01 2014 COL NL 1.863081797 0.25 P 3 1 COL CIN 2009 2014 STL
7962 7962 Nick Masset 32 masseni01 2014 COL NL 1.262887025 -0.32 P 1 1 COL CIN 2014 2014 FLA
8204 8204 Roger Bernadina 30 bernaro01 2014 LAD NL 0.088926746 0.18 LF, RF, CF, 1B 1 2 LAD CIN 2014 2014  
8286 8286 Zach Duke 31 dukeza01 2014 MIL NL 1.926587245 1.205 P 7 1 MIL CIN 2014 2014 CHW
8301 8301 Jonathan Broxton 30 broxtjo01 2014 MIL NL 0.424177589 0.125 P 1 2 MIL CIN 2014 2015 STL

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);