5,292 rows where SH = 1

View and edit SQL

Suggested facets: stint, lgID, W, L, CG, SHO, IBB, WP, HBP, BK, SF, GIDP

SH

  • 1 · 5,292
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
19194 allenll01 1970 1 CAL AL 1 1 8 2 0 0 0 72 23 7 0 11 12 0.261 2.63 2 2 1 0 102 0 7 1 1  
19196 arrigge01 1970 1 CHA AL 0 3 5 3 0 0 0 40 24 19 4 9 12 0.39299999999999996 12.83 1 1 0 0 72 1 20 1 1  
19199 baldsja01 1970 1 SDN NL 1 0 12 0 0 0 0 40 24 15 2 4 12 0.375 10.13 1 0 0 0 70 8 15 1 1  
19201 barbest01 1970 1 CHN NL 0 1 5 0 0 0 0 17 10 6 0 6 3 0.41700000000000004 9.53 3 1 0 0 31 4 6 1 0  
19202 barbest01 1970 2 ATL NL 0 1 5 2 0 0 0 44 17 8 3 5 11 0.28800000000000003 4.91 0 2 1 0 66 2 10 1 0  
19204 beenefr01 1970 1 BAL AL 0 0 4 0 0 0 0 18 8 4 1 5 4 0.32 6.0 4 0 0 0 31 1 5 1 0  
19231 burbabi01 1970 1 NYA AL 0 2 4 4 0 0 0 50 23 19 2 9 10 0.324 10.26 0 2 1 0 83 0 19 1 1  
19235 cambrfr01 1970 1 PIT NL 1 2 6 5 0 0 0 100 37 13 2 12 14 0.272 3.51 0 0 1 0 150 0 15 1 0  
19238 cardwdo01 1970 2 ATL NL 2 1 16 2 1 1 0 69 31 23 5 13 16 0.326 9.0 2 1 1 1 111 8 23 1 1  
19239 carloci01 1970 1 WS2 AL 0 0 5 0 0 0 0 18 3 1 0 4 2 0.15 1.5 0 0 0 0 25 3 1 1 0  
19252 colpadi01 1970 1 PIT NL 1 0 8 0 0 0 0 32 9 7 3 8 6 0.237 5.91 2 1 0 0 47 2 7 1 0  
19263 culvege01 1970 1 SLN NL 3 3 11 7 2 0 0 170 64 29 6 24 23 0.284 4.61 4 3 1 0 252 1 31 1 1  
19266 cumbejo01 1970 2 SFN NL 2 0 7 0 0 0 0 33 6 1 0 4 6 0.158 0.82 0 1 0 1 44 2 3 1 1  
19276 downial01 1970 1 OAK AL 3 3 10 6 1 0 0 123 39 18 5 22 26 0.252 3.95 0 0 1 0 180 0 19 1 1  
19278 doylepa01 1970 1 CAL AL 3 1 40 0 0 0 5 126 43 24 7 21 34 0.267 5.14 3 2 1 2 184 18 25 1 0  
19281 drabomo01 1970 2 BAL AL 4 2 21 0 0 0 1 100 30 14 7 15 21 0.233 3.78 3 0 1 0 146 10 17 1 0  
19287 eddydo01 1970 1 CHA AL 0 0 7 0 0 0 0 35 10 3 0 6 9 0.244 2.31 0 0 0 0 48 3 4 1 0  
19290 ellswdi01 1970 2 ML4 AL 0 0 14 0 0 0 1 47 11 3 0 3 9 0.196 1.72 0 1 1 0 61 4 3 1 0  
19291 faulbi01 1970 1 SFN NL 0 0 7 0 0 0 1 29 15 8 1 6 6 0.35700000000000004 7.45 2 0 0 0 49 2 9 1 0  
19300 garbege01 1970 1 PIT NL 0 3 14 0 0 0 0 67 22 13 4 10 7 0.275 5.24 1 0 2 0 94 5 13 1 1  
19319 halldi01 1970 1 BAL AL 10 5 32 0 0 0 3 184 51 21 8 6 30 0.22899999999999998 3.08 2 0 0 0 232 17 25 1 2  
19320 hallto01 1970 1 MIN AL 11 6 52 11 1 0 4 466 94 44 11 66 184 0.17300000000000001 2.55 4 3 2 0 619 13 46 1 6  
19322 hamilst01 1970 2 CHA AL 0 0 3 0 0 0 0 9 4 2 0 1 3 0.33299999999999996 6.0 0 0 0 0 14 0 2 1 0  
19331 hartech01 1970 2 SLN NL 0 0 6 0 0 0 0 40 24 13 1 5 9 0.375 8.78 0 1 0 0 71 1 13 1 1  
19333 haydeha01 1970 1 MIN AL 2 0 4 0 0 0 0 27 7 3 2 4 4 0.226 3.0 0 1 0 0 37 2 3 1 1  
19337 herbero01 1970 2 NYN NL 2 2 12 0 0 0 1 39 14 2 1 2 8 0.275 1.38 1 0 0 0 54 7 3 1 0  
19345 hraboal01 1970 1 SLN NL 2 1 16 1 0 0 0 57 22 10 2 7 12 0.28600000000000003 4.74 1 1 0 0 85 7 10 1 0  
19346 humphbo01 1970 1 WS2 AL 0 0 5 0 0 0 0 20 4 1 1 9 6 0.2 1.35 0 0 0 0 30 2 2 1 0  
19365 kealest01 1970 1 CAL AL 1 0 17 0 0 0 1 65 19 10 2 6 14 0.26 4.15 2 0 0 0 83 1 11 1 3  
19374 kooncca01 1970 1 NYN NL 0 2 13 0 0 0 0 66 25 8 2 14 10 0.301 3.27 5 0 1 0 99 8 9 1 0  
19385 lauzege01 1970 1 ML4 AL 1 2 11 4 1 0 0 105 41 27 7 14 24 0.295 6.94 1 1 1 0 158 1 27 1 3  
19394 lockebo02 1970 1 ML4 AL 0 1 28 0 0 0 3 95 37 12 1 10 19 0.306 3.41 1 1 5 0 138 16 18 1 1  
19401 magnuji01 1970 1 CHA AL 1 5 13 6 0 0 0 134 45 24 7 16 20 0.263 4.84 1 1 1 0 190 3 28 1 1  
19411 mccoobi01 1970 1 SLN NL 0 3 18 0 0 0 1 65 20 15 0 16 12 0.25 6.23 0 3 0 0 99 3 15 1 2  
19419 mclaide01 1970 1 DET AL 3 5 14 14 1 0 0 274 100 47 19 28 52 0.273 4.63 0 0 3 1 402 0 51 1 4  
19423 mcraeno01 1970 1 DET AL 0 0 19 0 0 0 0 94 26 10 1 25 16 0.226 2.87 0 6 1 0 143 4 13 1 1  
19430 millebo04 1970 3 CHN NL 0 0 7 1 0 0 2 27 6 5 3 6 4 0.19399999999999998 5.0 1 0 0 0 39 4 5 1 1  
19431 millsdi01 1970 1 BOS AL 0 0 2 0 0 0 0 11 6 1 0 3 3 0.353 2.45 0 1 1 0 22 1 4 1 0  
19435 monteau01 1970 1 KCA AL 1 1 21 0 0 0 0 82 20 9 2 9 18 0.2 2.96 0 2 1 0 111 12 11 1 0  
19458 nyeri01 1970 1 SLN NL 0 0 6 0 0 0 0 24 13 4 2 6 5 0.371 4.5 1 0 0 0 43 2 5 1 1  
19460 nymanje01 1970 1 SDN NL 0 2 2 2 0 0 0 16 8 9 1 2 2 0.364 15.19 0 0 0 0 26 0 9 1 1  
19464 oriledo01 1970 1 KCA AL 0 0 9 2 0 0 0 70 26 14 5 9 13 0.27699999999999997 5.4 0 3 1 0 106 5 15 1 1  
19465 osinsda01 1970 1 HOU NL 0 1 3 0 0 0 0 11 5 4 0 2 1 0.35700000000000004 9.82 1 0 0 0 18 2 4 1 1  
19474 pascuca02 1970 1 LAN NL 0 0 10 0 0 0 0 42 12 4 2 5 8 0.231 2.57 1 0 1 0 59 3 4 1 0  
19479 penaor01 1970 1 PIT NL 2 1 23 0 0 0 2 113 38 20 6 7 25 0.268 4.78 2 0 1 0 152 7 21 1 1  
19486 philled03 1970 1 BOS AL 0 2 18 0 0 0 0 71 29 14 4 10 23 0.312 5.32 1 2 2 0 107 10 14 1 1  
19494 ramospe01 1970 1 WS2 AL 0 0 4 0 0 0 0 25 10 7 2 4 10 0.294 7.56 0 1 0 0 39 1 7 1 0  
19506 richepe01 1970 1 BAL AL 7 2 50 0 0 0 13 164 36 12 5 24 66 0.19399999999999998 1.98 3 4 1 0 216 25 14 1 4  
19510 roberje01 1970 1 DET AL 0 0 11 0 0 0 0 44 19 6 1 5 11 0.306 3.68 1 1 0 0 69 5 8 1 1  
19513 rodriro01 1970 2 SDN NL 0 0 10 0 0 0 3 49 26 12 1 5 8 0.366 6.61 0 2 0 0 77 4 16 1 0  
19519 rounsge01 1970 1 CHA AL 0 1 8 0 0 0 0 19 10 7 1 2 3 0.35700000000000004 9.95 0 0 0 0 31 1 8 1 0  
19524 santoal01 1970 1 SDN NL 1 8 21 12 0 0 1 227 91 51 11 43 41 0.294 6.07 6 2 3 0 360 5 56 1 3  
19531 sembeca01 1970 1 MON NL 0 0 5 0 0 0 0 20 14 14 2 11 6 0.424 18.9 3 4 1 0 46 4 14 1 0  
19539 sparmjo01 1970 1 MON NL 0 4 9 6 1 0 0 88 34 23 7 25 23 0.29600000000000004 7.06 3 4 2 0 146 2 25 1 3  
19543 stangle01 1970 2 CHA AL 1 0 16 0 0 0 0 67 28 13 5 5 14 0.295 5.24 1 1 0 0 101 4 13 1 0  
19550 suchdi01 1970 1 WS2 AL 1 5 21 5 0 0 0 150 48 42 8 45 41 0.258 7.56 5 3 3 0 239 3 42 1 4  
19566 waslega01 1970 1 MON NL 0 2 6 4 0 0 0 74 23 14 3 15 19 0.247 5.11 4 1 0 0 109 1 14 1 0  
19572 wilcomi01 1970 1 CIN NL 3 1 5 2 1 1 1 67 19 6 2 7 13 0.22899999999999998 2.42 0 0 1 1 92 1 6 1 0  
19574 wilheho01 1970 2 CHN NL 0 1 3 0 0 0 0 11 4 4 1 3 1 0.28600000000000003 9.82 0 0 0 0 18 2 4 1 0  
19580 wilsoea01 1970 2 SDN NL 1 6 15 9 0 0 0 195 82 35 5 19 29 0.309 4.85 2 0 2 0 290 3 36 1 3  
19597 arroyru01 1971 1 SLN NL 0 1 9 0 0 0 0 35 18 7 2 5 5 0.375 5.4 1 1 0 0 55 3 8 1 1  
19602 barbest02 1971 1 MIN AL 1 0 4 2 0 0 0 35 8 8 2 13 4 0.19 6.17 1 1 0 0 56 0 9 1 0  
19605 bellje01 1971 1 ML4 AL 2 1 8 0 0 0 0 44 10 5 0 6 8 0.2 3.07 1 1 0 0 58 5 5 1 1  
19627 brunege01 1971 1 SLN NL 0 1 7 0 0 0 0 28 12 6 3 7 4 0.316 5.79 0 0 0 0 46 1 6 1 0  
19631 burbabi01 1971 1 NYA AL 0 1 2 0 0 0 0 10 6 4 0 5 3 0.4 10.8 2 2 0 0 22 1 6 1 1  
19637 caprabu01 1971 1 NYN NL 0 1 3 0 0 0 0 16 3 5 0 5 6 0.16699999999999998 8.44 1 0 0 0 24 1 6 1 0  
19645 clemola01 1971 1 KCA AL 1 0 10 3 0 0 0 72 26 11 2 12 20 0.263 4.13 0 2 1 0 114 2 16 1 1  
19661 curtijo01 1971 1 BOS AL 2 2 5 3 1 0 0 78 30 9 3 6 19 0.29100000000000004 3.12 1 0 0 0 110 1 9 1 0  
19671 dukesto01 1971 1 BAL AL 1 5 28 0 0 0 4 115 40 15 4 8 30 0.263 3.52 2 1 1 0 165 12 15 1 3  
19673 eddydo01 1971 1 CHA AL 0 2 22 0 0 0 0 68 19 6 3 19 14 0.23199999999999998 2.38 2 0 0 0 103 6 6 1 1  
19675 ellswdi01 1971 1 ML4 AL 0 1 11 0 0 0 0 44 22 8 1 7 10 0.361 4.91 1 0 1 0 72 5 10 1 2  
19678 fisheed02 1971 1 CAL AL 10 8 57 3 0 0 3 357 92 36 11 50 82 0.21100000000000002 2.72 5 4 2 0 492 30 46 1 3  
19687 gardnro01 1971 1 OAK AL 0 0 4 1 0 0 0 23 8 2 1 3 5 0.267 2.35 0 0 0 0 34 1 2 1 0  
19690 garregr01 1971 1 CIN NL 0 1 2 1 0 0 0 26 7 1 0 10 2 0.25 1.04 0 1 0 1 39 0 1 1 0  
19697 giustda01 1971 1 PIT NL 5 6 58 0 0 0 30 258 79 28 5 31 55 0.24100000000000002 2.93 8 3 1 0 365 49 31 1 4  
19704 griffto02 1971 1 HOU NL 0 6 10 6 0 0 0 113 44 20 4 20 29 0.28800000000000003 4.78 1 4 2 0 177 0 22 1 1  
19713 hambrro01 1971 1 NYA AL 3 1 18 0 0 0 2 80 22 13 5 10 14 0.22399999999999998 4.39 2 2 0 0 110 14 13 1 1  
19714 hamilst01 1971 1 SFN NL 2 2 39 0 0 0 4 134 29 15 4 11 38 0.18600000000000003 3.02 6 1 1 0 173 16 15 1 4  
19718 hannaji01 1971 1 DET AL 1 0 7 0 0 0 0 33 7 4 1 7 6 0.18899999999999997 3.27 0 1 1 0 46 3 4 1 0  
19723 harribu03 1971 1 HOU NL 1 1 20 0 0 0 0 92 33 22 3 16 21 0.275 6.46 1 2 0 1 138 7 22 1 1  
19729 hernara01 1971 1 PIT NL 0 1 10 0 0 0 4 37 5 1 0 2 7 0.122 0.73 1 0 0 0 44 7 1 1 0  
19730 higgide01 1971 1 SLN NL 1 0 3 0 0 0 0 21 6 3 0 2 6 0.24 3.86 0 0 0 0 29 1 3 1 1  
19736 houghch01 1971 1 LAN NL 0 0 4 0 0 0 0 13 3 2 1 3 4 0.2 4.15 0 0 0 0 19 3 3 1 0  
19737 houseto01 1971 1 ATL NL 1 0 11 1 0 0 0 62 20 7 2 3 11 0.263 3.05 0 3 1 0 82 2 8 1 1  
19750 jonesga01 1971 1 NYA AL 0 0 12 0 0 0 0 42 19 14 1 7 10 0.317 9.0 1 0 0 0 69 5 14 1 1  
19764 kooncca01 1971 1 BOS AL 0 1 13 1 0 0 0 63 22 13 3 11 9 0.278 5.57 0 0 0 0 91 6 16 1 0  
19767 lachema01 1971 1 OAK AL 0 0 1 0 0 0 0 1 2 2 0 1 0 1.0 54.0 0 0 0 0 4 0 2 1 0  
19768 lambjo01 1971 1 PIT NL 0 0 2 0 0 0 0 13 3 0 0 1 1 0.188 0.0 0 0 0 0 18 0 0 1 0  
19778 lindbpa01 1971 1 OAK AL 1 0 8 0 0 0 0 48 18 7 1 2 4 0.295 3.94 1 0 1 0 65 3 7 1 0  
19788 machech01 1971 1 CLE AL 0 2 14 0 0 0 3 55 16 13 2 15 9 0.24600000000000002 6.38 3 0 0 1 84 7 16 1 3  
19793 matlajo01 1971 1 NYN NL 0 3 7 6 0 0 0 111 31 17 2 15 24 0.228 4.14 0 3 0 0 153 1 18 1 1  
19797 mccormi03 1971 1 KCA AL 0 0 4 1 0 0 0 29 14 10 0 5 2 0.35 9.31 0 0 0 0 46 1 10 1 0  
19815 montgmo01 1971 1 KCA AL 3 0 3 2 0 0 0 64 16 5 0 3 12 0.205 2.11 0 0 0 0 82 1 5 1 0  
19824 neibaga01 1971 1 ATL NL 1 0 6 1 0 0 1 63 14 5 3 9 6 0.187 2.14 1 1 1 0 86 1 5 1 0  
19825 nelsoji01 1971 1 PIT NL 2 2 17 2 0 0 0 104 27 9 0 26 11 0.225 2.34 4 3 5 0 153 2 9 1 1  
19844 pascuca02 1971 1 CLE AL 2 2 9 1 0 0 0 70 17 8 0 11 20 0.205 3.09 0 0 1 0 97 1 9 1 1  
19880 roberri01 1971 1 SFN NL 2 2 23 6 1 0 1 183 66 31 5 31 32 0.267 4.57 3 2 2 0 283 5 40 1 2  
19889 santoal01 1971 1 SDN NL 0 2 18 3 0 0 0 115 43 16 4 11 21 0.285 3.76 1 2 0 1 165 3 19 1 2  
19895 selmadi01 1971 1 PHI NL 0 2 17 0 0 0 1 74 21 9 2 8 15 0.231 3.28 0 2 2 0 102 9 9 1 0  
19907 stephea01 1971 1 CHN NL 1 0 16 0 0 0 1 61 24 10 1 11 11 0.316 4.43 0 1 0 0 90 5 10 1 2  

Next page

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