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

View and edit SQL

Suggested facets: league, broken_eggs, mehs

Link rowid name year team league goose_eggs broken_eggs mehs league_average_gpct ppf replacement_gpct gwar key_retro
1 Dolf Luque 1921 CIN NL 3 1 0 0.752062 94 0.717062 0.068511 luqud101
2 Mike Kircher 1921 SLN NL 0 1 0 0.749262 96 0.7142619 -0.37141620000000003 kircm101
3 Slim Sallee 1921 NY1 NL 13 6 2 0.746462 98 0.711462 -0.269244 salls101
4 Lou North 1921 SLN NL 10 4 0 0.749262 96 0.7142619 0.00017309999999999998 nortl101
5 Dana Fillingim 1921 BSN NL 4 1 1 0.749262 96 0.7142619 0.222919 filld101
6 Speed Martin 1921 CHN NL 5 2 1 0.742262 101 0.707262 0.0255665 marts102
7 Lynn Brenton 1921 CIN NL 2 1 0 0.752062 94 0.717062 -0.0786167 brenl101
8 Pete Alexander 1921 CHN NL 1 0 0 0.742262 101 0.707262 0.1522238 alexg102
9 Fritz Coumbe 1921 CIN NL 1 1 0 0.752062 94 0.717062 -0.22574450000000001 coumf101
10 Red Causey 1921 NY1 NL 0 1 0 0.746462 98 0.711462 -0.3699602 causr101
11 Mule Watson 1921 BSN NL 0 0 1 0.749262 96 0.7142619   watsm103
12 Red Shea 1921 NY1 NL 5 0 1 0.746462 98 0.711462 0.7501989 shear102
13 Tink Riviere 1921 SLN NL 0 1 0 0.749262 96 0.7142619 -0.37141620000000003 rivit101
14 George Mohart 1921 BRO NL 0 0 0 0.738062 104 0.703062   mohag101
15 Stan Baumgartner 1921 PHI NL 2 0 1 0.728262 111 0.6932619999999999 0.3190075 baums101
16 Ferdie Schupp 1921 BRO NL 4 1 1 0.738062 104 0.703062 0.2520388 schuf102
17 Jack Scott 1921 BSN NL 7 1 0 0.749262 96 0.7142619 0.6686703 scotj101
18 Al Mamaux 1921 BRO NL 13 2 1 0.738062 104 0.703062 1.276116 mamaa101
19 Rube Marquard 1921 CIN NL 1 0 0 0.752062 94 0.717062 0.14712779999999998 marqr102
20 Rip Wheeler 1921 PIT NL 0 0 0 0.742262 101 0.707262   wheer101
21 Lyle Bigbee 1921 PIT NL 0 0 0 0.742262 101 0.707262   bigbl101
22 Vic Keen 1921 CHN NL 0 0 0 0.742262 101 0.707262   keenv101
23 Garland Braxton 1921 BSN NL 0 0 1 0.749262 96 0.7142619   braxg101
24 Ferdie Schupp 1921 SLN NL 1 0 0 0.749262 96 0.7142619 0.1485838 schuf102
25 Lee Meadows 1921 PHI NL 0 1 0 0.728262 111 0.6932619999999999 -0.3604962 meadl101
26 Roy Walker 1921 SLN NL 1 0 0 0.749262 96 0.7142619 0.1485838 walkr102
27 Phil Morrison 1921 PIT NL 0 0 0 0.742262 101 0.707262   morrp101
28 Eppa Rixey 1921 CIN NL 5 1 2 0.752062 94 0.717062 0.3627665 rixee101
29 Pete Donohue 1921 CIN NL 4 3 0 0.752062 94 0.717062 -0.5301056 donop102
30 Johnny Cooney 1921 BSN NL 0 0 0 0.749262 96 0.7142619   coonj101
31 Huck Betts 1921 PHI NL 9 3 2 0.728262 111 0.6932619999999999 0.3540452 betth101
32 Bob Geary 1921 CIN NL 0 1 0 0.752062 94 0.717062 -0.37287220000000004 gearb101
33 Buddy Napier 1921 CIN NL 0 0 1 0.752062 94 0.717062   napib101
34 Al Pierotti 1921 BSN NL 0 0 0 0.749262 96 0.7142619   piera101
35 Ira Townsend 1921 BSN NL 0 0 0 0.749262 96 0.7142619   towni101
36 Elmer Ponder 1921 PIT NL 3 0 1 0.742262 101 0.707262 0.45667129999999995 ponde101
37 Fred Toney 1921 NY1 NL 6 1 3 0.746462 98 0.711462 0.5302785 tonef101
38 Jimmy Ring 1921 PHI NL 0 0 1 0.728262 111 0.6932619999999999   ringj101
39 Jeff Pfeffer 1921 BRO NL 1 1 0 0.738062 104 0.703062 -0.21118449999999997 pfefj101
40 Virgil Cheeves 1921 CHN NL 7 0 0 0.742262 101 0.707262 1.065566 cheev101
41 Leon Cadore 1921 BRO NL 10 3 1 0.738062 104 0.703062 0.447301 cadol101
42 Walter Zink 1921 NY1 NL 0 0 0 0.746462 98 0.711462   zinkw101
43 Rosy Ryan 1921 NY1 NL 8 4 0 0.746462 98 0.711462 -0.2795225 ryanr101
44 Hal Carlson 1921 PIT NL 6 5 0 0.742262 101 0.707262 -0.9255384 carlh101
45 Elmer Ponder 1921 CHN NL 0 1 0 0.742262 101 0.707262 -0.3677762 ponde101
46 Earl Hamilton 1921 PIT NL 6 1 2 0.742262 101 0.707262 0.5455664000000001 hamie101
47 Hippo Vaughn 1921 CHN NL 0 0 0 0.742262 101 0.707262   vaugh101
48 Babe Adams 1921 PIT NL 12 0 0 0.742262 101 0.707262 1.826685 adamb104
49 Jimmy Zinn 1921 PIT NL 10 3 2 0.742262 101 0.707262 0.4189090999999999 zinnj101
50 Drew Rader 1921 PIT NL 0 0 0 0.742262 101 0.707262   raded102
51 Sherry Smith 1921 BRO NL 14 5 0 0.738062 104 0.703062 0.3337474 smits102
52 Jeff Pfeffer 1921 SLN NL 0 0 0 0.749262 96 0.7142619   pfefj101
53 Duke Sedgwick 1921 PHI NL 0 0 0 0.728262 111 0.6932619999999999   sedgd101
54 George Smith 1921 PHI NL 3 1 0 0.728262 111 0.6932619999999999 0.11801510000000001 smitg104
55 Dutch Ruether 1921 BRO NL 1 0 2 0.738062 104 0.703062 0.15440779999999998 ruetd101
56 Joe Oeschger 1921 BSN NL 3 3 0 0.749262 96 0.7142619 -0.6684973000000001 oescj101
57 Oscar Fuhr 1921 CHN NL 0 0 0 0.742262 101 0.707262   fuhro102
58 Art Nehf 1921 NY1 NL 2 2 0 0.746462 98 0.711462 -0.43984090000000003 nehfa101
59 Johnny Morrison 1921 PIT NL 0 0 0 0.742262 101 0.707262   morrj105
60 Bill Pertica 1921 SLN NL 0 0 0 0.749262 96 0.7142619   pertb101
61 Kaiser Wilhelm 1921 PHI NL 0 0 0 0.728262 111 0.6932619999999999   wilhk101
62 Rube Benton 1921 NY1 NL 6 3 0 0.746462 98 0.711462 -0.2096419 bentr102
63 Buck Freeman 1921 CHN NL 5 0 0 0.742262 101 0.707262 0.7611188 freeb101
64 Johnny Miljus 1921 BRO NL 4 1 1 0.738062 104 0.703062 0.2520388 miljj101
65 Lefty Tyler 1921 CHN NL 3 0 0 0.742262 101 0.707262 0.45667129999999995 tylel101
66 Bill Sherdel 1921 SLN NL 6 2 0 0.749262 96 0.7142619 0.1486703 sherb101
67 Pol Perritt 1921 NY1 NL 0 0 0 0.746462 98 0.711462   perrp101
68 Jesse Haines 1921 SLN NL 3 0 0 0.749262 96 0.7142619 0.4457514 hainj101
69 Hod Eller 1921 CIN NL 1 1 0 0.752062 94 0.717062 -0.22574450000000001 elleh101
70 Jimmie Keenan 1921 PHI NL 1 0 1 0.728262 111 0.6932619999999999 0.15950379999999997 keenj103
71 Cliff Markle 1921 CIN NL 3 4 0 0.752062 94 0.717062 -1.050106 markc101
72 Bill Hubbell 1921 PHI NL 1 0 0 0.728262 111 0.6932619999999999 0.15950379999999997 hubbb101
73 Percy Jones 1921 CHN NL 4 6 0 0.742262 101 0.707262 -1.5977620000000001 jonep101
74 Jesse Barnes 1921 NY1 NL 6 1 2 0.746462 98 0.711462 0.5302785 barnj102
75 Clarence Mitchell 1921 BRO NL 2 0 1 0.738062 104 0.703062 0.3088155 mitcc102
76 Bill Bailey 1921 SLN NL 0 0 1 0.749262 96 0.7142619   bailb101
77 Jesse Winters 1921 PHI NL 0 0 0 0.728262 111 0.6932619999999999   wintj101
78 Sweetbreads Bailey 1921 CHN NL 0 0 1 0.742262 101 0.707262   bails101
79 Eddie Eayrs 1921 BSN NL 0 0 0 0.749262 96 0.7142619   eayre101
80 Marv Goodwin 1921 SLN NL 0 0 0 0.749262 96 0.7142619   goodm102
81 Clint Rogge 1921 CIN NL 1 1 0 0.752062 94 0.717062 -0.22574450000000001 roggc101
82 Bill Doak 1921 SLN NL 0 0 0 0.749262 96 0.7142619   doakb101
83 Lefty York 1921 CHN NL 5 1 3 0.742262 101 0.707262 0.3933426 yorkl101
84 Chief Yellow Horse 1921 PIT NL 8 3 0 0.742262 101 0.707262 0.1144616 yellc101
85 Hugh McQuillan 1921 BSN NL 8 1 1 0.749262 96 0.7142619 0.8172541 mcquh101
86 George Stueland 1921 CHN NL 0 0 0 0.742262 101 0.707262   stueg101
87 Bill Hughes 1921 PIT NL 0 0 0 0.742262 101 0.707262   hughb102
88 Lefty Weinert 1921 PHI NL 0 0 0 0.728262 111 0.6932619999999999   weinl101
89 Phil Douglas 1921 NY1 NL 6 4 0 0.746462 98 0.711462 -0.5796021 dougp101
90 Cy Morgan 1921 BSN NL 4 0 0 0.749262 96 0.7142619 0.5943351 morgc101
91 Whitey Glazner 1921 PIT NL 1 1 2 0.742262 101 0.707262 -0.2155525 glazw101
92 Tony Kaufmann 1921 CHN NL 3 0 0 0.742262 101 0.707262 0.45667129999999995 kauft101
93 Sweetbreads Bailey 1921 BRO NL 0 0 0 0.738062 104 0.703062   bails101
94 Burleigh Grimes 1921 BRO NL 0 0 0 0.738062 104 0.703062   grimb101
95 Charlie Eckert 1922 PHA AL 0 2 1 0.7100418000000001 105 0.6750417 -0.7020434 eckec101
96 Dixie Leverett 1922 CHA AL 4 0 0 0.7170418000000001 100 0.6820418 0.6613531 leved101
97 Ferdie Schupp 1922 CHA AL 5 0 3 0.7170418000000001 100 0.6820418 0.8266914000000001 schuf102
98 Guy Morton 1922 CLE AL 4 1 1 0.7170418000000001 100 0.6820418 0.3066914 mortg101
99 Urban Shocker 1922 SLA AL 5 2 3 0.7128418000000001 103 0.6778418 0.132656 shocu101
100 Chief Youngblood 1922 WS1 AL 0 0 0 0.7226418000000001 96 0.6876416999999999   younc101

Next page

Advanced export

JSON shape: default, array

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 62.206ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub