3,509 rows where stint = 2 sorted by GF

View and edit SQL

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

stint

  • 2 · 3,509
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
22 brainas01 1872 2 MID   0 2 2 2 1 0 0 24 13 5 1 0 0   5.63   0   0 50 0 17      
43 zettlge01 1872 2 BR1   1 8 9 9 8 0 0 226 106 30 1 6 8   3.58   6   0 360 0 62      
88 bechtge01 1875 2 PH1   3 1 4 4 4 0 0 108 41 10 0 3 3   2.5   1   0 150 0 19      
102 fleetfr01 1875 2 BR2   0 1 2 1 1 0 0 46 26 8 0 0 0   4.7   1   0 78 0 20      
106 goldemi01 1875 2 CH2   6 7 14 14 12 1 0 357 129 25 0 8 14   1.89   13   0 531 0 95      
132 zettlge01 1875 2 PH2   12 8 21 21 20 1 0 544 209 42 0 10 13   2.08   4   0 803 0 121      
227 purcebl01 1879 2 CN1 NL 0 2 2 2 2 0 0 54 27 8 0 2 3   4.0   3   0 78 0 15      
268 bradlge01 1881 2 CL2 NL 2 4 6 6 5 0 0 153 70 22 2 3 6   3.88   2   0 222 0 36      
311 critcmo01 1882 2 SL4 AA 0 4 4 4 4 0 0 102 43 16 3 7 2   4.24   0   0 156 0 31      
332 learyja01 1882 2 BL2 AA 2 1 3 3 3 0 0 78 29 3 1 8 2   1.04   4   0 118 0 22      
340 mountfr01 1882 2 PH4 AA 2 6 8 8 8 0 0 207 72 30 1 11 15   3.91   10   0 298 0 49      
409 haganar01 1883 2 BFN NL 0 2 2 2 1 0 0 45 17 6 0 6 7   3.6   3   0 69 0 12      
417 jonesja02 1883 2 PH4 AA 5 2 7 7 7 0 0 195 58 19 1 6 28   2.63   3   0 266 0 38      
428 mcintfr01 1883 2 CL5 AA 1 1 2 2 2 0 0 57 20 11 0 7 6   5.21   2   0 86 0 19      
468 atkinal01 1884 2 CHU UA 6 10 16 16 16 1 0 420 127 43 1 21 104   2.76   5   0 584 0 83      
472 bakelje01 1884 2 WIL UA 0 2 2 2 2 0 0 51 24 8 0 1 9   4.24   2   0 78 0 17      
476 barrbo01 1884 2 IN2 AA 3 11 16 16 15 0 0 395 159 73 2 19 69   4.99   13 5 0 605 0 117      
481 beckfr01 1884 2 BLU UA 0 2 2 2 1 0 0 27 17 8 0 4 7   8.0   5   0 49 0 13      
486 bondto01 1884 2 IN2 AA 0 5 5 5 5 0 0 129 62 27 5 4 15   5.65   7 2 0 206 0 51      
492 brownji01 1884 2 NY1 NL 0 1 1 1 1 0 0 27 10 5 0 8 2   5.0   2   0 46 0 9      
507 cattajo01 1884 2 SLU UA 1 1 2 2 2 0 0 51 12 4 0 4 13   2.12   5   0 69 0 10      
530 dailyhu01 1884 2 WSU UA 1 1 2 2 2 0 0 48 16 4 0 1 14   2.25   3   0 67 0 11      
533 davisda01 1884 2 BSN NL 1 3 4 4 3 0 0 93 50 27 2 8 13   7.84   2   0 149 0 36      
535 deaglre01 1884 2 LS2 AA 4 6 12 12 8 0 0 262 81 25 0 13 23   2.58   5 7 0 356 0 43      
552 foremfr01 1884 2 KCU UA 0 1 1 1 1 0 0 24 17 5 0 2 5   5.63   2   0 44 0 12      
559 gardngi01 1884 2 CHU UA 0 1 1 1 0 0 0 18 10 4 0 1 4   6.0   2   0 30 0 8      
565 goldsfr01 1884 2 BL2 AA 3 1 4 4 3 0 0 90 29 9 0 2 11   2.7   0 1 0 125 0 12      
566 gormaja01 1884 2 PT1 AA 1 2 3 3 3 0 0 75 22 13 0 5 10   4.68   1 1 0 110 0 20      
608 mccorji01 1884 2 CNU UA 21 3 24 24 24 7 0 630 151 36 3 14 161   1.54   3   0 818 0 57      
610 mcelrji01 1884 2 WIL UA 0 1 1 1 0 0 0 15 10 6 0 0 3   10.8   0   0 26 0 6      
624 moriage01 1884 2 IN2 AA 0 2 2 2 2 0 0 41 16 8 0 7 4   5.27   1 1 0 68 0 13      
666 smithph01 1884 2 PT1 AA 0 1 1 1 1 0 0 24 11 8 0 2 4   9.0   1 1 0 39 0 10      
678 taylobi01 1884 2 PH4 AA 18 12 30 30 30 1 0 780 232 73 3 44 130   2.53   13 12 0 1115 0 118      
680 tennefr01 1884 2 BSU UA 3 1 4 4 4 0 0 105 31 9 0 5 18   2.31   4   0 145 0 21      
692 wheelha01 1884 2 KCU UA 0 1 1 1 1 0 0 24 7 1 0 0 6   1.13   2   0 32 0 6      
716 connojo02 1885 2 LS2 AA 1 3 4 4 4 0 0 105 43 19 0 12 19   4.89   2 2 0 160 0 27      
720 corcola01 1885 2 NY1 NL 2 1 3 3 2 0 0 75 24 8 1 11 10   2.88   2   0 109 0 12      
725 cushmed01 1885 2 NY4 AA 8 14 22 22 22 0 0 573 158 59 2 33 133   2.78   18 3 1 790 0 105      
731 emslibo01 1885 2 PH4 AA 0 4 4 4 3 0 0 86 37 20 1 6 9   6.28   3 0 0 133 0 30      
739 galvipu01 1885 2 PT1 AA 3 7 11 11 9 0 0 265 97 36 2 7 27   3.67   7 0 0 372 0 64      
766 mccorji01 1885 2 CHN NL 20 4 24 24 24 3 0 645 187 58 8 40 88   2.43   3   0 873 0 103      
774 mountbi01 1885 2 BL2 AA 2 4 6 6 6 1 0 159 72 32 1 13 15   5.43   2 4 0 245 0 47      
798 smithph01 1885 2 PH4 AA 0 1 1 1 0 0 0 12 7 4 0 4 7   9.0   2 1 0 24 0 9      
806 vintobi01 1885 2 PH4 AA 4 3 7 7 6 2 0 165 46 15 1 15 34   2.45   4 4 1 249 0 41      
840 conwape01 1886 2 DTN NL 6 5 11 11 11 0 0 273 93 34 1 25 35   3.36   6   0 389 0 55      
867 hendeha01 1886 2 BR3 AA 10 4 14 14 14 0 0 372 112 40 2 51 49   2.9   14 0 0 533 0 82      
878 kennete01 1886 2 LS2 AA 0 4 4 4 4 0 0 96 53 19 1 16 14   5.34   5 1 0 168 0 43      
894 mckeola01 1886 2 KCN NL 0 2 3 3 3 0 0 63 44 25 0 8 3   10.71   2   0 115 0 32      
901 murphjo02 1886 2 SL5 NL 0 4 4 4 3 0 0 99 45 30 3 16 11   8.18   10   0 157 0 41      
916 reardje02 1886 2 CN2 AA 0 1 1 1 0 0 0 6 5 4 0 4 0   18.0   0 0 0 14 0 4      
932 smithre01 1886 2 PH4 AA 0 1 1 1 1 0 0 27 15 7 0 5 4   7.0   3 0 0 44 0 13      
985 dailyed01 1887 2 WS8 NL 0 1 1 1 1 0 0 21 5 6 0 6 3   7.71   1 0 0 30 0 6      
1018 kirbyjo01 1887 2 CL3 AA 0 5 5 5 5 0 0 123 62 41 1 28 6   9.0   8 2 0 213 0 53      
1020 knoufed01 1887 2 SL4 AA 4 2 6 6 6 1 0 150 40 25 0 36 18   4.5   1 3 0 217 0 34      
1066 shrevle01 1887 2 IN3 NL 5 9 14 14 14 1 0 366 141 64 5 65 22   4.72   6 4 0 576 0 100      
1082 titcoca01 1887 2 NY1 NL 4 3 9 9 9 0 0 216 68 31 3 37 34   3.88   3 1 1 330 0 50      
1093 wiedmst01 1887 2 NY4 AA 4 8 12 12 11 1 0 291 122 50 3 25 37   4.64   7 1 0 444 0 84      
1112 chambel01 1888 2 SL4 AA 11 2 14 14 13 1 0 336 61 20 1 27 57   1.61   11 6 0 428 0 34      
1120 crowebi01 1888 2 LS2 AA 0 1 1 1 1 0 0 27 12 6 1 6 5   6.0   0 1 0 46 0 14      
1161 knoufed01 1888 2 CL3 AA 0 1 2 2 1 0 0 27 8 1 0 3 2   1.0   1 1 0 39 0 2      
1192 smithph01 1888 2 PH4 AA 2 1 3 3 3 0 0 66 21 7 0 10 19   2.86   4 0 0 97 0 15      
1271 healyjo01 1889 2 CHN NL 1 4 5 5 5 0 0 138 48 23 4 18 22   4.5   3 4 0 206 0 35      
1276 irwinar01 1889 2 WS8 NL 0 0 1 0 0 0 0 3 1 0 0 0 0   0.0   0 0 0 4 0 1      
1284 krockgu01 1889 2 IN3 NL 2 2 4 4 3 0 0 96 48 26 2 14 10   7.31   1 0 0 157 0 38      
1305 odayha01 1889 2 NY1 NL 9 1 10 10 8 0 0 234 83 37 2 35 28   4.27   0 7 0 355 0 51      
1348 anderda01 1890 2 PIT NL 2 11 13 13 13 0 0 324 116 56 2 49 41   4.67   4 7 0 493 0 84      
1353 baldwla01 1890 2 BFP PL 2 5 7 7 7 0 0 186 90 31 5 24 13   4.5   2 3 0 304 0 72      
1378 cunnibe01 1890 2 BFP PL 9 15 25 25 24 2 0 633 251 137 8 134 78   5.84   20 6 0 1027 0 190      
1387 daybi01 1890 2 PIT NL 0 6 6 6 6 0 0 150 66 29 1 24 10   5.22   1 1 0 239 0 50      
1403 esperdu01 1890 2 PIT NL 0 2 2 2 2 0 0 51 18 10 0 10 9   5.29   2 1 0 79 0 16      
1421 gibsoro01 1890 2 PIT NL 0 3 3 3 2 0 0 36 24 23 0 23 3   17.25   6 3 0 86 0 38      
1444 hughemi01 1890 2 PH4 AA 1 3 6 5 4 0 0 124 64 25 0 21 15   5.44   5 5 0 212 0 56      
1461 lawsoal01 1890 2 PIT NL 0 2 2 2 1 0 0 30 15 10 0 10 2   9.0   2 0 0 55 0 20      
1464 lincoez01 1890 2 SR2 AA 0 3 3 3 2 0 0 60 33 23 1 4 6   10.35   1 1 0 97 0 27      
1476 mcculch01 1890 2 SR2 AA 1 2 3 3 3 0 0 78 29 21 1 14 8   7.27   0 0 0 120 0 25      
1486 morrimi01 1890 2 BL3 AA 1 2 4 4 3 0 0 78 15 11 0 20 13   3.81   3 2 0 114 0 20      
1489 murphbo01 1890 2 BR4 AA 3 9 12 12 10 0 0 288 121 61 6 46 26   5.72   2 5 0 456 0 95      
1498 oneiled01 1890 2 PH4 AA 0 6 6 6 6 0 0 156 84 56 0 32 17   9.69   11 7 0 277 0 77      
1517 smithph01 1890 2 PIT NL 1 3 5 5 5 0 0 132 39 15 0 13 15   3.07   4 1 0 184 0 25      
1543 viaule01 1890 2 CL4 NL 4 9 13 13 13 1 0 321 101 40 4 42 30   3.36   3 5 0 466 0 65      
1563 bellch01 1891 2 CN3 AA 1 0 1 1 1 0 0 27 2 0 0 3 1   0.0   0 1 0 33 0 2      
1592 duryeje01 1891 2 SL4 AA 1 1 3 3 2 0 0 72 19 9 0 10 13   3.38   4 0 0 100 0 13      
1594 dwyerfr01 1891 2 ML3 AA 6 4 10 10 10 0 0 258 92 21 2 21 27   2.2   1 4 0 373 0 41      
1610 getzich01 1891 2 CL4 NL 0 1 1 1 1 0 0 27 12 8 1 4 4   8.0   1 0 0 43 0 9      
1647 mainswi01 1891 2 ML3 AA 0 2 2 2 1 0 0 30 14 12 1 10 2   10.8   1 0 0 54 0 19      
1683 stratsc01 1891 2 LS2 AA 6 13 20 20 20 1 0 516 204 78 10 34 52   4.08   6 7 0 757 0 112      
1685 sulliji01 1891 2 CL6 AA 0 1 1 1 1 0 0 27 10 4 1 5 1   4.0   1 1 0 43 0 9      
1687 sullimi02 1891 2 NY1 NL 1 2 3 3 3 0 0 72 24 9 0 8 11   3.38   5 1 0 105 0 19      
1728 esperdu01 1892 2 PIT NL 2 0 3 3 1 0 0 55 18 11 0 12 5   5.4   2 0 0 85 0 13      
1735 galvipu01 1892 2 SLN NL 5 6 12 12 10 0 0 276 102 33 4 26 27   3.23   1 3 0 407 0 47      
1748 healyjo01 1892 2 LS3 NL 1 1 2 2 2 0 0 55 15 4 0 5 4   1.96   0 0 0 75 0 7      
1750 hemmige01 1892 2 LS3 NL 2 2 4 4 4 0 0 105 36 18 1 17 12   4.63   0 0 0 158 0 25      
1755 inksbe01 1892 2 WAS NL 1 2 3 3 3 0 0 63 29 12 0 10 11   5.14   2 2 0 104 0 27      
1757 jonesal01 1892 2 WAS NL 0 3 4 4 3 0 0 81 33 12 0 14 7   4.0   2 2 0 130 0 23      
1773 meakige01 1892 2 CIN NL 1 1 3 3 1 0 0 41 19 13 1 9 4   8.56   1 2 0 71 0 18      
1775 meekijo01 1892 2 WAS NL 3 10 14 14 13 1 0 336 112 43 2 48 58   3.46   6 4 0 500 0 91      
1781 rettgge01 1892 2 CIN NL 1 0 1 1 1 0 0 27 8 4 0 10 1   4.0   0 1 0 46 0 5      
1791 stephbe01 1892 2 CIN NL 0 1 1 1 0 0 0 21 12 1 0 4 1   1.29   0 0 0 37 0 3      
1827 craneed01 1893 2 BRO NL 0 2 2 2 1 0 0 30 19 15 2 9 5   13.5   1 1 0 59 0 19      
1856 hawkebi01 1893 2 BLN NL 11 16 29 29 22 1 0 675 248 119 8 108 69   4.76   12 9 0 1031 0 175      

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