15 rows where SH = 19

View and edit SQL

Suggested facets: yearID, teamID, lgID, W, L, G, GS, CG, SHO, H, ER, HR, BB, IBB, WP, HBP, BK, GF, R, SF, GIDP

stint

  • 1 15

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
20492 koosmje01 1973 1 NYN NL 14 15 35 35 12 3 0 789 234 83 18 76 156 0.242 2.84 6 3 4 0 1071 0 93 19 6 25
20935 perryga01 1974 1 CLE AL 21 13 37 37 28 4 0 967 230 90 25 99 216 0.204 2.51 7 2 6 0 1262 0 98 19 12 27
21280 mortoca01 1975 1 ATL NL 17 16 39 39 11 2 0 833 302 108 19 82 78 0.278 3.5 3 1 3 1 1199 0 122 19 8 18
23282 reuscri01 1980 1 CHN NL 11 13 38 38 6 0 0 771 281 97 13 76 140 0.28600000000000003 3.4 10 3 4 1 1094 0 111 19 14 26
23295 rogerst01 1980 1 MON NL 16 11 37 37 14 4 0 843 247 93 16 85 147 0.23800000000000002 2.98 7 7 3 0 1151 0 101 19 7 16
24135 valenfe01 1982 1 LAN NL 19 13 37 37 18 4 0 855 247 91 13 83 199 0.23600000000000002 2.87 12 4 2 0 1156 0 105 19 6 21
26594 mahleri01 1988 1 ATL NL 9 16 39 34 5 0 0 747 279 102 17 42 131 0.282 3.69 6 5 8 8 1063 2 125 19 5 16
27005 hershor01 1989 1 LAN NL 15 15 35 33 8 4 0 770 226 66 9 77 178 0.24 2.31 14 8 3 4 1047 0 75 19 6 29
28092 leibrch01 1991 1 ATL NL 15 13 36 36 1 1 0 689 212 89 18 56 128 0.245 3.49 3 5 4 3 949 0 105 19 6 6
28348 benesan01 1992 1 SDN NL 13 14 34 34 2 2 0 694 230 86 14 61 169 0.264 3.35 6 1 5 1 961 0 90 19 6 12
29998 fasseje01 1995 1 MON NL 13 14 30 30 1 0 0 567 207 91 15 74 164 0.28300000000000003 4.33 3 7 2 1 833 0 102 19 7 13
33410 rueteki01 2000 1 SFN NL 11 9 32 31 0 0 0 552 205 81 23 62 71 0.29 3.96 5 1 2 0 799 0 92 19 9 22
36464 glavito02 2005 1 NYN NL 13 13 33 33 2 1 0 634 227 83 12 61 105 0.27899999999999997 3.53 5 1 3 0 901 0 88 19 3 21
36605 maddugr01 2005 1 CHN NL 13 15 35 35 3 0 0 675 239 106 29 36 136 0.275 4.24 4 8 7 0 936 0 112 19 6 21
41613 nolasri01 2012 1 MIA NL 12 13 31 31 3 2 0 573 214 95 18 47 125 0.285 4.48 9 8 8 1 832 0 100 19 6 21

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