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

14 rows where stint_ID = 4

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: age, team_ID, lg_ID, def_pos, quasi_ws, franch_id, prev_franch, 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
3033 3033 Oliver Drake 31 drakeol01 2018 TOR AL 0.02687733 -0.05 P 0 4 TOR ANA 2018 2018 MIN
5738 5738 Oswaldo Arcia 25 arciaos01 2016 SDP NL 0.458618872 -0.565 LF, RF 0 4 SDP FLA 2016 2016  
9168 9168 John McDonald 38 mcdonjo03 2013 BOS AL 0.082165906 -0.04 SS, 3B, 2B, LF, P 0 4 BOS PHI 2013 2013 ANA
22435 22435 Jose Bautista 23 bautijo02 2004 PIT NL 0.432535553 -0.412546584 3B, RF, LF, CF 0 4 PIT KCR 2004 2008 TOR
23313 23313 Dan Miceli 32 micelda01 2003 HOU NL 0.755829386 0.51 P 3 4 HOU NYY 2003 2004 COL
28116 28116 Dave Martinez 35 martida01 2000 TOR AL 1.897411466 0.805 RF, 1B, LF, CF 5 4 TOR TEX 2000 2000 ATL
52573 52573 Dave Kingman 28 kingmda01 1977 NYY AL 0.250119789 0.335 LF, RF, 1B, 3B 1 4 NYY ANA 1977 1977 CHC
56804 56804 Mike Kilkenny 27 kilkemi01 1972 CLE AL 1.727659574 0.098653846 P 3 4 CLE SDP 1972 1973  
57567 57567 Frank Fernandez 28 fernafr01 1971 CHC NL 0.595609065 0.95 C, LF, RF 4 4 CHC TEX 1971 1972  
65977 65977 Wes Covington 29 covinwe01 1961 PHI NL 1.943244233 -0.350129032 RF, LF 1 4 PHI OAK 1961 1965 CHC
69325 69325 Ted Gray 30 grayte01 1955 BAL AL 0.463754201 -0.571153846 P 0 4 BAL NYY 1955 1955  
71978 71978 Paul Lehner 30 lehnepa01 1951 CLE AL 0.149347066 -0.08883871 OF 0 4 CLE BAL 1951 1951 BOS
78615 78615 Willis Hudlin 34 hudliwi01 1940 SLB AL 0.336407767 -0.27 P 0 4 BAL SFG 1940 1944  
97472 97472 Frank Huelsman 30 huelsfr01 1904 SLB AL 0.847599165 -0.171346154 OF 1 4 BAL DET 1904 1904 MIN

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