21 rows where SH = 18

View and edit SQL

Suggested facets: playerID, yearID, teamID, lgID, W, G, GS, CG, SHO, H, ER, BB, SO, BAOpp, ERA, WP, HBP, BK, GF, R, SF

SH

Link rowid ▼ playerID yearID stint teamID lgID W L G GS CG SHO SV IPouts H ER HR BB SO BAOpp ERA IBB WP HBP BK BFP GF R SH SF GIDP
19879 roberda05 1971 1 SDN NL 14 17 37 34 14 2 0 809 238 63 9 61 135 0.24 2.1 9 4 5 0 1086 3 79 18 12  
19915 suttodo01 1971 1 LAN NL 17 12 38 37 12 4 1 796 231 75 10 55 194 0.23800000000000002 2.54 5 5 5 0 1059 1 85 18 9  
19944 woodwi01 1971 1 CHA AL 22 13 44 42 22 7 1 1002 272 71 21 62 210 0.222 1.91 2 6 7 0 1316 2 95 18 5  
20011 cuellmi01 1972 1 BAL AL 18 12 35 35 17 4 0 745 197 71 21 71 132 0.22 2.57 4 3 0 0 989 0 78 18 4  
20720 bryanro01 1974 1 SFN NL 3 15 41 23 0 0 0 380 142 79 11 68 75 0.28600000000000003 5.61 4 2 4 0 593 5 92 18 6 12
21152 freisda01 1975 1 SDN NL 5 14 36 27 4 1 0 543 206 86 11 82 77 0.289 4.28 9 8 7 0 825 2 102 18 5 17
21322 reussje01 1975 1 PIT NL 18 11 32 32 15 6 0 712 224 67 10 78 131 0.253 2.54 8 4 0 1 984 0 73 18 3 29
21331 rogerst01 1975 1 MON NL 11 12 35 35 12 3 0 755 248 92 13 88 137 0.26 3.29 8 13 4 1 1068 0 104 18 4 27
21458 burrira01 1976 1 CHN NL 15 13 37 36 10 4 0 747 251 86 22 70 112 0.263 3.11 5 7 5 1 1053 0 102 18 5 16
22082 rogerst01 1977 1 MON NL 17 16 40 40 17 4 0 905 272 104 16 81 206 0.243 3.1 3 14 5 1 1235 0 122 18 9 23
22305 gurala01 1978 1 KCA AL 16 4 35 26 8 2 0 665 183 67 13 60 81 0.22899999999999998 2.72 3 1 4 1 890 1 73 18 9 16
24466 reussje01 1983 1 LAN NL 12 11 32 31 7 0 0 670 233 73 12 50 143 0.271 2.94 5 3 2 2 935 0 94 18 6 23
26315 valenfe01 1987 1 LAN NL 14 14 34 34 12 1 0 753 254 111 25 124 190 0.262 3.98 4 14 4 1 1116 0 120 18 2 21
27025 hurstbr01 1989 1 SDN NL 15 11 33 33 10 2 0 734 214 73 16 66 179 0.237 2.69 7 8 0 0 990 0 84 18 3 13
27075 maddugr01 1989 1 CHN NL 19 12 35 35 7 1 0 715 222 78 13 82 135 0.249 2.95 13 5 6 3 1002 0 90 18 6 17
27579 maddugr01 1990 1 CHN NL 15 15 35 35 8 2 0 711 242 91 11 71 144 0.265 3.46 10 3 4 3 1011 0 116 18 5 27
31015 watsoal01 1996 1 SFN NL 8 12 29 29 2 0 0 557 189 95 28 69 128 0.273 4.61 2 9 5 2 793 0 105 18 9 20
31161 cookest01 1997 1 PIT NL 9 15 32 32 0 0 0 502 184 80 15 77 109 0.285 4.3 11 8 9 1 756 0 95 18 5 16
32320 bohanbr01 1999 1 COL NL 12 12 33 33 3 1 0 592 236 136 30 92 120 0.305 6.2 1 6 14 0 903 0 146 18 3 20
39188 dukeza01 2009 1 PIT NL 11 16 32 32 3 1 0 639 231 96 23 49 106 0.285 4.06 0 2 3 1 891 0 101 18 10 20
41482 kershcl01 2012 1 LAN NL 14 9 33 33 2 2 0 683 170 64 16 63 229 0.21 2.53 5 6 5 2 901 0 70 18 4 17

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Pitching" (
"playerID" TEXT,
  "yearID" INTEGER,
  "stint" INTEGER,
  "teamID" TEXT,
  "lgID" REAL,
  "W" INTEGER,
  "L" INTEGER,
  "G" INTEGER,
  "GS" INTEGER,
  "CG" INTEGER,
  "SHO" INTEGER,
  "SV" INTEGER,
  "IPouts" INTEGER,
  "H" INTEGER,
  "ER" INTEGER,
  "HR" INTEGER,
  "BB" INTEGER,
  "SO" INTEGER,
  "BAOpp" REAL,
  "ERA" REAL,
  "IBB" INTEGER,
  "WP" INTEGER,
  "HBP" INTEGER,
  "BK" INTEGER,
  "BFP" INTEGER,
  "GF" INTEGER,
  "R" INTEGER,
  "SH" INTEGER,
  "SF" INTEGER,
  "GIDP" INTEGER
);