Goose: goose_rawdata.csv

Table actions

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 · About: simonw/fivethirtyeight-datasette

30,962 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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