6 rows where SH = 20

View and edit SQL

Suggested facets: yearID, teamID, lgID, W, GS, CG, SV, H, HR, BB, SO, IBB, WP, HBP, BK, GF, SF, GIDP

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
20952 reussje01 1974 1 PIT NL 16 11 35 35 14 1 0 780 259 101 20 101 105 0.261 3.5 16 7 1 1 1125 0 115 20 9 29
21116 cuellmi01 1975 1 BAL AL 14 12 36 36 17 5 0 768 229 104 17 84 105 0.249 3.66 5 7 1 1 1034 0 112 20 10 28
21262 messean01 1975 1 LAN NL 19 14 42 40 19 7 1 965 244 82 22 96 213 0.213 2.29 2 8 5 0 1276 2 92 20 7 24
21321 reuscri01 1975 1 CHN NL 11 17 38 37 6 0 1 702 244 97 17 67 155 0.268 3.73 8 4 7 1 1007 1 116 20 4 28
24224 carltst01 1983 1 PHI NL 15 16 37 37 8 3 0 851 277 98 20 84 275 0.258 3.11 10 13 3 9 1183 0 117 20 4 18
28388 candito01 1992 1 LAN NL 11 15 32 30 6 2 0 611 177 68 13 63 152 0.237 3.0 5 9 3 2 839 1 78 20 6 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
);