home / fivethirtyeight

Goose: goose_rawdata.csv

This table contains data behind the stories: The Save Ruined Relief Pitching. The Goose Egg Can Fix It Kenley Jansen Is The Model Of A Modern Reliever

Header Definition
name Pitcher name
year Start year of season
team Retrosheet team code
league NL or AL
goose_eggs Goose eggs
broken_eggs Broken eggs
mehs Mehs
league_average_gpct League-average goose percentage
ppf Pitcher park factor
replacement_gpct Replacement-level goose pecentage
gwar Goose Wins Above Replacement
key_retro Retrosheet unique player identifier

Source: Retrosheet

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

30,962 rows sorted by team

View and edit SQL

Suggested facets: broken_eggs, mehs

Link rowid name year team ▼ league goose_eggs broken_eggs mehs league_average_gpct ppf replacement_gpct gwar key_retro
19774 Pep Harris 1997 ANA AL 13 6 6 0.7244282 102 0.6894281999999999 -0.051550599999999995 harrp001
19775 Anthony Chavez 1997 ANA AL 0 0 1 0.7244282 102 0.6894281999999999   chava001
19799 Jason Dickson 1997 ANA AL 0 0 0 0.7244282 102 0.6894281999999999   dickj001
19838 Rich DeLucia 1997 ANA AL 19 5 5 0.7244282 102 0.6894281999999999 1.275936 delur001
19842 Shad Williams 1997 ANA AL 0 0 0 0.7244282 102 0.6894281999999999   wills001
19866 Allen Watson 1997 ANA AL 0 0 0 0.7244282 102 0.6894281999999999   watsa001
19867 Mike Bovee 1997 ANA AL 0 0 0 0.7244282 102 0.6894281999999999   bovem001
19895 Dennis Springer 1997 ANA AL 2 1 1 0.7244282 102 0.6894281999999999 -0.035508 sprid001
19914 Matt Perisho 1997 ANA AL 0 0 0 0.7244282 102 0.6894281999999999   perim001
19938 Mike James 1997 ANA AL 29 9 6 0.7244282 102 0.6894281999999999 1.456899 jamem001
19946 Kevin Gross 1997 ANA AL 1 1 1 0.7244282 102 0.6894281999999999 -0.1970053 grosk001
19957 Greg Cadaret 1997 ANA AL 1 0 2 0.7244282 102 0.6894281999999999 0.16149729999999998 cadag001
19970 Darrell May 1997 ANA AL 2 2 4 0.7244282 102 0.6894281999999999 -0.3940107 may-d002
19971 Shigetoshi Hasegawa 1997 ANA AL 11 8 2 0.7244282 102 0.6894281999999999 -1.091551 hases001
19984 Troy Percival 1997 ANA AL 26 4 0 0.7244282 102 0.6894281999999999 2.76492 perct001
20008 Mike Holtz 1997 ANA AL 13 2 17 0.7244282 102 0.6894281999999999 1.38246 holtm001
20012 Chuck McElroy 1997 ANA AL 4 2 2 0.7244282 102 0.6894281999999999 -0.071016 mcelc001
20255 Greg Cadaret 1998 ANA AL 3 5 7 0.7276075 102 0.6926074999999999 -1.3212469999999998 cadag001
20266 Steve Sparks 1998 ANA AL 0 0 0 0.7276075 102 0.6926074999999999   spars001
20288 Trevor Wilson 1998 ANA AL 1 0 6 0.7276075 102 0.6926074999999999 0.15984410000000002 wilst002
20296 Jarrod Washburn 1998 ANA AL 0 1 2 0.7276075 102 0.6926074999999999 -0.36015590000000003 washj001
20311 Troy Percival 1998 ANA AL 38 8 6 0.7276075 102 0.6926074999999999 3.192828 perct001
20334 Pep Harris 1998 ANA AL 13 7 1 0.7276075 102 0.6926074999999999 -0.4431185 harrp001
20336 Allen Watson 1998 ANA AL 0 0 1 0.7276075 102 0.6926074999999999   watsa001
20337 Jeff Juden 1998 ANA AL 0 0 0 0.7276075 102 0.6926074999999999   judej001
20341 Jason Dickson 1998 ANA AL 4 0 1 0.7276075 102 0.6926074999999999 0.6393763000000001 dickj001
20376 Omar Olivares 1998 ANA AL 0 1 2 0.7276075 102 0.6926074999999999 -0.36015590000000003 olivo001
20415 Mike Fetters 1998 ANA AL 2 2 1 0.7276075 102 0.6926074999999999 -0.40062359999999997 fettm001
20434 Rich Robertson 1998 ANA AL 0 0 0 0.7276075 102 0.6926074999999999   rober001
20454 Mike Holtz 1998 ANA AL 6 4 8 0.7276075 102 0.6926074999999999 -0.481559 holtm001
20459 Mike James 1998 ANA AL 1 0 2 0.7276075 102 0.6926074999999999 0.15984410000000002 jamem001
20465 Rich DeLucia 1998 ANA AL 23 7 8 0.7276075 102 0.6926074999999999 1.155322 delur001
20466 Shigetoshi Hasegawa 1998 ANA AL 21 5 9 0.7276075 102 0.6926074999999999 1.5559459999999998 hases001
20744 Troy Percival 1999 ANA AL 35 6 4 0.7125683 100 0.6775683000000001 3.7542449999999996 perct001
20765 Mark Petkovsek 1999 ANA AL 23 8 12 0.7125683 100 0.6775683000000001 1.0376 petkm001
20770 Shigetoshi Hasegawa 1999 ANA AL 9 6 5 0.7125683 100 0.6775683000000001 -0.6050321999999999 hases001
20863 Mike Holtz 1999 ANA AL 2 3 5 0.7125683 100 0.6775683000000001 -0.7216774 holtm001
20903 Lou Pote 1999 ANA AL 5 3 2 0.7125683 100 0.6775683000000001 -0.2186839 potel001
20906 Juan Alvarez 1999 ANA AL 1 1 2 0.7125683 100 0.6775683000000001 -0.184671 alvaj002
20914 Mike Fyhrie 1999 ANA AL 0 0 0 0.7125683 100 0.6775683000000001   fyhrm001
20918 Ken Hill 1999 ANA AL 0 1 0 0.7125683 100 0.6775683000000001 -0.3523355 hillk001
20928 Scott Schoeneweis 1999 ANA AL 8 3 3 0.7125683 100 0.6775683000000001 0.2843097 schos001
20943 Jarrod Washburn 1999 ANA AL 0 0 0 0.7125683 100 0.6775683000000001   washj001
20948 Steve Mintz 1999 ANA AL 0 0 0 0.7125683 100 0.6775683000000001   mints001
20961 Mike Magnante 1999 ANA AL 3 1 8 0.7125683 100 0.6775683000000001 0.150658 magnm001
20963 Steve Sparks 1999 ANA AL 0 0 0 0.7125683 100 0.6775683000000001   spars001
20968 Al Levine 1999 ANA AL 1 2 1 0.7125683 100 0.6775683000000001 -0.5370064 levia001
21233 Shigetoshi Hasegawa 2000 ANA AL 40 12 7 0.7107810999999999 103 0.6757811 2.52688 hases001
21249 Al Levine 2000 ANA AL 11 3 3 0.7107810999999999 103 0.6757811 0.8003137 levia001
21277 Ben Weber 2000 ANA AL 0 0 3 0.7107810999999999 103 0.6757811   webeb001
21301 Kent Mercker 2000 ANA AL 0 1 0 0.7107810999999999 103 0.6757811 -0.3514062 merck001
21302 Mark Petkovsek 2000 ANA AL 25 6 5 0.7107810999999999 103 0.6757811 2.106409 petkm001
21324 Troy Percival 2000 ANA AL 27 11 3 0.7107810999999999 103 0.6757811 0.6865654999999999 perct001
21344 Scott Karl 2000 ANA AL 0 0 0 0.7107810999999999 103 0.6757811   karls001
21380 Eric Weaver 2000 ANA AL 1 1 1 0.7107810999999999 103 0.6757811 -0.18281229999999998 weave001
21383 Matt Wise 2000 ANA AL 0 0 0 0.7107810999999999 103 0.6757811   wisem001
21398 Mike Holtz 2000 ANA AL 3 4 7 0.7107810999999999 103 0.6757811 -0.8998431 holtm001
21419 Derrick Turnbow 2000 ANA AL 0 0 0 0.7107810999999999 103 0.6757811   turnd001
21432 Mike Fyhrie 2000 ANA AL 2 0 1 0.7107810999999999 103 0.6757811 0.3371877 fyhrm001
21441 Brett Hinchliffe 2000 ANA AL 1 0 0 0.7107810999999999 103 0.6757811 0.1685938 hincb001
21457 Lou Pote 2000 ANA AL 1 2 1 0.7107810999999999 103 0.6757811 -0.5342184 potel001
21470 Bryan Ward 2000 ANA AL 0 0 0 0.7107810999999999 103 0.6757811   wardb001
21484 Juan Alvarez 2000 ANA AL 0 0 0 0.7107810999999999 103 0.6757811   alvaj002
21783 Lou Pote 2001 ANA AL 2 1 2 0.7276640999999999 101 0.6926640000000001 -0.0405558 potel001
21787 Ben Weber 2001 ANA AL 7 3 3 0.7276640999999999 101 0.6926640000000001 0.038147 webeb001
21862 Mark Lukasiewicz 2001 ANA AL 0 2 0 0.7276640999999999 101 0.6926640000000001 -0.7203706 lukam001
21870 Brian Cooper 2001 ANA AL 0 0 0 0.7276640999999999 101 0.6926640000000001   coopb001
21876 Pat Rapp 2001 ANA AL 0 0 0 0.7276640999999999 101 0.6926640000000001   rappp001
21889 Troy Percival 2001 ANA AL 38 3 4 0.7276640999999999 101 0.6926640000000001 4.9924029999999995 perct001
21909 Mike Holtz 2001 ANA AL 6 4 4 0.7276640999999999 101 0.6926640000000001 -0.4818528 holtm001
21924 Bart Miadich 2001 ANA AL 0 0 0 0.7276640999999999 101 0.6926640000000001   miadb001
21925 Toby Borland 2001 ANA AL 0 0 0 0.7276640999999999 101 0.6926640000000001   borlt001
21954 Al Levine 2001 ANA AL 24 12 12 0.7276640999999999 101 0.6926640000000001 -0.4866702 levia001
21976 Shigetoshi Hasegawa 2001 ANA AL 19 7 4 0.7276640999999999 101 0.6926640000000001 0.5151821 hases001
21980 Matt Wise 2001 ANA AL 0 0 0 0.7276640999999999 101 0.6926640000000001   wisem001
21992 Scot Shields 2001 ANA AL 0 0 0 0.7276640999999999 101 0.6926640000000001   shies002
22280 Dennis Cook 2002 ANA AL 2 2 3 0.7328956999999999 99 0.6978956000000001 -0.4116229 cookd001
22283 Mark Lukasiewicz 2002 ANA AL 1 1 3 0.7328956999999999 99 0.6978956000000001 -0.20581149999999998 lukam001
22291 Al Levine 2002 ANA AL 10 8 5 0.7328956999999999 99 0.6978956000000001 -1.332303 levia001
22317 Lou Pote 2002 ANA AL 3 3 0 0.7328956999999999 99 0.6978956000000001 -0.6174344 potel001
22345 Donne Wall 2002 ANA AL 3 0 0 0.7328956999999999 99 0.6978956000000001 0.47128279999999995 walld002
22353 Matt Wise 2002 ANA AL 0 0 0 0.7328956999999999 99 0.6978956000000001   wisem001
22363 Francisco Rodriguez 2002 ANA AL 1 0 0 0.7328956999999999 99 0.6978956000000001 0.1570943 rodrf003
22378 Ben Weber 2002 ANA AL 28 9 4 0.7328956999999999 99 0.6978956000000001 1.132488 webeb001
22406 Brendan Donnelly 2002 ANA AL 16 2 7 0.7328956999999999 99 0.6978956000000001 1.787697 donnb001
22414 Scott Schoeneweis 2002 ANA AL 7 4 5 0.7328956999999999 99 0.6978956000000001 -0.35196320000000003 schos001
22494 Scot Shields 2002 ANA AL 8 4 0 0.7328956999999999 99 0.6978956000000001 -0.1948687 shies002
22501 Troy Percival 2002 ANA AL 33 2 4 0.7328956999999999 99 0.6978956000000001 4.458299 perct001
22790 Scot Shields 2003 ANA AL 1 0 0 0.7391459 97 0.7041459 0.1538441 shies002
22799 Brendan Donnelly 2003 ANA AL 37 6 1 0.7391459 97 0.7041459 3.4952970000000003 donnb001
22811 Mickey Callaway 2003 ANA AL 2 2 0 0.7391459 97 0.7041459 -0.4246235 callm001
22819 Francisco Rodriguez 2003 ANA AL 17 4 2 0.7391459 97 0.7041459 1.150727 rodrf003
22826 Bart Miadich 2003 ANA AL 0 0 0 0.7391459 97 0.7041459   miadb001
22849 Derrick Turnbow 2003 ANA AL 2 0 0 0.7391459 97 0.7041459 0.30768829999999997 turnd001
22905 Gary Glover 2003 ANA AL 0 0 0 0.7391459 97 0.7041459   glovg001
22908 Troy Percival 2003 ANA AL 21 5 2 0.7391459 97 0.7041459 1.3999469999999998 perct001
22952 Chris Bootcheck 2003 ANA AL 0 0 0 0.7391459 97 0.7041459   bootc001
22971 Scott Schoeneweis 2003 ANA AL 2 0 3 0.7391459 97 0.7041459 0.30768829999999997 schos001
22985 Ben Weber 2003 ANA AL 8 4 2 0.7391459 97 0.7041459 -0.2338703 webeb001
23004 Kevin Gregg 2003 ANA AL 0 0 0 0.7391459 97 0.7041459   gregk001

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "goose/goose_rawdata" (
"name" TEXT,
  "year" INTEGER,
  "team" TEXT,
  "league" TEXT,
  "goose_eggs" INTEGER,
  "broken_eggs" INTEGER,
  "mehs" INTEGER,
  "league_average_gpct" REAL,
  "ppf" INTEGER,
  "replacement_gpct" REAL,
  "gwar" REAL,
  "key_retro" TEXT
)
Powered by Datasette · Query took 1489.6ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub