47,628 rows sorted by BB

View and edit SQL

These facets timed out: 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
3 fergubo01 1871 1 NY2   0 0 1 0 0 0 0 3 8 3 0 0 0   27.0   2   0 14 0 9      
6 flowedi01 1871 1 TRO   0 0 1 0 0 0 0 3 1 0 0 0 0   0.0   0   0 3 1 0      
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      
41 wrighha01 1872 1 BS1   1 0 7 0 0 0 4 77 26 6 0 0 1   2.1   0   0 109 6 12      
51 fleetfr01 1873 1 ELI   0 3 3 3 2 0 0 72 57 14 0 0 1   5.25   0   0 141 0 47      
53 frencbi01 1873 1 BL4   0 1 1 1 1 0 0 27 30 12 0 0 0   12.0   0   0 65 0 27      
60 mcdoo01 1873 1 BL4   0 1 1 1 1 0 0 27 18 3 0 0 0   3.0   0   0 59 0 24      
62 selmafr01 1873 1 BL4   0 1 1 1 1 0 0 27 21 8 0 0 0   8.0   0   0 60 0 26      
76 forceda01 1874 1 CH2   0 0 1 0 0 0 0 21 22 12 4 0 0   15.43   0   0 51 1 24      
77 hatfijo01 1874 1 NY2   0 1 3 0 0 0 0 24 11 2 0 0 0   2.25   0   0 35 3 6      
81 ryanjo01 1874 1 BL1   0 0 1 0 0 0 0 10 13 6 0 0 0   16.2   1   0 23 0 8      
86 arundha01 1875 1 BR2   0 1 1 1 0 0 0 7 6 2 0 0 0   7.71   0   0 15 0 6      
92 boydbi01 1875 1 BR2   0 0 1 0 0 0 0 5 4 0 0 0 0   0.0   1   0 9 1 3      
98 edwar01 1875 1 BR2   0 1 1 1 0 0 0 6 4 1 0 0 0   4.5   1   0 13 0 6      
99 fergubo01 1875 1 HR1   0 0 1 0 0 0 0 6 9 5 1 0 0   22.5   1   0 15 0 7      
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      
107 heifefr01 1875 1 BS1   0 0 2 0 0 0 1 7 6 4 0 0 0   15.43   0   0 13 1 4      
108 knighge01 1875 1 NH1   1 0 1 1 1 0 0 27 12 3 0 0 0   3.0   0   0 41 0 6      
119 oneilj01 1875 1 BR2   0 4 5 4 3 0 0 102 59 19 3 0 0   5.03   2   0 172 1 45      
123 pearcdi01 1875 1 SL2   0 0 2 0 0 0 0 16 10 2 0 0 0   3.38   0   0 30 1 11      
127 suttoez01 1875 1 PH1   0 0 2 0 0 0 0 18 14 7 0 0 0   10.5   1   0 34 2 13      
129 withech01 1875 1 WS6   0 1 1 1 0 0 0 3 4 2 0 0 0   18.0   0   0 9 0 5      
130 wrighge01 1875 1 BS1   0 1 2 0 0 0 0 12 5 3 0 0 0   6.75   0   0 17 1 3      
133 barnero01 1876 1 CHN NL 0 0 1 0 0 0 0 4 7 3 0 0 0   20.25   0   0 13 0 8      
136 bootham01 1876 1 CN1 NL 0 1 3 1 0 0 0 29 22 10 0 0 0   9.31   0   0 51 1 18      
137 boothed01 1876 1 NY3 NL 0 0 1 0 0 0 0 15 16 6 0 0 0   10.8   0   0 34 1 10      
141 clackbo01 1876 1 CN1 NL 0 0 1 0 0 0 0 6 2 1 0 0 0   4.5   0   0 8 1 1      
142 clintji01 1876 1 LS1 NL 0 1 1 1 1 0 0 27 12 6 0 0 1   6.0   2   0 43 0 11      
143 coonwi01 1876 1 PHN NL 0 0 2 0 0 0 0 21 9 4 0 0 0   5.14   0   0 35 2 8      
148 gouldch01 1876 1 CN1 NL 0 0 2 0 0 0 0 13 10 0 0 0 0   0.0   0   0 25 1 9      
150 laffefl01 1876 1 PHN NL 0 1 1 1 1 0 0 27 5 0 0 0 0   0.0   0   0 33 0 3      
151 larkite01 1876 1 NY3 NL 0 1 1 1 1 0 0 27 9 3 0 0 0   3.0   0   0 39 0 7      
157 nichotr01 1876 1 BSN NL 1 0 1 1 1 0 0 27 7 1 0 0 0   1.0   0   0 35 0 5      
160 piersda01 1876 1 CN1 NL 0 1 1 1 0 0 0 0 2 2 1 0 0       0   0 2 0 2      
161 ryanjo01 1876 1 LS1 NL 0 0 1 0 0 0 0 24 22 5 0 0 1   5.63   7   0 49 1 20      
163 whitede01 1876 1 CHN NL 0 0 1 0 0 0 1 6 1 0 0 0 3   0.0   0   0 7 1 0      
165 wrighge01 1876 1 BSN NL 0 0 1 0 0 0 0 3 1 0 0 0 1   0.0   1   0 4 1 0      
184 spaldal01 1877 1 CHN NL 1 0 4 1 0 0 1 33 17 4 0 0 2   3.27   0   0 53 2 12      
191 fishech01 1878 1 PRO NL 0 1 1 1 1 0 0 27 14 4 0 0 2   4.0   1   0 46 0 12      
193 hankifr01 1878 1 CHN NL 0 1 1 1 1 0 0 27 11 6 0 0 4   6.0   1   0 39 0 9      
214 gardngi01 1879 1 TRN NL 0 2 2 2 2 0 0 42 27 9 0 0 3   5.79   7   0 74 0 21      
239 dorgami01 1880 1 PRO NL 0 0 1 0 0 0 0 24 4 1 0 0 2   1.13   0   0 29 1 3      
241 evansja01 1880 1 TRN NL 0 0 1 0 0 0 0 12 11 6 0 0 0   13.5   0   0 21 1 8      
252 learyja01 1880 1 BSN NL 0 1 1 1 0 0 0 9 8 5 0 0 1   15.0   0   0 11 0 5      
297 willine01 1881 1 CHN NL 1 1 3 1 1 0 0 54 14 4 0 0 2   2.0   1   0 67 2 9      
302 browned01 1882 1 SL4 AA 0 0 1 0 0 0 0 6 2 0 0 0 1   0.0   0   0 8 1 1      
305 burkeja01 1882 1 BFN NL 0 1 1 1 0 0 0 12 10 5 0 0 0   11.25   0   0 23 0 9      
318 evansja01 1882 1 WOR NL 0 1 1 1 1 0 0 24 13 5 1 0 2   5.63   1   0 41 0 10      
320 foleycu01 1882 1 BFN NL 0 0 1 0 0 0 0 3 2 2 0 0 0   18.0   0   0 6 0 2      
327 hoganed01 1882 1 SL4 AA 0 1 1 1 1 0 0 24 10 1 0 0 4   1.13   0   0 35 0 7      
338 morrijo01 1882 1 BSN NL 0 0 1 0 0 0 0 6 3 0 0 0 2   0.0   0   0 8 1 0      
394 dolanto01 1883 1 SL4 AA 0 0 1 0 0 0 0 12 4 2 0 0 0   4.5   0   0 16 1 3      
399 evansja01 1883 1 CL2 NL 0 0 1 0 0 0 0 9 0 0 0 0 1   0.0   0   0 9 1 0      
400 fergubo01 1883 1 PHI NL 0 0 1 0 0 0 0 3 2 1 0 0 0   9.0   0   0 7 1 2      
419 kellyki01 1883 1 CHN NL 0 0 1 0 0 0 0 3 1 0 0 0 0   0.0   0   0 3 1 0      
443 reccijo01 1883 1 LS2 AA 0 0 1 0 0 0 0 12 10 1 0 0 0   2.25   0   0 22 1 3      
449 smithpo01 1883 1 CL5 AA 0 0 3 0 0 0 0 17 10 4 0 0 0   6.35   0   0 28 3 7      
451 stoveha01 1883 1 PH4 AA 0 0 1 0 0 0 0 9 5 3 0 0 4   9.0   2   0 14 1 3      
477 bastich01 1884 1 WIL UA 0 0 1 0 0 0 0 18 6 2 0 0 2   3.0   2   0 25 1 5      
512 comisch01 1884 1 SL4 AA 0 0 1 0 0 0 0 12 1 1 0 0 4   2.25   0 0 0 17 1 1      
515 connojo01 1884 2 KCU UA 0 1 2 1 1 0 0 36 24 6 1 0 1   4.5   2   0 61 1 14      
522 coughed01 1884 1 BFN NL 0 0 1 0 0 0 0 0 3 3 0 0 0       2   0 5 0 4      
537 dorseje01 1884 1 BLU UA 0 1 1 1 0 0 0 12 7 4 1 0 3   9.0   0   0 19 0 8      
538 drewda01 1884 1 PHU UA 0 1 1 0 0 0 0 21 7 3 0 0 2   3.86   1   0 29 1 5      
542 dunlafr01 1884 1 SLU UA 0 0 1 0 0 0 1 2 2 1 0 0 1   13.5   0   0 4 1 1      
550 fogarji01 1884 1 PHI NL 0 0 1 0 0 0 0 3 2 0 0 0 1   0.0   1   0 6 1 2      
576 hinespa01 1884 1 PRO NL 0 0 1 0 0 0 0 3 3 0 0 0 0   0.0   1   0 6 0 1      
579 housech01 1884 1 CHU UA 0 0 2 0 0 0 0 9 4 1 0 0 3   3.0   0   0 13 2 3      
583 keenaji01 1884 1 IN2 AA 0 0 1 0 0 0 0 9 2 1 0 0 0   3.0   0 0 0 11 1 1      
606 mccorje01 1884 1 PHU UA 0 0 1 0 0 0 0 6 5 2 1 0 3   9.0   0   0 11 1 4      
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      
617 mcsortr01 1884 1 TL1 AA 0 0 1 0 0 0 0 6 5 1 0 0 1   4.5   0 0 0 9 1 2      
620 millecy01 1884 1 CHU UA 1 0 1 1 1 0 0 27 4 1 0 0 13   1.0   1   0 32 0 2      
649 purcebl01 1884 1 PHI NL 0 0 1 0 0 0 0 12 3 1 0 0 1   2.25   2   0 16 1 1      
655 roweda01 1884 1 SLU UA 1 0 1 1 1 0 0 27 10 2 0 0 2   2.0   0   0 38 0 3      
664 smithge01 1884 1 ALT UA 0 0 1 0 0 0 0 3 3 1 0 0 1   9.0   1   0 6 1 2      
671 sulliwi01 1884 1 SLU UA 1 0 1 1 0 0 0 18 10 3 0 0 3   4.5   0   0 29 0 6      
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      
709 burnsdi01 1885 1 SL5 NL 0 0 1 0 0 0 0 9 3 3 0 0 2   9.0   1   0 12 1 3      
761 maculji01 1885 1 BL2 AA 0 0 1 0 0 0 0 3 0 0 0 0 0   0.0   0 0 0 3 1 0      
793 sewared01 1885 1 PRO NL 0 0 1 0 0 0 0 18 2 0 0 0 1   0.0   2   0 20 1 0      
796 smithed01 1885 1 PRO NL 1 0 1 1 1 0 0 27 9 1 0 0 1   1.0   2   0 33 0 3      
799 sommejo01 1885 1 BL2 AA 0 0 2 0 0 0 1 9 6 3 0 0 0   9.0   1 0 0 14 2 3      
813 willine01 1885 1 CHN NL 0 0 2 0 0 0 2 18 2 0 0 0 3   0.0   0   0 25 2 0      
815 wolfji01 1885 1 LS2 AA 0 0 1 0 0 0 0 3 1 1 0 0 1   9.0   0 0 0 5 0 2      
842 corkhpo01 1886 1 CN2 AA 0 0 1 0 0 0 0 2 1 1 0 0 1   13.5   0 0 0 3 1 1      
851 fogarji01 1886 1 PHI NL 0 1 1 0 0 0 0 18 7 0 0 0 4   0.0   1   0 28 1 6      
885 maculji01 1886 1 BL2 AA 0 0 1 0 0 0 0 6 4 2 0 0 1   9.0   0 0 0 10 1 3      
897 morrijo01 1886 1 BSN NL 0 0 1 0 0 0 0 12 5 0 0 0 2   0.0   1   0 16 1 1      
908 pinknge01 1886 1 BR3 AA 0 0 1 0 0 0 0 6 2 1 0 0 0   4.5   1 0 0 5 1 1      
912 purcebl01 1886 1 BL2 AA 0 0 1 0 0 0 0 3 1 1 0 0 0   9.0   0 0 0 5 0 1      
922 rosemch01 1886 1 NY4 AA 0 0 1 0 0 0 0 21 6 4 0 0 0   5.14   0 0 0 25 1 6      
936 stoveha01 1886 1 PH4 AA 0 0 1 0 0 0 0 1 2 1 0 0 0   27.0   0 0 0 3 0 2      
953 willine01 1886 1 CHN NL 0 0 2 0 0 0 1 9 2 0 0 0 1   0.0   0   0 14 2 2      
956 wolfji01 1886 1 LS2 AA 0 0 1 0 0 0 0 9 7 5 0 0 0   15.0   0 0 0 20 1 8      
964 bierblo01 1887 1 PH4 AA 0 0 1 0 0 0 1 3 0 0 0 0 1   0.0   0 0 0 3 1 0      
988 dunlafr01 1887 1 DTN NL 0 0 1 0 0 0 0 6 4 1 0 0 1   4.5   0 0 0 8 1 2      
1002 glassja01 1887 1 IN3 NL 0 0 1 0 0 0 0 3 0 0 0 0 1   0.0   0 0 0 3 1 0      
1101 bierblo01 1888 1 PH4 AA 0 0 1 0 0 0 0 9 5 0 0 0 3   0.0   1 0 0 14 1 1      
1117 corkhpo01 1888 1 CN2 AA 0 0 2 0 0 0 1 15 8 6 1 0 1   10.8   0 0 0 23 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
);