6 rows where SH = 21

View and edit SQL

Suggested facets: lgID, W, L, G, CG, SHO, SV, H, HR, BB, IBB, BK, GF, 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
20314 woodwi01 1972 1 CHA AL 24 17 49 49 20 8 0 1130 325 105 28 74 193 0.235 2.51 5 11 7 0 1490 0 119 21 4  
20655 twitcwa01 1973 1 PHI NL 13 9 34 28 10 5 0 670 172 62 16 99 169 0.21899999999999997 2.5 9 13 10 0 921 0 71 21 4 18
22897 rogerst01 1979 1 MON NL 13 12 37 37 13 5 0 746 232 83 14 78 143 0.251 3.0 9 10 4 0 1032 0 97 21 6 19
24082 scottmi03 1982 1 NYN NL 7 13 37 22 1 0 3 441 185 84 13 60 63 0.321 5.14 3 1 2 2 670 10 100 21 11 11
27456 glavito02 1990 1 ATL NL 10 12 33 33 1 0 0 643 232 102 18 78 129 0.281 4.28 10 8 1 1 929 0 111 21 2 22
37154 haranaa01 2006 1 CIN NL 16 11 36 35 6 2 0 703 242 98 28 56 216 0.26899999999999996 3.76 8 6 8 1 993 0 109 21 8 15

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