47,628 rows sorted by ER

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
3092 hookebu01 1903 1 CIN NL 0 0 1 0 0 0 0 7 2 0 0 2 0   0.0   0 0 0 10 1 0      
3164 tayloed01 1903 1 SLN NL 0 0 1 0 0 0 0 9 0 0 0 0 1   0.0   0 0 0 12 1 0      
3178 wickebo01 1903 1 SLN NL 0 0 1 0 0 0 0 15 4 0 0 3 3   0.0   1 0 0 26 1 1      
3219 delahji01 1904 1 BSN NL 0 0 1 0 0 0 0 10 5 0 0 1 0   0.0   0 0 0 15 1 3      
3223 doschja01 1904 1 BRO NL 0 0 2 0 0 0 0 19 1 0 0 1 2   0.0   0 0 0 20 1 1      
3224 doughto01 1904 1 CHA AL 1 0 1 0 0 0 0 6 0 0 0 0 0   0.0   0 0 0 6 1 0      
3394 howarde01 1905 1 PIT NL 0 0 1 0 0 0 0 18 4 0 1 1 0   0.0   0 1 0 22 1 7      
3424 moorege01 1905 1 PIT NL 0 0 1 0 0 0 0 9 2 0 0 0 1   0.0   0 0 0 10 1 0      
3462 vanzaik01 1905 1 SLA AL 0 0 1 0 0 0 0 20 2 0 0 2 3   0.0   0 1 0 24 1 0      
3494 camerja01 1906 1 BSN NL 0 0 2 1 0 0 0 18 4 0 0 6 2   0.0   0 0 0 25 1 0      
3537 harpeja01 1906 2 CHN NL 0 0 1 1 0 0 0 3 0 0 0 0 0   0.0   0 0 0 3 0 0      
3549 isbelfr01 1906 1 CHA AL 0 0 1 0 0 0 0 6 1 0 0 0 2   0.0   1 0 0 7 1 0      
3558 krohru01 1906 1 BOS AL 1 0 1 1 1 1 0 27 2 0 0 4 5   0.0   0 0 0 31 0 0      
3627 tiemeed01 1906 1 CIN NL 0 0 1 0 0 0 0 3 1 0 0 1 1   0.0   0 0 0 3 1 0      
3661 bradyki01 1907 1 PIT NL 0 0 1 0 0 0 0 6 2 0 0 1 0   0.0   0 0 0 8 1 1      
3676 covelha01 1907 1 PHI NL 1 0 4 0 0 0 0 60 10 0 0 3 6   0.0   0 1 0 72 4 2      
3715 hopesa01 1907 1 PHA AL 0 0 1 0 0 0 0 1 3 0 0 0 0   0.0   0 0 0 4 0 1      
3719 isbelfr01 1907 1 CHA AL 0 0 1 0 0 0 1 1 0 0 0 0 0   0.0   0 0 0 1 1 0      
3749 mathehe01 1907 1 NY1 NL 0 0 1 0 0 0 1 3 1 0 0 0 0   0.0   1 0 0 4 1 0      
3831 bradyki01 1908 1 BOS AL 1 0 1 1 1 1 0 27 8 0 0 0 3   0.0   0 0 0 33 0 0      
3842 chaseha01 1908 1 NYA AL 0 0 1 0 0 0 0 1 0 0 0 0 0   0.0   0 0 0 1 0 0      
3884 hilleho01 1908 1 PIT NL 0 0 1 0 0 0 0 3 1 0 0 0 1   0.0   0 0 0 3 1 0      
3920 mccarto02 1908 2 PIT NL 0 0 2 1 0 0 0 18 3 0 0 6 1   0.0   0 0 0 23 1 1      
3927 mooreea01 1908 1 PHI NL 2 1 3 3 3 1 0 78 20 0 0 8 16   0.0   1 2 0 102 0 4      
3952 rhodech01 1908 1 CIN NL 0 0 1 0 0 0 0 12 1 0 0 2 4   0.0   0 1 0 16 1 2      
4016 bernajo01 1909 1 SLN NL 0 0 1 0 0 0 0 3 1 0 0 2 2   0.0   1 0 0 6 1 0      
4033 carmich01 1909 1 CIN NL 0 0 2 0 0 0 0 21 9 0 0 3 2   0.0   2 2 0 33 2 6      
4043 coleki01 1909 1 CHN NL 1 0 1 1 1 1 0 27 6 0 0 3 1   0.0   0 0 0 34 0 0      
4044 collior01 1909 1 WS1 AL 0 0 1 0 0 0 0 3 0 0 0 0 1   0.0   0 0 0 3 1 0      
4074 frasech01 1909 1 CHN NL 0 0 1 0 0 0 0 9 2 0 0 4 1   0.0   0 0 0 13 0 1      
4197 wackech01 1909 1 PIT NL 0 0 1 0 0 0 0 6 2 0 0 1 0   0.0   0 0 0 6 1 2      
4200 wallere01 1909 1 NY1 NL 0 0 1 0 0 0 0 3 3 0 0 0 1   0.0   0 1 0 8 1 2      
4236 bresnro01 1910 1 SLN NL 0 0 1 0 0 0 0 10 6 0 0 1 0   0.0   0 0 0 16 1 1      
4242 burnsbi01 1910 1 CHA AL 0 0 1 0 0 0 0 1 0 0 0 1 0   0.0   0 0 0 2 0 0      
4250 chambbi01 1910 1 SLN NL 0 0 1 0 0 0 0 3 1 0 0 0 0   0.0   0 0 0 4 0 1      
4269 dowdki01 1910 1 PIT NL 0 0 1 0 0 0 0 6 4 0 0 2 1   0.0   0 1 0 13 1 4      
4281 flahepa02 1910 1 PHI NL 0 0 1 0 0 0 0 1 1 0 0 1 0   0.0   0 0 0 4 1 4      
4345 merceja01 1910 1 PIT NL 0 0 1 0 0 0 0 3 0 0 0 2 1   0.0   0 0 0 4 1 0      
4358 oharabi01 1910 1 SLN NL 0 0 1 0 0 0 0 3 0 0 0 0 0   0.0   0 0 0 3 0 0      
4386 russele01 1910 1 PHA AL 1 0 1 1 1 1 0 27 8 0 0 2 5   0.0   0 0 0 33 0 0      
4431 aitchra01 1911 1 BRO NL 0 1 1 0 0 0 0 4 1 0 0 1 0 0.2 0.0   0 0 0 6 0 2      
4435 armstho01 1911 1 PHA AL 0 1 1 0 0 0 0 9 3 0 0 1 0 0.27 0.0   0 0 0 12 1 2      
4461 camniha01 1911 1 SLN NL 1 0 2 0 0 0 0 6 0 0 0 1 2 0.0 0.0   0 0 0 7 2 0      
4466 chenela01 1911 1 CHN NL 1 0 3 1 0 0 0 30 8 0 0 3 11 0.22 0.0   0 0 0 38 2 0      
4616 smithja01 1911 1 PHI NL 0 0 2 0 0 0 0 15 3 0 0 2 1 0.17 0.0   0 0 0 19 2 0      
4629 thomabl01 1911 1 BOS AL 0 0 2 2 0 0 0 14 3 0 0 7 0 0.27 0.0   0 1 0 19 0 2      
4680 bradybi01 1912 1 BSN NL 0 0 1 0 0 0 0 3 2 0 0 0 0 0.5 0.0   0 0 0 4 1 0      
4711 cramebi01 1912 1 CIN NL 0 0 1 0 0 0 0 7 6 0 0 0 2 0.5 0.0   1 0 0 15 0 6      
4733 ewingbo01 1912 1 SLN NL 0 0 1 1 0 0 0 4 2 0 0 1 0 0.33 0.0   0 0 0 7 0 0      
4742 gallibe01 1912 1 WS1 AL 0 0 2 0 0 0 0 6 0 0 0 3 0 0.0 0.0   0 0 0 9 1 0      
4743 gardnha01 1912 1 PIT NL 0 0 1 0 0 0 0 1 3 0 0 1 0 0.5 0.0   0 0 0 7 0 6      
4758 harresl01 1912 1 PHA AL 0 0 1 0 0 0 0 9 4 0 0 0 1 0.36 0.0   0 0 0 11 1 0      
4761 herrihe01 1912 1 WS1 AL 0 0 1 0 0 0 0 3 1 0 0 1 0 0.25 0.0   0 0 0 5 1 0      
4804 mcgehpa01 1912 1 DET AL 0 0 1 1 0 0 0 0 1 0 0 1 0 1.0     0 0 0 2 0 0      
4819 neherji01 1912 1 CLE AL 0 0 1 0 0 0 0 3 0 0 0 0 0 0.0 0.0   0 0 0 3 1 0      
4852 schaege01 1912 1 WS1 AL 0 0 1 0 0 0 0 2 1 0 0 0 0 0.33 0.0   0 0 0 3 0 0      
4867 spencha01 1912 1 SLA AL 0 0 1 0 0 0 0 5 2 0 0 0 0 0.28 0.0   0 0 0 7 1 2      
4877 tompkch01 1912 1 CIN NL 0 0 1 0 0 0 0 9 5 0 0 0 1 0.35 0.0   0 0 0 14 1 1      
4887 walkemy01 1912 1 CLE AL 0 0 1 0 0 0 0 3 0 0 0 1 0 0.0 0.0   1 0 0 5 1 0      
4888 walkero01 1912 1 CLE AL 0 0 1 0 0 0 0 6 0 0 0 2 1 0.0 0.0   0 0 0 8 1 0      
4889 wallahu01 1912 1 PHI NL 0 0 4 0 0 0 0 14 7 0 0 4 4 0.35 0.0   1 0 0 24 3 5      
4896 whitest01 1912 1 WS1 AL 0 0 1 0 0 0 0 2 2 0 1 0 1 0.66 0.0   1 0 0 3 0 2      
4923 bentlja01 1913 1 WS1 AL 1 0 3 1 0 0 1 33 5 0 0 2 5 0.14 0.0   1 1 0 31 1 0      
4966 dawsore01 1913 1 WS1 AL 0 0 1 0 0 0 0 3 1 0 0 0 1 0.25 0.0   0 0 0 4 0 0      
4985 gedeojo01 1913 1 WS1 AL 0 0 1 0 0 0 1 1 0 0 0 0 0 0.0 0.0   0 0 0 1 1 0      
4991 griffcl01 1913 1 WS1 AL 0 0 1 0 0 0 0 3 1 0 0 0 0 0.25 0.0   0 0 0 4 0 0      
5008 hedgpha01 1913 1 WS1 AL 0 0 1 0 0 0 1 3 1 0 0 0 0 0.25 0.0   0 0 0 4 1 0      
5012 hoffch01 1913 1 NYA AL 0 0 2 0 0 0 0 9 0 0 0 1 2 0.0 0.0   0 0 0 9 1 0      
5013 hoopeha01 1913 1 BOS AL 0 0 1 0 0 0 0 6 2 0 0 1 0 0.33 0.0   0 0 0 7 0 0      
5030 koneted01 1913 1 SLN NL 1 0 1 0 0 0 0 14 1 0 0 4 3 0.07 0.0   0 0 0 18 1 0      
5082 powelja02 1913 1 SLA AL 0 0 2 0 0 0 0 6 1 0 0 2 0 0.14 0.0   0 0 0 9 2 3      
5105 scoggji01 1913 1 CHA AL 0 1 1 1 0 0 0 0 0 0 0 1 0 0.0     0 0 0 2 0 1      
5145 zabelzi01 1913 1 CHN NL 1 0 1 1 0 0 0 15 3 0 0 1 0 0.16 0.0   0 1 0 19 0 0      
5156 altroni01 1914 1 WS1 AL 0 0 1 0 0 0 0 3 3 0 0 0 0 0.75 0.0   0 0 0 5 1 0      
5163 barrofr02 1914 1 WS1 AL 0 0 1 0 0 0 0 3 1 0 0 0 1 0.33 0.0   0 0 0 3 1 0      
5166 beckge01 1914 1 CLE AL 0 0 1 0 0 0 0 3 1 0 0 0 0 0.25 0.0   0 1 0 5 1 0      
5169 bennhe01 1914 1 CLE AL 0 0 1 0 0 0 0 3 0 0 0 0 1 0.0 0.0   0 0 0 3 1 0      
5232 ericker01 1914 1 NY1 NL 0 1 1 1 0 0 0 15 8 0 0 3 3 0.36 0.0   0 0 0 28 0 7      
5246 griffcl01 1914 1 WS1 AL 0 0 1 0 0 0 1 3 1 0 0 0 1 0.25 0.0   0 0 0 4 1 0      
5294 kellyed01 1914 1 BOS AL 0 0 3 0 0 0 0 7 1 0 0 1 4 0.1 0.0   0 0 0 11 3 1      
5320 mcartdi01 1914 1 PIT NL 0 0 1 0 0 0 0 3 1 0 0 0 1 0.25 0.0   0 0 0 4 1 0      
5324 mcgrajo02 1914 1 BRF FL 0 0 1 0 0 0 0 6 0 0 0 0 2 9.99 0.0   0 1 0 0 0 0      
5379 shermda01 1914 1 CHF FL 0 1 1 1 0 0 0 1 0 0 0 2 0 9.99 0.0   0 0 0 0 0 2      
5395 swandu01 1914 1 KCF FL 0 0 1 0 0 0 0 3 0 0 0 1 1 9.99 0.0   0 0 0 0 1 0      
5415 willile01 1914 1 DET AL 0 1 1 1 0 0 0 3 3 0 0 2 0 0.42 0.0   0 0 0 9 0 5      
5466 braital01 1915 1 PTF FL 0 0 2 0 0 0 0 9 0 0 0 0 2 9.99 0.0   0 0 0 0 1 0      
5499 coopegu01 1915 1 BOS AL 0 0 1 0 0 0 0 6 0 0 0 2 0 0.0 0.0   0 0 0 7 1 0      
5513 davisdi01 1915 1 CHA AL 0 0 2 0 0 0 0 9 2 0 0 2 2 0.25 0.0   0 1 0 11 2 0      
5552 harribe02 1915 1 KCF FL 0 0 1 0 0 0 0 6 1 0 0 0 0 9.99 0.0   0 0 0 0 1 0      
5562 hillhe01 1915 1 CLE AL 0 0 1 0 0 0 0 6 1 0 0 2 0 0.25 0.0   0 0 0 6 0 0      
5598 ledbera01 1915 1 DET AL 0 0 1 0 0 0 0 3 1 0 0 0 0 0.33 0.0   0 0 0 3 1 0      
5614 mayersa01 1915 1 WS1 AL 0 0 1 0 0 0 0 0 0 0 0 2 0 0.0     0 0 0 2 0 0      
5626 miljujo01 1915 1 PTF FL 0 0 1 0 0 0 0 3 1 0 0 0 0 9.99 0.0   0 0 0 0 1 0      
5634 myersel01 1915 1 PHA AL 1 0 1 1 1 1 0 27 2 0 0 5 12 0.07 0.0   0 0 0 32 0 0      
5693 slattph01 1915 1 PIT NL 0 0 3 0 0 0 0 24 5 0 0 1 1 0.18 0.0   0 2 0 31 3 0      
5727 whitegi01 1915 1 NEW FL 0 0 1 0 0 0 0 3 0 0 0 1 0 9.99 0.0   0 0 0 0 1 0      
5728 wilheka01 1915 1 BLF FL 0 0 1 0 0 0 0 3 0 0 0 0 0 9.99 0.0   0 0 0 0 0 0      
5752 bentlja01 1916 1 WS1 AL 0 0 2 0 0 0 0 4 0 0 0 1 1 0.0 0.0   0 0 0 4 0 0      
5766 cantwmi01 1916 1 NYA AL 0 0 1 0 0 0 0 6 0 0 0 2 0 0.0 0.0   0 0 0 6 0 2      
5791 donovbi01 1916 1 NYA AL 0 0 1 0 0 0 0 3 1 0 0 1 0 0.25 0.0   0 0 0 5 1 0      

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