174 rows where stint = 3

View and edit SQL

Suggested facets: lgID, W, L, GS, SHO, SV, HR, IBB, WP, HBP, BK, GF, SH, SF, GIDP

CG

stint

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
291 taylobi01 1881 3 CL2 NL 0 0 1 0 0 0 0 9 0 0 0 1 2   0.0   0   0 10 1 0      
341 mountfr01 1882 3 WOR NL 2 11 13 13 11 0 0 306 138 45 4 24 24   3.97   14   0 485 0 93      
436 neaglja01 1883 3 PT1 AA 3 12 16 16 12 0 0 342 156 74 9 25 41   5.84   22   0 535 0 123      
469 atkinal01 1884 3 BLU UA 3 5 8 8 8 0 0 208 60 18 4 12 50   2.34   7   0 288 0 34      
473 bakelje01 1884 3 KCU UA 2 3 5 5 3 0 0 99 29 9 0 4 13   2.45   4   0 136 0 16      
493 brownji01 1884 3 SPU UA 1 4 6 6 4 1 0 108 43 15 1 14 20   3.75   4   0 169 0 34      
615 mclaufr01 1884 3 KCU UA 0 0 2 1 0 0 0 30 15 6 0 2 3   5.4   1   0 48 1 12      
622 millecy01 1884 3 PHI NL 0 1 1 1 1 0 0 27 17 10 5 6 1   10.0   4   0 50 0 19      
681 tennefr01 1884 3 WIL UA 0 1 1 1 1 0 0 24 6 1 0 4 10   1.13   0   0 35 0 5      
902 murphjo02 1886 3 SL4 AA 1 0 1 1 1 0 0 21 5 3 0 3 3   3.86   1 0 0 31 0 4      
1094 wiedmst01 1887 3 NY1 NL 0 1 1 1 1 0 0 24 10 1 0 2 4   1.13   1 0 0 37 0 6      
1285 krockgu01 1889 3 WS8 NL 2 4 6 6 6 0 0 144 65 28 1 22 17   5.25   1 1 0 230 0 50      
1383 dailyed01 1890 3 LS2 AA 6 3 12 10 9 1 0 279 83 20 2 30 31   1.94   4 4 0 392 2 35      
1404 esperdu01 1890 3 PHI NL 5 0 5 5 4 0 0 123 40 14 1 16 18   3.07   0 0 0 178 0 22      
1435 hatfigi01 1890 3 NYP PL 1 1 2 0 0 0 0 17 6 2 1 3 2   3.18   2 1 0 27 2 6      
1597 eastoja01 1891 3 CL6 AA 0 2 2 2 2 0 0 45 15 6 2 4 13   3.6   2 2 0 66 0 8      
1803 viaule01 1892 3 BSN NL 1 0 1 1 1 0 0 27 5 0 0 4 1   0.0   0 0 0 36 0 1      
2160 weyhigu01 1895 3 LS3 NL 7 19 28 25 22 1 0 639 285 128 9 66 53   5.41   5 8 0 976 3 205      
2551 hillbi01 1899 3 BRO NL 1 0 2 1 1 0 1 33 11 1 0 6 3   0.82   0 0 0 48 1 3      
2572 mageebi01 1899 3 WAS NL 1 4 8 7 4 0 0 126 54 40 3 28 11   8.57   1 7 0 208 1 45      
2872 cronija01 1902 3 NY1 NL 5 6 13 12 11 0 0 342 105 31 3 18 52   2.45   1 0 0 447 1 49      
3184 willipo01 1903 3 BSN NL 4 5 10 10 9 1 0 249 97 38 3 37 20   4.12   3 9 0 375 0 60      
3576 mcfarch02 1906 3 BRO NL 0 1 1 1 1 0 0 27 10 8 1 5 5   8.0   0 0 0 40 0 8      
3816 wolteha01 1907 3 SLN NL 0 2 3 3 1 0 0 69 27 11 1 18 8   4.3   0 2 0 105 0 13      
3921 mccarto02 1908 3 BSN NL 7 3 14 11 7 2 0 282 77 17 0 28 27   1.63   1 1 0 356 2 24      
4481 curticl01 1911 3 PHI NL 2 1 8 5 3 1 0 135 45 13 0 15 13 0.26 2.6   0 1 0 189 1 19      
4960 cranddo01 1913 3 NY1 NL 2 0 11 1 1 0 1 127 41 12 1 11 14 0.0 2.55   0 0 0 181 8 17      
5523 douglph01 1915 3 CHN NL 1 1 4 4 2 1 0 75 17 6 0 7 18 0.18 2.16   0 1 0 102 0 9      
5597 leclage01 1915 3 BLF FL 1 8 18 9 6 1 1 252 76 23 2 22 30 9.99 2.46   1 0 1 0 9 43      
5815 hamilea01 1916 3 SLA AL 5 7 22 12 3 0 0 274 97 31 2 26 25 0.28 3.05   2 2 1 369 6 44      
6301 smithge02 1918 3 BRO NL 4 1 8 5 4 0 0 150 43 13 0 5 18 0.24 2.34   2 2 0 185 3 14      
6359 chenela01 1919 3 PHI NL 2 5 9 6 5 0 0 172 69 29 2 28 25 0.31 4.55   3 1 0 261 2 34      
6413 jamesbi01 1919 3 CHA AL 3 2 5 5 3 2 0 118 39 11 0 14 11 0.28 2.52   0 2 0 155 0 12      
6473 oeschjo01 1919 3 BSN NL 4 2 7 7 4 1 0 170 63 16 0 21 16 0.3 2.54   1 1 0 238 0 19      
6487 raganpa01 1919 3 CHA AL 0 0 1 0 0 0 0 3 1 0 0 0 0 0.25 0.0   0 0 0 4 1 0      
6756 watsomu01 1920 3 BSN NL 5 4 12 10 4 2 0 215 79 30 0 17 16 0.29 3.77   1 1 0 296 2 33      
6946 sothoal01 1921 3 CLE AL 12 4 22 16 10 2 0 434 146 52 0 58 61 0.27 3.24   5 7 0 621 5 60      
7704 fergual01 1925 3 WS1 AL 5 1 7 6 3 0 0 166 52 20 2 23 24 0.25 3.25   0 2 0 234 1 22      
8169 kaufmto01 1927 3 SLN NL 0 0 1 0 0 0 0 1 4 3 0 1 0 1.0 81.0   0 0 0 5 0 3      
8748 carroow01 1930 3 CIN NL 0 1 3 2 1 0 0 42 17 7 3 3 0 0.3 4.5   1 0 0 59 1 9      
9515 uhlege01 1933 3 NYA AL 6 1 12 6 4 0 0 183 63 35 4 20 26 0.25 5.16   1 3 0 268 4 42      
9605 grimebu01 1934 3 PIT NL 1 2 8 4 0 0 0 82 36 22 0 10 9 0.31 7.24   1 1 0 130 3 24      
10025 dietrbi01 1936 3 CHA AL 4 4 14 11 6 1 0 248 93 43 8 36 39 0.28 4.68   2 1 0 368 1 50      
10085 kowalfa01 1936 3 BSN NL 0 1 1 1 1 0 0 27 18 8 0 2 0 0.41 8.0   0 0 0 47 0 8      
10862 thomabu01 1939 3 DET AL 7 0 27 0 0 0 1 142 45 22 7 20 14 0.25 4.18   2 0 0 202 15 25      
10997 hudliwi01 1940 3 SLA AL 0 1 6 1 0 0 0 34 19 14 0 8 4 0.35 11.12   0 0 0 61 3 16      
11760 newsobo01 1943 3 WS1 AL 3 3 6 6 2 0 0 120 38 17 1 21 11 0.24 3.83   0 2 0 179 0 22      
11792 salvoma01 1943 3 BSN NL 5 6 20 13 5 1 0 281 94 34 6 25 25 0.26 3.27   0 1 0 391 4 45      
12631 behrmha01 1947 3 BRO NL 5 3 38 6 0 0 8 265 94 52 9 44 31 0.27 5.3   3 0 0 392 16 64      
12819 schmifr01 1947 3 CHN NL 0 0 1 1 0 0 0 9 4 3 0 5 0 0.33 9.0   0 0 0 19 0 3      
12922 erickpa01 1948 3 NY1 NL 0 0 2 0 0 0 0 3 0 0 0 2 1 0.0 0.0   0 0 0 5 1 0      
13050 pottene01 1948 3 BSN NL 5 2 18 7 3 0 2 255 77 22 4 8 47 0.24 2.33   1 0 0 332 9 27      
13359 borowha01 1950 3 DET AL 1 1 13 2 1 0 0 98 23 12 3 16 12 0.2 3.31   2 0 0 134 3 15      
13683 hoguebo01 1951 3 NYA AL 1 0 7 0 0 0 0 22 4 0 0 3 2 0.17 0.0   1 0 0 26 3 0      
13790 sanfofr01 1951 3 SLA AL 2 4 9 7 1 0 0 82 37 31 6 23 7 0.3 10.21   0 0 0 143 0 33      
14051 schmijo01 1952 3 CIN NL 1 0 3 0 0 0 0 15 3 0 0 3 3 0.18 0.0   0 0 0 20 1 0      
14670 grayte01 1955 3 NYA AL 0 0 1 1 0 0 0 9 3 1 0 0 1 0.3 3.0 0 0 0 0 11 0 1      
14995 lapalpa01 1956 3 CHA AL 3 1 29 0 0 0 2 137 31 12 2 27 23 0.19 2.36 2 2 0 0 193 14 14      
15008 littldi01 1956 3 NY1 NL 4 4 31 7 0 0 2 291 78 44 16 39 65 0.23 4.08 5 1 0 0 396 8 45      
15104 surkoma01 1956 3 NY1 NL 2 2 8 4 1 0 1 96 24 17 5 9 18 0.2 4.78 1 1 0 0 129 2 17      
15440 constji01 1958 3 WS1 AL 0 1 15 2 0 0 0 83 29 15 3 15 25 0.27 4.88 0 1 1 0 125 4 15      
15467 fischbi01 1958 3 WS1 AL 0 3 3 3 0 0 0 63 24 9 1 5 10 0.32 3.86 1 0 1 0 86 0 9      
15541 lowntu01 1958 3 CHA AL 3 3 27 0 0 0 8 122 49 18 1 28 40 0.3 3.98 4 2 0 0 195 15 22      
15776 harshja01 1959 3 CLE AL 5 1 13 6 5 1 1 198 46 19 6 13 35 0.17 2.59 0 1 0 0 277 6 21      
15785 hoeftbi01 1959 3 BAL AL 1 1 16 3 0 0 0 123 50 26 6 19 30 0.3 5.71 3 2 0 0 186 6 29      
15868 portebo01 1959 3 PIT NL 1 2 30 0 0 0 1 108 45 19 2 17 18 0.32 4.75 5 5 0 0 160 12 20      
15932 wallmu01 1959 3 BOS AL 1 1 11 0 0 0 0 52 26 11 2 11 6 0.0 5.71 2 1 0 0 86 8 11      
16040 grimbo01 1960 3 SLN NL 1 0 15 0 0 0 0 62 22 7 1 9 15 0.27 3.05 1 0 0 0 92 10 7      
16075 labincl01 1960 3 PIT NL 3 0 15 0 0 0 3 91 29 5 0 11 21 0.25 1.48 3 0 1 0 129 5 5      
16455 stalege01 1961 3 DET AL 1 1 13 0 0 0 2 40 15 5 1 6 8 0.28 3.38 1 1 0 0 60 8 6      
17100 sturdto01 1963 3 KC1 AL 1 2 17 3 0 0 0 159 47 22 3 17 26 0.23 3.74 2 3 1 0 219 4 24      
17298 laryfr01 1964 3 ML1 NL 1 0 5 2 0 0 0 37 15 6 4 0 4 0.3 4.38 0 0 0 0 51 2 7      
17324 meyerbo01 1964 3 KC1 AL 1 4 9 7 2 0 0 126 37 18 2 33 30 0.24 3.86 0 3 0 0 188 1 23      
17405 shantbo01 1964 3 PHI NL 1 1 14 0 0 0 0 96 23 8 1 6 18 0.2 2.25 3 1 0 0 124 3 10      
17424 sprinja01 1964 3 SLN NL 0 0 2 0 0 0 0 9 8 1 1 1 0 0.47 3.0 1 1 0 0 20 0 9      
17764 tiefebo01 1965 3 CLE AL 0 5 15 0 0 0 4 67 24 12 3 10 13 0.27 4.84 3 1 1 0 103 10 17      
17876 fischha01 1966 3 BOS AL 2 3 6 5 1 0 0 93 35 10 4 11 26 0.28 2.9 1 1 1 0 135 0 12      
18177 buzhajo01 1967 3 HOU NL 0 0 1 0 0 0 0 2 0 0 0 0 0 0.0 0.0 0 0 0 0 2 0 0      
18295 lamabja01 1967 3 SLN NL 3 4 23 1 1 1 4 143 43 15 2 10 30 0.24 2.83 3 0 0 0 190 10 16      
18782 wyattjo02 1968 3 DET AL 1 0 22 0 0 0 2 91 26 8 2 11 25 0.23 2.37 2 4 1 0 125 10 9      
18949 johnske02 1969 3 CHN NL 1 2 9 1 0 0 1 57 17 6 2 13 18 0.23 2.84 3 1 0 0 87 3 8      
18962 klinero01 1969 3 BOS AL 0 1 16 0 0 0 1 51 24 9 4 17 7 0.32 4.76 3 1 0 0 92 9 11      
19069 pizarju01 1969 3 OAK AL 1 1 3 0 0 0 1 23 3 2 1 3 4 0.12 2.35 0 0 0 0 28 3 2      
19073 priddbo01 1969 3 ATL NL 0 0 1 0 0 0 0 6 1 0 0 1 1 0.14 0.0 0 0 0 0 8 0 0      
19143 talbofr01 1969 3 OAK AL 1 2 12 2 0 0 1 57 22 11 2 7 9 0.29 5.21 0 0 0 0 82 6 11      
19190 abernte02 1970 3 KCA AL 9 3 36 0 0 0 12 167 41 16 3 38 49 0.209 2.59 0 2 1 0 244 31 23 9 0  
19332 hartech01 1970 3 BOS AL 0 3 17 0 0 0 1 57 21 17 6 12 12 0.28800000000000003 8.05 5 1 1 0 88 4 17 2 0  
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  
19514 rodriro01 1970 3 CHN NL 3 2 26 0 0 0 2 130 50 28 6 15 46 0.289 5.82 2 1 0 0 193 12 33 2 3  
19812 millebo04 1971 3 PIT NL 1 2 16 0 0 0 3 84 20 4 1 13 13 0.2 1.29 4 0 0 0 115 10 8 2 0  
19847 patteda02 1971 3 SLN NL 0 1 13 2 0 0 1 80 20 13 3 15 11 0.21100000000000002 4.39 1 2 0 0 112 7 14 0 2  
20116 kilkemi01 1972 3 SDN NL 0 0 5 0 0 0 0 13 7 4 1 3 5 0.35 8.31 0 1 0 0 23 3 4 0 0  
20237 rolanji01 1972 3 TEX AL 0 0 5 0 0 0 0 10 7 3 1 2 4 0.41200000000000003 8.1 1 0 1 0 20 1 3 0 0  
20534 millebo04 1973 3 NYN NL 0 0 1 0 0 0 0 3 0 0 0 0 1 0.0 0.0 0 0 0 0 3 0 0 0 0 0
20631 spraged01 1973 3 ML4 AL 0 1 7 0 0 0 1 29 13 10 0 14 3 0.317 9.31 5 1 2 0 59 5 11 0 2 1
21290 odombl01 1975 3 ATL NL 1 7 15 10 0 0 0 168 78 44 5 28 30 0.342 7.07 0 4 0 1 263 1 46 5 2 5
21325 reynobo01 1975 3 CLE AL 0 2 5 0 0 0 2 29 11 5 0 3 5 0.289 4.66 1 2 0 0 41 3 7 0 0 0
21339 sadecra01 1975 3 KCA AL 1 0 5 0 0 0 0 9 5 1 0 3 0 0.33299999999999996 3.0 0 0 0 0 18 1 2 0 0 0
21869 ellisdo01 1977 3 TEX AL 10 6 23 22 7 1 1 502 158 54 13 42 90 0.254 2.9 1 4 0 0 685 1 60 12 8 19
21911 hargast01 1977 3 ATL NL 0 3 16 5 0 0 0 110 49 28 3 16 18 0.325 6.87 1 6 0 1 172 3 31 3 2 6

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